@extends('admin::curd.index')
@section('heading')
@stop

@section('title')
 <img src="{!!URL::to('img/report/analytics.png')!!}"> &nbsp;{!! ucwords('Reports') !!}
@stop

@section('breadcrumb')
@stop

@section('entry')

@stop

@section('tools')
@stop


@section('content')

  <div class="box-body" >
    <div class="nav-tabs-custom">
      <ul class="nav nav-tabs primary">
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/asset/report" >Asset</a></li>
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/inspection/report">Inspection</a></li>
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/upgrade/report">Upgrade</a></li>
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/breakdown/report">Breakdown</a></li>
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/asset/sale">Sales</a></li>
        <li class="inactive"><a href="{!!trans_url('admin')!!}/assets/asset/depreciation/report">Depreciation</a></li>
        <li class="active"><a href="{!!trans_url('admin')!!}/assets/asset/barcode/report"  class="active">Barcode</a></li>

      </ul>

      <div class="tab-content">
  
        <div class="tab-pane active clearfix" id="details">

            {!!Form::horizondal_open()
            ->id('workOrderReportForm')
            ->secure()
            ->method('POST')
            ->files('true')
            ->enctype('multipart/form-data') !!}
            <div class="col-md-5 col-lg-5">
              {!! Form::select('search[company_id]')
              -> options(Company::companies())
              -> addGroupClass('form-group-sm')
              -> label('Company')
              -> placeholder('Company')
              ->id('company_id')
              !!}

              {!! Form::select('search[division_id]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Division')
              -> placeholder('Division')
              ->id('division_id')
              !!}

              {!! Form::select('search[block_id]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Block')
              -> placeholder('Block')
              ->id('block_id')
              !!}

              {!! Form::select('search[section_id]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Section')
              -> placeholder('Section')
              ->id('section_id')
              !!}
                            
                   
              {!! Form::select('search[category_id]')
              -> options(Category::categories())
              ->id('category_id')
              -> addGroupClass('form-group-sm')
              -> label('Category')
              -> placeholder('Category')
              !!}


              {!! Form::select('search[subcategory_id]')
              ->id('subcategory_id')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Subcategory')
              -> placeholder('Subcategory')
              !!}

              {!! Form::select('search[asset_group_id]')
              -> options(array())
              ->id('asset_group_id')
              -> addGroupClass('form-group-sm')
              -> label('Asset Group')
              -> placeholder('Asset Group')
              !!}
              {!! Form::select('search[depreciation_group_id]')
              -> options(array())
              ->id('depreciation_group_id')
              -> addGroupClass('form-group-sm')
              -> label('Dep Group -IT act')
              -> placeholder('select Dep Group -IT act')
              !!}

              
             <div class="form-group form-group-sm">
                <label for="primary_view" class="control-label col-lg-3 col-md-6 col-sm-6"> 
                Expiry Date
                </label>
                <div class="col-lg-5 col-md-3 col-sm-3">

                    {!! Form::date('search[exp_date][0]')
                    -> id('exp_date_from')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('From')
                    -> raw()!!}
                </div>

                <div class="col-lg-4 col-md-3 col-sm-3 m-l-0">
                  {!! Form::date('search[exp_date][1]')
                    -> id('exp_date_to')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('To')
                    -> raw()!!}
                </div>
              </div>
              
               <div class="form-group form-group-sm">
                <label for="primary_view" class="control-label col-lg-3 col-md-6 col-sm-6"> 
                Calibration Done Date
                </label>
                <div class="col-lg-5 col-md-3 col-sm-3">

                    {!! Form::date('search[calibration_from_date][0]')
                    -> id('exp_date_from')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('From')
                    -> raw()!!}
                </div>

                <div class="col-lg-4 col-md-3 col-sm-3 m-l-0">
                  {!! Form::date('search[calibration_from_date][1]')
                    -> id('exp_date_to')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('To')
                    -> raw()!!}
                </div>
              </div>
              

    

            </div>          
            <div class="col-md-5 col-lg-5">
              {!! Form::select('search[status]')
              -> options(trans('assets::asset.options.status'))
              -> addGroupClass('form-group-sm')
              -> options(trans('assets::asset.options.status'))
              -> label('Status')
              -> placeholder('Status')
              !!} 

              {!! Form::select('search[supplier_id]')
              -> options(Supplier::suppliers())
              -> addGroupClass('form-group-sm')
              -> label('Supplier')
              -> placeholder('Supplier')
              !!}

              {!! Form::select('search[used_by]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Used By')
              -> placeholder('Used By')
              ->id('employee_id')
              !!}

              {!! Form::select('search[custodian_id]')
              -> options(Company::custodians())
              -> addGroupClass('form-group-sm')
              -> label('Custodian')
              -> placeholder('Custodian')
              !!}

              {!! Form::select('search[location_id]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Location')
              -> placeholder('Location')
              ->id('location_id')
              !!}

              {!! Form::select('search[sublocation_id]')
              -> options(array())
              -> addGroupClass('form-group-sm')
              -> label('Sublocation')
              -> placeholder('Sublocation')
              ->id('sublocation_id')
              !!} 

              {!! Form::select('search[department_id]')
              -> options(Department::departments())
              -> addGroupClass('form-group-sm')
              -> label('Department')
              -> placeholder('Department')
              ->id('department_id')
              !!} 
              {!! Form::select('search[work_department_id]')
              -> options(WorkDepartment::work_departments())
              -> addGroupClass('form-group-sm')
              -> label('Work Department')
              -> placeholder('Work Department')
              ->id('work_department_id')
              !!} 

              {!! Form::select('search[criticality_type]')
              -> options(trans('assets::asset.options.criticality_type'))
              -> label('Criticality Type')
              -> placeholder('select criticality type')
              -> addGroupClass('form-group-sm')
              !!} 
              
              <div class="form-group form-group-sm">
                <label for="primary_view" class="control-label col-lg-3 col-md-6 col-sm-6"> 
                Calibration Due Date
                </label>
                <div class="col-lg-5 col-md-3 col-sm-3">

                    {!! Form::date('search[calibration_end_date][0]')
                    -> id('exp_date_from')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('From')
                    -> raw()!!}
                </div>

                <div class="col-lg-4 col-md-3 col-sm-3 m-l-0">
                  {!! Form::date('search[calibration_end_date][1]')
                    -> id('exp_date_to')
                    ->addClass('datepick')
                    -> addGroupClass('form-group-sm')
                    -> placeholder('To')
                    -> raw()!!}
                </div>
              </div>
 
            </div>

    
            <div class="col-md-2 col-lg-2">
              
                <div class="m-b-20">
                  <i class="fa fa-file-excel-o" style="color:#000;"></i>&nbsp;
                  <a  id="download_csv"  class="headpicture" href="#">Print Barcode</a>
                </div>
                <div class="m-b-20">
                    <i class="fa fa-refresh" style="color:#000;"></i>&nbsp;
                    <a  id="resetnow" class="headpicture" style="cursor:pointer;">Reset Filter</a>
                </div> 
            </div>  
            <div class="col-md-10 col-lg-10">            
                <button type="button" id="gobutton" class="btn btn-success btn-sm" style="width:100%">Go</button>
            </div>
            {!!Form::close()!!}
        </div>
      </div>
    </div>
  </div>

  <div class="nav-tabs-custom">
    <ul class="nav nav-tabs primary">
      {{-- <li class="active"><a href="#tab-graph" data-toggle="tab">Graph</a></li> --}}
      {{-- <li class="active"><a href="#tab-summary" data-toggle="tab">Data Summary</a></li> --}}
      <li class="active"><a href="#tab-full-data" data-toggle="tab">Full Data Set</a></li>
    </ul>
    
    <div class="tab-content">
     
        <div class="tab-pane active table-responsive" id="tab-full-data">
          <table id="full_listings" class="table table-striped data-table" width="100%">
              <thead  class="list_head">
                   <th>Asset Id</th>
                    <th>Asset</th>
                   <th>{!! trans('assets::asset.label.category_id')!!}</th>
                   <th>{!! trans('assets::asset.label.subcategory_id')!!}</th>
                   <th>Department</th>
                   <th>Work Department</th>
                   <th>Purchase Date</th>
                   <th>Purchase Value</th>
                   <th>Asset Value</th>
                   <th>{!! trans('assets::asset.label.company_id')!!}</th>
                   <th>{!! trans('assets::asset.label.division_id')!!}</th>
                   <th>Block</th>
                   <th>Section</th>
                   <th>Location</th>
                   <th>Sublocation</th>
                   <th>Supplier</th>
                   <th>{!! trans('assets::asset.label.asset_group_id')!!}</th>
                   <th>{!! trans('assets::asset.label.depreciation_group_id')!!}</th>
                   <th>Used By</th>
                   <th>Custodian</th>
                   <th>EST Life</th>
                   <th>Criticality Type</th>
                   <th>Expiry date</th>
                   <th>{!! trans('assets::asset.label.status')!!}</th>
                   
              </thead>
              
          </table>
        </div>
    </div>
