web-erp-developers

[WebERP-developers] Error on DeliveryDetails.php

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

Hi,

Someone has an idea of where to look for to correct this problem?


on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638


Error de Base de Datos 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 ')' at line 10

Fallo de SQL : El SQL que falló fue
SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost, fixedprice,
minimumchg FROM freightcosts WHERE locationfrom = 'CURRI' AND
destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination LIKE
'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR destination
LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%' OR
destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)

Regards, Rafael.

Re: [WebERP-developers] Error on DeliveryDetails.php

[Marcos G. T. <ad...@gm...>]

I don't know which version you have, but the last in the sourceforge, the
file includes/FreightCalculation.inc has the ofender code:
===========  CODE ==================
        // if there is some details of the address besides the country
        $sql .= " AND (";
        if ($BrAddCountry !=
$CountriesArray[$_SESSION['CountryOfOperation']]){
                    /* For international shipments empty destination (ANY)
is allowed */
                    $sql = $sql . " destination = '' OR";
                }
                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
            }

    $CalcFreightCostResult = DB_query($sql,$db);
=========== \CODE ===============

I guess a quick solution (but not the definitive) was to replace this part
by:
                // if there is some details of the address besides the
country
                $sql .= " AND (";
                $OR="";
                foreach ($FindCity as $City) {
                    $sql = $sql . $OR ." destination LIKE '" .
ucwords($City) . "%'";
                    $OR= " OR";
                }
                if ($BrAddCountry !=
$CountriesArray[$_SESSION['CountryOfOperation']]){
                    /* For international shipments empty destination (ANY)
is allowed */
                    $sql = $sql . $OR. " destination = ''";
                }
//                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
                $sql .=")";
            }

    $CalcFreightCostResult = DB_query($sql,$db);
================= /code =============
This form avoids the las " OR"  in the sql


2013/10/5 Rafael Chacón <raf...@gm...>

> Hi,
>
> Someone has an idea of where to look for to correct this problem?
>
>
> on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
>
>
> Error de Base de Datos 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 ')' at line 10
>
> Fallo de SQL : El SQL que falló fue
> SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
> fixedprice, minimumchg FROM freightcosts WHERE locationfrom = 'CURRI' AND
> destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
> destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination LIKE
> 'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
> destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR destination
> LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%' OR
> destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
> 'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)
>
> Regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
Ing Marcos R Garcia Trejo
(52) 9991-513412
Laboratorio de Ingeniería y Procesos Costeros (LIPC)
Unidad Académica Sisal, UNAM
MGa...@ii...
Tel 52 988 931 1000

Re: [WebERP-developers] Error on DeliveryDetails.php

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

Tim Schofield and Ing Marcos R Garcia Trejo:

Thanks for your help.


Web-erp-developers mailing list:

Now, I use webERP version 4.11.0; I updated to it last week-end. Previous
version was 4.10.0 and no similar problem was observed. My results:

1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the line
64 of includes/FreightCalculation.inc.

2. I added in table "freightcosts" a line with kgrate=0 for shipper "N/A"
("do not apply shipper"), and I got the same problem.

3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Service/Labour" items, and I got the same problem.

4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Service/Labour" items with Marcos Garcia Trejos' quick solution (but not
the definitive), and I got SUCCESS Report : Order Number 113 has been
entered.

5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick
solution (but not the definitive), and I got SUCCESS Report : Order Number
114 has been entered.

Regards,

Rafael Chacón
Verdorama


2013/10/5 Marcos Garcia Trejo <ad...@gm...>

> I don't know which version you have, but the last in the sourceforge, the
> file includes/FreightCalculation.inc has the ofender code:
> ===========  CODE ==================
>         // if there is some details of the address besides the country
>         $sql .= " AND (";
>         if ($BrAddCountry !=
> $CountriesArray[$_SESSION['CountryOfOperation']]){
>                     /* For international shipments empty destination (ANY)
> is allowed */
>                     $sql = $sql . " destination = '' OR";
>
>                 }
>                 $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>             }
>
>     $CalcFreightCostResult = DB_query($sql,$db);
> =========== \CODE ===============
>
> I guess a quick solution (but not the definitive) was to replace this part
> by:
>                 // if there is some details of the address besides the
> country
>                 $sql .= " AND (";
>                 $OR="";
>                 foreach ($FindCity as $City) {
>                     $sql = $sql . $OR ." destination LIKE '" .
> ucwords($City) . "%'";
>                     $OR= " OR";
>                 }
>                 if ($BrAddCountry !=
> $CountriesArray[$_SESSION['CountryOfOperation']]){
>                     /* For international shipments empty destination (ANY)
> is allowed */
>                     $sql = $sql . $OR. " destination = ''";
>                 }
> //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>                 $sql .=")";
>             }
>
>     $CalcFreightCostResult = DB_query($sql,$db);
> ================= /code =============
> This form avoids the las " OR"  in the sql
>
>
> 2013/10/5 Rafael Chacón <raf...@gm...>
>
>> Hi,
>>
>> Someone has an idea of where to look for to correct this problem?
>>
>>
>> on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
>>
>>
>> Error de Base de Datos 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 ')' at line 10
>>
>> Fallo de SQL : El SQL que falló fue
>> SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
>> fixedprice, minimumchg FROM freightcosts WHERE locationfrom = 'CURRI' AND
>> destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
>> destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination LIKE
>> 'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
>> destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR destination
>> LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%' OR
>> destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
>> 'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)
>>
>> Regards, Rafael.
>>
>>
>> ------------------------------------------------------------------------------
>> October Webinars: Code for Performance
>> Free Intel webinars can help you accelerate application performance.
>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>> from
>> the latest Intel processors and coprocessors. See abstracts and register >
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> --
> Ing Marcos R Garcia Trejo
> (52) 9991-513412
> Laboratorio de Ingeniería y Procesos Costeros (LIPC)
> Unidad Académica Sisal, UNAM
> MGa...@ii...
> Tel 52 988 931 1000
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Error on DeliveryDetails.php

[Marcos G. T. <ad...@gm...>]

Hi again,
I can't undersand the use of:  "$sql = mb_substr($sql, 0,
strrpos($sql,' OR')) . ')';"  in this part of the code, but I guess
the author want to cut the last "OR " generated and replace it with a
single ')'. Therefore, my code submitted works for this purpose, but
avoindig this code from the beginning.
If my observation is correct, I suggest that this "quick solution"
replaces the previous one.

Saludos cordiales. (greetings!)

2013/10/7, Rafael Chacón <raf...@gm...>:
> Tim Schofield and Ing Marcos R Garcia Trejo:
>
> Thanks for your help.
>
>
> Web-erp-developers mailing list:
>
> Now, I use webERP version 4.11.0; I updated to it last week-end. Previous
> version was 4.10.0 and no similar problem was observed. My results:
>
> 1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the line
> 64 of includes/FreightCalculation.inc.
>
> 2. I added in table "freightcosts" a line with kgrate=0 for shipper "N/A"
> ("do not apply shipper"), and I got the same problem.
>
> 3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> "Service/Labour" items, and I got the same problem.
>
> 4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> "Service/Labour" items with Marcos Garcia Trejos' quick solution (but not
> the definitive), and I got SUCCESS Report : Order Number 113 has been
> entered.
>
> 5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> "Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick
> solution (but not the definitive), and I got SUCCESS Report : Order Number
> 114 has been entered.
>
> Regards,
>
> Rafael Chacón
> Verdorama
>
>
> 2013/10/5 Marcos Garcia Trejo <ad...@gm...>
>
>> I don't know which version you have, but the last in the sourceforge, the
>> file includes/FreightCalculation.inc has the ofender code:
>> ===========  CODE ==================
>>         // if there is some details of the address besides the country
>>         $sql .= " AND (";
>>         if ($BrAddCountry !=
>> $CountriesArray[$_SESSION['CountryOfOperation']]){
>>                     /* For international shipments empty destination
>> (ANY)
>> is allowed */
>>                     $sql = $sql . " destination = '' OR";
>>
>>                 }
>>                 $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>>             }
>>
>>     $CalcFreightCostResult = DB_query($sql,$db);
>> =========== \CODE ===============
>>
>> I guess a quick solution (but not the definitive) was to replace this
>> part
>> by:
>>                 // if there is some details of the address besides the
>> country
>>                 $sql .= " AND (";
>>                 $OR="";
>>                 foreach ($FindCity as $City) {
>>                     $sql = $sql . $OR ." destination LIKE '" .
>> ucwords($City) . "%'";
>>                     $OR= " OR";
>>                 }
>>                 if ($BrAddCountry !=
>> $CountriesArray[$_SESSION['CountryOfOperation']]){
>>                     /* For international shipments empty destination
>> (ANY)
>> is allowed */
>>                     $sql = $sql . $OR. " destination = ''";
>>                 }
>> //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>>                 $sql .=")";
>>             }
>>
>>     $CalcFreightCostResult = DB_query($sql,$db);
>> ================= /code =============
>> This form avoids the las " OR"  in the sql
>>
>>
>> 2013/10/5 Rafael Chacón <raf...@gm...>
>>
>>> Hi,
>>>
>>> Someone has an idea of where to look for to correct this problem?
>>>
>>>
>>> on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
>>>
>>>
>>> Error de Base de Datos 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 ')' at line
>>> 10
>>>
>>> Fallo de SQL : El SQL que falló fue
>>> SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
>>> fixedprice, minimumchg FROM freightcosts WHERE locationfrom = 'CURRI'
>>> AND
>>> destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
>>> destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination
>>> LIKE
>>> 'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
>>> destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR
>>> destination
>>> LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%'
>>> OR
>>> destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
>>> 'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)
>>>
>>> Regards, Rafael.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> October Webinars: Code for Performance
>>> Free Intel webinars can help you accelerate application performance.
>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>>> from
>>> the latest Intel processors and coprocessors. See abstracts and register
>>> >
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> --
>> Ing Marcos R Garcia Trejo
>> (52) 9991-513412
>> Laboratorio de Ingeniería y Procesos Costeros (LIPC)
>> Unidad Académica Sisal, UNAM
>> MGa...@ii...
>> Tel 52 988 931 1000
>>
>>
>> ------------------------------------------------------------------------------
>> October Webinars: Code for Performance
>> Free Intel webinars can help you accelerate application performance.
>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>> from
>> the latest Intel processors and coprocessors. See abstracts and register
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>


-- 
Ing Marcos R Garcia Trejo
(52) 9991-513412
Laboratorio de Ingeniería y Procesos Costeros (LIPC)
Unidad Académica Sisal, UNAM
MGa...@ii...
Tel 52 988 931 1000

