web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Should we use dot instead of comma as concatenation operator?

[gilberto d. s. a. <gs...@gm...>]

+1 from me. you get the point.

2016-07-25 12:49 GMT-03:00 Rafael Chacón <raf...@gm...>:

> Hi,
>
> In PHP, developers had decided to do PHP friendly to people who come from
> different language backgrounds (C++, Pearl, Python, etc.). This is the
> reason that we have many ways to do the same thing. E.g. redundant
> functions like die() and exit(). See:
> http://stackoverflow.com/questions/1795025/what-are-the-differences-in-die-and-exit-in-php,
> http://www.beastwithin.org/users/wwwwolf/code/phprant.html.
>
> In the case of comma and dot inside a echo, there is a difference more
> than execution time:
>
> The use of dot is like to:
> // Create a concatenated variable:
> $to_output = $a + $b + ... +$z;
> // Then, output that variable:
> echo $to_output;
>
> The use of comma is like to:
> // Output a list of variables:
> echo($a, $b, ..., $z);
>
> See: http://php.net/manual/en/function.echo.php
>
> To create that concatenated variable before output is the reason that
> "echo $a . $b . ... . $z;" outlast "echo $a, $b, ..., $z;" in execution
> time. In other programming languages, concatenate variables has others
> implications: all variables must be the same type. In PHP, in general, we
> do not have such problem (mixture of variables types); some exceptions: &,
> {}, [], non ISO-8859-1, non UTF-8_lower_part. Except in "class.pdf.php"
> script, I do not expect more issues with mixture of variables types.
>
> About use: I use and I recommend to use a list of variables instead of
> concatenate them before output. I found it "more clear" for beginner
> programmers.
>
> About changes: we can do them in on step, but i prefer to do one-by-one
> and test script; tracking bugs between minor changes (not related with bug)
> is very difficult.
>
> Keeping customised versions: I can not too much help. I use LibreOffice to
> compare changes before merge them.
>
> Best regards, Rafael.
>
>
>
> 2016-07-21 7:19 GMT-06:00 gilberto dos santos alves <gs...@gm...>:
>
>> Hi. IMO there are historical reason and meaning to use dot for concat.
>> Many languages ISO conform use comma for decimal point for numbers. By the
>> way file t format csv use other char for represent field delimit.
>> See locale var environment for better understant why comma use is not a
>> standard nor good idea.
>> Regards .
>> Em 21/07/2016 05:56, "Phil Daintree" <ph...@lo...> escreveu:
>>
>> Yes ... However, I really don't think the gains are significant - at
>> least not enough  to make such massive changes worthwhile.
>>
>> To explain my thinking more fully, as you know, I prefer that if the
>> change is to be made then all the scripts should be coded in the same
>> consistent way throughout, so far as humanly possible. So this would
>> require that the change must be made everywhere not just in some scripts
>> with other scripts then becoming inconsistent with those changed scripts.
>> Such a fundamental change to the code is so pervasive that every script
>> would need to be modified and the risk of errors creeping in with such a
>> huge amount of editing is too great to warrant consideration of this
>> change.
>>
>> So, I prefer not to change this please.
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890
>> http://www.logicworks.co.nz
>>
>> On 21/07/16 19:54, ExsonQu wrote:
>> > *Dear all,*
>> >
>> >                   Thank you for your contribution to webERP!
>> >
>> >                   I've found that comma is used instead of dot to
>> concatenate
>> > strings.  The googled result shows that comma is a little fast than
>> dot. But
>> > I think the comma change will make a impression that lots changes
>> happened.
>> > It'll be a heavy load for those users to maintain a customization file.
>> >
>> >                   Should we not use the comma except where comma has to
>> be
>> > used?
>> >
>> >                   Thanks and best regards!
>> >
>> >                   Exson
>> >
>> >
>> >
>> > --
>> > View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/Should-we-use-dot-instead-of-comma-as-concatenation-operator-tp4658639.html
>> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
>> >
>> >
>> ------------------------------------------------------------------------------
>> > What NetFlow Analyzer can do for you? Monitors network bandwidth and
>> traffic
>> > patterns at an interface-level. Reveals which users, apps, and
>> protocols are
>> > consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> > J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning
>> > reports.http://sdm.link/zohodev2dev
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> >
>>
>>
>>
>> ------------------------------------------------------------------------------
>> What NetFlow Analyzer can do for you? Monitors network bandwidth and
>> traffic
>> patterns at an interface-level. Reveals which users, apps, and protocols
>> are
>> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning
>> reports.http://sdm.link/zohodev2dev
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>> ------------------------------------------------------------------------------
>> What NetFlow Analyzer can do for you? Monitors network bandwidth and
>> traffic
>> patterns at an interface-level. Reveals which users, apps, and protocols
>> are
>> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning
>> reports.http://sdm.link/zohodev2dev
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


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

