public function getScari($id_imobil) { $im = new \Codecorner\Imobil\Controllers\ImobileController(); $imobil = $im->getImobil($id_imobil); $scari = DB::select("SELECT\n scara_imobil.id,\n scara_imobil.scara,\n scara_imobil.observatii,\n scara_imobil.id_imobil,\n scara_imobil.id_ap,\n ap.denumire as ap\n FROM scara_imobil\n LEFT OUTER JOIN asociatie_proprietari ap ON ap.id = scara_imobil.id_ap AND ap.logical_delete = 0\n WHERE scara_imobil.logical_delete = 0\n AND scara_imobil.id_imobil = :id_imobil", array('id_imobil' => $id_imobil)); return View::make('imobil::scara_imobil.list')->with('scari', $scari)->with('id_imobil', $id_imobil)->with('imobil', $imobil[0]); }
public function getLocatariImobil($id_imobil) { $im = new \Codecorner\Imobil\Controllers\ImobileController(); $imobil = $im->getImobil($id_imobil); $suprafata_utila_imobil = self::getSuprafataUtilaImobil($id_imobil, $imobil[0]->numar_apartamente); $locatari = self::getLocatariImobilASObject($id_imobil); return View::make('imobil::locatari.list_rezumat')->with('locatari', $locatari)->with('suprafata_utila_imobil', $suprafata_utila_imobil)->with('imobil', $imobil[0]); }
public function getLocatariImobil($id_investitie, $id_imobil) { $im = new \Codecorner\Imobil\Controllers\ImobileController(); $imobil = $im->getImobil($id_imobil); $locatar_class = new \Codecorner\Imobil\Controllers\LocatarController(); $locatari = $locatar_class->getLocatariImobilASObject($id_imobil, $imobil[0]->numar_apartamente); $suprafata_utila_imobil = $locatar_class->getSuprafataUtilaImobil($id_imobil, $imobil[0]->numar_apartamente); $imobil = $imobil[0]; return View::make('investitie_por_axa12.lucrari_individuale_list', compact('locatari', 'suprafata_utila_imobil', 'imobil')); }