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
//******************************************************************
//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('View eval hdr');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require 'form_data_eval_hdr.php';
}
if (xsrf_guard()) {
init_var($_POST['btn_back']);
if ($_POST['btn_back']) {
log_action('Pressed cancel button');
require 'components/query_string_standard.php';
redirect("listview_eval_hdr.php?{$query_string}");
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('Detail View: Eval Hdr', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->detail_view = TRUE;
$html->draw_controls('view');
$html->draw_footer();
$csv_name = $token . $_SESSION['user'] . '_eval_hdr_' . $timestamp . '.csv';
$filename = TMP_DIRECTORY . '/' . $csv_name;
$csv_contents = $dbh_eval_hdr->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';
}
}
}
require 'subclasses/eval_hdr_html.php';
$html = new eval_hdr_html();
$html->draw_header('CSV Exporter: Eval Hdr', $message, $message_type);
echo '<div class="container">';
echo '<fieldset class="container_invisible">';
$html->draw_fieldset_header('Table Data to CSV Export');
$html->draw_fieldset_body_start();
echo '<tr><td>';
$html->display_info('Exporting data to CSV will let you have an offline backup of this module.');
$html->display_tip('Your system admin can use this CSV file to restore data for this module in case of catastrophic data loss on the server.');
echo '</td></tr>';
$html->draw_fieldset_body_end();
$html->draw_fieldset_footer_start();
$html->draw_submit_cancel();
$html->draw_fieldset_footer_end();
echo '</fieldset>';
echo '</div>';
$html->draw_footer();
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');
$html->draw_footer();
$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";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
//echo "Connected to MySQL<br>";
//select a database to work with
$selected = mysql_select_db("apc-cpo", $dbhandle) or die("Could not select examples");
//execute the SQL query and return records
$result = mysql_query("SELECT count(question) as count FROM questionnaire WHERE type = 'Resume'");
$questions = mysql_query("SELECT question,id FROM questionnaire WHERE type = 'Resume'");
//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {
$i = $row['count'];