break; case 'edit': $fm_showEditRows = true; break; } } ///////////////////////////////////////////////////////////////////////////////////////////// /// HOOK //////////////////////////////////////////////////////////////////////////////////// if (isset($checked)) { do_action('fm_data_process_checked', $checked); } ///////////////////////////////////////////////////////////////////////////////////////////// if (isset($_POST['submit-edit'])) { $checked = fm_getEditItems(); foreach ($checked as $subID) { $newData = fm_getEditPost($subID, $cols); if (sizeof($newData) > 0) { $fmdb->updateDataSubmissionRowByID($form['ID'], $subID, $newData); } } } /// 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;
$queryMessage = ""; $form = null; if ($_REQUEST['id'] != "") { $form = $fmdb->getForm($_REQUEST['id']); } $subMetaFields = $fmdb->getFormItems($_REQUEST['id'], 1); $dbRow = $fmdb->getSubmissionByID($form['ID'], $_REQUEST['sub']); global $fm_dataPageSettings; $fm_dataPageSettings = $fmdb->getDataPageSettings($form['ID']); //////////////////////////////////////////////////////////////////////////////////////// $cols = fm_getDefaultDataCols(); fm_dataBuildTableCols($form, $subMetaFields, $cols); fm_applyColSettings($fm_dataPageSettings, $cols); //////////////////////////////////////////////////////////////////////////////////////// if (isset($_POST['submit-changes']) && (!$fm_MEMBERS_EXISTS || current_user_can('form_manager_data_summary_edit'))) { $postData = fm_getEditPost($_REQUEST['sub'], $cols, true); if (sizeof($postData) > 0) { $fmdb->updateDataSubmissionRowByID($form['ID'], $_REQUEST['sub'], $postData); $dbRow = $fmdb->getSubmissionByID($form['ID'], $_REQUEST['sub']); } } $editMode = false; if (isset($_POST['submit-edit'])) { $editMode = true; } ?> <form enctype="multipart/form-data" name="fm-main-form" id="fm-main-form" action="" method="post"> <input type="hidden" value="<?php echo $form['ID']; ?> " name="form-id" id="form-id"/>