ISMAIL MASSERAN
51 lines
1.4 KiB
Markdown
51 lines
1.4 KiB
Markdown
If you does't know what is this you probably in wrong project
|
|
|
|
```sql
|
|
--- for all ip
|
|
CREATE USER 'kaunteruser'@'%' IDENTIFIED BY 'your_password';
|
|
|
|
--- for specific ip
|
|
CREATE USER 'kaunteruser'@'localhost' IDENTIFIED BY 'your_password';
|
|
|
|
GRANT ALL PRIVILEGES ON kaunter_erahn.* TO 'kaunteruser'@'%';
|
|
FLUSH PRIVILEGES;
|
|
```
|
|
|
|
# ADDITIONAL NOTE
|
|
|
|
## customers/v2/index.blade.php is modal to register customer
|
|
|
|
## Min Komoditi = RM5000
|
|
|
|
# System Flowchart
|
|
|
|
## Proses Gadaian
|
|
1) Pelanggan datang bawa marhun
|
|
2) Teller daftar maklumat pelanggan jika pelanggan baharu
|
|
3) Serah marhun ke penilai untuk timbang
|
|
4) Teller daftar marhun di sistem berdasarkan maklumat dari penilai
|
|
5) Penilai print SAG dan serah marhun ke Khazanah (PC/PPC) - __khazanah can still scan still scan though__
|
|
6) Khazanah scan barcode dekat SAG untuk masuk ke dalam peti besi
|
|
* table involved - gadai.semakbarcode (default is blank, after is Lulus)
|
|
7) DONE
|
|
|
|
## Setup new branch command:
|
|
1. Duplicate previous branch table - use erahn_{{name}}
|
|
```sql
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
SET SESSION group_concat_max_len = 1000000;
|
|
|
|
SELECT GROUP_CONCAT(
|
|
CONCAT('TRUNCATE TABLE `', table_name, '`')
|
|
SEPARATOR '; '
|
|
) INTO @sql
|
|
FROM information_schema.tables
|
|
WHERE table_schema = DATABASE();
|
|
|
|
SELECT @sql; --- copy the output and paste it
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
```
|
|
2. Add new cawangan kod on master_erahn.arrahn_master_db and and kaunter_erahn.cawangan
|
|
3. Register new cawangan detail in erahn_{{name}}.cawangan |