n@extends('admin/layouts/default')

{{-- Page title --}}
@section('title')
    store Report
    @parent
@stop

{{-- page level styles --}}
@section('header_styles')

    <link type="text/css" rel="stylesheet" href="{{ asset('assets/css/pages/flot.css') }}" />
    <script type="text/javascript" src="{{ asset('assets/chart/loader.js') }}"></script>
@stop

{{-- Page content --}}
@section('content')

    <section class="content-header">
        <!--section starts-->
        <h1>DMU Cafe stores report</h1>
        <ol class="breadcrumb">
            <li>
                <a href="{{ route('dashboard') }}">
                    <i class="livicon" data-name="home" data-size="14" data-loop="true"></i>
                    Dashboard
                </a>
            </li>
            <li>
                <a href="#">stock Statics</a>
            </li>
            <li class="active">Statics</li>
        </ol>
    </section>
    <script type="text/javascript" src="jquery.tools.min.js">
    </script>
    <script type="text/javascript">
        function printthis()
        {
            var w = window.open('', '', 'width=1200,height=1200,resizeable,scrollbars');
            w.document.write($("#printthis").html());
            w.document.close();
            javascript:w.print();
            w.close();


            return false;
        }
    </script>
    <!-- Main content -->
    <section class="content paddingleft_right15">
        <div class="row">
            <div class="col-lg-12">


                        <span class="pull-right">
                           <i class="glyphicon glyphicon-chevron-up showhide clickable"></i>
                       </span>
            </div>
            <div class="panel-body" id="printthis">
                <div class="col-lg-11">
                    <div class="panel panel-danger">
                        <div class="panel-heading">
                            <h2 class="panel-title">
                                <i class="livicon" data-name="barchart" data-size="16" data-loop="true" data-c="cc00" data-hc="nav"></i>
                                <h4><font color="blue" >Dmu Cafe Store Detailss</font></h4>
                            </h2>
                            <span class="pull-right">
                                   <i class="glyphicon glyphicon-chevron-up showhide clickable"></i>
                               </span>
                        </div>
                        <div class="panel-body">
                            <canvas id="mybarChart" height="280" width="600"></canvas>
                        </div>
                    </div>
                </div>

            </div>        <!-- row -->
        </div>        <!-- row -->
        </div>        <!-- row -->
        <?php
        $store=App\Material::select('materialname')->groupBy('materialname')->orderBy('materialname', 'desc')->get()->take(100);
        $x="";
        $k="";
        $h="";
        $m="";
        $total="";
        foreach($store as $s){
        $m=0;
        $mm=App\Material::where('materialname',$s['materialname'])->get();?>
        @foreach($mm as $sm)
            <?php
            $m+=$sm->amount;
            ?>
        @endforeach

        <?php
        if($m){
            $k=$h . '"'.$m.'",';
            $x=$x . '"'.$s['materialname'].'",';
            $t=$m ;
            $total=$total . '"'.$t.'",';
        }

        }

        $x = rtrim($x, ",");
        $k = rtrim($k, ",");
        $h = rtrim($h, ",");
        $total = rtrim($total, ",");
        ?>

    </section>
    <!-- content -->
@stop
{{-- page level scripts --}}
@section('footer_scripts')
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.stack.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.crosshair.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.time.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.selection.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.symbol.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.resize.js') }}" ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flotchart/js/jquery.flot.categories.js') }}"  ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/splinecharts/jquery.flot.spline.js') }}"  ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/vendors/flot.tooltip/js/jquery.flot.tooltip.js') }}"  ></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/js/pages/customcharts.js') }}" ></script>

    <script type="text/javascript" src="{{ asset('assets/Chart.bundle.min.js') }}" ></script>
    <script type="text/javascript" src="{{ asset('assets/chart/loader.js') }}"></script>
    <script type="text/javascript" src="/assets/script/canvasjs.min.js"></script>

    {{--// Bar chart--}}
    <script>
        /* Active regular students*/
        var ctx = document.getElementById("mybarChart");
        var mybarChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: [<?php echo $x; ?>],
                datasets: [
                    {
                        label: 'Total Amounts in KGS',
                        backgroundColor: "blue",
                        data: [<?php echo $total; ?>]
                    }]

            },

            options: {
                scales: {
                    yAxes: [{
                        ticks: {
                            beginAtZero:true
                        }
                    }]
                }
            }
        });
    </script>
@stop
<a href="printpage" onClick="printthis(); return false;"><input type="button" id="print" value="Print"></a>