';
// print_r($sql_get);
// echo '';
foreach ($res_get as $key => $data) {
// 結案隱藏
if ($data['flow_code'] !== 'Z') {
$test = $data['form_id'];
// $sql = "SELECT mid FROM pricereview_sign WHERE id = $test";
// $result = mysqli_fetch_all(mysqli_query($link, $sql), MYSQLI_ASSOC);
// echo '';
// print_r($result);
// echo '';
$id[] = $test;
}
}
$inClause = implode(',', $id);
}
// 設置一個空陣列來放資料
$data = array();
// sql語法存在變數中
$sql_cmd = sql_myself($user_id);
// M0024許伃廷,M0107許紓晴,M0012李盈瑩權限全開
if ($user_id == "M0024" || $user_id == "M0107" || $user_id == "M0012" || $user_id == "M0008" || $user_id == "M0060" || $user_id == "M0189" || $user_id == "M0061" || $user_id == "TEST01" || $user_id == "TEST02" || $user_id == "TEST03" || $user_id == "TEST04" || $user_id == "M0029") {
$sql_cmd = "where create_at >= '2023-01-01 00:00:00'";
}
if ($user_id == "M0008") {
// $sql_cmd = "where creater in (select accountid from account where department_id like '5%')";
}
if (!empty($res_get)) {
$sql_cmd = "where id IN ($inClause)";
}
// if ($user_id == "M0060") {
// $sql_cmd = "where creater in (select accountid from account where (department_id like '3%' or department_id like '5%'))";
// }
if (empty($sql_cmd)) $sql = "select * from pricereview_main where status like 'Y%' and ekind = '汰改' order by id";
else $sql = "select * from pricereview_main $sql_cmd and status like 'Y%' and ekind = '汰改' order by id";
// echo ''; // print_r($sql); // echo ''; $data = mysqli_query($link, $sql); $para = "function_name=pricereview_renovate&" . $token_link; $sign_st = ""; ?> Please fill up the required field!"; } else { header("Location:pricereview-index.php"); } } */ ?>
| 項次 | 卷號 | 營業員 | 客戶名稱 | 案件名稱 | 牌價總額 | 售價總額 | 價率 | 預定成交日 | 預定交期 | 建檔人 | 建檔時間 | 功能 | 區經理 | 服務助理 | 服務副總 | 總經理 | 狀態 | 合約書下載 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| % | '; // print_r($maxContractID); // echo ''; if ($data["status"] == "Y1") { ?> 修改 刪除 填規調 重填價審 " class="btn btn-warning btn-sm">檢視 |
";
elseif ($ustatus == "N") $str = "";
$str .= " " . $accountname_arr[$uperson] . " " . $udtte; } else { if ($sign_st == 1 && $sign_nt == $user_id && $data["status"] == "YS") { $str = ""; $str = "待簽核"; $str = "" . $str . ""; } else $str = "--"; } echo $str; /* if ($sign_st==1 && $sign_nt==$user_id) { $str = ""; $str = "".$str.""; } else if ($sign_st > 1 || $data['last_check_result']) { // 過了這關或已完成流程 list($uperson, $ustatus, $udtte) = explode(",", $sign1); if ($ustatus == "Y") $str = ""; else $str = ""; $str .= " ".$accountname_arr[$uperson]." ".$udtte; } else $str = "--"; */ /* if ($data["checker_1_result"] == "Y") { $str = ""; } elseif ($data["checker_1_result"] == "N") { $str = ""; } else { $str = ""; } if (!$oneself) { $str = "".$str.""; $str .= " ".$data["checker_1"]." ".$data["checker_1_dt"]; } else { if ($data["checker_1_result"]) { $str = "".$str.""; $str .= " ".$data["checker_1"]." ".$data["checker_1_dt"]; } else $str = "--"; }*/ //echo $str; ?> |
";
elseif ($ustatus == "N") $str = "";
$str .= " " . $accountname_arr[$uperson] . " " . $udtte; } else { if ($sign_st == 2 && $sign_nt == $user_id && $data["status"] == "YS") { $str = ""; $str = "待簽核"; $str = "" . $str . ""; } else $str = "--"; } echo $str; ?> |
";
elseif ($ustatus == "N") $str = "";
$str .= " " . $accountname_arr[$uperson] . " " . $udtte; } else { if (($data["status"] == "YS") && ($sign_st == 3) && ($sign_nt == $user_id)) { $str = ""; $str = "待簽核"; $str = "" . $str . ""; } else $str = "--"; } echo $str; /* $str = ""; if ($sign_st==3 && $sign_nt==$user_id) { $str = ""; $str = "".$str.""; } else $str = "--"; */ /* if ($data["checker_3_result"] == "Y") { $str = ""; } elseif ($data["checker_3_result"] == "N") { $str = ""; } else { $str = ""; } if (!$oneself) { $str = "".$str.""; $str .= " ".$data["checker_3"]." ".$data["checker_3_dt"]; } else { if ($data["checker_3_result"]) { $str = "".$str.""; $str .= " ".$data["checker_3"]." ".$data["checker_3_dt"]; } else $str = "--"; } */ //echo $str; ?> |
";
elseif ($ustatus == "N") $str = "";
$str .= " " . $accountname_arr[$uperson] . " " . $udtte; } else { if (($data["status"] == "YS") && ($sign_st == 4) && ($sign_nt == $user_id)) { $str = ""; $str = "待簽核"; $str = "" . $str . ""; } else $str = "--"; } echo $str; ?> |
合約書申請 |