web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

Hi Exson,

You are welcome!

Best regards, Rafael.


2014-04-05 19:47 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi, Rafael*
>
>     Thank you for your fix.
>     I've received the bug report several weeks before. I could not find the
> reason just found that the system parameters cannot be updated.
>     Thanks again!
>
>     Best regards!
>
>     Exson
>
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] TWIG and

[Jonathan (T. <th...@ic...>]

Hey icedlava,
just wondering, do you have an eta on when you might be making the changes?
I'm starting work on jEditable (I think I've got it figured out, just need
to work out where the javascript should submit to (the api or the form
itself?)). I'm itching to get moving on this if possible.


On Sat, Apr 5, 2014 at 12:00 PM, Phil Daintree <ph...@lo...>wrote:

>  Icedlava - perhaps you could go a ahead with your proposal in the working
> copy - this may blow away some of serakfalcon's work but hopefully we could
> keep the tableview class in place to have a play with.
>
> Serakfalcon's database work to me looks interesting. However, I am not up
> for a rewrite of the webERP code to make the other DBs work more
> efficiently due to limitations of their API. The Doctrine database
> abstraction appears to have a lot of code/scripts and abstraction at every
> turn - very clever stuff but I am really not sure about it. If there was
> some problem with mysql then perhaps it would be worth considering  - but I
> am not aware of a problem. The drivers are not strong enough to consider
> such a rewrite to me.
>
> I would like to have a look at TWIG and icedlavas work.
>
> Thanks
>
>
>
> -------- Original Message --------  Subject: New Reply to Update on View
> Updates  Date: Fri, 04 Apr 2014 01:03:36 -0400  From: webERP Forum
> <in...@we...> <in...@we...>  Reply-To: in...@we...  To:
> ph...@lo...
>
> phil,
>
> serakfalcon has just replied to a thread which you have subscribed to at webERP Forum. This thread is titled Update on View Updates.
>
> Here is an excerpt of the message:
> ------------------------------------------
> I updated Views to include Twig.
>
>  I'll add Views to the working directory so you can try it out. It... (visit the thread to read more..)
> ------------------------------------------
>
> To view the thread, you can go to the following URL:http://www.weberp.org/forum/showthread.php?tid=2133&action=newpost
>
> There may also be other replies to this thread but you will not receive anymore notifications until you visit the board again.
>
> Thank you,
> webERP Forum Staff
>
> ------------------------------------------
> Unsubscription Information:
>
> If you would not like to receive any more notifications of replies to this thread, visit the following URL in your browser:http://www.weberp.org/forum/usercp2.php?action=removesubscription&tid=2133&key=a1f57630c1da5416c08f42f087e9b2a5&my_post_key=ccb046e3b721334d9e5f63cba4406f2a
>
> ------------------------------------------
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Shall we change the SQL end date to 9999-12-31?

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

*Hi, Richard and Phil*

         Thank you for your nice comments. 

         I've did a quick study of this problem. Currently, the scripts
failed strict mode is Prices_Customer.php. I'll fix it immediately to use a
'0000-00-00' as end date instead of '';

        I did a summary for this issue:

       1. In sql table, the default enddate is '9999-12-31'. It's right. 

       2. Prices.php and Prices_Customer.php used to define prices. The
default date is set to '0000-00-00' in Prices.php which acceptable by mysql
strict mode. But in Price_Customer.php, the default date is set to '', which
was denied by the strict mode. 
  
       3. All prices are retrieved from GetPrice.inc.  It will loop all
those prices with specific end date, if no data retrieved, it'll test the
end date is '0000-00-00'.

       4.  Files use function GetPrice() as following:
                 SelectOrderItems_IntoCart.inc
                 SelectCreditItems.php
                 StockDispatch.php
       
       According to the GetPrice() defintion, even we change default end
date to '9999-12-31', it will not affect any calculation result in my
opinion. I think change to '9999-12-31' is NO harmful in this case. 

      What we need to do is change the default end date variable to
'9999-12-31'. sql definition will check if there is duplicated records. And
it can be retrieved successfully in GetPrice.inc.

       Maybe I've overlooked something. Please correct if I'm wrong. 

       Thanks and best regards!

       Exson
     

         

         

 




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shall-we-change-the-SQL-end-date-to-9999-12-31-tp4657341p4657344.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Shall we change the SQL end date to 9999-12-31?

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

Well i think the reason was pragmatic in that i didn't want to do it. We use 0000-00-00 quite a bit, in principle it makes sense to default to 9999-12-31
-- 
Phil Daintree
+64(0)275 567890
Skype: daintree

