File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_CreateCanvassSheet.php

Back
<?php include 'core/init.php'; $activeID=$user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); //echo "Date: ". $prfDate; if(isset($_POST['done'])){ $myCanvassPRFCode = mysql_escape_string($_POST['myCanvassPRFCode']); $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); $getCompanyID = mysql_result(mysql_query("SELECT comp_id FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $getCompanyName = mysql_result(mysql_query("SELECT comp_name FROM vts_company WHERE comp_id='$getCompanyID'"),0); echo "<input type='hidden' id='myPRFNum' value='".$myCanvassPRFCode."'>"; $itemDesc = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$ItemRecordID'"),0); $itemQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_request_detl` WHERE `id`='$ItemRecordID'"),0); $itemUoM = mysql_result(mysql_query("SELECT `uom` FROM `prf_request_detl` WHERE `id`='$ItemRecordID'"),0); $proposalCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_canvass_sheet` WHERE `item_id`='$ItemRecordID'"),0); } ?> <div style='float:left;width:98.5%;padding:2px;height:80px;margin:5px;box-shadow: #e5e5e1 3px 3px;background:white;border:1px solid gray'> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color:white;background:black;margin:0px;padding:1px;float:left;width:76%'>Requested Item:</p> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color:white;background:black;margin:0px;padding:1px;float:left;width:12%'>Quantity</p> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color:white;background:black;margin:0px;padding:1px;float:left;width:12%'>UoM</p> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color: #363632 ;background:white;margin:0px;padding:2px;float:left;width:76%;padding-top:15px;padding-left:20px'><?php echo $itemDesc;?></p> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color: #363632 ;background:white;margin:0px;padding:2px;float:left;width:12%;padding-top:15px;padding-left:10px'><?php echo $itemQTY;?></p> <p style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;color: #363632 ;background:white;margin:0px;padding:2px;float:left;width:12%;padding-top:15px;padding-left:10px'><?php echo $itemUoM;?></p> </div> <div style='float:left;width:98.5%;padding:2px;height:180px;margin:5px;box-shadow: #e5e5e1 3px 3px;background:white;border:1px solid gray'> <p style='font-family:Yu Gothic Light;font-size:16px;font-weight:bold;color:white;background:black;margin:0px;padding:3px'>Active Proposal</p> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:10%;font-size:12px;padding:3px'>DATE ADDED</th> <th style='width:12%;font-size:12px;padding:3px'>CANVASS CODE</th> <th style='width:13%;font-size:12px;padding:3px'>VENDOR CODE</th> <th style='width:30%;font-size:12px;padding:3px'>VENDOR NAME</th> <th style='width:10%;font-size:12px;padding:3px'>VALIDITY</th> <th style='width:20%;font-size:12px;padding:3px'>UPLOADED BY</th> <th style='width:5%;font-size:12px;padding:3px'></th> </thead> </table> </div> <div id='activeProposals' style='width:100%;height:100px;background:white;overflow:fixed'> <table> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_uploadedcanvass` WHERE `deleted`=0 AND `validity_date` > '$prfDate' AND `notes` LIKE '%$UpdatePRFReferenceNumber%'"); while($cRow = mysql_fetch_array($getActiveProposals)){ $cvID = $cRow['id']; $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `canvass_id`='$cvID' AND `item_id`='$ItemRecordID'"),0); if($checkIfExist==0){ $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getCanvassInfo(this);" onDblClick="javascript:showEndorseForm(this);"><?php echo "<td style='width:10.5%;font-size:11px;padding:3px;color:black'>".$cRow['date_added']."</td>"; echo "<td style='width:12%;font-size:11px;padding:3px;color:black'>".$cRow['ref_code']."</td>"; echo "<td style='width:13.5%;font-size:11px;padding:3px;color:black'>".$cRow['vendor_code']."</td>"; echo "<td style='width:30.5%;font-size:11px;padding:3px;color:black'>"; $uploadVCode = $cRow['vendor_code']; $supName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE sup_code='$uploadVCode'"),0); echo strtoupper($supName); echo "</td>"; echo "<td style='width:10%;font-size:11px;padding:3px;color:black'>".$cRow['validity_date']."</td>"; echo "<td style='width:20%;font-size:11px;padding:3px;color:black'>"; $uploadID = $cRow['uploaded_by']; $upFname = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadID'"),0); $upLname = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadID'"),0); echo strtoupper($upLname). ", ".strtoupper($upFname); echo "</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } } ?> </table> </div> </div> <div style='float:left;width:98.5%;padding:2px;height:180px;margin:5px;box-shadow: #e5e5e1 3px 3px;background:white;border:1px solid gray'> <p style='font-family:Yu Gothic Light;font-size:16px;font-weight:bold;color:white;background:black;margin:0px;padding:3px'>Endorsed Proposals</p> <div style='width:100%;height:33px;background:white;margin:0px'> <table> <thead> <th style='width:15%;font-size:12px;padding:3px'>CANVASS CODE</th> <th style='width:15%;font-size:12px;padding:3px'>VENDOR CODE</th> <th style='width:40%;font-size:12px;padding:3px'>VENDOR NAME</th> <th style='width:10%;font-size:12px;padding:3px'>QTY</th> <th style='width:15%;font-size:12px;padding:3px'>AMOUNT</th> <th style='width:5%;font-size:12px;padding:3px'></th> </thead> </table> </div> <div id='endorsedProposals' style='width:100%;height:109px;background:white;overflow:auto;margin:0px'> <table> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_canvass_sheet` WHERE `deleted`=0 AND item_id='$ItemRecordID'"); while($csRow = mysql_fetch_array($getActiveProposals)){ $cvsID = $csRow['id']; $cvID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$cvsID'"),0); $venCode = mysql_result(mysql_query("SELECT `vendor_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $venName = mysql_result(mysql_query("SELECT `vendor_name` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getEndorsedCanvassInfo(this);" onDblClick="javascript:showRemoveCanvassOption(this);"><?php echo "<td style='width:15%;font-size:11px;padding:3px;color:black'>".$cvCode."</td>"; echo "<td style='width:15%;font-size:11px;padding:3px;color:black'>"; echo $venCode; echo "</td>"; echo "<td style='width:40%;font-size:11px;padding:3px;color:black'>"; echo strtoupper($venName); echo "</td>"; echo "<td style='width:10%;font-size:11px;padding:3px;color:black;text-align:center'>".$csRow['quantity']."</td>"; echo "<td style='width:15%;font-size:11px;padding:3px;color:black;text-align:right'>".$csRow['amount']."</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> </div> <div style='float:right;width:50%;padding:5px;height:50px;margin:0px;background:white;border:0px solid gray'> <button onclick="javascript:hideUpdatePRFForm(this);"class='PopUpLowerButtonR' style='width:120px;float:right' >📑  CLOSE</button> <button onclick="javascript:showCreatedCanvassForm(this);" id='createCanvassSheet' class='PopUpLowerButtonR' style='width:220px;float:right' >🗒  FOR USER APPROVAL</button> </div> <!--########################## POPUP FOR ENDORSING CANVASS TO GENERATE CANVASS SHEET ############################################--> <!--###################################################################################################################################--> <div id="showAssignedCanvass" class="DelPopUpActionWindow" style='height:315px'> <div class='DelPopUpWindowTitle'> 🪧 REMOVE ENTRY <div class='PopUpWindowClose'> <b onclick="javascript:hideRemoveCanvassOption(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;width:100%;background:white;font-family:Yu Gothic; font-size:12px;color: #161615 ;height:130px;font-weight:normal;text-align:left'> <div style='float:left;width:49%;'>CANVASS CODE:<input disabled type='text' id='ENmyCanvassCode' style='margin-right:2px;'></div> <div style='float:left;width:49%;'>VENDOR CODE:<input disabled type='text' id='ENmyVendorCode' style='margin-left:3px;'></div> <div style='float:left;width:99%;margin-top:5px;'>ITEM DESCRIPTION:<br><textarea disabled rows='2' id='itemDesc' style='width:100%;padding:3px'><?php echo $itemDesc;?></textarea></div> <div style='float:left;width:10%;margin-top:5px;padding-top:10px'>QTY</div> <div style='float:left;width:20%;margin-top:5px;'><input type='text' id='ENitemQTY' value='<?php echo $itemQTY;?>' style='margin-right:5px;text-align:center'></div> <div style='float:left;width:15%;margin-top:5px;margin-left:50px;;padding-top:10px'>AMOUNT:</div> <div style='float:left;width:39%;margin-top:5px;'><input type='text' id='ENitemAmount' style='margin-left:5px;text-align:right'></div> </td> </tr> <tr> <td colspan='1' style='padding:5px;width:250px;background:white;border-top:1px solid #161615 ;text-align:center;padding-top:3px'> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <button id='deleteEndorsedCanvass' class='PopUpLowerButtonR' style='width:40%;float:right'>❌      Delete</button> </div> </td> </tr> </table> </div> <!--########################## POPUP FOR ENDORSING CANVASS TO GENERATE CANVASS SHEET ############################################--> <!--###################################################################################################################################--> <div id="showEndorseCanvassForm" class="PopUpActionWindow" style='height:450px'> <div class='PopUpWindowTitle'> 🪧 Add to Canvass Sheet <div class='PopUpWindowClose'> <b onclick="javascript:hideEndorseForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;width:100%;background:white;font-family:Yu Gothic; font-size:12px;color: #161615 ;height:130px;font-weight:normal;text-align:left'> <div style='float:left;width:49%;'>CANVASS CODE:<input disabled type='text' id='myCanvassCode' style='margin-right:2px;'></div> <div style='float:left;width:49%;'>VENDOR CODE:<input disabled type='text' id='myVendorCode' style='margin-left:3px;'></div> <div style='float:left;width:99%;margin-top:5px;'>ITEM DESCRIPTION:<br><textarea disabled rows='3' id='itemDesc' style='width:100%;padding:3px'><?php echo $itemDesc;?></textarea></div> <div style='float:left;width:99%;margin-top:5px;'>SPECIFICATIONS(Optional):<br> <textarea rows='3' id='itemSpecs' style='width:100%;padding:3px'></textarea> </div> <div style='float:left;width:25%;margin-top:5px;margin-left:10px;;padding-top:10px'>QUANTITY:<br> <input type='text' id='itemQTY' value='<?php echo $itemQTY;?>' onchange="javascript:computeAmount()" style='margin-right:5px;text-align:center;margin-top:0px'> </div> <div style='float:left;width:30%;margin-top:5px;margin-left:10px;;padding-top:10px'>AMOUNT / UNIT:<br> <input type='text' id='itemAmount' value='' onchange="javascript:computeAmount()" style='margin-right:5px;text-align:center;margin-top:0px'> </div> <div style='float:left;width:30%;margin-top:5px;margin-left:10px;;padding-top:10px'>TOTAL AMOUNT:<br> <input type='text' id='totalAmount' disabled style='margin-right:5px;text-align:center;margin-top:0px'> </div> </td> </tr> <tr> <td colspan='1' style='padding:5px;width:250px;background:white;border-top:1px solid #161615 ;text-align:center;padding-top:3px'> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <button id='setEndorsedCanvass' class='PopUpLowerButtonR' style='width:40%;float:right'>✅      Endorse</button> </div> </td> </tr> </table> </div> <!--########################## POPUP FOR ENDORSING CANVASS TO GENERATE CANVASS SHEET ############################################--> <!--###################################################################################################################################--> <div id="showGenCanvassForm" class="PopUpActionWindow" style='height:300px'> <div class='PopUpWindowTitle'> 🪧 User Approval <div class='PopUpWindowClose'> <b onclick="javascript:hideCreatedCanvassForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div id='loadCanvassItem' style='padding:10px;width:100%;height:200px;background:white;'> <div style='float:left;width:100%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'><b style='font-size:14px;color:black'>Item Description:</b><br><div style='width:100%;min-height:60px;padding:3px;border:1px solid lightgray;'><?php echo $itemDesc;?></div></div> <div style='float:left;width:50%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemQTY'><b style='font-size:14px;color:black'>Quantity:</b><br> <?php echo "<input type='text' style='width:100%;padding:3px;text-align:center' disabled id='reqQuantity' value='".$itemQTY."'>";?> </div> <div style='float:left;width:50%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue'><b style='font-size:14px;color:black'>Active Proposal:</b><br> <input type='text' id='cvsCount' style='width:100%;padding:3px;text-align:center' value='<?php echo $proposalCount;?>'></div> </div> <div style='width:100%;height:55px;background:white;padding:10px'> <button id='sendToUser' class='PopUpLowerButtonR' style='width:63%;float:right;padding-left:20px'>➕   SEND TO USER</button> <button onclick="javascript:hideCreatedCanvassForm();" class='PopUpLowerButtonR' style='width:30%;float:left'>⬅   CLOSE</button> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <script type="text/javascript"> function hideCreatedCanvassForm(){ $("#showGenCanvassForm").fadeOut(500); }; function showCreatedCanvassForm(){ $("#showGenCanvassForm").fadeIn(500); }; function hideEndorseForm(){ $("#showEndorseCanvassForm").fadeOut(500); }; function showEndorseForm(){ $("#showEndorseCanvassForm").fadeIn(500); }; function hideRemoveCanvassOption(){ $("#showAssignedCanvass").fadeOut(500); }; function showRemoveCanvassOption(){ $("#showAssignedCanvass").fadeIn(500); }; function computeAmount(){ //alert('test'); var itemQTY = $("#itemQTY").val(); var itemAmount = $("#itemAmount").val(); var MyTotalAmount = itemAmount * itemQTY; $('#totalAmount').val(MyTotalAmount.toFixed(2)); } function getCanvassInfo(row) { var x=row.cells; document.getElementById("myCanvassCode").value = x[1].innerHTML; document.getElementById("myVendorCode").value = x[2].innerHTML; } function getEndorsedCanvassInfo(row) { var x=row.cells; document.getElementById("ENmyCanvassCode").value = x[0].innerHTML; document.getElementById("ENmyVendorCode").value = x[1].innerHTML; document.getElementById("ENitemQTY").value = x[3].innerHTML; document.getElementById("ENitemAmount").value = x[4].innerHTML; } </script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#setEndorsedCanvass").click(function(){ var itemQTY = $("#itemQTY").val(); var itemAmount = $("#itemAmount").val(); var totalAmount = $("#totalAmount").val(); var myCanvassCode = $("#myCanvassCode").val(); var myVendorCode = $("#myVendorCode").val(); var ItemRecordID = $("#ItemRecordID").val(); var itemSpecs = $("#itemSpecs").val(); //alert(myCanvassCode); //exit; if(totalAmount < 0.01){ alert('Please type the Quantity to continue...'); exit; } if(itemQTY < 1){ alert('Please type the Quantity to continue...'); exit; } if(itemAmount < 0.01){ alert('Please type the Amount to continue...'); exit; } //if(confirm("CONFIRM ACTION: \n\n Are you sure you want to add this to your canvass sheet? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_AddToCanvassSheet.php", type: "POST", async: false, data: { "totalAmount": totalAmount, "itemQTY": itemQTY, "itemSpecs": itemSpecs, "itemAmount": itemAmount, "myCanvassCode": myCanvassCode, "myVendorCode": myVendorCode, "ItemRecordID": ItemRecordID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#endorsedProposals").html(d); hideEndorseForm(); // $('#itemQTY').val(''); $('#itemAmount').val(''); updateCanvassList(); } }) //} }); //====================================================================================================== $("#deleteEndorsedCanvass").click(function(){ var ENmyVendorCode = $("#ENmyVendorCode").val(); var ENmyCanvassCode = $("#ENmyCanvassCode").val(); var ItemRecordID = $("#ItemRecordID").val(); //alert(ENmyVendorCode); //alert(ItemRecordID); //alert(ENmyCanvassCode); //exit; ShowUploadBar(); $.ajax({ url: "PRF_DELETEEndorsedCanvass.php", type: "POST", async: false, data: { "ENmyCanvassCode": ENmyCanvassCode, "ENmyVendorCode": ENmyVendorCode, "ItemRecordID": ItemRecordID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#endorsedProposals").html(d); hideRemoveCanvassOption(); updateCanvassList(); } }) }); //====================================================================================================== $("#sendToUser").click(function(){ var cvsCount= $("#cvsCount").val(); var ItemRecordID = $("#ItemRecordID").val(); if(cvsCount < 1){ alert('ERROR: You need to endorse at least 1 proposal'); exit; } if(cvsCount < 3){ if(confirm("WARNING: \n\n You have less than 3 active proposal for this request. \n\n Proceed anyway.")){ ShowUploadBar(); $.ajax({ url: "PRF_ENDORSECanvassToUserForApproval.php", type: "POST", async: false, data: { "ItemRecordID": ItemRecordID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#reloadCanvassItem").html(d); hideRemoveCanvassOption(); updateCanvassList(); ProposalCount(); hideCreatedCanvassForm(); hideUpdatePRFForm(); Swal.fire({ position: 'top-start', icon: 'success', title: 'Canvass Sheet has been routed to user', showConfirmButton: false, timer: 2000 }) } }) } }else{ ShowUploadBar(); $.ajax({ url: "PRF_ENDORSE_Canvass_To_User_For_Approval.php", type: "POST", async: false, data: { "ItemRecordID": ItemRecordID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTable").html(d); hideRemoveCanvassOption(); updateCanvassList(); ProposalCount(); hideCreatedCanvassForm(); hideUpdatePRFForm(); Swal.fire({ position: 'top-start', icon: 'success', title: 'Canvass Sheet has been routed to user', showConfirmButton: false, timer: 2000 }) } }) } }); //====================================================================================================== function updateCanvassList(){ var ItemRecordIDLoad = $("#ItemRecordID").val(); var UpdateuReferenceID = $("#myPRFNum").val(); //alert(UpdateuReferenceID); $.ajax({ url: "PRF_UpdateCanvassLists.php", type: "POST", async: false, data: { "ItemRecordIDLoad":ItemRecordIDLoad, "UpdateuReferenceID":UpdateuReferenceID, "trans":1 }, success: function(d){ $("#activeProposals").html(d); } }) } //====================================================================================================== function ProposalCount(){ //alert('test'); $.ajax({ url: "PRF_UpdateCanvassCount.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#canvassCount").html(d); } }) } }); </script>

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