public function edit($id)
{
$user = User::with('AssigmentRole')->with('Neighbors')->findOrFail($id);
$status = Status::all();
$roles = Role::all();
return View::make('dashboard.users.edit', ['row' => $user, 'status' => $status, 'roles' => $roles]);
}
public function getStatuses()
{
$allStatuses = Status::all();
$statuses = [];
foreach ($allStatuses as $thisStatus) {
$statuses[$thisStatus->id] = $thisStatus->title;
}
return $statuses;
}
/**
* Get list status
* @return array
*/
public function scopeGetList()
{
$status = Status::all();
$data = array();
foreach ($status as $stt) {
$data[$stt->id] = $stt->name;
}
return $data;
}
public function getIndex()
{
if (Request::ajax()) {
$this->init();
$status = Status::all();
$all_messages = DB::table('gcm_messages_state')->leftJoin('gcm_messages', 'gcm_messages_state.message_id', '=', 'gcm_messages.id')->leftJoin('gcm_users', 'gcm_messages_state.user_id', '=', 'gcm_users.id')->leftJoin('gcm_status', 'gcm_messages_state.state', '=', 'gcm_status.id')->select('gcm_messages_state.id', 'gcm_messages_state.message_id', 'gcm_messages.message', 'gcm_messages_state.user_id', 'gcm_users.name as gcm_users_name', 'gcm_messages_state.state', 'gcm_status.name as gcm_status_name', 'gcm_messages_state.state_text', 'gcm_messages_state.created_at as gcm_messages_state_created_at')->whereRaw('gcm_messages_state.created_at >= "' . $this->from_date . '" and gcm_messages_state.created_at <= "' . $this->to_date . '" and gcm_messages_state.state like ' . $this->state)->orderBy('gcm_messages_state.created_at', 'desc')->paginate($this->count);
return Response::json(View::make('push.notif.reports', array('messages' => $all_messages, 'status' => $status))->render());
}
$all_messages = DB::table('gcm_messages_state')->leftJoin('gcm_messages', 'gcm_messages_state.message_id', '=', 'gcm_messages.id')->leftJoin('gcm_users', 'gcm_messages_state.user_id', '=', 'gcm_users.id')->leftJoin('gcm_status', 'gcm_messages_state.state', '=', 'gcm_status.id')->select('gcm_messages_state.id', 'gcm_messages_state.message_id', 'gcm_messages.message', 'gcm_messages_state.user_id', 'gcm_users.name as gcm_users_name', 'gcm_messages_state.state', 'gcm_status.name as gcm_status_name', 'gcm_messages_state.state_text', 'gcm_messages_state.created_at as gcm_messages_state_created_at')->orderBy('gcm_messages_state.created_at', 'desc')->paginate($this->count);
$status = Status::all();
return View::make('push.notif.notif_state')->with('messages', $all_messages)->with('status', $status);
}
public function getStatus()
{
$new_status_id = '';
$used_status_id = '';
$statuses = Status::all();
foreach ($statuses as $status) {
if ($status->status == 'Used') {
$used_status_id = $status->id;
} else {
if ($status->status == 'New') {
$new_status_id = $status->id;
}
}
}
$status = array();
$status['new_id'] = $new_status_id;
$status['used_id'] = $used_status_id;
return $status;
}
public function index()
{
$this->layout->body_class = 'srp';
$zip_code = Input::query('zip_code', '');
$distance = Input::query('distance', '50');
if (empty($zip_code)) {
$this->findLocation();
$zip_code = Session::get('zip_code', '');
}
Session::put('zip_code', $zip_code);
Session::put('distance', $distance);
$title = '';
$make_filter = Input::get('make', '');
$makes = explode("-", $make_filter);
$model_filter = Input::get('model', '');
$models = explode("-", $model_filter);
foreach ($makes as $make) {
$entities = Make::where('id', '=', $make);
if ($entities->count()) {
$entity = $entities->first();
$title = $title . $entity->make . ' ';
}
}
$models_available = false;
foreach ($models as $model) {
$entities = Model::where('id', '=', $model);
if ($entities->count()) {
$entity = $entities->first();
$title = $title . $entity->model . ' - ';
$models_available = true;
}
}
if ($models_available == true) {
$title = substr($title, 0, -2);
}
$search_title = $title;
$search_text = '';
if (sizeof($makes) == 1 && sizeof($models) <= 1) {
$entities = Make::where('id', '=', $makes[0]);
if ($entities->count()) {
$entity = $entities->first();
$search_text = $entity->make;
if (sizeof($models) == 1) {
$entities = Model::where('id', '=', $models[0]);
if ($entities->count()) {
$entity = $entities->first();
$search_text = $search_text . ' ' . $entity->model;
}
}
}
}
$search_location = '';
$location_info = 'change location';
if (!empty($zip_code)) {
$locations = Location::where('zip_code', '=', $zip_code);
if ($locations->count()) {
$location = Location::where('zip_code', '=', $zip_code)->first();
$city = $location->city;
$state = $location->state;
if (!empty($city) && !empty($state)) {
if ($distance == 0) {
$search_location = 'Within ' . 'unlimited miles from ' . $city . ', ' . $state;
$location_info = 'unlimited miles from ' . $city . ', ' . $state . ' (change)';
} else {
$search_location = 'Within ' . $distance . ' miles from ' . $city . ', ' . $state;
$location_info = $distance . ' miles from ' . $city . ', ' . $state . ' (change)';
}
if (strlen($title) > 0) {
$title = $title . ' near ' . $city . ', ' . $state;
}
}
}
}
$results = $this->executeSearch();
$aggregations = $this->executeAggregations();
$selected_filters = $this->findSelectedFilters($aggregations);
$remaining_filters = $this->findRemainingFilters();
$search_filter = '';
foreach ($selected_filters as $filter) {
$search_filter = $search_filter . '<strong -class->' . $filter['name'] . ':' . '</strong>';
foreach ($filter['values'] as $value) {
$search_filter = $search_filter . $value['title'] . ',';
}
$search_filter = substr($search_filter, 0, -1) . ' ';
}
$paid = $aggregations['paid'];
$page = Input::get('page', '1');
$from = ($page - 1) * 10;
$featured = -1;
$standard = -1;
if ($paid > 0 && $page == 1) {
$featured = 0;
}
if ($from == $paid) {
$standard = 0;
} else {
if ($paid - $from < 9) {
$standard = $paid - $from;
}
}
$new_status_id = '';
$used_status_id = '';
$statuses = Status::all();
foreach ($statuses as $status) {
if ($status->status == 'Used') {
$used_status_id = $status->id;
} else {
if ($status->status == 'New') {
$new_status_id = $status->id;
}
}
}
$tab = array();
$tab['all_link'] = '';
$tab['new_link'] = $new_status_id;
$tab['used_link'] = $used_status_id;
$all_count = 0;
$new_count = 0;
$used_count = 0;
$status_aggs = $aggregations['status'];
if (array_key_exists($new_status_id, $status_aggs)) {
$new_count = $status_aggs[$new_status_id]['count'];
}
if (array_key_exists($used_status_id, $status_aggs)) {
$used_count = $status_aggs[$used_status_id]['count'];
}
$all_count = $new_count + $used_count;
$tab['all_count'] = '(' . $all_count . ')';
$tab['new_count'] = '(' . $new_count . ')';
$tab['used_count'] = '(' . $used_count . ')';
$tab['all_class'] = 'inactive';
$tab['new_class'] = 'inactive';
$tab['used_class'] = 'inactive';
$selected_status = Input::get('status', '');
if ($selected_status == $new_status_id) {
$tab['new_class'] = 'active';
} else {
if ($selected_status == $used_status_id) {
$tab['used_class'] = 'active';
} else {
$tab['all_class'] = 'active';
}
}
$save_search_popup = 'saveSearchModalGuest';
$save_vehicle_popup = 'saveVehicleModalGuest';
if (Auth::check()) {
$save_search_popup = 'saveSearchModalUser';
$save_vehicle_popup = 'saveVehicleModalUser';
}
$data = array('zip_code' => $zip_code, 'distance' => $distance, 'search_text' => $search_text, 'title' => $title, 'location_info' => $location_info, 'total' => $results['total'], 'selected_filters' => $selected_filters, 'remaining_filters' => $remaining_filters, 'results' => $results['results'], 'aggregations' => $aggregations, 'standard' => $standard, 'featured' => $featured, 'tab' => $tab, 'save_search_popup' => $save_search_popup, 'save_vehicle_popup' => $save_vehicle_popup, 'search_title' => $search_title, 'search_location' => $search_location, 'search_filter' => $search_filter);
$this->layout->contents = View::make('search/search', $data);
}
public function adsParameter()
{
$make_input = Input::get('make', '');
$model_input = Input::get('model', '');
$body_input = Input::get('body', '');
$status_input = Input::get('status', '');
$statuses = '';
$makes = '';
$models = '';
$bodies = '';
$new_status_id = '';
$used_status_id = '';
$status_values = Status::all();
foreach ($status_values as $status) {
if ($status->status == 'Used') {
$used_status_id = $status->id;
} else {
if ($status->status == 'New') {
$new_status_id = $status->id;
}
}
}
if ($status_input == $new_status_id) {
$statuses = 'New-';
} else {
if ($status_input == $used_status_id) {
$statuses = 'Used-';
}
}
foreach (explode("-", $make_input) as $make) {
$entities = Make::where('id', '=', $make);
if ($entities->count()) {
$entity = $entities->first();
$makes = $makes . $entity->make . '-';
}
}
foreach (explode("-", $model_input) as $model) {
$entities = Model::where('id', '=', $model);
if ($entities->count()) {
$entity = $entities->first();
$models = $models . $entity->model . '-';
}
}
foreach (explode("-", $body_input) as $body) {
$entities = Body::where('id', '=', $body);
if ($entities->count()) {
$entity = $entities->first();
$bodies = $bodies . $entity->body . '-';
}
}
$ads = '';
if (!empty($statuses)) {
$ads = $ads . $statuses;
}
if (!empty($makes)) {
$ads = $ads . $makes;
}
if (!empty($models)) {
$ads = $ads . $models;
}
if (!empty($bodies)) {
$ads = $ads . $bodies;
}
if (!empty($ads)) {
$ads = substr($ads, 0, -1);
}
return Response::json(array('ads' => $ads));
}
public function getAll()
{
$obj = new Status($this->db);
echo json_encode($obj->all());
}
<?php
$I = new AcceptanceTester($scenario);
$I->wantTo('ensure that the tickets index filtering works');
TestCommonAdmin::logMeIn($I);
$statuses = Status::all();
foreach ($statuses as $status) {
$I->amOnPage('/tickets/status/' . $status->title);
$I->see('Title', 'th');
$I->see('Updated At', 'th');
$I->see('Priority', 'th');
$I->see('Owner', 'th');
$I->dontSee('whoops');
}
/**
* [postData - handle company specific posted data]
* @return [json] [DT compatible object]
*/
public function postData()
{
$Model = $this->modelName;
// Build our Editor instance and process the data coming from _POST
global $db;
$data = Editor::inst($db, 'services')->fields(Field::inst('services.id'), Field::inst('services.name'), Field::inst('services.category_id'), Field::inst('service_categories.name'), Field::inst('services.invoice_periods_id'), Field::inst('invoice_periods.description'), Field::inst('services.status_id'), Field::inst('statuses.description'), Field::inst('services.default_monthly_costs'), Field::inst('services.comment'))->leftJoin('service_categories', 'service_categories.id', '=', 'services.category_id')->leftJoin('statuses', 'statuses.id', '=', 'services.status_id')->leftJoin('invoice_periods', 'invoice_periods.id', '=', 'services.invoice_periods_id')->process($_POST)->data();
$data['service_categories'] = ServiceCategory::all(['id AS value', 'name AS label']);
$data['statuses'] = Status::all(['id AS value', 'description AS label']);
$data['invoice_periods'] = Period::all(['id AS value', 'description AS label']);
return Response::json($data);
}
/**
* [postModelData - handle company specific posted subscriptions data]
* @param [Eloquent model] $model [company model]
* @return [json] [DT compatible object]
*/
public function postModelData($model)
{
$Model = $this->modelName;
if (isset($_POST["data"]) && !empty($_POST["data"])) {
$tot_price_str = $_POST['data']['subscriptions']['total_price'];
if (empty($tot_price_str)) {
$subs_id = (int) $_POST['data']['subscriptions']['id'];
$subscription = Subscription::find($subs_id);
$tot_price_str = $this->subscriptionTotalPrice($_POST['data']['subscriptions']['subscription_start'], $_POST['data']['subscriptions']['subscription_end'], $_POST['data']['subscriptions']['invoice_periods_id'], $_POST['data']['subscriptions']['price']);
$_POST['data']['subscriptions']['total_price'] = $tot_price_str;
}
//error_log("Le POST".json_encode($_POST['data']['subscriptions']['total_price']));
}
// Build our Editor instance and process the data coming from _POST
global $db;
$data = Editor::inst($db, 'subscriptions')->fields(Field::inst('subscriptions.id'), Field::inst('subscriptions.company_id'), Field::inst('service_categories.id'), Field::inst('service_categories.name'), Field::inst('subscriptions.service_id'), Field::inst('services.name'), Field::inst('subscriptions.description'), Field::inst('subscriptions.price'), Field::inst('subscriptions.total_price'), Field::inst('subscriptions.subscription_start'), Field::inst('subscriptions.subscription_end')->validator(function ($val, $data, $opts) {
$date_start = strtotime($data['subscriptions']['subscription_start']);
$date_end = strtotime($data['subscriptions']['subscription_end']);
return $date_end > $date_start ? true : "Error: End date precedes start date";
}), Field::inst('subscriptions.invoice_id'), Field::inst('subscriptions.invoice_periods_id'), Field::inst('invoice_periods.description'), Field::inst('subscriptions.status_id'), Field::inst('statuses.description'), Field::inst('subscriptions.status_date'))->leftJoin('invoice_periods', 'invoice_periods.id', '=', 'subscriptions.invoice_periods_id')->leftJoin('statuses', 'statuses.id', '=', 'subscriptions.status_id')->leftJoin('companies', 'companies.id', '=', 'subscriptions.company_id')->leftJoin('services', 'services.id', '=', 'subscriptions.service_id')->leftJoin('service_categories', 'service_categories.id', '=', 'services.category_id')->process($_POST)->data();
$data['companies'] = Company::all(['id AS value', 'bedrijfsnaam AS label']);
$data['services'] = Service::all(['id AS value', 'name AS label']);
$data['service_categories'] = ServiceCategory::all(['id AS value', 'name AS label']);
$data['statuses'] = Status::all(['id AS value', 'description AS label']);
$data['invoice_periods'] = Period::all(['id AS value', 'description AS label']);
return Response::json($data);
}
function listStatuses()
{
echo Status::all()->toJson();
}
