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/esgpos.shop/public_html/teanaw/main/pos

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: cashierReport.php

<?php
session_start();
include('../controller/config.php');
date_default_timezone_set('Asia/Manila');
$date = date("M d,Y - h:i A");

$time = date("h:i A");
$cashier_print = $_SESSION['cashier_print'];

if (isset($_SESSION['login_id'])) {

$log_id = $_SESSION['login_id'];

$get_record = mysqli_query($conn, "select * from user, branch where user.user_id ='$log_id' and user.branch_id = branch.branch_id");
    $row = mysqli_fetch_assoc($get_record);
    $log_name = $row['name'];
    $usertype = $row['usertype'];
    $branch_id = $row['branch_id'];
    $branch_name = $row['branch_name'];
    $_SESSION['branch_id'] = $branch_id;

if ($usertype === "admin") {
        header('Location: /admin/index.php');
    } else if ($usertype === "Branch Manager") {
        header('Location: main/branch/index.php');
    } else if ($usertype === "Commisary") {
        header('Location: main/commisary/index.php');
    }
} else {
    header("location: ../../index.php");
}

require __DIR__ . '../../../vendor/autoload.php';

use Mike42\Escpos\PrintConnectors\WindowsPrintConnector;
use Mike42\Escpos\CapabilityProfile;
use Mike42\Escpos\Printer;
use Mike42\Escpos\EscposImage;

$profile = CapabilityProfile::load("simple");
$connector = new WindowsPrintConnector($cashier_print);
$printer = new Printer($connector, $profile);

// // MONTHLY REPORTS
// if (isset($_POST['monthly'])) {

//     $d1 = $_POST['date1'];
//     $d2 = $_POST['date2'];

//     $sql = "SELECT * from sales where date between '$d1' and 'd2' and branch_id = 5";
//     $res = $conn->query($sql);
//     while ($row = $res->fetch_assoc()) {
//         echo $row['order_number'] . " ";
//     }
// }
// //

if (isset($_POST['mySales'])) {
    $today_sales = $_POST['today_sales'];

$get_trans = mysqli_query($conn, "SELECT * from sales where user_id ='$log_id' and branch_id = '$branch_id'");
    $fetch = mysqli_fetch_assoc($get_trans);

$get_start = mysqli_query($conn, "SELECT * from sales where user_id ='$log_id' and branch_id = '$branch_id' and DATE(date) = '$today_sales'  ORDER BY order_number ASC LIMIT 1");
    $row = mysqli_fetch_assoc($get_start);
    $start_or = $row['order_number'];
    $get_time1 = $row['date'];
    $phpdate1 = strtotime($get_time1);
    $start_date = date('h:i A', $phpdate1);
    $date_today = date('M d,Y', $phpdate1);

$get_end = mysqli_query($conn, "SELECT * from sales where user_id ='$log_id' and branch_id = '$branch_id' and DATE(date) = '$today_sales'  ORDER BY order_number DESC LIMIT 1");
    $end = mysqli_fetch_assoc($get_end);
    $end_or = $end['order_number'];
    $get_time = $end['date'];
    $phpdate = strtotime($get_time);
    $end_date = date('h:i A', $phpdate);

//CHECKING TOTAL
    $result = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$branch_id' and user_id = '$log_id'
    and payment_type = 'Cash' and DATE(date) = '$today_sales'");
    $row2 = mysqli_fetch_assoc($result);
    $cash = number_format($row2['value_sum'], 2);
    echo $cash;

$result7 = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$branch_id' and user_id = '$log_id'
    and payment_type = 'Card' and DATE(date) = '$today_sales'");
    $row7 = mysqli_fetch_assoc($result7);
    $card = number_format($row7['value_sum'], 2);
    echo $card;

$result4 = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$branch_id' and user_id = '$log_id'
    and payment_type = 'Gcash' and DATE(date) = '$today_sales'");
    $row10 = mysqli_fetch_assoc($result4);
    $Gcash = $row10['value_sum'];

$result1 = mysqli_query($conn, "SELECT SUM(discounted_amount) AS discount FROM byb_walkin_orders where branch_id = '$branch_id' and DATE(order_date) = '$today_sales'");
    $row5 = mysqli_fetch_assoc($result1);
    $discounted = number_format($row5['discount'], 2);

$result45 = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$branch_id' and user_id = '$log_id'
    and DATE(date) = '$today_sales'");
    $row105 = mysqli_fetch_assoc($result45);
    $total_sales = number_format($row105['value_sum'], 2);

//PRINT FOR CASHIER
    $printer->selectPrintMode(Printer::MODE_DOUBLE_WIDTH | Printer::MODE_EMPHASIZED);
    $printer->setJustification(Printer::JUSTIFY_CENTER);
    $printer->text("CASHIER OUT \n");
    $printer->selectPrintMode();

$printer->text("________________________________ \n");
    //DATE/TIME
    $printer->setJustification(Printer::JUSTIFY_LEFT);
    $printer->setEmphasis(false);
    $printer->text("Cashier: $log_name \n");
    $printer->setJustification(Printer::JUSTIFY_LEFT);
    $printer->setEmphasis(false);
    $printer->text("Date Trans: $date_today \n");
    $printer->setJustification(Printer::JUSTIFY_LEFT);
    $printer->setEmphasis(false);
    $printer->text("Start Trans: $start_date \n");
    $printer->setJustification(Printer::JUSTIFY_LEFT);
    $printer->setEmphasis(false);
    $printer->text("End Trans: $end_date \n \n");

//START RECEIPT
    $printer->setEmphasis(false);
    $printer->text(str_pad("Start Receipt #:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($start_or, 11, " ", STR_PAD_LEFT) . "\n");
    //END RECEIPT
    $printer->setEmphasis(false);
    $printer->text(str_pad("End Receipt #:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($end_or, 11, " ", STR_PAD_LEFT) . "\n \n");

//CASH

$printer->setEmphasis(false);
    $printer->text(str_pad("Cash Sales:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($cash, 11, " ", STR_PAD_LEFT) . "\n");
    //CARD
    $printer->setEmphasis(false);
    $printer->text(str_pad("Card Sales:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($card, 11, " ", STR_PAD_LEFT) . "\n");
    //GCASH

$printer->setEmphasis(false);
    $printer->text(str_pad("Gcash Sales:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad(number_format($Gcash, 2), 11, " ", STR_PAD_LEFT) . "\n \n");

$printer->setEmphasis(true);
    $printer->text(str_pad("TOTAL SALES:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(true);
    $printer->text(str_pad($total_sales, 11, " ", STR_PAD_LEFT) . "\n \n");

$printer->text("________________________________ \n");

$printer->setEmphasis(false);
    $printer->text("Printed: $date \n \n");

$printer->feed(2);
    $printer->pulse();

$printer->cut();
    $printer->close();
}

$_SESSION['status'] = "Ingat po sa Pag-uwi Miss " . $log_name;
$_SESSION['code'] = "success";

header('location: reports.php');

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: cashierReport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation