query( "SELECT
COUNT(a.category) as total,
a.category
FROM visitor a
WHERE a.deleted_at IS NULL AND a.updated_at LIKE '%" . $date_time . "%'
AND a.status IN ( 'rejected', 'tested-rejected' )
" . $search_query . "
GROUP BY a.category" ) ;
if ( $select_visitor->num_rows > 0 ){
while ( $row_visitor = $select_visitor->fetch_assoc() ){
$category_id = $row_visitor['category'] ;
$category_id = dataFilter( $category_id != '' ? $category_id : 'Unknown' ) ;
$reject_lists[] = [
'label' => $category_id,
'y' => floatval( $row_visitor['total'] )
] ;
}
}
// complete report
$complete_lists = [] ;
$select_visitor = $mysqli->query( "SELECT
COUNT(a.category) as total,
a.category
FROM visitor a
WHERE a.deleted_at IS NULL AND a.updated_at LIKE '%" . $date_time . "%'
AND a.status IN ( 'approved', 'tested-approved', 'visited' )
" . $search_query . "
GROUP BY a.category" ) ;
if ( $select_visitor->num_rows > 0 ){
while ( $row_visitor = $select_visitor->fetch_assoc() ){
$category_id = $row_visitor['category'] ;
$category_id = dataFilter( $category_id != '' ? $category_id : 'Unknown' ) ;
$complete_lists[] = [
'label' => $category_id,
'y' => floatval( $row_visitor['total'] )
] ;
}
}
?>