public function show($id)
{
// init
$event = Events::with(array('city', 'eventcategory', 'user'))->where('id', '=', $id)->orderBy('id', 'desc')->first();
$data = array('menu' => $this->_menu, 'title' => 'Event - ' . $event->name, 'description' => '', 'breadcrumb' => array('Event' => route('admin.event'), $event->name => route('admin.event.show', $event->id)));
if ($event == null) {
return App::abort('404');
}
$data['event'] = $event;
$social_action = SocialActionEvent::with(array('user', 'socialAction'))->where('event_id', '=', $event['id'])->orderBy('id', 'desc')->get();
// Get category
// $data['social_actions'] = $social_action;
$sos = array();
if (count($social_action) > 0) {
foreach ($social_action as $val) {
# code...
$sos[] = $val['social_action'];
}
$data['social_actions'] = $sos;
// Get Photos that related with this
$data['photos'] = Photo::where('type_name', '=', 'social_actions')->where('type_id', '=', $social_action[0]->id)->orderBy('id', 'desc')->get();
} else {
$data['social_actions'] = array();
$data['photos'] = array();
}
return View::make('admin.pages.event.show')->with($data);
}
public function index()
{
// init
$data = array();
// set offset & limit
$limit = 8;
$page = Input::has('page') ? Input::get('page') : 1;
$offset = ($page - 1) * $limit;
// get all categories
$data['categories'] = EventCategory::where('status', '=', 1)->get();
// get all cities
$data['cities'] = City::where('status', '=', 1)->orderBy('name', 'asc')->get();
// get input
$input = Input::all();
// get social actions
$events = Events::with(array('city', 'category'))->where('status', '!=', 0);
if (Input::has('q')) {
// keyword
$input['q'] = trim($input['q']);
$events = $events->where('name', 'like', '%' . $input['q'] . '%');
}
if (Input::has('category') and Input::get('category') != 'all') {
// category
$events = $events->where('event_category_id', '=', $input['category']);
}
if (Input::has('city') and Input::get('city') != 'all') {
// city
$events = $events->where('city_id', '=', $input['city']);
}
$data['events'] = $events->orderBy('ended_at', 'desc')->paginate($limit);
// set input
$data['input'] = $input;
return View::make('bagikasih.event.index', $data);
}
public function index()
{
$blogs = Blog::with('author')->orderBy('created_at', 'desc')->take(10)->get();
$events = Events::with('author')->orderBy('created_at', 'desc')->take(8)->get();
$groups = Group::with('author')->orderBy('created_at', 'desc')->take(8)->get();
$photos = Photo::with('author')->orderBy('created_at', 'desc')->take(8)->get();
return View::make('home.index')->with('blogs', $blogs)->with('events', $events)->with('groups', $groups)->with('photos', $photos);
}
public function index()
{
// init
$data = array('menu' => $this->_menu, 'title' => 'Dashboard', 'description' => '', 'breadcrumb' => array('Dashboard' => '/'));
// New payment that need confirmation
$data['payments'] = Payment::with(array('user', 'donations'))->where('status', '=', 0)->get();
// New social target that need confirmation
$data['social_targets'] = SocialTarget::with(array('city', 'category', 'user'))->where('status', '=', 0)->get();
// New action action that need confirmation
$data['social_actions'] = SocialAction::with(array('city', 'category', 'user'))->where('status', '=', 0)->get();
// New event that need confirmation
$data['events'] = Events::with(array('city', 'category', 'user'))->where('status', '=', 0)->get();
// New report that need confirmation
$reports = Report::with(array('user'))->where('have_responded', '=', 0)->get();
foreach ($reports as $report) {
$report->setAppends(array('type'));
}
$data['reports'] = $reports;
// return $data;
return View::make('admin.pages.dashboard')->with($data);
}
public function index()
{
$events = Events::with('author')->orderBy('created_at', 'desc')->paginate(20);
return View::make('events.index')->with('events', $events);
}
