<?php
	include_once("../../../cfg/db.php");

    $type = $db->escape($_POST['type']);

    if(isset($_GET['search'])){
        $search = $db -> escape(trim($_GET['search']));
    } 
    else {
        $search = "";
    }

    if(isset($_GET['offset'])){
        $offset = $db -> escape(trim($_GET['offset']));
    } 
    else {
        $offset = "";
    }

    if(isset($_GET['limit'])){
        $limit =   $db -> escape(trim($_GET['limit']));
        $offset_limit = " LIMIT ". $offset.",".$limit;
    } 
    else {
        $offset_limit = "";
    }

    // confused in file making, why I start at #2
    if($type == 2){ // search bank list
        $search_item = $db->escape($_POST['search_item']);
        $json_arr = array();
        $number_count = 0;

        $count = " COUNT(1) ";
        $fields = " bdl.id, bda.name AS area, bdl.branch_name ";

        $query = "SELECT %s 
            FROM bank_db_list bdl 
            INNER JOIN bank_db bd 
            ON bd.id = f.bank_id 
            INNER JOIN bank_db_areas bda 
            ON bda.id = f.area_id 
            WHERE 1 
                AND concat(bda.name, bdl.branch_name) 
                    LIKE '%%".$search_item."%%'";

        echo sprintf($query, $fields); return;
        $search_query_list = $db->sql_query(sprintf($query, $fields) . $offset_limit);
        $search_query_count = $db->sql_query(sprintf($query, $count));

        while($row = $search_query_list->fetch_assoc()) {
            $json_arr['rows'] = array_merge($json_arr['rows'], array(array(
                'number_count'=>$number_count++,
                'id'=>$row['id'],
                'branch_name'=>$row['branch_name'],
                'area'=>$row['area']
            ))); 
        }

        $json_arr['total'] = $search_query_count;

        echo json_encode($json_arr);
    }
?>