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");