public function __construct()
{
parent::__construct();
// 删除活动配置SQL语句
$this->SQL_DELETE_CONFIG = "DELETE FROM " . C('DB_PREFIX') . "wevote_config WHERE ";
// 删除候选人SQL语句
$this->SQL_DELETE_CANDIDATE = "DELETE FROM " . C('DB_PREFIX') . "wevote_candidates WHERE ";
// 删除投票信息SQL语句
$this->SQL_DELETE_VOTE_INFO = "DELETE FROM " . C('DB_PREFIX') . "wevote_info WHERE ";
// 删除投票人信息SQL语句
$this->SQL_DELETE_VOTER_INFO = "DELETE FROM " . C('DB_PREFIX') . "wevote_voters WHERE ";
// 删除访问者信息SQL语句
$this->SQL_DELETE_VISITOR = "DELETE FROM " . C('DB_PREFIX') . "wevote_visitors WHERE ";
}
public function __construct()
{
parent::__construct();
// 查询所有候选人SQL语句
$this->SQL_QUERY_CANDIDATES = "SELECT *, COALESCE(T2.count2, 0) AS count FROM " . C('DB_PREFIX') . "wevote_candidates AS T1\nLEFT JOIN (SELECT COUNT(id) AS count2, candidate_id FROM " . C('DB_PREFIX') . "wevote_info GROUP BY candidate_id) AS T2\nON T1.id = T2.candidate_id\nWHERE (action_id = %d) AND (status = 1)\nORDER BY count DESC LIMIT %d, %d";
// 查询所有候选人总数SQL语句
$this->SQL_QUERY_CANDIDATES_COUNT = "SELECT COUNT(id) AS count FROM " . C('DB_PREFIX') . "wevote_candidates WHERE (action_id = %d) AND (status = 1)";
// 查询候选人SQL语句
$this->SQL_QUERY_CANDIDATE = "SELECT * FROM " . C('DB_PREFIX') . "wevote_candidates WHERE (id = %d)";
// 更新候选人SQL语句
$this->SQL_UPDATE_CANDIDATE = "UPDATE " . C('DB_PREFIX') . "wevote_candidates SET title='%s', comment='%s', announce='%s', parent='%s', tel='%s', address='%s', cell='%s', picture='%s' WHERE (id = %d)";
// 删除候选人SQL语句
$this->SQL_DELETE_CANDIDATE = "DELETE FROM " . C('DB_PREFIX') . "wevote_candidates WHERE ";
// 删除投票信息SQL语句
$this->SQL_DELETE_VOTE_INFO = "DELETE FROM " . C('DB_PREFIX') . "wevote_info WHERE ";
}
