TYPE=VIEW
query=select `dep_return`.`shcode` AS `shcode`,`dep_return`.`sub_head` AS `sub_head`,round((`dep_return`.`Opening` / 100000),2) AS `opening`,round((if(isnull(`dep_return`.`received`),0,`dep_return`.`received`) / 100000),2) AS `received`,round(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) / 100000),2) AS `Total_amt`,round((if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`) / 100000),2) AS `refund`,round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) AS `Balance`,round(((round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) / (select round((sum(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`))) / 100000),2) from `co-operativebank-210`.`dep_return`)) * 100),2) AS `Of_Depo`,`dep_return`.`total_no_acc` AS `new_acc` from `co-operativebank-210`.`dep_return` where ((`dep_return`.`shcode` = \'14103\') or (`dep_return`.`shcode` = \'14104\') or (`dep_return`.`shcode` = \'14303\') or (`dep_return`.`shcode` = \'14309\') or (`dep_return`.`shcode` = \'14304\') or (`dep_return`.`shcode` = \'14102\') or (`dep_return`.`shcode` = \'14302\') or (`dep_return`.`shcode` = \'14107\') or (`dep_return`.`shcode` = \'14307\'))
md5=5794591b6f1d85835af8060f91e678d0
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-07-04 09:53:25
create-version=1
source=SELECT shcode,sub_head,round((opening/100000),2) opening,round((IF(ISNULL(received),0,received)/100000),2) as received,round(((opening)+(IF(ISNULL(received),0,received)))/100000,2) as Total_amt,round((IF(ISNULL(refund),0,refund)/100000),2) as refund,round(((opening)+(IF(ISNULL(received),0,received))-IF(ISNULL(refund),0,refund))/100000,2) as Balance, round((round(((opening)+(IF(ISNULL(received),0,received))-IF(ISNULL(refund),0,refund))/100000,2)/(select round((sum((opening)+(IF(ISNULL(received),0,received))-(IF(ISNULL(refund),0,refund))))/100000,2) FROM dep_return)*100),2) as Of_Depo,total_no_acc as new_acc FROM `dep_return` where shcode=\'14103\' or shcode=\'14104\' or shcode=\'14303\' or shcode=\'14309\' or shcode=\'14304\' or shcode=\'14102\' or shcode=\'14302\' or shcode=\'14107\' or shcode=\'14307\'
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `dep_return`.`shcode` AS `shcode`,`dep_return`.`sub_head` AS `sub_head`,round((`dep_return`.`Opening` / 100000),2) AS `opening`,round((if(isnull(`dep_return`.`received`),0,`dep_return`.`received`) / 100000),2) AS `received`,round(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) / 100000),2) AS `Total_amt`,round((if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`) / 100000),2) AS `refund`,round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) AS `Balance`,round(((round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) / (select round((sum(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`))) / 100000),2) from `co-operativebank-210`.`dep_return`)) * 100),2) AS `Of_Depo`,`dep_return`.`total_no_acc` AS `new_acc` from `co-operativebank-210`.`dep_return` where ((`dep_return`.`shcode` = \'14103\') or (`dep_return`.`shcode` = \'14104\') or (`dep_return`.`shcode` = \'14303\') or (`dep_return`.`shcode` = \'14309\') or (`dep_return`.`shcode` = \'14304\') or (`dep_return`.`shcode` = \'14102\') or (`dep_return`.`shcode` = \'14302\') or (`dep_return`.`shcode` = \'14107\') or (`dep_return`.`shcode` = \'14307\'))
