FreenetIS

'back to credit accounts' => 'Zpět na kreditní účty',

'credit' => 'Kredit',

'current credit' => 'Současný kredit',

'deduct' => 'Odečíst',

'deduction of membership fees' => 'Odečtení členských příspěvků',

'fees have been successfully deducted' => 'Členské příspěvky byly úspěšně odečteny.',

'monthly membership fee' => 'Měsíční členský příspěvek',

'number of months' => 'Počet měsíců',

'project accounts' => 'Projektové účty',

/*

a.id, a.name AS aname, a.comment,

CONCAT(ba.account_nr, '/', ba.bank_nr) AS account_number,

WHERE aa.id = ".Account_attribute_Model::$bank." AND a.member_id = '1'");

*/

return self::$db->query('SELECT q3.id, a.name, a.comment,

CONCAT(ba.account_nr, \'/\', ba.bank_nr) AS account_number,

q3.credit FROM

(SELECT id, member_id, (inbound - outbound) as credit FROM

(SELECT q1.id, q1.member_id, IFNULL(sum(amount),0) as inbound, outbound FROM

(SELECT a.id, member_id, IFNULL( sum( amount ) , 0 ) AS outbound

FROM accounts a

LEFT JOIN account_attributes aa ON a.account_attribute_id = aa.id

LEFT JOIN money_transfers mt ON a.id = mt.origin_id

WHERE aa.id = '.Account_attribute_Model::$bank.'

GROUP BY a.id) AS q1

LEFT JOIN money_transfers ON q1.id = money_transfers.destination_id GROUP BY q1.id) AS q2

) AS q3

LEFT JOIN accounts a ON q3.id = a.id

LEFT JOIN bank_accounts ba ON a.id = ba.account_id

');

WHERE aa.id = ".Account_attribute_Model::$credit." AND aa.id < ".Account_attribute_Model::$bank_debts);

* It gets all credit accounts from database including member name and credit.

public function get_credit_accounts($limit_from = 0, $limit_results = 20, $order_by = 'aid', $order_by_direction = 'desc')

return self::$db->query('SELECT q3.id, a.name AS aname, a.comment, m.name AS mname,

q3.credit FROM

(SELECT id, member_id, (inbound - outbound) as credit FROM

(SELECT q1.id, q1.member_id, IFNULL(sum(amount),0) as inbound, outbound FROM

(SELECT a.id, member_id, IFNULL( sum( amount ) , 0 ) AS outbound

FROM accounts a

LEFT JOIN account_attributes aa ON a.account_attribute_id = aa.id

LEFT JOIN money_transfers mt ON a.id = mt.origin_id

WHERE aa.id = '.Account_attribute_Model::$credit.'

GROUP BY a.id) AS q1

LEFT JOIN money_transfers ON q1.id = money_transfers.destination_id GROUP BY q1.id) AS q2

) AS q3

LEFT JOIN members m ON q3.member_id = m.id

LEFT JOIN accounts a ON q3.id = a.id

ORDER BY '.$order_by.' '.$order_by_direction.'

LIMIT '.$limit_from.','.$limit_results);

* It gets count of credit accounts.

* @return unknown_type

*/

public function get_credit_accounts_count()

{

$count = self::$db->query('SELECT COUNT(id) AS total

FROM accounts a

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

GROUP BY id'

);

return $count->current()->total;

}

/**

* @author Jiri Svitak

// there should be information about where to return to - credit or project accounts?

//$grid->add_new_button(url_lang::base().'accounts/doubleentry_accounts', url_lang::lang('texts.Back to the double-entry accounts'));

url::redirect(url_lang::base().'accounts/credit_accounts');

$acc_grid->order_field('credit')->label(url_lang::lang('texts.Credit'));

* It shows credit accounts of members.

function credit_accounts($limit_results = 50, $order_by = 'id', $order_by_direction = 'DESC')

{

// to do - correct access rights

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

// Controller::Error(1);

// gets grid settings

if (is_numeric($this->input->get('record_per_page')))

$limit_results = (int) $this->input->get('record_per_page');

// to do - correct allowed order type array

$allowed_order_type = array('id', 'origin_id', 'destination_id', 'timestamp', 'amount', 'constant_symbol', 'specific_symbol', 'name', 'date_time', 'fee_transfer_id', 'trans_type', 'text');

if (!in_array(strtolower($order_by),$allowed_order_type))

$order_by = 'id';

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

$order_by_direction = 'asc';

$account_model = new Account_Model();

$total_accounts = $account_model->get_credit_accounts_count();

$url_array = explode('/', trim(url::current(), '/'));

$sql_offset = (isset($url_array[8])) ? (int) ($url_array[8] - 1) * $limit_results : 0;

unset($url_array);

$sql_offset = ($sql_offset>$total_accounts) ? 0 : $sql_offset;

$accounts = $account_model->get_credit_accounts($sql_offset, (int)$limit_results, $order_by, $order_by_direction);

$grid = new Grid(url_lang::base().'accounts',

null, array(

'selector_increace' => 50, // increace

'base_url' => Config::item('locale.lang').'/accounts/credit_transfers/'.$limit_results.'/'.$order_by.'/'.$order_by_direction ,

'total_items' => $total_accounts, // use db count query here of course

$grid->add_new_button(url_lang::base().'accounts/deduct_fees', url_lang::lang('texts.Deduction of membership fees'));

$grid->order_field('id')->label('ID');

$grid->order_field('aname')->label(url_lang::lang('texts.Account name'));

$grid->order_field('comment')->label(url_lang::lang('texts.Comment'));

$grid->order_field('mname')->label(url_lang::lang('texts.Member name'));

$grid->order_field('credit')->label(url_lang::lang('texts.Credit'));

$grid->action_field('id')->label(url_lang::lang('texts.Transfers'))->url(url_lang::base().'money_transfers/show_by_doubleentry_account')->action(url_lang::lang('texts.Show'));

$grid->datasource($accounts);

$view->header->title = url_lang::lang('texts.Credit accounts');

$view->content = new View('accounts/credit');

$view->content->grid = $grid;

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

/**

* Form for deducting membership fees.

* @return unknown_type

*/

function deduct_fees()

{

// to do - access rights

//if (!$this->acl_check_new(get_class($this),'members')) Controller::error(1);

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

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

$form->date('from')->label(url_lang::lang('texts.Date from').':')->years(date('Y')-10, date('Y'))->rules('required');

$form->input('months')->label(url_lang::lang('texts.Number of months').':')->rules('required|valid_numeric');

$form->input('fee')->label(url_lang::lang('texts.Monthly membership fee').':')->rules('required|valid_numeric');

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

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

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

if ($form->validate())

{

$form_data = $form->as_array();

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

{

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

}

$mt = new Money_transfer_Model();

$member_model = new Member_Model();

$account_model = new Account_Model();

$credit_accounts = $account_model->select('id')

->where('account_attribute_id', Account_attribute_Model::$credit)->find_all();

$oa = $account_model->select('id')

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

$save_successful = true;

foreach($credit_accounts as $ca)

{

$member->clear();

$mt->clear();

$mt->origin_id = $ca->id;

$mt->destination_id = $oa->id;

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

$mt->text = $form_data['text'];

$mt->amount = $form_data['fee'] * $form_data['months'];

if (!$mt->save())

$save_successful = false;

}

if ($save_successfull)

{

$this->session->set_flash('message', url_lang::lang('texts.Fees have been successfully deducted.'));

url::redirect(url_lang::base().'accounts/credit_accounts');

}

else

{

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

}

}

else

{

$view = new View('template');

$view->header = new View('base/header');

$view->header->title = url_lang::lang('texts.Deduction of membership fees');

$view->header->menu = Controller::render_menu();

$view->content = new View('accounts/deduct_fees');

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

$view->footer = new View('base/footer');

$view->render(TRUE);

}

}

//if (!$this->acl_check_view('Settings_Controller','fees'))

// Controller::Error(1);

//if (!$this->acl_check_new('Settings_Controller','fees'))

// Controller::error(1);

<li>'.html::anchor(url_lang::base().'accounts/credit_accounts', url_lang::lang('texts.Credit accounts')).'</li>

<li>'.html::anchor(url_lang::base().'accounts/project_accounts', url_lang::lang('texts.Project accounts')).'</li>

<h2>

<?php echo url_lang::lang('texts.Credit accounts')?>

</h2>

<?php echo $message ? '<div class="message">'.$message.'</div>' : '' ?>

<br />

<?php echo $grid ?>

<h2><?php echo url_lang::lang('texts.Deduction of membership fees'); ?></h2>

<br />

<?php echo html::anchor(url_lang::base().'accounts/credit_accounts',url_lang::lang('texts.Back to credit accounts'))?>

<br />

<br />

<?php echo $form?>