web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Webshop interfaces

[Simon H. <si...@ac...>]

Thanks Phil, I will check out Richards work.

Regards
Simon

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.


> Sent: Monday, February 02, 2015 at 7:17 AM
> From: "Phil Daintree" <ph...@lo...>
> To: "webERP Developers" <web...@li...>
> Subject: Re: [WebERP-developers] Webshop interfaces
>
> Ricard has done a job on an open-cart integration - which is freely 
> available at:
> 
> http://www.weberp.org/forum/showthread.php?tid=2273
> 
> I also did an interface to zen-cart but I no longer support this having 
> built a webSHOP directly into webERP....
> http://www.logicworks.co.nz/webSHOP.html
> 
> I do charge for this though and neither does it have the bells and 
> whistles of the leading open-source shopping systems.
> 
> 
> Phil
> 
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
> 
> On 02/02/15 07:03, Andrew Galuski wrote:
> > I have 1 integration point from webERP into Magento(inventory levels). Long term I will build others.
> >
> > Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
> >    Original Message
> > From: Simon Hill
> > Sent: Sunday, February 1, 2015 11:35 AM
> > To: web...@li...
> > Reply To: webERP Developers
> > Subject: [WebERP-developers] Webshop interfaces
> >
> >
> > Hello weberp,
> >
> > We are looking to move from an old erp system to a web based erp for a number of our clients in the internet retailing sector. Does weberp have interfaces to any webshops, specifically if possible magento oscommerce and opencart?
> >
> > Regards
> > Simon
> >
> > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
> >
> > ------------------------------------------------------------------------------
> > Dive into the World of Parallel Programming. The Go Parallel Website,
> > sponsored by Intel and developed in partnership with Slashdot Media, is your
> > hub for all things parallel software development, from weekly thought
> > leadership blogs to news, videos, case studies, tutorials and more. Take a
> > look and join the conversation now. http://goparallel.sourceforge.net/
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> > ------------------------------------------------------------------------------
> > Dive into the World of Parallel Programming. The Go Parallel Website,
> > sponsored by Intel and developed in partnership with Slashdot Media, is your
> > hub for all things parallel software development, from weekly thought
> > leadership blogs to news, videos, case studies, tutorials and more. Take a
> > look and join the conversation now. http://goparallel.sourceforge.net/
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> 
> 
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 

Re: [WebERP-developers] Webshop interfaces

[Phil D. <ph...@lo...>]

Ricard has done a job on an open-cart integration - which is freely 
available at:

http://www.weberp.org/forum/showthread.php?tid=2273

I also did an interface to zen-cart but I no longer support this having 
built a webSHOP directly into webERP....
http://www.logicworks.co.nz/webSHOP.html

I do charge for this though and neither does it have the bells and 
whistles of the leading open-source shopping systems.


Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 02/02/15 07:03, Andrew Galuski wrote:
> I have 1 integration point from webERP into Magento(inventory levels). Long term I will build others.
>
> Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
>    Original Message
> From: Simon Hill
> Sent: Sunday, February 1, 2015 11:35 AM
> To: web...@li...
> Reply To: webERP Developers
> Subject: [WebERP-developers] Webshop interfaces
>
>
> Hello weberp,
>
> We are looking to move from an old erp system to a web based erp for a number of our clients in the internet retailing sector. Does weberp have interfaces to any webshops, specifically if possible magento oscommerce and opencart?
>
> Regards
> Simon
>
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Webshop interfaces

[Andrew G. <aga...@re...>]

I have 1 integration point from webERP into Magento(inventory levels). Long term I will build others.

Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
  Original Message
From: Simon Hill
Sent: Sunday, February 1, 2015 11:35 AM
To: web...@li...
Reply To: webERP Developers
Subject: [WebERP-developers] Webshop interfaces


Hello weberp,

We are looking to move from an old erp system to a web based erp for a number of our clients in the internet retailing sector. Does weberp have interfaces to any webshops, specifically if possible magento oscommerce and opencart?

Regards
Simon

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] Webshop interfaces

[Simon H. <si...@ac...>]

Hello weberp,

We are looking to move from an old erp system to a web based erp for a number of our clients in the internet retailing sector. Does weberp have interfaces to any webshops, specifically if possible magento oscommerce and opencart?

Regards
Simon

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

[WebERP-developers] New version 4.12

[Phil D. <ph...@lo...>]

I have rolled up a fresh release containing all the latest code and bug 
fixes.

Key changes include:

Extensive improvements from Rafael Chacon including:
- Modifications to the Spanish translation
- Adding of manual links and bookmarks
- Additional manual text for some utility scripts
- Improvements to the manual stylesheet
- Facility to turn on/off the dashboard for specific users
- Default theme now modifiable from System Parameters script
- Standardisation of labels in different scripts.
- Translation of some of the database data for transaction types

Pak Ricard added a facility to automatically translate database item 
descriptions and long descriptions using google translate
Andrew Galuski Added a new Quality Module - this is quite an extensive 
and impressive addition to webERP - many thanks Andrew for contributing 
this work.
Exson Qu has been busy with many bug fixes - see change log for full 
details.
Phil Daintree Added a new script Z_UpdateItemCosts.php that allows a csv 
import of items and costs and updates the standard cost based on 
imported data
Also removed the $db parameter from all DB_query() DB_Txn_Begin($db) 
DB_Txn_Commit($db) DB_Txn_Rollback($db)calls - as $db is now global


Phil
Phil Daintree Logic Works Ltd - +64 (0)275 567890 
http://www.logicworks.co.nz

Re: [WebERP-developers] locale/en_IN.utf8

[Rafael C. <raf...@gm...>]

Hi,

I added info to Manual about Indian Numbering System.

Best regards, Rafael.

2015-01-23 18:26 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hi Phil,
>
> Thank you, very much.
>
> Best regards, Rafael.
>
> 2015-01-23 18:22 GMT-06:00 Phil Daintree <ph...@lo...>:
>
>  Well many people in India do speak English but want to see numbers
>> formatted in their special format... having a record in the
>> LanguagesArray.php and a folder under locale/en_IN.utf8 allows us to have -
>> an English (British) no strings translated as there is no matching strings
>> in a messages.mo but the number format logic in place from the
>> LanguagesArray.php
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>
>> On 24/01/15 09:28, Rafael Chacón wrote:
>>
>> Hello,
>>
>> Anyone know if the purpose of "~/locale/en_IN.utf8" (English-INDIA) empty
>> folder is to use Indian number format in English?
>>
>> Best regards, Rafael.
>>
>> 2014-08-13 10:30 GMT-06:00 Rafael Chacón <raf...@gm...>
>> :
>>
>>> Hello,
>>>
>>> The origin of my question is that the locale/en_IN.utf8/LC_MESSAGES
>>> folder is empty.
>>>
>>> Regards, Rafael.
>>>
>>>
>>>
>>>
>>> 2014-08-13 9:15 GMT-06:00 Rafael Chacón <raf...@gm...>
>>> :
>>>
>>>> Hello,
>>>>
>>>> Someone is using the English - INDIA (en-IN) ?
>>>>
>>>>  Regards, Rafael.
>>>>
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>> GigeNET is offering a free month of service with a new server in Ashburn.
>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>> Higher redundancy.Lower latency.Increased capacity.Completely compliant.http://p.sf.net/sfu/gigenet
>>
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>> GigeNET is offering a free month of service with a new server in Ashburn.
>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>> http://p.sf.net/sfu/gigenet
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>

Re: [WebERP-developers] LanguageSetup.php, $Collect = array of arrays

[Rafael C. <raf...@gm...>]

Hi Exson,

thank you, very much.

Best regards, Rafael.

2015-01-24 10:20 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi,Rafael,*
>
>         It's used to detect users' language automatically during
> installation.
>
>        Best regards!
>
>        Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/LanguageSetup-php-Collect-array-of-arrays-tp4657999p4658005.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] LanguageSetup.php, $Collect = array of arrays

[ExsonQu <hex...@gm...>]

*Hi,Rafael,*

        It's used to detect users' language automatically during
