<?php

 
require 'common.inc.php';      
class main extends utility  
{                
    private $initDB;    
    public $db; 
    
    public function __construct()
    {   
        $db = new db();    
        $db->DBselect("mycms");
        //$db->DBselect("mycms","GBK");//gbk页面用到  
        $this->db = $db; 
        $this->tpl = template::instance();                
    }


function run()
{
@$type=$this->GET('type')?$this->GET('type'):"index";
$rs['title']="锦江环境"; 


if( in_array($type,array("report", "directors", "management", "company","milepost","honor"))){
$rs['menub']=" on";    
}

if( in_array($type,array("investor-announcement", "investor-announcement", "investor-performance", "investor-shareholders","investor-stock","investor-financial","investor-risk-factors"))){
$rs['menuc']=" on";    
}

if( in_array($type,array("services", "territory", "research", "prospect","energy"))){
$rs['menud']=" on";    
}

if( in_array($type,array("responsibility", "environmentalprotection", "communitycare", "charity","cultivation_a"))){
$rs['menue']=" on";    
}

if( in_array($type,array("news", "newsview", "mediacontact"))){
$rs['menuf']=" on";    
}

if( in_array($type,array("joinus", "job", "plan"))){
$rs['menug']=" on";    
}

$sql = "SELECT * FROM allcms_sys_pingdao where  upid=0  and zhuangtai=1 ORDER BY xu desc "; 
$ras = $this->db->getAll($sql);
 foreach ($ras as $rts) {
            $sql = "select * from allcms_sys_pingdao where  upid={$rts['id']} and zhuangtai=1 order by  xu desc";

            $rts['lanmu'] = $this->db->getAll($sql);
            $rs['menu'][] = $rts;
 } 


if(method_exists($this,$type)){
$a=$this->$type();
if($a){
$rs=array_merge($rs,$a);//合并两个数组，class返回数组及现在数组    
}

}else{

 
$sql="select * ,(select muban from allcms_sys_pingdao where pid=allcms_sys_pingdao.id) as mubana from allcms_sys_danye where seourl='{$this->GET('type')}' and zhuangtai=1 and isdel=0 LIMIT 1";
$rs['row']= $this->db->getrow($sql);   
if($rs['row']){

if($rs['row']['pid']==1){
$rs['menua']="on";//确定菜单的样式 
} 
if($rs['row']['pid']==2){
$rs['menub']="on";//确定菜单的样式 
}
if($rs['row']['pid']==8){
$rs['menuc']="on";//确定菜单的样式 
}
if($rs['row']['pid']==3){
$rs['menud']="on";//确定菜单的样式 
}
if($rs['row']['pid']==4){
$rs['menue']="on";//确定菜单的样式 
}
if($rs['row']['pid']==5){
$rs['menuf']="on";//确定菜单的样式 
}
if($rs['row']['pid']==6){
$rs['menug']="on";//确定菜单的样式 
}

if($rs['row']['pid']==8){
$rs['menuh']="on";//确定菜单的样式 
}


if($rs['row']['pid']==35){
$rs['menui']="on";//确定菜单的样式 
}
 

if($rs['row']['muban']!=""){  
$type=$rs['row']['muban'];
}else
{
if($rs['row']['mubana']!=""){     
$type=$rs['row']['mubana'];
}    
else
{
$type="tongyong";    
}
}

}    
 else{   
$this->index();
$rs=array_merge($rs,$this->index());//合并两个数组，class返回数组及现在数组
$type="index"; 
}
  
}


//关于我们
$typearray = array("report", "director", "management", "company");
if( in_array($type,$typearray)){
$type="report";    
}


//业务概览
$typearray = array("services", "prospect");
if( in_array($type,$typearray)){
$type="services";    
}


//社会责任
$typearray = array("responsibility", "cultivation","responsibilityreport");
if( in_array($type,$typearray)){
$type="responsibility";    
}


//就业机会
$typearray = array("joinus", "plan");
if( in_array($type,$typearray)){
$type="joinus";    
}


//合作伙伴 通用模板
$typearray = array("cooperation", "partners");
if( in_array($type,$typearray)){
$type="cooperation";    
}

 if($type=="search"){
$type="news";
}

//print_r($rs);

$this->tpl->display($type.".html",$rs); 

}


 //免责声明
function disclaimer()
{
$sql = "SELECT * FROM allcms_sys_danye where id=20";
$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
return  $rs;
}  
     
      
 //联系我们
function contactus()
{
$sql = "SELECT * FROM allcms_sys_danye where id=19";
$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
return  $rs;
}       
      

 //管理培训生计划
function plan()
{
$sql = "SELECT * FROM allcms_sys_danye where id=18";
$rs['row']= $this->db->getRow($sql);
return  $rs;
} 


