File manager

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

Back
<?php include 'core/init.php'; $activeID=$user_data['u_id']; $deptID=$user_data['dept_id']; echo "<input type='hidden' id='myUID' value='$uniqueRefID'>"; echo "<input type='hidden' id='myDeptID' value='$deptID'>"; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $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); $getDealerID = mysql_result(mysql_query("SELECT deal_id FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $getDealerName = mysql_result(mysql_query("SELECT deal_name FROM vts_dealerships WHERE deal_id='$getDealerID'"),0); $getCategoryID = mysql_result(mysql_query("SELECT category_id FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $getCategoryName = mysql_result(mysql_query("SELECT description FROM prf_expensecategory WHERE id='$getCategoryID'"),0); $getSubCatID = mysql_result(mysql_query("SELECT sub_category_id FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $getSubCatName = mysql_result(mysql_query("SELECT description FROM prf_expenseitems WHERE id='$getSubCatID'"),0); $getdeptHeadID = mysql_result(mysql_query("SELECT dept_head_id FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $getdeptHeadFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id ='$getdeptHeadID'"),0); $getdeptHeadLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id ='$getdeptHeadID'"),0); $dateNeeded = mysql_result(mysql_query("SELECT date_needed FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); $purpose = mysql_result(mysql_query("SELECT purpose_of_request FROM prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber'"),0); } ?> <!--########################################################################################################--> <div id='UpdateshowCategory' style='position:fixed;top:0px;left:0px;width:250px;border:1px solid gray; background:#000000;display:none;height:780px;overflow:fixed'> <div class='PopUpWindowTitle'> 🗒 ITEM CATEGORY <div class='PopUpWindowClose'> <b id='closCategory' onclick="javascript:UpdatehideItemCategoryForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <!--BODY--> <div style='width:100%;height:95%;overflow:auto;padding:2px;border:0px solid red;background:white' id='UpdateClassList'> test </div> </div> <!--########################################################################################################--> <!--########################################################################################################--> <div id='UpdateshowItemList' style='position:fixed;top:0px;left:0px;width:600px;border:1px solid gray; background:#000000;display:none;height:100%;overflow:fixed'> <div class='PopUpWindowTitle'> 🗒 SELECT ITEM <i style='font-family:Yu Gothic Light;font-size:12px;color:white'>(If item is not in the list, you can manually type it in the item description box)</i> <div class='PopUpWindowClose'> <b id='closItemList' onclick="javascript:hideUpdateItemListForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <!--BODY--> <div style='width:100%;height:99%;overflow:auto;padding:2px;border:0px solid red;background:white' id='itemListUpdate'> test </div> </div> <!--########################################################################################################--> <input type='hidden' id="UpdateReferenceHeaderCode" value='<?php echo $UpdatePRFReferenceNumber;?>'> <div class='PRFdropItemSelectionContainer'> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Company:</p> <select disabled id='UpdateprfCompanySelected' class='DropDownButton' onchange="showDealership(this.value)"> <?php echo "<option value='".$getCompanyID."'>".strToupper($getCompanyName)."</option>"; ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Dealer:</p> <select disabled id='UpdatemyDealerList' class='DropDownButton' > <?php echo "<option value='".$getDealerID."'>".strToupper($getDealerName)."</option>"; ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Expense Category:</p> <select disabled id='UpdateprfCategorySelected' class='DropDownButton' onchange="showCategoryItems(this.value)"> <?php echo "<option value='".$getCategoryID."'>".strToupper($getCategoryName)."</option>"; ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Expense Type:</p> <select disabled id='UpdateCategorySubItem' class='DropDownButton' > <?php echo "<option value='".$getSubCatID."'>".strToupper($getSubCatName)."</option>"; ?> </select> </div> </div> <div class='PRFdropItemSelectionContainer'> <!--<div class='PRFdropItemSelection' style='width:50%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Purpose of Request:</p> <input disabled type='text' id='UpdatePurposeOfReqeust' class='DropDownButton' value='<?php echo $purpose;?>'style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:25%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Date Needed:</p> <input disabled type='date' id='UpdateDateNeeded' value='<?php echo $dateNeeded;?>'> </div>--> <div class='PRFdropItemSelection' style='width:38%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Purpose of Request:</p> <input type='text' id='UpdatePurposeOfReqeust' class='DropDownButton' style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:20%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px;font-weight:bold'>Item Type: <label id='UpdateviewCat' style='cursor:pointer;font-size:10px;color:blue'><i>View Class</i></label></p> <input type='text' id='UpdateItemCategory' onchange="UpdatehideItemCategoryForm()" class='DropDownButton' style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:17%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Date Needed:</p> <input type='date' id='UpdateDateNeeded'> </div> <div class='PRFdropItemSelection' style='width:25%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Approving Head:</p> <select disabled id='UpdateprfApprovingHead' class='DropDownButton' style='margin:0px;' > <?php echo "<option value='".$getdeptHeadID."'>".strToupper($getdeptHeadLName).", ".strToupper($getdeptHeadFName)."</option>"; ?> </select> </div> </div> <div class='PRFAddNewItem'> <div class='PRFdropItemSelection' style='width:50%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Item Description:<label id='UpdateviewItems' style='cursor:pointer;font-size:10px;color:blue'><i>View Items</i></label></p> <input type='text' id='UpdatetxtAddItemDesc' class='DropDownButton' style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:15%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Quantity:</p> <input type='number' value='1' id='UpdatetxtAddItemQty' min="1" class='DropDownButton' style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:15%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>UoM:</p> <select id='UpdateUnitOfMeasure' class='DropDownButton' style='margin:0px;' > <option value='0'>-- Select --</option> <?php $getCompanyAccess = mysql_query("SELECT * FROM PRF_UoM WHERE status =1 ORDER BY Description ASC "); while($row=mysql_fetch_array($getCompanyAccess)){ echo "<option value='".$row['description']."'>".strToupper($row['description'])."</option>"; } ?> </select> </div> <div class='PRFdropItemSelection' style='width:20%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'></p> <button id='btnUpdateNewItem' class='InsertButton'>➕    Add Item</button> </div> </div> <div class='PRFNewTableBody' id='UpdatePRFItemBody'> <?php $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber' AND `deleted` = 0"); echo "<table>"; echo "<thead>"; echo "<th style='width:30px'>NO</th>"; echo "<th style='width:80px'>ITEM TYPE</th>"; echo "<th style='width:80px'>REF. #</th>"; echo "<th style='width:450px'>ITEM DESCRIPTION</th>"; echo "<th style='width:30px'>UoM</th>"; echo "<th style='width:40px'>QUANTITYx</th>"; echo "</thead>"; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemClassID = $row['item_class']; $itemClassDes = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='$itemClassID'"),0); ?><tr onclick="javascript:POPUPShowDeleteSubItem(this);"><?php echo "<td>".strtoupper($row['id'])."</td>"; echo "<td>".strtoupper($itemClassDes)."</td>"; echo "<td>".strtoupper($row['header_ref_code'])."</td>"; echo "<td>".strtoupper($row['item_description'])."</td>"; echo "<td>".strtoupper($row['uom'])."</td>"; echo "<td style='text-align:center'>".strtoupper($row['quantity'])."</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <div class='PRFLowerActionButtonDiv'> <div style='width:45%;float:right;height:50px;padding:10px;background:white'> <button id='btnPostNewPRFUpdate' class='PopUpLowerButtonR'>📪   POST ORDER</button> <button id='btnCloseButtonUpdate' class='PopUpLowerButtonR'>✖   CLOSE</button> </div> </div> <!--- $##################################################################### --> <!--- $##################################################################### --> <div id="PRFDELETENewRequest" class="PopUpActionWindow"> <div class='PopUpWindowTitle'> 🪧 Confirm Action <div class='PopUpWindowClose'> <b onclick="javascript:hideDeleteAction(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;width:100%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'>Are you sure you want to delete the selected record? <input disabled type='hidden' id='DelActionReferenceID' style='text-align:center;margin-top:10px;background:yellow;border:0px;font-family:Yu Gothic;font-size:18px;color: red ;font-weight:bold;margin-bottom:3px;padding-bottom:2px'> <input disabled type='text' id='ActionReferenceIDDescXX' style='text-align:center;margin-top:10px;background:white;border:0px;font-family:Yu Gothic;font-size:18px;color: red ;font-weight:bold;margin-bottom:3px;padding-bottom:2px'> </td> </tr> <td colspan='2' style='padding:10px;width:250px;background:white;text-align:center'> <button onclick="javascript:hideDeleteAction(this);" class='PopUpLowerButtonR' style='width:45%'>📑  Cancel</button> <button id='deletePRFDetail' class='PopUpLowerButtonR' style='width:45%'> ❌  Delete</button> </td> </tr> </table> </div> <!--- $##################################################################### --> <!--- $##################################################################### --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> //====================================================================================================== function hideUpdateItemListForm(){ $("#UpdateshowItemList").fadeOut(500); }; function showUpdateItemListForm(){ $("#UpdateshowItemList").fadeIn(500); }; function UpdatehideItemCategoryForm(){ $("#UpdateshowCategory").fadeOut(500); }; function UpdateshowItemCategoryForm(){ $("#UpdateshowCategory").fadeIn(500); }; function hideActionViewDelete(){ $("#showActionViewDelete").fadeOut(500); }; function hideDeleteAction(){ $("#PRFDELETENewRequest").fadeOut(500); }; function showDeleteAction(){ $("#PRFDELETENewRequest").fadeIn(500); }; function POPUPShowDeleteSubItem(row) { showDeleteAction(); var x=row.cells; document.getElementById("DelActionReferenceID").value = x[0].innerHTML; document.getElementById("ActionReferenceIDDescXX").value ="Record #." + x[0].innerHTML; //document.getElementById("UpdateuReferenceID").innerHTML = x[1].innerHTML; //document.getElementById("UpdatePRFReferenceNumber").value = x[1].innerHTML; } //GET THE VALUE OF SELECTED ITEM DESCRIPTION function getItemDescription(row) { var x=row.cells; document.getElementById("UpdatetxtAddItemDesc").value = x[0].innerHTML; hideUpdateItemListForm(); } //GET THE VALUE OF SELECTED ITEM DESCRIPTION function getManualItemUpdate() { var manualUpdateAddItem = $("#manualUpdateAddItem").val(); document.getElementById("UpdatetxtAddItemDesc").value = manualUpdateAddItem; hideUpdateItemListForm(); } function UpdategetItemCategoryValue(row) { var x=row.cells; document.getElementById("UpdateItemCategory").value = x[0].innerHTML; UpdatehideItemCategoryForm(); } </script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== //====================================================================================================== $("#UpdateItemCategory").click(function(){ var UpdateprfCategorySelected = $("#UpdateprfCategorySelected").val(); //alert(prfCategorySelected); if(prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } ShowUploadBar(); $.ajax({ url: "prf_loadItemClassUpdate.php", type: "POST", async: false, data: { "UpdateprfCategorySelected": UpdateprfCategorySelected, "done": 1 }, success: function(d){ ShowUploadBar(); UpdateshowItemCategoryForm(); $("#UpdateClassList").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#UpdateviewCat").click(function(){ var UpdateprfCategorySelected = $("#UpdateprfCategorySelected").val(); //alert(prfCategorySelected); if(prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } ShowUploadBar(); $.ajax({ url: "prf_loadItemClassUpdate.php", type: "POST", async: false, data: { "UpdateprfCategorySelected": UpdateprfCategorySelected, "done": 1 }, success: function(d){ ShowUploadBar(); UpdateshowItemCategoryForm(); $("#UpdateClassList").html(d); } }) }); //====================================================================================================== //========================================txtAddItemDesc============================================================== $("#UpdateviewItems").click(function(){ var myDeptID= $("#myDeptID").val(); if(prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } //alert(myDeptID); ShowUploadBar(); $.ajax({ url: "prf_loaddepartmentsUpdates.php", type: "POST", async: false, data: { "myDeptID": myDeptID, "done": 1 }, success: function(d){ ShowUploadBar(); showUpdateItemListForm(); $("#itemListUpdate").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#UpdatetxtAddItemDesc").click(function(){ var myDeptID= $("#myDeptID").val(); //alert(myDeptID); ShowUploadBar(); $.ajax({ url: "prf_loaddepartmentsUpdates.php", type: "POST", async: false, data: { "myDeptID": myDeptID, "done": 1 }, success: function(d){ ShowUploadBar(); showUpdateItemListForm(); $("#itemListUpdate").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#btnUpdateNewItem").click(function(){ var UpdatePRFReferenceNumber = $("#UpdatePRFReferenceNumber").val(); var UpdateprfCompanySelected = $("#UpdateprfCompanySelected").val(); var UpdatemyDealerList = $("#UpdatemyDealerList").val(); var UpdateprfCategorySelected = $("#UpdateprfCategorySelected").val(); var UpdateCategorySubItem = $("#UpdateCategorySubItem").val(); var UpdatePurposeOfReqeust = $("#UpdatePurposeOfReqeust").val(); var UpdateDateNeeded = $("#UpdateDateNeeded").val(); var UpdateprfApprovingHead = $("#UpdateprfApprovingHead").val(); var UpdatetxtAddItemDesc = $("#UpdatetxtAddItemDesc").val(); var UpdatetxtAddItemQty = $("#UpdatetxtAddItemQty").val(); var UpdateUnitOfMeasure = $("#UpdateUnitOfMeasure").val(); var UpdateItemCategory = $("#UpdateItemCategory").val(); if(UpdatetxtAddItemDesc == ""){ alert("Please type something in the item description"); exit; } if(UpdatetxtAddItemQty == ""){ alert("Please select unit of measure"); exit; } ShowUploadBar(); //alert(UpdatePRFReferenceNumber); $.ajax({ url: "PRF_UPDATEPRFItemsAndHeaders.php", type: "POST", async: false, data: { "UpdatePRFReferenceNumber": UpdatePRFReferenceNumber, "UpdateprfCompanySelected": UpdateprfCompanySelected, "UpdatemyDealerList": UpdatemyDealerList, "UpdateprfCategorySelected": UpdateprfCategorySelected, "UpdateCategorySubItem": UpdateCategorySubItem, "UpdatePurposeOfReqeust": UpdatePurposeOfReqeust, "UpdateDateNeeded": UpdateDateNeeded, "UpdateprfApprovingHead": UpdateprfApprovingHead, "UpdatetxtAddItemDesc": UpdatetxtAddItemDesc, "UpdatetxtAddItemQty": UpdatetxtAddItemQty, "UpdateUnitOfMeasure": UpdateUnitOfMeasure, "UpdateItemCategory": UpdateItemCategory, "done": 1 }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#UpdatePRFItemBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================================================================================== $("#btnPostNewPRFUpdate").click(function(){ var UpdateReferenceHeaderCode = $("#UpdateReferenceHeaderCode").val(); //alert(UpdateReferenceHeaderCode); //exit; ShowUploadBar(); $.ajax({ url: "PRF_PostUnpostedPRF.php", type: "POST", async: false, data: { "UpdateReferenceHeaderCode": UpdateReferenceHeaderCode, "done": 1 }, success: function(d){ updateCREATENEWPRF(); $("#mainTable").html(d); hideUpdatePRFForm(); ShowUploadBar(); updateApprovalPRFSub(); } }) }); //====================================================================================================== $("#deletePRFDetail").click(function(){ var DelActionReferenceID = $("#DelActionReferenceID").val(); //alert(DelActionReferenceID); if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to DELETE this record? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_DeletePRF_Detail.php", type: "POST", async: false, data: { "DelActionReferenceID": DelActionReferenceID, "done": 1 }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#UpdatePRFItemBody").html(d); hideDeleteAction(); //$('#searchText').val(''); 015334295-1005 } }) } }); //====================================================================================================== $("#UpdatedeletePRFItem").click(function(){ var DelActionReferenceID = $("#DelActionReferenceID").val(); alert(DelActionReferenceID); exit; if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to DELETE this record? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_DeletePRF_item.php", type: "POST", async: false, data: { "DelActionReferenceID": DelActionReferenceID, "done": 1 }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#UpdatePRFItemBody").html(d); hideDeleteAction(); //$('#searchText').val(''); 015334295-1005 } }) } }); //====================================================================================================== $("#btnCloseButtonUpdate").click(function(){ hideUpdatePRFForm(); hideActionViewDelete(); ShowUploadBar(); $.ajax({ url: "PRF_NewResfresh.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#UpdatePRFItemBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================================================================================== function updateCREATENEWPRF(){ $.ajax({ url: "PRF_Update_CREATE_NEW_PRF.php", type: "POST", async: false, data: { "trans":1 }, success: function(d){ updatePostedPRF(); $("#unPostedPRFRequestCount").html(d); } }) } //====================================================================================================== function updateApprovalPRFSub(){ $.ajax({ url: "PRF_UpdateApprovalCount.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forMyApprovalCount").html(d); } }) } //====================================================================================================== function updatePostedPRF(){ $.ajax({ url: "PRF_Update_POSTEDPRF.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#PostedPRFRequestCount").html(d); } }) } });

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