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/silverconchawavepoolresortandhotel.com/public_html/admin/pos

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: cashierSales.php

<?php
include('user.php');

$get_printer = mysqli_query($conn, "SELECT * from printer where printer_id = 1 ");
$row5 = mysqli_fetch_assoc($get_printer);

$printer = $row5['printer_name'];

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("$printer");
$printer = new Printer($connector, $profile);

date_default_timezone_set('Asia/Manila');
$date = date("M d,Y - h:i A");

$time = date("h:i A");

// // 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_num'] . " ";
//     }
// }
// //

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

$get_trans = mysqli_query($conn, "SELECT * from sales where date(sales_date)='$today_sales'");
    $fetch = mysqli_fetch_assoc($get_trans);

$get_start = mysqli_query($conn, "SELECT * from sales where  DATE(sales_date) ='$today_sales'  ORDER BY order_num ASC LIMIT 1");
    $row = mysqli_fetch_assoc($get_start);
    $start_or = $row['order_num'];
    $get_time1 = $row['sales_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  DATE(sales_date) = '$today_sales'  ORDER BY order_num DESC LIMIT 1");
    $end = mysqli_fetch_assoc($get_end);
    $end_or = $end['order_num'];
    $get_time = $end['sales_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 payment_type = 'CASH' and DATE(sales_date) = '$today_sales'");
    $row2 = mysqli_fetch_assoc($result);
    $cash = number_format($row2['value_sum'], 2);
    echo $cash;

$result4 = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where payment_type = 'G-CASH' and DATE(sales_date) = '$today_sales'");
    $row10 = mysqli_fetch_assoc($result4);
    $Gcash = number_format($row10['value_sum'], 2);

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

//PRINT FOR CASHIER
    $printer->text("\n");
    $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");

//GCASH

$printer->setEmphasis(false);
    $printer->text(str_pad("Gcash Sales:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($Gcash, 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(3);
    $printer->pulse();

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

$_SESSION['status'] = "Printing Reports!";
$_SESSION['code'] = "success";

header('location: mySales.php');

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: cashierSales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation