public function actionOrders($category) { $query = Job::find()->where(['category_id' => $category]); $query2 = Posts::find()->where(['category_id' => $category]); $pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]); $orders = $query->orderBy('create_date DESC')->offset($pagination->offset)->limit($pagination->limit)->all(); $postOrders = $query2->orderBy('create_date DESC')->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('orders', ['orders' => $orders, 'pagination' => $pagination, 'postOrders' => $postOrders]); }
public function getCategory() { return $this->hasMany(Job::className(), ['category_id' => 'id']); }
echo Yii::$app->urlManager->createUrl('job/create'); ?> ">Create</a></h1> <?php if (!empty($orders)) { ?> <ul class="list-group"> <?php /* * $jobs is object of ActiveRecord for rendering vacancies */ foreach ($orders as $order) { ?> <?php $formatedDate = ''; $formatedDate = Job::dateVacancy($order); ?> <li class="list-group-item"> <a href="<?php echo Yii::$app->urlManager->createUrl(['job/details', 'id' => $order->id]); ?> "> <?php echo $order->title; ?> </a> - in <b><?php echo $order->city; ?> </b> Added: <i><?php echo $formatedDate; ?>
echo Yii::$app->urlManager->createUrl(['job/edit', 'id' => $job->id]); ?> ">Edit</a> </span> <?php } if (!empty($job)) { ?> <h3>From category: <?php $category = Category::find()->where(['id' => $job->category_id])->one(); echo $category->name; ?> </h3> <span style="font-size: 18px">Published: <?php echo Job::dateVacancy($job); ?> </span> <h2 class="well"><?php echo $job->title; ?> <span style="font-size: 24px; color: green"> Salary: <?php echo $job->salary; ?> </span></h2> <code style="font-size: 22px"><?php echo $job->description; ?> </code><br> <ul class="list-group-item-info" style="margin: 3px">
<?php /* * $jobs is object of ActiveRecord for rendering vacancies * use Html::encode() * also we can use HtmlPurifier::process() but it's pretty slow loading */ /* * We can also render file in file, or view in view */ // $job = new Job(); // echo Yii::$app->view->render('create', ['job' => $job]); foreach ($jobs as $job) { ?> <?php $formatedDate = ''; $formatedDate = Job::dateVacancy($job); ?> <li class="list-group-item"> <?php /* * everything that we have from users have to be encoded and secure, don't trust them */ ?> <a href="<?php echo Yii::$app->urlManager->createUrl(['job/details', 'id' => $job->id]); ?> "> <?php echo Html::encode($job->title); ?> </a> - in <b><?php
public function actionDelete($id) { $job = Job::findOne($id); if (Yii::$app->user->identity->id != $job->user_id) { Yii::$app->session->setFlash('restricted', 'Deny!'); return $this->redirect(Yii::$app->urlManager->createUrl('job')); } $job->delete(); Yii::$app->session->setFlash('success', 'Job has deleted!'); return $this->redirect(Yii::$app->urlManager->createUrl('job')); }