public function getOrderByOrderTime($campaignId, $orderStatTime, $orderEndTime)
{
if (empty($campaignId) || empty($orderStatTime) || empty($orderEndTime)) {
echo "campaignId ,orderStatTime or orderEndTime is null";
exit;
}
$sql = "SELECT p.order_id,order_sn,add_time,order_status,pay_status,pay_name,order_time,cid,wi,order_status,pay_status,pay_name,shipping_fee,surplus,bonus,order_amount FROM `cps` as p LEFT OUTER JOIN ecs_order_info as i on i.order_id=p.order_id where p.cid=" . $campaignId . " and order_time>" . $orderStatTime . " and order_time<" . $orderEndTime;
$dborder = $GLOBALS['db']->getAll($sql);
if (empty($dborder)) {
return NULL;
}
foreach ($dborder as $k => $v) {
$order = new Order();
$order->setOrderNo($v['order_sn']);
$order_time = date('Y-m-d H:i:s', $v['order_time']);
$order->setOrderTime($order_time);
// 设置下单时间
$order->setUpdateTime($order_time);
// 设置订单更新时间,如果没有下单时间,要提前对接人提前说明
$order->setCampaignId($v['cid']);
// 测试时使用"101",正式上线之后活动id必须要从数据库里面取
$order->setFeedback($v['wi']);
$order->setFare($v['shipping_fee']);
$order->setFavorable($v['bonus'] + $v['surplus']);
//$orderStatus = new OrderStatus();
//$orderStatus -> setOrderNo($order -> getOrderNo());
$order->setOrderStatus($v['order_status']);
// 设置订单状态
$order->setPaymentStatus($v['pay_status']);
// 设置支付状态
$order->setPaymentType($v['pay_name']);
// 支付方式
$sql = "select * from ecs_order_goods where order_id=" . $v['order_id'] . " and goods_price>100";
$order_goods = $GLOBALS['db']->getAll($sql);
//echo "<pre>";print_r($order_goods);
foreach ($order_goods as $k1 => $v1) {
$pro = new Product();
//$pro -> setOrderNo($order -> getOrderNo());
$pro->setProductNo($v1['goods_sn']);
$pro->setName($v1['goods_name']);
$pro->setCategory("蛋糕");
$pro->setCommissionType("");
$pro->setAmount($v1['goods_number']);
$a = number_format($v1['goods_price'] * (1 - ($v['bonus'] + $v['surplus']) / ($v['bonus'] + $v['surplus'] + $v['order_amount'])), 2, ".", "");
$pro->setPrice($a);
$products[] = $pro;
}
$order->setProducts($products);
$orderlist[] = $order;
$products = array();
}
//print_r($orderlist);
//echo json_encode($orderlist);
return $orderlist;
}