 //暂缺职位
function job()
{

//$rs['menu']['a']=" class=\"center\"";//确定菜单的样式
//return  $rs;
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$sqla="SELECT * FROM allcms_job where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_job where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=200;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"job",0,10);

$sql="select * from  allcms_miaoshu where id=1" ;
$neirong=$this->db->getrow($sql);
$rs['neirong']=$neirong['neirong'];

return  $rs;    


} 


 //成为锦江人
function joinus()
{
$sql = "SELECT * FROM allcms_sys_danye where id=17";
$rs['row']= $this->db->getRow($sql);
return  $rs;
}  


 //培育员工
function cultivation()
{
global $jiangrong;
$rs['menu']['a']=" class=\"center\"";//确定菜单的样式
return  $rs;
}  


 //公益慈善
function charity()
{
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=1;
 
if($typeid<>0){
$t=" and  typeid={$typeid}";    
}

$sqla="SELECT * FROM allcms_product where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_product where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"news-".$typeid,0,10);

return  $rs;
    
}  


 //社会关怀
function communitycare()
{
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=3;
 
if($typeid<>0){
$t=" and  typeid={$typeid}";    
}

$sqla="SELECT * FROM allcms_product where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_product where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"news-".$typeid,0,10);
 

return  $rs;
}  

 
 //环境保护
function environmentalprotection()
{
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=2;
 
if($typeid<>0){
$t=" and  typeid={$typeid}";    
}

$sqla="SELECT * FROM allcms_product where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_product where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=20;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"news-".$typeid,0,10);


return  $rs;
}  

 
//社会责任总览
function responsibility()
{
 $sql = "SELECT * FROM allcms_sys_danye where id=15";
$rs['row']= $this->db->getRow($sql);
return  $rs;
}


//股票信息
function stock()
{
$rs['a']="1";
$rs['menuh']="on";//确定菜单的样式 
return  $rs;
}


//环境公示
function Environmentalmanagementpublicity()
{
$rs['a']="1";
$rs['menui']="on";//确定菜单的样式 
return  $rs;
}


//3.4锦江环境展望prospect 
function prospect()
{
 $sql = "SELECT * FROM allcms_sys_danye where id=6";
$rs['row']= $this->db->getRow($sql);
return  $rs;
}


//奖项及嘉许 
function honor()
{
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 

$sqla="SELECT * FROM allcms_honor where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_honor where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"honor",0,10);
return  $rs;
}


//科研成果research
function research()
{
//$sql = "SELECT * FROM allcms_sys_danye where id=14";
//$rs['row']= $this->db->getRow($sql);
//return  $rs;

$sql="SELECT * FROM allcms_tech where zhuangtai=1 and isdel=0 and  iscommend=1 order by dateline desc";
$rs['tuijian']=$this->db->getall($sql);
 

$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 

$sqla="SELECT * FROM allcms_tech where zhuangtai=1 and isdel=0 and iscommend=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_tech where zhuangtai=1 and  isdel=0 and iscommend=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"research",0,10); 

return  $rs;


}

//节约能源energy

function energy()
{
//$sql = "SELECT * FROM allcms_sys_danye where id=14";
//$rs['row']= $this->db->getRow($sql);
//return  $rs;

$sql="SELECT * FROM allcms_jieneng where zhuangtai=1 and isdel=0 and  iscommend=1 order by dateline desc";
$rs['tuijian']=$this->db->getall($sql);
 

$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 

$sqla="SELECT * FROM allcms_jieneng where zhuangtai=1 and isdel=0 and iscommend=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_jieneng where zhuangtai=1 and  isdel=0 and iscommend=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"research",0,10); 

return  $rs;

}

//业务版图
function territory()
{
//$sql = "SELECT * FROM allcms_sys_danye where id=5";
//$rs['row']= $this->db->getRow($sql);
//return  $rs;
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid") ? $this->REQUEST("typeid") :"0";
$sql="select * from allcms_sys_quyu where zhuangtai=1 order by xu asc,id desc";
$rs['type']= $this->db->getAll($sql);  
if($typeid<>0){
$t=" and  typeid={$typeid}";    
}

$sqla="SELECT * FROM allcms_case where zhuangtai=1 and isdel=0 ".$t;
$sqls="SELECT count(*) as zongshu FROM allcms_case where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"territory-".$typeid,0,10);
 

return  $rs;


}


//综合环境服务
function services()
{
$sql = "SELECT * FROM allcms_sys_danye where id=4";
$rs['row']= $this->db->getRow($sql);
return  $rs;
}


//里程碑
function milepost()
{
//$sql = "SELECT * FROM allcms_sys_danye where id=13";
//$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 order by dateline desc"; 
$rs['type']= $this->db->getAll($sql);

$typeid = $this->REQUEST("typeid");

if(!$typeid){
$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 order by dateline desc limit 1";   
}else
{  
$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 and id={$typeid}";
     
}
$rs['row']= $this->db->getRow($sql);
 
return  $rs;
}


//总览
function company()
{
$sql = "SELECT * FROM allcms_sys_danye where id=3";
$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
return  $rs;
}


//企业管理
function management()
{
 $sql = "SELECT * FROM allcms_sys_danye where id=12";
$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
return  $rs;
}


//董事会成员
function directors()
{
$sql = "SELECT * FROM allcms_sys_danye where id=11";
$rs['row']= $this->db->getRow($sql);
$sql = "SELECT * FROM allcms_news where  zhuangtai=1 and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
return  $rs;
}


//公司介绍
function report()
{


$sql = "SELECT * FROM allcms_sys_danye where id=2";
$rs['row']= $this->db->getRow($sql); 
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 
//$rs['row']['jianjiecontent']=str_replace("[CHANNELPATH][UPFILEPATH]","uploadfiles/",$rs['row']['jianjiecontent']); 
//$rs['hot']=$this->getnew(6);   
return  $rs;
}

//新闻检索
function search()
{    
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid");


if($typeid!=""){
$t=" and  (title  like '%{$typeid}%' or  keywords  like '%{$typeid}%') ";
}
 
$sqla="SELECT *,(select typename from allcms_newstype where id=typeid) as typename FROM allcms_news where zhuangtai=1 and isdel=0 ".$t;

$sqls="SELECT count(*) as zongshu FROM allcms_news where zhuangtai=1 and  isdel=0 ".$t;
$sqlb=" order by dateline desc ";
$tiaojian=" ";
$num=100;
$sqlshu= $sqls.$tiaojian;

$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"search-".$typeid,0,10);
 $rs['menuf']="on"; 

return  $rs;
}  

