@@ -248,9 +248,9 @@ |
||
248 | 248 | echo '<span class="notok">' . $_lang['failed'] . '</span></b>' . $_lang['table_prefix_not_exist'] . '</p>'; |
249 | 249 | $errors++; |
250 | 250 | echo '<p>' . $_lang['table_prefix_not_exist_note'] . '</p>'; |
251 | - } else { |
|
251 | + } else { |
|
252 | 252 | echo '<span class="ok">' . $_lang['ok'] . '</span></p>'; |
253 | - } |
|
253 | + } |
|
254 | 254 | } |
255 | 255 | |
256 | 256 | // check mysql version |
@@ -15,13 +15,13 @@ |
||
15 | 15 | include($base_path.MGR_DIR.'/includes/config.inc.php'); |
16 | 16 | // We need to have all connection settings - but prefix may be empty so we have to ignore it |
17 | 17 | if ($dbase) { |
18 | - $database_name = trim($dbase, '`'); |
|
19 | - if (!$conn = mysqli_connect($database_server, $database_user, $database_password)) |
|
20 | - $upgradeable = (isset($_POST['installmode']) && $_POST['installmode']=='new') ? 0 : 2; |
|
21 | - elseif (! mysqli_select_db($conn, trim($dbase, '`'))) |
|
22 | - $upgradeable = (isset($_POST['installmode']) && $_POST['installmode']=='new') ? 0 : 2; |
|
23 | - else |
|
24 | - $upgradeable = 1; |
|
18 | + $database_name = trim($dbase, '`'); |
|
19 | + if (!$conn = mysqli_connect($database_server, $database_user, $database_password)) |
|
20 | + $upgradeable = (isset($_POST['installmode']) && $_POST['installmode']=='new') ? 0 : 2; |
|
21 | + elseif (! mysqli_select_db($conn, trim($dbase, '`'))) |
|
22 | + $upgradeable = (isset($_POST['installmode']) && $_POST['installmode']=='new') ? 0 : 2; |
|
23 | + else |
|
24 | + $upgradeable = 1; |
|
25 | 25 | } |
26 | 26 | else $upgradable= 2; |
27 | 27 | } |
@@ -3,23 +3,23 @@ |
||
3 | 3 | |
4 | 4 | // START HACK |
5 | 5 | if (isset ($modx)) { |
6 | - $user_id = $modx->getLoginUserID(); |
|
6 | + $user_id = $modx->getLoginUserID(); |
|
7 | 7 | } else { |
8 | - $user_id = $_SESSION['mgrInternalKey']; |
|
8 | + $user_id = $_SESSION['mgrInternalKey']; |
|
9 | 9 | } |
10 | 10 | // END HACK |
11 | 11 | |
12 | 12 | if (!empty($user_id)) { |
13 | - // Raymond: grab the user settings from the database. |
|
14 | - $rs = $modx->db->select('setting_name, setting_value', $modx->getFullTableName('user_settings'), "user=".$modx->getLoginUserID()); |
|
13 | + // Raymond: grab the user settings from the database. |
|
14 | + $rs = $modx->db->select('setting_name, setting_value', $modx->getFullTableName('user_settings'), "user=".$modx->getLoginUserID()); |
|
15 | 15 | |
16 | - $which_browser_default = $which_browser; |
|
17 | - while ($row = $modx->db->getRow($rs)) { |
|
18 | - if($row['setting_name'] == 'which_browser' && $row['setting_value'] == 'default') $row['setting_value'] = $which_browser_default; |
|
19 | - $settings[$row['setting_name']] = $row['setting_value']; |
|
20 | - if (isset($modx->config)) { |
|
21 | - $modx->config[$row['setting_name']] = $row['setting_value']; |
|
22 | - } |
|
23 | - } |
|
24 | - extract($settings, EXTR_OVERWRITE); |
|
16 | + $which_browser_default = $which_browser; |
|
17 | + while ($row = $modx->db->getRow($rs)) { |
|
18 | + if($row['setting_name'] == 'which_browser' && $row['setting_value'] == 'default') $row['setting_value'] = $which_browser_default; |
|
19 | + $settings[$row['setting_name']] = $row['setting_value']; |
|
20 | + if (isset($modx->config)) { |
|
21 | + $modx->config[$row['setting_name']] = $row['setting_value']; |
|
22 | + } |
|
23 | + } |
|
24 | + extract($settings, EXTR_OVERWRITE); |
|
25 | 25 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | - /* |
|
2 | + /* |
|
3 | 3 | * MODX Manager Home Page Implmentation by pixelchutes (www.pixelchutes.com) |
4 | 4 | * Based on kudo's kRSS Module v1.0.72 |
5 | 5 | * |
@@ -30,43 +30,43 @@ discard block |
||
30 | 30 | require_once(MODX_MANAGER_PATH.'media/rss/rss_fetch.inc'); |
31 | 31 | // Convert relative path into absolute url |
32 | 32 | function rel2abs( $rel, $base ) { |
33 | - // parse base URL and convert to local variables: $scheme, $host, $path |
|
34 | - extract( parse_url( $base ) ); |
|
35 | - if ( strpos( $rel,"//" ) === 0 ) { |
|
36 | - return $scheme . ':' . $rel; |
|
37 | - } |
|
38 | - // return if already absolute URL |
|
39 | - if ( parse_url( $rel, PHP_URL_SCHEME ) != '' ) { |
|
40 | - return $rel; |
|
41 | - } |
|
42 | - // queries and anchors |
|
43 | - if ( $rel[0] == '#' || $rel[0] == '?' ) { |
|
44 | - return $base . $rel; |
|
45 | - } |
|
46 | - // remove non-directory element from path |
|
47 | - $path = preg_replace( '#/[^/]*$#', '', $path ); |
|
48 | - // destroy path if relative url points to root |
|
49 | - if ( $rel[0] == '/' ) { |
|
50 | - $path = ''; |
|
51 | - } |
|
52 | - // dirty absolute URL |
|
53 | - $abs = $host . $path . "/" . $rel; |
|
54 | - // replace '//' or '/./' or '/foo/../' with '/' |
|
55 | - $abs = preg_replace( "/(\/\.?\/)/", "/", $abs ); |
|
56 | - $abs = preg_replace( "/\/(?!\.\.)[^\/]+\/\.\.\//", "/", $abs ); |
|
57 | - // absolute URL is ready! |
|
58 | - return $scheme . '://' . $abs; |
|
33 | + // parse base URL and convert to local variables: $scheme, $host, $path |
|
34 | + extract( parse_url( $base ) ); |
|
35 | + if ( strpos( $rel,"//" ) === 0 ) { |
|
36 | + return $scheme . ':' . $rel; |
|
37 | + } |
|
38 | + // return if already absolute URL |
|
39 | + if ( parse_url( $rel, PHP_URL_SCHEME ) != '' ) { |
|
40 | + return $rel; |
|
41 | + } |
|
42 | + // queries and anchors |
|
43 | + if ( $rel[0] == '#' || $rel[0] == '?' ) { |
|
44 | + return $base . $rel; |
|
45 | + } |
|
46 | + // remove non-directory element from path |
|
47 | + $path = preg_replace( '#/[^/]*$#', '', $path ); |
|
48 | + // destroy path if relative url points to root |
|
49 | + if ( $rel[0] == '/' ) { |
|
50 | + $path = ''; |
|
51 | + } |
|
52 | + // dirty absolute URL |
|
53 | + $abs = $host . $path . "/" . $rel; |
|
54 | + // replace '//' or '/./' or '/foo/../' with '/' |
|
55 | + $abs = preg_replace( "/(\/\.?\/)/", "/", $abs ); |
|
56 | + $abs = preg_replace( "/\/(?!\.\.)[^\/]+\/\.\.\//", "/", $abs ); |
|
57 | + // absolute URL is ready! |
|
58 | + return $scheme . '://' . $abs; |
|
59 | 59 | } |
60 | 60 | $feedData = array(); |
61 | 61 | |
62 | 62 | // create Feed |
63 | 63 | foreach ($urls as $section=>$url) { |
64 | - $output = ''; |
|
64 | + $output = ''; |
|
65 | 65 | $rss = @fetch_rss($url); |
66 | 66 | if( !$rss ){ |
67 | - $feedData[$section] = 'Failed to retrieve ' . $url; |
|
68 | - continue; |
|
69 | - } |
|
67 | + $feedData[$section] = 'Failed to retrieve ' . $url; |
|
68 | + continue; |
|
69 | + } |
|
70 | 70 | $output .= '<ul>'; |
71 | 71 | |
72 | 72 | $items = array_slice($rss->items, 0, $itemsNumber); |
@@ -84,5 +84,5 @@ discard block |
||
84 | 84 | } |
85 | 85 | |
86 | 86 | $output .= '</ul>'; |
87 | - $feedData[$section] = $output; |
|
87 | + $feedData[$section] = $output; |
|
88 | 88 | } |
@@ -9,366 +9,366 @@ discard block |
||
9 | 9 | * @author Jason Coward <[email protected]> (MODX) |
10 | 10 | */ |
11 | 11 | class MakeTable { |
12 | - var $actionField; |
|
13 | - var $cellAction; |
|
14 | - var $linkAction; |
|
15 | - var $tableWidth; |
|
16 | - var $tableClass; |
|
17 | - var $tableID; |
|
18 | - var $thClass; |
|
19 | - var $rowHeaderClass; |
|
20 | - var $columnHeaderClass; |
|
21 | - var $rowRegularClass; |
|
22 | - var $rowAlternateClass; |
|
23 | - var $formName; |
|
24 | - var $formAction; |
|
25 | - var $formElementType; |
|
26 | - var $formElementName; |
|
27 | - var $rowAlternatingScheme; |
|
28 | - var $excludeFields; |
|
29 | - var $allOption; |
|
30 | - var $pageNav; |
|
31 | - var $columnWidths; |
|
32 | - var $selectedValues; |
|
33 | - |
|
34 | - function __construct() { |
|
35 | - $this->fieldHeaders= array(); |
|
36 | - $this->excludeFields= array(); |
|
37 | - $this->actionField= ''; |
|
38 | - $this->cellAction= ''; |
|
39 | - $this->linkAction= ''; |
|
40 | - $this->tableWidth= ''; |
|
41 | - $this->tableClass= ''; |
|
42 | - $this->rowHeaderClass= ''; |
|
43 | - $this->columnHeaderClass= ''; |
|
44 | - $this->rowRegularClass= ''; |
|
45 | - $this->rowAlternateClass= 'alt'; |
|
46 | - $this->formName= 'tableForm'; |
|
47 | - $this->formAction= '[~[*id*]~]'; |
|
48 | - $this->formElementName= ''; |
|
49 | - $this->formElementType= ''; |
|
50 | - $this->rowAlternatingScheme= 'EVEN'; |
|
51 | - $this->allOption= 0; |
|
52 | - $this->selectedValues= array(); |
|
53 | - $this->extra= ''; |
|
54 | - } |
|
55 | - |
|
56 | - /** |
|
57 | - * Sets the default link href for all cells in the table. |
|
58 | - * |
|
59 | - * @param $value A URL to execute when table cells are clicked. |
|
60 | - */ |
|
61 | - function setCellAction($value) { |
|
62 | - $this->cellAction= $this->prepareLink($value); |
|
63 | - } |
|
64 | - |
|
65 | - /** |
|
66 | - * Sets the default link href for the text presented in a cell. |
|
67 | - * |
|
68 | - * @param $value A URL to execute when text within table cells are clicked. |
|
69 | - */ |
|
70 | - function setLinkAction($value) { |
|
71 | - $this->linkAction= $this->prepareLink($value); |
|
72 | - } |
|
73 | - |
|
74 | - /** |
|
75 | - * Sets the width attribute of the main HTML TABLE. |
|
76 | - * |
|
77 | - * @param $value A valid width attribute for the HTML TABLE tag |
|
78 | - */ |
|
79 | - function setTableWidth($value) { |
|
80 | - $this->tableWidth= $value; |
|
81 | - } |
|
82 | - |
|
83 | - /** |
|
84 | - * Sets the class attribute of the main HTML TABLE. |
|
85 | - * |
|
86 | - * @param $value A class for the main HTML TABLE. |
|
87 | - */ |
|
88 | - function setTableClass($value) { |
|
89 | - $this->tableClass= $value; |
|
90 | - } |
|
91 | - |
|
92 | - /** |
|
93 | - * Sets the id attribute of the main HTML TABLE. |
|
94 | - * |
|
95 | - * @param $value A class for the main HTML TABLE. |
|
96 | - */ |
|
97 | - function setTableID($value) { |
|
98 | - $this->tableID= $value; |
|
99 | - } |
|
100 | - |
|
101 | - /** |
|
102 | - * Sets the class attribute of the table header row. |
|
103 | - * |
|
104 | - * @param $value A class for the table header row. |
|
105 | - */ |
|
106 | - function setRowHeaderClass($value) { |
|
107 | - $this->rowHeaderClass= $value; |
|
108 | - } |
|
109 | - |
|
110 | - /** |
|
111 | - * Sets the class attribute of the table header row. |
|
112 | - * |
|
113 | - * @param $value A class for the table header row. |
|
114 | - */ |
|
115 | - function setThHeaderClass($value) { |
|
116 | - $this->thClass= $value; |
|
117 | - } |
|
118 | - |
|
119 | - /** |
|
120 | - * Sets the class attribute of the column header row. |
|
121 | - * |
|
122 | - * @param $value A class for the column header row. |
|
123 | - */ |
|
124 | - function setColumnHeaderClass($value) { |
|
125 | - $this->columnHeaderClass= $value; |
|
126 | - } |
|
127 | - |
|
128 | - /** |
|
129 | - * Sets the class attribute of regular table rows. |
|
130 | - * |
|
131 | - * @param $value A class for regular table rows. |
|
132 | - */ |
|
133 | - function setRowRegularClass($value) { |
|
134 | - $this->rowRegularClass= $value; |
|
135 | - } |
|
136 | - |
|
137 | - /** |
|
138 | - * Sets the class attribute of alternate table rows. |
|
139 | - * |
|
140 | - * @param $value A class for alternate table rows. |
|
141 | - */ |
|
142 | - function setRowAlternateClass($value) { |
|
143 | - $this->rowAlternateClass= $value; |
|
144 | - } |
|
145 | - |
|
146 | - /** |
|
147 | - * Sets the type of INPUT form element to be presented as the first column. |
|
148 | - * |
|
149 | - * @param $value Indicates the INPUT form element type attribute. |
|
150 | - */ |
|
151 | - function setFormElementType($value) { |
|
152 | - $this->formElementType= $value; |
|
153 | - } |
|
154 | - |
|
155 | - /** |
|
156 | - * Sets the name of the INPUT form element to be presented as the first column. |
|
157 | - * |
|
158 | - * @param $value Indicates the INPUT form element name attribute. |
|
159 | - */ |
|
160 | - function setFormElementName($value) { |
|
161 | - $this->formElementName= $value; |
|
162 | - } |
|
163 | - |
|
164 | - /** |
|
165 | - * Sets the name of the FORM to wrap the table in when a form element has |
|
166 | - * been indicated. |
|
167 | - * |
|
168 | - * @param $value Indicates the FORM name attribute. |
|
169 | - */ |
|
170 | - function setFormName($value) { |
|
171 | - $this->formName= $value; |
|
172 | - } |
|
173 | - |
|
174 | - /** |
|
175 | - * Sets the action of the FORM element. |
|
176 | - * |
|
177 | - * @param $value Indicates the FORM action attribute. |
|
178 | - */ |
|
179 | - function setFormAction($value) { |
|
180 | - $this->formAction= $value; |
|
181 | - } |
|
182 | - |
|
183 | - /** |
|
184 | - * Excludes fields from the table by array key. |
|
185 | - * |
|
186 | - * @param $value An Array of field keys to exclude from the table. |
|
187 | - */ |
|
188 | - function setExcludeFields($value) { |
|
189 | - $this->excludeFields= $value; |
|
190 | - } |
|
191 | - |
|
192 | - /** |
|
193 | - * Sets the table to provide alternate row colors using ODD or EVEN rows |
|
194 | - * |
|
195 | - * @param $value 'ODD' or 'EVEN' to indicate the alternate row scheme. |
|
196 | - */ |
|
197 | - function setRowAlternatingScheme($value) { |
|
198 | - $this->rowAlternatingScheme= $value; |
|
199 | - } |
|
200 | - |
|
201 | - /** |
|
202 | - * Sets the default field value to be used when appending query parameters |
|
203 | - * to link actions. |
|
204 | - * |
|
205 | - * @param $value The key of the field to add as a query string parameter. |
|
206 | - */ |
|
207 | - function setActionFieldName($value) { |
|
208 | - $this->actionField= $value; |
|
209 | - } |
|
210 | - |
|
211 | - /** |
|
212 | - * Sets the width attribute of each column in the array. |
|
213 | - * |
|
214 | - * @param $value An Array of column widths in the order of the keys in the |
|
215 | - * source table array. |
|
216 | - */ |
|
217 | - function setColumnWidths($widthArray) { |
|
218 | - $this->columnWidths= $widthArray; |
|
219 | - } |
|
220 | - |
|
221 | - /** |
|
222 | - * An optional array of values that can be preselected when using |
|
223 | - * |
|
224 | - * @param $value Indicates the INPUT form element type attribute. |
|
225 | - */ |
|
226 | - function setSelectedValues($valueArray) { |
|
227 | - $this->selectedValues= $valueArray; |
|
228 | - } |
|
229 | - |
|
230 | - /** |
|
231 | - * Sets extra content to be presented following the table (but within |
|
232 | - * the form, if a form is being rendered with the table). |
|
233 | - * |
|
234 | - * @param $value A string of additional content. |
|
235 | - */ |
|
236 | - function setExtra($value) { |
|
237 | - $this->extra= $value; |
|
238 | - } |
|
239 | - |
|
240 | - /** |
|
241 | - * Retrieves the width of a specific table column by index position. |
|
242 | - * |
|
243 | - * @param $columnPosition The index of the column to get the width for. |
|
244 | - */ |
|
245 | - function getColumnWidth($columnPosition) { |
|
246 | - $currentWidth= ''; |
|
247 | - if (is_array($this->columnWidths)) { |
|
248 | - $currentWidth= $this->columnWidths[$columnPosition] ? ' width="'.$this->columnWidths[$columnPosition].'" ' : ''; |
|
249 | - } |
|
250 | - return $currentWidth; |
|
251 | - } |
|
252 | - |
|
253 | - /** |
|
254 | - * Determines what class the current row should have applied. |
|
255 | - * |
|
256 | - * @param $value The position of the current row being rendered. |
|
257 | - */ |
|
258 | - function determineRowClass($position) { |
|
259 | - switch ($this->rowAlternatingScheme) { |
|
260 | - case 'ODD' : |
|
261 | - $modRemainder= 1; |
|
262 | - break; |
|
263 | - case 'EVEN' : |
|
264 | - $modRemainder= 0; |
|
265 | - break; |
|
266 | - } |
|
267 | - if ($position % 2 == $modRemainder) { |
|
268 | - $currentClass= $this->rowRegularClass; |
|
269 | - } else { |
|
270 | - $currentClass= $this->rowAlternateClass; |
|
271 | - } |
|
272 | - return ' class="'.$currentClass.'"'; |
|
273 | - } |
|
274 | - |
|
275 | - /** |
|
276 | - * Generates an onclick action applied to the current cell, to execute |
|
277 | - * any specified cell actions. |
|
278 | - * |
|
279 | - * @param $value Indicates the INPUT form element type attribute. |
|
280 | - */ |
|
281 | - function getCellAction($currentActionFieldValue) { |
|
282 | - if ($this->cellAction) { |
|
283 | - $cellAction= ' onClick="javascript:window.location=\''.$this->cellAction.$this->actionField.'='.urlencode($currentActionFieldValue).'\'" '; |
|
284 | - } |
|
285 | - return $cellAction; |
|
286 | - } |
|
287 | - |
|
288 | - /** |
|
289 | - * Generates the cell content, including any specified action fields values. |
|
290 | - * |
|
291 | - * @param $currentActionFieldValue The value to be applied to the link action. |
|
292 | - * @param $value The value of the cell. |
|
293 | - */ |
|
294 | - function createCellText($currentActionFieldValue, $value) { |
|
295 | - $cell .= $value; |
|
296 | - if ($this->linkAction) { |
|
297 | - $cell= '<a href="'.$this->linkAction.$this->actionField.'='.urlencode($currentActionFieldValue).'">'.$cell.'</a>'; |
|
298 | - } |
|
299 | - return $cell; |
|
300 | - } |
|
301 | - |
|
302 | - /** |
|
303 | - * Sets an option to generate a check all link when checkbox is indicated |
|
304 | - * as the table formElementType. |
|
305 | - */ |
|
306 | - function setAllOption() { |
|
307 | - $this->allOption= 1; |
|
308 | - } |
|
309 | - |
|
310 | - /** |
|
311 | - * Function to prepare a link generated in the table cell/link actions. |
|
312 | - * |
|
313 | - * @param $value Indicates the INPUT form element type attribute. |
|
314 | - */ |
|
315 | - function prepareLink($link) { |
|
316 | - if (strstr($link, '?')) { |
|
317 | - $end= '&'; |
|
318 | - } else { |
|
319 | - $end= '?'; |
|
320 | - } |
|
321 | - return $link.$end; |
|
322 | - } |
|
323 | - |
|
324 | - /** |
|
325 | - * Generates the table content. |
|
326 | - * |
|
327 | - * @param $fieldsArray The associative array representing the table rows |
|
328 | - * and columns. |
|
329 | - * @param $fieldHeadersArray An optional array of values for providing |
|
330 | - * alternative field headers; this is an associative arrays of keys from |
|
331 | - * the $fieldsArray where the values represent the alt heading content |
|
332 | - * for each column. |
|
333 | - */ |
|
334 | - function create($fieldsArray, $fieldHeadersArray=array(),$linkpage="") { |
|
335 | - global $_lang; |
|
336 | - if (is_array($fieldsArray)) { |
|
337 | - $i= 0; |
|
338 | - foreach ($fieldsArray as $fieldName => $fieldValue) { |
|
339 | - $table .= "\t<tr".$this->determineRowClass($i).">\n"; |
|
340 | - $currentActionFieldValue= $fieldValue[$this->actionField]; |
|
341 | - if (is_array($this->selectedValues)) { |
|
342 | - $isChecked= array_search($currentActionFieldValue, $this->selectedValues)===false? 0 : 1; |
|
343 | - } else { |
|
344 | - $isChecked= false; |
|
345 | - } |
|
346 | - $table .= $this->addFormField($currentActionFieldValue, $isChecked); |
|
347 | - $colPosition= 0; |
|
348 | - foreach ($fieldValue as $key => $value) { |
|
349 | - if (!in_array($key, $this->excludeFields)) { |
|
350 | - $table .= "\t\t<td".$this->getCellAction($currentActionFieldValue).">"; |
|
351 | - $table .= $this->createCellText($currentActionFieldValue, $value); |
|
352 | - $table .= "</td>\n"; |
|
353 | - if ($i == 0) { |
|
354 | - if (empty ($header) && $this->formElementType) { |
|
355 | - $header .= "\t\t<th style=\"width:32px\" ".($this->thClass ? 'class="'.$this->thClass.'"' : '').">". ($this->allOption ? '<a href="javascript:clickAll()">all</a>' : '')."</th>\n"; |
|
356 | - } |
|
357 | - $headerText= array_key_exists($key, $fieldHeadersArray)? $fieldHeadersArray[$key]: $key; |
|
358 | - $header .= "\t\t<th".$this->getColumnWidth($colPosition).($this->thClass ? ' class="'.$this->thClass.'" ' : '').">".$headerText."</th>\n"; |
|
359 | - } |
|
360 | - $colPosition ++; |
|
361 | - } |
|
362 | - } |
|
363 | - $i ++; |
|
364 | - $table .= "\t</tr>\n"; |
|
365 | - } |
|
366 | - $table= "\n".'<table'. ($this->tableWidth ? ' width="'.$this->tableWidth.'"' : ''). ($this->tableClass ? ' class="'.$this->tableClass.'"' : ''). ($this->tableID ? ' id="'.$this->tableID.'"' : '').">\n". ($header ? "\t<thead>\n\t<tr class=\"".$this->rowHeaderClass."\">\n".$header."\t</tr>\n\t</thead>\n" : '').$table."</table>\n"; |
|
367 | - if ($this->formElementType) { |
|
368 | - $table= "\n".'<form id="'.$this->formName.'" name="'.$this->formName.'" action="'.$this->formAction.'" method="POST">'.$table; |
|
369 | - } |
|
370 | - if (strlen($this->pageNav) > 1) {//changed to display the pagination if exists. |
|
371 | - /* commented this part because of cookie |
|
12 | + var $actionField; |
|
13 | + var $cellAction; |
|
14 | + var $linkAction; |
|
15 | + var $tableWidth; |
|
16 | + var $tableClass; |
|
17 | + var $tableID; |
|
18 | + var $thClass; |
|
19 | + var $rowHeaderClass; |
|
20 | + var $columnHeaderClass; |
|
21 | + var $rowRegularClass; |
|
22 | + var $rowAlternateClass; |
|
23 | + var $formName; |
|
24 | + var $formAction; |
|
25 | + var $formElementType; |
|
26 | + var $formElementName; |
|
27 | + var $rowAlternatingScheme; |
|
28 | + var $excludeFields; |
|
29 | + var $allOption; |
|
30 | + var $pageNav; |
|
31 | + var $columnWidths; |
|
32 | + var $selectedValues; |
|
33 | + |
|
34 | + function __construct() { |
|
35 | + $this->fieldHeaders= array(); |
|
36 | + $this->excludeFields= array(); |
|
37 | + $this->actionField= ''; |
|
38 | + $this->cellAction= ''; |
|
39 | + $this->linkAction= ''; |
|
40 | + $this->tableWidth= ''; |
|
41 | + $this->tableClass= ''; |
|
42 | + $this->rowHeaderClass= ''; |
|
43 | + $this->columnHeaderClass= ''; |
|
44 | + $this->rowRegularClass= ''; |
|
45 | + $this->rowAlternateClass= 'alt'; |
|
46 | + $this->formName= 'tableForm'; |
|
47 | + $this->formAction= '[~[*id*]~]'; |
|
48 | + $this->formElementName= ''; |
|
49 | + $this->formElementType= ''; |
|
50 | + $this->rowAlternatingScheme= 'EVEN'; |
|
51 | + $this->allOption= 0; |
|
52 | + $this->selectedValues= array(); |
|
53 | + $this->extra= ''; |
|
54 | + } |
|
55 | + |
|
56 | + /** |
|
57 | + * Sets the default link href for all cells in the table. |
|
58 | + * |
|
59 | + * @param $value A URL to execute when table cells are clicked. |
|
60 | + */ |
|
61 | + function setCellAction($value) { |
|
62 | + $this->cellAction= $this->prepareLink($value); |
|
63 | + } |
|
64 | + |
|
65 | + /** |
|
66 | + * Sets the default link href for the text presented in a cell. |
|
67 | + * |
|
68 | + * @param $value A URL to execute when text within table cells are clicked. |
|
69 | + */ |
|
70 | + function setLinkAction($value) { |
|
71 | + $this->linkAction= $this->prepareLink($value); |
|
72 | + } |
|
73 | + |
|
74 | + /** |
|
75 | + * Sets the width attribute of the main HTML TABLE. |
|
76 | + * |
|
77 | + * @param $value A valid width attribute for the HTML TABLE tag |
|
78 | + */ |
|
79 | + function setTableWidth($value) { |
|
80 | + $this->tableWidth= $value; |
|
81 | + } |
|
82 | + |
|
83 | + /** |
|
84 | + * Sets the class attribute of the main HTML TABLE. |
|
85 | + * |
|
86 | + * @param $value A class for the main HTML TABLE. |
|
87 | + */ |
|
88 | + function setTableClass($value) { |
|
89 | + $this->tableClass= $value; |
|
90 | + } |
|
91 | + |
|
92 | + /** |
|
93 | + * Sets the id attribute of the main HTML TABLE. |
|
94 | + * |
|
95 | + * @param $value A class for the main HTML TABLE. |
|
96 | + */ |
|
97 | + function setTableID($value) { |
|
98 | + $this->tableID= $value; |
|
99 | + } |
|
100 | + |
|
101 | + /** |
|
102 | + * Sets the class attribute of the table header row. |
|
103 | + * |
|
104 | + * @param $value A class for the table header row. |
|
105 | + */ |
|
106 | + function setRowHeaderClass($value) { |
|
107 | + $this->rowHeaderClass= $value; |
|
108 | + } |
|
109 | + |
|
110 | + /** |
|
111 | + * Sets the class attribute of the table header row. |
|
112 | + * |
|
113 | + * @param $value A class for the table header row. |
|
114 | + */ |
|
115 | + function setThHeaderClass($value) { |
|
116 | + $this->thClass= $value; |
|
117 | + } |
|
118 | + |
|
119 | + /** |
|
120 | + * Sets the class attribute of the column header row. |
|
121 | + * |
|
122 | + * @param $value A class for the column header row. |
|
123 | + */ |
|
124 | + function setColumnHeaderClass($value) { |
|
125 | + $this->columnHeaderClass= $value; |
|
126 | + } |
|
127 | + |
|
128 | + /** |
|
129 | + * Sets the class attribute of regular table rows. |
|
130 | + * |
|
131 | + * @param $value A class for regular table rows. |
|
132 | + */ |
|
133 | + function setRowRegularClass($value) { |
|
134 | + $this->rowRegularClass= $value; |
|
135 | + } |
|
136 | + |
|
137 | + /** |
|
138 | + * Sets the class attribute of alternate table rows. |
|
139 | + * |
|
140 | + * @param $value A class for alternate table rows. |
|
141 | + */ |
|
142 | + function setRowAlternateClass($value) { |
|
143 | + $this->rowAlternateClass= $value; |
|
144 | + } |
|
145 | + |
|
146 | + /** |
|
147 | + * Sets the type of INPUT form element to be presented as the first column. |
|
148 | + * |
|
149 | + * @param $value Indicates the INPUT form element type attribute. |
|
150 | + */ |
|
151 | + function setFormElementType($value) { |
|
152 | + $this->formElementType= $value; |
|
153 | + } |
|
154 | + |
|
155 | + /** |
|
156 | + * Sets the name of the INPUT form element to be presented as the first column. |
|
157 | + * |
|
158 | + * @param $value Indicates the INPUT form element name attribute. |
|
159 | + */ |
|
160 | + function setFormElementName($value) { |
|
161 | + $this->formElementName= $value; |
|
162 | + } |
|
163 | + |
|
164 | + /** |
|
165 | + * Sets the name of the FORM to wrap the table in when a form element has |
|
166 | + * been indicated. |
|
167 | + * |
|
168 | + * @param $value Indicates the FORM name attribute. |
|
169 | + */ |
|
170 | + function setFormName($value) { |
|
171 | + $this->formName= $value; |
|
172 | + } |
|
173 | + |
|
174 | + /** |
|
175 | + * Sets the action of the FORM element. |
|
176 | + * |
|
177 | + * @param $value Indicates the FORM action attribute. |
|
178 | + */ |
|
179 | + function setFormAction($value) { |
|
180 | + $this->formAction= $value; |
|
181 | + } |
|
182 | + |
|
183 | + /** |
|
184 | + * Excludes fields from the table by array key. |
|
185 | + * |
|
186 | + * @param $value An Array of field keys to exclude from the table. |
|
187 | + */ |
|
188 | + function setExcludeFields($value) { |
|
189 | + $this->excludeFields= $value; |
|
190 | + } |
|
191 | + |
|
192 | + /** |
|
193 | + * Sets the table to provide alternate row colors using ODD or EVEN rows |
|
194 | + * |
|
195 | + * @param $value 'ODD' or 'EVEN' to indicate the alternate row scheme. |
|
196 | + */ |
|
197 | + function setRowAlternatingScheme($value) { |
|
198 | + $this->rowAlternatingScheme= $value; |
|
199 | + } |
|
200 | + |
|
201 | + /** |
|
202 | + * Sets the default field value to be used when appending query parameters |
|
203 | + * to link actions. |
|
204 | + * |
|
205 | + * @param $value The key of the field to add as a query string parameter. |
|
206 | + */ |
|
207 | + function setActionFieldName($value) { |
|
208 | + $this->actionField= $value; |
|
209 | + } |
|
210 | + |
|
211 | + /** |
|
212 | + * Sets the width attribute of each column in the array. |
|
213 | + * |
|
214 | + * @param $value An Array of column widths in the order of the keys in the |
|
215 | + * source table array. |
|
216 | + */ |
|
217 | + function setColumnWidths($widthArray) { |
|
218 | + $this->columnWidths= $widthArray; |
|
219 | + } |
|
220 | + |
|
221 | + /** |
|
222 | + * An optional array of values that can be preselected when using |
|
223 | + * |
|
224 | + * @param $value Indicates the INPUT form element type attribute. |
|
225 | + */ |
|
226 | + function setSelectedValues($valueArray) { |
|
227 | + $this->selectedValues= $valueArray; |
|
228 | + } |
|
229 | + |
|
230 | + /** |
|
231 | + * Sets extra content to be presented following the table (but within |
|
232 | + * the form, if a form is being rendered with the table). |
|
233 | + * |
|
234 | + * @param $value A string of additional content. |
|
235 | + */ |
|
236 | + function setExtra($value) { |
|
237 | + $this->extra= $value; |
|
238 | + } |
|
239 | + |
|
240 | + /** |
|
241 | + * Retrieves the width of a specific table column by index position. |
|
242 | + * |
|
243 | + * @param $columnPosition The index of the column to get the width for. |
|
244 | + */ |
|
245 | + function getColumnWidth($columnPosition) { |
|
246 | + $currentWidth= ''; |
|
247 | + if (is_array($this->columnWidths)) { |
|
248 | + $currentWidth= $this->columnWidths[$columnPosition] ? ' width="'.$this->columnWidths[$columnPosition].'" ' : ''; |
|
249 | + } |
|
250 | + return $currentWidth; |
|
251 | + } |
|
252 | + |
|
253 | + /** |
|
254 | + * Determines what class the current row should have applied. |
|
255 | + * |
|
256 | + * @param $value The position of the current row being rendered. |
|
257 | + */ |
|
258 | + function determineRowClass($position) { |
|
259 | + switch ($this->rowAlternatingScheme) { |
|
260 | + case 'ODD' : |
|
261 | + $modRemainder= 1; |
|
262 | + break; |
|
263 | + case 'EVEN' : |
|
264 | + $modRemainder= 0; |
|
265 | + break; |
|
266 | + } |
|
267 | + if ($position % 2 == $modRemainder) { |
|
268 | + $currentClass= $this->rowRegularClass; |
|
269 | + } else { |
|
270 | + $currentClass= $this->rowAlternateClass; |
|
271 | + } |
|
272 | + return ' class="'.$currentClass.'"'; |
|
273 | + } |
|
274 | + |
|
275 | + /** |
|
276 | + * Generates an onclick action applied to the current cell, to execute |
|
277 | + * any specified cell actions. |
|
278 | + * |
|
279 | + * @param $value Indicates the INPUT form element type attribute. |
|
280 | + */ |
|
281 | + function getCellAction($currentActionFieldValue) { |
|
282 | + if ($this->cellAction) { |
|
283 | + $cellAction= ' onClick="javascript:window.location=\''.$this->cellAction.$this->actionField.'='.urlencode($currentActionFieldValue).'\'" '; |
|
284 | + } |
|
285 | + return $cellAction; |
|
286 | + } |
|
287 | + |
|
288 | + /** |
|
289 | + * Generates the cell content, including any specified action fields values. |
|
290 | + * |
|
291 | + * @param $currentActionFieldValue The value to be applied to the link action. |
|
292 | + * @param $value The value of the cell. |
|
293 | + */ |
|
294 | + function createCellText($currentActionFieldValue, $value) { |
|
295 | + $cell .= $value; |
|
296 | + if ($this->linkAction) { |
|
297 | + $cell= '<a href="'.$this->linkAction.$this->actionField.'='.urlencode($currentActionFieldValue).'">'.$cell.'</a>'; |
|
298 | + } |
|
299 | + return $cell; |
|
300 | + } |
|
301 | + |
|
302 | + /** |
|
303 | + * Sets an option to generate a check all link when checkbox is indicated |
|
304 | + * as the table formElementType. |
|
305 | + */ |
|
306 | + function setAllOption() { |
|
307 | + $this->allOption= 1; |
|
308 | + } |
|
309 | + |
|
310 | + /** |
|
311 | + * Function to prepare a link generated in the table cell/link actions. |
|
312 | + * |
|
313 | + * @param $value Indicates the INPUT form element type attribute. |
|
314 | + */ |
|
315 | + function prepareLink($link) { |
|
316 | + if (strstr($link, '?')) { |
|
317 | + $end= '&'; |
|
318 | + } else { |
|
319 | + $end= '?'; |
|
320 | + } |
|
321 | + return $link.$end; |
|
322 | + } |
|
323 | + |
|
324 | + /** |
|
325 | + * Generates the table content. |
|
326 | + * |
|
327 | + * @param $fieldsArray The associative array representing the table rows |
|
328 | + * and columns. |
|
329 | + * @param $fieldHeadersArray An optional array of values for providing |
|
330 | + * alternative field headers; this is an associative arrays of keys from |
|
331 | + * the $fieldsArray where the values represent the alt heading content |
|
332 | + * for each column. |
|
333 | + */ |
|
334 | + function create($fieldsArray, $fieldHeadersArray=array(),$linkpage="") { |
|
335 | + global $_lang; |
|
336 | + if (is_array($fieldsArray)) { |
|
337 | + $i= 0; |
|
338 | + foreach ($fieldsArray as $fieldName => $fieldValue) { |
|
339 | + $table .= "\t<tr".$this->determineRowClass($i).">\n"; |
|
340 | + $currentActionFieldValue= $fieldValue[$this->actionField]; |
|
341 | + if (is_array($this->selectedValues)) { |
|
342 | + $isChecked= array_search($currentActionFieldValue, $this->selectedValues)===false? 0 : 1; |
|
343 | + } else { |
|
344 | + $isChecked= false; |
|
345 | + } |
|
346 | + $table .= $this->addFormField($currentActionFieldValue, $isChecked); |
|
347 | + $colPosition= 0; |
|
348 | + foreach ($fieldValue as $key => $value) { |
|
349 | + if (!in_array($key, $this->excludeFields)) { |
|
350 | + $table .= "\t\t<td".$this->getCellAction($currentActionFieldValue).">"; |
|
351 | + $table .= $this->createCellText($currentActionFieldValue, $value); |
|
352 | + $table .= "</td>\n"; |
|
353 | + if ($i == 0) { |
|
354 | + if (empty ($header) && $this->formElementType) { |
|
355 | + $header .= "\t\t<th style=\"width:32px\" ".($this->thClass ? 'class="'.$this->thClass.'"' : '').">". ($this->allOption ? '<a href="javascript:clickAll()">all</a>' : '')."</th>\n"; |
|
356 | + } |
|
357 | + $headerText= array_key_exists($key, $fieldHeadersArray)? $fieldHeadersArray[$key]: $key; |
|
358 | + $header .= "\t\t<th".$this->getColumnWidth($colPosition).($this->thClass ? ' class="'.$this->thClass.'" ' : '').">".$headerText."</th>\n"; |
|
359 | + } |
|
360 | + $colPosition ++; |
|
361 | + } |
|
362 | + } |
|
363 | + $i ++; |
|
364 | + $table .= "\t</tr>\n"; |
|
365 | + } |
|
366 | + $table= "\n".'<table'. ($this->tableWidth ? ' width="'.$this->tableWidth.'"' : ''). ($this->tableClass ? ' class="'.$this->tableClass.'"' : ''). ($this->tableID ? ' id="'.$this->tableID.'"' : '').">\n". ($header ? "\t<thead>\n\t<tr class=\"".$this->rowHeaderClass."\">\n".$header."\t</tr>\n\t</thead>\n" : '').$table."</table>\n"; |
|
367 | + if ($this->formElementType) { |
|
368 | + $table= "\n".'<form id="'.$this->formName.'" name="'.$this->formName.'" action="'.$this->formAction.'" method="POST">'.$table; |
|
369 | + } |
|
370 | + if (strlen($this->pageNav) > 1) {//changed to display the pagination if exists. |
|
371 | + /* commented this part because of cookie |
|
372 | 372 | $table .= '<div id="max-display-records" ><select style="display:inline" onchange="javascript:updatePageSize(this[this.selectedIndex].value);">'; |
373 | 373 | $pageSizes= array (10, 25, 50, 100, 250); |
374 | 374 | for ($i= 0; $i < count($pageSizes); $i ++) { |
@@ -379,12 +379,12 @@ discard block |
||
379 | 379 | |
380 | 380 | $table .= '</select>'.$_lang["pagination_table_perpage"].'</div>'; |
381 | 381 | */ |
382 | - $table .= '<div id="pagination" class="paginate">'.$_lang["pagination_table_gotopage"].'<ul>'.$this->pageNav.'</ul></div>'; |
|
383 | - //$table .= '<script language="javascript">function updatePageSize(size){window.location = \''.$this->prepareLink($linkpage).'pageSize=\'+size;}</script>'; |
|
382 | + $table .= '<div id="pagination" class="paginate">'.$_lang["pagination_table_gotopage"].'<ul>'.$this->pageNav.'</ul></div>'; |
|
383 | + //$table .= '<script language="javascript">function updatePageSize(size){window.location = \''.$this->prepareLink($linkpage).'pageSize=\'+size;}</script>'; |
|
384 | 384 | |
385 | - } |
|
386 | - if ($this->allOption) { |
|
387 | - $table .= ' |
|
385 | + } |
|
386 | + if ($this->allOption) { |
|
387 | + $table .= ' |
|
388 | 388 | <script language="javascript"> |
389 | 389 | toggled = 0; |
390 | 390 | function clickAll() { |
@@ -397,134 +397,134 @@ discard block |
||
397 | 397 | toggled = (toggled?0:1); |
398 | 398 | } |
399 | 399 | </script>'; |
400 | - } |
|
401 | - if ($this->formElementType) { |
|
402 | - if ($this->extra) { |
|
403 | - $table.= "\n".$this->extra."\n"; |
|
404 | - } |
|
405 | - $table.= "\n".'</form>'."\n"; |
|
406 | - } |
|
407 | - return $table; |
|
408 | - } |
|
409 | - } |
|
410 | - |
|
411 | - /** |
|
412 | - * Generates optional paging navigation controls for the table. |
|
413 | - * |
|
414 | - * @param $numRecords The number of records to show per page. |
|
415 | - * @param $qs An optional query string to be appended to the paging links |
|
416 | - */ |
|
417 | - function createPagingNavigation($numRecords, $qs='') { |
|
418 | - global $_lang; |
|
419 | - $currentPage= (is_numeric($_GET['page']) ? $_GET['page'] : 1); |
|
420 | - $numPages= ceil($numRecords / MAX_DISPLAY_RECORDS_NUM); |
|
421 | - if ($numPages > 1) { |
|
422 | - $currentURL= empty($qs)? '': '?'.$qs; |
|
423 | - if ($currentPage > 6) { |
|
424 | - $nav .= $this->createPageLink($currentURL, 1, $_lang["pagination_table_first"]); |
|
425 | - } |
|
426 | - if ($currentPage != 1) { |
|
427 | - $nav .= $this->createPageLink($currentURL, $currentPage -1, '<<'); |
|
428 | - } |
|
429 | - $offset= -4 + ($currentPage < 5 ? (5 - $currentPage) : 0); |
|
430 | - $i= 1; |
|
431 | - while ($i < 10 && ($currentPage + $offset <= $numPages)) { |
|
432 | - if ($currentPage == $currentPage + $offset) |
|
433 | - $nav .= $this->createPageLink($currentURL, $currentPage + $offset, $currentPage + $offset, true); |
|
434 | - else |
|
435 | - $nav .= $this->createPageLink($currentURL, $currentPage + $offset, $currentPage + $offset); |
|
436 | - $i ++; |
|
437 | - $offset ++; |
|
438 | - } |
|
439 | - if ($currentPage < $numPages) { |
|
440 | - $nav .= $this->createPageLink($currentURL, $currentPage +1, '>>'); |
|
441 | - } |
|
442 | - if ($currentPage != $numPages) { |
|
443 | - $nav .= $this->createPageLink($currentURL, $numPages, $_lang["pagination_table_last"]); |
|
444 | - } |
|
445 | - } |
|
446 | - $this->pageNav= ' '.$nav; |
|
447 | - } |
|
448 | - |
|
449 | - /** |
|
450 | - * Creates an individual page link for the paging navigation. |
|
451 | - * |
|
452 | - * @param $link The link for the page, defaulted to the current document. |
|
453 | - * @param $pageNum The page number of the link. |
|
454 | - * @param $displayText The text of the link. |
|
455 | - * @param $currentPage Indicates if the link is to the current page. |
|
456 | - * @param $qs And optional query string to be appended to the link. |
|
457 | - */ |
|
458 | - function createPageLink($link='', $pageNum, $displayText, $currentPage=false, $qs='') { |
|
459 | - global $modx; |
|
460 | - $orderBy= !empty($_GET['orderby'])? '&orderby=' . $_GET['orderby']: ''; |
|
461 | - $orderDir= !empty($_GET['orderdir'])? '&orderdir=' . $_GET['orderdir']: ''; |
|
462 | - if (!empty($qs)) $qs= "?$qs"; |
|
463 | - $link= empty($link)? $modx->makeUrl($modx->documentIdentifier, $modx->documentObject['alias'], $qs . "page=$pageNum$orderBy$orderDir"): $this->prepareLink($link) . "page=$pageNum"; |
|
464 | - $nav .= '<li'.($currentPage? ' class="currentPage"': '').'><a'.($currentPage? ' class="currentPage"': '').' href="'.$link.'">'.$displayText.'</a></li>'."\n"; |
|
465 | - return $nav; |
|
466 | - } |
|
467 | - |
|
468 | - /** |
|
469 | - * Adds an INPUT form element column to the table. |
|
470 | - * |
|
471 | - * @param $value The value attribute of the element. |
|
472 | - * @param $isChecked Indicates if the checked attribute should apply to the |
|
473 | - * element. |
|
474 | - */ |
|
475 | - function addFormField($value, $isChecked) { |
|
476 | - if ($this->formElementType) { |
|
477 | - $checked= $isChecked? "checked ": ""; |
|
478 | - $field= "\t\t".'<td><input type="'.$this->formElementType.'" name="'. ($this->formElementName ? $this->formElementName : $value).'" value="'.$value.'" '.$checked.'/></td>'."\n"; |
|
479 | - } |
|
480 | - return $field; |
|
481 | - } |
|
482 | - |
|
483 | - /** |
|
484 | - * Generates the proper LIMIT clause for queries to retrieve paged results in |
|
485 | - * a MakeTable $fieldsArray. |
|
486 | - */ |
|
487 | - function handlePaging() { |
|
488 | - $offset= (is_numeric($_GET['page']) && $_GET['page'] > 0) ? $_GET['page'] - 1 : 0; |
|
489 | - $limitClause= ' LIMIT '. ($offset * MAX_DISPLAY_RECORDS_NUM).', '.MAX_DISPLAY_RECORDS_NUM; |
|
490 | - return $limitClause; |
|
491 | - } |
|
492 | - |
|
493 | - /** |
|
494 | - * Generates the SORT BY clause for queries used to retrieve a MakeTable |
|
495 | - * $fieldsArray |
|
496 | - * |
|
497 | - * @param $natural_order If true, the results are returned in natural order. |
|
498 | - */ |
|
499 | - function handleSorting($natural_order=false) { |
|
500 | - $orderByClause= ''; |
|
501 | - if (!$natural_order) { |
|
502 | - $orderby= !empty($_GET['orderby'])? $_GET['orderby']: "id"; |
|
503 | - $orderdir= !empty($_GET['orderdir'])? $_GET['orderdir']: "DESC"; |
|
504 | - $orderbyClause= !empty($orderby)? ' ORDER BY ' . $orderby . ' ' . $orderdir . ' ': ""; |
|
505 | - } |
|
506 | - return $orderbyClause; |
|
507 | - } |
|
508 | - |
|
509 | - /** |
|
510 | - * Generates a link to order by a specific $fieldsArray key; use to generate |
|
511 | - * sort by links in the MakeTable $fieldHeadingsArray values. |
|
512 | - * |
|
513 | - * @param $key The $fieldsArray key for the column to sort by. |
|
514 | - * @param $text The text for the link (e.g. table column header). |
|
515 | - * @param $qs An optional query string to append to the order by link. |
|
516 | - */ |
|
517 | - function prepareOrderByLink($key, $text, $qs='') { |
|
518 | - global $modx; |
|
519 | - if (!empty($_GET['orderdir'])) { |
|
520 | - $orderDir= strtolower($_GET['orderdir'])=='desc'? '&orderdir=asc': '&orderdir=desc'; |
|
521 | - } else { |
|
522 | - $orderDir= '&orderdir=asc'; |
|
523 | - } |
|
524 | - if (!empty($qs)) { |
|
525 | - if (!strrpos($qs, '&')==strlen($qs)-1) $qs.= '&'; |
|
526 | - } |
|
527 | - return '<a href="[~'.$modx->documentIdentifier.'~]?'.$qs.'orderby='.$key.$orderDir.'">'.$text.'</a>'; |
|
528 | - } |
|
400 | + } |
|
401 | + if ($this->formElementType) { |
|
402 | + if ($this->extra) { |
|
403 | + $table.= "\n".$this->extra."\n"; |
|
404 | + } |
|
405 | + $table.= "\n".'</form>'."\n"; |
|
406 | + } |
|
407 | + return $table; |
|
408 | + } |
|
409 | + } |
|
410 | + |
|
411 | + /** |
|
412 | + * Generates optional paging navigation controls for the table. |
|
413 | + * |
|
414 | + * @param $numRecords The number of records to show per page. |
|
415 | + * @param $qs An optional query string to be appended to the paging links |
|
416 | + */ |
|
417 | + function createPagingNavigation($numRecords, $qs='') { |
|
418 | + global $_lang; |
|
419 | + $currentPage= (is_numeric($_GET['page']) ? $_GET['page'] : 1); |
|
420 | + $numPages= ceil($numRecords / MAX_DISPLAY_RECORDS_NUM); |
|
421 | + if ($numPages > 1) { |
|
422 | + $currentURL= empty($qs)? '': '?'.$qs; |
|
423 | + if ($currentPage > 6) { |
|
424 | + $nav .= $this->createPageLink($currentURL, 1, $_lang["pagination_table_first"]); |
|
425 | + } |
|
426 | + if ($currentPage != 1) { |
|
427 | + $nav .= $this->createPageLink($currentURL, $currentPage -1, '<<'); |
|
428 | + } |
|
429 | + $offset= -4 + ($currentPage < 5 ? (5 - $currentPage) : 0); |
|
430 | + $i= 1; |
|
431 | + while ($i < 10 && ($currentPage + $offset <= $numPages)) { |
|
432 | + if ($currentPage == $currentPage + $offset) |
|
433 | + $nav .= $this->createPageLink($currentURL, $currentPage + $offset, $currentPage + $offset, true); |
|
434 | + else |
|
435 | + $nav .= $this->createPageLink($currentURL, $currentPage + $offset, $currentPage + $offset); |
|
436 | + $i ++; |
|
437 | + $offset ++; |
|
438 | + } |
|
439 | + if ($currentPage < $numPages) { |
|
440 | + $nav .= $this->createPageLink($currentURL, $currentPage +1, '>>'); |
|
441 | + } |
|
442 | + if ($currentPage != $numPages) { |
|
443 | + $nav .= $this->createPageLink($currentURL, $numPages, $_lang["pagination_table_last"]); |
|
444 | + } |
|
445 | + } |
|
446 | + $this->pageNav= ' '.$nav; |
|
447 | + } |
|
448 | + |
|
449 | + /** |
|
450 | + * Creates an individual page link for the paging navigation. |
|
451 | + * |
|
452 | + * @param $link The link for the page, defaulted to the current document. |
|
453 | + * @param $pageNum The page number of the link. |
|
454 | + * @param $displayText The text of the link. |
|
455 | + * @param $currentPage Indicates if the link is to the current page. |
|
456 | + * @param $qs And optional query string to be appended to the link. |
|
457 | + */ |
|
458 | + function createPageLink($link='', $pageNum, $displayText, $currentPage=false, $qs='') { |
|
459 | + global $modx; |
|
460 | + $orderBy= !empty($_GET['orderby'])? '&orderby=' . $_GET['orderby']: ''; |
|
461 | + $orderDir= !empty($_GET['orderdir'])? '&orderdir=' . $_GET['orderdir']: ''; |
|
462 | + if (!empty($qs)) $qs= "?$qs"; |
|
463 | + $link= empty($link)? $modx->makeUrl($modx->documentIdentifier, $modx->documentObject['alias'], $qs . "page=$pageNum$orderBy$orderDir"): $this->prepareLink($link) . "page=$pageNum"; |
|
464 | + $nav .= '<li'.($currentPage? ' class="currentPage"': '').'><a'.($currentPage? ' class="currentPage"': '').' href="'.$link.'">'.$displayText.'</a></li>'."\n"; |
|
465 | + return $nav; |
|
466 | + } |
|
467 | + |
|
468 | + /** |
|
469 | + * Adds an INPUT form element column to the table. |
|
470 | + * |
|
471 | + * @param $value The value attribute of the element. |
|
472 | + * @param $isChecked Indicates if the checked attribute should apply to the |
|
473 | + * element. |
|
474 | + */ |
|
475 | + function addFormField($value, $isChecked) { |
|
476 | + if ($this->formElementType) { |
|
477 | + $checked= $isChecked? "checked ": ""; |
|
478 | + $field= "\t\t".'<td><input type="'.$this->formElementType.'" name="'. ($this->formElementName ? $this->formElementName : $value).'" value="'.$value.'" '.$checked.'/></td>'."\n"; |
|
479 | + } |
|
480 | + return $field; |
|
481 | + } |
|
482 | + |
|
483 | + /** |
|
484 | + * Generates the proper LIMIT clause for queries to retrieve paged results in |
|
485 | + * a MakeTable $fieldsArray. |
|
486 | + */ |
|
487 | + function handlePaging() { |
|
488 | + $offset= (is_numeric($_GET['page']) && $_GET['page'] > 0) ? $_GET['page'] - 1 : 0; |
|
489 | + $limitClause= ' LIMIT '. ($offset * MAX_DISPLAY_RECORDS_NUM).', '.MAX_DISPLAY_RECORDS_NUM; |
|
490 | + return $limitClause; |
|
491 | + } |
|
492 | + |
|
493 | + /** |
|
494 | + * Generates the SORT BY clause for queries used to retrieve a MakeTable |
|
495 | + * $fieldsArray |
|
496 | + * |
|
497 | + * @param $natural_order If true, the results are returned in natural order. |
|
498 | + */ |
|
499 | + function handleSorting($natural_order=false) { |
|
500 | + $orderByClause= ''; |
|
501 | + if (!$natural_order) { |
|
502 | + $orderby= !empty($_GET['orderby'])? $_GET['orderby']: "id"; |
|
503 | + $orderdir= !empty($_GET['orderdir'])? $_GET['orderdir']: "DESC"; |
|
504 | + $orderbyClause= !empty($orderby)? ' ORDER BY ' . $orderby . ' ' . $orderdir . ' ': ""; |
|
505 | + } |
|
506 | + return $orderbyClause; |
|
507 | + } |
|
508 | + |
|
509 | + /** |
|
510 | + * Generates a link to order by a specific $fieldsArray key; use to generate |
|
511 | + * sort by links in the MakeTable $fieldHeadingsArray values. |
|
512 | + * |
|
513 | + * @param $key The $fieldsArray key for the column to sort by. |
|
514 | + * @param $text The text for the link (e.g. table column header). |
|
515 | + * @param $qs An optional query string to append to the order by link. |
|
516 | + */ |
|
517 | + function prepareOrderByLink($key, $text, $qs='') { |
|
518 | + global $modx; |
|
519 | + if (!empty($_GET['orderdir'])) { |
|
520 | + $orderDir= strtolower($_GET['orderdir'])=='desc'? '&orderdir=asc': '&orderdir=desc'; |
|
521 | + } else { |
|
522 | + $orderDir= '&orderdir=asc'; |
|
523 | + } |
|
524 | + if (!empty($qs)) { |
|
525 | + if (!strrpos($qs, '&')==strlen($qs)-1) $qs.= '&'; |
|
526 | + } |
|
527 | + return '<a href="[~'.$modx->documentIdentifier.'~]?'.$qs.'orderby='.$key.$orderDir.'">'.$text.'</a>'; |
|
528 | + } |
|
529 | 529 | |
530 | 530 | } |
@@ -11,18 +11,18 @@ |
||
11 | 11 | */ |
12 | 12 | |
13 | 13 | function secureWebDocument($docid='') { |
14 | - global $modx; |
|
14 | + global $modx; |
|
15 | 15 | |
16 | - $modx->db->update('privateweb = 0', $modx->getFullTableName("site_content"), ($docid>0 ? "id='$docid'":"privateweb = 1")); |
|
17 | - $rs = $modx->db->select( |
|
18 | - 'DISTINCT sc.id', |
|
19 | - $modx->getFullTableName("site_content")." sc |
|
16 | + $modx->db->update('privateweb = 0', $modx->getFullTableName("site_content"), ($docid>0 ? "id='$docid'":"privateweb = 1")); |
|
17 | + $rs = $modx->db->select( |
|
18 | + 'DISTINCT sc.id', |
|
19 | + $modx->getFullTableName("site_content")." sc |
|
20 | 20 | LEFT JOIN ".$modx->getFullTableName("document_groups")." dg ON dg.document = sc.id |
21 | 21 | LEFT JOIN ".$modx->getFullTableName("webgroup_access")." wga ON wga.documentgroup = dg.document_group", |
22 | - ($docid>0 ? " sc.id='{$docid}' AND ":"")."wga.id>0" |
|
23 | - ); |
|
24 | - $ids = $modx->db->getColumn("id",$rs); |
|
25 | - if(count($ids)>0) { |
|
26 | - $modx->db->update('privateweb = 1', $modx->getFullTableName("site_content"), "id IN (".implode(", ",$ids).")"); |
|
27 | - } |
|
22 | + ($docid>0 ? " sc.id='{$docid}' AND ":"")."wga.id>0" |
|
23 | + ); |
|
24 | + $ids = $modx->db->getColumn("id",$rs); |
|
25 | + if(count($ids)>0) { |
|
26 | + $modx->db->update('privateweb = 1', $modx->getFullTableName("site_content"), "id IN (".implode(", ",$ids).")"); |
|
27 | + } |
|
28 | 28 | } |
@@ -9,7 +9,7 @@ |
||
9 | 9 | |
10 | 10 | // ajax response |
11 | 11 | if (isset($_POST['updateMsgCount'])) { |
12 | - header("Content-Type: application/json; charset=utf-8"); |
|
13 | - print $nrnewmessages.','.$nrtotalmessages; |
|
14 | - exit; |
|
12 | + header("Content-Type: application/json; charset=utf-8"); |
|
13 | + print $nrnewmessages.','.$nrtotalmessages; |
|
14 | + exit; |
|
15 | 15 | } |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | |
23 | 23 | // load template |
24 | 24 | if(!isset($modx->config['manager_lockout_tpl']) || empty($modx->config['manager_lockout_tpl'])) { |
25 | - $modx->config['manager_lockout_tpl'] = MODX_MANAGER_PATH . 'media/style/common/manager.lockout.tpl'; |
|
25 | + $modx->config['manager_lockout_tpl'] = MODX_MANAGER_PATH . 'media/style/common/manager.lockout.tpl'; |
|
26 | 26 | } |
27 | 27 | |
28 | 28 | $target = $modx->config['manager_lockout_tpl']; |
@@ -30,40 +30,40 @@ discard block |
||
30 | 30 | $target = $modx->mergeSettingsContent($target); |
31 | 31 | |
32 | 32 | if(substr($target,0,1)==='@') { |
33 | - if(substr($target,0,6)==='@CHUNK') { |
|
34 | - $target = trim(substr($target,7)); |
|
35 | - $lockout_tpl = $modx->getChunk($target); |
|
36 | - } |
|
37 | - elseif(substr($target,0,5)==='@FILE') { |
|
38 | - $target = trim(substr($target,6)); |
|
39 | - $lockout_tpl = file_get_contents($target); |
|
40 | - } |
|
41 | - } else { |
|
42 | - $chunk = $modx->getChunk($target); |
|
43 | - if($chunk!==false && !empty($chunk)) { |
|
44 | - $lockout_tpl = $chunk; |
|
45 | - } |
|
46 | - elseif(is_file(MODX_BASE_PATH . $target)) { |
|
47 | - $target = MODX_BASE_PATH . $target; |
|
48 | - $lockout_tpl = file_get_contents($target); |
|
49 | - } |
|
50 | - elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/manager.lockout.tpl')) { |
|
51 | - $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/manager.lockout.tpl'; |
|
52 | - $lockout_tpl = file_get_contents($target); |
|
53 | - } |
|
54 | - elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/templates/actions/manager.lockout.tpl')) { |
|
55 | - $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/templates/actions/manager.lockout.tpl'; |
|
56 | - $login_tpl = file_get_contents($target); |
|
57 | - } |
|
58 | - elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/html/manager.lockout.html')) { // ClipperCMS compatible |
|
59 | - $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/html/manager.lockout.html'; |
|
60 | - $lockout_tpl = file_get_contents($target); |
|
61 | - } |
|
62 | - else { |
|
63 | - $target = MODX_MANAGER_PATH . 'media/style/common/manager.lockout.tpl'; |
|
64 | - $lockout_tpl = file_get_contents($target); |
|
65 | - } |
|
66 | - } |
|
33 | + if(substr($target,0,6)==='@CHUNK') { |
|
34 | + $target = trim(substr($target,7)); |
|
35 | + $lockout_tpl = $modx->getChunk($target); |
|
36 | + } |
|
37 | + elseif(substr($target,0,5)==='@FILE') { |
|
38 | + $target = trim(substr($target,6)); |
|
39 | + $lockout_tpl = file_get_contents($target); |
|
40 | + } |
|
41 | + } else { |
|
42 | + $chunk = $modx->getChunk($target); |
|
43 | + if($chunk!==false && !empty($chunk)) { |
|
44 | + $lockout_tpl = $chunk; |
|
45 | + } |
|
46 | + elseif(is_file(MODX_BASE_PATH . $target)) { |
|
47 | + $target = MODX_BASE_PATH . $target; |
|
48 | + $lockout_tpl = file_get_contents($target); |
|
49 | + } |
|
50 | + elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/manager.lockout.tpl')) { |
|
51 | + $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/manager.lockout.tpl'; |
|
52 | + $lockout_tpl = file_get_contents($target); |
|
53 | + } |
|
54 | + elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/templates/actions/manager.lockout.tpl')) { |
|
55 | + $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/templates/actions/manager.lockout.tpl'; |
|
56 | + $login_tpl = file_get_contents($target); |
|
57 | + } |
|
58 | + elseif(is_file(MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/html/manager.lockout.html')) { // ClipperCMS compatible |
|
59 | + $target = MODX_MANAGER_PATH . 'media/style/' . $modx->config['manager_theme'] . '/html/manager.lockout.html'; |
|
60 | + $lockout_tpl = file_get_contents($target); |
|
61 | + } |
|
62 | + else { |
|
63 | + $target = MODX_MANAGER_PATH . 'media/style/common/manager.lockout.tpl'; |
|
64 | + $lockout_tpl = file_get_contents($target); |
|
65 | + } |
|
66 | + } |
|
67 | 67 | |
68 | 68 | // merge placeholders |
69 | 69 | $lockout_tpl = $modx->mergePlaceholderContent($lockout_tpl); |
@@ -11,18 +11,18 @@ |
||
11 | 11 | */ |
12 | 12 | |
13 | 13 | function secureMgrDocument($docid='') { |
14 | - global $modx; |
|
14 | + global $modx; |
|
15 | 15 | |
16 | - $modx->db->update('privatemgr = 0', $modx->getFullTableName("site_content"), ($docid>0 ? "id='$docid'":"privatemgr = 1")); |
|
17 | - $rs = $modx->db->select( |
|
18 | - 'DISTINCT sc.id', |
|
19 | - $modx->getFullTableName("site_content")." sc |
|
16 | + $modx->db->update('privatemgr = 0', $modx->getFullTableName("site_content"), ($docid>0 ? "id='$docid'":"privatemgr = 1")); |
|
17 | + $rs = $modx->db->select( |
|
18 | + 'DISTINCT sc.id', |
|
19 | + $modx->getFullTableName("site_content")." sc |
|
20 | 20 | LEFT JOIN ".$modx->getFullTableName("document_groups")." dg ON dg.document = sc.id |
21 | 21 | LEFT JOIN ".$modx->getFullTableName("membergroup_access")." mga ON mga.documentgroup = dg.document_group", |
22 | - ($docid>0 ? " sc.id='{$docid}' AND ":"")."mga.id>0" |
|
23 | - ); |
|
24 | - $ids = $modx->db->getColumn("id",$rs); |
|
25 | - if(count($ids)>0) { |
|
26 | - $modx->db->update('privatemgr = 1', $modx->getFullTableName("site_content"), "id IN (".implode(", ",$ids).")"); |
|
27 | - } |
|
22 | + ($docid>0 ? " sc.id='{$docid}' AND ":"")."mga.id>0" |
|
23 | + ); |
|
24 | + $ids = $modx->db->getColumn("id",$rs); |
|
25 | + if(count($ids)>0) { |
|
26 | + $modx->db->update('privatemgr = 1', $modx->getFullTableName("site_content"), "id IN (".implode(", ",$ids).")"); |
|
27 | + } |
|
28 | 28 | } |