Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: dispatch-parcel-report.blade.php

@extends('layouts.app')

@section('custom-css')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css">
@endsection

@section('content')

<div class="page-body"> 
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h5>Dsipatch Parcel Report</h5>
                    <div class="text-right">
                        <button id="btnExport" onclick="fnExcelReport();" class="btn btn-primary">Export to Excel</button>
                    </div>
                </div>
                <div class="card-block">
                    <form action="{{route('DispatchParcelReport')}}" method="POST">
                        @csrf
                        <div class="row">
                            <div class="col-md-5">
                                <div class="form-group form-static-label form-default">
                                    <input type="date" name="date" id="date" class="form-control" required="required" value="<?php
                                    if (isset($_POST['date'])) {
                                        echo $_POST['date'];
                                    }
                                    ?>">
                                </div>
                            </div>
                            <div class="col-md-5">
                                <div class="form-group form-static-label form-default">
                                    <input type="date" name="to" id="to" class="form-control" required="required" value="<?php
                                    if (isset($_POST['to'])) {
                                        echo $_POST['to'];
                                    }
                                    ?>">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <button type="submit" class="btn btn-primary waves-effect waves-light" id="assign_parcel_to_rider">
                                    Submit
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="card-block">
    <div class="page-body display" id="printableArea">
        <div class="card">
            <div class="card-header">
                <h5>Dsipatch Parcel Report</h5>
            </div>
            <?php 
            if (isset($_POST['to']) && $_POST['date']) { ?>
                <div class="card-block table-border-style">
                    <div class="table-responsive">
                        <table class="table table-hover" id="example">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>DP Report Date</th>
                                    <th>Dispatch QTY</th>
                                    <th>Total Riders</th>
                                    <th>Avg. Parcels Per Rider</th>
                                    <th>Delivered</th>
                                    <th>Cancelled</th>
                                    <th>Re-Attempted</th>
                                    <th>Ratio</th>
                                    <th>Total Fuel Cost</th>
                                    <th>Fuel In Liters</th>
                                    <th>Avg. Fuel Per Rider Cost</th>
                                    <th>Avg. Fuel Per Rider In Liter</th>
                                    <th>Salary</th>
                                    <th>Incentive</th>
                                    <th>Total Cost</th>
                                    <th>Cost Per Parcel</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(!empty($reportSummary))
                                    @foreach($reportSummary as $data)
                                        <?php
                                            // average parcel ratio per rider
                                            if($data['dispatch_orders'] > 0 && $data['total_riders'] > 0){
                                                $avg_parcel_per_rider = round($data['dispatch_orders'] / $data['total_riders']);
                                            }else{
                                                $avg_parcel_per_rider = 0;
                                            }
                                            
                                            // delivered parcel ratio
                                            if($data['dispatch_orders'] > 0 && $data['delivered_orders'] > 0){
                                                $delivered_ratio = round(($data['delivered_orders'] / $data['dispatch_orders']) * 100, 0);
                                            }else{
                                                $delivered_ratio = 0;
                                            }

// Avergae fuel per rider
                                            if($data['total_fuel_cost'] > 0 && $data['total_riders'] > 0){
                                                $avg_fuel_per_rider = round($data['total_fuel_cost'] / $data['total_riders'], 2);
                                            }else{
                                                $avg_fuel_per_rider = 0;
                                            }

// Avergae fuel In liter per rider
                                            if($data['fuel_in_liters'] > 0 && $data['total_riders'] > 0){
                                                $avg_fuel_per_rider_in_liter = round($data['fuel_in_liters'] / $data['total_riders'], 2);
                                            }else{
                                                $avg_fuel_per_rider_in_liter = 0;
                                            }

//Total cost
                                            $totalCost = round($data['total_salary'] + $data['total_commission'] + $data['total_fuel_cost'], 2);

// Cost per parcel
                                            if($totalCost > 0 && $data['dispatch_orders'] > 0){
                                                $cost_per_parcel = round($totalCost / $data['dispatch_orders'], 0);
                                            }else{
                                                $cost_per_parcel = 0;
                                            }

$date = $data['date'];
                                        ?>
                                        <tr>
                                            <td></td>
                                            <td>{{ $date }}</td>
                                            <td>{{ $data['dispatch_orders'] }}</td>
                                            <td>{{ $data['total_riders'] }}</td>
                                            <td>{{ $avg_parcel_per_rider }}</td>
                                            <td>{{ $data['delivered_orders'] }}</td>
                                            <td>{{ $data['cancelled_orders'] }}</td>
                                            <td>{{ $data['reattempt_orders'] }}</td>
                                            <td>{{ $delivered_ratio }} %</td>
                                            <td>{{ round($data['total_fuel_cost'], 2) }}</td>
                                            <td>{{ $data['fuel_in_liters'] }}</td>
                                            <td>{{ $avg_fuel_per_rider }}</td>
                                            <td>{{ $avg_fuel_per_rider_in_liter }}</td>
                                            <td>{{ $data['total_salary'] }}</td>
                                            <td>{{ $data['total_commission'] }}</td>
                                            <td>{{ $totalCost }}</td>
                                            <td>{{ $cost_per_parcel}}</td>
                                        </tr>
                                    @endforeach
                                @endif
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="2" style="text-align:right">Total:</th>
                                    <th><span id="sum_dispatch_orders"></span></th> 
                                    <th>AVG <span id="sum_total_riders"></span></th> 
                                    <th>AVG <span id="sum_avg_parcel_per_rider"></span></th>
                                    <th><span id="sum_delivered_orders"></span></th> 
                                    <th><span id="sum_cancelled_orders"></span></th> 
                                    <th><span id="sum_reattempt_orders"></span></th> 
                                    <th>AVG <span id="sum_delivered_ratio"></span> %</th> 
                                    <th><span id="sum_total_fuel_cost"></span></th> 
                                    <th><span id="sum_fuel_in_liters"></span></th> 
                                    <th>AVG <span id="sum_avg_fuel_per_rider"></span></th> 
                                    <th>AVG <span id="sum_avg_fuel_per_rider_in_liter"></span></th> 
                                    <th><span id="sum_total_salary"></span></th> 
                                    <th><span id="sum_total_commission"></span></th> 
                                    <th><span id="sum_total_cost"></span></th> 
                                    <th>AVG <span id="sum_cost_per_parcel"></span></th> 
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            <?php  } ?>
        </div>
    </div>
