= DATEADD(day,-7, GETDATE()) // $color=''; // $name = getFieldFromTable('patient_name', 'patient_master', 'id', $row['emp_id']); // $task = getFieldFromTable('checkup_type_name','checkup_type', 'checkup_type_id', $row['task']); // $checkup_date = date_format(date_create($row['checkup_date']), "d-M-Y"); // $deu_date = date("d-m-Y", strtotime($row['deu_date'])); // $today= date('d-m-Y'); // if( strtotime($today) > strtotime($deu_date) ){ $color='#e505055c'; } // else {$color='white';} // error_log( $row['checkup_id'] ."name " . $name . " task " . $task . " date checkup " . $checkup_date ." exp " . $deu_date . " color " . $color); ?>
Sr. Ecode/Gpass Name Department Diagosis Due Date