File manager - Edit - /home/autoph/public_html/tasks/PRF_AutohubAdminItemApproval.php.tar
Back
home/autoph/public_html/PRF_AutohubAdminItemApproval.php 0000644 00000005605 15024754507 0017441 0 ustar 00 <?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'); $myDateD = date_create() ->format("Y-m-d"); $myDate = $myDateD . " " .$prfTime; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $DelActionReferenceID = mysql_escape_string($_POST['DelActionReferenceID']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); mysql_query("UPDATE `prf_request_detl` SET `for_canvass`='1', `item_status`='5', `ahg_admin_id`='$myUID', `ahg_admin_date`='$myDate' WHERE `header_ref_code`='$UpdatePRFReferenceNumber' AND `deleted`=0"); mysql_query("UPDATE `prf_request_hdr` SET `ahg_admin_id`='$myUID', `ahg_admin_date`='$myDate' WHERE `reference_code`='$UpdatePRFReferenceNumber'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber'"); echo "<table>"; echo "<thead>"; echo "<th style='width:100px'>Rec.#</th>"; echo "<th style='width:155px'>REF. #</th>"; echo "<th style='width:300px'>ITEM DESCRIPTION</th>"; echo "<th style='width:50px'>UoM</th>"; echo "<th style='width:50px'>QUANTITY</th>"; echo "<th style='width:25px'>-</th>"; echo "</thead>"; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemStatusChk=$row['ahg_admin_id']; $isDeleted = $row['deleted']; if($itemStatusChk == 0){ if($isDeleted == 1){ $txtcolor='red'; $itemStatus='❌'; }else{ $txtcolor='black'; $itemStatus='❔'; } }else{ $itemStatus='✅'; $txtcolor='black'; } ?><tr onclick="javascript:POPUPShowDeleteSubItem(this);"><?php echo "<td style='font-family:Calibri;color:$txtcolor'>".$row['id']."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['header_ref_code'])."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['item_description'])."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['uom'])."</td>"; echo "<td style='text-align:center;font-family:Calibri;color:$txtcolor'>".strtoupper($row['quantity'])."</td>"; echo "<td style='tet-align:center;padding-left:15px;font-family:Calibri;color:$txtcolor'>"; echo $itemStatus; echo "</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings