File manager

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

Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; ?> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="icon" href="images/ahg_logo.png"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> </head> <body> <?php 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); $getGMID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$getPRFCode'"),0); $getEXED = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$myUID' AND `authority` < 4"),0); $chkAuthority = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `authority`='$matrixLabe' AND `execom_id`='$myUID'"),0); //echo "My UID" .$myUID . " Dept: ".$getDeptID . " - GM: ".$getGMID. " - Execom: ".$getEXED ."<br><br>"; ?> <?php switch($matrixLabe){ case '5': //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if($getDeptID == $myUID ){ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> <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['canvass_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 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ }else{ echo "<p style='margin:30px;padding:10px;font-family:Yu Gothic Light;color:red;font-size:18px;font-weight:normal;text-align:center'>Sorry, this item has been assigned to another approving officers</p>"; $getLinkSignatory = mysql_query("SELECT * FROM `prf_validate_links` WHERE `item_id`='$SeletedPRFItemID' AND `deleted`=0 AND `completed`=0"); ?><table style='width:50%;float:right' id='sendSM'> <thead> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white;text-decoration:underline'>ACTION</th> <th style='background:white;border:1px solid white;text-decoration:underline'>PENDING APPROVAL</th> </thead> <?php while($sRow = mysql_fetch_array($getLinkSignatory)){ ?><tr onclick="javascript:getInfoBXXX(this);"><?php echo "<td style='width:10px;color:transparent;background:white'>".$sRow['uid']."</td> <td style='width:10px;color:transparent;background:white'>".$sRow['item_id']."</td> <td style='width:100px;color:red'>Click to send SMS</td> <td>"; $getUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); $getULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); echo strtoupper($getULName).", ". strtoupper($getUFName); echo"</td>"; echo "</tr>"; } echo "</table>"; exit; } break; case '4': //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if($getGMID == $myUID){ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> <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['canvass_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 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ }else{ echo "<p style='margin:30px;padding:10px;font-family:Yu Gothic Light;color:red;font-size:18px;font-weight:normal;text-align:center'>Sorry, this item has been assigned to another approving officers</p>"; $getLinkSignatory = mysql_query("SELECT * FROM `prf_validate_links` WHERE `item_id`='$SeletedPRFItemID' AND `deleted`=0 AND `completed`=0"); ?><table style='width:50%;float:right' id='sendSM'> <thead> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white;text-decoration:underline'>ACTION</th> <th style='background:white;border:1px solid white;text-decoration:underline'>PENDING APPROVAL</th> </thead> <?php while($sRow = mysql_fetch_array($getLinkSignatory)){ ?><tr onclick="javascript:getInfoBXXX(this);"><?php echo "<td style='width:10px;color:transparent;background:white'>".$sRow['uid']."</td> <td style='width:10px;color:transparent;background:white'>".$sRow['item_id']."</td> <td style='width:100px;color:red'>Click to send SMS</td> <td>"; $getUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); $getULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); echo strtoupper($getULName).", ". strtoupper($getUFName); echo"</td>"; echo "</tr>"; } echo "</table>"; exit; } break; case '3': //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if($getEXED > 0){ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> <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['canvass_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 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ }else{ echo "<p style='margin:30px;padding:10px;font-family:Yu Gothic Light;color:red;font-size:18px;font-weight:normal;text-align:center'>Sorry, this item has been assigned to another approving officers</p>"; $getLinkSignatory = mysql_query("SELECT * FROM `prf_validate_links` WHERE `item_id`='$SeletedPRFItemID' AND `deleted`=0 AND `completed`=0"); ?><table style='width:50%;float:right' id='sendSM'> <thead> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white;text-decoration:underline'>ACTION</th> <th style='background:white;border:1px solid white;text-decoration:underline'>PENDING APPROVAL</th> </thead> <?php while($sRow = mysql_fetch_array($getLinkSignatory)){ ?><tr onclick="javascript:getInfoBXXX(this);"><?php echo "<td style='width:10px;color:transparent;background:white'>".$sRow['uid']."</td> <td style='width:10px;color:transparent;background:white'>".$sRow['item_id']."</td> <td style='width:100px;color:red'>Click to send SMS</td> <td>"; $getUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); $getULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); echo strtoupper($getULName).", ". strtoupper($getUFName); echo"</td>"; echo "</tr>"; } echo "</table>"; exit; } break; case '2': //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if($getEXED > 0){ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> <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['canvass_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 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ }//else{ echo "<p style='margin:30px;padding:10px;font-family:Yu Gothic Light;color:red;font-size:18px;font-weight:normal;text-align:center'>Sorry, this item has been assigned to another approving officers</p>"; $getLinkSignatory = mysql_query("SELECT * FROM `prf_validate_links` WHERE `item_id`='$SeletedPRFItemID' AND `deleted`=0"); ?><table style='width:50%;float:right' id='sendSM'> <thead> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white;text-decoration:underline'>ACTION</th> <th style='background:white;border:1px solid white;text-decoration:underline'>PENDING APPROVAL</th> </thead> <?php while($sRow = mysql_fetch_array($getLinkSignatory)){ ?><tr onclick="javascript:getInfoBXXX(this);"><?php echo "<td style='width:10px;color:transparent;background:white'>".$sRow['uid']."</td> <td style='width:10px;color:transparent;background:white'>".$sRow['item_id']."</td> <td style='width:100px;color:red'>Click to send SMS</td> <td>"; $getUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); $getULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); echo strtoupper($getULName).", ". strtoupper($getUFName); echo"</td>"; echo "</tr>"; } echo "</table>"; exit; //} break; case '1': //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if($getEXED > 0 ){ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> <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['canvass_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 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ }else{ echo "<p style='margin:30px;padding:10px;font-family:Yu Gothic Light;color:red;font-size:18px;font-weight:normal;text-align:center'>Sorry, this item has been assigned to another approving officers</p>"; $getLinkSignatory = mysql_query("SELECT * FROM `prf_validate_links` WHERE `item_id`='$SeletedPRFItemID' AND `deleted`=0 AND `completed`=0"); ?><table style='width:50%;float:right' id='sendSM'> <thead> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white'></th> <th style='background:white;border:1px solid white;text-decoration:underline'>ACTION</th> <th style='background:white;border:1px solid white;text-decoration:underline'>PENDING APPROVAL</th> </thead> <?php while($sRow = mysql_fetch_array($getLinkSignatory)){ ?><tr onclick="javascript:getInfoBXXX(this);"><?php echo "<td style='width:10px;color:transparent;background:white'>".$sRow['uid']."</td> <td style='width:10px;color:transparent;background:white'>".$sRow['item_id']."</td> <td style='width:100px;color:red'>Click to send SMS</td> <td>"; $getUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); $getULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$sRow['uid']."'"),0); echo strtoupper($getULName).", ". strtoupper($getUFName); echo"</td>"; echo "</tr>"; } echo "</table>"; exit; } break; } } ?> <body> </body> </html>

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