private static function subject_replace()
{
if (is_array($_POST['id'])) {
foreach ($_POST['id'] as $key => $ID) {
$newArgs = array('subject' => $_POST['subject'][$key], 'sort' => $_POST['sort'][$key], 'email' => $_POST['email'][$key], 'id' => $ID);
CRUD::dataUpdate('contact_subject', $newArgs);
if (!empty(DB::$error)) {
break;
}
}
$msg = self::$lang["modify_done"];
} else {
CHECK::is_must($_POST['subject']);
if (CHECK::is_pass()) {
CRUD::dataInsert('contact_subject', $_POST, true);
$msg = self::$lang["modify_done"];
} else {
$msg = self::$lang["no_args"];
}
}
if (!empty(DB::$error)) {
$msg = DB::$error;
}
CORE::msg($msg, CORE::$manage . 'contact/subject/');
}
public static function add($tb_name, $id, array $args)
{
if (!empty($args["filename"])) {
$args["filename"] = self::filename_check(false, $args["filename"]);
}
CRUD::dataInsert('seo', $args);
$seo_id = DB::get_id();
DB::update(CORE::$prefix . "_" . $tb_name, array('seo_id' => $seo_id, 'id' => $id));
}
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 replace()
{
CHECK::is_email($_POST["email"]);
CHECK::is_must($_POST["callback"]);
if (CHECK::is_pass()) {
$systemExist = CRUD::dataFetch('system', array('id' => '1'));
$args = array_merge($_POST, array('id' => '1'));
if ($systemExist) {
CRUD::dataUpdate('system', $args);
} else {
CRUD::dataInsert('system', $args);
}
if (!empty(DB::$error)) {
$msg = array(DB::$error, CORE::$manage . 'system/');
} else {
$msg = array(self::$lang["modify_done"], CORE::$manage . 'system/');
}
} else {
$msg = array(CHECK::$alert, CORE::$manage . 'system/');
}
CORE::msg($msg);
}
private static function replace()
{
CHECK::is_array_exist($_POST["id"]);
if (CHECK::is_pass()) {
$fieldArray = array('origin', 'target', 'status', 'id');
foreach ($_POST["id"] as $key => $ID) {
unset($args);
foreach ($fieldArray as $field) {
switch ($field) {
case "origin":
$var = preg_replace('/(http:\\/\\/|https:\\/\\/)([^\\/]+)(.*)/si', '$1' . CORE::$cfg['url'] . '$3', $_POST[$field][$key]);
break;
default:
$var = $_POST[$field][$key];
break;
}
$args[$field] = $var;
}
if (urlencode($args['origin']) == urlencode($args['target'])) {
continue;
}
if (empty($ID)) {
unset($args['id']);
CRUD::dataInsert('rewrite', $args);
} else {
CRUD::dataUpdate('rewrite', $args);
}
if (!empty(DB::$error)) {
$msg = DB::$error;
} else {
$msg = self::$lang["modify_done"];
}
}
} else {
$msg = CHECK::$alert;
}
CORE::msg($msg, CORE::$manage . 'rewrite/');
}
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 insert()
{
CHECK::is_must($_POST["callback"], $_POST["subject"], $_POST["cateID"]);
if (CHECK::is_pass()) {
CRUD::dataInsert('ad', $_POST, true, false, true);
if (!empty(DB::$error)) {
CRUD::args_output();
$msg = DB::$error;
$path = CORE::$manage . 'ad/add/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . 'ad/';
}
} else {
CRUD::args_output();
$msg = CHECK::$alert;
$path = CORE::$manage . 'ad/add/';
}
CORE::msg($msg, $path);
}
private static function insert()
{
CHECK::is_must($_POST["callback"], $_POST["subject"], $_POST["content"]);
if (CHECK::is_pass()) {
$_POST['createdate'] = date('Y-m-d H:i:s');
CRUD::dataInsert('intro', $_POST, true, true);
if (!empty(DB::$error)) {
CRUD::args_output();
$msg = DB::$error;
$path = CORE::$manage . 'intro/add/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . 'intro/';
}
} else {
CRUD::args_output();
$msg = CHECK::$alert;
$path = CORE::$manage . 'intro/add/';
}
CORE::msg($msg, $path);
}
private static function insert()
{
CHECK::is_must($_POST["callback"], $_POST["subject"], $_POST["dirpath"], $_POST["parent"]);
if (CHECK::is_pass()) {
if (is_array($_POST['related'])) {
$_POST['related'] = json_encode($_POST['related']);
} else {
$_POST['related'] = '';
}
CRUD::dataInsert('gallery', $_POST, true, true, true);
if (!empty(DB::$error)) {
CRUD::args_output();
$msg = DB::$error;
$path = CORE::$manage . 'gallery/add/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . 'gallery/';
}
} else {
CRUD::args_output();
$msg = CHECK::$alert;
$path = CORE::$manage . 'gallery/add/';
}
CORE::msg($msg, $path);
}
private static function insert()
{
CHECK::is_must($_POST["callback"], $_POST["subject"], $_POST["content"], $_POST["parent"]);
if (CHECK::is_pass()) {
CRUD::$parent_tb_name = 'products_cate';
if (is_array($_POST['related'])) {
$_POST['related'] = json_encode($_POST['related']);
} else {
$_POST['related'] = '';
}
$_POST['createdate'] = date('Y-m-d H:i:s');
CRUD::dataInsert('products', $_POST, true, true, true);
if (!empty(DB::$error)) {
CRUD::args_output();
$msg = DB::$error;
$path = CORE::$manage . 'products/add/';
} else {
$msg = self::$lang["modify_done"];
$path = CORE::$manage . 'products/';
}
} else {
CRUD::args_output();
$msg = CHECK::$alert;
$path = CORE::$manage . 'products/add/';
}
CORE::msg($msg, $path);
}
private static function replace()
{
CHECK::is_array_exist($_POST["id"]);
if (CHECK::is_pass()) {
$sql = DB::field(CORE::$prefix . '_stock_bind');
while ($row = DB::fetch($sql)) {
$field_array[] = $row["Field"];
}
foreach ($_POST["id"] as $key => $id) {
$rsnum = CRUD::dataFetch('stock_cate');
# 取得規格類別數量
foreach ($field_array as $field) {
switch ($field) {
case "item":
for ($i = 0; $i < $rsnum; $i++) {
if ($_POST['item_' . $i][$key] !== 'null') {
$item[$i] = $_POST['item_' . $i][$key];
}
if (empty($_POST["name"][$key])) {
CRUD::dataFetch('stock_item', array('id' => $item[$i]));
# 取得規格項目名稱
if (!empty(CRUD::$data[0]["name"])) {
$name[$i] = CRUD::$data[0]["name"];
}
}
}
$args["item"] = json_encode($item);
$args["name"] = empty($_POST["name"][$key]) ? implode(" / ", $name) : $_POST["name"][$key];
break;
default:
$args[$field] = $_POST[$field][$key];
break;
}
}
$args["sort"] = $key;
if (empty($id)) {
CRUD::dataInsert('stock_bind', $args);
} else {
CRUD::dataUpdate('stock_bind', $args);
}
if (empty($key)) {
$p_id = $args["p_id"];
}
if (!empty(DB::$error)) {
CORE::msg(DB::$error, CORE::$manage . "stock/{$p_id}");
}
}
CORE::msg(self::$lang["modify_done"], CORE::$manage . "stock/{$p_id}");
} else {
CORE::msg(self::$lang["no_args"], CORE::$manage . "stock/{$p_id}");
}
}
private static function insert()
{
CHECK::is_email($_POST["account"]);
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["match_password"]);
CHECK::is_must($_POST["name"]);
$check = CHECK::is_pass();
$account_check = CRUD::dataFetch('manager', array('account' => $_POST["account"]));
if ($check && empty($account_check)) {
$_POST["password"] = md5($_POST["password"]);
CRUD::dataInsert('manager', $_POST);
if (!empty(DB::$error)) {
CRUD::args_output();
$msg = DB::$error;
$path = CORE::$manage . 'manager/add/';
} else {
$msg = self::$lang["account_open"];
$path = CORE::$manage . 'manager/';
}
} else {
CRUD::args_output();
$msg = !$check ? CHECK::$alert : self::$lang["account_exist"];
$path = CORE::$manage . 'manager/add/';
}
CORE::msg($msg, $path);
}
public static function modify(array $args, $tb_name = false, $related = false)
{
foreach ($args["id"] as $key => $id) {
list($width, $height) = IMAGES::size($args["path"][$key]);
$images = array('id' => $id, 'path' => $args["path"][$key], 'alt' => $args["alt"][$key], 'title' => $args["title"][$key], 'width_o' => $width, 'height_o' => $height, 'width' => $args['width'][$key], 'height' => $args['height'][$key], 'width_m' => $args['width_m'][$key], 'height_m' => $args['height_m'][$key], 'info' => $args['info'][$key]);
if (empty($id)) {
$images = array_merge($images, array('sheet' => $tb_name, 'related' => $related));
CRUD::dataInsert('images', $images);
$ID = CRUD::$id;
} else {
CRUD::dataUpdate('images', $images);
$ID = $images['id'];
}
$rsnum = CRUD::dataFetch('images', array('id' => $id));
if (!empty($rsnum)) {
list($imgRow) = CRUD::$data;
}
self::crop($ID, $images['path'], $images['width'], $images['height'], $images['width_m'], $images['height_m'], $imgRow['crop'], $imgRow['crop_m']);
}
}
private static function grant()
{
if (is_array($_POST["id"])) {
foreach ($_POST["id"] as $m_id) {
CRUD::dataInsert('grant', array('m_id' => $m_id, 'granted' => SALE::bonus($m_id), 'date' => date("Y-m-d H:i:s")));
if (!empty(DB::$error)) {
$msg = DB::$error;
break;
}
}
if (empty($msg)) {
$msg = self::$lang["modify_done"];
}
} else {
$msg = self::$lang["no_args"];
}
CORE::msg($msg, CORE::$manage . 'sale/bonus/');
}
private static function login()
{
CHECK::is_email($_POST["account"]);
CHECK::is_password($_POST["password"]);
if (CHECK::is_pass()) {
$rsnum = CRUD::dataFetch('manager', array('ban' => '0', 'status' => '1', 'account' => $_POST["account"], 'password' => md5($_POST["password"])));
if ($rsnum == 1) {
list($manager) = CRUD::$data;
$pass = true;
}
}
if (!$pass) {
$fail_count = SESS::get('LOGIN_FAIL');
SESS::write('LOGIN_FAIL', ++$fail_count);
if ($fail_count <= 3) {
CORE::msg(self::$lang["login_error"], CORE::$manage . 'manager/login/');
} else {
# 失敗超過三次禁止登入
session_destroy();
CRUD::dataInsert('ban', array('ip' => CORE::getIP()));
CORE::msg(self::$lang["login_ban"], CORE::$root);
}
} else {
if (!empty($_POST["cookie"])) {
$path = CORE::$manage . 'manager/reverify/';
} else {
$path = CORE::$manage;
}
SESS::write("MANAGER", $manager);
CORE::msg(self::$lang["login_success"], $path);
}
}
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/');
}
