churen/service/bill/lib/Manage.php

<?php

namespace Bill\Lib;

use Dever;

class Manage
{
    public function cashUpdate($id, $name, $data)
    {
        Dever::config('base')->hook = true;
        $mid = Dever::param('mid', $data);
        $cash = Dever::param('cash', $data);
        $desc = Dever::param('desc', $data);
        if ($mid && $cash && $desc) {
        	$member = Dever::db('agent/member')->find($mid);
        	if ($member && $member['status'] == 2) {
        		Dever::load('bill/lib/cash')->up($mid, 10, $cash, $member['role'], $id, $desc, 2);
        		$where['where_id'] = $mid;
        		$where['cash'] = $cash;
        		Dever::db('agent/member')->upCash($where);
        	} else {
        		Dever::db('bill/push_cash')->update(array('where_id' => $id, 'status' => 2));
        		Dever::alert('代理商未审核通过，发放失败');
        	}
        }
    }

    public function cashAuditUpdateStart($param, $name, $data)
    {
        $mul_type = Dever::config('base')->mul_type;
        if ($mul_type == 2) {
            $list = Dever::db('bill/cash')->select(array('status' => 1));
        } else {
            $list = explode(',', $param['where_id']);
        }
    }

    public function cashAuditUpdate($id, $name, $data)
    {
    	Dever::config('base')->hook = true;
        $audit = Dever::param('audit', $data);
        if ($audit > 1) {
            $mul_type = Dever::config('base')->mul_type;
            if ($mul_type == 2) {
                $list = Dever::db('bill/cash')->select(array('status' => 1));
            } else {
                $list = explode(',', $id);
            }
            
            foreach ($list as $k => $v) {
                if (is_array($v)) {
                    $id = $v['id'];
                } else {
                    $id = $v;
                    $info  = Dever::db('bill/cash')->find(array('id' => $id, 'clear' => true));
                }
                
                if ($info['status'] != 1) {
                    continue;
                }
                #已审核
                if ($audit == 2) {
                    Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
                    $info = Dever::db('bill/cash')->find($id);
                    if ($info && $info['type'] <= 10) {
                        $where['where_id'] = $info['mid'];
                        $where['cash'] = $info['cash'];
                        Dever::db('agent/member')->upCash($where);
                    }elseif ($info && $info['type'] == 11) {
                        $tixian = Dever::db('bill/tixian')->find($info['type_id']);
                        $where['where_id'] = $tixian['id'];
                        $where['status'] = 1;
                        Dever::db('bill/tixian')->update($where);
                    }
                } else {
                    #作废
                    Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
                    $info = Dever::db('bill/cash')->find($id);
                    if ($info && $info['type'] == 11) {
                        $tixian = Dever::db('bill/tixian')->find($info['type_id']);
                        $where['where_id'] = $info['mid'];
                        $where['cash'] = -1*$tixian['ycash'];
                        Dever::db('agent/member')->upCash($where);
                        $update['where_id'] = $tixian['id'];
                        $update['status'] = 3;
                        Dever::db('bill/tixian')->update($update);
                    }
                }
            }
        }
    }

