web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Performance 4.11.3

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

please have you examples for what we can test in our environment? Until now
we have see some processing slow on sales invoices when we confirm invoice
[1]

http://[our-erp-4113-env]/SelectOrderItems.php?NewOrder=Yes


2014-07-30 12:10 GMT-03:00 rfthomas <rf...@as...>:

> We downloaded the most recent distribution 4.11.3 and installed it on our
> server.  We notice a significant drop in responsiveness when logging into
> the system, navigating the menues, as well as painting any new screen.
>
> There appears to have been a lot of work to support multiple languages so
> that a user in one language can create documents (invoices, orders, etc.)
> in
> the target user's language, i.e customer or vendor's language.
>
> We are trying to understand the causes of this new slower performance.  The
> prior versions were delightfully responsive.  We have made no changes to
> our
> server configuration.
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Performance-4-11-3-tp4657575.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> 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

[WebERP-developers] ?> missing from many .inc and .php files

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

Our AMP implementation is very strict with respect to include handling.  All
php code sections must be terminated properly with ?>.  On every webERP
distribution, including 4.11.3, we find a number of files missing this
termination.  It is time consuming to check every file for proper
termination.  There are a number of files in /includes that are not properly
terminated.  In addition in /includes/tcpdf..., /includes/phpplot...,
/includes/barcodepack..., /doc/manual... .php and .inc files are missing the
?> terminator in many cases.

We recognize that some php implementations relax this requirement, but
having such is good programming practice, and in our case a rigid
requirement.  Placing ?> terminator in these files works in all
implementations.

Bob Thomas





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/missing-from-many-inc-and-php-files-tp4657576.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Performance 4.11.3

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

We downloaded the most recent distribution 4.11.3 and installed it on our
server.  We notice a significant drop in responsiveness when logging into
the system, navigating the menues, as well as painting any new screen.

There appears to have been a lot of work to support multiple languages so
that a user in one language can create documents (invoices, orders, etc.) in
the target user's language, i.e customer or vendor's language.

We are trying to understand the causes of this new slower performance.  The
prior versions were delightfully responsive.  We have made no changes to our
server configuration.



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Performance-4-11-3-tp4657575.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Unable to purchase Inventory types of service/labor

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

Well I am a bit confused by this - I thought I had long since allowed 
labour type items i.e. dummy items that have labour recovery accounts 
set up (although could be used for other subcontract services) to be 
added to purchase orders. I have made the necessary changes just now.

Phil

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

On 23/07/14 07:01, rfthomas wrote:
> We routinely have sub-tier vendors perform value added operations on parts.
> While inventory is shipped and received, the items being billed are value
> added operation, e.g. solder connectors.  The PO_Items.php denies
> utilization of inventory items with mbflag = D, A, K, or G.  Items of type
> service/labor have an mbflag = D.
>
> When we receive the parts back from the sub-tier vendor we do not want to
> create new inventory, since we need to build the item using inventory
> transferred to the sub-tier vendor.
>
> We have made a simple modification to the PO_Items.php script replacing all
> occurrences of mbflag<>'D' with mbflag<>'X' (such being done to allow for
> easy reconstruction of the script if necessary).
>
> Things appear to work as expected, except that when creating the purchase
> order the system has no cost to use by default.
>
> We see that receipts can be properly made with no inventory being created.
>
> Does anyone see any potential problems with this change?
>
> Thank you,
> Bob Thomas
>
>
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Unable-to-purchase-Inventory-types-of-service-labor-tp4657567.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Integrating Purchase Orders and Work Orders

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

We use sub-tier vendors for several of our manufacturing operations.  There
currently is no integration between the Purchasing System and Work Orders. 
It should be possible to when a Purchase Order is generated to create work
orders for those items that are manufactured with a BOM.

We would envision that upon issuing the Purchase Order one or more Work
Orders would be automatically created at the sub-tier's location.  If
inventory needed to be transferred (issues) to the customer such would be
done via a mechanism integral to the work order issue function.

When the finished items are received from the sub-tier, either receipt would
be entered at the work order and noted on the purchase order or the purchase
order receiving function would be utilized to perform a work order receipt.

As things currently are implemented there is a great deal of duplicate entry
with many chances for error.

Bob Thomas 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Integrating-Purchase-Orders-and-Work-Orders-tp4657568.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Unable to purchase Inventory types of service/labor

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

We routinely have sub-tier vendors perform value added operations on parts. 
While inventory is shipped and received, the items being billed are value
added operation, e.g. solder connectors.  The PO_Items.php denies
utilization of inventory items with mbflag = D, A, K, or G.  Items of type
service/labor have an mbflag = D.

When we receive the parts back from the sub-tier vendor we do not want to
create new inventory, since we need to build the item using inventory
transferred to the sub-tier vendor.

We have made a simple modification to the PO_Items.php script replacing all
occurrences of mbflag<>'D' with mbflag<>'X' (such being done to allow for
easy reconstruction of the script if necessary).

Things appear to work as expected, except that when creating the purchase
order the system has no cost to use by default.

We see that receipts can be properly made with no inventory being created.

Does anyone see any potential problems with this change?

Thank you,
Bob Thomas





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Unable-to-purchase-Inventory-types-of-service-labor-tp4657567.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] schema weberp tables with index key duplicated

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

ok.


2014-07-19 2:21 GMT-03:00 Phil Daintree <ph...@lo...>:

