File manager

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

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; $deptID=$user_data['dept_id']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; echo "<input type='hidden' id='myUID' value='$uniqueRefID'>"; echo "<input type='hidden' id='myDeptID' value='$deptID'>"; ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> <!--########################## POPUP MESSAGE ############################################--> <!--########################## POPUP MESSAGE ############################################--> <!--########################## POPUP MESSAGE ############################################--> <!--########################## POPUP MESSAGE ############################################--> <!--########################## POPUP MESSAGE ############################################--> <!--########################## POPUP MESSAGE ############################################--> </head> <body> <!--########################## POPUP MESSAGE ############################################--> <!--########################################################################################################--> <div id='saveMessage' style='display:none;background:yellow;border:1px solid orange;padding:0px;width:400px;top:40px;position:fixed;left:50px;position:absolute;z-index:999999999;opacity: 0.95;'> <b style=''></b> <p style='margin:20px;background:yellow;font-family:Yu Gothic;font-size:1.5vw;text-align:center'>New record has been saved.</p> </div> <!--########################################################################################################--> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  Create New Purchase Request (New PRF)</p> </div> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody'> <div class='NewPRFBodyMenu'> <div class='searchDIVA'> <b class='BodyTopMenu' id='LoadNewPRFForm' onclick='showActionSlipForm()'>➕ CREATE NEW PRF </b> <b class='BodyTopMenu'>📠 Print </b> <b class='BodyTopMenu'>💾 Export</b> </div> <div class='searchDIVB'> <input type='text' id='searchText' placeholder='Search Record.' class='textSearch' style='width:70%;margin:0px;border:1px solid lightgray;'> <button id='searchNewPRF' class='searchButton' style='width:25%'> 🔍       Search</button> </div> </div> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:3%'>NO</th> <th style='width:10%'>REF. CODE</th> <th style='width:7%'>DATE</th> <th style='width:19%'>COMPANY</th> <th style='width:16%'>DEALER</th> <th style='width:13%'>REQ. CATEGOY</th> <th style='width:12%'>REQ. TYPE</th> <th style='width:12%'>APPROVED BY</th> <th style='width:8%'>STATUS</th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### //$totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `deleted`=0"),0); //$noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); //$myPageCount = ceil($totalRows / $noOfRecordPerPage); //$offSet = ($myPageCount-1) * $noOfRecordPerPage; //echo "<input type='hidden' id='MyPageCount' value='".$myPageCount."'>"; //echo "<input type='hidden' id='MyRowCount' value='".$totalRows."'>"; //echo "<input type='hidden' id='myOffSet' value='".$offSet."'>"; //echo "<input type='hidden' id='recordPerPage' value='".$noOfRecordPerPage."'>"; //####################################################################################################### //####################################################################################################### $getItemHdr = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `deleted`=0 AND `request_by`='$uniqueRefID' AND `current_status` = 100 \|\| `deleted`=0 AND `request_by`='$uniqueRefID' AND `current_status` = 0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFheaderForDeletion(this);"><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:19%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:16%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:13%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:12%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:12%'>".strtoupper($prfDeptApproverLName).", ".strtoupper($prfDeptApproverFName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='3' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='6' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel'> <input disabled type='text' id='selectedPRFHeaderIDLabel' style='background:white;border:0px;font-family:Yu Gothic;font-size:14px;color: #f97d43 ;font-weight:normal'> </td> </tr> </table> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################ <div style='margin-top:50px;background:white;width:100%;padding:0px;float:left;height:70px;padding:30px'> <center> <button onclick="javascript:pageLess();" id='pageCountViewBack' class='paginationBack'>◀  Back</button> <input type='text' disabled id='pageCountView' value ="Page 1 of <?php echo $myPageCount;?>" class='paginationBox' style='width:200px;margin-left:0px'> <input type='hidden' id='pageCount' value='1' class='paginationBox'> <button onclick="javascript:pageAdd();" id='pageCountViewNext' class='paginationNext'>Next    ▶ </button> </center> </div> --> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################--> </div> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="showActionViewDelete" class="PopUpActionWindow"> <div class='PopUpWindowTitle'> 🪧 Confirm Action <div class='PopUpWindowClose'> <b onclick="javascript:hideActionViewDelete(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;padding-left:20px;width:100%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'>Selected Record:<br> <input disabled type='hidden' id='ActionReferenceID' 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='ActionReferenceIDDesc' 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'> <br> </td> </tr> <tr> <td colspan='1' style='padding:10px;width:250px;background:white;border-top:1px solid gray;text-align:center;padding-top:5px'> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <button onclick="javascript:showUpdatePRFForm(this);" id='LoadUnpostedPRF' class='PopUpLowerButtonR'>📑  View Details</button> <button id='deletePRFHeader' class='PopUpLowerButtonR'> ❌  Delete</button> </div> </td> </tr> </table> </div> <!--########################## ADD NEW PURCHASE REQEUST ############################################--> <!--########################################################################################################--> <div id="PRFCreateNewRequest" class="PopUpWindowPRF"> <div class='PopUpWindowTitle'> 🗒 New Purchase Request <div class='PopUpWindowClose'> <b id='XCloseButton' style='font-weight:bold'> ✕ </b> </div> </div> <!--BODY--> <div class='PopUpWindowBodyContainer'> <input type='hidden' id='PRFReferenceNumber'> <label class='PRFRefID' id='uReferenceID'>:</label> <label class='PRFRefID'>Reference Number.</label> <div id="PRFNewContentInfo" class="PopUpWindowBody"> <div class='PRFdropItemSelectionContainer'> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Company:</p> <select id='prfCompanySelected' class='DropDownButton' onchange="showDealership(this.value)"> <option value='0'>-- Select Company --</option> <?php $getCompanyAccess = mysql_query(" SELECT brand_access.user_id, brand_access.comp_id,brand_access.dealer_id,vts_company.comp_id,vts_company.comp_code,vts_company.comp_name FROM brand_access JOIN vts_company ON brand_access.comp_id = vts_company.comp_id WHERE brand_access.user_id=$uniqueRefID GROUP BY brand_access.comp_id ORDER BY vts_company.comp_name ASC "); while($row=mysql_fetch_array($getCompanyAccess)){ echo "<option value='".$row['comp_id']."'>".strToupper($row['comp_name'])."</option>"; } ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Dealer:</p> <select id='myDealerList' class='DropDownButton' > </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Select Expense Category:</p> <select id='prfCategorySelected' class='DropDownButton' onchange="showCategoryItems(this.value)"> <option value='0'>-- Select Category --</option> <?php $getCompanyAccess = mysql_query("SELECT * FROM `prf_expensecategory` WHERE `status` = 1 ORDER BY description ASC "); while($row=mysql_fetch_array($getCompanyAccess)){ echo "<option value='".$row['id']."'>".strToupper($row['description'])."</option>"; } ?> </select> </div> <div class='PRFdropItemSelection'> <p class='buttonTitle'>Expense Type:</p> <select id='CategorySubItem' class='DropDownButton' > </select> </div> </div> <!--########################################################################################################--> <div id='showCategory' style='position:fixed;top:0px;left:0px;width:350px;border:1px solid gray; background:#000000;display:none;height:100%;overflow:fixed'> <div class='PopUpWindowTitle'> 🗒 ITEM CATEGORY <div class='PopUpWindowClose'> <b id='closCategory' onclick="javascript:hideItemCategoryForm(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='ClassList'> test </div> </div> <!--########################################################################################################--> <!--########################################################################################################--> <div id='showItemList' 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:hideItemListForm(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='itemList'> test </div> </div> <!--########################################################################################################--> <div class='PRFdropItemSelectionContainer'> <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='PurposeOfReqeust' 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='viewCat' style='cursor:pointer;font-size:10px;color:blue'><i>View Class</i></label></p> <input type='text' id='itemClass' onchange="hideItemCategoryForm()" class='DropDownButton' style='margin:0px;' autocomplete="off"> </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='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 id='prfApprovingHead' class='DropDownButton' style='margin:0px;' > <?php //$myHeadApprova=$user_data['dept_head_id']; $myHeadApproval=$user_data['dept_head_id']; //$getCompanyAccess = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,cl_approving_officers.cl_emp_id_a FROM cl_approving_officers JOIN vts_users ON cl_approving_officers.cl_emp_id_a = vts_users.u_id WHERE cl_approving_officers.cl_status=1 GROUP by cl_approving_officers.cl_emp_id_a ORDER BY vts_users.u_lname ASC"); $getHead = mysql_query("SELECT * FROM `vts_users` WHERE `u_id`='$myHeadApproval'"); while($row=mysql_fetch_array($getHead)){ echo "<option value='".$row['u_id']."'>".strToupper($row['u_lname']).", ".strToupper($row['u_fname'])."</option>"; //echo "<option value='".$row['u_id']."'>".strToupper($row['u_lname']).", ".strToupper($row['u_fname'])."</option>"; } ?> </select> </div> </div> <div class='PRFAddNewItem'> <div class='PRFdropItemSelection' style='width:65%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>Item Description:<label id='viewItems' style='cursor:pointer;font-size:10px;color:blue'><i>View Items List</i></label></p> <input type='text' id='txtAddItemDesc' class='DropDownButton' style='margin:0px;' autocomplete="off"> </div> <div class='PRFdropItemSelection' style='width:10%;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='txtAddItemQty' min="1" class='DropDownButton' style='margin:0px;'> </div> <div class='PRFdropItemSelection' style='width:10%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'>UoM:</p> <select id='UnitOfMeasure' 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:15%;background:transparent;padding-bottom:0px;padding-top:0px'> <p class='buttonTitle' style='margin-top:0px;padding-top:0px'></p> <button id='btnAddNewItem' class='InsertButton'>➕    Add Item</button> </div> </div> <div class='PRFNewTableBody' id='PRFItemBody'> </div> <div class='PRFLowerActionButtonDiv' style='border:1px solid red'> <button id='btnCloseButton' class='SavePostCloseButton' style='width:130px'>✖   CLOSE</button> <button id='btnPostNewPRF' class='SavePostCloseButton' style='width:155px'>📪   POST ORDER</button> <label id='attachedFilename' style='float:left;padding:10px;margin:7px;border:1px solid lightgray;width:40%;color:blue'>No Attachment.</label> <button id='showAttachmentForm' onclick="showAttachForm(this);" class='SavePostCloseButton' style='width:140px'>⬆  ATTACH FILE</button> </div> </div> </div> </div> <!--########################## END OF ADD NEW PURCHASE REQEUST ############################################--> <!--########################## EDIT/UPDATE PURCHASE REQUEST ###############################################--> <div id="PRFUPDATENewRequest" class="PopUpWindowPRF"> <div class='PopUpWindowTitle'> 🗒 Update Purchase Request Form <div class='PopUpWindowClose'> <b onclick="javascript:hideUpdatePRFForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <!--BODY--> <div class='PopUpWindowBodyContainer'> <input type='hidden' id='UpdatePRFReferenceNumber'> <label class='PRFRefID' id='UpdateuReferenceID'>:</label> <label class='PRFRefID'>Reference Number.</label> <div id="UpdatePRFNewContentInfo" class="PopUpWindowBody"> </div> </div> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="MyUploadForm" class="uploadForm" style='height:310px'> <div class='PopUpWindowTitle'> 🪧 PRF ATTACHMENT <div class='PopUpWindowClose'> <b onclick="javascript:hideAttachForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:5px;width:100%;background:lightgray;font-family:Yu Gothic; font-size:16px;color:red ;font-weight:normal;text-align:left'> <form action = "" method="post" enctype="multipart/form-data" style='background:white;border:0px solid gray;text-align:left;font-family:Arial;font-size:12px;color:black;border-bottom:0px solid lightgray;margin-top:10px'> <div style='width:48.2%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:0px'> <input type="hidden" disabled id="userID" value='<?php echo $uniqueRefID;?>' style="font-family:Arial;font-size:12px;color:blue;font-weight:bold;margin:2px;padding:6.5px;border:0px solid white"> </div> <div style='width:96.5%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:5px'> <b style='font-family:Yu Gothic Light;font-size:14px;padding:3px'>Select Document:</b><br><br> <input type="file" value="Upload" id="canvassFile" required style='padding;6px;float:left;background:white;width:100%;text-align:left;border:0px;float:left;font-family:Calibri;font-size:12px;margin-bottom:0px'> </div> <div style='width:96.5%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:5px'>Remarks:<br> <textarea rows='1' id='myNotes' style='width:100%;padding:10px'></textarea> </div> </form> </td> </tr> <tr> <td colspan='1' style='padding:10px;width:250px;background:lightgray;border-top:0px solid gray;text-align:center;padding-top:5px'> <div style='width:100%;float:right;height:63px;padding:10px;background:lightgray'> <button id='uploadCanvass' class='PopUpLowerButtonR' >⬇    Upload File</button> </div> </td> </tr> </table> </div> <!--########################## END OF EDIT/UPDATING PURCHASE REQEUST ############################################--> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#searchNewPRF").click(function(){ var searchText = $("#searchText").val(); //alert(selectedPRFHeaderID); //exit; ShowUploadBar(); $.ajax({ url: "PRF_SearchPRFRecord.php", type: "POST", async: false, data: { "searchText": searchText, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTable").html(d); $('#searchText').val(''); } }) }); //====================================================================================================== $("#uploadCanvass").click(function(){ var PRFReferenceNumber = $("#PRFReferenceNumber").val(); var myNotes = $("#myNotes").val(); var userActiveID = $("#myUID").val(); var file_data = $('#canvassFile').prop('files')[0]; var form_data = new FormData(); // Create a FormData object canvassCode validityDate vendorProposal form_data.append('file', file_data); // Append all element in FormData object form_data.append('PRFReferenceNumber', PRFReferenceNumber); form_data.append('myNotes', myNotes); form_data.append('userActiveID', userActiveID); //form_data.append('validityDate', validityDate); //form_data.append('vendorCode', vendorCode); if(file_data==''){ alert('No record has been selected. ERROR: File upload failed.'); exit(); } ShowUploadBar(); //alert('its working'); //return false; $.ajax({ url : 'PRF_ATTACHMENT.php', // point to server-side PHP script dataType : 'text', // what to expect back from the PHP script, if anything cache : false, contentType : false, processData : false, data : form_data, type : 'post', success : function(d){ $("#attachedFilename").html(d); ShowUploadBar(); hideAttachForm(); } }); $('#canvassFile').val(''); /* Clear the file container / }); //====================================================================================================== $("#deletePRFHeader").click(function(){ var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert(selectedPRFHeaderID); //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_Header.php", type: "POST", async: false, data: { "selectedPRFHeaderID": selectedPRFHeaderID, "done": 1 }, success: function(d){ ShowUploadBar(); updateCREATENEWPRF(); $("#mainTable").html(d); hideActionViewDelete(); //$('#searchText').val(''); 015334295-1005 } }) } }); //====================================================================================================== $("#LoadNewPRFForm").click(function(){ var uReferenceID = <?php echo $NewRefCode;?> +""+ Math.floor(Math.random() 888) + <?php echo $uniqueRefID;?>; document.getElementById("PRFReferenceNumber").value= uReferenceID;//<?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniquerefid;?>; document.getElementById("uReferenceID").innerHTML= uReferenceID; document.getElementById("prfCompanySelected").disabled = false; document.getElementById("myDealerList").disabled = false; document.getElementById("prfCategorySelected").disabled = false; document.getElementById("CategorySubItem").disabled = false; document.getElementById("PurposeOfReqeust").disabled = false; document.getElementById("DateNeeded").disabled = false; document.getElementById("prfApprovingHead").disabled = false; ShowUploadBar(); $.ajax({ url: "PRF_NewResfresh.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); updateCREATENEWPRF(); $("#PRFItemBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================================================================================== $("#XCloseButton").click(function(){ document.getElementById("btnAddNewItem").disabled = false; document.getElementById("btnAddNewItem").style.backgroundColor = ""; document.getElementById("btnAddNewItem").style.color = ""; $("#PRFCreateNewRequest").fadeOut(500); ShowUploadBar(); $.ajax({ url: "PRF_NewResfresh.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); updateCREATENEWPRF(); $("#PRFItemBody").html(d); //invHideAssignMsg(); refreshMainTable(); } }) }); //====================================================================================================== $("#btnPostNewPRF").click(function(){ var UpdateReferenceHeaderCode = $("#PRFReferenceNumber").val(); //=alert(UpdateReferenceHeaderCode); //exit; ShowUploadBar(); $('#btnPostNewPRF').prop('disabled', true); $.ajax({ url: "PRF_PostNewPRF_FromNew.php", type: "POST", async: false, data: { "UpdateReferenceHeaderCode": UpdateReferenceHeaderCode, "done": 1 }, success: function(d){ //showSaveForm(); // hideSaveForm(); $('#btnPostNewPRF').prop('disabled', false); updateCREATENEWPRF(); $("#mainTable").html(d); ShowUploadBar(); updateApprovalPRF(); refreshMainTable(); $("#PRFCreateNewRequest").fadeOut(500); Swal.fire({ position: 'top-start', icon: 'success', title: 'Record has been saved', showConfirmButton: false, timer: 2000 }) } }) }); //====================================================================================================== $("#btnCloseButton").click(function(){ document.getElementById("btnAddNewItem").disabled = false; document.getElementById("btnAddNewItem").style.backgroundColor = ""; document.getElementById("btnAddNewItem").style.color = ""; $("#PRFCreateNewRequest").fadeOut(500); ShowUploadBar(); $.ajax({ url: "PRF_NewResfresh.php", type: "POST", async: false, data: { }, success: function(d){ $("#PRFItemBody").html(d); updateCREATENEWPRF(); refreshMainTable(); ShowUploadBar(); } }) }); //====================================================================================================== $("#LoadUnpostedPRF").click(function(){ var UpdatePRFReferenceNumber = $("#UpdatePRFReferenceNumber").val(); ShowUploadBar(); //alert(prfCompanySelected); $.ajax({ url: "PRF_UpdateUnpostedPRF.php", type: "POST", async: false, data: { "UpdatePRFReferenceNumber": UpdatePRFReferenceNumber, "done": 1 }, success: function(d){ ShowUploadBar(); updateCREATENEWPRF(); $("#UpdatePRFNewContentInfo").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================================================================================== //====================================================================================================== $("#itemClass").click(function(){ var prfCategorySelected = $("#CategorySubItem").val(); //alert(prfCategorySelected); if(prfCategorySelected == null \|\| prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } ShowUploadBar(); $.ajax({ url: "prf_loadItemClass.php", type: "POST", async: false, data: { "prfCategorySelected": prfCategorySelected, "done": 1 }, success: function(d){ ShowUploadBar(); showItemCategoryForm(); $("#ClassList").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#viewCat").click(function(){ var prfCategorySelected = $("#CategorySubItem").val(); if(prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } //alert(prfCategorySelected); ShowUploadBar(); $.ajax({ url: "prf_loadItemClass.php", type: "POST", async: false, data: { "prfCategorySelected": prfCategorySelected, "done": 1 }, success: function(d){ ShowUploadBar(); showItemCategoryForm(); $("#ClassList").html(d); } }) }); //====================================================================================================== //========================================txtAddItemDesc============================================================== $("#viewItems").click(function(){ var myDeptID= $("#myDeptID").val(); if(prfCategorySelected == 0){ alert('Please select Expense Category first.'); exit(); } //alert(myDeptID); ShowUploadBar(); $.ajax({ url: "prf_loaddepartments.php", type: "POST", async: false, data: { "myDeptID": myDeptID, "done": 1 }, success: function(d){ ShowUploadBar(); showItemListForm(); $("#itemList").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#txtAddItemDesc").click(function(){ //Endaya Item Class var myDeptID= $("#myDeptID").val(); var itemClass= $("#itemClass").val(); if(itemClass == ""){ alert('Please select Expense Category first.'); exit(); } //alert(myDeptID); ShowUploadBar(); $.ajax({ url: "prf_loaddepartments.php", type: "POST", async: false, data: { "myDeptID": myDeptID, "itemClass": itemClass, "done": 1 }, success: function(d){ ShowUploadBar(); showItemListForm(); $("#itemList").html(d); } }) }); //====================================================================================================== $("#btnAddNewItem").click(function(){ var prfCompanySelected = $("#prfCompanySelected").val(); var myDealerList = $("#myDealerList").val(); var prfCategorySelected = $("#prfCategorySelected").val(); var CategorySubItem = $("#CategorySubItem").val(); var PurposeOfReqeust = $("#PurposeOfReqeust").val(); var DateNeeded = $("#DateNeeded").val(); var prfApprovingHead = $("#prfApprovingHead").val(); var txtAddItemDesc = $("#txtAddItemDesc").val(); var txtAddItemQty = $("#txtAddItemQty").val(); var UnitOfMeasure = $("#UnitOfMeasure").val(); var uReferenceID = $("#PRFReferenceNumber").val(); var itemClass = $("#itemClass").val(); var myDeptID= $("#myDeptID").val(); //alert(txtAddItemDesc); //exit; if(prfCompanySelected ==0){ alert("Please select company."); exit; } if(myDealerList ==0){ alert("Please select dealer."); exit; } if(prfCategorySelected ==0){ alert("Please select purchase category."); exit; } if(CategorySubItem ==0){ alert("Please select purchase subcategory."); exit; } if(PurposeOfReqeust ==""){ alert("Please indicate the purpose of your request."); exit; } if(itemClass ==''){ alert("Please Item Type"); exit; } if(DateNeeded ==""){ alert("Please indicate date needed"); exit; } if(prfApprovingHead ==0){ alert("Please select approving head"); exit; } if(txtAddItemDesc ==""){ alert("Please type something in the item description"); exit; } if(UnitOfMeasure ==""){ alert("Please select unit of measure"); exit; } document.getElementById("prfCompanySelected").disabled = true; document.getElementById("myDealerList").disabled = true; document.getElementById("prfCategorySelected").disabled = true; document.getElementById("CategorySubItem").disabled = true; document.getElementById("PurposeOfReqeust").disabled = true; document.getElementById("DateNeeded").disabled = true; document.getElementById("prfApprovingHead").disabled = true; //document.getElementById("btnAddNewItem").style.backgroundColor = "gray"; //document.getElementById("btnAddNewItem").style.color = "lightgray"; ShowUploadBar(); $('#btnAddNewItem').attr('disabled', true); $.ajax({ url: "PRF_AddNewPRFItemsAndHeaders.php", type: "POST", async: false, beforeSend: function(){ }, data: { "uReferenceID": uReferenceID, "myDeptID": myDeptID, "prfCompanySelected": prfCompanySelected, "myDealerList": myDealerList, "prfCategorySelected": prfCategorySelected, "CategorySubItem": CategorySubItem, "PurposeOfReqeust": PurposeOfReqeust, "DateNeeded": DateNeeded, "txtAddItemDesc": txtAddItemDesc, "prfApprovingHead": prfApprovingHead, "txtAddItemQty": txtAddItemQty, "UnitOfMeasure": UnitOfMeasure, "itemClass": itemClass, "done": 1 }, success: function(d){ ShowUploadBar(); $("#PRFItemBody").html(d); $('#btnAddNewItem').attr('disabled', false); } }) }); //================================================================================= //================================================================================= $("#pageCountViewNext").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_LoadNewPRF.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#displaySupplier").html(d); } }) }); //================================================================================= //================================================================================= $("#pageCountViewBack").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_LoadNewPRF.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#displaySupplier").html(d); } }) //================================================================================= //================================================================================= }); //====================================================================================================== function updateCREATENEWPRF(){ $.ajax({ url: "PRF_UpdateCREATENEW_\PRF.php", type: "POST", async: false, data: { "trans":1 }, success: function(d){ updatePostedPRF(); $("#unPostedPRFRequestCount").html(d); } }) } //====================================================================================================== function updatePostedPRF(){ $.ajax({ url: "PRF_Update_POSTEDPRF.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#PostedPRFRequestCount").html(d); } }) } //====================================================================================================== function updateApprovalPRF(){ $.ajax({ url: "PRF_UpdateApprovalCount.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forMyApprovalCount").html(d); } }) } //====================================================================================================== function refreshMainTable(){ $.ajax({ url: "PRF_MainTableHeaderDisplay.php", type: "POST", async: false, data: { }, success: function(d){ //invShowAssignMsg(); $("#mainTable").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> function showAttachForm(){ $('#MyUploadForm').fadeIn(500); } function hideAttachForm(){ $('#MyUploadForm').fadeOut(500); } function hideItemCategoryForm(){ $("#showCategory").fadeOut(500); }; function showItemCategoryForm(){ $("#showCategory").fadeIn(500); }; function hideItemListForm(){ $("#showItemList").fadeOut(500); }; function showItemListForm(){ $("#showItemList").fadeIn(500); }; function hideActionSlipForm(){ $("#PRFCreateNewRequest").fadeOut(500); }; function showActionSlipForm(){ $("#PRFCreateNewRequest").fadeIn(500); }; function hideActionViewDelete(){ $("#showActionViewDelete").fadeOut(500); }; function showActionViewDelete(){ $("#showActionViewDelete").fadeIn(500); }; function hideUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeOut(500); }; function showUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeIn(500); $("#showActionViewDelete").fadeOut(500); }; function hideSaveForm(){ $("#saveMessage").fadeOut(10000); }; function showSaveForm(){ $("#saveMessage").fadeIn(300); }; function showPRFheaderForDeletion(row) { var x=row.cells; document.getElementById("selectedPRFHeaderID").value = x[1].innerHTML; document.getElementById("selectedPRFHeaderIDLabel").value = x[1].innerHTML; document.getElementById("ActionReferenceID").value = x[1].innerHTML; document.getElementById("ActionReferenceIDDesc").value = "Ref.#: " + x[1].innerHTML; document.getElementById("UpdateuReferenceID").innerHTML = x[1].innerHTML; document.getElementById("UpdatePRFReferenceNumber").value = x[1].innerHTML; showActionViewDelete(); } //GET THE VALUE OF SELECTED ITEM SUB CATEGORY function getItemCategoryValue(row) { var x=row.cells; document.getElementById("itemClass").value = x[0].innerHTML; hideItemCategoryForm(); } //GET THE VALUE OF SELECTED ITEM DESCRIPTION function getItemDescription(row) { var x=row.cells; document.getElementById("txtAddItemDesc").value = x[0].innerHTML; hideItemListForm(); } //GET THE VALUE OF SELECTED ITEM DESCRIPTION function getManualItem() { var manualAddItem = $("#manualUpdateAddItem").val(); document.getElementById("txtAddItemDesc").value = manualAddItem; hideItemListForm(); } //GET THE VALUE OF SELECTED ITEM DESCRIPTION function getManualItemClass() { var manualAddItemClass = $("#manualAddItemClass").val(); document.getElementById("itemClass").value = manualAddItemClass; hideItemCategoryForm(); } //LOAD DEALER BASED ON SELECTED COMPANY function showDealership(str) { //alert(str); if (str == "") { document.getElementById("myDealerList").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("myDealerList").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_DealerBySelectedCompany.php?q="+str,true); xmlhttp.send(); } } //LOAD DEALER BASED ON SELECTED COMPANY function showCategoryItems(str) { //alert(str); if (str == "") { document.getElementById("CategorySubItem").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("CategorySubItem").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_ExpenseCategoryItems.php?q="+str,true); xmlhttp.send(); } } </script>

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