Revize 487
Přidáno uživatelem Jiří Sviták před asi 15 roky(ů)
| freenetis/trunk/kohana/application/i18n/cs_CZ/texts.php | ||
|---|---|---|
|
'password' => 'Heslo',
|
||
|
'pay from account' => 'Platit z účtu',
|
||
|
'payment' => 'Platba',
|
||
|
'payment by cash' => 'Platba hotově',
|
||
|
'payment has been successfully assigned' => 'Platba byla úspěšně přiřazena.',
|
||
|
'payment information' => 'Informace o platbě',
|
||
|
'payment notice' => 'Upozornění na placení',
|
||
| freenetis/trunk/kohana/application/models/subnet.php | ||
|---|---|---|
|
LEFT JOIN towns t ON t.id = ap.town_id
|
||
|
LEFT JOIN streets st ON st.id = ap.street_id
|
||
|
WHERE su.id = $subnet_id
|
||
|
ORDER BY ip_address
|
||
|
ORDER BY inet_aton(ip_address)
|
||
|
");
|
||
|
}
|
||
|
}
|
||
| freenetis/trunk/kohana/application/controllers/members.php | ||
|---|---|---|
|
// but there are problems probably with encofing in MS Excel
|
||
|
//$grid->add_new_button(url_lang::base().'members/xls_export', url_lang::lang('texts.Export to XLS'));
|
||
|
// csv export of members
|
||
|
$grid->add_new_button(url_lang::base().'members/csv_export', url_lang::lang('texts.Export to CSV (utf-8)'));
|
||
|
$grid->add_new_button(url_lang::base().'members/csv_export/windows-1250', url_lang::lang('texts.Export to CSV (windows-1250)'));
|
||
|
$grid->add_new_button(url_lang::base().'export/csv/members', url_lang::lang('texts.Export to CSV (utf-8)'));
|
||
|
$grid->add_new_button(url_lang::base().'export/csv/members/windows-1250', url_lang::lang('texts.Export to CSV (windows-1250)'));
|
||
|
}
|
||
|
$grid->order_field('id')->label('ID');
|
||
|
$grid->order_field('registration')->label(url_lang::lang('texts.Reg'))->bool(array(url_lang::lang('texts.No'),url_lang::lang('texts.Yes')))->class('center');
|
||
| ... | ... | |
|
} // end of registration function
|
||
|
|
||
|
|
||
|
/**
|
||
|
* @author Jiri Svitak
|
||
|
* Export list of members to xls file. Requires library PEAR.
|
||
|
* Works fine in OpenOffice, but there are problems probably with encoding in MS Excel.
|
||
|
* @return unknown_type
|
||
|
*/
|
||
|
function xls_export()
|
||
|
function get_streets()
|
||
|
{
|
||
|
// access rights
|
||
|
if (!$this->acl_check_view(get_class($this),'members'))
|
||
|
Controller::error(ACCESS);
|
||
|
// set content header
|
||
|
header('Content-type: application/xls');
|
||
|
// requires xls module from library PEAR
|
||
|
//require_once(APPPATH.'vendors/Spreadsheet/Excel/Writer.php');
|
||
|
require_once('Spreadsheet/Excel/Writer.php');
|
||
|
// workbook represents xls file
|
||
|
$workbook = new Spreadsheet_Excel_Writer();
|
||
|
$workbook->setVersion(8);
|
||
|
$workbook->send(url_lang::lang('texts.Members').'.xls');
|
||
|
// set xls cells format
|
||
|
$format_bold =& $workbook->addFormat();
|
||
|
$format_bold->setBold();
|
||
|
// worksheet represents sheet in xls file
|
||
|
$worksheet =& $workbook->addWorksheet('Clenove');
|
||
|
$worksheet->setInputEncoding("utf-8");
|
||
|
// creates database member model
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
if (!$q) return;
|
||
|
$member_model = new Member_Model();
|
||
|
$members = $member_model->get_all_members_to_export();
|
||
|
$resultCnt = count($members);
|
||
|
$first = true;
|
||
|
$row = 0;
|
||
|
// yes and no for registration
|
||
|
$yes = url_lang::lang('texts.yes');
|
||
|
$no = url_lang::lang('texts.no');
|
||
|
// goes through rows of data
|
||
|
foreach ($members as $key => $line)
|
||
|
{
|
||
|
// get column count
|
||
|
$colCnt = count($line);
|
||
|
$col = 0;
|
||
|
// header is written only once
|
||
|
if ($first)
|
||
|
{
|
||
|
// foreach goes through columns of header
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
$valLen = strlen($value);
|
||
|
// max array stores lenghts of columns in xls sheet
|
||
|
$max[$key] = $valLen;
|
||
|
// writes header values
|
||
|
$worksheet->write(0, $col, url_lang::lang('texts.'.$key), $format_bold);
|
||
|
if ($col >= $colCnt-1)
|
||
|
$first = false;
|
||
|
// sets max size of cell
|
||
|
if ($row >= $resultCnt-1)
|
||
|
$worksheet->setColumn($col, $col, $max[$key]);
|
||
|
$col++;
|
||
|
}
|
||
|
$row++;
|
||
|
$colCnt = count($line);
|
||
|
$col = 0;
|
||
|
}
|
||
|
// goes through columns of data and writes them into the sheet
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// special case - registration
|
||
|
if ($key == 'registration')
|
||
|
{
|
||
|
if ($value == 1)
|
||
|
$value = $yes;
|
||
|
else
|
||
|
$value = $no;
|
||
|
}
|
||
|
// determining size of cell
|
||
|
$valLen = strlen($value);
|
||
|
if ($max[$key] < $valLen)
|
||
|
$max[$key] = $valLen;
|
||
|
// writes data
|
||
|
$worksheet->write($row, $col, $value);
|
||
|
// sets max size of cell
|
||
|
if ($row >= $resultCnt)
|
||
|
$worksheet->setColumn($col, $col, $max[$key]);
|
||
|
$col++;
|
||
|
}
|
||
|
$row++;
|
||
|
}
|
||
|
$workbook->close();
|
||
|
} // end of xls_export
|
||
|
|
||
|
/**
|
||
|
* @author Jiri Svitak
|
||
|
* Function exports list of members to csv file. Rows are separated by newlines and it columns by semicolon.
|
||
|
* @param encoding optional parameter; by default the result is encoded in utf-8 and encoding can change this
|
||
|
* @return unknown_type
|
||
|
*/
|
||
|
function csv_export($encoding = 'utf-8')
|
||
|
$streets = $member_model->get_streets($q);
|
||
|
foreach ($streets as $street) echo $street->street."\n";
|
||
|
}
|
||
|
|
||
|
function get_towns()
|
||
|
{
|
||
|
// access rights
|
||
|
if (!$this->acl_check_view(get_class($this),'members'))
|
||
|
Controller::error(ACCESS);
|
||
|
// creates database member model
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
if (!$q) return;
|
||
|
$member_model = new Member_Model();
|
||
|
$members = $member_model->get_all_members_to_export();
|
||
|
// set content header
|
||
|
header('Content-type: application/csv');
|
||
|
$filename = url_lang::lang('texts.Members').'.csv';
|
||
|
header('Content-Disposition: attachment; filename="'.$filename.'"');
|
||
|
$first = true;
|
||
|
// yes and no for registration
|
||
|
$yes = url_lang::lang('texts.yes');
|
||
|
$no = url_lang::lang('texts.no');
|
||
|
// this foreach goes through rows
|
||
|
foreach ($members as $line)
|
||
|
{
|
||
|
// first headers of columns will be written
|
||
|
if ($first)
|
||
|
{
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// translation of column titles
|
||
|
$title = url_lang::lang('texts.'.$key);
|
||
|
// file cannot start with ID, otherwise excel and openoffice think that the file is invalid
|
||
|
if ($title == 'ID')
|
||
|
$title = url_lang::lang('texts.Number');
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$title = iconv ('utf-8', $encoding, $title);
|
||
|
echo '"'.$title.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
$first = false;
|
||
|
}
|
||
|
// this foreach writes line
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// special case - registration
|
||
|
if ($key == 'registration')
|
||
|
{
|
||
|
if ($value == 1)
|
||
|
$value = $yes;
|
||
|
else
|
||
|
$value = $no;
|
||
|
}
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$value = iconv ('utf-8', $encoding, $value);
|
||
|
echo '"'.$value.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
}
|
||
|
$towns = $member_model->get_towns($q);
|
||
|
foreach ($towns as $town) echo $town->town."\n";
|
||
|
}
|
||
|
|
||
|
function get_streets()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
|
||
|
if (!$q) return;
|
||
|
function get_ZIP_codes()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
if (!$q) return;
|
||
|
$member_model = new Member_Model();
|
||
|
$ZIP_codes = $member_model->get_ZIP_codes($q);
|
||
|
foreach ($ZIP_codes as $ZIP_code) echo $ZIP_code->ZIP_code."\n";
|
||
|
}
|
||
|
|
||
|
$member_model = new Member_Model();
|
||
|
$streets = $member_model->get_streets($q);
|
||
|
function get_quarters()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
if (!$q) return;
|
||
|
$member_model = new Member_Model();
|
||
|
$quarters = $member_model->get_quarters($q);
|
||
|
foreach ($quarters as $quarter) echo $quarter->quarter."\n";
|
||
|
}
|
||
|
|
||
|
foreach ($streets as $street) echo $street->street."\n";
|
||
|
}
|
||
|
|
||
|
function get_towns()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
|
||
|
if (!$q) return;
|
||
|
|
||
|
$member_model = new Member_Model();
|
||
|
$towns = $member_model->get_towns($q);
|
||
|
|
||
|
foreach ($towns as $town) echo $town->town."\n";
|
||
|
}
|
||
|
|
||
|
function get_ZIP_codes()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
|
||
|
if (!$q) return;
|
||
|
|
||
|
$member_model = new Member_Model();
|
||
|
$ZIP_codes = $member_model->get_ZIP_codes($q);
|
||
|
|
||
|
foreach ($ZIP_codes as $ZIP_code) echo $ZIP_code->ZIP_code."\n";
|
||
|
}
|
||
|
|
||
|
function get_quarters()
|
||
|
{
|
||
|
$q = strtolower($this->input->get('q'));
|
||
|
|
||
|
if (!$q) return;
|
||
|
|
||
|
$member_model = new Member_Model();
|
||
|
$quarters = $member_model->get_quarters($q);
|
||
|
|
||
|
foreach ($quarters as $quarter) echo $quarter->quarter."\n";
|
||
|
}
|
||
|
|
||
|
|
||
|
|
||
|
/**
|
||
|
* Checks if username already exists.
|
||
|
* @param $input new username
|
||
| freenetis/trunk/kohana/application/controllers/subnets.php | ||
|---|---|---|
|
url::redirect(url_lang::base().'subnets/show_all');
|
||
|
}
|
||
|
|
||
|
|
||
|
/**
|
||
|
* Function export all ip addresses of given subnet. With ip address, information is included, like
|
||
|
* interface, device, user, member.
|
||
|
* @param $subnet_id
|
||
|
* @return unknown_type
|
||
|
*/
|
||
|
function csv_export($subnet_id = null, $encoding = 'utf-8')
|
||
|
{
|
||
|
if (!isset($subnet_id))
|
||
|
Controller::warning(PARAMETER);
|
||
|
$subnet_model = new Subnet_Model($subnet_id);
|
||
|
if ($subnet_model->id == 0)
|
||
|
Controller::error(RECORD);
|
||
|
if (!$this->acl_check_view('Devices_Controller', 'subnet'))
|
||
|
Controller::error(ACCESS);
|
||
|
$items = $subnet_model->get_items_of_subnet($subnet_id);
|
||
|
// set content header
|
||
|
header('Content-type: application/csv');
|
||
|
$filename = $subnet_model->name.'.csv';
|
||
|
header('Content-Disposition: attachment; filename="'.$filename.'"');
|
||
|
$first = true;
|
||
|
// this foreach goes through rows
|
||
|
foreach ($items as $line)
|
||
|
{
|
||
|
// first headers of columns will be written
|
||
|
if ($first)
|
||
|
{
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// translation of column titles
|
||
|
$title = url_lang::lang('texts.'.$key);
|
||
|
// file cannot start with ID, otherwise excel and openoffice think that the file is invalid
|
||
|
if ($title == 'ID')
|
||
|
$title = url_lang::lang('texts.Number');
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$title = iconv ('utf-8', $encoding, $title);
|
||
|
echo '"'.$title.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
$first = false;
|
||
|
}
|
||
|
// this foreach writes line
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$value = iconv ('utf-8', $encoding, $value);
|
||
|
echo '"'.$value.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Callback function validates ip address.
|
||
|
* @param $input
|
||
|
* @return unknown_type
|
||
| freenetis/trunk/kohana/application/controllers/bank_accounts.php | ||
|---|---|---|
|
{
|
||
|
$member_model = new Member_Model();
|
||
|
$members = $member_model->find_all();
|
||
|
$arr_members = array();
|
||
|
foreach ($members as $member)
|
||
|
{
|
||
|
$arr_members[$member->id] = $member->name;
|
||
|
if ($member->id != 1)
|
||
|
$arr_members[$member->id] = $member->name;
|
||
|
}
|
||
|
asort($arr_members, SORT_LOCALE_STRING);
|
||
|
$form = new Forge(url_lang::base()."bank_accounts/add/", '', 'POST', array('id' => 'article_form'));
|
||
|
$form->set_attr('class', 'form_class')->set_attr('method', 'post');
|
||
|
$form->dropdown('member_id')->label(url_lang::lang('texts.Member name'))->options($arr_members)->selected($this->session->get('member_id'));
|
||
|
$form->dropdown('member_id')->label(url_lang::lang('texts.Member name'))->options($arr_members)->selected($this->session->get('member_id'))->rules('required');
|
||
|
}
|
||
|
else
|
||
|
{
|
||
| ... | ... | |
|
$bank_account->bank_nr = $form_data["bank_nr"];
|
||
|
$bank_account->IBAN = $form_data["IBAN"];
|
||
|
$bank_account->SWIFT = $form_data["SWIFT"];
|
||
|
$bank_account->save();
|
||
|
// these three double-entry accounts are related to one bank account through relation table
|
||
|
// double-entry bank account
|
||
|
$doubleentry_bank_account = new Account_Model();
|
||
|
$doubleentry_bank_account->member_id = $member_id;
|
||
|
$doubleentry_bank_account->name = $form_data["account_name"];
|
||
|
$doubleentry_bank_account->account_attribute_id = Account_attribute_Model::$bank;
|
||
|
$doubleentry_bank_account->comment = url_lang::lang('texts.Bank accounts');
|
||
|
$doubleentry_bank_account->save();
|
||
|
$doubleentry_bank_account->add_bank_account($bank_account);
|
||
|
// double-entry account of bank fees
|
||
|
$bank_fees_account = new Account_Model();
|
||
|
$bank_fees_account->member_id = $member_id;
|
||
|
$bank_fees_account->name = $form_data["account_name"].' - '.url_lang::lang('texts.Bank fees');
|
||
|
$bank_fees_account->account_attribute_id = Account_attribute_Model::$bank_fees;
|
||
|
$bank_fees_account->comment = url_lang::lang('texts.Bank fees');
|
||
|
$bank_fees_account->save();
|
||
|
$bank_fees_account->add_bank_account($bank_account);
|
||
|
// double-entry account of bank interests
|
||
|
$bank_interests_account = new Account_Model();
|
||
|
$bank_interests_account->member_id = $member_id;
|
||
|
$bank_interests_account->name = $form_data["account_name"].' - '.url_lang::lang('texts.Bank interests');
|
||
|
$bank_interests_account->account_attribute_id = Account_attribute_Model::$bank_interests;
|
||
|
$bank_interests_account->comment = url_lang::lang('texts.Bank interests');
|
||
|
$bank_interests_account->save();
|
||
|
$bank_interests_account->add_bank_account($bank_account);
|
||
|
$bank_account->save();
|
||
|
// only member 1 - association itself - has related double-entry accounts to added bank account
|
||
|
if ($member_id == 1)
|
||
|
{
|
||
|
// these three double-entry accounts are related to one bank account through relation table
|
||
|
// double-entry bank account
|
||
|
$doubleentry_bank_account = new Account_Model();
|
||
|
$doubleentry_bank_account->member_id = $member_id;
|
||
|
$doubleentry_bank_account->name = $form_data["account_name"];
|
||
|
$doubleentry_bank_account->account_attribute_id = Account_attribute_Model::$bank;
|
||
|
$doubleentry_bank_account->comment = url_lang::lang('texts.Bank accounts');
|
||
|
$doubleentry_bank_account->save();
|
||
|
$doubleentry_bank_account->add_bank_account($bank_account);
|
||
|
// double-entry account of bank fees
|
||
|
$bank_fees_account = new Account_Model();
|
||
|
$bank_fees_account->member_id = $member_id;
|
||
|
$bank_fees_account->name = $form_data["account_name"].' - '.url_lang::lang('texts.Bank fees');
|
||
|
$bank_fees_account->account_attribute_id = Account_attribute_Model::$bank_fees;
|
||
|
$bank_fees_account->comment = url_lang::lang('texts.Bank fees');
|
||
|
$bank_fees_account->save();
|
||
|
$bank_fees_account->add_bank_account($bank_account);
|
||
|
// double-entry account of bank interests
|
||
|
$bank_interests_account = new Account_Model();
|
||
|
$bank_interests_account->member_id = $member_id;
|
||
|
$bank_interests_account->name = $form_data["account_name"].' - '.url_lang::lang('texts.Bank interests');
|
||
|
$bank_interests_account->account_attribute_id = Account_attribute_Model::$bank_interests;
|
||
|
$bank_interests_account->comment = url_lang::lang('texts.Bank interests');
|
||
|
$bank_interests_account->save();
|
||
|
$bank_interests_account->add_bank_account($bank_account);
|
||
|
}
|
||
|
// redirection
|
||
|
url::redirect(url_lang::base().'bank_accounts/show_all');
|
||
|
}
|
||
|
$headline = url_lang::lang('texts.Add new bank account of association');
|
||
|
if ($member_id == 1)
|
||
|
$headline = url_lang::lang('texts.Add new bank account of association');
|
||
|
else
|
||
|
$headline = url_lang::lang('texts.Add new bank account');
|
||
|
$view = new View('main');
|
||
|
$view->title = $headline;
|
||
|
$view->content = new View('form');
|
||
| freenetis/trunk/kohana/application/controllers/import.php | ||
|---|---|---|
|
// file types of bank listings
|
||
|
$types = array();
|
||
|
$types[self::$html_ebanka] = 'HTML eBanka';
|
||
|
$types[self::$csv_postovni_sporitelna] = 'CSV Postovni sporitelna';
|
||
|
//$types[self::$csv_postovni_sporitelna] = 'CSV Postovni sporitelna';
|
||
|
|
||
|
// csv templates
|
||
|
/*
|
||
| freenetis/trunk/kohana/application/controllers/export.php | ||
|---|---|---|
|
<?php
|
||
|
|
||
|
class Export_Controller extends Controller
|
||
|
{
|
||
|
/**
|
||
|
* @author Jiri Svitak
|
||
|
* Function exports list of items to csv file. Rows are separated by newlines and it columns by semicolon.
|
||
|
* @param encoding optional parameter; by default the result is encoded in utf-8 and encoding can change this
|
||
|
*/
|
||
|
function csv($content = null, $encoding = 'utf-8', $id = null)
|
||
|
{
|
||
|
// each content has specific query
|
||
|
switch ($content)
|
||
|
{
|
||
|
case 'members':
|
||
|
if (!$this->acl_check_view('Members_Controller', 'members'))
|
||
|
Controller::error(ACCESS);
|
||
|
$member_model = new Member_Model();
|
||
|
$items = $member_model->get_all_members_to_export();
|
||
|
break;
|
||
|
case 'subnets':
|
||
|
$subnet_model = new Subnet_Model($id);
|
||
|
if ($subnet_model->id == 0)
|
||
|
Controller::error(RECORD);
|
||
|
if (!$this->acl_check_view('Devices_Controller', 'subnet'))
|
||
|
Controller::error(ACCESS);
|
||
|
$items = $subnet_model->get_items_of_subnet($id);
|
||
|
break;
|
||
|
default:
|
||
|
Controller::warning(PARAMETER, url_lang::lang('texts.Bad parameter for export'));
|
||
|
}
|
||
|
// set content header
|
||
|
header('Content-type: application/csv');
|
||
|
$filename = url_lang::lang('texts.Members').'.csv';
|
||
|
header('Content-Disposition: attachment; filename="'.$filename.'"');
|
||
|
$first = true;
|
||
|
// yes and no for registration
|
||
|
$yes = url_lang::lang('texts.yes');
|
||
|
$no = url_lang::lang('texts.no');
|
||
|
// this foreach goes through rows
|
||
|
foreach ($items as $line)
|
||
|
{
|
||
|
// first headers of columns will be written
|
||
|
if ($first)
|
||
|
{
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// translation of column titles
|
||
|
$title = url_lang::lang('texts.'.$key);
|
||
|
// file cannot start with ID, otherwise excel and openoffice think that the file is invalid
|
||
|
if ($title == 'ID')
|
||
|
$title = url_lang::lang('texts.Number');
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$title = iconv ('utf-8', $encoding, $title);
|
||
|
echo '"'.$title.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
$first = false;
|
||
|
}
|
||
|
// this foreach writes line
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// special case - registration
|
||
|
if ($key == 'registration')
|
||
|
{
|
||
|
if ($value == 1)
|
||
|
$value = $yes;
|
||
|
else
|
||
|
$value = $no;
|
||
|
}
|
||
|
// character encoding
|
||
|
if ($encoding != 'utf-8')
|
||
|
$value = iconv ('utf-8', $encoding, $value);
|
||
|
echo '"'.$value.'";';
|
||
|
}
|
||
|
echo "\n";
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* @author Jiri Svitak
|
||
|
* Export list of members to xls file. Requires library PEAR.
|
||
|
* Works fine in OpenOffice, but there are problems probably with encoding in MS Excel.
|
||
|
* @return unknown_type
|
||
|
*/
|
||
|
function xls_export()
|
||
|
{
|
||
|
// access rights
|
||
|
if (!$this->acl_check_view(get_class($this),'members'))
|
||
|
Controller::error(ACCESS);
|
||
|
// set content header
|
||
|
header('Content-type: application/xls');
|
||
|
// requires xls module from library PEAR
|
||
|
//require_once(APPPATH.'vendors/Spreadsheet/Excel/Writer.php');
|
||
|
require_once('Spreadsheet/Excel/Writer.php');
|
||
|
// workbook represents xls file
|
||
|
$workbook = new Spreadsheet_Excel_Writer();
|
||
|
$workbook->setVersion(8);
|
||
|
$workbook->send(url_lang::lang('texts.Members').'.xls');
|
||
|
// set xls cells format
|
||
|
$format_bold =& $workbook->addFormat();
|
||
|
$format_bold->setBold();
|
||
|
// worksheet represents sheet in xls file
|
||
|
$worksheet =& $workbook->addWorksheet('Clenove');
|
||
|
$worksheet->setInputEncoding("utf-8");
|
||
|
// creates database member model
|
||
|
$member_model = new Member_Model();
|
||
|
$members = $member_model->get_all_members_to_export();
|
||
|
$resultCnt = count($members);
|
||
|
$first = true;
|
||
|
$row = 0;
|
||
|
// yes and no for registration
|
||
|
$yes = url_lang::lang('texts.yes');
|
||
|
$no = url_lang::lang('texts.no');
|
||
|
// goes through rows of data
|
||
|
foreach ($members as $key => $line)
|
||
|
{
|
||
|
// get column count
|
||
|
$colCnt = count($line);
|
||
|
$col = 0;
|
||
|
// header is written only once
|
||
|
if ($first)
|
||
|
{
|
||
|
// foreach goes through columns of header
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
$valLen = strlen($value);
|
||
|
// max array stores lenghts of columns in xls sheet
|
||
|
$max[$key] = $valLen;
|
||
|
// writes header values
|
||
|
$worksheet->write(0, $col, url_lang::lang('texts.'.$key), $format_bold);
|
||
|
if ($col >= $colCnt-1)
|
||
|
$first = false;
|
||
|
// sets max size of cell
|
||
|
if ($row >= $resultCnt-1)
|
||
|
$worksheet->setColumn($col, $col, $max[$key]);
|
||
|
$col++;
|
||
|
}
|
||
|
$row++;
|
||
|
$colCnt = count($line);
|
||
|
$col = 0;
|
||
|
}
|
||
|
// goes through columns of data and writes them into the sheet
|
||
|
foreach ($line as $key => $value)
|
||
|
{
|
||
|
// special case - registration
|
||
|
if ($key == 'registration')
|
||
|
{
|
||
|
if ($value == 1)
|
||
|
$value = $yes;
|
||
|
else
|
||
|
$value = $no;
|
||
|
}
|
||
|
// determining size of cell
|
||
|
$valLen = strlen($value);
|
||
|
if ($max[$key] < $valLen)
|
||
|
$max[$key] = $valLen;
|
||
|
// writes data
|
||
|
$worksheet->write($row, $col, $value);
|
||
|
// sets max size of cell
|
||
|
if ($row >= $resultCnt)
|
||
|
$worksheet->setColumn($col, $col, $max[$key]);
|
||
|
$col++;
|
||
|
}
|
||
|
$row++;
|
||
|
}
|
||
|
$workbook->close();
|
||
|
} // end of xls_export
|
||
|
|
||
|
}
|
||
|
|
||
|
?>
|
||
| freenetis/trunk/kohana/application/views/members_show.php | ||
|---|---|---|
|
<h2>
|
||
|
<?php echo url_lang::lang('texts.Member').' ' ?>
|
||
|
<?php echo $member_data->namem ?>
|
||
|
</h2>
|
||
|
<h2><?php echo $member_type.' '.$member_data->namem ?></h2>
|
||
|
<br />
|
||
|
<?php
|
||
|
echo $message ? '<div class="message">'.$message.'</div>' : '';
|
||
| ... | ... | |
|
if ($this->acl_check_view('Accounts_Controller', 'transfers', $member_data->member_id) && $member_data->member_id != 1)
|
||
|
$links[] = html::anchor(url_lang::base().'transfers/show_by_account/'.$account->id, url_lang::lang('texts.Show his transfers'));
|
||
|
if ($this->acl_check_edit('Accounts_Controller', 'transfers', $member_data->member_id) && $member_data->member_id != 1)
|
||
|
$links[] = html::anchor(url_lang::base().'transfers/add_member_fee_payment_by_cash/'.$member_data->member_id, url_lang::lang('texts.Add member fee payment by cash'));
|
||
|
$links[] = html::anchor(url_lang::base().'transfers/add_member_fee_payment_by_cash/'.$member_data->member_id, url_lang::lang('texts.Payment by cash'));
|
||
|
if ($this->acl_check_edit('Members_Controller', 'redirect', $member_data->member_id))
|
||
|
$links[] = html::anchor(url_lang::base().'redirect/member/'.$member_data->member_id, url_lang::lang('texts.Redirection'));
|
||
|
if ($member_data->member_id != 1 && $member_data->entrance_fee_left != 0 && $this->acl_check_new('Accounts_Controller', 'transfers'))
|
||
|
$links[] = html::anchor(url_lang::base().'transfers/deduct_entrance_fees/'.$member_data->member_id, url_lang::lang('texts.Deduct entrance fee'), array('onclick' => 'return potvrd(\''.url_lang::lang('texts.Do you want to deduct this member\'s entrance fee').'\')'));
|
||
|
$links[] = html::anchor(url_lang::base().'transfers/deduct_entrance_fees/'.$member_data->member_id, url_lang::lang('texts.Deduct entrance fee'), array('onclick' => 'return potvrd(\''.url_lang::lang('texts.Do you want to deduct this member\'s entrance fee').'\')'));
|
||
|
if ($member_data->member_id != 1 && $this->acl_check_edit('Members_Controller', 'members'))
|
||
|
$links[] = html::anchor(url_lang::base().'members/end_membership/'.$member_data->member_id, url_lang::lang('texts.End membership'));
|
||
|
echo implode (' | ', $links)
|
||
|
?>
|
||
|
<br />
|
||
| ... | ... | |
|
<th><?php echo url_lang::lang('texts.Organization identifier') ?></th>
|
||
|
<td><?php echo $member_data->organization_identifier ?></td>
|
||
|
</tr>
|
||
|
<?php if ($member_data->member_id != 1) { ?>
|
||
|
<tr>
|
||
|
<th><?php echo url_lang::lang('texts.Variable symbol') ?></th>
|
||
|
<td><?php echo $member_data->variable_symbol ?></td>
|
||
|
</tr>
|
||
|
<?php } ?>
|
||
|
<?php if ($this->acl_check_view('Members_Controller', 'entrance_date', $member_data->member_id)) { ?>
|
||
|
<tr>
|
||
|
<th><?php echo url_lang::lang('texts.Entrance date') ?></th>
|
||
| freenetis/trunk/kohana/application/views/subnets_show.php | ||
|---|---|---|
|
$links[] = html::anchor(url_lang::base().'subnets/edit/'.$subnet->id, url_lang::lang('texts.Edit'));
|
||
|
if ($this->acl_check_view('Devices_Controller', 'subnet'))
|
||
|
{
|
||
|
$links[] = html::anchor(url_lang::base().'subnets/csv_export/'.$subnet->id, url_lang::lang('texts.Export to CSV (utf-8)'));
|
||
|
$links[] = html::anchor(url_lang::base().'subnets/csv_export/'.$subnet->id.'/windows-1250', url_lang::lang('texts.Export to CSV (windows-1250)'));
|
||
|
$links[] = html::anchor(url_lang::base().'export/csv/subnets/utf-8/'.$subnet->id, url_lang::lang('texts.Export to CSV (utf-8)'));
|
||
|
$links[] = html::anchor(url_lang::base().'export/csv/subnets/windows-1250/'.$subnet->id, url_lang::lang('texts.Export to CSV (windows-1250)'));
|
||
|
}
|
||
|
echo implode(' | ', $links);
|
||
|
?>
|
||
| freenetis/trunk/money_transfers.clay | ||
|---|---|---|
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
|
||
|
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
||
|
<clay-model clay-version="1.4.2">
|
||
|
<database-model alias="" author="" begin-script="" end-script="" name="money_transfers" remarks="" sql-dialect-id="jp.azzurri.clay.dialect.MySQL_5_0_Dialect" uid="13ed0e:11d774ed92c:-8000" version="1.0">
|
||
|
<database-model-description/>
|
||
|
<database-model-description></database-model-description>
|
||
|
<schema-list>
|
||
|
<schema alias="" name="DEFAULT_SCHEMA" remarks="" uid="13ed0e:11d774ed92c:-7ffe">
|
||
|
<schema-description/>
|
||
|
<schema-description></schema-description>
|
||
|
<domain-list/>
|
||
|
<table-list>
|
||
|
<table alias="" name="accounts" remarks="" uid="13ed0e:11d774ed92c:-7ffd">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="-1" width="-1" x="542" y="157"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="-1" width="-1" x="534" y="64"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7ffb">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="13ed0e:11d774ed92c:-7ffa">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7ff9">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="account_attribute_id" remarks="" uid="13ed0e:11d774ed92c:-7ff8">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
|
||
|
<variant type-name-pattern="INTEGER"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7ff6">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
| ... | ... | |
|
</column>
|
||
|
</column-list>
|
||
|
<primary-key alias="" name="PK_ACCOUNTS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7ffc">
|
||
|
<primary-key-description/>
|
||
|
<primary-key-description></primary-key-description>
|
||
|
<primary-key-column name="id"/>
|
||
|
</primary-key>
|
||
|
<unique-key-list/>
|
||
|
<foreign-key-list>
|
||
|
<foreign-key alias="" name="FK_accounts_1" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13ed0e:11d774ed92c:-7e58">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="11" y="45"/>
|
||
|
<fk-fig-target-terminal x="202" y="192"/>
|
||
| ... | ... | |
|
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_accounts_2" on-delete="" on-update="" referenced-key="PK_ACCOUNT_ATTRIBUTES" referenced-table="account_attributes" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="5084c6:122298f0109:-7f87">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-target-terminal x="66" y="88"/>
|
||
|
<fk-fig-bendpoint-list/>
|
||
| ... | ... | |
|
</foreign-key-list>
|
||
|
<index-list>
|
||
|
<index alias="" name="is_owned_by" remarks="" uid="13ed0e:11d774ed92c:-7ff5" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="member_id" sort="ASC"/>
|
||
|
</index>
|
||
|
</index-list>
|
||
|
</table>
|
||
|
<table alias="" name="members" remarks="" uid="13ed0e:11d774ed92c:-7fe9">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="-1" width="-1" x="209" y="9"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="-1" width="-1" x="79" y="-127"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fe7">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="true" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fe6">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="street_number" remarks="" uid="13ed0e:11d774ed92c:-7fe5">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="street" remarks="" uid="13ed0e:11d774ed92c:-7fe4">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="town" remarks="" uid="13ed0e:11d774ed92c:-7fe3">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="ZIP_code" remarks="" uid="13ed0e:11d774ed92c:-7fe2">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fe1">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
|
||
|
<variant type-name-pattern="TINYINT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="false" name="qos_ceil" remarks="" uid="13ed0e:11d774ed92c:-7fe0">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="false" name="qos_rate" remarks="" uid="13ed0e:11d774ed92c:-7fdf">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee" remarks="" uid="13ed0e:11d774ed92c:-7fde">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
|
||
|
<variant type-name-pattern="DOUBLE"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="debt_payment_rate" remarks="" uid="13ed0e:11d774ed92c:-7fdd">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
|
||
|
<variant type-name-pattern="DOUBLE"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee_left" remarks="" uid="13ed0e:11d774ed92c:-7fdc">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
|
||
|
<variant type-name-pattern="DOUBLE"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee_date" remarks="" uid="13ed0e:11d774ed92c:-7fdb">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
|
||
|
<variant type-name-pattern="DATE"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="1" mandatory="false" name="must_pay_regular_fee" remarks="" uid="13ed0e:11d774ed92c:-7fda">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
|
||
|
<variant type-name-pattern="TINYINT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="12" decimal-digits="0" default-value="" mandatory="false" name="current_credit" remarks="" uid="13ed0e:11d774ed92c:-7fd9">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="7" name="FLOAT" selected-variant-pattern="FLOAT(%n)">
|
||
|
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n)"/>
|
||
|
<variant type-name-pattern="FLOAT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_date" remarks="" uid="13ed0e:11d774ed92c:-7fd8">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
|
||
|
<variant type-name-pattern="DATE"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_form_received" remarks="" uid="13ed0e:11d774ed92c:-7fd7">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
|
||
|
<variant type-name-pattern="DATE"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_form_accepted" remarks="" uid="13ed0e:11d774ed92c:-7fd6">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
|
||
|
<variant type-name-pattern="DATE"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7fd5">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="old_db_id" remarks="" uid="13ed0e:11d774ed92c:-7fd4">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</column>
|
||
|
</column-list>
|
||
|
<primary-key alias="" name="PK_MEMBERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fe8">
|
||
|
<primary-key-description/>
|
||
|
<primary-key-description></primary-key-description>
|
||
|
<primary-key-column name="id"/>
|
||
|
</primary-key>
|
||
|
<unique-key-list/>
|
||
| ... | ... | |
|
<index-list/>
|
||
|
</table>
|
||
|
<table alias="" name="bank_transfers" remarks="" uid="13ed0e:11d774ed92c:-7fd3">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="124" width="163" x="817" y="326"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="124" width="163" x="1089" y="307"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7e41">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT">
|
||
|
<variant type-name-pattern="INT"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="origin_id" remarks="" uid="13cf887:1224b8822ba:-7fef">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
|
||
|
<variant type-name-pattern="INTEGER"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="destination_id" remarks="" uid="13cf887:1224b8822ba:-7fec">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
|
||
|
<variant type-name-pattern="INTEGER"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="transfer_id" remarks="" uid="13ed0e:11d774ed92c:-7fd1">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="variable_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fd0">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
|
||
|
<variant type-name-pattern="BIGINT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="constant_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fcf">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
|
||
|
<variant type-name-pattern="BIGINT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="specific_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fce">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
|
||
|
<variant type-name-pattern="BIGINT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fcd">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
| ... | ... | |
|
</column>
|
||
|
</column-list>
|
||
|
<primary-key alias="" name="PK_MONEY_TRANSFER_BANK_INFOS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fd2">
|
||
|
<primary-key-description/>
|
||
|
<primary-key-description></primary-key-description>
|
||
|
<primary-key-column name="id"/>
|
||
|
</primary-key>
|
||
|
<unique-key-list/>
|
||
|
<foreign-key-list>
|
||
|
<foreign-key alias="" name="FK_money_transfer_bank_infos_1" on-delete="" on-update="" referenced-key="PK_MONEY_TRANSFERS_PRIMARY" referenced-table="transfers" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..1" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13ed0e:11d774ed92c:-7e05">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="0" y="51"/>
|
||
|
<fk-fig-target-terminal x="177" y="55"/>
|
||
| ... | ... | |
|
<foreign-key-column column-name="transfer_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_bank_transfers_2" on-delete="" on-update="" referenced-key="PK_BANK_ACCOUNTS" referenced-table="bank_accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13cf887:1224b8822ba:-7f86">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="16" y="3"/>
|
||
|
<fk-fig-target-terminal x="14" y="123"/>
|
||
| ... | ... | |
|
<foreign-key-column column-name="origin_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_bank_transfers_3" on-delete="" on-update="" referenced-key="PK_BANK_ACCOUNTS" referenced-table="bank_accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13cf887:1224b8822ba:-7d3c">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="112" y="1"/>
|
||
|
<fk-fig-bendpoint-list/>
|
||
| ... | ... | |
|
<index-list/>
|
||
|
</table>
|
||
|
<table alias="" name="transfers" remarks="" uid="13ed0e:11d774ed92c:-7fcc">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="-1" width="-1" x="532" y="321"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="-1" width="-1" x="497" y="350"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fca">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="origin_id" remarks="" uid="13ed0e:11d774ed92c:-7fc9">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="destination_id" remarks="" uid="13ed0e:11d774ed92c:-7fc8">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
<variant type-name-pattern="INT ZEROFILL"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="previous_transfer_id" remarks="" uid="13ed0e:11d774ed92c:-7fc7">
|
||
|
<column-description/>
|
||
|
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="false" name="previous_transfer_id" remarks="" uid="1834b39:1238964e7e9:-7be9">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant type-name-pattern="INT"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED ZEROFILL"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) ZEROFILL"/>
|
||
| ... | ... | |
|
<variant type-name-pattern="INT ZEROFILL"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="CURRENT_TIMESTAMP" mandatory="true" name="timestamp" remarks="" uid="13ed0e:11d774ed92c:-7fc6">
|
||
|
<column-description/>
|
||
|
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
|
||
|
<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
|
||
|
<variant type-name-pattern="TIMESTAMP"/>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="1834b39:1238964e7e9:-7bab">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
||
|
<variant type-name-pattern="CHAR"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="user_id" remarks="" uid="1834b39:1238964e7e9:-7baa">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
||
|
<variant type-name-pattern="CHAR"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="1834b39:1238964e7e9:-7bac">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT">
|
||
|
<variant type-name-pattern="TINYINT"/>
|
||
|
<variant type-name-pattern="TINYINT UNSIGNED"/>
|
||
|
<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
|
||
|
<variant type-name-pattern="TINYINT ZEROFILL"/>
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
|
||
|
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="datetime" remarks="" uid="13ed0e:11d774ed92c:-7fc7">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
|
||
|
<variant type-name-pattern="DATETIME"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="creation_datetime" remarks="" uid="1834b39:1238964e7e9:-7bea">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
|
||
|
<variant type-name-pattern="DATETIME"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="text" remarks="" uid="13ed0e:11d774ed92c:-7fc5">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="amount" remarks="" uid="13ed0e:11d774ed92c:-7fc4">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
|
||
|
<variant type-name-pattern="DOUBLE"/>
|
||
|
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
|
||
| ... | ... | |
|
</column>
|
||
|
</column-list>
|
||
|
<primary-key alias="" name="PK_MONEY_TRANSFERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fcb">
|
||
|
<primary-key-description/>
|
||
|
<primary-key-description></primary-key-description>
|
||
|
<primary-key-column name="id"/>
|
||
|
</primary-key>
|
||
|
<unique-key-list/>
|
||
|
<foreign-key-list>
|
||
|
<foreign-key alias="" name="FK_money_transfers_1" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13ed0e:11d774ed92c:-7f43">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="41" y="0"/>
|
||
|
<fk-fig-target-terminal x="32" y="97"/>
|
||
| ... | ... | |
|
<foreign-key-column column-name="origin_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_money_transfers_2" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13ed0e:11d774ed92c:-7e7f">
|
||
|
<foreign-key-description/>
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-source-terminal x="130" y="4"/>
|
||
|
<fk-fig-target-terminal x="122" y="94"/>
|
||
| ... | ... | |
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="destination_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_transfers_3" on-delete="" on-update="" referenced-key="PK_USERS_PRIMARY" referenced-table="users" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7b9e">
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-bendpoint-list/>
|
||
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="user_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_transfers_4" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7b67">
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-bendpoint-list/>
|
||
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
<foreign-key alias="" name="FK_transfers_5" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-78c5">
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-bendpoint-list/>
|
||
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="destination_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
</foreign-key-list>
|
||
|
<index-list>
|
||
|
<index alias="" name="from" remarks="" uid="13ed0e:11d774ed92c:-7fc3" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="origin_id" sort="ASC"/>
|
||
|
</index>
|
||
|
<index alias="" name="to" remarks="" uid="13ed0e:11d774ed92c:-7fc2" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="destination_id" sort="ASC"/>
|
||
|
</index>
|
||
|
</index-list>
|
||
|
</table>
|
||
|
<table alias="" name="users" remarks="" uid="13ed0e:11d774ed92c:-7fc1">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="-1" width="-1" x="-63" y="236"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="-1" width="-1" x="-59" y="333"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="member_id" remarks="" uid="13ed0e:11d774ed92c:-7fbf">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT UNSIGNED">
|
||
|
<variant type-name-pattern="INT UNSIGNED"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fbe">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fbd">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="middle_name" remarks="" uid="13ed0e:11d774ed92c:-7fbc">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="60" decimal-digits="0" default-value="" mandatory="false" name="surname" remarks="" uid="13ed0e:11d774ed92c:-7fbb">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="false" name="pre_title" remarks="" uid="13ed0e:11d774ed92c:-7fba">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="post_title" remarks="" uid="13ed0e:11d774ed92c:-7fb9">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="birthday" remarks="" uid="13ed0e:11d774ed92c:-7fb8">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
|
||
|
<variant type-name-pattern="DATE"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="false" name="phone" remarks="" uid="13ed0e:11d774ed92c:-7fb7">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="60" decimal-digits="0" default-value="" mandatory="false" name="email" remarks="" uid="13ed0e:11d774ed92c:-7fb6">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fb5">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="password" remarks="" uid="13ed0e:11d774ed92c:-7fb4">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="7" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fb3">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="1111" literal-prefix="'" literal-suffix="'" name="ENUM" selected-variant-pattern="ENUM(7)">
|
||
|
<variant type-name-pattern="ENUM(7)"/>
|
||
|
<variant type-name-pattern="ENUM('%1')"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="web_messages_types" remarks="" uid="13ed0e:11d774ed92c:-7fb2">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="email_messages_types" remarks="" uid="13ed0e:11d774ed92c:-7fb1">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7fb0">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="240" decimal-digits="0" default-value="all" mandatory="true" name="aro_section_value" remarks="" uid="13ed0e:11d774ed92c:-7faf">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
|
||
|
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
|
||
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="aro_order_value" remarks="" uid="13ed0e:11d774ed92c:-7fae">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="aro_hidden" remarks="" uid="13ed0e:11d774ed92c:-7fad">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</column>
|
||
|
</column-list>
|
||
|
<primary-key alias="" name="PK_USERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fc0">
|
||
|
<primary-key-description/>
|
||
|
<primary-key-description></primary-key-description>
|
||
|
<primary-key-column name="id"/>
|
||
|
</primary-key>
|
||
|
<unique-key-list/>
|
||
|
<foreign-key-list/>
|
||
|
<foreign-key-list>
|
||
|
<foreign-key alias="" name="FK_users_1" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7c0d">
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-bendpoint-list/>
|
||
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
|
||
|
</foreign-key>
|
||
|
</foreign-key-list>
|
||
|
<index-list>
|
||
|
<index alias="" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fac" unique="true">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="login" sort="ASC"/>
|
||
|
</index>
|
||
|
<index alias="" name="belogs_to_member" remarks="" uid="13ed0e:11d774ed92c:-7fab" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="member_id" sort="ASC"/>
|
||
|
</index>
|
||
|
<index alias="" name="email" remarks="" uid="13ed0e:11d774ed92c:-7faa" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="email" sort="ASC"/>
|
||
|
</index>
|
||
|
<index alias="" name="phone" remarks="" uid="13ed0e:11d774ed92c:-7fa9" unique="false">
|
||
|
<index-description/>
|
||
|
<index-description></index-description>
|
||
|
<index-column name="phone" sort="ASC"/>
|
||
|
</index>
|
||
|
</index-list>
|
||
|
</table>
|
||
|
<table alias="" name="works" remarks="" uid="13ed0e:11d774ed92c:-7fa8">
|
||
|
<table-description/>
|
||
|
<table-figure-bounds height="-1" width="-1" x="258" y="367"/>
|
||
|
<table-description></table-description>
|
||
|
<table-figure-bounds height="-1" width="-1" x="353" y="610"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fa6">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="user_id" remarks="" uid="13ed0e:11d774ed92c:-7fa5">
|
||
|
<column-description/>
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
| ... | ... | |
|
</data-type>
|
||
|
</column>
|
||
|
<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="description" remarks="" uid="13ed0e:11d774ed92c:-7fa4">
|
||
|
<column-description/>
|
||
Také k dispozici: Unified diff
Pridan diagram zarizeni. Oprava chyby v pridavani bankovnich uctu. Exportovaci funkce prevedeny do noveho kontroleru export.