public function showInfoRestaurant($id)
{
$analytic = Restaurant::find($id);
if ($analytic) {
$analytic->counter = $analytic->counter++;
$analytic->save();
}
$restaurant = Restaurant::find($id);
return view('frontend.pages.info-restaurant', compact('restaurant'));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Restaurant::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['restaurant_id' => $this->restaurant_id, 'name' => $this->name, 'street' => $this->street, 'house_nr' => $this->house_nr, 'flat_nr' => $this->flat_nr, 'zip_code' => $this->zip_code, 'city' => $this->city]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'street', $this->street])->andFilterWhere(['like', 'zip_code', $this->zip_code])->andFilterWhere(['like', 'city', $this->city]);
return $dataProvider;
}
function userRestaurantAnalytic()
{
$input = Input::all();
$analytic = Restaurant::find($input['restaurant_id']);
$analytic->counter = $analytic->counter++;
if (!$analytic) {
return Json::error('error');
} else {
$analytic->counter = $analytic->counter++;
if ($analytic->save()) {
return Json::success();
} else {
return Json::error('error');
}
}
}
public function actionChart()
{
$customers = User::find()->select(['city', 'COUNT(*) AS street'])->groupBy('city')->all();
$restaurants = Restaurant::find()->select(['city', 'COUNT(*) AS street'])->groupBy('city')->all();
// $restaurantsOrders = Restaurant::find()
// ->select(['{{restaurants}}.name', 'COUNT({{orders}}.order_id) AS restaurant_id'])
// ->joinWith('order')
// ->groupBy('{{restaurants}}.name')
// ->all();
$connection = \Yii::$app->db;
$restaurantsOrders = $connection->createCommand('SELECT restaurants.name, Count(orders.order_id) FROM restaurants LEFT JOIN orders ON restaurants.restaurant_id = orders.restaurant_id GROUP BY restaurants.name')->queryAll();
$chart = new Charts();
$LabChartsPie = new LabChartsPie();
$LabChartsPie->setData($chart->getUsersAmountArray($customers));
$LabChartsPie->setTitle('');
$LabChartsPie->setSize('400x200');
$LabChartsPie->setColors('D9351C');
$LabChartsPie->setLabels($chart->getCities($customers));
$LabChartsBar = new LabChartsBar();
$LabChartsBar->setData($chart->getAmountArray($restaurants));
$LabChartsBar->setSize('400x200');
$LabChartsBar->setTitle('');
//$LabChartsBar->setColors('D9351C|FAAC02|79D81C|2A9DF0|02AA9D');
$LabChartsBar->setLabels($chart->getCities($restaurants));
$LabChartsBar->setBarStyles(40);
$LabChartsBar->setAxis(10);
$LabChartsBar->setGrids(10);
$LabChartsPie2 = new LabChartsPie();
$LabChartsPie2->setData($chart->getAmountOrderArray($restaurantsOrders));
//$LabChartsPie->setType('p3');
$LabChartsPie2->setTitle('');
$LabChartsPie2->setSize('400x200');
$LabChartsPie2->setColors('D9351C');
$LabChartsPie2->setLabels($chart->getRestaurantNames($restaurantsOrders));
return $this->render('chart', ['LabChartsPie' => $LabChartsPie, 'LabChartsPie2' => $LabChartsPie2, 'LabChartsBar' => $LabChartsBar]);
}
public function upload()
{
if ($this->validate()) {
$this->xmlFile->saveAs('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension);
$xml = simplexml_load_file('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension);
foreach ($xml->product as $product) {
$warehouse = new Warehouse();
$warehouse->warehouse_id = null;
$restaurant = Restaurant::find()->where(['name' => $product->restaurant_name])->one();
$products = Product::find()->where(['name' => $product->product_name])->one();
if (isset($products) && isset($restaurant)) {
$warehouse->restaurant_id = $restaurant->restaurant_id;
$warehouse->product_id = $products->product_id;
$warehouse->description = $product->description;
$warehouse->price = $product->price;
$warehouse->save();
}
}
unlink('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension);
return true;
} else {
return false;
}
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use app\models\Restaurant;
$this->title = Yii::t('app', 'Pdf menu creator');
$this->params['breadcrumbs'][] = Yii::t('app', $this->title);
?>
<div class="order-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'restaurant_id')->dropDownList(ArrayHelper::map(Restaurant::find()->all(), 'restaurant_id', 'name'));
?>
<div class="form-group">
<?php
echo Html::submitButton(Yii::t('app', 'Create'), ['class' => 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
</div>
' . Yii::t('app', 'You are logged in') . '
</div>';
echo '<h1>' . Yii::t('app', 'Welcome') . ' ' . $model->login . '</h1>';
echo '<img src= "/upload/' . $model->filename . '" onError="this.src=\'\';"/>';
echo '<h1>' . Yii::t('app', 'Find restaurant') . '</h1>';
}
?>
<div style="width:100%">
<div class="col-lg-5" style="left: 30%;">
<?php
$form = ActiveForm::begin(['id' => 'contact-form']);
?>
<?php
echo $form->field($modelform, 'city')->dropDownList(ArrayHelper::map(Restaurant::find()->all(), 'city', 'city'));
?>
<?php
echo $form->field($modelform, 'street')->label(Yii::t('app', "Street name:"));
?>
<div class="form-group">
<?php
echo Html::submitButton(Yii::t('app', 'Find'), ['class' => 'btn btn-primary', 'name' => 'contact-button']);
?>
</div>
<?php
ActiveForm::end();
?>
</div>
/**
* @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]);
}
protected function findModel($id)
{
Yii::$app->response->format = Response::FORMAT_JSON;
if (($model = Restaurant::find()->where(['restaurant_id' => $id])->one()) !== null) {
return $model;
} else {
echo json_encode(array('status' => 0, 'error_code' => Codes::$BAD_REQUEST, 'message' => StatusCodeMessage::$BAD_REQUEST), JSON_PRETTY_PRINT);
exit;
// throw new NotFoundHttpException('The requested page does not exist.');
}
}
