- aplicatie MVC scrisa in php cu baza de date mysql - rutele vor fi sub forma: domeniu.ro/modul/pagina/actiune exemplu: app.ingesta.ro/employees/add - autentificarea se va face pe baza de email si parola - autentificarea reusita te va redirectiona catre dashboard cu ruta domeniu.ro/dashboard - permisiunile sa fie de forma RBAC. Flux de informatii in aplicatie: 1. Utilizatorul se autentificare 1.1. daca se autentifica cu succes - redirectionare catre dashboard 1.2. daca datele nu sunt corecte / greiste / nu exista - primeste mesaj pe pagina de login 2. Utilizatorul poate sa adauge un client nou -> partner -> partner_id - id unic de identificare -> partner_name -> fiscal_number -> addressS -> erp_id -> proiects -> project_id - id unic de identificare -> project_name -> start_date - date time -> end_date - date time -> partner_id - se preia din tabela Partner -> budget_ini -> budget_total -> expenses_employees -> expenses_auxiliary -> expenses_total -> responsible - json (se populeaza cu id-uri din tabela person) -> team - json (se populeaza cu id-uri din tabela person) -> project_state_id - se preia din tabela project_state -> internal_time - se preia automat cu data si ora la care a fost creat -> project_detail -> project_activity -> activity_id - id unic de identificare -> activity -> project_id - id-ul proiectului pentru care se intampla evenimentul -> internal_time - se preia automat cu data si ora la care a fost creat -> person_id - se preia din tabela person -> activity_detail -> project_state -> state_id -> state_name -> active - valoare 0 sau 1 -> person -> person_id -> first_name -> last_name -> email -> phone -> position_id - se preia din tabela positions -> department_id - se preia din tabela department_id -> color_hex -> erp_id -> hcm_id -> revisal_id -> marca_no -> is_active -> users -> user_id -> user_name -> password -> person_id - se preia din tabela person -> last_login -> internal_time -> is_active - valoare 0/1 -> user_role -> user_id -> role_id -> is_active -> role -> role_id -> role_name -> is_active -> user_permissions -> user_id -> permissions_id -> is_active -> permissions -> permissions_id -> permissions -> permissions_code -> is_active -> department -> department_id -> department -> is_active -> position -> position_id -> position -> is_active -> employee_salaries -> id -> employee_id - se preia din person, coloana person_id -> month - data in format YYYY-mm -> salary_net -> salary_brut -> diurnal -> bonus -> cam -> meal_voucher -> collected - valoare 0 sau 1 -> employee_time -> id -> employee_id -> project_id -> task_id -> start_date -> end_date -> location -> detail -> 2fa -> uniqe_identification -> task -> task_id -> task_name -> project_id -> start_time -> end_time -> responsible - json -> team - json -> task_status_id -> budget_ini -> budget_total -> expenses_employees -> expenses_auxiliary -> expenses_total -> expenses -> expenses_id -> expenses_name -> expenses_type_id -> value -> tva -> project_id -> task_id -> description -> is_collected -> expenses_type -> expenses_type_id -> expenses_name -> is_general_expenses - valoare 0 sau 1 -> is_active