EVOLUTION-NINJA

Edit File: tickets_list.php

<?php $this->load->view('includes/admin_header');?>
 <link rel="stylesheet" href="<?php echo base_url('admin_assets/toastr/toastr.min.css');?>">
 <script src="<?php echo base_url('admin_assets/toastr/toastr.min.js');?>"></script>

<div class="page-content">
		
	<div class="row">
	<div class="col-xs-12">
		
			<div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;">
				<div class="col-sm-12 col-md-6">
					<span style="font-size:25px;">Tickets List</span>
				</div>
				<div class="col-sm-7"></div>										
			</div>

</div>

</div>

<div id ="jaytab" style="margin-top:3%" class="col-sm-12 col-md-12grid">
		<div class="grid_div"></div><table id="list2"></table>
			  <div id="pager2"></div>
			  <div id="dialogSelectRow" title="Warning" style="display:none">
				<p>Please select row</p>
		</div>
	</div>

</div>

</body>
</html>

$(document).ready(function(){

CallGrid();

function CallGrid()
	{
		jQuery("#list2").jqGrid({
		
	 	url:"<?php echo site_url('get_all_tickets')?>",	 
		mtype : "get", 	 
		datatype: "json", 
	    colNames:['SI','Project','Ticket','Description','File','Link','Created_by','Status','Created On','Priority','Action'],
		colModel:[
					{name:'ticket_id',index:'ticket_id', width:50, hidden:true,editable:false,key:true},
					{name:'project',index:'project',editable:true,edittype:"text",width:70},
					{name:'ticket_title',index:'ticket_title',editable:true,edittype:"text",width:70},
					{name:'ticket_description',index:'ticket_description',editable:true,edittype:'text',width:150,

formatter: function (cellvalue, options, rowObject) {
							
							var substring = rowObject.ticket_description;
		                	var result = '';
		                	while (substring.length > 0) {
								    result += substring.substring(0, 40) + '\n';
								    substring = substring.substring(40);
								  }

return result;
						}
					},
					
					{name:'ticket_file',edittype:'file',index:'ticket_file',editable:true, width:20,

formatter: function (cellvalue, options, rowObject) {
							if(rowObject.ticket_file != "")
							{
								return '<a target="_blank" href="<?php echo base_url("ticket_uploads")?>/'+rowObject.ticket_file+'"><span class="glyphicon glyphicon-file"></span></a>';
							}
							else
							{
								return '';
							}
						}
					},

{name:'ticket_link',index:'ticket_link',editable:true, width:100,edittype:"text"},
			      	{name:'user_name',index:'user_name',width:60},
			      	{name:'ticket_status',index:'ticket_status',editable:false,width:50,},
			      	{name:'created_at',index:'created_at',editable:false,width:70,},
			      	{name:'ticket_priority',index:'ticket_priority',editable:false,width:40,},
			      	{
					name: 'EditAction', index: 'id', align: 'center', width: 40,
						formatter: function (cellvalue, options, rowObject) {
							return '<a class="" href="<?php echo site_url("edit-ticket");?>/'+rowObject.ticket_id+'"><span class="glyphicon glyphicon-pencil"></span></a> <a class="delete_req" ticket_id="'+rowObject.ticket_id+'" href="javascript:void(0);"><span class="glyphicon glyphicon-trash"></span></a> <a class="" href="<?php echo site_url("assign-ticket");?>/'+rowObject.ticket_id+'"><span class="glyphicon glyphicon-plus"></span></a>';
						}
		      		},
	      	    ],

rowNum:20,
	      	rowTotal: 2000,
	      	rowList : [20,30],
	      	rownumbers: true,
	      	rownumWidth: 60,
	      	pager:"#pager2", 
	      	sortname:'id', 
	      	viewrecords: true,
	      	gridview: true,
	      	autowidth: true,
	      	sortorder:"asc",
	      	shrinkToFit: true,
	      	loadonce:true,
			caption:"Ticket List",

}); 
		$("#list2").jqGrid("setLabel", "rn", "SL");
		$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list2").jqGrid('navGrid','#pager2',
			{edit:false,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true,
		         	closeAfterDelete:true,
		         	closeAfterEdit:true
		         	 },

);

$("#list2").navButtonAdd('#pager2',
					{ 	caption:"Edit", 
						buttonicon:"ui-icon-pencil", 
						onClickButton: editRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_edit"
					} 
			);
		
	 		$("#list2").navButtonAdd('#pager2',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);
		
	}

});

// function deleteRow()
// {
// 	var row = $("#list2").jqGrid('getGridParam','selrow');

