Revize 227
Přidáno uživatelem Jiří Sviták před více než 15 roky(ů)
freenetis/trunk/kohana/application/models/bank_account.php | ||
---|---|---|
<?php
|
||
class Bank_account_Model extends ORM
|
||
{
|
||
|
||
}
|
||
?>
|
freenetis/trunk/kohana/application/controllers/import.php | ||
---|---|---|
<?php
|
||
class Import_Controller extends Controller
|
||
{
|
||
function index()
|
||
{
|
||
url::redirect(url::base());
|
||
}
|
||
|
||
/**
|
||
* Imports data from table which contains annual statement to database structure of freenetis.
|
||
* Not functional yet.
|
||
* @return unknown_type
|
||
*/
|
||
public function run()
|
||
{
|
||
$db = new Database();
|
||
$stat = $db->get('2006');
|
||
for ($i = 0; $i < count($stat); $i++)
|
||
{
|
||
if ($stat[$i]->varsym != null)
|
||
{
|
||
$ba = $db->select('bank_nr')->from('bank_accounts')->where('bank_nr', $stat[$i]->protiucet)->get();
|
||
if ($ba->count() == 0)
|
||
{
|
||
$acc = new Account_Model();
|
||
$acc->member_id = 'null';
|
||
$acc->name = $stat[$i]->osoba;
|
||
$acc->type = 'bank';
|
||
$acc->start_amount = '0';
|
||
$acc->comment = '';
|
||
$acc->save();
|
||
$bacc = new Bank_Account_Model();
|
||
$bacc->account_id = $acc->id;
|
||
$bacc->account_nr = $stat[$i]->protiucet;
|
||
$bacc->bank_nr = $stat[$i]->kod_banky;
|
||
$bacc->save();
|
||
}
|
||
$mt = new Money_transfer_Model();
|
||
$mt->origin_id = $acc->id;
|
||
$mt->destination_id = '1';
|
||
$mt->timestamp = $stat[$i]->datum_platby;
|
||
$mt->text = $stat[$i]->text;
|
||
$mt->amount = $stat[$i]->castka;
|
||
$mt->save();
|
||
$mtbi = new Money_transfer_bank_info_Model();
|
||
$mtbi->transfer_id = $mt->id;
|
||
$mtbi->variable_symbol = $stat[$i]->varsym;
|
||
$mtbi->save();
|
||
}
|
||
echo 'line '.($i+1). ' saved';
|
||
}
|
||
}
|
||
}
|
||
?>
|
Také k dispozici: Unified diff
Pridan model pro bank_accounts. Pridan jeste nefunkcni import z databaze vypisu do databaze freenetisu. Skript na import dat vypisu v csv do mysql poslu mailem za usmev.