public function get_uncommented_list()
{
$students = StudentModel::joins(['job.uid' => $this->user['uid'], 'j.status' => JoinModel::STATUS_JOINED]);
foreach ($students as $key => &$student) {
$comment = M('job_comment')->where(['uid' => $student['uid'], 'job_id' => $student['job_id'], 'type' => 2])->find();
if ($comment) {
unset($students[$key]);
}
}
return $students;
}
public static function joins($conditions)
{
$students = M('job_join j')->join('__JOB__ job on job.id = j.job_id', 'left')->join('__JOB_USER_RESUME__ resume on resume.uid = j.uid', 'left')->join('__USER__ user on user.uid = j.uid', 'left')->join('__USER_INFO__ user_info on user_info.uid = j.uid', 'left')->field('
j.job_id, j.uid, j.is_company_paid, job.title as job_title,
user.realname, user.mobile, resume.avatar,
user_info.university_name, user_info.campus_name')->order('j.created desc')->where($conditions)->select();
foreach ($students as &$student) {
$student['score'] = StudentModel::get_score($student['uid']);
$student['avatar'] = $student['avatar'] ?: StudentModel::DEFAULT_AVATAR;
}
return $students;
}
public function joins($id)
{
$this->assign('job', $this->get_job($id));
$this->assign('list', StudentModel::joins(['j.job_id' => $id, 'j.status' => JoinModel::STATUS_JOINED]));
$this->display();
}
