<?php
/**
* Created by PhpStorm.
* User: xiaofeng
* Date: 2018/5/2
* Time: 上午10:09
*/
namespace backend\controllers;
use backend\base\CommonController;
use backend\base\Help;
use common\models\WxJc;
use common\models\WxRand;
use common\models\WxUserJc;
use Yii;
use common\models\WxUser;
class WxController extends CommonController
{
/*
* 首页-view
* */
public function actionHome()
{
return $this->render('home');
}
/*
* 首页数据
* */
public function actionHomeform()
{
$model = new WxUser();
$result = $model->getList(Yii::$app->request->post());
if($result != null)
{
foreach ($result as &$val)
{
$val['create_at'] = date('Y-m-d H:i',$val['create_at']);
}
return Help::JsonData(0,'成功',$model->Total(Yii::$app->request->post()),$result);
}
return Help::JsonCode(Help::ERROR,'暂无数据');
}
/*
* 添加页面
* */
public function actionCreate()
{
return $this->render('create');
}
/*
* 添加数据
* */
public function actionCreateform()
{
$input = Yii::$app->request->post('data');
$model = new WxUser();
$model->name = $input['name'];
$model->openid = 'a';
$model->key = 'a';
$Transaction = Yii::$app->db->beginTransaction();
$result = $model->save();
$jc = new WxUserJc();
$jc->uid = $model->attributes['id'];
$jc->jc = 0;
$rand = WxRand::find()->andWhere(['state'=>1])->one();
$rand->state = 2;
$jc->rand = $rand->id;
if($jc->save() == true && $result == true && $rand->save())
{
$Transaction->commit();
return Help::JsonCode(Help::SUCCESS,'添加成功',['rand'=>$jc->rand]);
}
$Transaction->rollBack();
return Help::JsonCode(Help::ERROR,'添加失败，请重新添加');
}
//===============奖次相关
public function actionJchome()
{
return $this->render('jchome');
}
/*
*
* */
public function actionJchomeform()
{
$model = new WxJc();
$result = $model->getList(Yii::$app->request->post());
$query = \common\models\WxUserJc::find();
$groupJc = $query->andWhere(['<>','jc',0])->select(["count('js') as jcnum",'jc'])->groupBy('jc')->asArray()->all();
$jc = array_column($groupJc,'jcnum','jc');
if($result != null)
{
foreach ($result as &$val)
{
if(isset($jc[$val['id']]))
{
$val['state'] = '已抽';
$val['total'] = $jc[$val['id']];
}
else
{
$val['state'] = '未抽';
$val['total'] = 0;
}
$val['create_at'] = date('Y-m-d H:i',$val['create_at']);
}
return Help::JsonData(0,'成功',$model->Total(),$result);
}
return Help::JsonCode(Help::ERROR,'失败');
}
public function actionJccreate()
{
return $this->render('jccreate');
}
public function actionJccreateform()
{
$model = new WxJc();
$input = Yii::$app->request->post();
$one = $model::find()->andWhere(['name'=>$input['name']])->andWhere(['del'=>1])->one();
if($one != null) return Help::JsonCode(Help::ERROR,'该奖次已存在');
$model->name = $input['name'];
if($model->save() == true) return Help::JsonCode(Help::SUCCESS,Yii::t('app','add_success'));
return Help::JsonCode(Help::ERROR,Yii::t('app','add_error'));
}
public function actionJcedit()
{
$model = new WxJc();
$input = Yii::$app->request->get();
$row = $model->FindByOne($input['id']);
return $this->render('jcedit',['model'=>$row]);
}
public function actionJceditform()
{
$model = new WxJc();
$input = Yii::$app->request->post();
$row = $model->FindByOne($input['id']);
if($row != null)
{
$row->name = $input['name'];
if($row->save() == true) return Help::JsonCode(Help::SUCCESS,Yii::t('app','edit_success'));
}
return Help::JsonCode(Help::SUCCESS,Yii::t('app','edit_error'));
}
public function actionJcdel()
{
$model = new WxJc();
$input = Yii::$app->request->post();
$row = $model->FindByOne($input['id']);
if($row != null)
{
$row->del = 2;
if($row->save() == true) return Help::JsonCode(Help::SUCCESS,Yii::t('app','del_success'));
}
return Help::JsonCode(Help::SUCCESS,Yii::t('app','del_error'));
}
/*
* 获奖人员名单
* */
public function actionAwardnamelist()
{
$input = Yii::$app->request->get();
$rows = WxUserJc::find()->select(['pfg_wx_user.name','pfg_wx_user.photo','pfg_wx_user_jc.rand'])->andWhere(['pfg_wx_user_jc.jc'=>$input['id']])->leftJoin('pfg_wx_user','pfg_wx_user_jc.uid=pfg_wx_user.id')->asArray()->all();
if($rows != null)
{
return $this->render('awardnamelist',['model'=>$rows]);
}
}
/*
* 清除奖次，重新抽奖
* */
public function actionJcclear()
{
$input = Yii::$app->request->post();
$jcRows = WxUserJc::find()->andWhere(['jc'=>$input['id']])->asArray()->all();
if($jcRows == null) return Help::JsonCode(Help::ERROR,'暂无该奖次记录');
$beginTransaction = Yii::$app->db->beginTransaction();
foreach ($jcRows as &$val)
{
$val['create_at'] = $_SERVER['REQUEST_TIME'];
$val['update_at'] = $_SERVER['REQUEST_TIME'];
$val['session_id'] = Yii::$app->session['user_info']['uid'];
}
$result = Yii::$app->db->createCommand()->batchInsert('pfg_wxjc_record',['jc','state','create_at','update_at','uid','rand','session_id'],$jcRows)->execute();
$res = WxUserJc::updateAll(['jc'=>0,'state'=>1],['jc'=>$input['id']]);
if($res > 0 && $result >0 )
{
$beginTransaction->commit();
return Help::JsonCode(Help::SUCCESS,'操作成功');
}
$beginTransaction->rollBack();
return Help::JsonCode(Help::ERROR,'操作失败');
}
//语录
public function actionYhome()
{
return $this->render('yhome');
}
public function actionYhomeform()
{
$model = new \common\models\WxJt();
$rows = $model->getList(Yii::$app->request->post());
if($rows != null)
{
return Help::JsonData(0,'成功',$model->Total(),$rows);
}
}
public function actionYcreate()
{
return $this->render('ycreate');
}
public function actionYcreateform()
{
$model = new \common\models\WxJt();
$input = Yii::$app->request->post('data');
$model->text = $input['name'];
if($model->save()) return Help::JsonCode(Help::SUCCESS,'添加成功');
return Help::JsonCode(Help::ERROR,'添加失败');
}
public function actionYedit()
{
$row = \common\models\WxJt::findOne(Yii::$app->request->get('id'));
if($row != null)
{
return $this->render('yedit',['model'=>$row]);
}
}
public function actionYeditform()
{
$input = Yii::$app->request->post('data');
$row = \common\models\WxJt::findOne($input['id']);
if($row != null)
{
$row->text = $input['name'];
if($row->save()) return Help::JsonCode(Help::SUCCESS,'操作成功');
return Help::JsonCode(Help::ERROR,'操作失败');
}
}
public function actionYdel()
{
$row = \common\models\WxJt::findOne(Yii::$app->request->post('id'));
if($row != null)
{
if($row->delete() == true) return Help::JsonCode(Help::SUCCESS,'操作成功');
return Help::JsonCode(Help::ERROR,'操作失败');
}
}
}