</div>

<div class="modal fade" id="save-report">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
        <h3 class="modal-title">Save Report</h3>
        <div class="popup_description">Type the name and save report for future use.</div>
      </div>
      <div class="modal-body" style="height:110px;">
        <div class="form-horizontal">

            <div class="col-md-12 col-lg-12 m-t-20">
              {!!Form::horizontal_open()
              ->id('report_save')
              ->method('POST')
              ->files('true')
              ->action(trans_url('admin/save_report'))!!}

                {!! Form::hidden('screen')
                   -> forceValue('asset')!!}

                {!! Form::text('name')
                 -> placeholder('Enter Name')
                 -> label('Report Name')
                 -> required()!!}

              {!!Form::close()!!}  
            </div>
        </div>
        <div id="resultofsave" class="searchoptiontext"> </div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-primary" id="save-repot" name="Saverep" value="Send" data-dismiss="modal">Save</button>
      </div>
    </div>
  </div>
</div>


@stop


<script type="text/javascript">

var chart;


 $(document).ready(function () {

    @if(@$save_report['search']['category_id'] <> "")
    $("select[name='search[subcategory_id]").load('{{URL::to("admin/category/subcategory")}}/{{@$save_report['search']['category_id']}}');
    @endif

    @if(@$save_report['search']['subcategory_id'] <> "")
    $("#subcategory_id").load('{{URL::to("admin/category/subcategory")}}/{{@$save_report['search']['category_id']}}/{{@$save_report['search']['subcategory_id']}}');
    $("select[name='search[asset_group_id]").load('{{URL::to("admin/category/asset_group/subcategory")}}/{{@$save_report['search']['subcategory_id']}}');
    @endif

    @if(@$save_report['search']['asset_group_id'] <> "")
    $("select[name='search[asset_group_id]").load('{{URL::to("admin/category/asset_group/subcategory")}}/{{@$save_report['search']['subcategory_id']}}/{{@$save_report['search']['asset_group_id']}}');
    @endif

    @if(@$save_report['search']['company_id'] <> "")
    $("select[name='search[division_id]").load('{{URL::to("admin/company/division/employee")}}/{{@$save_report['search']['company_id']}}');
    @endif

    @if(@$save_report['search']['division_id'] <> "")
    $("select[name='search[division_id]").load('{{URL::to("admin/company/division/employee")}}/{{@$save_report['search']['company_id']}}/{{@$save_report['search']['division_id']}}');
    @endif

    @if(@$save_report['search']['employee_id'] <> "")
    $("select[name='search[employee_id]").load('{{URL::to("admin/company/employee/division")}}/{{@$save_report['search']['division_id']}}/{{@$save_report['search']['employee_id']}}');
    @endif

    @if(@$save_report['search']['location_id'] <> "")
    $("select[name='search[sublocation_id]").load('{{URL::to("admin/location/sub_location/location")}}/{{@$save_report['search']['location_id']}}');
    @endif

    @if(@$save_report['search']['sublocation_id'] <> "")
    $("#sublocation_id").load('{{URL::to("admin/location/sub_location/location")}}/{{@$save_report['search']['location_id']}}/{{@$save_report['search']['sublocation_id']}}');
    @endif


    var filter = $("#workOrderReportForm").serialize();
    // plotGraph("{{URL::to('admin/assets/asset/barcode/report/graph')}}" +'/' + filter + '');
  

    // $('#view_report').click(function(){
    //   $('#saved-reports').load("{{ trans_url('admin/asset/save/save_report')}}");
    //   $('#show_report').modal("show");
    // });

    $("#popup-save-report").click(function(){
      $("#name").val('');
      $("#save-report").modal('show');
    });

    $('#resetnow').click(function(){
      $("input[name='search[exp_date][0]']").val('');
      $("input[name='search[exp_date][1]']").val('');
      $('#workOrderReportForm')[0].reset();
      var filter = $("#workOrderReportForm").serialize(); 
      //  plotGraph("{{URL::to('admin/assets/asset/barcode/report/graph')}}" +'/' + filter + '');          
      $('#group_by_label').html('');
      oTable.api().draw();
    });

    $('#download_csv').click(function(){
      var filter = $("#workOrderReportForm").serialize();
      $('#download_csv').attr('href',"{{URL::to('admin/assets/asset/barcode/report/graph/')}}"+ "/" + filter);
      $('#download_csv').attr("target", "_blank");
    });

    


  

   

   oTable = $('#full_listings').dataTable( {
        "bProcessing": true,
        "sDom": 'R<>rt<ilp><"clear">',
        "bServerSide": true,
        "sAjaxSource": '{!!trans_url("admin")!!}/assets/asset/report',
        "fnServerData" : function ( sSource, aoData, fnCallback ) {

            $('#full_listings .search_bar input, #full_listings .search_bar select').each(
                function(){
                    aoData.push( { 'name' : $(this).attr('name'), 'value' : $(this).val() } );
                }
            );
            $('#workOrderReportForm select, #workOrderReportForm input').each(
                function(){
                    if ($(this).val() == null || $(this).val() == '') {
                      return;
                    }

                    aoData.push( { 'name' : $(this).attr('name'), 'value' : $(this).val() } );
                }
            );
            
            app.dataTable(aoData);
            $.ajax({
                'dataType'  : 'json',
                'data'      : aoData,
                'type'      : 'GET',
                'url'       : sSource,
                'success'   : fnCallback
            });
        },

        "columns": [
            
                    {data :'rfc'},
                    {data :'name'},            
                    {data :'category_id'},
                    {data :'subcategory_id'},
                    {data :'department_id'},
                    {data :'work_department_id'},
                    {data :'purchase_date'},
                    {data :'purchase_value'},
                    {data :'asset_value'},
                    
                    {data :'company_id'},
                    {data :'division_id'},
                    {data :'block_id'},
                    {data :'section_id'},
                    
                    {data :'location_id'},
                    {data :'sublocation_id'},
                    {data :'supplier_id'},
                    {data :'asset_group_id'},
                    {data :'depreciation_group_id'},
                    {data :'custodian_id'},
                    {data :'used_by'},
                    {data :'est'},
                    {data :'criticality_type'},
                    {data :'exp_date'},
                    {data :'status'},

            ],
             
        "pageLength": 25
    });

    
    $(document.body).on('click', "#gobutton", function (e) {
        e.preventDefault();
        var filter = $("#workOrderReportForm").serialize();
        var filter_label = '';
        var comma = '';
        $("#workOrderReportForm select, #workOrderReportForm input").each(function () {
            if ($(this).val() != '' || $(this).val() != null ) {
                filter_label += comma + ' ' + $('#' + $(this).attr('id') + ' :selected').text();
                comma = ',';
            }
        });

        
        
        // plotGraph("{{URL::to('admin/assets/asset/barcode/report/graph')}}" +'/' + filter + '');
        $('#full_listings .search_bar').find("."+$(this).attr('id')).prop('disabled',true);
        oTable.api().draw();
    });
});