>  I've committed this.
> Thanks
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 17/07/14 05:24, gilberto dos santos alves wrote:
>
> please have you received this email? please confirm. thanks.
>
>
> 2014-07-08 13:32 GMT-03:00 gilberto dos santos alves <gs...@gm...>:
>
>>  Hi for all!
>>
>>  After revise schema for weberp, we find inside files default.sql,
>> demo.sql, weberpchine.sql following tables, with duplicated function index
>> key:
>>
>>     banktrans,
>>     gltrans,
>>     mrpdemandtypes,
>>     salescatprod,
>>     stockrequest,
>>     storequestitemns.
>>
>>  These are commands executed to drop these keys, run on your database
>> will clean unnecessary index.
>>
>>
>> alter table banktrans drop key ref_10, drop key ref_9, drop key ref_8,
>> drop key ref_7;
>> alter table banktrans drop key ref_6, drop key ref_5, drop key ref_4,
>> drop key ref_3, drop key ref_2;
>> alter table gltrans drop key tag_2, drop key tag_3, drop key tag_4;
>> alter table mrpdemandtypes drop key mrpdemandtype;
>> alter table salescatprod drop key manufacturers_id_2;
>> alter table salescatprod drop key manufacturers_id;
>> alter table stockrequest drop key departmentid_2;
>> alter table stockrequest drop key loccode_2;
>> alter table stockrequestitems drop key stockid_2, drop key dispatchid_2;
>>
>>
>>  Following revised tables contain entries commented and identified by:
>>
>> 1 - revised-081-,
>> 2 - revised-082-,
>> 3 - revised-083-,
>>  4 - revised-084-,
>> 5 - revised-085-,
>>  6 - revised-086-,
>>
>>  All this are on pastebin [1]
>>
>> [1] http://pastebin.com/EgXjpqb1
>>
>>  Please Phil could you verify and confirm these changes for next release?
>>
>>  Best regards!
>>
>>
>>
>>
>> CREATE TABLE IF NOT EXISTS `banktrans` (
>>   `banktransid` bigint(20) NOT NULL AUTO_INCREMENT,
>>   `type` smallint(6) NOT NULL DEFAULT '0',
>>   `transno` bigint(20) NOT NULL DEFAULT '0',
>>   `bankact` varchar(20) NOT NULL DEFAULT '0',
>>   `ref` varchar(50) NOT NULL DEFAULT '',
>>   `amountcleared` double NOT NULL DEFAULT '0',
>>   `exrate` double NOT NULL DEFAULT '1' COMMENT 'From bank account
>> currency to payment currency',
>>   `functionalexrate` double NOT NULL DEFAULT '1' COMMENT 'Account
>> currency to functional currency',
>>   `transdate` date NOT NULL DEFAULT '0000-00-00',
>>   `banktranstype` varchar(30) NOT NULL DEFAULT '',
>>   `amount` double NOT NULL DEFAULT '0',
>>   `currcode` char(3) NOT NULL DEFAULT '',
>>   PRIMARY KEY (`banktransid`),
>>   KEY `BankAct` (`bankact`,`ref`),
>>   KEY `TransDate` (`transdate`),
>>   KEY `TransType` (`banktranstype`),
>>   KEY `Type` (`type`,`transno`),
>>   KEY `CurrCode` (`currcode`),
>>   KEY `ref` (`ref`)
>>   /* revised-081-begin by gsavix08-jul-2014
>>   KEY `ref_2` (`ref`),
>>   KEY `ref_3` (`ref`),
>>   KEY `ref_4` (`ref`),
>>   KEY `ref_5` (`ref`),
>>   KEY `ref_6` (`ref`),
>>   KEY `ref_7` (`ref`),
>>   KEY `ref_8` (`ref`),
>>   KEY `ref_9` (`ref`),
>>   KEY `ref_10` (`ref`)
>>   revised-081-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>>
>>
>> CREATE TABLE IF NOT EXISTS `gltrans` (
>>   `counterindex` int(11) NOT NULL AUTO_INCREMENT,
>>   `type` smallint(6) NOT NULL DEFAULT '0',
>>   `typeno` bigint(16) NOT NULL DEFAULT '1',
>>   `chequeno` int(11) NOT NULL DEFAULT '0',
>>   `trandate` date NOT NULL DEFAULT '0000-00-00',
>>   `periodno` smallint(6) NOT NULL DEFAULT '0',
>>   `account` varchar(20) NOT NULL DEFAULT '0',
>>   `narrative` varchar(200) NOT NULL DEFAULT '',
>>   `amount` double NOT NULL DEFAULT '0',
>>   `posted` tinyint(4) NOT NULL DEFAULT '0',
>>   `jobref` varchar(20) NOT NULL DEFAULT '',
>>   `tag` tinyint(4) NOT NULL DEFAULT '0',
>>   PRIMARY KEY (`counterindex`),
>>   KEY `Account` (`account`),
>>   KEY `ChequeNo` (`chequeno`),
>>   KEY `PeriodNo` (`periodno`),
>>   KEY `Posted` (`posted`),
>>   KEY `TranDate` (`trandate`),
>>   KEY `TypeNo` (`typeno`),
>>   KEY `Type_and_Number` (`type`,`typeno`),
>>   KEY `JobRef` (`jobref`),
>>   KEY `tag` (`tag`)
>>   /* revised-082-begin by gsavix08-jul-2014
>>   KEY `tag_2` (`tag`),
>>   KEY `tag_3` (`tag`),
>>   KEY `tag_4` (`tag`)
>>   revised-082-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>>
>>
>>
>> CREATE TABLE IF NOT EXISTS `mrpdemandtypes` (
>>   `mrpdemandtype` varchar(6) NOT NULL DEFAULT '',
>>   `description` char(30) NOT NULL DEFAULT '',
>>   PRIMARY KEY (`mrpdemandtype`)
>>   /* revised-083-begin by gsavix08-jul-2014
>>   KEY `mrpdemandtype` (`mrpdemandtype`)
>>   revised-083-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>>
>> CREATE TABLE IF NOT EXISTS `salescatprod` (
>>   `salescatid` tinyint(4) NOT NULL DEFAULT '0',
>>   `stockid` varchar(20) NOT NULL DEFAULT '',
>>   `manufacturers_id` int(11) NOT NULL,
>>   `featured` tinyint(4) NOT NULL DEFAULT '0',
>>   PRIMARY KEY (`salescatid`,`stockid`),
>>   KEY `salescatid` (`salescatid`),
>>   KEY `stockid` (`stockid`),
>>   KEY `manufacturer_id` (`manufacturers_id`)
>>   /* revised-084-begin by gsavix08-jul-2014
>>   KEY `manufacturers_id` (`manufacturers_id`)
>>   KEY `manufacturers_id_2` (`manufacturers_id`)
>>   revised-084-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>>
>>
>> CREATE TABLE IF NOT EXISTS `stockrequest` (
>>   `dispatchid` int(11) NOT NULL AUTO_INCREMENT,
>>   `loccode` varchar(5) NOT NULL DEFAULT '',
>>   `departmentid` int(11) NOT NULL DEFAULT '0',
>>   `despatchdate` date NOT NULL DEFAULT '0000-00-00',
>>   `authorised` tinyint(4) NOT NULL DEFAULT '0',
>>   `closed` tinyint(4) NOT NULL DEFAULT '0',
>>   `narrative` text NOT NULL,
>>   PRIMARY KEY (`dispatchid`),
>>   KEY `loccode` (`loccode`),
>>   KEY `departmentid` (`departmentid`)
>>   /* revised-085-begin by gsavix08-jul-2014
>>   KEY `loccode_2` (`loccode`),
>>   KEY `departmentid_2` (`departmentid`)
>>   revised-085-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
>>
>>
>> CREATE TABLE IF NOT EXISTS `stockrequestitems` (
>>   `dispatchitemsid` int(11) NOT NULL DEFAULT '0',
>>   `dispatchid` int(11) NOT NULL DEFAULT '0',
>>   `stockid` varchar(20) NOT NULL DEFAULT '',
>>   `quantity` double NOT NULL DEFAULT '0',
>>   `qtydelivered` double NOT NULL DEFAULT '0',
>>   `decimalplaces` int(11) NOT NULL DEFAULT '0',
>>   `uom` varchar(20) NOT NULL DEFAULT '',
>>   `completed` tinyint(4) NOT NULL DEFAULT '0',
>>   PRIMARY KEY (`dispatchitemsid`,`dispatchid`),
>>   KEY `dispatchid` (`dispatchid`),
>>   KEY `stockid` (`stockid`)
>>   /* revised-086-begin by gsavix08-jul-2014
>>   KEY `dispatchid_2` (`dispatchid`),
>>   KEY `stockid_2` (`stockid`)
>>   revised-086-end by gsavix08-jul-2014 */
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>>
>>
>>
>>
>>
>> --
>> gilberto dos santos alves
>> +55.11.98646-5049
>> sao paulo - sp - brasil
>>
>>
>>
>>
>>
>
>
> --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.http://p.sf.net/sfu/bds
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> 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] schema weberp tables with index key duplicated

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

I've committed this.
Thanks

