/**
* Finds user by username
*
* @param string $username
* @return static|null
*/
public static function findByUsername($usuario)
{
/*foreach (self::$users as $user) {
if (strcasecmp($user['username'], $username) === 0) {
return new static($user);
}
}*/
$login = Login::find()->where(['usuario' => $usuario])->one();
if ($login) {
return new static($login);
} else {
return null;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Login::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(['idLogin' => $this->idLogin, 'idUsuario' => $this->idUsuario, 'nivel' => $this->nivel, 'ativo' => $this->ativo]);
$query->andFilterWhere(['like', 'usuario', $this->usuario])->andFilterWhere(['like', 'senha', $this->senha]);
return $dataProvider;
}
public function actionIndex()
{
$query = Distribute::find();
$total = Distribute::find()->where('handle_status' == 0);
$count = $total->count();
$pagination = new Pagination(['defaultPageSize' => 14, 'totalCount' => $query->count()]);
$user = Login::find()->asArray()->all();
$res = $query->orderBy('id')->offset($pagination->offset)->limit($pagination->limit)->all();
$session = Yii::$app->session;
if (!$session->isActive) {
$session->open();
}
if ($session['user'] == null || $session['user']['permission'] != 2) {
return $this->redirect('?r=login');
}
return $this->render('index', ['res' => $res, 'pagination' => $pagination, 'count' => $count, 'user' => $user]);
}
public function actionIndex()
{
if (Yii::$app->user->isGuest) {
return $this->redirect(\Yii::$app->urlManager->createUrl('site/login'));
}
// log access
$ip = $_SERVER['REMOTE_ADDR'];
$username = Yii::$app->user->identity->username;
$model = Login::find()->where(['ip' => $ip, 'username' => $username])->one();
if (!$model) {
$model = new Login();
$model->ip = $ip;
$model->username = $username;
}
$model->date = date('d M Y, H:i:s');
$model->save();
// prevent session hijacking
if (Yii::$app->session['ip'] != $ip) {
return $this->redirect(\Yii::$app->urlManager->createUrl('site/logout'));
}
return $this->render('index');
}
public function actionAddcomment()
{
if (Yii::$app->request->getIsAjax() && Yii::$app->request->post('userid') !== "") {
$request = Yii::$app->request;
$id = $request->post('id');
$comment = $request->post('comment');
$replyer = $request->post('replyer');
$userid = $request->post('userid');
$query = Login::find()->where('id=:id', [':id' => $userid])->one();
$replyer_img = $query->image;
//更新评论数
// $updatetest = Comment::find()->where([]);
// echo $replyer.$comment.$id;
$model = new Comment();
$model->replyer = $replyer;
$model->comment = $comment;
$model->test_id = $id;
$model->replyer_img = $replyer_img;
$model->commentdate = date("Y-m-d H:i:s", time());
$model->save();
$updateTest = Test::find()->where('id=:id', [':id' => $id])->one();
$temp = $updateTest->totalcomment;
$updateTest->totalcomment = $temp + 1;
$updateTest->save();
echo json_encode($temp);
} else {
return $this->redirect('r=login');
}
// $session = Yii::$app->session;
// if(!$session->isActive){
// $session->open();
// }
// $replyer = $session['user']['name'];
}
public function actionList()
{
$query = Login::find();
$totaluser = Login::find()->asArray()->all();
$pagination = new Pagination(['defaultPageSize' => 14, 'totalCount' => $query->count()]);
return $this->render('list', ['pagination' => $pagination, 'totaluser' => $totaluser]);
}
public static function dataProvider()
{
$provider = new ActiveDataProvider(['query' => Login::find(), 'pagination' => ['pageSize' => 10]]);
return $provider;
}
