| | 1 | 136 | | 1 | 58 | {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"name","type":"STRING","showAt":null,"format":null},{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"service_order","column":"status","type":"STRING","showAt":null,"format":"list:serviceOrderStatus"},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"service_order.status","operator":"$ne","condition":"AND","value":["waiting_nf","finished","canceled"],"references":null,"format":"list:serviceOrderStatus","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"service_order.total_cost","operator":"$gt","condition":"AND","value":0,"references":null,"format":null,"type":"DECIMAL","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[],"preview":false,"orderBy":[{"table":"service_order","column":"name","isHeaderColumn":true,"desc":false}]} | 2018-02-09 20:18:37.303+00 | 2018-02-09 20:18:37.303+00 | | 1 | | | 1 | REL-000058 | table | | Ordens de serviço abertas com despesas | service_order |
| | 1 | 145 | {"type":"column","categories":"transaction.date","values":[{"column":"transaction.potential_economy_quantity","rawColumn":"transaction.potential_economy_quantity__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 68 | {"table":"transaction","relationships":["vehicle"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"vehicle","column":"name","type":"STRING","showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"potential_economy_quantity","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"transaction","column":"potential_economy_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.register_type","operator":"equal","condition":"AND","value":["Abastecimento"],"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","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":"vehicle","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"potential_economy_quantity","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"potential_economy_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"vehicle","column":"name","isHeaderColumn":true,"desc":false}]} | 2018-06-29 13:10:11.708+00 | 2018-06-29 13:10:34.919+00 | | 1 | | | 1 | REL-000068 | matrix | | Infográfico - Economia potencial por veículo mês anterior | transaction |
| | 1 | 134 | | 1 | 57 | {"table":"expense_parcel","relationships":["expense","stock_entry"],"type":"table","fields":[{"table":"expense_parcel","column":"name","type":"STRING","showAt":null,"format":null},{"table":"expense_parcel","column":"number","type":"INTEGER","showAt":null,"format":null},{"table":"expense_parcel","column":"due_date","type":"DATE","showAt":null,"format":null},{"table":"expense_parcel","column":"value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"expense_parcel","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"expense","column":"supplier_id","type":"INTEGER","showAt":null,"format":null},{"table":"expense","column":"doc_number","type":"STRING","showAt":null,"format":null},{"table":"expense_parcel","column":"stock_entry_id","type":"INTEGER","showAt":null,"format":null},{"table":"stock_entry","column":"doc_number","type":"STRING","showAt":null,"format":null}],"filters":[{"field":"expense_parcel.payment_date","operator":"empty","condition":"AND","value":null,"references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"expense_parcel.paid_value","operator":"empty","condition":"AND","value":0,"references":null,"format":null,"type":"DECIMAL","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"expense_parcel","column":"value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"expense_parcel","column":"due_date","isHeaderColumn":true,"desc":false}]} | 2017-12-11 11:20:59.382+00 | 2019-01-18 11:28:29.613+00 | | 1 | | | 1 | REL-000057 | table | Listagem das parcelas que não foram pagas. | Parcelas - Parcelas a pagar | expense_parcel |
| | 1 | 154 | | 1 | 78 | {"table":"transaction","relationships":["cost_center"],"type":"matrix","fields":[{"table":"transaction","column":"cost_center_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":"Abastecimentos","type":"formula","query":"SUM(transaction.fuel_supplies)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Manutenção","type":"formula","query":"SUM(transaction.maintenance)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Pneus","type":"formula","query":"SUM(transaction.tires)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Outros","type":"formula","query":"SUM(transaction.others)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Total Despesas","type":"formula","query":"SUM(transaction.expenses)","showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Receitas","type":"formula","query":"SUM(transaction.revenues)","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":"cost_center_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.cost_center_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:45.673+00 | 2019-01-24 19:42:20.879+00 | | 2 | | | 2 | REL-000078 | matrix | | Receitas x Tipos de custo mensais por Centro de Custo | transaction |
| | 1 | 65 | {"type":"column","categories":"trip.employee_id","values":[{"column":"_formula.Lucro por Km rodado","rawColumn":"_formula.Lucro por Km rodado","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 8 | {"table":"trip","relationships":["employee","route","vehicle"],"type":"table","fields":[{"table":"trip","column":"employee_id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"name","type":"STRING","showAt":null,"format":null},{"table":"trip","column":"date","type":"DATE","showAt":null,"format":null},{"table":"trip","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"route_id","type":"INTEGER","showAt":null,"format":null},{"table":"trip","column":"total_income","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"total_cost","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"margin","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"distance","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"cost_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"trip","column":"balance_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"_formula","column":"Lucro por Km rodado","type":"formula","query":"( SUM(trip.total_income) - SUM(trip.total_cost) ) / SUM(trip.distance)","showAt":null,"format":null}],"filters":[{"field":"trip.status","operator":"equal","condition":"AND","value":["Terminada"],"references":null,"format":"list:tripStatus","type":"STRING"}],"aggregates":[{"table":"trip","column":"employee_id","group":true,"sum":false,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[]} | 2016-06-29 21:23:34.077+00 | 2017-11-09 18:39:47.524+00 | | | | | | REL-000008 | table | | Viagens - DRE das viagens terminadas por colaborador | trip |
| | 1 | 123 | {"type":"column","categories":"vehicle.name","values":[{"column":"transaction.traveled_distance","rawColumn":"transaction.traveled_distance__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 50 | {"table":"transaction","relationships":["item","vehicle"],"type":"table","fields":[{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"type","type":"STRING","showAt":null,"format":"list:transactionTypes"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","showAt":null,"format":null},{"table":"item","column":"name","type":"STRING","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"_formula","column":"Custo por hora trabalhada","type":"formula","query":"SUM(transaction.final_value) / SUM(transaction.traveled_distance)","showAt":null,"format":null}],"filters":[{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING"},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"vehicle.measurement_unit","operator":"equal","condition":"AND","value":["hours"],"references":null,"format":"list:unitMeasure","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"vehicle","column":"name","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"transaction","column":"traveled_distance","group":false,"sum":true,"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":"vehicle","column":"name","isHeaderColumn":false,"desc":false},{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}]} | 2017-10-26 13:59:25.481+00 | 2017-10-26 13:59:25.481+00 | | 1 | | | 1 | REL-000050 | table | | Despesas - Custos por hora trabalhada por veículo em detalhes mês atual | transaction |
| | | | {"type":"column","categories":"vehicle.license_plate","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 2 | 4017 | {"table":"transaction","relationships":["expense","vehicle"],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"invoice_due_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"expense","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1,1892],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"vehicle","column":"license_plate","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Placa","id":"vehicle.license_plate"}],"preview":false,"orderBy":[{"table":"transaction","column":"invoice_due_date","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2022-12-23 19:33:28.435+00 | 2024-03-27 18:03:45.36+00 | | 77 | 1172 | | 77 | REL-004017 | table | Relatório , que mostra o vencimento da fatura | Despesas de multa da Smartech | transaction |
| | | | | 268 | 5051 | {"table":"tire_life","relationships":["tire"],"type":"table","fields":[{"table":"tire","column":"tire_brand_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"current_life","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"repair_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"covered_distance","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"life_total_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"tire_dimension_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"durability_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire_life","column":"durability_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"tire","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:tireStatus","daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"tire_life","column":"life_total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"tire_life","column":"repair_cost","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"tire_life","column":"covered_distance","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} | 2023-08-22 18:45:29.711+00 | 2023-08-22 19:10:11.689+00 | 2023-08-22 19:10:11.684+00 | 77 | 77 | 77 | 77 | REL-005051 | table | | dsfgdsg | tire_life |
| | 1 | 68 | {"type":"column","categories":"trip.date","values":[{"column":"trip.total_income","rawColumn":"trip.total_income__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 10 | {"table":"trip","relationships":["vehicle"],"type":"matrix","fields":[{"table":"vehicle","column":"name","type":"STRING","showAt":{"inner":true,"total":true},"format":null},{"table":"trip","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null},{"table":"trip","column":"total_income","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"trip","column":"total_cost","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"trip","column":"margin","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":null},{"table":"_formula","column":"Qtd de viagens","type":"formula","query":"COUNT(trip.id)","showAt":{"inner":true,"total":true},"format":null}],"filters":[],"aggregates":[{"table":"vehicle","column":"name","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"trip","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"trip","column":"total_income","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"total_cost","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"trip","column":"margin","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"trip","column":"date","isHeaderColumn":true,"desc":false}]} | 2016-06-29 21:23:34.087+00 | 2017-10-13 12:41:25.369+00 | | | | | | REL-000010 | matrix | | Viagens - DRE mensal das viagens terminadas por veículo | trip |
| | 1 | 135 | {"type":"donut","categories":"vehicle.subsidiary_id","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","axis":0,"summarizer":"formula","isMainValue":true}],"legend":{"enabled":true}} | 1 | 55 | {"table":"vehicle","relationships":["subsidiary"],"type":"table","fields":[{"table":"vehicle","column":"subsidiary_id","type":"INTEGER","showAt":null,"format":null},{"table":"subsidiary","column":"alert_users","type":"JSON","showAt":null,"format":"association:user"},{"table":"vehicle","column":"name","type":"STRING","showAt":null,"format":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"format":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(vehicle.id)","showAt":null,"format":null}],"filters":[{"field":"vehicle.status","operator":"equal","condition":"AND","value":["active"],"references":null,"format":"list:vehicleStatus","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"table":"vehicle","column":"subsidiary_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"translated":"Filial","id":"vehicle.subsidiary_id"}],"preview":false,"orderBy":[{"table":"vehicle","column":"name","isHeaderColumn":true,"desc":false}]} | 2018-02-05 19:41:39.632+00 | 2018-03-19 20:41:38.976+00 | | 1 | | | 1 | REL-000055 | table | | Cadastros - Veículos ativos por filial | vehicle |