require 'path.php';
init_cobalt('Delete province');
if (isset($_GET['province_id'])) {
    $province_id = urldecode($_GET['province_id']);
    require_once 'form_data_province.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_province.php?{$query_string}");
    } elseif ($_POST['btn_delete']) {
        log_action('Pressed delete button');
        require_once 'subclasses/province.php';
        $dbh_province = new province();
        $object_name = 'dbh_province';
        require 'components/create_form_data.php';
        $dbh_province->delete($arr_form_data);
        redirect("listview_province.php?{$query_string}");
    }
}
require 'subclasses/province_html.php';
$html = new province_html();
$html->draw_header('Delete Province', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('province_id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();
    require 'subclasses/province.php';
    $dbh_province = new province();
    $object_name = 'dbh_province';
    require 'components/create_form_data.php';
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_province.php?{$query_string}");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_province->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_province->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_province->edit($arr_form_data);
            redirect("listview_province.php?{$query_string}");
        }
    }
}
require 'subclasses/province_html.php';
$html = new province_html();
$html->draw_header('Edit Province', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('province_id');
$html->draw_controls('edit');
$html->draw_footer();
    require 'components/query_string_standard.php';
    require 'subclasses/province.php';
    $dbh_province = new province();
    $object_name = 'dbh_province';
    require 'components/create_form_data.php';
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_province.php?{$query_string}");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_province->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_province->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_province->add($arr_form_data);
            redirect("listview_province.php?{$query_string}");
        }
    }
}
require 'subclasses/province_html.php';
$html = new province_html();
$html->draw_header('Add Province', $message, $message_type);
$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();
<?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('View province');
if (isset($_GET['province_id'])) {
    $province_id = urldecode($_GET['province_id']);
    require 'form_data_province.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_province.php?{$query_string}");
    }
}
require 'subclasses/province_html.php';
$html = new province_html();
$html->draw_header('Detail View: Province', $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'] . '_province_' . $timestamp . '.csv';
            $filename = TMP_DIRECTORY . '/' . $csv_name;
            $csv_contents = $dbh_province->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/province_html.php';
$html = new province_html();
$html->draw_header('CSV Exporter: Province', $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();