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