protected static function form($rowCount = 5)
{
CRUD::args_output(true, true);
$rsnum = CRUD::dataFetch('feedback', array('status' => '1'), false, array('createdate' => 'desc'));
if (!empty($rsnum)) {
$dataRow = CRUD::$data;
foreach ($dataRow as $row) {
$scoreArray[] = $row['score'];
$socreCount[$row['score']]++;
}
# 計算平均總分
$averge = round(array_sum($scoreArray) / $rsnum, 1);
list($mainScore, $subScore) = explode('.', $averge);
}
VIEW::assignGlobal(array('VALUE_TOTAL' => empty($rsnum) ? 0 : $rsnum, 'VALUE_AVERGE_MAIN' => empty($mainScore) ? 0 : $mainScore, 'VALUE_AVERGE_SUB' => empty($subScore) ? 0 : $subScore));
if (is_array($socreCount)) {
$s = 6;
while (--$s > 0) {
VIEW::newBlock('TAG_SOCRE_LINE');
$number = empty($socreCount[$s]) ? '0' : $socreCount[$s];
VIEW::assign(array('VALUE_SCORE_PERCENT' => round(100 / $rsnum * $number) . '%', 'VALUE_SOCRE_COUNT' => $s, 'VALUE_SCORE_NUMBER' => $number));
}
}
$schemaReview = self::row($rowCount);
SCHEMA::make('feedback', array('count' => $rsnum, 'score' => $averge, 'review' => $schemaReview));
}
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 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);
}
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 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()
{
$account_check = CRUD::dataFetch('member', array('account' => $_POST["account"]));
CHECK::is_password($_POST["password"]);
CHECK::is_same($_POST["password"], $_POST["password_match"]);
CHECK::is_must($_POST["name"], $_POST["callback"]);
CHECK::is_email($_POST["account"]);
if (CHECK::is_pass() && empty($account_check)) {
# 預設值 / 更改
$insert_args = $_POST;
$insert_args["password"] = md5($_POST["password"]);
$insert_args["createdate"] = date("Y-m-d H:i:s");
CRUD::dataUpdate('member', $insert_args);
if (!empty(DB::$error)) {
CRUD::args_output();
CORE::msg(DB::$error, CORE::$root . 'member/regist/');
} else {
# 註冊成功，發送驗證信
$verify_temp = 'ogs-mail-verify-tpl.html';
# 信件樣板
$m_id = DB::get_id();
# 取得 id
$verify_code = md5($_POST["account"] . $insert_args["password"] . $insert_args["createdate"] . $m_id);
# 組合認證碼
$verify_path = 'http://' . CORE::$cfg["url"] . CORE::$root . "member/verify/{$verify_code}/";
# 組合認證路徑
CRUD::dataUpdate('member', array('verify_code' => $verify_code, 'id' => $m_id));
# 儲存認證碼
# 輸出認證信樣板
VIEW::assignGlobal('VALUE_VERIFY_PATH', $verify_path);
new VIEW($verify_temp, false, true, false);
CORE::mail_handle(SYSTEM::$setting["email"], $_POST["account"], VIEW::$output, CORE::$lang["regist_mail"], SYSTEM::$setting["name"]);
# 寄出認證信
CORE::msg(CORE::$lang["regist_done"], CORE::$root . 'member/');
# 完成訊息
return true;
}
} else {
CRUD::args_output();
if (!empty($account_check)) {
CORE::msg(CORE::$lang["account_exist"], CORE::$root . 'member/regist/');
return false;
}
if (empty($referrals_check)) {
CORE::msg(CORE::$lang["referrals_none"], CORE::$root . 'member/regist/');
return false;
}
if ($referrals_count >= 2) {
CORE::msg(CORE::$lang["referrals_max"], CORE::$root . 'member/regist/');
return false;
}
if (empty($verify_check)) {
CORE::msg(CORE::$lang["verify_error"], CORE::$root . 'member/regist/');
return false;
}
CORE::msg(CHECK::$alert, CORE::$root . 'member/regist/');
}
}
