select
  "sessions"."id"                                        as "Cashdesk Session",
  "sessions"."name"                                      as "Cashdesk",
  "sessions"."login"                                     as "Cashier login",
  "checks"."x_sum"                                       as "Checks",
  "income"."x_sum"                                       as "Income",
  "outcome"."x_sum"                                      as "Outcome",
  "goods"."x_sum"                                        as "Goods",
  "services"."x_sum"                                     as "Services",
  "refund"."x_sum"                                       as "Returned",
  "cancel"."x_sum"                                       as "Canceled",
  "x_report"."x_sum"                                     as "Total amount",
  coalesce("checks"."x_sum", 0)
  + coalesce("income"."x_sum", 0)
  + coalesce("outcome"."x_sum", 0)
  + coalesce("goods"."x_sum", 0)
  + coalesce("services"."x_sum", 0)
  + coalesce("refund"."x_sum", 0)
  + coalesce("cancel"."x_sum", 0)                        as "Columns Sum",
  "x_report"."x_sum" - (coalesce("checks"."x_sum", 0)
                        + coalesce("income"."x_sum", 0)
                        + coalesce("outcome"."x_sum", 0)
                        + coalesce("goods"."x_sum", 0)
                        + coalesce("services"."x_sum", 0)
                        + coalesce("refund"."x_sum", 0)
                        + coalesce("cancel"."x_sum", 0)) as "DIFF"
from (select
        "t1"."employee_session_id" as "employee_session_id",
        "t2"."login"               as "login",
        "t3"."name"                as "name",
        "t1"."start_date"          as "start_date",
        "t1"."end_date"            as "end_date",
        "t4"."id"                  as "id",
        "t5"."dic_office_name"     as "dic_office_name",
        "t1"."dic_office_id"       as "dic_office_id"
      from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
        inner join "main_payment" as "t7" on ("t7"."payment_id" = "t6"."payment_id")
        inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
        inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
        inner join "main_dic_user" as "t2" on ("t2"."dic_user_id" = "t1"."dic_user_id")
        inner join "main_dic_office" as "t5" on ("t5"."dic_office_id" = "t1"."dic_office_id")
        inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
      group by "t1"."employee_session_id", "t4"."id", "t5"."dic_office_id", "t2"."dic_user_id", "t3"."id") as "sessions"
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 10)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join
               "main_cashdesk_operation" as "t6"
                 on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7"
                 on (("t7"."payment_id" = "t6"."payment_id") and
                     ("t7"."dic_payment_type_id" = 10))
               inner join "main_dic_payment_type" as "t8"
                 on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_cashdesk_session" as "t4"
                 on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3"
                 on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id",
               "t3"."id") as "income"
    on (("sessions"."employee_session_id" = "income"."employee_session_id") and ("sessions"."id" = "income"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 1)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t7"."payment_id" = "t6"."payment_id") and ("t7"."dic_payment_type_id" = 1))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               left join "main_shop_cart" as "t9" on ("t9"."item_check_id" = "t6"."item_id")
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             where ("t9"."item_check_id" is null)
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "checks"
    on (("sessions"."employee_session_id" = "checks"."employee_session_id") and ("sessions"."id" = "checks"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE("t10"."selling_price", 0) * t11.quantity) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t7"."payment_id" = "t6"."payment_id") and ("t7"."dic_payment_type_id" = 1))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_shop_cart" as "t9" on ("t9"."item_check_id" = "t6"."item_id")
               inner join "main_shop_cart_position" as "t11" on ("t11"."shop_cart_id" = "t9"."id")
               inner join "main_shop_entity" as "t10" on (("t11"."shop_entity_id" = "t10"."id") and ("t10"."type" = 0))
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "goods"
    on (("sessions"."employee_session_id" = "goods"."employee_session_id") and ("sessions"."id" = "goods"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE("t10"."selling_price", 0) * t11.quantity) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t7"."payment_id" = "t6"."payment_id") and ("t7"."dic_payment_type_id" = 1))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_shop_cart" as "t9" on ("t9"."item_check_id" = "t6"."item_id")
               inner join "main_shop_cart_position" as "t11" on ("t11"."shop_cart_id" = "t9"."id")
               inner join "main_shop_entity" as "t10" on (("t11"."shop_entity_id" = "t10"."id") and ("t10"."type" = 1))
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "services"
    on (("sessions"."employee_session_id" = "services"."employee_session_id") and ("sessions"."id" = "services"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 0)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t7"."payment_id" = "t6"."payment_id") and ("t7"."dic_payment_type_id" = 12))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "outcome" on (("sessions"."employee_session_id" = "outcome"."employee_session_id") and ("sessions"."id" = "outcome"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 0)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1" inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t6"."payment_id" = "t7"."payment_id") and ("t7"."dic_payment_type_id" = 9))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "refund" on (("sessions"."employee_session_id" = "refund"."employee_session_id") and ("sessions"."id" = "refund"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 0)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1"
               inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on (("t6"."payment_id" = "t7"."payment_id") and ("t7"."dic_payment_type_id" = 8))
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "cancel" on (("sessions"."employee_session_id" = "cancel"."employee_session_id") and ("sessions"."id" = "cancel"."id"))
  left join (select
               "t1"."employee_session_id",
               SUM(COALESCE(("t8"."sign" * "t7"."payed_amount"), 0)) as "x_sum",
               "t3"."name",
               "t4"."start_date",
               "t4"."end_date",
               "t4"."id"
             from "main_employee_session" as "t1"
               inner join "main_cashdesk_operation" as "t6" on ("t6"."employee_session_id" = "t1"."employee_session_id")
               inner join "main_payment" as "t7" on ("t7"."payment_id" = "t6"."payment_id")
               inner join "main_dic_payment_type" as "t8" on ("t7"."dic_payment_type_id" = "t8"."dic_payment_type_id")
               inner join "main_cashdesk_session" as "t4" on ("t4"."id" = "t6"."cashdesk_session_id")
               inner join "main_cashdesk" as "t3" on ("t3"."id" = "t6"."cashdesk_id")
             group by "t1"."employee_session_id", "t4"."id", "t3"."id") as "x_report"
    on (("sessions"."employee_session_id" = "x_report"."employee_session_id") and ("sessions"."id" = "x_report"."id"))
where
  (((("sessions"."start_date" between '2019-03-15' and '2019-03-30') or (("sessions"."end_date" is null) and ("sessions"."start_date" <= now()))) or
    ("sessions"."end_date" between '2019-03-15' and '2019-03-30')) and ("sessions"."dic_office_id" = 1))
order by "sessions"."employee_session_id" desc
limit 1000;