EVOLUTION-NINJA

Edit File: webportal_form.php

<?php echo view('includes/header');?>

<section class="content-header">
				<h1> Webportals </h1>				
			</section> 
 
			<section class="content">

<button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#myModal">
			  Add Webportals
			</button>
			
			<button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#myModals">
			  Add Database
			</button>

<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
			  <div class="modal-dialog" role="document">
			    <div class="modal-content">
			      <div class="modal-header">
			        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
			        <h4 class="modal-title" id="myModalLabel">Add web portals</h4>
			      </div>
			      <div class="modal-body">
			        <form id="land_owner" class="form-inline webportal_form">
						
						<div class="row land_owner_a">
							<div class="form-group col-sm-12 col-md-8">
								<label class="col-sm-4">Webportal</label>
								<input type="text" class="form-control col-sm-8 webportal" name="webportal" required="required">
							</div>
							
						</div>

<div class="multiple_fields"></div>
						
						<div class="row land_owner_a">
							<div class="col-sm-4 col-md-4"></div>
							<div class="col-sm-4 col-md-4">
								<button type="submit" class="btn btn-primary center-block submit">Submit</button>
							</div>
							<div class="col-sm-4 col-md-4"></div>													
						</div>

</form>
			      </div>
			     
			    </div>
			  </div>
			</div>
			
			
			<div class="modal fade" id="myModals" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
			  <div class="modal-dialog" role="document">
			    <div class="modal-content">
			      <div class="modal-header">
			        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
			        <h4 class="modal-title" id="myModalLabel">Add Database</h4>
			      </div>
			      <div class="modal-body">
			        <form id="land_owner" class="form-inline database_form">
						
						<div class="row land_owner_a">
							<div class="form-group col-sm-12 col-md-8">
								<label class="col-sm-4">Database</label>
								<input type="text" class="form-control col-sm-8 database" name="database" required="required">
							</div>
							
						</div>

</form>
			      </div>
			     
			    </div>
			  </div>
			</div>
					</br></br>
					<div class="row" style="">
						
						<div class="col-md-6">
						 <div id = "jaytab3" style="margin-top:3%;margin-left: 90px;" class="col-sm-10 grid">
			<div class="grid_div"></div><table id="list3"></table>
			  <div id="pager3"></div>
		     <div id="dialogSelectRow3" title="Warning" style="display:none">
			 <p>Please select row</p>
		  </div>
		</div>
						</div>
						
						<div class="col-md-6">

<div id = "jaytab4" style="margin-top:3%;" class="col-sm-10 grid">
			<div class="grid_div"></div><table id="list4"></table>
			  <div id="pager4"></div>
		     <div id="dialogSelectRow4" title="Warning" style="display:none">
			 <p>Please select row</p>
		  </div>
		</div>

</div>									
					</div>
					
				</div> 	 -->			
				<div class="col-sm-0 col-md-1"></div>
			</section>

<div class="modal fade" id="edit_modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel">Update web portal</h4>
      </div>
      <div class="modal-body">
        <form id="land_owner" class="form-inline update_form" enctype="multipart/form-data">
					
			<input type="hidden" class="form-control col-sm-8 portal_id_pk" name="portal_id" required="required">
						
			<div class="row land_owner_a">
				<div class="form-group col-sm-12 col-md-8">
					<label class="col-sm-4">Webportal</label>
					<input type="text" class="form-control col-sm-8 webportal" name="webportal" required="required">
				</div>
			</div> 
			
			<div class="row land_owner_a">
				<div class="col-sm-4 col-md-4"></div>
				<div class="col-sm-4 col-md-4">
					<button type="submit" class="btn btn-primary center-block submit">Update</button>
				</div>
				<div class="col-sm-4 col-md-4"></div>													
			</div>

</form>
      </div>
      
    </div>
  </div>
</div>

<div class="modal fade" id="edit_modals" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel">Update Database</h4>
      </div>
      <div class="modal-body">
        <form id="land_owner" class="form-inline databaseupdate_form" enctype="multipart/form-data">
					
			<input type="hidden" class="form-control col-sm-8 database_id_pk" name="database_id" required="required">
						
			<div class="row land_owner_a">
				<div class="form-group col-sm-12 col-md-8">
					<label class="col-sm-4">Database</label>
					<input type="text" class="form-control col-sm-8 database" name="database" required="required">
				</div>
			</div> 
			
			<div class="row land_owner_a">
				<div class="col-sm-4 col-md-4"></div>
				<div class="col-sm-4 col-md-4">
					<button type="submit" class="btn btn-primary center-block submit">Update</button>
				</div>
				<div class="col-sm-4 col-md-4"></div>													
			</div>

</form>
      </div>
      
    </div>
  </div>
</div>

