File manager - Edit - /home/autoph/public_html/connect/home/PRF_updateMatrixTable.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'>📝 APPROVAL MATRIX</p> </div> <div id='mainTable' class='PRFTableBody'> <div style='width:90%;height:33px;background:white'> <table style='width:100%'> <thead> <th style='width:10%'>LEVEL</th> <th style='width:25%'>DESCRIPTION</th> <th style='width:15%'>MIN. AMOUNT</th> <th style='width:15%'>MAX. AMOUNT</th> <th style='width:15%'>REQUIRED EXECOM</th> <th style='width:20%'>REQUIRED APPROVER</th> </thead> </table> </div> <div id='matrixTable' class='PRFTableItems' style='width:90%;height:350px;border:1px solid gray;overflow:auto'> <?php $getMatrixData = mysql_query("SELECT * FROM `prf_approval_matrix` WHERE `deleted`=0 ORDER BY `level` ASC"); echo "<table style='width:100%'>"; while($row=mysql_fetch_array($getMatrixData)){ $fixApprover = $row['requiredApproverID']; $fixAPproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0); $fixAPproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0); ?><tr onclick="javascript:getMatrixInfo(this);" onDblclick="javascript:showActionViewDelete(this);" ><?php echo "<td style='width:10%;text-align:center;font-family:Yu Gothic Light;font-size:14px'>".$row['level']."</td>"; echo "<td style='width:25%;text-align:left;font-family:Yu Gothic Light;font-size:14px'>".$row['description']."</td>"; echo "<td style='width:15%;text-align:left;font-family:Yu Gothic Light;font-size:14px'>".$row['min_amount']."</td>"; echo "<td style='width:15%;text-align:left;font-family:Yu Gothic Light;font-size:14px'>".$row['max_amount']."</td>"; echo "<td style='width:15%;text-align:center;font-family:Yu Gothic Light;font-size:14px'>".$row['requiredExecom']."</td>"; echo "<td style='width:20%;text-align:left;font-family:Yu Gothic Light;font-size:14px'>".strtoupper($fixAPproverLName).", ".strtoupper($fixAPproverFName)."</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <div class='PRFTableItems' style='padding:10px;width:70%;height:200px;border:1px solid gray;margin-top:10px;font-size:12px;color:black'> <p style='margin:0px;font-family:Yu Gothic Light;font-size:16px;color:gray;font-weight:bold'>Matrix Data:</p> <div style='float:left;width:10%;border:0px solid lightgray;padding:3px'> Level:<input type='text' id='myLevel' style='width:100%;float:left;padding:10px;text-align:center'></input> </div> <div style='float:left;width:30%;border:0px solid lightgray;padding:3px'> Description:<input type='text' id='myDesciption' style='width:100%;float:left;padding:10px;text-align:left'></input> </div> <div style='float:left;width:15%;border:0px solid lightgray;padding:3px'> Min. Amount:<input type='text' id='myMinimum' style='width:100%;float:left;padding:10px;text-align:center'></input> </div> <div style='float:left;width:15%;border:0px solid lightgray;padding:3px'> Max. Amount:<input type='text' id='myMaximum' style='width:100%;float:left;padding:10px;text-align:center'></input> </div> <div style='float:left;width:15%;border:0px solid lightgray;padding:3px'> Req. EXECOM:<input type='text' id='myApprover' style='width:100%;float:left;padding:10px;text-align:center'></input> </div> <div style='float:left;width:15%;border:0px solid lightgray;padding:3px'> Fixed Approver:<input type='text' id='fixedApprover' style='width:100%;float:left;padding:10px;text-align:center'></input> </div> <button id='updateMyMatrixTable' class='PopUpLowerButtonR' style='width:20%'>Update<button> </div> </div> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> function getMatrixInfo(row) { var x=row.cells; document.getElementById("myLevel").value = x[0].innerHTML; document.getElementById("myDesciption").value = x[1].innerHTML; document.getElementById("myMinimum").value = x[2].innerHTML; document.getElementById("myMaximum").value = x[3].innerHTML; document.getElementById("myApprover").value = x[4].innerHTML; document.getElementById("fixedApprover").value = x[5].innerHTML; } </script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#updateMyMatrixTable").click(function(){ var myLevel = $("#myLevel").val(); var myDesciption = $("#myDesciption").val(); var myMinimum = $("#myMinimum").val(); var myMaximum = $("#myMaximum").val(); var myApprover = $("#myApprover").val(); var fixedApprover = $("#fixedApprover").val(); //alert(myDesciption); //xit; ShowUploadBar(); $.ajax({ url: "prf_SaveUpdatedMatrix.php", type: "POST", async: false, data: { "myLevel": myLevel, "myDesciption": myDesciption, "myMinimum": myMinimum, "myMaximum": myMaximum, "myApprover": myApprover, "fixedApprover": fixedApprover, "done": 1 }, success: function(d){ ShowUploadBar(); $("#matrixTable").html(d); } }) }); }); </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings