public function actionIndex()
{
$query = Event::find();
$pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]);
$events = $query->orderBy('date')->offset($pagination->offset)->limit($pagination->limit)->all();
return $this->render('index', ['events' => $events, 'pagination' => $pagination]);
}
public function actionOtchet()
{
$this->layout = false;
$poisk1 = Yii::$app->request->post('from_date');
$poisk2 = Yii::$app->request->post('to_date');
return $this->render('otchet', ['model' => Event::find()->where(['between', 'date_event', $poisk1, $poisk2])->orderBy('date_event, time_event')->all(), 'poisk1' => $poisk1, 'poisk2' => $poisk2]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::find();
if (\Yii::$app->user->isGuest) {
return null;
}
$user = \Yii::$app->user->identity;
if (!$user->admin && count($user->organisations) == 0) {
return null;
} else {
if (!$user->admin) {
$organisations = $user->organisations;
foreach ($organisations as $organisation) {
$query->orWhere(['owner_id' => $organisation->id]);
}
}
}
$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(['id' => $this->id, 'owner_id' => $this->owner_id, 'start_time' => $this->start_time, 'end_time' => $this->end_time]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'summary', $this->summary]);
return $dataProvider;
}
/**
* Lists all Event models.
* @return mixed
*/
public function actionIndex($id = null)
{
//Check user level & existence of $id
$id = Yii::$app->user->identity->level == 0 && $id != null ? $id : Yii::$app->user->id;
//$searchModel = new EventSearch();
//$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', ['events' => Event::find()->where('FIND_IN_SET(' . $id . ', shared_with)')->orWhere('user_id=' . $id)->all()]);
}
/**
* Выводит событие
*
* @param int $id идентификатор события
*
* @return string
* @throws \cs\web\Exception
*/
public function actionEvents_item($id)
{
$item = Event::find($id);
if (is_null($item)) {
throw new Exception('Событие не найдено');
}
return $this->render(['item' => $item]);
}
public function getRoom($eventId)
{
$event = Event::find($eventId);
$room = $event->room;
if (!$room) {
return $this->respondNotFound('Room Not Found!');
}
return $this->respond([$room->toArray()]);
}
public function eventPost($id)
{
//
$event = Event::find($id);
$posts = $event->posts;
$response = new \stdClass();
$response->success = true;
$response->total = count($posts);
$response->data = $posts;
return response()->json($response);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
//dd(Input::get('data'));
$data = Input::get('data');
foreach ($data as $key => $value) {
if (Event::find($value['id']) != null) {
Event::find($value['id'])->update(['title' => $value['title'], 'start' => $value['start'], 'end' => $value['end']]);
} else {
Event::create(array('title' => $value['title'], 'start' => $value['start'], 'end' => $value['end']));
}
}
}
/**
* Lists all Event models.
* @return mixed
*/
public function actionIndex()
{
$events = Event::find()->all();
$tasks = [];
foreach ($events as $eve) {
$event = new \yii2fullcalendar\models\event();
$event->id = $eve->id;
$event->title = $eve->title;
$event->start = $eve->created_date;
$tasks[] = $event;
}
return $this->render('index', ['events' => $tasks]);
}
/**
* AJAX
* Добавляет site_update
* Делает рассылку
*
* @param integer $id - идентификатор события
*
* @return string
*/
public function actionSubscribe($id)
{
$item = \app\models\Event::find($id);
if (is_null($item)) {
return self::jsonError(101, 'Не найдено событие');
}
$start = microtime(true);
Subscribe::add($item);
SiteUpdate::add($item);
$item->update(['is_added_site_update' => 1]);
\Yii::info(microtime(true) - $start, 'gs\\actionSubscribe');
return self::jsonSuccess();
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::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(['id' => $this->id, 'created_date' => $this->created_date]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::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(['id' => $this->id, 'start' => $this->start, 'finish' => $this->finish, 'is_allday' => $this->is_allday, 'created' => $this->created]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'roomid', $this->roomid])->andFilterWhere(['like', 'note', $this->note]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'start' => $this->start, 'end' => $this->end, 'active' => $this->active]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request, $eventId)
{
$input = Input::except('token');
$roomId = Event::find($eventId)->room->id;
$tableType = $table = new Table();
$validator = $table->getValidator($input);
if ($validator->fails()) {
return $this->respondInvalidData($validator->errors());
}
$table->fill($input);
$table->room_id = $roomId;
$table->save();
return $this->respondCreateSuccess('Table: ' . $table->table_name . ' created');
}
public function validateTime1($attribute)
{
if (!$this->hasErrors()) {
if ($this->isNewRecord) {
$timeprov = Event::find()->where(['date_event' => $this->date_event, 'id_zal' => $this->id_zal])->all();
foreach ($timeprov as $timeprovdet) {
$t = explode(' - ', $timeprovdet->time_event);
if ($this->time_c >= $t[0] and $this->time_c <= $t[1]) {
$this->addError($attribute, 'В это время зал занят');
}
}
}
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params, $today)
{
$query = Event::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['date_event' => SORT_DESC, 'time_event' => SORT_ASC]]]);
$dataProvider->pagination->pageSize = 10;
$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(['id' => $this->id, 'id_zal' => $this->id_zal, 'id_client' => $this->id_client, 'id_users' => $this->id_users, 'id_users1' => $this->id_users1, 'date_event' => $this->date_event, 'status' => $this->status, 'updated_at' => $this->updated_at, 'created_at' => $this->created_at]);
$query->andFilterWhere(['like', 'name_event', $this->name_event])->andFilterWhere(['like', 'oborud', $this->oborud])->andFilterWhere(['like', 'time_event', $this->time_event])->andFilterWhere(['like', 'kofebrayk', $this->kofebrayk])->andFilterWhere(['like', 'furshet', $this->furshet])->andFilterWhere(['like', 'dopinfo', $this->dopinfo])->andFilterWhere(['like', 'date_event', $today]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'event', $this->event])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'text', $this->text])->andFilterWhere(['like', 'type', $this->type]);
return $dataProvider;
}
public static function getUserEvents(UserId $uid, $sort = true)
{
if ($sort) {
$e = Event::find()->where(['event_owner' => $uid->getId()])->orderBy(['date' => SORT_DESC])->all();
} else {
$e = Event::findAll(['event_owner' => $uid->getId()]);
}
$events = [];
foreach ($e as $event) {
$type = EEvent::search($event->event_type);
$uconnected = $event->event_user_connected == null ? null : new UserId($event->event_user_connected);
$ev = new UserEvent($event->event_id, EEvent::$type(), $uid, new \DateTime($event->date), $uconnected, $event->event_data_connected);
$events[] = $ev;
}
return $events;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'allDay' => $this->allDay, 'start' => $this->start, 'end' => $this->end, 'editable' => $this->editable]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'dow', $this->dow])->andFilterWhere(['like', 'className', $this->className])->andFilterWhere(['like', 'source', $this->source])->andFilterWhere(['like', 'color', $this->color])->andFilterWhere(['like', 'backgroundColor', $this->backgroundColor])->andFilterWhere(['like', 'borderColor', $this->borderColor])->andFilterWhere(['like', 'textColor', $this->textColor]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Event::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'jadwal' => $this->jadwal]);
$query->andFilterWhere(['like', 'nama', $this->nama])->andFilterWhere(['like', 'deskripsi', $this->deskripsi]);
return $dataProvider;
}
/**
* Creates a new Peserta model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Peserta();
$this->layout = 'frontend.php';
if ($model->load(Yii::$app->request->post()) && $model->save()) {
$subject = "Pendaftaran Seminar di Unpar Career Expo";
$content = "Dear {$model->nama}, <br>\n Terima kasih telah mendaftar di seminar Unpar Career Expo November 2015. <br>\n Berikut adalah daftar seminar yang Anda ikuti:<br><br>\n <ul>\n ";
foreach ($model->eventsData as $event) {
$content .= "<li><span class='event-detail'><b>{$event->nama}</b><br>{$event->deskripsi}<br><small>{$event->jadwal}</small></span><br><br></li>";
}
$content .= "</ul><br><br>\n <b>Lokasi Seminar: </b><br>\n Universitas Katolik Parahyangan <br>\n Jl. Ciumbuleuit No. 94 <br>\n Bandung - 40141 <br>\n Gedung Rektorat <br>\n Ruang Operation Room <br><br>\n Sampai jumpat di acara seminarnya. Jika memerlukan bantuan silakan hubungi kami di:<br>\n +62-22-2032655 ext. 100120 / 100126 <br>\n Dian - 0857 4105 3212<br><br>\n Best regards,<br>Panitia Unpar Career Expo & Seminar";
Yii::$app->mailer->compose()->setFrom(Yii::$app->params['adminEmail'])->setHtmlBody($content)->setSubject($subject)->setTo($model->email)->send();
Yii::$app->session->setFlash('success', 'Pendaftaran berhasil! Terima kasih.');
return $this->refresh();
} else {
$model_event = Event::find()->all();
return $this->render('create', ['model' => $model, 'model_event' => $model_event]);
}
}
public function actionAdmin()
{
$this->layout = 'admin';
$searchModel = new EventSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$dataProvider->sort->defaultOrder = ['id' => 'DESC'];
$models = Event::find()->with('room')->all();
//var_dump($models);
$events = array();
foreach ($models as $value) {
$event = new \yii2fullcalendar\models\Event();
//$event->id = $value->id;
$event->title = $value->title . ' ห้อง ' . $value->room->roomnum;
$event->start = date('Y-m-d', strtotime($value->start));
$event->end = date('Y-m-d', strtotime('+1 day', strtotime($value->finish)));
$event->color = $value->room->color;
$events[] = $event;
}
return $this->render('admin', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'events' => $events]);
}
/**
* Delete a Manager of an Event.
*
* @param Request $request
* @param int $eid
* @param int $uid
* @return Response
*/
public function destroy(Request $request, $eid, $uid)
{
try {
$user = $this->isEventManager($request, $eid);
if (!$user) {
return response()->error(403, 'You are not a manager of this event!');
}
$event = Event::find($eid);
if (!$event) {
return response()->error(404, 'Event Not Found');
}
$user = User::find($uid);
if (!$user) {
return response()->error(404, 'User Not Found');
}
$event->managers()->detach($user);
return response()->success();
} catch (Exception $e) {
return response()->error();
}
}
/**
* Delete a Passenger of an Event Vehicle.
*
* @param Request $request
* @param int $eid
* @param int $vid
* @param int $pid
* @return Response
*/
public function destroy(Request $request, $eid, $vid, $pid)
{
try {
$event = Event::find($eid);
if (!$event) {
return response()->error(404, 'Event Not Found');
}
$vehicle = EventVehicle::find($vid);
if (!$vehicle) {
return response()->error(404, 'Vehicle Not Found');
}
$profile = Profile::find($pid);
if (!$profile) {
return response()->error(404, 'Profile Not Found');
}
$vehicle->passengers()->detach($profile);
$vehicle->decrement('passenger_count');
return response()->success();
} catch (Exception $e) {
return response()->error($e);
}
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create($event_id)
{
$event = Event::find($event_id);
if ($event->cancelled || empty($event)) {
Session::flash('message', 'Evento cancelado');
Session::flash('alert-class', 'alert-warning');
return redirect('promoter/event/record');
}
$amountAccumulated = $event->amountAccumulated();
$amountComission = $amountAccumulated * $event->percentage_comission / 100;
$totalToPay = $amountAccumulated - $amountComission;
$paid = Payment::where("event_id", $event_id)->sum('paid');
$debt = 0;
if ($totalToPay > $paid) {
$debt = $totalToPay - $paid;
}
if ($debt <= 0) {
Session::flash('message', 'No se puede transferir, tiene deuda igual a cero');
Session::flash('alert-class', 'alert-warning');
return redirect('promoter/event/record');
}
$objs = array("event" => $event, "amountAccumulated" => $amountAccumulated, "benefit" => $amountComission, "totalToPay" => $totalToPay, "paid" => $paid, "debt" => $debt);
return view('internal.promoter.payment.create', $objs);
}
public function cancelStorage(StorePresentationRequest $request, $presentation_id)
{
$user_id = Auth::user()->id;
$input = $request->all();
$presentation = Presentation::findOrFail($presentation_id);
$presentation->cancelled = "1";
$presentation->save();
$event = Event::find($presentation->event_id);
if ($event->presentations->isEmpty()) {
$event->cancelled = true;
$event->save();
}
$cancel = new CancelPresentation();
$cancel->presentation_id = $presentation_id;
$cancel->user_id = $user_id;
$cancel->reason = $input['reason'];
$cancel->duration = $input['duration'];
$cancel->authorized = $input['authorized'];
$cancel->date_refund = $input['date_refund'];
$cancel->save();
Session::flash('message', 'La presentación se ha cancelado!');
Session::flash('alert-class', 'alert-success');
return redirect('/promoter/presentation/cancelled');
}
public function store(StoreBookingRequest $request)
{
$event = Event::find($request['event_id']);
$zone = Zone::find($request['zone_id']);
$nTickets = $request['quantity'];
$codigo_reserva = uniqid();
$seats_array = array();
if ($event->place->rows != null) {
//Es numerado
$seats = $request['seats'];
$seats = $this->getSelectedSlots($seats, $zone->id);
foreach ($seats as $seat_id) {
$slot = DB::table('slot_presentation')->where('slot_id', $seat_id)->where('presentation_id', $request['presentation_id'])->first();
array_push($seats_array, Slot::where('id', $seat_id)->get()->first());
if ($slot->status != config('constants.seat_available')) {
return back()->withInput($request->except('seats'))->withErrors(['El asiento ' . $seat_id . ' no esta libre']);
}
}
} else {
//No es numerado
$zoneXpres = DB::table('zone_presentation')->where('zone_id', $request['zone_id'])->where('presentation_id', $request['presentation_id'])->first();
if ($zoneXpres->slots_availables - $nTickets < 0) {
//Deberia ser zona x presentacion
return back()->withInput($request->except('seats'))->withErrors(['La zona esta llena']);
}
}
DB::beginTransaction();
try {
$tickets = array();
for ($i = 0; $i < $nTickets; $i++) {
if ($event->place->rows != null) {
//Cambiar estado de asiento
$seat = DB::table('slot_presentation')->where('slot_id', $seats[$i])->where('presentation_id', $request['presentation_id'])->sharedLock();
//Revisa de nuevo
$seat = DB::table('slot_presentation')->where('slot_id', $seats[$i])->where('presentation_id', $request['presentation_id'])->first();
if ($seat->status != config('constants.seat_available')) {
return back()->withInput($request->except('seats'))->withErrors(['El asiento ' . $seat_id . ' no esta libre']);
}
DB::table('slot_presentation')->where('slot_id', $seats[$i])->where('presentation_id', $request['presentation_id'])->update(['status' => config('constants.seat_reserved')]);
} else {
//Disminuir capacidad en la zona de esa presentacion
DB::table('zone_presentation')->where('zone_id', $request['zone_id'])->where('presentation_id', $request['presentation_id'])->sharedLock();
$zoneXpres = DB::table('zone_presentation')->where('zone_id', $request['zone_id'])->where('presentation_id', $request['presentation_id'])->first();
if ($zoneXpres->slots_availables - $nTickets < 0) {
return back()->withInput($request->except('seats'))->withErrors(['La zona esta llena']);
}
DB::table('zone_presentation')->where('zone_id', $request['zone_id'])->where('presentation_id', $request['presentation_id'])->decrement('slots_availables');
}
}
//Crear ticket
$id = DB::table('tickets')->insertGetId(['payment_date' => null, 'reserve' => $codigo_reserva, 'cancelled' => 0, 'owner_id' => \Auth::user()->id, 'event_id' => $request['event_id'], 'price' => $zone->price, 'presentation_id' => $request['presentation_id'], 'zone_id' => $request['zone_id'], 'promo_id' => null, 'quantity' => $nTickets, 'salesman_id' => null, 'picked_up' => false, 'discount' => null, 'designee' => \Auth::user()->di, 'total_price' => $zone->price * $nTickets, 'created_at' => new Carbon(), 'updated_at' => new Carbon()]);
if ($request['dni_recojo'] != null) {
DB::table('tickets')->where('id', $id)->update(['designee' => $request['dni_recojo']]);
}
if ($event->place->rows != null) {
//Asignar id en caso sea numerado
for ($i = 0; $i < $nTickets; $i++) {
DB::table('slot_presentation')->where('slot_id', $seats[$i])->where('presentation_id', $request['presentation_id'])->update(['sale_id' => $id]);
}
}
array_push($tickets, $id);
DB::commit();
} catch (\Exception $e) {
//dd('rollback');
DB::rollback();
return back()->withInput($request->except('seats'))->withErrors(['Por favor intentelo nuevamente']);
}
$presentation = Presentation::find($request->input('presentation_id'));
session(['tickets' => $tickets]);
$array = ['event' => $event, 'zone' => $zone, 'cant' => $nTickets, 'eventDate' => date("d-m-Y h:i:s a", $presentation->starts_at), 'codigo' => $codigo_reserva, 'seats' => ''];
if ($event->place->rows != null) {
$array['seats'] = $seats_array;
}
return view('external.booking.results', $array);
//return $array['seats'][0]->row ;
}
</div>
</div>
<br>
<div class="body-content">
<div class="row">
<div class="col-lg-12">
<?php
$idUser = Yii::$app->user->identity->id;
$event = Event::find()->where(['idUser' => $idUser])->orderBy('Date')->all();
if (count($event) == 0) {
echo '<div class="col-lg-12 notEvent">У вас еще нет добавленных событий!</div>';
} else {
echo '<table class="table table-striped">';
echo ' <thead>';
echo ' <tr>';
echo ' <th>№</th>';
echo ' <th>Событие</th>';
echo ' <th>Дата</th>';
echo ' <th>Удалить</th>';
echo ' </tr>';
echo ' </thead>';
}
echo '<tbody>';
for ($i = 0; $i < count($event); $i++) {
public function postEdit(EventReq $req)
{
$event = Event::find($req->id);
try {
$event->fill($req->except('_token'));
$event->save();
return $this->edit('general', $event);
} catch (InvalidModelException $e) {
return redirect()->back()->withInput($req->except($req->dontFlash))->withErrors($e->getErrors(), 'default');
}
}
/**
* Delete a Vehicle of an Event.
*
* @param VehicleRequest $request
* @param int $eid
* @param int $vid
* @return Response
*/
public function destroy(VehicleRequest $request, $eid, $vid)
{
try {
$user = $this->isEventManager($request, $eid);
if (!$user) {
return response()->error(403, 'You are not a manager of this event!');
}
$event = Event::find($eid);
if (!$event) {
return response()->error(404, 'Event Not Found');
}
$vehicle = EventVehicle::find($vid);
if (!$vehicle) {
return response()->error(404, 'Vehicle Not Found');
}
$vehicle->delete();
return response()->success();
} catch (Exception $e) {
return response()->error();
}
}