//新闻列表页
function news()
{    
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid") ? $this->REQUEST("typeid") : 1;
$sqltype="select * from allcms_newstype where id={$typeid}";
$rs['type']= $this->db->getRow($sqltype);  

$sqla="SELECT *,(select typename from allcms_newstype where id=typeid) as typename FROM allcms_news where zhuangtai=1 and isdel=0 and  typeid={$typeid}";
$sqls="SELECT count(*) as zongshu FROM allcms_news where zhuangtai=1 and  isdel=0  and  typeid={$typeid}";
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"news-".$typeid,0,10);


return  $rs;
}  


//披露信息列表页
function info()
{   
$rs['menuh']="on";//确定菜单的样式  
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid");

if ($typeid=="")
{
$typeid=0;   
}
if($typeid!=0){
$sqltiao=" id={$typeid}";
$sqltiaoa=" and typeid={$typeid}";
}else{
    
}

$sqltype="select * from allcms_infotype where".$sqltiao;
$rs['type']= $this->db->getRow($sqltype);  

$sqla="SELECT *,(select typename from allcms_infotype where id=typeid) as typename FROM allcms_info where zhuangtai=1 and isdel=0 ".$sqltiaoa;
$sqls="SELECT count(*) as zongshu FROM allcms_info where zhuangtai=1 and  isdel=0 ".$sqltiaoa;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"info-".$typeid,0,10);


return  $rs;
} 


//社会责任报告
function responsibilityreports()
{   
$rs['menuh']="on";//确定菜单的样式  
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid");

if($typeid!=""){
$sqltiao=" id={$typeid}";
$sqltiaoa=" and typeid={$typeid}";
    
    
}

$sqltype="select * from allcms_responsibilityreportstype where".$sqltiao;
$rs['type']= $this->db->getRow($sqltype);  

$sqla="SELECT *,(select typename from allcms_responsibilityreportstype where id=typeid) as typename FROM allcms_responsibilityreports where zhuangtai=1 and isdel=0 ".$sqltiaoa;
$sqls="SELECT count(*) as zongshu FROM allcms_responsibilityreports where zhuangtai=1 and  isdel=0 ".$sqltiaoa;
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"responsibilityreports-".$typeid,0,10);


return  $rs;
} 


//投资者日志
function rlog()
{    
    $rs['menuh']="on";//确定菜单的样式 
$page = $this->REQUEST("page") ? $this->REQUEST("page") : 1; 
$typeid=$this->REQUEST("typeid") ? $this->REQUEST("typeid") : 1;
$sqla="SELECT * FROM allcms_log where zhuangtai=1 and isdel=0 ";
$sqls="SELECT count(*) as zongshu FROM allcms_info where zhuangtai=1 and  isdel=0  ";
$sqlb=" order by dateline desc ";
$tiaojian="";
$num=10;
$sqlshu= $sqls.$tiaojian;
$numzong= $this->db->getRow($sqlshu);
$rs['numzong']=$numzong['zongshu'];
$rs['res'] =$this->datalist($sqla,$tiaojian,$sqlb,$num,$page); 
$pg = new pagejing;
$rs['showpage'] = $pg->multi($rs['numzong'],$num,$page,"rlog-".$typeid,0,10);
return  $rs;
} 


