/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$user = user::find($id);
$user->fill($request->all());
$user->save();
Session::flash('message', 'user actualizado Correctamente');
return Redirect::to('backend//users');
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function view()
{
$rsExpenseList = expense::orderBy("expense.id", "DESC")->get();
$arrExpenseList = array();
foreach ($rsExpenseList as $expense) {
$users = DB::table('users')->join('mapuserexpense', 'mapuserexpense.user_id', '=', 'users.id')->select('users.name')->where('mapuserexpense.expense_id', '=', $expense->id)->get();
$expense['shared_by'] = $users;
$expense['payed_by'] = user::find($expense->payed_by)->name;
$arrExpenseList[] = $expense;
}
return view('user/manageExpense', ['arrExpenseList' => $arrExpenseList, "strCurrentPage" => "manage_expense"]);
}
public function edit_profile(Request $request)
{
$validator = Validator::make($request->all(), ['full_name' => 'required|max:50', 'user_name' => 'required|max:30', 'email' => 'required|email|max:50', 'address' => 'required|max:50']);
if ($validator->fails()) {
$data['errors'] = $validator->errors()->first();
return response()->json($data, 201);
}
$user = JWTAuth::parseToken()->authenticate();
$user = user::find($user->id);
$user->update($request->all());
$data['result'] = $user;
return response()->json($data, 200);
}
public function seeProfile($idUser = 37)
{
// echo '<pre>';print_r(Auth::user());exit;
$idUser = 37;
if (user::find($idUser) != false) {
DB::statement("SET lc_time_names = 'es_ES'");
$dataUser = array('infoGeneral' => user::find($idUser), 'infoSocialin' => user::find($idUser)->socialin, 'infoExperience' => experienceModel::obtenerExperienciaPorUsuario($idUser), 'infoEducation' => educationModel::obtenerEstudiosPorUsuario($idUser), 'infoCourse' => courseModel::obtenerCursosPorUsuario($idUser));
// $doctor['infoLinkedin']['srcImage']=doctorModel::isImageHere($doctor['infoLinkedin']);
// $doctor['infoLinkedin']['currentExperiences']=$exp->getCurrentExperience($idUser);
// $doctor['infoLinkedin']['oldExperiences']=$exp->getOldExperience($idUser);
// echo '<pre>';print_r($dataUser);exit;
return view('perfil.show', ['dataUser' => $dataUser]);
} else {
//si el usuario no existe
return redirect()->route('home');
}
return view("perfil.show");
}
public function processphoto(Request $request)
{
$validator = Validator::make($request->all(), ['profile_photo' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$file = $request->file('profile_photo');
$path = public_path('uploads/');
$filename = str_random(24) . "." . $file->getClientOriginalExtension();
$fileExtension = $file->getClientOriginalExtension();
$fileSize = $file->getSize();
if ($fileSize > 512000) {
$request->session()->flash('message', 'Sorry file size large');
return redirect('profile_photo');
}
if ($fileExtension != "jpg" && $fileExtension != "png") {
$request->session()->flash('message', 'Sorry try jpg or png');
return redirect('profile_photo');
} else {
if (!file_exists($filename)) {
$file->move($path, $filename);
try {
$user = user::find(Auth::user()->id);
$user->update(['profile_photo' => $filename]);
$request->session()->flash('message', 'Upload success');
return redirect('dashboard');
} catch (QueryException $e) {
$request->session()->flash('message', $e->getMessage());
return redirect('dashboard');
}
} else {
$filename = str_random(24) . "." . $file->getClientOriginalExtension();
$file->move($path, $filename);
try {
$user = user::find(Auth::user()->id);
$user->update(['profile_photo' => $filename]);
$request->session()->flash('message', 'Upload success');
return redirect('dashboard');
} catch (QueryException $e) {
$request->session()->flash('message', $e->getMessage());
return redirect('dashboard');
}
}
}
}
public function createInfo()
{
$logged_user_id = Auth::user()->id;
$user = user::find($logged_user_id);
return View::make('userInfoForm')->with('user', $user);
}
public function modAdd()
{
$film = Input::get('film');
$user = Input::get('user');
$review = Input::get('review');
$vote = Input::get('vote');
$check = DB::table('film_review')->where('fr_usr_id', $user)->where('fr_fl_id', $film)->first();
if ($check) {
} else {
if (!$review == "") {
// inserts the review
$rev = new Review();
// revie instance
$rev->fr_fl_id = $film;
$rev->fr_usr_id = $user;
$rev->fr_review = $review;
$rev->fr_vote = $vote;
$rev->fr_date = \time();
$rev->save();
// saves review
// insert a new user actions
$act = new Activity();
// notification instance
$act->type_id = '2';
// activity type 2 for review
$act->subject_id = $user;
// id of the user
$act->object_type = 'film';
// type of object
$act->object_id = $film;
// id of the object
$act->action_date = \time();
// time of the activity
$act->save();
// saves activity
}
}
// gets the review details from the given id
$latest = DB::table('film_review')->where('fr_usr_id', $user)->orderBy('fr_id', 'desc')->first();
$user = user::find($user);
return view('reviews.add', compact('latest', 'user'));
}
public function search(Request $request)
{
$date_from = "";
$date_to = "";
$validator = Validator::make($request->all(), ['date_from' => 'required', 'date_to' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$arrUser = User::lists('name', 'id');
$date_from = date("Y-m-d", strtotime($request->date_from)) . " 00:00:00";
$date_to = date("Y-m-d", strtotime($request->date_to)) . " 23:59:59";
//$arrExpenseList = expense::whereBetween('created_at',array($date_from,$date_to))->orderBy("expense.id", "ASC")->get();
$arrExpenseList = expense::whereRaw('created_at between "' . $date_from . '" and "' . $date_to . '"')->get();
$ExpenseList = array();
$sumData = array();
$sumTotalPay = array();
foreach ($arrUser as $k => $user) {
$sumData[$k] = 0;
foreach ($arrUser as $i => $user) {
$sumTotalPay[$k][$i] = 0;
}
}
$total_expense = 0;
if (count($arrExpenseList) > 0) {
foreach ($arrExpenseList as $expense) {
$share_count = $expense->shared_by_users->count();
$countData = array();
foreach ($arrUser as $k => $user) {
$count = DB::table('mapuserexpense')->where('expense_id', $expense->id)->where('user_id', $k)->count();
if ($count > 0) {
$cost = $expense->price / $share_count;
$countData[] = $cost;
$sumData[$k] = $sumData[$k] + $cost;
$total_expense += $cost;
$sumTotalPay[$expense->payed_by][$k] += $cost;
} else {
$countData[] = NULL;
}
}
$ExpenseList[] = array('expense_name' => $expense->expense_name, 'price' => $expense->price, 'payed_by' => user::find($expense->payed_by)->name, 'created_at' => $expense->created_at, 'countData' => $countData, 'sumData' => $sumData);
}
} else {
$ExpenseList = array();
}
return view('user/reports', ["strCurrentPage" => "reports", "total_expense" => $total_expense, "arrUser" => $arrUser, "sumTotalPay" => $sumTotalPay, 'date_from' => $date_from, 'date_to' => $date_to, "arrExpenseList" => $ExpenseList]);
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request)
{
//echo $request->id;
// echo $request->n_name;
$user1 = user::find($request->id);
$user1->s_name = $request->n_name;
//echo $user1->s_name;
$user1->save();
return redirect()->action('Hello_controller@index');
//echo $user1;
}
