81 lines
2.7 KiB
Python
81 lines
2.7 KiB
Python
# -*- coding: utf-8 -*-
|
|
from openerp import http, SUPERUSER_ID
|
|
from openerp.http import request
|
|
|
|
from openerp.tools.translate import _
|
|
|
|
import logging
|
|
_logger = logging.getLogger(__name__)
|
|
|
|
class GroupeURD_CRM(http.Controller):
|
|
|
|
#Example: /crm/list_mailing_lists?db=groupeurd-openacademy
|
|
@http.route('/crm/list_mailing_lists', auth='public')
|
|
def view_mailing_lists(self, db):
|
|
http.request.session.db = db
|
|
http.request.cr.execute("""
|
|
select mmml.name as mailing_list, imd.module || '.' || imd.name as external_id
|
|
from ir_model_data imd
|
|
inner join mail_mass_mailing_list mmml on mmml.id = imd.res_id
|
|
where imd.model = 'mail.mass_mailing.list'
|
|
order by mmml.name;
|
|
""")
|
|
mailing_lists = http.request.cr.dictfetchall()
|
|
output = ""
|
|
for i, val in enumerate(mailing_lists):
|
|
output = output + val['mailing_list'] + "\t" + val['external_id'] + "\n"
|
|
return output
|
|
|
|
#Example: /crm/list_partner_categories?db=groupeurd-openacademy
|
|
@http.route('/crm/list_partner_categories', auth='public')
|
|
def view_partner_categories(self, db):
|
|
http.request.session.db = db
|
|
http.request.cr.execute("""
|
|
select rpc.name as category, imd.module || '.' || imd.name as external_id
|
|
from ir_model_data imd
|
|
inner join res_partner_category rpc on rpc.id = imd.res_id
|
|
where imd.model = 'res.partner.category'
|
|
order by rpc.name;
|
|
""")
|
|
partner_categories = http.request.cr.dictfetchall()
|
|
output = ""
|
|
for i, val in enumerate(partner_categories):
|
|
output = output + val['category'] + "\t" + val['external_id'] + "\n"
|
|
return output
|
|
|
|
|
|
#Example: /crm/list_partner_titles?db=groupeurd-openacademy
|
|
@http.route('/crm/list_partner_titles', auth='public')
|
|
def view_partner_titles(self, db):
|
|
http.request.session.db = db
|
|
http.request.cr.execute("""
|
|
select rpt.name as title, imd.module || '.' || imd.name as external_id
|
|
from ir_model_data imd
|
|
inner join res_partner_title rpt on rpt.id = imd.res_id
|
|
where imd.model = 'res.partner.title'
|
|
order by rpt.name;
|
|
""")
|
|
partner_titles = http.request.cr.dictfetchall()
|
|
output = ""
|
|
for i, val in enumerate(partner_titles):
|
|
output = output + val['title'] + "\t" + val['external_id'] + "\n"
|
|
return output
|
|
|
|
|
|
#Example: /crm/list_languagelist?db=groupeurd-openacademy
|
|
@http.route('/crm/list_languagelist', auth='public')
|
|
def view_languagelist(self, db):
|
|
http.request.session.db = db
|
|
http.request.cr.execute("""
|
|
select gcl.name as language, imd.module || '.' || imd.name as external_id
|
|
from ir_model_data imd
|
|
inner join groupeurd_crm_languagelist gcl on gcl.id = imd.res_id
|
|
where imd.model = 'groupeurd_crm.languagelist'
|
|
order by gcl.name;
|
|
""")
|
|
languagelist = http.request.cr.dictfetchall()
|
|
output = ""
|
|
for i, val in enumerate(languagelist):
|
|
output = output + val['language'] + "\t" + val['external_id'] + "\n"
|
|
return output
|