000

<?php $__env->startSection('content'); ?>
<div class="container-fluid py-4" style="margin-top: -37px;">
    <div class="main-card shadow-lg border-0 rounded-xl overflow-hidden">
        <div class="card-header text-white py-4 position-relative" style="background: linear-gradient(135deg, #2d5016 0%, #6b8e23 50%, #8fbc34 10%); height: 74px;">
            <div class="header-overlay"></div>
            <div class="d-flex align-items-center justify-content-center position-relative">
                <i class="fas fa-chart-line me-3 fs-3"></i>
                <h3 class="mb-0">Production Analysis Dashboard</h3>
            </div>
            <div class="header-decoration"></div>
        </div>

<div class="card-body p-0">
            <div class="filter-section p-4 bg-gradient-light">
                <div class="filter-header mb-3">
                    <h5 class="text-primary fw-bold mb-0">
                        <i class="fas fa-filter me-2"></i>Filter Options
                    </h5>
                    <small class="text-muted">Select your criteria to generate the report</small>
                </div>

<form method="GET" class="filter-form">
                    <div class="row g-3">
                        
                        <?php if($loggedInUserRole == 1): ?>
                            <div class="col-lg-3 col-md-4 col-sm-6">
                                <div class="form-group-enhanced">
                                    <label for="site_id" class="form-label">
                                        <i class="fas fa-map-marker-alt me-1"></i>Select Site
                                    </label>
                                    <select name="site_id" id="site_id" class="form-select form-select-enhanced">
                                        <?php $__currentLoopData = $sites; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $id => $name): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                            <option value="<?php echo e($id); ?>" <?php echo e((isset($sel['selectedSiteId']) && $sel['selectedSiteId'] == $id) ? 'selected' : ''); ?>>
                                                <?php echo e($name); ?>

</option>
                                        <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                    </select>
                                </div>
                            </div>
                        <?php else: ?>
                            
                            <div class="col-lg-3 col-md-4 col-sm-6">
                                <div class="form-group-enhanced">
                                    <label for="site_id" class="form-label">
                                        <i class="fas fa-map-marker-alt me-1"></i>Location
                                    </label>
                                    <?php $__currentLoopData = $sites; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $id => $name): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                        <input type="text" class="form-control form-control-enhanced" value="<?php echo e($name); ?>" disabled>
                                        <input type="hidden" name="site_id" value="<?php echo e($id); ?>">
                                    <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                </div>
                            </div>
                        <?php endif; ?>

<div class="col-lg-3 col-md-4 col-sm-6">
                            <div class="form-group-enhanced">
                                <label for="block" class="form-label">
                                    <i class="fas fa-th-large me-1"></i>Block Select
                                </label>
                                <select name="block" id="block" class="form-select form-select-enhanced">
                                    <option value="">Select Block</option>
                                    <?php $__currentLoopData = $blocks; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $block): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                        <option value="<?php echo e($block); ?>" <?php echo e($sel['block'] == $block ? 'selected' : ''); ?>><?php echo e($block); ?></option>
                                    <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                </select>
                            </div>
                        </div>

<div class="col-lg-3 col-md-4 col-sm-6">
                            <div class="form-group-enhanced">
                                <label for="plot" class="form-label">
                                    <i class="fas fa-map me-1"></i>Plot Select
                                </label>
                                <select name="plot" id="plot" class="form-select form-select-enhanced">
                                    <option value="">Select Plot</option>
                                    <?php if(isset($sel['block']) && !empty($sel['block']) && isset($plotsByBlock[$sel['block']])): ?>
                                        <?php $__currentLoopData = $plotsByBlock[$sel['block']]; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $plot): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                            <option value="<?php echo e($plot); ?>" <?php echo e($sel['plot'] == $plot ? 'selected' : ''); ?>><?php echo e($plot); ?></option>
                                        <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                    <?php endif; ?>
                                </select>
                            </div>
                        </div>

<div class="col-lg-3 col-md-4 col-sm-6">
                            <div class="form-group-enhanced">
                                <label class="form-label">
                                    <i class="fas fa-calendar-alt me-1"></i>Date Range
                                </label>
                                <div class="date-range-wrapper">
                                    <input type="date" name="from" value="<?php echo e($sel['from']); ?>" class="form-control form-control-enhanced">
                                    <span class="date-separator">to</span>
                                    <input type="date" name="to" value="<?php echo e($sel['to']); ?>" class="form-control form-control-enhanced">
                                </div>
                            </div>
                        </div>

<div class="col-lg-3 col-md-4 col-sm-6">
                            <div class="form-group-enhanced">
                                <label for="activity" class="form-label">
                                    <i class="fas fa-tasks me-1"></i>Select Activity
                                </label>
                                <select name="activity" id="activity" class="form-select form-select-enhanced">
                                    <option value="">All Activities</option>
                                    <?php $__currentLoopData = $orderedActivities; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $activity): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                        <option value="<?php echo e($activity['table']); ?>" <?php echo e(old('activity', $sel['activity'] ?? '') == $activity['table'] ? 'selected' : ''); ?>>
                                            <?php echo e($activity['display']); ?>

