public function actionView($id)
{
$commodityOrderDetail = CommodityOrderDetail::findOne($id);
if (empty($commodityOrderDetail)) {
throw new HttpException(404, '查看失败，数据不存在！');
}
$commodityOrder = CommodityOrder::findOne($commodityOrderDetail->coid);
if (empty($commodityOrder)) {
throw new HttpException(404, '查看失败，数据不存在！');
}
return $this->render('view', ['model' => $commodityOrder]);
}
public function actionUpdateOrderDetail()
{
$id = Yii::$app->request->post('pk');
$name = Yii::$app->request->post('name');
$value = Yii::$app->request->post('value');
$commodityOrderDetail = CommodityOrderDetail::findOne($id);
$commodityOrderDetail->{$name} = $value;
if ($name == 'eid') {
$entrance = Entrance::findOne($value);
if (!empty($entrance)) {
$commodityOrderDetail->entrance = $entrance->name;
}
}
if ($name == 'recommends') {
if ($value == '0') {
$commodityOrderDetail->recommends = '';
} else {
if ($value == '1') {
$commodityOrder = CommodityOrder::findOne($commodityOrderDetail->coid);
$sql = 'SELECT t.id FROM (SELECT `tbl_buyer`.`id`,COUNT(*) AS num FROM `tbl_buyer` RIGHT JOIN `tbl_order` ON `tbl_buyer`.`account` = `tbl_order`.`buyer` WHERE `tbl_buyer`.`platform` = :platform AND `tbl_buyer`.`credit_temp` >= :credit_temp AND date_sub(curdate(), INTERVAL 30 DAY) <= date(`tbl_buyer`.`buy_time`) ORDER BY `tbl_buyer`.`weight` DESC,RAND()) AS t WHERE t.num >= :trade_num LIMIT :num';
$db = Yii::$app->db;
$command = $db->createCommand($sql);
$command->bindValue(":platform", $commodityOrder->platform);
$command->bindValue(":credit_temp", $commodityOrder->credit);
$command->bindValue(":trade_num", $commodityOrder->trade_num);
$command->bindValue(":num", $commodityOrderDetail->num);
$buyerArray = $command->queryColumn();
// $buyers = Buyer::find()->where('platform = :platform and and date_sub(curdate(), INTERVAL 30 DAY) <= date(buy_time)',[':platform'=>$commodityOrder->platform])->orderBy('weight desc,rand()')->limit($commodityOrderDetail->num)->all();
// $buyerArray = array();
// foreach($buyers as $buyer){
// $buyerArray[] = $buyer->id;
// }
$ids = '';
if (!empty($buyerArray)) {
$ids = implode(',', $buyerArray);
}
if (empty($ids)) {
$result = ['status' => 'error', 'msg' => '系统推荐失败，系统没找到符合要求的买家帐号'];
echo json_encode($result);
return;
}
$commodityOrderDetail->recommends = $ids;
}
}
}
if ($name == 'uid') {
$commodityOrderDetail->recommend_time = date('Y-m-d H:i:s');
}
if ($commodityOrderDetail->save()) {
$commodityOrderDetails = CommodityOrderDetail::find()->where('coid = :coid', [':coid' => $commodityOrderDetail->coid])->all();
$corpus = 0;
$total_fee = 0;
$budget_num = 0;
foreach ($commodityOrderDetails as $cod) {
$num = intval($cod->num);
$price = floatval($cod->price);
$fee = floatval($cod->fee);
$total_price = $num * $price;
$sum_fee = $num * $fee;
$corpus += $total_price;
$total_fee += $sum_fee;
$budget_num += $num;
}
$statistics = Statistics::find()->where('coid = :coid', [':coid' => $commodityOrderDetail->coid])->one();
$statistics->corpus = $corpus;
$statistics->total_fee = $total_fee;
$statistics->budget_num = $budget_num;
$statistics->save();
}
$result = ['status' => 'sucess'];
echo json_encode($result);
}