ListBox.py 101 KB
Newer Older
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1 2 3
##############################################################################
#
# Copyright (c) 2002 Nexedi SARL and Contributors. All Rights Reserved.
Jean-Paul Smets's avatar
Jean-Paul Smets committed
4
#                    Jean-Paul Smets-Solanes <jp@nexedi.com>
Jean-Paul Smets's avatar
Jean-Paul Smets committed
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
#
# WARNING: This program as such is intended to be used by professional
# programmers who take the whole responsability of assessing all potential
# consequences resulting from its eventual inadequacies and bugs
# End users who are looking for a ready-to-use solution with commercial
# garantees and support are strongly adviced to contract a Free Software
# Service Company
#
# This program is Free Software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
#
##############################################################################

29
import string, types, sys
30
from AccessControl import ClassSecurityInfo
Jean-Paul Smets's avatar
Jean-Paul Smets committed
31 32 33 34
from Products.Formulator.DummyField import fields
from Products.Formulator import Widget, Validator
from Products.Formulator.Field import ZMIField
from Products.Formulator.Form import BasicForm
35
from Products.Formulator.Errors import FormValidationError, ValidationError
Jean-Paul Smets's avatar
Jean-Paul Smets committed
36
from Products.Formulator.MethodField import BoundMethod
37
from Selection import Selection, DomainSelection
Jean-Paul Smets's avatar
Jean-Paul Smets committed
38 39
from DateTime import DateTime
from Products.ERP5Type.Utils import getPath
40
from Products.ERP5Type.Document import newTempBase
41
from Products.CMFCore.utils import getToolByName
Sebastien Robin's avatar
Sebastien Robin committed
42
from copy import copy
Jean-Paul Smets's avatar
Jean-Paul Smets committed
43 44 45 46

from Acquisition import aq_base, aq_inner, aq_parent, aq_self
from zLOG import LOG

47
from Globals import InitializeClass, Persistent, Acquisition, get_request
48 49
from Products.PythonScripts.Utility import allow_class

50
import random
51 52
import md5

53 54 55 56 57 58
def getAsList(a):
  l = []
  for e in a:
    l.append(e)
  return l

59 60 61
def makeTreeBody(form, root_dict, domain_path, depth, total_depth, unfolded_list, form_id, selection_name):
  """
    This method builds a report tree
62

63
    domain_path  --    ('region', 'skill', 'group', 'group', 'region')
64

65
    root -- {'region': <instance>, 'group'; instance}
66 67

  """
68 69 70
  #LOG('makeTreeBody root_dict', 0, str(root_dict))
  #LOG('makeTreeBody domain_path', 0, str(domain_path))
  #LOG('makeTreeBody unfolded_list', 0, str(unfolded_list))
71

72 73
  if total_depth is None:
    total_depth = max(1, len(unfolded_list))
74

75
  if type(domain_path) is type('a'): domain_path = domain_path.split('/')
76

77
  portal_categories = getattr(form, 'portal_categories', None)
78
  portal_domains = getattr(form, 'portal_domains', None)
79
  portal_object = form.portal_url.getPortalObject()
80

81 82 83
  if len(domain_path):
    base_category = domain_path[0]
  else:
84 85
    base_category = None

86 87
  if root_dict is None:
    root_dict = {}
88 89

  is_empty_level = 1
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106
  while is_empty_level:
    if not root_dict.has_key(base_category):
      root = None
      if portal_categories is not None:
        if base_category in portal_categories.objectIds():
          root = root_dict[base_category] = root_dict[None] = portal_categories[base_category]
          domain_path = domain_path[1:]
      if root is None and portal_domains is not None:
        if base_category in portal_domains.objectIds():
          root = root_dict[base_category] = root_dict[None] = portal_domains[base_category]
          domain_path = domain_path[1:]
      if root is None:
        try:
          root = root_dict[None] = portal_object.unrestrictedTraverse(domain_path)
        except KeyError:
          root = None
        domain_path = ()
107 108
    else:
      root = root_dict[None] = root_dict[base_category]
109
      if len(domain_path) >= 1:
110
        domain_path = domain_path[1:]
111 112
      else:
        domain_path = ()
113
    is_empty_level = root is not None and (root.objectCount() == 0) and (len(domain_path) != 0)
114 115
    if is_empty_level: base_category = domain_path[0]

Jean-Paul Smets's avatar
Jean-Paul Smets committed
116
  tree_body = ''
117
  if root is None: return tree_body
Jean-Paul Smets's avatar
Jean-Paul Smets committed
118 119 120

  for o in root.objectValues():
    tree_body += '<TR>' + '<TD WIDTH="16" NOWRAP>' * depth
121
    if o.getRelativeUrl() in unfolded_list:
Jean-Paul Smets's avatar
Jean-Paul Smets committed
122
      tree_body += """<TD NOWRAP VALIGN="TOP" ALIGN="LEFT" COLSPAN="%s">
123 124 125 126 127
<a href="portal_selections/foldDomain?domain_url=%s&form_id=%s&list_selection_name=%s&domain_depth:int=%s" >- <b>%s</b></a>
</TD>""" % (total_depth - depth + 1, o.getRelativeUrl() , form_id, selection_name, depth, o.id)
      new_root_dict = root_dict.copy()
      new_root_dict[None] = new_root_dict[base_category] = o
      tree_body += makeTreeBody(form, new_root_dict, domain_path, depth + 1, total_depth, unfolded_list, form_id, selection_name)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
128 129
    else:
      tree_body += """<TD NOWRAP VALIGN="TOP" ALIGN="LEFT" COLSPAN="%s">
130 131
<a href="portal_selections/unfoldDomain?domain_url=%s&form_id=%s&list_selection_name=%s&domain_depth:int=%s" >+ %s</a>
</TD>""" % (total_depth - depth + 1, o.getRelativeUrl() , form_id, selection_name, depth, o.id)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
132 133 134

  return tree_body

135 136
_parent_domain_mark = '__parent'  
  
137
def makeTreeList(here, form, root_dict, report_path, base_category, depth, unfolded_list, form_id, selection_name, report_depth, is_report_opened=1, sort_on = (('id', 'ASC'),)):
Jean-Paul Smets's avatar
Jean-Paul Smets committed
138
  """
139
    (object, is_pure_summary, depth, is_open, select_domain_dict)
140

141
    select_domain_dict is a dictionary of  associative list of (id, domain)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
142
  """
143
  if type(report_path) is type('a'): report_path = report_path.split('/')
144

145
  portal_categories = getattr(form, 'portal_categories', None)
146
  portal_domains = getattr(form, 'portal_domains', None)
147
  portal_object = form.portal_url.getPortalObject()
148

149 150
  if len(report_path):
    base_category = report_path[0]
151

152 153
  if root_dict is None:
    root_dict = {}
154 155

  is_empty_level = 1
156 157 158 159 160
  while is_empty_level:
    if not root_dict.has_key(base_category):
      root = None
      if portal_categories is not None:
        if base_category in portal_categories.objectIds():
161 162 163 164 165 166 167
          if base_category == 'parent':
            # parent has a special treatment
            root = root_dict[base_category] = root_dict[None] = here
            report_path = report_path[1:]
          else:          
            root = root_dict[base_category] = root_dict[None] = portal_categories[base_category]
            report_path = report_path[1:]
168 169 170 171 172 173 174 175 176 177
      if root is None and portal_domains is not None:
        if base_category in portal_domains.objectIds():
          root = root_dict[base_category] = root_dict[None] = portal_domains[base_category]
          report_path = report_path[1:]
      if root is None:
        try:
          root = root_dict[None] = portal_object.unrestrictedTraverse(report_path)
        except KeyError:
          root = None
        report_path = ()
178
    else:
179 180
      root = root_dict[None] = root_dict[base_category]
      report_path = report_path[1:]
181
    is_empty_level = (root is None or root.objectCount() == 0) and (len(report_path) != 0)
182 183
    if is_empty_level: base_category = report_path[0]

Jean-Paul Smets's avatar
Jean-Paul Smets committed
184
  tree_list = []
185
  if root is None: return tree_list
Jean-Paul Smets's avatar
Jean-Paul Smets committed
186

187
  if base_category == 'parent':
188 189
    if hasattr(aq_base(root), 'objectValues'):
      # If this is a folder, try to browse the hierarchy
190
      for zo in root.searchFolder(sort_on=sort_on):
191 192 193 194 195 196 197
        o = zo.getObject()
        if o is not None:
          new_root_dict = root_dict.copy()
          new_root_dict[None] = new_root_dict[base_category] = o
          selection_domain = DomainSelection(domain_dict = new_root_dict)
          if (report_depth is not None and depth <= (report_depth - 1)) or o.getRelativeUrl() in unfolded_list:
            exception_uid_list = [] # Object we do not want to display
198
            for sub_zo in o.searchFolder(sort_on=sort_on):
199 200 201 202 203 204
              sub_o = sub_zo.getObject()
              if sub_o is not None and hasattr(aq_base(root), 'objectValues'):
                exception_uid_list.append(sub_o.getUid())          
            tree_list += [(o, 1, depth, 1, selection_domain, exception_uid_list)] # Summary (open)
            if is_report_opened :
              tree_list += [(o, 0, depth, 0, selection_domain, exception_uid_list)] # List (contents, closed, must be strict selection)
205
            tree_list += makeTreeList(here, form, new_root_dict, report_path, base_category, depth + 1, unfolded_list, form_id, selection_name, report_depth, is_report_opened=is_report_opened, sort_on=sort_on)
206 207
          else:
            tree_list += [(o, 1, depth, 0, selection_domain, ())] # Summary (closed)
208 209 210 211 212 213
  else:
    for o in root.objectValues():
      new_root_dict = root_dict.copy()
      new_root_dict[None] = new_root_dict[base_category] = o
      selection_domain = DomainSelection(domain_dict = new_root_dict)
      if (report_depth is not None and depth <= (report_depth - 1)) or o.getRelativeUrl() in unfolded_list:
214
        tree_list += [(o, 1, depth, 1, selection_domain, None)] # Summary (open)
215
        if is_report_opened :
216
          tree_list += [(o, 0, depth, 0, selection_domain, None)] # List (contents, closed, must be strict selection)
217 218 219
        tree_list += makeTreeList(here, form, new_root_dict, report_path, base_category, depth + 1, 
            unfolded_list, form_id, selection_name, report_depth, 
            is_report_opened=is_report_opened, sort_on=sort_on)
220
      else:
221
        tree_list += [(o, 1, depth, 0, selection_domain, None)] # Summary (closed)
222

Jean-Paul Smets's avatar
Jean-Paul Smets committed
223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254
  return tree_list


class ListBoxWidget(Widget.Widget):
    """
        ListBox widget

        The ListBox widget allows to display a collection of objects in a form.
        The ListBox widget can be used for many applications:

        1- show the content of a folder by providing a list of meta_types
           and eventually a sort order

        2- show the content of a relation by providing the name of the relation,
           a list of meta_types and eventually a sort order

        3- show the result of a search request by selecting a query and
           providing parameters for that query (and eventually a sort order)

        In all 3 cases, a parameter to hold the current start item must be
        stored somewhere, typically in a selection object.

        Parameters in case 3 should stored in a selection object which allows a per user
        per PC storage.

        ListBox uses the following control variables

        - sort_by -- the id to sort results

        - sort_order -- the order of sorting
    """
    property_names = Widget.Widget.property_names +\
255
                     ['lines', 'columns', 'all_columns', 'search_columns', 'sort_columns', 'sort',
Yoshinori Okuji's avatar
Yoshinori Okuji committed
256
                      'editable_columns', 'all_editable_columns', 'stat_columns', 'url_columns', 'global_attributes',
257
                      'list_method', 'count_method', 'stat_method', 'selection_name',
Jean-Paul Smets's avatar
Jean-Paul Smets committed
258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299
                      'meta_types', 'portal_types', 'default_params',
                      'search', 'select',
                      'domain_tree', 'domain_root_list',
                      'report_tree', 'report_root_list',
                      'list_action' ]

    default = fields.TextAreaField('default',
                                   title='Default',
                                   description=(
        "Default value of the text in the widget."),
                                   default="",
                                   width=20, height=3,
                                   required=0)

    lines = fields.IntegerField('lines',
                                title='Lines',
                                description=(
        "The number of lines of this list. Required."),
                                default=10,
                                required=1)

    columns = fields.ListTextAreaField('columns',
                                 title="Columns",
                                 description=(
        "A list of attributes names to display. Required."),
                                 default=[],
                                 required=1)

    all_columns = fields.ListTextAreaField('all_columns',
                                 title="More Columns",
                                 description=(
        "An optional list of attributes names to display."),
                                 default=[],
                                 required=0)

    search_columns = fields.ListTextAreaField('search_columns',
                                 title="Searchable Columns",
                                 description=(
        "An optional list of columns to search."),
                                 default=[],
                                 required=0)

