<?php

namespace Common\Model;
//[1.3.86]
class RetailScoremallModel extends BaseModel
{
    protected $tableName = 'retail_scoremall';
    const ID = 'id';
    const NAME = 'name';    //varchar(255) DEFAULT NULL COMMENT '商品名',
    const PRICE = 'price';    //varchar(255) DEFAULT '0' COMMENT '价格',
    const INTEGRAL = 'integral';    //varchar(255) DEFAULT NULL COMMENT '积分',
    const NUM = 'num';    //int(11) DEFAULT NULL COMMENT '数量',
    const IMAGE = 'image';    //varchar(255) DEFAULT NULL COMMENT '商品图',
    const ADD_TIME = 'time';    //varchar(255) DEFAULT NULL COMMENT '添加时间',
    const STATUS = 'status';    //varchar(255) DEFAULT '2' COMMENT '1为s上架2为下架',
    const MERCHANT_ID = 'merchantid';    //varchar(255) DEFAULT '2' COMMENT '1为s上架2为下架',
    const TYPE = 'type';    //varchar(255) DEFAULT NULL COMMENT '1为积分兑换，2为积分加会员卡余额，3为积分加微信支付',
    const INFORMATION = 'information';    //text COMMENT '商品描述',
    const NOTICE = 'notice';    //text COMMENT '兑换须知',
    const IMAGE_ID = 'image_id';    //varchar(255) DEFAULT '0',

    /**
     * 临时把图片添加到图库，之后的image字段将废弃
     */
    public function tempMoveImg()
    {
        $map = array(
            'image' => array(array('neq', '/Uploads'),array('neq', ''),array('exp','IS NOT NULL'),'AND'),
            'image_id' => 0,
            'status' => array('in','0,1')
        );
        $list = $this->getSelect($map,'id,image,image_id,merchantid');
        if ($list) {
            $arr = array();
            foreach ($list as $value) {
                $save['image_id'] = $this->addImage($value['image'], $value['merchantid']);
                $this->updateOrder(array('id' => $value['id']), $save);
                $arr[] = $save;
            }
//            print_r($arr);
        }
    }

    protected function addImage($path, $merchant_id)
    {
        $time = time();
        $menu = explode('/', $path);
        $catalog = $menu;
        array_splice($catalog,count($menu) - 1, 1);
        $item = array(
            'merchant_id' => $merchant_id,
            'path' => $path,
            'add_time' => $time,         //varchar(20) DEFAULT NULL,
            'storage_type' => 1,     //tinyint(1) DEFAULT '1',
            'source_type' => 1,      //tinyint(1) DEFAULT '1',
            'name' => $menu[count($menu) - 1],             //varchar(100) DEFAULT '',
            'original_name' => $menu[count($menu) - 1],    //varchar(255) DEFAULT '',
            'size' => 0,             //varchar(20) DEFAULT '',
            'from_name' => '积分商城图片',        //varchar(50) DEFAULT NULL,
            'from_type_id' => 25,     //tinyint(3) DEFAULT '0',
            'user_type' => 3,        //tinyint(1) DEFAULT '0'
            'catalog' => implode('/', $catalog),          //varchar(255) DEFAULT NULL,
        );
        $id = M('image_gallery')->add($item);
        return $id;
    }

}