EVOLUTION-NINJA

Edit File: Add_indents.php

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

<div class="card-body">
          
          <form action="<?php echo site_url('add-indent-details'); ?>" method="post" class="form-horizontal">
            <b>To insert data click here:</b>
            <input type="submit" name="Insert" value="Insert" /><br><br>
          </form>

<div class="radio-list" style="margin-left: 2%;">
   <label class="radio-inline">
    <input type="radio" name="planningorder" id="planningorder" checked="checked" onclick="planningtypes('indent_pending_tax')" />
    Pending Tax Indent </label> &nbsp;&nbsp;&nbsp;

<label class="radio-inline">
      <input type="radio" name="planningorder" id="planningorder"  onclick="planningtypes('approved_indent_tax')" />
    Approved Tax Indent</label> &nbsp;&nbsp;&nbsp;

<label class="radio-inline">
    <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('indent_pending_no_tax')" />
    Pending Tax-free Indent </label> &nbsp;&nbsp;&nbsp;

<label class="radio-inline">
      <input type="radio" name="planningorder" id="planningorder"  onclick="planningtypes('approved_indent_no_tax')" />
    Approved Tax-free Indent</label>
  </div><br>

<div id="table_pending_indent_tax">
    <div id = "jaytab" class="jaytab">
      <table id="list2"></table>
      <div id="pager2"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>                  
    </div>
  </div>

<div id="table_approved_indent_tax">            
    <div id = "jaytab1" class="jaytab">
      <table id="list3"></table>
      <div id="pager3"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>                  
    </div>  
  </div>

<div id="table_pending_indent_no_tax">
    <div id = "jaytab2" class="jaytab">
      <table id="list4"></table>
      <div id="pager4"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>                  
    </div>
  </div>

<div id="table_approved_indent_no_tax">            
    <div id = "jaytab3" class="jaytab">
      <table id="list5"></table>
      <div id="pager5"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>                  
    </div>  
  </div>
        
</div>
</div>
</div>
</div>
<input type="hidden" id="selected_ids"/>
  <button type="button" id="select_ids" class="btn btn-primary get_site_grid" onclick="getSelectedRow()" >Submit</button>
</div>

#table_pending_indent_no_tax
  {
    display:none;
  }

#table_approved_indent_no_tax
  {
    display:none;
  }

#btn{
    border: none;
    background:none;
  }
</style>        
<script type="text/javascript">

}
///pending indent details-------------------------//
  
CallGrid();

