public function down() { $this->dropColumn(ProductOrder::tableName(), 'out_order_no'); $this->dropColumn(ProductOrder::tableName(), 'charge_id'); }
/** * 单个商品修改 * @return type */ public function actionSuresellproduct() { $user_id = \Yii::$app->user->getId(); #获得用户的可用资金 $p_param = \Yii::$app->request->get(); if (!isset($p_param['id'])) { echo 1; \Yii::$app->end(); } $order = ProductOrder::find()->where("order_id=:id AND p_user_id=:user_id ", [':id' => $p_param['id'], ':user_id' => $user_id])->one(); if (!isset($order)) { echo 1; \Yii::$app->end(); } if (isset($p_param['sure']) && $p_param['sure'] == 1) { $in_p_user_id = $order->p_user_id; $order_id = $order->order_id; #调有存储过程冻结资金并生成订单 $conn = \Yii::$app->db; $trance = $conn->beginTransaction(); try { $command = $conn->createCommand('update ' . ProductOrder::tableName() . ' set order_status=1 where p_user_id=:in_p_user_id AND order_id=:order_id'); $command->bindParam(":in_p_user_id", $in_p_user_id, PDO::PARAM_INT); $command->bindParam(":order_id", $order_id, PDO::PARAM_INT); $command->execute(); $trance->commit(); $fit = ['remark' => '发货成功', 'status' => 1]; } catch (Exception $e) { $trance->rollBack(); $fit = ['remark' => '发货失败', 'status' => 0]; } } else { $fit = []; } return $this->renderAjax('ajax_suresell', ['order' => $order, 'p_param' => $p_param, 'fit' => $fit]); }
public function down() { $this->dropColumn(ProductOrder::tableName(), 'payment'); $this->dropColumn(ProductOrder::tableName(), 'shipment'); }