"; echo "alert('客戶資料錯誤!');"; echo "location.href='../crm/crmm01-index.php?function_name=customer&" . $token_link . "';"; echo ""; echo ""; exit; } // 同一卷號只限一筆價審 $sql = "select count(*) from pricereview_main where contractno = '$vol_no' and status in ('Y1', 'YS', 'YY')"; $res = mysqli_query($link, $sql); $row = mysqli_fetch_row($res); if ($row[0] > 0) { echo ""; exit; } // 退回重填價審，帶出上次價審內容 $last_pr_arr = $last_pritem_arr = $last_prpay_arr = []; $sql = "select * from pricereview_main where contractno = '$vol_no' and status in ('YN', 'D') order by id limit 1"; $res = mysqli_query($link, $sql); if ($row = mysqli_fetch_assoc($res)) { $last_pr_arr = $row; } mysqli_free_result($res); if (count($last_pr_arr) > 0) { $last_pr_arr["qty_total"] = $last_pr_arr["pay_all_scale"] = $last_pr_arr["pay_all_amount"] = 0; $sql = "select * from pricereview_item where mid = '" . $last_pr_arr["id"] . "'"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($res)) { $last_pritem_arr[$row["item_group"]][$row["item_no"]] = $row; if (isset($last_pritem_arr["A"][$row["item_no"]])) { $last_pr_arr["qty_total"] += $last_pritem_arr["A"][$row["item_no"]]["item_qty"]; } } mysqli_free_result($res); $sql = "select * from pricereview_pay where mid = '" . $last_pr_arr["id"] . "' order by pay_kind"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($res)) { $last_prpay_arr[$row["pay_kind"]] = $row; $last_pr_arr["pay_all_scale"] += $last_prpay_arr[$row["pay_kind"]]["pay_scale"]; $last_pr_arr["pay_all_amount"] += $last_prpay_arr[$row["pay_kind"]]["pay_amount"]; } mysqli_free_result($res); } // 開門方式 $op_arr = []; $sql = "select code_name, content from code where field_name = 'open_kind'"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_row($res)) { $op_arr[$row[0]] = $row[1]; } mysqli_free_result($res); // 在有望客戶建的電梯項目 $hope_elev_spec_arr = []; $hope_elev_spec_amt = $hope_elev_spec_num = 0; $sql = "select seq, specifications, person, weight, stop, speed, spec_num, spec_price, open from hope_project_elevator_spec where vol_no = '$vol_no' order by seq"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_row($res)) { $hope_elev_spec_arr[$row[0]]["spec"] = $row[1]; if (preg_match("/^[G|A]/", $row[2])) { $hope_elev_spec_arr[$row[0]]["person"] = ""; $hope_elev_spec_arr[$row[0]]["weight"] = ""; $hope_elev_spec_arr[$row[0]]["series"] = $row[2]; $hope_elev_spec_arr[$row[0]]["open"] = ""; } elseif (strlen($row[2]) == 7) { $hope_elev_spec_arr[$row[0]]["person"] = ""; $hope_elev_spec_arr[$row[0]]["weight"] = ""; $hope_elev_spec_arr[$row[0]]["series"] = ""; $hope_elev_spec_arr[$row[0]]["open"] = $row[2]; } elseif (strlen($row[2]) >= 3) { $hope_elev_spec_arr[$row[0]]["person"] = ""; $hope_elev_spec_arr[$row[0]]["weight"] = $row[2]; $hope_elev_spec_arr[$row[0]]["series"] = ""; $hope_elev_spec_arr[$row[0]]["open"] = ""; } else { $hope_elev_spec_arr[$row[0]]["person"] = $row[2]; $hope_elev_spec_arr[$row[0]]["weight"] = ""; $hope_elev_spec_arr[$row[0]]["series"] = ""; $hope_elev_spec_arr[$row[0]]["open"] = ""; } $hope_elev_spec_arr[$row[0]]["stop"] = $row[4]; $hope_elev_spec_arr[$row[0]]["speed"] = $row[5]; $hope_elev_spec_arr[$row[0]]["spec_num"] = $row[6]; $hope_elev_spec_arr[$row[0]]["spec_price"] = $row[7]; $hope_elev_spec_arr[$row[0]]["op"] = $op_arr[$row[8]]; $hope_elev_spec_amt += $row[6] * $row[7]; $hope_elev_spec_num += $row[6]; } mysqli_free_result($res); // 在有望客戶建的option項目 $hope_opt_arr = []; $h = 1; $hope_elev_opt_amt = 0; $sql = "select a.spec, a.price, a.id from hope_elevator_option_price a "; $sql .= "where a.vol_no = '$vol_no'"; $res = mysqli_query($link, $sql); while ($row = mysqli_fetch_row($res)) { $hope_opt_arr[$h]["seat"] = $row[0]; $hope_opt_arr[$h]["option_price"] = $row[1]; $hope_opt_arr[$h]["id"] = $row[2]; $hope_opt_arr[$h]["option_num"] = 1; $hope_elev_opt_amt += $row[1]; $h++; } mysqli_free_result($res); if ($last_pr_arr) { $price_total = $last_pr_arr["price_total"]; $qty_total = $last_pr_arr["qty_total"]; } else { $price_total = $hope_elev_spec_amt; // + $hope_elev_opt_amt; $qty_total = $hope_elev_spec_num; } // 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"])."
"; ?>
Please fill up the required field!

