Odoo 中文社区

billchen0769

2024-01-11 06:40:51,934 25272 WARNING owl_test odoo.addons.base.models.assetsbundle: Error: Undefined variable: "$o-community-color".
on line 28:23 of stdin

background-color: $o-community-color;

----------------------^
This error occurred while compiling the bundle 'web.assets_backend' containing:
- /basis_xlsx_report/static/src/css/ThemeSetting.scss
- /web/static/lib/bootstrap/scss/_functions.scss
- /web/static/lib/bootstrap/scss/_mixins.scss
- /web/static/src/scss/mixins_forwardport.scss
- /web/static/src/scss/bs_mixins_overrides.scss
- /web/static/src/legacy/scss/utils.scss
- /web/static/src/scss/primary_variables.scss
- /web/static/src/core/notifications/notification.variables.scss
- /web/static/src/search/control_panel/control_panel.variables.scss
- /web/static/src/search/search_panel/search_panel.variables.scss
- /web/static/src/views/form/form.variables.scss
- /web/static/src/views/kanban/kanban.variables.scss
- /web/static/src/webclient/burger_menu/burger_menu.variables.scss
- /web/static/src/webclient/navbar/navbar.variables.scss
- /base/static/src/scss/onboarding.variables.scss
- /web_editor/static/src/scss/web_editor.variables.scss
- /web_editor/static/src/scss/wysiwyg.variables.scss
- /web/static/src/scss/secondary_variables.scss
- /web_editor/static/src/scss/secondary_variables.scss
- /web/static/src/scss/bootstrap_overridden.scss
- /web/static/src/scss/bs_mixins_overrides_backend.scss
- /web_editor/static/src/scss/bootstrap_overridden_backend.scss
- /web_editor/static/src/scss/bootstrap_overridden.scss
- /web/static/src/scss/pre_variables.scss
- /web/static/lib/bootstrap/scss/_variables.scss
- /web/static/src/scss/import_bootstrap.scss
- /web/static/src/scss/helpers_backport.scss
- /web/static/src/scss/utilities_custom.scss
- /web/static/lib/bootstrap/scss/utilities/_api.scss
- /web/static/src/scss/bootstrap_review.scss
- /web/static/src/core/utils/transitions.scss
- /web/static/src/core/action_swiper/action_swiper.scss
- /web/static/src/core/autocomplete/autocomplete.scss
- /web/static/src/core/colorlist/colorlist.scss
- /web/static/src/core/commands/command_palette.scss
- /web/static/src/core/debug/debug_menu.scss
- /web/static/src/core/debug/profiling/profiling_item.scss
- /web/static/src/core/debug/profiling/profiling_qweb.scss
- /web/static/src/core/dialog/dialog.scss
- /web/static/src/core/dropdown/dropdown.scss
- /web/static/src/core/effects/rainbow_man.scss
- /web/static/src/core/file_upload/file_upload_progress_bar.scss
- /web/static/src/core/file_upload/file_upload_progress_record.scss
- /web/static/src/core/model_field_selector/model_field_selector.scss
- /web/static/src/core/model_field_selector/model_field_selector_popover.scss
- /web/static/src/core/notebook/notebook.scss
- /web/static/src/core/notifications/notification.scss
- /web/static/src/core/popover/popover.scss
- /web/static/src/core/tooltip/tooltip.scss
- /web/static/src/core/ui/block_ui.scss
- /web/static/src/search/control_panel/control_panel.scss
- /web/static/src/search/search_bar/search_bar.scss
- /web/static/src/search/search_panel/search_panel.scss
- /web/static/src/search/search_panel/search_view.scss
- /web/static/src/webclient/icons.scss
- /web/static/src/views/calendar/calendar_common/calendar_common_popover.scss
- /web/static/src/views/calendar/calendar_controller.scss
- /web/static/src/views/calendar/calendar_controller_mobile.scss
- /web/static/src/views/calendar/calendar_renderer.scss
- /web/static/src/views/calendar/calendar_renderer_mobile.scss
- /web/static/src/views/calendar/calendar_year/calendar_year_popover.scss
- /web/static/src/views/calendar/filter_panel/calendar_filter_panel.scss
- /web/static/src/views/fields/ace/ace_field.scss
- /web/static/src/views/fields/badge/badge_field.scss
- /web/static/src/views/fields/char/char_field.scss
- /web/static/src/views/fields/color_picker/color_picker_field.scss
- /web/static/src/views/fields/copy_clipboard/copy_clipboard_field.scss
- /web/static/src/views/fields/email/email_field.scss
- /web/static/src/views/fields/fields.scss
- /web/static/src/views/fields/html/html_field.scss
- /web/static/src/views/fields/iframe_wrapper/iframe_wrapper_field.scss
- /web/static/src/views/fields/image/image_field.scss
- /web/static/src/views/fields/journal_dashboard_graph/journal_dashboard_graph_field.scss
- /web/static/src/views/fields/many2many_tags/many2many_tags_field.scss
- /web/static/src/views/fields/many2many_tags/tags_list.scss
- /web/static/src/views/fields/many2many_tags_avatar/many2many_tags_avatar_field.scss
- /web/static/src/views/fields/many2one/many2one_field.scss
- /web/static/src/views/fields/monetary/monetary_field.scss
- /web/static/src/views/fields/pdf_viewer/pdf_viewer_field.scss
- /web/static/src/views/fields/percent_pie/percent_pie_field.scss
- /web/static/src/views/fields/phone/phone_field.scss
- /web/static/src/views/fields/progress_bar/progress_bar_field.scss
- /web/static/src/views/fields/properties/kanban_properties_field.scss
- /web/static/src/views/fields/properties/properties_field.scss
- /web/static/src/views/fields/properties/property_definition.scss
- /web/static/src/views/fields/properties/property_definition_selection.scss
- /web/static/src/views/fields/properties/property_tags.scss
- /web/static/src/views/fields/properties/property_value.scss
- /web/static/src/views/fields/radio/radio_field.scss
- /web/static/src/views/fields/selection/selection_field.scss
- /web/static/src/views/fields/state_selection/state_selection_field.scss
- /web/static/src/views/fields/statusbar/statusbar_field.scss
- /web/static/src/views/fields/text/text_field.scss
- /web/static/src/views/fields/translation_button.scss
- /web/static/src/views/fields/url/url_field.scss
- /web/static/src/views/form/form_controller.scss
- /web/static/src/views/form/form_error_dialog/form_error_dialog.scss
- /web/static/src/views/form/status_bar_buttons/status_bar_buttons.scss
- /web/static/src/views/graph/graph_view.scss
- /web/static/src/views/kanban/kanban_column_progressbar.scss
- /web/static/src/views/kanban/kanban_controller.scss
- /web/static/src/views/kanban/kanban_dashboard.scss
- /web/static/src/views/kanban/kanban_examples_dialog.scss
- /web/static/src/views/list/list_renderer.scss
- /web/static/src/views/pivot/pivot_view.scss
- /web/static/src/views/view.scss
- /web/static/src/views/view_dialogs/export_data_dialog.scss
- /web/static/src/views/widgets/ribbon/ribbon.scss
- /web/static/src/views/widgets/week_days/week_days.scss
- /web/static/src/webclient/barcode/barcode_scanner.scss
- /web/static/src/webclient/barcode/crop_overlay.scss
- /web/static/src/webclient/burger_menu/burger_menu.scss
- /web/static/src/webclient/loading_indicator/loading_indicator.scss
- /web/static/src/webclient/select2.scss
- /web/static/src/webclient/settings_form_view/settings_form_view.scss
- /web/static/src/webclient/settings_form_view/settings_form_view_mobile.scss
- /web/static/src/webclient/settings_form_view/widgets/settings_widgets.scss
- /web/static/src/webclient/user_menu/user_menu.scss
- /web/static/src/webclient/webclient.scss
- /web/static/src/webclient/webclient_layout.scss
- /web/static/src/legacy/scss/domain_selector.scss
- /web/static/src/legacy/scss/model_field_selector.scss
- /web/static/src/legacy/scss/dropdown.scss
- /web/static/src/legacy/scss/tooltip.scss
- /web/static/src/legacy/scss/switch_company_menu.scss
- /web/static/src/legacy/scss/ace.scss
- /web/static/src/legacy/scss/fields.scss
- /web/static/src/legacy/scss/views.scss
- /web/static/src/legacy/scss/form_view.scss
- /web/static/src/legacy/scss/list_view.scss
- /web/static/src/legacy/scss/kanban_dashboard.scss
- /web/static/src/legacy/scss/kanban_examples_dialog.scss
- /web/static/src/legacy/scss/kanban_column_progressbar.scss
- /web/static/src/legacy/scss/kanban_view.scss
- /web/static/src/legacy/scss/data_export.scss
- /base/static/src/scss/onboarding.scss
- /web/static/src/legacy/scss/attachment_preview.scss
- /web/static/src/legacy/scss/base_document_layout.scss
- /web/static/src/legacy/scss/special_fields.scss
- /web/static/src/legacy/scss/fields_extra.scss
- /web/static/src/legacy/scss/form_view_extra.scss
- /web/static/src/legacy/scss/list_view_extra.scss
- /web/static/src/legacy/scss/color_picker.scss
- /base/static/src/scss/res_partner.scss
- /web/static/src/views/form/button_box/button_box.scss
- /auth_totp/static/src/scss/res_users_view_form.scss
- /base_import/static/src/legacy/scss/base_import.scss
- /base_import/static/src/legacy/scss/icons.scss
- /web_editor/static/src/components/media_dialog/media_dialog.scss
- /web_editor/static/src/components/upload_progress_toast/upload_progress_toast.scss
- /web_editor/static/src/scss/web_editor.common.scss
- /web_editor/static/src/scss/web_editor.backend.scss
2024-01-11 06:40:52,001 25272 ERROR owl_test odoo.http: Exception during request handling.
Traceback (most recent call last):
File "D:\odoo01\odoo\odoo16\odoo\tools\cache.py", line 85, in lookup
r = d[key]
File "", line 2, in getitem
File "D:\odoo01\odoo\odoo16\odoo\tools\func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "D:\odoo01\odoo\odoo16\odoo\tools\lru.py", line 34, in getitem
a = self.d[obj]
KeyError: ('ir.qweb', <function IrQWeb._generate_asset_nodes_cache at 0x000001ACB7072D30>, 'web.assets_backend', False, True, '', False, False, False, False, ('zh_CN', None, None, None, None))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "<193>", line 323, in template_193
File "<193>", line 305, in template_193_content
File "<193>", line 274, in template_193_t_call_0
File "<193>", line 191, in template_193_t_set_2
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_qweb.py", line 2422, in _get_asset_nodes
return self._generate_asset_nodes_cache(bundle, css, js, debug, async_load, defer_load, lazy_load, media)
File "", line 2, in _generate_asset_nodes_cache
File "D:\odoo01\odoo\odoo16\odoo\tools\cache.py", line 90, in lookup
value = d[key] = self.method(*args, **kwargs)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_qweb.py", line 2477, in _generate_asset_nodes_cache
return self._generate_asset_nodes(bundle, css, js, debug, async_load, defer_load, lazy_load, media)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_qweb.py", line 2551, in generate_asset_nodes
return remains + asset.to_node(css=css, js=js, debug=debug, async_load=async_load, defer_load=defer_load, lazy_load=lazy_load)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\assetsbundle.py", line 181, in to_node
js_attachment = self.js(is_minified=not is_debug_assets)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\assetsbundle.py", line 405, in js
content.append(self.xml(show_inherit_info=not is_minified))
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\assetsbundle.py", line 530, in xml
raise ValueError(("Module %r not loaded or inexistent (try to inherit %r), or templates of addon being loaded %r are misordered (template %r)", parent_addon, parent_name, addon, template_name))
ValueError: 模块'web'未加载或不存在（尝试承接'WebClient'），或加载'basis_xlsx_report'的ADDON模板顺序错误（模板None）

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 2003, in call
response = request._serve_db()
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 1589, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "D:\odoo01\odoo\odoo16\odoo\service\model.py", line 133, in retrying
result = func()
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 1616, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 1730, in dispatch
return self.request.registry['ir.http']._dispatch(endpoint)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_http.py", line 156, in _dispatch
result.flatten()
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 1100, in flatten
self.response.append(self.render())
File "D:\odoo01\odoo\odoo16\odoo\http.py", line 1092, in render
return request.env["ir.ui.view"]._render_template(self.template, self.qcontext)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_ui_view.py", line 2125, in _render_template
return self.env['ir.qweb']._render(template, values)
File "D:\odoo01\odoo\odoo16\odoo\tools\profiler.py", line 292, in _tracked_method_render
return method_render(self, template, values, **options)
File "D:\odoo01\odoo\odoo16\odoo\addons\base\models\ir_qweb.py", line 581, in _render
result = ''.join(rendering)
File "<193>", line 329, in template_193
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
ValueError: 模块'web'未加载或不存在（尝试承接'WebClient'），或加载'basis_xlsx_report'的ADDON模板顺序错误（模板None）
Template: web.webclient_bootstrap
Path: /t/t/t[1]/t[4]
Node:
2024-01-11 06:40:52,006 25272 INFO owl_test werkzeug: 127.0.0.1 - - [11/Jan/2024 06:40:52] "GET /web HTTP/1.1" 500 - 65 0.023 0.652

