$id = urldecode($_GET['id']);
require_once 'form_data_final_paper_hdr.php';
}
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_delete']);
require 'components/query_string_standard.php';
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button');
redirect("listview_final_paper_hdr.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button');
require_once 'subclasses/final_paper_hdr.php';
$dbh_final_paper_hdr = new final_paper_hdr();
$object_name = 'dbh_final_paper_hdr';
require 'components/create_form_data.php';
$dbh_final_paper_hdr->delete($arr_form_data);
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
$dbh_final_paper_hdr->delete_many($arr_form_data);
redirect("listview_final_paper_hdr.php?{$query_string}");
}
}
require 'subclasses/final_paper_hdr_html.php';
$html = new final_paper_hdr_html();
$html->draw_header('Delete Final Paper Hdr', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();
//framework developed by JV Roig (jvroig@jvroig.com).
//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('Edit final paper dtl');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require 'form_data_final_paper_dtl.php';
}
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
require 'components/query_string_standard.php';
require 'subclasses/final_paper_dtl.php';
$dbh_final_paper_dtl = new final_paper_dtl();
$object_name = 'dbh_final_paper_dtl';
require 'components/create_form_data.php';
extract($arr_form_data);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button');
redirect("listview_final_paper_dtl.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_final_paper_dtl->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_final_paper_dtl->check_uniqueness_for_editing($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
log_action('Pressed cancel button');
redirect("listview_final_paper_hdr.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_final_paper_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_final_paper_hdr->check_uniqueness_for_editing($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
}
if ($message == "") {
$dbh_final_paper_hdr->edit($arr_form_data);
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
$dbh_final_paper_hdr->delete_many($arr_form_data);
for ($a = 0; $a < $final_paper_dtl_count; $a++) {
$param = array('final_paper_hdr_id' => $id, 'questionnaire_id' => $cf_final_paper_dtl_questionnaire_id[$a], 'response' => $cf_final_paper_dtl_response[$a]);
$dbh_final_paper_hdr->add($param);
}
redirect("listview_final_paper_hdr.php?{$query_string}");
}
}
}
require 'subclasses/final_paper_hdr_html.php';
$html = new final_paper_hdr_html();
$html->draw_header('Edit Final Paper Hdr', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('id');
$html->draw_controls('edit');
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
$file_upload_control_name = 'attachment';
require 'components/upload_generic.php';
$message .= $dbh_final_paper_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_final_paper_hdr->check_uniqueness($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
}
if ($message == "") {
$dbh_final_paper_hdr->add($arr_form_data);
$id = $dbh_final_paper_hdr->auto_id;
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
for ($a = 0; $a < $final_paper_dtl_count; $a++) {
$param = array('id' => $id, 'final_paper_hdr_id' => $id, 'questionnaire_id' => $cf_final_paper_dtl_questionnaire_id[$a], 'response' => $cf_final_paper_dtl_response[$a]);
$dbh_final_paper_hdr->add($param);
}
redirect("listview_final_paper_hdr.php?{$query_string}");
}
}
}
require 'subclasses/final_paper_hdr_html.php';
$html = new final_paper_hdr_html();
$html->draw_header('Add Final Paper Hdr', $message, $message_type, TRUE, TRUE);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_controls('add');
$html->draw_footer();
require 'path.php';
init_cobalt('Delete final paper dtl');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require_once 'form_data_final_paper_dtl.php';
}
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_delete']);
require 'components/query_string_standard.php';
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button');
redirect("listview_final_paper_dtl.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button');
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_dtl = new final_paper_dtl();
$object_name = 'dbh_final_paper_dtl';
require 'components/create_form_data.php';
$dbh_final_paper_dtl->delete($arr_form_data);
redirect("listview_final_paper_dtl.php?{$query_string}");
}
}
require 'subclasses/final_paper_dtl_html.php';
$html = new final_paper_dtl_html();
$html->draw_header('Delete Final Paper Dtl', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();
<?php
require 'components/get_listview_referrer.php';
require 'subclasses/final_paper_hdr.php';
$dbh_final_paper_hdr = new final_paper_hdr();
$dbh_final_paper_hdr->set_where("id='" . quote_smart($id) . "'");
if ($result = $dbh_final_paper_hdr->make_query()->result) {
$data = $result->fetch_assoc();
extract($data);
$data = explode('-', $date_submitted);
$date_submitted_year = $data[0];
$date_submitted_month = $data[1];
$date_submitted_day = $data[2];
$data = explode('-', $rcv_date);
$rcv_date_year = $data[0];
$rcv_date_month = $data[1];
$rcv_date_day = $data[2];
}
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
$dbh_final_paper_hdr->set_fields('questionnaire_id, response');
$dbh_final_paper_hdr->set_where("id='" . quote_smart($id) . "' AND final_paper_hdr_id='" . quote_smart($id) . "'");
if ($result = $dbh_final_paper_hdr->make_query()->result) {
$num_final_paper_dtl = $dbh_final_paper_hdr->num_rows;
for ($a = 0; $a < $num_final_paper_dtl; $a++) {
$data = $result->fetch_row();
$cf_final_paper_dtl_questionnaire_id[$a] = $data[0];
$cf_final_paper_dtl_response[$a] = $data[1];
}
}
}
$file_upload_control_name = 'attachment';
require 'components/upload_generic.php';
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_final_paper_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_final_paper_hdr->check_uniqueness_for_editing($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
}
if ($message == "") {
$dbh_final_paper_hdr->edit($arr_form_data);
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
//$dbh_final_paper_hdr->delete_many($arr_form_data);
$dbh_final_paper_hdr->delete_data($id);
for ($a = 0; $a < $final_paper_dtl_count; $a++) {
$param = array('final_paper_hdr_id' => $id, 'questionnaire_id' => $cf_final_paper_dtl_questionnaire_id[$a], 'response' => $cf_final_paper_dtl_response[$a]);
$dbh_final_paper_hdr->add($param);
}
redirect("listview_final_paper_hdr.php?{$query_string}");
}
}
}
require 'subclasses/final_paper_hdr_html.php';
$html = new final_paper_hdr_html();
$html->draw_header('Edit Final Paper Hdr', $message, $message_type, TRUE, TRUE);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('id');
<?php
require 'components/get_listview_referrer.php';
require 'subclasses/final_paper_dtl.php';
$dbh_final_paper_dtl = new final_paper_dtl();
$dbh_final_paper_dtl->set_where("id='" . quote_smart($id) . "'");
if ($result = $dbh_final_paper_dtl->make_query()->result) {
$data = $result->fetch_assoc();
extract($data);
}
//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('View final paper dtl');
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button', $_SERVER['PHP_SELF']);
redirect("listview_final_paper_dtl.php");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
require 'subclasses/final_paper_dtl.php';
$dbh_final_paper_dtl = new final_paper_dtl();
if ($message == "") {
log_action("Exported table data to CSV", $_SERVER['PHP_SELF']);
$timestamp = date('Y-m-d');
$token = generate_token(0, 'fs');
$csv_name = $token . $_SESSION['user'] . '_final_paper_dtl_' . $timestamp . '.csv';
$filename = TMP_DIRECTORY . '/' . $csv_name;
$csv_contents = $dbh_final_paper_dtl->export_to_csv();
$csv_file = fopen($filename, "wb");
fwrite($csv_file, $csv_contents);
fclose($csv_file);
chmod($filename, 0755);
$csv_name = urlencode($csv_name);
$message = 'CSV file successfully generated: <a href="/' . BASE_DIRECTORY . '/download_generic.php?filename=' . $csv_name . '">Download the CSV file.</a>';
$message_type = 'system';
}
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require_once 'form_data_final_paper_hdr.php';
} elseif (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_delete']);
require 'components/query_string_standard.php';
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button', $_SERVER['PHP_SELF']);
redirect("listview_final_paper_hdr.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button', $_SERVER['PHP_SELF']);
require_once 'subclasses/final_paper_hdr.php';
$dbh_final_paper_hdr = new final_paper_hdr();
$object_name = 'dbh_final_paper_hdr';
require 'components/create_form_data.php';
$dbh_final_paper_hdr->del($arr_form_data);
require_once 'subclasses/final_paper_dtl.php';
$dbh_final_paper_hdr = new final_paper_dtl();
$dbh_final_paper_hdr->del($arr_form_data);
redirect("listview_final_paper_hdr.php?{$query_string}");
}
}
require 'subclasses/final_paper_hdr_html.php';
$html = new final_paper_hdr_html();
$html->draw_header('Delete Final Paper Hdr', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();