public function getByDate(Carbon $date) { $return = null; if (isset($this->workingDays[$date->toDateString()])) { $return = $this->workingDays[$date->toDateString()]; } return $return; }
private function addSlotsForDay(Carbon $day) { $result = ''; $courts = [3, 4, 5, 6]; $hours = [15, 16, 17, 18]; foreach ($courts as $key => $court) { foreach ($hours as $key => $hour) { if (!Slot::where('day', $day->toDateString())->where('court', $court)->where('hour', $hour)->count()) { $result .= $day->toDateString() . ', Bana ' . $court . ', kl ' . $hour . ':00 tillagd som slot.<br/>'; Slot::create(['day' => $day->toDateString(), 'hour' => $hour, 'court' => $court]); } } } return $result; }
public function store($projectId, Request $request) { $date = new Carbon($request->date); $project = Project::findOrFail($projectId); $project->costEstimations()->create(['settled_at' => $date]); return redirect()->route('projects.cost-estimations.show', [$projectId, $date->toDateString()]); }
/** * Pay billet by billet id. * * @param int $billet_id * @param Carbon $date * * @return Billet */ public function pay($billet_id, Carbon $date) { $model = $this->model; $billet = $model->find($billet_id); if (!is_null($billet->discharge_date)) { throw new RepositoryException("You can't pay this billet"); } $billet->discharge_date = $date->toDateString(); $billet->save(); return $billet; }
public function index(Request $request) { $now = new Carbon(); if ($request->isMethod('post')) { $from = new Carbon($request->input('from', $now->toDateString())); $to = new Carbon($request->input('to', $now->toDateString())); $lessons = \App\Lesson::orderBy('given_at', 'asc')->where('given_at', '>=', $from->startOfDay()->toDateTimeString())->where('given_at', '<=', $to->endOfDay()->toDateTimeString())->get(); } else { $lessons = \App\Lesson::orderBy('given_at', 'asc')->get(); } $groups = \App\CustomerGroup::orderBy('groupname', 'desc')->get(); return view('lesson.index')->with(['lessons' => $lessons, 'groups' => $groups, 'now' => $now->toDateString(), 'from' => isset($from) ? $from->toDateString() : '', 'to' => isset($to) ? $to->toDateString() : '']); }
public function filterByDate(Carbon $date) { $lists = $this->listService->all(); $todayTasks = new ArrayList(); foreach ($lists as $list) { $tasks = new ArrayList($this->forList($list)); $listTasks = $tasks->filter(function (Task $task) use($date) { if ($task->getDueDate()) { $taskDate = Carbon::instance($task->getDueDate()); return $taskDate->toDateString() === $date->toDateString(); } }); $todayTasks->concat($listTasks); } return $todayTasks; }
public function testRegister() { $birthday = new Carbon(); $birthday->addYear(-23); $this->visit('/auth/register')->type('user1', 'name')->type('*****@*****.**', 'email')->type('useruser', 'password')->type('useruser', 'password_confirmation')->type($birthday->toDateTimeString(), 'bdate')->select('1', 'gender')->type('2000', 'daily_calories'); $map = []; $restrictions = Restriction::all(); foreach ($restrictions as $restriction) { $val = round(mt_rand() / mt_getrandmax()); $map[$restriction->id] = $val; $this->type($val + 1, 'restriction' . ($restriction->id + 1)); } $this->press('Register')->seePageIs('/home'); $this->seeInDatabase('users', ['name' => 'user1', 'email' => '*****@*****.**', 'bdate' => $birthday->toDateString(), 'gender' => '0', 'daily_calories' => '2000']); $user = \App\User::whereEmail('*****@*****.**')->first(); foreach ($restrictions as $restriction) { if ($map[$restriction->id] == 1) { $this->seeInDatabase('restriction_user', ['user_id' => $user->id, 'restriction_id' => $restriction->id]); } } }
/** * Scope of date. * * @param Illuminate\Database\Query $query * @param Carbon $date * * @return Illuminate\Database\Query */ public function scopeOfDate($query, Carbon $date) { $date->timezone('UTC'); return $query->whereRaw('date(`start_at`) = ?', [$date->toDateString()]); }
protected function getDate($value) { if ($value) { $d = new Carbon($value); return $d->toDateString(); } else { return null; } }
require_once 'vendor/autoload.php'; use Carbon\Carbon; use Citco\Carbon as CitcoCarbon; use CarbonExt\FiscalYear\Calculator; // Object Instantiation $brisbane = new Carbon('2015-12-01', 'Australia/Brisbane'); $newYorkCity = new Carbon('2015-12-01', 'America/New_York'); $dtBerlin = new Carbon('2015-12-01', 'Europe/Berlin'); $outputString = "Time difference between %s & %s: %s hours.\n"; // Date difference printf($outputString, "Berlin", "Brisbane, Australia", $dtBerlin->diffInHours($brisbane, false)); printf($outputString, "Berlin", "New York City, America", $dtBerlin->diffInHours($newYorkCity, false)); $septEighteen2014 = Carbon::createFromDate(2014, 9, 18, $dtBerlin->getTimezone()); printf("difference between now and %s in \n\thours: %d, \n\tdays: %d, \n\tweeks: %d, \n\tweekend days: %d, \n\tweek days: %s, \n\thuman readable: %s\n", $septEighteen2014->toFormattedDateString(), $dtBerlin->diffInHours($septEighteen2014), $dtBerlin->diffInDays($septEighteen2014), $dtBerlin->diffInWeeks($septEighteen2014), $dtBerlin->diffInWeekendDays($septEighteen2014), $dtBerlin->diffInWeekDays($septEighteen2014), $dtBerlin->diffForHumans($septEighteen2014)); // Date formatting echo $dtBerlin->toDateString() . "\n"; echo $dtBerlin->toFormattedDateString() . "\n"; echo $dtBerlin->toTimeString() . "\n"; echo $dtBerlin->toDateTimeString() . "\n"; echo $dtBerlin->toDayDateTimeString() . "\n"; echo $dtBerlin->toRfc1036String() . "\n"; echo $dtBerlin->toAtomString() . "\n"; echo $dtBerlin->toCookieString() . "\n"; echo $dtBerlin->toRssString() . "\n"; $dtBerlin->setToStringFormat('l jS \\of F Y'); echo $dtBerlin . "\n"; echo (int) $dtBerlin->isLeapYear() . "\n"; // is* range of functions test printf("Is yesterday? %s\n", $dtBerlin->isYesterday() ? "yes" : "no"); printf("Is a Thursday? %s\n", $dtBerlin->isThursday() ? "yes" : "no"); printf("Is in the future? %s\n", $dtBerlin->isFuture() ? "yes" : "no");
public function test_suspend_company_with_command_on_expiration_date() { $expirationDate = new Carbon('2017-06-30'); $company = factory(Company::class)->create(); $user = factory(User::class, 'admin')->create(); $this->actingAs($user)->visit('/company/' . $company->id . '/edit')->see($company->name)->see('name="licence_expire_at"')->type($expirationDate->toDateString(), 'licence_expire_at')->press('Save Edit')->seeInDatabase('companies', ['id' => $company->id, 'licence_expire_at' => $expirationDate->toDateString(), 'is_suspended' => false])->seeInDatabase('schedules', ['who_object' => Company::class, 'who_id' => $company->id, 'run_at' => $expirationDate->toDateString(), 'action' => ActionCommandSuspendCompanyCommand::class]); // enter to testing time - set date to be expiration date Carbon::setTestNow($expirationDate); $company = Company::findOrFail($company->id); $this->assertEquals(false, $company->is_suspended); $results = \App\Model\ActionQueue\ActionCommandScheduled::run(); $company = Company::findOrFail($company->id); $this->assertEquals(true, $company->is_suspended); // exit from testing time - reset current time Carbon::setTestNow(); }
public function sendEmailContact(Request $request) { $email = userAdmin::where('identidad', $request->identidad)->first(); $ent = entidadTuristica::where('rif', $request->identidad)->first(); $camas = new camas(); $hab = new habitacion(); $email = $email->email; // Buscando habitaciones para el email de respaldo de la persona // todo este codigo deberia estar en una función aparte -- mejorar modularidad en codigo para futuros proyectos. $legalMessage = ""; $f = ""; $f2 = ""; if ($ent->tipoentidad == "Hotel") { $habitaciones = habitacion::where('identidad', $request->identidad)->get(); $camas = $camas->camasPorHabitacion($habitaciones); $habitaciones = $hab->serviciosOrdenados($habitaciones); $desde = Carbon::now(); $desdeInicio = Carbon::create($desde->year, $desde->month, 1); $desdeFin = Carbon::create($desde->year, $desde->month, $desde->daysInMonth); $desdeInicio = $desdeInicio->toDateString(); $desdeFin = $desdeFin->toDateString(); $dias = 1; $legalMessage = "NOTA: Las tarifas son validas desde el " . $desdeInicio . " hasta el " . $desdeFin . " y las mismas estan sujetas a cambios."; if (Session::has('fecha')) { $fecha = explode(" - ", Session::get('fecha')); $f = new Carbon($fecha[0]); $f2 = new Carbon($fecha[1]); $dias = $f->diffInDays($f2); $query = " SELECT idperfilhabitacion FROM habitacionesperfil WHERE id NOT IN ( SELECT disponibilidad.idhabitacion from disponibilidad WHERE (estado = 'Habilitado')\n AND ((disponibilidad.fecha_inicio BETWEEN '" . $fecha[0] . "' AND '" . $fecha[1] . "')\n OR (disponibilidad.fecha_fin BETWEEN '" . $fecha[0] . "' AND '" . $fecha[1] . "')\n OR ( ('" . $fecha[0] . "' >= disponibilidad.fecha_inicio) AND ('" . $fecha[1] . "' <= disponibilidad.fecha_fin) ) ) ) "; $search = DB::select(DB::raw($query)); $arraySearch = []; foreach ($search as $s) { array_push($arraySearch, $s->idperfilhabitacion); } foreach ($habitaciones as $h) { $h['disponible'] = in_array($h->id, $arraySearch); } } foreach ($habitaciones as $h) { $h['total'] = $dias * $h['tarifa']; } } else { $habitaciones = null; } $data = ['nombre' => $request->nombre, "email" => $request->email, "telefono" => $request->telefono, "mensaje" => $request->mensaje]; $data2 = ['habitaciones' => $habitaciones, 'legalMessage' => $legalMessage, 'nombreEntidad' => $ent->nombre, 'f' => $f->toDateString(), 'f2' => $f2->toDateString()]; $response; $statusCode; try { Mail::send('emails.contacto', $data, function ($message) use($email) { $message->from(env('MAIL_USERNAME'), 'AppHoteles'); $message->subject('Contacto - AppHoteles'); // Aqui iria el titulo... $message->to($email); }); Mail::send('emails.usuarioContacto', $data2, function ($message) use($request) { $message->from(env('MAIL_USERNAME'), 'AppHoteles'); $message->subject('Contacto - AppHoteles'); // Aqui iria el titulo... $message->to($request->email); }); $response = ['success' => true, 'message' => 'Email enviado.']; $statusCode = 200; } catch (Exception $e) { $response = ["error" => $e->getMessage()]; $statusCode = 400; } finally { return Response::json($response, $statusCode); } }
public function getByDate(Carbon $date) { $repo = $this->em->getRepository('JGimeno\\TaskReporter\\Domain\\Entity\\WorkingDay'); $return = $repo->findOneByDate($date->toDateString()); return $return; }
/** * @param $bwDate * @param $ewDate * * @return string */ protected function buildTimeCardRangeVar(Carbon $bwDate, Carbon $ewDate) { $timeCardRange = '( ' . $bwDate->toDateString() . ' - ' . $ewDate->toDateString() . ' )'; return $timeCardRange; }
/** * @param $data * @return array */ private function buildPayload($data) { $payload = ['id' => (int) $data[0], 'name' => trim($data[1]), 'account_type_id' => (int) $data[2], 'account_status_id' => (int) $data[3], 'contact_name' => trim($data[16])]; $unformattedAddress = ['line1' => trim($data[7]), 'line2' => trim($data[8]), 'city' => trim($data[9]), 'state' => trim($data[10]), 'county' => trim($data[11]), 'zip' => trim($data[12]), 'country' => trim($data[13]), 'latitude' => trim($data[14]), 'longitude' => trim($data[15])]; $formattedAddress = $this->addressFormatter->formatAddress($unformattedAddress, false); $payload = array_merge($payload, $formattedAddress); /** * We don't do a ton of validation here, as the API call will fail if this data is invalid anyway. */ if (trim($data[4])) { $payload['account_groups'] = explode(",", trim($data[4])); } if (trim($data[5])) { $payload['sub_accounts'] = explode(",", trim($data[5])); } if (trim($data[6])) { $carbon = new Carbon($data[6]); $now = Carbon::now(); if ($carbon->gt($now)) { $payload['next_bill_date'] = trim($carbon->toDateString()); } } if (trim($data[17])) { $payload['role'] = trim($data[17]); } if (trim($data[18])) { $payload['email_address'] = trim($data[18]); } if (trim($data[19])) { $payload['email_message_categories'] = explode(",", trim($data[19])); } else { $payload['email_message_categories'] = []; } $phoneNumbers = []; if (trim($data[20])) { $phoneNumbers['work'] = ['number' => trim(preg_replace("/[^0-9]/", "", $data[20])), 'extension' => trim($data[21])]; } if (trim($data[22])) { $phoneNumbers['home'] = ['number' => trim(preg_replace("/[^0-9]/", "", $data[22])), 'extension' => null]; } if (trim($data[23])) { $phoneNumbers['mobile'] = ['number' => trim(preg_replace("/[^0-9]/", "", $data[23])), 'extension' => null]; } if (trim($data[24])) { $phoneNumbers['fax'] = ['number' => trim(preg_replace("/[^0-9]/", "", $data[24])), 'extension' => null]; } if (count($phoneNumbers) > 0) { $payload['phone_numbers'] = $phoneNumbers; } return $payload; }
public function getSalesChannelReport(Request $request) { $query = PurchaseOrder::select(DB::raw('sales_channels.name'), DB::raw('count(purchase_orders.id) as pocount'), DB::raw('sum(purchase_orders.total) as pototal')); $reportParams = $request->input('reportParams'); if (isset($reportParams['sales_channel_from_date']) && $reportParams['sales_channel_from_date'] !== '') { $sDate = new Carbon($reportParams['sales_channel_from_date']); $query->whereDate('purchase_orders.created_at', '>=', $sDate->toDateString()); } if (isset($reportParams['sales_channel_to_date']) && $reportParams['sales_channel_to_date'] !== '') { $eDate = new Carbon($reportParams['sales_channel_to_date']); $query->whereDate('purchase_orders.created_at', '<=', $eDate->toDateString()); } $query->join('sales_channels', 'purchase_orders.sales_channel_id', '=', 'sales_channels.id'); $query->groupBy(DB::raw('purchase_orders.sales_channel_id')); $query->orderBy('sales_channels.name', 'asc'); $dataPoints = $query->get(); return response()->json($dataPoints); }
/** * Scope For Date * * @param Illuminate\Database\Query $query * @param Carbon $date Date of inquiry * @return Illuminate\Database\Query Scoped query */ public function scopeForDate($query, Carbon $date) { return $query->where('date', '=', $date->toDateString()); }
public function postDonate() { date_default_timezone_set('Asia/Manila'); $carbon = new Carbon(); $datedonated = $carbon->toDateString(); $usersid = Session::get('userid'); $donation = new Donations(); $donation->amountdonated = Input::get('amountdonated'); $donation->datedonated = $datedonated; $donation->usersid = $usersid; $donation->campaignid = Input::get('campaignid'); $donation->bankname = Input::get('bankname'); $donation->bankaccount = Input::get('bankaccount'); $donation->userbankname = Input::get('userbankname'); $donation->save(); $result = DB::table('campaign')->select('campaign.name')->where('campaign.id', Input::get('campaignid'))->get(); foreach ($result as $row) { $name = $row->name; } $activityname = "Donated P" . Input::get('amountdonated') . ' to campaign: ' . $name; DB::table('activity')->insertGetId(array('name' => $activityname, 'usersid' => $usersid, 'date' => $datedonated)); }
/** * метод вызывается, если в абонементе указано количество занятий * пробегает по рассписанию и добавляет в массив $_insertArray данные о новых оплаченных занятиях, * для вставки в базу данных. * @param array Timetable::find() $timeTableGroups * @param array PaidEmployment::find() $existEmployments * @param Carbon $currentDate * @param Carbon $endDate */ private function addInsertArrayAmountLimit($timeTableGroups, $existEmployments, $currentDate, $endDate) { while ($endDate->timestamp >= $currentDate->timestamp) { foreach ($timeTableGroups as $tableRow) { if ($tableRow['week_day'] == $currentDate->dayOfWeek) { if ($this->_ticketModel->amount < 1) { goto amountEnd; } $findFlag = false; foreach ($existEmployments as $employmentRow) { if ($employmentRow['date'] == $currentDate->toDateString() && $tableRow['id'] == $employmentRow['timetable_id']) { $findFlag = true; break; } } if (!$findFlag) { $this->_insertArray[] = ['date' => $currentDate->toDateString(), 'pay_id' => $this->id, 'timetable_id' => $tableRow['id']]; --$this->_ticketModel->amount; } } } $currentDate->addDay(); } amountEnd: // goto amountEnd }
public function getNewActionsForDate(Carbon $dateRunAt) { return Schedule::where('run_at', $dateRunAt->toDateString())->where('status', 'new')->get(); }
/** * Checks if the passed in date is the same day as the instance current day. * * @param Carbon $dt * @return boolean */ public function isSameDay(Carbon $dt) { return $this->toDateString() === $dt->toDateString(); }
public function scopeShipsOn($query, $date) { if ($date == 'any') { return $query; } $date = new Carbon($date); return $query->where('collect_after', 'like', $date->toDateString() . '%'); }