Phil

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

On 17/07/14 05:24, gilberto dos santos alves wrote:
> please have you received this email? please confirm. thanks.
>
>
> 2014-07-08 13:32 GMT-03:00 gilberto dos santos alves <gs...@gm... 
> <mailto:gs...@gm...>>:
>
>     Hi for all!
>
>     After revise schema for weberp, we find inside files default.sql,
>     demo.sql, weberpchine.sql following tables, with duplicated
>     function index key:
>
>         banktrans,
>         gltrans,
>         mrpdemandtypes,
>         salescatprod,
>         stockrequest,
>         storequestitemns.
>
>     These are commands executed to drop these keys, run on your
>     database will clean unnecessary index.
>
>
>     alter table banktrans drop key ref_10, drop key ref_9, drop key
>     ref_8, drop key ref_7;
>     alter table banktrans drop key ref_6, drop key ref_5, drop key
>     ref_4, drop key ref_3, drop key ref_2;
>     alter table gltrans drop key tag_2, drop key tag_3, drop key tag_4;
>     alter table mrpdemandtypes drop key mrpdemandtype;
>     alter table salescatprod drop key manufacturers_id_2;
>     alter table salescatprod drop key manufacturers_id;
>     alter table stockrequest drop key departmentid_2;
>     alter table stockrequest drop key loccode_2;
>     alter table stockrequestitems drop key stockid_2, drop key
>     dispatchid_2;
>
>
>     Following revised tables contain entries commented and identified by:
>
>     1 - revised-081-,
>     2 - revised-082-,
>     3 - revised-083-,
>     4 - revised-084-,
>     5 - revised-085-,
>     6 - revised-086-,
>
>     All this are on pastebin [1]
>
>     [1] http://pastebin.com/EgXjpqb1
>
>     Please Phil could you verify and confirm these changes for next
>     release?
>
>     Best regards!
>
>
>
>
>     CREATE TABLE IF NOT EXISTS `banktrans` (
>       `banktransid` bigint(20) NOT NULL AUTO_INCREMENT,
>       `type` smallint(6) NOT NULL DEFAULT '0',
>       `transno` bigint(20) NOT NULL DEFAULT '0',
>       `bankact` varchar(20) NOT NULL DEFAULT '0',
>       `ref` varchar(50) NOT NULL DEFAULT '',
>       `amountcleared` double NOT NULL DEFAULT '0',
>       `exrate` double NOT NULL DEFAULT '1' COMMENT 'From bank account
>     currency to payment currency',
>       `functionalexrate` double NOT NULL DEFAULT '1' COMMENT 'Account
>     currency to functional currency',
>       `transdate` date NOT NULL DEFAULT '0000-00-00',
>       `banktranstype` varchar(30) NOT NULL DEFAULT '',
>       `amount` double NOT NULL DEFAULT '0',
>       `currcode` char(3) NOT NULL DEFAULT '',
>       PRIMARY KEY (`banktransid`),
>       KEY `BankAct` (`bankact`,`ref`),
>       KEY `TransDate` (`transdate`),
>       KEY `TransType` (`banktranstype`),
>       KEY `Type` (`type`,`transno`),
>       KEY `CurrCode` (`currcode`),
>       KEY `ref` (`ref`)
>       /* revised-081-begin by gsavix08-jul-2014
>       KEY `ref_2` (`ref`),
>       KEY `ref_3` (`ref`),
>       KEY `ref_4` (`ref`),
>       KEY `ref_5` (`ref`),
>       KEY `ref_6` (`ref`),
>       KEY `ref_7` (`ref`),
>       KEY `ref_8` (`ref`),
>       KEY `ref_9` (`ref`),
>       KEY `ref_10` (`ref`)
>       revised-081-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>
>
>     CREATE TABLE IF NOT EXISTS `gltrans` (
>       `counterindex` int(11) NOT NULL AUTO_INCREMENT,
>       `type` smallint(6) NOT NULL DEFAULT '0',
>       `typeno` bigint(16) NOT NULL DEFAULT '1',
>       `chequeno` int(11) NOT NULL DEFAULT '0',
>       `trandate` date NOT NULL DEFAULT '0000-00-00',
>       `periodno` smallint(6) NOT NULL DEFAULT '0',
>       `account` varchar(20) NOT NULL DEFAULT '0',
>       `narrative` varchar(200) NOT NULL DEFAULT '',
>       `amount` double NOT NULL DEFAULT '0',
>       `posted` tinyint(4) NOT NULL DEFAULT '0',
>       `jobref` varchar(20) NOT NULL DEFAULT '',
>       `tag` tinyint(4) NOT NULL DEFAULT '0',
>       PRIMARY KEY (`counterindex`),
>       KEY `Account` (`account`),
>       KEY `ChequeNo` (`chequeno`),
>       KEY `PeriodNo` (`periodno`),
>       KEY `Posted` (`posted`),
>       KEY `TranDate` (`trandate`),
>       KEY `TypeNo` (`typeno`),
>       KEY `Type_and_Number` (`type`,`typeno`),
>       KEY `JobRef` (`jobref`),
>       KEY `tag` (`tag`)
>       /* revised-082-begin by gsavix08-jul-2014
>       KEY `tag_2` (`tag`),
>       KEY `tag_3` (`tag`),
>       KEY `tag_4` (`tag`)
>       revised-082-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>
>
>
>     CREATE TABLE IF NOT EXISTS `mrpdemandtypes` (
>       `mrpdemandtype` varchar(6) NOT NULL DEFAULT '',
>       `description` char(30) NOT NULL DEFAULT '',
>       PRIMARY KEY (`mrpdemandtype`)
>       /* revised-083-begin by gsavix08-jul-2014
>       KEY `mrpdemandtype` (`mrpdemandtype`)
>       revised-083-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>     CREATE TABLE IF NOT EXISTS `salescatprod` (
>       `salescatid` tinyint(4) NOT NULL DEFAULT '0',
>       `stockid` varchar(20) NOT NULL DEFAULT '',
>       `manufacturers_id` int(11) NOT NULL,
>       `featured` tinyint(4) NOT NULL DEFAULT '0',
>       PRIMARY KEY (`salescatid`,`stockid`),
>       KEY `salescatid` (`salescatid`),
>       KEY `stockid` (`stockid`),
>       KEY `manufacturer_id` (`manufacturers_id`)
>       /* revised-084-begin by gsavix08-jul-2014
>       KEY `manufacturers_id` (`manufacturers_id`)
>       KEY `manufacturers_id_2` (`manufacturers_id`)
>       revised-084-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>
>     CREATE TABLE IF NOT EXISTS `stockrequest` (
>       `dispatchid` int(11) NOT NULL AUTO_INCREMENT,
>       `loccode` varchar(5) NOT NULL DEFAULT '',
>       `departmentid` int(11) NOT NULL DEFAULT '0',
>       `despatchdate` date NOT NULL DEFAULT '0000-00-00',
>       `authorised` tinyint(4) NOT NULL DEFAULT '0',
>       `closed` tinyint(4) NOT NULL DEFAULT '0',
>       `narrative` text NOT NULL,
>       PRIMARY KEY (`dispatchid`),
>       KEY `loccode` (`loccode`),
>       KEY `departmentid` (`departmentid`)
>       /* revised-085-begin by gsavix08-jul-2014
>       KEY `loccode_2` (`loccode`),
>       KEY `departmentid_2` (`departmentid`)
>       revised-085-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
>
>
>     CREATE TABLE IF NOT EXISTS `stockrequestitems` (
>       `dispatchitemsid` int(11) NOT NULL DEFAULT '0',
>       `dispatchid` int(11) NOT NULL DEFAULT '0',
>       `stockid` varchar(20) NOT NULL DEFAULT '',
>       `quantity` double NOT NULL DEFAULT '0',
>       `qtydelivered` double NOT NULL DEFAULT '0',
>       `decimalplaces` int(11) NOT NULL DEFAULT '0',
>       `uom` varchar(20) NOT NULL DEFAULT '',
>       `completed` tinyint(4) NOT NULL DEFAULT '0',
>       PRIMARY KEY (`dispatchitemsid`,`dispatchid`),
>       KEY `dispatchid` (`dispatchid`),
>       KEY `stockid` (`stockid`)
>       /* revised-086-begin by gsavix08-jul-2014
>       KEY `dispatchid_2` (`dispatchid`),
>       KEY `stockid_2` (`stockid`)
>       revised-086-end by gsavix08-jul-2014 */
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>
>
>
>
>     -- 
>     gilberto dos santos alves
>     +55.11.98646-5049 <tel:%2B55.11.98646-5049>
>     sao paulo - sp - brasil
>
>
>
>
>
>
>
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] schema weberp tables with index key duplicated

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

please have you received this email? please confirm. thanks.


2014-07-08 13:32 GMT-03:00 gilberto dos santos alves <gs...@gm...>:

> Hi for all!
>
> After revise schema for weberp, we find inside files default.sql,
> demo.sql, weberpchine.sql following tables, with duplicated function index
> key:
>
>     banktrans,
>     gltrans,
>     mrpdemandtypes,
>     salescatprod,
>     stockrequest,
>     storequestitemns.
>
> These are commands executed to drop these keys, run on your database will
> clean unnecessary index.
>
>
> alter table banktrans drop key ref_10, drop key ref_9, drop key ref_8,
> drop key ref_7;
> alter table banktrans drop key ref_6, drop key ref_5, drop key ref_4, drop
> key ref_3, drop key ref_2;
> alter table gltrans drop key tag_2, drop key tag_3, drop key tag_4;
> alter table mrpdemandtypes drop key mrpdemandtype;
> alter table salescatprod drop key manufacturers_id_2;
> alter table salescatprod drop key manufacturers_id;
> alter table stockrequest drop key departmentid_2;
> alter table stockrequest drop key loccode_2;
> alter table stockrequestitems drop key stockid_2, drop key dispatchid_2;
>
>
> Following revised tables contain entries commented and identified by:
>
> 1 - revised-081-,
> 2 - revised-082-,
> 3 - revised-083-,
> 4 - revised-084-,
> 5 - revised-085-,
> 6 - revised-086-,
>
> All this are on pastebin [1]
>
> [1] http://pastebin.com/EgXjpqb1
>
> Please Phil could you verify and confirm these changes for next release?
>
> Best regards!
>
>
>
>
> CREATE TABLE IF NOT EXISTS `banktrans` (
>   `banktransid` bigint(20) NOT NULL AUTO_INCREMENT,
>   `type` smallint(6) NOT NULL DEFAULT '0',
>   `transno` bigint(20) NOT NULL DEFAULT '0',
>   `bankact` varchar(20) NOT NULL DEFAULT '0',
>   `ref` varchar(50) NOT NULL DEFAULT '',
>   `amountcleared` double NOT NULL DEFAULT '0',
>   `exrate` double NOT NULL DEFAULT '1' COMMENT 'From bank account currency
> to payment currency',
>   `functionalexrate` double NOT NULL DEFAULT '1' COMMENT 'Account currency
> to functional currency',
>   `transdate` date NOT NULL DEFAULT '0000-00-00',
>   `banktranstype` varchar(30) NOT NULL DEFAULT '',
>   `amount` double NOT NULL DEFAULT '0',
>   `currcode` char(3) NOT NULL DEFAULT '',
>   PRIMARY KEY (`banktransid`),
>   KEY `BankAct` (`bankact`,`ref`),
>   KEY `TransDate` (`transdate`),
>   KEY `TransType` (`banktranstype`),
>   KEY `Type` (`type`,`transno`),
>   KEY `CurrCode` (`currcode`),
>   KEY `ref` (`ref`)
>   /* revised-081-begin by gsavix08-jul-2014
>   KEY `ref_2` (`ref`),
>   KEY `ref_3` (`ref`),
>   KEY `ref_4` (`ref`),
>   KEY `ref_5` (`ref`),
>   KEY `ref_6` (`ref`),
>   KEY `ref_7` (`ref`),
>   KEY `ref_8` (`ref`),
>   KEY `ref_9` (`ref`),
>   KEY `ref_10` (`ref`)
>   revised-081-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>
>
> CREATE TABLE IF NOT EXISTS `gltrans` (
>   `counterindex` int(11) NOT NULL AUTO_INCREMENT,
>   `type` smallint(6) NOT NULL DEFAULT '0',
>   `typeno` bigint(16) NOT NULL DEFAULT '1',
>   `chequeno` int(11) NOT NULL DEFAULT '0',
>   `trandate` date NOT NULL DEFAULT '0000-00-00',
>   `periodno` smallint(6) NOT NULL DEFAULT '0',
>   `account` varchar(20) NOT NULL DEFAULT '0',
>   `narrative` varchar(200) NOT NULL DEFAULT '',
>   `amount` double NOT NULL DEFAULT '0',
>   `posted` tinyint(4) NOT NULL DEFAULT '0',
>   `jobref` varchar(20) NOT NULL DEFAULT '',
>   `tag` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`counterindex`),
>   KEY `Account` (`account`),
>   KEY `ChequeNo` (`chequeno`),
>   KEY `PeriodNo` (`periodno`),
>   KEY `Posted` (`posted`),
>   KEY `TranDate` (`trandate`),
>   KEY `TypeNo` (`typeno`),
>   KEY `Type_and_Number` (`type`,`typeno`),
>   KEY `JobRef` (`jobref`),
>   KEY `tag` (`tag`)
>   /* revised-082-begin by gsavix08-jul-2014
>   KEY `tag_2` (`tag`),
>   KEY `tag_3` (`tag`),
>   KEY `tag_4` (`tag`)
>   revised-082-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
>
>
>
> CREATE TABLE IF NOT EXISTS `mrpdemandtypes` (
>   `mrpdemandtype` varchar(6) NOT NULL DEFAULT '',
>   `description` char(30) NOT NULL DEFAULT '',
>   PRIMARY KEY (`mrpdemandtype`)
>   /* revised-083-begin by gsavix08-jul-2014
>   KEY `mrpdemandtype` (`mrpdemandtype`)
>   revised-083-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
> CREATE TABLE IF NOT EXISTS `salescatprod` (
>   `salescatid` tinyint(4) NOT NULL DEFAULT '0',
>   `stockid` varchar(20) NOT NULL DEFAULT '',
>   `manufacturers_id` int(11) NOT NULL,
>   `featured` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`salescatid`,`stockid`),
>   KEY `salescatid` (`salescatid`),
>   KEY `stockid` (`stockid`),
>   KEY `manufacturer_id` (`manufacturers_id`)
>   /* revised-084-begin by gsavix08-jul-2014
>   KEY `manufacturers_id` (`manufacturers_id`)
>   KEY `manufacturers_id_2` (`manufacturers_id`)
>   revised-084-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>
> CREATE TABLE IF NOT EXISTS `stockrequest` (
>   `dispatchid` int(11) NOT NULL AUTO_INCREMENT,
>   `loccode` varchar(5) NOT NULL DEFAULT '',
>   `departmentid` int(11) NOT NULL DEFAULT '0',
>   `despatchdate` date NOT NULL DEFAULT '0000-00-00',
>   `authorised` tinyint(4) NOT NULL DEFAULT '0',
>   `closed` tinyint(4) NOT NULL DEFAULT '0',
>   `narrative` text NOT NULL,
>   PRIMARY KEY (`dispatchid`),
>   KEY `loccode` (`loccode`),
>   KEY `departmentid` (`departmentid`)
>   /* revised-085-begin by gsavix08-jul-2014
>   KEY `loccode_2` (`loccode`),
>   KEY `departmentid_2` (`departmentid`)
>   revised-085-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
>
>
> CREATE TABLE IF NOT EXISTS `stockrequestitems` (
>   `dispatchitemsid` int(11) NOT NULL DEFAULT '0',
>   `dispatchid` int(11) NOT NULL DEFAULT '0',
>   `stockid` varchar(20) NOT NULL DEFAULT '',
>   `quantity` double NOT NULL DEFAULT '0',
>   `qtydelivered` double NOT NULL DEFAULT '0',
>   `decimalplaces` int(11) NOT NULL DEFAULT '0',
>   `uom` varchar(20) NOT NULL DEFAULT '',
>   `completed` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`dispatchitemsid`,`dispatchid`),
>   KEY `dispatchid` (`dispatchid`),
>   KEY `stockid` (`stockid`)
>   /* revised-086-begin by gsavix08-jul-2014
>   KEY `dispatchid_2` (`dispatchid`),
>   KEY `stockid_2` (`stockid`)
>   revised-086-end by gsavix08-jul-2014 */
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>
>
>
>
> --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>


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

[WebERP-developers] Multi-currency Suppliers

[RL <rl...@ya...>]

Hello, could you please tell me the reason why I can´t have the same supplier transactions with different currencies? 

Regards

[WebERP-developers] schema weberp tables with index key duplicated

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

Hi for all!

After revise schema for weberp, we find inside files default.sql, demo.sql,
weberpchine.sql following tables, with duplicated function index key:

    banktrans,
    gltrans,
    mrpdemandtypes,
    salescatprod,
    stockrequest,
    storequestitemns.

These are commands executed to drop these keys, run on your database will
clean unnecessary index.


alter table banktrans drop key ref_10, drop key ref_9, drop key ref_8, drop
key ref_7;
alter table banktrans drop key ref_6, drop key ref_5, drop key ref_4, drop
key ref_3, drop key ref_2;
alter table gltrans drop key tag_2, drop key tag_3, drop key tag_4;
alter table mrpdemandtypes drop key mrpdemandtype;
alter table salescatprod drop key manufacturers_id_2;
alter table salescatprod drop key manufacturers_id;
alter table stockrequest drop key departmentid_2;
alter table stockrequest drop key loccode_2;
alter table stockrequestitems drop key stockid_2, drop key dispatchid_2;


Following revised tables contain entries commented and identified by:

1 - revised-081-,
2 - revised-082-,
3 - revised-083-,
4 - revised-084-,
5 - revised-085-,
6 - revised-086-,

All this are on pastebin [1]

[1] http://pastebin.com/EgXjpqb1

Please Phil could you verify and confirm these changes for next release?

Best regards!




CREATE TABLE IF NOT EXISTS `banktrans` (
  `banktransid` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` smallint(6) NOT NULL DEFAULT '0',
  `transno` bigint(20) NOT NULL DEFAULT '0',
  `bankact` varchar(20) NOT NULL DEFAULT '0',
  `ref` varchar(50) NOT NULL DEFAULT '',
  `amountcleared` double NOT NULL DEFAULT '0',
  `exrate` double NOT NULL DEFAULT '1' COMMENT 'From bank account currency
to payment currency',
  `functionalexrate` double NOT NULL DEFAULT '1' COMMENT 'Account currency
to functional currency',
  `transdate` date NOT NULL DEFAULT '0000-00-00',
  `banktranstype` varchar(30) NOT NULL DEFAULT '',
  `amount` double NOT NULL DEFAULT '0',
  `currcode` char(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`banktransid`),
  KEY `BankAct` (`bankact`,`ref`),
  KEY `TransDate` (`transdate`),
  KEY `TransType` (`banktranstype`),
  KEY `Type` (`type`,`transno`),
  KEY `CurrCode` (`currcode`),
  KEY `ref` (`ref`)
  /* revised-081-begin by gsavix08-jul-2014
  KEY `ref_2` (`ref`),
  KEY `ref_3` (`ref`),
  KEY `ref_4` (`ref`),
  KEY `ref_5` (`ref`),
  KEY `ref_6` (`ref`),
  KEY `ref_7` (`ref`),
  KEY `ref_8` (`ref`),
  KEY `ref_9` (`ref`),
  KEY `ref_10` (`ref`)
  revised-081-end by gsavix08-jul-2014 */
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `gltrans` (
  `counterindex` int(11) NOT NULL AUTO_INCREMENT,
  `type` smallint(6) NOT NULL DEFAULT '0',
  `typeno` bigint(16) NOT NULL DEFAULT '1',
  `chequeno` int(11) NOT NULL DEFAULT '0',
  `trandate` date NOT NULL DEFAULT '0000-00-00',
  `periodno` smallint(6) NOT NULL DEFAULT '0',
  `account` varchar(20) NOT NULL DEFAULT '0',
  `narrative` varchar(200) NOT NULL DEFAULT '',
  `amount` double NOT NULL DEFAULT '0',
  `posted` tinyint(4) NOT NULL DEFAULT '0',
  `jobref` varchar(20) NOT NULL DEFAULT '',
  `tag` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`counterindex`),
  KEY `Account` (`account`),
  KEY `ChequeNo` (`chequeno`),
  KEY `PeriodNo` (`periodno`),
  KEY `Posted` (`posted`),
  KEY `TranDate` (`trandate`),
  KEY `TypeNo` (`typeno`),
  KEY `Type_and_Number` (`type`,`typeno`),
  KEY `JobRef` (`jobref`),
  KEY `tag` (`tag`)
  /* revised-082-begin by gsavix08-jul-2014
  KEY `tag_2` (`tag`),
  KEY `tag_3` (`tag`),
  KEY `tag_4` (`tag`)
  revised-082-end by gsavix08-jul-2014 */
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;



CREATE TABLE IF NOT EXISTS `mrpdemandtypes` (
  `mrpdemandtype` varchar(6) NOT NULL DEFAULT '',
  `description` char(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`mrpdemandtype`)
  /* revised-083-begin by gsavix08-jul-2014
  KEY `mrpdemandtype` (`mrpdemandtype`)
  revised-083-end by gsavix08-jul-2014 */
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `salescatprod` (
  `salescatid` tinyint(4) NOT NULL DEFAULT '0',
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `manufacturers_id` int(11) NOT NULL,
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`salescatid`,`stockid`),
  KEY `salescatid` (`salescatid`),
  KEY `stockid` (`stockid`),
  KEY `manufacturer_id` (`manufacturers_id`)
  /* revised-084-begin by gsavix08-jul-2014
  KEY `manufacturers_id` (`manufacturers_id`)
  KEY `manufacturers_id_2` (`manufacturers_id`)
  revised-084-end by gsavix08-jul-2014 */
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `stockrequest` (
  `dispatchid` int(11) NOT NULL AUTO_INCREMENT,
  `loccode` varchar(5) NOT NULL DEFAULT '',
  `departmentid` int(11) NOT NULL DEFAULT '0',
  `despatchdate` date NOT NULL DEFAULT '0000-00-00',
  `authorised` tinyint(4) NOT NULL DEFAULT '0',
  `closed` tinyint(4) NOT NULL DEFAULT '0',
  `narrative` text NOT NULL,
  PRIMARY KEY (`dispatchid`),
  KEY `loccode` (`loccode`),
  KEY `departmentid` (`departmentid`)
  /* revised-085-begin by gsavix08-jul-2014
  KEY `loccode_2` (`loccode`),
  KEY `departmentid_2` (`departmentid`)
  revised-085-end by gsavix08-jul-2014 */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `stockrequestitems` (
  `dispatchitemsid` int(11) NOT NULL DEFAULT '0',
  `dispatchid` int(11) NOT NULL DEFAULT '0',
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `quantity` double NOT NULL DEFAULT '0',
  `qtydelivered` double NOT NULL DEFAULT '0',
  `decimalplaces` int(11) NOT NULL DEFAULT '0',
  `uom` varchar(20) NOT NULL DEFAULT '',
  `completed` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`dispatchitemsid`,`dispatchid`),
  KEY `dispatchid` (`dispatchid`),
  KEY `stockid` (`stockid`)
  /* revised-086-begin by gsavix08-jul-2014
  KEY `dispatchid_2` (`dispatchid`),
  KEY `stockid_2` (`stockid`)
  revised-086-end by gsavix08-jul-2014 */
) ENGINE=InnoDB DEFAULT CHARSET=utf8;





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

[WebERP-developers] warning message SupplierTypes.php

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

Please, after insert records on types of supplier receive this advice.

Inserts are ok, but some could explain how can i correct this?

thanks!

""

*Warning*: Unknown: Your script possibly relies on a session side-effect
which existed until PHP 4.2.3. Please be advised that the session extension
does not consider global variables as a source of data, unless
register_globals is enabled. You can disable this functionality and this
warning by setting session.bug_compat_42 or session.bug_compat_warn to off,
respectively in *Unknown* on line *0*

""

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

Re: [WebERP-developers] revision for weberp 4-11-3 constraints duplicated

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

i think it is not a bug because constraint names are distinct.


2014-07-07 3:05 GMT-03:00 Phil Daintree <ph...@lo...>:

>  I have committed this.
>
> I wonder how this happens though as the script is dumped from mysql so
> perhaps a bug with mysqldump?
>
> Thanks Gilberto :-)
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 07/07/14 07:49, gilberto dos santos alves wrote:
>
>  Hi. Please could some one revise files default.sql, demo.sql and
> weberpchina.sql for constraints that are duplicated for these 5 tables?
>
> /* ( 5 revisions for files) */
>
> /* revision 1 */
>
> ALTER TABLE `internalstockcatrole`
>   ADD CONSTRAINT `internalstockcatrole_ibfk_1` FOREIGN KEY (`categoryid`)
> REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `internalstockcatrole_ibfk_2` FOREIGN KEY (`secroleid`)
> REFERENCES `securityroles` (`secroleid`);
>   /* gs...@gm... revisado em 20140706 */
>   /* beg-rev1
>   ADD CONSTRAINT `internalstockcatrole_ibfk_3` FOREIGN KEY (`categoryid`)
> REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `internalstockcatrole_ibfk_4` FOREIGN KEY (`secroleid`)
> REFERENCES `securityroles` (`secroleid`);
>       end-rev1 */
>
> /* revision 2 */
>
> ALTER TABLE `stockitemproperties`
>   ADD CONSTRAINT `stockitemproperties_ibfk_1` FOREIGN KEY (`stockid`)
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_2` FOREIGN KEY (`stkcatpropid`)
> REFERENCES `stockcatproperties` (`stkcatpropid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev2
>   ADD CONSTRAINT `stockitemproperties_ibfk_3` FOREIGN KEY (`stockid`)
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_4` FOREIGN KEY (`stkcatpropid`)
> REFERENCES `stockcatproperties` (`stkcatpropid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_5` FOREIGN KEY (`stockid`)
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_6` FOREIGN KEY (`stkcatpropid`)
> REFERENCES `stockcatproperties` (`stkcatpropid`);
>       end-rev2 */
>
> /* revision 3 */
>
> ALTER TABLE `stockmovestaxes`
>   ADD CONSTRAINT `stockmovestaxes_ibfk_1` FOREIGN KEY (`taxauthid`)
> REFERENCES `taxauthorities` (`taxid`),
>   ADD CONSTRAINT `stockmovestaxes_ibfk_2` FOREIGN KEY (`stkmoveno`)
> REFERENCES `stockmoves` (`stkmoveno`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev3
>   ADD CONSTRAINT `stockmovestaxes_ibfk_3` FOREIGN KEY (`stkmoveno`)
> REFERENCES `stockmoves` (`stkmoveno`),
>   ADD CONSTRAINT `stockmovestaxes_ibfk_4` FOREIGN KEY (`stkmoveno`)
> REFERENCES `stockmoves` (`stkmoveno`);
>      end-rev3 */
>
> /* revision 4 */
>
> ALTER TABLE `stockrequest`
>   ADD CONSTRAINT `stockrequest_ibfk_1` FOREIGN KEY (`loccode`) REFERENCES
> `locations` (`loccode`),
>   ADD CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`)
> REFERENCES `departments` (`departmentid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev4
>   ADD CONSTRAINT `stockrequest_ibfk_3` FOREIGN KEY (`loccode`) REFERENCES
> `locations` (`loccode`),
>   ADD CONSTRAINT `stockrequest_ibfk_4` FOREIGN KEY (`departmentid`)
> REFERENCES `departments` (`departmentid`);
>      end-rev4 */
>
> /* revision 5 */
>
> ALTER TABLE `stockrequestitems`
>   ADD CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`)
> REFERENCES `stockrequest` (`dispatchid`),
>   ADD CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`)
> REFERENCES `stockmaster` (`stockid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev5
>   ADD CONSTRAINT `stockrequestitems_ibfk_3` FOREIGN KEY (`dispatchid`)
> REFERENCES `stockrequest` (`dispatchid`),
>   ADD CONSTRAINT `stockrequestitems_ibfk_4` FOREIGN KEY (`stockid`)
> REFERENCES `stockmaster` (`stockid`);
>      end-rev5 */
>
> I have create a file for this on [1] .
>
>  Thanks
>
> [1] http://pastebin.com/CFgbZfBn
>
> --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awardshttp://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> 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] revision for weberp 4-11-3 constraints duplicated

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

I have committed this.

I wonder how this happens though as the script is dumped from mysql so 
perhaps a bug with mysqldump?

Thanks Gilberto :-)

Phil

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

On 07/07/14 07:49, gilberto dos santos alves wrote:
> Hi. Please could some one revise files default.sql, demo.sql and 
> weberpchina.sql for constraints that are duplicated for these 5 tables?
>
> /* ( 5 revisions for files) */
>
> /* revision 1 */
>
> ALTER TABLE `internalstockcatrole`
>   ADD CONSTRAINT `internalstockcatrole_ibfk_1` FOREIGN KEY 
> (`categoryid`) REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `internalstockcatrole_ibfk_2` FOREIGN KEY 
> (`secroleid`) REFERENCES `securityroles` (`secroleid`);
>   /* gs...@gm... <mailto:gs...@gm...> revisado em 20140706 */
>   /* beg-rev1
>   ADD CONSTRAINT `internalstockcatrole_ibfk_3` FOREIGN KEY 
> (`categoryid`) REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `internalstockcatrole_ibfk_4` FOREIGN KEY 
> (`secroleid`) REFERENCES `securityroles` (`secroleid`);
>       end-rev1 */
>
> /* revision 2 */
>
> ALTER TABLE `stockitemproperties`
>   ADD CONSTRAINT `stockitemproperties_ibfk_1` FOREIGN KEY (`stockid`) 
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_2` FOREIGN KEY 
> (`stkcatpropid`) REFERENCES `stockcatproperties` (`stkcatpropid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev2
>   ADD CONSTRAINT `stockitemproperties_ibfk_3` FOREIGN KEY (`stockid`) 
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_4` FOREIGN KEY 
> (`stkcatpropid`) REFERENCES `stockcatproperties` (`stkcatpropid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_5` FOREIGN KEY (`stockid`) 
> REFERENCES `stockmaster` (`stockid`),
>   ADD CONSTRAINT `stockitemproperties_ibfk_6` FOREIGN KEY 
> (`stkcatpropid`) REFERENCES `stockcatproperties` (`stkcatpropid`);
>       end-rev2 */
>
> /* revision 3 */
>
> ALTER TABLE `stockmovestaxes`
>   ADD CONSTRAINT `stockmovestaxes_ibfk_1` FOREIGN KEY (`taxauthid`) 
> REFERENCES `taxauthorities` (`taxid`),
>   ADD CONSTRAINT `stockmovestaxes_ibfk_2` FOREIGN KEY (`stkmoveno`) 
> REFERENCES `stockmoves` (`stkmoveno`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev3
>   ADD CONSTRAINT `stockmovestaxes_ibfk_3` FOREIGN KEY (`stkmoveno`) 
> REFERENCES `stockmoves` (`stkmoveno`),
>   ADD CONSTRAINT `stockmovestaxes_ibfk_4` FOREIGN KEY (`stkmoveno`) 
> REFERENCES `stockmoves` (`stkmoveno`);
>      end-rev3 */
>
> /* revision 4 */
>
> ALTER TABLE `stockrequest`
>   ADD CONSTRAINT `stockrequest_ibfk_1` FOREIGN KEY (`loccode`) 
> REFERENCES `locations` (`loccode`),
>   ADD CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`) 
> REFERENCES `departments` (`departmentid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev4
>   ADD CONSTRAINT `stockrequest_ibfk_3` FOREIGN KEY (`loccode`) 
> REFERENCES `locations` (`loccode`),
>   ADD CONSTRAINT `stockrequest_ibfk_4` FOREIGN KEY (`departmentid`) 
> REFERENCES `departments` (`departmentid`);
>      end-rev4 */
>
> /* revision 5 */
>
> ALTER TABLE `stockrequestitems`
>   ADD CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`) 
> REFERENCES `stockrequest` (`dispatchid`),
>   ADD CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`) 
> REFERENCES `stockmaster` (`stockid`),
>   /* gsavix@gmail 20140706 */
>   /* beg-rev5
>   ADD CONSTRAINT `stockrequestitems_ibfk_3` FOREIGN KEY (`dispatchid`) 
> REFERENCES `stockrequest` (`dispatchid`),
>   ADD CONSTRAINT `stockrequestitems_ibfk_4` FOREIGN KEY (`stockid`) 
> REFERENCES `stockmaster` (`stockid`);
>      end-rev5 */
>
> I have create a file for this on [1] .
>
> Thanks
>
> [1] http://pastebin.com/CFgbZfBn
>
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] revision for weberp 4-11-3 constraints duplicated

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

Hi. Please could some one revise files default.sql, demo.sql and
weberpchina.sql for constraints that are duplicated for these 5 tables?

/* ( 5 revisions for files) */

/* revision 1 */

ALTER TABLE `internalstockcatrole`
  ADD CONSTRAINT `internalstockcatrole_ibfk_1` FOREIGN KEY (`categoryid`)
REFERENCES `stockcategory` (`categoryid`),
  ADD CONSTRAINT `internalstockcatrole_ibfk_2` FOREIGN KEY (`secroleid`)
REFERENCES `securityroles` (`secroleid`);
  /* gs...@gm... revisado em 20140706 */
  /* beg-rev1
  ADD CONSTRAINT `internalstockcatrole_ibfk_3` FOREIGN KEY (`categoryid`)
REFERENCES `stockcategory` (`categoryid`),
  ADD CONSTRAINT `internalstockcatrole_ibfk_4` FOREIGN KEY (`secroleid`)
REFERENCES `securityroles` (`secroleid`);
      end-rev1 */

/* revision 2 */

ALTER TABLE `stockitemproperties`
  ADD CONSTRAINT `stockitemproperties_ibfk_1` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_2` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev2
  ADD CONSTRAINT `stockitemproperties_ibfk_3` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_4` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_5` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_6` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`);
      end-rev2 */

