Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,28 @@ + + + + + + + select count(*) + from wf_arcs + where workflow_key = :workflow_key + and transition_key = :transition_key + and place_key = :place_key + and direction = :direction + + + + + + + + + insert into wf_arcs (workflow_key, transition_key, place_key, direction) + values (:workflow_key, :transition_key, :place_key, :direction) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + + delete from wf_arcs + where workflow_key = :workflow_key + and transition_key = :transition_key + and place_key = :place_key + and direction = :direction + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,20 @@ + + + + + + + update wf_arcs + set guard_callback = :guard_callback, + guard_custom_arg = :guard_custom_arg, + guard_description = :guard_description + where workflow_key = :workflow_key + and transition_key = :transition_key + and place_key = :place_key + and direction = :direction + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,46 @@ + + + + + + + select a.guard_callback, + a.guard_custom_arg, + a.guard_description + from wf_arcs a + where a.workflow_key = :workflow_key + and a.transition_key = :transition_key + and a.place_key = :place_key + and a.direction = :direction + + + + + + + + + select a0.package_name || '.' || a0.object_name + from user_arguments a0 + where position = 0 + and argument_name is null + and data_type = 'CHAR' + and in_out = 'OUT' + and exists (select 1 from user_arguments a1 where a1.package_name=a0.package_name and a1.object_name=a0.object_name + and a1.position=1 and a1.data_type='NUMBER' and a1.in_out='IN') + and exists (select 1 from user_arguments a2 where a2.package_name=a0.package_name and a2.object_name=a0.object_name + and a2.position=2 and a2.data_type='VARCHAR2' and a2.in_out='IN') + and exists (select 1 from user_arguments a3 where a3.package_name=a0.package_name and a3.object_name=a0.object_name + and a3.position=3 and a3.data_type='VARCHAR2' and a3.in_out='IN') + and exists (select 1 from user_arguments a4 where a4.package_name=a0.package_name and a4.object_name=a0.object_name + and a4.position=4 and a4.data_type='VARCHAR2' and a4.in_out='IN') + and exists (select 1 from user_arguments a5 where a5.package_name=a0.package_name and a5.object_name=a0.object_name + and a5.position=5 and a5.data_type='VARCHAR2' and a5.in_out='IN') + and exists (select 1 from user_arguments a6 where a6.package_name=a0.package_name and a6.object_name=a0.object_name + and a6.position=6 and a6.data_type='VARCHAR2' and a6.in_out='IN') + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,24 @@ + + + oracle8.1.6 + + + + + declare + v_attribute_id integer; + begin + v_attribute_id := workflow.create_attribute( + workflow_key => :workflow_key, + attribute_name => :attribute_name, + datatype => :datatype, + pretty_name => :pretty_name, + default_value => :default_value + ); + end; + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add-2-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,28 @@ + + + postgresql7.1 + + + + + select workflow__create_attribute( + :workflow_key, + :attribute_name, + :datatype, + :pretty_name, + null, + null, + null, + :default_value, + 1, + 1, + null, + 'generic', + 'none' + ) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,26 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + + + + select datatype + from acs_datatypes + order by datatype + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,19 @@ + + + oracle8.1.6 + + + + + begin + workflow.drop_attribute( + workflow_key => :workflow_key, + attribute_name => :attribute_name + ); + end; + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,17 @@ + + + postgresql7.1 + + + + + select workflow__drop_attribute( + :workflow_key, + :attribute_name + ); + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attribute-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,29 @@ + + + + + + + delete from wf_transition_attribute_map + where workflow_key = :workflow_key + and attribute_id = :attribute_id + + + + + + + + + begin + workflow.drop_attribute( + workflow_key => :workflow_key, + attribute_name => :attribute_name + ); + end; + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attributes.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attributes.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/attributes.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,44 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + + + + select a.attribute_id, + a.sort_order, + a.attribute_name, + a.pretty_name, + a.datatype, + '' as delete_url, + (select count(*) from wf_transition_attribute_map m + where m.workflow_key = a.object_type + and m.attribute_id = a.attribute_id) as used_p + from acs_attributes a + where a.object_type = :workflow_key + order by sort_order + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,25 @@ + + + oracle8.1.6 + + + + + select case_id, acs_object.name(object_id) as object_name, state as state from wf_cases where case_id = :case_id + + + + + + + + + select a.attribute_name as name, acs_object.get_attribute(c.case_id, a.attribute_name) as value + from acs_attributes a, wf_cases c + where a.object_type = c.workflow_key + and c.case_id = :case_id + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,25 @@ + + + postgresql7.1 + + + + + select case_id, acs_object__name(object_id) as object_name, state as state from wf_cases where case_id = :case_id + + + + + + + + + select a.attribute_name as name, acs_object__get_attribute(c.case_id, a.attribute_name) as value + from acs_attributes a, wf_cases c + where a.object_type = c.workflow_key + and c.case_id = :case_id + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,55 @@ + + + + + + + select task_id, transition_key, state, case_id + from wf_tasks + where case_id = :case_id + order by case when state = 'started' then 1 when state = 'enabled' then 2 when state = 'finished' then 3 else 4 end + + + + + + + + + select token_id, place_key, case_id, state, locked_task_id + from wf_tokens + where case_id = :case_id + and state in ('free', 'locked') + + + + + + + + + select token_id, place_key, case_id, state, locked_task_id, + to_char(produced_date, 'YYYY-MM-DD HH24:MI:SS') as produced_date_pretty, + to_char(locked_date, 'YYYY-MM-DD HH24:MI:SS') as locked_date_pretty, + to_char(consumed_date, 'YYYY-MM-DD HH24:MI:SS') as consumed_date_pretty, + to_char(canceled_date, 'YYYY-MM-DD HH24:MI:SS') as canceled_date_pretty + from wf_tokens + where case_id = :case_id + and state in ('consumed', 'canceled') + + + + + + + + + select case_id, transition_key, transition_name, trigger_type + from wf_enabled_transitions + where case_id = :case_id + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/cases.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/cases.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/cases.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,48 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select pretty_name as workflow_name + from acs_object_types + where object_type = :workflow_key + + + + + + + + + select transition_key, transition_name + from wf_transitions + where workflow_key = :workflow_key + order by transition_name + + + + + + + + + select place_key, place_name + from wf_places + where workflow_key = :workflow_key + order by place_name + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/context-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/context-add-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/context-add-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,14 @@ + + + + + + + insert into wf_contexts (context_key, context_name) + values (:context_key, :context_name) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/define.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/define.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/define.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + select count(*) from wf_workflows where workflow_key = :workflow_key + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + + oracle8.1.6 + + + + select package_id from apm_packages where package_key='acs-workflow' and rownum=1 + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,15 @@ + + + + postgresql7.1 + + + + + select package_id from apm_packages where package_key='acs-workflow' limit 1 + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/export.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,26 @@ + + + oracle8.1.6 + + + + + select w.workflow_key, + t.pretty_name, + w.description, + count(c.case_id) as num_cases, + 0 as num_unassigned_tasks + from wf_workflows w, + acs_object_types t, + wf_cases c + where w.workflow_key = t.object_type + and c.workflow_key (+) = w.workflow_key + and c.state (+) = 'active' + group by w.workflow_key, t.pretty_name, w.description + order by t.pretty_name + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/index.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,38 @@ + + + + + + + select w.workflow_key, + t.pretty_name, + w.description, + count(c.case_id) as num_cases, + 0 as num_unassigned_tasks + from wf_workflows w left outer join wf_cases c + on (w.workflow_key = c.workflow_key and c.state = 'active'), + acs_object_types t, + where w.workflow_key = t.object_type + group by w.workflow_key, t.pretty_name, w.description + order by t.pretty_name + + + + + + + + + select count(*) + from wf_tasks t, wf_cases c + where t.workflow_key = :workflow_key + and t.state = 'enabled' + and c.case_id = t.case_id + and c.state = 'active' + and not exists (select 1 from wf_task_assignments ta where ta.task_id = t.task_id) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + oracle8.1.6 + + + + + select object_id, acs_object.name(object_id) as name from acs_objects order by name + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + postgresql7.1 + + + + + select object_id, acs_object__name(object_id) as name from acs_objects order by name + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/init.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,31 @@ + + + + + + + select context_key, context_name, '' as selected + from wf_contexts + order by context_name + + + + + + + + + select object_id, acs_object.name(object_id) as name from acs_objects order by name + + + + + + + + select pretty_name from acs_object_types where object_type = :workflow_key + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,27 @@ + + + + + + + update acs_object_types + set pretty_name = :workflow_name, + pretty_plural = :workflow_name + where object_type = :workflow_key + + + + + + + + + update wf_workflows + set description = :description + where workflow_key = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/name-edit.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + select ot.pretty_name as workflow_name, w.description + from acs_object_types ot, wf_workflows w + where ot.object_type = w.workflow_key + and w.workflow_key = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,45 @@ + + + + + + + select count(*) + from wf_places + where workflow_key = :workflow_key + and place_name = :place_name + + + + + + + + + select count(*) + from wf_places + where workflow_key = :workflow_key + and place_name = :place_name + + + + + + + + select place_key from wf_places where workflow_key = :workflow_key + + + + + + + + insert into wf_places (place_key, place_name, workflow_key) + values (:place_key, :place_name, :workflow_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,37 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + + + + select case when count(*) = 0 then 0 else 1 end from wf_places + where workflow_key = :workflow_key + and place_key = 'start' + + + + + + + + + select case when count(*) = 0 then 0 else 1 end from wf_places + where workflow_key = :workflow_key + and place_key = 'start' + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,26 @@ + + + + + + + delete from wf_arcs + where workflow_key = :workflow_key + and place_key = :place_key + + + + + + + + + delete from wf_places + where workflow_key = :workflow_key + and place_key = :place_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + update wf_places + set place_name = :place_name + where workflow_key = :workflow_key + and place_key = :place_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/place-edit.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,18 @@ + + + + + + + select p.place_name, + ot.pretty_name as workflow_name + from wf_places p, acs_object_types ot + where p.place_key = :place_key + and p.workflow_key = :workflow_key + and ot.object_type = p.workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + insert into wf_context_assignments + (workflow_key, context_key, transition_key, party_id) + values + (:workflow_key, :context_key, :transition_key, :party_id) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignment-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,18 @@ + + + + + + + delete + from wf_context_assignments + where workflow_key = :workflow_key + and context_key = :context_key + and transition_key = :transition_key + and party_id = :party_id + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,34 @@ + + + oracle8.1.6 + + + + + select tr.transition_key, + tr.transition_name, + p.party_id, + acs_object.name(p.party_id) as party_name, + p.email as party_email, + '' as user_select_widget + from wf_transition_info tr, + wf_context_assignments ca, + parties p + where tr.workflow_key = :workflow_key + and tr.context_key = :context_key + and tr.trigger_type = 'user' + and tr.assignment_callback is null + and ca.context_key (+) = tr.context_key + and ca.transition_key (+) = tr.transition_key + and p.party_id (+) = ca.party_id + and not exists + (select 1 + from wf_transition_assignment_map + where workflow_key = tr.workflow_key + and assign_transition_key = tr.transition_key) + order by tr.sort_order, tr.transition_key + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,83 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select pretty_name as workflow_name + from acs_object_types + where object_type = :workflow_key + + + + + + + + + select context_key as context_key_from_db, + context_name as title, + '' as url, + 0 as selected_p + from wf_contexts + order by context_name + + + + + + + + + select tr.transition_key, + tr.transition_name, + p.party_id, + acs_object.name(p.party_id) as party_name, + p.email as party_email, + '' as user_select_widget + from wf_transition_info tr left outer join + (wf_context_assignments ca left outer join parties p + using (party_id)) using (context_key, transition_key) + where tr.workflow_key = :workflow_key + and tr.context_key = :context_key + and tr.trigger_type = 'user' + and tr.assignment_callback is null + and not exists + (select 1 + from wf_transition_assignment_map + where workflow_key = tr.workflow_key + and assign_transition_key = tr.transition_key) + order by tr.sort_order, tr.transition_key + + + + + + + + + select p.party_id as sel_party_id, + acs_object.name(p.party_id) as sel_name, + p.email as sel_email + from parties p + where p.party_id not in + (select ca.party_id + from wf_context_assignments ca + where ca.workflow_key = :workflow_key + and ca.context_key = :context_key + and ca.transition_key = :transition_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,93 @@ + + + + + + + select count(*) from wf_context_transition_info where workflow_key = :workflow_key and transition_key = :transition_key and context_key = :context_key + + + + + + + + + insert into wf_context_transition_info + (workflow_key, + transition_key, + context_key, + enable_callback, + enable_custom_arg, + fire_callback, + fire_custom_arg, + assignment_callback, + assignment_custom_arg, + time_callback, + time_custom_arg, + deadline_callback, + deadline_custom_arg, + deadline_attribute_name, + hold_timeout_callback, + hold_timeout_custom_arg, + notification_callback, + notification_custom_arg, + unassigned_callback, + unassigned_custom_arg, + access_privilege) + values + (:workflow_key, + :transition_key, + :context_key, + :enable_callback, + :enable_custom_arg, + :fire_callback, + :fire_custom_arg, + :assignment_callback, + :assignment_custom_arg, + :time_callback, + :time_custom_arg, + :deadline_callback, + :deadline_custom_arg, + :deadline_attribute_name, + :hold_timeout_callback, + :hold_timeout_custom_arg, + :notification_callback, + :notification_custom_arg, + :unassigned_callback, + :unassigned_custom_arg, + :access_privilege) + + + + + + + + + update wf_context_transition_info set + enable_callback = :enable_callback, + enable_custom_arg = :enable_custom_arg, + fire_callback = :fire_callback, + fire_custom_arg = :fire_custom_arg, + assignment_callback = :assignment_callback, + assignment_custom_arg = :assignment_custom_arg, + time_callback = :time_callback, + time_custom_arg = :time_custom_arg, + deadline_callback = :deadline_callback, + deadline_custom_arg = :deadline_custom_arg, + deadline_attribute_name = :deadline_attribute_name, + hold_timeout_callback = :hold_timeout_callback, + hold_timeout_custom_arg = :hold_timeout_custom_arg, + notification_callback = :notification_callback, + notification_custom_arg = :notification_custom_arg, + unassigned_callback = :unassigned_callback, + unassigned_custom_arg = :unassigned_custom_arg, + access_privilege = :access_privilege + where workflow_key = :workflow_key and transition_key = :transition_key and context_key = :context_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-actions.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,29 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,46 @@ + + + + + + + select count(*) + from wf_transitions + where workflow_key = :workflow_key + and transition_name = :transition_name + + + + + + + + + select transition_key from wf_transitions where workflow_key = :workflow_key + + + + + + + + + insert into wf_transitions (transition_key, transition_name, workflow_key, trigger_type) + values (:transition_key, :transition_name, :workflow_key, :trigger_type) + + + + + + + + + insert into wf_context_transition_info + (context_key, workflow_key, transition_key, estimated_minutes) + values (:context_key, :workflow_key, :transition_key, :estimated_minutes) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,21 @@ + + + + + + select count(*) from wf_transition_assignment_map where workflow_key = :workflow_key and transition_key = :transition_key and assign_transition_key = :assign_transition_key + + + + + + + + insert into wf_transition_assignment_map (workflow_key, transition_key, assign_transition_key) + values (:workflow_key, :transition_key, :assign_transition_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + delete from wf_transition_assignment_map + where workflow_key = :workflow_key + and transition_key = :transition_key + and assign_transition_key = :assign_transition_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-assignment.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,62 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + + + + select t.transition_name as assign_transition_name, + m.assign_transition_key, + '' as delete_url + from wf_transition_assignment_map m, + wf_transitions t + where m.workflow_key = :workflow_key + and m.transition_key = :transition_key + and t.workflow_key = m.workflow_key + and t.transition_key = m.assign_transition_key + + + + + + + + + select t.transition_name as assign_transition_name, + t.transition_key as assign_transition_key + from wf_transitions t + where t.workflow_key = :workflow_key + and t.transition_key != :transition_key + and not exists (select 1 from wf_transition_assignment_map m + where m.workflow_key = :workflow_key + and m.transition_key = :transition_key + and m.assign_transition_key = t.transition_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + + insert into wf_transition_attribute_map (workflow_key, transition_key, sort_order, attribute_id) + select :workflow_key, :transition_key, coalesce(max(sort_order)+1,1), :attribute_id + from wf_transition_attribute_map + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + delete from wf_transition_attribute_map + where workflow_key = :workflow_key + and transition_key = :transition_key + and attribute_id = :attribute_id + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-move-up.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-move-up.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attribute-move-up.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + + update wf_transition_attribute_map + set sort_order = case when sort_order = :sort_order then :prior_sort_order when sort_order = :prior_sort_order then :sort_order end + where workflow_key = :workflow_key + and transition_key = :transition_key + and sort_order in (:sort_order, :prior_sort_order) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attributes.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attributes.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-attributes.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,70 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + + + + select ta.sort_order, + a.attribute_id, + a.attribute_name, + a.pretty_name, + a.datatype, + '' as delete_url, + '' as move_up_url + from wf_transition_attribute_map ta, + acs_attributes a + where ta.workflow_key = :workflow_key + and ta.transition_key = :transition_key + and a.attribute_id = ta.attribute_id + order by sort_order + + + + + + + + + select a.attribute_id, + a.sort_order, + a.attribute_name, + a.pretty_name, + a.datatype + from acs_attributes a + where a.object_type = :workflow_key + and not exists (select 1 from wf_transition_attribute_map m + where m.workflow_key = :workflow_key + and m.transition_key = :transition_key + and m.attribute_id = a.attribute_id) + order by sort_order + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,70 @@ + + + + + + + delete from wf_arcs + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + + delete from wf_transition_attribute_map + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + + delete from wf_transition_assignment_map + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + + delete from wf_context_assignments + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + + delete from wf_context_transition_info + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + + delete from wf_transitions + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,45 @@ + + + + + + + update wf_transitions + set transition_name = :transition_name, + trigger_type = :trigger_type + where workflow_key = :workflow_key + and transition_key = :transition_key + + + + + + + + select count(*) from wf_context_transition_info where workflow_key = :workflow_key and transition_key = :transition_key and context_key = 'default' + + + + + + + + insert into wf_context_transition_info + (workflow_key, transition_key, context_key, estimated_minutes) + values (:workflow_key, :transition_key, 'default', :estimated_minutes) + + + + + + + + + update wf_context_transition_info set estimated_minutes = :estimated_minutes + where workflow_key = :workflow_key and transition_key = :transition_key and context_key = 'default' + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-edit.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,26 @@ + + + + + + + select t.transition_name, + ot.pretty_name as workflow_name, + t.trigger_type + from wf_transitions t, acs_object_types ot + where t.transition_key = :transition_key + and t.workflow_key = :workflow_key + and ot.object_type = t.workflow_key + + + + + + + + select estimated_minutes from wf_context_transition_info where workflow_key = :workflow_key and transition_key = :transition_key and context_key = 'default' + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,19 @@ + + + + + + + insert into wf_context_task_panels + (workflow_key, transition_key, context_key, sort_key, header, template_url) + select :workflow_key, :transition_key, :context_key, coalesce(max(sort_key)+1,1), :header, :template_url + from wf_context_task_panels + where workflow_key = :workflow_key + and transition_key = :transition_key + and context_key = :context_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-add.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,19 @@ + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + + delete from wf_context_task_panels + where workflow_key = :workflow_key + and transition_key = :transition_key + and context_key = :context_key + and sort_key = :sort_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,19 @@ + + + + + + + update wf_context_task_panels + set header = :header, + template_url = :template_url + where workflow_key = :workflow_key + and transition_key = :transition_key + and context_key = :context_key + and sort_key = :sort_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-edit.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,34 @@ + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + + + + select p.header, + p.template_url + from wf_context_task_panels p + where p.workflow_key = :workflow_key + and p.transition_key = :transition_key + and p.context_key = :context_key + and p.sort_key = :sort_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-move-up.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-move-up.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panel-move-up.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,32 @@ + + + + + + + select max(sort_key) + from wf_context_task_panels + where workflow_key = :workflow_key + and transition_key = :transition_key + and context_key = :context_key + and sort_key < :sort_key + + + + + + + + + update wf_context_task_panels + set sort_key = case when sort_key = :sort_key then :prior_sort_key when sort_key = :prior_sort_key then :sort_key end + where workflow_key = :workflow_key + and transition_key = :transition_key + and context_key = :context_key + and sort_key in (:sort_key, :prior_sort_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panels.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panels.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/task-panels.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,61 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select ot.pretty_name as workflow_name, + t.transition_name + from acs_object_types ot, + wf_transitions t + where ot.object_type = :workflow_key + and t.workflow_key = ot.object_type + and t.transition_key = :transition_key + + + + + + + + + select context_key as context_key_from_db, + context_name as title, + '' as url, + 0 as selected_p + from wf_contexts + order by context_name + + + + + + + + + select tp.sort_key, + tp.header, + tp.template_url, + '' as edit_url, + '' as delete_url, + '' as move_up_url + from wf_context_task_panels tp + where tp.context_key = :context_key + and tp.workflow_key = :workflow_key + and tp.transition_key = :transition_key + order by sort_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,35 @@ + + + oracle8.1.6 + + + + + select ta.task_id, + ta.case_id, + ta.workflow_key, + ta.transition_key, + tr.transition_name, + ta.enabled_date, + to_char(ta.enabled_date, :date_format) enabled_date_pretty, + ta.state, + ta.deadline, + to_char(ta.deadline, :date_format) as deadline_pretty, + ta.estimated_minutes, + c.object_id, + acs_object.name(c.object_id) as object_name, + o.object_type + from wf_tasks ta, wf_transitions tr, wf_cases c, acs_objects o + where ta.workflow_key = :workflow_key + and tr.workflow_key = ta.workflow_key + and tr.transition_key = ta.transition_key + and c.case_id = ta.case_id + and o.object_id = c.object_id + and ta.state = 'enabled' + and not exists (select 1 from wf_task_assignments tasgn where tasgn.task_id = ta.task_id) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,35 @@ + + + postgresql7.1 + + + + + select ta.task_id, + ta.case_id, + ta.workflow_key, + ta.transition_key, + tr.transition_name, + ta.enabled_date, + to_char(ta.enabled_date, :date_format) enabled_date_pretty, + ta.state, + ta.deadline, + to_char(ta.deadline, :date_format) as deadline_pretty, + ta.estimated_minutes, + c.object_id, + acs_object__name(c.object_id) as object_name, + o.object_type + from wf_tasks ta, wf_transitions tr, wf_cases c, acs_objects o + where ta.workflow_key = :workflow_key + and tr.workflow_key = ta.workflow_key + and tr.transition_key = ta.transition_key + and c.case_id = ta.case_id + and o.object_id = c.object_id + and ta.state = 'enabled' + and not exists (select 1 from wf_task_assignments tasgn where tasgn.task_id = ta.task_id) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/unassigned-tasks.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + + + + + select ot.pretty_name + from wf_workflows wf, acs_object_types ot + where wf.workflow_key = :workflow_key + and ot.object_type = wf.workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,25 @@ + + + + oracle8.1.6 + + + + + declare + v_workflow_key varchar(40); + begin + v_workflow_key := workflow.create_workflow( + workflow_key => :workflow_key, + pretty_name => :workflow_name, + pretty_plural => :workflow_name, + description => :description, + table_name => :workflow_cases_table + ); + end; + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,22 @@ + + + + postgresql7.1 + + + + + select workflow__create_workflow( + :workflow_key, + :workflow_name, + :workflow_name, + :description, + :workflow_cases_table, + 'case_id' + ); + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-add-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,66 @@ + + + + + + + select case when count(*) = 0 then 0 else 1 end from acs_object_types where pretty_name = :workflow_name + + + + + + + + select object_type from acs_object_types + + + + + + + select constraint_name from user_constraints + + + + + + + + create table $workflow_cases_table ( + case_id integer primary key + constraint $workflow_cases_constraint + references wf_cases + ) + + + + + + + + insert into wf_places (place_key, workflow_key, place_name, sort_order) + values ('start', :workflow_key, 'Start place', 1) + + + + + + + + + insert into wf_places (place_key, workflow_key, place_name, sort_order) + values ('end', :workflow_key, 'End place', 999) + + + + + + + + drop table $workflow_cases_table + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,16 @@ + + + oracle8.1.6 + + + + + begin + workflow.delete_cases(workflow_key => :workflow_key); + end; + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,14 @@ + + + postgresql7.1 + + + + + select workflow__delete_cases(:workflow_key) + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-cases-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + + oracle8.1.6 + + + + select package_id from apm_packages where package_key='acs-workflow' and rownum=1 + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,13 @@ + + + + postgresql7.1 + + + + select package_id from apm_packages where package_key='acs-workflow' limit 1 + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy-2.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,36 @@ + + + + + + select object_type from acs_object_types + + + + + + + select pretty_name from acs_object_types + + + + + + + select pretty_name from acs_object_types + + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-copy.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,47 @@ + + + + + + + select ot.pretty_name as workflow_name + from acs_object_types ot + where ot.object_type = :workflow_key + + + + + + + + + select pretty_name, pretty_plural + from acs_object_types + where object_type = :workflow_key + + + + + + + + select object_type from acs_object_types + + + + + + + select pretty_name from acs_object_types + + + + + + + select pretty_name from acs_object_types + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,25 @@ + + + oracle8.1.6 + + + + + begin + workflow.delete_cases(workflow_key => :workflow_key); + end; + + + + + + + + begin + workflow.drop_workflow(workflow_key => :workflow_key); + end; + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete-postgresql.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,21 @@ + + + postgresql7.1 + + + + + select workflow__delete_cases(:workflow_key); + + + + + + + + select workflow__drop_workflow(:workflow_key); + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-delete.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,27 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + select table_name from acs_object_types where object_type = :workflow_key + + + + + + + drop table $cases_table + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-oracle.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,24 @@ + + + oracle8.1.6 + + + + + select w.workflow_key, + t.pretty_name, + w.description, + count(c.case_id) as num_cases, + 0 as num_unassigned_tasks + from wf_workflows w, + acs_object_types t, + wf_cases c + where w.workflow_key = :workflow_key + and w.workflow_key = t.object_type + and c.workflow_key (+) = w.workflow_key + group by w.workflow_key, t.pretty_name, w.description + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-summary.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-summary.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow-summary.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,91 @@ + + + + + + + select 1 from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select pretty_name as workflow_name + from acs_object_types + where object_type = :workflow_key + + + + + + + + + select count(*) + from wf_cases + where workflow_key = :workflow_key + + + + + + + + + select state, count(case_id) as num + from wf_cases + where workflow_key = :workflow_key + group by state + + + + + + + + + select p.place_key, + p.place_name, + (select count(*) + from wf_tokens t, wf_cases c + where t.workflow_key = p.workflow_key + and t.place_key = p.place_key + and t.state in ('free') + and c.case_id = t.case_id + and c.state = 'active') as num_cases, + 0 as num_pixels, + '' as cases_url + from wf_places p + where p.workflow_key = :workflow_key + order by p.sort_order + + + + + + + + + select tr.transition_key, + tr.transition_name, + (select count(*) + from wf_tasks ta, wf_cases c + where ta.workflow_key = tr.workflow_key + and ta.transition_key = tr.transition_key + and ta.state in ('started') + and c.case_id = ta.case_id + and c.state = 'active') as num_cases, + 0 as num_pixels, + '' as cases_url + from wf_transitions tr + where tr.workflow_key = :workflow_key + order by tr.sort_order + + + + + + Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/workflow.xql 3 May 2001 01:14:21 -0000 1.1 @@ -0,0 +1,59 @@ + + + + + + + select count(*) from wf_workflows + where workflow_key = :workflow_key + + + + + + + + select w.workflow_key, + t.pretty_name, + w.description, + count(c.case_id) as num_cases, + 0 as num_unassigned_tasks + from wf_workflows w left outer join wf_cases c using (workflow_key), + acs_object_types t + where w.workflow_key = :workflow_key + and w.workflow_key = t.object_type + group by w.workflow_key, t.pretty_name, w.description + + + + + + + + + select count(*) + from wf_tasks t, + wf_cases c + where t.workflow_key = :workflow_key + and t.state = 'enabled' + and c.case_id = t.case_id + and c.state = 'active' + and not exists (select 1 from wf_task_assignments ta where ta.task_id = t.task_id) + + + + + + + + + select count(*) + from wf_cases c + where c.workflow_key = :workflow_key + and c.state = 'active' + + + + + +