FreenetIS

.menu_item_counter {

margin-right: 5px;

padding: 0px 6px;

font-size: 10px;

font-family: arial;

font-weight: bold;

background-color: #CCC;

-moz-border-radius: 5px;

-webkit-border-radius: 5px;

border-radius: 5px;

}

cursor: help;

color: red;

.rbg {

background-color: red;

color: white;

}

margin: 15px;

'approval_priority' => 'Priorita umožňuje vícekolové hlasování o práci/pracovním výkazu. Pokud nechcete šablonu s vícekolovým hlasováním, nastavte u všech položek šablony prioritu na hodnotu \'0\'. Vícekolové hlasování začíná u prvku s nejvyšší prioritou a sestupuje k dalším kolům hlasováním, dokud není buďto schváleno ve všech kolech, nebo v jednom z kol zamítnuto. Pokud v některém z kol hlasování chcete schvalovat více prvků zadejte jim stejnou prioritu.',

'approval_priority' => 'Priority allows multi-round voting for works / work reports. If you do not vote multi-round template, set the template for all items priority to \'0 \'. Multi-round voting begins at the element with the highest priority and descends to the next rounds of voting until it is either approved in all rounds, or in one of the rounds rejected. If any of the rounds of votes to approve more elements enter them the same priority.',

<method name="get_gps_by_address_from_google" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="autocomplete_gps" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_devices_by_user" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="delete" autogenerate="on">

<attributes>

<attribute name="vlan_id" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_all_address_points_with_empty_gps" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_count_of_unvoted_works_of_voter" autogenerate="on">

<attributes>

<attribute name="user_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

</method>

</model>

<method name="get_suggest_amount" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_count_of_unvoted_work_reports_of_voter" autogenerate="on">

<attributes>

<attribute name="user_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<attributes>

<attribute name="member_id" default_value="" />

</attributes>

<input>

<param value="" />

</input>

<method name="get_first_member_account_id" autogenerate="on">

<attributes>

<attribute name="member_id" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="count_unfilled_phone_invoices" autogenerate="on">

<attributes>

<attribute name="user_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_devices_of_vlan" autogenerate="on">

<attributes>

<attribute name="vlan_id" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

</method>

<method name="has_user_voted_about" autogenerate="on">

<attributes>

<attribute name="user_id" default_value="" />

<attribute name="fk_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

</values>

</method>

</model>

<method name="date" autogenerate="off">

<attributes>

<attribute name="item" default_value=""/>

<attribute name="name" default_value=""/>

</attributes>

<values>

</values>

</method>

</method>

<method name="ports_field" autogenerate="off">

<attributes>

<attribute name="item" default_value=""/>

<attribute name="name" default_value=""/>

</attributes>

<values>

</values>

</method>

<method name="devices_field" autogenerate="off">

<attributes>

<attribute name="item" default_value=""/>

<attribute name="name" default_value=""/>

</attributes>

<values>

</values>

<method name="menu_item_counter" autogenerate="on">

<attributes>

<attribute name="count" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

$site_url = url_lang::site($uri, FALSE, $protocol);

/**

* Menu item counter for view menu

*

* @author Ondřej Fibich

* @param integer $count

*/

public static function menu_item_counter($count)

{

echo '<span class="menu_item_counter ' . ($count ? 'rbg' : '') . '">' . $count . '</span>';

}

* Callback for date

*

* @author Ondrej Fibich

* @param object $item

* @param string $name

*/

public static function date($item, $name)

{

echo date('j.n. Y', strtotime($item->$name));

}

