PolicyInfo-WebApp

The PHP Project revolves around retrieving policy holder and vehicle information through Phone or Policy Number. Database referenced here are proprietary to a existing Insurance Company with sample records . Phone Number/Policy Number Is Passed As A PHP Argument During Code Execution.

Requirements

Additional PHP packages are used to help to connect to an Oracle Database. Alternative interpreters compatible with 2.0+ should work as well.

Earlier PHP versions are also supported. These versions have official support and receive security updates.

The rest-api application depends on these other gems for usage at runtime:

• oci_connect
• oci_parse
• oci_bind_by_name
• oci_error

Usage

Via Policy Number

The Policy Information Is Retrieved Through Policy Holder's Policy Number.

• Policy Number Is Passed As A PHP Argument During Code Execution. '$id = $argv[1]'.
• DB Referenced : DBM$DB.VW_POLICY_INFO & DBM$DB.VW_POLICY_VH_INFO.

[username@webapps7-dev policy]$ php policy.php JF80619
Information For Policy#ID: JF80619

[
    {
        "POLICYNUMBER": "JF80331",
        "EFFECTIVEDATE": "08\/06\/2015",
        "EXPIRATIONDATE": "08\/06\/2016",
        "PRODUCERCODE": "315995",
        "PRODUCT": "B1H",
        "PLANCODE": "515",
        "FIRSTNAME": "SAMUEL",
        "LASTNAME": "JOHNSON",
        "ADDRESS": "2400 E FORT AVE",
        "CITY": "BALTIMORE",
        "STATE": "MD",
        "ZIP": "21230-4956",
        "PHONE": "4435291059",
        "EMAIL": [email protected],
        "POLICY_ID": "JF80619"
    }
]
[
    {
        "YEAR": "2005",
        "MAKE": "HYUN",
        "MODEL": "ACCENT",
        "VIN": "KMHCG35C15U1059533",
        "POLICY_ID": "JF80619"
    }
]

Via Phone Number

The Policy Information Is Retrieved Through Policy Holder's Phone Number.

• Phone Number Is Passed As A PHP Argument During Code Execution. '$phone = $argv[1]'.
• DB Referenced : DBM$DB.VW_POLICY_INFO & DBM$DB.VW_POLICY_VH_INFO.

[username@webapps7-dev phone]$ php phone.php 4435291059
Information For Policy#ID With Phone Number: 4435291059
[
    {
         "POLICYNUMBER": "JF80619",
         "EFFECTIVEDATE": "08\/06\/2015",
         "EXPIRATIONDATE": "08\/06\/2016",
         "PRODUCERCODE": "315995",
         "PRODUCT": "B1H",
         "PLANCODE": "515",
         "FIRSTNAME": "SAMUEL",
         "LASTNAME": "JOHNSON",
         "ADDRESS": "2400 E FORT AVE",
         "CITY": "BALTIMORE",
         "STATE": "MD",
         "ZIP": "21230-4956",
         "PHONE": "4435291059",
         "EMAIL": [email protected],
         "POLICY_ID": "JF80619"
    }
]
[
    {
         "YEAR": "2005",
         "MAKE": "HYUN",
         "MODEL": "ACCENT",
         "VIN": "KMHCG35C15U1059533",
         "POLICY_ID": "JF80619"
    }
]

Legal

Released under the MIT License: https://opensource.org/licenses/MIT

Images used and considered are in the public domain.