123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- <?php
- namespace app\dao\user;
- use app\dao\BaseDao;
- use app\model\user\User;use app\model\user\UserAddress;
- class UserAddressDao extends BaseDao
- {
-
- protected function setModel(): string
- {
- return UserAddress::class;
- }
- protected function JoinModel() : string
- {
- return User::class;
- }
- public function getJoinModel(string $alias = 'a', string $join_alias = 'u', $join = 'left')
- {
- $this->alias = $alias;
- $this->joinAlis = $join_alias;
-
- $user = app()->make($this->joinModel());
- $table = $user->getName();
- return parent::getModel()->alias($alias)->join($table . ' ' . $join_alias, $alias . '.uid = ' . $join_alias . '.uid', $join);
- }
-
- public function getList(array $where, string $field = '*', int $page = 0, int $limit = 0): array
- {
- return $this->search($where)->field($field)->page($page, $limit)->order('is_default DESC')->select()->toArray();
- }
-
- public function getRegionAll($time, $userType)
- {
- return $this->getJoinModel()->when($userType != '', function ($query) use ($userType) {
- $query->where($this->joinAlis . '.user_type', $userType);
- })->where(function ($query) use ($time) {
- $query->whereTime($this->joinAlis . '.add_time', '<', strtotime($time[1]) + 86400)->whereOr($this->joinAlis . '.add_time', NULL);
- })->field('count(distinct(' . $this->alias . '.uid)) as allNum,' . $this->alias . '.province')
- ->group($this->alias . '.province')->select()->toArray();
- }
-
- public function getRegionNew($time, $userType)
- {
- return $this->getJoinModel()->when($userType != '', function ($query) use ($userType) {
- $query->where($this->joinAlis . '.user_type', $userType);
- })->where(function ($query) use ($time) {
- if ($time[0] == $time[1]) {
- $query->whereDay($this->joinAlis . '.add_time', $time[0]);
- } else {
- $time[1] = date('Y/m/d', strtotime($time[1]) + 86400);
- $query->whereTime($this->joinAlis . '.add_time', 'between', $time);
- }
- })->field('count(distinct(' . $this->alias . '.uid)) as newNum,' . $this->alias . '.province')
- ->group($this->alias . '.province')->select()->toArray();
- }
- }
|