public function getImobileAsociatie($id_asociatie)
{
$imobile = DB::select("SELECT\n im.id,\n im.adresa, \n im.numar_apartamente,\n im.observatii,\n loc.Denumire AS localitate,\n judet.Denumire AS judet,\n regiune.Denumire AS regiune\n FROM imobil im\n INNER JOIN scara_imobil scara ON scara.id_imobil = im.id AND im.logical_delete = 0 AND scara.id_ap = :id_asociatie\n LEFT OUTER JOIN tara ON im.id_tara = tara.id_tara AND tara.logical_delete = 0\n LEFT OUTER JOIN judet ON im.id_judet = judet.id_judet AND judet.logical_delete = 0\n LEFT OUTER JOIN localitate loc ON im.id_localitate = loc.id_localitate AND loc.logical_delete = 0\n LEFT OUTER JOIN regiune ON im.id_regiune = regiune.id_regiune AND regiune.logical_delete = 0\n WHERE im.logical_delete = 0", array('id_asociatie' => $id_asociatie));
$ap = new AsociatieProprietariController();
$asociatie = $ap->getAPbyID($id_asociatie);
return View::make("entitate::imobil.list")->with("imobile", $imobile)->with("asociatie", $asociatie);
}
public function getAddScara($id_imobil)
{
$ap = new AsociatieProprietariController();
$asociatii = $ap->getAPJudetImobil($id_imobil);
return View::make('entitate::scara_imobil.add')->with('asociatii', $asociatii);
}