{"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":[{"sl_number":1,"project_id":"57","project_name":"Ashwasurya Aisiri  Keerthi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":2,"project_id":"52","project_name":"Ashwasurya APS Keerthi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":3,"project_id":"49","project_name":"Ashwasurya Atharva Riteway","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":4,"project_id":"50","project_name":"Ashwasurya Destiny Farm","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":5,"project_id":"51","project_name":"Ashwasurya Jyesta","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":6,"project_id":"58","project_name":"Ashwasurya Legacy","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":7,"project_id":"48","project_name":"Ashwasurya Lotus","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":8,"project_id":"41","project_name":"Ashwasurya Ruthvi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":9,"project_id":"54","project_name":"Ashwasurya Signature","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":10,"project_id":"55","project_name":"Ashwasurya Urvi","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":11,"project_id":"56","project_name":"Ashwasurya Yashas","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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},{"sl_number":12,"project_id":"53","project_name":"JD Ashwasurya Lavish","ftDaySaleCount":0,"dayTotalReceived":"0","dayTotalReceived_1":0,"ftMonthSaleCount":0,"ftMonthArea":0,"monthTotalReceived":"0","monthTotalReceived_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,"previousFYBalanceReceivable":"0","previousFYBalanceReceivable_1":0,"totalBalance":"0","totalBalance_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}]}