public function actionIndex() { $modelform = new Restaurant(); $results = new Restaurant(); if ($modelform->load(Yii::$app->request->post())) { $connection = \Yii::$app->db; $results = $connection->createCommand("SELECT * FROM restaurants WHERE city LIKE '" . $modelform->city . "%' AND ((street LIKE '" . $modelform->street . "%') OR (name LIKE '" . $modelform->street . "%'))")->queryAll(); // $results = Restaurant::find() // ->where(['city' => $model->city, 'street' =>$model->street ]) // ->all(); Yii::$app->session->setFlash('contactFormSubmitted'); return $this->render('index', ['modelform' => $modelform, 'results' => $results]); } else { return $this->render('index', ['modelform' => $modelform, 'results' => $results]); } }
/** * @return string */ public function actionCreatepdf() { if (Yii::$app->user->isGuest || Yii::$app->user->identity->user_role != 4 && Yii::$app->user->identity->user_role != 3) { return $this->goHome(); } $model = new Restaurant(); if ($model->load(Yii::$app->request->post())) { $mpdf = new mPDF(); $connection = \Yii::$app->db; $warehouses = $connection->createCommand('SELECT warehouse.description, warehouse.price, products.name FROM warehouse LEFT JOIN products ON warehouse.product_id=products.product_id WHERE warehouse.restaurant_id=' . $model->restaurant_id)->queryAll(); $restaurant = Restaurant::find()->where(['restaurant_id' => $model->restaurant_id])->one(); $mpdf->WriteHTML('<h1>Menu restauracji ' . $restaurant->name . ' ' . $restaurant->city . '</h1>'); foreach ($warehouses as $warehouse) { $mpdf->WriteHTML($warehouse['name'] . '<br> Opis: ' . $warehouse['description'] . '<br>Cena: ' . $warehouse['price'] . '<br><br><br>'); } $mpdf->Output(); exit; } return $this->render('createpdf', ['model' => $model]); }