@@ -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 | } |