123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129 |
- <?php
- namespace crmeb\traits;
- use think\Model;
- trait ModelTrait
- {
-
- public function searchTimeAttr($query, $value, $data)
- {
- if ($value) {
- $timeKey = $data['timeKey'] ?? (property_exists($this, 'timeKey') && $this->timeKey ? $this->timeKey : 'add_time');
- if (is_array($value)) {
- $startTime = $value[0] ?? 0;
- $endTime = $value[1] ?? 0;
- if ($startTime || $endTime) {
- try {
- date('Y-m-d', $startTime);
- } catch (\Throwable $e) {
- $startTime = strtotime($startTime);
- }
- try {
- date('Y-m-d', $endTime);
- } catch (\Throwable $e) {
- $endTime = strtotime($endTime);
- }
- if ($startTime == $endTime || $endTime == strtotime(date('Y-m-d', $endTime))) {
- $endTime = $endTime + 86400;
- }
- $query->whereBetween($timeKey, [$startTime, $endTime]);
- }
- } elseif (is_string($value)) {
- switch ($value) {
- case 'today':
- case 'week':
- case 'month':
- case 'year':
- case 'yesterday':
- case 'last year':
- case 'last week':
- case 'last month':
- $query->whereTime($timeKey, $value);
- break;
- case 'quarter':
- [$startTime, $endTime] = $this->getMonth();
- $query->whereBetween($timeKey, [strtotime($startTime), strtotime($endTime)]);
- break;
- case 'lately7':
- $query->whereBetween($timeKey, [strtotime("-7 day"), time()]);
- break;
- case 'lately30':
- $query->whereBetween($timeKey, [strtotime("-30 day"), time()]);
- break;
- default:
- if (strstr($value, '-') !== false) {
- [$startTime, $endTime] = explode('-', $value);
- $startTime = trim($startTime) ? strtotime($startTime) : 0;
- $endTime = trim($endTime) ? strtotime($endTime) : 0;
- if ($startTime && $endTime) {
- if ($startTime == $endTime || $endTime == strtotime(date('Y-m-d', $endTime))) {
- $endTime = $endTime + 86400;
- }
- $query->whereBetween($timeKey, [$startTime, $endTime]);
- } else if (!$startTime && $endTime) {
- $query->whereTime($timeKey, '<', $endTime + 86400);
- } else if ($startTime && !$endTime) {
- $query->whereTime($timeKey, '>=', $startTime);
- }
- }
- break;
- }
- }
- }
- }
-
- public function getMonth(int $ceil = 0)
- {
- if ($ceil != 0) {
- $season = ceil(date('n') / 3) - $ceil;
- } else {
- $season = ceil(date('n') / 3);
- }
- $firstday = date('Y-m-01', mktime(0, 0, 0, ($season - 1) * 3 + 1, 1, date('Y')));
- $lastday = date('Y-m-t', mktime(0, 0, 0, $season * 3, 1, date('Y')));
- return [$firstday, $lastday];
- }
-
- public function getFieldValue($value, string $filed, ?string $valueKey = '', ?array $where = [])
- {
- $model = $this->where($filed, $value);
- if ($where) {
- $model->where(...$where);
- }
- return $model->value($valueKey ?: $filed);
- }
- }
|