File manager

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

Back
<?php include 'core/init.php'; $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['ActionReferenceIDa']); $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); } ?> <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='".$getSubCatID."'>".strToupper($getCategoryName)."</option>"; ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Expense Type:</p> <select disabled id='UpdateCategorySubItem' class='DropDownButton' > <?php echo "<option value='".$getCategoryID."'>".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: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:</p> <input type='text' disabled 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' disabled 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 disabled 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 disabled class='InsertButton' style='background:lightgray;color:gray'>➕    Add Item</button> </div> </div> <div class='PRFNewTableBody' id='UpdatePRFItemBody' style='height:260px'> <?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:10%'>Rec.#</th>"; echo "<th style='width:15%'>REF. #</th>"; echo "<th style='width:55%'>ITEM DESCRIPTION</th>"; echo "<th style='width:5%'>UoM</th>"; echo "<th style='width:5%'>QUANTITY</th>"; echo "<th style='width:10%'>STATUS</th>"; echo "</thead>"; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; ?><tr onDblclick="javascript:POPUPShowDeleteSubItem(this);"><?php echo "<td>".$row['id']."</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 "<td style='text-align:center'>"; $itemStat = $row['item_status']; $itemStatName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `sequence`='$itemStat'"),0); echo $itemStatName; echo"</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <!--- $##################################################################### --> <!--- $##################################################################### --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> 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("UpdateuReferenceID").innerHTML = x[1].innerHTML; //document.getElementById("UpdatePRFReferenceNumber").value = x[1].innerHTML; } </script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#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(); 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, "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_PostNewPRF.php", type: "POST", async: false, data: { "UpdateReferenceHeaderCode": UpdateReferenceHeaderCode, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainTable").html(d); hideUpdatePRFForm(); ShowUploadBar(); } }) }); //====================================================================================================== $("#deletePRFDetail").click(function(){ var DelActionReferenceID = $("#DelActionReferenceID").val(); //alert(DelActionReferenceID); 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 } }) }); //====================================================================================================== $("#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(''); } }) }); //====================================================================================================== });

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