$data = $result->fetch_assoc(); extract($data); $data = explode('-', $date_filed); if (count($data) == 3) { $date_filed_year = $data[0]; $date_filed_month = $data[1]; $date_filed_day = $data[2]; } $data = explode('-', $date_served); if (count($data) == 3) { $date_served_year = $data[0]; $date_served_month = $data[1]; $date_served_day = $data[2]; } } require_once 'subclasses/request_has_requirement.php'; $dbh_request = new request_has_requirement(); $dbh_request->set_fields('date_submitted, requirement_document, status'); $dbh_request->set_where("request_id='" . quote_smart($request_id) . "'"); if ($result = $dbh_request->make_query()->result) { $num_request_has_requirement = $dbh_request->num_rows; for ($a = 0; $a < $num_request_has_requirement; $a++) { $data = $result->fetch_row(); $data_temp_cf_date = explode('-', $data[0]); $cf_request_has_requirement_date_submitted_year[$a] = $data_temp_cf_date[0]; $cf_request_has_requirement_date_submitted_month[$a] = $data_temp_cf_date[1]; $cf_request_has_requirement_date_submitted_day[$a] = $data_temp_cf_date[2]; $cf_request_has_requirement_requirement_document[$a] = $data[1]; $cf_request_has_requirement_status[$a] = $data[2]; } }
//**************************************************************************************** //Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com //Cobalt developed by JV Roig (jvroig@jvroig.com) //**************************************************************************************** require 'path.php'; init_cobalt('Edit request has requirement'); if (isset($_GET['request_has_requirement_id'])) { $request_has_requirement_id = urldecode($_GET['request_has_requirement_id']); require 'form_data_request_has_requirement.php'; } if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/request_has_requirement.php'; $dbh_request_has_requirement = new request_has_requirement(); $object_name = 'dbh_request_has_requirement'; require 'components/create_form_data.php'; extract($arr_form_data); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_request_has_requirement.php?{$query_string}"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); $message .= $dbh_request_has_requirement->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_request_has_requirement->check_uniqueness_for_editing($arr_form_data)->is_unique) { //Good, no duplicate in database } else { $message = "Record already exists with the same primary identifiers!";
$mf_upload_counter_name = "request_has_requirement_count"; require 'components/upload_generic_mf.php'; if ($_POST['btn_submit']) { log_action('Pressed submit button'); $message .= $dbh_request->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_request->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_request->add($arr_form_data); $request_id = $dbh_request->auto_id; require_once 'subclasses/request_has_requirement.php'; $dbh_request = new request_has_requirement(); for ($a = 0; $a < $request_has_requirement_count; $a++) { $cf_request_has_requirement_date_submitted[$a] = $cf_request_has_requirement_date_submitted_year[$a] . '-' . $cf_request_has_requirement_date_submitted_month[$a] . '-' . $cf_request_has_requirement_date_submitted_day[$a]; $param = array('date_submitted' => $cf_request_has_requirement_date_submitted[$a], 'requirement_document' => $cf_request_has_requirement_requirement_document[$a], 'request_id' => $request_id, 'status' => $cf_request_has_requirement_status[$a]); $dbh_request->add($param); } redirect("listview_request.php?{$query_string}"); } } } require 'subclasses/request_html.php'; $html = new request_html(); $html->draw_header('Add Request', $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();
log_action('Pressed cancel button'); redirect("listview_request.php?{$query_string}"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); $message .= $dbh_request->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_request->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_request->edit($arr_form_data); require_once 'subclasses/request_has_requirement.php'; $dbh_request = new request_has_requirement(); $dbh_request->delete_many($arr_form_data); for ($a = 0; $a < $request_has_requirement_count; $a++) { $cf_request_has_requirement_date_submitted[$a] = $cf_request_has_requirement_date_submitted_year[$a] . '-' . $cf_request_has_requirement_date_submitted_month[$a] . '-' . $cf_request_has_requirement_date_submitted_day[$a]; $param = array('date_submitted' => $cf_request_has_requirement_date_submitted[$a], 'requirement_document' => $request_id); $dbh_request->add($param); } redirect("listview_request.php?{$query_string}"); } } } require 'subclasses/request_html.php'; $html = new request_html(); $html->draw_header('Edit Request', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('request_id');
<?php require 'components/get_listview_referrer.php'; require 'subclasses/request_has_requirement.php'; $dbh_request_has_requirement = new request_has_requirement(); $dbh_request_has_requirement->set_where("request_has_requirement_id='" . quote_smart($request_has_requirement_id) . "'"); if ($result = $dbh_request_has_requirement->make_query()->result) { $data = $result->fetch_assoc(); extract($data); $data = explode('-', $date_submitted); if (count($data) == 3) { $date_submitted_year = $data[0]; $date_submitted_month = $data[1]; $date_submitted_day = $data[2]; } }
<?php require 'components/get_listview_referrer.php'; require 'subclasses/request_has_requirement.php'; $dbh_request_has_requirement = new request_has_requirement(); $dbh_request_has_requirement->set_where(""); if ($result = $dbh_request_has_requirement->make_query()->result) { $data = $result->fetch_assoc(); extract($data); $data = explode('-', $date_submitted); if (count($data) == 3) { $date_submitted_year = $data[0]; $date_submitted_month = $data[1]; $date_submitted_day = $data[2]; } }
require 'path.php'; init_cobalt('Delete request has requirement'); if (isset($_GET['request_has_requirement_id'])) { $request_has_requirement_id = urldecode($_GET['request_has_requirement_id']); require_once 'form_data_request_has_requirement.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_request_has_requirement.php?{$query_string}"); } elseif ($_POST['btn_delete']) { log_action('Pressed delete button'); require_once 'subclasses/request_has_requirement.php'; $dbh_request_has_requirement = new request_has_requirement(); $object_name = 'dbh_request_has_requirement'; require 'components/create_form_data.php'; $dbh_request_has_requirement->delete($arr_form_data); redirect("listview_request_has_requirement.php?{$query_string}"); } } require 'subclasses/request_has_requirement_html.php'; $html = new request_has_requirement_html(); $html->draw_header('Delete Request Has Requirement', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('request_has_requirement_id'); $html->detail_view = TRUE; $html->draw_controls('delete'); $html->draw_footer();
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com //Cobalt developed by JV Roig (jvroig@jvroig.com) //**************************************************************************************** require 'path.php'; init_cobalt('View request has requirement'); if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_request_has_requirement.php"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); require 'subclasses/request_has_requirement.php'; $dbh_request_has_requirement = new request_has_requirement(); if ($message == "") { log_action('Exported table data to CSV'); $timestamp = date('Y-m-d'); $token = generate_token(0, 'fs'); $csv_name = $token . $_SESSION['user'] . '_request_has_requirement_' . $timestamp . '.csv'; $filename = TMP_DIRECTORY . '/' . $csv_name; $csv_contents = $dbh_request_has_requirement->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'; }
$request_id = urldecode($_GET['request_id']); require_once 'form_data_request.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_request.php?{$query_string}"); } elseif ($_POST['btn_delete']) { log_action('Pressed delete button'); require_once 'subclasses/request.php'; $dbh_request = new request(); $object_name = 'dbh_request'; require 'components/create_form_data.php'; $dbh_request->delete($arr_form_data); require_once 'subclasses/request_has_requirement.php'; $dbh_request = new request_has_requirement(); $dbh_request->delete_many($arr_form_data); redirect("listview_request.php?{$query_string}"); } } require 'subclasses/request_html.php'; $html = new request_html(); $html->draw_header('Delete Request', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('request_id'); $html->detail_view = TRUE; $html->draw_controls('delete'); $html->draw_footer();