| | |
|---|
| | | param.custom_script = Utils.formatOptions(_customScript) |
|---|
| | | param.LText = Utils.formatOptions(LText) |
|---|
| | | param.DateCount = Utils.formatOptions(DateCount) |
|---|
| | | |
|---|
| | | // 多层结构数据 |
|---|
| | | // LText = `SELECT a.id as bid,a.ID,a.workerCode,a.workerName,a.jobName,a.Initials,case when isnull(m.friend_id ,'') ='' then '' |
|---|
| | | // when isnull(m.status,0)=10 then '已添加' else '待通过' end as friend_text |
|---|
| | | // ,case when images='' then 'http://epc.mk9h.cn/Content/images/upload/img/kane.jpg' else images end as icon FROM |
|---|
| | | // (select friend_id,status from oa_mail_list where userid='sso202004100959326131C0805998B6745F886F9' and Initials=case when right('0',1)='0' then Initials else '0' end |
|---|
| | | // and status=10 and deleted=0) m |
|---|
| | | // inner join (select * from BD_workers where |
|---|
| | | // Initials=case when right('0',1)='0' then Initials else '0' end and deleted=0 ) a |
|---|
| | | // on a.id=m.friend_id ` |
|---|
| | | // param.custom_script = '' |
|---|
| | | // param.LText = Utils.formatOptions(LText) |
|---|
| | | // param.DateCount = '' |
|---|
| | | // param.prm_field = 'workerCode' |
|---|
| | | // param.arr_field = 'workerName,jobName' |
|---|
| | | // param.tabid = 'ID' |
|---|
| | | // param.parid = 'BID' |
|---|
| | | // param.sub_name = 'sub_data' |
|---|
| | | // param.sub_field = 'BID,friend_text,icon,Initials' |
|---|
| | | |
|---|
| | | // exec_type: 'y' 解码字段：LText、LText1、LText2、custom_script、DateCount |
|---|
| | | |
|---|
