-
Notifications
You must be signed in to change notification settings - Fork 1
/
loanrulemodeller.sql
47 lines (44 loc) · 1.9 KB
/
loanrulemodeller.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
SELECT DISTINCT
circ_loan_rule.loan_rule_num,
circ_loan_rule.loan_period,
CASE WHEN circ_loan_rule.period_uom = 3600 THEN 'hours'
WHEN circ_loan_rule.period_uom = 86400 THEN 'days'
END AS loan_period_unit,
circ_loan_rule.is_holdable,
circ_loan_rule_name.name AS loan_rule_name,
circ_loan_rule_determiner.display_order AS determiner_order
FROM
public.circ_loan_rule,
public.circ_loan_rule_determiner,
public.circ_loan_rule_determiner_itype_property,
public.circ_loan_rule_determiner_location,
public.circ_loan_rule_determiner_ptype_property,
public.circ_loan_rule_name,
public.location,
public.location_name,
public.itype_property_name,
public.itype_property,
public.ptype,
public.ptype_desc,
public.branch,
public.branch_name
WHERE
branch_name.branch_id = branch.id
AND location.branch_code_num = branch.code_num
AND circ_loan_rule_determiner_location.location_id = location.id
AND circ_loan_rule_determiner_location.circ_loan_rule_determiner_id = circ_loan_rule_determiner.id
AND ptype_desc.ptype_id = ptype.id
AND itype_property_name.itype_property_id = itype_property.id
AND circ_loan_rule_determiner.loan_rule_id = circ_loan_rule.id
AND itype_property.id = circ_loan_rule_determiner_itype_property.itype_property_id
AND circ_loan_rule_determiner_itype_property.circ_loan_rule_determiner_id = circ_loan_rule_determiner.id
AND ptype.id = circ_loan_rule_determiner_ptype_property.ptype_property_id
AND circ_loan_rule_determiner_ptype_property.circ_loan_rule_determiner_id = circ_loan_rule_determiner.id
AND circ_loan_rule_name.loan_rule_id = circ_loan_rule.id
AND circ_loan_rule_determiner_location.location_id = location.id
AND circ_loan_rule_determiner_itype_property.itype_property_id = itype_property.id
AND ptype.value = '0'
AND itype_property.code_num = '0'
AND location.code ='bakr'
ORDER BY determiner_order DESC NULLS LAST
LIMIT 1;