.content-wrapper, .right-side {			
		//min-height:900px !important;
	}	
	
	a {
	 color: inherit; 
	}
	.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);
				}
				#FrmGrid_list2
				{
					width: 100% !important;
				}
				.ui-jqdialog .ui-jqdialog-titlebar
				{
					height: 29px !important;
					background-color: #001a00;
					color: white;
					padding-left: 10px;
				}
				.fm-button
				{
					height: 21px !important;
					padding: 1px;					
					margin-right: 10px !important;
					height: 21px !important;				    
				    width: 50%;
				    margin-top: -7px !important;
				}
				.ui-jqdialog-content td.navButton {
					padding-top: 12px !important;
				}
				.ui-jqgrid .ui-jqgrid-titlebar
				{
					height: 27px !important;
					background:#AF0100 !important;
					color:white !important;
				}
				.ui-jqgrid-bdiv
				{
					height: 232px !important;
				}
				.ui-widget-overlay
				{
					z-index:0 !important;
				}
				.ui-widget-header
				{
				background: #1e7ad7 !important;
				}
				.ui-jqgrid-hdiv ui-state-default
				{
				width: 873px !important; cursor: default!important
				}
				ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight 
				{
				border: 1px solid #fed22f;
				background: #ffe45c;
			   }
			   .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
			   {
					font-weight: bold;
					color: black;
				}
			.ui-jqgrid .ui-jqgrid-bdiv {
				overflow-y: scroll;
				//overflow-x: hidden;
				}
				
				.agr_appr
				{
				font-weight:bold !important;
				color:#AF0100;
				cursor: pointer; 
				}
				#list4{
				width: 620px!important;
				}
</style>

<script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" />
						
		<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>
		
		<script type="text/javascript">

$(document).ready(function (){

jQuery("#list3").jqGrid({
		
	 	url:"<?php echo site_url('web-portal-list')?>",	 
		 mtype : "post", 	 
		datatype: "json", 
	    colNames:['SI','Web Portal','Edit','Delete'],
		colModel:[
					{name:'portal_id',index:'portal_id', width:50, hidden:true,editable:false,key:true},
					{name:'webportal',index:'webportal', width:180, editable:false},
					 {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:130,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="reg_fun($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' \>";
			}},

{name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:130,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun_delete($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='DELETE'  \>";
			  }},
			 
	      	    ],
	      	  rowNum:20,
		      	rowTotal: 2000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:" Web Portal List",
			
		});

$("#list3").jqGrid("setLabel", "rn", "SL");

$("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list3").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		);

jQuery("#list4").jqGrid({
 			
 		 	url:"<?php echo site_url('database-list')?>",	 
 			 mtype : "post", 	 
 			datatype: "json", 
 		    colNames:['SI','Database Name','Edit','Delete'],
 			colModel:[
 						{name:'database_id',index:'database_id', width:50, hidden:true,editable:false,key:true},
 						{name:'database_name',index:'database_name', width:180, editable:false},
 						 {name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:130,cellattr: function (rowId, tv, rawObject, cm, rdata) 
 							{
 		            	     return ' onclick="reg_fun4($(this))" ';
 		            		},formatter:function (cellvalue, options, rowObject) {    
 							return "<input type='button' value='EDIT' \>";
 				}},

{name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:130,cellattr: function (rowId, tv, rawObject, cm, rdata) 
 							{
 		            	     return ' onclick="fun_delete4($(this))" ';
 		            		},formatter:function (cellvalue, options, rowObject) {    
 							return "<input type='button'  value='DELETE'  \>";
 				  }},
 				 
 		      	    ],
 		      	  rowNum:20,
 			      	rowTotal: 2000,
 			      	rowList : [10,20,30,50,100,500,1000],
 			      	rownumbers: true,
 			      	rownumWidth: 40,
 			      	pager:"#pager4", 
 			      	sortname:'owner_id', 
 			      	viewrecords: true,
 			      	gridview: true,
 			      	autowidth: true,
 			      	sortorder:"asc",
 			      	shrinkToFit: false,
 			      	
 			      	 emptyrecords: 'No records to display',
 			       //  multiselect: true,
 			         // multiboxonly: true,
 			      	loadonce:true,
 					caption:"Database List",
 				
 			});

$("#list4").jqGrid("setLabel", "rn", "SL");

$("#list4").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list4").jqGrid('navGrid','#pager4',
 				{edit:true,add:false,del:false,search:true,refreshstate:"current"},
 				{ },
 		        { },
 		        { }, 
 				{
 			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
 			        closeOnEscape: true, 
 			        	multipleSearch: true, 
 			         	closeAfterSearch: true }
 			);

});

function reg_fun(rowId)
{

var portal_id = rowId.closest('tr').attr('id');
    var app = $("#list3").jqGrid('getRowData',portal_id);
	 
 	$(".portal_id_pk").val(app.portal_id);
 	$(".webportal").val(app.webportal);

$("#edit_modal").modal("show");
}

