public function dueDate()
{
$settings = APSetting::first();
$generated_on = new Carbon($this->generated_on);
$generated_on->addDays($settings->payment_due_in_days);
return $generated_on->format('d M y');
}
private function calculateHolidays($country, $fromYear, $toYear)
{
$return = [];
if ($fromYear == $toYear) {
$years = [$fromYear];
} else {
$years = [$fromYear, $toYear];
}
foreach ($years as $year) {
$country_file = dirname(__DIR__) . '/data/' . $country . '.json';
$countryHolidays = json_decode(file_get_contents($country_file), true);
foreach ($countryHolidays as $countryHoliday) {
if (strstr($countryHoliday['rule'], '%Y')) {
$rule = str_replace('%Y', $year, $countryHoliday['rule']);
} elseif (strstr($countryHoliday['rule'], '%EASTER')) {
$date = new Carbon($year . '-03-21 +' . easter_days($year) . ' days');
$rule = str_replace('%EASTER', $date->format('Y-m-d'), $countryHoliday['rule']);
} elseif (in_array($country, ['BR', 'US']) && strstr($countryHoliday['rule'], '%ELECTION')) {
$rule = $this->calculateElectionDay($country, $years, $year, $countryHoliday);
} else {
$rule = $countryHoliday['rule'] . ' ' . $year;
}
if ($rule) {
$return[] = ['name' => $countryHoliday['name'], 'date' => new Carbon($rule)];
}
}
}
return $return;
}
/**
* Set the value of the "created at" attribute.
*
* @param mixed $value
* @return void
*/
public function setCreatedAt($value)
{
$this->{static::CREATED_AT} = $value;
if (!$value instanceof Carbon) {
$value = new Carbon($value);
}
$this->{static::CREATED_AT . '_gmt'} = $value->timezone('GMT');
}
/**
* Show the board index for the user.
*
* @return Response
*/
public function getContribute()
{
$devStart = new Carbon(static::$ContributeProjectStart);
$devCarbon = new Carbon(static::$ContributePublicStart);
$donors = Payment::all();
$donationsTotal = 0;
foreach ($donors as $donor) {
$donationsTotal += $donor->amount;
}
$devEnd = clone $devCarbon;
$devTime = $donationsTotal / 100 / (double) env('CONTRIB_HOUR_COST', 10) * static::$ContributeDevInflation;
$devEnd->addHours($devTime);
return response()->json(['development_start' => $devStart->toRfc2822String(), 'development_public' => $devCarbon->toRfc2822String(), 'development_paid_until' => $devEnd->toRfc2822String(), 'donations_total' => $donationsTotal, 'donors' => $donors->toJson()]);
}
public function postRegistro()
{
$input = Input::all();
$reglas = array('nombre' => 'required', 'apellido' => 'required', 'celular' => 'required|numeric|unique:users', 'cedula' => 'required|numeric|unique:users', 'email' => 'required|email|unique:users', 'pin' => 'required|numeric|digits_between:0,4', 'password' => 'required|numbers|case_diff|letters|min:6|confirmed', 'password_confirmation' => 'required|min:6');
$validation = Validator::make($input, $reglas);
if ($validation->fails()) {
return Response::json(['success' => false, 'errors' => $validation->errors()->toArray()]);
}
try {
// se guarda los datos del usuario
$user = Sentry::register(array('first_name' => Input::get('nombre'), 'last_name' => Input::get('apellido'), 'email' => Input::get('email'), 'habilitar_pin' => 1, 'celular' => Input::get('celular'), 'cedula' => Input::get('cedula'), 'password' => Input::get('password'), 'pin' => Input::get('pin'), 'porcentaje' => 0.05, 'activated' => true));
$userId = $user->getId();
$token = new Token();
$token->user_id = $userId;
$token->api_token = hash('sha256', Str::random(10), false);
$token->client = BrowserDetect::toString();
$token->expires_on = Carbon::now()->addMonth()->toDateTimeString();
$token->save();
// Se autentica de una
$user_login = Sentry::findUserById($userId);
Sentry::login($user_login, false);
return Response::json(['success' => true, 'user' => $user_login, 'token' => $token->api_token]);
} catch (Cartalyst\Sentry\Users\LoginRequiredException $e) {
$error = array('usuario' => 'Email es requerido');
} catch (Cartalyst\Sentry\Users\PasswordRequiredException $e) {
$error = array('usuario' => 'Password es requerido');
} catch (Cartalyst\Sentry\Users\UserExistsException $e) {
$error = array('usuario' => 'El Email ya está registrado');
}
return Response::json(['success' => false, 'errors' => $error]);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
list($rootFolder, $current, $folder) = $this->setFolder();
$counter = 1;
$measurementsCounter = 0;
$file = fopen($folder . 'file' . $counter . '.csv', "w");
$maxRows = self::MAX_ROWS - 500;
Measurement::with('station')->where('time', '>', Carbon::now()->subMonths(3))->orderBy('time', 'asc')->chunk(500, function ($measurements) use($folder, &$file, &$measurementsCounter, &$counter, $maxRows) {
if ($measurementsCounter > $maxRows) {
echo "measurements: " . $measurementsCounter . "\n";
echo "file created: " . $counter . ".csv\n";
$measurementsCounter = 0;
if (is_resource($file)) {
fclose($file);
}
$counter++;
$file = fopen($folder . 'file' . $counter . '.csv', "w");
}
foreach ($measurements as $measurement) {
$array = $measurement->toArray();
unset($array['station_id'], $array['station']['id']);
fputcsv($file, array_flatten($array));
}
$measurementsCounter += 500;
});
File::put($rootFolder . 'finished.txt', $current);
}
public function getIncompleteProductLoads($user_id)
{
//get user and in progress product requests / ideas
$user = $this->eloquent->with(['ideas' => function ($query) {
$query->where('is_fulfilled', '=', 0);
}])->with(['productRequests' => function ($query) {
$query->whereNull('product_id');
}])->find($user_id);
if (empty($user)) {
return [];
}
$user = $user->toArray();
$product_requests = $user['product_requests'];
$ideas = $user['ideas'];
//compile inprogress items
$inprogress_items = new \Collection();
foreach ($product_requests as $product_request) {
$inprogress_items->add(['type' => 'id load', 'human_time_diff' => \Carbon::createFromFormat('Y-m-d H:i:s', $product_request['created_at'])->diffForHumans(), 'created_at' => $product_request['created_at'], 'updated_at' => $product_request['updated_at'], 'id' => $product_request['id'], 'description' => $product_request['vendor'] . ' ' . $product_request['vendor_id'], 'query' => ['vendor' => $product_request['vendor'], 'vendor_id' => $product_request['vendor_id']]]);
}
foreach ($ideas as $idea) {
$inprogress_items->add(['type' => 'idea load', 'human_time_diff' => \Carbon::createFromFormat('Y-m-d H:i:s', $idea['created_at'])->diffForHumans(), 'created_at' => $idea['created_at'], 'updated_at' => $idea['updated_at'], 'id' => $idea['id'], 'description' => $idea['description'], 'query' => ['idea_description' => $idea['description']]]);
}
$inprogress_items->sortBy('created_at');
return $inprogress_items->toArray();
}
public function sendInvoice(Invoice $invoice)
{
$invoice->load('invitations', 'client', 'account');
$entityType = $invoice->getEntityType();
$view = 'invoice';
$subject = trans("texts.{$entityType}_subject", ['invoice' => $invoice->invoice_number, 'account' => $invoice->account->getDisplayName()]);
foreach ($invoice->invitations as $invitation) {
if (!$invitation->user->email) {
return false;
}
if (!$invitation->contact->email) {
return false;
}
$invitation->sent_date = \Carbon::now()->toDateTimeString();
$invitation->save();
$data = ['entityType' => $entityType, 'link' => $invitation->getLink(), 'clientName' => $invoice->client->getDisplayName(), 'accountName' => $invoice->account->getDisplayName(), 'contactName' => $invitation->contact->getDisplayName(), 'invoiceAmount' => Utils::formatMoney($invoice->amount, $invoice->client->currency_id), 'emailFooter' => $invoice->account->email_footer, 'showNinjaFooter' => !$invoice->account->isPro()];
$fromEmail = $invitation->user->email;
$fromName = $invitation->user->getDisplayName();
$this->sendTo($invitation->contact->email, $fromEmail, $fromName, $subject, $view, $data);
Activity::emailInvoice($invitation);
}
if (!$invoice->isSent()) {
$invoice->invoice_status_id = INVOICE_STATUS_SENT;
$invoice->save();
}
\Event::fire('invoice.sent', $invoice);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$videoItems = array(array("Breakfast Show!", "This is the breakfast show description."), array("BBC News"), array("BBC News 24"), array("Dragons Den"), array("Mock The Week!"), array("Some Other Show"), array("Soundbooth Sessions"), array("The LA1 Show"), array("The One Show"), array("Star Wars"), array("Sugar TV!"), array("The Incredibles"), array("University Challenge"), array("Countdown"), array("8 out of 10 Cats Does Countdown"), array("Jurassic Park"), array("Jurassic Park 2"), array("Shrek"), array("Shrek 2"), array("Shrek 3"), array("Mission Impossible"));
foreach ($videoItems as $a) {
$mediaItemVideo = new MediaItemVideo(array("is_live_recording" => rand(0, 1) ? true : false, "time_recorded" => Carbon::now()->subHour(), "description" => rand(0, 4) === 0 ? "A description that should override the general media item one." : null, "enabled" => rand(0, 1) ? true : false));
$mediaItem = new MediaItem(array("name" => $a[0], "description" => count($a) >= 2 ? $a[1] : null, "enabled" => rand(0, 1) ? true : false, "scheduled_publish_time" => Carbon::now()));
DB::transaction(function () use(&$mediaItem, &$mediaItemVideo) {
$mediaItem->save();
$mediaItem->videoItem()->save($mediaItemVideo);
});
$this->addLikes($mediaItem);
$this->addComments($mediaItem);
}
//$mediaItemLiveStream = new MediaItemLiveStream(array(
// "enabled" => true
//));
$mediaItem = new MediaItem(array("name" => "Lunchtime Show!", "description" => "This is the lunchtime show description.", "enabled" => true, "scheduled_publish_time" => Carbon::now()));
DB::transaction(function () use(&$mediaItem, &$mediaItemLiveStream) {
$mediaItem->save();
// $mediaItem->liveStreamItem()->save($mediaItemLiveStream);
});
$this->addLikes($mediaItem);
$this->addComments($mediaItem);
$this->command->info('Media items created!');
}
public function update($id)
{
$oss = Oss::find($id);
$oss->tanggal_oss = Carbon::createFromFormat('d/m/Y', Input::get('tanggal_oss'));
$oss->no_oss = Input::get('no_oss');
$oss->mitra_oss = Input::get('mitra_oss');
if (Input::get('nama_bantek') != '') {
$oss->nama_bantek_oss = Input::get('nama_bantek');
}
$oss->id_site = Input::get('id_site');
$oss->nama_site = Input::get('nama_site');
if (Input::get('tanggal_mulai') != '') {
$oss->tanggal_mulai_oss = Carbon::createFromFormat('d/m/Y', Input::get('tanggal_mulai'));
}
if (Input::get('tanggal_selesai') != '') {
$oss->tanggal_selesai_oss = Carbon::createFromFormat('d/m/Y', Input::get('tanggal_selesai'));
}
$oss->permasalahan_oss = Input::get('masalah');
$oss->action_oss = Input::get('action');
if (Input::get('rincian') != '') {
$oss->rincian_jasa_material_oss = Input::get('rincian');
}
if (Input::get('shopping_list') != '') {
$oss->kode_shopping_list = Input::get('shopping_list');
}
$oss->harga_oss = Input::get('harga');
$oss->req_oleh = Input::get('request');
$oss->diketahui_oleh = Input::get('approval');
$oss->save();
Session::flash('success', 'Data has been saved');
return Redirect::to('/oss');
}
public function toText($txt)
{
$tab = explode('-', $txt);
$date = Carbon::createFromTimeStamp($tab[0])->toDateString();
$tab[1] == 'm' ? $day = 'matin' : ($day = 'après-midi');
return $date . ' ' . $day;
}
public function fire()
{
$cacheName = $this->queueCacheName . $this->argument('aliasCacheCode');
if (!Cache::has($cacheName)) {
return;
}
$smallIds = Cache::pull($cacheName);
$profiles = Profile::whereIn('small_id', $smallIds)->get();
foreach ($profiles as $profile) {
$steamAPI = new SteamAPI('alias');
$steamAPI->setSmallId($profile->small_id);
$steamAlias = $steamAPI->run();
if ($steamAPI->error()) {
$steamAlias = [];
} else {
usort($steamAlias, array('VacStatus\\Steam\\Steam', 'aliasSort'));
}
$profile->alias = json_encode($steamAlias);
$profile->save();
$cacheName = "profile_{$profile->small_id}}";
if (!Cache::has($cachName)) {
continue;
}
$profileCache = Cache::get($cacheName);
$profileCache['alias'] = Steam::friendlyAlias($steamAlias);
if (Cache::has($cacheName)) {
Cache::forget($cacheName);
}
$expireTime = Carbon::now()->addMinutes(60);
Cache::put($cacheName, $profileCache, $expireTime);
}
}
/**
* Редактирование сообщения
*/
public function edit($id)
{
if (!User::check()) {
App::abort(403);
}
if (!($guest = Guestbook::find_by_id($id))) {
App::abort('default', 'Сообщение не найдено!');
}
if (!User::isAdmin() && $guest->user_id != User::getUser('id')) {
App::abort('default', 'Редактирование невозможно, вы не автор данного сообщения!');
}
if (!User::isAdmin() && $guest->created_at < Carbon::now()->subMinutes(10)) {
App::abort('default', 'Редактирование невозможно, прошло более 10 мин.');
}
if (Request::isMethod('post')) {
$guest->token = Request::input('token', true);
$guest->text = Request::input('text');
if ($guest->save()) {
App::setFlash('success', 'Сообщение успешно изменено!');
App::redirect('/guestbook');
} else {
App::setFlash('danger', $guest->getErrors());
App::setInput($_POST);
}
}
App::view('guestbook.edit', compact('guest'));
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$data = Input::all();
$fecha = new Carbon();
$fecha->setTimezone('America/Bogota');
$data = array_add($data, 'fecha', $fecha::now());
if (Auth::user()->avatar != null) {
$imagen = "<img class='avatar circle' src='" . Auth::user()->avatar . "'/>";
} else {
$imagen = ' <i class="fa fa-2x fa-user"></i>';
}
$data = array_add($data, 'persona', Auth::user()->nombre . " de Residencia " . Residencias::find(Auth::user()->residencia_id)->nombre . $imagen);
$data = array_add($data, 'user_id', Auth::user()->id);
$noticia = Noticias::create($data);
return $noticia;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$exclude = \App\EventCheckin::lists('sale_checkin_id');
$ticketsales = \App\Sale::where('created_at', '>', \Carbon::parse('1/31/2016'))->whereNotIn('cart_id', $exclude)->with('cartsBySale', 'cartsBySale.product')->get();
$checkedin = \App\Sale::where('created_at', '>', \Carbon::parse('1/31/2016'))->WhereIn('cart_id', $exclude)->with('cartsBySale', 'cartsBySale.product')->get();
return view('orders.index', compact('ticketsales', 'checkedin'));
}
public function run()
{
$now = Carbon::now();
$permissions = [['name' => 'admin.adkats.bans.create', 'display_name' => 'Create New Bans', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.bans.edit', 'display_name' => 'Edit Bans', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.bans.view', 'display_name' => 'View Banlist', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.reports.edit', 'display_name' => 'Edit Admin Reports', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.reports.view', 'display_name' => 'View Admin Reports', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.settings.edit', 'display_name' => 'Edit AdKats Settings', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.special.edit', 'display_name' => 'Edit AdKats Special Players', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.special.view', 'display_name' => 'View AdKats Special Players', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.user.edit', 'display_name' => 'Edit AdKats Users', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.user.view', 'display_name' => 'View AdKats Users', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.roles.edit', 'display_name' => 'Edit AdKats Roles', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.adkats.roles.view', 'display_name' => 'View AdKats Roles', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.forgive', 'display_name' => 'Forgive Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.kick', 'display_name' => 'Kick Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.kickall', 'display_name' => 'Kick All Players', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.kill', 'display_name' => 'Kill Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.mute', 'display_name' => 'Mute Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.nuke', 'display_name' => 'Nuke Server', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.pban', 'display_name' => 'Perma Ban Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.punish', 'display_name' => 'Punish Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.say', 'display_name' => 'Say Message', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.tban', 'display_name' => 'Temp Ban Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.teamswitch', 'display_name' => 'Teamswitch Player', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.yell', 'display_name' => 'Yell Message', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.scoreboard.tell', 'display_name' => 'Tell Message (Sends both Say and Yell)', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.motd', 'display_name' => 'View Message of the Day', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.roles', 'display_name' => 'Manage Site Roles', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.settings.server', 'display_name' => 'Manage Server Settings', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.settings.site', 'display_name' => 'Manage Site Settings', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.users', 'display_name' => 'Manage Users', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.users.notify', 'display_name' => 'Receive emails on new user registration', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.site.system.logs', 'display_name' => 'View the application logs', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.player.special.add', 'display_name' => 'Add player to the special players table', 'created_at' => $now, 'updated_at' => $now], ['name' => 'admin.player.special.remove', 'display_name' => 'Remove player from the special players table', 'created_at' => $now, 'updated_at' => $now], ['name' => 'chatlogs', 'display_name' => 'View Chatlogs', 'created_at' => $now, 'updated_at' => $now], ['name' => 'player.infractions.forgive', 'display_name' => 'Issue Forgive Points', 'created_at' => $now, 'updated_at' => $now], ['name' => 'player.view.guids', 'display_name' => 'View Player GUIDS', 'created_at' => $now, 'updated_at' => $now], ['name' => 'player.view.ip', 'display_name' => 'View Player IP', 'created_at' => $now, 'updated_at' => $now]];
Permission::insert($permissions);
Role::find(1)->permissions()->attach(Permission::lists('id'));
}
public function onLogin()
{
$account = Auth::user()->account;
$account->last_login = Carbon::now()->toDateTimeString();
$account->save();
Event::fire('user.refresh');
}
public function niceDateRange(Carbon $date1 = null, Carbon $date2 = null, $ordinalSuffixRequired = false)
{
$ordinalSuffix = "";
$day1 = $date1->day;
$day2 = $date2->day;
$month1 = $date1->month;
$month2 = $date2->month;
//$ordinalSuffix = FormatMe::toOrdinalSuffix($day2);
$restOfDate = $date2->format('F Y');
$myDateString = "{$day1}-{$day2}" . $ordinalSuffix;
// if months are not the same, display both months in range
if ($month1 !== $month2) {
return "{$day1} " . $date1->format('F') . " – " . "{$day2} " . $date2->format('F Y');
}
return $myDateString . ' ' . $restOfDate;
}
public function run()
{
Banner::truncate();
Website::truncate();
$user = User::create(array("username" => "danheyman", "name" => "Daniel Heyman", "email" => "*****@*****.**", "password" => "hello", "newsletter" => true, "admin_emails" => true, "membership" => "platinum", "paypal" => "", "membership_expires" => Carbon::now()->addMonth(), "referrals" => 0, "upline" => "", "cash" => 0, "credits" => 0, "credits_today" => 0, "views_total" => 0, "views_today" => 0, 'auto_assign' => 0, 'register_ip' => Request::getClientIp(), 'last_login' => Carbon::now()));
for ($x = 0; $x < 20; $x++) {
$website = new Website();
$website->url = "http://listviral.com";
$website->enabled = true;
$website->credits = 10000;
$website->views = 0;
$website->days = array();
$website->hours = array();
$user->websites()->save($website);
$banner = new Banner();
$banner->banner = "http://brisksurf.com/banner.png";
$banner->url = "http://brisksurf.com";
$banner->enabled = true;
$banner->credits = 10000;
$banner->views = 0;
$banner->days = array();
$banner->hours = array();
$user->banners()->save($banner);
}
}
public function ReportAffiliate($token)
{
$header = array(array('INSTITUCION DE PREVISION SOCIAL DEL PERIODISTA'), array('Carnet: ', '', ' Fecha Nacimiento: ', ' ', 'Edad: ', 'Fecha Ingreso: '), array('Nombre: '), array('Tiempo de jubilación Voluntaria: '), array('Tiempo de jubilación Obligatorio: '), array('Pago de Cuotas Sector Privado '), array(''), array('Año', 'Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'));
$dues = $this->duesRepository->getModel()->where('affiliate_id', $affiliate->id)->orderBy('date_payment', 'ASC')->get();
if (!$dues->isEmpty()) {
//"01/01/1995"
$old_year = Carbon::format($dues[0]->date_payment)->getFullYear();
//1995
$last_year = Carbon::format($dues[count($dues) - 1])->getFullYear();
//2014
for ($i = $old_year; $i <= $last_year; $i++) {
$row[] = $i;
for ($j = 1; $j <= 12; $j++) {
# code...
foreach ($dues as $key => $value) {
if ($value->date_payment == "01/" . $j . "/" . $i) {
array_push($row, $value->amount);
} else {
array_push($row, "");
}
}
}
array_push($header, $row);
}
}
echo json_encode($header);
die;
/* foreach ($dues as $due) {
$duesYear = $this->duesRepository->getModel()->where('date_payment',$affiliate->id)->where('affiliate_id',$affiliate->id)->orderBy('date_payment','ASC')->get();
foreach(){
$header[] = ['Año','Enero','Febrero','Marzo','Abril','Mayo','Junio','Julio','Agosto','Septiembre','Octubre','Noviembre','Diciembre'];
}
}*/
}
public function mongoTime($time = false)
{
if (!$time) {
$time = \Carbon::now();
}
return new \MongoDate($time->getTimestamp());
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$types = self::_getSeedData();
foreach ($types as $type) {
DB::table(self::_getTableName())->insert(['name' => $type, 'created_at' => Carbon::now()]);
}
}
public function run()
{
DB::table('landmarks')->delete();
$dt = Carbon::now();
$dateNow = $dt->toDateTimeString();
DB::table('landmarks')->insert(array(array('name' => 'ufo 1', 'desc' => 'Description of ufo view in Oviedo, spain.', 'location' => 'Oviedo', 'link' => 'http://exoarchive.com/ufo1', 'image' => 'http://cdn2-b.examiner.com/sites/default/files/styles/image_content_width/hash/b9/b2/1360764616_6383_UFO.jpg', 'latitude' => '43.361915', 'longitude' => '5.849389', 'mapId' => '1', 'viewDate' => $dateNow, 'created_at' => $dateNow, 'updated_at' => $dateNow), array('name' => 'ufo 2', 'desc' => 'Description of ufo view in Barcelona, spain.', 'location' => 'Batcelona', 'link' => 'http://exoarchive.com/ufo2', 'image' => 'http://cdn2-b.examiner.com/sites/default/files/styles/image_content_width/hash/b9/b2/1360764616_6383_UFO.jpg', 'latitude' => '41.385064', 'longitude' => '2.173403', 'mapId' => '1', 'viewDate' => $dateNow, 'created_at' => $dateNow, 'updated_at' => $dateNow), array('name' => 'ufo 3', 'desc' => 'Description of ufo view in Madrid, spain.', 'location' => 'Madrid', 'link' => 'http://exoarchive.com/ufo3', 'image' => 'http://cdn2-b.examiner.com/sites/default/files/styles/image_content_width/hash/b9/b2/1360764616_6383_UFO.jpg', 'latitude' => '40.416775', 'longitude' => '-3.70379', 'mapId' => '1', 'viewDate' => $dateNow, 'created_at' => $dateNow, 'updated_at' => $dateNow), array('name' => 'ufo 4', 'desc' => 'Description of ufo view in Alicante, spain.', 'location' => 'Alicante', 'link' => 'http://exoarchive.com/ufo4', 'image' => 'http://cdn2-b.examiner.com/sites/default/files/styles/image_content_width/hash/b9/b2/1360764616_6383_UFO.jpg', 'latitude' => '40.970104', 'longitude' => '-5.66354', 'mapId' => '1', 'viewDate' => $dateNow, 'created_at' => $dateNow, 'updated_at' => $dateNow)));
}
public function paymentByDay()
{
return static::select('id')->get()->where('type', 'payment')->andWhere('state', 'paid')->groupBy(function ($date) {
return Carbon::parse($date->created_at)->format('d');
// grouping by months
});
}
function validate()
{
if (!Session::has('vatsimauth')) {
throw new AuthException('Session does not exist');
}
$SSO = new SSO(Config::get('vatsim.base'), Config::get('vatsim.key'), Config::get('vatsim.secret'), Config::get('vatsim.method'), Config::get('vatsim.cert'));
$session = Session::get('vatsimauth');
if (Input::get('oauth_token') !== $session['key']) {
throw new AuthException('Returned token does not match');
return;
}
if (!Input::has('oauth_verifier')) {
throw new AuthException('No verification code provided');
}
$user = $SSO->checkLogin($session['key'], $session['secret'], Input::get('oauth_verifier'));
if ($user) {
Session::forget('vatsimauth');
$authUser = User::find($user->user->id);
if (is_null($authUser)) {
$authUser = new User();
$authUser->vatsim_id = $user->user->id;
$authUser->name = trim($user->user->name_first . ' ' . $user->user->name_last);
}
$authUser->last_login = Carbon::now();
$authUser->save();
Auth::login($authUser);
Messages::success('Welcome on board, <strong>' . $authUser->name . '</strong>!');
return Redirect::intended('/');
} else {
$error = $SSO->error();
throw new AuthException($error['message']);
}
}
public static function makeExpiry($units, $unit, $format = 'Y-m-d H:i:s')
{
$val = Carbon::now();
$add = "add" . $unit;
$val->{$add}($units);
return $val->format($format);
}
/**
* Return all date in weeks for a month.
*
* @param Carbon $date The month.
* @param integer $firstDayOfWeek The first day of the week.
*
* @return Array Array of dates.
*/
public static function getDatesInWeeksForMonth(Carbon $date, $firstDayOfWeek)
{
Log::info('Get all dates in weeks for month.', compact('date', 'firstDayOfWeek'));
$days = array();
$date = $date->copy();
$date->day = 1;
// Get next month.
$nextMonth;
if ($date->month === 12) {
$nextMonth = 1;
} else {
$nextMonth = $date->month + 1;
}
// Get first day of the first week.
if ($date->dayOfWeek > $firstDayOfWeek) {
$date->day = -($date->dayOfWeek - $firstDayOfWeek - 1);
} else {
if ($date->dayOfWeek < $firstDayOfWeek) {
$date->day = -(6 - ($firstDayOfWeek - $date->dayOfWeek));
}
}
// Get rest of the days in weeks until next month and before first day of week.
while (!($date->month === $nextMonth && $date->dayOfWeek === $firstDayOfWeek)) {
$days[] = Carbon::createFromDate($date->year, $date->month, $date->day);
$date->day++;
}
return $days;
}
public function indexAction()
{
if ($this->request->isPost()) {
$register = new Users();
$register->id = UUID::v4();
$register->password = $this->security->hash($this->request->getPost('password'));
$register->phonenumber = $this->request->getPost('phonenumber');
$register->email = $this->request->getPost('email');
$register->name = $this->request->getPost('name');
$register->created_date = Carbon::now()->now()->toDateTimeString();
$register->updated_date = Carbon::now()->now()->toDateTimeString();
$user = Users::findFirstByEmail($register->email);
if ($user) {
$this->flash->error("can not register, User " . $register->email . " Alredy Registerd! ");
return true;
}
if ($register->save() === true) {
$this->session->set('user_name', $register->name);
$this->session->set('user_email', $register->email);
$this->session->set('user_id', $register->id);
$this->flash->success("Your " . $register->email . " has been registered Please Login for booking court");
$this->response->redirect('dashboard');
}
}
}
public function store()
{
$st = new SuratTugas();
$st->tempat_tanggal = Carbon::now();
$st->menyetujui = Input::get('menyetujui');
$st->save();
$romans = array(0 => '', 1 => 'I', 2 => 'II', 3 => 'III', 4 => 'IV', 5 => 'V', 6 => 'VI', 7 => 'VII', 8 => 'VIII', 9 => 'IX', 10 => 'X', 11 => 'XI', 12 => 'XII');
$day = Carbon::now();
$st->no_surat = $st->id . '/TC.01' . '/RO-43' . '/' . $romans[$day->month] . '/' . $day->year;
$st->save();
$banteks = Input::get('bantek');
for ($i = 0; $i < count($banteks); $i++) {
$stb = new STBantek();
$stb->bantek_id = $banteks[$i];
$stb->st_id = $st->id;
$stb->save();
}
$activities = Input::get('activity');
if ($activities != '') {
$activities = substr($activities, 0, -1);
$activity = explode(",", $activities);
if (count($activity > 0)) {
for ($i = 0; $i < count($activity); $i++) {
$sta = STActivity::find($activity[$i]);
$sta->st_id = $st->id;
$sta->save();
}
}
}
STActivity::where('st_id', '=', '')->delete();
Session::flash('success', 'Data telah dibuat.');
return Redirect::to('/' . Auth::user()->role . '/surattugas');
}
public function getIndex()
{
$minigraph_data = array();
$minigraph_data['account_created'] = $this->graphDataBuild('account_created');
$minigraph_data['login'] = $this->graphDataBuild('login');
$minigraph_data['activity'] = $this->graphDataBuild('activity');
$minigraph_data['activity_unique'] = $this->graphDataBuild('activity', '5', true);
View::share('minigraph_data', $minigraph_data);
View::share('minigraph_json', json_encode($minigraph_data));
$widgets = $this->widgets();
View::share('widgets', $widgets);
$results = DB::select('SELECT email FROM users WHERE UNIX_TIMESTAMP(`last_activity`) > ?', array(time() - 600));
View::share('whosonline', $results);
$stocksTable = Lava::DataTable('Stocks');
$stocksTable->addColumn('string', 'Week', 'count');
$stocksTable->addColumn('number', 'Hits', 'projected');
$stocksTable->addColumn('number', 'Unique', 'projected');
foreach (array_reverse($minigraph_data['activity']['data'], true) as $i => $d) {
$data[0] = $i == 0 ? "This week" : Carbon::now()->subWeeks($i)->diffForHumans();
$data[1] = $d;
$data[2] = $minigraph_data['activity_unique']['data'][$i];
$stocksTable->addRow($data);
}
Lava::LineChart('Stocks')->setConfig();
return Theme::make('admin/dashboard');
}
