<?php
require_once '../../../config/boot.php';
use McKay\Flash;
$input = array_merge($_GET, $_POST);
$faculty_id = GetSQLValueString($input['faculty_id'], "int");
$year_id = GetSQLValueString($input['year_id'], "int");
if (!($facultyRow = db_row_exists('academy_structure_faculty', 'faculty_id', $faculty_id, ['faculty_name']))) {
Flash::warning(trans('ACADEMY_STRUCTURE.YEAR.FACULTY_DONT_EXIST'));
header('location:../faculties/index.php');
exit;
}
if (!($yearRow = db_row_exists('academy_structure_year', 'year_id', $year_id, ['year_name']))) {
Flash::warning(trans('ACADEMY_STRUCTURE.YEAR.YEAR_DONT_EXISTS'));
header('location:index.php');
exit;
}
$createFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$createFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if (isset($input["MM_insert"]) && $input["MM_insert"] == "form1") {
$year_name = GetSQLValueString($input['year_name'], "text");
if (empty($year_name)) {
header('location: edit.php?year_id=' . $yearRow['year_name']);
exit;
}
$insert = sprintf("UPDATE academy_structure_year SET year_name=%s WHERE year_id=%s", $year_name, $yearRow['year_id']);
$result = mysql_query($insert, $dares_conn) or die(mysql_error());
if ($result) {
Flash::success($ecss_lang['ACADEMY_STRUCTURE']['YEAR']['UPDATE_SUCCESS']);
require_once '../../../config/boot.php';
use McKay\Flash;
$input = array_merge($_GET, $_POST);
$faculty_id = $input['faculty_id'];
/** start pagination */
$pagination_per_page = 10;
$pagination_target = 'index.php';
$page = 0;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$pagination_start = $page * $pagination_per_page;
/** end pagination */
// check if the faculty exists first
if (!($facultyRow = db_row_exists('academy_structure_faculty', 'faculty_id', $faculty_id, ['faculty_name']))) {
Flash::warning(trans('ACADEMY_STRUCTURE.YEAR.FACULTY_DONT_EXIST'));
header('location:../faculties/index.php');
exit;
}
$query_get_year = sprintf("SELECT year_name,user_fullname ,year_id,year_name,year_created_date,\n year_faculty_id FROM academy_structure_year asy \n LEFT JOIN academy_structure_faculty asf ON asy.year_faculty_id=asf.faculty_id \n LEFT JOIN sys_users su ON asy.year_created_by=su.user_id \n WHERE year_faculty_id = %s GROUP BY asy.year_id", GetSQLValueString($faculty_id, "int"));
$query_get_year_limit = sprintf("%s LIMIT %d, %d", $query_get_year, $pagination_start, $pagination_per_page);
$get_year_recordset = mysql_query($query_get_year, $dares_conn) or die(mysql_error());
$get_year_recordset_limit = mysql_query($query_get_year_limit, $dares_conn) or die(mysql_error());
$row_get_year = mysql_fetch_assoc($get_year_recordset_limit);
$total = mysql_num_rows($get_year_recordset_limit);
$pagination_total = mysql_num_rows($get_year_recordset_limit);
// html page title
$pageTitle = 'السنوات الدراسية';
// require page header
require_once $config['base_url'] . '/admin/template/includes/header.php';
/**
* save vote using database abstraction layer api
*/
function save_vote_database($table = "ballot_box")
{
$db = db_connect();
$row = array();
$row['ip_addr'] = $_SESSION['ip_addr'];
$row['email'] = $_SESSION['email_value'];
$row['mobile'] = $_SESSION['mobile_value'];
$row['choice'] = implode(',', $_SESSION['vote_keys']);
if (db_row_exists($db, 'email', $row['email'])) {
append_error("Такий e-mail вже проголосував.");
}
if (db_row_exists($db, 'mobile', $row['mobile'])) {
append_error("Такий мобільний вже проголосував.");
}
if (db_insert_row($db, $row, $ballot_id) == false) {
append_error("Запис голосу не вдався.");
}
$_SESSION['ballot_id'] = $ballot_id;
}
