In its current implementation ( introduced in  4787eadd ), `variation_category` parameter of Inventory API require movements to be in the `predicate_category` table. The approach is to do a first query to get uids of all movements members of the variation and pass their `uid` to catalog. My guess is that this does not scale well. It also uses deprecated `where_expression` and generates invalid SQL when no movements match.

As far as I know, it is only used in [testInventory](https://lab.nexedi.com/nexedi/erp5/blob/ba541ad46e5c593f94fe1ebe79e99d67aafdecb1/product/ERP5/tests/testInventory.py#L1024). We could also consider dropping it, but keeping compatibility is easy.

This implementation just use `variation_text`.

[Test results](https://nexedi.erp5.net/test_result_module/20170502-1FDBAB66) are OK; there is one functional test failure but it really looks unrelated.

@yusei @vpelletier  @seb @romain do you see problems with this ?

/reviewed-on nexedi/erp5!265

Reuse code of delivery to ensure we can customize which item should be
in item table

This reverts commit 2ef67082

This allow customization, original init script is called by new script.

Performance is still not optimal, but should be better than before. At
least it does not assume that movements will be in predicate table.

- Use cloudooo instead of imagemagick
- Avoid to use (probably lossy) png format

_from_  _to_  ____id____  _______________module____________________  ______________comments_______________
pdf     bmp   pdf_to_bmp  erp5.component.document.TransformPdfToBmp  Previous: pdf-(imagemagick)->png->bmp

* acquire objectValues list method instead of using searchFolder
* acquire tales expression for selection name

this is an issue for layout of six-column grid since 16.667 * 6  > 100

/reviewed-on nexedi/erp5!279

this commit concern 3 bt5: erp5_officejs, erp5_officejs_ooffice, erp5_officejs_jquery_app

this patch concern 3 bt5: erp5_officejs, erp5_officejs_jquery_app, erp5_officejs_ooffice

and fix jslint issues.
this commit concern 3 bt5: erp5_officejs, erp5_officejs_jquery_appn erp5_officejs_ooffice

Disable matplotlib interactive mode to avoid "ValueError: ordinal must be >= 1" error that sometimes happens when plotting datetime index.

Do not put links when no valid link exists. This makes copying values much
easier.
Do provide links to activity context and method.
Also, do not use TALES when it is not needed.

svg
text/svg+xml

 text/html
+text/x-html-safe

adds:
ppty
xlsy
docy
application/x-asc-presentation
application/x-asc-spreadsheet
application/x-asc-text

image/bmp
image/gif
image/jpeg
image/png
image/tiff
image/tiff-fx
image/x-icon
image/x-xbm
image/x-xbitmap
image/webp

 bmp
 gif
 jpeg
 jpg
+jpe
+jif
+jfi
+jfif
 png
 tif
 tiff
+ico
+xbm
+webp

erp5_core was using Image portal type which is defined in erp5_base.

   ___from___  _to_  ________id_________  ____________________module___________________________  ______________comments______________
   *           bmp   image_to_bmp         Products.PortalTransforms.transforms.image_to_bmp
   *           gif   image_to_gif         Products.PortalTransforms.transforms.image_to_gif
   *           jpg   image_to_jpeg        Products.PortalTransforms.transforms.image_to_jpeg
   *           pcx   image_to_pcx         Products.PortalTransforms.transforms.image_to_pcx
   *           png   image_to_png         Products.PortalTransforms.transforms.image_to_png
   *           ppm   image_to_ppm         Products.PortalTransforms.transforms.image_to_ppm
   *           svg   image_to_svg         Products.PortalTransforms.transforms.image_to_svg
   *           tiff  image_to_tiff        Products.PortalTransforms.transforms.image_to_tiff
+  css         txt   css_to_text          Products.PortalTransforms.transforms.identity
   csv         txt   csv_to_text          Products.PortalTransforms.transforms.identity
+  doc         docx  doc_to_docx          erp5.component.document.TransformDocToDocx
-  doc         html  word_to_html         Products.PortalTransforms.transforms.word_to_html      binary `wvHtml` not in slapos
+  doc         html  doc_to_html          erp5.component.document.TransformDocToHtml
+  docx        docy  docx_to_docy         erp5.component.document.TransformDocxToDocy            docy is OnlyOffice Text Document
+  docx        odt   docx_to_odt          erp5.component.document.TransformDocxToOdt
+  docy        docx  docy_to_docx         erp5.component.document.TransformDocyToDocx
   html        html  html_body            Products.PortalTransforms.transforms.html_body
   html        html  safe_html            Products.PortalTransforms.transforms.safe_html
   html        html  text-pre_to_html     Products.PortalTransforms.transforms.text_pre_to_html
   html        odt   html_to_odt          Products.ERP5OOo.transforms.html_to_odt
   html        txt   html_to_text         Products.PortalTransforms.transforms.html_to_text
-  html        txt   lynx_dump            Products.PortalTransforms.transforms.lynx_dump         binary `lynx` not in erp5 SR
   html        txt   w3m_dump             Products.PortalTransforms.transforms.w3m_dump
+  js          txt   javascript_to_text   Products.PortalTransforms.transforms.identity
+  odp         html  odp_to_html          erp5.component.document.TransformOdpToHtml
+  odp         pdf   odp_to_pdf           erp5.component.document.TransformOdpToPdf
+  odp         pptx  odp_to_pptx          erp5.component.document.TransformOdpToPptx
+  odp         sxi   odp_to_sxi           erp5.component.document.TransformOdpToSxi
+  ods         html  ods_to_html          erp5.component.document.TransformOdsToHtml
+  ods         pdf   ods_to_pdf           erp5.component.document.TransformOdsToPdf
+  ods         xlsx  ods_to_xlsx          erp5.component.document.TransformOdsToXlsx
   odt         doc   odt_to_doc           Products.ERP5OOo.transforms.odt_to_doc
+  odt         docx  odt_to_docx          erp5.component.document.TransformOdtToDocx
+  odt         html  odt_to_html          erp5.component.document.TransformOdtToHtml
   odt         pdf   odt_to_pdf           Products.ERP5OOo.transforms.odt_to_pdf
   odt         xml   odt_to_xml           Products.ERP5OOo.transforms.odt_to_xml
   pdf         html  pdf_to_html          Products.PortalTransforms.transforms.pdf_to_html
   pdf         png   pdf_to_png           Products.PortalTransforms.transforms.pdf_to_png
   pdf         txt   pdf_to_text          Products.PortalTransforms.transforms.pdf_to_text
+  php         txt   php_to_text          Products.PortalTransforms.transforms.identity
-  png         txt   png_to_text          Products.PortalTransforms.transforms.png_to_text       binary `ocrocmd` not in slapos
+  ppt         pptx  ppt_to_pptx          erp5.component.document.TransformPptToPptx
+  pptx        odp   pptx_to_odp          erp5.component.document.TransformPptxToOdp
+  pptx        ppty  pptx_to_ppty         erp5.component.document.TransformPptxToPpty            ppty is OnlyOffice Presentation
+  ppty        pptx  ppty_to_pptx         erp5.component.document.TransformPptyToPptx
   py          html  python_to_html       Products.PortalTransforms.transforms.python
+  rss         txt   rss_to_text          Products.PortalTransforms.transforms.identity
   rst         html  rest_to_html         Products.PortalTransforms.transforms.rest
   rst         txt   rest_to_text         Products.PortalTransforms.transforms.identity
-  rst,js,css  txt   css_to_text          Products.PortalTransforms.transforms.identity
-  rst,js,css  txt   javascript_to_text   Products.PortalTransforms.transforms.identity
-  rtf         html  rtf_to_html          Products.PortalTransforms.transforms.rtf_to_html       binary `rtf-converter` not in slapos
-  rtf         xml   rtf_to_xml           Products.PortalTransforms.transforms.rtf_to_xml        binary `rtf2xml` not in slapos
   st          html  st_to_html           Products.PortalTransforms.transforms.st
+  sxi         html  sxi_to_html          erp5.component.document.TransformSxiToHtml
+  sxi         odp   sxi_to_odp           erp5.component.document.TransformSxiToOdp
-  tiff        txt   tiff_to_text         N/A                                                    Cannot find the entry definition...
+  tiff        txt   tiff_to_text         Products.PortalTransforms.transforms.tiff_to_text
   txt         html  text_to_html         Products.PortalTransforms.transforms.text_to_html
+  xls         ods   xls_to_ods           erp5.component.document.TransformXlsToOds
+  xls         xlsx  xls_to_xlsx          erp5.component.document.TransformXlsToXlsx
+  xlsx        ods   xlsx_to_ods          erp5.component.document.TransformXlsxToOds
+  xlsx        xlsy  xlsx_to_xlsy         erp5.component.document.TransformXlsxToXlsy            xlsy is OnlyOffice Spreadsheet
+  xlsy        xlsx  xlsy_to_xlsx         erp5.component.document.TransformXlsyToXlsx
   xml         txt   xml_to_text          Products.PortalTransforms.transforms.xml_to_text

added:
  id: Word 2007 document
    icon: docx.png
    binary: yes
    mimetypes: application/vnd.openxmlformats-officedocument.wordprocessingml.document
    extensions: docx
    globs: *.docx
  id: OnlyOffice Text Document
    icon: application.png
    binary: yes
    mimetypes: application/x-asc-text
    extensions: docy
    globs: *.docy
  id: OnlyOffice Spreadsheet
    icon: application.png
    binary: yes
    mimetypes: application/x-asc-spreadsheet
    extensions: xlsy
    globs: *.xlsy
  id: OnlyOffice Presentation
    icon: application.png
    binary: yes
    mimetypes: application/x-asc-presentation
    extensions: ppty
    globs: *.ppty