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