Re: [WebERP-developers] Should we use dot instead of comma as concatenation operator?

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

Hi,

In PHP, developers had decided to do PHP friendly to people who come from
different language backgrounds (C++, Pearl, Python, etc.). This is the
reason that we have many ways to do the same thing. E.g. redundant
functions like die() and exit(). See:
http://stackoverflow.com/questions/1795025/what-are-the-differences-in-die-and-exit-in-php,
http://www.beastwithin.org/users/wwwwolf/code/phprant.html.

In the case of comma and dot inside a echo, there is a difference more than
execution time:

The use of dot is like to:
// Create a concatenated variable:
$to_output = $a + $b + ... +$z;
// Then, output that variable:
echo $to_output;

The use of comma is like to:
// Output a list of variables:
echo($a, $b, ..., $z);

See: http://php.net/manual/en/function.echo.php

To create that concatenated variable before output is the reason that "echo
$a . $b . ... . $z;" outlast "echo $a, $b, ..., $z;" in execution time. In
other programming languages, concatenate variables has others implications:
all variables must be the same type. In PHP, in general, we do not have
such problem (mixture of variables types); some exceptions: &, {}, [], non
ISO-8859-1, non UTF-8_lower_part. Except in "class.pdf.php" script, I do
not expect more issues with mixture of variables types.

About use: I use and I recommend to use a list of variables instead of
concatenate them before output. I found it "more clear" for beginner
programmers.

About changes: we can do them in on step, but i prefer to do one-by-one and
test script; tracking bugs between minor changes (not related with bug) is
very difficult.

Keeping customised versions: I can not too much help. I use LibreOffice to
compare changes before merge them.

Best regards, Rafael.



2016-07-21 7:19 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

> Hi. IMO there are historical reason and meaning to use dot for concat.
> Many languages ISO conform use comma for decimal point for numbers. By the
> way file t format csv use other char for represent field delimit.
> See locale var environment for better understant why comma use is not a
> standard nor good idea.
> Regards .
> Em 21/07/2016 05:56, "Phil Daintree" <ph...@lo...> escreveu:
>
> Yes ... However, I really don't think the gains are significant - at
> least not enough  to make such massive changes worthwhile.
>
> To explain my thinking more fully, as you know, I prefer that if the
> change is to be made then all the scripts should be coded in the same
> consistent way throughout, so far as humanly possible. So this would
> require that the change must be made everywhere not just in some scripts
> with other scripts then becoming inconsistent with those changed scripts.
> Such a fundamental change to the code is so pervasive that every script
> would need to be modified and the risk of errors creeping in with such a
> huge amount of editing is too great to warrant consideration of this
> change.
>
> So, I prefer not to change this please.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 21/07/16 19:54, ExsonQu wrote:
> > *Dear all,*
> >
> >                   Thank you for your contribution to webERP!
> >
> >                   I've found that comma is used instead of dot to
> concatenate
> > strings.  The googled result shows that comma is a little fast than dot.
> But
> > I think the comma change will make a impression that lots changes
> happened.
> > It'll be a heavy load for those users to maintain a customization file.
> >
> >                   Should we not use the comma except where comma has to
> be
> > used?
> >
> >                   Thanks and best regards!
> >
> >                   Exson
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Should-we-use-dot-instead-of-comma-as-concatenation-operator-tp4658639.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> > patterns at an interface-level. Reveals which users, apps, and protocols
> are
> > consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> > J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> > reports.http://sdm.link/zohodev2dev
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] PDF generator in webERP.

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

