File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_LOADEXECOMApprovedCanvass.php

Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $SeletedPRFItemID = mysql_escape_string($_POST['SeletedPRFItemID']); $selectedPRFHeaderID = mysql_escape_string($_POST['selectedPRFHeaderID']); $matrixLabe = mysql_escape_string($_POST['matrixLabe']); $matrixLabeName = mysql_escape_string($_POST['matrixLabeName']); $getPRFCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$selectedPRFHeaderID'"),0); $getDeptID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$getPRFCode'"),0); $chkAuthority = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `authority`='$matrixLabe' AND `execom_id`='$myUID'"),0); //echo $chkAuthority . " - ".$matrixLabe; ?> <div style='width:100%;height:30px;background:yellow'> <table> <thead> <th style='width:7%'>REC#</th> <th style='width:10%'>RANK</th> <th style='width:45%'>SUPPLIER'S NAME</th> <th style='width:7%'>QTY</th> <th style='width:10%;text-align:right'>AMOUNT</th> <th style='width:15%;text-align:left'>USER ACTION</th> <th style='width:6%'>VIEW</th> </thead> </table> </div> <div class='PRFTableItems' style='padding:0px;background:white;height:140px'> <table> <?php $getItemInfo = mysql_query(" SELECT 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.id, prf_canvass_sheet.canvass_id, prf_uploadedcanvass.`ref_code`, prf_canvass_sheet.`user_feedback`, 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.`user_canvass_approval`=1 AND prf_canvass_sheet.item_id='$SeletedPRFItemID' ORDER BY prf_canvass_sheet.amount ASC"); while($row=mysql_fetch_array($getItemInfo)){ $cvFileCode = $row['file_code']; $uFeedBack = $row['user_feedback']; if($uFeedBack==1){ $txtColor='green'; $bold='bold'; }else{ $txtColor='gray'; $bold='normal'; } $chkExecomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `canvass_id`='".$row['id']."'"),0); if($chkExecomApproval!= 0){ $MyStar ='⭐'; }else{ $MyStar =''; } $order = $order + 1; ?><tr onclick="javascript:getSelectedCanvassInfo(this);" ><?php echo "<td style='width:7%;color:$txtColor;font-weight:$bold'>".$row['id']."</td>"; echo "<td style='width:10%;color:$txtColor;font-weight:$bold'>Rank # ".$order."</td>"; echo "<td style='width:45%;color:$txtColor;font-weight:$bold'>".strtoupper($row['vendor_name'])." ".$MyStar."</td>"; echo "<td style='width:7%;text-align:center;color:$txtColor;font-weight:$bold'>".$row['quantity']."</td>"; echo "<td style='width:10%;text-align:right;color:$txtColor;font-weight:$bold'>".$row['amount']."</td>"; echo "<td style='width:15%;text-align:left;color:$txtColor;font-weight:$bold'>"; $getRecoData = mysql_result(mysql_query("SELECT `desc` FROM `prf_user_recommendation` WHERE `deleted`=0 AND `id`='$uFeedBack' "),0); echo $getRecoData; echo "</td>"; echo "<td style='width:6%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> <?php } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings