function action_my_task($status) { $user_id = Auth::get_user_id(); if (!$user_id) { _throw("您还没有登陆", 9001); } $table = self::_table("user_mission"); $table_mission = self::_table("mission"); $rows = self::_db()->rows("select\n user_mission.*,mission.title,mission.thumb,mission.desc from {$table} as user_mission\n left join {$table_mission} as mission on mission.id = user_mission.mission_id\n where user_mission.user_id = ? order by user_mission.id desc ", $user_id); return array("missions" => $rows); }
function action_detail($id) { $table_mission = self::_table("mission"); $table_user_mission = self::_table("user_mission"); $table_mission_verify = self::_table("user_mission_verify"); $table_mission_task = self::_table("mission_task"); $table_user_wx = self::_table("user_wx"); $table_user_wx_rel = self::_table("user_wx_rel"); //任务详情 $mission = self::_db()->row("select * from {$table_mission} where id = ?", $id); $mission['tips1'] = null; if (!empty($mission['start_time']) && time() < strtotime($mission['start_time'])) { $mission['tips1'] = "任务未开始"; } if (!empty($mission['end_time']) && time() > strtotime($mission['end_time'])) { $mission['tips1'] = "任务已结束"; } //参与总人数 $join_users_count = self::_db()->row("select count(id) as total from {$table_user_mission} where mission_id = ?", $id); $join_users_total = $join_users_count['total']; //取最新的14个参与人头像 $limit = 14; $join_users = self::_db()->rows("select user_id from {$table_user_mission} where mission_id = ? order by id desc limit {$limit}", $id); $avatars = array(); foreach ($join_users as $join_user) { $avatar = self::_db()->row("select rel.user_id,wx.avatar as pic from {$table_user_wx_rel} as rel\n left join {$table_user_wx} as wx on wx.openid = rel.openid\n where rel.user_id = ?", $join_user['user_id']); if ($avatar) { $avatars[] = $avatar; } } //取子任务 $tasks = self::_db()->rows("select * from {$table_mission_task} where mission_id = ? order by id asc", $id); $i = 1; foreach ($tasks as &$task) { $task['key'] = $i++; } $user_id = Auth::get_user_id(); $user_mission = array(); $user_missions = array(); if ($user_id > 0) { //当前用户 参与的任务 $user_mission = self::_db()->row("select * from {$table_user_mission} where mission_id = ? and user_id = ?", $id, $user_id); //当前用户 最近提交审核的任务 $user_missions = self::_db()->rows("select * from {$table_mission_verify} where mission_id = ? and user_id = ? order by `task_key` asc ", $id, $user_id); } return array("mission" => $mission, "avatars" => $avatars, "join_users_total" => $join_users_total, "tasks" => $tasks, "user_mission" => $user_mission, "user_missions" => $user_missions); }