andrewdyer/date-expression

A utility that can be used to create raw query date expressions for MySQL or SQLite Laravel databases

1.0.1 2022-09-06 16:47 UTC

Requires

• php: ^7.3|^8.0
• illuminate/database: ^8.76

Requires (Dev)

• phpunit/phpunit: ^9.5
• symfony/var-dumper: ^5.4

MIT

• Andrew Dyer

README

A utility that can be used to create raw query date expressions for MySQL or SQLite Laravel databases.

License

Licensed under MIT. Totally free for private or commercial projects.

Installation

composer require andrewdyer/date-expression

Usage

use Anddye\DateExpression\DateExpressionFactory;

$dateExpression = DateExpressionFactory::create($query, $column, $unit);

$value = $dateExpression->getValue();

Function Arguments

Name	Type	Description
$query	Illuminate\Database\Eloquent\Builder	The query builder being used to build the trend.
$column	string	The column being measured.
$unit	string	The unit being measured. Supported values include; "daily", "monthly" or "weekly"

Support

If you're using this package, I'd love to hear your thoughts! Feel free to contact me on Twitter.

Found a bug? Please report it using the issue tracker, or better yet, fork the repository and submit a pull request.