Hi Exson.

Sorry by the delay. You are welcome.

I think at a certain time we can dispense with the use of
~/includes/class.pdf.php. The class.pdf.php is an intermediary
between R&OS_pdf.php_class (how functions were written inside webERP) and
~/includes/tcpdf/tcpdf.php (the actually used functions in webERP). Nicola
Asuni released a new version of TCPDF; unfortunately something inside webRP
causes a bug with the new version.

I begun to replace addJpegFromFile() [from R&OS pdf.php] with Image() [from
tcpdf.php].

Best regards, Rafael.


2016-07-08 20:48 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi, Rafael,*
>
>                 Thank you for your documentation.
>                 Since some parts of those pdf files not display Chinese
> characters properly, I've reviewed all your post and they give me lots of
> help.
>                 I've found that mb_substr() function missed encoding in
> addTextWrap() function. It's fixed now and hope it also make some
> improvements for the utf8 code separation.
>
>                Thanks again!
>
>                 Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/PDF-generator-in-webERP-tp4658061p4658633.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Should we use dot instead of comma as concatenation operator?

[gilberto d. s. a. <gs...@gm...>]

Hi. IMO there are historical reason and meaning to use dot for concat.
Many languages ISO conform use comma for decimal point for numbers. By the
way file t format csv use other char for represent field delimit.
See locale var environment for better understant why comma use is not a
standard nor good idea.
Regards .
Em 21/07/2016 05:56, "Phil Daintree" <ph...@lo...> escreveu:

Yes ... However, I really don't think the gains are significant - at
least not enough  to make such massive changes worthwhile.

To explain my thinking more fully, as you know, I prefer that if the
change is to be made then all the scripts should be coded in the same
consistent way throughout, so far as humanly possible. So this would
require that the change must be made everywhere not just in some scripts
with other scripts then becoming inconsistent with those changed scripts.
Such a fundamental change to the code is so pervasive that every script
would need to be modified and the risk of errors creeping in with such a
huge amount of editing is too great to warrant consideration of this change.

So, I prefer not to change this please.

Phil

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

On 21/07/16 19:54, ExsonQu wrote:
> *Dear all,*
>
>                   Thank you for your contribution to webERP!
>
>                   I've found that comma is used instead of dot to
concatenate
> strings.  The googled result shows that comma is a little fast than dot.
But
> I think the comma change will make a impression that lots changes
happened.
> It'll be a heavy load for those users to maintain a customization file.
>
>                   Should we not use the comma except where comma has to be
> used?
>
>                   Thanks and best regards!
>
>                   Exson
>
>
>
> --
> View this message in context:
http://weberp-accounting.1478800.n4.nabble.com/Should-we-use-dot-instead-of-comma-as-concatenation-operator-tp4658639.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>


------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Should we use dot instead of comma as concatenation operator?

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

Yes ... However, I really don't think the gains are significant - at 
least not enough  to make such massive changes worthwhile.

To explain my thinking more fully, as you know, I prefer that if the 
change is to be made then all the scripts should be coded in the same 
consistent way throughout, so far as humanly possible. So this would 
require that the change must be made everywhere not just in some scripts 
with other scripts then becoming inconsistent with those changed scripts.
Such a fundamental change to the code is so pervasive that every script 
would need to be modified and the risk of errors creeping in with such a 
huge amount of editing is too great to warrant consideration of this change.

So, I prefer not to change this please.

Phil

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

On 21/07/16 19:54, ExsonQu wrote:
> *Dear all,*
>
>                   Thank you for your contribution to webERP!
>
>                   I've found that comma is used instead of dot to concatenate
> strings.  The googled result shows that comma is a little fast than dot. But
> I think the comma change will make a impression that lots changes happened.
> It'll be a heavy load for those users to maintain a customization file.
>
>                   Should we not use the comma except where comma has to be
> used?
>
>                   Thanks and best regards!
>
>                   Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Should-we-use-dot-instead-of-comma-as-concatenation-operator-tp4658639.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Should we use dot instead of comma as concatenation operator?

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

*Dear all,*

                 Thank you for your contribution to webERP!

                 I've found that comma is used instead of dot to concatenate
strings.  The googled result shows that comma is a little fast than dot. But
I think the comma change will make a impression that lots changes happened.
It'll be a heavy load for those users to maintain a customization file. 

                 Should we not use the comma except where comma has to be
used?

                 Thanks and best regards!

                 Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Should-we-use-dot-instead-of-comma-as-concatenation-operator-tp4658639.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Pc tag suggestion

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

Hi Exson:

I'm not sure how to set a default tag (in my business case, we set tags by
business units, and users report expenses related to different business
units).
As I designed it, by Type of PC Tab is not correct as the tag is linked to
the expense, not the tab.

Do you have an idea how to maintain the current functionality and add your
request?

Regards,
Ricard

2016-07-15 8:13 GMT+08:00 ExsonQu <hex...@gm...>:

> *Hi, Richard,*
>
>                Thank you for your long time nice support.
>
>                 The pc module is quite practical!
>                 I'm wondering if we can make some improvement of basic data
> setup.
>                When we set up the Pc expense, we found it'll be quite time
> consuming to add tag choice. Is it possible to add the tag setting in the
> Expenses for Type of PC tab to minimize the Items setting in Pc expense?
>
>               Thanks and best regards!
>
>               Exson
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Pc-tag-suggestion-tp4658634.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports.http://sdm.link/zohodev2dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Pc tag suggestion

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

*Hi, Richard,*

               Thank you for your long time nice support. 

                The pc module is quite practical! 
                I'm wondering if we can make some improvement of basic data
setup. 
               When we set up the Pc expense, we found it'll be quite time
consuming to add tag choice. Is it possible to add the tag setting in the
Expenses for Type of PC tab to minimize the Items setting in Pc expense?
              
              Thanks and best regards!

              Exson
                
               



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Pc-tag-suggestion-tp4658634.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] PDF generator in webERP.

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

*Hi, Rafael,*

                Thank you for your documentation. 
                Since some parts of those pdf files not display Chinese
characters properly, I've reviewed all your post and they give me lots of
help. 
                I've found that mb_substr() function missed encoding in
addTextWrap() function. It's fixed now and hope it also make some
improvements for the utf8 code separation. 

               Thanks again!

                Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/PDF-generator-in-webERP-tp4658061p4658633.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Is the suppliers zero invoice reasonable?

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

*Hi, Bob,*

               Thank you for your reply. I'll find some fool-proof method
for this after further investigation. 

               Best regards!

               Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-suppliers-zero-invoice-reasonable-tp4658627p4658632.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Transaction's Rollback failed

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

*Hi, Phil,*

        Thank you for your quick reply. 

        I've changed the table lock to row lock which provides extra safe
locking read. 

       Thanks and best regards!

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Transaction-s-Rollback-failed-tp4658233p4658631.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Transaction's Rollback failed

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

I can't quite recall - but I think there was a good reason ... at the 
time!!
The idea was to release the lock on systypes as soon as possible so that 
other transactions could be started without choking at the same time. 
The risk though is that the transaction counter is incremented and no 
transaction is actually committed. In principle I think the ideal 
solution is to have the lock table removed and bring the systypes update 
inside the transaction.

Phil