    public function tixianAuditUpdate($id, $name, $data)
    {
    	Dever::config('base')->hook = true;
        $audit = Dever::param('audit', $data);
        $desc = Dever::param('audit_desc', $data);
        if ($audit > 1) {
            $mul_type = Dever::config('base')->mul_type;
            if ($mul_type == 2) {
                $list = Dever::db('bill/tixian')->select(array('status' => 1));
            } else {
                $list = explode(',', $id);
            }
            
            foreach ($list as $k => $v) {
                if (is_array($v)) {
                    $id = $v['id'];
                } else {
                    $id = $v;
                    $info  = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
                }
                
                if ($info['status'] != 1) {
                    continue;
                }

                $info = Dever::db('bill/cash')->find(array('type' => 11, 'type_id' => $id));
                if (!$info) {
                    continue;
                }
                if ($audit == 2) {
                    Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
                    if ($info && $info['status'] == 1) {
                        Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
                    }
                    # 通知短信
                    if (Dever::project('sms')) {
                        $member = Dever::db('agent/member')->find($info['mid']);
                        Dever::load('sms/api')->send('daili_tixian_yes', $member['mobile'], array('name' => $member['name']));
                    }
                } else {
                    Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
                    # 通知短信
                    if (Dever::project('sms')) {
                        $member = Dever::db('agent/member')->find($info['mid']);
                        Dever::load('sms/api')->send('daili_tixian_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
                    }
                }
            }
        }
    }

    public function sellUpdate($id, $name, $data)
    {
        Dever::config('base')->hook = true;
        $mid = Dever::param('mid', $data);
        $num = Dever::param('num', $data);
        $desc = Dever::param('desc', $data);
        $type = Dever::param('type', $data);
        if ($mid && $num && $desc) {
        	$member = Dever::db('agent/member')->find($mid);
        	if ($member && $member['status'] == 2) {
                if ($type == 1) {
                    Dever::load('bill/lib/sell.push_one_commit', $mid, $num, $member['role'], $id, $desc);
                } else {
                    Dever::load('bill/lib/sell.push_all_commit', $mid, $num, $member['role'], $id, $desc);
                }
        	} else {
        		Dever::db('bill/push_sell')->update(array('where_id' => $id, 'status' => 2));
        		Dever::alert('代理商未审核通过，发放失败');
        	}
        }
    }

    # 获取新增业绩
    public function getSellNewNum($num, $month, $mid)
    {
        $where = array('month' => $month, 'mid' => $mid);
        $search = Dever::search_button();
        if ($search) {
            $where['config']['group'] = $search[0];
            $where['config']['col'] = str_replace('|id', '', $search[1]);
        }
        if ($num < 0) {
            $num = 0;
        }
        $new_num = 0;
        $prev = Dever::db('bill/sell_stat')->prev($where);
        if ($prev && $num > 0 && $prev['num'] >= 0) {
            $new_num = $num - $prev['num'];
        }

        return $new_num;
    }

    #提现导出
    public function tixian_out_api(){
        $status = Dever::input('search_option_status');
        $start = Dever::input('search_option_start_cdate');
        $end = Dever::input('search_option_end_cdate');
        if($start){
            $starts=strtotime($start);
        }
        if($end){
            $ends=strtotime($end);
        }
        $header = array('提现单号', '姓名', '手机号', '身份证号', '会员角色', '提现金额', '到账金额', '手续费金额', '申请时间', '审核时间', '审核状态','发放状态','审核人', '来源');
        if($status && isset($starts) &&  $starts && isset($ends) && $ends){
            $data = Dever::db('bill/tixian')->getExcelAll(array('start'=>$starts,'end'=>$ends,'status'=>$status,'state'=>1));
        }elseif($status){
            $data = Dever::db('bill/tixian')->getExcelAll(array('status'=>$status,'state'=>1));
        }elseif(isset($starts) && $starts && isset($ends) && $ends){
            $data = Dever::db('bill/tixian')->getExcelAll(array('start'=>$starts,'end'=>$ends,'state'=>1));
        }else{
            $data = Dever::db('bill/tixian')->getExcelAll(array('state'=>1));
        }
        
        $body = array();
        foreach($data as $k => $v){
            $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
            $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
            if($v['audit'] == 1){
                $audit = '待审核';
            }elseif($v['audit'] == 2){
                $audit = '已审核';
            }else{
                $audit = '已作废';
            }
            if($v['status'] == -1){
                $status = '未审核待发放';
            }elseif($v['status'] == 1){
                $status = '已审核待发放';
            }elseif($v['status'] == 2){
                $status = '已发放';
            }else{
                 $status = '已作废';
            }
            $cdate = date('Y-m-d H:i',$v['cdate']);
            $operdate = date('Y-m-d H:i',$v['operdate']);
            $admin = Dever::load('manage/auth.data');
            $d = array
            (
                $v['order_num'],
                $member['name'],
                "'".$member['mobile'],
                "'".$member['idcard'],
                $role['name'],
                $v['ycash'],
                $v['cash'],
                $v['ycash']-$v['cash'],
                $cdate,
                $operdate,
                $audit,
                $status,
                $admin['username'],
                '',
            );
             $body[] = $d;
        }
        $file = '每日提现';
        Dever::excelExport($body, $header, $file);
    }
}