'NYSE', self::TAPE_NYSE_ARCA => 'NYSEARCA', self::TAPE_NASDAQ => 'NASDAQ', ]; public static function getMarketList($data): array { $where='status=1'; if(!empty($data['trade_name'])){ $where.=" and (trade_name like '".strtoupper($data['trade_name'])."%' or stock_code like '".strtoupper($data['trade_name'])."%')"; } if($data['page']<1){ $data['page']=1; } if($data['page_size']<1){ $data['page_size']=10; } $count=self::where($where)->count(); $list = self::where($where)->field('trade_name as name,stock_code as code')->page($data['page'],$data['page_size'])->select(); if(empty($list)){ return []; } return [ 'total'=>$count, 'list'=>$list->toArray(), ]; } public static function existMarket($trade_name):bool { $id=self::where('stock_code',$trade_name)->value('id'); return $id >0; } }