//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('View accomplishment');
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button', $_SERVER['PHP_SELF']);
redirect("listview_accomplishment.php");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button', $_SERVER['PHP_SELF']);
require 'subclasses/accomplishment.php';
$dbh_accomplishment = new accomplishment();
if ($message == "") {
log_action("Exported table data to CSV", $_SERVER['PHP_SELF']);
$timestamp = date('Y-m-d');
$token = generate_token(0, 'fs');
$csv_name = $token . $_SESSION['user'] . '_accomplishment_' . $timestamp . '.csv';
$filename = TMP_DIRECTORY . '/' . $csv_name;
$csv_contents = $dbh_accomplishment->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';
}
//framework developed by JV Roig (jvroig@jvroig.com).
//
//Cobalt on the web: http://cobalt.jvroig.com
//******************************************************************
require 'path.php';
init_cobalt('Edit accomplishment');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require 'form_data_accomplishment.php';
}
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
require 'components/query_string_standard.php';
require 'subclasses/accomplishment.php';
$dbh_accomplishment = new accomplishment();
$object_name = 'dbh_accomplishment';
require 'components/create_form_data.php';
extract($arr_form_data);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button');
redirect("listview_accomplishment.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_accomplishment->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_accomplishment->check_uniqueness_for_editing($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
//******************************************************************
require 'path.php';
init_cobalt('Delete accomplishment');
if (isset($_GET['id'])) {
$id = urldecode($_GET['id']);
require_once 'form_data_accomplishment.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_accomplishment.php?{$query_string}");
} elseif ($_POST['btn_delete']) {
log_action('Pressed delete button', $_SERVER['PHP_SELF']);
require_once 'subclasses/accomplishment.php';
$dbh_accomplishment = new accomplishment();
$object_name = 'dbh_accomplishment';
require 'components/create_form_data.php';
$dbh_accomplishment->del($arr_form_data);
redirect("listview_accomplishment.php?{$query_string}");
}
}
require 'subclasses/accomplishment_html.php';
$html = new accomplishment_html();
$html->draw_header('Delete Accomplishment', $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
require 'components/get_listview_referrer.php';
require 'subclasses/accomplishment.php';
$dbh_accomplishment = new accomplishment();
$dbh_accomplishment->set_where("id='" . quote_smart($id) . "'");
if ($result = $dbh_accomplishment->make_query()->result) {
$data = $result->fetch_assoc();
extract($data);
$data = explode('-', $date);
if (count($data) == 3) {
$date_year = $data[0];
$date_month = $data[1];
$date_day = $data[2];
}
}