File: /home/durgeshpandey215/www/subsidycrm/DB/enum_store_dummy_data.sql
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'product',
'[
{"id": 1,"name":"Prod A","color":"info"},
{"id": 2,"name":"Prod B","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'model',
'[
{"id": 1,"name":"Model A","for":"Prod A","color":"info"},
{"id": 2,"name":"Model B","for":"Prod A","color":"info"},
{"id": 3,"name":"Model C","for":"Prod B","color":"info"},
{"id": 4,"name":"Model D","for":"Prod B","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'variant',
'[
{"id": 1,"name":"Vary A","for":"Model A","color":"info"},
{"id": 2,"name":"Vary B","for":"Model A","color":"info"},
{"id": 3,"name":"Vary C","for":"Model B","color":"info"},
{"id": 4,"name":"Vary D","for":"Model B","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'modification',
'[
{"id": 1,"name":"Modify A","for":"Prod A","color":"info"},
{"id": 2,"name":"Modify B","for":"Prod A","color":"info"},
{"id": 3,"name":"Modify C","for":"Prod A","color":"info"},
{"id": 4,"name":"Modify D","for":"Prod A","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'fuel',
'[
{"id": 1,"name":"Petrol","color":"info"},
{"id": 2,"name":"Diesel","color":"info"},
{"id": 3,"name":"Electric","color":"info"},
{"id": 4,"name":"Hybrid","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'doc_type',
'[
{"id": 1,"name":"PAN","color":"info"},
{"id": 2,"name":"AADHAR Front","color":"info"},
{"id": 3,"name":"AADHAR back","color":"info"},
{"id": 4,"name":"Voter ID","color":"info"},
{"id": 5,"name":"Driving License","color":"info"},
{"id": 6,"name":"Bank Passbook","color":"info"},
{"id": 7,"name":"Payment Info","color":"info"}
]'
);
INSERT INTO
enum_store (`type`, `data`)
VALUES
(
'branch',
'[
{"id": 1,"name":"Mumbai(Dadar)","type":"Head","color":"info"},
{"id": 2,"name":"Mumbai(Vashi)","color":"Operation","color":"info"},
{"id": 3,"name":"Mumbai(Andheri)","color":"Finance","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'operation_status',
'[
{"id":1,"name":"Booking Done","color":"info"},
{"id":2,"name":"File uploaded","color":"info"},
{"id":3,"name":"Subsidy Approved","color":"info"},
{"id":4,"name":"Ready for Finance","color":"info"},
{"id":5,"name":"Forwarded to Finance Team with Financer name","color":"info"},
{"id":6,"name":"Forward to EDP training","color":"info"},
{"id":7,"name":"EDP Training","color":"info"},
{"id":8,"name":"Subsidy Claimed","color":"info"},
{"id":9,"name":"Cancelled","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'finance_status',
'[
{"id":1,"name":"File Received","color":"info"},
{"id":2,"name":"CIBIL check","color":"info"},
{"id":3,"name":"Home verification","color":"info"},
{"id":4,"name":"Loan Sanctioned","color":"info"},
{"id":5,"name":"Loan Disbursed","color":"info"},
{"id":6,"name":"Vehicle Modification","color":"info"},
{"id":7,"name":"Vehicle delivered","color":"info"},
{"id":8,"name":"Vehicle Documentation","color":"info"},
{"id":9,"name":"File Closed","color":"info"},
{"id":10,"name":"Cancelled","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'message',
'[
{"id":1,"subject":"booking","msg":"Dear {customer_name} your booking ref no. {ref_no} is created","operation_status_id":1,"color":"info"},
{"id":2,"subject":"booking","msg":"Dear {customer_name} your document is uploaded for booking ref no. {ref_no}","operation_status_id":2,"color":"info"},
{"id":3,"subject":"booking","msg":"Dear {customer_name} your subsidy is approved booking ref no. {ref_no}","operation_status_id":3,"color":"info"},
{"id":4,"subject":"booking","msg":"Dear {customer_name} you are ready for the finance process for booking ref no. {ref_no}","operation_status_id":4,"color":"info"},
{"id":5,"subject":"booking","msg":"Dear {customer_name} your file id forwarded to financer for finance approval for booking ref no. {ref_no}","operation_status_id":5,"color":"info"},
{"id":6,"subject":"booking","msg":"Dear {customer_name} your file is forward for EDP training for booking ref no. {ref_no}","operation_status_id":6,"color":"info"},
{"id":7,"subject":"booking","msg":"Dear {customer_name} your file is under EDP training for booking ref no. {ref_no}","operation_status_id":7,"color":"info"},
{"id":8,"subject":"booking","msg":"Dear {customer_name} your subsidy is claimed for booking ref no. {ref_no}","operation_status_id":8,"color":"info"},
{"id":9,"subject":"booking","msg":"Dear {customer_name} your subsidy is cancelled for booking ref no. {ref_no}","operation_status_id":9,"color":"info"},
{"id":10,"subject":"booking","msg":"Dear {customer_name} your file is revieved by finance team for booking ref no. {ref_no}","finance_status_id":1,"color":"info"},
{"id":11,"subject":"booking","msg":"Dear {customer_name} your file under CIBIL check for booking ref no. {ref_no}","finance_status_id":2,"color":"info"},
{"id":12,"subject":"booking","msg":"Dear {customer_name} your address is under verification for booking ref no. {ref_no}","finance_status_id":3,"color":"info"},
{"id":13,"subject":"booking","msg":"Dear {customer_name} your loan in sanctioned for booking ref no. {ref_no}","finance_status_id":4,"color":"info"},
{"id":14,"subject":"booking","msg":"Dear {customer_name} you loan is disbursed for booking ref no. {ref_no}","finance_status_id":5,"color":"info"},
{"id":15,"subject":"booking","msg":"Dear {customer_name} your you have opted for vehicle modifications for booking ref no. {ref_no}","finance_status_id":6,"color":"info"},
{"id":16,"subject":"booking","msg":"Dear {customer_name} your vehicle is delivered for booking ref no. {ref_no}","finance_status_id":7,"color":"info"},
{"id":17,"subject":"booking","msg":"Dear {customer_name} your vehicle documents are ready for booking ref no. {ref_no}","finance_status_id":8,"color":"info"},
{"id":18,"subject":"booking","msg":"Dear {customer_name} your susidy process is final for booking ref no. {ref_no}","finance_status_id":9,"color":"info"},
{"id":19,"subject":"booking","msg":"Dear {customer_name} your subsidy process is cancelled for booking ref no. {ref_no}","finance_status_id":10,"color":"info"},
{"id":20,"subject":"assign_customer","msg":"{admin_name} has assigned {customer_name} to {user_name}","color":"info"},
{"id":20,"subject":"new_customer","msg":"Dear {customer_name}, thank you for reaching out to us. We are eager to assist you and provide you with our best service.","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'notification_type',
'[
{"id":1,"name":"System","color":"info"},
{"id":2,"name":"WhatsApp","color":"info"},
{"id":3,"name":"SMS","color":"info"},
{"id":4,"name":"Email","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'notification_for',
'[
{"id":1,"name":"Internal","color":"info"},
{"id":2,"name":"External","color":"info"}
]'
);
insert into
enum_store (`type`, `data`)
VALUES
(
'payment_mode',
'[
{"id":1,"name":"Cash","color":"info"},
{"id":2,"name":"Cheque","color":"info"},
{"id":3,"name":"NEFT","color":"info"},
{"id":4,"name":"UPI","color":"info"},
{"id":5,"name":"Other","color":"info"}
]'
);