CTreeView AJAX Tree

[hav3fun (Gmateos)]

It seems to exit in the very beginning:

if (!Yii::app()->request->isAjaxRequest) {

                        exit();

}

That’s the problem. Do you know why is not an ajax request?

Thats whay i was wondering if I should do anything to enable Ajax or what…

I would appreciatte if you could give any hint on this. Thank u.

[macinville]

Hi hav3fun,

Wierd, because I actually got it working.

These is my table:

CREATE TABLE `menu` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `id_parent` int(11) DEFAULT NULL,

 `title` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

 `position` int(2) NOT NULL,

 `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

 `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

 PRIMARY KEY (`id`),

 KEY `id_parent` (`id_parent`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

This is the part of my controller:

public function actionAjaxFillTree() {

        if (!Yii::app()->request->isAjaxRequest) {

            exit();

        }

        $parentId = "NULL";

        if (isset($_GET['root']) && $_GET['root'] !== 'source') {

            $parentId = (int) $_GET['root'];

        }

        $req = Yii::app()->db->createCommand(

                        "SELECT m1.id, m1.title AS text, m2.id IS NOT NULL AS hasChildren "

                        . "FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.id=m2.id_parent "

                        . "WHERE m1.id_parent <=> $parentId "

                        . "GROUP BY m1.id ORDER BY m1.title ASC"

        );

        $children = $req->queryAll();

        echo str_replace(

                '"hasChildren":"0"', '"hasChildren":false', CTreeView::saveDataAsJson($children)

        );

        exit();

    }

And this is my view:

<?php

$this->widget('CTreeView', array(

    'animated' => 'fast', //quick animation

    'collapsed' => true,

    'url' => array('site/ajaxFillTree'),

    'htmlOptions' => array(

        'class' => 'treeview-famfamfam',

    ))

);

?>

insert these in your menu table for samples:

INSERT INTO `menu` (

`id` ,

`id_parent` ,

`title` ,

`position` ,

`url` ,

`icon`

)

VALUES (

'1', NULL , 'tree1', '', '', NULL

), (

'2', '1', 'subtree1', '', '', NULL

), (

'3', NULL , 'tree2', '', '', NULL

), (

'4', '3', 'subtree2', '', '', NULL

), (

'5', '3', 'subtree2', '', '', NULL

);

[hav3fun (Gmateos)]

Thanks for the info,

Finally it worked yesterday. Basically I didn´t changed anything but in the way of calling the view with the tree, so that I´m sure that the call is an AJAX call.

Now I´m trying with the SimpleTree extension, which was my intention in the first place. Wish me luck!

Thanks

[talles (Talles D O P)]

YEAAAAH , IT WORKED , Thanks Macinville , you hellped me alot =D .

[macinville]

@hav3fun

Glad you got it rolling. Good luck!

@talles

Welcome! Good luck also!

[Samar (Samarrizvi Lko)]

@hav3fun

Glad you got it rolling. Good luck!

@talles

Welcome! Good luck also!

Hi, I am having the same problem that have3fun was having. The html only shows

<ul class="treeview-famfamfam" id="yw0"></ul>

and no content is loaded. I am using the wiki example. Can you help, is there a problem with accessrules.

[tomwang (Tzwang)]

the problem that caused the sample code above not working is this

app()->createUrl

it missed Yii::app()->createUrl

after i changed that, it works.

[ostovar (Ostovarit)]

the problem that caused the sample code above not working is this

app()->createUrl

it missed Yii::app()->createUrl

after i changed that, it works.

Hi

CTreeView won’t display when i add createLinks() function

my CTreeView works great with out urls

how can i add url for each nodes??

[macinville]

Hi

CTreeView won’t display when i add createLinks() function

my CTreeView works great with out urls

how can i add url for each nodes??

I’m currently working on extending the CTreeView to allow links if is given in the table. But for now, can you please post your table here? Let me use it to check my extension if it will work.

[bingjie2680]

Hi

CTreeView won’t display when i add createLinks() function

my CTreeView works great with out urls

how can i add url for each nodes??

I have just write something about this. you can find solution here

[h3rm]

Hi again, and thanks for your quick response.

I´ve checked firebug console but there´s no log related to AJAX calls.

I don´t know where is the problem, i´ve spent two days on this when it´s supposed to be quite simple, right?

This is the snippet in my SiteController:

 public function actionTree(){

                if (!Yii::app()->request->isAjaxRequest) {

                        exit();

                }

                $parentId = "NULL";

                if (isset($_GET['root']) && $_GET['root'] !== 'source') {

                        $parentId = (int) $_GET['root'];

                }

                $sql = "SELECT m1.id, m1.title AS text, m2.id IS NOT NULL AS hasChildren,m1.url "

                . "FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.id=m2.id_parent "

                . "WHERE m1.id_parent <=> $parentId "

                . "GROUP BY m1.id ORDER BY m1.position ASC";

                $req = Yii::app()->db->createCommand($sql);

                $children = $req->queryAll();


                $children = $this->createLinks($children);


                echo str_replace(

                        '"hasChildren":"0"',

                        '"hasChildren":false',

                        CTreeView::saveDataAsJson($children)

                );

                exit();

        }

And this is the code in my wiew:

<?php

        $this->widget(

                'CTreeView',

                array(

                        'animated'=>'fast', //quick animation

                        'collapsed' => true,

                        'url' => array('/site/tree'),

                )

        );	

?>

so that my test page is localhost/index.php/site/tree

Can you see where the problem is?

Thanks!

Hi… i tried but get error like:

CDbException

CDbCommand failed to execute the SQL statement: CDbCommand failed to prepare the SQL statement: SQLSTATE[HY000]: General error: 1 near ">": syntax error. The SQL statement executed was: SELECT m1.id, m1.name AS text, m2.id IS NOT NULL AS hasChildren FROM tree AS m1 LEFT JOIN tree AS m2 ON m1.id=m2.parent_id WHERE m1.parent_id <=> NULL GROUP BY m1.id ORDER BY m1.name ASC (D:\AppServ\www\yii\framework\db\CDbCommand.php:516)

#0 D:\AppServ\www\yii\framework\db\CDbCommand.php(374): CDbCommand->queryInternal(‘fetchAll’, Array, Array)

#1 D:\AppServ\www\yii\prj\cbj\protected\controllers\SiteController.php(255): CDbCommand->queryAll()

#2 D:\AppServ\www\yii\framework\web\actions\CInlineAction.php(50): SiteController->actionAjaxFillTree()

#3 D:\AppServ\www\yii\framework\web\CController.php(300): CInlineAction->runWithParams(Array)

#4 D:\AppServ\www\yii\framework\web\CController.php(278): CController->runAction(Object(CInlineAction))

#5 D:\AppServ\www\yii\framework\web\CController.php(257): CController->runActionWithFilters(Object(CInlineAction), Array)

#6 D:\AppServ\www\yii\framework\web\CWebApplication.php(277): CController->run(‘ajaxfilltree’)

#7 D:\AppServ\www\yii\framework\web\CWebApplication.php(136): CWebApplication->runController(‘site/ajaxFillTr…’)

#8 D:\AppServ\www\yii\framework\base\CApplication.php(158): CWebApplication->processRequest()

#9 D:\AppServ\www\yii\prj\cbj\index.php(13): CApplication->run()

#10 {main}

use: sqlite3 and Yii Version 1.1.8

I do not understand the meaning of this syntax:

<=> $parentId

[macinville]

Hi… i tried but get error like:

use: sqlite3 and Yii Version 1.1.8

I do not understand the meaning of this syntax:

<=> $parentId

The explanation for ‘<=>’ is in the wiki page:

…

We suppose here that the corresponding nodes (the root nodes) have a parent_id set to NULL. In SQL, “=” can’t compare a value with NULL, so we have to use the <=> operator instead.

…

Probably an error when used with sqlite3? I’m tied to MySQL as of the moment, can’t test your scenario yet.

[macinville]

BTW,in my example given, I have provided a link to my base theme to retrieve the icons. If your tree does not need an icon, delete that part…it might just cause trouble if not.

[macinville]

I have finished creating an extension which extends to CTreeView and can create links with ease. It can handle both Nested Set and Adjacency List model, and can be used in AJAX calls too!

Extension page: MTreeView

Downloads: MTreeView.zip

Explanation: My Blog

This is the thread I created so can voice out your observations and comments and suggestions.

Edit: updated the links

[h3rm]

@macinville

thank you

[ostovar (Ostovarit)]

I have just write something about this. you can find solution here

hi

thanks … it’s work.

when data inserted to the database, how can i update CTreevie with Jquery (without refresh page)??

[chriscao (Labs Net)]

a great work, many thanks~

[macinville]

I have improved the extension so as to make it useful to more “tree-lovers”. Click here to be redirected to the extension’s discussion page.

[andromeda (Daney Andromeda)]

where,

if i call tree from three table??

[al_rahim (Arahimit)]

If I use oracle database then what should be the query to get treeview for the same example?