File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_SaveUserEndorsedProposal.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'])){ $canvassRecoValue = mysql_escape_string($_POST['canvassRecoValue']); $selectedRecordID = mysql_escape_string($_POST['selectedRecordID']); $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_canvass_sheet` WHERE `item_id`='$selectedRecordID' AND `user_feedback`!=0"),0); if($checkIfExist==0){ echo "<script>alert('ERROR: You need to approve or endorse at least one (1) proposal or specfication.')</script>"; exit; } mysql_query("UPDATE `prf_request_detl` SET `create_canvass_sheet`='1',`user_approval_ts`='$prfDateTime' WHERE `id`='$selectedRecordID'"); $refCodeID = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id='$selectedRecordID'"),0); mysql_query("UPDATE `prf_request_hdr` SET `current_status`='6' WHERE `reference_code`='$refCodeID'"); } ?> <div style='width:100%;height:30px;background:white'> <table> <thead> <th style='width:10%'>REC. NO</th> <th style='width:65%'>ITEM DESCRIPTION</th> <th style='width:10%'>QUANTITY</th> <th style='width:5%'>UOM</th> <th style='width:10%;text-align:right'>DATE NEEDED</th> </thead> </table> </div> <div class='PRFTableItems' style='padding:0px;background:white'> <table> <?php $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.request_by, prf_request_detl.header_ref_code, prf_request_detl.item_description, prf_request_detl.uom, 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_hdr.request_by='$myUID' AND `user_canvass_approval`=1 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);" onDblclick="javascript:showUserAction(this);" id='LoadActiveCanvassForUserApproval' ><?php echo "<td style='width:10%'>".$row['id']."</td>"; echo "<td style='width:65%'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:10%;text-align:center'>".$row['quantity']."</td>"; echo "<td style='width:5%;text-align:center'>".strtoupper($row['uom'])."</td>"; echo "<td style='width:10%;text-align:right'>".$row['date_needed']."</td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='9' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:bold'> <input type='hidden' id='selectedRecordID' class='TableBottomLabel'> <p style='float:left;width:auto;padding-right:10px'>Selected Record:</p> <p style='float:left:width:70%;font-family:Yu Gothic Light;color:gray' id='selectedPRFHeaderIDLabel'></p> </td> </tr> </table> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings