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