TYPE=VIEW
query=select `co-operativebank`.`loan_disbasment_list`.`no` AS `no`,`co-operativebank`.`loan_disbasment_list`.`name` AS `name`,`co-operativebank`.`loan_disbasment_list`.`father_name` AS `father_name`,group_concat(`co-operativebank`.`loan_disbasment_list`.`rabi_acc` separator \'\') AS `rabi_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) AS `ramt`,group_concat(`co-operativebank`.`loan_disbasment_list`.`kharif_acc` separator \'\') AS `kharif_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) AS `kamt`,group_concat(`co-operativebank`.`loan_disbasment_list`.`share_acc` separator \'\') AS `share_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`) AS `share_amt`,round(if((((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)) > 0),((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)),0),2) AS `share_paid`,if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),\'30.00\',0) AS `gap`,if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),\'10.00\',0) AS `from_chg`,round((((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) - if((((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)) > 0),((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)),0)) - if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),30,0)) - if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),10,0)),2) AS `payloan_amt`,`co-operativebank`.`loan_disbasment_list`.`dt` AS `dt`,`co-operativebank`.`loan_disbasment_list`.`sv_acc` AS `sv_acc` from `co-operativebank`.`loan_disbasment_list` where ((`co-operativebank`.`loan_disbasment_list`.`ramt` > 0) or (`co-operativebank`.`loan_disbasment_list`.`kamt` > 0) or (`co-operativebank`.`loan_disbasment_list`.`share_acc` <> \'\')) group by `co-operativebank`.`loan_disbasment_list`.`sv_acc`
md5=135afff43043b96d5a17a3a6b1386457
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2021-02-11 11:42:35
create-version=1
source=SELECT `no`, `name`, `father_name`, GROUP_CONCAT(rabi_acc SEPARATOR \'\') as rabi_acc , sum(`ramt`) as ramt, GROUP_CONCAT(kharif_acc SEPARATOR \'\') as kharif_acc,sum(`kamt`) as kamt, GROUP_CONCAT(share_acc SEPARATOR \'\') as share_acc , sum(`share_amt`) as share_amt, round(if((((sum(ramt)+sum(kamt))*5/100)-sum(share_amt))>0,(((sum(ramt)+sum(kamt))*5/100)-sum(share_amt)),0),2) as `share_paid`, IF(SUM(kamt)>0,\'30.00\',0) as `gap`, IF(SUM(kamt)>0,\'10.00\',0) as `from_chg`, round(((sum(kamt) - (if((((sum(ramt)+sum(kamt))*5/100)-sum(share_amt))>0,(((sum(ramt)+sum(kamt))*5/100)-sum(share_amt)),0)))- IF(SUM(kamt)>0,30,0) - IF(SUM(kamt)>0,10,0)),2) as `payloan_amt`, `dt`, `sv_acc` FROM `loan_disbasment_list` where  (ramt>0 or kamt>0 OR `share_acc` <>\'\')  group by sv_acc
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`loan_disbasment_list`.`no` AS `no`,`co-operativebank`.`loan_disbasment_list`.`name` AS `name`,`co-operativebank`.`loan_disbasment_list`.`father_name` AS `father_name`,group_concat(`co-operativebank`.`loan_disbasment_list`.`rabi_acc` separator \'\') AS `rabi_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) AS `ramt`,group_concat(`co-operativebank`.`loan_disbasment_list`.`kharif_acc` separator \'\') AS `kharif_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) AS `kamt`,group_concat(`co-operativebank`.`loan_disbasment_list`.`share_acc` separator \'\') AS `share_acc`,sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`) AS `share_amt`,round(if((((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)) > 0),((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)),0),2) AS `share_paid`,if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),\'30.00\',0) AS `gap`,if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),\'10.00\',0) AS `from_chg`,round((((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) - if((((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)) > 0),((((sum(`co-operativebank`.`loan_disbasment_list`.`ramt`) + sum(`co-operativebank`.`loan_disbasment_list`.`kamt`)) * 5) / 100) - sum(`co-operativebank`.`loan_disbasment_list`.`share_amt`)),0)) - if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),30,0)) - if((sum(`co-operativebank`.`loan_disbasment_list`.`kamt`) > 0),10,0)),2) AS `payloan_amt`,`co-operativebank`.`loan_disbasment_list`.`dt` AS `dt`,`co-operativebank`.`loan_disbasment_list`.`sv_acc` AS `sv_acc` from `co-operativebank`.`loan_disbasment_list` where ((`co-operativebank`.`loan_disbasment_list`.`ramt` > 0) or (`co-operativebank`.`loan_disbasment_list`.`kamt` > 0) or (`co-operativebank`.`loan_disbasment_list`.`share_acc` <> \'\')) group by `co-operativebank`.`loan_disbasment_list`.`sv_acc`
