/**
* Displays event view page.
*
* @return mixed
*/
public function actionShow()
{
if (Yii::$app->request->get("eventname") == "") {
throw new CHttpException(404, 'The specified post cannot be found.');
}
$eventname = Yii::$app->request->get("eventname");
$list = Events::find()->where(['link' => $eventname]);
if ($list->count() == 0) {
throw new CHttpException(404, 'The specified post cannot be found.');
}
$list = $list->one();
$org = Users::find()->where(['id' => $list["FK_organizer_id"]])->one();
$participients = UsersEvents::find()->where(['FK_event_id' => $list->id]);
$pars = array();
if ($participients->count() == 0) {
$participients = false;
}
if ($participients) {
$participients = $participients->all();
foreach ($participients as $value) {
$pars[] = $value["id"];
}
}
Users::current()->id;
$participients = Users::find()->where(['id' => $pars])->all();
return $this->render('view', ['model' => $list, 'org' => $org, 'participients' => $participients]);
}
public function actionIndex()
{
$result = Yii::$app->request;
if ($result->post('event') === 'Login_Event') {
$login = $result->post('login');
$password = $result->post('password');
$user = Users::find()->from('users')->where(['email' => $login, 'password' => $password])->one();
if (!empty($user)) {
$ip = Yii::$app->request->getUserIP();
$id = $user->person_id;
$sessionId = Helper::generateRandomString(date("Y_m_d_H_i_s"), 15);
$session = Yii::$app->session;
$session->setId('' . $sessionId);
$session->set("login", $login);
$session->set("IP", $ip);
$session->set("success", "accept");
$session->set("id", $id);
$user->session_id = $sessionId;
$user->save();
$answer = 'success';
} else {
$answer = 'denied';
}
Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
if ($answer == 'success') {
return array('event' => 'Login_Event', 'answer' => $answer, 'url' => Yii::$app->urlManager->createUrl(['network/index', 'id' => $id]));
}
return array('event' => 'Login_Event', 'answer' => $answer);
} else {
return $this->render('index', array());
}
}
public function actionIndex()
{
$query = Users::find()->leftJoin('media', array('id' => 'user_id'))->where(['type' => 1, 'active' => 1]);
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count()]);
echo $pages;
die;
$page = 1;
if (isset($_REQUEST["page"])) {
$page = intVal($_REQUEST["page"]);
}
$limit = 12;
$offset = $limit * ($page - 1);
$pageSize = ceil($countQuery->count() / $limit);
$pages->setPageSize($pageSize);
$models = $query->offset($offset)->limit($limit)->all();
$city = City::find()->all();
return $this->render('index', ['models' => $models, 'pages' => $pages, 'city' => $city]);
}
public function actionGetpass()
{
$model = new Users();
$pass = $model->find()->select(['FIELD4'])->where(['FIELD3' => 'telkom'])->scalar();
echo $this->decrypt($pass);
}
public function actionIndex()
{
$data = Users::find()->asArray()->all();
return $this->render('index', ['data' => $data]);
}