On April 7, 2014 1:08:15 PM NZST, Pak Ricard <pak...@gm...> wrote:
>Hi Exson:
>
>I brought it up long time ago as it would help to simplify all queries
>regarding prices, as we do not need to add the OR enddate =
>'0000-00-00'
>condition everywhere to detect the current active price. That was my
>main
>goal then, as keeping it as 0000-00-00 was messing with the Joomla!
>extension I used back then.
>
>Really can't remember the reason why it was decided to keep it as is
>(probably a tech reason beyond my understanding), so I can't help much.
>
>As usual, if you decide to go ahead with this change, will be happy to
>test
>i!
>
>Regards,
>Ricard
>
>
>2014-04-06 15:55 GMT+08:00 Tim Schofield <tim...@gm...>:
>
>> Hi Exson,
>>
>> I remember Ricard brought this up a few years ago but Phil wanted to
>> stay using the 0000-00-00 dates at the time.
>>
>> Thanks
>> Tim
>>
>> On 6 April 2014 04:34, ExsonQu <hex...@gm...> wrote:
>> > *Dear all,*
>> >
>> >          Thank you very much for your great work to webERP
>community.
>> >
>> >          I've detected a problem in Prices.php when it runs in
>mysql
>> strict
>> > mode. It will be error for $SQLEndDate='0000-00-00'.
>> >
>> >         Shall we change this to '9999-12-31' to coincide with
>mysql's
>> > definition. Otherwise, users use this strict mode we have to face
>the
>> > problem when they do not set the effective end date.
>> >
>> >         Any comments are highly appreciated!
>> >
>> >         Thanks and best regards!
>> >
>> >         Exson
>> >
>> >
>> >
>> > --
>> > View this message in context:
>>
>http://weberp-accounting.1478800.n4.nabble.com/Shall-we-change-the-SQL-end-date-to-9999-12-31-tp4657341.html
>> > Sent from the web-ERP-developers mailing list archive at
>Nabble.com.
>> >
>> >
>>
>------------------------------------------------------------------------------
>> > _______________________________________________
>> > 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/
>>
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>Put Bad Developers to Shame
>Dominate Development with Jenkins Continuous Integration
>Continuously Automate Build, Test & Deployment 
>Start a new project now. Try Jenkins in the cloud.
>http://p.sf.net/sfu/13600_Cloudbees_APR
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Shall we change the SQL end date to 9999-12-31?

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

Hi Exson:

I brought it up long time ago as it would help to simplify all queries
regarding prices, as we do not need to add the OR enddate = '0000-00-00'
condition everywhere to detect the current active price. That was my main
goal then, as keeping it as 0000-00-00 was messing with the Joomla!
extension I used back then.

Really can't remember the reason why it was decided to keep it as is
(probably a tech reason beyond my understanding), so I can't help much.

As usual, if you decide to go ahead with this change, will be happy to test
i!

Regards,
Ricard


2014-04-06 15:55 GMT+08:00 Tim Schofield <tim...@gm...>:

> Hi Exson,
>
> I remember Ricard brought this up a few years ago but Phil wanted to
> stay using the 0000-00-00 dates at the time.
>
> Thanks
> Tim
>
> On 6 April 2014 04:34, ExsonQu <hex...@gm...> wrote:
> > *Dear all,*
> >
> >          Thank you very much for your great work to webERP community.
> >
> >          I've detected a problem in Prices.php when it runs in mysql
> strict
> > mode. It will be error for $SQLEndDate='0000-00-00'.
> >
> >         Shall we change this to '9999-12-31' to coincide with mysql's
> > definition. Otherwise, users use this strict mode we have to face the
> > problem when they do not set the effective end date.
> >
> >         Any comments are highly appreciated!
> >
> >         Thanks and best regards!
> >
> >         Exson
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Shall-we-change-the-SQL-end-date-to-9999-12-31-tp4657341.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > 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] Shall we change the SQL end date to 9999-12-31?

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

*Dear all,*

         Thank you very much for your great work to webERP community.

         I've detected a problem in Prices.php when it runs in mysql strict
mode. It will be error for $SQLEndDate='0000-00-00'. 
         
        Shall we change this to '9999-12-31' to coincide with mysql's
definition. Otherwise, users use this strict mode we have to face the
problem when they do not set the effective end date.

        Any comments are highly appreciated!

        Thanks and best regards!

        Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shall-we-change-the-SQL-end-date-to-9999-12-31-tp4657341.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

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