300 301 302 303 304 305 306
    sort_columns = fields.ListTextAreaField('sort_columns',
                                 title="Sortable Columns",
                                 description=(
        "An optional list of columns to sort."),
                                 default=[],
                                 required=0)

Jean-Paul Smets's avatar
Jean-Paul Smets committed
307 308 309 310 311 312 313 314 315 316 317 318 319
    sort = fields.ListTextAreaField('sort',
                                 title='Default Sort',
                                 description=('The default sort keys and order'),
                                 default=[],
                                 required=0)

    list_method = fields.MethodField('list_method',
                                 title='List Method',
                                 description=('The method to use to list'
                                              'objects'),
                                 default='',
                                 required=0)

320 321 322 323 324 325 326
    count_method = fields.MethodField('count_method',
                                 title='Count Method',
                                 description=('The method to use to count'
                                              'objects'),
                                 default='',
                                 required=0)

Jean-Paul Smets's avatar
Jean-Paul Smets committed
327 328
    stat_method = fields.MethodField('stat_method',
                                 title='Stat Method',
329
                                 description=('The method to use to stat'
Jean-Paul Smets's avatar
Jean-Paul Smets committed
330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387
                                              'objects'),
                                 default='',
                                 required=0)

    selection_name = fields.StringField('selection_name',
                                 title='Selection Name',
                                 description=('The name of the selection to store'
                                              'params of selection'),
                                 default='',
                                 required=0)

    meta_types = fields.ListTextAreaField('meta_types',
                                 title="Meta Types",
                                 description=(
        "Meta Types of objects to list. Required."),
                                 default=[],
                                 required=0)

    portal_types = fields.ListTextAreaField('portal_types',
                                 title="Portal Types",
                                 description=(
        "Portal Types of objects to list. Required."),
                                 default=[],
                                 required=0)

    default_params = fields.ListTextAreaField('default_params',
                                 title="Default Parameters",
                                 description=(
        "Default Parameters for the List Method."),
                                 default=[],
                                 required=0)

    search = fields.CheckBoxField('search',
                                 title='Search Row',
                                 description=('Search Row'),
                                 default='',
                                 required=0)

    select = fields.CheckBoxField('select',
                                 title='Select Column',
                                 description=('Select Column'),
                                 default='',
                                 required=0)

    editable_columns = fields.ListTextAreaField('editable_columns',
                                 title="Editable Columns",
                                 description=(
        "An optional list of columns which can be modified."),
                                 default=[],
                                 required=0)

    all_editable_columns = fields.ListTextAreaField('all_editable_columns',
                                 title="All Editable Columns",
                                 description=(
        "An optional list of columns which can be modified."),
                                 default=[],
                                 required=0)

388 389 390 391 392 393 394 395 396 397 398 399 400 401
    stat_columns = fields.ListTextAreaField('stat_columns',
                                 title="Stat Columns",
                                 description=(
        "An optional list of columns which can be used for statistics."),
                                 default=[],
                                 required=0)

    url_columns = fields.ListTextAreaField('url_columns',
                                 title="URL Columns",
                                 description=(
        "An optional list of columns which can provide a custom URL."),
                                 default=[],
                                 required=0)

Jean-Paul Smets's avatar
Jean-Paul Smets committed
402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443
    global_attributes = fields.ListTextAreaField('global_attributes',
                                 title="Global Attributes",
                                 description=(
        "An optional list of attributes which are set by hidden fields and which are applied to each editable column."),
                                 default=[],
                                 required=0)

    domain_tree = fields.CheckBoxField('domain_tree',
                                 title='Domain Tree',
                                 description=('Selection Tree'),
                                 default='',
                                 required=0)

    domain_root_list = fields.ListTextAreaField('domain_root_list',
                                 title="Domain Root",
                                 description=(
        "A list of domains which define the possible root."),
                                 default=[],
                                 required=0)

    report_tree = fields.CheckBoxField('report_tree',
                                 title='Report Tree',
                                 description=('Report Tree'),
                                 default='',
                                 required=0)



    report_root_list = fields.ListTextAreaField('report_root_list',
                                 title="Report Root",
                                 description=(
        "A list of domains which define the possible root."),
                                 default=[],
                                 required=0)

    list_action = fields.StringField('list_action',
                                 title='List Action',
                                 description=('The id of the object action'
                                              'to display the current list'),
                                 default='',
                                 required=1)

444 445 446 447 448 449 450
    def render_view(self, field, value, REQUEST=None, render_format='html', key='listbox'):
        """
          Returns
        """
        if REQUEST is None: REQUEST=get_request()
        return self.render(field, key, value, REQUEST, render_format=render_format)                                
    
451
    def render(self, field, key, value, REQUEST, render_format='html'):
Jean-Paul Smets's avatar
Jean-Paul Smets committed
452 453 454
        """
          This is where most things happen. This method renders a list
          of items
Jean-Paul Smets's avatar
Jean-Paul Smets committed
455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472
          
          render_format allows to produce either HTML (default)
          or produce a generic 'list' format which can be converted by page templates
          or dtml into various formats (ex. PDF, CSV, OpenOffice, etc.)
          
          the 'list' format includes additional metainformation
          
          - depth in a report tree (ex. 0, 1, 2, etc.)
          
          - nature of the line (ex. stat or nonstat)
          
          - identification of the tree (ex. relative_url)
          
          - uid if any (to allow future import)
          
          - etc.
          
          which is intended to simplify operation with a spreadsheet or a pagetemplate
Jean-Paul Smets's avatar
Jean-Paul Smets committed
473
        """
474 475 476 477 478
        ###############################################################
        #
        # First, grasp and intialize the variables we may need later
        #
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
479

Jean-Paul Smets's avatar
Jean-Paul Smets committed
480 481 482
        here = REQUEST['here']
        reset = REQUEST.get('reset', 0)
        form = field.aq_parent
483
        field_errors = REQUEST.get('field_errors',{});
Jean-Paul Smets's avatar
Jean-Paul Smets committed
484 485 486 487 488 489 490 491 492 493 494 495
        field_title = field.get_value('title')
        lines = field.get_value('lines')
        meta_types = field.get_value('meta_types')
        portal_types= field.get_value('portal_types')
        columns = field.get_value('columns')
        all_columns = field.get_value('all_columns')
        default_params = field.get_value('default_params')
        search = field.get_value('search')
        select = field.get_value('select')
        sort = field.get_value('sort')
        editable_columns = field.get_value('editable_columns')
        all_editable_columns = field.get_value('all_editable_columns')
496
        stat_columns = field.get_value('stat_columns')
Yoshinori Okuji's avatar
Yoshinori Okuji committed
497
        url_columns = field.get_value('url_columns')
Jean-Paul Smets's avatar
Jean-Paul Smets committed
498
        search_columns = field.get_value('search_columns')
499
        sort_columns = field.get_value('sort_columns')
Jean-Paul Smets's avatar
Jean-Paul Smets committed
500 501 502 503 504
        domain_tree = field.get_value('domain_tree')
        report_tree = field.get_value('report_tree')
        domain_root_list = field.get_value('domain_root_list')
        report_root_list = field.get_value('report_root_list')
        list_method = field.get_value('list_method')
505
        count_method = field.get_value('count_method')
Jean-Paul Smets's avatar
Jean-Paul Smets committed
506
        stat_method = field.get_value('stat_method')
Sebastien Robin's avatar
Sebastien Robin committed
507
        selection_index = REQUEST.get('selection_index')
Jean-Paul Smets's avatar
Jean-Paul Smets committed
508
        selection_name = field.get_value('selection_name')
Sebastien Robin's avatar
Sebastien Robin committed
509
        portal_url_string = getToolByName(here, 'portal_url')()
510
        portal_categories = getattr(form, 'portal_categories', None)
511 512
        portal_domains = getattr(form, 'portal_domains', None)
        portal_object = form.portal_url.getPortalObject()
Sebastien Robin's avatar
Sebastien Robin committed
513 514 515
        #selection_name = REQUEST.get('selection_name',None)
        #if selection_name is None:
        #  selection_name = str(random.randrange(1,2147483600))
516
        current_selection_name = REQUEST.get('selection_name','default')
517 518
        current_selection_index = REQUEST.get('selection_index', 0)
        report_depth = REQUEST.get('report_depth', None)
519 520 521 522 523
        list_action = here.absolute_url() + '/' + field.get_value('list_action')
        if list_action.find('?') < 0:
          list_action += '?reset=1'
        else:
          list_action += '&reset=1'
Sebastien Robin's avatar
Sebastien Robin committed
524
        object_list = []
Yoshinori Okuji's avatar
Yoshinori Okuji committed
525
        translate = portal_object.translation_service.translate
Jean-Paul Smets's avatar
Jean-Paul Smets committed
526

527 528 529
        # Make sure list_result_item is defined
        list_result_item = [] 

530 531 532 533
        if render_format == 'list': 
          # initialize the result
          listboxline_list = []

534 535 536
        # Make sure that the title is not UTF-8.
        field_title = unicode(field_title, 'utf-8')

537 538 539
        # Make sure that columns are not UTF-8.
        columns = [(str(cname[0]), unicode(cname[1], 'utf-8')) for cname in columns]

540 541 542
        # Make sure that columns are not UTF-8.
        domain_root_list = [(str(cname[0]), unicode(cname[1], 'utf-8')) for cname in domain_root_list]

543
        #LOG('Listbox',0,'search_columns1: %s' % str(search_columns))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
544 545 546
        if search_columns == [] or search_columns is None or search_columns == '':
          # We will set it as the schema
          search_columns = map(lambda x: [x,x],here.portal_catalog.schema())
547
          #LOG('Listbox',0,'search_columns2: %s' % str(search_columns))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
548 549
        search_columns_id_list = map(lambda x: x[0], search_columns)

550 551 552
        if sort_columns == [] or sort_columns is None or sort_columns == '':
          sort_columns = search_columns
        sort_columns_id_list = map(lambda x: x[0], sort_columns)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
553

554
        # Display statistics if the button Parameter exists or stat columns are defined explicitly.
Jean-Paul Smets's avatar
Jean-Paul Smets committed
555 556
        filtered_actions = here.portal_actions.listFilteredActionsFor(here);
        object_ui = filtered_actions.has_key('object_ui')
557 558 559 560 561 562 563 564
        show_stat = (object_ui or stat_columns)

        # If nothing is specified to stat_columns, assume that all columns are available.
        # For compatibility, because there was no stat_columns before.
        if not stat_columns:
          stat_columns = []
          for column in all_columns:
            stat_columns.append((column[0], column[0]))
565 566
          for column in columns: # Sometimes, all_columns is not defined
            stat_columns.append((column[0], column[0]))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
567

Yoshinori Okuji's avatar
Yoshinori Okuji committed
568 569 570
        if not url_columns:
          url_columns = []

Jean-Paul Smets's avatar
Jean-Paul Smets committed
571 572 573 574 575 576
        has_catalog_path = None
        for (k, v) in all_columns:
          if k == 'catalog.path' or k == 'path':
            has_catalog_path = k
            break

577 578
        selection = here.portal_selections.getSelectionFor(selection_name, REQUEST=REQUEST)
        # Create selection if needed, with default sort order
Jean-Paul Smets's avatar
Jean-Paul Smets committed
579
        if selection is None:
580
          selection = Selection(params=default_params, default_sort_on = sort)
581 582
        # Or make sure all sort arguments are valid
        else:
583 584 585
          # Reset Selection is needed
          if reset is not 0 and reset is not '0':
            here.portal_selections.setSelectionToAll(selection_name)
586 587 588 589
            here.portal_selections.setSelectionSortOrder(selection_name, sort_on = [])

          # Modify the default sort index every time, because it may change immediately.
          selection.edit(default_sort_on = sort)
