// Order by FLBuilder::render_settings_field('order_by', array('type' => 'select', 'label' => __('Order By', 'fl-builder'), 'options' => array('ID' => __('ID', 'fl-builder'), 'date' => __('Date', 'fl-builder'), 'modified' => __('Date Last Modified', 'fl-builder'), 'title' => __('Title', 'fl-builder'), 'author' => __('Author', 'fl-builder'), 'comment_count' => __('Comment Count', 'fl-builder'), 'menu_order' => __('Menu Order', 'fl-builder'), 'rand' => __('Random', 'fl-builder'))), $settings); // Order FLBuilder::render_settings_field('order', array('type' => 'select', 'label' => __('Order', 'fl-builder'), 'options' => array('DESC' => __('Descending', 'fl-builder'), 'ASC' => __('Ascending', 'fl-builder'))), $settings); // Offset FLBuilder::render_settings_field('offset', array('type' => 'text', 'label' => _x('Offset', 'How many posts to skip.', 'fl-builder'), 'default' => '0', 'size' => '4', 'help' => __('Skip this many posts that match the specified criteria.', 'fl-builder')), $settings); ?> </table> </div> <div id="fl-builder-settings-section-filter" class="fl-builder-settings-section"> <h3 class="fl-builder-settings-title"><?php _e('Filter', 'fl-builder'); ?> </h3> <?php foreach (FLBuilderLoop::post_types() as $slug => $type) { ?> <table class="fl-form-table fl-loop-builder-filter fl-loop-builder-<?php echo $slug; ?> -filter" <?php if ($slug == $settings->post_type) { echo 'style="display:table;"'; } ?> > <?php // Posts FLBuilder::render_settings_field('posts_' . $slug, array('type' => 'suggest', 'action' => 'fl_as_posts', 'data' => $slug, 'label' => $type->label, 'help' => sprintf(__('Enter a comma separated list of %s. Only these %s will be shown.', 'fl-builder'), $type->label, $type->label)), $settings); // Taxonomies $taxonomies = FLBuilderLoop::taxonomies($slug);
/** * Returns data for link auto suggest queries. * * @since 1.3.9 * @return array */ public static function links() { global $wpdb; $data = array(); $like = self::get_like(); $types = FLBuilderLoop::post_types(); $slugs = array(); foreach ($types as $slug => $type) { $slugs[] = esc_sql($slug); } $posts = $wpdb->get_results("\n\t\t\tSELECT ID, post_title FROM {$wpdb->posts} \n\t\t\tWHERE post_title LIKE '%{$like}%'\n\t\t\tAND post_type IN ('" . implode("','", $slugs) . "')\n\t\t\tAND post_status = 'publish'\n\t\t"); foreach ($posts as $post) { $data[] = array('name' => $post->post_title, 'value' => get_permalink($post->ID)); } return $data; }