@using Imza.WebTools.Classes

@{
    ViewBag.Modul = "İstatistikler";
    ViewBag.Title = "Net Kantin";
    Layout = "~/Views/Shared/Index.cshtml";
}

<link rel="stylesheet" type="text/css" href="/assets/css/c3.css">
<script src="/assets/js/d3.v3.min.js"></script>
<script src="/assets/js/c3.js"></script>

<!--[if !IE]><!-->
<style>
    /*
    Generic Styling, for Desktops/Laptops
    */
    table {
        width: 100%;
        border-collapse: collapse;
    }
    /* Zebra striping */
    tr:nth-of-type(odd) {
        background: #eee;
    }

    th {
        font-weight: bold;
    }

    td, th {
        padding: 6px;
        border: 1px solid #ccc;
        text-align: left;
    }

    /*
    Max width before this PARTICULAR table gets nasty
    This query will take effect for any screen smaller than 760px
    and also iPads specifically.
    */
    @@media only screen and (max-width: 760px), (min-device-width: 768px) and (max-device-width: 1024px) {

        /* Force table to not be like tables anymore */
        table, thead, tbody, th, td, tr {
            display: block;
        }

        /* Hide table headers (but not display: none;, for accessibility) */
        thead tr {
            position: absolute;
            top: -9999px;
            left: -9999px;
        }

        tr {
            border: 1px solid #ccc;
        }

        td {
            /* Behave  like a "row" */
            border: none;
            border-bottom: 1px solid #eee;
            position: relative;
            padding-left: 50%;
        }

        td:before {
            /* Now like a table header */
            position: absolute;
            /* Top/left values mimic padding */
            top: 6px;
            left: 6px;
            width: 45%;
            padding-right: 10px;
            white-space: nowrap;
        }

        /*
        Label the data
        */
        td:nth-of-type(1):before {
            content: "Öğrenci";
        }

        td:nth-of-type(2):before {
            content: "Yüklenen";
        }
        
        td:nth-of-type(3):before {
            content: "Harcama";
        }
        td:nth-of-type(4):before {
            content: "Kalan Bakiye";
        }

    }
</style>
<!--=== Page Header ===-->
<div class="page-header">
    <div class="page-title">
        <h3>Hoşgeldiniz</h3>
        <span>@Session["USERNAME"]</span>
    </div>
    <!-- Page Stats -->
    <ul class="page-stats">
        <li>
            <div class="summary">
                <span>Toplam Öğrenci Sayısı</span>
                <h3>@ViewBag.OGRENCISAYISI</h3>
            </div>
            
            <div id="sparkline-bar" class="graph sparkline hidden-xs">20,15,8,50,20,40,20,30,20,15,30,20,25,20</div>
            <!-- Use instead of sparkline e.g. this:
            <div class="graph circular-chart" data-percent="73">73%</div>
            -->
        </li>
        <li>
            <div class="summary">
                <span>Kartta Kalan Bakiye</span>
                <h3>@ViewBag.KALANBAKIYE ₺</h3>
            </div>
            <div id="sparkline-bar2" class="graph sparkline hidden-xs">20,15,8,50,20,40,20,30,20,15,30,20,25,20</div>
        </li>
    </ul>
    <!-- /Page Stats -->
</div>

<div class="row">


    <div class="col-md-6">
        <div class="widget box">
            <div class="widget-header">
                <h4><i class="icon-reorder"></i> ÖĞRENCİ EN ÇOK SATIN ALDIĞI 5 ÜRÜN</h4>
                <div class="toolbar no-padding">
                    <div class="btn-group">
                        <span class="btn btn-xs widget-collapse"><i class="icon-angle-down"></i></span>
                    </div>
                </div>
            </div>
            <div class="widget-content">

                <div id="chartOkulTurleri"></div>
                <script>

                    @Html.Raw(ViewBag.OKULTURLERI)


                </script>
            </div>
        </div>
    </div>
    <div class="col-md-6">
        <div class="widget box">
            <div class="widget-header">
                <h4><i class="icon-reorder"></i> ÖĞRENCİ KART BAKİYE GRAFİĞİ</h4>
                <div class="toolbar no-padding">
                    <div class="btn-group">
                        <span class="btn btn-xs widget-collapse"><i class="icon-angle-down"></i></span>
                    </div>
                </div>
            </div>
            <div class="widget-content">

                <div id="chartOkul"></div>
                <script>


                    @Html.Raw(ViewBag.OKUL)


                </script>

            </div>
        </div>
    </div>
    
</div>



<div class="row">
    <div class="col-md-12">
        <div class="widget box">
            <div class="widget-header">
                <h4><i class="icon-reorder"></i> DETAYLI BAKİYE RAPORU</h4>

                <div class="toolbar no-padding">
                </div>
            </div>
            <div class="widget-content no-padding">


                <table id="gvData" class="table-striped table-bordered table-hover hover datatable  table-columnfilter">
                    <thead>
                        <tr>

                            <th>Öğrenci</th>
                            <th style="width: 20%; color: #6b8e23; font-weight: bold">Yüklenen</th>
                            <th style="width: 20%; color: #8b0000; font-weight: bold">Harcama</th>
                            <th style="width: 20%; color: #000080; font-weight: bold">Kalan Bakiye</th>
                        </tr>
                    </thead>
                    <tbody>
                    @{
                        var dtTable = SQL.GetDataTable(@"SELECT ADI,SUM(KANTINBORC) HARCAMA,SUM(KANTINALACAK) YUKLENEN,SUM(KANTINBAKIYETUTAR) KALANBAKIYE FROM dbo.viewCariHesaplarKantin WHERE ID IN(SELECT OGRENCIID FROM dbo.DEF_VELIKULLANICI_OGRENCILERI WHERE VELIID = " + Session["USERID"] + ")  GROUP BY ADI");
                    }
                        
                        
                        
                    @for (int i = 0; i < dtTable.Rows.Count; i++)
                        {
                            <tr>
                                <td>
                                    
                                    @dtTable.Rows[i]["ADI"]
                                </td>
                                <td style="color: #6b8e23; font-weight: bold">
                                    @dtTable.Rows[i]["YUKLENEN"] TL
                                </td>
                                <td style="color: #8b0000; font-weight: bold">
                                    @dtTable.Rows[i]["HARCAMA"] TL
                                </td>
                                <td style="color: #000080; font-weight: bold">
                                    @dtTable.Rows[i]["KALANBAKIYE"] TL
                                </td>

                            </tr>
                        }
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>