session_regenerate_id();
$_SESSION['sess_user_id'] = $result['user_id'];
$_SESSION['sess_username'] = $result['user_name'];
$_SESSION['sess_user_eid'] = $result['user_eid'];
// user is administrator
if ($result['user_role'] == 0) {
$_SESSION['sess_user_role'] = $result['user_role'];
$_SESSION['sess_user_eid'] = $result['user_eid'];
header('Location: ' . ROOT . "admin/history.php");
exit;
// user is normal user
} else {
if ($result['user_role'] == 1) {
// ** add timezone
$todaydate = date("Y-n-j");
$wtime = getGroupTime($result['user_id'], $db);
$_SESSION['sess_user_intime'] = $wtime[0]['group_intime'];
$_SESSION['sess_user_outtime'] = $wtime[0]['group_outtime'];
$_SESSION['sess_user_role'] = $result['user_role'];
$_SESSION['sess_user_eid'] = $result['user_eid'];
$_SESSION['sess_user_bid'] = $result['branch_id'];
$_SESSION['sess_date'] = $todaydate;
header('Location: ' . ROOT . 'home.php');
exit;
} else {
header("location: " . ROOT . "error.html");
exit;
}
}
session_write_close();
}
include_once "mod.select.php";
include_once "ctrl.checklogin.php";
include_once "mod.attendance.php";
include_once "ctrl.attendance.php";
include_once "ctrl.group.php";
//error_reporting(E_ALL);
//ini_set( 'display_errors','1');
mysql_query("set character_set_client='utf8'");
mysql_query("set character_set_results='utf8'");
mysql_query("set collation_connection='utf8_general_ci'");
//$userid = (!isset($_GET['userid']) || $_GET['userid'] == "")?1:$_GET['userid'];
$userid = $_GET['uid'];
$todaydate = explode("-", date("Y-n-j"));
$getCurrentMonth = getCurrentMonth($todaydate, $userid, $db);
$getname = getusername($userid, $db);
$wtime = getGroupTime($userid, $db);
$WORKINTIME = $wtime[0]['group_intime'];
$WORKOUTTIME = $wtime[0]['group_outtime'];
//echo "testing".$WORKINTIME;
foreach ($getname as $result) {
$fname = $result['user_name'];
}
if (PHP_SAPI == 'cli') {
die('This example should only be run from a Web Browser');
}
/** Include PHPExcel */
require_once '../Classes/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("Rubbersoul")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
