dtz33344 2013-02-12 09:16
浏览 51
已采纳

extjs 4:仅按特定ID显示树面板节点

MySQL DATABASE:

CREATE DATABASE `tree`;

DROP TABLE IF EXISTS `mytree`;
CREATE TABLE `mytree` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'node_id',
  `text` varchar(20) NOT NULL COMMENT 'node_name',
  `parent_id` int(11) NOT NULL,
  `leaf` varchar(5) NOT NULL COMMENT 'true/false',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;

INSERT INTO `mytree` VALUES (36,'Folder 1',0,'false'),
(38,'Folder 2',0,'false'),(42,'Text 1',36,'true'),
(43,'Folder 3',0,'false'),(44,'Text 2',36,'true'),
(52,'Text 6',38,'true'),(57,'Text 5',38,'true'),
(58,'Text 4',38,'true'),(73,'Subfolder 1',36,'false'),
(74,'Text 7',73,'true'),(75,'Text 10',73,'true'),
(76,'Text 9',73,'true'); 

tree.php

<?php
mysql_connect("localhost", "root", "") or die("Could not connect");
mysql_select_db("tree") or die("Could not select database");

$parent_id = $_GET['node'];
$id = $_GET['id'];
    // 1) Remove false as checked
    $query = "SELECT id, text,parent_id, leaf FROM mytree WHERE parent_id='".$parent_id."' ORDER BY text ASC";
    $rs = mysql_query($query);
    $arr = array();
    while($obj = mysql_fetch_object($rs)) {

      // 2) If no leaf then destroy the attribute
      if($obj->leaf != "false"){
         // 1) set checked attribute with an boolean value 
         $obj->checked = false;       
      }
     $arr[] = $obj;
    }
    echo json_encode($arr);
?>

script:

Ext.onReady(function() {
    var store = Ext.create('Ext.data.TreeStore', {
        proxy: {
    type: 'ajax',
    url: 'tree.php',
    extraParams :{id:'38,43'},
    // Here Magic comes
    actionMethods: {
      create : 'GET',
      read   : 'GET',
      update : 'GET',
      destroy: 'GET'
    }
        },
        sorters: [{
            property: 'leaf',
            direction: 'ASC'
        }, {
            property: 'text',
            direction: 'ASC'
        }]
    });

Question:

1)i just want to show the tree panel root where id 38 and 43 only.if we changing the code inside .php , when clicked the tree panel the tree are cannot expand the data.so,i dont think so we changing the code in php script?how to just display the data i want in the tree panel? P/S:passing parameters of id are flexible, not only 38 and 43.

  • 写回答

1条回答 默认 最新

  • duanlu2935 2013-02-18 19:32
    关注

    I think this will work for what you want:

       <?php
        mysql_connect("localhost", "root", "") or die("Could not connect");
        mysql_select_db("tree") or die("Could not select database");
    
        $parent_id = $_GET['node'];
        $id = $_GET['id'];
        // 1) Remove false as checked
        $query = "SELECT id, text,parent_id, leaf FROM mytree WHERE parent_id='".$parent_id."' ";
        if($parent_id == 0)
            $query = $query."AND id IN (".$id.") ";
        $query = $query."ORDER BY text ASC";
        $rs = mysql_query($query);
        $arr = array();
        while($obj = mysql_fetch_object($rs)) {
    
          // 2) If no leaf then destroy the attribute
          if($obj->leaf != "false"){
             // 1) set checked attribute with an boolean value 
             $obj->checked = false;       
          }
         $arr[] = $obj;
        }
        echo json_encode($arr);
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 数据结构—复杂度分析
  • ¥15 如何使用单链表编写学生信息管理系统?
  • ¥15 完成课题以及ppt 在21号之前完成
  • ¥15 懂的来,你应该知道我在说什么,我需要你的帮助
  • ¥15 关于#java#的问题,请各位专家解答!
  • ¥15 maccms影视模板 制作影视网站失败 求
  • ¥15 stm32按键设置闹钟数进退位不正常
  • ¥15 自己写的测试驱动程序无法启动
  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设