function createdetailevents($parenteventid) { $sql = "select * from user_event where id=" . $parenteventid; mysql_query($sql); $handle = mysql_query($sql) or die(mysql_error()); /*$this->db->where('id', $parenteventid); $q = $this->db->get('user_event'); if ($q->num_rows() > 0): $row = $q->row(); endif;*/ $arr; while ($row = mysql_fetch_object($handle)) { $arr["_ID"] = $row->id; $arr["_EventName"] = $row->event_title; $arr["_Location"] = $row->event_loc; $arr["_Description"] = $row->event_desc; $arr["_StartDate"] = $row->start_date; $arr["_EndDate"] = $row->to_date; $arr["_Daily"] = $row->daily; $arr["_Weekly"] = $row->weekly; $arr["_Monthly"] = $row->monthly; $arr["_Yearly"] = $row->yearly; $arr["_Daily_interval"] = $row->daily_interval; $arr["_Weekly_interval"] = $row->weekly_interval; $arr["_Weekly_interval_day"] = $row->weekly_interval_day; $arr["_Monthly_interval"] = $row->monthly_interval; $arr["_Monthly_interval_date"] = $row->monthly_interval_date; $arr["_Yearly_interval_date"] = $row->yearly_interval_date; $arr["_Yearly_interval_month"] = $row->yearly_interval_month; $arr["_Occurence"] = $row->event_occ; $arr["repeat_start_date"] = $row->repeat_start_date; if (trim($arr["_Daily"]) == "0" && trim($arr["_Monthly"]) == "0" && trim($arr["_Weekly"]) == "0" && trim($arr["_Yearly"]) == "0") { $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $arr["_StartDate"] = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $enddate = $arr['_EndDate']; $end_exp = explode("/", $enddate); $arr["_EndDate"] = $end_exp[2] . "-" . $end_exp[1] . "-" . $end_exp[0]; $strFieldsName = "parenteventid,startDate,endDate"; $strInsertValue = "'" . $arr["_ID"] . "','" . $arr["_StartDate"] . "','" . $arr["_EndDate"] . "'"; $this->insertdetailevent($strFieldsName, $strInsertValue); } else { $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $startdate = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $enddate = $arr['_EndDate']; $end_exp = explode("/", $enddate); $enddate = $end_exp[2] . "-" . $end_exp[1] . "-" . $end_exp[0]; $repeat_start_date = $arr['repeat_start_date']; $repeat_exp = explode("/", $repeat_start_date); $repeat_start_date = $repeat_exp[2] . "-" . $repeat_exp[1] . "-" . $repeat_exp[0]; $date_difference = strtotime($repeat_start_date) - strtotime($startdate); if (trim($arr["_Daily"]) == "1") { // Start Code $strFieldsName = "parenteventid,startDate,endDate"; $strInsertValue = ""; $arr["_Occurence"] = $date_difference / (60 * 60 * 24); if (trim($arr["_Daily_interval"]) != "") { if (intval($arr["_Daily_interval"]) <= 0) { $arr["_Daily_interval"] = 1; } $icounter = -1; $blnloop = 1; while ($blnloop == 1) { $icounter++; $strInsertValue = "'" . $arr["_ID"] . "'"; $interval = intval(trim($arr["_Daily_interval"])) * $icounter; $startresult = mysql_fetch_array(mysql_query("SELECT ADDDATE('" . $startdate . "', INTERVAL " . $interval . " DAY) as startdate")); $endresult = mysql_fetch_array(mysql_query("SELECT ADDDATE('" . $enddate . "', INTERVAL " . $interval . " DAY) as enddate")); $strNewDate = $startresult['startdate']; $strEndDate = $endresult['enddate']; //$strNewDate=adddays($arr["_StartDate"],(intval(trim($arr["_Daily_interval"]))*$icounter),"day"); //$strEndDate=adddays($arr["_EndDate"],(intval(trim($arr["_Daily_interval"]))*$icounter),"day"); $strInsertValue .= ",'" . $strNewDate . "','" . $strEndDate . "'"; $this->insertdetailevent($strFieldsName, $strInsertValue); if ($icounter + 1 >= intval($arr["_Occurence"])) { $blnloop = 0; } } } // End Code } // weekly if (trim($arr["_Weekly"]) == "1") { $arr["_Occurence"] = $date_difference / (60 * 60 * 24 * 7); // Start Code $strFieldsName = "parenteventid,startDate,endDate"; $strInsertValue = ""; if (trim($arr["_Weekly_interval"]) == "") { $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $arr["_StartDate"] = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $arr["_Weekly_interval"] = getCurrentWeeklyDay($arr["_StartDate"]); } if (trim($arr["_Weekly_interval"]) != "") { $icounter = -1; $blnloop = 1; $strNewDate = ""; $strNewEndDate = ""; $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $arr["_StartDate"] = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $enddate = $arr['_EndDate']; $end_exp = explode("/", $enddate); $arr["_EndDate"] = $end_exp[2] . "-" . $end_exp[1] . "-" . $end_exp[0]; while ($blnloop == 1) { $strInsertValue = "'" . $arr["_ID"] . "'"; $icounter++; if ($icounter == 0) { $strNewDate = getWeeklyDay($arr["_StartDate"], trim($arr["_Weekly_interval"])); } else { $intWeekInterval = 1; if (trim($arr["_Weekly_interval_day"]) != "") { $intWeekInterval = intval(trim($arr["_Weekly_interval_day"])); } if ($intWeekInterval <= 0) { $intWeekInterval = 1; } $strNewDate = adddays($strNewDate, $intWeekInterval, "week"); } $arrTempCompare = getDateDifference($arr["_StartDate"], $strNewDate); $strNewEndDate = adddays($arr["_EndDate"], intval($arrTempCompare["days"]), "day"); $exp_new = explode("-", $strNewDate); if (strlen($exp_new[2]) == 1) { $exp_new[2] = "0" . $exp_new[2]; } $exp_newend = explode("-", $strNewEndDate); if (strlen($exp_newend[2]) == 1) { $exp_newend[2] = "0" . $exp_newend[2]; } $strNewDate = $exp_new[0] . "-" . $exp_new[1] . "-" . $exp_new[2]; $strNewEndDate = $exp_newend[0] . "-" . $exp_newend[1] . "-" . $exp_newend[2]; $strInsertValue .= ",'" . $strNewDate . "','" . $strNewEndDate . "'"; $this->insertdetailevent($strFieldsName, $strInsertValue); if ($icounter + 1 >= intval($arr["_Occurence"])) { $blnloop = 0; } } } // End Code } // Monthly if (trim($arr["_Monthly"]) == "1") { // Start Code $arr["_Occurence"] = $date_difference / (60 * 60 * 24 * 30); $strFieldsName = "parenteventid,startDate,endDate"; $strInsertValue = ""; $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $arr["_StartDate"] = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $enddate = $arr['_EndDate']; $end_exp = explode("/", $enddate); $arr["_EndDate"] = $end_exp[2] . "-" . $end_exp[1] . "-" . $end_exp[0]; if (trim($arr["_Monthly_interval"]) == "") { $arr["_Monthly_interval"] = getCurrentMonthDay($arr["_StartDate"]); } if (trim($arr["_Monthly_interval"]) != "") { $icounter = -1; $blnloop = 1; $strNewDate = ""; while ($blnloop == 1) { $strInsertValue = "'" . $arr["_ID"] . "'"; $icounter++; $intMonthInterval = 1; if (trim($arr["_Monthly_interval_date"]) != "") { $intMonthInterval = intval(trim($arr["_Monthly_interval_date"])); } if ($intMonthInterval <= 0) { $intMonthInterval = 1; } if ($icounter == 0) { $strNewDate = getMonthDay($arr["_StartDate"], trim($arr["_Monthly_interval"]), $intMonthInterval, 1); } else { $strNewDate = getMonthDay($strNewDate, trim($arr["_Monthly_interval"]), $intMonthInterval); } if ($strNewDate != "") { $arrTempCompare = getDateDifference($arr["_StartDate"], $strNewDate); $strNewEndDate = adddays($arr["_EndDate"], intval($arrTempCompare["days"]), "day"); $exp_new = explode("-", $strNewDate); if (strlen($exp_new[2]) == 1) { $exp_new[2] = "0" . $exp_new[2]; } $exp_newend = explode("-", $strNewEndDate); if (strlen($exp_newend[2]) == 1) { $exp_newend[2] = "0" . $exp_newend[2]; } $strNewDate = $exp_new[0] . "-" . $exp_new[1] . "-" . $exp_new[2]; $strNewEndDate = $exp_newend[0] . "-" . $exp_newend[1] . "-" . $exp_newend[2]; $strInsertValue .= ",'" . $strNewDate . "','" . $strNewEndDate . "'"; $this->insertdetailevent($strFieldsName, $strInsertValue); } if ($icounter + 1 >= intval($arr["_Occurence"])) { $blnloop = 0; } } } // End Code } // Yearly if (trim($arr["_Yearly"]) == "1") { // Start Code $arr["_Occurence"] = $date_difference / (60 * 60 * 24 * 365); $startdate = $arr['_StartDate']; $start_exp = explode("/", $startdate); $arr["_StartDate"] = $start_exp[2] . "-" . $start_exp[1] . "-" . $start_exp[0]; $enddate = $arr['_EndDate']; $end_exp = explode("/", $enddate); $arr["_EndDate"] = $end_exp[2] . "-" . $end_exp[1] . "-" . $end_exp[0]; // Start Code $strFieldsName = "parenteventid,startDate,endDate"; $strInsertValue = ""; if (trim($arr["_Yearly_interval_date"]) == "" && intval(trim($arr["_Yearly_interval_date"])) <= 0) { $arr["_Yearly_interval_date"] = getCurrentMonth($arr["_StartDate"]); } if (trim($arr["_Yearly_interval_month"]) == "" && intval(trim($arr["_Yearly_interval_month"])) <= 0) { $arr["_Yearly_interval_month"] = getCurrentMonthDay($arr["_StartDate"]); } if (trim($arr["_Yearly_interval_month"]) != "") { $icounter = -1; $blnloop = 1; $strNewDate = ""; while ($blnloop == 1) { $strInsertValue = "'" . $arr["_ID"] . "'"; $icounter++; if ($icounter == 0) { $strNewDate = getYearDay($arr["_StartDate"], trim($arr["_Yearly_interval_date"]), trim($arr["_Yearly_interval_month"]), 1); } else { $strNewDate = getYearDay($strNewDate, trim($arr["_Yearly_interval_date"]), trim($arr["_Yearly_interval_month"])); } if ($strNewDate != "") { $arrTempCompare = getDateDifference($arr["_StartDate"], $strNewDate); $strNewEndDate = adddays($arr["_EndDate"], intval($arrTempCompare["days"]), "day"); $exp_new = explode("-", $strNewDate); if (strlen($exp_new[2]) == 1) { $exp_new[2] = "0" . $exp_new[2]; } $exp_newend = explode("-", $strNewEndDate); if (strlen($exp_newend[2]) == 1) { $exp_newend[2] = "0" . $exp_newend[2]; } $strNewDate = $exp_new[0] . "-" . $exp_new[1] . "-" . $exp_new[2]; $strNewEndDate = $exp_newend[0] . "-" . $exp_newend[1] . "-" . $exp_newend[2]; $strInsertValue .= ",'" . $strNewDate . "','" . $strNewEndDate . "'"; $this->insertdetailevent($strFieldsName, $strInsertValue); } if ($icounter + 1 >= intval($arr["_Occurence"])) { $blnloop = 0; } } } // End Code } } } }
include_once "mod.calendar.php"; include_once "mod.attendance.php"; include_once "ctrl.checklogin.php"; include_once "ctrl.calendar.php"; include_once "ctrl.attendance.php"; mysql_query("set character_set_client='utf8'"); mysql_query("set character_set_results='utf8'"); mysql_query("set collation_connection='utf8_general_ci'"); /** Error reporting */ error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); //$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); 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"); $hrow = 1; $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $hrow, '日付')->setCellValue('B' . $hrow, '曜日')->setCellValue('C' . $hrow, '出社時間')->setCellValue('D' . $hrow, '遅刻')->setCellValue('E' . $hrow, '退社時間')->setCellValue('F' . $hrow, '早退')->setCellValue('G' . $hrow, '作業時間')->setCellValue('H' . $hrow, '残業時間')->setCellValue('I' . $hrow, '統計時間');
/** * function to generate a unique print number for abbott */ function generateWorksheetReferenceNumber() { global $trailSessionUser,$datetime; //get the user's names $names=0; $names=getDetailedTableInfo2("vl_users","email='$trailSessionUser' limit 1","names"); $namesArray=array(); $namesArray=explode(" ",$names); $initials=0; if(count($namesArray)>1) { //get the first letter of each name $initials=substr(trim($namesArray[0]),0,1); $initials.=substr(trim($namesArray[1]),0,1); $initials=strtoupper($initials); } else { //get the first 2 letters of the email $initials=substr(trim($trailSessionUser),0,2); $initials=strtoupper($initials); } //variables $number=0; $number=getDetailedTableInfo3("vl_samples_worksheetcredentials","year(created)='".getCurrentYear()."' and month(created)='".getCurrentMonth()."'","count(id)","num"); $number+=1; $reference=0; $reference=getFormattedDateYearShort($datetime).getFormattedDateMonth($datetime); switch(strlen($number)) { case 1: $reference.=$initials."00$number"; break; case 2: $reference.=$initials."0$number"; break; default: $reference.=$initials.$number; break; } return $reference; }
//echo $yr['1']; $out_limit = $_SESSION['sess_user_outtime']; $in_limit = $_SESSION['sess_user_intime']; $to = $_SESSION['sess_user_id']; $rsesult = getmail($to, $db); foreach ($rsesult as $row) { $tosend = $row['email']; //echo $tosend; } $getname = getusername($_SESSION['sess_user_id'], $db); foreach ($getname as $result) { $fname = $result['user_name']; $eid = $result['user_eid']; //echo $eid; } $getCurrentMonth = getCurrentMonth($yr, $_SESSION['sess_user_id'], $db); $to_mail = implode(", ", MailList(getHeaders(1, $db), 'to', $db)); $to_cc = implode(", ", MailList(getHeaders(1, $db), 'cc', $db)); $to_bcc = implode(", ", MailList(getHeaders(1, $db), 'bcc', $db)); $body = '<html> <head><title></title> <style> td{text-align:center; border-bottom: 1px dotted #514F4F;} table{width:900px;} span{color:red;} th{border-top: 1px solid #514F4F;border-bottom: 1px solid #514F4F;background: #514F4F;color: #E1E1E1;} </style> </head> <body>'; $body .= 'User Name: ' . $fname . '<br>'; $body .= 'User Id: ' . $eid . '<br>';
include_once "ctrl.attendance.php"; if ($_SESSION['sess_user_id']) { $to = $_SESSION['sess_user_id']; $rsesult = getmail($to, $db); foreach ($rsesult as $row) { $tosend = $row['email']; } } $getname = getusername($_SESSION['sess_user_id'], $db); foreach ($getname as $result) { $fname = $result['user_name']; $eid = $result['user_eid']; } $userid = !isset($_GET['userid']) || $_GET['userid'] == "" ? 1 : $_GET['userid']; $todaydate = explode("-", date("Y-n-j")); $getCurrentMonth = getCurrentMonth($todaydate, $_SESSION['sess_user_id'], $db); $to_mail = implode(", ", MailList(getHeaders(1, $db), 'to', $db)); $to_cc = implode(", ", MailList(getHeaders(1, $db), 'cc', $db)); $to_bcc = implode(", ", MailList(getHeaders(1, $db), 'bcc', $db)); $body = '<html><head><title></title>'; $body .= '<style>'; $body .= 'table{width:900px;}'; $body .= 'th{border-top: 1px solid #514F4F;border-bottom: 1px solid #514F4F;background: #514F4F;color: #E1E1E1;}'; $body .= 'td{text-align:center; border-bottom: 1px dotted #514F4F;}'; $body .= 'span{color:red;}'; $body .= '</style>'; $body .= '</head><body>'; $body .= 'User Name: ' . $fname . '<br>'; $body .= 'User Id: ' . $eid . '<br>'; $body .= '<table>'; $body .= "<tr>";
include_once "ctrl.attendance.php"; include_once "ctrl.checklogin.php"; include_once "ctrl.admin.php"; include_once "ctrl.group.php"; if (isset($_GET['uid']) && isset($_GET['cdate']) && $_GET['uid'] != "" && $_GET['cdate'] != "") { $d = explode("-", $_GET['cdate']); $userid = $_GET['uid']; // ** get user information $user = getUserProfileById($userid, $db); $wtime = getGroupTime($userid, $db); // ** set current timezone according to user type setTimeZone($user[0]['user_eid']); // ** set intime and outtime for this user's group $WORKINTIME = $wtime[0]['group_intime']; $WORKOUTTIME = $wtime[0]['group_outtime']; $getCurrentMonth = getCurrentMonth($d, $userid, $db); $late = getLateCheckIn($userid, $WORKINTIME, $d, $db); $earlyleave = getEarlyCheckOut($userid, $WORKOUTTIME, $d, $db); $absent = getAbsent($userid, $d, $db); } ?> <html lang="en"> <head> <meta charset="utf-8"> <title>Kinntai system</title> <link href="<?php echo CSS; ?> /import.css" rel="stylesheet" type="text/css"/> <script src="<?php echo JS;