*Hi, Rafael,*

       Thank you for your 2 cents.

       I'm wondering the same quantity is printed from webERP directly? Or
it's hand writing?

       Best regards!

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657340.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

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

*Hi, Phil,*

            You're right. And I've same comments from Tim too. Thank you
very much.

            But things a little difference in China. Usually the delivery
note is in B5 size, so we have to create a different layout. I think there
are other Asia country also need this size.

            Best regards!

            Exson

            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657339.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

*Hi, Rafael*

    Thank you for your fix. 
    I've received the bug report several weeks before. I could not find the
reason just found that the system parameters cannot be updated. 
    Thanks again!

    Best regards!

    Exson

    
          



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

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

Hi all,

My two cents: Here, in a hardware store, we have several people in the
process with several documents (to prevent stealing):

Sales_man send >---(Authorised picking list)---> Warehouse_man >---(goods
delivery note)---> Freight_man >---(goods receiving note)---> Customer's_man

For a "goods delivery note" we use the webERP picking list, signed by the "
Freight_man".
For a "goods receiving note" we use the webERP invoice, signed by the "
Customer'".

But, so far, in this hardware store, all the quantities in the 3 documents
are the same.

Best regards, Rafael.


2014-04-05 15:34 GMT-06:00 Phil Daintree <ph...@lo...>:

> A dispatch note with the quantities on is effectively an invoice.
> If you wish to show the quantities but not the price/extending total
> amounts then it is just a modification of the invoice script.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 06/04/14 03:22, ExsonQu wrote:
> > *Dear all,*
> >
> >             Thank you for your comments.
> >
> >             After investigate the processes, I found that webERP has not
> > provided a Dispatched Note with printed actual delivery quantity. There
> is
> > one which named packing note and dispatched notes in some interface. But
> the
> > actual delivery quantity can only be written manually.
> >
> >            In China and Hong Kong, lots of customers will not accept
> Delivery
> > Notes with handwriting number. Since the prices are not allowed shown in
> > Delivery Note, so the invoice cannot be used.
> >
> >           So the dispatched note with actual delivery quantity is a must
> in
> > my opinion. I'll add it later.
> >
> >           And I've reviewed the picking lists too. It is designed
> concise and
> > great. A think a html view should be available, and the actual picked
> > quantity should also be recordable. Even we can use this to hold some
> goods
> > for special cases.
> >
> >           Thank you for the comments from Phil, Jo and Tim.
> >
> >           Any idea is still highly appreciated before I start to code it.
> >
> >           Thanks and best regards!
> >
> >           Exson
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

Hi Phil,

Thank you, very much. Yes, the problem was caused by this line:
$ItemDescriptionLanguages =
explode(',',$_SESSION['ItemDescriptionLanguages']);

$ItemDescriptionLanguages is an array, and
$_SESSION['ItemDescriptionLanguages']
is a vector (one dimension variable).

I am now testing the fix in Stocks.php and StockClone.php. No problem at
the moment...

Best regards, Rafael.


2014-04-05 15:30 GMT-06:00 Phil Daintree <ph...@lo...>:

>
> In Stocks.php - line 23
>
> $ItemDescriptionLanguages =
> explode(',',$_SESSION['ItemDescriptionLanguages']);
>
> So in SystemParameters.php - we set a
> confname='ItemDescriptionLanguages' to a comma separated list of locales
> that we wish to maintain language descriptions for our items.
>
> Perhaps your configuration has been messed up and this config option not
> set for some reason.
>
> Regards
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 06/04/14 04:39, Rafael Chacón wrote:
> > Dear All:
> >
> > In Stocks.php and in StockClone.php, I got this error when I edit
> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> > "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
> >
> > Database Error 1064 :
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'AN)' at line 1
> > Database SQL Failure : The SQL that failed was
> > SELECT descriptiontranslation, language_id FROM
> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
> >
> > The company has 3 languages (Spanish -default-) and
> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
> >
> > When I re-setup ItemDescriptionLanguages, I works,but in a second
> > query the problem reappears.
> >
> > I think the problem is that the variable ItemDescriptionLanguages
> deletes.
> >
> > Any ideas to where to look for?
> >
> > Best regards,
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

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

A dispatch note with the quantities on is effectively an invoice.
If you wish to show the quantities but not the price/extending total 
amounts then it is just a modification of the invoice script.

Phil

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