On 2016-07-07 06:11, ExsonQu wrote:
> *Dear all,*
> 
>              I've found the reason for the atomic transaction feature
> failure. It is caused by the "Lock Table" sql statement which causes a
> implicit commit.
>              In order to fix this problem, we have to move the
> GetNextTransNo function outside of the transaction begin statements or
> remove the lock table sql statement.
>              Is any idea for this?
> 
>              Thanks and best regards!
> 
>               Exson
> 
> 
> ExsonQu wrote*
>> Dear all,
> *
>> 
>>                I found a serious problem in WorkOrderReceive.php 
>> during
>> fixing a bug.
>> 
>>               The transaction roll back failed for following query
>> statement ( It's around at line 450~454).
>> 
>>                       	$SQL = "UPDATE locstock
>> 				SET quantity = locstock.quantity + " . $QuantityReceived . "
>> 				WHERE locstock.stockid = '" . $_POST['StockID'] . "'
>> 				AND loccode = '" . $_POST['IntoLocation'] . "'";
>> 
>>                  All of others queries have been rolled back, but only
>> this one failed. It leads to stock quantity updated so the inventory
>> quantity become a mess.
>> 
>>                Any comments are highly appreciated!
>> 
>>                Thanks in advance!
>> 
>>                Best regards!
>> 
>>                Exson
> 
> 
> 
> 
> 
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Transaction-s-Rollback-failed-tp4658233p4658628.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech 
> luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Is the suppliers zero invoice reasonable?

[rfthomas <rf...@as...>]

We get samples from suppliers that have accompanying zero value invoices.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-suppliers-zero-invoice-reasonable-tp4658627p4658629.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Transaction's Rollback failed

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

*Dear all,*

             I've found the reason for the atomic transaction feature
failure. It is caused by the "Lock Table" sql statement which causes a
implicit commit. 
             In order to fix this problem, we have to move the
GetNextTransNo function outside of the transaction begin statements or
remove the lock table sql statement. 
             Is any idea for this?

             Thanks and best regards!

              Exson


ExsonQu wrote*
> Dear all,
*
> 
>                I found a serious problem in WorkOrderReceive.php during
> fixing a bug.
> 
>               The transaction roll back failed for following query
> statement ( It's around at line 450~454). 
> 
>                       	$SQL = "UPDATE locstock
> 				SET quantity = locstock.quantity + " . $QuantityReceived . "
> 				WHERE locstock.stockid = '" . $_POST['StockID'] . "'
> 				AND loccode = '" . $_POST['IntoLocation'] . "'";
> 
>                  All of others queries have been rolled back, but only
> this one failed. It leads to stock quantity updated so the inventory
> quantity become a mess. 
> 
>                Any comments are highly appreciated!
> 
>                Thanks in advance!
> 
>                Best regards!
> 
>                Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Transaction-s-Rollback-failed-tp4658233p4658628.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Is the suppliers zero invoice reasonable?

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

*Dear all,*

         We found that the supplier invoice is allowed to be zero amount.
It's quite fallibility. Is this really allowed or necessary?

          Thanks and best regards!
         
          Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-suppliers-zero-invoice-reasonable-tp4658627.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13 has been released

[rfthomas <rf...@as...>]

The problem appears to have been caused by various timers set in Apache, PHP,
MariaDB, and webERP and mysterious Windows-10 updates.  All of our desktops
run Windows-10 and are "magically" updated (introducing new bugs).  After
one of the Windows-10 updates that don't tell one what is actually being
updated the infinite loop problem went away.  We then saw timeout messages
from webERP, so we increased the timer value in config.php.  WebERP v4.13 is
now running on our system.  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658626.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13 has been released

[rfthomas <rf...@as...>]

Gilberto,

The process goes into an infinite loop inside PHP.  We started checking the
various header files and at least one deep there are only very minor changes
that should not affect the operation.  We need to look deeper into the
changes/updates in the lower level included libraries.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658625.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13 has been released

[gilberto d. s. a. <gs...@gm...>]

hi.
i use these steps to my migrations weberp:

1-backup current database
2-create new database
3-create new weberp app directory
4-run manual migration-weberp-script on new-database
5-adjust config on new weberp for point to new-database
6-login on new-weberp environment

do not make any concurrent changes (mysql, php or so related)

look at log for what is going on (weberp and apache2 log files).

is necessary understand very clear what is base directory used by weberp.

i have made teste with this version using apache2.4.18 , mysql 5.5.48 and
php5.6.18 all using windows 7 32bits with service pack sp1. install and run
new version is worked fine using demonstration environment of weberp.

if your mig not works please post log for complementr analyse

2016-06-07 10:46 GMT-03:00 rfthomas <rf...@as...>:

> Andrew,
>
> The session files are created and managed by the Apache server and saved in
> the APACHE server directory where all of the log and individual session
> files are saved.
>
> Each session file has a unique very long name and contains the session
> variable information.  There is a session file created when we attempt the
> upgrade, but it is empty.
>
> All,
>
> Anyone have any suggestions how we can proceed?  We thought that the
> version
> of PHP might be a problem and installed PHP 7.0.3.  It broke webERP 4.12.3
> showing many error messages as well as most of our other PHP applications
> stopped working.  We have returned to PHP 5.4.31.
>
> Bob Thomas
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658616.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



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

Re: [WebERP-developers] webERP_4.13 has been released

[rfthomas <rf...@as...>]

Andrew,

The session files are created and managed by the Apache server and saved in
the APACHE server directory where all of the log and individual session
files are saved.

Each session file has a unique very long name and contains the session
variable information.  There is a session file created when we attempt the
upgrade, but it is empty.

All,

Anyone have any suggestions how we can proceed?  We thought that the version
of PHP might be a problem and installed PHP 7.0.3.  It broke webERP 4.12.3
showing many error messages as well as most of our other PHP applications
stopped working.  We have returned to PHP 5.4.31.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658616.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13 has been released

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

A wild shot in the dark.
Could it be anything to do with existing session files on the web server? Are you session files part of the directory structure you copied over and hence aren't there when unzip cleanly? Session files have database name and company name in them.  


Best Regards,
Andrew Galuski


-----Original Message-----
From: rfthomas [mailto:rf...@as...] 
Sent: Monday, June 06, 2016 2:25 PM
To: web...@li...
Subject: Re: [WebERP-developers] webERP_4.13 has been released

Exson,

We have followed the upgrade instructions and are unable to get into the upgrade process.  It appears that possibly in session.inc the process goes into an infinite loop utilizing CPU but not requesting any database functions.  We know the ...US.mo is opened.

Steps:

1) Copied production webERP directory tree to webERP_DEV.
2) Edited config.php to point to a test data base.  We don't want to disturb the production data until ready place upgrade in production use.
3) Started webERP_DEV/index.php - system goes into an infinite loop.

