CLASS {{p}}bake_hidden DEFINITION PUBLIC FINAL CREATE PUBLIC
  FOR TESTING DURATION SHORT RISK LEVEL HARMLESS.
  PRIVATE SECTION.
    TYPES tt_shop TYPE RANGE OF {{p}}deliv-shop.
    METHODS run
      IMPORTING iv_date        TYPE d
                it_shop        TYPE tt_shop OPTIONAL
      RETURNING VALUE(rr_data) TYPE REF TO data.
    METHODS lines_of
      IMPORTING ir_data         TYPE REF TO data
      RETURNING VALUE(rv_lines) TYPE i.
    METHODS value_of
      IMPORTING ir_data        TYPE REF TO data
                iv_row         TYPE i
                iv_col         TYPE string
      RETURNING VALUE(rv_value) TYPE string.
    METHODS all_shops_for_date FOR TESTING.
    METHODS sorted_by_revenue FOR TESTING.
    METHODS totals_and_counts FOR TESTING.
    METHODS shop_filter FOR TESTING.
    METHODS date_filter FOR TESTING.
    METHODS empty_result FOR TESTING.
    METHODS tie_break_by_shop FOR TESTING.
ENDCLASS.

CLASS {{p}}bake_hidden IMPLEMENTATION.
  METHOD run.
    cl_salv_bs_runtime_info=>set( display = abap_false metadata = abap_false data = abap_true ).
    SUBMIT {{p}}bake_sales WITH p_date = iv_date WITH s_shop IN it_shop AND RETURN.
    TRY.
        cl_salv_bs_runtime_info=>get_data_ref( IMPORTING r_data = rr_data ).
      CATCH cx_salv_bs_sc_runtime_info.
    ENDTRY.
    cl_salv_bs_runtime_info=>clear_all( ).
  ENDMETHOD.

  METHOD lines_of.
    FIELD-SYMBOLS <lt_data> TYPE STANDARD TABLE.
    IF ir_data IS BOUND.
      ASSIGN ir_data->* TO <lt_data>.
      DESCRIBE TABLE <lt_data> LINES rv_lines.
    ENDIF.
  ENDMETHOD.

  METHOD value_of.
    FIELD-SYMBOLS <lt_data> TYPE STANDARD TABLE.
    FIELD-SYMBOLS <ls_line> TYPE any.
    FIELD-SYMBOLS <lv_value> TYPE any.
    DATA lv_text TYPE string.
    ASSIGN ir_data->* TO <lt_data>.
    READ TABLE <lt_data> ASSIGNING <ls_line> INDEX iv_row.
    cl_abap_unit_assert=>assert_subrc( exp = 0 msg = 'row not found' ).
    ASSIGN COMPONENT iv_col OF STRUCTURE <ls_line> TO <lv_value>.
    cl_abap_unit_assert=>assert_subrc( exp = 0 msg = 'column not found' ).
    lv_text = <lv_value>.
    SHIFT lv_text LEFT DELETING LEADING space.
    SHIFT lv_text RIGHT DELETING TRAILING space.
    rv_value = lv_text.
  ENDMETHOD.

  METHOD all_shops_for_date.
    cl_abap_unit_assert=>assert_equals( exp = 5 act = lines_of( run( '20260401' ) ) ).
  ENDMETHOD.

  METHOD sorted_by_revenue.
    DATA lr_data TYPE REF TO data.
    lr_data = run( '20260401' ).
    cl_abap_unit_assert=>assert_equals( exp = 'SUED' act = value_of( ir_data = lr_data iv_row = 1 iv_col = 'SHOP' ) ).
    cl_abap_unit_assert=>assert_equals( exp = 'OST' act = value_of( ir_data = lr_data iv_row = 5 iv_col = 'SHOP' ) ).
  ENDMETHOD.

  METHOD totals_and_counts.
    DATA lr_data TYPE REF TO data.
    lr_data = run( '20260401' ).
    cl_abap_unit_assert=>assert_equals( exp = 'NORD' act = value_of( ir_data = lr_data iv_row = 2 iv_col = 'SHOP' ) ).
    cl_abap_unit_assert=>assert_equals( exp = '150' act = value_of( ir_data = lr_data iv_row = 2 iv_col = 'LOAVES' ) ).
    cl_abap_unit_assert=>assert_equals( exp = '400.00' act = value_of( ir_data = lr_data iv_row = 2 iv_col = 'REVENUE' ) ).
    cl_abap_unit_assert=>assert_equals( exp = '2' act = value_of( ir_data = lr_data iv_row = 2 iv_col = 'DELIVERIES' ) ).
  ENDMETHOD.

  METHOD shop_filter.
    DATA lr_data TYPE REF TO data.
    DATA lt_shop TYPE tt_shop.
    DATA ls_shop LIKE LINE OF lt_shop.
    ls_shop-sign = 'I'.
    ls_shop-option = 'EQ'.
    ls_shop-low = 'NORD'.
    APPEND ls_shop TO lt_shop.
    lr_data = run( iv_date = '20260401' it_shop = lt_shop ).
    cl_abap_unit_assert=>assert_equals( exp = 1 act = lines_of( lr_data ) ).
    cl_abap_unit_assert=>assert_equals( exp = '150' act = value_of( ir_data = lr_data iv_row = 1 iv_col = 'LOAVES' ) ).
    cl_abap_unit_assert=>assert_equals( exp = '400.00' act = value_of( ir_data = lr_data iv_row = 1 iv_col = 'REVENUE' ) ).
  ENDMETHOD.

  METHOD date_filter.
    DATA lr_data TYPE REF TO data.
    lr_data = run( '20260331' ).
    cl_abap_unit_assert=>assert_equals( exp = 1 act = lines_of( lr_data ) ).
    cl_abap_unit_assert=>assert_equals( exp = '999' act = value_of( ir_data = lr_data iv_row = 1 iv_col = 'LOAVES' ) ).
    cl_abap_unit_assert=>assert_equals( exp = '9980.01' act = value_of( ir_data = lr_data iv_row = 1 iv_col = 'REVENUE' ) ).
  ENDMETHOD.

  METHOD empty_result.
    cl_abap_unit_assert=>assert_equals( exp = 0 act = lines_of( run( '20200101' ) ) ).
  ENDMETHOD.

  METHOD tie_break_by_shop.
    DATA lr_data TYPE REF TO data.
    lr_data = run( '20260401' ).
    cl_abap_unit_assert=>assert_equals( exp = 'MITT' act = value_of( ir_data = lr_data iv_row = 3 iv_col = 'SHOP' ) ).
    cl_abap_unit_assert=>assert_equals( exp = 'WEST' act = value_of( ir_data = lr_data iv_row = 4 iv_col = 'SHOP' ) ).
  ENDMETHOD.
ENDCLASS.