$dotAp->idDotare = $dotare;
$dotAp->save();
}
}
redirect_to("oferta_view.php?id=" . $oferta->id);
} else {
$xOfertaId = $_GET['id'];
$oferta = Oferta::find_by_id($xOfertaId);
$apartament = Apartament::find_by_id($oferta->idApartament);
$client = Client::find_by_id($apartament->idClient);
$agent = User::find_by_id($client->idUtilizator);
$agentIntroducere = User::find_by_id($oferta->idAgentIntroducere);
$agentVizionare = User::find_by_id($oferta->idAgentInchiriere);
$agentLucreaza = User::find_by_id($oferta->IdAgentVanzare);
$strada = Strada::find_by_id($apartament->idStrada);
$stradaClient = Strada::find_by_id($client->idStrada);
$subzona = Subzona::find_by_id($apartament->idSubzona);
$sursa = Sursa::find_by_id($apartament->idSursa);
switch ($apartament->TipProprietate) {
case 0:
$tipprop = "xa";
break;
case 1:
$tipprop = "xb";
break;
case 2:
$tipprop = "xc";
break;
case 3:
$tipprop = "xt";
break;
// 0 - nu se exporta
// 1 - creare
// 2 - update
// 3 - delete
// 4 - exportat
$oferte = Oferta::find_by_sql($sql);
if (!empty($oferte)) {
$fisier = "." . DS . "export" . DS . "RoImobile.txt";
$fh = fopen($fisier, "w");
fwrite($fh, "\n");
foreach ($oferte as $oferta) {
$apartament = Apartament::find_by_id($oferta->idApartament);
$client = Client::find_by_id($apartament->idClient);
$agent = User::find_by_id($client->idUtilizator);
$subzona = Subzona::find_by_id($apartament->idSubzona);
$strada = Strada::find_by_id($apartament->idStrada);
$sql = "SELECT * FROM Foto WHERE idApartament={$apartament->id} ORDER BY Ordin DESC";
$fotografii = Foto::find_by_sql($sql);
if ($oferta->Vanzare == 1) {
posteazaAnunt(0);
}
if ($oferta->Inchiriere == 1) {
posteazaAnunt(1);
}
$oferta->ExportRoImobile = $oferta->ExportRoImobile == 3 ? 0 : 4;
if ($oferta->Stare != 'de actualitate') {
$oferta->ExportRoImobile = 0;
}
$oferta->save();
}
}
</form>
<?php
if (isset($_POST['submit'])) {
?>
<div class="view" align="center" >
<h3>Lista strazi gasite</h3>
<table width="600px">
<tr>
<td class="header" width="10%">Cod</td>
<td class="header" width="60%">Denumire</td>
<td class="header" width="40%">Operatii</td>
</tr>
<?php
$sql = "SELECT * FROM Strada WHERE Denumire LIKE '%{$strada}%'";
$stradaList = Strada::find_by_sql($sql);
if (!empty($stradaList)) {
$i = 0;
foreach ($stradaList as $strada) {
$i++;
$class = $i % 2 ? "impar" : "par";
echo "<tr id='" . $strada->id . "' class='" . $class . "' ondblclick=stradaEdit(" . $strada->id . ") onmouseover=onOver(" . $strada->id . ",1," . $i . ") onmouseout=onOver(" . $strada->id . ",0," . $i . ") >";
echo "<td>" . $strada->id . "</td>";
echo "<td>" . $strada->Denumire . "</td>";
echo "<td> <a href=\"strada_update.php?id=" . $strada->id . "\">modifica</a> | <a href=\"strada_delete.php?id=" . $strada->id . "\">sterge</a></td>";
}
}
?>
</table>
</div>
}
include_layout_template('admin_header.php');
?>
<script type="text/javascript">
<!--
function back(){
document.location = ("strada_list.php");
}
//-->
</script>
<?php
$message = "";
if (isset($_POST['submit'])) {
$strada = new Strada();
$Denumire = $_POST['Denumire'];
$sql = "SELECT * FROM Strada WHERE Denumire='{$Denumire}'";
$stradaList = Strada::find_by_sql($sql);
if (!empty($stradaList)) {
$message = "Strada deja exista in baza de date";
} else {
$strada->Denumire = $Denumire;
$strada->save();
$message = "Adaugat";
}
}
?>
<form action="strada_new.php" method="post">
<div class="view" align="center" >
require_once ".././include/initialize.php";
if (!$session->is_logged_in()) {
redirect_to("login.php");
}
include_layout_template('admin_header.php');
?>
<script type="text/javascript">
<!--
function back(){
document.location = ("strada_list.php");
}
//-->
</script>
<?php
$strada = Strada::find_by_id($_GET['id']);
$strada->delete();
?>
<h3>Strada <?php
echo $strada->Denumire;
?>
a fost stearsa.</h3>
<div id="butoane" class="butoane">
<input type="button" name="submit" value="Inapoi" onclick="back()" />
</div>
<?php
include_layout_template('admin_footer.php');
$oferta->Titlu .= ($apartament->Etaje < 1 ? "casa " : "vila ") . $apartament->NumarCamere . " camere ";
} else {
$oferta->Titlu .= tip_proprietate($apartament->TipProprietate) . " ";
if ($apartament->TipProprietate == 4) {
$oferta->Titlu .= $apartament->TipSpatiu . " ";
}
}
}
$zona = Subzona::find_by_id($apartament->idSubzona);
$cartier = Cartier::find_by_id($zona->idCartier);
$oferta->Titlu .= $cartier->Denumire;
}
$oferta->save();
$sql = "SELECT * FROM Strada WHERE Denumire='" . str_replace("%20", " ", $client->idStrada) . "' LIMIT 1";
//print_r($_POST);
$stradaLc = Strada::find_by_sql($sql);
$strada = array_shift($stradaLc);
$client->idStrada = $strada->id;
$client->save();
$sql = "SELECT * FROM DotareApartament WHERE idApartament='{$apartament->id}'";
$DAList = Dotareapartament::find_by_sql($sql);
if (!empty($DAList)) {
foreach ($DAList as $dotAP) {
$dotAP->delete();
}
}
if (!empty($dotariList)) {
foreach ($dotariList as $dotare) {
$dotAp = new Dotareapartament();
$dotAp->idApartament = $apartament->id;
$dotAp->idDotare = $dotare;
" /></td>
</tr>
<tr>
<td>Adresa</td>
<td><input type="text" name="Adresa" maxlength="30" value="<?php
echo htmlentities(isset($Adresa) ? $Adresa : "");
?>
" /></td>
</tr>
<tr>
<td>Strada</td>
<td>
<select name='idStrada'>
<option value='' selected='selected'>alegeti ...</option>
<?php
$stradalist = Strada::find_all();
foreach ($stradalist as $strada) {
echo "<option ";
echo "label='" . $strada->Denumire;
echo "' value='" . $strada->id . "'";
echo "></option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Oras</td>
<td><input type="text" name="Oras" maxlength="30" value="<?php
echo htmlentities(isset($Oras) ? $Oras : "");
?>
document.location = ("strada_list.php");
}
//-->
</script>
<?php
$message = "";
if (isset($_GET['id'])) {
$strada = Strada::find_by_id($_GET['id']);
$Denumire = $strada->Denumire;
$_SESSION['curentIdStrada'] = $strada->id;
}
if (isset($_POST['submit'])) {
$strada = new Strada();
$Denumire = $_POST['Denumire'];
$strada = Strada::find_by_id($_SESSION['curentIdStrada']);
unset($_SESSION['curentIdStrada']);
$strada->Denumire = $Denumire;
$strada->save();
$message = "salvat";
}
?>
<form action="strada_update.php" method="post">
<div class="view" align="center" >
<h3>Modificare strada<?php
if ($message != "") {
echo " - " . $message;
}
?>
</h3>
