EVOLUTION-NINJA
Edit File: abp_view_old.php
<?php $this->load->view('includes/admin_dashboard_header');?> <div id="wrapper"> <!-- Navigation --> <?php $this->load->view('includes/admin_menu');?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="row"> <div class="col-lg-12"> <!-- <h1 class="page-header"> Dashboard <small>Statistics Overview</small> </h1> <ol class="breadcrumb"> <li class="active"> <i class="fa fa-user" aria-hidden="true"></i> Manage Users </li> </ol>--> </div> </div> <!-- /.row --> <!--<div class="row"> --> <section class="admin_heading"> <div class="col-sm-12"> <h3>ABP</h3> </div> <div class="col-sm-12"> <input type="submit" id="less" value="View" onclick="show();" style=""/> <input type="submit" id="more" value="View" onclick="hide();" style=""/> <input type="hidden" id="demo"/> </div> <div class="col-sm-12"> <div id = "jaytab" style="width: 100%; margin-top:1%;overflow-x: scroll;" > <p>Last Updated Date and Time is : <?php if(empty($time)) { echo "Data not found"; }else{ echo $time->createdate; } ?></p> <table id="list2"></table> <div id="pager2"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> <input type="hidden" id="demo"/> <input type="hidden" id="demo1"/> <input type="hidden" id="demo2"/> </div> </section> <?php $ci =& get_instance(); $base_url = base_url(); ?> <!-- /.row end--> <!--</div>--> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> </div> <?php $this->load->view('includes/admin_dashboard_footer');?> <style> @media only screen and (min-width:320px) and (max-width:641px){ .ui-jqgrid { margin-left: 1px !important; } #sData span, #cData span { margin-left: 0 !important; } } @media only screen and (min-width:641px) and (max-width:991px){ .ui-jqgrid { margin-left: 1px !important; } #jaytab{ margin-top: 0 !important; margin-left: 0 !important; overflow-x: scroll; width: 100% !important; padding-left:0 !important; padding-right:9px !important; } } #sData span, #cData span { margin-left: 3px; } #sData { height: 29px; } #cData { height: 29px; } .jqgfirstrow { height: 0px !important; } .text_color a{ color:white !important; </style> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.js'); ?>"></script> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script> $('#more').hide(); </script> <script> $("#less").click(function() { $("#more").show(); $("#less").hide(); }); </script> <script> $("#more").click(function() { $("#less").show(); $("#more").hide(); }); </script> <script> $(document).ready(function (){ jQuery("#list2").jqGrid({ url:"<?php echo site_url('controller/abp_view_insert');?>", mtype : "post", datatype: "json", colNames:['Id','Uid','Role','Region','Company Name','Address','City','State','State Code','Pin','Landline','Mobile','Alt Mobile','Email','Alt Email','Password','Pan','GSTIN','Tin','Software Access'], //JQuery("#list2").hideCol("Id"); colModel:[ {name:'id',index:'id', width:50, align:'center',key:true,editable:true,hidden:true, editrules: {edithidden:false} }, {name:'uid', index:'uid', align:'center',editable:true, width:50,hidden:true,editrules : {edithidden:true}}, {name:'role', index:'role', width:80, align:'center', sortable:false,editable:true,hidden:true,formatter: 'select',editrules:{edithidden:true},edittype:'select',editoptions:{value:{<?php foreach($abp_role as $rol){?> <?php echo $rol->id;?> :'<?php echo $rol->role;?>',<?php } ?>}}}, {name:'region', index:'region', width:50, align:'center', sortable:false,editable:true,formatter: 'select', edittype:'select',editoptions:{value:{<?php foreach($region as $reg){ ?> <?php echo $reg->id;?>:'<?php echo $reg->region;?>',<?php } ?>} } }, {name:'company_name', index:'company_name', width:230, align:'center',editable:true,edittype:'text'}, {name:'address', index:'address', width:200, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'city', index:'city', width:120, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'state', index:'state', width:120, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'state_code', index:'state_code', width:70, align:'center', sortable:false,editable:true}, {name:'pin', index:'pin', width:50, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'landline', index:'landline', width:80, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'mobile', index:'mobile', width:70, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'alt_mobile', index:'alt_mobile', width:80, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'email', index:'email', width:100, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'alt_email', index:'alt_email', width:80, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'password', index:'password', width:80, align:'center', sortable:false,editable:true,edittype:'password'}, {name:'pan', index:'pan', width:80, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'gstin', index:'gstin', width:50, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'tin', index:'tin', width:80, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'software_status', index:'software_status', width:80, align:'center', sortable:false,editable:true,edittype:'text',formatter:function (cellvalue, options, rowObject) { var retcheck = ""; if(cellvalue == "YES") { var retcheck = '<input type="checkbox" value="YES" test="YES" class="check" onclick="somefunction($(this))" checked>'; } else { var retcheck = '<input type="checkbox" value="NO" test="NO" class="check" onclick="somefunction($(this))">'; } return retcheck; }}, ], rowNum:10, rowTotal: 2000, rowList : [10,20,30], rownumbers: true, rownumWidth: 40, pager:"#pager2", sortname:'id', viewrecords: true, loadonce:true, gridview: true, autowidth: true, sortorder:"asc", caption:"ABP" }); $("#list2").jqGrid('filterToolbar',{searchOperators : false});//for multisearch code,remove if not required $("#list2").jqGrid('navGrid','#pager2', {edit:false,add:false,del:false,search:true,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, multipleGroup:true, caption:"search" } ); $('#pager2').css("height", "auto"); $("#list2").navButtonAdd('#pager2', { caption:"Add", buttonicon:"ui-icon-plus", onClickButton: addRow, position: "last", title:"", cursor:"pointer", id:"client_add" } ); $("#list2").navButtonAdd('#pager2', { caption:"Edit", buttonicon:"ui-icon-pencil", onClickButton: editRow, position: "last", title:"", cursor: "pointer", id:"client_edit" } ); $("#list2").navButtonAdd('#pager2', { caption:"Delete", buttonicon:"ui-icon-trash", onClickButton: deleteRow, position: "last", title:"", cursor: "pointer", id:"client_delete" } ); }); function somefunction(rowId) { var idd = rowId.closest('.check'); //alert(idd); var id = rowId.closest('tr').attr('id'); if($(idd). prop("checked") == true){ var access_status = "YES"; } else { var access_status = "NO"; } $.ajax({ url:"<?php echo site_url('controller/update_access_status');?>", type:"POST", data:{'id':id,'access_status':access_status}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); alert(response.message); } else { alert(response.message); } } }); } function show () { // // Position of the name column var colPos = 0; var navGrid = $('#list2'); // navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 1].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 2].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 3].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 6].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 12].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 14].name); navGrid.jqGrid('showCol', navGrid.getGridParam("colModel")[colPos + 17].name); } function hide() { var colPos = 0; var navGrid = $('#list2'); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 1].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 2].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 3].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 6].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 12].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 14].name); navGrid.jqGrid('hideCol', navGrid.getGridParam("colModel")[colPos + 17].name); } function addRow() { // Get the currently selected row $("#list2").jqGrid('editGridRow','new', { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var uid = $("#uid").val(); var role = $("#role").val(); var region = $("#region").val(); var company_name = $("#company_name").val(); var address = $("#address").val(); var city = $("#city").val(); var state = $("#state").val(); var state_code = $("#state_code").val(); var pin = $("#pin").val(); var landline = $("#landline").val(); var mobile = $("#mobile").val(); var alt_mobile = $("#alt_mobile").val(); var email = $("#email").val(); var alt_email = $("#alt_email").val(); var password = $("#password").val(); var pan = $("#pan").val(); var gstin = $("#gstin").val(); var tin = $("#tin").val(); var attachments = $("#attachments").val(); alert("sending Email to "+email) var myAge = prompt("Enter the Cc to :","") alert("you are sending Cc to:"+ myAge) if (myAge!=null) { x=myAge; document.getElementById("demo1").value=x; } var cc=$("#demo1").val(); $.ajax({ url:"<?php echo site_url('controller/abp_view_add');?>", type:"POST", data:{'uid':uid,'role':role,'region':region,'company_name':company_name,'address':address,'city':city,'state':state,'state_code':state_code,'pin':pin,'landline':landline,'mobile':mobile,'alt_mobile':alt_mobile,'email':email,'alt_email':alt_email,'password':password,'pan':pan,'gstin':gstin,'tin':tin,'attachments':attachments,'cc':cc}, async:false, success:function(data){ alert('Successfully Added.'); $("#editmodlist2").remove(); window.location.reload(); } }); }, closeAfterAdd: true, reloadAfterSubmit:false, closeOnEscape:true, clearAfterAdd: true, afterSubmit :false }); } function deleteRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); var email= $("#email").val(row); if( row != null ) $("#list2").jqGrid('delGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ alert("sending Email to "+email) var myAge = prompt("Enter the Cc to :","") alert("you are sending Cc to:"+ myAge) if (myAge!=null) { x=myAge; document.getElementById("demo2").value=x; } var cc=$("#demo2").val(); $.ajax({ url:"<?php echo site_url('controller/abp_view_delete');?>", type:"POST", data:{'id':row,'cc':cc}, async:false, success:function(data){ if(data==""){ alert('Successfully Deleted.'); } else{ alert('Successfully Deleted.'); $("#delmodlist2").remove(); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } function editRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); if( row != null ) $("#list2").jqGrid('editGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var id = $("#id").val(); var uid = $("#uid").val(); var role = $("#role").val(); var region = $("#region").val(); var company_name = $("#company_name").val(); var address = $("#address").val(); var city = $("#city").val(); var state = $("#state").val(); var state_code = $("#state_code").val(); var pin = $("#pin").val(); var landline = $("#landline").val(); var mobile = $("#mobile").val(); var alt_mobile = $("#alt_mobile").val(); var email = $("#email").val(); var alt_email = $("#alt_email").val(); var password = $("#password").val(); var pan = $("#pan").val(); var gstin = $("#gstin").val(); var tin = $("#tin").val(); var attachments = $("#attachments").val(); alert("sending Email to"+email) var myAge = prompt("Enter the Cc to:","") alert("you are sending Cc to:"+ myAge) if (myAge!=null) { x=myAge; document.getElementById("demo").value=x; } var cc=$("#demo").val(); $.ajax({ url:"<?php echo site_url('controller/abp_view_edit');?>", type:"POST", data:{'id':id,'uid':uid,'role':role,'region':region,'company_name':company_name,'address':address,'city':city,'state':state,'state_code':state_code,'pin':pin,'landline':landline,'mobile':mobile,'alt_mobile':alt_mobile,'email':email,'alt_email':alt_email,'password':password,'pan':pan,'gstin':gstin,'tin':tin,'attachments':attachments,'cc':cc}, async:false, success:function(data){ if(data==""){ alert('Successfully .'); } else{ alert('Successfully Updated.'); $("#editmodlist10").remove(); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } </script> <!-- Bootstrap Core JavaScript --> <script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/raphael.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris-data.js');?>"></script>