function createMenuChild($parentid) { $menu = "\n"; if (isDbConnect()) { $conn = pg_connect(getConnectionString()); // XIBAR-OLD $queryString = ""; $queryString .= "select a.id, a.name, a.parentid, a.url "; $queryString .= queryString(); $queryString .= "and a.parentid = " . $parentid . " "; $queryString .= "order by a.id "; $recordset = pg_query($conn, $queryString); while ($row = pg_fetch_object($recordset)) { if (isHasChild($row->id)) { $menu .= "<div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-carat-2-ew'\">\n"; $menu .= "<span><strong>" . $row->name . "</strong></span>\n"; $menu .= "<div>\n"; $menu .= createMenuChild($row->id); $menu .= "</div>\n"; $menu .= "</div>\n"; } else { // $menu .= "<div onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; $menu .= "<div data-options=\"iconCls:'icon icon-color icon-bullet-on'\" onclick=\"javascript:window.location = 'index.php?p=" . $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">" . $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-bullet-off'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-script'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-star-on'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-star-off'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-stop'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-tasks'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; // $menu .= "<div data-options=\"iconCls:'icon icon-color icon-carat-1-e'\" onclick=\"javascript:window.location = 'index.php?p=". $row->url . "&id=" . $row->id . "&name=" . $row->name . "';\">". $row->name . "</div>\n"; } } pg_close(getConnectionString()); } return $menu; }
function lib_middlenavlist(&$ctag, &$refObj) { global $dsql; $attlist = "row|5,kindid|,flag|,type|,row|6,readad|1,limit|0,destid|,pid|,leftad|indexleftad,isnav|1,ishot|0"; FillAttsDefault($ctag->CAttribute->Items, $attlist); extract($ctag->CAttribute->Items, EXTR_SKIP); $typeid = isset($refObj->Fields['typeid']) ? $refObj->Fields['typeid'] : 1; //首页的显示与线路一致. $adflag = ''; if (!empty($flag)) { $tablename = array("1" => "#@__line_kindlist", "2" => "#@__hotel_kindlist", "3" => "#@__car_kindlist", "4" => "#@__article_kindlist", "5" => "#@__spot_kindlist", "6" => "#@__photo_kindlist", "13" => "#@__tuan_kindlist"); if ($flag == 'raider') { $typeid = 4; if ($readad) { $adflag = "IndexRaiderMiddleNavAd"; } } else { if ($flag == 'line') { $typeid = 1; if ($readad) { $adflag = "IndexLineMiddleNav"; } } else { if ($flag == 'hotel') { $typeid = 2; if ($readad) { $adflag = "IndexHotelMiddleNav"; } } else { if ($flag == 'car') { $typeid = 3; } else { if ($flag == 'spot') { $typeid = 5; } else { if ($flag == 'photo') { $typeid = 6; } else { if ($flag == 'tuan') { $typeid = 13; } } } } } } } if (!empty($pid)) { $w = " and a.pid={$pid}"; } $tablename = isset($tablename[$typeid]) ? $tablename[$typeid] : '#@__' . $flag . '_kindlist'; if ($isnav == 1) { $sql = "select a.kindname,b.kindid,b.shownum,a.jieshao,a.pinyin,a.litpic,a.pinyin from #@__destinations as a inner join {$tablename} as b on a.id=b.kindid where b.isnav=1 and a.isopen=1 {$w} order by b.displayorder asc limit {$limit},{$row}"; } else { if ($ishot == 1) { $sql = "select a.kindname,b.kindid,b.shownum,a.jieshao,a.pinyin,a.litpic,a.pinyin from #@__destinations as a inner join {$tablename} as b on a.id=b.kindid where b.ishot=1 and a.isopen=1 {$w} order by b.displayorder asc limit {$limit},{$row}"; } else { $sql = "select a.kindname,b.kindid,b.shownum,a.jieshao,a.pinyin,a.litpic,a.pinyin from #@__destinations as a inner join {$tablename} as b on a.id=b.kindid where a.isopen=1 {$w} order by b.displayorder asc limit {$limit},{$row}"; } } } if ($type == 'gather') { $kindid = isset($refObj->Fields['kindid']) ? $refObj->Fields['kindid'] : 36; if ($destid) { $kindid = $destid; } if (isHasChild($kindid)) { $sql = "select id as kindid,kindname,pinyin,litpic from #@__destinations where pid={$kindid} and isopen=1 order by displayorder asc limit 0,{$row}"; } else { $sql = "select id as kindid,kindname,pinyin,litpic from #@__destinations where id={$kindid} and isopen=1 order by displayorder asc limit 0,{$row}"; } } //首页目的地显示 if ($type == 'index') { $sql = "select a.id as kindid,a.* from #@__destinations a where a.isnav = '1' and a.isopen = 1 order by a.displayorder asc limit {$limit},{$row}"; $adflag = "IndexMiddleAd"; } //$adflag="IndexMiddleAd"; $innertext = trim($ctag->GetInnerText()); $artlist = ''; if ($innertext == '') { return ''; } //获得类别ID总数的信息 $ids = array(); $kindnames = array(); $dsql->SetQuery($sql); $dsql->Execute(); while ($row = $dsql->GetArray()) { //if(Exist($row['kindid'],$typeid)) //{ $ids[] = $row['kindid']; $kindnames[] = $row['kindname']; //获取导航分类名称 $shownumber[] = !empty($row['shownum']) ? $row['shownum'] : 8; $pinyins[] = $row['pinyin']; $litpic[] = getUploadFileUrl($row['litpic']); $jieshao[] = $row['jieshao']; //} //$numbers[]=$row['row'];//显示数量 } //如里子分类不存在则取当前级(聚合页面用) /* if(!isset($ids[0])) { $kindid=$refObj->Fields['kindid']; $kindnames[]=$refObj->Fields['kindname']; $ids[]=$kindid; } */ $GLOBALS['itemindex'] = 0; for ($i = 0; isset($ids[$i]); $i++) { $GLOBALS['itemindex']++; $newinnertext = $innertext; $pv = new View($typeid); $pv->Fields['leftad'] = getMiddleAd($leftad, $i); $pv->Fields['middlead'] = getMiddleAd($adflag, $i); $pv->Fields['kindname'] = $kindnames[$i]; //$pv->Fields['sonid']=$ids[$i]; //$pv->Fields['shownumber']=$numbers[$i]; $pv->Fields['pinyin'] = !empty($pinyins[$i]) ? $pinyins[$i] : $ids[$i]; $pv->Fields['shownum'] = $shownumber[$i]; $pv->Fields['kindid'] = $ids[$i]; $pv->Fields['destid'] = $ids[$i]; $pv->Fields['kindpy'] = $pinyins[$i]; $pv->Fields['jieshao'] = $jieshao[$i]; //$pv->Fields['kindchild']=GetChild($ids[$i],$typeid); $pv->Fields['litpic'] = $litpic[$i]; $pv->SetTemplet($newinnertext, 'string'); $artlist .= $pv->GetResult(); } return $artlist; }