EVOLUTION-NINJA

Edit File: layouts_list.php

<?php $this->load->view('includes/header.php')?>

<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="#">General</a></li>
          <li class="breadcrumb-item">Add layouts </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>
   <div class="row">

<button type='button' class="btn btn-primary add_layout">Add New Layout</button>

</div>

<br/>

<input type="radio" checked="checked" class="form-check-input" id="todays" name="optradio" value="todays" onclick="planningtypes('layout')">Layout List

</label>

</div>

<input type="radio" class="form-check-input" id="date" name="optradio" value="date" onclick="planningtypes('approved_layout')">Approved Layout list

</label>

</div>

<p>Please select row</p>

</div>

<p>Please select row</p>

</div>

pre {

background-color: transparent;

border: 1px solid transparent;

line-height: 1.6;

text-align: justify;

}

#pager2_left

{

display: none !important;

}

#pager2_center

{

padding-left: 350px !important;

}

.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: 43%;

margin-top: -7px !important;

}

.ui-jqdialog-content td.navButton {

padding-top: 12px !important;

}

.ui-jqgrid .ui-jqgrid-titlebar

{

height: 27px !important;

/*background:#1e7ad7 !important;*/

color:white !important;

}

.ui-jqgrid-bdiv

{

height: auto !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: scroll ;

//width: 100% !important;

}

.ui-jqgrid-htable{

//width: 100% !important;

}

#list2{

//width: 100% !important;

}

.ui-jqgrid-hdiv {

//width: 100% !important;

}

@media only screen and (min-width:320px) and (max-width:640px)

{

#jaytab {

width: 1100px !important;

overflow-x: scroll !important;

}

.ui-jqgrid ui-widget ui-widget-content ui-corner-all {

//width: 900px !important;

}

.ui-jqgrid-view  {

//width: 900px !important;

}

.ui-jqgrid-hdiv {

//width: 900px !important;

}

.ui-jqgrid-htable {

width: 900px !important;

}

.ui-jqgrid-bdiv {

width: 900px !important;

}

#list2 {

width: 900px !important;

}

#pager2 {

width: 900px !important;

}

.subgrid-data {

width: 1100px !important;

overflow-x: scroll !important;

}

.table-responsive {

border: transparent;

}

.ui-jqgrid {

background-color: #ecf0f5;

border: 1px solid #ecf0f5 !important;

border-radius: 0px !important;

}

#myTable {

overflow-x: scroll;

width: 1200px;

}

@media only screen and (min-width:641px) and (max-width:991px)

{

#jaytab {

width: 1100px !important;

overflow-x: scroll !important;

}

.ui-jqgrid ui-widget ui-widget-content ui-corner-all {

//width: 900px !important;

}

.ui-jqgrid-view  {

width: 900px !important;

}

.ui-jqgrid-hdiv {

width: 900px !important;

}

.ui-jqgrid-htable {

width: 900px !important;

}

.ui-jqgrid-bdiv {

width: 900px !important;

}

#list2 {

width: 900px !important;

}

#pager2 {

width: 900px !important;

}

.subgrid-data {

width: 1100px !important;

overflow-x: scroll !important;

}

.table-responsive {

border: transparent;

}

.ui-jqgrid {

background-color: #ecf0f5;

border: 1px solid #ecf0f5 !important;

border-radius: 0px !important;

}

@media only screen and (min-width:320px) and (max-width:640px)

{

#jaytab {

width: 280px !important;

overflow-x: scroll !important;

}

@media only screen and (min-width:641px) and (max-width:991px)

{

#jaytab {

width: 680px !important;

overflow-x: scroll !important;

}

.table-bordered>thead>tr>th, .table-bordered>tbody>tr>td, .table-bordered>tbody>tr>th {

border: 1px solid #555;

}

.table>thead:first-child>tr:first-child>th {

border-top: 1px solid #555;

}

table.table-bordered th:last-child, table.table-bordered td:last-child {

border-right: 1px solid #555;

}

</style>

function planningtypes(str)

