FreenetIS

'near number %s wasnt found data for testing in group %s' => 'U čísla %s nebyly nalezena data pro kontrolu služeb ve skupině %s',

'near number %s differs from price of services: %s\ncalculated price: %s\ninvoiced price: %s' => 'Poblíž čísla %s se odlišují ceny služeb: %s\nVypočtená cena: %s\nFakturovaná cena: %s',

'netmask' => 'Maska',

'network address does not match any address ranges' => 'Síťová adresa neodpovídá žádnému adresnímu rozsahu.',

'network address does not match the mask' => 'Síťová adresa neodpovídá zadané masce.',

'network settings' => 'Nastavení sítě',

class Account_Model extends ORM

{

// groups of double-entry accounts

public static $project = 3;

public static $other = 4;

//protected $has_one = array();

protected $has_many = array('transfers');

protected $belongs_to = array('member', 'account_attribute', 'comments_thread');

$where .= 'account_attribute_id = '.Account_attribute_Model::$credit;

else

$where .= 'account_attribute_id <> '.Account_attribute_Model::$project.

foreach ($filter_values as $key => $value)

{

if ($key == 'name')

$where"

)->current()->total;

}

/**

* Function gets some double-entry accounts. Used in dropdown to select destination account.

* @return unknown_type

public function get_some_doubleentry_account_names($origin=null, $account_attribute_id=null)

{

if ($origin !== null) {

AND (a.account_attribute_id = ".Account_attribute_Model::$credit."

OR a.account_attribute_id = ".Account_attribute_Model::$operating."

OR a.account_attribute_id = ".Account_attribute_Model::$project.")";

else $cond_origin="";

$where = ($account_attribute_id) ? 'WHERE a.account_attribute_id='.$account_attribute_id : '';;

return $this->db->query("SELECT a.id, a.name, a.member_id, a.account_attribute_id,

concat(t.town, '-', t.quarter, ' ', p.street_number)) AS addr

JOIN address_points p ON m.address_point_id=p.id

JOIN towns t ON t.id=p.town_id $where"

);

}

/**

* It gets balance of account. It subtracts all outbound transfers from all incoming transfers.

* @author Jiri Svitak

FROM transfers

WHERE origin_id = $account_id

) a, transfers t

")->current()->credit;

return $credit;

}

/**

* @author Tomas Dulik

* This function creates new record in the table "accounts".

$account = new Account_Model();

$account->account_attribute_id=$attribute_id;

$account->name=$name;

$account->save();

return $account;

}

/**

* Returns all accounts to deduct fee in date

*

");

}

/**

* Gets information important to correctly deduct fees. Used for recounting

* member fees of one member (one account).

WHERE mi.from <= '$date' AND mi.to > '$date'

) mi ON m.id = mi.member_id

WHERE a.id = $account_id AND a.account_attribute_id = ".Account_attribute_Model::$credit."

}

/**

* Function gets all members to deduct entrance fees.

* @author Jiri Svitak

JOIN members m ON a.member_id = m.id AND m.id <> 1

LEFT JOIN transfers t ON t.origin_id = a.id AND t.type = ".Transfer_Model::$deduct_entrance_fee."

WHERE a.account_attribute_id = ".Account_attribute_Model::$credit."

}

/**

* Gets amount of deducted entrance fees of member's credit account.

* Used for deducting entrance fees with instalment.

SELECT IFNULL(SUM(t.amount), 0) AS amount

FROM transfers t

WHERE t.origin_id = $account_id AND t.type = ".Transfer_Model::$deduct_entrance_fee

}

/**

* Gets information about one credit account, used for recounting entrance fee with or without instalment.

* @author Jiri Svitak

FROM accounts a

JOIN members m ON a.member_id = m.id AND m.id <> 1

WHERE a.account_attribute_id = ".Account_attribute_Model::$credit." AND a.id = $account_id

}

/**

throw new Exception();

return $transfers_count;

}

/**

* Finds accounts of members who have at least one device to repay.

* @author Jiri Svitak

HAVING total_price > 0

");

}

/**

* Gets actually repaied amount of prices of all member's devices.

* @author Jiri Svitak

WHERE t.origin_id = $account_id AND t.type = ".Transfer_Model::$deduct_device_fee

)->current()->amount;

}

/**

* Gets list of devices with repayments. Devices are ordered ascending by their buy date.

* @author Jiri Svitak

}

*

* @author Jiri Svitak

* @license <http://www.gnu.org/licenses/> GNU/GPLv3

*/

class Transfers_Controller extends Controller

{

{

url::redirect(url_lang::base().'transfers/show_all');

}

/**

* @author Jiri Svitak

* @param $limit_results

* @param $order_by

$order_by = 'id';

if (strtolower($order_by_direction) != 'asc' && strtolower($order_by_direction) != 'desc')

$order_by_direction = 'desc';

// creates fields for filtering

$filter=new Table_Form(url_lang::base()."transfers/show_all", "get", array(

new Table_Form_Item('text', 'oa_name', 'Origin account'),

new Table_Form_Item('text', 'amount', 'Amount'),

"tr",

new Table_Form_Item('text', 'text', 'Text'),

"tr",

"td", new Table_Form_Item('submit', 'submit', 'Filter')

)

$model_transfer = new Transfer_Model();

$total_transfers = $model_transfer->count_all_transfers($filter->values());

if (($sql_offset = ($page - 1) * $limit_results) > $total_transfers)

$alltransfers = $model_transfer->get_all_transfers($sql_offset, (int)$limit_results, $order_by, $order_by_direction, $filter->values());

$headline = url_lang::lang('texts.Day book');

$grid = new Grid(url_lang::base().'transfers', null, array(

$view->render(TRUE);

}

/**

* It shows transfers of credit account.

* @author Jiri Svitak

if (count($filter_values) == 0)

$filter_values['type'] = Transfer_Model::$inbound_and_outbound;

// transfers on account

if (($sql_offset = ($page - 1) * $limit_results) > $total_transfers)

$transfers = $transfer_model->get_transfers($account_id, $sql_offset, (int)$limit_results, $order_by, $order_by_direction, $filter_values);

// total amount of inbound and outbound transfers and total balance

$balance = $inbound = $outbound = 0;

$view->content->transfers_grid = $transfers_grid;

if ($this->acl_check_view ('Members_Controller','comment',$account->member_id))

$view->content->comments_grid = $comments_grid;

$view->render(TRUE);

/**

* Function shows information of transfer including previous transfer if exists.

* @author Jiri Svitak

elseif ($da->member_id != 1)

$member_id = $da->member_id;

else

if (!$this->acl_check_view('Accounts_Controller', 'transfers', $member_id))

Controller::error(ACCESS);

// transfers dependent on this transfer, if this transfer is member fee payment

$view->content->message = $this->session->get_once('message');

$view->render(TRUE);

}

/**

* Adds transfers from single origin account.

* @todo set of accounts choosen by account_attribute_id, must be done by ajax

{

if (!isset($origin_account_id) || !is_numeric($origin_account_id))

Controller::warning(PARAMETER);

$origin_account = new Account_Model($origin_account_id);

if ($origin_account->id == 0)

Controller::error(RECORD);

if (!$this->acl_check_new('Accounts_Controller', 'transfers', $origin_account->member_id))

Controller::error(ACCESS);

// destination account, instead of origin one

$dst_accounts = $dst_account_model->get_some_doubleentry_account_names($origin_account_id);

foreach ($dst_accounts as $dst_account)

$arr_dst_accounts[$dst_account->id] = $dst_account->name.' '.$dst_account->id.' ('.$dst_account->addr.')';

//"$dst_account->name, $dst_account->addr - ".url_lang::lang('texts.Account ID')." $dst_account->id - "

//.url_lang::lang('texts.Member ID')." $dst_account->member_id - "

}

asort($arr_dst_accounts, SORT_LOCALE_STRING);

// default destination account

// array with only one origin account

$arr_orig_accounts[$origin_account->id] = $origin_account->name.' '.$origin_account->id;

// account attributes for types of accounts

//$form->dropdown('')->label(url_lang::lang('texts.Account type').':')->options($arr_attributes);

$form->dropdown('oname')->label(url_lang::lang('texts.Origin account (account name, account ID)').':')->options($arr_orig_accounts)->rules('required');

// destination account

$form->dropdown('account_type')->label(url_lang::lang('texts.Account type').':')->options($arr_attributes);

$form->dropdown('aname')->label(url_lang::lang('texts.Destination account (account name, account ID)').':')->options($arr_dst_accounts)->rules('required')->selected($operating->id);

// other information

$form->date('datetime')->label(url_lang::lang('texts.Date and time').':')->years(date('Y')-20, date('Y'))->rules('required');

$form->input('amount')->label(url_lang::lang('texts.Amount').':')->rules('required|valid_numeric')->callback(array($this, 'valid_amount_to_send'));

$form->input('text')->label(url_lang::lang('texts.Text').':')->rules('required');

$form->submit('submit')->value(url_lang::lang('texts.Send'));

if ($form->validate())

{

foreach($form_data as $key => $value)

{

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

}

url::redirect(url_lang::base().'transfers/show_by_account/'.$origin_account_id);

}

//if ($this->acl_check_view('Members_Controller','members', $origin_account->member_id))

// $links[] = html::anchor(url_lang::base().'members/show/'.$origin_account->member_id, url_lang::lang('texts.Back to the member'));

//$links[] = html::anchor(url_lang::base().'transfers/show_by_account/'.$origin_account_id, url_lang::lang('texts.Back to account transfers'));

$breadcrumbs = array();

$view->content->headline = $headline;

$view->content->form = $form->html();

$view->content->link_back = '';

}

/**

* Function adds transfers from one arbitrary account to another arbitrary account.

* @todo set of accounts choosen by account_attribute_id, must be done by ajax

function add()

{

if (!$this->acl_check_new('Accounts_Controller', 'transfers'))

$account_model = new Account_Model();

$accounts = $account_model->get_some_doubleentry_account_names();

$origin_accounts = $accounts;

{

$arr_dst_accounts[$dst_account->id] = $dst_account->name.' '.$dst_account->id.' ('.$dst_account->addr.')';

}

// array origin accounts for dropdown

// default destination account

$operating = ORM::factory('account')->where('account_attribute_id', Account_attribute_Model::$operating)->find();

// account attributes for types of accounts

//$form->dropdown('')->label(url_lang::lang('texts.Account type').':')->options($arr_attributes);

$form->dropdown('oname')->label(url_lang::lang('texts.Origin account (account name, account ID)').':')->options($arr_orig_accounts)->rules('required');

// destination account

//$form->dropdown('')->label(url_lang::lang('texts.Account type').':')->options($arr_attributes);

$form->dropdown('aname')->label(url_lang::lang('texts.Destination account (account name, account ID)').':')->options($arr_dst_accounts)->rules('required')->selected($operating->id);

// other information

$form->date('datetime')->label(url_lang::lang('texts.Date and time').':')->years(date('Y')-20, date('Y'))->rules('required');

// no amount on origin account is required, this arbitrary transfers should only admin or accountant of association who knows what is he doing

$form->input('amount')->label(url_lang::lang('texts.Amount').':')->rules('required|valid_numeric')->callback(array($this, 'valid_amount'));//->callback(array($this, 'valid_amount_to_send'));

$form->input('text')->label(url_lang::lang('texts.Text').':')->rules('required');

$form->submit('submit')->value(url_lang::lang('texts.Send'));

if ($form->validate())

{

foreach($form_data as $key => $value)

{

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

}

/**

* @author Jiri Svitak

* @param $transfer_id

* @return unknown_type

{

if (!isset($transfer_id))

Controller::warning(PARAMETER);

if (!$this->acl_check_edit('Accounts_Controller', 'transfers'))

Controller::error(ACCESS);

$transfer = new Transfer_Model($transfer_id);

$form = new Forge(url_lang::base().'transfers/edit/'.$transfer_id, '', 'POST', array('id' => 'article_form'));

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

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

$form->input('amount')->label(url_lang::lang('texts.Amount').':')->rules('required')->value($transfer->amount)->callback(array($this, 'valid_amount'));

$form->submit('submit')->value(url_lang::lang('texts.Edit'));

special::required_forge_style($form, ' *', 'required');

Transfer_Model::edit_transfer($transfer_id, htmlspecialchars($form_data['text']), htmlspecialchars($form_data['amount']));

$db->transaction_commit();

$this->session->set_flash('message', url_lang::lang('texts.Transfer has been successfully updated.'));

}

catch (Exception $e)

{

}

}

/**

* Deducts fees of all members in one month. If deduct transfer for one month and

* account is found, then it is ignored and skipped.

$form->dropdown('month')->label(url_lang::lang('texts.Month').':')->rules('required')->options($arr_months)->selected($current_month)->callback(array($this, 'valid_default_fee'));

$form->submit('submit')->value(url_lang::lang('texts.Deduct'));

special::required_forge_style($form, ' *', 'required');

if ($form->validate())

{

// access rights

$db->transaction_rollback();

$this->session->set_flash('message', url_lang::lang('texts.Error - some fees have not been deducted.'));

}

}

else

{

$view->content->form = $form->html();

$view->content->link_back = html::anchor(url_lang::base().'transfers/show_all',url_lang::lang('texts.Back to day book'));

$view->render(TRUE);

}

/**

{

$db->transaction_rollback();

$this->session->set_flash('message', url_lang::lang('texts.Error - cant deduct entrance fee.'));

}

/**

* Recounts transfer of one member credit account.

* Used only in special cases, like changing entrance date.

if ($ca->entrance_fee == 0)

{

$this->session->set_flash('message', url_lang::lang('texts.Entrance fees have been successfully recalculated, %d transfers deleted, %d new transfers created.', array(1=>$deleted_transfers_count, 2=>$created_transfers_count)));

}

// entrance fee is not wholy paid, calculate debt

$debt = $ca->entrance_fee;

{

$db->transaction_rollback();

$this->session->set_flash('message', url_lang::lang('texts.Error - cant deduct entrance fee.'));

}

/**

* Deducts repayments of devices. Special devices, like wifi clients can be sold by association.

* This mechanism enables repayments of these devices in case that member has not enough money to

{

$db->transaction_rollback();

$this->session->set_flash('message', url_lang::lang('texts.Error - cant deduct device fee.'));

}

/**

* Function adds member fee payment by cash.

* @author Jiri Svitak

if (!$this->acl_check_new('Accounts_Controller', 'transfers'))

Controller::error(ACCESS);

$credit = ORM::factory('account')->where(array('member_id' => $member_id,

$accounts[$credit->id] = $credit->name;

// check if there is fee for payment, then new amount is calculated

$fee = $fee_model->get_by_date_type(date('Y-m-d'), 'transfer fee');

if (is_object($fee) && $fee->id)

$transfer_fee = $fee->fee;

else

$transfer_fee = 0;

$form = new Forge(url_lang::base().'transfers/add_member_fee_payment_by_cash/'.$member_id, '', 'POST', array('id' => 'article_form'));

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

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

$form->input('transfer_fee')->label(url_lang::lang('texts.Amount').':')->value($transfer_fee)->rules('valid_numeric')->callback(array($this, 'valid_fee'));

$form->input('fee_text')->label(url_lang::lang('texts.Text').':')->value(url_lang::lang('texts.Transfer fee'));

$form->submit('submit')->value(url_lang::lang('texts.Add'));

if ($form->validate())

{

foreach($form_data as $key => $value)

{

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

//$links[] = html::anchor(url_lang::base().'members/show/'.$member_id, url_lang::lang('texts.Back to the member'));

//$links[] = html::anchor(url_lang::base().'transfers/show_by_account/'.$credit->id, url_lang::lang('texts.Back to transfers of member'));

//$view->content->link_back = implode(' | ', $links);

}

}

/**

* Function validates amount of money to send from double-entry account.

* @param $input

$account_model = new Account_Model();

if ($input->value <= 0)

{

}

else if (!$this->acl_check_new('Accounts_Controller', 'transfers') && $account_model->get_account_balance($this->origin) < $input->value)

{

$input->add_error('required', url_lang::lang('texts.Error - not enough money on origin account.'));

}

}

/**

* Function validates amount of money in editing.

* @param $input

$input->add_error('required', url_lang::lang('texts.Error - amount has to be positive.'));

}

}

/**

* Function validates number of months in function deduct_fees.

* @param $input

$year = $this->input->post('year');

$month = $this->input->post('month');

$date = date('Y-m-d', mktime(0, 0, 0, $month, 15, $year));

// finds default fee

$fee_model = new Fee_Model();

$fee = $fee_model->get_default_fee_by_date_type($date, 'regular member fee');

$input->add_error('required', url_lang::lang('texts.For this month and year is not set default fee.'));

}

}

}

?>

// bad parameter

if (!$comments_thread_id || !is_numeric($comments_thread_id))

Controller::warning(PARAMETER);

$comments_thread = new Comments_thread_Model($comments_thread_id);

// comment thread doesn't exist

// access control

if (!$this->acl_check_view ('Members_Controller','comment',$parent->member_id))

Controller::error (ACCESS);

$link_back_url = url_lang::base().'transfers/show_by_account/'.$parent->id;

break;

case 'job':

<br />

<?php echo (isset($message)) ? '<div class="message">'.$message.'</div>' : ''; ?>

<?php echo $member_links ?>

<br />

<h3><?php echo url_lang::lang('texts.Users')?></h3>

<?php echo $users_grid ?>

<br />

<?php echo $voip_grid ?>

<br />

if ($permissions == NULL)

{

foreach ($this->db->query("SHOW GRANTS FOR CURRENT_USER") as $row)

{

$values = array_values(arr::from_object ($row));