query("SELECT a.department_id, b.department_desc FROM setting_department a LEFT JOIN setting_department_translation b ON ( a.department_id = b.department_id ) WHERE a.deleted_at IS NULL AND b.lang = 'en'") ; if($mysqli_department->num_rows > 0){ while($row_department = $mysqli_department->fetch_assoc()){ $array_department[$row_department['department_id']] = $row_department['department_desc']; } } $array_staff = []; $mysqli_staff = $mysqli->query("SELECT staff_id,staff_name FROM staff WHERE deleted_at is null"); if($mysqli_staff->num_rows > 0){ while($row_staff = $mysqli_staff->fetch_assoc()){ $array_staff[$row_staff['staff_id']] = $row_staff['staff_name']; } } // keep parameter in value $page = escapeString($_GET['page']) ; $page_mode = escapeString($_GET['page_mode']) ; $type = escapeString($_GET['type']) ; $search = escapeString($_GET['search']) ; $search_staffid = escapeString($_GET['search_staffid']) ; $search_mode = escapeString($_GET['search_mode']) ; // active menu bar $active_main_menu = 'task' ; $active_sub_menu = 'task-list' ; $active_menu = 'task-list' ; // mode type | all list | new | edit switch($page_mode){ //view item case 'view': //define initial data $department_name = $staff_name_created = $staff_name_assigned = '-'; $staff_name_executed = [] ; //get all data $mysqli_page = $mysqli->query("SELECT * FROM task WHERE task_id = '".$page."' "); if($mysqli_page->num_rows > 0){ $row_page = $mysqli_page->fetch_assoc(); //handle task status $status = taskStatusButton($row_page['status']); //handle task difficulty $difficulty_color = setDifficulty($row_page['difficulty']); $task_type = resetTaskType($row_page['task_type']); //todo summary if($row_page['todo_list'] > 0){ $todo = $row_page['todo_done'].' / '.$row_page['todo_list']; }else{ $todo = '-'; } //get department name if($row_page['department_id'] != '' && $row_page['department_id'] != '0'){ $department_name = getDepartmentName($row_page['department_id']); } //get create task staff if($row_page['created_by'] != '' && $row_page['created_by'] != '0'){ $staff_name_created = getStaffName($row_page['created_by']); } //get assign task staff if($row_page['assigned_by'] != '' && $row_page['assigned_by'] != '0'){ $staff_name_assigned = getStaffName($row_page['assigned_by']); } //get execute task staff $select_executed = $mysqli->query( "SELECT staff_id FROM task_joinstaff WHERE task_id = '".$page."'" ) ; if ( $select_executed->num_rows > 0 ){ while ( $row_executed = $select_executed->fetch_assoc() ){ $staff_name_executed[] = getStaffName($row_executed['staff_id']); } } //get reject task staff if($row_page['rejected_by'] != '' && $row_page['rejected_by'] != '0'){ $staff_name_rejected = getStaffName($row_page['rejected_by']); } //get all todo list $mysqli_todo = $mysqli->query("SELECT * FROM task_todo WHERE task_id = '".$page."' AND deleted_at IS NULL ORDER BY sortable ASC, todo_id ASC"); $mysqli_rejected = $mysqli->query("SELECT * FROM task_rejected WHERE task_id='".$page."' AND deleted_at IS NULL"); } // start header here include 'requires/page_header.php'; include 'requires/page_top.php'; ?>

<?= implode( "\n", $staff_name_executed ) ?>

