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.
308 lines
13 KiB
308 lines
13 KiB
<?php
|
|
include "header.php";
|
|
$id = isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID not found.');
|
|
$st = $_GET["st"];
|
|
if ($st != 1 && $st != 2 && $st != 3) header("Location: pricereview-index.php");
|
|
|
|
require_once "database.php"; // get $link
|
|
|
|
$data = $item_arr = array();
|
|
$db_query = "select * from pricereview_main where id = '$id'";
|
|
/*
|
|
if ($res = mysqli_query($link, $db_query)) {
|
|
while ($row = mysqli_fetch_row($res)) {
|
|
list($id, $version, $company)
|
|
}
|
|
}
|
|
*/
|
|
$res = mysqli_query($link, $db_query);
|
|
foreach ($res as $data) {
|
|
if (!$data["checker_1"] && !$data["checker_2"] && !$data["checker_3"]) $allow_st = 1;
|
|
else if (!$data["checker_2"] && !$data["checker_3"]) $allow_st = 2;
|
|
else if (!$data["checker_3"]) $allow_st = 3;
|
|
if ($data["checker_1_result"]) {
|
|
if ($data["checker_1_result"] == "Y") $checker_1_result = "通過";
|
|
else if ($data["checker_1_result"] == "N") {
|
|
$stopchk = 1;
|
|
$checker_1_result = "拒絕";
|
|
}
|
|
}
|
|
if ($data["checker_2_result"]) {
|
|
if ($data["checker_2_result"] == "Y") $checker_2_result = "通過";
|
|
else if ($data["checker_2_result"] == "N") {
|
|
$stopchk = 1;
|
|
$checker_2_result = "拒絕";
|
|
}
|
|
}
|
|
if ($data["checker_3_result"]) {
|
|
if ($data["checker_3_result"] == "Y") $checker_3_result = "通過";
|
|
else if ($data["checker_3_result"] == "N") {
|
|
$stopchk = 1;
|
|
$checker_3_result = "拒絕";
|
|
}
|
|
}
|
|
|
|
/*
|
|
if ($st != $allow_st) {
|
|
mysqli_free_result($res);
|
|
mysqli_close($link);
|
|
echo "<script>";
|
|
echo "alert('請依序審核');";
|
|
echo "location.href='pricereview-index.php'";
|
|
echo "</script>";
|
|
}
|
|
*/
|
|
$mid = $data["id"];
|
|
$db_query = "select * from pricereview_item where mid = '$mid' order by item_no";
|
|
$res_i = mysqli_query($link, $db_query);
|
|
while ($row = mysqli_fetch_assoc($res_i)) {
|
|
$item_arr[$row['item_no']]['fp_id'] = $row['fp_id'];
|
|
$item_arr[$row['item_no']]['item_group'] = $row['item_group'];
|
|
$item_arr[$row['item_no']]['item_spec'] = $row['item_spec'];
|
|
$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'] = $row['item_price'];
|
|
$item_arr[$row['item_no']]['pv_rate'] = $row['pv_rate'];
|
|
$item_arr[$row['item_no']]['note'] = $row['note'];
|
|
$data["qty_total"] += $row["item_qty"];
|
|
if ($row['item_group'] == "A") $fp_id_str .= $row['fp_id'].",";
|
|
}
|
|
mysqli_free_result($res_i);
|
|
|
|
$data["price_total_broken"] = $data["price_total"] - $data["price_lowest"];
|
|
$data["price_rate"] = ($data["price_lowest"]) ? round(($data["price_total"]/$data["price_lowest"])*100, 2) : 0;
|
|
$data["price_broken"] = ($data["qty_total"]) ? round($data["price_total_broken"]/$data["qty_total"], 1) : 0;
|
|
?>
|
|
<script>
|
|
$(function () {
|
|
$(":input").prop("disabled", true);
|
|
$("#checker").prop("disabled", false);
|
|
$("#status_n").prop("disabled", false);
|
|
$("#status_y").prop("disabled", false);
|
|
$("#id").prop("disabled", false);
|
|
$("#st").prop("disabled", false);
|
|
});
|
|
</script>
|
|
<div class="container">
|
|
<form class="form-inline" method="post" action="pricereview-record-check.php" enctype="multipart/form-data">
|
|
<input type="hidden" name="id" id="id" value="<?=$id;?>">
|
|
<input type="hidden" name="st" id="st" value="<?=$st;?>">
|
|
<div>
|
|
<label for="contractno">卷號</label>
|
|
<input type="text" name="contractno" id="contractno" maxlength="7" value="<?=$data["contractno"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="person">營業員</label>
|
|
<input type="text" name="person" id="person" value="<?=$data["person"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="company">客戶名稱</label>
|
|
<input type="text" name="company" id="company" value="<?=$data["company"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="case_name">案件名稱</label>
|
|
<input type="text" name="case_name" id="case_name" value="<?=$data["case_name"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="address">工地地址</label>
|
|
<input type="text" name="address" id="address" value="<?=$data["address"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="compete">競爭對手</label>
|
|
<input type="text" name="compete" id="compete" value="<?=$data["compete"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="price_lowest">底價總額</label>
|
|
<input type="text" name="price_lowest" id="price_lowest" value="<?=number_format($data["price_lowest"]);?>" style="background-color:#eee5e5">
|
|
</div>
|
|
<div>
|
|
<label for="price_total">售價總額</label>
|
|
<input type="text" name="price_total" id="price_total" value="<?=number_format($data["price_total"]);?>">
|
|
</div>
|
|
<div>
|
|
<label for="price_total_broken">破價總額</label>
|
|
<input type="text" name="price_total_broken" id="price_total_broken" value="<?=number_format($data["price_total_broken"]);?>" style="background-color:#eee5e5">
|
|
</div>
|
|
<div>
|
|
<label for="price_rate">價率%</label>
|
|
<input type="text" name="price_rate" id="price_rate" value="<?=$data["price_rate"];?>" style="background-color:#eee5e5">
|
|
</div>
|
|
<div>
|
|
<label for="qty_total">總台數</label>
|
|
<input type="text" name="qty_total" id="qty_total" value="<?=number_format($data["qty_total"]);?>" style="background-color:#eee5e5">
|
|
</div>
|
|
<div>
|
|
<label for="inquire_no">詢價單號</label>
|
|
<input type="text" name="inquire_no" id="inquire_no" value="<?=$data["inquire_no"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="price_broken">破價(台)</label>
|
|
<input type="text" name="price_broken" id="price_broken" value="<?=number_format($data["price_broken"]);?>" style="background-color:#eee5e5">
|
|
</div>
|
|
<div>
|
|
<label for="predeal_date">預定成交日</label><br>
|
|
<input type="date" name="predeal_date" id="predeal_date" value="<?=$data["predeal_date"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="facilitok_date">預定交期</label><br>
|
|
<input type="date" name="facilitok_date" id="facilitok_date" value="<?=$data["facilitok_date"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="penalty">罰則</label>
|
|
<input type="text" name="penalty" id="penalty" value="<?=$data["penalty"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="deposit_rate">訂金保證金(函)%</label>
|
|
<input type="text" name="deposit_rate" id="deposit_rate" value="<?=$data["deposit_rate"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="keep_rate">履約保證金(函)%</label>
|
|
<input type="text" name="keep_rate" id="keep_rate" value="<?=$data["keep_rate"];?>">
|
|
</div>
|
|
<div>
|
|
<label for="warranty_rate">保固保證金(函)%</label>
|
|
<input type="text" name="warranty_rate" id="warranty_rate" value="<?=$data["warranty_rate"];?>">
|
|
</div>
|
|
<div class="table-responsive" style="width:100%;margin-top:10px;">
|
|
<table class="table">
|
|
<thead>
|
|
<tr>
|
|
<th><label for="memo">說明</label></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td><textarea name="memo" id="memo" rows="10"><?=$data["memo"];?></textarea></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<div class="table-responsive">
|
|
<table id="tb1" class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th nowrap>項次</th>
|
|
<th>規格</th>
|
|
<th>數量</th>
|
|
<th style="width:15%;">B/P(含稅)</th>
|
|
<th>金額(含稅)</th>
|
|
<th>價審%</th>
|
|
<th>備註</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
foreach ($item_arr as $item_no => $val) {
|
|
?>
|
|
<tr>
|
|
<td><?=$item_no;?></td>
|
|
<td><input type="text" name="item_spec" value="<?=$val["item_spec"];?>"></td>
|
|
<td><input type="text" name="item_qty" value="<?=number_format($val["item_qty"]);?>"></td>
|
|
<td><input type="text" name="item_price_bp" value="<?=number_format($val["item_price_bp"]);?>"></td>
|
|
<td><input type="text" name="item_price" value="<?=number_format($val["item_price"]);?>"></td>
|
|
<td><input type="text" name="pv_rate" value="<?=$val["pv_rate"];?>"></td>
|
|
<td><input type="text" name="note" value="<?=$val["note"];?>"></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<div class="table-responsive">
|
|
<table class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th colspan="4">合計</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td><label>數量</label></td>
|
|
<td><input type="text" id="cnt" style="background-color:#eee5e5" value="<?=number_format($data["qty_total"]);?>"></td>
|
|
<td><label>B/P(含稅)</label></td>
|
|
<td><input type="text" id="amt" style="background-color:#eee5e5" value="<?=number_format($data["price_lowest"]);?>"></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<table class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th colspan="4">付款辦法</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td>1、訂金</td>
|
|
<td>20%</td>
|
|
<td id="pay1"><?=number_format($data["price_total"]*0.2);?></td>
|
|
<td>30天期票,簽約後30日內兌現</td>
|
|
</tr>
|
|
<tr>
|
|
<td>2、二次款</td>
|
|
<td>40%</td>
|
|
<td id="pay2"><?=number_format($data["price_total"]*0.4);?></td>
|
|
<td>30天期票,電梯出貨前兌現</td>
|
|
</tr>
|
|
<tr>
|
|
<td>3、貨到付款</td>
|
|
<td>20%</td>
|
|
<td id="pay3"><?=number_format($data["price_total"]*0.2);?></td>
|
|
<td>30天期票,電梯使用前兌現</td>
|
|
</tr>
|
|
<tr>
|
|
<td>4、安裝完畢款</td>
|
|
<td>10%</td>
|
|
<td id="pay4"><?=number_format($data["price_total"]*0.1);?></td>
|
|
<td>30天期票,電梯交車前兌現</td>
|
|
</tr>
|
|
<tr>
|
|
<td>5、尾款</td>
|
|
<td>10%</td>
|
|
<td id="pay5"><?=number_format($data["price_total"]*0.1);?></td>
|
|
<td>30天期票,取得許可函後30日內兌現</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<table class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th colspan="4">審核記錄</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td>初審</td>
|
|
<td><?php echo $checker_1_result; ?></td>
|
|
<td><?=$data["checker_1"];?></td>
|
|
<td><?=$data["checker_1_dt"];?></td>
|
|
</tr>
|
|
<tr>
|
|
<td>二審</td>
|
|
<td><?php echo $checker_2_result; ?></td>
|
|
<td><?=$data["checker_2"];?></td>
|
|
<td><?=$data["checker_2_dt"];?></td>
|
|
</tr>
|
|
<tr>
|
|
<td>三審</td>
|
|
<td><?php echo $checker_3_result; ?></td>
|
|
<td><?=$data["checker_3"];?></td>
|
|
<td><?=$data["checker_3_dt"];?></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<?php if (!$stopchk && ($st==$allow_st)) { ?>
|
|
<label>審核人員</label>
|
|
<input type="text" name="checker" id="checker" required>
|
|
<button type="submit" name="status" id="status_n" value="N" onclick="if (!confirm('確定審核失敗？')) return false;">拒絕</button>
|
|
<button type="submit" name="status" id="status_y" value="Y" onclick="if (!confirm('確定審核成功？')) return false;">通過</button>
|
|
<?php } ?>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<?php
|
|
}
|
|
mysqli_free_result($res);
|
|
mysqli_close($link);
|
|
include "footer.php";
|
|
?>
|