<!DOCTYPE html>
<html>
<head>
    <title><?= lang('estimates_report') ?></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <?php
    $direction = $this->session->userdata('direction');
    if (!empty($direction) && $direction == 'rtl') {
        $RTL = 'on';
    } else {
        $RTL = config_item('RTL');
    }

    $cur = $this->report_model->check_by(array('code' => config_item('default_currency')), 'tbl_currencies');
    $discount_total = 0;
    $estimate_total = 0;
    $total_tax = 0;
    $estimate_count = !empty($all_estimates) ? count($all_estimates) : 0;
    ?>
    <style>
        body {
            margin: 0;
            color: #172033;
            background: #ffffff;
            font: 12px/1.55 DejaVu Sans, Arial, Helvetica, sans-serif;
            min-width: 100%;
            min-height: 100%;
        <?php if (!empty($RTL)) { ?> text-align: right;
        <?php } ?>
        }

        table {
            width: 100%;
            border-collapse: collapse;
            border-spacing: 0;
        <?php if (!empty($RTL)) { ?> text-align: right;
        <?php } ?>
        }

        .page-wrap {
            padding: 18px 22px 24px;
        }

        .brand-shell {
            border: 1px solid #d7deea;
            padding: 18px 20px;
            background: #f8fafc;
            margin-bottom: 18px;
        }

        .brand-logo {
            width: 60px;
            height: 60px;
            background: #ffffff;
            border: 1px solid #d7deea;
            padding: 6px;
        }

        .brand-title {
            font-size: 24px;
            font-weight: 700;
            color: #0f172a;
            margin: 0 0 4px;
        }

        .brand-text {
            font-size: 12px;
            color: #64748b;
            margin: 0;
        }

        .report-shell {
            border: 1px solid #d7deea;
            padding: 18px 20px;
            margin-bottom: 18px;
            background: linear-gradient(180deg, #ffffff 0%, #f8fafc 100%);
        }

        .eyebrow {
            display: inline-block;
            padding: 5px 12px;
            border: 1px solid #dbe4ff;
            border-radius: 999px;
            background: #eef2ff;
            color: #4338ca;
            font-size: 10px;
            font-weight: 700;
            letter-spacing: .16em;
            text-transform: uppercase;
            margin-bottom: 10px;
        }

        .report-title {
            font-size: 26px;
            font-weight: 700;
            color: #0f172a;
            margin: 0 0 6px;
        }

        .report-subtitle {
            font-size: 12px;
            color: #64748b;
            margin: 0;
        }

        .range-chip {
            margin-top: 12px;
            display: inline-block;
            padding: 8px 14px;
            border: 1px solid #d7deea;
            background: #ffffff;
            color: #334155;
            font-size: 11px;
            font-weight: 600;
        }

        .metrics {
            margin: 0 0 18px;
        }

        .metric-card {
            width: 23.5%;
            border: 1px solid #d7deea;
            background: #ffffff;
            padding: 14px 16px;
            vertical-align: top;
        }

        .metric-gap {
            width: 2%;
        }

        .metric-label {
            font-size: 10px;
            font-weight: 700;
            text-transform: uppercase;
            letter-spacing: .12em;
            color: #64748b;
            margin-bottom: 6px;
        }

        .metric-value {
            font-size: 21px;
            font-weight: 700;
            color: #0f172a;
            margin: 0;
        }

        .metric-note {
            font-size: 11px;
            color: #94a3b8;
            margin-top: 4px;
        }

        .table-shell {
            border: 1px solid #d7deea;
            overflow: hidden;
            background: #ffffff;
        }

        .table-shell table {
            border-collapse: separate;
            border-spacing: 0;
        }

        .table-head td {
            background: #1e293b;
            color: #f8fafc;
            font-size: 11px;
            font-weight: 700;
            letter-spacing: .06em;
            text-transform: uppercase;
            padding: 12px 14px;
            border-bottom: 1px solid #1e293b;
        }

        .row td {
            padding: 12px 14px;
            border-bottom: 1px solid #e2e8f0;
            color: #1e293b;
            vertical-align: top;
        }

        .row-alt td {
            background: #f8fafc;
        }

        .number {
        <?php if (!empty($RTL)) { ?> text-align: left;
        <?php } else { ?> text-align: right;
        <?php } ?>
        }

        .muted {
            color: #64748b;
        }

        .strong {
            font-weight: 700;
            color: #0f172a;
        }

        .total-row td {
            padding: 14px;
            background: #eef2ff;
            border-top: 1px solid #c7d2fe;
            font-weight: 700;
            color: #1e1b4b;
        }
    </style>
</head>
<body>
<?php
$rootPath = defined('ROOTPATH') ? ROOTPATH : FCPATH;
$img = $rootPath . '/' . config_item('company_logo');
$a = file_exists($img);
if (empty($a)) {
    $img = base_url() . config_item('company_logo');
}
if (!file_exists($img)) {
    $img = $rootPath . '/' . 'uploads/default_logo.png';
}

if (!empty($range[0])) {
    $start_date = display_date($range[0]);
    $end_date = display_date($range[1]);
}

if (!empty($all_estimates)) {
    foreach ($all_estimates as $v_estimates) {
        $estimate_total += $this->estimates_model->estimate_calculation('total', $v_estimates->estimates_id);
        $total_tax += $this->estimates_model->get_estimate_tax_amount($v_estimates->estimates_id);
        $discount_total += $this->estimates_model->get_estimate_discount($v_estimates->estimates_id);
    }
}
?>
<div class="page-wrap">
    <div class="brand-shell">
        <table>
            <tr>
                <td style="width: 84px; border: 0;">
                    <img class="brand-logo" src="<?= $img ?>" alt="<?= config_item('company_name') ?>">
                </td>
                <td style="border: 0;">
                    <p class="brand-title"><?= config_item('company_name') ?></p>
                    <p class="brand-text"><?= $this->config->item('company_address') ?></p>
                </td>
            </tr>
        </table>
    </div>

    <div class="report-shell">
        <span class="eyebrow"><?= lang('finance') ?></span>
        <p class="report-title"><?= lang('estimates_report') ?></p>
        <p class="report-subtitle">Summary of estimate volume, tax exposure, discounts, and conversion-ready totals.</p>
        <?php if (!empty($start_date)) { ?>
            <span class="range-chip"><?= lang('FROM') ?> <?= $start_date ?> <?= lang('TO') ?> <?= $end_date ?></span>
        <?php } ?>
    </div>

    <table class="metrics">
        <tr>
            <td class="metric-card">
                <div class="metric-label"><?= lang('estimates') ?></div>
                <p class="metric-value"><?= $estimate_count ?></p>
                <div class="metric-note"><?= lang('records') ?></div>
            </td>
            <td class="metric-gap"></td>
            <td class="metric-card">
                <div class="metric-label"><?= lang('amount') ?></div>
                <p class="metric-value"><?= display_money($estimate_total, $cur->symbol) ?></p>
                <div class="metric-note"><?= lang('gross_value') ?></div>
            </td>
            <td class="metric-gap"></td>
            <td class="metric-card">
                <div class="metric-label"><?= lang('tax') . ' ' . lang('amount') ?></div>
                <p class="metric-value"><?= display_money($total_tax, $cur->symbol) ?></p>
                <div class="metric-note"><?= lang('tax_summary') ?></div>
            </td>
            <td class="metric-gap"></td>
            <td class="metric-card">
                <div class="metric-label"><?= lang('discount') ?></div>
                <p class="metric-value"><?= display_money($discount_total, $cur->symbol) ?></p>
                <div class="metric-note"><?= lang('discount_total') ?></div>
            </td>
        </tr>
    </table>

    <div class="table-shell">
        <table cellpadding="0" cellspacing="0" border="0">
            <thead>
            <tr class="table-head">
                <td><?= lang('estimate') ?></td>
                <td class="number"><?= lang('estimate') . ' ' . lang('date') ?></td>
                <td class="number"><?= lang('expire') . ' ' . lang('date') ?></td>
                <td class="number"><?= lang('invoice') ?>#</td>
                <td><?= lang('client_name') ?></td>
                <td class="number"><?= lang('amount') ?></td>
                <td class="number"><?= lang('tax') . ' ' . lang('amount') ?></td>
                <td class="number"><?= lang('discount') ?></td>
            </tr>
            </thead>
            <tbody>
            <?php if (!empty($all_estimates)) {
                foreach ($all_estimates as $index => $v_estimates) {
                    $estimate_amount = $this->estimates_model->estimate_calculation('total', $v_estimates->estimates_id);
                    $estimate_tax = $this->estimates_model->get_estimate_tax_amount($v_estimates->estimates_id);
                    $estimate_discount = $this->estimates_model->get_estimate_discount($v_estimates->estimates_id);
                    $invoice_reference = '';
                    if ($v_estimates->invoiced == 'Yes') {
                        $invoice_info = $this->db->where('invoices_id', $v_estimates->invoices_id)->get('tbl_invoices')->row();
                        if (!empty($invoice_info)) {
                            $invoice_reference = $invoice_info->reference_no;
                        }
                    }
                    ?>
                    <tr class="row<?= ($index % 2 !== 0) ? ' row-alt' : '' ?>">
                        <td>
                            <div class="strong"><?= $v_estimates->reference_no ?></div>
                        </td>
                        <td class="number"><?= display_date($v_estimates->estimate_date) ?></td>
                        <td class="number"><?= display_date($v_estimates->due_date) ?></td>
                        <td class="number"><?= !empty($invoice_reference) ? $invoice_reference : '-' ?></td>
                        <td>
                            <div class="strong"><?= client_name($v_estimates->client_id); ?></div>
                        </td>
                        <td class="number strong"><?= display_money($estimate_amount, $cur->symbol); ?></td>
                        <td class="number"><?= display_money($estimate_tax, $cur->symbol); ?></td>
                        <td class="number"><?= display_money($estimate_discount, $cur->symbol); ?></td>
                    </tr>
                <?php } ?>
                <tr class="total-row">
                    <td colspan="5"><?= lang('total') ?></td>
                    <td class="number"><?= display_money($estimate_total, $cur->symbol) ?></td>
                    <td class="number"><?= display_money($total_tax, $cur->symbol) ?></td>
                    <td class="number"><?= display_money($discount_total, $cur->symbol) ?></td>
                </tr>
            <?php } else { ?>
                <tr class="row">
                    <td colspan="8" style="text-align:center;" class="muted"><?= lang('nothing_to_display') ?></td>
                </tr>
            <?php } ?>
            </tbody>
        </table>
    </div>
</div>
</body>
</html>
