format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myPONumber = mysql_escape_string($_POST['myPONumber']); $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); $myTokenKey = $myPONumber ."-".$myPONumber; $myToken = md5(md5($myTokenKey)); $poChecker = mysql_result(mysql_query("SELECT `po_officer_id` FROM `prf_poapprover` WHERE `trans_type`='Checker'"),0); mysql_query("UPDATE `prf_request_detl` SET `po_code_posted`='1', `item_status`='8' WHERE `po_code`='$myPONumber'"); mysql_query("UPDATE `prf_purchase_order` SET `token`='$myToken', `checked_by`='$poChecker', `date_posted`='$prfDate', `po_status`='1' WHERE `po_number`='$myPONumber'"); $getPOApprovingOfficers=mysql_query("SELECT vts_users.`u_id`,vts_users.`u_fname`,vts_users.`u_lname`,vts_users.`usr_mobile`, prf_poapprover.`comp_id`,prf_poapprover.`po_officer_id`,prf_poapprover.`authority` FROM prf_poapprover JOIN vts_users ON vts_users.`u_id` = prf_poapprover.`po_officer_id` WHERE prf_poapprover.`deleted`=0 AND prf_poapprover.`trans_type`='Checker'"); while($xRow = mysql_fetch_array($getPOApprovingOfficers)){ $exID = $xRow['u_id']; $SMSMessage = "Purchase Order (PO) has been routed to you for PO Validation prior to Approval https://www.autohub.ph/connect/home/prfpovalidation.php?uid=".$exID."&id=".$myPONumber."&token=".$myToken; $empMobile = $xRow['usr_mobile']; //$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!"; } echo ""; } echo ""; //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### $totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`=1 "),0); $noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); $myPageCount = ceil($totalRows / $noOfRecordPerPage); $offSet = 0;//($myPageCount-1) * $noOfRecordPerPage; echo ""; echo ""; echo ""; echo ""; //####################################################################################################### //####################################################################################################### //SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1 $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 1 || `po_status`= 0 ORDER BY `id` DESC LIMIT $offSet, $noOfRecordPerPage "); while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $reqCompID=$row['comp_id']; $reqDealID=$row['dealer_id']; $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0); ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$row['po_number']."

".$row['date_created']."

".$row['date_posted']."

".$reqCompName."

".$reqDealName."

".$vendorName."

".$row['terms']." Days

"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"

".$row['remarks']."

"; } ?>