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