README

Query Shorter 是一个 laravel 包，可以缩短您 Eloquent 查询的 50%。有时我们的查询会变得过长，比如嵌套查询、条件查询，这个包会为您创建更短的查询。

这是一个小巧的包，可以轻松简化您的代码。

安装过程

composer require skycoder/query-shorter

使用

模型

<?php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Skycoder\QueryShorter\QueryShorter;

class Employee extends Model
{
    use  QueryShorter;
}

控制器

使用 Query Shorter 之前

  $employees = Employee::query()
                ->when($request->filled('name'), function($q) use($request) {
                    $q->where('name', 'like', '%' . $request->name . '%');
                })
                ->when($request->filled('department_id'), function($q) use($request) {
                    $q->where('name', $request->department_id);
                })
                ->when($request->filled('designation_id'), function($q) use($request) {
                    $q->where('designation_id', '!=', $request->designation_id);
                })
                ->when($request->filled('age'), function($q) use($request) {
                    $q->where('age', '<', $request->age);
                })
                ->when($request->filled('from_date'), function($q) use($request) {
                    $q->where('joining_date', '>=', $request->from_date);
                })
                ->when($request->filled('to_date'), function($q) use($request) {
                    $q->where('joining_date', '<=', $request->to_date);
                })
                ->when($request->filled('from_retirement_date'), function($q) use($request) {
                    $q->where('retirement_date', '>=', $request->from_retirement_date);
                })
                ->when($request->filled('to_retirement_date'), function($q) use($request) {
                    $q->where('retirement_date', '<=', $request->to_retirement_date);
                })
                ->when(request()->filled('from'), function($qr) use($request) {
                   $qr->where('date', '>=', $request->from);
                })
                ->when(request()->filled('to'), function($qr) use($request) {
                   $qr->where('date', '<=', $request->to);
                })
                ->when($request->filled('division'), function($q) use($request) {
                    $q->whereHas('contact_info', function($qr) use($request) {
                        $qr->where('division', $request->division);
                    });
                })
                ->withCount(['employee_type as employee_type_name' => function($q) { 
                    $q->select(DB::raw('name')); 
                }])
                ->latest()
                ->get();

使用 Query Shorter 之后

 $employees = Employee::query()
                        ->likeSearch('name')
                        ->searchByField('department_id') // check if the request has `department_id` value then we query
                        ->searchByField('designation_id', "!=")
                        ->searchByField('age', "<")
                        ->searchDateFrom('joining_date') // `joining_date` is database field and `from_date` from request
                        ->searchDateTo('joining_date') // `joining_date` is database field and `to_date` from request
                        ->searchDateFrom('retirement_date', 'from_retirement_date') // `retirement_date` is database field and `from_retirement_date` from request
                        ->searchDateTo('retirement_date', 'to_retirement_date') // `retirement_date` is database field and `to_retirement_date` from request
                        ->dateFilter()
                        ->searchFromRelation('contact_info', 'division')
                        ->selectName('employee_type')
                        ->selectName(['department', 'designation', 'grade'])
                        ->latest()
                        ->get();

更多包

• 用户日志
• Laravel Filesaver