| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209 | <?phpnamespace Agent\Lib;use Dever;class Import{    # 图片存放地址    private $img_host = 'https://cryl.yijiuguanfang.com/attachment/';    public function __construct()    {        $this->db = Dever::db('agent/test:old');    }    # 获取已审核的条件    private function get_yes_where()    {        //issuingstate=1 已发放权益        return 'restatus = 0 and status = 1 and  prestatus = 1 and isagent = 1';    }    # 获取审核失败的条件    private function get_no_where()    {        //issuingstate=1 已发放权益        return 'restatus = 1 and isagent = 1';    }    # 获取待审核的条件    private function get_where()    {        //issuingstate=1 已发放权益        return 'restatus = 0 and status = 0 and isagent = 1 and contractstatus = 1';    }    # 获取sql    public function get_sql_api()    {        $table['已审核'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_yes_where().' group by mobile order by num desc';        $table['审核失败'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_no_where().' group by mobile order by num desc';        $table['待审核'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_where().' group by mobile order by num desc';        echo Dever::table($table);die;    }    public function get_api()    {        # 获取已审核通过、权益已发放的用户        $data = $this->db->fetchAll('select * from ims_ewei_shop_member where '.$this->get_yes_where().' order by id asc limit 10');        print_r($data);die;        foreach ($data as $k => $v) {            # 创建订单            $order = Dever::db('agent/order')->find($v['id']);            if (!$order) {                $data = array();                $data['id'] = $v['id'];                $data['mobile'] = $v['mobile'];                $data['name'] = $v['realname'];                $data['avatar'] = $v['avatar'];                $data['username'] = $v['nickname'];                $data['mid'] = $v['id'];                $data['parent_mid'] = $v['agentid'];                $data['parent_code'] = Dever::load("invite/api.code", $data['parent_mid']);                $data['role'] = $this->getRole($v['agentlevel']);                $data['area'] = str_replace(' ', ',', $v['datavalue']);                if ($v['streetvalue']) {                    $data['area'] .= ',' . $v['streetvalue'];                }                if ($v['entertype'] == 1) {                    $data['type'] = 1;                } else {                    $data['type'] = 2;                }                $data['price'] = $v['paymoney'];                $data['f_price'] = $data['price'];                $role = Dever::db('setting/role')->find($data['role']);                if ($role['type'] == 1) {                    $data['f_price'] = $role['price'];                } elseif ($role['type'] == 2) {                    $data['f_price'] = Dever::load('area/api')->getPrice($role['area'], $data['area']);                    if ($data['f_price'] <= 0) {                        $data['f_price'] = $data['price'];                    }                }                $data['agent_cash'] = $data['f_price'];                $data['sign'] = $v['contractsign'];                $data['idcard'] = $v['idnumber'];                if ($v['identity']) {                    $identity = Dever::json_decode($v['identity']);                    if (isset($identity[0])) {                        $data['idcard_front'] = $identity[0];                    }                    if (isset($identity[1])) {                        $data['idcard_back'] = $identity[1];                    }                }                $data['company_name'] = $v['company'];                $data['address'] = $v['province'] . $v['city'] . $v['area'] . $v['street'];                $data['pay_type'] = 2;                $data['pay_pic'] = $v['receipt'];                $data['status'] = $this->getStatus($v);                $data['audit_desc'] = $v['refuse'];                if ($v['issuingstate'] == 1) {                    $data['goods_status'] = 3;                } else {                    $data['goods_status'] = 1;                }                $data['pay_status'] = 2;                $data['order_num'] = Dever::load('agent/lib/order')->getOrderId();                $order_id = Dever::db('agent/order')->insert($data);                if ($order_id && $data['status'] == 4) {                    $member = Dever::db('agent/member')->find($v['id']);                    if ($data['status'] == 4) {                        $data['status'] = 2;                    } elseif ($data['status'] == 5) {                        $data['status'] = 1;                        $data['state'] = 2;                    } else {                        $data['status'] = 1;                    }                    $data['rdate'] = $v['agenttime'];                    $data['cash'] = $v['credit2'];                    $data['group_sell'] = $v['allcommission'];                    if (!$member) {                        Dever::db('agent/order')->insert($data);                    } else {                        $data['where_id'] = $member['id'];                        Dever::db('agent/order')->update($data);                    }                }            }        }        print_r($data);die;    }    # 状态对应    private function getStatus($data)    {        # 完成权益发放issuingstate、财务审核status、初审prestatus的认为订单有效        if ($data['issuingstate'] == 1 && $data['status'] == 1 && $data['prestatus'] == 1) {            return 4;        } elseif ($data['status'] == 1 && $data['prestatus'] == 1) {            return 3;        } elseif ($data['prestatus'] == 1) {            return 2;        } elseif ($data['restatus'] == 1) {            # 审核失败            return 5;        } elseif ($data['trainersign'] && $data['contractsign']) {            return 1;        } else {            return -2;        }    }    # 代理商角色对应    private function getRole($role)    {        # key是历史数据 value是最新数据        $config = array        (            # 创服            5 => 5,            # 创客            4 => 6,            # 逍客            8 => 7,            # 城市            1 => 2,            # 区县            2 => 3,            # 街道            3 => 4,            # 炒菜机分享会员            6 => 8,            # 热敏炉分享会员            7 => 9,        );        if (isset($config[$role]) && $config[$role]) {            return $config[$role];        }        return 1;    }}
 |