total_current_penjualan

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id_customer

int4

10

√

null

total

numeric

0

√

null

total_diskon

numeric

0

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT sales_order.id_customer,
    sum((sales_order_hpp.qty * sales_order_detail.harga)) AS total,
    sum(
        CASE
            WHEN sales_order_hpp.is_bonus THEN (sales_order_detail.harga_asli * sales_order_hpp.qty)
            WHEN (sales_order_hpp.is_diskon AND (NOT sales_order.is_ppn)) THEN (sales_order_detail.diskon_rp_1 * sales_order_hpp.qty)
            WHEN sales_order_hpp.is_diskon THEN (((sales_order_detail.harga * sales_order_detail.diskon_persen_1) / (100)::numeric) * sales_order_hpp.qty)
            ELSE (0)::numeric
        END) AS total_diskon
   FROM ((sales_order
     JOIN sales_order_detail ON ((sales_order_detail.id = sales_order.id)))
     JOIN sales_order_hpp ON (((sales_order_hpp.id = sales_order_detail.id) AND (sales_order_hpp.id_barang = sales_order_detail.id_barang))))
  WHERE ((sales_order.status = ANY (ARRAY['D'::bpchar, 'W'::bpchar, 'C'::bpchar])) AND ((EXISTS ( SELECT 1
           FROM (surat_jalan_detail
             JOIN surat_jalan ON ((surat_jalan.id = surat_jalan_detail.id)))
          WHERE ((surat_jalan_detail.id_sales_order_hpp = sales_order_hpp.id) AND (surat_jalan_detail.urut_sales_order_hpp = sales_order_hpp.urut) AND (surat_jalan.status = ANY (ARRAY['A'::bpchar, 'P'::bpchar, 'G'::bpchar]))))) OR (NOT (EXISTS ( SELECT 1
           FROM surat_jalan
          WHERE (surat_jalan.id_sales_order = sales_order.id))))))
  GROUP BY sales_order.id_customer;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views