FreenetIS

return self::$db->query('SELECT a.name AS aname, a.id AS aid, a.owner_id, mt. * , mt.id AS mtid, bi. * , IF( mt.destination_id = '.$account_id.', FALSE, TRUE ) AS trans_type

LEFT JOIN money_transfer_bank_infos bi ON bi.id = mt.bank_info_id

return self::$db->query('SELECT a.name AS aoname, a.id AS aoid, a.owner_id AS aoowner, a2.name AS adname, a2.id AS adid, a2.owner_id AS adowner, mt. * , mt.id AS mtid, bi. *

LEFT JOIN money_transfer_bank_infos bi ON bi.id = mt.bank_info_id

{

*/

public function get_all_money_transfers()

return self::$db->query('SELECT mt.id AS mtid, mt.timestamp, mt.text, mt.amount,

CONCAT(oba.account_nr, "/", oba.bank_nr),

CONCAT(dba.account_nr, "/", dba.bank_nr)

FROM money_transfers mt

LEFT JOIN money_transfer_bank_infos bi

ON mt.id = bi.transfer_id

JOIN accounts AS oa

ON da.id = dba.account_id

$user_data = new User_Model();

$member_data = new Member_Model();

$account_data = new Account_Model();

$account_data->type = 'analytic';

$account_data->name = $form_data['membername'];

$account_data->start_amount = $form_data['current_credit'];

//print_r($member_data);die();

$user_data->name = $form_data['name'];

$user_data->middle_name = $form_data['middle_name'];

$user_data->login = $form_data['login'];

$user_data->surname = $form_data['surname'];

$user_data->pre_title = $form_data['pre_title'];

$user_data->post_title = $form_data['post_title'];

$user_data->birthday = date("Y-m-d",$form_data['birthday']);

$user_data->phone = $form_data['phone'];

$user_data->email = $form_data['email'];

$user_data->password = sha1($form_data['passwd']);

$user_data->type="member";

$member_data->type = $form_data['type'];

$member_data->comment = $form_data['comment'];

$member_data->entrance_date = date("Y-m-d",$form_data['entrance_date']);

$member_data->name = $form_data['membername'];;

$member_data->street = $form_data['street'];

$member_data->street_number = $form_data['street_number'];

$member_data->town = $form_data['town'];

$member_data->ZIP_code = $form_data['zip_code'];

$member_data->qos_ceil = $form_data['qos_ceil'];

$member_data->qos_rate = $form_data['qos_rate'];

$member_data->entrance_fee = $form_data['entrance_fee'];

$member_data->entrance_fee_left = $form_data['entrance_fee_left'];

$member_data->debt_payment_rate = $form_data['debt_payment_rate'];

$member_data->current_credit = $form_data['current_credit'];

$member_data->must_pay_regular_fee = $form_data['must_pay_regular_fee'];

$member_saved = $member_data->save();

$user_data->member_id = $member_data->id;

$account_data->owner_id = $member_data->id;

$user_saved = $user_data->save();

Controller::insert_phpgacl($user_data->id,$user_data->surname.' '.$user_data->name,$user_data->login,$form_data['type']);

if ($member_saved && $user_saved && $account_data->save())

url::redirect(url_lang::base().'members/show/'.(int)$member_data->id);

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

$model_account= new Account_Model();

$model_account->where('type','analytic');

$model_account->find_by_owner_id($member_id);

$acc_name = $model_account->name;

$acc_id = $model_account->id;

$model_transfer = new Money_transfer_Model();

$total_transfers = $model_transfer->count_my_transfers($acc_id);

$transfers = $model_transfer->get_transfers($model_account->id,$sql_offset, (int)$limit_results, $order_by, $order_by_direction);

//$grid->add_new_button(url_lang::base().'accounts/new_transfer/'.$member_id, url_lang::lang('texts.New transfer'));

$model_account->clear();

$model_transfer->clear();

$model_account->where('type','project');

$project_accs = $model_account->find_all_by_owner_id($member_id);

$projects_acc_data = array();

foreach ($project_accs as $project)

$transfers = $model_transfer->get_transfers($project->id);

$projects_acc_data[$i]['name'] = $project->name;

$projects_acc_data[$i]['grid'] = $grid;

$projects_acc_data[$i]['credit'] = $model_transfer->count_credit($project->id)+(float)$project->start_amount;

$all_accounts = $model_account->find_all_by_owner_id($member_id);

$view->content->acc_name = $acc_name;

$view->content->acc_id = $acc_id;

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

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

$view->content->projects_acc = $projects_acc_data;

function trans_detail($trans_id = NULL, $member_id = NULL)

if (isset($trans_id) && isset($member_id))

if ($member_id == $_SESSION['member_id'])

{

if (!$this->gacl_class->acl_check('freenetis', 'view_own', 'all', $_SESSION['username'],get_class($this),'view_transfers')) Controller::error(1);

}

else

{

if (!$this->gacl_class->acl_check('freenetis', 'view_all', 'all', $_SESSION['username'],get_class($this),'view_all_transfers')) Controller::error(1);

}

$model_transfer = new Money_transfer_Model();

$transfer = $model_transfer->get_transfer($trans_id);

//$view->content->heading = "Úprava uživatele ".$data['row']['name']." ".$data['row']['surname'];

$account_data = new Account_Model;

$account_data->$key = htmlspecialchars($value);

$account_data->owner_id = $member_id;

if ($account_data->save())

function new_transfer($acc_id = NULL)

if (isset($acc_id))

$this->acc_id = $acc_id;

$model_account = new Account_Model($acc_id);

if ($model_account->owner_id == $_SESSION['member_id'])

{

if (!$this->gacl_class->acl_check('freenetis', 'new_own', 'all', $_SESSION['username'])) Controller::error(1);

}

else

{

if (!$this->gacl_class->acl_check('freenetis', 'new_all', 'all', $_SESSION['username'])) Controller::error(1);

}

$model_user = new User_Model;

$users = $model_user->select('member_id','name','surname','login')->orderby('surname, name')->where('type!=','user')->find_all();

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

$form->dropdown('username')->label(url_lang::lang('texts.Send to member').':')->options($arr_users)->onchange('ajax_get_accounts(this.value,'.$acc_id.')')->callback(array($this, 'callback_username'));

$model_transfer = new Money_transfer_Model();

$account_data->$key = htmlspecialchars($value);

$model_transfer->origin_id = $model_account->id;

$model_transfer->destination_id = $form_data['account'];

$model_transfer->text = $form_data['comment'];

$model_transfer->amount = (float)$form_data['amount'];

if ($model_transfer->save())

if ($model_account->type=='analytic')

$model_members = new Member_Model($model_account->owner_id);

$model_members->current_credit = (float)$model_members->current_credit - (float)$form_data['amount'];

$model_members->save();

$model_account2 = new Account_Model($form_data['account']);

if ($model_account2->type=='analytic')

$model_members = new Member_Model($model_account2->owner_id);

$model_members->current_credit = (float)$model_members->current_credit + (float)$form_data['amount'];

$model_members->save();

url::redirect(url_lang::base().'accounts/transfers/'.(int)$model_account->owner_id);

$view->content->acc_data = $model_account;

<td><?php if ($transfer->bank_info_id!='' && $transfer->aoname=='') echo $transfer->name; else echo html::anchor(url_lang::base().'members/show/'.$transfer->aoowner,$transfer->aoname); ?></td>

<td><?php if ($transfer->bank_info_id!='' && $transfer->adname=='') echo $transfer->name; else echo html::anchor(url_lang::base().'members/show/'.$transfer->adowner,$transfer->adname); ?></td>

<?php if ($transfer->bank_info_id!='&nbsp;') { ?>

<?php } ?>

<h2><?php echo url_lang::lang('texts.Account').' '.$acc_name ?></h2><br />

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

<?php echo html::anchor(url_lang::base().'accounts/new_transfer/'.$acc_id,url_lang::lang('texts.New transfer')).' | '.html::anchor(url_lang::base().'members/show/'.$member_id,url_lang::lang('texts.Back to the member.')) ?>

foreach ($projects_acc as $project)

<td <?php echo $style_td?>><?php if($field->name == 'amount') {if ($item->trans_type) echo '<span style="color:red">- '.number_format((float)$item->$field, 2, ',', ' ').'</span>'; else echo number_format((float)$item->$field, 2, ',', ' ');} elseif ($field->name == 'aname' && $item->$field == '') echo $item->name; elseif ($field->name == 'name') echo trim($item->text.'<br />'.$item->variable_symbol.' - '.$item->specific_symbol,'<br />'); elseif (trim($item->$field)!='') echo $item->$field; else echo '&nbsp;'; ?></td>