mitirrli/build-query

model query for orm.

1.2.0 2021-03-25 07:33 UTC

Requires

• php: ^7.1

Requires (Dev)

• brainmaestro/composer-git-hooks: ^2.8
• friendsofphp/php-cs-fixer: ^2.16
• php-coveralls/php-coveralls: ^2.3
• phpunit/phpunit: ~7

MIT

• Mitirrli

• framework
• orm
• tools

README

🌈 use for build query.

Environment

• PHP >= 7.1

Installation

$ composer require mitirrli/build-query

QuickStart

1. Common filter

use Mitirrli\Buildable\Constant;
use Mitirrli\Buildable\Buildable;

$this->param($params ?? [])
    ->initial(['initial' => 0])
    ->key('avatar')
    ->key('name', Constant::RIGHT)
    ->key('name', Constant::ALL)
    ->inKey('type')
    ->betweenKey('created_at', ['start' => 'create', 'end' => 'end'])
    ->beforeKey('id')
    ->afterKey('id')
    ->unsetKey('initial')
    ->sort('created_at')
    ->result();

1. Get order

use Mitirrli\Buildable\Buildable;

$order = $this
   ->param(array_merge(['update_time' => 'desc'], $params)) //默认更新时间排序
   ->sort(['update_time', 'a.update_time']) //更新时间
   ->sort(['id', 'a.id']) //ID
   ->sort('create_time')
   ->order();