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;
}