</option>
                                    <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                </select>
                            </div>
                        </div>

<div class="col-lg-3 col-md-4 col-sm-6 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary-enhanced w-100">
                                <i class="fas fa-search me-2"></i>Generate Report
                            </button>
                        </div>
                    </div>
                </form>
            </div>

<div class="table-section">
                <div class="table-header p-3 bg-light border-bottom">
                    <h5 class="mb-0 text-dark fw-bold">
                        <i class="fas fa-table me-2"></i>Production Data Analysis
                    </h5>
                </div>

<div class="table-responsive">
                    <table class="table table-enhanced" id="activityTable">
                        <thead class="table-header-enhanced sticky-top">
                            <tr>
                                <th data-column-name="sr_no" class="table-header-cell"><i class="fas fa-hashtag me-1"></i>Sr. No.</th>
                                <th data-column-name="activity_type" class="table-header-cell"><i class="fas fa-cogs me-1"></i>Activity Type</th>
                                <th data-column-name="block_name" class="table-header-cell"><i class="fas fa-th-large me-1"></i>Block Name</th>
                                <th data-column-name="plot_name" class="table-header-cell"><i class="fas fa-map me-1"></i>Plot No</th>
                                <th data-column-name="date" class="table-header-cell"><i class="fas fa-calendar me-1"></i>Date</th>
                                <th data-column-name="area" class="table-header-cell"><i class="fas fa-expand-arrows-alt me-1"></i>Area (Acre)</th>
                                <th data-column-name="area_covered" class="table-header-cell"><i class="fas fa-layer-group me-1"></i>Area Covered (Acre)</th>
                                <th data-column-name="seed_name" class="table-header-cell"><i class="fas fa-seedling me-1"></i>Seed Name</th>
                                <th data-column-name="seed_consumption" class="table-header-cell"><i class="fas fa-weight me-1"></i>Seed Consumption</th>
                                <th data-column-name="yield_production" class="table-header-cell"><i class="fas fa-chart-bar me-1"></i>Yield (MT)</th>
                                
                                
                                <th data-column-name="machine_tractor" class="table-header-cell"><i class="fas fa-tractor me-1"></i>Machine Used</th>
                                <th data-column-name="tractor_used" class="table-header-cell"><i class="fas fa-tractor me-1"></i>Tractor Used</th>
                                <th data-column-name="hsd_consumption" class="table-header-cell"><i class="fas fa-gas-pump me-1"></i>HSD Consumption (Ltr)</th>
                                <th data-column-name="hsd_cost" class="table-header-cell"><i class=""></i>HSD Cost (Rs)</th>
                                <th data-column-name="electricity_units" class="table-header-cell"><i class="fas fa-bolt me-1"></i>Electricity Units</th>
                                <th data-column-name="electricity_cost" class="table-header-cell"><i class=""></i>Electricity Cost (Rs)</th>
                                <th data-column-name="fertilizer_name" class="table-header-cell"><i class="fas fa-flask me-1"></i>Fertilizer Name</th>
                                <th data-column-name="fertilizer_used" class="table-header-cell"><i class="fas fa-weight me-1"></i>Fertilizer Used</th>
                                <th data-column-name="fertilizer_cost" class="table-header-cell"><i class=""></i>Fertilizer Cost (Rs)</th>
                                <th data-column-name="manpower_type" class="table-header-cell"><i class="fas fa-users me-1"></i>Manpower Type</th>
                                <th data-column-name="unskilled" class="table-header-cell"><i class="fas fa-user me-1"></i>Unskilled</th>
                                <th data-column-name="semi_skilled_1" class="table-header-cell"><i class="fas fa-user-tie me-1"></i>Semi-Skilled 1</th>
                                <th data-column-name="semi_skilled_2" class="table-header-cell"><i class="fas fa-user-graduate me-1"></i>Semi-Skilled 2</th>
                                <th data-column-name="manpower_cost" class="table-header-cell"><i class=""></i>Manpower Cost (Rs)</th>
                                <th data-column-name="maintenance_cost" class="table-header-cell"><i class="fas fa-tools me-1"></i>Maintenance Cost (Rs)</th>
                                <th data-column-name="chemical_name" class="table-header-cell"><i class="fas fa-vial me-1"></i>Chemical Name</th>
                                <th data-column-name="chemical_used" class="table-header-cell"><i class="fas fa-weight me-1"></i>Chemical Used</th>
                                <th data-column-name="total_overall_cost" class="table-header-cell"><i class="fas fa-calculator me-1"></i>Total Cost (Rs)</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                                $displayRows = collect($summary);
                                
                                // Harvest Store Management Totals
                                if ( (empty($sel['activity']) || $sel['activity'] == 'harvesting_update') && isset($harvestStoreManageTotals) && (count($harvestStoreManageTotals->seedTotals) > 0 || $harvestStoreManageTotals->grandTotal > 0) ) {
                                    $displayRows->push((object)['is_section_header' => true, 'text' => 'YIELD PRODUCTION SUMMARY', 'bg_class' => 'bg-harvest', 'icon' => 'fas fa-warehouse']);
                                    foreach ($harvestStoreManageTotals->seedTotals as $item) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => false,
                                            'activity_type' => 'Harvest Store Management',
                                            'seed_name_summary' => $item->seed_name,
                                            'yield_mt' => $item->total_yield_mt,
                                            'sold_mt' => $item->total_sold_mt ?? 0,
                                            'total_price' => $item->total_price ?? null,
                                            'label_text' => 'Total Yield for ' . $item->seed_name
                                        ]);
                                    }
                                    if ($harvestStoreManageTotals->grandTotal > 0) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => true,
                                            'activity_type' => 'Harvest Store Management',
                                            'seed_name_summary' => 'GRAND TOTAL',
                                            'yield_mt' => $harvestStoreManageTotals->grandTotal,
                                            'sold_mt' => $harvestStoreManageTotals->grandTotalSold ?? 0,
                                            'total_price' => $harvestStoreManageTotals->grandTotalPrice ?? null,
                                            'label_text' => 'TOTAL'
                                        ]);
                                    }
                                }

