TYPE=VIEW
query=select `co-operativebank-mohati`.`headvoucher`.`shcode` AS `SHCODE`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,if(((`co-operativebank-mohati`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-mohati`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-mohati`.`headvoucher`.`htcode` = \'27000\') or (`co-operativebank-mohati`.`headvoucher`.`main_head` = \'60000\')),(sum(`co-operativebank-mohati`.`headvoucher`.`dr`) - sum(`co-operativebank-mohati`.`headvoucher`.`cr`)),(sum(`co-operativebank-mohati`.`headvoucher`.`cr`) - sum(`co-operativebank-mohati`.`headvoucher`.`dr`))) AS `BAL`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` < \'2020-10-17\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17103\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17109\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17110\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17111\')) group by `co-operativebank-mohati`.`headvoucher`.`shcode` union all select \'17103\' AS `SHCODE`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-mohati`.`headvoucher`.`cr`) - sum(`co-operativebank-mohati`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` < \'2020-10-17\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17103\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17109\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17110\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17111\'))) 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-mohati`.`approciation`.`sub_head` AS `SHCODE`,`co-operativebank-mohati`.`approciation`.`main_head` AS `htcode`,sum(`co-operativebank-mohati`.`approciation`.`amt`) AS `BAL`,`co-operativebank-mohati`.`approciation`.`head` AS `hcode` from `co-operativebank-mohati`.`approciation` where ((`co-operativebank-mohati`.`approciation`.`date` < \'2020-10-17\') and (`co-operativebank-mohati`.`approciation`.`amt` > 0)) group by `co-operativebank-mohati`.`approciation`.`sub_head`
md5=1d5375e65f2d469efad558355e9c85d2
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2021-10-09 06:28:28
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<\'2020-10-17\' and ((`headvoucher`.`shcode` <> \'17103\') and (`headvoucher`.`shcode` <> \'17109\') and (`headvoucher`.`shcode` <> \'17110\') and (`headvoucher`.`shcode` <> \'17111\')) group by shcode union all select \'17103\' AS `SHCODE`,htcode,(sum(`headvoucher`.`cr`) - sum(`headvoucher`.`dr`)) AS `BAL`,hcode from `headvoucher` where ((`headvoucher`.`date` < \'2020-10-17\') and ((`headvoucher`.`shcode` = \'17103\') or (`headvoucher`.`shcode` = \'17109\') or (`headvoucher`.`shcode` = \'17110\') or (`headvoucher`.`shcode` = \'17111\'))) 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<\'2020-10-17\' and amt>0 group by sub_head
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mohati`.`headvoucher`.`shcode` AS `SHCODE`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,if(((`co-operativebank-mohati`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-mohati`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-mohati`.`headvoucher`.`htcode` = \'27000\') or (`co-operativebank-mohati`.`headvoucher`.`main_head` = \'60000\')),(sum(`co-operativebank-mohati`.`headvoucher`.`dr`) - sum(`co-operativebank-mohati`.`headvoucher`.`cr`)),(sum(`co-operativebank-mohati`.`headvoucher`.`cr`) - sum(`co-operativebank-mohati`.`headvoucher`.`dr`))) AS `BAL`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` < \'2020-10-17\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17103\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17109\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17110\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` <> \'17111\')) group by `co-operativebank-mohati`.`headvoucher`.`shcode` union all select \'17103\' AS `SHCODE`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,(sum(`co-operativebank-mohati`.`headvoucher`.`cr`) - sum(`co-operativebank-mohati`.`headvoucher`.`dr`)) AS `BAL`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `hcode` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` < \'2020-10-17\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17103\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17109\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17110\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'17111\'))) 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-mohati`.`approciation`.`sub_head` AS `SHCODE`,`co-operativebank-mohati`.`approciation`.`main_head` AS `htcode`,sum(`co-operativebank-mohati`.`approciation`.`amt`) AS `BAL`,`co-operativebank-mohati`.`approciation`.`head` AS `hcode` from `co-operativebank-mohati`.`approciation` where ((`co-operativebank-mohati`.`approciation`.`date` < \'2020-10-17\') and (`co-operativebank-mohati`.`approciation`.`amt` > 0)) group by `co-operativebank-mohati`.`approciation`.`sub_head`
