<dataConfig>
    <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3308/signcatch_sandbox_app2" user="*******" password="********" />
    <document>
        <entity name="refund_orders"
                pk="id"
                query="select
            op.id,
            o.store_id,
            op.created_at as bill_date,
        o.refunded_order_no as original_order_no,
        o.order_id as refunded_orderid,
        op.sku as sku_code,
        op.batch_no as plu_code,
        op.product_name as description,
        op.quantity as qty,
        op.price as price,
        op.discount as discount,
        (op.pre_tax_amount+op.tax_amount) as amount,
        ml.location as pos_name,
        mm.first_name as user,
        o.manager_id as user_id,
        op.created_at,
        op.updated_at
        from order_product as op
        LEFT JOIN `order` o ON(o.order_id=op.order_no)
        LEFT JOIN merchant_manager mm ON(mm.id=o.manager_id)
        LEFT JOIN merchant_location ml ON(ml.id=o.merchant_location_id)

        WHERE op.refund_order_id!=0
        GROUP BY op.id
        ORDER BY op.created_at ASC
    "
                deltaImportQuery="
        SELECT
        op.id,
        o.store_id,
        op.created_at as bill_date,
        o.refunded_order_no as original_order_no,
        o.order_id as refunded_orderid,
        op.sku as sku_code,
        op.batch_no as plu_code,
        op.product_name as description,
        op.quantity as qty,
        op.price as price,
        op.discount as discount,
        (op.pre_tax_amount+op.tax_amount) as amount,
        ml.location as pos_name,
        mm.first_name as user,
        o.manager_id as user_id,
        op.created_at,
        op.updated_at
        from order_product as op
        LEFT JOIN `order` o ON(o.order_id=op.order_no)
        LEFT JOIN merchant_manager mm ON(mm.id=o.manager_id)
        LEFT JOIN merchant_location ml ON(ml.id=o.merchant_location_id)

        WHERE op.refund_order_id!=0 AND op.id='${dih.delta.id}' "

                deltaQuery="
        SELECT op.id as id
        FROM order_product as op
        WHERE op.refund_order_id!=0 AND updated_at>'${dih.delta.refund_orders.last_index_time}"
                >
            <field column="id" name="id" />
            <field column="store_id" name="store_id" />
            <field column="bill_date" name="bill_date" />
            <field column="original_order_no" name="original_order_no" />
            <field column="refunded_orderid" name="refunded_orderid" />
            <field column="sku_code" name="sku_code" />
            <field column="plu_code" name="plu_code" />
            <field column="description" name="description" />
            <field column="qty" name="qty" />
            <field column="price" name="price" />
            <field column="qty" name="qty" />
            <field column="discount" name="discount" />
            <field column="amount" name="amount" />
            <field column="pos_name" name="pos_name" />
            <field column="user" name="user" />
            <field column="user_id" name="user_id" />
            <field column="created_at" name="created_at" />
            <field column="updated_at" name="updated_at" />
        </entity>
    </document>
</dataConfig>