// Silage Making Totals
                                if ( (empty($sel['activity']) || $sel['activity'] == 'silage_making') && isset($silageTotals) && (count($silageTotals->seedTotals) > 0 || $silageTotals->grandTotal > 0) ) {
                                    $displayRows->push((object)['is_section_header' => true, 'text' => ' SILAGE PRODUCTION SUMMARY', 'bg_class' => 'bg-silage', 'icon' => 'fas fa-leaf']);
                                    foreach ($silageTotals->seedTotals as $seed) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => false,
                                            'activity_type' => 'Silage Making',
                                            'seed_name_summary' => $seed->seed_name,
                                            'yield_mt' => $seed->total_yield_mt,
                                            'sold_mt' => $seed->total_sold_mt ?? 0,
                                            'total_price' => $seed->total_price ?? null,
                                            'label_text' => 'Total Yield for ' . $seed->seed_name
                                        ]);
                                    }
                                    if ($silageTotals->grandTotal > 0) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => true,
                                            'activity_type' => 'Silage Making',
                                            'seed_name_summary' => 'GRAND TOTAL',
                                            'yield_mt' => $silageTotals->grandTotal,
                                            'sold_mt' => $silageTotals->grandTotalSold ?? 0,
                                            'total_price' => $silageTotals->grandTotalPrice ?? null,
                                            'label_text' => 'TOTAL'
                                        ]);
                                    }
                                }

// Hay Making Totals
                                if ( (empty($sel['activity']) || $sel['activity'] == 'hay_making') && isset($hayTotals) && (count($hayTotals->seedTotals) > 0 || $hayTotals->grandTotal > 0) ) {
                                    $displayRows->push((object)['is_section_header' => true, 'text' => ' HAY PRODUCTION SUMMARY', 'bg_class' => 'bg-hay', 'icon' => 'fas fa-wheat']);
                                    foreach ($hayTotals->seedTotals as $seed) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => false,
                                            'activity_type' => 'Hay Making',
                                            'seed_name_summary' => $seed->seed_name,
                                            'yield_mt' => $seed->total_yield_mt,
                                            'sold_mt' => $seed->total_sold_mt ?? 0,
                                            'total_price' => $seed->total_price ?? null,
                                            'label_text' => 'Total Yield for ' . $seed->seed_name
                                        ]);
                                    }
                                    if ($hayTotals->grandTotal > 0) {
                                        $displayRows->push((object)[
                                            'is_summary_total' => true,
                                            'is_grand_total' => true,
                                            'activity_type' => 'Hay Making',
                                            'seed_name_summary' => 'GRAND TOTAL',
                                            'yield_mt' => $hayTotals->grandTotal,
                                            'sold_mt' => $hayTotals->grandTotalSold ?? 0,
                                            'total_price' => $hayTotals->grandTotalPrice ?? null,
                                            'label_text' => 'TOTAL'
                                        ]);
                                    }
                                }
                            ?>