installation. 

       Best regards!

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/LanguageSetup-php-Collect-array-of-arrays-tp4657999p4658005.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] locale/en_IN.utf8

[Rafael C. <raf...@gm...>]

Hi Phil,

Thank you, very much.

Best regards, Rafael.

2015-01-23 18:22 GMT-06:00 Phil Daintree <ph...@lo...>:

>  Well many people in India do speak English but want to see numbers
> formatted in their special format... having a record in the
> LanguagesArray.php and a folder under locale/en_IN.utf8 allows us to have -
> an English (British) no strings translated as there is no matching strings
> in a messages.mo but the number format logic in place from the
> LanguagesArray.php
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 24/01/15 09:28, Rafael Chacón wrote:
>
> Hello,
>
> Anyone know if the purpose of "~/locale/en_IN.utf8" (English-INDIA) empty
> folder is to use Indian number format in English?
>
> Best regards, Rafael.
>
> 2014-08-13 10:30 GMT-06:00 Rafael Chacón <raf...@gm...>:
>
>> Hello,
>>
>> The origin of my question is that the locale/en_IN.utf8/LC_MESSAGES
>> folder is empty.
>>
>> Regards, Rafael.
>>
>>
>>
>>
>> 2014-08-13 9:15 GMT-06:00 Rafael Chacón <raf...@gm...>:
>>
>>> Hello,
>>>
>>> Someone is using the English - INDIA (en-IN) ?
>>>
>>>  Regards, Rafael.
>>>
>>
>>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.http://p.sf.net/sfu/gigenet
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] locale/en_IN.utf8

[Phil D. <ph...@lo...>]

Well many people in India do speak English but want to see numbers 
formatted in their special format... having a record in the 
LanguagesArray.php and a folder under locale/en_IN.utf8 allows us to 
have - an English (British) no strings translated as there is no 
matching strings in a messages.mo but the number format logic in place 
from the LanguagesArray.php

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 24/01/15 09:28, Rafael Chacón wrote:
> Hello,
>
> Anyone know if the purpose of "~/locale/en_IN.utf8" (English-INDIA) 
> empty folder is to use Indian number format in English?
>
> Best regards, Rafael.
>
> 2014-08-13 10:30 GMT-06:00 Rafael Chacón 
> <raf...@gm... <mailto:raf...@gm...>>:
>
>     Hello,
>
>     The origin of my question is that the
>     locale/en_IN.utf8/LC_MESSAGES folder is empty.
>
>     Regards, Rafael.
>
>
>
>
>     2014-08-13 9:15 GMT-06:00 Rafael Chacón
>     <raf...@gm...
>     <mailto:raf...@gm...>>:
>
>         Hello,
>
>         Someone is using the English - INDIA (en-IN) ?
>
>         Regards, Rafael.
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] New version

[Phil D. <ph...@lo...>]

Maybe 4.12 I am thinking
Regards
Phil
Phil Daintree
Cell: +64 (0) 275 567890
http://www.logicworks.co.nz

On 24 January 2015 9:11:37 AM NZDT, "Rafael Chacón" <raf...@gm...> wrote:
>Are we going to launch a new release or just upgrade 4.11.5.b with bug
>fixes?
>
>2015-01-23 2:29 GMT-06:00 Tim Schofield <tim...@gm...>:
>
>> Doesn't need to be this complex as $db should be removed from
>> everything except the includes/ConnectDB*.inc files so something like
>>
>> grep '$db' * --exclude=ConnectDB*.inc --exclude=Change.log -rRnw
>>
>> should be used - I note that there are a lot of instances of $db that
>> still need removing.
>>
>> Tim
>>
>> On 22 January 2015 at 04:38, Phil Daintree <ph...@lo...>
>wrote:
>> > I used this to do the whole lot in one go, I figured it would be
>too
>> > risky to do it manually as I would have missed some for sure. May
>help
>> > you blast the remaining ones in your modified code.
>> >
>> >  >find /usr/share/nginx/html/webERP/ -type f -name "*.php" -name
>"*.inc"
>> > -exec sed -i -e '/.*[dD][bB]_[Qq]uery.*,.*/s/$db//g' {} \;
>> >
>> > where
>> >
>> > /usr/share/nginx/html/webERP/
>> >
>> > is the path to my working copy.
>> >
>> > Phil
>> >
>> > Phil Daintree
>> > Logic Works Ltd - +64 (0)275 567890
>> > http://www.logicworks.co.nz
>> >
>> > On 22/01/15 03:03, Andrew Galuski wrote:
>> >> It will be a large effort on my part (Especially identifying all
>my
>> modifications I have that may not be in the main trunk (Like the
>picking,
>> packing, shipping functionality that is separate from Invoicing)
>> >> Quick question, If I still call DB_Query() in code with the $db
>> parameter and the include file doesn't expect it will I get a hard
>error or
>> a warning?
>> >>
>> >> Best Regards,
>> >> Andrew Galuski
>> >>
>> >>
>> >> -----Original Message-----
>> >> From: Phil Daintree [mailto:ph...@lo...]
>> >> Sent: Tuesday, January 20, 2015 11:38 PM
>> >> To: webERP Developers
>> >> Subject: [WebERP-developers] New version
>> >>
>> >> Rafael suggested we go for a new version recently.
>> >> We last released in October - I thought it was more recent than
>that.
>> >> There are a few bug fixes in there and a whole load of work I did
>to
>> change the DB_query() calls to exclude the global $db in them. Would
>be
>> interested to know what others think about another release now?
>> >>
>> >> --
>> >> Phil
>> >>
>> >> Phil Daintree
>> >> Logic Works Ltd - +64 (0)275 567890
>> >> http://www.logicworks.co.nz
>> >>
>> >>
>> >>
>>
>------------------------------------------------------------------------------
>> >> New Year. New Location. New Benefits. New Data Center in Ashburn,
>VA.
>> >> GigeNET is offering a free month of service with a new server in
>> Ashburn.
>> >> Choose from 2 high performing configs, both with 100TB of
>bandwidth.
>> >> Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>> >> http://p.sf.net/sfu/gigenet
>> >> _______________________________________________
>> >> Web-erp-developers mailing list
>> >> Web...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> >>
>> >>
>>
>------------------------------------------------------------------------------
>> >> New Year. New Location. New Benefits. New Data Center in Ashburn,
>VA.
>> >> GigeNET is offering a free month of service with a new server in
>> Ashburn.
>> >> Choose from 2 high performing configs, both with 100TB of
>bandwidth.
>> >> Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>> >> http://p.sf.net/sfu/gigenet
>> >> _______________________________________________
>> >> Web-erp-developers mailing list
>> >> Web...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> >>
>> >
>> >
>> >
>>
>------------------------------------------------------------------------------
>> > New Year. New Location. New Benefits. New Data Center in Ashburn,
>VA.
>> > GigeNET is offering a free month of service with a new server in
>Ashburn.
>> > Choose from 2 high performing configs, both with 100TB of
>bandwidth.
>> > Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>> > http://p.sf.net/sfu/gigenet
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>> --
>> Course View Towers,
>> Plot 21 Yusuf Lule Road,
>> Kampala
>> T   +256 (0) 312 314 418
>> M +256 (0) 752 963 325
>> www.weberpafrica.com
>> Twitter: @TimSchofield2
>> Blog: http://weberpafrica.blogspot.co.uk/
>>
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>GigeNET is offering a free month of service with a new server in
>Ashburn.
>Choose from 2 high performing configs, both with 100TB of bandwidth.
>Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>http://p.sf.net/sfu/gigenet
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] locale/en_IN.utf8

[Rafael C. <raf...@gm...>]

Hello,

Anyone know if the purpose of "~/locale/en_IN.utf8" (English-INDIA) empty
folder is to use Indian number format in English?

Best regards, Rafael.

