huahuibao/common/services/xhInitService.php

<?php
namespace common\services;
use Yii;
use common\components\util;
use common\components\configDict;

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();
		}
		$id				= configDict::getConfig('openId');
		$open			= xhWxOpenService::getById($id);
		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, ['merchantId'=>0]);
		}
		$id					= configDict::getConfig('openAdminId');
		$adminOpen			= xhWxOpenAdminService::getById($id);
		if(empty($adminOpen)){
			$data = [
			'mobile' => '15280215347',
			'avatar' => '/platAdmin/admin.jpg',
			'adminName' => '石少华',
			'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);
	}

}