@extends('layouts.app')
@section('pagetitle')
@stop
@section('title')
<h1>รายงานผลกำไร</h1>
@stop
@section('content')
<style>
.table{ margin-bottom:0}
 
</style>
<div class="main-container col-sm-12" >
  <div class="panel panel-default">
    <div class="panel-body"><span class="pull-left">
      <form class="form-inline">
        <div class="form-group">
          <label for="date1">วันที่</label>
          <input type="date" class="form-control" id="date1" name="date1" placeholder="วันที่" value="{{$date1}}">
        </div>
        <div class="form-group">
          <label for="date2">ถึงวันที่</label>
          <input type="date" class="form-control" id="date2" name="date2" placeholder="วันที่"  value="{{$date2}}">
        </div>
        
         <div class="form-group">
        <label for="branches_id">สาขา</label>
        <select  class="form-control" id="branches_id" name="branches_id" placeholder="สาขา" >
        @if(auth()->user()->permission=='ADMIN')
        <option value="ALL">ทุกสาขา</option>
        @endif 
        @foreach($branches as $branch)
            <option value="{{$branch->id }}" {{isset($_REQUEST['branches_id']) && $_REQUEST['branches_id'] == $branch->id ? 'selected' : '' }}>{{$branch->name }}</option>
        @endforeach
        </select>
      </div>
  
        <button type="submit" class="btn btn-info">ค้นหารายงานผลกำไร</button>
      </form>
      </span>
      <span class="pull-right">
      <label class="control-label">วันที่ {{date('d/m/Y',strtotime($date1))}} - {{date('d/m/Y',strtotime($date2))}} </label>
      </span>
    </div>
  </div>
  @if(isset($sells))
  <div class="table-responsive">
  <table width="100%" border="1" class="table table-bordered">
    <thead>
      <tr class="btn-info">
        <td align="center">รหัสสินค้า</td>
        <td align="center">ชื่อสินค้า</td>
        <td align="center">จำนวนที่ขาย</td>
        <td align="center">มูลค่าสุทธิ</td>
        <td align="center">มูลค่าการขาย</td>
        <td align="center">มูลค่ากำไร</td>
      </tr>
    </thead>
    <tbody>
          @foreach($sells as $sell)
    <tr>
      <td align="center">{{$sell->barcode}}</td>
      <td align="center">{{$sell->name}}</td>
      <td align="center">{{number_format($sell->s_amount,0)}}</td>
      <td align="center">{{number_format($sell->s_cost,0)}}</td>
      <td align="center">{{number_format($sell->s_price,0)}}</td>
      <td align="center">{{number_format($sell->s_price - $sell->s_cost,0)}}</td>
    </tr>
    @endforeach
      </tbody>
    
    <tfoot style="color:black; font-weight:700">
      <tr>
        <td colspan="2" rowspan="2">&nbsp;</td>
        <td align="right">รวมหน้านี้</td>
        <td align="right">&nbsp;</td>
        <td align="right">&nbsp;</td>
        <td align="right">&nbsp;</td>
      </tr>
      <tr>
        <td align="right">รวมทั้งหมด</td>
        <td align="right">&nbsp;</td>
        <td align="right">&nbsp;</td>
        <td align="right">&nbsp;</td>
      </tr>
    </tfoot>
  </table>
  </div>
  @endif </div>
@stop


@section('style')
<link href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet" />
@stop
@section('script') 
<script src="{{asset('https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('https://cdn.datatables.net/1.10.20/js/dataTables.bootstrap.min.js')}}"> </script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script> 
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.colVis.min.js"></script> 
<script>
$(document).ready(function() {
$('.table').DataTable({
  "lengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "ทั้งหมด"]],
                "order": [[0, "desc"]],

			dom: 'lBfrtip',
                buttons: [
                    { extend: 'copyHtml5', footer: true, title: 'รายงานการขาย ' ,text :'คัดลอก'					 },
                    { extend: 'excelHtml5', footer: true, title: 'รายงานการขาย ' , text :'ส่งออกเป็น Excel' },
                    { extend: 'pdfHtml5', footer: true, title: 'รายงานการขาย ' , text :'ส่งออกเป็น PDF' },
                    { extend: 'print', footer: true, title: 'รายงานการขาย ' , text :'พิมพ์'  },
                ], initComplete: function () {
                    $('.buttons-copy').addClass('btn btn-sm btn-info');
                    $('.buttons-copy').removeClass('dt-button');
                    $('.buttons-excel').addClass('btn btn-sm btn-success');
                    $('.buttons-excel').removeClass('dt-button');
                    $('.buttons-pdf').addClass('btn btn-sm btn-danger');
                    $('.buttons-pdf').removeClass('dt-button');
                    $('.buttons-print').addClass('btn btn-sm btn-primary');
                    $('.buttons-print').removeClass('dt-button');
                },
					"language":{
					"decimal":        "",
					"emptyTable":     "ไม่พบข้อมูลเลยค่ะ",
					"info":           "แสดง _START_ ถึง _END_ จาก _TOTAL_ รายการ",
					"infoEmpty":      "ไม่มีรายการที่จะแสดง",
					"infoFiltered":   "(กรองจาก _MAX_ รายการ)",
					"infoPostFix":    "",
					"thousands":      ",",
					"lengthMenu":     "แสดง _MENU_ รายการ &nbsp;",
					"loadingRecords": "กำลังโหลดข้อมูล...",
					"processing":     "กำลังค้นข้อมูล...",
					"search":         "ค้นหา:",
					"zeroRecords":    "ไม่พบข้อมูลค่ะ",
					"paginate": {
					"first":      "หน้าแรก",
					"last":       "หน้าสุดท้าย",
					"next":       "หน้าถัดไป",
					"previous":   "ก่อนหน้า"
					},
					"aria": {
					"sortAscending":  ": activate to sort column ascending",
					"sortDescending": ": activate to sort column descending"
					}
					}
	,
		  "footerCallback": function (row, data, start, end, display) {
                    var api = this.api(), data;
                    var intVal = function (i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                                i : 0;
                    };
                   PageCost = api
                        .column(3, { page: 'current' })
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);
                    TotalCost = api
                        .column(3)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    pagePrice = api
                        .column(4, { page: 'current' })
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);
                    totalPrice = api
                        .column(4)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    pageProfit = api
                        .column(5, { page: 'current' })
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);
                    totalProfit = api
                        .column(5)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0); 
                    
                    $(api.column(3).footer()).html($.fn.dataTable.render.number(',', '.', '2').display(  PageCost  )  );
                    $('tr:eq(1) td:eq(1)', api.table().footer()).html($.fn.dataTable.render.number(',', '.', '2').display(TotalCost )  );
					
                    $(api.column(4).footer()).html($.fn.dataTable.render.number(',', '.', '2').display(  pagePrice ) + "  " );
                    $('tr:eq(1) td:eq(2)', api.table().footer()).html($.fn.dataTable.render.number(',', '.', '2').display( totalPrice )  );
					
                    $(api.column(5).footer()).html($.fn.dataTable.render.number(',', '.', '2').display(   pageProfit) + "  "   );
                    $('tr:eq(1) td:eq(3)', api.table().footer()).html($.fn.dataTable.render.number(',', '.', '2').display(totalProfit   ) + "  ");
                  
                }
                
            });
 
 
 
});
</script> 
@stop