2014-08-13 10:30 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hello,
>
> The origin of my question is that the locale/en_IN.utf8/LC_MESSAGES folder
> is empty.
>
> Regards, Rafael.
>
>
>
>
> 2014-08-13 9:15 GMT-06:00 Rafael Chacón <raf...@gm...>:
>
>> Hello,
>>
>> Someone is using the English - INDIA (en-IN) ?
>>
>> Regards, Rafael.
>>
>
>

Re: [WebERP-developers] New version

[Rafael C. <raf...@gm...>]

Are we going to launch a new release or just upgrade 4.11.5.b with bug
fixes?

2015-01-23 2:29 GMT-06:00 Tim Schofield <tim...@gm...>:

> Doesn't need to be this complex as $db should be removed from
> everything except the includes/ConnectDB*.inc files so something like
>
> grep '$db' * --exclude=ConnectDB*.inc --exclude=Change.log -rRnw
>
> should be used - I note that there are a lot of instances of $db that
> still need removing.
>
> Tim
>
> On 22 January 2015 at 04:38, Phil Daintree <ph...@lo...> wrote:
> > I used this to do the whole lot in one go, I figured it would be too
> > risky to do it manually as I would have missed some for sure. May help
> > you blast the remaining ones in your modified code.
> >
> >  >find /usr/share/nginx/html/webERP/ -type f -name "*.php" -name "*.inc"
> > -exec sed -i -e '/.*[dD][bB]_[Qq]uery.*,.*/s/$db//g' {} \;
> >
> > where
> >
> > /usr/share/nginx/html/webERP/
> >
> > is the path to my working copy.
> >
> > Phil
> >
> > Phil Daintree
> > Logic Works Ltd - +64 (0)275 567890
> > http://www.logicworks.co.nz
> >
> > On 22/01/15 03:03, Andrew Galuski wrote:
> >> It will be a large effort on my part (Especially identifying all my
> modifications I have that may not be in the main trunk (Like the picking,
> packing, shipping functionality that is separate from Invoicing)
> >> Quick question, If I still call DB_Query() in code with the $db
> parameter and the include file doesn't expect it will I get a hard error or
> a warning?
> >>
> >> Best Regards,
> >> Andrew Galuski
> >>
> >>
> >> -----Original Message-----
> >> From: Phil Daintree [mailto:ph...@lo...]
> >> Sent: Tuesday, January 20, 2015 11:38 PM
> >> To: webERP Developers
> >> Subject: [WebERP-developers] New version
> >>
> >> Rafael suggested we go for a new version recently.
> >> We last released in October - I thought it was more recent than that.
> >> There are a few bug fixes in there and a whole load of work I did to
> change the DB_query() calls to exclude the global $db in them. Would be
> interested to know what others think about another release now?
> >>
> >> --
> >> Phil
> >>
> >> Phil Daintree
> >> Logic Works Ltd - +64 (0)275 567890
> >> http://www.logicworks.co.nz
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> >> GigeNET is offering a free month of service with a new server in
> Ashburn.
> >> Choose from 2 high performing configs, both with 100TB of bandwidth.
> >> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> >> http://p.sf.net/sfu/gigenet
> >> _______________________________________________
> >> Web-erp-developers mailing list
> >> Web...@li...
> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >>
> ------------------------------------------------------------------------------
> >> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> >> GigeNET is offering a free month of service with a new server in
> Ashburn.
> >> Choose from 2 high performing configs, both with 100TB of bandwidth.
> >> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> >> http://p.sf.net/sfu/gigenet
> >> _______________________________________________
> >> Web-erp-developers mailing list
> >> Web...@li...
> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >
> >
> >
> ------------------------------------------------------------------------------
> > New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> > GigeNET is offering a free month of service with a new server in Ashburn.
> > Choose from 2 high performing configs, both with 100TB of bandwidth.
> > Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> > http://p.sf.net/sfu/gigenet
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>

[WebERP-developers] LanguageSetup.php, $Collect = array of arrays

[Rafael C. <raf...@gm...>]

Hi,

In LanguageSetup.php, line 28, there is an array of arrays ($Collect):

<code>
$Collect = array(

'US'=>array('en_US.utf8','en_GB.utf8','ja_JP.utf8','hi_IN.utf8','mr_IN.utf8','sw_KE.utf8','tr_TR.utf8','vi_VN.utf8','zh_CN.utf8','zh_HK.utf8','zh_TW.utf8'),
    'IN'=>array('en_IN.utf8'),

'EE'=>array('ar_EG.utf8','cz_CZ.utf8','fr_CA.utf8','fr_FR.utf8','hr_HR.utf8','pl_PL.utf8','ru_RU.utf8','sq_AL.utf8','sv_SE.utf8'),

'FR'=>array('ar_EG.utf8','cz_CZ.utf8','fr_CA.utf8','fr_FR.utf8','hr_HR.utf8','pl_PL.utf8','ru_RU.utf8','sq_AL.utf8','sv_SE.utf8'),

'GM'=>array('de_DE.utf8','el_GR.utf8','es_ES.utf8','fa_IR.utf8','id_ID.utf8','it_IT.utf8','ro_RO.utf8','lv_LV.utf8','nl_NL.utf8','pt_BR.utf8','pt_PT.utf8')
    );
foreach($Collect as $Key=>$Value) {
    if(in_array($Language,$Value)) {
        $Lang = $Key;
        $_SESSION['Lang'] = $Lang;
    }
}
</code>

What is the purpose of $Lang? (a language number pattern; see:
~/javascripts/MiscFunctions.js, function rLocaleNumber() ).

I think 'IN'=>array(...) should include 'hi_IN.utf8' and 'mr_IN.utf8'. Am I
right?

Best regards, Rafael.

Re: [WebERP-developers] New version

[Andrew G. <aga...@re...>]

I will work on it!

Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
From: Phil Daintree
Sent: Wednesday, January 21, 2015 11:35 PM
To: webERP Developers
Reply To: webERP Developers
Subject: Re: [WebERP-developers] New version


Well on that basis, if it is easy to bring it in - would be great!


Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 17:50, Andrew Galuski wrote:
No need for a parameter and the code added didn't require using the new functionality. Anybody with security to invoice can skip picking and shipping and invoice directly. If picking already done somebody with permissions to invoice can skip 'shipping' step as well. However if you wish to use it you can send picklists to the warehouse and ‎they can pick and print packing slips (including lot/serial details). Shipping is done by warehouse and invoice is just a confirmation / 1 click. Has been used now for multiple months in a multi-user environment. Even for credit/rebills accounting goes through pick/pack/ship process because they like it and the paperwork.
People used too existing process just continue to use it.


Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
From: Phil Daintree
Sent: Wednesday, January 21, 2015 10:26 PM
To: webERP Developers
Reply To: webERP Developers
Subject: Re: [WebERP-developers] New version


The feature that you think is good that we didn't include was the separation of picking and confirming/invoicing as I recall which added another layer into the workflow which couldn't be circumvented. If it could be circumvented to retain the existing workflow using a parameter then I'd be keen ... I just didn't want to add functionality that people who are used to webERP would be forced to use.


Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 08:20, Andrew Galuski wrote:
Hello Rafael,
Yes - I try to incorporate as ,much as I can into the main trunk.  Very rarely I see a specific business need that I keep to myself and 1 major change wasn’t quite accepted in the trunk ☹ even though I think it is a good feature.  So that one will be more work for me to incorporate

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com<http://www.resmart.com>
[resmart_logo]

From: Rafael Chacón [mailto:raf...@gm...]
Sent: Wednesday, January 21, 2015 1:01 PM
To: webERP Developers
Subject: Re: [WebERP-developers] New version

Hi Andrew,

Yes, I understand. For me, always a new version involves an effort to compare new version with customised versions.
At the beginning, as a newbie, I made the mistake of doing several customised versions. Now, I prefer to not do customized versions (the update is a headache). Instead, I prefer to include new features in the webERP main version if it make sense. I am trying to move those customisation to main code. Lucky, except forms, I eliminated the other customisations

For modifications done, is it possible to incorporate them as new features or options? Maybe we can join efforts in that way.
Best regards, Rafael.


2015-01-21 12:47 GMT-06:00 Rafael Chacón <raf...@gm...<mailto:raf...@gm...>>:
Hi,

IMHO, the arguments for a new version are:

1. As a Software Libre (free and open source software)

A new version is a way to share the changes made to the shared code. A new version fixes bugs and adds new features, and makes them available to everyone (not just developers and testers).
I suggest twice a year, as other Software Libre does (Ubuntu, LibreOffice, etc.). It could be in May and November of each year. In this way, we can schedule advertising and do intensive testing in April and October.

2. A specific new release after 4.11.5

+ The release is 4.11.5 came out between some modifications and its bug fixes. So if someone uses 4.11.5, he will have a version with bugs that are already fixed.
+ Since version 4.11.5 to today, there have been many changes. These charges are important.  E.g.: db-function, Z_UpdateItemCosts.php, CustomerBalancesMovement.php, new Quality Module, translation scripts, etc. Some of them involves databases changes.

I suggest a new version to not comprise an installation with bugs already fixed. It could be 4.11.5.b (with only the bug fixes added) or a new release 4.12.
Best regads, Rafael.


2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo...<mailto:ph...@lo...>>:

Re: [WebERP-developers] New version.eml
Subject:
Re: [WebERP-developers] New version

From:
Tim Schofield <tim...@gm...><mailto:tim...@gm...>

Date:
22/01/15 03:46


To:
webERP Developers <web...@li...><mailto:web...@li...>



Mostly just a warning. DB_query() is defined as function DB_query

($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,

$TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it

will assume the error message to be the value of $db so you will just

get a wrong type warning.



However if you did a call such as DB_query ($SQL, $db, 'Error

Message', 'Debug Message', false, true); you will get an error as

there are an incorrect number of parameters used.



Either way you should get rid of all $db except those in the

ConnectDB_*.inc files



Thanks

Tim



On 21 January 2015 at 14:03, Andrew Galuski <aga...@re...><mailto:aga...@re...> wrote:

IOn 22/01/15 03:03, Andrew Galuski wrote:

It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)

Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?



Best Regards,

Andrew Galuski





-----Original Message-----

From: Phil Daintree [mailto:ph...@lo...]

Sent: Tuesday, January 20, 2015 11:38 PM

To: webERP Developers

Subject: [WebERP-developers] New version



Rafael suggested we go for a new version recently.

We last released in October - I thought it was more recent than that.

There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?



--

Phil



Phil Daintree

Logic Works Ltd - +64 (0)275 567890

http://www.logicworks.co.nz





------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers



------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers




------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers





------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet



_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers





------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet



_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] New version

[Andrew G. <aga...@re...>]

Started this but never finished the setup! I think I need to revisit it.

Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
From: Pak Ricard
Sent: Thursday, January 22, 2015 3:26 AM
To: webERP Developers
Reply To: webERP Developers
Subject: Re: [WebERP-developers] New version


Hi all:

Specially for Andrew and those having a nightmare each time a new version is released:

I WAS having all this nightmare and cold sweat each time a new version was released until Tim pointed me to gitHub and now merging any release won't take me more than 1 hour. As user interface, I'm using SourceTree, extremelly simple.

Set up was:
Open an account in BitBucket (free and can keep private repositories)
use the SVN webERP release as the main branch of the project. Pick the webERP version you already merged (without any change, the "official" one).
Create a branch with your current code.
Then commit the newest release always to main and your changes to your branch.

Merging is then stupid-proof and works magically.

The hours you will spend setting it up is well worth it. Now I merge every few weeks, just to enjoy the last feautres and bug fixes without the pain. "No pain, big gain".

All credit goes to Tim, who helped me and guided during setup. Regrettably I can't find the email where he explained all the techy details.


Regards,
Ricard

2015-01-22 3:20 GMT+08:00 Andrew Galuski <aga...@re...<mailto:aga...@re...>>:
Hello Rafael,
Yes - I try to incorporate as ,much as I can into the main trunk.  Very rarely I see a specific business need that I keep to myself and 1 major change wasn’t quite accepted in the trunk :( even though I think it is a good feature.  So that one will be more work for me to incorporate

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038<tel:817.615.2038> (Office)
817.821.0544<tel:817.821.0544> (Cell)
www.resmart.com<http://www.resmart.com>
[resmart_logo]

From: Rafael Chacón [mailto:raf...@gm...<mailto:raf...@gm...>]
Sent: Wednesday, January 21, 2015 1:01 PM
To: webERP Developers
Subject: Re: [WebERP-developers] New version

Hi Andrew,

Yes, I understand. For me, always a new version involves an effort to compare new version with customised versions.
At the beginning, as a newbie, I made the mistake of doing several customised versions. Now, I prefer to not do customized versions (the update is a headache). Instead, I prefer to include new features in the webERP main version if it make sense. I am trying to move those customisation to main code. Lucky, except forms, I eliminated the other customisations

For modifications done, is it possible to incorporate them as new features or options? Maybe we can join efforts in that way.
Best regards, Rafael.


2015-01-21 12:47 GMT-06:00 Rafael Chacón <raf...@gm...<mailto:raf...@gm...>>:
Hi,

IMHO, the arguments for a new version are:

1. As a Software Libre (free and open source software)

A new version is a way to share the changes made to the shared code. A new version fixes bugs and adds new features, and makes them available to everyone (not just developers and testers).
I suggest twice a year, as other Software Libre does (Ubuntu, LibreOffice, etc.). It could be in May and November of each year. In this way, we can schedule advertising and do intensive testing in April and October.

2. A specific new release after 4.11.5

+ The release is 4.11.5 came out between some modifications and its bug fixes. So if someone uses 4.11.5, he will have a version with bugs that are already fixed.
+ Since version 4.11.5 to today, there have been many changes. These charges are important.  E.g.: db-function, Z_UpdateItemCosts.php, CustomerBalancesMovement.php, new Quality Module, translation scripts, etc. Some of them involves databases changes.

I suggest a new version to not comprise an installation with bugs already fixed. It could be 4.11.5.b (with only the bug fixes added) or a new release 4.12.
Best regads, Rafael.


2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo...<mailto:ph...@lo...>>:

Re: [WebERP-developers] New version.eml
Subject:
Re: [WebERP-developers] New version

From:
Tim Schofield <tim...@gm...><mailto:tim...@gm...>

Date:
22/01/15 03:46


To:
webERP Developers <web...@li...><mailto:web...@li...>



Mostly just a warning. DB_query() is defined as function DB_query

($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,

$TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it

will assume the error message to be the value of $db so you will just

get a wrong type warning.



However if you did a call such as DB_query ($SQL, $db, 'Error

Message', 'Debug Message', false, true); you will get an error as

there are an incorrect number of parameters used.



Either way you should get rid of all $db except those in the

ConnectDB_*.inc files



Thanks

Tim



On 21 January 2015 at 14:03, Andrew Galuski <aga...@re...><mailto:aga...@re...> wrote:

IOn 22/01/15 03:03, Andrew Galuski wrote:

It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)

Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?



Best Regards,

Andrew Galuski





-----Original Message-----

From: Phil Daintree [mailto:ph...@lo...]

Sent: Tuesday, January 20, 2015 11:38 PM

To: webERP Developers

Subject: [WebERP-developers] New version



Rafael suggested we go for a new version recently.

We last released in October - I thought it was more recent than that.

There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?



--

Phil



Phil Daintree

Logic Works Ltd - +64 (0)275 567890

http://www.logicworks.co.nz





------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers



------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers




------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] New version

[Pak R. <pak...@gm...>]

Hi all:

Specially for Andrew and those having a nightmare each time a new version
is released:

I WAS having all this nightmare and cold sweat each time a new version was
released until Tim pointed me to gitHub and now merging any release won't
take me more than 1 hour. As user interface, I'm using SourceTree,
extremelly simple.

Set up was:
Open an account in BitBucket (free and can keep private repositories)
use the SVN webERP release as the main branch of the project. Pick the
webERP version you already merged (without any change, the "official" one).
Create a branch with your current code.
Then commit the newest release always to main and your changes to your
branch.

Merging is then stupid-proof and works magically.

The hours you will spend setting it up is well worth it. Now I merge every
few weeks, just to enjoy the last feautres and bug fixes without the pain.
"No pain, big gain".

All credit goes to Tim, who helped me and guided during setup. Regrettably
I can't find the email where he explained all the techy details.


Regards,
Ricard

2015-01-22 3:20 GMT+08:00 Andrew Galuski <aga...@re...>:

>  Hello Rafael,
>
> Yes - I try to incorporate as ,much as I can into the main trunk.  Very
> rarely I see a specific business need that I keep to myself and 1 major
> change wasn’t quite accepted in the trunk L even though I think it is a
> good feature.  So that one will be more work for me to incorporate
>
>
>
> Best Regards,
>
> Andrew Galuski
>
> ResMart LLC.
>
> 817.615.2038 (Office)
>
> 817.821.0544 (Cell)
>
> www.resmart.com
>
> [image: resmart_logo]
>
>
>
> *From:* Rafael Chacón [mailto:raf...@gm...]
> *Sent:* Wednesday, January 21, 2015 1:01 PM
> *To:* webERP Developers
> *Subject:* Re: [WebERP-developers] New version
>
>
>
> Hi Andrew,
>
> Yes, I understand. For me, always a new version involves an effort to
> compare new version with customised versions.
> At the beginning, as a newbie, I made the mistake of doing several
> customised versions. Now, I prefer to not do customized versions (the
> update is a headache). Instead, I prefer to include new features in the
> webERP main version if it make sense. I am trying to move those
> customisation to main code. Lucky, except forms, I eliminated the other
> customisations
>
> For modifications done, is it possible to incorporate them as new features
> or options? Maybe we can join efforts in that way.
>
> Best regards, Rafael.
>
>
>
>
>
> 2015-01-21 12:47 GMT-06:00 Rafael Chacón <raf...@gm...>:
>
> Hi,
>
> IMHO, the arguments for a new version are:
>
> 1. As a Software Libre (free and open source software)
>
> A new version is a way to share the changes made to the shared code. A new
> version fixes bugs and adds new features, and makes them available to
> everyone (not just developers and testers).
> I suggest twice a year, as other Software Libre does (Ubuntu, LibreOffice,
> etc.). It could be in May and November of each year. In this way, we can
> schedule advertising and do intensive testing in April and October.
>
> 2. A specific new release after 4.11.5
>
> + The release is 4.11.5 came out between some modifications and its bug
> fixes. So if someone uses 4.11.5, he will have a version with bugs that are
> already fixed.
> + Since version 4.11.5 to today, there have been many changes. These
> charges are important.  E.g.: db-function, Z_UpdateItemCosts.php,
> CustomerBalancesMovement.php, new Quality Module, translation scripts, etc.
> Some of them involves databases changes.
>
> I suggest a new version to not comprise an installation with bugs already
> fixed. It could be 4.11.5.b (with only the bug fixes added) or a new
> release 4.12.
>
> Best regads, Rafael.
>
>
>
>
>
> 2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo...>:
>
>
>
> Re: [WebERP-developers] New version.eml
>
> Subject:
>
> Re: [WebERP-developers] New version
>
> From:
>
> Tim Schofield <tim...@gm...> <tim...@gm...>
>
> Date:
>
> 22/01/15 03:46
>
>
>
> To:
>
> webERP Developers <web...@li...>
> <web...@li...>
>
>
>
> Mostly just a warning. DB_query() is defined as function DB_query
>
> ($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,
>
> $TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it
>
> will assume the error message to be the value of $db so you will just
>
> get a wrong type warning.
>
>
>
> However if you did a call such as DB_query ($SQL, $db, 'Error
>
> Message', 'Debug Message', false, true); you will get an error as
>
> there are an incorrect number of parameters used.
>
>
>
> Either way you should get rid of all $db except those in the
>
> ConnectDB_*.inc files
>
>
>
> Thanks
>
> Tim
>
>
>
> On 21 January 2015 at 14:03, Andrew Galuski <aga...@re...> <aga...@re...> wrote:
>
>  IOn 22/01/15 03:03, Andrew Galuski wrote:
>
>    It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)
>
> Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?
>
>
>
> Best Regards,
>
> Andrew Galuski
>
>
>
>
>
> -----Original Message-----
>
> From: Phil Daintree [mailto:ph...@lo... <ph...@lo...>]
>
> Sent: Tuesday, January 20, 2015 11:38 PM
>
> To: webERP Developers
>
> Subject: [WebERP-developers] New version
>
>
>
> Rafael suggested we go for a new version recently.
>
> We last released in October - I thought it was more recent than that.
>
> There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?
>
>
>
> --
>
> Phil
>
>
>
> Phil Daintree
>
> Logic Works Ltd - +64 (0)275 567890
>
> http://www.logicworks.co.nz
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>
> GigeNET is offering a free month of service with a new server in Ashburn.
>
> Choose from 2 high performing configs, both with 100TB of bandwidth.
>
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>
> http://p.sf.net/sfu/gigenet
>
> _______________________________________________
>
> Web-erp-developers mailing list
>
> Web...@li...
>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
>
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>
> GigeNET is offering a free month of service with a new server in Ashburn.
>
> Choose from 2 high performing configs, both with 100TB of bandwidth.
>
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>
> http://p.sf.net/sfu/gigenet
>
> _______________________________________________
>
> Web-erp-developers mailing list
>
> Web...@li...
>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] New version

[Phil D. <ph...@lo...>]

Well on that basis, if it is easy to bring it in - would be great!

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 17:50, Andrew Galuski wrote:
> No need for a parameter and the code added didn't require using the 
> new functionality. Anybody with security to invoice can skip picking 
> and shipping and invoice directly. If picking already done somebody 
> with permissions to invoice can skip 'shipping' step as well. However 
> if you wish to use it you can send picklists to the warehouse and 
> ‎they can pick and print packing slips (including lot/serial details). 
> Shipping is done by warehouse and invoice is just a confirmation / 1 
> click. Has been used now for multiple months in a multi-user 
> environment. Even for credit/rebills accounting goes through 
> pick/pack/ship process because they like it and the paperwork.
> People used too existing process just continue to use it.
>
>
> Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE 
> network.
> *From: *Phil Daintree
> *Sent: *Wednesday, January 21, 2015 10:26 PM
> *To: *webERP Developers
> *Reply To: *webERP Developers
> *Subject: *Re: [WebERP-developers] New version
>
>
> The feature that you think is good that we didn't include was the 
> separation of picking and confirming/invoicing as I recall which added 
> another layer into the workflow which couldn't be circumvented. If it 
> could be circumvented to retain the existing workflow using a 
> parameter then I'd be keen ... I just didn't want to add functionality 
> that people who are used to webERP would be forced to use.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
> On 22/01/15 08:20, Andrew Galuski wrote:
>>
>> Hello Rafael,
>>
>> Yes - I try to incorporate as ,much as I can into the main trunk.  
>> Very rarely I see a specific business need that I keep to myself and 
>> 1 major change wasn’t quite accepted in the trunk Leven though I 
>> think it is a good feature.  So that one will be more work for me to 
>> incorporate
>>
>> Best Regards,
>>
>> Andrew Galuski
>>
>> ResMart LLC.
>>
>> 817.615.2038 (Office)
>>
>> 817.821.0544 (Cell)
>>
>> www.resmart.com <http://www.resmart.com>
>>
>> resmart_logo
>>
>> *From:*Rafael Chacón [mailto:raf...@gm...]
>> *Sent:* Wednesday, January 21, 2015 1:01 PM
>> *To:* webERP Developers
>> *Subject:* Re: [WebERP-developers] New version
>>
>> Hi Andrew,
>>
>> Yes, I understand. For me, always a new version involves an effort to 
>> compare new version with customised versions.
>> At the beginning, as a newbie, I made the mistake of doing several 
>> customised versions. Now, I prefer to not do customized versions (the 
>> update is a headache). Instead, I prefer to include new features in 
>> the webERP main version if it make sense. I am trying to move those 
>> customisation to main code. Lucky, except forms, I eliminated the 
>> other customisations
>>
>> For modifications done, is it possible to incorporate them as new 
>> features or options? Maybe we can join efforts in that way.
>>
>> Best regards, Rafael.
>>
>> 2015-01-21 12:47 GMT-06:00 Rafael Chacón 
>> <raf...@gm... <mailto:raf...@gm...>>:
>>
>> Hi,
>>
>> IMHO, the arguments for a new version are:
>>
>> 1. As a Software Libre (free and open source software)
>>
>> A new version is a way to share the changes made to the shared code. 
>> A new version fixes bugs and adds new features, and makes them 
>> available to everyone (not just developers and testers).
>> I suggest twice a year, as other Software Libre does (Ubuntu, 
>> LibreOffice, etc.). It could be in May and November of each year. In 
>> this way, we can schedule advertising and do intensive testing in 
>> April and October.
>>
>> 2. A specific new release after 4.11.5
>>
>> + The release is 4.11.5 came out between some modifications and its 
>> bug fixes. So if someone uses 4.11.5, he will have a version with 
>> bugs that are already fixed.
>> + Since version 4.11.5 to today, there have been many changes. These 
>> charges are important.  E.g.: db-function, Z_UpdateItemCosts.php, 
>> CustomerBalancesMovement.php, new Quality Module, translation 
>> scripts, etc. Some of them involves databases changes.
>>
>> I suggest a new version to not comprise an installation with bugs 
>> already fixed. It could be 4.11.5.b (with only the bug fixes added) 
>> or a new release 4.12.
>>
>> Best regads, Rafael.
>>
>> 2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo... 
>> <mailto:ph...@lo...>>:
>>
>>     Re: [WebERP-developers] New version.eml
>>
>>     Subject:
>>
>>     Re: [WebERP-developers] New version
>>
>>     From:
>>
>>     Tim Schofield <tim...@gm...>
>>     <mailto:tim...@gm...>
>>
>>     Date:
>>
>>     22/01/15 03:46
>>
>>     To:
>>
>>     webERP Developers <web...@li...>
>>     <mailto:web...@li...>
>>
>>     Mostly just a warning. DB_query() is defined as function DB_query
>>
>>     ($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,
>>
>>     $TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it
>>
>>     will assume the error message to be the value of $db so you will just
>>
>>     get a wrong type warning.
>>
>>       
>>
>>     However if you did a call such as DB_query ($SQL, $db, 'Error
>>
>>     Message', 'Debug Message', false, true); you will get an error as
>>
>>     there are an incorrect number of parameters used.
>>
>>       
>>
>>     Either way you should get rid of all $db except those in the
>>
>>     ConnectDB_*.inc files
>>
>>       
>>
>>     Thanks
>>
>>     Tim
>>
>>       
>>
>>     On 21 January 2015 at 14:03, Andrew Galuski<aga...@re...>  <mailto:aga...@re...>  wrote:
>>
>>     IOn 22/01/15 03:03, Andrew Galuski wrote:
>>
>>         It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)
>>
>>         Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?
>>
>>           
>>
>>         Best Regards,
>>
>>         Andrew Galuski
>>
>>           
>>
>>           
>>
>>         -----Original Message-----
>>
>>         From: Phil Daintree [mailto:ph...@lo...]
>>
>>         Sent: Tuesday, January 20, 2015 11:38 PM
>>
>>         To: webERP Developers
>>
>>         Subject: [WebERP-developers] New version
>>
>>           
>>
>>         Rafael suggested we go for a new version recently.
>>
>>         We last released in October - I thought it was more recent than that.
>>
>>         There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?
>>
>>           
>>
>>         --
>>
>>         Phil
>>
>>           
>>
>>         Phil Daintree
>>
>>         Logic Works Ltd - +64 (0)275 567890
>>
>>         http://www.logicworks.co.nz
>>
>>           
>>
>>           
>>
>>         ------------------------------------------------------------------------------
>>
>>         New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>>
>>         GigeNET is offering a free month of service with a new server in Ashburn.
>>
>>         Choose from 2 high performing configs, both with 100TB of bandwidth.
>>
>>         Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>>
>>         http://p.sf.net/sfu/gigenet
>>
>>         _______________________________________________
>>
>>         Web-erp-developers mailing list
>>
>>         Web...@li...  <mailto:Web...@li...>
>>
>>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>           
>>
>>         ------------------------------------------------------------------------------
>>
>>         New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>>
>>         GigeNET is offering a free month of service with a new server in Ashburn.
>>
>>         Choose from 2 high performing configs, both with 100TB of bandwidth.
>>
>>         Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>>
>>         http://p.sf.net/sfu/gigenet
>>
>>         _______________________________________________
>>
>>         Web-erp-developers mailing list
>>
>>         Web...@li...  <mailto:Web...@li...>
>>
>>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>           
>>
>>
>>     ------------------------------------------------------------------------------
>>     New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>>     GigeNET is offering a free month of service with a new server in
>>     Ashburn.
>>     Choose from 2 high performing configs, both with 100TB of bandwidth.
>>     Higher redundancy.Lower latency.Increased capacity.Completely
>>     compliant.
>>     http://p.sf.net/sfu/gigenet
>>     _______________________________________________
>>     Web-erp-developers mailing list
>>     Web...@li...
>>     <mailto:Web...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>> ------------------------------------------------------------------------------
>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>> GigeNET is offering a free month of service with a new server in Ashburn.
>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>> http://p.sf.net/sfu/gigenet
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] New version

[Andrew G. <aga...@re...>]

No need for a parameter and the code added didn't require using the new functionality. Anybody with security to invoice can skip picking and shipping and invoice directly. If picking already done somebody with permissions to invoice can skip 'shipping' step as well. However if you wish to use it you can send picklists to the warehouse and ‎they can pick and print packing slips (including lot/serial details). Shipping is done by warehouse and invoice is just a confirmation / 1 click. Has been used now for multiple months in a multi-user environment. Even for credit/rebills accounting goes through pick/pack/ship process because they like it and the paperwork.
People used too existing process just continue to use it.


Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
From: Phil Daintree
Sent: Wednesday, January 21, 2015 10:26 PM
To: webERP Developers
Reply To: webERP Developers
Subject: Re: [WebERP-developers] New version


The feature that you think is good that we didn't include was the separation of picking and confirming/invoicing as I recall which added another layer into the workflow which couldn't be circumvented. If it could be circumvented to retain the existing workflow using a parameter then I'd be keen ... I just didn't want to add functionality that people who are used to webERP would be forced to use.


Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 08:20, Andrew Galuski wrote:
Hello Rafael,
Yes - I try to incorporate as ,much as I can into the main trunk.  Very rarely I see a specific business need that I keep to myself and 1 major change wasn’t quite accepted in the trunk ☹ even though I think it is a good feature.  So that one will be more work for me to incorporate

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com<http://www.resmart.com>
[resmart_logo]

From: Rafael Chacón [mailto:raf...@gm...]
Sent: Wednesday, January 21, 2015 1:01 PM
To: webERP Developers
Subject: Re: [WebERP-developers] New version

Hi Andrew,

Yes, I understand. For me, always a new version involves an effort to compare new version with customised versions.
At the beginning, as a newbie, I made the mistake of doing several customised versions. Now, I prefer to not do customized versions (the update is a headache). Instead, I prefer to include new features in the webERP main version if it make sense. I am trying to move those customisation to main code. Lucky, except forms, I eliminated the other customisations

For modifications done, is it possible to incorporate them as new features or options? Maybe we can join efforts in that way.
Best regards, Rafael.


2015-01-21 12:47 GMT-06:00 Rafael Chacón <raf...@gm...<mailto:raf...@gm...>>:
Hi,

IMHO, the arguments for a new version are:

1. As a Software Libre (free and open source software)

A new version is a way to share the changes made to the shared code. A new version fixes bugs and adds new features, and makes them available to everyone (not just developers and testers).
I suggest twice a year, as other Software Libre does (Ubuntu, LibreOffice, etc.). It could be in May and November of each year. In this way, we can schedule advertising and do intensive testing in April and October.

2. A specific new release after 4.11.5

+ The release is 4.11.5 came out between some modifications and its bug fixes. So if someone uses 4.11.5, he will have a version with bugs that are already fixed.
+ Since version 4.11.5 to today, there have been many changes. These charges are important.  E.g.: db-function, Z_UpdateItemCosts.php, CustomerBalancesMovement.php, new Quality Module, translation scripts, etc. Some of them involves databases changes.

I suggest a new version to not comprise an installation with bugs already fixed. It could be 4.11.5.b (with only the bug fixes added) or a new release 4.12.
Best regads, Rafael.


2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo...<mailto:ph...@lo...>>:

Re: [WebERP-developers] New version.eml
Subject:
Re: [WebERP-developers] New version

From:
Tim Schofield <tim...@gm...><mailto:tim...@gm...>

Date:
22/01/15 03:46


To:
webERP Developers <web...@li...><mailto:web...@li...>



Mostly just a warning. DB_query() is defined as function DB_query

($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,

$TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it

will assume the error message to be the value of $db so you will just

get a wrong type warning.



However if you did a call such as DB_query ($SQL, $db, 'Error

Message', 'Debug Message', false, true); you will get an error as

there are an incorrect number of parameters used.



Either way you should get rid of all $db except those in the

ConnectDB_*.inc files



Thanks

Tim



On 21 January 2015 at 14:03, Andrew Galuski <aga...@re...><mailto:aga...@re...> wrote:

IOn 22/01/15 03:03, Andrew Galuski wrote:

It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)

Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?



Best Regards,

Andrew Galuski





-----Original Message-----

From: Phil Daintree [mailto:ph...@lo...]

Sent: Tuesday, January 20, 2015 11:38 PM

To: webERP Developers

Subject: [WebERP-developers] New version



Rafael suggested we go for a new version recently.

We last released in October - I thought it was more recent than that.

There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?



--

Phil



Phil Daintree

Logic Works Ltd - +64 (0)275 567890

http://www.logicworks.co.nz





------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers



------------------------------------------------------------------------------

New Year. New Location. New Benefits. New Data Center in Ashburn, VA.

GigeNET is offering a free month of service with a new server in Ashburn.

Choose from 2 high performing configs, both with 100TB of bandwidth.

Higher redundancy.Lower latency.Increased capacity.Completely compliant.

http://p.sf.net/sfu/gigenet

_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

https://lists.sourceforge.net/lists/listinfo/web-erp-developers




------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers





------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet



_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] BOM effective dates mismatch

[Phil D. <ph...@lo...>]

All scripts should be checking the effectivity dates.

effectiveafter <= '" . date('Y-m-d') . "' AND effectiveto > '" .  
date('Y-m-d') . "'

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 07:48, Vitaly Shevkunov wrote:
> te('Y-m-dHello all,
>
> I just noticed, that there is a discrepancy in how different scrips
> access the BOM table. Some of them do this
>
>               AND bom.effectiveafter < '" . Date('Y-m-d') . "'
>               AND (bom.effectiveto > '" . Date('Y-m-d') . "'
>                OR bom.effectiveto='0000-00-00')";
>
> Others have
> AND bom.effectiveto >= '" . date('Y-m-d') . "'
>                 AND bom.effectiveafter <= '" . date('Y-m-d') . "'";
>
> And yet others do not check effective dates at all.
>
> I would like to fix this, but I am not sure if I am supposed to use '>'
> or '>='.
>
> Thanks,
>
> Vitaly
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] New version

[Andrew G. <aga...@re...>]

Thanks.

Sent from my BlackBerry 10 smartphone on the Verizon Wireless 4G LTE network.
  Original Message
From: Phil Daintree
Sent: Wednesday, January 21, 2015 10:39 PM
To: webERP Developers
Reply To: webERP Developers
Subject: Re: [WebERP-developers] New version


I used this to do the whole lot in one go, I figured it would be too
risky to do it manually as I would have missed some for sure. May help
you blast the remaining ones in your modified code.

 >find /usr/share/nginx/html/webERP/ -type f -name "*.php" -name "*.inc"
-exec sed -i -e '/.*[dD][bB]_[Qq]uery.*,.*/s/$db//g' {} \;

where

/usr/share/nginx/html/webERP/

is the path to my working copy.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 03:03, Andrew Galuski wrote:
> It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)
> Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?
>
> Best Regards,
> Andrew Galuski
>
>
> -----Original Message-----
> From: Phil Daintree [mailto:ph...@lo...]
> Sent: Tuesday, January 20, 2015 11:38 PM
> To: webERP Developers
> Subject: [WebERP-developers] New version
>
> Rafael suggested we go for a new version recently.
> We last released in October - I thought it was more recent than that.
> There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?
>
> --
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] New version

