require "menu.php";
require "class/class_firebird.php";
require "class/mysql-class.php";
$fac = new class_ibase();
$test = new class_mysql_base();
if ($_POST['zdacha']) {
$test->update_excel("UPDATE excel SET type_atemp = '" . $_POST['year'] . "',date = '" . $_POST['date'] . "',lang = '" . $_POST['lang'] . "'\n ,chastuna = '" . $_POST['chastuna'] . "',potik = '" . $_POST['potik'] . "',type_sesion = '" . $_POST['zdacha'] . "' WHERE id = '" . $_GET['id'] . "'");
}
//$department_kil = $test->select_excel_faculty();
/*$department = $fac->select_faculty();
$special = $fac->select_speciality();*/
echo "<br> \n <h3><center>Редагування бази Excel </h3>";
if ($_GET['id_excel']) {
$log = $test->select_log("SELECT * FROM log_excel WHERE id_export_table='" . $_GET['id_excel'] . "'");
unlink($log[0]['file_path']);
$test->delete_log_excel($_GET['id_excel']);
}
include "navigate/navigate.php";
if ($_GET['faculty'] != '' && $_GET['year'] != '') {
if ($_GET['special']) {
$parameter = " AND speciality_id=" . $_GET['special'] . "";
}
if ($_GET['lang']) {
$parameter = $parameter . " AND lang='" . $_GET['lang'] . "'";
}
if ($_GET['course']) {
$parameter = $parameter . " AND semester='" . $_GET['course'] . "'";
}
if ($_GET['year']) {
$parameter = $parameter . " AND type_atemp='" . $_GET['year'] . "'";
}
