@api.one

@api.constrains(‘order_line’)

def _check_tanggal_rencana(self):

query = “””

SELECT shl.start_time as tgl_rencana_produksi

FROM survey_harian_line shl

WHERE shl.survey_id = %s

ORDER BY shl.start_time DESC

“””

self.env.cr.execute(query,(self.id,))

survey_harian_line = self.env.cr.dictfetchall()

if survey_harian_line:

for s in survey_harian_line:

tgl_rencana_produksi = s[‘tgl_rencana_produksi’]

self.tgl_rencana_produksi = tgl_rencana_produksi