If we just unzip webERP_4.13 into a new directory and then browse to index.php the installation screen is displayed.

Bob Thomas







--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658614.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] webERP_4.13 has been released

[rfthomas <rf...@as...>]

Exson,

We have followed the upgrade instructions and are unable to get into the
upgrade process.  It appears that possibly in session.inc the process goes
into an infinite loop utilizing CPU but not requesting any database
functions.  We know the ...US.mo is opened.

Steps:

1) Copied production webERP directory tree to webERP_DEV.
2) Edited config.php to point to a test data base.  We don't want to disturb
the production data until ready place upgrade in production use.
3) Started webERP_DEV/index.php - system goes into an infinite loop.

If we just unzip webERP_4.13 into a new directory and then browse to
index.php the installation screen is displayed.

Bob Thomas







--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658614.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13 has been released

[ciesac <we...@si...>]

Great Job, thanks



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612p4658613.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] webERP_4.13 has been released

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

*Dear all,*

            I'm proud to announce that webERP_4.13 version has been
released. 
           
           Thank you for Phil's leadership and great contribution for this
new release. And thank you for Rafael Chacón, Richard, Jan Bakke, Tim and
Andrew.
         
          Thank you Rafael for providing a print css which make screen
directly print possible. And there are many other improvements in this
release from other developer and contributor. You can find this data from
the doc/change of this release. We're very appreciated for those developers
and users' join and contribution.
 
          At the mean time, there are some bugs fixed in this release
including the wrong gl balance which has been obsessed us for a long time.
         
         Thanks you again and looking forward to your continue support!

         Best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-has-been-released-tp4658612.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] webERP_4.13_RC1 has been released

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

I've deleted them from my system so the final release will be free of them

Phil
Phil Daintree
+64 (0)275 567 890

