EVOLUTION-NINJA

Edit File: annexure_list.php

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

<div class="container">
    <form class="forms-sample add_annexure_form">
      <div class="row">
      <div class="col-sm-4">
        <div class="form-group">
          <label>Package</label>          
        <select name="package_name" class="form-control package_name" required>
                <option value="">Select</option>
                <?php foreach($package_name as $value) { ?>             
                <option value="<?php echo $value->id; ?>"><?php echo $value->package_name;?></option>
                <?php } ?>
        </select> 
        </div>
      </div>
  
      <div class="col-sm-4">
        <div class="form-group">
          <label>Annexure</label>         
            <select class="form-control annexure_name" name="annexure_names" multiple>      
            <?php foreach($annexure as $value) { ?>  
            <option value="<?php echo $value->id; ?>"><?php echo $value->type_of_work; ?></option>
           <option value="<?php echo $value->id; ?>"><?php echo $value->foundation_level; echo $value->foundation_level; ?></option>     
            <option value="<?php echo $value->id; ?>"><?php echo $value->unit_quantity;?></option>
            <?php } ?>               
          </select> 
        </div>
      </div>
    </div>
    <div class="modal-footer">          
      <button type="submit" class="btn btn-primary submit">Submit</button>
      <button type="reset" class="btn btn-primary cancel">Cancel</button>
    </div>
    </form>
  </div>
  <div class="container">
     <div id ="jaytab" style="margin-top:3%" class="grid ">
      <table id="list2"></table>
      <div id="pager2"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>
      </div>
</div>
  <script type="text/javascript">

$(document).ready(function() {

$('.annexure_name').SumoSelect({selectAll: true, 
  });
});
  $('.add_annexure_form').submit(function(e){
     var package_id  =$('.package_name').val();
     var annexure_id = $('.annexure_name').val();
     // alert(annexure_id);die();
      e.preventDefault();
      formdata = new FormData($(this)[0]);
      swal({

title: "Are you sure?",
        text: "You want to Save 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('insert-annexure-package');?>",
            data : {'pack_id':package_id,'annex_id':annexure_id},
            success:function(response) {
              response=jQuery.parseJSON(response);
              console.log(response);
              if(response.result==1)
              {
                toastr["success"](response.message);
                $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              } 
              else
              {
                toastr["error"](response.message);
                $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              }    
            }
        });
        } 
        else 
        {
          $(".sweet-alert").hide();
          $(".sweet-overlay").hide();
        }
      });

});
  
  CallGrid();

}},
             
           ],

rowNum:20,
          rowTotal: 2000,
          rowList : [20,30],
          rownumbers: true,
          //rownumWidth: 60,
          pager:"#pager2", 
          sortname:'id', 
          viewrecords: true,
          gridview: true,
          autowidth: true,
          sortorder:"asc",
          shrinkToFit: true,
          loadonce:true,
          autoencode: true,
          caption:"Annexure List",
           subGrid: true,
                subGridRowExpanded: function(subgrid_id, row_id) {
                var subgrid_table_id;
                swan_id=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('get-sub-annexure-category');?>?id="+swan_id,

type : "GET", 
                        datatype: "json", 
                        colNames:['ID','Sub Annexure','Action'],
                        colModel:[
                        {name:'id',index:'id',hidden:true,key:true, width:100, editable:false},
                        {name:'annexure_category',index:'annexure_category', width:150, hidden:false,editable:false},                         
                        {name:'',index:'',search:false,width:60, editable:false,formatter: function (cellvalue, options, rowObject) {
                        var retVal = "";
                        var retVal = ' <a data-toggle="tooltip" title="Edit" class="" href="javascript:void(0);"><span class="fa fa-pencil" onclick="edit_sub($(this))"  style="color:blue;"></span></a>     <a data-toggle="tooltip" title="Delete" onclick="delete_sub($(this))"; href="javascript:void(0);"><span class="fa fa-trash" style="color:red;"></span></a>';
                        return retVal;
                      }},
                        
                    ],

height: 'auto',
                        width: 'auto',
                        autowidth: false,
                        shrinkToFit: true,
                        rowNum:20,
                        sortname: 'num',
                        sortorder: "asc",
                        pager:subgrid_table_id,
                        loadonce: true,
                        footerrow: true,
                        userDataOnFooter: true,

});
                  }

});

$("#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
               },

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