MAINHACK

Viewing / Editing File: get_ticket.php

<?php include 'header.php';?>

<div id="page-wrapper">
            <div class="row">
                <div class="col-lg-12">
   <div class="panel panel-info">
                        <div class="panel-heading">
					Ticket Details                  
						</div>
                        <div class="panel-body">
                            <div class="row">
                                <div class="col-lg-12">
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" > 
     
		<div class="card-body">
<?php
			
$stmt =$show->readwithdata_clause('support_ticket','ticket_id',$_REQUEST['tid'],' group by ticket_id');
$num = $stmt->rowCount();

$count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];
      
       $client_id=$row['client_id']; 
       $mail_id=$row['email'];
       $name=$row['name'];
?>   	
		    	<div class="card-title">Ticket ID :<?=$row['ticket_id']?></div>
<style>
table tr td{
    padding:10px;
}    
    
</style>		    	
		   	<div class="form-group form-show-validation row">
			<table style="color:#000;padding:10px;font-size:14px" >
			    <tr><td>Name</td><td><?=$row['name']?></td></tr>
			    <tr><td>Email</td><td><?=$row['email']?></td></tr>
			    <tr><td>Phone</td><td><?=$row['phone']?></td></tr>
			    <tr><td>Help Topic</td><td><?=$row['topic']?></td></tr>
			    <tr><td>Domain Name</td><td><?=$row['topic']?></td></tr>
			    <tr><td>Subject</td><td><?=$row['subject']?></td></tr>
			    
			</table>
			</div>
<?php } ?>	
<hr>		
<?php
			
$stmt =$show->readwithdata_clause('support_ticket','ticket_id',$_REQUEST['tid'],' and user="user"');
$num = $stmt->rowCount();

$count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];
      
        
?>   	
			<div class="form-group form-show-validation row">
	
	                <div class="col-lg-12 col-md-12 col-sm-12" style="color:#000;font-size:20px;background-color:#b2f09b">
	               <?=date('D, M H:i a',strtotime($row['date']))?>     
	               <br>
	                    <?=htmlspecialchars_decode($row['description']);?>
				</div>
			</div>	
<?php } ?>			
					
	    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 ">Write Reply<span class="required-label">*</span></label>
				<div class="col-lg-12 col-md-12 col-sm-12">
            	   					
            	   
            	    <textarea name="content" class="form-control"  rows="10"></textarea>
				</div>
			</div>
	    <div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 ">Status<span class="required-label">*</span></label>
				<div class="col-lg-12 col-md-12 col-sm-12">
            	 	<?php	$option = array(
    'OPEN',
    'CLOSED',
    
);
?>			<select name="status" class="form-control" required><option value="">Select</option>
							
							<?php						
foreach($option as $options){
	echo "<option value='$options'"; 
	if($row['status']==$options) echo "selected";

echo " >{$options}</option>";	
}
?>
</select>
				</div>
			</div>
       <input type="hidden" name="ticket_id" value="<?=$_REQUEST['tid']?>">
       <input type="hidden" name="client_id" value="<?=$client_id?>">
       <input type="hidden" name="email" value="<?=$mail_id?>">
       <input type="hidden" name="name" value="<?=$name?>">

</div>
	</form>
	
<?php

if(isset($_POST['sub'])){

$data = array(
    'client_id' =>htmlspecialchars($_POST['client_id']), 
    'ticket_id' =>htmlspecialchars($_POST['ticket_id']), 
    'description' =>htmlspecialchars($_POST['content']), 
    'status'=>htmlspecialchars($_POST['status']), 
    'user'=>'ADMIN'
    );
//	print_r($data);
 if($show->insert('support_ticket',$data)){
    if($_POST['status']=='CLOSED'){
        $sq="update support_ticket set status='CLOSED' where ticket_id='".$_POST['ticket_id']."'";
        $sq1=$con->prepare($sq);
        $sq1->execute();
    }
  $my_mail='info@incrementertech.com';
//$my_mail='priya.pie27@gmail.com';
		    
	$email_subject = "Support Ticket ID:";
    $em='<html><head>';
	$email_content1="
<html><head>
	<style>
	h2{
	color:#000;
font-size:26px;
	}
	#b{
	width:500px;
	font-size:15px;

}
	th{
	background-color:#fff;
	}
	body, td, input, textarea, select {
    font-family:'Podkova', serif;
    margin: 0;
}
	</style>
	</head>
	
	<body>

<h3>Welcome to Incrementer Technology Solutions Pvt Ltd,</h3></td></tr>

<tr><td  style='text-align:justify;padding:12px;font-size:18px;'><br>Hi Admin,<br><br>

<br>
<br><br><br><br>	
Thanks & Regards<br>
Incrementer Technology Solutions Pvt Ltd
WebSite : https://incrementertech.com<br>
Customer Care +91 7980785847<br>
Email ID : info@incrementertech.com<br>

<br>

</td></tr>
</tr>

</table>

</body></html>";
$email_content="
<html><head>
	<style>
	h2{
	color:#000;
font-size:26px;
	}
	#b{
	width:500px;
	font-size:15px;

}
	th{
	background-color:#fff;
	}
	body, td, input, textarea, select {
    font-family:'Podkova', serif;
    margin: 0;
}
	</style>
	</head>
	
	<body>

<h3>Welcome to Incrementer Technology Solutions Pvt Ltd, </h3></td></tr>

<tr><td  style='text-align:justify;padding:12px;font-size:18px;'><br>Hi ".$_POST['name'].",<br><br>
        You got a reply for ticket with Ticket ID: ".$_POST['ticket_id'].",<br>

Issue:".$_POST['content']."
		<br>
<br><br><br><br>	
Thanks & Regards<br>
Incrementer Technology Solutions Pvt Ltd
WebSite : https://incrementertech.com<br>
Customer Care +91 7980785847<br>
Email ID : info@incrementertech.com<br>

<br>

</td></tr>
</tr>

</table>

</body></html>";
	$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
	  
	if(@mail($_POST['email'],$email_subject,$email_content,$headers)) {
	  	echo "<script>alert('Updated')</script>";           
	} else {
	//	echo "<script>alert('Message  not sent!')</script>";
	}
	
     
echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You !",
            text: "Your Ticket post has been submitted. We will contact you soon.",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
 //echo "<script>swal('Thank you for Registration.');window.location.href='".$_SERVER['request_uri']."';</script>";
 }   
}
?>			
</div>	
					</div>
				</div>
			</div>
			
		</div>
</div>
</div>
<?php include 'footer.php'; ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: get_ticket.php

Server Info

System Features

User Info