/* revision 3 */

ALTER TABLE `stockmovestaxes`
  ADD CONSTRAINT `stockmovestaxes_ibfk_1` FOREIGN KEY (`taxauthid`)
REFERENCES `taxauthorities` (`taxid`),
  ADD CONSTRAINT `stockmovestaxes_ibfk_2` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`),
  /* gsavix@gmail 20140706 */
  /* beg-rev3
  ADD CONSTRAINT `stockmovestaxes_ibfk_3` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`),
  ADD CONSTRAINT `stockmovestaxes_ibfk_4` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`);
     end-rev3 */

/* revision 4 */

ALTER TABLE `stockrequest`
  ADD CONSTRAINT `stockrequest_ibfk_1` FOREIGN KEY (`loccode`) REFERENCES
`locations` (`loccode`),
  ADD CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`)
REFERENCES `departments` (`departmentid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev4
  ADD CONSTRAINT `stockrequest_ibfk_3` FOREIGN KEY (`loccode`) REFERENCES
`locations` (`loccode`),
  ADD CONSTRAINT `stockrequest_ibfk_4` FOREIGN KEY (`departmentid`)
REFERENCES `departments` (`departmentid`);
     end-rev4 */

/* revision 5 */

ALTER TABLE `stockrequestitems`
  ADD CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`)
