query( $mysqli_query." ORDER BY a.view_id DESC LIMIT $start_from, " . LIMIT ) ;
// load pagination
$page_pagination = nextPrevious($product_page, LIMIT, $search_url, $mysqli_query) ;
if ( $export_excel == 'export_eae' ){
$page_export_file_name = 'Association List-';
$array_header_excel = array(
'No.',
'SO Number',
'ID',
'Name',
'Association',
'Status',
'Created At',
'Updated At'
) ;
$mysqli_export = $mysqli->query( $mysqli_query ) ;
if ( $mysqli_export->num_rows > 0 ){
$count_mysqli_export_page = 0;
while ( $mysqli_export_page = $mysqli_export->fetch_assoc() ){
$count_mysqli_export_page ++;
$array_body_excel[] = array(
$count_mysqli_export_page,
$mysqli_export_page['association_so'],
$mysqli_export_page['staff_idno'],
$mysqli_export_page['staff_name'],
dataFilter($mysqli_export_page['title']),
$mysqli_export_page['status'],
date('Y-m-d', strtotime($mysqli_export_page['created_at'])),
date('Y-m-d', strtotime($mysqli_export_page['updated_at']))
) ;
}
$count_mysqli_export_page = 0;
}
include 'export_excel_default.php';
}
// start header here
include 'requires/page_header.php';
include 'requires/page_top.php';
?>
Join Staff
| So Number |
Profile |
Staff ID |
Name |
Association |
Status |
Created At |
Updated At |
num_rows > 0 ){
while ( $row_list = $mysqli_list->fetch_array(MYSQLI_ASSOC) ){
$staff_image = ( $row_list['staff_image'] != '' ? PATH.'uploads/Staff/'.dataFilter($row_list['staff_image']) : '' ) ;
echo '
| '.dataFilter($row_list['association_so']).' |
'.( $staff_image != '' ? ' ' : '' ).' |
'.dataFilter($row_list['staff_idno']).' |
'.dataFilter($row_list['staff_name']).' |
'.dataFilter($row_list['title']).' |
'.resetStatus($row_list['status']).' |
'.resetDateFormat($row_list['created_at']).' |
'.resetDateFormat($row_list['updated_at']).' |
';
}
}else{
echo
'
| No data. |
|
|
|
|
|
|
|
';
}
?>
query( "SELECT association_id, status FROM staff_association
WHERE deleted_at IS NULL AND association_so = '".$qrcode."' LIMIT 1" ) ;
if ( $select->num_rows > 0 ){
$error = 'Invalid status' ;
$row = $select->fetch_assoc() ;
if ( $row['status'] == 'approved' ){
$error = 'Success' ;
$mysqli->query( "UPDATE staff_association SET
status = 'confirmed'
WHERE association_id = '".$row['association_id']."'" ) ;
}
}
}
$_SESSION['system_result'] = $error ;
header( "Refresh: 0;" ) ;
exit ;
}
// 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 ;
// page query
$mysqli_query = "SELECT a.association_so, a.created_at, a.updated_at, c.staff_idno, c.staff_name FROM staff_association a
LEFT JOIN association b ON ( a.association_id = b.association_id )
LEFT JOIN staff c ON ( a.staff_id = c.staff_id )
WHERE a.deleted_at IS NULL AND a.status = 'confirmed' " . $search_query ;
$mysqli_page = $mysqli->query( $mysqli_query." ORDER BY a.view_id 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' ;
?>
query( $mysqli_query." ORDER BY a.association_id 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' ;
?>