EVOLUTION-NINJA
Edit File: annexure_master.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" href="<?php echo base_url('assets/css/jquery-ui.css');?>" /> <script src="<?php echo base_url('assets/js/jquery-ui.js');?>"></script> <script src="<?php echo base_url('assets/ckeditor/ckeditor.js');?>"></script> <script src="<?php echo base_url('assets/ckeditor/config.js');?>"></script> <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="#">Accounts</a></li> <li class="breadcrumb-item"><a href="#">Masters</a></li> <li class="breadcrumb-item"><a href="#">Civil</a></li> <li class="breadcrumb-item"> Annexure </li> </ol> </div> </div> </div> </div> <div class="row"> <div class="col-sm-12" style="margin-bottom: 20px;"> <button class="add_annexure btn btn-primary">Add Annexure Details</button> <button class="btn btn-primary" data-toggle="modal" data-target="#impsite">Upload</button> </div> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <!-- <button class="add_annexure btn btn-primary">Add Annexure Details</button> <div class="col-sm-6"> <div style="margin-left: 185px;margin-top: -39px;"> <button type="button" class="btn btn-primary" data-toggle="modal" data-target="#impsite">Upload</button> </div> </div>--> <div class="col-sm-1"></div> <div class="col-sm-10"> <div id="jaytab3" style="margin-top:6%;" > <div class="grid_div"></div> <table id="list2"> </table> <div id="pager3"></div> <div id="dialogSelectRow3" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div class="col-sm-5"></div> </div> </div> <!-- /.row --> </div> <!-- /.content-wrapper --> </div> </div> <div class="modal fade" id="impsite" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true"> <div class="modal-dialog modal-md" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="ModalLabel">Upload Annexure Details</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <form class="forms-sample import_data" enctype="multipart/form-data"> <div class="modal-body"> <div class="form-group"> <input type="file" name="annexure_data" class="form-control"> </div> </div> <div class="modal-footer"> <button type="submit" class="btn btn-primary submit1">Upload</button> <button type="button" class="btn btn-light" data-dismiss="modal">Close</button> </div> </form> </div> </div> </div> <div class="modal fade" id="add_modal" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="ModalLabel">Annexure Details</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <form class="forms-sample" id="add_annexure"> <div class="row"> <div class="col-sm-12"> <div class="form-group" > <label for="exampleInputUsername1">Foundation Level</label> <textarea class="form-control ckeditor foundation_level" id="content" name="foundation_level" required ></textarea> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group" > <label for="exampleInputUsername1">Type Of Work</label> <input type="text" class="form-control type_of_work" name="type_of_work" required > </div> </div> <div class="col-sm-4"> <div class="form-group" > <label for="exampleInputUsername1">Unit/Quantity</label> <input type="text" class="form-control unit_quantity" name="unit_quantity" required > </div> </div> <!-- <div class="col-sm-4"> <div class="form-group" > <label for="exampleInputUsername1">GST</label> <input type="text" class="form-control gst" name="gst" required > </div> </div>--> </div> <!-- <div class="row"> <div class="col-sm-6"> <div class="form-group" > <label for="exampleInputUsername1">Type Of Work</label> <input type="text" class="form-control type_of_work" name="type_of_work" required > </div> <div class="form-group" > <label for="exampleInputUsername1">Unit/Quantity</label> <input type="text" class="form-control unit_quantity" name="unit_quantity" required > </div> <div class="form-group" > <label for="exampleInputUsername1">GST</label> <input type="text" class="form-control gst" name="gst" required > </div> </div> <div class="col-sm-6"> <div class="form-group" > <label for="exampleInputUsername1">Foundation Level</label> <textarea class="ckeditor foundation_level" id="content" name="foundation_level" required ></textarea> </div> </div> </div> --> <!-- <div class="row"> <div class="col-sm-6"> <div class="form-group" > <label for="exampleInputUsername1">Unit/Quantity</label> <input type="text" class="form-control unit_quantity" name="unit_quantity" required > </div> </div> <div class="col-sm-6"> <div class="form-group" > <label for="exampleInputUsername1">GST</label> <input type="text" class="form-control gst" name="gst" required > </div> </div> </div> --> <div class="modal-footer"> <button type="submit" class="btn btn-primary submit">Submit</button> <button type="button" class="btn btn-light" data-dismiss="modal">Close</button> </div> </form> </div> </div> </div> </div> <style type="text/css"> pre { background-color: transparent; border: 1px solid transparent; line-height: 1.6; text-align: justify; } .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); } .cke_toolbar_break { display: block; clear: initial; } </style> <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> <script type="text/javascript"> $('.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('annexure-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"); $("#impsite").modal("hide"); toastr["success"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } else { $('.import_data')[0].reset(); toastr["error"](response.message); $(".submit1").text("Upload"); $(".submit1").removeAttr('disabled'); } } }); }); $('.add_annexure').click(function() { $('#add_modal').modal('show'); }) $('#add_annexure').submit(function(e){ e.preventDefault(); for ( instance in CKEDITOR.instances ) CKEDITOR.instances[instance].updateElement(); 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("add-annexure-details")?>', data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('#add_annexure')[0].reset(); /*for ( instance in CKEDITOR.instances ) { CKEDITOR.instances[instance].updateElement(); CKEDITOR.instances[instance].setData(''); }*/ $(".submit").text("Submit"); toastr["success"](response.message); location.reload(); } else { toastr["error"](response.message); $(".submit").text("Submit"); $(".submit").removeAttr('disabled'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); }); CallGrid(); function CallGrid() { jQuery("#list2").jqGrid({ url:"<?php echo site_url('get-annexure-master')?>", mtype : "get", datatype: "json", colNames:['ID','Type Of Work','Foundation Level','Unit/Quantity','Action'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false}, {name:'type_of_work',index:'type_of_work', width:150, hidden:false,editable:false}, {name:'foundation_level',index:'foundation_level', width:300, hidden:false,editrules:{},editable:false}, {name:'unit_quantity',index:'unit_quantity', width:150, hidden:false,editable:false}, //{name:'gst',index:'gst',editable:false, width:80}, {name:'',index:'',search:false,align:'center',width:80,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = '<a data-toggle="tooltip" title="Edit" class="" href="javascript:void(0);"><span class="fa fa-pencil" onclick="fun_edit($(this))" style="color:blue;"></span></a><a data-toggle="tooltip" title="Delete" onclick="fun_delete($(this))"; href="javascript:void(0);"><span class="fa fa-trash" style="color:red;"></span></a>'; return retVal; }}, ], rowNum:20, rowTotal: 2000, rowList : [20,30], rownumbers: true, //rownumWidth: 60, pager:"#pager2", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, loadonce:true, autoencode: true, caption:"Annexure 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 fun_edit(rowId) { var id = rowId.closest('tr').attr('id'); window.location.href = '<?php echo site_url('Edit-annexure-details');?>/'+id; } /*function fun_edit(rowId) { var id = rowId.closest('tr').attr('id'); $.ajax({ url:"<?php echo site_url("Edit-annexure-details")?>", type:"POST", data:{id:id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { alert(response.message.foundation_level); $("#edit_modal").modal("show"); $(".up_id").val(response.message.id); $(".edit_type_of_work").val(response.message.type_of_work); //$(".edit_foundation_level").val(CKEDITOR.instances.foundation_level.setData(response.message.foundation_level)); //$(".edit_foundation_level").val(CKEDITOR.instances[foundation_level].setData(response.message.foundation_level)); //$(".edit_foundation_level").val(response.message.foundation_level); $(".edit_unit_quantity").val(response.message.unit_quantity); $(".edit_gst").val(response.message.gst); //$(".edit_foundation_level").val(response.message.foundation_level); $("#edit_foundation_level").val(CKEDITOR.instances[instance].setData(response.message.foundation_level)); /*CKEDITOR.instances['instance'].on('change',function(){ CKEDITOR.instances['instance'].updateElement(); });*/ /*} else { toastr["error"](response.message); } } }); }*/ /*$('.update_form').submit(function(e){ e.preventDefault(); for ( instance in CKEDITOR.instances ) CKEDITOR.instances[instance].updateElement(); $(".update").attr('disabled', 'disabled'); $(".update").text("Updating..."); formdata = new FormData($(this)[0]); $.ajax({ type : 'post', url : '<?php echo site_url('update-annexure-details');?>', data : formdata, contentType: false, processData: false, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.update_form')[0].reset(); for ( instance in CKEDITOR.instances ) { CKEDITOR.instances[instance].updateElement(); CKEDITOR.instances[instance].setData(''); } $(".update").text("Update"); $("#edit_modal").modal("hide"); toastr["success"](response.message); location.reload(); } else { toastr["error"](response.message); $(".update").text("Update"); $(".update").removeAttr('disabled'); } } }); });*/ function fun_delete(rowId) { var id = rowId.closest('tr').attr('id'); var 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(); $.ajax({ url:"<?php echo site_url("delete-annexure-details")?>", type:"POST", data:{id:id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } </script> <?php $this->load->view('includes/footer'); ?> <style type="text/css"> .regis-block{ padding: 15px; background: #fff; } .regist-button{ text-align: center; padding-top: 20px; } .form_submit label{ padding-top: 20px; } </style>