$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;
}