590

591
          # Filter non searchable items
592
          sort_list = []
593
          fix_sort = 0
594
          for (k , v) in selection.sort_on: # XXX Access to selection - bad 
595
            if k in sort_columns_id_list:
596
              sort_list.append((k,v))
597 598
            else:
              fix_sort = 1
599
          if fix_sort: selection.sort_on = sort_list # XXX Access to selection - bad
Jean-Paul Smets's avatar
Jean-Paul Smets committed
600

601
        if not hasattr(selection, 'flat_list_mode'):
602 603 604 605
          # initialisation of render mode. Choose flat_list_mode by default
          selection.edit(flat_list_mode=1,domain_tree_mode=0,report_tree_mode=0)
          #selection.edit(flat_list_mode=(not (domain_tree or
          # report_tree)),domain_tree_mode=domain_tree,report_tree_mode= report_tree)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
606

607
        #LOG('ListBox', 0, 'sort = %s, selection.selection_sort_on = %s' % (repr(sort), repr(selection.selection_sort_on)))
608
        # Selection
Yoshinori Okuji's avatar
Yoshinori Okuji committed
609
        #LOG("Selection",0,str(selection.__dict__))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
610 611 612

        # Display choosen by the user

613
        if selection.flat_list_mode is not None:
614
          if selection.flat_list_mode == 1:
Jean-Paul Smets's avatar
Jean-Paul Smets committed
615 616
            domain_tree = 0
            report_tree = 0
617
          elif selection.domain_tree_mode == 1:
618 619 620 621 622 623 624
            # Only display domain if domain is defined
            if len(domain_root_list):
              domain_tree = 1
              report_tree = 0
            else:              
              domain_tree = 0
              report_tree = 0
625
          elif selection.report_tree_mode == 1:
626 627 628 629 630 631 632
            # Only display report if report is defined
            if len(report_root_list):
              domain_tree = 0
              report_tree = 1
            else:              
              domain_tree = 0
              report_tree = 0
Jean-Paul Smets's avatar
Jean-Paul Smets committed
633

634 635 636 637
        # In report tree mode, we want to remember if the items have to be displayed
        is_report_opened = REQUEST.get('is_report_opened', selection.isReportOpened())
        selection.edit(report_opened=is_report_opened)

638
        checked_uids = selection.getCheckedUids()
Jean-Paul Smets's avatar
Jean-Paul Smets committed
639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658
        columns = here.portal_selections.getSelectionColumns(selection_name,
                                                columns=columns, REQUEST=REQUEST)


        editable_column_ids = map(lambda x: x[0], editable_columns)
        all_editable_column_ids = map(lambda x: x[0], all_editable_columns)

        url = REQUEST.URL

        # Build the list of meta_types
        filtered_meta_types = map(lambda x: x[0], meta_types)
        if len(filtered_meta_types) == 0:
          filtered_meta_types = None

        # Build the list of meta_types
        filtered_portal_types = map(lambda x: x[0], portal_types)
        if len(filtered_portal_types) == 0:
            filtered_portal_types = None

        # Combine default values, selection values and REQUEST
659
        params = selection.getParams()
660 661 662 663 664 665 666 667 668
        if list_method not in (None, ''):
          # Only update params if list_method is defined
          # (ie. do not update params in listboxed intended to show a previously defined selection
          params.update(REQUEST.form)
          for (k,v) in default_params:
            if REQUEST.form.has_key(k):
              params[k] = REQUEST.form[k]
            elif not params.has_key(k):
              params[k] = eval(v)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
669

670
        # Allow overriding list_method, count_method and stat_method by params
671 672 673 674 675
        if params.has_key('list_method_id'):
          #try:
          list_method = getattr(here.portal_skins.local_list_method , params['list_method_id']) # Coramy specific
          #except:
          #  list_method = list_method
676 677 678 679 680
        if params.has_key('count_method_id'):
          #try:
          count_method = getattr(here.portal_skins.local_list_method , params['count_method_id']) # Coramy specific
          #except:
          #  list_method = list_method
681 682 683 684 685 686
        if params.has_key('stat_method_id'):
          #try:
          list_method = getattr(here.portal_skins.local_list_method , params['stat_method_id']) # Coramy specific
          #except:
          #  list_method = list_method

Jean-Paul Smets's avatar
Jean-Paul Smets committed
687
        # Set the params spec (this should change in the future)
688 689 690 691 692
        if list_method not in (None, ''):
          # Only update params if list_method is defined
          # (ie. do not update params in listboxed intended to show a previously defined selection
          params['meta_type'] = filtered_meta_types
          params['portal_type'] = filtered_portal_types
Jean-Paul Smets's avatar
Jean-Paul Smets committed
693

694
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
695
        #
Jean-Paul Smets's avatar
Jean-Paul Smets committed
696
        # Build the columns selections
697
        #
Jean-Paul Smets's avatar
Jean-Paul Smets committed
698 699 700
        # The idea is: instead of selecting *, listbox is able to
        # provide what should be selected. This should allow to reduce
        # the quantity of data transfered between MySQL and Zope
701 702
        #
        ###############################################################
Jean-Paul Smets's avatar
Jean-Paul Smets committed
703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723
        extended_columns = []
        sql_columns = []
        for (sql, title) in columns:
          # original SQL id, Title, alias
          alias = string.split(sql,'.')
          alias = string.join(alias, '_')
          extended_columns += [(sql, title, alias)]
          if alias != sql:
            sql_columns += ['%s AS %s' % (sql, alias)]
          else:
            sql_columns += [alias]
        if has_catalog_path:
          alias = string.split(has_catalog_path,'.')
          alias = string.join(alias, '_')
          if alias != has_catalog_path:
            sql_columns += ['%s AS %s' % (has_catalog_path, alias)]
          else:
            sql_columns += [alias]
        sql_columns_string = string.join(sql_columns,' , ')
        params['select_columns'] = sql_columns_string

724
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
725
        #
Jean-Paul Smets's avatar
Jean-Paul Smets committed
726
        # Execute the query
Yoshinori Okuji's avatar
Yoshinori Okuji committed
727
        #
728
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
729

Jean-Paul Smets's avatar
Jean-Paul Smets committed
730
        kw = params
731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746

        # XXX Remove selection_expression if present.
        # This is necessary for now, because the actual selection expression in
        # search catalog does not take the requested columns into account. If
        # select_expression is passed, this can raise an exception, because stat
        # method sets select_expression, and this might cause duplicated column
        # names.
        #
        # In the future, this must be addressed in a clean way. selection_expression
        # should be used for search catalog, and search catalog should not use
        # catalog.* but only selection_expression. But this is a bit difficult,
        # because there is no simple way to distinguish queried columns from callable
        # objects in the current ListBox configuration.
        if 'select_expression' in kw:
          del kw['select_expression']

Jean-Paul Smets's avatar
Jean-Paul Smets committed
747 748 749 750 751
        if hasattr(list_method, 'method_name'):
          if list_method.method_name == 'objectValues':
            list_method = here.objectValues
            kw = copy(params)
            kw['spec'] = filtered_meta_types
752
          else:
Jean-Paul Smets's avatar
Jean-Paul Smets committed
753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777
            # The Catalog Builds a Complex Query
            # So we should not pass too many variables
            kw = {}
            if REQUEST.form.has_key('portal_type'):
              kw['portal_type'] = REQUEST.form['portal_type']
            elif REQUEST.has_key('portal_type'):
              kw['portal_type'] = REQUEST['portal_type']
            elif filtered_portal_types is not None:
              kw['portal_type'] = filtered_portal_types
            elif filtered_meta_types is not None:
              kw['meta_type'] = filtered_meta_types
            elif kw.has_key('portal_type'):
              if kw['portal_type'] == '':
                del kw['portal_type']

            # Remove useless matter
            for cname in params.keys():
              if params[cname] != '' and params[cname]!=None:
                kw[cname] = params[cname]

            # Try to get the method through acquisition
            try:
              list_method = getattr(here, list_method.method_name)
            except:
              pass
778 779 780 781
        elif list_method in (None, ''): # Use current selection
          # Use previously used list method
          list_method = None

Jean-Paul Smets's avatar
Jean-Paul Smets committed
782

783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798
        # Lookup the count_method
        if hasattr(count_method, 'method_name'):
          if count_method.method_name == 'portal_catalog':
            # We use the catalog count results
            count_method = here.portal_catalog.countResults
          else:
            # Try to get the method through acquisition
            try:
              count_method = getattr(here, count_method.method_name)
            except:
              count_method = None
        else:
          # No count method defined means that all objects must be retrieved.
          count_method = None
          
          
Jean-Paul Smets's avatar
Jean-Paul Smets committed
799 800 801 802 803 804 805 806
        # Lookup the stat_method
        if hasattr(stat_method, 'method_name'):
          if stat_method.method_name == 'objectValues':
            stat_method = None # Nothing to do in this case
            show_stat = 0
          elif stat_method.method_name == 'portal_catalog':
            # We use the catalog count results
            stat_method = here.portal_catalog.countResults
807
            show_stat = 1
Jean-Paul Smets's avatar
Jean-Paul Smets committed
808 809 810 811 812 813 814 815 816
          else:
            # Try to get the method through acquisition
            try:
              stat_method = getattr(here, stat_method.method_name)
              show_stat = 1
            except:
              show_stat = 0
              pass
        else:
817 818 819
          # No stat method defined means no statistics displayed
          stat_method = None
          show_stat = 0
Jean-Paul Smets's avatar
Jean-Paul Smets committed
820

821
        #LOG('ListBox', 0, 'domain_tree = %s, selection.getDomainPath() = %s, selection.getDomainList() = %s' % (repr(domain_tree), repr(selection.getDomainPath()), repr(selection.getDomainList())))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
822
        if domain_tree:
823 824
          selection_domain_path = selection.getDomainPath()
          selection_domain_current = selection.getDomainList()
Jean-Paul Smets's avatar
Jean-Paul Smets committed
825
          if len(selection_domain_current) > 0:
826
            root_dict = {}
827 828
            for domain in selection_domain_current:
              if type(domain) != type(''): continue # XXX workaround for a past bug in Selection
829 830 831 832 833 834 835 836 837 838 839 840 841
              root = None
              base_category = domain.split('/')[0]
              if portal_categories is not None:
                if base_category in portal_categories.objectIds():
                  root = root_dict[base_category] = portal_categories.restrictedTraverse(domain)
              if root is None and portal_domains is not None:
                if base_category in portal_domains.objectIds():
                  root = root_dict[base_category] = portal_domains.restrictedTraverse(domain)
              if root is None:
                try:
                  root_dict[None] = portal_object.restrictedTraverse(domain)
                except KeyError:
                  root = None
842 843 844
              #LOG('domain_tree root aq_parent', 0, str(root_dict[base_category].aq_parent))
            selection.edit(domain = DomainSelection(domain_dict = root_dict))
            #LOG('selection.domain', 0, str(selection.domain.__dict__))
845 846
        else:
          selection.edit(domain = None)
847

848 849
        #LOG('ListBox', 0, 'list_method = %s, list_method.__dict__ = %s' % (repr(list_method), repr((list_method.__dict__))))

850
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
851
        #
852
        # Prepare the stat select_expression
Yoshinori Okuji's avatar
Yoshinori Okuji committed
853 854
        #
        ###############################################################
855
        select_expression = ''
856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877
        if show_stat:
          stats = here.portal_selections.getSelectionStats(selection_name, REQUEST=REQUEST)
          index = 0

          for (sql,title,alias) in extended_columns:
            # XXX This might be slow.
            for column in stat_columns:
              if column[0] == sql:
                break
            else:
              column = None
            if column is not None and column[0] == column[1]:
              try:
                if stats[index] != ' ':
                  select_expression += stats[index] + '(' + sql + ') AS ' + alias + ','
                else:
                  select_expression += '\'&nbsp;\' AS ' + alias + ','
              except:
                select_expression += '\'&nbsp;\' AS ' + alias + ','
            index = index + 1

          select_expression = select_expression[:len(select_expression) - 1]
Yoshinori Okuji's avatar
Yoshinori Okuji committed
878

