'购买', 'gift' => '赠送' ); public function getStatusList($card_type) { switch ( $card_type ) { case 'virtual'://电子卡 return array ( 'to_use' => '待使用', 'used' => '已使用', 'expire' => '已过期' ); break; case 'real'://实体卡 return array ( 'to_activate' => '待激活', 'to_use' => '待使用', 'used' => '已使用', 'expire' => '已过期', 'invalid' => '已失效' ); break; } } /** * 生成礼品卡记录 * @param $params */ public function addCardItem($params) { $insert_data = $params[ 'insert_data' ];//可能包含订单id $site_id = $params[ 'site_id' ]; $member_id = $params[ 'member_id' ] ?? 0; $giftcard_id = $params[ 'giftcard_id' ]; $card_type = $params[ 'card_type' ] ?? ''; $card_right_type = $params[ 'card_right_type' ]; $card_no = $params[ 'card_no' ] ?? $this->createNo($site_id, $member_id); if ($card_type == 'real') { $count = model('giftcard_card')->getCount([ [ 'card_no', '=', $card_no ] ]); if ($count > 0) { return $this->error([], '当前卡密和编号已存在'); } } $data = array ( 'site_id' => $params[ 'site_id' ], 'card_no' => $card_no, 'card_type' => $card_type, 'giftcard_id' => $giftcard_id, 'member_id' => $member_id, 'create_time' => time(), 'card_right_type' => $card_right_type, 'valid_time' => $this->getValidityTime($params), 'balance' => $params[ 'balance' ] ?? 0, 'card_right_goods_type' => $params[ 'card_right_goods_type' ] ?? '', 'card_right_goods_count' => $params[ 'card_right_goods_count' ] ?? '', ); $card_id = model('giftcard_card')->add(array_merge($data, $insert_data)); if ($card_type == 'virtual') { $goods_list = $params[ 'goods_list' ]; foreach ($goods_list as $k => $v) { $v[ 'card_id' ] = $card_id; $v[ 'giftcard_id' ] = $giftcard_id; $v[ 'card_right_type' ] = $card_right_type; $this->addCardItemGoods($v); } } return $this->success($card_id); } /** * 礼品卡项 * @param $params */ public function addCardItemGoods($params) { $data = array ( 'site_id' => $params[ 'site_id' ], 'giftcard_id' => $params[ 'giftcard_id' ], 'card_id' => $params[ 'card_id' ], 'sku_id' => $params[ 'sku_id' ] ?? 0, 'sku_name' => $params[ 'sku_name' ] ?? '', 'sku_image' => $params[ 'sku_image' ] ?? '', 'sku_no' => $params[ 'sku_no' ] ?? '', 'goods_id' => $params[ 'goods_id' ] ?? 0, 'goods_name' => $params[ 'goods_name' ] ?? '', 'balance' => $params[ 'balance' ] ?? 0,//储值余额 'total_balance' => $params[ 'total_balance' ] ?? 0, 'price' => $params[ 'price' ] ?? 0, 'total_num' => $params[ 'num' ] ?? 1,//购买数量 'order_id' => $params[ 'order_id' ] ?? 0, 'order_goods_id' => $params[ 'order_goods_id' ] ?? 0, 'card_right_type' => $params[ 'card_right_type' ] ?? '', ); model('giftcard_card_goods')->add($data); return $this->success(); } /** * 计算礼品卡有效期 * @param $params * @return float|int */ public function getValidityTime($params) { $validity_type = $params[ 'validity_type' ]; $validity_time = $params[ 'validity_time' ]; $validity_day = $params[ 'validity_day' ]; switch ( $validity_type ) { case 'forever': $temp_time = 0; break; case 'day': $temp_time = time() + 86400 * $validity_day; break; case 'date': $temp_time = $validity_time; break; } return $temp_time; } /** * 生成订单编号 * @param array $site_id */ public function createNo($site_id, $member_id = 0, $prefix = '', $suffix = '') { $time_str = date('YmdHi'); $max_no = Cache::get($site_id . '_' . $member_id . '_' . $time_str); if (!isset($max_no) || empty($max_no)) { $max_no = 1; } else { $max_no += 1; } $member_no = $member_id > 0 ? sprintf('%05d', $member_id) : ''; $order_no = $prefix . $time_str . $member_no . sprintf('%03d', $max_no) . $suffix; Cache::set($site_id . '_' . $member_id . '_' . $time_str, $max_no); return $order_no; } /** * 一般认为这是针对单项的删除 * @param $condition * @return array */ public function delete($params) { $site_id = $params[ 'site_id' ] ?? 0; $card_id = $params[ 'card_id' ] ?? 0; $card_ids = $params[ 'card_ids' ] ?? ''; $card_import_id = $params[ 'card_import_id' ] ?? 0; $card_import_ids = $params[ 'card_import_ids' ] ?? 0; $condition = array ( [ 'status', '=', 'to_activate' ] ); if ($card_id > 0) { $condition[] = [ 'card_id', '=', $card_id ]; } if (!empty($card_ids)) { $condition[] = [ 'card_id', 'in', $card_ids ]; } if ($card_id > 0) { $condition[] = [ 'card_id', '=', $card_id ]; } if ($site_id > 0) { $condition[] = [ 'site_id', '=', $site_id ]; } if ($card_import_id > 0) { $condition[] = [ 'card_import_id', '=', $card_import_id ]; } if (!empty($card_import_ids)) { $condition[] = [ 'card_import_id', 'in', $card_import_ids ]; } $card_list = $this->getCardList($condition)[ 'data' ] ?? []; if (empty($card_list)) return $this->error(); // if($card_info['status'] == 'used') // return $this->error('', '删除失败,不可删除已使用的礼品卡'); $result = model('giftcard_card')->delete($condition); if ($result === false) return $this->error(); $params[ 'list' ] = $card_list; $this->deleteOperation($params); return $this->success(); } /** * 删除卡项的后续事件 * @param $params * @return array */ public function deleteOperation($params) { $list = $params[ 'list' ]; foreach ($list as $v) { //数据统计 ( new CardStat() )->stat(array_merge([ 'card_info' => $v, 'stat_type' => 'del' ])); } return $this->success(); } /** * 获取礼品卡记录信息 * @param $condition * @param string $field * @return array */ public function getCardInfo($condition, $field = '*', $alias = '', $join = []) { $info = model('giftcard_card')->getInfo($condition, $field, $alias, $join); return $this->success($info); } /** * 获取礼品卡记录列表 * @param array $condition * @param string $field * @param string $order * @param null $limit * @return array */ public function getCardList($condition = [], $field = '*', $order = '', $alias = '', $join = [], $limit = null) { $list = model('giftcard_card')->getList($condition, $field, $order, $alias, $join, '', $limit); return $this->success($list); } /** * 获取礼品卡记录分页列表 * @param array $condition * @param int $page * @param int $page_size * @param string $order * @param string $field * @return array */ public function getCardPageList($condition = [], $page = 1, $page_size = PAGE_LIST_ROWS, $order = '', $field = '*', $alias = '', $join = []) { $list = model('giftcard_card')->pageList($condition, $field, $order, $page, $page_size, $alias, $join); return $this->success($list); } /** * 获取礼品卡记录项信息 * @param $condition * @param string $field * @return array */ public function getCardGoodsInfo($condition, $field = '*') { $info = model('giftcard_card_goods')->getInfo($condition, $field); return $this->success($info); } /** * 获取礼品卡记录项列表 * @param array $condition * @param string $field * @param string $order * @param null $limit * @return array */ public function getCardGoodsList($condition = [], $field = '*', $order = '', $limit = null, $alias = 'a', $join = []) { $list = model('giftcard_card_goods')->getList($condition, $field, $order, $alias, $join, '', $limit); return $this->success($list); } /** * 获取礼品卡记录项分页列表 * @param array $condition * @param int $page * @param int $page_size * @param string $order * @param string $field * @return array */ public function getCardGoodsPageList($condition = [], $page = 1, $page_size = PAGE_LIST_ROWS, $order = '', $field = '*', $alias = 'a', $join = []) { $list = model('giftcard_card_goods')->pageList($condition, $field, $order, $page, $page_size, $alias, $join); return $this->success($list); } /** * 卡券详情 * @param $params */ public function getCardDetail($params) { $site_id = $params[ 'site_id' ] ?? 0; $member_id = $params[ 'member_id' ] ?? 0; $card_id = $params[ 'card_id' ]; $condition = array ( [ 'c.card_id', '=', $card_id ] ); if ($site_id > 0) { $condition[] = [ 'c.site_id', '=', $site_id ]; } if ($member_id > 0) { $condition[] = [ 'c.member_id', '=', $member_id ]; } $info = $this->getCardInfo($condition, 'c.*,go.order_no', 'c', [ [ 'giftcard_order go', 'c.order_id=go.order_id', 'left' ] ])[ 'data' ] ?? []; if (empty($info)) return $this->error(); $member_model = new Member(); $member_info = $member_model->getMemberInfo([ [ 'member_id', '=', $info[ 'member_id' ] ] ], 'nickname,headimg')[ 'data' ] ?? []; $info[ 'member_nickname' ] = $member_info[ 'nickname' ] ?? ''; $info[ 'member_headimg' ] = $member_info[ 'headimg' ] ?? ''; $member_info = $member_model->getMemberInfo([ [ 'member_id', '=', $info[ 'init_member_id' ] ] ], 'nickname,headimg')[ 'data' ] ?? []; $info[ 'init_member_nickname' ] = $member_info[ 'nickname' ] ?? ''; $info[ 'init_member_headimg' ] = $member_info[ 'headimg' ] ?? ''; $condition = array ( [ 'card_id', '=', $card_id ] ); if ($site_id > 0) { $condition[] = [ 'site_id', '=', $site_id ]; } if ($member_id > 0) { $condition[] = [ 'member_id', '=', $member_id ]; } $list = $this->getCardGoodsList($condition)[ 'data' ] ?? []; $info[ 'card_goods_list' ] = $list; return $this->success($info); } public function tran($data) { $status = $data[ 'status' ] ?? ''; if (!empty($status)) { $data[ 'status_name' ] = $this->getStatusList($data[ 'card_type' ])[ $status ] ?? ''; } $source = $data[ 'source' ] ?? ''; if (!empty($source)) { $data[ 'source_name' ] = $this->source_list[ $source ]; } $member_id = $data[ 'member_id' ] ?? 0; if ($member_id > 0) { $member_model = new Member(); $member_info = $member_model->getMemberInfo([ [ 'member_id', '=', $member_id ] ])[ 'data' ] ?? []; $data[ 'member_nickname' ] = $member_info[ 'nickname' ] ?? ''; } return $data; } }