alert("Sorry You Don\'t Have The Permission.")'; header('Location: index.php') ; exit ; } // include the class include 'requires/class_resize.php' ; // keep parameter in value $page = escapeString($_GET['page']) ; $page_mode = escapeString($_GET['page_mode']) ; $type = escapeString($_GET['type']) ; $search = escapeString($_GET['search']) ; // mode type | all list | new | edit switch($page_mode){ // all type list case 'all' : default : // query type $search_query = '' ; $staff_id = escapeString($_GET['staff_id']) ; $ty_type = escapeString($_GET['ty_type']) ; $st_type = escapeString($_GET['st_type']) ; $sort_by = escapeString($_GET['sort_by']) ; $sort_by = ( $sort_by != '' ? $sort_by : 'created_at' ) ; $sort_by_type = escapeString($_GET['sort_by_type']) ; $sort_by_type = ( $sort_by_type != '' ? $sort_by_type : 'desc' ) ; $export = escapeString($_GET['export']) ; // form submit if ( $_POST['hide'] == '1' ){ $leave_annual_id = escapeString($_POST['leave_annual_id']) ; $leave_annual = escapeString($_POST['leave_annual']) ; $leave_sick_id = escapeString($_POST['leave_sick_id']) ; $leave_sick = escapeString($_POST['leave_sick']) ; if ( $leave_annual_id > 0 && $leave_annual != '' ){ $mysqli->query("UPDATE staff_leave_year SET leave_days = '".$leave_annual."' WHERE leave_year_id = '".$leave_annual_id."'") ; } if ( $leave_sick_id > 0 && $leave_sick != '' ){ $mysqli->query("UPDATE staff_leave_year SET leave_days = '".$leave_sick."' WHERE leave_year_id = '".$leave_sick_id."'") ; } } // search query if ($search != ''){ $search_query .= " AND (leave_reason LIKE '%".$search."%')" ; } if ($ty_type != ''){ $search_query .= " AND leave_type = '".$ty_type."'" ; } if ($st_type != ''){ $search_query .= " AND leave_status = '".$st_type."'" ; } // active menu bar $active_main_menu = 'hr' ; $active_sub_menu = 'hr-leave' ; // pagination if (isset($page) && !empty($page)) { $product_page = $page ; } else { $product_page = 1 ; } // next and prev page (5 thing need to change) $start_from = ($product_page - 1) * LIMIT ; //end next and prev page // set search url $search_url = 'search='.$search.'&staff_id='.$staff_id.'&ty_type='.$ty_type.'&st_type='.$st_type.'&sort_by='.$sort_by.'&sort_by_type='.$sort_by_type ; // page query $mysqli_query = "SELECT a.leave_id as leave_id, a.leave_type, a.leave_from, a.leave_to, a.leave_day, a.leave_file, a.leave_reason, a.leave_status, a.created_at, a.updated_at, b.staff_name, b.staff_idno FROM staff_leave a LEFT JOIN staff b ON ( a.staff_id = b.staff_id ) WHERE a.staff_id = '".$staff_id."' AND a.deleted_at IS NULL " . $search_query ; // export excel if ( $export == 'yes' ){ include 'PhpExcel/PHPExcel.php' ; $page_filename = 'StaffLeave-'.date( 'Ymd', time() ) ; $objPHPExcel = new PHPExcel() ; $objPHPExcel->getProperties() ->setCreator(COMPANY) ->setTitle(COMPANY) ->setSubject(COMPANY) ->setDescription(COMPANY) ->setKeywords(COMPANY) ->setCategory(COMPANY) ; $objPHPExcel->getActiveSheet()->setTitle( $page_filename ) ; $objPHPExcel->setActiveSheetIndex(0); $objWriter = PHPExcel_IOFactory::createWriter( $objPHPExcel, 'Excel2007' ) ; // default parameter $count = 1 ; $char = 'A' ; $count_row = 1 ; $array_title = array( 'No.', 'Request By', 'Type', 'From ~ To', 'Reason', 'Status', 'Created Date', 'Updated Date' ) ; $newChar = $char ; foreach( $array_title as $k => $v ){ $objPHPExcel->setActiveSheetIndex(0)->setCellValue( $newChar.$count, $v ) ; $newChar++ ; } $count++ ; $row_q = $mysqli->query($mysqli_query." ORDER BY a.created_at DESC") ; if ( $row_q->num_rows > 0 ){ while ( $row = $row_q->fetch_assoc() ){ $newChar = $char ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, $count_row ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($row['staff_name']).' ( '.dataFilter($row['staff_idno']).' )' ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, ucwords($row['leave_type']) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($row['leave_from']).' ~ '.dataFilter($row['leave_to']).' ('.dataFilter($row['leave_day']).')' ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($row['leave_reason']) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($row['leave_status']) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, resetDateFormat($row['created_at']) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, resetDateFormat($row['updated_at']) ) ; $count++ ; $count_row++ ; } } // Submission from header( 'Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) ; header( 'Content-Disposition: attachment;filename="'.$page_filename.'.xls"' ) ; header( 'Cache-Control: max-age=0' ) ; // save to pc $objWriter->save('php://output') ; header( "Refresh: 0" ) ; exit ; } $mysqli_page = $mysqli->query($mysqli_query." ORDER BY a.created_at DESC LIMIT $start_from, " . LIMIT) ; // load pagination $page_pagination = nextPrevious($product_page, LIMIT, $search_url, $mysqli_query) ; // start header here include 'requires/page_header.php' ; include 'requires/page_top.php' ; setStaffLeaveYear( $staff_id ) ; ?>

query("SELECT leave_year_id, leave_type, leave_days FROM staff_leave_year WHERE staff_id = '".$staff_id."' AND leave_year = '".date('Y', time())."'") ; if ( $get_year->num_rows > 0 ){ $annual_id = '' ; $annual = '' ; $sick_id = '' ; $sick = '' ; while ( $row_year = $get_year->fetch_assoc() ){ if ( $row_year['leave_type'] == 'annual' ){ $annual_id = $row_year['leave_year_id'] ; $annual = $row_year['leave_days'] ; } if ( $row_year['leave_type'] == 'sick' ){ $sick_id = $row_year['leave_year_id'] ; $sick = $row_year['leave_days'] ; } } ?>

num_rows > 0){ while ($row_page = $mysqli_page->fetch_array(MYSQLI_ASSOC)){ if ( $row_page['leave_status'] == 'pending' ){ $button = '' ; }elseif ( $row_page['leave_status'] == 'confirmed' ){ $button = '' ; }else{ $button = '' ; } echo ' ' ; } }else{ echo ' ' ; } ?>

	> > > >				> > > >
'.dataFilter($row_page['staff_name']).' ( '.dataFilter($row_page['staff_idno']).' )	'.ucwords($row_page['leave_type']).'	'.dataFilter($row_page['leave_from']).' ~ '.dataFilter($row_page['leave_to']).' ('.dataFilter($row_page['leave_day']).')	' ; if ( $row_page['leave_file'] != '' ){ echo ' ' ; } echo '	'.dataFilter($row_page['leave_reason']).'	'.$button.'	'.resetDateFormat($row_page['created_at']).'	'.resetDateFormat($row_page['updated_at']).'
'.$lang['no_data'].'