| | 1 | 157 | | 1 | 70 | {"table":"transaction","relationships":["vehicle"],"type":"table","fields":[{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"_formula","column":"Abastecimentos","type":"formula","showAt":null,"format":"money","query":"SUM(transaction.fuel_supplies)"},{"table":"_formula","column":"Manutenção","type":"formula","query":"SUM(transaction.maintenance)","showAt":null,"format":"money"},{"table":"_formula","column":"Pneus","type":"formula","query":"SUM(transaction.tires)","showAt":null,"format":"money"},{"table":"_formula","column":"Outros","type":"formula","query":"SUM(transaction.others)","showAt":null,"format":"money"},{"table":"_formula","column":"Total Despesas","type":"formula","query":"SUM(transaction.expenses)","showAt":null,"format":"money"},{"table":"_formula","column":"Receitas","type":"formula","query":"SUM(transaction.revenues)","showAt":null,"format":"money"},{"table":"_formula","column":"Lucro","type":"formula","query":"SUM(transaction.revenues) - SUM(transaction.expenses)","showAt":null,"format":"money"},{"table":"_formula","column":"Margem %","type":"formula","query":"(SUM(transaction.revenues) - SUM(transaction.expenses))*100 / SUM(transaction.revenues)","showAt":null,"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"equal","condition":"AND","value":["revenue","expense","tire_action"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"vehicle","column":"name","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"vehicle","column":"name","isHeaderColumn":true,"desc":false}],"hideDetails":true,"from":"SELECT transaction.id, transaction.vehicle_id, transaction.date, transaction.type, transaction.deleted_at, CASE WHEN transaction.type = 'revenue' THEN transaction.final_value ELSE 0 END AS revenues, CASE WHEN transaction.type in ('expense','tire_action') THEN transaction.final_value ELSE 0 END AS expenses, CASE WHEN item.cost_type = 'abastecimento' THEN transaction.final_value ELSE 0 END AS fuel_supplies, CASE WHEN item.cost_type = 'manutencao' THEN transaction.final_value ELSE 0 END AS maintenance, CASE WHEN item.cost_type = 'pneu' THEN transaction.final_value ELSE 0 END AS tires, CASE WHEN item.cost_type = 'outros' THEN transaction.final_value ELSE 0 END AS others FROM transaction LEFT OUTER JOIN item ON item.id = transaction.item_id AND item.deleted_at IS NULL"} | 2018-12-12 17:08:30.579+00 | 2019-01-24 19:42:24.943+00 | | 2 | | | 2 | REL-000070 | table | | Lucratividade por Veículo | transaction |
| | 1 | 105 | {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 6 | {"table":"transaction","relationships":["service_order","item","vehicle"],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.service_order_id","operator":"$ne","condition":"AND","value":null,"references":"service_order","format":null,"type":"INTEGER"},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.final_value","operator":"$gte","condition":"AND","value":0.01,"references":null,"format":null,"type":"DECIMAL"},{"field":"service_order.type","operator":"equal","condition":"AND","value":["preventive"],"references":null,"format":"list:serviceOrderTypes","type":"STRING"}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"vehicle_id","isHeaderColumn":false,"desc":false}]} | 2016-07-04 18:05:18.237+00 | 2017-10-13 12:38:08.768+00 | | | | | | REL-000006 | table | | Ordens de serviço - Custos preventivos no mês atual | transaction |
| | 1 | 74 | {"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 29 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"format":"list:itemTypes"},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING"}],"aggregates":[{"table":"item","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}]} | 2016-06-29 21:23:34.11+00 | 2017-10-13 12:55:47.595+00 | | | | | | REL-000029 | matrix | | Despesas - Custos totais mensal por tipo de item | transaction |
| | 1 | 117 | | 1 | 37 | {"table":"transaction","relationships":["tire"],"type":"table","fields":[{"table":"transaction","column":"tire_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"source_status","type":"STRING","showAt":null,"format":"list:tireStatus"},{"table":"transaction","column":"source_position","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"movement_type","type":"STRING","showAt":null,"format":"list:tireMovementType"},{"table":"transaction","column":"furrow","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"destination_status","type":"STRING","showAt":null,"format":"list:tireStatus"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"destination_position","type":"STRING","showAt":null,"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.movement_type","operator":"not_empty","condition":"AND","value":null,"references":null,"format":"list:tireMovementType","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"tire_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} | 2017-10-17 11:05:23.999+00 | 2018-05-09 14:39:28.664+00 | | 1 | | | 1 | REL-000037 | table | Histórico das movimentações de pneus por pneu,
nos últimos 60 dias. | Pneus - Histórico das movimentações de pneus por pneu U60d | transaction |
| | 1 | 137 | {"type":"column","categories":"fine.vehicle_id","values":[{"column":"fine.penalty_total_amount","rawColumn":"fine.penalty_total_amount__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 59 | {"table":"fine","relationships":["fine_qualification"],"type":"table","fields":[{"table":"fine","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"name","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"ait","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"status","type":"STRING","showAt":null,"format":"list:fineStatus"},{"table":"fine","column":"infringement_date","type":"DATE","showAt":null,"format":null},{"table":"fine","column":"fine_qualification_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"penalty_total_amount","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"fine_qualification","column":"description","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"address","type":"STRING","showAt":null,"format":null},{"table":"fine","column":"city_id","type":"INTEGER","showAt":null,"format":null},{"table":"fine","column":"driver_id","type":"INTEGER","showAt":null,"format":null}],"filters":[],"aggregates":[{"table":"fine","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"fine","column":"penalty_total_amount","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[]} | 2018-02-14 11:36:12.31+00 | 2018-03-06 13:05:56.831+00 | | 1 | | | 1 | REL-000059 | table | | Infrações - Infrações por veículo | fine |
| | 1 | 125 | {"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true}} | 1 | 43 | {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"is_full_period":false},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}]} | 2017-11-07 16:54:03.862+00 | 2019-05-13 18:43:17.824+00 | | 1 | | | 1 | REL-000043 | matrix | | Infográfico - Despesas gerais por veículo mês anterior | transaction |
| 1 | | 1 | 161 | | 1 | 5018 | {"table":"vehicle","relationships":["employee","employee_role","model"],"type":"table","fields":[{"table":"vehicle","column":"employee_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"employee","column":"employee_role_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_model_version_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"model","column":"vehicle_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_model_class","column":"vehicle_class_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"association":{"model":"vehicle_class","key":"id"},"daysEvaluatedColumns":null},{"table":"_formula","column":"Contador","type":"formula","query":"COUNT(DISTINCT vehicle.employee_id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"employee.employee_role_id","operator":"not_empty","condition":"AND","value":null,"references":"employee_role","format":null,"type":"INTEGER","fixed":true,"variableValue":null,"conditionType":"fixed","isFixedPeriod":false,"sql":"vehicle.employee_id IS NOT NULL AND vehicle_joins_employee_role.vehicle_classes :: text = '[]' :: text","isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null}],"aggregates":[{"table":"vehicle","column":"employee_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"employee","column":"subsidiary_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"employee","column":"cost_center_id","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"employee","column":"employee_role_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[],"completeFrom":"vehicle AS vehicle LEFT OUTER JOIN employee AS vehicle_joins_employee ON vehicle.employee_id = vehicle_joins_employee.id AND vehicle_joins_employee.deleted_at IS NULL LEFT OUTER JOIN vehicle_model AS vehicle_joins_model ON vehicle.vehicle_model_id = vehicle_joins_model.id AND vehicle_joins_model.deleted_at IS NULL LEFT OUTER JOIN subsidiary AS employee_joins_subsidiary ON vehicle_joins_employee.subsidiary_id = employee_joins_subsidiary.id AND employee_joins_subsidiary.deleted_at IS NULL LEFT OUTER JOIN cost_center AS employee_joins_cost_center ON vehicle_joins_employee.cost_center_id = employee_joins_cost_center.id AND employee_joins_cost_center.deleted_at IS NULL LEFT OUTER JOIN vehicle_model_version AS vehicle_joins_modelversion ON vehicle.vehicle_model_version_id = vehicle_joins_modelversion.id AND vehicle_joins_modelversion.deleted_at IS NULL LEFT OUTER JOIN vehicle_brand AS model_joins_brand ON vehicle_joins_model.vehicle_brand_id = model_joins_brand.id AND model_joins_brand.deleted_at IS NULL LEFT OUTER JOIN employee_role AS employee_joins_role ON vehicle_joins_employee.employee_role_id = employee_joins_role.id LEFT OUTER JOIN employee_role AS vehicle_joins_employee_role ON vehicle_joins_employee.employee_role_id = vehicle_joins_employee_role.id LEFT OUTER JOIN vehicle_class AS vehicle_model_class_joins_vehicle_class ON vehicle_model_class_joins_vehicle_class.id =( SELECT vehicle_class_id FROM vehicle_model_class WHERE vehicle_model_id = vehicle.vehicle_model_id AND ( vehicle_model_version_id = vehicle.vehicle_model_version_id OR vehicle_model_version_id IS NULL ) ORDER BY vehicle_model_version_id ASC LIMIT 1)"} | 2023-07-13 03:04:39.761+00 | 2023-07-13 03:04:39.771+00 | | | | | | REL-005018 | table | | Colaboradores sem acesso a veículos que possuem veículos | vehicle |
| | | | | 268 | 1301 | {"table":"vehicle","relationships":["group","modelversion","cost_center","model"],"type":"table","fields":[{"table":"vehicle","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cost_center_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"chassis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"color","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"state_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"axis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"model","column":"vehicle_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_141","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_36","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_308","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_cmt","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_35","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_612","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-09-13 17:49:48.051+00 | 2022-09-20 18:32:17.62+00 | 2022-09-20 18:32:17.616+00 | 870 | 870 | 870 | 870 | REL-001301 | table | relatório para verificar veículos ativos | RELATÓRIO DE VEICULOS | vehicle |
| | | | | 1 | 3508 | {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-11-28 19:02:09.875+00 | 2022-11-29 18:57:56.632+00 | 2022-11-29 18:57:56.462+00 | 1403 | 77 | 77 | 1403 | REL-003508 | table | | excluir | transaction |
| | 1 | 150 | | 1 | 74 | {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"subsidiary_id","type":"INTEGER","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":{"inner":true,"total":true},"format":null,"date_config":["month","year"],"is_full_period":true},{"table":"_formula","column":"Receitas","type":"formula","query":"SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Despesas","type":"formula","query":"SUM(transaction.expenses)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Lucro","type":"formula","query":"SUM(transaction.revenues) - SUM(transaction.expenses)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Margem %","type":"formula","query":"(SUM(transaction.revenues) - SUM(transaction.expenses)) * 100 / SUM(transaction.revenues)","showAt":{"inner":true,"total":true},"format":null}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"sub_12_months:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"equal","condition":"AND","value":["revenue","expense","tire_action"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"transaction","column":"subsidiary_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"from":"SELECT transaction.id, transaction.subsidiary_id, transaction.date, transaction.type, transaction.deleted_at, CASE WHEN transaction.type = 'revenue' THEN transaction.final_value ELSE 0 END AS revenues, CASE WHEN transaction.type IN ('expense','tire_action') THEN transaction.final_value ELSE 0 END AS expenses FROM transaction"} | 2018-12-12 17:09:09.564+00 | 2019-01-24 19:42:14.796+00 | | 2 | | | 2 | REL-000074 | matrix | | Receitas x Despesas mensais por Filial | transaction |