$queryFields[] = $stfields['stime']; } if (!empty($stfields['etime'])) { $queryFields[] = $stfields['etime']; } if (isset($stfields['subject'])) { $descflds = explode(',', $stfields['subject']); foreach ($descflds as $dfld) { $queryFields[] = $dfld; } } $queryGenerator->setFields($queryFields); if ($record != "") { $queryGenerator->addCondition('id', $record, 'e', $queryGenerator::$AND); } else { $dtflds = getDateFieldsOfModule($modtab[$activitytypeid]); $queryGenerator->startGroup(); foreach ($dtflds as $field) { $queryGenerator->addCondition($field, array(0 => $start_date, 1 => $end_date), 'bw', $queryGenerator::$OR); } $queryGenerator->startGroup('OR'); $queryGenerator->addCondition($stfields['start'], $start_date, 'b'); $queryGenerator->addCondition($stfields['end'], $end_date, 'a', $queryGenerator::$AND); $queryGenerator->endGroup(); $queryGenerator->endGroup(); $queryGenerator->addCondition('assigned_user_id', getUserFullName($userid), 'e', $queryGenerator::$AND); if (count($Event_Status) > 0) { $evuniq = array_diff(array('Held', 'Not Held', 'Planned'), array_unique($Event_Status)); $encompas_group = false; foreach ($evuniq as $evstat) { if (isset($Module_Status_Fields[$evstat])) {
function getModuleCalendarFields($module) { global $adb, $log, $current_user; $rscalflds = $adb->pquery('select * from its4you_calendar_modulefields where module=? and (userid=? or userid=1) order by userid desc', array($module, $current_user->id)); if ($rscalflds and $adb->num_rows($rscalflds) > 0) { $calflds = $adb->fetch_row($rscalflds); $Module_StartEnd_Fields = array('start' => $calflds['start_field'], 'end' => $calflds['end_field'], 'stime' => $calflds['start_time'], 'etime' => $calflds['end_time'], 'subject' => $calflds['subject_fields'], 'color' => $calflds['color']); } else { // it isn't registered > we look for custom fields $tid = getTabid($module); $dtflds = getDateFieldsOfModule($tid); if (count($dtflds) > 0) { $tmflds = getTimeFieldsOfModule($tid); $Module_StartEnd_Fields = array('start' => $dtflds[0], 'end' => isset($dtflds[1]) ? $dtflds[1] : '', 'stime' => isset($tmflds[0]) ? $tmflds[0] : '', 'etime' => isset($tmflds[1]) ? $tmflds[1] : '', 'subject' => '', 'color' => ''); } else { $Module_StartEnd_Fields = array(); } } return $Module_StartEnd_Fields; }