if (count($data) == 3) {
$date_eval_year = $data[0];
$date_eval_month = $data[1];
$date_eval_day = $data[2];
}
$data = explode('-', $date_discussed);
if (count($data) == 3) {
$date_discussed_year = $data[0];
$date_discussed_month = $data[1];
$date_discussed_day = $data[2];
}
$data = explode('-', $rcv_date);
if (count($data) == 3) {
$rcv_date_year = $data[0];
$rcv_date_month = $data[1];
$rcv_date_day = $data[2];
}
}
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
$dbh_eval_hdr->set_fields('questionnaire_id, response_rating, response_detail');
$dbh_eval_hdr->set_where("eval_hdr_id='" . quote_smart($id) . "'");
if ($result = $dbh_eval_hdr->make_query()->result) {
$num_eval_dtl = $dbh_eval_hdr->num_rows;
for ($a = 0; $a < $num_eval_dtl; $a++) {
$data = $result->fetch_row();
$cf_eval_dtl_questionnaire_id[$a] = $data[0];
$cf_eval_dtl_response_rating[$a] = $data[1];
$cf_eval_dtl_response_detail[$a] = $data[2];
}
}
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require_once 'form_data_eval_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_eval_hdr.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button', $_SERVER['PHP_SELF']);
require_once 'subclasses/eval_hdr.php';
$dbh_eval_hdr = new eval_hdr();
$object_name = 'dbh_eval_hdr';
require 'components/create_form_data.php';
$dbh_eval_hdr->del($arr_form_data);
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
$dbh_eval_hdr->del($arr_form_data);
redirect("listview_eval_hdr.php?{$query_string}");
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Delete Eval 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();
<?php
require 'components/get_listview_referrer.php';
require 'subclasses/eval_dtl.php';
$dbh_eval_dtl = new eval_dtl();
$dbh_eval_dtl->set_where("id='" . quote_smart($id) . "'");
if ($result = $dbh_eval_dtl->make_query()->result) {
$data = $result->fetch_assoc();
extract($data);
}
require 'path.php';
init_cobalt('Delete eval dtl');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require_once 'form_data_eval_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_eval_dtl.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button');
require_once 'subclasses/eval_dtl.php';
$dbh_eval_dtl = new eval_dtl();
$object_name = 'dbh_eval_dtl';
require 'components/create_form_data.php';
$dbh_eval_dtl->delete($arr_form_data);
redirect("listview_eval_dtl.php?{$query_string}");
}
}
require 'subclasses/eval_dtl_html.php';
$html = new eval_dtl_html();
$html->draw_header('Delete Eval 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();
//This file was generated by Cobalt, a rapid application development
//framework developed by JV Roig (jvroig@jvroig.com).
//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('Edit eval dtl');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require 'form_data_eval_dtl.php';
} elseif (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
require 'components/query_string_standard.php';
require 'subclasses/eval_dtl.php';
$dbh_eval_dtl = new eval_dtl();
$object_name = 'dbh_eval_dtl';
require 'components/create_form_data.php';
extract($arr_form_data);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button', $_SERVER['PHP_SELF']);
redirect("listview_eval_dtl.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
$message .= $dbh_eval_dtl->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_eval_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!";
//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('View eval 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_eval_dtl.php");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
require 'subclasses/eval_dtl.php';
$dbh_eval_dtl = new eval_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'] . '_eval_dtl_' . $timestamp . '.csv';
$filename = TMP_DIRECTORY . '/' . $csv_name;
$csv_contents = $dbh_eval_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';
}
log_action('Pressed cancel button', $_SERVER['PHP_SELF']);
redirect("listview_eval_hdr.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
$message .= $dbh_eval_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_eval_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_eval_hdr->edit($arr_form_data);
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
$dbh_eval_hdr->del($arr_form_data);
for ($a = 0; $a < $eval_dtl_count; $a++) {
$param = array('id' => $id, 'questionnaire_id' => $cf_eval_dtl_questionnaire_id[$a], 'eval_hdr_id' => $id, 'response_rating' => $cf_eval_dtl_response_rating[$a], 'response_detail' => $cf_eval_dtl_response_detail[$a]);
$dbh_eval_hdr->add($param);
}
redirect("listview_eval_hdr.php?{$query_string}");
}
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Edit Eval 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']);
$message .= $dbh_eval_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_eval_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_eval_hdr->add($arr_form_data);
$id = $dbh_eval_hdr->auto_id;
$idd = $dbh_eval_dtl->auto_id;
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
for ($a = 0; $a < $eval_dtl_count; $a++) {
$param = array('id' => $idd, 'questionnaire_id' => $cf_eval_dtl_questionnaire_id[$a], 'eval_hdr_id' => $id, 'response_rating' => $cf_eval_dtl_response_rating[$a], 'response_detail' => $cf_eval_dtl_response_detail[$a]);
$dbh_eval_hdr->add($param);
}
redirect("listview_eval_hdr.php?{$query_string}");
}
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Add Eval Hdr', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$username = "******";
$password = "";
$hostname = "localhost";
log_action('Pressed cancel button');
redirect("listview_eval_hdr.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_eval_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_eval_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_eval_hdr->edit($arr_form_data);
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
//$dbh_eval_hdr->delete_many($arr_form_data);
$dbh_eval_hdr->delete_data($id);
for ($a = 0; $a < $eval_dtl_count; $a++) {
$param = array('questionnaire_id' => $cf_eval_dtl_questionnaire_id[$a], 'eval_hdr_id' => $id, 'response_rating' => $cf_eval_dtl_response_rating[$a], 'response_detail' => $cf_eval_dtl_response_detail[$a]);
$dbh_eval_hdr->add($param);
}
redirect("listview_eval_hdr.php?{$query_string}");
}
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Edit Eval 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');
$id = urldecode($_GET['id']);
require_once 'form_data_eval_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_eval_hdr.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button');
require_once 'subclasses/eval_hdr.php';
$dbh_eval_hdr = new eval_hdr();
$object_name = 'dbh_eval_hdr';
require 'components/create_form_data.php';
$dbh_eval_hdr->delete($arr_form_data);
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
$dbh_eval_hdr->delete_many($arr_form_data);
redirect("listview_eval_hdr.php?{$query_string}");
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Delete Eval 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();
log_action('Pressed cancel button');
redirect("listview_eval_hdr.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_eval_hdr->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_eval_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_eval_hdr->edit($arr_form_data);
require_once 'subclasses/eval_dtl.php';
$dbh_eval_hdr = new eval_dtl();
$dbh_eval_hdr->delete_many($arr_form_data);
for ($a = 0; $a < $eval_dtl_count; $a++) {
$param = array('questionnaire_id' => $cf_eval_dtl_questionnaire_id[$a], 'eval_hdr_id' => $id, 'response_rating' => $cf_eval_dtl_response_rating[$a], 'response_detail' => $cf_eval_dtl_response_detail[$a]);
$dbh_eval_hdr->add($param);
}
redirect("listview_eval_hdr.php?{$query_string}");
}
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Edit Eval 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');
