rendered paste body#Zpt
<table border="1" tal:define="fp_sql options/parametro | nothing">
<tr>
<form name="form" method="post" tal:attributes="action string:${context/consulta_pluviometria_py/absolute_url}">
<td style="white-space:nowrap;" class="td">Data Inicial: <input type="text" name="dataI" onkeypress="FormataData('dataI',event);" maxlength="10" size="10" style="font-size:7pt;"></td>
<td style="white-space:nowrap;" class="td">Data Final: <input type="text" name="dataF" onkeypress="FormataData('dataF',event);" maxlength="10" size="10" style="font-size:7pt;"></td>
<td style="white-space:nowrap;" class="td"><input type="submit" value="Processar" name=""></td>
</form>
</tr>
<metal:block tal:condition="fp_sql" tal:repeat="items fp_sql">
<tr>
<td class="td" tal:define="data items/data;" tal:content="python:context.ZopeTime(data).strftime('%d/%m/%Y')"/>
<td class="td" tal:content="items/empresa1"/>
<td class="td" tal:content="items/empresa2"/>
<td class="td" tal:content="items/empresa3"/>
<td class="td" tal:content="items/empresa4"/>
<td class="td" tal:content="items/empresa5"/>
<td class="td" tal:content="items/empresa6"/>
<td class="td" tal:content="items/empresa8"/>
<td class="td" tal:content="items/empresa9"/>
<td class="td" tal:content="items/empresa10"/>
<td class="td" tal:content="items/empresa11"/>
</tr>
</metal:block>
</table>
#PY
data_inicial = request.get('dataI')
data_final = request.get('dataF')
if data_inicial == "" and data_final == "":
final_data = context.ZopeTime().strftime('%Y/%m/%d')
hoje_data = DateTime(final_data) - 15
result = context.zsql_select_pluviometria(dataI=hoje_data,dataF=final_data)
else:
dataI = data_inicial.split("/")
dataF = data_final.split("/")
data_I = dataI[2]+"/"+dataI[1]+"/"+dataI[0]
data_F = dataF[2]+"/"+dataF[1]+"/"+dataF[0]
result = context.zsql_select_pluviometria(dataI=data_I,dataF=data_F)
return context.pluviometria(parametro=result)