<?php $__empty_1 = true; $__currentLoopData = $displayRows; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $index => $row): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); $__empty_1 = false; ?>
                                <?php if(isset($row->is_section_header) && $row->is_section_header): ?>
                                    <tr class="section-header-row <?php echo e($row->bg_class ?? 'bg-info'); ?>">
                                        <th class="section-header-cell section-title" colspan="9">
                                            <i class="<?php echo e($row->icon ?? 'fas fa-chart-line'); ?> me-2"></i>
                                            <span class="fw-bold"><?php echo e($row->text); ?></span>
                                        </th>
                                        <th class="section-header-cell section-yield-header" data-column="yield_production">
                                            <i class="fas fa-chart-bar me-1"></i>Yield (MT)
                                        </th>
                                        <th class="section-header-cell section-sold-header" data-column="sold_mt">
                                            <i class="fas fa-shipping-fast me-1"></i>Sold (MT)
                                        </th>
                                        <th class="section-header-cell section-sale-header" data-column="total_sale_price">
                                            <i class="fas fa-money-bill-wave me-1"></i>Total Sale (Rs)
                                        </th>
                                        <th class="section-header-cell" colspan="18"></th>
                                    </tr>
                                <?php elseif(isset($row->is_summary_total) && $row->is_summary_total): ?>
                                    <tr class="summary-total-row <?php if($row->is_grand_total): ?> grand-total-row <?php endif; ?>">
                                        <td class="col-sr_no summary-cell summary-hidden"></td>
                                        <td class="text-start ps-3 col-activity_type summary-label summary-cell" colspan="9">
                                            <i class="fas fa-calculator me-2 text-primary"></i>
                                            <strong><?php echo e($row->label_text); ?></strong>
                                        </td>
                                        <td class="text-end col-yield_production summary-value summary-cell">
                                            <strong><?php echo e(is_numeric($row->yield_mt) && (float)$row->yield_mt > 0 ? number_format((float)$row->yield_mt, 2) . ' MT' : '--'); ?></strong>
                                        </td>
                                        <td class="text-end col-sold_mt summary-value summary-cell">
                                            <strong><?php echo e(is_numeric($row->sold_mt) && (float)$row->sold_mt > 0 ? number_format((float)$row->sold_mt, 2) . ' MT' : '--'); ?></strong>
                                        </td>
                                        <td class="text-end col-total_sale_price summary-value summary-cell">
                                            <strong><?php echo e(is_numeric($row->total_price) && (float)$row->total_price > 0 ? '₹' . number_format((float)$row->total_price, 2) : '--'); ?></strong>
                                        </td>
                                        <td class="summary-cell summary-hidden" colspan="17"></td>
                                    </tr>
                                <?php else: ?>
                                    <tr class="data-row">
                                        <td class="col-sr_no data-cell"><?php echo e(($paginator->currentPage() - 1) * $paginator->perPage() + ($loop->index + 1)); ?></td>
                                        <?php
                                            $displayName = collect($orderedActivities)->firstWhere('table', $row['table'])['display'] ?? '-';
                                        ?>
                                        <td class="col-activity_type data-cell"><?php echo e($displayName); ?></td>
                                        <td class="col-block_name data-cell"><?php echo e($row['block_name'] ?? '-'); ?></td>
                                        <td class="col-plot_name data-cell"><?php echo e($row['plot_name'] ?? '-'); ?></td>
                                        <td style="vertical-align: middle; height: 40px; text-align: center; font-size: 14px; padding: 8px; white-space: nowrap;">
                                            <?php
                                                $date = $row['date'] ?? null;
                                            ?>

<?php if($date && strtotime($date) !== false): ?>
                                                <?php echo e(\Carbon\Carbon::parse($date)->format('d-m-y')); ?>

<?php else: ?>
                                                &nbsp;
                                            <?php endif; ?>
                                        </td>
                                        <td class="text-end col-area data-cell"><?php echo e($row['area'] ?? '-'); ?></td>
                                        <td class="text-end col-area_covered data-cell"><?php echo e($row['area_covered'] ?? '-'); ?></td>
                                        <td class="col-seed_name data-cell"><?php echo e($row['seed_name'] ?? '-'); ?></td>
                                        <td class="text-end col-seed_consumption data-cell"><?php echo e($row['seed_consumption'] ?? '-'); ?></td>
                                        <td class="text-end col-yield_production data-cell">
                                            <?php if(isset($row['table']) && in_array($row['table'], ['harvesting_update', 'harvestings', 'silage_making', 'hay_making', 'harvest_store_manage'])): ?>
                                                <?php echo e(is_numeric($row['yield_mt']) && (float)$row['yield_mt'] > 0 ? number_format((float)$row['yield_mt'], 2) : '--'); ?>

