File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_UpdateCanvassLists.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); if(isset($_POST['trans'])){ $ItemRecordIDLoad = mysql_escape_string($_POST['ItemRecordIDLoad']); ?> <table> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_uploadedcanvass` WHERE `deleted`=0 AND `validity_date` > '$prfDate'"); while($cRow = mysql_fetch_array($getActiveProposals)){ $cvID = $cRow['id']; $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `canvass_id`='$cvID' AND `item_id`='$ItemRecordIDLoad'"),0); if($checkIfExist==0){ $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getCanvassInfo(this);" onDblClick="javascript:showEndorseForm(this);"><?php echo "<td style='width:10.5%;font-size:12px;padding:3px;color:black'>".$cRow['date_added']."</td>"; echo "<td style='width:15%;font-size:12px;padding:3px;color:black'>".$cRow['ref_code']."</td>"; echo "<td style='width:15.5%;font-size:12px;padding:3px;color:black'>".$cRow['vendor_code']."</td>"; echo "<td style='width:30.5%;font-size:12px;padding:3px;color:black'>"; $uploadVCode = $cRow['vendor_code']; $supName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE sup_code='$uploadVCode'"),0); echo strtoupper($supName); echo "</td>"; echo "<td style='width:10%;font-size:12px;padding:3px;color:black'>".$cRow['validity_date']."</td>"; echo "<td style='width:20%;font-size:12px;padding:3px;color:black'>"; $uploadID = $cRow['uploaded_by']; $upFname = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadID'"),0); $upLname = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadID'"),0); echo strtoupper($upLname). ", ".strtoupper($upFname); echo "</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } } ?> </table> <?php } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings