File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_CancelLoadPOData.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'])){ $mySelectedPO = mysql_escape_string($_POST['mySelectedPO']); echo "<input type='hidden' id='userID' value='".$activeID."'>"; echo "<input type='hidden' id='MyActivePO' value='".$mySelectedPO."'>"; echo "<input type='hidden' id='activeItem'>"; //echo "adfas" .$loadSelectedPRF; ?> <div style='width:100%;height:33px;background:white;float:left'> <table> <thead> <th style='width:5%'>REC.#</th> <th style='width:12%'>PRF.</th> <th style='width:60%'>ITEM DESCRIPTION</th> <th style='width:8%'>QTY</th> <th style='width:8%'>PRICE</th> </thead> </table> </div> <div id='prfItems' style='float:left;width:100%;margin-bottom:2px;padding:0px;font-family:Yu Gothic Bold;;color:black;border:1px solid gray;'> <table style='width:100%;border-collapse:collapse'> <?php $getItems = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`='$mySelectedPO'"); $poAmount = mysql_result(mysql_query("SELECT SUM(`approved_amount`) FROM `prf_request_detl` WHERE `po_code`='$mySelectedPO' AND `deleted`= 0"),0); while($row=mysql_fetch_array($getItems)){ $counter = $counter + 1; ?><tr onclick="javascript:getInfoX(this);" ><?php echo "<td style='width:5%;border:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;'>".$row['id']."</td>"; echo "<td style='width:12%;border:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;'>".$row['header_ref_code']."</td>"; echo "<td style='width:60%;border:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:left;'>".$row['item_description']."</td>"; echo "<td style='width:8%;border:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;'>".$row['approved_qty']."</td>"; echo "<td style='width:8%;border:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;'>".$row['approved_amount']."</td>"; echo "</tr>"; } echo "<tr> <td colspan='5' style='padding:10px;padding-right:20px;width:5%;border:0px solid gray; font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:right;'>AMOUNT: ".$poAmount."</td> </tr>"; ?> </table> </div> <?php if($counter > 0){ ?> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <p id='activeDesription' style='display:none;float:left;width:100%;background:yellow;font-family:Calibri;height:30px;color:black;padding:4px;font-size:14px;margin-bottom:0px'></p> <button id='cancelPOAndAllItems' class='PopUpLowerButtonR' style='width:20%;float:right;height:30px;padding:0px;width:200px;margin-top:13px'>📑  CANCEL THIS P.O</button> </div> <?php } else{ $chkIfCancelled= mysql_result(mysql_query("SELECT `po_status` FROM `prf_purchase_order` WHERE `po_number`='$mySelectedPO'"),0); if($chkIfCancelled > 0){ $poStat ="<p style='text-align:center;padding:10px;margin-top:100px;color:red;font-size:14px'>Cancelled P.O</p>"; }else{ $poStat ="<p style='text-align:center;padding:10px;margin-top:100px;color:gray;font-size:14px'>-- No Record Found --</p>"; } ?> <?php echo $poStat;?> <?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"> $(document).ready(function(){ <!--######################################################################prf_changePRFExpenseSubType.php#############################################################--> $("#cancelPOAndAllItems").click(function(){ var activePO= $("#MyActivePO").val(); //var activeItem= $("#activeItem").val(); //alert(activePO); //return false; if(confirm("WARNING: \n This action will cancel the selected PURCHASE ORDER and all items associated to it. Please click OK to proceed or CANCEL to abort. .")){ ShowUploadBar(); $.ajax({ url: "prf_CANCELPOAndAllItems.php", type: "POST", async: false, data: { "activePO":activePO, //"activeItem":activeItem, "done": 1 }, success: function(d){ $("#prfItems").html(d); ShowUploadBar(); //alert('test'); } }) } }); }); function changePRFCatShow(){ $("#changePRFCatForm").fadeIn(500); } function changePRFCatHide(){ $("#changePRFCatForm").fadeOut(500); } function getInfoX(row) { var x=row.cells; document.getElementById("activeDesription").innerHTML = x[2].innerHTML; document.getElementById("activeItem").value = x[0].innerHTML; } </script>

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