public static function fetch($func = false, $row = false)
{
CHECK::is_must($func);
if (CHECK::is_pass()) {
switch ($func) {
case "intro":
self::make($row["subject"], CORE::$root . 'intro/' . SEO::link($row) . '/');
break;
case "sitemap":
case "contact":
case "feedback":
self::make(CORE::$lang[$func], CORE::$root . $func . '/');
break;
case "news":
self::newsFetch($row);
break;
case "blog":
self::blogFetch($row);
break;
case "faq":
self::faqFetch($row);
break;
case "products":
self::productsFetch($row);
break;
case "search":
self::make(CORE::$lang["search"], '#');
break;
}
self::output();
}
}
private static function add($m_id = false)
{
$recaptcha = self::recaptcha();
CHECK::is_must($_POST["name"], $_POST["tel"], $_POST["content"]);
CHECK::is_email($_POST["email"]);
if ($recaptcha && CHECK::is_pass()) {
$args = array('m_id' => !empty($m_id) ? $m_id : "null", 'content' => htmlspecialchars($_POST["content"], ENT_NOQUOTES));
$args = array_merge($_POST, $args);
CRUD::dataInsert('contact', $args);
if (!empty(DB::$error)) {
$msg = DB::$error;
} else {
foreach ($_POST as $field => $var) {
switch ($field) {
case "subject":
$subjectmail = self::subjectFetch($var, 'email');
$var = self::subjectFetch($var, 'subject');
break;
case "gender":
$var = empty($var) ? CORE::$lang["female"] : CORE::$lang["male"];
break;
}
VIEW::assignGlobal('VALUE_' . strtoupper($field), $var);
}
$msg = CORE::$lang["submit_done"];
$mail_temp = 'ogs-mail-contact-tpl.html';
# 信件樣板
new VIEW($mail_temp, false, true, false);
$fromMail = !empty($subjectmail) ? $subjectmail : SYSTEM::$setting["email"];
CORE::mail_handle($_POST["email"], $fromMail, VIEW::$output, CORE::$lang["contact_mail"], SYSTEM::$setting["name"]);
# 寄出認證信
$rs = true;
}
} else {
$msg = CHECK::$alert;
if (empty($recaptcha)) {
$msg = '請勾選驗證';
}
CRUD::args_output();
}
if ($rs) {
RESPONSE::register($_POST, CORE::$root . 'contact/thankyou/');
exit;
} else {
CORE::msg($msg, CORE::$root . 'contact/');
}
}
private static function finish()
{
self::car();
#$account_check = CRUD::dataFetch('member',array('account' => $_POST["account"]));
CHECK::is_must($_POST["name"], $_POST["tel"], $_POST["cell"], $_POST["add_name"], $_POST["add_tel"], $_POST["add_address"]);
if (!empty($_POST["first"])) {
# 未登入
/*
CHECK::is_email($_POST["account"]);
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"],$_POST["match_password"]);
$pass = CHECK::is_pass();
if($pass && empty($account_check)){
$new_member_rs = self::new_member();
}else{
CORE::msg(CORE::$lang["account_exist"].'或'.CORE::$lang["args_error"],CORE::$root);
}
*/
} else {
# 已登入
$pass = CHECK::is_pass();
}
if ($pass) {
$serial = self::new_serial();
#$email = (empty($_POST["first"]))?$_POST["email"]:$_POST["account"];
$email = $_POST["email"];
$name = $_POST["name"];
$order = array('m_id' => self::$id, 'serial' => $serial, 'status' => !empty($_POST["first"]) ? 11 : 0, 'createdate' => date("Y-m-d H:i:s"), 'subtotal' => self::$subtotal, 'ship' => self::$ship, 'total' => self::$total, 'email' => $email);
$order = array_merge($order, $_POST);
CRUD::dataInsert('order', $order);
$o_id = DB::get_id();
if (empty(DB::$error)) {
$cartRow = SESS::get('cart');
foreach ($cartRow as $id => $cart) {
$item = array('serial' => $serial, 'p_id' => $cart["p_id"], 'name' => $cart["name"], 'amount' => $cart["amount"], 'price' => $cart["price"]);
CRUD::dataInsert('order_item', $item);
if (!empty(DB::$error)) {
break;
}
}
}
if (empty(DB::$error)) {
# 訂購確認信
foreach ($order as $field => $var) {
VIEW::assignGlobal("VALUE_" . strtoupper($field), $var);
}
new VIEW('ogs-mail-cart-tpl.html', false, true, false);
CORE::mail_handle(SYSTEM::$setting["email"], $email, VIEW::$output, CORE::$lang["cart_mail"], SYSTEM::$setting["name"]);
CORE::mail_handle($email, SYSTEM::$setting["email"], VIEW::$output, CORE::$lang["cart_mail"], $name);
# 會員認證信
/*
VIEW::assignGlobal('VALUE_VERIFY_PATH',self::$verify);
new VIEW('ogs-mail-verify-tpl.html',false,true,false);
CORE::mail_handle(SYSTEM::$setting["email"],$email,VIEW::$output,CORE::$lang["regist_mail"],SYSTEM::$setting["name"]);
*/
SESS::del('cart');
CORE::msg(CORE::$lang["cart_done"], CORE::$root . "member/order/{$o_id}/");
} else {
# 發生錯誤
CORE::msg(DB::$error, CORE::$root);
}
} else {
if (!$pass || empty($_POST["first"])) {
CORE::msg(CHECK::$alert, CORE::$root);
}
}
}
private static function modify()
{
CHECK::is_must($_POST["callback"], $_POST["id"], $_POST["subject"], $_POST["cateID"]);
$check = CHECK::is_pass();
$rsnum = CRUD::dataFetch('ad', array('id' => $_POST["id"]));
if ($check && !empty($rsnum)) {
CRUD::dataUpdate('ad', $_POST, false, true);
if (!empty(DB::$error)) {
$msg = DB::$error;
$path = CORE::$manage . 'ad/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . "ad/detail/{$_POST['id']}/";
}
} else {
if (empty($rsnum)) {
$msg = self::$lang["no_data"];
$path = CORE::$manage . 'ad/';
}
if (!$check) {
$msg = CHECK::$alert;
$path = CORE::$manage . 'ad/';
}
}
CORE::msg($msg, $path);
}
private static function modify()
{
CHECK::is_must($_POST["id"], $_POST["serial"]);
if (CHECK::is_pass() && isset($_POST["status"])) {
CRUD::dataUpdate('order', array('status' => $_POST["status"], 'id' => $_POST["id"]));
# 訂單完成，刪除庫存數
/*
if($_POST["status"] == 3){
$rsnum = CRUD::dataFetch('order_item',array('serial' => $_POST["serial"]));
if(!empty($rsnum)){
$itemArray = CRUD::$data;
foreach($itemArray as $key => $row){
CRUD::dataFetch('stock_bind',array('id' => $row["stock_id"]));
$remain_amount = CRUD::$data[0]["amount"] - $row["amount"];
CRUD::dataUpdate('stock_bind',array('id' => $row["stock_id"],'amount' => $remain_amount));
}
}
}
*/
CORE::msg(self::$lang["modify_done"], CORE::$manage . 'order/detail/' . $_POST["serial"] . '/');
} else {
CORE::msg(CHECK::$alert, CORE::$manage . 'order/detail/' . $_POST["serial"] . '/');
}
}
private static function modify()
{
CHECK::is_must($_POST["callback"], $_POST["id"], $_POST["subject"], $_POST["dirpath"], $_POST["parent"]);
$check = CHECK::is_pass();
$rsnum = CRUD::dataFetch('gallery', array('id' => $_POST["id"]));
if ($check && !empty($rsnum)) {
if (is_array($_POST['related'])) {
$_POST['related'] = json_encode($_POST['related']);
} else {
$_POST['related'] = '';
}
CRUD::dataUpdate('gallery', $_POST, true, true);
if (!empty(DB::$error)) {
$msg = DB::$error;
$path = CORE::$manage . 'gallery/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . "gallery/detail/{$_POST['id']}/";
}
} else {
if (empty($rsnum)) {
$msg = self::$lang["no_data"];
$path = CORE::$manage . 'gallery/';
}
if (!$check) {
$msg = CHECK::$alert;
$path = CORE::$manage . 'gallery/';
}
}
CORE::msg($msg, $path);
}
private static function modify()
{
CHECK::is_must($_POST["id"], $_POST["name"]);
CHECK::is_email($_POST["account"]);
if (!empty($_POST["password"])) {
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["match_password"]);
$password_check = true;
} else {
unset($_POST["password"]);
}
$check = CHECK::is_pass();
if ($password_check) {
$rsnum = CRUD::dataFetch('manager', array('id' => $_POST["id"], 'password' => md5($_POST["old_password"])));
$check = !empty($rsnum) ? true : false;
if ($check) {
$_POST["password"] = md5($_POST["password"]);
}
}
if ($check) {
CRUD::dataUpdate('manager', $_POST);
if (!empty(DB::$error)) {
$msg = DB::$error;
$path = CORE::$manage . 'manager/';
} else {
$manager = SESS::get('MANAGER');
if ($manager["id"] == $_POST["id"]) {
$msg = self::$lang["manager_modify"];
$path = CORE::$manage . 'manager/logout/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . 'manager/';
}
}
} else {
$msg = !empty($rsnum) ? self::$lang["password_error"] : CHECK::$alert;
$path = CORE::$manage . 'manager/';
}
CORE::msg($msg, $path);
}
private static function seo()
{
CHECK::is_array_exist($_POST["id"]);
CHECK::is_must($_POST["callback"]);
if (CHECK::is_pass()) {
$field_rs = DB::field(CORE::$prefix . '_seo');
while ($field_row = DB::fetch($field_rs)) {
if ($field_row["Field"] != "langtag" && $field_row["Field"] != "name") {
$field_array[] = $field_row["Field"];
}
}
foreach ($_POST["id"] as $key => $id) {
foreach ($field_array as $field) {
$args[$field] = $_POST[$field][$key];
}
CRUD::dataUpdate('seo', $args);
if (!empty(DB::$error)) {
$msg = array(DB::$error, CORE::$manage . 'system/seo/');
CORE::msg($msg);
return false;
}
}
$msg = array(self::$lang["modify_done"], CORE::$manage . 'system/seo/');
} else {
$msg = array(CHECK::$alert, CORE::$manage . 'system/seo/');
}
CORE::msg($msg);
}
public static function multi($tb_name = false, $path = false)
{
list($func, $action, $args) = CORE::$args;
CHECK::is_array_exist($_POST["id"]);
CHECK::is_must($action);
if (CHECK::is_pass() && $tb_name !== false) {
# 依照排序要求更改陣列排序, 以符合自動排序邏輯
if ($action == "sort") {
asort($_POST["sort"]);
foreach ($_POST["sort"] as $id => $sort) {
if (isset($_POST["id"][$id]) && !empty($_POST["id"][$id])) {
$new_args[] = $_POST["id"][$id];
}
}
} else {
$new_args = $_POST["id"];
}
foreach ($new_args as $key => $id) {
switch ($action) {
case "sort":
CRUD::dataUpdate($tb_name, array('id' => $id, 'sort' => $_POST["sort"][$id]));
if (!empty(DB::$error)) {
$msg = DB::$error;
}
break;
case "status":
CRUD::dataUpdate($tb_name, array('id' => $id, 'status' => $args));
if (!empty(DB::$error)) {
$msg = DB::$error;
}
break;
case "clone":
/*
$rsnum = CRUD::dataFetch($tb_name,array('id' => $id));
if(!empty($rsnum)){
list($row) = CRUD::$data;
unset($row["id"]);
CRUD::dataInsert($tb_name,$row);
if(!empty(DB::$error)){
$msg = DB::$error;
}
}else{
$msg = self::$lang["no_args"];
}
*/
break;
case "del":
$rs = CRUD::dataDel($tb_name, array('id' => $id));
if (!empty(DB::$error)) {
$msg = DB::$error;
}
if (!$rs) {
$msg = self::$lang["del_error"];
}
break;
}
if (!empty($msg)) {
break;
}
}
} else {
$msg = self::$lang["no_args"];
}
if (empty($msg)) {
$msg = self::$lang["modify_done"];
} else {
$path = self::$temp_option["MSG"];
}
CORE::msg($msg, $path);
}
public static function class_init()
{
CHECK::is_must(self::$class);
if (CHECK::is_pass()) {
CORE::$class = self::$class;
CORE::$args = self::$args;
new self::$class();
}
}
private static function insert()
{
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["match_password"]);
CHECK::is_must($_POST["name"]);
CHECK::is_email($_POST["account"]);
$check = CHECK::is_pass();
$account_check = CRUD::dataFetch('member', array('account' => $_POST["account"]));
if ($check && empty($account_check)) {
# 預設值 / 更改
$manager = SESS::get("MANAGER");
$regist_args = $_POST;
$regist_args["verify"] = '1';
$regist_args["password"] = md5($_POST["password"]);
CRUD::dataUpdate('member', $regist_args);
if (!empty(DB::$error)) {
CRUD::args_output();
CORE::msg(DB::$error, CORE::$manage . 'member/add/');
} else {
CORE::msg(self::$lang["regist_done"], CORE::$manage . 'member/');
# 完成訊息
}
} else {
CRUD::args_output();
if (!empty($account_check)) {
CORE::msg(self::$lang["account_exist"], CORE::$manage . 'member/add/');
return false;
}
CORE::msg(self::$lang["no_args_start"], CORE::$manage . 'member/add/');
}
}
private static function regist()
{
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["match_password"]);
CHECK::is_must($_POST["name"]);
if (CHECK::is_pass()) {
$args = array('id' => SESS::get('VERIFY_ID'), 'status' => '1', 'password' => md5($_POST["password"]));
$args = array_merge($_POST, $args);
CRUD::dataUpdate('manager', $args);
SESS::del('VERIFY_ID');
if (!empty(DB::$error)) {
CORE::msg(DB::$error, CORE::$manage . 'manager/login/');
} else {
CORE::msg(self::$lang["account_open"], CORE::$manage . 'manager/login/');
}
} else {
CORE::msg(CHECK::$alert, CORE::$manage . 'manager/regist/');
}
}
private static function add()
{
CHECK::is_must($_POST["callback"], $_POST["name"], $_POST["content"]);
CHECK::is_email($_POST["email"]);
if (CHECK::is_pass()) {
foreach ($_POST as $field => $var) {
switch ($field) {
case "name":
case "content":
case "gender":
$insert[$field] = strip_tags($var);
break;
default:
$insert[$field] = $var;
break;
}
}
CRUD::dataInsert('feedback', $insert);
if (!empty(DB::$error)) {
$msg = 'Error! ' . DB::$error;
} else {
$msg = CORE::$lang['submit_done'];
}
} else {
$msg = CHECK::$alert;
}
RESPONSE::register($msg, CORE::$root . 'feedback/thankyou/');
}
private static function reply()
{
$rsnum = CRUD::dataFetch('contact', array('id' => $_POST["id"]));
$id = $_POST["id"];
if (!empty($rsnum) && !empty($id)) {
list($row) = CRUD::$data;
CHECK::is_must($_POST["reply"]);
CHECK::is_email($row["email"]);
if (CHECK::is_pass()) {
CRUD::dataUpdate('contact', array('id' => $id, 'reply' => $_POST["reply"]));
$mail_temp = 'ogs-mail-contact-reply-tpl.html';
VIEW::assignGlobal(array('VALUE_REPLY' => $_POST["reply"], "VALUE_CONTENT" => $row["content"]));
new VIEW($mail_temp, false, true, 1);
CORE::mail_handle(SYSTEM::$setting["email"], $row["email"], VIEW::$output, self::$lang["reply"], SYSTEM::$setting["name"]);
# 寄出認證信
$msg = self::$lang["reply_done"];
} else {
$msg = CHECK::$alert;
}
} else {
$msg = self::$lang["no_args"];
}
CORE::msg($msg, CORE::$manage . "contact/detail/{$id}/");
}
private static function modify()
{
self::check();
CHECK::is_email($_POST["account"]);
CHECK::is_must($_POST["name"], $_POST["callback"]);
if (!empty($_POST["old_password"]) && !empty($_POST["password"])) {
CHECK::is_password($_POST["old_password"]);
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["password_match"]);
$pass = CHECK::is_pass();
$rsnum = CRUD::dataFetch('member', array('status' => '1', 'verify' => '1', 'id' => self::$id, 'password' => md5($_POST["old_password"])));
if (empty($rsnum)) {
CORE::msg(CORE::$lang["args_error"], CORE::$root . 'member/profile/');
return false;
} else {
$modify["password"] = md5($_POST["password"]);
}
} else {
$pass = CHECK::is_pass();
unset($_POST["password"]);
}
if ($pass) {
$modify["id"] = self::$id;
$modify = array_merge($_POST, $modify);
CRUD::dataUpdate('member', $modify);
if (!empty(DB::$error)) {
CORE::msg(DB::$error, CORE::$root . 'member/profile/');
} else {
CORE::msg(CORE::$lang["modify_done"], CORE::$root . 'member/profile/');
}
} else {
CORE::msg(CHECK::$alert, CORE::$root . 'member/profile/');
}
}