</div>

@endsection

@section('custom-js')
<script type="text/javascript" src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
<SCRIPT language="javascript">

$(function () {
        /* Data Table */
        var table = $('#example').DataTable({
            'lengthMenu': [100, 250, 500, 1000, 5000, 10000],
            'pageLength': 100
        });
    });

let sum_dispatch_orders = 0,
        sum_total_riders = 0,
        sum_avg_parcel_per_rider = 0,
        sum_delivered_orders = 0,
        sum_cancelled_orders = 0,
        sum_reattempt_orders = 0,
        sum_delivered_ratio = 0,
        sum_total_fuel_cost = 0,
        sum_avg_fuel_per_rider = 0,
        sum_total_salary = 0,
        sum_total_commission = 0,
        sum_total_cost = 0,
        sum_cost_per_parcel = 0;
        sum_fuel_in_liters = 0;
        sum_avg_fuel_per_rider_in_liter = 0;

const numRows = table.rows.length - 2; // Exclude header and footer rows

for (let i = 1; i <= numRows; i++) {
        const cells = table.rows[i].cells;

sum_dispatch_orders += parseFloat(cells[2].innerText) || 0;
        sum_total_riders += parseFloat(cells[3].innerText) || 0;
        sum_avg_parcel_per_rider += parseFloat(cells[4].innerText) || 0;
        sum_delivered_orders += parseFloat(cells[5].innerText) || 0;
        sum_cancelled_orders += parseFloat(cells[6].innerText) || 0;
        sum_reattempt_orders += parseFloat(cells[7].innerText) || 0;
        sum_delivered_ratio += parseFloat(cells[8].innerText) || 0;
        sum_total_fuel_cost += parseFloat(cells[9].innerText) || 0;
        sum_fuel_in_liters += parseFloat(cells[10].innerText) || 0;
        sum_avg_fuel_per_rider += parseFloat(cells[11].innerText) || 0;
        sum_avg_fuel_per_rider_in_liter += parseFloat(cells[12].innerText) || 0;
        sum_total_salary += parseFloat(cells[13].innerText) || 0;
        sum_total_commission += parseFloat(cells[14].innerText) || 0;
        sum_total_cost += parseFloat(cells[15].innerText) || 0;
        sum_cost_per_parcel += parseFloat(cells[16].innerText) || 0;
    }

// Set sums
    document.getElementById("sum_dispatch_orders").textContent = sum_dispatch_orders.toFixed(0);
    document.getElementById("sum_total_riders").textContent = (sum_total_riders/numRows).toFixed(0);
    document.getElementById("sum_delivered_orders").textContent = sum_delivered_orders.toFixed(0);
    document.getElementById("sum_cancelled_orders").textContent = sum_cancelled_orders.toFixed(0);
    document.getElementById("sum_reattempt_orders").textContent = sum_reattempt_orders.toFixed(0);
    document.getElementById("sum_total_fuel_cost").textContent = sum_total_fuel_cost.toFixed(0);
    document.getElementById("sum_total_salary").textContent = sum_total_salary.toFixed(0);
    document.getElementById("sum_total_commission").textContent = sum_total_commission.toFixed(0);
    document.getElementById("sum_total_cost").textContent = sum_total_cost.toFixed(0);
    document.getElementById("sum_fuel_in_liters").textContent = sum_fuel_in_liters.toFixed(2);

// Set averages
    document.getElementById("sum_avg_parcel_per_rider").textContent = (sum_avg_parcel_per_rider / numRows).toFixed(0);
    document.getElementById("sum_delivered_ratio").textContent = (sum_delivered_ratio / numRows).toFixed(0);
    document.getElementById("sum_avg_fuel_per_rider").textContent = (sum_avg_fuel_per_rider / numRows).toFixed(0);
    document.getElementById("sum_cost_per_parcel").textContent = (sum_cost_per_parcel / numRows).toFixed(0);
    document.getElementById("sum_avg_fuel_per_rider_in_liter").textContent = (sum_avg_fuel_per_rider_in_liter / numRows).toFixed(2);
</script>

@endsection

Name	Type	Actions
PickupRider	Directory
area	Directory
booking	Directory
cashier	Directory
city	Directory
commission	Directory
complain	Directory
flyer	Directory
fuel	Directory
packing	Directory
parcel-limit	Directory
pickup_request	Directory
remarks	Directory
reverse_pickup	Directory
rider	Directory
salary	Directory
staff	Directory
subArea	Directory
tagline	Directory
timing	Directory
vendor	Directory
weight	Directory
zone	Directory
admin_dashboard.blade.php	File
agging-report.blade.php	File
cancel_all.blade.php	File
daily-fuel-sheet.blade.php	File
delivery-ratio.blade.php	File
dispatch-parcel-report.blade.php	File
edit-fuel-sheet.blade.php	File
edit-verified-sheet.blade.php	File
error_log	File
pra_report.blade.php	File
vendor-cod.blade.php	File
vendor-tax-report.blade.php	File
verified-daily-fuel-sheet.blade.php	File
weekly-fuel-sheet.blade.php	File