churen/app/shop/lib/Manage.php

<?php

namespace Shop\Lib;

use Dever;

class Manage
{
    # 获取用户信息
    public function user($id)
    {
        $info = Dever::db('shop/sell_order')->one($id);

        $user = Dever::db('passport/user')->one($info['uid']);

        $result = $user['username'];
        if ($info['mobile']) {
            $result .= '('.$info['mobile'].')';
        }
        return $result;
    }

    # 获取订单信息
    public function sell_order($id)
    {
        $table = array();
        $info = Dever::db('shop/sell_order')->one($id);

        $goods = Dever::db('shop/sell_order_goods')->select(array('order_id' => $info['id']));

        foreach ($goods as $k => $v) {
            $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
            //print_r($goods_info);die;
            $table[$goods_info['name']] = $v['price'];
        }
        
        return Dever::table($table);
    }

    /**
     * 更新信息
     *
     * @return mixed
     */
    public function infoUpdate($id, $name, $data)
    {
        $update = array();
        $area = Dever::param('area', $data);
        if ($area) {
            $temp = is_string($area) ? explode(',', $area) : $area;
            $update['province'] = $temp[0];
            $update['city'] = $temp[1];
        }

        $map = Dever::param('map', $data);
        if ($map) {
            $temp = is_string($map) ? explode(',', $map) : $map;
            $update['lng'] = $temp[1];
            $update['lat'] = $temp[2];
        }

        $goods = Dever::param('goods', $data);
        if ($goods) {
            $goods = Dever::json_decode($goods);

            if ($goods) {
                foreach ($goods as $k1 => $v1) {
                    if ($v1['value']) {
                        foreach ($v1['value'] as $k => $v) {
                            if ($v['state'] == 1) {
                                $w = array();
                                $w['goods_id'] = $v['id'];
                                $w['shop_id'] = $id;
                                $info = Dever::db('shop/goods')->one($w);

                                $w['category_id'] = $v1['id'];
                                if (!$info) {
                                    Dever::db('shop/goods')->insert($w);
                                } else {
                                    $w['where_id'] = $info['id'];
                                    $w['state'] = 1;
                                    Dever::db('shop/goods')->update($w);
                                }
                            } else {
                                unset($goods[$k1]['value'][$k]);
                            }
                        }
                    }
                }

                $update['goods'] = Dever::json_encode($goods);
            }
        }

        if (isset($update) && $update) {
            $update['where_id'] = $id;
            Dever::db('shop/info')->update($update);
        }

        $truename = Dever::param('truename', $data);
        $mobile = Dever::param('mobile', $data);
        if ($mobile) {
            $member = Dever::db('shop/member')->one(array('shop_id' => $id, 'mobile' => $mobile));

            $update = array();
            $update['shop_id'] = $id;
            $update['name'] = $truename;
            $update['mobile'] = $mobile;
            if ($member) {
                $update['where_id'] = $member['id'];
                Dever::db('shop/member')->update($update);
            } else {
                Dever::db('shop/member')->insert($update);
            }
        }
    }

    /**
     * 更新商品信息
     *
     * @return mixed
     */
    public function goodsUpdate($id, $name, $data)
    {
        $update = array();
        $state = Dever::param('state', $data);
        if ($state) {
            Dever::config('base')->after = true;
            $info = Dever::db('shop/goods')->one($id);
            $shop_id = $info['shop_id'];

            $shop = Dever::db('shop/info')->one($shop_id);

            if ($shop && $shop['goods']) {
                $goods = Dever::json_decode($shop['goods']);

                if (isset($goods['level_' . $info['category_id']]['value']['id_' . $info['goods_id']])) {
                    if ($state == 2) {
                        unset($goods['level_' . $info['category_id']]['value']['id_' . $info['goods_id']]);
                    }

                    if (count($goods['level_' . $info['category_id']]['value']) <= 0) {
                        unset($goods['level_' . $info['category_id']]);
                    }
                } elseif ($state == 1) {
                    $goods_info = Dever::db('goods/info')->one($info['goods_id']);
                    $cate = Dever::load('category/api')->string($info['category_id']);
                    $goods['level_' . $info['category_id']]['id'] = $info['category_id'];
                    $goods['level_' . $info['category_id']]['name'] = $cate;
                    $goods['level_' . $info['category_id']]['value']['id_' . $info['goods_id']] = array
                    (
                        'id' => $info['goods_id'],
                        'name' => $goods_info['name'],
                        'state' => 1,
                    );
                }
                
                $set['goods'] = Dever::json_encode($goods);
                $set['where_id'] = $shop_id;
                Dever::db('shop/info')->update($set);
            }
        }
    }

    /**
     * 更新库存信息
     *
     * @return mixed
     */
    public function skuUpdate($id, $name, $data)
    {
        $update = array();
        $add_num = Dever::param('add_num', $data);
        if ($add_num) {
            $state = Dever::db('shop/goods_sku')->updateTotal(array('where_id' => $id, 'total_num' => $add_num));
            if ($state) {
                $state = Dever::db('shop/goods_sku')->update(array('where_id' => $id, 'add_num' => 0));
                $info = Dever::db('shop/goods_sku')->one($id);
                $goods = Dever::db('shop/goods')->one(array('goods_id' => $info['goods_id'], 'shop_id' => $info['shop_id']));
                if ($goods) {
                    Dever::db('shop/goods')->update(array('where_id' => $goods['id'], 'total_num' => $info['total_num'], 'add_num' => 0));
                }

                if ($add_num < 0) {
                    # 记录出库日志
                } else {
                    # 记录入库日志
                }
            }
        }
    }
}