public function actionWin()
{
$data = Yii::$app->request->post();
if (!isset($data['phone'])) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
//(new \yii\db\Query ())->createCommand();
$connection = Yii::$app->db;
$user = Users::findOne(['phone' => $data['phone']]);
//$query->andFilterWhere(['grabcornrecords.userid' => $user->id]);
//$connection->queryBuilder->buildUnion($unions, $params)
//$cmd=$connection->createCommand('SELECT if(isnull(grabcornrecords.id),0,0) as tbk, `grabcorns`.`id` AS `flag`, `grabcornrecords`.`id`, `grabcornrecords`.`grabcornid` AS `grabid`, `grabcornrecords`.`userid`, `grabcornrecords`.`type`, `grabcornrecords`.`created_at`, `grabcornrecords`.`isgotback`, `grabcorns`.`isgot`, `grabcorns`.`picture`, `grabcorns`.`title`, `grabcorns`.`version`, `grabcorns`.`date`, `grabcorns`.`needed`, `grabcorns`.`end_at`, `grabcorns`.`islotteried`, `grabcorns`.`winnernumber`, `users`.`nickname`, `users`.`phone`, `users`.`thumb` FROM `grabcornrecords` INNER JOIN `grabcorns` ON grabcornrecords.grabcornid = grabcorns.id INNER JOIN `users` ON grabcornrecords.userid = users.id and winnerrecordid = grabcornrecords.id WHERE `grabcornrecords`.`userid`=:userid UNION ALL SELECT if(isnull(grabcommodityrecords.id),1,1) as tbk, `grabcommodityrecords`.`id` AS `flag`, `grabcommodityrecords`.`id`, `grabcommodityrecords`.`grabcommodityid` AS `grabid`, `grabcommodityrecords`.`userid`, `grabcommodityrecords`.`type`, `grabcommodityrecords`.`created_at`, `grabcommodityrecords`.`isgotback`, `grabcommodities`.`isgot`, `grabcommodities`.`picture`, `grabcommodities`.`title`, `grabcommodities`.`version`, `grabcommodities`.`date`, `grabcommodities`.`needed`, `grabcommodities`.`end_at`, `grabcommodities`.`islotteried`, `grabcommodities`.`winnernumber`, `users`.`nickname`, `users`.`phone`, `users`.`thumb` FROM `grabcommodityrecords` INNER JOIN `grabcommodities` ON grabcommodityrecords.grabcommodityid = grabcommodities.id and winnerrecordid = grabcommodityrecords.id INNER JOIN `users` ON grabcommodityrecords.userid = :userid',[':userid'=>$user->id]);
//$query=$cmd->query();
$query = (new \yii\db\Query())->select('*, id as version')->from('activities')->where('userid=:userid', [':userid' => $user->id])->orderBy('end_at desc');
//->orderBy('created_at des');
//var_dump($query);
$dataProvider = new ActiveDataProvider(['query' => $query]);
//$this->load($params);
//$value = 0;
if (!empty($data)) {
if (isset($data['phone'])) {
}
}
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Users::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'directalliancecount' => $this->directalliancecount, 'allalliancecount' => $this->allalliancecount, 'corns' => $this->corns, 'money' => $this->money, 'envelope' => $this->envelope, 'cornsforgrab' => $this->cornsforgrab, 'alliancerewards' => $this->alliancerewards, 'gender' => $this->gender, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'friendcount' => $this->friendcount, 'concerncount' => $this->concerncount, 'isdraw' => $this->isdraw]);
$query->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'pwd', $this->pwd])->andFilterWhere(['like', 'authKey', $this->authKey])->andFilterWhere(['like', 'fatherid', $this->fatherid])->andFilterWhere(['like', 'nickname', $this->nickname])->andFilterWhere(['like', 'thumb', $this->thumb])->andFilterWhere(['like', 'area', $this->area])->andFilterWhere(['like', 'job', $this->job])->andFilterWhere(['like', 'hobby', $this->hobby])->andFilterWhere(['like', 'signature', $this->signature])->andFilterWhere(['like', 'channel', $this->channel])->andFilterWhere(['like', 'platform', $this->platform]);
return $dataProvider;
}
public function actionDelete()
{
$data = Yii::$app->request->post();
if (isset($data['myphone']) && isset($data['concernphone'])) {
$u1 = Users::find()->where(['phone' => $data['myphone']])->one();
$u2 = Users::find()->where(['phone' => $data['concernphone']])->one();
if (!Concerns::findAll(['myid' => $u1['id'], 'concernid' => $u2['id']])) {
return array('flag' => 1, 'msg' => 'is already not concern!');
}
Concerns::deleteAll('myid = :myid and concernid = :concernid', [':myid' => $u1['id'], ':concernid' => $u2['id']]);
$u2->concerncount--;
$u2->save();
return array('flag' => 1, 'msg' => 'delete concern success!');
} else {
return array('flag' => 0, 'msg' => 'arg not enough!');
}
}
public function search($data, $type)
{
if (!(isset($data) && isset($data['phone']) && isset($type))) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
$user = Users::findOne(['phone' => $data['phone']]);
$query = (new \yii\db\Query())->select(['users.phone', 'users.nickname', 'users.thumb', 'users.signature', 'users.concerncount', 'if(isnull(concerns.id),0,1) as isconcerned'])->from('users');
switch ($type) {
case 1:
$query = $query->orderBy('users.concerncount desc')->join('LEFT JOIN', 'concerns', 'concerns.concernid = users.id and concerns.myid = :id', [':id' => $user->id]);
break;
case 2:
$query = $query->orderBy('concerns.created_at desc')->join('INNER JOIN', 'concerns', 'concerns.concernid = users.id and concerns.myid = :id', [':id' => $user->id]);
break;
case 3:
$query = $query->orderBy('concerns.created_at desc')->join('INNER JOIN', 'concerns c', 'c.concernid = :id and c.myid = users.id', [':id' => $user->id])->join('LEFT JOIN', 'concerns', 'concerns.concernid = users.id and concerns.myid = :id', [':id' => $user->id]);
break;
}
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $dataProvider;
}
public function actionList()
{
$data = Yii::$app->request->post();
$query = (new \yii\db\Query())->select('grabcommodityrecords.*,grabcommodities.picture,grabcommodities.title,grabcommodities.id as version,grabcommodities.date,grabcommodities.needed,grabcommodities.end_at,grabcommodities.winnernumber,grabcommodities.islotteried,g2.count as winnercount,users.phone,users.nickname,users.thumb')->from('grabcommodityrecords')->orderBy('grabcommodityrecords.created_at desc')->join('INNER JOIN', 'grabcommodities', 'grabcommodityrecords.grabcommodityid = grabcommodities.id')->join('LEFT JOIN', 'grabcommodityrecords g2', 'grabcommodities.winnerrecordid = g2.id')->join('LEFT JOIN', 'users', 'g2.userid = users.id');
$dataProvider = new ActiveDataProvider(['query' => $query]);
//$this->load($params);
//$value = 0;
if (!empty($data)) {
if (isset($data['phone'])) {
$user = Users::findOne(['phone' => $data['phone']]);
$query->andFilterWhere(['grabcommodityrecords.userid' => $user->id]);
}
// if(isset($data['hobbyid'])){
// $query->andFilterWhere(['hobbyid' => $data['hobbyid']]);
// }
// if(isset($data['content'])){
// $query->andFilterWhere(['like', 'content',$data['content']]);
// }
}
return $dataProvider;
}
public function actionDelete()
{
$data = Yii::$app->request->post();
if (empty($data['phone']) || empty('usertocardid')) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
$user = Users::findOne(['phone' => $data['phone']]);
if (!$user) {
return array('flag' => 0, 'msg' => 'user not exist!');
}
$model = Usertocards::findOne(['id' => $data['usertocardid']]);
if (!$model) {
return array('flag' => 0, 'msg' => 'usertocard not exist!');
}
if ($model['userid'] != $user['id']) {
return array('flag' => 0, 'msg' => 'not the owner!');
}
if ($model->delete()) {
return array('flag' => 1, 'msg' => 'delete success!');
} else {
return array('flag' => 0, 'msg' => 'delete failure!');
}
}
/**
* Deletes an existing Applyjobs model.
* If deletion is successful, the browser will be redirected to the 'index' page.
* @param integer $id
* @return mixed
*/
public function actionDelete()
{
$data = Yii::$app->request->post();
if (!isset($data['phone']) || !isset($data['recommendationcommentid'])) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
$user = Users::findOne(['phone' => $data['phone']]);
$recommendation = $this->findModel($data['recommendationcommentid']);
if (!$recommendation || !$user) {
return array('flag' => 0, 'msg' => 'delete job applying fail!');
}
if ($recommendation->userid == $user->id) {
if ($recommendation->delete()) {
return array('flag' => 1, 'msg' => 'delete recommendation success!');
} else {
return array('flag' => 0, 'msg' => 'delete recommendation fail!');
}
} else {
return array('flag' => 0, 'msg' => 'have no authority!');
}
}
/**
* Finds the Users model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Users the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Users::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionSetchannel()
{
$data = Yii::$app->request->post();
$user = Users::find()->where(['phone' => $data['phone']])->one();
if ($user) {
if ($user . updateChannel($data['channel'])) {
return array('flag' => 1, 'msg' => 'update user channel success');
} else {
return array('flag' => 0, 'msg' => 'update user channel fail');
}
} else {
return array('flag' => 0, 'msg' => 'can not find the user');
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFrom()
{
return $this->hasOne(Users::className(), ['id' => 'fromid']);
}
public function actionChangetocorns()
{
$data = Yii::$app->request->post();
if (!(isset($data['phone']) && isset($data['grabcommodityid']))) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
//Users::findOne(['phone'=>$data['phone']])
$grabcommodity = Grabcorns::findOne(['id' => $data['grabcommodityid']]);
if (!$grabcommodity) {
return array('flag' => 0, 'msg' => 'activity not exist!');
}
$user = Users::findOne(['phone' => $data['phone']]);
if (!$user) {
return array('flag' => 0, 'msg' => 'find user fail!');
}
if ($grabcommodity->winneruserid != $user->id) {
return array('flag' => 0, 'msg' => 'you are not the winner!');
}
if ($grabcommodity->isgot != 0) {
return array('flag' => 0, 'msg' => 'you has got the corn!');
}
$connection = Yii::$app->db;
$transaction = $connection->beginTransaction();
$updategrab = 0;
try {
//$worth = intval($grabcommodity->worth * 0.9);
$updategrab = $connection->createCommand('update grabcommodities g1,users u1 set g1.isgot=1,u1.corns=u1.corns+g1.worth where g1.id=:id and u1.id = g1.winneruserid', [':id' => $data['grabcommodityid']])->execute();
if (!$updategrab) {
throw new Exception("Value must be 1 or below");
}
// ... executing other SQL statements ...
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
//var_dump($e->getMessage());
//Yii::$app->log->logger->
return array('err' => $e, 'flag' => 0, 'msg' => 'get grabcommodity fail!');
}
return array('c' => $updategrab, 'flag' => 1, 'msg' => 'get grabcommodity success!');
}
public function setFather($fid)
{
//$result=$this->find()->select()->join('INNER JOIN','users u1',['u1.phone'=>$fatherphone])->join('LEFT JOIN','users u2','u3.phone = u1.fatherid')->join('Left JOIN','users u3','u3.phone = u2.fatherid')->one();
$f = Users::findOne(['id' => $fid]);
// if($f['status']!=2){
// return true;
// }
$result = (new \yii\db\Query())->select('u1.id as f, u2.id as gf ,u3.id as ggf')->from('users u1')->where('u1.id=:id', [':id' => $fid])->join('LEFT JOIN', 'users u2', 'u2.id = u1.fatherid')->join('Left JOIN', 'users u3', 'u3.id = u2.fatherid')->one();
// var_dump($result);
// return true;
if ($result) {
$this->fatherid = strval($fid);
Users::updateAllCounters(['directalliancecount' => 1, 'allalliancecount' => 1], ['id' => $result['f']]);
Users::updateAllCounters(['allalliancecount' => 1], ['id' => $result['gf']]);
Users::updateAllCounters(['allalliancecount' => 1], ['id' => $result['ggf']]);
return true;
} else {
return false;
}
}
public function actionDelete()
{
$data = Yii::$app->request->post();
if (!isset($data['phone']) || !isset($data['tbotherid'])) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
$user = Users::findOne(['phone' => $data['phone']]);
$model = $this->findModel($data['tbotherid']);
if (!$model || !$user) {
return array('flag' => 0, 'msg' => 'delete fail!');
}
if ($model->userid == $user->id) {
if ($model->delete()) {
return array('flag' => 1, 'msg' => 'delete success!');
} else {
return array('flag' => 0, 'msg' => 'delete fail!');
}
} else {
return array('flag' => 0, 'msg' => 'have no authority!');
}
}
public function actionReply()
{
$data = Yii::$app->request->post();
//$user=new Users();
$fromphone = Users::find()->select('id')->where(['phone' => $data['fphone']])->one();
//var_dump($fromphone);
$model = new Tbreplys();
if ($data['tphone'] == '') {
$model->toid = 0;
} else {
$tophone = Users::find()->select('id')->where(['phone' => $data['tphone']])->one();
//var_dump($tophone);
$model->toid = $tophone['id'];
}
// $to=Messages::findOne(['id'=>$data['msgid']]);
// if($fromphone['id']!=$to['id']){
// $model3=new Notify();
// $model3->from=$fromphone['id'];
// $model3->to=$to['userid'];
// //$model3->kind='评论';
// $model3->kind=$data['content'];
// $model3->created_at=time();
// $model3->msg_id=$data['msgid'];
// if(!$model3->save()){
// echo json_encode ( array (
// 'flag' => 0,
// 'msg' => 'Reply failed!'
// ));
// return;
// }
// }
$model->fromid = $fromphone['id'];
$model->tbmessageid = $data['tbmessageid'];
$model->content = $data['content'];
$model->isread = 0;
$model->created_at = time();
//var_dump($model);
$tbmessage = $this->findModel($data['tbmessageid']);
$connection = Yii::$app->db;
$transaction = $connection->beginTransaction();
try {
if (!$model->save()) {
throw new Exception("dsfgsdfg");
}
$tbmessage->replycount++;
if (!$tbmessage->save()) {
throw new Exception("asdfgsdfg");
}
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
//var_dump("133435465");
//Yii::$app->log->logger->
return array('flag' => 0, 'msg' => 'Reply fail!');
}
return array('flag' => 1, 'msg' => 'Reply success!');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMy()
{
return $this->hasOne(Users::className(), ['id' => 'myid']);
}
public function actionReply()
{
$data = Yii::$app->request->post();
//$user=new Users();
$fromphone = Users::find()->select('id')->where(['phone' => $data['fphone']])->one();
//var_dump($fromphone);
$model = new Replys();
if ($data['tphone'] == '') {
$model->toid = 0;
} else {
$tophone = Users::find()->select('id')->where(['phone' => $data['tphone']])->one();
//var_dump($tophone);
$model->toid = $tophone['id'];
}
// $to=Messages::findOne(['id'=>$data['msgid']]);
// if($fromphone['id']!=$to['id']){
// $model3=new Notify();
// $model3->from=$fromphone['id'];
// $model3->to=$to['userid'];
// //$model3->kind='评论';
// $model3->kind=$data['content'];
// $model3->created_at=time();
// $model3->msg_id=$data['msgid'];
// if(!$model3->save()){
// echo json_encode ( array (
// 'flag' => 0,
// 'msg' => 'Reply failed!'
// ));
// return;
// }
// }
$model->fromid = $fromphone['id'];
$model->messageid = $data['messageid'];
$model->content = $data['content'];
$model->isread = 0;
$model->created_at = time();
//var_dump($model);
if ($model->save()) {
return array('flag' => 1, 'msg' => 'Reply success!');
} else {
return array('flag' => 0, 'msg' => 'Reply failed!');
}
}
public function actionGetback()
{
$data = Yii::$app->request->post();
if (!(isset($data['phone']) && isset($data['grabcornid']))) {
return array('flag' => 0, 'msg' => 'no enough arg!');
}
//Users::findOne(['phone'=>$data['phone']])
$grabcorn = Grabcorns::findOne(['id' => $data['grabcornid']]);
if (!$grabcorn) {
return array('flag' => 0, 'msg' => 'activity not exist!');
}
$user = Users::findOne(['phone' => $data['phone']]);
if (!$user) {
return array('flag' => 0, 'msg' => 'find user fail!');
}
// if($grabcorn->winneruserid !=$user->id){
// return array (
// 'flag' => 0,
// 'msg' => 'you are not the winner!'
// );
// }
// if($grabcorn->isgot !=0){
// return array (
// 'flag' => 0,
// 'msg' => 'you has got the corn!'
// );
// }
$back = 0;
$back = (new \yii\db\Query())->select('SUM(grabcornrecords.count) as back')->from('grabcornrecords')->where('grabcornrecords.userid = :userid and grabcornrecords.grabcornid = :id and grabcornrecords.isgotback=0', [':id' => $data['grabcornid'], ':userid' => $user->id])->one();
$back = $back['back'];
$connection = Yii::$app->db;
$transaction = $connection->beginTransaction();
$updategrab = 0;
try {
$updategrab = $connection->createCommand('update grabcornrecords g1 set g1.isgotback=1 where g1.grabcornid = :id and g1.userid = :userid', [':id' => $data['grabcornid'], ':userid' => $user->id])->execute();
$updateuser = $connection->createCommand('update users u1 set u1.money = u1.money + :back where u1.id=:id', [':id' => $user->id, ':back' => intval($back * 0.9)])->execute();
if (!$updateuser) {
throw new Exception("Value must be 1 or below");
}
$trade = new Traderecords();
$trade->userid = $user['id'];
$trade->type = 4;
$trade->description = '自己人联盟提前保本';
$trade->cardid = 0;
$trade->count = intval($back * 0.9);
$trade->ishandled = 0;
$trade->created_at = time();
if (!$trade->save()) {
throw new Exception("Value must be 1 or below");
}
// ... executing other SQL statements ...
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
//var_dump($e->getMessage());
//Yii::$app->log->logger->
return array('flag' => 0, 'msg' => 'get corn fail!');
}
return array('flag' => 1, 'msg' => 'get corn success!');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getUser()
{
return $this->hasOne(Users::className(), ['id' => 'userid']);
}
public function actionDelete()
{
$data = Yii::$app->request->post();
if (isset($data['myphone']) && isset($data['friendphone'])) {
$u1 = Users::find()->where(['phone' => $data['myphone']])->one();
$u2 = Users::find()->where(['phone' => $data['friendphone']])->one();
if (!Friends::findAll(['myid' => $u1['id'], 'friendid' => $u2['id']]) && !Friends::findAll(['myid' => $u2['id'], 'friendid' => $u1['id']])) {
return array('flag' => 0, 'msg' => 'is already not friend!');
}
Friends::deleteAll('myid = :myid and friendid = :friendid or myid = :friendid and friendid = :myid', [':myid' => $u1['id'], ':friendid' => $u2['id']]);
$easeclient = new Easeapi('YXA6halokJDEEeWMRgvYONLZPQ', 'YXA6pswnZbss8mj351XE3oxuRYm6cek', '13022660999', 'allpeopleleague', 'file');
$result = json_decode($easeclient->curl('/users/' . $u1->id . '/contacts/users/' . $u2->id, '', 'DELETE'), true);
return array('flag' => 1, 'msg' => 'delete friend success!');
} else {
return array('flag' => 0, 'msg' => 'arg not enough!');
}
}
