public function error() { $_GET = array(); $_GET['id'] = intval($_GET['id']); $_GET['password'] = $_GET['password']; $_GET['type'] = $_GET['type']; $_GET['msg'] = addslashes($_GET['msg']); $_GET['msg'] = iconv('gb2312', 'utf-8', $interArray['msg']); $_GET['ip'] = $_SERVER['REMOTE_ADDR']; if ($_GET['pid'] == "" or $_GET['type_id'] == "" or $_GET['code'] == "" or $_GET['msg'] == "") { Message::showError('传入参数有误,请对照文档检查您的传入参数!'); } else { if (!is_numeric($_GET['pid'])) { Message::showError('pid错误,不是数字', $_GET['id']); return 0; } //验证id和密码 $projectDB = new ProjectModelDB(); $passwd = $projectDB->getRow("SELECT * FROM `" . $projectDB->getTableName() . "` WHERE `id` = " . intval($_GET['id'])); if ($_GET['password'] != $passwd['password']) { Message::showError('您所传入的项目passowrd不正确', $_GET['password']); return 0; } else { //type 是否为现有类型,不是则插入到setting表中;是则将有关id,type,msg写到err_msg表中 if (!is_numeric(intval($_GET['type_id']))) { Message::showError('type_id错误,不能为非数字类型,请对照后台查询类型号', $_GET['type_id']); return 0; } else { $settingsDB = new SettingsModelDB(); $sid = $settingsDB->getFirst("SELECT id FROM `" . $settingsDB->getTableName() . "` WHERE `type` = " . intval($_GET['type_id'])); if (empty($sid)) { $settingsInsertArr['pid'] = $_GET['id']; $settingsDB->insert($settingsInsertArr); } //不管type是什么都执行以下msg操作! $errMsgDB = new ErrmsgModelDB(); $value = $errMsgDB->insertMsg($_GET['id'], intval($interArray['type']), $interArray['msg'], $interArray['ip']); if ($value) { //return true; echo json_encode(array('stat' => 0, 'info' => 'insert message,ok')); } else { Message::showError('写入message时,数据库错误', $value); } } } } }
public function detail() { $sid = intval($_GET['sub_mid']); if (md5(md5(md5(implode('|', array($sid, '!mrala', date('Y-m-d')))))) !== $_GET['sign']) { Message::showError('sign fail'); } else { $submoduleDB = new SubmoduleModelDB(); $submodule = $submoduleDB->getRow('SELECT mid, code, name FROM `' . $submoduleDB->getTableName() . '` WHERE id=?', array(intval($sid))); $moduleDB = new ModuleModelDB(); $module = $moduleDB->getRow('SELECT sys_mid, pid FROM `' . $moduleDB->getTableName() . '` WHERE id=?', array(intval($submodule['mid']))); $sysmoduleDB = new SysmoduleModelDB(); $sysmodule = $sysmoduleDB->getRow('SELECT `name` FROM `' . $sysmoduleDB->getTableName() . '` WHERE id=?', array(intval($module['sys_mid']))); $projectDB = new ProjectModelDB(); $project = $projectDB->getRow('SELECT `name` FROM `' . $projectDB->getTableName() . '` WHERE id=?', array(intval($module['pid']))); $this->setView('project', $project); $this->setView('sysmodule', $sysmodule); $this->setView('submodule', $submodule); $this->setView('sub_mid', $sid); $this->display('mobile/details.html'); } }
public function delete() { $projectDB = new ProjectModelDB(); $whereArr = array(); $whereArr['id'] = $_GET['id']; $sql = "SELECT * FROM `" . $projectDB->getTableName() . "` WHERE `id` = ?"; $row = $projectDB->getRow($sql, array_values($whereArr)); $rs = $projectDB->delete($whereArr); Log::write($this->adminUserName, $this->ip, $_GET['id'], self::$state . "__" . self::$action, $rs, Log::arrayToLog($row)); $rs ? Message::showSucc('删除成功') : Message::showError('删除失败:' . implode(" ", $projectDB->getErrorInfo())); }
require PATH_ROOT . 'libs/DaggerSysInitConfig.php'; //系统配置 require PATH_LIBS . 'basics.php'; //__autoload函数 require PATH_ROOT . 'config/DBConfig.php'; //载入数据库配置 //==========取代global.php功能==========// $time = time(); $db = new QueueRuntimeModelDB(); $sql = "SELECT * FROM " . $db->getTableName() . " WHERE `begin_time` < ?"; $data = $db->getData($sql, array($time - 60 * 50)); if (!empty($data)) { $ndb = new ProjectModelDB(); $queueConfigDB = new QueueConfigModelDB(); foreach ($data as $v) { $row = $ndb->getRow("SELECT `id`,`key`,`name` FROM `" . $ndb->getTableName() . "` WHERE `id` = ?", array($v['project_id'])); $task = trim(array_shift(explode(' ', $v['task']))); $runTimeConfig = $queueConfigDB->getFirst("SELECT `time` FROM `" . $queueConfigDB->getTableName() . "` WHERE `project_id` = ? AND `task` = ?", array($v['project_id'], $task)); if (empty($runTimeConfig)) { $runTimeConfig = 50; } $runTime = intval(($time - $v['begin_time']) / 60); if ($runTime >= $runTimeConfig) { $message = "[{$row['name']}]的队列[{$v['task']}]于[" . date("Y-m-d H:i:s", $v['begin_time']) . "]在[{$v['ip']}]开始运行,目前已超过{$runTime}分钟!"; // 多个监控点,同一次错误只提醒一次 $mc = new MyMemcache(); $mcKey = md5($message . $row['key'] . $row['id']); if ($mc->addPlain($mcKey, 1, 50)) { BaseModelHttp::sendRequest(array('http://i.alarm.mix.sina.com.cn/alarm.php', array('pid' => $row['id'], 'key' => $row['key'], 'sys_mid' => 8, 'code' => 1, 'message' => $message, 'name' => '队列超时', 'client_ip' => '127.0.0.1'))); // BaseModelHttp::sendRequest(array('http://i.alarm.mix.sina.com.cn/alarm.php',array('pid'=>1,'key'=>'b662346b2d7da90b8413a5ee095c8ff4','sys_mid'=>8,'code'=>1,'message'=>$message,'name'=>'队列超时','client_ip'=>'127.0.0.1'))); }