[2665] | 1 | from zope.component import queryUtility |
---|
[2687] | 2 | from zope.component import queryAdapter |
---|
[2654] | 3 | from zope.interface import implements, Interface |
---|
| 4 | |
---|
| 5 | from Products.Five import BrowserView |
---|
| 6 | from Products.CMFCore.utils import getToolByName |
---|
| 7 | |
---|
[2665] | 8 | from plone.memoize.view import memoize_contextless |
---|
| 9 | |
---|
| 10 | from quintagroup.gauth.interfaces import IGAuthUtility |
---|
| 11 | from gdata.spreadsheet.service import SpreadsheetsService |
---|
| 12 | from gdata.spreadsheet.service import DocumentQuery as shDocumentQuery |
---|
[2667] | 13 | from gdata.spreadsheet import SpreadsheetsListFeed |
---|
[2665] | 14 | |
---|
[2654] | 15 | from quintagroup.gdocs.spreadsheet import spreadsheetMessageFactory as _ |
---|
[2665] | 16 | from quintagroup.gdocs.spreadsheet import logException, logger |
---|
[2687] | 17 | from quintagroup.gdocs.spreadsheet.interfaces import IGSpreadsheet |
---|
| 18 | from quintagroup.gdocs.spreadsheet.interfaces import IGSpreadsheetDataProvider |
---|
[2654] | 19 | |
---|
| 20 | |
---|
[2665] | 21 | class IViewWorksheetView(Interface): |
---|
[2654] | 22 | """ |
---|
[2665] | 23 | ViewWorksheet view interface |
---|
[2654] | 24 | """ |
---|
| 25 | |
---|
[2665] | 26 | def renderWorksheet(ssh_id, wsh_idx, startrow_idx): |
---|
| 27 | """ |
---|
| 28 | ssh_id - Id of the spreadsheet |
---|
| 29 | wsh_id - Id of the worksheet |
---|
| 30 | startrow_idx - index of row, from which table should be rendered |
---|
| 31 | """ |
---|
[2654] | 32 | |
---|
| 33 | |
---|
[2665] | 34 | class ViewWorksheetView(BrowserView): |
---|
[2654] | 35 | """ |
---|
[2665] | 36 | ViewWorksheet browser view |
---|
[2654] | 37 | """ |
---|
[2665] | 38 | implements(IViewWorksheetView) |
---|
[2654] | 39 | |
---|
| 40 | def __init__(self, context, request): |
---|
| 41 | self.context = context |
---|
| 42 | self.request = request |
---|
[2665] | 43 | self.query = shDocumentQuery() |
---|
[2654] | 44 | |
---|
| 45 | @property |
---|
| 46 | def portal_catalog(self): |
---|
| 47 | return getToolByName(self.context, 'portal_catalog') |
---|
| 48 | |
---|
| 49 | @property |
---|
| 50 | def portal(self): |
---|
| 51 | return getToolByName(self.context, 'portal_url').getPortalObject() |
---|
| 52 | |
---|
[2665] | 53 | @memoize_contextless |
---|
[2667] | 54 | def renderWorksheet(self, ssh_id="", wsh_id='', startrow_idx=0): |
---|
[2654] | 55 | """ |
---|
| 56 | """ |
---|
[2668] | 57 | table = '' |
---|
[2687] | 58 | feed = IGSpreadsheetDataProvider(self.context).getListFeed() |
---|
[2667] | 59 | if isinstance(feed, SpreadsheetsListFeed): |
---|
[2668] | 60 | # akc is a list of keys of all columns. The context is GSpreadsheet content type |
---|
| 61 | akc = self.context.all_keys_columns |
---|
| 62 | # key_title_columns is list of tuples with two elements (column_key, column_title or column_key) |
---|
| 63 | key_title_columns = [(e['column_key'], e['column_title'] or e['column_key']) |
---|
| 64 | for e in self.context.order_columns if e['column_key'] in akc] |
---|
| 65 | if key_title_columns: |
---|
| 66 | # Prepare table |
---|
| 67 | table = "<table id=\"sshwsh\">" |
---|
| 68 | table += "<tr>" |
---|
| 69 | table += ''.join(["<th>%s</th>" % el[1] for el in key_title_columns]) |
---|
| 70 | table += "</tr>" |
---|
| 71 | for i, entry in enumerate(feed.entry): |
---|
| 72 | if i >= startrow_idx: |
---|
| 73 | td_row = "<tr>" |
---|
| 74 | for key in zip(*key_title_columns)[0]: |
---|
| 75 | td_row += "<td>%s</td>" \ |
---|
| 76 | % (not (entry.custom[key].text == 'None') and entry.custom[key].text or '') |
---|
| 77 | td_row += "</tr>\n" |
---|
| 78 | table += td_row |
---|
| 79 | table += "</table>" |
---|
[2667] | 80 | return table |
---|