On 06/04/14 03:22, ExsonQu wrote:
> *Dear all,*
>
>             Thank you for your comments.
>
>             After investigate the processes, I found that webERP has not
> provided a Dispatched Note with printed actual delivery quantity. There is
> one which named packing note and dispatched notes in some interface. But the
> actual delivery quantity can only be written manually.
>
>            In China and Hong Kong, lots of customers will not accept Delivery
> Notes with handwriting number. Since the prices are not allowed shown in
> Delivery Note, so the invoice cannot be used.
>
>           So the dispatched note with actual delivery quantity is a must in
> my opinion. I'll add it later.
>
>           And I've reviewed the picking lists too. It is designed concise and
> great. A think a html view should be available, and the actual picked
> quantity should also be recordable. Even we can use this to hold some goods
> for special cases.
>
>           Thank you for the comments from Phil, Jo and Tim.
>
>           Any idea is still highly appreciated before I start to code it.
>
>           Thanks and best regards!
>
>           Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

In Stocks.php - line 23

$ItemDescriptionLanguages = 
explode(',',$_SESSION['ItemDescriptionLanguages']);

So in SystemParameters.php - we set a 
confname='ItemDescriptionLanguages' to a comma separated list of locales 
that we wish to maintain language descriptions for our items.

Perhaps your configuration has been messed up and this config option not 
set for some reason.

Regards

Phil

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

On 06/04/14 04:39, Rafael Chacón wrote:
> Dear All:
>
> In Stocks.php and in StockClone.php, I got this error when I edit
> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>
> Database Error 1064 :
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'AN)' at line 1
> Database SQL Failure : The SQL that failed was
> SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>
> The company has 3 languages (Spanish -default-) and
> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>
> When I re-setup ItemDescriptionLanguages, I works,but in a second
> query the problem reappears.
>
> I think the problem is that the variable ItemDescriptionLanguages deletes.
>
> Any ideas to where to look for?
>
> Best regards,
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

Hi Gilberto,

I am not sure if this is related with the SELECT Error in Stocks.php and
StockClone.php. I am going to review the Spanish and French .po files.

Best regards, Rafael.


2014-04-05 12:25 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

> please visuali confirme your .po for see characters that not have
> representative visual char, correct them and after that compile .mo and and
> make your tests.
>
>
> 2014-04-05 15:22 GMT-03:00 Rafael Chacón <raf...@gm...>:
>
> Hi, Gilberto:
>>
>> I use utf-8 as usual. In which files there are some incorrect code page
>> chars?
>>
>> Best regards, Rafael.
>>
>>
>>
>>
>> 2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>:
>>
>> do you use utf-8 or iso-8859-x . please confirm your translation (.po
>>> files) and .mo files. in pt-br, before revise all translation file, there
>>> are some incorrect code page chars.
>>>
>>>
>>> 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...
>>> >:
>>>
>>>>  Dear All:
>>>>
>>>> In Stocks.php and in StockClone.php, I got this error when I edit
>>>> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
>>>> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>>>>
>>>> Database Error 1064 :
>>>> You have an error in your SQL syntax; check the manual that
>>>> corresponds to your MySQL server version for the right syntax to use
>>>> near 'AN)' at line 1
>>>> Database SQL Failure : The SQL that failed was
>>>> SELECT descriptiontranslation, language_id FROM
>>>> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>>>>
>>>> The company has 3 languages (Spanish -default-) and
>>>> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>>>>
>>>> When I re-setup ItemDescriptionLanguages, I works,but in a second
>>>> query the problem reappears.
>>>>
>>>> I think the problem is that the variable ItemDescriptionLanguages
>>>> deletes.
>>>>
>>>> Any ideas to where to look for?
>>>>
>>>> Best regards,
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> _______________________________________________
>>>> Web-erp-developers mailing list
>>>> Web...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>
>>>
>>>

[WebERP-developers] Fwd: Stocks.php, StockClone.php: Error in SELECT

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

Hi Tim,

Thank you, very much. I am going to recheck GetConfig.php.

Best regards, Rafael.




---------- Forwarded message ----------
From: Tim Schofield <tim...@gm...>
Date: 2014-04-05 12:41 GMT-06:00
Subject: Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT
To: Rafael Emilio Chacon <raf...@gm...>


The variable is loaded in includes/GetConfig.php which loads the
entire config table into the session array in the form of
$_SESSION[confname]=confvalue;

Thanks
Tim

