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 ""; while($row=mysql_fetch_array($getMatrixData)){ ?>".$row['level'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$row['description']."

".$row['min_amount']."

".$row['max_amount']."

".$row['requiredExecom']."

".$row['constant_approver']."

"; } exit(); ?>