REFERENCES `stockrequest` (`dispatchid`),
  ADD CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev5
  ADD CONSTRAINT `stockrequestitems_ibfk_3` FOREIGN KEY (`dispatchid`)
REFERENCES `stockrequest` (`dispatchid`),
  ADD CONSTRAINT `stockrequestitems_ibfk_4` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`);
     end-rev5 */

I have create a file for this on [1] .

Thanks

[1] http://pastebin.com/CFgbZfBn

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

Re: [WebERP-developers] Creating New Company

[Eric P. <ec...@gm...>]

Unsubscribe


On Sat, Jul 5, 2014 at 10:54 AM, Phil Daintree <ph...@lo...>
wrote:

> You need to edit config.php to add appropriate entries to select the new
> company.
> You can also remove the entry for the existing deleted company too:
> You need a line like below for each company you wish to be able to select
>
> //Installed companies
> $CompanyList[0] = array('database'=>'weberpdemo' ,'company'=>'WebERP
> Demo Company' );
> $CompanyList[1] = array('database'=>'yourcoydatabasename'
> ,'company'=>'Your Company PLC' );
>
> Phil
>   Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 03/07/14 03:16, bukola wrote:
> > Hello,
> >
> > I created a New Company on my weberp, I later deleted the company name
> from
> > phpMyAdmin.
> >
> > When i attempt to log in, the deleted company still appears on the
> company
> > name field of the company drop down.
> >
> > Also, I attempted creating a new company and i get this error: You have
> an
> > error in your SQL syntax; check the manual that corresponds to your
> MariaDB
> > server version for the right syntax to use near 'company' at line 1.
> >
> > Kindly assist.
> >
> > Thanks
> >
> >
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Creating New Company

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

You need to edit config.php to add appropriate entries to select the new 
company.
You can also remove the entry for the existing deleted company too:
You need a line like below for each company you wish to be able to select

//Installed companies
$CompanyList[0] = array('database'=>'weberpdemo' ,'company'=>'WebERP 
Demo Company' );
$CompanyList[1] = array('database'=>'yourcoydatabasename' 
,'company'=>'Your Company PLC' );

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

On 03/07/14 03:16, bukola wrote:
> Hello,
>
> I created a New Company on my weberp, I later deleted the company name from
> phpMyAdmin.
>
> When i attempt to log in, the deleted company still appears on the company
> name field of the company drop down.
>
> Also, I attempted creating a new company and i get this error: You have an
> error in your SQL syntax; check the manual that corresponds to your MariaDB
> server version for the right syntax to use near 'company' at line 1.
>
> Kindly assist.
>
> Thanks
>
>

Re: [WebERP-developers] Creating New Company

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

To remove the company you should remove the sub directory under 
companies for
that database, and also remove the line referring to it at the bottom of the
config.php file (if there is one it depends on your version).

Thanks
Tim

[WebERP-developers] Creating New Company

[bukola <buk...@gm...>]

Hello,

I created a New Company on my weberp, I later deleted the company name from
phpMyAdmin.

When i attempt to log in, the deleted company still appears on the company
name field of the company drop down.

Also, I attempted creating a new company and i get this error: You have an
error in your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near 'company' at line 1.

Kindly assist.

Thanks



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Creating-New-Company-tp4657534.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Location constraint

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

*Dear all,*

           Thank you for your long time nice support!

           Recently, I face some problem about the location (warehouse)
constraint in webERP.  The main problem seems come from delivery
confirmation. 
          There are some situation that delivery are not sure during sales
orders creation. But the Confirm_delivery feature get the location data from
sales orders. Sometime we have to fulfill the same orders from different
locations. We have to create an work around for this situation now. 

          I've studied the stockmoves table and found it records the
locations data. Then is it a nice idea to make location selectable during we
confirm_delivery?  
          At the mean time, during place sales orders, the search result is
filtered by customer's default location, shall we make this configurable?

          Any comments are highly appreciated!

           Thanks and best regards!

           Exson

           



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

Re: [WebERP-developers] What's the real meaning of Ports?

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

*Hi, Phil,*

            I think the compromise way is to add the strpos() to the
original scripts. 

             if( mb_strpos() or strpos() ) {
             }  else{
             };

           I've test mb related function before and it seems there is some
uncertainty with them. This topic seems more complex then their looks.

           Best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/What-s-the-real-meaning-of-Ports-tp4657516p4657522.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] What's the real meaning of Ports?

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

Ah yes I see.... tricky! Not sure what the best solution is here - but 
it seems incorrect to be using the non- multi-byte character functions 
when we are using multi-byte character set.

Phil

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

On 13/06/14 11:46, ExsonQu wrote:
> *Hi, Phil,*
>
>            Thank you for your ideas for this.
>             
>            It's sure that your solution will fix the fields input with comma
> problem. I think the design for this consideration at least has one
> consideration is to separate number from text string.When the  fields
> content is quoted, it'll be handled as text string even it should be a
> number.
>
>            In excel or open office's data sheet, the number properties will
> lost due to this change.
>
>            Thanks and best regards!
>
>            Exson
>
>          
>             
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/What-s-the-real-meaning-of-Ports-tp4657516p4657520.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] What's the real meaning of Ports?

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

*Hi, Phil,*

          Thank you for your ideas for this. 
           
          It's sure that your solution will fix the fields input with comma
problem. I think the design for this consideration at least has one
consideration is to separate number from text string.When the  fields
content is quoted, it'll be handled as text string even it should be a
number. 

          In excel or open office's data sheet, the number properties will
lost due to this change. 

          Thanks and best regards!

          Exson

        
           



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/What-s-the-real-meaning-of-Ports-tp4657516p4657520.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] What's the real meaning of Ports?

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

Hi Exson,

I wondered why we don't just always enclose the output in quotes and why 
there needs to be a test to see if there is a comma in it at all. 
Couldn't we just always quote ... I'll commit this to see if it works 
for you?

Phil

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

On 12/06/14 14:06, ExsonQu wrote:
> *Hi, Phil,*
>
>           Thank you for your nice reply. I'll remove it later.
>
>           Thank you for reviewing my revision. For multi-byte character set,
> the comma is not coded in '44' as ASCII, at least in Chinese characters set.
> So it'll not destroy the delimiter function of csv files. The actual one
> make the delimiter failed is the ASCII coded 44, unfortunately, mb_strpos()
> failed to to sort it out. The strpos() does.
>          The solution at least work for Chinese characters.
>
>          If any mistake, please correct me!
>
>          Thanks and best regards!
>
>          Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/What-s-the-real-meaning-of-Ports-tp4657516p4657518.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] What's the real meaning of Ports?

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

*Hi, Phil,*

         Thank you for your nice reply. I'll remove it later.

         Thank you for reviewing my revision. For multi-byte character set,
the comma is not coded in '44' as ASCII, at least in Chinese characters set.
So it'll not destroy the delimiter function of csv files. The actual one
make the delimiter failed is the ASCII coded 44, unfortunately, mb_strpos()
failed to to sort it out. The strpos() does. 
        The solution at least work for Chinese characters. 

        If any mistake, please correct me!

        Thanks and best regards!

        Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/What-s-the-real-meaning-of-Ports-tp4657516p4657518.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.