pax_global_header 0000666 0000000 0000000 00000000064 12015425354 0014513 g ustar 00root root 0000000 0000000 52 comment=c44db1eac1e1a284e4bbc4f89909b49a4b53e330
erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/ 0000775 0000000 0000000 00000000000 12015425354 0023674 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/ 0000775 0000000 0000000 00000000000 12015425354 0024366 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/ 0000775 0000000 0000000 00000000000 12015425354 0030056 5 ustar 00root root 0000000 0000000 PathTemplateItem/ 0000775 0000000 0000000 00000000000 12015425354 0033206 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql portal_alarms/ 0000775 0000000 0000000 00000000000 12015425354 0036046 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/PathTemplateItem worklist_refresh.xml 0000664 0000000 0000000 00000005064 12015425354 0042171 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/PathTemplateItem/portal_alarms
-
active_sense_method_id
Base_refreshWorklistTableContent
-
description
-
enabled
1
-
id
worklist_refresh
-
periodicity_hour
-
periodicity_minute
-
periodicity_minute_frequency
5
-
periodicity_month
-
periodicity_month_day
-
periodicity_start_date
-
periodicity_week
-
portal_type
Alarm
-
title
Refresh worklist table content
SkinTemplateItem/ 0000775 0000000 0000000 00000000000 12015425354 0033216 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql portal_skins/ 0000775 0000000 0000000 00000000000 12015425354 0035726 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem erp5_worklist_sql.xml 0000664 0000000 0000000 00000001211 12015425354 0042133 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins
-
_objects
-
id
erp5_worklist_sql
-
title
erp5_worklist_sql/ 0000775 0000000 0000000 00000000000 12015425354 0041416 5 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins Base_getCountFromWorklistTable.xml 0000664 0000000 0000000 00000005403 12015425354 0050217 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
Script_magic
3
-
_bind_names
-
_body
# Wrapper for Base_zGetCountFromWorklistTable\n
\n
where_expression = context.getPortalObject().portal_catalog.buildSQLQuery(query=query, query_table=None)[\'where_expression\']\n
\n
return context.Base_zGetCountFromWorklistTable(\n
where_expression=where_expression,\n
select_expression=select_expression,\n
group_by_expression=group_by_expression,\n
**kw)\n
-
_params
query, select_expression, group_by_expression, **kw
-
id
Base_getCountFromWorklistTable
Base_getWorklistTableColumnIDList.xml 0000664 0000000 0000000 00000005534 12015425354 0050616 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
Script_magic
3
-
_bind_names
-
_body
return [\n
\'security_uid\', \'simulation_state\',\n
\'validation_state\', \'portal_type\', \'owner\', \'viewable_owner\', \'parent_uid\',\n
\'title\',\'opportunity_state\', \'causality_state\', \'invoice_state\',\n
\'payment_state\', \'event_state\', \'immobilisation_state\', \'reference\',\n
\'grouping_reference\', \'source_reference\', \'destination_reference\',\n
\'string_index\', \'int_index\', \'float_index\', \'has_cell_content\',\n
\'creation_date\', \'modification_date\'\n
]\n
-
_params
-
id
Base_getWorklistTableColumnIDList
Base_refreshWorklistTableContent.xml 0000664 0000000 0000000 00000004645 12015425354 0050603 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
Script_magic
3
-
_bind_names
-
_body
context.getPortalObject().portal_workflow.refreshWorklistCache()\n
-
_params
-
id
Base_refreshWorklistTableContent
Base_zClearWorklistTable.xml 0000664 0000000 0000000 00000001676 12015425354 0047033 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
Base_zClearWorklistTable
-
src
DELETE FROM worklist_cache
-
title
Base_zCreateWorklistTable.xml 0000664 0000000 0000000 00000005111 12015425354 0047174 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
_col
-
arguments_src
-
connection_id
erp5_sql_connection
-
id
Base_zCreateWorklistTable
-
src
\n
CREATE TABLE `worklist_cache` (\n
`count` INT UNSIGNED NOT NULL,\n
`owner` VARCHAR(32) DEFAULT \'\',\n
`viewable_owner` VARCHAR(32) NOT NULL DEFAULT \'\',\n
`security_uid` INT UNSIGNED NOT NULL,\n
`portal_type` VARCHAR(255) NOT NULL,\n
`validation_state` VARCHAR(255) NULL,\n
`simulation_state` VARCHAR(255) NULL,\n
`parent_uid` BIGINT UNSIGNED default \'0\',\n
`title` varchar(255) default \'\',\n
`opportunity_state` varchar(255) default \'\',\n
`causality_state` varchar(255) default \'\',\n
`invoice_state` varchar(255) default \'\',\n
`payment_state` varchar(255) default \'\',\n
`event_state` varchar(255) default \'\',\n
`immobilisation_state` varchar(255) default \'\',\n
`reference` varchar(255) binary default \'\',\n
`grouping_reference` varchar(255) default \'\',\n
`source_reference` varchar(255) default \'\',\n
`destination_reference` varchar(255) default \'\',\n
`string_index` varchar(255),\n
`int_index` INT,\n
`float_index` real,\n
`has_cell_content` bool,\n
`creation_date` datetime,\n
`modification_date` datetime,\n
KEY `portal_simulation_security` (`portal_type`, `simulation_state`, `security_uid`),\n
KEY `portal_simulation_owner` (`portal_type`, `simulation_state`, `viewable_owner`),\n
KEY `portal_validation_security` (`portal_type`, `validation_state`, `security_uid`),\n
KEY `portal_validation_owner` (`portal_type`, `validation_state`, `viewable_owner`)\n
) ENGINE=InnoDB
]]>
-
title
Base_zGetCountFromWorklistTable.xml 0000664 0000000 0000000 00000005350 12015425354 0050352 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
_Use_Database_Methods_Permission
Anonymous
Assignee
Assignor
Associate
Auditor
Authenticated
Author
Manager
Member
Owner
Reviewer
-
allow_simple_one_argument_traversal
-
arguments_src
select_expression\r\n
where_expression\r\n
group_by_expression
-
cache_time_
0
-
class_file_
-
class_name_
-
connection_hook
-
connection_id
erp5_sql_connection
-
id
Base_zGetCountFromWorklistTable
-
max_cache_
100
-
max_rows_
0
-
src
\n
FROM\n
worklist_cache\n
WHERE\n
\n
GROUP BY\n
\n
]]>
-
title
Base_zInsertIntoWorklistTable.xml 0000664 0000000 0000000 00000007370 12015425354 0050100 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/SkinTemplateItem/portal_skins/erp5_worklist_sql
-
arguments_src
count\r\n
security_uid\r\n
portal_type\r\n
simulation_state\r\n
validation_state\r\n
owner\r\n
viewable_owner\r\n
parent_uid\r\n
title\r\n
opportunity_state\r\n
causality_state\r\n
invoice_state\r\n
payment_state\r\n
event_state\r\n
immobilisation_state\r\n
reference\r\n
grouping_reference\r\n
source_reference\r\n
destination_reference\r\n
string_index\r\n
int_index\r\n
float_index\r\n
has_cell_content\r\n
creation_date\r\n
modification_date
-
connection_id
erp5_sql_connection
-
id
Base_zInsertIntoWorklistTable
-
src
\n
(\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
,\n
\n
)\n
,\n
]]>
-
title
erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt/ 0000775 0000000 0000000 00000000000 12015425354 0030463 5 ustar 00root root 0000000 0000000 change_log 0000664 0000000 0000000 00000000204 12015425354 0032411 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt 2008-12-15 romain
* Add Base_getWorklistTableColumnIDList
2008-01-11 aurel
* include most of the column of the catalog in sql table erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt/comment0000664 0000000 0000000 00000000201 12015425354 0032041 0 ustar 00root root 0000000 0000000 Depends on erp5_mysql_innodb_catalog version gein at least 1.1 (inclued) because it relies on the presence of the "owner" column. copyright_list 0000664 0000000 0000000 00000000036 12015425354 0033371 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt Copyright (c) 2007 Nexedi SARL dependency_list 0000664 0000000 0000000 00000000042 12015425354 0033474 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt erp5_mysql_innodb_catalog (>= 1.1) description 0000664 0000000 0000000 00000000250 12015425354 0032647 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt SQL-based caching system for worklists.
This allows to cache object count into a SQL table, reducing greatly the amount of work needed for every worklist generation. erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt/license0000664 0000000 0000000 00000000003 12015425354 0032021 0 ustar 00root root 0000000 0000000 GPL maintainer_list 0000664 0000000 0000000 00000000007 12015425354 0033506 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt vincent revision 0000664 0000000 0000000 00000000002 12015425354 0032155 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt 38 template_format_version 0000664 0000000 0000000 00000000001 12015425354 0035246 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt 1 template_path_list 0000664 0000000 0000000 00000000036 12015425354 0034210 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt portal_alarms/worklist_refresh template_skin_id_list 0000664 0000000 0000000 00000000021 12015425354 0034666 0 ustar 00root root 0000000 0000000 erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt erp5_worklist_sql erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt/title 0000664 0000000 0000000 00000000021 12015425354 0031520 0 ustar 00root root 0000000 0000000 erp5_worklist_sql erp5-c44db1eac1e1a284e4bbc4f89909b49a4b53e330-bt5-erp5_worklist_sql/bt5/erp5_worklist_sql/bt/version0000664 0000000 0000000 00000000005 12015425354 0032066 0 ustar 00root root 0000000 0000000 5.4.7