public function schedules() { $schedules = Schedule::where('user_id', '=', Auth::user()->id)->paginate(10); $page_data = array('schedules' => $schedules); $this->layout->title = 'Schedules'; $this->layout->content = View::make('admin.schedules', $page_data); }
/** * Generate the view of the week for given month and given year * with events in this period. * * @param string $year * @param string $week * @return view weekView * * */ public function showWeek($year, $week) { // Create week start date on monday (day 1) $weekStart = date('Y-m-d', strtotime($year . "W" . $week . '1')); // Create the number of the next week $nextWeek = date("W", strtotime("next Week" . $weekStart)); $nextYear = date("Y", strtotime("next Week" . $weekStart)); // Create week end date - we go till tuesday (day 2) because café needs alternative week view (Mi-Di) $weekEnd = date('Y-m-d', strtotime($nextYear . "W" . $nextWeek . '2')); // Create the number of the previous week $previousWeek = date("W", strtotime("previous Week" . $weekStart)); $previousYear = date("Y", strtotime("previous Week" . $weekStart)); // Convert number of prev/next week to verbatim format - needed for correct << and >> button links $nextWeek = $nextYear . "/KW" . $nextWeek; $previousWeek = $previousYear . "/KW" . $previousWeek; $date = array('year' => $year, 'week' => $week, 'weekStart' => $weekStart, 'weekEnd' => $weekEnd, 'nextWeek' => $nextWeek, 'previousWeek' => $previousWeek); $events = ClubEvent::where('evnt_date_start', '>=', $weekStart)->where('evnt_date_start', '<=', $weekEnd)->with('getPlace', 'getSchedule.getEntries.getJobType', 'getSchedule.getEntries.getPerson.getClub')->orderBy('evnt_date_start')->orderBy('evnt_time_start')->get(); $tasks = Schedule::where('schdl_show_in_week_view', '=', '1')->where('schdl_due_date', '>=', $weekStart)->where('schdl_due_date', '<=', $weekEnd)->with('getEntries.getPerson.getClub', 'getEntries.getJobType')->get(); // TODO: don't use raw query, rewrite with eloquent. $persons = Cache::remember('personsForDropDown', 10, function () { $timeSpan = new DateTime("now"); $timeSpan = $timeSpan->sub(DateInterval::createFromDateString('3 months')); return Person::whereRaw("prsn_ldap_id IS NOT NULL \n\t\t\t\t\t\t\t\t\t\t AND (prsn_status IN ('aktiv', 'kandidat') \n\t\t\t\t\t\t\t\t\t\t OR updated_at>='" . $timeSpan->format('Y-m-d H:i:s') . "')")->orderBy('clb_id')->orderBy('prsn_name')->get(); }); $clubs = Club::orderBy('clb_title')->lists('clb_title', 'id'); // IDs of schedules shown, needed for bulk-update $updateIds = array(); foreach ($events as $event) { array_push($updateIds, $event->getSchedule->id); } return View::make('weekView', compact('events', 'schedules', 'date', 'tasks', 'entries', 'weekStart', 'weekEnd', 'persons', 'clubs')); }
public function get_fleetsonnotprintspj() { $date = Input::get('date', date('Y-m-d')); $pool_id = Auth::user()->pool_id; $timestamp = strtotime($date); /* $fleets_on_not_printspj = Scheduledate::join('schedules','schedules.id','=','schedule_dates.schedule_id') ->join('fleets', 'fleets.id', '=', 'schedules.fleet_id' ) //->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id' ) //->where_in('schedule_dates.schedule_id', $arrayschedule ) //->where('ksos.actived','=',1) ->where('schedules.pool_id', '=', $pool_id ) ->where('schedule_dates.date', '=', date('j', $timestamp)) ->where('schedules.month','=',date('n', $timestamp )) ->where('schedule_dates.fg_check','=',0) ->order_by('fleets.taxi_number','asc') ->get(array('schedule_dates.id as id','schedule_dates.driver_id','schedules.fleet_id','fleets.taxi_number')); */ $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets_on_not_printspj = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets_on_not_printspj = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedule_dates.fg_check', '=', 0)->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'schedule_dates.id as id')); } $datas = array_map(function ($object) { return $object->to_array(); }, $fleets_on_not_printspj); return Response::json($datas); }
public function post_search() { $jsondata = Input::json(); $date = $jsondata->date; $timestamp = strtotime($date); //list armada on schedule $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('ksos.actived', '=', 1)->where('taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number')); } $fleetdatas = array_map(function ($object) { return $object->to_array(); }, $fleets); $data['fleet'] = $fleetdatas; return json_encode($data); }
public function get_schedule() { $callback = Input::get('callback'); $date = Input::get('date', date('Y-m-d')); $pool = Input::get('pool'); $timestamp = strtotime($date); //list armada on schedule $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', $pool)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('ksos.actived', '=', 1)->order_by('fleets.taxi_number', 'asc')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number', 'schedule_dates.fg_check as out')); //->get(array('fleets.taxi_number','schedule_dates.id as id', 'schedule_dates.fg_check as out')); } $fleetdatas = array_map(function ($object) { return $object->to_array(); }, $fleets); return Response::jsonp($callback, $fleetdatas); }
/** * Generate the view of the calender for given month and given year * with events in this period. * * @param string $year * @param string $month * @return view monthView */ public function showMonth($year, $month) { // Create a string of the start of the month $monthStart = $year . $month . '01'; // String of end of month $monthEnd = $year . $month . '31'; // Create timestamp of the first day of selected month. Time 12:12:12 used only as dummy time $usedTime = mktime(12, 12, 12, $month, 1, $year); // Create a int with the number of days of the month (28...31) $daysOfMonth = date("t", $usedTime); // Create a timestamp with start of month $startStamp = mktime(0, 0, 0, date("n", $usedTime), 1, date("Y", $usedTime)); // Int for the start day $startDay = date("N", $startStamp); // Int for the lst day $endDay = date("N", mktime(0, 0, 0, date("n", $usedTime), $daysOfMonth, date("Y", $usedTime))); // Array for german translation of the month names $monthName = array(1 => Config::get('messages_de.month-name-jan'), 2 => Config::get('messages_de.month-name-feb'), 3 => Config::get('messages_de.month-name-mar'), 4 => Config::get('messages_de.month-name-apr'), 5 => Config::get('messages_de.month-name-may'), 6 => Config::get('messages_de.month-name-jun'), 7 => Config::get('messages_de.month-name-jul'), 8 => Config::get('messages_de.month-name-aug'), 9 => Config::get('messages_de.month-name-sep'), 10 => Config::get('messages_de.month-name-oct'), 11 => Config::get('messages_de.month-name-nov'), 12 => Config::get('messages_de.month-name-dec')); $date = array('year' => $year, 'month' => $month, 'daysOfMonth' => $daysOfMonth, 'startDay' => $startDay, 'endDay' => $endDay, 'startStamp' => $startStamp, 'usedTime' => $usedTime, 'monthName' => $monthName[date("n", $usedTime)]); $events = ClubEvent::where('evnt_date_start', '>=', $monthStart)->where('evnt_date_start', '<=', $monthEnd)->orderBy('evnt_date_start')->orderBy('evnt_time_start')->get(); $tasks = Schedule::where('schdl_show_in_week_view', '=', '1')->where('schdl_due_date', '>=', $monthStart)->where('schdl_due_date', '<=', $monthEnd)->get(); return View::make('monthView', compact('events', 'tasks', 'date')); }
public function get_schedules() { $schedules = Schedule::where('doctor_id', Session::get('doctor.id'))->where('date', 'like', Input::get('date', date('Y-m')) . '%')->orderBy('date')->get(); //->paginate( $this->default_num_per_page ); $schedules_map = array(); foreach ($schedules as $schedule) { $date_parse = date('m-d', strtotime($schedule->date)); if (!array_key_exists($schedule->date, $schedules_map)) { $schedules_map[$schedule->date] = array(); } $schedules_map[$schedule->date][$schedule->period] = array('id' => $schedule->id, 'period' => $schedule->period); } $page = (int) Input::get('page'); $schedule_count = count($schedules_map); $max_page = $schedule_count % $this->default_num_per_page; if ($page > $max_page) { $page = $max_page; } if ($page < 1) { $page = 1; } $result = array_slice($schedules_map, ($page - 1) * $this->default_num_per_page, $this->default_num_per_page); return Response::json(array('error_code' => 0, 'totality' => $schedule_count, 'schedules' => $result)); }
public function post_toolspj() { $date = Input::get('tanggal', date('Y-m-d')); ini_set('max_execution_time', 120); $timestamp = strtotime($date); //list armada on schedule $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('schedule_dates.shift_id', '=', 1)->where('ksos.actived', '=', 1)->order_by('fleets.taxi_number', 'asc')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number')); } if ($fleets) { foreach ($fleets as $f) { $scheduledate = Scheduledate::find($f->id); $scheduledate->fg_check = 1; $scheduledate->save(); $schedule = Schedule::find($scheduledate->schedule_id); //$driverinfo = Driver::find($scheduledate->driver_id); //$fleetinfo = Fleet::find($schedule->fleet_id); $ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first(); $dateopertion = mktime(0, 0, 0, $schedule->month, $scheduledate->date, $schedule->year); $checkouts = Checkout::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first(); //delete checkouts if ($checkouts) { $checkouts->delete(); } $codeops = 1; $status = 7; $keterangan = 'Print SPJ melalui Tools'; if (!$checkouts) { //insert into to checkouts step $checkouts = new Checkout(); $checkouts->kso_id = $ksoinfo->id; $checkouts->operasi_time = date('Y-m-d', $dateopertion); $checkouts->fleet_id = $schedule->fleet_id; $checkouts->driver_id = $scheduledate->driver_id; $checkouts->checkout_step_id = $status; $checkouts->shift_id = $scheduledate->shift_id; $checkouts->user_id = Auth::user()->id; $checkouts->pool_id = Auth::user()->pool_id; $checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate()); $checkouts->operasi_status_id = $codeops; $checkouts->keterangan = $keterangan; $checkouts->save(); $cinada = Checkin::where('operasi_time', '=', date('Y-m-d', $dateopertion))->where('fleet_id', '=', $schedule->fleet_id)->first(); if ($cinada) { $cinada->delete(); } if (!$cinada) { $cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $schedule->fleet_id, 'driver_id' => $scheduledate->driver_id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 2, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan)); if ($cin) { $docs = new Checkindocument(); $docs->checkin_id = $cin->id; $docs->save(); //return Redirect::to('schedule'); } // } } } return Redirect::to('schedule'); } }
public function getLastPlayableVideoDuration() { $videostoShow = array(); $currentTime = date('h:i:s A'); $today = date("Y-m-d"); $videoCounter = 0; $timestamp = 0; // dd(new DateTime('today')); $activeSchedule = Schedule::where('active', '=', '1')->where('start_date', '<=', $today)->where('end_date', '>=', $today)->first(); //dd($activeSchedule); if ($activeSchedule) { /*$videoList = Videos::where('schedule_id','=',$activeSchedule->id) ->where('active','=', '1') ->orderBy('position')->get();*/ $videoList = DB::select(DB::raw('select * from `videolist` where `schedule_id` = ' . $activeSchedule->id . ' and `active` = \'1\' ORDER BY STR_TO_DATE(time, \'%h:%i:%s\') desc LIMIT 1')); } else { $videoList = []; } if (empty($videoList)) { $videostoShow[] = array('videoId' => null, 'startsAt' => null, 'endsAt' => null); } else { $datetimepickers = date('m/d/Y h:i:s a', strtotime($videoList[0]->time)); //dd($videoList[0]); $videostoShow[] = array('videoId' => $videoList[0]->id, 'startsAt' => date('U', strtotime($today . ' ' . $videoList[0]->time)), 'endsAt' => date('U', strtotime($videoList[0]->time) + $videoList[0]->length + 1)); } return $videostoShow; }
protected function getMenuData() { $menu_data = array(); $row = Practiceinfo::find(Session::get('practice_id')); $menu_data['mtm'] = $row->mtm_extension; $menu_data['id'] = Session::get('pid'); $row1 = Encounters::where('pid', '=', Session::get('pid'))->where('eid', '!=', '')->where('practice_id', '=', Session::get('practice_id'))->orderBy('eid', 'desc')->first(); if ($row1) { $menu_data['lastvisit'] = date('F jS, Y', strtotime($row1->encounter_DOS)); } else { $menu_data['lastvisit'] = "No previous visits."; } $row2 = Schedule::where('pid', '=', Session::get('pid'))->where('start', '>', time())->first(); if (isset($row2->start)) { $menu_data['nextvisit'] = '<br>' . date('F jS, Y, g:i A', $row2->start); } else { $menu_data['nextvisit'] = 'None.'; } $row3 = Encounters::where('pid', '=', Session::get('pid'))->where('eid', '!=', '')->where('practice_id', '=', Session::get('practice_id'))->where('encounter_template', '=', 'standardpsych')->where('addendum', '=', 'n')->orderBy('eid', 'desc')->first(); if ($row3) { $psych_date = strtotime($row3->encounter_DOS); $new_psych_date = $psych_date + 31556926; $psych_query = Encounters::where('pid', '=', Session::get('pid'))->where('eid', '!=', '')->where('practice_id', '=', Session::get('practice_id'))->where('addendum', '=', 'n')->where(function ($query_array1) { $query_array1->where('encounter_template', '=', 'standardpsych')->orWhere('encounter_template', '=', 'standardpsych1'); })->orderBy('eid', 'desc')->get(); $tp_date = ''; if ($psych_query) { $i = 0; $psych_comp = ''; $psych_comp1 = ''; $tp_eid = ''; foreach ($psych_query as $psych_row) { $planInfo = Plan::find($psych_row->eid); if ($planInfo) { if ($i == 0) { $psych_comp = $planInfo->goals; $psych_comp .= $planInfo->tp; $tp_eid = $psych_row->eid; $tp_eid1 = $tp_eid; } else { $psych_comp1 = $planInfo->goals; $psych_comp1 .= $planInfo->tp; $tp_eid1 = $psych_row->eid; } if ($psych_comp1 != $psych_comp && $i != 0) { $tp = DB::table('encounters')->where('eid', '=', $tp_eid)->first(); $tp_date = '<strong>Most recent TP adjustment:</strong> ' . date('F jS, Y', strtotime($tp->encounter_DOS)) . '<br>'; break; } else { $i++; $tp_eid = $tp_eid1; } } } } $menu_data['psych'] = '<strong>Last Annual Psychiatric Eval:</strong> ' . date('F jS, Y', $psych_date) . '<br><strong>Next Annual Psychiatric Eval Due:</strong> ' . date('F jS, Y', $new_psych_date) . '<br>' . $tp_date; } else { $menu_data['psych'] = ''; } $menu_data['supplements'] = $row->supplements_menu_item; $menu_data['immunizations'] = $row->immunizations_menu_item; return $menu_data; }
<table class="table table-condensed table-bordered table-striped table-small"> {{-- loop group in pool --}} @forelse( Schedulegroup::where('schedule_master_id','=',$master->id)->where('pool_id','=',Auth::user()->pool_id)->get() as $group ) <tr> <td class="span2"><span class="label">Group #{{ $group->group }} </span> <a class="delete_toggler btn btn-mini btn-danger" rel="{{ $group->id }}"> Delete </a></td> <td class="span8"> {{-- loop fleet in group --}} @foreach(Schedulefleetgroup::where('schedule_group_id','=', $group->id )->get() as $fleet) <?php $fleetz = Fleet::find($fleet->fleet_id); ?> @if($fleetz) <span class="label label-info">{{ $fleetz->taxi_number }}</span> <?php $x = Schedule::where('fleet_id', '=', $fleet->fleet_id)->where('year', '=', date('Y', time()))->order_by('month', 'desc')->first(); if ($x) { echo 'Last Generate: '; echo '<span class="label label-info">'; echo MyFungsi::bulan($x->month); echo '</span>'; } ?> @endif @endforeach </td> <td class="span2"><a class="label label-info" href="{{URL::to('schedule/create')}}?id={{$group->id}}"> Create Jadwal </a></td> </tr> @empty <tr> <td> Tidak ada armada di master kepang ini </td> </tr>
<div class="form-group"> <label class="col-sm-2 col-sm-2 control-label">Name</label> <div class="col-sm-10"> <input type="text" class="form-control" name="name" id="vidname" value="{{$video->name}}"> </div> </div> <div class="form-group"> <label class="col-sm-2 col-sm-2 control-label">Select Schedule</label> <div class="col-sm-10"> <select class="form-control" name="schedule_id"> <option>Select...</option> @foreach (Schedule::get() as $schedule) <?php $SelectedSchedule = Schedule::where('id', '=', $video->schedule_id)->first(); if ($SelectedSchedule->id == $schedule->id) { ?> <option value="{{$schedule->id}}" selected="selected">{{$schedule->name}}</option> <?php } else { ?> <option value="{{$schedule->id}}">{{$schedule->name}}</option> <?php } ?> @endforeach </select> </div> </div>
protected function insert_schedules() { $doctors = Doctor::all(); foreach ($doctors as $doctor) { $count = rand(300, 500); while ($count--) { $date = $this->get_random_date(); $schedules = Schedule::where('date', $date)->where('doctor_id', $doctor->id)->get(); if ($schedules->count()) { continue; } // 添加早上排班 if (rand(0, 1)) { Schedule::create(['date' => $date, 'period' => 0, 'doctor_id' => $doctor->id]); } // 添加下午排班 if (rand(0, 1)) { Schedule::create(['date' => $date, 'period' => 1, 'doctor_id' => $doctor->id]); } } } }
/** * Updates all existing templates with changes provided. * * @return view templateManagementView */ public function updateTemplates() { $templates = Schedule::where('schdl_is_template', '=', '1')->orderBy('schdl_title', 'ASC')->get(); foreach ($templates as $template) { if (Input::get('destroy' . $template->id)) { // remove from the list of templates, but don't touch corrsponding event/schedule $template->schdl_is_template = 0; $template->save(); } else { // update title $template->schdl_title = Input::get('schdl_title' . $template->id); $template->save(); } } // need to update our index after the changes $templates = Schedule::where('schdl_is_template', '=', '1')->with('getClubEvent')->orderBy('schdl_title', 'ASC')->get(); return View::make('templateManagementView', compact('templates')); }
public function postsCalendar() { $user_id = Auth::user()->id; $networks = Network::where('user_id', '=', $user_id)->get(); $settings = Settings::where('user_id', '=', $user_id)->first(); $default_networks = json_decode($settings->default_networks); $schedules = Schedule::where('user_id', '=', $user_id)->get(); $custom_schedule_checked = ''; $default_schedule = $settings->schedule_id; $page_data = array('networks' => $networks, 'default_networks' => $default_networks, 'default_schedule' => $default_schedule, 'schedules' => $schedules, 'custom_schedule_checked' => $custom_schedule_checked); $this->layout->title = 'Posts'; $this->layout->handlebars = true; $this->layout->posts = true; $this->layout->posts_calendar = true; $this->layout->new_post = true; $this->layout->content = View::make('admin.posts_calendar', $page_data); }
echo '<br>'; echo '<table class="table table-bordered table-striped table-condensed">'; echo '<thead> <tr><th>Body</th> <th>Driver</th>'; for ($i = 1; $i <= $countmonth; $i++) { echo '<th>' . $i . '</th>'; } echo '</tr> </thead>'; $driver_ar = array(); // loop fleet group foreach (Schedulefleetgroup::where_schedule_group_id($grp->id)->get() as $scf) { //echo 'fleet id'; echo $scf->fleet_id; echo '<br>'; // loop schedule $scdul = Schedule::where('fleet_id', '=', $scf->fleet_id)->where('pool_id', '=', Auth::user()->pool_id)->where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(); foreach ($scdul as $as) { // loop schedule date / driver $scheduledate = Scheduledate::where('schedule_id', '=', $as->id)->group_by('driver_id')->get(array('driver_id')); foreach ($scheduledate as $gdriver) { if (!in_array($gdriver->driver_id, $driver_ar)) { array_push($driver_ar, $gdriver->driver_id); } } } } /********************************/ /* Proses Pembuatan Jadwal View */ /********************************/ if (is_array($driver_ar) && !empty($driver_ar)) { foreach ($driver_ar as $key => $value) {
/** * Updates multiple schedules. */ public function bulkUpdateSchedule($year, $week) { // Create week start date $weekStart = date('Y-m-d', strtotime($year . "W" . $week . '1')); // Create the number of the next week and the week end date // We go till tuesday (day 2) because café needs alternative week view (Mi-Di) $nextWeek = date("W", strtotime("next Week" . $weekStart)); $nextYear = date("Y", strtotime("next Week" . $weekStart)); $weekEnd = date('Y-m-d', strtotime($nextYear . "W" . $nextWeek . '2')); // Create (empty) index of all schedules we need to update $updateIds = array(); // Collect IDs of event schedules shown in chosen week view $events = ClubEvent::where('evnt_date_start', '>=', $weekStart)->where('evnt_date_start', '<=', $weekEnd)->get(); // Add them to the index foreach ($events as $event) { array_push($updateIds, $event->getSchedule->id); } // Collect IDs of tasks shown in week view $tasks = Schedule::where('schdl_show_in_week_view', '=', '1')->where('schdl_due_date', '>=', $weekStart)->where('schdl_due_date', '<=', $weekEnd)->get(); // Add them to the index foreach ($tasks as $task) { array_push($updateIds, $task->id); } // Update each of the schedules in the index foreach ($updateIds as $schedule) { $this->onUpdate($schedule); } return Redirect::back(); }
$data['employee_number'] = Input::get('employee_number'); $employeeNumber = Employee::where('employee_number', '=', trim($data['employee_number']))->first(); $defaultSchedules = Workshift::where('employee_id', '=', trim($employeeNumber->id))->get(); $employeeId = Session::get('userEmployeeId'); $employee = new Employee(); $employeeInfo = $employee->getEmployeeInfoById($employeeId); $getUserEmployee = DB::table('users')->join('employees', 'users.employee_id', '=', 'employees.id')->join('users_groups', 'users_groups.user_id', '=', 'users.id')->join('groups', 'users_groups.group_id', '=', 'groups.id')->get(); return View::make('admin.scheduling', ['employeeInfo' => $employeeInfo, 'getUserEmployee' => $getUserEmployee, 'defaultSchedules' => $defaultSchedules]); //return View::make('admin.scheduling', ['employeeInfo' => $employeeInfo, 'defaultSchedules' => $defaultSchedules]); })); Route::post('/admin/scheduling/upload/new/schedule', array('as' => 'adminUploadNewSchedule', 'uses' => 'EmployeesController@postShift')); Route::post('/admin/scheduling/search/uploaded/schedule', array('as' => '', 'uses' => function () { $data = Input::all(); //$data['employee_number'] = Input::get('employee_number'); $employeeNumber = Employee::where('employee_number', '=', trim($data['employee_number']))->first(); $uploadedSchedules = Schedule::where('employee_id', '=', trim($employeeNumber->id))->whereBetween('schedule_date', array($data["schedule_date_from"], $data["schedule_date_to"]))->get(); $employeeId = Session::get('userEmployeeId'); $employee = new Employee(); $employeeInfo = $employee->getEmployeeInfoById($employeeId); $getUserEmployee = DB::table('users')->join('employees', 'users.employee_id', '=', 'employees.id')->join('users_groups', 'users_groups.user_id', '=', 'users.id')->join('groups', 'users_groups.group_id', '=', 'groups.id')->get(); return View::make('admin.scheduling', ['employeeInfo' => $employeeInfo, 'getUserEmployee' => $getUserEmployee, 'uploadedSchedules' => $uploadedSchedules]); //return View::make('admin.scheduling', ['employeeInfo' => $employeeInfo, 'defaultSchedules' => $defaultSchedules]); })); /** * * Administration: TimeClock & Attendace * */ Route::get('/admin/timeclock', array('as' => 'adminTimeClock', 'uses' => function () { //return 'Administration: TimeClock & Attendace'; $employeeId = Session::get('userEmployeeId');
/** * Generate the view for editing an event specified by $id. * * @param int $id * @return view editClubEventView */ public function showEditEvent($id) { $event = ClubEvent::findOrFail($id); $schedule = $event->getSchedule()->getResults(); $jobtypes = Jobtype::where('jbtyp_is_archived', '=', '0')->orderBy('jbtyp_title', 'ASC')->get(); $places = Place::orderBy('plc_title', 'ASC')->lists('plc_title', 'id'); $templates = Schedule::where('schdl_is_template', '=', '1')->orderBy('schdl_title', 'ASC')->get(); $template = Schedule::where('id', '=', $schedule->id)->first(); // put template data into entries $entries = $schedule->getEntries()->with('getJobType')->getResults(); // put name of the active template for further use $activeTemplate = $template->schdl_title; return View::make('editClubEventView', compact('event', 'schedule', 'places', 'jobtypes', 'templates', 'template', 'entries', 'activeTemplate')); }
public function postGetAppointments($user_id) { $start_time = time() - 604800; $end_time = time() + 604800; $query = Schedule::where('provider_id', '=', $user_id)->where('pid', '=', Session::get('pid'))->whereBetween('start', array($start_time, $end_time))->get(); $data = array(); if ($query) { foreach ($query as $row) { $key = $row->visit_type . ',' . $row->appt_id; $value = date('Y-m-d H:i:s A', $row->start) . ' (Appt ID: ' . $row->appt_id . ')'; $data[$key] = $value; } } echo json_encode($data); }
public function post_schedulereset() { $data = Input::json(); $schedule = Schedule::where('fleet_id', '=', $data->fleet_id)->where('month', '=', $data->month)->where('year', '=', $data->year)->first(); if ($schedule->delete()) { return json_encode(array('Jadwal Berhasil di Hapus')); } else { return json_encode(array('Jadwal Gagal di Hapus')); } }
public function appointment_screen($practice_id) { $practice = DB::table('practiceinfo')->where('practice_id', '=', $practice_id)->first(); if ($practice->timezone != null) { date_default_timezone_set($practice->timezone); } $i = 0; $query = DB::table('demographics')->join('demographics_relate', 'demographics_relate.pid', '=', 'demographics.pid')->select('demographics_relate.appointment_reminder', 'demographics.pid', 'demographics_relate.demographics_relate_id')->where('demographics_relate.practice_id', '=', $practice_id)->where('demographics.active', '=', '1')->where('demographics.reminder_to', '!=', '')->get(); if ($query) { foreach ($query as $row) { $row2 = Schedule::where('pid', '=', $row->pid)->where('start', '>', time())->first(); if (isset($row2->start)) { $data['appointment_reminder'] = 'n'; DB::table('demographics_relate')->where('demographics_relate_id', '=', $row->demographics_relate_id)->update($data); $this->audit('Update'); } else { if ($row->appointment_reminder == 'n') { $newdate = time() + $practice->appointment_interval; $data['appointment_reminder'] = date('Y-m-d', $newdate); DB::table('demographics_relate')->where('demographics_relate_id', '=', $row->demographics_relate_id)->update($data); $this->audit('Update'); $i++; } } } } return $i; }
public function postDemographicsList() { $practice_id = Session::get('practice_id'); $pid = Session::get('pid'); $row = Demographics::find($pid); $row_relate = Demographics_relate::where('pid', '=', $pid)->where('practice_id', '=', $practice_id)->first(); $result = ''; if ($row) { $result .= '<p class="tips"><strong>Address:</strong><br>' . $row->address . '<br>' . $row->city . ', ' . $row->state . ' ' . $row->zip . '</p>'; $result .= '<p class="tips"><strong>Phone Numbers:</strong><br>Home: ' . $row->phone_home . '<br>Work: ' . $row->phone_work . '<br>Cell: ' . $row->phone_cell . '<br>Email: ' . $row->email . '</p>'; $result .= '<p class="tips"><strong>Emergency Contact:</strong><br>Contact: ' . $row->emergency_contact . ', ' . $row->emergency_phone . '</p>'; $gender = Session::get('gender'); if ($gender == 'female') { if ($row->pregnant != 'no') { $pregnant = 'Yes'; } else { $pregnant = 'No'; } $result .= '<p class="tips"><strong>Other:</strong><br>Sexually Active: ' . ucfirst($row->sexuallyactive) . '<br>Tobacco Use: ' . ucfirst($row->tobacco) . '<br>Pregnant: ' . $pregnant . '</p>'; } else { $result .= '<p class="tips"><strong>Other:</strong><br>Sexually Active: ' . ucfirst($row->sexuallyactive) . '<br>Tobacco Use: ' . ucfirst($row->tobacco) . '</p>'; } $result .= '<p class="tips">Active since ' . $row->date . '</p>'; if ($row_relate->id != '') { $result .= '<p class="tips">Online account is active.</p>'; } else { $result .= '<p class="tips">No online account.</p>'; } $schedule1 = Schedule::where('pid', '=', $pid)->where('status', '=', 'LMC')->get(); $schedule2 = Schedule::where('pid', '=', $pid)->where('status', '=', 'DNKA')->get(); $result .= '<p class="tips"><strong># Last minute cancellations: ' . count($schedule1) . '</strong></p>'; $result .= '<p class="tips"><strong># Did not keep appointments: ' . count($schedule2) . '</strong></p>'; $result .= '<p class="tips"><strong>Billing Notes:</strong><br>' . nl2br($row->billing_notes) . '</p>'; $query1 = Insurance::where('pid', '=', $pid)->where('insurance_plan_active', '=', 'Yes')->get(); if ($query1) { $result .= '<p class="tips"><strong>Active Insurance:</strong>'; foreach ($query1 as $row1) { $result .= '<br>' . $row1->insurance_plan_name . '; ID: ' . $row1->insurance_id_num . '; Group: ' . $row1->insurance_group; if ($row1->insurance_copay != '') { $result .= '; Copay: ' . $row1->insurance_copay; } if ($row1->insurance_deductible != '') { $result .= '; Deductible: ' . $row1->insurance_deductible; } if ($row1->insurance_comments != '') { $result .= '; Comments: ' . $row1->insurance_comments; } } $result .= '</p>'; } $result .= '<p class="tips"><strong>Credit Card on File: '; if ($row->creditcard_number != '') { $result .= 'Yes'; } else { $result .= 'No'; } $result .= '</strong></p>'; } else { $result .= 'None available.'; } echo $result; }