EVOLUTION-NINJA
Edit File: holiday_list.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="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <form class="filter_choice_submit"> <div class="form-check-inline"> <label class="form-check-label"> <input type="radio" checked="checked" class="form-check-input" id="todays" name="optradio" value="todays" onclick="planningtypes('today_list')">All </label> </div> <div class="form-check-inline"> <label class="form-check-label"> <input type="radio" class="form-check-input" id="month" name="optradio" value="month" onclick="planningtypes('months_list')">Month </label> </div> <div class="months"> </div> <div class="row " style="padding-top: 30px;"> <div class="center filter_submit"> </div> </div> </form> <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 id="month_list"> <div id ="monthjaytab" style="margin-top:3%" class="grid table-responsive"> <table id="monthlist2"></table> <div id="monthpager2"></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"> function planningtypes(str) { if(str=="today_list") { $('#todays_list').show(); $('#month_list').hide(); } else if(str=="months_list") { $("#monthlist2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#todays_list').hide(); $('#month_list').show(); } } CallGrid(); function CallGrid() { $('#all_list').hide(); jQuery("#list2").jqGrid({ url:"<?php echo site_url('get-all-holiday-details')?>", mtype : "get", datatype: "json", colNames:['id','Name','Holiday Date','Description','Action'], colModel:[ {name:'id',index:'id', width:60, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:70, hidden:false,editable:false}, {name:'holiday_date',index:'holiday_date',editable:false, width:70,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'description',index:'description',editable:false, width:70}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="delete_holiday('+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", loadonce:true, caption:"Holiday Details", //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(); $('.months').empty(); $('.filter_submit').empty(); 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); } }); $('.filter_choice_submit').submit(function(e) { e.preventDefault(); var type = $('input[name=optradio]:checked').val(); if(type == 'month') { load_month_grid(); function load_month_grid() { var month = $(".month").val(); $("#monthlist2").setGridParam( { url:"<?php echo site_url('get-monthwise-holiday-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-holiday-list')?>?month="+month, mtype : "get", datatype: "json", colNames:['id','Name','Holiday Date','Description'], colModel:[ {name:'id',index:'id', width:70, hidden:true,editable:false,key:true}, {name:'name',index:'name', width:70, hidden:false,editable:false}, {name:'holiday_date',index:'holiday_date',editable:false, width:70,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, {name:'description',index:'description',editable:false, width:70}, ], 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:"Monthwise Holiday 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 }, ); } }); function delete_holiday(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(); $.ajax({ type : 'post', url : "<?php echo site_url('delete-holiday');?>", data : {'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'); } 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'); ?>