<?php else: ?>
                                                --
                                            <?php endif; ?>
                                        </td>
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        <td class="col-machine_tractor data-cell"><?php echo e($row['machine_id'] ?? '-'); ?></td>
                                        <td class="col-tractor_used data-cell"><?php echo e($row['tractor_id'] ?? '-'); ?></td>
                                        <td class="text-end col-hsd_consumption data-cell"><?php echo e($row['hsd_consumption'] ?? '-'); ?></td>
                                        <td class="text-end col-hsd_cost data-cell"><?php echo e($row['hsd_cost'] ?? '-'); ?></td>
                                        <td class="text-end col-electricity_units data-cell"><?php echo e($row['electricity_units'] ?? '-'); ?></td>
                                        <td class="text-end col-electricity_cost data-cell"><?php echo e($row['electricity_cost'] ?? '-'); ?></td>
                                        <td class="col-fertilizer_name data-cell"><?php echo e($row['fertilizer_name'] ?? '-'); ?></td>
                                        <td class="text-end col-fertilizer_used data-cell"><?php echo e($row['fertilizer_used'] ?? '-'); ?></td>
                                        <td class="text-end col-fertilizer_cost data-cell"><?php echo e($row['fertilizer_cost'] ?? '-'); ?></td>
                                        <td class="col-manpower_type data-cell"><?php echo e($row['manpower_type'] ?? '-'); ?></td>
                                        <td class="text-end col-unskilled data-cell"><?php echo e($row['unskilled'] ?? '-'); ?></td>
                                        <td class="text-end col-semi_skilled_1 data-cell"><?php echo e($row['semi_skilled_1'] ?? '-'); ?></td>
                                        <td class="text-end col-semi_skilled_2 data-cell"><?php echo e($row['semi_skilled_2'] ?? '-'); ?></td>
                                        <td class="text-end col-manpower_cost data-cell"><?php echo e($row['manpower_cost'] ?? '-'); ?></td>
                                        <?php
                                            $maintenance = $row['major_maintenance'] ?? null;
                                            $items = is_string($maintenance) ? json_decode($maintenance, true) : null;
                                        ?>
                                        <td class="text-end col-maintenance_cost data-cell">
                                            <?php if(is_array($items)): ?>
                                                <?php $__currentLoopData = $items; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $item): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                                    <?php echo e($item['spare_part'] ?? '-'); ?>: <?php echo e($item['value'] ?? '-'); ?><br>
                                                <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                            <?php else: ?>
                                                <?php echo e(is_numeric($maintenance) ? number_format((float)$maintenance, 2) : '-'); ?>

<?php endif; ?>
                                        </td>
                                        <td class="col-chemical_name data-cell"><?php echo e($row['chemical_name'] ?? '-'); ?></td>
                                        <td class="text-end col-chemical_used data-cell"><?php echo e($row['chemical_used'] ?? '-'); ?></td>
                                        <td class="text-end col-total_overall_cost data-cell"><?php echo e($row['total_cost'] ?? '-'); ?></td>
                                    </tr>
                                <?php endif; ?>
                            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); if ($__empty_1): ?>
                                <tr>
                                    <td colspan="30" class="text-center py-5 text-muted">
                                        <i class="fas fa-search fa-3x mb-3 opacity-50"></i>
                                        <h5>No data found for the selected filters</h5>
                                        <p class="mb-0">Try adjusting your filter criteria</p>
                                    </td>
                                </tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>

<div class="summary-section p-4">
                <div class="summary-card">
                    <div class="summary-header">
                        <h4 class="fw-bold text-white mb-0">
                            <i class="fas fa-chart-pie me-2"></i>Financial Overview
                        </h4>
                    </div>
                    <div class="summary-body">
                        <div class="row g-4">
                            <div class="col-lg-4 col-md-6">
                                <div class="metric-card cost-card">
                                    <div class="metric-icon">
                                        <i class="fas fa-money-bill-alt"></i>
                                    </div>
                                    <div class="metric-content">
                                        <h6 class="metric-label">Total Cost</h6>
                                        <h3 class="metric-value text-danger">
                                            ₹<?php echo e(is_numeric($totalStats['totalCost']) ? number_format((float)$totalStats['totalCost'], 2) : '0.00'); ?>

</h3>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-md-6">
                                <div class="metric-card revenue-card">
                                    <div class="metric-icon">
                                        <i class="fas fa-coins"></i>
                                    </div>
                                    <div class="metric-content">
                                        <h6 class="metric-label">Total Revenue</h6>
                                        <h3 class="metric-value text-success">
                                            ₹<?php echo e(is_numeric($overallTotalSalePrice) ? number_format((float)$overallTotalSalePrice, 2) : '0.00'); ?>

