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; }
function createProduct() { //Product 1 $product1 = new Product(); $product1->setCode(1); $product1->setDescription("Produto de teste 1"); $product1->setAmount(2); $product1->setValue(5.5); $product1->setExtraDescription("Este produto é um exemplo"); //Product 2 $product2 = new Product(); $product2->setCode(2); $product2->setDescription("Produto de teste 2"); $product2->setAmount(1); $product2->setValue(9); $product2->setExtraDescription(""); //Product Array $products = array($product1, $product2); return $products; }
// 设置优惠券 $cps->setOrderStatus($order['order_status']); // 设置订单状态 $cps->setPaymentStatus($order['pay_status']); // 设置支付状态 $cps->setPaymentType($order['pay_name']); // 支付方式 foreach ($cart_goods as $k => $v) { if ($v['goods_price'] > 0) { $pro = new Product(); // $pro2 -> setOrderNo($order -> getOrderNo()); $pro->setProductNo($v['goods_sn']); $pro->setName($v['goods_name']); $pro->setCategory("蛋糕"); $pro->setCommissionType(""); $pro->setAmount($v['goods_number']); $a = number_format($v['goods_price'] * (1 - ($order['bonus'] + $order['surplus']) / ($order['bonus'] + $order['surplus'] + $order['order_amount'])), 2, ".", ""); $pro->setPrice($a); $products[] = $pro; } } $cps->setProducts($products); //var_dump(get_object_vars($cps)); $sender = new Sender(); $sender->setOrder($cps); $sender->sendOrder(); $ordertime = $order['add_time'] + 8 * 3600; $sql = "INSERT INTO cps ( " . "order_id,src,channel,cid,wi,order_time)" . " values('{$new_order_id}','emar','cps'," . $arr[2] . ",'" . $arr[3] . "','" . $ordertime . "') "; $db->query($sql); } /* 修改拍卖活动状态
$pro->setCategory("asdf"); // 设置商品类型 $pro->setCommissionType("A"); // 设置佣金类型,如:普通商品 佣金比例是10%、佣金编号(可自行定义然后通知双方商务)A $pro->setAmount("1"); // 设置商品数量 $pro->setPrice("3000"); // 设置商品价格 $pro1 = new Product(); // $pro1 -> setOrderNo($order -> getOrderNo()); $pro1->setProductNo("1002"); $pro1->setName("测试商品5"); $pro1->setCategory("a"); $pro1->setCommissionType("B"); $pro1->setAmount("3"); $pro1->setPrice("100"); $pro2 = new Product(); // $pro2 -> setOrderNo($order -> getOrderNo()); $pro2->setProductNo("1003"); $pro2->setName("测试商品4"); $pro2->setCategory("2"); $pro2->setCommissionType("B"); $pro2->setAmount("5"); $pro2->setPrice("500"); $products = array($pro, $pro1, $pro2); // 实现商品信息集合 $order->setProducts($products); //var_dump(get_object_vars($order)); $sender = new Sender(); $sender->setOrder($order); $sender->sendOrder();
if (isset($_GET["submitSell"])) { //check if (isAlreadyHaveProduct($productCode) == 0) { print "<br><br>************** Input wrong product code **************<br><br><br>"; } else { if (isOwner($productCode, $username, $password) == 0) { print "<br><br>************** This isn't your product code **************<br><br><br>"; } else { //database connection $conn = mysql_connect("localhost", "root", "root") or die("****** can't connect to sever ******"); mysql_select_db("easystock", $conn) or die("****** can't select database ******"); //load product form database $rs = $easystockDB->fncSelectRecord("product", "code LIKE '{$productCode}%'"); //Set value to class then use function sell() to calculate $productSell = new Product(); $productSell->setAmount($rs[amount]); $productSell->setCost($rs[cost]); $productSell->setPrice($rs[price]); $productSell->setSale($rs[sale]); $productSell->sell($amount); $amountSell = $productSell->getAmount(); $saleSell = $productSell->getSale(); //update detail to database $easystockDB->fncUpdateRecord("product", "amount='{$amountSell}'", "code='{$productCode}'"); $easystockDB->fncUpdateRecord("product", "sale='{$saleSell}'", "code='{$productCode}'"); mysql_close($conn); } } } /*** Home ***/ //database connection