7-30之前

2020-01-07 | 阅读：次

流程图-mermaid-ipo

ipo网上可见

graph TB
    Start(稽核配置-稽核专项) --> |菜单栏|Open[数据一部-新股稽查-ipo数据抓取]
    Start-->|lsb-临时表| open2[信息类别=209-数据抓取]
    Open --> Put[每股发行价数错误1]
    Open --> Put1[全面摊薄发行市盈率错误2] --> IsFit
    Open --> Put2[证券简称错误3] --> IsFit
	Put --> IsFit["统计求和"] 
	
	open2 --> put1[今天的]-->int
	open2 --> put2[无-总的数据]-->int

ipo网上可见

7：30网址

http://data.eastmoney.com/xg/xg/default.html

新股申购与中签查询 _ 数据中心 _ 东方财富网

遇到不同

许志寅

你好临时表每天早上定时抓取的IPO数据今天的数据没有抓取抓的是东财的数据能复查一下吗早上要发邮件的

代码

1★每股发行价数错误-副本
关联表名：usrXGFXYSS

查询语句：

查询名称 ： ★DC有,JY无
查询名称 ：★证券简称错误
select  A.GPDM 公司代码,A.ZQJC 证券简称,B.MGFXJ '新股表-每股发行价',C.DECIMAL4 '临时表-数据字段4', 
[错误类型]='发行价数错误',B.SWFXRQSX 上网发行日期,C.VARCHAR5 '临时表-字符字段5',C.XGSJ 临时表修改时间 ,S.MS  发行进度
 ,B.XGSJ '新股表-修改时间',R.OPERATORNAME as  '新股表-修改人员'
 from    usrXGFXYSS B  			
JOIN  usrZQZB A 			
ON  B.IGSDM=A.IGSDM   and A.ZQLB=(SELECT TOP 1 ZQLB 			
FROM usrZQZB WHERE IGSDM=A.IGSDM ORDER BY ZQLB)  AND  A.ZQLB IN (1,2)  AND  A.SSBZ IN (1,2,6)			
left join  usrLSB  C    ON        C.XXLB=209
JOIN usrXTCLB S ON S.LB=1722 AND S.DM=B.FXJD
left JOIN cmdOPERATORS R ON R.OPERATORID=B.XGRY
 WHERE   B.SWFXRQSX>=CONVERT(varchar(10),dateadd(month,-3,getdate()), 120 )  AND A.GPDM=C.VARCHAR2  AND 
(B.MGFXJ<>C.DECIMAL4 OR 
(B.MGFXJ  IS NULL AND  C.DECIMAL4  IS   NOT NULL) OR 
(B.MGFXJ  IS NOT NULL AND  C.DECIMAL4  IS    NULL) )
ORDER   BY  B.SWFXRQSX  desc,A.GPDM
  

2★发行市盈率错误(全面摊薄发行市盈率)-副本
关联表名：usrXGFXYSS
查询语句：

select  A.GPDM 公司代码,A.ZQJC 证券简称,B.QMTBFXSYL '新股表-全面摊薄发行市盈率',C.DECIMAL5 '临时表-数据字段5', 
[错误类型]='发行市盈率错误',B.SWFXRQSX 上网发行日期,C.VARCHAR6 '临时表-字符字段6',C.XGSJ 临时表时间,S.MS  发行进度
 from    usrXGFXYSS B  			
JOIN  usrZQZB A 			
ON  B.IGSDM=A.IGSDM   and A.ZQLB=(SELECT TOP 1 ZQLB 			
FROM usrZQZB WHERE IGSDM=A.IGSDM ORDER BY ZQLB)  AND  A.ZQLB IN (1,2)  AND  A.SSBZ IN (1,2,6)			
left join  usrLSB  C    ON        C.XXLB=209
JOIN usrXTCLB S ON S.LB=1722 AND S.DM=B.FXJD
WHERE   A.GPDM=C.VARCHAR2   AND 
(B.QMTBFXSYL<>C.DECIMAL5 OR 
(B.QMTBFXSYL  IS  NULL  AND  C.DECIMAL5   IS  NOT   NULL) OR  
(B.QMTBFXSYL  IS NOT  NULL  AND  C.DECIMAL5   IS    NULL))   AND   B.SWFXRQSX>=CONVERT(varchar(10),dateadd(month,-3,getdate()), 120 ) 
ORDER   BY  B.SWFXRQSX  desc,A.GPDM

3★证券简称错误-副本
关联表名：usrLSB
查询语句：

select  A.GPDM 公司代码,A.ZQJC 证券简称,B.QMTBFXSYL '新股表-全面摊薄发行市盈率',C.DECIMAL5 '临时表-数据字段5', 
[错误类型]='发行市盈率错误',B.SWFXRQSX 上网发行日期,C.VARCHAR6 '临时表-字符字段6',C.XGSJ 临时表时间,S.MS  发行进度
 from    usrXGFXYSS B  			
JOIN  usrZQZB A 			
ON  B.IGSDM=A.IGSDM   and A.ZQLB=(SELECT TOP 1 ZQLB 			
FROM usrZQZB WHERE IGSDM=A.IGSDM ORDER BY ZQLB)  AND  A.ZQLB IN (1,2)  AND  A.SSBZ IN (1,2,6)			
left join  usrLSB  C    ON        C.XXLB=209
JOIN usrXTCLB S ON S.LB=1722 AND S.DM=B.FXJD
WHERE   A.GPDM=C.VARCHAR2   AND 
(B.QMTBFXSYL<>C.DECIMAL5 OR 
(B.QMTBFXSYL  IS  NULL  AND  C.DECIMAL5   IS  NOT   NULL) OR  
(B.QMTBFXSYL  IS NOT  NULL  AND  C.DECIMAL5   IS    NULL))   AND   B.SWFXRQSX>=CONVERT(varchar(10),dateadd(month,-3,getdate()), 120 ) 
ORDER   BY  B.SWFXRQSX  desc,A.GPDM