TYPE=VIEW
query=select `loan_inst`.`tdate` AS `tdate`,`loan_inst`.`head` AS `head`,`loan_inst`.`sub_head` AS `sub_head`,`loan_inst`.`nsc` AS `nsc`,`loan_inst`.`acc_no` AS `acc_no`,`loan_inst`.`fianl_date` AS `fianl_date`,`loan_inst`.`duration` AS `duration`,`loan_inst`.`duration_type` AS `duration_type`,`loan_inst`.`loan_inst` AS `loan_inst`,`loan_inst`.`ins_type` AS `ins_type`,`loan_inst`.`cc_int` AS `cc_int`,`loan_inst`.`od_int` AS `od_int`,`loan_inst`.`cc_int_due` AS `cc_int_due`,`loan_inst`.`od_int_due` AS `od_int_due`,`loan_inst`.`jer_amt` AS `jer_amt`,`loan_inst`.`loan_amt` AS `loan_amt`,`loan_inst`.`clear_amt` AS `clear_amt`,`loan_inst`.`total_pay` AS `total_pay`,`loan_inst`.`pay_date` AS `pay_date`,`loan_inst`.`days` AS `days`,`loan_inst`.`cc_days` AS `cc_days`,`loan_inst`.`od_days` AS `od_days`,`loan_inst`.`dur_day` AS `dur_day`,`loan_inst`.`issue_date` AS `issue_date`,`loan_inst`.`ins_no` AS `ins_no`,if((`loan_inst`.`ins_type` = \'One Time (1)\'),`loan_inst`.`fianl_date`,if((`loan_inst`.`ins_type` = \'Days (365)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) day),if((`loan_inst`.`ins_type` = \'Monthly (12)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) month),if((`loan_inst`.`ins_type` = \'Quaterly (4)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) quarter),if((`loan_inst`.`ins_type` = \'Halfyearly (2)\'),(`loan_inst`.`issue_date` + interval (if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) * 2) quarter),if((`loan_inst`.`ins_type` = \'Yearly (1)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) year),0)))))) AS `imst_date` from `co-club`.`loan_inst` where (`loan_inst`.`clear_amt` <> 0)
md5=f9fc37c1afabcd3cb98b095c34ef0cac
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-12-27 10:00:29
create-version=1
source=SELECT *,if((ins_type = \'One Time (1)\'),fianl_date,if((ins_type = \'Days (365)\'),(issue_date + interval if((ins_no = 0),1,ins_no) day),if((ins_type = \'Monthly (12)\'),(issue_date + interval if((ins_no = 0),1,ins_no) month),if((ins_type = \'Quaterly (4)\'),(issue_date + interval if((ins_no = 0),1,ins_no) quarter),if((ins_type = \'Halfyearly (2)\'),(issue_date + interval (if((ins_no = 0),1,ins_no) * 2) quarter),if((ins_type = \'Yearly (1)\'),(issue_date + interval if((ins_no = 0),1,ins_no) year),0)))))) AS imst_date FROM `loan_inst` WHERE `clear_amt`<>0
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `loan_inst`.`tdate` AS `tdate`,`loan_inst`.`head` AS `head`,`loan_inst`.`sub_head` AS `sub_head`,`loan_inst`.`nsc` AS `nsc`,`loan_inst`.`acc_no` AS `acc_no`,`loan_inst`.`fianl_date` AS `fianl_date`,`loan_inst`.`duration` AS `duration`,`loan_inst`.`duration_type` AS `duration_type`,`loan_inst`.`loan_inst` AS `loan_inst`,`loan_inst`.`ins_type` AS `ins_type`,`loan_inst`.`cc_int` AS `cc_int`,`loan_inst`.`od_int` AS `od_int`,`loan_inst`.`cc_int_due` AS `cc_int_due`,`loan_inst`.`od_int_due` AS `od_int_due`,`loan_inst`.`jer_amt` AS `jer_amt`,`loan_inst`.`loan_amt` AS `loan_amt`,`loan_inst`.`clear_amt` AS `clear_amt`,`loan_inst`.`total_pay` AS `total_pay`,`loan_inst`.`pay_date` AS `pay_date`,`loan_inst`.`days` AS `days`,`loan_inst`.`cc_days` AS `cc_days`,`loan_inst`.`od_days` AS `od_days`,`loan_inst`.`dur_day` AS `dur_day`,`loan_inst`.`issue_date` AS `issue_date`,`loan_inst`.`ins_no` AS `ins_no`,if((`loan_inst`.`ins_type` = \'One Time (1)\'),`loan_inst`.`fianl_date`,if((`loan_inst`.`ins_type` = \'Days (365)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) day),if((`loan_inst`.`ins_type` = \'Monthly (12)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) month),if((`loan_inst`.`ins_type` = \'Quaterly (4)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) quarter),if((`loan_inst`.`ins_type` = \'Halfyearly (2)\'),(`loan_inst`.`issue_date` + interval (if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) * 2) quarter),if((`loan_inst`.`ins_type` = \'Yearly (1)\'),(`loan_inst`.`issue_date` + interval if((`loan_inst`.`ins_no` = 0),1,`loan_inst`.`ins_no`) year),0)))))) AS `imst_date` from `co-club`.`loan_inst` where (`loan_inst`.`clear_amt` <> 0)
