public function search(Request $request)
{
$results = array();
$term = $request->get('term');
$goals = Goal::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
$objectives = Objective::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
$actions = Action::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
$tasks = Task::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
$teams = Team::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get();
$departments = Department::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get();
$users = User::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get()->all();
foreach (User::where('email', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get() as $matching_user_email) {
if (in_array($matching_user_email, $users)) {
continue;
}
$users[] = $matching_user_email;
}
$notes = Note::where('content', 'like', '%' . $term . '%')->orderBy('content', 'asc')->get();
$types = [$goals, $objectives, $actions, $tasks, $teams, $departments, $users, $notes];
foreach ($types as $type) {
foreach ($type as $result) {
$results[] = $result;
}
}
return view('search.show')->with('results', $results)->with('term', $term);
}
public function saveNotes()
{
$input = \Input::all();
$user = \App\User::where('email', Session::get('email'))->first();
$notes = \App\Note::where('user_id', $user->id)->first();
$note = \input::get('notes');
$site = null;
for ($i = 1; $i < count($input); $i++) {
if (array_key_exists("website" . $i, $input)) {
if (strlen(\input::get('website' . $i)) > 0) {
$site = $site . \input::get('website' . $i);
$site = $site . "\r\n";
}
}
}
$tbd = \input::get('tbd');
$image = \Input::file('file');
$file = null;
if ($image != null) {
$file = file_get_contents($image);
}
if ($notes == null) {
$notes = Note::create(array('note' => $note, 'website' => $site, 'tbd' => $tbd, 'user_id' => $user->id, 'image1' => $file));
} else {
$notes->note = $note;
$notes->website = $site;
$notes->tbd = $tbd;
$notes->user_id = $user->id;
if ($notes->image1 == null) {
$notes->image1 = $file;
} elseif ($notes->image2 == null) {
$notes->image2 = $file;
} elseif ($notes->image3 == null) {
$notes->image3 = $file;
} elseif ($notes->image4 == null) {
$notes->image4 = $file;
}
$notes->save();
}
if (\input::get('delete1') == 1) {
$notes->image1 = null;
$notes->save();
}
if (\input::get('delete2') == 1) {
$notes->image2 = null;
$notes->save();
}
if (\input::get('delete3') == 1) {
$notes->image3 = null;
$notes->save();
}
if (\input::get('delete4') == 1) {
$notes->image4 = null;
$notes->save();
}
return view('notes')->with('notes', $notes);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$user = Auth::user()->id;
$categories = Category::where('user_id', '=', $user)->get();
foreach ($categories as $category) {
$noteCount = Note::where('category_id', '=', $category->id)->count();
$category->count = $noteCount;
}
return Response::json($categories, 200);
}
/**
* Show the application welcome screen to the user.
*
* @return Response
*/
public function index()
{
$actif = 0;
$preference = Preference::first();
$notes = Note::where('etat', 1)->orderBy('created_at', 'desc')->paginate(5);
$contacts = Contact::where('etat', 1)->orderBy('created_at', 'desc')->paginate(5);
$societes = Societe::where('etat', 1)->orderBy('created_at', 'desc')->paginate(5);
$devis = Devis::where('etat_devis', 1)->orderBy('created_at', 'desc')->paginate(5);
return view('accueil', compact('actif', 'preference', 'notes', 'contacts', 'societes', 'devis'));
}
public function showPastAuditions()
{
$auditionsStatuses = AuditionStatus::where('user_id', Auth::user()->id)->get();
$auditions = collect();
foreach ($auditionsStatuses as $audition) {
$audition_details = Audition::find($audition->audition_id);
if ($audition_details->ended) {
$audition_details->status = $audition;
$audition_details->notes = Note::where('audition_status_id', $audition->id)->get();
$auditions->push($audition_details);
}
}
return view('past', ['auditions' => $auditions]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
// $lesson = Lesson::where('user_id', $request->user()->id)->get()->medias;
if (Auth::user()->group_id != 1) {
$lessons = Lesson::where('category_id', Auth::user()->category_id)->get();
$infos = Info::all();
$notes = Note::where('user_id', Auth::user()->id)->get();
} else {
$lessons = Lesson::all();
$infos = Info::all();
$notes = Note::where('user_id', Auth::user()->id)->get();
}
return view('home.index', compact('lessons', 'infos', 'notes'));
}
/**
* Returns all projects in database
*
* This function uses an Eloquent query to return a list of id, user,
* project, content, created, deadline and completed for all notes stored
* in the database.
*
* @since 1.1.0
*
* @return Response A HTTP Response object formatted as JSON
*/
public function listNotes()
{
try {
$statusCode = 200;
$notes = Note::where('removed', 0)->with(['user', 'project'])->orderBy('time_created', 'asc')->get();
$response = [];
foreach ($notes as $note) {
$this_row = array('id' => $note->id, 'user' => $note->user->uname, 'project' => $note->project->pname, 'content' => $note->content, 'completed' => $note->completed, 'created' => $note->time_created, 'deadline' => $note->time_deadline);
$response[] = $this_row;
}
} catch (Exception $e) {
$statusCode = 400;
} finally {
return Response::json($response, $statusCode);
}
}
public function notes()
{
$notes = Note::where('states', 1)->orderBy('id', 'desc')->with('user')->paginate(24);
return view('notes.notes', compact('notes'));
}
public function noteCount($user)
{
return Note::where('creator', $user->id)->count();
}
private function _isOwner()
{
$userId = $this->_getUserId(Input::get('api_key'));
if (!$userId) {
response()->json(array('status' => 'failed'));
}
$isOwner = Note::where('id', Input::get('id'))->where('user_id', $userId)->count();
if (!$isOwner) {
return response()->json(array('status' => 'failed'));
}
return true;
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$user = JWTAuth::parseToken()->authenticate();
$note = Note::where('user_id', $user->id)->find($id);
if (Gate::denies('show-note', $note)) {
abort(403);
}
if ($note) {
return response()->json($note);
}
}
public function displayNotes()
{
$notes = Note::where('availability', 'public')->get();
return view('pages.home', compact('notes'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$notes = Note::where('user', '=', Auth::id())->orderBy('updated_at', 'desc')->get();
return view('notes', compact('notes'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$user = Auth::user()->id;
$notes = Note::where('user_id', '=', $user)->where('category_id', '=', $id)->get();
return Response::json($notes, 200);
}
public function getNumberNotes()
{
return Note::where('tag_ids', 'like', "%," . $this->id . ",%")->count();
}
/**
* Returns matches in the note table for the given term
*
* @param string $term The search term
*
* @return mixed Response or Collection depending on validation
*/
public function getNoteSearch($term)
{
// TODO: implement a "good" fulltext search.
$notes = Note::where('content', 'LIKE', '%' . $term . '%')->orWhere('title', 'LIKE', '%' . $term . '%')->limit(15)->get(['content', 'title', 'id']);
// Do we have a search result?
if (!$notes) {
return response()->json(['message', 'No search results'], 404);
} else {
foreach ($notes as $note) {
$note->content = strip_tags(Markdown::convertToHtml(str_limit($note->content, 120, '…')));
}
return $notes;
}
}
public function notes($id)
{
$notes = Note::where('creator', $id)->orderBy('id', 'desc')->get();
$user = User::findOrFail($id);
return view('space.notes', compact('notes', 'user'));
}
public function getNotesPerso($year)
{
$match = ['etat' => 1, 'id_user_destination' => Auth::user()->id];
$notes = Note::where($match)->get();
return $notes;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$notes = Note::where('user_id', '=', Auth::User()->id)->get();
return view('notes.index', compact('notes'));
}
public function FiltreCategorie($cat)
{
$actif = 'notes';
//
if ($cat == 'afaire') {
$note_past = Note::where('etat', '1')->where('categorie', 'A faire')->where('echeance', '<', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_futur = Note::where('etat', '1')->where('categorie', 'A faire')->where('echeance', '>', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_auj = Note::where('etat', '1')->where('categorie', 'A faire')->where('echeance', '=', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
} elseif ($cat == 'tel') {
$note_past = Note::where('etat', '1')->where('categorie', 'Appel téléphonique')->where('echeance', '<', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_futur = Note::where('etat', '1')->where('categorie', 'Appel téléphonique')->where('echeance', '>', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_auj = Note::where('etat', '1')->where('categorie', 'Appel téléphonique')->where('echeance', '=', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
} elseif ($cat == 'email') {
$note_past = Note::where('etat', '1')->where('categorie', 'E-mail')->where('echeance', '<', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_futur = Note::where('etat', '1')->where('categorie', 'E-mail')->where('echeance', '>', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_auj = Note::where('etat', '1')->where('categorie', 'E-mail')->where('echeance', '=', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
} elseif ($cat == 'reunion') {
$note_past = Note::where('etat', '1')->where('categorie', 'Réunion')->where('echeance', '<', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_futur = Note::where('etat', '1')->where('categorie', 'Réunion')->where('echeance', '>', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_auj = Note::where('etat', '1')->where('categorie', 'Réunion')->where('echeance', '=', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
} elseif ($cat == 'autre') {
$note_past = Note::where('etat', '1')->where('categorie', 'Autre')->where('echeance', '<', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_futur = Note::where('etat', '1')->where('categorie', 'Autre')->where('echeance', '>', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
$note_auj = Note::where('etat', '1')->where('categorie', 'Autre')->where('echeance', '=', Carbon::today())->orderBy('updated_at', 'desc')->paginate(15);
}
return view('notes.index', compact('note_auj', 'note_futur', 'note_past', 'note_auj', 'actif'));
}
public function checkNotes(Request $request)
{
$query = Note::where('states', '=', 0);
return view('admin.notes.cnotes', $this->getNotesQuery($request, $query));
}
/**
* Runs a comparision between notes on text basis
*
* @param Note $note The note, for which related notes should be returned
*
* @return array An array containing the IDs and relevancy of related notes
*/
function textAnalysis(Note $note)
{
// For a text analysis we need to reduce this note and
// reduce all possible related notes to a small index.
// TODO: Implement an indexing function.
// explode note contents and title by words
$title = explode(" ", $note->title);
$tmp = strip_tags(preg_replace('/[^a-zA-Z0-9[:space:]\\p{L}]/u', '', $note->content));
$tmp = str_replace(["\n", "\r"], " ", $tmp);
$content = explode(" ", $tmp);
// Remove duplicates and reset array keys to Zero-based
$content = array_values(array_unique($content));
$suggestedNotes = [];
$rel = [];
// Now suggest tags for all words with > 3 letters
for ($i = 0; $i < count($content); $i++) {
if (strlen($content[$i]) > 3) {
// I guess above 300+ notes this will be one of the slowest
// functions in this whole app. Let's see if it breaks the
// 60sec wall of the server ...
$notes = Note::where('content', 'LIKE', '%' . $content[$i] . '%')->get();
if (count($notes) > 0) {
foreach ($notes as $index => $n) {
// Compare the arrays to determine the relevancy
$suggestedNotes[$index] = $n->id;
$tmp = strip_tags(preg_replace('/[^a-zA-Z0-9[:space:]\\p{L}]/u', '', $n->content));
$tmp = str_replace(["\n", "\r"], " ", $tmp);
$suggestContent = explode(" ", $tmp);
// Remove duplicates and reset array keys to Zero-based
$suggestContent = array_values(array_unique($suggestContent));
$relevancy = count(array_intersect($content, $suggestContent));
$rel[$index] = $relevancy;
}
}
}
}
// Remove potential duplicate notes
$suggestedNotes = array_values(array_unique($suggestedNotes));
// now write the index of relevancy into the remaining $suggestedNotes
unset($tmp);
$tmp = [];
foreach ($suggestedNotes as $index => $id) {
$tmp[$index]['id'] = $id;
$tmp[$index]['relevancy'] = $rel[$index];
}
$suggestedNotes = $tmp;
return $suggestedNotes;
}
public function liveUser($id, $auditionStatus)
{
if (Auth::user()->user_role == 2) {
return redirect()->route('live-view', [$id]);
}
$audition = Audition::find($id);
$auditionDetails = AuditionDetails::where('audition_id', $id)->first();
$auditioner = AuditionStatus::find($auditionStatus);
$auditioner->seen = true;
$auditioner->save();
return view('audition.live', ['audition' => $audition, 'details' => $auditionDetails, 'auditioner' => $auditioner->user, 'notes' => Note::where('audition_status_id', $auditioner->id)->where('user_id', Auth::user()->id)->orderBy('id', 'desc')->get(), 'auditionStatusId' => $auditioner->id]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($device)
{
//
$note = Note::where('device_id', $device->id)->where('past', 0)->first();
return view('devices.edit', compact('device', 'note'));
}
