Menu
▾
▴
humano2-commits — Changes in the source repository
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(146) |
Jun
(188) |
Jul
(11) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|---|
|
From: <sv...@de...> - 2005-06-24 21:23:03
|
Author: marcelo
Date: 2005-06-24 17:23:07 -0400 (Fri, 24 Jun 2005)
New Revision: 1424
Modified:
humano2/trunk/Humano2.sln
humano2/trunk/changelog.txt
humano2/trunk/core/schema/pgsql/pgsql-03-view.sql
Log:
* Modified pgsql-03-view.sql which was causing error when loading from s=
cratch.
* Modified solution to start-up with Portal project
* Updated changelog.txt
Modified: humano2/trunk/Humano2.sln
=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/Humano2.sln 2005-06-24 21:19:31 UTC (rev 1423)
+++ humano2/trunk/Humano2.sln 2005-06-24 21:23:07 UTC (rev 1424)
@@ -7,10 +7,6 @@
ProjectSection(ProjectDependencies) =3D postProject
EndProjectSection
EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") =3D "Humano2.Core.Db.M=
ssql", "core\db\mssql\Humano2.Core.Db.Mssql.csproj", "{EF59AEF0-F80D-4F6E=
-9DEA-2EE58E5B81D6}"
- ProjectSection(ProjectDependencies) =3D postProject
- EndProjectSection
-EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") =3D "Humano2.Core.Db.P=
gsql", "core\db\pgsql\Humano2.Core.Db.Pgsql.csproj", "{C00E6659-2370-4074=
-AF26-5A28B55DD288}"
ProjectSection(ProjectDependencies) =3D postProject
EndProjectSection
@@ -77,10 +73,6 @@
{0CC5A8D4-547D-4283-B908-F4095E1D1A10}.Debug.Build.0 =3D Debug|.NET
{0CC5A8D4-547D-4283-B908-F4095E1D1A10}.Release.ActiveCfg =3D Release|.=
NET
{0CC5A8D4-547D-4283-B908-F4095E1D1A10}.Release.Build.0 =3D Release|.NE=
T
- {EF59AEF0-F80D-4F6E-9DEA-2EE58E5B81D6}.Debug.ActiveCfg =3D Debug|.NET
- {EF59AEF0-F80D-4F6E-9DEA-2EE58E5B81D6}.Debug.Build.0 =3D Debug|.NET
- {EF59AEF0-F80D-4F6E-9DEA-2EE58E5B81D6}.Release.ActiveCfg =3D Release|.=
NET
- {EF59AEF0-F80D-4F6E-9DEA-2EE58E5B81D6}.Release.Build.0 =3D Release|.NE=
T
{C00E6659-2370-4074-AF26-5A28B55DD288}.Debug.ActiveCfg =3D Debug|.NET
{C00E6659-2370-4074-AF26-5A28B55DD288}.Debug.Build.0 =3D Debug|.NET
{C00E6659-2370-4074-AF26-5A28B55DD288}.Release.ActiveCfg =3D Release|.=
NET
Modified: humano2/trunk/changelog.txt
=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/changelog.txt 2005-06-24 21:19:31 UTC (rev 1423)
+++ humano2/trunk/changelog.txt 2005-06-24 21:23:07 UTC (rev 1424)
@@ -1,6 +1,6 @@
$Id$
=20
-=3D=3D 5.0.beta7 - 2005-06-24 Revision: 1419 =3D=3D #update this line!!
+=3D=3D 5.0.beta7 - 2005-06-24 Revision: 1423 =3D=3D =20
=20
* Builder
* Interface for creation of folders, views, reports, and forms are un=
der xsl
Modified: humano2/trunk/core/schema/pgsql/pgsql-03-view.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-03-view.sql 2005-06-24 21:19:31=
UTC (rev 1423)
+++ humano2/trunk/core/schema/pgsql/pgsql-03-view.sql 2005-06-24 21:23:07=
UTC (rev 1424)
@@ -19,6 +19,8 @@
"viewName" character varying(50)
);
=20
+INSERT INTO "class" VALUES (1011, 27, 'view', 'view', 3, false, false, N=
ULL);
+
INSERT INTO entity ("id_entity","domainId","class","delDate","status") V=
ALUES (1011, 10, 2, NULL, NULL);
INSERT INTO entity ("id_entity","domainId","class","delDate","status") V=
ALUES (1012, 10, 13, NULL, NULL);
INSERT INTO entity ("id_entity","domainId","class","delDate","status") V=
ALUES (1013, 10, 13, NULL, NULL);
@@ -30,8 +32,6 @@
INSERT INTO entity ("id_entity","domainId","class","delDate","status") =
VALUES (1404,10,1011,NULL,NULL);
INSERT INTO entity ("id_entity","domainId","class","delDate","status") =
VALUES (1405,10,1011,NULL,NULL);
=20
-INSERT INTO "class" VALUES (1011, 27, 'view', 'view', 3, false, false, N=
ULL);
-
INSERT INTO attribute VALUES (1012, 1011, 'columns', 'columns', 0.00, fa=
lse, true, false, true, false, false, false, false, NULL, 't', 0);
INSERT INTO attribute VALUES (1013, 1011, 'where', 'where', 0.00, false,=
true, false, true, false, false, false, false, NULL, 't', 0);
INSERT INTO attribute VALUES (1014, 1011, 'groupby', 'groupby', 0.00, fa=
lse, true, false, true, false, false, false, false, NULL, 't', 0);
|
|
From: <sv...@de...> - 2005-06-24 21:19:27
|
Author: pcamacho Date: 2005-06-24 17:19:31 -0400 (Fri, 24 Jun 2005) New Revision: 1423 Modified: humano2/trunk/components/webTools/Makefile Log: CHANGE: add Humano2.Components.Rules to Makefile. Modified: humano2/trunk/components/webTools/Makefile =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/components/webTools/Makefile 2005-06-24 20:51:50 UTC (r= ev 1422) +++ humano2/trunk/components/webTools/Makefile 2005-06-24 21:19:31 UTC (r= ev 1423) @@ -21,6 +21,6 @@ all: $(dll) $(subs) =20 $(dll): *.cs - $(csc) $(opts) /out:$@ /r:System.Data,System.Web,$(bindir)/Humano2.Core= ,$(bindir)/Humano2.Core.Db,$(bindir)/Humano2.Components.ViewTools,$(bindi= r)/Humano2.Components.Formulas /t:library /doc:$(docdir)/$(namespace).xml= $^ + $(csc) $(opts) /out:$@ /r:System.Data,System.Web,$(bindir)/Humano2.Core= ,$(bindir)/Humano2.Core.Db,$(bindir)/Humano2.Components.ViewTools,$(bindi= r)/Humano2.Components.Formulas,$(bindir)/Humano2.Components.Rules /t:libr= ary /doc:$(docdir)/$(namespace).xml $^ =20 .PHONY: all |
|
From: <sv...@de...> - 2005-06-24 20:51:59
|
Author: pcamacho
Date: 2005-06-24 16:51:50 -0400 (Fri, 24 Jun 2005)
New Revision: 1422
Modified:
humano2/trunk/components/webTools/interfacetools.cs
Log:
FIX: Creation of view: the order by default was with the second column in=
the list of the selected columns by the=20
user, not the first.
Modified: humano2/trunk/components/webTools/interfacetools.cs
=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/components/webTools/interfacetools.cs 2005-06-24 20:03:=
06 UTC (rev 1421)
+++ humano2/trunk/components/webTools/interfacetools.cs 2005-06-24 20:51:=
50 UTC (rev 1422)
@@ -244,7 +244,7 @@
public static string GetFirstColumnForOrder(string receivedColum=
n)
{
string [] columns =3D receivedColumn.Split(",".ToCharArray()=
);
- string res =3D columns[1] + "|0";=20
+ string res =3D columns[0] + "|0";=20
return res; =20
}
=20
|
|
From: <sv...@de...> - 2005-06-24 20:03:02
|
Author: pcamacho Date: 2005-06-24 16:03:06 -0400 (Fri, 24 Jun 2005) New Revision: 1421 Added: humano2/trunk/components/webTools/string.cs Modified: humano2/trunk/web/portal/site/report.aspx.cs Log: * FIX: bug #209. * ADD: string.cs file: to put all string tricky funny useful functions of= the code. Added: humano2/trunk/components/webTools/string.cs =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/components/webTools/string.cs 2005-06-24 19:44:58 UTC (= rev 1420) +++ humano2/trunk/components/webTools/string.cs 2005-06-24 20:03:06 UTC (= rev 1421) @@ -0,0 +1,36 @@ +// +// The Humano2 Business solution. +// Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) +// +// This program is free software; you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation; either version 2 of the License, or +// (at your option) any later version. +// +// $Id$ +// + +using System; +using System.Web; +using System.Web.UI.WebControls; +using System.IO; + +using Humano2.Core; +using Humano2.Core.Db; + + +namespace Humano2.Components.WebTools +{ + /// <summary> + /// This class contains all useful string functions + /// </summary> + public class H2String + { + public static string EscapeStr(string strToEscape, string from, string= to) =20 + { + string res; + res =3D strToEscape.Replace(from,to); + return res; + } + } +} Property changes on: humano2/trunk/components/webTools/string.cs ___________________________________________________________________ Name: svn:keywords + Id Modified: humano2/trunk/web/portal/site/report.aspx.cs =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/portal/site/report.aspx.cs 2005-06-24 19:44:58 UTC = (rev 1420) +++ humano2/trunk/web/portal/site/report.aspx.cs 2005-06-24 20:03:06 UTC = (rev 1421) @@ -31,34 +31,34 @@ =20 namespace Portal.site { - /// <summary> - /// Summary description for showView. - /// </summary> - public class Report : basePage - { - =09 - int iniClass; + /// <summary> + /// Summary description for showView. + /// </summary> + public class Report : basePage + { + =20 + int iniClass; int idEntityReport; =20 -=09 - private void Page_Load(object sender, System.EventArgs e) - { + =20 + private void Page_Load(object sender, System.EventArgs e) + { } - + =20 /// <summary> /// </summary> override protected string createXml() { - string xmlString =3D""; //the result string - =20 - iniClass =3D 0; - idEntityReport =3D Convert.ToInt32(Request.QueryString["id_e= ntity"]); - =20 - DataTable viewRes =3D getViewTableRes(idEntityReport, out in= iClass); //For a report - =20 - xmlString =3D getXmlFromDatableView(viewRes,idEntityReport);= =20 - Logger.Log("report: xml: " + xmlString ,LogLevel.Trace); - return xmlString; + string xmlString =3D""; //the result string + =20 + iniClass =3D 0; + idEntityReport =3D Convert.ToInt32(Request.QueryString["id_entit= y"]); + =20 + DataTable viewRes =3D getViewTableRes(idEntityReport, out iniCla= ss); //For a report + =20 + xmlString =3D getXmlFromDatableView(viewRes,idEntityReport); = =20 + Logger.Log("report: xml: " + xmlString ,LogLevel.Trace); + return xmlString; } =20 ///<summary> @@ -79,106 +79,107 @@ =20 foreach(DataColumn col in viewRes.Columns)=20 { - string colName =3D col.ColumnName; - =20 - if(colName =3D=3D "instanceUrl") //Skip this col - {=20 - continue;=20 - } - =20 - if(colName =3D=3D "id_entity") //Skip this col and updat= e the list of group attributes - {=20 - xmlString +=3D"<attribute><value>id_entity</value><s= how>0</show></attribute>"; =20 - continue;=20 - } - if(colName.StartsWith("id_entity")) //Skip this col - {=20 - continue;=20 - } =20 - xmlString +=3D"<attribute>"; =20 - =20 - //Get the real user column name that corresponds to syst= em column name - string userColName =3D complex.ConvertSysAttNameToUserAt= tName(colName); - =20 - xmlString +=3D "<value>" - + userColName - + "</value><show>1</show>"; = =20 - xmlString +=3D "</attribute>"; + string colName =3D col.ColumnName; + =20 + if(colName =3D=3D "instanceUrl") //Skip this col + {=20 + continue;=20 } + =20 + if(colName =3D=3D "id_entity") //Skip this col and update th= e list of group attributes + {=20 + xmlString +=3D"<attribute><value>id_entity</value><show>0</s= how></attribute>"; =20 + continue;=20 + } + if(colName.StartsWith("id_entity")) //Skip this col + {=20 + continue;=20 + } =20 + xmlString +=3D"<attribute>"; =20 + =20 + //Get the real user column name that corresponds to system c= olumn name + string userColName =3D complex.ConvertSysAttNameToUserAttNam= e(colName); + =20 + xmlString +=3D "<value>" + + userColName + + "</value><show>1</show>"; =20 + xmlString +=3D "</attribute>"; + } xmlString +=3D "</attributes>"; =20 //Fill the xml string with the content of the table (view) foreach(DataRow row in viewRes.Rows) { - string groupValues =3D ""; //The list of values of attri= butes used in agrupation - xmlString +=3D "<instance>"; - foreach( DataColumn col in row.Table.Columns ) + string groupValues =3D ""; //The list of values of attribute= s used in agrupation + xmlString +=3D "<instance>"; + foreach( DataColumn col in row.Table.Columns ) + { + if(col.ColumnName =3D=3D "id_entity")//Get the id_entity= : for now it is not needed,=20 + { //but it may be us= eful later. + // xmlString +=3D "<id_entity>" + // row["id_entity"] + //+ "</id_entity>"; + =20 + xmlString +=3D "<value>" + + "<text>" + row[col] + "</text>"; + //Now check if the attribute is Primary + xmlString +=3D "<isPrimary>"; + if(complex.IsPrimary(col.ColumnName)) { - if(col.ColumnName =3D=3D "id_entity")//Get the i= d_entity: for now it is not needed,=20 - { //but it m= ay be useful later. - // xmlStri= ng +=3D "<id_entity>" - // row["i= d_entity"] - //+ "</id_= entity>"; - =20 - xmlString +=3D "<value>" - + "<text>" + row[col] = + "</text>"; - //Now check if the attribute is Primary - xmlString +=3D "<isPrimary>"; - if(complex.IsPrimary(col.ColumnName)) - { - xmlString +=3D "true"; - } - else - { - xmlString +=3D "false"; - } - xmlString +=3D "</isPrimary>"; - xmlString +=3D "<show>0</show>"; - xmlString +=3D "</value>"; - =20 - } - else //a standard value - { - string auxcolname; - =20 - auxcolname =3D col.ColumnName; - =20 - xmlString +=3D "<value>" - + "<text>" + row[c= ol] + "</text>"; - //Now check if the attribute is Primary - xmlString +=3D "<isPrimary>"; - if(complex.IsPrimary(col.ColumnName)) - { - xmlString +=3D "true"; - } - else - { - xmlString +=3D "false"; - } - xmlString +=3D "</isPrimary>"; - =20 - if(auxcolname.StartsWith("id_entity")) - { - xmlString +=3D "<show>0</show>"; - } - else - { - xmlString +=3D "<show>1</show>"; - } - =20 - //If the value corresponds to an attribute o= f group then add it to the list of values of group - string valueToCompare =3D Convert.ToString(c= omplex.ConvertSysAttNameToIdAttName(auxcolname)); - string fullValue; - if(isInArray( valueToCompare, - getGroupAttributes(idReport)= , - out fullValue)) //Careful: d= on't use fullValue as many target can have the same fullValue=3D> use the= NameValueCollection - { - groupValues +=3D row[col] + separator; - } - xmlString +=3D "</value>"; - } =20 + xmlString +=3D "true"; } + else + { + xmlString +=3D "false"; + } + xmlString +=3D "</isPrimary>"; + xmlString +=3D "<show>0</show>"; + xmlString +=3D "</value>"; =20 + } + else //a standard value + { + string auxcolname; + =20 + auxcolname =3D col.ColumnName; + =20 + xmlString +=3D "<value>" + + "<text>" + row[col] + "</text>"; + //Now check if the attribute is Primary + xmlString +=3D "<isPrimary>"; + if(complex.IsPrimary(col.ColumnName)) + { + xmlString +=3D "true"; + } + else + { + xmlString +=3D "false"; + } + xmlString +=3D "</isPrimary>"; + =20 + if(auxcolname.StartsWith("id_entity")) + { + xmlString +=3D "<show>0</show>"; + } + else + { + xmlString +=3D "<show>1</show>"; + } + =20 + //If the value corresponds to an attribute of group = then add it to the list of values of group + string valueToCompare =3D Convert.ToString(complex.C= onvertSysAttNameToIdAttName(auxcolname)); + string fullValue; + if(isInArray( valueToCompare, getGroupAttributes(i= dReport), out fullValue)) //Careful: don't use fullValue as many target c= an have the same fullValue=3D> use the NameValueCollection + { + groupValues +=3D row[col] + separator; + } + xmlString +=3D "</value>"; + } =20 + } + =20 + //Escape the groupValues string because a "/" of a date = is interpreted like path separator + groupValues =3D H2String.EscapeStr(groupValues,"/","%2F"= ); + =20 //Now add the details for every agrupacion //DataTable viewParamsTable =3D getViewTableRes(idEntity= Report, out iniClass); xmlString +=3D"<details>"; @@ -206,7 +207,7 @@ =20 return columnsTab; } - =20 + =20 private string getOperatorsList(int reportId, string separator) { string operators =3D ""; @@ -220,7 +221,7 @@ } return operators; } - =20 + =20 private string getXmlGroupAttributes(int reportId, string separa= tor) { string [] listAttGroup =3D getGroupAttributes(reportId); @@ -232,7 +233,7 @@ } return listAttGroupStr; } - + =20 private string getGroupByParam(int reportId) { absCrud crud =3D Factory.Crud(); @@ -288,23 +289,23 @@ =20 //FIXME this function exists also (identically) in search.aspx.c= s private DataTable makeDataTableInViewTools() - { - DataTable dt1 =3D new DataTable(); - DataColumn dc1; - dc1 =3D new DataColumn("columna",typeof(string)); - dt1.Columns.Add(dc1); - dc1 =3D new DataColumn("filtros",typeof(string)); - dt1.Columns.Add(dc1); - dc1 =3D new DataColumn("group",typeof(string)); - dt1.Columns.Add(dc1); - dc1 =3D new DataColumn("having",typeof(string)); - dt1.Columns.Add(dc1); - dc1 =3D new DataColumn("order",typeof(string)); - dt1.Columns.Add(dc1); - dc1 =3D new DataColumn("claves",typeof(string)); - dt1.Columns.Add(dc1); - return dt1; - } + { + DataTable dt1 =3D new DataTable(); + DataColumn dc1; + dc1 =3D new DataColumn("columna",typeof(string)); + dt1.Columns.Add(dc1); + dc1 =3D new DataColumn("filtros",typeof(string)); + dt1.Columns.Add(dc1); + dc1 =3D new DataColumn("group",typeof(string)); + dt1.Columns.Add(dc1); + dc1 =3D new DataColumn("having",typeof(string)); + dt1.Columns.Add(dc1); + dc1 =3D new DataColumn("order",typeof(string)); + dt1.Columns.Add(dc1); + dc1 =3D new DataColumn("claves",typeof(string)); + dt1.Columns.Add(dc1); + return dt1; + } =20 private DataTable getViewTableRes(int reportId, out int iniClass= ) { =20 @@ -383,27 +384,25 @@ return res; } =20 + #region Web Form Designer generated code + override protected void OnInit(EventArgs e) + { + // + // CODEGEN: This call is required by the ASP.NET Web Form De= signer. + // + InitializeComponent(); + base.OnInit(e); + } =20 - #region Web Form Designer generated code - override protected void OnInit(EventArgs e) - { - // - // CODEGEN: This call is required by the ASP.NET Web Form Designer. - // - InitializeComponent(); - base.OnInit(e); - } - =09 - /// <summary> - /// Required method for Designer support - do not modify - /// the contents of this method with the code editor. - /// </summary> - private void InitializeComponent() - { =20 - this.Load +=3D new System.EventHandler(this.Page_Load); - } - #endregion - - } - =20 + /// <summary> + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// </summary> + private void InitializeComponent() + { =20 + this.Load +=3D new System.EventHandler(this.Page_Load); + } + #endregion + =20 + } } |
|
From: <sv...@de...> - 2005-06-24 19:44:56
|
Author: marcelo
Date: 2005-06-24 15:44:58 -0400 (Fri, 24 Jun 2005)
New Revision: 1420
Added:
humano2/trunk/solutions/
humano2/trunk/solutions/README.TXT
humano2/trunk/solutions/pgsql-09-HelpDeskSMB.sql
Removed:
humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql
Modified:
humano2/trunk/changelog.txt
Log:
* Removed solutions schemas from core/schema and placed them under solut=
ions. No sub dir was created since in time, these Sql based schemas shoul=
d change to XML based.
Modified: humano2/trunk/changelog.txt
=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/changelog.txt 2005-06-24 19:38:52 UTC (rev 1419)
+++ humano2/trunk/changelog.txt 2005-06-24 19:44:58 UTC (rev 1420)
@@ -1,6 +1,6 @@
$Id$
=20
-=3D=3D 5.0.beta7 - 2005-06-24 Revision: 1355 =3D=3D #update this line!!
+=3D=3D 5.0.beta7 - 2005-06-24 Revision: 1419 =3D=3D #update this line!!
=20
* Builder
* Interface for creation of folders, views, reports, and forms are un=
der xsl
@@ -19,6 +19,7 @@
=20
* Other
* pertinence has now width and height property
+ * Solution Schemas have been moved to \solutions
=20
=3D=3D 5.0.beta6 - 2005-06-17 Revision: 1355 =3D=3D
=20
Deleted: humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.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-09-HelpDeskSMB.sql 2005-06-24 1=
9:38:52 UTC (rev 1419)
+++ humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql 2005-06-24 1=
9:44:58 UTC (rev 1420)
@@ -1,236 +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, linked) VALUES (=
10193, 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);
-
-
-SELECT setval('entity_id_entity_seq', 10250);
Added: humano2/trunk/solutions/README.TXT
=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/solutions/README.TXT 2005-06-24 19:38:52 UTC (rev 1419)
+++ humano2/trunk/solutions/README.TXT 2005-06-24 19:44:58 UTC (rev 1420)
@@ -0,0 +1,7 @@
+
+This are sample solutions and can all coexist in a CLEANLY installed dat=
abase.
+If you have already started to create clases and attributes, the instala=
tion of=20
+these solutions will fail due to conflict of IDs.
+
+Eventually these will change from Sql commands to XML and will be import=
ed by=20
+the system. In this way a solution can be incorporated at any point.
Added: humano2/trunk/solutions/pgsql-09-HelpDeskSMB.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/solutions/pgsql-09-HelpDeskSMB.sql 2005-06-24 19:38:52 =
UTC (rev 1419)
+++ humano2/trunk/solutions/pgsql-09-HelpDeskSMB.sql 2005-06-24 19:44:58 =
UTC (rev 1420)
@@ -0,0 +1,236 @@
+
+
+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, linked) VALUES (=
10193, 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" PR...
[truncated message content] |
|
From: <sv...@de...> - 2005-06-24 19:38:53
|
Author: marcelo Date: 2005-06-24 15:38:52 -0400 (Fri, 24 Jun 2005) New Revision: 1419 Added: humano2/trunk/core/schema/pgsql/patch-pgsql-Beta6.sql humano2/trunk/core/schema/pgsql/pgsql-01-metadata.sql humano2/trunk/core/schema/pgsql/pgsql-02-formulas.sql humano2/trunk/core/schema/pgsql/pgsql-03-view.sql humano2/trunk/core/schema/pgsql/pgsql-04-extendedAttributes.sql humano2/trunk/core/schema/pgsql/pgsql-05-rules.sql humano2/trunk/core/schema/pgsql/pgsql-06-form.sql humano2/trunk/core/schema/pgsql/pgsql-07-report.sql humano2/trunk/core/schema/pgsql/pgsql-08-folder.sql humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql Removed: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql humano2/trunk/core/schema/pgsql/pgsql-2-formulas.sql humano2/trunk/core/schema/pgsql/pgsql-3-view.sql humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql humano2/trunk/core/schema/pgsql/pgsql-5-rules.sql humano2/trunk/core/schema/pgsql/pgsql-6-form.sql humano2/trunk/core/schema/pgsql/pgsql-7-report.sql humano2/trunk/core/schema/pgsql/pgsql-8-folder.sql humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql Log: * Renaming files metamodel files along with patch file so that it does n= ot get included with the initial database creation. Copied: humano2/trunk/core/schema/pgsql/patch-pgsql-Beta6.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-01-metadata.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-02-formulas.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-2-formulas.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-03-view.sql (from rev 1418,= humano2/trunk/core/schema/pgsql/pgsql-3-view.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-04-extendedAttributes.sql (= from rev 1418, humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes= .sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-05-rules.sql (from rev 1418= , humano2/trunk/core/schema/pgsql/pgsql-5-rules.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-06-form.sql (from rev 1418,= humano2/trunk/core/schema/pgsql/pgsql-6-form.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-07-report.sql (from rev 141= 8, humano2/trunk/core/schema/pgsql/pgsql-7-report.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-08-folder.sql (from rev 141= 8, humano2/trunk/core/schema/pgsql/pgsql-8-folder.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql (from re= v 1418, humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql) Deleted: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.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-1-metadata.sql 2005-06-24 19:27= :13 UTC (rev 1418) +++ humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql 2005-06-24 19:38= :52 UTC (rev 1419) @@ -1,622 +0,0 @@ --- The Humano2 Business solution --- Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) --- --- This program is free software; you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- the Free Software Foundation; either version 2 of the License, or --- (at your option) any later version. =20 --- --- $Id$ - --- Este archivo contiene el eschema para la base de datos PostgreSQL de --- La meta data y sistema de Humano2. - -/* Create Tables */ -Create table "attribute" -( - "id_entity" Integer NOT NULL, - "classId" Integer NOT NULL, - "sysAttName" Varchar(50) NOT NULL, - "attName" Varchar(50) NOT NULL, - "order" Numeric(10,2) NOT NULL DEFAULT 0, - "isObligatory" Boolean NOT NULL DEFAULT 'f', -- No se puede crear si e= sto es true, pero el attributo no esta definido - "isActive" Boolean NOT NULL DEFAULT 't', -- Es activo (=3D habilitado)= en el definicion del class - "isSearchable" Boolean NOT NULL DEFAULT 't', -- Se debe habilitar para= full-text search.=20 - "isEditable" Boolean NOT NULL DEFAULT 't', -- Si se puede editar una v= ez creado. - "isSelfLookup" Boolean NOT NULL DEFAULT 'f', -- Para si este attributo= tiene la posibilidad de hacer un drilldown. - "isPrimary" Boolean NOT NULL DEFAULT 'f', -- Si es llave primaria (UNI= QUE, NOT NULL) - "isUnique" Boolean NOT NULL DEFAULT 'f', -- Si es el valor del attribu= to es unico en la class. - "isVirtual" Boolean NOT NULL DEFAULT 'f', -- Si el atributo es virtual= no genera una columna - "descAtt" text, -- Descripcion del attributo. - "protection" Boolean NOT NULL DEFAULT 'f', -- Para que no se puede bo= rrar a nivel del builder (=3D anti-condoro) - "display" Integer, - primary key ("id_entity") -); - - -Create table "option" -( - "id_entity" Integer NOT NULL, - "group" Integer NOT NULL, -- Grupo de opciones a la que pertenece la= opcion - "value" Varchar(50) NOT NULL, - "parent" Integer, -- Para relaciones entre opciones, Region, Comuna. - "isActiveOption" Boolean not null default 't', -- Si es activo. - "orderOption" Numeric(10,2), - primary key ("id_entity") -); - -Create table "boolean" -( - "id_entity" Integer NOT NULL, - "displayText" Varchar(20), -- FIXME. - "numTrueValue" Integer, -- Valor para displegar cuando Verda= dero - "numFalseValue" Integer, -- Valor para displegar cuando Falso - primary key ("id_entity") -); - -Create table "class" -( - "id_entity" Integer NOT NULL, - "classType" Integer NOT NULL, -- Tipo de clase - "sysName" Varchar(50) NOT NULL, -- Nombre de la tabla en la BD - "name" Varchar(50) NOT NULL, -- Nombre explicativo, human name - "parentId" Integer, -- Clase padre, de la cual se hereda. - "isAbstract" Boolean NOT NULL default 'f', -- significa que no se pued= e instanciar solo (como entity) - "isHidden" Boolean NOT NULL default 'f', -- significa que el class no = es visible al usuario.=09 - "descClass" text, - primary key ("id_entity") -); - -Create table "classType" -( - "id_entity" Integer NOT NULL, - "sysClassTypeName" Varchar(50) NOT NULL, - "parentClassType" Integer, - primary key ("id_entity") -); - -Create table "dateTime" -( - "id_entity" Integer NOT NULL, - "format" Integer, -- Pulldown con el formato del tiempo. FIXME - "dispHours" Integer, -- Pulldown de la resolucion del tiempo FIXME - "custom" Varchar(50),-- FIXME - primary key ("id_entity") -); - -Create table "domain" -( - "id_entity" Integer NOT NULL, - "domainName" Varchar(50), - "statusDomain" Integer,-- Pulldown de los estatus (deben ser Parte del = eschema inicial) FIXME.=20 - primary key ("id_entity") -); - -Create table "entity" -( - "id_entity" Serial, - "domainId" Integer NOT NULL, - "class" Integer NOT NULL, - "createDate" Timestamp NOT NULL DEFAULT NOW(), -- Momento de creacion - "modDate" Timestamp NOT NULL DEFAULT NOW(), -- Momento de modificacion - "delDate" Timestamp, -- Momento de borrar (NULL =3D Vivo) - "status" Varchar(40), - primary key ("id_entity") -); - -Create table "file" -( - "id_entity" Integer NOT NULL, - "maxsize" integer NOT NULL, -- Tamano maximo para subir en Kilobytes. - "path" Varchar(50), -- Ubicacion en el sistema de archivos. - "extensions" Varchar(50), -- Extenciones de archivos permitidos. - "linked" Boolean, -- CAREFUL!! Don't put "link" for this column:= causes problem with xsl then - primary key ("id_entity") -); - -Create table "inheritance" -( - "id_entity" Integer NOT NULL, - "from" Integer NOT NULL, - "to" Integer NOT NULL, - primary key ("id_entity") -); - -Create table "numeric" -( - "id_entity" Integer NOT NULL, - "decimals" Integer, -- Cantidad de decimales despues de la comma (para = la creacion de Numeric(x,y)) - "max" Integer, -- Valor maximo que se puede guardar en el numeric. - "min" Integer, - "default" Integer, - primary key ("id_entity") -); - -Create table "pertinence" -( - "id_entity" Integer NOT NULL, - "owner" Integer NOT NULL, -- El id de la columna que posee las refer= encias - "to" Integer NOT NULL, -- Tabla a la cual conecta esta relacion - "ratio" char(3) NOT NULL, -- Relacion (n:1, 1:n, n:m) - "parentPertinence" Integer, -- Padre de la relacion. - "visualAttrib" Integer, -- Attributo que se trae desde la tabla fora= nea. Si es null se trae la llave del metadata - "filterView" Text, -- Un filter sobre los pertinences que se muestr= an. -- FIXME: Is this the cleanst solution? - "widthPertinence" Integer, -- Width to display the pert= inence - "heightPertinence" Integer, -- Height to display - primary key ("id_entity") -); - -Create table "choice" -( - "id_entity" Integer NOT NULL, - "groupType" Integer NOT NULL, -- Grupo de opciones asociado a esta ele= ccion - "parentChoice" Integer, -- Para relaciones entre opciones, Region, Co= muna. - primary key ("id_entity") -); - -Create table "text" -( - "id_entity" Integer NOT NULL, - "rows" Integer NOT NULL, -- Numero of rows for the TextArea - "cols" Integer NOT NULL, -- Numero of columns for the TextArea - "isHtml" Boolean NOT NULL DEFAULT 'f', - primary key ("id_entity") -); - -Create table "textline" -( - "id_entity" Integer NOT NULL, - "maxLength" Integer, - "minLength" Integer, - "defaultText" Varchar(50), -- Default value - "dispSize" Integer, -- Tamano para displegar - primary key ("id_entity") -); - -Create table "user" -( - "id_entity" Integer NOT NULL, - "email" Varchar(50), - "pass" Varchar(50), -- plaintext password. - primary key ("id_entity") -); - -Create table "user_domain" -- Relacion entre usuarios y dominios. -( - "id_entity" Integer NOT NULL, - "userTable" Integer NOT NULL, - "domainTable" Integer NOT NULL, - primary key ("id_entity") -); - -Create table "optionGroup" -( - "id_entity" Integer NOT NULL, - "optionGroupName" Varchar(50), -- Default value - primary key ("id_entity") -); - -Create table "displayAttribute" -( - "id_entity" Integer NOT NULL, - "xslt" Varchar(50), -- Default value - "attTypeRef" Integer, - primary key ("id_entity") -); - -Create table "version" -( - "id_entity" Integer NOT NULL, - "versionItem" Varchar(50),=09 - "versionValue" Varchar(50),=09 - primary key ("id_entity") -); - -/* Create Foreign Keys */ -Alter table "boolean" add foreign key ("id_entity") references "attrib= ute" ("id_entity") on update restrict on delete cascade; -Alter table "dateTime" add foreign key ("id_entity") references "attri= bute" ("id_entity") on update restrict on delete cascade; -Alter table "file" add foreign key ("id_entity") references "attribut= e" ("id_entity") on update restrict on delete cascade; -Alter table "inheritance" add foreign key ("id_entity") references "att= ribute" ("id_entity") on update restrict on delete restrict; -Alter table "numeric" add foreign key ("id_entity") references "attrib= ute" ("id_entity") on update restrict on delete cascade; -Alter table "pertinence" add foreign key ("id_entity") references "attr= ibute" ("id_entity") on update restrict on delete cascade; -Alter table "choice" add foreign key ("id_entity") references "attribu= te" ("id_entity") on update restrict on delete cascade; -Alter table "text" add foreign key ("id_entity") references "attribut= e" ("id_entity") on update restrict on delete cascade; -Alter table "textline" add foreign key ("id_entity") references "attri= bute" ("id_entity") on update restrict on delete cascade; -Alter table "attribute" add foreign key ("classId") references "class"= ("id_entity") on update restrict on delete cascade; -Alter table "entity" add foreign key ("class") references "class" ("id= _entity") on update restrict on delete restrict; -Alter table "class" add foreign key ("classType") references "classTy= pe" ("id_entity") on update restrict on delete cascade; -Alter table "user_domain" add foreign key ("userTable") references "use= r" ("id_entity") on update restrict on delete cascade; -Alter table "user_domain" add foreign key ("domainTable")references "do= main" ("id_entity") on update restrict on delete cascade; - -/* Initial Data */ - -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (1,'metaModel',NULL); -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (27,'component',NULL); -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (29,'solutionData',NULL); - -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (1,1, 'classType','classType',3,'f',= 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (2,1, 'class','class',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (3,1, 'entity','entity',NULL,'t','f'= ); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (5,1, 'attribute','attribute',3,'t','= f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (6,27, 'domain','domain',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (7,27, 'user','user',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (8,1, 'textline','textline',5,'f', 'f= '); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (9,1, 'numeric','numeric',5,'f', 'f')= ; -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (12,1,'dateTime','dateTime',5,'f', 'f= '); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (13,1,'text','text',5,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (14,1,'inheritance','inheritance',5,'= f', 't'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (15,1,'choice','choice',81,'f', 't'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (26,27,'user_domain','user_domain',3,= 'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (39,1,'file','file',5,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (80,1, 'option','option',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (81,1,'pertinence','pertinence',5,'f'= , 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (82,1,'boolean','boolean',5,'f', 'f')= ; -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (130,1,'optionGroup','optionGroup',3,= 'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (149,1,'displayAttribute','displayAtt= ribute',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (153,1,'version','version',3,'f', 'f'= ); - -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (1,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (2,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (3,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (4,10,14,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (5,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (6,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (7,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (8,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (9,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (10,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (11,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (12,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (13,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (14,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (15,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (16,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (17,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (18,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (19,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (20,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (21,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (22,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (23,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (24,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (25,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (26,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (27,10,1,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (28,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (29,10,1,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (30,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (31,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (32,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (33,10,14,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (34,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (35,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (36,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (37,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (39,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (40,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (41,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (42,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (43,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (44,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (45,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (46,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (47,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (48,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (49,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (50,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (51,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (52,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (53,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (54,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (55,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (56,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (57,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (58,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (60,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (61,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (62,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (63,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (64,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (65,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (66,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (67,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (68,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (69,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (70,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (71,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (72,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (73,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (74,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (75,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (76,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (77,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (78,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (80,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (81,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (82,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (83,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (84,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (85,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (86,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (102,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (103,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (104,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (105,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (106,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (107,10,13,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (108,10,13,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (109,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (110,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (111,109,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (112,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (113,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (114,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (116,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (117,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (118,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (119,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (120,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (121,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (122,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (123,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (124,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (125,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (126,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (127,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (128,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (129,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (130,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (131,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (132,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (133,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (134,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (135,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (136,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (137,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (138,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (139,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (140,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (141,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (142,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (143,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (144,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (145,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (146,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (147,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (148,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (149,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (150,10,39,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (151,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (152,10,13,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (153,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (154,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (155,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (156,10,153,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (157,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (158,10,9,NULL,NULL); - -=20 -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (4,1,'parentCla= ssType','parentId',4,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (16,6,'domainNa= me','name',1,'t','t','t','t','t','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (17,6,'statusDo= main','status',2,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (18,7,'email','= email',0,'f','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (19,7,'pass','p= ass',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (20,80,'group',= 'group',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (21,80,'value',= 'value',0,'t','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (22,80,'parent'= ,'parent',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (23,80,'isActiv= eOption','isActive',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (24,80,'orderOp= tion','order',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","isVirtual","protection","display") VALUES (25= ,7,'domains','domains',0,'f','t','f','f','t','f','f','t','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (30,1,'sysClass= TypeName','sysName',0,'t','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (31,2,'classTyp= e','classType',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (32,2,'sysName'= ,'sysName',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (33,2,'parentId= ','parentId',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (34,3,'domainId= ','domainId',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (35,3,'class','= class',0,'t','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (36,3,'delDate'= ,'delDate',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (37,3,'status',= 'status',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (40,5,'classId'= ,'classId',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (41,5,'order','= order',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (42,5,'attName'= ,'name',-1,'t','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (43,8,'maxLengt= h','maximum size',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (44,8,'minLengt= h','minimum size',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (45,8,'defaultT= ext','default',0,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (46,8,'dispSize= ','dispSize',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (47,9,'decimals= ','decimals',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (48,9,'max','ma= x',0,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (49,9,'min','mi= n',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (50,9,'default'= ,'default',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (51,12,'format'= ,'format',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (52,12,'dispHou= rs','dispHours',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (53,13,'cols','= cols',0,'t','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (54,13,'rows','= rows',0,'t','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (55,13,'isHtml'= ,'isHtml',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (56,14,'from','= from',0,'f','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (57,14,'to','to= ',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (60,15,'groupTy= pe','group',0,'f','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (61,5,'isObliga= tory','isObligatory',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (62,5,'isActive= ','isActive',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (63,5,'isSearch= able','isSearchable',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (64,5,'isEditab= le','isEditable',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (65,5,'isSelfLo= okup','isSelfLookup',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (66,2,'name','n= ame',0,'t','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (67,5,'isPrimar= y','isPrimary',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (68,12,'custom'= ,'custom',0,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (69,5, 'protect= ion','protection',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (70,81,'owner',= 'owner',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (71,81,'to','to= ',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (72,81,'ratio',= 'ratio',0,'f','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (76,82,'display= Text','displayText',0,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (77,82,'numTrue= Value','numTrueValue',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (78,82,'numFals= eValue','numFalseValue',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (83,39,'maxsize= ','maxsize',1,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (84,39,'path','= path',2,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (85,39,'extensi= ons','extensions',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (86,39,'linked'= ,'linked',4,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (102,2,'isAbstr= act','isAbstract',5,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (103,5,'sysAttN= ame','sysName',0,'t','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (104,3,'createD= ate','createDate',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (105,3,'modDate= ','modDate',0,'t','f','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (106,5,'isUniqu= e','isUnique',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (107,5,'descAtt= ','desc',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (108,2,'descCla= ss','description',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (114,5,'isVirtu= al','isVirtual',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (125,2,'isHidde= n','isHidden',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","isVirtual","protection","display") VALUES (12= 6,6,'users','users',0,'f','t','f','f','t','f','f','t','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (127,26,'domain= Table','domainTable',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (128,26,'userTa= ble','userTable',0,'f','t','f','f','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (129,81,'parent= Pertinence','parentId',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (131,130,'optio= nGroupName','name',0,'f','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (134,5,'display= ','display',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (136,15,'parent= Choice','parent',0,'f','t','f','f','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (137,81,'visual= Attrib','visualAttrib',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (150,149,'xslt'= ,'xslt',0,'t','t','f','t','f','t','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (151,149,'attTy= peRef','attTypeRef',0,'t','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (152,81,'filter= View','filterView',0,'f','t','f','f','f','f','f','t',null); - -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (157,81,'widthP= ertinence','width (in pixels)',0,'f','t','f','t','f','f','f','t',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (158,81,'height= Pertinence','height (in pixels)',0,'f','t','f','t','f','f','f','t',null); - -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (154,153,'versi= onItem','versionItem',0,'t','t','f','f','f','t','t','f',null); -INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","= order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku= p","isPrimary","isUnique","protection","display") VALUES (155,153,'versi= onValue','versionValue',0,'t','t','f','f','f','f','f','f',null); - -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (17,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (24,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (41,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (43,0,255,1,20); -- textLine maxLength -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (44,0,255,0, 0); -- textLine minLength -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (46,0,255,1,20); -- textLine dispSize -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (47,0, 25, 0, 3); -- numeric decimals -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (48,0,NULL,NULL, 10000000); -- numeric max -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (49,0,NULL,NULL,-10000000); -- numeric min -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (50,0,NULL,NULL, NULL); -- numeric default=20 -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (53,0,100,1,30); -- text cols -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (54,0,50, 1, 7); -- text rows -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (77,0,NULL,NULL,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (83,2,10,0,1); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (157,4,NULL,NULL,200); -- pertinence width -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (158,4,NULL,NULL,200); -- pertinence height - -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (16,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (18,25,1,25); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (19,10,6,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (21,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (30,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (32,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (37,40,35,40); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (66,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (42,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (45,50,0,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (68,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (72,10,3,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (76,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (84,20,0,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (131,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (154,50,1,50); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (155,50,1,50); - - -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (36,116,118,NULL); -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (104,116,118,NULL); -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (105,116,118,NULL); - - -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (23,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (55,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (61,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (62,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (63,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (64,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (65,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (67,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (86,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (102,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (106,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (114,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (125,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (69,NULL,1,NULL); - - -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (20,20,5,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (22,22,80,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (25,128,26,'n:m',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (31,31,1,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (34,34,6,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (35,35,2,'n:1',NULL); -- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (40,40,2,'n:1',NULL); -- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (51,51,80,'n:1',NULL); -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (52,52,80,'n:1',NULL); -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (56,56,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (57,57,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (60,60,130,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (70,70,5,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (71,71,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (126,127,26,'n:m',25);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (127,127,6,'n:1',25);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (128,128,7,'n:1',25);-- ok -INSERT INTO "per... [truncated message content] |
|
From: <sv...@de...> - 2005-06-24 19:27:11
|
Author: marcelo
Date: 2005-06-24 15:27:13 -0400 (Fri, 24 Jun 2005)
New Revision: 1418
Modified:
humano2/trunk/changelog.txt
Log:
* Modified changelog.txt
Modified: humano2/trunk/changelog.txt
=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/changelog.txt 2005-06-24 19:19:54 UTC (rev 1417)
+++ humano2/trunk/changelog.txt 2005-06-24 19:27:13 UTC (rev 1418)
@@ -1,17 +1,26 @@
$Id$
=20
-=3D=3D 5.0.beta7 - 2005-06-03 Revision: 1355 =3D=3D #update this line!!
+=3D=3D 5.0.beta7 - 2005-06-24 Revision: 1355 =3D=3D #update this line!!
=20
* Builder
- * Interface for creation of folders, views, reports, and forms are un=
der xsl and have the same css / js motor
+ * Interface for creation of folders, views, reports, and forms are un=
der xsl
+ and have the same css / js motor
+ * Modified inteface/engine for building formulas
=20
* Portal
- * patch to allow viewing well two pertinences attribute columns to th=
e same class. =20
+ * patch to allow viewing well two pertinences attribute columns to th=
e same=20
+ class.
+ * Rules are calculated when saving an entity
+ * search works for upper/lower case
+ * Views display pertinence attributes in the form of=20
+ attributeName.foreignAttributeName
+ * Views can now have dynamic values, such as [CurrentUser.UserName] t=
o create
+ dynamic views such as "My accunts"
=20
* Other
* pertinence has now width and height property
=20
-=3D=3D 5.0.beta6 - 2005-06-03 Revision: 1355 =3D=3D
+=3D=3D 5.0.beta6 - 2005-06-17 Revision: 1355 =3D=3D
=20
* Builder
* Added capability to upload a file to be imported
@@ -24,13 +33,14 @@
* Exportation now exports with column names
=09
* Other
- * Updated Import proyect which is a stand alone executable which impor=
ts flat files to the database
+ * Updated Import proyect which is a stand alone executable which impor=
ts=20
+ flat files to the database
* Install instruction in spanish for windows.=09
=09
Full details at http://devel.humano2.org/trac/report/11
=20
=20
-=3D=3D 5.0.beta5 - 2005-06-03 Revision: 1288 =3D=3D
+=3D=3D 5.0.beta5 - 2005-06-10 Revision: 1288 =3D=3D
=20
* Databases
* Changed paging logic in ViewTools so that it works in MsSql
|
|
From: <sv...@de...> - 2005-06-24 19:19:49
|
Author: marcelo
Date: 2005-06-24 15:19:54 -0400 (Fri, 24 Jun 2005)
New Revision: 1417
Modified:
humano2/trunk/web/builder/site/exeFormByAttribute.aspx.cs
Log:
* Modified catch to include system errors in message to user.
Modified: humano2/trunk/web/builder/site/exeFormByAttribute.aspx.cs
=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/exeFormByAttribute.aspx.cs 2005-06-24 =
19:14:10 UTC (rev 1416)
+++ humano2/trunk/web/builder/site/exeFormByAttribute.aspx.cs 2005-06-24 =
19:19:54 UTC (rev 1417)
@@ -96,10 +96,10 @@
/* Fin lineas para depurar */
=20
}
- catch
+ catch (Exception ex)
{
//Se intenta eliminar la tabla temporal, por si hubo un error antes=
...
- Response.Write("There was an error while executing the formula");
+ Response.Write("There was an error while executing the formula : " =
+ ex.Message + ":" + ex.InnerException);
string sql =3D "DROP table tbltempfx"+attributeId;
try
{
|
|
From: <sv...@de...> - 2005-06-24 19:14:16
|
Author: cristian
Date: 2005-06-24 15:14:10 -0400 (Fri, 24 Jun 2005)
New Revision: 1416
Modified:
humano2/trunk/components/webTools/Adapter.cs
humano2/trunk/components/webTools/Humano2.Components.WebTools.csproj
humano2/trunk/web/portal/site/instance.aspx.cs
Log:
* Modificacion en el portal, para que las reglas se ejcuten al editar una=
instancia, tal como ocurre con las formulas.
Modified: humano2/trunk/components/webTools/Adapter.cs
=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/components/webTools/Adapter.cs 2005-06-24 17:48:12 UTC =
(rev 1415)
+++ humano2/trunk/components/webTools/Adapter.cs 2005-06-24 19:14:10 UTC =
(rev 1416)
@@ -21,8 +21,8 @@
using Humano2.Core.Db;
using Humano2.Components.ViewTools;
using Humano2.Components.Formulas;
+using Humano2.Components.Rules;
=20
-
namespace Humano2.Components.WebTools
{
/// <summary>
@@ -1709,6 +1709,25 @@
}
return (int[]) res.ToArray(typeof(int));
}
+
+ /// <summary>
+ /// Busca las reglas de una clase y las ejecuta...
+ /// </summary>
+ /// <param name=3D"classId"></param>
+ /// <param name=3D"id_entity"></param>
+ public void RulesForClass(int classId, int id_entity)
+ {
+ SessionCredencial userCred;
+ userCred =3D SessionManager.Current.GetSession(Cookies.Get(WebConst.S=
essionCookie));
+ int domainId =3D userCred.DomainIds[userCred.CurrentDomainIndex];
+
+ RulesH2 myrules =3D new RulesH2();
+ DataTable dtrules =3D myrules.GetRulesForClass(domainId,classId);
+ if(dtrules.Rows.Count>0)
+ {
+ myrules.ExecuteRules(domainId,dtrules,id_entity);
+ }
+ }
=09
/// <summary>
/// Busca las formulas de una clase y las ejecuta...
Modified: humano2/trunk/components/webTools/Humano2.Components.WebTools.c=
sproj
=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/components/webTools/Humano2.Components.WebTools.csproj =
2005-06-24 17:48:12 UTC (rev 1415)
+++ humano2/trunk/components/webTools/Humano2.Components.WebTools.csproj =
2005-06-24 19:14:10 UTC (rev 1416)
@@ -104,6 +104,11 @@
Project =3D "{0CC5A8D4-547D-4283-B908-F4095E1D1A10}"
Package =3D "{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}"
/>
+ <Reference
+ Name =3D "Humano2.Components.Rules"
+ Project =3D "{955FF650-7CB5-4F1F-9831-A50BB0EE3D1B}"
+ Package =3D "{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}"
+ />
</References>
</Build>
<Files>
Modified: humano2/trunk/web/portal/site/instance.aspx.cs
=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/portal/site/instance.aspx.cs 2005-06-24 17:48:12 UT=
C (rev 1415)
+++ humano2/trunk/web/portal/site/instance.aspx.cs 2005-06-24 19:14:10 UT=
C (rev 1416)
@@ -134,6 +134,7 @@
try
{
dbAdapter.FormulasForClass(classid,idEntity);
+ dbAdapter.RulesForClass(classid,idEntity);
}
catch
{
|
|
From: <sv...@de...> - 2005-06-24 17:48:11
|
Author: pcamacho
Date: 2005-06-24 13:48:12 -0400 (Fri, 24 Jun 2005)
New Revision: 1415
Modified:
humano2/trunk/components/viewTools/ViewTools.cs
humano2/trunk/components/webTools/Adapter.cs
humano2/trunk/web/portal/site/showView.aspx.cs
Log:
FIX: ticket #228. Now viewtools has the possibility to be case unsensitiv=
e for WHERE condition using operator=20
StartsWith or ContainsTo.
Modified: humano2/trunk/components/viewTools/ViewTools.cs
=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/components/viewTools/ViewTools.cs 2005-06-24 16:22:29 U=
TC (rev 1414)
+++ humano2/trunk/components/viewTools/ViewTools.cs 2005-06-24 17:48:12 U=
TC (rev 1415)
@@ -34,6 +34,7 @@
private int _page, _rowcount, _pageview, _totalRecordCount;
private string _tempTable;
private string _whereInit =3D "";
+ private bool _caseSensitive; //To allow doing insensitive case s=
earch
#endregion
=20
#region "CONSTRUCTORES"
@@ -80,6 +81,19 @@
this._rowcount =3D value;
}
}
+ =20
+ public bool CaseSensitive
+ {
+ get
+ {
+ return this._caseSensitive;
+ }
+ set
+ {
+ this._caseSensitive =3D value;
+ } =20
+ }
+ =20
public int PageView
{
get
@@ -824,13 +838,23 @@
break;
}
=20
+ //To do sensitive or insensitive search
+ string like =3D "";
+ if(CaseSensitive)
+ {
+ like=3D"LIKE";
+ }
+ else
+ {
+ like=3D"ILIKE"; =20
+ }
switch(intFilter)
{
case (int)Enums.Condition.BeginWith:
- strFilters.Append("LIKE '" + endArgument + "%' ");
+ strFilters.Append(like + " '" + endArgument + "%' ");
break;
case (int)Enums.Condition.ContainsTo:
- strFilters.Append("LIKE '%" + endArgument + "%' ");
+ strFilters.Append(like +" '%" + endArgument + "%' ");
break;
case (int)Enums.Condition.DistinctTo:
strFilters.Append("<> " + endArgument + " ");
@@ -1116,7 +1140,7 @@
strFilters.Append("LIKE '" + parameter.ToString() + "%' ");
break;
case (int)Enums.Condition.ContainsTo:
- strFilters.Append("LIKE '%" + parameter.ToString() + "%' ");
+ strFilters.Append("ILIKE '%" + parameter.ToString() + "%' ");
break;
case (int)Enums.Condition.DistinctTo:
//If adicional agregado, pues ViewTools se caia cuando se comparab=
a con NULL
Modified: humano2/trunk/components/webTools/Adapter.cs
=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/components/webTools/Adapter.cs 2005-06-24 16:22:29 UTC =
(rev 1414)
+++ humano2/trunk/components/webTools/Adapter.cs 2005-06-24 17:48:12 UTC =
(rev 1415)
@@ -318,16 +318,23 @@
///<param name=3D"iniClass">The class that the DataTable's View sho=
uld act on.</param>
///<param name=3D"order">The ViewTools formated string with the ord=
er.</param>
///<param name=3D"page">The page that should be shown.</param>
- ///<param name=3D"keyFlag">The key Flag to use (0: for group=
by,1: without group)</param>
-
+ ///<param name=3D"keyFlag">The key Flag to use (0: for group by,=
1: without group)</param>
+ ///<param name=3D"caseSensitive">To know if we want case sensiti=
ve search or not. Use for search commonly</param>
///<returns>The datatable that is the result of executing the view.=
</returns>
- public DataTable ExecViewFromDataTable(int iniClass, DataTable vtTa=
ble, int idEntity, string order,=20
- int page, int keyFlag)
+ public DataTable ExecViewFromDataTable( int iniClass,=20
+ DataTable vtTable,=20
+ int idEntity,=20
+ string order,=20
+ int page,=20
+ int keyFlag,
+ bool caseSensitive)
{
// We got the data.. Do the viewTools invocation with the data.
Humano2.Components.ViewTools.ViewTools vt =3D new Humano2.Components.=
ViewTools.ViewTools(iniClass);
vt.Complex =3D complex;
- vt.KeyFlag=3DkeyFlag;
+ vt.KeyFlag =3D keyFlag;
+ vt.CaseSensitive =3D caseSensitive;
+ =20
if((order !=3D null) && (order !=3D""))
{=20
Logger.Log("ExecViewFromDataTable: " + "order!=3D \"\"",Lo=
gLevel.Trace);
Modified: humano2/trunk/web/portal/site/showView.aspx.cs
=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/portal/site/showView.aspx.cs 2005-06-24 16:22:29 UT=
C (rev 1414)
+++ humano2/trunk/web/portal/site/showView.aspx.cs 2005-06-24 17:48:12 UT=
C (rev 1415)
@@ -73,6 +73,7 @@
{
Logger.Log("=3D=3D=3D showView.aspx.cs =3D=3D=3D",LogLevel.T=
race);
}
+ =20
override protected string createXml()
{
string xmlString =3D""; //the result string
@@ -142,7 +143,7 @@
// The framework already puts a "," between multiple "order =
arguments.
Logger.Log("Before ExecViewFromDataTabe. iniClass=3D " + Con=
vert.ToString(iniClass),LogLevel.Trace);
=20
- DataTable viewRes =3D dbAdapter.ExecViewFromDataTable(iniCla=
ss, viewTable, idEntity, orderArr, currPage, 1);
+ DataTable viewRes =3D dbAdapter.ExecViewFromDataTable(iniCla=
ss, viewTable, idEntity, orderArr, currPage, 1, true);
viewRes =3D bigPatchForViewTools(viewRes,viewTable,iniClass,=
idEntity); //Only a big patch, see comment of the function....
=20
int pageCount=3D dbAdapter.NumberOfPagesInPagedView;
@@ -729,7 +730,8 @@
viewTable.Rows[0]["columns"] =3D "0," + col;
=20
adapter dbAdapter =3D userCred.CoreAdapter;
- DataTable res =3D dbAdapter.ExecViewFromDataTable(iniClass, =
viewTable, idEntity, "", 0, 1);
+ Logger.Log("order=3D " + viewTable.Rows[0]["order"],LogLevel=
.Trace);
+ DataTable res =3D dbAdapter.ExecViewFromDataTable(iniClass, =
viewTable, idEntity, "", 0, 1,false);
=20
//Build the column
int size =3D res.Rows.Count;
|
|
From: <sv...@de...> - 2005-06-24 16:22:27
|
Author: cristian
Date: 2005-06-24 12:22:29 -0400 (Fri, 24 Jun 2005)
New Revision: 1414
Modified:
humano2/trunk/web/builder/site/buildattribute.aspx.cs
Log:
Cambio en el constructor de formulas, para que traduzca correctamente...
Modified: humano2/trunk/web/builder/site/buildattribute.aspx.cs
=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/buildattribute.aspx.cs 2005-06-24 16:1=
3:05 UTC (rev 1413)
+++ humano2/trunk/web/builder/site/buildattribute.aspx.cs 2005-06-24 16:2=
2:29 UTC (rev 1414)
@@ -937,9 +937,14 @@
return fxTable;
}
=20
+ /// <summary>
+ /// Funcion que crea un arreglo asociativo para transformar de string a=
ids
+ /// </summary>
+ /// <param name=3D"formula"></param>
+ /// <param name=3D"classId"></param>
+ /// <returns></returns>
private string convToNumericFormula(string formula, int classId)
{
-
StringDictionary attrNameList =3D new StringDictionary();
DataTable attrTable =3D userCred.CoreAdapter.GetAttributesFromClass(cl=
assId);
foreach(DataRow row in attrTable.Rows)
@@ -965,7 +970,8 @@
{
string attName =3D Convert.ToString(row2["attName"]);
string className =3D Convert.ToString(dr["name"]);
- attrNameList[Convert.ToString(className+":"+attName)] =3D Convert=
.ToString(idatt.ToString()+"^"+row2["id_entity"]);
+ //attrNameList[Convert.ToString(className+":"+attName)] =3D Conve=
rt.ToString(idatt.ToString()+"^"+row2["id_entity"]);
+ attrNameList[Convert.ToString(attNamePert+"."+attName)] =3D Conve=
rt.ToString(idatt.ToString()+"^"+row2["id_entity"]);
if(row2["isPrimary"].ToString()=3D=3D"1")
{
attrNameList[Convert.ToString(attNamePert)] =3D Convert.ToString=
(idatt.ToString()+"^"+row2["id_entity"]);
@@ -978,6 +984,12 @@
=20
}
=20
+ /// <summary>
+ /// Funcion que traduce las formulas desde ids a palabras.
+ /// </summary>
+ /// <param name=3D"formula"></param>
+ /// <param name=3D"classId"></param>
+ /// <returns></returns>
private string convToReadableFormula(string formula, int classId)
{
=20
@@ -1005,7 +1017,8 @@
{
string attName =3D Convert.ToString(row2["attName"]);
string className =3D Convert.ToString(dr["name"]);
- attrIdList[Convert.ToString(idatt.ToString()+"^"+row2["id_entity"=
])] =3D Convert.ToString(className+":"+attName);
+ //attrIdList[Convert.ToString(idatt.ToString()+"^"+row2["id_entit=
y"])] =3D Convert.ToString(className+":"+attName);
+ attrIdList[Convert.ToString(idatt.ToString()+"^"+row2["id_entity"=
])] =3D Convert.ToString(attNamePert+"."+attName);
if(row2["isPrimary"].ToString()=3D=3D"1")
{
attrIdList[Convert.ToString(idatt.ToString()+"^"+row2["id_entity=
"])] =3D Convert.ToString(attNamePert);
|
|
From: <sv...@de...> - 2005-06-24 16:13:00
|
Author: marcelo Date: 2005-06-24 12:13:05 -0400 (Fri, 24 Jun 2005) New Revision: 1413 Added: humano2/trunk/web/builder/site/dataTable.aspx humano2/trunk/web/builder/site/dataTable.aspx.cs Log: * Temporary files to prove/disprove bug in mono. Added: humano2/trunk/web/builder/site/dataTable.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/dataTable.aspx 2005-06-24 03:48:05 UTC= (rev 1412) +++ humano2/trunk/web/builder/site/dataTable.aspx 2005-06-24 16:13:05 UTC= (rev 1413) @@ -0,0 +1,21 @@ +<%@ Page language=3D"c#" Codebehind=3D"dataTable.aspx.cs" AutoEventWireu= p=3D"false" Inherits=3D"Builder.site.dataTable" %> +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >=20 + +<html> + <head> + <title>dataTable</title> + <meta name=3D"GENERATOR" Content=3D"Microsoft Visual Studio .NET 7.1= "> + <meta name=3D"CODE_LANGUAGE" Content=3D"C#"> + <meta name=3Dvs_defaultClientScript content=3D"JavaScript"> + <meta name=3Dvs_targetSchema content=3D"http://schemas.microsoft.com= /intellisense/ie5"> + </head> + + <body MS_POSITIONING=3D"GridLayout"> +=09 + <form id=3D"Form1" method=3D"post" runat=3D"server"> + <asp:TextBox ID=3D"text1" Runat=3D"server" Width=3D"200px" Height=3D"2= 00" Rows=3D"10" Columns=3D"50" TextMode=3D"MultiLine"></asp:TextBox> + =09 + </form> +=09 + </body> +</html> Added: humano2/trunk/web/builder/site/dataTable.aspx.cs =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/dataTable.aspx.cs 2005-06-24 03:48:05 = UTC (rev 1412) +++ humano2/trunk/web/builder/site/dataTable.aspx.cs 2005-06-24 16:13:05 = UTC (rev 1413) @@ -0,0 +1,76 @@ +using System; +using System.Collections; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Web; +using System.Web.SessionState; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.HtmlControls; + +namespace Builder.site +{ + /// <summary> + /// Summary description for dataTable. + /// </summary> + public class dataTable : System.Web.UI.Page + { + protected System.Web.UI.WebControls.TextBox text1; + private void Page_Load(object sender, System.EventArgs e) + { + DataTable dt =3D new DataTable(); + DataRow dr; + dt.Columns.Add("column1",System.Type.GetType("System.Int32")); + dt.Columns.Add("column2",System.Type.GetType("System.Int32")); + dt.Columns.Add("result",System.Type.GetType("System.Int32")); + =09 + dr =3D dt.NewRow(); + dr["column1"] =3D 80; + dr["column2"] =3D 10; + dt.Rows.Add(dr); + + dr =3D dt.NewRow(); + dr["column1"] =3D 6; + dt.Rows.Add(dr); + =09 + dr =3D dt.NewRow(); + dr["column2"] =3D 4; + dt.Rows.Add(dr); + + dt.Columns["result"].Expression =3D "column1*column2/100"; + =09 + foreach(DataRow dr2 in dt.Rows) + { + text1.Text +=3D "Col1 \"" + dr2["column1"].ToString() + "\"\n"; + text1.Text +=3D "Col2 \"" + dr2["column2"].ToString() + "\"\n"; + text1.Text +=3D "Result \"" + dr2["result"].ToString() + "\"\n"; + Console.WriteLine("Col1 \"" + dr2["column1"].ToString() + "\""); + Console.WriteLine("Col2 \"" + dr2["column2"].ToString() + "\""); + Console.WriteLine("result \"" + dr2["result"].ToString() + "\""); + } + + =09 + } + + #region Web Form Designer generated code + override protected void OnInit(EventArgs e) + { + // + // CODEGEN: This call is required by the ASP.NET Web Form Designer. + // + InitializeComponent(); + base.OnInit(e); + } + =09 + /// <summary> + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// </summary> + private void InitializeComponent() + { =20 + this.Load +=3D new System.EventHandler(this.Page_Load); + } + #endregion + } +} |
|
From: <sv...@de...> - 2005-06-23 19:58:11
|
Author: pcamacho
Date: 2005-06-23 15:58:17 -0400 (Thu, 23 Jun 2005)
New Revision: 1409
Modified:
humano2/trunk/components/webTools/interfacetools.cs
Log:
FIX: in the interface for creation of views, not all pertinence attribute=
s where getted.=20
Modified: humano2/trunk/components/webTools/interfacetools.cs
=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/components/webTools/interfacetools.cs 2005-06-23 19:11:=
47 UTC (rev 1408)
+++ humano2/trunk/components/webTools/interfacetools.cs 2005-06-23 19:58:=
17 UTC (rev 1409)
@@ -260,8 +260,6 @@
string salida=3D"";
string className =3D "";
=20
- DataTable dt =3D userCred.CoreAdapter.GetAttributesFromClass(classId)=
;
-
adapter dbAdapter =3D new adapter();
className =3D dbAdapter.GetClassNameById(classId);
//className =3D dt.Rows[0]["name"].ToString();
@@ -271,45 +269,6 @@
salida +=3D "<name>" + className + "</name>";
salida +=3D "<attributes>";
=09
- /*
- =20
- foreach(DataRow row in dt.Rows)=20
- {
- string attName =3D Convert.ToString(row["attName"]);
- string attType =3D Convert.ToString(row["attType"]);
- if((attType=3D=3D"pertinence") && fullPert)
- {
- idatt =3D Convert.ToInt32(row["id_entity"]);
- dtpert =3D userCred.CoreAdapter.GetClassesFromPertinence(idatt);
- DataRow dr2 =3D dtpert.Rows[0];
- idClassRel =3D Convert.ToInt32(dr2["to"].ToString());
- =09
- =20
- //For each attribute of pertinence put the id with t=
ogo and=20
- // the pertname.attname
- int [] listAttId =3D GetAttributeIdListForClass(idCl=
assRel,userCred);
- string [] listAttName =3D getAttributeNameListForCla=
ss(idClassRel,userCred);
- int size =3D listAttId.Length;
- for(int i=3D0;i<size;i++)
- {
- attlogin =3D listAttId[i];
- salida +=3D "<attribute>";
- salida +=3D "<id>" + idatt + "^" + attlogin + "<=
/id>";
- salida +=3D "<name>" + attName + "." + listAttN=
ame[i]+ "</name>";
- salida +=3D "</attribute>";
- }
- }
- else
- {
- salida +=3D "<attribute>";
- salida +=3D "<id>" + row["id_entity"].ToString() + "</id>";
- salida +=3D "<name>" + attName + "</name>";
- salida +=3D "</attribute>";
- }
- }
- =20
- */
- =20
DataTable DtListAtt =3D GetAttribListForClass(classId, userC=
red,fullPert);
foreach(DataRow row in DtListAtt.Rows)
{
@@ -320,7 +279,6 @@
salida +=3D "<name>";
salida +=3D Convert.ToString(row["name"]);
salida +=3D "</name>";
- =20
salida +=3D "</attribute>";
}
=20
@@ -349,7 +307,6 @@
=20
foreach(DataRow row in dt.Rows)=20
{
- DataRow resRow =3D res.NewRow();
string attName =3D Convert.ToString(row["attName"]);
string attType =3D Convert.ToString(row["attType"]);
if((attType=3D=3D"pertinence") && fullPert)
@@ -366,17 +323,21 @@
int size =3D listAttId.Length;
for(int i=3D0;i<size;i++)
{
+ DataRow resRow =3D res.NewRow();
attlogin =3D listAttId[i];
resRow["id"] =3D idatt + "^" + attlogin;
resRow["name"] =3D attName + "." + listAttName[=
i];
+ res.Rows.Add(resRow);
}
}
else
{
+ DataRow resRow =3D res.NewRow();
resRow["id"] =3D row["id_entity"].ToString();
resRow["name"] =3D attName;
+ res.Rows.Add(resRow);
} =20
- res.Rows.Add(resRow);
+ =20
}
return res;
}
|
|
From: <sv...@de...> - 2005-06-23 19:11:51
|
Author: marcelo Date: 2005-06-23 15:11:47 -0400 (Thu, 23 Jun 2005) New Revision: 1408 Modified: humano2/trunk/INSTALL-LINUX.en.txt humano2/trunk/INSTALL-LINUX.es.txt humano2/trunk/INSTALL-WINDOWS.es.txt Log: * Updating installation manuals Modified: humano2/trunk/INSTALL-LINUX.en.txt =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/INSTALL-LINUX.en.txt 2005-06-23 17:27:09 UTC (rev 1407) +++ humano2/trunk/INSTALL-LINUX.en.txt 2005-06-23 19:11:47 UTC (rev 1408) @@ -1,29 +1,30 @@ $Id$ =20 -How to install Humano2 on Linux: -=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\ +| Installing Humano2 on Linux | +\=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/ =20 This and more documentation is available on the Humano2 developers -site: http://devel.humano2.org.=20 +site: http://devel.humano2.org as well as http://www.humano2.com/network =20 -If you have questions or suport, you can subscribe to the mailing +If you have questions or support, you can subscribe to the mailing lists at http://list.humano2.org and post your questions there.=20 =20 + Prerequisites: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 1. Get and Install Mono ( http://www.mono-project.com ) - Remark: if you are using Mono 1.1.6, configure it like that: - - ./configure -with-preview=3Dyes - (It is needed to compile XPS) - + Notice: if you are using Mono 1.1.6 or later, configure it -with-previe= w=3Dyes since it is needed to compile XPS: 2. Get and install PostgreSQL 8.0 or later ( http://www.postgresql.org = )=20 3. Get XSP (http://www.go-mono.com/archive/1.0.6/xsp-1.0.6.tar.gz) - 4. Get the latest Humano2 source code=20 - ( http://sourceforge.net/project/showfiles.php?group_id=3D117865&pac= kage_id=3D152308 ) =20 + Compiling: - 1. Compile the code with make: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + 1. Get the latest Humano2 source code=20 + ( http://sourceforge.net/project/showfiles.php?group_id=3D117865&pac= kage_id=3D152308 ) + 2. Compile the code with make: =20 $ make =20 @@ -95,7 +96,19 @@ (insert the database schema into database "h2_solution" with user "h2_d= base") $ cat `ls core/schema/pgsql/pgsql-*.sql` | psql -h 127.0.0.1 -U h2_dbas= e h2_solution =20 +Loading a solution: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 +This step is optional. + +If you wish to start with a preconfigured solution you can load in one +of the solutions files that are located in the solutions/ +directory. For example, you can load a simple helpdesk loading the +pgsql-help_desk.sql file. you can do that with the following command: + + $ cat solutions/pgsql-help_desk.sql | psql -h 127.0.0.1 -U h2_dbase h2_= solution + + Starting up: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 1. Stand in the web/ directory and start the XSP server either by hand = or via: @@ -105,3 +118,12 @@ 2. This will bring up the xsp application server on port 8080.=20 3. Use a browser to connect to port 8080 of the server you installed humano2 on. For example: humano2.mycompany.com:8080 + + +Further Support: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + +If you need further support, you can contact us by subscribing +to one of the mailing lists at http://list.humano2.org and sending a +email to the list. You can also try your luck connecting to the IRC +support channel #humano2 on the irc.freenode.net network. Modified: humano2/trunk/INSTALL-LINUX.es.txt =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/INSTALL-LINUX.es.txt 2005-06-23 17:27:09 UTC (rev 1407) +++ humano2/trunk/INSTALL-LINUX.es.txt 2005-06-23 19:11:47 UTC (rev 1408) @@ -1,30 +1,32 @@ $Id$ =20 -Como instalar Humano2 en Linux: -=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\ +| Instalando Humano2 en Linux | +\=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/ =20 Esta y mas documentacion esta disponible en el sitio de desarrolladores -de Humano2: http://devel.humano2.org.=20 +de Humano2: http://devel.humano2.org o http://www.humano2.com/network =20 Si tiene preguntas o necesita soporte, puede suscribirse a las listas de correo en http://list.humano2.org y hacer sus preguntas ahi. =20 =20 Requerimientos: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + 1. Mono ( http://www.mono-project.com ) - Remarca: si usa Mono 1.1.6, configuralo asi: -=20 - ./configure -with-preview=3Dyes=20 - (Eso es necesario para compilar XSP) -=20 + Remarca: si usa Mono 1.1.6, configuralo con la opcion -with-preview=3Dy= es ya qye es necesario para compilar XSP 2. PostgreSQL version 8.0 o posterior ( http://www.postgresql.org ) 3. Instale XSP (http://www.go-mono.com/archive/1.0.6/xsp-1.0.6.tar.gz) - 4. Obtenga la ultima version del codigo fuente de Humano2 - ( http://sourceforge.net/project/showfiles.php?group_id=3D117865&pac= kage_id=3D152308 ) =20 + Compilacion: - 1. Compile ejecutando: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 + 1. Obtenga la ultima version del codigo fuente de Humano2 + ( http://sourceforge.net/project/showfiles.php?group_id=3D117865&pac= kage_id=3D152308 ) + 2. Compile ejecutando: + $ make =20 =20 @@ -102,6 +104,19 @@ $ cat `ls core/schema/pgsql/pgsql-*.sql` | psql -h 127.0.0.1 -U h2_dbas= e h2_solution =20 =20 +Cargando la solution: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + +Este paso es opcional. + +Si deseas iniciar con una solucion preconfigurado puedes cargar uno de +las archivos ubicados en el directorio soluciones/ . Por ejemplo, si +usted desea cargar la solucion para un Help Desk elemental, se puede +cargar el archivo mediante el siguiente mando: + + $ cat solutions/pgsql-help_desk.sql | psql -h 127.0.0.1 -U h2_dbase h2_= solution + + Inicio: =3D=3D=3D=3D=3D=3D=3D =20 @@ -112,3 +127,12 @@ 2. Esto iniciara el servidor de aplicaciones XSP en el puerto 8080.=20 3. Utilice un navegador para conectarse al puerto 8080 en el servidor d= onde ha instalado humano2. Por ejemplo: http://humano2.micompania.com:8080 + + +Soporte Adicional: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + +Si deseas mas soporte, nos puede contactar inscribiendose en las +listas de correos en http://list.humano2.org y mandando un correo a la +lista. Ademas puedes intentar contectarse al canal de soporte via IRC +irc.freenode.net canal #humano2 .=20 \ No newline at end of file Modified: humano2/trunk/INSTALL-WINDOWS.es.txt =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/INSTALL-WINDOWS.es.txt 2005-06-23 17:27:09 UTC (rev 140= 7) +++ humano2/trunk/INSTALL-WINDOWS.es.txt 2005-06-23 19:11:47 UTC (rev 140= 8) @@ -1,33 +1,46 @@ =20 -Como instalar Humano2 en Windows: -=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\ +| instalando Humano2 en Windows | +\=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/ =20 Esta y mas documentacion esta disponible en el sitio de desarrolladores -de Humano2: http://devel.humano2.org.=20 +de Humano2: http://devel.humano2.org o http://www.humano2.com/network =20 Si tiene preguntas o necesita soporte, puede suscribirse a las listas de correo en http://list.humano2.org y hacer sus preguntas ahi. =20 =20 Requerimientos: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + 1. .NEt platform 1.1 2. PostgreSQL version 8.0 o posterior ( http://www.postgresql.org ) - o MsSQL server 2000 con SP4 - 3. VS .NEt (para compilar si no bajo la version compilada) + Opcional: + 3. VS .Net (para compilar si no bajo la version compilada) =20 + Instalacion: - 1. Descomprima el archivo .zip que obtuvo. (por razones de ejemplo, est= e directorio se haga referencia en al forma de INSTALLDIR) +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + 1. Descomprima el archivo .zip que obtuvo. (por razones de ejemplo, est= e=20 + directorio se haga referencia en al forma de INSTALLDIR) 2. Abra el administrador de Servicios Internet - 3. Dentro del servidor web, hay que crear dos directorios virtuales, PO= RTAL y BUILDER, estos deberian apuntar a INSTALLDIR\sites\portal y INSTAL= LDIR\sites\builder respectivamente. Estos directorio deben tener acceso a= ejecutar sequencia de comandos. - 4.Agrege index.aspx bajo documentos. + 3. Dentro del servidor web, hay que crear dos directorios virtuales,=20 + PORTAL y BUILDER, estos deberian apuntar a INSTALLDIR\sites\portal y=20 + INSTALLDIR\sites\builder respectivamente. Estos directorio deben tener= =20 + acceso a ejecutar sequencia de comandos. + 4. Agrege index.aspx bajo documentos. +=20 + Opcional, si no bajo la version ya compilada: 5. Abra la solucion haciendo doble clic en INSTALLDIR\Humano2.sln 6. Compila la solucion +=20 7. Seguir con Creacion de la Base de Datos 8. Seguir con Configurando el sistema =20 =20 -Creacion de la Base de Datos - Postgres: +Creacion de la Base de Datos: =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 + 1. Cree la base de datos "h2_solution" con la codificacion UNICODE =20 2. Cree el usuario de base de datos "h2_dbase" con una contrasena @@ -79,8 +92,25 @@ completa)de su archivo config.xml. =20 =20 +Cargando la solution: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + +Este paso es opcional. + +Si deseas iniciar con una solucion preconfigurado puedes cargar uno de +las archivos ubicados en el directorio soluciones/ .=20 + + Inicio: =3D=3D=3D=3D=3D=3D=3D =20 1. Utilice un navegador para conectarse al servidor (eg. http://localho= st) =20 +=20 +Soporte Adicional: +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D + +Si deseas mas soporte, nos puede contactar inscribiendose en las +listas de correos en http://list.humano2.org y mandando un correo a la +lista. Ademas puedes intentar contectarse al canal de soporte via IRC +irc.freenode.net canal #humano2 .=20 |
|
From: <sv...@de...> - 2005-06-23 17:27:03
|
Author: pcamacho
Date: 2005-06-23 13:27:09 -0400 (Thu, 23 Jun 2005)
New Revision: 1407
Modified:
humano2/trunk/components/webTools/interfacetools.cs
humano2/trunk/web/builder/site/buildattribute.aspx.cs
Log:
FIX: bug #225. Use now the same function as for the creation of views to =
display attribute list.
Modified: humano2/trunk/components/webTools/interfacetools.cs
=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/components/webTools/interfacetools.cs 2005-06-23 17:16:=
33 UTC (rev 1406)
+++ humano2/trunk/components/webTools/interfacetools.cs 2005-06-23 17:27:=
09 UTC (rev 1407)
@@ -310,7 +310,7 @@
=20
*/
=20
- DataTable DtListAtt =3D getAttribListForClass(classId, userC=
red,fullPert);
+ DataTable DtListAtt =3D GetAttribListForClass(classId, userC=
red,fullPert);
foreach(DataRow row in DtListAtt.Rows)
{
salida +=3D "<attribute>";
@@ -331,7 +331,7 @@
}
=20
=20
- private static DataTable getAttribListForClass(int classId, Sess=
ionCredencial userCred,bool fullPert)
+ public static DataTable GetAttribListForClass(int classId, Sessi=
onCredencial userCred,bool fullPert)
{
int attlogin =3D 0;
int idatt =3D 0;
Modified: humano2/trunk/web/builder/site/buildattribute.aspx.cs
=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/buildattribute.aspx.cs 2005-06-23 17:1=
6:33 UTC (rev 1406)
+++ humano2/trunk/web/builder/site/buildattribute.aspx.cs 2005-06-23 17:2=
7:09 UTC (rev 1407)
@@ -865,7 +865,7 @@
res.Append(@"<table><tr>");
=20
res.Append(@"<td><select size=3D""6"" name=3D""fx_formAttribList"" ond=
blclick=3D""insertElementBracedText(this.options[this.selectedIndex], For=
m1.fx_Formula)"">");
- res.Append( formAttibList(classId) );
+ res.Append( formAttribList(classId) );
res.Append(@"</select></td>");
=20
res.Append(@"<td>");
@@ -1043,77 +1043,18 @@
return result;
}
=20
- private StringBuilder formAttibList(int classId)=20
- {
- StringBuilder res =3D new StringBuilder();
- int idatt =3D 0;
- int attlogin =3D 0;
- DataTable dtpert;
- DataTable dtrel;
- int idClassRel =3D 0;
+ private StringBuilder formAttribList(int classId)=20
+ {
+ StringBuilder res =3D new StringBuilder();
+ =20
+ DataTable DtAttList =3D Interface.GetAttribListForClass(clas=
sId, userCred,true); //All attribs with pertinence
+ foreach(DataRow row in DtAttList.Rows)
+ {
+ res.Append("<option value=3D\"" + row["id"] + "\">" + ro=
w["name"] + "</option>"); =20
+ }
+ return res;
+ }
=20
- DataTable dt =3D userCred.CoreAdapter.GetAttributesFromClass(classId);
-
- // foreach(DataColumn dc in dt.Columns)
- // {
- // Response.Write(dc.ColumnName+"\n");
- // }
- =20
- foreach(DataRow row in dt.Rows)=20
- {
- string attName =3D Convert.ToString(row["attName"]);
- string attType =3D Convert.ToString(row["attType"]);
- if(attType=3D=3D"pertinence")
- {
- idatt =3D Convert.ToInt32(row["id_entity"]);
- dtpert =3D userCred.CoreAdapter.GetClassesFromPertinence(idatt);
- DataRow dr2 =3D dtpert.Rows[0];
- idClassRel =3D Convert.ToInt32(dr2["to"].ToString());
- attlogin =3D this.GetAttributePrimary(idClassRel);
-
- res.Append("<option value=3D\""+attName+".ID\">"+attName+".ID</optio=
n>");
- =09
- idClassRel =3D Convert.ToInt32(dr2["to"].ToString());
- dtrel =3D userCred.CoreAdapter.GetAttributesFromClass(idClassRel);
- //Siempre debe ingresar a este if, a menos que la clase relacionada =
no tenga login (isPrimary)
- if(Convert.ToInt32(attlogin)>0)
- {
- if(dtrel.Select("id_entity=3D"+attlogin).Length>0)
- {
- DataRow row3 =3D dtrel.Select("id_entity=3D"+attlogin)[0];
- string attNameAux =3D Convert.ToString(row3["attName"]);
-
- res.Append("<option value=3D\""+dr2["name"]+"^"+attNameAux+"\">"+a=
ttName+"</option>");
- }
- }
- }
- else
- {
- res.Append("<option>"+attName+"</option>");
- }
- }
- foreach(DataRow row in dt.Select("attType=3D'pertinence'"))=20
- {
- idatt =3D Convert.ToInt32(row["id_entity"]);
- =09
- dtpert =3D userCred.CoreAdapter.GetClassesFromPertinence(idatt);
- =20
- foreach(DataRow dr in dtpert.Rows)
- {
- =09
- idClassRel =3D Convert.ToInt32(dr["to"].ToString());
- dtrel =3D userCred.CoreAdapter.GetAttributesFromClass(idClassRel);
- foreach(DataRow row2 in dtrel.Rows)=20
- {
- string attName =3D Convert.ToString(row2["attName"]);
- string className =3D Convert.ToString(dr["name"]);
- res.Append("<option>"+className+":"+attName+"</option>");
- }
- }=09
- }
- return res;
- }
-
private StringBuilder formOperatorList() {
StringBuilder res =3D new StringBuilder();
string[] operators =3D {"+", "-", "*", "/", "&"};
|
|
From: <sv...@de...> - 2005-06-23 17:16:30
|
Author: pcamacho
Date: 2005-06-23 13:16:33 -0400 (Thu, 23 Jun 2005)
New Revision: 1406
Modified:
humano2/trunk/components/webTools/interfacetools.cs
humano2/trunk/web/portal/site/showView.aspx.cs
Log:
CHANGE: factorization for preparing fixing #225.
Modified: humano2/trunk/components/webTools/interfacetools.cs
=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/components/webTools/interfacetools.cs 2005-06-23 16:59:=
14 UTC (rev 1405)
+++ humano2/trunk/components/webTools/interfacetools.cs 2005-06-23 17:16:=
33 UTC (rev 1406)
@@ -258,11 +258,6 @@
public static string GetXmlAttribListForClass(int classId,SessionCrede=
ncial userCred, bool fullPert)=20
{
string salida=3D"";
- int attlogin =3D 0;
- int idatt =3D 0;
- DataTable dtpert;
- DataTable dtrel;
- int idClassRel =3D 0;
string className =3D "";
=20
DataTable dt =3D userCred.CoreAdapter.GetAttributesFromClass(classId)=
;
@@ -276,6 +271,8 @@
salida +=3D "<name>" + className + "</name>";
salida +=3D "<attributes>";
=09
+ /*
+ =20
foreach(DataRow row in dt.Rows)=20
{
string attName =3D Convert.ToString(row["attName"]);
@@ -310,12 +307,80 @@
salida +=3D "</attribute>";
}
}
+ =20
+ */
+ =20
+ DataTable DtListAtt =3D getAttribListForClass(classId, userC=
red,fullPert);
+ foreach(DataRow row in DtListAtt.Rows)
+ {
+ salida +=3D "<attribute>";
+ salida +=3D "<id>";
+ salida +=3D Convert.ToString(row["id"]);
+ salida +=3D "</id>";
+ salida +=3D "<name>";
+ salida +=3D Convert.ToString(row["name"]);
+ salida +=3D "</name>";
+ =20
+ salida +=3D "</attribute>";
+ }
+ =20
salida +=3D "</attributes>";
salida +=3D "</class>";
=20
return salida;
}
=20
+ =20
+ private static DataTable getAttribListForClass(int classId, Sess=
ionCredencial userCred,bool fullPert)
+ {
+ int attlogin =3D 0;
+ int idatt =3D 0;
+ DataTable dtpert;
+ DataTable dtrel;
+ int idClassRel =3D 0;
+ DataTable dt =3D userCred.CoreAdapter.GetAttributesFromClass=
(classId);
+ DataTable res =3D new DataTable();
+ DataColumn colName;
+ colName =3D new DataColumn("name",typeof(string));
+ res.Columns.Add(colName);
+ DataColumn colId;
+ colId =3D new DataColumn("id",typeof(string));
+ res.Columns.Add(colId);
+ =20
+ foreach(DataRow row in dt.Rows)=20
+ {
+ DataRow resRow =3D res.NewRow();
+ string attName =3D Convert.ToString(row["attName"]);
+ string attType =3D Convert.ToString(row["attType"]);
+ if((attType=3D=3D"pertinence") && fullPert)
+ {
+ idatt =3D Convert.ToInt32(row["id_entity"]);
+ dtpert =3D userCred.CoreAdapter.GetClassesFromPertinence(idatt);
+ DataRow dr2 =3D dtpert.Rows[0];
+ idClassRel =3D Convert.ToInt32(dr2["to"].ToString());
+ =09
+ //For each attribute of pertinence put the id with t=
ogo and=20
+ // the pertname.attname
+ int [] listAttId =3D GetAttributeIdListForClass(idCl=
assRel,userCred);
+ string [] listAttName =3D getAttributeNameListForCla=
ss(idClassRel,userCred);
+ int size =3D listAttId.Length;
+ for(int i=3D0;i<size;i++)
+ {
+ attlogin =3D listAttId[i];
+ resRow["id"] =3D idatt + "^" + attlogin;
+ resRow["name"] =3D attName + "." + listAttName[=
i];
+ }
+ }
+ else
+ {
+ resRow["id"] =3D row["id_entity"].ToString();
+ resRow["name"] =3D attName;
+ } =20
+ res.Rows.Add(resRow);
+ }
+ return res;
+ }
+ =20
///<summary> The list of all attributes id for a class</summary>
public static int[] GetAttributeIdListForClass(int classId, Sess=
ionCredencial userCred)
{
Modified: humano2/trunk/web/portal/site/showView.aspx.cs
=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/portal/site/showView.aspx.cs 2005-06-23 16:59:14 UT=
C (rev 1405)
+++ humano2/trunk/web/portal/site/showView.aspx.cs 2005-06-23 17:16:33 UT=
C (rev 1406)
@@ -75,7 +75,6 @@
}
override protected string createXml()
{
-
string xmlString =3D""; //the result string
=20
adapter dbAdapter =3D userCred.CoreAdapter;
@@ -84,7 +83,6 @@
=20
iniClass =3D 0;
=20
-
iniClass =3D Convert.ToInt32(Request["classId"]);
//Logger.Log("classId" + iniClass.ToString(),LogLevel.Trace)=
;
=20
|
|
From: <sv...@de...> - 2005-06-23 16:59:09
|
Author: marcelo
Date: 2005-06-23 12:59:14 -0400 (Thu, 23 Jun 2005)
New Revision: 1405
Modified:
humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql
Log:
* Modified pertinence width and height attribute names to include "(in pi=
xels)" to let the user know what units are being used.
Modified: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.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-1-metadata.sql 2005-06-23 16:10=
:47 UTC (rev 1404)
+++ humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql 2005-06-23 16:59=
:14 UTC (rev 1405)
@@ -474,8 +474,8 @@
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (151,149,'attTy=
peRef','attTypeRef',0,'t','t','f','t','f','f','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (152,81,'filter=
View','filterView',0,'f','t','f','f','f','f','f','t',null);
=20
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (157,81,'widthP=
ertinence','width',0,'f','t','f','t','f','f','f','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (158,81,'height=
Pertinence','height',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (157,81,'widthP=
ertinence','width (in pixels)',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (158,81,'height=
Pertinence','height (in pixels)',0,'f','t','f','t','f','f','f','t',null);
=20
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (154,153,'versi=
onItem','versionItem',0,'t','t','f','f','f','t','t','f',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (155,153,'versi=
onValue','versionValue',0,'t','t','f','f','f','f','f','f',null);
|
|
From: <sv...@de...> - 2005-06-23 16:10:42
|
Author: pcamacho
Date: 2005-06-23 12:10:47 -0400 (Thu, 23 Jun 2005)
New Revision: 1404
Modified:
humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql
humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql
humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql
humano2/trunk/web/portal/site/xsl/orderattributes.xsl
Log:
FIX: bug #224. Good version: the guilty column "link" has been changed to=
"linked" into the metamodel.
Modified: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.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-1-metadata.sql 2005-06-23 15:27=
:35 UTC (rev 1403)
+++ humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql 2005-06-23 16:10=
:47 UTC (rev 1404)
@@ -110,7 +110,7 @@
"maxsize" integer NOT NULL, -- Tamano maximo para subir en Kilobytes.
"path" Varchar(50), -- Ubicacion en el sistema de archivos.
"extensions" Varchar(50), -- Extenciones de archivos permitidos.
- "link" Boolean, -- FIXME
+ "linked" Boolean, -- CAREFUL!! Don't put "link" for this column:=
causes problem with xsl then
primary key ("id_entity")
);
=20
@@ -452,7 +452,7 @@
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (83,39,'maxsize=
','maxsize',1,'f','t','f','t','f','f','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (84,39,'path','=
path',2,'f','t','f','t','f','t','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (85,39,'extensi=
ons','extensions',0,'f','t','f','t','f','f','f','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (86,39,'link','=
link',4,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (86,39,'linked'=
,'linked',4,'f','t','f','t','f','f','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (102,2,'isAbstr=
act','isAbstract',5,'f','t','f','f','f','f','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (103,5,'sysAttN=
ame','sysName',0,'t','t','f','f','f','f','f','t',null);
INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (104,3,'createD=
ate','createDate',0,'f','t','f','f','f','f','f','t',null);
Modified: humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.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-HelpDeskSMB.sql 2005-06-23 15=
:27:35 UTC (rev 1403)
+++ humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql 2005-06-23 16=
:10:47 UTC (rev 1404)
@@ -143,7 +143,7 @@
INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10209, NULL, NULL, NULL);
=20
=20
-INSERT INTO file (id_entity, maxsize, path, extensions, link) VALUES (10=
193, 100000, NULL, NULL, true);
+INSERT INTO file (id_entity, maxsize, path, extensions, linked) VALUES (=
10193, 100000, NULL, NULL, true);
=20
=20
INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10211, 'Assets', 0, '10167');
Modified: humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.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-Beta6patch.sql 2005-06-23 15:27=
:35 UTC (rev 1403)
+++ humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql 2005-06-23 16:10=
:47 UTC (rev 1404)
@@ -11,6 +11,14 @@
INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V=
ALUES (157,4,NULL,NULL,200); -- pertinence width
INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V=
ALUES (158,4,NULL,NULL,200); -- pertinence height
=20
+--Change name of attribute link of file to linked
+alter table "file" rename column "link" to "linked";
+update "attribute" set "sysAttName"=3D'linked' where "id_entity"=3D86;=20
+update "attribute" set "attName"=3D'linked' where "id_entity"=3D86;
+delete from "file" where "id_entity"=3D10193;
+INSERT INTO file (id_entity, maxsize, path, extensions, linked) VALUES (=
10193, 100000, NULL, NULL, true);
=20
=20
=20
+
+
Modified: humano2/trunk/web/portal/site/xsl/orderattributes.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/portal/site/xsl/orderattributes.xsl 2005-06-23 15:2=
7:35 UTC (rev 1403)
+++ humano2/trunk/web/portal/site/xsl/orderattributes.xsl 2005-06-23 16:1=
0:47 UTC (rev 1404)
@@ -15,22 +15,9 @@
<xsl:copy-of select=3D"/dataWithAttributes/structure/att=
ribute[id_entity=3D$currentId]" />
</xsl:for-each>
<!-- copy what remains -->
- <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()!=3D'class' and name()!=3D'attribute' and name()!=3D'entity' and name()=
!=3D'file']">
+ <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()!=3D'class' and name()!=3D'attribute' and name()!=3D'entity']">
<xsl:copy-of select=3D"."/>
</xsl:for-each>
- <!-- patch because of a big pb with xsl... With link the cop=
y is impossible... So it is replaced by link1-->
- <!-- The tag <link> cannot be copied correctly (the closing =
tag </link>never appears. So we don't put it... Nevermind we do not
- use it for the moment...-->
- <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()=3D'file']">
- <file>
- <id_entity>
- <xsl:value-of select=3D"id_entity" />
- </id_entity>
- <maxsize>
- <xsl:value-of select=3D"maxsize" />
- </maxsize>
- </file>
- </xsl:for-each>
</structure>
</xsl:template>
</xsl:stylesheet>
|
|
From: <sv...@de...> - 2005-06-23 15:27:33
|
Author: pcamacho
Date: 2005-06-23 11:27:35 -0400 (Thu, 23 Jun 2005)
New Revision: 1403
Modified:
humano2/trunk/web/portal/site/showView.aspx.cs
Log:
FIX:
* when using search mode, the second column for viewtools was called "fi=
ltros", causing a conflict with the name=20
"where". Now "where" is used in every case.
* replaced "currrentUser" by "currentUser".
Modified: humano2/trunk/web/portal/site/showView.aspx.cs
=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/portal/site/showView.aspx.cs 2005-06-23 14:54:45 UT=
C (rev 1402)
+++ humano2/trunk/web/portal/site/showView.aspx.cs 2005-06-23 15:27:35 UT=
C (rev 1403)
@@ -126,22 +126,20 @@
viewTable =3D getViewForSearch(iniClass,idAttributes,idOperators,val=
uesToSearch);
}
=20
- //replaces dynamic session variables
- Type myType =3D typeof(SessionCredencial);
- string whereStr =3D viewTable.Rows[0]["where"].ToString();
-
- FieldInfo[] myFieldInfo =3D myType.GetFields();
- for(int i=3D0;i<myFieldInfo.Length;i++)
- {
- FieldInfo myPropInfo =3D (FieldInfo)myFieldInfo[i];
- string fieldName =3D myPropInfo.Name;=09
- whereStr =3D whereStr.Replace("[currrentUser." + fieldName + "]",myP=
ropInfo.GetValue(userCred).ToString());
- }
-=20
- =09
- =09
- viewTable.Rows[0]["where"] =3D whereStr;
-
+ //replaces dynamic session variables
+ Type myType =3D typeof(SessionCredencial);
+ =20
+ string whereStr =3D viewTable.Rows[0]["where"].ToString();
+ =20
+ FieldInfo[] myFieldInfo =3D myType.GetFields();
+ for(int i=3D0;i<myFieldInfo.Length;i++)
+ {
+ FieldInfo myPropInfo =3D (FieldInfo)myFieldInfo[i];
+ string fieldName =3D myPropInfo.Name;=09
+ whereStr =3D whereStr.Replace("[currentUser." + fieldNam=
e + "]",myPropInfo.GetValue(userCred).ToString());
+ }
+ viewTable.Rows[0]["where"] =3D whereStr;
+ =20
// If there are multiple "order" arguments, they should be s=
eperated by ",";
// The framework already puts a "," between multiple "order =
arguments.
Logger.Log("Before ExecViewFromDataTabe. iniClass=3D " + Con=
vert.ToString(iniClass),LogLevel.Trace);
@@ -230,10 +228,10 @@
=20
//Explicacion de los filtros...
char separator =3D ';';
- dr["filtros"] =3D getFilterForSearch(idAttributes,idOperators,valuesT=
oSearch,separator);
- Logger.Log("search: filtros =3D " + dr["filtros"],LogLevel.Trace);
+ =09
+ dr["where"] =3D getFilterForSearch(idAttributes,idOperators,=
valuesToSearch,separator);
+ Logger.Log("search: filtros =3D " + dr["where"],LogLevel.Trace);
=20
- =20
dtParam.Rows.Add(dr);
return dtParam;
}
@@ -303,7 +301,7 @@
DataColumn dc1;
dc1 =3D new DataColumn("columns",typeof(string));
dt1.Columns.Add(dc1);
- dc1 =3D new DataColumn("filtros",typeof(string));
+ dc1 =3D new DataColumn("where",typeof(string));
dt1.Columns.Add(dc1);
dc1 =3D new DataColumn("group",typeof(string));
dt1.Columns.Add(dc1);
|
|
From: <sv...@de...> - 2005-06-23 14:54:40
|
Author: pcamacho
Date: 2005-06-23 10:54:45 -0400 (Thu, 23 Jun 2005)
New Revision: 1402
Modified:
humano2/trunk/components/webTools/xmltools.cs
humano2/trunk/web/portal/site/instance.aspx.cs
humano2/trunk/web/portal/site/xsl/orderattributes.xsl
Log:
FIX: bug #224. The tag <link> in the attribute file is not copied correct=
ly (</link> missing...). While we don't use=20
this tag, it can't be removed.
Modified: humano2/trunk/components/webTools/xmltools.cs
=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/components/webTools/xmltools.cs 2005-06-22 22:36:27 UTC=
(rev 1401)
+++ humano2/trunk/components/webTools/xmltools.cs 2005-06-23 14:54:45 UTC=
(rev 1402)
@@ -168,7 +168,7 @@
+ xmlAttributesList
+ "</attributesList>" =20
+ "</dataWithAttributes>";
- //Logger.Log("xmlWithAttributesList: " + xmlWithAttributesLi=
st,LogLevel.Trace);
+ Logger.Log("xmlWithAttributesList: " + xmlWithAttributesList=
,LogLevel.Trace);
string res =3D TransformXML(xmlWithAttributesList, xslPath, =
null);
//Logger.Log("res: " + res,LogLevel.Trace);
return res;
Modified: humano2/trunk/web/portal/site/instance.aspx.cs
=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/portal/site/instance.aspx.cs 2005-06-22 22:36:27 UT=
C (rev 1401)
+++ humano2/trunk/web/portal/site/instance.aspx.cs 2005-06-23 14:54:45 UT=
C (rev 1402)
@@ -173,6 +173,8 @@
string structure =3D dbAdapter.ReadStructureAndXsls1(idEntit=
y,xslInclude,listAtt); //AQUI
Logger.Log("structure(before)=3D" + structure,LogLevel.Trac=
e);
//Reorder the attributes as they appear in the selected orde=
r (form)
+ Logger.Log("listAtt: " + listAtt,LogLevel.Trace);
+ =20
structure =3D Humano2.Components.WebTools.Xml.OrderAttribute=
sInDataStructure(structure, listAtt, baseUrl() +"xsl/orderattributes.xsl"=
);
Logger.Log("structure(after)=3D" + structure,LogLevel.Trace=
);
//SVERA string structure =3D dbAdapter.ReadStructureAndXsls1=
(idEntity,xslInclude,formAttribute);
Modified: humano2/trunk/web/portal/site/xsl/orderattributes.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/portal/site/xsl/orderattributes.xsl 2005-06-22 22:3=
6:27 UTC (rev 1401)
+++ humano2/trunk/web/portal/site/xsl/orderattributes.xsl 2005-06-23 14:5=
4:45 UTC (rev 1402)
@@ -15,9 +15,22 @@
<xsl:copy-of select=3D"/dataWithAttributes/structure/att=
ribute[id_entity=3D$currentId]" />
</xsl:for-each>
<!-- copy what remains -->
- <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()!=3D'class' and name()!=3D'attribute' and name()!=3D'entity']">
+ <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()!=3D'class' and name()!=3D'attribute' and name()!=3D'entity' and name()=
!=3D'file']">
<xsl:copy-of select=3D"."/>
</xsl:for-each>
+ <!-- patch because of a big pb with xsl... With link the cop=
y is impossible... So it is replaced by link1-->
+ <!-- The tag <link> cannot be copied correctly (the closing =
tag </link>never appears. So we don't put it... Nevermind we do not
+ use it for the moment...-->
+ <xsl:for-each select=3D"/dataWithAttributes/structure/*[name=
()=3D'file']">
+ <file>
+ <id_entity>
+ <xsl:value-of select=3D"id_entity" />
+ </id_entity>
+ <maxsize>
+ <xsl:value-of select=3D"maxsize" />
+ </maxsize>
+ </file>
+ </xsl:for-each>
</structure>
</xsl:template>
</xsl:stylesheet>
|
|
From: <sv...@de...> - 2005-06-22 22:36:26
|
Author: pcamacho
Date: 2005-06-22 18:36:27 -0400 (Wed, 22 Jun 2005)
New Revision: 1401
Modified:
humano2/trunk/web/builder/site/foldermanagement.aspx.cs
Log:
CHANGE: factorization again...
Modified: humano2/trunk/web/builder/site/foldermanagement.aspx.cs
=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/foldermanagement.aspx.cs 2005-06-22 22=
:26:30 UTC (rev 1400)
+++ humano2/trunk/web/builder/site/foldermanagement.aspx.cs 2005-06-22 22=
:36:27 UTC (rev 1401)
@@ -118,51 +118,75 @@
return strXml;
}
=20
+ ///<summary>
+ /// Only for need of factorization. Basically does a request to =
viewtools, and builds an xml string
+ /// with it.
+ ///</summary>
+ ///<param name=3D"classId">For viewtools: the class id</param>
+ ///<param name=3D"col">For viewtools: the col with the name of v=
iew/report/form</param>
+ ///<param name=3D"filter">For viewtools: filter by domain for ex=
ample</param>
+ ///<param name=3D"type">Could be view,report,form</param>
+ ///<param name=3D"sysColName">The name of the col for system</pa=
ram>
+ ///<return>the xml string with for each item: the type, the name=
and the id</return>
+ private string getItemsXml(int classId,string col, string sysCol=
Name,string filter, string type)
+ {
+ string strXml =3D "";
+ DataTable dt =3D userCred.CoreAdapter.GenerateViewTools(clas=
sId,"0,"+col,filter,"","","",0);
+ foreach(DataRow row in dt.Rows)
+ {
+ strXml +=3D getItemXml(type,Convert.ToString(row[sysColN=
ame]),Convert.ToString(row["id_entity"]));
+ } =20
+ return strXml;
+ }
+ =20
+ //FIXME: please comment
+ private string getPreselectedItemsXml(int classId, string col, s=
tring sysColName, string filter, string type, string [] listOfCols)
+ {
+ string strXml =3D "";
+ DataTable dt =3D userCred.CoreAdapter.GenerateViewTools(clas=
sId,"0," + col,filter,"","","",0);
+ foreach(DataRow row in dt.Rows)
+ {
+ string idEntity =3D Convert.ToString(row["id_entity"]);
+ if(Array.IndexOf(listOfCols,idEntity)!=3D-1)
+ {
+ strXml +=3D getItemXml(type,Convert.ToString(row[sys=
ColName]),Convert.ToString(row["id_entity"]));
+ }
+ } =20
+ return strXml;
+ }
+ =20
+ ///<summary>Only add xml envelope to an item</summary>
+ private string getItemXml(string type, string name, string id)
+ {
+ string strXml =3D "";
+ =20
+ strXml +=3D "<item>";
+ strXml +=3D "<type>" + type + "</type>";
+ strXml +=3D "<name>" + name + "</name>"; =20
+ strXml +=3D "<id>" + id + "</id>";
+ strXml +=3D "</item>";
+ =20
+ return strXml;
+ }
+ =20
private string getFolderContent(int folderId)
{
string strXml =3D "";
string filter =3D "";
- DataTable dt =3D null;
=20
strXml +=3D "<items>";
filter =3D String.Format("34|4|'{0}'|0|0",domainId); //Filte=
r by domain
=20
//Views
- dt =3D userCred.CoreAdapter.GenerateViewTools(1011,"0, 1018"=
,filter,"","","",0);
- foreach(DataRow row in dt.Rows)
- {
- strXml +=3D "<item>";
- strXml +=3D "<type>view</type>";
- strXml +=3D "<name>" + row["viewName"] + "</name>"; =20
- strXml +=3D "<id>" + row["id_entity"] + "</id>";
- strXml +=3D "</item>";
- }
+ strXml +=3D getItemsXml(1011,"1018","viewName",filter,"view"=
);
=20
//Forms
string filterForm =3D String.Format("1201|4|'CREATE'|1|0;34|=
4|'{0}'|0|0",domainId);
- dt =3D userCred.CoreAdapter.GenerateViewTools(1200,"0, 1202",filterFo=
rm,"","","",0);
+ strXml +=3D getItemsXml(1200,"1202","formName",filterForm,"f=
orm");
=20
- foreach(DataRow row in dt.Rows)
- {
- strXml +=3D "<item>";
- strXml +=3D "<type>form</type>";
- strXml +=3D "<name>" + row["formName"] + "</name>"; =20
- strXml +=3D "<id>" + row["id_entity"] + "</id>";
- strXml +=3D "</item>";
- }
- =20
//Reports
- dt =3D userCred.CoreAdapter.GenerateViewTools(1300,"0, 1307"=
,filter,"","","",0);
+ strXml +=3D getItemsXml(1300,"1307","reportName",filter,"rep=
ort");
=20
- foreach(DataRow row in dt.Rows)
- {
- strXml +=3D "<item>";
- strXml +=3D "<type>report</type>";
- strXml +=3D "<name>" + row["reportName"] + "</name>"; =
=20
- strXml +=3D "<id>" + row["id_entity"] + "</id>";
- strXml +=3D "</item>";
- }
- =20
strXml +=3D"</items>"; =20
=20
//The possible parent folders
@@ -179,56 +203,18 @@
string filter =3D "0|4|'" + folderId + "'|0|0";
DataTable dt =3D userCred.CoreAdapter.GenerateViewTools(140=
0,"0,1403",filter,"","","",0); =20
string [] listOfCols =3D Convert.ToString(dt.Rows[0]["folder=
Forms"]).Split(",".ToCharArray());
- =20
string filterDomain =3D String.Format("34|4|'{0}'|0|0",domai=
nId); //Filter by domain;
- //Get the views
+ =20
//Views
- dt =3D userCred.CoreAdapter.GenerateViewTools(1011,"0, 1018"=
,filterDomain,"","","",0);
- foreach(DataRow row in dt.Rows)
- {
- string idEntity =3D Convert.ToString(row["id_entity"]);
- if(Array.IndexOf(listOfCols,idEntity)!=3D-1)
- {
- strXml +=3D "<item>";
- strXml +=3D "<type>view</type>";
- strXml +=3D "<name>" + row["viewName"] + "</name>"; =
=20
- strXml +=3D "<id>" + row["id_entity"] + "</id>";
- strXml +=3D "</item>";
- }
- }
+ strXml +=3D getPreselectedItemsXml(1011,"1018","viewName",fi=
lterDomain,"view", listOfCols);
=20
//Forms
string filterForm =3D String.Format("1201|4|'CREATE'|1|0;34|=
4|'{0}'|0|0",domainId);
- dt =3D userCred.CoreAdapter.GenerateViewTools(1200,"0, 1202",filterFo=
rm,"","","",0);
- foreach(DataRow row in dt.Rows)
- {
- string idEntity =3D Convert.ToString(row["id_entity"]);
- if(Array.IndexOf(listOfCols,idEntity)!=3D-1)
- {
- //Logger.Log("form " + row["formName"] + " added", L=
ogLevel.Trace);
- strXml +=3D "<item>";
- strXml +=3D "<type>form</type>";
- strXml +=3D "<name>" + row["formName"] + "</name>"; =
=20
- strXml +=3D "<id>" + idEntity + "</id>";
- strXml +=3D "</item>";
- }
- Logger.Log("listOfCols.IndexOf(idEntity): " + Array.Inde=
xOf(listOfCols,idEntity),LogLevel.Trace);
- }
+ strXml +=3D getPreselectedItemsXml(1200,"1202","formName",filterForm,=
"form", listOfCols);
=20
//Reports
- dt =3D userCred.CoreAdapter.GenerateViewTools(1300,"0, 1307"=
,filterDomain,"","","",0);
- foreach(DataRow row in dt.Rows)
- {
- string idEntity =3D Convert.ToString(row["id_entity"]);
- if(Array.IndexOf(listOfCols,idEntity)!=3D-1)
- {
- strXml +=3D "<item>";
- strXml +=3D "<type>report</type>";
- strXml +=3D "<name>" + row["reportName"] + "</name>"=
; =20
- strXml +=3D "<id>" + row["id_entity"] + "</id>";
- strXml +=3D "</item>";
- }
- }
+ strXml +=3D getPreselectedItemsXml(1300,"1307","reportName",=
filterDomain,"report", listOfCols);
+ =20
strXml +=3D "</items>";
return strXml;
}
|
|
From: <sv...@de...> - 2005-06-22 22:26:24
|
Author: marcelo
Date: 2005-06-22 18:26:30 -0400 (Wed, 22 Jun 2005)
New Revision: 1400
Modified:
humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql
humano2/trunk/web/builder/site/buildattribute.aspx.cs
Log:
* Modified attName of the new attributes to have "(in pixels)" when indi=
cating width and height
* removed If identified as "// Don't add the column if the value is empt=
y." which did not enable to leave answers in blank.
Modified: humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.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-Beta6patch.sql 2005-06-22 22:23=
:35 UTC (rev 1399)
+++ humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql 2005-06-22 22:26=
:30 UTC (rev 1400)
@@ -6,8 +6,8 @@
insert into "entity" ("id_entity","domainId","class","delDate","status"=
) values (157,10,9,NULL,NULL);
insert into "entity" ("id_entity","domainId","class","delDate","status"=
) values (158,10,9,NULL,NULL);
=20
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (157,81,'widthP=
ertinence','width',0,'f','t','f','t','f','f','f','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (158,81,'height=
Pertinence','height',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (157,81,'widthP=
ertinence','width (in pixels)',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (158,81,'height=
Pertinence','height (in pixels)',0,'f','t','f','t','f','f','f','t',null);
INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V=
ALUES (157,4,NULL,NULL,200); -- pertinence width
INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V=
ALUES (158,4,NULL,NULL,200); -- pertinence height
=20
Modified: humano2/trunk/web/builder/site/buildattribute.aspx.cs
=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/buildattribute.aspx.cs 2005-06-22 22:2=
3:35 UTC (rev 1399)
+++ humano2/trunk/web/builder/site/buildattribute.aspx.cs 2005-06-22 22:2=
6:30 UTC (rev 1400)
@@ -337,10 +337,6 @@
//Load Form variables into NameValueCollection variable.
foreach(string formKey in keyList)
{ // Add all the columns to the datatable.
- if(coll[formKey] =3D=3D "") // Don't add the column if the value is e=
mpty.
- {=20
- continue;
- }
dt.Columns.Add(formKey);
}
=20
|
|
From: <sv...@de...> - 2005-06-22 22:23:38
|
Author: concha
Date: 2005-06-22 18:23:35 -0400 (Wed, 22 Jun 2005)
New Revision: 1399
Modified:
humano2/trunk/web/portal/site/xsl/pertinence.xsl
Log:
* Se arreglo bug de iframe de relacionados que tapaba attributo pertine=
nce al ser desplegado. *
Modified: humano2/trunk/web/portal/site/xsl/pertinence.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/portal/site/xsl/pertinence.xsl 2005-06-22 21:30:26 =
UTC (rev 1398)
+++ humano2/trunk/web/portal/site/xsl/pertinence.xsl 2005-06-22 22:23:35 =
UTC (rev 1399)
@@ -38,7 +38,7 @@
</table>=09
<!--<input type=3D"button" name=3D"aaa" value=3D"Ver=
" onclick=3D"toggleIFrame('{concat('frame_',$idEntity)}','viewpertinencel=
ist.aspx?idClass=3D{$idClass}&idEntity=3D{$idEntity}&sysAttName=3D=
{$sysAttName}');" />-->
<input type=3D"hidden" name=3D"{$sysAttName}" value=3D=
"{$data}"/>
- <iframe scrolling=3D"no" id=3D"{concat('frame_',$idE=
ntity)}" src=3D"" style=3D"visibility: hidden; position:absolute;" width=3D=
"{$widthPertinence}" height=3D"{$heightPertinence}" frameborder=3D"0" al=
ign=3D"middle"></iframe>
+ <iframe scrolling=3D"no" id=3D"{concat('frame_',$idE=
ntity)}" src=3D"" style=3D"visibility: hidden; position:absolute;z-index:=
100;" width=3D"{$widthPertinence}" height=3D"{$heightPertinence}" framebo=
rder=3D"0" align=3D"middle"></iframe>
</xsl:if>
=20
<xsl:if test=3D"not(string($isEditable)=3D'true')"> =20
@@ -66,7 +66,7 @@
</tr>
</table>=09
<input type=3D"hidden" name=3D"{$sysAttName}" />
- <iframe id=3D"{concat('frame_',$idEntity)}" src=3D""=
style=3D"visibility: hidden; position:absolute;" scrolling=3D"no" width=3D=
"{$widthPertinence}" height=3D"{$heightPertinence}" frameborder=3D"0" ali=
gn=3D"middle" ></iframe>
+ <iframe id=3D"{concat('frame_',$idEntity)}" src=3D""=
style=3D"visibility: hidden; position:absolute;z-index:100;" scrolling=3D=
"no" width=3D"{$widthPertinence}" height=3D"{$heightPertinence}" framebor=
der=3D"0" align=3D"middle" ></iframe>
</xsl:if>
</xsl:when>
</xsl:choose>
|
|
From: <sv...@de...> - 2005-06-22 21:30:26
|
Author: pcamacho Date: 2005-06-22 17:30:26 -0400 (Wed, 22 Jun 2005) New Revision: 1398 Removed: humano2/trunk/web/builder/site/js/fn_formsmng.js Log: DEL: now this file is unuseful as the creation of forms is now standard. Deleted: humano2/trunk/web/builder/site/js/fn_formsmng.js =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/js/fn_formsmng.js 2005-06-22 21:19:02 = UTC (rev 1397) +++ humano2/trunk/web/builder/site/js/fn_formsmng.js 2005-06-22 21:30:26 = UTC (rev 1398) @@ -1,106 +0,0 @@ -// -// The Humano2 Business solution. -// Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) -// -// This program is free software; you can redistribute it and/or modify -// it under the terms of the GNU General Public License as published by -// the Free Software Foundation; either version 2 of the License, or -// (at your option) any later version. -// -// $Id$ =20 - -//**********************************************************************= **************** -function loadClass(ClassValue,ClassName) -{ - //alert(ClassValue + " " + ClassName); - iFrame =3D document.getElementById("FrameTempLoad"); - iFrame.style.visibility=3D'hidden'; - if(ClassValue =3D=3D 0) - { - return; - } - document.formulario.ClassName.value =3D ClassName; - document.formulario.ClassId.value =3D ClassValue; - document.formulario.submit(); - //alert(document.formulario.ClassName.value + " "=20 - //+ document.formulario.ClassId.value); -} - -//**********************************************************************= **************** -function mostrar() -{ - iFrame =3D document.getElementById("FrameTempLoad"); - iFrame.style.width=3D '150px'; - iFrame.style.height=3D '100px'; - iFrame.style.visibility =3D 'visible'; - iFrame.src=3D"combobox_type_entity.aspx"; - //document.all.FrameTempLoad.src=3D"combobox_type_entity.aspx"; // ?= typeent=3D' + strtype_Entity + '&typeEntityFrom=3D' + typeEntityFrom + '&= IntView=3D' + vista + strelem + '"' -} -=20 -//**********************************************************************= ****************=20 -function fn_saveData() -{ - var frm =3D document.formulario; - var strError =3D ""; - =20 - if (frm.formName.value =3D=3D "") - { - strError +=3D "Error, you must insert a name.\n"; - } - =20 - frm.LstAttrib.value =3D ""; - =20 - for( var i =3D 0;i < rightColumn.fSortedList.Length();i++) - { - if(rightColumn.fSortedList.GetItem(i).value !=3D "") - { - frm.LstAttrib.value +=3D rightColumn.fSortedList.GetItem(i).= value; - if(i < rightColumn.fSortedList.Length() -1) - frm.LstAttrib.value +=3D ","; - } - } - =20 - if (strError =3D=3D "") - { - if (frm.opaction.value =3D=3D 0) - { - frm.opaction.value=3D1; - } - frm.submit(); - }else{ - alert(strError); - } -} - -//**********************************************************************= ****************=20 -function fn_deleteData() -{ - //var frm =3D document.formulario; - //var strError =3D ""; - - //alert("Antes :: " + document.formulario.opAction.value); - document.formulario.opaction.setAttribute("value",3);// =3D 3; //val= ue",3); - =20 - //alert("Despues :: " + document.formulario.opaction.value); - //document.formulario.submit(); - =20 - //var folderId =3D document.formulario.folderid.value; - //var url[] =3D String(document.location).split("?"); - =20 - //alert(document.formulario.opaction.value); - //document.location =3D "foldermanagement.aspx?opaction=3D3&folderId= =3D" + folderId;=20 - document.formulario.submit(); -} - -//**********************************************************************= ****************=20 -function fn_setFolderParentId(parentid) -{ - var frm =3D document.formulario; - //alert(parentid); - =20 - if(parentid !=3D null || parentid > 0) - { - frm.folderparentid.value =3D parentid; - } - //alert(frm.folderparent.options[pos].value); =20 -} =20 |
|
From: <sv...@de...> - 2005-06-22 21:18:55
|
Author: marcelo
Date: 2005-06-22 17:19:02 -0400 (Wed, 22 Jun 2005)
New Revision: 1397
Modified:
humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql
Log:
* Fixed Patch, had not placed column names within quotes to respect uppe=
rcase characters.
Modified: humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.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-Beta6patch.sql 2005-06-22 21:16=
:59 UTC (rev 1396)
+++ humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql 2005-06-22 21:19=
:02 UTC (rev 1397)
@@ -1,8 +1,8 @@
update "view" set "where" =3D '34|8|{(''[DomainId]'',''10'')}|0|0' wher=
e id_entity =3D 1405;
=20
-- For the pertinence properties width and height
-alter table pertinence add column widthPertinence Integer;
-alter table pertinence add column heightPertinence Integer;
+alter table pertinence add column "widthPertinence" Integer;
+alter table pertinence add column "heightPertinence" Integer;
insert into "entity" ("id_entity","domainId","class","delDate","status"=
) values (157,10,9,NULL,NULL);
insert into "entity" ("id_entity","domainId","class","delDate","status"=
) values (158,10,9,NULL,NULL);
=20
|
