0) { echo ""; exit; } $data = $item_arr = $option_arr = $mn_arr = $ex_arr = $demolition_arr = $pay_arr = array(); $db_query = "select * from pricereview_main where id = '$id' and creater = '$user_id'"; $res = mysqli_query($link, $db_query); foreach ($res as $data) { $data["qty_total"] = 0; $db_query = "select * from pricereview_item where mid = '$id' order by item_group, item_no"; $res_i = mysqli_query($link, $db_query); while ($row = mysqli_fetch_assoc($res_i)) { if ($row['item_group'] == "A") { $item_arr[$row['item_no']]['id'] = $row['id']; $item_arr[$row['item_no']]['fp_id'] = $row['price_id']; $item_arr[$row['item_no']]['item_op'] = $row['item_op']; $item_arr[$row['item_no']]['item_weight'] = $row['item_weight']; $item_arr[$row['item_no']]['item_spec'] = $row['item_spec']; $item_arr[$row['item_no']]['item_unit_price'] = $row['item_unit_price']; $item_arr[$row['item_no']]['item_qty'] = $row['item_qty']; $item_arr[$row['item_no']]['item_price_bp'] = $row['item_price_bp']; $item_arr[$row['item_no']]['item_price_ct'] = $row['item_price_ct']; $item_arr[$row['item_no']]['item_price'] = $row['item_price']; $item_arr[$row['item_no']]['pv_rate'] = $row['pv_rate']; $item_arr[$row['item_no']]['allocate'] = $row['allocate']; $item_arr[$row['item_no']]['gross_profit'] = $row['gross_profit']; $item_arr[$row['item_no']]['gross_profit_rate'] = $row['gross_profit_rate']; $item_arr[$row['item_no']]['note'] = $row['note']; $item_arr[$row['item_no']]['mi_fix'] = $row['mi_fix']; $data["qty_total"] += $row["item_qty"]; } elseif ($row['item_group'] == "B") { $option_arr[$row['item_no']]['id'] = $row['id']; $option_arr[$row['item_no']]['op_id'] = $row['price_id']; $option_arr[$row['item_no']]['item_spec'] = $row['item_spec']; $option_arr[$row['item_no']]['option_relate_spec'] = $row['option_relate_spec']; $option_arr[$row['item_no']]['item_unit_price'] = $row['item_unit_price']; $option_arr[$row['item_no']]['item_qty'] = $row['item_qty']; $option_arr[$row['item_no']]['item_price_bp'] = $row['item_price_bp']; $option_arr[$row['item_no']]['memo'] = $row['memo']; } elseif ($row['item_group'] == "D") { $mn_arr[$row['item_no']]['id'] = $row['id']; $mn_arr[$row['item_no']]['mn_id'] = $row['price_id']; $mn_arr[$row['item_no']]['item_spec'] = $row['item_spec']; $mn_arr[$row['item_no']]['option_relate_spec'] = $row['option_relate_spec']; $mn_arr[$row['item_no']]['item_unit_price'] = $row['item_unit_price']; $mn_arr[$row['item_no']]['item_qty'] = $row['item_qty']; $mn_arr[$row['item_no']]['item_price_bp'] = $row['item_price_bp']; $mn_arr[$row['item_no']]['note'] = $row['note']; $mn_arr[$row['item_no']]['memo'] = $row['memo']; } elseif ($row['item_group'] == "E") { $ex_arr[$row['item_no']]['id'] = $row['id']; $ex_arr[$row['item_no']]['item_spec'] = $row['item_spec']; $ex_arr[$row['item_no']]['item_unit_price'] = $row['item_unit_price']; $ex_arr[$row['item_no']]['item_qty'] = $row['item_qty']; $ex_arr[$row['item_no']]['item_price_bp'] = $row['item_price_bp']; $ex_arr[$row['item_no']]['note'] = $row['note']; // 詢價單號 } elseif ($row['item_group'] == "C") { $demolition_arr[$row['item_no']]['id'] = $row['id']; $demolition_arr[$row['item_no']]['dem_id'] = $row['price_id']; $demolition_arr[$row['item_no']]['item_spec'] = $row['item_spec']; $demolition_arr[$row['item_no']]['item_unit_price'] = $row['item_unit_price']; $demolition_arr[$row['item_no']]['item_qty'] = $row['item_qty']; $demolition_arr[$row['item_no']]['item_price_bp'] = $row['item_price_bp']; $demolition_arr[$row['item_no']]['note'] = $row['note']; // 樓層 } } mysqli_free_result($res_i); // 付款辦法 $pay_all_scale = $pay_all_amount = 0; $sql = "select * from pricereview_pay where mid = '$id' order by pay_kind"; $res_p = mysqli_query($link, $sql); while ($row_p = mysqli_fetch_assoc($res_p)) { $pay_arr[$row_p["pay_kind"]]["id"] = $row_p["id"]; $pay_arr[$row_p["pay_kind"]]["pay_scale"] = $row_p["pay_scale"]; $pay_arr[$row_p["pay_kind"]]["pay_amount"] = $row_p["pay_amount"]; $pay_arr[$row_p["pay_kind"]]["pay_period"] = $row_p["pay_period"]; $pay_arr[$row_p["pay_kind"]]["pay_note"] = $row_p["pay_note"]; $pay_all_scale += $row_p["pay_scale"]; $pay_all_amount += $row_p["pay_amount"]; } mysqli_free_result($res_p); // Option Data $opt_data_arr = []; $opt_kind_arr = ["A" => "小電梯型錄選配加價報價", "B" => "客梯型錄選配加價報價", "C" => "550-1600kg選配業務報價", "D" => "其它"]; $sql = "select * from option_price where status = 'Y' order by kind, id"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($res)) { $opt_data_arr[$row["kind"]][$row["group_name"]][$row["id"]]["spec"] = $row["spec"]; $opt_data_arr[$row["kind"]][$row["group_name"]][$row["id"]]["memo"] = $row["memo"]; $opt_data_arr[$row["kind"]][$row["group_name"]][$row["id"]]["optional"] = $row["optional"]; $opt_data_arr[$row["kind"]][$row["group_name"]][$row["id"]]["unit"] = $row["unit"]; $opt_data_arr[$row["kind"]][$row["group_name"]][$row["id"]]["price"] = $row["price"]; } mysqli_free_result($res); $option_str = ''; $option_str .= ''; foreach ($opt_data_arr as $k => $v) { //$option_str .= ''; foreach ($v as $k2 => $v2) { foreach ($v2 as $k3 => $v3) { if ($v3["optional"] == "1") $optional = "標"; elseif ($v3["optional"] == "2") $optional = "選"; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; } } /* $group_nums = count($v2); $i = 1; foreach ($v2 as $k3 => $v3) { if ($v3["optional"] == "1") $optional = "標"; elseif ($v3["optional"] == "2") $optional = "選"; $option_str .= ""; if ($i==1) { $option_str .= ''; } else { $option_str .= ''; } $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $option_str .= ""; $i++; } */ } $option_str .= "
名稱 規格 備註 配置 單位 定價
'.$opt_kind_arr[$k].'
" . $k2 . "" . $v3["spec"] . "" . $v3["memo"] . "" . $optional . "" . $v3["unit"] . "" . number_format($v3["price"]) . "
'.$k2.''.$k2.'".$v3["spec"]."".$v3["memo"]."".$optional."".$v3["unit"]."".number_format($v3["price"])."
"; ?>
0) { foreach ($item_arr as $item_no => $v) { if (!empty($v["note"])) list($spec, $seat, $stop, $speed) = explode(",", $v["note"]); else $spec = $seat = $floor = $speed = ""; ?>
整機單價＋
電梯 人乘/載重 停數 速度 開門方式 規格 單價 數量 複價 售價
" readonly> " required> X
小計
0) { foreach ($option_arr as $item_no => $v) { ?>
OPTION加價＋
選配規格 單價 數量 複價 備註
所屬電梯
功能
" readonly> "> " readonly> "; } } } ?> 電梯 X
點選 電梯 X
小計
0) { foreach ($ex_arr as $item_no => $v) { ?>
除外項目＋
詢價單號 名稱 單價 數量 複價
"> "> "> ">"> " readonly> X
X
小計
0) { foreach ($mn_arr as $item_no => $v) { if (!empty($v["note"])) list($seat, $stop, $speed) = explode(",", $v["note"]); else $seat = $stop = $speed = ""; ?>
保固延長＋
電梯 人乘/載重 停數 速度 單價 數量(月) 複價 備註 所屬電梯 功能
" readonly> "> " readonly> "; } } } ?> 電梯 X
電梯 X
小計
0) { foreach ($demolition_arr as $item_no => $v) { if (!empty($v["note"])) $floor = $v["note"]; else $floor = ""; ?>
拆梯價格＋
人乘/載重 樓層 單價 數量 複價
" readonly> "> " readonly> X
X
小計
付款辦法 款別 比例% 金額 票期
材料 1、訂金 "> " readonly>
2、二次款 "> " readonly>
3、貨到工地款 "> " readonly>
4、其它 "> " readonly>
安裝 5、安裝完畢款 "> " readonly>
6、驗收款 "> " readonly>
7、其它 "> " readonly>
合計
備註
" readonly>
" required> ">
" readonly>
">

" required>

" required>
">
">
">
">
" . substr($data["attatch1"], strrpos($data["attatch1"], "/") + 1) . " "; echo 'X'; } ?>
X
" . substr($data["attatch2"], strrpos($data["attatch2"], "/") + 1) . " "; echo 'X'; } ?>
X