FreenetIS

);

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

$model_voip_sip = new Voip_sip_Model();

$grid->action_field('user_id')->label(url_lang::lang('texts.Account'))->url(url_lang::base().'voip/show')->action(url_lang::lang('texts.Show'));

$grid->datasource($all_voip_sip);

function show($user_id = NULL)

if (!isset($user_id))

Controller::warning(PARAMETER);

$voip_sip = new Voip_sip_Model();

$voip = $voip_sip->get_record_by_user_limited($user_id);

if ($voip->count() == 0)

Controller::error(4);

$voip = $voip_sip->get_record_by_user($user_id);;

if ($voip->count() == 0)

Controller::error(RECORD);

$config = new Config_Model();

$config->get_value_from_name('voip_sip_server');

$sip_server = $config->get_value_from_name('voip_sip_server');

$voip = $voip_sip->get_record_by_user($user_id);

$voip = $voip->current();

$voicemail_model = new Voip_voicemail_user_Model();

$voicemail = $voicemail_model->find_by_customer_id($voip->mailbox);

if(( $voip->regseconds - time()) > 1)

$link_status = true;

else

$link_status = false;

$view = new View('main');

$view->title = url_lang::lang('texts.Show VoIP');

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

$view->content->headline = url_lang::lang('texts.Show VoIP');

$view->content->voip = $voip;

$view->content->sip_server = $sip_server;

$view->content->link_status = $link_status;

$view->content->ipaddr = $voip->ipaddr;

$view->content->port = $voip->port;

$view->content->regseconds = ($voip->regseconds - time()< 0 )?'0':$voip->regseconds - time();

$view->content->voicemail = $voicemail;

$view->render(true);

}

function change_password($user_id = NULL)

$voip_sip = new Voip_sip_Model();

$voip = $voip_sip->get_record_by_user_limited($user_id);

if ($voip->count() == 0)

Controller::error(4);

$voip = $voip_sip->find_by_user_id($user_id);

$view->title = url_lang::lang('texts.Change VoIP password');

$view->content->password = $voip->secret;

function edit_voicemail($user_id = NULL)

$voip_sip = new Voip_sip_Model();

$voip = $voip_sip->get_record_by_user_limited($user_id);

if ($voip->count() == 0)

Controller::error(4);

$voip = $voip_sip->find_by_user_id($user_id);

$form = new Forge(url_lang::base()."voip/edit_voicemail/".$user_id, '', 'POST', array('id' => 'article_form'));

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

$form->password('confirm_password')->label(url_lang::lang('texts.Confirm new password').':')->rules('required|length[4,4]|valid_digit')->matches($form->password);

$form->input('email')->label(url_lang::lang('texts.email').':')->rules('length[6,50]|required')->value($voicemail->email)->callback(array($this,'valid_voip_voicemail_email'));

$view->title = url_lang::lang('texts.Edit VoIP voicemail');

function edit_member_limit($member_id = NULL)

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

url::redirect(url_lang::base().'voip/edit_member_limit/'.$member_id);

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

$headline = url_lang::lang('texts.Edit member limit');

$view->title = $headline;

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

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

$view->content->member_id = $member_id;

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

if ($message)

$view->content->message = $message;

$view->content->aditional_info = url_lang::lang('texts.Information').' : '.url_lang::lang('texts.0 means unlimited limit.');

}

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

//kontrola existence cisla voip

//kontrola existence usera

if ($this->input->post('ranges') != NULL)

$user = ORM::factory('user')->where('id', $user_id)->find();

$username = text::cs_utf2ascii($user->name.' '.$user->surname);

$voip_new = new Voip_sip_Model();

$voip_new->name = $number;

$voip_new->user_id = $user_id;

$voip_new->callerid = $username.' <'.$number.'>';

$voip_new->mailbox = $number;

$voip_new->secret = security::generate_password();

$voip_new->username = $number;

$voip_new->save();

$voicemail = new Voip_voicemail_user_Model();

$voicemail->customer_id = $number;

$voicemail->mailbox = $number;

$voicemail->password = security::generate_numeric_password(4);

$voicemail->fullname = $username;

$voicemail->email =$user->email;

$voicemail->save();

}

$voip_sip = new Voip_sip_Model();

//check existence of number

function valid_voip_voicemail_email($input)

{

if(!valid::email($input->value) == true)

$input->add_error('required', url_lang::lang('texts.Must be a valid e-mail'));

}

"CREATE ALGORITHM = UNDEFINED VIEW `account_outbounds` AS SELECT a. * , IFNULL( SUM( amount ) , 0 ) AS outbound

FROM accounts a

LEFT JOIN transfers t ON a.id = t.origin_id

GROUP BY a.id",

"CREATE ALGORITHM = UNDEFINED VIEW `account_inbounds` AS SELECT a . * , IFNULL( SUM( amount ) , 0 ) AS inbound

FROM account_outbounds a

LEFT JOIN transfers t ON a.id = t.destination_id

GROUP BY a.id",

"CREATE ALGORITHM = UNDEFINED VIEW `account_balances` AS SELECT a . * , (

inbound - outbound

) AS balance

FROM account_inbounds a",

"CREATE TABLE `bank_statements` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`bank_account_id` INT NOT NULL ,

`user_id` INT NOT NULL ,

`extension` VARCHAR( 10 ) NULL DEFAULT NULL ,

`from` DATETIME NULL DEFAULT NULL ,

`to` DATETIME NULL DEFAULT NULL ,

`opening_balance` DOUBLE NULL DEFAULT NULL ,

`closing_balance` DOUBLE NULL DEFAULT NULL

) ENGINE = InnoDB;",

"ALTER TABLE `bank_transfers` ADD `bank_statement_id` INT NULL AFTER `transfer_id`",

"CREATE TABLE `messages` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`text` TEXT NULL DEFAULT NULL ,

`type` TINYINT NULL DEFAULT NULL ,

`priority` INT NULL DEFAULT NULL ,

`system` TINYINT NULL DEFAULT NULL ,

`self_cancel` TINYINT NULL DEFAULT NULL

) ENGINE = InnoDB COMMENT = 'messages used for redirection';",

"CREATE TABLE `messages_ip_addresses` (

`message_id` INT NOT NULL COMMENT 'redirection message',

`ip_address_id` INT NOT NULL COMMENT 'redirected ip address',

`user_id` INT NOT NULL COMMENT 'user id of admin who redirects',

`comment` TEXT NULL DEFAULT NULL COMMENT 'personal comment from admin for redirected user',

PRIMARY KEY ( `message_id` , `ip_address_id` )

) ENGINE = InnoDB COMMENT = 'junction table between redirected ip address and message of redirection';"

<td><?php echo $billing_account->ballance.' '.$billing_account->currency.(($member_data->member_id != 1)?html::anchor(url_lang::base().'transfers/add_voip/'.$account->id, '&nbsp;&nbsp;-&nbsp;&nbsp;'.url_lang::lang('texts.Recharge')):''); ?></td>

<td><?php echo $billing_account->limit.' '.$billing_account->currency.'&nbsp;&nbsp;-&nbsp;&nbsp;'.html::anchor(url_lang::base().'voip/edit_member_limit/'.$member_data->member_id, url_lang::lang('texts.Change')); ?></td>

<h2><?php echo url_lang::lang('texts.Edit member limit') ?></h2><br />

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

<?php

$links = array();

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

echo implode (' | ', $links)

?>

<br /><br />

<?php echo $form?>

<h2><?php echo url_lang::lang('texts.Edit VoIP voicemail') ?></h2><br />

<?php echo url_lang::lang('texts.VoIP').' '.$voip->name ?>

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

$links[] = html::anchor(url_lang::base().'voip/edit_voicemail/'.$voip->user_id, url_lang::lang('texts.Edit VoIP voicemail'));

<th colspan="2"><?php echo url_lang::lang('texts.Login information') ?></th>

<td><?php echo '<b>********</b>'.' &nbsp;&nbsp;&nbsp;&nbsp; '.html::anchor(url_lang::base().'voip/change_password/'.$voip->user_id, url_lang::lang('texts.Change')); ?></td>

<th><?php echo url_lang::lang('texts.Display name') ?></th>

<th><?php echo url_lang::lang('texts.Domain') ?></th>

<th colspan="2"><?php echo url_lang::lang('texts.Link status') ?></th>

<th><?php echo url_lang::lang('texts.Registration expires') ?></th>

<th colspan="2"><?php echo url_lang::lang('texts.Voicemail information') ?></th>

<th><?php echo url_lang::lang('texts.Password') ?></th>

<td><?php echo $voicemail->password ?></td>

<td><?php echo $voicemail->email ?></td>

<h2><?php echo url_lang::lang('texts.Change VoIP password') ?></h2><br />

<?php echo url_lang::lang('texts.Current VoIP password is') ?> <b><?php echo $password ?></b>

<br /><br />

$links[] = html::anchor(url_lang::base().'users/show/'.$user_id, url_lang::lang('texts.Back to user'));

<?php echo url_lang::lang('texts.Warning').': '.url_lang::lang('texts.If you choose your VoIP number there is no chance how to take it back. Please vote your number carefully.'); ?><br />

<td><?php echo url_lang::lang('texts.Number ranges'.':'); ?></td>