EVOLUTION-NINJA
Edit File: linkedin_customer.php
<?php $this->load->view('includes/header'); ?> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/grid_style.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap-ui.css'); ?>" /> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <!----------------------------- Left MENU END ---------------------------------------------------> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <div class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> </div> <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="#">Customer</a></li> <li class="breadcrumb-item"> LinkedIn Customer </li> </ol> </div> </div> </div> </div> <div class="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <div class="row duplicate_for_hide"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <div id="todays_list"> <div id ="todaysjaytab" style="margin-top:3%" class="grid "> <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> </div> </div> </div> </div> <script type="text/javascript"> $.ajax({ type : 'post', url : "<?php echo site_url('get-total-customer-count');?>", success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.todays_entry').html(response.message); } else { $('.todays_entry').html('0'); } } }); $.ajax({ type : 'post', url : "<?php echo site_url('get-duplicate-customer-count');?>", success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.duplicate_entry').html(response.message); } else { $('.duplicate_entry').html('0'); } } }); $(document).ready(function() { $("#phone_no_search" ).autocomplete({ source: '<?php echo site_url("auto-complete-phone-based-customer"); ?>', }); }); $(document).ready(function() { $("#phone_no_search_duplicate" ).autocomplete({ source: '<?php echo site_url("auto-complete-phone-based-duplicate-customer"); ?>', }); }); $('#phone_no_search').change(function() { $('#todays_list').hide(); $('#date_list').show(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').hide(); //$('.duplicate_for_hide').hide(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').show(); $('.submit_button').hide(); $('.update_button').show(); var phone_no_search = $('#phone_no_search').val(); $.ajax({ type:'post', url:'<?php echo site_url('get-customer-details-based-phoneno');?>', data:{'phone_no_search':phone_no_search}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { $('.customer_idss').val(response.message.id); $('.a_customer_name').val(response.message.name); $('.a_phone').val(response.message.phone); $('.a_email').val(response.message.email); $('.a_remarks').val(response.message.remarks); $('.a_ref_type').val(response.message.ref_type); $('.a_nri_no').val(response.message.nri_no); $('.a_dept_id').val(response.message.department_id); $('.a_dept_name').val(response.message.dept_name); $('.a_emp_name').val(response.message.employee_id); $('.site_idss').val(response.message.ref_site_number); $('.ref_person').val(response.message.ref_person); $('.enquiry_layout').val(response.message.enquiry_layout); $('.customer_id_for_update').val(response.message.id); $('.employee_name').val(response.message.ref_person); var con=''; if (response.message.reference_type == 'Old Customer') { con += '<label class="col-sm-4">Layout Name<span style="color:red" ></span></label>'; con += '<div class="col-sm-8 yes_form">'; con += '<select type="text" class="form-control layout_list" name="layout_id">'; con += '<option value="">Select</option>'; $.each( response.layouts, function( key, value ) { if(value.id == response.message.ref_layout_id) { con+='<option value="'+value.id+'" selected>'+value.layout_name+'</option>'; } else { con+='<option value="'+value.id+'" >'+value.layout_name+'</option>'; } }); con += '</select> '; con += '</div> '; $('#leaves').empty(); $('#leaves').append(con); $.ajax({ type:'post', url:'<?php echo site_url('get-site-based-on-layout');?>', data:{'layout_id':response.message.ref_layout_id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var site_idss = $('.site_idss').val(); var con1 = ''; con1 += '<label class="col-sm-4">Site No<span style="color:red" ></span></label>'; con1 += '<div class="col-sm-8 yes_form">'; con1 += '<select type="text" class="form-control layout_list" name="site_id">'; con1 += '<option value="">Select</option>'; $.each( response.sites, function( key, value2 ) { if(value2.id == site_idss) { con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>'; } else { con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>'; } }); con1 += '</select> '; con1 += '</div> '; $('#leaves1').empty(); $('#leaves1').append(con1); } else { $('#leaves1').empty(); toastr["error"](response.message); } } }); $.ajax({ type:'post', url:'<?php echo site_url('get-customer-based-on-layout-site');?>', data:{'site_id':response.message.ref_site_number,'layout_id':response.message.ref_layout_id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var ref_person = $('.ref_person').val(); var con2 = ''; con2 += '<label class="col-sm-4">Layout Name<span style="color:red" ></span></label>'; con2 += '<div class="col-sm-8 yes_form">'; con2 += '<select type="text" class="form-control customer_id" name="customer_id">'; con2 += '<option value="">Select</option>'; $.each( response.customer, function( key, value3 ) { if(value3.customer_id == ref_person) { con2+='<option value="'+value3.customer_id+'" selected>'+value3.name+'</option>'; } else { con2+='<option value="'+value3.customer_id+'" >'+value3.name+'</option>'; } }); con2 += '</select> '; con2 += '</div> '; $('#leaves2').empty(); $('#leaves2').append(con2); } else { $('#leaves2').empty(); toastr["error"](response.message); } } }); } } else { $('#edit_ref_person').empty(); toastr["error"](response.message); } } }); load_date_grid21(); function load_date_grid21() { var phone_no_search = $('#phone_no_search').val(); $("#list20").setGridParam( { url:"<?php echo site_url('get-customer-details-based-phoneno-list')?>/"+phone_no_search, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list20").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } $("#list20").jqGrid({ url:"<?php echo site_url('get-customer-details-based-phoneno-list')?>/"+phone_no_search, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action','Duplicate Customer'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ //{name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, {name:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <button><a href="javascript:void(0);" onclick="duplicate_customer('+rowObject.id+');" class="" id="btn">Duplicate</button></a>'; return retVal; }}, ], rowNum:20, rowTotal: 2000, rowList : [20,30], rownumbers: true, //rownumWidth: 60, pager:"#pager20", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Customer List", //Subgrid1... subGrid: false, }); $("#list20").jqGrid("setLabel", "rn", "SL"); $("#list20").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list20").jqGrid('navGrid','#pager20', {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 }, ); }); function planningtypes(str) { if(str=="today_list") { $('#todays_list').show(); $('#date_list').hide(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').hide(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="dates_list") { $("#datelist1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').show(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').hide(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="months_list") { $("#monthlist2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').hide(); $('#month_list').show(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').hide(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="years_list") { $("#yearlist3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').hide(); $('#month_list').hide(); $('#year_list').show(); $('#all_list').hide(); $('#duplicate_list').hide(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="alls_list") { $("#list0").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').hide(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').show(); $('#duplicate_list').hide(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="duplicate_customer") { $("#duplicatelist3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').hide(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').show(); $('.duplicate_for_hide').show(); $('.show_duplicate_search').hide(); $('#search_duplicate_list').hide(); $('#phone_search_grid').hide(); } else if(str=="search_duplicate_customer") { $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#date_list').hide(); $('#month_list').hide(); $('#year_list').hide(); $('#all_list').hide(); $('#duplicate_list').hide(); $('#search_duplicate_list').show(); $('.duplicate_for_hide').hide(); $('.show_duplicate_search').show(); $('#phone_search_grid').hide(); } } CallGrid(); function CallGrid() { $('#all_list').hide(); jQuery("#list2").jqGrid({ url:"<?php echo site_url('get-customer-today-list')?>", mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created_time','Action'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ //{name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, ], rowNum:20, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#pager2", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"LinkedIn Customer List", //Subgrid1... subGrid: false, }); $("#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:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); } $('input[name=optradio]').change(function() { var value = $(this).val(); $('.from_to_date').empty(); $('.months').empty(); $('.years').empty(); $('.filter_submit').empty(); if(value == 'date') { $('.from_to_date').empty(); var content = ''; content += '<div class="row" style="padding-top: 30px;">'; content += '<div class="col-sm-2">'; content += '<div class="form-group">'; content += '<center><label>From Date</label> </center>'; content += '</div>'; content += '</div>'; content += '<div class="col-sm-4">'; content += '<div class="form-group">'; content += '<input type="text" name="from_date" class="form-control from_date from_datepicker">'; content += '</div> '; content += '</div>'; content += '<div class="col-sm-2">'; content += '<div class="form-group">'; content += '<center><label >To Date</label></center>'; content += '</div> '; content += '</div>'; content += '<div class="col-sm-4">'; content += '<div class="form-group">'; content += '<input type="text" name="to_date" class="form-control to_date from_datepicker">'; content += '</div>'; content += '</div> '; content += '</div>'; $('.from_to_date').append(content); var content1 = ''; content1 += '<div class="form-group">'; content1 += '<div class="col-sm-6">'; content1 += '<button type="submit" id="btn" class="btn btn-primary center-block">Submit</button>'; content1 += '</div>'; content1 += '</div>'; $('.filter_submit').append(content1); $(function(){ $(".from_datepicker").datepicker({ dateFormat: 'dd-mm-yy', }).on('changeDate', function(ev){ $('.to_datepicker').datepicker('hide'); }); }); $('.from_datepicker').on('change', function(){ var date = $(this).val(); $('.to_datepicker').datepicker({ dateFormat: 'dd-mm-yy', minDate: date, }); }); } else if(value == 'month') { $('.months').empty(); var content = ''; content += '<div class="row" style="padding-top: 30px;">'; content += '<div class="col-sm-2">'; content += '<center><label>Months</label></center>'; content += '</div>'; content += '<div class="col-sm-4">'; content += '<div class="form-group">'; content += '<select class="form-control col-sm-8 month" id="months" name="months">'; content += '<option value="">Select</option>'; content += '<option value="01">January</option>'; content += '<option value="02">Febraury</option>'; content += '<option value="03">March</option>'; content += '<option value="04">April</option>'; content += '<option value="05">May</option>'; content += '<option value="06">June</option>'; content += '<option value="07">July</option>'; content += '<option value="08">August</option>'; content += '<option value="09">September</option>'; content += '<option value="10">October</option>'; content += '<option value="11">November</option>'; content += '<option value="12">December</option>'; content += '</select>'; content += '</div>'; content += '</div>'; content += '</div>'; var content1 = ''; content1 += '<div class="form-group">'; content1 += '<div class="col-sm-6">'; content1 += '<button type="submit" id="btn" class="btn btn-primary center-block">Submit</button>'; content1 += '</div>'; content1 += '</div>'; $('.filter_submit').append(content1); $('.months').append(content); } else if(value == 'year') { $('.years').empty(); var content = ''; content += '<div class="row" style="padding-top: 30px;">'; content += '<div class="col-sm-2">'; content += '<center><label>Year</label></center>'; content += '</div>'; content += '<div class="col-sm-4">'; content += '<div class="form-group">'; content += '<input type="text" name="year" class="form-control year" id="datetimepicker1" >'; content += '</div>'; content += '</div>'; content += '</div>'; $('.years').append(content); var content1 = ''; content1 += '<div class="form-group">'; content1 += '<div class="col-sm-6">'; content1 += '<button type="submit" id="btn" class="btn btn-primary center-block">Submit</button>'; content1 += '</div>'; content1 += '</div>'; $('.filter_submit').append(content1); $('#datetimepicker1').datetimepicker({ format : "YYYY", //viewMode : "years", }); } /* var content = ''; content += '<div class="form-group">'; content += '<div class="col-sm-6">'; content += '<button type="submit" id="btn" class="btn btn-primary center-block">Submit</button>'; content += '</div>'; content += '</div>'; $('.filter_submit').append(content);*/ }); $('.filter_choice_submit').submit(function(e) { e.preventDefault(); var type = $('input[name=optradio]:checked').val(); if(type == 'date') { load_date_grid(); function load_date_grid() { var from_date = $(".from_date").val(); var to_date = $(".to_date").val(); $("#datelist1").setGridParam( { url:"<?php echo site_url('get-datewise-customer-list')?>?from_date="+from_date+"&&to_date="+to_date, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#datelist1").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } var from_date = $(".from_date").val(); var to_date = $(".to_date").val(); $("#datelist1").jqGrid({ url:"<?php echo site_url('get-datewise-customer-list')?>?from_date="+from_date+"&to_date="+to_date, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ //{name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, /* {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = '<a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }},*/ ], rowNum:20, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#datepager1", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Customer List", //Subgrid1... subGrid: false, }); $("#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:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); } else if(type == 'month') { load_month_grid(); function load_month_grid() { var month = $(".month").val(); $("#monthlist2").setGridParam( { url:"<?php echo site_url('get-monthwise-customer-list')?>?month="+month, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#monthlist2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } var month = $(".month").val(); $("#monthlist2").jqGrid({ url:"<?php echo site_url('get-monthwise-customer-list')?>?month="+month, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ //{name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, /*{name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }},*/ ], rowNum:20, rowTotal: 2000, rowList : [20,30], rownumbers: true, //rownumWidth: 60, pager:"#monthpager2", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Customer List", //Subgrid1... subGrid: false, }); $("#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:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); } else { load_year_grid(); function load_year_grid() { var year = $(".year").val(); $("#yearlist3").setGridParam( { url:"<?php echo site_url('get-yearwise-customer-list')?>?year="+year, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#yearlist3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } var year = $(".year").val(); $("#yearlist3").jqGrid({ url:"<?php echo site_url('get-yearwise-customer-list')?>?year="+year, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ // {name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, /* {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }},*/ ], rowNum:20, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#yearpager2", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Customer List", //Subgrid1... subGrid: false, }); $("#list0").jqGrid("setLabel", "rn", "SL"); $("#list0").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list0").jqGrid('navGrid','#pager2', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); } }); $("#list0").jqGrid({ url:"<?php echo site_url('get-customer-list')?>", mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action','Duplicate Customer'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, /* {name:'phone',index:'phone', width:100, hidden:false,editable:false}, {name:'email',index:'email', width:200, hidden:false,editable:false},*/ //{name:'nri_no',index:'nri_no',editable:false, width:200}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, {name:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <button><a href="javascript:void(0);" onclick="duplicate_customer('+rowObject.id+');" class="" id="btn">Duplicate</button></a>'; return retVal; }}, ], rowNum:50, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#pager0", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Customer List", //Subgrid1... subGrid: false, }); $("#list0").jqGrid("setLabel", "rn", "SL"); $("#list0").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list0").jqGrid('navGrid','#pager2', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); <?php $role_id =$this->session->userdata('role_id'); if($role_id == 1){?> $("#duplicatelist3").jqGrid({ url:"<?php echo site_url('get-duplicate-customer-list')?>", mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = '<a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, ], rowNum:50, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#duplicatepager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Duplicate Customer List", //Subgrid1... subGrid: false, }); $("#duplicatelist3").jqGrid("setLabel", "rn", "SL"); $("#duplicatelist3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#duplicatelist3").jqGrid('navGrid','#duplicatepager3', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); <?php } else { ?> $("#duplicatelist3").jqGrid({ url:"<?php echo site_url('get-duplicate-customer-list')?>", mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, ], rowNum:50, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#duplicatepager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Duplicate Customer List", //Subgrid1... subGrid: false, }); $("#duplicatelist3").jqGrid("setLabel", "rn", "SL"); $("#duplicatelist3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#duplicatelist3").jqGrid('navGrid','#duplicatepager3', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); <?php } ?> $('#phone_no_search_duplicate').change(function() { load_date_grid_search(); function load_date_grid_search() { var phone_no_search2 = $('#phone_no_search_duplicate').val(); $("#searchlist").setGridParam( { url:"<?php echo site_url('get-phone-based-duplicate-customer')?>/"+phone_no_search2, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#searchlist").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } <?php $role_id =$this->session->userdata('role_id'); if($role_id == 1){?> var phone_no_search2 = $('#phone_no_search_duplicate').val(); $("#list8").jqGrid({ url:"<?php echo site_url('get-phone-based-duplicate-customer')?>/"+phone_no_search2, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = '<a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, ], rowNum:50, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Duplicate Customer List", //Subgrid1... subGrid: false, }); $("#list8").jqGrid("setLabel", "rn", "SL"); $("#list8").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list8").jqGrid('navGrid','#pager3', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); <?php } else { ?> var phone_no_search2 = $('#phone_no_search_duplicate').val(); $("#list8").jqGrid({ url:"<?php echo site_url('get-phone-based-duplicate-customer')?>/"+phone_no_search2, mtype : "get", datatype: "json", colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:100, hidden:false,editable:false}, {name:'reference_type',index:'reference_type',editable:false, width:100}, {name:'ref_person',index:'ref_person',editable:false, width:100}, {name:'ref_layout',index:'ref_layout',editable:false, width:75}, {name:'ref_site_number',index:'ref_site_number',editable:false, width:100}, {name:'remarks',index:'remarks',editable:false, width:100}, {name:'first_name',index:'first_name',editable:false, width:100}, {name:'dept_name',index:'dept_name',editable:false, width:100}, {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'created_by',index:'created_by',editable:false, width:100}, {name:'created_time',index:'created_time',editable:false, width:100}, ], rowNum:50, rowTotal: 2000, rowList : [20,30,100,200,500,1000], rownumbers: true, //rownumWidth: 60, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Duplicate Customer List", //Subgrid1... subGrid: false, }); $("#list8").jqGrid("setLabel", "rn", "SL"); $("#list8").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required $("#list8").jqGrid('navGrid','#pager3', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, closeAfterDelete:true, closeAfterEdit:true }, ); <?php } ?> }); function duplicate_customer(id) { $.ajax({ type : 'post', url : "<?php echo site_url('insert-duplicate-customer');?>", data : {'customer_id':id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); location.reload(); } else{ toastr["error"](response.message); } } }); } $('#add_customer').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); swal({ title: "Are you sure?", text: "You want to Save this?", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : "<?php echo site_url('insert-customer');?>", data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); setTimeout(1000); location.reload(); } else { toastr["error"](response.message); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); }); function delete_customer(id) { swal({ title: "Are you sure?", text: "You will not be able to recover this customer 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(); $.ajax({ type : 'post', url : "<?php echo site_url('delete-customer-details');?>", data : {'customer_id':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'); location.reload(); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } $('.import_data').submit(function(e){ e.preventDefault(); $(".submit1").attr('disabled', 'disabled'); $(".submit1").text("Uploading..."); formdata = new FormData($(this)[0]); $.ajax({ type : 'post', url : '<?php echo site_url('Customer-Info-Import');?>', data : formdata, contentType: false, processData: false, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { //alert(); $('.import_data')[0].reset(); $(".submit1").text("Upload"); $("#impcustomer").modal("hide"); toastr["success"](response.message); setTimeout(function wait(){ window.location = '<?php echo site_url("add-customer")?>'; }, 1000); } else { $('.import_data')[0].reset(); toastr["error"](response.message); $(".submit1").text("Upload"); $(".submit1").removeAttr('disabled'); } } }); }); function change_reference() { var select = $('.ref_type option:selected').text(); if(select == "Old Customer") { $('.emp_dep_div').hide(); $.ajax({ type:'post', url:'<?php echo site_url('get-all-layout');?>', data:{'customer_id':select}, success:function(response){ response=jQuery.parseJSON(response); if(response.result==1) { $('#edit_layout_id').show(); var con=''; if (select == 'Old Customer') { con += '<label class="col-sm-4">Layout Name<span style="color:red" ></span></label>'; con += '<div class="col-sm-8 yes_form">'; con += '<select type="text" class="form-control layout_list" name="layout_id">'; con += '<option value="">Select</option>'; $.each( response.message, function( key, value ) { con+='<option value="'+value.id+'" >'+value.layout_name+'</option>'; }); con += '</select> '; con += '</div> '; $('#leaves').empty(); $('#leaves').append(con); $('#edit_layout_id').empty(); $('#edit_layout_id').append(con); $('.layout_list').change(function() { var id = $(this).val(); $('#layout_id').val(id); $.ajax({ type:'post', url:'<?php echo site_url('get-site-based-on-layout');?>', data:{'layout_id':id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var con1 = ''; con1 += '<label class="col-sm-4">Site No<span style="color:red" ></span></label>'; con1 += '<div class="col-sm-8">'; con1 += '<select type="text" class="form-control site_list" name="site_id">'; con1 += '<option value="">Select</option>'; $.each( response.sites, function( key, value2 ) { con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>'; }); con1 += '</select> '; con1 += '</div> '; $('#leaves1').empty(); $('#leaves1').append(con1); $('#edit_site_id').empty(); $('#edit_site_id').append(con1); } else { $('#leaves1').empty(); $('#edit_site_id').empty(); toastr["error"](response.message); } } }); }); } else { $('#leaves').empty(); $('#leaves1').empty(); $('#leaves2').empty(); $('#edit_layout_id').empty(); $('#edit_site_id').empty(); $('#edit_ref_person').empty(); } } } }); } else if(select == "Staff") { $('.emp_dep_div').show(); $('#leaves').empty(); $('#leaves1').empty(); $('#leaves2').empty() } else if(select == "Channel Partner") { $('.emp_dep_div').hide(); $('#leaves1').empty(); $('#leaves2').empty(); $.ajax({ type:'post', url:'<?php echo site_url('get-channel-partners-employee');?>', data:{'channel_partner':select}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var con = ''; con += '<label class="col-sm-4">Refered Employee Name<span style="color:red" ></span></label>'; con += '<div class="col-sm-8">'; con += '<select type="text" class="form-control" name="refered_employee_id">'; con += '<option value="">Select</option>'; $.each( response.message, function( key, value2 ) { con+='<option value="'+value2.emp_id+'" >'+value2.first_name+' '+value2.last_name+'</option>'; }); con += '</select> '; con += '</div> '; $('#leaves').empty(); $('#leaves1').empty(); $('#leaves2').empty(); $('#leaves').append(con); } else { $('#leaves1').empty(); $('#leaves2').empty(); $('#leaves').empty(); toastr["error"](response.message); } } }); } } function edit_change_reference() { var select = $('.edit_ref_type option:selected').text(); if(select == "Old Customer") { $('.employee_div').hide(); $.ajax({ type:'post', url:'<?php echo site_url('get-all-layout');?>', data:{'customer_id':select}, success:function(response){ response=jQuery.parseJSON(response); if(response.result==1) { $('#edit_layout_id').show(); var con=''; if (select == 'Old Customer') { con += '<label>Layout Name<span style="color:red" ></span></label>'; con += '<select type="text" class="form-control layout_list" name="layout_id">'; con += '<option value="">Select</option>'; $.each( response.message, function( key, value ) { con+='<option value="'+value.id+'" >'+value.layout_name+'</option>'; }); con += '</select> '; con += '</div> '; $('#edit_layout_id').empty(); $('#edit_layout_id').append(con); $('.layout_list').change(function() { var id = $(this).val(); $('#layout_id').val(id); $.ajax({ type:'post', url:'<?php echo site_url('get-site-based-on-layout');?>', data:{'layout_id':id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var con1 = ''; con1 += '<label>Site No<span style="color:red" ></span></label>'; con1 += '<select type="text" class="form-control site_list" name="site_id">'; con1 += '<option value="">Select</option>'; $.each( response.sites, function( key, value2 ) { con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>'; }); con1 += '</select> '; $('#edit_site_id').empty(); $('#edit_site_id').append(con1); } else { $('#edit_site_id').empty(); toastr["error"](response.message); } } }); }); } else { $('#edit_layout_id').empty(); $('#edit_site_id').empty(); $('#edit_ref_person').empty(); } } } }); } else if(select == "Staff") { $('.employee_div').show(); $('#edit_layout_id').empty(); $('#edit_site_id').empty(); $('#edit_ref_person').empty(); } else if(select == "Channel Partner") { $('.employee_div').hide(); $('#edit_layout_id').empty(); $('#edit_site_id').empty(); $('#edit_ref_person').empty(); $.ajax({ type:'post', url:'<?php echo site_url('get-channel-partners-employee');?>', data:{'channel_partner':select}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var con = ''; con += '<label>Refered Employee Name</label>'; con += '<select type="text" class="form-control" name="refered_employee_id">'; con += '<option value="">Select</option>'; $.each( response.message, function( key, value2 ) { con+='<option value="'+value2.emp_id+'" >'+value2.first_name+' '+value2.last_name+'</option>'; }); con += '</select> '; $('#leaves').empty(); $('#leaves1').empty(); $('#leaves2').empty(); $('#edit_layout_id').append(con); } else { $('#leaves1').empty(); $('#leaves2').empty(); $('#edit_layout_id').empty(); toastr["error"](response.message); } } }); } } $(document).on('change','.site_list',function() { var select = $('.ref_type option:selected').text(); var id = $(this).val(); var layout_id = $('#layout_id').val(); $.ajax({ type:'post', url:'<?php echo site_url('get-customer-based-on-layout-site');?>', data:{'site_id':id,'layout_id':layout_id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var con = ''; con += '<label class="col-sm-4">Customer Name<span style="color:red" ></span></label>'; con += '<div class="col-sm-8">'; con += '<select type="text" class="form-control customer_id" name="customer_id">'; con += '<option value="">Select</option>'; $.each( response.customer, function( key, value2 ) { con+='<option value="'+value2.customer_id+'" >'+value2.name+'</option>'; }); con += '</select> '; con += '</div> '; $('#leaves2').empty(); $('#leaves2').append(con); } else { $('#leaves2').empty(); toastr["error"](response.message); } } }); }); $('.employee_name').change(function() { var employee_name = $(this).val(); $.ajax({ type:'post', url:'<?php echo site_url('get-department-based-on-employee');?>', data:{'employee_name':employee_name}, success:function(response){ response=jQuery.parseJSON(response); if(response.result==1) { $('#department_name').empty(); $('#department_id').empty(); $('#department_name').val(response.message.dept_name); $('#department_id').val(response.message.id); $('.department_name').val(response.message.dept_name); $('.department_id').val(response.message.id); } else { $('#department_name').empty(); $('.department_name').empty(); toastr["error"](response.message); } } }); }); function edit_customer(id) { $.ajax({ type : 'post', url : "<?php echo site_url('edit-customer-details');?>", data : {'customer_id':id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('#edit_modal1').modal('show'); $('#edit_layout_id').empty(); $('#edit_site_id').empty(); $('#edit_ref_person').empty(); $('.customer_idss').val(response.message.id); $('.customer_name').val(response.message.name); $('.customer_phone').val(response.message.phone); $('.customer_email').val(response.message.email); $('.remarks').val(response.message.remarks); $('.edit_ref_type').val(response.message.ref_type); $('.nri_no').val(response.message.nri_no); $('.department_id').val(response.message.department_id); $('.department_name').val(response.message.dept_name); $('.employee_name').val(response.message.ref_person); $('.site_idss').val(response.message.ref_site_number); $('.ref_person').val(response.message.ref_person); $('.enquiry_layout_id').val(response.message.enquiry_layout); var con=''; if (response.message.reference_type == 'Old Customer') { con += '<label for="exampleInputUsername1">Layout Name</label>'; con += '<select type="text" class="form-control layout_list" name="layout_id">'; con += '<option value="">Select</option>'; $.each( response.layouts, function( key, value ) { if(value.id == response.message.ref_layout_id) { con+='<option value="'+value.id+'" selected>'+value.layout_name+'</option>'; } else { con+='<option value="'+value.id+'" >'+value.layout_name+'</option>'; } }); con += '</select> '; $('#edit_layout_id').empty(); $('#edit_layout_id').append(con); $.ajax({ type:'post', url:'<?php echo site_url('get-site-based-on-layout');?>', data:{'layout_id':response.message.ref_layout_id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var site_idss = $('.site_idss').val(); var con1 = ''; con1 += '<label for="exampleInputUsername1">Site No</label>'; con1 += '<select type="text" class="form-control layout_list" name="site_id">'; con1 += '<option value="">Select</option>'; $.each( response.sites, function( key, value2 ) { if(value2.id == site_idss) { con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>'; } else { con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>'; } }); con1 += '</select> '; $('#edit_site_id').empty(); $('#edit_site_id').append(con1); } else { $('#edit_site_id').empty(); toastr["error"](response.message); } } }); $.ajax({ type:'post', url:'<?php echo site_url('get-customer-based-on-layout-site');?>', data:{'site_id':response.message.ref_site_number,'layout_id':response.message.ref_layout_id}, success:function(response){ response=jQuery.parseJSON(response) if(response.result==1) { var ref_person = $('.ref_person').val(); var con2 = ''; con2 += '<label for="exampleInputUsername1">Referred Person</label>'; con2 += '<select type="text" class="form-control customer_id" name="customer_id">'; con2 += '<option value="">Select</option>'; $.each( response.customer, function( key, value3 ) { if(value3.customer_id == ref_person) { con2+='<option value="'+value3.customer_id+'" selected>'+value3.name+'</option>'; } else { con2+='<option value="'+value3.customer_id+'" >'+value3.name+'</option>'; } }); con2 += '</select> '; $('#edit_ref_person').empty(); $('#edit_ref_person').append(con2); } else { $('#edit_ref_person').empty(); toastr["error"](response.message); } } }); } else if (response.message.reference_type == 'Staff') { $('.employee_div').show(); } } } }); } $('.update_form').submit(function(e) { e.preventDefault(); $("#loading").show(); formdata = new FormData($(this)[0]); $(".update").attr('disabled', 'disabled'); $(".update").text("Updating..."); $.ajax({ type : 'post', url : '<?php echo site_url("update-customer-details")?>', data : formdata, contentType: false, processData: false, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $("#edit_modal1").modal("hide"); toastr["success"](response.message); $('.update_form')[0].reset(); $(".update").text("Submit"); $(".update").removeAttr('disabled'); location.reload(); } else if(response.result == 2) { toastr["error"](response.message); $(".update").text("Submit"); $(".update").removeAttr('disabled'); } else { toastr["error"](response.message); $(".update").text("Submit"); $(".update").removeAttr('disabled'); } } }); }); function delete_customer(id) { swal({ title: "Are you sure?", text: "You will not be able to recover this customer 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(); $.ajax({ type : 'post', url : "<?php echo site_url('delete-customer-details');?>", data : {'customer_id':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'); $("#list0").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#datelist1").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#monthlist2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#yearlist3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } else { toastr["error"](response.message); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } </script> <style type="text/css"> .content-wrapper { max-width: 1460px !important; } .row-form { width:100%; } .form_submit label{ padding-top: 20px; } #ui-id-1{ margin-left: 1128px; width: 190.859px; margin-top: 218px; } #search{ margin-right: 30px; } </style> <?php $this->load->view('includes/footer'); ?>