EVOLUTION-NINJA

Edit File: user_chat.php

<div class="page-content-wrapper">
		<div class="page-content">
			
			
			<h3 class="page-title"> User Chat Details </h3>
		<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="<?php echo base_url();?>dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="#" > User Chat Details </a></li>
		</ul>
	</div>
			 <?php  $this->load->view('import_module/masters_data_display'); ?>
			 
<?php if(empty($access_row))
{
}
else 
{
if($access_row->insert_id == '1') { ?>
<form action="<?php echo base_url(); ?>access/add_department_details" method="post" class="form-horizontal">
<b>To insert data click here:</b>
<input type="submit" name="Insert" value="Insert" /><br><br>
</form>	
<?php  } else { ?>

<?php  } }?>

<input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)){ } else { echo $access_row->preview_id; } ?>" >
<input type="hidden" id="edit_id" class="edit_id" value="<?php if(empty($access_row)){ } else { echo $access_row->edit_id; } ?>" >
<input type="hidden" id="delete_id" class="delete_id" value="<?php if(empty($access_row)){ } else { echo $access_row->delete_id; } ?>" >
<input type="hidden" id="approval_id" class="approval_id" value="<?php if(empty($access_row)){ } else { echo $access_row->approval_id; } ?>" >
	<div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></div>
			<div class="portlet box blue-madison">
				<form id="land_owner" class="form-inline" method="post">

<div id="department">
						<div id = "jaytab" class="jaytab">
							<table id="list2"></table>
							<div id="pager2"></div>
							<div id="dialogSelectRow" title="Warning" style="display:none">
							<p>Please select row</p>
							</div>									
						</div>
						</div>
					<div id="sub_department" style="display:none;">
						<div id = "jaytab" class="jaytab">
							<table id="list1"></table>
							<div id="pager1"></div>
							<div id="dialogSelectRow" title="Warning" style="display:none">
							<p>Please select row</p>
							</div>									
						</div>	
					</div>	
				</form>	
				
				
				
				
				
			
						
					
			
			
		
	</div>
</div>
</div>

</script>
	<style type="text/css">
			
		.ss{
	padding-right: 0 !important;
	padding-left: 0 !important;
}

label {
    font-weight: normal;
    text-align: left;
}
.hr-line{
	border-top: 1px solid #465A81;
}

.well-sm {
    padding: 3px !important;
	border-radius: 0px !important;
}
input[type="file"] {
    padding-bottom: 28px !important;
    height: 25px !important;
    color:transparent;
}
.portlet.box.blue-madison {
    border: 1px solid #fff !important;
    border-top: 0;
    background:#fff !important;
}

#list2_122_t
	{
		height:0px !important;
	}

list2_136_t
{
	height:12px !important;
}

.ui-jqgrid-btable
{
	
}
.ui-common-table
{
	height:12px !important;
}
#refresh_list2
{
	display:none !important;
}
#client_edit
{
	padding-right:18px !important;
}

#list2
{
	width: 1050px;
height: 0px !important;
}
#list1
{
	width: 1050px;
height: 0px !important;
}
input:required {
    border-color: #ccc !important;
    box-shadow: none !important;
    -webkit-box-shadow: none !important;
}

#gview_list2
{

height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
			.ui-jqgrid {
    margin-left: 1px !important;
}
			#jaytab{
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 100% !important;
				padding-left: 0 !important;
			}
			
			#editmodlist2
			{
				width:90% !important;
			}
			#sData span, #cData span {
				margin-left: 0 !important;
				}
		}
		@media only screen and (min-width:641px) and (max-width:991px){
			
			.ui-jqgrid {
			margin-left: 1px !important;
			}
			#jaytab{
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 100% !important;
				padding-left:0 !important;
				padding-right:9px !important;
			}

}
		#search_list2
{
	display:none !important;
}
.ss{
	padding-right: 0 !important;
	padding-left: 0 !important;
}
.form-control {
	width:65% !important;
    height:27px !important;
    padding: 3px 12px !important;
    border-radius: 0px !important;
	//margin-bottom:15px;
}
label {
    font-weight: normal;
    text-align: left;
}
.hr-line{
	border-top: 1px solid #465A81;
}

.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar {
    padding: .1em .1em;
    min-height: 35px;
     background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin:  -9px !important;
}   
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px !important;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
html, body {
     overflow-x: hidden;
	 
}
#gbox_list2
{
	margin-left:12px !important;
}
#gbox_list1
{
	margin-left:12px !important;
}
	</style>

<script>

$(document).ready(function (){
	//var swan_id='';
	jQuery("#list2").jqGrid({

url:"<?php echo base_url('access/chat_fetch')?>",	  
			 mtype : "post", 	 
			datatype: "json", 
		    colNames:['Id','User Name','Delete','Download'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, editable:true,width:100},
					//  {name:'user_type_id',index:'user_type_id', editable:false,width:100},
					  {name:'from_name',index:'from_name',editable:true, align:'center',width:100},
					//  {name:'department_code',index:'department_code',edittype:'text',editable:true,editrules:{required: true}, width:100},

{name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) 
							{
                	     return ' onclick="export_page($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
return "<input type='button' value='Download' onclick='some_function'  \>";
				  }}
		      	    ],
		      	  height: 'auto',
		      	 rowNum:50,
		      	rowTotal: 200000,
		      	rowList : [50,100,200,300],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager2", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	//multiple: true,  
		      	loadonce:true,
				caption:"User Chat Details",
			
  });

//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	 		$("#list2").jqGrid('navGrid','#pager2',
				{edit:false,add:false,del:false,search:false,refreshstate:false},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true }
			);

}); 
function chat_delete(rowId)
{
var id = rowId.closest('tr').attr('id'); 
var as=id;

$.ajax({
		type:'post',
		url:'<?php echo base_url("access/chat_details_delete"); ?>',
		data:{'id':as},
		async:false,
		success:function()
		{
			 $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
			}
		 
	});
			
	}

function export_page(rowId) {
	
	var id = rowId.closest('tr').attr('id'); 
	var as=id;
	//alert(id);
	$.ajax({
        type   : 'post',
      url:"<?php echo base_url('access/download_excel')?>",	
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		   console.log(response);
         var count =1;
         
  
                var content = '';
                content +='<thead><tr><th><b>SL No.</b></th><th><b>From</b></th> <th><b>To</b></th> <th><b>Message</b></th> <th><b>Date</b></th> </tr></thead>';
                 $.each(response,function(key,vas){

content +='<tr><td>'+count+'</td> <td>'+vas.from_name+'</td> <td>'+vas.to_name+'</td> <td>'+vas.message+'</td> <td>'+vas.msg_date+'</td></tr></thead>';
						count++;
             
                });
				
				
                 $('.export_table').append(content);
                 
                 export_data();
				 pdf_download();
          			}
				 });
				
}
function export_data()
	{
		
		
		$("#export_table").table2excel({
			exclude: ".noExl",
			name: "Excel Document Name",
			filename: "User Chat Report",
			fileext: ".xls",
			exclude_img: true,
			exclude_links: true,
			exclude_inputs: true
		});	
		
	}
</script>