EVOLUTION-NINJA

Edit File: po_list.php

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

<div class="container" style="margin-top: 40px; border: 1px solid #E6E6E6; margin-bottom: 40px;background: white; padding-left:25px;padding-right:25px;padding-top:25px;padding-bottom:150px;">
	<h3 class="page-title" style="padding-bottom: 20px;">
	Purchase Order List
	</h3><br>

<div id="table_product_po">
    <div id = "jaytab4" class="jaytab">
      <table id="list6"></table>
      <div id="pager6"></div>
      <div id="dialogSelectRow" title="Warning" style="display:none">
        <p>Please select row</p>
      </div>                  
    </div>
  </div>

</div>

/*------------------------------------------product-po details-------------------------*/
  
CallGrid();

function CallGrid()
{

jQuery("#list6").jqGrid({
      url:"<?php echo site_url('product-po-list')?>",   
      datatype: "json", 
       colNames:['ID','PO NO','Date','Layout','Site','Level','Customer','Customer Address','Currency','Created By','Created At','Approval','Approved By','Action','Preview'],
        
      colModel:[
        {name:'id',index:'id',hidden:true, width:50,editable:true,width:50},
        {name:'po_no',index:'po_no',hidden:false, editable:true,width:120},
        {name:'po_date',index:'po_date', width:80,editable:true,editrules:{required: true},formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'layout_name',index:'layout_name', editable:true,editrules:{required: true},width:150},
        {name:'site_no',index:'site_no', editable:true,editrules:{required: true},width:60},
        {name:'level_name',index:'level_name', editable:true,editrules:{required: true},width:80},
        {name:'customer',index:'customer', editable:true,editrules:{required: true},width:100},
        {name:'customer_address',index:'customer_address', editable:true,editrules:{required: true},width:150},
        {name:'currency',index:'currency', editable:true,editrules:{required: true},width:40},
        {name:'name',index:'name', editable:true,editrules:{required: true},width:100},
        {name:'created_on',index:'created_on', editable:true,editrules:{required: true},width:140,formatter: 'date', formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},},
         {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:60,cellattr: function (rowId, tv, rawObject, cm, rdata)
          {
             return 'onclick="fun_approve('+rawObject.id+',\'' + rawObject.approval + '\')"';
          },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:'role',index:'role', editable:true,editrules:{required: true},width:100},
        {name:'',index:'',width:40,align:'center',search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
                var retVal = "";
                var retVal1 = "";
                var retVal = '<a onclick="fun_edit('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>';
                var retVal1 = '<a onclick="fun_edit_prod_approved('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>';
                if(rowObject.approval == 'NOT_APPROVED')
                  return retVal;
                else
                  return retVal1;
          }},
        {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false, width:100,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' \>";
              }}

],
            height: 'auto',
             rowNum:50,
            rowTotal: 200000000000000000000000000,
            rowList : [50,100,200,300,500,1000,5000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager6", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            //autowidth: true,
            sortorder:"asc",
            loadonce:true,
        caption:"Product-PO 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-product-po-details');?>/"+row_id,
    
      mtype : "get",   
      datatype: "json", 
      colNames:['Id','Product Name','Product Type','PO Qty','Unit','Unit Price','INR Value','CGST','SGST','IGST','Total Value'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            
            {name:'product_name',index:'product_name', width:200,editable:true,editrules:{required: true}},
            {name:'product_type',index:'product_type', width:200,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:50},
            {name:'unit_price',index:'unit_price', editable:true,editrules:{required: true},width:50},
            {name:'inr_value',index:'inr_value', editable:true,editrules:{required: true},width:100},
            {name:'cgst',index:'cgst',width:50,editable:true,editrules:{required: true}},
            {name:'sgst',index:'sgst',width:50,editable:true,editrules:{required: true}},
            {name:'igst',index:'igst',width:50,editable:true,editrules:{required: true}},
            {name:'total_value',index:'total_value',width:100,editable:true,editrules:{required: true}},
          ],
      height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  });

jQuery("#list6").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
    
      $("#list6").jqGrid('navGrid','#pager6',
        {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 fun_edit_prod_approved(rowId)
{
  swal({
    title: "This PO is already Approved, cannot Edit!",
    type: "warning",   showCancelButton: false,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "OK"
    });        
}

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('po-approval');?>",
            data : {'po_id':id},
            success:function(response) {
              response=jQuery.parseJSON(response);
              console.log(response);
              if(response.result==1)
              {
                toastr["success"](response.message);
                $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              } 
              else
              {
                toastr["error"](response.message);
                $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              }    
            }
        });

} 
      else 
      {

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

});
  }
}

function fun_edit(rowId)
{
  var id = rowId;
  window.location.href  = '<?php echo site_url('edit-generated-po');?>/'+id;          
}

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

function fun_delete(rowId)
{
  var 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({
          
          url:"<?php echo site_url("delete-created-po")?>",
          type:"POST",
          data:{'p_id':id},
          success:function(response) {
            response=jQuery.parseJSON(response);
                console.log(response);

if(response.result == 1) 
              {
                  toastr["success"]("Deleted successfully"); 
                  $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); 
              }
              else
              {
                toastr["error"](response.message);
              }

}

});  
        
         } 
        else {

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

});
}

</script>
<style type="text/css">
	form{
			padding-top: 30px;
		}
    .main-panel{
      height: 77vh;
    }
    #gbox_list3{
      width: 1050px;
    }
    #gbox_list4{
       width: 1050px;
    }
    #gbox_list5{
       width: 1050px;
    }
    #gbox_list6{
       width: 1050px;
    }
    @media only screen and (min-width:320px) and (max-width:640px){
     
    }
</style>
<?php $this->load->view('includes/footer.php')?>