@extends('layouts.app')

@push('scripts')
    <script>
        jQuery(document).ready(function($) {
            $('#tabel-realisasi-pembelian').dataTable( {
                "ordering": false,
            });
        });
        
    </script>
@endpush

@section('content')
<div class="main-container">
    <div class="container-fluid">
        <div class="page-breadcrumb">
            <div class="row">
                <div class="col-md-7">
                    <div class="page-breadcrumb-wrap">

                        <div class="page-breadcrumb-info">
                            <h2 class="breadcrumb-titles"><a href="{{ url($url) }}">{{ $title }}</a></h2>
                            <ul class="list-page-breadcrumb">
                                <li><a href="#">Realisasi Pembelian</a>
                                </li>
                                <li class="active-page"><a href="{{ url($url) }}">{{ $title }}</a></li>
                            </ul>
                        </div>
                    </div>
                </div>
                <div class="col-md-5">
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-md-12">
                <!-- <div class="section-header">
                    <h2>Table with simple header <code>.matmix-dt</code></h2>
                    <p>
                        This table is well styled and included edit delete options. You can use it in any table and this table support all bootstrap table classes like<code>.table, .table-striped, .table-hover, .table-bordered</code>
                    </p>
                </div> -->
                <div class="box-widget widget-module">
                    <div class="widget-head clearfix">
                        <span class="h-icon"><i class="fa fa-table"></i></span>
                        <h4>Data {{ $title }}</h4>
                     
                        
                    </div>
                    <div class="widget-container">
                        <div class="widget-block">
                            <div class="row">
                                <div class="col-md-4">
                                                                        <a href="{{ url($url.'/cetak?type=html&menu='.$_GET['menu'].'&from='.$from.'&to='.$to.'&kd_supplier='.$g) }}" target="_blank"><img src="{{ asset('images/btn_print2.png') }}" height="18" border="0" title="Cetak ke Format HTML"/></a>
                                    | <a class="btn btn-default" href="{{ url($url.'/cetak?type=excel&menu='.$_GET['menu'].'&from='.$from.'&to='.$to.'&kd_supplier='.$g) }}" target="_blank">Export ke Excel</a>  | <a href="{{ url($url) }}" class="btn btn-sm btn-warning">Kembali</a>
                                </div>
                                <div class="col-md-8">
                                    <form class="form-horizontal">
                                        <input type="hidden"  value="">
                                        <input type="hidden" name="menu" value="{{ $_GET['menu'] }}">
                                        <div class="form-group">
                                            
                                            <div class=" col-md-3">
                                                <input type="date" name="from" class="form-control" placeholder="Dari Tanggal" value="{{ $from }}" required>
                                            </div>
                                            <div class=" col-md-3">
                                                <input type="date" name="to" class="form-control" placeholder="Sampai Tanggal" value="{{ $to }}" required>
                                            </div>
                                            <div class="col-md-4">
                                                <select name="kd_supplier" class="form-control select2">
                                                    <option value="">Pilih Semua</option>
                                                    @foreach($seconds as $supplier)
                                                        <option @if(isset($_GET['kd_supplier']) && $_GET['kd_supplier'] == $supplier->kd_supplier) selected @endif value="{{ $supplier->kd_supplier }}">{{ $supplier->nm_supplier }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                            <div class="col-md-2">
                                                <button class="btn btn-info">Tampil</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                                <!-- <div class="col-md-3">
                                    <form class="form-horizontal">
                                        <div class="form-group">
                                            <label class="col-md-6 control-label">Search:</label>
                                            <div class=" col-md-6">
                                                <input class="form-control" type="text" placeholder="Search" name="s" value="">
                                                <input type="hidden" name="menu" value="{{ $_GET['menu'] }}">
                                            </div>
                                        </div>
                                    </form>

                                </div> -->
                            </div>
                            <div class="table-responsive">
                                
                                <table class="table table-striped table-hover table-bordered matmix-dt" id="tabel-realisasi-pembelian">
                                    <thead>
                                        <tr>
                                           
                                            <th>
                                                No
                                            </th>
                                           
                                            <th>
                                                No Pembelian
                                            </th>
                                            <th>
                                                Supplier
                                            </th>
                                            <th>
                                                Tanggal Pembelian
                                            </th>
                                            <th>
                                                Tanggal Realisasi
                                            </th>
                                            <th>
                                                Prepared By
                                            </th>
                                            <th>
                                                Approved By
                                            </th>
                                            <th>
                                                Reviewed By
                                            </th>
                                            <th >
                                                Keterangan
                                            </th>
                                            
                                           
                                  
                                        </tr>
                                    </thead>
                                    <tbody>
                                                                                                                        @foreach($datas as $data)
                                            <tr>
                                              
                                                <td>
                                                    {{ $no++ }}
                                                </td>
                                                
                                                <td>
                                                    {{ $data->no_pembelian }}
                                                </td>

                                                
                                                
                                                <td>
                                                    {{ $data->pembelian->supplier->nm_supplier }}
                                                </td>

                                                <td>
                                                    {{ $data->pembelian->tgl_pembelian }}
                                                </td>

                                                <td>
                                                    {{ $data->tgl_realisasi }}
                                                </td>

                                                <td>
                                                    {{ $data->prepared->name }}
                                                </td>

                                                <td>
                                                    {{ ($data->approved->name) ?? "-"  }}
                                                </td>

                                                <td>
                                                    {{ ($data->reviewed->name) ?? "-"  }}
                                                </td>

                                                <td>
                                                    {{ $data->keterangan }}
                                                </td>
                                               
                                                
                                               
                                            </tr>
                                            <tr style="background-color: #e0e0e0;color:black;font-weight: bold;">
                                                <td></td>
                                                <td></td>
                                                <td>Kode Barang</td>
                                                <td>Nama Barang</td>
                                                <td>Harga</td>
                                                <td>Jumlah</td>
                                                <td>Disc</td>
                                                <td>Total</td>
                                                <td></td>
                                            </tr>
                                            @foreach($data->pembelian->detail as $detail)
                                                <br />
<b>Warning</b>:  Undefined variable $detail in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "harga_barang" on null in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "harga_beli" on null in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Undefined variable $detail in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "harga_barang" on null in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "harga_beli" on null in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Undefined variable $detail in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "diskon" on null in <b>/home/aplikasiposinfo/public_html/hayyumart.com/resources/views/laporan/pembelian/realisasi_pembelian.blade.php</b> on line <b>206</b><br />
                                                <tr style="background-color: #e0e0e0;color:black;">
                                                    <td></td>
                                                    <td></td>
                                                    <td>{{ $detail->harga_barang->kd_barang }}</td>
                                                    <td>{{ $detail->harga_barang->barang->nm_barang }}</td>
                                                    <td>Rp.{{ number_format($detail->harga_barang->harga_beli) }}</td>
                                                    <td>{{ $detail->jumlah }}</td>
                                                    <td>{{ $detail->diskon }}%</td>
                                                    <td >Rp.{{ number_format($hargaDiskon * $detail->jumlah) }}</td>
                                                    <td></td>
                                                </tr>
                                                @php
                                                    $gttl += $hargaDiskon * $detail->jumlah;
                                                    $ttlb += $detail->jumlah;
                                                @endphp
                                            @endforeach
                                        @endforeach
                                        
                                    </tbody>
                                    
                                        <tfoot>
                                            <tr style="background-color: #e0e0e0;color:black;font-weight: bold;">
                                                <td colspan="7" align="right">
                                                    <b>Grand Total : </b>
                                                </td>
                                                <td colspan="2">
                                                    Rp. {{ number_format($gttl) }}
                                                </td>
                                            </tr>
                                            <tr style="background-color: #e0e0e0;color:black;font-weight: bold;">
                                                <td colspan="7" align="right">
                                                    <b>Total Qty : </b>
                                                </td>
                                                <td colspan="2">
                                                    {{ $ttlb }}
                                                </td>
                                            </tr>
                                        </tfoot>
                                    
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

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



@endsection