@extends('layouts/pos_layout')
@section('title', '| Stock Update System')
@section('content')
<style>
    .page-item.active .page-link {
        background-color: lightgrey !important;
        border: 1px solid black;
    }

    .page-link {
        color: black !important;
    }

    .table.table-condensed>thead>tr>td,
    .table.table-condensed>tbody>tr>td,
    .table.table-condensed>tfoot>tr>td,
    .table.table-condensed>thead>tr>th,
    .table.table-condensed>tbody>tr>th,
    .table.table-condensed>tfoot>tr>th {
        padding: 5px 3px !important;
        font-size: 11px !important;
        border: 1px solid #dbdbdb !important;

    }

    .table thead tr th {
        font-size: 11px !important;
    }

    tr.footerrow {
        font-weight: bold;
    }

    p.text-center.reportHeading {
        font-size: 13px;
    }
    @media only screen and (max-width: 1320px) {

        .select2-container {
            min-width: 100% !important;
            height: 33px;
            width: 13vw !important;
        }
    }
</style>

<div class="row page-wrap ">
    <div class="col-md-12">
        <div class="" style="">
            <div class=" ">


                <div class="panel panel-default" style="background-color:#708090;">
                    <div class="panel-heading" style="padding-bottom:0px">
                        <div class="panel-title">
                            <h2>DATE WISE STOCK REPORT</h2>
                        </div>
                        <div class="panel-options">
                            <a href="" class="btn btn-info pull-right addViewBtn printIcon" id="printIcon">
                                <i class="glyphicon glyphicon-plus-sign addIcon"></i>Print
                            </a>
                        </div>
                    </div>


                    <div class="panel-body panelBodyView printIcon" id="printDiv">
                        @php
                        $options = ['' => 'Select any'];
                        $status_options = ['*' => 'All','1' => 'Approve','0' => 'Pending'];

                        $viewOptions = ['' => 'Select any'];
                        $viewStatus_options = ['1' => 'Without Zero','0' => 'With Zero'];

                        $purchaseNo = $options + DB::table('pos_purchases')->pluck('purchase_no','purchase_no')->all();
                        $chalanNo = $options + DB::table('pos_purchases')->pluck('invoice_no','invoice_no')->all();
                        $brands = $options + DB::table('pos_product_brands')->pluck('name','id')->all();
                        $products = $options + DB::table('pos_products')->pluck('name','id')->all();

                        $searchElements = [
                        ['element' => 'report_level','showAll'=>'no'],
                        ['element' => 'branchId'],
                        ['element' => 'supplierId'],
                        ['element' => 'group_id'],
                        ['element' => 'category_id'],
                        ['element' => 'model_id'],
                        ['element' => 'dateTo'],
                        ];
                        @endphp
                        @include('partials.searchPanel.main', ['searchElements' => $searchElements])

                        <div class="row vert-offset-top-2" id="stockReportPdf">

                            <style>
                                @media print {

                                    #stockReportPdf {
                                        visibility: visible;
                                        overflow-x: unset;
                                    }

                                    .text-nowrap {
                                        white-space: normal;
                                    }

                                    table th {
                                        border-top: 1px solid red !important;
                                    }

                                    .table thead tr th {
                                        font-size: 11px !important;
                                        border: 1px solid #474444 !important;
                                        font-weight: bold;
                                    }

                                    .table thead tr td {
                                        border: 1px solid #848484 !important;
                                    }

                                    .table.table-condensed>tbody>tr>td {
                                        border: 1px solid #848484 !important;
                                        color: #000 !important;
                                        padding: 5px 2px !important;
                                        font-size: 11px !important;
                                    }

                                    .table.table-condensed>tfoot>tr>th {
                                        border: 1px solid #827a7a !important;
                                        border-left: 1px solid #827a7a !important;
                                        border-right: 1px solid #827a7a !important;
                                    }

                                    tr.footerrow {
                                        font-weight: bold;
                                    }

                                    p.text-center.reportHeading {
                                        font-size: 15px;
                                    }
                                }
                            </style>
                            <p class="text-center reportHeading">
                            <span class="companyNameData" style="color:#fff;"><b> {{$data['company']->name}} </b></span><br>
                                <span style="color:#fff;font-size:11px;"><b>{{$data['company']->address}}</b></span><br>
                                <span style="color:#fff;"><b>Date Wise Stock Report</b></span><br>
                                <span style="color:#fff;"><b><span id="reportlevelName">Branch Name: </span></b></span> <span id="brnachName" style="color:#fff;"></span><br>
                                <span style="color:#fff;"><b>As on:</b></span><span id="daterange" style="color:#fff;"></span><br>
                            </p>

                            <p class="text-right" style="color:#fff;">Printed Date: {{date('d-m-Y')}}</p>
                            <table class="table table-striped table-bordered table-condensed first-col-dark dataTable no-footer" cellpadding="0" cellspacing="0" width="100">
                                <thead>
                                    <tr>
                                        <th width="0"><b>SL No</b></th>
                                        <th class="text-nowrap"><b>Purchase Date</b></th>
                                        <th class="text-nowrap"><b>Product Name</b></th>
                                        <th class="text-nowrap"><b>Product Brand</b></th>
                                        <th class="text-nowrap"><b>Model Number</b></th>
                                        <th class="text-nowrap"><b>Pre Barcode</b></th>
                                        <th class="text-nowrap"><b>Barcode</b></th>
                                        <th class="text-nowrap"><b>PID/EMEI Number</b></th>
                                        <th class="text-nowrap"><b>Cost Price (Tk)</b></th>
                                        <th class="text-nowrap"><b>Action</b></th>
                                    </tr>

                                </thead>
                                <tbody id="table_data">
                                </tbody>
                                <tfoot align="right" id="table_footer_data">
                                </tfoot>
                            </table>

                            <div class="row userInfoMainDiv" style="padding: 100px 15px 5px 15px; ">
                                <table class="" id="" style="color:black;font-size: 12px; font-weight: bold; width:100%">
                                    <tbody>
                                        <tr>
                                            <td style="text-align:left;  width: 25%">Prepared By</td>
                                            <td style="text-align:center;  width: 20%">Verified By</td>
                                            <td style="text-align:right; width: 25%">Reviewed By</td>
                                            <td style="text-align:right;">Approved By</td>
                                        </tr>
                                    </tbody>
                                </table>

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

