huahuibao/console/controllers/InitController.php

<?php

namespace console\controllers;

use biz\user\services\UserOldDataService;
use biz\user\services\UserService;
use common\services\xhAdminService;
use common\services\xhMerchantAssetService;
use common\services\xhMerchantExtendService;
use common\services\xhWxMenuService;
use Yii;
use yii\console\Controller;
use common\models\xhDistrict;
use linslin\yii2\curl;
use common\components\util;
use common\services\xhTMessageService;
use common\services\xhMerchantService;
use back\controllers\WeixinAdminbaseController;
use common\models\xhMerchant;
use common\services\xhInitService;

/**
 * 脚本
 */
class InitController extends Controller
{

	public function actionChangeDb()
	{
		echo 'ok';
	}

	//接入一个商家需要的操作 shish 2019.9.7 yii init/join-one
	public function actionJoinOne()
	{
		$id = 12360;
		//初始化微信菜单
		$merchant = xhMerchantService::getById($id);
		//xhWxMenuService::applyInit($merchant);
		//模板消息
		$r = xhTMessageService::supplement($merchant);
		print_r($r);
	}

	//yii init/sub
	public function actionSub()
	{
		$name = 'redis_shi';
		$redisPubSub = \Yii::$app->redisPubSub;
		$redisPubSub->setOptReadTimeout(-1);
		$redisPubSub->subscribe($name, function($instance, $channelName, $message) {
			$a = 123;
		});
	}

	public function actionPub()
	{
		$name = 'redis_shi';
		$time = 'nihao1123';
		$redisPubSub = \Yii::$app->redisPubSub;
		$redisPubSub->publish($name, $time);
	}
	
	public function actionBegin()
	{

		//先清除公众号里的模板消息！！！！！！！

		$num = 0;

		//清空数据
		$this->actionFlushAll();
		
		//国兰花尚
		if($num == 0){
			xhAdminService::updateById(1,['mobile'=>'18030142050','password'=>'6a348767a0b612172e5da7539de20cb5','confirmPassword' => 'c80fd29375a3a91d3681d8445822248a','adminName'=>'姜祖岚']);
			xhMerchantService::updateById(12358, [
				'merchantName'=>'国兰花尚',
				'miniAppId'=>'wxe994a9f5fd036f69',
				'miniAppSecret'=>'53b646675251e940f56bd304c2dba480',
				'wxAppId'=>'wx193341a4a80f6ea3',
				'wxUserName'=>'gh_090c30df22e6',
				'wxAliasName'=>'glhs520',
				'openAppId'=>'wxe9211595a1d5a39f',
				'wxToken' => 'wt01467284437',
				'status' =>1,
			]);
			xhMerchantExtendService::updateByMerchantId(12358,[
				'wxAppId'=>'wx193341a4a80f6ea3',
				'miniAppId' => 'wxe994a9f5fd036f69',
				'wxPayMerchantId'=>'1244548702',
				'wxPayKey'=>'eez23jf739jsmm4309j10jnza3qw8dwm',
				'webTitle'=>'国兰花尚',
				'webKeyword'=>'国兰花尚',
				'webDescription'=>'国兰花尚',
				'alipayAccount'=>'18030142050',
				'alipayAccountName'=>'游俊涛',
			]);
		}
		//花美灵
		if($num == 1){
			xhAdminService::updateById(1,['mobile'=>'15280215347','password'=>'6a348767a0b612172e5da7539de20cb5','confirmPassword'=>'6a348767a0b612172e5da7539de20cb5','adminName'=>'石少华']);
			xhMerchantService::updateById(12358, [
				'merchantName'=>'花美灵',
				'miniAppId'=>'wxe4675bab299a52f7',
				'miniAppSecret'=>'03dd4000a26af5c17fb86321b7d1ebf3',
				'wxAppId'=>'wx84d95afcb7b594eb',
				'wxUserName'=>'gh_090c30df22e6',
				'wxAliasName'=>'glhs520',
				'wxToken' => 'wt01467284437',
				'openAppId'=>'wxb46e972ab18f27bb',
				'status' =>1,
				]);
			xhMerchantExtendService::updateByMerchantId(12358,[
				'wxAppId'=>'wx84d95afcb7b594eb',
				'miniAppId' => 'wxe4675bab299a52f7',
				'wxPayMerchantId'=>'1371367002',
				'wxPayKey'=>'eoz23aG739jscv4309275jnza32wvdwm',
				'webTitle'=>'花美灵',
				'webKeyword'=>'花美灵',
				'webDescription'=>'花美灵',
				'alipayAccount'=>'shishaohua8879@sina.com',
				'alipayAccountName'=>'石少华',
			]);
		}
		//花卉宝
		if($num == 2){
			xhAdminService::updateById(1,['mobile'=>'15280215347','password'=>'6a348767a0b612172e5da7539de20cb5','confirmPassword'=>'6a348767a0b612172e5da7539de20cb5','adminName'=>'石少华']);
			xhMerchantService::updateById(12358, [
				'merchantName'=>'花卉宝',
				'miniAppId'=>'',
				'miniAppSecret'=>'',
				'wxAppId'=>'wx66dd83ff8744f7a8',
				'wxUserName'=>'gh_a9105e0f02b9',
				'wxAliasName'=>'ihuahuibao',
				'wxToken' => 'wt01467284437',
				'status' =>1,
			]);
			xhMerchantExtendService::updateByMerchantId(12358,[
				'wxAppId'=>'wx66dd83ff8744f7a8',
				'miniAppId' => '',
				'wxPayMerchantId'=>'1442448402',
				'wxPayKey'=>'xxe29ax639jvcv4m082a1jnza32svdd0',
				'webTitle'=>'花卉宝',
				'webKeyword'=>'花卉宝',
				'webDescription'=>'花卉宝',
				'alipayAccount'=>'shishaohua8879@sina.com',
				'alipayAccountName'=>'石少华',
			]);
		}

	}

	public function actionLast()
	{
		//拉取用户
		$this->actionPullUser();
		//生成模板消息
		//$this->actionTMSupplement();
	}

	public function actionFlushAll()
	{
		$sql = "TRUNCATE xhDrawCash;
TRUNCATE xhInvite;
TRUNCATE xhLuckyDrawActivity;
TRUNCATE xhLuckyDrawAward;
TRUNCATE xhLuckyDrawAwardCustomer;
TRUNCATE xhLuckyDrawAwardParticipant;
TRUNCATE xhMerchantCapital;
TRUNCATE xhOrder;
TRUNCATE xhOrderDayNum;
TRUNCATE xhOrderGoods;
TRUNCATE xhOrderMonthNum;
TRUNCATE xhRecharge;
TRUNCATE xhStatDealByDay;
TRUNCATE xhStatInDay;
TRUNCATE xhStatInMonth;
TRUNCATE xhStatOutDay;
TRUNCATE xhStatOutMonth;
TRUNCATE xhStatUserByDay;
TRUNCATE xhStatVisitByDay;
TRUNCATE xhUnionUser;
TRUNCATE xhUser;
TRUNCATE xhUserAlipay;
TRUNCATE xhUserAsset;
TRUNCATE xhUserByDay;
TRUNCATE xhUserByMonth;
TRUNCATE xhUserCapital;
TRUNCATE xhUserIntegral;
TRUNCATE xhUserOldData;
TRUNCATE xhUserByDay;";
		//清空用户
		$sql .= "TRUNCATE xhUser;TRUNCATE xhUserAsset;TRUNCATE xhUserCapital;TRUNCATE xhUserIntegral;";
		$sql .= "TRUNCATE xhUserIntegral;TRUNCATE xhUserAlipay;ALTER TABLE xhUser AUTO_INCREMENT=12536580;";
		//清空提现申请记录
		$sql .= "TRUNCATE xhDrawCash;";
		Yii::$app->db->createCommand($sql)->execute();
		//清空订单
		$sql = "TRUNCATE xhOrder;TRUNCATE xhOrderDayNum;TRUNCATE xhOrderGoods;TRUNCATE xhOrderMonthNum;";
		Yii::$app->db->createCommand($sql)->execute();
		//清空缓存
		Yii::$app->redis->executeCommand('FLUSHDB');
	}
	
	/**
	 * 拉取微信用户 shish 2019.9.9
	 */
	public function actionPullUser()
	{

		$merchantId = 12359;

		$return = UserService::syncWeixinUser($merchantId);
		$total = isset($return['data']['total']) ? $return['data']['total'] : 0;
		xhMerchantAssetService::updateByMerchantId($merchantId, ['totalFans' => $total]);
	}
	
	/**
	 * 开放平台初始化
	 * yii init/open hhb
	 */
	public function actionOpen($myOption = 'hhb')
	{
		$hostname = isset($_SERVER['HOSTNAME']) ? $_SERVER['HOSTNAME'] : '';
		if ($hostname == 'iZ23b0wy8awZ') {
			util::stop("线上服务器不允许初始化\n");
		}
		echo "开始初始化…\n";
		xhInitService::clear($myOption);
		echo "初始化完成！\n";
	}
	
	/**
	 * 模板消息补充增加
	 * ./yii init/t-m-supplement
	 */
	public function actionTMSupplement()
	{
		//服务号
		$allMerchant = xhMerchant::getAllByCondition(['accountStyle' => 0]);
		if (empty($allMerchant)) {
			echo "没有商家需要初始化模板消息";
			Yii::$app->end();
		}
		foreach ($allMerchant as $val) {
			$merchantId = $val['id'];
			$merchant = xhMerchantService::getById($merchantId);
			xhTMessageService::supplement($merchant);
		}
	}

	/**
	 * 初始化 花卉宝 的行政区划
	 */
	public function actionDistrict()
	{
		set_time_limit(0);
		$connection = Yii::$app->db;
		$sql = 'truncate xhDistrict';
		$connection->createCommand($sql)->execute();
		$url = 'http://apis.map.qq.com/ws/district/v1/list?key=OFWBZ-2NTHP-EHNDD-LKWQY-GANM7-PXBJH';
		$curl = new curl\Curl();
		$result = $curl->get($url);
		$r = json_decode($result, true);
		if (!empty($r)) {
			$onelist = $r['result'][0];
			$twolist = $r['result'][1];
			$threelist = $r['result'][2];
			foreach ($onelist as $oneKey => $oneVal) {
				$topId = $oneVal['id'];
				$name = isset($oneVal['name']) ? $oneVal['name'] : '';
				$fullname = $oneVal['fullname'];
				$lat = (string)$oneVal['location']['lat'];
				$lng = (string)$oneVal['location']['lng'];
				$oneData = ['districtId' => $topId, 'shortName' => $name, 'fullName' => $fullname, 'locationLat' => $lat, 'locationLng' => $lng, 'parentId' => 0];
				echo "<p>1级菜单：</p>\n";
				print_r($oneData);
				echo "\n";
				$oneObj = xhDistrict::add($oneData);
				if (isset($oneVal['cidx'])) {
					$onecidx = $oneVal['cidx'];
					if (isset($onecidx[0]) && isset($onecidx[1])) {
						echo "<p>2级菜单序号： | {$onecidx[0]} {$onecidx[1]}</p>\n";
						for ($xx = $onecidx[0]; $xx <= $onecidx[1]; $xx++) {
							$twoVal = $twolist[$xx];
							$id = $twoVal['id'];
							$name = isset($twoVal['name']) ? $twoVal['name'] : '';
							$fullname = $twoVal['fullname'];
							$lat = (string)$twoVal['location']['lat'];
							$lng = (string)$twoVal['location']['lng'];
							$twoData = ['districtId' => $id, 'shortName' => $name, 'fullName' => $fullname, 'locationLat' => $lat, 'locationLng' => $lng, 'parentId' => $oneObj['id']];
							echo $xx;
							print_r($twoData);
							echo "\n";
							$twoObj = xhDistrict::add($twoData);
							if (isset($twoVal['cidx'])) {
								$twocidx = $twoVal['cidx'];
								if (isset($twocidx[0]) && isset($twocidx[1])) {
									echo "<p>3级菜单序号： | {$twocidx[0]} {$twocidx[1]}</p>\n";
									for ($incr = $twocidx[0]; $incr <= $twocidx[1]; $incr++) {
										$threeVal = $threelist[$incr];
										$id = $threeVal['id'];
										$name = isset($threeVal['name']) ? $threeVal['name'] : '';
										$fullname = $threeVal['fullname'];
										$lat = (string)$threeVal['location']['lat'];
										$lng = (string)$threeVal['location']['lng'];
										$threeData = ['districtId' => $id, 'shortName' => $name, 'fullName' => $fullname, 'locationLat' => $lat, 'locationLng' => $lng, 'parentId' => $twoObj['id']];
										$threeObj = xhDistrict::add($threeData);
										echo $incr;
										print_r($threeData);
										echo "\n";
									}
								}
							}
						}
					}
				}
			}
		}
	}
	
