/** * Index * * @param voi * @return null */ function index() { require_once CALENDAR_MODULE_PATH . '/models/generators/ProjectCalendarGenerator.class.php'; $today = new DateTimeValue(time() + get_user_gmt_offset()); if ($this->request->get('month') && $this->request->get('year')) { $month = $this->request->get('month'); $year = $this->request->get('year'); } else { $month = $today->getMonth(); $year = $today->getYear(); } // if $first_weekday = UserConfigOptions::getValue('time_first_week_day', $this->logged_user); $generator = new ProjectCalendarGenerator($month, $year, $first_weekday); $generator->setProject($this->active_project); $generator->setData(Calendar::getProjectData($this->logged_user, $this->active_project, $month, $year)); $this->smarty->assign(array('month' => $month, 'year' => $year, 'calendar' => $generator, 'page_tab' => 'calendar', 'navigation_pattern' => Calendar::getProjectMonthUrl($this->active_project, '-YEAR-', '-MONTH-'))); }
/** * Calendar * * @param void * @return null */ function index() { require_once CALENDAR_MODULE_PATH . '/models/generators/DashboardCalendarGenerator.class.php'; if ($this->request->get('month') && $this->request->get('year')) { $month = $this->request->get('month'); $year = $this->request->get('year'); } else { $today = new DateTimeValue(time() + get_user_gmt_offset()); $month = $today->getMonth(); $year = $today->getYear(); } // if $first_weekday = UserConfigOptions::getValue('time_first_week_day', $this->logged_user); $generator = new DashboardCalendarGenerator($month, $year, $first_weekday); $generator->setData(Calendar::getActiveProjectsData($this->logged_user, $month, $year)); $this->smarty->assign(array('month' => $month, 'year' => $year, 'calendar' => $generator, 'navigation_pattern' => Calendar::getDashboardMonthUrl('-YEAR-', '-MONTH-'))); //BOF:mod 20110623 $tabs = new NamedList(); $tabs->add('dashboard', array('text' => 'Active Teams', 'url' => assemble_url('dashboard'))); $tabs->add('home_page', array('text' => 'Home Page', 'url' => assemble_url('goto_home_tab'))); $this->smarty->assign('page_tabs', $tabs); //EOF:mod 20110623 }
$img_url = image_url('/16x16/milestone.png'); $divtype = '<span class="italic">' . lang('milestone') . '</span> - '; $tipBody = clean($event->getDescription()); } elseif ($event instanceof ProjectTask) { $start_of_task = false; $end_of_task = false; if ($event->getDueDate() instanceof DateTimeValue) { $due_date = new DateTimeValue($event->getDueDate()->getTimestamp() + logged_user()->getTimezone() * 3600); if ($dtv->getTimestamp() == mktime(0, 0, 0, $due_date->getMonth(), $due_date->getDay(), $due_date->getYear())) { $end_of_task = true; $start_of_task = true; } } if ($event->getStartDate() instanceof DateTimeValue) { $start_date = new DateTimeValue($event->getStartDate()->getTimestamp() + logged_user()->getTimezone() * 3600); if ($dtv->getTimestamp() == mktime(0, 0, 0, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())) { $start_of_task = true; $end_of_task = true; } } if ($start_of_task && $end_of_task) { $tip_title = lang('task'); $img_url = image_url('/16x16/tasks.png'); $tip_pre = ''; } else { if ($end_of_task) { $tip_title = lang('end of task'); $img_url = image_url('/16x16/task_end.png'); $tip_pre = 'end_'; } else { $tip_title = lang('start of task');
/** * Returns all events for the given range, tag and considers the active project * * @param DateTimeValue $date * @param String $tags * @return unknown */ static function getRangeProjectEvents(DateTimeValue $start_date, DateTimeValue $end_date, $tags = '', $project = null, $archived = false) { $start_year = date("Y", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_month = date("m", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_day = date("d", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $end_year = date("Y", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_month = date("m", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_day = date("d", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); if (!is_numeric($start_day) or !is_numeric($start_month) or !is_numeric($start_year) or !is_numeric($end_day) or !is_numeric($end_month) or !is_numeric($end_year)) { return NULL; } //permission check $permissions = ' AND ( ' . permissions_sql_for_listings(ProjectEvents::instance(), ACCESS_LEVEL_READ, logged_user()) . ')'; if ($project instanceof Project) { $pids = $project->getAllSubWorkspacesQuery(!$archived); $wsstring = " AND " . self::getWorkspaceString($pids); } else { $wsstring = ""; } if (isset($tags) && $tags && $tags != '') { $tag_str = " AND EXISTS (SELECT * FROM `" . TABLE_PREFIX . "tags` `t` WHERE `tag` IN (" . DB::escape($tags) . ") AND `" . TABLE_PREFIX . "project_events`.`id` = `t`.`rel_object_id` AND `t`.`rel_object_manager` = 'ProjectEvents') "; } else { $tag_str = ""; } $invited = " AND `id` IN (SELECT `event_id` FROM `" . TABLE_PREFIX . "event_invitations` WHERE `user_id` = " . logged_user()->getId() . ")"; if ($archived) { $archived_cond = " AND `archived_by_id` <> 0"; } else { $archived_cond = " AND `archived_by_id` = 0"; } $tz_hm = "'" . floor(logged_user()->getTimezone()) . ":" . abs(logged_user()->getTimezone()) % 1 * 60 . "'"; $s_date = new DateTimeValue($start_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date = new DateTimeValue($end_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date->add("d", 1); $start_date_str = $s_date->format("Y-m-d H:i:s"); $end_date_str = $e_date->format("Y-m-d H:i:s"); $first_d = $start_day; while ($first_d > 7) { $first_d -= 7; } $week_of_first_day = date("W", mktime(0, 0, 0, $start_month, $first_d, $start_year)); $conditions = "\t((\n\t\t\t\t-- \n\t\t\t\t-- THIS RETURNS EVENTS ON THE ACTUAL DAY IT'S SET FOR (ONE TIME EVENTS)\n\t\t\t\t-- \n\t\t\t\t(\n\t\t\t\t\t`repeat_h` = 0 \n\t\t\t\t\tAND `duration` >= '{$start_date_str}' \n\t\t\t\t\tAND `start` < '{$end_date_str}' \n\t\t\t\t) \n\t\t\t\t-- \n\t\t\t\t-- THIS RETURNS REGULAR REPEATING EVENTS - DAILY, WEEKLY, MONTHLY, OR YEARLY.\n\t\t\t\t-- \n\t\t\t\tOR \n\t\t\t\t(\n\t\t\t\t\t`repeat_h` = 0 \n\t\t\t\t\tAND\n\t\t\t\t\tDATE(`start`) < '{$end_date_str}'\n\t\t\t\t\tAND\n\t\t\t\t\t(\t\t\t\t\t\t\t\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_d` DAY) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t\t\t)\n\t\t\t\t\t\tOR\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_m` MONTH) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t\t\t)\n\t\t\t\t\t\tOR\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_y` YEAR) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t\t\t)\n\t\t\t\t\t)\t\t\n\t\t\t\t)\n\t\t\t\t-- \n\t\t\t\t-- THIS RETURNS EVENTS SET TO BE A CERTAIN DAY OF THE WEEK IN A CERTAIN WEEK EVERY CERTAIN AMOUNT OF MONTHS\n\t\t\t\t-- \n\t\t\t\tOR\n\t\t\t\t(\n\t\t\t\t\tDATE(`start`) <= '{$start_date_str}'\n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_h` = 1 \n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_dow` = DAYOFWEEK('{$start_date_str}') \n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_wnum` + {$week_of_first_day} - 1 = WEEK('{$start_date_str}', 3) \n\t\t\t\t\tAND\n\t\t\t\t\tMOD( PERIOD_DIFF(DATE_FORMAT(`start`, '%Y%m'), DATE_FORMAT('{$start_date_str}', '%Y%m')), `repeat_mjump`) = 0\n\t\t\t\t)\t\t\t\t\n\t\t\t)\n\t\t\t{$wsstring}\n\t\t\t{$permissions} {$invited}\n\t\t\t{$tag_str} {$archived_cond} )"; $result_events = self::findAll(array('conditions' => $conditions, 'order' => '`start`')); // Find invitations for events and logged user ProjectEvents::addInvitations($result_events); return $result_events; }
$divtype = '<span class="italic">' . lang('event') . '</span> - '; $tipBody = trim(clean($event->getDescription())) != '' ? '<br>' . clean($event->getDescription()) : ''; } elseif ($event instanceof Contact) { $div_prefix = 'w5_bd_div_'; $objType = 'contact'; $subject = clean($event->getObjectName()); $img_url = image_url('/16x16/contacts.png'); $due_date = new DateTimeValue(mktime(0, 0, 0, $event->getOBirthday()->getMonth(), $event->getOBirthday()->getDay(), $dates[$day_of_week]->getYear())); $divtype = '<span class="italic">' . lang('birthday') . '</span> - '; } $tipBody = str_replace("\r", '', $tipBody); $tipBody = str_replace("\n", '<br>', $tipBody); if (strlen_utf($tipBody) > 200) { $tipBody = substr_utf($tipBody, 0, strpos($tipBody, ' ', 200)) . ' ...'; } if ($event instanceof ProjectMilestone || $event instanceof ProjectEvent || $due_date instanceof DateTimeValue && $dates[$day_of_week]->getTimestamp() == mktime(0, 0, 0, $due_date->getMonth(), $due_date->getDay(), $due_date->getYear()) || $start_date instanceof DateTimeValue && $dates[$day_of_week]->getTimestamp() == mktime(0, 0, 0, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())) { $ws_color = $event->getObjectColor($event instanceof ProjectEvent ? 1 : 12); cal_get_ws_color($ws_color, $ws_style, $ws_class, $txt_color, $border_color); ?> <div id="<?php echo $div_prefix . $event->getId(); ?> " class="adc" style="left: 4%; top: <?php echo $top; ?> px; z-index: 5;width: 92%;margin:1px;position:absolute;"> <div class="t3 <?php echo $ws_class; ?> " style="<?php echo $ws_style;
/** * Return pick date widget * * @access public * @param string $name Name prefix * @param DateTimeValue $value Can be DateTimeValue object, integer or string * @param integer $year_from Start counting from this year. If NULL this value will be set * to current year - 10 * @param integer $year_to Count to this year. If NULL this value will be set to current * @deprecated * year + 10 * @return null */ function pick_date_widget($name, $value = null, $year_from = null, $year_to = null, $attributes = null, $id = null) { require_javascript("og/DateField.js"); $oldValue = $value; if (!$value instanceof DateTimeValue) { $value = new DateTimeValue($value); } $month_options = array(); for ($i = 1; $i <= 12; $i++) { $option_attributes = $i == $value->getMonth() ? array('selected' => 'selected') : null; $month_options[] = option_tag(lang("month {$i}"), $i, $option_attributes); } // for $day_options = array(); for ($i = 1; $i <= 31; $i++) { $option_attributes = $i == $value->getDay() ? array('selected' => 'selected') : null; $day_options[] = option_tag($i, $i, $option_attributes); } // for $year_from = (int) $year_from < 1 ? $value->getYear() - 10 : (int) $year_from; $year_to = (int) $year_to < 1 || (int) $year_to < $year_from ? $value->getYear() + 10 : (int) $year_to; $year_options = array(); if ($year_from <= 1902) { $option_attributes = is_null($oldValue) ? array('selected' => 'selected') : null; $year_options[] = option_tag(lang('select'), 0, $option_attributes); } for ($i = $year_from; $i <= $year_to; $i++) { $option_attributes = $i == $value->getYear() && !is_null($oldValue) ? array('selected' => 'selected') : null; $year_options[] = option_tag($i, $i, $option_attributes); } // if $attM = $attributes; $attY = $attributes; $attD = $attributes; if ($attM['id']) { $attM['id'] .= '_month'; } if ($attY['id']) { $attY['id'] .= '_year'; } if ($attD['id']) { $attD['id'] .= '_day'; } if (strpos($name, "]")) { $preName = substr_utf($name, 0, strpos_utf($name, "]")); return select_box($preName . '_month]', $month_options, $attM) . select_box($preName . '_day]', $day_options, $attD) . select_box($preName . '_year]', $year_options, $attY); } else { return select_box($name . '_month', $month_options, $attM) . select_box($name . '_day', $day_options, $attD) . select_box($name . '_year', $year_options, $attY); } }
function getData($event_data){ // get the day if (array_var($event_data, 'start_value') != '') { $date_from_widget = array_var($event_data, 'start_value'); $dtv = getDateValue($date_from_widget); $day = $dtv->getDay(); $month = $dtv->getMonth(); $year = $dtv->getYear(); } else { $month = isset($event_data['month'])?$event_data['month']:date('n', DateTimeValueLib::now()->getTimestamp()); $day = isset($event_data['day'])?$event_data['day']:date('j', DateTimeValueLib::now()->getTimestamp()); $year = isset($event_data['year'])?$event_data['year']:date('Y', DateTimeValueLib::now()->getTimestamp()); } if (array_var($event_data, 'start_time') != '') { $this->parseTime(array_var($event_data, 'start_time'), $hour, $minute); } else { $hour = array_var($event_data, 'hour'); $minute = array_var($event_data, 'minute'); if(array_var($event_data, 'pm') == 1) $hour += 12; } if (array_var($event_data, 'type_id') == 2 && $hour == 24) $hour = 23; // repeat defaults $repeat_d = 0; $repeat_m = 0; $repeat_y = 0; $repeat_h = 0; $repeat_h_params = array('dow' => 0, 'wnum' => 0, 'mjump' => 0); $rend = ''; // get the options $forever = 0; $jump = array_var($event_data,'occurance_jump'); if(array_var($event_data,'repeat_option') == 1) $forever = 1; elseif(array_var($event_data,'repeat_option') == 2) $rnum = array_var($event_data,'repeat_num'); elseif(array_var($event_data,'repeat_option') == 3) $rend = getDateValue(array_var($event_data,'repeat_end')); // verify the options above are valid if(isset($rnum) && $rnum !="") { if(!is_numeric($rnum) || $rnum < 1 || $rnum > 1000) { throw new Exception(CAL_EVENT_COUNT_ERROR); } } else $rnum = 0; if($jump != ""){ if(!is_numeric($jump) || $jump < 1 || $jump > 1000) { throw new Exception(CAL_REPEAT_EVERY_ERROR); } } else $jump = 1; // check for repeating options // 1=repeat once, 2=repeat daily, 3=weekly, 4=monthy, 5=yearly, 6=holiday repeating $oend = null; switch(array_var($event_data,'occurance')){ case "1": $forever = 0; $repeat_d = 0; $repeat_m = 0; $repeat_y = 0; $repeat_h = 0; break; case "2": $repeat_d = $jump; if(isset($forever) && $forever == 1) $oend = null; else $oend = $rend; break; case "3": $repeat_d = 7 * $jump; if(isset($forever) && $forever == 1) $oend = null; else $oend = $rend; break; case "4": $repeat_m = $jump; if(isset($forever) && $forever == 1) $oend = null; else $oend = $rend; break; case "5": $repeat_y = $jump; if(isset($forever) && $forever == 1) $oend = null; else $oend = $rend; break; case "6": $repeat_h = 1; $repeat_h_params = array( 'dow' => array_var($event_data, 'repeat_dow'), 'wnum' => array_var($event_data, 'repeat_wnum'), 'mjump' => array_var($event_data, 'repeat_mjump'), ); break; } $repeat_number = $rnum; // get duration $durationhour = array_var($event_data,'durationhour'); $durationmin = array_var($event_data,'durationmin'); // get event type: 2=full day, 3=time/duratin not specified, 4=time not specified $typeofevent = array_var($event_data,'type_id'); if(!is_numeric($typeofevent) OR ($typeofevent!=1 AND $typeofevent!=2 AND $typeofevent!=3)) $typeofevent = 1; if ($durationhour == 0 && $durationmin < 15 && $typeofevent != 2) { throw new Exception(lang('duration must be at least 15 minutes')); } // calculate timestamp and durationstamp $dt_start = new DateTimeValue(mktime($hour, $minute, 0, $month, $day, $year) - logged_user()->getTimezone() * 3600); $timestamp = $dt_start->format('Y-m-d H:i:s'); $dt_duration = DateTimeValueLib::make($dt_start->getHour() + $durationhour, $dt_start->getMinute() + $durationmin, 0, $dt_start->getMonth(), $dt_start->getDay(), $dt_start->getYear()); $durationstamp = $dt_duration->format('Y-m-d H:i:s'); // organize the data expected by the query function $data = array(); $data['repeat_num'] = $rnum; $data['repeat_h'] = $repeat_h; $data['repeat_dow'] = $repeat_h_params['dow']; $data['repeat_wnum'] = $repeat_h_params['wnum']; $data['repeat_mjump'] = $repeat_h_params['mjump']; $data['repeat_d'] = $repeat_d; $data['repeat_m'] = $repeat_m; $data['repeat_y'] = $repeat_y; $data['repeat_forever'] = $forever; $data['repeat_end'] = $oend; $data['start'] = $timestamp; $data['name'] = array_var($event_data,'name'); $data['description'] = array_var($event_data,'description'); $data['type_id'] = $typeofevent; $data['duration'] = $durationstamp; $data['users_to_invite'] = array(); // options when creating an event through a POP UP if (array_var($_POST, 'popup')){ $user_filter = user_config_option('calendar user filter'); if ($user_filter == '0' || $user_filter == '-1') { $user_filter = logged_user()->getId(); } $data['users_to_invite'][$user_filter] = 0; if ($user_filter != logged_user()->getId() && user_config_option('autoassign_events')){ $data['users_to_invite'][logged_user()->getId()] = 1; } } $compstr = 'invite_user_'; foreach ($event_data as $k => $v) { if (str_starts_with($k, $compstr) && ($v == 'checked' || $v == 'on')) { $data['users_to_invite'][substr($k, strlen($compstr))] = 0; // Pending Answer } } if (isset($event_data['confirmAttendance'])) { $data['confirmAttendance'] = array_var($event_data, 'confirmAttendance'); } if (isset($event_data['send_notification'])) { $data['send_notification'] = array_var($event_data,'send_notification') == 'checked'; } if (isset($event_data['subscribe_invited'])) { $data['subscribe_invited'] = array_var($event_data,'subscribe_invited') == 'checked'; } return $data; }
/** * Returns all events for the given range, tag and considers the active project * * @param DateTimeValue $date * @param String $tags * @return unknown */ static function getRangeProjectEvents(DateTimeValue $start_date, DateTimeValue $end_date, $user_filter = null, $inv_state = null) { $start_year = date("Y", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_month = date("m", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_day = date("d", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $end_year = date("Y", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_month = date("m", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_day = date("d", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); if (!is_numeric($start_day) or !is_numeric($start_month) or !is_numeric($start_year) or !is_numeric($end_day) or !is_numeric($end_month) or !is_numeric($end_year)) { return NULL; } $user = null; if ($user_filter > 0) { $user = Contacts::findById($user_filter); } if ($user_filter != -1 && !$user instanceof Contact) { $user = logged_user(); } $invited = ""; if ($user instanceof Contact) { $invited = " AND o.`id` IN (SELECT `event_id` FROM `" . TABLE_PREFIX . "event_invitations` WHERE `contact_id` = " . $user->getId() . ")"; } $tz_hm = "'" . floor(logged_user()->getTimezone()) . ":" . abs(logged_user()->getTimezone()) % 1 * 60 . "'"; $s_date = new DateTimeValue($start_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date = new DateTimeValue($end_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date->add("d", 1); $start_date_str = $s_date->format("Y-m-d H:i:s"); $end_date_str = $e_date->format("Y-m-d H:i:s"); $first_d = $start_day; while ($first_d > 7) { $first_d -= 7; } $week_of_first_day = date("W", mktime(0, 0, 0, $start_month, $first_d, $start_year)); $conditions = "\r\n\t\t\tAND (type_id=2 OR type_id=1 AND `duration` > `start`)\r\n\t\t\tAND \r\n\t\t\t(\r\n\t\t\t (\r\n\t\t\t\t(\r\n\t\t\t\t\t`repeat_h` = 0\r\n\t\t\t\t\tAND `duration` >= '{$start_date_str}' \r\n\t\t\t\t\tAND `start` < '{$end_date_str}' \r\n\t\t\t\t) \r\n\t\t\t\tOR \r\n\t\t\t\t(\r\n\t\t\t\t\toriginal_event_id = 0\r\n\t\t\t\t\tAND\r\n\t\t\t\t\t`repeat_h` = 0 \r\n\t\t\t\t\tAND\r\n\t\t\t\t\tDATE(`start`) < '{$end_date_str}'\r\n\t\t\t\t\tAND\r\n\t\t\t\t\t(\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_d` DAY) >= '{$start_date_str}' \r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_forever = 1\r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_m` MONTH) >= '{$start_date_str}' \r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_forever = 1\r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_y` YEAR) >= '{$start_date_str}' \r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_forever = 1\r\n\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t)\t\t\r\n\t\t\t\t)\r\n\t\t\t\tOR\r\n\t\t\t\t(\r\n\t\t\t\t\toriginal_event_id = 0\r\n\t\t\t\t\tAND\r\n\t\t\t\t\tDATE(`start`) <= '{$end_date_str}'\r\n\t\t\t\t\tAND\r\n\t\t\t\t\t`repeat_h` = 1 \t\t\t\t\t\r\n\t\t\t\t\tAND\r\n\t\t\t\t\tMOD( ABS(PERIOD_DIFF(DATE_FORMAT(`start`, '%Y%m'), DATE_FORMAT('{$start_date_str}', '%Y%m'))), `repeat_mjump`) = 0\t\t\t\t\t\r\n\t\t\t\t)\r\n\t\t\t )\r\n\t\t\t {$invited}\r\n\t\t\t)"; $result_events = self::instance()->listing(array("order" => 'start', "order_dir" => 'ASC', "extra_conditions" => $conditions))->objects; // Find invitations for events and logged user if (!($user_filter == null && $inv_state == null) && $user_filter != -1) { ProjectEvents::addInvitations($result_events, $user->getId()); foreach ($result_events as $k => $event) { $inv = $event->getInvitations(); if (!is_array($inv)) { if ($inv == null || trim($inv_state) != '-1' && !strstr($inv_state, '' . $inv->getInvitationState()) && $inv->getContactId() == logged_user()->getId()) { unset($result_events[$k]); } } else { if (count($inv) > 0) { foreach ($inv as $key => $v) { if ($v == null || trim($inv_state) != '-1' && !strstr($inv_state, '' . $v->getInvitationState()) && $v->getContactId() == logged_user()->getId()) { unset($result_events[$k]); break; } } } else { unset($result_events[$k]); } } } } return $result_events; }
/** * Returns all events for the given range, tag and considers the active project * * @param DateTimeValue $date * @param String $tags * @return unknown */ static function getRangeProjectEvents(DateTimeValue $start_date, DateTimeValue $end_date, $tags = '', $project = null, $archived = false) { $start_year = date("Y", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_month = date("m", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $start_day = date("d", mktime(0, 0, 1, $start_date->getMonth(), $start_date->getDay(), $start_date->getYear())); $end_year = date("Y", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_month = date("m", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); $end_day = date("d", mktime(0, 0, 1, $end_date->getMonth(), $end_date->getDay(), $end_date->getYear())); if (!is_numeric($start_day) or !is_numeric($start_month) or !is_numeric($start_year) or !is_numeric($end_day) or !is_numeric($end_month) or !is_numeric($end_year)) { return NULL; } $invited = " AND `id` IN (SELECT `event_id` FROM `" . TABLE_PREFIX . "event_invitations` WHERE `contact_id` = " . logged_user()->getId() . ")"; $tz_hm = "'" . floor(logged_user()->getTimezone()) . ":" . abs(logged_user()->getTimezone()) % 1 * 60 . "'"; $s_date = new DateTimeValue($start_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date = new DateTimeValue($end_date->getTimestamp() - logged_user()->getTimezone() * 3600); $e_date->add("d", 1); $start_date_str = $s_date->format("Y-m-d H:i:s"); $end_date_str = $e_date->format("Y-m-d H:i:s"); $first_d = $start_day; while ($first_d > 7) { $first_d -= 7; } $week_of_first_day = date("W", mktime(0, 0, 0, $start_month, $first_d, $start_year)); $conditions = "\tAND ((\n\t\t\t\t(\n\t\t\t\t\t`repeat_h` = 0 \n\t\t\t\t\tAND `duration` >= '{$start_date_str}' \n\t\t\t\t\tAND `start` < '{$end_date_str}' \n\t\t\t\t) \n\t\t\t\tOR \n\t\t\t\t(\n\t\t\t\t\t`repeat_h` = 0 \n\t\t\t\t\tAND\n\t\t\t\t\tDATE(`start`) < '{$end_date_str}'\n\t\t\t\t\tAND\n\t\t\t\t\t(\t\t\t\t\t\t\t\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_d` DAY) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n repeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t)\n\t\t\t\tOR\n\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_m` MONTH) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t\t\t)\n\t\t\t\t\t\tOR\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tDATE_ADD(`start`, INTERVAL (`repeat_num`-1)*`repeat_y` YEAR) >= '{$start_date_str}' \n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_forever = 1\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\trepeat_end >= '{$start_year}-{$start_month}-{$start_day}'\n\t\t\t\t\t\t)\n\t\t\t\t\t)\t\t\n\t\t\t\t)\n\t\t\t\tOR\n\t\t\t\t(\n\t\t\t\t\tDATE(`start`) <= '{$start_date_str}'\n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_h` = 1 \n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_dow` = DAYOFWEEK('{$start_date_str}') \n\t\t\t\t\tAND\n\t\t\t\t\t`repeat_wnum` + {$week_of_first_day} - 1 = WEEK('{$start_date_str}', 3) \n\t\t\t\t\tAND\n\t\t\t\t\tMOD( ABS(PERIOD_DIFF(DATE_FORMAT(`start`, '%Y%m'), DATE_FORMAT('{$start_date_str}', '%Y%m'))), `repeat_mjump`) = 0\t\t\t\t\t\n\t\t\t\t)\t\t\t\t\n\t\t\t)\n\t\t\t{$invited}\n\t\t)"; //$result_events = self::getContentObjects(active_context(), ObjectTypes::findById(self::instance()->getObjectTypeId()), '`start`', 'ASC', $conditions, null, false, false, $start, $limit); $result_events = self::instance()->listing(array("order" => 'start', "order_dir" => 'ASC', "extra_conditions" => $conditions, "start" => $start, "limit" => $limit))->objects; // Find invitations for events and logged user ProjectEvents::addInvitations($result_events); return $result_events; }
/** * Return pick date widget * * @access public * @param string $name Name prefix * @param DateTimeValue $value Can be DateTimeValue object, integer or string * @param integer $year_from Start counting from this year. If NULL this value will be set * to current year - 10 * @param integer $year_to Count to this year. If NULL this value will be set to current * year + 10 * @return null */ function pick_date_widget($name, $value = null, $year_from = null, $year_to = null) { if (!$value instanceof DateTimeValue) { $value = new DateTimeValue($value); } $month_options = array(); for ($i = 1; $i <= 12; $i++) { $option_attributes = $i == $value->getMonth() ? array('selected' => 'selected') : null; $month_options[] = option_tag(lang("month {$i}"), $i, $option_attributes); } // for $day_options = array(); for ($i = 1; $i <= 31; $i++) { $option_attributes = $i == $value->getDay() ? array('selected' => 'selected') : null; $day_options[] = option_tag($i, $i, $option_attributes); } // for $year_from = (int) $year_from < 1 ? $value->getYear() - 10 : (int) $year_from; $year_to = (int) $year_to < 1 || (int) $year_to < $year_from ? $value->getYear() + 10 : (int) $year_to; $year_options = array(); for ($i = $year_from; $i <= $year_to; $i++) { $option_attributes = $i == $value->getYear() ? array('selected' => 'selected') : null; $year_options[] = option_tag($i, $i, $option_attributes); } // if return select_box($name . '_month', $month_options) . select_box($name . '_day', $day_options) . select_box($name . '_year', $year_options); }
/** * This function will return true if this day is today * Date must be in GMT0 * @param void * @return boolean */ function isToday() { $today = DateTimeValueLib::now(); if (logged_user() instanceof Contact) { $date = new DateTimeValue($this->getTimestamp() + logged_user()->getTimezone() * 3600); $today = new DateTimeValue($today->getTimestamp() + logged_user()->getTimezone() * 3600); } else { $date = $this; } return $date->getDay() == $today->getDay() && $date->getMonth() == $today->getMonth() && $date->getYear() == $today->getYear(); }
/** * This function will return true if this day is today * * @param integer $offset * @return boolean */ function isToday($offset = null) { $today = new DateTimeValue(time() + $offset); $today->beginningOfDay(); return $this->getDay() == $today->getDay() && $this->getMonth() == $today->getMonth() && $this->getYear() == $today->getYear(); }
/** * Get log data * * @param integer $revision_to * @param mixed $revision_from * @return array */ function getLogs($revision_to, $revision_from = 'HEAD', $logs_per_query = 100) { // get multiple logs or a single one if (!is_null($revision_from)) { $r = $revision_from . ':' . $revision_to; } else { $r = $revision_to; $this->triggerred_by_handler = true; } // if $string = 'log -r ' . $r . ' --xml --verbose ' . $this->active_repository->getUrl(); $this->execute($string); $log_data = xml2array(implode("\n", $this->output), 1, array('path', 'logentry')); $insert_data = array(); $i = 1; // this is because we get commits from SVN sorted from newest to oldest $logs = is_array($log_data['log']['logentry']) ? array_reverse($log_data['log']['logentry']) : array(); // loop through array of log entries foreach ($logs as $key => $log_entry) { // prevent duplicate entries in case when there are two separate update processes // (like, both scheduled task and aC user triggered the update if (Commits::count("parent_id = '" . $this->active_repository->getId() . "' AND integer_field_1 = '" . $log_entry['attr']['revision'] . "'") > 0) { continue; } // if $paths = array(); $k = 0; foreach ($log_entry['paths']['path'] as $path) { $paths[$k]['path'] = mysql_real_escape_string($path['value']); // paths can contain file names with characters that can break the query $paths[$k]['action'] = $path['attr']['action']; $k++; } // foreach $date = new DateTimeValue($log_entry['date']['value']); $log_date = $date->getYear() . "-" . $date->getMonth() . '-' . $date->getDay() . ' ' . $date->getHour() . ':' . $date->getMinute() . ':' . $date->getSecond(); $commit_message = Commit::analyze_message($log_entry['msg']['value'], $log_entry['author']['value'], $log_entry['attr']['revision'], $this->active_repository, $this->active_project); $insert_data[$i][$key] = "('Commit','Source','" . $this->active_project->getId() . "','" . $this->active_repository->getId() . "','Repository','" . mysql_real_escape_string($commit_message) . "','" . $log_entry['attr']['revision'] . "','" . serialize($paths) . "','" . mysql_real_escape_string($log_entry['author']['value']) . "','{$log_date}', '" . STATE_VISIBLE . "', '" . $this->active_repository->getVisibility() . "')"; $i = count($insert_data[$i]) < $logs_per_query ? $i : $i + 1; } // foreach return array('data' => $insert_data, 'total' => count($logs)); }