123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Ppintuanorder extends BaseModel {
- const PINTUANORDER_STATE_CLOSE = 0;
- const PINTUANORDER_STATE_NORMAL = 1;
- const PINTUANORDER_STATE_SUCCESS = 2;
- private $pintuanorder_state_array = array(
- self::PINTUANORDER_STATE_CLOSE => '拼团取消',
- self::PINTUANORDER_STATE_NORMAL => '参团中',
- self::PINTUANORDER_STATE_SUCCESS => '拼团成功'
- );
-
- public function getPpintuanorderList($condition) {
- $ppintuanorder_list = Db::name('ppintuanorder')->alias('ppintuanorder')->field('ppintuanorder.*,order.buyer_id,order.buyer_name,order.order_state')
- ->join('order order', 'ppintuanorder.order_id=order.order_id','LEFT')
- ->where($condition)
- ->select()->toArray();
- if (!empty($ppintuanorder_list)) {
- foreach ($ppintuanorder_list as $key => $ppintuanorder) {
- $ppintuanorder_list[$key]['pintuanorder_state_text'] = $this->pintuanorder_state_array[$ppintuanorder['pintuanorder_state']];
-
- $ppintuanorder_list[$key]['pintuanorder_avatar'] = get_member_avatar_for_id($ppintuanorder['buyer_id']);
- $ppintuanorder_list[$key]['order_state_text'] = get_order_state($ppintuanorder);
- }
- }
- return $ppintuanorder_list;
- }
-
-
- public function getPpintuanvrorderList($condition) {
- $ppintuanorder_list = Db::name('ppintuanorder')->alias('ppintuanorder')->field('ppintuanorder.*,vrorder.buyer_id,vrorder.buyer_name,vrorder.order_state')
- ->join('vrorder vrorder', 'ppintuanorder.order_id=vrorder.order_id','LEFT')
- ->where($condition)
- ->select()->toArray();
- if (!empty($ppintuanorder_list)) {
- foreach ($ppintuanorder_list as $key => $ppintuanorder) {
- $ppintuanorder_list[$key]['pintuanorder_state_text'] = $this->pintuanorder_state_array[$ppintuanorder['pintuanorder_state']];
-
- $ppintuanorder_list[$key]['pintuanorder_avatar'] = get_member_avatar_for_id($ppintuanorder['buyer_id']);
- $ppintuanorder_list[$key]['order_state_text'] = get_order_state($ppintuanorder);
- }
- }
- return $ppintuanorder_list;
- }
-
- public function getOnePpintuanorder($condition) {
- return Db::name('ppintuanorder')->where($condition)->find();
- }
-
- public function addPpintuanorder($data) {
- return Db::name('ppintuanorder')->insertGetId($data);
- }
-
- public function editPpintuanorder($condition, $data) {
- return Db::name('ppintuanorder')->where($condition)->update($data);
- }
- }
|