@extends("layouts.default")

@section("title", trans("lang.budget_report"))

@section("block-header")
    @lang('lang.budget_report')
@stop

@section("breadcrumb")
    @parent
    <li class="breadcrumb-item active">
        @lang('lang.budget_report')
    </li>
@stop
@section("content")


<div class="row clearfix">
    <div class="col-lg-6 col-md-6 col-sm-6">
        <div class="card">
            <div class="card-body">
                <p><strong>RUSH-IT Indicators Tracking</strong></p>
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th>Item</th>
                            <th>Indicator</th>
                            <th>Target</th>
                            <th>Achievement</th>
                            <th>Achievement %</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td class="text-center">1</td>
                            <td>Total Farmer Register</td>
                            <td class="text-right">{{number_format($register_target)}}</td>
                            <td class="text-right">{{number_format($register_achievement)}}</td>
                            <td class="text-right">{{number_format($register_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Male</td>
                            <td class="text-right">{{number_format($register_male_target)}}</td>
                            <td class="text-right">{{number_format($register_male_achievement)}}</td>
                            <td class="text-right">{{number_format($register_male_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Female</td>
                            <td class="text-right">{{number_format($register_female_target)}}</td>
                            <td class="text-right">{{number_format($register_female_achievement)}}</td>
                            <td class="text-right">{{number_format($register_female_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Youth</td>
                            <td class="text-right">{{number_format($register_youth_target)}}</td>
                            <td class="text-right">{{number_format($register_youth_achievement)}}</td>
                            <td class="text-right">{{number_format($register_youth_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td class="text-center">2</td>
                            <td>Total Proposal Approved</td>
                            <td class="text-right">{{number_format($submit_proposal_target)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_achievement)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Male</td>
                            <td class="text-right">{{number_format($submit_proposal_male_target)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_male_achievement)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_male_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Female</td>
                            <td class="text-right">{{number_format($submit_proposal_female_target)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_female_achievement)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_female_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Youth</td>
                            <td class="text-right">{{number_format($submit_proposal_youth_target)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_youth_achievement)}}</td>
                            <td class="text-right">{{number_format($submit_proposal_youth_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td class="text-center">3</td>
                            <td>Total Farmer Received Input</td>
                            <td class="text-right">{{number_format($received_input_target)}}</td>
                            <td class="text-right">{{number_format($received_input_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Male</td>
                            <td class="text-right">{{number_format($received_input_male_target)}}</td>
                            <td class="text-right">{{number_format($received_input_male_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_male_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Female</td>
                            <td class="text-right">{{number_format($received_input_female_target)}}</td>
                            <td class="text-right">{{number_format($received_input_female_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_female_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Youth</td>
                            <td class="text-right">{{number_format($received_input_youth_target)}}</td>
                            <td class="text-right">{{number_format($received_input_youth_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_youth_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">ID Poor</td>
                            <td class="text-right">{{number_format($received_input_id_poor_target)}}</td>
                            <td class="text-right">{{number_format($received_input_id_poor_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_id_poor_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Non-ID Poor</td>
                            <td class="text-right">{{number_format($received_input_no_id_target)}}</td>
                            <td class="text-right">{{number_format($received_input_no_id_achievement)}}</td>
                            <td class="text-right">{{number_format($received_input_no_id_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td class="text-center">4</td>
                            <td>Total Budget By RUSH-IT</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_target, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_achievement, 2)}}</td>
                            <td class="text-right">{{number_format($rush_it_budget_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">ID Poor</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_id_poor_target, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_id_poor_achievement, 2)}}</td>
                            <td class="text-right">{{number_format($rush_it_budget_id_poor_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="pd-left-20">Non-ID Poor</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_no_id_target, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($rush_it_budget_no_id_achievement, 2)}}</td>
                            <td class="text-right">{{number_format($rush_it_budget_no_id_achievement_percent, 1) . "%"}}</td>
                        </tr>
                        <tr>
                            <td class="text-center">5</td>
                            <td>Total Budget Contribute by Farmers</td>
                            <td class="text-right">{{"$" . number_format($farmer_budget_target)}}</td>
                            <td class="text-right">{{"$" . number_format($farmer_budget_achievement, 2)}}</td>
                            <td class="text-right">{{number_format($farmer_budget_achievement_percent, 1) . "%"}}</td>
                        </tr>
                    </tbody>

                </table>
            </div>
        </div>
    </div>
    <div class="col-lg-6 col-md-6 col-sm-6">
        <div class="card">
            <div class="card-body">
                <div id="barchart_values" style="width: 100%; height: 400px;"></div>
            </div>
        </div>
        <!-- todo -->
        @if(auth()->user()->is_admin)
            <div class="card mrg-top-20">
                <div class="card-body">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th rowspan="2"></th>
                                <th colspan="2">Amoung Register Farmers</th>
                                <th colspan="2">Farmer Received Input</th>
                            </tr>
                            <tr>
                                <th>Video Learning</th>
                                <th>Chat with Expert</th>
                                <th>Video Learning</th>
                                <th>Chat with Expert</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>Male</td>
                                <td class="text-right">{{number_format($register_view_post_result->total_male)}}</td>
                                <td class="text-right">{{number_format($register_chat_result->total_male)}}</td>
                                <td class="text-right">{{number_format($received_view_post_result->total_male)}}</td>
                                <td class="text-right">{{number_format($received_chat_result->total_male)}}</td>
                            </tr>
                            <tr>
                                <td>Female</td>
                                <td class="text-right">{{number_format($register_view_post_result->total_female)}}</td>
                                <td class="text-right">{{number_format($register_chat_result->total_female)}}</td>
                                <td class="text-right">{{number_format($received_view_post_result->total_female)}}</td>
                                <td class="text-right">{{number_format($received_chat_result->total_female)}}</td>
                            </tr>
                            <tr>
                                <td>Youth</td>
                                <td class="text-right">{{number_format($register_view_post_result->total_youth)}}</td>
                                <td class="text-right">{{number_format($register_chat_result->total_youth)}}</td>
                                <td class="text-right">{{number_format($received_view_post_result->total_youth)}}</td>
                                <td class="text-right">{{number_format($received_chat_result->total_youth)}}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        @endif
    </div>
</div>

<div class="row clearfix mrg-top-5">
    <div class="col-lg-12 col-md-12 col-sm-12">
        <div class="card">
            <div class="card-body">
                <p><strong>RUSH-IT Target Tracking by Province</strong></p>
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th rowspan="2">Item</th>
                            <th rowspan="2">Province</th>
                            <th colspan="4">Target</th>
                            <th colspan="2">Farmer Register</th>
                            <th colspan="4">Proposal Received</th>
                            <th rowspan="2">Proposal Pending</th>
                            <th rowspan="2" class="total-needed">Proposal Needed</th>
                            <th colspan="4">Proposal Approved</th>
                            <th rowspan="2">Delivered Input</th>
                        </tr>
                        <tr>
                            <th>Farmer Register</th>
                            <th>ID Poor</th>
                            <th>Non-ID Poor</th>
                            <th>Total</th>
                            <th>Total</th>
                            <th>Total %</th>
                            <th>ID Poor</th>
                            <th>Non-ID Poor</th>
                            <th>Total</th>
                            <th>Total %</th>
                            <th>ID Poor</th>
                            <th>Non-ID Poor</th>
                            <th>Total</th>
                            <th>Total %</th>
                        </tr>
                    </thead>
                    <tbody>
                                                @foreach($by_provine_target as $k => $v)
                                                        <tr>
                                <td class="text-center">{{$ind}}</td>
                                <td>{{@$arr_provinces[$k]}}</td>
                                <td class="text-right">{{$by_province_target}}</td>
                                <td class="text-right">{{number_format($id_poor_target)}}</td>
                                <td class="text-right">{{number_format($no_poor_target)}}</td>
                                <td class="text-right">{{number_format($total_target)}}</td>
                                <td class="text-right">{{number_format($total_register_farmer)}}</td>
                                <td class="text-right">{{number_format($register_farmer_percentage, 1) . "%"}}</td>
                                <!-- received -->
                                <td class="text-right {{$id_poor_received_class}}">{{number_format($id_poor_received_achievement)}}</td>
                                <td class="text-right {{$no_poor_received_class}}">{{number_format($non_id_received_achievement)}}</td>
                                <td class="text-right {{$total_received_class}}">{{number_format($total_received_achievement)}}</td>
                                <td class="text-right">{{number_format($total_received_achievement_percent, 1) . "%"}}</td>
                                <!-- pending -->
                                <td class="text-right">{{number_format($total_pending)}}</td>
                                <!-- needed -->
                                <td class="text-right total-needed">{{number_format($total_needed)}}</td>
                                <!-- approved -->
                                <td class="text-right {{$id_poor_class}}">{{number_format($id_poor_achievement)}}</td>
                                <td class="text-right {{$no_poor_class}}">{{number_format($non_id_achievement)}}</td>
                                <td class="text-right {{$total_class}}">{{number_format($total_achievement)}}</td>
                                <td class="text-right {{$total_achievement_class}}">{{number_format($total_achievement_percent, 1) . "%"}}</td>
                                <td class="text-right">{{number_format($total_delivered_input)}}</td>
                            </tr>
                        @endforeach
                        <tr>
                            <td colspan="2" class="text-right">Total</td>
                            <td class="text-right">{{number_format($sum_register_farmer_target)}}</td>
                            <td class="text-right">{{number_format($received_input_id_poor_target)}}</td>
                            <td class="text-right">{{number_format($received_input_no_id_target)}}</td>
                            <td class="text-right">{{number_format($received_input_target)}}</td>
                            <td class="text-right">{{number_format($sum_register_farmer)}}</td>
                            <td class="text-right">
                                {{number_format(($sum_register_farmer/$sum_register_farmer_target*100), 1) . "%"}}
                            </td>
                            <!-- received -->
                            <td class="text-right">{{number_format($sum_id_poor_received)}}</td>
                            <td class="text-right">{{number_format($sum_non_id_received)}}</td>
                            <td class="text-right">{{number_format($sum_total_received)}}</td>
                            <td class="text-right">{{number_format(($sum_total_received/$received_input_target*100), 1) . "%"}}</td>
                            <!-- pending -->
                            <td class="text-right">{{number_format($sum_pending)}}</td>
                            <!-- needed -->
                            <td class="text-right total-needed">{{number_format($sum_needed)}}</td>
                            <!-- approved -->
                            <td class="text-right">{{number_format($sum_id_poor)}}</td>
                            <td class="text-right">{{number_format($sum_non_id)}}</td>
                            <td class="text-right">{{number_format($sum_total)}}</td>
                            <td class="text-right">{{number_format(($sum_total/$received_input_target*100), 1) . "%"}}</td>
                            <td class="text-right">{{number_format($sum_delivered_input)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="row clearfix mrg-top-5">
    <div class="col-lg-12 col-md-12 col-sm-12">
        <div class="card">
            <div class="card-body">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th class="text-center" rowspan="2">Province</th>
                            <th class="text-center" colspan="5">Proposal Approved</th>
                            <th class="text-center" colspan="4">Budget</th>
                            <th class="text-center" colspan="2">Commodity</th>
                        </tr>
                        <tr>
                            <th class="text-center">Non-ID Poor</th>
                            <th class="text-center">ID Poor 1</th>
                            <th class="text-center">ID Poor 2</th>
                            <th class="text-center">Total ID Poor</th>
                            <th class="text-center">Total Proposal</th>
                            <th class="text-center">ID Poor</th>
                            <th class="text-center">Non ID Poor</th>
                            <th class="text-center">Total Budget</th>
                            <th class="text-center">Farmer Contribution</th>
                            <th class="text-center">Chicken</th>
                            <th class="text-center">Vegetable</th>
                        </tr>
                    </thead>
                    <tbody>
                                                @foreach($rush_it_provinces as $rP)
                                                        <tr>
                                <td>{{$p_name}}</td>
                                <td class="text-right">{{$total_no_id_poor}}</td>
                                <td class="text-right">{{$total_id_poor_1}}</td>
                                <td class="text-right">{{$total_id_poor_2}}</td>
                                <td class="text-right">{{$total_id_poor}}</td>
                                <td class="text-right">{{$total_proposal}}</td>
                                <td class="text-right">{{"$" . number_format(($budget_id_poor_1 + $budget_id_poor_2), 2)}}</td>
                                <td class="text-right">{{"$" . number_format($budget_no_id_poor, 2)}}</td>
                                <td class="text-right">{{"$" . number_format(($budget_id_poor_1 + $budget_id_poor_2 + $budget_no_id_poor), 2)}}</td>
                                <td class="text-right">{{"$" . number_format(($contribution_poor_id_1 + $contribution_poor_id_2 + $contribution_no_id_poor), 2)}}</td>
                                <td class="text-right">{{$total_chicken}}</td>
                                <td class="text-right">{{$total_vegetable}}</td>
                            </tr>
                        @endforeach
                        <tr>
                            <td>{{"សរុប"}}</td>
                            <td class="text-right">{{$sum_proposal_non_id_poor}}</td>
                            <td class="text-right">{{$sum_proposal_poor_id_1}}</td>
                            <td class="text-right">{{$sum_proposal_poor_id_2}}</td>
                            <td class="text-right">{{$sum_proposal_total_poor_id}}</td>
                            <td class="text-right">{{$sum_proposal_total}}</td>
                            <td class="text-right">{{"$" . number_format($sum_budget_id_poor, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($sum_budget_non_id_poor, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($sum_budget_total, 2)}}</td>
                            <td class="text-right">{{"$" . number_format($sum_budget_farmer_contribution, 2)}}</td>
                            <td class="text-right">{{$sum_commodity_chicken}}</td>
                            <td class="text-right">{{$sum_commodity_vegetable}}</td>
                        </tr>
                            
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<style type="text/css">
    .table thead th { vertical-align: middle !important; text-align: center; }
    table { border-collapse: collapse; }
    .mrg-top-5 { margin-top: 5px; }
    .mrg-top-20 { margin-top: 20px; }
    .pd-left-20 { padding-left: 20px !important; }
    .total-needed { background-color: #fffacd; }
</style>


@endsection

@section('script')
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
// chart
var chart_data_json = {!! $chart_data_json !!};
google.charts.load("current", {packages:["corechart"]});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
    var data = google.visualization.arrayToDataTable(chart_data_json);

    var view = new google.visualization.DataView(data);
    view.setColumns([0, 1,
                    {   calc: "stringify",
                        sourceColumn: 1,
                        type: "string",
                        role: "annotation" },
                    2]);

    var options = {
        title: "",
        bar: { groupWidth: "95%" },
        legend: { position: "none" },
        chartArea:{ width:'80%', left:80, right:0 }
    };
    var chart = new google.visualization.BarChart(document.getElementById("barchart_values"));
    chart.draw(view, options);
}

$('.datepicker-1').bootstrapMaterialDatePicker({ format : 'DD MMMM YYYY', time: false });
const province_id = '{{old('province_id',@$province_id)}}';
const district_id = '{{old('district_id',@$district_id)}}';
if (province_id) {
    getDistrict(province_id, function (data) {
        if (data.id === Number(district_id)) {
            return 'selected="selected"'
        }
    });
}
const selectChangeStatus = $(".btn-change-status");
selectChangeStatus.on('change', function () {
    const status = $(this).val();
    const url = $(this).attr("data-url");
    const search_text = $(".search_text").val();
    const token = '{{ csrf_token() }}';
    $.ajax({
        method: "POST",
        url: url,
        data: {
            status: status, search_text: search_text, '_token': token
        },
        success: function () {
            console.log('success');
        },
        errors: function (error) {
            console.error(error);
        }
    })
});
// btn-view-list
$('.btn-view-list').click(function(e){
    e.preventDefault();
    var me = $(this),
        verified_by = me.attr('data-id');
    var frm = $('#formFilter'),
        action = "{{route('proposal.filter')}}";
    frm.find('input#verified_by').val(verified_by);
    frm.attr('action', action).submit();
});

</script>
@stop