Revize 328
Přidáno uživatelem Tomáš Dulík před asi 15 roky(ů)
freenetis/trunk/kohana/application/models/account.php | ||
---|---|---|
// protected $has_many = array('transfers');
|
||
protected $belongs_to = array('member');
|
||
//protected $belongs_to_many = array();
|
||
protected $has_and_belongs_to_many = array('bank_account');
|
||
protected $has_and_belongs_to_many = array('bank_accounts');
|
||
|
||
public function acc_type_exist($type, $owner_id = null, $acc_id = NULL)
|
||
{
|
freenetis/trunk/kohana/application/models/bank_account.php | ||
---|---|---|
// protected $has_many = array('money_transfers');
|
||
//protected $belongs_to = array('account');
|
||
//protected $belongs_to_many = array();
|
||
protected $has_and_belongs_to_many = array('account');
|
||
protected $has_and_belongs_to_many = array('accounts');
|
||
|
||
/**
|
||
* @author Jiri Svitak
|
||
... | ... | |
)->current()->credit;
|
||
return $credit;
|
||
}
|
||
|
||
/**
|
||
* @author Tomas Dulik
|
||
* @param $attribute_id - a value from accounts.account_attribute_id
|
||
* @return object containing first related account from the account table having the $type
|
||
*/
|
||
public function get_related_account_by_attribute_id($attribute_id) {
|
||
if (!$this->id) return false;
|
||
$q="SELECT accounts.* FROM accounts
|
||
JOIN accounts_bank_accounts AS pivot
|
||
ON accounts.id=pivot.account_id AND pivot.bank_account_id=$this->id
|
||
AND accounts.account_attribute_id=$attribute_id";
|
||
return self::$db->query($q)->current();
|
||
}
|
||
|
||
}
|
||
|
freenetis/trunk/kohana/application/controllers/accounts.php | ||
---|---|---|
$bank_acc->member_id=1;
|
||
$bank_acc->account_nr = $data->parsed_acc_nr;
|
||
$bank_acc->bank_nr=$data->parsed_acc_bank_nr;
|
||
$bank_acc->add_account($parsed_acc);
|
||
$bank_acc->save();
|
||
$this->parsed_bank_acc=$bank_acc;
|
||
}
|
||
... | ... | |
return;
|
||
}
|
||
}
|
||
if (!isset($parsed_acc)) {
|
||
$acc_name=$this->parsed_bank_acc->account_nr."/".$this->parsed_bank_acc->bank_nr;
|
||
$parsed_acc = ORM::factory('account')->find_by_name_and_account_attribute_id(
|
||
$acc_name, Account_attribute_Model::$bank);
|
||
if (!isset($parsed_acc)) {
|
||
$parsed_acc = $this->parsed_bank_acc->get_related_account_by_attribute_id(
|
||
Account_attribute_Model::$bank);
|
||
if (!$parsed_acc) {
|
||
// tohle by normálně nemělo nastat - pouze pokud nebude svázán bank. účet sdružení s podvojným účtem přes tabulku accounts_bank_accounts
|
||
$acc_name=$this->parsed_bank_acc->account_nr."/".$this->parsed_bank_acc->bank_nr;
|
||
$parsed_acc = ORM::factory('account')->find_by_name_and_account_attribute_id(
|
||
$acc_name, Account_attribute_Model::$bank);
|
||
$parsed_acc->add_bank_account($this->parsed_bank_acc);
|
||
$parsed_acc->save();
|
||
}
|
||
}
|
||
$bank_interests = ORM::factory('account')->find_by_account_attribute_id(
|
||
Account_attribute_Model::$bank_interests);
|
||
... | ... | |
$bank_acc->name = $data->name;
|
||
$bank_acc->account_nr = $data->account_nr;
|
||
$bank_acc->bank_nr = $data->account_bank_nr;
|
||
// $bank_acc->add_account($member_fees); // tuto vazbu bych tvořil jen pokud bych chtěl evidovat pohyby na bank. účtech členů
|
||
$bank_acc->save();
|
||
}
|
||
|
Také k dispozici: Unified diff
Do importu plateb doplneno pouziti vazebni tabulky accounts_bank_accounts