if($folder=="inbox"||$folder=='') $postuser = "******";
if(!empty($keyword)) $whereSql .= " AND (subject like '%".$keyword."%' OR message like '%".$keyword."%')";
if(!empty($username)) $whereSql .= " AND msgfrom like '%".$username."%'";
function GetFolders($me){
if($me=="track") return "发件箱";
else if($me=="inbox") return "收件箱";
else if($me=="outbox") return "草搞箱";
}
function IsReader($me){
$me = ereg_replace("[^0-1]","",$me);
if($me) return "<font color='green'>×</font>";
else return "<font color='red'>√</font>";
}
$sql = "SELECT * FROM #@__pms $whereSql ORDER BY dateline desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("folder",$folder);
$dlist->SetParameter("username",$username);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/member_pm.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
function GetSta($sta)
{
if($sta==1) return "内页";
if($sta==2) return "首页";
else return "未审核";
}
$addquery = " where 1=1 ";
if($ischeck!=-1){
if($ischeck==3) $addquery .= " And ischeck>0 ";
else $addquery .= " And ischeck='$ischeck' ";
}
if(!empty($keyword)){
$addquery .= " And (url like '%$keyword%' OR webname like '%$keyword%') ";
}
$sql = "";
$sql = "Select * From #@__flink $addquery order by dtime desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("ischeck",$ischeck);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/friendlink_main.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
case "4":
//按肋记词
$query = "select * from #@__mainkc,#@__basic where #@__basic.cp_helpword LIKE '%" . $stext . "%' and #@__basic.cp_categories='{$cp_categories}' and #@__basic.cp_categories_down='{$cp_categories_down}' and #@__mainkc.p_id=#@__basic.cp_number";
break;
}
} else {
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.p_id=#@__basic.cp_number";
}
//echo $query;
//exit();
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("cp_categories", $cp_categories);
$dlist->SetParameter("cp_categories_down", $cp_categories_down);
$dlist->SetParameter("sort", $sort);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>￥" . $row['cp_jj'] . "</td><td>" . get_name($row['p_id'], 'gys') . "</td><td>" . get_name($row['l_id'], 'lab') . "</td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
?>
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
if ($action == 'seek') {
if ($s_number == '') {
echo "<script>alert('请输入要退货的销售单号');history.go(-1);</script>";
}
$query = "select * from #@__sale where rdh='{$s_number}' and productid LIKE '%" . $stext . "%'";
} else {
$query = "select * from #@__sale";
}
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
$dlist->SetParameter("form", $form);
$dlist->SetParameter("field", $field);
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("s_number", $s_number);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>售价</td><td>供应商</td><td>销售单号</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['productid'] . "</td><td> " . get_name($row['productid'], 'name') . "</td><td>" . get_name($row['productid'], 'gg') . "</td><td>￥" . getsale($row['productid']) . "</td><td>" . get_name($row['productid'], 'gys') . "</td><td>" . $row['rdh'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . get_name($row['productid'], 'name') . "' onclick=\"selectpro(this.value," . $row['productid'] . ",'" . get_name($row['productid'], 'gg') . "','" . get_name(get_name($row['productid'], 'dwname'), 'dw') . "')\"></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
}
function IsExData($isex){
if($isex==0) return "未导出";
else return "已导出";
}
if($nid!=""){
$exportbt = "<input type='button' name='b0' value='导出采集内容' class='inputbut' style='width:100' onClick=\"location.href='co_export.php?nid=$nid';\"> ";
}
else{
$exportbt = "";
}
$sql .= "Select #@__courl.aid,#@__courl.nid,#@__courl.isex,#@__courl.title,#@__courl.url,";
$sql .= "#@__courl.dtime,#@__courl.isdown,#@__conote.gathername From #@__courl ";
$sql .= " left join #@__conote on #@__conote.nid=#@__courl.nid $where";
$sql .= " order by #@__courl.aid desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("nid",$nid);
$dlist->SetParameter("small",$small);
$dlist->SetSource($sql);
if($small==0) include(dirname(__FILE__)."/templets/co_url.htm");
else include(dirname(__FILE__)."/templets/co_url_2.htm");
$dlist->Close();
ClearAllLink();
?>
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
$bgcolor = "";
if(!isset($keyword)) $keyword="";
if(!isset($typeid)) $typeid="0";
function IsCheck($st)
{
if($st==1) return "[已审核]";
else return "<font color='red'>[未审核]</font>";
}
$querystring = "select * from #@__feedback where CONCAT(#@__feedback.msg,#@__feedback.arctitle) like '%$keyword%' order by dtime desc";
$dlist = new DataList();
$dlist->pageSize = 10;
$dlist->Init();
$dlist->SetParameter("typeid",$typeid);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($querystring);
include(dirname(__FILE__)."/templets/feedback_main.htm");
$dlist->Close();
ClearAllLink();
?>
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
function GetSta($sta)
{
if($sta==1) return "正常";
else return "<font color='red'>禁用</font>";
}
function GetMan($sta)
{
if($sta==1) return "<u>禁用</u>";
else return "<u>启用</u>";
}
if(empty($keywords)) $keywords = "";
$sql = "Select * from #@__keywords order by rank desc";
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 300;
$dlist->SetParameter("f",$f);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/article_keywords_select.htm");
$dlist->Close();
ClearAllLink();
?>
}
}
function GetAreaName($e,$df)
{
global $Areas;
if(isset($Areas[$e])) return $Areas[$e];
else return $df;
}
function GetMAtt($m){
if($m<1) return "";
else return "<img src='img/adminuserico.gif' width='16' height='15'><font color='red'>(荐)</font>";
}
$sql = "select ID,userid,pwd,uname,sex,email,money,c1,c2,c3,matt,
logintime,loginip,membertype,scores,spaceshow,pageshow
From #@__member $whereSql order by $sortkey desc
";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("sex",$sex);
$dlist->SetParameter("status",$status);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/member_main.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
function GetSta($sta)
{
if($sta==1) return "";
else return " checked";
}
if(empty($keyword)){ $keyword = ""; $addquery = ""; }
else $addquery = " where keyword like '%$keyword%'";
$sql = "Select * from #@__keywords $addquery order by rank desc";
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 30;
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/article_keywords_main.htm");
$dlist->Close();
ClearAllLink();
?>
<tr>
<td> </td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 销售单管理</strong> - <a href="sale.php">新单</a></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$query = "select * from #@__reportsale";
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
$dlist->SetParameter("action", $action);
//设置GET参数表
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>ID</td><td>销售单号</td><td>操作人员</td><td>创单时间</td><td>保存状态</td><td>相关操作</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
if ($row['r_status'] == 1) {
$statusstring = "<img src='images/yes.png'>";
} else {
$statusstring = "<img src='images/no.png'>";
}
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['r_dh'] . "</td><td> " . $row['r_people'] . "</td><td> " . $row['r_date'] . "</td><td> " . $statusstring . "</td><td><span onclick=showsubinfo(" . $row['id'] . ") style='cursor:hand;'>展开详情</span> | <a href=system_basic_del.php?id=" . $row['id'] . ">打印此单</a></td></tr>";
echo "<tr id='rk_subinfo" . $row['id'] . "' style='display:none;'><td colspan='6'><br><table width=\"98%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\" align=\"center\">";
$csql1 = new Dedesql(false);
$csql1->SetQuery("select * from #@__sale where rdh='" . $row['r_dh'] . "'");
$csql1->Execute();
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
if ($action == 'seek') {
if ($stext == '' || !is_numeric($stext) || $stext < 0) {
echo "<script>alert('请输入正确的数字');history.go(-1);</script>";
}
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<'{$stext}' and #@__mainkc.p_id=#@__basic.cp_number";
} else {
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<5 and #@__mainkc.p_id=#@__basic.cp_number";
}
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>￥" . $row['cp_jj'] . "</td><td><a href='' title='查看与该供应商的数据'>" . get_name($row['p_id'], 'gys') . "</a></td><td><a href='' title='查看此仓库所有产品'>" . get_name($row['l_id'], 'lab') . "</a></td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
?>
</td>
</tr></form>
</table>
$nowtime = time();
$starttime = $nowtime - ($dtime*24*3600);
$where .= " And #@__log.dtime>'$starttime' ";
}
$sql = "Select #@__log.*,#@__admin.userid From #@__log
left join #@__admin on #@__admin.ID=#@__log.adminid
where 1=1 $where order by #@__log.lid desc";
$adminlist = "";
$dsql = new DedeSql(false);
$dsql->SetQuery("Select ID,uname From #@__admin");
$dsql->Execute('admin');
while($myrow = $dsql->GetObject('admin')){
$adminlist .="<option value='{$myrow->ID}'>{$myrow->uname}</option>\r\n";
}
$dsql->Close();
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 20;
$dlist->SetParameter("adminid",$adminid);
$dlist->SetParameter("cip",$cip);
$dlist->SetParameter("dtime",$dtime);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/log_list.htm");
$dlist->Close();
ClearAllLink();
?>
$whereSql .= " And (arc.title like '%$keyword%' Or arc.keywords like '%$keyword%' Or arc.addinfos like '%$keyword%') ";
}
if($typeid!=0){
$tids = $tl->GetSunID($typeid,'',$channelid,true);
$whereSql .= " And arc.typeid in($tids) ";
}
$query = "
select arc.aid as ID,arc.typeid,arc.uptime,arc.channelid,arc.arcrank,arc.title,
arc.litpic,arc.adminID,arc.mid,t.typename,c.typename as channelname
from `#@__full_search` arc
left join #@__arctype t on t.ID=arc.typeid
left join #@__channeltype c on c.ID=arc.channelid
$whereSql
order by aid desc
";
$dlist = new DataList();
$dlist->pageSize = 20;
$dlist->SetParameter("dopost","listArchives");
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("cid",$cid);
$dlist->SetParameter("f",$f);
$dlist->SetParameter("arcrank",$arcrank);
$dlist->SetParameter("channelid",$channelid);
$dlist->SetSource($query);
include(dirname(__FILE__)."/templets/content_select_list.htm");
ClearAllLink();
?>
$CheckUserSend = "<input type='button' onClick=\"location='full_list.php?arcrank=-1&channelid=$channelid';\" value='稿件审核' class='inputbut'>";
}
if(empty($orderby)) $orderby = "aid";
$query = "
select a.aid,a.adminid,a.typeid,a.uptime,a.channelid,a.arcrank,a.click,a.title,a.litpic,a.adminid,a.mid,
t.typename,c.typename as channelname,adm.uname as adminname
from `#@__full_search` a
left join `#@__arctype` t on t.ID=a.typeid
left join `#@__channeltype` c on c.ID=a.channelid
left join `#@__admin` adm on adm.ID=a.adminid
$whereSql order by a.aid desc
";
$dsql = new DedeSql(false);
$dlist = new DataList();
$dlist->pageSize = 20;
$dlist->SetParameter("dopost","listArchives");
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("adminid",$adminid);
$dlist->SetParameter("memberid",$memberid);
$dlist->SetParameter("cid",$cid);
$dlist->SetParameter("arcrank",$arcrank);
$dlist->SetParameter("channelid",$channelid);
$dlist->SetParameter("ismember",$ismember);
$dlist->SetParameter("orderby",$orderby);
$dlist->SetSource($query);
include_once(dirname(__FILE__)."/templets/full_list.htm");
$dlist->Close();
ClearAllLink();
?>
if(empty($buyid)) $buyid = '';
$addsql = " where buyid like '%$buyid%' ";
if(isset($sta)){
$addsql .= " And sta='$sta' ";
}
$sql = "Select * From #@__member_operation $addsql order by aid desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("buyid",$buyid);
if(isset($sta)){
$dlist->SetParameter("sta",$sta);
}
$dlist->dsql->SetQuery("Select * From #@__moneycard_type ");
$dlist->dsql->Execute('ts');
while($rw = $dlist->dsql->GetArray('ts')){
$TypeNames[$rw['tid']] = $rw['pname'];
}
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/member_operations.htm");
$dlist->Close();
ClearAllLink();
else return "附件/其它";
}
function GetFileSize($fs){
$fs = $fs/1024;
return sprintf("%10.1f",$fs)." K";
}
if(empty($keyword)) $keyword = "";
$addsql = " where (title like '%$keyword%' Or url like '%$keyword%') ";
if($mediatype==2) $addsql .= " And (mediatype='2' OR mediatype='3') ";
else if($mediatype>0) $addsql .= " And mediatype='$mediatype' ";
$addsql .= " And memberid='{$cfg_ml->M_ID}' ";
$sql = "Select aid,title,url,mediatype,filesize,uptime From #@__uploads $addsql order by aid desc";
//echo $sql;
$dlist = new DataList();
$dlist->pageSize = 20;
$dlist->Init();
$dlist->SetParameter("mediatype",$mediatype);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("f",$f);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/all_medias.htm");
$dlist->Close();
?>
if($sta==1) return '已售出';
else if($sta==-1) return '已使用';
else return '未使用';
}
$addsql = '';
if(isset($isexp)){
$addsql = " where isexp='$isexp' ";
}
$sql = "Select * From #@__moneycard_record $addsql order by aid desc";
$dlist = new DataList();
$dlist->Init();
if(isset($isexp)){
$dlist->SetParameter("isexp",$isexp);
}
$dlist->dsql->SetQuery("Select * From #@__moneycard_type ");
$dlist->dsql->Execute('ts');
while($rw = $dlist->dsql->GetArray('ts')){
$TypeNames[$rw['tid']] = $rw['pname'];
}
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/member_card.htm");
$dlist->Close();
ClearAllLink();
?>
} else {
$query = "select * from #@__accounts where dtime between '{$cp_sdate}' and '{$cp_edate}' order by dtime desc";
}
} else {
if ($atype != '') {
$query = "select * from #@__accounts where atype='{$atype}' order by dtime desc";
} else {
$query = "select * from #@__accounts order by dtime desc";
}
}
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("cp_sdate", $cp_sdate);
$dlist->SetParameter("cp_edate", $cp_edate);
}
$dlist->SetSource($query);
echo "<tr><td colspan='8' align='right'>" . $moneystring . " </td></tr>";
echo "<tr class='row_color_head'><td>ID号</td><td>科目</td><td>账户</td><td>操作用户</td><td>日期</td><td>金额</td><td>备注</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
$cmoney += $row['amoney'];
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['id'] . "</td><td> <a href='{$hurl}" . $row['atype'] . "'>" . $row['atype'] . "</td><td>" . getbank($row['abank']) . "</td><td>" . $row['apeople'] . "</td><td>" . $row['dtime'] . "</td><td>￥" . $row['amoney'] . "</td><td>" . $row['atext'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
}
echo "<tr><td colspan=\"8\"> 总计： ￥" . $cmoney . "元</td></tr>";
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
if(empty($membertype)) $membertype = 0;
if($membertype==1) $addsql .= " And u.adminID>0 ";
else if($membertype==2) $addsql .= " And u.memberID>0 ";
if(empty($mediatype)) $mediatype = 0;
if($mediatype>1) $addsql .= " And u.mediatype='$membertype' ";
if(!empty($memberid)) $addsql .= " And u.memberID='$memberid' ";
else $memberid = 0;
if(!empty($memberid)) $addsql .= " And u.memberid='$memberid' ";
$sql = "Select u.aid,u.title,u.url,u.mediatype,u.filesize,u.memberID,u.uptime
,a.userid as adminname,m.userid as membername
From #@__uploads u
Left join #@__admin a on a.ID = u.adminID
Left join #@__member m on m.ID = u.memberID
$addsql order by u.aid desc";
$dlist = new DataList();
$dlist->pageSize = 10;
$dlist->SetParameter("mediatype",$mediatype);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("membertype",$membertype);
$dlist->SetParameter("memberid",$memberid);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/media_main.htm");
$dlist->Close();
ClearAllLink();
?>
}
$wheresql .= " and typeid2=$sectorid2";
}
if($comname != ''){
$wheresql .= " and comname LIKE '%".$comname."%'";
}
$wheresql = trim($wheresql);
if(eregi("^and", $wheresql)) {
$wheresql = substr($wheresql,3);
}
if($wheresql != ''){
$wheresql = 'where '.trim($wheresql);
}
$companys = array();
$query = "select id, comname, regyear, areaid, areaid2, service, typeid1, typeid2, comaddr, website, postid
from #@__member_cominfo $wheresql";
$dlist = new DataList();
$dlist->pageSize = 10;
$dlist->SetParameter("sectorid",$sectorid);
$dlist->SetParameter("sectorid2",$sectorid2);
$dlist->SetParameter("areaid",$areaid);
$dlist->SetParameter("comname",$comname);
$dlist->SetParameter("areaid2",$areaid2);
$dlist->SetSource($query);
include(dirname(__FILE__)."/template/default/search_list.htm");
?>
global $dsql;
global $untjs;
if(!isset($untjs[$nid]))
{
$dsql->SetSql("Select count(aid) as kk From #@__courl where nid='$nid'");
$dsql->Execute();
$row = $dsql->GetObject();
$kk = $row->kk;
$untjs[$nid] = $kk." ";
}
return $untjs[$nid];
}
$where = "";
if(!isset($typeid)) $typeid="";
if(!empty($typeid)) $where = " where #@__conote.typeid='$typeid' ";
$sql = "Select #@__conote.nid,#@__conote.typeid,#@__conote.gathername,#@__conote.language,";
$sql .= "#@__conote.savetime,#@__conote.lasttime,#@__co_exrule.rulename as typename From #@__conote ";
$sql .= "left join #@__co_exrule on #@__co_exrule.aid=#@__conote.typeid ";
$sql .= " $where order by nid desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("typeid",$typeid);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/co_main.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
