byp4a55 professor6T9

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

File Name : generate_monthly_bills.php

<?php

// HARD RESET – keep it clean
ini_set('display_errors', 0);
error_reporting(0);

require_once '../config/db.php';
require_once __DIR__ . '/../salaries/mpdf/vendor/autoload.php';

use Mpdf\Mpdf;

/* =========================
   INIT PDF
========================= */
$mpdf = new Mpdf([
    'mode' => 'utf-8',
    'format' => 'A4',
    'orientation' => 'P',
    'margin_left' => 10,
    'margin_right' => 10,
    'margin_top' => 10,
    'margin_bottom' => 10,
]);

/* =========================
   BILL MONTH (NEXT MONTH)
========================= */
$billMonth = (new DateTime('first day of next month'))->format('F Y');

/* =========================
   FETCH BILLS
========================= */
$stmt = $pdo->prepare("
    SELECT 
        b.*,
        s.name,
        s.phone
    FROM individual_bills b
    JOIN subscribers s ON s.id = b.subscriber_id
    WHERE b.bill_month = ?
");
$stmt->execute([$billMonth]);
$bills = $stmt->fetchAll(PDO::FETCH_ASSOC);

if (!$bills) {
    exit('No bills found');
}

/* =========================
   START HTML DOCUMENT
========================= */
$html = "
<!DOCTYPE html>
<html>
<head>
<style>
body {
    font-family: Arial, sans-serif;
    font-size: 11px;
}

.bill {
    border: 2px solid #000;
    background: #d7cfe4;
    padding: 8px;
    margin-bottom: 10mm;
}

h1 {
    text-align: center;
    font-size: 18px;
    margin: 6px 0;
}

table {
    width: 100%;
    border-collapse: collapse;
}

td, th {
    border: 1px solid #000;
    padding: 4px;
}

.header-box {
    background: #b6aecf;
    text-align: right;
    padding: 4px;
}

.section-title {
    background: #7b6aa6;
    color: #fff;
    font-weight: bold;
    text-align: center;
}

.red {
    color: red;
    font-weight: bold;
}

.center {
    text-align: center;
}

.bold {
    font-weight: bold;
}
</style>
</head>
<body>
";

/* =========================
   BUILD BILLS
========================= */
$count = 0;

foreach ($bills as $b) {

if ($count > 0 && $count % 3 === 0) {
        $html .= '<pagebreak />';
    }

$arrears = number_format((float)$b['arrears_amount']);
    $current = number_format((float)$b['base_amount']);
    $total   = number_format((float)$b['arrears_amount'] + (float)$b['base_amount']);

$billDate = date('d/m/Y', strtotime($b['bill_date']));

$html .= "
    <div class='bill'>
        <h1>EMACOM CABLE NETWORK</h1>

<table>
            <tr>
                <td width='70%'>
                    <strong>Customer Name:</strong> {$b['name']}<br>
                    <strong>Contact:</strong> {$b['phone']}
                </td>
                <td width='30%' class='header-box'>
                    <strong>Bill Date:</strong><br>
                    {$billDate}
                </td>
            </tr>
        </table>

<p class='center'><strong>Bill for:</strong> {$b['bill_month']}</p>

<table>
            <tr>
                <td width='35%'>
                    <table>
                        <tr>
                            <td colspan='2' class='section-title'>TOTAL ACCUMULATED BILL</td>
                        </tr>
                        <tr>
                            <td>Arrears</td>
                            <td class='red'>FCFA {$arrears}</td>
                        </tr>
                        <tr>
                            <td>Current bill</td>
                            <td class='red'>FCFA {$current}</td>
                        </tr>
                        <tr>
                            <td class='bold'>TOTAL DEBT</td>
                            <td class='red bold'>FCFA {$total}</td>
                        </tr>
                    </table>
                </td>

<td width='65%'>
                    <table>
                        <tr>
                            <th>Description</th>
                            <th>Qty</th>
                            <th>Unit</th>
                            <th>Total</th>
                        </tr>
                        <tr>
                            <td>Cable TV subscription</td>
                            <td>1</td>
                            <td>{$current}</td>
                            <td>{$current}</td>
                        </tr>
                        <tr>
                            <td colspan='3' class='bold'>TOTAL</td>
                            <td class='bold'>{$current}</td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>

<p class='center'>
            Payments via <strong>MOMO</strong> ONLY @ <strong>678403543</strong>
        </p>

<p class='center bold'>
            Please pay on or before the 05th of {$b['bill_month']}.
        </p>

<p class='center'><em>Thank you for your custom!</em></p>
    </div>
    ";

$count++;
}

/* =========================
   CLOSE HTML & OUTPUT
========================= */
$html .= "
</body>
</html>
";

$mpdf->WriteHTML($html);
$mpdf->Output('emacomBillsFor_.pdf', 'I');
exit;

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2026-03-05 02:02:27
..	dir	-	mboniqkj/nobody	0750	2026-03-05 01:59:52
generated	dir	-	mboniqkj/mboniqkj	0777	2026-01-16 12:48:31
templates	dir	-	mboniqkj/mboniqkj	0755	2026-01-05 05:34:00
.DS_Store	application/octet-stream	6 KB	mboniqkj/mboniqkj	0644	2026-01-30 01:05:40
error_log	text/plain	7.01 KB	mboniqkj/mboniqkj	0644	2026-03-05 09:35:17
generate_bills.php	text/x-php	2.93 KB	mboniqkj/mboniqkj	0644	2026-01-05 05:42:09
generate_monthly_bills.php	text/x-php	4.92 KB	mboniqkj/mboniqkj	0644	2026-01-16 12:51:03
index.php	text/x-php	1.46 KB	mboniqkj/mboniqkj	0644	2026-01-07 11:47:51
sample.php	text/x-php	3.64 KB	mboniqkj/mboniqkj	0644	2026-01-12 06:31:15

Team Anon Force

https://t.me/Professor6T9x