huahuibao/common/services/xhInitService.php

<?php

namespace common\services;

use Yii;
use common\components\util;
use common\components\dict;

class xhInitService
{

    public static function clear($myOption = 'hhb')
    {
        Yii::$app->redis->executeCommand('FLUSHDB');
        $connection = Yii::$app->db;
        $result = Yii::$app->db->createCommand('SHOW TABLES')->queryAll();
        if (empty($result)) {
            util::stop('没有找到数据库表\n');
        }
        foreach ($result as $val) {
            $tableName = array_pop($val);
            if (in_array($tableName, ['xhWxOpen', 'xhWxOpenAdmin'])) {//测试时需要重复执行，xhWxOpen xhWxOpenAdmin 已经有数据则不进行清空
                continue;
            }
            $sql = 'truncate ' . $tableName;
            $connection->createCommand($sql)->execute();
        }
        $open = [];
        if (empty($open)) {
            util::fail('取平台信息错误');
        }

        if (empty($open)) {
            switch ($myOption) {
                /**
                 * case 'hhbxs'://花卉宝 线上环境
                 * $data    = [
                 * 'appId' => 'wxed3b3da77f382b4f',
                 * 'openName' => '花卉宝',
                 * 'appSecret' => '38cd1c6f37462e57bd3153e49f9a85d4',
                 * 'token' => 'wt11464773309',
                 * 'aesKey' => 'Gm2BIikJaExAbiyafGoJGFbEsECb4mDEnyEYgl9WXW5',
                 * 'createTime' => date("Y-m-d H:i:s"),
                 * ];
                 * break;
                 **/
                case 'hml'://花美灵 测试环境
                    $data = [
                        'appId' => 'wxe4428cfe08fc74d6',
                        'openName' => '花美灵',
                        'appSecret' => '2228663f0d56eb3e4b79fa96b3861f20',
                        'token' => 'wt11464773308',
                        'aesKey' => 'Gm2BIikJaExAbiyafGoJGFbEsECb4mDEnyEYgl9WXW6',
                        'createTime' => date("Y-m-d H:i:s"),
                    ];
                    break;
                case 'zhh'://中花汇 开发环境
                    $data = [
                        'appId' => 'wxa08c41644219674c',
                        'openName' => '中花汇',
                        'appSecret' => 'aec3f43257d51318538ecdb8bb78a42b',
                        'token' => 'wt11464773309',
                        'aesKey' => 'Gm2BIikJaExAbiyafGoJGFbEsECb4mDEnyEYgl9WXW5',
                        'createTime' => date("Y-m-d H:i:s"),
                    ];
                    break;
                case 'hhb'://花汇宝 演示环境
                    $data = [
                        'appId' => 'wx364800c320a0cf53',
                        'openName' => '花汇宝',
                        'appSecret' => '88565e17fa739efc020ed1e2a2a56ade',
                        'token' => 'wt11464773309',
                        'aesKey' => 'Gm2BIikJaExAbiyafGoJGFbEsECb4mDEnyEYgl9WXW5',
                        'createTime' => date("Y-m-d H:i:s"),
                    ];
                    break;
            }
            $historyTime = date('Y-m-d', strtotime('-30 days'));
            $data['verifyTicketTime'] = $historyTime;
            $data['componentAccessTokenTime'] = $historyTime;
            $data['authorizerAccessTokenTime'] = $historyTime;
            $data['preAuthCodeTime'] = $historyTime;
            xhWxOpenService::add($data);
        } else {
            xhWxOpenService::updateById($id, ['sjId' => 0]);
        }
        $id = dict::getDict('openAdminId');
        $adminOpen = xhWxOpenAdminService::getById($id);
        if (empty($adminOpen)) {
            $data = [
                'mobile' => '15280215347',
                'avatar' => '/platAdmin/admin.jpg',
                'name' => '石少华',
                'password' => md5('111111'),
                'province' => '福建',
                'city' => '厦门',
                'dist' => '思明区',
                'address' => '软件园二期望海路31号5楼阿里百川',
                'createTime' => date("Y-m-d H:i:s"),
            ];
            xhWxOpenAdminService::add($data);
        }
        $setData = ['name' => '零售基础版', 'manageStyle' => 0, 'price' => '3900', 'createTime' => date("Y-m-d H:i:s")];
        xhSetMealService::add($setData);
    }

}