File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_ManagePRFUtil.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']; $ITADM=$user_data['IT_ADM']; echo "<input type='hidden' id='userID' value='".$activeID."'>"; echo "<input type='hidden' id='ITADM' value='".$ITADM."'>"; if(isset($_POST['done'])){ $loadPRFItem = mysql_escape_string($_POST['loadPRFItem']); echo "<input type='hidden' value='$loadPRFItem' id='prfCode'>"; $chkIfPRFExist = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); if($chkIfPRFExist==0){ echo '<script>alert("PRF # '.$loadPRFItem.' cannot be found. Please check your entry and try again!")</script>'; }else{ $deptHeadID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $deptHeadIDSigned = mysql_result(mysql_query("SELECT `dept_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); if($deptHeadIDSigned !=''){ $chngeDeptID ='Enable'; }else{ $chngeDeptID ='Enable'; } $deptHeadFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $deptHeadLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $reqID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $reqFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $reqLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $gmID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $gmIDSigned = mysql_result(mysql_query("SELECT `gm_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); if($gmIDSigned !=''){ $chngeGMID ='Enable'; }else{ $chngeGMID ='Enable'; } $gmFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gmID'"),0); $gmLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gmID'"),0); $assValID = mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $assIDSigned = mysql_result(mysql_query("SELECT `admin_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); if($assIDSigned !=''){ $chngeAssID ='Enable'; }else{ $chngeAssID ='Enable'; } $assFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$assValID'"),0); $assLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$assValID'"),0); $curStatus = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); if($curStatus > 9){ $chngeStat ='Enable'; }else{ $chngeStat ='Enable'; } $curStatusName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `sequence`='$curStatus'"),0); $curExpenseTypeID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $curExpenseTypeName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$curExpenseTypeID'"),0); $curExpenseSubTypeID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0); $curExpenseSubTypeName = mysql_result(mysql_query("SELECT `description` FROM `prf_expenseitems` WHERE `id`='$curExpenseSubTypeID'"),0); } echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>Department Head:</p>"; echo "<select id='newDeptHead' $chngeDeptID name='newDeptHead[]' class='myNewDeptHead' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select --</option>"; $getOfficers = mysql_query("SELECT u_id, u_fname, u_lname FROM `vts_users` WHERE `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['u_id']."'>".$row['u_lname'].", ".$row['u_fname']."</option>"; } echo "<select>"; echo "<p id='deptMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>CURRENT: ".$deptHeadFName."," .$deptHeadLName."</p>"; echo"</div>"; echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;border-left:0px'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>Gen. Manager:</p>"; echo "<select id='newGM' $chngeGMID name='newGM[]' class='newGM' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select --</option>"; $getOfficers = mysql_query("SELECT u_id, u_fname, u_lname FROM `vts_users` WHERE `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['u_id']."'>".$row['u_lname'].", ".$row['u_fname']."</option>"; } echo "<select>"; echo "<p id='newGMMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>CURRENT: ".$gmLName."," .$gmFName."</p>"; echo"</div>"; echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;border-left:0px'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>Requestor:</p>"; echo "<select id='newREQ' name='newREQ[]' class='newREQ' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select --</option>"; $getOfficers = mysql_query("SELECT u_id, u_fname, u_lname FROM `vts_users` WHERE `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['u_id']."'>".$row['u_lname'].", ".$row['u_fname']."</option>"; } echo "<select>"; echo "<p id='newReqMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>CURRENT: ".$reqLName."," .$reqFName."</p>"; echo"</div>"; echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;border-left:0px'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>Asset Validator:</p>"; echo "<select id='newAssVal' $chngeAssID name='newAssVal[]' class='newAssVal' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select --</option>"; $getOfficers = mysql_query("SELECT u_id, u_fname, u_lname FROM `vts_users` WHERE `u_status`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['u_id']."'>".$row['u_lname'].", ".$row['u_fname']."</option>"; } echo "<select>"; echo "<p id='newAssValMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>CURRENT: ".$assLName."," .$assFName."</p>"; echo"</div>"; echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;border-left:0px'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>EXPENSE TYPE:</p>"; echo "<select id='newExpense' name='newExpense[]' class='newExpense' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select Status --</option>"; $getOfficers = mysql_query("SELECT * FROM `prf_expensecategory` WHERE `status`=1 ORDER BY `description` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['id']."'>".$row['description']."</option>"; } echo "<select>"; echo "<p id='newExpenseMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>Expense Type: ".$curExpenseTypeName."</p>"; echo"</div>"; echo "<div style='float:left;width:24.5%;padding:5px;border:0px solid gray;border-left:0px'>"; echo "<p style='margin:0px;padding:1px;float:left;with:100%;color:black'>CATEGORY:</p>"; echo "<select id='newExpenseSub' name='newExpenseSub[]' class='newExpenseSub' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select Status --</option>"; $getOfficers = mysql_query("SELECT * FROM `prf_expenseitems` WHERE `status`=1 ORDER BY `description` ASC"); while($row=mysql_fetch_array($getOfficers)){ echo "<option value='".$row['id']."'>".$row['description']."</option>"; } echo "<select>"; echo "<p id='newSubExpenseMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>Expense Type: ".$curExpenseSubTypeName."</p>"; echo"</div>"; echo "<div style='float:left;width:49%;padding:5px;border:0px solid gray;border-left:0px;background: #fcd5ab '>"; echo "<p style='margin:0px;padding:1px;float:left;width:100%;color:black;background:red;color:white'>RETURN TO CANVASS:</p>"; echo "<b style='padding:10px;width:40%;float:left;color:black;padding-bottom:0px;'>INPUT ITEM CODE:</b>"; echo "<input type='text' id='itemCode' style='padding:5px;padding-top:0px;width:30%;float:left;text-align:center;'>"; echo "<select id='newStat' $chngeStat name='newStat[]' class='newStat' style='padding:3px;width:100%;'>"; echo "<option value='0'>--Select Status --</option>"; $getOfficers = mysql_query("SELECT * FROM `prf_status` WHERE `deleted`=0 ORDER BY `sequence` ASC"); echo "<option value='4'>Return to For Canvass</option>"; echo "<select>"; echo "<p id='newStatMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>Status: ".$curStatusName."</p>"; echo"</div>"; echo "<div style='float:left;width:100%;padding:10px;border:0px solid gray;border-left:0px;background: #ffffff;color:black '>"; echo "NOTES/REMARKS:<br><textarea id='actionNotes' rows=1 style='padding:3px;width:100%;color:black'></textarea>"; echo "</div>"; } ?> <!-- 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#############################################################--> $('.newExpenseSub').bind("change",function(){ var newExpenseSub = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(userID); //alert(prfCode); //return false; if(confirm("CONFIRM ACTION: \n\nAre you sure you want to change the PRF status?")){ ShowUploadBar(); $.ajax({ url: "prf_changePRFExpenseSubType.php", type: "POST", async: false, data: { "newExpenseSub": newExpenseSub, "userID": userID, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newSubExpenseMSG").html(d); ShowUploadBar(); } }) } }); <!--######################################################################prf_changePRFExpenseSubType.php#############################################################--> $('.newExpense').bind("change",function(){ var newExpense = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(newExpense); //return false; if(confirm("CONFIRM ACTION: \n\nAre you sure you want to change the PRF status?")){ ShowUploadBar(); $.ajax({ url: "prf_changePRFExpenseType.php", type: "POST", async: false, data: { "userID": userID, "newExpense": newExpense, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newExpenseMSG").html(d); ShowUploadBar(); } }) } }); <!--#########################################James bone #############################PRF_POST_PO.php#############################################################--> $('.newStat').bind("change",function(){ var newStat = $(this).val(); var prfCode = $("#prfCode").val(); var itemCode = $("#itemCode").val(); var userID = $("#userID").val(); var ITADM = $("#ITADM").val(); var actionNotes = $("#actionNotes").val(); //alert(newStat); //return false; //alert(itemCode); //return false; if(ITADM == 0){ alert('Sorry, you are not allowed to change PRF status. Please contact your System Administrator for assistance.'); return false; } if(newStat == 0){ alert('Error: Invalid Entry.'); return false; } if(actionNotes == ''){ alert('Please type your reason for changing the status of this item.'); return false; } // alert(ITADM); // return false; if(confirm("CONFIRM ACTION: \n\nAre you sure you want to return this item to FOR CANVASS? Click OK to proceed")){ ShowUploadBar(); $.ajax({ url: "prf_changePRFStatus.php", type: "POST", async: false, data: { "userID": userID, "actionNotes": actionNotes, "itemCode": itemCode, "newStat": newStat, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newStatMSG").html(d); $('#actionNotes').val(''); ShowUploadBar(); } }) } }); <!--######################################################################PRF_POST_PO.php#############################################################--> $('.newAssVal').bind("change",function(){ var newAssVal = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(newGM); //return false; ShowUploadBar(); $.ajax({ url: "prf_changeAssetValidator.php", type: "POST", async: false, data: { "userID": userID, "newAssVal": newAssVal, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newAssValMSG").html(d); ShowUploadBar(); } }) }); <!--######################################################################PRF_POST_PO.php#############################################################--> $('.newREQ').bind("change",function(){ var newREQ = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(newGM); //return false; ShowUploadBar(); $.ajax({ url: "prf_updatenewREQ.php", type: "POST", async: false, data: { "userID": userID, "newREQ": newREQ, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newReqMSG").html(d); ShowUploadBar(); } }) }); <!--######################################################################PRF_POST_PO.php#############################################################--> $('.newGM').bind("change",function(){ var newGM = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(newGM); //return false; ShowUploadBar(); $.ajax({ url: "prf_updatenewGM.php", type: "POST", async: false, data: { "userID": userID, "newGM": newGM, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#newGMMSG").html(d); ShowUploadBar(); } }) }); <!--######################################################################PRF_POST_PO.php#############################################################--> $('.myNewDeptHead').bind("change",function(){ var newDeptHead = $(this).val(); var prfCode = $("#prfCode").val(); var userID = $("#userID").val(); //alert(newDeptHead); //return false; ShowUploadBar(); $.ajax({ url: "prf_updatePRFDeptHead.php", type: "POST", async: false, data: { "newDeptHead": newDeptHead, "userID": userID, "prfCode": prfCode, "done": 1 }, success: function(d){ $("#deptMSG").html(d); ShowUploadBar(); } }) }); $("#itemReIndex").click(function(){ // if(confirm("CONFIRM ACTION: \n\nPRF item mapping will be executed. Please click OK to confirm.")){ ShowUploadBar(); $.ajax({ url: "prf_itemReIndex.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ $("#poItems").html(d); ShowUploadBar(); //alert('test'); } }) } }); }); function changePRFCatShow(){ $("#changePRFCatForm").fadeIn(500); } function changePRFCatHide(){ $("#changePRFCatForm").fadeOut(500); } </script>

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