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