Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/pawn

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: save_service.php

<?php
/**
 * save_service.php
 * Saves SERVICE invoice using existing schema
 */

ob_start();
ini_set('display_errors', 0);
error_reporting(E_ALL);

header('Content-Type: application/json; charset=utf-8');

require_once __DIR__ . '/includes/db.php';

if (!isset($conn) || !($conn instanceof mysqli)) {
    http_response_code(500);
    echo json_encode(['success' => false, 'message' => 'DB connection failed']);
    exit;
}

$payload = json_decode(file_get_contents('php://input'), true);

if (!$payload) {
    echo json_encode(['success' => false, 'message' => 'Invalid JSON']);
    exit;
}

/* -------------------------
   REQUIRED FIELDS
--------------------------*/
$customer_name = trim($payload['customer_name'] ?? 'Walk-in-Customer');
$customer_phone = trim($payload['customer_phone'] ?? '');
$items = $payload['items'] ?? [];

if (empty($items)) {
    echo json_encode(['success' => false, 'message' => 'No service items']);
    exit;
}

/* -------------------------
   TRANSACTION START
--------------------------*/
$conn->begin_transaction();

try {

/* -------------------------
       CUSTOMER (reuse or create)
    --------------------------*/
    $stmt = $conn->prepare("SELECT id FROM customers WHERE phone = ? LIMIT 1");
    $stmt->bind_param("s", $customer_phone);
    $stmt->execute();
    $res = $stmt->get_result();

if ($res->num_rows > 0) {
        $customer_id = $res->fetch_assoc()['id'];
    } else {
        $stmt = $conn->prepare(
            "INSERT INTO customers (name, phone, created_at) VALUES (?, ?, NOW())"
        );
        $stmt->bind_param("ss", $customer_name, $customer_phone);
        $stmt->execute();
        $customer_id = $stmt->insert_id;
    }

/* -------------------------
       INVOICE TOTALS
    --------------------------*/
    $subtotal = (float)$payload['subtotal'];
    $discount = (float)($payload['discount'] ?? 0);
    $discount_type = $payload['discount_type'] ?? 'percent';
    $total = (float)$payload['total'];
    $cash_received = (float)($payload['cash_received'] ?? 0);
    $change_given = (float)($payload['change_given'] ?? 0);

$total_gst  = (float)($payload['total_gst'] ?? 0);
    $total_cgst = (float)($payload['total_cgst'] ?? 0);
    $total_sgst = (float)($payload['total_sgst'] ?? 0);

$business_id   = $payload['business_id'] ?? null;
    $business_name = $payload['business_name'] ?? null;
    $gst_number    = $payload['gst_number'] ?? null;

$template_file = $payload['template_file'] ?? null;
    $template_name = $payload['template_name'] ?? null;

$service_date  = $payload['service_date'] ?? date('Y-m-d');
    $service_notes = $payload['service_notes'] ?? '';

$invoice_number = 'SRV' . date('YmdHis') . rand(100, 999);

/* -------------------------
       INSERT INVOICE
    --------------------------*/
    $stmt = $conn->prepare("
        INSERT INTO invoices (
            customer_id, invoice_number, subtotal, discount, discount_type,
            total, cash_received, change_given, payment_method,
            service_type, business_id, business_name, gst_number,
            template_file, template_name,
            service_date, service_notes,
            created_at, total_item_discount,
            total_gst, total_cgst, total_sgst
        ) VALUES (
            ?, ?, ?, ?, ?, ?, ?, ?, 'cash',
            'service', ?, ?, ?,
            ?, ?, ?, ?, NOW(), 0,
            ?, ?, ?
        )
    ");

$stmt->bind_param(
        "isdddsddissssssddd",
        $customer_id,
        $invoice_number,
        $subtotal,
        $discount,
        $discount_type,
        $total,
        $cash_received,
        $change_given,
        $business_id,
        $business_name,
        $gst_number,
        $template_file,
        $template_name,
        $service_date,
        $service_notes,
        $total_gst,
        $total_cgst,
        $total_sgst
    );

$stmt->execute();
    $invoice_id = $stmt->insert_id;

/* -------------------------
       INSERT INVOICE ITEMS
    --------------------------*/
    foreach ($items as $item) {

$stmt = $conn->prepare("
            INSERT INTO invoice_items (
                service_id, invoice_id, product_name, quantity,
                original_price, discounted_price, total_price,
                product_category, duration, technician,
                service_date, discount, discount_type,
                item_discount, product_code, hsn_code,
                is_gst_applicable, gst_percentage,
                gst_amount, cgst_amount, sgst_amount,
                item_type
            ) VALUES (
                ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'service'
            )
        ");

$stmt->bind_param(
            "iisiiddssssdsdsisdddd",
            $item['id'],
            $invoice_id,
            $item['name'],
            $item['quantity'],
            $item['price'],
            $item['price'],
            $item['total_price'],
            $item['category'],
            $item['duration'],
            $item['technician'],
            $service_date,
            $item['discount'],
            $item['discount_type'],
            $item['item_discount'],
            $item['product_code'],
            $item['hsn_code'],
            $item['is_gst_applicable'],
            $item['gst_percentage'],
            $item['gst_amount'],
            $item['cgst_amount'],
            $item['sgst_amount']
        );

$stmt->execute();

/* -------------------------
           SERVICE SALES LOG
        --------------------------*/
        $stmt2 = $conn->prepare("
            INSERT INTO service_sales (
                service_id, customer_id, quantity, price,
                total_amount, discount, tax, payment_method,
                service_date, technician_name, notes,
                business_id, invoice_id
            ) VALUES (
                ?, ?, ?, ?, ?, ?, ?, 'cash',
                ?, ?, ?, ?, ?
            )
        ");

$stmt2->bind_param(
            "iiiddddsssii",
            $item['id'],
            $customer_id,
            $item['quantity'],
            $item['price'],
            $item['total_price'],
            $item['discount'],
            $item['gst_amount'],
            $service_date,
            $item['technician'],
            $service_notes,
            $business_id,
            $invoice_id
        );

$stmt2->execute();
    }

/* -------------------------
       COMMIT
    --------------------------*/
    $conn->commit();

echo json_encode([
        'success' => true,
        'invoice_id' => $invoice_id,
        'invoice_number' => $invoice_number
    ]);
    exit;

} catch (Exception $e) {
    $conn->rollback();
    echo json_encode([
        'success' => false,
        'message' => $e->getMessage()
    ]);
    exit;
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: save_service.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation