break; case '4': $strWhere .= " order by a.price asc "; break; } } else { $strWhere .= " order by a.goodstop desc, a.on_time desc "; } $strPages = $kekezu->_page_obj->getPages($intCount, $intPagesize, $intPage, $strUrl); $strWhere .= $strPages['where']; $arrServices = db_factory::query($strSql . $strWhere); if (is_array($arrServices)) { foreach ($arrServices as $k => $v) { $arrFavorite = db_factory::get_count(sprintf('select count(*) from %s where uid = %d and obj_id = %d and keep_type = "service"', TABLEPRE . 'witkey_favorite', intval($gUid), intval($v['service_id']))); if ($arrFavorite) { $arrServices[$k]['favorite'] = true; } unset($arrFollow); } } $arrFeedPubs = kekezu::get_feed("(feedtype='pub_task' or feedtype='pub_service')", "feed_time desc", 8); $arrRecommShops = db_factory::query(sprintf("select a.username,a.uid,b.indus_id,b.indus_pid,a.shop_name,if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate from %switkey_shop a " . " left join %switkey_space b on a.uid=b.uid where b.recommend=1 and b.status=1 and IFNULL(a.is_close,0)=0 and shop_status=1 order by good_rate desc limit 0,5", TABLEPRE, TABLEPRE), 1, $intIndexCacheTime); $arrGoodsType = array('6' => '文件', '7' => '服务'); $data = array('地区' => $arrCityone['name'] . $arrCitytwo['name'] . $arrCitythree['name'], '商品类型' => $arrGoodsType[$m], '行业' => $arrIndusPInfo['indus_name'], '子行业' => $arrIndusInfo['indus_name']); list($strPageTitle, $strPageKeyword, $strPageDescription) = keke_seo_class::getListSEO($pd, $i, $data, 'goods', true); $_SESSION['spread'] = 'index.php?do=goodslist'; function get_good_rate($rateuid) { $good_rate = db_factory::get_one("select if(seller_total_num>0,seller_good_num/seller_total_num,0) as good_rate from " . TABLEPRE . "witkey_space where uid=" . intval($rateuid)); return $good_rate[good_rate]; }
<?php defined('IN_KEKE') or exit('Access Denied'); $strNavActive = 'articlelist'; $strUrl = $_K['siteurl'] . "/index.php?do=articlelist"; $catid and $strUrl .= "&catid=" . intval($catid); $intPage and $strUrl .= "&intPage=" . $intPage; $arrArtCats = kekezu::get_table_data("*", "witkey_article_category", "cat_type='article' and art_cat_pid=1", "listorder asc", "", "", "", null); $page and $intPage = intval($page); $intPage = intval($intPage) ? $intPage : 1; $intPagesize = intval($intPagesize) ? $intPagesize : 20; intval($catid) and $intCatid = intval($catid) or $intCatid = intval($arrArtCats['0']['art_cat_id']); $intCatid and $strWhere .= " and a.art_cat_id = " . intval($intCatid); $strWhere .= " and a.is_show!=2"; $strWhere .= " order by is_recommend desc,a.listorder asc,pub_time desc"; $strSql = "select a.* ,b.cat_name from " . TABLEPRE . "witkey_article a left join " . TABLEPRE . "witkey_article_category b on a.art_cat_id=b.art_cat_id where b.cat_type='article' {$strWhere}"; $strCsql = "select count(a.art_id) as c from " . TABLEPRE . "witkey_article a left join " . TABLEPRE . "witkey_article_category b on a.art_cat_id=b.art_cat_id where b.cat_type='article' {$strWhere}"; $intCount = intval(db_factory::get_count($strCsql, 0, NULL, 10 * 60)); $kekezu->_page_obj->setStatic($static); $strPages = $kekezu->_page_obj->getPages($intCount, $intPagesize, $intPage, $strUrl); $arrArticleLists = db_factory::query($strSql . $strPages['where'], 5 * 60); foreach ($arrArtCats as $k => $v) { intval($v['art_cat_id']) == $intCatid and $articleType = $v['cat_name']; } list($strPageTitle, $strPageKeyword, $strPageDescription) = keke_seo_class::getListSEO(0, 0, array('资讯分类' => $articleType), 'article', true); $arrHotNews = db_factory::query("select * from " . TABLEPRE . "witkey_article where cat_type='article' order by views desc limit 10"); $arrRecommShops = db_factory::query(sprintf("select a.username,a.uid,b.indus_id,b.indus_pid,a.shop_name,if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate from %switkey_shop a " . " left join %switkey_space b on a.uid=b.uid where b.recommend=1 and b.status=1 and IFNULL(a.is_close,0)=0 and shop_status=1 order by good_rate desc limit 0,5", TABLEPRE, TABLEPRE), 1, $intIndexCacheTime); $_SESSION['spread'] = 'index.php?do=articlelist';
$strSql = 'select * from ' . TABLEPRE . 'witkey_case where '; $strWhere = ' 1=1 '; if ($t == '1') { $strWhere .= ' and obj_type="task" '; } else { if ($t == '2') { $strWhere .= ' and obj_type="service" '; } } $intCount = db_factory::get_count(' select count(case_id) as c from ' . TABLEPRE . 'witkey_case where ' . $strWhere, 0, null, 3600); $strPages = $kekezu->_page_obj->getPages($intCount, $intPagesize, $intPage, $strUrl); $arrCaseLists = db_factory::query($strSql . $strWhere . ' order by on_time desc ' . $strPages['where']); } $arrModelLabel = array(0 => '未知', 1 => '单人', 2 => '多人', 3 => '计件', 4 => '招标', 5 => '订金', 6 => '文件', 7 => '服务'); $arrCaseType = array('0' => '全部', '1' => '任务案例', '2' => '商品案例'); list($strPageTitle, $strPageKeyword, $strPageDescription) = keke_seo_class::getListSEO(0, 0, array('案例类型' => $arrCaseType[$t]), 'case', true); foreach ($arrCaseLists as $caseK => $caseV) { if ($caseV['obj_type'] == 'task') { $arrTaskSql = 'select model_id,task_id,task_title,work_num,uid,username,task_pic,focus_num from ' . TABLEPRE . 'witkey_task where task_id = ' . $caseV['obj_id']; $arrTaskInfo = db_factory::get_one($arrTaskSql); $arrCaseLists[$caseK]['labelstyle'] = 'marked-task'; $arrCaseLists[$caseK]['text'] = '投稿'; $arrCaseLists[$caseK]['quantifier'] = '个'; $arrCaseLists[$caseK]['focus_num'] = $arrTaskInfo['focus_num']; $arrCaseLists[$caseK]['from'] = '发布者'; $arrCaseLists[$caseK]['num'] = intval($arrTaskInfo['work_num']); $arrCaseLists[$caseK]['objurl'] = $arrTaskInfo['task_id'] ? 'index.php?do=task&id=' . $arrTaskInfo['task_id'] : "javascript:tipsOp('该项目的源不存在,无法访问','warning')"; $arrCaseLists[$caseK]['label'] = $arrModelLabel[intval($arrTaskInfo['model_id'])]; $arrCaseLists[$caseK]['fromurl'] = $arrTaskInfo['uid'] ? 'index.php?do=seller&id=' . $arrTaskInfo['uid'] : "javascript:tipsOp('该项目的源不存在,无法访问','warning')"; $arrCaseLists[$caseK]['username'] = $arrTaskInfo['username'] ? $arrTaskInfo['username'] : '******'; unset($arrTaskInfo);