<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2017/8/31
 * Time: 10:31
 */

namespace app\controllers;


use common\models\Deal;
use common\modules\qixunpay\vo\Pay;
use common\modules\rebate\Rebate;
use common\modules\rebate\UserRebate;
use common\services\BackMessageServices;
use common\services\ResultStatusServices;
use common\utils\CommUtil;
use Yii;
use yii\rest\Controller;


class PayController extends Controller
{
//    public $enableCsrfValidation = false;
    public function actionPayList()
    {


        $user_id = (int)Yii::$app->request->get('user_id');
        $type=Yii::$app->request->get('type');
        $current_page = (int)Yii::$app->request->get('page');
        $sort = Yii::$app->request->get('sort');

        $find = Pay::find();
        if (!empty($user_Id)) $find->andWhere(['=', $user_Id]);
        if (!empty($type)) $find->andWhere(['=',  $type]);

        $total = $find->count();

        $per_page = 12;
        $last_page = ceil($total / $per_page);

        $find->offset($per_page * ($current_page - 1))->limit($per_page);

        if (!empty($sort)) {
            list($field, $sortType) = explode("|", $sort);
            if (!empty($field) && !empty($sortType)) {
                $type = SORT_ASC;
                if ($sortType == 'desc') $type = SORT_DESC;
                $find->addOrderBy([$field => $type]);
            }
        }

        $dbList = $find->all();
        $list = [];
        foreach ($dbList as $item) {
            $itemData = $item->toArray();
            $itemData['update_time'] = CommUtil::formatDate($item->updated_at);
            $itemData['created_time'] = CommUtil::formatDate($item->created_at);
            array_push($list, $itemData);
        }

        $returnData['data'] = $list;
        $returnData['total'] = $total;
        $returnData['per_page'] = $per_page;
        $returnData['current_page'] = $current_page;
        $returnData['last_page'] = $last_page;
        return BackMessageServices::sendMessage(ResultStatusServices::RS_OPERATION_SUCCESS, $returnData);
    }

    public $enableCsrfValidation = false;
    public function actionDealList()
    {
        $complete = Yii::$app->request->get('complete');
        $endTime = Yii::$app->request->get('end_time');
        $user_id = (int)Yii::$app->request->get('user_id');
        $type=Yii::$app->request->get('type');
        $current_page = (int)Yii::$app->request->get('page');
        $sort = Yii::$app->request->get('sort');

        $find = Deal::find();
        if (!empty($user_id)) $find->andWhere(['=', 'user_id', $user_id]);
        if (!empty($complete)) $find->andWhere(['=', 'complete', $complete]);
        if (!empty($startTime)) $find->andWhere(['>=', 'created_at',  date_create($startTime)->getTimestamp()+3600*24]);
        if (!empty($endTime)) $find->andWhere(['<=', 'created_at',  date_create($endTime)->getTimestamp()+3600*24]);


        $total = $find->count();

        $per_page = 12;
        $last_page = ceil($total / $per_page);

        $find->offset($per_page * ($current_page - 1))->limit($per_page);

        if (!empty($sort)) {
            list($field, $sortType) = explode("|", $sort);
            if (!empty($field) && !empty($sortType)) {
                $type = SORT_ASC;
                if ($sortType == 'desc') $type = SORT_DESC;
                $find->addOrderBy([$field => $type]);
            }
        }
        $dbList = $find->all();
        $list = [];
        foreach ($dbList as $item) {
            $itemData = $item->toArray();
            $itemData['created_at'] = CommUtil::formatDate($item->created_at);
            array_push($list, $itemData);
        }

        $returnData['data'] = $list;
        $returnData['total'] = $total;
        $returnData['per_page'] = $per_page;
        $returnData['current_page'] = $current_page;
        $returnData['last_page'] = $last_page;
        return BackMessageServices::sendMessage(ResultStatusServices::RS_OPERATION_SUCCESS, $returnData);
    }

