File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/prf_CanvassAwardToVendor.php

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $uid = mysql_escape_string($_POST['uid']); $ExecomSelectedCanvassID = mysql_escape_string($_POST['ExecomSelectedCanvassID']); $selectedVendorAmount = mysql_escape_string($_POST['selectedVendorAmount']); $selectedVendorQty = mysql_escape_string($_POST['selectedVendorQty']); $canvassCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$ExecomSelectedCanvassID'"),0); $canvassID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$ExecomSelectedCanvassID'"),0); $canvassVendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$canvassID'"),0); $prfCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $itemDes = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$prfCode'"),0); $chkIfWithMyApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$uid'"),0); if($chkIfWithMyApproval!=0){ echo '<script>alert("ERROR: You already approved this request. Waiting for other EXECOM to approve this transaction.")</script>'; }else{ mysql_query("INSERT INTO `prf_execomcanvassapproval`(prf_ref_code,canvass_id,item_code,vendor_id,canvass_qty,approved_amount,approved_by_execom,notes,date_approved,time_approved) VALUES('{$prfCode}','{$ExecomSelectedCanvassID}','{$itemID}','{$canvassVendorID}','{$selectedVendorQty}','{$selectedVendorAmount}','{$uid}','{$notes}','{$myDate}','{$prfTime}')"); $getEXECOMAuthority = mysql_result(mysql_query("SELECT `authority` FROM `prf_execommembers` WHERE `execom_id`='$uid'"),0); $chkExecomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"),0); if($getEXECOMAuthority == 1){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'"); $messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO"; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')"); } if($getEXECOMAuthority == 2){ if($chkExecomApproval == 2){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'"); $messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO"; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')"); } else{ $messageToReqB ="You ".$itemDes." request has been endorsed by EXECOM. Please wait for another EXECOM to approved your request before we proceed with the PO. "; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfCode}','{$uid}','{$messageToReqB}','{$requestorID}','{$myDate}','{$prfTime}')"); } } if($getEXECOMAuthority == 3){ if($chkExecomApproval == 3){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'"); $messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO"; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')"); } else{ $messageToReqB ="You ".$itemDes." request has been endorsed by EXECOM. Please wait for another EXECOM to approved your request before we proceed with the PO. "; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfCode}','{$uid}','{$messageToReqB}','{$requestorID}','{$myDate}','{$prfTime}')"); } } //CHECK IF ALL ITEMS IN THE PRF HAS BEEN APPROVED $chekItemCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`=0"),0); $chekItemCountApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`=0 AND `execom_approval_ts`!=''"),0); if($chekItemCount = $chekItemCountApproval){ mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$canvassCode'"); mysql_query("UPDATE `prf_request_detl` SET `item_status`='7' WHERE `id`='$itemID'"); }else{ mysql_query("UPDATE `prf_request_detl` SET `item_status`='6' WHERE `id`='$itemID'"); } //mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$canvassCode'"); } echo '<script>alert("Purchase Request has been approved.")</script>'; ?> <table class='tableItem' id='LoadUserApprovedCanvassItemX' > <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_approval_ts`=''"); while($row=mysql_fetch_array($getItemHdr)){ $itmID=$row['id']; $reqNameID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $catID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $SubcatID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $Category = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='".$catID."'"),0); $ProposalCount = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `item_id`='$itmID'"),0); $reqNameFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); $reqNameLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); ?><tr onclick="javascript:getInfoX(this);" ><?php echo "<td style='background:white'>"; echo "<div class='itemDisplay'>"; echo "<div style='float:left;width:100%;height:10px;font-family:Yu Gothic Light;font-size:2.5vw;color:gray;'></div>"; echo "<div style='float:left;width:21%;color:black;padding-left:10px;' class='ApproverView'>Record ID: <input disabled type='text' value='".$row['id']."' id='itemID' class='textClass'></div>"; echo "<div style='float:left;width:45%;' class='ApproverView'>Requestor: <input disabled type='text' value='".$reqNameLName. ", ".$reqNameFName."' id='requestorName' class='textClass'></div>"; echo "<div style='float:left;width:30% ' class='ApproverView'>Date Needed: <input disabled type='text' value='".$dateNeeded."' id='dateNeeded' class='textClass'></div>"; echo "<div style='margin-top:15px;margin-bottom:15px;float:left;width:96%; padding-left:10px' class='ApproverView'>Item Description: <textarea rows='1' disabled id='itemDescription' class='textClass' style='padding:5px;border:1px solid lightgray;background:white'>".$row['item_description']."</textarea></div>"; echo "<div style='float:left;width:56%;padding-left:10px' class='ApproverView'>Category: <input disabled type='text' value='".$Category."' id='itemCategory' class='textClass'></div>"; echo "<div style='float:left;width:20%;' class='ApproverView'>Quantity: <input disabled type='text' value='".$row['quantity']."' id='requestorName' class='textClass'></div>"; echo "<div style='float:left;width:20%;' class='ApproverView'>Proposal: <input disabled type='text' value='".$ProposalCount."' id='dateNeeded' class='textClass'></div>"; echo "<div style='float:left;width:100%;height:10px;font-family:Yu Gothic Light;font-size:2vw;color:gray'></div>"; echo "<div style='float:left;width:100%;height:1px;font-family:Yu Gothic Light;background: #fdae8b'></div>"; echo "</div>"; echo "</td>"; echo "</tr>"; echo "<tr><td style='text-align:center;background:white;padding:5px;padding-top:0px'> <p class='viewRequest'>View Request</p></td></tr>"; } ?> </table> <?php } ?> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== //====================================================================================================== $("#LoadUserApprovedCanvassItemX").click(function(){ var itemID = $("#itemID").val(); //alert(itemID); showCanvassInfo(); //exit; ShowUploadBar(); $.ajax({ url: "prf_loadCanvassSheetWithApprovedByUser.php", type: "POST", async: false, data: { "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#itemCanvassList").html(d); } }) }); }); </script> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <script type="text/javascript"> function hideCanvassInfo(){ $("#CanvassInfoForm").fadeOut(500); }; function showCanvassInfo(){ $("#CanvassInfoForm").fadeIn(500); }; function getInfoX(row) { var x=row.cells; document.getElementById("selectedPRFHeaderID").value = x[1].innerHTML; document.getElementById("SeletedPRFItemID").value = x[0].innerHTML; } </script>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings