File manager - Edit - /home/autoph/public_html/connect/home/PRF_ApprovedReviewedCanvass.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ $selectedRecordID = mysql_escape_string($_POST['selectedRecordID']); mysql_query("UPDATE `prf_request_detl` SET `approved_canvass` = '1',`canvass_review_date`='$prfDateTime', `item_status`=5 WHERE `id` = '$selectedRecordID'"); $getItemInfo = mysql_query(" SELECT prf_request_detl.id, prf_request_hdr.reference_code, prf_request_hdr.`comp_id`, prf_request_hdr.`deal_id`, prf_request_hdr.category_id, prf_request_hdr.sub_category_id, prf_request_hdr.date_needed, prf_request_hdr.purpose_of_request, prf_request_hdr.request_by, prf_request_detl.header_ref_code, prf_request_detl.item_description, prf_request_detl.uom, prf_request_detl.approved_canvass, prf_request_detl.item_status, prf_canvass_sheet.item_id, prf_canvass_sheet.canvass_id, prf_uploadedcanvass.`ref_code`, prf_canvass_sheet.quantity, prf_canvass_sheet.amount, prf_canvass_sheet.item_id, prf_uploadedcanvass.`vendor_id`, prf_uploadedcanvass.`vendor_code`, prf_uploadedcanvass.`vendor_name`, prf_uploadedcanvass.`file_code` FROM `prf_request_hdr` JOIN `prf_request_detl` ON prf_request_detl.`header_ref_code` = prf_request_hdr.reference_code JOIN prf_canvass_sheet ON prf_canvass_sheet.item_id = prf_request_detl.id JOIN prf_uploadedcanvass ON prf_uploadedcanvass.`id` = prf_canvass_sheet.`canvass_id` WHERE prf_request_detl.deleted=0 AND prf_request_detl.`user_canvass_approval`=1 AND prf_request_detl.`user_approval_ts`='' AND prf_request_detl.`create_canvass_sheet`= 0 AND prf_request_detl.approved_canvass = 0 GROUP BY prf_canvass_sheet.item_id ORDER BY prf_request_detl.item_description ASC "); while($row=mysql_fetch_array($getItemInfo)){ $cvFileCode = $row['file_code']; ?><tr onclick="javascript:getUserActionInfo(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:50%'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:14%;text-align:left'>".$row['purpose_of_request']."</td>"; echo "<td style='width:5%;text-align:center'>".$row['quantity']."</td>"; echo "<td style='width:8%;text-align:center'>".strtoupper($row['uom'])."</td>"; echo "<td style='width:8%;text-align:right'>".$row['date_needed']."</td>"; echo "</tr>"; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings