Commits · d41301d0bd54d73844c02db596fdcfc535c14054 · preetwinder / erp5

19 Dec, 2008 11 commits

buildSQLQuery is expected to generate a join on catalog table... · d41301d0

Vincent Pelletier authored Dec 19, 2008

buildSQLQuery is expected to generate a join on catalog table (Delivery_zGetTotal uses catalog table but does not have it in its "from" expression).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24953 20353a03-c40f-0410-a6d1-a30d3c3de9de

d41301d0

output more info when invoice is divergent · b3d8eb67

Jérome Perrin authored Dec 19, 2008


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24952 20353a03-c40f-0410-a6d1-a30d3c3de9de

b3d8eb67

Reapply 24945 commit intent, but with working code this time. · c2b505cf
Vincent Pelletier authored Dec 19, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24951 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
c2b505cf

use delivery table instead of movement table here, otherwise transactions... · 4dd83049

Jérome Perrin authored Dec 19, 2008

use delivery table instead of movement table here, otherwise transactions without lines cannot be searched by date.
remove a very outdated FIXME comment

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24950 20353a03-c40f-0410-a6d1-a30d3c3de9de

4dd83049

don't use low level Query.__call__ , use portal_catalog.buildSQLQuery instead · 5492d56a
Jérome Perrin authored Dec 19, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24949 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
5492d56a
test searching by date on the accounting transaction search dialog · 9a14f67f
Jérome Perrin authored Dec 19, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24948 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
9a14f67f

Apply a change similar with 24944: use buildSQLQuery. · 4af43165

Vincent Pelletier authored Dec 19, 2008

Also, factorise code used to retrieve buildSQLQuery.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24947 20353a03-c40f-0410-a6d1-a30d3c3de9de

4af43165

Revert commit r24945: for strange reasons, it breaks. · 58ada0e6
Vincent Pelletier authored Dec 19, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24946 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
58ada0e6

