'.$device['uplink'].' '.$device['name']; print '", "icon" : "'.$dev_icon.'", "id" : "'.$device['id'].'","state" : { "opened" : true },'; print '"a_attr" : { "href": "'.reencodeurl('/admin/devices/editdevice.php?id='.$device['id']).'"},'; print '"children" : ['; print_child($device['id'],$hash); print ']';print "},\n"; } } $dSQL = 'SELECT * FROM devices WHERE deleted=0 and device_type<=2'; $switches = get_records_sql($db_link,$dSQL); $dev_hash = NULL; foreach ($switches as $row) { $dev_id=$row['id']; $dev_hash[$dev_id]['id']=$dev_id; $dev_hash[$dev_id]['name']=$row['device_name']; $dev_hash[$dev_id]['type']=$row['device_type']; $pSQL = 'SELECT * FROM device_ports WHERE uplink = 1 and device_id='.$dev_id; $uplink = get_record_sql($db_link,$pSQL); if (empty($uplink)) { continue; } if (empty($uplink['target_port_id'])) { continue; } //$dev_hash[$dev_id]['uplink']=$uplink['ifName']; $dev_hash[$dev_id]['uplink']=$uplink['port_name']; $parentSQL='SELECT * FROM device_ports WHERE device_ports.id='.$uplink['target_port_id']; $parent=get_record_sql($db_link,$parentSQL); $dev_hash[$dev_id]['parent_id']=$parent['device_id']; //$dev_hash[$dev_id]['parent_port']=$parent['ifName']; $dev_hash[$dev_id]['parent_port']=$parent['port_name']; } print '
'; print "\n"; print '