Members_traffic_Model Class Reference

Public Member Functions
	add_daily_partition ()
	Add new partition for members_traffics_daily.
	add_monthly_partition ()
	Add new partition for members_traffics_monthly.
	remove_daily_old_partitions ()
	Remove partitions for members_traffics_daily which are more than 2 month old.
	remove_monthly_old_partitions ()
	Remove partitions for members_traffics_monthly which are more than 2 years old.
	get_total_member_traffic ($member_id)
	Returns total traffics of member.
	get_today_member_traffic ($member_id)
	Returns today traffics of member.
	get_month_member_traffic ($member_id)
	Returns month traffics of member.
	get_total_traffics ($type, $limit_from=0, $limit_results=50, $order_by=NULL, $order_by_direction= 'ASC', $filter_sql= '')
	Returns total traffics.
	get_all_members_traffics ($type, $limit_from=0, $limit_results=50, $order_by=NULL, $order_by_direction= 'ASC', $filter_sql= '')
	Returns traffics of all members.
	get_member_traffics ($member_id, $type, $order_by=NULL, $filter_sql= '')
	Returns all traffics of member.
	count_total_traffics ($type, $filter_sql= '')
	Count total traffics.
	count_all_members_traffics ($type, $filter_sql= '')
	Counts traffics of all members.
	avg_total_traffics ($type)
	Averages total traffics.
	avg_member_traffics ($member_id, $type)
	Counts avarage of member's traffics.
	avg_daily_traffics ($day=NULL, $type=NULL)
	Average daily traffic of all members.
	update_active_members ($avg, $limit, $type, $day)
	Update active members.

Static Public Member Functions
static	create_tables ($create_first_partition=FALSE)
	Creates tables (daily, monthly, yearly) with parttitons for current date/month.
static	destroy_tables ()
	Destroys tables.

Member Function Documentation

Members_traffic_Model::add_daily_partition

(

)

Add new partition for members_traffics_daily.

Author

Ondřej Fibich

Members_traffic_Model::add_monthly_partition

(

)

Add new partition for members_traffics_monthly.

Author

Ondřej Fibich

Members_traffic_Model::avg_daily_traffics	(		$day = NULL,
			$type = NULL
	)

Average daily traffic of all members.

Author

Michal Kliment

Parameters

type	$day
type	$type

Returns

null

Members_traffic_Model::avg_member_traffics	(		$member_id,
			$type
	)

Counts avarage of member's traffics.

Author

Michal Kliment

Parameters

integer	$member_id
string	$type

Returns

Database_Result

Members_traffic_Model::avg_total_traffics

(

$type

)

Averages total traffics.

Author

Michal Kliment

Parameters

string

$type

Returns

MySQL_Result object

Members_traffic_Model::count_all_members_traffics	(		$type,
			$filter_sql = ''
	)

Counts traffics of all members.

Author

Michal kliment

Parameters

string	$type
string	$filter_sql

Returns

integer

Members_traffic_Model::count_total_traffics	(		$type,
			$filter_sql = ''
	)

Count total traffics.

Author

Michal Kliment

Parameters

string	$type
string	$filter_sql

Returns

integer

static Members_traffic_Model::create_tables (   $create_first_partition = FALSE )

static

Creates tables (daily, monthly, yearly) with parttitons for current date/month.

Parameters

boolean

$create_first_partition

enable creating of first partitions?

Members_traffic_Model::get_all_members_traffics	(		$type,
			$limit_from = 0,
			$limit_results = 50,
			$order_by = NULL,
			$order_by_direction = 'ASC',
			$filter_sql = ''
	)

Returns traffics of all members.

Author

Michal Kliment

Parameters

string	$type
integer	$limit_from
integer	$limit_results
string	$order_by
string	$order_by_direction
string	$filter_sql

Returns

MySQL_Iterator object

Members_traffic_Model::get_member_traffics	(		$member_id,
			$type,
			$order_by = NULL,
			$filter_sql = ''
	)

Returns all traffics of member.

!!!!!! SECURITY WARNING !!!!!! Be careful when you using this method, param $filter_sql is unprotected for SQL injections, security should be made at controller site using Filter_form class. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Author

Michal Kliment

Parameters

type	$member_id
type	$type
type	$limit_from
type	$limit_results
type	$order_by
type	$order_by_direction
type	$filter_sql

Returns

type

Members_traffic_Model::get_month_member_traffic

(

$member_id

)

Returns month traffics of member.

Parameters

integer

$member_id

Returns

MySQL_Result

Members_traffic_Model::get_today_member_traffic

(

$member_id

)

Returns today traffics of member.

Parameters

integer

$member_id

Returns

MySQL_Result

Members_traffic_Model::get_total_member_traffic

(

$member_id

)

Returns total traffics of member.

Author

Michal Kliment

Parameters

int

$member_id

Returns

MySQL_Result object

Members_traffic_Model::get_total_traffics	(		$type,
			$limit_from = 0,
			$limit_results = 50,
			$order_by = NULL,
			$order_by_direction = 'ASC',
			$filter_sql = ''
	)

Returns total traffics.

Author

Michal Kliment

Parameters

string	$type
integer	$limit_from
integer	$limit_results
string	$order_by
string	$order_by_direction
string	$filter_sql

Returns

MySQL_Iterator object

Members_traffic_Model::remove_daily_old_partitions

(

)

Remove partitions for members_traffics_daily which are more than 2 month old.

Author

Ondřej Fibich

Members_traffic_Model::remove_monthly_old_partitions

(

)

Remove partitions for members_traffics_monthly which are more than 2 years old.

Author

Ondřej Fibich

Members_traffic_Model::update_active_members	(		$avg,
			$limit,
			$type,
			$day
	)

Update active members.

Author

Michal Kliment

Parameters

double	$avg
integer	$limit
string	$type
string	$day

Returns

boolean

---

The documentation for this class was generated from the following file:

• members_traffic.php