Acknowledgement

# language: en
@integratie @stap-documentatie
Feature: Acknowledgement

  Scenario: {kind} was acknowledged by {ouder} on {datum}
    Given the woman 'P1', born yesterday 45 years ago
    And 'P2', born tomorrow 17 years ago
    And 'P2' was acknowledged by 'P1' on 1-2-2023
    When the SQL statements generated from the Given steps have been executed
    Then person 'P1' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P1    |          0 |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum     | burger_service_nr | geslachts_aand | geboorte_land_code | akte_nr |
      | P1    |         0 |       0 | P            | P1             | gisteren - 45 jaar |         000000012 | V              |               6030 | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | geboorte_datum   |
      | P1    |         0 |       0 | K            |         000000024 | P2             | 1_C____ | morgen - 17 jaar |
    And person 'P2' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P2    |          0 |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       1 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_A____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       0 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_C____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | familie_betrek_start_datum | geslachts_aand | geboorte_datum     |
      | P2    |         0 |       0 |            1 |         000000012 | P1             | 1_C____ |                   20230201 | V              | gisteren - 45 jaar |

  Scenario: {kind} was acknowledged {relatieve datum} by {ouder}
    Given the woman 'P1', born yesterday 45 years ago
    And 'P2', born tomorrow 17 years ago
    And 'P2' was acknowledged by 'P1' 2 years ago
    When the SQL statements generated from the Given steps have been executed
    Then person 'P1' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P1    |          0 |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum     | burger_service_nr | geslachts_aand | geboorte_land_code | akte_nr |
      | P1    |         0 |       0 | P            | P1             | gisteren - 45 jaar |         000000012 | V              |               6030 | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | geboorte_datum   |
      | P1    |         0 |       0 | K            |         000000024 | P2             | 1_C____ | morgen - 17 jaar |
    And person 'P2' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P2    |          0 |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       1 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_A____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       0 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_C____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | familie_betrek_start_datum | geslachts_aand | geboorte_datum     |
      | P2    |         0 |       0 |            1 |         000000012 | P1             | 1_C____ |             2 jaar geleden | V              | gisteren - 45 jaar |

  Scenario: {kind} was acknowledged by {ouder} at the birth declaration
    Given the woman 'P1', born yesterday 45 years ago
    And 'P2', born tomorrow 17 years ago
    And 'P2' was acknowledged by 'P1' at the birth declaration
    When the SQL statements generated from the Given steps have been executed
    Then person 'P1' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P1    |          0 |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum     | burger_service_nr | geslachts_aand | geboorte_land_code | akte_nr |
      | P1    |         0 |       0 | P            | P1             | gisteren - 45 jaar |         000000012 | V              |               6030 | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | geboorte_datum   |
      | P1    |         0 |       0 | K            |         000000024 | P2             | 1_B____ | morgen - 17 jaar |
    And person 'P2' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P2    |          0 |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       1 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_A____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       0 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_B____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr | familie_betrek_start_datum |
      | P2    |         0 |       0 |            1 |         000000012 | P1             | 1_B____ | morgen - 17 jaar           |

  Scenario Outline: {kind} was acknowledged by {ouder} {na geboorteaangifte|bij notariële akte|met gerechtelijke vaststelling ouderschap} on {datum}
    Given the woman 'P1', born yesterday 45 years ago
    And 'P2', born tomorrow 17 years ago
    And 'P2' was acknowledged by 'P1' <soort erkenning> on 1-2-2023
    When the SQL statements generated from the Given steps have been executed
    Then person 'P1' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P1    |          0 |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum     | burger_service_nr | geslachts_aand | geboorte_land_code | akte_nr |
      | P1    |         0 |       0 | P            | P1             | gisteren - 45 jaar |         000000012 | V              |               6030 | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr       | geboorte_datum   |
      | P1    |         0 |       0 | K            |         000000024 | P2             | <akte nummer> | morgen - 17 jaar |
    And person 'P2' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P2    |          0 |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr |
      | P2    |         0 |       1 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | 1_A____ |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geboorte_datum   | burger_service_nr | geboorte_land_code | akte_nr       |
      | P2    |         0 |       0 | P            | P2             | morgen - 17 jaar |         000000024 |               6030 | <akte nummer> |
    And person 'P2' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | akte_nr       | familie_betrek_start_datum |
      | P2    |         0 |       0 |            1 |         000000012 | P1             | <akte nummer> |                   20230201 |

    Examples:
      | soort erkenning                           | akte nummer |
      | na geboorteaangifte                       |     1_C____ |
      | bij notariële akte                        |     1_J____ |
      | met gerechtelijke vaststelling ouderschap |     1_V____ |

  Scenario: there is already an empty category ouder 2 and {aanduidingMinderjarige} was acknowledged by {aanduidingErkenner} after the birth declaration on {datum}
    Given the minor 'P1' with one parent 'P2'
    And the man 'P3', born yesterday 35 years ago
    And 'P1' was acknowledged by 'P3' after the birth declaration on 13-05-2024
    When the SQL statements generated from the Given steps have been executed
    Then person 'P1' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | P1    |          0 |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | akte_nr |
      | P1    |         0 |       1 | P            | P1             | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | akte_nr |
      | P1    |         0 |       0 | P            | P1             | 1_C____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | geslachts_naam | geslachts_aand | familie_betrek_start_datum | akte_nr |
      | P1    |         0 |       0 |            1 | P2             | V              | gisteren - 17 jaar         | 1_A____ |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | akte_nr | geldigheid_start_datum | geslachts_naam | familie_betrek_start_datum |
      | P1    |         0 |       1 |            2 | 1_A____ | gisteren - 17 jaar     |                |                            |
    And person 'P1' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | akte_nr | geslachts_naam | geboorte_datum     | geslachts_aand | familie_betrek_start_datum |
      | P1    |         0 |       0 |            2 | 1_C____ | P3             | gisteren - 35 jaar | M              |                   20240513 |