function fun_delete(rowId)
{
	
  var portal_id = rowId.closest('tr').attr('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();
//           test.attr('disabled', 'disabled');
//           test.text("Deleting...");
              $.ajax({          
                      type   : 'post',
                      url    : '<?php echo site_url("delete-portal")?>',
                      data   : {portal_id:portal_id},

success:function(response) {
                    //   response=jQuery.parseJSON(response);
							console.log(response);

if(response.result == 1) 
                          {
                             toastr["success"](response.message);
                             $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 								location.reload();
                          }
                      }
                  });

} 
                      else {

$(".sweet-alert").hide();
                      $(".sweet-overlay").hide();
                  }

});

}

function reg_fun4(rowId)
{

var database_id = rowId.closest('tr').attr('id');
var app = $("#list4").jqGrid('getRowData',database_id);

$(".database_id_pk").val(app.database_id);
	$(".database").val(app.database_name);

$("#edit_modals").modal("show");
}

function fun_delete4(rowId)
{

var database_id = rowId.closest('tr').attr('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-database")?>',
                    data   : {database_id:database_id},

success:function(response) {
                    // response=jQuery.parseJSON(response);
							console.log(response);

if(response.result == 1) 
                        {
                           toastr["success"](response.message);
                           $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 							location.reload();
                        }
                    }
                });

} 
                    else {

$(".sweet-alert").hide();
                    $(".sweet-overlay").hide();
                }

});

}

</script>
		
				
<script type="text/javascript">

$('.webportal_form').submit(function(e){    
        e.preventDefault();

formdata = new FormData($(this)[0]);

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("add-webportals")?>',
                data   : formdata,
                contentType: false,
                processData: false,
                                          
                  success:function(response){
                //   response=jQuery.parseJSON(response);
                  console.log(response);

if(response.result == 1)
                    {
                    	$("#myModal").modal("hide");
                    	$(".multiple_fields").empty();
                    	$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
	                    toastr["success"](response.message);						$(".webportal").val("");
	                    $('.webportal_form')[0].reset();
	                    $(".submit").text("Submit");    
	                    $(".submit").removeAttr('disabled');                
                    }
                    else if(response.result == 2)
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                    else 
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                   
                }
                
         });
             
     });

$('.update_form').submit(function(e){    
        e.preventDefault();

formdata = new FormData($(this)[0]);

//          	$(".submit").attr('disabled', 'disabled');
//             $(".submit").text("Updating...");

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("update-webportal")?>',
                data   : formdata,
                contentType: false,
                processData: false,
                                          
                  success:function(response){
                //   response=jQuery.parseJSON(response);
                  console.log(response);

if(response.result==1)
                    {
                    	$("#edit_modal").modal("hide");
                    	$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
	                    toastr["success"](response.message);
	                    $('.update_form')[0].reset();
	                    $(".submit").text("Submit");    
	                    $(".submit").removeAttr('disabled');                
                    }
                    else if(response.result==2)
                    {
	                    toastr["error"](response.message);    
	                    $(".submit").text("Submit");
	                    $(".submit").removeAttr('disabled');                    
                    }
                    else 
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                   
                }
                
         });
             
     });

$('.database_form').submit(function(e){    
        e.preventDefault();
//alert();
         formdata = new FormData($(this)[0]);

//          	$(".submit").attr('disabled', 'disabled');
//             $(".submit").text("Submitting...");

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("add-database")?>',
                data   : formdata,
                contentType: false,
                processData: false,
                                          
                  success:function(response){
                //   response=jQuery.parseJSON(response);
                  console.log(response);

if(response.result == 1)
                    {
                    	$("#myModals").modal("hide");
                    	$(".multiple_fields").empty();
                    	$("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
	                    toastr["success"](response.message);	                    $(".database").val("");
	                    $('.webportals_form')[0].reset();
	                    $(".submit").text("Submit");    
	                    $(".submit").removeAttr('disabled');                
                    }
                    else if(response.result == 2)
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                    else 
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                   
                }
                
         });
             
     });

$('.databaseupdate_form').submit(function(e){    
        e.preventDefault();

formdata = new FormData($(this)[0]);

//          	$(".submit").attr('disabled', 'disabled');
//             $(".submit").text("Updating...");

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("update-database")?>',
                data   : formdata,
                contentType: false,
                processData: false,
                                          
                  success:function(response){
                //   response=jQuery.parseJSON(response);
                  console.log(response);

if(response.result==1)
                    {
                    	$("#edit_modals").modal("hide");
                    	$("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
	                    toastr["success"](response.message);
	                    $('.databaseupdate_form')[0].reset();
	                    $(".submit").text("Submit");    
	                    $(".submit").removeAttr('disabled');                
                    }
                    else if(response.result==2)
                    {
	                    toastr["error"](response.message);    
	                    $(".submit").text("Submit");
	                    $(".submit").removeAttr('disabled');                    
                    }
                    else 
                    {
	                    toastr["error"](response.message);                       
		                $(".submit").text("Submit"); 
		                $(".submit").removeAttr('disabled');                      
                    }
                   
                }
                
         });
             
     });

</script>
	
<?php echo view('includes/footer');?>