File manager

File manager - Edit - /home/autoph/public_html/portal/pms_create_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> <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 if(isset($_POST['CreateNewTicket'])){ //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']; $sql="INSERT INTO `pms_tickets` (`id`,`ticket_id`,`employee_id`,`emp_id`,`comp_id`,`deal_id`,`dept_id`,`concerns`,`date_sent`,`time_sent`,`sent_to_dept`,`sent_to_comp`,`current_status`,`level`,`year`) VALUES('','$newTicket','$regByID','$regByEMPID','$compID','$dealCode','$deptCode','$concerns','$toDate','$currentTime','$xDeptCode','$xCompCode','NEW','$PriorityLevel','$mycYear')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div id='dialog' title='NEW TICKET CREATED' style='background:#FAFAFA;z-index:20000'> <p>New ticket has been created and routed to intended unit. </p> <center><a href='myportal.php?window=1.1'><input type='button' class='submit' name='Exit' value='Close'></a></center> </div>"; $message = "Hi ".$uFname."! This is to confirm receipt of your request dated ".$toDate ." \| ".$currentTime.". Autohub Support Team will attend to your concern as fast as possible. Please always check your e-mail for updates or, you may login to our portal at http://www.autohub.ph 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, 'NEW TICKET CREATED', $message, 'From: helpdesk@autohub.ph'); } } ?> <h2 class='titleBlue' style='margin:0px;border-radius:9px 9px 0px 0px;font-family:Calibri Light;font-size:18px;padding:5px' align='left' >CREATE NEW 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;'></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>"; } ?> </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 $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 $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='SUBMIT MY REQUEST'> <input type='reset' class='submit' name='Clear' value='CLEAR'> <a href='myportal.php?window=1.1&ticket=open'><input type='button' class='submit' name='Exit' value='EXIT'></a> </div> </form> </div></center>

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