mall/modules/admin/controllers/integralAppreciation/PoolController.php

<?php

namespace app\modules\admin\controllers\integralAppreciation;

use app\models\IntegralAppreciationTransferIntegralLog;
use app\models\User;
use app\modules\admin\controllers\BaseController;
use app\modules\admin\models\integralAppreciation\PoolForm;

class PoolController extends BaseController
{

    /**
     * 积分池
     */
    public function actionIntegralList() {
        $form = new PoolForm();
        $form->attributes = get_params();
        $form->store_id = get_store_id();
        return $this->asJson($form->getIntegralList());
    }

    /**
     * 积分池
     */
    public function actionIntegralDetail() {
        $form = new PoolForm();
        $form->attributes = get_params();
        $form->store_id = get_store_id();
        return $this->asJson($form->getIntegralDetail());
    }

    /**
     * 资金池
     */
    public function actionAmountList() {
        $form = new PoolForm();
        $form->attributes = get_params();
        $form->store_id = get_store_id();
        return $this->asJson($form->getAmountList());
    }

    /**
     * 积分价格
     */
    public function actionTotalAmount() {
        $form = new PoolForm();
        $form->attributes = get_params();
        $form->store_id = get_store_id();
        return $this->asJson($form->totalAmount());
    }

    /**
     * 积分互换记录
     */
    public function actionTransferList()
    {

        $start_time = input_params('start_time', '');
        $end_time = input_params('end_time', '');
        $user_name = input_params('user_name', '');
        $mobile = input_params('mobile', '');

        $query = IntegralAppreciationTransferIntegralLog::find()->alias('tr')
            ->leftJoin(['u' => User::tableName()], 'tr.user_id = u.id')
            ->where(['tr.store_id' => get_store_id()]);

        if ($mobile) {
            $query->andWhere(['like', 'u.binding', $mobile]);
        }
        if ($user_name) {
            $query->andWhere(['like', 'u.nickname', $user_name]);
        }
        if ($start_time) {
            $start_time = strtotime($start_time);
            $query->andWhere(['>=', 'tr.created_at', $start_time]);
        }
        if ($end_time) {
            $end_time = strtotime($end_time);
            $query->andWhere(['<=', 'tr.created_at', $end_time]);
        }

        $query->orderBy('tr.id DESC')
            ->select('tr.*,u.binding mobile, u.avatar_url avatar, u.nickname');
        $list = pagination_make($query);
        foreach ($list['list'] as &$item) {
            $item['created_at'] = date('Y-m-d H:i:s', $item['created_at']);
        }

        return $this->asJson(['code'=>0, 'msg'=>'操作成功', 'data'=>$list]);
    }
}