Thank you for your review, Guewen, I learned a few things. Diff comments:
> === added directory 'cmis_read' > === added file 'cmis_read/__init__.py' > --- cmis_read/__init__.py 1970-01-01 00:00:00 +0000 > +++ cmis_read/__init__.py 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,25 @@ > +# -*- encoding: utf-8 -*- > +############################################################################## > +# > +# OpenERP, Open Source Management Solution > +# This module copyright (C) 2014 Savoir-faire Linux > +# (<http://www.savoirfairelinux.com>). > +# > +# This program is free software: you can redistribute it and/or modify > +# it under the terms of the GNU Affero General Public License as > +# published by the Free Software Foundation, either version 3 of the > +# License, or (at your option) any later version. > +# > +# This program is distributed in the hope that it will be useful, > +# but WITHOUT ANY WARRANTY; without even the implied warranty of > +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the > +# GNU Affero General Public License for more details. > +# > +# You should have received a copy of the GNU Affero General Public License > +# along with this program. If not, see <http://www.gnu.org/licenses/>. > +# > +############################################################################## > + > +from . import wizard > + > +# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: > > === added file 'cmis_read/__openerp__.py' > --- cmis_read/__openerp__.py 1970-01-01 00:00:00 +0000 > +++ cmis_read/__openerp__.py 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,74 @@ > +# -*- encoding: utf-8 -*- > +############################################################################## > +# > +# OpenERP, Open Source Management Solution > +# This module copyright (C) 2014 Savoir-faire Linux > +# (<http://www.savoirfairelinux.com>). > +# > +# This program is free software: you can redistribute it and/or modify > +# it under the terms of the GNU Affero General Public License as > +# published by the Free Software Foundation, either version 3 of the > +# License, or (at your option) any later version. > +# > +# This program is distributed in the hope that it will be useful, > +# but WITHOUT ANY WARRANTY; without even the implied warranty of > +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the > +# GNU Affero General Public License for more details. > +# > +# You should have received a copy of the GNU Affero General Public License > +# along with this program. If not, see <http://www.gnu.org/licenses/>. > +# > +############################################################################## > + > +{ > + 'name': 'CMIS Read', > + 'version': '0.1', > + 'category': 'Knowledge Management', > + 'summary': 'Store Document File in a Remote CMIS Server', > + 'description': """ > +This module allows you to use the CMIS backend to search in the DMS > repository > +and attach documents to OpenERP records. > + > +Configuration > +============= > + > +Create a new CMIS backend with the host, login and password. > + > +Usage > +===== > + > +* On one OpenERP record, click "Add from DMS". > +* Type your query and then click on "Search". > +* Filter your results if necessary > +* Select the documents you want to attach > +* Selected documents will be enqueued for importing > + > +Contributors > +------------ > +* El Hadji Dem ([email protected]) > +""", > + 'author': 'Savoir-faire Linux', > + 'website': 'www.savoirfairelinux.com', > + 'license': 'AGPL-3', > + 'depends': [ > + 'document', > + 'cmis' > + ], > + 'data': [ > + 'security/ir.model.access.csv', > + 'wizard/document_wizard_view.xml', > + ], > + 'js': [ > + 'static/src/js/document.js' > + ], > + 'qweb': [ > + 'static/src/xml/document.xml' > + ], > + 'test': [], > + 'demo': [ > + ], > + 'installable': True, > + 'auto_install': False, > +} > + > +# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: > > === added directory 'cmis_read/i18n' > === added file 'cmis_read/i18n/cmis_read.pot' > --- cmis_read/i18n/cmis_read.pot 1970-01-01 00:00:00 +0000 > +++ cmis_read/i18n/cmis_read.pot 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,119 @@ > +# Translation of OpenERP Server. > +# This file contains the translation of the following modules: > +# * cmis_read > +# > +msgid "" > +msgstr "" > +"Project-Id-Version: OpenERP Server 7.0\n" > +"Report-Msgid-Bugs-To: \n" > +"POT-Creation-Date: 2014-03-21 14:55+0000\n" > +"PO-Revision-Date: 2014-03-21 10:55-0500\n" > +"Last-Translator: EL Hadji DEM <[email protected]>\n" > +"Language-Team: \n" > +"MIME-Version: 1.0\n" > +"Content-Type: text/plain; charset=UTF-8\n" > +"Content-Transfer-Encoding: 8bit\n" > +"Plural-Forms: \n" > +"X-Generator: Poedit 1.5.4\n" > + > +#. module: cmis_read > +#: field:ir.attachment.dms,file_id:0 > +msgid "File ID" > +msgstr "" > + > +#. module: cmis_read > +#: field:ir.attachment.dms.wizard,attachment_ids:0 > +msgid "Attachments" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "Search Document" > +msgstr "" > + > +#. module: cmis_read > +#: field:ir.attachment.dms,name:0 help:ir.attachment.dms,name:0 > +#: field:ir.attachment.dms.wizard,name:0 help:ir.attachment.dms.wizard,name:0 > +msgid "File name" > +msgstr "" > + > +#. module: cmis_read > +#: code:addons/cmis_read/wizard/document_wizard.py:59 > +#, python-format > +msgid "You have to fill in the file name. And try again" > +msgstr "" > + > +#. module: cmis_read > +#: help:ir.attachment.dms,file_id:0 > +msgid "File Id" > +msgstr "" > + > +#. module: cmis_read > +#: model:_description:0 model:ir.model,name:cmis_read.model_ir_attachment_dms > +msgid "ir.attachment.dms" > +msgstr "" > + > +#. module: cmis_read > +#: field:ir.attachment.dms,owner:0 help:ir.attachment.dms,owner:0 > +msgid "Owner" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "" > +"This action allows you to search by file name and to add the document you " > +"select" > +msgstr "" > + > +#. module: cmis_read > +#. openerp-web > +#: code:addons/cmis_read/static/src/js/document.js:26 > +#, python-format > +msgid "Search Document from DMS" > +msgstr "" > + > +#. module: cmis_read > +#. openerp-web > +#: code:addons/cmis_read/static/src/xml/document.xml:7 > +#, python-format > +msgid "Add Doc from DMS..." > +msgstr "" > + > +#. module: cmis_read > +#: code:addons/cmis_read/wizard/document_wizard.py:58 > +#: code:addons/cmis_read/wizard/document_wizard.py:86 > +#, python-format > +msgid "Error" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "Cancel" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "Apply" > +msgstr "" > + > +#. module: cmis_read > +#: model:_description:0 > +#: model:ir.model,name:cmis_read.model_ir_attachment_dms_wizard > +msgid "ir.attachment.dms.wizard" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "Search" > +msgstr "" > + > +#. module: cmis_read > +#: view:ir.attachment.dms.wizard:0 > +msgid "or" > +msgstr "" > + > +#. module: cmis_read > +#: code:addons/cmis_read/wizard/document_wizard.py:87 > +#, python-format > +msgid "You have to select at least 1 Document. And try again" > +msgstr "" > > === added directory 'cmis_read/security' > === added file 'cmis_read/security/ir.model.access.csv' > --- cmis_read/security/ir.model.access.csv 1970-01-01 00:00:00 +0000 > +++ cmis_read/security/ir.model.access.csv 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,2 @@ > +id,name,model_id:id,group_id:id,perm_read,perm_write,perm_create,perm_unlink > +access_ir_attachment_dms_wizard,access_ir_attachment_dms_wizard,model_ir_attachment_dms_wizard,base.group_document_user,1,1,1,1 > > === added directory 'cmis_read/static' > === added directory 'cmis_read/static/src' > === added directory 'cmis_read/static/src/js' > === added file 'cmis_read/static/src/js/document.js' > --- cmis_read/static/src/js/document.js 1970-01-01 00:00:00 +0000 > +++ cmis_read/static/src/js/document.js 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,44 @@ > +openerp.cmis_read = function(instance, m) { > +var _t = instance.web._t, > + QWeb = instance.web.qweb; > + > + instance.web.Sidebar.include({ > + redraw: function() { > + var self = this; > + this._super.apply(this, arguments); > + > self.$el.find('.oe_sidebar_add_attachment').after(QWeb.render('AddDocfromdms', > {widget: self})) > + self.$el.find('.oe_sidebar_add_dms_doc').on('click', function > (e) { > + self.on_cmis_doc(); > + }); > + }, > + on_cmis_doc: function(state) { > + var self = this; > + var view = self.getParent(); > + var ids = ( view.fields_view.type != "form" )? > view.groups.get_selection().ids : [ view.datarecord.id ]; > + var ds = new instance.web.DataSet(this, 'ir.attachment', > context); > + // you can pass in other data using the context dictionary > variable > + var context = { > + 'model': view.dataset.model, > + 'ids': ids, > + }; > + // the action dictionary variable sends data in the > "self.do_action" method > + var action = { > + name: _t("Search Document from DMS"), > + type: 'ir.actions.act_window', > + res_model: 'ir.attachment.dms.wizard', > + view_mode: 'form', > + view_type: 'form', > + views: [[false, 'form']], > + target: 'new', > + context: context, > + }; > + // self.do_action accepts the action parameter and opens the new > view > + self.do_action(action, { > + // refresh list of documents > + on_close: function () { > + self.do_attachement_update(self.dataset, self.model_id); > + } > + }); > + } > + }); > +}; > > === added directory 'cmis_read/static/src/xml' > === added file 'cmis_read/static/src/xml/document.xml' > --- cmis_read/static/src/xml/document.xml 1970-01-01 00:00:00 +0000 > +++ cmis_read/static/src/xml/document.xml 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,10 @@ > +<?xml version="1.0" encoding="UTF-8"?> > +<!-- vim:fdl=1: > +--> > +<templates id="template" xml:space="preserve"> > + > +<t t-name="AddDocfromdms"> > + <li class="oe_sidebar_add_dms_doc"><span><b>Add Doc from > DMS...</b></span></li> > +</t> > + > +</templates> > > === added directory 'cmis_read/wizard' > === added file 'cmis_read/wizard/__init__.py' > --- cmis_read/wizard/__init__.py 1970-01-01 00:00:00 +0000 > +++ cmis_read/wizard/__init__.py 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,25 @@ > +# -*- encoding: utf-8 -*- > +############################################################################## > +# > +# OpenERP, Open Source Management Solution > +# This module copyright (C) 2014 Savoir-faire Linux > +# (<http://www.savoirfairelinux.com>). > +# > +# This program is free software: you can redistribute it and/or modify > +# it under the terms of the GNU Affero General Public License as > +# published by the Free Software Foundation, either version 3 of the > +# License, or (at your option) any later version. > +# > +# This program is distributed in the hope that it will be useful, > +# but WITHOUT ANY WARRANTY; without even the implied warranty of > +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the > +# GNU Affero General Public License for more details. > +# > +# You should have received a copy of the GNU Affero General Public License > +# along with this program. If not, see <http://www.gnu.org/licenses/>. > +# > +############################################################################## > + > +from . import document_wizard > + > +# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: > > === added file 'cmis_read/wizard/document_wizard.py' > --- cmis_read/wizard/document_wizard.py 1970-01-01 00:00:00 +0000 > +++ cmis_read/wizard/document_wizard.py 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,184 @@ > +# -*- encoding: utf-8 -*- > +############################################################################## > +# > +# OpenERP, Open Source Management Solution > +# This module copyright (C) 2014 Savoir-faire Linux > +# (<http://www.savoirfairelinux.com>). > +# > +# This program is free software: you can redistribute it and/or modify > +# it under the terms of the GNU Affero General Public License as > +# published by the Free Software Foundation, either version 3 of the > +# License, or (at your option) any later version. > +# > +# This program is distributed in the hope that it will be useful, > +# but WITHOUT ANY WARRANTY; without even the implied warranty of > +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the > +# GNU Affero General Public License for more details. > +# > +# You should have received a copy of the GNU Affero General Public License > +# along with this program. If not, see <http://www.gnu.org/licenses/>. > +# > +############################################################################## > + > +from openerp.osv import orm, fields > +from openerp.tools.translate import _ > +from openerp.addons.connector.session import ConnectorSession > +from openerp.addons.connector.queue.job import job > +from openerp import SUPERUSER_ID > +import logging > +_logger = logging.getLogger(__name__) > + > + > +class ir_attachment_edm_wizard(orm.Model): > + _name = 'ir.attachment.dms.wizard' > + > + _columns = { > + 'name': fields.char('File name', size=150, help="File name"), > + 'attachment_ids': fields.one2many('ir.attachment.dms', > + 'wizard_id'), > + } > + > + # Search documents from dms. > + def search_doc(self, cr, uid, ids, context=None): > + if context is None: > + context = {} > + this = self.browse(cr, uid, ids, context=context)[0] > + data = self.read(cr, uid, ids, [], context=context)[0] > + if not data['name']: > + raise orm.except_orm(_('Error'), > + _('You have to fill in the file name.' + > + 'And try again')) > + if not hasattr(ids, '__iter__'): > + ids = [ids] > + session = ConnectorSession(cr, uid, context=context) > + file_name = data['name'] > + for backend_id in ids: > + search_doc_from_dms(session, 'ir.attachment', > + backend_id, file_name, this.id) > + return { > + 'type': 'ir.actions.act_window', > + 'res_model': 'ir.attachment.dms.wizard', > + 'view_mode': 'form', > + 'view_type': 'form', > + 'res_id': this.id, > + 'views': [(False, 'form')], > + 'target': 'new', > + } > + > + # Adding documents from Document Management (EDM) to OE. > + def action_apply(self, cr, uid, ids, context=None): > + ir_attachment_dms_obj = self.pool.get('ir.attachment.dms') Appending to that: Just in the case where 'ir.attachment.dms' is not in self.pool, it will raise a KeyError, while get will just return None and which will lead to errors later in the execution. > + if context is None: > + context = {} > + model = context['model'] > + res_id = context['ids'][0] > + ir_model_obj = self.pool.get(context['model']) > + name = ir_model_obj.browse(cr, uid, context['ids'], > + context=context)[0]['name'] > + data = self.read(cr, uid, ids, [], context=context)[0] > + > + if not hasattr(ids, '__iter__'): > + ids = [ids] > + session = ConnectorSession(cr, uid, context=context) > + # Just take the lines we select in the tree view > + selected_data = [one_attachment.id for one_attachment in > + ir_attachment_dms_obj.browse( > + cr, uid, data['attachment_ids'], context) > + if one_attachment.selectable_ok] > + data['attachment_ids'] = selected_data > + if not data['attachment_ids']: > + raise orm.except_orm(_('Error'), > + _('You have to select at least 1 Document.' > + Also, in English you shouldn't use numerals for a number under 10 and generally not under 20. > + 'And try again')) > + for backend_id in ids: > + # Create doc in OE from DMS. > + create_doc_from_dms.delay(session, 'ir.attachment', backend_id, > + data, name, model, res_id, uid) > + return {'type': 'ir.actions.act_window_close'} > + > + > +class ir_attachment_dms(orm.TransientModel): > + _name = 'ir.attachment.dms' > + > + _columns = { > + 'name': fields.char('File name', size=150, > + readonly=True, > + help="File name"), > + 'owner': fields.char('Owner', size=150, > + readonly=True, > + help="Owner"), > + 'file_id': fields.char('File ID', size=150, > + readonly=True, > + help="File Id"), > + 'wizard_id': fields.many2one('ir.attachment.dms.wizard', > + string='Wizard', > + required=True), > + 'selectable_ok': fields.boolean('Selected', help="Selected."), > + } > + > + > +def search_doc_from_dms(session, model_name, backend_id, file_name, > wizard_id): > + ir_attach_dms_obj = session.pool.get('ir.attachment.dms') > + cmis_backend_obj = session.pool.get('cmis.backend') > + if session.context is None: > + session.context = {} > + # login with the cmis account > + repo = cmis_backend_obj._auth(session.cr, session.uid, > + context=session.context) > + > + # Search name of doc and delete it if the document is already existed > + attachment_ids = ir_attach_dms_obj.search(session.cr, session.uid, []) > + ir_attach_dms_obj.unlink(session.cr, session.uid, > + attachment_ids, context=session.context) > + results = cmis_backend_obj.safe_query( > + "SELECT cmis:name, cmis:createdBy, cmis:objectId, " > + "cmis:contentStreamLength FROM cmis:document " > + "WHERE cmis:name LIKE '%%%s%%'", file_name, repo) > + for result in results: > + info = result.getProperties() > + if info['cmis:contentStreamLength'] != 0: > + data_attach = { > + 'name': info['cmis:name'], > + 'owner': info['cmis:createdBy'], > + 'file_id': info['cmis:objectId'], > + 'wizard_id': wizard_id, > + } > + ir_attach_dms_obj.create(session.cr, session.uid, data_attach, > + context=session.context) > + > + > +@job > +def create_doc_from_dms(session, model_name, backend_id, data, name, > + model, res_id, uid, filters=None): > + ir_attach_obj = session.pool.get('ir.attachment') > + ir_attach_dms_obj = session.pool.get('ir.attachment.dms') > + cmis_backend_obj = session.pool.get('cmis.backend') > + if session.context is None: > + session.context = {} > + # login with the cmis account > + repo = cmis_backend_obj._auth( > + session.cr, session.uid, context=session.context) > + for attach in ir_attach_dms_obj.browse(session.cr, session.uid, > + data['attachment_ids'], > + context=session.context): > + # Get results from id of document > + results = repo.query(" SELECT * FROM cmis:document WHERE \ > + cmis:objectId ='" + attach.file_id + "'") > + for result in results: > + info = result.getProperties() > + data_attach = { > + 'name': info['cmis:name'], > + 'description': info['cmis:description'], > + 'type': 'binary', > + 'datas': result.getContentStream().read().encode('base64'), > + 'res_model': model, > + 'res_name': name, > + 'res_id': res_id, > + 'user_id': uid, > + } > + session.context['bool_testdoc'] = True > + ir_attach_obj.create(session.cr, session.uid, > + data_attach, context=session.context) > + return True > + > +# vim:expandtab:smartindent:toabstop=4:softtabstop=4:shiftwidth=4: > > === added file 'cmis_read/wizard/document_wizard_view.xml' > --- cmis_read/wizard/document_wizard_view.xml 1970-01-01 00:00:00 +0000 > +++ cmis_read/wizard/document_wizard_view.xml 2014-06-12 19:57:17 +0000 > @@ -0,0 +1,47 @@ > +<?xml version="1.0"?> > +<openerp> > + <data> > + > + <!-- wizard view --> > + <record id="wizard_view" model="ir.ui.view"> > + <field name="name">Search Document</field> > + <field name="model">ir.attachment.dms.wizard</field> > + <field name="arch" type="xml"> > + <form string="Search Document" version="7.0"> > + <div> > + This action allows you to search by file name and to > add the document you select > + </div> > + <group> > + <div width="100%%"> > + <field name="name" width="70%%" class="oe_inline"/> > + <button name="search_doc" string="Search" > type="object" > + width="15%%" class="oe_inline oe_highlight" > /> > + </div> > + </group> > + <field name="attachment_ids"/> > + <footer> > + <button name="action_apply" string="Apply" > type="object" > + class="oe_highlight"/> > + or > + <button special="cancel" string="Cancel" type="object" > + class="oe_link"/> > + </footer> > + </form> > + </field> > + </record> > + > + > + <record id="wizard_attachment_tree_view" model="ir.ui.view"> > + <field name="name">Ir Attachment Dms</field> > + <field name="model">ir.attachment.dms</field> > + <field name="arch" type="xml"> > + <tree string="Attachment" editable="bottom" create="false" > delete="false"> > + <field name="selectable_ok"/> > + <field name="name"/> > + <field name="owner"/> > + </tree> > + </field> > + </record> > + > + </data> > +</openerp> > -- https://code.launchpad.net/~savoirfairelinux-openerp/knowledge-addons/cmis_read/+merge/212260 Your team Savoir-faire Linux' OpenERP is subscribed to branch lp:~savoirfairelinux-openerp/knowledge-addons/cmis_read. -- Mailing list: https://launchpad.net/~savoirfairelinux-openerp Post to : [email protected] Unsubscribe : https://launchpad.net/~savoirfairelinux-openerp More help : https://help.launchpad.net/ListHelp
