PHP sub_doc Examples

Example #1

File: form_data_request.php Project: seans888/Bgy-Project

$dbh_request->set_where("request_id='" . quote_smart($request_id) . "'");
if ($result = $dbh_request->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
    $data = explode('-', $date_served);
    if (count($data) == 3) {
        $date_served_year = $data[0];
        $date_served_month = $data[1];
        $date_served_day = $data[2];
    }
    $data = explode('-', $date_filed);
    if (count($data) == 3) {
        $date_filed_year = $data[0];
        $date_filed_month = $data[1];
        $date_filed_day = $data[2];
    }
}
require_once 'subclasses/sub_doc.php';
$dbh_request = new sub_doc();
$dbh_request->set_fields('document_id, requirement_id, requirement_doc, status');
$dbh_request->set_where("request_id='" . quote_smart($request_id) . "'");
if ($result = $dbh_request->make_query()->result) {
    $num_sub_doc = $dbh_request->num_rows;
    for ($a = 0; $a < $num_sub_doc; $a++) {
        $data = $result->fetch_row();
        $cf_sub_doc_document_id[$a] = $data[0];
        $cf_sub_doc_requirement_id[$a] = $data[1];
        $cf_sub_doc_requirement_doc[$a] = $data[2];
        $cf_sub_doc_status[$a] = $data[3];
    }
}

Example #2

File: csv_sub_doc.php Project: seans888/Bgy-Project

//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 sub doc');
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_sub_doc.php");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        require 'subclasses/sub_doc.php';
        $dbh_sub_doc = new sub_doc();
        if ($message == "") {
            log_action('Exported table data to CSV');
            $timestamp = date('Y-m-d');
            $token = generate_token(0, 'fs');
            $csv_name = $token . $_SESSION['user'] . '_sub_doc_' . $timestamp . '.csv';
            $filename = TMP_DIRECTORY . '/' . $csv_name;
            $csv_contents = $dbh_sub_doc->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';
        }

Example #3

File: delete_request.php Project: seans888/Bgy-Project

    $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/sub_doc.php';
        $dbh_request = new sub_doc();
        $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();

Example #4

File: edit_sub_doc.php Project: seans888/Bgy-Project

//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 sub doc');
if (isset($_GET['sub_doc_id'])) {
    $sub_doc_id = urldecode($_GET['sub_doc_id']);
    require 'form_data_sub_doc.php';
    $orig_sub_doc_id = $sub_doc_id;
}
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    require 'components/query_string_standard.php';
    require 'subclasses/sub_doc.php';
    $dbh_sub_doc = new sub_doc();
    $object_name = 'dbh_sub_doc';
    require 'components/create_form_data.php';
    $arr_form_data['orig_sub_doc_id'] = $_POST['orig_sub_doc_id'];
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_sub_doc.php?{$query_string}");
    }
    $file_upload_control_name = 'requirement_doc';
    require 'components/upload_generic.php';
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_sub_doc->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_sub_doc->check_uniqueness_for_editing($arr_form_data)->is_unique) {

Example #5

File: edit_request.php Project: seans888/Bgy-Project

    $file_upload_control_name = "cf_sub_doc_requirement_doc";
    $mf_upload_counter_name = "sub_doc_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_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/sub_doc.php';
            $dbh_request = new sub_doc();
            $dbh_request->delete_many($arr_form_data);
            for ($a = 0; $a < $sub_doc_count; $a++) {
                $param = array('request_id' => $request_id, 'document_id' => $cf_sub_doc_document_id[$a], 'requirement_id' => $cf_sub_doc_requirement_id[$a], 'requirement_doc' => $cf_sub_doc_requirement_doc[$a], 'status' => $cf_sub_doc_status[$a]);
                $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, TRUE, TRUE);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('request_id');
$html->draw_controls('edit');

Example #6

File: add_request.php Project: seans888/Bgy-Project

        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($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/sub_doc.php';
            $dbh_request = new sub_doc();
            for ($a = 0; $a < $sub_doc_count; $a++) {
                $param = array('request_id' => $request_id, 'document_id' => $cf_sub_doc_document_id[$a], 'requirement_id' => $cf_sub_doc_requirement_id[$a], 'requirement_doc' => $cf_sub_doc_requirement_doc[$a], 'status' => $cf_sub_doc_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();

Example #7

File: form_data_sub_doc.php Project: seans888/Bgy-Project

<?php

require 'components/get_listview_referrer.php';
require 'subclasses/sub_doc.php';
$dbh_sub_doc = new sub_doc();
$dbh_sub_doc->set_where("sub_doc_id='" . quote_smart($sub_doc_id) . "'");
if ($result = $dbh_sub_doc->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
}

Example #8

File: add_sub_doc.php Project: seans888/Bgy-Project

<?php

//****************************************************************************************
//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('Add sub doc');
require 'components/get_listview_referrer.php';
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    require 'components/query_string_standard.php';
    require 'subclasses/sub_doc.php';
    $dbh_sub_doc = new sub_doc();
    $object_name = 'dbh_sub_doc';
    require 'components/create_form_data.php';
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_sub_doc.php?{$query_string}");
    }
    $file_upload_control_name = 'requirement_doc';
    require 'components/upload_generic.php';
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_sub_doc->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_sub_doc->check_uniqueness($arr_form_data)->is_unique) {
            //Good, no duplicate in database
        } else {

Example #9

File: delete_sub_doc.php Project: seans888/Bgy-Project

require 'path.php';
init_cobalt('Delete sub doc');
if (isset($_GET['sub_doc_id'])) {
    $sub_doc_id = urldecode($_GET['sub_doc_id']);
    require_once 'form_data_sub_doc.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_sub_doc.php?{$query_string}");
    } elseif ($_POST['btn_delete']) {
        log_action('Pressed delete button');
        require_once 'subclasses/sub_doc.php';
        $dbh_sub_doc = new sub_doc();
        $object_name = 'dbh_sub_doc';
        require 'components/create_form_data.php';
        $dbh_sub_doc->delete($arr_form_data);
        redirect("listview_sub_doc.php?{$query_string}");
    }
}
require 'subclasses/sub_doc_html.php';
$html = new sub_doc_html();
$html->draw_header('Delete Submitted Document', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('sub_doc_id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();