/**
* 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();
$chat = $this->dispatch(new CreateChatRoom($user, $project, $request->all(), $audience));
return response()->json(['success' => true, 'message' => 'Project Chat Created.', 'chat' => $chat]);
}
public function viewActivity($mode = 'default')
{
$subs = Sub::getSubs(self::userFp());
$gsubs = Gsub::getSubs(self::userFp());
$users = User::whereIn('user_fp', $subs)->orderBy('id', 'desc')->get();
return View::make('board.activity', ['mode' => $mode, 'users' => $users, 'groups' => $gsubs, 'posts' => Post::activity($mode, self::userFp(), $subs, $gsubs, self::getBL())]);
}
public function promoteNow()
{
$returnResponse = array();
$promote = Input::get('promote');
if (count($promote) > 0) {
$studentIdList = array();
$studentDetailsList = array();
while (list(, $value) = each($promote)) {
$studentIdList[] = $value['id'];
}
$users = User::whereIn('id', $studentIdList)->get();
foreach ($users as $value) {
if (studentAcademicYears::where('studentId', $value->id)->where('academicYearId', $promote[$value->id]['acYear'])->count() > 0) {
$returnResponse[] = array("id" => $value->id, "fullName" => $value->fullName, "status" => "User already been in that academic year before");
} else {
$studentAcademicYears = new studentAcademicYears();
$studentAcademicYears->studentId = $value->id;
$studentAcademicYears->academicYearId = $promote[$value->id]['acYear'];
$studentAcademicYears->classId = $promote[$value->id]['class'];
$studentAcademicYears->save();
User::where('id', $value->id)->update(['studentClass' => $promote[$value->id]['class'], 'studentAcademicYear' => $promote[$value->id]['acYear']]);
$returnResponse[] = array("id" => $value->id, "fullName" => $value->fullName, "status" => "User promoted successfully");
}
}
return $returnResponse;
}
}
public function create()
{
$mailsms = new mailsms();
if (Input::get('userType') == "users") {
$mailsms->mailTo = json_encode(Input::get('selectedUsers'));
} else {
$mailsms->mailTo = Input::get('userType');
}
$mailsms->mailType = Input::get('sendForm');
$messageData = " ";
if (Input::get('messageTitle') != "") {
$messageData .= Input::get('messageTitle');
}
if (Input::get('messageContent') != "") {
$messageData .= htmlspecialchars(Input::get('messageContent'), ENT_QUOTES);
}
$mailsms->messageData = $messageData;
$mailsms->messageDate = date("F j, Y, g:i a");
$mailsms->messageSender = $this->data['users']->fullName . " [ " . $this->data['users']->id . " ] ";
$mailsms->save();
if (Input::get('userType') == "teachers") {
$sedList = User::where('role', 'teacher')->get();
}
if (Input::get('userType') == "students") {
if (!Input::get('classId') || Input::get('classId') == "" || Input::get('classId') == "0") {
$sedList = User::where('role', 'student')->get();
} else {
$sedList = User::where('role', 'student')->where('studentClass', Input::get('classId'))->get();
}
}
if (Input::get('userType') == "parents") {
$sedList = User::where('role', 'parent')->get();
}
if (Input::get('userType') == "users") {
$usersList = array();
$selectedUsers = Input::get('selectedUsers');
foreach ($selectedUsers as $user) {
$usersList[] = $user['id'];
}
$sedList = User::whereIn('id', $usersList)->get();
}
$SmsHandler = new MailSmsHandler();
if (Input::get('sendForm') == "email") {
foreach ($sedList as $user) {
$SmsHandler->mail($user->email, Input::get('messageTitle'), Input::get('messageContent'), $user->fullName);
}
}
if (Input::get('sendForm') == "sms") {
foreach ($sedList as $user) {
if ($user->mobileNo != "") {
$SmsHandler->sms($user->mobileNo, strip_tags(Input::get('messageContent')));
}
}
}
return $this->listAll();
}
public function assignContributors($contributor_github_ids)
{
$users = User::whereIn('github_id', $contributor_github_ids)->get();
$role = Role::where(['name' => $this->roleName])->first();
foreach ($users as $user) {
if ($user->roles()->count() > 0) {
continue;
}
$user->roles()->attach($role->id);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$input = Input::all();
$sessionId = Common::checkSessionLogin($input);
$blacklist = BlackList::where('user_id', $input['user_id'])->lists('black_id');
$data = User::whereIn('id', $blacklist)->select(['avatar', 'username', 'id'])->get();
foreach ($data as $key => $value) {
$value->avatar = url(USER_AVATAR . '/' . $value->id . '/' . $value->avatar);
}
return Common::returnData(200, SUCCESS, $input['user_id'], $sessionId, $data);
}
public function sendAdminNotice(Vks $vks)
{
$vksArray = $vks->toArray();
$admins = User::whereIn('role', [ROLE_ADMIN, ROLE_ADMIN_MODERATOR])->get(['login', 'email']);
if (count($admins)) {
foreach ($admins as $admin) {
$message = App::$instance->twig->render('mails/v2/newVksAdminNotificate.twig', array('vks' => $vksArray, 'http_path' => HTTP_BASE_PATH, 'appHttpPath' => NODE_HTTP_PATH));
Mail::sendMailToStack($admin->email, "Новая заявка на ВКС #{$vks['id']}", $message);
App::$instance->log->logWrite(LOG_MAIL_SENDED, "Новая заявка на ВКС #{$vks['id']}");
}
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$input = Input::all();
$sessionId = Common::checkSessionLogin($input);
$favorites = CommonFavorite::getFavorite(['model_name' => 'User', 'follow_id' => $input['user_id'], 'type_favorite' => TYPE_FAVORITE_LIKE]);
$data = User::whereIn('id', $favorites)->select(listFieldUser())->get();
foreach ($data as $value) {
$value->avatar = url(USER_AVATAR . '/' . $value->id . '/' . User::find($value->id)->avatar);
}
// $data->avatar = url(USER_AVATAR . '/' . $value . '/' . User::find($value)->avatar);
return Common::returnData(200, SUCCESS, $input['user_id'], $sessionId, $data);
}
public function getUsers($withMe = false)
{
$list = array();
if (isset($this->id) && (int) $this->id > 0) {
$ids = $this->getUsersIds();
if (count($ids) > 0) {
User::whereIn('id', $ids)->get()->each(function ($user) use(&$list, $withMe) {
if ($withMe || $user->id != Auth::user()->id) {
$list[] = $user;
}
});
}
}
return $list;
}
public static function getDepartmentOperatorsWithAdmin($department_id)
{
$operator_ids = OperatorsDepartment::where('department_id', $department_id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$admin_id = DepartmentAdmins::where('department_id', $department_id)->pluck('user_id');
$users = User::whereIn('id', $operator_ids)->get();
if (!empty($admin_id)) {
$user = User::where('id', $admin_id)->first();
$user->name = $user->name . " - " . trans('msgs.department_admin');
$users[] = $user;
}
return $users;
} else {
return [];
}
}
public function store()
{
$users = explode(',', Input::get('users', ''));
$users_ids = User::whereIn('username', $users)->get(['id']);
$description = Input::get('description');
foreach ($users_ids as $user) {
$notification = new Notification();
$notification->description = $description;
$notification->user_id = $user->id;
$notification->sender_id = Auth::user()->id;
$notification->new = 1;
$notification->save();
}
//foreach
return Redirect::route('notifications')->with('message', 'Notification sent successfully.');
}
protected function users()
{
$role = Auth::user()->role;
switch ($role) {
case 'UL1':
$users = User::get();
break;
case 'UL2':
$users = User::whereIn('role', array('Cl1', 'CL2'))->get();
break;
case 'CL1':
$users = User::where('role', 'CL2')->get();
break;
case 'CL2':
break;
}
return $users;
}
public function listUser()
{
$token = Input::get('token', '');
$ids = Input::get('ids', '');
$ids = explode(',', $ids);
try {
$user = User::chkUserByToken($token);
$friends = User::whereIn('u_id', $ids)->get();
// return all users without any restriction case IM will use all users
$data = [];
foreach ($friends as $key => $friend) {
$data[] = $friend->showInImList();
}
$re = Tools::reTrue('获取信息成功', $data);
} catch (Exception $e) {
$re = Tools::reFalse($e->getCode(), '获取信息失败:' . $e->getMessage());
}
return Response::json($re);
}
static function getFreeDepartmentAdmins($company_id, array $exclude_admin = [])
{
$user_ids = CompanyDepartmentAdmins::where("company_id", $company_id)->lists("user_id");
$department_admins_ids = [];
if (sizeof($user_ids) > 0) {
$department_admins_ids = DepartmentAdmins::whereIn('user_id', $user_ids)->lists('user_id');
}
$department_admins = [];
if (sizeof($user_ids) > 0) {
$admins = User::whereIn("id", $user_ids)->get();
foreach ($admins as $admin) {
if (!in_array($admin->id, $exclude_admin)) {
if (!in_array($admin->id, $department_admins_ids)) {
array_push($department_admins, $admin);
}
} else {
array_push($department_admins, $admin);
}
}
}
return $department_admins;
}
public function getAuthorizedUserids($authorization_flag)
{
if ($authorization_flag === 0) {
return [];
}
if ($authorization_flag === 1) {
return [$this->id];
}
$key = implode('.', ['User', 'getAuthorizedUserids', $this->id, $authorization_flag]);
$user = $this;
return Cache::tags(['User', 'OrganizationUnit'])->rememberForever($key, function () use($authorization_flag, $user) {
$result = [$user->id];
if ($user->organizationunit->user_id === $user->id) {
if ($authorization_flag == 2) {
$result = $user->organizationunit->users->lists('id');
}
if ($authorization_flag == 3) {
$result = User::whereIn('organization_unit_id', $user->organizationunit->descendantsAndSelf()->get()->lists('id'))->lists('id');
}
}
return $result;
});
}
public function all()
{
$group = Groups::where("name", "admin")->first();
$user_ids = UsersGroups::where("group_id", $group->id)->lists("user_id");
if (sizeof($user_ids) > 0) {
$this->data["users"] = User::whereIn("id", $user_ids)->get();
} else {
$this->data["users"] = [];
}
return View::make('accounts.all', $this->data);
}
public function transfer($onlineusers_id)
{
$online_users = OnlineUsers::find($onlineusers_id);
$companies = Company::all();
$this->data['operators'] = [];
if (sizeof($companies) > 0) {
$departments = Department::where('company_id', $online_users->company_id)->get();
$department_ids = Department::where('company_id', $online_users->company_id)->lists('id');
if (sizeof($department_ids) > 0) {
$operator_ids = OperatorsDepartment::whereIn('department_id', $department_ids)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$this->data['operators'] = User::whereIn('id', $operator_ids)->get();
}
}
} else {
$departments = [];
}
$this->data['companies'] = $companies;
$this->data['departments'] = $departments;
$this->data['online_users'] = $online_users;
$this->data['company_id'] = $online_users->company_id;
$this->data['department_id'] = $online_users->department_id;
$this->data['customer'] = User::find($online_users->user_id);
return View::make('conversations.transfer', $this->data);
}
public function start()
{
$response = [];
$response['token'] = 0;
if (Input::has('ip')) {
//check ip_address in blocking table
$blocking = Blocking::where('ip_address', Input::get('ip'))->first();
if (!empty($blocking)) {
if ($blocking->should_block_chat || $blocking->should_block_web_access) {
$response['blocked'] = 1;
$response['errors'] = trans('msgs.your_ip_blocked_by_admin_contact_support');
}
}
} else {
$response['blocked'] = 1;
$response['errors'] = trans('msgs.your_ip_blocked_by_admin_contact_support');
}
$response['blocked'] = 0;
$v_data = ["email" => Input::get('email'), "name" => Input::get('name'), "company_id" => Input::get('company_id'), "domain" => Input::get('domain'), "department" => Input::get('department'), "message" => Input::get('message')];
$v_rules = ["email" => 'required|email', "name" => 'required', "company_id" => 'required', "domain" => 'required', "department" => 'required', "message" => 'required'];
$v = Validator::make($v_data, $v_rules);
if ($v->passes()) {
$request_check = Company::where('id', Input::get('company_id'))->where('domain', Input::get('domain'))->get();
if (sizeof($request_check) <= 0) {
return $this->send(['result' => 0, 'errors' => trans('msgs.invalid_request_check_id_and_domain')]);
}
$company_customers = CompanyCustomers::where('company_id', Input::get('company_id'))->lists('customer_id');
$user = null;
if (sizeof($company_customers)) {
$user = User::whereIn('id', $company_customers)->where('email', Input::get('email'))->first();
}
$operator_online = Company::operatorsOnline(Input::get('company_id'));
$success_msg = trans('msgs.thanks_for_contacting_will_get_back');
$response['is_online'] = $operator_online;
$repo = new KodeInfo\Repo\MessageRepo();
if (!empty($user) && !is_null($user)) {
//user exists
$count = OnlineUsers::where('user_id', $user->id)->first();
if (sizeof($count) > 0) {
//user already online
$token = OnlineUsers::getToken();
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $count->thread_id;
$response['success_msg'] = $success_msg;
return $this->send($response);
} else {
$token = OnlineUsers::getToken();
$thread = $repo->createNewThread($user->id, Input::get("message"), true);
if ($response['is_online']) {
$online_user = new OnlineUsers();
$online_user->user_id = $user->id;
$online_user->thread_id = $thread['thread_id'];
$online_user->operator_id = 0;
$online_user->company_id = Input::get('company_id');
$online_user->department_id = Input::get('department');
$online_user->locked_by_operator = 0;
$online_user->requested_on = \Carbon\Carbon::now();
$online_user->token = $token;
$online_user->save();
}
$country = DB::table('countries')->where('countryCode', Input::get('country'))->first();
$geo_info = new ThreadGeoInfo();
$geo_info->thread_id = $thread['thread_id'];
$geo_info->ip_address = Input::get('ip');
$geo_info->country_code = Input::get('country');
$geo_info->country = !empty($country) ? $country->countryName : "";
$geo_info->provider = Input::get('provider');
$geo_info->current_page = Input::get('page');
$geo_info->all_pages = json_encode(['pages' => [Input::get('page')]]);
$geo_info->save();
if (!$response['is_online']) {
$this->convertToTicket($thread['thread_id'], $thread['msg_id'], $user, "", Input::get('message'), Input::get('department'), Input::get('company_id'));
}
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $thread['thread_id'];
$response['success_msg'] = $success_msg;
return $this->send($response);
}
} else {
$password = Str::random();
//Is user in users table then get id and put in company-customers table
$user = User::where('email', Input::get('email'))->first();
if (!empty($user)) {
$company_customer = new CompanyCustomers();
$company_customer->company_id = Input::get('company_id');
$company_customer->customer_id = $user->id;
$company_customer->save();
} else {
$user = $this->userManager->createUser(["name" => Input::get('name'), "email" => Input::get('email'), "password" => $password, "password_confirmation" => $password], 'customer', false);
$user->avatar = "/assets/images/default-avatar.jpg";
$user->save();
$user->getActivationCode();
$company_customer = new CompanyCustomers();
$company_customer->company_id = Input::get('company_id');
$company_customer->customer_id = $user->id;
$company_customer->save();
$this->mailer->welcome($user->email, $user->name, User::getWelcomeFields(false, $user->id, $password, $company_customer->company_id));
$this->mailer->activate($user->email, $user->name, User::getActivateFields(false, $user->id, $company_customer->company_id));
}
$token = OnlineUsers::getToken();
$thread = $repo->createNewThread($user->id, Input::get("message"), true);
if ($response['is_online']) {
$online_user = new OnlineUsers();
$online_user->user_id = $user->id;
$online_user->thread_id = $thread['thread_id'];
$online_user->operator_id = 0;
$online_user->company_id = Input::get('company_id');
$online_user->department_id = Input::get('department');
$online_user->locked_by_operator = 0;
$online_user->requested_on = \Carbon\Carbon::now();
$online_user->token = $token;
$online_user->save();
}
$country = DB::table('countries')->where('countryCode', Input::get('country'))->first();
$geo_info = new ThreadGeoInfo();
$geo_info->thread_id = $thread['thread_id'];
$geo_info->ip_address = Input::get('ip');
$geo_info->country_code = Input::get('country');
$geo_info->country = !empty($country) ? $country->countryName : "";
$geo_info->provider = Input::get('provider');
$geo_info->current_page = Input::get('page');
$geo_info->all_pages = json_encode(['pages' => [Input::get('page')]]);
$geo_info->save();
if (!$response['is_online']) {
$this->convertToTicket($thread['thread_id'], $thread['msg_id'], $user, "", Input::get('message'), Input::get('department'), Input::get('company_id'));
}
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $thread['thread_id'];
$response['success_msg'] = $success_msg;
return $this->send($response);
}
} else {
return $this->send(['result' => 0, 'errors' => Utils::buildMessages($v->messages()->all())]);
}
}
public function all()
{
$customer_ids = [];
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$customer_ids = CompanyCustomers::where("company_id", $department->company_id)->lists('customer_id');
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$customer_ids = CompanyCustomers::where("company_id", $department->company_id)->lists('customer_id');
} else {
$customer_ids = CompanyCustomers::lists('customer_id');
}
if (sizeof($customer_ids) > 0) {
$this->data["customers"] = User::whereIn("id", $customer_ids)->orderBy('id', 'desc')->get();
} else {
$this->data["customers"] = [];
}
foreach ($this->data["customers"] as $customer) {
$company_id = CompanyCustomers::where("customer_id", $customer->id)->pluck('company_id');
$customer->company = Company::find($company_id);
$customer->all_ticket_count = Tickets::where('customer_id', $customer->id)->count();
$customer->pending_ticket_count = Tickets::where('customer_id', $customer->id)->where('status', Tickets::TICKET_PENDING)->count();
$customer->resolved_ticket_count = Tickets::where('customer_id', $customer->id)->where('status', Tickets::TICKET_RESOLVED)->count();
}
return View::make('customers.all', $this->data);
}
/**
* Update the project
*/
public function updateProject($data, $userId)
{
//Find the project and update the fileds
$project = Project::find($data['projectid']);
$project->project_name = $data['project_name'];
$project->description = $data['description'];
$project->status = $data['status'];
$tempStartDate = \DateTime::createFromFormat('j F, Y', $data['startdate']);
$tempEndDate = \DateTime::createFromFormat('j F, Y', $data['enddate']);
$project->start_date = $tempStartDate->format('Y-m-d');
$project->end_date = $tempEndDate->format('Y-m-d');
$project->project_client = $data['project_client'];
$project->note = $data['note'];
//If the project is marked completed fill the respective fields of database
if ($data['status'] == 'completed') {
$project->completed_on = date_create();
$project->mark_completed_by = $userId;
$project->updated_by = $userId;
$project->save();
} else {
$project->updated_by = $userId;
$project->save();
}
//Remove all the Collaborators of the project
$prjtUsrs = ProjectUsers::where('project_id', $data['projectid'])->forceDelete();
//New list of emails of collaborators
$email = $data['tagsinput'];
$emails = preg_split("/[\\s,]+/", $email);
//Get the user Ids of the new collaborators
$userIdList = \User::whereIn('email', $emails)->lists('id');
//Add collaborators
foreach ($userIdList as $usrId) {
$projectcollabs = new \Projectcollabs();
$projectcollabs->user_id = $usrId;
$projectcollabs->project_id = $data['projectid'];
$projectcollabs->save();
}
//Get the project name and Id for the next view
$projectName = $data['project_name'];
$projectId = $data['projectid'];
$files;
$filesId = FileReference::where('parent_id', $projectId)->where('parent_type', 'project')->lists('attachment_id');
if ($filesId == null) {
$files = null;
} else {
$files = Files::whereIn('id', $filesId)->get(array('file_name', 'id', 'key', 'size', 'uploaded_date', 'uploaded_by'))->toArray();
}
//Wrap up data
$returnData['projectName'] = $projectName;
$returnData['projectId'] = $projectId;
$returnData['files'] = $files;
//Shoot back
return $returnData;
}
public static function getAllValidSponsors()
{
$userMeta = UserMeta::where('meta_key', '=', UserMeta::TYPE_INDEPENDENT_SPONSOR)->where('meta_value', '=', 1)->get();
$groups = Group::where('status', '=', Group::STATUS_ACTIVE)->get();
$results = new Collection();
$userIds = array();
foreach ($userMeta as $m) {
$userIds[] = $m->user_id;
}
if (!empty($userIds)) {
$users = User::whereIn('id', $userIds)->get();
foreach ($users as $user) {
$row = array('display_name' => "{$user->fname} {$user->lname}", 'sponsor_type' => 'individual', 'id' => $user->id);
$results->add($row);
}
}
foreach ($groups as $group) {
$row = array('display_name' => $group->display_name, 'sponsor_type' => 'group', 'id' => $group->id);
$results->add($row);
}
return $results;
}
public function banlist()
{
$bl = Ban::where('user_fp', self::userFp())->lists('ban_fp');
$users = User::whereIn('user_fp', $bl)->get();
return View::make('user.banlist', ["users" => $users]);
}
function index()
{
if (\KodeInfo\Utilities\Utils::isCustomer(Auth::user()->id)) {
return Redirect::to('/tickets/customer/all');
}
$past_hr = \Carbon\Carbon::now()->subHour();
$today = \Carbon\Carbon::now()->subDay();
$this_week = \Carbon\Carbon::now()->subWeek();
$this_month = \Carbon\Carbon::now()->subMonth();
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$company = Company::where('id', $department->company_id)->first();
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
$this->data['department_stats'] = $department;
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_operator->department_id)->first();
$company = Company::where('id', $department->company_id)->first();
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
$this->data['department_stats'] = $department;
} else {
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$companies = Company::all();
foreach ($companies as $company) {
$departments = Department::where('company_id', $company->id)->get();
foreach ($departments as $department) {
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
}
$company->departments = $departments;
}
$this->data['department_stats'] = $companies;
}
return View::make('index', $this->data);
}
public function testIn()
{
$users = User::whereIn('age', array(13, 23))->get();
$this->assertEquals(2, count($users));
$users = User::whereIn('age', array(33, 35, 13))->get();
$this->assertEquals(6, count($users));
$users = User::whereNotIn('age', array(33, 35))->get();
$this->assertEquals(4, count($users));
$users = User::whereNotNull('age')->whereNotIn('age', array(33, 35))->get();
$this->assertEquals(3, count($users));
}
/**
* 获取系统管理员信息
*
* @return array
*/
public static function getSystemAdmin()
{
$founder = explode(',', str_replace(' ', '', Config('auth.founder')));
$founders = User::whereIn('uid', $founder)->get();
return $founders;
}
public function all()
{
$user_ids = [];
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$department_ids = Department::where('company_id', $department->company_id)->lists('id');
$user_ids = DepartmentAdmins::whereIn('department_id', $department_ids)->lists('user_id');
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$department_ids = Department::where('company_id', $department->company_id)->lists('id');
$user_ids = DepartmentAdmins::whereIn('department_id', $department_ids)->lists('user_id');
} else {
$group = Groups::where("name", "department-admin")->first();
$user_ids = UsersGroups::where("group_id", $group->id)->lists("user_id");
}
if (sizeof($user_ids) > 0) {
$this->data["admins"] = User::whereIn("id", $user_ids)->orderBy('id', 'desc')->get();
} else {
$this->data["admins"] = [];
}
foreach ($this->data["admins"] as $admin) {
$department_admin = DepartmentAdmins::where('user_id', $admin->id)->first();
if (!empty($department_admin)) {
$admin->department = Department::find($department_admin->department_id);
}
$company_id = CompanyDepartmentAdmins::where("user_id", $admin->id)->pluck('company_id');
$admin->company = Company::find($company_id);
}
return View::make('department_admins.all', $this->data);
}
public function delete($company_id)
{
$departments = Department::where('company_id', $company_id)->get();
if (Config::get('site-config.is_demo') && $company_id == 1) {
Session::flash('error_msg', 'Demo : Feature is disabled');
return Redirect::to('/dashboard');
}
foreach ($departments as $department) {
if (!empty($department)) {
$tickets = Tickets::where('department_id', $department->id)->get();
//Delete tickets
foreach ($tickets as $ticket) {
TicketAttachments::where('thread_id', $ticket->id)->delete();
MessageThread::where('id', $ticket->thread_id)->delete();
ThreadMessages::where('thread_id', $ticket->thread_id)->delete();
}
Tickets::where('department_id', $department->id)->delete();
//Delete Chat and Conversations
$online_users = OnlineUsers::where('department_id', $department->id)->get();
foreach ($online_users as $online_user) {
MessageThread::where('id', $online_user->thread_id)->delete();
ThreadMessages::where('thread_id', $online_user->thread_id)->delete();
}
OnlineUsers::where('department_id', $department->id)->delete();
$closed_conversations = ClosedConversations::where('department_id', $department->id)->get();
foreach ($closed_conversations as $closed_conversation) {
MessageThread::where('id', $closed_conversation->thread_id)->delete();
ThreadMessages::where('thread_id', $closed_conversation->thread_id)->delete();
}
ClosedConversations::where('department_id', $department->id)->delete();
$operators = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operators) > 0) {
User::whereIn('id', $operators)->delete();
UsersGroups::whereIn('user_id', $operators)->delete();
}
OperatorsDepartment::where('department_id', $department->id)->delete();
$department_admin = DepartmentAdmins::where('department_id', $department->id)->first();
if (!empty($department_admin)) {
UsersGroups::where('user_id', $department_admin->user_id)->delete();
User::where("id", $department_admin->user_id)->delete();
CompanyDepartmentAdmins::where("user_id", $department_admin->user_id)->delete();
CannedMessages::where('operator_id', $operators)->delete();
}
}
DepartmentAdmins::where('department_id', $department->id)->delete();
Department::where('id', $department->id)->delete();
}
$company = Company::where('id', $company_id)->first();
RecentActivities::createActivity("Company <a href='/companies/all'>" . $company->name . "</a> deleted by User Name " . Auth::user()->name . " User ID " . Auth::user()->id);
Company::where('id', $company_id)->delete();
Session::flash('success_msg', trans('msgs.company_deleted_success'));
return Redirect::to('/companies/all');
}
}
//dd($qid1);
$users1 = User::where('event', '=', $exceleve)->orderby('name')->with(array('answer' => function ($q) use($qid1) {
$q->where('question_id', '=', $qid1)->orWhere('question_id', '=', $qid1 + 1);
}))->get();
$user_ids = array();
foreach ($users1 as $us) {
if ($us->answer[0]->answer_text != '' && $us->role != 'admin_dd') {
$user_ids[] = $us->id;
}
}
//dd($user_ids);
$useransarr = array();
$users = User::whereIn('id', $user_ids)->get();
//dd($users);
$userswithanswers = User::whereIn('id', $user_ids)->with('answer')->with('categoryvendoranswer')->get();
//dd($userswithanswers);
foreach ($userswithanswers as $usa) {
$tempansarr = array();
$tempcatansarr = array();
foreach ($usa->answer as $ansobj) {
$tempansarr[$ansobj->question_id] = $ansobj->answer_text;
}
foreach ($usa->categoryvendoranswer as $catansobj) {
$tempcatansarr[$catansobj->categoryvendor_id] = $catansobj->answer;
}
$useransarr[$usa->id]['login'] = $usa->email;
$useransarr[$usa->id]['id'] = $usa->id;
$useransarr[$usa->id]['answers'] = $tempansarr;
$useransarr[$usa->id]['catanswers'] = $tempcatansarr;
// dd($useransarr[]);
public function updateTask($data, $updateUserId)
{
try {
$email = $data['users'];
$emails = preg_split("/[\\s,]+/", $email);
$usersId = \User::whereIn('email', $emails)->lists('id');
$task = \Task::find((int) $data['taskId']);
$task->name = $data['task_name'];
$task->note = $data['note'];
if ($data['project'] == 'null') {
$task->project_id = null;
} else {
$task->project_id = (int) $data['project'];
}
\Log::info($data['startdate']);
$tempStartDate = \DateTime::createFromFormat('j F, Y', $data['startdate']);
$tempEndDate = \DateTime::createFromFormat('j F, Y', $data['enddate']);
$task->start_date = $tempStartDate->format('Y-m-d');
$task->end_date = $tempEndDate->format('Y-m-d');
$task->updated_by = (int) $updateUserId;
$task->save();
$taskcollabs = \Taskcollabs::where('task_id', (int) $data['taskId'])->forceDelete();
foreach ($usersId as $userId) {
$taskCollabs = new \Taskcollabs();
$taskCollabs->task_id = (int) $data['taskId'];
$taskCollabs->user_id = $userId;
$taskCollabs->updated_by = $updateUserId;
$taskCollabs->save();
}
$result['status'] = 'success';
$result['id'] = $task->id;
return $result;
} catch (Exception $e) {
\Log::error('Something Went Wrong in Task Repository - updateTask():' . $e->getMessage());
$result['status'] = 'error';
return $result;
}
}
public function getDeleteAdminModal()
{
$ids = Input::get('ids');
$users = User::whereIn('id', $ids)->get();
$ids = json_encode($ids);
return View::make('admin.modals.deleteAdmin')->with('ids', $ids)->with('users', $users);
}
