File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_DealerAssetValidator.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; if(isset($_POST['done'])){ $SelCompanyID = mysql_escape_string($_POST['SelCompanyID']); $SelDelaerID = mysql_escape_string($_POST['SelDelaerID']); $SelCategoryID = mysql_escape_string($_POST['SelCategoryID']); echo "<input id='actCompID' type='hidden' value='".$SelCompanyID."'>"; echo "<input id='actDealID' type='hidden' value='".$SelDelaerID."'>"; echo "<input id='actCategoryID' type='hidden' value='".$SelCategoryID."'>"; //echo $SelCompanyID; //echo "<br>".$SelDelaerID; echo "<table>"; ?> <?php $getAssetList = mysql_query("SELECT * FROM `prf_expenseitems` WHERE `status`=1 ORDER BY `category_id` ASC"); while($aRow = mysql_fetch_array($getAssetList)){ $expenseID =$aRow['id']; $catName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='".$aRow['category_id']."'"),0); $getOldValidatorID=mysql_result(mysql_query("SELECT `approver_id` FROM `prf_company_asset_approver` WHERE `comp_id`='$SelCompanyID' AND `expense_item_id`='$expenseID' AND `deal_id`='$SelDelaerID'"),0); $getOldValidatorLName = mysql_result(mysql_query("SELECT u_lname from vts_users where u_id='$getOldValidatorID'"),0); $getOldValidatorFName = mysql_result(mysql_query("SELECT u_Fname from vts_users where u_id='$getOldValidatorID'"),0); echo "<table>"; ?> <tr onclick="javascript:getCategoryID(this);"><!-- getCategoryIDonDblclick="javascript:showActionViewDelete(this);" >--> <?php echo "<td style='width:5%'>".$aRow['id']."</td>"; echo "<td style='width:60%'><b style='font-size:11px;color:blue'>".$catName."</b> - ".$aRow['description']."</td>"; echo "<td style='width:40%;padding:0px;font-size:11px;'>"; echo "<select name='AssetValidator[]' class='dropB' id='". $divID."' style='margin:0px;padding:2px;font-size:11px;'>"; echo "<option value='0'>".strtoupper($getOldValidatorLName).", ".strtoupper($getOldValidatorFName)."</option>"; //$getClearingOfficerList = 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"); $getClearingOfficerList = mysql_query("SELECT * FROM `vts_users` WHERE approver = 1 AND `u_status`=1 ORDER BY u_lname ASC"); while($row = mysql_fetch_array($getClearingOfficerList)){ echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } echo "</select>"; echo "</td>"; echo "<tr>"; echo "</table>"; } echo "</table>"; } ?> <!--- 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"> $('.dropB').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(); } }) }); </script>

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