public function actionDelGood() { if (Yii::$app->request->isAjax) { $data = Yii::$app->request->post(); $goods_id = $data['goods_id']; \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $session = new Sitesession(); $user_id = $session->getUserId(); if (!$user_id) { return ['goods_id' => 0, 'count' => 0]; } $goods = $session->getGoods($user_id); $shopping_car = $goods ? $goods : array(); if (in_array($goods_id, $shopping_car)) { foreach ($shopping_car as $key => $gid) { if ($gid == $goods_id) { unset($shopping_car[$key]); } } } $session->storeGoods($user_id, $shopping_car); $count = count($shopping_car); return ['goods_id' => $goods_id, 'shopping_car' => $shopping_car, 'count' => $count]; } }
public function actionDetails() { $session = new Sitesession(); $user_id = $session->getUserId(); $goods = $session->getGoods($user_id); $order_id = $session->getOrderId(); $order = null; if (!empty($order_id)) { $order = Orders::findOne($order_id); } $user = null; if ($user_id) { //获取user_id用户信息 /*$connection = \Yii::$app->db; $command = $connection->createCommand('SELECT * FROM customer WHERE id='.$user_id); $user = $command->queryOne();*/ $user = Customer::findOne($user_id); } $count = 0; if (is_array($goods) && !empty($goods)) { /*$str = ''; foreach ($goods as $key => $value) { if(empty($str)) { $str = $str." ".$value; } else { $str = $str.", ".$value; } } */ $count = count($goods); //获取goods $connection = \Yii::$app->db; $transaction = $connection->beginTransaction(); try { // 所有的查询都在主服务器上执行 //$goods = $connection->createCommand('SELECT * FROM goods WHERE goods_id in ('.$str.')')->queryAll(); $goods = Goods::findAll($goods); $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } } else { $goods = false; } return $this->render('details', ['user' => $user, 'goods' => $goods, 'count' => $count, 'order' => $order]); }
<?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'id', 'username', 'title', 'address', ['label' => '选择', 'format' => 'raw', 'value' => function ($data) { $url = "index.php?r=order/fix-user&user_id=" . $data->id; return Html::a('选择用户', $url, ['title' => '选择']); }]]]); ?> <?php } else { ?> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'goods_id', 'goods_sn', 'goods_name', 'shop_price', 'promote_price', ['label' => '添加到购物列表', 'format' => 'raw', 'value' => function ($data) { $session = new Sitesession(); $user_id = $session->getUserId(); $goods = $session->getGoods($user_id); if (!empty($goods) && in_array($data->goods_id, $goods)) { $text = "已添加"; $actionadd = 0; } else { $text = "添加"; $actionadd = 1; } return Html::a($text, null, ['title' => '添加', 'goods_id' => $data->goods_id, 'actionad' => $actionadd, 'class' => 'jsAddGoods']); }]]]); ?> <?php } ?> </div> <script>