Revize 511
Přidáno uživatelem Jiří Sviták před téměř 15 roky(ů)
freenetis/trunk/kohana/application/models/bank_transfer.php | ||
---|---|---|
ba.account_nr, ba.bank_nr,
|
||
ba.name,
|
||
t.datetime, t.text, t.amount,
|
||
bt.variable_symbol
|
||
bt.variable_symbol, bt.transfer_id
|
||
FROM bank_transfers bt
|
||
LEFT JOIN bank_accounts ba ON ba.id = IF (bt.origin_id = $ba_id, bt.destination_id, bt.origin_id)
|
||
LEFT JOIN transfers t ON t.id = bt.transfer_id
|
||
... | ... | |
ba.account_nr, ba.bank_nr, ba.name
|
||
FROM transfers srct
|
||
JOIN accounts a ON a.id = srct.origin_id
|
||
AND srct.member_id = 0
|
||
AND (srct.member_id = 0 OR srct.member_id IS NULL)
|
||
AND a.account_attribute_id =".Account_attribute_Model::$member_fees."
|
||
JOIN bank_transfers bt ON bt.transfer_id = srct.id
|
||
LEFT JOIN bank_accounts ba ON ba.id = bt.origin_id
|
||
... | ... | |
public function get_bank_transfer($trans_id)
|
||
{
|
||
return self::$db->query("SELECT
|
||
oba.id AS oba_id,oba.name AS oba_name,
|
||
oba.id AS oba_id, oba.name AS oba_name,
|
||
CONCAT(oba.account_nr, '/', oba.bank_nr) AS oba_number,
|
||
m.id AS oba_member_id, m.name AS oba_member_name,
|
||
dba.name AS dba_name,
|
||
dba.id AS dba_id, dba.name AS dba_name,
|
||
CONCAT(dba.account_nr, '/', dba.bank_nr) AS dba_number,
|
||
m2.id AS dba_member_id, m2.name AS dba_member_name,
|
||
t.id, t.origin_id, t.destination_id, t.datetime, t.creation_datetime, t.text, t.amount,
|
||
bt.id AS bt_id, bt.variable_symbol, bt.constant_symbol, bt.specific_symbol,
|
||
bt.origin_id AS bt_origin_id, bt.destination_id AS bt_destination_id
|
||
bt.id AS bt_id, bt.variable_symbol, bt.constant_symbol, bt.specific_symbol
|
||
FROM transfers t
|
||
JOIN bank_transfers bt ON t.id = bt.transfer_id
|
||
LEFT JOIN bank_accounts oba ON oba.id = bt.origin_id
|
freenetis/trunk/kohana/application/controllers/settings.php | ||
---|---|---|
$this->form->set_attr('class', 'form_class')->set_attr('method', 'post');
|
||
$this->form->group('')->label(url_lang::lang('texts.Gateway'));
|
||
$this->form->input('gateway')->label(url_lang::lang('texts.Gateway IP address').':')->value($this->setting->gateway);
|
||
$this->form->input('website_after_redirection')->label(url_lang::lang('texts.Website after redirection').':')->value($this->setting->website_after_redirection);
|
||
$this->form->textarea('website_after_redirection')->label(url_lang::lang('texts.Website after redirection').':')->rows(5)->cols(100)->value(addslashes($this->setting->website_after_redirection));
|
||
$this->form->textarea('contact')->label(url_lang::lang('texts.Contact list on redirect page').':')->rows(5)->cols(100)->value(addslashes($this->setting->contact));
|
||
$this->form->textarea('info')->label(url_lang::lang('texts.Information for members (how to log in)').':')->rows(5)->cols(100)->value(addslashes($this->setting->info));
|
||
$this->form->textarea('unknown_device')->label(url_lang::lang('texts.Unknown device text').':')->rows(5)->cols(100)->value(addslashes($this->setting->unknown_device));
|
freenetis/trunk/kohana/application/controllers/transfers.php | ||
---|---|---|
// bt has to be first set to null, transfer need not to be of bank type
|
||
$bt = null;
|
||
$bt_model = ORM::factory('bank_transfer')->where('transfer_id', $transfer->id)->find();
|
||
if ($transfer->oa_id == $member_fees->id && is_object($bt_model) && $bt_model->id != 0)
|
||
if ($bt_model->id)
|
||
$bt = $bt_model->get_bank_transfer($transfer_id);
|
||
$headline = url_lang::lang('texts.Detail of transfer number').' '.$transfer->id;
|
||
$view = new View('main');
|
freenetis/trunk/kohana/application/controllers/redirect.php | ||
---|---|---|
// no reason to redirect, this shouldn't happen
|
||
else
|
||
{
|
||
// so if there is no reason, then member is from these pages redirected to defined website
|
||
url::redirect($this->setting->website_after_redirection);
|
||
$content = $this->setting->website_after_redirection;
|
||
}
|
||
// engineer of user's device, owner of ip address - if available
|
||
if ($ip_address->id != 0)
|
freenetis/trunk/kohana/application/controllers/bank_transfers.php | ||
---|---|---|
$grid->order_field('name')->label(url_lang::lang('texts.Counteraccount'));
|
||
$grid->order_field('account_nr')->label(url_lang::lang('texts.Account number'));
|
||
$grid->order_field('bank_nr')->label(url_lang::lang('texts.Bank code'));
|
||
$grid->order_field('text')->label(url_lang::lang('texts.Text'));
|
||
//$grid->order_field('text')->label(url_lang::lang('texts.Text'));
|
||
$grid->order_field('variable_symbol')->label(url_lang::lang('texts.VS'));
|
||
$grid->order_field('amount')->label(url_lang::lang('texts.Amount'));
|
||
if ($this->acl_check_view('Accounts_Controller', 'transfers'))
|
||
$grid->action_field('transfer_id') ->label(url_lang::lang('texts.Transfer'))->url(url_lang::base().'transfers/show')->action(url_lang::lang('texts.Show'));
|
||
$grid->datasource($bts);
|
||
|
||
$view = new View('main');
|
freenetis/trunk/kohana/application/views/transfers_show.php | ||
---|---|---|
<td><?php echo html::anchor(url_lang::base().'transfers/show_by_account/'.$transfer->da_id, $transfer->da_name); ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Date and time') ?></th>
|
||
<td><?php echo $transfer->datetime; ?></td>
|
||
<th><?php echo url_lang::lang('texts.Date and time') ?></th>
|
||
<td><?php echo $transfer->datetime; ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Date and time of creation') ?></th>
|
||
<td><?php echo $transfer->creation_datetime; ?></td>
|
||
<th><?php echo url_lang::lang('texts.Date and time of creation') ?></th>
|
||
<td><?php echo $transfer->creation_datetime; ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Text') ?></th>
|
||
<td><?php echo $transfer->text; ?></td>
|
||
<th><?php echo url_lang::lang('texts.Text') ?></th>
|
||
<td><?php echo $transfer->text; ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Amount') ?></th>
|
||
<td><?php echo number_format((float)$transfer->amount, 2, ',', ' ').' '.$this->setting->currency ?></td>
|
||
<th><?php echo url_lang::lang('texts.Amount') ?></th>
|
||
<td><?php echo number_format((float)$transfer->amount, 2, ',', ' ').' '.$this->setting->currency ?></td>
|
||
</tr>
|
||
<?php if (isset($transfer->previous_transfer_id)) { ?>
|
||
<tr>
|
||
... | ... | |
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Bank account id') ?></th>
|
||
<td><?php echo html::anchor(url_lang::base().'bank_transfers/show_by_bank_account/'.$bt->bt_origin_id, $bt->bt_origin_id) ?></td>
|
||
<td><?php echo empty($bt->oba_id) ? '' : html::anchor(url_lang::base().'bank_transfers/show_by_bank_account/'.$bt->oba_id, $bt->oba_id) ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Account name') ?></th>
|
||
... | ... | |
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Bank account id') ?></th>
|
||
<td><?php echo html::anchor(url_lang::base().'bank_transfers/show_by_bank_account/'.$bt->bt_destination_id, $bt->bt_destination_id) ?></td>
|
||
<td><?php echo empty($bt->dba_id) ? '' : html::anchor(url_lang::base().'bank_transfers/show_by_bank_account/'.$bt->dba_id, $bt->dba_id)?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Account name') ?></th>
|
Také k dispozici: Unified diff
Pridano zobrazeni podrobnosti pro bankovni platbu, stranka po presmerovani.