File manager

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

Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); ?> <p style='font-family:Yu Gothic Light;font-size:16px;font-weight:bold;color:white;background:black;margin:0px;padding:3px'>ACTIVE PROPOSALS</p> <div style='width:100%;height:33px;background:white;margin:0px'> <table style='width:100%'> <thead> <th class='loadcanvassuser' style='width:8%;'>C.ID</th> <th class='loadcanvassuser' style='width:40%;'>VENDOR NAME</th> <th class='loadcanvassuser' style='width:10%;'>QTY</th> <th class='loadcanvassuser' style='width:15%;'>PRICE PER UNIT</th> <th class='loadcanvassuser' style='width:19%;'>TOTAL AMOUNT</th> <th class='loadcanvassuser' style='width:8%;'></th> </thead> </div> <div style='width:100%;height:auto;background:lightgray'> <table style='width:100%'> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_canvass_sheet` WHERE `deleted`=0 AND item_id='$itemID' AND `user_feedback` BETWEEN 1 AND 3"); while($csRow = mysql_fetch_array($getActiveProposals)){ $cvsID = $csRow['id']; $userFBack = $csRow['user_feedback']; if($userFBack==1){ $txtColor='#a8fc9c'; $weight='bold'; }else{ $txtColor='white'; $weight='normal'; } $cvID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$cvsID'"),0); $venCode = mysql_result(mysql_query("SELECT `vendor_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $venName = mysql_result(mysql_query("SELECT `vendor_name` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $chkExecomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `canvass_id`='".$csRow['id']."'"),0); if($chkExecomApproval!= 0){ $MyStar ='⭐'; }else{ $MyStar =''; } $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getExecomApprovedVendor(this);"><?php echo "<td class='loadcanvassuser' style='cursor:pointer;width:8%;background:$txtColor;font-weight:$weight' '>".$csRow['id']."</td>"; echo "<td class='loadcanvassuser' style='cursor:pointer;width:40%;background:$txtColor;font-weight:$weight' >"; echo strtoupper($venName) . " ".$MyStar; echo "</td>"; echo "<td class='loadcanvassuser' style='cursor:pointer;width:10%;background:$txtColor;font-weight:$weight' >".$csRow['quantity']."</td>"; echo "<td class='loadcanvassuser' style='cursor:pointer;width:15%;background:$txtColor;font-weight:$weight' >"; $itemPrice = $csRow['amount']; $itemFPrice = number_format($itemPrice,2,'.',","); echo $itemFPrice; echo"</td>"; echo "<td class='loadcanvassuser' style='cursor:pointer;width:19%;background:$txtColor;font-weight:$weight' >"; $qty = $csRow['quantity']; $unitPrice = $csRow['amount']; $itemTotalPrice = $qty * $unitPrice; $itemTotalFPrice = number_format($itemTotalPrice,2,'.',","); echo $itemTotalFPrice; echo"</td>"; echo "<td class='loadcanvassuser' style='width:8%;text-align:center;background:$txtColor;font-weight:$weight'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank' style='text-shadow:3px 3px gray'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> <?php } ?> <!--################################################################################################################################### ⭐ --> <!--###################################################################################################################################--> <script type="text/javascript"> function hideCreatedCanvassForm(){ $("#showGenCanvassForm").fadeOut(500); }; function showCreatedCanvassForm(){ $("#showGenCanvassForm").fadeIn(500); }; function getExecomApprovedVendor(row) { var x=row.cells; document.getElementById("ExecomSelectedCanvassID").value = x[0].innerHTML; document.getElementById("selectedVendor").value = x[1].innerHTML; document.getElementById("selectedVendorQty").value = x[2].innerHTML; document.getElementById("selectedVendorAmount").value = x[3].innerHTML; } </script>

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