def button_check_time(self): begin_date = self.appointment_begin_date end_date = self.appointment_end_date # 检查这个教练在预约表中有无冲突 检查车辆在预约表中有无冲突 domain = [('active', '=', True), ('complete', '=', False), ('id', '!=', self.id), # 不是本预约单 ('complete_begin_date', '=', False), '|', ('car_name', '=', self.car_name.id), # |表示后面两个条件或 ('teacher_name', '=', self.teacher_name.id)] field_names = ['appointment_begin_date', 'appointment_end_date', 'name', 'teacher_name', 'car_name'] records = self.search_read(domain, field_names) for rec in records: if rec['name']: check_begin_date = rec['appointment_begin_date'] check_end_date = rec['appointment_end_date'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('预约单时间冲突!单据号:' + rec['name'])) # 检查教练请假单 domain = [('active', '=', True), ('teacher_name', '=', self.teacher_name.id), # 本教练的请假单 ('actual_begin_date', '=', False)] field_names = ['Holiday_begin_date', 'Holiday_end_date', 'name'] records = self.env['nebula.teacher.holiday'].search_read(domain, field_names) for rec in records: if rec['name']: print('****nebula.teacher.holiday:', records) check_begin_date = rec['Holiday_begin_date'] check_end_date = rec['Holiday_end_date'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('教练假期冲突!单据号:' + rec['name'])) # 检查车辆检验单 domain = [('active', '=', True), ('car_name', '=', self.car_name.id), # 车辆 ('actual_date_begin', '=', False)] field_names = ['order_date_begin', 'order_date_end', 'name'] records = self.env['nebula.car.maintenance'].search_read(domain, field_names) for rec in records: if rec['name']: print('****nebula.car.maintenance:', records) check_begin_date = rec['order_date_begin'] check_end_date = rec['order_date_end'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('车辆保养冲突!单据号:' + rec['name'])) return {}# 比较时间是不是在里面，在里面就Truedef check_time_out(in_begin_time, in_end_time, check_begin_time, check_end_time): if (check_begin_time <= in_begin_time) and (in_begin_time <= check_end_time): re = True # 传入开始时间在要检查的时间中间 elif (check_begin_time <= in_end_time) and (in_end_time <= check_end_time): re = True # 传入结束时间在要检查的时间中间 elif (in_begin_time <= check_begin_time) and (check_end_time <= in_end_time): re = True # 传入开始时间和传入结束时间跨越了要检查的时间段 else: re = False return re
from .system_info import get_charge_hourfrom .neubla_tools import check_time_out, appointment_begin_datefrom odoo import fields, models, api, _from datetime import datetime, timedeltafrom odoo.osv import osvclass NebulaAppointment(models.Model): _name = "nebula.appointment" _description = "预约管理" _order = 'name' active = fields.Boolean('预约有效', default=True) complete = fields.Boolean('预约完成', default=False) name = fields.Char('预约简情', size=30, default=datetime.now().strftime('%Y-%m-%d %H:%M:%S')) student_name = fields.Many2one('nebula.student', string='学员姓名', index=True, size=8) student_seq = fields.Char('学员编号', related='student_name.seq', store=True) references_appointment = fields.Many2one('nebula.appointment', string='参考预约单', size=30, domain=[('active', '=', True)]) student_mobile = fields.Char('学员手机', related='student_name.mobile') appointment_begin_date = fields.Datetime('预约起始时间', required=True, index=True, default=appointment_begin_date(24)) appointment_hours = fields.Integer('预约小时数', required=True, default=3) appointment_end_date = fields.Datetime('预约结束时间', compute='_calc_appointment_end_date', store=True) complete_begin_date = fields.Datetime('实际起始时间', index=True) complete_hours = fields.Integer('实际小时数') complete_end_date = fields.Datetime('实际结束时间', compute='_calc_complete_end_date', store=True) auto_type_name = fields.Selection(selection='_select_auto_type', string='预约类型', required=True) teacher_name = fields.Many2one('nebula.teacher', string='教练工号', size=8, required=True, domain=[('active', '=', True)]) teacher_full_name = fields.Char('教练姓名', related='teacher_name.full_name', store=True) teacher_mobile = fields.Char('教练手机', related='teacher_name.mobile') car_name = fields.Many2one('nebula.car', string='车辆编号', size=8, domain=[('active', '=', True)]) license_plate = fields.Char('车辆牌照', related='car_name.license_plate', store=True) car_type_name = fields.Selection(selection='_select_car_type', string='车型', related='car_name.car_type_name') car_auto_type_name = fields.Selection(selection='_select_auto_type', string='排挡类', related='car_name.auto_type_name') fee_type = fields.Many2one('nebula.system.info', string='费用标准', required=True, size=30, store=True, domain=[('active', '=', True)]) work_start_time = fields.Float('上班时间', digits=(4, 2), related='fee_type.start_time', store=True) work_end_time = fields.Float('下班时间', digits=(4, 2), related='fee_type.end_time', store=True) work_hours_hour = fields.Integer('每节课小时数', related='fee_type.hours_hour', store=True) work_charge_hour = fields.Integer('每小时收费', compute="_get_charge_hour", store=True) deposit = fields.Integer('学员缴费') give_money = fields.Integer('赠送金额', help='充值送费') pay = fields.Integer('本次支付费用') balance = fields.Integer('余额', readonly=True) # 计算字段，学员缴费之和-支付费用之和。 begin_address = fields.Text('上车地点') end_address = fields.Text('下车地点', default='同上车地点') user_id = fields.Many2one('res.users', string='创建人', index=True, readonly=True, default=lambda self: self.env.user) date_docket = fields.Datetime('单据日期', required=True, readonly=True, index=True, default=fields.Datetime.now) note = fields.Text('备注') @api.model def _select_car_type(self): records = self.env['nebula.car.type'].search([('active', '=', True)]) return [(r.name, r.name_type) for r in records] def _select_auto_type(self): records = self.env['nebula.auto.type'].search([]) return [(r.name, r.name_type) for r in records] @api.depends('fee_type', 'car_auto_type_name') def _get_charge_hour(self): for order in self: order_id = order.fee_type.id auto_type = order.car_auto_type_name order.work_charge_hour = get_charge_hour(order, order_id, auto_type) @api.depends('appointment_begin_date', 'appointment_hours') def _calc_appointment_end_date(self): for order in self: begin_date = order.appointment_begin_date add_hours = order.appointment_hours end_date = begin_date + timedelta(hours=add_hours) end_date = end_date - timedelta(seconds=1) order.appointment_end_date = end_date @api.depends('complete_begin_date', 'complete_hours') def _calc_complete_end_date(self): for order in self: if order.complete_begin_date: begin_date = order.complete_begin_date add_hours = order.complete_hours begin_date += timedelta(hours=add_hours) begin_date -= timedelta(seconds=1) order.complete_end_date = begin_date @api.onchange('appointment_hours') def onchange_appointment_hours(self): if self.appointment_hours <= 0: self.appointment_hours = 1 @api.onchange('student_seq', 'deposit', 'give_money', 'pay') def onchange_get_balance(self): balance = 0 if self.student_seq: if self.deposit: balance += self.deposit if self.give_money: balance += self.give_money if self.pay: balance -= self.pay domain = [('active', '=', True), ('student_seq', '=', self.student_seq), ('id', '!=', self.id.origin)] field_names = ['deposit', 'give_money', 'pay'] records = self.search_read(domain, field_names) for rec in records: if rec['deposit']: balance += rec['deposit'] if rec['give_money']: balance += rec['give_money'] if rec['pay']: balance -= rec['pay'] self.balance = balance @api.onchange('student_seq') def _onchange_student_seq(self): # TODO: 如果是同一个学员，则不清空 self.references_appointment = None if self.student_seq: return { 'domain': {'references_appointment': [ ('active', '=', True), ('student_seq', '=', self.student_seq) ]}} else: return {'domain': {'references_appointment': [('active', '=', True)]}} @api.onchange('references_appointment') def _onchange_references_appointment(self): if self.references_appointment: domain = [('id', '=', self.references_appointment.id)] field_names = ['auto_type_name', 'teacher_name', 'car_name', 'begin_address', 'end_address', 'student_name', 'fee_type'] records = self.env['nebula.appointment'].search_read(domain, field_names) for rec in records: if rec['auto_type_name']: self.auto_type_name = rec['auto_type_name'] if rec['teacher_name']: self.teacher_name = rec['teacher_name'] if rec['car_name']: self.car_name = rec['car_name'] if rec['begin_address']: self.begin_address = rec['begin_address'] if rec['end_address']: self.end_address = rec['end_address'] if rec['fee_type']: self.fee_type = rec['fee_type'] if not self.student_name and rec['student_name']: self.student_name = rec['student_name'] # 4.检查车辆在预约表中有无冲突 # 1.检查教练休息表有没有准备休息 # 2.检查车辆是不是需要检修 # 3.检查这个教练在预约表中有无冲突 def button_check_time(self): begin_date = self.appointment_begin_date end_date = self.appointment_end_date # 检查这个教练在预约表中有无冲突 检查车辆在预约表中有无冲突 domain = [('active', '=', True), ('complete', '=', False), ('id', '!=', self.id), # 不是本预约单 ('complete_begin_date', '=', False), '|', ('car_name', '=', self.car_name.id), # |表示后面两个条件或 ('teacher_name', '=', self.teacher_name.id)] field_names = ['appointment_begin_date', 'appointment_end_date', 'name', 'teacher_name', 'car_name'] records = self.search_read(domain, field_names) for rec in records: if rec['name']: check_begin_date = rec['appointment_begin_date'] check_end_date = rec['appointment_end_date'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('预约单时间冲突!单据号:' + rec['name'])) # 检查教练请假单 domain = [('active', '=', True), ('teacher_name', '=', self.teacher_name.id), # 本教练的请假单 ('actual_begin_date', '=', False)] field_names = ['Holiday_begin_date', 'Holiday_end_date', 'name'] records = self.env['nebula.teacher.holiday'].search_read(domain, field_names) for rec in records: if rec['name']: check_begin_date = rec['Holiday_begin_date'] check_end_date = rec['Holiday_end_date'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('教练假期冲突!单据号:' + rec['name'])) # 检查车辆检验单 domain = [('active', '=', True), ('car_name', '=', self.car_name.id), # 车辆 ('actual_date_begin', '=', False)] field_names = ['order_date_begin', 'order_date_end', 'name'] records = self.env['nebula.car.maintenance'].search_read(domain, field_names) for rec in records: if rec['name']: check_begin_date = rec['order_date_begin'] check_end_date = rec['order_date_end'] if check_time_out(begin_date, end_date, check_begin_date, check_end_date): raise osv.except_osv(_('Warning!'), _('车辆保养冲突!单据号:' + rec['name'])) return {}
