publicstatic List<Record>getNodesById(int id){
Company dao=newCompany();
String sql="select id id,name text,fatherid pid from company where fatherId="+id;
List<Record> menu=Db.find(sql);if(menu!=null){for(int i =0; i < menu.size(); i++){
String sql1="select id id,name text,fatherid pid from company where fatherId="+menu.get(i).getInt("id");
List<Record> menu1=Db.find(sql1);if(menu1.size()>0){ menu.get(i).set("state","closed");}else{ menu.get(i).set("state","true");}}}return menu;}