/**
  * 用户登录检查
  *
  */
 public function checklogin()
 {
     $this->_globals();
     $_POST["username"] = strtolower($_POST["username"]);
     $rs = $this->mCustomer->checkLogin();
     if ($rs) {
         $sql = "SELECT * FROM " . get_table("customers") . " WHERE email = '" . $_POST["username"] . "'";
         $r = $this->mDb->getRow($sql);
         if ($r["status"] == 1) {
             $msg["status"] = "true";
             $this->mCustomer->upHits($_SESSION["login_user"]["id"]);
             $_SESSION["login_user"] = $r;
             $msg["message"] = "登录成功";
             $this->mLog->userLog("前台登录成功");
         } else {
             $msg["status"] = "false";
             $msg["message"] = "您的邮箱还没有验证,请查看邮件进行验证";
         }
     } else {
         $msg["status"] = "false";
         $msg["message"] = "错误的用户名或密码";
         $_SESSION["tmpuser"] = $_POST["username"];
     }
     echo json_encode($msg);
     die;
 }

 /**
  * 系统初始化
  */
 private static function init()
 {
     set_exception_handler(array('AWS_APP', 'exception_handle'));
     self::$config = load_class('core_config');
     self::$db = load_class('core_db');
     self::$plugins = load_class('core_plugins');
     self::$settings = self::model('setting')->get_settings();
     if ((!defined('G_SESSION_SAVE') or G_SESSION_SAVE == 'db') and get_setting('db_version') > 20121123) {
         Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable(array('name' => get_table('sessions'), 'primary' => 'id', 'modifiedColumn' => 'modified', 'dataColumn' => 'data', 'lifetimeColumn' => 'lifetime')));
         self::$session_type = 'db';
     }
     Zend_Session::setOptions(array('name' => G_COOKIE_PREFIX . '_Session', 'cookie_domain' => G_COOKIE_DOMAIN));
     if (G_SESSION_SAVE == 'file' and G_SESSION_SAVE_PATH) {
         Zend_Session::setOptions(array('save_path' => G_SESSION_SAVE_PATH));
     }
     Zend_Session::start();
     self::$session = new Zend_Session_Namespace(G_COOKIE_PREFIX . '_Anwsion');
     if ($default_timezone = get_setting('default_timezone')) {
         date_default_timezone_set($default_timezone);
     }
     if ($img_url = get_setting('img_url')) {
         define('G_STATIC_URL', $img_url);
     } else {
         define('G_STATIC_URL', base_url() . '/static');
     }
     if (self::config()->get('system')->debug) {
         if ($cornd_timer = self::cache()->getGroup('crond')) {
             foreach ($cornd_timer as $cornd_tag) {
                 if ($cornd_runtime = self::cache()->get($cornd_tag)) {
                     AWS_APP::debug_log('crond', 0, 'Tag: ' . str_replace('crond_timer_', '', $cornd_tag) . ', Last run time: ' . date('Y-m-d H:i:s', $cornd_runtime));
                 }
             }
         }
     }
 }

 public function defshow()
 {
     //检查登录
     if (!$_SESSION["login_user"]) {
         $_SESSION["fromurl"] = $_SERVER["HTTP_REFERER"];
         header("Location: /user/login.html");
     } else {
         $this->result["login_user"] = $_SESSION["login_user"];
     }
     $this->result["sites"]["pagetitle"] = "课程设置";
     $this->result["nav1"] = $this->mArt->getPidLists(7);
     // 项目
     $this->result["nav2"] = $this->mArt->getPidLists(10);
     // 招生
     $this->result["logout"] = $this->mClient->isOrLogin();
     $this->result["sites"]["course"] = 'current';
     $this->result["ads"]["indexlbanner"] = $this->mAd->getAd("indexlbanner", "list");
     $sql1 = "select id,cname from " . get_table("art_cates") . " where pid = 14";
     $info = $this->mDb->getall($sql1);
     $this->result["info"] = $info;
     $sql2 = "select c.id as cid,a.id as aid,a.title from sb_art_cates AS c,sb_articles AS a where c.id=a.class_id and c.id in (select id from sb_art_cates where pid = 14)";
     $rs = $this->mDb->getall($sql2);
     $this->result["rs"] = $rs;
     $sql3 = "select id,cname from " . get_table("art_cates") . " where pid = 23";
     $infos = $this->mDb->getall($sql3);
     $this->result["infos"] = $infos;
     $sql4 = "select c.id as cid,a.id as aid,a.title from sb_art_cates AS c,sb_articles AS a where c.id=a.class_id and c.id in (select id from sb_art_cates where pid = 23)";
     $rse = $this->mDb->getall($sql4);
     $this->result["rse"] = $rse;
     $this->tplname = $_GET["lang"] . '/course';
 }

 public function batch()
 {
     $this->_globals();
     //$rs = $this->mArticle->Batch();
     $i = 0;
     while ($i < count($_POST["selected"])) {
         if ($_POST["more"] == "0") {
             $sql = "DELETE FROM " . get_table("download") . " WHERE id=" . $_POST["selected"][$i];
         } else {
             $sql = "UPDATE " . get_table("download") . " SET class_id='" . $_POST["class_id"] . "' WHERE id=" . $_POST["selected"][$i];
         }
         $rs = $this->mDb->execute($sql);
         $i++;
     }
     $this->mLog->adminLog("批量移动/删除内容");
     /*if($rs)
      				{
      					$msg["status"] = "true";
      				}
      				else
      				{
      					$msg["false"] = "true";
      					$msg["message"] = "保存错误，请联系管理员";
     
      				}
      				echo json_encode($msg);*/
     die;
 }

 function revert()
 {
     $this->build();
     $sql = "SELECT * FROM " . get_table("backuplist") . " WHERE id=" . $_POST["dataid"];
     $rs = $this->mDb->getrow($sql);
     $path = $rs["path"] . $rs["filename"];
     system("mysql -h " . _DB_HOST . " -u " . _DB_USER . " -p" . _DB_PASS . " " . _DB_NAME . " < " . $this->mPath . "/" . $rs["filename"]);
 }

 public function db_clean()
 {
     $users_columns = $this->query_all("SHOW COLUMNS FROM `" . get_table('users') . "`");
     foreach ($users_columns as $key => $val) {
         if (in_array($val['Field'], array('avatar_type', 'url'))) {
             $this->query("ALTER TABLE `" . get_table('users') . "` DROP `" . $val['Field'] . "`;");
         }
     }
 }

 public function count_favorite_items($uid, $tag = null)
 {
     if ($tag) {
         $favorite_items = $this->query_all('SELECT DISTINCT item_id FROM ' . get_table('favorite_tag') . ' WHERE uid = ' . intval($uid) . " AND title = '" . $this->quote($tag) . "'");
         return sizeof($favorite_items);
     } else {
         return $this->count('favorite', 'uid = ' . intval($uid));
     }
 }

 public function get_topics_by_feature_id($feature_id)
 {
     if (!($topics = $this->query_all('SELECT topic_id FROM ' . get_table('feature_topic') . ' WHERE feature_id = ' . intval($feature_id)))) {
         return false;
     }
     foreach ($topics as $key => $val) {
         $topic_ids[] = $val['topic_id'];
     }
     return $topic_ids;
 }

 public static function _saveAnswer($aid, $qid, $username, $content, $vote)
 {
     $a = get_table('answer');
     $update = array('id' => $aid, 'q_id' => $qid, 'user' => $username, 'text' => $content, 'vote' => $vote, 'fetched' => time());
     $where = array('id' => $aid);
     $rs = $a->update($where, array('$set' => $update), array('upsert' => true));
     if (!$rs['ok']) {
         echo basename(__FILE__) . ':' . __LINE__ . ' ' . $rs['err'] . "\n";
     }
     return $rs;
 }

 public function savePost()
 {
     foreach ($_POST as $key => $val) {
         $sql[] = $key . " = '{$val}'";
     }
     $sql = implode(",", $sql);
     $sql = "UPDATE " . get_table("sites") . " SET {$sql} WHERE id=1";
     $rs = $this->mDb->execute($sql);
     $this->building();
     return $rs;
 }

 public function pay_to_project_order_id($order_id, $project_product_order_id)
 {
     if (!($order_info = $this->get_order($order_id))) {
         return false;
     }
     if (!($project_order_info = $this->model('project')->get_project_order_info_by_id($project_product_order_id))) {
         return false;
     }
     $this->query("UPDATE " . get_table('project') . " SET paid = paid + " . $order_info['amount'] . " WHERE id = " . intval($project_order_info['project_id']));
     return $this->set_order_payment_time($project_product_order_id);
 }

 public function update_dialog_count($dialog_id, $uid)
 {
     if (!($inbox_dialog = $this->get_dialog_by_id($dialog_id))) {
         return false;
     }
     $this->update('inbox_dialog', array('sender_count' => $this->count('inbox', 'uid IN(' . $inbox_dialog['sender_uid'] . ', ' . $inbox_dialog['recipient_uid'] . ') AND sender_remove = 0 AND dialog_id = ' . intval($dialog_id)), 'recipient_count' => $this->count('inbox', 'uid IN(' . $inbox_dialog['sender_uid'] . ', ' . $inbox_dialog['recipient_uid'] . ') AND recipient_remove = 0 AND dialog_id = ' . intval($dialog_id)), 'update_time' => time()), 'id = ' . intval($dialog_id));
     if ($inbox_dialog['sender_uid'] == $uid) {
         $this->query("UPDATE " . get_table('inbox_dialog') . " SET recipient_unread = recipient_unread + 1 WHERE id = " . intval($dialog_id));
     } else {
         $this->query("UPDATE " . get_table('inbox_dialog') . " SET sender_unread = sender_unread + 1 WHERE id = " . intval($dialog_id));
     }
 }

 public function search_users($q, $page, $limit = 20)
 {
     if (is_array($q) and sizeof($q) > 1) {
         $where[] = "user_name = '" . $this->quote(implode(' ', $q)) . "' OR user_name = '" . $this->quote(implode('', $q)) . "'";
     } else {
         if (is_array($q)) {
             $q = implode('', $q);
         }
         $where[] = "user_name LIKE '" . $this->quote($q) . "%'";
     }
     return $this->query_all('SELECT uid, last_login FROM ' . get_table('users') . ' WHERE ' . implode(' OR ', $where), calc_page_limit($page, $limit));
 }

function get_reason($reason)
{
    global $db, $L;
    $str = '';
    $arr = explode('|', $reason);
    switch ($arr[0]) {
        case 'deposit':
            $str = $L['charge_reason_deposit'];
            break;
        case 'credit':
            $str = $L['charge_reason_credit'];
            break;
        case 'vip':
            $str = $L['charge_reason_vip'];
            break;
        case 'pay':
            if (is_numeric($arr[1]) && is_numeric($arr[2])) {
                $t = $db->get_one("SELECT title FROM " . get_table(intval($arr[1])) . " WHERE itemid=" . intval($arr[2]));
                if ($t) {
                    $str = $t['title'];
                }
            }
            break;
        case 'trade':
            if (is_numeric($arr[1])) {
                $t = $db->get_one("SELECT title FROM " . $db->pre . "mall_order WHERE itemid=" . intval($arr[1]));
                if ($t) {
                    $str = $t['title'];
                }
            }
            break;
        case 'trades':
            $ids = explode(',', $arr[1]);
            $t = $db->get_one("SELECT title FROM " . $db->pre . "group_order WHERE itemid=" . intval($ids[0]));
            if ($t) {
                $str = $L['charge_reason_muti'] . $t['title'] . '...';
            }
            break;
        case 'group':
            if (is_numeric($arr[1])) {
                $t = $db->get_one("SELECT title FROM " . $db->pre . "group_order WHERE itemid=" . intval($arr[1]));
                if ($t) {
                    $str = $t['title'];
                }
            }
            break;
        default:
            break;
    }
    return $str;
}

 private function check_dunning($bdname, $time, $status)
 {
     $sql = "select * from " . get_table($bdname) . " where etime >=now() and etime <='" . $time . "' and emailstatus<>" . $status;
     $rs = $this->mDb->getall($sql);
     foreach ($rs as $key => $value) {
         $r = $this->getRow("customers", $value["uid"]);
         $rs[$key]["email"] = $r["email"];
         if ($value["emailstatus"] == $status - 1) {
             if ($this->to_email($rs[$key]["email"], $status, $bdname)) {
                 $this->Update($bdname, $value["id"], " emailstatus =" . $status);
             }
         }
     }
 }

 public function canceldomain()
 {
     $this->_globals();
     $root = "/data/wwwroot/vhost/";
     system("rm -f " . $root . $_POST["host"]);
     $sql = "DELETE FROM " . get_table("domain") . " WHERE domain='" . $_POST["host"] . "'";
     $rs = $this->mDb->execute($sql);
     if ($rs == false) {
         $msg["status"] = "false";
     } else {
         $msg["status"] = "true";
     }
     echo json_encode($msg);
     die;
 }

 public function defshow()
 {
     $this->_globals();
     include _APP_PATH . "libs/adodb/adodb-pager2.inc.php";
     $r = $this->mBasic->getList("orderprodlist", array("uid = '" . $_SESSION["login_user"]["id"] . "'", " payflag != 2 "));
     $payflag = $this->mOrder->getPayflagList();
     foreach ($r["logs"] as $key => $val) {
         $r["logs"][$key]["payflagname"] = $payflag[$val["payflag"]];
         $r["logs"][$key]["infolist"] = $this->mDb->getall("SELECT * FROM " . get_table("orderprod") . " p ," . get_table("orderprodlist") . " o ," . get_table("products") . " pr WHERE p.oid=o.id AND p.pid = pr.id AND p.oid = '" . $val["id"] . "'");
         $r["logs"][$key]["infos"] = $this->mDb->getall("SELECT * FROM " . get_table("orderprod") . " p ," . get_table("orderprodlist") . " o  WHERE p.oid=o.id  AND p.oid = '" . $val["id"] . "'");
     }
     $this->result["logs"] = $r["logs"];
     $this->result["pages"] = $r["pages"];
     $this->result["sites"]["pagetitle"] = "订单中心";
     $this->tplname = 'orderlist';
 }

 public function savepost()
 {
     $this->_globals();
     $password = md5($_POST["password"]);
     $sql = "UPDATE " . get_table("customers") . " SET password = '{$password}' WHERE id= '" . $_POST["id"] . "'";
     $rs = $this->mDb->execute($sql);
     if ($rs) {
         $msg["status"] = "true";
         $msg["message"] = "密码重设成功，请重新登录";
     } else {
         $msg["status"] = "false";
         $msg["message"] = "密码重设失败，请稍后重试";
     }
     echo json_encode($msg);
     die;
 }

 public function index_action()
 {
     $publisher_projects = $this->model('project')->query_all('SELECT id FROM ' . get_table('project') . ' WHERE uid = ' . intval($this->user_id));
     if (!$publisher_projects) {
         exit;
     }
     foreach ($publisher_projects as $value) {
         $project_ids[] = $value['id'];
     }
     $order_list = $this->model('project')->fetch_all('product_order', 'project_id IN (' . implode(',', $project_ids) . ')', 'id ASC');
     if (!$order_list) {
         exit;
     }
     foreach ($order_list as $order_info) {
         $uids[] = $order_info['uid'];
     }
     $users = $this->model('account')->get_user_info_by_uids($uids);
     $objPHPExcel = new PHPExcel();
     $objPHPExcel->getProperties()->setTitle('活动列表');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '活动 ID')->setCellValue('B1', '联系人')->setCellValue('C1', '报名时间')->setCellValue('D1', '手机号')->setCellValue('E1', '邮箱')->setCellValue('F1', '收货地址')->setCellValue('G1', '邮编')->setCellValue('H1', '支持金额')->setCellValue('I1', '状态');
     $i = 1;
     foreach ($order_list as $order_info) {
         $i++;
         $order_info['order_status'] = $this->model('project')->get_order_status($order_info);
         switch ($order_info['order_status']) {
             case 'pay':
                 $order_info['order_status'] = '未支付';
                 break;
             case 'refunded':
                 $order_info['order_status'] = '已退款';
                 break;
             case 'shipped':
                 $order_info['order_status'] = '已回报';
                 break;
             case 'donate':
                 $order_info['order_status'] = '无需回报';
                 break;
             default:
                 $order_info['order_status'] = '等待回报';
                 break;
         }
         $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $order_info['project_id'] ?: '')->setCellValue('B' . $i, $order_info['shipping_name'] ?: '')->setCellValue('C' . $i, date('Y-m-d H:i:s', $order_info['add_time']) ?: '')->setCellValue('D' . $i, $order_info['shipping_mobile'] ?: '')->setCellValue('E' . $i, $order_info['project_type'] == 'DEFAULT' ? $users[$order_info['uid']]['email'] : $order_info['shipping_address'])->setCellValue('F' . $i, $order_info['project_type'] == 'DEFAULT' ? $order_info['shipping_province'] . $order_info['shipping_city'] . $order_info['shipping_address'] : $order_info['address'])->setCellValue('G' . $i, $order_info['shipping_zipcode'] ?: '')->setCellValue('H' . $i, $order_info['amount'] ?: '')->setCellValue('I' . $i, $order_info['order_status']);
     }
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
     $objWriter->save('php://output');
     exit;
 }

 public function online_active($uid, $last_active)
 {
     if (!$uid or $last_active + 60 > time()) {
         return false;
     }
     $online_data = array('uid' => $uid, 'last_active' => time(), 'ip' => ip2long(fetch_ip()), 'user_agent' => $_SERVER['HTTP_USER_AGENT'], 'active_url' => $_SERVER['HTTP_REFERER']);
     if ($user_online = $this->fetch_row('users_online', 'uid = ' . intval($uid))) {
         $this->shutdown_update('users_online', $online_data, 'uid = ' . $user_online['uid']);
     } else {
         $this->insert('users_online', $online_data);
     }
     $online_time = time() - $last_active;
     if ($online_time > 300) {
         $online_time = 1;
     }
     $this->shutdown_query("UPDATE " . get_table('users') . ' SET online_time = online_time + ' . intval($online_time) . ', last_active = ' . time() . ' WHERE uid = ' . intval($uid));
     return true;
 }