function plotGraph(url) {
 
    var label = new Array();
    var dataA = new Array();
    var dataB = new Array();
    var dataC = new Array();
    var dataD = new Array();
    var dataE = new Array();
    var dataF = new Array();
    var dataG = new Array();
    
    var html = '';
    var color = '';
    var count = 0;
 
    html += '<thead class="list_head"><tr height="30" class="listing_headings" >';
    html += '<th width="320" style="padding-left:10px;" >Group By</th>';
    html += '<th width="320" style="padding-left:10px;" >Available</th>';
    html += '<th width="320" style="padding-left:10px;" >Archived</th>';    
    html += '<th width="320" style="padding-left:10px;" >Sold</th>';
    html += '<th width="320" style="padding-left:10px;" >Transit</th>';
    html += '<th width="320" style="padding-left:10px;" >Transfer</th>';
    html += '<th width="320" style="padding-left:10px;" >Condemned</th>';
    html += '<th width="320" style="padding-left:10px;" >Total</th>';
    html += '</tr></thead>';


    $.getJSON(url, function (seriesData) {
        $.each(seriesData, function (id, key) {
            if (count % 2 == 0) {
                color = '#ffffff';
            } else {
                color = '#e9e9e9'
            }

            label.push(key.labels);
            dataA.push(Number(key.available));
            dataB.push(Number(key.archived));
            dataC.push(Number(key.sold));
            dataD.push(Number(key.transit));
            dataE.push(Number(key.transfer));
            dataF.push(Number(key.condemned));
            dataG.push(Number(key.total));

            html += '<tr height="25">';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.labels + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.available + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.archived + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.sold + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.transit + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.transfer+ '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.condemned + '</td>';
            html += '<td style="padding-left:10px;" bgcolor="' + color + '">' + key.total + '</td>';
            html += '</tr>';

            count++;

        });

        $('#data_summary').html(html)
        chart.xAxis[0].setCategories(label);
        chart.series[0].setData(dataA, true);
        chart.series[1].setData(dataB, true);
        chart.series[2].setData(dataC, true);
        chart.series[3].setData(dataD, true);
        chart.series[4].setData(dataE, true);
        chart.series[5].setData(dataF, true);
        chart.series[6].setData(dataG, true);
        chart.redraw();
        chart.hideLoading();
    });



$(".datepick").pickadate({
        format: 'dd mmm, yyyy',
        formatSubmit: 'yyyy-mm-dd',
        hiddenSuffix: '',
        selectMonths: true,
        selectYears: true
    }).prop('type','text');


	  $("#category_id").change(function(){		
    var category = $("#category_id option:selected").val();
    $("#subcategory_id").load('{{URL::to("admin/category/subcategory")}}'+'/'+category);
    });

    $("#subcategory_id").change(function(){
    var subcategory = $("#subcategory_id option:selected").val();
    $("#asset_group_id").load('{{URL::to("admin/category/asset_group/subcategory")}}'+'/'+subcategory);
    });
    $("#subcategory_id").change(function(){
    var subcategory = $("#subcategory_id option:selected").val();
    $("#depreciation_group_id").load('{{URL::to("admin/category/depreciation_group/subcategory")}}'+'/'+subcategory);
    });

    $("#company_id").change(function(){
    var company = $("#company_id option:selected").val();
    $("#division_id").load('{{URL::to("/admin/company/division/employee")}}'+'/'+company);
    });

    $("#division_id").change(function(){
    var division = $("#division_id option:selected").val();
    $("#employee_id").load('{{URL::to("/admin/company/employee/division")}}'+'/'+division);
    });

    $("#company_id,#division_id").change(function(){
     if($("#company_id").val()!='' && $("#division_id option:selected").val()!=''){
    var company = $("#company_id").val();
    var division = $("#division_id option:selected").val();
    // $("#location_id").load('{{URL::to("admin/location/location/location")}}'+'/'+company+'/'+division);
    $("#block_id").load('{{URL::to("admin/block/block/block")}}'+'/'+company+'/'+division);
   
     }
     else
     {
        $("#location_id").val('');
      $("#block_id").val('');
        
        var company=0;
        var division=0;
     }

    });
    $("#block_id").change(function(){
    var block = $("#block_id option:selected").val();
    $("#section_id").load('{{URL::to("/admin/block/section/block")}}'+'/'+block);
    });

    $("#company_id,#division_id,#block_id,#section_id").change(function(){
            if($("#company_id").val()!='' && $("#division_id option:selected").val()!=''&& $("#block_id option:selected").val()!=''&& $("#section_id option:selected").val()!=''){
                var company = $("#company_id").val();
                var division = $("#division_id option:selected").val();
                var block = $("#block_id option:selected").val();
                var section = $("#section_id option:selected").val();
                $("#location_id").load('{{URL::to("admin/location/location/location")}}'+'/'+company+'/'+division+'/'+block+'/'+section);
            
                }
                else
                {
                    $("#location_id").val('');
                    var company=0;
                    var division=0;
                }
      });


  //   $("#company_id,#division_id").change(function(){
  //   if($("#company_id option:selected").val()!='' && $("#division_id option:selected").val()!=''){
  //  var company = $("#company_id option:selected").val();
  //  var division = $("#division_id option:selected").val();
  //  $("#location_id").load('{{URL::to("admin/location/location/location")}}'+'/'+company+'/'+division);
  
  //   }
  //   else
  //   {
  //      $("#location_id").val('');
  //      $("#sublocation_id").val('');
  //      var company=0;
  //      var division=0;
  //   }

  //  });

    $("#location_id").change(function(){
    var location = $("#location_id option:selected").val();
    $("#sublocation_id").load('{{URL::to("admin/location/sub_location/location")}}'+'/'+location);
    });

    // $(".ser_exp_date").pickadate({
    //     format: 'd mmm , yyyy',
    //     formatSubmit: 'd mmm , yyyy',
    //     hiddenSuffix: '',
    //     selectMonths: true,
    //     selectYears: true
    // }).prop('type','text');
}


</script>

<style type="text/css">
.header{
        background: #3c8dbc;
        color: white;
    }
</style>