Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- total_vertical = timedelta(hours=0, minutes=0)
- cr.execute("SELECT enti.entidade, jobs.nr_job " \
- "FROM all_jobs AS jobs " \
- "JOIN jobsopen_entidades AS enti ON enti.id = jobs.entidade_id " \
- "JOIN all_services as servic on servic.job_id = jobs.id " \
- "WHERE servic.create_uid = %s AND " \
- "EXTRACT(MONTH FROM servic.date_service) = %s " \
- "GROUP BY 1,2",[5, 9])
- query_A = cr.fetchall()
- if query_A:
- for values_A in query_A:
- sheet.write(line_, 0, values_A[0], style_main)
- sheet.write(line_, 1, values_A[1], style_main)
- for i in range(1, 32):
- cr.execute("SELECT SUM(CAST(hour_end as time) - CAST(hour_begin as time)) AS time_ " \
- "FROM all_services AS servic " \
- "JOIN all_jobs AS jobs ON jobs.id = servic.job_id " \
- "WHERE servic.create_uid = %s AND " \
- "EXTRACT(MONTH FROM date_service) = %s AND " \
- "EXTRACT(DAY FROM date_service) = %s AND " \
- "jobs.nr_job = %s",[5, 9, i, values_A[1]])
- query_B = cr.fetchall()
- if query_B:
- for values_B in query_B:
- current_value = str(values_B[0]);
- if current_value != 'None':
- hours_ = current_value.split(':')[0]
- minutes_ = current_value.split(':')[1]
- total_ = hours_ +':'+ minutes_
- sheet.write(line_, i + 1, total_, style_main)
- total_vertical += timedelta(hours=int(hours_), minutes=int(minutes_))
- sheet.write(line_, 33, str(total_vertical), style_main)
- line_ += 1
- total_vertical = timedelta(hours=0, minutes=0) # Reset
Advertisement
Add Comment
Please, Sign In to add comment