Skip to content

Latest commit

 

History

History
67 lines (45 loc) · 786 Bytes

README.md

File metadata and controls

67 lines (45 loc) · 786 Bytes

Zefix Validator

Setup

Database & Queue

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=33072
DB_DATABASE=check_zefix
DB_USERNAME=root
DB_PASSWORD=

QUEUE_CONNECTION=database

Zefix

ZEFIX_USERNAME=
ZEFIX_PASSWORD=

Import

Command

php artisan companies:import

Heading Row
kreditoren_nr,name,mwst_nr_clean

Path File
public storage 'Documents-20230805-091205.xlsx'

Validate

Command

php artisan companies:validate

Validations

- check_valid_uid // required|regex:/^CHE-[0-9]{3}\.[0-9]{3}\.[0-9]{3}$/
- check_account_number_duplicate
- check_account_number_duplicate_count
- check_uid_duplicate
- check_uid_duplicate_count

Zefix

Command

php artisan companies:zefix

php artisan queue:listen