"; } else { echo "

Record has added successfully

"; } } */ ?>
" enctype="multipart/form-data">
0 && isset($last_pritem_arr["A"])) { foreach ($last_pritem_arr["A"] as $k => $v) { list($last_pritem_kind, $last_pritem_seat, $last_pritem_numberofstop, $last_pritem_speed) = explode(",", $v["note"]); ?> 0) { foreach ($hope_elev_spec_arr as $k => $v) { ?>
整機單價＋
電梯 人乘/載重 停數 速度 開門方式 規格 單價 數量 複價 售價
" readonly> " readonly> ">"> " readonly> " required> X
"> " readonly> ">"> " readonly> " required> X
X
小計
0 && isset($last_pritem_arr["B"])) { foreach ($last_pritem_arr["B"] as $k => $v) { ?> 0) { foreach ($hope_opt_arr as $k => $v) { ?>
OPTION加價＋
選配規格 單價 數量 複價 備註
所屬電梯
功能
" readonly> "> " readonly> "> "> 電梯 X
" readonly> "> " readonly> "> 電梯 X
點選 " readonly> "> " readonly> 電梯 X
小計
0 && isset($last_pritem_arr["E"])) { foreach ($last_pritem_arr["E"] as $k => $v) { ?>
除外項目＋
詢價單號 名稱 單價 數量 複價
"> " readonly> " readonly> ">"> " readonly> X
X
小計
0 && isset($last_pritem_arr["D"])) { foreach ($last_pritem_arr["D"] as $k => $v) { list($last_pritem_seat, $last_pritem_numberofstop, $last_pritem_speed) = explode(",", $v["note"]); ?>
保固延長＋
電梯 人乘/載重 停數 速度 單價 數量(月) 複價 備註 所屬電梯 功能
" readonly> ">"> " readonly> 電梯 X
電梯 X
小計
0 && isset($last_pritem_arr["C"])) { foreach ($last_pritem_arr["C"] as $k => $v) { //list($seat, $floor) = explode(",", $v["item_spec"]); list($seat, $floor) = array_pad(explode(",", $v["item_spec"]), 2, null); // 換個寫法，避免undefined offset ?>
拆梯價格＋
人乘/載重 樓層 單價 數量 複價
" readonly> "> " readonly> X
X
小計
付款辦法 款別 比例% 金額 票期
材料 1、訂金 "> " readonly>
2、二次款 "> " readonly>
3、貨到工地款 "> " readonly>
4、其它 "> " readonly>
安裝 5、安裝完畢款 "> " readonly>
6、驗收款 "> " readonly>
7、其它 "> " readonly>
合計 " readonly> " readonly>
備註
" readonly>
" readonly>
" readonly>
">
0) { echo number_format(($last_pr_arr["price_total"] - $last_pr_arr["price_lowest"]) / $last_pr_arr["qty_total"]); } ?>" readonly>

" required>

" required>
">
">
">
">
X
X