FreenetIS

'do you want to end membership of this member' => 'Chcete ukončit členství tohoto člena',

'error - cant end membership' => 'Chyba - nelze ukončit členství.',

'if you were redirected, wait and redirection will stop in one minute' => 'Pokud jste byli přesměrováni, počkejte a přesměrování do jedné minuty skončí.',

'membership of the member has been ended' => 'Členství člena bylo ukončeno.',

public function get_bank_transfers($ba_id = null, $limit_from = 0, $limit_results = 20, $order_by = 'id', $order_by_direction = 'DESC', $filter_values = array())

$where = '';

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

{

if ($key != 'submit')

{

$where .= ' AND '.$key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';

}

}

IF (bt.destination_id = $ba_id, FALSE, TRUE) AS trans_type,

ba.account_nr, ba.bank_nr,

LEFT JOIN bank_accounts ba ON ba.id = IF (bt.origin_id = $ba_id, bt.destination_id, bt.origin_id)

WHERE (bt.origin_id = $ba_id OR bt.destination_id = $ba_id)

$where

ORDER BY $order_by $order_by_direction

LIMIT $limit_from, $limit_results"

public function count_bank_transfers($ba_id, $filter_values = array())

$where = '';

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

{

if ($key != 'submit')

{

$where .= ' AND '.$key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';

}

}

LEFT JOIN bank_accounts ba ON ba.id = IF (bt.origin_id = $ba_id, bt.destination_id, bt.origin_id)

LEFT JOIN transfers t ON t.id = bt.transfer_id

WHERE bt.origin_id = $ba_id OR bt.destination_id = $ba_id

$where"

public function get_transfers($account_id = null, $limit_from = 0, $limit_results = 20, $order_by = 't.id', $order_by_direction = 'ASC', $filter_values = array())

$where = '';

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

{

if ($key != 'submit')

{

$where .= ' AND '.$key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';

}

}

$where

public function count_transfers($account_id = null, $filter_values = array())

$where = '';

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

{

if ($key != 'submit')

{

$where .= ' AND '.$key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';

}

}

return self::$db->query("SELECT COUNT(*) AS total

WHERE t.origin_id = $account_id OR t.destination_id = $account_id

$where"

)->current()->total;

// address point

// member type string

// member type

$enum_type_model = new Enum_type_Model();

$former_member = $member_data->member_type == 'Former member';

// contacts of main user of member

$model_contacts = new Contact_Model();

$contacts = $model_contacts->find_all_by_user_id($member_data->id);

// users of member

// view

$view->content->former = $former_member;

$types = $enum_types->get_values(Enum_type_Model::$member_type_id);

unset($types[$enum_types->get_type_id('Former member')]);

/*

*/

/*

*/

* Function ends membership of member.

* @param $member_id

* @return unknown_type

*/

function end_membership($member_id = null)

{

if (!isset($member_id))

Controller::warning(PARAMETER);

$member = new Member_Model($member_id);

if ($member->id == 0)

Controller::error(RECORD);

if (!$this->acl_check_edit(get_class($this), 'members', $member_id))

Controller::error(ACCESS);

// form

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

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

$form->date('leaving_date')->label(url_lang::lang('texts.Leaving date'));

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

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

// validation

if ($form->validate())

{

$form_data = $form->as_array();

$member->leaving_date = date('Y-m-d', $form_data['leaving_date']);

$enum_type_model = new Enum_type_Model();

$member->type = $enum_type_model->get_type_id('Former member');

if ($member->save())

$this->session->set_flash('message', url_lang::lang('texts.Membership of the member has been ended.'));

else

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

url::redirect(url_lang::base().'members/show/'.(int)$member_id);

}

$headline = url_lang::lang('texts.End membership');

$view = new View('main');

$view->title = $headline;

$view->content = new View('form');

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

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

$view->content->link_back = html::anchor(url_lang::base().'members/show/'.$member_id,url_lang::lang('texts.Back to the member'));

$view->render(TRUE);

}

/**

new Table_Form_Item('text','surname','Surname'),

new Table_Form_Item('text','name','Name'),

/**

* This controller handles double-entry transfers and special actions with transfers like deducting fees etc.

*

* @author Jiri Svitak

*

*/

* It shows all double-entry transfers. They are shown in day book.

function show_all($limit_results = 500, $order_by = 'datetime', $order_by_direction = 'desc', $page_word = null, $page = 1)

* It shows transfers of credit account.

function show_by_account($account_id = NULL, $limit_results = 500, $order_by = 'datetime', $order_by_direction = 'desc', $page_word = null, $page = 1)

// creates fields for filtering

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

new Table_Form_Item('text', 'name', 'Counteraccount'),

new Table_Form_Item('text', 'datetime', 'Date and time'),

"tr",

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

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

"tr",

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

)

);

$arr_gets = array();

foreach ($this->input->get() as $key=>$value)

$arr_gets[] = $key.'='.$value;

$query_string = '?'.implode('&',$arr_gets);

$total_transfers = $transfer_model->count_transfers($account_id, $filter->values());

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

'url_array_ofset' => 1,

'query_string' => $query_string,

'filter' => $filter->view

));

} // end of show_by_account function

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

* @param $transfer_id

* @return unknown_type

*/

function show($transfer_id = null)

{

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

Controller::error(ACCESS);

if (!isset($transfer_id))

Controller::warning(PARAMETER);

$account_model = new Account_Model();

$transfer_model = new Transfer_Model();

$transfer = $transfer_model->get_transfer($transfer_id);

if (!is_object($transfer))

Controller::error(RECORD);

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

$dependent_transfers = $transfer_model->get_dependent_transfers($transfer->id);

// bank transfer is only assigned to transfer from member fees account to account of association

$member_fees = ORM::factory('account')->find_by_account_attribute_id(Account_attribute_Model::$member_fees);

$bt_model = ORM::factory('bank_transfer')->find_by_transfer_id($transfer->id);

if ($transfer->oa_id == $member_fees->id && is_object($bt_model) && $bt_model->id != 0)

$bt = $bt_model->get_bank_transfer($transfer_id);

$headline = url_lang::lang('texts.Detail of transfer number').' '.$transfer->id;

$view = new View('main');

$view->title = $headline;

$view->content = new View('transfers/show');

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

$view->content->transfer = $transfer;

$view->content->dependent_transfers = $dependent_transfers;

$view->content->bt = $bt;

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

$view->render(TRUE);

}

/**

* @author Jiri Svitak

* Function edits double-entry transfers. They should not be edited.

* Wrong transfer should be solved by new transfer.

* Function deducts member fees. This version creates one transfer per month.

* This version is still buggy and uncomplete

/*

*/

* still buggy

/*

*/

* Function deducts member fees. This version creates one deducting transfer per year and its value

* can be recalculated (for example every month).

* Functional and debugged version.

* @author Jiri Svitak

* @author Jiri Svitak

* @author Jiri Svitak

$content = url_lang::lang('texts.System has not found reason to this redirection, this should not happen in ordinary running.').' '.

url_lang::lang('texts.If you were redirected, wait and redirection will stop in one minute.');

// creates fields for filtering unidentified transfers

$filter=new Table_Form(url_lang::base()."bank_transfers/show_by_bank_account/$bank_account_id", "get", array(

new Table_Form_Item('text', 'datetime', 'Date and time'),

new Table_Form_Item('text', 'name', 'Account name'),

"tr",

new Table_Form_Item('text', 'variable_symbol', 'Variable symbol'),

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

"tr",

new Table_Form_Item('text', 'account_nr', 'Account number'),

new Table_Form_Item('text', 'bank_nr', 'Bank code'),

"tr",

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

)

);

$arr_gets = array();

foreach ($this->input->get() as $key=>$value)

$arr_gets[] = $key.'='.$value;

$query_string = '?'.implode('&',$arr_gets);

// model

$total_bank_transfers = $bt_model->count_bank_transfers($bank_account_id, $filter->values());

$bts = $bt_model->get_bank_transfers($bank_account_id, $sql_offset, (int)$limit_results, $order_by, $order_by_direction, $filter->values());

'url_array_ofset' => 1,

'query_string' => $query_string,

'filter' => $filter->view

));

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

$grid->order_field('bank_nr')->label(url_lang::lang('texts.Bank code'));

$arr_subnets[$subnet->id] = $subnet->name.': '.$subnet->net_str.'/'.$subnet->mask;

$filename = url_lang::lang('texts.Members').'.csv';

$items = $subnet_model->get_items_of_subnet($id);

$filename = $subnet_model->name.'.csv';

if (!$former && $this->acl_check_edit('Members_Controller', 'members', $member_data->member_id))

if ($member_data->member_id != 1)

{

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

$links[] = html::anchor(url_lang::base().'transfers/show_by_account/'.$account->id, url_lang::lang('texts.Show his transfers'));

if (!$former)

{

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

$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 ($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').'\')'));

if ($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'), array('onclick' => 'return potvrd(\''.url_lang::lang('texts.Do you want to end membership of this member').'\')'));

}

}

if (!$former && $this->acl_check_edit('Members_Controller', 'redirect', $member_data->member_id))

if(!$former && $this->acl_check_edit('Users_Controller','users',$member_data->member_id))

$links[] = html::anchor(url_lang::base().'works/show_by_user/'.$member_data->id,url_lang::lang('texts.Show his works'));

if (!$former)

{

if ($this->acl_check_edit('Users_Controller', 'password', $member_data->id))

$links[] = html::anchor(url_lang::base().'users/change_password/'.$member_data->id, url_lang::lang('texts.Change password'));

if ($this->acl_check_edit('Users_Controller', 'application_password', $member_data->id))

$links[] = html::anchor(url_lang::base().'users/change_application_password/'.$member_data->id, url_lang::lang('texts.Change application password'));

}