<?php
class Model_Get_Rayons_Json extends Model
{


    public function get_shops()
    {	
	//$lang = $this->lang_on();
	//$pdo = $this->controller->pdo_connect();
	//$new_orders = self::$pdo->query("select count(*) from users")->fetchColumn();
	
							$sql = 'SELECT * FROM shops WHERE city="Київ" AND rayon!="" GROUP BY rayon';
                            $query = self::$pdo->prepare($sql);
                            $query->execute();
                            
							$arr = array();
							$num = 0;
	                        while ($row = $query->fetchObject()) {								
								$arr[$num][id] = $num;
								$arr[$num][city] = $row->city;
								$arr[$num][rayon] = $row->rayon;
								$arr[$num][adress] = $row->adress;
								$arr[$num][name] = $row->name;
								$arr[$num][contacts] = $row->contacts;
								$arr[$num][url] = $row->url;
								$arr[$num][pic] = '/pics/shops/'.$row->pic;
								$num++;
							}
        return $arr;
    }
	
    public function get_rayon($city,$rayon)
    {	
	//$lang = $this->lang_on();
	//$pdo = $this->controller->pdo_connect();
	//$new_orders = self::$pdo->query("select count(*) from users")->fetchColumn();
	
							$sql = 'SELECT * FROM shops WHERE city="'.$city.'" AND rayon="'.$rayon.'"';
                            $query = self::$pdo->prepare($sql);
                            $query->execute();
                            
							$arr = array();
							$num = 0;
	                        while ($row = $query->fetchObject()) {								
								$arr[$num][id] = $num;
								$arr[$num][city] = $row->city;
								$arr[$num][rayon] = $row->rayon;
								$arr[$num][adress] = $row->adress;
								$arr[$num][name] = $row->name;
								$arr[$num][contacts] = $row->contacts;
								$arr[$num][url] = $row->url;
								$arr[$num][pic] = '/pics/shops/'.$row->pic;
								$num++;
							}
        return $arr;
    }	
}