function datalist($sqla,$tiaojian,$sqlb,$num,$page='1') //sqla基本语句，sqlb排序语句，$num一页多少
{
global $jiangrong;            
//$sqla = "SELECT * FROM allcms_news  where  verify=1 "; 
//$sqlb = " ORDER BY id DESC ";
if($page)
{
$pagenum = ($page - 1)*$num;
$sqlnum  = sprintf(" LIMIT %s,"."$num",$pagenum);  
}
else
{
$sqlnum  = " LIMIT ".$num ;    
}
$sql = $sqla.$tiaojian.$sqlb.$sqlnum;
$sop =$this->db->GetAll($sql); 
return $sop;  
}


//新闻查看页面
function newsview()
{

$id=$this->GET("id");
$sql = "SELECT * FROM allcms_news where  zhuangtai=1 and isdel=0 and id={$id}";
//echo $sql;
$rs['row']= $this->db->getRow($sql); 
$sql="UPDATE allcms_news SET hits=hits+1 where  zhuangtai=1 and isdel=0  and id={$id}";
$this->db->Execute($sql); 
return  $rs;
}


//日志查看页面
function logview()
{
$rs['menuh']="on";//确定菜单的样式 
$id=$this->GET("id");
$sql = "SELECT * FROM allcms_log where  zhuangtai=1 and isdel=0 and id={$id}";
//echo $sql;
$rs['row']= $this->db->getRow($sql); 
$sql="UPDATE allcms_log SET hits=hits+1 where  zhuangtai=1 and isdel=0  and id={$id}";
$this->db->Execute($sql); 
return  $rs;
}

//信息披露查看页面
function infoview()
{
 $rs['menuh']="on";//确定菜单的样式 
$id=$this->GET("id");
$sql = "SELECT * FROM allcms_info where  zhuangtai=1 and isdel=0 and id={$id}";
//echo $sql;
$rs['row']= $this->db->getRow($sql); 
$sql="UPDATE allcms_info SET hits=hits+1 where  zhuangtai=1 and isdel=0  and id={$id}";
$this->db->Execute($sql); 
return  $rs;
}


//社会责任报告查看页面
function responsibilityreportsview()
{
 $rs['menuh']="on";//确定菜单的样式 
$id=$this->GET("id");
$sql = "SELECT * FROM allcms_responsibilityreports where  zhuangtai=1 and isdel=0 and id={$id}";
//echo $sql;
$rs['row']= $this->db->getRow($sql); 
$sql="UPDATE allcms_responsibilityreports SET hits=hits+1 where  zhuangtai=1 and isdel=0  and id={$id}";
$this->db->Execute($sql); 
return  $rs;
}


//首页    
function index()
{
$sql = "SELECT * FROM allcms_news where islight=1 and zhuangtai=1 and isdel=0 order by dateline desc limit 3";
$rs['huandeng']= $this->db->getall($sql); 
//islight<>1 and 不是幻灯的条件
$sql = "SELECT * FROM allcms_news where  zhuangtai=1  and isdel=0 order by dateline desc limit 6";
$rs['news']= $this->db->getall($sql); 

//$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 order by dateline asc limit 20";
$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 and id in(SELECT id FROM ((SELECT id FROM allcms_lichengbei where zhuangtai=1 and isdel=0 order by dateline desc limit 20) as t)) order by dateline asc limit 20";
$rs['lichengbeia']= $this->db->getAll($sql); 

$sql="SELECT * FROM allcms_lichengbei where zhuangtai=1 and isdel=0 order by dateline desc limit 20";
$lichengbei= $this->db->getAll($sql);
foreach($lichengbei as $rts){
//$rts['content']=str_replace("<ul class=\" list-paddingleft-2\" style=\"list-style-type: disc;\"><li><p>","<span><i></i><em>",$rts['content']);
//$rts['content']=str_replace("<\/p></li><\/ul>","<\/em><\/span>",$rts['content']);
$rts['content']=str_replace("<ul class=\" list-paddingleft-2\" style=\"list-style-type: disc;\"><li><p>","<span><i></i><em>",$rts['content']);
$rts['content']=str_replace("</p></li></ul>","</em></span>",$rts['content']);
$rts['content']=str_replace("<li><p>","<span><i></i><em>",$rts['content']);
$rts['content']=str_replace("</p></li>","</em></span>",$rts['content']);


$res[]=$rts; 
}
$rs['lichengbei']=$res;


return  $rs;
}


}
$run= new main;
$run->run();

?>