/** * Отравка сообщения о сегодняшних дедлайнах */ public function actionToday() { $bot = new BotApi(Yii::$app->params['token']); $start = time(); $end = strtotime('+1 day'); $users = User::findAll(['notification' => true]); foreach ($users as $user) { $deadlines = []; foreach ($user->teams as $team) { $deadline = strtotime($team->tournament->deadline); if ($deadline > $start && $deadline < $end) { $deadlines[$team->tournament->name] = $team->tournament->deadline; } } if (!empty($deadlines)) { asort($deadlines); $message = 'Сегодня дедлайны:'; foreach ($deadlines as $name => $deadline) { $date = new DateTime($deadline, new DateTimeZone(Yii::$app->timeZone)); $message .= "\n" . $date->format('H:i') . ' ' . $name; } try { $bot->sendMessage($user->chat_id, $message); } catch (Exception $e) { Yii::info($e->getMessage(), 'send'); } } } }
public function actionAll() { if (Yii::$app->user->identity->role != USER::ADMIN) { throw new ForbiddenHttpException("You are not allowed", 1); } $users = User::findAll(['status' => User::ACTIVE, 'role' => User::CLIENT]); return ['success' => 1, 'payload' => $users]; }
/** * Remove new users that didn't validate the email for more than x days(read from config) * Removed deleted accounts if x days passed (read from config) */ public function actionUsers() { $newUsers = User::findAll("status = :new AND register_date < DATE_SUB(NOW(), INTERVAL :days DAY)", array(':new' => User::STATUS_NEW, ':days' => GlobalConfig::value('USERS_REMOVE_NEW_AFTER_DAYS'))); foreach ($newUsers as $user) { $this->debug($user->name . '<' . $user->email . '> deleted! [new]'); $user->delete(); } $deletedUsers = User::findAll("status = :deleted AND deleteblock_date < DATE_SUB(NOW(), INTERVAL :days DAY)", array(':deleted' => User::STATUS_DELETED, ':days' => GlobalConfig::value('USERS_REMOVE_DELETED_AFTER_X_DAYS'))); foreach ($deletedUsers as $user) { $this->debug($user->name . '<' . $user->email . '> deleted! [delete request on ' . $user->deleteblock_date . ']'); $user->delete(); } }
public function actionTest() { // $user = new User(); // $user->name = 'jun1'; // $user->age = 30; // $result = $user->insert(); // $user = User::findOne(['id' => 10]); // $user->name = 'test'; // $result = $user->update(); // $result = $user->delete(); // var_dump($result);die; $user = User::findAll(); // $user = User::deleteAll(['name' => 'jun1']); // // $user = User::updateAll(['age' => 21], ['age' => 20]); $data = ['first' => 'awesome-php-zh_CN', 'second' => 'simple-framework', 'user' => $user]; echo $this->toJson($data); }
public function actionHome() { if (YII_DEBUG) { error_log("[Site::Home]"); } if (YII_DEBUG) { error_log('CLIENTS : '); $users = User::findAll(["user_type" => 0]); foreach ($users as $user) { error_log("user : "******"user_type" => 1]); foreach ($users as $user) { error_log("user : " . json_encode($user->getAttributes())); } } return $this->render('index', ['content' => []]); }
public function testCreateModel() { $indonesia = new Country(array('name' => 'Indonesia')); $indonesia->save(); $user = new User(array('fullname' => 'Mukhamad Ikhsan', 'email' => '*****@*****.**', 'password' => 'rahasia', 'profile' => array('profession' => 'programmer', 'nationality' => $indonesia))); $this->assertEqual('Mukhamad Ikhsan', $user->fullname); $this->assertEqual('programmer', $user->profile->profession); $this->assertEqual('Indonesia', $user->profile->nationality->name); $this->assertTrue($user->save()); $ikhsan = User::getRepository()->findOneBy(array('email' => '*****@*****.**')); $users = User::findAll(array('where' => array('and' => array(array('fullname' => array('like' => '%Ikhsan')), array('fullname' => array('eq' => 'Mukhamad Ikhsan')), array('fullname' => array('neq' => 'Haris Riswandi')))), 'leftJoin' => array(array('field' => 'groups')))); $compacts = User::getCompactList('fullname'); $this->assertEqual(1, count($users)); $this->assertEqual(1, count($compacts)); $this->assertEqual('Mukhamad Ikhsan', $ikhsan->fullname); $this->assertEqual('programmer', $ikhsan->profile->profession); $this->assertEqual('Indonesia', $ikhsan->profile->nationality->name); $ikhsan->delete(); $indonesia->delete(); $this->assertNull(User::getRepository()->findOneBy(array('email' => '*****@*****.**'))); $this->assertNull(Country::getRepository()->findOneBy(array('name' => 'Indonesia'))); }
<?php require __DIR__ . '/autoload.php'; $users = \App\Models\User::findAll(); var_dump($users); /** echo \App\Models\User::$table; */ /** $user = new \App\Models\User(); $user->findAll(); var_dump($user->findAll()); */ /** $db = new \App\Db(); $data = $db->query('SELECT * FROM users','App\Models\User'); var_dump($data); */ /** $db = new \App\Db(); $res = $db->execute('CREATE TABLE foo (id SERIAL)'); var_dump($res); */
public function getUserList() { return User::findAll(['created_time' => 0]); }
public function actionDefault() { $this->data->items = User::findAll(); }
/** * Delete multiple existing User model. * For ajax request will return json object * and for non-ajax request if deletion is successful, the browser will be redirected to the 'index' page. * @param string $id * @return mixed */ public function actionBulkDelete() { $request = Yii::$app->request; $pks = $request->post('pks'); // Array or selected records primary keys foreach (User::findAll(json_decode($pks)) as $model) { $model->delete(); } if ($request->isAjax) { /* * Process for ajax request */ Yii::$app->response->format = Response::FORMAT_JSON; return ['forceClose' => true, 'forceReload' => '#crud-datatable-pjax']; } else { /* * Process for non-ajax request */ return $this->redirect(['index']); } }
protected function actionIndex() { $this->view->news = \App\Models\News::findLastNews(3); $this->view->users = \App\Models\User::findAll(); echo $this->view->render(__DIR__ . '/../templates/index.php'); }
protected function actionIndex() { $this->view->news = News::findLastNews(5); $this->view->users = User::findAll(); echo $this->view->render(__DIR__ . '/../templates/admin.php'); }
<?php require_once dirname(dirname(__DIR__)) . '/layout/header.php'; echo \mpf\widgets\datatable\Table::get(['dataProvider' => $model->getDataProvider(), 'columns' => ['url', 'author_id' => ['filter' => \mpf\helpers\ArrayHelper::get()->transform(\app\models\User::findAll(), ['id' => 'name']), 'value' => function (\mpf\modules\blog\models\BlogPost $model) { return $model->author->name; }], 'category_id' => ['filter' => \mpf\helpers\ArrayHelper::get()->transform(\mpf\modules\blog\models\BlogCategory::findAll(), ['id' => 'name']), 'value' => function (\mpf\modules\blog\models\BlogPost $model) { return $model->category->name; }], 'time_written' => ['class' => 'Date'], 'time_published' => ['class' => 'Date'], 'status' => ['filter' => \mpf\modules\blog\models\BlogPost::getStatuses(), 'value' => function (\mpf\modules\blog\models\BlogPost $model) { $all = \mpf\modules\blog\models\BlogPost::getStatuses(); return $all[$model->status]; }], ['class' => 'Actions', 'buttons' => ['delete' => ['class' => 'Delete'], 'edit' => ['class' => 'Edit'], 'publish' => ['post' => ['{{modelKey}}' => '$row->id'], 'confirmation' => \app\components\htmltools\Translator::get()->t("Are you sure that you want to publish the article?"), 'title' => '"Publish Article"', 'url' => "\\mpf\\WebApp::get()->request()->createURL('articles', 'publish')", 'icon' => '%MPF_ASSETS%images/oxygen/%SIZE%/actions/view-task.png', 'visible' => "\$row->status != " . \mpf\modules\blog\models\BlogPost::STATUS_PUBLISHED]], 'headerHtmlOptions' => ['style' => 'width:60px;']]]])->display(); require_once dirname(dirname(__DIR__)) . '/layout/footer.php';
<?php require __DIR__ . '/autoload.php'; $view = new \App\View(); $view->title = 'Мой крутой сайт!'; $view->users = \App\Models\User::findAll(); echo count($view); die; $view->display(__DIR__ . '/App/templates/index.php');
public function actionTest() { $user_m = User::findAll(['username' => '13699273824']); var_dump($user_m); exit; }
/** * @inheritdoc */ public function beforeValidate() { if (!parent::beforeValidate()) { return false; } if ($this->scenario == 'create' || $this->scenario == 'update') { $this->categoriesValid = Category::findAll($this->categories); $this->usersValid = User::findAll($this->users); } return true; }
public function index() { $users = User::findAll(); return compact('users'); }
public function actionDefault() { $this->data->students = User::findAll(); }