churen/service/option/lib/Account.php

<?php

namespace Option\Lib;

use Dever;

class Account
{
    public function getInfo($id, $table = 'option/account')
    {
        if ($id < 0) {
            return '无';
        }
        $account = Dever::db($table)->find($id);
        if ($account) {
            $string = $account['name'] . '<br />' . $account['mobile'] . '<br />' . $account['idcard'] . '<br />' . $account['email'];

            if ($account['is_email'] == 1) {
                $string .= '<br /><font style="color:blue">邮箱已验证</font>';
            } else {
                $string .= '<br /><font style="color:red">邮箱未验证</font>';
            }
            return $string;
            
        } else {
            return '';
        }
    }

    public function getAudit($id, $table = 'option/account')
    {
        if ($id < 0) {
            return '无';
        }
        $audit = Dever::db($table)->config['set']['audit'];
        $account = Dever::db($table)->find($id);
        if ($account) {
            $string = $audit[$account['audit']];
            if ($account['audit'] == 4) {
                $string .= '<br />原因：' . $account['audit_desc'];
            }
            if ($account['audit_date']) {
                $audit_date = date('Y-m-d H:i:s', $account['audit_date']);
                $string .= '<br />'.$audit_date;
            }
            return $string;
            
        } else {
            return '';
        }
    }

    /**
     * 验证手机号
     * @return mixed
     */
    public function checkMobile($mobile)
    {
        $rule = Dever::rule('mobile');

        if (!$mobile) {
            Dever::alert('手机号不能为空');
        }
        if (!preg_match($rule, $mobile)) {
            Dever::alert('手机号码格式错误');
        }

        return $mobile;
    }

    /**
     * 验证验证码
     * @return mixed
     */
    public function checkMcode($mobile)
    {
        $code = Dever::input('mcode');
        if (!$code) {
            Dever::alert('请输入验证码');
        }
        $code = Dever::load('passport/reg')->mcode($mobile, $code, 1);
        if (!$code) {
            Dever::alert('验证码输入错误');
        }
    }

    /**
     * 查看详情
     * @return mixed
     */
    public function show()
    {
        $aid = Dever::input('aid');
        $account = Dever::db('option/account')->one($aid);

        $config = Dever::db('option/account')->config['set'];

        $result['账户信息'] = $this->getShowInfo($account, $config);

        $button = array();

        $button[0]['btn'][] = array
        (
            'type' => 'edit',
            'link' => Dever::url('project/database/update?project=option&table=account&where_id='.$account['id'].'&status=1&col=name,idcard,idcard_front,idcard_back', 'manage'),
            'name' => '修改认证资料',
        );
        $url = '';
        if ($account['status'] == 3) {
            $button[0]['btn'][] = array
            (
                'type' => 'action',
                'link' => Dever::url('lib/account.setStatus?id=' . $account['id'] . '&value=2', 'option'),
                'name' => '恢复账号',
            );
        } elseif ($account['status'] == 2) {
            $button[0]['btn'][] = array
            (
                'type' => 'action',
                'link' => Dever::url('lib/account.setStatus?id=' . $account['id'] . '&value=3', 'option'),
                'name' => '禁用账号',
            );
        }

        $aid = $account['id'];
        if ($account['type'] == 1) {
            # 给主账户发期权
            $parent = Dever::db('option/account')->find(array('type' => 2, 'key' => $account['key']));
            if ($parent) {
                $aid = $parent['id'];
            } else {
                $aid = false;
            }
        }

        # 获取账户资金
        $cash_type = Dever::db('option/cash')->config['config_type'];
        $cash = Dever::db('option/cash')->select(array('aid' => $aid));

        if ($cash) {
            $table = array();
            $table['head'] = array('账户类型', '待交付', '已交付总额', '已发放剩余', '未发放', '已兑付');
            $table['body'] = array();

            foreach ($cash as $k => $v) {
                $total = number_format($v['jiaofu'] + $v['fafang'] + $v['duifu'], 2, '.', '');
                //$weifafang = number_format($total-$v['fafang']-$v['duifu'], 2);
                $table['body'][] = array
                (
                    $cash_type[$v['type']],
                    $v['daijiaofu'],
                    $total,
                    //$v['jiaofu'],
                    $v['fafang'],
                    $v['jiaofu'],
                    $v['duifu'],
                );
            }

            $result['账户金额'] = array
            (
                'type' => 'table',
                'content' => $table,
            );
        }

        if ($aid) {
            $search_type = Dever::input('search_type');
            $option_aid = $aid;
            if ($search_type) {
                $option_aid .= '&search_type=' . $search_type;
            }
            $button[0]['btn'][] = array
            (
                'type' => 'edit',
                'link' => Dever::url('project/database/update?project=option&table=push_cash&search_option_aid='.$option_aid, 'manage'),
                'name' => '发放期权',
            );

            $button[1]['btn'][] = array
            (
                'type' => 'link',
                'link' => Dever::url('project/database/list?project=option&table=bill_jiaofu&search_option_aid='.$option_aid.'', 'manage'),
                'name' => '期权交付记录',
            );

            $button[1]['btn'][] = array
            (
                'type' => 'link',
                'link' => Dever::url('project/database/list?project=option&table=bill_fafang&search_option_aid='.$option_aid.'', 'manage'),
                'name' => '期权发放记录',
            );

            $button[1]['btn'][] = array
            (
                'type' => 'link',
                'link' => Dever::url('project/database/list?project=option&table=bill_duifu&search_option_aid='.$option_aid.'', 'manage'),
                'name' => '期权兑付记录',
            ); 

            $button[1]['btn'][] = array
            (
                'type' => 'link',
                'link' => Dever::url('project/database/list?project=option&table=agreement&search_option_aid='.$option_aid.'', 'manage'),
                'name' => '期权合同',
            ); 
        }

        
        $url = Dever::url('project/database/list?project=option&table=account', 'manage');
        if ($search_type) {
            $url .= '&search_option_type=' . $search_type;
        }
        $head_btn[] = array
        (
            'type' => 'link',
            'link' => $url,
            'name' => '返回上一页',
        );
        $head = array
        (
            'name' => '基本信息',
            'btn' => $head_btn,
        );
        $foot = $button;
        $html = Dever::show($head, $result, $foot);

        return $html;
    }

