Skip to content

Instantly share code, notes, and snippets.

@hkouns

hkouns/CountingList_PrintStatements

Created December 6, 2015 08:06
Show Gist options
  • Save hkouns/5b3c7d320837524c2d19 to your computer and use it in GitHub Desktop.
Save hkouns/5b3c7d320837524c2d19 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CountingList_PrintStatements
sqlpeople = q.QuerySqltoList('GivingUnits',"")
print '<html>'
print '<head>'
print '<style>'
print 'table, th, td {'
print ' border: 1px solid black;'
print '}'
print 'th, td {'
print ' padding: 2px;'
print '}'
print 'td {'
print ' border-style:dotted dotted dotted dotted;'
print '}'
print '</style>'
print '</head>'
print '<body>'
print '<table width="1005">'
print ' <tbody>'
print ' <tr>'
print ' <th width="50">'
print ' <p>&nbsp;</p>'
print ' </th>'
print ' <th width="190">'
print ' <p>&nbsp;&nbsp;</p>'
print ' </th>'
print ' <th width="150">'
print ' <p>&nbsp;&nbsp;</p>'
print ' </th>'
print ' <th width="50">'
print ' <p>&nbsp;&nbsp;</p>'
print ' </th>'
print ' <th width="110">'
print ' <p align="center"><strong>Tithe</strong></p>'
print ' </th>'
print ' <th width="110">'
print ' <p align="center"><strong>Bldg Fund</strong></p>'
print ' </th>'
print ' <th colspan="3" width="438">'
print ' <p align="center"><strong>Other Funds </strong><em>(enter Fund Name)</em></p>'
print ' </th>'
print ' </tr>'
print ' <tr>'
print ' <th width="50">'
print ' <p align="center"><strong>Id</strong></p>'
print ' </th>'
print ' <th width="190">'
print ' <p><strong>Name</strong></p>'
print ' </th>'
print ' <th width="150">'
print ' <p><strong>Spouse</strong></p>'
print ' </th>'
print ' <th width="50">'
print ' <p align="center"><small>Type</small></p>'
print ' </th>'
print ' <th width="110">'
print ' <p align="center"><strong>Amount</strong></p>'
print ' </th>'
print ' <th width="110">'
print ' <p align="center"><strong>Amount</strong></p>'
print ' </th>'
print ' <th width="146">'
print ' <p align="center"><strong>______________</strong></p>'
print ' </th>'
print ' <th width="146">'
print ' <p align="center"><strong>______________</strong></p>'
print ' </th>'
print ' <th width="146">'
print ' <p align="center"><strong>______________</strong></p>'
print ' </th>'
print ' </tr>'
for q in sqlpeople:
print ' <tr>'
print ' <td width="50">'
print ' <p align="center">'
print q["PeopleId"]
print '</p>'
print ' </td>'
print ' <td width="190">'
print ' <p>'
print q["Name2"]
print '</p>'
print ' </td>'
print ''
print ' <td width="150">'
print ' <p>'
print q["Spouse"]
print '<small>&nbsp;&nbsp;('
print q["SpouseId"]
print ')</small>'
print ' </p>'
print ' </td>'
print ' <td width="50" >'
print ' <p align="center"><small>'
print q["ContributionOptionsId"]
print ' </small></p>'
print ' </td>'
print ' <td width="110">'
print ' <p>&nbsp;</p>'
print ' </td>'
print ' <td width="110">'
print ' <p>&nbsp;</p>'
print ' </td>'
print ' <td width="146">'
print ' <p>&nbsp;</p>'
print ' </td>'
print ' <td width="146">'
print ' <p>&nbsp;</p>'
print ' </td>'
print ' <td width="146">'
print ' <p>&nbsp;</p>'
print ' </td>'
print ''
print ' </tr>'
print '</tbody>'
print '</table>'
print '</body>'
print '</html>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment