Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/wwwroot/sd.electronharmony.com/invoice/

View File Name : add_invoice.php

<?php
include '../sql/sql.php'; // 包含数据库连接

// 设置时区为美国洛杉矶
date_default_timezone_set('America/Los_Angeles');

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // 数据校验
    $fields = ['one_dollar_qty', 'one_dollar_total', 'five_dollar_qty', 'five_dollar_total',
               'ten_dollar_qty', 'ten_dollar_total', 'twenty_dollar_qty', 'twenty_dollar_total',
               'fifty_dollar_qty', 'fifty_dollar_total', 'hundred_dollar_qty', 'hundred_dollar_total',
               'daily_float_amount', 'daily_cash_intake', 'tip_amount', 'cash_out_amount', 'grand_total'];

    $validated_data = [];
    
    foreach ($fields as $field) {
        // 检查是否存在字段并且不为空
        if (!isset($_POST[$field]) || empty(trim($_POST[$field]))) {
            die("Invalid input for $field. Please ensure all fields are filled.");
        }
        $validated_data[$field] = trim($_POST[$field]); // 去除首尾空格
    }

    // 自动生成日期
    $date = date('Y-m-d');

    // 插入数据到 invoice 表
    $sql = "INSERT INTO invoice (
        one_dollar_qty, one_dollar_total, five_dollar_qty, five_dollar_total, 
        ten_dollar_qty, ten_dollar_total, twenty_dollar_qty, twenty_dollar_total, 
        fifty_dollar_qty, fifty_dollar_total, hundred_dollar_qty, hundred_dollar_total, 
        daily_float_amount, daily_cash_intake, tip_amount, cash_out_amount, grand_total, date
    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    $stmt = $conn->prepare($sql);

    if (!$stmt) {
        die("Statement preparation failed: " . $conn->error);
    }

    // 绑定参数
    $stmt->bind_param(
        "ssssssssssssssssss", // 全部字段为字符串类型
        $validated_data['one_dollar_qty'], $validated_data['one_dollar_total'],
        $validated_data['five_dollar_qty'], $validated_data['five_dollar_total'],
        $validated_data['ten_dollar_qty'], $validated_data['ten_dollar_total'],
        $validated_data['twenty_dollar_qty'], $validated_data['twenty_dollar_total'],
        $validated_data['fifty_dollar_qty'], $validated_data['fifty_dollar_total'],
        $validated_data['hundred_dollar_qty'], $validated_data['hundred_dollar_total'],
        $validated_data['daily_float_amount'], $validated_data['daily_cash_intake'],
        $validated_data['tip_amount'], $validated_data['cash_out_amount'],
        $validated_data['grand_total'], $date
    );

    // 执行语句
    if ($stmt->execute()) {
        echo "<script>alert('Invoice saved successfully!'); window.location.href = ' invoice.php';</script>";
    } else {
        echo "<script>alert('Error saving invoice: " . $stmt->error . "'); window.history.back();</script>";
    }

    $stmt->close();
    $conn->close();
}
?>