| ITEM ID | DATE START | TODAYS DATE | DAYS LAPSE | VALID | SIGNED BY R.A |
|---|
| ".$row['id']." | "; echo "".$row['canvass_sheet_creation_ts']." | "; echo "".$curDateTime." | "; $startDate = strtotime($prfDate); $EndDate = strtotime($row['canvass_sheet_creation_ts']); $datediff = $startDate - $EndDate; $mandays = round($datediff / (60 * 60 * 24)); echo "".$mandays." | "; echo ""; if($mandays ==0){ echo "Active"; } if($mandays ==1){ echo "Sending FF Reminder 1"; } if($mandays ==2){ //############################################################################################################## $exeApproverEmail =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); //SEND EMAIL NOTIFICATIONS $from = "support@autohub.ph"; $to = $exeApproverEmail; $subject = "PENDING CANVASS APPROVAL"; $SMSMessage = "This is to remind you of your pending CANVASS APPROVAL. The system will Automatically approve this request within 48 hours. please login to your ASA APP for more details. Thank you!"; $headers = "From:" . $from; mail($to,$subject,$SMSMessage, $headers); //######################################END OF EMAIL $exeApproverMobile =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); $result = itexmoAA($exeApproverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo ''; }else if ($result == 0){ //echo "SMS Sent!"; }else{ //echo "Error Num ". $result . " was encountered!"; } //NOTIFICATION####################################################### } if($mandays ==3){ //############################################################################################################## $exeApproverEmail =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); //SEND EMAIL NOTIFICATIONS $from = "support@autohub.ph"; $to = $exeApproverEmail; $subject = "PENDING CANVASS APPROVAL"; $SMSMessage = "This is to remind you of your pending CANVASS APPROVAL. The system will Automatically approve this request within 24 hours. please login to your ASA APP for more details. Thank you!"; $headers = "From:" . $from; mail($to,$subject,$SMSMessage, $headers); //######################################END OF EMAIL NOTIFICATION####################################################### $exeApproverMobile =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); $result = itexmoAA($exeApproverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo ''; }else if ($result == 0){ //echo "SMS Sent!"; }else{ //echo "Error Num ". $result . " was encountered!"; } } if($mandays > 3){ echo "Execute Automation "; } echo " | "; echo "";
$itemID = $row['id'];
$getItemAmountFromCanvassSheet = mysql_result(mysql_query("SELECT MIN(`amount`) FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0);
echo $itemID . " | ";
$chckIfWithApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0);
$aprMatrix = mysql_result(mysql_query("SELECT `level` FROM `prf_approval_matrix` WHERE '$getItemAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0);
echo "My Matrix: ". $aprMatrix ." "; if($aprMatrix < 5){ //execom approval if($chckIfWithApproval > 0){ //execute automated approval //echo $chckIfWithApproval; $approvedQTY = mysql_result(mysql_query("SELECT `canvass_qty` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedAmount= mysql_result(mysql_query("SELECT `approved_amount` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedVendorID= mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedCanvassID= mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); echo " ".$approvedQTY. " "; echo $approvedAmount. " "; echo $approvedVendorID. " "; echo $approvedCanvassID. " "; if($approvedVendorID ==''){$errorD=$errorD + 1;} if($approvedCanvassID ==''){$errorD=$errorD + 1;} if($errorD == 0){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$curDateTime', `awarded`=1, `award_to_vendor_id`='$approvedVendorID', `approved_proposal_code`='$approvedCanvassID',`approved_qty`='$approvedQTY',`approved_amount`='$approvedAmount',`item_status`=7,`approval_type`='auto' WHERE `id`='$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `item_id`='$itemID' AND `link` LIKE '%exapr.php%'"); } }else{ echo "Pending ".$chckIfWithApproval; } }else{ //department head approval $approvedQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedAmount=mysql_result(mysql_query("SELECT `amount` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedCanvassID= mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedVendorID= mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$approvedCanvassID'"),0); echo " QTY:".$approvedQTY; echo " Amount:".$approvedAmount; echo " Vendor:".$approvedVendorID; echo " Canvass:".$approvedCanvassID; if($approvedVendorID ==''){$errorC=$errorC + 1;} if($approvedCanvassID ==''){$errorC=$errorC + 1;} if($errorC == 0){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$curDateTime', `awarded`=1, `award_to_vendor_id`='$approvedVendorID', `approved_proposal_code`='$approvedCanvassID',`approved_qty`='$approvedQTY',`approved_amount`='$approvedAmount',`item_status`=7,`approval_type`='auto' WHERE `id`='$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `item_id`='$itemID' AND `link` LIKE '%exapr.php%'"); } } echo " | ";
echo "";
}
?>