Esempio n. 1
0
 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' => '哇,你已经全部都看完了!'));
         }
     }
 }
Esempio n. 2
0
 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");
             }
         }
     }
 }
Esempio n. 3
0
 /**
  * 检查程序,检查阶段涨幅数据是否更新
  */
 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");
     }
 }
Esempio n. 4
0
 public static function getData($project, $name)
 {
     $sql = "SELECT * FROM " . self::tStyle . " WHERE project='{$project}' AND name='{$name}' ";
     $resource = DB::getLine($sql);
     return $resource;
 }