JobfairPersonalJobsReceiveRepository.php 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: wuzhenke
  5. * Date: 2019/1/25
  6. * Time: 17:54
  7. */
  8. namespace App\Repositories\Jobfair;
  9. use App\Models\Jobfair\JobfairPersonalJobsReceive;
  10. use Prettus\Repository\Eloquent\BaseRepository;
  11. class JobfairPersonalJobsReceiveRepository extends BaseRepository
  12. {
  13. public function model()
  14. {
  15. return JobfairPersonalJobsReceive::class;
  16. }
  17. public function getResume($where)
  18. {
  19. return $this->model->with(['jobfairs','resumes','putJobs'])->where($where)->orderBy("personal_look", 'asc')->paginate(10);
  20. }
  21. public function personJobfair($data, $where, $resumeWhere)
  22. {
  23. return $this->model->with(['resumes', 'putJobs'=>function ($query) use ($where) {
  24. $query->whereIn('audit', $where)->where('display', 1);
  25. }, 'jobfairs'])->where($data)->whereHas('resumes')->whereHas('putJobs')->whereHas('jobfairs')->orderBy('id', 'desc')->paginate(10);
  26. }
  27. public function delete($id){
  28. return $this->model->where('id', $id)->delete();
  29. }
  30. }