{"iTotalDisplayRecords":"12","query":"\r\n  SELECT SQL_CALC_FOUND_ROWS `project_id`, `project_name`\r\n  FROM crm_project_master\r\n   Where `project_active` = '1' \r\n  ORDER BY project_name ASC\r\n  \r\n  ","aaData":[{"project_id":"57","project_name":"Ashwasurya Aisiri  Keerthi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":null,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '57' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '57' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"52","project_name":"Ashwasurya APS Keerthi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '52' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '52' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"49","project_name":"Ashwasurya Atharva Riteway","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '49' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '49' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":26,"totalAvailableStockArea":"73,789","totalAvailableStockValue":"0","totalAvailableStockArea_1":73789.58000000002,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"26","totalStockArea":"73,789","totalStockValue":"0","totalStockSites_1":26,"totalStockArea_1":73789.58000000002,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"50","project_name":"Ashwasurya Destiny Farm","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '50' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '50' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"51","project_name":"Ashwasurya Jyesta","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '51' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '51' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"58","project_name":"Ashwasurya Legacy","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '58' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '58' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"48","project_name":"Ashwasurya Lotus","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '48' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '48' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"41","project_name":"Ashwasurya Ruthvi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '41' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '41' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":7,"totalAvailableStockArea":"13,733","totalAvailableStockValue":"0","totalAvailableStockArea_1":13733.78,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"7","totalStockArea":"13,733","totalStockValue":"0","totalStockSites_1":7,"totalStockArea_1":13733.78,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"54","project_name":"Ashwasurya Signature","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '54' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '54' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"55","project_name":"Ashwasurya Urvi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '55' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '55' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"56","project_name":"Ashwasurya Yashas","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '56' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '56' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0},{"project_id":"53","project_name":"JD Ashwasurya Lavish","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_1":0,"dayTotalOtherReceived":"0","dayTotalOtherReceived_1":0,"monthTotalOtherReceived":"0","monthTotalOtherReceived_1":0,"finacialYearOtherReceived":"0","finacialYearOtherReceived_1":0,"financialYearSaleCount":0,"finacialYearArea":"0","finacialYearArea_1":0,"finacialYearReceivable":"0","finacialYearReceivable_1":0,"finacialYearReceived":"0","finacialYearReceived_1":0,"finacialYearBalance":0,"finacialYearBalance_1":0,"financialYearSaleCancelledCount":0,"finacialYearCancelledAmount":"0","finacialYearCancelledAmount_1":0,"previousFinancialYearSaleCancelledCount":0,"previousFinacialYearCancelledAmount":"0","previousFinacialYearCancelledAmount_1":0,"previousFYSalesQuery":"SELECT * FROM crm_site_booking where ( Date(booking_date) < '2026-04-01') AND `booked_project_id` = '53' AND `booking_status` = '1' ","paymentOnPreviousFinancialYearQuery":"SELECT * FROM crm_payment inner join crm_payment_track  on  crm_payment_track.crm_payment_id = crm_payment.crm_payment_id inner join crm_booking on crm_booking.crm_booking_id = crm_payment.crm_payment_booking_id  inner join crm_site_master  on crm_site_master.crm_site_id = crm_booking.crm_booking_site_id where ( Date(crm_payment_receipt_date) < '2026-04-01') AND crm_site_master.crm_project_id = '53' AND crm_booking.crm_booking_status = '1' AND crm_payment_track.crm_payment_track_status = '3' AND crm_payment_track.payment_type = '0'","previousFYTotalReceivable":0,"previousFYTotalReceived":0,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_1":0,"knsBalance":"0","knsBalance_1":0,"investorBalance":"0","investorBalance_1":0,"totalAvailableStock":0,"totalAvailableStockArea":"0","totalAvailableStockValue":"0","totalAvailableStockArea_1":0,"totalAvailableStockValue_1":0,"totalBlockedStock":0,"totalBlockedfStockArea":"0","totalBlockedStockValue":"0","totalBlockedfStockArea_1":0,"totalBlockedStockValue_1":0,"totalStockSites":"0","totalStockArea":"0","totalStockValue":"0","totalStockSites_1":0,"totalStockArea_1":0,"totalStockValue_1":0,"effectiveSiteCost":0}]}