On 5 April 2014 18:25, Rafael Chacón <raf...@gm...> wrote:
> Hi Tim,
>
> Thank you, very much. Yes, you are right. When $ItemDescriptionLanguages
is
> empty, <pre>$sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';</pre>
deletes
> wrong.
>
> I improved <pre>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
>     foreach ($ItemDescriptionLanguages as $DescriptionLanguage) {
>
>         $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
>     }
>     $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>
> </pre>
>  with
> <pre>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "'";
> </pre>
>  (if we want all DescriptionTranslation is not necessary to list each),
but
> main problem persist: somewhere $ItemDescriptionLanguages becomes empty
(or
> is not global?).
>
> I appreciate if someone can give me an idea of where this variable is
> loaded. I have reviewed Stocks.php, StockClone.php, SystemParameters.php
and
> SQL_CommonFunctions.inc, and so far I have not found anything that tells
me
> what can be the cause of $ItemDescriptionLanguages becomes empty.
>
> Best regards, Rafael.
>
>
> 2014-04-05 11:06 GMT-06:00 Tim Schofield <tim...@gm...>:
>
>> Hi Rafael,
>>
>> I can tell you what is happening but I cannot explain it .Line 937 of
>> Stocks.php is as follows:
>>
>> $sql = "SELECT descriptiontranslation, language_id FROM
>> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
>>
>> and then there is a loop that is supposed to add some conditions:
>>
>> $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
>>
>> and then finally the line
>>
>> $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>>
>> removes the last 3 characters and (which is supposed to be 'OR ' that
>> was added to the last condition) and then adds a closing bracket.
>> However for some reason the loop is not adding anything and so then
>> the last 3 characters added in 937 "D (" are being removed so your SQL
>> ends with "AN)" which is obviously wrong, see the error message.
>>
>> You can verify what I am saying by putting an
>>
>> echo $sql;
>>
>> after line 941 but before the DB_query() function call.
>>
>> For this to happen $ItemDescriptionLanguages must be empty but I
>> cannot tell you why. I have tried to force it to happen on my machine
>> but cannot replicate it. Check the value of the config variable
>> ItemDescriptionLanguages in the config table and see what that says.
>>
>> Thanks
>> Tim
>>
>> On 5 April 2014 17:39, Rafael Chacón <raf...@gm...>
>> wrote:
>> > Dear All:
>> >
>> > In Stocks.php and in StockClone.php, I got this error when I edit
>> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
>> > "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>> >
>> > Database Error 1064 :
>> > You have an error in your SQL syntax; check the manual that
>> > corresponds to your MySQL server version for the right syntax to use
>> > near 'AN)' at line 1
>> > Database SQL Failure : The SQL that failed was
>> > SELECT descriptiontranslation, language_id FROM
>> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>> >
>> > The company has 3 languages (Spanish -default-) and
>> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>> >
>> > When I re-setup ItemDescriptionLanguages, I works,but in a second
>> > query the problem reappears.
>> >
>> > I think the problem is that the variable ItemDescriptionLanguages
>> > deletes.
>> >
>> > Any ideas to where to look for?
>> >
>> > Best regards,
>> >
>> >
>> >
------------------------------------------------------------------------------
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

please visuali confirme your .po for see characters that not have
representative visual char, correct them and after that compile .mo and and
make your tests.


2014-04-05 15:22 GMT-03:00 Rafael Chacón <raf...@gm...>:

> Hi, Gilberto:
>
> I use utf-8 as usual. In which files there are some incorrect code page
> chars?
>
> Best regards, Rafael.
>
>
>
>
> 2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>:
>
> do you use utf-8 or iso-8859-x . please confirm your translation (.po
>> files) and .mo files. in pt-br, before revise all translation file, there
>> are some incorrect code page chars.
>>
>>
>> 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>
>> :
>>
>>>  Dear All:
>>>
>>> In Stocks.php and in StockClone.php, I got this error when I edit
>>> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
>>> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>>>
>>> Database Error 1064 :
>>> You have an error in your SQL syntax; check the manual that
>>> corresponds to your MySQL server version for the right syntax to use
>>> near 'AN)' at line 1
>>> Database SQL Failure : The SQL that failed was
>>> SELECT descriptiontranslation, language_id FROM
>>> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>>>
>>> The company has 3 languages (Spanish -default-) and
>>> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>>>
>>> When I re-setup ItemDescriptionLanguages, I works,but in a second
>>> query the problem reappears.
>>>
>>> I think the problem is that the variable ItemDescriptionLanguages
>>> deletes.
>>>
>>> Any ideas to where to look for?
>>>
>>> Best regards,
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>>
>>
>> --
>> gilberto dos santos alves
>> +55.11.98646-5049
>> sao paulo - sp - brasil
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

Hi, Gilberto:

I use utf-8 as usual. In which files there are some incorrect code page
chars?

Best regards, Rafael.




2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