Re: [WebERP-developers] Error on DeliveryDetails.php

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"/>
 <style type="text/css">.mceResizeHandle {position: absolute;border: 1px solid black;background: #FFF;width: 5px;height: 5px;z-index: 10000}.mceResizeHandle:hover {background: #000}img[data-mce-selected] {outline: 1px solid black}img.mceClonedResizable, table.mceClonedResizable {position: absolute;outline: 1px dashed black;opacity: .5;z-index: 10000}

  </style></head><body style="">
 
  
 
 
  <div>
   Hi guys,
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   I think Marcos solution makes sense to me the extra OR on the end looks wrong - so some logic that truncates that.
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   $sql = mb_substr($sql, 0,&#160;strrpos($sql,&#39; OR&#39;)) . &#39;)&#39;;
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   should do it... but I have yet to look into this in detail.
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   I think what the code was trying to do was to look for all possible destinations in the freight costs table with any part of the city/suburb matching a freight cost record so it was parsing out all components and doing an &#34;OR&#34; on each bit.
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   Probably not such a helpful response I will try to get into this later on.
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   Phil
  </div> 
  <div>
   &#160;
  </div> 
  <div>
   &#62; On October 8, 2013 at 10:47 AM Marcos Garcia Trejo &#60;ad...@gm...&#62; wrote:
   <br/>&#62; 
   <br/>&#62; Hi again,
   <br/>&#62; I can&#39;t undersand the use of: &#34;$sql = mb_substr($sql, 0,
   <br/>&#62; strrpos($sql,&#39; OR&#39;)) . &#39;)&#39;;&#34; in this part of the code, but I guess
   <br/>&#62; the author want to cut the last &#34;OR &#34; generated and replace it with a
   <br/>&#62; single &#39;)&#39;. Therefore, my code submitted works for this purpose, but
   <br/>&#62; avoindig this code from the beginning.
   <br/>&#62; If my observation is correct, I suggest that this &#34;quick solution&#34;
   <br/>&#62; replaces the previous one.
   <br/>&#62; 
   <br/>&#62; Saludos cordiales. (greetings!)
   <br/>&#62; 
   <br/>&#62; 2013/10/7, Rafael Chac&#243;n &#60;raf...@gm...&#62;:
   <br/>&#62; &#62; Tim Schofield and Ing Marcos R Garcia Trejo:
   <br/>&#62; &#62;
   <br/>&#62; &#62; Thanks for your help.
   <br/>&#62; &#62;
   <br/>&#62; &#62;
   <br/>&#62; &#62; Web-erp-developers mailing list:
   <br/>&#62; &#62;
   <br/>&#62; &#62; Now, I use webERP version 4.11.0; I updated to it last week-end. Previous
   <br/>&#62; &#62; version was 4.10.0 and no similar problem was observed. My results:
   <br/>&#62; &#62;
   <br/>&#62; &#62; 1. Yes, &#34;$sql = mb_substr($sql, 0, strrpos($sql,&#39; OR&#39;)) . &#39;)&#39;;&#34; is the line
   <br/>&#62; &#62; 64 of includes/FreightCalculation.inc.
   <br/>&#62; &#62;
   <br/>&#62; &#62; 2. I added in table &#34;freightcosts&#34; a line with kgrate=0 for shipper &#34;N/A&#34;
   <br/>&#62; &#62; (&#34;do not apply shipper&#34;), and I got the same problem.
   <br/>&#62; &#62;
   <br/>&#62; &#62; 3. I tried to &#34;Place Order&#34; (.../weberp/DeliveryDetails.php) for
   <br/>&#62; &#62; &#34;Service/Labour&#34; items, and I got the same problem.
   <br/>&#62; &#62;
   <br/>&#62; &#62; 4. I tried to &#34;Place Order&#34; (.../weberp/DeliveryDetails.php) for
   <br/>&#62; &#62; &#34;Service/Labour&#34; items with Marcos Garcia Trejos&#39; quick solution (but not
   <br/>&#62; &#62; the definitive), and I got SUCCESS Report : Order Number 113 has been
   <br/>&#62; &#62; entered.
   <br/>&#62; &#62;
   <br/>&#62; &#62; 5. I tried to &#34;Place Order&#34; (.../weberp/DeliveryDetails.php) for
   <br/>&#62; &#62; &#34;Manufactured&#34; and &#34;Purchased&#34; items with Marcos Garcia Trejos&#39; quick
   <br/>&#62; &#62; solution (but not the definitive), and I got SUCCESS Report : Order Number
   <br/>&#62; &#62; 114 has been entered.
   <br/>&#62; &#62;
   <br/>&#62; &#62; Regards,
   <br/>&#62; &#62;
   <br/>&#62; &#62; Rafael Chac&#243;n
   <br/>&#62; &#62; Verdorama
   <br/>&#62; &#62;
   <br/>&#62; &#62;
   <br/>&#62; &#62; 2013/10/5 Marcos Garcia Trejo &#60;ad...@gm...&#62;
   <br/>&#62; &#62;
   <br/>&#62; &#62;&#62; I don&#39;t know which version you have, but the last in the sourceforge, the
   <br/>&#62; &#62;&#62; file includes/FreightCalculation.inc has the ofender code:
   <br/>&#62; &#62;&#62; =========== CODE ==================
   <br/>&#62; &#62;&#62; // if there is some details of the address besides the country
   <br/>&#62; &#62;&#62; $sql .= &#34; AND (&#34;;
   <br/>&#62; &#62;&#62; if ($BrAddCountry !=
   <br/>&#62; &#62;&#62; $CountriesArray[$_SESSION[&#39;CountryOfOperation&#39;]]){
   <br/>&#62; &#62;&#62; /* For international shipments empty destination
   <br/>&#62; &#62;&#62; (ANY)
   <br/>&#62; &#62;&#62; is allowed */
   <br/>&#62; &#62;&#62; $sql = $sql . &#34; destination = &#39;&#39; OR&#34;;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; }
   <br/>&#62; &#62;&#62; $sql = mb_substr($sql, 0, strrpos($sql,&#39; OR&#39;)) . &#39;)&#39;;
   <br/>&#62; &#62;&#62; }
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; $CalcFreightCostResult = DB_query($sql,$db);
   <br/>&#62; &#62;&#62; =========== \CODE ===============
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; I guess a quick solution (but not the definitive) was to replace this
   <br/>&#62; &#62;&#62; part
   <br/>&#62; &#62;&#62; by:
   <br/>&#62; &#62;&#62; // if there is some details of the address besides the
   <br/>&#62; &#62;&#62; country
   <br/>&#62; &#62;&#62; $sql .= &#34; AND (&#34;;
   <br/>&#62; &#62;&#62; $OR=&#34;&#34;;
   <br/>&#62; &#62;&#62; foreach ($FindCity as $City) {
   <br/>&#62; &#62;&#62; $sql = $sql . $OR .&#34; destination LIKE &#39;&#34; .
   <br/>&#62; &#62;&#62; ucwords($City) . &#34;%&#39;&#34;;
   <br/>&#62; &#62;&#62; $OR= &#34; OR&#34;;
   <br/>&#62; &#62;&#62; }
   <br/>&#62; &#62;&#62; if ($BrAddCountry !=
   <br/>&#62; &#62;&#62; $CountriesArray[$_SESSION[&#39;CountryOfOperation&#39;]]){
   <br/>&#62; &#62;&#62; /* For international shipments empty destination
   <br/>&#62; &#62;&#62; (ANY)
   <br/>&#62; &#62;&#62; is allowed */
   <br/>&#62; &#62;&#62; $sql = $sql . $OR. &#34; destination = &#39;&#39;&#34;;
   <br/>&#62; &#62;&#62; }
   <br/>&#62; &#62;&#62; // $sql = mb_substr($sql, 0, strrpos($sql,&#39; OR&#39;)) . &#39;)&#39;;
   <br/>&#62; &#62;&#62; $sql .=&#34;)&#34;;
   <br/>&#62; &#62;&#62; }
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; $CalcFreightCostResult = DB_query($sql,$db);
   <br/>&#62; &#62;&#62; ================= /code =============
   <br/>&#62; &#62;&#62; This form avoids the las &#34; OR&#34; in the sql
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; 2013/10/5 Rafael Chac&#243;n &#60;raf...@gm...&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62;&#62; Hi,
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; Someone has an idea of where to look for to correct this problem?
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; Error de Base de Datos 1064 :
   <br/>&#62; &#62;&#62;&#62; You have an error in your SQL syntax; check the manual that corresponds
   <br/>&#62; &#62;&#62;&#62; to your MySQL server version for the right syntax to use near &#39;)&#39; at line
   <br/>&#62; &#62;&#62;&#62; 10
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; Fallo de SQL : El SQL que fall&#243; fue
   <br/>&#62; &#62;&#62;&#62; SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
   <br/>&#62; &#62;&#62;&#62; fixedprice, minimumchg FROM freightcosts WHERE locationfrom = &#39;CURRI&#39;
   <br/>&#62; &#62;&#62;&#62; AND
   <br/>&#62; &#62;&#62;&#62; destinationcountry = &#39;Costa Rica&#39; AND maxkgs &#62; 4 AND maxcub &#62;0 AND (
   <br/>&#62; &#62;&#62;&#62; destination LIKE &#39;400m%&#39; OR destination LIKE &#39;Oeste%&#39; OR destination
   <br/>&#62; &#62;&#62;&#62; LIKE
   <br/>&#62; &#62;&#62;&#62; &#39;Y%&#39; OR destination LIKE &#39;400m%&#39; OR destination LIKE &#39;Norte%&#39; OR
   <br/>&#62; &#62;&#62;&#62; destination LIKE &#39;Urbanizaci&#243;n%&#39; OR destination LIKE &#39;La%&#39; OR
   <br/>&#62; &#62;&#62;&#62; destination
   <br/>&#62; &#62;&#62;&#62; LIKE &#39;Favorita%&#39; OR destination LIKE &#39;San%&#39; OR destination LIKE &#39;Jos&#233;,%&#39;
   <br/>&#62; &#62;&#62;&#62; OR
   <br/>&#62; &#62;&#62;&#62; destination LIKE &#39;San%&#39; OR destination LIKE &#39;Jos&#233;,%&#39; OR destination LIKE
   <br/>&#62; &#62;&#62;&#62; &#39;Pavas%&#39; OR destination LIKE &#39;10109%&#39; OR destination = &#39;&#39; OR)
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; Regards, Rafael.
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; ------------------------------------------------------------------------------
   <br/>&#62; &#62;&#62;&#62; October Webinars: Code for Performance
   <br/>&#62; &#62;&#62;&#62; Free Intel webinars can help you accelerate application performance.
   <br/>&#62; &#62;&#62;&#62; Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
   <br/>&#62; &#62;&#62;&#62; from
   <br/>&#62; &#62;&#62;&#62; the latest Intel processors and coprocessors. See abstracts and register
   <br/>&#62; &#62;&#62;&#62; &#62;
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62; http://pubads.g.doubleclick.net/gampad/clk?id=60134791&#38;iu=/4140/ostg.clktrk
   <br/>&#62; &#62;&#62;&#62; _______________________________________________
   <br/>&#62; &#62;&#62;&#62; Web-erp-developers mailing list
   <br/>&#62; &#62;&#62;&#62; Web...@li...
   <br/>&#62; &#62;&#62;&#62; https://lists.sourceforge.net/lists/listinfo/web-erp-developers
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; --
   <br/>&#62; &#62;&#62; Ing Marcos R Garcia Trejo
   <br/>&#62; &#62;&#62; (52) 9991-513412
   <br/>&#62; &#62;&#62; Laboratorio de Ingenier&#237;a y Procesos Costeros (LIPC)
   <br/>&#62; &#62;&#62; Unidad Acad&#233;mica Sisal, UNAM
   <br/>&#62; &#62;&#62; MGa...@ii...
   <br/>&#62; &#62;&#62; Tel 52 988 931 1000
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62; ------------------------------------------------------------------------------
   <br/>&#62; &#62;&#62; October Webinars: Code for Performance
   <br/>&#62; &#62;&#62; Free Intel webinars can help you accelerate application performance.
   <br/>&#62; &#62;&#62; Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
   <br/>&#62; &#62;&#62; from
   <br/>&#62; &#62;&#62; the latest Intel processors and coprocessors. See abstracts and register
   <br/>&#62; &#62;&#62; &#62;
   <br/>&#62; &#62;&#62; http://pubads.g.doubleclick.net/gampad/clk?id=60134791&#38;iu=/4140/ostg.clktrk
   <br/>&#62; &#62;&#62; _______________________________________________
   <br/>&#62; &#62;&#62; Web-erp-developers mailing list
   <br/>&#62; &#62;&#62; Web...@li...
   <br/>&#62; &#62;&#62; https://lists.sourceforge.net/lists/listinfo/web-erp-developers
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;&#62;
   <br/>&#62; &#62;
   <br/>&#62; 
   <br/>&#62; 
   <br/>&#62; -- 
   <br/>&#62; Ing Marcos R Garcia Trejo
   <br/>&#62; (52) 9991-513412
   <br/>&#62; Laboratorio de Ingenier&#237;a y Procesos Costeros (LIPC)
   <br/>&#62; Unidad Acad&#233;mica Sisal, UNAM
   <br/>&#62; MGa...@ii...
   <br/>&#62; Tel 52 988 931 1000
   <br/>&#62; 
   <br/>&#62; ------------------------------------------------------------------------------
   <br/>&#62; October Webinars: Code for Performance
   <br/>&#62; Free Intel webinars can help you accelerate application performance.
   <br/>&#62; Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
   <br/>&#62; the latest Intel processors and coprocessors. See abstracts and register &#62;
   <br/>&#62; http://pubads.g.doubleclick.net/gampad/clk?id=60134071&#38;iu=/4140/ostg.clktrk
   <br/>&#62; _______________________________________________
   <br/>&#62; Web-erp-developers mailing list
   <br/>&#62; Web...@li...
   <br/>&#62; https://lists.sourceforge.net/lists/listinfo/web-erp-developers
  </div> 
  <div id="ox-signature">
   Phil
   <br/>
   <br/>Ph: +64 (0)275 567890
   <br/>Skype: daintree
   <br/>http://www.logicworks.co.nz
  </div>
 
</body></html>

Re: [WebERP-developers] Error on DeliveryDetails.php

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

This is tricky....

I wonder if replacing the line 64 in includes/FreightCalculation.inc

with

$sql = mb_substr($sql, 0, mb_strrpos($sql,' OR')) . ')';

might do it..
this should lop off the trailing OR and append a closing bracket to the 
$sql string - we were mixing multi-byte and non-multibyte functions. I 
don't have data to test this on though so if you could perhaps echo the 
$sql to see what it is producing

Phil

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

On 08/10/13 04:05, Rafael Chacón wrote:
> Tim Schofield and Ing Marcos R Garcia Trejo:
>
> Thanks for your help.
>
>
> Web-erp-developers mailing list:
>
> Now, I use webERP version 4.11.0; I updated to it last week-end. 
> Previous version was 4.10.0 and no similar problem was observed. My 
> results:
>
> 1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the 
> line 64 of includes/FreightCalculation.inc.
>
> 2. I added in table "freightcosts" a line with kgrate=0 for shipper 
> "N/A" ("do not apply shipper"), and I got the same problem.
>
> 3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for 
> "Service/Labour" items, and I got the same problem.
>
> 4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for 
> "Service/Labour" items with Marcos Garcia Trejos' quick solution (but 
> not the definitive), and I got SUCCESS Report : Order Number 113 has 
> been entered.
>
> 5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for 
> "Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick 
> solution (but not the definitive), and I got SUCCESS Report : Order 
> Number 114 has been entered.
>
> Regards,
>
> Rafael Chacón
> Verdorama
>
>
> 2013/10/5 Marcos Garcia Trejo <ad...@gm... 
> <mailto:ad...@gm...>>
>
>     I don't know which version you have, but the last in the
>     sourceforge, the file includes/FreightCalculation.inc has the
>     ofender code:
>     ===========  CODE ==================
>             // if there is some details of the address besides the country
>             $sql .= " AND (";
>             if ($BrAddCountry !=
>     $CountriesArray[$_SESSION['CountryOfOperation']]){
>                         /* For international shipments empty
>     destination (ANY) is allowed */
>                         $sql = $sql . " destination = '' OR";
>
>                     }
>                     $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>                 }
>
>         $CalcFreightCostResult = DB_query($sql,$db);
>     =========== \CODE ===============
>
>     I guess a quick solution (but not the definitive) was to replace
>     this part by:
>                     // if there is some details of the address besides
>     the country
>                     $sql .= " AND (";
>                     $OR="";
>                     foreach ($FindCity as $City) {
>                         $sql = $sql . $OR ." destination LIKE '" .
>     ucwords($City) . "%'";
>                         $OR= " OR";
>                     }
>                     if ($BrAddCountry !=
>     $CountriesArray[$_SESSION['CountryOfOperation']]){
>                         /* For international shipments empty
>     destination (ANY) is allowed */
>                         $sql = $sql . $OR. " destination = ''";
>                     }
>     //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) .
>     ')';
>                     $sql .=")";
>                 }
>
>         $CalcFreightCostResult = DB_query($sql,$db);
>     ================= /code =============
>     This form avoids the las " OR"  in the sql
>
>
>     2013/10/5 Rafael Chacón <raf...@gm...
>     <mailto:raf...@gm...>>
>
>         Hi,
>
>         Someone has an idea of where to look for to correct this problem?
>
>
>         on:
>         http://www..../weberp/DeliveryDetails.php?identifier=1380990638
>
>
>         Error de Base de Datos 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 ')' at line 10
>
>         Fallo de SQL : El SQL que falló fue
>         SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS
>         cubcost, fixedprice, minimumchg FROM freightcosts WHERE
>         locationfrom = 'CURRI' AND destinationcountry = 'Costa Rica'
>         AND maxkgs > 4 AND maxcub >0 AND ( destination LIKE '400m%' OR
>         destination LIKE 'Oeste%' OR destination LIKE 'Y%' OR
>         destination LIKE '400m%' OR destination LIKE 'Norte%' OR
>         destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR
>         destination LIKE 'Favorita%' OR destination LIKE 'San%' OR
>         destination LIKE 'José,%' OR destination LIKE 'San%' OR
>         destination LIKE 'José,%' OR destination LIKE 'Pavas%' OR
>         destination LIKE '10109%' OR destination = '' OR)
>
>         Regards, Rafael.
>
>         ------------------------------------------------------------------------------
>         October Webinars: Code for Performance
>         Free Intel webinars can help you accelerate application
>         performance.
>         Explore tips for MPI, OpenMP, advanced profiling, and more.
>         Get the most from
>         the latest Intel processors and coprocessors. See abstracts
>         and register >
>         http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>         _______________________________________________
>         Web-erp-developers mailing list
>         Web...@li...
>         <mailto:Web...@li...>
>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>     -- 
>     Ing Marcos R Garcia Trejo
>     (52) 9991-513412
>     Laboratorio de Ingeniería y Procesos Costeros (LIPC)
>     Unidad Académica Sisal, UNAM
>     MGa...@ii... <mailto:MGa...@ii...>
>     Tel 52 988 931 1000
>
>     ------------------------------------------------------------------------------
>     October Webinars: Code for Performance
>     Free Intel webinars can help you accelerate application performance.
>     Explore tips for MPI, OpenMP, advanced profiling, and more. Get
>     the most from
>     the latest Intel processors and coprocessors. See abstracts and
>     register >
>     http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>     _______________________________________________
>     Web-erp-developers mailing list
>     Web...@li...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Error on DeliveryDetails.php

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

Hi Marcos,

Sorry for delay in looking into this one...

strrpos($sql,' OR')

finds the right most or last occurence in left to right languages of  ' 
OR' in the $sql string and returns the position as an index starting 
from 0 as the first character.

mb_substr($sql, 0, strrpos($sql,' OR'))

this returns the part of $sql from 0 to the point where ' OR' occurs in $sql

I think this code should work - but we are mixing multi-byte string 
functions with the single byte string functions and might be that we 
should be using the multi-byte function mb_strrpos rather than single 
byte function strrpos as utf-8 characters are a couple of bytes per 
character.

Phil

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

On 08/10/13 10:47, Marcos Garcia Trejo wrote:
> Hi again,
> I can't undersand the use of:  "$sql = mb_substr($sql, 0,
> strrpos($sql,' OR')) . ')';"  in this part of the code, but I guess
> the author want to cut the last "OR " generated and replace it with a
> single ')'. Therefore, my code submitted works for this purpose, but
> avoindig this code from the beginning.
> If my observation is correct, I suggest that this "quick solution"
> replaces the previous one.
>
> Saludos cordiales. (greetings!)
>
> 2013/10/7, Rafael Chacón <raf...@gm...>:
>> Tim Schofield and Ing Marcos R Garcia Trejo:
>>
>> Thanks for your help.
>>
>>
>> Web-erp-developers mailing list:
>>
>> Now, I use webERP version 4.11.0; I updated to it last week-end. Previous
>> version was 4.10.0 and no similar problem was observed. My results:
>>
>> 1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the line
>> 64 of includes/FreightCalculation.inc.
>>
>> 2. I added in table "freightcosts" a line with kgrate=0 for shipper "N/A"
>> ("do not apply shipper"), and I got the same problem.
>>
>> 3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
>> "Service/Labour" items, and I got the same problem.
>>
>> 4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
>> "Service/Labour" items with Marcos Garcia Trejos' quick solution (but not
>> the definitive), and I got SUCCESS Report : Order Number 113 has been
>> entered.
>>
>> 5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
>> "Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick
>> solution (but not the definitive), and I got SUCCESS Report : Order Number
>> 114 has been entered.
>>
>> Regards,
>>
>> Rafael Chacón
>> Verdorama
>>
>>
>> 2013/10/5 Marcos Garcia Trejo <ad...@gm...>
>>
>>> I don't know which version you have, but the last in the sourceforge, the
>>> file includes/FreightCalculation.inc has the ofender code:
>>> ===========  CODE ==================
>>>          // if there is some details of the address besides the country
>>>          $sql .= " AND (";
>>>          if ($BrAddCountry !=
>>> $CountriesArray[$_SESSION['CountryOfOperation']]){
>>>                      /* For international shipments empty destination
>>> (ANY)
>>> is allowed */
>>>                      $sql = $sql . " destination = '' OR";
>>>
>>>                  }
>>>                  $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>>>              }
>>>
>>>      $CalcFreightCostResult = DB_query($sql,$db);
>>> =========== \CODE ===============
>>>
>>> I guess a quick solution (but not the definitive) was to replace this
>>> part
>>> by:
>>>                  // if there is some details of the address besides the
>>> country
>>>                  $sql .= " AND (";
>>>                  $OR="";
>>>                  foreach ($FindCity as $City) {
>>>                      $sql = $sql . $OR ." destination LIKE '" .
>>> ucwords($City) . "%'";
>>>                      $OR= " OR";
>>>                  }
>>>                  if ($BrAddCountry !=
>>> $CountriesArray[$_SESSION['CountryOfOperation']]){
>>>                      /* For international shipments empty destination
>>> (ANY)
>>> is allowed */
>>>                      $sql = $sql . $OR. " destination = ''";
>>>                  }
>>> //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>>>                  $sql .=")";
>>>              }
>>>
>>>      $CalcFreightCostResult = DB_query($sql,$db);
>>> ================= /code =============
>>> This form avoids the las " OR"  in the sql
>>>
>>>
>>> 2013/10/5 Rafael Chacón <raf...@gm...>
>>>
>>>> Hi,
>>>>
>>>> Someone has an idea of where to look for to correct this problem?
>>>>
>>>>
>>>> on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
>>>>
>>>>
>>>> Error de Base de Datos 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 ')' at line
>>>> 10
>>>>
>>>> Fallo de SQL : El SQL que falló fue
>>>> SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
>>>> fixedprice, minimumchg FROM freightcosts WHERE locationfrom = 'CURRI'
>>>> AND
>>>> destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
>>>> destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination
>>>> LIKE
>>>> 'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
>>>> destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR
>>>> destination
>>>> LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%'
>>>> OR
>>>> destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
>>>> 'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)
>>>>
>>>> Regards, Rafael.
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> October Webinars: Code for Performance
>>>> Free Intel webinars can help you accelerate application performance.
>>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>>>> from
>>>> the latest Intel processors and coprocessors. See abstracts and register
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> Web-erp-developers mailing list
>>>> Web...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>
>>> --
>>> Ing Marcos R Garcia Trejo
>>> (52) 9991-513412
>>> Laboratorio de Ingeniería y Procesos Costeros (LIPC)
>>> Unidad Académica Sisal, UNAM
>>> MGa...@ii...
>>> Tel 52 988 931 1000
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> October Webinars: Code for Performance
>>> Free Intel webinars can help you accelerate application performance.
>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>>> from
>>> the latest Intel processors and coprocessors. See abstracts and register
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>

