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: printSales.php

<?php
session_start();
include('../controller/config.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");

$si = $_SESSION['order_num'];

if (isset($_POST['generate'])) {

$today_sales = $_POST['report_date'];

$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 TX

$result59 = mysqli_query($conn, "SELECT count(1) FROM sales where DATE(sales_date) = '$today_sales'");
    $row59 = mysqli_fetch_array($result59);
    $total_tx = $row59[0];

//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);

$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 BRACH
    $printer->text("\n");
    $printer->selectPrintMode(Printer::MODE_DOUBLE_WIDTH | Printer::MODE_EMPHASIZED);
    $printer->setJustification(Printer::JUSTIFY_CENTER);
    $printer->text("E-READING \n\n");
    $printer->selectPrintMode();

$printer->text(str_pad("-", 32, "-", STR_PAD_BOTH) . " \n ");

$printer->setEmphasis(false);
    $printer->text("Printed: $date \n \n");
    //DATE/TIME
    $printer->setJustification(Printer::JUSTIFY_LEFT);
    $printer->setEmphasis(false);
    $printer->text("Shop: Boss Jon - SC \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");

//SALES
    $printer->text(str_pad(" Sales ", 32, "-", STR_PAD_BOTH) . "\n \n");
    $printer->setEmphasis(false);
    $printer->text(str_pad("No. of Trx:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($total_tx, 11, " ", STR_PAD_LEFT) . "\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");

$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");

//PWD

$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->setEmphasis(false);
    $printer->text(str_pad(" End of E-Reading ", 32, "-", STR_PAD_BOTH) . " \n");
    $printer->setEmphasis(false);
    $printer->text(str_pad("Via Cash Drawer Screen", 32, " ", STR_PAD_BOTH) . " \n ");

$printer->feed();
    // Demo that alignment QRcode is the same as text
    $printer2 = new Printer($connector); // dirty printer profile hack !!
    $printer2->setJustification(Printer::JUSTIFY_CENTER);
    $printer2->qrCode("https://facebook.com/ejie13", Printer::QR_ECLEVEL_M, 6);
    $printer2->text("ESG IT-Solutions \n");
    $printer2->setJustification();
    $printer2->feed();

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

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

$_SESSION['status'] = "Sales Successfully Generated!";
$_SESSION['code'] = "success";

header('location: mySales.php');

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: printSales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation