EVOLUTION-NINJA

Edit File: enquiry_list.php

<?php echo view('includes/header');?>

<section class="content-header">
		<h1> Enquiry List </h1>				
	</section> <br><br>

</div>
		<div class="form-group col-sm-12 col-md-4">
			<label class="col-sm-4 col-md-4">To Date</label>
			 
			<input type="text" class="form-control col-sm-8 dob date_picker to_date" name="to_date" >

</div>
	
	
		<div class="form-group col-sm-12 col-md-4">
			<label class="col-sm-4 col-md-4">Customer Name</label>
			<input type="text" class="form-control col-sm-8 customer_name" name="customer_name" >

</div>

<div class="form-group" align="center">
			<button type="button" id="select_month" class="btn btn-sm btn-primary">Submit</button></a>
		</div>
	</div>
				
	<section class="content">				
				<div id="menu1" class="tab-panecol-sm-12 col-md-12 ">
    
	<div id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid">
			<div class="grid_div"></div><table id="list3"></table>
			  <div id="pager3"></div>
		     <div id="dialogSelectRow3" title="Warning" style="display:none">
			 <p>Please select row</p>
		  </div>
		</div>
  </div>		
	</section>

<div class="modal fade" id="edit_modal" role="dialog">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update enquiry details</h4>
        </div>

<div class="modal-body">
         
         <form id="land_owner" class="form-inline update_form">
         	<input type="hidden" class="form-control col-sm-8 enquiry_id_pk" name="enquiry_id" required="required">
						<div class="row land_owner_a">
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Customer Name</label>
								<input type="text" class="form-control col-sm-8 name" name="name" required="required">
							</div>

<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Address</label>
								<input type="text" class="form-control col-sm-8 address" name="address">
							</div>
						</div> 
						
						<div class="row land_owner_a">
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Contact No</label>
								<input type="text" pattern="^[0-9]{10}$" class="form-control col-sm-8 mobile" name="mobile" style="width: 29% !important; margin-right:10px;">
								<input type="text" class="form-control col-sm-8 col-xs-6 mobile2" pattern="^[0-9]{10}$" name="mobile2" style="width: 29% !important;">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 ">Mail Id</label>
								 <input type="email" class="form-control col-sm-8 email" pattern="[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,3}$" name="email">
							</div>							
						</div> 
						
						<div class="row land_owner_a">							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Web Portal</label>
								<select class="form-control col-sm-8 web_portal" name="web_portal" id="sel1">
									<option value="">Select</option>
									<?php 
									foreach($webportals as $val)
									{
									?>
										<option value="<?php echo $val->webportal;?>"><?php echo $val->webportal;?></option>
									<?php
									}
									?>
								</select>
							</div>
							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Reference</label>
								<select class="form-control col-sm-8 reference" name="reference" id="sel1">
									<option value="">Select</option>
									<?php 
									foreach($reference as $val)
									{
									?>
										<option value="<?php echo $val->associate_name;?>"><?php echo $val->associate_name;?></option>
									<?php
									}
									?>
								</select>
								
							</div>							
						</div> 
						
						<div class="row land_owner_a">							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Database</label>
								<select class="form-control col-sm-8 database" name="database_name" id="sel1">
									<option value="">Select</option>
									<?php 
									foreach($database as $val)
									{
									?>
										<option value="<?php echo $val->database_name;?>"><?php echo $val->database_name;?></option>
									<?php
									}
									?>
								</select>
							</div>
							</div>
							
								<div class="row land_owner_a">							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Status</label>
								<textarea class="form-control col-sm-8" name="status" style="width: 60%;" id="status"></textarea>
							</div>
								
						</div> 
						
						<div class="row land_owner_a">
							<div class="col-sm-4 col-md-4"></div>
							<div class="col-sm-4 col-md-4">
								<button type="submit" class="btn btn-primary center-block submit">Submit</button>
							</div>
							<div class="col-sm-4 col-md-4"></div>													
						</div> 					
					</form>

</div>

</div>
    </div>
  </div>

.content-wrapper, .right-side {			
		//min-height:900px !important;
	}	
	
	a {
	 color: inherit; 
	}

</style>
    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" />
						
		<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>
		<style type="text/css">
			
				.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {
				  border-color: #FF0000;
				  box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);
				}
				#FrmGrid_list2
				{
					width: 100% !important;
				}
				.ui-jqdialog .ui-jqdialog-titlebar
				{
					height: 29px !important;
					background-color: #001a00;
					color: white;
					padding-left: 10px;
				}
				.fm-button
				{
					height: 21px !important;
					padding: 1px;					
					margin-right: 10px !important;
					height: 21px !important;				    
				    width: 50%;
				    margin-top: -7px !important;
				}
				.ui-jqdialog-content td.navButton {
					padding-top: 12px !important;
				}
				.ui-jqgrid .ui-jqgrid-titlebar
				{
					height: 27px !important;
					background:#AF0100 !important;
					color:white !important;
				}
				.ui-jqgrid-bdiv
				{
					height: 232px !important;
				}
				.ui-widget-overlay
				{
					z-index:0 !important;
				}
				.ui-widget-header
				{
				background: #1e7ad7 !important;
				}
				.ui-jqgrid-hdiv ui-state-default
				{
				width: 873px !important; cursor: default!important
				}
				ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight 
				{
				border: 1px solid #fed22f;
				background: #ffe45c;
			   }
			   .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
			   {
					font-weight: bold;
					color: black;
				}
			.ui-jqgrid .ui-jqgrid-bdiv {
				overflow-y: scroll;
				//overflow-x: hidden;
				}
				
				
			</style>
	<script src="<?php echo base_url('public/assets/js/jquery.table2excel.js');?>"></script>		
<script type="text/javascript">
	
	function change_status(){
		console.log('changed');
	}
	$(function(){

$(".from_date").datepicker({

dateFormat: 'dd-mm-yy',

}).on('changeDate', function(ev){

$('.from_date').datepicker('hide');

});

});
	$('.from_date').on('change', function(){
	    var date = $(this).val();
	    $('.to_date').datepicker({
	            dateFormat: 'dd-mm-yy',
	            minDate: date,
	    });  
	});
</script>
<style>
#ui-datepicker-div
{
	z-index: 999 !important;
}
</style>
<script type="text/javascript">
function some_function() {
        console.log("Edit button clicked!");
    }
$(document).ready(function (){

$('#select_month').click(function(){

var  from_date=$("input[name=from_date]").val();
		var  to_date=$("input[name=to_date]").val();
		var  customer_name=$("input[name=customer_name]").val();
		//alert(customer_name);
	jQuery("#list3").jqGrid({

url:"<?php echo site_url('enquiries-list')?>?from_date="+from_date+"&to_date="+to_date+"&customer_name="+customer_name,	 
		 mtype : "post", 	 
		datatype: "json", 
	    colNames:['SI','Name','Email','Contact','Address','Portal','Database','Reference','Enquired on','Status','Edit','Delete'],
		colModel:[
					{name:'enquiry_id',index:'enquiry_id', width:50, hidden:true,editable:false,key:true},
					{name:'customer_name',index:'customer_name', width:100, editable:false},
					{name:'email',index:'email', width:100, editable:false},
					{name:'mobile',index:'mobile', width:175, editable:false},
					{name:'address',index:'address', width:100, editable:false},
					{name:'web_portal_address',index:'web_portal_address', width:100, editable:false},
					{name:'database_name',index:'database_name', width:100, editable:false},
					{name:'reference',index:'reference', width:100, editable:false},
					{name:'created_at',index:'created_at', width:100, formatter: 'date', formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'},editable:false},
					{name:'status',index:'status', width:100, editable:false},
					
					 {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' onclick='some_function' data-toggle='modal' data-target='#edit_modal' \>";
			}},	
			  {name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun_delete($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
			return "<input type='button'  value='DELETE'  \>";
			  }},
			  
	      	    ],
	      	  rowNum:100,
		      	rowTotal: 10000,
		      	rowList : [100,1000,2000,4000,8000,16000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:" Enquiry List",
			
		});

$("#list3").jqGrid("setLabel", "rn", "SL");

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

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

// $("#list3").navButtonAdd('#pager3',
		// 		{ 	caption:"Change Status", 
		// 			buttonicon:"ui-icon-pencil", 
		// 			onClickButton: change_status,
		// 			position: "last", 
		// 			title:"", 
		// 			cursor: "pointer",
		// 			id:"client_edit_new"
		// 		} 
		// );	
		
		function print_page(){
		console.log('clicked');
		}
  		$("#list3").navButtonAdd('#pager3',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);

function export_page(){
		console.log('clicked');
			}
 		$("#list3").navButtonAdd('#pager3',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				} 
		);

});

//$(document).ready(function (){
//
//	$('#select_month').click(function(){
//
//		var  from_date=$("input[name=from_date]").val();
//		var  to_date=$("input[name=to_date]").val();
//		var  customer_name=$("input[name=customer_name]").val();
//		//alert(customer_name);
//	jQuery("#list3").jqGrid({
//
//	 	url:"<?php echo site_url('gss/enquiries')?>?from_date="+from_date+"&to_date="+to_date+"&customer_name="+customer_name,	 
//		 mtype : "post", 	 
//		datatype: "json", 
//	    colNames:['SI','Name','Email','Contact','Address','Portal','Database','Reference','Enquired on','Edit','Delete'],
//		colModel:[
//					{name:'enquiry_id',index:'enquiry_id', width:50, hidden:true,editable:false,key:true},
//					{name:'customer_name',index:'customer_name', width:100, editable:false},
//					{name:'email',index:'email', width:100, editable:false},
//					{name:'mobile',index:'mobile', width:175, editable:false},
//					{name:'address',index:'address', width:100, editable:false},
//					{name:'web_portal_address',index:'web_portal_address', width:100, editable:false},
//					{name:'database_name',index:'database_name', width:100, editable:false},
//					{name:'associate_name',index:'associate_name', width:100, editable:false},
//					{name:'created_at',index:'created_at', width:100,formatter: 'date', formatoptions: { newformat: 'd/m/Y'}, editable:false},
//
//					
//					 {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
//						{
//                	     return ' onclick="fun($(this))" ';
//                		},formatter:function (cellvalue, options, rowObject) {    
//						return "<input type='button' value='EDIT' onclick='some_function' data-toggle='modal' data-target='#edit_modal' \>";
//			}},	
//			  {name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
//						{
//                	     return ' onclick="fun_delete($(this))" ';
//                		},formatter:function (cellvalue, options, rowObject) {    
//			return "<input type='button'  value='DELETE'  \>";
//			  }},
//			  
//	      	    ],
//	      	  rowNum:20,
//		      	rowTotal: 2000,
//		      	rowList : [10,20,30,50,100,500,1000],
//		      	rownumbers: true,
//		      	rownumWidth: 40,
//		      	pager:"#pager3", 
//		      	sortname:'id', 
//		      	viewrecords: true,
//		      	gridview: true,
//		      	autowidth: true,
//		      	sortorder:"asc",
//		      	shrinkToFit: false,
//		      	
//		      	 emptyrecords: 'No records to display',
//		       //  multiselect: true,
//		         // multiboxonly: true,
//		      	loadonce:true,
//				caption:" Enquiry List",
//			
//		}); 
//
//		$("#list3").jqGrid("setLabel", "rn", "SL");
//
// 		$("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
//
// 		$("#list3").jqGrid('navGrid','#pager3',
//			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
//			{ },
//	        { },
//	        { }, 
//			{
//		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
//		        closeOnEscape: true, 
//		        	multipleSearch: true, 
//		         	closeAfterSearch: true }
//		);
//
//
//
// 		$("#list3").navButtonAdd('#pager3',
//				{ 	caption:"Change Status", 
//					buttonicon:"ui-icon-pencil", 
//					onClickButton: change_status,
//					position: "last", 
//					title:"", 
//					cursor: "pointer",
//					id:"client_edit_new"
//				} 
//		);	
//		
//  		$("#list3").navButtonAdd('#pager3',
// 				{ 	caption:"Print", 
//					buttonicon:"ui-icon-print", 
// 					onClickButton:print_page,
// 					position: "last", 
//					title:"", 
// 					cursor: "pointer",
//					id:"client_delete_new"
// 				} 
//		);	
// 		$("#list3").navButtonAdd('#pager3',
//				{ 	caption:"Export", 
//					buttonicon:"", 
//					onClickButton: export_page,
//					position: "last", 
//					title:"", 
//					cursor: "pointer",
//					id:"client_delete"
//				} 
//		);	
//
// 			
// 		
//	});
//
//});

function fun(rowId)
{
   var id = rowId.closest('tr').attr('id');
   //alert(id);
   $.ajax({          
       type   : 'post',
       url    : '<?php echo site_url("edit-enquiries")?>',
       data   : {enquiry_id:id},

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

if(response.result == 1) 
           {
           	$(".enquiry_id_pk").val(response.enquiry_details.enquiry_id);
           	$(".name").val(response.enquiry_details.customer_name);
           	$(".mobile").val(response.enquiry_details.mobile);
        	$(".mobile2").val(response.enquiry_details.mobile2);
           	$(".web_portal option[value='"+response.enquiry_details.web_portal_address+"']").attr("selected","selected");
           	$(".database option[value='"+response.enquiry_details.database_name+"']").attr("selected","selected");
           	$(".reference option[value='"+response.enquiry_details.reference+"']").attr("selected","selected");
           	$(".email").val(response.enquiry_details.email);
           	$(".address").val(response.enquiry_details.address);
           	$(".reference").val(response.enquiry_details.reference);
        	$("#status").val(response.enquiry_details.status);
            $("#edit_modal").modal("show");
            $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                }
            }
	            });  
}

function fun_delete(rowId)
{
	
  var id = rowId.closest('tr').attr('id'); 
  var enquiry_id=id;

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-enquiries")?>',
                      data   : {enquiry_id:enquiry_id},

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

if (response.result == 1) {
    toastr["success"]("Deleted successfully");
    // ✅ Use only `reloadGrid`
    $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
}

}
                  });

} 
                      else {

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

});

}

$('.update_form').submit(function(e){    
    e.preventDefault();

formdata = new FormData($(this)[0]);

$(".submit").attr('disabled', 'disabled');
        $(".submit").text("Updating...");

$.ajax({

type   : 'post',
            url    : '<?php echo site_url("update-enquiry")?>',
            data   : formdata,
            contentType: false,
            processData: false,
                                      
              success:function(response){
              //response=jQuery.parseJSON(response);
              console.log(response);

if(response.result==1)
                {
                	$("#edit_modal").modal("hide");
                	$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
                    toastr["success"](response.message);
                    $('.update_form')[0].reset();
                    $(".submit").text("Submit");  
                    $(".submit").removeAttr('disabled');                  
                }
                else 
                {
                    toastr["error"](response.message);                       
	                $(".submit").text("Submit"); 
	                $(".submit").removeAttr('disabled');                      
                }
               
            }
            
     });
         
 });

// function export_page() {
// 	id = jQuery("#list3").jqGrid('getDataIDs');

// 	$.ajax({
//         type   : 'post',
//         url    : '<?php echo site_url("get_table_details_export")?>',
//         data   : {id:id},
                                  
//           success:function(response){
//           //response=jQuery.parseJSON(data);
//           console.log(response);
//          var count =1;
         
//                 var content = '';
//                 content +='<thead><tr><th>Sl No</th> <th>Village</th> <th>Hobli</th> <th>Sy. No</th> <th>Document Name</th> <th>Criteria</th> <th>Excutive Assign Date</th> <th>Sorce</th><th>Remark</th><th>Excutive</th></tr></thead>';
//                 $.each(response,function(key,vas){