{

if(str=="layout")

{

$('#layout').show();

$('#approved_layout').hide();

}

else if(str=="approved_layout")

{

$("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');

$('#layout').hide();

$('#approved_layout').show();

}

jQuery("#list2").jqGrid({

url:"<?php echo site_url('get-layout-list')?>",

mtype : "get",

datatype: "json",

colNames:['id','Layout Name','Layout Address','Sub-Register Address','Agent','Land Owner','Layout image','Layout Status','Action'],

colModel:[

{name:'id',index:'id', width:40, hidden:true,editable:false},

{name:'layout_name',index:'layout_name', width:150, hidden:false,editable:false},

{name:'layout_address',index:'layout_address', width:300, hidden:false,editable:false},

{name:'sub_register_address',index:'sub_register_address', width:240, hidden:false,editable:false},

{name:'first_name',index:'first_name',editable:false, width:100},

//{name:'sites',index:'sites',editable:false, width:100},

{name:'name',index:'name',editable:false, width:100},

{name:'',index:'',search:false,editable:false,editrules:{}, width:70,

formatter: function (cellvalue, options, rowObject) {

var retVal = '';

if(rowObject.upload_layout != '')

{

var ext = rowObject.upload_layout.split('.').pop();

if(ext=="png" || ext=="jpg" || ext=="jpeg")

{

retVal +='<a href="<?php echo base_url('assets/images/');?>/'+rowObject.upload_layout+'"  target="_blank" ><img width="30px" height="30px" src="<?php echo base_url('assets/images/');?>/'+rowObject.upload_layout+'" class="profile-pic"/></a>';

}

else if(ext=="pdf")

{

retVal +='<a href="<?php echo base_url('assets/images/');?>/'+rowObject.upload_layout+'"  target="_blank" ><iframe width="30px" height="30px" src="<?php echo base_url('assets/images/');?>/'+rowObject.upload_layout+'" class="profile-pic"></iframe></a>';

//$('.layout_image').html('<iframe src="<?php echo base_url('layout_uploads/');?>'+response.message.upload_layout+'" height="315px" width="100%"></iframe>');

}

else

{

retVal +='';

}

return retVal;

}},

/*{name:'layout_status',index:'layout_status',editable:false, width:100},

{name:'',index:'',width:80,align:"center",search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
	                	var retVal = "";
	                	var retVal1 = "";
	                		var retVal = '<b><a href="javascript:void(0);" onclick="fun_edit('+rowObject.id+');"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>&nbsp;<a onclick="delete_layout('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a></b>';

var retVal1 = '<b><a href="javascript:void(0);" onclick="fun_edit_inactive('+rowObject.id+');"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>&nbsp;<a onclick="delete_layout_inactive('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a></b>';

if(rowObject.layout_status == 'ACTIVE')
			                    {
			                      return retVal;
			                    }
			                    else
			                    {
			                      return retVal1;
			                    }
	                		
	            }},*/
    {name:'layout_status',index:'layout_status',editable:false, width:100},

{name:'',index:'',width:80,align:"center",search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
	                	var retVal = "";
	                	var retVal = '<b><a href="javascript:void(0);" onclick="fun_edit('+rowObject.id+');"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>&nbsp;<a onclick="delete_layout('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a></b>';
                        return retVal;
			                  
	            }},

rowNum:50,

rowTotal: 2000,

rowList : [100,200,500,1000,2000],

rownumbers: true,

//rownumWidth: 60,

pager:"#pager2",

sortname:'id',

viewrecords: true,

gridview: true,

autowidth: true,

sortorder:"asc",

shrinkToFit: true,

loadonce:true,

autoencode: true,

caption:"Layouts 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

);

jQuery("#list4").jqGrid({

url:"<?php echo site_url('get-approved-layout-list')?>",

mtype : "get",

datatype: "json",

colNames:['id','Layout Name','Layout Address','Sub-Register Address','Agent','Land Owner','Layout image','Approval','Action'],

colModel:[

{name:'id',index:'id', width:40, hidden:true,editable:false},

{name:'layout_name',index:'layout_name', width:200, hidden:false,editable:false},

{name:'layout_address',index:'layout_address', width:300, hidden:false,editable:false},

{name:'sub_register_address',index:'sub_register_address', width:150, hidden:false,editable:false},

{name:'first_name',index:'first_name',editable:false, width:100},

//{name:'sites',index:'sites',editable:false, width:100},

{name:'name',index:'name',editable:false, width:100},

{name:'',index:'',search:false,editable:false,editrules:{}, width:100,

formatter: function (cellvalue, options, rowObject) {

var retVal = '';

if(rowObject.upload_layout != '')

{

var ext = rowObject.upload_layout.split('.').pop();

if(ext=="png" || ext=="jpg" || ext=="jpeg")

{

}

else if(ext=="pdf")

{

//$('.layout_image').html('<iframe src="<?php echo base_url('layout_uploads/');?>'+response.message.upload_layout+'" height="315px" width="100%"></iframe>');

}

else

{

retVal +='';

}

return retVal;

}},

{name:'status',index:'status',editable:false,align:'center',editrules:{required: true},search:false, width:120,cellattr: function (rowId, tv, rawObject, cm, rdata)
          {
             return 'onclick="fun_approve('+rawObject.id+',\'' + rawObject.status + '\')"';
          },formatter:function (cellvalue, options, rowObject) {    
            if(cellvalue == 'APPROVED')
              return "<input type='checkbox' value='APPROVE' checked readonly \>";
            else if(cellvalue == 'NOT_APPROVED')
              return "<input type='checkbox' value='APPROVE' \>";                  
        }},

{name:'',index:'',width:150,align:"center",search:false,editable:false,formatter: function (cellvalue, options, rowObject) {

var retVal = "";

var retVal = '<b><a onclick="delete_layout('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a></b>';

return retVal;

}},

rowNum:50,

rowTotal: 2000,

rowList : [100,200,500,1000,2000],

rownumbers: true,

//rownumWidth: 60,

pager:"#pager4",

sortname:'id',

viewrecords: true,

gridview: true,

autowidth: true,

sortorder:"asc",

shrinkToFit: true,

loadonce:true,

autoencode: true,

caption:"Approved Layouts List",

//Subgrid1...

subGrid: false,

});

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

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

$("#list4").jqGrid('navGrid','#pager4',

{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

);

$('.filter_choice_submit').submit(function(e)

{

$('#layout_list').hide();

$('#filter_layout_list').show();

e.preventDefault();

load_all_progress();

function load_all_progress()

{

var layout_id = $(".layout_id").val();

$("#progress").setGridParam(

{

url:"<?php echo site_url('get-layout-list-with-filter/')?>"+layout_id,

page:1

}).trigger("reloadGrid");//Reload grid trigger

$("#progress").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

return false

}

var layout_id = $(".layout_id").val();

$("#progress").jqGrid({

url:"<?php echo site_url('get-layout-list-with-filter/')?>"+layout_id,

mtype : "get",

datatype: "json",

colNames:['id','Layout Name','Layout Address','Sub-Register Address','Agent','Land Owner','Layout image','Action'],

colModel:[

{name:'id',index:'id', width:40, hidden:true,editable:false},

{name:'layout_name',index:'layout_name', width:150, hidden:false,editable:false},

{name:'layout_address',index:'layout_address', width:300, hidden:false,editable:false},

{name:'sub_register_address',index:'sub_register_address', width:240, hidden:false,editable:false},

{name:'first_name',index:'first_name',editable:false, width:100},

//{name:'sites',index:'sites',editable:false, width:100},

{name:'name',index:'name',editable:false, width:100},

{name:'',index:'',search:false,editable:false,editrules:{}, width:70,

formatter: function (cellvalue, options, rowObject) {

var retVal = '';

if(rowObject.upload_layout != '')

{

var ext = rowObject.upload_layout.split('.').pop();

if(ext=="png" || ext=="jpg" || ext=="jpeg")

{

retVal +='<a href="<?php echo base_url('/layout_uploads');?>/'+rowObject.upload_layout+'"  target="_blank" ><img width="30px" height="30px" src="<?php echo base_url('/layout_uploads');?>/'+rowObject.upload_layout+'" class="profile-pic"/></a>';

}

else if(ext=="pdf")

{

retVal +='<a href="<?php echo base_url('/layout_uploads');?>/'+rowObject.upload_layout+'"  target="_blank" ><iframe width="30px" height="30px" src="<?php echo base_url('/layout_uploads');?>/'+rowObject.upload_layout+'" class="profile-pic"></iframe></a>';

//$('.layout_image').html('<iframe src="<?php echo base_url('layout_uploads/');?>'+response.message.upload_layout+'" height="315px" width="100%"></iframe>');

}

else

{

retVal +='';

}

return retVal;

}},

{name:'',index:'',width:80,align:"center",search:false,editable:false,formatter: function (cellvalue, options, rowObject) {

var retVal = "";

var retVal = '<b><a href="javascript:void(0);" onclick="fun_edit('+rowObject.id+');"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>&nbsp;<a onclick="delete_layout('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a></b>';

return retVal;

}},

rowNum:20,

rowTotal: 2000,

rowList : [20,30,100,200,500,1000],

rownumbers: true,

//rownumWidth: 60,

pager:"#progresspage1",

sortname:'id',

viewrecords: true,

gridview: true,

autowidth: true,

sortorder:"asc",

shrinkToFit: true,

//loadonce:true,

autoencode: true,

caption:"Layout List",

//Subgrid1...

subGrid: false,

});

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

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

$("#progress").jqGrid('navGrid','#progresspage1',

{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_approve(id,status)

{

if(status == 'APPROVED')

{

swal({

title: "Are you sure?",

text: "You want to DisApprove 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('layout-disapproval');?>",

data : {'layout_id':id},

success:function(response) {

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

toastr["success"](response.message);

$("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
  
              }

else

{

toastr["error"](response.message);

$("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                
              }

}

});

}

else

{

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

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

$("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

}

});

}

else

{

swal({

title: "Are you sure?",

text: "You want to Approve 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('quotation-approval');?>",

data : {'quotation_id':id},

success:function(response) {

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

toastr["success"](response.message);

$("#list").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
   
              }

else

{

toastr["error"](response.message);

$("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
  
    
              }

}

});

}

else

{

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

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

$("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

}

});

}

function fun_edit(rowId)

{

var id = rowId;

window.location.href  = '<?php echo site_url('edit-layout');?>/'+id;

}

function fun_edit_inactive(rowId)
{
  swal({
    title: "Layout in INACTIVE State You Cannot Edit!",
    type: "warning",   showCancelButton: false,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "OK"
    });        
}

function delete_layout_inactive(rowId)
{
  swal({
    title: "Layout in INACTIVE  State You Cannot Delete!",
    type: "warning",   showCancelButton: false,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "OK"
    });        
}

$('.add_layout').click(function()

{

window.location.href="<?php echo site_url('add-layouts')?>";

});

function delete_layout(id)

{

swal({

title: "Are you sure of deleting?",

text: "You will not be able to recover this Layout 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-layout');?>",

data : {'layout_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);

$("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

}

});

}

else

{

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

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

}

});

}

</script>

<?php $this->load->view('includes/footer.php')?>