</h3>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-md-12">
                                <?php
                                    $totalCost = is_numeric($totalStats['totalCost']) ? (float)$totalStats['totalCost'] : 0;
                                    $currentOverallSalePrice = is_numeric($overallTotalSalePrice) ? (float)$overallTotalSalePrice : 0;
                                    $profitLoss = $currentOverallSalePrice - $totalCost;
                                ?>
                                <div class="metric-card <?php echo e($profitLoss >= 0 ? 'profit-card' : 'loss-card'); ?>">
                                    <div class="metric-icon">
                                        <i class="fas <?php echo e($profitLoss >= 0 ? 'fa-chart-line' : 'fa-chart-line-down'); ?>"></i>
                                    </div>
                                    <div class="metric-content">
                                        <h6 class="metric-label"><?php echo e($profitLoss >= 0 ? 'Net Profit' : 'Net Loss'); ?></h6>
                                        <h3 class="metric-value <?php echo e($profitLoss >= 0 ? 'text-success' : 'text-danger'); ?>">
                                            ₹<?php echo e(number_format(abs($profitLoss), 2)); ?>

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

<div class="pagination-section p-4 bg-light">
                <div class="d-flex justify-content-center">
                    <?php echo e($paginator->links('pagination::bootstrap-5')); ?>

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