> do you use utf-8 or iso-8859-x . please confirm your translation (.po
> files) and .mo files. in pt-br, before revise all translation file, there
> are some incorrect code page chars.
>
>
> 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>:
>
>> Dear All:
>>
>> In Stocks.php and in StockClone.php, I got this error when I edit
>> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
>> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>>
>> Database Error 1064 :
>> You have an error in your SQL syntax; check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'AN)' at line 1
>> Database SQL Failure : The SQL that failed was
>> SELECT descriptiontranslation, language_id FROM
>> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>>
>> The company has 3 languages (Spanish -default-) and
>> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>>
>> When I re-setup ItemDescriptionLanguages, I works,but in a second
>> query the problem reappears.
>>
>> I think the problem is that the variable ItemDescriptionLanguages deletes.
>>
>> Any ideas to where to look for?
>>
>> Best regards,
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>
>
> --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

do you use utf-8 or iso-8859-x . please confirm your translation (.po
files) and .mo files. in pt-br, before revise all translation file, there
are some incorrect code page chars.


2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>:

> Dear All:
>
> In Stocks.php and in StockClone.php, I got this error when I edit
> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>
> Database Error 1064 :
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'AN)' at line 1
> Database SQL Failure : The SQL that failed was
> SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>
> The company has 3 languages (Spanish -default-) and
> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>
> When I re-setup ItemDescriptionLanguages, I works,but in a second
> query the problem reappears.
>
> I think the problem is that the variable ItemDescriptionLanguages deletes.
>
> Any ideas to where to look for?
>
> Best regards,
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

Hi Tim,

Thank you, very much. Yes, you are right. When $ItemDescriptionLanguages is
empty, *<pre>$sql = mb_substr($sql,0,mb_strlen($sql)-3) .
')';</pre>*deletes wrong.

I improved <pre>




*$sql = "SELECT descriptiontranslation, language_id FROM
stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
foreach ($ItemDescriptionLanguages as $DescriptionLanguage) {        $sql
.= "language_id='" . $DescriptionLanguage ."' OR ";    }    $sql =
mb_substr($sql,0,mb_strlen($sql)-3) . ')';*
</pre>
 with
<pre>
*$sql = "SELECT descriptiontranslation, language_id FROM
stockdescriptiontranslations WHERE stockid='" . $StockID . "'";*
</pre>
 (if we want all DescriptionTranslation is not necessary to list each), but
main problem persist: somewhere $ItemDescriptionLanguages becomes empty (or
is not global?).

I appreciate if someone can give me an idea of ​​where this variable is
loaded. I have reviewed Stocks.php, StockClone.php, SystemParameters.php
and SQL_CommonFunctions.inc, and so far I have not found anything that
tells me what can be the cause of $ItemDescriptionLanguages becomes empty.

Best regards, Rafael.


2014-04-05 11:06 GMT-06:00 Tim Schofield <tim...@gm...>:

> Hi Rafael,
>
> I can tell you what is happening but I cannot explain it .Line 937 of
> Stocks.php is as follows:
>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
>
> and then there is a loop that is supposed to add some conditions:
>
> $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
>
> and then finally the line
>
> $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>
> removes the last 3 characters and (which is supposed to be 'OR ' that
> was added to the last condition) and then adds a closing bracket.
> However for some reason the loop is not adding anything and so then
> the last 3 characters added in 937 "D (" are being removed so your SQL
> ends with "AN)" which is obviously wrong, see the error message.
>
> You can verify what I am saying by putting an
>
> echo $sql;
>
> after line 941 but before the DB_query() function call.
>
> For this to happen $ItemDescriptionLanguages must be empty but I
> cannot tell you why. I have tried to force it to happen on my machine
> but cannot replicate it. Check the value of the config variable
> ItemDescriptionLanguages in the config table and see what that says.
>
> Thanks
> Tim
>
> On 5 April 2014 17:39, Rafael Chacón <raf...@gm...>
> wrote:
> > Dear All:
> >
> > In Stocks.php and in StockClone.php, I got this error when I edit
> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> > "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
> >
> > Database Error 1064 :
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'AN)' at line 1
> > Database SQL Failure : The SQL that failed was
> > SELECT descriptiontranslation, language_id FROM
> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
> >
> > The company has 3 languages (Spanish -default-) and
> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
> >
> > When I re-setup ItemDescriptionLanguages, I works,but in a second
> > query the problem reappears.
> >
> > I think the problem is that the variable ItemDescriptionLanguages
> deletes.
> >
> > Any ideas to where to look for?
> >
> > Best regards,
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > 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] Stocks.php, StockClone.php: Error in SELECT

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

