EVOLUTION-NINJA

Edit File: inward_purchases_delivery.php

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

<div class="container bg" style="background: white; padding: 30px; border: 1px solid #E6E6E6;
    margin-bottom: 20px;
    margin-top: 20px;">
    
    <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="#">Purchase</a></li>
          <li class="breadcrumb-item"> Purchase </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>
    
	<h3 class="page-title">
	Inward Purchase Delivery Confirmation
	</h3>

<div class="radio-list" style="margin-left: 2%;">
   
      <label class="radio-inline">
      <input type="radio" checked="checked" name="planningorder" id="planningorder" onclick="planningtypes('product_inward')" />
      Inward Purchase - Product</label>&nbsp;&nbsp;&nbsp;
       <label class="radio-inline"> 
      <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('credit_note')" />
      Credit Note</label> &nbsp;&nbsp;&nbsp;
      <label class="radio-inline">
      <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('debit_note')" />
      Debit Note</label> &nbsp;&nbsp;&nbsp;
      
    </div>
		
    <div id="credit_note">
      <div id ="jaytab2" style="margin-top:3%" class="grid ">
        <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="debit_note">
      <div id ="jaytab3" style="margin-top:3%" class="grid ">
        <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 id="table_product_inward">
      <div id ="jaytab4" style="margin-top:3%" class="grid ">
        <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>

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:"Credit Note 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
          },

);
    }
    else if(str=="debit_note")
    {
      $('#table_product_inward').hide();
      $('#credit_note').hide();
      $('#debit_note').show();
      $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      jQuery("#list5").jqGrid({
      url:"<?php echo site_url('get-debit-note-list')?>",  
      mtype : "get",   
      datatype: "json", 
      colNames:['id','PO No','Products Name','Consumed At','Received Quantity','Inr Value','Unit Price','Return Stock','Return Amount','Total Amount','Created At','Created By','Action'],
      colModel:[
              {name:'id',index:'id', width:40, hidden:true,editable:false},
              {name:'po_no',index:'po_no', width:150, hidden:false,editable:false},
              {name:'product_name',index:'product_name', width:150, hidden:false,editable:false},
              {name:'consumed_at',index:'consumed_at',editable:false, width:100},
              {name:'received_quantity',index:'received_quantity', width:100, hidden:false,editable:false},
              {name:'inr_value',index:'inr_value', width:100, hidden:false,editable:false},
              {name:'unit_price',index:'unit_price',width:100,hidden:false,editable:false},
              {name:'return_stock',index:'return_stock',width:100,hidden:false,editable:false},
              {name:'return_amount',index:'return_amount',width:100,hidden:false,editable:false},
              {name:'total_amount',index:'total_amount',width:100,hidden:false,editable:false},
            {name:'name',index:'name',width:100,hidden:false,editable:false},
              {name:'created_at',index:'created_at', editable:true,editrules:{required: true},width:260,formatter: 'date',formatoptions:  { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true},width:270},
             {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
                  {
                      return ' onclick="fun_debit_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>";
              }},

rowNum:20,
            rowTotal: 2000,
            rowList : [20,30],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager5", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Debit Note List",
            //Subgrid1...
            subGrid: false,

});

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

$("#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,
          closeAfterDelete:true,
          closeAfterEdit:true
          },

);
    }
    else if(str=="product_inward")
    {
      $("#list6").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#table_product_inward').show();
      $('#credit_note').hide();
      $('#debit_note').hide();
    }
}

function fun_creditdebit(rowId)
  {
 
  var id = rowId;
   
    window.location.href  = '<?php echo site_url('credit-debit-notes');?>/'+id;
  }

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

function fun_edit_completed(rowId)
{
  swal({
    title: "Stock Received, cannot Add more!",
    type: "warning",   showCancelButton: false,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "OK"
    });        
}

function fun_delete(rowId)
{
  var id = rowId.closest('tr').attr('id');
  var id = 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-prod-master")?>",
          type:"POST",
          data:{id:id},
          success:function(response) {
            response=jQuery.parseJSON(response);
                console.log(response);

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

});  
        
         } 
        else {

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

});
}

/*--------------------------------------product_inward-----------------------------------*/

