用友TurboCRM打印模板制作说明

《用友TurboCRM打印模板制作说明》由会员分享，可在线阅读，更多相关《用友TurboCRM打印模板制作说明（13页珍藏版）》请在装配图网上搜索。

1、用友TurboCRM打印模板制作说明V2.0变动记录日期变更内容操作人2009-6-25:增加引用对象属性的取值方法李鹏1、保存格式CRM6.0的打印模板文件保存格式为*.xlsx即Excel2007的默认保存格式2、编写格式打印模板可以输出 CRM系统对象查看页面的主表信息(包括表头和子表) 表头变量格式：#系统变量WMUl19.X产也机背I*）二UGtelfEPr打ttrr Pruduci-tem Quar-irtwXlTjeitEE no PnceJWLUE1trinAnnurt芦盘单世战本4t=；djb= itra Ur-5S=|tWjDiA企鬲衬料 IQuBtdlkuJifLuLlE

2、yQuoGe. EeUcr Lpli血I1子表变量格式：#=系统变量报愉单模扳Quotfzojyj 丄二抿单甘号；fl luvpte, Uwr&JlubcTliuote. StajriDatej摧:(平类型匚fltjQLiotE-TypEl;Qll: t e- rtepartniEntiQuote. faiff业务弘亡 CppnFtUTlltl科 ICUOT歆站（QizTp,cijrnlTLlQuot. E&kJ0u-te. Fi iiinRrdKj韦忻单日期:檢 tm VTlQu.de. 1 dinedTlid如上图所示，根据用户实际需要配置模板的布局显示，各字段所需变量可从数据库中查询，查

3、询语句见 4、查询语句。在模板中，除了填写系统变量获取数据库中信息以外，还可以使用Excel自己的函数实现一些实用的功能，比如字段值的运算，当前日期等。在子表里，需要使用 #=BEGIN和#=END来括住子表信息，如图示。#=BEGIN子表字段信息#=END3、引用对象的字段取值举例说明：系统中创建了自定义对象“车辆管理”对象名是“car”，在订单中创建了引用字段“车辆”字段名是“ chelia ng ”并引用“车辆管理”对象。这时如果想在订单的打印模板 中打印车辆管理对象中的创建人属性，变量写法是：Con tract.chelia ng. CreatedBy说明：1、使用查询语句先找出车辆管

4、理对象的属性名（本例中是“car”根据实际情况指定对象名）=2 and not label like %ID and dict_ nameselect * from dd_dict_str where orgd = 1 and Ian g_id like Car%本例中，找到的车辆创建人变量是Car. CreatedBy2、使用查询语句找出订单中“车辆”的属性名 select * from dd_dict_str where orgd = 1 and not label like %ID and langd = 2 and dict_ name like con tract.%本例中，找到的名

5、称是Co ntract.chelia ng3、把两次查询得到的名称拼在一起，如下Con tract.chelia ng. CreatedBy将此变量应用到订单的打印模板中就可以打印出引用的车辆属性。4、查询语句由于系统会存在若干自定义字段，因此打印模板所需字段要在数据库中查询。-客户字段selecta . attr_nameas客户字段,d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name= d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd=

6、 2and a.attr_namelikeaccou nt.%and not a . attr_namelike accou nt.%id-线索字段select a . attr_nameas线索字段,d. labelas 中文标签 from dd_attribute ainner join dd_dict_str don a . attr_name=d . dict_nameandd .orgd= 1andd .langd= 2anda .attr_ namelikelead.%andnot a . attr_namelikelead.%id-联系人字段selecta . attr_name

7、as联系人字段，d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikeco ntact.%and not a . attr_namelikeco ntact.%id-市场活动字段selecta . attr_nameas市场活动字段，d. labelasinnerjoin dd_dict_str don a . attr_name=dwherea .

8、orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikecampaig n.%and not a . attr_namelikecampaig n.%id中文标签 from dd_attribute a.dict_name-竞争对手字段as竞争对手字段，d. label asinnerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikeCompetitor.%and not a . attr_n amelikeC

9、ompetitor%.%idselect a . attr_name中文标签 from dd_attribute a.dict_name-竞争产品字段selecta . attr_nameas竞争产品字段，d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and a . attr namelikeand not a . attr nameCmptProd.%like CmptProd%.%id-竞争订单字段sel

10、ecta . attr_nameas竞争订单字段，d. labelas 中文标签from ddinnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikeCmptC ntrt.%and not a . attr_namelikeCmptC ntrt%.%idattribute a-竞争订单子表字段dd_attributeselect a. attr_nameas 竞争订单子表字段 ,d. label as 中文标签fromai

