All pastes #197866 Raw Edit

Someone

public text v1 · immutable
·published 2006-10-11 16:01 UTC
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 == "":
    data_zope = context.ZopeTime().strftime('%Y/%m/%d') #data do server
    data_inicial = DateTime(data_zope) - 15             #data do server - 15
    result = context.zsql_select_pluviometria(dataI=data_inicial,dataF=data_zope)
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)