Revize 529
Přidáno uživatelem Jiří Sviták před asi 15 roky(ů)
| freenetis/trunk/kohana/application/models/transfer.php | ||
|---|---|---|
|
return self::$db->query("SELECT
|
||
|
t.id, IF(t.destination_id = $account_id, FALSE, TRUE) AS trans_type,
|
||
|
t.text, t.amount, t.datetime,
|
||
|
a.name
|
||
|
a.name,
|
||
|
IF(t.destination_id = $account_id, bt.variable_symbol, NULL) AS variable_symbol
|
||
|
FROM transfers t
|
||
|
LEFT JOIN accounts a ON a.id = IF(t.origin_id = $account_id, t.destination_id, t.origin_id)
|
||
|
LEFT JOIN transfers pt ON pt.id = t.previous_transfer_id
|
||
|
LEFT JOIN bank_transfers bt ON pt.id = bt.transfer_id
|
||
|
$where
|
||
|
ORDER BY $order_by $order_by_direction
|
||
|
LIMIT $limit_from, $limit_results"
|
||
| freenetis/trunk/kohana/application/controllers/transfers.php | ||
|---|---|---|
|
$grid->order_field('datetime')->label(url_lang::lang('texts.Date and time'));
|
||
|
$grid->order_field('amount')->label(url_lang::lang('texts.Amount'));
|
||
|
$grid->order_field('text')->label(url_lang::lang('texts.Text'));
|
||
|
$grid->order_field('variable_symbol')->label(url_lang::lang('texts.VS'));
|
||
|
if ($this->acl_check_view('Accounts_Controller', 'transfers', $account->member_id))
|
||
|
$grid->action_field('id')->label(url_lang::lang('texts.Transfer'))->url(url_lang::base().'transfers/show')->action(url_lang::lang('texts.Show'));
|
||
|
// transfers should not be edited
|
||
Také k dispozici: Unified diff
Vypis prevodu na uctu clena u prichozich identifikovanych plateb vypisuje i variabilni symbol.