QWebException:求值时：“强制到Unicode:需要字符串或缓冲区，找到int”

Question

我的代码有问题：

def exam_day_date (self,day_id_date):
        id_date= []
        self._cr.execute(
            """select week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids from fci_exam_time_table_line, fci_subject s ,rel_sa t,lgna_teacher y  where exam_id = %d group by week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids order by exam_date  """ % (
            day_id_date))
        res = self._cr.dictfetchall()
        self._cr.execute(
            """select week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids from fci_exam_time_table_line, fci_subject s ,rel_sa t,lgna_teacher y  where exam_id = %d group by week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids order by exam_date   """ % (
            day_id_date))
        time_data = self._cr.dictfetchall()
        for time_detail in time_data:
            for data in res:
               time_detail[data['week_day']] = '('+data['week_day']+')\n'+data['exam_date']+'\n('+data['name']+')'+data['sasa_zozo']+data['teacher_ids']
            id_date.append(time_detail)
        print (id_date)
        return id_date

其中week-day，name为chars，exam-date为date，但sasa_-zozo和teacher-yu-id是intgers

当我试图打印一份报告时，它给了我一个错误

Answer 1

将整数转换为字符串并传递给报表模板进行打印

def exam_day_date (self,day_id_date):
        id_date= []
        self._cr.execute(
            """select week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids from fci_exam_time_table_line, fci_subject s ,rel_sa t,lgna_teacher y  where exam_id = %d group by week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids order by exam_date  """ % (
            day_id_date))
        res = self._cr.dictfetchall()
        self._cr.execute(
            """select week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids from fci_exam_time_table_line, fci_subject s ,rel_sa t,lgna_teacher y  where exam_id = %d group by week_day,exam_date ,s.name,t.sasa_zozo,y.teacher_ids order by exam_date   """ % (
            day_id_date))
        time_data = self._cr.dictfetchall()
        for time_detail in time_data:
            for data in res:
               time_detail[data['week_day']] = '('+data['week_day']+')\n'+data['exam_date']+'\n('+data['name']+')'+str(data['sasa_zozo'])+str(data['teacher_ids'])
            id_date.append(time_detail)
        print (id_date)
        return id_date

您试图在字符串中追加一个整数，这就是错误的原因