$agent["Adresa2"] = $usr->Adresa2;
$agent["Oras"] = $usr->Oras;
$agent["Judet"] = $usr->Judet;
$agent["Tara"] = $usr->Tara;
$agent["CNP"] = $usr->CNP;
$agent["SerieCI"] = $usr->SerieCI;
$agent["NumarCI"] = $usr->NumarCI;
$agent["Telefon"] = $usr->Telefon;
$agent["Email"] = $usr->Email;
$sql_agent .= "('" . join("', '", array_values($agent)) . "'),";
}
$sql_agent = substr($sql_agent, 0, strlen($sql_agent) - 1);
$result = execute_querry($sql_agent, $conexiune2);
// refresh subzona
$sql = "SELECT * FROM Cartier";
$cartiere = Cartier::find_by_sql($sql);
$sql = "DELETE FROM Subzona";
$result = execute_querry($sql, $conexiune2);
$sql = "ALTER TABLE Subzona AUTO_INCREMENT = 1";
$result = execute_querry($sql, $conexiune2);
$subzona = array();
$sql_subzone = "INSERT INTO Subzona (id,Denumire,idCartier) VALUES ";
foreach ($cartiere as $tmp) {
$subzona["id"] = $tmp->id;
$subzona["Denumire"] = $tmp->Denumire;
$subzona["idCartier"] = $tmp->idZona;
$sql_subzone .= "('" . join("', '", array_values($subzona)) . "'),";
}
$sql_subzone = substr($sql_subzone, 0, strlen($sql_subzone) - 1);
$result = execute_querry($sql_subzone, $conexiune2);
// refresh CategorieDotari
?>
</table>
</div>
<script type="text/javascript">
<?php
$zonalist = Zona::find_all();
if (!empty($zonalist)) {
foreach ($zonalist as $zona) {
echo "hide(\"cartiereZona" . $zona->id . "\");";
}
}
$sql = "SELECT * FROM Cartier WHERE Dezactivat='0' ORDER BY Denumire";
$cartierList = Cartier::find_by_sql($sql);
if (!empty($cartierList)) {
foreach ($cartierList as $cartier) {
echo "hide(\"zoneCartier" . $cartier->id . "\");";
}
}
?>
hide("zoneTree");
//console.log($('#zoneTree table').find('input[type="checkbox"][onClick^="checkZone"]').eq(0));
$('#zoneTree table').find('input[type="checkbox"][onClick^="checkZone"]').each(function(ii, sel){
$(sel).attr('onChange', "triggerChangeZone(this);");
});
function triggerChangeZone(self){
var kids = $(self).parent().parent().parent().next().find('div > table').children().find('input[type="checkbox"][onclick^="selectZone"]');
if($(self).is(':checked')){
