Hallo Tobias,
attached please find the source-file. Thanks for your help and efforts!
Regards,
--
Andreas Tepper
Softwareentwicklung
Animationsfabrik GmbH
Donnerstrasse 20
D-22763 Hamburg
Tel: +49 40 398415-10
Fax: +49 40 398415-32
E-Mail: [EMAIL PROTECTED]
Web: www.animationsfabrik.de
Amtsgericht Hamburg
HRB 75488
Geschäftsführer: Jörn Radel
Sitz der Gesellschaft: Hamburg
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tobias Koller
(GERMO GmbH)
Sent: Friday, December 14, 2007 10:36 AM
To: qooxdoo Development
Subject: Re: [qooxdoo-devel] Add New Row
Can you send me your *.js file (rename it to *.txt) so that I can take a closer
look. We will find a solution ;)
Tobias
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Andreas Tepper
Gesendet: Freitag, 14. Dezember 2007 10:24
An: qooxdoo Development
Betreff: Re: [qooxdoo-devel] Add New Row
Hello Tobias,
thanks for your reply. I've tried the addRows-Function before, but it did not
work. It's a silly phenomenom, this code did not work (adds no empty row at the
end of my table):
********************************************************************************************
(main-Function)
var tableModel = new qx.ui.table.model.Simple();
with (tableModel) {
setColumns([ "Ausgaben-Id",
...
"Rechnung" ]);
setColumnEditable(8, true);
...
};
var tableExpenses = new qx.ui.table.Table(tableModel);
with (tableExpenses) {
set({ border:"inset-thin" });
getSelectionModel().setSelectionMode(qx.ui.table.selection.Model.SINGLE_SELECTION);
getTableColumnModel().setColumnVisible(0,
false);
...
setColumnWidth(0, 0);
...
setColumnWidth(9, 150);
...
setWidth(1430);
};
I'VE SHORTENED THE TABLMODEL AND TABLE DEFINITIONS A
BIT, REAL SOURCE CONTAINS WHOLE
CODE FOR ALL 21 COLUMNS
this.fillExpensesTable(pid, tcid, tableModel);
var emptyRow = new
Array("","","","","","","","","","","","","","","","","","","","","");
var wrapper = new Array(emptyRow);
tableExpenses.getTableModel().addRows(wrapper);
(end of main function)
fillExpensesTable : function(pid, tcid, tableModel) {
try
{
//tableModel.removeRows(0, tableModel.getRowCount());
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("tc_id", tcid);
req.setParameter("action", "GetExpensesList");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
var tabledata =
qx.io.Json.parse(content);
tableModel.setData(tabledata);
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Tabellendaten: " + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Tabelle: " +
ex.toString());
}
},
********************************************************************************************
while this works:
********************************************************************************************
(main-Function)
SAME AS ABOVE UNTIL HERE
this.fillExpensesTable(pid, tcid, tableModel);
(end of main function)
fillExpensesTable : function(pid, tcid, tableModel) {
try
{
//tableModel.removeRows(0, tableModel.getRowCount());
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("tc_id", tcid);
req.setParameter("action", "GetExpensesList");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
var tabledata =
qx.io.Json.parse(content);
tableModel.setData(tabledata);
var emptyRow = new
Array("","","","","","","","","","","","","","","","","","","","","");
var wrapper = new
Array(emptyRow);
tableModel.addRows(wrapper);
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Tabellendaten: " + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Tabelle: " +
ex.toString());
}
},
********************************************************************************************
So if i add the empty row within the fillExpensesTable-Function which populates
the result from my backend script (database) the row was added
correctly. If i try to add the row afterwards in the main, the row was not
added, no matter if i use the tableModel-variable or
"tableExpenses.getTableModel()".
When i type "this.tableExpenses.getTableModel()" i've got an error saying that
tableExpenses has no properties...
I am a bit confused, why does the first one not work?
BTW: Thanks for the 29, i wish it would be real... ;-)
Thanks again and kind regards,
--
Andreas Tepper
Softwareentwicklung
Animationsfabrik GmbH
Donnerstrasse 20
D-22763 Hamburg
Tel: +49 40 398415-10
Fax: +49 40 398415-32
E-Mail: [EMAIL PROTECTED]
Web: www.animationsfabrik.de
Amtsgericht Hamburg
HRB 75488
Geschäftsführer: Jörn Radel
Sitz der Gesellschaft: Hamburg
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tobias Koller
(GERMO GmbH)
Sent: Friday, December 14, 2007 7:26 AM
To: qooxdoo Development
Subject: Re: [qooxdoo-devel] Add New Row
Hi andreas,
Here is an example:
if you have the following columns: id|name|firstname|age|hobby
var row = new Array("1","Tepper", "Andreas", "29", "programmingQooxdoo");
mytable.getTableModel().addRow(row);
if you don't want to fill this fields you can also just make something like:
var row = new Array("","", "", "", "");
I didn't try it out but that should work.
Tobias
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Andreas Tepper
Gesendet: Donnerstag, 13. Dezember 2007 14:04
An: qooxdoo-devel@lists.sourceforge.net
Betreff: [qooxdoo-devel] Add New Row
Hi,
i have a table (qx.ui.table.Table(tableModel) where tableModel is
qx.ui.table.model.Simple()) which is partly editable by the user. Also users
should be able to add new rows to the table. In other GUI-Environments, like
the DataGridView from MS .Net-Framework Forms, you have a special "last row"
which is empty to add a row to the table (nomrally marked with * in the
row-header, i think you all know what i mean).
How could i achieve this with qooxdoo-Tables? Another question is, if it is
possible to provide such a "add new row row", how to set up default values,
e.g. for columns the user must not or do not want to edit?
It would be highly appriciated if somebody has a piece of sample-code regarding
these matters.
Thanks for your help & kind regards,
--
Andreas Tepper
Softwareentwicklung
Animationsfabrik GmbH
Donnerstrasse 20
D-22763 Hamburg
Tel: +49 40 398415-10
Fax: +49 40 398415-32
E-Mail: [EMAIL PROTECTED]
Web: www.animationsfabrik.de
Amtsgericht Hamburg
HRB 75488
Geschäftsführer: Jörn Radel
Sitz der Gesellschaft: Hamburg
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
/* ************************************************************************
Copyright:
License:
Authors:
************************************************************************ */
/* ************************************************************************
#resource(custom.image:image)
// List all static resources that should be copied into the build version,
// if the resource filter option is enabled (default: disabled)
#embed(qx.icontheme/32/status/dialog-information.png)
#embed(custom.image/test.png)
************************************************************************ */
/**
* Your custom application
*/
qx.Class.define("af.CostsReport",
{
extend : qx.application.Gui,
/*
*****************************************************************************
MEMBERS
*****************************************************************************
*/
members :
{
/**
* TODOC
*
* @type member
*/
main : function()
{
this.base(arguments);
// Define alias for custom resource path
qx.io.Alias.getInstance().add("af",
qx.core.Setting.get("af.resourceUri"));
var myClass = this;
var urlParams = window.location.search;
var p_id = 0;
var tableModel = new qx.ui.table.model.Simple();
with (tableModel) {
setColumns([ "Todo-Id",
"Kosten-Id",
"Typ-Id",
"ProfitCenter",
"Position",
"Menge",
"Einzelpreis",
"Einzelpreis Verkauf",
"Einheiten-Id",
"Einheit",
"Markup",
"Umlage",
"PT",
"Budget",
"Budget Verkauf",
"Ausgaben",
"Differenz",
"Differenz Verkauf",
"Datum",
"Wert aus" ],
[ "TodoId",
"CostId",
"ArtId",
"PC",
"Todo",
"Anzahl",
"Stueckpreis",
"Stueckpreis_Extern",
"EinheitId",
"Einheit",
"Markup",
"Umlage",
"PT",
"Budget",
"Budget_Extern",
"Ausgaben",
"Differenz",
"Differenz_Extern",
"Datum",
"Art" ]);
};
var tableCosts = new qx.ui.table.Table(tableModel);
with (tableCosts) {
set({ border:"inset-thin" });
getSelectionModel().setSelectionMode(qx.ui.table.selection.Model.SINGLE_SELECTION);
getTableColumnModel().setColumnVisible(0, false);
getTableColumnModel().setColumnVisible(1, false);
getTableColumnModel().setColumnVisible(2, false);
getTableColumnModel().setColumnVisible(7, false);
getTableColumnModel().setColumnVisible(8, false);
getTableColumnModel().setColumnVisible(10, false);
getTableColumnModel().setColumnVisible(11, false);
getTableColumnModel().setColumnVisible(14, false);
getTableColumnModel().setColumnVisible(17, false);
setColumnWidth(0, 0);
setColumnWidth(1, 0);
setColumnWidth(2, 0);
setColumnWidth(3, 75);
setColumnWidth(4, 150);
setColumnWidth(5, 50);
setColumnWidth(6, 75);
setColumnWidth(7, 0);
setColumnWidth(8, 0);
setColumnWidth(9, 75);
setColumnWidth(10, 0);
setColumnWidth(11, 0);
setColumnWidth(12, 50);
setColumnWidth(13, 75);
setColumnWidth(14, 0);
setColumnWidth(15, 75);
setColumnWidth(16, 75);
setColumnWidth(17, 0);
setColumnWidth(18, 75);
setColumnWidth(19, 75);
setWidth(855);
setHeight(600);
setLeft(50);
var tableRenderer = new
qx.ui.table.cellrenderer.Conditional("right", "", "", "");
tableRenderer.addNumericCondition("<", 0, null,
"FF0000", null, "bold");
getTableColumnModel().setDataCellRenderer(16,
tableRenderer);
};
if (urlParams.length > 0)
{
urlParams = urlParams.substr(1, urlParams.length);
var params = urlParams.split("&");
for(var i = 0; i < params.length; i++)
{
if(params[i].substr(0,4) == "p_id")
{
p_id =
params[i].substr(5,params[i].length);
}
}
}
if (p_id == 0)
{
var lblProjects = new
qx.ui.basic.Label("Projektauswahl:");
with (lblProjects)
{
setTop(50);
setLeft(50);
setWidth(125);
setHeight(22);
addToDocument();
}
var cboProjects = new qx.ui.form.ComboBox();
with (cboProjects)
{
setTop(50);
setLeft(130);
setWidth(200);
setHeight(22);
addToDocument();
};
with (tableCosts) {
setTop(100);
addToDocument();
}
// Projektliste holen
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
var data = qx.io.Json.parse(content);
var item;
for(var i = 0; i < data.length; i++)
{
var project = data[i];
item = new
qx.ui.form.ListItem(project["Name"]);
item.setValue(project["Id"] +=
"");
cboProjects.add(item);
}
cboProjects.setSelected(cboProjects.getList().getFirstChild());
}
catch(ex)
{
alert("Projektliste konnte nicht
geladen werden: " + ex.toString());
}
});
req.setParameter("action", "GetProjectList");
req.setTimeout(10000);
req.send();
cboProjects.addEventListener("changeSelected",
function(e){
myClass.p_id =
this.getList().getSelectedItem().getValue();
myClass.fillCostsTable(this.getList().getSelectedItem().getValue(), tableModel);
});
}
else
{
with (tableCosts) {
setTop(50);
addToDocument();
}
this.fillCostsTable(p_id, tableModel);
}
tableCosts.addEventListener("cellDblclick",function(e){
myClass.showExpenses(p_id,
this.getTable().getTableModel().getValue(1, e.getRow()));
});
},
showExpenses : function(pid, tcid) {
try
{
var doc = qx.ui.core.ClientDocument.getInstance();
var expDlg = new qx.ui.window.Window("Ausgaben
verwalten");
expDlg.setSpace(50, 1475, 75, 600);
doc.add(expDlg);
var gl = new qx.ui.layout.GridLayout();
gl.setLocation(0,0);
gl.setDimension(expDlg.getWidth(), expDlg.getHeight());
gl.setPadding(2);
expDlg.add(gl);
gl.setColumnCount(1);
gl.setColumnWidth(0, "100%");
gl.setRowCount(3);
gl.setRowHeight(0,"5%");
gl.setRowHorizontalAlignment(0, "left");
gl.setRowVerticalAlignment(0, "top");
gl.setRowHeight(1,"80%");
gl.setRowHorizontalAlignment(1, "middle");
gl.setRowVerticalAlignment(1, "middle");
gl.setRowHeight(2,"15%");
gl.setRowHorizontalAlignment(2, "right");
gl.setRowVerticalAlignment(2, "bottom");
// var projectname = new qx.core.Object();
// projectname.setUserData("Name", "test");
//
// var todoname = new qx.core.Object();
// todoname.setUserData("Name", "test");
//
// this.getProjectName(pid, projectname);
// this.getTodoName(pid, tcid, todoname);
//
// var lbl = new qx.ui.basic.Label("Ausgabentabelle
angefordert für das Projekt " + projectname.getUserData("Name") + " / " +
todoname.getUserData("Name"));
// gl.add(lbl, 0, 0);
var fl = new qx.ui.layout.FlowLayout();
fl.setPadding(2);
fl.setVerticalSpacing(4);
fl.setVerticalChildrenAlign("bottom");
fl.setHorizontalSpacing(2);
fl.setHorizontalChildrenAlign("right");
gl.add(fl, 0, 2);
var btnOk = new qx.ui.form.Button("OK");
btnOk.setDimension(75,25);
btnOk.addEventListener("execute", function(e) {
alert("Daten würden gespeichert werden...")
expDlg.close();
})
var btnCancel = new qx.ui.form.Button("Abbrechen");
btnCancel.setDimension(75,25);
btnCancel.addEventListener("execute", function(e) {
expDlg.close();
})
fl.add(btnCancel, btnOk);
var tableModel = new qx.ui.table.model.Simple();
with (tableModel) {
setColumns([ "Ausgaben-Id",
"Todo-Id",
"Mitarbeiter-Id",
"Einheiten-Id",
"Ausgabentyp-Id",
"Vertragstyp-Id",
"ProfitCenter",
"Vertrag",
"Mitarbeiter",
"T\u00E4tigkeit",
"Kostenspez.",
"Beschreibung",
"Von",
"Bis",
"Endmonat",
"PT",
"Menge",
"Einzelpreis",
"Einheit",
"Gesamtpreis",
"Rechnung" ],
[ "ExpenseId",
"TodoId",
"EmployeeId",
"UnitId",
"ExpenseTypeId",
"ContractTypeId",
"PC",
"Vertrag",
"Mitarbeiter",
"Todo",
"Kostenspezifikation",
"Beschreibung",
"Von",
"Bis",
"Endmonat",
"Personentage",
"Anzahl",
"Einzelpreis",
"Einheit",
"Summe",
"Rechnung" ]);
setColumnEditable(8, true);
setColumnEditable(9, true);
setColumnEditable(10, true);
setColumnEditable(11, true);
setColumnEditable(12, true);
setColumnEditable(13, true);
setColumnEditable(15, true);
setColumnEditable(16, true);
setColumnEditable(17, true);
setColumnEditable(18, true);
setColumnEditable(20, true);
};
var tableExpenses = new qx.ui.table.Table(tableModel);
with (tableExpenses) {
set({ border:"inset-thin" });
getSelectionModel().setSelectionMode(qx.ui.table.selection.Model.SINGLE_SELECTION);
getTableColumnModel().setColumnVisible(0,
false);
getTableColumnModel().setColumnVisible(1,
false);
getTableColumnModel().setColumnVisible(2,
false);
getTableColumnModel().setColumnVisible(3,
false);
getTableColumnModel().setColumnVisible(4,
false);
getTableColumnModel().setColumnVisible(5,
false);
setColumnWidth(0, 0);
setColumnWidth(1, 0);
setColumnWidth(2, 0);
setColumnWidth(3, 0);
setColumnWidth(4, 0);
setColumnWidth(5, 0);
setColumnWidth(6, 75);
setColumnWidth(7, 75);
setColumnWidth(8, 100);
setColumnWidth(9, 150);
setColumnWidth(10, 100);
setColumnWidth(11, 200);
setColumnWidth(12, 75);
setColumnWidth(13, 75);
setColumnWidth(14, 100);
setColumnWidth(15, 50);
setColumnWidth(16, 50);
setColumnWidth(17, 75);
setColumnWidth(18, 75);
setColumnWidth(19, 75);
setColumnWidth(20, 150);
setWidth(1430);
//setHeight(400);
//setLocation(20,40);
};
this.fillExpensesTable(pid, tcid, tableModel);
//var emptyRow = new
Array("","","","","","","","","","","","","","","","","","","","","");
//var wrapper = new Array(emptyRow);
//tableExpenses.getTableModel().addRows(wrapper);
//tableModel.addRows(new
Array("","","","","","","","","","","","","","","","","","","","",""));
gl.add(tableExpenses, 0, 1);
expDlg.open();
}
catch(ex)
{
alert("Fehler bei Anforderung der Ausgabentabelle: " +
ex.toString());
}
},
fillExpensesTable : function(pid, tcid, tableModel) {
try
{
//tableModel.removeRows(0, tableModel.getRowCount());
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("tc_id", tcid);
req.setParameter("action", "GetExpensesList");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
//alert(content);
var tabledata =
qx.io.Json.parse(content);
tableModel.setData(tabledata);
var emptyRow = new
Array("","","","","","","","","","","","","","","","","","","","","");
var wrapper = new
Array(emptyRow);
tableModel.addRows(wrapper);
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Tabellendaten: " + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Tabelle: " +
ex.toString());
}
},
fillCostsTable : function(pid, tableModel) {
try
{
tableModel.removeRows(0, tableModel.getRowCount());
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("action", "GetCostsList");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
//alert(content);
var tabledata =
qx.io.Json.parse(content);
tableModel.setData(tabledata);
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Tabellendaten: " + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Tabelle: " +
ex.toString());
}
},
getProjectName : function(pid, projectname) {
try
{
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("action", "GetProjectName");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
var obj =
qx.io.Json.parse(content);
projectname.setUserData("Name",
obj["Projectname"]);
//alert(projectname.getUserData("Name"));
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Projektdaten: " + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Projektdaten: " +
ex.toString());
}
},
getTodoName : function(pid, tcid, todoname) {
try
{
var req = new
qx.io.remote.Request("http://devserver/projectdetail/costs_report/source/costs_report_backend.php","GET","text/plain";);
req.setParameter("p_id", pid);
req.setParameter("tc_id", tcid);
req.setParameter("action", "GetTodoName");
req.setTimeout(10000);
req.addEventListener("completed", function(e){
try
{
var content = e.getContent();
if (content.length > 0)
{
var obj =
qx.io.Json.parse(content);
todoname.setUserData("Name",
obj["Todoname"]);
//alert(todoname.getUserData("Name"));
}
}
catch (ex)
{
alert("Fehler bei Erhalt der Tododaten:
" + ex.toString());
}
});
req.send();
}
catch(ex)
{
alert("Fehler bei Anforderung der Tododaten: " +
ex.toString());
}
},
/**
* TODOC
*
* @type member
*/
close : function()
{
this.base(arguments);
// Prompt user
// return "Do you really want to close the application?";
},
/**
* TODOC
*
* @type member
*/
terminate : function() {
this.base(arguments);
}
},
/*
*****************************************************************************
SETTINGS
*****************************************************************************
*/
settings : {
"af.resourceUri" : "./resource"
}
});
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
