FreenetIS

'device fees have been successfully deducted' => 'Splátky zařízení byly úspěšně strženy.',

SELECT mip.ip_address_id, ip.ip_address, m.name, mip.datetime

WHERE t.origin_id = $account_id AND t.type = ".Transfer_Model::$deduct_device_fee

/**

* Gets list of devices with repayments. Devices are ordered ascending by their buy date.

* @author Jiri Svitak

* @param unknown_type $account_id

*/

function get_devices_of_account($account_id)

{

return self::$db->query("

SELECT d.id, d.payment_rate, d.buy_date, d.price

FROM devices d

JOIN users u ON d.user_id = u.id

JOIN accounts a ON a.member_id = u.member_id AND u.member_id <> 1

WHERE a.id = $account_id AND d.price IS NOT NULL AND d.price > 0

ORDER BY d.buy_date ASC

");

}

/*

*/

// asi neni nutne resit posilani zpravy z centralniho routeru, proste kdyz jsem prijde, tak je synchornizovany

function synchronized()

{

// get actual synchronization status

$synchronized = $this->settings->get('synchronized');

// set status to synchronized

$this->settings->set('synchronized', 1);

// return synchronization status to central router

return $synchronized;

}

// IP address to cancel redirection

$ip_string = $_POST['self_cancelable'];

$ip_array = explode(";", $ip_string);

$db = new Database();

foreach ($ip_array as $ip_address)

{

$ip_address;

$db->query("DELETE messages_ip_addresses FROM messages_ip_addresses mip, ip_addresses ip WHERE mip.ip_address_id = ip.id AND ip.ip_address = $ip_address");

}

// total amount of already repaied transfers

$already_paid = $account_model->get_amount_of_device_fees($ca->id);

// is all device repayments already paid?

if ($already_paid >= $ca->total_price)

// device repayment is not wholy paid, calculate debt

$debt = $ca->total_price - $already_paid;

// gets all devices including their buy dates and payment rates

$devices = $account_model->get_devices_of_account($ca->id);

// gets buy date of the first device

$buy_date = date_parse($devices->current()->buy_date);

$year = $buy_date['year'];

$month = $buy_date['month'];

$date = date('Y-m-d', mktime(0, 0, 0, $month, 15, $year));

//echo "date $date<br>";

// calculate total payment rate for current month

$payment_rate = 0;

foreach ($devices as $device)

{

// find finishing date of repayments for given device

$bd = date_parse($device->buy_date);

$y = $bd['year'];

$m = $bd['month'];

$d = date('Y-m-d', mktime(0, 0, 0, $m, 15, $y));

// payments

$payments = 0;

while ($device->price > $payments)

{

$payments += $device->payment_rate;

// iterate to next month

$m++;

if ($m == 13)

{

$m = 1;

$y++;

}

// getting boundary date - 15th day in the month

$d = date('Y-m-d', mktime(0, 0, 0, $m, 15, $y));

echo "payments $payments<br>";

}

echo "buy date $device->buy_date, current date $date, end date $d<br>";

// is current date between buying of device and date of its full repayment?

if ($device->buy_date <= $date && $date <= $d)

$payment_rate += $device->payment_rate;

echo "payment rate $payment_rate<br>";

}

if ($debt > $payment_rate)

$amount = $payment_rate;

echo "<strong>date $date, amount $amount</strong><br>";

//$transfer = ORM::factory('transfer')->where(array('type' => Transfer_Model::$deduct_device_fee, 'amount' => $amount,

// 'origin_id' => $ca->id, 'datetime' => $date))->find();

$db = new Database();

$transfers = $db->query("SELECT id FROM transfers WHERE type = ".Transfer_Model::$deduct_device_fee." AND amount = $amount AND origin_id = $ca->id AND datetime LIKE '%$date%'");

if ($amount > 0 && count($transfers) == 0)

{

// create new transfer

$transfer = new Transfer_Model();

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

$transfer->destination_id = $operating->id;

$transfer->user_id = $this->session->get('user_id');

$transfer->type = Transfer_Model::$deduct_device_fee;

$transfer->datetime = $date;

$transfer->creation_datetime = $creation_datetime;

$transfer->text = url_lang::lang('texts.Device repayments');

$transfer->amount = $amount;

if (!$transfer->save())

$save_successful = false;

}

$month++;

if ($month == 13)

$month = 1;

$year++;

$date = date('Y-m-d', mktime(0, 0, 0, $month, 15, $year));

//die();

$grid->order_callback_field('ip_address')->label(url_lang::lang('texts.IP address'))->callback('Ip_addresses_Controller::ip_address_field');

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

echo empty($message) ? '' : '<div class="message">'.$message.'</div>';

<?php /* if ($this->acl_check_view('Users_Controller', 'users',$this->session->get('member_id'))) { ?>

<?php } */ ?>

<?php if ($this->acl_check_view('Members_Controller', 'members')) { ?>

<li class="users"><h2><?php echo url_lang::lang('texts.Users') ?></h2>

<ul>

<li><?php echo html::anchor(url_lang::base().'members', url_lang::lang('texts.Members')) ?></li>

<li><?php echo html::anchor(url_lang::base().'users', url_lang::lang('texts.Users')) ?></li>

</ul>

</li>

<?php } ?>

<li><?php echo html::anchor(url_lang::base().'ip_addresses', url_lang::lang('texts.IP addresses')) ?></li>

<li><?php echo html::anchor(url_lang::base().'subnets', url_lang::lang('texts.Subnets')) ?></li>

<li><?php echo html::anchor(url_lang::base().'ifaces', url_lang::lang('texts.Interfaces')) ?></li>

<?php if ($this->acl_check_view('Settings_Controller', 'system')) { ?>

<li><?php echo html::anchor(url_lang::base().'settings', url_lang::lang('texts.Settings')) ?></li>

<?php if ($this->acl_check_view('Address_points_Controller', 'address_point')) {?>

<li><?php echo html::anchor(url_lang::base().'address_points', url_lang::lang('texts.Address points')) ?></li>

<?php } ?>

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

echo empty($message) ? '' : '<div class="message">'.$message.'</div>';