function logout_all() { $log = new Log(); $id = $_SESSION['user_login_id']; $sql = "UPDATE `user_login` SET `user_logout_time` = SYSDATE() , `user_login_status` = '0' WHERE `id` = '{$id}' "; DB::update(DB::raw($sql)); $log->add_log(" ", " ", "User Logout"); // add a log }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { session_start(); $data = $request->all(); $count = App\User::where('user_name', $data['user_name'])->count(); if ($count != 0) { return 0; } else { $data['user_owner'] = $_SESSION['user_id']; $data['user_password'] = md5($data['user_password']); $userid = App\User::create($data)->id; $log = new Log(); $log->add_log("users", $userid, "insert"); // add a log foreach ($_SESSION['groups'] as $group_name) { $group_d = App\group::where('group_name', $group_name)->first(); $group_pri = App\privilege::where('group_id', $group_d->group_id)->first(); $data_pri = ['user_id' => $userid, 'group_id' => $group_d->group_id, 'call_log' => $group_pri->call_log, 'contact' => $group_pri->contact, 'account' => $group_pri->account, 'user' => $group_pri->user, 'group' => $group_pri->group, 'sales' => $group_pri->sales, 'ticket' => $group_pri->ticket]; App\user_group::create($data_pri); } return redirect('user'); } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { session_start(); $data = $request->all(); $loguser = $_SESSION['user_id']; // $sql="UPDATE `tax` SET `code`='$_POST[code]',`name`='$_POST[name]',`description`='$_POST[description]' ,`modified_by`='$loguser',`modified_time`=SYSDATE(),`tax_code`='$_POST[tax_code]' WHERE `id` = '$_POST[id]' "; $data['modified_by'] = $loguser; App\tax::find($id)->update($data); $log = new Log(); $log->add_log("tax", $id, "update"); // add a log return redirect('tax'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { session_start(); $log = new Log(); $data = Request::all(); $loguser = $_SESSION['user_id']; $call_log_detials = App\call_log::where('deleted', '0')->find($id); if ($call_log_detials->call_type == "Sales") { $sales_detail = App\sale::where('call_log_id', $id)->first(); $row = $sales_detail; if ($_POST['status'] != $row->status) { $data_status = ['sales_id' => $row->id, 'new_status' => $data['status'], 'old_status' => $row->status, 'changed_by' => $loguser]; App\status_history::create($data_status); } $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $data['modified_by'] = $loguser; App\sale::find($row->id)->update($data); $log->add_log("sales", $row->id, "update"); // add a log id must change } elseif ($call_log_detials->call_type == "Inquiry") { $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $inquiry_detail = App\inquiry::where('call_log_id', $id)->first(); $row = $inquiry_detail; if ($data['status'] == "complete") { $endtime = date('Y-m-d H:i:s'); } else { $endtime = NULL; } $data['inquiry_end_time'] = $endtime; App\inquiry::find($row->id)->update($data); $log->add_log("inquiry", $row->id, "update"); // add a log } elseif ($call_log_detials->call_type == "Tickets") { $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $ticket_detail = App\ticket::where('call_log_id', $id)->first(); $row = $ticket_detail; $data['modified_by'] = $loguser; App\ticket::find($row->id)->update($data); $log->add_log("ticket", $row->id, "update"); // add a log if ($data['problem'] != '') { $data_ticket_problem = ['ticket_id' => $row->id, 'problem' => $data['problem'], 'owner' => $loguser]; App\ticket_problem::create($data_ticket_problem); } } return redirect('call_log'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { session_start(); $loguser = $_SESSION['user_id']; $data = $request->all(); $data['group_modified_by'] = $loguser; App\group::find($id)->update($data); $log = new Log(); $log->add_log("groups", $id, "update"); // add a log $calllog = NULL; if (isset($_POST['calllog_view'])) { if (isset($_POST['calllog_add'])) { $calllog = $calllog + $_POST['calllog_add']; } if (isset($_POST['calllog_edit'])) { $calllog = $calllog + $_POST['calllog_edit']; } if (isset($_POST['calllog_delete'])) { $calllog = $calllog + $_POST['calllog_delete']; } if ($calllog == NULL) { $calllog = 8; } } $data_pri['call_log'] = $calllog; $contact = NULL; if (isset($_POST['contact_view'])) { if (isset($_POST['contact_add'])) { $contact = $contact + $_POST['contact_add']; } if (isset($_POST['contact_edit'])) { $contact = $contact + $_POST['contact_edit']; } if (isset($_POST['contact_delete'])) { $contact = $contact + $_POST['contact_delete']; } if ($contact == NULL) { $contact = 8; } } $data_pri['contact'] = $contact; $account = NULL; if (isset($_POST['account_view'])) { if (isset($_POST['account_add'])) { $account = $account + $_POST['account_add']; } if (isset($_POST['account_edit'])) { $account = $account + $_POST['account_edit']; } if (isset($_POST['account_delete'])) { $account = $account + $_POST['account_delete']; } if ($account == NULL) { $account = 8; } } $data_pri['account'] = $account; $sales = NULL; if (isset($_POST['sales_view'])) { if (isset($_POST['sales_add'])) { $sales = $sales + $_POST['sales_add']; } if (isset($_POST['sales_edit'])) { $sales = $sales + $_POST['sales_edit']; } if (isset($_POST['sales_delete'])) { $sales = $sales + $_POST['sales_delete']; } if ($sales == NULL) { $sales = 8; } } $data_pri['sales'] = $sales; $user = NULL; if (isset($_POST['user_view'])) { if (isset($_POST['user_add'])) { $user = $user + $_POST['user_add']; } if (isset($_POST['user_edit'])) { $user = $user + $_POST['user_edit']; } if (isset($_POST['user_delete'])) { $user = $user + $_POST['user_delete']; } if ($user == NULL) { $user = 8; } } $data_pri['user'] = $user; $ticket = NULL; if (isset($_POST['ticket_view'])) { if (isset($_POST['ticket_add'])) { $ticket = $ticket + $_POST['ticket_add']; } if (isset($_POST['ticket_edit'])) { $ticket = $ticket + $_POST['ticket_edit']; } if (isset($_POST['ticket_delete'])) { $ticket = $ticket + $_POST['ticket_delete']; } if ($ticket == NULL) { $ticket = 8; } } $data_pri['ticket'] = $ticket; $group = NULL; // if(isset($_POST['group_view'])){ // if(isset($_POST['group_add'])){ // $group=$group+$_POST['group_add']; // } // if(isset($_POST['group_edit'])){ // $group=$group+$_POST['group_edit']; // } // if(isset($_POST['group_delete'])){ // $group=$group+$_POST['group_delete']; // } // if($group==NULL){ // $group=8; // } // } $data_pri['group'] = $group; App\privilege::where('group_id', $id)->first()->update($data_pri); return redirect('group'); }
/** * @return int|string */ public function login_submit() { $username = $_POST['username']; $password = $_POST['password']; $log = new Log(); $group = new GroupController(); $user = new UserController(); session_start(); $password = md5($password); //Super admin login $super_username = "******"; $super_password = md5("iphonik"); if ($username == $super_username) { if ($password == $super_password) { $_SESSION['user_type'] == "s_admin"; // set user type session return "5"; // return value } } // End super admin login DB::enableQueryLog(); $ip = $this->get_client_ip(); // get user ip //sql query $query = DB::table('users')->select('id', 'user_group', 'user_is_admin')->where('user_name', $username)->where('user_password', $password)->get(); //sql query end foreach ($query as $re) { $_SESSION['user_id'] = $re->id; if ($re->user_is_admin != "1") { // check if user is admin or not //sql query $query1 = DB::table('user_login')->select('*')->where('user_id', $re->id)->where('user_login_status', 1)->get(); //sql query end foreach ($query1 as $rew) { if ($rew->ip != $ip) { $log->add_log("logging attempt 1", $ip, $username); return $rew->ip; } //sql query DB::table('user_login')->where('user_id', $re->id)->update(['user_logout_time' => DATE('Y-m-d H:i:s'), 'user_login_status' => 0]); //sql query end } // end of foreach } //end of if foreach ($group->viewusergroups() as $row1) { $_SESSION['user_groups'][] = $row1->group_id; // add user groups to session // add user privileges to sessions foreach ($user->user_privilages($row1->group_id) as $row2) { $_SESSION['_' . $row1->group_id]['call_log'] = $row2->call_log; $_SESSION['_' . $row1->group_id]['contacts'] = $row2->contact; $_SESSION['_' . $row1->group_id]['accounts'] = $row2->account; $_SESSION['_' . $row1->group_id]['users'] = $row2->user; $_SESSION['_' . $row1->group_id]['groups'] = $row2->group; $_SESSION['_' . $row1->group_id]['sales'] = $row2->sales; $_SESSION['_' . $row1->group_id]['ticket'] = $row2->ticket; } // end } $_SESSION['user_type'] = $re->user_is_admin; $ip = $this->get_client_ip(); // get user ip //sql query DB::table('user_login')->where('user_id', $re->id)->update(['user_logout_time' => DATE('Y-m-d H:i:s'), 'user_login_status' => 0]); //sql query end //sql query start $last_id = DB::table('user_login')->insertGetId(['user_id' => $re->id, 'user_login_time' => DATE('Y-m-d H:i:s'), 'user_session' => 1, 'user_login_status' => 1, 'ip' => $ip]); //add to user_login table //sql query end $_SESSION['user_login_id'] = $last_id; $log->add_log(" ", " ", "User Login"); // add a log //sql query $query = DB::table('s_admin')->select('*')->where('id', 1)->get(); //sql query end foreach ($query as $result) { $_SESSION['per_inquiry'] = $result->Inquiry; $_SESSION['per_sales'] = $result->Sales; $_SESSION['per_tickets'] = $result->Tickets; } $_SESSION['login_user'] = $username; return redirect('home'); } $log->add_log("logging attempt ", $ip, $username); return "0"; }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $data = $request->all(); session_start(); $loguser = $_SESSION['user_id']; $data['modified_by'] = $loguser; App\category::find($id)->update($data); $log = new Log(); $log->add_log("category", $_POST['id'], "update"); // add a log return redirect('category'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { session_start(); $data = $request->all(); $data['modified_by'] = $_SESSION['user_id']; App\ticket_category::find($id)->update($data); $log = new Log(); $log->add_log("ticket_category", $id, "update"); // add a log return redirect('ticket_category'); }