EVOLUTION-NINJA
Edit File: supervisor_view.php
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>Yaskawa</title> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.css'); ?>" /> <!-- Bootstrap Core CSS --> <link href="<?php echo base_url('admin_assets/css/bootstrap.min.css');?>" rel="stylesheet"> <!-- Custom CSS --> <link href="<?php echo base_url('admin_assets/css/sb-admin.css');?>" rel="stylesheet"> <!-- Morris Charts CSS --> <link href="<?php echo base_url('admin_assets/css/plugins/morris.css');?>" rel="stylesheet"> <!-- Custom Fonts --> <link href="<?php echo base_url('admin_assets/font-awesome/css/font-awesome.min.css');?>" rel="stylesheet" type="text/css"> <script type="text/javascript" src="<?php echo base_url('assets/js/jquery-2.2.4.min.js');?>"></script> <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> <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 src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <style> .right { text-transform: uppercase; font-family:Roboto; font-weight:bold; color:#00a859; } </style> <style type="text/css"> .form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus { border-color: #FF0000; box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6); } #editmodlist2 { //height: 232px !important; width: 326px !important; } #FrmGrid_list2 { width: 100% !important; } .ui-jqdialog .ui-jqdialog-titlebar { height: 29px !important; background-color:#2A4474 !important; color: white; padding-left: 10px; } .fm-button { height: 21px !important; padding: 1px; margin-right: 10px !important; height: 21px !important; width: 43%; margin-top: -7px !important; } .ui-jqdialog-content td.navButton { padding-top: 12px !important; } .ui-jqgrid .ui-jqgrid-titlebar { height: 27px !important; background-color: #2A4474!important; color:white !important; } .ui-jqgrid-bdiv { height: 232px !important; } .ui-widget-overlay { z-index:0 !important; } </style> </head> <body> <div id="wrapper"> <!-- Navigation --> <nav class="navbar navbar-inverse navbar-fixed-top menu-a" role="navigation"> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand my_logo" href="<?php echo site_url('controller/product');?>"><img class="img-responsive" src="<?php echo base_url('admin_assets/img/yaskawa_logo2.png');?>"></a> </div> <!-- Top Menu Items --> <ul class="nav navbar-right top-nav"> <li class="dropdown"> <a href="<?php echo site_url('controller/admin');?>" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> Admin</a> <!-- <ul class="dropdown-menu" style="background-color: black"> <li> <a href="#"><i class="fa fa-fw fa-user"></i> Profile</a> </li> <li> <a href="#"><i class="fa fa-fw fa-gear"></i> Settings</a> </li> <li class="divider"></li> </ul> --> <li> <a href="<?php echo site_url('controller/logout');?>"><i class="fa fa-fw fa-power-off"></i> Log Out</a> </li> </li> </ul> <!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens --> <div class="collapse navbar-collapse navbar-ex1-collapse"> <ul class="nav navbar-nav side-nav my-nav"> <!-- <li class="active"> <a href="index.html"><i class="fa fa-fw fa-dashboard"></i> Dashboard</a> </li> --> <li class="active"> <a href="javascript:;" data-toggle="collapse" data-target="#demo1"> Manage Users <i class="fa fa-fw fa-caret-down"></i></a> <ul id="demo1" class="collapse"> <li> <a href="<?php echo site_url('controller/supervisor_view');?>">Supervisor</a> </li> <li> <a href="<?php echo site_url('controller/abp_view');?>">ABP</a> </li> <li> <a href="<?php echo site_url('controller/region_view');?>">Regional Manager</a> </li> </ul> </li> <li> <a href="javascript:;" data-toggle="collapse" data-target="#demo2"> Information <i class="fa fa-fw fa-caret-down"></i></a> <ul id="demo2" class="collapse"> <li> <a href="<?php echo site_url('controller/stock_updates_view');?>">Stock Updates</a> </li> <li> <a href="<?php echo site_url('controller/po_view');?>">PO Acknowledgemets</a> </li> </ul> </li> <li> <a href="javascript:;" data-toggle="collapse" data-target="#demo3"> Financials<i class="fa fa-fw fa-caret-down"></i></a> <ul id="demo3" class="collapse"> <li> <a href="<?php echo site_url('controller/outstanding_view');?>">Outstanding Statement</a> </li> <li> <a href="<?php echo site_url('controller/overdue_view');?>">Overdue Statement</a> </li> <li> <a href="<?php echo site_url('controller/cform_view');?>">C forms</a> </li> </ul> </li> <li> <a href="javascript:;" data-toggle="collapse" data-target="#demo4"> Technical Support<i class="fa fa-fw fa-caret-down"></i></a> <ul id="demo4" class="collapse"> <li> <a href="<?php echo site_url('controller/drive_catalogues_view');?>">Drive Catalogues</a> </li> <li> <a href="<?php echo site_url('controller/case_stories_view');?>">Case Stories</a> </li> </ul> </li> <li> <a href="<?php echo site_url('controller/news_view');?>">News</a> </li> <li class="divider"></li> <li> <a href="<?php echo site_url('controller/product');?>">Add Product and Category</a> </li> <li class="divider"></li> <li> <a href="<?php echo site_url('controller/add_product');?>">Add New Product</a> </li> <li class="divider"></li> <li> <a href="<?php echo site_url('controller/product_list');?>">Product List</a> </li> <li class="divider"></li> </ul> </div> <!-- /.navbar-collapse --> </nav> <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="row"> <div class="col-sm-8"> <h1 style="margin-left: 15%;"> Supervisor </h1> </div> <div class="col-sm-2"></div> </section> <div class="row"> <div class="col-sm-12"> <div id = "jaytab" style="width: 1000px; margin-top:3%;margin-left:5%;"> <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> <div class="row" style="padding-bottom:20px;"></div> </div> </div> </div> <input type="hidden" id="demo"/> <input type="hidden" id="demo1"/> <input type="hidden" id="demo2"/> <?php $ci =& get_instance(); $base_url = base_url(); ?> <!-- /.row end--> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> <!-- /#wrapper --> <!-- jQuery <script src="<?php echo base_url('admin_assets/js/jquery.js');?>"></script> <!-- Bootstrap Core JavaScript <script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script> <!-- Morris Charts JavaScript <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>--> </body> </html> <script> $(document).ready(function (){ jQuery("#list2").jqGrid({ url:"<?php echo site_url('controller/supervisor_view_insert');?>", mtype : "post", datatype: "json", colNames:['Id','usercode','Region','Username','Email','Password','Phone','Department','Role'], colModel:[ {name:'id',index:'id', width:100, align:'center',key:true,hidden:true,editable:true}, {name:'usercode', index:'usercode', align:'center',editable:true, width:100}, {name:'region', index:'region', width:100, align:'center', sortable:false,formatter: 'select',editable:true, edittype:'select',editoptions:{value:{<?php foreach($region as $reg) {?> <?php echo $reg->id ; ?> :'<?php echo $reg->region;?>',<?php } ?>} } }, {name:'username', index:'username', width:150, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'email', index:'email', width:200, align:'center',editable:true,edittype:'text'}, {name:'password', index:'password', width:100, align:'center', sortable:false,editable:true,edittype:'password'}, {name:'phone', index:'phone', width:120, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'department', index:'department', width:140, align:'center', sortable:false,editable:true, edittype:'select',formatter: 'select',editoptions:{value:{<?php foreach($supervisor as $sup){ ?> <?php echo $sup->id ; ?> :'<?php echo $sup->role;?>',<?php } ?>} } }, {name:'role', index:'role', width:100, align:'center', sortable:false,formatter: 'select',editable:true,edittype:'select',editoptions:{value:{<?php foreach($role as $rol){ ?> <?php echo $rol->id;?>:'<?php echo $rol->role;?>',<?php } ?>} } } ], rowNum:50, rowTotal: 2000, rowList : [50,100,200], rownumbers: true, rownumWidth: 40, pager:"#pager2", sortname:'id', viewrecords: true, loadonce:true, gridview: true, autowidth: true, sortorder:"asc", //multiple: true, caption:"supervisor" }); $("#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 addRow() { // Get the currently selected row $("#list2").jqGrid('editGridRow','new', { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var usercode = $("#usercode").val(); var region = $("#region").val(); var username = $("#username").val(); var email = $("#email").val(); var password = $("#password").val(); var phone = $("#phone").val(); var department = $("#department").val(); var role = $("#role").val(); var image = $("#image").val(); var createdate = $("#createdate").val(); var status = $("#status").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/supervisor_view_add');?>", type:"POST", data:{'usercode':usercode,'region':region,'username':username,'email':email,'password':password,'phone':phone,'department':department,'role':role,'image':image,'createdate':createdate,'status':status,'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/supervisor_view_delete');?>", type:"POST", data:{'id':row,'cc':cc}, async:false, success:function(data){ if(data==""){ alert(''); } 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 usercode = $("#usercode").val(); var region = $("#region").val(); var username = $("#username").val(); var email = $("#email").val(); var password = $("#password").val(); var phone = $("#phone").val(); var department = $("#department").val(); var role = $("#role").val(); var image = $("#image").val(); var createdate = $("#createdate").val(); var status = $("#status").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/supervisor_view_edit');?>", type:"POST", data:{'id':id,'usercode':usercode,'region':region,'username':username,'email':email,'password':password,'phone':phone,'department':department,'role':role,'image':image,'createdate':createdate,'status':status,'cc':cc}, async:false, success:function(data){ if(data==""){ alert('Successfully .'); } else{ alert('Successfully Updated'); $("#editmodlist2").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>