/** * Called by the Event Queue processor to process a reminder * on a task. * @access public * @param string $module Module name (not used) * @param string $type Type of event (not used) * @param integer $id ID of task being reminded * @param integer $owner Originator of event * @param mixed $args event-specific arguments. * @return mixed true, dequeue event, false, event stays in queue. -1, event is destroyed. */ function remind($module, $type, $id, $owner, &$args) { global $locale_char_set, $AppUI; $q = new DBQuery(); $df = $AppUI->getPref('SHDATEFORMAT'); $tf = $AppUI->getPref('TIMEFORMAT'); // If we don't have preferences set for these, use ISO defaults. if (!$df) { $df = '%Y-%m-%d'; } if (!$tf) { $tf = '%H:%m'; } $df .= ' ' . $tf; // At this stage we won't have an object yet if (!$this->load($id)) { return -1; // No point it trying again later. } $this->htmlDecode(); // Only remind on working days. $today = new CDate(); if (!$today->isWorkingDay()) { return true; } // Check if the task is completed if ($this->task_percent_complete == 100) { return -1; } // Grab the assignee list $q->addTable('user_tasks', 'ut'); $q->leftJoin('users', 'u', 'u.user_id = ut.user_id'); $q->leftJoin('contacts', 'c', 'c.contact_id = u.user_contact'); $q->addQuery('c.contact_id, contact_first_name, contact_last_name, contact_email'); $q->addWhere('ut.task_id = ' . $id); $contacts = $q->loadHashList('contact_id'); $q->clear(); // Now we also check the owner of the task, as we will need // to notify them as well. $owner_is_not_assignee = false; $q->addTable('users', 'u'); $q->leftJoin('contacts', 'c', 'c.contact_id = u.user_contact'); $q->addQuery('c.contact_id, contact_first_name, contact_last_name, contact_email'); $q->addWhere('u.user_id = ' . $this->task_owner); if ($q->exec(ADODB_FETCH_NUM)) { list($owner_contact, $owner_first_name, $owner_last_name, $owner_email) = $q->fetchRow(); if (!isset($contacts[$owner_contact])) { $owner_is_not_assignee = true; $contacts[$owner_contact] = array('contact_id' => $owner_contact, 'contact_first_name' => $owner_first_name, 'contact_last_name' => $owner_last_name, 'contact_email' => $owner_email); } } $q->clear(); // build the subject line, based on how soon the // task will be overdue. $starts = new CDate($this->task_start_date); $expires = new CDate($this->task_end_date); $now = new CDate(); $diff = $expires->dateDiff($now); $prefix = $AppUI->_('Task Due', UI_OUTPUT_RAW); if ($diff == 0) { $msg = $AppUI->_('TODAY', UI_OUTPUT_RAW); } else { if ($diff == 1) { $msg = $AppUI->_('TOMORROW', UI_OUTPUT_RAW); } else { if ($diff < 0) { $msg = $AppUI->_(array('OVERDUE', abs($diff), 'DAYS')); $prefix = $AppUI->_('Task', UI_OUTPUT_RAW); } else { $msg = $AppUI->_(array($diff, 'DAYS')); } } } $q->addTable('projects'); $q->addQuery('project_name'); $q->addWhere('project_id = ' . $this->task_project); $project_name = htmlspecialchars_decode($q->loadResult()); $q->clear(); $subject = $prefix . ' ' . $msg . ' ' . $this->task_name . '::' . $project_name; $body = $AppUI->_('Task Due', UI_OUTPUT_RAW) . ': ' . $msg . "\n" . $AppUI->_('Project', UI_OUTPUT_RAW) . ': ' . $project_name . "\n" . $AppUI->_('Task', UI_OUTPUT_RAW) . ': ' . $this->task_name . "\n" . $AppUI->_('Start Date', UI_OUTPUT_RAW) . ': ' . $starts->format($df) . "\n" . $AppUI->_('Finish Date', UI_OUTPUT_RAW) . ': ' . $expires->format($df) . "\n" . $AppUI->_('URL', UI_OUTPUT_RAW) . ': ' . DP_BASE_URL . '/index.php?m=tasks&a=view&task_id=' . $this->task_id . '&reminded=1' . "\n\n" . $AppUI->_('Resources', UI_OUTPUT_RAW) . ":\n"; foreach ($contacts as $contact) { if ($owner_is_not_assignee || $contact['contact_id'] != $owner_contact) { $body .= $contact['contact_first_name'] . ' ' . $contact['contact_last_name'] . ' <' . $contact['contact_email'] . ">\n"; } } $body .= "\n" . $AppUI->_('Description', UI_OUTPUT_RAW) . ":\n" . $this->task_description . "\n"; $mail = new Mail(); foreach ($contacts as $contact) { if ($mail->ValidEmail($contact['contact_email'])) { $mail->To($contact['contact_email']); } } $mail->From('"' . $owner_first_name . ' ' . $owner_last_name . '" <' . $owner_email . '>'); $mail->Subject($subject, $locale_char_set); $mail->Body($body, $locale_char_set); return $mail->Send(); }
<?php $total_sum = 0; foreach ($projects as $id => $project_name) { ?> <tr> <td style="background:#8AC6FF; text-align:right;"><?php echo $project_name; ?> </td> <td style="background:#8AC6FF;"> </td> <?php $date = new CDate($start_report); $sum_project = 0; for ($i = 0; $i < $start_report->getDaysInMonth(); $i++) { if ($date->isWorkingDay()) { ?> <td style="background:#8AC6FF;text-align:center;" align="right"> <?php } else { ?> <td style="background:#EF95CB;text-align:center;" align="right"> <?php } ?> <?php if (isset($projects_hours[$id][$date->format('%Y-%m-%d')])) { printf("%.1f", $projects_hours[$id][$date->format('%Y-%m-%d')]); $sum_project += $projects_hours[$id][$date->format('%Y-%m-%d')]; }
function calc_duration($start_date = null, $end_date = null) { // global $AppUI; $cal_day_start = intval(dPgetConfig('cal_day_start')); $cal_day_end = intval(dPgetConfig('cal_day_end')); $count = new CDate($start_date); $end = new CDate($end_date); $total_dias = 0; while ($count <= $end) { if ($count->isWorkingDay()) { $total_dias++; } $count->addDays(1); } return $total_dias; }
function clash_process() { global $AppUI, $do_include; $obj =& new CEvent(); $obj->bind($_SESSION['add_event_post']); $attendees = $_SESSION['add_event_attendees']; $users = array(); if (isset($attendees) && $attendees) { $users = explode(',', $attendees); } array_push($users, $obj->event_owner); // First remove any duplicates $users = array_unique($users); // Now remove any null entries, so implode doesn't create a dud SQL // Foreach is safer as it works on a copy of the array. foreach ($users as $key => $user) { if (!$user) { unset($users[$key]); } } $start_date =& new CDate($_POST['event_start_date'] . "000000"); $end_date =& new CDate($_POST['event_end_date'] . "235959"); // First find any events in the range requested. $event_list = $obj->getEventsInWindow($start_date->format(FMT_DATETIME_MYSQL), $end_date->format(FMT_DATETIME_MYSQL), (int) ($_POST['start_time'] / 100), (int) ($_POST['end_time'] / 100), $users); $event_start_date =& new CDate($_POST['event_start_date'] . $_POST['start_time']); $event_end_date =& new CDate($_POST['event_end_date'] . $_POST['end_time']); if (!$event_list || !count($event_list)) { // First available date/time is OK, seed addEdit with the details. $obj->event_start_date = $event_start_date->format(FMT_DATETIME_MYSQL); $obj->event_end_date = $event_end_date->format(FMT_DATETIME_MYSQL); $_SESSION['add_event_post'] = get_object_vars($obj); $AppUI->setMsg('No clashes in suggested timespan', UI_MSG_OK); $_SESSION['event_is_clash'] = true; $_GET['event_id'] = $obj->event_id; $do_include = DP_BASE_DIR . "/modules/calendar/addedit.php"; return; } // Now we grab the events, in date order, and compare against the // required start and end times. // Working in 30 minute increments from the start time, and remembering // the end time stipulation, find the first hole in the times. // Determine the duration in hours/minutes. $start_hour = (int) ($_POST['start_time'] / 10000); $start_minutes = (int) ($_POST['start_time'] % 10000 / 100); $start_time = $start_hour * 60 + $start_minutes; $end_hour = (int) ($_POST['end_time'] / 10000); $end_minutes = (int) ($_POST['end_time'] % 10000 / 100); $end_time = $end_hour * 60 + $end_minutes - $_POST['duration']; // First, build a set of "slots" that give us the duration // and start/end times we need $first_day = $start_date->format('%E'); $end_day = $end_date->format('%E'); $days_between = $end_day + 1 - $first_day; $oneday =& new Date_Span(array(1, 0, 0, 0)); $slots = array(); $slot_count = 0; $first_date = new CDate($start_date); for ($i = 0; $i < $days_between; $i++) { if ($first_date->isWorkingDay()) { $slots[$i] = array(); for ($j = $start_time; $j <= $end_time; $j += 30) { $slot_count++; $slots[$i][] = array('date' => $first_date->format('%Y-%m-%d'), 'start_time' => $j, 'end_time' => $j + $_POST['duration'], 'committed' => false); } } $first_date->addSpan($oneday); } // Now process the events list foreach ($event_list as $event) { $sdate = new CDate($event['event_start_date']); $edate = new CDate($event['event_end_date']); $sday = $sdate->format('%E'); $day_offset = $sday - $first_day; // Now find the slots on that day that match list($syear, $smonth, $sday, $shour, $sminute, $ssecond) = sscanf($event['event_start_date'], "%4d-%2d-%2d %2d:%2d:%2d"); list($eyear, $emonth, $eday, $ehour, $eminute, $esecond) = sscanf($event['event_start_date'], "%4d-%2d-%2d %2d:%2d:%2d"); $start_mins = $shour * 60 + $sminute; $end_mins = $ehour * 60 + $eminute; if (isset($slots[$day_offset])) { foreach ($slots[$day_offset] as $key => $slot) { if ($start_mins <= $slot['end_time'] && $end_mins >= $slot['start_time']) { $slots[$day_offset][$key]['committed'] = true; } } } } // Third pass through, find the first uncommitted slot; foreach ($slots as $day_offset => $day_slot) { foreach ($day_slot as $slot) { if (!$slot['committed']) { $hour = (int) ($slot['start_time'] / 60); $min = $slot['start_time'] % 60; $ehour = (int) ($slot['end_time'] / 60); $emin = $slot['end_time'] % 60; $obj->event_start_date = $slot['date'] . " " . sprintf("%02d:%02d:00", $hour, $min); $obj->event_end_date = $slot['date'] . " " . sprintf("%02d:%02d:00", $ehour, $emin); $_SESSION['add_event_post'] = get_object_vars($obj); $AppUI->setMsg('First available time slot', UI_MSG_OK); $_SESSION['event_is_clash'] = true; $_GET['event_id'] = $obj->event_id; $do_include = DP_BASE_DIR . "/modules/calendar/addedit.php"; return; } } } // If we get here we have found no available slots clear_clash(); $AppUI->setMsg("No times match your parameters", UI_MSG_ALERT); $AppUI->redirect(); }
function clash_process() { global $AppUI, $do_include; $obj =& new CEvent(); $obj->bind($_SESSION['add_event_post']); $attendees = $_SESSION['add_event_attendees']; $users = array(); if (isset($attendees) && $attendees) { $users = explode(',', $attendees); } array_push($users, $obj->event_owner); // First remove any duplicates $users = array_unique($users); // Now remove any null entries, so implode doesn't create a dud SQL // Foreach is safer as it works on a copy of the array. foreach ($users as $key => $user) { if (!$user) { unset($users[$key]); } } // First find any events in the range requested. $start_date = new CDate($_POST['event_start_date'] . $_POST['start_time']); $end_date = new CDate($_POST['event_start_date'] . $_POST['start_time']); $end_date->addSeconds($_POST['duration'] * 60); $final_date = new CDate($_POST['event_end_date'] . $_POST['end_time']); $original_event_start = $obj->event_start_date; $original_event_end = $obj->event_end_date; $user_list = implode(',', $users); // Now we grab the events, in date order, and compare against the // required start and end times. // Working in 30 minute increments from the start time, and remembering // the end time stipulation, find the first hole in the times. // Determine the duration in hours/minutes. $start_hour = (int) ($_POST['start_time'] / 10000); $start_minutes = (int) ($_POST['start_time'] % 10000 / 100); $start_min_offset = $start_hour * 60 + $start_minutes; $end_hour = (int) ($_POST['end_time'] / 10000); $end_minutes = (int) ($_POST['end_time'] % 10000 / 100); $end_min_offset = $end_hour * 60 + $end_minutes - $_POST['duration']; // First, build a set of "slots" that give us the duration // and start/end times we need $first_day = $start_date->format('%E'); $end_day = $final_date->format('%E'); $oneday =& new Date_Span(array(1, 0, 0, 0)); $slots = array(); $curr_date = new CDate($start_date); $curr_date->setTime(0, 0, 0); $inc = intval(dPgetConfig('cal_day_increment')) ? intval(dPgetConfig('cal_day_increment')) : 30; for ($i = 0; $i <= $end_day - $first_day; $i++) { if ($curr_date->isWorkingDay()) { for ($j = $start_min_offset; $j <= $end_min_offset; $j += $inc) { $is_committed = false; $slot_start_date = new CDate($curr_date); $slot_start_date->addSeconds($j * 60); $slot_end_date = new CDate($slot_start_date); $slot_end_date->addSeconds($_POST['duration'] * 60); $obj->event_start_date = $slot_start_date->format('%Y-%m-%d %T'); $obj->event_end_date = $slot_end_date->format('%Y-%m-%d %T'); if (!($clash = $obj->checkClash($user_list))) { $_SESSION['add_event_post'] = get_object_vars($obj); $AppUI->setMsg('First available time slot', UI_MSG_OK); $_SESSION['event_is_clash'] = true; $_GET['event_id'] = $obj->event_id; $do_include = DP_BASE_DIR . '/modules/calendar/addedit.php'; return; } } } $curr_date->addSpan($oneday); $curr_date->setTime(0, 0, 0); } // If we get here we have found no available slots $obj->event_start_date = $original_event_start; $obj->event_end_date = $original_event_end; clear_clash(); $AppUI->setMsg('No times match your parameters', UI_MSG_ALERT); $AppUI->redirect(); }