Dec 20, 2021
0
Level 1
if date difference is more than 2 echo red else echo green
THis is pure php (sorry but badly need help) I was able to get the date difference of two dates but my goal is if the date diff is more than 2 days echo it red else is green here is my code:
$query_getCreatedDate3 = "select created_date as DesignqcDate, created_date as DesignqcDate2
from lab_order_history
where order_number = ".$res_dep['order_number']." and order_status = 'tech_design_qc'";
$result_getCreatedDate = mysqli_query($con, $query_getCreatedDate3);
$row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);
$DesignqcDate2 = $row_getCreatedDate['DesignqcDate2'];
$result_getCreatedDate = mysqli_query($con, $query_getCreatedDate3);
$row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);
$query_getCreatedDate2 = "select created_date as DesigningDate, created_date as DesigningDate2
from lab_order_history
where order_number = ".$res_dep['order_number']." and order_status = 'start_design_external'";
$result_getCreatedDate = mysqli_query($con, $query_getCreatedDate2);
$row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);
$DesigningDate = $row_getCreatedDate['DesigningDate'];
$DesigningDate2 = $row_getCreatedDate['DesigningDate2'];
$DesignqcDate2=date_create($DesignqcDate2);
$DesigningDate2=date_create($DesigningDate2);
$diff=date_diff($DesignqcDate2,$DesigningDate2);
if($diff < 2){
echo '<span style="background-color:#2ecc71;border-radius: 30px;padding: 3px 5px;color: #fff;">'.$diff->format("$DesigningDate: %a Days").'</span>';
}else {
echo '<span style="background-color:#e74c3;border-radius: 30px;padding: 3px 5px;color: #fff;">'.$diff->format("$DesigningDate: %a Days").'</span>';
}
?></td>
Please or to participate in this conversation.