/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$company = Company::findOrFail($id);
$message = '';
$users = User::whereRaw('company_id = ? order by first_name', array($company->id))->paginate(15)->appends(Input::except('page'));
return view('company.show', ['company' => $company, 'users' => $users, 'message' => $message]);
}
function profile()
{
$id = Input::get('id');
if (Auth::user()->id == $id) {
return redirect("/profile");
}
$user = User::find($id);
if ($user) {
$data = ['member' => $user];
$request = AddRequest::where('requested_by_user_id', Auth::user()->id)->where('recipient_user_id', $user->id)->first();
if ($request) {
$data['request'] = $request;
}
// check if a member available for the new team
$xu = User::whereRaw('parent_user_id IS NULL')->where('id', $user->id)->get();
if ($xu && count($xu) > 0) {
$data['available'] = true;
}
// check if member is member of current user
$cU = User::where('parent_user_id', Auth::user()->id)->get();
if ($cU && count($cU) > 0) {
$data['myMember'] = true;
}
return view('member.others-profile', $data);
} else {
return view('member.others-profile')->with('notFound', true);
}
}
public function findUserByEmailOrFail($userEmail)
{
if (User::where('email', '=', $userEmail)->count() == 1) {
return User::whereRaw('email = ?', [$userEmail])->get();
} else {
return false;
}
}
public function findByUserNameOrCreate($provider, $userData)
{
$user = User::whereRaw('provider_id = ? and provider = ?', [$userData->id, $provider])->first();
if (!$user) {
$user = User::create(['provider' => $provider, 'provider_id' => $userData->id, 'name' => $userData->name, 'username' => $userData->nickname, 'email' => $userData->email, 'avatar' => $userData->avatar, 'active' => 1]);
\Flash::message('New user created!');
}
$this->checkIfUserNeedsUpdating($userData, $user);
return $user;
}
public static function tipoUserLogado()
{
if (!\Auth::check()) {
return "*";
}
$user = User::whereRaw('name=?', [\Auth::user()->name]);
if ($user->count() == 1) {
return $user->first()->tipo;
}
return "";
}
public function search(Request $request)
{
$rules = array('page' => 'required', 'pageSize' => 'required');
$validator = Validator::make($request->all(), $rules);
if ($validator->fails()) {
return response()->json(array('result' => false, 'message' => $validator->errors()->first()));
}
$role = $request->input('type');
$active = $request->input('status');
$email = $request->input('email');
$page = $request->input('page');
$pageSize = $request->input('pageSize');
$skip = ($page - 1) * $pageSize;
//$sql = \DB::table('users');
$sql = User::whereRaw('(1+1=2)')->where('isAdmin', 0);
if ($role == 99 && $active == 99 && !isset($email)) {
$user = $sql->limit($skip, $pageSize)->get();
return response()->json(['result' => true, 'data' => $user, 'total' => $sql->count()]);
} else {
if ($role == 99 && $active == 99 && isset($email)) {
$count = $sql->email($email)->count();
$user = $sql->email($email)->limit($skip, $pageSize)->get();
return response()->json(['result' => true, 'data' => $user, 'total' => $count]);
}
}
if (isset($role) && $role != 99) {
$sql->role($role);
}
if (isset($active) && $active != 99) {
$sql->active($active);
}
if (isset($email)) {
$sql->email($email);
}
$sql_str = $sql->toSql();
$count = $sql->count();
$user = $sql->limit($skip, $pageSize)->get();
//var_dump($role , $active);
return response()->json(['result' => true, 'data' => $user, 'total' => $count, 'sql' => $sql_str]);
}
private function getActiveCompanyUsers($keyword)
{
$role_id = Auth::user()->role_id;
$company_id = Auth::user()->company_id;
$manager_id = Auth::user()->id;
$filter = '';
if ($role_id == 3) {
$filter = ' and role_id in( 2 ) ';
if (empty($keyword)) {
return User::whereRaw('company_id = ? and status = ? and manager_id = ? ' . $filter . ' order by first_name', array($company_id, 'ACTIVE', $manager_id))->paginate(25)->appends(Input::except('page'));
} else {
return User::whereRaw(' ( first_name like ? or last_name like ? or email like ? ) and status = ? and company_id = ? and manager_id = ? ' . $filter . ' order by first_name', array('%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%', 'ACTIVE', $company_id, $manager_id))->paginate(25)->appends(Input::except('page'));
}
} elseif ($role_id == 4) {
// En teoria deberia tambien incluir en la lista al mismo owner... se deberia agregar el id del owner
$filter = ' and role_id in( 2, 3 ) ';
if (empty($keyword)) {
return User::whereRaw('company_id = ? and status = ? ' . $filter . ' order by first_name', array(Auth::user()->company_id, 'ACTIVE'))->paginate(25)->appends(Input::except('page'));
} else {
return User::whereRaw(' ( first_name like ? or last_name like ? or email like ? ) and status = ? and company_id = ? ' . $filter . ' order by first_name', array('%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%', 'ACTIVE', $company_id))->paginate(25)->appends(Input::except('page'));
}
}
}
public function login(Request $request)
{
$a = $request->all();
$error = array();
if (empty($a['username'])) {
$error['username'] = "******";
}
if (empty($a['password'])) {
$error['password'] = "******";
}
if (empty($error)) {
$pa = md5($a['password']);
$a = User::whereRaw(DB::raw("username='******'username']}' AND password='******'"))->first();
if (!empty($a)) {
Auth::login($a);
return Response::json(Auth::user());
} else {
$a = User::whereRaw(DB::raw("email='{$a['username']}' AND password='******'"))->first();
if (!empty($a)) {
Auth::login($a);
return Response::json(Auth::user());
}
}
return Response::json(['error' => '1', 'username' => "Tên đăng nháºp hoặc máºt khẩu không chÃnh xác"]);
}
$error['error'] = '1';
return Response::json($error);
}
private function getActiveCompanyUsers($keyword)
{
$role_id = Auth::user()->role_id;
$company_id = Auth::user()->company_id;
$manager_id = Auth::user()->id;
$filter = '';
if ($role_id == 3) {
$filter = ' and role_id in( 2 ) ';
if (empty($keyword)) {
return User::whereRaw('company_id = ? and manager_id = ? ' . $filter . ' order by first_name', array($company_id, $manager_id))->paginate(15)->appends(Input::except('page'));
} else {
return User::whereRaw(' ( first_name like ? or last_name like ? or email like ? ) and company_id = ? and manager_id = ? ' . $filter . ' order by first_name', array('%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%', $company_id, $manager_id))->paginate(15)->appends(Input::except('page'));
}
} elseif ($role_id == 4) {
$filter = ' and role_id in( 2, 3 ) ';
if (empty($keyword)) {
return User::whereRaw('company_id = ? ' . $filter . ' order by first_name', array(Auth::user()->company_id))->paginate(15)->appends(Input::except('page'));
} else {
return User::whereRaw(' ( first_name like ? or last_name like ? or email like ? ) and company_id = ? ' . $filter . ' order by first_name', array('%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%', $company_id))->paginate(15)->appends(Input::except('page'));
}
}
}
public function findByStatus()
{
$status = Input::get('status');
$companies = Input::get('companies');
$keyword = '';
if ($status == null || $status == 'ALL') {
$users = $this->getActiveUsers();
$status = '';
$companies = '';
return view('user.list', compact('users', 'status', 'keyword', 'companies'));
} else {
if ($companies == null || $companies == 'default') {
$companies = '';
//$users = User::whereRaw(' ( company_id = ? ) order by first_name', array($companies))->paginate(15)->appends(Input::except('page')); debe ser asi
$users = User::whereRaw(' ( status = ? ) order by first_name', array($status))->paginate(100)->appends(Input::except('page'));
return view('user.list', compact('users', 'status', 'keyword', 'companies'));
} else {
//$users = User::whereRaw(' ( company_id = ? ) order by first_name', array($companies))->paginate(15)->appends(Input::except('page')); debe ser asi
$users = User::whereRaw(' ( status = ? and company_id = ? ) order by first_name', array($status, $companies))->paginate(100)->appends(Input::except('page'));
return view('user.list', compact('users', 'status', 'keyword', 'companies'));
}
}
}
public function scopeGetUsersCount($query, $id)
{
$count = User::whereRaw('company_id = ?', array($id))->count();
return $count . " users";
}
/**
* Return data for all members within the system
*
* @return array
*/
public function listMembers(Router $router)
{
$uri = $router->getCurrentRoute()->uri();
$users = User::whereRaw('id != 1')->orderBy('created_at')->get();
foreach ($users as $key => $user) {
foreach ($user->standings as $standing) {
if (empty($standing->end_date)) {
$user->activeStanding = $standing->type;
}
}
}
return view('members.list', compact('uri', 'users'));
}
public function friends()
{
$data = array('slide' => array('up', 'down', 'left', 'right'), 'size' => array('tile', 'tile-wide', 'tile-large', 'tile-big', 'tile-square', 'tile-big-x'), 'color' => array('blue', 'green', 'red', 'black'), 'friends' => User::whereRaw('namadepan<>"" and namabelakang<>"" and tanggallahir<>"0000-00-00" and blokir=0 and foto<>1')->orderByRaw('id')->paginate(25));
return view('mine.friends')->with($data);
}
public function sharePost(Request $request)
{
if ($request->ajax()) {
$validator = Validator::make(['post_id' => $request['share_post_id'], 'links' => $request['share_links'], 'groups' => $request['share_groups']], ['post_id' => 'required', 'links' => 'required_without:groups', 'groups' => 'required_without:links|unique:post_group_taggings,post_id,group_id'], ['links.required_without' => 'Either link or group is required for sharing.', 'groups.required_without' => 'Either group or link is required for sharing.', 'groups.unique' => 'Either group or link is required for sharing.']);
if ($validator->fails()) {
return response()->json(array('success' => false, 'errors' => $validator->getMessageBag()->toArray()), 500);
} else {
$isShared = 0;
$sharePostId = $request['share_post_id'];
$post = Postjob::findOrFail($sharePostId);
$data = [];
if ($post != null) {
// share to link
if ($request['share_links'] != null) {
$taggedUsers = $request['share_links'];
$post->taggeduser()->attach($taggedUsers, array('mode' => 'shared', 'tag_share_by' => Auth::user()->induser_id));
$induserIds = implode(', ', $taggedUsers);
$userIds = User::whereRaw('induser_id in (' . $induserIds . ')')->get(['id']);
foreach ($userIds as $r) {
$to_user = $r->id;
if ($to_user != null) {
$notification = new Notification();
$notification->from_user = Auth::user()->id;
$notification->to_user = $to_user;
$notification->remark = 'has shared post: ' . $post->unique_id;
$notification->operation = 'post sharing';
$notification->save();
}
}
$isShared++;
}
// share to group
if ($request['share_groups'] != null) {
$taggedGroups = $request['share_groups'];
$post->taggedGroup()->attach($taggedGroups, array('mode' => 'shared', 'tag_share_by' => Auth::user()->induser_id));
$isShared++;
}
// myactivity update
if ($isShared > 0) {
$postActivity = Postactivity::where('post_id', '=', $sharePostId)->where('user_id', '=', Auth::user()->id)->first();
if ($postActivity == null) {
$postActivity = new Postactivity();
$postActivity->post_id = $sharePostId;
$postActivity->user_id = Auth::user()->id;
$postActivity->share = 1;
$postActivity->share_dtTime = \Carbon\Carbon::now(new \DateTimeZone('Asia/Kolkata'));
$postActivity->save();
} elseif ($postActivity != null && $postActivity->share == 0) {
$postActivity->share = 1;
$postActivity->share_dtTime = \Carbon\Carbon::now(new \DateTimeZone('Asia/Kolkata'));
$postActivity->save();
}
$sharecount = Postactivity::where('post_id', '=', $sharePostId)->sum('share');
$data['sharecount'] = $sharecount;
$data['page'] = 'home';
}
}
return response()->json(['success' => true, 'data' => $data]);
}
} else {
return redirect("/home");
}
}
public function run()
{
DB::table('role_user')->delete();
/*
Role::create(['name' => 'receipt' , 'display_name' => 'Receiver' , 'description' => 'Receiver worker at a rework table' ]);
Role::create(['name' => 'putAwayReserve', 'display_name' => 'Put Away to reserve' , 'description' => 'Put Away to reserve locations' ]);
Role::create(['name' => 'putAwayPick' , 'display_name' => 'Put Away to pick face' , 'description' => 'Put Away to pick face locations' ]);
Role::create(['name' => 'replen' , 'display_name' => 'Replen' , 'description' => 'Move Inventory from reserve to pick face locations']);
Role::create(['name' => 'poReconcile' , 'display_name' => 'PO Receipt Reconciliator', 'description' => 'Reconcile Receipt POs variances' ]);
Role::create(['name' => 'teamLead' , 'display_name' => 'Shift Team Leader' , 'description' => 'Team Lead for the shift' ]);
Role::create(['name' => 'super' , 'display_name' => 'Shift Supervisor' , 'description' => 'Supervising the shift' ]);
Role::create(['name' => 'manager' , 'display_name' => 'Shift Manager' , 'description' => 'Managing shift activities' ]);
Role::create(['name' => 'admin' , 'display_name' => 'Administrator' , 'description' => 'Administrates users of this application']);
Role::create(['name' => 'support' , 'display_name' => 'IT Support' , 'description' => 'IT Support for this application' ]);
User::create(['name' => 'worker' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'teamLead' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'super' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'manager', 'email' => '*****@*****.**', 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'admin' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'rbowers', 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
User::create(['name' => 'pneal' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]);
*/
$roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen')")->get();
$users = User::whereRaw("name in ('worker')")->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
$roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead')")->get();
$users = User::whereRaw("name in ('teamLead')")->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
$roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead', 'super')")->get();
$users = User::whereRaw("name in ('super')")->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
$roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead', 'super', 'manager')")->get();
$users = User::whereRaw("name in ('manager', 'rbowers')")->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
$roles = Role::whereName('admin')->get();
$users = User::whereRaw("name in ('admin', 'rbowers')")->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
$roles = Role::get();
$users = User::whereName('pneal')->get();
foreach ($roles as $role) {
foreach ($users as $user) {
DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]);
}
}
}
/**
* @author: lmkhang - skype
* @date: 2016-01-10
* Get account by User_id
*/
public function getAccount($user_id = '')
{
return \App\User::whereRaw('status = ? AND del_flg = ? AND user_id = ? ', [1, 1, $user_id])->first();
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$company = Company::findOrFail($id);
$message = '';
$user = DB::table('users')->where('company_id', $id)->where('role_id', 4)->first();
$company->email = $user->email;
$company->first_name = $user->first_name;
$company->last_name = $user->last_name;
$company->contact_number = $user->contact_number;
$company->address1 = $user->address1;
$company->address2 = $user->address2;
$company->user_id = $user->id;
$users = User::whereRaw('company_id = ? order by first_name', array($company->id))->paginate(15)->appends(Input::except('page'));
return view('company.show', ['company' => $company, 'users' => $users, 'message' => $message]);
}
public function autocompleteUsers()
{
$users = User::whereRaw('mem_status IN ("Active", "Pending") AND venmo_handle IS NOT NULL')->select('id', 'first_name', 'last_name', 'skater_name', 'venmo_handle')->get();
return $users;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$requested = Input::get('request');
$status = Input::get('status');
$companies = Input::get('companies');
$filter = Input::get('user_filter');
if ($requested == null || $requested == '' || $requested == 'showAll') {
$user = Auth::user();
$activeTab = 'users';
$keyword = '';
$users = User::paginate(15);
$saleTypes = SaleType::all();
$status = 'ALL';
$companies = 'default';
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
} else {
if ($filter == 1) {
$user = Auth::user();
$activeTab = 'users';
$keyword = '';
$users = User::paginate(15);
$saleTypes = SaleType::all();
$user_filter = Input::get('user_filter');
$status_date = Input::get('status_date');
if ($user_filter == '1') {
if ($companies == null || $companies == 'default') {
if ($status == null || $status == 'ALL') {
$status = 'ALL';
$companies = 'default';
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
} else {
$companies = 'default';
$users = User::whereRaw(' ( status = ?) order by first_name', array($status))->paginate(100)->appends(Input::except('page'));
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
} else {
if ($status == null || $status == 'ALL') {
$status = 'ALL';
$users = User::whereRaw(' ( company_id = ?) order by first_name', array($companies))->paginate(100)->appends(Input::except('page'));
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
} else {
$users = User::whereRaw(' ( company_id = ? and status = ?) order by first_name', array($companies, $status))->paginate(100)->appends(Input::except('page'));
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
}
} else {
$status = 'ALL';
$companies = 'default';
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
} else {
$status_date = Input::get('status_date');
$user = Auth::user();
$activeTab = 'users';
$keyword = '';
$users = User::paginate(15);
$saleTypes = SaleType::all();
$status = 'ALL';
$companies = 'default';
$from_date = Input::get('from_date');
$to_date = Input::get('to_date');
if ($status_date == null || $status_date == 'ALL') {
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
if ($status_date == 'ACTIVATION') {
$users = User::whereRaw(' ( active_date >= ? and active_date <= ?) order by first_name', array($from_date, $to_date))->paginate(100)->appends(Input::except('page'));
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
if ($status_date == 'CANCELLATION') {
$users = User::whereRaw(' ( inactive_date >= ? and inactive_date <= ?) order by first_name', array($from_date, $to_date))->paginate(100)->appends(Input::except('page'));
return view('reports.list', compact('user', 'activeTab', 'saleTypes', 'keyword', 'users', 'status', 'companies'));
}
}
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$users = User::whereRaw("`level`!=0")->paginate(10);
//$users = User::paginate(20);
return view('Admin::Admin')->with("users", $users);
}
