// 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;
}
