/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function dashboard()
{
$user = User::find(Auth::user()->id);
$communitys = Community::all()->lists('name', 'id');
$feedbacksGiven = Feedback::where('giver_id', Auth::user()->id)->get();
$feedbacks = Feedback::where('receiver_id', Auth::user()->id)->get();
$activePosts = Post::where('user_id', Auth::user()->id)->where('sold', null)->get();
$offers = Offer::where('post_creator', Auth::user()->id)->whereHas('post', function ($q) {
$q->where('sold', NULL);
})->orderBy('created_at', 'desc')->get();
return view('pages.dashboard', ['user' => $user, 'communities' => $communitys, 'offers' => $offers, 'feedbacks' => $feedbacks, 'activePosts' => $activePosts, 'feedbacksGiven' => $feedbacksGiven]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(FeedbackFormRequest $request)
{
$traineeId = Auth::user()->id;
$feedback = new Feedback(array('trainer_id' => $request->get('trainer_id'), 'trainee_id' => $traineeId, 'voice_range' => $request->get('A1'), 'voice_clearity' => $request->get('A2'), 'communication_skills' => $request->get('A3'), 'rapport_building' => $request->get('A4'), 'interaction' => $request->get('A5'), 'topic_usefulness' => $request->get('B1'), 'material_organization' => $request->get('B2'), 'speakers_knowledge' => $request->get('B3'), 'comments' => $request->get('comments')));
//dd($feedback);
if (Feedback::where('trainee_id', '=', $traineeId)->where('trainer_id', '=', $request->get('trainer_id'))->exists()) {
return redirect('/trainee')->with('status', 'You have already given feedback');
} else {
$feedback->save();
return redirect('/trainee')->with('status', 'Your feedback has been submitted!');
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$user = \Auth::user();
$project = \App\Project::find($id);
$users = \App\Project::find($id)->projectUser;
$projectUsers = [];
foreach ($users as $u) {
$projectUsers[] = \App\User::find($u->user_id);
}
$feedbacks = \App\Feedback::where('user_id', '=', $user->id)->orWhere('project_id', '=', $id)->get();
return view('user.feedback.projectfeedback', compact('project', 'user', 'feedbacks'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$feedbacks = Feedback::where('trainer_id', '=', $id)->with('trainer')->join('trainers', 'trainers.id', '=', 'feedbacks.trainer_id')->select('*', DB::raw('AVG(voice_range) as voice_range,
AVG(voice_clearity) as voice_clearity,
AVG(communication_skills) as communication_skills,
AVG(rapport_building) as rapport_building,
AVG(topic_usefulness) as topic_usefulness,
AVG(interaction) as interaction,
AVG(material_organization) as material_organization,
AVG(speakers_knowledge) as speakers_knowledge'))->get();
foreach ($feedbacks as $f) {
$sum = $f->voice_range + $f->voice_clearity + $f->communication_skills + $f->rapport_building + $f->topic_usefulness + $f->interaction + $f->material_organization + $f->speakers_knowledge;
}
$avg = $sum / 8;
return view('feedbacks.show', compact('feedbacks', 'avg'));
}
public function newfeedback(Request $request)
{
$this->validate($request, ['feedback' => 'required|min:10']);
$user = Sentinel::check();
$user = User::findorfail($user->id);
if ($request->ajax()) {
$feedback = ['user_id' => $user->id, 'feedback' => $request->feedback];
$hasfeedback = Feedback::where('user_id', $user->id)->first();
if ($hasfeedback) {
$hasfeedback->feedback = $request->feedback;
$hasfeedback->save();
} else {
Feedback::create($feedback);
}
return response()->json(['success' => 'posted feedback']);
}
return redirect()->route('home');
}
public function detail($id)
{
$number_of_items = Cart::content();
$product = Product::find($id);
// Tìm sản phẩm có ID như trên trong database để lấy dữ liệu
$type = Type::all();
// Lấy tất cả các loại sp
$users = User::all();
// Lấy tất cả các người dùng
$feedbacks = Feedback::where('product_id', '=', $id)->get();
// Hiển thị những Feedback có id Sản phẩm như trên
$rate_stars = DB::table('rates')->where('product_id', '=', $id)->avg('rate');
// Tính trung bình đánh giá của sp đó
$related_product = Product::where('type_id', '=', $product->type_id)->orderByRaw('RAND()')->take(4)->get();
// Hiển thị những sản phẩm liên quan, cùng loại
if ($product->sale_price != 0) {
$price = $product->sale_price;
} else {
$price = $product->price;
}
return view('webcontent/detail', compact('product', 'price', 'type', 'related_product', 'number_of_items', 'feedbacks', 'users', 'rate_stars'));
}
public function commentshistory($id)
{
$page = 'partials.profile-commentshistory';
$comments = Feedback::where('user_id', '=', $id)->get();
return view('webcontent/profile', compact('page', 'comments'));
}
public function destroy($id)
{
Feedback::where('id', '=', $id)->delete();
return redirect()->back();
}
public function getFeedbacks(Request $request)
{
if (!session()->has('can-save')) {
return json_encode(['success' => false, 'errors' => ['Ошибка прав доступа на получения списка отзывов.']]);
}
session()->flash('can-save', '1');
$feedbacks = \App\Feedback::where('ls', $request->input('ls'))->latest()->with('answer')->paginate(3);
$data = [];
foreach ($feedbacks as $feedback) {
$text = $feedback->text;
$item = ['date' => $feedback->created_at->format('d.m.Y'), 'text' => $text];
if ($feedback->answer) {
$item['answer'] = $feedback->answer->text;
}
array_push($data, $item);
}
return json_encode(['success' => true, 'data' => $data, 'lastPage' => $feedbacks->lastPage(), 'currentPage' => $feedbacks->currentPage()]);
}
