今天就跟大家聊聊有关laravel中collection的作用是什么,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。
pluck
public function getDeductCourse()
{
return TeacherFinanceLogModel::select(['order_id', 'period'])->where('type', 6)
->get()->pluck('period', 'order_id')->all();
}
group map keyBy
public function getStudentCourseByUids($uids)
{
$studentCourse = $this->studentCourseModel
->select(['uid', 'grade_type', 'subject', 'period', 'old_period', 'period_total', 'finish_period', 'wait_period', 'total_free_period', 'free_period', 'wait_free_period'])
->whereIn('uid', $uids)
->get();
return collect($studentCourse)->groupBy('uid')->map(function ($item) {
return $item->keyBy(function ($value) {
return sprintf("%s-%s-%s", $value['uid'], $value['grade_type'], $value['subject']);
})->toArray();
})->toArray();
}
filter
public function getRewardsAndPunishByUid($uids)
{
$rewardPunish = $this->courseRewardsModel
->select([
"course.uid",
"course.grade_type",
"course.subject",
"course.course_type",
"course.period_type",
"course.course_id",
"course.tid",
"course_rewards.s_rewards",
"course_rewards.t_rewards",
"course_rewards.s_option_status",
"course_rewards.t_option_status"
])
->leftjoin("course", "course.course_id", "=", "course_rewards.course_id")
->whereIn('course.uid', $uids)
->where("course.course_type", 1)
->get();
return collect($rewardPunish)->filter(function ($item) {
return ($item->s_rewards == 1 || $item->s_rewards == -1) && $item->s_option_status != 1;
})->groupBy('uid')->map(function ($item) {
return [
'reward_total' => $item->filter(function ($value) {
return $value->s_rewards == 1;
})->sum('s_rewards'),
'punish_total' => abs($item->filter(function ($value) {
return $value->s_rewards == -1;
})->sum('s_rewards'))
];
})->toArray();
}
看完上述内容,你们对laravel中collection的作用是什么有进一步的了解吗?如果还想了解更多知识或者相关内容,请关注天达云行业资讯频道,感谢大家的支持。