Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.16.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u226437350

Directory:

/home/u226437350/domains/perlct.in/public_html/erp/ERP & CRM/sales/models

Free Space:

8.52 TB

🔧 Quick Actions

✏️ Editing: sales.model.php

<?php

require_once 'connection.php';

class ModelSales {
    /*=============================================
    SHOWING SALES
    =============================================*/
    static public function mdlShowSales($table, $item, $value) {
        if ($item != null) {
            $connection = new Connection();
            $stmt = $connection->connect()->prepare("SELECT * FROM $table WHERE $item = :$item ORDER BY id ASC");
            $stmt->bindParam(":".$item, $value, PDO::PARAM_STR);
            $stmt->execute();
            return $stmt->fetch();
        } else {
            $connection = new Connection();
            $stmt = $connection->connect()->prepare("SELECT * FROM $table ORDER BY id ASC");
            $stmt->execute();
            return $stmt->fetchAll();
        }
    }

/*=============================================
    REGISTERING SALE
    ==============================================*/
    static public function mdlAddSale($table, $data) {
        $connection = new Connection();
        $stmt = $connection->connect()->prepare("INSERT INTO $table(code, idCustomer, idSeller, products, tax, netPrice, totalPrice, paymentMethod) VALUES (:code, :idCustomer, :idSeller, :products, :tax, :netPrice, :totalPrice, :paymentMethod)");
        $stmt->bindParam(":code", $data["code"], PDO::PARAM_INT);
        $stmt->bindParam(":idCustomer", $data["idCustomer"], PDO::PARAM_INT);
        $stmt->bindParam(":idSeller", $data["idSeller"], PDO::PARAM_INT);
        $stmt->bindParam(":products", $data["products"], PDO::PARAM_STR);
        $stmt->bindParam(":tax", $data["tax"], PDO::PARAM_STR);
        $stmt->bindParam(":netPrice", $data["netPrice"], PDO::PARAM_STR);
        $stmt->bindParam(":totalPrice", $data["totalPrice"], PDO::PARAM_STR);
        $stmt->bindParam(":paymentMethod", $data["paymentMethod"], PDO::PARAM_STR);
        if ($stmt->execute()) {
            return "ok";
        } else {
            return "error";
        }
    }

/*=============================================
    EDIT SALE
    ==============================================*/
    static public function mdlEditSale($table, $data) {
        $connection = new Connection();
        $stmt = $connection->connect()->prepare("UPDATE $table SET  idCustomer = :idCustomer, idSeller = :idSeller, products = :products, tax = :tax, netPrice = :netPrice, totalPrice= :totalPrice, paymentMethod = :paymentMethod WHERE code = :code");
        $stmt->bindParam(":code", $data["code"], PDO::PARAM_INT);
        $stmt->bindParam(":idCustomer", $data["idCustomer"], PDO::PARAM_INT);
        $stmt->bindParam(":idSeller", $data["idSeller"], PDO::PARAM_INT);
        $stmt->bindParam(":products", $data["products"], PDO::PARAM_STR);
        $stmt->bindParam(":tax", $data["tax"], PDO::PARAM_STR);
        $stmt->bindParam(":netPrice", $data["netPrice"], PDO::PARAM_STR);
        $stmt->bindParam(":totalPrice", $data["totalPrice"], PDO::PARAM_STR);
        $stmt->bindParam(":paymentMethod", $data["paymentMethod"], PDO::PARAM_STR);
        if ($stmt->execute()) {
            return "ok";
        } else {
            return "error";
        }
    }

/*=============================================
    DELETE SALE
    ==============================================*/
    static public function mdlDeleteSale($table, $data) {
        $connection = new Connection();
        $stmt = $connection->connect()->prepare("DELETE FROM $table WHERE id = :id");
        $stmt->bindParam(":id", $data, PDO::PARAM_INT);
        if ($stmt->execute()) {
            return "ok";
        } else {
            return "error";
        }
    }

/*=============================================
    DATES RANGE
    ==============================================*/
    static public function mdlSalesDatesRange($table, $initialDate, $finalDate) {
        // ... Your date range code ...
    }

/*=============================================
    Adding TOTAL sales
    ==============================================*/
    public function mdlAddingTotalSales($table) {
        $connection = new Connection();
        $stmt = $connection->connect()->prepare("SELECT SUM(netPrice) as total FROM $table");
        $stmt->execute();
        return $stmt->fetch();
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales.model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation