public static function eventReply($key)
{
$db = Vera_Database::getInstance();
$result = $db->select('wechat_Click', '*', array('event_key' => $key));
if (!$result) {
return false;
}
return $result[0];
}
private static function getActs()
{
$db = Vera_Database::getInstance();
$start = date("Y-m-d H:i:s", time() + 86400);
//一天内
$end = date("Y-m-d H:i:s", time() - 3600);
//过期一小时内
$condition = "startTime <= '{$start}' and '{$end}' <= endTime and isPassed = 1";
return $db->select('rollcall_Board', 'md5', $condition);
}
protected static function getUserInfo()
{
if (empty(self::$resource)) {
throw new Exception("Resource can not be empty", 1);
}
if (!($db = Vera_Database::getInstance())) {
throw new Exception("Cannot get instance of database", 1);
}
$result = $db->select('vera_User', '*', array('wechat_id' => self::$resource['openid']));
if (!$result) {
self::$userInfo = -1;
return NULL;
}
self::$userInfo = $result[0];
return $result[0];
}
protected function getYibanInfo()
{
if (empty(self::$resource)) {
return false;
}
if (!($db = Vera_Database::getInstance())) {
return false;
}
$num = $this->getStuNum();
$result = $db->select('vera_Yiban', '*', array('xmu_num' => $num, 'fromApp' => 'mall'));
if (!$result) {
self::$yibanInfo = -1;
return false;
}
self::$yibanInfo = $result[0];
return $result[0];
}
/**
* 取未来一段时间的任务，未推送且已审核通过
* @param integer $seconds 未来一段时间（秒）
* @return array 任务数组
*/
public function getNowTasks($seconds = 600)
{
$db = Vera_Database::getInstance();
$next = date("Y-m-d H:i:s", time() + $seconds);
$cond = "pushTime <= '{$next}' and state = 0 and review = 1";
//取出未来一段时间以内没有推送过的任务
$result = $db->select('wechat_PushTask', '*', $cond);
if (!$result) {
return false;
}
return $result;
}
/**
* @param string $yb_uid 易班id
* @param int $teacher_id 老师id
* @return int 影响行数
* @author nili <*****@*****.**>
*/
public static function vote($teacher_id, $yb_uid)
{
$db = Vera_Database::getInstance();
$db->insert('wap_TeacherLog', array('yb_uid' => $yb_uid, 'teacher_id' => $teacher_id, 'time' => date('Y-m-d H:i:s')));
$where = array('id' => $teacher_id);
$set = 'vote=vote + 1';
$db->update('wap_Teacher', $set, $where);
}
/**
* 插入一条抽奖日志
* @param string $yiban_uid 易班id
* @param string $xmu_num 学号
* @param string $award 获得网薪值
* @return int 影响行数
* @author nili
*/
public static function insertLog($yiban_uid, $xmu_num, $award)
{
$db = Vera_Database::getInstance();
return $db->insert('wechat_TmpLuck', array('xmu_num' => $xmu_num, 'yiban_uid' => $yiban_uid, 'award' => $award, 'time' => date("Y-m-d H:i:s")));
}
/**
* 根据学号获取密码
* @param string $xmu_num 学号
* @return string 密码
* @author nili
*/
public static function getPwdByXmuNum($xmu_num)
{
$db = Vera_Database::getInstance();
$res = $db->select('vera_User', 'xmu_password', array('xmu_num' => $xmu_num));
return $res[0]['xmu_password'];
}