'余额', ]; private $type_key = [ 1 => 'money', ]; private $add_reduce_arr = [ 1 => '增加', 0 => '减少', ]; private $status_arr = [ 1 => '消费金订单抵扣', 2 => '商城购买', 3 => '线下消费', 4 => '兑换商品', 5 => '奖励', 6 => '分销佣金',//订单分佣 7 => '佣金',//门店分佣 8 => '支付返现',//门店分佣 9 => '余额提现',//门店分佣 10 => '退货/退款',//门店分佣 11 => '线下代理收益',//线下订单佣金 12 => '购买返现',//线上订单佣金 13 => '返现',//进货订单平台返现 14 => '驳回',//提现驳回 15 => '闲置交易',//提现驳回 16 => '分销返现',//提现驳回 17 => '线上代理收益',//提现驳回 18 => '进货返现',//提现驳回 19 => '账户合并',//账户合并变动金额、消费金、公益豆 ]; private $water_type = [ 1 => [ ['water_key' => '2', 'water_name' => '商城购买'], ['water_key' => '6', 'water_name' => '分销佣金'], // ['water_key' => '7', 'water_name' => '佣金'], ['water_key' => '11', 'water_name' => '线下代理收益'], ['water_key' => '15', 'water_name' => '闲置交易'], ['water_key' => '16', 'water_name' => '分销返现'], ['water_key' => '17', 'water_name' => '线上代理收益'], ['water_key' => '18', 'water_name' => '进货返现'], ['water_key' => '12', 'water_name' => '购买返现'], ['water_key' => '8', 'water_name' => '支付返现'], ['water_key' => '9', 'water_name' => '提现'], ['water_key' => '10', 'water_name' => '退款'], ] ]; static private $server = null; private function __construct() { } /** * 创建对象 * @return MoneyDetailServer */ static function creatServer() { if (empty(self::$server)) self::$server = new MoneyDetailServer(); return self::$server; } /** * @param $reduce * @return string */ public function getAddReduceArr($reduce) { return empty($this->add_reduce_arr[$reduce]) ? '' : $this->add_reduce_arr[$reduce]; } /** * @return string[] */ public function getStatus() { return $this->status_arr; } /** * @param $status * @return array|string */ public function getStatusArr($status) { return empty($this->status_arr[$status]) ? '' : $this->status_arr[$status]; } /** * 获取消费类型 * @param $type * @return array|\string[][] */ public function getWaterType($type) { return empty($this->water_type[$type]) ? [] : $this->water_type[$type]; } /** * 获取订单类型 * @param $type * @return array|string */ public function getTypeArr($type) { return empty($this->type_arr[$type]) ? '' : $this->type_arr[$type]; } /** * @return string[] */ public function getType() { return $this->type_arr; } /** * 会员余额变动 * @param $type * @param $status * @param $price * @param $addReduce * @param $m_id * @param $mark * @param int $fromID * @param int $shop_id * @param int $level * @return MoneyDetail|false|\Illuminate\Database\Eloquent\Model */ public function write($type, $status, $price, $addReduce, $m_id, $mark = '', $fromID = 0, $shop_id = 0, $level = 0) { $money_mode = Member::where('id', $m_id)->select(['id', 'money'])->first(); if (empty($money_mode)) { return false; } $money_mode->increment('money', $price); $detail = MoneyDetail::create( [ 'type' => $type, // 货币类型 'status' => $status, // 来源 'price' => $price, // 数目 'add_reduce' => $addReduce, // 增加 | 减少 'm_id' => $m_id, // 被操作会员ID 'mark' => $mark, // 备注 'shop_id' => $shop_id, // 备注 'source_id' => $fromID, // 操作员备注 'level' => $level, // 操作员备注 'remainder' => sprintf("%.2f", ($addReduce == 0 ? $price * -1 : $price) + $remainder),// 剩余数目 ] ); MemberServer::creatServer()->delMemberCache($m_id); return $detail->{'id'}; } /** * 验证会员余额是否充足 * @param $m_id * @param $money * @return bool */ function verifyMoney($m_id, $money) { $type_key = $this->type_key[1]; $balance = Member::where('id', $m_id)->select(['id', 'money', 'benefit_money', 'consume_money'])->value($type_key); return ($balance >= $money) ? true : false; } /** * 获取会员余额 * @param $m_id * @param $type * @param $shop_id * @return mixed */ function getMoney($m_id, $type=1) { if (empty($this->type_key[$type])) return 0; $type_key = $this->type_key[$type]; $balance = Member::where('id', $m_id)->value($type_key); $balance = CommonServer::creatServer()->setFormatNum($balance); return $balance; } /** * 获取收支 * @param $m_id * @param $type * @param $date_arr * @return array */ function getMoneyIncome($m_id, $type, $date_arr) { $where = [['m_id', $m_id], ['type', $type]]; $income = MoneyDetail::where($where)->where('add_reduce', 1)->whereBetween('created_at', $date_arr)->sum('price'); $expenses = MoneyDetail::where($where)->where('add_reduce', 0)->whereBetween('created_at', $date_arr)->sum('price'); return ['income' => $income, 'expenses' => $expenses]; } }