> On 29/05/2016, at 2:16 am, Rafael Chacón <raf...@gm...> wrote:
> 
> Hi Exson:
> 
> In webERP_4.13_RC1.zip, there are 3 files to be deleted (*.orig extension):
> 
> /GetStockImage.php.orig
> /SelectCreditItems.php.orig
> /SelectProduct.php.orig
> 
> Best regards, Rafael.
> 
> 
> 2016-05-27 5:59 GMT-06:00 gilberto dos santos alves <gs...@gm...>:
>> hi.
>> I made download of weberp 4.13.rc1 and installed on following teste environment:
>> OS: windows 7 32bits with service pack sp1
>> Apache2: 2.4.18
>> PHP: 5.6.18
>> mysql:  Ver 14.14 Distrib 5.5.48, for Win32 (x86)
>> 
>> Install with demo files and with new environment.
>> 
>> If necessary admin password and url could be sent for who want make more tests.
>> 
>> regards.
>> 
>> 2016-05-26 4:17 GMT-03:00 ExsonQu <hex...@gm...>:
>>> Dear all,
>>> 
>>>              I'm glad to announce that webERP4.13 RC1 has been release on
>>> May 16,2016.
>>> 
>>>              It's a candidate of webERP4.13 formal release! And you can
>>> download it from here:  download
>>> <https://sourceforge.net/projects/web-erp/files/webERP_4.13_RC1.zip/download>
>>> 
>>>             Please test it and feedback if there is any problem.
>>> 
>>>             Thanks and best regards!
>>> 
>>>             Exson
>>> 
>>> 
>>> 
>>> --
>>> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-RC1-has-been-released-tp4658607.html
>>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>> 
>>> ------------------------------------------------------------------------------
>>> Mobile security can be enabling, not merely restricting. Employees who
>>> bring their own devices (BYOD) to work are irked by the imposition of MDM
>>> restrictions. Mobile Device Manager Plus allows you to control only the
>>> apps on BYO-devices by containerizing them, leaving personal data untouched!
>>> https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> 
>> 
>> 
>> -- 
>> gilberto dos santos alves
>> +55(11)9-8646-5049
>> sao paulo - sp - brasil
>> 
>> 
>> 
>> 
>> 
>> ------------------------------------------------------------------------------
>> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
>> patterns at an interface-level. Reveals which users, apps, and protocols are
>> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> 
> 
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are 
> consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
> J-Flow, sFlow and other flows. Make informed decisions using capacity 
> planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] webERP_4.13_RC1 has been released

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

Hi Exson:

In webERP_4.13_RC1.zip, there are 3 files to be deleted (*.orig extension):

/GetStockImage.php.orig
/SelectCreditItems.php.orig
/SelectProduct.php.orig

Best regards, Rafael.


2016-05-27 5:59 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

> hi.
> I made download of weberp 4.13.rc1 and installed on following teste
> environment:
> OS: windows 7 32bits with service pack sp1
> Apache2: 2.4.18
> PHP: 5.6.18
> mysql:  Ver 14.14 Distrib 5.5.48, for Win32 (x86)
>
> Install with demo files and with new environment.
>
> If necessary admin password and url could be sent for who want make more
> tests.
>
> regards.
>
> 2016-05-26 4:17 GMT-03:00 ExsonQu <hex...@gm...>:
>
>> Dear all,
>>
>>              I'm glad to announce that webERP4.13 RC1 has been release on
>> May 16,2016.
>>
>>              It's a candidate of webERP4.13 formal release! And you can
>> download it from here:  download
>> <
>> https://sourceforge.net/projects/web-erp/files/webERP_4.13_RC1.zip/download
>> >
>>
>>             Please test it and feedback if there is any problem.
>>
>>             Thanks and best regards!
>>
>>             Exson
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/webERP-4-13-RC1-has-been-released-tp4658607.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> Mobile security can be enabling, not merely restricting. Employees who
>> bring their own devices (BYOD) to work are irked by the imposition of MDM
>> restrictions. Mobile Device Manager Plus allows you to control only the
>> apps on BYO-devices by containerizing them, leaving personal data
>> untouched!
>> https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>
>
> --
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>