Example #1
0
 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]);
 }
Example #2
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'));
 }