body {
    background: linear-gradient(135deg, #f5f7fa 0%, #c3cfe2 100%);
    font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
}

/* Main Card Styling */
.main-card {
    background: white;
    border-radius: var(--border-radius);
    box-shadow: var(--box-shadow);
    overflow: hidden;
}

/* Enhanced Header */
.card-header {
    position: relative;
    overflow: hidden;
}

.header-overlay {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    background: url('data:image/svg+xml,<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 100 100"><defs><pattern id="grain" width="100" height="100" patternUnits="userSpaceOnUse"><circle cx="25" cy="25" r="1" fill="rgba(255,255,255,0.1)"/><circle cx="75" cy="75" r="1" fill="rgba(255,255,255,0.1)"/></pattern></defs><rect width="100" height="100" fill="url(%23grain)"/></svg>');
    opacity: 0.3;
}

.header-decoration {
    position: absolute;
    bottom: -2px;
    left: 0;
    right: 0;
    height: 4px;
    background: linear-gradient(90deg, transparent, rgba(255,255,255,0.3), transparent);
}

/* Filter Section */
.filter-section {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
    border-bottom: 1px solid #dee2e6;
}

.bg-gradient-light {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
}

.filter-header {
    border-bottom: 2px solid var(--primary-color);
    padding-bottom: 10px;
    margin-bottom: 20px;
}

.form-group-enhanced {
    position: relative;
}

.form-label {
    font-weight: 600;
    color: var(--dark-color);
    margin-bottom: 8px;
    display: flex;
    align-items: center;
}

.form-label i {
    color: var(--secondary-color);
}

.form-select-enhanced,
.form-control-enhanced {
    border: 2px solid #e9ecef;
    border-radius: 8px;
    padding: 12px 16px;
    font-size: 14px;
    transition: var(--transition);
    background: white;
}

.form-select-enhanced:focus,
.form-control-enhanced:focus {
    border-color: var(--secondary-color);
    box-shadow: 0 0 0 0.2rem rgba(107, 142, 35, 0.25);
    outline: none;
}

.date-range-wrapper {
    display: flex;
    align-items: center;
    gap: 10px;
}

.date-separator {
    color: var(--secondary-color);
    font-weight: 600;
    padding: 0 5px;
}

.btn-primary-enhanced {
    background: linear-gradient(135deg, var(--primary-color) 0%, var(--secondary-color) 100%);
    border: none;
    border-radius: 8px;
    padding: 12px 24px;
    font-weight: 600;
    transition: var(--transition);
    box-shadow: 0 4px 15px rgba(45, 80, 22, 0.3);
}

.btn-primary-enhanced:hover {
    transform: translateY(-2px);
    box-shadow: 0 6px 20px rgba(45, 80, 22, 0.4);
    background: linear-gradient(135deg, #1a3009 0%, #5a7a1e 100%);
}

/* Table Enhancements - COMPLETELY FIXED HEADER COLORS */
.table-section {
    background: white;
}

.table-header {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
    border-bottom: 2px solid var(--primary-color);
}

.table-enhanced {
    margin-bottom: 0;
    font-size: 13px;
}

/* COMPLETELY FIXED: Main Table Headers with Dark Background and White Text */
.table-header-enhanced {
    background: #2d5016 !important;
}

.table-header-cell {
    background: #2d5016 !important;
    color: #ffffff !important;
    border: 1px solid #1a3009 !important;
    padding: 16px 12px !important;
    font-weight: 700 !important;
    text-align: center !important;
    vertical-align: middle !important;
    white-space: nowrap !important;
    position: sticky !important;
    top: 0 !important;
    z-index: 10 !important;
    box-shadow: 0 2px 4px rgba(0,0,0,0.2) !important;
    font-size: 13px !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
}

.table-header-cell i {
    opacity: 1 !important;
    color: #ffffff !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
}

/* Data Cells */
.data-cell {
    padding: 12px 8px;
    vertical-align: middle;
    border: 1px solid #e9ecef;
    background: #ffffff;
    color: #495057;
    font-size: 13px;
}

.data-row {
    transition: var(--transition);
}

.data-row:hover {
    background-color: rgba(107, 142, 35, 0.05) !important;
}

.data-row:hover .data-cell {
    background-color: rgba(107, 142, 35, 0.05) !important;
}

/* COMPLETELY FIXED: Section Headers with Dark Background and White Text */
.section-header-row {
    background: #17a2b8 !important;
}

.section-header-row.bg-silage {
    background: #6c757d !important;
}

.section-header-row.bg-hay {
    background: #e0a800 !important;
}

.section-header-row.bg-harvest {
    background: #17a2b8 !important;
}

.section-header-cell {
    background: inherit !important;
    border: 1px solid rgba(255,255,255,0.2) !important;
    padding: 16px !important;
    text-align: center !important;
    color: #ffffff !important;
    font-weight: 700 !important;
    font-size: 14px !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
    vertical-align: middle !important;
}

.section-header-cell i {
    color: #ffffff !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
}

.section-title {
    font-size: 16px !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
    color: #ffffff !important;
    font-weight: 700 !important;
}

.section-sold-header {
    background: inherit !important;
    border: 1px solid rgba(255,255,255,0.2) !important;
    padding: 16px !important;
    text-align: center !important;
    color: #ffffff !important;
    font-weight: 700 !important;
    font-size: 14px !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
    vertical-align: middle !important;
}

.section-sold-header i {
    color: #ffffff !important;
    text-shadow: 0 1px 2px rgba(0,0,0,0.3) !important;
}

/* FIXED: Summary Rows with Better Visibility and Perfect Alignment */
.summary-total-row {
    background: #f8f9fa !important;
    border-top: 2px solid #dee2e6 !important;
    border-bottom: 2px solid #dee2e6 !important;
}

.summary-cell {
    padding: 14px 12px !important;
    background: #f8f9fa !important;
    border: 1px solid #dee2e6 !important;
    color: #343a40 !important;
    vertical-align: middle !important;
}

.summary-label {
    color: #343a40 !important;
    font-weight: 600 !important;
}

.summary-label i {
    color: #2d5016 !important;
}

.summary-value {
    font-weight: 700 !important;
    color: #2d5016 !important;
}

.summary-hidden {
    display: none !important;
}

.col-sold_mt {
    padding: 12px 8px;
    vertical-align: middle;
    border: 1px solid #e9ecef;
    background: #ffffff;
    color: #495057;
    font-size: 13px;
    text-align: right;
}

.summary-total-row .col-sold_mt {
    padding: 14px 12px !important;
    background: #f8f9fa !important;
    border: 1px solid #dee2e6 !important;
    color: #2d5016 !important;
    vertical-align: middle !important;
    font-weight: 700 !important;
}

.grand-total-row {
    background: #d1e7dd !important;
    border: 2px solid #28a745 !important;
}

.grand-total-row .summary-cell {
    background: #d1e7dd !important;
    border-color: #28a745 !important;
    color: #0f5132 !important;
}

.grand-total-row .summary-label,
.grand-total-row .summary-value {
    color: #0f5132 !important;
    font-weight: 700 !important;
}

.grand-total-row .summary-label i {
    color: #0f5132 !important;
}

.grand-total-row .summary-value {
    font-size: 16px !important;
}

.grand-total-row .col-sold_mt {
    background: #d1e7dd !important;
    border-color: #28a745 !important;
    color: #0f5132 !important;
    font-weight: 700 !important;
    font-size: 16px !important;
}

/* Summary Section */
.summary-section {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
    border-top: 1px solid #dee2e6;
}

.summary-card {
    background: white;
    border-radius: var(--border-radius);
    overflow: hidden;
    box-shadow: var(--box-shadow);
}

.summary-header {
    background: linear-gradient(135deg, var(--primary-color) 0%, var(--secondary-color) 100%);
    padding: 20px;
    text-align: center;
}

.summary-body {
    padding: 30px;
}

.metric-card {
    background: white;
    border-radius: var(--border-radius);
    padding: 24px;
    box-shadow: 0 4px 15px rgba(0,0,0,0.08);
    transition: var(--transition);
    border-left: 4px solid;
    display: flex;
    align-items: center;
    gap: 20px;
}

.metric-card:hover {
    transform: translateY(-4px);
    box-shadow: 0 8px 25px rgba(0,0,0,0.15);
}

.cost-card {
    border-left-color: var(--danger-color);
    background: linear-gradient(135deg, #fff5f5 0%, #fed7d7 100%);
}

.revenue-card {
    border-left-color: var(--success-color);
    background: linear-gradient(135deg, #f0fff4 0%, #c6f6d5 100%);
}

.profit-card {
    border-left-color: var(--success-color);
    background: linear-gradient(135deg, #f0fff4 0%, #c6f6d5 100%);
}

.loss-card {
    border-left-color: var(--danger-color);
    background: linear-gradient(135deg, #fff5f5 0%, #fed7d7 100%);
}

.metric-icon {
    width: 60px;
    height: 60px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 24px;
    color: white;
    flex-shrink: 0;
}

.cost-card .metric-icon {
    background: linear-gradient(135deg, var(--danger-color) 0%, #c82333 100%);
}

.revenue-card .metric-icon,
.profit-card .metric-icon {
    background: linear-gradient(135deg, var(--success-color) 0%, #1e7e34 100%);
}

.loss-card .metric-icon {
    background: linear-gradient(135deg, var(--danger-color) 0%, #c82333 100%);
}

.metric-content {
    flex: 1;
}

.metric-label {
    font-size: 14px;
    font-weight: 600;
    color: #6c757d;
    margin-bottom: 8px;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

.metric-value {
    font-size: 28px;
    font-weight: 700;
    margin: 0;
    line-height: 1.2;
}

/* Pagination */
.pagination-section {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
    border-top: 1px solid #dee2e6;
}

/* Responsive Design */
@media (max-width: 768px) {
    .date-range-wrapper {
        flex-direction: column;
        gap: 8px;
    }
    
    .date-separator {
        display: none;
    }
    
    .metric-card {
        flex-direction: column;
        text-align: center;
        gap: 15px;
    }
    
    .metric-value {
        font-size: 24px;
    }
    
    .table-enhanced {
        font-size: 12px;
    }
    
    .table-header-cell {
        padding: 12px 8px !important;
        font-size: 12px !important;
    }
}

/* Hidden columns */
.hidden-column {
    display: none !important;
}

/* Font Awesome and Bootstrap Icons */
@import url("https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css");
@import url("https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css");

/* Animation for loading states */
@keyframes fadeIn {
    from { opacity: 0; transform: translateY(20px); }
    to { opacity: 1; transform: translateY(0); }
}

.main-card {
    animation: fadeIn 0.6s ease-out;
}

/* Scrollbar styling */
.table-responsive::-webkit-scrollbar {
    height: 8px;
}

.table-responsive::-webkit-scrollbar-track {
    background: #f1f1f1;
    border-radius: 4px;
}

.table-responsive::-webkit-scrollbar-thumb {
    background: var(--secondary-color);
    border-radius: 4px;
}

.table-responsive::-webkit-scrollbar-thumb:hover {
    background: var(--primary-color);
}
</style>

function hideEmptyColumns() {
        const selectedActivity = activitySelect.value;
        const columnVisibilityMap = {};

// Initialize column visibility
        tableHeaders.forEach(header => {
            const columnName = header.dataset.columnName;
            if (columnName) {
                // Always visible columns unless explicitly hidden by data
                if (['sr_no', 'activity_type', 'block_name', 'plot_name', 'date', 'area', 'yield_production', 'sold_mt', 'total_sale_price'].includes(columnName)) {
                    columnVisibilityMap[columnName] = true;
                } else {
                    columnVisibilityMap[columnName] = false;
                }
            }
        });

// Check data rows for content
        tableBodyRows.forEach(row => {
            if (row.classList.contains('section-header-row') || row.classList.contains('summary-total-row')) {
                return; // Skip section/summary headers
            }

row.querySelectorAll('td').forEach((cell, cellIndex) => {
                const header = tableHeaders[cellIndex];
                const columnName = header ? header.dataset.columnName : null;
                if (columnName && !['sr_no', 'activity_type', 'block_name', 'plot_name', 'date', 'area'].includes(columnName)) {
                    const cellValue = cell.textContent.trim();
                    if (!isCellTrulyEmptyForDisplay(cellValue)) {
                        columnVisibilityMap[columnName] = true;
                    }
                }
            });
        });

// Apply visibility to headers and cells
        tableHeaders.forEach((header, index) => {
            const columnName = header.dataset.columnName;
            if (columnName) {
                const isVisible = columnVisibilityMap[columnName];
                header.classList.toggle('hidden-column', !isVisible);
                
                // Apply to all data cells
                tableBodyRows.forEach(row => {
                    const cell = row.querySelector(`.col-${columnName}`);
                    if (cell) {
                        cell.classList.toggle('hidden-column', !isVisible);
                    }
                });
            }
        });

// Update section header visibility
        updateSectionHeaderVisibility(columnVisibilityMap);
    }

// Initial calls
    updatePlotOptions(blockSelect.value);
    hideEmptyColumns(); // Call on page load

// Event listeners
    blockSelect.addEventListener('change', function() {
        updatePlotOptions(this.value);
    });

activitySelect.addEventListener('change', hideEmptyColumns);
});
</script>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.app', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /home3/pmmsanvp/public_html/ccbfsolution/resources/views/cost_analysis/index.blade.php ENDPATH**/ ?>