function CallGrid()
{

$(document).ready(function (){
   var currids =[];
    jQuery("#list2").jqGrid({
      url:"<?php echo site_url('get-indent-list')?>",   
      datatype: "json", 
       colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'],
        
      colModel:[
             {name:'id',index:'id',hidden:true, editable:true,width:200},
            {name:'indent_no',index:'indent_no', width:250,editable:false},
            //{name:'department_name',index:'department_name', width:250,editable:true,editrules:{required: true}},
            {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}},
            {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}},
            {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:300},
            {name:'created_at',index:'created_at', formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true},width:270},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:150},
            {name:'preview',index:'preview',align: "center",editable:false,search:false,editrules:{required: true}, width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                      return ' onclick="fun_preview($(this))" ';
                  },formatter:function (cellvalue, options, rowObject) {    
                     // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>";
                     return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>";
              }}
          ],
            height: 'auto',
             rowNum:50,
            rowTotal: 200000000000000000000000000,
            rowList : [50,100,200,300,500,1000,5000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager2", 
            sortname:'id', 
            
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            loadonce:true,
        caption:"Pending Tax Indent Details",
         subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
    //alert(row_id);
     
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({
  
     url:"<?php echo site_url('subgrid-indent-details');?>/"+row_id,
    
      mtype : "get",   
      datatype: "json", 
      colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Action','Delete'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}},
            {name:'product_group_name',index:'product_group_name', width:150,editable:true,editrules:{required: true}},
            {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:80},
            {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:80},
            {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}},
            {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:100},
            /*{name:'approval',index:'approval',editable:false,align:'center', classes: 'check',editrules:{required: true},search:false, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata)
              {
                 return 'onclick="fun_approve('+rawObject.id+')"';
              },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:'edit',index:'edit',align: "center",editable:false,seach:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return 'onclick="fun_edit($(this))"';
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='SELECT'  \>"; 
                 return "<button type='button' id='select'><i class='fa fa-hand-pointer-o fa-lg' aria-hidden='true'></i></button>";
              }},
                            
            {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return 'onclick="fun_delete($(this))"';
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='DELETE'  \>"; 
                  return "<button type='button' id='delete'><i class='fa fa-trash fa-lg' aria-hidden='true'></i></button>";
              }}, 
          ],
      height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc",
           multiselect: true,
           onSelectRow: function(ids) {
        
        //fun_approve(ids);
        var sub_id=jQuery("#"+subgrid_table_id).jqGrid('getGridParam','selrow');
        currids.push(sub_id);
        var result = [];
        $.each(currids, function(i, e) {
          if ($.inArray(e, result) == -1) result.push(e);
        });
       
        $("#selected_ids").val(currids);
      }, 
      
      onSelectAll:function(ids) {
        fun_approve_all(ids);

});
   }
  });

jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
    
      $("#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 }
      );
  });

}

function getSelectedRow() {
  
  var sub_ids=$("#selected_ids").val();
  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('indent-approval');?>",
            data : {'indent_sub_ids':sub_ids},
            success:function(response) {
              response=jQuery.parseJSON(response);
              // alert(response);
              console.log(response);
              if(response.result==1)
              {
                toastr["success"](response.message);
                $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              } 
              else
              {
                toastr["error"](response.message);
                $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              }    
            }
        });

} 
      else 
      {

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

});
  }

function fun_edit(rowId)
{
  var id = rowId.closest('tr').attr('id');
  window.location.href  = '<?php echo site_url('edit-indent');?>/'+id;          
}
function checkBox(obj) {
    alert(obj);
    $('.check').prop('checked', obj.checked);
}

function fun_delete(rowId)
{
    var id = rowId.closest('tr').attr('id');

swal({

title: "Are you sure of deleting?",
    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-indent');?>",
            data : {'indent_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 
        {
      $(".sweet-alert").hide();
            $(".sweet-overlay").hide();
        }
  });
       
}

//   function fun_approve(id)
//   {
//     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('indent-approval');?>",
//             data : {'indent_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');
//                 $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
//               } 
//               else
//               {
//                 toastr["error"](response.message);
//                 $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
//                 $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
//               }    
//             }
//         });

//       } 
//       else 
//       {

//           $(".sweet-alert").hide();
//           $(".sweet-overlay").hide();
//            $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
//       }

//     });
// }

function fun_approve_all(id)
  {
    
    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('indent-approvalall');?>",
            data : {'indent_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');
                $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              } 
              else
              {
                toastr["error"](response.message);
                $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              }    
            }
        });

} 
      else 
      {

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

});
}
  
  function fun_preview(rowId,grid_from_id)
  {
    var id = rowId.closest('tr').attr('id');     
    window.location.href  = '<?php echo site_url('indent-preview');?>/'+id;
  }
  
 
  
   function fun_preview_approve(rowId,grid_from_id)
  {
    var id = rowId.closest('tr').attr('id');     
    window.location.href  = '<?php echo site_url('indent-preview-approve');?>/'+id;
  }

//------------------------approved-details----------------------------//

$(document).ready(function (){
  $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
    jQuery("#list3").jqGrid({
      url:"<?php echo site_url('approved-indent-details')?>",  
      datatype: "json", 
       colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'],
        
      colModel:[
            {name:'id',index:'id',hidden:true, editable:true,width:200},
            {name:'indent_no',index:'indent_no', width:200,editable:false},
           // {name:'department_name',index:'department_name', width:300,editable:true,editrules:{required: true}},
            {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}},
            {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}},
            {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:250},
            {name:'created_at',index:'created_at',formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'}, editable:true,editrules:{required: true},width:270},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:150},
             {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return ' onclick="fun_preview_approve($(this))" ';
                  },formatter:function (cellvalue, options, rowObject) {    
                      //return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>";
                      return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>";
              }}

],
            height: 'auto',
             rowNum:50,
            rowTotal: 200000000000000000000000000,
            rowList : [50,100,200,300,500,1000,5000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager3", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            loadonce:true,
        caption:"Approved Tax Indent Details",
         subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
    //alert(row_id);
     swan_id=row_id;
     //alert(swan_id);
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({
  
     url:"<?php echo site_url('indent-approved-subgrid');?>/"+row_id,
   
    //data:{'sub_id':123},
        mtype : "get",   
      datatype: "json", 
        colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Approved','Approved By'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}},
            {name:'product_group_name',index:'product_group_name', width:150,editable:true,editrules:{required: true}},
            {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:80},
            {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:80},
            {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}},
            {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:150},
            {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata)
              {
                 return 'onclick="fun_approve('+rawObject.id+')"';
              },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:'name',index:'name', width:100,editable:true,editrules:{required: true}},
            
          ],
                      
      height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  }); 
  
  jQuery("#list3").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
    
      $("#list3").jqGrid('navGrid','#pager3',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
            { },
            { }, 
        {
            sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
              closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true }
      );
  
  });

/*--------------------------Pending Indent Tax-free---------------------------------*/

$(document).ready(function (){
   var currids =[];
    jQuery("#list4").jqGrid({
      url:"<?php echo site_url('get-tax-free-indent-list')?>",   
      datatype: "json", 
       colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'],
        
      colModel:[
             {name:'id',index:'id',hidden:true, editable:true,width:200},
            {name:'indent_no',index:'indent_no', width:250,editable:false},
           
            {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}},
            {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}},
            {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:300},
            {name:'created_at',index:'created_at', formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true},width:250},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:150},
            {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                      return ' onclick="fun_preview($(this))" ';
                  },formatter:function (cellvalue, options, rowObject) {    
                     // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>";
                     return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>";
              }}
          ],
            height: 'auto',
             rowNum:50,
            rowTotal: 200000000000000000000000000,
            rowList : [50,100,200,300,500,1000,5000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager4", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            loadonce:true,
        caption:"Pending Tax-free Indent Details",
         subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
    //alert(row_id);
     
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({
  
     url:"<?php echo site_url('subgrid-tax-free-indent-details');?>/"+row_id,
    
      mtype : "get",   
      datatype: "json", 
      colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Action','Delete'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}},
            {name:'product_group_name',index:'product_group_name', width:110,editable:true,editrules:{required: true}},
            {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:60},
            {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:50},
            {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}},
            {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:80},
            // {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:120,cellattr: function (rowId, tv, rawObject, cm, rdata)
            //   {
            //      return 'onclick="fun_approve('+rawObject.id+')"';
            //   },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:'edit',index:'edit',align: "center",search:false,editable:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return 'onclick="fun_edit($(this))"';
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='SELECT'  \>"; 
                  return "<button type='button' id='select'><i class='fa fa-hand-pointer-o fa-lg' aria-hidden='true'></i></button>";
              }},
                            
            {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return 'onclick="fun_delete($(this))"';
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='DELETE'  \>";
                return "<button type='button' id='delete'><i class='fa fa-trash fa-lg' aria-hidden='true'></i></button>";
              }}, 
          ],
      height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc",
          multiselect: true,
           onSelectRow: function(ids) {
      
        //fun_approve(ids);
        var sub_id=jQuery("#"+subgrid_table_id).jqGrid('getGridParam','selrow');
        
        currids.push(sub_id);
        var result = [];
        $.each(currids, function(i, e) {
          if ($.inArray(e, result) == -1) result.push(e);
        });
        $("#selected_ids").val(currids);
      }, 
        onSelectAll:function(ids) {
        fun_approve_all(ids);

}, 
       });
   }
  });

