/**
* Finds the TypeTicket model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return TypeTicket the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = TypeTicket::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionIndex()
{
$TypeTicket = TypeTicket::find()->all();
$model = new PriceTicket();
$model2 = new PriceTicket2();
$model3 = new PriceTicket3();
$model_programms = new PriceProgramms();
$dt = Yii::$app->getRequest()->post('PriceTicket');
$dt2 = Yii::$app->getRequest()->post('PriceTicket2');
$dt3 = Yii::$app->getRequest()->post('PriceTicket3');
$dt_dop_price = Yii::$app->getRequest()->post("DopPrice");
if ($dt["price"]) {
foreach ($dt["price"] as $type_day => $value) {
foreach ($value as $type_ticket => $val) {
foreach ($val as $hours => $price) {
$res = PriceTicket::find()->where("type_day={$type_day} AND type_ticket={$type_ticket} AND hours={$hours}")->all();
if ($res) {
$id = $res[0]->id;
$record = PriceTicket::findOne($id);
$record->price = $price;
$record->update();
} else {
$record = new PriceTicket();
$record->type_day = $type_day;
$record->type_ticket = $type_ticket;
$record->hours = $hours;
$record->price = $price;
$record->insert();
}
}
}
}
}
if ($dt2["price"]) {
foreach ($dt2["price"] as $type_day => $value) {
foreach ($value as $type_ticket => $val) {
foreach ($val as $hours => $price) {
$res = PriceTicket2::find()->where("type_day={$type_day} AND type_ticket={$type_ticket} AND hours={$hours}")->all();
if ($res) {
$id = $res[0]->id;
$record = PriceTicket2::findOne($id);
$record->price = $price;
$record->update();
} else {
$record = new PriceTicket2();
$record->type_day = $type_day;
$record->type_ticket = $type_ticket;
$record->hours = $hours;
$record->price = $price;
$record->insert();
}
}
}
}
}
if ($dt3["price"]) {
foreach ($dt3["price"] as $type_day => $value) {
foreach ($value as $type_ticket => $val) {
foreach ($val as $hours => $price) {
$res = PriceTicket3::find()->where("type_day={$type_day} AND type_ticket={$type_ticket} AND hours={$hours}")->all();
if ($res) {
$id = $res[0]->id;
$record = PriceTicket3::findOne($id);
$record->price = $price;
$record->update();
} else {
$record = new PriceTicket3();
$record->type_day = $type_day;
$record->type_ticket = $type_ticket;
$record->hours = $hours;
$record->price = $price;
$record->insert();
}
}
}
}
}
$dt_programms = Yii::$app->getRequest()->post('PriceProgramms');
if ($dt_programms["programms"]) {
foreach ($dt_programms["programms"] as $id_programm => $programm) {
foreach ($programm as $id_type_day => $price) {
$res = PriceProgramms::findOne(["id_programm" => $id_programm, "id_time" => $id_type_day]);
if ($res) {
$res->price = $price;
$res->save();
} else {
$res = new PriceProgramms();
$res->id_programm = $id_programm;
$res->id_time = $id_type_day;
$res->price = $price;
$res->save();
}
}
}
}
$data = PriceTicket::find()->all();
$data2 = PriceTicket2::find()->all();
$data3 = PriceTicket3::find()->all();
foreach ($data as $key => $val) {
$dt_val[$val["type_day"]][$val["type_ticket"]][$val["hours"]] = $val["price"];
}
foreach ($data2 as $key => $val) {
$dt_val2[$val["type_day"]][$val["type_ticket"]][$val["hours"]] = $val["price"];
}
foreach ($data3 as $key => $val) {
$dt_val3[$val["type_day"]][$val["type_ticket"]][$val["hours"]] = $val["price"];
}
$TypeHours = TypeHours::find()->all();
foreach ($TypeHours as $val) {
$dt_type_hours[$val->id] = $val->value;
}
$programms = Programms::find()->all();
$programms_type_day = TypeDayProgramms::find()->all();
$data_programms = PriceProgramms::find()->all();
$dt_programms_val = "";
foreach ($data_programms as $val) {
$dt_programms_val[$val["id_programm"]][$val["id_time"]] = $val["price"];
}
$model_dop_price = new DopPrice();
if (count($dt_dop_price) > 0) {
foreach ($dt_dop_price as $key => $value) {
$res = DopPrice::find()->where(["name" => $key])->all();
$res[0]->price = $value;
$res[0]->update();
}
}
$DopPrice = DopPrice::find()->all();
return $this->render('index', ['TypeTicket' => $TypeTicket, 'model' => $model, 'model2' => $model2, 'model3' => $model3, 'dt' => $dt, 'dt2' => $dt2, 'dt3' => $dt3, 'dt_val' => $dt_val, 'dt_val2' => $dt_val2, 'dt_val3' => $dt_val3, 'dt_type_hours' => $dt_type_hours, 'DopPrice' => $DopPrice, 'model_dop_price' => $model_dop_price, 'programms' => $programms, 'programms_type_day' => $programms_type_day, 'model_programms' => $model_programms, 'dt_val_programms' => $dt_programms_val]);
}
public function actionGetTicketInfo()
{
$type_user = $this->get["type_user"];
if ($type_user == 1) {
$name_table = new Customs();
} elseif ($type_user == 2) {
$name_table = new Bankir();
}
$controller = $name_table::findOne(["token" => $this->get["token"]]);
if (!$controller) {
$r = $this->setError(205);
} else {
$RelOrderPeople = RelOrderPeople::findOne(["qr" => $this->get["qr"]]);
if (!$RelOrderPeople) {
$r = $this->setError(501);
} else {
$r["status"] = "ok";
if ($RelOrderPeople->type_people == 1) {
$type_people = new Parents();
$r["type_people"] = "Adult";
} elseif ($RelOrderPeople->type_people == 2) {
$type_people = new Kids();
$r["type_people"] = "Kids";
}
$order = Order::findOne($RelOrderPeople->id_order);
$people = $type_people::findOne($RelOrderPeople->id_people);
$r["name"] = $people->name;
$r["surname"] = $people->surname;
$r["father_name"] = $people->father_name;
$dt_txt = date("Y-m-d", $people->birthday);
$datetime1 = date_create($dt_txt);
$datetime2 = date_create();
$interval = date_diff($datetime1, $datetime2);
$r["birthday"] = $interval->format('%y') . " лет (" . date("d.m.Y", $people->birthday) . ")";
$r["phone"] = $people->phone;
$r["summ"] = $RelOrderPeople->summ / 100;
$r["pitanie"] = $RelOrderPeople->pitanie;
$r["status_enter"] = $RelOrderPeople->status;
$r["status_money"] = $RelOrderPeople->status_money;
$r["count_hours"] = $order->count_hours;
if ($RelOrderPeople->type_people == 2) {
$r["money"] = 50;
} else {
$r["money"] = 0;
}
$type_tiket = TypeTicket::findOne($RelOrderPeople->type_tiket);
$r["type_tiket"] = $type_tiket->name;
$d = $order->date;
$date1 = date("d.m.Y", $d);
$date2 = date("d.m.Y", mktime(0, 0, 0, date("m", $d) + 6, date("d", $d), date("Y", $d)));
$r["date1"] = $date1;
$r["date2"] = $date2;
}
}
return json_encode($r);
}
public function actionReport()
{
$get = Yii::$app->request->get();
$user = Yii::$app->user;
if (isset($get["id"])) {
$id = $get["id"];
$RelOrderPeople = RelOrderPeople::findOne($id);
$mOrderID = $RelOrderPeople->id_order;
$order = Order::findOne($RelOrderPeople->id_order);
if ($order->id_user != $user->id) {
exit;
}
if ($RelOrderPeople->type_people == 2) {
$people = Kids::findOne($RelOrderPeople->id_people);
} elseif ($RelOrderPeople->type_people == 1) {
$people = Parents::findOne($RelOrderPeople->id_people);
}
$name = $people->surname . " " . $people->name;
$old = $this->getyeardiff($people->birthday, $mOrderID);
$TypeTicket = TypeTicket::findOne($RelOrderPeople->type_tiket);
$name_tiket = $TypeTicket->name;
$time = $order->count_hours;
$date = date("d.m.Y", $order->date);
$price = $RelOrderPeople->summ / 100;
$pitanie = $RelOrderPeople->pitanie;
$qr = $RelOrderPeople->qr;
$money = 0;
if ($RelOrderPeople->type_people == "2") {
$money = 50;
}
$d = $order->date;
$date2 = date("d.m.Y", mktime(0, 0, 0, date("m", $d) + 6, date("d", $d), date("Y", $d)));
}
$myview = $this->renderPartial("test_t", ["name" => $name, "old" => $old, "name_tiket" => $name_tiket, "time" => $time, "date" => $date, "price" => $price, "pitanie" => $pitanie, "qr" => $qr, "date2" => $date2, "money" => $money]);
$d = new mPDF('utf-8', 'A4', '8', '', 0, 0, 0, 0, 0, 0);
$d->writeHTML($myview);
$d->charset_in = 'utf-8';
$d->list_indent_first_level = 0;
$d->WriteHTML($html, 2);
$d->Output('mpdf.pdf', 'I');
$d->output();
}
