function article($id = null) { $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $pageSize = isset($_GET['pagesize']) ? intval($_GET['pagesize']) : 10; if ($id) { $id = intval($id); $sql = "SELECT * FROM SIMU WHERE ID ={$id}"; $article = DB::getLine($sql); if ($article) { self::json(array('code' => 0, 'data' => $article)); } else { self::json(array('code' => -1, 'msg' => '没有找到这篇文章哦!')); } } else { $offset = ($page - 1) * $pageSize; $sql = "SELECT * FROM SIMU ORDER BY UPDATEID LIMIT {$offset},{$pageSize}"; $data = DB::getData($sql); if ($data) { foreach ($data as &$item) { unset($item['CONTENT']); } $total = DB::getVar("SELECT COUNT(1) FROM SIMU"); $total = ceil($total / $pageSize); self::json(array('code' => 0, 'page' => $page, 'total' => $total, 'data' => $data)); } else { self::json(array('code' => -1, 'msg' => '哇,你已经全部都看完了!')); } } }
private function toDb($result) { foreach ($result as $name => $item) { foreach ($item as $code) { $origin = DB::getLine("SELECT * FROM `invest_product` WHERE code='{$code}'"); $comments = explode(',', $origin['comment']); $comments = array_filter($comments, function ($value) { return trim($value); }); if (!in_array($name, $comments) && !empty($origin)) { $comments[] = $name; $comments = implode(',', $comments); $sql = "UPDATE `invest_product` SET comment='{$comments}' WHERE code ='{$code}' "; $ret = DB::runSql($sql); self::log("Updated {$code},Result:{$ret}"); } else { self::log("Code {$code} Already Update-To-Date"); } } } }
/** * 检查程序,检查阶段涨幅数据是否更新 */ function check() { $code = 530008; $sql = "SELECT * FROM `fund_data` WHERE `code`={$code} ORDER BY create_date DESC"; $data = DB::getLine($sql); $lastUpdate = strtotime($data['update_date']); $last = date('Y-m-d H:i:s', time() - 21600); if ($lastUpdate < time() - 21600) { self::log('!!!!Warning:fund_data was not update at least 6 hours'); } else { $num = DB::getVar("SELECT count(1) FROM `fund_data` where update_date > '{$last}'"); self::log("fund_data was updated at {$data['update_date']},please check {$code} {$data['increase']}"); self::log("total update {$num}/3034"); } //下面检查货币基金 $date = DB::getVar("SELECT date(create_date) create_date FROM `fund_value` WHERE `code`=740601 ORDER BY create_date DESC LIMIT 1"); if ($date != date('Y-m-d', strtotime('-1 days'))) { self::log("!!!!Warning:fund_value has no yesterday data,recent date {$date}"); } else { self::log("fund_value last update {$date}"); $last = date('Y-m-d 00:00:00', strtotime('-1 days')); $num = DB::getVar("SELECT count(1) FROM `fund_value` where create_date = '{$last}'"); self::log("total update {$num}/3107"); } }
public static function getData($project, $name) { $sql = "SELECT * FROM " . self::tStyle . " WHERE project='{$project}' AND name='{$name}' "; $resource = DB::getLine($sql); return $resource; }