7 * LICENSE: This source file is licensed under the terms of the GNU General Public License.
9 * @package Magic3 Framework
10 * @author 平田直毅(Naoki Hirata) <naoki@aplo.co.jp>
11 * @copyright Copyright 2006-2009 Magic3 Project.
12 * @license http://www.gnu.org/copyleft/gpl.html GPL License
13 * @version SVN: $Id: slide_menuDb.php 2560 2009-11-17 02:19:10Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class slide_menuDb extends BaseDb
23 * @param function $callback コールバック関数
26 function getMenuIdList($callback)
28 $queryStr = 'SELECT * FROM _menu_id ';
29 $queryStr .= 'ORDER BY mn_sort_order';
30 $this->selectLoop($queryStr, array(), $callback);
35 * @param string $menuId メニュー識別ID
36 * @param string $parentId 親項目ID
37 * @param array $rows 取得レコード
38 * @return true=取得、false=取得せず
40 function getChildMenuItems($menuId, $parentId, &$rows)
42 $queryStr = 'SELECT * FROM _menu_def ';
43 $queryStr .= 'WHERE md_menu_id = ? ';
44 $queryStr .= 'AND md_parent_id = ? ';
45 $queryStr .= 'ORDER BY md_index';
46 $retValue = $this->selectRecords($queryStr, array($menuId, $parentId), $rows);
52 * @param string $id メニューID
53 * @return true=正常、false=異常
55 function getMenu($id, &$row)
57 $queryStr = 'SELECT * FROM _menu_id ';
58 $queryStr .= 'WHERE mn_id = ? ';
59 $ret = $this->selectRecord($queryStr, array($id), $row);