EVOLUTION-NINJA
Edit File: user_chat.php
<script src="<?php echo base_url('assets/js/jquery.table2excel.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.debug.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.min.js');?>"></script> <?php //include("menu.php"); error_reporting(E_ALL); ?> <script> function displaycustomer(str) { $.ajax({ type:"post", url:"<?php echo base_url(); ?>display_data/testingcustomer", data:"id="+str, success:function(data) { document.getElementById("dynamicdatamster").innerHTML=data; } }); } </script> <script> $(function () { $("#orderDate").datepicker({ dateFormat: "d-m-yy", changeMonth: true, changeYear: true }); }); </script> <?php //include("menu.php"); ?> <!-- BEGIN CONTENT --> <div class="page-content-wrapper"> <div class="page-content"> <!-- BEGIN PAGE HEADER--> <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 class="row" style="padding-bottom:45px;"> <div class="col-sm-4"></div> <div class="col-sm-4"> <label class="radio-inline"><input type="radio" name="optradio" checked value="department">Department</label> <label class="radio-inline pull-right"><input type="radio" name="optradio" value="sub_department">Sub Department</label> </div> <div class="col-sm-4"></div> </div> <!-- radio button ---> <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> <!-------------Sub Department -----------------------------------------------> <!-- END DASHBOARD STATS --> </div> </div> </div> <!-- End BEGIN CONTAINER --> <!-- BEGIN FOOTER --> <script type="text/javascript"> $(document).ready(function () { $('input[type="radio"]').click(function () { if ($(this).attr("value") == "department") { $("#sub_department").hide(); $("#department").show(); } if ($(this).attr("value") == "sub_department") { $("#department").hide(); $("#sub_department").show(); } }); }); </script> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" > <script src="<?php echo base_url(); ?>assets/js/rowedex3.min.js" type="text/javascript"></script> <style> .portlet > .portlet-body.blue-madison, .portlet.blue-madison { background-color:transparent !important; } .portlet.box.blue-madison{ border:transparent !important;} body{ overflow-y: hidden !important; } </style> <!-- The link to the CSS that the grid needs --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.min.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap-ui.min.css'); ?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url();?>assets/css/bootstrap-datepicker.min.css"/> <script src="<?php echo base_url();?>assets/js/bootstrap-datepicker.min.js"></script> <script> $('.datepicker').datepicker({ //format: 'yyyy/mm/dd', }); </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; } .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; } .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> <!-----------------datepicker-------------> <!-- The link to the CSS that the grid needs --> <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="chat_delete($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE' onclick='some_function' \>"; }}, {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>