Dear All:

In Stocks.php and in StockClone.php, I got this error when I edit
(Stocks.php) or clone (StockClone.php) a stock item, after I click the
"Update" / "Insert New Item"  button (Stocks.php / StockClone.php):

Database Error 1064 :
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'AN)' at line 1
Database SQL Failure : The SQL that failed was
SELECT descriptiontranslation, language_id FROM
stockdescriptiontranslations WHERE stockid='2000000300030' AN)

The company has 3 languages (Spanish -default-) and
ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".

When I re-setup ItemDescriptionLanguages, I works,but in a second
query the problem reappears.

I think the problem is that the variable ItemDescriptionLanguages deletes.

Any ideas to where to look for?

Best regards,

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

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

*Dear all,*

           Thank you for your comments.

           After investigate the processes, I found that webERP has not
provided a Dispatched Note with printed actual delivery quantity. There is
one which named packing note and dispatched notes in some interface. But the
actual delivery quantity can only be written manually. 

          In China and Hong Kong, lots of customers will not accept Delivery
Notes with handwriting number. Since the prices are not allowed shown in
Delivery Note, so the invoice cannot be used.

         So the dispatched note with actual delivery quantity is a must in
my opinion. I'll add it later. 

         And I've reviewed the picking lists too. It is designed concise and
great. A think a html view should be available, and the actual picked
quantity should also be recordable. Even we can use this to hold some goods
for special cases. 

         Thank you for the comments from Phil, Jo and Tim. 

         Any idea is still highly appreciated before I start to code it.

         Thanks and best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] TWIG and

