Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/cheatday.store/public_html/main/commisary

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: printDispatched.php

<?php
include('../controller/config.php');
require('../fpdf/fpdf.php');

$date = $_GET['id'];

// date_default_timezone_set('Asia/Manila');
// $date = date("M d, Y");
$newDate = date("M d, Y", strtotime($date));

$image = "../img/logo.png";

//CELL (witdh, height, text, border, endline, align)

$pdf = new FPDF('P', 'mm', "A4");
$pdf->AddPage();

$pdf->SetFont('Arial', 'B', '20');
$pdf->Cell(80, 10, '', 0, 0);
$pdf->Cell(219, 10, $pdf->Image($image, $pdf->GetX(), $pdf->GetY(), 33.78), 0, 0, 'R', false);
$pdf->Cell(59, 10, '', 0, 1);
$pdf->Cell(59, 9, '', 0, 1);

//CELL (witdh, height, text, border, endline, align)

$pdf->SetFont('Arial', 'B', 11);
$pdf->Cell(59, 2, '', 0, 1);
$pdf->Cell(194, 4, '(Commissary)', 0, 1, 'C');
$pdf->Cell(80, 4, '', 0, 1);
$pdf->SetFont('Arial', 'B', 13);
$pdf->Cell(194, 10, 'DISPATCHED REPORT', 0, 1, 'C');

// $pdf->Cell(90, 4, 'Order #: ' . $order_num, 0, 0);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(194, 4, 'Date: ' . $newDate, 0, 1, 'L');
// $pdf->Cell(90, 4, 'Branch: ' . $branch_name, 0, 0);
// $pdf->Cell(99, 4, 'Pin: ' . $pin, 0, 1, 'R');

//$pdf->SetFillColor(250, 250, 0); yellow
// blue 0, 0, 250
$pdf->Cell(80, 2, '', 0, 1);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(110, 6, 'Item Name', 1, 0, 'L');
$pdf->Cell(50, 6, 'Quantity', 1, 0, 'C');
$pdf->Cell(30, 6, 'Remarks', 1, 1, 'C');

$sql = "SELECT ingredient.ing_name, SUM(order_item.quantity) as count FROM ingredient, branch_order, order_item WHERE
 branch_order.b_order_id = order_item.b_order_id and order_item.ingredient_id = ingredient.ingredient_id and branch_order.d_status = 'Delivered'and
 date(branch_order.order_date) = '$date' GROUP by ingredient.ing_name";
$res = $conn->query($sql);
while ($row = $res->fetch_assoc()) {
    $ing_name = $row['ing_name'];
    $count = $row['count'];

$pdf->SetFont('Arial', '', 10);
    $pdf->Cell(110, 6, $ing_name, 1, 0, 'L');
    $pdf->Cell(50, 6, $count, 1, 0, 'C');
    $pdf->Cell(30, 6, '', 1, 1, 'C');
}

if (mysqli_num_rows($res) < 25) {
    $empty_rows = 25 - mysqli_num_rows($res);

for ($i = 0; $i < $empty_rows; $i++) {
        $pdf->Cell(110, 6, '', 1, 0, 'L');
        $pdf->Cell(50, 6, '', 1, 0, 'C');
        $pdf->Cell(30, 6, '', 1, 1, 'R');
    }
}

$pdf->Cell(80, 10, '', 0, 1);
$pdf->Cell(97, 4, '_____________________', 0, 0, 'L');
$pdf->Cell(94, 4, '_____________________', 0, 1, 'R');
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(97, 5, '        Checked By:', 0, 0, 'L');
$pdf->Cell(94, 5, '  Noted By:             ', 0, 0, 'R');

$pdf->Output();

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: printDispatched.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation