public function unpaidPayeePayments() { $query = PayeePayment::unpaid(); $query->with(["payee", "client"]); $query->join(User::table() . " as user", 'user.code', '=', PayeePayment::table() . '.payee_code'); $filters = Request::get('_filter'); if (count($filters)) { foreach ($filters as $key => $filter) { list($field, $value) = explode(':', $filter); if (strpos($filter, 'search') !== false) { $query->where(function ($query) use($value) { $query->orWhere("user.name", "like", '%' . $value . '%'); }); } else { $this->attachWhere($query, $value, $field); } } } $this->attachSort(new PayeePayment(), $query); $count = $this->getQueryCount($query); $offset = $this->attachOffset($query); $limit = $this->attachLimit($query); $items = $query->get([PayeePayment::table() . '.*']); return Response::json(array('model' => "PayeePayment", 'items' => $items->toApiArray(), 'offset' => $offset, 'limit' => $limit, 'count' => $count), 200, [], JSON_NUMERIC_CHECK); }
public static function apiQuery() { $query = self::query(); if (!Auth::user()->isAdmin()) { $query->where(PayeeCompany::table() . '.company_id', '=', Auth::user()["company_id"]); } $query->join(User::table() . " as user", 'user.id', '=', 'user_id'); return $query; }
public function __construct() { $this->id = 'UserGrid'; $this->source = User::table(); $this->endpoint = __HOME__ . '/user/grid'; $this->columns = ['id' => ['visible' => false], 'username' => ['label' => _('Username')], 'cognome' => ['label' => _('Surname')], 'nome' => ['label' => _('Name')], 'role' => ['label' => _('Role')], 'command' => ['label' => _('Command'), 'field' => 'id', 'html' => '<a href="' . __HOME__ . '/user/detail/id/{?}" class="btn btn-xs btn-success">' . _('View') . '</a> ' . '<a href="' . __HOME__ . '/user/modify/id/{?}" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-pencil"></i>' . _('Edit') . '</a> ' . '<a href="' . __HOME__ . '/user/delete/id/{?}" class="btn btn-xs btn-danger"><i class="glyphicon glyphicon-trash"></i>' . _('Delete') . '</a>']]; /* * Onclik open item detail */ $this->events = ['row.click' => 'window.location = "' . __HOME__ . '/user/detail/id/"+id;']; }
/** * {inheritdoc} */ public static function show($where = [], $sort = false) { $db = static::db(); $join_primary = User::primary(); $sql = sprintf('SELECT a.*, b.username, b.email, b.aktif FROM %1$s a LEFT JOIN %2$s b USING (%3$s)', static::table(), User::table(), $join_primary); if (!empty($where)) { if (isset($where[static::$primary])) { $where['a.' . static::$primary] = $where[static::$primary]; unset($where[static::$primary]); } if (isset($where[$join_primary])) { $where['b.' . $join_primary] = $where[$join_primary]; unset($where[$join_primary]); } $where = $db->_parseWhere($where); $sql .= ' %s'; } return $db->query($sql, $where); }
public function fb_sign_in() { if (!(Fb::login() && ($me = Fb::me()) && (isset($me['name']) && ($name = $me['name']) && (isset($me['email']) && ($email = $me['email'])) && (isset($me['id']) && ($id = $me['id']))))) { return redirect_message(array(), array('_flash_message' => 'Facebook 登入錯誤,請通知程式設計人員!(1)')); } if (!($user = User::find('one', array('conditions' => array('uid = ?', $id))))) { if (!User::transaction(function () use(&$user, $id) { return verifyCreateOrm($user = User::create(array_intersect_key(array('uid' => $id), User::table()->columns))); })) { return redirect_message(array(), array('_flash_message' => 'Facebook 登入錯誤,請通知程式設計人員!(2)')); } } $user->name = $name; $user->login_count += 1; $user->logined_at = date('Y-m-d H:i:s'); if (!User::transaction(function () use($user) { return $user->save(); })) { return redirect_message(array(), array('_flash_message' => 'Facebook 登入錯誤,請通知程式設計人員!(3)')); } Session::setData('user_id', $user->id); return redirect_message(func_get_args(), array('_flash_message' => '使用 Facebook 登入成功!')); }
/** * View group profile * * @param Request $request * @param $matches * @return mixed|string */ public function group_profile(Request $request, $matches) { \GroupPermission::updatePermissionsList(); try { /** @var \Group $user */ $group = \Group::find($matches['id']); $perms = $group->getPermissions(); } catch (\Exception $e) { $this->error404($request); return; } if ($request->isMethod('post')) { // Moving users $new_group = intval($request->get('new_group', $group->id)); if ($new_group != $group->id) { $update = ['group_id' => $new_group]; \User::table()->update($update, ['group_id' => $group->id]); } // Saving permissions foreach ($perms as $key => $val) { $new_val = intval($request->get('perm_' . $key)); $perms[$key] = $new_val; } // Saving data $new_name = $request->get('name'); $new_icon = $request->get('icon'); if ($new_name != $group->name) { $group->name = $new_name; } if ($new_icon != $group->icon) { $group->icon = $new_icon; } if ($group->save() && $perms->save()) { \GroupPermission::updatePermissionsList(); return static::json_response(['status' => $this->lang->translate('form.saved'), 'class' => 'success']); } else { return static::json_response(['status' => $this->lang->translate('form.failed'), 'class' => 'error']); } } // Filter groups $groups = \Group::all(); $groups = array_map(function ($i) { return $i->to_array(); }, $groups); return $this->view->render('users/group_profile.twig', ['title' => $this->lang->translate('user.group.name', $group->name), 'group' => $group->to_array(), 'perms' => $perms, 'groups' => $groups]); }
public function savePayees($rpf) { // $payments = RoyaltyPayment::groupedByPayeeCode($rpf->id)->get(); // foreach ($payments as $payment) { // $user = User::where('code', '=', $payment->payee_code)->first(); // if ($user == null) { // $user = User::create(["name" => $payment->payee_name, // "deleted_at" => null, // "email" => null, // "code" => $payment->payee_code, // "company_id" => $rpf->company_id, // "password" => $payment->payee_code, // "type" => "payee"]); // PayeeCompany::create(["user_id" => $user->id, "code" => $user->code, "company_id" => $rpf->company_id]); // } else { // if (PayeeCompany::findByUserAndCompany($user->id, $rpf->company_id) == null) // PayeeCompany::create(["user_id" => $user->id, "code" => $user->code, "company_id" => $rpf->company_id]); // } // } DB::connection()->getpdo()->exec('INSERT IGNORE INTO ' . User::table() . '(`name`, `deleted_at`, `email`, `code`, `company_id`, `password`, `type`) SELECT `payee_name`, NULL, NULL, `payee_code`, ' . $rpf->company_id . ', ENCRYPT(`payee_code`), \'payee\' FROM ' . RoyaltyPayment::table() . ' WHERE `royalty_payment_file_id` = ' . $rpf->id . ' AND `payee_payment_id` IS NULL GROUP BY `payee_code` ORDER BY `payee_code`'); DB::connection()->getpdo()->exec('INSERT IGNORE INTO ' . PayeeCompany::table() . '(`user_id`, `code`, `company_id`) SELECT u.id, `payee_code`, ' . $rpf->company_id . ' FROM ' . RoyaltyPayment::table() . ' as rp LEFT JOIN ' . User::table() . ' as u on rp.payee_code = u.code WHERE `royalty_payment_file_id` = ' . $rpf->id . ' AND `payee_payment_id` IS NULL GROUP BY `payee_code` ORDER BY `payee_code`'); }
public static function getListUsers($table) { self::$table = $table; return parent::all(); }
public function testJoinManyMany() { $b = new SelectBuilder(); $b->root('Article'); $b->with('readers')->select(['*']); $components = $b->build(); $jc = array(new JoinClause('articles', '_'), (new JoinClause('articles_USERS', 'readers_m', JoinClause::LEFT))->on('_', 'id', 'readers_m', 'article_id'), (new JoinClause('USERS', 'readers', JoinClause::LEFT))->on('readers_m', 'user_id', 'readers', 'id')); $columns = array('_' => ['columns' => Article::table()->getColumns(), 'resAlias' => ''], 'readers' => ['columns' => User::table()->getColumns(), 'resAlias' => 'readers']); $this->assertEquals($jc, $components['from']); $this->assertEquals($columns, $components['columns']); }
} else { $matched = array_first($perms, function ($i, $perm) use($feature) { return fnmatch($perm, $feature, FNM_NOESCAPE | FNM_PATHNAME | FNM_CASEFOLD); }); return (bool) ($allBut ^ !!$matched); } } function emailRecipient() { $self = $this; return (string) Event::result('user.recipient', $this, function ($result) use($self) { if (strpos($result, $self->email) === false) { return 'a string without the actual e-mail address'; } }); } function resetHash($days = null, $hash = null) { $args = func_num_args(); if ($args === 0) { $date = date('d'); return md5($this->id . '-' . \Config::get('application.key') . '-' . $date); } else { $date = date('d', strtotime('+' . $days . ' day')); $value = md5($this->id . '-' . \Config::get('application.key') . '-' . $date); return $args === 1 ? $value : $value === $hash; } } } User::$table = \Config::get('vanemart::general.table_prefix') . User::$table; User::$fields = userFields(User::$fields, 'user');
<?php $tables_to_clear = array(User::table(), Customer::table(), Product::table(), Cart::table(), Address::table(), UserLog::table(), Account::table(), AccountHistory::table()); $db = Sdb::getDb(); foreach ($tables_to_clear as $table) { $db->exec("TRUNCATE TABLE {$table}"); } if (_get('exit')) { echo '<script src="static/hide.js"></script>'; echo '<div class="conclusion pass">All Clear!</div>'; exit; }
error_reporting(E_ALL); define("ROOT", '..'); require ROOT . "/ini.php"; require ROOT . "/lib/activerecord.php"; require ROOT . "/lib/persistance.php"; ActiveRecord::$db = new PDO($ini['db']); class User implements persistance { static $table; function gul_assalam() { print $this->name . " : Aya golna slam3likom <br />"; } function insert() { return self::$table->insert($this); } static function select($options = NULL) { return self::$table->select($options); } } User::$table = new ActiveRecord("users", "User"); $users = User::select(); foreach ($users as $u) { $u->gul_assalam(); $u->name = "Changed my name"; $u->insert(); } $users = User::select(); print_r($users);
public static function apiQuery() { $query = self::query(); if (!Auth::user()->isAdmin()) { $query->where(User::table() . '.company_id', '=', Auth::user()["company_id"]); } return $query; }