	public function actionImport()
	{
$str = '13947241000	0	1012
18050645581	500.85	10000
15710626721	645.00	2000		秋妹
13959203009	104.00	5000		王小姐
13720871696	0	5000		刘雯晶
13606066178	61.76	5000		蔡小姐
13459280660	9.84	6762		张小姐
13959207614	0	5000		苏文佳
13599527721	0	5000		吴瑜
13860194680	161.20	5000		杜晓蕾
18659268620	0	5000		戴茜
13950069066	0	5000		金鑫
13606045256	2.96	5000		何明
13959288441	0	5390		张小姐
13806061983	0	5000		黄晓莹
18359261252	199.92	5000		黄安妮
15305926801	0	5000		杨悦
13696950608	0	5000		Mini
13306003939	199.92	5000		陈小姐
13559474350	0	5527		张小姐
13606923843	0	5000		陈先生
13799210320	0	5000		吕秋茹
18650043128	0	5000		许凌
13666051853	0	5000		明明
18650100076	376.80	5000		郑孜
13959259769	0	5000		王芬
13950168359	0	9575		黄小姐
15859299959	0	5026		周小姐
15959239170	0	5000		沈秋雯
13696903892	0	5000		高丁婷
13959275218	0	5000		陈荣盛
18950059936	0	5541		张永力
13950058904	0	5000
13806090303	0	5000		陈小姐
13806090209	0.00	5979		杜晖
15859249049	0	5000		王斌如
13459279756	0.16	5000		解飞
18750263657	2.80	5000		林熹路
18506967678	0.00	5000		郑际任
13606055775	0	5000		何伟强
13696993169	0	5000		黄晓春
13665181131	0	5000		冯均
13400677093	0	5000		余艳蓉
15280213049	0	5000		郭磊
13666082178	0	5000		曾婷婷
13625000941	0	5000		黄潇
18695632926	13.36	5000		林建庭
13860189996	105.04	5000		石文静
13626001278	0	5000		管珠平
13860461895	0	5000		杨旭
13696991646	18.80	5000		展如
18659258133	642.72	5000		郑博鸿
18606921315	0	5000		刘琳
13559050688	156.08	5000		陈先生
13696928398	0	5000		林小姐
18859267777	398.96	5000		陈勇栋
13959237573	617.20	5000		王小姐
15980050567	0	5000		庄惠璇
18950116993	450.00	5000		方明慧
13850001133	0	9836		陈小姐
13656005600	661.20	5000		汤雅竹
18650121851	251.12	5000		姚保志
13906008783	400.72	5000		郑女士
13959290700	0	5600		邢焘
13950169684	0	5000		罗小姐
13950118148	0	5000		邓女士
13616048250	90.96	5000		李小姐
18965168289	71.32	5071		董庆顺
13860458733	855.68	5000		叶小姐
15985837717	0	5589		张冠宇
17750667077	749.20	5000		女士
13906033220	0.00	5000		张南峰
13959205828	0	11225		林维方
18850334823	261.68	5000		魏陆辉
15960206532	0	6268		周巧
13950129687	0	5000		倪萍萍
13950005513	0	8314		黄丽云
13666057157	0	5000		孔莉
13860176298	851.60	5000		张丽旋
13950888970	0	5000		周金钟
15959289777	0	8744		宋
13599508270	0	8041
13306043126	897.00	3130		林燕彬
13950065250	628.00	20000		陈婉霞
15959240102	1086.50	2913		陈凡
18859731166	73.00	5708
13063055090	460.10	2000		李莹莹
13656032165	11.00	2524		曾乐祺
13806096767	0	10000	  	玛丽姐
13806038557	0	1500		女士
13806075656	0	1465
13779961085	0	2000		黄彩虹
15960665678	0	585
13505018088	0	1700		吴剑英
18760080291	0	385		韩立舟
15985889794	0	900		项小青
13696968166	0	2330		程宇榕
13950002622	0	3265		洪先生
15305979123	0	785		廖伟铭
13255904535	0	1125		陈粤龙
18950001601	0	655		张女士
13606076651	0	2000		余女士
13666032261	0	1025		赵小姐
13950102824	0	1555
18959298099	0	1640
13906020819	0	385
15960800586	0	2035
18205951515	0	20000		詹圣哲
13599911707	0	1250		陈兵霞
15060787575	0	595		林小姐
13906029140	0	485		康慕德
18650152100	0	1400		刘小姐
15736275581	0	635		高洋
18250881053	0	2065		寒宁
13696984491	0	970
18650805089	0	2300
13559590630	0	2410
18020742720	0	438
18559829201	0	498		彭女士
15859568585	0	1600
13074879508	0	2794
13608017700	0	2182
18759470000	0	4100
15921948286	0	1000		陈飞雪
13599527106	0	2143
17704626602	0	592		郑先生
18659271133	0	4986		魏小姐
18050047626	0	100		卓志平
13850009016	0	2000		吴爱园
13850078509	0	10000		杨惠彬
15160095069	0	4320		陈菁
15859708100	0	1140		吴小姐
15985887215	0	1832		刘懿萱
18120736151	0	2000		方春燕
18649928583	0	585		吴先生
18059816606	0	1800		蓝小姐
18359704548	0	100		杨先生
13358392966	0	563		唐萍
13779988539	0	585		沈小姐
17750215023	0	493		洪先生
13763209999	0	2442
13850050100	0	2805
15880225761	0	300		邱晓那
13842969222	0	485		女士
13906003016	0	485		吴先生
13860196186	0	1070
13774691946	0	2000
15911560170	0	828
13774668248	0	191
13950068666	0	1670		陈先生
15259578999	0	600
18559690017	0	230		张丽丹
15805902518	0	2000		吴洁莹
13606907150	0	148
18666001638	0	560		曾
13950002198	0	2000
15059835588	0	535
13779993210	0	185		黄小姐
18906055275	0	228		万秋金
13686102396	0	635
15960245698	0	2000		郭燕恋
13850083997	0	385
18060945266	0	228
18653550333	0	550
15859288416	0	1720		黄女士
18606002588	0	3248		叶青红
15160001252	0	100		曹女士
18650100871	0	970		黄慧玲
13313708992	0	994		美美
15979153543	0	1183		詹旭辉
15160017961	0	500		吕思凯
18965355555	0	2360
13606026732	0	1130
13906035136	0	1100		孙小姐
13860195777	0	2528		厦门狼
15759210032	0	1178
13696904669	0	1164		宗子
13860498565	0	585		叶小姐
15989095556	0	485		黄先生
15980919889	0	1205		张秋德
13600755798	0	1080		林小姐
13616051924	0	2370		林先生
13599500884	0	200		林先生
18559285598	0	485
18606098175	0	2000		伍小姐
13666020896	0	1525
13959213428	0	165		邱小姐
18650100051	0	770		卢妙香
18559037060	0	2170		李静妮
15396212130	0	3100		王妙真
18850050200	0	3105		魏先生
18950126969	0	400		李
13382878566	0	16750
13859924605	0	870
15160061025	0	700		黄先生
13950000219	0	995		小羽
18601773661	0	730
18559221569	0	460		马小姐
18750230832	0	231		罗
18259619327	0	130		陈小姐
13400679121	0	1300		胡涛
15880981120	0	455		吴先生
13850008500	0	2429		先生
13606923982	0	290		林小姐
15859266617	0	850		梁先生
13599549621	0	1498		宁平华
13906042299	0	225		吕小姐
18650006742	0	2523		林先生
15980929513	0	685		黄钰莹
13509373776	0	206		卢小姐
13606081153	0	1905		曾小姐
13599533328	0	485		郑先生
13799279775	0	620		张小姐
13859996177	0	1148		周小姐
18506915800	0	3038		lee
13459289415	0	498		张先生
13950066136	0	350		王女士
13459217297	0	585		吕小姐
13950192095	0	313		华小姐
13606020630	0	555		张小姐
13606901692	0	35749		舒眉
15960280635	0	21941		邱娟
15359201933	0	5339		黄方斌
18950440023	0	5180
18650810622	0	32177
15860728561	0	7030		潘红
15960253989	0	7304		郑婉贤
18860098999	0	5689		李江
13860466276	0	12872		苏女士
13959213483	0	6418		陈永杰
13850001133	0	9836		陈小姐
18659268101	0	9687		朱平
13599511511	0	8063
13696960055	0	5000		林
18559288198	0	3954		吴沁乡
13799730317	0	3015		柯桦靖
18859202262	0	4636		林璇
13666021993	0	2732		陆欢欢
18659166666	0	3003		陈朝恩
13601293636	0	4148
13666006458	0	2000		陈菲菲
13489684085	0	2000
13599902996	0	2935		黄斌斌
15859291453	0	2190
15980763600	0	5223		丁妍婷
13606918514	0	3162
13606903967	0	2329
13600713099	0	2080		阿亮
13559213333	0	4460
13860189139	0	138		王
15750729316	0	145		陈婕
13600949577	0	198
15606976364	0	117
15959218576	0	200		谭欣妮
13906003375	0	150		李
15980826763	0	120
13860150766	0	170		苏艳?
15959236183	0	138		张云鹏
13799270659	0	135		黄
18559256368	0	158		樊文斌
18850190969	0	164
18650117599	0	115		黄小麦
17789611680	0	125		石玲华
13806090080	0	186		郭
15189689993	0	142		林昱君
18559250880	0	130
13695570730	0	193		臧威
15659284608	0	146
13950007643	0	142		丁小姐
13696914110	0	118		黄小姐
13950111896	0	175
18606920077	0	145
13074876858	0	140		?芷涵
13799759020	0	190
13599915232	0	156
13850009923	0	120
13860198718	0	130
18030302423	0	120		傅吉纳
17689460198	0	165		林淼培
13400619989	0	184
18906017573	0	200
13959299972	0	120		杨
13600925770	0	120		何艺琦
15800043264	0	310		庄碧娜
13950001084	0	593		游先生
18840968126	0	435		周磊
13806090083	0	290
15013105201	0	250		陈小萍
13559935855	0	820		邱文斌
13616045402	0	485		肖绵绵
13599533372	0	385		王佳
18859853666	0	1162
13950006045	0	255		李元元
13799282527	0	485
15710668380	0	385		魏真
13859940296	0	285		廖小姐
18350201726	0	780
13959260695	0	297		赵娟琴
13606076068	0	685		石
13806087087	0	385		黄
18721515629	0	385		任秀萍
13606060039	0	485		高
13959818695	0	385
13806006789	0	350		秋旭
18750201883	0	1075		王华兰
13860188337	0	527		陈春风
13505051221	0	398		绵
18650029934	0	385		傅毓辉
18750275217	0	507
13606053183	0	485		李达鸿
13696990090	0	398		苏晓燕
13906013229	0	385		黄梦兰
13606032210	0	555
13779952590	0	550		曾
18606090031	0	415		师育起
13806031461	0	405		罗小姐
18206078983	0	225		林香
13860181767	0	485
13429329346	0	594		黄水和
18050099900	0	347		郑佳彬
13666060193	0	855		陈丽丽
13696938387	0	285		蔡小姐
18205921730	0	350
13003970501	0	342
18205967612	0	211		赵美玲
13860118659	0	855		颜
13110920225	0	820		林娅欣
15959280646	0	700		郭云
13806074630	0	520
18659506065	0	398		大师
18750936269	0	385
18559872005	0	980		唐敏捷
13850077267	0	620		潘丽娜
13859903231	0	380
13666047217	0	288		周小姐
18659153855	0	720		陈西丽
13365083888	0	687
13606912400	0	450		林涛
18206081199	0	385		许
13375921500	0	578		周
18659230422	0	420		陈庆凤
15060405786	0	253
18030111546	0	230
18857537408	0	350		王燕
13599501839	0	770		杨艺
13799285590	0	980		鑫
13779956975	0	1658		刘婕
18020747088	0	750		艾森豪威尔
13859966186	0	502		纪留娜
17605070817	0	398		张劲
18059293900	0	335		开心
15359201777	0	285		刘峭妹
13850056156	0	485		马雪冰
13806061863	0	385		zhb
18030021710	0	485		张淑君
13779959880	0	385
13906008098	0	1841
18659568898	0	435		吴夏冰
18906037298	0	245		林鹭玫
13600975578	0	257
13666065980	0	1397		莉娜
18561345726	0	820		秦艳如
18150178888	0	782		楚艳
13950151550	0	850
15960270623	0	325		杜芊
17081945147	0	270		刘谅
13666043800	0	920		欧阳朝?
13606093600	0	285		林媛媛
18905925208	0	550		陈
13459266106	0	398		郭小姐
18650168484	0	335		黄
13696925869	0	818		吴?琪
13178070066	0	228		秋瑾
18605924817	0	985		陈婉婷
13799285579	0	550		高岚
18850508898	0	398
15160099934	0	1189		李
18659260800	0	385		孙捷
13779961758	0	285
13910962336	0	985		程程
13779985569	0	636		林瑛
18059234423	0	450		蔡志刚
13559208539	0	285		?永南
15259254330	0	251		王天养
15328889964	0	1000		?、昊郑
18650167688	0	840		魏佳妮
13616045321	0	1550		水水
13074886126	0	324
13666026326	0	485		林
13860097772	0	385
15980849372	0	347		璐璐
13779951903	0	986		陈小姐
15959210073	0	670
13276961016	0	720
13600936681	0	499
13666053616	0	398		康俊君
13860480845	0	802		杨敏
13960374301	0	600		陈淑芬
15160730293	0	360		熊天
15860909237	0	520		黄少伟
15659288897	0	398		曾倩
13779940690	0	285		水晶
13034628111	0	477		郭俊亚
13850000345	0	385		宁宁
13950595580	0	698		左翕瑗
15060308660	0	385
13860186182	0	850
18090592222	0	383		李娟
13616058576	0	620		黄小姐
18206067779	0	485		孙景楷
13666000338	0	385		晓虹
18650005772	0	970		黄小姐
13055208085	0	850		嘉乐
18050081688	0	340
15258866040	0	285		徐叶鹏
13720879665	0	853		种香香
18750938490	0	318
15080331891	0	299		陈
18205999913	0	1194		陈艺玲
18650153153	0	1335		少惠
13636989993	0	1540		许清秀
13860450966	0	1835		陈杰
13559072226	0	1150		林
13959286845	0	1530
13850002949	0	1753		猪猪
15381692906	0	1002		胡如芳
15959399906	0	1880		赵
13600961556	0	1606
18559295328	0	1231
13599538857	0	2339
18250161204	0	2118		张小姐
18559289598	0	1429
13799767183	0	1632		穆
18695667197	0	1155		黄俊楷
18665933383	0	1152
13806012529	0	1685		蒋群
18559649006	0	1460
18759222010	0	2088		戴昕
13606018864	0	1800		吴
13696959870	0	1151		杨
13500027041	0	1155		姜丽
13860198715	0	108		李小姐
15280215347	0	5171		石少华
15332276677	0	100		刘瑞
15710626721	0	115		严秋妹
13950051154	0	100
18659851677	0	110
13806031511	0	398		黄先生
18359256858	0	345		张小姐
15880712555	0	2000
18650150015	0	725		吴先生
18505922366	0	2058		韩先生
15260180038	0	1555		陈启鸿
18205986653	0	1070		陈佳
13600901989	0	237		苏小姐
15002305607	0	398		凌公子（微信号）
13906058199	0	636		许云雨
18551014320	0	330		李先生
13606009896	0	670
18649705023	0	485		张家伟
13779930477	0	598		先生
15959297719	0	783		颜小姐
13799297053	0	380		李小姐
15960202598	0	585		黄先生
13959291727	0	717		林女士
15160070003	0	2000		吴先生
18050088888	0	1565		洪先生
13599505435	0	1070
13515966803	0	315		张小姐
18030098399	0	385		林小姐
13559201076	0	1300		郑新华
13606031210	0	5000		茶之然
18059206715	0	5000		陈伟金
13806061955	0	9276		曾先生
15960298475	0	5000
13600908880	0	5000		林小姐
18695637722	0	5000		王小姐
18695638821	0	5000		吴淑姗
18565628686	0	5000
18659295128	0	5000		兆元
13559045678	0	5000		王萍萍
13606061197	0	5000		刘小姐
18965116170	0	5000		闻文
13606065216	0	5000		林露曦
13696951979	0	5000		许永红
13123386758	0	5000		彭晶
13616029897	0	5000		晓东先生
18205929266	0	10000		阮小姐
13950052965	0	5000		黄小姐
18605923366	0	5000		王小姐
15960236799	0	5000		陈先生
18610344561	0	5000		郑义
18250860096	0	5000		潘小姐
18965116039	0	5000		廖丰顺
15859770087	0	5000		先生
13806009624	0	5000		陈鸣鸿
13950113099	0	6611		候小姐
18650816769	0	5000
18859206686	0	6417		黄静
13600922009	0	5000		周小姐
13599530337	0	5000		姚丽娟
13559200743	0	5350		柯英杰
15359275552	0	5000		本爱琴
13958730169	0	5000		安子
13606000139	0	5000
18659072828	0	5000		?翠?
13606010888	0	5000		肖先生
13960830301	0	5000		徐森婷
18559239933	0	5000		柯舒静
13905953920	0	5000		黄婷婷
18794788989	0	5000		张庆昕
13806086688	0	6340		刘小姐
18205973587	0	5000		安小姐
13950055031	0	5000		张先生
13906001946	0	5000		罗海鸣
18650038507	0	5000
13606059178	0	5000		吴小姐
18650119077	0	5000		高小玉
18060967889	0	5000		杨小姐
18650155966	0	5000		林思沫
17032260228	0	5000		黄小姐
18605023635	0	5633		高女士
13779968069	0	5000		高鹭芗
18659995050	0	5000		张仙红
18759223496	0	5000		廖金钗
13606000066	0	5000		姚辛莹
18859995555	0	5000		叶萌芽
18606008187	0	5000		蒋小姐
13906029050	0	5000		王小姐
13696986680	0	5000		张玲
13859987997	0	5000		小姐
13806038054	0	5000		郑先生
18950171850	0	5000		陈文忠
15880248198	0	5000		夏丽
13348370097	0	5000		邹幼凤
13906032681	0	5000		张小姐
13606097710	0	5000		郭小姐
15960249698	0	5000		彭先生
18950068989	0	5000		周先生
18205950051	0	5000		蔡燕茹
13858861161	0	5000		方女士
13950068737	0	5000		陈女士
13860128717	0	5000		熊素娥
18250868387	0	5000		林先生
13599511181	0	8371		郭小姐
15980931982	0	5000		姚小姐
13506928893	0	5000		林小姐';
		
		$str = trim($str);
		$arr = explode('
',$str);
		if(!empty($arr)){

			$sql = "TRUNCATE xhUserOldData";
			Yii::$app->db->createCommand($sql)->execute();

			foreach($arr as $item){
				$it = explode('	',$item);
				$mobile = $it[0];
				$amount = $it[1];
				$integral = $it[2];
				$name = '';
				if(isset($it[3]) && !empty($it[3])){
					$name = $it[3];
				}
				if(isset($it[4]) && !empty($it[4])){
					$name = $it[4];
				}
				UserOldDataService::add(['merchantId'=>12358,'mobile'=>$mobile,'userName'=>$name,'integral'=>$integral,'balance'=>$amount,'status'=>0,'createTime'=>date("Y-m-d H:i:s")]);
			}
		}
	}
	
}