Compare commits
141 Commits
feature/制造
...
feature/to
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
2644df4fd5 | ||
|
|
9392819375 | ||
|
|
ea3d9e5375 | ||
|
|
238840b647 | ||
|
|
c6f06a4c32 | ||
|
|
5b61a801c5 | ||
|
|
ed55e36f45 | ||
|
|
3763b60758 | ||
|
|
50c3b31ece | ||
|
|
8afc8bb3a6 | ||
|
|
3148ce5a15 | ||
|
|
8e726e1bf6 | ||
|
|
4c0f9cfb39 | ||
|
|
a8e4c7d9a0 | ||
|
|
7501832637 | ||
|
|
ce0ead4da6 | ||
|
|
6d3793ee30 | ||
|
|
9e6f3fa864 | ||
|
|
ed50d7c9a7 | ||
|
|
89e23050e6 | ||
|
|
b7f912453f | ||
|
|
cab6b6fa2a | ||
|
|
35bf954529 | ||
|
|
1040844b0a | ||
|
|
36a13c04de | ||
|
|
f4318bd997 | ||
|
|
d47a30977c | ||
|
|
ceb38aa483 | ||
|
|
11ecad5ef2 | ||
|
|
8249d1427f | ||
|
|
94bcfc0543 | ||
|
|
b4d31c7c4b | ||
|
|
d7f7bb9a57 | ||
|
|
ee87e1dacf | ||
|
|
2f6c41c999 | ||
|
|
d0d4db1555 | ||
|
|
62cbb4b796 | ||
|
|
f040406002 | ||
|
|
bfff4ac440 | ||
|
|
a97386c37c | ||
|
|
18ae46207a | ||
|
|
bacddd2ad8 | ||
|
|
dd5794899d | ||
|
|
e5b730b2ef | ||
|
|
aea158de41 | ||
|
|
a933a0ffea | ||
|
|
7575424760 | ||
|
|
6c2eb40e6a | ||
|
|
f10f595fa4 | ||
|
|
6d1de42d76 | ||
|
|
5dc16c039c | ||
|
|
c416cdbeed | ||
|
|
18c7b22319 | ||
|
|
b5339046b9 | ||
|
|
e0ba222382 | ||
|
|
58b00e6442 | ||
|
|
9182dbfb5d | ||
|
|
27516844af | ||
|
|
99237445ac | ||
|
|
9349ca91d3 | ||
|
|
51c517145b | ||
|
|
c55f3d77bf | ||
|
|
95716c2e3e | ||
|
|
5f72519dc2 | ||
|
|
c24bba3137 | ||
|
|
01bb6fd0aa | ||
|
|
bf4add6b78 | ||
|
|
7d986fe139 | ||
|
|
fffbfc21c2 | ||
|
|
6451bfbc42 | ||
|
|
5aa848de53 | ||
|
|
efc4ae31c9 | ||
|
|
0863238819 | ||
|
|
4f181e5eba | ||
|
|
2bf43ae9a1 | ||
|
|
d98d04d4ed | ||
|
|
602d6678bc | ||
|
|
8fd0c4e1f1 | ||
|
|
514fd79c3e | ||
|
|
95c25ac7b8 | ||
|
|
21d052e222 | ||
|
|
95e2c2db0d | ||
|
|
17a29b7b29 | ||
|
|
dd745423a1 | ||
|
|
a534e5f400 | ||
|
|
4dc7b5857e | ||
|
|
dc679c46cc | ||
|
|
8ccf6cc365 | ||
|
|
f8457ae66b | ||
|
|
12c8641f2e | ||
|
|
f42938f668 | ||
|
|
a856c5cbf7 | ||
|
|
6411e79904 | ||
|
|
946f08c479 | ||
|
|
4a198639ec | ||
|
|
234812bb40 | ||
|
|
dd43e31c3c | ||
|
|
2f5b0281c3 | ||
|
|
d4cf2a9d17 | ||
|
|
ecf5dcf2f2 | ||
|
|
848e8a5fa8 | ||
|
|
cc38383e32 | ||
|
|
39de4e5ea1 | ||
|
|
8b6c904dae | ||
|
|
a63f2d28f6 | ||
|
|
08812f169e | ||
|
|
ce79016bef | ||
|
|
fef960f7e8 | ||
|
|
425c9fb64b | ||
|
|
fc9a58c0c3 | ||
|
|
ed90ad34e6 | ||
|
|
5662094ec4 | ||
|
|
404c56e134 | ||
|
|
9ee614aa10 | ||
|
|
57789dc5a5 | ||
|
|
52d436909b | ||
|
|
3a760a66e1 | ||
|
|
72415d633c | ||
|
|
5c67a8c190 | ||
|
|
46ba682848 | ||
|
|
6b38062e87 | ||
|
|
0945754736 | ||
|
|
644ff967e5 | ||
|
|
5f79d2038c | ||
|
|
defd779279 | ||
|
|
e2e820267e | ||
|
|
94f179a6d6 | ||
|
|
bf9f4c1276 | ||
|
|
51a633594f | ||
|
|
7d7c7b0fcf | ||
|
|
d88ac22b7c | ||
|
|
1f4e1c11c8 | ||
|
|
9f1beb4013 | ||
|
|
f864466987 | ||
|
|
9cf70cc54c | ||
|
|
82bd50cb97 | ||
|
|
4bce26721d | ||
|
|
3fb4e7c413 | ||
|
|
a7ab8679f4 | ||
|
|
ca9a91e30a | ||
|
|
314d738412 |
@@ -3,8 +3,12 @@ import qrcode
|
||||
from reportlab.pdfgen import canvas
|
||||
from reportlab.lib.pagesizes import A4
|
||||
from PIL import Image
|
||||
import logging
|
||||
from reportlab.lib.utils import ImageReader
|
||||
from odoo import models, fields, api
|
||||
import base64
|
||||
|
||||
_logger = logging.getLogger(__name__)
|
||||
|
||||
class JikimoPrinting(models.AbstractModel):
|
||||
_name = 'jikimo.printing'
|
||||
@@ -13,6 +17,11 @@ class JikimoPrinting(models.AbstractModel):
|
||||
"""
|
||||
打印二维码
|
||||
"""
|
||||
printer = self.env['printing.printer'].get_default()
|
||||
if not printer:
|
||||
_logger.error("未找到默认打印机")
|
||||
return False
|
||||
|
||||
# 生成二维码
|
||||
qr = qrcode.QRCode(version=1, box_size=10, border=5)
|
||||
qr.add_data(data)
|
||||
@@ -41,16 +50,38 @@ class JikimoPrinting(models.AbstractModel):
|
||||
|
||||
# 获取PDF内容并打印
|
||||
pdf_content = pdf_buffer.getvalue()
|
||||
printer = self.env['printing.printer'].get_default()
|
||||
# _logger.info(f"打印内容: {pdf_content}")
|
||||
printer.print_document(report=None, content=pdf_content, doc_format='pdf')
|
||||
|
||||
# 清理资源
|
||||
pdf_buffer.close()
|
||||
temp_image.close()
|
||||
|
||||
return True
|
||||
|
||||
def print_pdf(self, pdf_data):
|
||||
"""
|
||||
打印PDF
|
||||
"""
|
||||
printer = self.env['printing.printer'].get_default()
|
||||
printer.print_document(report=None, content = pdf_data, doc_format='pdf')
|
||||
if not printer:
|
||||
_logger.error("未找到默认打印机")
|
||||
return False
|
||||
|
||||
pdf_data_str = pdf_data.decode('ascii', errors='ignore')
|
||||
decoded_data = base64.b64decode(pdf_data_str)
|
||||
|
||||
# 处理二进制数据
|
||||
pdf_buffer = BytesIO()
|
||||
pdf_buffer.write(decoded_data)
|
||||
pdf_buffer.seek(0)
|
||||
|
||||
# 获取PDF内容
|
||||
pdf_content = pdf_buffer.getvalue()
|
||||
|
||||
printer.print_document(report=None, content=pdf_content, doc_format='pdf')
|
||||
# 清理资源
|
||||
pdf_buffer.close()
|
||||
|
||||
_logger.info("成功打印PDF")
|
||||
return True
|
||||
@@ -21,8 +21,6 @@ class MrpWorkorder(models.Model):
|
||||
# 执行打印
|
||||
self.env['jikimo.printing'].print_pdf(pdf_data)
|
||||
wo.production_id.product_id.is_print_program = True
|
||||
_logger.info(f"工单 {wo.name} 的PDF已成功打印")
|
||||
|
||||
except Exception as e:
|
||||
_logger.error(f"工单 {wo.name} 的PDF打印失败: {str(e)}")
|
||||
|
||||
|
||||
@@ -12,12 +12,14 @@
|
||||
'views/mrp_production.xml',
|
||||
'views/purchase_request_view.xml',
|
||||
'wizard/purchase_request_line_make_purchase_order_view.xml',
|
||||
'views/purchase_request_line_view.xml',
|
||||
'views/stock_picking_views.xml',
|
||||
],
|
||||
# 'assets': {
|
||||
# 'web.assets_backend': [
|
||||
# 'jikimo_purchase_request/static/src/**/*'
|
||||
# ],
|
||||
# },
|
||||
'assets': {
|
||||
'web.assets_backend': [
|
||||
'jikimo_purchase_request/static/src/**/*'
|
||||
],
|
||||
},
|
||||
'application': True,
|
||||
'installable': True,
|
||||
'auto_install': False,
|
||||
|
||||
@@ -1043,7 +1043,7 @@ msgstr "询价单"
|
||||
#. module: purchase_request
|
||||
#: model:ir.model.fields,field_description:purchase_request.field_purchase_request_line__purchased_qty
|
||||
msgid "RFQ/PO Qty"
|
||||
msgstr ""
|
||||
msgstr "已订购数"
|
||||
|
||||
#. module: purchase_request
|
||||
#. odoo-python
|
||||
|
||||
@@ -5,3 +5,4 @@ from . import sale_order
|
||||
from . import mrp_production
|
||||
from . import purchase_order
|
||||
from . import stock_rule
|
||||
from . import stock_picking
|
||||
|
||||
@@ -9,18 +9,32 @@ class MrpProduction(models.Model):
|
||||
@api.depends('state')
|
||||
def _compute_pr_mp_count(self):
|
||||
for item in self:
|
||||
pr_ids = self.env['purchase.request'].sudo().search([('origin', 'like', item.name), ('is_subcontract', '!=', 'True')])
|
||||
if pr_ids:
|
||||
item.pr_mp_count = len(pr_ids)
|
||||
else:
|
||||
item.pr_mp_count = 0
|
||||
# if item.product_id.product_tmpl_id.single_manufacturing == True and not item.is_remanufacture:
|
||||
# first_order = self.env['mrp.production'].search(
|
||||
# [('origin', '=', item.origin), ('product_id', '=', item.product_id.id)], limit=1, order='id asc')
|
||||
# pr_ids = self.env['purchase.request'].sudo().search([('origin', 'like', first_order.name)])
|
||||
# item.pr_mp_count = len(pr_ids)
|
||||
# else:
|
||||
# pr_ids = self.env['purchase.request'].sudo().search([('origin', 'like', item.name)])
|
||||
# item.pr_mp_count = len(pr_ids)
|
||||
# 由于采购申请合并了所有销售订单行的采购,所以不区分产品
|
||||
first_mp = self.env['mrp.production'].search(
|
||||
[('origin', '=', item.origin)], limit=1, order='id asc')
|
||||
pr_ids = self.env['purchase.request'].sudo().search(
|
||||
[('origin', 'like', first_mp.name), ('is_subcontract', '!=', 'True')])
|
||||
item.pr_mp_count = len(pr_ids)
|
||||
# pr_ids = self.env['purchase.request'].sudo().search([('origin', 'like', item.name), ('is_subcontract', '!=', 'True')])
|
||||
|
||||
def action_view_pr_mp(self):
|
||||
"""
|
||||
采购请求
|
||||
"""
|
||||
self.ensure_one()
|
||||
pr_ids = self.env['purchase.request'].sudo().search([('origin', 'like', self.name),('is_subcontract', '!=', True)])
|
||||
first_mp = self.env['mrp.production'].search(
|
||||
[('origin', '=', self.origin)], limit=1, order='id asc')
|
||||
pr_ids = self.env['purchase.request'].sudo().search(
|
||||
[('origin', 'like', first_mp.name), ('is_subcontract', '!=', 'True')])
|
||||
|
||||
action = {
|
||||
'res_model': 'purchase.request',
|
||||
'type': 'ir.actions.act_window',
|
||||
@@ -33,7 +47,7 @@ class MrpProduction(models.Model):
|
||||
else:
|
||||
action.update({
|
||||
'name': _("从 %s生成采购请求单", self.name),
|
||||
'domain': [('id', 'in', pr_ids)],
|
||||
'domain': [('id', 'in', pr_ids.ids)],
|
||||
'view_mode': 'tree,form',
|
||||
})
|
||||
return action
|
||||
|
||||
@@ -47,6 +47,19 @@ class PurchaseRequestLine(models.Model):
|
||||
('outsourcing', "委外加工"),
|
||||
], string='供货方式', compute='_compute_supply_method', store=True)
|
||||
|
||||
purchase_request_count = fields.Integer(string='采购申请数量', compute='_compute_purchase_request_count', readonly=True)
|
||||
purchase_count = fields.Integer(string="采购订单数量", compute="_compute_purchase_count", readonly=True)
|
||||
|
||||
@api.depends("purchase_lines")
|
||||
def _compute_purchase_count(self):
|
||||
for rec in self:
|
||||
rec.purchase_count = len(rec.mapped("purchase_lines.order_id"))
|
||||
|
||||
@api.depends('request_id')
|
||||
def _compute_purchase_request_count(self):
|
||||
for order in self:
|
||||
order.purchase_request_count = len(order.request_id)
|
||||
|
||||
@api.depends('origin')
|
||||
def _compute_supply_method(self):
|
||||
for prl in self:
|
||||
@@ -98,3 +111,36 @@ class PurchaseRequestLine(models.Model):
|
||||
else:
|
||||
record.part_number = record.product_id.part_number
|
||||
record.part_name = record.product_id.part_name
|
||||
|
||||
def _compute_qty_to_buy(self):
|
||||
for pr in self:
|
||||
qty_to_buy = sum(pr.mapped("product_qty"))
|
||||
if pr.purchase_count > 0:
|
||||
qty_to_buy -= sum(pr.mapped("purchase_lines").filtered(lambda po: po.state != 'cancel').mapped(
|
||||
"product_qty"))
|
||||
pr.qty_to_buy = qty_to_buy > 0.0
|
||||
pr.pending_qty_to_receive = qty_to_buy
|
||||
|
||||
def action_view_purchase_request(self):
|
||||
action = self.env["ir.actions.actions"]._for_xml_id("purchase_request.purchase_request_form_action")
|
||||
action.update({
|
||||
'res_id': self.request_id.id,
|
||||
'views': [[False, 'form']],
|
||||
})
|
||||
return action
|
||||
|
||||
def action_view_purchase_order(self):
|
||||
action = self.env["ir.actions.actions"]._for_xml_id("purchase.purchase_rfq")
|
||||
lines = self.mapped("purchase_lines.order_id")
|
||||
if len(lines) > 1:
|
||||
action["domain"] = [("id", "in", lines.ids)]
|
||||
elif lines:
|
||||
action["views"] = [
|
||||
(self.env.ref("purchase.purchase_order_form").id, "form")
|
||||
]
|
||||
action["res_id"] = lines.id
|
||||
origin_context = ast.literal_eval(action['context'])
|
||||
if 'search_default_draft' in origin_context:
|
||||
origin_context.pop('search_default_draft')
|
||||
action['context'] = origin_context
|
||||
return action
|
||||
|
||||
35
jikimo_purchase_request/models/stock_picking.py
Normal file
35
jikimo_purchase_request/models/stock_picking.py
Normal file
@@ -0,0 +1,35 @@
|
||||
from odoo import fields, api, models, _
|
||||
|
||||
|
||||
class StockPicking(models.Model):
|
||||
_inherit = "stock.picking"
|
||||
|
||||
purchase_request_count = fields.Integer('采购订单数量', compute='_compute_purchase_request')
|
||||
|
||||
@api.depends('name')
|
||||
def _compute_purchase_request(self):
|
||||
for record in self:
|
||||
purchase_request_ids = self.env['purchase.request'].search([('origin', '=', record.name)])
|
||||
record.purchase_request_count = len(purchase_request_ids)
|
||||
|
||||
def action_view_purchase_request(self):
|
||||
self.ensure_one()
|
||||
|
||||
purchase_request_ids = self.env['purchase.request'].search([('origin', '=', self.name)])
|
||||
|
||||
action = {
|
||||
'res_model': 'purchase.request',
|
||||
'type': 'ir.actions.act_window',
|
||||
}
|
||||
if len(purchase_request_ids) == 1:
|
||||
action.update({
|
||||
'view_mode': 'form',
|
||||
'res_id': purchase_request_ids[0].id,
|
||||
})
|
||||
else:
|
||||
action.update({
|
||||
'name': _("从 %s生成采购请求单", self.name),
|
||||
'domain': [('id', 'in', purchase_request_ids.ids)],
|
||||
'view_mode': 'tree,form',
|
||||
})
|
||||
return action
|
||||
@@ -1,4 +1,5 @@
|
||||
from odoo import api, fields, models
|
||||
from collections import defaultdict
|
||||
|
||||
|
||||
class StockRule(models.Model):
|
||||
@@ -44,7 +45,40 @@ class StockRule(models.Model):
|
||||
purchase_request_line_model.create(request_line_data)
|
||||
|
||||
def _run_buy(self, procurements):
|
||||
res = super(StockRule, self)._run_buy(procurements)
|
||||
# 如果补货组相同,并且产品相同,则合并
|
||||
procurements_dict = defaultdict()
|
||||
for procurement, rule in procurements:
|
||||
if (procurement.product_id.id, procurement.values['group_id'], rule.id) not in procurements_dict:
|
||||
procurements_dict[(procurement.product_id.id, procurement.values['group_id'], rule.id)] = {
|
||||
'product_id': procurement.product_id,
|
||||
'product_qty': procurement.product_qty,
|
||||
'product_uom': procurement.product_uom,
|
||||
'location_id': procurement.location_id,
|
||||
'name': procurement.name,
|
||||
'origin': procurement.origin,
|
||||
'company_id': procurement.company_id,
|
||||
'values': procurement.values,
|
||||
'rule': rule
|
||||
}
|
||||
else:
|
||||
procurements_dict[(procurement.product_id.id, procurement.values['group_id'], rule.id)]['product_qty'] += procurement.product_qty
|
||||
procurements_dict[(procurement.product_id.id, procurement.values['group_id'], rule.id)]['values']['move_dest_ids'] |= procurement.values['move_dest_ids']
|
||||
new_procurements = []
|
||||
for k, p in procurements_dict.items():
|
||||
new_procurements.append((
|
||||
self.env['procurement.group'].Procurement(
|
||||
product_id=p['product_id'],
|
||||
product_qty=p['product_qty'],
|
||||
product_uom=p['product_uom'],
|
||||
location_id=p['location_id'],
|
||||
name=p['name'],
|
||||
origin=p['origin'],
|
||||
company_id=p['company_id'],
|
||||
values=p['values']
|
||||
), p['rule'])
|
||||
)
|
||||
|
||||
res = super(StockRule, self)._run_buy(new_procurements)
|
||||
# 判断是否根据规则生成新的采购申请单据,如果生成则修改状态为 approved
|
||||
origins = list(set([procurement[0].origin for procurement in procurements]))
|
||||
for origin in origins:
|
||||
|
||||
3
jikimo_purchase_request/static/src/change.scss
Normal file
3
jikimo_purchase_request/static/src/change.scss
Normal file
@@ -0,0 +1,3 @@
|
||||
th[data-name=keep_description] {
|
||||
min-width: 220px;
|
||||
}
|
||||
22
jikimo_purchase_request/views/purchase_request_line_view.xml
Normal file
22
jikimo_purchase_request/views/purchase_request_line_view.xml
Normal file
@@ -0,0 +1,22 @@
|
||||
<odoo>
|
||||
<record id="purchase_request_line_form_sf" model="ir.ui.view">
|
||||
<field name="name">purchase.request.line.sf.form</field>
|
||||
<field name="model">purchase.request.line</field>
|
||||
<field name="inherit_id" ref="purchase_request.purchase_request_line_form"/>
|
||||
<field name="arch" type="xml">
|
||||
<xpath expr="//h1" position="before">
|
||||
<div class="oe_button_box" name="button_box">
|
||||
<button type="object" name="action_view_purchase_request" class="oe_stat_button"
|
||||
icon="fa-file">
|
||||
<field name="purchase_request_count" widget="statinfo" string="采购申请"/>
|
||||
</button>
|
||||
<button type="object" name="action_view_purchase_order" class="oe_stat_button"
|
||||
attrs="{'invisible': [('purchase_count', '=', 0)]}" icon="fa-shopping-cart">
|
||||
<field name="purchase_count" widget="statinfo" string="采购订单"/>
|
||||
</button>
|
||||
</div>
|
||||
</xpath>
|
||||
|
||||
</field>
|
||||
</record>
|
||||
</odoo>
|
||||
21
jikimo_purchase_request/views/stock_picking_views.xml
Normal file
21
jikimo_purchase_request/views/stock_picking_views.xml
Normal file
@@ -0,0 +1,21 @@
|
||||
<?xml version="1.0" encoding="UTF-8" ?>
|
||||
<odoo>
|
||||
<record id="stock_pikcing_inherited_form_jikimo_purchase_request" model="ir.ui.view">
|
||||
<field name="name">stock.pikcing.inherited.form.jikimo.purchase.request</field>
|
||||
<field name="model">stock.picking</field>
|
||||
<field name="inherit_id" ref="stock.view_picking_form"/>
|
||||
<field name="arch" type="xml">
|
||||
<xpath expr="//div[@name='button_box']/button" position="before">
|
||||
<button class="oe_stat_button" name="action_view_purchase_request" type="object" icon="fa-credit-card"
|
||||
attrs="{'invisible': [('purchase_request_count', '=', 0)]}">
|
||||
<div class="o_field_widget o_stat_info">
|
||||
<span class="o_stat_value">
|
||||
<field name="purchase_request_count"/>
|
||||
</span>
|
||||
<span class="o_stat_text">采购申请</span>
|
||||
</div>
|
||||
</button>
|
||||
</xpath>
|
||||
</field>
|
||||
</record>
|
||||
</odoo>
|
||||
@@ -104,9 +104,26 @@ class PurchaseRequestLineMakePurchaseOrder(models.TransientModel):
|
||||
# 去掉合并必须同一采购组的限制
|
||||
pass
|
||||
|
||||
def get_items(self, request_line_ids):
|
||||
request_line_obj = self.env["purchase.request.line"]
|
||||
items = []
|
||||
request_lines = request_line_obj.browse(request_line_ids).filtered(lambda line: line.pending_qty_to_receive > 0)
|
||||
self._check_valid_request_line(request_line_ids)
|
||||
self.check_group(request_lines)
|
||||
for line in request_lines:
|
||||
items.append([0, 0, self._prepare_item(line)])
|
||||
return items
|
||||
|
||||
|
||||
class PurchaseRequestLineMakePurchaseOrderItem(models.TransientModel):
|
||||
_inherit = "purchase.request.line.make.purchase.order.item"
|
||||
|
||||
supply_method = fields.Selection(related='line_id.supply_method', string='供货方式')
|
||||
|
||||
wiz_id = fields.Many2one(
|
||||
comodel_name="purchase.request.line.make.purchase.order",
|
||||
string="Wizard",
|
||||
required=False,
|
||||
ondelete="cascade",
|
||||
readonly=True,
|
||||
)
|
||||
|
||||
@@ -6,7 +6,7 @@ from odoo.addons.sf_base.decorators.api_log import api_log
|
||||
|
||||
class MainController(http.Controller):
|
||||
|
||||
@http.route('/api/manual_download_program', type='json', methods=['POST'], auth='public', cors='*')
|
||||
@http.route('/api/manual_download_program', type='json', methods=['POST'], auth='wechat_token', cors='*')
|
||||
@api_log('人工线下加工编程文件传输', requester='报工系统')
|
||||
def manual_download_program(self):
|
||||
"""
|
||||
@@ -59,7 +59,7 @@ class MainController(http.Controller):
|
||||
target_ftp_info,
|
||||
'/' + str(model_id),
|
||||
'/',
|
||||
match_str=r'^\d*_\d*-' + tool_groups_id.name + r'-\w{2}-all\.nc$'
|
||||
match_str=r'^\d*-' + tool_groups_id.name + r'-\w{2}-all\.nc$'
|
||||
)
|
||||
if len(result) > 0:
|
||||
return {'code': 200, 'message': '传输成功', 'file_list': result}
|
||||
|
||||
@@ -141,7 +141,7 @@ class QualityCheck(models.Model):
|
||||
# # 出厂检验报告编号
|
||||
# report_number = fields.Char('出厂检验报告编号', compute='_compute_report_number', readonly=True)
|
||||
# 总数量,值为调拨单_产品明细_数量
|
||||
total_qty = fields.Char('总数量', compute='_compute_total_qty')
|
||||
total_qty = fields.Char('总数量', compute='_compute_total_qty', store=True)
|
||||
|
||||
column_nums = fields.Integer('测量值列数', default=1)
|
||||
|
||||
@@ -153,9 +153,9 @@ class QualityCheck(models.Model):
|
||||
for move in record.picking_id.move_ids_without_package:
|
||||
if move.product_id == record.product_id:
|
||||
total_qty = int(move.product_uom_qty)
|
||||
record.total_qty = total_qty if total_qty > 0 else ''
|
||||
record.total_qty = total_qty if total_qty > 0 else 0
|
||||
else:
|
||||
record.total_qty = ''
|
||||
record.total_qty = 0
|
||||
|
||||
# 检验数
|
||||
check_qty = fields.Integer('检验数', default=lambda self: self._get_default_check_qty())
|
||||
@@ -735,8 +735,9 @@ class QualityCheck(models.Model):
|
||||
def _compute_qty_to_test(self):
|
||||
for qc in self:
|
||||
if qc.is_lot_tested_fractionally:
|
||||
rounding = qc.product_id.uom_id.rounding if qc.product_id.uom_id else 0.01
|
||||
qc.qty_to_test = float_round(qc.qty_line * qc.testing_percentage_within_lot / 100,
|
||||
precision_rounding=self.product_id.uom_id.rounding, rounding_method="UP")
|
||||
precision_rounding=rounding, rounding_method="UP")
|
||||
else:
|
||||
qc.qty_to_test = qc.qty_line
|
||||
|
||||
|
||||
@@ -23,8 +23,8 @@ class QualityCheckWizard(models.TransientModel):
|
||||
lot_name = fields.Char(related='current_check_id.lot_name')
|
||||
lot_line_id = fields.Many2one(related='current_check_id.lot_line_id')
|
||||
qty_line = fields.Float(related='current_check_id.qty_line')
|
||||
qty_to_test = fields.Float(related='current_check_id.qty_to_test')
|
||||
qty_tested = fields.Float(related='current_check_id.qty_tested', readonly=False)
|
||||
qty_to_test = fields.Float(related='current_check_id.qty_to_test', string='待检')
|
||||
qty_tested = fields.Float(related='current_check_id.qty_tested', string='已检', readonly=False)
|
||||
measure = fields.Float(related='current_check_id.measure', readonly=False)
|
||||
measure_on = fields.Selection(related='current_check_id.measure_on')
|
||||
quality_state = fields.Selection(related='current_check_id.quality_state')
|
||||
|
||||
@@ -1,3 +1,7 @@
|
||||
pystrich
|
||||
cpca
|
||||
pycryptodome==3.20
|
||||
cpca==0.5.5
|
||||
wechatpy==1.8.18
|
||||
pycryptodome==3.22.0
|
||||
openupgradelib==3.10.0
|
||||
opcua==0.98.13
|
||||
openpyxl
|
||||
@@ -134,7 +134,7 @@ class PrintingUtils(models.AbstractModel):
|
||||
|
||||
# 注册中文字体
|
||||
font_paths = [
|
||||
"/usr/share/fonts/windows/simsun.ttc", # Windows系统宋体
|
||||
"/usr/share/fonts/chinese/simsun.ttc", # Windows系统宋体
|
||||
"c:/windows/fonts/simsun.ttc", # Windows系统宋体另一个位置
|
||||
"/usr/share/fonts/truetype/droid/DroidSansFallbackFull.ttf", # Linux Droid字体
|
||||
"/usr/share/fonts/truetype/wqy/wqy-zenhei.ttc", # 文泉驿正黑
|
||||
@@ -167,10 +167,10 @@ class PrintingUtils(models.AbstractModel):
|
||||
|
||||
# 设置字体
|
||||
if font_found:
|
||||
c.setFont('SimSun', 14) # 增大字体大小到14pt
|
||||
c.setFont('SimSun', 10) # 增大字体大小到14pt
|
||||
else:
|
||||
# 如果没有找到中文字体,使用默认字体
|
||||
c.setFont('Helvetica', 14)
|
||||
c.setFont('Helvetica', 10)
|
||||
logging.warning("未找到中文字体,将使用默认字体")
|
||||
|
||||
# 在右下角绘制二维码,预留边距
|
||||
@@ -182,7 +182,7 @@ class PrintingUtils(models.AbstractModel):
|
||||
if buttom_text:
|
||||
# 在二维码下方绘制文字
|
||||
text = buttom_text
|
||||
text_width = c.stringWidth(text, "SimSun" if font_found else "Helvetica", 14) # 准确计算文字宽度
|
||||
text_width = c.stringWidth(text, "SimSun" if font_found else "Helvetica", 10) # 准确计算文字宽度
|
||||
text_x = page_width - qr_size - margin + (qr_size - text_width) / 2 # 文字居中对齐
|
||||
text_y = margin + 20 # 文字位置靠近底部
|
||||
c.drawString(text_x, text_y, text)
|
||||
|
||||
@@ -4,6 +4,7 @@ import json
|
||||
import logging
|
||||
from odoo import http
|
||||
from odoo.http import request
|
||||
from odoo.addons.sf_base.decorators.api_log import api_log
|
||||
|
||||
_logger = logging.getLogger(__name__)
|
||||
|
||||
@@ -11,6 +12,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/MachineToolGroup', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('机床刀具组', requester='中控系统')
|
||||
def get_maintenance_tool_groups_Info(self, **kw):
|
||||
"""
|
||||
机床刀具组接口
|
||||
|
||||
@@ -27,6 +27,9 @@ def api_log(name=None, requester=None):
|
||||
|
||||
# 执行原始函数
|
||||
result = func(*args, **kwargs)
|
||||
origin_result = result
|
||||
if isinstance(result, str):
|
||||
result = json.loads(result)
|
||||
|
||||
# 计算响应时间
|
||||
end_time = datetime.now()
|
||||
@@ -41,7 +44,7 @@ def api_log(name=None, requester=None):
|
||||
'response_data': json.dumps(result, ensure_ascii=False),
|
||||
'remote_addr': remote_addr,
|
||||
'response_time': response_time,
|
||||
'status': result.get('code', 500),
|
||||
'status': result.get('code') or result.get('ErrorCode') or 500,
|
||||
'requester': requester,
|
||||
'responser': '智能工厂'
|
||||
}
|
||||
@@ -49,7 +52,7 @@ def api_log(name=None, requester=None):
|
||||
# 异步创建日志记录
|
||||
request.env['api.request.log'].sudo().with_context(tracking_disable=True).create(log_vals)
|
||||
|
||||
return result
|
||||
return origin_result
|
||||
|
||||
except Exception as e:
|
||||
_logger.error(f"API日志记录失败: {str(e)}")
|
||||
|
||||
@@ -1,4 +1,9 @@
|
||||
from odoo import models, fields, api
|
||||
import json, ast
|
||||
import logging
|
||||
import requests
|
||||
|
||||
_logger = logging.getLogger(__name__)
|
||||
|
||||
|
||||
class ApiRequestLog(models.Model):
|
||||
@@ -16,3 +21,52 @@ class ApiRequestLog(models.Model):
|
||||
status = fields.Integer('状态码')
|
||||
requester = fields.Char('请求方')
|
||||
responser = fields.Char('响应方')
|
||||
|
||||
@api.model
|
||||
def log_request(self, method, url, name=None, responser=None, **kwargs):
|
||||
# Log the request
|
||||
request_headers = kwargs.get('headers', {})
|
||||
request_body = kwargs.get('json') or kwargs.get('params') or {}
|
||||
|
||||
_logger.info(f"Request: {method} {url} Headers: {request_headers} Body: {request_body}")
|
||||
|
||||
# Make the actual request
|
||||
response = requests.request(method, url, **kwargs)
|
||||
|
||||
# Log the response
|
||||
response_status = response.status_code
|
||||
response_headers = response.headers
|
||||
response_body = response.text
|
||||
response_time = response.elapsed.total_seconds()
|
||||
|
||||
_logger.info(f"Response: Status: {response_status} Headers: {response_headers} Body: {response_body}")
|
||||
|
||||
try:
|
||||
# 如果是字符串,先尝试用 ast.literal_eval 安全地转换成 Python 对象
|
||||
if isinstance(response_body, str):
|
||||
|
||||
response_body_obj = json.loads(response_body)
|
||||
else:
|
||||
response_body_obj = response_body
|
||||
|
||||
# 再使用 json.dumps 转换成标准的 JSON 字符串
|
||||
response_body = json.dumps(response_body_obj, ensure_ascii=False)
|
||||
except Exception as e:
|
||||
_logger.warning(f"转换 response_body 到标准 JSON 失败: {str(e)}")
|
||||
# 如果转换失败,保持原样
|
||||
|
||||
# Save to database
|
||||
self.sudo().create({
|
||||
'name': name,
|
||||
'path': url,
|
||||
'method': method,
|
||||
'request_data': request_body,
|
||||
'response_data': response_body,
|
||||
'remote_addr': None,
|
||||
'response_time': response_time,
|
||||
'status': response_status,
|
||||
'requester': '智能工厂',
|
||||
'responser': responser
|
||||
})
|
||||
|
||||
return response
|
||||
@@ -24,6 +24,8 @@ class SfProductionProcessParameter(models.Model):
|
||||
obj = super(SfProductionProcessParameter, self).create(vals)
|
||||
return obj
|
||||
def create_service_product(self):
|
||||
if not self.active:
|
||||
return
|
||||
service_categ = self.env.ref(
|
||||
'sf_dlm.product_category_surface_technics_sf').sudo()
|
||||
|
||||
|
||||
@@ -41,7 +41,9 @@
|
||||
attrs="{'invisible': [('categ_type', 'not in', ['成品','坯料', '原材料'])],'readonly': [('id', '!=', False)]}"/>
|
||||
<field name="server_product_process_parameters_id" string="工艺参数"
|
||||
options="{'no_create': True}"
|
||||
attrs="{'invisible': ['|',('detailed_type', '!=', 'service'),('detailed_type', '=', False)]}"/>
|
||||
attrs="{'invisible': ['|',('detailed_type', '!=', 'service'),('detailed_type', '=', False)]}"
|
||||
domain="[('active', '=', 'True'),('outsourced_service_products', '!=', 'True')]"
|
||||
/>
|
||||
<field name="cutting_tool_material_id" class="custom_required"
|
||||
options="{'no_create': True}"
|
||||
attrs="{'invisible': [('categ_type', '!=', '刀具')],'required': [('categ_type', '=', '刀具')],'readonly': [('id', '!=', False)]}"
|
||||
|
||||
@@ -1360,9 +1360,9 @@ class Sf_Dashboard_Connect(http.Controller):
|
||||
if result[0]:
|
||||
if float(result[0]) >= 28800:
|
||||
continue
|
||||
alarm_last_24_time = float(result[0])
|
||||
alarm_last_24_time += float(result[0])
|
||||
else:
|
||||
alarm_last_24_time = 0.0
|
||||
alarm_last_24_time += 0.0
|
||||
|
||||
alarm_all_nums = []
|
||||
with conn.cursor() as cur:
|
||||
|
||||
@@ -261,8 +261,50 @@ def transfer_files(
|
||||
target_path = f"{target_dir}/{relative_path}/{item}"
|
||||
else:
|
||||
target_path = f"{target_dir}/{item}"
|
||||
with open(temp_path, 'rb') as f:
|
||||
target_ftp.ftp.storbinary(f'STOR {target_path}', f)
|
||||
|
||||
# 规范化路径
|
||||
target_path = target_path.replace('\\', '/').strip('/')
|
||||
|
||||
# 确保目标目录存在
|
||||
target_dir_path = '/'.join(target_path.split('/')[:-1])
|
||||
try:
|
||||
target_ftp.ftp.cwd('/') # 回到根目录
|
||||
for dir_part in target_dir_path.split('/'):
|
||||
if dir_part:
|
||||
try:
|
||||
target_ftp.ftp.cwd(dir_part)
|
||||
except:
|
||||
try:
|
||||
target_ftp.ftp.mkd(dir_part)
|
||||
target_ftp.ftp.cwd(dir_part)
|
||||
except Exception as e:
|
||||
logging.error(f"创建目录失败 {dir_part}: {str(e)}")
|
||||
raise
|
||||
except Exception as e:
|
||||
logging.error(f"处理目标目录失败: {str(e)}")
|
||||
raise
|
||||
|
||||
# 检查FTP连接状态
|
||||
try:
|
||||
target_ftp.ftp.voidcmd('NOOP')
|
||||
except:
|
||||
logging.error("FTP连接已断开,尝试重新连接")
|
||||
target_ftp.ftp.connect(target_ftp_info['host'], target_ftp_info['port'])
|
||||
target_ftp.ftp.login(target_ftp_info['username'], target_ftp_info['password'])
|
||||
|
||||
# 上传文件
|
||||
try:
|
||||
with open(temp_path, 'rb') as f:
|
||||
# 检查文件是否可读
|
||||
content = f.read()
|
||||
if not content:
|
||||
raise Exception("临时文件为空")
|
||||
f.seek(0) # 重置文件指针
|
||||
target_ftp.ftp.storbinary(f'STOR {target_path}', f)
|
||||
except Exception as e:
|
||||
logging.error(f"上传文件失败: {str(e)}")
|
||||
logging.error(f"目标路径: {target_path}")
|
||||
raise
|
||||
|
||||
transfered_file_list.append(item)
|
||||
# 删除临时文件
|
||||
@@ -270,37 +312,37 @@ def transfer_files(
|
||||
logging.info(f"已传输文件: {item}")
|
||||
|
||||
# 清空目标目录下的所有内容
|
||||
try:
|
||||
target_ftp.ftp.cwd(target_dir)
|
||||
files = target_ftp.ftp.nlst()
|
||||
# try:
|
||||
# target_ftp.ftp.cwd(target_dir)
|
||||
# files = target_ftp.ftp.nlst()
|
||||
|
||||
for f in files:
|
||||
try:
|
||||
# 尝试删除文件
|
||||
target_ftp.ftp.delete(f)
|
||||
except:
|
||||
try:
|
||||
# 如果删除失败,可能是目录,递归删除目录
|
||||
def remove_dir(path):
|
||||
target_ftp.ftp.cwd(path)
|
||||
sub_files = target_ftp.ftp.nlst()
|
||||
for sf in sub_files:
|
||||
try:
|
||||
target_ftp.ftp.delete(sf)
|
||||
except:
|
||||
remove_dir(f"{path}/{sf}")
|
||||
target_ftp.ftp.cwd('..')
|
||||
target_ftp.ftp.rmd(path)
|
||||
# for f in files:
|
||||
# try:
|
||||
# # 尝试删除文件
|
||||
# target_ftp.ftp.delete(f)
|
||||
# except:
|
||||
# try:
|
||||
# # 如果删除失败,可能是目录,递归删除目录
|
||||
# def remove_dir(path):
|
||||
# target_ftp.ftp.cwd(path)
|
||||
# sub_files = target_ftp.ftp.nlst()
|
||||
# for sf in sub_files:
|
||||
# try:
|
||||
# target_ftp.ftp.delete(sf)
|
||||
# except:
|
||||
# remove_dir(f"{path}/{sf}")
|
||||
# target_ftp.ftp.cwd('..')
|
||||
# target_ftp.ftp.rmd(path)
|
||||
|
||||
remove_dir(f"{target_dir}/{f}")
|
||||
except:
|
||||
logging.error(f"无法删除 {f}")
|
||||
pass
|
||||
# remove_dir(f"{target_dir}/{f}")
|
||||
# except:
|
||||
# logging.error(f"无法删除 {f}")
|
||||
# pass
|
||||
|
||||
logging.info(f"已清空目标目录 {target_dir}")
|
||||
except Exception as e:
|
||||
logging.error(f"清空目标目录失败: {str(e)}")
|
||||
raise Exception(f"清空目标目录失败: {str(e)}")
|
||||
# logging.info(f"已清空目标目录 {target_dir}")
|
||||
# except Exception as e:
|
||||
# logging.error(f"清空目标目录失败: {str(e)}")
|
||||
# raise Exception(f"清空目标目录失败: {str(e)}")
|
||||
|
||||
# 开始遍历
|
||||
traverse_dir(source_dir)
|
||||
|
||||
@@ -48,6 +48,7 @@
|
||||
'views/mrp_workorder_batch_replan.xml',
|
||||
'views/purchase_order_view.xml',
|
||||
'views/product_template_views.xml',
|
||||
'views/stock_warehouse_orderpoint.xml',
|
||||
],
|
||||
'assets': {
|
||||
|
||||
|
||||
@@ -6,12 +6,14 @@ from datetime import datetime
|
||||
from odoo.addons.sf_manufacturing.models.agv_scheduling import RepeatTaskException
|
||||
from odoo import http
|
||||
from odoo.http import request
|
||||
from odoo.addons.sf_base.decorators.api_log import api_log
|
||||
|
||||
|
||||
class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/GetWoInfo', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('获取工单', requester='中控系统')
|
||||
def get_Work_Info(self, **kw):
|
||||
"""
|
||||
自动化传递工单号获取工单信息
|
||||
@@ -107,6 +109,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/QcCheck', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('工件预调(前置三元检测)', requester='中控系统')
|
||||
def get_qcCheck(self, **kw):
|
||||
"""
|
||||
工件预调(前置三元检测)
|
||||
@@ -149,6 +152,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/FeedBackStart', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('工单开始', requester='中控系统')
|
||||
def button_Work_START(self, **kw):
|
||||
"""
|
||||
工单任务开始
|
||||
@@ -198,6 +202,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/FeedBackEnd', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('工单结束', requester='中控系统')
|
||||
def button_Work_End(self, **kw):
|
||||
"""
|
||||
工单任务结束
|
||||
@@ -249,6 +254,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/PartQualityInspect', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('零件检测(后置三元检测)', requester='中控系统')
|
||||
def PartQualityInspect(self, **kw):
|
||||
"""
|
||||
零件质检
|
||||
@@ -295,6 +301,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/CMMProgDolod', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('CMM测量程序下载', requester='中控系统')
|
||||
def CMMProgDolod(self, **kw):
|
||||
"""
|
||||
中控系统传递RFID编号给MES,获取测量程序文件。Ftp下载文件
|
||||
@@ -335,6 +342,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/NCProgDolod', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('CAM加工程序下载', requester='中控系统')
|
||||
def NCProgDolod(self, **kw):
|
||||
"""
|
||||
中控系统传递RFID编号给MES,获取程序单及程序文件。Ftp下载文件
|
||||
@@ -376,6 +384,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/LocationChange', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('库位变更', requester='中控系统')
|
||||
def LocationChange(self, **kw):
|
||||
"""
|
||||
库位变更
|
||||
@@ -480,6 +489,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/AGVToProduct', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('AGV运送上产线', requester='中控系统')
|
||||
def AGVToProduct(self, **kw):
|
||||
"""
|
||||
AGV运送上产线(完成)
|
||||
@@ -552,6 +562,7 @@ class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/AGVDownProduct', type='json', auth='none', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('AGV运送下产线', requester='中控系统')
|
||||
def AGVDownProduct(self, **kw):
|
||||
"""
|
||||
MES调度AGV,搬运零件AGV托盘到产线接驳站。
|
||||
|
||||
@@ -18,3 +18,4 @@ from . import quick_easy_order
|
||||
from . import purchase_order
|
||||
from . import quality_check
|
||||
from . import purchase_request_line
|
||||
from . import stock_warehouse_orderpoint
|
||||
@@ -928,7 +928,9 @@ class MrpProduction(models.Model):
|
||||
'sf_stock.stock_route_process_outsourcing').id)]
|
||||
for product_id, request_line_list in grouped_purchase_request_line_sorted_list.items():
|
||||
cur_request_line = request_line_list[0]
|
||||
cur_request_line['product_qty'] = len(request_line_list)
|
||||
if cur_request_line['product_qty'] == 1:
|
||||
cur_request_line['product_qty'] = len(request_line_list)
|
||||
# cur_request_line['product_qty'] = cur_request_line['product_qty']
|
||||
cur_request_line['request_id'] = pr.id
|
||||
cur_request_line['origin'] = ", ".join({item['production_name'] for item in request_line_list if item.get('production_name')})
|
||||
cur_request_line.pop('group_id', None)
|
||||
|
||||
@@ -85,6 +85,7 @@ class ResMrpWorkOrder(models.Model):
|
||||
item.pr_mp_count = len(pr_ids)
|
||||
else:
|
||||
item.pr_mp_count = 0
|
||||
|
||||
@api.depends('state')
|
||||
def _compute_back_button_display(self):
|
||||
for record in self:
|
||||
@@ -442,21 +443,11 @@ class ResMrpWorkOrder(models.Model):
|
||||
@api.depends('state', 'production_id.name')
|
||||
def _compute_surface_technics_purchase_ids(self):
|
||||
for order in self:
|
||||
if order.routing_type == '表面工艺' and order.state not in ['cancel']:
|
||||
# domain = [('group_id', '=', self.production_id.procurement_group_id.id),
|
||||
# ('purchase_type', '=', 'consignment'), ('state', '!=', 'cancel')]
|
||||
domain = [('purchase_type', '=', 'consignment'),
|
||||
('origin', 'like', '%' + self.production_id.name + '%'),
|
||||
('state', '!=', 'cancel')]
|
||||
purchase = self.env['purchase.order'].search(domain)
|
||||
order.surface_technics_purchase_count = 0
|
||||
if not purchase:
|
||||
order.surface_technics_purchase_count = 0
|
||||
for po in purchase:
|
||||
if any(
|
||||
line.product_id and line.product_id.server_product_process_parameters_id == order.surface_technics_parameters_id
|
||||
for line in po.order_line):
|
||||
order.surface_technics_purchase_count = 1
|
||||
pr_ids = self.env['purchase.request'].sudo().search(
|
||||
[('origin', 'like', self.production_id.name), ('is_subcontract', '=', 'True'),
|
||||
('state', '!=', 'rejected')])
|
||||
if pr_ids.purchase_count:
|
||||
order.surface_technics_purchase_count = pr_ids.purchase_count
|
||||
else:
|
||||
order.surface_technics_purchase_count = 0
|
||||
|
||||
@@ -484,6 +475,7 @@ class ResMrpWorkOrder(models.Model):
|
||||
'view_mode': 'tree,form',
|
||||
})
|
||||
return action
|
||||
|
||||
def action_view_surface_technics_purchase(self):
|
||||
self.ensure_one()
|
||||
# if self.routing_type == '表面工艺':
|
||||
@@ -500,22 +492,26 @@ class ResMrpWorkOrder(models.Model):
|
||||
# if technology_design.is_auto is False:
|
||||
# domain = [('origin', '=', self.production_id.name)]
|
||||
# else:
|
||||
purchase_orders_id = self._get_surface_technics_purchase_ids()
|
||||
result = {
|
||||
"type": "ir.actions.act_window",
|
||||
"res_model": "purchase.order",
|
||||
"res_id": purchase_orders_id.id,
|
||||
# "domain": [['id', 'in', self.purchase_id]],
|
||||
"name": _("Purchase Orders"),
|
||||
'view_mode': 'form',
|
||||
}
|
||||
return result
|
||||
pr_ids = self.env['purchase.request'].sudo().search(
|
||||
[('origin', 'like', self.production_id.name), ('is_subcontract', '=', 'True'),
|
||||
('state', '!=', 'rejected')])
|
||||
# purchase_orders_id = self._get_surface_technics_purchase_ids()
|
||||
# result = {
|
||||
# "type": "ir.actions.act_window",
|
||||
# "res_model": "purchase.order",
|
||||
# "res_id": purchase_orders_id.id,
|
||||
# # "domain": [['id', 'in', self.purchase_id]],
|
||||
# "name": _("Purchase Orders"),
|
||||
# 'view_mode': 'form',
|
||||
# }
|
||||
return pr_ids.action_view_purchase_order()
|
||||
|
||||
def _get_surface_technics_purchase_ids(self):
|
||||
domain = [('origin', 'like', '%' + self.production_id.name + '%'), ('purchase_type', '=', 'consignment')]
|
||||
domain = [('origin', 'like', '%' + self.production_id.name + '%'), ('purchase_type', '=', 'consignment'),
|
||||
('state', '!=', 'cancel')]
|
||||
# domain = [('origin', 'like', '%' + self.production_id.name + '%'), ('purchase_type', '=', 'consignment')]
|
||||
# domain = [('group_id', '=', self.production_id.procurement_group_id.id), ('purchase_type', '=', 'consignment')]
|
||||
purchase_orders = self.env['purchase.order'].search(domain, order='id desc', # 按创建时间降序(最新的在前)
|
||||
limit=1)
|
||||
purchase_orders = self.env['purchase.order'].search(domain, order='id desc')
|
||||
purchase_orders_id = self.env['purchase.order']
|
||||
for po in purchase_orders:
|
||||
for line in po.order_line:
|
||||
@@ -1242,6 +1238,13 @@ class ResMrpWorkOrder(models.Model):
|
||||
}]
|
||||
return workorders_values_str
|
||||
|
||||
def check_lot_exists(self, picking_id, lot_id):
|
||||
return bool(
|
||||
picking_id.move_ids.move_line_ids.filtered(
|
||||
lambda line: line.lot_id.id == lot_id
|
||||
)
|
||||
)
|
||||
|
||||
def _process_compute_state(self):
|
||||
sorted_workorders = sorted(self, key=lambda x: x.sequence)
|
||||
for workorder in sorted_workorders:
|
||||
@@ -1263,20 +1266,37 @@ class ResMrpWorkOrder(models.Model):
|
||||
workorder.state = 'pending'
|
||||
continue
|
||||
# ================= 如果制造订单制造类型为【人工线下加工】==========================
|
||||
# lot_id = workorder.production_id.move_raw_ids.move_line_ids.lot_id
|
||||
# picking_ids = workorder.production_id.picking_ids.filtered(
|
||||
# lambda wk: wk.location_id.name == '外协收料区' and wk.location_dest_id.name == '制造前')
|
||||
# exists = any(
|
||||
# move_line.lot_id == lot_id
|
||||
# for picking in picking_ids
|
||||
# for move in picking.move_ids
|
||||
# for move_line in move.move_line_ids
|
||||
# )
|
||||
if (workorder.production_id.production_type == '人工线下加工'
|
||||
and workorder.production_id.schedule_state == '已排'
|
||||
and len(workorder.production_id.picking_ids.filtered(
|
||||
lambda w: w.state not in ['done', 'cancel'])) == 0):
|
||||
and workorder.production_id.programming_state == '已编程'):
|
||||
# and workorder.production_id.programming_state == '已编程'
|
||||
if workorder.is_subcontract is True:
|
||||
if workorder.production_id.state == 'rework':
|
||||
workorder.state = 'waiting'
|
||||
continue
|
||||
purchase_orders_id = self._get_surface_technics_purchase_ids()
|
||||
if purchase_orders_id.state == 'purchase':
|
||||
purchase_count = 0
|
||||
for purchase_order in purchase_orders_id:
|
||||
for purchase_order_line in purchase_order.order_line:
|
||||
if purchase_order_line.product_id.server_product_process_parameters_id.id == workorder.surface_technics_parameters_id.id:
|
||||
purchase_count = purchase_order_line.product_qty
|
||||
if purchase_orders_id.state == 'purchase' and purchase_count>=workorder.production_id.product_qty:
|
||||
workorder.state = 'ready'
|
||||
move_out = workorder.move_subcontract_workorder_ids[1]
|
||||
picking_id = workorder.production_id.picking_ids.filtered(
|
||||
lambda wk: wk.location_id.name == '制造前' and wk.location_dest_id.name == '外协加工区')
|
||||
move_out = picking_id.move_ids
|
||||
# move_out = workorder.move_subcontract_workorder_ids[1]
|
||||
for mo in move_out:
|
||||
if workorder.production_id.bom_id.bom_line_ids.product_id.id != mo.product_id.id:
|
||||
continue
|
||||
if mo.state != 'done':
|
||||
mo.write({'state': 'assigned', 'production_id': False})
|
||||
if not mo.move_line_ids:
|
||||
@@ -1292,6 +1312,7 @@ class ResMrpWorkOrder(models.Model):
|
||||
else:
|
||||
workorder.state = 'ready'
|
||||
continue
|
||||
continue
|
||||
# ================= 如果制造订单刀具状态为[无效刀、缺刀] 或者 制造订单状态为[返工]==========================
|
||||
if (workorder.production_id.tool_state in ['1', '2'] or workorder.production_id.state == 'rework'
|
||||
or workorder.production_id.schedule_state != '已排'
|
||||
@@ -1307,15 +1328,18 @@ class ResMrpWorkOrder(models.Model):
|
||||
if workorder.is_subcontract is False:
|
||||
workorder.state = 'ready'
|
||||
else:
|
||||
if len(workorder.production_id.picking_ids.filtered(
|
||||
lambda w: w.state not in ['done',
|
||||
'cancel'])) == 0 and workorder.production_id.programming_state == '已编程':
|
||||
if workorder.production_id.programming_state == '已编程':
|
||||
purchase_orders_id = self._get_surface_technics_purchase_ids()
|
||||
if purchase_orders_id:
|
||||
if purchase_orders_id.state == 'purchase':
|
||||
workorder.state = 'ready'
|
||||
move_out = workorder.move_subcontract_workorder_ids[1]
|
||||
picking_id = workorder.production_id.picking_ids.filtered(
|
||||
lambda
|
||||
wk: wk.location_id.name == '制造前' and wk.location_dest_id.name == '外协加工区')
|
||||
move_out = picking_id.move_ids
|
||||
for mo in move_out:
|
||||
if workorder.production_id.bom_id.bom_line_ids.product_id.id != mo.product_id.id:
|
||||
continue
|
||||
if mo.state != 'done':
|
||||
mo.write({'state': 'assigned', 'production_id': False})
|
||||
if not mo.move_line_ids:
|
||||
@@ -1324,7 +1348,6 @@ class ResMrpWorkOrder(models.Model):
|
||||
else:
|
||||
workorder.state = 'waiting'
|
||||
|
||||
|
||||
@api.depends('production_availability', 'blocked_by_workorder_ids', 'blocked_by_workorder_ids.state',
|
||||
'production_id.tool_state', 'production_id.schedule_state', 'sequence',
|
||||
'production_id.programming_state')
|
||||
@@ -1356,16 +1379,25 @@ class ResMrpWorkOrder(models.Model):
|
||||
# 判断是否有坯料的序列号信息
|
||||
boolean = False
|
||||
if self.production_id.move_raw_ids:
|
||||
if self.production_id.move_raw_ids[0].product_id.categ_type == '坯料':
|
||||
if self.production_id.move_raw_ids[0].product_id.categ_type == '坯料' and \
|
||||
self.production_id.move_raw_ids[0].product_id.tracking == 'serial':
|
||||
if self.production_id.move_raw_ids[0].move_line_ids:
|
||||
if self.production_id.move_raw_ids[0].move_line_ids:
|
||||
if self.production_id.move_raw_ids[0].move_line_ids[0].lot_id.name:
|
||||
boolean = True
|
||||
if self.production_id.move_raw_ids[0].move_line_ids[0].lot_id.name:
|
||||
boolean = True
|
||||
else:
|
||||
boolean = True
|
||||
if not boolean:
|
||||
raise UserError('制造订单【%s】缺少组件的序列号信息!' % self.production_id.name)
|
||||
self.pro_code = self.production_id.move_raw_ids[0].move_line_ids[0].lot_id.name
|
||||
self.pro_code = False # 默认值
|
||||
if (
|
||||
self.production_id
|
||||
and self.production_id.move_raw_ids
|
||||
and len(self.production_id.move_raw_ids) > 0
|
||||
and self.production_id.move_raw_ids[0].move_line_ids
|
||||
and len(self.production_id.move_raw_ids[0].move_line_ids) > 0
|
||||
and self.production_id.move_raw_ids[0].move_line_ids[0].lot_id
|
||||
):
|
||||
self.pro_code = self.production_id.move_raw_ids[0].move_line_ids[0].lot_id.name
|
||||
# cnc校验
|
||||
if self.production_id.production_type == '自动化产线加工':
|
||||
cnc_workorder = self.search(
|
||||
@@ -1389,7 +1421,10 @@ class ResMrpWorkOrder(models.Model):
|
||||
# 表面工艺外协出库单
|
||||
if self.routing_type == '表面工艺':
|
||||
if self.is_subcontract is True:
|
||||
move_out = self.move_subcontract_workorder_ids[1]
|
||||
picking_id = self.production_id.picking_ids.filtered(
|
||||
lambda wk: wk.location_id.name == '制造前' and wk.location_dest_id.name == '外协加工区')
|
||||
move_out = picking_id.move_ids
|
||||
# move_out = self.move_subcontract_workorder_ids[1]
|
||||
# move_out = self.env['stock.move'].search(
|
||||
# [('location_id', '=', self.env['stock.location'].search(
|
||||
# [('barcode', 'ilike', 'WH-PREPRODUCTION')]).id),
|
||||
@@ -1397,6 +1432,8 @@ class ResMrpWorkOrder(models.Model):
|
||||
# [('barcode', 'ilike', 'VL-SPOC')]).id),
|
||||
# ('origin', '=', self.production_id.name), ('state', 'not in', ['cancel', 'done'])])
|
||||
for mo in move_out:
|
||||
if self.production_id.bom_id.bom_line_ids.product_id.id != mo.product_id.id:
|
||||
continue
|
||||
if mo.state != 'done':
|
||||
mo.write({'state': 'assigned', 'production_id': False})
|
||||
if not mo.move_line_ids:
|
||||
@@ -1529,7 +1566,8 @@ class ResMrpWorkOrder(models.Model):
|
||||
lambda wo: wo.is_subcontract == True and wo.state != 'cancel').sorted('sequence')
|
||||
if self == subcontract_workorders[-1]:
|
||||
# 给下一个库存移动就绪
|
||||
self.move_subcontract_workorder_ids[0].move_dest_ids._action_done()
|
||||
if self.move_subcontract_workorder_ids:
|
||||
self.move_subcontract_workorder_ids[0].move_dest_ids._action_done()
|
||||
# self.production_id.button_mark_done()
|
||||
tem_date_planned_finished = record.date_planned_finished
|
||||
tem_date_finished = record.date_finished
|
||||
|
||||
@@ -1030,6 +1030,7 @@ class ResProductMo(models.Model):
|
||||
'single_manufacturing': product_id.single_manufacturing,
|
||||
'is_bfm': True,
|
||||
'active': True,
|
||||
'tracking': finish_product.tracking, # 坯料的跟踪方式跟随成品
|
||||
}
|
||||
# 外协和采购生成的坯料需要根据材料型号绑定供应商
|
||||
if route_type == 'subcontract' or route_type == 'purchase':
|
||||
|
||||
@@ -113,24 +113,26 @@ class PurchaseOrder(models.Model):
|
||||
# production.bom_id.bom_line_ids.product_id
|
||||
location_id = self.env['stock.location'].search([('name', '=', '制造前')])
|
||||
quants = self.env['stock.quant'].search([
|
||||
('product_id', '=', product_id),
|
||||
('product_id', '=', productions.bom_id.bom_line_ids.product_id.id),
|
||||
('location_id', '=', location_id.id)
|
||||
])
|
||||
total_qty = sum(quants.mapped('quantity')) # 计算该位置的总库存量
|
||||
is_available = total_qty > 0
|
||||
if not is_available:
|
||||
continue
|
||||
raise UserError('请先完成坯料入库')
|
||||
for production_id in productions:
|
||||
work_ids = production_id.workorder_ids.filtered(
|
||||
lambda wk: wk.state not in ['done', 'rework', 'cancel'])
|
||||
if not work_ids:
|
||||
continue
|
||||
min_sequence_wk = min(work_ids, key=lambda wk: wk.sequence)
|
||||
if min_sequence_wk.is_subcontract:
|
||||
if min_sequence_wk.is_subcontract and min_sequence_wk.state == 'ready':
|
||||
picking_id = production_id.picking_ids.filtered(
|
||||
lambda wk: wk.location_id.name == '制造前' and wk.location_dest_id.name == '外协加工区')
|
||||
move_out = picking_id.move_id
|
||||
move_out = picking_id.move_ids
|
||||
for mo in move_out:
|
||||
if production_id.bom_id.bom_line_ids.product_id.id != mo.product_id.id:
|
||||
continue
|
||||
if mo.state != 'done':
|
||||
mo.write({'state': 'assigned', 'production_id': False})
|
||||
if not mo.move_line_ids:
|
||||
@@ -147,7 +149,16 @@ class PurchaseOrder(models.Model):
|
||||
if line.price_unit <= 0:
|
||||
raise UserError('请对【产品】中的【单价】进行输入')
|
||||
record.outsourcing_service_replenishment()
|
||||
return super(PurchaseOrder, self).button_confirm()
|
||||
|
||||
res = super(PurchaseOrder, self).button_confirm()
|
||||
|
||||
for line in self.order_line:
|
||||
# 将产品不追踪序列号的行项目设置qty_done
|
||||
if not line.move_ids:
|
||||
continue
|
||||
if line.move_ids and line.move_ids[0].product_id.tracking == 'none':
|
||||
line.move_ids[0].quantity_done = line.move_ids[0].product_qty
|
||||
return res
|
||||
|
||||
|
||||
origin_sale_id = fields.Many2one('sale.order', string='销售订单号', store=True, compute='_compute_origin_sale_id')
|
||||
@@ -217,6 +228,24 @@ class PurchaseOrderLine(models.Model):
|
||||
)
|
||||
record.part_number = filtered_order_line.product_id.part_number
|
||||
record.part_name = filtered_order_line.product_id.part_name
|
||||
elif record.order_id.purchase_type == 'consignment':
|
||||
product_name = ''
|
||||
match = re.search(r'(S\d{5}-\d)', record.related_product.name)
|
||||
# 如果匹配成功,提取结果
|
||||
if match:
|
||||
product_name = match.group(0)
|
||||
sale_order_name = ''
|
||||
match_sale = re.search(r'S(\d+)', record.related_product.name)
|
||||
if match_sale:
|
||||
sale_order_name = match_sale.group(0)
|
||||
sale_order = self.env['sale.order'].sudo().search(
|
||||
[('name', '=', sale_order_name)])
|
||||
if sale_order:
|
||||
filtered_order_line = sale_order.order_line.filtered(
|
||||
lambda order_line: re.search(f'{product_name}$', order_line.product_id.name)
|
||||
)
|
||||
record.part_number = filtered_order_line.product_id.part_number
|
||||
record.part_name = filtered_order_line.product_id.part_name
|
||||
else:
|
||||
record.part_number = record.product_id.part_number
|
||||
record.part_name = record.product_id.part_name
|
||||
|
||||
@@ -59,6 +59,7 @@ class SaleOrder(models.Model):
|
||||
line.product_id.product_tmpl_id.copy_template(product_template_id)
|
||||
# 将模板上的single_manufacturing属性复制到成品上
|
||||
line.product_id.single_manufacturing = product_template_id.single_manufacturing
|
||||
line.product_id.tracking = product_template_id.tracking
|
||||
|
||||
order_id = self
|
||||
product = line.product_id
|
||||
|
||||
@@ -2,7 +2,7 @@
|
||||
import logging
|
||||
from odoo import fields, models, api
|
||||
from odoo.exceptions import UserError, ValidationError
|
||||
from odoo.tools import str2bool
|
||||
# from odoo.tools import str2bool
|
||||
|
||||
|
||||
class SfProductionProcessParameter(models.Model):
|
||||
@@ -20,13 +20,6 @@ class SfProductionProcessParameter(models.Model):
|
||||
is_product_button = fields.Boolean(compute='_compute_is_product_button',default=False)
|
||||
is_delete_button = fields.Boolean(compute='_compute_is_delete_button', default=False)
|
||||
routing_id = fields.Many2one('mrp.routing.workcenter', string="工序")
|
||||
|
||||
@api.depends('outsourced_service_products')
|
||||
def _compute_service_products(self):
|
||||
for record in self:
|
||||
# 假设取第一条作为主明细
|
||||
record.service_products = record.outsourced_service_products.id if record.outsourced_service_products else False
|
||||
|
||||
def _inverse_service_products(self):
|
||||
for record in self:
|
||||
if record.service_products:
|
||||
@@ -34,6 +27,12 @@ class SfProductionProcessParameter(models.Model):
|
||||
record.outsourced_service_products = record.service_products.ids if record.service_products else False
|
||||
else:
|
||||
record.outsourced_service_products = False
|
||||
@api.depends('outsourced_service_products')
|
||||
def _compute_service_products(self):
|
||||
for record in self:
|
||||
# 假设取第一条作为主明细
|
||||
record.service_products = record.outsourced_service_products[0].id if record.outsourced_service_products else False
|
||||
|
||||
def name_get(self):
|
||||
result = []
|
||||
for record in self:
|
||||
|
||||
@@ -631,28 +631,62 @@ class StockPicking(models.Model):
|
||||
move.action_clear_lines_show_details()
|
||||
move.action_show_details()
|
||||
res = super().button_validate()
|
||||
picking_type_in = self.env.ref('sf_manufacturing.outcontract_picking_in').id
|
||||
if res is True and self.picking_type_id.id == picking_type_in:
|
||||
lot_ids = None
|
||||
product_ids = self.move_ids.mapped('product_id')
|
||||
if not self.move_ids[0].product_id.single_manufacturing and self.move_ids[0].product_id.tracking == 'none':
|
||||
lot_ids = self.move_ids.move_line_ids.mapped('lot_id')
|
||||
production_ids = self.sale_order_id.mrp_production_ids if self.sale_order_id else self.env['mrp.production']
|
||||
if res and self.location_id.name == '外协收料区' and self.location_dest_id.name == '制造前':
|
||||
# 如果是最后一张外协入库单,则设置库存位置的预留数量
|
||||
move_in = self.move_ids
|
||||
if move_in:
|
||||
workorder = move_in.subcontract_workorder_id
|
||||
workorders = workorder.production_id.workorder_ids
|
||||
subcontract_workorders = workorders.filtered(
|
||||
lambda wo: wo.is_subcontract == True and wo.state != 'cancel').sorted('sequence')
|
||||
# if workorder == subcontract_workorders[-1]:
|
||||
# self.env['stock.quant']._update_reserved_quantity(
|
||||
# move_in.product_id, move_in.location_dest_id, move_in.product_uom_qty,
|
||||
# lot_id=move_in.move_line_ids.lot_id,
|
||||
# package_id=False, owner_id=False, strict=False
|
||||
# )
|
||||
workorder.button_finish()
|
||||
picking_type_out = self.env.ref('sf_manufacturing.outcontract_picking_out').id
|
||||
if res and self.picking_type_id.id == picking_type_out:
|
||||
move_out = self.move_ids
|
||||
if move_out:
|
||||
workorder = move_out.subcontract_workorder_id
|
||||
workorder.button_start()
|
||||
for production_id in production_ids:
|
||||
if lot_ids:
|
||||
lot_id = production_id.move_raw_ids.move_line_ids.lot_id
|
||||
# picking_ids = production_id.picking_ids.filtered(
|
||||
# lambda wk: wk.location_id.name == '外协收料区' and wk.location_dest_id.name == '制造前')
|
||||
if lot_id in lot_ids:
|
||||
workorder_id = production_id.workorder_ids.filtered(
|
||||
lambda a: a.state == 'progress' and a.is_subcontract)
|
||||
if not workorder_id:
|
||||
continue
|
||||
workorder_id.button_finish()
|
||||
else:
|
||||
workorder_id = production_id.workorder_ids.filtered(lambda a: a.state == 'progress' and a.is_subcontract)
|
||||
if not workorder_id:
|
||||
continue
|
||||
workorder_id.button_finish()
|
||||
# lot_id = workorder.production_id.move_raw_ids.move_line_ids.lot_id
|
||||
# picking_ids = workorder.production_id.picking_ids.filtered(
|
||||
# lambda wk: wk.location_id.name == '外协收料区' and wk.location_dest_id.name == '制造前')
|
||||
|
||||
# if move_in:
|
||||
# workorder = move_in.subcontract_workorder_id
|
||||
# workorders = workorder.production_id.workorder_ids
|
||||
# subcontract_workorders = workorders.filtered(
|
||||
# lambda wo: wo.is_subcontract == True and wo.state != 'cancel').sorted('sequence')
|
||||
# # if workorder == subcontract_workorders[-1]:
|
||||
# # self.env['stock.quant']._update_reserved_quantity(
|
||||
# # move_in.product_id, move_in.location_dest_id, move_in.product_uom_qty,
|
||||
# # lot_id=move_in.move_line_ids.lot_id,
|
||||
# # package_id=False, owner_id=False, strict=False
|
||||
# # )
|
||||
# workorder.button_finish()
|
||||
if res and self.location_id.name == '制造前' and self.location_dest_id.name == '外协加工区':
|
||||
for production_id in production_ids:
|
||||
if lot_ids:
|
||||
lot_id = production_id.move_raw_ids.move_line_ids.lot_id
|
||||
# picking_ids = production_id.picking_ids.filtered(
|
||||
# lambda wk: wk.location_id.name == '外协收料区' and wk.location_dest_id.name == '制造前')
|
||||
if lot_id in lot_ids:
|
||||
workorder_id = production_id.workorder_ids.filtered(
|
||||
lambda a: a.state == 'progress' and a.is_subcontract)
|
||||
if not workorder_id:
|
||||
continue
|
||||
workorder_id.button_finish()
|
||||
else:
|
||||
workorder_id = production_id.workorder_ids.filtered(lambda a: a.state == 'ready' and a.is_subcontract)
|
||||
if not workorder_id:
|
||||
continue
|
||||
workorder_id.button_start()
|
||||
if self.location_id.name == '成品存货区' and self.location_dest_id.name == '客户':
|
||||
sale_id = self.env['sale.order'].sudo().search(
|
||||
[('name', '=', self.origin)])
|
||||
@@ -675,6 +709,7 @@ class StockPicking(models.Model):
|
||||
|
||||
# 创建 外协出库入单
|
||||
def create_outcontract_picking(self, workorders, item, sorted_workorders):
|
||||
production = workorders[0].production_id
|
||||
for workorder in workorders:
|
||||
if workorder.move_subcontract_workorder_ids:
|
||||
workorder.move_subcontract_workorder_ids.write({'state': 'cancel'})
|
||||
@@ -706,7 +741,7 @@ class StockPicking(models.Model):
|
||||
})
|
||||
moves_in = self.env['stock.move'].sudo().with_context(context).create(
|
||||
self.env['stock.move']._get_stock_move_values_Res(item, outcontract_picking_type_in,
|
||||
procurement_group_id.id, move_dest_id))
|
||||
procurement_group_id.id, move_dest_id, production.product_uom_qty))
|
||||
picking_in = self.create(
|
||||
moves_in._get_new_picking_values_Res(item, workorder, 'WH/OCIN/'))
|
||||
# pick_ids.append(picking_in.id)
|
||||
@@ -716,7 +751,7 @@ class StockPicking(models.Model):
|
||||
# self.env.context.get('default_production_id')
|
||||
moves_out = self.env['stock.move'].sudo().with_context(context).create(
|
||||
self.env['stock.move']._get_stock_move_values_Res(item, outcontract_picking_type_out,
|
||||
procurement_group_id.id, moves_in.id))
|
||||
procurement_group_id.id, moves_in.id, production.product_uom_qty))
|
||||
workorder.write({'move_subcontract_workorder_ids': [(6, 0, [moves_in.id, moves_out.id])]})
|
||||
picking_out = self.create(
|
||||
moves_out._get_new_picking_values_Res(item, workorder, 'WH/OCOUT/'))
|
||||
@@ -848,7 +883,7 @@ class ReStockMove(models.Model):
|
||||
traceback_error = traceback.format_exc()
|
||||
logging.error("零件图号 零件名称获取失败:%s" % traceback_error)
|
||||
|
||||
def _get_stock_move_values_Res(self, item, picking_type_id, group_id, move_dest_ids=False):
|
||||
def _get_stock_move_values_Res(self, item, picking_type_id, group_id, move_dest_ids=False, product_uom_qty=1.0):
|
||||
route_id = self.env.ref('sf_manufacturing.route_surface_technology_outsourcing').id
|
||||
stock_rule = self.env['stock.rule'].sudo().search(
|
||||
[('route_id', '=', route_id), ('picking_type_id', '=', picking_type_id)])
|
||||
@@ -857,7 +892,7 @@ class ReStockMove(models.Model):
|
||||
'company_id': item.company_id.id,
|
||||
'product_id': item.bom_id.bom_line_ids.product_id.id,
|
||||
'product_uom': item.bom_id.bom_line_ids.product_uom_id.id,
|
||||
'product_uom_qty': 1.0,
|
||||
'product_uom_qty': product_uom_qty,
|
||||
'location_id': stock_rule.location_src_id.id,
|
||||
'location_dest_id': stock_rule.location_dest_id.id,
|
||||
'origin': item.name,
|
||||
@@ -895,6 +930,8 @@ class ReStockMove(models.Model):
|
||||
}
|
||||
|
||||
def get_move_line(self, production_id, sorted_workorders):
|
||||
# if not self.move_ids[0].product_id.single_manufacturing and self.move_ids[0].product_id.tracking == 'none':
|
||||
qty = production_id.product_qty
|
||||
return {
|
||||
'move_id': self.id,
|
||||
'product_id': self.product_id.id,
|
||||
@@ -902,7 +939,7 @@ class ReStockMove(models.Model):
|
||||
'location_id': self.picking_id.location_id.id,
|
||||
'location_dest_id': self.picking_id.location_dest_id.id,
|
||||
'picking_id': self.picking_id.id,
|
||||
'reserved_uom_qty': 1.0,
|
||||
'reserved_uom_qty': qty,
|
||||
'lot_id': production_id.move_line_raw_ids.lot_id.id,
|
||||
'company_id': self.env.company.id,
|
||||
# 'workorder_id': '' if not sorted_workorders else sorted_workorders.id,
|
||||
|
||||
11
sf_manufacturing/models/stock_warehouse_orderpoint.py
Normal file
11
sf_manufacturing/models/stock_warehouse_orderpoint.py
Normal file
@@ -0,0 +1,11 @@
|
||||
# -*- coding: utf-8 -*-
|
||||
# Part of SmartGo. See LICENSE file for full copyright and licensing details.
|
||||
import base64
|
||||
from io import BytesIO
|
||||
from odoo import api, fields, models, SUPERUSER_ID, _
|
||||
|
||||
|
||||
class StockWarehouseOrderpoint(models.Model):
|
||||
_inherit = 'stock.warehouse.orderpoint'
|
||||
origin = fields.Char(string='来源')
|
||||
_order = 'create_date DESC'
|
||||
@@ -4,30 +4,32 @@
|
||||
name="Manufacturing"
|
||||
groups="mrp.group_mrp_user,mrp.group_mrp_manager,sf_base.group_sf_mrp_user,sf_base.group_sf_mrp_manager"
|
||||
web_icon="mrp,static/description/icon.svg"
|
||||
sequence="145">
|
||||
sequence="145"/>
|
||||
|
||||
<menuitem id="mrp.menu_mrp_manufacturing"
|
||||
name="Operations"
|
||||
sequence="10"/>
|
||||
<menuitem id="mrp.menu_mrp_manufacturing"
|
||||
name="Operations"
|
||||
parent="mrp.menu_mrp_root"
|
||||
sequence="10"/>
|
||||
|
||||
<menuitem id="mrp.mrp_planning_menu_root"
|
||||
name="Planning"
|
||||
sequence="15"/>
|
||||
<menuitem id="mrp.mrp_planning_menu_root"
|
||||
name="Planning"
|
||||
parent="mrp.menu_mrp_root"
|
||||
sequence="15"/>
|
||||
|
||||
<menuitem id="mrp.enu_mrp_bom"
|
||||
name="Products"
|
||||
sequence="20"/>
|
||||
<menuitem id="mrp.menu_mrp_bom"
|
||||
name="Products"
|
||||
parent="mrp.menu_mrp_root"
|
||||
sequence="20"/>
|
||||
|
||||
<menuitem id="mrp.menu_mrp_reporting"
|
||||
name="Reporting"
|
||||
sequence="25"/>
|
||||
|
||||
<menuitem id="mrp.menu_mrp_configuration"
|
||||
name="Configuration"
|
||||
groups="mrp.group_mrp_manager,sf_base.group_sf_mrp_manager"
|
||||
sequence="100"/>
|
||||
|
||||
</menuitem>
|
||||
<menuitem id="mrp.menu_mrp_reporting"
|
||||
name="Reporting"
|
||||
parent="mrp.menu_mrp_root"
|
||||
sequence="25"/>
|
||||
|
||||
<menuitem id="mrp.menu_mrp_configuration"
|
||||
name="Configuration"
|
||||
parent="mrp.menu_mrp_root"
|
||||
groups="mrp.group_mrp_manager,sf_base.group_sf_mrp_manager"
|
||||
sequence="100"/>
|
||||
|
||||
</odoo>
|
||||
|
||||
16
sf_manufacturing/views/stock_warehouse_orderpoint.xml
Normal file
16
sf_manufacturing/views/stock_warehouse_orderpoint.xml
Normal file
@@ -0,0 +1,16 @@
|
||||
<?xml version="1.0" encoding="utf-8"?>
|
||||
<odoo>
|
||||
<data>
|
||||
<record id="view_warehouse_orderpoint_tree_editable_inherit" model="ir.ui.view">
|
||||
<field name="name">补货</field>
|
||||
<field name="model">stock.warehouse.orderpoint</field>
|
||||
<field name="inherit_id" ref="stock.view_warehouse_orderpoint_tree_editable"/>
|
||||
<field name="arch" type="xml">
|
||||
<xpath expr="//field[@name='qty_to_order']" position="after">
|
||||
<field name="origin"/>
|
||||
</xpath>
|
||||
</field>
|
||||
</record>
|
||||
<!-- 继承补货单的搜索视图 -->
|
||||
</data>
|
||||
</odoo>
|
||||
@@ -213,11 +213,11 @@ class ReworkWizard(models.TransientModel):
|
||||
self.production_id.get_new_program(panel_name)
|
||||
if self.reprogramming_num >= 0 and self.programming_state == '已下发':
|
||||
# ============= 处理CNC加工加工工单的 CNC程序和cmm程序 信息=============
|
||||
for cnc_work in new_work_ids.filtered(lambda wk: wk.name == 'CNC加工'):
|
||||
for cnc_work in new_work_ids.filtered(lambda wk: wk.name == 'CNC加工' or wk.name == '人工线下加工'):
|
||||
ret = {'programming_list': []}
|
||||
old_cnc_rework = max(self.production_id.workorder_ids.filtered(
|
||||
lambda crw: crw.processing_panel == cnc_work.processing_panel
|
||||
and crw.state == 'rework' and crw.routing_type == 'CNC加工'),
|
||||
and crw.state == 'rework' and (crw.routing_type == 'CNC加工' or crw.routing_type == '人工线下加工')),
|
||||
key=lambda w: w.create_date
|
||||
)
|
||||
# 获取当前工单的CNC程序和cmm程序
|
||||
@@ -259,7 +259,7 @@ class ReworkWizard(models.TransientModel):
|
||||
new_cnc_workorder = self.production_id.workorder_ids.filtered(
|
||||
lambda ap1: ap1.processing_panel == cnc_work.processing_panel
|
||||
and ap1.state not in (
|
||||
'rework', 'done') and ap1.routing_type == 'CNC加工'
|
||||
'rework', 'done') and (ap1.routing_type == 'CNC加工' or ap1.routing_type == '人工线下加工')
|
||||
)
|
||||
if not new_cnc_workorder.cnc_ids:
|
||||
new_cnc_workorder.write({
|
||||
@@ -268,6 +268,8 @@ class ReworkWizard(models.TransientModel):
|
||||
'cmm_ids': new_cnc_workorder.cmm_ids.sudo()._json_cmm_program(
|
||||
cnc_work.processing_panel, ret),
|
||||
'cnc_worksheet': old_cnc_rework.cnc_worksheet})
|
||||
# 复制装夹图纸
|
||||
new_cnc_workorder.processing_drawing = old_cnc_rework.processing_drawing
|
||||
# ========== 处理装夹预调 【装夹图纸】 数据 ================
|
||||
for new_pre_work in new_pre_workorder_ids:
|
||||
pre_rework = max(self.production_id.workorder_ids.filtered(
|
||||
@@ -303,18 +305,22 @@ class ReworkWizard(models.TransientModel):
|
||||
@api.onchange('production_id')
|
||||
def onchange_processing_panel_id(self):
|
||||
for item in self:
|
||||
panel_ids = []
|
||||
domain = [('id', '=', False)]
|
||||
production_id = item.production_id
|
||||
if production_id:
|
||||
if self.env.user.has_group('sf_base.group_sf_order_user'):
|
||||
panel_ids = []
|
||||
|
||||
panel_arr = production_id.product_id.model_processing_panel
|
||||
if panel_arr is False:
|
||||
break
|
||||
for p in production_id.detection_result_ids.filtered(
|
||||
lambda ap1: ap1.handle_result == '待处理'):
|
||||
if p.processing_panel is not False and p.processing_panel not in panel_arr:
|
||||
panel_arr += ','.join(p.processing_panel)
|
||||
if len(panel_arr)>0:
|
||||
panel_arr += ','.join(p.processing_panel)
|
||||
else:
|
||||
panel_arr = p.processing_panel
|
||||
for item in panel_arr.split(','):
|
||||
panel = self.env['sf.processing.panel'].search(
|
||||
[('name', 'ilike', item)])
|
||||
|
||||
@@ -3,6 +3,9 @@ import logging
|
||||
import os
|
||||
import json
|
||||
import base64
|
||||
import traceback
|
||||
|
||||
|
||||
from odoo import http, fields, models
|
||||
from odoo.http import request
|
||||
from odoo.addons.sf_base.controllers.controllers import MultiInheritController
|
||||
@@ -95,7 +98,7 @@ class Sf_Mrs_Connect(http.Controller, MultiInheritController):
|
||||
logging.info('panel_file_path:%s' % panel_file_path)
|
||||
|
||||
# 向编程单中添加二维码
|
||||
request.env['printing.utils'].add_qr_code_to_pdf(panel_file_path, model_id, "扫码获取工单")
|
||||
request.env['printing.utils'].add_qr_code_to_pdf(panel_file_path, model_id, "模型ID:%s" % model_id)
|
||||
cnc_workorder.write({'cnc_worksheet': base64.b64encode(open(panel_file_path, 'rb').read())})
|
||||
pre_workorder = productions.workorder_ids.filtered(
|
||||
lambda ap: ap.routing_type in ['装夹预调', '人工线下加工'] and ap.state not in ['done', 'rework'
|
||||
@@ -273,7 +276,8 @@ class Sf_Mrs_Connect(http.Controller, MultiInheritController):
|
||||
except Exception as e:
|
||||
res = {'status': -1, 'message': '系统解析失败'}
|
||||
request.cr.rollback()
|
||||
logging.info('get_cnc_processing_create error:%s' % e)
|
||||
traceback_error = traceback.format_exc()
|
||||
logging.error("get_cnc_processing_create error:%s" % traceback_error)
|
||||
return json.JSONEncoder().encode(res)
|
||||
|
||||
|
||||
|
||||
@@ -1135,8 +1135,6 @@ class sfProductionProcessParameter(models.Model):
|
||||
[("code", '=', item['code']), ('active', 'in', [True, False])])
|
||||
process = self.env['sf.production.process'].search(
|
||||
[('code', '=', item['process_id_code'])], limit=1)
|
||||
production_process_parameter = self.search(
|
||||
[("code", '=', item['code']), ('active', 'in', [True, False])])
|
||||
if not production_process_parameter:
|
||||
production_process_parameter = self.create({
|
||||
"name": item['name'],
|
||||
|
||||
@@ -228,7 +228,7 @@ class sf_production_plan(models.Model):
|
||||
"""
|
||||
排程方法
|
||||
"""
|
||||
self.deal_processing_schedule(self.date_planned_start)
|
||||
self.deal_processing_schedule(self[0].date_planned_start)
|
||||
for record in self:
|
||||
if not record.production_line_id:
|
||||
raise ValidationError("未选择生产线")
|
||||
|
||||
@@ -5,6 +5,7 @@ from odoo import fields, models, api
|
||||
from odoo.exceptions import ValidationError
|
||||
from datetime import datetime
|
||||
from odoo.addons.sf_base.commons.common import Common
|
||||
from odoo.tools import float_round
|
||||
|
||||
|
||||
class QualityCheck(models.Model):
|
||||
@@ -125,10 +126,86 @@ class QualityCheck(models.Model):
|
||||
# todo 需修改
|
||||
val = ['0037818516']
|
||||
logging.info('获取到的工单信息%s' % val)
|
||||
r = requests.post(crea_url, json=val, headers=headers)
|
||||
# r = requests.post(crea_url, json=val, headers=headers)
|
||||
r = self.env['api.request.log'].log_request(
|
||||
'get',
|
||||
crea_url,
|
||||
name='零件特采',
|
||||
responser='中控系统',
|
||||
json=val,
|
||||
headers=headers
|
||||
)
|
||||
ret = r.json()
|
||||
logging.info('_register_quality_check:%s' % ret)
|
||||
if ret['Succeed']:
|
||||
return "零件特采发送成功"
|
||||
else:
|
||||
raise ValidationError("零件特采发送失败")
|
||||
|
||||
|
||||
|
||||
@api.model_create_multi
|
||||
def create(self, vals_list):
|
||||
for val in vals_list:
|
||||
if 'point_id' in val and 'measure_on' not in val:
|
||||
# 如果没有控制方式字段,则从检查点读取质量方式
|
||||
point_id = self.env['quality.point'].browse(val['point_id'])
|
||||
val.update({'measure_on': point_id.measure_on})
|
||||
return super(QualityCheck, self).create(vals_list)
|
||||
|
||||
|
||||
@api.depends('total_qty','testing_percentage_within_lot', 'is_lot_tested_fractionally')
|
||||
def _compute_workorder_qty_to_test(self):
|
||||
for qc in self:
|
||||
if qc.is_lot_tested_fractionally:
|
||||
rounding = qc.product_id.uom_id.rounding if qc.product_id.uom_id else 0.01
|
||||
qc.workorder_qty_to_test = float_round(float(qc.total_qty) * qc.testing_percentage_within_lot / 100,
|
||||
precision_rounding=rounding, rounding_method="UP")
|
||||
else:
|
||||
qc.workorder_qty_to_test = qc.total_qty
|
||||
|
||||
@api.depends('picking_id', 'workorder_id')
|
||||
def _compute_total_qty(self):
|
||||
super(QualityCheck, self)._compute_total_qty()
|
||||
for qc in self:
|
||||
if not qc.picking_id and qc.workorder_id:
|
||||
qc.total_qty = qc.workorder_id.production_id.product_qty
|
||||
|
||||
@api.depends('workorder_qty_to_test')
|
||||
def _compute_workorder_qty_tested(self):
|
||||
for qc in self:
|
||||
qc.workorder_qty_tested = qc.workorder_qty_to_test
|
||||
|
||||
|
||||
workorder_qty_to_test = fields.Float('应检', compute='_compute_workorder_qty_to_test', store=True)
|
||||
workorder_qty_tested = fields.Float('已检', compute='_compute_workorder_qty_tested', store=True)
|
||||
workorder_qty_test_failed = fields.Float('不合格数')
|
||||
|
||||
|
||||
@api.onchange('total_qty', 'workorder_qty_test_failed', 'workorder_qty_to_test', 'workorder_qty_tested')
|
||||
def _onchage_qty(self):
|
||||
for record in self:
|
||||
if record.total_qty and record.workorder_qty_to_test and record.workorder_qty_to_test > float(record.total_qty):
|
||||
record.workorder_qty_to_test = float(record.total_qty)
|
||||
return {
|
||||
'warning': {
|
||||
'title': '警告',
|
||||
'message': '待检数量不能超过总数量'
|
||||
}
|
||||
}
|
||||
if record.workorder_qty_to_test and record.workorder_qty_tested and record.workorder_qty_tested > record.workorder_qty_to_test:
|
||||
record.workorder_qty_tested = record.workorder_qty_to_test
|
||||
return {
|
||||
'warning': {
|
||||
'title': '警告',
|
||||
'message': '已检数量不能超过待检数量'
|
||||
}
|
||||
}
|
||||
if record.workorder_qty_tested and record.workorder_qty_test_failed and record.workorder_qty_test_failed > record.workorder_qty_tested:
|
||||
record.workorder_qty_test_failed = record.workorder_qty_tested
|
||||
return {
|
||||
'warning': {
|
||||
'title': '警告',
|
||||
'message': '不合格数量不能超过已检数量'
|
||||
}
|
||||
}
|
||||
@@ -88,6 +88,42 @@
|
||||
<button name="do_cancel_publish" string="取消发布" type="object" class="btn-primary" confirm="确定取消发布吗?" attrs="{'invisible': ['|',('is_out_check', '=', False), ('publish_status', '!=', 'published')]}"/>
|
||||
<button name="do_re_publish" string="重新发布" type="object" class="btn-primary" attrs="{'invisible': ['|', ('is_out_check', '=', False), ('publish_status', '!=', 'canceled')]}"/>
|
||||
</xpath>
|
||||
<xpath expr="//field[@name='total_qty']" position="attributes">
|
||||
<attribute name="attrs">{
|
||||
'invisible': ['&', '|', ('measure_on', '!=', 'product'), ('is_out_check', '=', False), '|', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False)],
|
||||
'readonly': ['|', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False)],
|
||||
'on_change': ['|', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False)]
|
||||
}</attribute>
|
||||
</xpath>
|
||||
<xpath expr="//field[@name='total_qty']" position="after">
|
||||
<label for="workorder_qty_to_test"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}"/>
|
||||
<div class="o_row"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}">
|
||||
<field name="workorder_qty_to_test" attrs="{'readonly': 0, 'on_chnage': 1}"/>
|
||||
<field name="uom_id"/>
|
||||
</div>
|
||||
<label for="workorder_qty_tested"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}"/>
|
||||
<div class="o_row"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}">
|
||||
<field name="workorder_qty_tested" attrs="{'readonly': [('quality_state', '!=', 'none')], 'on_chnage': 1}"/>
|
||||
<field name="uom_id"/>
|
||||
</div>
|
||||
<label for="workorder_qty_test_failed"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}"/>
|
||||
<div class="o_row"
|
||||
attrs="{'invisible': ['|', '&', ('measure_on', '!=', 'move_line'), ('workorder_id', '=', False), ('is_lot_tested_fractionally', '=', False)]}">
|
||||
<field name="workorder_qty_test_failed" attrs="{'readonly': [('quality_state', '!=', 'none')], 'on_chnage': 1}"/>
|
||||
<field name="uom_id"/>
|
||||
</div>
|
||||
</xpath>
|
||||
<xpath expr="//label[@for='qty_tested']" position="attributes">
|
||||
<attribute name="attrs">{'invisible': ['|', '|', ('measure_on', '!=', 'move_line'), ('is_lot_tested_fractionally', '=', False), '&', ('measure_on', '=', 'move_line'), ('workorder_id', '!=', False)]}</attribute>
|
||||
</xpath>
|
||||
<xpath expr="//div[@class='o_row'][.//field[@name='qty_tested']]" position="attributes">
|
||||
<attribute name="attrs">{'invisible': ['|', '|', ('measure_on', '!=', 'move_line'), ('is_lot_tested_fractionally', '=', False), '&', ('measure_on', '=', 'move_line'), ('workorder_id', '!=', False)]}</attribute>
|
||||
</xpath>
|
||||
</field>
|
||||
</record>
|
||||
|
||||
|
||||
@@ -343,6 +343,9 @@ class RePurchaseOrder(models.Model):
|
||||
if order_line.product_id.id in product_list:
|
||||
purchase.purchase_type = 'outsourcing'
|
||||
break
|
||||
if purchase.order_line[0].product_id.categ_id.name == '坯料':
|
||||
if purchase.order_line[0].product_id.materials_type_id.gain_way == '外协':
|
||||
purchase.purchase_type = 'outsourcing'
|
||||
request_lines = self.order_line.mapped('purchase_request_lines')
|
||||
# 检查是否存在 is_subcontract 为 True 的行
|
||||
if any(line.is_subcontract for line in request_lines):
|
||||
@@ -390,11 +393,11 @@ class RePurchaseOrder(models.Model):
|
||||
# route_ids
|
||||
result.append({
|
||||
"product_id": server_template.product_variant_id.id,
|
||||
'related_product':production.product_id.id,
|
||||
'related_product': production.product_id.id,
|
||||
"name": production.procurement_group_id.name,
|
||||
"date_required": fields.Datetime.now(),
|
||||
"product_uom_id":server_template.uom_id.id,
|
||||
"product_qty": 1,
|
||||
"product_qty": production.product_qty,
|
||||
"request_id": False,
|
||||
"move_dest_ids": False,
|
||||
"orderpoint_id": False,
|
||||
@@ -417,7 +420,7 @@ class RePurchaseOrder(models.Model):
|
||||
('detailed_type', '=', 'service')])
|
||||
server_product_process.append((0, 0, {
|
||||
'product_id': server_template.product_variant_id.id,
|
||||
'product_qty': 1,
|
||||
'product_qty': production.product_uom_qty,
|
||||
'product_uom': server_template.uom_id.id,
|
||||
'related_product': production.product_id.id,
|
||||
'manual_part_number': pp.part_number,
|
||||
|
||||
@@ -4,12 +4,14 @@ import json
|
||||
import base64
|
||||
from odoo import http
|
||||
from odoo.http import request
|
||||
from odoo.addons.sf_base.decorators.api_log import api_log
|
||||
|
||||
|
||||
class Manufacturing_Connect(http.Controller):
|
||||
|
||||
@http.route('/AutoDeviceApi/ToolGroup', type='json', auth='sf_token', methods=['GET', 'POST'], csrf=False,
|
||||
cors="*")
|
||||
@api_log('刀具组', requester='中控系统')
|
||||
def get_functional_tool_groups_Info(self, **kw):
|
||||
"""
|
||||
刀具组接口
|
||||
|
||||
@@ -51,7 +51,15 @@ class SfMaintenanceEquipment(models.Model):
|
||||
headers = {'Authorization': config['center_control_Authorization']}
|
||||
crea_url = config['center_control_url'] + "/AutoDeviceApi/GetToolInfos"
|
||||
params = {"DeviceId": self.name}
|
||||
r = requests.get(crea_url, params=params, headers=headers)
|
||||
# r = requests.get(crea_url, params=params, headers=headers)
|
||||
r = self.env['api.request.log'].log_request(
|
||||
'get',
|
||||
crea_url,
|
||||
name='机床刀库',
|
||||
responser='中控系统',
|
||||
params=params,
|
||||
headers=headers
|
||||
)
|
||||
ret = r.json()
|
||||
logging.info('机床刀库register_equipment_tool():%s' % ret)
|
||||
datas = ret['Datas']
|
||||
|
||||
@@ -514,7 +514,15 @@ class ShelfLocation(models.Model):
|
||||
crea_url = config['center_control_url'] + "/AutoDeviceApi/GetLocationInfos"
|
||||
|
||||
params = {'DeviceId': device_id}
|
||||
r = requests.get(crea_url, params=params, headers=headers)
|
||||
# r = requests.get(crea_url, params=params, headers=headers)
|
||||
r = self.env['api.request.log'].log_request(
|
||||
'get',
|
||||
crea_url,
|
||||
name='库位信息',
|
||||
responser='中控系统',
|
||||
params=params,
|
||||
headers=headers
|
||||
)
|
||||
|
||||
ret = r.json()
|
||||
|
||||
@@ -812,40 +820,49 @@ class SfStockMoveLine(models.Model):
|
||||
# # 从目标stock.move对象获取目标stock.picking对象
|
||||
# dest_picking = dest_move.picking_id if dest_move else False
|
||||
# # 现在,dest_picking就是current_picking的下一步
|
||||
# 添加所有需要的依赖字段
|
||||
@api.depends('location_id')
|
||||
def _compute_current_location_id(self):
|
||||
# 批量获取所有相关记录的picking
|
||||
pickings = self.mapped('picking_id')
|
||||
|
||||
# 构建源picking的移库行与目标位置的映射
|
||||
origin_location_map = {}
|
||||
for picking in pickings:
|
||||
# 获取源picking
|
||||
origin_move = picking.move_ids[:1].move_orig_ids[:1]
|
||||
if not origin_move:
|
||||
continue
|
||||
|
||||
origin_picking = origin_move.picking_id
|
||||
if not origin_picking:
|
||||
continue
|
||||
|
||||
# 为每个picking构建lot_id到location的映射
|
||||
origin_location_map[picking.id] = {
|
||||
move_line.lot_id.id: move_line.destination_location_id
|
||||
for move_line in origin_picking.move_line_ids.filtered(
|
||||
lambda ml: ml.destination_location_id and ml.lot_id
|
||||
)
|
||||
}
|
||||
|
||||
# 批量更新current_location_id
|
||||
for record in self:
|
||||
# 使用record代替self来引用当前遍历到的记录
|
||||
logging.info('record.picking_id.name: %s' % record.picking_id.name)
|
||||
logging.info('record.env: %s' % record.env['stock.picking'].search([('name', '=', record.picking_id.name)]))
|
||||
current_picking = record.picking_id
|
||||
if not current_picking:
|
||||
record.current_location_id = False
|
||||
continue
|
||||
|
||||
# 获取当前的stock.picking对象
|
||||
current_picking = record.env['stock.picking'].search([('name', '=', record.picking_id.name)], limit=1)
|
||||
# 获取当前picking对应的lot_location映射
|
||||
lot_dest_map = origin_location_map.get(current_picking.id, {})
|
||||
|
||||
# 获取当前picking的第一个stock.move对象
|
||||
current_move = current_picking.move_ids[0] if current_picking.move_ids else False
|
||||
|
||||
# 如果存在相关的stock.move对象
|
||||
if current_move:
|
||||
# 获取源stock.move对象
|
||||
origin_move = current_move.move_orig_ids[0] if current_move.move_orig_ids else False
|
||||
|
||||
# 从源stock.move对象获取源stock.picking对象
|
||||
origin_picking = origin_move.picking_id if origin_move else False
|
||||
|
||||
# 如果前一个调拨单有目标货位
|
||||
if origin_picking:
|
||||
for i in current_picking.move_line_ids:
|
||||
for j in origin_picking.move_line_ids:
|
||||
if j.destination_location_id and i.lot_id == j.lot_id:
|
||||
# 更新当前记录的current_location_id字段
|
||||
record.current_location_id = j.destination_location_id
|
||||
# # 获取目标stock.move对象
|
||||
# dest_move = current_move.move_dest_ids[0] if current_move.move_dest_ids else False
|
||||
#
|
||||
# # 从目标stock.move对象获取目标stock.picking对象
|
||||
# dest_picking = dest_move.picking_id if dest_move else False
|
||||
# # 现在,dest_picking就是current_picking的下一步
|
||||
# 查找匹配的lot_id
|
||||
for move_line in current_picking.move_line_ids:
|
||||
if move_line.lot_id and move_line.lot_id.id in lot_dest_map:
|
||||
record.current_location_id = lot_dest_map[move_line.lot_id.id]
|
||||
break
|
||||
else:
|
||||
record.current_location_id = False
|
||||
|
||||
# 是一张单据一张单据往下走的,所以这里的目标货位是上一张单据的当前货位,且这样去计算是可以的。
|
||||
@api.depends('location_dest_id')
|
||||
|
||||
Reference in New Issue
Block a user