<script>
    $(document).ready(function() {
        $("#fillAreaId").change(function(event) {
            var areaName = $('#fillAreaId option:selected').text();
            $('#reportlevelName').html("Area Name: ");
            $('#brnachName').html(areaName);
        });
        $("#fillZoneId").change(function(event) {
            var zoneName = $('#fillZoneId option:selected').text();
            $('#reportlevelName').html("Zone Name: ");
            $('#brnachName').html(zoneName);
        });
        $("#fillRegionId").change(function(event) {
            var regionName = $('#fillRegionId option:selected').text();
            $('#reportlevelName').html("Region Name: ");
            $('#brnachName').html(regionName);
        });

        $("#fillBranchId").change(function(event) {
            var branchName = $('#fillBranchId option:selected').text();
            if (branchName != '') {
                $('#reportlevelName').html("Branch Name: ");
                $('#brnachName').html(branchName);
            } else {
                $('#reportlevelName').html("Branch Name: ");
                $('#brnachName').html("ALL");
            }

        });

        $('form').submit(function(event) {
            event.preventDefault();
            $('#daterange').html('');
            $('#table_footer_data').html('');
            // for as on date
            var datehtml = '';
            var branchhtml = '';
            var dateTo = $('#fillDateTo').val();
            datehtml = dateTo;
            $('#daterange').html(datehtml);

            $('#loadingModal').show();
            var form = $('form').serialize();
            $('#table_data').html('');
            //check date is selected or not
            var enddate = $('#fillDateTo').val();
            if (enddate == "") {

                $('#loadingModal').hide();
                Swal.fire({
                    icon: 'error',
                    title: 'Please select  end date first!',
                    showConfirmButton: true,
                })
                return false;
            }

            $.ajax({
                type: 'post',
                url: '{{ Request::url() }}',
                data: $('form').serialize(),
                dataType: 'json',
                success: function(_response) {
                    //console.log(_response.data);
                    $('#loadingModal').hide();
                    if (_response.responseTitle == 'success') {
                        var finalToalAmount = 0;
                        var finalToalQuantity = 0;
                        var serial = 0;
                        $.each(_response.data, function(key, SingleBranchValue) {

                            var html = '';
                            var totalCostAmount = 0;
                            $.each(SingleBranchValue, function(key, value) {
                                serial++;
                                html = '<tr>';
                                html += '<td>' + serial + ' </td>';
                                html += '<td  style="text-align:center"> ' + value.view_purchase_date + ' </td>';
                                html += '<td  style="text-align:center"> ' + value.view_product_name + ' </td>';
                                html += '<td  style="text-align:center"> ' + value.view_brand_name + '  </td>';
                                html += '<td  style="text-align:center"> ' + value.view_model_name + '  </td>';
                                html += '<td  style="text-align:center"> ' + value.view_pre_barcode + '  </td>';
                                html += '<td  style="text-align:center"> ' + value.view_barcode + '  </td>';
                                html += '<td  style="text-align:center"> ' + value.view_barcode_serial + '  </td>';
                                html += '<td  style="text-align:right"> ' + zerocheck(value.view_cost_price) + '  </td>';
                                html += '<td  style="text-align:right"><input name="cost_price_for_update" id="cost_price_for_update_' + value.id + '"/><a href="javascript:;" data-id=' + value.id + ' data-openingstockid=' + value.opening_stock_id + ' data-branchid=' + value.branch_id + ' data-viewproductid=' + value.view_product_id + ' data-viewbarcode=' + value.view_barcode + ' data-viewcostprice=' + value.view_cost_price + ' class="btn btn-xs btn-info update-action"><i class="fa fa-pencil" aria-hidden="true"></i></a></td>';
                                html += '</tr> ';

                                totalCostAmount += parseFloat(value.view_cost_price);
                                $('#table_data').append(html);

                            });
                            html1 = '<tr class="footerrow">';
                            html1 += '<td style="text-align:center" class="text-nowrap" colspan="8">' + _response.branch[key] + ' ( Total Quantity ' + SingleBranchValue.length + ' ) </td>';
                            html1 += '<td style="text-align:right" >' + zerocheck(totalCostAmount) + '</td>';
                            html1 += '</tr> ';
                            $('#table_data').append(html1);

                            finalToalAmount += parseFloat(totalCostAmount);
                            finalToalQuantity += parseFloat(SingleBranchValue.length);
                        });
                        html2 = '<tr class="footerrow">';
                        html2 += '<td style="text-align:center" class="text-nowrap" colspan="9">Total Quantity ( ' + finalToalQuantity + ' ), Total Amount </td>';
                        html2 += '<td style="text-align:right" >' + zerocheck(finalToalAmount) + '</td>';
                        html2 += '</tr> ';

                        $('#table_data').append(html2);


                    } else {
                        $('#loadingModal').hide();
                        Swal.fire({
                            icon: 'error',
                            title: 'Something went wrong!',
                            showConfirmButton: true
                        })
                        return false;
                    }

                },
                error: function(_response) {
                    toastr.error('_response.errors');
                    $('#loadingModal').hide();

                }
            });
        });

        //update function
        $(document).on('click', '.update-action', function() {

            Swal.fire({
                title: 'Are you sure?',
                text: "Once update you won't be able to revert this!",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#d33',
                cancelButtonColor: '#7e7979',
                confirmButtonText: 'Yes, update it!'
            }).then((result) => {
                if (result.isConfirmed) {

                    var id = $(this).data('id');
                    var cost_price_for_update = $('#cost_price_for_update_'+id).val();

                    $.ajax({
                        type: 'post',
                        url: '{{route("pos_product_opening_stock_update_barcode_costprice")}}',
                        data: {
                            '_token': $('input[name=_token]').val(),
                            'id': id,
                            'opening_stock_id': $(this).data('openingstockid'),
                            'branch_id': $(this).data('branchid'),
                            'product_id': $(this).data('viewproductid'),
                            'product_barcode': $(this).data('viewbarcode'),
                            'product_cost_price': $(this).data('viewcostprice'),
                            'cost_price_for_update': cost_price_for_update
                        },
                        success: function(_response) {

                            if (_response.responseTitle == 'success') {
                                Swal.fire({
                                    icon: 'success',
                                    title: 'Updated!',
                                    text: 'This data has been updated.',
                                    showConfirmButton: false,
                                    timer: 1500
                                });
                                $('#cost_price_for_update_'+id).val('');


                            } else {
                                Swal.fire({
                                    icon: 'error',
                                    title: 'Failed to update!',
                                    text: 'This data has not been updated.',
                                    showConfirmButton: true,
                                })
                            }
                        }
                    });



                }
            })


        });

    });

    function zerocheck(value) {

        if (value == 0) {
            return "-";
        } else {
            return value.toLocaleString("en-IN", {
                minimumFractionDigits: 2,
                maximumFractionDigits: 2
            });
        }

    }



    $("#printIcon").click(function() {

        var printContents = document.getElementById("stockReportPdf").innerHTML;
        var printStyle = '<style>@page {size: auto;margin: 0mm;margin-top:20px;margin-bottom:20px;margin-right:10px;} @media print  { .table thead tr th {white-space: normal;} #stockReportPdf {width: 100%;height: auto;overflow: visible;} }</style>';
        var printDiv = '<div id="order-details-wrapper" style="margin-top:25px;padding-left:10px;padding-right:10px;">' + printStyle + printContents + '</div>';

        document.body.innerHTML = printDiv;

        var originalContents = document.body.innerHTML;
        window.print();
        document.body.innerHTML = originalContents;
        // location.reload();

    });
</script>
@endsection