You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
164 lines
4.6 KiB
164 lines
4.6 KiB
<!doctype html>
|
|
<html lang="en">
|
|
|
|
<!-- 主頁header -->
|
|
<?php
|
|
/*--- 處理session ----*/
|
|
include "include-session-security.php"; #確認session
|
|
|
|
/*
|
|
if(isset($_SESSION['user_id'])){
|
|
#echo $_SESSION['user_id'];
|
|
$userid = $_SESSION['user_id'];
|
|
}
|
|
*/
|
|
/*--- 處理session ----*/
|
|
|
|
#$userid = "B000000001";
|
|
#$repairerid = $user_id;
|
|
$category = $_POST["category"];
|
|
$insert_flag = 0;
|
|
#echo $category;
|
|
|
|
require_once "db/database.php"; # 載入db.php來連結資料庫
|
|
|
|
# 接受自己傳來的資料並insert進數據庫
|
|
if (isset($_POST['action'])) {
|
|
if (($_POST['action'] = "insert") and ($_POST["quantity"] > 0)){
|
|
|
|
# 取得userid的name
|
|
$data = array();
|
|
$sql = "select name from account where accountid = '$user_id'";
|
|
$data = mysqli_query($link,$sql);
|
|
foreach($data as $data){
|
|
$name = $data['name'];
|
|
}
|
|
|
|
# 取得數據庫最大值與order_id
|
|
$data = array();
|
|
$sql = "select max(id) from pre_order";
|
|
$data = mysqli_query($link,$sql);
|
|
foreach($data as $data){
|
|
$id = $data['max(id)'];
|
|
}
|
|
$order_id = "OR_" . date("Y-m-d") . "-" . strval(intval(strval($id)) + 1);
|
|
|
|
$equipment_id = $_POST["equipment_id"];
|
|
$equipment_name = $_POST["equipment_name"];
|
|
$brand = $_POST["brand"];
|
|
$spec = $_POST["spec"];
|
|
$picture = $_POST["picture"];
|
|
$count_type = $_POST["count_type"];
|
|
$price = $_POST["price"];
|
|
$quantity = $_POST["quantity"];
|
|
$total_price = bcmul($price, $quantity, 2); #避免数据不准确
|
|
$orderer_id = $user_id;
|
|
$orderer_name = $name;
|
|
$status = "C"; # carts (存入購物車)
|
|
$create_at = date("Y-m-d H:i:s");
|
|
|
|
$sql = "INSERT INTO pre_order (order_id, equipment_id, equipment_name, brand, spec, picture, count_type, price, quantity, total_price, orderer_id, orderer_name, status, create_at) values " .
|
|
"('$order_id', '$equipment_id', '$equipment_name', '$brand', '$spec', '$picture', '$count_type', '$price', '$quantity', '$total_price', '$orderer_id', '$orderer_name', '$status', '$create_at')";
|
|
|
|
/* # insert單筆資料
|
|
$sql = "INSERT INTO pre_order (order_id, equipment_id) " .
|
|
"values ('$order_id', '$equipment_id')";# sql語法存在變數中
|
|
*/
|
|
# insert多筆資料
|
|
#$sql = "INSERT INTO pre_order (order_id, equipment_id) " .
|
|
# "values ('$order_id', '$equipment_id'), " .
|
|
# "('$order_id', '$equipment_id'), " .
|
|
# "('$order_id', '$equipment_id')";# sql語法存在變數中
|
|
|
|
$data = mysqli_query($link,$sql); # 機房在combo table中的id (亦即每個保養項的ID)
|
|
$insert_flag = 1;
|
|
}
|
|
}
|
|
|
|
|
|
include "include-header.php";
|
|
?>
|
|
<!-- * 主頁header -->
|
|
|
|
<body class="bg-white">
|
|
|
|
<!-- loader -->
|
|
<div id="loader">
|
|
<div class="spinner-border text-primary" role="status"></div>
|
|
</div>
|
|
<!-- * loader -->
|
|
|
|
<!-- App Header -->
|
|
<div class="appHeader no-border transparent position-absolute">
|
|
<!-- 已簽呈成功，不讓返回上一頁
|
|
<div class="left">
|
|
<a href="javascript:;" class="headerButton goBack">
|
|
<ion-icon name="chevron-back-outline"></ion-icon>
|
|
</a>
|
|
</div>
|
|
-->
|
|
<div class="pageTitle"></div>
|
|
<!--
|
|
<div class="right">
|
|
</div>
|
|
-->
|
|
</div>
|
|
<!-- * App Header -->
|
|
|
|
<!-- App Capsule -->
|
|
<div id="appCapsule">
|
|
<?php
|
|
if ($insert_flag == 0){
|
|
echo "<div class='alert alert-danger alert-dismissible fade show' role='alert'>";
|
|
}else{
|
|
echo "<div class='alert alert-primary alert-dismissible fade show' role='alert'>";
|
|
}
|
|
?>
|
|
<h4 class="alert-title">
|
|
<?php
|
|
if ($insert_flag == 0){
|
|
echo "請輸入數量";
|
|
}else{
|
|
echo "已加入購物車";
|
|
}
|
|
?>
|
|
</h4>
|
|
<button type="button" class="close" data-dismiss="alert">
|
|
<ion-icon name="close-outline"></ion-icon>
|
|
</button>
|
|
</div>
|
|
|
|
<div class="login-form">
|
|
<div class="section">
|
|
<h4></h4>
|
|
<a href="app-products.php?token=<?php echo $token; ?>"><button type="button" class="btn btn-success mr-1 mb-1">回到備品總類</button></a>
|
|
<a href="app-productsdetail.php?category=<?php echo $category; ?>&token=<?php echo $token; ?>"><button type="button" class="btn btn-primary mr-1 mb-1">回到前一頁</button></a>
|
|
<a href="app-productscart.php?token=<?php echo $token; ?>"><button type="button" class="btn btn-warning mr-1 mb-1">我的購物車</button></a>
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
<!-- * App Capsule -->
|
|
|
|
<!-- 主頁頁尾 -->
|
|
<?php
|
|
include "include-footer.php";
|
|
mysqli_close($link); #代表結束連線
|
|
?>
|
|
<!-- * 主頁頁尾 -->
|
|
|
|
<!-- 主頁頁尾按鈕 -->
|
|
<?php
|
|
# include "include-bottom-menu.php";
|
|
?>
|
|
<!-- * 主頁頁尾按鈕 -->
|
|
|
|
<!-- ///////////// Js Files //////////////////// -->
|
|
<!-- Jquery -->
|
|
<?php
|
|
include "include-jsfiles.php";
|
|
?>
|
|
|
|
</body>
|
|
|
|
</html>
|