/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(Project $project, User $user)
{
$admin = JWTAuth::parseToken()->authenticate();
$audience = User::whereIn('id', explode(',', $request->get('audience')))->get();
$this->dispatch(new RemoveUserFromProject($admin, $project, $user, $audience));
return response()->json(['success' => true, 'message' => 'User Left Project.']);
}
public function index()
{
$classes = StudyClass::all();
$teacher_ids = array();
$assist_ids = array();
foreach ($classes as $class) {
if ($class->teach != null) {
$teacher_ids[] = $class->teach->id;
}
if ($class->assist != null) {
$assist_ids[] = $class->assist->id;
}
}
$teachers = User::whereIn('id', $teacher_ids)->get();
foreach ($teachers as &$teacher) {
$class_ids = array();
foreach ($teacher->teach as $t) {
$class_ids[] = $t->id;
}
$teacher->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->count();
$teacher->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->avg('rating_teacher');
}
$assistants = User::whereIn('id', $assist_ids)->get();
foreach ($assistants as &$assistant) {
$class_ids = array();
foreach ($assistant->assist as $t) {
$class_ids[] = $t->id;
}
$assistant->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->count();
$assistant->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->avg('rating_ta');
}
$this->data['teachers'] = $teachers;
$this->data['assistants'] = $assistants;
return view('manage.personal_rating.all', $this->data);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Project $project, Request $request)
{
$user = JWTAuth::parseToken()->authenticate();
$audience = User::whereIn('id', explode(',', $request->get('audience')))->get();
$forum = $this->dispatch(new PostForum($user, $project, $request->all(), $audience));
return response()->json(['success' => true, 'message' => 'Forum Posted.', 'forum' => $forum]);
}
public function refresh()
{
if (!\Session::get('user')->is_admin()) {
abort(401);
}
$group_id = config('gapper.group_id');
$members = Client::getMembers($group_id);
if (count($members)) {
$deleted_users = User::all()->lists('gapper_id', 'id')->toArray();
foreach ($members as $member) {
$id = $member['id'];
$user = User::where('gapper_id', $id)->first();
if (!$user) {
$user = new \App\User();
$user->gapper_id = $member['id'];
$user->name = $member['name'];
$user->icon = $member['icon'];
} else {
$user->name = $member['name'];
$user->icon = $member['icon'];
//从 deleted_users 中删除当前 gapper_id 对应的用户
//最后剩下的, 就是 User 中不包含 gapper_id 的用户
if (array_key_exists($member['id'], $deleted_users)) {
unset($deleted_users[$id]);
}
}
$user->save();
}
//发现有需要删除的 User
if (count($deleted_users)) {
$to_deleted_users = User::whereIn('id', array_values($deleted_users))->delete();
}
}
return redirect()->to('users')->with('message_content', '同步成功!')->with('message_type', 'info');
}
public function postGroupList(Request $request)
{
//新增职务
if ($request->has('new_cp_group_name')) {
$new_cp_group_name = $request->input('new_cp_group_name');
if (in_array($new_cp_group_name, array('系统管理员', '超级管理员')) || AdminGroup::where('cp_group_name', '=', $new_cp_group_name)->first()) {
return redirect($this->redirectPath('/user/groups'))->withErrors([Lang::get('access.addNewCpGroupFailed')]);
}
$adminGroup = new AdminGroup();
$adminGroup->cp_group_name = strip_tags($new_cp_group_name);
$adminGroup->save();
}
//更新职务
if ($request->has('name')) {
foreach ($request->input('name') as $cp_group_id => $cp_group_name) {
$adminGroup = AdminGroup::find($cp_group_id);
$adminGroup->cp_group_name = $cp_group_name;
$adminGroup->save();
}
}
//删除职务
if ($request->has('delete')) {
AdminAccess::destroy($request->input('delete'));
User::whereIn('cp_group_id', $request->input('delete'))->delete();
AdminGroup::destroy($request->input('delete'));
}
return redirect($this->redirectPath('/user/groups'))->with($this->statusVar, Lang::get('access.updateCpGroupSuccess'));
}
/**
* Execute the job.
*
* @return void
*/
public function handle(Mailer $mail)
{
$group = $this->ticket->group_id;
$customers = Group::where('id', $group)->first()->customers()->get();
$_customers = [];
foreach ($customers as $customer) {
$_customers[] = $customer->id;
}
$sys_name = Settings::where('name', 'sys_name')->first();
$user = User::whereIn('customer_id', $_customers)->get();
foreach ($user as $_user) {
$mail->send('emails.updateticket', ['user' => $_user, 'ticket' => $this->ticket, 'response' => $this->response, 'sys_name' => $sys_name], function ($m) use($_user) {
$m->to($_user->email, $_user->first_name . ' ' . $_user->last_name)->subject('Ticket updated - ' . $this->ticket->track_id . ' [' . $this->ticket->status->name . ']');
if (count($this->response->attachments()->get()) > 0) {
foreach ($this->response->attachments as $attachment) {
$m->attach(storage_path() . '/attachments/' . $this->ticket->id . '/' . $attachment->name);
}
}
});
}
// Cleanup variables
unset($this->ticket);
unset($this->response);
unset($group);
unset($customers);
unset($user);
unset($sys_name);
unset($_customers);
}
public static function notify($idArr = array(), $body, $type, $to_all = 0, $is_system = 0)
{
$currentId = auth()->id();
if (!$currentId) {
return;
}
$data = $notifiedUidArr = [];
$now = \Carbon\Carbon::now();
if ($to_all) {
$data = ['user_id' => 0, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now];
} elseif (!empty($idArr)) {
$idArr = array_unique($idArr);
foreach ($idArr as $id) {
if ($id == $currentId) {
return;
}
$data[] = ['user_id' => $id, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now];
$notifiedUidArr[] = $id;
}
}
if (!empty($data)) {
Notify::insert($data);
if ($to_all) {
\DB::table('users')->increment('notice_count');
} elseif ($notifiedUidArr) {
User::whereIn('id', $notifiedUidArr)->increment('notice_count');
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$projectdetails = ['name' => 'shitzu', 'description' => 'frickzena oah auhsdoh vgos'];
$taskdetails = ['name' => 'joozie', 'description' => 'ahioihd poaiy7u ascihogyfcd pouaou'];
$taskdetails2 = ['name' => 'ambroze', 'description' => 'shitzu prickzen la frickzen'];
$statusdetails = ['message' => 'hello wazzup?'];
DB::table('projects')->delete();
DB::table('users_projects')->delete();
DB::table('stories')->delete();
DB::table('sprints')->delete();
DB::table('backlogs')->delete();
// optional
DB::table('comments')->delete();
DB::table('statuses')->delete();
$user1 = User::firstOrFail();
$user2 = User::all()->last();
$project = Bus::dispatch(new CreateProject($user1, $projectdetails));
Bus::dispatch(new AddUserToProject($user1, $project, $user2, 'developer'));
$users = User::whereIn('id', [$user1->id, $user2->id])->get();
$backlog = App\Backlog::create(['name' => 'Release Elixir']);
$user1->backlogs()->save($backlog);
$project->backlogs()->save($backlog);
$sprint = App\Sprint::create(['name' => 'Sprint Shikku']);
$project->sprints()->save($sprint);
$backlog->sprints()->save($sprint);
$user1->sprints()->save($sprint);
$datas = [['name' => 'Refactoring Iceblocks', 'description' => 'Cool tasks are always cool. So do this !!', 'priority' => 1, 'work_hours' => '7'], ['name' => 'Streaming section', 'description' => 'This is one of the besttask ever i ve seen in my life time => )', 'priority' => 0, 'work_hours' => '2'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Smooth UI Design', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 2, 'work_hours' => '4'], ['name' => 'Refactoring Iceblocks', 'description' => 'Major refactor needed in the sublimentory section of zylanfuzku Masked version.Its all about the stuffs and stone of the rechard steven.', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Smooth UI Design', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 2, 'work_hours' => '4'], ['name' => 'Refactoring Iceblocks', 'description' => 'Major refactor needed in the sublimentory section of zylanfuzku Masked version.Its all about the stuffs and stone of the rechard steven.', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2']];
foreach ($datas as $data) {
$story = App\Story::create($data);
$project->stories()->save($story);
$user1->createdStories()->save($story);
}
}
public function parse($body)
{
$this->body_original = $body;
$this->usernames = $this->getMentionedUsername();
count($this->usernames) > 0 && ($this->users = User::whereIn('name', $this->usernames)->get());
$this->replace();
return $this->body_parsed;
}
public static function dependentsOkay($dependentIDList)
{
$accountID = Auth::user()->id;
$matchCount = User::whereIn('id', $dependentIDList)->where(function ($query) use($accountID) {
$query->where('accountId', '=', $accountID)->where('approved', '<>', 'false');
})->count();
return $matchCount == sizeof($dependentIDList);
}
public static function getUsersString($id)
{
$result = "";
$_users = ConversationUser::where(['conversation_id' => $id])->get(['user_id']);
$users = User::whereIn('id', $_users)->get();
foreach ($users as $user) {
if ($user->id != Auth::id()) {
$result = $result . $user->name . " " . $user->surname . ", ";
}
}
return rtrim($result, ", ");
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$images = Picture::where('user_id', '=', Auth::user()->id)->where('isDish', '=', false)->orderBy('id', 'desc')->take(5)->get();
$profile = User::find(Auth::user()->id);
$favoriteDish = explode(';', $profile->favoriteDish);
$time = explode("-", $profile->dateOfBirth);
$dt = Carbon::createFromDate($time[0], $time[1], $time[2], 'Europe/Brussels');
$now = Carbon::today();
$age = $now->diffInYears($dt);
$profile->age = $age;
foreach ($favoriteDish as $key => $value) {
if ($value == "") {
unset($favoriteDish[$key]);
}
}
$profile->favoriteDishArray = $favoriteDish;
$friends = User::where('id', '=', Auth::user()->id)->first()->friends()->get();
$friendRequests = Friend::where('friend_id', '=', Auth::user()->id)->where('accepted', '=', false)->get();
$mayLike = array();
foreach ($profile->tastes as $taste) {
$othersTaste = $taste->users()->where('user_id', '<>', Auth::user()->id)->where('taste_id', $taste->id)->get();
foreach ($othersTaste as $user) {
$mayLike[] = $user->id;
}
}
//count how many times an id apears in array
$CountMayLikes = array_count_values($mayLike);
//sort from high to low
arsort($CountMayLikes);
//var_dump($CountMayLikes);
$sortedArray = [];
foreach ($CountMayLikes as $id => $value) {
$sortedArray[] = $id;
}
//var_dump($sortedArray);
//give te first 10z
$pYML = array_slice($sortedArray, 0, 10);
$people = User::whereIn('id', $pYML)->select('id', 'name', 'surname', 'country', 'city', 'dateOfBirth')->get();
foreach ($people as $person) {
// var_dump($person->id);
$picture_url = Picture::where('user_id', $person->id)->select('picture_url')->first();
// echo '<pre>';
// var_dump($picture_url['picture_url']);
$person->picture_url = $picture_url['picture_url'];
}
$smaken = Taste::select('id', 'tastes')->get();
$tasts = array();
foreach ($smaken as $smaak) {
$tasts[$smaak->id] = $smaak->tastes;
}
$data = ['profile' => $profile, 'friends' => $friends, 'friendRequests' => $friendRequests, 'images' => $images, 'tasts' => $tasts, 'peoples' => $people];
return View('dashboard')->with($data);
}
public function index(Request $request)
{
// 获取排序条件
$orderColumn = $request->get('sort_up', $request->get('sort_down', 'created_at'));
$direction = $request->get('sort_up') ? 'asc' : 'desc';
$members = User::whereIn('level', ['003', '002'])->whereHas('roles', function ($query) {
$query->where('slug', 'member');
})->orderBy($orderColumn, $direction)->paginate(8);
$nonMembers = User::where('level', '001')->whereHas('roles', function ($query) {
$query->where('slug', 'member');
})->orderBy($orderColumn, $direction)->paginate(8);
return view('admin.user.list', compact('members', 'nonMembers', 'query'));
}
function getTask()
{
$user = \Auth::user();
$events = Event::all();
$event = Event::latest('id')->first();
$tasks = Task::all();
$categories = array('Pending', 'In-progress', 'Delayed', 'Finished');
//Array of head->id of user
$heads_comm = Head::where('event_id', $event->id)->where('user_id', $user->id)->get(array('comm_id'))->toArray();
//members of committee
$mem = Member::whereIn('comm_id', $heads_comm)->get(array('user_id'))->toArray();
$members = User::whereIn('id', $mem)->get();
//committees where user is head
$committees = Committee::whereIn('id', $heads_comm)->get();
return view('pages/task', compact('user', 'members', 'events', 'event', 'committees', 'tasks', 'categories'));
}
public function addMember(AddMemberToProjectRequest $request)
{
$owner = Auth::user();
$users_id = $request->users;
// 傳進來的資料再做一次搜尋，確定傳進來的資料在資料庫都存在
$users = User::whereIn('id', $users_id)->get();
$projectId = $request->project_id;
$project = $owner->projects()->find($projectId);
$relationshipData = [];
foreach ($users as $user) {
$relationshipData[] = $user->id;
}
// 為project加入關聯
$project->users()->attach($relationshipData, ['role' => $request->role]);
return $project->users()->whereIn('id', $users_id)->get();
}
/**
* 사용자를 json형태로 가져옴
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
private function getUserCollection(Request $request)
{
$type = $request->get('type', 'dept_id');
$value = $request->get('value', '0');
$list = collect([]);
switch ($type) {
case 'dept_id':
$dept = Department::find($value);
if ($dept) {
$allDepts = $dept->allChildDepartments();
$list = User::whereIn('dept_id', $allDepts->pluck('id')->toArray())->get();
}
break;
}
return $list;
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
view()->composer('partials.navigation', function ($view) {
if (Auth::guest()) {
//とりあえず
$rooms = Room::take(10)->get();
$friends = User::all();
$view->with(['rooms' => $rooms, 'friends' => $friends]);
} else {
$user_id = Auth::user()->id;
$rooms = User::find($user_id)->room;
$friends_id_lists = User::find($user_id)->friends->lists('friends_id');
$friends = User::whereIn('id', $friends_id_lists)->get();
$friends_request = Friends::where('friends_id', $user_id)->where('friends_request', 1)->get();
//$friends_request = Friends::whereIn('user_id' , $friends_request_lists)->get();
$view->with(['rooms' => $rooms, 'friends' => $friends, 'friends_request' => $friends_request]);
}
});
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
//
// validate
// read more on validation at http://laravel.com/docs/validation
$rules = $this->getRestrictions();
$validator = Validator::make($request->all(), $rules);
// process the login
if ($validator->fails()) {
return redirect('/families/create')->withErrors($validator)->withInput($request->all());
} else {
// store
$family = new Family();
$family = $this->assignValues($request, $family);
$family->save();
User::whereIn("id", $request->input('members'))->update(["family_id" => $family->id]);
Session::flash('status', 'Successfully created the Family!');
return redirect('/families');
}
}
/**
* Display the friends of the User
*
* @param int $id
* @param int $level
* @return Response
*/
public function show($id, $level = 1)
{
try {
$friends_by_level = [];
$names = ["User_" . $id];
for ($i = 1; $i <= $level; $i++) {
$cur_level = User::whereIn("name", $names)->get();
foreach ($cur_level as $cur) {
$friends = $cur->friend()->get()->toArray();
foreach ($friends as $friend) {
if (!in_array($friend['name'], $names) && $friend['name'] != "User_" . $id) {
$names[] = $friend['name'];
$friends_by_level[$i][] = $friend;
}
}
}
}
return response()->json($friends_by_level);
} catch (Exception $e) {
dd($e->getMessage());
}
}
/**
* Shows a message thread
*
* Example URL: GET /api/v1/messages/1?api_key=30ce6864e2589b01bc002b03aa6a7923
*
* @param MessageTransformer $messageTransformer
* @param $id
* @return mixed
*/
public function show(MessageTransformer $messageTransformer, $id)
{
$userId = $this->user->id;
try {
$thread = Thread::findOrFail($id);
} catch (ModelNotFoundException $e) {
return $this->respondNotFound('Sorry, the message thread was not found.');
}
$thread->markAsRead($userId);
$messageData = $thread->toArray();
// Get messages
$messages = $thread->messages()->with('user')->get();
$messageData['messages'] = $messages->toArray();
// Get participants
$participants = User::whereIn('id', $thread->participantsUserIds())->get();
$messageData['participants'] = $participants->toArray();
// Get non-participants
$nonParticipants = User::whereNotIn('id', $thread->participantsUserIds())->get();
$messageData['non_participants'] = $nonParticipants->toArray();
$data = $messageTransformer->transform($messageData);
$response = ['data' => $data];
return $this->respondWithSuccess($response);
}
public function shifts_progress($gen_id = null)
{
if ($gen_id) {
$current_gen = Gen::find($gen_id);
} else {
$current_gen = Gen::getCurrentGen();
}
$weeks = $current_gen->shifts()->get()->pluck('week')->unique()->sortByDesc(function ($week, $key) {
return $week;
});
$return_arr = [];
foreach ($weeks as $week) {
$week_shifts = $current_gen->shifts()->where('week', $week)->get();
$user_ids = $week_shifts->pluck('user_id');
$users = User::whereIn('id', $user_ids)->get();
$shift_count_arr = [];
$max_count = 0;
foreach ($users as $user) {
$count = $user_ids->filter(function ($item) use($user) {
return $item == $user->id;
})->count();
if ($count > $max_count) {
$max_count = $count;
}
$shift_count_arr[] = ['count' => $count, 'user' => ['name' => $user->name, 'url' => url('profile/' . get_first_part_of_email($user->email))]];
}
$return_arr[] = ['week' => $week, 'progresses' => $shift_count_arr, 'max_count' => $max_count];
}
return response()->json($return_arr);
}
public function editTeam($id)
{
if (!$this->auth()) {
return "You have no Permissions!";
}
$team = team::where('teamID', '=', $id)->first();
$students = team_contents::where('teamID', '=', $id)->get(array('studentID'));
$s = array();
foreach ($students as $a) {
array_push($s, $a->studentID);
}
$teamContents = User::whereIn('id', $s)->get();
$allStudents = User::whereNotIn('id', $s)->get();
return view('editTeam', compact('team', 'teamContents', 'allStudents'));
}
public function testTaskOwnership()
{
$project = Project::has('users', '>', 1)->first();
$user1 = $project->users()->wherePrivilegeLevel('1')->first();
$user2 = $project->users()->where('id', '!=', $user1->id)->first();
// echo "users {$user1->id} {$user2->id}";
$users = User::whereIn('id', [$user1->id, $user2->id])->get();
$this->assertNotNull($users);
$this->assertEquals(2, $users->count());
$task = Bus::dispatch(new CreateTask($user1, ['name' => 'poopech'], $project, null, $users));
$this->assertTrue($task->users->contains($user1->id));
$this->assertTrue($task->users->contains($user2->id));
}
/**
* Update users to lead
*
* @param AdminShowRequest $request
* @param Integer $id
* @return Redirect
*/
public function putUpdateLeadUsers(AdminShowRequest $request, $id)
{
$lead = Lead::find($id);
// Update roles
if ($request->has('role')) {
$roles = $request->get('role');
$users = User::whereIn('id', array_keys($roles))->where('id', '!=', Auth::id())->get();
foreach ($users as $user) {
$role = strtolower($roles[$user->id]);
$current_role = $lead->users()->where('user_id', $user->id)->first()->pivot->type;
if ($role != $current_role) {
$lead->users()->updateExistingPivot($user->id, ['lead_id' => $lead->id, 'type' => $role]);
}
}
}
// Update deletes
if ($request->has('delete')) {
$users = User::whereIn('id', array_keys($request->get('delete')))->get();
// Remove user pivots as necessary
foreach ($users as $user) {
$role = $lead->users()->where('user_id', $user->id)->first()->pivot->type;
$lead->users()->newPivotStatementForId($user->id)->where('lead_id', $id)->delete();
}
}
return redirect('leads/' . $id . '/assign_lead')->with('status', \Lang::get('lead.updated_users'));
}
/**
* Update users for campaign
*
* @param AdminUpdateUsersRequest $request
* @param Integer $id
* @return Redirect
*/
public function putUpdateUsers(AdminUpdateUsersRequest $request, $id)
{
// Update roles
if ($request->has('role')) {
$roles = $request->get('role');
$users = User::whereIn('id', array_keys($roles))->where('id', '!=', Auth::id())->get();
foreach ($users as $user) {
$role_id = (int) $roles[$user->id];
$current_role_id = $user->roles()->where('campaign_id', $id)->first()->id;
if ($role_id != $current_role_id) {
$user->roles()->updateExistingPivot($user->id, ['role_id' => $role_id]);
}
}
}
// Update deletes
if ($request->has('delete')) {
$users = User::whereIn('id', array_keys($request->get('delete')))->where('id', '!=', Auth::id())->get();
// Remove user pivots as necessary
foreach ($users as $user) {
$role_id = $user->roles()->where('campaign_id', $id)->first()->id;
$user->roles()->newPivotStatementForId($role_id)->where('campaign_id', $id)->delete();
}
}
return redirect('campaigns/' . $id . '/add_users')->with('status', \Lang::get('campaign.updated_users'));
}
public function scopeGetActiveUsersCount($query, $id)
{
$count = User::whereIn('status', array('NEW', 'ACTIVE', 'RESET'))->where('company_id', '=', $id)->count();
return $count . " users";
}
public function deleteByIds($ids)
{
$result = User::whereIn('id', $ids)->delete();
return $result;
}
public function update(DepartmentRequest $request, $id)
{
$allWorker = DB::table('department_worker')->where('department_id', '!=', \Crypt::decrypt($request->id))->get(['user_id']);
$duplicateWorker = [];
$leader = $request->department_leader;
$departmentUsers = $request->department_worker;
array_push($departmentUsers, $request->department_leader);
$departmentUsers = array_unique($departmentUsers);
foreach ($allWorker as $aw) {
if (in_array($aw->user_id, $request->department_worker)) {
array_push($duplicateWorker, $aw->user_id);
}
}
if (!empty($duplicateWorker)) {
$users = User::whereIn('id', $duplicateWorker)->select(DB::raw('CONCAT(first_name," ",last_name) as full_name'))->get();
$usersString = '';
foreach ($users as $u) {
$usersString .= $u->full_name . ',';
}
return response()->json(['messages' => $usersString . ' Kişileri Başka Bir Departmana Bağlıdır.'], 422);
} else {
foreach ($departmentUsers as $key => $value) {
$value == $leader ? $departmentUsers[$key] = ['user_id' => $value, 'is_senior' => 1] : ($departmentUsers[$key] = ['user_id' => $value, 'is_senior' => 0]);
}
$this->permissionSection(function () use($request, $departmentUsers) {
DB::transaction(function () use($request, $departmentUsers) {
$department = Department::where('id', '=', \Crypt::decrypt($request->id))->first();
$department->slug = $request->slug_name;
$department->name = $request->department_name;
$department->save();
$department->worker()->detach();
$department->worker()->sync($departmentUsers);
});
}, 'wts.department.edit');
return response()->json($this->editResponseMessage);
}
}
/**
* A list is users from company 'company' with permission to 'permission'
*
* @return collection
*/
public function usersWithPermissionTo($permission, $company = '')
{
if ($company == 'all') {
$user_list = $this->userList;
} elseif ($company) {
$user_list = $company->staff;
} else {
$user_list = $this->staff;
}
$user_can_list = [];
foreach ($user_list as $user) {
if ($user->can($permission)) {
$user_can_list[] = $user->id;
}
}
return User::whereIn('id', $user_can_list)->get();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\DB::table('laraboard_posts')->truncate();
$faker = \Faker\Factory::create();
// create some categories
foreach (range(1, rand(3, 7)) as $c) {
$category = new \Christhompsontldr\Laraboard\Models\Post();
$category->name = ucwords(str_replace('.', '', $faker->sentence(rand(1, 3))));
$category->body = rand(1, 6) == 6 ? $faker->sentence : null;
$category->type = 'Category';
$category->user_id = \App\User::whereIn('id', collect(\DB::select('SELECT id FROM users'))->pluck('id')->toArray())->get()->random()->id;
$category->ip = $faker->ipv4;
$category->created_at = \Carbon\Carbon::now()->subMonths(rand(6, 24))->subHours(rand(1, 24))->subMinutes(rand(1, 59));
$category->updated_at = $category->created_at;
$category->save();
// 1 in 10 chance there are no boards
if (rand(1, 10) == 10) {
continue;
}
$previous_board = $previous_thread = $previous_reply = $category;
// make some boards
foreach (range(1, rand(2, 3)) as $b) {
$board = new \Christhompsontldr\Laraboard\Models\Post();
$board->name = ucwords(str_replace('.', '', $faker->sentence(rand(1, 5))));
$board->body = rand(1, 6) == 6 ? $faker->sentence : null;
$board->type = 'Board';
$board->user_id = \App\User::whereIn('id', collect(\DB::select('SELECT id FROM users'))->pluck('id')->toArray())->get()->random()->id;
$board->ip = $faker->ipv4;
$board->created_at = \Carbon\Carbon::parse($previous_board->created_at)->addMinutes(rand(1, 500));
$board->updated_at = $board->created_at;
$board->save();
$board->makeChildOf($category);
// 1 in 10 chance there are no threads
if (rand(1, 10) == 10) {
continue;
}
$previous_board = $previous_thread = $previous_reply = $board;
// make some threads
foreach (range(1, rand(1, 20)) as $b) {
$rand = $b == 1 ? rand(1, 60) : rand(1, 300);
$thread = new \Christhompsontldr\Laraboard\Models\Post();
$thread->name = $faker->sentence(rand(3, 10));
$thread->body = implode("\n\n", $faker->paragraphs($faker->randomDigitNotNull));
$thread->type = 'Thread';
$thread->user_id = \App\User::get()->random()->id;
$thread->ip = $faker->ipv4;
$thread->created_at = \Carbon\Carbon::parse($previous_thread->created_at)->addMinutes($rand);
$thread->updated_at = $thread->created_at;
$thread->save();
$thread->makeChildOf($board);
$previous_thread = $previous_reply = $thread;
// 1 in 10 chance there are no replies
if (rand(1, 10) == 10) {
continue;
}
// make some replies
foreach (range(1, rand(1, 50)) as $r) {
$reply = new \Christhompsontldr\Laraboard\Models\Post();
$reply->body = file_get_contents('https://jaspervdj.be/lorem-markdownum/markdown.txt?num-blocks=' . rand(1, 6) . '&no-headers=true');
$reply->type = 'Reply';
$reply->user_id = \App\User::get()->random()->id;
$reply->ip = $faker->ipv4;
$reply->created_at = \Carbon\Carbon::parse($previous_reply->created_at)->addMinutes($rand);
$reply->updated_at = $reply->created_at;
$reply->save();
$reply->makeChildOf($thread);
$previous_reply = $reply;
}
}
}
}
}
