$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();
