/**
* Get a language by its given name
*
* @param string $name
*
* @return array Language
*/
public function getByName($name)
{
$lang = \Language::where('name', '=', $name)->first();
if (!empty($lang)) {
return $lang->toArray();
}
return $lang;
}
public static function factory($name = null)
{
$instance = new Language();
if (!empty($name)) {
$instance->where('name', $name)->limit(1)->get();
}
return $instance;
}
public function login($language)
{
// Définition de la langue :
if (!$this->setupLanguage($language)) {
App::abort(404);
}
try {
$languages = Language::where('_url', '=', $language)->firstOrFail();
$page = Pages::where('_language', $languages->_id)->where("_name", "=", "user/login")->get()->first();
} catch (Exception $e) {
App::abort(500);
}
// Redirection de l'utilisateur s'il est déjà connecté :
if (Auth::check()) {
return Redirect::to(URL::to($language . '/home'));
}
// Variables :
// Details :
$data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
// Message :
$message = "";
// Inputs :
$login = "";
$password = "";
// Envoi du formulaire de connexion :
if (count(Input::all()) > 0) {
// récupération des inputs :
$login = htmlentities(Input::get('your-login'));
$password = htmlentities(Input::get('your-password'));
// validation des formulaire :
$validator = Validator::make(array('email' => $login, 'password' => $password), array('email' => 'required|email', 'password' => 'required'), array('email.required' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_RQ'), 'email.email' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_INV'), 'password.required' => Lang::get('libelle.CONNEXION_ERROR_PASSWORD_RQ')));
// retour en cas d'erreur :
if ($validator->fails()) {
$message = $validator->messages();
} else {
// connexion en cas de succès :
$auth = Users::where('_email', '=', $login)->where('_password', '=', md5($password))->first();
// si utilisateur trouvé, redirection :
if ($auth) {
Auth::login($auth);
Auth::user()->_ipLastConnection = Request::getClientIp(true);
Auth::user()->_dateLastConnection = date("Y-m-d H:i:s");
Auth::user()->save();
return Redirect::to(URL::to($language . '/home'));
} else {
$message = Lang::get("libelle.CONNEXION_ERROR");
}
}
}
// Renvoi de la vue avec les message(s) d'erreurs :
$page = $this->layout->content = View::make('pages.users.login', array("data" => $data, "page" => $page, "message" => $message));
return Response::make($page, '200');
}
public function rss($language)
{
// Définition de la langue :
if (!$this->setupLanguage($language)) {
App::abort(404);
}
// Variables :
// Details :
$header = '<?xml version="1.0" encoding="UTF-8"?>';
// News (dans un try catch pour gérer les erreurs) :
try {
$languages = Language::where('_url', '=', $language)->firstOrFail();
$news = News::where('_langue', '=', $languages->_id)->get();
$news = $news->sortBy('_date')->take(30);
} catch (Exception $e) {
App::abort(404);
}
// Renvoi de la vue avec les news et l'en-tête :
$page = $this->layout->content = View::make('pages.news.fluxXML', array("news" => $news, "header" => $header));
return Response::make($page, '200')->header('Content-Type', 'text/xml');
}
/**
* @param $id
*/
public function allUserData($id, $mode = 'show')
{
if (!($user = User::find($id))) {
abort(404);
}
$name = $user->full_name;
if (!($fullProfile = Profile::where('user_id', '=', $id)->first())) {
$fullProfile = new Profile();
}
$cityLiving = $this->placeLiving($fullProfile->place_living_id);
$cityFrom = $this->placeFrom($fullProfile->place_from_id);
$languages_high = Language::where('profile_id', '=', $fullProfile->id)->where('level', '=', 'advanced')->get();
$languages_med = Language::where('profile_id', '=', $fullProfile->id)->where('level', '=', 'intermediate')->get();
$languages_low = Language::where('profile_id', '=', $fullProfile->id)->where('level', '=', 'basic')->get();
//Avatar is optional
if ($user->avatar) {
$avatar = $user->avatar;
}
if ($mode == 'show' || $mode == 'references') {
$references = Reference::where('profile_user_id', '=', $id)->with(['user'])->orderBy('updated_at', 'DES')->get();
$age = $user->age;
$owner = \Auth::id() == $id;
$gender = $user->gender;
$places = $user->placesWanted;
$placesVisited = $user->placesVisited;
$avg = Reference::where('profile_user_id', '=', $id)->avg('grade');
$ref = false;
$fav = boolval(Favorites::where('owner_id', \Auth::id())->where('user_id', $id)->first());
if ($mode == 'references') {
$ref = true;
}
return compact('fullProfile', 'references', 'name', 'avatar', 'ref', 'avg', 'cityFrom', 'cityLiving', 'age', 'gender', 'id', 'owner', 'fav', 'languages_high', 'languages_med', 'languages_low', 'places', 'placesVisited');
} else {
if ($mode == 'edit') {
return compact('fullProfile', 'cityFrom', 'cityLiving', 'name', 'avatar', 'id', 'languages_high', 'languages_med', 'languages_low');
} else {
return abort(404);
}
}
}
public function search($language)
{
if (!$this->setupLanguage($language)) {
App::abort(404);
}
// VARIABLES :
// Pages :
try {
$languages = Language::where('_url', '=', $language)->firstOrFail();
$page = Pages::where('_language', $languages->_id)->where("_name", "=", "search")->get()->first();
} catch (Exception $e) {
App::abort(500);
}
// Request :
$accentARemplacer = array('Š' => 'S', 'š' => 's', 'Ž' => 'Z', 'ž' => 'z', 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Æ' => 'A', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ý' => 'Y', 'Þ' => 'B', 'ß' => 'Ss', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'a', 'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ð' => 'o', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ý' => 'y', 'ý' => 'y', 'þ' => 'b', 'ÿ' => 'y');
$request = trim(Input::get("q"));
$requestWithoutAccent = strtr($request, $accentARemplacer);
$requestWithAccent = $request;
$request_explode = array_unique(array_merge(explode(" ", $requestWithoutAccent), explode(" ", $requestWithAccent)));
// Details :
$data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => " ", $request => ""));
//
$results = array();
if (count($request_explode) > 0) {
foreach ($request_explode as $key => $value) {
$pages = Pages::where("_keywords", "LIKE", '%' . $value . '%')->orWhere('_title', "LIKE", '%' . $value . '%')->orWhere('_name', "LIKE", '%' . $value . '%')->orWhere('_description', "LIKE", '%' . $value . '%')->get();
$news = News::where('_langue', '=', $languages->_id)->where("_extract", "LIKE", '%' . $value . '%')->orWhere('_content', "LIKE", '%' . $value . '%')->orWhere('_title', "LIKE", '%' . $value . '%')->get();
if (count($pages) > 0) {
$results["pages"] = $pages;
}
if (count($news) > 0) {
$results["news"] = $news;
}
}
} else {
App::abort(404);
}
$this->layout->content = View::make('pages.search.search', array('data' => $data, "page" => $page, "language" => $languages, 'request' => $request, 'results' => $results));
}
function translate_eloquent_model($translator, $data, $original, $owner = null, $editor = null)
{
if (is_object($original)) {
$original = $original->id;
}
if (is_object($owner)) {
$owner = $owner->id;
}
if (is_object($editor)) {
$editor = $editor->id;
}
$language_repo = config('melon.');
foreach ($data as $slug => $translation_data) {
if (!($language = Language::where('slug', $slug)->first())) {
continue;
}
$translation = (new $translator())->create($translation_data);
$translation->language_id = $language->id;
$translation->original_id = $original;
$translation->owner_id = $owner;
$translation->editor_id = $editor;
$translation->save();
}
}
public function duplicatecvpage($cv_code)
{
$cv_old = Cv::where('cv_code', $cv_code)->first();
if ($cv_old->user_id != Auth::id()) {
return 'False';
}
$new_cv_name = $cv_old->cv_name . ' - Copy';
$cv = new Cv();
do {
$random = str_random(10);
$count = Cv::where('cv_code', $random)->count();
} while ($count != 0);
$cv->cv_code = $random;
if (Auth::check()) {
$cv->user_id = Auth::id();
}
$cv->cv_name = $new_cv_name;
$cv->user_id = $cv_old->user_id;
$cv->full_name = $cv_old->full_name;
$cv->phone_num = $cv_old->phone_num;
$cv->email = $cv_old->email;
$cv->website = $cv_old->website;
$cv->add_line1 = $cv_old->add_line1;
$cv->add_line2 = $cv_old->add_line2;
$cv->dob = $cv_old->dob;
$cv->marital_status = $cv_old->marital_status;
$cv->profile_image = $cv_old->profile_image;
$cv->sex = $cv_old->sex;
$cv->state_origin = $cv_old->state_origin;
$cv->religion = $cv_old->religion;
$cv->religion_text = $cv_old->religion_text;
$cv->show_profile_pic = $cv_old->show_profile_pic;
$cv->local_government = $cv_old->local_government;
$cv->save();
$new_cv_id = $cv->id;
// copying sections
$sections = Section::where('cv_id', $cv_old->id)->get();
foreach ($sections as $section) {
$section_new = new Section();
$section_new->cv_id = $new_cv_id;
$section_new->section_name = $section->section_name;
$section_new->type = $section->type;
$section_new->content = $section->content;
$section_new->default = $section->default;
$section_new->priority = $section->priority;
$section_new->save();
}
// copying educations
$educations = Education::where('cv_id', $cv_old->id)->get();
foreach ($educations as $education) {
$education_new = new Education();
$education_new->cv_id = $new_cv_id;
$education_new->coursename = $education->coursename;
$education_new->institutename = $education->institutename;
$education_new->add_line1 = $education->add_line1;
$education_new->add_line2 = $education->add_line2;
$education_new->startdate = $education->startdate;
$education_new->enddate = $education->enddate;
$education_new->otherinfo = $education->otherinfo;
$education_new->priority = $education->priority;
$education_new->save();
}
// copying languages
$languages = Language::where('cv_id', $cv_old->id)->get();
foreach ($languages as $language) {
$language_new = new Language();
$language_new->cv_id = $new_cv_id;
$language_new->language_id = $language->language_id;
$language_new->language_name = $language->language_name;
$language_new->ability_id = $language->ability_id;
$language_new->level_id = $language->level_id;
$language_new->priority = $language->priority;
$language_new->save();
}
// copying nysc
$nyscs = Nysc::where('cv_id', $cv_old->id)->get();
foreach ($nyscs as $nysc) {
$nysc_new = new Nysc();
$nysc_new->cv_id = $new_cv_id;
$nysc_new->year = $nysc->year;
$nysc_new->batch = $nysc->batch;
$nysc_new->ppa = $nysc->ppa;
$nysc_new->cd = $nysc->cd;
$nysc_new->otherinfo = $nysc->otherinfo;
$nysc_new->priority = $nysc->priority;
$nysc_new->save();
}
// copying work_exp
$work_exps = WorkExperience::where('cv_id', $cv_old->id)->get();
foreach ($work_exps as $work_exp) {
$work_exp_new = new WorkExperience();
$work_exp_new->cv_id = $new_cv_id;
$work_exp_new->title = $work_exp->title;
$work_exp_new->company = $work_exp->company;
$work_exp_new->location = $work_exp->location;
$work_exp_new->startdate = $work_exp->startdate;
$work_exp_new->enddate = $work_exp->enddate;
$work_exp_new->otherinfo = $work_exp->otherinfo;
$work_exp_new->priority = $work_exp->priority;
$work_exp_new->save();
}
return Redirect::back();
}
public function settings()
{
$user = User::find(Auth::user()->id);
$settings = Setting::where('user_id', '=', $user->id)->first();
if ($this->isPostRequest()) {
$validator = $this->getSettingsValidator();
if ($validator->passes()) {
$settings->ui_language = Input::get('ui_language');
$document_languages = Input::get('document_languages');
// TODO: I think this whole thing could be done nicer...
DB::Table('language_user')->where('user_id', '=', $user->id)->delete();
if (!is_null($document_languages)) {
foreach ($document_languages as $document_lang) {
$foundLanguage = Language::where('language_code', '=', $document_lang)->first();
if (!is_null($foundLanguage)) {
$user->languages()->save($foundLanguage);
}
}
}
Session::put('ui_language', $settings->ui_language);
App::setLocale($settings->ui_language);
} else {
return Redirect::back()->withInput()->withErrors($validator);
}
}
$languages = [];
$userDocumentLanguages = $user->languages()->get();
foreach ($userDocumentLanguages as $userDocumentLanguage) {
$languages[$userDocumentLanguage->language_code] = true;
}
return View::make("user/settings")->with('settings', $settings)->with('languages', $languages);
// TODO:
// Think about whether we need to run an OCRing process in background, if document languages selection changed.
}
public function addMission($language)
{
// Définition de la langue :
if (!$this->setupLanguage($language)) {
App::abort(404);
}
// Redirection de l'utilisateur s'il est pas connecté et s'il n'est pas Admin:
if (!Auth::check()) {
return Redirect::to(URL::to($language . '/home'));
} elseif (Auth::User()->_level != "admin") {
return Redirect::to(URL::to($language . '/missions'));
}
// Variables :
// Missions :
$languages = Language::where('_url', '=', $language)->firstOrFail();
$page = Pages::where('_language', $languages->_id)->where("_name", "=", "missions")->get()->first();
$missions = Missions::where("_dateEnd", ">=", date("Y-m-d 00:00:00"))->orderBy('_dateStart')->orderBy('_dateEnd')->get();
// Form :
$inputs = Input::all();
$result = array();
// Details :
$data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
// Envoi du formulaire d'ajout de mission :
if (count(Input::all()) > 0) {
// validation des formulaire :
$validator = Validator::make($inputs, array('professor-name' => 'required|max:60', 'professor-email' => 'required|email|max:60', 'manager-name' => 'required|max:60', 'manager-email' => 'required|email|max:60', 'professor-mission-start' => 'required|date_format:"Y-m-d"|after:"now -1 day"', 'professor-mission-end' => 'required|date_format:"Y-m-d"|after:"' . strtotime("professor-mission-start") . '"', 'your-message' => 'required', 'liaison-file' => 'mimes:jpg,jpeg,png,doc,docx,pdf'), array('professor-name.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_NAME_RQ'), 'professor-name.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_NAME_MAX'), 'professor-email.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_RQ'), 'professor-email.email' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_INV'), 'professor-email.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_MAX'), 'manager-name.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_NAME_RQ'), 'manager-name.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_NAME_MAX'), 'manager-email.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_RQ'), 'manager-email.email' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_INV'), 'manager-email.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_MAX'), 'professor-mission-start.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_RQ'), 'professor-mission-start.date_format' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_INV'), 'professor-mission-start.after' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_INV'), 'professor-mission-end.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_RQ'), 'professor-mission-end.date_format' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_INV'), 'professor-mission-end.after' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_INV'), 'your-message.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MESSAGE'), 'liaison-file.mimes' => Lang::get('libelle.MISSIONS_FORM_ERROR_LIAISON_FILE')));
// retour en cas d'erreur :
if ($validator->fails()) {
$result["errors"] = $validator->messages();
} else {
// traitement du texte en paragraphe
$texte = explode('<br />', nl2br(trim(htmlentities($inputs['your-message']))));
$inputs['your-message'] = "";
foreach ($texte as $key => $value) {
$inputs['your-message'] .= "<p>" . $value . "</p>";
}
// ajout en cas de succès :
$mission = new Missions();
$mission->_author = 1;
$mission->_dateStart = trim(htmlentities($inputs['professor-mission-start']));
$mission->_dateEnd = trim(htmlentities($inputs['professor-mission-end']));
$mission->_profName = trim(htmlentities($inputs['professor-name']));
$mission->_profMail = trim(htmlentities($inputs['professor-email']));
$mission->_ctdName = trim(htmlentities($inputs['manager-name']));
$mission->_ctdMail = trim(htmlentities($inputs['manager-email']));
$mission->_description = $inputs['your-message'];
if (Input::hasFile('liaison-file')) {
$filename = date("YmdHis") . "-" . Input::file('liaison-file')->getClientOriginalName();
Input::file('liaison-file')->move(dirname("app/storage/uploads/missions/") . "/missions/", $filename);
$mission->_file = "storage/uploads/missions/" . $filename;
}
// enrgistrement en base de données.
if ($mission->save()) {
// actualisation des missions :
$missions = Missions::where("_dateEnd", ">=", date("Y-m-d 00:00:00"))->orderBy('_dateStart')->orderBy('_dateEnd')->get();
// vidage du formulaire :
foreach ($inputs as $key => $value) {
$inputs[$key] = "";
}
// affichage du message de reussite :
$result["success"] = Lang::get("libelle.MISSIONS_FORM_SUCCESS");
} else {
$result["errors"] = Lang::get("libelle.MISSIONS_FORM_ERROR");
}
}
}
// Affichage de la vue avec retour du résultat de l'ajout :
$this->layout->content = View::make('pages.missions.missions', array("data" => $data, "page" => $page, "missions" => $missions, "inputs" => $inputs, "result" => $result));
}
public function siteMap($language)
{
if (!$this->setupLanguage($language)) {
App::abort(404);
}
try {
$language = Language::where('_url', '=', $language)->firstOrFail();
$page = Pages::where('_language', $language->_id)->where("_name", "=", "sitemap")->get()->first();
$pages = Pages::where('_language', $language->_id)->where('_dependsOn', "=", NULL)->where("_public", "=", "1")->orderBy('_priority', 'DESC')->get();
$news = News::where('_langue', $language->_id)->orderBy('_date', 'DESC')->get();
} catch (Exception $e) {
App::abort(500);
}
// Details :
$data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
$this->layout->content = View::make('pages.sitemap.sitemap', array("data" => $data, "page" => $page, "pages" => $pages, "news" => $news));
}
public function deleteLanguage($language_id, $code)
{
$cv = Cv::where('cv_code', $code)->first();
$cv_id = $cv->id;
Language::where('id', $language_id)->where('cv_id', $cv_id)->delete();
$data["success"] = 1;
$data["message"] = "Succefully deleted";
return json_encode($data);
}