Re: [WebERP-developers] Error on DeliveryDetails.php

[Ricard A. <pak...@gm...>]

Hi all:
It was me who took over with this code, to make it work with the webSHOP.
Funny thing, I have revision 6111  working real on my websSHOP and seems to
work OK.
I will take a look ASAP.
Thanks for reporting

Regards,
Ricard


2013/10/9 Phil Daintree <ph...@lo...>

> Hi Marcos,
>
> Sorry for delay in looking into this one...
>
> strrpos($sql,' OR')
>
> finds the right most or last occurence in left to right languages of  '
> OR' in the $sql string and returns the position as an index starting
> from 0 as the first character.
>
> mb_substr($sql, 0, strrpos($sql,' OR'))
>
> this returns the part of $sql from 0 to the point where ' OR' occurs in
> $sql
>
> I think this code should work - but we are mixing multi-byte string
> functions with the single byte string functions and might be that we
> should be using the multi-byte function mb_strrpos rather than single
> byte function strrpos as utf-8 characters are a couple of bytes per
> character.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 08/10/13 10:47, Marcos Garcia Trejo wrote:
> > Hi again,
> > I can't undersand the use of:  "$sql = mb_substr($sql, 0,
> > strrpos($sql,' OR')) . ')';"  in this part of the code, but I guess
> > the author want to cut the last "OR " generated and replace it with a
> > single ')'. Therefore, my code submitted works for this purpose, but
> > avoindig this code from the beginning.
> > If my observation is correct, I suggest that this "quick solution"
> > replaces the previous one.
> >
> > Saludos cordiales. (greetings!)
> >
> > 2013/10/7, Rafael Chacón <raf...@gm...>:
> >> Tim Schofield and Ing Marcos R Garcia Trejo:
> >>
> >> Thanks for your help.
> >>
> >>
> >> Web-erp-developers mailing list:
> >>
> >> Now, I use webERP version 4.11.0; I updated to it last week-end.
> Previous
> >> version was 4.10.0 and no similar problem was observed. My results:
> >>
> >> 1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the
> line
> >> 64 of includes/FreightCalculation.inc.
> >>
> >> 2. I added in table "freightcosts" a line with kgrate=0 for shipper
> "N/A"
> >> ("do not apply shipper"), and I got the same problem.
> >>
> >> 3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> >> "Service/Labour" items, and I got the same problem.
> >>
> >> 4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> >> "Service/Labour" items with Marcos Garcia Trejos' quick solution (but
> not
> >> the definitive), and I got SUCCESS Report : Order Number 113 has been
> >> entered.
> >>
> >> 5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
> >> "Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick
> >> solution (but not the definitive), and I got SUCCESS Report : Order
> Number
> >> 114 has been entered.
> >>
> >> Regards,
> >>
> >> Rafael Chacón
> >> Verdorama
> >>
> >>
> >> 2013/10/5 Marcos Garcia Trejo <ad...@gm...>
> >>
> >>> I don't know which version you have, but the last in the sourceforge,
> the
> >>> file includes/FreightCalculation.inc has the ofender code:
> >>> ===========  CODE ==================
> >>>          // if there is some details of the address besides the country
> >>>          $sql .= " AND (";
> >>>          if ($BrAddCountry !=
> >>> $CountriesArray[$_SESSION['CountryOfOperation']]){
> >>>                      /* For international shipments empty destination
> >>> (ANY)
> >>> is allowed */
> >>>                      $sql = $sql . " destination = '' OR";
> >>>
> >>>                  }
> >>>                  $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
> >>>              }
> >>>
> >>>      $CalcFreightCostResult = DB_query($sql,$db);
> >>> =========== \CODE ===============
> >>>
> >>> I guess a quick solution (but not the definitive) was to replace this
> >>> part
> >>> by:
> >>>                  // if there is some details of the address besides the
> >>> country
> >>>                  $sql .= " AND (";
> >>>                  $OR="";
> >>>                  foreach ($FindCity as $City) {
> >>>                      $sql = $sql . $OR ." destination LIKE '" .
> >>> ucwords($City) . "%'";
> >>>                      $OR= " OR";
> >>>                  }
> >>>                  if ($BrAddCountry !=
> >>> $CountriesArray[$_SESSION['CountryOfOperation']]){
> >>>                      /* For international shipments empty destination
> >>> (ANY)
> >>> is allowed */
> >>>                      $sql = $sql . $OR. " destination = ''";
> >>>                  }
> >>> //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
> >>>                  $sql .=")";
> >>>              }
> >>>
> >>>      $CalcFreightCostResult = DB_query($sql,$db);
> >>> ================= /code =============
> >>> This form avoids the las " OR"  in the sql
> >>>
> >>>
> >>> 2013/10/5 Rafael Chacón <raf...@gm...>
> >>>
> >>>> Hi,
> >>>>
> >>>> Someone has an idea of where to look for to correct this problem?
> >>>>
> >>>>
> >>>> on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638
> >>>>
> >>>>
> >>>> Error de Base de Datos 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 ')' at
> line
> >>>> 10
> >>>>
> >>>> Fallo de SQL : El SQL que falló fue
> >>>> SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost,
> >>>> fixedprice, minimumchg FROM freightcosts WHERE locationfrom = 'CURRI'
> >>>> AND
> >>>> destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
> >>>> destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination
> >>>> LIKE
> >>>> 'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
> >>>> destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR
> >>>> destination
> >>>> LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE
> 'José,%'
> >>>> OR
> >>>> destination LIKE 'San%' OR destination LIKE 'José,%' OR destination
> LIKE
> >>>> 'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)
> >>>>
> >>>> Regards, Rafael.
> >>>>
> >>>>
> >>>>
> ------------------------------------------------------------------------------
> >>>> October Webinars: Code for Performance
> >>>> Free Intel webinars can help you accelerate application performance.
> >>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the
> most
> >>>> from
> >>>> the latest Intel processors and coprocessors. See abstracts and
> register
> >>>>
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> >>>> _______________________________________________
> >>>> Web-erp-developers mailing list
> >>>> Web...@li...
> >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>>>
> >>>>
> >>>
> >>> --
> >>> Ing Marcos R Garcia Trejo
> >>> (52) 9991-513412
> >>> Laboratorio de Ingeniería y Procesos Costeros (LIPC)
> >>> Unidad Académica Sisal, UNAM
> >>> MGa...@ii...
> >>> Tel 52 988 931 1000
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> October Webinars: Code for Performance
> >>> Free Intel webinars can help you accelerate application performance.
> >>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the
> most
> >>> from
> >>> the latest Intel processors and coprocessors. See abstracts and
> register
> >>>
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> >>> _______________________________________________
> >>> Web-erp-developers mailing list
> >>> Web...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>>
> >>>
> >
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>