view_api_reportoperation

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

created_at

date

13

√

null

name

text

2147483647

√

null

monto

float8

17,17

√

null

envases

int4

10

√

null

office_id

int4

10

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT DISTINCT to_date(to_char(ro.created_at, 'YYYYMMDD'::text), 'YYYYMMDD'::text) AS created_at,
    'ATM'::text AS name,
    ro.atm AS monto,
    0 AS envases,
    ro.office_id
   FROM ((api_reportoperation ro
     LEFT JOIN api_reportoperation_employees_open eoo ON ((eoo.reportoperation_id = ro.id)))
     LEFT JOIN api_reportoperation_employees_close eoc ON ((eoc.reportoperation_id = ro.id)))
  WHERE (ro.deleted IS NULL)
UNION ALL
 SELECT DISTINCT to_date(to_char(ro.created_at, 'YYYYMMDD'::text), 'YYYYMMDD'::text) AS created_at,
    upper('apertura efectivo'::text) AS name,
    ro.cash_opening AS monto,
    0 AS envases,
    ro.office_id
   FROM ((api_reportoperation ro
     LEFT JOIN api_reportoperation_employees_open eoo ON ((eoo.reportoperation_id = ro.id)))
     LEFT JOIN api_reportoperation_employees_close eoc ON ((eoc.reportoperation_id = ro.id)))
  WHERE (ro.deleted IS NULL)
UNION ALL
 SELECT DISTINCT to_date(to_char(ro.created_at, 'YYYYMMDD'::text), 'YYYYMMDD'::text) AS created_at,
    upper('atm transit'::text) AS name,
    ro.atm_transit_amount AS monto,
    ro.atm_transit_packings AS envases,
    ro.office_id
   FROM ((api_reportoperation ro
     LEFT JOIN api_reportoperation_employees_open eoo ON ((eoo.reportoperation_id = ro.id)))
     LEFT JOIN api_reportoperation_employees_close eoc ON ((eoc.reportoperation_id = ro.id)))
  WHERE (ro.deleted IS NULL)
UNION ALL
 SELECT DISTINCT to_date(to_char(ro.created_at, 'YYYYMMDD'::text), 'YYYYMMDD'::text) AS created_at,
    upper('envases pend.'::text) AS name,
    ro.packings_pending_amount AS monto,
    ro.packings_pending AS envases,
    ro.office_id
   FROM ((api_reportoperation ro
     LEFT JOIN api_reportoperation_employees_open eoo ON ((eoo.reportoperation_id = ro.id)))
     LEFT JOIN api_reportoperation_employees_close eoc ON ((eoc.reportoperation_id = ro.id)))
  WHERE (ro.deleted IS NULL)
UNION ALL
 SELECT DISTINCT to_date(to_char(ro.created_at, 'YYYYMMDD'::text), 'YYYYMMDD'::text) AS created_at,
    upper('horas cerrada'::text) AS name,
    COALESCE((ro.hours_close)::integer, 0) AS monto,
    0 AS envases,
    ro.office_id
   FROM ((api_reportoperation ro
     LEFT JOIN api_reportoperation_employees_open eoo ON ((eoo.reportoperation_id = ro.id)))
     LEFT JOIN api_reportoperation_employees_close eoc ON ((eoc.reportoperation_id = ro.id)))
  WHERE (ro.deleted IS NULL);

view_api_reportoperation

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views