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;