TYPE=VIEW
query=select `co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,if(((`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'27000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`main_head` = \'60000\')),(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`)),(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`))) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17103\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17109\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17110\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17111\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17153\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17154\')) group by `co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` union all select \'17103\' AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and ((`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17103\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17109\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17110\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17111\'))) union all select \'17154\' AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and ((`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17153\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17154\'))) union all select \'17153\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17154\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17109\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17110\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17111\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select `co-operativebank-dkmadhabpur`.`approciation`.`sub_head` AS `SHCODE`,`co-operativebank-dkmadhabpur`.`approciation`.`main_head` AS `htcode`,sum(`co-operativebank-dkmadhabpur`.`approciation`.`amt`) AS `BAL`,`co-operativebank-dkmadhabpur`.`approciation`.`head` AS `hcode` from `co-operativebank-dkmadhabpur`.`approciation` where ((`co-operativebank-dkmadhabpur`.`approciation`.`date` < \'2022-05-24\') and (`co-operativebank-dkmadhabpur`.`approciation`.`amt` > 0)) group by `co-operativebank-dkmadhabpur`.`approciation`.`sub_head`
md5=224263339fd425d35573a3f64c10ad0f
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2022-08-25 05:24:48
create-version=1
source=SELECT SHCODE,htcode,if(htcode=\'21000\' or htcode=\'23000\' or  htcode=\'27000\' or  `main_head`=\'60000\',(sum(`dr`) - sum(`cr`)),(sum(`cr`) - sum(`dr`))) as  BAL,hcode FROM headvoucher where date<\'2022-05-24\' and ((`headvoucher`.`shcode` <> \'17103\') and (`headvoucher`.`shcode` <> \'17109\') and (`headvoucher`.`shcode` <> \'17110\') and (`headvoucher`.`shcode` <> \'17111\') and (`headvoucher`.`shcode` <> \'17153\') and (`headvoucher`.`shcode` <> \'17154\')) group by shcode union all select \'17103\' AS `SHCODE`,htcode,(sum(`headvoucher`.`cr`) - sum(`headvoucher`.`dr`)) AS `BAL`,hcode from `headvoucher` where ((`headvoucher`.`date` < \'2022-05-24\') and ((`headvoucher`.`shcode` = \'17103\') or (`headvoucher`.`shcode` = \'17109\') or (`headvoucher`.`shcode` = \'17110\') or (`headvoucher`.`shcode` = \'17111\')))union all select \'17154\' AS `SHCODE`,htcode,(sum(`headvoucher`.`cr`) - sum(`headvoucher`.`dr`)) AS `BAL`,hcode from `headvoucher` where ((`headvoucher`.`date` < \'2022-05-24\') and ((`headvoucher`.`shcode` = \'17153\') or (`headvoucher`.`shcode` = \'17154\'))) union all select \'17153\' AS `SHCODE`,\'17000\' AS htcode,0 AS `BAL`,\'17100\' as hcode union all select \'17154\' AS `SHCODE`,\'17000\' AS htcode,0 AS `BAL`,\'17100\' as hcode union all select \'17109\' AS `SHCODE`,\'17000\' AS htcode,0 AS `BAL`,\'17100\' as hcode union all select \'17110\' AS `SHCODE`,\'17000\' AS htcode,0 AS `BAL`,\'17100\' as hcode union all select \'17111\' AS `SHCODE`,\'17000\' AS  htcode,0 AS `BAL`,\'17100\' as hcode union all select sub_head AS `SHCODE`,main_head AS htcode,sum(amt) AS `BAL`,head as hcode from approciation where date<\'2022-05-24\' and amt>0 group by sub_head
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,if(((`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` = \'27000\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`main_head` = \'60000\')),(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`)),(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`))) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17103\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17109\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17110\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17111\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17153\') and (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` <> \'17154\')) group by `co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` union all select \'17103\' AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and ((`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17103\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17109\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17110\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17111\'))) union all select \'17154\' AS `SHCODE`,`co-operativebank-dkmadhabpur`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`cr`) - sum(`co-operativebank-dkmadhabpur`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-dkmadhabpur`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-dkmadhabpur`.`headvoucher` where ((`co-operativebank-dkmadhabpur`.`headvoucher`.`date` < \'2022-05-24\') and ((`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17153\') or (`co-operativebank-dkmadhabpur`.`headvoucher`.`shcode` = \'17154\'))) union all select \'17153\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17154\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17109\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17110\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select \'17111\' AS `SHCODE`,\'17000\' AS `htcode`,0 AS `BAL`,\'17100\' AS `hcode` union all select `co-operativebank-dkmadhabpur`.`approciation`.`sub_head` AS `SHCODE`,`co-operativebank-dkmadhabpur`.`approciation`.`main_head` AS `htcode`,sum(`co-operativebank-dkmadhabpur`.`approciation`.`amt`) AS `BAL`,`co-operativebank-dkmadhabpur`.`approciation`.`head` AS `hcode` from `co-operativebank-dkmadhabpur`.`approciation` where ((`co-operativebank-dkmadhabpur`.`approciation`.`date` < \'2022-05-24\') and (`co-operativebank-dkmadhabpur`.`approciation`.`amt` > 0)) group by `co-operativebank-dkmadhabpur`.`approciation`.`sub_head`
