public function prepare_items()
{
global $wpdb, $per_page;
$per_page = $this->get_items_per_page('formidable_page_formidable_entries_per_page');
$form_id = $this->params['form'];
if (!$form_id) {
$this->items = array();
$this->set_pagination_args(array('total_items' => 0, 'per_page' => $per_page));
return;
}
$default_orderby = 'id';
$default_order = 'DESC';
$s_query = array('it.form_id' => $form_id);
$s = isset($_REQUEST['s']) ? stripslashes($_REQUEST['s']) : '';
if ($s != '' && FrmAppHelper::pro_is_installed()) {
$fid = isset($_REQUEST['fid']) ? sanitize_title($_REQUEST['fid']) : '';
$s_query = FrmProEntriesHelper::get_search_str($s_query, $s, $form_id, $fid);
}
$orderby = isset($_REQUEST['orderby']) ? sanitize_title($_REQUEST['orderby']) : $default_orderby;
if (strpos($orderby, 'meta') !== false) {
$order_field_type = FrmField::get_type(str_replace('meta_', '', $orderby));
$orderby .= in_array($order_field_type, array('number', 'scale')) ? ' +0 ' : '';
}
$order = isset($_REQUEST['order']) ? sanitize_title($_REQUEST['order']) : $default_order;
$order = ' ORDER BY ' . $orderby . ' ' . $order;
$page = $this->get_pagenum();
$start = (int) isset($_REQUEST['start']) ? absint($_REQUEST['start']) : ($page - 1) * $per_page;
$this->items = FrmEntry::getAll($s_query, $order, ' LIMIT ' . $start . ',' . $per_page, true, false);
$total_items = FrmEntry::getRecordCount($s_query);
$this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page));
}
public static function get_search_str($where_clause = '', $search_str, $form_id = false, $fid = false)
{
_deprecated_function(__FUNCTION__, '2.0', 'FrmProEntriesHelper::get_search_str');
return FrmProEntriesHelper::get_search_str($where_clause, $search_str, $form_id, $fid);
}