    public function actionRebateList()
    {
        $level = Yii::$app->request->get('level');
        $endTime = Yii::$app->request->get('end_time');
        $from_user_id = (int)Yii::$app->request->get('from_user_id');
        $type=Yii::$app->request->get('type');
        $current_page = (int)Yii::$app->request->get('page');
        $sort = Yii::$app->request->get('sort');

        $find = Rebate::find();
        if (!empty($from_user_id)) $find->andWhere(['=', 'from_user_id', $from_user_id]);
        if (!empty($level)) $find->andWhere(['=', 'level', $level]);
        if (!empty($startTime)) $find->andWhere(['>=', 'created_at',  date_create($startTime)->getTimestamp()+3600*24]);
        if (!empty($endTime)) $find->andWhere(['<=', 'created_at',  date_create($endTime)->getTimestamp()+3600*24]);


        $total = $find->count();

        $per_page = 12;
        $last_page = ceil($total / $per_page);

        $find->offset($per_page * ($current_page - 1))->limit($per_page);

        if (!empty($sort)) {
            list($field, $sortType) = explode("|", $sort);
            if (!empty($field) && !empty($sortType)) {
                $type = SORT_ASC;
                if ($sortType == 'desc') $type = SORT_DESC;
                $find->addOrderBy([$field => $type]);
            }
        }else{
                $find->addOrderBy(['id' => SORT_DESC]);
        }
        $dbList = $find->all();
        $list = [];
        foreach ($dbList as $item) {
            $itemData = $item->toArray();
            $itemData['created_at'] = CommUtil::formatDate($item->created_at);
            array_push($list, $itemData);
        }

        $returnData['data'] = $list;
        $returnData['total'] = $total;
        $returnData['per_page'] = $per_page;
        $returnData['current_page'] = $current_page;
        $returnData['last_page'] = $last_page;
        return BackMessageServices::sendMessage(ResultStatusServices::RS_OPERATION_SUCCESS, $returnData);
    }
    public function actionRebateUserList()
    {
        $level = Yii::$app->request->get('level');
        $endTime = Yii::$app->request->get('end_time');
        $parent_user_id = (int)Yii::$app->request->get('parent_user_id');
        $type=Yii::$app->request->get('type');
        $current_page = (int)Yii::$app->request->get('page');
        $sort = Yii::$app->request->get('sort');

        $find = UserRebate::find();
        if (!empty($parent_user_id)) $find->andWhere(['=', 'parent_user_id', $parent_user_id]);
        if (!empty($level)) $find->andWhere(['=', 'level', $level]);
        if (!empty($startTime)) $find->andWhere(['>=', 'created_at',  date_create($startTime)->getTimestamp()+3600*24]);
        if (!empty($endTime)) $find->andWhere(['<=', 'created_at',  date_create($endTime)->getTimestamp()+3600*24]);


        $total = $find->count();

        $per_page = 12;
        $last_page = ceil($total / $per_page);

        $find->offset($per_page * ($current_page - 1))->limit($per_page);

        if (!empty($sort)) {
            list($field, $sortType) = explode("|", $sort);
            if (!empty($field) && !empty($sortType)) {
                $type = SORT_ASC;
                if ($sortType == 'desc') $type = SORT_DESC;
                $find->addOrderBy([$field => $type]);
            }
        }
        $dbList = $find->all();
        $list = [];
        foreach ($dbList as $item) {
            $itemData = $item->toArray();
            $itemData['created_at'] = CommUtil::formatDate($item->created_at);
            array_push($list, $itemData);
        }

        $returnData['data'] = $list;
        $returnData['total'] = $total;
        $returnData['per_page'] = $per_page;
        $returnData['current_page'] = $current_page;
        $returnData['last_page'] = $last_page;
        return BackMessageServices::sendMessage(ResultStatusServices::RS_OPERATION_SUCCESS, $returnData);
    }
}

?>