1
2
3
4
5
6
7
8
| -- 软件抓图上传接口 需要上传的图片视图
| CREATE view v_gnkssctp
| as
| SELECT (case when a.his_xmdm='8522' then 'xdt' else '' end) gnlx,concat(c.cus_name,'_',a.id,'.jpg') picname
| FROM ltkj_jianchajianyan_tree a
| left join tj_order b on b.card_id = a.card_id join tj_customer c on c.cus_id = b.user_id
| left join sys_attachment d on d.old_file_name<>concat(c.cus_name,'_',a.id,'.jpg')
| where a.his_xmdm in ('8522','gmd');
|
|
