2020-07-09
==========================================
- add column active to table users
- add column alias in table permission
- update data in permission to lowercase
- change column tel to phone in table users
- add column active in table roles
- add public permission
- add qr code permission
- change column size photo in employees table
- change column size logo in companies table
- add table groups
- add column cgroup in table companies
- run sql statement to update all company type to សហគ្រាសគ្រឹះស្ថាន
    update companies set cgroup = 'សហគ្រាសគ្រឹះស្ថាន' where type='company';
- edit enterprise permission to 'ក្រុមហ៊ុនផ្តល់សេវា'
- set column latlong to default 0,0
- set lat column default to 0
- set lng column default to 0
========================================================================
- block and unblick qr employee - DONE
- validate company name and address, no duplicate - DONE
- validate employee name and dob, no duplicate - DONE
- auto add company name to work experience when change company
- in education, "វគ្គបំប៉នជំនាញភ្នាក់ងារសន្តិសុខឯកជន" (បានឆ្លង ឬមិនបានឆ្លង)
    add input box for វគ្គទី (eg. 3)

- in user log, add filter role

======================================================

- in company detail, add contract (number, date, expired....) (មានច្បាប់ បានមានកិច្ចសន្យា)
- ថែមសញ្ជាតិ សម្រាប់ម្ចាស់អាជិវកម្ម
- មានភាគហ៊ុន ឬអត់ សម្រាប់បង្កើតក្រុមហ៊ុន បើមានភាគហ៊ុន ត្រូវបន្ថែមម្ចាស់ភាគហ៊ុន
 - add colunm វគ្គទី ក្នុងប្រវត្តរូបបុគ្គលិក
 - employee code is optional
 - report employee input by office (k1, k2, k3, k4...)

 ====================================
 - add filter report employee is trained or note
 - expired card 1 year (load from training)
 - in training employee, add វគ្គទី, ដូរឆ្នាំ ទៅ ថ្ងៃខែ
 - in dashboard, add total expired card employee and printable in list
 - remove duplicate employee, keep only ក៤ (Code: CPP-*)