$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')){