//                 	$.each(vas,function(key,val){
//                 	var id_proove=jQuery.parseJSON(val.id_proof);

//                 	content +='<tr><td>'+count+'</td> <td>'+val.village+'</td> <td>'+val.hobli+'</td> <td>'+val.survey_number+'</td> <td>'+val.document_name+'</td>';
//                 	content +='<td>';
//                  	$.each(id_proove,function(key,va){

//                 		content+=va.id_proof_name+':'+va.id_proof_no+',';
               		
//                  	});
//                 	content +='</td>';
//                 	content +='<td>'+val.start_date+'</td> <td>'+val.source_master+'</td><td>'+val.remark+'</td><td>'+val.name+'</td></tr>';

// 					count++;
					
//                 });
//                 });
//                  $('.export_table').append(content);
                 
//                  export_data();
//           }
// 				 });
				
// 				}
// function export_data(){
// 	$("#export_table").table2excel({
// 	exclude: ".noExl",
// 	name: "Excel Document Name",
// 	filename: "Completed_list",
// 	fileext: ".xls",
// 	exclude_img: true,
// 	exclude_links: true,
// 	exclude_inputs: true
// 	});						   
// 	}

// function print_page() {
// 	id = jQuery("#list3").jqGrid('getDataIDs');
// 	$.ajax({
//         type   : 'post',
//         url    : '<?php echo site_url("get_table_details")?>',
//         data   : {id:id},
                                  
//           success:function(response){
//           //response=jQuery.parseJSON(data);
		  
//          console.log(response);
        
//                var count =1;
//                 var content = '';
//                 content +='<thead><tr><th>Sl No</th> <th>Village</th> <th>Hobli</th> <th>Sy. No</th> <th>Document Name</th> <th>Criteria</th> <th>Excutive Assign Date</th></tr></thead>';
//                 $.each(response,function(key,val){
//                 	$.each(val,function(key,va){
                	
//                     //alert(va.assign_date);
                	
//                 	 //$.each(va.message,function(key,val){
                    	 
//                 	var id_proove=jQuery.parseJSON(va.id_proof);

//                 	content +='<tr><td>'+count+'</td> <td>'+va.village+'</td> <td>'+va.hobli+'</td> <td>'+va.survey_number+'</td> <td>'+va.document_name+'</td>';
//                 	content +='<td>';
//                 	$.each(id_proove,function(key,va){

//                 		content+=va.id_proof_name+':'+va.id_proof_no;
//                 		content+='</br>';
//                 	});
//                 	//});
//                 	content +='</td>';
//                 	content +='<td>'+va.start_date+'</td></tr>';

// 					count++;
//                 	});
//                 });
//                  $('.print_table').append(content);
// print_page1();
//           }
// 				 });
				
// 				}

// function print_page1()
// {  
	
// 	var divToPrint=document.getElementById('print_table');
// 		newWin= window.open("");
// 		newWin.document.write('<html><head><title></title>');
// 		newWin.document.write('</head>');
// 		newWin.document.write(divToPrint.outerHTML);
// 		newWin.document.write('</html>');
// 		newWin.print();
// 		document.getElementById('print_table').style.display='';
// 		newWin.close();
// 		location.reload();
// }
</script>

$(document).ready(function(){

function isNumberKey(evt){
    var charCode = (evt.which) ? evt.which : event.keyCode
    if (charCode > 31 && (charCode < 48 || charCode > 57))
        return false;
    return true;
}

});

</script>
	
<?php echo view('includes/footer');?>