1. #211
    Sencha User
    Join Date
    Oct 2007
    Location
    Berlin, Germany
    Posts
    886
    Vote Rating
    8
    wm003 will become famous soon enough

      0  

    Default


    Quote Originally Posted by Bing Qiao View Post
    Is the source code of data_proxy.php still available? I couldn't find it anywhere.

    Thanks!
    Here's the code from March, don't know if it changed until now...
    PHP Code:
    <?php 
    /** 
     * 73 lines of license free PHP basics. 
     * 
     *  
     * @author Thorsten Suckow-Homberg <ts@siteartwork.de> 
     */ 


    // +---------------------------------------------------------------------------- 
    // | Connection settings. Adjust the following lines (see "livegrid.sql"). 
    // +---------------------------------------------------------------------------- 
        
    $host     "localhost"
        
    $user     "root";    
        
    $password ""
        
    $database "livegrid"
        
    $table    "livegrid"

         
    // +---------------------------------------------------------------------------- 
    // | Query stuff. As long as everything works fine, you can ignore the following 
    // | lines. Scroll down to the part where the json encoding happens... 
    // | WARNING: Script does not check for valid POST vars... 
    // +---------------------------------------------------------------------------- 
        
    $conn mysql_connect($host$user$password); 
        
    mysql_select_db($database$conn); 
         
        
    $sql2 "SELECT COUNT(id) AS count_id FROM $table"
        
    $res2 mysql_query($sql2); 
         
        
    $row2 mysql_fetch_assoc($res2); 
         
        
    $length $row2['count_id']; 
         
        
    $feeds = array('response' => array( 
            
    'value' => array() 
        ));          

        
    $sql "SELECT * FROM $table ORDER BY ".$_POST['sort']." ".$_POST['dir']. 
               
    " LIMIT ".$_POST['start'].",".$_POST['limit']; 
                
        
    $res mysql_query($sql); 
                                             
        while ((
    $row mysql_fetch_assoc($res))) { 
            
    $feeds['response']['value']['items'][] = array( 
               
    'id'            => $row['id'], 
               
    'number_field'  => $row['number_field'], 
               
    'string_field'  => $row['string_field'], 
               
    'date_field'    => $row['date_field'
            );   
        } 
         
        if (!isset(
    $feeds['response']['value']['items'])) { 
            
    $feeds['response']['value']['items'] = array(); 
        } 
         
        
    $feeds['response']['value']['total_count'] = $length;                                           
        
    $feeds['response']['value']['version']     = 1;                                           
         
    // +---------------------------------------------------------------------------- 
    // | You need to json_encode the array. If your PHP installation does not support 
    // | json_encode, go and get the Zend Framework at http://framework.zend.com, 
    // | which provides userland json encoding/decoding logic. 
    // +----------------------------------------------------------------------------     
        
    if (function_exists('json_encode')) { 
            
    $json json_encode($feeds); 
        } else { 
            require_once 
    'Zend/Json.php'
            
    $json Zend_Json::encode($feeds); 
        } 
          
        echo 
    $json;         
    ?>

  2. #212
    Ext User
    Join Date
    Jun 2008
    Posts
    18
    Vote Rating
    0
    xenon is on a distinguished road

      0  

    Default


    As i was looking at data_proxy.php source, I notice that the answer to my question is already answered. thanks wm003 for posting. and thanks mindpatterns for the great ext.

  3. #213
    Ext User
    Join Date
    Mar 2008
    Location
    Debin, Souf Efrika
    Posts
    17
    Vote Rating
    0
    ub3rn00b is on a distinguished road

      0  

    Default


    Quote Originally Posted by xenon View Post
    hi, im new on extjs and nice work mindpatterns, by the way to all, is it possible to set limit on Ext.ux.grid.BufferedStore proxy? My problem is, im loading 15000+ records with 10 columns so it loads about more than 30 seconds, my objective is to load only the desired data to minimize the processing time... below is an example of what i want to do.

    First Load:
    Code:
    var bufferedDataStore = new Ext.ux.grid.BufferedStore({
                autoLoad       : true,
                bufferSize     : 300,
                reader         : bufferedReader,
                url            : 'email-proxy.php?start=0&limit=100'
            });
    Scroll Down:
    Code:
    var bufferedDataStore = new Ext.ux.grid.BufferedStore({
                autoLoad       : true,
                bufferSize     : 300,
                reader         : bufferedReader,
                url            : 'email-proxy.php?start=100&limit=200'
            });
    any brilliant ideas?
    Am also looking for someway to do something similar, so I can hook up some filtering into the grid

  4. #214
    Ext User
    Join Date
    Jun 2008
    Posts
    18
    Vote Rating
    0
    xenon is on a distinguished road

      0  

    Default


    Quote Originally Posted by ub3rn00b View Post
    Am also looking for someway to do something similar, so I can hook up some filtering into the grid
    great, just keep us posted if you found a way.

  5. #215
    Ext User
    Join Date
    Mar 2008
    Location
    Debin, Souf Efrika
    Posts
    17
    Vote Rating
    0
    ub3rn00b is on a distinguished road

      0  

    Default


    Quote Originally Posted by xenon View Post
    great, just keep us posted if you found a way.
    Will do

  6. #216
    Ext User
    Join Date
    Jun 2008
    Posts
    3
    Vote Rating
    0
    tmaung is on a distinguished road

      0  

    Default


    Quote Originally Posted by xenon View Post
    hi, im new on extjs and nice work mindpatterns, by the way to all, is it possible to set limit on Ext.ux.grid.BufferedStore proxy? My problem is, im loading 15000+ records with 10 columns so it loads about more than 30 seconds, my objective is to load only the desired data to minimize the processing time... below is an example of what i want to do.

    First Load:
    Code:
    var bufferedDataStore = new Ext.ux.grid.BufferedStore({
                autoLoad       : true,
                bufferSize     : 300,
                reader         : bufferedReader,
                url            : 'email-proxy.php?start=0&limit=100'
            });
    Scroll Down:
    Code:
    var bufferedDataStore = new Ext.ux.grid.BufferedStore({
                autoLoad       : true,
                bufferSize     : 300,
                reader         : bufferedReader,
                url            : 'email-proxy.php?start=100&limit=200'
            });
    any brilliant ideas?
    Here's what gets sent to the server using POST
    Code:
    dir: ASC
    asc: col
    limit: 300
    start: 0
    As you scroll down, another POST:
    Code:
    dir: ASC
    asc: col
    limit: 300
    start: 285
    So what you could do at the server-side script is to have:
    Code:
    start = $POST['start'];
    end = start + $POST['limit'];
    You don't even have to include all that GET request in the URL. It always sends the buffer size and also the predicted start index so you just use those request parameters to figure out your start and end. If it is about the time it takes to acquire the data, then set the buffersize smaller and also the nearlimit to a value between 1/2 and 1/3 of the buffersize. Please ignore my syntax above because I haven't worked with PHP in a long time.

    My answer is based on what I think you are trying to ask. If you only want certain definite ranges instead of predicted ranges, then the best bet is the paging grid. What would happen if you are viewing records 95-105? Hope it helps.

  7. #217
    Sencha User
    Join Date
    Feb 2008
    Location
    Turin, Italy
    Posts
    13
    Vote Rating
    0
    c.barca is on a distinguished road

      0  

    Post BufferedDataStore & GroupingStore

    BufferedDataStore & GroupingStore


    Hi all,
    I would use the grouping store for group my records.
    It's possible use the magical BufferedDataStore togheter GroupingStore?
    If yes, how to use ?

    Thank you for your precious effort.

    All the best

    Claudio

  8. #218
    Sencha - Training Team RWaters's Avatar
    Join Date
    Mar 2007
    Location
    Los Angeles, CA
    Posts
    714
    Vote Rating
    0
    RWaters is on a distinguished road

      0  

    Default


    This hasn't been thoroughly tested (That's what the community is for, right? :P), though I figured there may be some interest. I've added some additional keyNav handlers to the bufferedRowSelectionModel to go along with the up and down arrows that it gets from extending the standard RowSelectionModel

    An updated version of this is posted below
    Code:
    Index: BufferedRowSelectionModel.js
    ===================================================================
    --- BufferedRowSelectionModel.js	(revision 741)
    +++ BufferedRowSelectionModel.js	(working copy)
    @@ -47,6 +47,46 @@
             
             this.grid.store.on('add',            this.onAdd,            this);
             this.grid.store.on('selectionsload', this.onSelectionsLoad, this);
    +        
    +        this.pgRowNav = new Ext.KeyNav(this.grid.getGridEl(), {
    +			"pageUp" : function(e) {
    +				var vw = this.grid.getView();
    +				if (this.lastActive !== false) {
    +					if (e.shiftKey && this.last !== false) {
    +						var last = this.last;
    +						this.selectRange(this.last, this.lastActive
    +								- vw.visibleRows);
    +						if (last !== false) {
    +							this.last = last;
    +						}
    +					} else {
    +						this.selectRow(this.lastActive - vw.visibleRows);
    +					}
    +					vw.focusRow(this.lastActive);
    +				} else {
    +					this.selectFirstRow();
    +				}
    +			},
    +			"pageDown" : function(e) {
    +				var vw = this.grid.getView();
    +				if (this.lastActive !== false) {
    +					if (e.shiftKey && this.last !== false) {
    +						var last = this.last;
    +						this.selectRange(this.last, this.lastActive
    +								+ vw.visibleRows);
    +						if (last !== false) {
    +							this.last = last;
    +						}
    +					} else {
    +						this.selectRow(this.lastActive + vw.visibleRows);
    +					}
    +					vw.focusRow(this.lastActive);
    +				} else {
    +					this.selectFirstRow();
    +				}
    +			},
    +			scope : this
    +		});
         },

  9. #219
    Sencha User
    Join Date
    Mar 2008
    Posts
    64
    Vote Rating
    0
    srikanthnukala is on a distinguished road

      0  

    Question how do we send params/filters

    how do we send params/filters


    Hello,

    i have filters and when i click on a button, the live grid should reload everything with these filters.

    Code:
    this.bufferedDataStore.on('beforeload',this.beforeLoad,this);
    this.on('filterApplied',this.applyFilters,this);
    
    
    beforeLoad: function(st,t,p,k){
    		console.log('called before load');
    		st.custParams = {
    			entity: 'srikanth'				
    		};
    		debugger;
    	
    	},
    	applyFilters: function(){		
    		console.log('apply filters');
    		this.entityId = 'asdfasdf';
    		this.bufferedDataStore.reload();
    	},
    How do i manipulate the params being sent for reload request to add filters?
    Sri

  10. #220
    Sencha User
    Join Date
    Mar 2008
    Posts
    64
    Vote Rating
    0
    srikanthnukala is on a distinguished road

      0  

    Talking


    params and filters in live grid.

    I am able to apply the parameters :

    Code:
    onBeforeLoad : function(store, options)
        {
        	
            if (!options.params) {
                options.params = {start : 0, limit : this.ds.bufferSize};    
            } else {
                options.params.start = 0;
                options.params.limit = this.ds.bufferSize;
            }
            
            
            if(this.filters){
            	console.dir(this.filters);
            	Ext.apply(options.params, this.filters);        	
            }
            
            options.scope    = this;
            options.callback = function(){this.reset(false);};
            
            return true;
        },
    inside the grid component beforeLoad of buffered store, set this.bufferedView.filters = { //params/filters u want to send}
    Sri

Thread Participants: 248

  1. JeffHowden (1 Post)
  2. Animal (4 Posts)
  3. rodiniz (1 Post)
  4. galdaka (2 Posts)
  5. mdissel (1 Post)
  6. Wolfgang (1 Post)
  7. zzo (2 Posts)
  8. Frank (1 Post)
  9. herve (2 Posts)
  10. ericd (2 Posts)
  11. RWaters (5 Posts)
  12. Digital God (1 Post)
  13. Dumbledore (11 Posts)
  14. KimH (1 Post)
  15. pjordan (1 Post)
  16. cpantel (1 Post)
  17. mystix (3 Posts)
  18. wanclark (1 Post)
  19. MD (3 Posts)
  20. drew (1 Post)
  21. jheid (15 Posts)
  22. tsprague (1 Post)
  23. Confused (2 Posts)
  24. thesilentman (1 Post)
  25. andreas.linde (1 Post)
  26. violinista (1 Post)
  27. redxiii (1 Post)
  28. akannu (1 Post)
  29. theo (1 Post)
  30. Troy Wolf (3 Posts)
  31. chh (4 Posts)
  32. Phenothiasine (1 Post)
  33. danh2000 (1 Post)
  34. tobiu (1 Post)
  35. badgerd (1 Post)
  36. mlarese (1 Post)
  37. pluesch0r (1 Post)
  38. krycek (1 Post)
  39. gtaylor (4 Posts)
  40. ftftft (1 Post)
  41. hallikpapa (7 Posts)
  42. tech-nova (1 Post)
  43. provagino (1 Post)
  44. mjlecomte (2 Posts)
  45. iancmcc (1 Post)
  46. andrei.neculau (7 Posts)
  47. zieli1 (1 Post)
  48. meteorbites (1 Post)
  49. brookd (3 Posts)
  50. alexpetri (1 Post)
  51. urskipfer (1 Post)
  52. JEBriggs (1 Post)
  53. magunes117 (6 Posts)
  54. shiweiwei97 (3 Posts)
  55. vpell (1 Post)
  56. gelleneu (4 Posts)
  57. ohhowihateie (2 Posts)
  58. Andrewd2 (1 Post)
  59. Jacob (1 Post)
  60. cherbert (2 Posts)
  61. DragonFist (1 Post)
  62. marcoas (1 Post)
  63. Shmoo (1 Post)
  64. GraemeBryce (1 Post)
  65. w011117 (1 Post)
  66. luxxxian (1 Post)
  67. loverofdream (1 Post)
  68. lvanderree (1 Post)
  69. robw (1 Post)
  70. SeaSharp (1 Post)
  71. xpressive (1 Post)
  72. jeremia (1 Post)
  73. wm003 (21 Posts)
  74. miti (1 Post)
  75. sfrancolla (1 Post)
  76. Blob (1 Post)
  77. WoLpH (5 Posts)
  78. khatuido (3 Posts)
  79. zacware (3 Posts)
  80. mepfuso (2 Posts)
  81. wasp (1 Post)
  82. sharpguy (1 Post)
  83. stevets (1 Post)
  84. fred (1 Post)
  85. eliasp (3 Posts)
  86. h0tzenpl0tz (1 Post)
  87. tonedeaf (1 Post)
  88. Zolcsi (3 Posts)
  89. dearsina (1 Post)
  90. efattal (3 Posts)
  91. franck34 (3 Posts)
  92. tyr (1 Post)
  93. cybertaz (1 Post)
  94. zergworld (8 Posts)
  95. sekundek (1 Post)
  96. cs_alpha (3 Posts)
  97. Sultanalifezar (3 Posts)
  98. emily (7 Posts)
  99. jwendt@iscinternational.com (1 Post)
  100. sinma (1 Post)
  101. ItsMee (3 Posts)
  102. Nic (1 Post)
  103. sksoft (4 Posts)
  104. mjhaston (1 Post)
  105. mattb (4 Posts)
  106. jenner (1 Post)
  107. 2le (1 Post)
  108. bluefeet (1 Post)
  109. PremiereGlobal (2 Posts)
  110. rtozati (1 Post)
  111. KirkOlson (4 Posts)
  112. False Maria (1 Post)
  113. jbd007 (5 Posts)
  114. c.barca (1 Post)
  115. nctag (34 Posts)
  116. kfironit123 (1 Post)
  117. Emt (1 Post)
  118. ub3rn00b (12 Posts)
  119. Ballsacian1 (1 Post)
  120. mprice (1 Post)
  121. srikanthnukala (2 Posts)
  122. Mots (2 Posts)
  123. yhwh (1 Post)
  124. el777 (1 Post)
  125. JoomlaMan (1 Post)
  126. sanjivank (1 Post)
  127. sdetweil (1 Post)
  128. Snakehit (1 Post)
  129. msynovic (2 Posts)
  130. Snuyt (1 Post)
  131. as (2 Posts)
  132. pkmiec (2 Posts)
  133. epoks (2 Posts)
  134. NoahK17 (1 Post)
  135. praneeth528 (2 Posts)
  136. bemn (1 Post)
  137. Remy (1 Post)
  138. Daniel_Brazil_Campinas (1 Post)
  139. freddyk (4 Posts)
  140. dshorthouse (1 Post)
  141. dahman7 (1 Post)
  142. Canard64 (1 Post)
  143. dkuz (2 Posts)
  144. xsuniwov (1 Post)
  145. neha.chopra (1 Post)
  146. Eric24 (2 Posts)
  147. Mandeep (2 Posts)
  148. ttbgwt (6 Posts)
  149. suzan (1 Post)
  150. tenthcup (5 Posts)
  151. excelsis (5 Posts)
  152. DaveBrewster (6 Posts)
  153. rusty124 (1 Post)
  154. bcmatz (3 Posts)
  155. bjcullinan (1 Post)
  156. sstratton (4 Posts)
  157. Scorpie (1 Post)
  158. supercharge2 (3 Posts)
  159. Bing Qiao (6 Posts)
  160. tmaung (1 Post)
  161. xenon (4 Posts)
  162. sureaintme (5 Posts)
  163. animeshsingh (2 Posts)
  164. NicoP (29 Posts)
  165. cyfl (2 Posts)
  166. simplessus (1 Post)
  167. imnphd (1 Post)
  168. mono blaine (5 Posts)
  169. Kango_V (5 Posts)
  170. cain06 (1 Post)
  171. charak (2 Posts)
  172. vayumahesh (1 Post)
  173. Gabor Turi (1 Post)
  174. daeghran (2 Posts)
  175. maceido (5 Posts)
  176. sgoswami (1 Post)
  177. rubaiz (1 Post)
  178. Jabe (1 Post)
  179. ecarrenho (1 Post)
  180. mpereira (1 Post)
  181. changhua (4 Posts)
  182. alexw23 (1 Post)
  183. fxmisticat (5 Posts)
  184. extjssiva (1 Post)
  185. f1xxx3r (1 Post)
  186. SimoAmi (1 Post)
  187. aj3423 (1 Post)
  188. kkothari (2 Posts)
  189. jmariani (28 Posts)
  190. ibet (3 Posts)
  191. SunWuKung (1 Post)
  192. micgala (2 Posts)
  193. inptisto (1 Post)
  194. TheColonel (1 Post)
  195. cdeguzman (1 Post)
  196. ektanit (6 Posts)
  197. James Wang (1 Post)
  198. PCBingoB (1 Post)
  199. flylaputa (1 Post)
  200. MacSimon (1 Post)
  201. pibree (2 Posts)
  202. Markus (1 Post)
  203. aleister999 (2 Posts)
  204. adamli (2 Posts)
  205. jmaisel (4 Posts)
  206. pdugas (1 Post)
  207. plaak (1 Post)
  208. coriolis (2 Posts)
  209. weazil (4 Posts)
  210. fwiethof (1 Post)
  211. meroy (19 Posts)
  212. lxf1101 (2 Posts)
  213. stephen.friedrich (3 Posts)
  214. vinepod (1 Post)
  215. yuriy (2 Posts)
  216. completej (1 Post)
  217. dan_jf (1 Post)
  218. harel (2 Posts)
  219. veenvliet.morion (2 Posts)
  220. yura620310 (1 Post)
  221. barncat (1 Post)
  222. DmitrySistor (2 Posts)
  223. pclovec (3 Posts)
  224. Ranma13 (1 Post)
  225. swang (4 Posts)
  226. calugaru.cristian (5 Posts)
  227. mohan_b (1 Post)
  228. karlsnyder0 (2 Posts)
  229. JimmyInMD (2 Posts)
  230. tolitius (1 Post)
  231. a.labeau (2 Posts)
  232. benjixx (1 Post)
  233. psm1963 (1 Post)
  234. sosy (1 Post)
  235. nosferatum (9 Posts)
  236. daddie888 (1 Post)
  237. ixvivxi (1 Post)
  238. dp814082 (1 Post)
  239. nickelj (4 Posts)
  240. wifi4psp (1 Post)
  241. drian (1 Post)
  242. su-aska (1 Post)
  243. SebTardif (1 Post)
  244. danceric (1 Post)
  245. DTSman (1 Post)
  246. brian.moeskau (1 Post)
  247. Neethi (2 Posts)
  248. sango (1 Post)

film izle

hd film izle

film sitesi

takipci kazanma sitesi

takipci kazanma sitesi

güzel olan herşey

takipci alma sitesi

komik eğlenceli videolar