879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894
        ###############################################################
        #
        # Calculate list start temporarily
        #
        ###############################################################
        if render_format == 'list':
          start = 0
        else:
          try:
            start = REQUEST.get('list_start')
            start = int(start)
          except:
            start = params.get('list_start',0)
            start = int(start)
          start = max(start, 0)
          
895
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
896
        #
897 898 899 900 901
        # Build the report tree
        #
        # When we build the body, we have to go through all report lines
        #
        # Each report line is a tuple of the form:
902 903
        #
        # (section_id, is_summary, depth, object_list, object_list_size, is_open)
Yoshinori Okuji's avatar
Yoshinori Okuji committed
904 905
        #
        ###############################################################
Jean-Paul Smets's avatar
Jean-Paul Smets committed
906
        if report_tree:
907 908 909 910 911 912 913
          default_selection_report_path = report_root_list[0][0].split('/')[0]
          if default_selection_report_path in portal_categories.objectIds() or \
            (portal_domains is not None and default_selection_report_path in portal_domains.objectIds()):
            pass
          else:
            default_selection_report_path = report_root_list[0][0]          
          selection_report_path = selection.getReportPath(default = (default_selection_report_path,))
914 915
          if report_depth is not None:
            selection_report_current = ()
916
          else:
917
            selection_report_current = selection.getReportList()
918
          report_tree_list = makeTreeList(here, form, None, selection_report_path, None,
919 920
                                          0, selection_report_current, form.id, selection_name, report_depth, 
                                          is_report_opened, sort_on=selection.sort_on)
921 922

          # Update report list if report_depth was specified
923 924 925
          if report_depth is not None:
            report_list = map(lambda s:s[0].getRelativeUrl(), report_tree_list)
            selection.edit(report_list=report_list)
926

Jean-Paul Smets's avatar
Jean-Paul Smets committed
927 928 929
          report_sections = []
          #LOG("Report Tree",0,str(report_tree_list))
          for s in report_tree_list:
930
            # Prepare query by defining selection report object
931 932
            #if s[4] is not _parent_domain_mark:
            selection.edit(report = s[4])            
Jean-Paul Smets's avatar
Jean-Paul Smets committed
933
            if s[1]:
934 935 936
              # Push new select_expression
              original_select_expression = kw.get('select_expression')
              kw['select_expression'] = select_expression
Jean-Paul Smets's avatar
Jean-Paul Smets committed
937
              selection.edit( params = kw )
938
              #LOG('ListBox 569', 0, str((selection_name, selection.__dict__)))
939
              stat_temp = selection(method = stat_method, context=here, REQUEST=REQUEST)
940 941 942 943 944
              # Pop new select_expression
              if original_select_expression is None:
                del kw['select_expression']
              else:
                kw['select_expression'] = original_select_expression
Jean-Paul Smets's avatar
Jean-Paul Smets committed
945

946
            if s[1] and show_stat:
Jean-Paul Smets's avatar
Jean-Paul Smets committed
947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962
              # stat_result is a list
              # we want now to make it a dictionnary
              # Is this a report line
              # object_stat = ....
              stat_result = {}
              index = 1

              for (k,v) in columns:
                try:
                  stat_result[k] = str(stat_temp[0][index])
                except IndexError:
                  stat_result[k] = ''
                index = index + 1

              stat_context = s[0].asContext(**stat_result)
              stat_context.absolute_url = lambda x: s[0].absolute_url()
963
              stat_context.domain_url = s[0].getRelativeUrl()
964
              section_title = s[0].getTitle()     
965
              section_title = translate('content', section_title, section_title.decode('utf-8'))
966 967
              if type(section_title) == type(u''):
                section_title = section_title.encode('utf-8')
968
              report_sections += [(s[0].getTitle(), 1, s[2], [stat_context], 1, s[3], s[4], stat_context, 0)]
969
              #                 report id, is_summary, depth, object_list, object_list_len, XX, XX, report_object, start, stop
Jean-Paul Smets's avatar
Jean-Paul Smets committed
970 971 972
            else:
              # Prepare query
              selection.edit( params = kw )
973
              if list_method not in (None, ''):
974 975 976 977
                #if s[4] is not _parent_domain_mark:
                object_list = selection(method = list_method, context=here, REQUEST=REQUEST)
                #else:
                #  object_list = [s[0]]           
978 979
              else:
                # If list_method is None, use already selected values.
980 981
                #if s[4] is not _parent_domain_mark:
                object_list = here.portal_selections.getSelectionValueList(selection_name, 
982
                                                                context=here, REQUEST=REQUEST)
983 984
                #else:
                #  object_list = [s[0]]           
985
#               # PERFORMANCE ? is len(object_list) fast enough ?
986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005
              exception_uid_list = s[5]
              if exception_uid_list is not None:
                # Filter folders if this is a parent tree
                new_object_list = []
                for o in object_list:
                  #LOG('exception_uid_list', 0, '%s %s' % (o.getUid(), exception_uid_list))
                  if o.getUid() not in exception_uid_list:
                    new_object_list.append(o)
                object_list = new_object_list
              object_list_len = len(object_list)              
              if not s[1]:
                if show_stat:
                  report_sections += [ (None, 0, s[2], object_list, object_list_len, s[3], s[4], None, 0) ]
              else:                       
                stat_context = s[0].asContext()
                stat_context.absolute_url = lambda x: s[0].absolute_url()
                stat_context.domain_url = s[0].getRelativeUrl()
                if object_list_len and s[3]:
                  # Display object data at same level as category selector
                  # If this domain is open
1006
                  report_sections += [ (s[0].getTitle(), 0, s[2], [object_list[0]], 1, s[3], s[4], stat_context, 0) ]
1007 1008 1009 1010
                  report_sections += [ (None, 0, s[2], object_list, object_list_len - 1, s[3], s[4], None, 1) ]
                else:                  
                  if exception_uid_list is not None:
                    # Display current parent domain
1011
                    report_sections += [ (s[0].getTitle(), 0, s[2], [s[0]], 1, s[3], s[4], stat_context, 0) ]
1012 1013
                  else:                    
                    # No data to display
1014
                    report_sections += [ (s[0].getTitle(), 0, s[2], [None], 1, s[3], s[4], stat_context, 0) ]
1015 1016 1017

          # Reset original value
          selection.edit(report = None)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1018
        else:
1019
          #LOG('ListBox 612', 0, str((selection_name, selection.__dict__)))
1020
          if list_method is not None:
1021
            if count_method is not None and not selection.invert_mode and render_format == 'html':
1022 1023 1024 1025
              #LOG('ListBox', 0, 'use count_method %r' % count_method)
              # If the count method is available, get only required objects.
              selection.edit( params = kw, report = None )
              count = selection(method = count_method, context=here, REQUEST=REQUEST)
1026
              object_list_len = int(count[0][0])
1027 1028
              if start > object_list_len:
                start = object_list_len
1029 1030 1031 1032 1033 1034
              start -= (start % lines)
              kw['limit'] = (start, lines)
              selection.edit( params = kw, report = None )
              object_list = selection(method = list_method, context=here, REQUEST=REQUEST)
              del kw['limit']
              selection.edit( params = kw, report = None ) # XXX Necessary?
1035 1036 1037 1038 1039 1040
              # For convenience, add padding into the list of objects with None.
              object_list = [None] * start + list(object_list) + [None] * (object_list_len - len(object_list) - start)
            else:
              selection.edit( params = kw, report = None )
              object_list = selection(method = list_method, context=here, REQUEST=REQUEST)
              object_list_len = len(object_list)
1041
          else:
1042
            selection.edit( params = kw, report = None )
1043 1044
            # If list_method is None, use already selected values.
            object_list = here.portal_selections.getSelectionValueList(selection_name, context=here, REQUEST=REQUEST)
1045 1046
            # PERFORMANCE PROBLEM ? is len(object_list) fast enough ?
            object_list_len = len(object_list)
1047
          report_sections = ( (None, 0, 0, object_list, object_list_len, 0, None, None, 0),  )
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1048

Yoshinori Okuji's avatar
Yoshinori Okuji committed
1049

1050
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1051 1052 1053
        #
        # Build an md5 signature of the selection
        #
1054
        # It is calculated based on the selection uid list
Sebastien Robin's avatar
Sebastien Robin committed
1055 1056 1057 1058 1059 1060
        # It is used in order to do some checks in scripts.
        # For example, if we do delete objects, then we do have a list of
        # objects to delete, but it is possible that on another tab the selection
        # change, and then when we confirm the deletion, we don't delete what
        # we want, so this is really dangerous. with this md5 we can check if the
        # selection is the same
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1061 1062 1063
        #
        ###############################################################

1064 1065 1066 1067 1068
        # XXX To avoid the difference of the string representations of int and long,
        # convert each element to a string. 
        object_uid_list = [str(getattr(x, 'uid', None)) for x in object_list]
        object_uid_list.sort()
        md5_string = md5.new(str(object_uid_list)).hexdigest()
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1069

1070
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1071
        #
1072
        # Calculate list start and stop
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1073
        #
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1074 1075 1076
        # Build the real list by slicing it
        # PERFORMANCE ANALYSIS: the result of the query should be
        # if possible a lazy sequence
1077
        #
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1078 1079
        ###############################################################

1080
        #LOG("Selection", 0, str(selection.__dict__))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1081 1082 1083
        total_size = 0
        for s in report_sections:
          total_size += s[4]
1084
        if render_format == 'list':
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1085 1086
          end = total_size
          total_pages = 1
1087
          current_page = 0
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1088
        else:
1089 1090 1091 1092 1093 1094 1095 1096 1097
          end = min(start + lines, total_size)
          #object_list = object_list[start:end]
          total_pages = int(max(total_size-1,0) / lines) + 1
          current_page = int(start / lines)
          start = min(start, max(0, total_pages * lines - lines) )
          kw['list_start'] = start
          kw['list_lines'] = lines

        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1098
        #
1099
        # Store new selection values
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1100
        #
1101 1102
        # Store the resulting selection if list_method is not None and render_format is not list
        #
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1103
        ###############################################################
1104
        if list_method is not None and render_format != 'list':
1105 1106
          try:
            method_path = getPath(here) + '/' + list_method.method_name
1107
            #LOG('ListBox', 0, 'method_path = %s, getPath = %s, list_method.method_name = %s' % (repr(method_path), repr(getPath(here)), repr(list_method.method_name)))
1108 1109
          except:
            method_path = getPath(here) + '/' + list_method.__name__
1110
            #LOG('ListBox', 0, 'method_path = %s, getPath = %s, list_method.__name__ = %s' % (repr(method_path), repr(getPath(here)), repr(list_method.__name__)))
1111 1112 1113 1114 1115
          # Sometimes the seltion name is a list ??? Why ????
          if type(current_selection_name) in (type(()),type([])):
            current_selection_name = current_selection_name[0]
          list_url =  url+'?selection_name='+current_selection_name+'&selection_index='+str(selection_index)
          selection.edit( method_path= method_path, params = kw, list_url = list_url)
1116 1117
          #LOG("Selection kw", 0, str(selection.selection_params))
          here.portal_selections.setSelectionFor(selection_name, selection, REQUEST=REQUEST)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1118

1119
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1120
        #
1121
        # Build HTML header and footer
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1122
        #
1123
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1124

