dongm2ez/general-db

database CRUD

Laravel general-db

:heart: This package helps you smiple CRUD, _(*1)

, _(*2)

Requirement

• PHP >= 7.0

Installation

$ composer require dongm2ez/general-db

After installing the library, register the Dongm2ez\Db\DbServiceProvider in your config/app.php file:, _(*3)

php 'providers' => [ // Other service providers... Dongm2ez\Db\DbServiceProvider::class, ],, _(*4)

As optional if you want to modify the default configuration, you can publish the configuration file:, _(*5)

$ php artisan vendor:publish --provider='Dongm2ez\Db\DbServiceProvider' --tag="config"

Usage

<?php

namespace App\Repositories;

class ExampleRepository extends \Dongm2ez\Db\AbstractRepository
{
    protected function init()
    {
        $this->model = new ExampleModel();
    }
}

<?php

namespace App\Services;

class ExampleService extends \Dongm2ez\Db\AbstractService
{
    public function getAllList($params)
    {
        $extends = $this->listParamsFormat($params);
        $input = $this->listFillableFromArray($params, [
            'id',
            'user_id',
            'create_at',
            'update_at',
        ]);

        $result = (new \App\Repositories\ExampleRepository())->getList(array_merge($input, ['_extends' => $extends]));

        return $result;
    }
}

<?php

namespace App\Http\Controller;


class ExampleController extends Controller
{
    public function lists(Request $request)
    {
        $masterData = (new \App\Services\ExampleService)->getAllList($request->all());
    }
}

传值格式

字段{条件}=值, _(*6)

条件不传默认为 = 查询, _(*7)

例子：, _(*8)

id{!}=1,意思为取 id 不等于1的所有, _(*9)

支持查询条件

一元查询

{>} 大于，?pay_money{>}=100, _(*10)

{ge} 大于等于, ?pay_money{ge}=100, _(*11)

{<} 小于, ?pay_money{<}=100, _(*12)

{le} 小于等于, ?pay_money{le}=100, _(*13)

{!} 不等于, ?pay_money{!}=100, _(*14)

{~} like 查询, ?pay_money{~}=100, _(*15)

{!~} not like 查询, ?pay_money{!~}=100, _(*16)

{#} is null 查询, ?delete_at{#}=null,表示delete_at is null, _(*17)

{!#} is not null 查询, ?delete_at{!#}=null,表示delete_at is not null), _(*18)

二元查询

{<>} between 查询, ?create_date{<>}=2017-10-01,2017-10-02,表示create_date between(2017-10-01,2017-10-02), _(*19)

{><} not between 查询, ?create_date{><}=2017-10-01,2017-10-02,表示create_date not between(2017-10-01,2017-10-02), _(*20)

多元查询

订单合单类型在做 {@}、{!@} 查询时使用 ** 表示中间连接符，如 goods,event**goods 表示查询商品与活动和商品合单, _(*21)

{@} in 查询, ?id{@}=1,2,3,4,表示id IN(1,2,3,4), _(*22)

{!@} not in 查询, ?id{!@}=1,2,3,4,表示id IN(1,2,3,4), _(*23)

扩展条件

_page 页码，默认1, _(*24)

_limit 分页大小，默认15, _(*25)

_sort 排序字段，默认id, _(*26)

_order 排序方式，默认DESC, _(*27)

_group 分组字段，默认空, _(*28)

_fields 查询字段，默认 *, _(*29)

_type 查询类型，列表默认 page 分页，可选 offset 方式, _(*30)

_version 版本，默认 V1, _(*31)

用法：, _(*32)

?_type=offset&_page=200&_limit=10 偏移量模式，_page 是偏移量，_limit 是取多少, _(*33)

License

MIT, _(*34)