File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_edit_new_ticket.php

Back
<html> <head> <link rel="stylesheet" href="ajs/vendors/jQueryUI/jquery-ui.css"> <script src="ajs/vendors/jQueryUI/jquery-1.12.4.js"></script> <script src="ajs/vendors/jQueryUI/jquery-ui.js"></script> <link rel="stylesheet" href="css/jquery/css/jquery-ui.css"> <link rel="stylesheet" href="/resources/demos/style.css"> </head> <!-- ////////////////////////////////////////////////////////////////////////////////////// START OF SCRIPT FOR AUTOM COMPLETE --> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `employee_list` WHERE `status`='1' ORDER BY `last_name` ASC" ); $mpList = array(); while( $r = mysql_fetch_assoc($d) ) { $mpList[] = $r['last_name'].",".$r['first_name']."---".$r['employee_id']; } echo json_encode( $mpList ); ?>; $( "#MyEmpList" ).autocomplete({ source: userName }); } ); </script> <center><div align='left' style='width:60%;height:480px;border:1px solid #2E9AFE;border-radius:10px ;padding:0px;top:70px;left:200px;position:absolute;z-index:4;' class='lightGradient'> <?php $curUser = $user_data['u_lname'] . ", " . $user_data['u_fname']."---". $user_data['emp_id']; $id=$_GET['id']; $content = mysql_result(mysql_query("SELECT `concerns` FROM `pms_tickets` WHERE `id`='$id'"),0); if(isset($_POST['CreateNewTicket'])){ $id=$_GET['id']; //echo "Message". $uID . " --- ".$compID. "--".$deptCode. "---".$dealCode; $getLastTicket = mysql_result(mysql_query("SELECT `id` FROM `pms_tickets` WHERE `id`!='' ORDER BY `id` DESC LIMIT 1 "),0); $newTicket = $compID."-".($getLastTicket + 1); //echo "New Ticket". $newTicket; $reqBy=$_POST['reqBy']; $regEx = explode('---',$reqBy); $regByID = $regEx[1]; $regByEMPID = mysql_result(mysql_query("SELECT `u_id` FROM `c_users` WHERE `emp_id`='$regByID'"),0); $concerns=$_POST['desc']; $concerns=mysql_real_escape_string($concerns); $compName=$_POST['compName']; $xCompCode=mysql_result(mysql_query("SELECT `code` FROM `company` WHERE `name`='$compName'"),0); $deptName=$_POST['deptName']; $xDeptCode=mysql_result(mysql_query("SELECT `code` FROM `departments` WHERE `name`='$deptName'"),0); $deptEmail=mysql_result(mysql_query("SELECT `email` FROM `departments` WHERE `name`='$deptName'"),0); $PriorityLevel=$_POST['PriorityLevel']; if(empty($regByID)){ $errorMSg ="<p style='font-family:Calibri;font-size:14px;color:red'>Selected employee cannot be found in the database file... </p>"; }else{ mysql_query("UPDATE `pms_tickets` SET `employee_id`='$regByID',`emp_id`='$regByEMPID',`concerns`='$concerns',`sent_to_dept`='$xDeptCode',`sent_to_comp`='$xCompCode' WHERE `id`='$id' AND `created_by`='$myEMPID'"); echo "<div id='dialog' title='UPDATE COMPLETE' style='background:#FAFAFA;z-index:20000'> <p>Ticket has been modified. </p> <center><a href='myportal.php?window=1.1'><input type='button' class='submit' name='Exit' value='Close'></a></center> </div>"; $message = "Hi ".$uFname."! The ticket you have created has been modified on ".$toDate ." \| ".$currentTime.". Ticket status will not be changed unless routed to new department. Please always check your e-mail for updates or, you may login to our portal at http://www.autohub.ph/portal for real-time update of your request. If you do not have an account yet, please visit the site and click Register. Thank you. Autohub Support Group"; mail($uMail, 'SUPPORT TICKET MODIFICATION', $message, 'From: support@autohubgroup.com'); } } ?> <h2 class='titlePink' style='margin:0px;border-radius:9px 9px 0px 0px;font-family:Calibri Light;font-size:18px;padding:5px' align='left' >UPDATE TICKET</h3> <form action='' method='POST' style='padding:20px;font-family:Calibri Light;font-size:13px;'> NATURE OF REQUEST / CONCERN / SUPPORT NEEDED:<br><textarea rows='2' required placeholder="TYPE YOUR CONCERN OR REQUEST HERE..." name='desc' style='padding:10px;width:100%;border:1px solid gray;font-family:Calibri Light;font-size:14px;background:white;'><?php echo $content;?></textarea> <br><br>REQUESTED BY:<br> <!--<select REQUIRED class='textbox' type="text" name="reqBy" style='background:white;width:50%;padding:5px;border:1px solid gray;font-family:Calibri Light;font-size:14px;border-radius:3px;background:white;'> <?php // echo "<option>".$uLname .", ".$uFname."---".$myEMPID."</option>"; // $co = mysql_query("SELECT * FROM `c_users` WHERE `status`='1' ORDER BY `u_lname` ASC"); // while($cRow = mysql_fetch_array($co)){ // echo "<option>".$cRow['u_lname'].", ".$cRow['u_fname']."---".$cRow['emp_id']."</option>"; // } MyEmpList ?> --> <input type='text' id='MyEmpList' name="reqBy" value='<?php echo $curUser;?>' style='background:white;width:50%;padding:5px;border:1px solid gray;font-family:Calibri Light;font-size:14px;border-radius:3px;background:white;'> </select> <br><br>SEND TO THIS DEPARTMENT<br> <select REQUIRED class='textbox' type="text" name="deptName" style='background:white;width:50%;padding:5px;border:1px solid gray;font-family:Calibri Light;font-size:14px;border-radius:3px;background:white;'> <?php echo "<option></option>"; $co = mysql_query("SELECT * FROM `departments` WHERE `status`='1' ORDER BY `name` ASC"); while($dRow = mysql_fetch_array($co)){ echo "<option>".$dRow['name']."</option>"; } ?> </select> <br><br>SELECT COMPANY:<br> <select REQUIRED class='textbox' type="text" name="compName" style='background:white;width:50%;padding:5px;border:1px solid gray;font-family:Calibri Light;font-size:14px;border-radius:3px;background:white;'> <?php echo "<option></option>"; $co = mysql_query("SELECT * FROM `company` WHERE `status`='1' ORDER BY `name` ASC"); while($cRow = mysql_fetch_array($co)){ echo "<option>".$cRow['name']."</option>"; } ?> </select> <br><br>LEVEL OF URGENCY:<br><select REQUIRED class='textbox' type="text" name="PriorityLevel" style='background:white;width:50%;padding:5px;border:1px solid gray;font-family:Calibri Light;font-size:14px;border-radius:3px;background:white;'> <option>MODERATE</option> <option>CRITICAL</option> <option>HIGH</option> <option>LOW</option> </select> <div align='right' class="form-group" style='padding:3px;border:0px solid red;margin-top:-35px'> <input type='submit' class='submit' name='CreateNewTicket' value='UPDATE TICKET' style='margin-right:10px'> <a href='myportal.php?window=1.1&ticket=open'><input type='button' class='submit' name='Exit' value='EXIT'style='margin-right:50px'></a> </div> <?php echo $errorMSg;?> </form> </div></center>

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