    private function getShowInfo($account, $config)
    {
        $result = array();

        $idcard_pic = '';
        if ($account['idcard_front']) {
            $idcard_pic = '<a href="'.$account['idcard_front'].'" target="_blank"><img src="'.$account['idcard_front'].'" width="150" /></a>';
        }
        
        if ($account['idcard_back']) {
            $idcard_pic .= '&nbsp;&nbsp;<a href="'.$account['idcard_back'].'" target="_blank"><img src="'.$account['idcard_back'].'" width="150" /></a>';
        }

        if ($account['email']) {
            $account['email'] .= '（'.$config['is_email'][$account['is_email']].'）';
        }

        $result = array
        (
            'type' => 'info',
            'content' => array
            (
                array
                (
                    array('姓名', $account['name']),
                    array('手机号', $account['mobile']),
                    array('邮箱', $account['email']),
                ),

                array
                (
                    array('账户类型', $config['type'][$account['type']]),
                    array('审核状态', $config['audit'][$account['audit']]),
                    array('账户状态', $config['status'][$account['status']]),
                ),
            ),
        );

        $result['content'][] = array
        (
            array('身份证号', $account['idcard']),
            array('身份证照片', $idcard_pic),
        );

        return $result;
    }

    public function setStatus_api()
    {
        $where['where_id'] = Dever::input('id');
        $where['status'] = Dever::input('value');

        Dever::db('option/account')->update($where);

        return 'reload';
    }

    public function daijiaofu($id)
    {
        $where['aid'] = $id;
        $total = Dever::db('option/bill_jiaofu')->total($where);
        $html = $total . '条';
        $cash = Dever::db('option/cash')->select(array('aid' => $id));
        $total = 0;
        if ($cash) {
            foreach ($cash as $k => $v) {
                $total += $v['daijiaofu'];
            }
        }
        $html .= '<br/ >' . number_format($total, 2, '.', '');
        return $html;
    }

    public function getCash($id)
    {
        $where['aid'] = $id;
        $total = Dever::db('option/bill_jiaofu')->total($where);
        $daijiaofu = $total . '条';
        $cash = Dever::db('option/cash')->select(array('aid' => $id, 'status' => 2));
        $total = 0;
        $qiquan = '';
        $yuanshiqiquan = '';
        if ($cash) {
            foreach ($cash as $k => $v) {
                $v['total'] = number_format($v['jiaofu'] + $v['fafang'] + $v['duifu'], 2, '.', '');
                $total += $v['daijiaofu'];
                if ($v['type'] == 1) {
                    $qiquan .= $v['total'];
                    $qiquan .= '<br/ >发放' . $v['fafang'];
                    $qiquan .= '<br/ >未发' . $v['jiaofu'];
                    $qiquan .= '<br/ >兑付' . $v['duifu'];
                } elseif ($v['type'] == 2) {
                    $yuanshiqiquan .= $v['total'];
                    $yuanshiqiquan .= '<br/ >发放' . $v['fafang'];
                    $yuanshiqiquan .= '<br/ >未发' . $v['jiaofu'];
                    $yuanshiqiquan .= '<br/ >兑付' . $v['duifu'];
                }
            }
        }
        $daijiaofu .= '<br/ >' . number_format($total, 2, '.', '');
        return array('daijiaofu' => $daijiaofu, 'qiquan' => $qiquan, 'yuanshiqiquan' => $yuanshiqiquan);
    }
}