jQuery Grid Plugin - jqGridForum

24/12/2009
05:28

aristideau

Member

Members

Forum Posts: 11

Member Since:
26/05/2009

Offline

1

Hi,

I could not get the treegrid demo to work. Looking at the code (server.php?q=tree2) I found this SQL statement

SELECT account_id, name, acc_num, debit, credit, balance, level, lft, rgt FROM accounts WHERE 0=0 ORDER BY lft

I seem to be missing level, lft and rgt fields and values for this table.

I have search the forums for ltf and rgt and came up with zip

Does anyone have the sample data for treegrid?

regards

AA

26/12/2009
12:01

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

2

Hello,

Thanks will update the demo soon.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

29/12/2009
10:33

waiting

Member

Members

Forum Posts: 40

Member Since:
22/12/2008

Offline

3

here's mine,enjoy.

test.js:

var gridimgpath = '../css/theme/redmond/images';
$(document).ready(function(){
treeview();
});

}

29/12/2009
11:00

waiting

Member

Members

Forum Posts: 40

Member Since:
22/12/2008

Offline

4

i use PEAR:MDB2 for db connect

manage_column_aj.php:

function make_treecolum($db) {
    $nodeId = !isset($_POST['nodeid']) || intval($_POST['nodeid'])<1 ? 1 : intval($_POST['nodeid']);
    $deep = 3;    // can not less 2, or Duplicat root will be shown
    $res = get_column($nodeId, $deep, $db);
    if (!$res) {return false;}

    $count = count($res);
    $out = array('page'=>1, 'total'=>1, 'records'=>$count);
    foreach ($res as $row) {
        $colType = $row['sort_type'];
        if($row[rgt] == $row[lft]+1) {
            $leaf = true;
        }
        else {
            $leaf = false;
            $colType = 0;
        }

        $id = $row['id'];
        $name = $row['sort_name'];
        $ename = $row['sort_ename'];
        $image = $row['sort_pic'];

        $lvl = $row['level'];
        $lft = $row['lft'];
        $rgt = $row['rgt'];
        $shoInHeader = $row['isdispaly'];


        $expand = $lvl<$deep-1 ? TRUE : FALSE;


        $out['rows'][] = array('id'=>"$id",
            'cell'=>array($id, $name, $ename, $colType, $shoInHeader, $image, $lvl,
                    $image, $lvl, $lft, $rgt, $leaf, $expand)
        );
    }

   echo json_encode($out);
}

/**
* get Nested
*
* @param int $nodeId
* @param int $deep
* @return array
*/
function get_column($nodeId = 1, $deep = 3, $db) {

    $nodeId = $nodeId < 1 ? 1 : $nodeId;
    // detect if here we post the data from allready loaded tree
    // we can make here other checks

    if( $nodeId >1) {
        $node = get_columnInfo($nodeId);
        $n_lft = $node['lft'];
        $n_rgt = $node['rgt'];
        $n_lvl = $node['level'] + 1;

        $sql = 'SELECT * FROM tb_sort2 WHERE lft>' .$n_lft . ' AND lft<' .$n_rgt .' AND level=' .$n_lvl .' ORDER BY lft';
    }
    else {
        // initial grid
        $sql = 'SELECT * FROM tb_sort2 WHERE level<' .$deep .' ORDER BY lft';
    }
    $res = $db->queryAll($sql);
    $e = isMDB2Error($res);
    if ($e != false) {
        die('err');
    }
    else {
        return $res;
    }

}

29/12/2009
11:01

waiting

Member

Members

Forum Posts: 40

Member Since:
22/12/2008

Offline

5

database:

CREATE TABLE `tb_sort2` (
`id` int(11) unsigned NOT NULL auto_increment,
`lft` int(11) unsigned NOT NULL default '0' COMMENT 'Nested left_field',
`rgt` int(11) unsigned NOT NULL default '0' COMMENT 'Nested right_field',
`level` smallint(6) unsigned NOT NULL default '1' COMMENT 'Nested tree level',
`sort_name` varchar(255) default '',
`ctype` tinyint(1) unsigned default '0' COMMENT 'is PhotoNews Column',
`sort_type` tinyint(1) unsigned default '1' COMMENT 'display type:1-show newslists, 2-show news, 4-photo news',
`sort_url` varchar(100) default '',
`sort_ename` varchar(50) default '',
`isdispaly` tinyint(1) unsigned default '0' COMMENT '1-display in header menu',
`order_id` tinyint(4) unsigned NOT NULL default '255' COMMENT 'ASC max255 min1',
`sort_pic` varchar(255) default '',
`is_en` tinyint(1) unsigned default '0',
PRIMARY KEY (`id`),
KEY `rgt` (`rgt`),
KEY `lvl` (`level`),
KEY `lft_lvl` (`lft`,`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;