68 行
2.9 KiB
PHP
可执行文件
68 行
2.9 KiB
PHP
可执行文件
<?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;
|
|
}
|
|
|
|
} |