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); }