public function batal_bergabung($id)
{
$iduser = Users::where('id', '=', Session::get('user_id'))->first()->id;
$slug = Acara::where('id', '=', $id)->first()->slug;
UserEvent::where('id_user', '=', $iduser)->where('id_acara', '=', $id)->delete();
return Redirect::to('/acara/' . $slug);
}
/**
* Store a newly created resource in storage.
* POST
* @return Response
*/
public function store()
{
$uid = Input::get('uid');
$following_uid = Input::get('following_uid');
$Following = new Following();
$Following->following_uid = $following_uid;
$Following->uid = $uid;
$Following->save();
return Users::where('uid', $uid)->get();
}
/**
*
* @param string $field field in table to check. Default is account
* @return boolean
*/
public static function isExistedUser($field = 'account')
{
$data = Input::all();
$user = Users::where($field, $data["{$field}"])->first();
if ($user) {
return true;
} else {
return false;
}
}
public function check($fbid)
{
$check = Users::where('fbid', '=', $fbid)->count();
if (empty($check)) {
return FALSE;
// Users::create($data);
} else {
return TRUE;
// Users::where('fbid', '=', $fbid)->update($data);
}
}
public function login($language)
{
// Définition de la langue :
if (!$this->setupLanguage($language)) {
App::abort(404);
}
try {
$languages = Language::where('_url', '=', $language)->firstOrFail();
$page = Pages::where('_language', $languages->_id)->where("_name", "=", "user/login")->get()->first();
} catch (Exception $e) {
App::abort(500);
}
// Redirection de l'utilisateur s'il est déjà connecté :
if (Auth::check()) {
return Redirect::to(URL::to($language . '/home'));
}
// Variables :
// Details :
$data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
// Message :
$message = "";
// Inputs :
$login = "";
$password = "";
// Envoi du formulaire de connexion :
if (count(Input::all()) > 0) {
// récupération des inputs :
$login = htmlentities(Input::get('your-login'));
$password = htmlentities(Input::get('your-password'));
// validation des formulaire :
$validator = Validator::make(array('email' => $login, 'password' => $password), array('email' => 'required|email', 'password' => 'required'), array('email.required' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_RQ'), 'email.email' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_INV'), 'password.required' => Lang::get('libelle.CONNEXION_ERROR_PASSWORD_RQ')));
// retour en cas d'erreur :
if ($validator->fails()) {
$message = $validator->messages();
} else {
// connexion en cas de succès :
$auth = Users::where('_email', '=', $login)->where('_password', '=', md5($password))->first();
// si utilisateur trouvé, redirection :
if ($auth) {
Auth::login($auth);
Auth::user()->_ipLastConnection = Request::getClientIp(true);
Auth::user()->_dateLastConnection = date("Y-m-d H:i:s");
Auth::user()->save();
return Redirect::to(URL::to($language . '/home'));
} else {
$message = Lang::get("libelle.CONNEXION_ERROR");
}
}
}
// Renvoi de la vue avec les message(s) d'erreurs :
$page = $this->layout->content = View::make('pages.users.login', array("data" => $data, "page" => $page, "message" => $message));
return Response::make($page, '200');
}
public function changeName()
{
$name = Input::get('name');
$uid = Session::get('uid');
$user = Users::where('uid', $uid)->first();
if ($user) {
$user->username = $name;
$user->save();
return json_encode(array('status' => 'success'));
} else {
return json_encode(array('status' => 'failed'));
}
}
/**
* Performs an authentication
* @param array
* @return Nette\Security\Identity
* @throws Nette\Security\AuthenticationException
*/
public function authenticate(array $credentials)
{
if (count($credentials) == 1) {
$row = $this->users->where('hash', $credentials[0])->fetch();
if (!$row) {
throw new NS\AuthenticationException("User not found.", self::IDENTITY_NOT_FOUND);
}
} else {
list($username, $password) = $credentials;
$row = $this->users->where('username', $username)->fetch();
if (!$row) {
throw new NS\AuthenticationException("User '{$username}' not found.", self::IDENTITY_NOT_FOUND);
}
if ($row->password !== $this->users->calculateHash($password)) {
throw new NS\AuthenticationException("Invalid password.", self::INVALID_CREDENTIAL);
}
$this->users->get($row->id)->update(array('last_login' => new DibiDateTime(), 'last_ip' => $_SERVER['REMOTE_ADDR']));
}
$data = $row->toArray();
unset($data['password']);
return new NS\Identity($row->id, $row->role, $data);
}
public function getAuth()
{
$username = Input::get('username');
$pass = Input::get('password');
$password = md5($pass);
$cek = Users::where('username', '=', $username)->where('password', '=', $password)->first();
if (empty($cek)) {
Session::flash('message', 'Wrong');
return Redirect::to('/');
} else {
Session::put('username', $username);
Session::put('employee_id', $cek->employee_id);
Session::flash('message', 'Login was successfully, Welcome ' . $username);
return Redirect::to('dashboard');
}
}
public function get_data_for_dashboard()
{
$userid = Users::where('id', '=', Session::get('user_id'))->first()->id;
$data['user'] = Users::find(Session::get('user_id'));
$data['komunitas'] = Komunitas::orderBy('avg_rate', 'DESC')->take(5)->get();
$data['rekomen'] = $this->predict->recommendation($userid);
$data['rating'] = $this->rating->count_rate_row_by_id($userid);
$data['cek'] = $this->predict->has_recommendation($userid);
$data['rand'] = Komunitas::orderByRaw("RAND()")->take(5)->get();
// $data['test'] = $this->komunitas->get_recommendation($userid);
// $data['komunitas'] = $this->komunitas->get_initial_recommendation();
$data['acara'] = Acara::where('tanggal', '>=', DB::raw('CURDATE()'))->take(4)->orderBy('tanggal', 'ASC')->get();
// $count = Komunitas::where('id_kategori', '=', 1)->count();
$allkom = $this->predict->has_recommendation($userid);
//var_dump($allkom);
//var_dump($data['test']);
return View::make('dashboard', $data);
}
function edit($id)
{
//$user = $this->Users_model->get_user_by_id($id);
$userModel = new Users();
$user = $userModel->where('idusers', $id)->get();
$form_rules = array(array('field' => 'login', 'label' => $this->lang->line('login'), 'rules' => 'required|max_length[16]'), array('field' => 'password', 'label' => $this->lang->line('password'), 'rules' => 'required|max_length[16]|matches[confirm]'), array('field' => 'name', 'label' => $this->lang->line('name'), 'rules' => 'required|max_length[32]'), array('field' => 'type', 'label' => $this->lang->line('user_type'), 'rules' => 'required'));
$this->form_validation->set_rules($form_rules);
if ($this->form_validation->run() == FALSE) {
$this->load->view('template/editUser', array('user' => $user, 'action' => 'edit/' . $id));
} else {
$user = new Users();
$user->idusers = $_POST['idusers'];
$user->login = $_POST['login'];
$user->password = $_POST['password'];
$user->name = $_POST['name'];
$user->type = $_POST['type'];
$user->language = $_POST['language'];
$user->edit();
redirect('/admin/user');
}
}
public function store()
{
$data = Input::all();
$validator = FEUsersHelper::validateLoginInfo();
if ($validator->fails()) {
$messages = $validator->messages();
echo json_encode($messages);
} else {
$user = Users::where('account', $data['account'])->get()->first();
if (!$user) {
echo "fail: Not exists user";
} else {
$user = Users::where('account', $data['account'])->where('password', md5($data['password']))->first();
if (!$user) {
echo "fail: incorrect password";
} else {
Session::put('user', $user);
echo "success";
}
}
}
}
public function signin(array $params = array())
{
/**
* @Desc: needs two params : email + password
* @Desc2: Optional params : keepAlive
*/
/*
* TODO: Confirm the system.
* TODO: Error checking and Flash Session
*/
$email = $params["email"];
$password = $params["'password'"];
$u = \Users::where("email", $email)->first();
// STEP 2: Compare
$compare = Criptography::compare($password, $u["password"]);
if ($compare) {
Session::set("user_id", $u["id"]);
Session::set("email", $u["email"]);
// STEP 3: SET INFINITE SESSION
if (isset($params["keepAlive"])) {
$this->setRememberMe();
}
}
}
public function batal_bergabung($id)
{
$iduser = Users::where('id', '=', Session::get('user_id'))->first()->id;
$slug = Komunitas::where('id', '=', $id)->first()->slug;
KomunitasMember::where('id_user', '=', $iduser)->where('id_komunitas', '=', $id)->delete();
return Redirect::to('/komunitas/' . $slug);
}
function postDoblast()
{
$rules = array('subject' => 'required', 'message' => 'required|min:10', 'groups' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->passes()) {
if (!is_null(Input::get('groups'))) {
$groups = Input::get('groups');
for ($i = 0; $i < count($groups); $i++) {
if (Input::get('uStatus') == 'all') {
$users = Users::all()->where('group_id', '=', $groups[$i]);
} else {
$users = Users::where('active', '=', Input::get('uStatus'))->where('group_id', '=', $groups[$i]);
}
$count = 0;
foreach ($users as $row) {
$to = $row->email;
$subject = Input::get('subject');
$message = Input::get('message');
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: ' . CNF_APPNAME . ' <' . CNF_EMAIL . '>' . "\r\n";
mail($to, $subject, $message, $headers);
$count = ++$count;
}
}
return Redirect::to('config/blast')->with('messagetext', 'Total ' . $count . ' Message has been sent')->with('msgstatus', 'success');
}
return Redirect::to('config/blast')->with('messagetext', 'No Message has been sent')->with('msgstatus', 'info');
} else {
return Redirect::to('config/blast')->with('messagetext', 'The following errors occurred')->with('msgstatus', 'error')->withErrors($validator)->withInput();
}
}
public function getDriverById()
{
$driverId = Input::get('driver_id');
try {
$driver = Driver::find($driverId);
$email = Users::where('id', '=', $driver->user_id)->pluck('email');
$driver->email = $email;
$result = array('success' => true, 'driver' => $driver);
} catch (Exception $ex) {
\Log::error(__METHOD__ . ' | error :' . print_r($ex, 1));
$result = array('success' => false, 'driver' => null);
}
return $result;
}
private function cek_email_valid($email)
{
$feedback = array();
//cek email sudah benar
$is_email = false;
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$is_email = true;
}
if ($is_email) {
$sudah_dipakai = Users::where('email', '=', $email)->count();
$feedback['status'] = 'sukses';
//cek email sudah terpakai atau belum
if ($sudah_dipakai) {
$feedback['status'] = 'gagal';
$feedback['issue'] = 'email_terpakai';
}
} else {
$feedback['status'] = 'gagal';
$feedback['issue'] = 'bukan_email';
}
return $feedback;
}
public function Info($user)
{
$this_user = Users::where('account', $user)->first();
if ($this_user) {
return View::make('frontend/profile/info')->with('user', $this_user);
} else {
return 'ko có user ' . $user;
}
}
public function getSave()
{
$id = Input::get('id');
$employee_id = Input::get('employee_id');
$username = Input::get('username');
$pass1 = Input::get('password1');
$pass2 = Input::get('password2');
if ($id) {
$exist_username = Users::where('username', '=', $username)->where('id', '!=', $id)->first();
if (!empty($exist_username)) {
Session::flash('message', 'Sorry, Username was exists');
return Redirect::to('users/edit/' . $id);
} else {
if ($pass1 != $pass2) {
Session::flash('message', 'Sorry, Password not same');
return Redirect::to('users/edit/' . $id);
} else {
if ($employee_id) {
$user = Users::find($id);
$user->username = $username;
$user->employee_id = $employee_id;
$user->password = md5($pass1);
$user->save();
Session::flash('message', 'The records are updated successfully');
return Redirect::to('users');
} else {
$user = Users::find($id);
$user->username = $username;
$user->password = md5($pass1);
$user->save();
Session::flash('message', 'The records are updated successfully');
return Redirect::to('users');
}
}
}
} else {
$exist_username = Users::where('username', '=', $username)->first();
if (!empty($exist_username)) {
Session::flash('message', 'Sorry, Username was exists');
return Redirect::to('users/add');
} else {
if ($employee_id) {
$exists_employee = Users::where('employee_id', '=', $employee_id)->first();
if (!empty($exists_employee)) {
Session::flash('message', 'Sorry, Employee was exists');
return Redirect::to('users/add');
} else {
if ($pass1 != $pass2) {
Session::flash('message', 'Sorry, Password not same');
return Redirect::to('users/add');
} else {
$user = new Users();
$user->username = $username;
$user->employee_id = $employee_id;
$user->password = md5($pass1);
$user->save();
Session::flash('message', 'The records are inserted successfully');
return Redirect::to('users');
}
}
} else {
if ($pass1 != $pass2) {
Session::flash('message', 'Sorry, Password not same');
return Redirect::to('users/add');
} else {
$user = new Users();
$user->username = $username;
$user->password = md5($pass1);
$user->save();
Session::flash('message', 'The records are inserted successfully');
return Redirect::to('users');
}
}
}
}
}
public function updateUserInfo()
{
if (func_num_args() > 0) {
$data = func_get_arg(0);
$where = func_get_arg(1);
try {
$result = Users::where('id', $where)->update($data);
} catch (\Exception $e) {
return $e->getMessage();
}
if ($result) {
return $result;
} else {
return 0;
}
} else {
throw new Exception('Argument Not Passed');
}
}
public static function get_id($user)
{
$user = Users::where('username', '=', $user)->first();
return $user->id;
}
$pass = $app->request->post('password');
$password = hash('sha512', $pass);
$email = $app->request->post('email');
if ($username == "") {
$app->flash('error', 1);
$app->redirect($settings->base_url . '/admin/users/new');
}
if ($email == "" or !filter_var($email, FILTER_VALIDATE_EMAIL)) {
$app->flash('error', 2);
$app->redirect($settings->base_url . '/admin/users/new');
}
$redirect = $settings->base_url . '/admin/users';
if (!empty($pass)) {
Users::where('id', '=', $id)->update(array('username' => $username, 'password' => $password, 'email' => $email));
} else {
Users::where('id', '=', $id)->update(array('username' => $username, 'email' => $email));
}
$app->render('success.html', array('redirect' => $redirect));
})->conditions(array('id' => '\\d+'));
$app->get('/users/delete/:id', $authenticate($app, $settings), function ($id) use($app) {
$app->render('a_user_delete.html', array('user_id' => $id));
})->conditions(array('id' => '\\d+'));
$app->delete('/users/delete/:id', $authenticate($app, $settings), function ($id) use($app, $settings) {
Users::destroy($id);
$redirect = $settings->base_url . '/admin/users';
$app->render('success.html', array('redirect' => $redirect));
})->conditions(array('id' => '\\d+'));
$app->get('/users/new/', $authenticate($app, $settings), function () use($app) {
$flash = $app->view()->getData('flash');
$error = isset($flash['error']) ? $flash['error'] : '';
$app->render('a_user_new.html', array('error' => $error));
