create procedure get_request_no
modify procedure get_lab, get_lab_list

add new column request_id to lab_requisitions
ALTER TABLE `lab_requisition` ADD `request_id` VARCHAR(50) NULL AFTER `booking_no`;

modify view, lab_info, lab_request2, lab_process add column request_id

-- 29-06-21
create procedure get_doc_report_fees;

	-- modified:   controller/pharmacy.js
 --        modified:   controller/transactions.js
 --        modified:   models/25-06-2021.sql
 --        modified:   routes/transactions.js

 -- modify procedure customer_deposit, service_transaction, get_request_no 
 -- create procedure update_txn_status
 
 -- modify account_entries add patient_id
 ALTER TABLE `account_entries`  ADD `client_id` VARCHAR(50) NOT NULL  AFTER `createdAt`,  ADD `txn_status` VARCHAR(10) NOT NULL  AFTER `client_id`;
 
 -- modify lab_requisitions table add payment_status
 ALTER TABLE `lab_requisition` ADD `payment_status` VARCHAR(20) NOT NULL AFTER `receiptNo`;

 -- modify transactions table add settlment_status
 ALTER TABLE `transactions` ADD `settlement_status` VARCHAR(50) NOT NULL AFTER `patient_id`;

 update procedure get_doc_report_fees, get_patient_txn

 -- modified files
 --        modified:   config/config.json
 --        modified:   controller/lab.js
 --        modified:   controller/lab2.js
 --        modified:   controller/pharmacy.js
 --        modified:   controller/record.js
 --        modified:   controller/transactions.js
 --        modified:   models/25-06-2021.sql


 -- others
 -- modified:   controller/drugs.js
 --        modified:   controller/lab.js
 --        modified:   controller/lab2.js
 --        modified:   controller/pharmacy.js
 --        modified:   controller/record.js
 --        modified:   controller/transactions.js
 --        modified:   routes/lab.js