invoice builder


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

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

test_accept_quantity_divergence_on_invoice_with_started_packing_list (only for sale, currently failing)
test_accept_quantity_divergence_on_invoice_with_stopped_packing_list (for sale and purchase)



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

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

Only update the stop date if we are on "started" state (the same script is called to go to delivered).
Fix a stupid mistake when checking if stop_date was given.

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

Add the possibility for use to define a stop payment lift date when requesting the lift (change workflow state change template, add setter call in workflow action script).
Dislay that date on the document after lift was requested.

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

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

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

modify assertions in content-disposition case because there are double quotations around the filename after r24942.


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

Modify assertions in test_getSingleCategoryAcquiredMembershipListOnParent because the expected return value of getSingleCategoryMembershipList() changes after r.22671.


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

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

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

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

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

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

Fix error on Container.getQuantity


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

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

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

add new form PageTemplate for Base_viewSearchResultList (Global Search) which avoid display of context_bar

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

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

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

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

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

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

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

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

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

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

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

Also, factorise code used to retrieve buildSQLQuery.


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

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

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

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

  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

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

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

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

*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

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

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