File manager - Edit - /home/autoph/public_html/connect/home/prf_SaveUpdatedMatrix.php
Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $myLevel = mysql_escape_string($_POST['myLevel']); $myDesciption = mysql_escape_string($_POST['myDesciption']); $myMinimum = mysql_escape_string($_POST['myMinimum']); $myMaximum = mysql_escape_string($_POST['myMaximum']); $myApprover = mysql_escape_string($_POST['myApprover']); $myApprover = mysql_escape_string($_POST['myApprover']); $fixedApprover = mysql_escape_string($_POST['fixedApprover']); mysql_query("INSERT INTO prf_poapprover(comp_id,po_officer_id,authority,trans_type) VALUES('{$getCompID}','{$getExecom}','{$getAuthority}','{$aprRole}')"); $chkIfExist=mysql_result(mysql_query("SELECT COUNT(`id`) FROM `prf_approval_matrix` WHERE `level`='$myLevel'"),0); if($chkIfExist == 0){ mysql_query("INSERT INTO prf_approval_matrix(level,description,min_amount,max_amount,required_officers) VALUES('{$myLevel}','{$myDesciption}','{$myMinimum}','{$myMaximum}','{$myApprover}')"); }else{ mysql_query("UPDATE `prf_approval_matrix` SET `description`='$myDesciption', `min_amount`='$myMinimum', `max_amount`='$myMaximum', `requiredExecom`='$myApprover' , `constant_approver`='$fixedApprover' WHERE `level`='$myLevel'"); } $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)){ ?><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:30%;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:15%;text-align:center;font-family:Yu Gothic Light;font-size:14px'>".$row['constant_approver']."</td>"; echo "</tr>"; } echo "</table>"; } exit(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings