public function search($params) { $query = MUser::find(); $query->joinWith('openidBindMobiles'); // $query->select('*'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $this->gh_id = Yii::$app->user->getGhid(); $this->addCondition($query, 'wx_user.gh_id'); if (!Yii::$app->user->getIsAdmin()) { $office = Yii::$app->user->identity; $scene_ids = $office->getSceneids(); $query->andWhere(['scene_pid' => $scene_ids]); } $query->andWhere(['subscribe' => 1]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $this->addCondition($query, 'id'); $this->addCondition($query, 'nickname', true); $this->addCondition($query, 'status'); $this->addCondition($query, 'update_time'); $this->addCondition($query, 'scene_pid'); $this->addCondition($query, 'is_liantongstaff'); $query->andFilterWhere(['like', 'wx_openid_bind_mobile.mobile', $this->mobile]); if (!empty($this->office_id)) { $office = MOffice::findOne($this->office_id); if (!empty($office)) { $query->andFilterWhere(['scene_pid' => $office->getSceneids()]); } } if (trim($this->create_time) !== '') { $query->andWhere('date(wx_user.create_time)>=:create_time', [':create_time' => $this->create_time]); } if (trim($this->create_time_2) !== '') { $query->andWhere('date(wx_user.create_time)<=:create_time_2', [':create_time_2' => $this->create_time_2]); } return $dataProvider; }
public static function confirmAjax($office_id, $cat) { $office = MOffice::findOne(['office_id' => $office_id]); if (empty($office)) { $score = 0; } else { $score = $office->score; } if ($cat == self::CAT_30YUAN_DAIJINJUAN) { $dh_score = self::CAT_30YUAN_DAIJINJUAN_SCORE; } else { if ($cat == self::CAT_100YUAN_DAIJINJUAN) { $dh_score = self::CAT_100YUAN_DAIJINJUAN_SCORE; } else { $dh_score = self::CAT_30YUAN_DAIJINJUAN_SCORE; } } if ($score < $dh_score) { U::W("----------score not enough--------"); return \yii\helpers\Json::encode(['code' => 1]); } else { $office_score_event = new MOfficeScoreEvent(); $office_score_event->gh_id = 'gh_03a74ac96138'; $office_score_event->openid = ''; $office_score_event->office_id = $office_id; $office_score_event->cat = $cat; $office_score_event->score = $dh_score; $office_score_event->memo = self::getCatNameOption($cat); $office_score_event->status = 0; $office_score_event->code = ''; $office_score_event->create_time = date('y-m-d h:i:s', time()); $office_score_event->save(false); $office = MOffice::findOne(['office_id' => $office_id]); $office->score = $office->score - $dh_score; $office->save(false); } return \yii\helpers\Json::encode(['code' => 0]); }
public function actionOfficewb($filename = 'office-wb.csv') { //$xyunicom = \app\models\WosoClient::findOne(['title_abbrev' => '襄阳联通']); //if (empty($xyunicom)) die('不能找到襄阳联通。'); //gh_id,branch,region,title,address,manager,member_cnt,mobile //$filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . $filename; $filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'imported_data' . DIRECTORY_SEPARATOR . $filename; $fh = fopen($filepathname, "r"); while (!feof($fh)) { $line = trim(fgets($fh)); if (empty($line) || strlen($line) == 0) { continue; } //襄阳,樊城,襄阳市城区家客樊东网格逐日电子,李孔恒,13177226622 $fields = explode(",", $line); $branch = trim($fields[0]); $branch_utf8 = iconv('GBK', 'UTF-8//IGNORE', $branch); $region = trim($fields[1]); $region_utf8 = iconv('GBK', 'UTF-8//IGNORE', $region); $title = trim($fields[2]); $title_utf8 = iconv('GBK', 'UTF-8//IGNORE', $title); $manager = trim($fields[3]); $manager_utf8 = iconv('GBK', 'UTF-8//IGNORE', $manager); $mobile = trim($fields[4]); $mobile_utf8 = iconv('GBK', 'UTF-8//IGNORE', $mobile); $office = MOffice::findOne(['title' => $title_utf8]); if (empty($office)) { echo $title_utf8 . "\t\t" . "insert ... \n"; $office = new MOffice(); $office->gh_id = \app\models\MGh::GH_XIANGYANGUNICOM; // 襄阳联通公共ID $office->branch = $branch_utf8; $office->region = $region_utf8; $office->title = $title_utf8; $office->manager = $manager_utf8; $office->mobile = $mobile_utf8; $office->save(false); } else { echo $title_utf8 . "\t\t" . "update ...\n"; $office->branch = $branch_utf8; $office->region = $region_utf8; $office->title = $title_utf8; $office->manager = $manager_utf8; $office->mobile = $mobile_utf8; $office->save(false); } //echo $branch_utf8."\t".$region_utf8."\t".$title_utf8."\t".$manager_utf8."\t".$mobile_utf8."\n"; } fclose($fh); echo "done\n"; }
public function getQrImageUrl2() { $gh_id = $this->gh_id; if (empty($this->scene_id)) { // hbhe if (yii::$app->mutex->acquire(MStaff::SCENE_LOCK, MStaff::SCENE_LOCK_WAIT_TIME_SECOND)) { $this->scene_id = MStaff::newSceneId($this->gh_id); $this->save(false); //yii::$app->mutex->release($lock); yii::$app->mutex->release(MStaff::SCENE_LOCK); } else { yii::error('acquire lock error'); } } $scene_id = $this->scene_id; $office_id = $this->office_id; $office = MOffice::findOne(['office_id' => $office_id]); $office_title = $office->title; //$log_file_path = Yii::$app->getRuntimePath().DIRECTORY_SEPARATOR.'qr'.DIRECTORY_SEPARATOR."{$gh_id}_{$scene_id}.jpg"; $log_file_path = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'qr-all-offices' . DIRECTORY_SEPARATOR . "{$scene_id}_{$office_title}.jpg"; if (!file_exists($log_file_path) || filesize($log_file_path) == 0) { Yii::$app->wx->setGhId($gh_id); $arr = Yii::$app->wx->WxgetQRCode($scene_id, true); $url = Yii::$app->wx->WxGetQRUrl($arr['ticket']); Wechat::downloadFile($url, $log_file_path); } //$url = Yii::$app->getRequest()->baseUrl."/../runtime/qr/{$gh_id}_{$scene_id}.jpg"; //return $url; }
protected function findOfficeModel($id) { if (($model = MOffice::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function actionMetronic($office_id = 0) { $this->layout = 'metronic'; if (\Yii::$app->user->isAdmin) { if (0 !== $office_id) { $office = \app\models\MOffice::findOne(['office_id' => $office_id]); } else { $office = null; } } else { if (\Yii::$app->user->isOffice) { $office = \Yii::$app->user->identity; } } return $this->render('blank', ['target_office' => $office]); }
public function actionProfile() { $user = MOffice::findOne(Yii::$app->user->id); // if (is_numeric(Yii::$app->user->identity->openid)) // $office = MOffice::findOne(Yii::$app->user->identity->openid); if ($user->load(Yii::$app->request->post())) { if ($user->save(false, ['pswd'])) { Yii::$app->session->setFlash('success', '设置成功!'); return $this->refresh(); } else { U::W($user->getErrors()); } } return $this->render('profile', ['model' => $user]); }
public function getOutlet() { if ($this->belongto === 0) { return null; } $office = MOffice::findOne(['office_id' => $this->belongto]); return $office->outlet; }
<h1><?php echo Html::encode($this->title); ?> </h1> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <p> <?php echo Html::a('新增消息', ['create'], ['class' => 'btn btn-success']); ?> </p> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => ['msg_id', 'title', 'digest', 'author', ['attribute' => 'receiver_type', 'value' => function ($model, $key, $index, $column) { return Messagebox::getReceiverTypeOptionName($model->receiver_type); }, 'filter' => Messagebox::getReceiverTypeOptionName()], ['attribute' => 'receiver', 'value' => function ($model, $key, $index, $column) { $office = MOffice::findOne(['office_id' => $model->receiver]); if ($model->receiver_type == 0) { /*经销商*/ return '--'; } else { return $office->title; } }], ['class' => 'yii\\grid\\ActionColumn']]]); ?> </div>
public function actionGroupmember($filename = 'groupmember.csv') { //$xyunicom = \app\models\WosoClient::findOne(['title_abbrev' => '襄阳联通']); //if (empty($xyunicom)) die('不能找到襄阳联通。'); $filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . $filename; $fh = fopen($filepathname, "r"); while (!feof($fh)) { $line = trim(fgets($fh)); if (empty($line) || strlen($line) == 0) { continue; } $fields = explode(",", $line); $mobile = trim($fields[0]); $mobile_utf8 = iconv('GBK', 'UTF-8//IGNORE', $mobile); $office_title = trim($fields[1]); $office_title_utf8 = iconv('GBK', 'UTF-8//IGNORE', $office_title); $bind = OpenidBindMobile::findOne(['mobile' => $mobile]); if (!empty($bind)) { $user = MUser::findOne(['openid' => $bind->openid]); if (!empty($user)) { $office = MOffice::findOne(['title' => $office_title_utf8]); if (!empty($office)) { $user->belongto = $office->office_id; $user->save(false); } } } echo "done\n"; } fclose($fh); }
public static function getScore($office_id, $date = null) { $pic_categories = MOfficeCampaignPicCategory::find()->all(); $office = \app\models\MOffice::findOne(['office_id' => $office_id]); $total = 0; foreach ($pic_categories as $pic_category) { if (!$office->is_selfOperated && $pic_category->sort_order == 6) { continue; } $scores = self::getScoreByPicCategory($office_id, $pic_category->id, $date); if ($scores['count'] == 0) { return false; } $total += $scores['count'] == 1 ? $scores['total'] : $scores['total'] / $scores['count']; } return $total; }
public function actionAddbindmobile($gh_id, $openid) { $this->layout = 'wap'; $model = new OpenidBindMobile(); $model->gh_id = $gh_id; $model->openid = $openid; $model->setScenario('bind_mobile'); if ($model->load(Yii::$app->request->post()) && $model->save()) { //非自营厅渠道新增会员时,+积分100 $user = MUser::findOne(['openid' => $openid]); $office = MOffice::findOne(['office_id' => $user->belongto]); if (!empty($office)) { if ($office->is_selfOperated == 0) { //wx_office_score_event 增加一条记录 $offce_score_event = new MOfficeScoreEvent(); $offce_score_event->gh_id = $gh_id; $offce_score_event->openid = $openid; $offce_score_event->office_id = $user->belongto; $offce_score_event->cat = MOfficeScoreEvent::CAT_ADD_NEW_MEMBER; $offce_score_event->create_time = date('y-m-d h:i:s', time()); $offce_score_event->score = MOfficeScoreEvent::CAT_ADD_NEW_MEMBER_SCORE; $offce_score_event->memo = '新增会员'; $offce_score_event->save(false); //wx_office表中对应渠道score 加100分 $office->score = $office->score + 100; $office->save(false); } } Yii::$app->wx->setGhId($gh_id); $url = Url::to(['hyzx1', 'gh_id' => $gh_id, 'openid' => $openid], true); Yii::$app->wx->WxTemplateSend(Wechat::getTemplateBindSuccessNotify($openid, $url, "{$model->user->nickname},您的手机号码已成功绑定襄阳联通官方微信营业厅", "您已成为襄阳联通的会员,可随时查询话费余额,办理业务,参与更多专享优惠!", $model->mobile, date('Y-m-d'))); $url = Yii::$app->getSession()->get('RETURN_URL'); if (!empty($url)) { return $this->redirect($url); } else { Yii::$app->session->setFlash('success', '恭喜您,会员注册成功!'); return $this->refresh(); } } $searchModel = new OpenidBindMobileSearch(); $searchModel->gh_id = $gh_id; $searchModel->openid = $openid; $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('addbindmobile', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]); }
public function actionOrder($filename = 'order.csv', $date = null) { $filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'exported_data' . DIRECTORY_SEPARATOR . $filename; $fh = fopen($filepathname, 'w'); if (null === $date) { $date = \app\models\U::getFirstDate(date('Y'), date('m')); } $total_count = \app\models\MOrder::find()->where(['>', 'create_time', $date])->count(); //$total_count = \app\models\MUser::find()->count(); $step = 300; $start = 0; while ($start < $total_count) { $orders = \app\models\MOrder::find()->offset($start)->limit($step)->where(['>', 'create_time', $date])->orderBy(['create_time' => SORT_ASC])->all(); fprintf($fh, "营业厅, 订单号, 商品, 价格, 订单时间, 身份证, 用户姓名, 联系电话, 支付方式, 订单状态, 开通, 备注, 用户类型\n"); foreach ($orders as $order) { $office = \app\models\MOffice::findOne(['office_id' => $order->office_id]); if (!empty($office)) { $office_title = $office->title; } else { $office_title = ""; } $user = \app\models\MUser::findOne(['openid' => $order->openid]); $customerFlag = '--'; /* if ($user->bindMobileIsInside('wx_t1')) { $customerFlag = '老'; } elseif ($user->bindMobileIsInside('wx_t2')) { $customerFlag = '老'; }elseif ($user->bindMobileIsInside('wx_t3')) { $customerFlag = '老'; } else { $customerFlag = '新'; } */ if ($user->bindMobileIsInside('wx_oldcustomer')) { $customerFlag = '老'; } else { $customerFlag = '新'; } $pay_kind = \app\models\MOrder::getOrderPayKindOption($order->pay_kind); $price = $order->feesum / 100; $paystatus = \app\models\MOrder::getOrderStatusName($order->status); //echo $office_title."\t".$order->oid."\t".$order->title."\t".$price."\t".$order->create_time."\t".$order->userid."\t".$order->username."\t".$order->usermobile."\t".$pay_kind."\t".$order->memo."\t".$order->customerFlag."\t\n"; fprintf($fh, "%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s\n", $office_title, $order->oid, $order->title, $price, $order->create_time, $order->userid, $order->username, $order->usermobile, $pay_kind, $paystatus, $order->kaitong, $order->memo, $order->customerFlag); } $start += $step; } fclose($fh); }
public static function getDetailReadyStatus($office_id, $date = null) { $start_date = \app\models\utils\OfficeCampaignUtils::getOfficeCampaignBeginDate($date); $end_date = \app\models\utils\OfficeCampaignUtils::getOfficeCampaignEndDate($date); $pic_categories = MOfficeCampaignPicCategory::find()->all(); $office = \app\models\MOffice::findOne(['office_id' => $office_id]); $category_count = 0; $detail_count = 0; foreach ($pic_categories as $pic_category) { if (!$office->is_selfOperated && $pic_category->sort_order == 6) { continue; } $category_count++; $detail = self::find()->andWhere(['office_id' => $office_id, 'pic_category' => $pic_category->id])->andWhere('created_time >= :start_time', [':start_time' => $start_date->format("Y-m-d H:i:s")])->andWhere('created_time < :end_time', [':end_time' => $end_date->format("Y-m-d H:i:s")])->one(); if (!empty($detail)) { $detail_count++; } } if ($category_count == $detail_count) { return self::DETAIL_COMPLETE; } if ($detail_count == 0) { return self::DETAIL_IMCOMPLETE; } else { return self::DETAIL_PARTIALLY; } }
<//?= $form->field($model, 'score')->textInput() ?> <//?= $form->field($model, 'memo')->textInput(['maxlength' => 128]) ?> <//?= $form->field($model, 'code')->textInput(['maxlength' => 64]) ?> --> <!-- <//?= $form->field($model, 'status')->textInput() ?> --> <br><br> <?php $office = MOffice::findOne(["office_id" => $model->office_id]); if (empty($office)) { $title = "--"; } else { $title = $office->title; } echo "<h1>渠道名称: " . $title . "</h1>"; echo "<h3>代金卷: " . MOfficeScoreEvent::getCatNameOption($model->cat) . "</h3>"; echo "<h3>减积分: " . $model->score . "</h3>"; echo "<h3>时间: " . $model->create_time . "</h3>"; ?> <br> <?php echo $form->field($model, 'status')->dropDownList(MOfficeScoreEvent::getOseStatusOption());
public static function closeExpiredOrders() { $tableName = MOrder::tableName(); $n = Yii::$app->db->createCommand()->delete($tableName, 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_DRAFT])->execute(); U::W("UPDATE {$tableName}, {$n} --- 系统删除2天前的僵死订单。"); // auto close the orders exceed 2 days $n = Yii::$app->db->createCommand()->update($tableName, ['status' => MOrder::STATUS_SYSTEM_CLOSED], 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_SUBMITTED])->execute(); U::W("UPDATE {$tableName}, {$n} --- 系统自动关闭超时2天的提交订单。"); $n = Yii::$app->db->createCommand()->update($tableName, ['status' => MOrder::STATUS_SYSTEM_SUCCEEDED], 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_FULFILLED])->execute(); U::W("UPDATE {$tableName}, {$n} --- 系统自动确认超时2天的已办理订单。"); //找到超时2天的成功订单, 将其归属的渠道 +积分100 $orders = MOrder::find()->where(['status' => MOrder::STATUS_FULFILLED])->andWhere(['<', 'create_time', 'DATE_SUB(NOW(), INTERVAL 2 day)'])->all(); foreach ($orders as $order) { $user = MUser::findOne(['openid' => $order->openid]); $office = MOffice::findOne(['office_id' => $user->belongto]); if ($office->is_selfOperated == 0) { //wx_office_score_event 增加一条记录 $offce_score_event = new MOfficeScoreEvent(); $offce_score_event->gh_id = $order->gh_id; $offce_score_event->openid = $order->openid; $offce_score_event->office_id = $user->belongto; $offce_score_event->cat = MOfficeScoreEvent::CAT_ADD_ORDER; $offce_score_event->create_time = date('y-m-d h:i:s', time()); $offce_score_event->score = MOfficeScoreEvent::CAT_ADD_ORDER_SCORE; $offce_score_event->memo = '会员订单'; $offce_score_event->save(false); //wx_office表中对应渠道score 加100分 $office->score = $office->score + 100; $office->save(false); } } /* //move the unsuccessful orders exceed 90 days to bak table $n = Yii::$app->db->createCommand("INSERT INTO {$tableName}_arc SELECT * FROM $tableName WHERE status!=:status AND create_time < DATE_SUB(NOW(), INTERVAL 90 day)", [':status'=>MOrder::STATUS_OK])->execute(); U::W("INSERT $tableName, $n"); $n = Yii::$app->db->createCommand("DELETE FROM $tableName WHERE status!=:status AND create_time < DATE_SUB(NOW(), INTERVAL 90 day)", [':status'=>MOrder::STATUS_OK])->execute(); U::W("DELETE $tableName, $n"); */ //release mobile number $tableName = MMobnum::tableName(); $n = Yii::$app->db->createCommand()->update($tableName, ['status' => MMobnum::STATUS_UNUSED, 'locktime' => 0], 'status=:status AND locktime < :locktime', [':status' => MMobnum::STATUS_LOCKED, ':locktime' => time() - 2 * 24 * 3600])->execute(); U::W("UPDATE {$tableName}, {$n}"); $n = Yii::$app->db->createCommand("DELETE FROM {$tableName} WHERE status=:status", [':status' => MMobnum::STATUS_USED])->execute(); U::W("DELETE {$tableName}, {$n}"); }
protected function onTextOld() { $openid = $this->getRequest('FromUserName'); $gh_id = $this->getRequest('ToUserName'); while (1) { $Content = $this->getRequest('Content'); $msg = trim($Content); $state = $this->getState($gh_id, $openid); if ($msg == '0' && $state != self::STATE_NONE) { U::W('deleteState'); $this->deleteState($gh_id, $openid); return $this->responseText("谢谢,再见!"); } U::W($state); switch ($state) { case self::STATE_NONE: //if ($msg !== 'Xy') if ($msg == 'New') { $url = Url::to(['wapx/staffsearch', 'gh_id' => $gh_id, 'openid' => $openid], true); return $this->responseText("see my score? <a href=\"{$url}\">click me</a>"); } else { if ($msg == '.debug') { $url = Url::to(['wapx/staffsearch', 'gh_id' => $gh_id, 'openid' => $openid], true); return $this->responseText("see my score? <a href=\"{$url}\">click me</a>"); } } if ($msg !== 'Xy') { //return Wechat::NO_RESP; $model = MUser::findOne(['gh_id' => $gh_id, 'openid' => $openid]); $items = array(new RespNewsItem("{$model->nickname}, 欢迎进入襄阳联通官方微信营业厅", '猛戳进入首页!', Url::to('images/metro-intro.jpg', true), Url::to(['wap/home', 'gh_id' => $gh_id, 'openid' => $openid], true))); return $this->responseNews($items); } $model = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if ($model === null) { $this->setState($gh_id, $openid, self::STATE_MOBILE); return $this->responseText("请输入手机号, 0:退出"); } else { if (empty($model->office_id)) { $this->setState($gh_id, $openid, self::STATE_OFFICE); return $this->responseText($this->getOfficePrompt($gh_id)); } else { $this->setState($gh_id, $openid, self::STATE_MENU_ONE); return $this->responseText(self::PROMPT_MENU_ONE); } } break; case self::STATE_MOBILE: if (!is_numeric($msg) || substr($msg, 0, 1) !== '1' || strlen($msg) != 11) { return $this->responseText("无效的手机号!\n\n" . "请重新输入手机号, 0:退出"); } $model = MStaff::findOne(['mobile' => $msg]); if ($model === null) { return $this->responseText("非襄阳联通员工手机号!\n\n" . "请重新输入手机号, 0:退出"); } $model->gh_id = $gh_id; $model->openid = $openid; $model->save(false); if (empty($model->office_id)) { $this->setState($gh_id, $openid, self::STATE_OFFICE); $str = $this->getOfficePrompt($gh_id); return $this->responseText("{$model->name},您好!\n,{$str}"); } else { $this->setState($gh_id, $openid, self::STATE_MENU_ONE); return $this->responseText(self::PROMPT_MENU_ONE); } case self::STATE_OFFICE: //$offices =MOffice::find()->where(['gh_id'=>$gh_id])->asArray()->all(); $offices = MOffice::find()->where("gh_id = '{$gh_id}' AND office_id <=25 ")->asArray()->all(); $office_ids = []; foreach ($offices as $office) { $office_ids[] = $office['office_id']; } if (!is_numeric($msg) || $msg < 0 || !in_array($msg, $office_ids)) { return $this->responseText("无效的部门号!\n\n" . $this->getOfficePrompt($gh_id)); } $model = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); $model->office_id = $msg; $model->save(false); $this->setState($gh_id, $openid, self::STATE_MENU_ONE); return $this->responseText(self::PROMPT_MENU_ONE); case self::STATE_CHANGE_MOBILE: if (!is_numeric($msg) || substr($msg, 0, 1) !== '1' || strlen($msg) != 11) { return $this->responseText("无效的手机号!\n\n" . "请重新输入手机号, 0:退出"); } $model = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); $model->mobile = $msg; $model->save(false); $this->setState($gh_id, $openid, self::STATE_MENU_ONE); return $this->responseText(self::PROMPT_MENU_ONE); case self::STATE_MENU_ONE: if (!is_numeric($msg) || $msg < 0 || $msg > 7) { return $this->responseText("输入无效!\n\n" . self::PROMPT_MENU_ONE); } switch ($msg) { case 1: //U::W('enter 111111'); $model = MUser::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if (empty($model->scene_id)) { $gh = MGh::findOne($gh_id); $scene_id = $gh->newSceneId(); $gh->save(false); $model->scene_id = $scene_id; $model->save(false); //U::W("new a scene_id=$scene_id"); } else { $scene_id = $model->scene_id; //U::W("old scene_id=$scene_id"); } $log_file_path = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'qr' . DIRECTORY_SEPARATOR . "{$gh_id}_{$scene_id}.jpg"; //U::W($log_file_path); if (!file_exists($log_file_path)) { $arr = $this->WxgetQRCode($scene_id, true); $url = $this->WxGetQRUrl($arr['ticket']); Wechat::downloadFile($url, $log_file_path); } //$url = Url::to(['wap/aboutqr','name'=>$model->nickname, 'qrurl'=>Yii::$app->getRequest()->baseUrl."/../runtime/qr/{$gh_id}_{$scene_id}.jpg"],true); $url = "http://mp.weixin.qq.com/s?__biz=MzA4ODkwOTYxMA==&mid=203659175&idx=1&sn=0efaf2269fb7ba6a022f5c31d0d5e255#rd"; //U::W($url); $msg = ['touser' => $openid, 'msgtype' => 'text', 'text' => ['content' => "如何使用个人的二维码? <a href=\"{$url}\">点击这里...</a>"]]; $arr = $this->WxMessageCustomSend($msg); return $this->responseLocalImage('image', $log_file_path); case 2: $model = MUser::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if ($model->scene_id == 0) { $count = 0; } else { $count = MUser::find()->where(['gh_id' => $gh_id, 'scene_pid' => $model->scene_id])->count(); } return $this->responseText("你的推广人数是:{$count}\n\n" . self::PROMPT_MENU_ONE); case 3: $staff = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if (empty($staff->office_id)) { $this->setState($gh_id, $openid, self::STATE_OFFICE); return $this->responseText($this->getOfficePrompt($gh_id)); } $model = MOffice::findOne($staff->office_id); if ($model === null) { $this->setState($gh_id, $openid, self::STATE_OFFICE); $str = $this->getOfficePrompt($gh_id); return $this->responseText("invalid office id\n,{$str}"); } if (empty($model->scene_id)) { $gh = MGh::findOne($gh_id); $scene_id = $gh->newSceneId(); $gh->save(false); $model->scene_id = $scene_id; $model->save(false); U::W("scene_id={$scene_id}"); } else { $scene_id = $model->scene_id; } $log_file_path = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'qr' . DIRECTORY_SEPARATOR . "{$gh_id}_{$scene_id}.jpg"; //U::W($log_file_path); if (!file_exists($log_file_path)) { $arr = $this->WxgetQRCode($scene_id, true); $url = $this->WxGetQRUrl($arr['ticket']); Wechat::downloadFile($url, $log_file_path); } //$msg = ['touser'=>$openid, 'msgtype'=>'text', 'text'=>['content'=>'如何使用部门的二维码? <a href="http://baidu.com">点击这里...</a>']]; //$url = Url::to(['wap/aboutqr','name'=>$model->title, 'qrurl'=>Yii::$app->getRequest()->baseUrl."/../runtime/qr/{$gh_id}_{$scene_id}.jpg"],true); $url = "http://mp.weixin.qq.com/s?__biz=MzA4ODkwOTYxMA==&mid=203659175&idx=1&sn=0efaf2269fb7ba6a022f5c31d0d5e255#rd"; $msg = ['touser' => $openid, 'msgtype' => 'text', 'text' => ['content' => "如何使用部门的二维码? <a href=\"{$url}\">点击这里...</a>"]]; $arr = $this->WxMessageCustomSend($msg); return $this->responseLocalImage('image', $log_file_path); case 4: $staff = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if (empty($staff->office_id)) { $this->setState($gh_id, $openid, self::STATE_OFFICE); return $this->responseText($this->getOfficePrompt($gh_id)); } $model = MOffice::findOne($staff->office_id); if ($model === null) { $this->setState($gh_id, $openid, self::STATE_OFFICE); $str = $this->getOfficePrompt($gh_id); return $this->responseText("invalid office id\n,{$str}"); } if ($model->scene_id == 0) { $count = 0; } else { $count = MUser::find()->where(['gh_id' => $gh_id, 'scene_pid' => $model->scene_id])->count(); } //U::W($user->office_id); //U::W('a1111111111'); $staffs = MStaff::find()->where(['gh_id' => $gh_id, 'office_id' => $staff->office_id])->asArray()->all(); $openids = []; //U::W($staffs); foreach ($staffs as $staff) { if (!empty($staff['openid'])) { $openids[] = $staff['openid']; } } if (empty($openids)) { $staff_count = 0; } else { $users = MUser::find()->where(['gh_id' => $gh_id, 'openid' => $openids])->asArray()->all(); $scene_ids = []; foreach ($users as $user) { if ($user['scene_id'] != 0) { $scene_ids[] = $user['scene_id']; } } if (empty($scene_ids)) { $staff_count = 0; } else { $staff_count = MUser::find()->where(['gh_id' => $gh_id, 'scene_pid' => $scene_ids])->count(); } } return $this->responseText("部门所属员工推广人数是:{$staff_count}\n部门推广人数是:{$count}\n\n" . self::PROMPT_MENU_ONE); case 5: $this->setState($gh_id, $openid, self::STATE_CHANGE_MOBILE); return $this->responseText("请重新输入手机号, 0:退出"); case 6: $staff = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); $current_office_id = empty($staff->office_id) ? '' : "当前所属部门号:{$staff->office_id}\n"; $this->setState($gh_id, $openid, self::STATE_OFFICE); return $this->responseText($current_office_id . $this->getOfficePrompt($gh_id)); case 7: $staff = MStaff::findOne(['gh_id' => $gh_id, 'openid' => $openid]); if ($staff !== null) { $staff->openid = ''; $staff->save(false); return $this->responseText("成功解除微信号与员工之间的绑定!\n\n" . self::PROMPT_MENU_ONE); } else { return $this->responseText("你不需要解除绑定\n\n" . self::PROMPT_MENU_ONE); } default: return $this->responseText("输入无效!\n\n" . self::PROMPT_MENU_ONE); } return $this->responseText(self::PROMPT_MENU_ONE); } } }
<span id="item2mobile" class="control-content"> <ul class="table-view"> <?php if (count($ranking) == 0) { ?> <li class="table-view-cell media"> <div class="pull-right"></div> <div class="media-body">本期活动暂无排名</div> </li> <?php } else { $rank = 0; foreach ($ranking as $rank_item) { $rank++; $office = \app\models\MOffice::findOne(['office_id' => $rank_item['office_id']]); ?> <li class="table-view-cell media"> <a data-ignore="push" class="navigate-right" href="<?php echo Url::to(['qdxcjspb4', 'office_id' => $rank_item['office_id']], true); ?> "> <div class="pull-right"> <span class="badge badge-primary"><?php echo number_format($rank_item['score'], 2); ?> 分</span> </div> <div class="media-body"> <?php echo $rank;