TYPE=VIEW
query=select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`htcode` <> \'15000\') and (`co-club`.`headvoucher`.`htcode` <> \'16000\') and (`co-club`.`headvoucher`.`htcode` <> \'38000\') and (`co-club`.`headvoucher`.`htcode` <> \'24000\') and (`co-club`.`headvoucher`.`htcode` <> \'25000\') and (`co-club`.`headvoucher`.`htcode` <> \'22000\') and (`co-club`.`headvoucher`.`htcode` <> \'28000\') and (`co-club`.`headvoucher`.`htcode` <> \'62000\') and (`co-club`.`headvoucher`.`htcode` <> \'19000\') and (`co-club`.`headvoucher`.`htcode` <> \'65000\') and (`co-club`.`headvoucher`.`htcode` <> \'61000\') and (`co-club`.`headvoucher`.`htcode` <> \'63000\') and (`co-club`.`headvoucher`.`htcode` <> \'64000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`main_head` <> \'50000\') and (`co-club`.`headvoucher`.`shcode` <> \'17103\') and (`co-club`.`headvoucher`.`shcode` <> \'17109\') and (`co-club`.`headvoucher`.`shcode` <> \'17110\') and (`co-club`.`headvoucher`.`shcode` <> \'17111\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-club`.`headvoucher`.`cr` <> 0)) group by `co-club`.`headvoucher`.`htcode` union all select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where (((`co-club`.`headvoucher`.`htcode` = \'28000\') or (`co-club`.`headvoucher`.`htcode` = \'22000\')) and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-club`.`headvoucher`.`dr` > 0)) group by `co-club`.`headvoucher`.`htcode` union all select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,(sum(`co-club`.`headvoucher`.`cr`) - sum(`co-club`.`headvoucher`.`dr`)) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`main_head` = \'50000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`hcode` <> \'51100\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode` union all select \'8\' AS `sl_no`,\'44444\' AS `code`,concat(\'DIVIDENT ON SHARE RECEIVED\') AS `head`,(sum(`co-club`.`headvoucher`.`cr`) - sum(`co-club`.`headvoucher`.`dr`)) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`main_head` = \'50000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`hcode` = \'51100\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode` union all select \'5\' AS `sl_no`,\'17100\' AS `code`,concat(\'PROVIDENT FUND COLLECTION\') AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and ((`co-club`.`headvoucher`.`shcode` = \'17103\') or (`co-club`.`headvoucher`.`shcode` = \'17109\') or (`co-club`.`headvoucher`.`shcode` = \'17110\') or (`co-club`.`headvoucher`.`shcode` = \'17111\')) and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode`
md5=1d1aac9c694dd428b03cc5a4feae255a
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-10-11 09:23:48
create-version=1
source=select csl_no AS sl_no,htcode AS code,concat(head_type) AS head,sum(cr) AS dr,sum(dr) AS cr,htcode AS head_n,htcode from ((headvoucher)) where ( (htcode <> \'15000\') and (htcode <> \'16000\') and (htcode <> \'38000\') and (htcode <> \'24000\') and (htcode <> \'25000\' AND htcode <> \'22000\' AND htcode <> \'28000\') and (htcode <> \'62000\') and (htcode <> \'19000\') and (htcode <> \'65000\') and (htcode <> \'61000\') and (htcode <> \'63000\') and (htcode <> \'64000\') and (date >= \'2025-08-01\') and (date <= \'2025-09-30\') and (main_head <> \'50000\')  and ((shcode <> \'17103\') and (shcode <> \'17109\') and (shcode <> \'17110\') and (shcode <> \'17111\'))) and deposit_type <>  \'ATJUST\' AND CR<>0 group by htcode UNION ALL select `csl_no` AS `sl_no`,htcode AS `code`,concat(`head_type`) AS `head`,sum(`cr`) AS `dr`,sum(`dr`) AS `cr`,htcode AS `head_n`,`htcode` from (headvoucher) where (  (`htcode` = \'28000\' OR `htcode` = \'22000\') and (`date` >= \'2025-08-01\') and (`date` <= \'2025-09-30\') and (`deposit_type` <> \'ATJUST\')) AND DR>0 group by `htcode` union all select csl_no AS sl_no,htcode AS code,concat(head_type) AS head,(sum(cr) - sum(dr)) AS dr,sum(dr) AS cr,htcode AS head_n, htcode from (headvoucher) where ( (main_head = \'50000\') and (date >= \'2025-08-01\') and (date <= \'2025-09-30\')) AND hcode<>\'51100\' and deposit_type <>  \'ATJUST\' group by htcode union all select \'8\' AS sl_no,\'44444\' AS code,concat(\'DIVIDENT ON SHARE RECEIVED\') AS head,(sum(cr) - sum(dr)) AS dr,sum(dr) AS cr,htcode AS head_n, htcode from (headvoucher) where ( (main_head = \'50000\') and (date >= \'2025-08-01\') and (date <= \'2025-09-30\')) AND hcode=\'51100\' and deposit_type <>  \'ATJUST\' group by htcode union all select \'5\' AS sl_no,\'17100\' AS code,concat(\'PROVIDENT FUND COLLECTION\') AS head,sum(cr) AS dr,sum(dr) AS cr,htcode AS head_n, htcode from (headvoucher) where ((date >= \'2025-08-01\') and (date <= \'2025-09-30\')  and ((shcode =\'17103\') OR (shcode = \'17109\') OR (shcode = \'17110\') OR (shcode = \'17111\'))) and deposit_type <>  \'ATJUST\' group by htcode
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`htcode` <> \'15000\') and (`co-club`.`headvoucher`.`htcode` <> \'16000\') and (`co-club`.`headvoucher`.`htcode` <> \'38000\') and (`co-club`.`headvoucher`.`htcode` <> \'24000\') and (`co-club`.`headvoucher`.`htcode` <> \'25000\') and (`co-club`.`headvoucher`.`htcode` <> \'22000\') and (`co-club`.`headvoucher`.`htcode` <> \'28000\') and (`co-club`.`headvoucher`.`htcode` <> \'62000\') and (`co-club`.`headvoucher`.`htcode` <> \'19000\') and (`co-club`.`headvoucher`.`htcode` <> \'65000\') and (`co-club`.`headvoucher`.`htcode` <> \'61000\') and (`co-club`.`headvoucher`.`htcode` <> \'63000\') and (`co-club`.`headvoucher`.`htcode` <> \'64000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`main_head` <> \'50000\') and (`co-club`.`headvoucher`.`shcode` <> \'17103\') and (`co-club`.`headvoucher`.`shcode` <> \'17109\') and (`co-club`.`headvoucher`.`shcode` <> \'17110\') and (`co-club`.`headvoucher`.`shcode` <> \'17111\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-club`.`headvoucher`.`cr` <> 0)) group by `co-club`.`headvoucher`.`htcode` union all select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where (((`co-club`.`headvoucher`.`htcode` = \'28000\') or (`co-club`.`headvoucher`.`htcode` = \'22000\')) and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-club`.`headvoucher`.`dr` > 0)) group by `co-club`.`headvoucher`.`htcode` union all select `co-club`.`headvoucher`.`csl_no` AS `sl_no`,`co-club`.`headvoucher`.`htcode` AS `code`,concat(`co-club`.`headvoucher`.`head_type`) AS `head`,(sum(`co-club`.`headvoucher`.`cr`) - sum(`co-club`.`headvoucher`.`dr`)) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`main_head` = \'50000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`hcode` <> \'51100\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode` union all select \'8\' AS `sl_no`,\'44444\' AS `code`,concat(\'DIVIDENT ON SHARE RECEIVED\') AS `head`,(sum(`co-club`.`headvoucher`.`cr`) - sum(`co-club`.`headvoucher`.`dr`)) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`main_head` = \'50000\') and (`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and (`co-club`.`headvoucher`.`hcode` = \'51100\') and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode` union all select \'5\' AS `sl_no`,\'17100\' AS `code`,concat(\'PROVIDENT FUND COLLECTION\') AS `head`,sum(`co-club`.`headvoucher`.`cr`) AS `dr`,sum(`co-club`.`headvoucher`.`dr`) AS `cr`,`co-club`.`headvoucher`.`htcode` AS `head_n`,`co-club`.`headvoucher`.`htcode` AS `htcode` from `co-club`.`headvoucher` where ((`co-club`.`headvoucher`.`date` >= \'2025-08-01\') and (`co-club`.`headvoucher`.`date` <= \'2025-09-30\') and ((`co-club`.`headvoucher`.`shcode` = \'17103\') or (`co-club`.`headvoucher`.`shcode` = \'17109\') or (`co-club`.`headvoucher`.`shcode` = \'17110\') or (`co-club`.`headvoucher`.`shcode` = \'17111\')) and (`co-club`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-club`.`headvoucher`.`htcode`
