One Hat Cyber Team

View File Name : report.blade.php

@extends('layouts.master')
@section('styles')

<style>
   .edit,.delete{
   	border:none !important;
   	margin:1em;
   }

   .edit{
   	color:#136BAF;
   }

   .delete{
   	color:red;
   }
</style>

<link rel="stylesheet" href="{{ asset('css/lib/datatables-net/datatables.min.css') }}">
<link rel="stylesheet" href="{{ asset('css/separate/vendor/datatables-net.min.css')}}">
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
@endsection

@section('content')
<div class="page-content">
    <div class="container-fluid">
			@if(session()->has('message'))
	        	<div class="alert alert-info alert-fill alert-close alert-dismissible fade in">
				  <strong>{{ session()->get('message') }}</strong>
				</div>
			@endif

            <div class="box-typical box-typical-padding">
                <div class="filtering m-b">
                    <form action="{{route('sale-report')}}" method="GET">
                        {!! csrf_field() !!}
                        <div class="row">
                            <div class="col-lg-3">
                                <fieldset class="form-group">
                                    <label class="form-label semibold" for="exampleInputPassword1">Select Item</label>
                                    <select  class="form-control" name="item" id="item">
                                        <option value="All">All</option>
                                        @foreach($items as $item) 
                                            <option value="{{$item->id}}">{{$item->name}}</option>
                                        @endforeach
                                    </select>
                                </fieldset>
                            </div>
                            <div class="col-lg-3">
                                <fieldset class="form-group">
                                   <label class="form-label semibold" for="exampleInput">Start From</label>
                                   <div class='input-group date'>
                                        <input  type="text" id="start_date" class="form-control" name="start_date">
                                        <span class="input-group-addon">
                                            <i class="font-icon font-icon-calend"></i>
                                        </span>
                                    </div>
                                </fieldset>
                            </div>
                            <div class="col-lg-3">
                                <fieldset class="form-group">
                                   <label class="form-label semibold" for="exampleInput">End From</label>
                                   <div class='input-group date'>
                                        <input  type="text" id="end_date" class="form-control" name="end_date">
                                        <span class="input-group-addon">
                                            <i class="font-icon font-icon-calend"></i>
                                        </span>
                                    </div>
                                </fieldset>
                            </div>
                            <div class="col-lg-2">
                                <div class="input-group-btn"> 
                                    <p>&nbsp;</p>
                                    <button type="submit" value="1" name="filter" class="btn btn-sm btn-primary p-x-3 p-y mt-4">Fetch</button>
                                </div>
                            </div>
                        </div>
                        <!--Select Columns Modal-->
                    </form>
                </div>    
            </div>
			<section class="card">
                @if(count($saleItems) > 0)
                <button class="exportToExcel btn-sm btn-success m-y-1 m-r-2 float-right">Export</button>
                @endif
				<div class="card-block">
					<table id="example" class="sales_report table2excel_with_colors display table table-striped table-bordered" cellspacing="0" width="100%">
						<thead>
                            <tr>
                                <th>Sale Type</th>
                                <th>Invoice Number</th>
                                <th>FPO Invoice Number</th>
                                <th>Customer</th>
                                <th>Item</th>
                                <th>Quantity</th>
                                <th>Date</th>
                                <th>Narration</th>
                            </tr>
						</thead>
						<tbody>
                            @foreach($saleItems as $saleItem)
                            <tr>
                                <td>{{$saleItem->sale->sale_type}}</td>
                                <td>{{$saleItem->sale->invoice_number}}</td>
                                <td>{{$saleItem->sale->fpo_invoice_number}}</td>
                                <td>{{$saleItem->sale->customer->name}}</td>
                                <td>{{$saleItem->item->name}}</td>
                                <td>{{$saleItem->quantity}}</td>
                                <td>{{$saleItem->sale_date}}</td>
                                <td>{{$saleItem->sale->comments}}</td>
                            </tr>
                            @endforeach
						</tbody>
					</table>
				</div>
			</section>
    </div>
</div>

@endsection


@section('scripts')

<script src="{{ asset('js/lib/datatables-net/datatables.min.js') }}"></script>
<script src="{{ asset('js/jquery.table2excel.js') }}"></script>
<script src="https://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>
<script>
    $( function() {
        $( "#start_date" ).datepicker({
            dateFormat: "yy-mm-dd"
        });
        $( "#end_date" ).datepicker({
            dateFormat: "yy-mm-dd"
        });
    });
</script>
<script>
    $(function() {
        $(".exportToExcel").click(function(e){
            var table = $('.sales_report');
            if(table && table.length){
                var preserveColors = (table.hasClass('table2excel_with_colors') ? true : false);
                $(table).table2excel({
                    exclude: ".noExl",
                    name: "Excel Document Name",
                    filename: "sales_report" + new Date().toISOString().replace(/[\-\:\.]/g, "") + ".xls",
                    fileext: ".xls",
                    exclude_img: true,
                    exclude_links: true,
                    exclude_inputs: true,
                    preserveColors: preserveColors
                });
            }
        });
    });
</script>

@endsection