/// 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':
