72 lines
1.7 KiB
PHP
72 lines
1.7 KiB
PHP
<?php
|
|
include '../connect/cms-config.php' ;
|
|
include '../requires/function.php' ;
|
|
|
|
|
|
$select = $mysqli->query( "SELECT task_id, task_so, task_type, created_by, assigned_by, date_start FROM task
|
|
WHERE deleted_at IS NULL AND status IN ( 'pending', 'assigned', 'resubmit', 'progress' )" ) ;
|
|
if ( $select->num_rows > 0 ){
|
|
|
|
while ( $row = $select->fetch_assoc() ){
|
|
|
|
// '1time','daily','weekly','monthly','yearly'
|
|
|
|
$task_so = $row['task_so'] ;
|
|
$title = 'Task Reminder' ;
|
|
$message = 'Friendly reminder task ( '.$task_so.' ) haven\'t completed yet' ;
|
|
|
|
$date_start = strtotime( $row['date_start'] ) ;
|
|
|
|
$boolean = false ;
|
|
switch ( $row['task_type'] ){
|
|
case '1time' :
|
|
case 'daily' :
|
|
$boolean = true ;
|
|
break ;
|
|
case 'weekly' :
|
|
if ( date( 'w', $date_start ) == date( 'w', time() ) ){
|
|
$boolean = true ;
|
|
}
|
|
break ;
|
|
case 'monthly' :
|
|
|
|
if ( date( 'd', $date_start ) >= date( 't', time() ){
|
|
$boolean = true ;
|
|
}else{
|
|
if ( date( 'd', $date_start ) == date( 'd', time() ) ){
|
|
$boolean = true ;
|
|
}
|
|
}
|
|
|
|
break ;
|
|
case 'yearly' :
|
|
if ( date( 'm-01', $date_start ) == date( 'm-d', time() ) ){
|
|
$boolean = true ;
|
|
}
|
|
break ;
|
|
}
|
|
|
|
if ( $boolean ){
|
|
$staffs = [] ;
|
|
$staffs[] = $row['created_by'] ;
|
|
$staffs[] = $row['assigned_by'] ;
|
|
|
|
$select_join = $mysqli->query( "SELECT staff_id FROM task_joinstaff WHERE task_id = '".$row['task_id']."'" ) ;
|
|
if ( $select_join->num_rows > 0 ){
|
|
while ( $row_join = $select_join->fetch_assoc() ){
|
|
$staffs[] = $row_join['staff_id'] ;
|
|
}
|
|
}
|
|
|
|
foreach ( $staffs as $k => $staff ){
|
|
pushToUserCron( 'task', $row['task_id'], $staff, $title, $message ) ;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
?>
|