$options[$field][$value] = "DB" . $value; } } } else { foreach (dbFetchAll($sql, $field, array_values($fieldValues)) as $value) { if ($value != '') { $options[$field][] = $value; } } } } if (count($filter)) { $sql = "SELECT count(*) AS Available FROM Logs WHERE " . join(' AND ', $where); $available = dbFetchOne($sql, 'Available', array_values($values)); } ajaxResponse(array('updated' => preg_match('/%/', DATE_FMT_CONSOLE_LONG) ? strftime(DATE_FMT_CONSOLE_LONG) : date(DATE_FMT_CONSOLE_LONG), 'total' => $total, 'available' => isset($available) ? $available : $total, 'logs' => $logs, 'state' => logState(), 'options' => $options)); break; case 'export': if (!canView('System')) { ajaxError('Insufficient permissions to export logs'); } $minTime = isset($_POST['minTime']) ? $_POST['minTime'] : NULL; $maxTime = isset($_POST['maxTime']) ? $_POST['maxTime'] : NULL; if (!is_null($minTime) && !is_null($maxTime) && $minTime > $maxTime) { $tempTime = $minTime; $minTime = $maxTime; $maxTime = $tempTime; } //$limit = isset($_POST['limit'])?$_POST['limit']:1000; $filter = isset($_POST['filter']) ? $_POST['filter'] : array(); $sortField = isset($_POST['sortField']) ? $_POST['sortField'] : 'TimeKey';
if (ZM_OPT_X10 && canView('Devices')) { ?> <div id="devices"><?php echo makePopupLink('?view=devices', 'zmDevices', 'devices', translate('Devices')); ?> </div> <?php } if (canView('System')) { ?> <div id="options"><?php echo makePopupLink('?view=options', 'zmOptions', 'options', translate('Options')); if (logToDatabase() > Logger::NOLOG) { ?> / <?php echo makePopupLink('?view=log', 'zmLog', 'log', '<span class="' . logState() . '">' . translate('Log') . '</span>'); } ?> </div> <?php } if (canView('Stream') && $cycleCount > 1) { $cycleGroup = isset($_COOKIE['zmGroup']) ? $_COOKIE['zmGroup'] : 0; ?> <div id="cycleMontage"> <?php echo makePopupLink('?view=cycle&group=' . $cycleGroup, 'zmCycle' . $cycleGroup, array('cycle', $cycleWidth, $cycleHeight), translate('Cycle'), $running); ?> / <?php echo makePopupLink('?view=montage&group=' . $cycleGroup, 'zmMontage' . $cycleGroup, 'montage', translate('Montage'), $running);
if (ZM_OPT_X10 && canView('Devices')) { ?> <div id="devices"><?php echo makePopupLink('?view=devices', 'zmDevices', 'devices', $SLANG['Devices']); ?> </div> <?php } if (canView('System')) { ?> <div id="options"><?php echo makePopupLink('?view=options', 'zmOptions', 'options', $SLANG['Options']); if (logToDatabase() > Logger::NOLOG) { ?> / <?php echo makePopupLink('?view=log', 'zmLog', 'log', '<span class="' . logState() . '">' . $SLANG['Log'] . '</span>'); } ?> </div> <?php } if (canView('Stream') && $cycleCount > 1) { $cycleGroup = isset($_COOKIE['zmGroup']) ? $_COOKIE['zmGroup'] : 0; ?> <div id="cycleMontage"><?php echo makePopupLink('?view=cycle&group=' . $cycleGroup, 'zmCycle' . $cycleGroup, array('cycle', $cycleWidth, $cycleHeight), $SLANG['Cycle'], $running); ?> / <?php echo makePopupLink('?view=montage&group=' . $cycleGroup, 'zmMontage' . $cycleGroup, 'montage', $SLANG['Montage'], $running); ?> </div>