churen/app/goods/lib/Manage.php

<?php

namespace Goods\Lib;

use Dever;

class Manage
{
    public function search_api()
    {
        $table = 'goods/info';
        $keyword = Dever::input('keyword');

        $yes = Dever::input('yes');

        $where = array();

        $cate = Dever::input('cate');
        if ($cate) {
            $where['cate_id'] = $cate;
        }

        if ($yes) {
            $yes = Dever::db($table)->search(array('ids' => $yes));
        }
        if (!$keyword) {
            $where['limit'] = '0,50';
            $data = Dever::db($table)->search($where);
        } else {
            $where['name'] = $keyword;
            $data = Dever::db($table)->search($where);
        }

        $result = array();
        if ($yes) {
            foreach ($yes as $k => $v) {
                if (isset($data[$k])) {
                    unset($data[$k]);
                }
                $yes[$k]['selected'] = 'selected';
            }
            $data = $yes + $data;

            $data = array_merge($data, array());
        } else {
            $data = array_merge($data, array());
        }

        if (!$data) {
            Dever::alert('暂无数据');
        }

        return $data;
    }

    /**
     * 更新信息
     *
     * @return mixed
     */
    public function infoUpdate($id, $name, $data)
    {
        # 更新分类id
        $category = Dever::param('category', $data);
        if ($category) {
            if (is_array($category)) {
                $category_id = end($category);
                $top_category_id = $category[0];
                if (isset($category[1])) {
                    $second_category_id = $category[1];
                } else {
                    $second_category_id = $category[0];
                }
                
            } else {
                $category_id = $category;
                $top_category_id = $category;
                $second_category_id = $category;
            }

            $update['top_category_id'] = $top_category_id;
            $update['second_category_id'] = $second_category_id;
            $update['category_id'] = $category_id;
        }

        $pic = Dever::param('pic', $data);
        $pic_cover = Dever::param('pic_cover', $data);
        if ($pic && !$pic_cover) {
            if (is_string($pic)) {
                $pic = explode(',', $pic);
            }
            $update['pic_cover'] = $pic[0];
        }

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

    /**
     * 更新需求属性信息
     *
     * @return mixed
     */
    public function attrUpdate($id, $name, $data)
    {
        print_r($data);die;
        foreach ($data as $k => $v) {

        }
    }

    /**
     * 显示信息
     *
     * @return mixed
     */
    public function info($id)
    {
        $info = Dever::db('goods/info')->one($id);
        if ($info) {
            $table['编号'] = $info['id'];
            $table['标题'] = $info['name'];
            $table['分类'] = Dever::load("category/api.string", $info['category']);

            if ($info['pic']) {
                $table['商品图'] = '<img src="'.$info['pic'].'" width="150" />';
            }

            //$table['属性'] = $this->attrInfo($info);

            if ($info['cdate']) {
                $table['发布时间'] = date("Y-m-d H:i:s", $info['cdate']);
            }
            if ($info['udate']) {
                $table['更新时间'] = date("Y-m-d H:i:s", $info['udate']);
            }
        }

        return Dever::table($table);
    }

    private function attrInfo($info)
    {
        $table = array();

        $info = Info::init($info['top_category_id']);

        if ($info) {
            $info = $info->info($info, 'id');
            if ($info && isset($info['attr'])) {
                foreach ($info['attr'] as $k => $v) {
                    $table[$v['name']] = $v['value_string'];
                }
            }
        }
        
        return Dever::table($table);
    }

    public function area($id, $name, $data)
    {
        # 不再执行syncone等后续操作
        Dever::config('base')->after = 1;

        $type = Dever::input('type');

        $area = Dever::param('area', $data);

        if ($area) {

            if (isset($area[2])) {
                $update['district_id'] = $area[2];
            }

            if (isset($area[1])) {
                $update['city_id'] = $area[1];
            }

            if (isset($area[0])) {
                $update['province_id'] = $area[0];
            }

            if (isset($update)) {
                $update['where_id'] = $id;

                Dever::db($type . '/info')->update($update);
            }
        }
    }

    public function skuConfig()
    {
        $data['action'] = Dever::url('goods/lib/manage.skuUp');
        $data['info_id'] = Dever::input('search_option_info_id');
        return $data;
    }

    public function skuUp_api()
    {
        $info_id = Dever::input('info_id');
        $attr = Dever::input('attr');
        $key = Dever::input('key');
        $price = Dever::input('price');
        $s_price = Dever::input('s_price');
        $f_price = Dever::input('f_price');
        $num = Dever::input('num');

        if ($key) {
            foreach ($key as $k => $v) {
                if (isset($price[$k]) && $price[$k]) {
                    $info = Dever::db('goods/info_sku')->one(array('key' => $v));
                    $data['info_id'] = $info_id;
                    $data['attr'] = $attr[$k];
                    $data['key'] = $v;
                    $data['price'] = $price[$k];
                    $data['s_price'] = $s_price[$k];
                    $data['f_price'] = $f_price[$k];
                    $data['num'] = $num[$k];
                    if (!$info) {
                        Dever::db('goods/info_sku')->insert($data);
                    } else {
                        $data['where_id'] = $info['id'];
                        Dever::db('goods/info_sku')->update($data);
                    }
                }
            }
        }

        Dever::out('yes');
    }

    public function skuInput()
    {
        $id = Dever::input('search_option_info_id');

        $sku = Dever::db('goods/info_sku')->getData(array('info_id' => $id));

        $info = Dever::db('goods/info')->one($id);

        $info = Info::init(-1)->info($info, 'list_reorder');

        $html = '请先选择属性';
        if ($info['sell_attr']) {
            $head = '<thead><tr>';
            $body = '<tbody>';
            $option = array();
            foreach ($info['sell_attr'] as $k => $v) {
                $head .= '<th>'.$v['name'].'</th>';
                if (isset($v['option_sku'])) {
                    $option[$k] = $v['option_sku'];
                }
            }

            $head .= '<th>销售价</th>';
            $head .= '<th>市场价</th>';
            $head .= '<th>进货价</th>';
            //$head .= '<th>库存</th>';
            $head .= '</tr></thead>';

            if ($option) {
                $option = Dever::cartesian($option);

                foreach ($option as $k => $v) {
                    $body .= '<tr data-row="' .($k+1). '">';

                    $key = $id = array();
                    foreach ($v['name'] as $k1 => $v1) {
                        $rows = 1;
                        $body .= '<td width="50" rowspan="'.$rows.'">'.$v1.'</td>';
                        $id[] = array
                        (
                            'id' => $v['id'][$k1],
                            'attr_id' => $v['info_id'][$k1],
                        );
                        $key[] = $v['info_id'][$k1] . '-' . $v['id'][$k1];
                    }
                    $key = implode('_', $key);
                    $f_price = $s_price = $price = $num = '';
                    if (isset($sku[$key])) {
                        $f_price = $sku[$key]['f_price'];
                        $s_price = $sku[$key]['s_price'];
                        $price = $sku[$key]['price'];
                        //$num = $sku[$key]['num'];
                    }
                    
                    $body .= '<td width="30"><input type="text" class="layui-input" name="price['.$k.']"  value="'.$price.'"/></td>';
                    $body .= '<td width="30"><input type="text" class="layui-input" name="s_price['.$k.']" value="'.$s_price.'"/></td>';
                    $body .= '<td width="30"><input type="text" class="layui-input" name="f_price['.$k.']"  value="'.$f_price.'"/></td>';
                    //$body .= '<td width="30"><input type="text" class="layui-input" name="num['.$k.']"  value="'.$num.'"/></td>';

                    $body .= '<input type="hidden" name="key['.$k.']" value="'.$key.'"/><textarea style="display:none;" name="attr['.$k.']"/>'.json_encode($id).'</textarea>';
                    $body .= '</tr>';
                }
            }

            $body .= '</tbody>';
            
            $html = $head . $body;
        }

        return $html;
    }

    /**
     * 显示用户信息
     *
     * @return mixed
     */
    public function showUserInfo($id)
    {
        $info = Dever::db('goods/card_code')->find($id);
        $table = array();
        if ($info && $info['status'] > 1 && $info['uid'] && $info['uid'] > 0) {
            $user = Dever::load('passport/user-one', $info['uid']);
            $shop = Dever::load('shop/info-one', $info['shop_id']);
            if ($user) {
                $table['领取门店'] = $shop['name'] . '('.$shop['mobile'].')';
                $table['领取人'] = $user['username'] . '('.$info['uid'].')';
                $table['手机号'] = $user['mobile'];
                $table['兑换时间'] = date('Y-m-d H:i:s', $info['ddate']);
            }
        }

        return Dever::table($table);
    }

    /**
     * 创建兑换码
     *
     * @return mixed
     */
    public function createCard($id, $name, $param)
    {
        $num = Dever::param('num', $param);
        $card_id = Dever::param('card_id', $param);

        if ($num > 0) {
            for ($i = 0; $i< $num;$i++) {
                $this->createCode($card_id);
            }
        }
    }

    private function createCode($card_id)
    {
        # 生成卡号和密码
        $card = 'CR' . Dever::rand(14);
        $pwd = Dever::rand(8);

        $where['card'] = $card;
        $where['pwd'] = $pwd;
        $info = Dever::db('goods/card_code')->find($where);

        if (!$info) {
            $where['card_id'] = $card_id;
            Dever::db('goods/card_code')->insert($where);
        } else {
            $this->createCode($card_id);
        }
    }

    /**
     * 作废
     *
     * @return mixed
     */
    public function drop_api($id)
    {
        $update['where_id'] = $id;
        $update['type'] = 4;
        Dever::db('goods/card_code')->update($update);
        return 'ok';
    }

    public function recovery_api($id)
    {
        $update['where_id'] = $id;
        $update['type'] = 1;
        Dever::db('goods/card_code')->update($update);
        return 'ok';
    }
}