public function actionSearch() { $str = ''; if (isset($_POST['name'])) { $name = $_POST['name']; $icno = $_POST['icno']; if (!empty($name)) { $str = "name LIKE '%{$name}%'"; } if (!empty($icno)) { $str = "icno = '{$icno}'"; } } if (!empty($str)) { $visitors = Visitor::find()->where($str)->all(); } else { $visitors = Visitor::find()->all(); } return $this->render('search', ['visitors' => $visitors]); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $visitor = Visitor::find($id); $visitor->punch_out = Carbon::now(); $visitor->save(); return redirect()->route('visitors.index'); }
/* @var $this yii\web\View */ $this->title = 'Administration'; $this->params['breadcrumbs'][] = $this->title; use yii\grid\GridView; use app\models\Visitor; use app\models\Login; ?> <div class="site-index"> <div class="jumbotron"> <h1>Administration</h1> <p class="lead"> Site management. </p> </div> <div class="body-content"> <h2>Successful logins</h2> <?php echo GridView::widget(['dataProvider' => Login::dataProvider(), 'columns' => ['ip', 'date', 'username']]); ?> <h2>Visitor list</h2> <?php echo GridView::widget(['dataProvider' => Visitor::dataProvider(), 'columns' => ['ip', 'country', 'first_visit', 'last_visit', 'num_visits']]); ?> </div> </div>
public function actionDetails($id) { sleep(1); $visit = Visit::findOne($id); $visitor = Visitor::findOne($visit->visitor_id); return $this->renderPartial('details', ['visit' => $visit, 'visitor' => $visitor]); }