BP_Document: get (数组args美元＝数组()）

公共静态函数get（$ args = array（））{global $ wpdb;$ bp = buddypress（）;$ r = wp_parse_args（$ args，array（'scope' =>''，//范围 - 组，朋友等'页'=> 1，//当前页面。'per_page'=> 20，//文档每页的项目。'max'=> false，//返回的最多项目数。'字段'=>'全部'，//字段包含。'sort' =>'desc'，// ASC或DESC。'order_by'=>'date_created'，//列订购。'排除'=> false，// ID数组排除。'In'=> False，// ID数组以（IN）限制查询。'search_terms' => false, // Terms to search by. 'privacy' => false, // public, loggedin, onlyme, friends, grouponly, message. 'count_total' => false, // Whether or not to use count_total. 'folder_id' => false, 'folder' => true, 'user_directory' => true, 'meta_query' => false, // Filter by document meta. ) ); // Select conditions. $select_sql = 'SELECT DISTINCT d.id'; $from_sql = " FROM {$bp->document->table_name} d"; $join_sql = ''; // Where conditions. $where_conditions = array(); if ( ! empty( $r['scope'] ) ) { $scope_query = self::get_scope_query_sql( $r['scope'], $r ); // Override some arguments if needed. if ( ! empty( $scope_query['override'] ) ) { $r = array_replace_recursive( $r, $scope_query['override'] ); } } // Searching. if ( $r['search_terms'] ) { $search_terms_like = '%' . bp_esc_like( $r['search_terms'] ) . '%'; $where_conditions['search_sql'] = $wpdb->prepare( 'd.title LIKE %s', $search_terms_like ); /** * Filters whether or not to include users for search parameters. * * @param bool $value Whether or not to include user search. Default false. * * @since BuddyBoss 1.4.0 */ if ( apply_filters( 'bp_document_get_include_user_search', false ) ) { $user_search = get_user_by( 'slug', $r['search_terms'] ); if ( false !== $user_search ) { $user_id = $user_search->ID; $where_conditions['search_sql'] .= $wpdb->prepare( ' OR d.user_id = %d', $user_id ); } } } // Sorting. $sort = $r['sort']; if ( $sort !== 'ASC' && $sort !== 'DESC' ) { $sort = 'DESC'; } switch ( $r['order_by'] ) { case 'id': case 'user_id': case 'blog_id': case 'attachment_id': case 'title': case 'folder': case 'folder_id': case 'activity_id': case 'group_id': case 'menu_order': break; default: $r['order_by'] = 'date_created'; break; } $order_by = 'd.' . $r['order_by']; // Exclude specified items. if ( ! empty( $r['exclude'] ) ) { $exclude = implode( ',', wp_parse_id_list( $r['exclude'] ) ); $where_conditions['exclude'] = "d.id NOT IN ({$exclude})"; } // The specific ids to which you want to limit the query. if ( ! empty( $r['in'] ) ) { $in = implode( ',', wp_parse_id_list( $r['in'] ) ); $where_conditions['in'] = "d.id IN ({$in})"; // we want to disable limit query when include document ids. $r['page'] = false; $r['per_page'] = false; } if ( ! empty( $r['activity_id'] ) ) { $where_conditions['activity'] = "d.activity_id = {$r['activity_id']}"; } // existing-document check to query document which has no folders assigned. if ( ! empty( $r['folder_id'] ) && 'existing-document' !== $r['folder_id'] ) { $where_conditions['folder'] = "d.folder_id = {$r['folder_id']}"; } elseif ( ! empty( $r['folder_id'] ) && 'existing-document' === $r['folder_id'] ) { $where_conditions['folder'] = 'd.folder_id = 0'; } if ( ! empty( $r['user_id'] ) ) { $where_conditions['user'] = "d.user_id = {$r['user_id']}"; } if ( ! empty( $r['group_id'] ) ) { $where_conditions['user'] = "d.group_id = {$r['group_id']}"; } if ( ! empty( $r['privacy'] ) ) { $privacy = "'" . implode( "', '", $r['privacy'] ) . "'"; $where_conditions['privacy'] = "d.privacy IN ({$privacy})"; } // Process meta_query into SQL. $meta_query_sql = self::get_meta_query_sql( $r['meta_query'] ); if ( ! empty( $meta_query_sql['join'] ) ) { $join_sql .= $meta_query_sql['join']; } if ( ! empty( $meta_query_sql['where'] ) ) { $where_conditions[] = $meta_query_sql['where']; } /** * Filters the MySQL WHERE conditions for the Document items get method. * * @param array $where_conditions Current conditions for MySQL WHERE statement. * @param array $r Parsed arguments passed into method. * @param string $select_sql Current SELECT MySQL statement at point of execution. * @param string $from_sql Current FROM MySQL statement at point of execution. * @param string $join_sql Current INNER JOIN MySQL statement at point of execution. * * @since BuddyBoss 1.4.0 */ $where_conditions = apply_filters( 'bp_document_get_where_conditions', $where_conditions, $r, $select_sql, $from_sql, $join_sql ); if ( empty( $where_conditions ) ) { $where_conditions['2'] = '2'; } // Join the where conditions together. if ( ! empty( $scope_query['sql'] ) ) { $where_sql = 'WHERE ( ' . join( ' AND ', $where_conditions ) . ' ) OR ( ' . $scope_query['sql'] . ' )'; } else { $where_sql = 'WHERE ' . join( ' AND ', $where_conditions ); } /** * Filter the MySQL JOIN clause for the main document query. * * @param string $join_sql JOIN clause. * @param array $r Method parameters. * @param string $select_sql Current SELECT MySQL statement. * @param string $from_sql Current FROM MySQL statement. * @param string $where_sql Current WHERE MySQL statement. * * @since BuddyBoss 1.4.0 */ $join_sql = apply_filters( 'bp_document_get_join_sql', $join_sql, $r, $select_sql, $from_sql, $where_sql ); // Sanitize page and per_page parameters. $page = absint( $r['page'] ); $per_page = absint( $r['per_page'] ); $retval = array( 'documents' => null, 'total' => null, 'has_more_items' => null, ); // Query first for document IDs. $document_ids_sql = "{$select_sql} {$from_sql} {$join_sql} {$where_sql} ORDER BY {$order_by} {$sort}, d.id {$sort}"; if ( ! empty( $per_page ) && ! empty( $page ) ) { // We query for $per_page + 1 items in order to // populate the has_more_items flag. $document_ids_sql .= $wpdb->prepare( ' LIMIT %d, %d', absint( ( $page - 1 ) * $per_page ), $per_page + 1 ); } /** * Filters the paged document MySQL statement. * * @param string $document_ids_sql MySQL statement used to query for Document IDs. * @param array $r Array of arguments passed into method. * * @since BuddyBoss 1.4.0 */ $document_ids_sql = apply_filters( 'bp_document_paged_activities_sql', $document_ids_sql, $r ); $cache_group = 'bp_document'; $cached = bp_core_get_incremented_cache( $document_ids_sql, $cache_group ); if ( false === $cached ) { $document_ids = $wpdb->get_col( $document_ids_sql ); bp_core_set_incremented_cache( $document_ids_sql, $cache_group, $document_ids ); } else { $document_ids = $cached; } $retval['has_more_items'] = ! empty( $per_page ) && count( $document_ids ) > $per_page; // If we've fetched more than the $per_page value, we // can discard the extra now. if ( ! empty( $per_page ) && count( $document_ids ) === $per_page + 1 ) { array_pop( $document_ids ); } if ( 'ids' === $r['fields'] ) { $documents = array_map( 'intval', $document_ids ); } else { $documents = self::get_document_data( $document_ids ); } if ( 'ids' !== $r['fields'] ) { // Get the fullnames of users so we don't have to query in the loop. // $documents = self::append_user_fullnames( $documents ); // Pre-fetch data associated with document users and other objects. $documents = self::prefetch_object_data( $documents ); } $retval['documents'] = $documents; // If $max is set, only return up to the max results. if ( ! empty( $r['count_total'] ) ) { /** * Filters the total document MySQL statement. * * @param string $value MySQL statement used to query for total documents. * @param string $where_sql MySQL WHERE statement portion. * @param string $sort Sort direction for query. * * @since BuddyBoss 1.4.0 */ $total_documents_sql = apply_filters( 'bp_document_total_documents_sql', "SELECT count(DISTINCT d.id) FROM {$bp->document->table_name} d {$join_sql} {$where_sql}", $where_sql, $sort ); $cached = bp_core_get_incremented_cache( $total_documents_sql, $cache_group ); if ( false === $cached ) { $total_documents = $wpdb->get_var( $total_documents_sql ); bp_core_set_incremented_cache( $total_documents_sql, $cache_group, $total_documents ); } else { $total_documents = $cached; } if ( ! empty( $r['max'] ) ) { if ( (int) $total_documents > (int) $r['max'] ) { $total_documents = $r['max']; } } $retval['total'] = $total_documents; } return $retval; }