新增數據
~~~
$addup = [
'amount' => $price_b, //訂單金額
'status' => '1',
'finish_time' => time(), //訂單支付完成時間
];
$xb_order = Db::name('contract')->insertGetId($adddata);
if ($xb_order) {
$this -> success('創建成功',"/abt/index/order_list/");
// $this->redirect("/abt/index/pay_order/?order_id={$order_id}");
}else{
$this -> error('創建失敗');
}
~~~
修改數據
~~~
// 修改訂單狀態
$addup = [
'amount' => $price_b, //訂單金額
'status' => '1',
'finish_time' => time(), //訂單支付完成時間
];
$xb_order = Db::name('order')->where(["order_id" => $order_id])->update($addup);
if ($xb_order) {
$this -> success('修改成功',"/abt/index/order_list/");
// $this->redirect("/abt/index/pay_order/?order_id={$order_id}");
}else{
$this -> error('創建失敗');
}
~~~
刪除數據
~~~
// 刪除數據
if ($_G['del']=='1'){
$where_del = [
'order_id' => trim($_G['order_id']),
'uid'=>$_W['mc_uid'],
];
$xb_del = Db::name('order')->where($where_del)->delete();
if ($xb_del){
$this -> success('刪除成功');
}else{
$this -> error('刪除失敗');
}
}
~~~
其他
~~~
// 數字 字段值+1
Db::name('coupon')->where(["coupon_id" => $order_cb['coupon_id']])->setInc('stock',1);
// 數字 字段值-1
Db::name('coupon')->where(["coupon_id" => $order_cb['coupon_id']])->setDec('stock',1);
~~~