11、nnerjoin dd_dict_str don a . attr_name= d . dict_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikeCmptC ntrtitem.%and not a . attr_n amelikeCmptC ntrtitem%.%id-销售机会字段as 中文标签from ddattribute ainnerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namel

12、ikeopportu ni ty.%and not a . attr_n amelikeopportu nity%.%idselect a . attr_nameas销售机会字段，d. label=d . dict_name-销售机会子表字段dd_attributeselect a. attr_name as 销售机会子表字段 ,d. label as 中文标签 from ainner join dd_dict_str don a . attr_name= d . dict_nameand d . org_id and d . lang_idand a . attr_namelikeoppor

13、tu ni tyitem.%and not a . attr_namelike opportu ni tyitem%.%id-报价单主表字段selecta . attr_nameas报价单字段,d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikequote.%and not a . attr_namelikequote.%id-报价单子表字段sele

14、ct a . attr_name aas报价单子表字段，d. labelas 中文标签 from dd_attributeinnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikequoteitem.%and not a . attr_n amelikequoteitem.%id-订单主表字段selecta . attr_nameas 订单字段,d. labelas 中文标签 from dd_attribute ainnerjoi

15、n dd_dict_str don a . attr_name= d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikecon tract.%and not a . attr_namelikeco ntract.%id-订单子表字段select a . attr_nameas 订单字段，d. labelas 中文标签 from dd_attribute aon a . attr_name=d . dict_namewherea . orgd=1andd.orgd=1andd.langd=2anda.

16、attr_namelikeco ntractitem.%inner join dd_dict_str dand not a . attr_name like contractitem.%id-预收字段as 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikebeforetake.%and not a . attrn amelikebeforetake.%idselect a . attr_nameas 订

17、单字段，d. label=d . dict_name-收款字段innerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikepayme nt.%and not a . attr_n amelikepayme nt.%idselect a . attr_name as 收款字段,d. label as中文标签 from dd_attribute a=d . dict_name-收款子表字段selecta . attr_nameas，收款子表字段，d. labela

18、s 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikepayme ntitem.%and not a . attr_namelikepayme ntitem.%id-交付字段select a . attr_nameas 交付字段,d. labelas 中文标签 from dd_attribute aon a . attr_name=d . dict_namewherea

19、 . orgd= 1andd.orgd= 1andd.langd= 2anda.attr_namelikei nven tory.%andnot a . attr_namelikeinven tory.%idinner join dd_dict_str d-交付子表字段selecta . attr_nameas，交付子表字段，d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name=d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a

20、.attr_namelikei nven toryitem.%and not a . attr_namelikeinven toryitem.%id-发票字段selecta . attr_nameas 发票字段,d. labelas 中文标签 from dd_attribute ainnerjoin dd_dict_str don a . attr_name= d . dict_namewherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikein voice.%and not a . attr_namelikei nvoice

21、.%id-发票子表字段selecta . attr_nameas，发票子表字段，d. labelasinnerjoin dd_dict_str don a . attr_name=dwherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikein voiceitem.%and not a . attr_namelikei nvoiceitem.%id中文标签 from dd_attribute a.dict_name-服务计划innerjoin dd_dict_str don a . attr_namewherea . orgd=

22、1and d.orgd=1and d.langd=2and a.attr_namelikeservicepla n.%and not a . attr_n amelikeservicepla n.%idselect a . attr_nameas服务计划字段，d. labelas 中文标签 from dd_attribute a=d . dict_name-服务请求innerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikeservicerequest.%an

23、d not a . attr_n amelike servicerequest.%idselect a . attr_nameas服务请求字段，d. labelas 中文标签 from dd_attribute a=d . dict_name-服务工单selecta . attr_nameas，服务工单字段，d. labelasinnerjoin dd_dict_str don a . attr_name=dwherea . orgd= 1and d.orgd= 1and d.langd= 2and a.attr_namelikeworksheet.%and not a . attr_name

24、likeworksheet.%id中文标签 from dd_attribute a.dict_name-服务工单子表selectaa. attr_nameas服务工单子表字段，d. labeloinnerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikeworksheetitem.%and not a . attr_.n amelike worksheetitem.%idas 中文标签 from dd attribute=d . dict name-产品selecta . attr_nameas 产品字段,d. labelinnerjoin dd_dict_str don a . attr_namewherea . orgd=1and d.orgd=1and d.langd=2and a.attr_namelikeproduct.%and not a . attr_n amelikeproduct.%idas中文标签 from dd_attribute a=d . dict name