function inputTime($name, $default)
{
$defaultHour = getHour($default);
$defaultMin = getMin($default);
if ($defaultHour > 12) {
$realHour = $defaultHour - 12;
} else {
$realHour = $defaultHour;
}
echo "<table cellpadding='0' cellspacing='0'><tr><td rowspan='2'>";
echo "<select id='" . $name . "hour' onchange='changeMade();updateHour(\"" . $name . "\",this.value)'>";
for ($i = 1; $i <= 12; $i++) {
$isSelected = "";
if ($i % 12 == $realHour) {
$isSelected = " selected";
}
echo "<option value='" . $i . "'" . $isSelected . ">" . $i . "</option>";
}
echo "</select></td><td rowspan='2' valign='top'><span style='font-size:12px'><b> : </b></span>";
echo "<input type='text' id='" . $name . "mins' maxlength='2' size='2' value='" . formatMin($defaultMin) . "' onchange='changeMade();updateMin(\"" . $name . "\",this.value)' style='height:16px' /></td>";
echo "<td></td><td>";
echo "<select id='" . $name . "meridian' onchange='changeMade();updateAM(\"" . $name . "\",this.value)'>";
echo "<option value='0'>AM</option>";
echo "<option value='1'" . ($default > 1200 ? " selected" : "") . ">PM</option>";
echo "</select>";
echo "</td></tr><tr><td></td></tr></table>";
echo "<input type='hidden' id='" . $name . "' name='" . $name . "' value='" . $defaultHour * 100 . "' />";
}
function getTimeRow($numberOfHours, $startHour)
{
echo "<tr>";
echo "<td>";
echo "</td>";
for ($i = 0; $i < $numberOfHours; $i++) {
echo "<td>";
echo getHour($startHour + $i);
echo "</td>";
}
echo "</tr>";
}
function onmy_export()
{
$hasMyExportPrivilege = $_ENV['menu']->checkPermission($this->ask_login_name, $_SERVER['QUERY_STRING'], "myExport");
if ($hasMyExportPrivilege['return']) {
if ($_SESSION['my_session']['num'] >= 10000) {
$this->onmy('数据量太大，请重新筛选条件后进行导出！', "errormsg");
exit;
}
require TIPASK_ROOT . '/lib/php_excel.class.php';
$export = array();
$export_header = array("问题ID", "5173帐号", "问题描述", "问题分类", "提问时间", "回答客服", "接手时间", "回答时间", "回复时长", "处理状态", "协助处理", "评价状态", "浏览量", "问题的状态", "来源站点", "游戏名称", "回复内容");
array_push($export, $export_header);
$cat = $_ENV['category']->getNameById();
$_my = $_SESSION['my_session'];
$where = $_ENV['question']->Get_Where($_my['ask_start_time_search'], $_my['ask_end_time_search'], $_my['wait_start_time_search'], $_my['wait_end_time_search'], $_my['answer_start_time_search'], $_my['answer_end_time_search'], $_my['question_start_time_search'], $_my['question_end_time_search'], $_my['revocation_search'], $_my['que_status_search'], $_my['question_search'], $_my['assess_search'], $_my['qid_search'], $_my['operator_search'], $_my['user_name_search'], $_my['question_title_search'], $_my['display_method'], $_my['category_search'], $_my['order_search'], $_my['help_search'], $_my['all_kf_search'], $_my['r_site_search']);
$export_arr = $_ENV['question']->Get_All_Question($where, false, $_my['all_kf_search']);
foreach ($export_arr as $val) {
if ($val['is_pj'] == 0) {
$asses = "未评价";
} elseif ($val['is_pj'] == 1) {
$asses = "满意";
} else {
$asses = "不满意";
}
if ($val['status'] == 1) {
$q_status = "等待处理";
} elseif ($val['status'] == 2) {
$q_status = "等待评价";
} else {
$q_status = "已结束";
}
if ($val[q_handle_status] == 0) {
$mange_status = '未处理';
} else {
$mange_status = '已处理';
}
if ($val[help_status] == 0) {
$help_status = '未协助';
} else {
$help_status = '协助处理';
}
if ($val['r_site'] == 1) {
$r_site = '寄售';
} elseif ($val['r_site'] == 2) {
$r_site = '担保';
} elseif ($val['r_site'] == 3) {
$r_site = '账号';
} else {
$r_site = '';
}
$q_cat = '';
$val['cid'] && ($q_cat .= '-' . $cat[$val['cid']] . '-');
$val['cid1'] && ($q_cat .= '-' . $cat[$val['cid1']] . '-');
$val['cid2'] && ($q_cat .= '-' . $cat[$val['cid2']] . '-');
$val['cid3'] && ($q_cat .= '-' . $cat[$val['cid3']] . '-');
$val['cid4'] && ($q_cat .= '-' . $cat[$val['cid4']] . '-');
$replay_range = getHour($val['Atime'] - $val['receive_time']);
$val['receive_time'] = empty($val['receive_time']) ? '' : date("Y-m-d H:i:s", $val['receive_time']);
$val['Atime'] = empty($val['Atime']) ? '' : date("Y-m-d H:i:s", $val['Atime']);
$answer = $_ENV['answer']->get($val['id']);
$answer['content'] = preg_replace('/[\\s"]/', '', $answer['content']);
//$answer['content'] = preg_replace('/[& "]/','',$answer['content']);
$answer['content'] = strip_tags($answer['content']);
$export[] = array($val['id'], $val['author'], $val['description'], $q_cat, date("Y-m-d H:i:s", $val['time']), $val['Aauthor'], $val['receive_time'], $val['Atime'], $replay_range, $mange_status, $help_status, $asses, $val['views'], $q_status, $r_site, $val['game_name'], $answer['content']);
}
$xls = new Excel_XML('UTF-8', false, 'My Sheet');
$xls->addArray($export);
$xls->generateXML('question' . date('Ymd'));
} else {
$hasMyExportPrivilege['url'] = "?admin_question/my";
__msg($hasMyExportPrivilege);
}
}
<?php
include "./funktionen.php";
$sql = query("UPDATE einstellungen SET maxWasser = '" . $_GET['maxWasser'] . "' , diffTemp = '" . $_GET['diffTemp'] . "' , minSolar = '" . $_GET['minSolar'] . "' , startPumpe = '" . getTime($_GET['minZeit']) . "' , stopPumpe = '" . getTime($_GET['maxZeit']) . "' , startPumpe1 = '" . getTime($_GET['minZeit1']) . "' , stopPumpe1 = '" . getTime($_GET['maxZeit1']) . "', startTablet = '" . getTime($_GET['minZeitTablet']) . "' , stopTablet = '" . getTime($_GET['maxZeitTablet']) . "' , tabletWochentag = '" . $_GET['tabletLadezeit'] . "' ");
$status = '';
$sql = query("SELECT * FROM einstellungen");
$row = fetch($sql);
if ($row[maxWasser] == $_GET['maxWasser'] && $row[diffTemp] == $_GET['diffTemp'] && $row[minSolar] == $_GET['minSolar'] && $row[startPumpe] == getTime($_GET['minZeit']) && $row[stopPumpe] == getTime($_GET['maxZeit']) && $row[startTablet] == getTime($_GET['minZeitTablet']) && $row[stopTablet] == getTime($_GET['maxZeitTablet']) && $row[tabletWochentag] == $_GET['tabletLadezeit']) {
$status = 1;
} else {
$status = 0;
}
writeCrontab(getHour($_GET['minZeit']), getHour($_GET['maxZeit']), getHour($_GET['minZeit1']), getHour($_GET['maxZeit1']), getHour($_GET['minZeitTablet']), getHour($_GET['maxZeitTablet']), str_replace(";", ",", $_GET['tabletLadezeit']));
echo $status;
function getHour($min)
{
$hour = floor($min / 60);
return $hour;
}
function getTime($min)
{
$hours = floor($min / 60);
$minutes = $min - $hours * 60;
if (strlen($hours) == 1) {
$hours = "0" . $hours;
}
if (strlen($minutes) == 1) {
$minutes = "0" . $minutes;
}
$time = $hours . ":" . $minutes . ":00";
return $time;
