<?php
if ($_POST[button02]) {
    
      $query = "select gjc,count(DISTINCT ip) as cip,count(yjsf) as dj,sum(duihua) as dh,sum(zqfwcs) as fw,(count(yjsf)-sum(duihua)) as wdh,(count(yjsf)/sum(duihua)) as bl,sum(yuyue) as yuyue,(sum(yuyue)/sum(duihua)) as yuyuelv from (SELECT * FROM `dede_url_quan` where UNIX_TIMESTAMP(ksfwsj)<=".strtotime($et)." and UNIX_TIMESTAMP(ksfwsj)>=".strtotime($st)."  and ccfwwz like '%$k%') as be GROUP BY gjc order by $order $flag limit $offset,$pagesize";
       
  $dsql->SetQuery($query);
  $dsql->Execute();
  $fp=fopen("./temlates/djdh_bd.htm","r");
$str2=fread($fp,filesize("./temlates/djdh_bd.htm"));
$htmlstr2 =array();
$htmlstr2 =explode("{tengcong:list2}",$str2);
$htmlstring2="";
$zhongjian2="";
$htmlstr2[0]=str_replace("{tengcong:field name=zdj}",$zdj,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=bdzdj}",$bdzdj,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=wmzdj}",$wmzdj,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zdh}",$zdh,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zdhss}",$zdhss,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zdhwm}",$zdhwm,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zyy}",$zyy,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zyyss}",$zyyss,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=zyywm}",$zyywm,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=k}",$k,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=st}",$st,$htmlstr2[0]);
$htmlstr2[0]=str_replace("{tengcong:field name=et}",$et,$htmlstr2[0]);
    
  while($row = $dsql->GetArray()){
        
      $zhongjian2=$htmlstr2[1];
       $zhongjian2=str_replace("{tengcong:field name=k}",$k,$zhongjian2);
        $zhongjian2=str_replace("{tengcong:field name=st}",$st,$zhongjian2);
         $zhongjian2=str_replace("{tengcong:field name=et}",$et,$zhongjian2);
      $zhongjian2=str_replace("{tengcong:field name=gjc}",$row["gjc"],$zhongjian2);
      $zhongjian2=str_replace("{tengcong:field name=fw}",$row["fw"],$zhongjian2);
       $zhongjian2=str_replace("{tengcong:field name=dj}",$row["dj"],$zhongjian2);
        $zhongjian2=str_replace("{tengcong:field name=cip}",$row["cip"],$zhongjian2);
         $zhongjian2=str_replace("{tengcong:field name=wdh}",$row["wdh"],$zhongjian2);
           
         $krxxs=$dsql->GetOne("SELECT count(krxxs) as krxxs FROM `dede_url_quan` where UNIX_TIMESTAMP(ksfwsj)<=".strtotime($et)." and UNIX_TIMESTAMP(ksfwsj)>=".strtotime($st)." and gjc='".$row["gjc"]."' and duihua=1 and krxxs<=4");
           
          $zhongjian2=str_replace("{tengcong:field name=krxxs}",$krxxs["krxxs"],$zhongjian2);
            
            
           $zhongjian2=str_replace("{tengcong:field name=dh}",$row["dh"],$zhongjian2);
             
             
           $krxxs4=$dsql->GetOne("SELECT count(krxxs) as krxxs FROM `dede_url_quan` where UNIX_TIMESTAMP(ksfwsj)<=".strtotime($et)." and UNIX_TIMESTAMP(ksfwsj)>=".strtotime($st)." and gjc='".$row["gjc"]."' and duihua=1 and krxxs>4");
             
            $zhongjian2=str_replace("{tengcong:field name=krxxs4}",$krxxs4["krxxs"],$zhongjian2);
              
              
            $bl=sprintf("%.1f",$row["bl"]);
    if($bl==0) echo $zhongjian2=str_replace("{tengcong:field name=bl}","",$zhongjian2);
    else echo $zhongjian2=str_replace("{tengcong:field name=bl}",$bl,$zhongjian2);
      
      
      
              
            $zhongjian2=str_replace("{tengcong:field name=yuyue}",$row["yuyue"],$zhongjian2);
              
            $yuyuelv=sprintf("%.1f",$row["yuyuelv"]);
    if($yuyuelv==0) echo $zhongjian2=str_replace("{tengcong:field name=yuyuelv}","",$zhongjian2);
    else echo $zhongjian2=str_replace("{tengcong:field name=yuyuelv}",$yuyuelv,$zhongjian2);
      
      
            $htmlstring2=$htmlstring2.$zhongjian2;
        
        
        
  }
  fclose($fp);
                           
                         
$handle=fopen("./jingtai/djdh_bd/index.html","w+");
fwrite($handle,$htmlstr2[0].$htmlstring2.$htmlstr2[2]);
echo "<font color='red'>正在生成</font><br>";
 fclose($handle);
 echo "<script>alert('生成成功!');</script>";
 }
header('Location:/wangtengcong-zjz/plus/shengcheng.html');