[Jonathan (T. <th...@ic...>]

I would like to see what icedlava has, I can probably rework my code to fit
in since it's fairly modular. The table class can be separated from the
rest but it needs to be able to hook in to the header and footer to take
advantage of Datatables (and later jEditable- which would make the tables
editable in-place using AJAX) which is a lot easier with some sort of
template management system controlling output.

I posted my code with the general impression that getting things moving was
better than nothing, but I'm fine if it doesn't get used as-is or ends up
being changed in the end. Of course, I'm happy with it but I'd rather have
something everyone is happy with.

Also, beyond the table class, the forms class also adds a few things for
convenience. (For example, it would support a rotating FormID that changes
on every form submission and is form-specific, which would help prevent
attacks (I implemented this in a different project and could port the code
back into webERP if people are interested)), as well as selects that can
filter based on other selects. besides just making making forms easier.
Like the table class, the form class doesn't contain context, it just
expects to be fed information and displays that information. It should also
be optionally AJAX-able but I'll develop that in the other project I'm
working on and if it seems simple enough I can port it back.

There's also a menu class but I don't care about it as much as it pretty
much would only affect 1 file but it could lead to custom dashboards and
showing/hiding unused menu options on a per-user basis.

For Doctrine, the advantages will only really become obvious if we start
working with databases other than MySQL. It works, also the PDO file I
wrote works, you can add those as options and which theoretically expands
the amount of supported DB's by a factor of ~10 but that requires bringing
the install code in line with the rest of the project (right now it uses
mysqli specific code instead of going through the database wrapper, and
some functions use the ` symbol which is MySQL specific). So until that
happens it's true that it doesn't change much, and it's not a priority for
me.


On Sat, Apr 5, 2014 at 12:00 PM, Phil Daintree <ph...@lo...>wrote:

>  Icedlava - perhaps you could go a ahead with your proposal in the working
> copy - this may blow away some of serakfalcon's work but hopefully we could
> keep the tableview class in place to have a play with.
>
> Serakfalcon's database work to me looks interesting. However, I am not up
> for a rewrite of the webERP code to make the other DBs work more
> efficiently due to limitations of their API. The Doctrine database
> abstraction appears to have a lot of code/scripts and abstraction at every
> turn - very clever stuff but I am really not sure about it. If there was
> some problem with mysql then perhaps it would be worth considering  - but I
> am not aware of a problem. The drivers are not strong enough to consider
> such a rewrite to me.
>
> I would like to have a look at TWIG and icedlavas work.
>
> Thanks
>
>
>
> -------- Original Message --------  Subject: New Reply to Update on View
> Updates  Date: Fri, 04 Apr 2014 01:03:36 -0400  From: webERP Forum
> <in...@we...> <in...@we...>  Reply-To: in...@we...  To:
> ph...@lo...
>
> phil,
>
> serakfalcon has just replied to a thread which you have subscribed to at webERP Forum. This thread is titled Update on View Updates.
>
> Here is an excerpt of the message:
> ------------------------------------------
> I updated Views to include Twig.
>
>  I'll add Views to the working directory so you can try it out. It... (visit the thread to read more..)
> ------------------------------------------
>
> To view the thread, you can go to the following URL:http://www.weberp.org/forum/showthread.php?tid=2133&action=newpost
>
> There may also be other replies to this thread but you will not receive anymore notifications until you visit the board again.
>
> Thank you,
> webERP Forum Staff
>
> ------------------------------------------
> Unsubscription Information:
>
> If you would not like to receive any more notifications of replies to this thread, visit the following URL in your browser:http://www.weberp.org/forum/usercp2.php?action=removesubscription&tid=2133&key=a1f57630c1da5416c08f42f087e9b2a5&my_post_key=ccb046e3b721334d9e5f63cba4406f2a
>
> ------------------------------------------
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

[WebERP-developers] TWIG and

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

Icedlava - perhaps you could go a ahead with your proposal in the 
working copy - this may blow away some of serakfalcon's work but 
hopefully we could keep the tableview class in place to have a play with.

Serakfalcon's database work to me looks interesting. However, I am not 
up for a rewrite of the webERP code to make the other DBs work more 
efficiently due to limitations of their API. The Doctrine database 
abstraction appears to have a lot of code/scripts and abstraction at 
every turn - very clever stuff but I am really not sure about it. If 
there was some problem with mysql then perhaps it would be worth 
considering  - but I am not aware of a problem. The drivers are not 
strong enough to consider such a rewrite to me.

I would like to have a look at TWIG and icedlavas work.

Thanks



-------- Original Message --------
Subject: 	New Reply to Update on View Updates
Date: 	Fri, 04 Apr 2014 01:03:36 -0400
From: 	webERP Forum <in...@we...>
Reply-To: 	in...@we...
To: 	ph...@lo...



phil,

serakfalcon has just replied to a thread which you have subscribed to at webERP Forum. This thread is titled Update on View Updates.

Here is an excerpt of the message:
------------------------------------------
I updated Views to include Twig.

  I'll add Views to the working directory so you can try it out. It... (visit the thread to read more..)
------------------------------------------

To view the thread, you can go to the following URL:
http://www.weberp.org/forum/showthread.php?tid=2133&action=newpost

There may also be other replies to this thread but you will not receive anymore notifications until you visit the board again.

Thank you,
webERP Forum Staff

------------------------------------------
Unsubscription Information:

If you would not like to receive any more notifications of replies to this thread, visit the following URL in your browser:
http://www.weberp.org/forum/usercp2.php?action=removesubscription&tid=2133&key=a1f57630c1da5416c08f42f087e9b2a5&my_post_key=ccb046e3b721334d9e5f63cba4406f2a

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

Re: [WebERP-developers] Other feature to develop

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

*Hi,Phil,*

            Thank you for your reply. 

           Although it seems a CRM like feature, the main reason is that our
search engine is not so flexible as expected. 

           For instance, those control is a search limit issue. Why not
think about to revise the search engine to provide more choices to users or
developers?

           Thanks and best regards!

           Exson
           



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Other-feature-to-develop-tp4657319p4657323.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Other feature to develop

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

Yes I think the team leader is a CRM thing... if a user is allowed to 
see all salesman then it is simple and we also have the option for a 
saleman only login. I think it is probably a mod specific to the 
business that it was done for more than having widespread appeal.

Phil

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

On 03/04/14 22:23, ExsonQu wrote:
> *Hi, Phil,*
>
>             Thank you for your nice comments.
>
>             1. Thumb has almost completed the bin management module. I've
> created an distributed version based on 4.10. I'll send it to you later.
>
>             2. Yes. It's better to assessment suppliers based on items. The
> situation seems a little complicated. Need more consideration to this.
>
>             3. Currently, the salesman can only review their own customer
> data if they are marked as salesman login. But we found that sometime some
> users have 2 salesman accounts, they have to login and logout to see the
> accounts they owned. And if there are several sales groups, the group leader
> will not see their team's status. Thumb has created a team feature. Do we
> need to add this feature to webERP? It seems more like a CRM concept. And
> another scenario is that, some users will have one team to manage sales
> orders, their responsibility will be classified by customer's type. For
> instance, Clerk A will be responsible for customer type A, and Clerk B will
> be responsible for customer type B. Shall this features is needed?
>
>             Thanks and best regards!
>
>             Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Other-feature-to-develop-tp4657319p4657321.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>