Menu
▾
▴
[H2-commits] r1272 - in humano2/trunk: core/schema/pgsql web/builder/site web/builder/site/xsl
|
From: <sv...@de...> - 2005-06-08 20:27:53
|
Author: pcamacho
Date: 2005-06-08 16:27:54 -0400 (Wed, 08 Jun 2005)
New Revision: 1272
Added:
humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql
Removed:
humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql
Modified:
humano2/trunk/web/builder/site/functionoperationbar.aspx
humano2/trunk/web/builder/site/xsl/createreport.xsl
humano2/trunk/web/builder/site/xsl/functionindex.xsl
Log:
CHANGE: name of files should not have space.
Deleted: humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql 2005-06-08 2=
0:09:26 UTC (rev 1271)
+++ humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql 2005-06-08 2=
0:27:54 UTC (rev 1272)
@@ -1,234 +0,0 @@
-
-CREATE TABLE "d10160cAsset" (
- id_entity integer NOT NULL,
- "c10165Name" character varying(20),
- "c10165Serial Nr." character varying(20),
- "c10165Details" pg_catalog.text,
- "c10165User" integer,
- "c10165Purchase Data" timestamp without time zone,
- "c10165User1" integer
-);
-
-CREATE TABLE "d10160cAsset Type" (
- id_entity integer NOT NULL,
- "c10213Type Name" character varying(20)
-);
-
-
-CREATE TABLE "d10160cProblem Type" (
- id_entity integer NOT NULL,
- "c10189Problem Type" character varying(20)
-);
-
-
-CREATE TABLE "d10160cTicket" (
- id_entity integer NOT NULL,
- "c10162Title" character varying(20),
- "c10162Detail" pg_catalog.text,
- "c10162Request by" integer,
- "c10162Assigned to" integer,
- "c10162Assigned to1" integer,
- "c10162Status" integer,
- "c10162Solution Detail" pg_catalog.text,
- "c10162Problem Type" integer,
- "c10162Attachment" character varying(255),
- "c10162Date" timestamp without time zone,
- "c10162Resolution Date" timestamp without time zone,
- "c10162Request by1" integer,
- "c10162Assigned to2" integer,
- "c10162Assigned to3" integer
-);
-
-CREATE TABLE "d10160cTicket Status" (
- id_entity integer NOT NULL,
- "c10163Status Name" character varying(20)
-);
-
-INSERT INTO "domain" (id_entity, "domainName", "statusDomain") VALUES (1=
0160, 'HelpDesk SMB', NULL);
-
-INSERT INTO user_domain (id_entity, "userTable", "domainTable") VALUES (=
10161, 110, 10160);
-
-
-INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10162, 29, 'd10160cTicke=
t', 'Ticket', 3, false, false, NULL);
-INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10163, 29, 'd10160cTicke=
t Status', 'Ticket Status', 3, false, false, NULL);
-INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10165, 29, 'd10160cAsset=
', 'Asset', 3, false, false, NULL);
-INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10189, 29, 'd10160cProbl=
em Type', 'Problem Type', 3, false, false, NULL);
-INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10213, 29, 'd10160cAsset=
Type', 'Asset Type', 3, false, false, NULL);
-
-
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10160, 10, 6, '2005-06-03 13:42:40.382654=
', '2005-06-03 13:42:40.382654', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10161, 10, 26, '2005-06-03 13:42:40.38265=
4', '2005-06-03 13:42:40.382654', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10183, 10160, 13, '2005-06-03 13:49:23.35=
705', '2005-06-03 13:50:51.900709', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10188, 10160, 13, '2005-06-03 13:51:06.95=
1818', '2005-06-03 13:51:06.951818', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10191, 10160, 1011, '2005-06-03 13:52:08.=
746904', '2005-06-03 14:00:51.690467', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10180, 10160, 1011, '2005-06-03 13:49:03.=
157439', '2005-06-03 14:01:03.294255', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10213, 10160, 2, '2005-06-03 14:01:25.703=
696', '2005-06-03 14:01:25.703696', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10217, 10160, 8, '2005-06-03 14:02:01.815=
791', '2005-06-03 14:02:01.815791', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10211, 10160, 1400, '2005-06-03 14:00:13.=
606343', '2005-06-03 14:09:25.558326', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10169, 10160, 13, '2005-06-03 13:45:57.32=
3388', '2005-06-03 14:22:30.991451', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10168, 10160, 8, '2005-06-03 13:45:43.336=
775', '2005-06-03 14:25:37.287955', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10208, 10160, 12, '2005-06-03 13:58:04.81=
2695', '2005-06-03 14:26:15.834796', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10192, 10160, 81, '2005-06-03 13:52:32.32=
6281', '2005-06-03 14:28:15.268152', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10229, 10160, 81, '2005-06-03 14:39:34.53=
7608', '2005-06-03 14:40:29.939294', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10231, 10160, 81, '2005-06-03 14:42:01.61=
6166', '2005-06-03 14:42:19.932286', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10182, 10160, 1011, '2005-06-03 13:49:16.=
240216', '2005-06-03 14:46:42.304934', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10228, 10160, 1300, '2005-06-03 14:19:33.=
34587', '2005-06-03 14:53:13.709408', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10234, 10160, 81, '2005-06-03 14:54:09.56=
251', '2005-06-03 14:54:09.56251', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10167, 10160, 1011, '2005-06-03 13:45:32.=
65888', '2005-06-03 14:55:26.309087', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10187, 10160, 81, '2005-06-03 13:50:34.47=
0391', '2005-06-03 14:56:52.144244', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10162, 10160, 2, '2005-06-03 13:43:27.916=
665', '2005-06-03 13:43:27.916665', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10163, 10160, 2, '2005-06-03 13:43:46.308=
109', '2005-06-03 13:43:46.308109', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10165, 10160, 2, '2005-06-03 13:45:18.909=
72', '2005-06-03 13:45:18.90972', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10166, 10160, 8, '2005-06-03 13:45:32.568=
103', '2005-06-03 13:45:32.568103', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10179, 10160, 8, '2005-06-03 13:49:03.037=
233', '2005-06-03 13:49:03.037233', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10189, 10160, 2, '2005-06-03 13:51:55.936=
952', '2005-06-03 13:51:55.936952', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10190, 10160, 8, '2005-06-03 13:52:08.663=
398', '2005-06-03 13:52:08.663398', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10171, 10160, 1011, '2005-06-03 13:46:14.=
711256', '2005-06-03 14:11:48.27411', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10218, 10160, 1011, '2005-06-03 14:02:01.=
896462', '2005-06-03 14:12:17.918998', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10216, 10160, 1011, '2005-06-03 14:01:49.=
2393', '2005-06-03 14:12:32.141613', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10207, 10160, 12, '2005-06-03 13:57:45.49=
2882', '2005-06-03 14:22:45.989972', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10181, 10160, 8, '2005-06-03 13:49:16.159=
46', '2005-06-03 14:26:07.052118', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10209, 10160, 12, '2005-06-03 13:58:16.05=
7463', '2005-06-03 14:28:37.025827', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10212, 10160, 1400, '2005-06-03 14:00:21.=
580172', '2005-06-03 14:41:01.392034', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10227, 10160, 1011, '2005-06-03 14:14:50.=
273608', '2005-06-03 14:46:50.975127', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10226, 10160, 1011, '2005-06-03 14:14:03.=
451426', '2005-06-03 14:46:59.017467', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10210, 10160, 1400, '2005-06-03 14:00:06.=
409507', '2005-06-03 14:53:42.120173', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10193, 10160, 39, '2005-06-03 13:52:55.97=
5696', '2005-06-03 14:56:44.293002', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10194, 10160, 10163, '2005-06-03 13:53:51=
.821092', '2005-06-03 13:53:51.821092', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10195, 10160, 10163, '2005-06-03 13:53:59=
.706222', '2005-06-03 13:53:59.706222', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10196, 10160, 10189, '2005-06-03 13:54:17=
.310243', '2005-06-03 13:54:17.310243', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10197, 10160, 10189, '2005-06-03 13:54:46=
.136202', '2005-06-03 13:54:46.136202', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10198, 10160, 10189, '2005-06-03 13:54:53=
.731381', '2005-06-03 13:54:53.731381', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10199, 10160, 10189, '2005-06-03 13:55:04=
.593734', '2005-06-03 13:55:04.593734', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10200, 10160, 10189, '2005-06-03 13:55:17=
.971074', '2005-06-03 13:55:17.971074', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10201, 10160, 10189, '2005-06-03 13:55:41=
.042234', '2005-06-03 13:55:41.042234', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10202, 10160, 10189, '2005-06-03 13:55:49=
.192745', '2005-06-03 13:55:49.192745', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10203, 10160, 10189, '2005-06-03 13:56:15=
.128508', '2005-06-03 13:56:15.128508', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10204, 10160, 10189, '2005-06-03 13:56:25=
.237106', '2005-06-03 13:56:25.237106', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10205, 10160, 10189, '2005-06-03 13:56:36=
.198424', '2005-06-03 13:56:36.198424', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10206, 10160, 10189, '2005-06-03 13:56:46=
.303592', '2005-06-03 13:56:46.303592', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10221, 10160, 10213, '2005-06-03 14:03:01=
.731759', '2005-06-03 14:03:01.731759', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10222, 10160, 10213, '2005-06-03 14:03:11=
.262688', '2005-06-03 14:03:11.262688', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10223, 10160, 10213, '2005-06-03 14:03:19=
.212243', '2005-06-03 14:03:19.212243', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10224, 10160, 10213, '2005-06-03 14:03:27=
.729589', '2005-06-03 14:03:27.729589', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10225, 10160, 10213, '2005-06-03 14:03:34=
.714994', '2005-06-03 14:03:34.714994', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10233, 10160, 10162, '2005-06-03 14:48:54=
.39211', '2005-06-03 14:48:54.809633', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10235, 10160, 10165, '2005-06-03 14:54:50=
.088007', '2005-06-03 14:55:44.129858', NULL, NULL);
-INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10232, 10160, 10162, '2005-06-03 14:43:15=
.241259', '2005-06-03 14:57:13.749824', NULL, NULL);
-
-
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10183, 10162, 'c10162Detail', 'Problem Detail', 0.00, false,=
true, false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10188, 10162, 'c10162Solution Detail', 'Solution Detail', 0.=
00, false, true, false, true, false, false, false, false, NULL, false, NU=
LL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10217, 10213, 'c10213Type Name', 'Type Name', 0.00, false, t=
rue, false, true, false, true, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10169, 10165, 'c10165Details', 'Details', 10.00, false, true=
, false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10168, 10165, 'c10165Serial Nr.', 'Serial Nr.', 4.00, false,=
true, false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10208, 10162, 'c10162Date', 'Date', -9.00, false, true, fals=
e, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10192, 10162, 'c10162Problem Type', 'Problem Type', -4.00, f=
alse, true, false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10229, 10162, 'c10162Request by1', 'Request by', -5.00, fals=
e, true, true, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10231, 10162, 'c10162Assigned to3', 'Assigned to', 0.00, fal=
se, true, true, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10234, 10165, 'c10165User1', 'User', 0.00, false, true, true=
, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10187, 10162, 'c10162Status', 'Status', 15.00, false, true, =
false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10166, 10165, 'c10165Name', 'Name', 0.00, false, true, false=
, true, false, true, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10179, 10163, 'c10163Status Name', 'Status Name', 0.00, fals=
e, true, false, true, false, true, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10190, 10189, 'c10189Problem Type', 'Problem Type', 0.00, fa=
lse, true, false, true, false, true, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10207, 10165, 'c10165Purchase Data', 'Purchase Date', 5.00, =
false, true, false, true, false, false, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10181, 10162, 'c10162Title', 'Title', -10.00, false, true, f=
alse, true, false, true, false, false, NULL, false, NULL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10209, 10162, 'c10162Resolution Date', 'Resolution Date', 8.=
00, false, true, false, true, false, false, false, false, NULL, false, NU=
LL);
-INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10193, 10162, 'c10162Attachment', 'Attachment', 20.00, false=
, true, false, true, false, false, false, false, NULL, false, NULL);
-
-
-INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10207, NULL, NULL, NULL);
-INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10208, NULL, NULL, NULL);
-INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10209, NULL, NULL, NULL);
-
-
-INSERT INTO file (id_entity, maxsize, path, extensions, link) VALUES (10=
193, 100000, NULL, NULL, true);
-
-
-INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10211, 'Assets', 0, '10167');
-INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10212, 'Users and Setup', 0, '10191,10180,10218');
-INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10210, 'Tickets', 0, '10227,10226');
-
-
-INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10192, 10192, 10189, 'n:1', NU=
LL, NULL, NULL);
-INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10229, 10229, 7, 'n:1', NULL, =
NULL, NULL);
-INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10231, 10231, 7, 'n:1', NULL, =
NULL, NULL);
-INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10234, 10234, 7, 'n:1', NULL, =
NULL, NULL);
-INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10187, 10187, 10163, 'n:1', NU=
LL, NULL, NULL);
-
-
-INSERT INTO report (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassReport", "reportName") VALUES (10228, '10181|1,10187^10179',=
NULL, '10187^10179', NULL, NULL, 10162, 'Tickets by Assignment');
-
-
-INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10183, 7, 3=
0, false);
-INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10188, 7, 3=
0, false);
-INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10169, 7, 3=
0, false);
-
-
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10166, 20, NULL, NULL, NULL);
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10179, 20, NULL, NULL, NULL);
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10190, 20, NULL, NULL, NULL);
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10217, 20, NULL, NULL, NULL);
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10168, 20, NULL, NULL, NULL);
-INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10181, 20, NULL, NULL, NULL);
-
-
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10218, '0,10217', NULL, NULL, NUL=
L, NULL, 10213, 'Asset Type Pick List');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10227, '0,10181,10208,10231^18,10=
209', '10187^10179|7|''closed''|0|0', NULL, NULL, NULL, 10162, 'Closed Ti=
ckets');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10226, '0,10181,10208,10231^18,10=
187^10179', '10187^10179|7|''open''|0|0', NULL, NULL, NULL, 10162, 'Open =
Tickets');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10191, '0,10190', NULL, NULL, NUL=
L, NULL, 10189, 'Problem Type Pick List');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10180, '0,10179', NULL, NULL, NUL=
L, NULL, 10163, 'Ticket Status Pick List');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10182, '0,10181,10208,10231^18,10=
187^10179', NULL, NULL, NULL, NULL, 10162, 'All Tickets');
-INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10167, '0,10166,10168,10207,10169=
', NULL, NULL, NULL, NULL, 10165, 'All Assets');
-
-
-INSERT INTO "d10160cAsset" (id_entity, "c10165Name", "c10165Serial Nr.",=
"c10165Details", "c10165User", "c10165Purchase Data", "c10165User1") VAL=
UES (10235, 'PC Work Station', '453345345', 'Dell Work Station with Monit=
or VisewSonic 14F', NULL, '2005-06-14 00:00:00', 110);
-
-INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0221, 'PC Work Station');
-INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0222, 'PC Notebook');
-INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0223, 'Monitor');
-INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0224, 'Printer');
-INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0225, 'Other');
-
-
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10196, 'Conectivity');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10197, 'Bug');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10198, 'Crash');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10199, 'Priniting');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10200, 'System Start-up');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10201, 'Audio Visual');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10202, 'Virus');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10203, 'eMail');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10204, 'Software - Windows');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10205, 'Software - Office');
-INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10206, 'Software - Outlook');
-
-
-INSERT INTO "d10160cTicket" (id_entity, "c10162Title", "c10162Detail", "=
c10162Request by", "c10162Assigned to", "c10162Assigned to1", "c10162Stat=
us", "c10162Solution Detail", "c10162Problem Type", "c10162Attachment", "=
c10162Date", "c10162Resolution Date", "c10162Request by1", "c10162Assigne=
d to2", "c10162Assigned to3") VALUES (10233, 'Internet Down', 'User can n=
ot connect to the Internet', NULL, NULL, NULL, 10194, NULL, 10196, NULL, =
'2005-06-03 00:00:00', '2005-06-03 00:00:00', 110, NULL, 110);
-INSERT INTO "d10160cTicket" (id_entity, "c10162Title", "c10162Detail", "=
c10162Request by", "c10162Assigned to", "c10162Assigned to1", "c10162Stat=
us", "c10162Solution Detail", "c10162Problem Type", "c10162Attachment", "=
c10162Date", "c10162Resolution Date", "c10162Request by1", "c10162Assigne=
d to2", "c10162Assigned to3") VALUES (10232, 'PC does not startup', 'PC d=
oes not startup', NULL, NULL, NULL, 10195, 'PC was not plugged in. I plug=
ged in the PC. Now the PC works fine. User happy.', 10200, NULL, '2005-06=
-03 00:00:00', '2005-06-03 00:00:00', 110, NULL, 110);
-
-
-INSERT INTO "d10160cTicket Status" (id_entity, "c10163Status Name") VALU=
ES (10194, 'open');
-INSERT INTO "d10160cTicket Status" (id_entity, "c10163Status Name") VALU=
ES (10195, 'closed');
-
-
-ALTER TABLE ONLY "d10160cAsset Type"
- ADD CONSTRAINT "d10160cAsset Type_pkey" PRIMARY KEY (id_entity);
-
-ALTER TABLE ONLY "d10160cAsset"
- ADD CONSTRAINT "d10160cAsset_pkey" PRIMARY KEY (id_entity);
-
-
-
-ALTER TABLE ONLY "d10160cProblem Type"
- ADD CONSTRAINT "d10160cProblem Type_pkey" PRIMARY KEY (id_entity);
-
-
-ALTER TABLE ONLY "d10160cTicket Status"
- ADD CONSTRAINT "d10160cTicket Status_pkey" PRIMARY KEY (id_entity);
-
-
-ALTER TABLE ONLY "d10160cTicket"
- ADD CONSTRAINT "d10160cTicket_pkey" PRIMARY KEY (id_entity);
-
-
Copied: humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql (from rev=
1270, humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql)
Modified: humano2/trunk/web/builder/site/functionoperationbar.aspx
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/web/builder/site/functionoperationbar.aspx 2005-06-08 2=
0:09:26 UTC (rev 1271)
+++ humano2/trunk/web/builder/site/functionoperationbar.aspx 2005-06-08 2=
0:27:54 UTC (rev 1272)
@@ -49,7 +49,7 @@
<!--div id=3D"CreateRule"><a href=3D"#" onClick=3D"CreateRule()">Crea=
te Rule</a></div-->
<div id=3D"CreateForm"><a href=3D"#" onClick=3D"CreateForm()">Create =
Form</a></div>
<div id=3D"CreateFolder"><a href=3D"#" onClick=3D"CreateFolder()">Cre=
ate Folder</a></div>
- <!-- <div id=3D"CreateReport"><a href=3D"#" onClick=3D"Creat=
eReport()">Create Report</a></div> -->
+ <div id=3D"CreateReport"><a href=3D"#" onClick=3D"CreateRepo=
rt()">Create Report</a></div>
</div>
<form id=3D"Form1" method=3D"post" runat=3D"server">
<input id=3D"classId2" name=3D"classId2" type=3D"hidden">=20
Modified: humano2/trunk/web/builder/site/xsl/createreport.xsl
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/web/builder/site/xsl/createreport.xsl 2005-06-08 20:09:=
26 UTC (rev 1271)
+++ humano2/trunk/web/builder/site/xsl/createreport.xsl 2005-06-08 20:27:=
54 UTC (rev 1272)
@@ -22,172 +22,171 @@
<!-- Load this script before the next one -->
<script language=3D"Javascript" src=3D"js/formreport.js" typ=
e=3D"text/javascript"></script>=20
<script language=3D"Javascript" src=3D"js/createreport.js" t=
ype=3D"text/javascript"></script>=20
- <link href=3D"styles/css/general_styles_verde.css" rel=3D"st=
ylesheet" type=3D"text/css"></link>
+ <link href=3D"css/general_styles_verde.css" rel=3D"styleshee=
t" type=3D"text/css"></link>
<link href=3D"css/createreport.css" rel=3D"stylesheet" type=3D=
"text/css"></link>
- </head>
- =09
- <!-- Here we create an array and use it as parameter for Form cl=
ass constructor -->
- <script language=3D"Javascript">
- =20
- //////////////////////
- //The report params
- =20
- //Columns
- var reportColumnsArray =3D new Array();
- var i=3D0;
- <xsl:for-each select=3D"/report/reportDatas/reportParams/col=
umns/column">
- reportColumnsArray[i++] =3D "<xsl:value-of select=3D"." =
/>";
- </xsl:for-each>
- //alert(reportColumnsArray.length);
- var ReportParams =3D new ReportParams(reportColumnsArray,nul=
l,null);
- =20
- ////////////////////////
- //The form
- var formArray =3D new Array();
- var i; //Counter
- =20
- <xsl:for-each select=3D"/report/classes/class[count(attribut=
es)>0]">
- <xsl:variable name=3D"classId">
- <xsl:value-of select=3D"id" />
- </xsl:variable>
- formArray[<xsl:value-of select=3D"$classId"/>] =3D new A=
rray();
- i=3D0;
- <xsl:for-each select=3D"attributes/attribute">
- formArray[<xsl:value-of select=3D"$classId"/>][i] =3D=
new Array();
- formArray[<xsl:value-of select=3D"$classId"/>][i]["v=
alue"] =3D "<xsl:value-of select=3D"id"/>";
- formArray[<xsl:value-of select=3D"$classId"/>][i]["n=
ame"] =3D "<xsl:value-of select=3D"name" />";
+ =09
+ <!-- Here we create an array and use it as parameter for For=
m class constructor -->
+ <script language=3D"Javascript">
+ =20
+ //////////////////////
+ //The report params
+ =20
+ //Columns
+ var reportColumnsArray =3D new Array();
+ var i=3D0;
+ <xsl:for-each select=3D"/report/reportDatas/reportParams=
/columns/column">
+ reportColumnsArray[i++] =3D "<xsl:value-of select=3D=
"." />";
+ </xsl:for-each>
+ //alert(reportColumnsArray.length);
+ var ReportParams =3D new ReportParams(reportColumnsArray=
,null,null);
+ =20
+ ////////////////////////
+ //The form
+ var formArray =3D new Array();
+ var i; //Counter
+ =20
+ <xsl:for-each select=3D"/report/classes/class[count(attr=
ibutes)>0]">
+ <xsl:variable name=3D"classId">
+ <xsl:value-of select=3D"id" />
+ </xsl:variable>
+ formArray[<xsl:value-of select=3D"$classId"/>] =3D n=
ew Array();
+ i=3D0;
+ <xsl:for-each select=3D"attributes/attribute">
+ formArray[<xsl:value-of select=3D"$classId"/>][i=
] =3D new Array();
+ formArray[<xsl:value-of select=3D"$classId"/>][i=
]["value"] =3D "<xsl:value-of select=3D"id"/>";
+ formArray[<xsl:value-of select=3D"$classId"/>][i=
]["name"] =3D "<xsl:value-of select=3D"name" />";
+ i++;
+ </xsl:for-each>
+ </xsl:for-each>
+ =20
+ <xsl:if test=3D"/report/reportDatas/classId!=3D''">
+ var Form =3D new Form(formArray,<xsl:value-of select=3D"=
/report/reportDatas/classId" />,ReportParams);
+ </xsl:if>
+ //alert(Form.GetOptionString(0));
+ =20
+ //Filters =20
+ var selectOption0ArrayFilter =3D new Array();
+ var selectOption1ArrayFilter =3D new Array();
+ var inputTagValuesArrayFilter =3D new Array();
+ =20
+ var i=3D0;
+ <xsl:for-each select=3D"/report/reportDatas/reportParams=
/conditions/condition">
+ selectOption0ArrayFilter[i] =3D <xsl:value-of selec=
t=3D"idAtt" />;
+ selectOption1ArrayFilter[i] =3D <xsl:value-of selec=
t=3D"operator" />;
+ inputTagValuesArrayFilter[i] =3D <xsl:value-of sele=
ct=3D"value" />;
i++;
</xsl:for-each>
- </xsl:for-each>
- =20
- <xsl:if test=3D"/report/reportDatas/classId!=3D''">
- var Form =3D new Form(formArray,<xsl:value-of select=3D"/rep=
ort/reportDatas/classId" />,ReportParams);
- </xsl:if>
- //alert(Form.GetOptionString(0));
- =20
- //Filters =20
- var selectOption0ArrayFilter =3D new Array();
- var selectOption1ArrayFilter =3D new Array();
- var inputTagValuesArrayFilter =3D new Array();
- =20
- var i=3D0;
- <xsl:for-each select=3D"/report/reportDatas/reportParams/con=
ditions/condition">
- selectOption0ArrayFilter[i] =3D <xsl:value-of select=3D=
"idAtt" />;
- selectOption1ArrayFilter[i] =3D <xsl:value-of select=3D=
"operator" />;
- inputTagValuesArrayFilter[i] =3D <xsl:value-of select=3D=
"value" />;
- i++;
- </xsl:for-each>
- =20
- <xsl:if test=3D"/report/reportDatas/classId!=3D''">
- var InputLineParamsFilters =3D
- {
- type: 'TWOSELECTANDINPUT',
- select0: AttribsGetSelectArray(formArray,<xsl:value-=
of select=3D"/report/reportDatas/classId" />),
- select1: OperatorsGetSelectArray(),
- lineTitle: 'Filter',
- input0: '',
- PreselectedInput0: inputTagValuesArrayFilter,
- PreselectedSelect0: selectOption0ArrayFilter,
- PreselectedSelect1: selectOption1ArrayFilter,
- refName: 'expandFormFilter'
- }
- var InputLineFilters =3D new InputLine(InputLineParamsFi=
lters);
- </xsl:if>
- =20
- =20
- //Order
- var selectOption0ArrayOrder =3D new Array();
- var selectOption1ArrayOrder =3D new Array();
- var i=3D0;
- <xsl:for-each select=3D"/report/reportDatas/reportParams/ord=
ers/order">
- selectOption0ArrayOrder[i] =3D <xsl:value-of select=3D"=
idAtt" />;
- selectOption1ArrayOrder[i] =3D <xsl:value-of select=3D"=
ascOrDesc" />;
- i++;
- </xsl:for-each>
- =20
- <xsl:if test=3D"/report/reportDatas/classId!=3D''">
- var InputLineParamsOrders =3D
- {
- type: 'TWOSELECT',
- select0: AttribsGetSelectArray(formArray,<xsl:value-=
of select=3D"/report/reportDatas/classId" />),
- select1: OrderGetSelectArray(),
- lineTitle: 'Order',
- input0: '',
- PreselectedInput0: null,
- PreselectedSelect0: selectOption0ArrayOrder,
- PreselectedSelect1: selectOption1ArrayOrder,
- refName: 'expandFormSort'
- }
- var InputLineOrders =3D new InputLine(InputLineParamsOrd=
ers);
- </xsl:if>
- =20
- =20
- //Personalized columns
- var selectOption0ArrayPersoColumns =3D new Array();
- var selectOption1ArrayPersoColumns =3D new Array();
- var i=3D0;
- <xsl:for-each select=3D"/report/reportDatas/reportParams/per=
soColumns/persoColumn">
- selectOption0ArrayPersoColumns[i] =3D <xsl:value-of sel=
ect=3D"idAtt" />;
- selectOption1ArrayPersoColumns[i] =3D <xsl:value-of sel=
ect=3D"op" />;
- i++;
- </xsl:for-each>
- =20
- <xsl:if test=3D"/report/reportDatas/classId!=3D''">
- var InputLineParamsPersoColumns =3D
- {
- type: 'TWOSELECT', //For the moment
- select0: AttribsGetSelectArray(formArray,<xsl:value-=
of select=3D"/report/reportDatas/classId" />),
- select1: FunctionsGetSelectArray(),
- lineTitle: 'PersoCol',
- input0: '',
- PreselectedInput0: null,
- PreselectedSelect0: selectOption0ArrayPersoColumns, =
//For the moment
- PreselectedSelect1: selectOption1ArrayPersoColumns, =
//For the moment
- refName: 'expandFormPersoColumns'
- }
- var InputLinePersoColumns =3D new InputLine(InputLinePar=
amsPersoColumns);
- </xsl:if>
- =20
- //Having
- var selectIdAttArrayHaving =3D new Array();
- var selectOpArrayHaving =3D new Array();
- var selectFuncArrayHaving =3D new Array();
- var inputTagValuesArrayHaving =3D new Array();
- =20
- var i=3D0;
- <xsl:for-each select=3D"/report/reportDatas/reportParams/hav=
ings/having">
- selectFuncArrayHaving[i] =3D <xsl:value-of select=3D"fu=
nc" />;
- selectIdAttArrayHaving[i] =3D <xsl:value-of select=3D"i=
dAtt" />;
- selectOpArrayHaving[i] =3D <xsl:value-of select=3D"oper=
ator" />;
- inputTagValuesArrayHaving[i] =3D <xsl:value-of select=3D=
"value" />;
- i++;
- </xsl:for-each>
- =20
- <xsl:if test=3D"/report/reportDatas/classId!=3D''">
- var InputLineParamsHavings =3D
- {
- type: 'THREESELECTANDINPUT',
- select0: AttribsGetSelectArray(formArray,<xsl:value-=
of select=3D"/report/reportDatas/classId" />),
- select1: FunctionsGetSelectArray(),
- select2: OperatorsGetSelectArray(),
- lineTitle: 'GroupFilter',
- input0: '',
- PreselectedInput0: inputTagValuesArrayHaving,
- PreselectedSelect0: selectIdAttArrayHaving,
- PreselectedSelect1: selectFuncArrayHaving,
- PreselectedSelect2: selectOpArrayHaving,
- refName: 'expandFormHaving'
- }
- var InputLineHavings =3D new InputLine(InputLineParamsHa=
vings);
- </xsl:if>
- =20
- </script>
- =20
- <body >
+ =20
+ <xsl:if test=3D"/report/reportDatas/classId!=3D''">
+ var InputLineParamsFilters =3D
+ {
+ type: 'TWOSELECTANDINPUT',
+ select0: AttribsGetSelectArray(formArray,<xsl:va=
lue-of select=3D"/report/reportDatas/classId" />),
+ select1: OperatorsGetSelectArray(),
+ lineTitle: 'Filter',
+ input0: '',
+ PreselectedInput0: inputTagValuesArrayFilter,
+ PreselectedSelect0: selectOption0ArrayFilter,
+ PreselectedSelect1: selectOption1ArrayFilter,
+ refName: 'expandFormFilter'
+ }
+ var InputLineFilters =3D new InputLine(InputLinePara=
msFilters);
+ </xsl:if>
+ =20
+ =20
+ //Order
+ var selectOption0ArrayOrder =3D new Array();
+ var selectOption1ArrayOrder =3D new Array();
+ var i=3D0;
+ <xsl:for-each select=3D"/report/reportDatas/reportParams=
/orders/order">
+ selectOption0ArrayOrder[i] =3D <xsl:value-of select=
=3D"idAtt" />;
+ selectOption1ArrayOrder[i] =3D <xsl:value-of select=
=3D"ascOrDesc" />;
+ i++;
+ </xsl:for-each>
+ =20
+ <xsl:if test=3D"/report/reportDatas/classId!=3D''">
+ var InputLineParamsOrders =3D
+ {
+ type: 'TWOSELECT',
+ select0: AttribsGetSelectArray(formArray,<xsl:va=
lue-of select=3D"/report/reportDatas/classId" />),
+ select1: OrderGetSelectArray(),
+ lineTitle: 'Order',
+ input0: '',
+ PreselectedInput0: null,
+ PreselectedSelect0: selectOption0ArrayOrder,
+ PreselectedSelect1: selectOption1ArrayOrder,
+ refName: 'expandFormSort'
+ }
+ var InputLineOrders =3D new InputLine(InputLineParam=
sOrders);
+ </xsl:if>
+ =20
+ =20
+ //Personalized columns
+ var selectOption0ArrayPersoColumns =3D new Array();
+ var selectOption1ArrayPersoColumns =3D new Array();
+ var i=3D0;
+ <xsl:for-each select=3D"/report/reportDatas/reportParams=
/persoColumns/persoColumn">
+ selectOption0ArrayPersoColumns[i] =3D <xsl:value-of=
select=3D"idAtt" />;
+ selectOption1ArrayPersoColumns[i] =3D <xsl:value-of=
select=3D"op" />;
+ i++;
+ </xsl:for-each>
+ =20
+ <xsl:if test=3D"/report/reportDatas/classId!=3D''">
+ var InputLineParamsPersoColumns =3D
+ {
+ type: 'TWOSELECT', //For the moment
+ select0: AttribsGetSelectArray(formArray,<xsl:va=
lue-of select=3D"/report/reportDatas/classId" />),
+ select1: FunctionsGetSelectArray(),
+ lineTitle: 'PersoCol',
+ input0: '',
+ PreselectedInput0: null,
+ PreselectedSelect0: selectOption0ArrayPersoColum=
ns, //For the moment
+ PreselectedSelect1: selectOption1ArrayPersoColum=
ns, //For the moment
+ refName: 'expandFormPersoColumns'
+ }
+ var InputLinePersoColumns =3D new InputLine(InputLin=
eParamsPersoColumns);
+ </xsl:if>
+ =20
+ //Having
+ var selectIdAttArrayHaving =3D new Array();
+ var selectOpArrayHaving =3D new Array();
+ var selectFuncArrayHaving =3D new Array();
+ var inputTagValuesArrayHaving =3D new Array();
+ =20
+ var i=3D0;
+ <xsl:for-each select=3D"/report/reportDatas/reportParams=
/havings/having">
+ selectFuncArrayHaving[i] =3D <xsl:value-of select=3D=
"func" />;
+ selectIdAttArrayHaving[i] =3D <xsl:value-of select=3D=
"idAtt" />;
+ selectOpArrayHaving[i] =3D <xsl:value-of select=3D"=
operator" />;
+ inputTagValuesArrayHaving[i] =3D <xsl:value-of sele=
ct=3D"value" />;
+ i++;
+ </xsl:for-each>
+ =20
+ <xsl:if test=3D"/report/reportDatas/classId!=3D''">
+ var InputLineParamsHavings =3D
+ {
+ type: 'THREESELECTANDINPUT',
+ select0: AttribsGetSelectArray(formArray,<xsl:va=
lue-of select=3D"/report/reportDatas/classId" />),
+ select1: FunctionsGetSelectArray(),
+ select2: OperatorsGetSelectArray(),
+ lineTitle: 'GroupFilter',
+ input0: '',
+ PreselectedInput0: inputTagValuesArrayHaving,
+ PreselectedSelect0: selectIdAttArrayHaving,
+ PreselectedSelect1: selectFuncArrayHaving,
+ PreselectedSelect2: selectOpArrayHaving,
+ refName: 'expandFormHaving'
+ }
+ var InputLineHavings =3D new InputLine(InputLinePara=
msHavings);
+ </xsl:if>
+ =20
+ </script>
+ </head>
+ <body>
<form id=3D"formulario" name=3D"formulario" method=3D"post">
- <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpad=
ding=3D"0" class=3D"conttablecenter2">
- <tr>
- <td valign=3D"center" class=3D"smallgraytextnolink" =
>
+ <table width=3D"100%" border=3D"0" cellspacing=3D"0" cel=
lpadding=3D"0" class=3D"conttablecenter2">
+ <tr>
+ <td valign=3D"center" class=3D"smallgraytextnoli=
nk" >
<table width=3D"100%" cellspacing=3D"1" bord=
er=3D"0" class=3D"smallgraytextnolink" >
<tr>
<td class=3D"smallgraytextnolink" >
@@ -210,7 +209,7 @@
<!-- Only show classes for select wh=
en creating -->
<xsl:if test=3D"/report/reportDatas/=
saveName=3D'Create'" >=20
<td>
- <select class=3D"drpdwn2" id=3D"cla=
ssList" onchange=3D"Reload();">
+ <select class=3D"drpdwn2" id=3D"=
classList" onchange=3D"Reload();">
<xsl:for-each select=3D"repo=
rt/classes/class">
<option>
<xsl:attribute name=3D=
"name">
@@ -235,20 +234,20 @@
<xsl:if test=3D"count(/report/classes/cl=
ass/attributes)!=3D0">
<!-- ######################## Filters #=
####################################### -->
<tr>
- <td colspan=3D"2">
- <table width=3D"100%" border=3D"0" cellSpacing=3D"0" cellPadding=
=3D"0">
- <tr>
- <td width=3D"100%" colspan=3D"2">
- <div class=3D"lev1divider"><IMG height=3D"9" src=3D"clear2x2.=
gif" width=3D"100%"/></div>
- </td>
- </tr>
- <tr>
- <td class=3D"lev1head" valign=3D"top"><font size=3D"2">Filtros=
...</font></td>
- </tr>
- </table>
- </td>
- </tr>
-
+ <td colspan=3D"2">
+ <table width=3D"100%" border=3D"0" cellS=
pacing=3D"0" cellPadding=3D"0">
+ <tr>
+ <td width=3D"100%" colspan=3D"2"=
>
+ <div class=3D"lev1divider"><=
IMG height=3D"9" src=3D"clear2x2.gif" width=3D"100%"/></div>
+ </td>
+ </tr>
+ <tr>
+ <td class=3D"lev1head" valign=3D=
"top"><font size=3D"2">Filtros...</font></td>
+ </tr>
+ </table>
+ </td>
+ </tr>
+ =20
<tr>
<td class=3D"smallgraytextnolink" co=
lspan=3D"2">
<table width=3D"100%">
@@ -272,7 +271,7 @@
=20
<!--######################### Perso Colu=
mns ################################## -->
<tr>
- <td colspan=3D"2">
+ <td colspan=3D"2">
<table width=3D"100%" border=3D"=
0" cellSpacing=3D"0" cellPadding=3D"0">
<tr>
<td width=3D"100%" colspan=3D=
"2" class=3D"lev1divider">
@@ -283,9 +282,9 @@
<td class=3D"lev1head" valig=
n=3D"top"><font size=3D"2">Personalized columns...</font></td>
</tr>
</table>
- </td>
- </tr>
-
+ </td>
+ </tr>
+ =20
<tr>
<td class=3D"smallgraytextnolink" co=
lspan=3D"2">
<table>
@@ -308,10 +307,11 @@
=20
<!--######################### END: Perso=
Columns ################################## -->
=20
- =20
<!--######################### Havings ##=
########################################## -->
+ <!-- Commented for now due to a problem =
in showview see bug # -->
+ <!--
<tr>
- <td colspan=3D"2">
+ <td colspan=3D"2">
<table width=3D"100%" border=3D"=
0" cellSpacing=3D"0" cellPadding=3D"0">
<tr>
<td width=3D"100%" colspan=3D=
"2" class=3D"lev1divider">
@@ -322,9 +322,8 @@
<td class=3D"lev1head" valig=
n=3D"top"><font size=3D"2">Group filters...</font></td>
</tr>
</table>
- </td>
- </tr>
-
+ </td>
+ </tr>
<tr>
<td class=3D"smallgraytextnolink" co=
lspan=3D"2">
<table>
@@ -344,12 +343,12 @@
</script>
</td>
</tr>
- =20
+ -->
<!--######################### END: Havin=
gs ####################################### -->
=20
<!-- ######################## Group colu=
mns ############################## -->
<tr>
- <td colspan=3D"2">
+ <td colspan=3D"2">
<table width=3D"100%" border=3D"=
0" cellSpacing=3D"0" cellPadding=3D"0">
<tr>
<td width=3D"100%" colspan=3D=
"2">
@@ -360,9 +359,9 @@
<td class=3D"lev1head" valig=
n=3D"top"><font size=3D"2">Group columns...</font></td>
</tr>
</table>
- </td>
- </tr>
-
+ </td>
+ </tr>
+ =20
<tr>
<td class=3D"smallgraytextnolink" c=
olspan=3D"2">
<table>
@@ -430,7 +429,7 @@
=20
<!--######################### Sort #####=
######################################### -->
<tr>
- <td colspan=3D"2">
+ <td colspan=3D"2">
<table width=3D"100%" border=3D"=
0" cellSpacing=3D"0" cellPadding=3D"0">
<tr>
<td width=3D"100%" colspan=3D=
"2" class=3D"lev1divider">
@@ -441,9 +440,9 @@
<td class=3D"lev1head" valig=
n=3D"top"><font size=3D"2">Orden...</font></td>
</tr>
</table>
- </td>
- </tr>
-
+ </td>
+ </tr>
+ =20
<tr>
<td class=3D"smallgraytextnolink" co=
lspan=3D"2">
<table>
@@ -468,16 +467,16 @@
=20
<!--######################### Buttons ##=
######################################## -->
<tr>
- <td colspan=3D"2">
- <table width=3D"100%" border=3D"0" cellSpacing=3D"0" cellPadding=
=3D"0">
- <tr>
- <td width=3D"100%" colspan=3D"2">
- <div class=3D"lev1divider"><img height=3D"9" src=3D"clear2x2.=
gif" width=3D"100%"/></div>
- </td>
- </tr>
- </table>
- </td>
- </tr>
+ <td colspan=3D"2">
+ <table width=3D"100%" border=3D"0" cellS=
pacing=3D"0" cellPadding=3D"0">
+ <tr>
+ <td width=3D"100%" colspan=3D"2"=
>
+ <div class=3D"lev1divider"><=
img height=3D"9" src=3D"clear2x2.gif" width=3D"100%"/></div>
+ </td>
+ </tr>
+ </table>
+ </td>
+ </tr>
<tr>
<td class=3D"ContentAlt">
<div id=3D"CrudButtons1">
@@ -510,18 +509,18 @@
<!--######################### End:Button=
s ########################################## -->
</xsl:if>
</table>
- </td>
- </tr>
- </table>
- <!-- This tag is used to create the inputs hidden to send al=
l the data in one pass -->
- <div id=3D"SubmitAll">
- <!-- Always submits the report id -->
- <input type=3D"hidden" id=3D"reportId">
- <xsl:attribute name=3D"value">
- <xsl:value-of select=3D"/report/reportDatas/id" />
- </xsl:attribute>
- </input>=20
- </div>
+ </td>
+ </tr>
+ </table>
+ <!-- This tag is used to create the inputs hidden to sen=
d all the data in one pass -->
+ <div id=3D"SubmitAll">
+ <!-- Always submits the report id -->
+ <input type=3D"hidden" id=3D"reportId">
+ <xsl:attribute name=3D"value">
+ <xsl:value-of select=3D"/report/reportDatas/id" =
/>
+ </xsl:attribute>
+ </input>=20
+ </div>
</form>
</body>
</html>
Modified: humano2/trunk/web/builder/site/xsl/functionindex.xsl
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/web/builder/site/xsl/functionindex.xsl 2005-06-08 20:09=
:26 UTC (rev 1271)
+++ humano2/trunk/web/builder/site/xsl/functionindex.xsl 2005-06-08 20:27=
:54 UTC (rev 1272)
@@ -78,14 +78,13 @@
var child_<xsl:value-of select=3D"id" /> =3D new=
WebFXTreeItem('<xsl:value-of select=3D"name" />',
=
'formmanagement.aspx?modformid=3D<xsl:value-of select=3D"id" =
/>&modclassId=3D<xsl:value-of select=3D"classId" />',
...
[truncated message content] |
