<!-- >
parameters for the Database connection:
zehnder1 zehnder zehn10zehn
parameters for the ZSQl method (its ID is employee):
Firstname
Lastname
UserID
Company
The select statement:
select Firstname, Lastname, UserID, CompanyFK, PhoneDirect, Email01 from tblEmployee
where Firstname like ELT(FIND_IN_SET(<dtml-sqlvar Firstname type=string>,'')+1,<dtml-sqlvar Firstname type=string>,'%')
and Lastname like ELT(FIND_IN_SET(<dtml-sqlvar Lastname type=string>,'')+1,<dtml-sqlvar Lastname type=string>,'%')
and UserID like ELT(FIND_IN_SET(<dtml-sqlvar UserID type=string>,'')+1,<dtml-sqlvar UserID type=string>,'%')
and CompanyFK like ELT(FIND_IN_SET(<dtml-sqlvar Company type=string>,'')+1,<dtml-sqlvar Company type=string>,'%')
Order By Lastname, Firstname, UserID;
< -->
<html metal:use-macro="here/main_template/macros/master"
i18n:domain="plone">
tal:define="
<body>
<DIV metal:fill-slot="main"
tal:define="
firstname request/Firstname | nothing;lastname request/Lastname | nothing;
userid request/UserID | nothing; company request/Company | nothing;
Batch python:modules['Products.CMFPlone'].Batch;
b_size python:12;b_start python:0;b_start request/b_start | b_start;">
<form action="telephone_list_form" method="get">
<h2>Telephone List</h2>
<span i18n:translate="telephonedir_eneter_query">Enter query parameters:</span>
<table>
<tr>
<th width="80">User-ID</th>
<td><input name="UserID" width=30 tal:attributes="value userid"></td>
</tr>
<tr>
<th width="80">Firstname</th>
<td><input name="Firstname" width=30 tal:attributes="value firstname"></td>
</tr>
<tr>
<th width="80">Lastname</th>
<td><input name="Lastname" width=30 tal:attributes="value lastname"></td>
</tr>
<tr>
<th width="80">Company</th>
<td><input name="Company" width=30 tal:attributes="value company"></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type="SUBMIT" name="SUBMIT" value="Submit Query">
</td>
</tr>
</table>
</form>
<br>
<br>
<span i18n:translate="">For unknown letters or uncomplete parameters use %</span>
<div tal:condition="python:firstname or lastname or userid or company">
<table tal:define="results here/employees;">
<tr bgcolor="white" bordercolor="white">
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">User-ID</span></font></th>
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">Firstname</span></font></th>
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">Lastname</span></font></th>
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">Company</span></font></th>
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">Phone direct</span></font></th>
<th><font face="Arial"><span style="font-size:10pt; background-color:white;">Email</span></font></th>
</tr>
<metal:block tal:define="batch python:Batch(results, b_size, int(b_start), orphan=3);
nResults python:len(results);">
<!-- Navigation -->
<div metal:use-macro="here/batch_macros/macros/navigation" tal:condition="batch"/>
<div tal:repeat="result batch" >
<tr bordercolor="white" bgcolor="#DFDFDF" bordercolorlight="white" height="9" align="left" valign="center" bordercolordark="white" style="font-family:Arial; font-style:normal; font-weight:normal; font-size:10pt; text-align:left;">
<td height="20" nowrap tal:define="UserID result/UserID">
<a tal:content="UserID"
style="text-decoration: underline"
tal:attributes="href python:'telephone_detail_form?userid=%s' % UserID">
UserID goes here
</a>
</td>
<td height="20" nowrap>
<span tal:replace="result/Firstname" >Firstname goes here</span>
</td>
<td height="20" nowrap>
<span tal:replace="result/Lastname" >Lastname goes here</span>
</td>
<td height="20" nowrap>
<span tal:replace="result/CompanyFK" >CompanyFK goes here</span>
</td>
<td height="20" nowrap>
<span tal:replace="result/PhoneDirect" >PhoneDirect goes here</span>
</td>
<td height="20" nowrap tal:define="email result/Email01">
<a tal:content="email" tal:attributes="href python:'mailto:%s' % email">Email01 goes here</a>
</td>
</tr>
</div>
</metal:block>
</table>
</div>
<br>
</DIV>
</body>
</html>