jQuery("#list6").jqGrid({
      url:"<?php echo site_url('product-inward-purchase')?>",   
      datatype: "json", 
       colNames:['ID','PO NO','Date','Layout','Godown','Site','Level','Customer','Customer Address','Currency','Created By','Created At','Status','ADD STOCK','Preview',"Credit/Debit"],
        
      colModel:[
        {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
            {name:'po_no',index:'po_no',hidden:false, editable:true,width:150},
           {name:'po_date',index:'po_date', width:100,editable:true,editrules:{required: true},formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd-m-Y'}},
            {name:'layout',index:'layout', editable:true,editrules:{required: true},width:120},
            {name:'godown',index:'godown', editable:true,editrules:{required: true},width:100},
            {name:'site',index:'site', editable:true,editrules:{required: true},width:60},
            {name:'level',index:'level', 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:80},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:80},
             {name:'created_on',index:'created_on',formatter: 'date',formatoptions:  { srcformat: 'ISO8601Long', newformat: 'd-m-Y g:ia'},editable:true,editrules:{required: true},width:180},
            {name:'status',index:'status',editable:true,editrules:{required: true},width:80},
            {name:'',index:'',align: "center",editable:false,editrules:{required: true},search:false,width:80,cellattr: function (cellvalue, options, rowObject) 
                  {
                    var retVal = "";
                    var retVal1 = "";
                    var retVal = 'onclick="fun_edit('+rowObject.id+');"';
                      //return retVal;
                    var retVal1 = 'onclick="fun_edit_completed('+rowObject.id+');"'; 
                    if(rowObject.status == 'NOT_YET')
                    {
                      return retVal;
                    }
                    else
                    {
                      return retVal1;
                    }
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='SELECT'  \>"; 
                  return "<button type='button' id='stock'><i class='fa fa-cart-arrow-down fa-lg' aria-hidden='true'></i></button>";

}},  
            {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:80,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>";
              }},
             {name:'',index:'',align: "center",editable:false,editrules:{required: true},search:false,width:80,cellattr: function (cellvalue, options, rowObject) 
                  {
                    var retVal = "";
                    var retVal = 'onclick="fun_creditdebit('+rowObject.id+');"';
                    
                      return retVal;
                   
                  },formatter:function (cellvalue, options, rowObject) {    
                // return "<input type='button' class='fa fa-eye' value='Credit'  \>"; 
                 return "<button type='button' id='credit'><i class='fa fa-credit-card' aria-hidden='true'></i></button>";
              }},

],
            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 Inward Purchase 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('product-inward-purchase-subgrid');?>/"+row_id,
    
      mtype : "get",   
      datatype: "json", 
      colNames:['Id','Product Name','Product Type','PO Qty','Received Qty','Unit','Unit Price','INR Value','CGST','SGST','IGST','Total Value','Created By','Created At','Status'],
      colModel:[
            {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
           // {name:'department',index:'department', width:100,editable:true,editrules:{required: true}},
            {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}},
            {name:'product_type',index:'product_type', width:150,editable:true,editrules:{required: true}},
            //{name:'indent_qty',index:'indent_qty', editable:true,editrules:{required: true},width:60},
            {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:60},
            {name:'received_goods',index:'received_goods', editable:true,editrules:{required: true},width:60},
            {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:50},
            {name:'cgst',index:'cgst',width:40,editable:true,editrules:{required: true}},
            {name:'sgst',index:'sgst',width:40,editable:true,editrules:{required: true}},
            {name:'igst',index:'igst',width:40,editable:true,editrules:{required: true}},
            {name:'total_value',index:'total_value',width:80,editable:true,editrules:{required: true}},
            {name:'name',index:'name', editable:true,editrules:{required: true},width:80},
             {name:'created_on',index:'created_on', editable:true,editrules:{required: true},width:150,formatter: 'date',formatoptions:  { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true}},
            {name:'subgrid_status',index:'subgrid_status', editable:true,editrules:{required: true},width:80}

],
      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 }
      );

</script>
<style type="text/css">

#btn{
    border: none;
    background:none;
  }
   #stock{
    border: none;
    background:none;
    color: #2AA2DF;
  }
   #credit{
     border: none;
    background:none;
    color: #1DA075;
  }
 
	form{
			padding-top: 30px;
		}
</style>
<?php $this->load->view('includes/footer.php')?>