FreenetIS

'error - wrong arguments' => 'Chyba - špatné argumenty',

'error - wrong data' => 'Chyba - špatná data',

'error - amount has to be positive' => 'Chyba - částka musí být kladná.',

'error - cannot add message' => 'Chyba - nelze přidat zprávu.',

'error - cannot delete bank statement' => 'Chyba - nelze smazat bankovní výpis.',

'error - cannot load intelligent selection' => 'Chyba - nelze načíst inteligentní výběr',

'error - cannot update message' => 'Chyba - nelze upravit zprávu.',

'execution time' => 'Doba provádění',

'executive counsil' => 'Správní rada',

'expenditure-earning' => 'Výdej-Příjem',

'export of registration' => 'Export přihlášky',

'export to xls' => 'Exportovat do XLS',

'export to csv (utf-8)' => 'Exportovat do CSV (utf-8)',

'ignore whitelist' => 'Ignorovat whitelist',

'import dhcp export from mikrotik' => 'Import exportu DHCP z Mikrotiku',

'import has been successfully finished' => 'Import byl úspěšně dokončen.',

'import new invoice' => 'Import nové faktury',

'import private contact' => 'Importovat soukromé kontakty',

'import contact from server funanbol' => 'Importovat kontakty ze serveru Funanbol',

'in hours' => 'V hodinách',

'inactive' => 'Neaktivní',

'inbound' => 'Příchozí',

'incoming member payment' => 'Příchozí členské příspěvky',

'incoming member payment in the period' => 'Příchozí členské příspěvky v období',

'increase of members' => 'Přírůstek členů',

'specific symbol' => 'Specifický symbol',

'start amount' => 'Počáteční částka',

'static ip' => 'Statická IP',

'state' => 'Stav',

'statement' => 'Výpis',

'statement number' => 'Číslo výpisu',

'suffix has to start with slash character and has to end with slash character' => 'Přípona musí začínat lomítkem a musí končit lomítkem.',

'suggest amount' => 'Navrhovaná částka',

'sum' => 'Součet',

'supplier' => 'Dodavatel',

'suppliers account' => 'Účet dodavatelů',

'surname' => 'Příjmení',

GROUP BY q2.aid

) q3

SET a.balance = (q3.inbound - q3.outbound)

");

}

class Transfer_Model extends ORM

{

protected $belongs_to = array('origin' => 'account', 'destination' => 'account');

}

else

{

$transfer_model = new Transfer_Model();

$last_datetime = $transfer_model->find_last_transfer_datetime_by_type(Transfer_Model::$deduct_member_fee);

if ($last_datetime)

$db->transaction_start();

// deleting old deduct transfer of member

$account->delete_deduct_transfers_of_account($account_id);

$max_date = date('Y-m-d', mktime(0, 0, 0, $max_month, 15, $max_year));

{

$text = url_lang::lang('texts.Deduction of member fee');

// finds default regular member fee for this month

{

// creates new transfer

$account_model = new Account_Model();

$transfer = new Transfer_Model();

// finding of operating account

$operating_account = $account_model->where('account_attribute_id', Account_attribute_Model::$operating)->find();

$transfer->origin_id = $operating_account->id;

// findind of account of member

$member_account = $account_model->where('member_id', $work->user->member_id)->where('account_attribute_id', Account_attribute_Model::$credit)->find();

$transfer->destination_id = $member_account->id;

$transfer->datetime = date('Y-m-d');

$transfer->creation_datetime = date('Y-m-d H:i:s');

$transfer->text = url_lang::lang('texts.Work approval');

$transfer->amount = $work->suggest_amount;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

}

// saves work

{

// creates new transfer

$account_model = new Account_Model();

$transfer = new Transfer_Model();

// finding of operating account

$operating_account = $account_model->where('account_attribute_id', Account_attribute_Model::$operating)->find();

$transfer->origin_id = $operating_account->id;

// findind of account of member

$member_account = $account_model->where('member_id', $work->user->member_id)->where('account_attribute_id', Account_attribute_Model::$credit)->find();

$transfer->destination_id = $member_account->id;

$transfer->datetime = date('Y-m-d');

$transfer->creation_datetime = date('Y-m-d H:i:s');

$transfer->text = url_lang::lang('texts.Work approval');

$transfer->amount = $work->suggest_amount;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

}

// saves work

<?php

class Bank_transfers_Controller extends Controller

{

// static types of bank transfers

$member_id = $dst_acc->member_id;

$dst_id = $dst_acc->id;

}

{

}

{

}

}

$view = new View('main');

$view->title = url_lang::lang('texts.Assign transfer');

/**

* Function enables adding of bank transfers manually.

* @param baa_id bank account of association

* @return unknown_type

*/

// origin bank account

$baa = new Bank_account_Model($baa_id);

if ($baa->id == 0 || $baa->member_id != 1)

// bank transfer type

$arr_bt_types[self::$member_fee] = url_lang::lang('texts.Member fee');

$arr_bt_types[self::$invoice] = url_lang::lang('texts.Invoice');

$form->set_attr('class', 'form_class')->set_attr('method', 'post');

// counteraccount

$form->group('')->label(url_lang::lang('texts.Counteraccount'));

$form->input('counteraccount_bc')->label(url_lang::lang('texts.Bank code').':')->rules('required');

$form->input('counteraccount_name')->label(url_lang::lang('texts.Account name').':');

// transfer

$form_data[$key] = htmlspecialchars($value);

}

// preparation

$operating = ORM::factory('account')->

where('account_attribute_id', Account_attribute_Model::$operating)->find();

$member_fees = ORM::factory('account')->

$counter_ba = ORM::factory('bank_account')->

where(array('account_nr' => $form_data['counteraccount'],

'bank_nr' => $form_data['counteraccount_bc']))->find();

{

{

{

}

}

}

{

}

}

$headline = url_lang::lang('texts.Add new bank transfer');

$view = new View('main');

$form_data[$key] = htmlspecialchars($value);

}

// preparation

$account = $baa->get_related_account_by_attribute_id(

Account_attribute_Model::$bank);

$bank_fees = $baa->get_related_account_by_attribute_id(

$cash = ORM::factory('account')->

where('account_attribute_id', Account_attribute_Model::$cash)->find();

// transfer

if ($form_data['type'] == self::$bank_fee)

{

}

elseif ($form_data['type'] == self::$bank_interest)

{

}

elseif ($form_data['type'] == self::$deposit)

{

}

{

}

{

}

}

$headline = url_lang::lang('texts.Add new bank transfer without counteraccount');

$view = new View('main');

<?php

class Bank_statements_Controller extends Controller

{

/**

$grid->action_field('id')->label(url_lang::lang('texts.Statement'))->url(url_lang::base().'bank_transfers/show_by_bank_statement')->action(url_lang::lang('texts.Show'));

if ($this->acl_check_edit('Accounts_Controller', 'bank_statements'))

$grid->action_field('id')->label(url_lang::lang('texts.Statement'))->url(url_lang::base().'bank_statements/edit')->action(url_lang::lang('texts.Edit'));

$grid->datasource($bank_statements);

$view = new View('main');

// creates new transfer

$account_model = new Account_Model();

$transfer = new Transfer_Model();

// finding of operating account

$operating_account = $account_model->where('account_attribute_id', Account_attribute_Model::$operating)->find();

$transfer->origin_id = $operating_account->id;

// findind of account of member

$member_account = $account_model->where('member_id', $work->user->member_id)->where('account_attribute_id', Account_attribute_Model::$credit)->find();

$transfer->destination_id = $member_account->id;

$transfer->datetime = date('Y-m-d');

$transfer->creation_datetime = date('Y-m-d H:i:s');

$transfer->text = url_lang::lang('texts.Work report approval');

$transfer->amount = $amount;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

foreach ($approved_works_ids as $approved_work_id)

{

$approved_work = new Job_Model($approved_work_id);

$approved_work->save();

}

{

// creates new transfer

$account_model = new Account_Model();

$transfer = new Transfer_Model();

// finding of operating account

$operating_account = $account_model->where('account_attribute_id', Account_attribute_Model::$operating)->find();

$transfer->origin_id = $operating_account->id;

// findind of account of member

$member_account = $account_model->where('member_id', $work->user->member_id)->where('account_attribute_id', Account_attribute_Model::$credit)->find();

$transfer->destination_id = $member_account->id;

$transfer->datetime = date('Y-m-d');

$transfer->creation_datetime = date('Y-m-d H:i:s');

$transfer->text = url_lang::lang('texts.Work approval');

$transfer->amount = $work->suggest_amount;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

}

$work->save();

{

// creates new transfer

$account_model = new Account_Model();

$transfer = new Transfer_Model();

// finding of operating account

$operating_account = $account_model->where('account_attribute_id', Account_attribute_Model::$operating)->find();

$transfer->origin_id = $operating_account->id;

// findind of account of member

$member_account = $account_model->where('member_id', $work->user->member_id)->where('account_attribute_id', Account_attribute_Model::$credit)->find();

$transfer->destination_id = $member_account->id;

$transfer->datetime = date('Y-m-d');

$transfer->creation_datetime = date('Y-m-d H:i:s');

$transfer->text = url_lang::lang('texts.Work approval');

$transfer->amount = $work->suggest_amount;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

}

$work->save();

}

}

class Import_Controller extends Controller

{

$statement->from = date('Y-m-d', $form_data['from']);

$statement->to = date('Y-m-d', $form_data['to']);

$statement->opening_balance = $form_data['opening_balance'];

{

}

}

else

{

* @param $bank_account_id

* @param $bank_template_id

* @return unknown_type

* ALTER TABLE `bank_templates` ADD `has_header` TINYINT NOT NULL COMMENT '0=no header, 1=use the header, 2=header present, but use column numbers in the template' AFTER `string_separator`

* ALTER TABLE `bank_templates` CHANGE `datetime` `date` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL

ALTER TABLE `bank_templates` ADD `time` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL AFTER `date

/**

* Function parses csv bank listing file of czech bank Postovni sporitelna.

* @param $bank_account_id

* @param $url

* @return unknown_type

}

static $transfer; // static variable saves a little bit of memory & time

if (!isset($transfer)) $transfer=new Transfer_Model();

$transfer->clear();

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

return $transfer->id;

}

private function create_transfers($src_acc, $dst_acc, $amount,

$member_id=null, $prev_id=null)

{

// static variable saves a little bit of memory & time

static $transfer;

static $bank_transfer;

if (!isset($transfer)) {

$transfer=new Transfer_Model();

$bank_transfer=new Bank_transfer_Model();

}

$transfer->clear();

$transfer->amount = $amount;

$transfer->datetime = $data->date_time;

$transfer->member_id = $member_id;

$transfer->user_id = $this->session->get('user_id');

$transfer->save();

$bank_transfer->clear();

$bank_transfer->origin_id = isset($src_bank_acc)? $src_bank_acc->id : null;

$bank_transfer->destination_id = isset($dst_bank_acc)? $dst_bank_acc->id : null;

$bank_transfer->bank_statement_id = $this->bank_statement_id;

$bank_transfer->variable_symbol = $data->variable_symbol;

$bank_transfer->constant_symbol = $data->constant_symbol;

$bank_transfer->specific_symbol = $data->specific_symbol;

}

/**

* @param $url - URL containing the file to parse

* @param $account_id - ID of the account whose data will be parsed.

* @return void

// pokud z gridu dostáváme $account_id, pak si ho uložíme pro potřeby callback funkce

if (isset($bank_account_id))

$this->parsed_bank_acc=new Bank_account_Model($bank_account_id);

$duplicity_err='';

$parser->parse($url);

// v případě duplicity commitujeme vše do výskytu duplicity a hned skončíme

$duplicity=new View('table_n_columns'); // tabulka se všemi nalezenými duplicitami

$duplicity->set('table_data', $ex->duplicity);

$duplicity_err = "Končíme, právě importovaný záznam má již v databázi duplicitní záznam(y):\n"

.$duplicity;

}

$stats=$this->stats;

$stats_table = new View('table_2_columns');

$stats->memory_consumed=((memory_get_usage()-$mem)>>10) . " kB";

$arr_stats[url_lang::lang("texts.".ucfirst(strtr($key, "_", " ")))]=$val;

$stats_table->set('table_data', $arr_stats);

$summary=array(

);

$sum_table = new View('table_2_columns');

$sum_table->set('table_data', $summary);

$title = url_lang::lang('texts.Import results');

$view->title = $title;

$view->content = new View('show_all');

$links = array();

$links[] = html::anchor(url_lang::base().'bank_accounts/show_all', url_lang::lang('texts.Back to bank accounts'));

$links[] = html::anchor(url_lang::base().'bank_transfers/show_by_bank_statement/'.$this->bank_statement_id, url_lang::lang('texts.Transfers of bank statement'));

<h2><?php echo $baa_headline; ?></h2>

<br />

<?php echo $baa_grid; ?>

<br />