public function run($args) { $user_info = Admin::model()->findAll(); $count = Advice::model()->count('status=0'); foreach ($user_info as $row) { if ($row->send_email == 0 || empty($row->email)) { continue; } $message = "您今天新增" . $count . "条后勤办反馈建议\n\t \t\t'http://localhost/logistics/index.php?r=admin/index/index' 点击链接登录后台进行查看"; $mailer = Yii::createComponent('application.extensions.mailer.EMailer'); $mailer->Host = 'smtp.qq.com'; $mailer->IsSMTP(); $mailer->SMTPAuth = true; $mailer->From = '*****@*****.**'; $mailer->AddReplyTo("{$row->email}"); $mailer->AddAddress("{$row->email}"); $mailer->FromName = '你大爷'; $mailer->Username = '******'; //这里输入发件地址的用户名 $mailer->Password = '******'; //这里输入发件地址的密码 $mailer->SMTPDebug = true; //设置SMTPDebug为true,就可以打开Debug功能,根据提示去修改配置 $mailer->CharSet = 'UTF-8'; $mailer->Subject = Yii::t('demo', 'Yii rulez!'); $mailer->Body = $message; $x = $mailer->Send(); $x = $mailer->Send(); } }
/** * 发布一则反馈 */ public function actionUpdateStatus($aid = 0) { if ($aid != 0) { $model = Advice::model()->findByPk($aid); if (isset($model->aid)) { $model->attributes = array('status' => 1); } if ($model->save()) { $this->redirect(array('index')); } } $this->redirect(array('index')); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Advice the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Advice::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * 选时间段画出统计图 */ private function analyse($time = -1, $all = 1) { $criteria = new CDbCriteria(); $criteria->select = 'cid'; if ($all == 0) { $criteria->addCondition('`status`=0'); } if ($time > 0) { $start_time = date("Y-m-d H:i:s", strtotime("-{$time} week")); $end_time = date("Y-m-d H:i:s", time()); $criteria->addCondition("create_time>'" . $start_time . "'"); $criteria->addCondition("create_time<'" . $end_time . "'"); } else { if ($time == 0) { $end_time = date("Y-m-d H:i:s", strtotime("{$time} week")); $start_time = date("Y-m-d 00:00:00", time()); $criteria->addCondition("create_time>'" . $start_time . "'"); $criteria->addCondition("create_time<'" . $end_time . "'"); } } $model = Advice::model()->findAll($criteria); if (count($model) == 0) { return array(); } $data = array(); $cate_name = array(); $cates = Category::model()->findAll(); foreach ($cates as $row) { $cate_name[$row->cid] = $row->cname; $data[$cate_name[$row->cid]] = 0; } foreach ($model as $row) { $data[$cate_name[$row->cid]]++; } return $data; }
/** * 查看近一个星期的反馈情况 */ private function analyse($id) { $criteria = new CDbCriteria(); $criteria->select = array('create_time'); $criteria->addCondition('cid=' . $id); $start_time = date("Y-m-d H:i:s", strtotime("-1 week")); $end_time = date("Y-m-d H:i:s", time()); $criteria->addCondition("create_time>'" . $start_time . "'"); $criteria->addCondition("create_time<'" . $end_time . "'"); //$criteria -> order = 'create_time desc'; $model = Advice::model()->findAll($criteria); if (count($model) == 0) { return array(); } $data = array(); for ($i = 0; $i < 7; $i++) { $data[date("Y-m-d ", strtotime("-{$i} day"))] = 0; } foreach ($model as $row) { $date = substr($row->create_time, 0, 10); $data[$date]++; } return $data; }