Q5/ws_objects/Ew_email.pbl.src/ddd_tv_sandmail_search.srd

$PBExportHeader$ddd_tv_sandmail_search.srd
release 9;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 )
header(height=92 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=104 color="536870912" )
table(column=(type=long updatewhereclause=yes name=groupid dbname="GroupID" )
 column=(type=long updatewhereclause=yes name=reltype dbname="reltype" )
 column=(type=long updatewhereclause=yes name=relid dbname="u_email_rep.relid" )
 column=(type=char(255) updatewhereclause=yes name=mailname dbname="u_email_rep.mailname" )
 column=(type=char(255) updatewhereclause=yes name=mailaddress dbname="u_email_rep.mailaddress" )
 column=(type=char(50) updatewhereclause=yes name=dscrp dbname="dscrp" )
 retrieve="SELECT     0 AS GroupID, 0 AS reltype, repID AS relid, mailname, mailaddress, '' AS dscrp
FROM         u_email_rep
WHERE     (empid = :arg_empid OR
                      empid = 0) AND (reptype = 1) AND (LOWER(mailname) LIKE LOWER(:arg_parm) OR
                      LOWER(mailaddress) LIKE LOWER(:arg_parm))

UNION


SELECT     1 AS GroupID, 1 AS reltype, cusid AS relid, cuscode AS mailname, email AS mailaddress, name AS dscrp
FROM         u_cust
WHERE     (inuse = 1) AND (cusareaid IN (:arg_cusareaid)) AND (RTRIM(LTRIM(email)) <> '') AND (LOWER(cuscode) LIKE LOWER(:arg_parm) OR
                      LOWER(email) LIKE LOWER(:arg_parm))

UNION


SELECT     1 AS GroupID, 4 AS reltype, u_cust_rep.repid AS relid, RTRIM(LTRIM(u_cust_1.cuscode)) + '-' + RTRIM(LTRIM(u_cust_rep.repname)) AS mailname, 
                      u_cust_rep.email AS mailaddress, '' AS dscrp
FROM         u_cust AS u_cust_1 INNER JOIN
                      u_cust_rep ON u_cust_1.cusid = u_cust_rep.cusid AND u_cust_1.cusid = u_cust_rep.cusid
WHERE     (u_cust_1.inuse = 1) AND (u_cust_1.cusareaid IN (:arg_cusareaid)) AND (RTRIM(LTRIM(u_cust_rep.email)) <> '') AND 
                      (LOWER(RTRIM(LTRIM(u_cust_1.cuscode)) + '-' + RTRIM(LTRIM(u_cust_rep.repname))) LIKE LOWER(:arg_parm) OR
                      LOWER(u_cust_rep.email) LIKE LOWER(:arg_parm))

UNION


SELECT     2 AS GroupID, 2 AS reltype, sptid AS relid, sptcode AS mailname, email AS mailaddress, name AS dscrp
FROM         u_spt
WHERE     (inuse = 1) AND (spttypeid IN (:arg_spttypeid_arr)) AND (RTRIM(LTRIM(email)) <> '') AND (LOWER(sptcode) LIKE LOWER(:arg_parm) OR
                      LOWER(email) LIKE LOWER(:arg_parm))
UNION


SELECT     2 AS GroupID, 5 AS reltype, u_spt_rep.repid AS relid, RTRIM(LTRIM(u_spt_1.sptcode)) + '-' + RTRIM(LTRIM(u_spt_rep.repname)) AS mailname, 
                      u_spt_rep.email AS mailaddress, '' AS dscrp
FROM         u_spt AS u_spt_1 INNER JOIN
                      u_spt_rep ON u_spt_1.sptid = u_spt_rep.sptid AND u_spt_1.sptid = u_spt_rep.sptid
WHERE     (u_spt_1.inuse = 1) AND (u_spt_1.spttypeid IN (:arg_spttypeid_arr)) AND (RTRIM(LTRIM(u_spt_rep.email)) <> '') AND 
                      (LOWER(RTRIM(LTRIM(u_spt_1.sptcode)) + '-' + RTRIM(LTRIM(u_spt_rep.repname))) LIKE LOWER(:arg_parm) OR
                      LOWER(u_spt_rep.email) LIKE LOWER(:arg_parm))

ORDER BY GroupID, mailname" arguments=(("arg_empid", number),("arg_cusareaid", numberlist),("arg_spttypeid_arr", numberlist),("arg_parm", string)) )
text(band=header alignment="2" text="Groupid" border="0" color="33554432" x="9" y="8" height="76" width="384" html.valueishtml="0"  name=groupid_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Reltype" border="0" color="33554432" x="402" y="8" height="76" width="384" html.valueishtml="0"  name=reltype_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Relid" border="0" color="33554432" x="795" y="8" height="76" width="384" html.valueishtml="0"  name=relid_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Mailname" border="0" color="33554432" x="1189" y="8" height="76" width="1632" html.valueishtml="0"  name=mailname_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Mailaddress" border="0" color="33554432" x="2830" y="8" height="76" width="3232" html.valueishtml="0"  name=mailaddress_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Dscrp" border="0" color="33554432" x="6071" y="4" height="76" width="1591" html.valueishtml="0"  name=dscrp_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
column(band=detail id=1 alignment="1" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=groupid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="402" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=reltype visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="1" tabsequence=32766 border="0" color="33554432" x="795" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=relid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="1189" y="8" height="88" width="1632" format="[general]" html.valueishtml="0"  name=mailname visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="2830" y="8" height="88" width="3232" format="[general]" html.valueishtml="0"  name=mailaddress visible="1" edit.limit=100 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="6071" y="0" height="76" width="1591" format="[general]" html.valueishtml="0"  name=dscrp visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )