fineract-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nazeer1100...@apache.org
Subject [1/2] fineract git commit: Resolving compilation issues with Email Campaigns Feature and resolving 322.2 migration script issue
Date Tue, 21 Nov 2017 13:21:53 GMT
Repository: fineract
Updated Branches:
  refs/heads/develop 2614ffdb2 -> 4dbecc7f0


http://git-wip-us.apache.org/repos/asf/fineract/blob/4dbecc7f/fineract-provider/src/main/resources/sql/migrations/core_db/V322_2__email_business_rules.sql
----------------------------------------------------------------------
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V322_2__email_business_rules.sql
b/fineract-provider/src/main/resources/sql/migrations/core_db/V322_2__email_business_rules.sql
index 990f18d..c17cb51 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V322_2__email_business_rules.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V322_2__email_business_rules.sql
@@ -34,78 +34,77 @@ INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`,
`
 INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_sql`,
`description`, `core_report`, `use_report`) VALUES ('Loan Approved - Email', 'Email', 'Triggered',
'SELECT mc.id, mc.firstname, mc.middlename as middlename, mc.lastname, mc.display_name as
FullName, mc.email_address as EmailAddress, mc.group_name as GroupName,\n mo.name as officename,
ifnull(od.phoneNumber,\'\') as officenummber, ml.id as loanId, ml.account_no as accountnumber,
ml.principal_amount_proposed as loanamount, ml.annual_nominal_interest_rate as annualinterestrate\n
FROM\n m_office mo\n JOIN m_office ounder ON ounder.hierarchy LIKE CONCAT(mo.hierarchy, \'%\')\n
AND ounder.hierarchy like CONCAT(\'.\', \'%\')\n LEFT JOIN (\n select \n ml.id as loanId,
\n ifnull(mc.id,mc2.id) as id, \n ifnull(mc.firstname,mc2.firstname) as firstname, \n ifnull(mc.middlename,ifnull(mc2.middlename,(\'\')))
as middlename, \n ifnull(mc.lastname,mc2.lastname) as lastname, \n ifnull(mc.display_name,mc2.disp
 lay_name) as display_name, \n ifnull(mc.status_enum,mc2.status_enum) as status_enum,\n ifnull(mc.email_address,mc2.email_address)
as email_address,\n ifnull(mg.office_id,mc2.office_id) as office_id,\n ifnull(mg.staff_id,mc2.staff_id)
as staff_id,\n mg.id as group_id, \nmg.display_name as group_name\n from\n m_loan ml\n left
join m_group mg on mg.id = ml.group_id\n left join m_group_client mgc on mgc.group_id = mg.id\n
left join m_client mc on mc.id = mgc.client_id\n left join m_client mc2 on mc2.id = ml.client_id\n
order by loanId\n ) mc on mc.office_id = ounder.id\n left join ml_office_details as od on
od.office_id = mo.id\n left join m_loan ml on ml.id = mc.loanId\n WHERE mc.status_enum = 300
and mc.email_address is not null\n and (mo.id = ${officeId} or ${officeId} = -1)\n and (mc.staff_id
= ${staffId} or ${staffId} = -1)\nand (ml.id = ${loanId} or ${loanId} = -1)\nand (mc.id =
${clientId} or ${clientId} = -1)\nand (mc.group_id = ${groupId} or ${groupId} = -1)\nand (ml.loan_type_
 enum = ${loanType} or ${loanType} = -1)', 'Loan and client data of approved loan', '0', '0');
 INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_sql`,
`description`, `core_report`, `use_report`) VALUES ('Loan Repayment - Email', 'Email', 'Triggered',
'select ml.id as loanId,mc.id, mc.firstname, ifnull(mc.middlename,\'\') as middlename, mc.lastname,
mc.display_name as FullName, email_address as EmailAddress, mc.group_name as GroupName, round(ml.principal_amount,
ml.currency_digits) as LoanAmount, round(ml.`total_outstanding_derived`, ml.currency_digits)
as LoanOutstanding,\nifnull(od.phoneNumber,\'\') as officenummber,ml.`account_no` as LoanAccountId,
round(mlt.amountPaid, ml.currency_digits) as repaymentAmount\nFROM m_office mo\nJOIN m_office
ounder ON ounder.hierarchy LIKE CONCAT(mo.hierarchy, \'%\')\nAND ounder.hierarchy like CONCAT(\'.\',
\'%\')\nLEFT JOIN (\n select \n ml.id as loanId, \n ifnull(mc.id,mc2.id) as id, \n ifnull(mc.firstname,mc2.firstname)
as firstname, \n ifnull(mc.middlename,ifnull(mc2.middlename,(\'\'))) as middlename,
  \n ifnull(mc.lastname,mc2.lastname) as lastname, \n ifnull(mc.display_name,mc2.display_name)
as display_name, \n ifnull(mc.status_enum,mc2.status_enum) as status_enum,\n ifnull(mc.email_address,mc2.email_address)
as email_address,\n ifnull(mg.office_id,mc2.office_id) as office_id,\n ifnull(mg.staff_id,mc2.staff_id)
as staff_id,\n mg.id as group_id, \nmg.display_name as group_name\n from\n m_loan ml\n left
join m_group mg on mg.id = ml.group_id\n left join m_group_client mgc on mgc.group_id = mg.id\n
left join m_client mc on mc.id = mgc.client_id\n left join m_client mc2 on mc2.id = ml.client_id\n
order by loanId\n ) mc on mc.office_id = ounder.id\nleft join ml_office_details as od on od.office_id
= mo.id\nright join m_loan as ml on mc.loanId = ml.id\nright join(\nselect mlt.amount as amountPaid,mlt.id,mlt.loan_id\nfrom
m_loan_transaction mlt\nwhere mlt.is_reversed = 0 \ngroup by mlt.loan_id\n) as mlt on mlt.loan_id
= ml.id\nright join m_loan_repayment_schedule as mls1 on ml.id = ml
 s1.loan_id and mls1.`completed_derived` = 0\nand mls1.installment = (SELECT MIN(installment)
from m_loan_repayment_schedule where loan_id = ml.id and duedate <= CURDATE() and completed_derived=0)\nwhere
mc.status_enum = 300 and email_address is not null and ml.`loan_status_id` = 300\nand (mo.id
= ${officeId} or ${officeId} = -1)\nand (mc.staff_id = ${staffId} or ${staffId} = -1)\nand
(ml.loan_type_enum = ${loanType} or ${loanType} = -1)\nand ml.id in (select mla.loan_id from
m_loan_arrears_aging mla)\ngroup by ml.id', 'Loan Repayment', '0', '0');
 
+
 INSERT INTO `stretchy_report_parameter` (`report_id`, `parameter_id`, `report_parameter_name`)
 VALUES
 ( (SELECT id from stretchy_report where report_name = 'Active Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Active Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Active Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Prospective Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Prospective Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Prospective Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'cycleX'), 'Cycle X'),
-( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'cycleY'), 'Cycle Y'),
+( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'cycleXSelect'), 'Cycle X'),
+( (SELECT id from stretchy_report where report_name = 'Active Loan Clients - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'cycleYSelect'), 'Cycle Y'),
 ( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loans in arrears - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
 ( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
-( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'cycleX'), 'Cycle X'),
-( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'cycleY'), 'Cycle Y'),
+( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'cycleXSelect'), 'Cycle X'),
+( (SELECT id from stretchy_report where report_name = 'Loans disbursed to clients - Email'),
(SELECT id from stretchy_parameter where parameter_name = 'cycleYSelect'), 'Cycle Y'),
 ( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loan payments due - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
 ( (SELECT id from stretchy_report where report_name = 'Dormant Prospects - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Dormant Prospects - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Dormant Prospects - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Active Group Leaders - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Active Group Leaders - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Active Group Leaders - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'),
'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'),
'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueX'), 'overdueX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueY'), 'overdueY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'),
'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueXSelect'), 'overdueX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Due (Overdue Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueYSelect'), 'overdueY'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'),
'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'),
'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'),
'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Active Loans)
- Email'), (SELECT id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'),
'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'),
'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueX'), 'overdueX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueY'), 'overdueY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'),
'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueXSelect'), 'overdueX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Payments Received (Overdue Loans)
 - Email'), (SELECT id from stretchy_parameter where parameter_name = 'overdueYSelect'), 'overdueY'),
 ( (SELECT id from stretchy_report where report_name = 'Happy Birthday - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Happy Birthday - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Happy Birthday - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
-( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'fromXSelect'), 'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loan Fully Repaid - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
 ( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'),
'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'toY'), 'toY'),
-( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromX'), 'fromX'),
-( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'),
'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'toYSelect'), 'toY'),
+( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'fromXSelect'),
'fromX'),
+( (SELECT id from stretchy_report where report_name = 'Loans Outstanding after final instalment
date - Email'), (SELECT id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'),
'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultLoan'), 'loanId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultClient'), 'clientId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultGroup'), 'groupId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Rejected - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'SelectLoanType'), 'loanType'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultLoan'), 'loanId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultClient'), 'clientId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'DefaultGroup'), 'groupId'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Approved - Email'), (SELECT id
from stretchy_parameter where parameter_name = 'SelectLoanType'), 'loanType'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Repayment - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'OfficeIdSelectOne'), 'Office'),
-( (SELECT id from stretchy_report where report_name = 'Loan Repayment - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'LoanOfficerSelectOneRec'), 'Loanofficer'),
+( (SELECT id from stretchy_report where report_name = 'Loan Repayment - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'loanOfficerIdSelectAll'), 'Loanofficer'),
 ( (SELECT id from stretchy_report where report_name = 'Loan Repayment - Email'), (SELECT
id from stretchy_parameter where parameter_name = 'SelectLoanType'), 'loanType');
 
-
-
 INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`)
 VALUES
 ('report', 'READ_Active Clients - Email', 'Active Clients - Email', 'READ', 0),


Mime
View raw message