alert("Sorry You Don\'t Have The Permission.")'; header('Location: index.php') ; exit ; } //nav menu $active_main_menu = 'report' ; $active_sub_menu = 'year-end-cut-off' ; // keep parameter in value $page = escapeString($_GET['page']) ; $page_mode = escapeString($_GET['page_mode']) ; $type = escapeString($_GET['type']) ; $search = escapeString($_GET['search']) ; $search_name = escapeString($_GET['search_name']) ; $search_idno = escapeString($_GET['search_idno']) ; $search_year = ( ($_GET['search_year'] !='' && preg_match("/[2][0][0-9][0-9]/u", $_GET['search_year'])) ? escapeString($_GET['search_year']) : date('Y')); $export_excel = escapeString($_GET['export-excel']); $show_another_script = true ; $hide_title = false ; // page header $letter_head = getOwnerCompanyLetterHead($_SESSION['url_get_branch_admin']) ; $search_query = '' ; if( $search_name != ''){ $search_query .= " AND b.staff_name LIKE '%".$search_name."%'" ; } if( $search_idno != ''){ $search_query .= " AND b.staff_idno LIKE '%".$search_idno."%'" ; } if ( $search_year != '' && is_numeric($search_year) ) { $search_query .= " AND Year(a.created_at) = '".$search_year."'" ; }else{ $search_query .= " AND Year(a.created_at) = Year(Now())" ; } //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 $mysqli_cutoff = $mysqli->query("SELECT a.*, b.staff_name, b.staff_idno FROM staff_point_movement_cutoff a LEFT JOIN staff b ON ( a.staff_id = b.staff_id ) WHERE a.staff_id != '' AND a.deleted_at IS NULL ".$search_query." ".$user_branch_permission_sql_b." ORDER BY a.amount DESC LIMIT $start_from, ".LIMIT) ; $mysqli_cutoff_query = "SELECT a.*, b.staff_name, b.staff_idno FROM staff_point_movement_cutoff a LEFT JOIN staff b ON ( a.staff_id = b.staff_id ) WHERE a.staff_id != '' AND a.deleted_at IS NULL ".$search_query." ".$user_branch_permission_sql_b." ORDER BY a.amount DESC"; $search_url = 'page_mode=all&search_name='.$search_name.'&search_idno='.$search_idno.'&search_year='.$search_year ; $page_pagination = nextPrevious($product_page, LIMIT, $search_url, $mysqli_cutoff_query) ; if ($export_excel != '' && $export_excel == 'export_eae') { $page_export_file_name = 'Year End Cut Off Report-'; $t_title_header_excel = 'Year End Cut Off Report ('.$search_year.')'; $array_header_excel = array( 'Year', 'ID', 'Name', 'Point' ) ; $mysqli_export = $mysqli->query( $mysqli_cutoff_query ) ; if ( $mysqli_export->num_rows > 0 ){ while ( $mysqli_export_page = $mysqli_export->fetch_assoc() ){ $array_body_excel[] = array( $mysqli_export_page['cutoff_year']-1, $mysqli_export_page['staff_idno'], $mysqli_export_page['staff_name'], $mysqli_export_page['amount'] ) ; } } include 'export_excel_default.php'; } include 'requires/page_header.php'; include 'requires/page_top.php'; ?>

Prev Next Export As Excel

num_rows > 0){ while ($row_cutoff = $mysqli_cutoff->fetch_assoc()){ echo ' ' ; echo ' ' ; } }else{ echo ' ' ; } ?>


'.dataFilter($row_cutoff['cutoff_year']-1).'	'.dataFilter($row_cutoff['staff_idno']).'	'.dataFilter($row_cutoff['staff_name']).'	'.dataFilter($row_cutoff['amount']).'
'.$lang['no_data'].'

YEAR END CUT OFF