// 	if( row != null ) 
// 		$("#list2").jqGrid('delGridRow',row,
// 			{	 
// 				modal:true,jqModal:true,
// 		        recreateForm: true,		        
// 		        beforeSubmit: function(postdata,formid){
			        
// 		        	var id = row;

// 			    	 $.ajax({
			             
// 			    		 url:"<?php echo site_url('delete_ticket');?>",
// 			             type:"POST",
// 			             data:{'ticket_id':id,},
// 			             async:false,
// 			             success:function(response){
// 			                  response=jQuery.parseJSON(response);
// 			                  console.log(response);

// 			                  if(response.result==1)
// 			                    {
// 			                    	$("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
// 				                    toastr["success"](response.message);	
// 				                    $("#delmodlist2").remove(); 			     
// 			                    }
// 			                    else 
// 			                    {
// 				                    toastr["error"](response.message);                                          
// 			                    }
			                   
// 			                }
			                
// 			         });
// 			    },
				
				
// 			});

// 	else $( "#dialogSelectRow" ).dialog();
// }
	
// function editRow()
// {
// 	var row = $("#list2").jqGrid('getGridParam','selrow'); 
// 	if( row != null ) 
// 		$("#list2").jqGrid('editGridRow',row,
// 			{	 
// 				modal:true,jqModal:true,
// 		        recreateForm: true,		        
// 		        beforeSubmit: function(postdata,formid){
			        
// 		        	var id = row;
// 		        	var domain_name             = $('#domain_name').val();
// 		        	var domain_server           = $('#domain_server').val();
// 		        	var domain_username         = $('#domain_username').val();
// 		        	var domain_password         = $('#domain_password').val();
// 		        	var domain_start_date       = $('#domain_start_date').val();
// 		        	var domain_expiry_date      = $('#domain_expiry_date').val();
// 		        	var domain_status           = $('#domain_status').val();
// 		        	var domain_space            = $('#domain_space').val();
// 		        	var domain_service_provider = $('#domain_service_provider').val();
// 		        	var no_of_sms               = $('#no_of_sms').val();
// 		        	var pg_commission           = $('#pg_commission').val();

// 			    	 $.ajax({
			             
// 			    		 url:"<?php echo site_url('update_client_asset');?>",
// 			             type:"POST",
// 			             data:{'asset_id':id,'domain_name':domain_name,'domain_server':domain_server,'domain_username':domain_username,'domain_password':domain_password,'domain_start_date':domain_start_date,'domain_expiry_date':domain_expiry_date,'domain_status':domain_status,'domain_space':domain_space,'domain_service_provider':domain_service_provider,'no_of_sms':no_of_sms,'pg_commission':pg_commission},
// 			             async:false,
// 			             success:function(response){
// 			                  response=jQuery.parseJSON(response);
// 			                  console.log(response);

// 			                  if(response.result==1)
// 			                    {       
// 			                    	$("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');           	
// 				                    toastr["success"](response.message); 
// 				                    $("#editmodlist2").remove(); 		               
// 			                    }
// 			                    else if(response.result==2)
// 			                    {
// 				                    toastr["error"](response.message);    
// 				                    $(".submit").text("Submit");                    
// 			                    }
// 			                    else 
// 			                    {
// 				                    toastr["error"](response.message);                       
// 					                $(".submit").text("Submit");                       
// 			                    }
			                   
// 			                }
			                
// 			         });
// 			    },
// 				closeAfterEdit: true,
// 				reloadAfterSubmit:false,
// 				afterSubmit : false 
				
// 			});

// 	else $( "#dialogSelectRow" ).dialog();
// }

$(document).on('click','.delete_req',function(){

var ticket_id = $(this).attr('ticket_id');
		var test = $(this);
        var row  = $(this).closest('tr');
        swal({

title: "Are you sure?",
            text: "You will not be able to recover this data!",
            type: "warning",   showCancelButton: true,
            confirmButtonColor: "#DD6B55",
            confirmButtonText: "Yes, delete it!",
            cancelButtonText: "No, cancel plz!",
            closeOnConfirm: false,
            closeOnCancel: false 
            },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
                $(".sweet-overlay").hide();
                test.attr('disabled', 'disabled');
                test.text("Deleting...");
                    $.ajax({          
                            type   : 'post',
                            url    : '<?php echo site_url("delete_ticket")?>',
                            data   : {ticket_id:ticket_id},

success:function(response) {
                            response=jQuery.parseJSON(response);
									console.log(response);

if(response.result == 1) 
                                {
                                   toastr["success"](response.message);
                                  $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                                }
                            }
                        });

} 
                            else {

$(".sweet-alert").hide();
                            $(".sweet-overlay").hide();
                        }

});

</script>
<?php $this->load->view('includes/admin_footer');?>