Ejemplo n.º 1
0
 public function insertQuery(Request $request)
 {
     $type = $request->input('type');
     $tag = $request->input('tags');
     $id = $request->input('id');
     $mode = $request->input('mode');
     ////////////////////////////////////
     //mode = 0 edit , mode = 1 insert///
     ////////////////////////////////////
     if ($type == 'events') {
         $validator = Validator::make($request->all(), ['title' => 'required', 'address' => 'required', 'body' => 'required', 'tags' => 'required|array']);
         if ($validator->fails()) {
             return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'events', 'tags' => $this->returnTags()));
         } else {
             if ($mode == 1) {
                 $event = new Event();
                 $content = new Content();
             } else {
                 $event = Event::find($id);
                 $content = $event->content;
             }
             $content->title = $request->input('title');
             $event->address = $request->input('address');
             $content->body = $request->input('body');
             $content->type = $type;
             $content->save();
             $start = $request->input('start-day') . "|" . $request->input('start-month') . "|" . $request->input('start-year') . "|" . $request->input('start-hour') . ":" . $request->input('start-minute');
             $end = $request->input('end-day') . "|" . $request->input('end-month') . "|" . $request->input('end-year') . "|" . $request->input('end-hour') . ":" . $request->input('end-minute');
             $event->start = $start;
             $event->end = $end;
             $event->highlight = $request->input('highlight') == NULL ? 0 : 1;
             $files = $request->file('img');
             foreach ($files as $file) {
                 if ($file->isValid()) {
                     $photo = new Photo();
                     $tempName = $file->getClientOriginalName();
                     $extension = explode(".", $tempName);
                     $name = $extension[0] . "-" . time() . "." . $extension[1];
                     $destination = 'upload';
                     $file->move($destination, $name);
                     $photo->path = $destination . "/" . $name;
                     $content->photos()->save($photo);
                 }
             }
             if (!empty($tag)) {
                 foreach ($tag as $insertTag) {
                     $row = Tag::where('title', '=', $insertTag)->first();
                     $content->tags()->save($row);
                 }
             }
             $cat = Category::where('title', '=', $request->input('category'))->first();
             if ($cat != null) {
                 $content->categories()->attach($cat->id);
             }
             $content->event()->save($event);
             return redirect('admin');
         }
     } elseif ($type == 'members') {
         $validator = Validator::make($request->all(), ['firstname' => 'required', 'lastname' => 'required', 'email' => 'required']);
         if ($validator->fails()) {
             return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'members', 'tags' => $this->returnTags()));
         } else {
             if ($mode == 1) {
                 $member = new Member();
             } else {
                 $member = Member::find($id);
             }
             $member->firstname = $request->input('firstname');
             $member->lastname = $request->input('lastname');
             $member->email = $request->input('email');
             //$member->password = $request->input('password');
             $member->researchareas = $request->input('researchareas') == NULL ? NULL : $request->input('researchareas');
             $member->industrialareas = $request->input('intery') == NULL ? NULL : $request->input('industry');
             $member->tel = $request->input('telephone') == NULL ? NULL : $request->input('telephone');
             $member->mobile = $request->input('mobile') == NULL ? NULL : $request->input('mobile');
             $member->position = $request->input('position') == NULL ? NULL : $request->input('position');
             $member->googleplus = $request->input('googleplus') == NULL ? NULL : $request->input('pinterest');
             $member->facebook = $request->input('facebook') == NULL ? NULL : $request->input('facebook');
             $member->twitter = $request->input('twitter') == NULL ? NULL : $request->input('instagram');
             $member->linkedin = $request->input('linkedin') == NULL ? NULL : $request->input('linkedin');
             if ($request->hasFile('img')) {
                 $file = $request->file('img');
                 if ($file->isValid()) {
                     $photo = new Photo();
                     $tempName = $file->getClientOriginalName();
                     $extension = explode(".", $tempName);
                     $name = $extension[0] . "-" . time() . "." . $extension[1];
                     $destination = 'upload';
                     $file->move($destination, $name);
                     //$photo->title = $request->input('photoTitle');
                     $photo->path = $destination . "/" . $name;
                     Photo::where("member_id", $member->id)->delete();
                     $member->photo()->save($photo);
                 }
             }
             if ($request->hasFile('cv')) {
                 $file = $request->file('cv');
                 if ($file->isValid()) {
                     $tempName = $file->getClientOriginalName();
                     $extension = explode(".", $tempName);
                     $name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
                     $destination = 'upload';
                     $file->move($destination, $name);
                     $member->cv = $destination . "/" . $name;
                 }
             }
             $member->save();
             if ($mode == 0) {
                 $record = Member::find($id)->records;
                 foreach ($record as $rec) {
                     $rec->delete();
                 }
             }
             $recordArray = $request->input('rec');
             if (!empty($recordArray)) {
                 foreach ($recordArray as $key) {
                     if (empty($key['delete'])) {
                         $key['delete'] = 'off';
                     }
                     if ($key['delete'] != "on" && $key['institute'] != "") {
                         $record = new Record();
                         $record->institute = $key['institute'];
                         $record->position = $key['position'];
                         $record->start = $key['start'];
                         $record->end = $key['end'];
                         $record->type = $key['type'];
                         $member->records()->save($record);
                     }
                 }
             }
             // $cat = Category::where('title', '=', $request->input('category'))->first();
             return redirect('admin');
         }
     } elseif ($type == 'researches') {
         $validator = Validator::make($request->all(), ['author' => 'required', 'title' => 'required', 'abstract' => 'required']);
         if ($validator->fails()) {
             return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'researches', 'tags' => $this->returnTags()));
         } else {
             if ($mode == 1) {
                 $research = new Research();
                 $content = new Content();
             } else {
                 $research = Research::find($id);
                 $content = $research->content;
             }
             $content->title = $request->input('title');
             $content->body = $request->input('abstract');
             $content->type = $type;
             $content->save();
             $research->author = $request->input('author');
             $research->publisher = $request->input('publisher') == NULL ? NULL : $request->input('publisher');
             $date = $request->input('date-year') . "|" . $request->input('date-month') . "|" . $request->input('date-day') . "|" . $request->input('date-hour') . ":" . $request->input('date-minute');
             $research->date = $date;
             $research->external = $request->input("external") == NULL ? true : false;
             $research->pages = $request->input('pages') == NULL ? NULL : $request->input('pages');
             //                $research->abstract = $request->input('abstract') == NULL ? NULL : $request->input('abstract');
             $research->keywords = $request->input('keywords') == NULL ? NULL : $request->input('keywords');
             $research->link = $request->input('link') == NULL ? NULL : $request->input('link');
             $path = $request->file('path');
             if (!empty($path) && $path->isValid()) {
                 $tempName = $path->getClientOriginalName();
                 $extension = explode(".", $tempName);
                 $name = $extension[0] . time() . "." . $extension[count($extension) - 1];
                 $destination = 'upload';
                 $path->move($destination, $name);
                 $research->path = $destination . "/" . $name;
             }
             if (!empty($tag)) {
                 foreach ($tag as $insertTag) {
                     $row = Tag::where('title', '=', $insertTag)->first();
                     $content->tags()->save($row);
                 }
             }
             $research->content()->associate($content);
             $research->save();
             $cat = Category::where('title', '=', $request->input('category'))->first();
             if ($cat != null) {
                 $content->categories()->attach($cat->id);
             }
             return redirect('admin');
         }
     } elseif ($type == 'galleries') {
         $validator = Validator::make($request->all(), ['title' => 'required', 'body' => 'required']);
         if ($validator->fails()) {
             return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'galleries', 'tags' => $this->returnTags()));
         } else {
             if ($mode == 1) {
                 $content = new Content();
             } else {
                 $content = Content::find($id);
             }
             $content->title = $request->input('title');
             $content->body = $request->input('body');
             $content->type = $type;
             $content->save();
             if ($request->hasFile('img')) {
                 $file = $request->file('img');
                 for ($i = 0; $i < count($file); $i++) {
                     if ($file[$i]->isValid()) {
                         $photo = new Photo();
                         $tempName = $file[$i]->getClientOriginalName();
                         $extension = explode(".", $tempName);
                         $name = $extension[0] . "-" . time() . (string) $i . "." . $extension[count($extension) - 1];
                         $destination = 'upload';
                         $file[$i]->move($destination, $name);
                         $photo->title = $request->input('imgtitle')[$i];
                         $photo->path = $destination . "/" . $name;
                         $photo->highlight = $request->input("highlight")[$i] == "true" ? 1 : 0;
                         $content->photos()->save($photo);
                     }
                 }
             }
             if ($mode != 1) {
                 if (!empty($request->input('oldimg'))) {
                     foreach ($request->input('oldimg') as $img) {
                         if (empty($img['delete'])) {
                             $img['delete'] = "off";
                             $image = Photo::find($img['id']);
                             $image->title = $img['title'];
                             $image->highlight = $img['highlight'] == "true" ? 1 : 0;
                             $image->save();
                         }
                         if ($img['delete'] == "on") {
                             $temp = Photo::find($img['id']);
                             $temp->delete();
                         }
                     }
                 }
             }
             if (!empty($tag)) {
                 foreach ($tag as $insertTag) {
                     $row = Tag::where('title', '=', $insertTag)->first();
                     $content->tags()->save($row);
                 }
             }
             $cat = Category::where('title', '=', $request->input('category'))->first();
             if ($cat != null) {
                 $content->categories()->attach($cat->id);
             }
             return redirect('admin');
         }
     } elseif ($type == 'tags') {
         $input = $request->all();
         $split = explode("#", $input['body']);
         for ($i = 0; $i < count($split); $i++) {
             if (!empty($split[$i]) && $split[$i] != '') {
                 $tag = new Tag();
                 $tag->title = trim($split[$i]);
                 $tag->save();
             }
         }
         return redirect('admin');
     } elseif ($type == 'categories') {
         $cat = new Category();
         $cat->title = $request->input("title");
         $cat->parent = $request->input("cat-id");
         if ($cat->parent == 0) {
             $cat->parent = null;
         }
         $cat->save();
         return redirect('admin');
     } elseif ($type == "variables") {
         $var = Variable::find($id);
         $var->title = $request->input("title");
         $var->subtitle = $request->input("subtitle");
         $var->body = $request->input("body");
         if ($request->hasFile('img')) {
             $file = $request->file('img');
             if ($file->isValid()) {
                 $tempName = $file->getClientOriginalName();
                 $extension = explode(".", $tempName);
                 $name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
                 $destination = 'upload';
                 $file->move($destination, $name);
                 //$photo->title = $request->input('photoTitle');
                 $var->body = $destination . "/" . $name;
             }
         }
         $var->save();
         return redirect('admin');
     } else {
         $validator = Validator::make($request->all(), ['title' => 'required', 'body' => 'required', 'tags' => 'required|array']);
         if ($validator->fails()) {
             return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'news', 'tags' => $this->returnTags()));
         } else {
             if ($mode == 1) {
                 $news = new Content();
             } else {
                 $news = Content::find($id);
             }
             $news->title = $request->input('title');
             $news->body = $request->input('body');
             $news->type = $type;
             $news->save();
             if ($request->hasFile('img')) {
                 $files = $request->file('img');
                 if ($mode == 0) {
                     $oldphoto = Photo::where("content_id", $id)->first();
                     $oldphoto->delete();
                 }
                 foreach ($files as $file) {
                     if ($file->isValid()) {
                         $photo = new Photo();
                         $tempName = $file->getClientOriginalName();
                         $extension = explode(".", $tempName);
                         $name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
                         $destination = 'upload';
                         $file->move($destination, $name);
                         //$photo->title = $request->input('photoTitle');
                         $photo->path = $destination . "/" . $name;
                         $news->photos()->save($photo);
                     }
                 }
             }
             if (!empty($tag)) {
                 foreach ($tag as $insertTag) {
                     $row = Tag::where('title', '=', $insertTag)->first();
                     $news->tags()->save($row);
                 }
             }
             $cat = Category::find($request->input('cat-id'));
             if ($cat != null) {
                 $news->categories()->attach($cat->id);
             }
             return redirect('admin');
         }
     }
 }
 public function add(Request $request)
 {
     //$this->middleware('auth');
     $this->validate($request, ['title' => 'required|max:200', 'keywords' => 'max:200']);
     // die(print_r($request->input('authors_firstname'),true));
     $authors_name = "";
     $i = 0;
     foreach ($request->input('authors_firstname') as $firstname) {
         $authors_name = $authors_name . $firstname . " " . $request->input('authors_lastname')[$i] . ",";
         $i++;
     }
     $request->merge(array('authors' => $authors_name));
     $request->merge(array('authors_firstname' => implode(',', $request->input('authors_firstname'))));
     $request->merge(array('authors_lastname' => implode(',', $request->input('authors_lastname'))));
     if ($request->hasFile('fulltext_file')) {
         $fulltext_file = $request->file('fulltext_file');
         $fulltext_filename = md5(microtime()) . "." . $fulltext_file->getClientOriginalExtension();
         // $request->merge(array('full_text_file' =>$fulltext_filename));
     }
     if ($request->hasFile('abstract_file')) {
         $abstract_file = $request->file('abstract_file');
         $abstract_filename = md5(microtime()) . "." . $abstract_file->getClientOriginalExtension();
         // $request->merge(array('full_text_file' =>$fulltext_filename));
     }
     if ($request->hasFile('article_file')) {
         $article_file = $request->file('article_file');
         $article_filename = md5(microtime()) . "." . $article_file->getClientOriginalExtension();
         // $request->merge(array('article_file' =>$article_filename));
     }
     if ($request->hasFile('cover_file')) {
         $cover_file = $request->file('cover_file');
         $cover_filename = md5(microtime()) . "." . $cover_file->getClientOriginalExtension();
         // $request->merge(array('cover_file' =>$cover_filename));
     }
     $request->merge(array('creator' => Auth::user()->id));
     if (count($request->input('article_level')) > 0) {
         $request->merge(array('article_level' => implode(',', $request->input('article_level'))));
     }
     if ($request->input('research_id', null)) {
         $research = Research::find($request->input('research_id', null));
         $research->update(array_merge($request->all()));
     } else {
         $research = Research::create(array_merge($request->all()));
     }
     $research_id = $research->id;
     $destinationPath = 'uploads/' . $research_id . '/';
     if ($request->hasFile('fulltext_file')) {
         $fulltext_file->move($destinationPath, $fulltext_filename);
         $research->full_text_file = $fulltext_filename;
         $research->save();
     }
     if ($request->hasFile('abstract_file')) {
         $abstract_file->move($destinationPath, $abstract_filename);
         $research->abstract_file = $abstract_filename;
         $research->save();
     }
     if ($request->hasFile('article_file')) {
         $article_file->move($destinationPath, $article_filename);
         $research->article_file = $article_filename;
         $research->save();
     }
     if ($request->hasFile('cover_file')) {
         $cover_file->move($destinationPath, $cover_filename);
         $research->cover_file = $cover_filename;
         $research->save();
     }
     if ($research) {
         $fields = Researchfield::all();
         if ($request->input('research_id')) {
             return view('researchcenter.new_research', ['fields' => $fields, 'alert_type' => 'success', 'msg' => 'Successfully update research data.']);
         } else {
             return view('researchcenter.new_research', ['fields' => $fields, 'alert_type' => 'success', 'msg' => 'Successfully insert new research.']);
         }
     }
 }