Jean-Paul Smets's avatar
Jean-Paul Smets committed
1125 1126 1127 1128
        # Provide the selection name
        selection_line = """\
<input type="hidden" name="list_selection_name" value="%s" />
""" % selection_name
Sebastien Robin's avatar
Sebastien Robin committed
1129 1130 1131
        selection_line +="""\
<input type="hidden" name="md5_object_uid_list" value="%s" />
""" % md5_string
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1132 1133 1134 1135 1136 1137 1138

        # Create the Page Selector
        if start == 0:
          pages = """\
   <td nowrap valign="middle" align="center">
   </td>
   <td nowrap valign="middle" align="center">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1139
    <select name="list_start" title="%s" size="1"
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1140
      onChange="submitAction(this.form,'%s/portal_selections/setPage')">
1141
""" % (translate('ui', 'Change Page', default='Change Page'), REQUEST.URL1)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1142 1143 1144
        else:
          pages = """\
   <td nowrap valign="middle" align="center">
Sebastien Robin's avatar
Sebastien Robin committed
1145
    <input type="image" src="%s/images/1leftarrowv.png"
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1146
      title="%s" name="portal_selections/previousPage:method" border="0" />
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1147 1148
   </td>
   <td nowrap valign="middle" align="center">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1149
    <select name="list_start" title="%s" size="1"
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1150
      onChange="submitAction(this.form,'%s/portal_selections/setPage')">
1151
""" % (portal_url_string, translate('ui', 'Previous Page', default='Previous Page'), translate('ui', 'Change Page', default='Change Page'), REQUEST.URL1)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1152 1153
        for p in range(0, total_pages):
          if p == current_page:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1154
            selected = 'selected'
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1155
          else:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1156 1157 1158 1159
            selected = ''
          pages += '<option %s value="%s">%s</option>\n' \
                  % (selected,
                     p * lines,
1160
                     translate('ui', '${page} of ${total_pages}', default = '%s of %s' % (p+1, total_pages),
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1161
                               mapping = {'page' : p+1, 'total_pages': total_pages}))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1162 1163

        if current_page == total_pages - 1:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1164
          pages += """\
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1165 1166 1167 1168 1169 1170
    </select>
   </td>
   <td nowrap valign="middle" align="center">
   </td>
"""
        else:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1171
          pages += """\
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1172 1173 1174
    </select>
   </td>
   <td nowrap valign="middle" align="center">
Sebastien Robin's avatar
Sebastien Robin committed
1175
    <input type="image" src="%s/images/1rightarrowv.png"
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1176
      title="%s" name="portal_selections/nextPage:method" border="0" />
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1177
   </td>
1178
""" % (portal_url_string, translate('ui', 'Next Page', default='Next Page'))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1179 1180 1181
        # Create the header of the table - this should probably become DTML
        # Create also View Selector which enables to switch from a view mode
        # to another directly from the listbox
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1182 1183 1184 1185
        #LOG('ListBox', 0, 'field_title = %s, translate(\'ui\', field_title) + %s' % (repr(field_title), repr(translate('ui', field_title))))
        format_dict = {
                        'portal_url_string' : portal_url_string,
                        'list_action' : list_action,
1186
                        'field_title' : translate('ui', field_title, default = field_title),
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1187
                        'pages' : pages,
1188
                        'record_number' : translate('ui', '${number} record(s)', default = '%s record(s)' % total_size,
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1189
                                                    mapping = { 'number' : str(total_size) }),
1190
                        'item_number' : translate('ui', '${number} item(s) selected', default = '%s item(s) selected' % len(checked_uids),
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1191
                                                  mapping = { 'number' : str(len(checked_uids)) }),
1192 1193 1194
                        'flat_list_title': translate('ui', 'Flat List', default = 'Flat List'),
                        'report_tree_title': translate('ui', 'Report Tree', default = 'Report Tree'),
                        'domain_tree_title': translate('ui', 'Domain Tree', default = 'Domain Tree'),
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1195
                      }
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1196 1197 1198 1199 1200
        header = """\
<!-- List Summary -->
<div class="ListSummary">
 <table border="0" cellpadding="0" cellspacing="0">
  <tr height="10">
1201
   <td height="10"><img src="%(portal_url_string)s/images/Left.png" border="0"/></td>
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1202
   <td class="Top" colspan="2" height="10">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1203
    <img src="%(portal_url_string)s/images/spacer.png" width="5" height="10" border="0"
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1204 1205
      alt="spacer"/></td>
   <td class="Top" colspan="3" height="10">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1206
    <img src="%(portal_url_string)s/images/spacer.png" width="5" height="10" border="0"
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1207 1208 1209 1210 1211
      alt="spacer"/>
   </td>
  </tr>
  <tr>
   <td class="Left" width="17">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1212
    <img src="%(portal_url_string)s/images/spacer.png" width="5" height="5" border="0"
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1213 1214 1215
        alt="spacer"/>
   </td>
   <td valign="middle" nowrap>
1216 1217 1218
""" % format_dict
        if len(report_root_list) or len(domain_root_list):
          header += """
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1219 1220
    <input type="image" src="%(portal_url_string)s/images/text_block.png" id="flat_list"
       title="%(flat_list_title)s" name="portal_selections/setFlatListMode:method" value="1" border="0" alt="img"/">
1221 1222 1223 1224
""" % format_dict
        if len(report_root_list):
          header += """       
    <input type="image" src="%(portal_url_string)s/images/view_tree.png" id="report_list"
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1225
       title="%(report_tree_title)s" name="portal_selections/setReportTreeMode:method" value="1" border="0" alt="img"/">
1226 1227 1228 1229 1230 1231 1232 1233
""" % format_dict  
        if len(domain_root_list):
          header += """       
        <input type="image" src="%(portal_url_string)s/images/view_choose.png" id="domain_list"
       title="%(domain_tree_title)s" name="portal_selections/setDomainTreeMode:method" value="1" border="0" alt="img"/">
""" % format_dict
        header += """             
       </td>
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1234 1235
   <td width="100%%" valign="middle">&nbsp; <a href="%(list_action)s">%(field_title)s</a>:
        %(record_number)s - %(item_number)s
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1236
   </td>
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1237
   %(pages)s
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1238 1239 1240 1241 1242 1243
  </tr>
 </table>
</div>
<!-- List Content -->
<div class="ListContent">
 <table cellpadding="0" cellspacing="0" border="0">
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1244
""" % format_dict
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273

        # pages

        # Create the footer. This should be replaced by DTML
        # And work as some kind of parameter

        footer = """\
   <tr >
    <td colspan="%s" width="50" align="center" valign="middle"
        class="DataA">
    </td>
   </tr>
  </table>
 </div>
""" % (len(columns))

        # Create the header of the table with the name of the columns
        # Create also Report Tree Column if needed
        if report_tree:
          report_tree_options = ''
          for c in report_root_list:
            if c[0] == selection_report_path:
              report_tree_options += """<option selected value="%s">%s</option>\n""" % (c[0], c[1])
            else:
              report_tree_options += """<option value="%s">%s</option>\n""" % (c[0], c[1])
          report_popup = """<select name="report_root_url"
onChange="submitAction(this.form,'%s/portal_selections/setReportRoot')">
        %s</select>""" % (here.getUrl(),report_tree_options)
          report_popup = """
1274
  <td class="Data" width="50" align="left" valign="middle">
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1275 1276 1277 1278 1279 1280 1281
  %s
  </td>
""" % report_popup
        else:
          report_popup = ''

        if select:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1282 1283 1284
          format_dict = {
                          'portal_url_string' : portal_url_string,
                          'report_popup' : report_popup,
1285 1286
                          'check_all_title' : translate('ui', 'Check All', default = 'Check All'),
                          'uncheck_all_title' : translate('ui', 'Uncheck All', default = 'Uncheck All'),
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1287
                        }
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1288
          list_header = """\
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1289
<tr>%(report_popup)s
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1290
   <td class="Data" width="50" align="center" valign="middle">
1291
    <input type="image" name="portal_selections/checkAll:method" value="1"
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1292
      src="%(portal_url_string)s/images/checkall.png" border="0" alt="Check All" title=%(check_all_title)s />
1293
    <input type="image" name="portal_selections/uncheckAll:method" value="1"
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1294 1295
      src="%(portal_url_string)s/images/decheckall.png" border="0" alt="Uncheck All" title=%(uncheck_all_title)s />
""" % format_dict
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1296 1297
        else:
          list_header = """\
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1298
<tr>%s
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1299
""" % report_popup
1300

Jean-Paul Smets's avatar
Jean-Paul Smets committed
1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311
        # csort is a list of couples
        # we should convert it into a dict because a list of couples would need
        # a loop in each loop
        sort_dict = {}
        csort = here.portal_selections.getSelectionSortOrder(selection_name)
        for index in csort:
          sort_dict[index[0]] = index[1]

        for cname in columns:
          if sort_dict.has_key(cname[0]):
            if sort_dict[cname[0]] == 'ascending':
1312
              img = '<img src="%s/images/1bottomarrow.png" alt="Ascending display"/>' % portal_url_string
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1313
            elif sort_dict[cname[0]] == 'descending':
1314
              img = '<img src="%s/images/1toparrow.png" alt="Descending display"/>' % portal_url_string
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1315 1316 1317 1318
            else:
              img = ''
          else:
            img = ''
1319
          #LOG('ListBox', 0, 'cname = %r' % (cname,))
1320
          if cname[0] in sort_columns_id_list:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1321
            #LOG('ListBox', 0, 'str(cname[1]) = %s, translate(\'ui\',str(cname[1])) = %s' % (repr(str(cname[1])), repr(translate('ui',str(cname[1])))))
1322
            list_header += ("<td class=\"Data\"><a href=\"%s/portal_selections/setSelectionQuickSortOrder?selection_name=%s&sort_on=%s\">%s</a> %s</td>\n" %
1323
                (here.absolute_url(),str(selection_name),cname[0],translate('ui', cname[1], default = cname[1]),img))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1324
          else:
1325
            list_header += ("<td class=\"Data\">%s</td>\n" % translate('ui', cname[1], default = cname[1]))
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1326 1327
        list_header = list_header + "</tr>"

1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338
        # Create report depth_selector
        if report_tree:
          depth_selector = ''
          for i in range(0,6):
            # XXX We may lose previous list information
            depth_selector += """&nbsp;<a href="%s/%s?selection_name=%s&selection_index=%s&report_depth:int=%s">%s</a>""" % \
                                      (here.absolute_url(), form.id, current_selection_name, current_selection_index , i, i)
          # In report mode, we may want to hide items, and only display stat lines.
          depth_selector += """&nbsp;-&nbsp;<a href="%s/%s?selection_name=%s&selection_index=%s&is_report_opened:int=%s">%s</a>""" % \
                                    (here.absolute_url(), form.id, current_selection_name, current_selection_index , 1 - is_report_opened, is_report_opened and 'Hide' or 'Show')
                
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1339 1340 1341
        # Create the search row of the table with the name of the columns
        if search:
          if report_tree:
1342
            # Add empty column for report
1343
            report_search = """<td class="Data" width="50" align="left" valign="middle">%s</td>""" % depth_selector
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1344 1345 1346 1347 1348 1349 1350 1351
          else:
            report_search = ""

          if select:
            list_search ="""\
  <tr >
   %s
   <td class="Data" width="50" align="center" valign="middle">
1352
     <input type="image" src="%s/images/exec16.png" title="%s" alt="Action" name="Base_doSelect:method" />
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1353
   </td>
1354
""" % (report_search,portal_url_string,translate('ui', 'Action', default = 'Action')) # XXX Action? Is this word appropriate here?
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1355 1356 1357 1358 1359 1360 1361 1362
          else:
            list_search ="""\
  <tr >
  %s
""" % report_search

          for cname in extended_columns:
            if cname[0] in search_columns_id_list:
1363
              alias = str(cname[2])
1364 1365
              if type(alias) == type(''):
                alias = unicode(alias, 'utf-8')
1366 1367 1368
              param = params.get(alias,'')
              if type(param) == type(''):
                param = unicode(param, 'utf-8')
1369 1370 1371 1372 1373 1374 1375 1376
              search_field_id = 'search_%s_%s' % (field.id, alias)                
              if form.has_field(search_field_id):
                # First look for a search field
                search_field = form.get_field(search_field_id)
                search_field_html = search_field.render(value = param, key=alias)
              else:
                # Then create default rendering                
                search_field_html = """<input name="%s" size="8" value="%s" />""" % (alias, param)
1377 1378
              list_search += """\
     <td class="DataB">
1379
       <font size="-3">%s</font>
1380
     </td>
1381
""" % search_field_html
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1382 1383 1384 1385 1386 1387
            else:
              list_search = list_search + (
                "<td class=\"DataB\"></td> ")

          list_search = list_search + "</tr>"
        else:
1388 1389 1390 1391 1392
          if report_tree:
            list_search = """<td class="Data" width="50" align="left" valign="middle" colspan="%s">%s</td>""" % \
                              (len(extended_columns) + select + 1, depth_selector)
          else:
            list_search = ''
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1393

1394 1395 1396
        # Build the tuple of columns
        if render_format == 'list':
          c_name_list = []
1397
          c_property_id_list = []
1398 1399
          for cname in columns:
            c_name_list.append(cname[1])
1400
            c_property_id_list.append(cname[0])
