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