1332 lines
39 KiB
PHP
1332 lines
39 KiB
PHP
<?php
|
||
namespace App\Http\mode;
|
||
use Illuminate\Support\Facades\DB;
|
||
|
||
class Sina
|
||
{
|
||
|
||
|
||
public function etfgp($name){
|
||
|
||
$klinedemo='{
|
||
"code": 1,
|
||
"data": [
|
||
{
|
||
"volume": 322,
|
||
"high": "153.5900",
|
||
"amount": 49440.4,
|
||
"low": "153.5200",
|
||
"day": "2024-05-23 15:35:00",
|
||
"close": "153.5200",
|
||
"open": "153.5900"
|
||
},
|
||
{
|
||
"volume": 557,
|
||
"high": "153.5000",
|
||
"amount": 85489,
|
||
"low": "153.4650",
|
||
"day": "2024-05-23 15:36:00",
|
||
"close": "153.4650",
|
||
"open": "153.5000"
|
||
},
|
||
{
|
||
"volume": 402,
|
||
"high": "153.5550",
|
||
"amount": 61729.1,
|
||
"low": "153.5550",
|
||
"day": "2024-05-23 15:38:00",
|
||
"close": "153.5550",
|
||
"open": "153.5550"
|
||
},
|
||
{
|
||
"volume": 718,
|
||
"high": "153.6099",
|
||
"amount": 110286,
|
||
"low": "153.5805",
|
||
"day": "2024-05-23 15:39:00",
|
||
"close": "153.6099",
|
||
"open": "153.6000"
|
||
},
|
||
{
|
||
"volume": 300,
|
||
"high": "153.6000",
|
||
"amount": 46076.5,
|
||
"low": "153.5800",
|
||
"day": "2024-05-23 15:40:00",
|
||
"close": "153.5800",
|
||
"open": "153.6000"
|
||
},
|
||
{
|
||
"volume": 241,
|
||
"high": "153.6100",
|
||
"amount": 37020,
|
||
"low": "153.6100",
|
||
"day": "2024-05-23 15:41:00",
|
||
"close": "153.6100",
|
||
"open": "153.6100"
|
||
},
|
||
{
|
||
"volume": 417,
|
||
"high": "153.6200",
|
||
"amount": 64059.5,
|
||
"low": "153.6200",
|
||
"day": "2024-05-23 15:42:00",
|
||
"close": "153.6200",
|
||
"open": "153.6200"
|
||
},
|
||
{
|
||
"volume": 462,
|
||
"high": "153.5550",
|
||
"amount": 70934.2,
|
||
"low": "153.4900",
|
||
"day": "2024-05-23 15:43:00",
|
||
"close": "153.4900",
|
||
"open": "153.5550"
|
||
},
|
||
{
|
||
"volume": 196,
|
||
"high": "153.4851",
|
||
"amount": 30083.1,
|
||
"low": "153.4851",
|
||
"day": "2024-05-23 15:44:00",
|
||
"close": "153.4851",
|
||
"open": "153.4851"
|
||
},
|
||
{
|
||
"volume": 135,
|
||
"high": "153.5400",
|
||
"amount": 20727.9,
|
||
"low": "153.5400",
|
||
"day": "2024-05-23 15:45:00",
|
||
"close": "153.5400",
|
||
"open": "153.5400"
|
||
},
|
||
{
|
||
"volume": 850,
|
||
"high": "153.4700",
|
||
"amount": 130411,
|
||
"low": "153.3700",
|
||
"day": "2024-05-23 15:46:00",
|
||
"close": "153.3700",
|
||
"open": "153.4700"
|
||
},
|
||
{
|
||
"volume": 525,
|
||
"high": "153.3650",
|
||
"amount": 80513.9,
|
||
"low": "153.3404",
|
||
"day": "2024-05-23 15:47:00",
|
||
"close": "153.3404",
|
||
"open": "153.3650"
|
||
},
|
||
{
|
||
"volume": 1087,
|
||
"high": "153.3850",
|
||
"amount": 166703,
|
||
"low": "153.3400",
|
||
"day": "2024-05-23 15:48:00",
|
||
"close": "153.3850",
|
||
"open": "153.3600"
|
||
},
|
||
{
|
||
"volume": 425,
|
||
"high": "153.4500",
|
||
"amount": 65215.2,
|
||
"low": "153.4450",
|
||
"day": "2024-05-23 15:50:00",
|
||
"close": "153.4450",
|
||
"open": "153.4500"
|
||
},
|
||
{
|
||
"volume": 921,
|
||
"high": "153.5200",
|
||
"amount": 141360,
|
||
"low": "153.4300",
|
||
"day": "2024-05-23 15:51:00",
|
||
"close": "153.4300",
|
||
"open": "153.5200"
|
||
},
|
||
{
|
||
"volume": 303,
|
||
"high": "153.4950",
|
||
"amount": 46506.5,
|
||
"low": "153.4700",
|
||
"day": "2024-05-23 15:52:00",
|
||
"close": "153.4950",
|
||
"open": "153.4700"
|
||
},
|
||
{
|
||
"volume": 386,
|
||
"high": "153.4700",
|
||
"amount": 59236.3,
|
||
"low": "153.4500",
|
||
"day": "2024-05-23 15:53:00",
|
||
"close": "153.4700",
|
||
"open": "153.4600"
|
||
},
|
||
{
|
||
"volume": 683,
|
||
"high": "153.5150",
|
||
"amount": 104849,
|
||
"low": "153.4950",
|
||
"day": "2024-05-23 15:54:00",
|
||
"close": "153.5150",
|
||
"open": "153.4950"
|
||
},
|
||
{
|
||
"volume": 1022,
|
||
"high": "153.5200",
|
||
"amount": 156869,
|
||
"low": "153.4700",
|
||
"day": "2024-05-23 15:55:00",
|
||
"close": "153.5100",
|
||
"open": "153.5200"
|
||
},
|
||
{
|
||
"volume": 4004,
|
||
"high": "153.5000",
|
||
"amount": 614144,
|
||
"low": "153.2800",
|
||
"day": "2024-05-23 15:56:00",
|
||
"close": "153.3850",
|
||
"open": "153.5000"
|
||
},
|
||
{
|
||
"volume": 202,
|
||
"high": "153.3900",
|
||
"amount": 30984.8,
|
||
"low": "153.3900",
|
||
"day": "2024-05-23 15:57:00",
|
||
"close": "153.3900",
|
||
"open": "153.3900"
|
||
},
|
||
{
|
||
"volume": 597,
|
||
"high": "153.4550",
|
||
"amount": 91582.4,
|
||
"low": "153.3700",
|
||
"day": "2024-05-23 15:58:00",
|
||
"close": "153.4550",
|
||
"open": "153.3700"
|
||
},
|
||
{
|
||
"volume": 3067,
|
||
"high": "153.4700",
|
||
"amount": 470600,
|
||
"low": "153.4100",
|
||
"day": "2024-05-23 15:59:00",
|
||
"close": "153.4200",
|
||
"open": "153.4200"
|
||
},
|
||
{
|
||
"volume": 2310,
|
||
"high": "153.4600",
|
||
"amount": 354412,
|
||
"low": "153.3400",
|
||
"day": "2024-05-23 16:00:00",
|
||
"close": "153.4400",
|
||
"open": "153.4600"
|
||
}
|
||
],
|
||
"message": "OK"
|
||
}';
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/us/kline";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
$querys = "symbol=$name&type=1&limit=100";
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
|
||
$kline = curl_exec($curl);
|
||
|
||
|
||
$data_array = json_decode($kline,true);
|
||
|
||
if($data_array['code']==0) $data_array = json_decode($klinedemo,true);
|
||
|
||
$str2 = $data_array['data'];
|
||
foreach ($str2 as $k=>$v){
|
||
|
||
|
||
$data_arr[] = [
|
||
"id" => strtotime($v['day']),
|
||
"period" => '1min',
|
||
"base-currency" => $name,
|
||
"quote-currency" => 'USDC',
|
||
"open" => $v['open'],//开
|
||
"close" => $v['close'],//关
|
||
"high" => $v['high'],//高
|
||
"low" =>$v['low'],//低
|
||
"vol" => $v['volume'],//交易量
|
||
"amount" =>$v['amount']//数量
|
||
];
|
||
}//777
|
||
|
||
|
||
return $data_arr;
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
public function real_gu($name){
|
||
|
||
$hq =
|
||
'{
|
||
"msg": "ok",
|
||
"code": 1,
|
||
"data": {
|
||
"VPU": {
|
||
"after_price": "152.9300",
|
||
"volume_avg10": "180154",
|
||
"market_value": "6134400000",
|
||
"trade_time": "2024-05-24 04:00:00",
|
||
"change": "-2.7400",
|
||
"eps": "0.00",
|
||
"after_volume": "241",
|
||
"volume": "171928",
|
||
"shares": "40000000",
|
||
"after_change": "-0.43",
|
||
"high": "155.9400",
|
||
"update_time": "2024-05-24 09:46:10",
|
||
"low": "153.2800",
|
||
"pe": "--",
|
||
"price": "153.3600",
|
||
"name": "公用事业股ETF",
|
||
"dividend": "0.00",
|
||
"52week_low": "116.4040",
|
||
"after_changeRate": "-0.28",
|
||
"changeRate": "-1.76",
|
||
"preclose": "156.1000",
|
||
"open": "155.9400",
|
||
"52week_high": "158.0700",
|
||
"after_time": "2024-05-24 07:25:00"
|
||
}
|
||
},
|
||
"time": 1716519177
|
||
}';
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/us/real";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
$querys = "symbol=$name";
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
|
||
$realhq = curl_exec($curl);
|
||
|
||
|
||
$data_array = json_decode($realhq,true);
|
||
// print_r($data_array);exit;
|
||
if($data_array['code']==1 && !empty($data_array['data'])){
|
||
$str = $data_array['data'][$name];
|
||
}
|
||
|
||
|
||
if($data_array['code']==0 || $realhq=='' || empty($data_array['data'])){
|
||
$data_array = json_decode($hq,true);
|
||
|
||
$str = $data_array['data']['VPU'];
|
||
}
|
||
|
||
// print_r($data_array);exit;
|
||
|
||
$info = DB::table('currency')->where('vcode',$name)->first();
|
||
|
||
$data = [];
|
||
$data['now_price'] = $str['price'];//最新价格
|
||
$data['add_time'] = time();
|
||
$data['change'] = $str['changeRate'];
|
||
$data['high'] = $str['high'];//最高 √
|
||
$data['low'] = $str['low'];//最低 √
|
||
$data['open'] = $str['open'];//开 √
|
||
$data['close'] = $str['preclose'];//关
|
||
$data['volume'] = $str['volume'];
|
||
|
||
DB::table('currency_quotation')->where('currency_id',$info->id)->update($data);
|
||
// echo $info->id;
|
||
// print_r($data);exit;
|
||
}
|
||
|
||
//k线类型， 1:1分钟，5：五分钟；15：15分钟；30:30分钟，60:60分钟，120:120分钟，240:日K，1200:周K，7200:月K，21600:季K，43200:半年K，86400:年K
|
||
//ETFGP
|
||
public function geteftgp($name, $peroid, $limit)
|
||
{
|
||
|
||
$klinedemo='{
|
||
"code": 1,
|
||
"data": [
|
||
{
|
||
"volume": 322,
|
||
"high": "153.5900",
|
||
"amount": 49440.4,
|
||
"low": "153.5200",
|
||
"day": "2024-05-23 15:35:00",
|
||
"close": "153.5200",
|
||
"open": "153.5900"
|
||
},
|
||
{
|
||
"volume": 557,
|
||
"high": "153.5000",
|
||
"amount": 85489,
|
||
"low": "153.4650",
|
||
"day": "2024-05-23 15:36:00",
|
||
"close": "153.4650",
|
||
"open": "153.5000"
|
||
},
|
||
{
|
||
"volume": 402,
|
||
"high": "153.5550",
|
||
"amount": 61729.1,
|
||
"low": "153.5550",
|
||
"day": "2024-05-23 15:38:00",
|
||
"close": "153.5550",
|
||
"open": "153.5550"
|
||
},
|
||
{
|
||
"volume": 718,
|
||
"high": "153.6099",
|
||
"amount": 110286,
|
||
"low": "153.5805",
|
||
"day": "2024-05-23 15:39:00",
|
||
"close": "153.6099",
|
||
"open": "153.6000"
|
||
},
|
||
{
|
||
"volume": 300,
|
||
"high": "153.6000",
|
||
"amount": 46076.5,
|
||
"low": "153.5800",
|
||
"day": "2024-05-23 15:40:00",
|
||
"close": "153.5800",
|
||
"open": "153.6000"
|
||
},
|
||
{
|
||
"volume": 241,
|
||
"high": "153.6100",
|
||
"amount": 37020,
|
||
"low": "153.6100",
|
||
"day": "2024-05-23 15:41:00",
|
||
"close": "153.6100",
|
||
"open": "153.6100"
|
||
},
|
||
{
|
||
"volume": 417,
|
||
"high": "153.6200",
|
||
"amount": 64059.5,
|
||
"low": "153.6200",
|
||
"day": "2024-05-23 15:42:00",
|
||
"close": "153.6200",
|
||
"open": "153.6200"
|
||
},
|
||
{
|
||
"volume": 462,
|
||
"high": "153.5550",
|
||
"amount": 70934.2,
|
||
"low": "153.4900",
|
||
"day": "2024-05-23 15:43:00",
|
||
"close": "153.4900",
|
||
"open": "153.5550"
|
||
},
|
||
{
|
||
"volume": 196,
|
||
"high": "153.4851",
|
||
"amount": 30083.1,
|
||
"low": "153.4851",
|
||
"day": "2024-05-23 15:44:00",
|
||
"close": "153.4851",
|
||
"open": "153.4851"
|
||
},
|
||
{
|
||
"volume": 135,
|
||
"high": "153.5400",
|
||
"amount": 20727.9,
|
||
"low": "153.5400",
|
||
"day": "2024-05-23 15:45:00",
|
||
"close": "153.5400",
|
||
"open": "153.5400"
|
||
},
|
||
{
|
||
"volume": 850,
|
||
"high": "153.4700",
|
||
"amount": 130411,
|
||
"low": "153.3700",
|
||
"day": "2024-05-23 15:46:00",
|
||
"close": "153.3700",
|
||
"open": "153.4700"
|
||
},
|
||
{
|
||
"volume": 525,
|
||
"high": "153.3650",
|
||
"amount": 80513.9,
|
||
"low": "153.3404",
|
||
"day": "2024-05-23 15:47:00",
|
||
"close": "153.3404",
|
||
"open": "153.3650"
|
||
},
|
||
{
|
||
"volume": 1087,
|
||
"high": "153.3850",
|
||
"amount": 166703,
|
||
"low": "153.3400",
|
||
"day": "2024-05-23 15:48:00",
|
||
"close": "153.3850",
|
||
"open": "153.3600"
|
||
},
|
||
{
|
||
"volume": 425,
|
||
"high": "153.4500",
|
||
"amount": 65215.2,
|
||
"low": "153.4450",
|
||
"day": "2024-05-23 15:50:00",
|
||
"close": "153.4450",
|
||
"open": "153.4500"
|
||
},
|
||
{
|
||
"volume": 921,
|
||
"high": "153.5200",
|
||
"amount": 141360,
|
||
"low": "153.4300",
|
||
"day": "2024-05-23 15:51:00",
|
||
"close": "153.4300",
|
||
"open": "153.5200"
|
||
},
|
||
{
|
||
"volume": 303,
|
||
"high": "153.4950",
|
||
"amount": 46506.5,
|
||
"low": "153.4700",
|
||
"day": "2024-05-23 15:52:00",
|
||
"close": "153.4950",
|
||
"open": "153.4700"
|
||
},
|
||
{
|
||
"volume": 386,
|
||
"high": "153.4700",
|
||
"amount": 59236.3,
|
||
"low": "153.4500",
|
||
"day": "2024-05-23 15:53:00",
|
||
"close": "153.4700",
|
||
"open": "153.4600"
|
||
},
|
||
{
|
||
"volume": 683,
|
||
"high": "153.5150",
|
||
"amount": 104849,
|
||
"low": "153.4950",
|
||
"day": "2024-05-23 15:54:00",
|
||
"close": "153.5150",
|
||
"open": "153.4950"
|
||
},
|
||
{
|
||
"volume": 1022,
|
||
"high": "153.5200",
|
||
"amount": 156869,
|
||
"low": "153.4700",
|
||
"day": "2024-05-23 15:55:00",
|
||
"close": "153.5100",
|
||
"open": "153.5200"
|
||
},
|
||
{
|
||
"volume": 4004,
|
||
"high": "153.5000",
|
||
"amount": 614144,
|
||
"low": "153.2800",
|
||
"day": "2024-05-23 15:56:00",
|
||
"close": "153.3850",
|
||
"open": "153.5000"
|
||
},
|
||
{
|
||
"volume": 202,
|
||
"high": "153.3900",
|
||
"amount": 30984.8,
|
||
"low": "153.3900",
|
||
"day": "2024-05-23 15:57:00",
|
||
"close": "153.3900",
|
||
"open": "153.3900"
|
||
},
|
||
{
|
||
"volume": 597,
|
||
"high": "153.4550",
|
||
"amount": 91582.4,
|
||
"low": "153.3700",
|
||
"day": "2024-05-23 15:58:00",
|
||
"close": "153.4550",
|
||
"open": "153.3700"
|
||
},
|
||
{
|
||
"volume": 3067,
|
||
"high": "153.4700",
|
||
"amount": 470600,
|
||
"low": "153.4100",
|
||
"day": "2024-05-23 15:59:00",
|
||
"close": "153.4200",
|
||
"open": "153.4200"
|
||
},
|
||
{
|
||
"volume": 2310,
|
||
"high": "153.4600",
|
||
"amount": 354412,
|
||
"low": "153.3400",
|
||
"day": "2024-05-23 16:00:00",
|
||
"close": "153.4400",
|
||
"open": "153.4600"
|
||
}
|
||
],
|
||
"message": "OK"
|
||
}';
|
||
|
||
|
||
|
||
$types=240;
|
||
if($peroid=="1D") $types=240;
|
||
if($peroid=="1min") $types=1;
|
||
if($peroid=="5min") $types=5;
|
||
if($peroid=="15min") $types=15;
|
||
if($peroid=="30min") $types=30;
|
||
if($peroid=="60min") $types=60;
|
||
if($peroid=="120min") $types=120;
|
||
if($peroid=="1hour") $types=60;
|
||
if($peroid=="1week") $types=1200;
|
||
if($peroid=="1mon") $types=7200;
|
||
if($peroid=="1year") $types=86400;
|
||
if($peroid=="1M") $types=1200;
|
||
if($peroid=="1W") $types=7200;
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/us/kline";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
$querys = "symbol=".$name."&type=".$types."&limit=".$limit;
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
|
||
$kline = curl_exec($curl);
|
||
|
||
|
||
$data_array = json_decode($kline,true);
|
||
|
||
// file_put_contents('/www/wwwroot/crypto/public/w2.txt',json_encode($data_array).PHP_EOL,FILE_APPEND);
|
||
|
||
|
||
if($data_array['code']==0 || empty($data_array['data'])) $data_array = json_decode($klinedemo,true);
|
||
|
||
$str2 = $data_array['data'];
|
||
foreach ($str2 as $k=>$v){
|
||
|
||
|
||
$data_arr[] = [
|
||
"id" => strtotime($v['day']),
|
||
"period" => $peroid,
|
||
"base-currency" => $name,
|
||
"quote-currency" => 'USDC',
|
||
"open" => $v['open'],//开
|
||
"close" => $v['close'],//关
|
||
"high" => $v['high'],//高
|
||
"low" =>$v['low'],//低
|
||
"vol" => $v['volume'],//交易量
|
||
"amount" =>$v['amount']//数量
|
||
];
|
||
}//777
|
||
|
||
|
||
return $data_arr;
|
||
|
||
|
||
}
|
||
|
||
|
||
//外汇
|
||
public function getKline($name, $peroid, $limit)
|
||
{
|
||
$types=240;
|
||
if($peroid=="1D") $types=0;
|
||
if($peroid=="1min") $types=1;
|
||
if($peroid=="5min") $types=5;
|
||
if($peroid=="15min") $types=15;
|
||
if($peroid=="30min") $types=30;
|
||
if($peroid=="60min") $types=60;
|
||
if($peroid=="1hour") $types=60;
|
||
if($peroid=="1week") $types=120;
|
||
if($peroid=="1mon") $types=240;
|
||
if($peroid=="1year") $types=240;
|
||
if($peroid=="1M") $types=0;
|
||
if($peroid=="1W") $types=0;
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/waihui/kline";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
// $querys = "symbol=".$name;
|
||
$querys = "symbol=".$name."&type=".$types."&limit=".$limit;
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
$res=curl_exec($curl);
|
||
$res = json_decode($res, true);
|
||
$data_arr = [];
|
||
if (!isset($res['data']['lines'])) {
|
||
return [];
|
||
}
|
||
|
||
foreach ($res['data']['lines'] as $key => $item) {
|
||
$data_arr[] = [
|
||
"id" => $item[6],
|
||
"period" => $peroid,
|
||
"base-currency" =>$name,
|
||
"quote-currency" =>'USDC',
|
||
"open" => $item[0],
|
||
"close" => $item[1],
|
||
"high" => $item[2],
|
||
"low" => $item[3],
|
||
"vol" => 0,
|
||
"amount" => $item[0]
|
||
];
|
||
|
||
// $res1 = array_reverse($data_arr);
|
||
}
|
||
|
||
return $data_arr;
|
||
|
||
}
|
||
//贵金属
|
||
public function getwaipanKline($name, $peroid, $limit)
|
||
{
|
||
|
||
$types=240;
|
||
if($peroid=="1D") $types=0;
|
||
if($peroid=="1min") $types=1;
|
||
if($peroid=="5min") $types=5;
|
||
if($peroid=="15min") $types=15;
|
||
if($peroid=="30min") $types=30;
|
||
if($peroid=="60min") $types=60;
|
||
if($peroid=="1hour") $types=60;
|
||
if($peroid=="1week") $types=120;
|
||
if($peroid=="1mon") $types=240;
|
||
if($peroid=="1year") $types=240;
|
||
if($peroid=="1M") $types=0;
|
||
if($peroid=="1W") $types=0;
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/waipan/kline";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
// $querys = "symbol=".$name;
|
||
$querys = "symbol=".$name."&type=".$types."&limit=".$limit;
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
$res = curl_exec($curl);
|
||
|
||
$res = json_decode($res, true);
|
||
$data_arr = [];
|
||
if (!isset($res['data']['lines'])) {
|
||
return [];
|
||
}
|
||
|
||
foreach ($res['data']['lines'] as $key => $item) {
|
||
$data_arr[] = [
|
||
"id" => $item[7],
|
||
"period" => $peroid,
|
||
"base-currency" =>$name,
|
||
"quote-currency" =>'USDC',
|
||
"open" => $item[0],
|
||
"close" => $item[1],
|
||
"high" => $item[2],
|
||
"low" => $item[3],
|
||
"vol" => $item[6],
|
||
"amount" => $item[0]
|
||
];
|
||
|
||
// $res1 = array_reverse($data_arr);
|
||
}
|
||
|
||
return $data_arr;
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
public function sina($name){
|
||
$code = $name;
|
||
$time = date('Y_m_d',time());
|
||
//preg_match_all("/[a-zA-Z]{1}/",$code,$arrAl);
|
||
//echo "字母个数:".count($arrAl[0])."<br/>";
|
||
$url = "https://stock2.finance.sina.com.cn/futures/api/openapi.php/GlobalFuturesService.getGlobalFuturesMinLine?symbol=$code&callback=var%20t1hf_W=";//分k
|
||
//$url = "https://gu.sina.cn/ft/api/jsonp.php/var%20_W_5_1663703010461=/GlobalService.getMink?symbol=XAU&type=5";//5分
|
||
header('Connection: Upgrade');
|
||
header('Pragma: no-cache');
|
||
header('Cache-Control: no-cache');
|
||
header('Accept-Encoding: gzip, deflate, br');
|
||
header('Accept-Language: zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7');
|
||
header('User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Mobile Safari/537.36');
|
||
$html = html_entity_decode(file_get_contents("$url"));
|
||
$str2 = substr($html, 61);
|
||
$str2 = substr_replace($str2,"",-2,2);
|
||
$str2 = json_decode($str2,true);
|
||
$str2 = $str2['result']['data']['minLine_1d'];
|
||
// echo json_encode($str2);exit;
|
||
foreach ($str2 as $k=>$v){
|
||
if($k>0){//777
|
||
/*应甲方要求，个别前端有问题，进行数据修改，不要删改，不然前端有意想不到的惊喜*/
|
||
if($name=="NG"||$name=="XPD"){
|
||
$rand = '0.0'.rand(rand(1,3),rand(5,9));
|
||
$rand1 = '0.0'.rand(rand(1,3),rand(5,9));
|
||
$rand2 = '0.0'.rand(rand(1,3),rand(5,9));
|
||
$rand3 = '0.0'.rand(rand(1,3),rand(5,9));
|
||
|
||
}else{
|
||
$rand = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand1 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand2 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand3 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
|
||
}
|
||
|
||
if(rand(1,2)==1){
|
||
$open = $v[1]/100*$rand3+$v[1];
|
||
|
||
}else
|
||
{
|
||
$open = $v[1]-$v[1]/100*$rand3;
|
||
|
||
}
|
||
|
||
if(rand(1,2)==1)
|
||
{
|
||
$close = $v[1]-$v[1]/100*$rand2;
|
||
|
||
}else{
|
||
$close = $v[1]-$v[1]/100*$rand2;
|
||
|
||
}
|
||
/**/
|
||
if($k==count($str2)-1){
|
||
$info = DB::table('currency')->where('name',$name)->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
$bi = DB::table('currency_quotation')->where('currency_id',$info['id'])->first();
|
||
$bi = json_encode($bi);
|
||
$bi = json_decode($bi,true);
|
||
$close = $bi['now_price'];
|
||
}
|
||
$data_arr[] = [
|
||
"id" => strtotime($v[5]),
|
||
"period" => '1min',
|
||
"base-currency" => $name,
|
||
"quote-currency" => 'USDC',
|
||
"open" => $open,//开
|
||
"close" => $close,//关
|
||
"high" => $v[1]+$v[1]/100*$rand1,//高
|
||
"low" =>$v[1]-$v[1]/100*$rand,//低
|
||
"vol" => 0,//交易量
|
||
"amount" => 0//数量
|
||
];
|
||
}//777
|
||
}
|
||
//return array_reverse($data_arr);
|
||
return $data_arr;
|
||
}
|
||
//外汇
|
||
public function foreign($name){
|
||
|
||
|
||
$result =DB::table('currency')->where('name',$name)->first();
|
||
$code = $result->vcode;
|
||
|
||
|
||
$time = date('Y_m_d',time());
|
||
$url = "https://vip.stock.finance.sina.com.cn/forex/api/jsonp.php/var%20_fx_susdcad_1_1708783212908=/NewForexService.getMinKline?symbol=$code&scale=1&datalen=1440" ;//分k
|
||
header('Connection: Upgrade');
|
||
header('Pragma: no-cache');
|
||
header('Cache-Control: no-cache');
|
||
header('Accept-Encoding: gzip, deflate, br');
|
||
header('Accept-Language: zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7');
|
||
header('User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Mobile Safari/537.36');
|
||
$html = html_entity_decode(file_get_contents("$url"));
|
||
$str2 = substr($html, 82);
|
||
$str2 = substr_replace($str2,"",-2,2);
|
||
$str2 = json_decode($str2,true);
|
||
foreach ($str2 as $k=>$v){
|
||
if($k>0){//777
|
||
/*应甲方要求，个别前端有问题，进行数据修改，不要删改，不然前端有意想不到的惊喜*/
|
||
if($name=="GBP"||$name=="NZD"||$name=="EUR"){
|
||
$rand = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand1 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand2 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
$rand3 = '0.00'.rand(rand(1,3),rand(5,9));
|
||
if(rand(1,2)==1){
|
||
$open = $v['o']/100*$rand3+$v['o'];
|
||
|
||
}else{
|
||
$open = $v['o']-$v['o']/100*$rand3;
|
||
|
||
}
|
||
|
||
if(rand(1,2)==1){
|
||
$close = $v['o']-$v['o']/100*$rand2;
|
||
|
||
}else
|
||
{
|
||
$close = $v['o']-$v['o']/100*$rand2;
|
||
|
||
}
|
||
|
||
}else{
|
||
$open = $v['o'];
|
||
$close = $v['c'];
|
||
|
||
}
|
||
/**/
|
||
|
||
if($k==count($str2)-1){
|
||
$info = DB::table('currency')->where('name',$name)->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
$bi = DB::table('currency_quotation')->where('currency_id',$info['id'])->first();
|
||
$bi = json_encode($bi);
|
||
$bi = json_decode($bi,true);
|
||
$close = $bi['now_price'];
|
||
}
|
||
|
||
$data_arr[] = [
|
||
"id" => strtotime($v['d']),
|
||
"period" => '1min',
|
||
"base-currency" => $name,
|
||
"quote-currency" => 'USDC',
|
||
"open" => $open,//开
|
||
"close" => $close,//关
|
||
"high" => $v['h'],//高
|
||
"low" =>$v['l'],//低
|
||
"vol" => $v['o'],//交易量
|
||
"amount" => $v['o']//数量
|
||
];
|
||
}
|
||
}
|
||
//return array_reverse($data_arr);
|
||
return $data_arr;
|
||
}
|
||
|
||
|
||
//内部调用实时采集价格
|
||
public function real_s($name){
|
||
$hq = '{
|
||
"msg": "ok",
|
||
"code": 1,
|
||
"data": {
|
||
"change": "0.3800",
|
||
"ask_vol": "0",
|
||
"bid_vol": "0",
|
||
"hold": "0",
|
||
"volume": 0,
|
||
"high": "2339.64",
|
||
"update_time": 1719582600,
|
||
"low": "2318.94",
|
||
"price": "2327.71",
|
||
"name": "伦敦金（现货黄金）",
|
||
"ask": "2328.06",
|
||
"changeRate": "0.0163",
|
||
"preclose": "2327.33",
|
||
"bid": "2327.71",
|
||
"open": "2327.53"
|
||
},
|
||
"time": 1719582646
|
||
}';
|
||
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/waipan/real";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
$querys = "symbol=$name";
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
|
||
$realhq = curl_exec($curl);
|
||
|
||
|
||
$data_array = json_decode($realhq,true);
|
||
|
||
if($data_array['code']==1 && !empty($data_array['data'])){
|
||
$str = $data_array['data'];
|
||
}
|
||
if($data_array['code']==0 || $realhq=='' || empty($data_array['data'])){
|
||
$data_array = json_decode($hq,true);
|
||
|
||
$str = $data_array['data'];
|
||
}
|
||
|
||
// print_r($data_array);exit;
|
||
|
||
$info = DB::table('currency')->where('vcode',$name)->first();
|
||
|
||
$data = [];
|
||
$data['now_price'] = $str['price'];//最新价格
|
||
$data['add_time'] = time();
|
||
$data['change'] = $str['changeRate'];
|
||
$data['high'] = $str['high'];//最高 √
|
||
$data['low'] = $str['low'];//最低 √
|
||
$data['open'] = $str['open'];//开 √
|
||
$data['close'] = $str['preclose'];//关
|
||
$data['volume'] = $str['volume'];
|
||
|
||
DB::table('currency_quotation')->where('currency_id',$info->id)->update($data);
|
||
// echo $info->id;
|
||
// print_r($data);exit;
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
//内部调用实时采集价格
|
||
public function real_s_sina($name){
|
||
$curl = curl_init();
|
||
curl_setopt_array($curl, array(
|
||
CURLOPT_URL => 'https://w.sinajs.cn/?_=0.6314213010647229&list=hf_'.$name,
|
||
CURLOPT_RETURNTRANSFER => true,
|
||
CURLOPT_ENCODING => '',
|
||
CURLOPT_MAXREDIRS => 10,
|
||
CURLOPT_TIMEOUT => 0,
|
||
CURLOPT_FOLLOWLOCATION => true,
|
||
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
|
||
CURLOPT_CUSTOMREQUEST => 'POST',
|
||
CURLOPT_HTTPHEADER => array(
|
||
'referer: https://finance.sina.com.cn/'
|
||
),
|
||
));
|
||
$response = curl_exec($curl);
|
||
curl_close($curl);
|
||
// file_put_contents('/www/wwwroot/crypto/public/w.txt',$name."--".$response);
|
||
preg_match_all("/[a-zA-Z]{1}/",$name,$arrAl);
|
||
$str2 = substr($response, 16+count($arrAl[0]));
|
||
$str2 = substr_replace($str2,"",-3,2);
|
||
//echo $str2;
|
||
$str = explode(',',$str2);
|
||
//$str[0];//最新价格 $str[4];最高价 $str[5];最低价
|
||
$info = DB::table('currency')->where('name',$name)->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
if(round(100-round($str[0]/$info['price']*100,2),2)>0){
|
||
$chanhe = '+'.round(100-round($str[0]/$info['price']*100,2),2);
|
||
}else{
|
||
$chanhe = round(100-round($str[0]/$info['price']*100,2),2);
|
||
}
|
||
$data['now_price'] = $str[0];//最新价格
|
||
$data['add_time'] = time();
|
||
$data['change'] = bcdiv($chanhe,100,2);
|
||
$data['high'] = $str[4];//最高 √
|
||
$data['low'] = $str[5];//最低 √
|
||
$data['open'] = $str[8];//开 √
|
||
$data['close'] = $str[0];//关
|
||
$data['volume'] = $str[9];//交易量
|
||
DB::table('currency_quotation')->where('currency_id',$info['id'])->update($data);
|
||
//DB::table('currency')->where('id',$info['id'])->update(['price'=>$str[0]]);
|
||
}
|
||
//实时采集期货价格
|
||
public function real(){
|
||
//$this->real_s('XAU');exit;
|
||
//$this->real_s($name);
|
||
$list = DB::table('currency_matches')->where('market_from',3)->paginate(100);
|
||
$list = json_encode($list);
|
||
$list = json_decode($list,true);
|
||
$l = array();
|
||
foreach ($list['data'] as $k=>$v){
|
||
$info = DB::table('currency')->where('id',$v['currency_id'])->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
$this->real_s($info['vcode']);
|
||
}
|
||
/// echo 'success';
|
||
}
|
||
|
||
|
||
|
||
//实时采集股票价格
|
||
public function gpreal(){
|
||
//$this->real_s('XAU');exit;
|
||
//$this->real_s($name);
|
||
$list = DB::table('currency_matches')->where('market_from',6)->paginate(100);
|
||
|
||
$list = json_encode($list);
|
||
$list = json_decode($list,true);
|
||
$l = array();
|
||
|
||
foreach ($list['data'] as $k=>$v){
|
||
$info = DB::table('currency')->where('id',$v['currency_id'])->first();
|
||
|
||
$this->real_gu($info->vcode);
|
||
}
|
||
// echo 'success';
|
||
}
|
||
|
||
//实时采集股票价格
|
||
public function etfreal(){
|
||
//$this->real_s('XAU');exit;
|
||
//$this->real_s($name);
|
||
$list = DB::table('currency_matches')->where('market_from',9)->paginate(100);
|
||
$list = json_encode($list);
|
||
$list = json_decode($list,true);
|
||
$l = array();
|
||
foreach ($list['data'] as $k=>$v){
|
||
$info = DB::table('currency')->where('id',$v['currency_id'])->first();
|
||
|
||
$this->real_gu($info->vcode);
|
||
}
|
||
// echo 'success';
|
||
}
|
||
|
||
|
||
//实时采集外汇价格
|
||
public function foreign_real(){
|
||
$list = DB::table('currency_matches')->where('market_from',0)->paginate(100);
|
||
$list = json_encode($list);
|
||
$list = json_decode($list,true);
|
||
$l = array();
|
||
foreach ($list['data'] as $k=>$v){
|
||
$info = DB::table('currency')->where('id',$v['currency_id'])->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
$this->foreign_s($info['real_name']);
|
||
}
|
||
// echo 'success';
|
||
}
|
||
|
||
//外汇实时采集
|
||
//内部调用实时采集价格
|
||
public function foreign_s($name){
|
||
// $name = strtolower($name);
|
||
|
||
$hq ='{
|
||
"msg": "ok",
|
||
"code": 1,
|
||
"data": {
|
||
"EURUSD": {
|
||
"change": "-0.000220",
|
||
"update_time": 1719582553,
|
||
"bofu": "0.00348",
|
||
"high": "1.071990",
|
||
"low": "1.068510",
|
||
"price": "1.070210",
|
||
"name": "欧元兑美元即期汇率",
|
||
"ask": "1.070230",
|
||
"bid": "1.070210",
|
||
"preclose": "1.070430",
|
||
"changeRate": "-0.020000",
|
||
"open": "1.070470",
|
||
"zhenfu": "0.3251"
|
||
}
|
||
},
|
||
"time": 1719582560
|
||
}';
|
||
|
||
|
||
$host = "http://finance.market.alicloudapi.com";
|
||
$path = "/waihui/real";
|
||
$method = "GET";
|
||
$appcode = "38e9f1ff393246c6b9f3569512e1e5c4";
|
||
$headers = array();
|
||
array_push($headers, "Authorization:APPCODE " . $appcode);
|
||
$querys = "symbol=".$name;
|
||
$bodys = "";
|
||
$url = $host . $path . "?" . $querys;
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, $method);
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
|
||
curl_setopt($curl, CURLOPT_FAILONERROR, false);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_HEADER, 0);
|
||
if (1 == strpos("$".$host, "https://"))
|
||
{
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
|
||
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
|
||
}
|
||
$realhq = curl_exec($curl);
|
||
|
||
|
||
$data_array = json_decode($realhq,true);
|
||
// file_put_contents('/www/wwwroot/crypto/public/w2.txt',json_encode($realhq)."--".json_encode($data_array).PHP_EOL,FILE_APPEND);
|
||
if($data_array['code']==1 && !empty($data_array['data'])){
|
||
$str = $data_array['data'][$name];
|
||
}
|
||
if($data_array['code']==0 || $realhq=='' || empty($data_array['data'])){
|
||
$data_array = json_decode($hq,true);
|
||
|
||
$str = $data_array['data']['EURUSD'];
|
||
}
|
||
|
||
|
||
|
||
// print_r($data_array);exit;
|
||
|
||
$info = DB::table('currency')->where('real_name',$name)->first();
|
||
|
||
$data = [];
|
||
$data['now_price'] = $str['price'];//最新价格
|
||
$data['add_time'] = time();
|
||
$data['change'] = $str['changeRate'];
|
||
$data['high'] = $str['high'];//最高 √
|
||
$data['low'] = $str['low'];//最低 √
|
||
$data['open'] = $str['open'];//开 √
|
||
$data['close'] = $str['preclose'];//关
|
||
$data['volume'] = 0;
|
||
|
||
|
||
|
||
DB::table('currency_quotation')->where('currency_id',$info->id)->update($data);
|
||
|
||
|
||
}
|
||
|
||
|
||
//外汇实时采集
|
||
//内部调用实时采集价格
|
||
public function foreign_s_sina($name){
|
||
// $name = strtolower($name);
|
||
|
||
$result =DB::table('currency')->where('name',$name)->first();
|
||
$code = $result->vcode;
|
||
$curl = curl_init();
|
||
curl_setopt_array($curl, array(
|
||
CURLOPT_URL => 'https://w.sinajs.cn/?_=0.27948490427865&list='.$code.',sys_time',
|
||
CURLOPT_RETURNTRANSFER => true,
|
||
CURLOPT_ENCODING => '',
|
||
CURLOPT_MAXREDIRS => 10,
|
||
CURLOPT_TIMEOUT => 0,
|
||
CURLOPT_FOLLOWLOCATION => true,
|
||
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
|
||
CURLOPT_CUSTOMREQUEST => 'POST',
|
||
CURLOPT_HTTPHEADER => array(
|
||
'referer: https://finance.sina.com.cn/'
|
||
),
|
||
));
|
||
$response = curl_exec($curl);
|
||
curl_close($curl);
|
||
preg_match_all("/[a-zA-Z]{1}/",$name,$arrAl);
|
||
$str2 = substr($response, 20+count($arrAl[0]));
|
||
$str2 = substr_replace($str2,"",-37,37);
|
||
//echo $str2;exit;
|
||
$str = explode(',',$str2);
|
||
$name = ucfirst($name);
|
||
$info = DB::table('currency')->where('name',$name)->first();
|
||
$info = json_encode($info);
|
||
$info = json_decode($info,true);
|
||
|
||
if(round(100-round($str[1]/$info['price']*100,4),4)>0){
|
||
$chanhe = '+'.round(100-round($str[1]/$info['price']*100,4),4);
|
||
}else{
|
||
$chanhe = round(100-round($str[1]/$info['price']*100,4),4);
|
||
}
|
||
$data['now_price'] = $str[1];//最新价格
|
||
$data['add_time'] = time();
|
||
$data['change'] = bcdiv($chanhe,100,2);
|
||
$data['high'] = $str[3];//最高 √
|
||
$data['low'] = $str[5];//最低 √
|
||
$data['open'] = $str[6];//开 √
|
||
$data['close'] = $str[1];//关
|
||
$data['volume'] = $info['price']*rand(100,1000);
|
||
DB::table('currency_quotation')->where('currency_id',$info['id'])->update($data);
|
||
//DB::table('currency')->where('id',$info['id'])->update(['price'=>$str[1]]);
|
||
}
|
||
|
||
} |