All IND Query

gistfile1.txt

        switch ($ind_code) {

            case '001':
                $query = $con->select('SELECT count(distinct(branch_id)) as data FROM `monthlySavingSummary` where report_date between ? and ?',$date_between);
                break;

            case '002':
                $query = $con->select('SELECT sum(male_samity) as data FROM `monthlySavingSummary` where row_type = 1 and report_date between ? and ?',$date_between);
                break;

            case '003':
                $query = $con->select('SELECT sum(female_samity) as data FROM `monthlySavingSummary` where row_type = 1 and report_date between ? and ?',$date_between);
                break;

            case '004':
                $query = $con->select('SELECT sum(number_of_male_member) as data FROM `monthlySavingSummary` where row_type = 1 and report_date between ? and ?',$date_between);
                break;

            case '005':
                $query = $con->select('SELECT sum(number_of_female_member) as data FROM `monthlySavingSummary` where row_type = 1 and report_date between ? and ?',$date_between);
                break;

            case '006':
                $query = $con->select("select Gender, sum(closing_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=1 group by Gender", $date_between);
                break;

            case '007':
                $query = $con->select("select Gender, sum(closing_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=2 group by Gender", $date_between);
                break;

            case '008':
                $query = $con->select("select Gender, sum(cumulative_loan) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=1 group by Gender", $date_between);
                break;

            case '009':
                $query = $con->select("select Gender, sum(cumulative_loan) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=2 group by Gender", $date_between);
                break;

            case '010':
                $query = $con->select("select Gender, sum(cumulative_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=1 group by Gender", $date_between);
                break;

            case '011':
                $query = $con->select("select Gender, sum(cumulative_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=2 group by Gender", $date_between);
                break;

            case '014':
                $query = $con->select('select sum(this_month_deposit_male) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '015':
                $query = $con->select('select sum(this_month_deposit_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '016':
                $query = $con->select('select sum(this_month_withdraw_male) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '017':
                $query = $con->select('select sum(this_month_withdraw_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '018':
                $query = $con->select('select sum(this_month_partial_withdraw_male)+sum(this_month_Full_withdraw_male) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '019':
                $query = $con->select('select sum(this_month_partial_withdraw_fmale)+sum(this_month_Full_withdraw_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '020':
                $query = $con->select('select sum(closing_balance_male) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '021':
                $query = $con->select('select sum(closing_balance_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` = "GS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '022':
                $query = $con->select('select sum(closing_balance_male) as data from `monthlySavingSummary` where `saving_product_group_id` = "SS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '023':
                $query = $con->select('select sum(closing_balance_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` = "SS" and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '024':
                $query = $con->select('select sum(closing_balance_male) as data from `monthlySavingSummary` where `saving_product_group_id` not in ("GS","SS") and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '025':
                $query = $con->select('select sum(closing_balance_fmale) as data from `monthlySavingSummary` where `saving_product_group_id` not in ("GS","SS") and `row_type` = "0" and (report_date between ? and ? )', $date_between);
                break;

            case '026':
                    $query = $con->select('select sum(closing_balance_male) as data from `monthlySavingSummary` where `row_type` = "0" and (report_date between ? and ? )',$date_between);
                    break;

            case '027':
                    $query = $con->select('select sum(closing_balance_fmale) as data from `monthlySavingSummary` where `row_type` = "0" and (report_date between ? and ? )',$date_between);
                    break;

            case '028':
                    $query = $con->select('select sum(attendence_avg) as data from `monthlySavingSummary` where `row_type` = "2" and (report_date between ? and ? )',$date_between);
                    break;

            case '029':
                    $query = $con->select('select sum(this_month_disburse_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '030':
                    $query = $con->select('select sum(this_month_disburse_loanee) as data from `monthlyLoanSummary` where `row_type` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '031':
                    $query = $con->select('select sum(closing_due_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '032':
                    $query = $con->select('select sum(closing_due_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '033':
                    $query = $con->select('select sum(regular_recoverable_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '034':
                    $query = $con->select('select sum(regular_recoverable_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '035':
                    $query = $con->select('select sum(regular_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '036':
                    $query = $con->select('select sum(regular_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '037':
                    $query = $con->select('select sum(due_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '038':
                    $query = $con->select('select sum(due_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '039':
                    $query = $con->select('select sum(advance_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '040':
                    $query = $con->select('select sum(advance_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '041':
                    $query = $con->select('select sum(regular_collection_prin)+sum(due_collection_prin)+sum(advance_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '042':
                    $query = $con->select('select sum(closing_due_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '043':
                    $query = $con->select('select sum(closing_due_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '044':
                    $query = $con->select('select sum(closing_due_loanee) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '045':
                    $query = $con->select('select sum(closing_due_loanee) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '046':
                    $query = $con->select('select sum(substandard_due_sc) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '047':
                    $query = $con->select('select sum(doubtful_due_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '048':
                    $query = $con->select('select sum(badloan_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '049':
                    $query = $con->select('select sum(substandard_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '050':
                    $query = $con->select('select sum(doubtful_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '051':
                    $query = $con->select('select sum(badloan_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '052':
                    $query = $con->select('select sum(due_members_Savings_balance) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '054':
                    $query = $con->select('select sum(due_members_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '055':
                    $query = $con->select('select sum(regular_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '056':
                    $query = $con->select('select sum(regular_recoverable_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '058':
                    $query = $con->select('select count(emp_id) as data from `monthlySavingSummary` where (report_date between ? and ? )',$date_between);
                    break;
            case '061':
                    $query = $con->select('select sum(cum_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '062':
                    $query = $con->select('select sum(cum_collection_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '063':
                    $query = $con->select('select sum(closing_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '064':
                    $query = $con->select('select sum(closing_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '065':
                    $query = $con->select('select sum(due_2installment_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "1" and (process_date between ? and ? )',$date_between);
                    break;

            case '066':
                    $query = $con->select('select sum(due_2installment_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and `gender` = "2" and (process_date between ? and ? )',$date_between);
                    break;

            case '067':
                    $query = $con->select('select sum(closing_amount_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                    break;

            case '070':
                    $query = $con->select('select sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '071':
                    $query = $con->select('select sum(Credit_amount)-sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '072':
                    $query = $con->select('select sum(Credit_amount)-sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '073':
                    $query = $con->select('select sum(Credit_amount)-sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '074':
                    $query = $con->select('select sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '075':
                    $query = $con->select('select sum(Debit_amount) as data from `accounting_subsidiary_calculations` where (Transaction_date between ? and ? )',$date_between);
                    break;

            case '096':
                $query = $con->select('SELECT sum(Credit_amount)-sum(Debit_amount) as data FROM `accounting_subsidiary_calculations` where Group_id = 4 and Transaction_date BETWEEN ? and ?',$date_between);
                break;

            case '097':
                $query = $con->select('SELECT sum(Debit_amount)-sum(Credit_amount) as data FROM `accounting_subsidiary_calculations` where Group_id = 2 and Transaction_date BETWEEN ? and ?',$date_between);
                break;

            case '109':
                $query = $con->select("SELECT sum(Inter_rate) as data FROM `saving_product` where `group` = 'GS'");
                break;

            case '119':
                $query = $con->select('SELECT count(distinct(branch_id)) as data FROM `monthlySavingSummary` where report_date between ? and ?',$date_between);
                break;

            case '121':
                $query = $con->select('SELECT sum(male_samity) as data FROM `monthlySavingSummary` where row_type = 2 and report_date between ? and ?',$date_between);
                break;

            case '122':
                $query = $con->select('SELECT sum(female_samity) as data FROM `monthlySavingSummary` where row_type = 2 and report_date between ? and ?',$date_between);
                break;

            case '123':
                $query = $con->select("SELECT sum(number_of_male_member) as data from `monthlySavingSummary` where row_type = 2 and (report_date BETWEEN ? and ?)", $date_between);
                break;

            case '124':
                $query = $con->select("SELECT sum(number_of_female_member) as data from `monthlySavingSummary` where row_type = 2 and (report_date BETWEEN ? and ?)", $date_between);
                break;

            case '125':
                $query = $con->select("select Gender, sum(closing_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=1 group by Gender", $date_between);
                break;

            case '126':
                $query = $con->select("select Gender, sum(closing_loanee) as data from `monthlyLoanSummary` where row_type=1 and (process_date between ? and ?) and Gender=2 group by Gender", $date_between);
                break;

            case '127':

                $query = $con->select("select count(distinct(emp_id)) as data from `monthlySavingSummary` where report_date between ? and ?",$date_between);
                break;

            case '128':
                $query = $con->select("select count(distinct(emp_id)) as data from `monthlySavingSummary` where report_date between ? and ?",$date_between);
                break;

            case '134':
                $query = $con->select('select sum(watchful_due_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                break;

            case '135':
                $query = $con->select('select sum(watchful_outs_prin) as data from `monthlyLoanSummary` where `row_type` = "0" and (process_date between ? and ? )',$date_between);
                break;

            case '157':
                $query = $con->select("select count(distinct(district)) as data from `working_area` where (created_at between ? and ?)",$date_between);
                break;

            case '158':
                $query = $con->select("select count(distinct(thana)) as data from `working_area` where (created_at between ? and ?)",$date_between);
                break;

            case '159':
                $query = $con->select("select count(distinct(union_wards)) as data from `working_area` where (created_at between ? and ?)",$date_between);
                break;

            case '160':
                $query = $con->select("select count(distinct(village_blocks)) as data from `working_area` where (created_at between ? and ?)",$date_between);
                break;

            case '161':
                $query = $con->select("SELECT sum(number_of_male_member)+sum(number_of_female_member) as data FROM `monthlySavingSummary` where row_type=1 and report_date between ? and ?", $date_between);

                break;
            
            default:
                $query = 'N/A';
                break;
        }