WooYun.org

$dd = TDD_GetDatadict();//装载数据词典
$dealconn = mssql_connect(SQL_DEALSYS_IP,SQL_DEALSYSACCOUNT,SQL_DEALSYSPASSWD) or die('连接数据库错误');
$dealconn = mssql_connect('10.*.**.239','crm_login','chinapay') or die('连接数据库错误');
mssql_select_db('CPDataWarehouse');
$day = date('Y-m-d',time()-24*60*60);
$day = gmdate('Y-m-d');
$day = '2013-08-26';
   $nowtime = time();
     $nowstr = gmdate('Y-m-d H:i:s', ($nowtime+8*60*60));
$dqrq=date("Y-m-d",$nowstr);//当前日期
$day=date("Y-m-d",strtotime("-2 day",strtotime($dqrq)));
echo($day);
$startDay = $day.' 00:00:00';
$endDay = $day.' 23:59:59';
$crmdate = gmdate('Y-m-d H:i:s');
//支付控台
$get1Sql = "select *,DailyTransDate as TransDate,SucceedTransCount as Count,SucceedTransAmount as Amount 
from SQLCP.CPDataWarehouse.dbo.FactDailyTrans 
where DailyTransDate >= '$startDay' and DailyTransDate <= '$endDay'";
//ORA代付平台
$get2Sql = "select CPDate as TransDate,MerchantNo,sum(TransCount) as Count,SUM(TransAmount) as Amount
    from SQLCP.CPDataWarehouse.dbo.Table_OraTransSum 
   where CPDate >= '$startDay' 
   and CPDate <= '$endDay'
   group by CPDate,MerchantNo";
//基金转账
$get3Sql = "SELECT MerchantNo,TransDate,sum(TransAmt) as Amount,count(MerchantNo) as  Count
  FROM SQLCP.CPDataWarehouse.dbo.Table_TrfTransLog  
  where 
  TransDate >= '$startDay' and TransDate <= '$endDay'
  group by MerchantNo,TransDate";
  
//西联汇款表
$get4Sql = "select MerchantNo,TransDate,COUNT(MerchantNo)as Count,sum(DestTransAmount)as Amount 
   from SQLCP.CPDataWarehouse.dbo.Table_WUTransLog
   where TransDate >= '$startDay'
   and TransDate <= '$endDay'
   group by MerchantNo,TransDate";