File manager - Edit - /home/autoph/public_html/connect/home/prf_getExecomApprovedCanvass.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $exeItemID = mysql_escape_string($_POST['exeItemID']); ?> <table> <thead> <th style='width:5%;padding:3px'>REC.#</th> <th style='width:10%;padding:3px'>CANVASS ID</th> <th style='width:10%;padding:3px'>PRF #</th> <th style='width:10%;padding:3px'>ITEM CODE</th> <th style='width:30%;padding:3px'>VENDOR</th> <th style='width:20%;padding:3px'>APPROVED BY</th> <th style='width:10%;padding:3px'>AMOUNT</th> </thead> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_execomcanvassapproval` WHERE `item_code`=$exeItemID"); while($row=mysql_fetch_array($getItemHdr)){ $cID = $row['comp_id']; $venID = $row['vendor_id']; $aprEXECOMID = $row['approved_by_execom']; $exeFName =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprEXECOMID'"),0); $exeLName =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprEXECOMID'"),0); $exeFLName = strtoupper($exeLName) .", ".strtoupper($exeFName); $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$venID'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$cID'"),0); ?><tr onclick="javascript:getApprovedCanvassID(this);"><?php echo "<td style='width:5%;padding:3px'>".$row['id']."</td>"; echo "<td style='width:10%;padding:3px'>".$row['canvass_id']."</td>"; echo "<td style='width:10%;padding:3px'>".$row['prf_ref_code']."</td>"; echo "<td style='width:10%;padding:3px'>".$row['item_code']."</td>"; echo "<td style='width:30%;padding:3px'>".$vendorName."</td>"; echo "<td style='width:20%;padding:3px'>".$exeFLName."</td>"; echo "<td style='width:10%;padding:3px'>".$row['approved_amount']."</td>"; //echo "<td style='width:5%;text-align:center;padding:3px'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$fileCode."' target='_blank'>📋</a></td>"; echo "</tr>"; } ?> </table> <?php } ?> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script language="javascript" type="text/javascript"> function getApprovedCanvassID(row) { var x=row.cells; document.getElementById("selectedProposalID").value = x[0].innerHTML; //$('#searchText').val(''); } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings