application/modules/mod_stats/classes/MyDateInterval.php 1 location
|
@@ 39-47 (lines=9) @@
|
| 36 |
|
* - dateTo |
| 37 |
|
* @return string condition of date range |
| 38 |
|
*/ |
| 39 |
|
public static function prepareDateBetweenCondition($field, array $params = []) { |
| 40 |
|
$betweenCondition = ''; |
| 41 |
|
if (isset($params['dateFrom']) || isset($params['dateTo'])) { |
| 42 |
|
$dateFrom = isset($params['dateFrom']) ? $params['dateFrom'] : '2005-01-01'; |
| 43 |
|
$dateTo = isset($params['dateTo']) ? $params['dateTo'] : date('Y-m-d'); |
| 44 |
|
$betweenCondition = "AND FROM_UNIXTIME(`{$field}`) BETWEEN '{$dateFrom} 00:00:00' AND '{$dateTo} 23:59:59'"; |
| 45 |
|
} |
| 46 |
|
return $betweenCondition; |
| 47 |
|
} |
| 48 |
|
|
| 49 |
|
} |
application/modules/mod_stats/models/search_model.php 1 location
|
@@ 33-43 (lines=11) @@
|
| 30 |
|
* - dateTo |
| 31 |
|
* @return array |
| 32 |
|
*/ |
| 33 |
|
protected function prepareConditions(array $params) { |
| 34 |
|
|
| 35 |
|
$betweenCondition = ''; |
| 36 |
|
if (isset($params['dateFrom']) || isset($params['dateTo'])) { |
| 37 |
|
$dateFrom = isset($params['dateFrom']) ? $params['dateFrom'] : '2005-01-01'; |
| 38 |
|
$dateTo = isset($params['dateTo']) ? $params['dateTo'] : date('Y-m-d'); |
| 39 |
|
$betweenCondition = "AND FROM_UNIXTIME(`date`) BETWEEN '{$dateFrom} 00:00:00' AND '{$dateTo} 23:59:59'"; |
| 40 |
|
} |
| 41 |
|
|
| 42 |
|
return [$betweenCondition]; |
| 43 |
|
} |
| 44 |
|
|
| 45 |
|
/** |
| 46 |
|
* Get searched keywords by time interval |