billchen0769

UncaughtPromiseError > TypeError
未捕获的承诺 > Cannot read properties of undefined (reading 'record')
TypeError: Cannot read properties of undefined (reading 'record')
at on_close (http://localhost:8069/web/assets/debug/web.assets_backend.js:212108:37) (/report_master/static/libs/reportbro.js:32942)
at _executeCloseAction (http://localhost:8069/web/assets/debug/web.assets_backend.js:58212:19) (/web/static/src/webclient/actions/action_service.js:1186)
at doAction (http://localhost:8069/web/assets/debug/web.assets_backend.js:58246:24) (/web/static/src/webclient/actions/action_service.js:1220)

UncaughtClientError > ReferenceError
未捕获的Javascript错误 > app is not defined
ReferenceError: app is not defined
at o (chrome-extension://lcgkfekplehkejfdddmknfmfjppiomnb/js/inject.js:1:965)
at 559a (chrome-extension://lcgkfekplehkejfdddmknfmfjppiomnb/js/inject.js:1:1355)
at o (chrome-extension://lcgkfekplehkejfdddmknfmfjppiomnb/js/inject.js:1:110)
at chrome-extension://lcgkfekplehkejfdddmknfmfjppiomnb/js/inject.js:1:908
at chrome-extension://lcgkfekplehkejfdddmknfmfjppiomnb/js/inject.js:1:923

billchen0769

@digitalsatori 在如何解决odooqweb报告中 td rowspan 打印跨页断开的问题中说：

page-break-before: always, page-break-after: always

请问大概放在哪个位置？

billchen0769

如图，如何解决第一列跨页断开的问题？

billchen0769

from odoo import api, fields, models, _

class StockPickingInherit(models.Model):
_inherit = "stock.picking"

x_partner_ref = fields.Char(string='流水号', compute='_compute_partner_ref', store=True)


@api.depends('purchase_id.partner_ref', 'sale_id.x_serial')
def _compute_partner_ref(self):
    for picking in self:
        if picking.purchase_id:
            picking.x_partner_ref = picking.purchase_id.partner_ref
        elif picking.sale_id:
            picking.x_partner_ref = picking.sale_id.x_serial
        else:
            picking.x_partner_ref = False

在上面代码中会报这个错误：
ValueError: Wrong @depends on '_compute_partner_ref' (compute method of field stock.picking.x_partner_ref). Dependency field 'sale_id' not found in model stock.picking.
但是用下面这个方法就没问题：

@api.depends('purchase_id.partner_ref')
def _compute_partner_ref(self):
    for picking in self:
        if picking.purchase_id:
            picking.x_partner_ref = picking.purchase_id.partner_ref
        else:
            picking.x_partner_ref = False

是不是在stock.picking中需要扩展sale_id字段？请问应该如何改造？

billchen0769

在odoo16 中如何通过npm安装ReportBro Designer以及配置使用ReportBro 插件？

billchen0769

请问一下根据不同的产品类别生成不同的产品编号，有什么简单的方法实现，我想到的方法是给一个新字段，然后根据该字段的内容匹配不同的产品序号，但是获取不到该字段的内容，有什么方法解决，或者有什么更好的实现方法？

class ProductTemplateInherit(models.Model):
_inherit = 'product.template'
x_category_ordinal = fields.Char(related='categ_id.x_ordinal', string='产品类型序号', required=True)
default_code = fields.Char(default=lambda self: _(' '))

@api.model
def create(self, vals):
    if vals.get("x_category_ordinal") is None:
        # 获取记录中的实际数据值
        record = self.env['product.template'].browse(vals['categ_id'])
        x_category_ordinal = record.x_category_ordinal
        vals['x_category_ordinal'] = x_category_ordinal

    if vals.get('default_code', _(' ')) == _(' '):
        if vals['x_category_ordinal'] == 'value1':
            vals['default_code'] = self.env['ir.sequence'].next_by_code('sequence_code_1') or _(' ')
        elif vals['x_category_ordinal'] == 'value2':
            vals['default_code'] = self.env['ir.sequence'].next_by_code('sequence_code_2') or _(' ')
        elif vals['x_category_ordinal'] == 'value3':
            vals['default_code'] = self.env['ir.sequence'].next_by_code('sequence_code_3') or _(' ')
        elif vals['x_category_ordinal'] == 'value4':
            vals['default_code'] = self.env['ir.sequence'].next_by_code('sequence_code_4') or _(' ')
        else:
            vals['default_code'] = self.env['ir.sequence'].next_by_code('default_sequence') or _(' ')

    res = super(ProductTemplateInherit, self).create(vals)
    return res

billchen0769

可以在下面的代码中加入domain使得该序号只在某个字段为特定值的时候才启用该序号规则？

<!--    <record id="seq_product_category" model="ir.sequence">-->
      
      <!--        <field name="name">Category Sequence</field>-->
      
      <!--        <field name="code">product.category</field>-->
      
      <!--        <field name="prefix">C</field>-->
      
      <!--        <field name="padding">3</field>-->
      
      <!--        <field name="company_id" eval="False"/>-->
      
      <!--    </record>-->

billchen0769

first_level = fields.Selection([
('regular_checks', '常规检查'),
('transmissibility_photo_examination', '透射性检查'),
('in_vitro_examination', '体外检查'),
('tests_that_reach_into_the_body', '体内检查'),
('special_organ_examinations', '五官检查')
], string='检查大类')
second_level = fields.Selection(selection='_get_second_field_options', string='检查分类')

@api.model
def _get_second_field_options(self):
options = []
context = self.env.context
if context.get('first_level') == 'Regular_checks':
options = [('blood_test', '验血'), ('urine_test', '验尿'), ('examination_of_stool', '验便')]
elif context.get('first_level') == 'Transmissibility_photo_examination':
options = [('x_ray_dr', 'X光 / DR'), ('ct', 'CT'), ('mri', 'MR 核磁共振')]
elif context.get('first_level') == 'In_vitro_examination':
options = [('b_ultrasound', 'B超'), ('electrocardiogram', '心电图')]
elif context.get('first_level') == 'Tests_that_reach_into_the_body':
options = [('gastroscope', '胃镜'), ('colonoscopy', '肠镜')]
elif context.get('first_level') == 'Special_organ_examinations':
options = [('hearing_test', '听力检查'), ('vision_test', '视力检查')]
return options

为什么方法不生效，请问有什么错误的地方？

billchen0769

@昱y
大概是这样写吗？
first_level = fields.Selection(
[('Regular_checks', '常规检查'), ('Transmissibility_photo_examination', '透射性照片检查'),
('In_vitro_examination', '体外检查'), ('Tests_that_reach_into_the_body', '伸进体内的检查'),
('Special_organ_examinations', '特殊器官检查')],
string='检查大类')
second_level = fields.Selection(selection='_get_second_field_options', string='检查分类')

def _get_second_field_options(self):
    options = []
    context = self.env.context
    if context.get('first_level') == 'Regular_checks':
        options = [('blood_test', '验血'), ('urine_test', '验尿'), ('examination_of_stool', '验便')]
    elif context.get('first_level') == 'Transmissibility_photo_examination':
        options = [('x_ray_dr', 'X光 / DR'), ('ct', 'CT'), ('mri', 'MR 核磁共振')]
    elif context.get('first_level') == 'In_vitro_examination':
        options = [('b_ultrasound', 'B超'), ('electrocardiogram', '心电图')]
    elif context.get('first_level') == 'Tests_that_reach_into_the_body':
        options = [('gastroscope', '胃镜'), ('colonoscopy', '肠镜')]
    elif context.get('first_level') == 'Special_organ_examinations':
        options = [('hearing_test', '听力检查'), ('vision_test', '视力检查')]
    return options

当时不生效。

billchen0769

我有这样的需求，逻辑如下：
假如在第一个selection字段有A,B,C,D四个选项，
当第一个selection字段选择A时，第二个selection字段有1，2，3，4，四个选项
当第一个selection字段选择B时，第二个selection字段有5，6，7，8，四个选项
当第一个selection字段选择C时，第二个selection字段有9，10，11，12，四个选项
请问这样应该如何实现？