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"/>
