File manager

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

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $poNumber = mysql_escape_string($_POST['poNumber']); ?> <table style='width:100%'> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`= '$poNumber' AND `deleted`=0 ORDER BY `id` ASC"); while($row=mysql_fetch_array($getItemHdr)){ ?><tr onclick="javascript:getInfo(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10.5%'>".$row['header_ref_code']."</td>"; echo "<td style='width:15.2%'>".$row['po_code']."</td>"; echo "<td style='width:56.1%'>".$row['item_description']."</td>"; echo "<td style='width:5%'>".$row['approved_qty']."</td>"; echo "<td style='width:10%'>".$row['approved_amount']."</td>"; echo "</tr>"; } ?> </table> <?php } if(isset($_POST['update'])){ $selOldPOQty = mysql_escape_string($_POST['selOldPOQty']); $selOldPOAmount = mysql_escape_string($_POST['selOldPOAmount']); $selPOAmount = mysql_escape_string($_POST['selPOAmount']); $selNewPOQty = mysql_escape_string($_POST['selNewPOQty']); $newAmount = str_replace(',','',$selPOAmount); $selItemPOID = mysql_escape_string($_POST['selItemPOID']); $selPONumber = mysql_escape_string($_POST['selPONumber']); $chkPOStatus = mysql_result(mysql_query("SELECT `po_status` FROM `prf_purchase_order` WHERE `po_number`='$selPONumber'"),0); if($chkPOStatus > 4 ){ echo '<script>alert("ERROR: This PO has already been processed. Changing the price is not permitted. Please contact your system administrator for assistance. Thank you!")</script>'; echo "<p style='margin:5px;padding:5px;font-family:Yu Gothic Light;font-size:16px;color:red'> ERROR:<br>This PO has already been processed. Changing the price is not permitted. Please contact your system administrator for assistance. Thank you!</p>"; }else{ $selCanvassID = mysql_result(mysql_query("SELECT `approved_proposal_code` FROM `prf_request_detl` WHERE `id`='$selItemPOID'"),0); mysql_query("UPDATE `prf_request_detl` SET `approved_amount` = '$newAmount',`approved_qty` = '$selNewPOQty' WHERE `id`='$selItemPOID'"); mysql_query("UPDATE `prf_canvass_sheet` SET `amount` = '$newAmount' WHERE `item_id`='$selItemPOID' AND `canvass_id`='$selCanvassID'"); mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number,item_id) VALUES('','Change P.O Price','{$activeID}','{$selOldPOAmount}','{$selPOAmount}','{$selPONumber}','{$selItemPOID}')"); ?> <table style='width:100%'> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`= '$selPONumber' AND `deleted`=0 ORDER BY `id` ASC"); while($row=mysql_fetch_array($getItemHdr)){ ?><tr onclick="javascript:getInfo(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10.5%'>".$row['header_ref_code']."</td>"; echo "<td style='width:15.2%'>".$row['po_code']."</td>"; echo "<td style='width:56.1%'>".$row['item_description']."</td>"; echo "<td style='width:5%'>".$row['approved_qty']."</td>"; echo "<td style='width:10%'>".$row['approved_amount']."</td>"; echo "</tr>"; } ?> </table> <?php echo '<script>Alert("Price has been changed.")</script>'; } } ?> <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"> $(document).ready(function(){ }); function fixedWrongAmountShow(){ $("#fixedWrongAmountForm").fadeIn(500); } function fixedWrongAmountHide(){ $("#fixedWrongAmountForm").fadeOut(500); } function getInfo(row) { var x=row.cells; document.getElementById("selPOAmount").value = x[5].innerHTML; document.getElementById("selItemPOID").value = x[0].innerHTML; document.getElementById("selPONumber").value = x[2].innerHTML; document.getElementById("selOldPOAmount").value = x[5].innerHTML; document.getElementById("selOldPOQty").value = x[4].innerHTML; document.getElementById("selNewPOQty").value = x[4].innerHTML; } </script>

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