Use a dict-type value instead of manually rendering time as a string (the only... · 4f15f882

Vincent Pelletier authored Dec 19, 2008

Use a dict-type value instead of manually rendering time as a string (the only purpose was to prepend a comparison operator).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24945 20353a03-c40f-0410-a6d1-a30d3c3de9de

4f15f882

Instead of building by hand a query and calling it, it's simpler to use... · 8ffb3416

Vincent Pelletier authored Dec 19, 2008

Instead of building by hand a query and calling it, it's simpler to use buildSQLQuery while making sure that it won't join with any table.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24944 20353a03-c40f-0410-a6d1-a30d3c3de9de

8ffb3416

When query_table was explicitely given a None value, prevent joins from happening. · 7c0aee92

Vincent Pelletier authored Dec 19, 2008

  Other uses in that function are None-safe:
   - first use checks that query_table exavuates to True before using
   - (this fix applied to the second use)
   - third use is to provide related keys with a query_tabe parameter. So when using a related key it is either meaningless (if related key ignores that parameter, it means that it hadcodes its "source" table) or fixable (by making related key handle a None query_table nicely, if not already the case).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24943 20353a03-c40f-0410-a6d1-a30d3c3de9de

7c0aee92

18 Dec, 2008 7 commits

content disposition needs "" arround filename to support spaces in the filename · a9675974
Jérome Perrin authored Dec 18, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24942 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
a9675974

add test not to display positive and negative stock, or positive and zero... · fec4f962

Mame Coumba Sall authored Dec 18, 2008

add test not to display positive and negative stock, or positive and zero stock, or negative and zero stock

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24941 20353a03-c40f-0410-a6d1-a30d3c3de9de

fec4f962

Use a better sql escaping method. · 4a5029f0

Vincent Pelletier authored Dec 18, 2008


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24940 20353a03-c40f-0410-a6d1-a30d3c3de9de

4a5029f0

2008-12-18 mame · 57a2077c

Mame Coumba Sall authored Dec 18, 2008

*modify script so that report can hide positive and negative stock at the same time, or positive and zero stock or negative and zero stock

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24939 20353a03-c40f-0410-a6d1-a30d3c3de9de

57a2077c

Woops, accidentaly commented out line in previous commit. Partialy revert it. · 86952248
Vincent Pelletier authored Dec 18, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24938 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
86952248

Add a method to escape SQL. · 5c3a951c

Vincent Pelletier authored Dec 18, 2008


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24937 20353a03-c40f-0410-a6d1-a30d3c3de9de

5c3a951c

Another type mistake: this returns a dict, so use .copy(). · 59a07ca1
Vincent Pelletier authored Dec 18, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24936 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
59a07ca1

17 Dec, 2008 22 commits

add test not to display positive,negative or zero stock · 0ed8ae63
Mame Coumba Sall authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24935 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
0ed8ae63

Hardcode orber-by when sorting on translation title. · a5c2dddb

Vincent Pelletier authored Dec 17, 2008

As column alias is also hardcoded in subquery's select, it will make the intent clearer.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24934 20353a03-c40f-0410-a6d1-a30d3c3de9de

a5c2dddb

2008/12/17 kazuhiko · 2f2c7e70

Kazuhiko Shiozaki authored Dec 17, 2008

* display a readonly textarea as a normal text block.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24933 20353a03-c40f-0410-a6d1-a30d3c3de9de

2f2c7e70

Do not rely on the current way of alias name generation. It should be enough... · b9ef1dfc

Vincent Pelletier authored Dec 17, 2008

Do not rely on the current way of alias name generation. It should be enough to check that expected column is present.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24932 20353a03-c40f-0410-a6d1-a30d3c3de9de

b9ef1dfc

define good listbox column titles, so that we don't need "user columns" in the chart · cefec7d4
Jérome Perrin authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24931 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
cefec7d4

don't translate column values · 559e4f0c

Jérome Perrin authored Dec 17, 2008

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24930 20353a03-c40f-0410-a6d1-a30d3c3de9de

559e4f0c

define different style macro for axis and legend, and use smaller font for axis · 5b82c7fd
Jérome Perrin authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24929 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
5b82c7fd

If "Data Color" is defined expliclty in the OOoChart configuration, it already... · aa28e8a7

Jérome Perrin authored Dec 17, 2008

If "Data Color" is defined expliclty in the OOoChart configuration, it already starts with "#", so we must handle it explicitly here

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24928 20353a03-c40f-0410-a6d1-a30d3c3de9de

aa28e8a7

fix previous commit, don't mask "render_prefix" if it's already defined in that scope · 8ceba789
Jérome Perrin authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24927 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
8ceba789

fix some proxyfield targets · 60be7ad4

Jérome Perrin authored Dec 17, 2008

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24926 20353a03-c40f-0410-a6d1-a30d3c3de9de

60be7ad4

Don't propose all organisations in inventory chart dialog, but only sections... · 4539c119

Jérome Perrin authored Dec 17, 2008

Don't propose all organisations in inventory chart dialog, but only sections that have been used in movements with this resources (calculated with getInventoryList)

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24925 20353a03-c40f-0410-a6d1-a30d3c3de9de

4539c119

define render prefix for form_view · 8157a820

Jérome Perrin authored Dec 17, 2008

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24924 20353a03-c40f-0410-a6d1-a30d3c3de9de

8157a820

add minimal tests to render an OOoChart in ODS and ODT style · 5c4572bf
Jérome Perrin authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24923 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
5c4572bf
Detect and report wrong hierarchy in category spreadsheet · 26fd2f9d
Jérome Perrin authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24922 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
26fd2f9d

tests that wrong hierarchy are detected · 151d30cb

Jérome Perrin authored Dec 17, 2008


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24921 20353a03-c40f-0410-a6d1-a30d3c3de9de

151d30cb

Woops, this method returns a list, not a dict. · ceab69ca

Vincent Pelletier authored Dec 17, 2008


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24920 20353a03-c40f-0410-a6d1-a30d3c3de9de

ceab69ca

2008-12-17 mame · 34ee2d50

Mame Coumba Sall authored Dec 17, 2008

* Modify script to not display stock of the resource when it's positive, negative or equal to zero

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24919 20353a03-c40f-0410-a6d1-a30d3c3de9de

34ee2d50

allow Day Movement Group content type in Delivery Builder · 24793288
Nicolas Delaby authored Dec 17, 2008
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24918 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
24793288

As we return cached version of those values, copy them upon return. This... · 6d8deafd

Vincent Pelletier authored Dec 17, 2008

As we return cached version of those values, copy them upon return. This prevents third-party code from "poisoning" the cache.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24917 20353a03-c40f-0410-a6d1-a30d3c3de9de

6d8deafd

2008-12-17 nicolas · 8747b3c5

Nicolas Delaby authored Dec 17, 2008

* add Day Movement Group portal_type

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24916 20353a03-c40f-0410-a6d1-a30d3c3de9de

8747b3c5

typo · 8b74bf6c

Nicolas Delaby authored Dec 17, 2008

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24915 20353a03-c40f-0410-a6d1-a30d3c3de9de

8b74bf6c

add Daily Movement Group · 777b070c

Nicolas Delaby authored Dec 17, 2008

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24914 20353a03-c40f-0410-a6d1-a30d3c3de9de

777b070c