1. #71
    Ext User
    Join Date
    Dec 2007
    Posts
    9
    Vote Rating
    0
    pawelb1973 is on a distinguished road

      0  

    Default Remote Filter on Tree

    Remote Filter on Tree


    Recently I worked on a remote filter in the tree view.
    Local filter (eg such as TreeFilterX) for asynchronous tree freezes the browser and take over all the CPU resources available.
    My idea for the remote filtering is the following:
    1. search all the items in the SQL table 'tree' pattern matching
    2. search path for them
    3. of these paths build a tree and give it as a result of filtering

    Trick that still need to do, is change the parameters of the tree TreeLoader to add pattern to the query of filtered tree . The rest deals with server-side script (written in PHP for example) to handle the tree view.

    If anyone of you is interested in the PHP implementation can be made available (currently I am in preparation for the demo of this solution.)

  2. #72
    Sencha - Community Support Team jsakalos's Avatar
    Join Date
    Apr 2007
    Location
    Slovakia
    Posts
    27,520
    Vote Rating
    375
    jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future

      0  

    Default


    Would be interesting. Post it when you're done.
    Jozef Sakalos, aka Saki

    Education, extensions and services for developers at new http://extjs.eu
    News: Grid Search Plugin, ExtJS 5 Complex Data Binding using MVVM


  3. #73
    Ext User
    Join Date
    Dec 2007
    Posts
    9
    Vote Rating
    0
    pawelb1973 is on a distinguished road

      0  

    Default


    And Here is a demo of remote filtering on Tree. Just put 'remotetree.zip' in extjs examples directory and unzip. In SQL(MySQL) make table tree by this:
    PHP Code:
    CREATE TABLE IF NOT EXISTS `tree` (
      `
    idint(11NOT NULL auto_increment,
      `
    pidint(11NOT NULL,
      `
    textvarchar(255collate utf8_bin default NULL,
      `
    hrefvarchar(255collate utf8_bin default NULL,
      `
    iconClsvarchar(255collate utf8_bin default NULL,
      `
    iconvarchar(255collate utf8_bin default NULL,
      `
    disabledtinyint(4NOT NULL default '0',
      `
    leaftinyint(4NOT NULL default '0',
      `
    expandedtinyint(4NOT NULL default '0',
      
    PRIMARY KEY  (`id`)
    ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
    edit config.php file and browse to eg. http://127.0.0.1/ext-3.1.1/examples/...emotetree.html
    Should work.
    Don't forget to fullfill tree table some data to test wich method is the best - local or remote filtering.

    Of course, in this implementation, there are many shortcomings because it was written as prototype but not for production environment.
    By the way, where should I look for a class 'ctree'? It was used in 'proces-request.php' but this class not included in archive 'remotetree.zip' . Why?
    Attached Files

  4. #74
    Sencha - Community Support Team jsakalos's Avatar
    Join Date
    Apr 2007
    Location
    Slovakia
    Posts
    27,520
    Vote Rating
    375
    jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future

      0  

    Default


    Because ctree.php is proprietary software so I cannot publish it.
    Jozef Sakalos, aka Saki

    Education, extensions and services for developers at new http://extjs.eu
    News: Grid Search Plugin, ExtJS 5 Complex Data Binding using MVVM


  5. #75
    Ext User
    Join Date
    Dec 2007
    Posts
    9
    Vote Rating
    0
    pawelb1973 is on a distinguished road

      0  

    Default


    Thank You for reply. My first Idea was to build a tree from array that contains paths.
    But this idea seems to be difficult to do by client side ( browser).
    Server is much more quicker than client so imho this remote filter is a good for async tree with many nodes ( eg. over 2000) and levels.

    Did You already tested demo? Any tips?

    Off Topic question : Ctree class is a class for using with nested sets tree or other? Who is a author of this class and where ( website) can I found?

  6. #76
    Sencha - Community Support Team jsakalos's Avatar
    Join Date
    Apr 2007
    Location
    Slovakia
    Posts
    27,520
    Vote Rating
    375
    jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future

      0  

    Default


    Sorry, I didn't have time to test it. I'm the author of ctree.
    Jozef Sakalos, aka Saki

    Education, extensions and services for developers at new http://extjs.eu
    News: Grid Search Plugin, ExtJS 5 Complex Data Binding using MVVM


  7. #77
    Ext User
    Join Date
    Dec 2007
    Posts
    9
    Vote Rating
    0
    pawelb1973 is on a distinguished road

      0  

    Default


    Thank you for your reply. I hope that a solution to the remote filtering trees will be useful.

  8. #78
    Sencha - Community Support Team jsakalos's Avatar
    Join Date
    Apr 2007
    Location
    Slovakia
    Posts
    27,520
    Vote Rating
    375
    jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future jsakalos has a brilliant future

      0  

    Default


    I personally don't have such big trees at present but who knows...
    Jozef Sakalos, aka Saki

    Education, extensions and services for developers at new http://extjs.eu
    News: Grid Search Plugin, ExtJS 5 Complex Data Binding using MVVM


  9. #79
    Ext JS Premium Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    524
    Vote Rating
    29
    MrSparks has a spectacular aura about MrSparks has a spectacular aura about

      0  

    Default


    @Saki

    Have there been any updates since V1.0? http://remotetree.extjs.eu

    I've been trying to produce my own Filtered TreePanel for the last week (with partial success) however today came across your RemoteTree plug-in

    Are there any known performance issues on the amount of data displayed? i.e. if I were to list 5000 items under 1 node, how would the plug-in perform?

    Will definitely be making a donation once I've got it up and running.

    Great work and thanks for saving me a huge amount of time and effort!

  10. #80
    Ext User
    Join Date
    Dec 2007
    Posts
    9
    Vote Rating
    0
    pawelb1973 is on a distinguished road

      0  

    Default


    Hi
    How about Paging Tree. There is on the forum snippet and user extention of paging Tree.
    My solution for remote filter is for site those had a lot nodes ( parents and leafes). Recurection by client side depend on memory and CPU speed. In many cases, broser ( client side) will be hang 'cause computer resources is not enough to this task.
    Have a nice day,
    Pawel

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi