File manager - Edit - /home/autoph/public_html/connect/home/prf_updateGrabItem.php
Back
<?php include 'core/init.php'; $activeID=$user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prtTime =date('H:i:s'); $tsDate = $prfDate . " ".$prtTime; //echo "Date: ". $prfDate; if(isset($_POST['done'])){ $myCanvassPRFCode = mysql_escape_string($_POST['myCanvassPRFCode']); $getBuyer = mysql_escape_string($_POST['getBuyer']); $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); mysql_result(mysql_query("UPDATE `prf_request_detl` SET `canvass_by` = '$getBuyer',`date_time_pick`='$tsDate' WHERE `header_ref_code`='$UpdatePRFReferenceNumber'"),0); } ?> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' AND `canvass_by`='0' ORDER BY `ahg_admin_date` ASC"); while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $attDoc =mysql_result(mysql_query("SELECT `attachment` FROM `prf_request_hdr` WHERE `reference_code`='$itemRefCode'"),0); $Cat = $row['category_id']; $picTS = $row['date_time_pick']; $SubCat = $row['sub_category_id']; $CatName = mysql_result(mysql_query("SELECT description FROM prf_expensecategory WHERE id='$Cat'"),0); $SubCatName = mysql_result(mysql_query("SELECT description FROM prf_expenseitems WHERE id='$SubCat'"),0); $compCode = mysql_result(mysql_query("SELECT comp_code FROM vts_company WHERE comp_id='".$row['comp_id']."'"),0); $dealCode = mysql_result(mysql_query("SELECT deal_code FROM vts_dealerships WHERE deal_id='".$row['dealer_id']."'"),0); $reqBy = mysql_result(mysql_query("SELECT request_by FROM prf_request_hdr WHERE reference_code='$itemRefCode'"),0); $canBy = $row['canvass_by']; $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqBy'"),0); $canByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$canBy'"),0); $canByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$canBy'"),0); $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); //if($getPRFApprovalCode == 4){ //onDblclick="javascript:showActionViewDelete(this);" ?><tr onclick="javascript:showPRFheaderForDeletion(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:7%'>".strtoupper($row['header_ref_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['ahg_admin_date'])."</td>"; echo "<td style='width:7%'>".strtoupper($dealCode)."</td>"; echo "<td style='width:40%;text-align:left'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:5%;text-align:center'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:8%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:8%'>".strtoupper($canByLName).", ".strtoupper($canByFName)."<br>".$picTS."</td>"; echo "<td style='width:13%'>".strtoupper($CatName)."</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $withMail ='📝'; $attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $noMail = '-'; if($chkAttachment > 0){ echo "<a href='FILES/prfdoc/".$attFilename."' target='_Blank'><abbr title='View Attached document'>📑</abbr></a>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; //} } ?> </table>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings