. /** * Class for actions dealing with date periods * * This class encapsulates all actions dealing with time intervals. It handles data * storage, and retrieval, as well as formatting and access. * * @copyright Logical Outcome Ltd. 2005 - 2007 * @author Glenn Henshaw * @link http://www.mantisbt.org * @package MantisBT * @subpackage classes * */ class Period { /** * @var string start date */ var $start = ''; /** * @var string end date */ var $end = ''; // ******* End vars ********************************************* /** * Constructor */ function Period() { $this->start = ''; // default to today $this->end = ''; // default to today } /** * set dates for a week * * @param string $p_when date string to expand to a week (Sun to Sat) * @param int $p_weeks number of weeks */ function a_week( $p_when, $p_weeks = 1 ) { list( $t_year, $t_month, $t_day ) = explode( "-", $p_when ); $t_now = getdate( mktime( 0, 0, 0, $t_month, $t_day, $t_year ) ); $this->end = strftime( "%Y-%m-%d 23:59:59", mktime( 0, 0, 0, $t_month, $t_day - $t_now['wday'] + ( $p_weeks * 7 ) - 1, $t_year ) ); $this->start = strftime( "%Y-%m-%d 00:00:00", mktime( 0, 0, 0, $t_month, $t_day - $t_now['wday'], $t_year ) ); } /** * set dates for this week * */ function this_week() { $this->a_week( date( 'Y-m-d' ) ); } /** * set dates for last week * * @param int $p_weeks number of weeks */ function last_week( $p_weeks = 1 ) { $this->a_week( date( 'Y-m-d', strtotime( '-' . $p_weeks . ' week' ) ), $p_weeks ); } /** * set dates for this week to date * */ function week_to_date() { $this->this_week(); $this->end = date( 'Y-m-d' ) . ' 23:59:59'; } /** * set dates for a month * * @param string $p_when date string to expand to a month */ function a_month( $p_when ) { list( $t_year, $t_month, $t_day ) = explode( "-", $p_when ); $this->end = strftime( '%Y-%m-%d 23:59:59', mktime( 0, 0, 0, $t_month + 1, 0, $t_year ) ); $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, $t_month, 1, $t_year ) ); } /** * set dates for this month * */ function this_month() { $this->a_month( date( 'Y-m-d' ) ); } /** * set dates for last month * */ function last_month() { $this->a_month( date( 'Y-m-d', strtotime( '-1 month' ) ) ); } /** * set dates for this month to date * */ function month_to_date() { $this->end = date( 'Y-m-d' ) . ' 23:59:59'; list( $t_year, $t_month, $t_day ) = explode( "-", $this->end ); $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, $t_month, 1, $t_year ) ); } /** * set dates for a quarter * * @param string $p_when date string to expand to a quarter */ function a_quarter( $p_when ) { list( $t_year, $t_month, $t_day ) = explode( "-", $p_when ); $t_month = ( (int)(( $t_month - 1 ) / 3 ) * 3 ) + 1; $this->end = strftime( '%Y-%m-%d 23:59:59', mktime( 0, 0, 0, $t_month + 3, 0, $t_year ) ); $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, $t_month, 1, $t_year ) ); } /** * set dates for this quarter * */ function this_quarter() { $this->a_quarter( date( 'Y-m-d' ) ); } /** * set dates for last month * */ function last_quarter() { $this->a_quarter( date( 'Y-m-d', strtotime( '-3 months' ) ) ); } /** * set dates for this quarter to date * */ function quarter_to_date() { $this->end = date( 'Y-m-d' ) . ' 23:59:59'; list( $t_year, $t_month, $t_day ) = explode( '-', $this->end ); $t_month = ( (int)(( $t_month - 1 ) / 3 ) * 3 ) + 1; $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, $t_month, 1, $t_year ) ); } /** * set dates for a year * * @param string $p_when date string to expand to a year */ function a_year( $p_when ) { list( $t_year, $t_month, $t_day ) = explode( '-', $p_when ); $this->end = strftime( '%Y-%m-%d 23:59:59', mktime( 0, 0, 0, 12, 31, $t_year ) ); $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, 1, 1, $t_year ) ); } /** * set dates for this year * */ function this_year() { $this->a_year( date( 'Y-m-d' ) ); } /** * set dates for current year, ending today * */ function year_to_date() { $this->end = date( 'Y-m-d' ) . ' 23:59:59'; list( $t_year, $t_month, $t_day ) = explode( "-", $this->end ); $this->start = strftime( '%Y-%m-%d 00:00:00', mktime( 0, 0, 0, 1, 1, $t_year ) ); } /** * set dates for last year * */ function last_year() { $this->a_year( date( 'Y-m-d', strtotime( '-1 year' ) ) ); } /** * get start date in unix timestamp format * */ function get_start_timestamp() { return strtotime( $this->start ); } /** * get end date in unix timestamp format * */ function get_end_timestamp() { return strtotime( $this->end ); } /** * get formatted start date * */ function get_start_formatted() { return( $this->start == '' ? '' : strftime( '%Y-%m-%d', $this->get_start_timestamp() ) ); } /** * get formatted end date * */ function get_end_formatted() { return( $this->end == '' ? '' : strftime( '%Y-%m-%d', $this->get_end_timestamp() ) ); } /** * get number of days in interval * */ function get_elapsed_days() { return( $this->get_end_timestamp() - $this->get_start_timestamp() ) / ( 24 * 60 * 60 ); } /** * print a period selector * * @param string $p_control_name */ function period_selector( $p_control_name ) { $t_periods = array( 0 => plugin_lang_get( 'period_none' ), 7 => plugin_lang_get( 'period_this_week' ), 8 => plugin_lang_get( 'period_last_week' ), 9 => plugin_lang_get( 'period_two_weeks' ), 1 => plugin_lang_get( 'period_this_month' ), 2 => plugin_lang_get( 'period_last_month' ), 3 => plugin_lang_get( 'period_this_quarter' ), 4 => plugin_lang_get( 'period_last_quarter' ), 5 => plugin_lang_get( 'period_year_to_date' ), 6 => plugin_lang_get( 'period_last_year' ), 10 => plugin_lang_get( 'period_select' ), ); $t_default = gpc_get_int( $p_control_name, 0 ); $t_formatted_start = $this->get_start_formatted(); $t_formatted_end = $this->get_end_formatted(); $t_ret = '
'; $t_ret .= get_dropdown( $t_periods, $p_control_name, $t_default, false, false, 'setDisplay(\'dates\', document.getElementById(\'' . $p_control_name . '\').value == 10)' ); $t_ret .= '
' . lang_get( 'from_date' ) . ' ' . '' . 'Date' . "\n" . '
' . lang_get( 'to_date' ) . '    ' . '' . 'Date' . "\n" . '' . "\n" . '
'; return $t_ret; } /** * set date based on period selector * * @param string $p_control_name * @param string $p_start_field * @param string $p_end_field */ function set_period_from_selector( $p_control_name, $p_start_field = 'start_date', $p_end_field = 'end_date' ) { $t_default = gpc_get_int( $p_control_name, 0 ); switch( $t_default ) { case 1: $this->month_to_date(); break; case 2: $this->last_month(); break; case 3: $this->quarter_to_date(); break; case 4: $this->last_quarter(); break; case 5: $this->year_to_date(); break; case 6: $this->last_year(); break; case 7: $this->week_to_date(); break; case 8: $this->last_week(); break; case 9: $this->last_week( 2 ); break; case 10: $t_today = date( 'Y-m-d' ); if( $p_start_field != '' ) { $this->start = gpc_get_string( $p_start_field, '' ) . ' 00:00:00'; if( $this->start == '' ) { $this->start = $t_today . ' 00:00:00'; } } if( $p_end_field != '' ) { $this->end = gpc_get_string( $p_end_field, '' ) . ' 23:59:59'; if( $this->end == '' ) { $this->end = $t_today . ' 23:59:59'; } } break; default: } } }