Doctrine_Tree_NestedSet.html 43 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
<html>
    <head>
        <title>Coverage for Doctrine_Tree_NestedSet</title>
        <style type="text/css">
            .covered{ background: green;}
            .normal{ background: white;}
            .red{ background: red;}
            .orange{ background: #f90;}
       </style>
</head>
<body><h1>Coverage for Doctrine_Tree_NestedSet</h1><p><a href="index.php">Back to coverage report</a></p><table>
<tr><td>1</td>
<td class="normal">&lt;?php
</td></tr>
<tr><td>2</td>
<td class="normal">/*
</td></tr>
<tr><td>3</td>
meus's avatar
meus committed
19
<td class="normal">&nbsp;*&nbsp;&nbsp;$Id:&nbsp;NestedSet.php&nbsp;3144&nbsp;2007-11-13&nbsp;15:52:45Z&nbsp;romanb&nbsp;$
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
</td></tr>
<tr><td>4</td>
<td class="normal">&nbsp;*
</td></tr>
<tr><td>5</td>
<td class="normal">&nbsp;*&nbsp;THIS&nbsp;SOFTWARE&nbsp;IS&nbsp;PROVIDED&nbsp;BY&nbsp;THE&nbsp;COPYRIGHT&nbsp;HOLDERS&nbsp;AND&nbsp;CONTRIBUTORS
</td></tr>
<tr><td>6</td>
<td class="normal">&nbsp;*&nbsp;&quot;AS&nbsp;IS&quot;&nbsp;AND&nbsp;ANY&nbsp;EXPRESS&nbsp;OR&nbsp;IMPLIED&nbsp;WARRANTIES,&nbsp;INCLUDING,&nbsp;BUT&nbsp;NOT
</td></tr>
<tr><td>7</td>
<td class="normal">&nbsp;*&nbsp;LIMITED&nbsp;TO,&nbsp;THE&nbsp;IMPLIED&nbsp;WARRANTIES&nbsp;OF&nbsp;MERCHANTABILITY&nbsp;AND&nbsp;FITNESS&nbsp;FOR
</td></tr>
<tr><td>8</td>
<td class="normal">&nbsp;*&nbsp;A&nbsp;PARTICULAR&nbsp;PURPOSE&nbsp;ARE&nbsp;DISCLAIMED.&nbsp;IN&nbsp;NO&nbsp;EVENT&nbsp;SHALL&nbsp;THE&nbsp;COPYRIGHT
</td></tr>
<tr><td>9</td>
<td class="normal">&nbsp;*&nbsp;OWNER&nbsp;OR&nbsp;CONTRIBUTORS&nbsp;BE&nbsp;LIABLE&nbsp;FOR&nbsp;ANY&nbsp;DIRECT,&nbsp;INDIRECT,&nbsp;INCIDENTAL,
</td></tr>
<tr><td>10</td>
<td class="normal">&nbsp;*&nbsp;SPECIAL,&nbsp;EXEMPLARY,&nbsp;OR&nbsp;CONSEQUENTIAL&nbsp;DAMAGES&nbsp;(INCLUDING,&nbsp;BUT&nbsp;NOT
</td></tr>
<tr><td>11</td>
<td class="normal">&nbsp;*&nbsp;LIMITED&nbsp;TO,&nbsp;PROCUREMENT&nbsp;OF&nbsp;SUBSTITUTE&nbsp;GOODS&nbsp;OR&nbsp;SERVICES;&nbsp;LOSS&nbsp;OF&nbsp;USE,
</td></tr>
<tr><td>12</td>
<td class="normal">&nbsp;*&nbsp;DATA,&nbsp;OR&nbsp;PROFITS;&nbsp;OR&nbsp;BUSINESS&nbsp;INTERRUPTION)&nbsp;HOWEVER&nbsp;CAUSED&nbsp;AND&nbsp;ON&nbsp;ANY
</td></tr>
<tr><td>13</td>
<td class="normal">&nbsp;*&nbsp;THEORY&nbsp;OF&nbsp;LIABILITY,&nbsp;WHETHER&nbsp;IN&nbsp;CONTRACT,&nbsp;STRICT&nbsp;LIABILITY,&nbsp;OR&nbsp;TORT
</td></tr>
<tr><td>14</td>
<td class="normal">&nbsp;*&nbsp;(INCLUDING&nbsp;NEGLIGENCE&nbsp;OR&nbsp;OTHERWISE)&nbsp;ARISING&nbsp;IN&nbsp;ANY&nbsp;WAY&nbsp;OUT&nbsp;OF&nbsp;THE&nbsp;USE
</td></tr>
<tr><td>15</td>
<td class="normal">&nbsp;*&nbsp;OF&nbsp;THIS&nbsp;SOFTWARE,&nbsp;EVEN&nbsp;IF&nbsp;ADVISED&nbsp;OF&nbsp;THE&nbsp;POSSIBILITY&nbsp;OF&nbsp;SUCH&nbsp;DAMAGE.
</td></tr>
<tr><td>16</td>
<td class="normal">&nbsp;*
</td></tr>
<tr><td>17</td>
<td class="normal">&nbsp;*&nbsp;This&nbsp;software&nbsp;consists&nbsp;of&nbsp;voluntary&nbsp;contributions&nbsp;made&nbsp;by&nbsp;many&nbsp;individuals
</td></tr>
<tr><td>18</td>
<td class="normal">&nbsp;*&nbsp;and&nbsp;is&nbsp;licensed&nbsp;under&nbsp;the&nbsp;LGPL.&nbsp;For&nbsp;more&nbsp;information,&nbsp;see
</td></tr>
<tr><td>19</td>
67
<td class="normal">&nbsp;*&nbsp;&lt;http://www.phpdoctrine.org&gt;.
68 69 70 71 72
</td></tr>
<tr><td>20</td>
<td class="normal">&nbsp;*/
</td></tr>
<tr><td>21</td>
73
<td class="normal">
74 75
</td></tr>
<tr><td>22</td>
76
<td class="normal">/**
77 78
</td></tr>
<tr><td>23</td>
79
<td class="normal">&nbsp;*&nbsp;Doctrine_Tree_NestedSet
80 81
</td></tr>
<tr><td>24</td>
82
<td class="normal">&nbsp;*
83 84
</td></tr>
<tr><td>25</td>
85
<td class="normal">&nbsp;*&nbsp;@package&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Doctrine
86 87
</td></tr>
<tr><td>26</td>
88
<td class="normal">&nbsp;*&nbsp;@subpackage&nbsp;&nbsp;Tree
89 90
</td></tr>
<tr><td>27</td>
91
<td class="normal">&nbsp;*&nbsp;@license&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;http://www.opensource.org/licenses/lgpl-license.php&nbsp;LGPL
92 93
</td></tr>
<tr><td>28</td>
94
<td class="normal">&nbsp;*&nbsp;@link&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;www.phpdoctrine.org
95 96
</td></tr>
<tr><td>29</td>
97
<td class="normal">&nbsp;*&nbsp;@since&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.0
98 99
</td></tr>
<tr><td>30</td>
meus's avatar
meus committed
100
<td class="normal">&nbsp;*&nbsp;@version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$Revision:&nbsp;3144&nbsp;$
101 102
</td></tr>
<tr><td>31</td>
103
<td class="normal">&nbsp;*&nbsp;@author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joe&nbsp;Simms&nbsp;&lt;joe.simms@websites4.com&gt;
104 105
</td></tr>
<tr><td>32</td>
106
<td class="normal">&nbsp;*/
107 108
</td></tr>
<tr><td>33</td>
109
<td class="covered">class&nbsp;Doctrine_Tree_NestedSet&nbsp;extends&nbsp;Doctrine_Tree&nbsp;implements&nbsp;Doctrine_Tree_Interface
110 111
</td></tr>
<tr><td>34</td>
112
<td class="normal">{
113 114
</td></tr>
<tr><td>35</td>
115
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;$_baseQuery;
116 117
</td></tr>
<tr><td>36</td>
118
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;$_baseAlias&nbsp;=&nbsp;&quot;base&quot;;
119 120
</td></tr>
<tr><td>37</td>
121
<td class="normal">
122 123
</td></tr>
<tr><td>38</td>
124
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
125 126
</td></tr>
<tr><td>39</td>
127
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;constructor,&nbsp;creates&nbsp;tree&nbsp;with&nbsp;reference&nbsp;to&nbsp;table&nbsp;and&nbsp;sets&nbsp;default&nbsp;root&nbsp;options
128 129
</td></tr>
<tr><td>40</td>
130
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
131 132
</td></tr>
<tr><td>41</td>
133
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;object&nbsp;$table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;instance&nbsp;of&nbsp;Doctrine_Table
134 135
</td></tr>
<tr><td>42</td>
136
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;array&nbsp;$options&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;options
137 138
</td></tr>
<tr><td>43</td>
139
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
140 141
</td></tr>
<tr><td>44</td>
142
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;__construct(Doctrine_Table&nbsp;$table,&nbsp;$options)
143 144
</td></tr>
<tr><td>45</td>
145
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
146 147
</td></tr>
<tr><td>46</td>
148
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;set&nbsp;default&nbsp;many&nbsp;root&nbsp;attributes
149 150
</td></tr>
<tr><td>47</td>
151
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$options['hasManyRoots']&nbsp;=&nbsp;isset($options['hasManyRoots'])&nbsp;?&nbsp;$options['hasManyRoots']&nbsp;:&nbsp;false;
152 153
</td></tr>
<tr><td>48</td>
meus's avatar
meus committed
154
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($options['hasManyRoots'])&nbsp;{
155 156
</td></tr>
<tr><td>49</td>
meus's avatar
meus committed
157
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$options['rootColumnName']&nbsp;=&nbsp;isset($options['rootColumnName'])&nbsp;?&nbsp;$options['rootColumnName']&nbsp;:&nbsp;'root_id';
158 159
</td></tr>
<tr><td>50</td>
meus's avatar
meus committed
160
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
161 162
</td></tr>
<tr><td>51</td>
meus's avatar
meus committed
163
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
164 165
</td></tr>
<tr><td>52</td>
meus's avatar
meus committed
166
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parent::__construct($table,&nbsp;$options);
167 168
</td></tr>
<tr><td>53</td>
meus's avatar
meus committed
169
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;}
170 171
</td></tr>
<tr><td>54</td>
meus's avatar
meus committed
172
<td class="normal">
173 174
</td></tr>
<tr><td>55</td>
meus's avatar
meus committed
175
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
176 177
</td></tr>
<tr><td>56</td>
meus's avatar
meus committed
178
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;used&nbsp;to&nbsp;define&nbsp;table&nbsp;attributes&nbsp;required&nbsp;for&nbsp;the&nbsp;NestetSet&nbsp;implementation
179 180
</td></tr>
<tr><td>57</td>
meus's avatar
meus committed
181
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;adds&nbsp;lft&nbsp;and&nbsp;rgt&nbsp;columns&nbsp;for&nbsp;corresponding&nbsp;left&nbsp;and&nbsp;right&nbsp;values
182 183
</td></tr>
<tr><td>58</td>
meus's avatar
meus committed
184
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
185 186
</td></tr>
<tr><td>59</td>
meus's avatar
meus committed
187
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
188 189
</td></tr>
<tr><td>60</td>
meus's avatar
meus committed
190
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;setTableDefinition()
191 192
</td></tr>
<tr><td>61</td>
meus's avatar
meus committed
193
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
194 195
</td></tr>
<tr><td>62</td>
meus's avatar
meus committed
196
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($root&nbsp;=&nbsp;$this-&gt;getAttribute('rootColumnName'))&nbsp;{
197 198
</td></tr>
<tr><td>63</td>
meus's avatar
meus committed
199
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;table-&gt;setColumn($root,&nbsp;'integer',&nbsp;4);
200 201
</td></tr>
<tr><td>64</td>
meus's avatar
meus committed
202
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
203 204
</td></tr>
<tr><td>65</td>
meus's avatar
meus committed
205
<td class="normal">
206 207
</td></tr>
<tr><td>66</td>
meus's avatar
meus committed
208
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;table-&gt;setColumn('lft',&nbsp;'integer',&nbsp;4);
209 210
</td></tr>
<tr><td>67</td>
meus's avatar
meus committed
211
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;table-&gt;setColumn('rgt',&nbsp;'integer',&nbsp;4);
212 213
</td></tr>
<tr><td>68</td>
meus's avatar
meus committed
214
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;table-&gt;setColumn('level',&nbsp;'integer',&nbsp;2);
215 216
</td></tr>
<tr><td>69</td>
meus's avatar
meus committed
217
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;}
218 219
</td></tr>
<tr><td>70</td>
meus's avatar
meus committed
220
<td class="normal">
221 222
</td></tr>
<tr><td>71</td>
meus's avatar
meus committed
223
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
224 225
</td></tr>
<tr><td>72</td>
meus's avatar
meus committed
226
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;creates&nbsp;root&nbsp;node&nbsp;from&nbsp;given&nbsp;record&nbsp;or&nbsp;from&nbsp;a&nbsp;new&nbsp;record
227 228
</td></tr>
<tr><td>73</td>
meus's avatar
meus committed
229
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
230 231
</td></tr>
<tr><td>74</td>
meus's avatar
meus committed
232
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;object&nbsp;$record&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;instance&nbsp;of&nbsp;Doctrine_Record
233 234
</td></tr>
<tr><td>75</td>
meus's avatar
meus committed
235
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
236 237
</td></tr>
<tr><td>76</td>
meus's avatar
meus committed
238
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;createRoot(Doctrine_Record&nbsp;$record&nbsp;=&nbsp;null)
239 240
</td></tr>
<tr><td>77</td>
meus's avatar
meus committed
241
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
242 243
</td></tr>
<tr><td>78</td>
meus's avatar
meus committed
244
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;!&nbsp;$record)&nbsp;{
245 246
</td></tr>
<tr><td>79</td>
meus's avatar
meus committed
247
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record&nbsp;=&nbsp;$this-&gt;table-&gt;create();
248 249
</td></tr>
<tr><td>80</td>
meus's avatar
meus committed
250
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
251 252
</td></tr>
<tr><td>81</td>
meus's avatar
meus committed
253
<td class="normal">
254 255
</td></tr>
<tr><td>82</td>
meus's avatar
meus committed
256
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;tree&nbsp;is&nbsp;many&nbsp;roots,&nbsp;and&nbsp;no&nbsp;root&nbsp;id&nbsp;has&nbsp;been&nbsp;set,&nbsp;then&nbsp;get&nbsp;next&nbsp;root&nbsp;id
257 258
</td></tr>
<tr><td>83</td>
meus's avatar
meus committed
259
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($root&nbsp;=&nbsp;$this-&gt;getAttribute('hasManyRoots')&nbsp;&amp;&amp;&nbsp;$record-&gt;getNode()-&gt;getRootValue()&nbsp;&lt;=&nbsp;0)&nbsp;{
260 261
</td></tr>
<tr><td>84</td>
meus's avatar
meus committed
262
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record-&gt;getNode()-&gt;setRootValue($this-&gt;getNextRootId());
263 264
</td></tr>
<tr><td>85</td>
meus's avatar
meus committed
265
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
266 267
</td></tr>
<tr><td>86</td>
meus's avatar
meus committed
268
<td class="normal">
269 270
</td></tr>
<tr><td>87</td>
meus's avatar
meus committed
271
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record-&gt;set('lft',&nbsp;'1');
272 273
</td></tr>
<tr><td>88</td>
meus's avatar
meus committed
274
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record-&gt;set('rgt',&nbsp;'2');
275 276
</td></tr>
<tr><td>89</td>
meus's avatar
meus committed
277
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record-&gt;set('level',&nbsp;0);
278 279
</td></tr>
<tr><td>90</td>
meus's avatar
meus committed
280
<td class="normal">
281 282
</td></tr>
<tr><td>91</td>
meus's avatar
meus committed
283
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record-&gt;save();
284 285
</td></tr>
<tr><td>92</td>
meus's avatar
meus committed
286
<td class="normal">
287 288
</td></tr>
<tr><td>93</td>
meus's avatar
meus committed
289
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$record;
290 291
</td></tr>
<tr><td>94</td>
meus's avatar
meus committed
292
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
293 294
</td></tr>
<tr><td>95</td>
meus's avatar
meus committed
295
<td class="normal">
296 297
</td></tr>
<tr><td>96</td>
meus's avatar
meus committed
298
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
299 300
</td></tr>
<tr><td>97</td>
meus's avatar
meus committed
301
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;root&nbsp;node
302 303
</td></tr>
<tr><td>98</td>
meus's avatar
meus committed
304
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
305 306
</td></tr>
<tr><td>99</td>
meus's avatar
meus committed
307
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;object&nbsp;$record&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;instance&nbsp;of&nbsp;Doctrine_Record
308 309
</td></tr>
<tr><td>100</td>
meus's avatar
meus committed
310
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@deprecated&nbsp;Use&nbsp;fetchRoot()
311 312
</td></tr>
<tr><td>101</td>
meus's avatar
meus committed
313
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
314 315
</td></tr>
<tr><td>102</td>
meus's avatar
meus committed
316
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;findRoot($rootId&nbsp;=&nbsp;1)
317 318
</td></tr>
<tr><td>103</td>
meus's avatar
meus committed
319
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
320 321
</td></tr>
<tr><td>104</td>
meus's avatar
meus committed
322
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;fetchRoot($rootId);
323 324
</td></tr>
<tr><td>105</td>
meus's avatar
meus committed
325
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
326 327
</td></tr>
<tr><td>106</td>
meus's avatar
meus committed
328
<td class="normal">
329 330
</td></tr>
<tr><td>107</td>
meus's avatar
meus committed
331
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
332 333
</td></tr>
<tr><td>108</td>
meus's avatar
meus committed
334
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Fetches&nbsp;a/the&nbsp;root&nbsp;node.
335 336
</td></tr>
<tr><td>109</td>
meus's avatar
meus committed
337
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
338 339
</td></tr>
<tr><td>110</td>
meus's avatar
meus committed
340
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;integer&nbsp;$rootId
341 342
</td></tr>
<tr><td>111</td>
meus's avatar
meus committed
343
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
344 345
</td></tr>
<tr><td>112</td>
meus's avatar
meus committed
346
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetchRoot($rootId&nbsp;=&nbsp;1)
347 348
</td></tr>
<tr><td>113</td>
meus's avatar
meus committed
349
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
350 351
</td></tr>
<tr><td>114</td>
meus's avatar
meus committed
352
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;getBaseQuery();
353 354
</td></tr>
<tr><td>115</td>
meus's avatar
meus committed
355
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$q-&gt;addWhere($this-&gt;_baseAlias&nbsp;.&nbsp;'.lft&nbsp;=&nbsp;?',&nbsp;1);
356 357
</td></tr>
<tr><td>116</td>
meus's avatar
meus committed
358
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
359 360
</td></tr>
<tr><td>117</td>
meus's avatar
meus committed
361
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;tree&nbsp;has&nbsp;many&nbsp;roots,&nbsp;then&nbsp;specify&nbsp;root&nbsp;id
362 363
</td></tr>
<tr><td>118</td>
meus's avatar
meus committed
364
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;returnQueryWithRootId($q,&nbsp;$rootId);
365 366
</td></tr>
<tr><td>119</td>
meus's avatar
meus committed
367
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$data&nbsp;=&nbsp;$q-&gt;execute();
368 369
</td></tr>
<tr><td>120</td>
meus's avatar
meus committed
370
<td class="normal">
371 372
</td></tr>
<tr><td>121</td>
meus's avatar
meus committed
373
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(count($data)&nbsp;&lt;=&nbsp;0)&nbsp;{
374 375
</td></tr>
<tr><td>122</td>
meus's avatar
meus committed
376
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;false;
377 378
</td></tr>
<tr><td>123</td>
meus's avatar
meus committed
379
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
380 381
</td></tr>
<tr><td>124</td>
meus's avatar
meus committed
382
<td class="normal">
383 384
</td></tr>
<tr><td>125</td>
meus's avatar
meus committed
385
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($data&nbsp;instanceof&nbsp;Doctrine_Collection)&nbsp;{
386 387
</td></tr>
<tr><td>126</td>
meus's avatar
meus committed
388
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$root&nbsp;=&nbsp;$data-&gt;getFirst();
389 390
</td></tr>
<tr><td>127</td>
meus's avatar
meus committed
391
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$root['level']&nbsp;=&nbsp;0;
392 393
</td></tr>
<tr><td>128</td>
meus's avatar
meus committed
394
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(is_array($data))&nbsp;{
395 396
</td></tr>
<tr><td>129</td>
meus's avatar
meus committed
397
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$root&nbsp;=&nbsp;array_shift($data);
398 399
</td></tr>
<tr><td>130</td>
meus's avatar
meus committed
400
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$root['level']&nbsp;=&nbsp;0;
401 402
</td></tr>
<tr><td>131</td>
meus's avatar
meus committed
403
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{
404 405
</td></tr>
<tr><td>132</td>
meus's avatar
meus committed
406
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw&nbsp;new&nbsp;Doctrine_Tree_Exception(&quot;Unexpected&nbsp;data&nbsp;structure&nbsp;returned.&quot;);
407 408
</td></tr>
<tr><td>133</td>
meus's avatar
meus committed
409
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
410 411
</td></tr>
<tr><td>134</td>
meus's avatar
meus committed
412
<td class="normal">
413 414
</td></tr>
<tr><td>135</td>
meus's avatar
meus committed
415
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$root;
416 417
</td></tr>
<tr><td>136</td>
meus's avatar
meus committed
418
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
419 420
</td></tr>
<tr><td>137</td>
meus's avatar
meus committed
421
<td class="normal">
422 423
</td></tr>
<tr><td>138</td>
meus's avatar
meus committed
424
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
425 426
</td></tr>
<tr><td>139</td>
meus's avatar
meus committed
427
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Fetches&nbsp;a&nbsp;tree.
428 429
</td></tr>
<tr><td>140</td>
meus's avatar
meus committed
430
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
431 432
</td></tr>
<tr><td>141</td>
meus's avatar
meus committed
433
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;array&nbsp;$options&nbsp;&nbsp;Options
434 435
</td></tr>
<tr><td>142</td>
meus's avatar
meus committed
436
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;mixed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The&nbsp;tree&nbsp;or&nbsp;FALSE&nbsp;if&nbsp;the&nbsp;tree&nbsp;could&nbsp;not&nbsp;be&nbsp;found.
437 438
</td></tr>
<tr><td>143</td>
meus's avatar
meus committed
439
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
440 441
</td></tr>
<tr><td>144</td>
meus's avatar
meus committed
442
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetchTree($options&nbsp;=&nbsp;array())
443 444
</td></tr>
<tr><td>145</td>
meus's avatar
meus committed
445
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
446 447
</td></tr>
<tr><td>146</td>
meus's avatar
meus committed
448
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;fetch&nbsp;tree
449 450
</td></tr>
<tr><td>147</td>
meus's avatar
meus committed
451
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;getBaseQuery();
452 453
</td></tr>
<tr><td>148</td>
meus's avatar
meus committed
454
<td class="normal">
455 456
</td></tr>
<tr><td>149</td>
meus's avatar
meus committed
457
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$q-&gt;addWhere($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft&nbsp;&gt;=&nbsp;?&quot;,&nbsp;1);
458 459
</td></tr>
<tr><td>150</td>
meus's avatar
meus committed
460
<td class="normal">
461 462
</td></tr>
<tr><td>151</td>
meus's avatar
meus committed
463
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;tree&nbsp;has&nbsp;many&nbsp;roots,&nbsp;then&nbsp;specify&nbsp;root&nbsp;id
464 465
</td></tr>
<tr><td>152</td>
meus's avatar
meus committed
466
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$rootId&nbsp;=&nbsp;isset($options['root_id'])&nbsp;?&nbsp;$options['root_id']&nbsp;:&nbsp;'1';
467 468
</td></tr>
<tr><td>153</td>
meus's avatar
meus committed
469
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(is_array($rootId))&nbsp;{
470 471
</td></tr>
<tr><td>154</td>
meus's avatar
meus committed
472
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q-&gt;addOrderBy($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.&quot;&nbsp;.&nbsp;$this-&gt;getAttribute('rootColumnName')&nbsp;.
473 474
</td></tr>
<tr><td>155</td>
meus's avatar
meus committed
475
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;,&nbsp;&quot;&nbsp;.&nbsp;$this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft&nbsp;ASC&quot;);
476 477
</td></tr>
<tr><td>156</td>
meus's avatar
meus committed
478
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{
479 480
</td></tr>
<tr><td>157</td>
meus's avatar
meus committed
481
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q-&gt;addOrderBy($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft&nbsp;ASC&quot;);
482 483
</td></tr>
<tr><td>158</td>
meus's avatar
meus committed
484
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
485 486
</td></tr>
<tr><td>159</td>
meus's avatar
meus committed
487
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
488 489
</td></tr>
<tr><td>160</td>
meus's avatar
meus committed
490
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;returnQueryWithRootId($q,&nbsp;$rootId);
491 492
</td></tr>
<tr><td>161</td>
meus's avatar
meus committed
493
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tree&nbsp;=&nbsp;$q-&gt;execute();
494 495
</td></tr>
<tr><td>162</td>
meus's avatar
meus committed
496
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
497 498
</td></tr>
<tr><td>163</td>
meus's avatar
meus committed
499
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(count($tree)&nbsp;&lt;=&nbsp;0)&nbsp;{
500 501
</td></tr>
<tr><td>164</td>
meus's avatar
meus committed
502
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;false;
503 504
</td></tr>
<tr><td>165</td>
meus's avatar
meus committed
505
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
506 507
</td></tr>
<tr><td>166</td>
meus's avatar
meus committed
508
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
509 510
</td></tr>
<tr><td>167</td>
meus's avatar
meus committed
511
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$tree;
512 513
</td></tr>
<tr><td>168</td>
meus's avatar
meus committed
514
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
515 516
</td></tr>
<tr><td>169</td>
meus's avatar
meus committed
517
<td class="normal">
518 519
</td></tr>
<tr><td>170</td>
meus's avatar
meus committed
520
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
521 522
</td></tr>
<tr><td>171</td>
meus's avatar
meus committed
523
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Fetches&nbsp;a&nbsp;branch&nbsp;of&nbsp;a&nbsp;tree.
524 525
</td></tr>
<tr><td>172</td>
meus's avatar
meus committed
526
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
527 528
</td></tr>
<tr><td>173</td>
meus's avatar
meus committed
529
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;mixed&nbsp;$pk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;primary&nbsp;key&nbsp;as&nbsp;used&nbsp;by&nbsp;table::find()&nbsp;to&nbsp;locate&nbsp;node&nbsp;to&nbsp;traverse&nbsp;tree&nbsp;from
530 531
</td></tr>
<tr><td>174</td>
meus's avatar
meus committed
532
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;array&nbsp;$options&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Options.
533 534
</td></tr>
<tr><td>175</td>
meus's avatar
meus committed
535
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;mixed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The&nbsp;branch&nbsp;or&nbsp;FALSE&nbsp;if&nbsp;the&nbsp;branch&nbsp;could&nbsp;not&nbsp;be&nbsp;found.
536 537
</td></tr>
<tr><td>176</td>
meus's avatar
meus committed
538
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@todo&nbsp;Only&nbsp;fetch&nbsp;the&nbsp;lft&nbsp;and&nbsp;rgt&nbsp;values&nbsp;of&nbsp;the&nbsp;initial&nbsp;record.&nbsp;more&nbsp;is&nbsp;not&nbsp;needed.
539 540
</td></tr>
<tr><td>177</td>
meus's avatar
meus committed
541
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
542 543
</td></tr>
<tr><td>178</td>
meus's avatar
meus committed
544
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetchBranch($pk,&nbsp;$options&nbsp;=&nbsp;array())
545 546
</td></tr>
<tr><td>179</td>
meus's avatar
meus committed
547
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
548 549
</td></tr>
<tr><td>180</td>
meus's avatar
meus committed
550
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$record&nbsp;=&nbsp;$this-&gt;table-&gt;find($pk);
551 552
</td></tr>
<tr><td>181</td>
meus's avatar
meus committed
553
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;!&nbsp;($record&nbsp;instanceof&nbsp;Doctrine_Record)&nbsp;||&nbsp;!$record-&gt;exists())&nbsp;{
554 555
</td></tr>
<tr><td>182</td>
meus's avatar
meus committed
556
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;TODO:&nbsp;if&nbsp;record&nbsp;doesn't&nbsp;exist,&nbsp;throw&nbsp;exception&nbsp;or&nbsp;similar?
557 558
</td></tr>
<tr><td>183</td>
meus's avatar
meus committed
559
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;false;
560 561
</td></tr>
<tr><td>184</td>
meus's avatar
meus committed
562
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
563 564
</td></tr>
<tr><td>185</td>
meus's avatar
meus committed
565
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//$depth&nbsp;=&nbsp;isset($options['depth'])&nbsp;?&nbsp;$options['depth']&nbsp;:&nbsp;null;
566 567
</td></tr>
<tr><td>186</td>
meus's avatar
meus committed
568
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
569 570
</td></tr>
<tr><td>187</td>
meus's avatar
meus committed
571
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;getBaseQuery();
572 573
</td></tr>
<tr><td>188</td>
meus's avatar
meus committed
574
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$params&nbsp;=&nbsp;array($record-&gt;get('lft'),&nbsp;$record-&gt;get('rgt'));
575 576
</td></tr>
<tr><td>189</td>
meus's avatar
meus committed
577
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q-&gt;addWhere($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft&nbsp;&gt;=&nbsp;?&nbsp;AND&nbsp;&quot;&nbsp;.&nbsp;$this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.rgt&nbsp;&lt;=&nbsp;?&quot;,&nbsp;$params)
578 579
</td></tr>
<tr><td>190</td>
meus's avatar
meus committed
580
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&gt;addOrderBy($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft&nbsp;asc&quot;);
581 582
</td></tr>
<tr><td>191</td>
meus's avatar
meus committed
583
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;returnQueryWithRootId($q,&nbsp;$record-&gt;getNode()-&gt;getRootValue());
584 585
</td></tr>
<tr><td>192</td>
meus's avatar
meus committed
586
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$q-&gt;execute();
587 588
</td></tr>
<tr><td>193</td>
meus's avatar
meus committed
589
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
590 591
</td></tr>
<tr><td>194</td>
meus's avatar
meus committed
592
<td class="normal">
593 594
</td></tr>
<tr><td>195</td>
meus's avatar
meus committed
595
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
596 597
</td></tr>
<tr><td>196</td>
meus's avatar
meus committed
598
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Fetches&nbsp;all&nbsp;root&nbsp;nodes.&nbsp;If&nbsp;the&nbsp;tree&nbsp;has&nbsp;only&nbsp;one&nbsp;root&nbsp;this&nbsp;is&nbsp;the&nbsp;same&nbsp;as
599 600
</td></tr>
<tr><td>197</td>
meus's avatar
meus committed
601
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;fetchRoot().
602 603
</td></tr>
<tr><td>198</td>
meus's avatar
meus committed
604
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
605 606
</td></tr>
<tr><td>199</td>
meus's avatar
meus committed
607
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;mixed&nbsp;&nbsp;The&nbsp;root&nbsp;nodes.
608 609
</td></tr>
<tr><td>200</td>
meus's avatar
meus committed
610
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
611 612
</td></tr>
<tr><td>201</td>
meus's avatar
meus committed
613
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetchRoots()
614 615
</td></tr>
<tr><td>202</td>
meus's avatar
meus committed
616
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
617 618
</td></tr>
<tr><td>203</td>
meus's avatar
meus committed
619
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$this-&gt;getBaseQuery();
620 621
</td></tr>
<tr><td>204</td>
meus's avatar
meus committed
622
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;$q-&gt;addWhere($this-&gt;_baseAlias&nbsp;.&nbsp;'.lft&nbsp;=&nbsp;?',&nbsp;1);
623 624
</td></tr>
<tr><td>205</td>
meus's avatar
meus committed
625
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$q-&gt;execute();
626 627
</td></tr>
<tr><td>206</td>
meus's avatar
meus committed
628
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
629 630
</td></tr>
<tr><td>207</td>
meus's avatar
meus committed
631
<td class="normal">
632 633
</td></tr>
<tr><td>208</td>
meus's avatar
meus committed
634
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
635 636
</td></tr>
<tr><td>209</td>
meus's avatar
meus committed
637
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;calculates&nbsp;the&nbsp;next&nbsp;available&nbsp;root&nbsp;id
638 639
</td></tr>
<tr><td>210</td>
meus's avatar
meus committed
640
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
641 642
</td></tr>
<tr><td>211</td>
meus's avatar
meus committed
643
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;integer
644 645
</td></tr>
<tr><td>212</td>
meus's avatar
meus committed
646
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
647 648
</td></tr>
<tr><td>213</td>
meus's avatar
meus committed
649
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;getNextRootId()
650 651
</td></tr>
<tr><td>214</td>
meus's avatar
meus committed
652
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
653 654
</td></tr>
<tr><td>215</td>
meus's avatar
meus committed
655
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;getMaxRootId()&nbsp;+&nbsp;1;
656 657
</td></tr>
<tr><td>216</td>
meus's avatar
meus committed
658
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
659 660
</td></tr>
<tr><td>217</td>
meus's avatar
meus committed
661
<td class="normal">
662 663
</td></tr>
<tr><td>218</td>
meus's avatar
meus committed
664
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
665 666
</td></tr>
<tr><td>219</td>
meus's avatar
meus committed
667
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;calculates&nbsp;the&nbsp;current&nbsp;max&nbsp;root&nbsp;id
668 669
</td></tr>
<tr><td>220</td>
meus's avatar
meus committed
670
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
671 672
</td></tr>
<tr><td>221</td>
meus's avatar
meus committed
673
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;integer
674 675
</td></tr>
<tr><td>222</td>
meus's avatar
meus committed
676
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/&nbsp;&nbsp;&nbsp;&nbsp;
677 678
</td></tr>
<tr><td>223</td>
meus's avatar
meus committed
679
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;getMaxRootId()
680 681
</td></tr>
<tr><td>224</td>
meus's avatar
meus committed
682
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
683 684
</td></tr>
<tr><td>225</td>
meus's avatar
meus committed
685
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$component&nbsp;=&nbsp;$this-&gt;table-&gt;getComponentName();
686 687
</td></tr>
<tr><td>226</td>
meus's avatar
meus committed
688
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$column&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;$this-&gt;getAttribute('rootColumnName');
689 690
</td></tr>
<tr><td>227</td>
meus's avatar
meus committed
691
<td class="normal">
692 693
</td></tr>
<tr><td>228</td>
meus's avatar
meus committed
694
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;cannot&nbsp;get&nbsp;this&nbsp;dql&nbsp;to&nbsp;work,&nbsp;cannot&nbsp;retrieve&nbsp;result&nbsp;using&nbsp;$coll[0]-&gt;max
695 696
</td></tr>
<tr><td>229</td>
meus's avatar
meus committed
697
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//$dql&nbsp;=&nbsp;&quot;SELECT&nbsp;MAX(c.$column)&nbsp;FROM&nbsp;$component&nbsp;c&quot;;
698 699
</td></tr>
<tr><td>230</td>
meus's avatar
meus committed
700
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
701 702
</td></tr>
<tr><td>231</td>
meus's avatar
meus committed
703
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$dql&nbsp;=&nbsp;'SELECT&nbsp;c.'&nbsp;.&nbsp;$column&nbsp;.&nbsp;'&nbsp;FROM&nbsp;'&nbsp;.&nbsp;$component&nbsp;.&nbsp;'&nbsp;c&nbsp;ORDER&nbsp;BY&nbsp;c.'&nbsp;.&nbsp;$column&nbsp;.&nbsp;'&nbsp;DESC&nbsp;LIMIT&nbsp;1';
704 705
</td></tr>
<tr><td>232</td>
meus's avatar
meus committed
706
<td class="normal">&nbsp;&nbsp;
707 708
</td></tr>
<tr><td>233</td>
meus's avatar
meus committed
709
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$coll&nbsp;=&nbsp;$this-&gt;table-&gt;getConnection()-&gt;query($dql);
710 711
</td></tr>
<tr><td>234</td>
meus's avatar
meus committed
712
<td class="normal">&nbsp;&nbsp;
713 714
</td></tr>
<tr><td>235</td>
meus's avatar
meus committed
715
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$max&nbsp;=&nbsp;$coll[0]-&gt;get($column);
716 717
</td></tr>
<tr><td>236</td>
meus's avatar
meus committed
718
<td class="normal">&nbsp;&nbsp;
719 720
</td></tr>
<tr><td>237</td>
meus's avatar
meus committed
721
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$max&nbsp;=&nbsp;!is_null($max)&nbsp;?&nbsp;$max&nbsp;:&nbsp;0;
722 723
</td></tr>
<tr><td>238</td>
meus's avatar
meus committed
724
<td class="normal">&nbsp;&nbsp;
725 726
</td></tr>
<tr><td>239</td>
meus's avatar
meus committed
727
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$max;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
728 729
</td></tr>
<tr><td>240</td>
meus's avatar
meus committed
730
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
731 732
</td></tr>
<tr><td>241</td>
meus's avatar
meus committed
733
<td class="normal">
734 735
</td></tr>
<tr><td>242</td>
meus's avatar
meus committed
736
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
737 738
</td></tr>
<tr><td>243</td>
meus's avatar
meus committed
739
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;parsed&nbsp;query&nbsp;with&nbsp;root&nbsp;id&nbsp;where&nbsp;clause&nbsp;added&nbsp;if&nbsp;applicable
740 741
</td></tr>
<tr><td>244</td>
meus's avatar
meus committed
742
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
743 744
</td></tr>
<tr><td>245</td>
meus's avatar
meus committed
745
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;object&nbsp;&nbsp;&nbsp;&nbsp;$query&nbsp;&nbsp;&nbsp;&nbsp;Doctrine_Query
746 747
</td></tr>
<tr><td>246</td>
meus's avatar
meus committed
748
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;integer&nbsp;&nbsp;&nbsp;$root_id&nbsp;&nbsp;id&nbsp;of&nbsp;destination&nbsp;root
749 750
</td></tr>
<tr><td>247</td>
meus's avatar
meus committed
751
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;object&nbsp;&nbsp;&nbsp;Doctrine_Query
752 753
</td></tr>
<tr><td>248</td>
meus's avatar
meus committed
754
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
755 756
</td></tr>
<tr><td>249</td>
meus's avatar
meus committed
757
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;returnQueryWithRootId($query,&nbsp;$rootId&nbsp;=&nbsp;1)
758 759
</td></tr>
<tr><td>250</td>
meus's avatar
meus committed
760
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
761 762
</td></tr>
<tr><td>251</td>
meus's avatar
meus committed
763
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($root&nbsp;=&nbsp;$this-&gt;getAttribute('rootColumnName'))&nbsp;{
764 765
</td></tr>
<tr><td>252</td>
meus's avatar
meus committed
766
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(is_array($rootId))&nbsp;{
767 768
</td></tr>
<tr><td>253</td>
meus's avatar
meus committed
769
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query-&gt;addWhere($root&nbsp;.&nbsp;'&nbsp;IN&nbsp;('&nbsp;.&nbsp;implode(',',&nbsp;array_fill(0,&nbsp;count($rootId),&nbsp;'?'))&nbsp;.&nbsp;')',
770 771
</td></tr>
<tr><td>254</td>
meus's avatar
meus committed
772
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$rootId);
773 774
</td></tr>
<tr><td>255</td>
meus's avatar
meus committed
775
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{
776 777
</td></tr>
<tr><td>256</td>
meus's avatar
meus committed
778
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query-&gt;addWhere($root&nbsp;.&nbsp;'&nbsp;=&nbsp;?',&nbsp;$rootId);&nbsp;
779 780
</td></tr>
<tr><td>257</td>
meus's avatar
meus committed
781
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
782 783
</td></tr>
<tr><td>258</td>
meus's avatar
meus committed
784
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
785 786
</td></tr>
<tr><td>259</td>
meus's avatar
meus committed
787
<td class="normal">
788 789
</td></tr>
<tr><td>260</td>
meus's avatar
meus committed
790
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$query;
791 792
</td></tr>
<tr><td>261</td>
meus's avatar
meus committed
793
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
794 795
</td></tr>
<tr><td>262</td>
meus's avatar
meus committed
796
<td class="normal">
797 798
</td></tr>
<tr><td>263</td>
meus's avatar
meus committed
799
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
800 801
</td></tr>
<tr><td>264</td>
meus's avatar
meus committed
802
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
803 804
</td></tr>
<tr><td>265</td>
meus's avatar
meus committed
805
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
806 807
</td></tr>
<tr><td>266</td>
meus's avatar
meus committed
808
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;array&nbsp;$options
809 810
</td></tr>
<tr><td>267</td>
meus's avatar
meus committed
811
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;unknown
812 813
</td></tr>
<tr><td>268</td>
meus's avatar
meus committed
814
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
815 816
</td></tr>
<tr><td>269</td>
meus's avatar
meus committed
817
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;getBaseQuery()
818 819
</td></tr>
<tr><td>270</td>
meus's avatar
meus committed
820
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
821 822
</td></tr>
<tr><td>271</td>
meus's avatar
meus committed
823
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;!&nbsp;isset($this-&gt;_baseQuery))&nbsp;{
824 825
</td></tr>
<tr><td>272</td>
meus's avatar
meus committed
826
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;_baseQuery&nbsp;=&nbsp;$this-&gt;_createBaseQuery();
827 828
</td></tr>
<tr><td>273</td>
meus's avatar
meus committed
829
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
830 831
</td></tr>
<tr><td>274</td>
meus's avatar
meus committed
832
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;_baseQuery-&gt;copy();
833 834
</td></tr>
<tr><td>275</td>
meus's avatar
meus committed
835
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
836 837
</td></tr>
<tr><td>276</td>
meus's avatar
meus committed
838
<td class="normal">
839 840
</td></tr>
<tr><td>277</td>
meus's avatar
meus committed
841
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
842 843
</td></tr>
<tr><td>278</td>
meus's avatar
meus committed
844
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
845 846
</td></tr>
<tr><td>279</td>
meus's avatar
meus committed
847
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
848 849
</td></tr>
<tr><td>280</td>
meus's avatar
meus committed
850
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
851 852
</td></tr>
<tr><td>281</td>
meus's avatar
meus committed
853
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;getBaseAlias()
854 855
</td></tr>
<tr><td>282</td>
meus's avatar
meus committed
856
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
857 858
</td></tr>
<tr><td>283</td>
meus's avatar
meus committed
859
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;_baseAlias;
860 861
</td></tr>
<tr><td>284</td>
meus's avatar
meus committed
862
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
863 864
</td></tr>
<tr><td>285</td>
meus's avatar
meus committed
865
<td class="normal">
866 867
</td></tr>
<tr><td>286</td>
meus's avatar
meus committed
868
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
869 870
</td></tr>
<tr><td>287</td>
meus's avatar
meus committed
871
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
872 873
</td></tr>
<tr><td>288</td>
meus's avatar
meus committed
874
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
875 876
</td></tr>
<tr><td>289</td>
meus's avatar
meus committed
877
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
878 879
</td></tr>
<tr><td>290</td>
meus's avatar
meus committed
880
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;function&nbsp;_createBaseQuery()
881 882
</td></tr>
<tr><td>291</td>
meus's avatar
meus committed
883
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
884 885
</td></tr>
<tr><td>292</td>
meus's avatar
meus committed
886
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;_baseAlias&nbsp;=&nbsp;&quot;base&quot;;
887 888
</td></tr>
<tr><td>293</td>
meus's avatar
meus committed
889
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q&nbsp;=&nbsp;new&nbsp;Doctrine_Query();
890 891
</td></tr>
<tr><td>294</td>
meus's avatar
meus committed
892
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$q-&gt;select($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.*&quot;)-&gt;from($this-&gt;getBaseComponent()&nbsp;.&nbsp;&quot;&nbsp;&quot;&nbsp;.&nbsp;$this-&gt;_baseAlias);
893 894
</td></tr>
<tr><td>295</td>
meus's avatar
meus committed
895
<td class="covered">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$q;
896 897
</td></tr>
<tr><td>296</td>
meus's avatar
meus committed
898
<td class="orange">&nbsp;&nbsp;&nbsp;&nbsp;}
899 900
</td></tr>
<tr><td>297</td>
meus's avatar
meus committed
901
<td class="normal">
902 903
</td></tr>
<tr><td>298</td>
meus's avatar
meus committed
904
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
905 906
</td></tr>
<tr><td>299</td>
meus's avatar
meus committed
907
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
908 909
</td></tr>
<tr><td>300</td>
meus's avatar
meus committed
910
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
911 912
</td></tr>
<tr><td>301</td>
meus's avatar
meus committed
913
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;Doctrine_Query&nbsp;$query
914 915
</td></tr>
<tr><td>302</td>
meus's avatar
meus committed
916
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
917 918
</td></tr>
<tr><td>303</td>
meus's avatar
meus committed
919
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;setBaseQuery(Doctrine_Query&nbsp;$query)
920 921
</td></tr>
<tr><td>304</td>
meus's avatar
meus committed
922
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
923 924
</td></tr>
<tr><td>305</td>
meus's avatar
meus committed
925
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;_baseAlias&nbsp;=&nbsp;$query-&gt;getRootAlias();
926 927
</td></tr>
<tr><td>306</td>
meus's avatar
meus committed
928
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query-&gt;addSelect($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.lft,&nbsp;&quot;&nbsp;.&nbsp;$this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.rgt,&nbsp;&quot;.&nbsp;$this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.level&quot;);
929 930
</td></tr>
<tr><td>307</td>
meus's avatar
meus committed
931
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($this-&gt;getAttribute('rootColumnName'))&nbsp;{
932 933
</td></tr>
<tr><td>308</td>
meus's avatar
meus committed
934
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query-&gt;addSelect($this-&gt;_baseAlias&nbsp;.&nbsp;&quot;.&quot;&nbsp;.&nbsp;$this-&gt;getAttribute('rootColumnName'));
935 936
</td></tr>
<tr><td>309</td>
meus's avatar
meus committed
937
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
938 939
</td></tr>
<tr><td>310</td>
meus's avatar
meus committed
940
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;_baseQuery&nbsp;=&nbsp;$query;
941 942
</td></tr>
<tr><td>311</td>
meus's avatar
meus committed
943
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;}
944 945
</td></tr>
<tr><td>312</td>
meus's avatar
meus committed
946
<td class="normal">
947 948
</td></tr>
<tr><td>313</td>
meus's avatar
meus committed
949
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
950 951
</td></tr>
<tr><td>314</td>
meus's avatar
meus committed
952
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
953 954
</td></tr>
<tr><td>315</td>
meus's avatar
meus committed
955
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
956 957
</td></tr>
<tr><td>316</td>
meus's avatar
meus committed
958
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
959 960
</td></tr>
<tr><td>317</td>
meus's avatar
meus committed
961
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;resetBaseQuery()
962 963
</td></tr>
<tr><td>318</td>
meus's avatar
meus committed
964
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
965 966
</td></tr>
<tr><td>319</td>
meus's avatar
meus committed
967
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;_baseQuery&nbsp;=&nbsp;$this-&gt;_createBaseQuery();
968 969
</td></tr>
<tr><td>320</td>
meus's avatar
meus committed
970
<td class="red">&nbsp;&nbsp;&nbsp;&nbsp;}
971 972
</td></tr>
<tr><td>321</td>
meus's avatar
meus committed
973
<td class="normal">
974 975
</td></tr>
<tr><td>322</td>
meus's avatar
meus committed
976
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/**
977 978
</td></tr>
<tr><td>323</td>
meus's avatar
meus committed
979
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Enter&nbsp;description&nbsp;here...
980 981
</td></tr>
<tr><td>324</td>
meus's avatar
meus committed
982
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*
983 984
</td></tr>
<tr><td>325</td>
meus's avatar
meus committed
985
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;unknown_type&nbsp;$graph
986 987
</td></tr>
<tr><td>326</td>
meus's avatar
meus committed
988
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/
989 990
</td></tr>
<tr><td>327</td>
meus's avatar
meus committed
991
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;/*
992 993
</td></tr>
<tr><td>328</td>
meus's avatar
meus committed
994
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;computeLevels($tree)
995 996
</td></tr>
<tr><td>329</td>
meus's avatar
meus committed
997
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;{
998 999
</td></tr>
<tr><td>330</td>
meus's avatar
meus committed
1000
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$right&nbsp;=&nbsp;array();
1001 1002
</td></tr>
<tr><td>331</td>
meus's avatar
meus committed
1003
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$isArray&nbsp;=&nbsp;is_array($tree);
1004 1005
</td></tr>
<tr><td>332</td>
meus's avatar
meus committed
1006
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$rootColumnName&nbsp;=&nbsp;$this-&gt;getAttribute('rootColumnName');
1007 1008
</td></tr>
<tr><td>333</td>
meus's avatar
meus committed
1009
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1010 1011
</td></tr>
<tr><td>334</td>
meus's avatar
meus committed
1012
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;($i&nbsp;=&nbsp;0,&nbsp;$count&nbsp;=&nbsp;count($tree);&nbsp;$i&nbsp;&lt;&nbsp;$count;&nbsp;$i++)&nbsp;{
1013 1014
</td></tr>
<tr><td>335</td>
meus's avatar
meus committed
1015
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($rootColumnName&nbsp;&amp;&amp;&nbsp;$i&nbsp;&gt;&nbsp;0&nbsp;&amp;&amp;&nbsp;$tree[$i][$rootColumnName]&nbsp;!=&nbsp;$tree[$i-1][$rootColumnName])&nbsp;{
1016 1017
</td></tr>
<tr><td>336</td>
meus's avatar
meus committed
1018
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$right&nbsp;=&nbsp;array();
1019 1020
</td></tr>
<tr><td>337</td>
meus's avatar
meus committed
1021
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
1022 1023
</td></tr>
<tr><td>338</td>
meus's avatar
meus committed
1024
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1025 1026
</td></tr>
<tr><td>339</td>
meus's avatar
meus committed
1027
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(count($right)&nbsp;&gt;&nbsp;0)&nbsp;{
1028 1029
</td></tr>
<tr><td>340</td>
meus's avatar
meus committed
1030
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while&nbsp;(count($right)&nbsp;&gt;&nbsp;0&nbsp;&amp;&amp;&nbsp;$right[count($right)-1]&nbsp;&lt;&nbsp;$tree[$i]['rgt'])&nbsp;{
1031 1032
</td></tr>
<tr><td>341</td>
meus's avatar
meus committed
1033
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//echo&nbsp;count($right);
1034 1035
</td></tr>
<tr><td>342</td>
meus's avatar
meus committed
1036
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;array_pop($right);
1037 1038
</td></tr>
<tr><td>343</td>
meus's avatar
meus committed
1039
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
1040 1041
</td></tr>
<tr><td>344</td>
meus's avatar
meus committed
1042
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
1043 1044
</td></tr>
<tr><td>345</td>
meus's avatar
meus committed
1045
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1046 1047
</td></tr>
<tr><td>346</td>
meus's avatar
meus committed
1048
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($isArray)&nbsp;{
1049 1050
</td></tr>
<tr><td>347</td>
meus's avatar
meus committed
1051
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tree[$i]['level']&nbsp;=&nbsp;count($right);
1052 1053
</td></tr>
<tr><td>348</td>
meus's avatar
meus committed
1054
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{
1055 1056
</td></tr>
<tr><td>349</td>
meus's avatar
meus committed
1057
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tree[$i]-&gt;getNode()-&gt;setLevel(count($right));
1058 1059
</td></tr>
<tr><td>350</td>
meus's avatar
meus committed
1060
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
1061 1062
</td></tr>
<tr><td>351</td>
meus's avatar
meus committed
1063
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;
1064 1065
</td></tr>
<tr><td>352</td>
meus's avatar
meus committed
1066
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$right[]&nbsp;=&nbsp;$tree[$i]['rgt'];
1067 1068
</td></tr>
<tr><td>353</td>
meus's avatar
meus committed
1069
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
1070 1071
</td></tr>
<tr><td>354</td>
meus's avatar
meus committed
1072
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$tree;
1073 1074
</td></tr>
<tr><td>355</td>
meus's avatar
meus committed
1075
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;}
1076 1077
</td></tr>
<tr><td>356</td>
meus's avatar
meus committed
1078 1079 1080
<td class="normal">&nbsp;&nbsp;&nbsp;&nbsp;*/
</td></tr>
<tr><td>357</td>
1081 1082
<td class="covered">}</td></tr>
</table></body></html>