function executeListOp() { $start = isset($_GET['list_start']) ? intval($_GET['list_start']) : 0; if (strtolower($this->mListOrderDefault) == 'asc') { $order = isset($_GET['list_order']) && $_GET['list_order'] == 'desc' ? 'desc' : 'asc'; } else { $order = isset($_GET['list_order']) && $_GET['list_order'] == 'asc' ? 'asc' : 'desc'; } $sort = isset($_GET['list_sort']) ? htmlspecialchars($_GET['list_sort'], ENT_QUOTES) : $this->mListSortDefault; $perpage = !empty($_GET['list_perpage']) ? intval($_GET['list_perpage']) : $this->mListPerPageDefault; if ($this->mListFilterCriteria) { $criteria =& $this->mListFilterCriteria; } else { $criteria =& new Criteria(1, intNBCriteriaVal(1)); } $criteria->setStart($start); $criteria->setLimit($perpage); $criteria->setSort($sort); $criteria->setOrder($order); $this->mListStart = $start; $this->mListSort = $sort; $this->mListOrder = $order; $this->mListPerPage = $perpage; $this->mObjectArr =& $this->getListObjects($criteria, $this->mListFilterJoinDef, $this->mListFilterHaving); // echo $this->mObjectHandler->getLastSQL()."<br>"; $this->mObjectAllCount = $this->getListCount($criteria, $this->mListFilterJoinDef, $this->mListFilterHaving); // echo $this->mObjectHandler->getLastSQL()."<br>"; echo $this->mObjectAllCount; return NBFRAME_ACTION_VIEW_DEFAULT; break; }
function getLastModified($criteria = null) { if (empty($criteria)) { $criteria = new Criteria(1, intNBCriteriaVal(1)); } $criteria->setSort('_NBsys_update_time'); $criteria->setOrder('DESC'); $_prevLimit = $criteria->getLimit(); $criteria->setLimit(1); $objects =& $this->getObjects($criteria, false, '_NBsys_update_time'); if (count($objects) > 0) { $lastModified = $objects[0]->getVar('_NBsys_update_time'); } else { $lastModified = -1; } $criteria->setLimit($_prevLimit); return $lastModified; }
function executeDefaultOp() { $myts =& MyTextSanitizer::getInstance(); $this->elements['markers'] = array(); $this->elements['category'] = array(); $this->elements['overlay'] = array(); $categoryHandler =& NBFrame::getHandler('MyGmapCategory', $this->mEnvironment); $criteria = new Criteria(1, intNBCriteriaVal(1)); $categoryObjects =& $categoryHandler->getObjects($criteria); $this->elements['catlist'] = array(); $this->elements['catlist'][] = array('id' => -1, 'name' => $this->__l('All Categories')); foreach ($categoryObjects as $categoryObject) { $mygmap_cat = array(); $mygmap_cat['id'] = $categoryObject->getVar('mygmap_category_id'); $mygmap_cat['name'] = $categoryObject->getVar('mygmap_category_name'); $this->elements['catlist'][] = $mygmap_cat; } $this->elements['maptype'] = $GLOBALS['xoopsModuleConfig']['mygmap_maptype']; if (isset($_GET['lat']) && isset($_GET['lng'])) { $mygmap_marker = array(); $mygmap_marker['id'] = 0; $this->elements['center_lat'] = $mygmap_marker['lat'] = floatval($_GET['lat']); $this->elements['center_lng'] = $mygmap_marker['lng'] = floatval($_GET['lng']); $this->elements['zoom'] = $mygmap_marker['zoom'] = isset($_GET['z']) ? intval($_GET['z']) : $GLOBALS['xoopsModuleConfig']['mygmap_z']; $this->elements['maptype'] = isset($_GET['t']) ? intval($_GET['t']) : $GLOBALS['xoopsModuleConfig']['mygmap_maptype']; $mygmap_marker['mark'] = isset($_GET['mark']) ? htmlspecialchars(strtoupper($_GET['mark']), ENT_QUOTES) : ''; $mygmap_text = !empty($_GET['text']) ? mb_convert_encoding($_GET['text'], 'EUC-JP', 'auto') : $GLOBALS['xoopsModuleConfig']['mygmap_text2']; $mygmap_marker['text'] = str_replace("'", "\\'", $myts->makeTareaData4Show($mygmap_text)); $this->elements['markers'][] = $mygmap_marker; } elseif (!empty($_GET['cat']) || !empty($GLOBALS['xoopsModuleConfig']['mygmap_cat'])) { $category_id = !empty($_GET['cat']) ? intval($_GET['cat']) : $GLOBALS['xoopsModuleConfig']['mygmap_cat']; $markerHandler =& NBFrame::getHandler('MyGmapMarker', $this->mEnvironment); if ($category_id != -1) { $categoryObject =& $categoryHandler->get($category_id); $this->elements['center_lat'] = $this->elements['category']['lat'] = $categoryObject->getVar('mygmap_category_lat'); $this->elements['center_lng'] = $this->elements['category']['lng'] = $categoryObject->getVar('mygmap_category_lng'); $this->elements['zoom'] = $this->elements['category']['zoom'] = $categoryObject->getVar('mygmap_category_zoom'); $this->elements['category']['maptype'] = $categoryObject->getVar('mygmap_category_maptype'); $this->elements['maptype'] = $this->elements['category']['maptype'] ? $this->elements['category']['maptype'] : $this->elements['maptype']; $this->elements['category']['id'] = $categoryObject->getVar('mygmap_category_id'); $this->elements['category']['name'] = $categoryObject->getVar('mygmap_category_name'); $this->elements['category']['desc'] = $categoryObject->getVar('mygmap_category_desc'); $this->elements['category']['can_edit'] = $categoryObject->checkGroupPerm('write', true); if ($categoryObject->getVar('mygmap_category_overlay')) { $this->elements['overlay'][] = $this->overlayURL($categoryObject->getVar('mygmap_category_overlay')); } } else { $this->elements['center_lat'] = $mygmap_marker['lat'] = $GLOBALS['xoopsModuleConfig']['mygmap_lat']; $this->elements['center_lng'] = $mygmap_marker['lng'] = $GLOBALS['xoopsModuleConfig']['mygmap_lng']; $this->elements['zoom'] = $GLOBALS['xoopsModuleConfig']['mygmap_zoom']; $this->elements['category']['id'] = -1; foreach ($categoryObjects as $categoryObject) { $categoryCanEdit[$categoryObject->getKey()] = $categoryObject->checkGroupPerm('write', true); if ($categoryObject->getVar('mygmap_category_overlay')) { $this->elements['overlay'][] = $this->overlayURL($categoryObject->getVar('mygmap_category_overlay')); } } } if (!empty($_GET['id'])) { $map_id = intval($_GET['id']); if ($markerObject =& $markerHandler->get($map_id)) { $this->elements['center_lat'] = $markerObject->getVar('mygmap_marker_lat'); $this->elements['center_lng'] = $markerObject->getVar('mygmap_marker_lng'); $this->elements['zoom'] = $markerObject->getVar('mygmap_marker_zoom'); $this->elements['maptype'] = $markerObject->getVar('mygmap_marker_maptype') ? $markerObject->getVar('mygmap_marker_maptype') : $this->elements['maptype']; } } if ($category_id != -1) { $criteria =& new Criteria('mygmap_marker_category_id', $category_id); } else { $criteria = null; } $markerObjects =& $markerHandler->getObjects($criteria); foreach ($markerObjects as $markerObject) { $mygmap_marker = array(); $mygmap_marker['id'] = $markerObject->getVar('mygmap_marker_id'); $mygmap_marker['lat'] = $markerObject->getVar('mygmap_marker_lat'); $mygmap_marker['lng'] = $markerObject->getVar('mygmap_marker_lng'); $mygmap_marker['zoom'] = $markerObject->getVar('mygmap_marker_zoom'); $mygmap_marker['maptype'] = $markerObject->getVar('mygmap_marker_maptype'); $mygmap_marker['mark'] = $markerObject->getVar('mygmap_marker_icontext'); $mygmap_title = htmlspecialchars($markerObject->getVar('mygmap_marker_title'), ENT_QUOTES); $mygmap_desc = $markerObject->getVar('mygmap_marker_desc'); $mygmap_marker['title'] = $mygmap_title; $mygmap_marker['text'] = '<b>' . $mygmap_title . '</b>' . '<hr />' . $mygmap_desc; if ($category_id != -1) { $mygmap_marker['canedit'] = NBFrame::checkRight('marker_edit') && $this->elements['category']['can_edit']; } else { $mygmap_marker['canedit'] = NBFrame::checkRight('marker_edit') && $categoryCanEdit[$markerObject->getVar('mygmap_marker_category_id')]; } $this->elements['markers'][] = $mygmap_marker; } usort($this->elements['markers'], array(&$this, 'usort_cmp')); } else { $mygmap_marker = array(); $mygmap_marker['id'] = 0; $this->elements['center_lat'] = $mygmap_marker['lat'] = $GLOBALS['xoopsModuleConfig']['mygmap_lat']; $this->elements['center_lng'] = $mygmap_marker['lng'] = $GLOBALS['xoopsModuleConfig']['mygmap_lng']; $this->elements['zoom'] = $GLOBALS['xoopsModuleConfig']['mygmap_zoom']; $mygmap_marker['mark'] = ''; $mygmap_text = $GLOBALS['xoopsModuleConfig']['mygmap_text1']; $mygmap_marker['text'] = str_replace("'", "\\'", $myts->makeTareaData4Show($mygmap_text)); $mygmap_marker['canedit'] = false; $this->elements['markers'][] = $mygmap_marker; } $areaHandler =& NBFrame::getHandler('MyGmapArea', $this->mEnvironment); $criteria = new Criteria(1, intNBCriteriaVal(1)); $criteria->setSort('mygmap_area_order'); $areaObjects =& $areaHandler->getObjects($criteria); $this->elements['areas'] = array(); foreach ($areaObjects as $areaObject) { $mygmap_area = array(); $mygmap_area['id'] = $areaObject->getVar('mygmap_area_id'); $mygmap_area['name'] = $areaObject->getVar('mygmap_area_name'); $mygmap_area['lat'] = $areaObject->getVar('mygmap_area_lat'); $mygmap_area['lng'] = $areaObject->getVar('mygmap_area_lng'); $mygmap_area['zoom'] = $areaObject->getVar('mygmap_area_zoom'); $mygmap_area['maptype'] = $areaObject->getVar('mygmap_area_maptype'); $mygmap_area['desc'] = $areaObject->getVar('mygmap_area_desc'); $this->elements['areas'][] = $mygmap_area; } $this->elements['addr'] = !empty($_GET['q']) ? mb_convert_encoding(htmlspecialchars($_GET['q'], ENT_QUOTES), 'EUC-JP', 'UTF-8,EUC-JP,SJIS') : ''; $this->elements['station'] = !empty($_GET['s']) ? mb_convert_encoding(htmlspecialchars($_GET['s'], ENT_QUOTES), 'EUC-JP', 'UTF-8,EUC-JP,SJIS') : ''; NBFrame::using('MyGmapUtils', $this->mEnvironment); foreach (MyGmapUtils::getPluginFiles($this->mDirName, 'php') as $file) { require_once $file; $class = basename($file); $class = substr($class, 0, strlen($class) - 4); if (class_exists($class)) { call_user_func_array(array($class, 'executeDefaultOp'), array(&$this)); } } return NBFRAME_ACTION_VIEW_DEFAULT; }