File manager

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

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_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; ?> <!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"/> </head> <body> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  SETUP ASSET VALIDATE - COMPANY -> DEALERSHIP LEVEL</p> </div> <input type='hidden' id='SelCompanyID'> <input type='hidden' id='SelDelaerID'> <input type='hidden' id='SelCategoryID' style='text-align:right'> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody'> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table style='width:100%'> <thead> <th style='width:10%'>COMP. ID</th> <th style='width:15%'>COMPANY CODE</th> <th style='width:45%'>COMPANY NAME</th> <th style='width:30%'>ASSIGNED GM</th> </thead> </table> </div> <div class='PRFTableItems' style='height:600px;'> <table style='width:100%'> <?php $getItemHdr = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`= 1 ORDER BY comp_name ASC"); while($row=mysql_fetch_array($getItemHdr)){ $count = $count + 1; $assetCompID = $row['comp_id']; ?> <tr onclick="javascript:getCompanyID(this);"><!-- getCategoryIDonDblclick="javascript:showActionViewDelete(this);" >--> <?php echo "<td style='width:10%;vertical-align:top;font-family:Yu Gothic;font-size:14px;color:blue;font-weight:bold'>".$row['comp_id']."</td>"; echo "<td style='width:15%;vertical-align:top;font-family:Yu Gothic;font-size:14px;color:blue;font-weight:bold'>".strtoupper($row['comp_code'])."</td>"; echo "<td style='width:75%;vertical-align:top;font-family:Yu Gothic;font-size:14px;color:blue;font-weight:bold'>".strtoupper($row['comp_name']); echo "<div style='width:100%;padding:5px;padding-left:20px;border:0px;background:transparent '>"; $getavDealer = mysql_query("SELECT * FROM `vts_dealerships` WHERE `comp_id`='$assetCompID'"); echo "<table id='loadDealerAssetValidator' style='width:100%'>"; echo "<thead>"; while($vRow=mysql_fetch_array($getavDealer)){ ?><tr onclick="javascript:getDealershipID(this);"><?php echo "<td style='width:10%;font-weight:normal;color:#043468'>".$vRow['deal_id']."</td>"; echo "<td style='width:10%;font-weight:normal;color:#043468'>".$vRow['deal_code']."</td>"; echo "<td style='width:50%;font-weight:normal;color:#043468'>".$vRow['deal_name']."</td>"; echo "<td style='width:30%;font-weight:normal;color:#043468'>"; $getDealID = $vRow['deal_id']; $getDealGMID = mysql_result(mysql_query("SELECT `gm_id` FROM `vts_dealerships` WHERE `deal_id`='$getDealID'"),0); $dealGMLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getDealGMID'"),0); $dealGMFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getDealGMID'"),0); echo strtoupper($dealGMLname). ", ". strtoupper($dealGMFname); echo "</td>"; echo "</tr>"; } echo "</thead>"; echo "</table>"; echo "</div>"; echo"</td>"; echo "</tr>"; } ?> </table> </div> </div> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="showSetupDealerValidator" class="PopUpDealerValidator"> <div class='PopUpWindowTitle'> 🪧 DEALER ASSET VALIDATOR <div class='PopUpWindowClose'> <b onclick="javascript:hideDealerValidator(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td colspan = 2 style='padding:5px;width:100%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'> <input disabled type='text' id='activeDealer' style='text-align:left;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'> </td> </tr> <tr> <td style='padding:0px;padding-left:20px;width:60%;background:white;font-family:Yu Gothic; font-size:16px;color:black ;height:10px;font-weight:bold;text-align:left'> General Manager: <?php ?> <select id='dealGM' style='padding:15px width:69$'> <?php echo "<option value=''>-- SELECT GEN. MANAGER --</option>"; //$getGMList = 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_emp_id_a = vts_users.u_id GROUP BY cl_approving_officers.cl_emp_id_a ORDER BY vts_users.u_lname ASC"); $getGMList = mysql_query("SELECT * FROM `vts_users` WHERE approver = 1 AND `u_status`=1 GROUP BY u_name ORDER BY u_lname ASC"); while($row = mysql_fetch_array($getGMList)){ echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } ?> </select> </td> <td style='padding:0px;padding-left:30px;padding-right:30px;width:40%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'> <br><button id='updateGM' class='PopUpLowerButtonR' style='width:100%;height:35px;float:left;padding-left:5px'> ❌  UPDATE</button> </td> </tr> </table> <div id='dealerValidatorData' style='padding:10px;height:592px;width:100%;background:white;overflow:auto'> </div> </div> <!--########################## END OF EDIT/UPDATING PURCHASE REQEUST ############################################--> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>--> <!--<script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> --> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <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> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> $('.drop').bind("change",function(){ ShowUploadBar(); //var divID = $(this).attr('id'); // endaya var SelCompanyID = $("#SelCompanyID").val();// Approving Unit var validatorID = $(this).val(); // Approving Person var SelDelaerID = $("#SelDelaerID").val();// Approving Unit var SelCategoryID = $("#SelCategoryID").val(); // Company of Clearance template //alert(validatorID); //return false; $.ajax({ url: "PRF_SaveValidatorByCompany.php", type: "POST", async: false, data: { "SelCompanyID": SelCompanyID, "validatorID": validatorID, "SelDelaerID": SelDelaerID, "SelCategoryID": SelCategoryID, "done": 1 }, success: function(d){ //$("#templateUpdateMSG").html(d); ShowUploadBar(); } }) }); //======================================================================================================================================= //====================================================================================================== $("#updateGM").click(function(){ var dealGM = $("#dealGM").val(); var SelDelaerID = $("#SelDelaerID").val(); //alert(dealGM); //alert(SelDelaerID); if(dealGM == ""){ alert('please select General Manager from the list.'); exit; } ShowUploadBar(); $.ajax({ url: "prf_updateDealerGM.php", type: "POST", async: false, data: { "dealGM": dealGM, "SelDelaerID": SelDelaerID, "done": 1 }, success: function(d){ ShowUploadBar(); //Swal.fire('New Gen. Manager has been set. Please update asset validator below!', '', 'success') } }) }); //====================================================================================================== //======================================================================================================================================= //$("#loadDealerAssetValidator").click(function(){ function loadDealerAssetValidator(){ var SelCompanyID = $("#SelCompanyID").val();// Approving Unit var SelDelaerID = $("#SelDelaerID").val();// Approving Unit var SelCategoryID = $("#SelCategoryID").val(); // Company of Clearance template //alert(SelCompanyID); //alert(SelDelaerID); ShowUploadBar(); $.ajax({ url: "PRF_DealerAssetValidator.php", type: "POST", async: false, data: { "SelCompanyID": SelCompanyID, "SelDelaerID": SelDelaerID, "SelCategoryID": SelCategoryID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#dealerValidatorData").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } //======================================================================================================================================= //======================================================================================================================================= function hideDealerValidator(){ $("#showSetupDealerValidator").fadeOut(500); }; function showDealerValidator(){ $("#showSetupDealerValidator").fadeIn(500); }; function getCompanyID(row) { var x=row.cells; document.getElementById("SelCompanyID").value = x[0].innerHTML; loadDealerAssetValidator(); showDealerValidator(); } function getDealershipID(row) { SelDelaerID var x=row.cells; document.getElementById("SelDelaerID").value = x[0].innerHTML; document.getElementById("activeDealer").value = x[2].innerHTML; } function getCategoryID(row) { var x=row.cells; document.getElementById("SelCategoryID").value = x[0].innerHTML; } </script>

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