Download the PHP package cuongnd88/lara-query-kit without Composer
On this page you can find all versions of the php package cuongnd88/lara-query-kit. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package lara-query-kit
Lara Query Kit
Lara Query Kit utilizes the Eloquent model. PHP Trait and Laravel local scope are used to implement this utilitiy
PHP Traits
PHP only supports single inheritance: a child class can inherit only from one single parent.
So, what if a class needs to inherit multiple behaviors? OOP traits solve this problem.
Traits are used to declare methods that can be used in multiple classes. Traits can have methods and abstract methods that can be used in multiple classes, and the methods can have any access modifier (public, private, or protected).
Laravel local scope
Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application. To define a scope, simply prefix an Eloquent model method with scope
.
Installation & Configuration
1-Install cuongnd88/lara-query-kit
using Composer.
2-Push lara-query-kit
into your application.
3-App\Traits\QueryKit.php
is already to pump your performance. Please add QueryKit
into the model
Available methods
Let discuss each method available on the Query Kit.
- insertDuplicate()
- getTableColumns()
- exclude()
- filter()
- searchFulltext()
insertDuplicate
insertDuplicate(array $data, array $insertKeys, array $updateKeys)
: Insert new rows or update existed rows.
getTableColumns
getTableColumns()
: Get the array of columns.
exclude
exclude(array $columns)
: Retrieve a subset of the output data.
You should define which model attributes you want to exclude. You may do this using the $excludable
property on the model.
Or pass a array of excludable columns as argument
filter
filter(array $params)
: Get the result with filter conditions.
You may use the fitler
method on a query builder instance to add where
clauses to the query.
The $filterable
property should contain an array of conditions that you want to execute searching. The key of filterable array corresponds to table columns, whereas the value is condition to call where
clauses. The most basic condition requires two arguments:
-
The first argument is simple where clause such as: where, orWhere, whereBetween, whereNotBetween, whereIn, whereNotIn, whereNull, whereNotNull, orWhereNull , orWhereNotNull, whereDate, whereMonth, whereDay, whereYear, whereTime
- The second argument is an operator, which can be any of the database's supported operators.
Exceptionally, the third argument is required with the operator
is LIKE
, it is for a specified pattern
For convenience, if you verify only column in fiterable
property, the default clause is where
with =
operator
Dynamically, you can call filterableCondition()
and assign the filterable conditions
searchFulltext
_searchFulltext($value, $mode = NATURAL_LANGUAGE)
: Run full-text queries against character-based data in MySQL tables._
There are four modes of full-text searches:
NATURAL_LANGUAGE
(is default): IN NATURAL LANGUAGE MODENATURAL_LANGUAGE_QUERY
: IN NATURAL LANGUAGE MODE WITH QUERY EXPANSIONBOOLEAN_MODE
: IN BOOLEAN MODEQUERY_EXPANSION
: WITH QUERY EXPANSION
The $searchable
property should contain an array of conditions that you search full-
You flexibly add matched columns by searchableCols()
You must create a full-text index
on the table before you run full-text queries on a table. The full-text index can include one or more character-based columns in the table.