num_rows > 0 ){ while( $row_todo = $mysqli_todo->fetch_assoc() ){ $staff_name_done = '-'; if($row_todo['is_done'] == 'yes'){ $is_done = ''; }else{ $is_done = ''; } //get create task staff if($row_todo['done_by'] != '' && $row_todo['done_by'] != '0'){ $staff_name_done = getStaffName($row_todo['done_by']); } $mysqli_image = $mysqli->query("SELECT file, filetype FROM task_media WHERE todo_id = '".$row_todo['todo_id']."' AND deleted_at IS NULL") ; $mysqli_remark = $mysqli->query("SELECT title FROM task_todo_remark WHERE todo_id = '".$row_todo['todo_id']."' AND deleted_at IS NULL") ; echo ' '; } } ?>


'.dataFilter($row_todo['title']).'	'.$is_done.'	'.$staff_name_done.'	'.resetDateFormat($row_todo['done_at']).'	' ; if( $mysqli_image->num_rows > 0 ){ while( $row_image = $mysqli_image->fetch_assoc() ){ switch ( $row_image['filetype'] ){ case 'jpg' : case 'jpeg' : case 'png' : echo ' ' ; break ; default : echo ' ' ; } } }else{ echo '-'; } echo '	' ; if( $mysqli_remark->num_rows > 0 ){ while( $row_remark = $mysqli_remark->fetch_assoc() ){ echo $row_remark['title'].' '; } }else{ echo '-'; } echo '

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


'.dataFilter($row_rejected['title']).'	'.resetDateFormat($row_rejected['done_at']).'	'.dataFilter($row_rejected['remark']).'
'.$lang['no_data'].'

query("UPDATE task SET deleted_at = '".TODAYDATE."' WHERE task_id = '".$_GET['id']."' ") ; header('Location: '.PATH.'task.php?page_mode=list'); } // 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.'&search_staffid='.$search_staffid.'&search_mode='.$search_mode ; // page query $mysqli_query = "SELECT * FROM task a WHERE a.deleted_at IS NULL " . $search_query.$user_branch_permission_sql_task ; // print_r($mysqli_query);exit; // export excel if ( $export == 'yes' ){ include 'PhpExcel/PHPExcel.php' ; $page_filename = 'Task-'.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, 'Excel5' ) ; // default parameter $count = 1 ; $char = 'A' ; $count_staff = 1 ; $array_title = array( 'No.', 'Task', 'Task Type', 'Status', 'Department','Created By', 'Difficulty','Todo','start date','End Date','Created At' ) ; $newChar = $char ; foreach( $array_title as $k => $v ){ $objPHPExcel->setActiveSheetIndex(0)->setCellValue( $newChar.$count, $v ) ; $newChar++ ; } $count++ ; $redeem_q = $mysqli->query( $mysqli_query ) ; if ( $redeem_q->num_rows > 0 ){ while ( $redeem_page = $redeem_q->fetch_assoc() ){ // default variable $id = $redeem_page['task_id'] ; //handle task status $status = $redeem_page['status']; //handle task difficulty $difficulty_color = setDifficulty($redeem_page['difficulty']); $task_type = resetTaskType($redeem_page['task_type']); //get department name if($redeem_page['department_id'] != '' && $redeem_page['department_id'] != '0'){ $department_name = getDepartmentName($redeem_page['department_id']); } //get create task staff if($redeem_page['created_by'] != '' && $redeem_page['created_by'] != '0'){ $staff_name_created = getStaffName($redeem_page['created_by']); } $todo = $redeem_page['todo_done'].' / '.$redeem_page['todo_list']; $newChar = $char ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, $count_staff ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($redeem_page['title']) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, $task_type ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, ucfirst($status) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($department_name != '' ? $department_name : 'Cross Department') ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($staff_name_created) ) ; $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($redeem_page['difficulty']) ); $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, dataFilter($todo) ); $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, resetDateFormat($redeem_page['date_start']) ); $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, resetDateFormat($redeem_page['date_end']) ); $objPHPExcel->setActiveSheetIndex(0)->setCellValue( ($newChar++).$count, resetDateFormat($redeem_page['created_at']) ) ; $count++ ; $count_staff++ ; } } header( 'Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8' ) ; header( 'Content-Disposition: attachment;filename="'.$page_filename.'.xls"' ) ; header( 'Cache-Control: max-age=0' ) ; // save to pc ob_clean(); $objWriter->save('php://output') ; header( "Refresh: 0" ) ; exit ; } // print_r($mysqli_query);exit; $mysqli_page = $mysqli->query( $mysqli_query." ORDER BY a.task_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' ; ?>

View Type

listing

num_rows > 0){ while ($row_page = $mysqli_page->fetch_array(MYSQLI_ASSOC)){ // default variable $id = $row_page['task_id'] ; //handle task status $status = taskStatusButton($row_page['status']); //handle task difficulty $difficulty_color = setDifficulty($row_page['difficulty']); $task_type = resetTaskType($row_page['task_type']); //get department name if($row_page['department_id'] != '' && $row_page['department_id'] != '0'){ $department_name = getDepartmentName($row_page['department_id']); } //get create task staff if($row_page['created_by'] != '' && $row_page['created_by'] != '0'){ $staff_name_created = getStaffName($row_page['created_by']); } $todo = $row_page['todo_done'].' / '.$row_page['todo_list']; echo ' '; } }else{ echo ' ' ; } ?>


'; if($row_user['user_permission'] == 'admin' \|\| permissionCheck($row_user, 'task-list-trash')){ echo'\| '; } echo'	'.dataFilter($row_page['title']).'	'.$task_type.' '.$status.'	'.dataFilter($department_name != '' ? $department_name : 'Cross Department').'	'.dataFilter($staff_name_created).'	'.dataFilter($row_page['difficulty']).'	'.dataFilter($todo).'	'.resetDateFormat($row_page['date_start']).'	'.resetDateFormat($row_page['date_end']).'	'.resetDateFormat($row_page['created_at']).'	'.resetDateFormat($row_page['updated_at']).'
'.$lang['no_data'].'