1401 1402

        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1403
        #
1404
        # Build lines
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1405
        #
1406
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1407

1408

Jean-Paul Smets's avatar
Jean-Paul Smets committed
1409 1410
        # Build Lines
        list_body = ''
1411

1412
        if render_format == 'list': 
1413 1414 1415 1416
          # initialize the title line
          title_listboxline = ListBoxLine()
          title_listboxline.markTitleLine()
          for cname in columns:
1417
            title_listboxline.addColumn( cname[0], cname[1].encode('utf-8'))
1418 1419
          listboxline_list.append(title_listboxline)  

Jean-Paul Smets's avatar
Jean-Paul Smets committed
1420 1421
        section_index = 0
        current_section_base_index = 0
1422 1423 1424 1425
        if len(report_sections) > section_index:
          current_section = report_sections[section_index]
        elif len(report_sections):
          current_section = report_sections[0]
1426 1427
        else:
          current_section = None
1428 1429 1430
        if current_section is not None:
          current_section_size = current_section[4]
          object_list = current_section[3]
1431 1432
          stat_context = current_section[7]
          index_shift = current_section[8]
1433
          #if current_section is not None:
1434
          for i in range(start,end):
1435 1436 1437 1438 1439 1440 1441

            if render_format == 'list':
              # Create a ListBoxLine object
              current_listboxline = ListBoxLine()
              current_listboxline.markDataLine()
            

1442 1443
            # Set the selection index.
            selection.edit(index = i)
1444

1445 1446 1447 1448 1449 1450 1451
            # Make sure we go to the right section
            while current_section_base_index + current_section_size <= i:
              current_section_base_index += current_section[4]
              section_index += 1
              current_section = report_sections[section_index]
              current_section_size = current_section[4]
              object_list = current_section[3]
1452 1453 1454
              stat_context = current_section[7]
              index_shift = current_section[8]
                            
1455

1456
            is_summary = current_section[1] # Update summary type
1457

1458
            list_body = list_body + '<tr>'
1459
            o = object_list[i - current_section_base_index + index_shift] # FASTER PERFORMANCE
1460
            real_o = None
1461

1462 1463 1464
            # Define the CSS
            if not (i - start) % 2:
              td_css = 'DataA'
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1465
            else:
1466
              td_css = 'DataB'
1467

1468 1469 1470
            list_body = list_body + \
  """<input type="hidden" value="%s" name="%s_uid:list"/>
  """ % ( getattr(o, 'uid', '') , field.id ) # What happens if we list instances which are not instances of Base XXX
1471

1472 1473
            section_char = ''
            if report_tree:
1474
              if is_summary or current_section[0] is not None:
1475 1476
                # This is a summary
                section_name = current_section[0]
1477
              else:
1478
                section_name = ''
1479
                
1480 1481 1482 1483 1484
              if current_section[5]:
                if section_name != '':
                  section_char = '-'
                list_body = list_body + \
  """<td class="%s" align="left" valign="middle"><a href="portal_selections/foldReport?report_url=%s&form_id=%s&list_selection_name=%s">%s%s%s</a></td>
1485
  """ % (td_css, getattr(stat_context,'domain_url',''), form.id, selection_name, '&nbsp;&nbsp;' * current_section[2], section_char, translate('content', section_name, default=section_name.decode('utf-8')))
1486
  
1487
                if render_format == 'list': 
1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498
                  
                  if is_summary:
                    current_listboxline.markSummaryLine()
                  # XXX temporary correction (I dont some '' which havent signification)
                  if section_name == '':
                    section_name = None

                  current_listboxline.setSectionDepth( current_section[2]+1 )
                  current_listboxline.setSectionName( section_name )
                  current_listboxline.setSectionFolded( 0 )

1499 1500 1501 1502 1503
              else:
                if section_name != '':
                  section_char = '+'
                list_body = list_body + \
  """<td class="%s" align="left" valign="middle"><a href="portal_selections/unfoldReport?report_url=%s&form_id=%s&list_selection_name=%s">%s%s%s</a></td>
1504
  """ % (td_css, getattr(stat_context,'domain_url',''), form.id, selection_name, '&nbsp;&nbsp;' * current_section[2], section_char, translate('content', section_name, default=section_name.decode('utf-8')))
1505

1506
                if render_format == 'list': 
1507 1508 1509 1510 1511 1512 1513 1514 1515 1516
                  
                  if is_summary:
                    current_listboxline.markSummaryLine()
                  # XXX temporary correction (I dont some '' which havent signification)
                  if section_name == '':
                    section_name = None

                  current_listboxline.setSectionDepth( current_section[2]+1 )
                  current_listboxline.setSectionName( section_name )
                  current_listboxline.setSectionFolded( 1 )
1517

1518
            if select:
1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532
              if o is not None:
                if o.uid in checked_uids:
                  selected = 'checked'
                else:
                  selected = ''
                if is_summary:
                  list_body = list_body + \
    """<td class="%s" width="50" align="center" valign="middle">&nbsp;</td>
    """ % (td_css, )
                else:
                  list_body = list_body + \
    """<td class="%s" width="50" align="center" valign="middle">&nbsp;
    <input type="checkbox" %s value="%s" id="cb_%s" name="uids:list"/></td>
    """ % (td_css, selected, o.uid , o.uid)
1533 1534
              else:
                list_body = list_body + \
1535 1536 1537
    """<td class="%s" width="50" align="center" valign="middle">&nbsp;</td>
    """ % td_css
              
1538
            error_list = []
1539 1540 1541


            if render_format == 'list': 
1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577
              if o is not None:
                if selected == '':
                  current_listboxline.setObjectUid( o.uid )
                  current_listboxline.checkLine( 0 )
                else:
                  current_listboxline.setObjectUid( o.uid )
                  current_listboxline.checkLine( 1 )

            if o is None:
              # This line is an empty line used by reports without statistics
              list_body += ('<td class=\"%s\">&nbsp;</td>' % td_css) * len(extended_columns)
            else:            
              for cname in extended_columns:
                # add attribute_original_value, because I need to know the type of the attribute 
                attribute_original_value = None
  
                sql = cname[0] # (sql, title, alias)
                alias = cname[2] # (sql, title, alias)
                if '.' in sql:
                  property_id = '.'.join(sql.split('.')[1:]) # Only take trailing part
                else:
                  property_id = alias
    #            attribute_value = getattr(o, cname_id) # FUTURE WAY OF DOING TGW Brains
                my_field = None
                tales_expr = None
                if form.has_field('%s_%s' % (field.id, alias) ) and not is_summary:
                  my_field_id = '%s_%s' % (field.id, alias)
                  my_field = form.get_field(my_field_id)
                  tales_expr = my_field.tales.get('default', "")
                if tales_expr:
                  #
                  real_o = o
                  if hasattr(o,'getObject'): # we have a line of sql result
                    real_o = o.getObject()
                  field_kw = {'cell':real_o}
                  attribute_value = my_field.__of__(real_o).get_value('default',**field_kw)
1578
                  attribute_original_value = attribute_value
1579
                else:
1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596
                  # Prepare stat_column is this is a summary
                  if is_summary:
                    # Use stat method to find value
                    for stat_column in stat_columns:
                      if stat_column[0] == sql:
                        break
                    else:
                      stat_column = None
                  if hasattr(aq_self(o),alias) and (not is_summary or stat_column is None or stat_column[0] == stat_column[1]): # Block acquisition to reduce risks
                    # First take the indexed value
                    attribute_value = getattr(o,alias) # We may need acquisition in case of method call
                    attribute_original_value = attribute_value
                  elif is_summary:
                    attribute_value = getattr(here, stat_column[1])
                    attribute_original_value = attribute_value
                    #LOG('ListBox', 0, 'column = %s, value = %s' % (repr(column), repr(value)))
                    if callable(attribute_value):
1597
                      try:
1598 1599 1600 1601 1602 1603 1604
                        # set report and closed_summary
                        if report_tree == 1 :
                          selection.edit(report=current_section[6])
                          kw['closed_summary'] = 1 - current_section[5]
                          params = dict(kw)
                          selection.edit(params=params)
                        attribute_value=attribute_value(selection=selection)
1605
                        attribute_original_value = attribute_value
1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626
                        # reset report and closed_summary
                        if report_tree == 1 :
                          selection.edit(report=None)
                          del kw['closed_summary']
                          params = dict(kw)
                          selection.edit(params=params)
                      except:
                        LOG('ListBox', 0, 'WARNING: Could not call %s with %s: ' % (repr(attribute_value), repr(params)), error=sys.exc_info())
                        pass
                  else:
      #             MUST IMPROVE FOR PERFORMANCE REASON
      #             attribute_value = 'Does not exist'
                    if real_o is None:
                      try:
                        real_o = o.getObject()
                      except:
                        pass
                    if real_o is not None:
                      try:
                        try:
                          attribute_value = getattr(real_o,property_id, None)
1627
                          attribute_original_value = attribute_value
1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638
                          #LOG('Look up attribute %s' % cname_id,0,str(attribute_value))
                          if not callable(attribute_value):
                            #LOG('Look up accessor %s' % cname_id,0,'')
                            attribute_value = real_o.getProperty(property_id)
                            attribute_original_value = attribute_value
  
                            #LOG('Look up accessor %s' % cname_id,0,str(attribute_value))
                        except:
                          attribute_value = getattr(real_o,property_id)
                          attribute_original_value = attribute_value
                          #LOG('Fallback to attribute %s' % cname_id,0,str(attribute_value))
1639
                      except:
1640 1641 1642 1643
                        attribute_value = 'Can not evaluate attribute: %s' % sql
                        attribute_original_value = None
                    else:
                      attribute_value = 'Object does not exist'
1644
                      attribute_original_value = None
1645
                if callable(attribute_value):
1646
                  try:
1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663
                    try:
                      attribute_value = attribute_value(brain = o, selection = selection)
                      attribute_original_value = attribute_value
                    except TypeError:
                      attribute_value = attribute_value()
                      attribute_original_value = attribute_value
                  except:
                    LOG('ListBox', 0, 'Could not evaluate', error=sys.exc_info())
                    attribute_value = "Could not evaluate"
                    attribute_original_value = None
                #LOG('ListBox', 0, 'o = %s' % repr(dir(o)))
                if type(attribute_value) is type(0.0):
                  attribute_original_value = attribute_value
                  if sql in editable_column_ids and form.has_field('%s_%s' % (field.id, alias) ):
                    # Do not truncate if editable
                    pass
                  else:
1664 1665 1666
                    #attribute_original_value = attribute_value
                    attribute_value = "%.2f" % attribute_value
                  td_align = "right"
1667 1668
                elif type(attribute_value) is type(1):
                  attribute_original_value = attribute_value
1669 1670 1671
                  td_align = "right"
                else:
                  td_align = "left"
1672
                # It is safer to convert attribute_value to an unicode string, because
1673
                # it might be utf-8.
1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706
                if type(attribute_value) == type(''):
                  attribute_value = unicode(attribute_value, 'utf-8')
                  attribute_original_value = attribute_value
                elif attribute_value is None:
                  attribute_original_value = None
                  attribute_value = ''
                if sql in editable_column_ids and form.has_field('%s_%s' % (field.id, alias)) and not is_summary:
                  key = my_field.id + '_%s' % o.uid
                  if field_errors.has_key(key):
                    error_css = 'Error'
                    error_message = "<br/>%s" % translate('ui', field_errors[key].error_text, default = field_errors[key].error_text)
                    # Display previous value (in case of error
                    error_list.append(field_errors.get(key))
                    display_value = REQUEST.get('field_%s' % key, attribute_value)
                  else:
                    error_css = ''
                    error_message = ''
                    #display_value = REQUEST.get('field_%s' % key, attribute_value)
                    display_value = attribute_value # XXX Make sure this is ok
                  #LOG('ListBox', 0, 'display_value = %r' % display_value)
                  if type(display_value) == type(u''):
                    display_value = display_value.encode('utf-8')
                  if my_field.meta_type not in ('DateTimeField', ):
                    cell_body = my_field.render(value = display_value, REQUEST = o, key = key)
                                                                # We use REQUEST which is not so good here
                                                                # This prevents from using standard display process
                  else: # Some fields prefer a None value to a ''
                    cell_body = my_field.render(value = attribute_original_value, REQUEST = o.asContext(REQUEST=REQUEST, form=REQUEST.form), key = key)
                  # It is safer to convert cell_body to an unicode string, because
                  # it might be utf-8.
                  if type(cell_body) == type(''):
                    cell_body = unicode(cell_body, 'utf-8')
                  #LOG('ListBox', 0, 'cell_body = %r, error_message = %r' % (cell_body, error_message))
1707
                  list_body += ('<td class=\"%s%s\">%s%s</td>' % (td_css, error_css, cell_body, error_message))
1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727
                  
  
                  # Add item to list_result_item for list render format
  #                if render_format == 'list':
  #                  column_value = my_field._get_default(my_field.generate_field_key(), attribute_original_value, o)
  #                  if type(column_value) is type(u''):
  #                    #column_value = unicode(column_value, 'utf-8')
  #                    column_value = column_value.encode('utf-8')
  #                  current_listboxline.addColumn(property_id , column_value)
                  if render_format == 'list': 
                    # Make sure that attribute value is UTF-8
                    attribute_value_tmp  = attribute_original_value
                    if type(attribute_value_tmp) == type(u''):
                      attribute_value_tmp = attribute_original_value.encode('utf-8')
  
                    # XXX this is horrible, but it would be better without those &nbsp; ....
                    if type(attribute_value_tmp) == type(''):
                      if 'nbsp' in attribute_value_tmp:
                        attribute_value_tmp = None
                      
1728
                    current_listboxline.addColumn( cname[0] , attribute_value_tmp)
1729
  
1730
                else:
1731 1732 1733 1734 1735 1736 1737
                  # Check if url_columns defines a method to retrieve the URL.
                  url_method = None
                  for column in url_columns:
                    if sql == column[0]:
                      url_method = getattr(o, column[1], '')
                      break
                  if url_method is not None:
1738
                    try:
1739
                      object_url = url_method(brain = o, selection = selection)
1740 1741 1742 1743
                      list_body = list_body + \
                        ("<td class=\"%s\" align=\"%s\"><a href=\"%s\">%s</a></td>" %
                          (td_css, td_align, object_url, attribute_value))
                    except:
1744
                      LOG('ListBox', 0, 'Could not evaluate url_method %s' % column[1], error=sys.exc_info())
1745 1746 1747
                      list_body = list_body + \
                        ("<td class=\"%s\" align=\"%s\">%s</td>" % (td_css, td_align, attribute_value) )
                  else:
1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781
                    # Check if this object provides a specific URL method
                    url_method = getattr(o, 'getListItemUrl', None)
                    if url_method is None:
                      try:
                        object_url = o.absolute_url() + \
                          '/view?selection_index=%s&selection_name=%s&reset=1' % (i, selection_name)
                        list_body = list_body + \
                          ("<td class=\"%s\" align=\"%s\"><a href=\"%s\">%s</a></td>" %
                            (td_css, td_align, object_url, attribute_value))
                      except:
                        list_body = list_body + \
                          ("<td class=\"%s\" align=\"%s\">%s</td>" % (td_css, td_align, attribute_value) )
                    else:
                      try:
                        object_url = url_method(alias, i, selection_name)
                        list_body = list_body + \
                          ("<td class=\"%s\" align=\"%s\"><a href=\"%s\">%s</a></td>" %
                            (td_css, td_align, object_url, attribute_value))
                      except:
                        list_body = list_body + \
                          ("<td class=\"%s\" align=\"%s\">%s</td>" % (td_css, td_align, attribute_value) )
  
  
                  if render_format == 'list': 
                    # Make sure that attribute value is UTF-8
                    attribute_value_tmp  = attribute_original_value
                    if type(attribute_value_tmp) == type(u''):
                      attribute_value_tmp = attribute_original_value.encode('utf-8')
  
                    # XXX this is horrible, but it would be better without those &nbsp; ....
                    if type(attribute_value_tmp) == type(''):
                      if 'nbsp' in attribute_value_tmp:
                        attribute_value_tmp = None
                      
1782
                    current_listboxline.addColumn( cname[0] , attribute_value_tmp)
1783

1784
            list_body = list_body + '</tr>'
1785

1786 1787 1788 1789

            if render_format == 'list':
              listboxline_list.append(current_listboxline)  
              
1790
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1791
        #
1792
        # Build statistics
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1793
        #
1794
        ###############################################################
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1795

1796
        # Call the stat method
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1797
        if show_stat:
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1798

1799 1800 1801 1802 1803
          if render_format == 'list':
            # Create a ListBoxLine object
            current_listboxline = ListBoxLine()
            current_listboxline.markStatLine()
            
1804 1805 1806
          kw['select_expression'] = select_expression
          selection.edit( params = kw )

1807
          count_results = selection(method = stat_method,
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1808 1809
                          context=here, REQUEST=REQUEST)
          list_body = list_body + '<tr>'
1810 1811
    
              
1812 1813 1814 1815 1816 1817
          if report_tree:
            list_body += '<td class="Data">&nbsp;</td>'
          if select:
            list_body += '<td class="Data">&nbsp;</td>'
          for n in range((len(extended_columns))):
            try:
1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833
              sql = extended_columns[n][0]
              for column in stat_columns:
                if column[0] == sql:
                  break
              else:
                column = None
              #LOG('ListBox', 0, 'n = %s, extended_columns = %s, stat_columns = %s, column = %s' % (repr(n), repr(extended_columns), repr(stat_columns), repr(column)))
              if column is not None:
                if column[0] == column[1]:
                  alias = extended_columns[n][2]
                  value = getattr(count_results[0],alias,'')
                else:
                  value = getattr(here, column[1])
                  #LOG('ListBox', 0, 'column = %s, value = %s' % (repr(column), repr(value)))
                  if callable(value):
                    try:
1834
                      #params = dict(kw)
1835
                      #params['operator'] = stats[n]
1836 1837
                      #value=value(**params)
                      value=value(selection=selection)
1838 1839 1840 1841 1842 1843 1844
                    except:
                      LOG('ListBox', 0, 'WARNING: Could not call %s with %s: ' % (repr(value), repr(params)), error=sys.exc_info())
                      pass
                if type(value) is type(1.0):
                  list_body += '<td class="Data" align="right">%.2f</td>' % value
                else:
                  list_body += '<td class="Data">' + str(value) + '</td>'
1845 1846


1847 1848
                if render_format == 'list': 
                  # Make sure that attribute value is UTF-8
1849
                  value_tmp  = value
1850
                  if type(value) == type(u''):
1851 1852 1853 1854 1855 1856 1857
                    value_tmp = value.encode('utf-8')

                  # XXX this is horrible, but it would be better without those &nbsp; ....
                  if type(value_tmp) == type(''):
                    if 'nbsp' in value_tmp:
                      value_tmp = None
                    
1858
                  current_listboxline.addColumn( column[0] , value_tmp )
1859

1860
              else:
1861
                list_body += '<td class="Data">&nbsp;</td>'
Romain Courteaud's avatar
Romain Courteaud committed
1862
                #if render_format == 'list': current_listboxline.addColumn( column[1] , None)
1863 1864
                if render_format == 'list':
                  current_listboxline.addColumn( column[0] , None)
1865
            except:
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1866
              list_body += '<td class="Data">&nbsp;</td>'
Romain Courteaud's avatar
Romain Courteaud committed
1867
              #if render_format == 'list': current_listboxline.addColumn( column[1] , None)
1868
              if render_format == 'list': current_listboxline.addColumn( extended_columns[n][0] , None)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1869 1870
          list_body += '</tr>'

1871 1872 1873
          if render_format == 'list':
            listboxline_list.append(current_listboxline)  
          
1874 1875
        #LOG('ListBox', 0, 'header = %r, selection_list = %r, list_header = %r, list_search = %r, list_body = %r, footer = %r' % (header, selection_line, list_header, list_search, list_body, footer))
        #LOG('ListBox', 0, 'header = %r, selection_list = %r, list_header = %r, list_search = %r, footer = %r' % (header, selection_line, list_header, list_search, footer))
1876
        list_html = header + selection_line + list_header + list_search + list_body + footer
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1877

1878

1879
        if render_format == 'list':
1880 1881 1882 1883
          #listboxline_list.append(current_listboxline)  
          LOG('ListBox', 0, 'listboxline_list: %s' % str(listboxline_list) )

          return listboxline_list
Yoshinori Okuji's avatar
Yoshinori Okuji committed
1884

Jean-Paul Smets's avatar
Jean-Paul Smets committed
1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897
        #Create DomainTree Selector and DomainTree box
        if domain_tree:
          select_tree_options = ''
          for c in domain_root_list:
            if c[0] == selection_domain_path:
              select_tree_options += """<option selected value="%s">%s</option>\n""" % (c[0], c[1])
            else:
              select_tree_options += """<option value="%s">%s</option>\n""" % (c[0], c[1])
          select_tree_header = """<select name="domain_root_url"
onChange="submitAction(this.form,'%s/portal_selections/setDomainRoot')">
        %s</select>""" % (here.getUrl(),select_tree_options)

          try:
1898
            select_tree_body = makeTreeBody(form, None, selection_domain_path,
1899
                 0, None, selection_domain_current, form.id, selection_name)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937
          except KeyError:
            select_tree_body = ''

          select_tree_html = """<!-- Select Tree -->
%s
<table cellpadding="0" border="0">
%s
</table>
"""  % (select_tree_header, select_tree_body )

          return """<!-- Table Wrapping for Select Tree -->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td valign="top">""" + """
%s
</td><td valign="top">
%s
<!-- End of Table Wrapping for Select Tree -->
</td></tr>
</table>""" % (select_tree_html,list_html)

        return list_html

ListBoxWidgetInstance = ListBoxWidget()

class ListBoxValidator(Validator.Validator):
    property_names = Validator.Validator.property_names

    def validate(self, field, key, REQUEST):
        form = field.aq_parent
        # We need to know where we get the getter from
        # This is coppied from ERP5 Form
        here = getattr(form, 'aq_parent', REQUEST)
        columns = field.get_value('columns')
        editable_columns = field.get_value('editable_columns')
        all_editable_columns = field.get_value('all_editable_columns')
        column_ids = map(lambda x: x[0], columns)
        editable_column_ids = map(lambda x: x[0], editable_columns)
        all_editable_column_ids = map(lambda x: x[0], all_editable_columns)
1938
        selection_name = field.get_value('selection_name')
1939
        #LOG('ListBoxValidator', 0, 'field = %s, selection_name = %s' % (repr(field), repr(selection_name)))
1940
        selection = here.portal_selections.getSelectionFor(selection_name, REQUEST=REQUEST)
1941
        params = selection.getParams()
1942 1943
        portal_url = getToolByName(here, 'portal_url')
        portal = portal_url.getPortalObject()
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1944 1945

        result = {}
1946
        error_result = {}
Jean-Paul Smets's avatar
Jean-Paul Smets committed
1947
        listbox_uids = REQUEST.get('%s_uid' % field.id, [])
1948
        #LOG('ListBox.validate: REQUEST',0,REQUEST)
Sebastien Robin's avatar
Sebastien Robin committed
1949
        errors = []
1950 1951 1952 1953 1954 1955 1956 1957 1958 1959
        object_list = []
        # We have two things to do in the case of temp objects,
        # the first thing is to create a list with new temp objects
        # then try to validate some data, and then create again
        # the list with a listbox as parameter. Like this we
        # can use tales expression
        for uid in listbox_uids:
          if str(uid).find('new') == 0:
            list_method = field.get_value('list_method')
            list_method = getattr(here, list_method.method_name)
1960
            #LOG('ListBoxValidator', 0, 'call %s' % repr(list_method))
1961
            object_list = list_method(REQUEST=REQUEST, **params)
1962 1963 1964 1965 1966 1967 1968 1969
            break
        listbox = {}
        for uid in listbox_uids:
          if str(uid).find('new') == 0:
            o = None
            for object in object_list:
              if object.getUid()==uid:
                o = object
1970 1971 1972 1973
            if o is None:
              # First case: dialog input to create new objects
              o = newTempBase(portal, uid[4:]) # Arghhh - XXX acquisition problem - use portal root
              o.uid = uid
1974
            listbox[uid[4:]] = {}
1975 1976
            # We first try to set a listbox corresponding to all things
            # we can validate, so that we can use the same list
1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001
            # as the one used for displaying the listbox
            for sql in editable_column_ids:
              alias = '_'.join(sql.split('.'))
              if '.' in sql:
                property_id = '.'.join(sql.split('.')[1:]) # Only take trailing part
              else:
                property_id = alias
              my_field_id = '%s_%s' % (field.id, alias)
              if form.has_field( my_field_id ):
                my_field = form.get_field(my_field_id)
                key = 'field_' + my_field.id + '_%s' % o.uid
                error_result_key = my_field.id + '_%s' % o.uid
                REQUEST.cell = o
                try:
                  value = my_field.validator.validate(my_field, key, REQUEST) # We need cell
                  # Here we set the property
                  listbox[uid[4:]][sql] = value
                except ValidationError, err: # XXXX import missing
                  pass
        # Here we generate again the object_list with listbox the listbox we
        # have just created
        if len(listbox)>0:
          list_method = field.get_value('list_method')
          list_method = getattr(here, list_method.method_name)
          REQUEST.set('listbox',listbox)
2002
          object_list = list_method(REQUEST=REQUEST,**params)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
2003
        for uid in listbox_uids:
2004 2005
          if str(uid).find('new') == 0:
            # First case: dialog input to create new objects
2006 2007 2008 2009 2010 2011
            #o = newTempBase(here, uid[4:]) # Arghhh - XXX acquisition problem - use portal root
            #o.uid = uid
            o = None
            for object in object_list:
              if object.getUid()==uid:
                o = object
2012 2013 2014 2015
            if o is None:
              # First case: dialog input to create new objects
              o = newTempBase(portal, uid[4:]) # Arghhh - XXX acquisition problem - use portal root
              o.uid = uid
2016
            result[uid[4:]] = {}
2017 2018 2019 2020 2021 2022 2023
            for sql in editable_column_ids:
              alias = '_'.join(sql.split('.'))
              if '.' in sql:
                property_id = '.'.join(sql.split('.')[1:]) # Only take trailing part
              else:
                property_id = alias
              my_field_id = '%s_%s' % (field.id, alias)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
2024 2025
              if form.has_field( my_field_id ):
                my_field = form.get_field(my_field_id)
2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
                if my_field.get_value('editable') and field.need_validate(REQUEST):
                  key = 'field_' + my_field.id + '_%s' % o.uid
                  error_result_key = my_field.id + '_%s' % o.uid
                  REQUEST.cell = o
                  try:
                    value = my_field.validator.validate(my_field, key, REQUEST) # We need cell
                    result[uid[4:]][sql] = value
                  except ValidationError, err: 
                    #LOG("ListBox ValidationError",0,str(err))
                    err.field_id = error_result_key
                    errors.append(err)
2037 2038
          else:
            # Second case: modification of existing objects
2039 2040
            #try:
            if 1: #try:
2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052
              # We must try this
              # because sometimes, we can be provided bad uids
              o = here.portal_catalog.getObject(uid)
              for sql in editable_column_ids:
                alias = '_'.join(sql.split('.'))
                if '.' in sql:
                  property_id = '.'.join(sql.split('.')[1:]) # Only take trailing part
                else:
                  property_id = alias
                my_field_id = '%s_%s' % (field.id, alias)
                if form.has_field( my_field_id ):
                  my_field = form.get_field(my_field_id)
2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067
                  if my_field.get_value('editable') and field.need_validate(REQUEST):
                    tales_expr = my_field.tales.get('default', "")
                    key = 'field_' + my_field.id + '_%s' % o.uid
                    error_result_key = my_field.id + '_%s' % o.uid
                    REQUEST.cell = o # We need cell
                    try:                    
                      value = my_field.validator.validate(my_field, key, REQUEST) # We need cell
                      error_result[error_result_key] = value
                      if not result.has_key(o.getUrl()):
                        result[o.getUrl()] = {} 
                      result[o.getUrl()][sql] = value
                    except ValidationError, err: 
                      #LOG("ListBox ValidationError",0,str(err))
                      err.field_id = error_result_key
                      errors.append(err)
2068 2069
            #except:
            else:
2070
              LOG("ListBox WARNING",0,"Object uid %s could not be validated" % uid)
2071
        if len(errors) > 0:
2072 2073
            LOG("ListBox FormValidationError",0,str(error_result))
            LOG("ListBox FormValidationError",0,str(errors))
2074
            raise FormValidationError(errors, error_result)
Jean-Paul Smets's avatar
Jean-Paul Smets committed
2075 2076 2077 2078 2079 2080 2081 2082 2083 2084
        return result

ListBoxValidatorInstance = ListBoxValidator()

class ListBox(ZMIField):
    meta_type = "ListBox"

    widget = ListBoxWidgetInstance
    validator = ListBoxValidatorInstance

2085
    security = ClassSecurityInfo()
Yoshinori Okuji's avatar
Yoshinori Okuji committed
2086

2087 2088 2089
    security.declareProtected('Access contents information', 'get_value')
    def get_value(self, id, **kw):
      if id == 'default' and kw.get('render_format') in ('list', ):
2090
        return self.widget.render(self, self.generate_field_key() , None , kw.get('REQUEST'), render_format=kw.get('render_format'))
2091
      else:
2092
        return ZMIField.get_value(self, id, **kw)
Yoshinori Okuji's avatar
Yoshinori Okuji committed
2093

2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142 2143 2144


class ListBoxLine:
  meta_type = "ListBoxLine"
  security = ClassSecurityInfo()
  #security.declareObjectPublic()

  def __init__(self):
    """
      Initialize the line and set the default values
      Selected columns must be defined in parameter of listbox.render...
    """
    
    self.is_title_line = 0
    self.is_data_line = 1
    self.is_stat_line = 0
    self.is_summary_line = 0

    self.is_section_folded = 1

    self.config_dict = {
      'is_checked' : 0,
      'uid' : None,
      'section_name' : None,
      'section_depth' : 0,
      'content_mode' : 'DataLine'
    }
    self.config_display_list = []

    self.column_dict = {}
    self.column_id_list = []
    
  security.declarePublic('__getitem__')
  def __getitem__(self, column_id):
    return getColumnProperty(self, column_id)

  #security.declarePublic('View')
  def setConfigProperty(self, config_id, config_value):
    self.config_dict[config_id] = config_value

  #security.declarePublic('View')
  def getConfigProperty(self, config_id):
    return self.config_dict[config_id]

  #security.declarePublic('View')
  def setListboxLineContentMode(self, content_mode):
    """
      Toogle the content type of the line
      content_mode can be 'TitleLine' 'StatLine' 'DataLine'
      Default value is 'DataLine'
    """
2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155
    content_mode_dict = {
      'TitleLine':(1,0,0,0),
      'DataLine':(0,1,0,0),
      'StatLine':(0,0,1,0),
      'SummaryLine':(0,0,0,1)
    }
    self.is_title_line,\
    self.is_data_line,\
    self.is_stat_line,\
    self.is_summary_line = content_mode_dict[content_mode]

2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178
    self.setConfigProperty('content_mode',content_mode)

  #security.declarePublic('View')
  def markTitleLine(self):
    """
      Set content of the line to 'TitleLine'
    """
    self.setListboxLineContentMode('TitleLine')

  security.declarePublic('isTitleLine')
  def isTitleLine(self):
    """
      Returns 1 is this line contains no data but only title of columns
    """
    return self.is_title_line

  #security.declarePublic('View')
  def markStatLine(self):
    """
      Set content of the line to 'StatLine'
    """
    self.setListboxLineContentMode('StatLine')
    
2179 2180
  security.declarePublic('isStatLine')
  def isStatLine(self):
2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356
    """
      Returns 1 is this line contains no data but only stats
    """
    return self.is_stat_line
    
  #security.declarePublic('View')
  def markDataLine(self):
    """
      Set content of the line to 'DataLine'
    """
    self.setListboxLineContentMode('DataLine')
  
  security.declarePublic('isDataLine')
  def isDataLine(self):
    """
      Returns 1 is this line contains data
    """
    return self.is_data_line

  #security.declarePublic('View')
  def markSummaryLine(self):
    """
      Set content of the line to 'SummaryLine'
    """
    self.setListboxLineContentMode('SummaryLine')

  security.declarePublic('isSummaryLine')
  def isSummaryLine(self):
    """
      Returns 1 is this line is a summary line
    """
    return self.is_summary_line

  #security.declarePublic('View')
  def checkLine(self, is_checked):
    """
      Set line to checked if is_checked=1
      Default value is 0
    """
    self.setConfigProperty('is_checked',is_checked)

  security.declarePublic('isLineChecked')
  def isLineChecked(self):
    """
      Returns 1 is this line is checked
    """
    return self.getConfigProperty('is_checked')
  
  #security.declarePublic('View')
  def setObjectUid(self, object_uid):
    """
      Define the uid of the object
      Default value is None
    """
    self.setConfigProperty('uid',object_uid)

  security.declarePublic('getObjectUid')
  def getObjectUid(self):
    """
      Get the uid of the object related to the line
    """
    return self.getConfigProperty('uid')
    
  #security.declarePublic('View')
  def setSectionName(self, section_name):
    """
      Set the section name of this line
      Default value is None
    """
    self.setConfigProperty('section_name',section_name)

  security.declarePublic('getSectionName')
  def getSectionName(self):
    """
      Returns the section name of this line
      Default value is None
    """
    return self.getConfigProperty('section_name')

  #security.declarePublic('View')
  def setSectionDepth(self, depth):
    """
      Set the section depth of this line
      default value is 0 and means no depth
    """
    self.setConfigProperty('section_depth',depth)
    
  security.declarePublic('getSectionDepth')
  def getSectionDepth(self):
    """
      Returns the section depth of this line
      0 means no depth
    """
    return self.getConfigProperty('section_depth')
    
  #security.declarePublic('View')
  def setSectionFolded(self, is_section_folded):
    """
      Set the section mode of this line to 'Folded' if is_section_folded=1
    """
    self.is_section_folded = is_section_folded
    
    
  security.declarePublic('isSectionFolded')
  def isSectionFolded(self):
    """
      Returns 1 if section is in 'Folded' Mode
    """
    return self.is_section_folded 
    
  #security.declarePublic('View')
  def addColumn(self, column_id, column_value):
    """
      Add a new column 
    """
    self.column_dict[column_id] = column_value
    self.column_id_list.append(column_id)

  security.declarePublic('getColumnProperty')
  def getColumnProperty(self, column_id):
    """
      Returns the property of a column
    """
    return self.column_dict[column_id]


  security.declarePublic('getColumnPropertyList')
  def getColumnPropertyList(self, column_id_list = None):
    """
      Returns a list of the property 
      column_id_list selects the column_id returned
    """
    
    if column_id_list == None:
      column_id_list = self.column_id_list
      
    if self.isTitleLine():
      config_column = [None] * len(self.config_display_list)
    else:
      config_column = [self.config_dict[column_id] for column_id in self.config_display_list]
      
      
    return config_column + [self.column_dict[column_id] for column_id in column_id_list]

  security.declarePublic('getColumnItemList')
  def getColumnItemList(self, column_id_list = None ):
    """
      Returns a list of property tuple
      column_id_list selects the column_id returned
    """
    
    if column_id_list == None:
      column_id_list = self.column_id_list
      
    """
    if self.isTitleLine():
      config_column = [None] * len(self.config_display_list)
    else:
      config_column = [(config_id, self.config_dict[column_id]) for config_id in self.config_display_list]
    """
    config_column = [(config_id, self.config_dict[config_id]) for config_id in self.config_display_list]
      
    return config_column + [(column_id , self.column_dict[column_id]) for column_id in column_id_list]
  
  security.declarePublic('setListboxLineDisplayListMode')
  def setListboxLineDisplayListMode(self, display_list):
    """
      Set the config columns displayable
      display_list can content the key of self.config_dict
      Default value of display_list is []
    """
    self.config_display_list = display_list
  
InitializeClass(ListBoxLine)
allow_class(ListBoxLine)

Jean-Paul Smets's avatar
Jean-Paul Smets committed
2357 2358 2359 2360 2361 2362
# Psyco
import psyco
psyco.bind(ListBoxWidget.render)
psyco.bind(ListBoxValidator.validate)