国通总结——如何获取客户的双录视频

进入CRM正式环境ETL采集服务器（192.168.103.60）数据库执行以下SQL语句:

 SELECT (SELECT CPQC FROM TFP_CPDM WHERE ID =C.CPID),C.GLSP,C.USR_ID,C.YYZT,C.CZYYTJ,C.DJYH,C.SHR,C.* FROM TCPYY C WHERE C.KHMC LIKE '陈长春%'
 SELECT * FROM TSPXXB WHERE CPYYID IN (26580);

就可以查看TSPXXB（视频双录的ID）然后从顶点（192.168.103.66）的/home/crm/data/app/tSPXXB的目录下获取相应视频。

select t.*,tk.* from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh
select t.id,t.spmc, ( select cpqc from tfp_cpdm where id= (select cpid  from tcpyy tp where id=t.cpyyid) ) ,t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh
select t.id,t.spmc,
 ( select cpqc from tfp_cpdm where id= (select cpid  from tcpyy tp where id=t.cpyyid) ),
 t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh and tk.khxm='赵新亮'


select t.id,t.spmc, t.cpyyid ,t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh

select *  from tkhxx

select *  from tfp_cpdm where id=32719