<link rel='stylesheet' href='datepicker/datepicker.css' type='text/css' />
<?php
require "auth.php";
echo "\n<script type='text/javascript' src='datepicker/jquery.js'></script>\n<script type='text/javascript' src='datepicker/date.js'></script>\n<script type='text/javascript' src='datepicker/jquery.datePicker-2.1.2.js'></script>\n \n<script type='text/javascript'>\n\$(function()\n{\n\$('#inputDate4').datePicker({\ncreateButton:false,\nclickInput:true,\nendDate: (new Date()).addDays(365).asString()\n});\n});\n</script>";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
require "header.php";
require "menu.php";
require "class/potochna.php";
require "class/mysql-class.php";
require "class/class_firebird.php";
$test = new class_mysql_base();
$ibase = new class_ibase();
$type_session = $test->select_type_session("1");
$year = $test->select_year("SELECT DISTINCT date,name,id FROM yearplan WHERE 1 ORDER BY id DESC;");
echo " <br><center><h3>Завантажити файл з EXCEL </h3><br></center>\n <form action='up_stat.php' method='post' enctype='multipart/form-data'>\n \t\n \n <div class='kvadrant'><br>\n\tКороткий опис\n\t<input name='title' value='' />\n\t<br><br>\n\t</div> \n\n <div class='kvadrant'><br>\n\tТип здачі \n\t<select name='year'>\n ";
for ($i = 0; $i < count($year); $i++) {
echo "<option value='" . $year[$i]['id'] . "'>" . $year[$i]['date'] . "/" . $year[$i]['name'] . "</option>";
}
echo "\n\t</select>\n\t<br><br>\n\t</div>\n\n <div class='kvadrant'><br>\n\tМова здачі \n\t<select name='lang'>\n <option value='UA'>Українська</option>\n <option value='ENG'>Іноземна</option>\n\t</select>\n\t<br><br>\n\t</div>\n \n <div class='kvadrant'><br> \n\tДата здачі\n\t<input id='inputDate4' name='date' value='" . Date("Y-m-d") . "' />\n\t<br><br>\n\t</div>\n \n\t<div class='kvadrant'><br>\n\tТип здачі \n\t<select name='zdacha'>\n ";
for ($i = 0; $i < count($type_session); $i++) {
echo "<option value='" . $type_session[$i]['id'] . "'>" . $type_session[$i]['type'] . "</option>";
}
echo "\n\t</select>\n\t<br><br>\n\t</div>\n\t\n\t<div class='kvadrant'><br>\n\tПотік \n\t<select name='potik'>\n\t\t<option value='0' name=''>Без потоку</option>\n\t\t<option value='1' name=''>І потік</option>\n\t\t<option value='2' name=''>ІІ потік</option>\n\t</select>\n\t<br><br>\n\t</div>\n\t\n\t<div class='kvadrant'><br>\n\tЧастина\n\t<select name='chastuna'>\n\t\t<option value='1' name=''>І частина</option>\n\t\t<option value='2' name=''>ІІ частина</option>\n\t</select>\n\t<br><br>\n\t</div>\n\t<div class='kvadrant'><br>\n\tВиберіть файл \n <input type='file' name='filename' value='Огляд'>\n <br><br></div><br><br>\n <input type='submit' value='Експортувати дані'><br></form>";
if (isset($_FILES["filename"]["tmp_name"])) {
if (is_uploaded_file($_FILES["filename"]["tmp_name"])) {
$temp_file = date("d-m-i-s");
move_uploaded_file($_FILES["filename"]["tmp_name"], "sheets/" . $temp_file . $_FILES["filename"]["name"]);
include_once "Class/class reader.php";
$data = new XLSToDB($temp_file . $_FILES["filename"]["name"], 'CP1251');
$fileXLS = $temp_file . $_FILES["filename"]["name"];
