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); }