jQuery("#list4").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
    
      $("#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 }
      );
  });

/*------------------------------------Approved Indent Tax-free------------------------*/

$(document).ready(function (){
  $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
    jQuery("#list5").jqGrid({
      url:"<?php echo site_url('approved-tax-free-indent-details')?>",  
      datatype: "json", 
       colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'],
        
      colModel:[
            {name:'id',index:'id',hidden:true, editable:true,width:200},
            {name:'indent_no',index:'indent_no', width:200,editable:false},
           // {name:'department_name',index:'department_name', width:300,editable:true,editrules:{required: true}},
            {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}},
            {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}},
            {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:250},
            {name:'created_at',index:'created_at',formatter: 'date',formatoptions:{ srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'}, editable:true,editrules:{required: true},width:250},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:150},
            {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                     return ' onclick="fun_preview_approve($(this))" ';
                  },formatter:function (cellvalue, options, rowObject) {    
                     // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>";
                     return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>";
              }}

],
            height: 'auto',
             rowNum:50,
            rowTotal: 200000000000000000000000000,
            rowList : [50,100,200,300,500,1000,5000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager5", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            loadonce:true,
        caption:"Approved Tax-free Indent Details",
         subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
    //alert(row_id);
     swan_id=row_id;
     //alert(swan_id);
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({
  
     url:"<?php echo site_url('indent-approved-tax-free-subgrid');?>/"+row_id,
   
    //data:{'sub_id':123},
        mtype : "get",   
      datatype: "json", 
        colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Approved','Approved By'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}},
            {name:'product_group_name',index:'product_group_name', width:110,editable:true,editrules:{required: true}},
            {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:60},
            {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:50},
            {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}},
            {name:'required_on_or_before',index:'required_on_or_before', formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'},editable:true,editrules:{required: true},width:80},
            {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:120,cellattr: function (rowId, tv, rawObject, cm, rdata)
              {
                 return 'onclick="fun_approve('+rawObject.id+')"';
              },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:'name',index:'name', width:100,editable:true,editrules:{required: true}},
            
          ],
                      
      height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  }); 
  
  jQuery("#list5").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
    
      $("#list5").jqGrid('navGrid','#pager5',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
            { },
            { }, 
        {
            sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
              closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true }
      );
  
  });

</script>

<?php $this->load->view('includes/footer.php')?>
<style type="text/css">

#delete{
    color: red;
    border: none;
    background:none;
  }
  #select{
     color:#405189;
    border: none;
    background:none;
  }	
  
  #gbox_list3{
    width: 1050px !important;
  }
  #gbox_list4, #gbox_list5{
     width: 1050px !important;
  }

</style>