<?php // listItem : nom de la procedure dans le model $listItem = 'newListItem'; // Clubs déjà selectionnes $clubExistes = Confide::user()->getListClubId(); // Datas - cherche par Nom if ($inputs['nom'] == 'parNom') { $datas = Club::where('nom', 'LIKE', '%' . $inputs['search'] . '%')->where('id', '>', 1)->whereNotIn('id', $clubExistes)->orderBy('nom', 'ASC')->get(); } // Datas - cherche par Region if ($inputs['nom'] == 'parRegion') { $datas = Club::whereRegionId($inputs['search'])->where('id', '>', 1)->whereNotIn('id', $clubExistes)->orderBy('nom', 'ASC')->get(); } // Limit datas to show : if 0 or not exist then value no limit $param['maxData'] = '60'; // Sub-titre $param['sub-titre'] = 'Sélectionnez un club'; // Select Route $param['selectRoute'] = 'userclub.add'; $param['selectText'] = ''; // Actions $param['actions'] = 'select'; // BackUrl $param['backUrl'] = 'manager'; ?> <!-- List.Blade --> <div class="information white">
$code .= '<option value="' . $result->id . '">' . $result->libelle . '</option>'; } return $code; }); # SelectBox Regions Route::post('sbRegions/{nation_id}', function ($nation_id) { $results = Region::where('nation_id', '=', $nation_id)->get(); $code = ''; foreach ($results as $result) { $code .= '<option value="' . $result->id . '">' . $result->libelle . '</option>'; } return $code; }); # SelectBox Clubs Route::post('sbClubs/{region_id}', function ($region_id) { $results = Club::where('region_id', '=', $region_id)->get(); $code = ''; foreach ($results as $result) { $code .= '<option value="' . $result->id . '">' . $result->nom . '</option>'; } return $code; }); # LoadPage Route::post('loadpage', function () { if (Request::ajax()) { $inputs = Input::all(); $module = Input::get('page'); return View::make($module)->with(['inputs' => $inputs]); } }); });
private function saveClubInfo($user) { $title = Input::get('club_title', ''); $brief = Input::get('club_brief', ''); $img_token = Input::get('img_token_2', ''); if ($title) { $club = Club::where('u_id', '=', $user->u_id)->first(); if (empty($club)) { $club = new Club(); $club->u_id = $user->u_id; $club->s_id = $user->u_school_id; $club->c_title = $title; $club->addClub(); } $club->c_title = $title; $club->c_brief = $brief; $c_id = $club->c_id; $imgObj = new Img('club', $img_token); $club->c_imgs = $imgObj->getSavedImg($c_id, $club->c_imgs); $club->save(); } return true; }
public function censorUserProfileClub($id) { $check = Input::get('check'); $remark = Input::get('remark'); try { $club = Club::where('u_id', '=', $id)->first(); if (empty($club)) { throw new Exception("该用户没有可用的社团", 10001); } if ($check == 1) { $club->c_status = 1; $club->u_is_club_verified = 1; } else { $club->c_status = 2; $club->u_is_club_verified = 0; } $club->remark = $remark; $club->censor(); $re = Tools::reTrue('审核社团信息成功'); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '审核社团信息失败:' . $e->getMessage()); } return Response::json($re); }
/** * @param $region_id * @return mixed */ public static function listClubsOneRegion($region_id) { return Club::where('region_id', '=', $region_id)->lists('nom', 'id'); }