1
|
<?php
|
2
|
/**
|
3
|
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
|
4
|
*
|
5
|
* This program is free software: you can redistribute it and/or modify
|
6
|
* it under the terms of the GNU General Public License as published by
|
7
|
* the Free Software Foundation, either version 3 of the License, or
|
8
|
* (at your option) any later version.
|
9
|
*
|
10
|
* This program is distributed in the hope that it will be useful,
|
11
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
12
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
13
|
* GNU General Public License for more details.
|
14
|
*
|
15
|
* You should have received a copy of the GNU General Public License
|
16
|
* along with this program. If not, see <http://www.gnu.org/licenses/>.
|
17
|
*/
|
18
|
|
19
|
/**
|
20
|
* Lib.php
|
21
|
*
|
22
|
* @category Modules
|
23
|
* @package Modules_MultiLingual
|
24
|
* @author Werner v.d.Decken <wkl@isteam.de>
|
25
|
* @author Dietmar Wöllbrink <dietmar.woellbrink@websiteBaker.org>
|
26
|
* @copyright Werner v.d.Decken <wkl@isteam.de>
|
27
|
* @license http://www.gnu.org/licenses/gpl.html GPL License
|
28
|
* @version 1.6.8
|
29
|
* @revision $Revision: $
|
30
|
* @link $HeadURL: $
|
31
|
* @lastmodified $Date: $
|
32
|
* @since File available since 09.01.2013
|
33
|
* @description provides a flexible posibility for changeing to a translated page
|
34
|
*/
|
35
|
|
36
|
class m_MultiLingual_Lib {
|
37
|
/** @var object instance of the WbAdaptor object */
|
38
|
protected $_oReg = null;
|
39
|
/** @var object instance of the application object */
|
40
|
private $_oApp = null;
|
41
|
/** @var object instance of the database object */
|
42
|
private $_oDb = null;
|
43
|
|
44
|
private $_defaultPageId = 0;
|
45
|
|
46
|
|
47
|
/** @var array holds several values from the default.ini */
|
48
|
private $_config = array();
|
49
|
/** @var array set several values for Twig_Environment */
|
50
|
private $_aTwigEnv = array();
|
51
|
/** @var array set several values for Twig_Loader */
|
52
|
private $_aTwigLoader = array();
|
53
|
/**
|
54
|
* constructor used to import some application constants and objects
|
55
|
*/
|
56
|
public function __construct()
|
57
|
{
|
58
|
// import global vars and objects
|
59
|
$this->_wbAdaptor();
|
60
|
}
|
61
|
|
62
|
/**
|
63
|
* used to import some WB-constants and objects
|
64
|
*/
|
65
|
private function _wbAdaptor()
|
66
|
{
|
67
|
if(!defined('ADMIN_REL')) { define('ADMIN_REL', WB_REL.'/'.ADMIN_DIRECTORY); }
|
68
|
|
69
|
$this->_oApp = (isset($GLOBALS['admin']) ? $GLOBALS['admin'] : $GLOBALS['wb']);
|
70
|
$this->_oDb = WbDatabase::getInstance();
|
71
|
$this->_oReg = WbAdaptor::getInstance();
|
72
|
|
73
|
$this->_config = parse_ini_file(dirname(__FILE__).'/default.ini',true);
|
74
|
$this->_aTwigEnv = $this->_config['twig-environment'];
|
75
|
$this->_aTwigLoader = $this->_config['twig-loader-file'];
|
76
|
|
77
|
}
|
78
|
|
79
|
/**
|
80
|
* methode to update a var/value-pair into table
|
81
|
* @param integer $iPageId which page shall be updated
|
82
|
* @param string $sTable the pages table
|
83
|
* @param integer $iEntry
|
84
|
* @return bool
|
85
|
*/
|
86
|
private function _updatePageCode($iPageId, $sTable, $iNewPageCode = null)
|
87
|
{
|
88
|
// if new Pagecode is missing then set the own page ID
|
89
|
$entry = ( !isset($iNewPageCode) ? $iPageId : $iNewPageCode);
|
90
|
$sql = 'UPDATE `'.$this->_oReg->TablePrefix.$sTable.'` '
|
91
|
. 'SET `page_code`='.$entry.', '
|
92
|
. '`modified_when` = '.time().' '
|
93
|
. 'WHERE `page_id` = '.$iPageId;
|
94
|
return (bool)$this->_oDb->query($sql);
|
95
|
}
|
96
|
|
97
|
/**
|
98
|
* compose the needed SQL statement
|
99
|
* @param integer $sLangKey
|
100
|
* @return database object with given SQL statement
|
101
|
*/
|
102
|
private function _getLangInUsedDbResult ( $sLangKey='' )
|
103
|
{
|
104
|
$sql = 'SELECT DISTINCT `language`,'
|
105
|
. '`page_id`,`level`,`parent`,`root_parent`,`page_code`,`link`,'
|
106
|
. '`visibility`,`viewing_groups`,`viewing_users`,`position`,`page_title` '
|
107
|
. 'FROM `'.$this->_oReg->TablePrefix.'pages` '
|
108
|
. 'WHERE `level`= \'0\' '
|
109
|
. 'AND `root_parent`=`page_id` '
|
110
|
. 'AND `visibility`!=\'none\' '
|
111
|
. 'AND `visibility`!=\'hidden\' '
|
112
|
. ( ($sLangKey!='') ? ' AND `language` = \''.$sLangKey.'\'' : '')
|
113
|
. 'GROUP BY `language` '
|
114
|
. 'ORDER BY `position`';
|
115
|
return $this->_oDb->query($sql);
|
116
|
}
|
117
|
|
118
|
/**
|
119
|
*
|
120
|
* search for pages with given page code and create a DB result object
|
121
|
* @param integer Pagecode to search for
|
122
|
* @return object result object or null on error
|
123
|
*/
|
124
|
private function _getPageCodeDbResult( $iPageCode )
|
125
|
{
|
126
|
$sql = 'SELECT `language`,'
|
127
|
. '`page_id`,`level`,`parent`,`root_parent`,`page_code`,`link`,'
|
128
|
. '`visibility`,`viewing_groups`,`viewing_users`,`position`,`page_title` '
|
129
|
. 'FROM `'.$this->_oReg->TablePrefix.'pages`'
|
130
|
. 'WHERE `page_code` = '.$iPageCode.' '
|
131
|
. 'ORDER BY `position`';
|
132
|
return $this->_oDb->query($sql);
|
133
|
}
|
134
|
|
135
|
/**
|
136
|
* compose the needed SQL statement
|
137
|
* @param integer $sLangKey
|
138
|
* @return database object with given SQL statementt
|
139
|
*/
|
140
|
private function _getLangAddonsDbResult ( $sLangKey='' )
|
141
|
{
|
142
|
$sql = 'SELECT `directory`,`name` FROM `'.$this->_oReg->TablePrefix.'addons` '
|
143
|
. 'WHERE `type` = \'language\' '
|
144
|
. ( ($sLangKey!='') ? ' AND `directory` = \''.$langKey.'\' ' : '')
|
145
|
. 'ORDER BY `directory`';
|
146
|
return $this->_oDb->query($sql);
|
147
|
}
|
148
|
|
149
|
/**
|
150
|
*
|
151
|
* @param integer $parent
|
152
|
* @return database object with given SQL statement
|
153
|
*/
|
154
|
private function _getPageListDbResult ( $parent )
|
155
|
{
|
156
|
$sql = 'SELECT `language`,'
|
157
|
. '`page_id`,`page_title`,`menu_title`, `page_code`, `parent` '
|
158
|
. 'FROM `'.$this->_oReg->TablePrefix.'pages` '
|
159
|
. 'WHERE `parent` = '.$parent. ' '
|
160
|
. 'ORDER BY `position`';
|
161
|
return $this->_oDb->query($sql);
|
162
|
}
|
163
|
|
164
|
private function _getPageCodeValues( $iPageCode=0 )
|
165
|
{
|
166
|
$aRetval = array();
|
167
|
if( ($oRes = $this->_getPageCodeDbResult($iPageCode)) )
|
168
|
{
|
169
|
while($page = $oRes->fetchRow(MYSQL_ASSOC))
|
170
|
{
|
171
|
if(!$this->_oApp->page_is_visible($page)) {continue;}
|
172
|
$aRetval[$page['language']] = $page;
|
173
|
}
|
174
|
}
|
175
|
return $aRetval;
|
176
|
}
|
177
|
|
178
|
private function _getPageList($parent, $this_page=0 )
|
179
|
{
|
180
|
static $entries = array();
|
181
|
if( ($oLang = $this->_getPageListDbResult($parent)) )
|
182
|
{
|
183
|
while($value = $oLang->fetchRow(MYSQL_ASSOC))
|
184
|
{
|
185
|
if (( $value['page_id'] != $this_page ) )
|
186
|
{
|
187
|
$entries [$value['page_id']]['language'] = $value['language'];
|
188
|
$entries [$value['page_id']]['menu_title'] = $value['menu_title'];
|
189
|
$this->_getPageList($value['page_id'], $this_page );
|
190
|
}
|
191
|
}
|
192
|
}
|
193
|
return $entries;
|
194
|
}
|
195
|
|
196
|
|
197
|
|
198
|
private function _getAllowedLanguagesFromAddons($sLangKey='')
|
199
|
{
|
200
|
$aLangAddons = array();
|
201
|
if( ($oLang = $this->_getLangAddonsDbResult($sLangKey)) )
|
202
|
{
|
203
|
while( $aLang = $oLang->fetchRow(MYSQL_ASSOC) )
|
204
|
{
|
205
|
$aLangAddons[$aLang['directory']] = $aLang['name'];
|
206
|
}
|
207
|
}
|
208
|
return $aLangAddons;
|
209
|
}
|
210
|
|
211
|
/**
|
212
|
*
|
213
|
*
|
214
|
* @param
|
215
|
* @return array of first visible language pages with defined fields
|
216
|
*/
|
217
|
private function _getLanguagesDetailsInUsed ( $sLangKey='' )
|
218
|
{
|
219
|
$aRetval = array();
|
220
|
if( ($oRes = $this->_getLangInUsedDbResult($sLangKey)) )
|
221
|
{
|
222
|
while($page = $oRes->fetchRow(MYSQL_ASSOC))
|
223
|
{
|
224
|
if(!$this->_oApp->page_is_visible($page)) {continue;}
|
225
|
$aRetval[$page['language']] = $page;
|
226
|
}
|
227
|
}
|
228
|
return $aRetval;
|
229
|
}
|
230
|
|
231
|
/**
|
232
|
* m_MultiLingual_Lib::getLangMenuData()
|
233
|
*
|
234
|
* @param mixed $config
|
235
|
* @param mixed $oApp
|
236
|
* @return
|
237
|
*/
|
238
|
private function _getLangMenuData ( )
|
239
|
{
|
240
|
$data = array();
|
241
|
$SetLanguageUrl = array();
|
242
|
$SetLanguageIcons = array();
|
243
|
$SetLanguageIcons = $this->_getLanguagesDetailsInUsed( );
|
244
|
if(sizeof($SetLanguageIcons)>1)
|
245
|
{
|
246
|
$pages = $this->_getPageCodeValues( $this->_oApp->page_code );
|
247
|
$tmppage = array_intersect_key($pages,$SetLanguageIcons);
|
248
|
$pages = array_merge($SetLanguageIcons,$tmppage);
|
249
|
foreach ( $SetLanguageIcons AS $value)
|
250
|
{
|
251
|
$data[] = array(
|
252
|
'sIconUrl' => rtrim($this->_oReg->AppRel,'/').str_replace(rtrim($this->_oReg->DocumentRoot,'/'),'',str_replace('\\','/',dirname(__FILE__))),
|
253
|
'bCurrent' => ( ($value['language'] == $this->_oReg->Language ) ? true : false),
|
254
|
'sUrl' => $this->_oReg->AppRel.$this->_oReg->PagesDir.trim($pages[$value['language']]['link'],'/').$this->_oReg->PageExtension,
|
255
|
'sTitle' => $pages[$value['language']]['page_title'],
|
256
|
'FilePrefix' => strtolower($pages[$value['language']]['language']),
|
257
|
);
|
258
|
}
|
259
|
}
|
260
|
return $data;
|
261
|
}
|
262
|
|
263
|
/**
|
264
|
* m_MultiLingual_Lib::getLangMenu()
|
265
|
*
|
266
|
* @param mixed $config
|
267
|
* @param mixed $oApp
|
268
|
* @return
|
269
|
*/
|
270
|
private function _getLangMenuTwig ( )
|
271
|
{
|
272
|
$loader = new Twig_Loader_Filesystem( dirname(__FILE__).$this->_aTwigLoader['templates_dir'] );
|
273
|
$twig = new Twig_Environment( $loader );
|
274
|
$data['aTargetList'] = $this->_getLangMenuData( );
|
275
|
return $twig->render($this->_aTwigLoader['default_template'], $data);
|
276
|
}
|
277
|
|
278
|
|
279
|
public function getLangMenu()
|
280
|
{
|
281
|
return $this->_getLangMenuTwig ( );
|
282
|
}
|
283
|
|
284
|
public function updateDefaultPagesCode ( )
|
285
|
{
|
286
|
$retVal = false;
|
287
|
$aLangs = $this->_getLanguagesDetailsInUsed( );
|
288
|
$entries = $this->_getPageList( 0 );
|
289
|
// fill page_code with page_id for default_language
|
290
|
while( list( $page_id, $val ) = each ( $entries ) )
|
291
|
{
|
292
|
if( $val['language'] == $this->_oReg->DefaultLangauage ) {
|
293
|
if( ($retVal = $this->_updatePageCode((int)$page_id, 'pages', (int)$page_id ))==false ){ break; }
|
294
|
}
|
295
|
}
|
296
|
return $retVal;
|
297
|
}
|
298
|
|
299
|
}
|