/** * Displays the index (home) page. * Use it in case your home page contains static content. * * @return string */ public function actionIndex() { $searchModel = new ServiceSearch(); $searchModel->promo = true; $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('tempindex', ['cat' => Category::find()->orderBy('name_pt')->all(), 'serv' => Service::find()->orderBy('title_pt')->all(), 'modelImg' => Campaign::find()->one(), 'dataProvider' => $dataProvider]); }
/** * post Store. * * @param Request $request Input data of booking form * * @return Response Redirect to Appointments listing */ public function postStore(Request $request) { $this->log->info(__METHOD__); ////////////////// // FOR REFACTOR // ////////////////// $issuer = auth()->user(); $business = Business::findOrFail($request->input('businessId')); $contact = $issuer->getContactSubscribedTo($business->id); $service = Service::find($request->input('service_id')); $strDateTime = $request->input('_date') . ' ' . $business->pref('start_at'); $datetime = Carbon::parse($strDateTime . ' ' . $business->timezone)->setTimezone('UTC'); $comments = $request->input('comments'); $this->concierge->setBusiness($business); $appointment = $this->concierge->makeReservation($issuer, $business, $contact, $service, $datetime, $comments); if (false === $appointment) { $this->log->info('[ADVICE] Unable to book'); Flash::warning(trans('user.booking.msg.store.error')); return redirect()->route('user.agenda'); } if (!$appointment->exists) { $this->log->info('[ADVICE] Appointment is duplicated'); Flash::warning(trans('user.booking.msg.store.sorry_duplicated', ['code' => $appointment->code])); return redirect()->route('user.agenda'); } $this->log->info('Appointment saved successfully'); event(new NewBooking($issuer, $appointment)); Flash::success(trans('user.booking.msg.store.success', ['code' => $appointment->code])); return redirect()->route('user.agenda'); }
/** * Lists all Service models. * @return mixed */ public function actionIndex() { $searchModel = new ServiceSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $cat = Category::find()->orderBy('name_pt')->all(); $serv = Service::find()->orderBy('title_pt')->all(); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'cat' => $cat, 'serv' => $serv]); }
public function postDestroy() { $service = Service::find(Input::get('id')); if ($service) { $service->delete(); return Redirect::back()->with('message', 'Элемент удален'); } return Redirect::back()->with('message', "Ошибка"); }
/** * AJAX * Добавляет site_update * Делает рассылку * * @param integer $id - идентификатор услуги * * @return string */ public function actionSubscribe($id) { $item = Service::find($id); if (is_null($item)) { return self::jsonError(101, 'Не найдено послание'); } Subscribe::add($item); SiteUpdate::add($item); $item->update(['is_added_site_update' => 1]); return self::jsonSuccess(); }
public function up() { $this->execute('ALTER TABLE galaxysss_1.gs_services ADD column_name int NULL;'); $rows = \app\models\Service::query()->select(['id', 'date_insert'])->all(); foreach ($rows as $row) { $date = new DateTime($row['date_insert']); \app\models\Service::find($row['id'])->update(['column_name' => $date->format('U')]); } // удаляю старую колонку $this->execute('ALTER TABLE galaxysss_1.gs_services DROP date_insert;'); // переименовываю вновь созданную колонку $this->execute('ALTER TABLE galaxysss_1.gs_services CHANGE column_name date_insert int NULL;'); }
public function actionList() { $params = Yii::$app->request->queryParams; $limit = $params["iDisplayLength"]; $offset = $params["iDisplayStart"]; $sEcho = $params["sEcho"]; $query = Service::find(); $count = $query->count(); $aaData = $query->with(["user" => function ($query) { $query->addSelect(["user_id", "name"]); }])->asArray()->orderBy(['service_id' => SORT_DESC])->limit($limit)->offset($offset)->all(); \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; return ['success' => true, 'aaData' => $aaData, "iTotalRecords" => $count, "iTotalDisplayRecords" => $count, "sEcho" => $sEcho]; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Service::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['catName'] = ['asc' => ['category.name_' . Yii::$app->language => SORT_ASC], 'desc' => ['category.name_' . Yii::$app->language => SORT_DESC]]; $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'); $query->joinWith(['category']); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category_id' => $this->category_id, 'price' => $this->price, 'promo' => $this->promo, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'sku', $this->sku])->andFilterWhere(['like', 'title_en', $this->title_en])->andFilterWhere(['like', 'title_pt', $this->title_pt])->andFilterWhere(['like', 'summary_en', $this->summary_en])->andFilterWhere(['like', 'summary_pt', $this->summary_pt])->andFilterWhere(['like', 'description_en', $this->description_en])->andFilterWhere(['like', 'description_pt', $this->description_pt])->andFilterWhere(['like', 'availability_en', $this->availability_en])->andFilterWhere(['like', 'availability_pt', $this->availability_pt])->andFilterWhere(['like', 'promo_txt_en', $this->promo_txt_en])->andFilterWhere(['like', 'promo_txt_pt', $this->promo_txt_pt]); $query->joinWith(['category' => function ($q) { $q->where('category.name_' . Yii::$app->language . ' LIKE "%' . $this->catName . '%"'); }]); return $dataProvider; }
public function import($services, $deviceIndex) { $subscriptionCount = 0; foreach ($services as $service) { if (isset($service['serviceUuid']) && is_array($service['serviceUuid'])) { $service['serviceUuid'] = $service['serviceUuid'][0]; } if (!($serviceModel = Service::find()->where(array('device' => $deviceIndex, 'serviceUuid' => $service['serviceUuid']))->one())) { $serviceModel = new Service(); } $service = array_merge($service, array('device' => $deviceIndex)); $serviceModel->setAttributes($service); if ($serviceModel->save()) { $serviceIndex = $serviceModel->getPrimaryKey(); if (isset($service['charasteristics'])) { $subscriptionCount += \app\models\Charasteristic::import($service['charasteristics'], $serviceIndex); } } //else { //die(print_r( $serviceModel->getErrors(),true)); //} } return $subscriptionCount; }
public static function branchId($service_id) { return Service::find($service_id)->branch_id; }
public function actionServices_item($id) { return $this->render(['item' => Service::find($id)]); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($yy, $qq, $aa) { $fin = array(); $fm = Helpers::getSetting('first_month'); $m1 = $qq * 3 - 3 + $fm; $y1 = $yy; $m2 = $qq * 3 - 2 + $fm; $y2 = $yy; $m3 = $qq * 3 - 1 + $fm; $y3 = $yy; if ($m2 > 12) { $m2 = $m2 - 12; $y2 = $y2 + 1; } if ($m3 > 12) { $m3 = $m3 - 12; $y3 = $y3 + 1; } if ($aa == "edit") { $perms = Permission::where('user_id', '=', Auth::user()->id)->get(); foreach ($perms as $perm) { if ($perm->preaching or $perm->admin) { $data['authsoc'][] = $perm['society_id']; } } if (!isset($data['authsoc'])) { $aa = "view"; } } $firstDateTime = mktime(0, 0, 0, $m1, 1, $y1); $firstDay = date("N", $firstDateTime); $firstSunday = date("d M Y", mktime(0, 0, 0, $m1, 8 - $firstDay, $y1)); $lastSunday = strtotime($firstSunday); $lastDay = mktime(23, 59, 59, $m3, cal_days_in_month(CAL_GREGORIAN, $m3, $y3), $y3); $extras = Weekday::where('servicedate', '>=', $firstDateTime)->where('servicedate', '<=', $lastDay)->orderBy('servicedate')->get()->toArray(); $data['meetings'] = Meeting::where('meetingdatetime', '<', $lastDay)->where('meetingdatetime', '>', $firstDateTime)->orderBy('meetingdatetime')->get(); $dum['dt'] = $lastSunday; $dum['yy'] = intval(date("Y", $lastSunday)); $dum['mm'] = intval(date("n", $lastSunday)); $dum['dd'] = intval(date("j", $lastSunday)); $sundays[] = $dum; $data['societies'] = Society::orderBy('society')->with('service')->get(); $data['ministers'] = Minister::has('individual')->get(); $data['preachers'] = Preacher::has('individual')->get(); $data['guests'] = Guest::where('active', '=', 1)->get(); while (date($lastSunday + 604800 <= $lastDay)) { $lastSunday = $lastSunday + 604800; $dum['dt'] = $lastSunday; $dum['yy'] = intval(date("Y", $lastSunday)); $dum['mm'] = intval(date("n", $lastSunday)); $dum['dd'] = intval(date("j", $lastSunday)); $sundays[] = $dum; } if (count($extras)) { $xco = 0; for ($q = 0; $q < count($sundays); $q++) { if ($xco < count($extras) and $extras[$xco]['servicedate'] < $sundays[$q]['dt']) { $dum['dt'] = $extras[$xco]['servicedate']; $dum['yy'] = intval(date("Y", $extras[$xco]['servicedate'])); $dum['mm'] = intval(date("n", $extras[$xco]['servicedate'])); $dum['dd'] = intval(date("j", $extras[$xco]['servicedate'])); $data['sundays'][] = $dum; $xco++; $q = $q - 1; } else { $data['sundays'][] = $sundays[$q]; } } } else { $data['sundays'] = $sundays; } $pm1 = Plan::where('planyear', '=', $y1)->where('planmonth', '=', $m1)->get(); foreach ($pm1 as $p1) { $soc = Society::find($p1->society_id)->society; $ser = Service::find($p1->service_id)->servicetime; if ($p1->preachable) { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['preacher'] = substr($p1->preachable_type, 11, 1) . "_" . $p1->preachable->id); if ($p1->preachable_type == "App\\Models\\Guest") { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['pname'] = substr($p1->preachable->firstname, 0, 1) . " " . $p1->preachable->surname); } else { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['pname'] = substr($p1->preachable->individual->firstname, 0, 1) . " " . $p1->preachable->individual->surname); } } else { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['preacher'] = ""); } if ($p1->tag_id) { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tag'] = $p1->tag_id); @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tname'] = Tag::find($p1->tag_id)->abbr); } else { @($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tag'] = ""); } } $pm2 = Plan::where('planyear', '=', $y2)->where('planmonth', '=', $m2)->get(); foreach ($pm2 as $p2) { $soc = Society::find($p2->society_id)->society; $ser = Service::find($p2->service_id)->servicetime; if ($p2->preachable) { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['preacher'] = substr($p2->preachable_type, 11, 1) . "_" . $p2->preachable->id); if ($p2->preachable_type == "App\\Models\\Guest") { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['pname'] = substr($p2->preachable->firstname, 0, 1) . " " . $p2->preachable->surname); } else { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['pname'] = substr($p2->preachable->individual->firstname, 0, 1) . " " . $p2->preachable->individual->surname); } } else { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['preacher'] = ""); } if ($p2->tag_id) { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tag'] = $p2->tag_id); @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tname'] = Tag::find($p2->tag_id)->abbr); } else { @($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tag'] = ""); } } $pm3 = Plan::where('planyear', '=', $y3)->where('planmonth', '=', $m3)->get(); foreach ($pm3 as $p3) { $soc = Society::find($p3->society_id)->society; $ser = Service::find($p3->service_id)->servicetime; if ($p3->preachable) { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['preacher'] = substr($p3->preachable_type, 11, 1) . "_" . $p3->preachable->id); if ($p3->preachable_type == "App\\Models\\Guest") { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['pname'] = substr($p3->preachable->firstname, 0, 1) . " " . $p3->preachable->surname); } else { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['pname'] = substr($p3->preachable->individual->firstname, 0, 1) . " " . $p3->preachable->individual->surname); } } else { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['preacher'] = ""); } if ($p3->tag_id) { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tag'] = $p3->tag_id); @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tname'] = Tag::find($p3->tag_id)->abbr); } else { @($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tag'] = ""); } } $data['tags'] = Tag::orderBy('abbr')->get(); if ($qq == 1) { $data['prev'] = "plan/" . strval($yy - 1) . "/4"; } else { $data['prev'] = "plan/{$yy}/" . strval($qq - 1); } if ($qq == 4) { $data['next'] = "plan/" . strval($yy + 1) . "/1"; } else { $data['next'] = "plan/{$yy}/" . strval($qq + 1); } if ($aa == "edit") { return View::make('plans.edit', $data); } else { $data['pb'] = Helpers::getSetting('presiding_bishop'); if (!$data['pb']) { return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the Presiding Bishop'); } $data['gs'] = Helpers::getSetting('general_secretary'); if (!$data['gs']) { return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the General Secretary'); } $data['db'] = Helpers::getSetting('district_bishop'); if (!$data['db']) { return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the District Bishop'); } $data['super'] = Individual::find(Helpers::getSetting('superintendent')); if (!$data['super']) { return view('errors.errors')->with('errormessage', 'Before you can view the plan, please specify who the Circuit Superintendent is'); } $this->report($data); } }
public function storeServiceOrder(ServiceOrder $serviceOrder, StoreServiceOrder $request) { $status = ServiceStatus::where('is_first', Order::IS_FIRST)->first(); $user = Auth::user(); $service = Service::find($request->service_id); $serviceOrder->service_status_id = $status->id; $serviceOrder->user_id = $user->id; $serviceOrder->firm_id = $user->firm->id; $serviceOrder->service_name = $service->short_name; $serviceOrder->service_price = $service->price; $serviceOrder->more_info = $request->more_info; if ($request->need_station) { $serviceOrder->station_names = $request->station_names; } $serviceOrder->save(); $messageParams['service'] = $serviceOrder; Bus::dispatch(new SendWithTanksForServiceOrder($messageParams)); return view('orders.serviceSuccess', ['p' => 'purchases', 'serviceName' => $service->short_name]); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $service = Service::find($id); $service->delete(); //Region::destroy($id); return back()->with('alert-success', 'Услуга ' . $service->short_name . ' удалена'); }
/** * Get service by ID * * @return json */ public function getServiceById($id) { return Service::find($id); }
/** * Рисует услугу * * @param integer|array $row * * @return string */ public static function serviceItem($row) { if (!is_array($row)) { $id = $row; $item = Service::find($id); if (is_null($item)) { return ''; } $row = $item->getFields(); } $header = isset($row['header']) ? $row['header'] : $row['name']; // Заголовок $html[] = Html::tag('div', Html::tag('h2', $header), ['class' => 'header']); // Ссылка $l = ['page/services_item', 'id' => $row['id']]; $html[] = Html::tag('p', Html::a(Html::img($row['image'], ['width' => '100%', 'class' => 'thumbnail']), $l)); // Описание $html[] = $row['description']; return Html::tag('div', join('', $html), ['class' => 'col-lg-4 serviceItem']); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($soc_id, $id) { $service = Service::find($id); $service->delete(); return Redirect::back()->with('okmessage', 'Preacher has been deleted'); }
public function generatePdf($id) { $data['service'] = Service::find($id); $pdf = PDF::loadView('services/pdf', $data); return $pdf->stream(); }