format("Y-m-d"); $prfTime = date('H:i:s'); $fullDateTime = $prfDate . " ".$prfTime; $myDate = date_create() ->format("Y-m-d"); $uniqueRefID=$user_data['u_id']; $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); if(isset($_POST['done'])){ $UpdateReferenceHeaderCode = mysql_escape_string($_POST['UpdateReferenceHeaderCode']); $myApprovalCode = mysql_escape_string($_POST['myApprovalCode']); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); //mysql_query("UPDATE prf_request_hdr SET current_status = '$myApprovalCode', dept_approval_date='$myDate' WHERE reference_code='$UpdateReferenceHeaderCode'"); mysql_query("UPDATE prf_request_detl SET `item_status` = '$myApprovalCode' WHERE header_ref_code='$UpdateReferenceHeaderCode' AND `deleted`=0 AND `item_status`!=99"); switch($myApprovalCode){ case '2': // next is GM $myKeyID = mysql_escape_string($_POST['myKeyID']); $deptHeadID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE `prf_request_hdr` SET `dept_approval_date` = '$fullDateTime',`gm_approval_date` = '$fullDateTime',`current_status`='$myApprovalCode' WHERE reference_code='$UpdateReferenceHeaderCode'"); mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `code`='$myKeyID'"); mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `po_code`='$UpdateReferenceHeaderCode' AND `uid`='$uniqueRefID'"); $myTokenKey = $UpdateReferenceHeaderCode ."-".$UpdateReferenceHeaderCode; $myToken = md5(md5($myTokenKey)); $valLink ="prfgmApproval.php"; $exID = $uniqueRefID; $randomCodeFinal = rand(100000,99999999); $randomCode = $randomCodeFinal."".$exID; $SMSMessage = "New Purchase Request has been routed to you for your approval. Click the link below to process the request: https://autohub.ph/prfgmapr.php?c=".$randomCode; $myPostLink = "https://autohub.ph/prfgmapr.php?c=".$randomCode; $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); //$result = itexmo($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); /** $result = itexmoAA($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo ''; }else if ($result == 0){ //echo "SMS Sent!"; } else{ //echo "Error Num ". $result . " was encountered!"; }*/ //####################################################################### //####################################################################### mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid,sms_link) VALUES('{$randomCode}','{$valLink}','{$UpdateReferenceHeaderCode}','{$deptHeadID}','{$myPostLink}')"); //####################################################################### //####################################################################### //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### $from = "support@autohub.ph"; $to = $empEmail; $subject = "PRF For GM Approval"; $msgBox = "Hi ".$empFName."! New Purchase Request (PRF) has been routed to you for your Approval. Click the link below to process the request: https://autohub.ph/prfgmapr.php?c=".$randomCode; $headers = "From:" . $from; mail($to,$subject,$msgBox, $headers); //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### break; //#########################################################################################################################//######################################################################################################## case '3': // Admin Approval before canvass $myKeyID = mysql_escape_string($_POST['myKeyID']); $deptHeadID = mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET `dept_approval_date`='$fullDateTime',`gm_approval_date` = '$fullDateTime',`current_status`='$myApprovalCode' WHERE reference_code='$UpdateReferenceHeaderCode'"); mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `code`='$myKeyID'"); $myTokenKey = $UpdateReferenceHeaderCode ."-".$UpdateReferenceHeaderCode; $myToken = md5(md5($myTokenKey)); $valLink ="validate.php"; $exID = $uniqueRefID; $randomCodeFinal = rand(1001,8888888); $randomCode = $randomCodeFinal."".$exID; $empUFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $empULname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $deptheadMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $deptHeadEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $reqempUFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $reqempULname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $reqdeptheadMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $reqdeptHeadEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); //######################################################################################################################### mysql_query("INSERT INTO prf_ff_message(ref_code,sender_id,message,send_to,sms,email,date,time) VALUES('{$UpdateReferenceHeaderCode}','{$uniqueRefID}','Your purchase request with reference # ".$UpdateReferenceHeaderCode." has been approved and endorsed to next approving officer ','{$requestorID}','sms','email','{$prfDate}','{$prfTime}')"); //######################################################################################################################### //######################################################################################################################### //UPDATE NEXT APPROVING OFFICER //######################################################################################################################### $SMSMessage = "New Purchase Request has been routed to you for your review. Click the link below to proccess the request: https://autohub.ph/validate.php?c=".$randomCode; $myValidateLink = "https://autohub.ph/validate.php?c=".$randomCode; //$result = itexmoAA($deptheadMobile, $SMSMessage,$MyAPIcode,$MyPasswd); //if ($result == ""){ //echo ''; //}else if ($result == 0){ //echo "SMS Sent!"; //} //else{ //echo "Error Num ". $result . " was encountered!"; //} //######################################################################################################################### //######################################################################################################################### $from = "support@autohub.ph"; $to = $deptHeadEmail; $headersH = "From:" . $from; $subject = "NEW PURCHASE REQUEST"; $msgBox = "Hi ".$empUFname."! New Purchase Request has been routed to you for your review. Click the link below to proccess the request: https://autohub.ph/validate.php?c=".$randomCode." Autohub Support"; mail($to,$subject,$msgBox, $headersH); //####################################################################### //####################################################################### mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid,sms_link) VALUES('{$randomCode}','{$valLink}','{$UpdateReferenceHeaderCode}','{$deptHeadID}','{$myValidateLink}')"); //####################################################################### //####################################################################### //######################################################################################################################### //######################################################################################################################### break; case '4': $ahgMsg ="New PRF request has been routed to AHG Admin for fina ASSET VALIDATION."; $ahgMsgSub ="PRF For Admin Approval"; $myKeyID = mysql_escape_string($_POST['myKeyID']); mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `code`='$myKeyID'"); mysql_query("UPDATE prf_request_hdr SET admin_approval_date = '$fullDateTime' ,`current_status`='4' WHERE reference_code='$UpdateReferenceHeaderCode'"); $sndSMSTOAHGAdmin = mysql_query("SELECT * FROM `prf_poapprover` WHERE `trans_type`='AHGAdmin' AND `deleted`=0"); while($snd = mysql_fetch_array($sndSMSTOAHGAdmin)){ $ahgAdminID = $snd['po_officer_id']; $ahgMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$ahgAdminID'"),0); $ahgEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$ahgAdminID'"),0); //$result = itexmoAA($ahgMobile, $ahgMsg,$MyAPIcode,$MyPasswd); mail($ahgEmail,$ahgMsgSub,$ahgMsg, $headersH); } break; } //echo ''; } ?>
NO REF. CODE DATE COMPANY DEALER REQ. CATEGOY REQ. TYPE STATUS
".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //################################################################################################################################################################################## //FOR GM APPROVAL APPEND TO TABLE $getItemHdrGM = mysql_query("SELECT *FROM `prf_request_hdr` WHERE `approving_GM_id` ='$uniqueRefID' AND `current_status`= 2 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrGM)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //################################################################################################################################################################################## //FOR GM APPROVAL APPEND TO TABLE $getItemHdrAsset = mysql_query("SELECT *FROM `prf_request_hdr` WHERE `authorizing_dept_id` ='$uniqueRefID' AND `current_status`= 3 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrAsset)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //################################################################################################################################################################################## //ADMIN DEPARTMENT $getItemHdrAsset = mysql_query("SELECT *FROM `prf_request_hdr` WHERE `approving_admin_id` ='$uniqueRefID' AND `current_status`= 3 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrAsset)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //################################################################################################################################################################################## ?>
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
Selected Record: