openledger-developer Mailing List for OpenLedger (Page 2)
Brought to you by:
klavs
Menu
▾
▴
openledger-developer — Developer list for discussing SL3 development
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(15) |
Mar
(83) |
Apr
(23) |
May
(10) |
Jun
(6) |
Jul
(14) |
Aug
(5) |
Sep
(1) |
Oct
(7) |
Nov
(6) |
Dec
(1) |
|---|
|
From: Ang T. C. <at...@ew...> - 2005-07-28 02:20:37
|
no problem, thanks anyway! :) udono wrote: > Hello Ang, > sorry Iam temporarily very busy. But when I get time, Ill test your > last classes. > > Ang Tun CHek schrieb: > >> To All >> i have few question about sql-ledger >> >> 1) what is the purpose of status table > > I think it's a table for the Systemstatus. That mean, if you print > out, or send an Email of a document, this status will be stored in > this table. The value will be displayed on the right side of the > Bottom: 'printed' or 'emailed'... but i can be wrong, if have no > database to evaluate... > >> 2) what is the price break in customer price matrix > > > dont know. > >> 3) what does function do in IS.pm -> price_matrix > > don't know. Maybe create a vendor-specific Price list? Is it connected > to the vendor-preferences, there you can link services or goods to the > vendor?! > > Greetings from Udo |
|
From: Tony F. <to...@sy...> - 2005-07-27 18:47:49
|
On Wed, 2005-07-27 at 10:05, Ang Tun CHek wrote:
> To All
> i have few question about sql-ledger
>
> 1) what is the purpose of status table
Don't know off hand.
> 2) what is the price break in customer price matrix
pricebreak is for quantity pricing. If the customer orders pricebreak or
more of the part the sellprice will be the one used:
e.g.
parts_id customer_id pricebreak sellprice
1003 1001 0 10.00
1003 1001 10 9.50
If customer 1001 orders 9 of part 1003 the price is $10.00 each. If he
orders 10 (or more) the price is $9.50.
> 3) what does function do in IS.pm -> price_matrix
IS->price_matrix() is where all the SQL and stuff for the partscustomer
and partsvendor tables are. It summarizes the info into
$form->{"pricematrix_$x"}. Say using the partscustomer data above an
invoice is created for customer 1001 and part 1003 is added to line 3.
IS->price_matrix() would create a $form->{"pricematrix_3"} that contains
the string "0:10.00 10:9.50".
--
Tony Fraser
to...@sy...
Sybaspace Internet Solutions System Administrator
phone: (250) 246-5368 fax: (250) 246-5398
|
|
From: udono <ud...@gm...> - 2005-07-27 17:09:06
|
Hello Ang, sorry Iam temporarily very busy. But when I get time, Ill test your last classes. Ang Tun CHek schrieb: > To All > i have few question about sql-ledger > > 1) what is the purpose of status table I think it's a table for the Systemstatus. That mean, if you print out, or send an Email of a document, this status will be stored in this table. The value will be displayed on the right side of the Bottom: 'printed' or 'emailed'... but i can be wrong, if have no database to evaluate... > 2) what is the price break in customer price matrix dont know. > 3) what does function do in IS.pm -> price_matrix don't know. Maybe create a vendor-specific Price list? Is it connected to the vendor-preferences, there you can link services or goods to the vendor?! Greetings from Udo -- Udo S. |
|
From: Ang T. C. <at...@ew...> - 2005-07-27 16:49:08
|
To All i have few question about sql-ledger 1) what is the purpose of status table 2) what is the price break in customer price matrix 3) what does function do in IS.pm -> price_matrix from Ang |
|
From: Joseph <sy...@in...> - 2005-07-26 19:56:50
|
Hi Ang, I would like to try to install it open-ledger but I need some instructions where to start. Does the installation goes the same routine as sql-ledger? I think I need to create another database, upload my data and experiment isn't it? Is there anything special I need to configure or set up? I'm currently on sql-ledger ver. 2.2.7 #Joseph On Wed, 2005-07-27 at 01:30 +0800, Ang Tun CHek wrote: > hi > i had updated the invoice module. please try > however, i would like get some comments from you all. > > thanks > Ang |
|
From: Ang T. C. <at...@ew...> - 2005-07-26 17:14:14
|
hi i had updated the invoice module. please try however, i would like get some comments from you all. thanks Ang |
|
From: Ang T. C. <at...@ew...> - 2005-07-22 17:57:30
|
To All, the invoice module is almost complete,but save function is not yet ready.Eventhough, the function are based on sql-ledger but a lot of modification is made to make it object oriented.So, can anyone help me to test this module to make sure all the calculatation of exchange rate and taxes are correct. i will keep on to finish the save function as soon as possible thanks Ang |
|
From: Ang T. C. <at...@ew...> - 2005-07-18 06:46:04
|
To all, please try the new updates and classes regards Ang |
|
From: <at...@ew...> - 2005-07-06 05:56:41
|
hi thanks for your help udono. i uploaded test3.pl and some updates thanks Ang ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |
|
From: udono <ud...@gm...> - 2005-06-30 18:18:05
|
Hello Ang,
udono schrieb:
[...]
> test2.pl works with some errors, i try to follow...
test2 works good with german Chart, but there are some minor errors
in the query in line 850...
I quoted the Values this way, and it worked:
$query = qq|INSERT INTO partscustomer (parts_id, customer_id,
pricegroup_id, pricebreak, sellprice, curr,
validfrom, validto)
VALUES ('$self->{id}', '$vc->{customer}->{id}',
'$vc->{pricegroup_id}', '$vc->{"pricebreak"}',
'$vc->{"customerprice"}', '$vc->{"customercurr"}', |
.$user->dbquote($self->{"validfrom"},
"SQL_DATE").qq|, |
.$user->dbquote($self->{"validto"},
"SQL_DATE").qq|)|;
---------8<---------
Greetings Udo
|
|
From: udono <ud...@gm...> - 2005-06-30 17:45:18
|
Hello Ang, Ang Tun Chek schrieb: > hi > Test3.pl has a long wait time while retrieve all data for parts class. i > hope someone can help me to improve this > thanks I would like to test, but in the cvs isn't a file named test3.pl... test2.pl works with some errors, i try to follow... Greetings Udo -- Udo S. |
|
From: Ang T. C. <at...@ew...> - 2005-06-19 04:47:49
|
hi Test3.pl has a long wait time while retrieve all data for parts class. i hope someone can help me to improve this thanks from Ang TUn Chek |
|
From: Ang T. C. <at...@ew...> - 2005-06-16 15:14:10
|
To all, test3.pl contains sample code to retrieve and return an array of Customer, vendor, parts or service based on the given query. You can rewrite the sql "where" query and rerun the test, it will return an array of the class. i hope this helps those who start to write the report module and search interface. cheers Ang |
|
From: Ang T. C. <at...@ew...> - 2005-06-14 16:39:29
|
To All, A working IC.pm class is almost finish. you now be able to add Part with this class Some more works are required for adding service, labor and assembly. and this will be done soon. i hope somebody can do a full test with this class because this class is more complex than customer or vendor class. please use test2.pl for testing thanks from Ang Tun Chek |
|
From: Ang T. C. <at...@ew...> - 2005-06-05 04:42:22
|
To all Chart class is now embeded successfully into Customer and Vendor class. All customer and vendor taxes are stored in Chart classes for ease of retriving infomation. Please try out with test.pl thanks Ang Tun Chek |
|
From: udono <ud...@gm...> - 2005-05-17 17:25:42
|
Udo Spallek schrieb: > Hello Ang, > > > Modern_design88 schrieb: > >> To All >> i would like to get opinion from you all either to have one class that >> serve as part, service and assembly >> or have 3 classes for each of them. >> >> any pro or cons of doing either way? pro: general 'item' or 'good' class for parts, service and assembly would be great for non redundant code (inheritance). Just the differences to 'item' should build into own parts, service and assembly classes. The same with persons like customer, vendor, user, employee. All of them got a Name, Address, Phone ... con: No cons, i think. Greetings Udo |
|
From: Modern_design88 <wa...@pl...> - 2005-05-13 15:35:28
|
To All i would like to get opinion from you all either to have one class that serve as part, service and assembly or have 3 classes for each of them. any pro or cons of doing either way? cheers ANg |
|
From: Ang T. C. <tc...@st...> - 2005-05-12 01:40:07
|
Joseph wrote: >On Thu, 2005-05-12 at 01:41 +0000, Ang Tun Chek wrote: > > >>i just do what i can do, well i am not good on technical writing. i >>hope >>somebody can do it for me, any question about my code are welcome. >>please write to me. >> >> >> > >Don't worry about technical writing (or spelling) as long as the code >has come comments what this section does or what is doing would be >enough for others to look and/or make an improvement. > >It would be very hard to for somebody else to write a comments if >somebody didn't write the code. Some body else can add a correction or >additional explanation. > > > comments and code example are available in test.pl and test2.pl. btw, i will try to add more comments in other modules. |
|
From: Joseph <sy...@in...> - 2005-05-11 17:41:47
|
On Thu, 2005-05-12 at 01:41 +0000, Ang Tun Chek wrote: > > > i just do what i can do, well i am not good on technical writing. i > hope > somebody can do it for me, any question about my code are welcome. > please write to me. > Don't worry about technical writing (or spelling) as long as the code has come comments what this section does or what is doing would be enough for others to look and/or make an improvement. It would be very hard to for somebody else to write a comments if somebody didn't write the code. Some body else can add a correction or additional explanation. -- #Joseph |
|
From: Ang T. C. <at...@ew...> - 2005-05-11 17:31:06
|
Klavs Klavsen wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >Hi Ang, > >on 05/12/05 01:27 Ang Tun Chek wrote: > > >>To all, >>Currently, my code establish a database connection for each function. >>so my question is >> >>1) will the speed of executing reduce by doing this way? >> >> >> >Well yes - it does take a little time to open up and tear down a >connection, but IMHO performance is not that important :) > > > i will stayed with one function with one connection and observe the performance first >p.s. I'm glad to see you furthering the project - I hope you have good >use for the functions you write yourself and I would be very happy if >you could share with us, how/what you use these functions for.. I would >like to add a page on the site, listing everyday functions the current >codebase is used for. I intend to add my own usage too ofcourse :) > > > i just do what i can do, well i am not good on technical writing. i hope somebody can do it for me, any question about my code are welcome. please write to me. thanks from Ang |
|
From: Ang T. C. <at...@ew...> - 2005-05-11 17:25:47
|
To all new updates had been uploaded. please refer test2.pl for sample from Ang |
|
From: Klavs K. <kl...@vs...> - 2005-05-11 15:32:09
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Ang, on 05/12/05 01:27 Ang Tun Chek wrote: > To all, > Currently, my code establish a database connection for each function. > so my question is > > 1) will the speed of executing reduce by doing this way? > Well yes - it does take a little time to open up and tear down a connection, but IMHO performance is not that important :) > 2) is it better to establish a database connetion at the beginning of > the program and termiate at the end? so only one connection required for > the program > Well - I'd say yes - except ofcourse you have to control rollback and commits in the individual function/method. Atleast this is the way I've done it in the classes I've written and IMHO it is the "right" thing to do - but nothing urgent :) p.s. I'm glad to see you furthering the project - I hope you have good use for the functions you write yourself and I would be very happy if you could share with us, how/what you use these functions for.. I would like to add a page on the site, listing everyday functions the current codebase is used for. I intend to add my own usage too ofcourse :) - -- Regards, Klavs Klavsen, GSEC - kl...@vs... - http://www.vsen.dk PGP: 7E063C62/2873 188C 968E 600D D8F8 B8DA 3D3A 0B79 7E06 3C62 "Those who do not understand Unix are condemned to reinvent it, poorly." --Henry Spencer -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFCgiV3PToLeX4GPGIRAhX2AKCQjavZlEQVAQjRW685jmb55BPHQQCdFAFV 1iXnW5Q8ZINJBVfieq0Dpko= =RdmL -----END PGP SIGNATURE----- |
|
From: Ang T. C. <at...@ew...> - 2005-05-11 15:17:28
|
To all, Currently, my code establish a database connection for each function. so my question is 1) will the speed of executing reduce by doing this way? 2) is it better to establish a database connetion at the beginning of the program and termiate at the end? so only one connection required for the program cheers Ang |
|
From: Ang T. C. <at...@ew...> - 2005-05-11 12:50:33
|
To All,
i added new Chart class and test2.pl for testing and some updates
to other class to make them more Object oriented (please refer back to
test.pl).
cheers
Ang
|
|
From: Ang T. C. <at...@ew...> - 2005-05-03 16:18:16
|
To All, i had upload a new Service module/class. please give it a try. cheers Ang |
