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

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

$bar_print = $_SESSION['bar_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("$bar_print");
$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_number'] . " ";
//     }
// }
// //

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

$get_start = mysqli_query($conn, "SELECT * from sales where  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 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 TX

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

//CHECKING GROSS AMOUNT
    $gross = mysqli_query($conn, "SELECT SUM(subtotal) AS gross_sum FROM byb_walkin_orders where branch_id = '$branch_id'
     and DATE(order_date) = '$today_sales'");
    $row33 = mysqli_fetch_assoc($gross);
    $gross_total = number_format($row33['gross_sum'], 2);

//CHECKING OF PWD TOTAL
    $pwd = mysqli_query($conn, "SELECT SUM(discounted_amount) AS pwd_sum FROM byb_walkin_orders where branch_id = '$branch_id'
    and discount_type = 'PWD' and DATE(order_date) = '$today_sales'");
    $row99 = mysqli_fetch_assoc($pwd);
    $pwd_total = number_format($row99['pwd_sum'], 2);

//CHECKING OF SENIOR TOTAL
    $sen = mysqli_query($conn, "SELECT SUM(discounted_amount) AS sen_sum FROM byb_walkin_orders where branch_id = '$branch_id'
    and discount_type = 'Senior Citizen' and DATE(order_date) = '$today_sales'");
    $row88 = mysqli_fetch_assoc($sen);
    $sen_total = number_format($row88['sen_sum'], 2);

//CHECKING OF REGULAR TOTAL
    $reg = mysqli_query($conn, "SELECT SUM(discounted_amount) AS reg_sum FROM byb_walkin_orders where branch_id = '$branch_id'
    and discount_type = 'Regular' and DATE(order_date) = '$today_sales'");
    $row77 = mysqli_fetch_assoc($reg);
    $reg_total = number_format($row77['reg_sum'], 2);

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

$result7 = mysqli_query($conn, "SELECT SUM(total) AS value_sum FROM sales where branch_id = '$branch_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 payment_type = 'Gcash' and DATE(date) = '$today_sales'");
    $row10 = mysqli_fetch_assoc($result4);
    $Gcash = $row10['value_sum'];

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

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

$added = mysqli_query($conn, "SELECT SUM(cash) as ac from add_cash where branch_id = '$branch_id' and date(date) = '$today_sales'");
    $row96 = mysqli_fetch_assoc($added);
    $added_cash = $row96['ac'];
    if (!$row96) {
        $added_cash = 0;
    }

$starting = mysqli_query($conn, "SELECT SUM(s_cash) as sc from starting_cash where branch_id = '$branch_id' and date(date) = '$today_sales'");
    $row97 = mysqli_fetch_assoc($starting);
    $start_cash = $row97['sc'];
    if (!$row97) {
        $start_cash = 0;
    }

$expsenses = mysqli_query($conn, "SELECT SUM(total) as tot from expense where branch_id = '$branch_id' and date(date) = '$today_sales'");
    $row108 = mysqli_fetch_assoc($expsenses);
    $total_expense = number_format($row108['tot'], 2);
    if (!$row108) {
        $total_expense = 0;
    }

//PRINT BRACH
    $printer->selectPrintMode(Printer::MODE_DOUBLE_WIDTH | Printer::MODE_EMPHASIZED);
    $printer->setJustification(Printer::JUSTIFY_CENTER);
    $printer->text("E-READING \n");
    $printer->selectPrintMode();

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

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

//STARTING CASH AND ADDED CASH
    $printer->setEmphasis(false);
    $printer->text(str_pad("Cash", 32, "-", STR_PAD_BOTH) . "\n \n");
    $printer->setEmphasis(false);
    $printer->text(str_pad("Starting Cash:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad(number_format($start_cash, 2), 11, " ", STR_PAD_LEFT) . "\n");
    $printer->text(str_pad("Added Cash:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad(number_format($added_cash, 2), 11, " ", STR_PAD_LEFT) . "\n \n");
    $printer->setEmphasis(false);

//EXPENSES
    $printer->text(str_pad(" Expenses ", 32, "-", STR_PAD_BOTH) . "\n");
    $printer->text(str_pad("Qty", 5, " ", STR_PAD_RIGHT));
    $printer->text(str_pad("Item", 18, " ", STR_PAD_RIGHT));
    $printer->text(str_pad("Subtotal", 8, " ", STR_PAD_LEFT) . "\n \n");

$sql2 = "SELECT * FROM expense, ingredient WHERE expense.branch_id = '$branch_id' and date(expense.date) = '$today_sales' and expense.ingredient_id = ingredient.ingredient_id";
    $res2 = $conn->query($sql2);
    while ($row = $res2->fetch_assoc()) {
        $total_price = number_format($row['total'], 2);
        $quantity = $row['quantity'];
        $item = $row['ing_name'];

$printer->text(str_pad($quantity, 5, " ", STR_PAD_RIGHT));
        $printer->text(str_pad($item, 16, " ", STR_PAD_RIGHT));
        $printer->text(str_pad($total_price, 10, " ", STR_PAD_LEFT) . "\n");
    }
    $printer->text(str_pad(" ", 32, " ", STR_PAD_LEFT));
    $printer->text(str_pad("Total Expenses:", 22, " ", STR_PAD_LEFT));
    $printer->setEmphasis(true);
    $printer->text(str_pad(number_format($total_expense, 2), 9, " ", STR_PAD_LEFT) . "\n \n");
    $printer->setEmphasis(false);

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

//CASH
    $printer->setEmphasis(false);
    $printer->text(str_pad("Gross Sales:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($gross_total, 11, " ", STR_PAD_LEFT) . "\n");

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

$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($Gcash, 11, " ", STR_PAD_LEFT) . "\n \n");

//PWD

$printer->setEmphasis(false);
    $printer->text(str_pad("Pwd Discount:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($pwd_total, 11, " ", STR_PAD_LEFT) . "\n");

//SENIOR

$printer->setEmphasis(false);
    $printer->text(str_pad("Senior Discount:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($sen_total, 11, " ", STR_PAD_LEFT) . "\n");

//REGULAR
    $printer->setEmphasis(false);
    $printer->text(str_pad("Regular Discount:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(false);
    $printer->text(str_pad($reg_total, 11, " ", STR_PAD_LEFT) . "\n \n \n");

$total_start_cash = $start_cash + $added_cash;
    $total_available_cash = $total_start_cash + $cash;
    $total_cash = $total_available_cash - $total_expense;

// $cash_cash = number_format($total_cash, 2);

$printer->setEmphasis(true);
    $printer->text(str_pad("TOTAL CASH:", 20, " ", STR_PAD_LEFT));
    $printer->setEmphasis(true);
    $printer->text(str_pad(number_format($total_cash, 2), 11, " ", STR_PAD_LEFT) . " \n");

$printer->setEmphasis(true);
    $printer->text(str_pad("NET 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(2);
    $printer->pulse();

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

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

header('location: reports.php');

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: branchSales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation