Revize 393
Přidáno uživatelem Jiří Sviták před asi 15 roky(ů)
| freenetis/trunk/kohana/application/models/member.php | ||
|---|---|---|
|
return self::$db->query("SELECT m.id, a.id AS aid
|
||
|
FROM members m
|
||
|
JOIN accounts a ON a.member_id = m.id
|
||
|
AND a.account_attribute_id = ".Account_attribute_Model::$credit."
|
||
|
WHERE m.entrance_fee_left <> 0
|
||
|
");
|
||
|
}
|
||
| freenetis/trunk/kohana/application/models/account.php | ||
|---|---|---|
|
return self::$db->query("SELECT id
|
||
|
FROM accounts
|
||
|
WHERE member_id = $member_id AND account_attribute_id = ".Account_attribute_Model::$credit)
|
||
|
->current();
|
||
|
->current()->id;
|
||
|
}
|
||
|
|
||
|
/**
|
||
| freenetis/trunk/kohana/application/controllers/members.php | ||
|---|---|---|
|
->callback(array($this, 'valid_email'))->value($member_data->email);
|
||
|
|
||
|
$form->group('')->label(url_lang::lang('texts.Account information'));
|
||
|
// to do
|
||
|
//if ($this->acl_check_edit(get_class($this),'en_fee',$member_id) )// && ($member_data->entrance_fee == $member_data->entrance_fee_left))
|
||
|
// $form->input('entrance_fee')->label(url_lang::lang('texts.Entrance fee').':')->rules('valid_numeric')->value($member_data->entrance_fee);
|
||
|
if ($this->acl_check_edit(get_class($this),'en_fee',$member_id) && ($member_data->entrance_fee == $member_data->entrance_fee_left))
|
||
|
$form->input('entrance_fee')->label(url_lang::lang('texts.Entrance fee').':')->rules('valid_numeric')->value($member_data->entrance_fee);
|
||
|
if ($this->acl_check_edit(get_class($this),'debit',$member_id))
|
||
|
$form->input('debt_payment_rate')->label(url_lang::lang('texts.Debit payment rate').':')->rules('valid_numeric')->value($member_data->debt_payment_rate);
|
||
|
|
||
| ... | ... | |
|
$member_data->qos_ceil = $form_data['qos_ceil'];
|
||
|
if ($this->acl_check_edit(get_class($this),'qos_rate',$member_id))
|
||
|
$member_data->qos_rate = $form_data['qos_rate'];
|
||
|
//if ($this->acl_check_edit(get_class($this),'en_fee',$member_id))
|
||
|
// $member_data->entrance_fee = $form_data['entrance_fee'];
|
||
|
//if ($this->acl_check_edit(get_class($this),'en_fee_left',$member_id))
|
||
|
// $member_data->entrance_fee_left = $form_data['entrance_fee'];
|
||
|
if ($this->acl_check_edit(get_class($this),'en_fee',$member_id))
|
||
|
$member_data->entrance_fee = $form_data['entrance_fee'];
|
||
|
if ($this->acl_check_edit(get_class($this),'en_fee_left',$member_id))
|
||
|
$member_data->entrance_fee_left = $form_data['entrance_fee'];
|
||
|
if ($this->acl_check_edit(get_class($this),'debit',$member_id))
|
||
|
$member_data->debt_payment_rate = $form_data['debt_payment_rate'];
|
||
|
|
||
| freenetis/trunk/kohana/application/controllers/transfers.php | ||
|---|---|---|
|
$form->group('')->label(url_lang::lang('texts.Transfer'));
|
||
|
$form->dropdown('aname')->label(url_lang::lang('texts.Destination credit account').':')->options($arr_accounts)->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'));
|
||
|
$form->input('text')->label(url_lang::lang('texts.Text'))->rules('required');
|
||
|
$form->submit('submit')->value(url_lang::lang('texts.Send'));
|
||
|
special::required_forge_style($form, ' *', 'required');
|
||
|
if ($form->validate())
|
||
| ... | ... | |
|
if (isset($member_id))
|
||
|
{
|
||
|
$member = new Member_Model($member_id);
|
||
|
$transfer->origin_id = $account_model->get_credit_account_of_member($member_id)->id;
|
||
|
$transfer->origin_id = $account_model->get_credit_account_of_member($member_id);
|
||
|
$transfer->destination_id = $infrastructure->id;
|
||
|
$transfer->datetime = $member->entrance_date;
|
||
|
$transfer->creation_datetime = $creation_datetime;
|
||
| ... | ... | |
|
$member_model = new Member_Model();
|
||
|
$members = $member_model->get_all_members_to_deduct_entrance_fees();
|
||
|
$db = new Database();
|
||
|
// large amount of database inserts, transaction processing is necessary
|
||
|
$db->query("BEGIN;");
|
||
|
foreach($members as $m)
|
||
|
{
|
||
|
$member = ORM::factory($member_model, $m->id);
|
||
|
unset($member);
|
||
|
$member = new Member_Model($m->id);
|
||
|
$transfer->clear();
|
||
|
$transfer->origin_id = $account_model->get_credit_account_of_member($member->id)->id;
|
||
|
$transfer->origin_id = $m->aid;
|
||
|
$transfer->destination_id = $infrastructure->id;
|
||
|
$transfer->datetime = $member->entrance_date;
|
||
|
$transfer->creation_datetime = $creation_datetime;
|
||
| ... | ... | |
|
if (!$transfer->save())
|
||
|
$save_successful = false;
|
||
|
$member->entrance_fee_left = 0;
|
||
|
if (!$m->save())
|
||
|
if (!$member->save())
|
||
|
$save_successful = false;
|
||
|
}
|
||
|
if ($save_successful)
|
||
| ... | ... | |
|
}
|
||
|
url::redirect(url_lang::base().'transfers/show_all');
|
||
|
}
|
||
|
|
||
|
/*
|
||
|
// form
|
||
|
$form = new Forge(url_lang::base().'transfers/deduct_fees', '', 'POST', array('id' => 'article_form'));
|
||
|
$form->set_attr('class', 'form_class')->set_attr('method', 'post');
|
||
|
|
||
|
$form->submit('submit')->value(url_lang::lang('texts.Deduct'));
|
||
|
special::required_forge_style($form, ' *', 'required');
|
||
|
// validation
|
||
|
if ($form->validate())
|
||
|
{
|
||
|
|
||
|
|
||
|
}
|
||
|
else
|
||
|
{
|
||
|
$headline = url_lang::lang('texts.Deduction of entrance fees');
|
||
|
$view = new View('template');
|
||
|
$view->header = new View('base/header');
|
||
|
$view->header->title = $headline;
|
||
|
$view->header->menu = Controller::render_menu();
|
||
|
$view->content = new View('transfers/deduct_fees');
|
||
|
$view->content->headline = $headline;
|
||
|
$view->content->form = $form->html();
|
||
|
$view->content->message = $this->session->get_once('message');
|
||
|
$view->footer = new View('base/footer');
|
||
|
$view->render(TRUE);
|
||
|
}
|
||
|
*/
|
||
|
}
|
||
|
|
||
|
/**
|
||
Také k dispozici: Unified diff
Dodelano strhavani vstupnich prispevku.