{"iTotalDisplayRecords":"3","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `loan_id`, `loan_code`, `company_id`, `stock_company_master_name`, `borrower_type`, `borrower_id`, `bank_id`, `bank_name`, `category_id`, `category_name`, `loan_account_number`, `loan_description`, `loan_applied_amount`, `loan_applied_date`, `loan_sanction_amount`, `loan_sanction_date`, `loan_disbursed_amount`, `outstanding_principal_amount`, `outstanding_interest_amount`, `loan_tenure`, `loan_status`, `loan_closing_date`, `added_by`, `added_on`, `added_user_name`, `director_name`\r\n    FROM loan_view\r\n    \r\n    ORDER BY added_on ASC\r\n    \r\n    ","aaData":[{"loan_id":"1357","loan_code":"KNSL1357","company_id":"1","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","borrower_type":"Director","borrower_id":"2","bank_id":"4","bank_name":"Axis Bank","category_id":"152","category_name":"Test-Case-13","loan_account_number":"12334","loan_description":"ffg","loan_applied_amount":"0","loan_applied_date":"0000-00-00","loan_sanction_amount":"12","loan_sanction_date":"2023-04-26","loan_disbursed_amount":"0","outstanding_principal_amount":"0","outstanding_interest_amount":"0","loan_tenure":"12","loan_status":"Sanctioned","loan_closing_date":"2023-04-27","added_by":"143620071466608200","added_on":"2023-04-27 19:18:09","added_user_name":"NANJEGOWDA","director_name":null,"documentCount":0,"disbursment_amt":null,"principal_installment_amount":null,"interest_amt":"10","penalty_amt":null,"principal_amt_emi":null,"interest_amt_emi":null,"penalty_amt_emi":null,"total_Penalty":0},{"loan_id":"1358","loan_code":"KNSL1358","company_id":"2","stock_company_master_name":"K.N. SURENDRA","borrower_type":"Company","borrower_id":"2","bank_id":"7","bank_name":"ICICI Bank","category_id":"156","category_name":"Test-Case-5","loan_account_number":"775756465","loan_description":"Test Desc","loan_applied_amount":"6700","loan_applied_date":"2023-04-21","loan_sanction_amount":"1200","loan_sanction_date":"2023-04-27","loan_disbursed_amount":"0","outstanding_principal_amount":"0","outstanding_interest_amount":"0","loan_tenure":"12","loan_status":"Sanctioned","loan_closing_date":"2023-04-28","added_by":"143620071466608200","added_on":"2023-04-27 21:15:35","added_user_name":"NANJEGOWDA","director_name":null,"documentCount":0,"disbursment_amt":"320","principal_installment_amount":null,"interest_amt":"5","penalty_amt":"10","principal_amt_emi":null,"interest_amt_emi":null,"penalty_amt_emi":null,"total_Penalty":0},{"loan_id":"1359","loan_code":"KNSL1359","company_id":"23","stock_company_master_name":"KNS PROPWORTH LLP","borrower_type":"Company","borrower_id":"23","bank_id":"5","bank_name":"HDFC Bank","category_id":"168","category_name":"test1","loan_account_number":"0","loan_description":"xdfxdfdfzdf","loan_applied_amount":"123123","loan_applied_date":"2023-07-07","loan_sanction_amount":"0","loan_sanction_date":"1970-01-01","loan_disbursed_amount":"0","outstanding_principal_amount":"0","outstanding_interest_amount":"0","loan_tenure":"0","loan_status":"Applied","loan_closing_date":"1970-01-01","added_by":"144128013799301700","added_on":"2023-07-07 11:32:13","added_user_name":"NAGARAJ PRAKASH","director_name":null,"documentCount":0,"disbursment_amt":null,"principal_installment_amount":null,"interest_amt":null,"penalty_amt":null,"principal_amt_emi":null,"interest_amt_emi":null,"penalty_amt_emi":null,"total_Penalty":0}]}