Lines 109-115
sub SearchSuggestion {
Link Here
|
109 |
B2.branchname AS branchnamesuggestedby, |
109 |
B2.branchname AS branchnamesuggestedby, |
110 |
U2.email AS emailmanagedby, |
110 |
U2.email AS emailmanagedby, |
111 |
U2.branchcode AS branchcodemanagedby, |
111 |
U2.branchcode AS branchcodemanagedby, |
112 |
U2.borrowernumber AS borrnummanagedby |
112 |
U2.borrowernumber AS borrnummanagedby, |
|
|
113 |
BU.budget_name AS budget_name |
113 |
FROM suggestions |
114 |
FROM suggestions |
114 |
LEFT JOIN borrowers AS U1 ON suggestedby=U1.borrowernumber |
115 |
LEFT JOIN borrowers AS U1 ON suggestedby=U1.borrowernumber |
115 |
LEFT JOIN branches AS B1 ON B1.branchcode=U1.branchcode |
116 |
LEFT JOIN branches AS B1 ON B1.branchcode=U1.branchcode |
Lines 117-122
sub SearchSuggestion {
Link Here
|
117 |
LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber |
118 |
LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber |
118 |
LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode |
119 |
LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode |
119 |
LEFT JOIN categories AS C2 ON C2.categorycode=U2.categorycode |
120 |
LEFT JOIN categories AS C2 ON C2.categorycode=U2.categorycode |
|
|
121 |
LEFT JOIN aqbudgets AS BU ON budgetid=BU.budget_id |
120 |
WHERE 1=1 |
122 |
WHERE 1=1 |
121 |
} |
123 |
} |
122 |
); |
124 |
); |