/**

{

echo "<span class='help' title='".$item->a_comment."'><img src='".url::base()."media/images/icons/comment.png'></span>";

}

{

echo ' '.html::anchor((($item->a_comments_thread_id) ? 'comments/add/'.$item->a_comments_thread_id : 'comments_threads/add/account/'.$item->aid), html::image(array('src' => url::base().'media/images/ico_add.gif')), array('title' => __('Add comment to financial state of member')));

}

echo html::anchor('transfers/show_by_account/'.$item->oa_id, $item->oa_name);

echo html::anchor('transfers/show_by_account/'.$item->da_id, $item->da_name);

echo html::anchor("members/show/$item->member_id", $item->member_name);

echo html::anchor("subnets/show/$item->subnet_id", $item->subnet_name);

"devices/show_ip_address/$item->ip_address_id",

"ip_addresses/show/$item->ip_address_id",

echo html::anchor("segments/show/$item->segment_id", $item->segment_name);

echo html::anchor("devices/show/$item->device_id", $item->device_name);

echo '<span style="color: green">'.__('Free').'</span>';

echo html::anchor("devices/show/$item->device_id", $item->type);

echo html::anchor("ifaces/show/$item->iface_id", $item->mac);

echo html::anchor("users/show/$item->user_id", $item->user_name);

echo html::anchor("users/show/$item->user_id", $item->user_login);

echo html::anchor(url::base().'redirection/?ip_address='.$item->ip_address, __('Show'));

echo __('Cancel').' ';

echo html::anchor("redirect/delete/$item->ip_address_id/$item->message_id/member", __('one IP address'));

echo html::anchor("redirect/delete_from_member/$item->member_id/$item->message_id", __('all ip addresses of member'));

echo __('Permanent whitelist');

echo __('Temporary whitelist');

echo __('No whitelist');

echo __('No redirection');

echo __('User message');

echo __('System message');

echo html::anchor('messages/activate/'.$message->id, __('Activate'));

echo html::anchor('messages/deactivate/'.$message->id, __('Deactivate'));

echo html::anchor('messages/delete/'.$message->id, __('Delete'));

echo html::anchor(url::base().'redirection/?id='.$message->id, __('Preview'), array('target' => '_blank'));

echo '<span style="color: green">' . __('yes') . '</span>';

echo '<span style="color: red">' . __('no') . '</span>';

$title = __('Locked by admin');

$title = __('Already filled in');

$title = __('Not filled in');

$title = __('Already filled in');

$title = __('Not filled in');

'title' => __('Edit'))

'title' => __('Delete'))

'title' => __('History'))

'title' => __('Add'))

'title' => __('History'))

__('private contact') . '</span>';

$item->id, __('Delete'),

echo '<span style="color: red;">' . __('Locked') . '</span>';

$item->id, __('' . (($item->locked == 1) ? 'Show' : 'Edit')),

$item->id, __('Edit'),

echo '<span style="color: red;">' . __('Locked') . '</span>';

'users/show/'.$user->id,

'logs/show_by_user/'.$user->id,

'title' => __('Show user actions')))

echo __('Added');

echo __('Deleted');

echo __('Updated');

'logs/show_object/'.$item->table_name.'/'.$item->object_id,

echo html::image(array('src' => url::base().'media/images/'.$state.'.png', 'title' => __(''.$state)));

echo html::anchor ('ifaces/show/'.$item->iface_id, $item->iface_name, array('title' => __('Show interface')));

echo html::anchor ('vlan_ifaces/show/'.$item->vlan_iface_id, $item->vlan_iface_name, array('title' => __('Show VLAN interface')));

echo html::anchor ('vlans/show/'.$item->vlan_id, $item->vlan_name, array('title' => __('Show VLAN')));

echo html::anchor ('devices/show_vlan_iface/'.$item->vlan_iface_id, $item->vlan_iface_name, array('title' => __('Show VLAN interface')));

echo html::anchor ('vlan_ifaces/show/'.$item->vlan_iface_id, $item->vlan_iface_name, array('title' => __('Show VLAN interface')));

echo html::anchor ('ports/show/'.$item->port_id, $item->port_name, array('title' => __('Show port')));

echo html::anchor ('devices/show_iface/'.$item->iface_id, $item->iface_id, array('title' => __('Show interface')));

echo html::anchor ($args[0].'/edit/'.$item->id, __('Edit'));

echo html::anchor ($args[0].'/delete/'.$item->id, __('Delete'), array('class' => 'delete_link'));

$args[0].$item->id, html::image(

'src' => url::base().'media/images/'.$state.'.png', 'title' => __(''.$state))

'src' => url::base().'media/images/'.$state.'.png', 'title' => __(''.$state))

echo __('Domicile'). ' '.help::hint('address_point_member_domicile');

echo __('Connecting place'). ' '.help::hint('address_point_member_connecting_place');

echo __('Financial state of member').' '.html::anchor('members/show/'.$item->member_id, $item->member_name, array('title' => __('Show member')));

echo html::anchor('works/show/'.$item->work_id, __('Work'), array('title' => __('Show work'))).' '.__('of user').' '.html::anchor('users/show/'.$item->work_user_id, $item->work_user_name, array('title' => __('Show user')));

echo html::anchor('devices/show_iface/'.$item->iface_id, $item->mac, array('title' => $item->iface_name));

echo html::anchor('ifaces/show/'.$item->iface_id, $item->mac, array('title' => $item->iface_name));

echo html::anchor('users/show/'.$item->from_user_id, $item->from_user_name, array('title' => $item->from));

echo html::anchor('users/show/'.$item->to_user_id, $item->to_user_name, array('title' => $item->to));

'ifaces/show/'.$item->id, $item->name

'ports/show/'.$item->id, $item->name

$lang = Config::get('lang');

*

* @property integer $user_id

* @property User_Model $user

* @property integer $phone_invoice_id

* @property Phone_invoice_Model $phone_invoice

* @property string $phone_number

* @property boolean $locked

* @property ORM $phone_connections

* @property ORM $phone_calls

* @property ORM $phone_fixed_calls

* @property ORM $phone_pays

* @property ORM $phone_roaming_sms_messages

* @property ORM $phone_sms_messages

* @property ORM $phone_vpn_calls

protected $has_many = array

(

/**

* Gets count of unfilled users phone invoices

*

* @param integer $user_id User

* @return integer

*/

public function count_unfilled_phone_invoices($user_id)

{

return $this->db->query("

SELECT COUNT(pi.id) AS count

FROM phone_invoice_users pi

LEFT JOIN phone_invoices p ON pi.phone_invoice_id = p.id

WHERE pi.user_id = ? AND pi.locked = 0 AND p.locked = 0

", $user_id)->current()->count;

}

ORDER BY i.priority DESC

*

* @author Ondřej Fibich

* @param integer $work_id

* @param integer $user_id

* @param double $suggest_amount

* @return boolean

$work_id, $user_id, $suggest_amount = NULL)

$work = new Job_Model($work_id);

if (!$work || !$work->id || $work->state > 1)

{

return FALSE;

}

// get approval types

$cond = '';

// if suggested amount is empty get it from work/report

if (empty($suggest_amount))

{

$suggest_amount = $work->suggest_amount;

// gets suggested amount of whole report

if ($work->job_report_id)

{

$suggest_amount = $work->job_report->get_suggest_amount();

}

}

$groups = $this->db->query("

SELECT a.id, a.name, i.priority, i.approval_type_id

FROM approval_template_items i

LEFT JOIN approval_types t ON i.approval_type_id = t.id

LEFT JOIN aro_groups a ON t.aro_group_id = a.id

WHERE i.approval_template_id = ? AND t.min_suggest_amount <= ?

ORDER BY i.priority DESC

", $work->approval_template_id, $suggest_amount);

// group by priority

$group_by_priority = array();

foreach ($groups as $group)

{

$group_by_priority[$group->priority][] = $group;

}

unset($groups);

// check each group from most priority

$job = new Job_Model();

$vote = new Vote_Model();

$counter = 0;

foreach ($group_by_priority as $group)

{

$state = 0;

$ids = array();

$counter++;

foreach ($group as $item)

{

$ids[] = $item->id;

$item_state = $work->get_state(

Vote_Model::$work,

$item->approval_type_id

);

if ($item_state == 2)

{

$state = 2;

}

else if ($item_state == 3 && $state == 0)

{

$state = 3;

}

}

// is user in vote group?

$in_group = FALSE;

if (count($ids))

{

$in_group = $this->db->query("

SELECT COUNT(*) AS count

FROM groups_aro_map

WHERE group_id IN (" . implode(', ', $ids) . ") AND

aro_id = ?

", $user_id)->current()->count > 0;

}

// vote not finished yet, can vote or edit vote?

if ($state <= 2)

{

return $in_group;

}

// approved, but some user should not vote yet or

// if this is last group of voters, enable edit vote

else if ($in_group && (

(count($group_by_priority) == $counter) ||

!$vote->has_user_voted_about($user_id, $work->id)

))

{

return TRUE;

}

}

return FALSE;

ORDER BY i.priority DESC

ORDER BY i.priority DESC

if (!$result || !$result->count())

* @param integer $member_id

public function get_members_joined($member_id = NULL)

/**

* Gets ID of member account if there is any

*

* @param integer $member_id

* @return integer

*/

public function get_first_member_account_id($member_id = NULL)

{

if (empty($member_id))

{

$member_id = $this->id;

}

$result = $this->db->query("

SELECT a.id

FROM accounts a

WHERE a.member_id = ?

", $member_id);

if ($result && $result->count())

{

return $result->current()->id;

}

return NULL;

}

SELECT IFNULL(COUNT(*), 0) AS count

/**

* Gets count of unvoted works of voter

*

* @param integer $user_id ID of voter

* @return integer

*/

public function get_count_of_unvoted_works_of_voter($user_id)

{

return $this->db->query("

SELECT IFNULL(COUNT(j.id), 0) AS count

FROM groups_aro_map g

LEFT JOIN approval_types at ON at.aro_group_id = g.group_id

LEFT JOIN approval_template_items ati ON at.id = ati.approval_type_id

LEFT JOIN jobs j ON j.approval_template_id = ati.approval_template_id AND

j.suggest_amount >= at.min_suggest_amount

LEFT JOIN votes v ON v.fk_id = j.id AND v.user_id = ?

WHERE g.aro_id = ? AND

j.job_report_id IS NULL AND

j.state <= 1 AND

v.id IS NULL

", $user_id, $user_id)->current()->count;

}

* @author Michal Kliment, Ondřej Fibich

public function get_state($type, $approval_type_id = NULL)

if (!empty($approval_type_id))

{

$approval_template_items = $approval_template_item_model

->where('approval_template_id', $this->approval_template_id)

->where('approval_type_id', $approval_type_id)

->orderby('priority', 'desc')

->find_all();

}

else

{

$approval_template_items = $approval_template_item_model

->where('approval_template_id', $this->approval_template_id)

->orderby('priority', 'desc')

->find_all();

}

$suggest_amount = $this->suggest_amount;

if ($this->job_report_id)

{

$suggest_amount = $this->job_report->get_suggest_amount();

}

$at = $approval_template_item->approval_type;

if (!$suggest_amount || $at->min_suggest_amount <= $suggest_amount)

$at->aro_group_id

$interval = date::hour_diff($at->interval);

if ($at->type == Approval_type_Model::$simple &&

if ($percent < $at->majority_percent)

$interval = date::hour_diff($at->interval);

if ($percent < $at->majority_percent)

if ($percent < $at->majority_percent)

* @property integer $added_by_id

* @property User_Model $added_by

protected $belongs_to = array

(

'user', 'approval_template', 'transfer',

'added_by' => 'user'

);

* @staticvar array $cache Cache for states

SELECT IF(MIN(state) <= 1, MIN(state), MAX(state)) AS state

FROM jobs

WHERE job_report_id = ?

/**

* Gets suggest amount of work reports from it's works

*

* @author Ondřej Fibich

* @staticvar array $cache Cache for amounts

* @return double

*/

public function get_suggest_amount()

{

static $cache = array();

if (!$this->id)