MAINHACK

Viewing / Editing File: all_tickets.php

<?php

include('header.php');
$show=new Oops($db);

<div id="page-wrapper">
            <div class="row">
                <div class="col-lg-12">
<div class="tables">

<h3 class="title1" style="margin-top: 20px;">All Tickets</h3>
 			<table class="table" id='example'>
							<thead>
								<tr>  
								  <th>Sl</th>
                                  <th>Status</th>
							      <th>Ticket ID</th>
								  <th>Domain</th>
							      <th>Raised On</th>
								  <th>Subject</th>
								 <th>Image</th>
								 <th>Assign </th>
								  
								</tr>
							    </thead>
							   <tbody>

<?php
			
$sr='product';
$stmt=$con->prepare('select * from support_ticket group by ticket_id desc');
$stmt->execute();
$num = $stmt->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

echo "<tr>
							    <td>$count</td>";
							    ?>
							    <td>
                                <script>
                                function status(a){
                                var st_text="#status"+a;    
                                var st=$(st_text).val();
                                var id_text="#id"+a;    
                                var id=$(id_text).val();         
                              //  alert(id);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "status="+st+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                { //alert(result);
                                window.location.reload();
                                }
                                });    
                                }
                               
                                </script>			   
						   
						     	<?php 
						     	$interests = array('OPEN','CLOSED'); 
?>
<?php if($row['status']=='CLOSED'){echo "<b>CLOSED</b>"; }else {?>
						<select name="status" id="status<?=$count;?>" onchange="status(<?=$count;?>)">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['status']):  ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	
<?php } ?>
<input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                                    </td>
							    
							    <?php
							    echo "
								
								<td><a href='get_ticket.php?tid=".$row['ticket_id']."' style='background-color:#000;color:#fff;padding:10px'>".$row['ticket_id']."</a></td>
								<td>".$row['domain']."</td>
								<td>".date('d-m-Y',strtotime($row['date']))."</td>
								<td>".htmlspecialchars_decode($row['description'])."</td>
								<td><img src='../product_img/".$row['image']."' width='200px'></td>
							";
 								?>
 							   
							<td>
			                 <script>
                                function assign(a){
                                var st_text="#assign"+a;    
                                var st=$(st_text).val();
                                var id_text="#id"+a;    
                                var id=$(id_text).val();         
                                //alert(st);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "assign="+st+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                { alert(result);
                               window.location.reload();
                                }
                                });    
                                }
                               
                                </script>			   
						   
							    
                                <select name="assign" id="assign<?=$count;?>" onchange="assign(<?=$count;?>)"  class="form-control" required>  
                                <option value="">Assign</option> 
                                
                                <?php
                                
                                $sr='team';
                                $stmt1 =$show->state($sr);
                                $num = $stmt1->rowCount();
                                while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)){
                                extract($row);
                                ?>
                                <?php if($row['team_id']!=""){ ?>
                                <option value="<?=$row1['team']?>:<?=$row1['team_id']?>" selected><?=$row['team_name']?></option> 
                                
                                <?php }else{
                                ?>
                                <option value="<?=$row1['team']?>:<?=$row1['team_id']?>"><?=$row1['team']?></option> 
                               <?php
                                } } ?>
                                </select>

</td>
							  
								<?php echo"</tr>";

++$count;
 }
}

?>							
</tbody></table>								
							</div>
</div>
</div>
                    
                
            </div>
        </div>

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_tickets.php

Server Info

System Features

User Info