/// build the query $dataPerPage = isset($_POST['fm-data-per-page']) ? sanitize_text_field($_POST['fm-data-per-page']) : 30; $dataSortBy = isset($_POST['fm-data-sort-by']) ? sanitize_text_field($_POST['fm-data-sort-by']) : 'timestamp'; if (trim($dataSortBy) == "") { $dataSortBy = 'timestamp'; } $dataSortOrder = isset($_POST['fm-data-sort-order']) && $_POST['fm-data-sort-order'] == 'asc' ? 'ASC' : 'DESC'; $dataCurrentPage = isset($_POST['fm-data-current-page']) ? sanitize_text_field($_POST['fm-data-current-page']) : 1; $dataQuery = "SELECT `unique_id`, " . fm_getColQueryList($cols) . " FROM `" . $form['data_table'] . "` "; $allQuery = $dataQuery; $countQuery = "SELECT COUNT(*) as cnt FROM `" . $form['data_table'] . "` "; $queryClauses = array(); // search if (isset($_POST['fm-data-search']) && !trim($_POST['fm-data-search']) == "") { $searchColumn = sanitize_text_field($_POST['fm-data-search-column']); $colID = fm_getSafeColKey($searchColumn, $cols); if ($colID !== false) { $fmDataSearch = sanitize_text_field($_POST['fm-data-search']); $queryClauses[] = $wpdb->prepare("`" . $colID . "` LIKE %s ", "%" . $fmDataSearch . "%"); } } //date range $fmDataDateRange = isset($_POST['fm-data-date-range']) ? $_POST['fm-data-date-range'] : ""; switch ($fmDataDateRange) { case 'month': $queryClauses[] = "MONTH(`timestamp`) = MONTH(CURDATE())"; $queryMessage = __("Showing data for the current month", 'wordpress-form-manager'); break; case 'week': $queryClauses[] = "`timestamp` > DATE_SUB(CURDATE(), INTERVAL 7 DAY)"; $queryMessage = __("Showing data from the past seven days", 'wordpress-form-manager');
} /// build the query $dataPerPage = isset($_POST['fm-data-per-page']) ? $_POST['fm-data-per-page'] : 30; $dataSortBy = isset($_POST['fm-data-sort-by']) ? $_POST['fm-data-sort-by'] : 'timestamp'; if (trim($dataSortBy) == "") { $dataSortBy = 'timestamp'; } $dataSortOrder = $_POST['fm-data-sort-order'] == 'asc' ? 'ASC' : 'DESC'; $dataCurrentPage = isset($_POST['fm-data-current-page']) ? $_POST['fm-data-current-page'] : 1; $dataQuery = "SELECT `unique_id`, " . fm_getColQueryList($cols) . " FROM `" . $form['data_table'] . "` "; $allQuery = $dataQuery; $countQuery = "SELECT COUNT(*) as cnt FROM `" . $form['data_table'] . "` "; $queryClauses = array(); // search if (!trim($_POST['fm-data-search']) == "") { $colID = fm_getSafeColKey($_POST['fm-data-search-column'], $cols); if ($colID !== false) { $queryClauses[] = $wpdb->prepare("`" . $colID . "` LIKE %s ", "%" . $_POST['fm-data-search'] . "%"); } } //date range switch ($_POST['fm-data-date-range']) { case 'month': $queryClauses[] = "MONTH(`timestamp`) = MONTH(CURDATE())"; $queryMessage = __("Showing data for the current month", 'wordpress-form-manager'); break; case 'week': $queryClauses[] = "`timestamp` > DATE_SUB(CURDATE(), INTERVAL 7 DAY)"; $queryMessage = __("Showing data from the past seven days", 'wordpress-form-manager'); break; case 'today':