[Phil D. <ph...@lo...>]

I used this to do the whole lot in one go, I figured it would be too 
risky to do it manually as I would have missed some for sure. May help 
you blast the remaining ones in your modified code.

 >find /usr/share/nginx/html/webERP/ -type f -name "*.php" -name "*.inc" 
-exec sed -i -e '/.*[dD][bB]_[Qq]uery.*,.*/s/$db//g' {} \;

where

/usr/share/nginx/html/webERP/

is the path to my working copy.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 03:03, Andrew Galuski wrote:
> It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)
> Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?
>
> Best Regards,
> Andrew Galuski
>
>
> -----Original Message-----
> From: Phil Daintree [mailto:ph...@lo...]
> Sent: Tuesday, January 20, 2015 11:38 PM
> To: webERP Developers
> Subject: [WebERP-developers] New version
>
> Rafael suggested we go for a new version recently.
> We last released in October - I thought it was more recent than that.
> There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?
>
> --
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] New version

[Phil D. <ph...@lo...>]

The feature that you think is good that we didn't include was the 
separation of picking and confirming/invoicing as I recall which added 
another layer into the workflow which couldn't be circumvented. If it 
could be circumvented to retain the existing workflow using a parameter 
then I'd be keen ... I just didn't want to add functionality that people 
who are used to webERP would be forced to use.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 08:20, Andrew Galuski wrote:
>
> Hello Rafael,
>
> Yes - I try to incorporate as ,much as I can into the main trunk.  
> Very rarely I see a specific business need that I keep to myself and 1 
> major change wasn’t quite accepted in the trunk Leven though I think 
> it is a good feature.  So that one will be more work for me to incorporate
>
> Best Regards,
>
> Andrew Galuski
>
> ResMart LLC.
>
> 817.615.2038 (Office)
>
> 817.821.0544 (Cell)
>
> www.resmart.com <http://www.resmart.com>
>
> resmart_logo
>
> *From:*Rafael Chacón [mailto:raf...@gm...]
> *Sent:* Wednesday, January 21, 2015 1:01 PM
> *To:* webERP Developers
> *Subject:* Re: [WebERP-developers] New version
>
> Hi Andrew,
>
> Yes, I understand. For me, always a new version involves an effort to 
> compare new version with customised versions.
> At the beginning, as a newbie, I made the mistake of doing several 
> customised versions. Now, I prefer to not do customized versions (the 
> update is a headache). Instead, I prefer to include new features in 
> the webERP main version if it make sense. I am trying to move those 
> customisation to main code. Lucky, except forms, I eliminated the 
> other customisations
>
> For modifications done, is it possible to incorporate them as new 
> features or options? Maybe we can join efforts in that way.
>
> Best regards, Rafael.
>
> 2015-01-21 12:47 GMT-06:00 Rafael Chacón 
> <raf...@gm... <mailto:raf...@gm...>>:
>
> Hi,
>
> IMHO, the arguments for a new version are:
>
> 1. As a Software Libre (free and open source software)
>
> A new version is a way to share the changes made to the shared code. A 
> new version fixes bugs and adds new features, and makes them available 
> to everyone (not just developers and testers).
> I suggest twice a year, as other Software Libre does (Ubuntu, 
> LibreOffice, etc.). It could be in May and November of each year. In 
> this way, we can schedule advertising and do intensive testing in 
> April and October.
>
> 2. A specific new release after 4.11.5
>
> + The release is 4.11.5 came out between some modifications and its 
> bug fixes. So if someone uses 4.11.5, he will have a version with bugs 
> that are already fixed.
> + Since version 4.11.5 to today, there have been many changes. These 
> charges are important.  E.g.: db-function, Z_UpdateItemCosts.php, 
> CustomerBalancesMovement.php, new Quality Module, translation scripts, 
> etc. Some of them involves databases changes.
>
> I suggest a new version to not comprise an installation with bugs 
> already fixed. It could be 4.11.5.b (with only the bug fixes added) or 
> a new release 4.12.
>
> Best regads, Rafael.
>
> 2015-01-21 12:06 GMT-06:00 Phil Daintree <ph...@lo... 
> <mailto:ph...@lo...>>:
>
>     Re: [WebERP-developers] New version.eml
>
>     Subject:
>
>     Re: [WebERP-developers] New version
>
>     From:
>
>     Tim Schofield <tim...@gm...>
>     <mailto:tim...@gm...>
>
>     Date:
>
>     22/01/15 03:46
>
>     To:
>
>     webERP Developers <web...@li...>
>     <mailto:web...@li...>
>
>     Mostly just a warning. DB_query() is defined as function DB_query
>
>     ($SQL, $ErrorMessage='', $DebugMessage= '', $Transaction=false,
>
>     $TrapErrors=true) so if you did a call such as DB_query($SQL, $db) it
>
>     will assume the error message to be the value of $db so you will just
>
>     get a wrong type warning.
>
>       
>
>     However if you did a call such as DB_query ($SQL, $db, 'Error
>
>     Message', 'Debug Message', false, true); you will get an error as
>
>     there are an incorrect number of parameters used.
>
>       
>
>     Either way you should get rid of all $db except those in the
>
>     ConnectDB_*.inc files
>
>       
>
>     Thanks
>
>     Tim
>
>       
>
>     On 21 January 2015 at 14:03, Andrew Galuski<aga...@re...>  <mailto:aga...@re...>  wrote:
>
>     IOn 22/01/15 03:03, Andrew Galuski wrote:
>
>         It will be a large effort on my part (Especially identifying all my modifications I have that may not be in the main trunk (Like the picking, packing, shipping functionality that is separate from Invoicing)
>
>         Quick question, If I still call DB_Query() in code with the $db parameter and the include file doesn't expect it will I get a hard error or a warning?
>
>           
>
>         Best Regards,
>
>         Andrew Galuski
>
>           
>
>           
>
>         -----Original Message-----
>
>         From: Phil Daintree [mailto:ph...@lo...]
>
>         Sent: Tuesday, January 20, 2015 11:38 PM
>
>         To: webERP Developers
>
>         Subject: [WebERP-developers] New version
>
>           
>
>         Rafael suggested we go for a new version recently.
>
>         We last released in October - I thought it was more recent than that.
>
>         There are a few bug fixes in there and a whole load of work I did to change the DB_query() calls to exclude the global $db in them. Would be interested to know what others think about another release now?
>
>           
>
>         --
>
>         Phil
>
>           
>
>         Phil Daintree
>
>         Logic Works Ltd - +64 (0)275 567890
>
>         http://www.logicworks.co.nz
>
>           
>
>           
>
>         ------------------------------------------------------------------------------
>
>         New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>
>         GigeNET is offering a free month of service with a new server in Ashburn.
>
>         Choose from 2 high performing configs, both with 100TB of bandwidth.
>
>         Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>
>         http://p.sf.net/sfu/gigenet
>
>         _______________________________________________
>
>         Web-erp-developers mailing list
>
>         Web...@li...  <mailto:Web...@li...>
>
>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>           
>
>         ------------------------------------------------------------------------------
>
>         New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>
>         GigeNET is offering a free month of service with a new server in Ashburn.
>
>         Choose from 2 high performing configs, both with 100TB of bandwidth.
>
>         Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>
>         http://p.sf.net/sfu/gigenet
>
>         _______________________________________________
>
>         Web-erp-developers mailing list
>
>         Web...@li...  <mailto:Web...@li...>
>
>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>           
>
>
>     ------------------------------------------------------------------------------
>     New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>     GigeNET is offering a free month of service with a new server in
>     Ashburn.
>     Choose from 2 high performing configs, both with 100TB of bandwidth.
>     Higher redundancy.Lower latency.Increased capacity.Completely
>     compliant.
>     http://p.sf.net/sfu/gigenet
>     _______________________________________________
>     Web-erp-developers mailing list
>     Web...@li...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] BOM effective dates mismatch

[Vitaly S. <vsh...@so...>]

This is the current trunk revision 7091.
Some of the files are BOMExtendedQty.php, BOMIndented.php, 
BOMInquiry.php, SQL_CommonFunctions.inc and some other.

Vitaly


On 1/21/2015 1:51 PM, Andrew Galuski wrote:
>
> Also which version of the code?
>
> Best Regards,
>
> Andrew Galuski
>
> ResMart LLC.
>
> 817.615.2038 (Office)
>
> 817.821.0544 (Cell)
>
> www.resmart.com <http://www.resmart.com>
>
> resmart_logo
>
> *From:*gilberto dos santos alves [mailto:gs...@gm...]
> *Sent:* Wednesday, January 21, 2015 1:50 PM
> *To:* webERP Developers
> *Subject:* Re: [WebERP-developers] BOM effective dates mismatch
>
> Hi. Please could you describe (if possible) what scripts you are 
> talking (tools like diff or others similar). Thanks for your time.
>
> 2015-01-21 16:48 GMT-02:00 Vitaly Shevkunov <vsh...@so... 
> <mailto:vsh...@so...>>:
>
> Hello all,
>
> I just noticed, that there is a discrepancy in how different scrips
> access the BOM table. Some of them do this
>
>              AND bom.effectiveafter < '" . Date('Y-m-d') . "'
>              AND (bom.effectiveto > '" . Date('Y-m-d') . "'
>               OR bom.effectiveto='0000-00-00')";
>
> Others have
> AND bom.effectiveto >= '" . date('Y-m-d') . "'
>                AND bom.effectiveafter <= '" . date('Y-m-d') . "'";
>
> And yet others do not check effective dates at all.
>
> I would like to fix this, but I am not sure if I am supposed to use '>'
> or '>='.
>
> Thanks,
>
> Vitaly
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li... 
> <mailto:Web...@li...>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> -- 
>
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2015.0.5645 / Virus Database: 4260/8972 - Release Date: 01/21/15
>

Re: [WebERP-developers] BOM effective dates mismatch

[Andrew G. <aga...@re...>]

Also which version of the code?

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com<http://www.resmart.com>
[resmart_logo]

From: gilberto dos santos alves [mailto:gs...@gm...]
Sent: Wednesday, January 21, 2015 1:50 PM
To: webERP Developers
Subject: Re: [WebERP-developers] BOM effective dates mismatch

Hi. Please could you describe (if possible) what scripts you are talking (tools like diff or others similar). Thanks for your time.

2015-01-21 16:48 GMT-02:00 Vitaly Shevkunov <vsh...@so...<mailto:vsh...@so...>>:
Hello all,

I just noticed, that there is a discrepancy in how different scrips
access the BOM table. Some of them do this

             AND bom.effectiveafter < '" . Date('Y-m-d') . "'
             AND (bom.effectiveto > '" . Date('Y-m-d') . "'
              OR bom.effectiveto='0000-00-00')";

Others have
AND bom.effectiveto >= '" . date('Y-m-d') . "'
               AND bom.effectiveafter <= '" . date('Y-m-d') . "'";

And yet others do not check effective dates at all.

I would like to fix this, but I am not sure if I am supposed to use '>'
or '>='.

Thanks,

Vitaly


------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Web-erp-developers mailing list
Web...@li...<mailto:Web...@li...>
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



--
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil