<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="pharmhub-manufacturer-income-all" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2fc23dba-c4b0-4693-bc9d-30176507bee3">
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="db4pharmhub"/>
    <parameter name="manufacturer_single" class="java.lang.String"/>
    <parameter name="manufacturers_goods" class="java.lang.String"/>
    <parameter name="campaigns_endpoints_manual" class="java.lang.String"/>
    <parameter name="start_date_required" class="java.sql.Date"/>
    <parameter name="end_date_required" class="java.sql.Date">
        <parameterDescription><![CDATA[]]></parameterDescription>
    </parameter>
    <parameter name="show_empty_endpoints" class="java.lang.Boolean">
        <defaultValueExpression><![CDATA[false]]></defaultValueExpression>
    </parameter>
    <parameter name="show_empty_endpoints_sql" class="java.lang.Boolean" isForPrompting="false">
        <defaultValueExpression><![CDATA[$P{show_empty_endpoints}.equals(true) ? "" : "WHERE union_turnovers.endpoint IS NOT NULL"]]></defaultValueExpression>
    </parameter>
    <parameter name="Parameter1" class="java.lang.Float" nestedType="java.lang.Float">
        <parameterDescription><![CDATA[singlepackprice]]></parameterDescription>
    </parameter>
    <queryString language="SQL">
        <![CDATA[WITH dates AS (
  SELECT
    $P{start_date_required}::TIMESTAMP - INTERVAL '3 hours' AS "begin", -- convert to MSK TZ
    $P{end_date_required}::TIMESTAMP + INTERVAL '21 hours' AS "end"
),

-- точки продажи, по которым берутся данные
endpoints AS (
  SELECT e.id, e.client
  FROM "Endpoints" e
  JOIN "Clients" p ON p.id = e.client AND p.deleted = FALSE AND p.status = 'active'
  WHERE e.deleted = FALSE
    AND e.status = 'active'
    AND (p.data ->> 'participatesInCampaigns') = 'true'
    AND coalesce(coalesce(e.data, '{}'::JSONB) ->> 'excludedFromCampaigns', 'false') <> 'true'
    AND ($P{campaigns_endpoints_manual} IS NULL OR $X{IN, lower(e.id::VARCHAR), campaigns_endpoints_manual})
),

-- Точки продажи, для которых данные берутся из заказов
-- (не выгружают обороты или есть какие-то проблемы).
manual_order_endpoints AS (
  SELECT e.id
  FROM endpoints e
  WHERE NOT EXISTS(
    SELECT 1
    FROM dates
    JOIN "NomenclatureTurnovers" nt ON nt.endpoint = e.id
      AND nt."date" >= dates.begin AND nt."date" < dates.end
  )
      AND ($P{campaigns_endpoints_manual} IS NULL OR $X{IN, lower(e.id::VARCHAR), campaigns_endpoints_manual})
),

-- Точки продажи, для которых данные берутся из оборотов
-- (все точки минус точки по заказам)
turnover_endpoints AS (
  SELECT
    endpoints.*
  FROM endpoints
  WHERE NOT EXISTS(SELECT 1 FROM manual_order_endpoints WHERE manual_order_endpoints.id = endpoints.id)
),

-- Препараты производителя
goods AS (
    SELECT
        ce."EAN",
        max(coalesce(ce.title, rg.title)) AS title,
        avg(ce.price)::NUMERIC(20, 2) AS price
    FROM "CampaignEAN" ce
    JOIN "CampaignGood" cg ON cg.id = ce.good
    JOIN "Campaigns" c ON
        c.id = cg.campaign AND
        c.client = $P{manufacturer_single}::UUID AND
        c."isActive" = TRUE AND
        (NOW() AT TIME ZONE 'UTC') < c."endDate" AND
        c.deleted = FALSE
    LEFT JOIN "ResellerGoods" rg ON rg."EAN" = ce."EAN"
    WHERE ce."EAN" NOT LIKE 'PH.%'
      AND ($P{manufacturers_goods} IS NULL OR $X{IN, ce."EAN", manufacturers_goods})
    GROUP BY ce."EAN"
),

turnovers_goods AS (
    SELECT
        nt.*,
        goods."EAN" AS goods_ean,
        goods.title AS goods_title,
        goods.price AS goods_price
    FROM turnover_endpoints e
    JOIN goods ON TRUE
    JOIN dates ON TRUE
    JOIN "NomenclatureTurnovers" nt ON nt.endpoint = e.id
      AND nt."EAN" = goods."EAN"
      AND nt."date" >= dates.begin AND nt."date" < dates.END
    UNION ALL
    SELECT
        nt.*,
        goods."EAN" AS goods_ean,
        goods.title AS goods_title,
        goods.price AS goods_price
    FROM turnover_endpoints e
    JOIN goods ON TRUE
    JOIN dates ON TRUE
    JOIN "Nomenclatures" n ON n.client = e.client AND n."clientEAN" = goods."EAN"
    JOIN "NomenclatureTurnovers" nt ON nt.endpoint = e.id
      AND nt."nomenclatureCode" = n.nomenclature
      AND nt."EAN" IS NULL
      AND nt."date" >= dates.begin AND nt."date" < dates.END
),

turnovers AS (
  SELECT
    endpoint,
    "date",
    reseller,
    "resellerCode",
    "EAN",
    "title",
    "incomeQuantity",
    income,
    price
  FROM (
    SELECT
        nt.price,
        t.endpoint,
        t."date",
        r.title AS reseller,
        ntr."resellerCode",
        t.goods_ean AS "EAN",
        t.goods_title AS title,
        ntr."quantityDebit" AS "incomeQuantity",
        ntr."quantityDebit" * coalesce(t.goods_price, ntr."priceDebit") AS income,
        row_number() OVER (
            PARTITION BY
                nt.price,
                t.endpoint,
                t."date",
                t."nomenclatureCode",
                t."EAN",
                t."quantityEnd",
                ntr."quantityDebit",
                ntr."resellerCode"
        )
    FROM turnovers_goods t
    JOIN "NomenclatureTurnoversResellers" ntr ON ntr."nomenclatureTurnover" = t.id
    JOIN "NomenclatureTurnoversSettings" nts ON nts.endpoint = t.endpoint AND nts."resellerCode" = ntr."resellerCode"
    JOIN "Clients" r ON r.id = nts.reseller
    JOIN "NomenclatureTurnovers" nt ON nt.endpoint = e.id
        WHERE (
            NOT EXISTS(
                SELECT 1
                FROM "ManufacturerResellers" mr
                WHERE mr.manufacturer = $P{manufacturer_single}::UUID
            ) OR EXISTS(
                SELECT 1
                FROM "ManufacturerResellers" mr
                WHERE mr.manufacturer = $P{manufacturer_single}::UUID AND mr.reseller = nts.reseller
            )
        )
  ) turnovers_with_duplicates
  WHERE row_number = 1
),

-- Данные по заказам
order_endpoints AS (
  SELECT
    manual_order_endpoints.id AS endpoint,
    r.id AS reseller
  FROM manual_order_endpoints
  JOIN "Contracts" c ON c."buyerEndpoint" = manual_order_endpoints.id AND (c.status = 'approved' OR c.status = 'paused') AND c."resellerType" = 'reseller'
  JOIN "Clients" r ON r.id = c.seller
  GROUP BY manual_order_endpoints.id, r.id
),

orders AS (
  SELECT
    o.id,
    o.endpoint
  FROM dates
  JOIN "Orders" o ON o."dateSent" >= dates."begin" AND o."dateSent" < dates."end" AND o.status = 'sent'
  JOIN order_endpoints ON o.endpoint = order_endpoints.endpoint
  GROUP BY o.id, o.endpoint
),

order_turnovers as (
  SELECT
    orders.endpoint,
    oi."date",
    r.title AS reseller,
    goods."EAN",
    goods.title,
    oi.quantity AS "incomeQuantity",
    oi.quantity * goods.price AS income,
    nt.price
  FROM "OrderItems" oi
  JOIN "OrderResellers" ors ON oi."orderReseller" = ors.id
  JOIN "Clients" r ON r.id = ors.reseller
  JOIN orders ON orders.id = ors."order"
  JOIN goods ON goods."EAN" = coalesce(oi.offer ->> 'EAN', oi.offer ->> 'ean')
  JOIN "Endpoints" e ON "Clients".id = e.client
  JOIN "NomenclatureTurnovers" nt ON e.id = "NomenclatureTurnovers".endpoint
  WHERE oi.type = 'order'
      AND (
            NOT EXISTS(
                SELECT 1
                FROM "ManufacturerResellers" mr
                WHERE mr.manufacturer = $P{manufacturer_single}::UUID
            ) OR EXISTS(
                    SELECT 1
                    FROM "ManufacturerResellers" mr
                    WHERE mr.manufacturer = $P{manufacturer_single}::UUID AND mr.reseller = r.id
            )
        )
),

union_turnovers as (
  SELECT
    turnovers.endpoint,
    turnovers."date",
    turnovers.reseller,
    turnovers."resellerCode",
    turnovers."title",
    turnovers."EAN",
    turnovers."incomeQuantity",
    turnovers.income
  FROM turnovers
  UNION ALL
  SELECT
    order_turnovers.endpoint,
    order_turnovers."date",
    order_turnovers.reseller,
    'По нашим заказам' AS "resellerCode",
    order_turnovers."title",
    order_turnovers."EAN",
    order_turnovers."incomeQuantity",
    order_turnovers.income,
    order_turnovers.price
  FROM order_turnovers
)

SELECT
  union_turnovers.price as "pack",
  m.title AS manufacturer,
  union_turnovers."EAN",
  union_turnovers.title,
  p.title AS client,
  e."legalTitle" || ', ' || e.incorporation AS endpoint,
  e.inn,
  e."physicalAddress" AS address,
  sum(union_turnovers."incomeQuantity") AS "incomeQuantity",
  sum(union_turnovers.income)::NUMERIC(20, 2) AS income,
  union_turnovers.reseller,
  union_turnovers."resellerCode",
  to_char(union_turnovers."date" + INTERVAL '3 hours', 'MM.YYYY') AS "month"
FROM endpoints
LEFT JOIN union_turnovers ON union_turnovers.endpoint = endpoints.id
JOIN "Endpoints" e ON e.id = endpoints.id
JOIN "Clients" p ON p.id = e.client
JOIN "Clients" m ON m.id = $P{manufacturer_single}::UUID

$P!{show_empty_endpoints_sql}
GROUP BY
  m.id,
  p.id,
  e.id,
  union_turnovers."EAN",
  union_turnovers.title,
  union_turnovers.reseller,
  union_turnovers."resellerCode",
  to_char(union_turnovers."date" + INTERVAL '3 hours', 'MM.YYYY')
ORDER BY title, client, endpoint, address, "month";]]>
    </queryString>
    <field name="manufacturer" class="java.lang.String"/>
    <field name="EAN" class="java.lang.String"/>
    <field name="title" class="java.lang.String"/>
    <field name="client" class="java.lang.String"/>
    <field name="endpoint" class="java.lang.String"/>
    <field name="inn" class="java.lang.String"/>
    <field name="address" class="java.lang.String"/>
    <field name="incomeQuantity" class="java.lang.Float"/>
    <field name="income" class="java.math.BigDecimal"/>
    <field name="reseller" class="java.lang.String"/>
    <field name="resellerCode" class="java.lang.String"/>
    <field name="month" class="java.lang.String"/>
    <field name="pack" class="java.lang.Float"/>
    <variable name="incomeQuantityTotal" class="java.lang.Float" calculation="Sum">
        <variableExpression><![CDATA[$F{incomeQuantity}]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <variable name="incomeTotal" class="java.math.BigDecimal" calculation="Sum">
        <variableExpression><![CDATA[$F{income}]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <variable name="manufacturer" class="java.lang.String" calculation="First">
        <variableExpression><![CDATA[$F{manufacturer}]]></variableExpression>
        <initialValueExpression><![CDATA[$F{manufacturer}]]></initialValueExpression>
    </variable>
    <group name="incomeQuantityGroup">
        <groupExpression><![CDATA[$F{incomeQuantity}]]></groupExpression>
    </group>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="30">
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement x="0" y="0" width="802" height="30" uuid="b8fcd19d-e922-462b-a422-ff10844a4541"/>
                <textElement verticalAlignment="Middle">
                    <font isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA["Отчет по приходам (все аптеки) за " + $P{start_date_required} + " - " + $P{end_date_required} + " по производителю " + $V{manufacturer} + ". Дата создания отчета: " + DATEFORMAT(TODAY(),"yyyy-MM-dd HH:mm:ss")]]></textFieldExpression>
            </textField>
        </band>
    </title>
    <columnHeader>
        <band height="35" splitType="Stretch">
            <staticText>
                <reportElement x="0" y="0" width="82" height="30" uuid="aeb2a1fd-eda8-4a2f-9fdc-585c97ba920d"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[EAN]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="82" y="0" width="80" height="30" uuid="38ebc45d-2447-412b-8d12-813bee933f51"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Название]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="162" y="0" width="80" height="30" uuid="75bda337-80d7-4551-9e0e-48b1648a2bfd"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Аптека]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="242" y="0" width="80" height="30" uuid="7f91dd8a-6445-43d5-8a57-14b5b9d9298f"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Юр. название]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="322" y="0" width="68" height="30" uuid="d66e8b2c-ce41-4953-8243-a5e7bfcc62fc"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[ИНН]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="390" y="0" width="80" height="30" uuid="96dbd76b-a5e1-4333-8da0-e41dbe31d8ef"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Физический адрес]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="470" y="0" width="68" height="30" uuid="ec420bbc-26e3-476e-bb7a-d655e7c5a130"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Приход, шт.]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="538" y="0" width="70" height="30" uuid="f82e7cfb-aa7a-4ced-b582-6b432df8667c"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Приход, руб.]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="608" y="0" width="70" height="30" uuid="a36b3baa-7231-43ae-b9de-fe4d038f98f5"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Поставщик]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="678" y="0" width="60" height="30" uuid="69af0c5c-3b0d-491d-81be-f296b54757e2"/>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Код поставщика]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="738" y="0" width="64" height="30" uuid="c980d822-22e3-466a-badc-b3779f92a1b3"/>
                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Месяц]]></text>
            </staticText>
            <staticText>
                <reportElement stretchType="RelativeToBandHeight" x="802" y="2" width="64" height="30" uuid="51fdc6be-3a3c-4758-a221-b38542c5dbd5"/>
                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center" verticalAlignment="Middle"/>
                <text><![CDATA[Цена за 1 упаковку]]></text>
            </staticText>
        </band>
    </columnHeader>
    <detail>
        <band height="35" splitType="Stretch">
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="82" height="30" uuid="c406c798-6ee1-4b1a-8315-6e0cb2952063"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{EAN}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="82" y="0" width="80" height="30" uuid="e9b8ab3e-89bd-414a-8528-064494d918dc"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="162" y="0" width="80" height="30" uuid="e6bbf811-80a1-419e-8408-4fbc820fc5b7"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{client}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="242" y="0" width="80" height="30" uuid="ff0daa50-7353-4096-b3e6-e4fd7cc45e9f"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{endpoint}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="322" y="0" width="68" height="30" uuid="5124cb2d-7a64-468c-b54d-ff51f22b8db6"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{inn}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="390" y="0" width="80" height="30" uuid="7fafb004-8c5f-44e4-9b42-cb3263c96899"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{address}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="470" y="0" width="68" height="30" uuid="072ef7c3-1f58-4de9-8fbd-ae36654431c1"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{incomeQuantity}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="538" y="0" width="70" height="30" uuid="11bfa3e4-f258-4959-b1e9-5ec0db492e88"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{income}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="608" y="0" width="70" height="30" uuid="c3ae7b18-9a06-435c-8d98-259b02b1ef2a"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{reseller}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="678" y="0" width="60" height="30" uuid="c316faa7-49d4-4d1c-b743-78edc6a4f193"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{resellerCode}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="738" y="0" width="64" height="30" uuid="9e1a1fb8-17e9-4d2a-9374-7881cf4aabf4"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{month}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="800" y="0" width="64" height="30" uuid="e48060b7-7ebd-45c6-8059-fd97cf722673"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{pack}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
    <summary>
        <band height="30" splitType="Stretch">
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="470" y="0" width="68" height="30" uuid="2cec5580-3df7-4e02-8b96-f56216a1c14b"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$V{incomeQuantityTotal}]]></textFieldExpression>
            </textField>
            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="538" y="0" width="70" height="30" uuid="e4ca408c-ac00-4e41-9411-af4e6015bafd"/>
                <box padding="4">
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$V{incomeTotal}]]></textFieldExpression>
            </textField>
        </band>
    </summary>
</jasperReport>