/**
* 修改触摸屏
* @param $id：int 触摸屏ID 默认0
* @param $arr：Array 其内容如下
* name：string（50） （可不填，触摸屏名）
brandid：int（4） （可不填，品牌ID）
isshow：text （可不填，是否显示对应的功能.存放的是二维数组.其中第一维为ipad,touch,brand分别表示IPAD,触摸屏和品牌专区.第二维里面对应的ID为b_category表的style为13的.1为显示）
touchbrand：string（1000）（可不填，触摸屏下的品牌 arr[brandid]=order 0-100）
openkey：string（1000）（可不填，打开触摸屏密钥）
description：string（5000） （可不填，试衣间简介）
headtail：string（1000） （可不填，页头,页尾 array[head][touch] 或 array[tail][touch]）
enddate：date （可不填，到期时间）
lock：int（4） （可不填，锁定）
apikey：string（100） （可不填，同步密钥）
* @return 如果添加数据成功返回true
* 否则返回其错误信息
*/
public function touchUpdateById($id = 0, $arr = array())
{
$id = trim($id);
try {
Comm::checkValue($id, Yii::t('public', '触摸屏号'), 1, 1);
} catch (BeubeuException $e) {
throw new BeubeuException($e->getMessage(), $e->getCode());
}
if (count($arr) > 0 && gettype($arr) == 'array') {
$updata_arr = array();
if (isset($arr['name'])) {
$str_param = trim($arr['name']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '触摸屏名'), 0, 0, 50);
$updata_arr['name'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['brandid'])) {
$str_param = trim($arr['brandid']);
try {
Comm::checkValue($str_param, Yii::t('public', '品牌号'), 1, 1, 50000);
$updata_arr['brandid'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['touchbrand'])) {
$str_param = trim($arr['touchbrand']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '触摸屏下的品牌'), 0, 1, 1000);
$updata_arr['touchbrand'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['isshow'])) {
$str_param = trim($arr['isshow']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '对应的功能'), 0, 1, 1000);
$updata_arr['isshow'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['openkey'])) {
$str_param = trim($arr['openkey']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '触摸屏密钥'), 0, 1, 1000);
$updata_arr['openkey'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['description'])) {
$str_param = trim($arr['description']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '试衣间简介'), 0, 1, 5000);
$updata_arr['description'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['headtail'])) {
$str_param = trim($arr['headtail']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '页头,页尾'), 0, 1, 1000);
$updata_arr['headtail'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['enddate'])) {
$str_param = trim($arr['enddate']);
try {
Comm::dataSingle($str_param, Yii::t('touch_config', '到期时间'));
$updata_arr['enddate'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['lock'])) {
$str_param = trim($arr['lock']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '锁定'), 1, 1, 1000);
$updata_arr['lock'] = $str_param;
} catch (Exception $e) {
}
}
if (isset($arr['apikey'])) {
$str_param = trim($arr['apikey']);
try {
Comm::checkValue($str_param, Yii::t('touch_config', '同步密钥'), 0, 1, 100);
$updata_arr['apikey'] = $str_param;
} catch (Exception $e) {
}
}
try {
touch_config::model()->updateByPk($id, $updata_arr);
return true;
} catch (Exception $e) {
throw new BeubeuException(Yii::t('public', '修改数据失败'), BeubeuException::SQL_UPDATE_ERR);
}
} else {
throw new BeubeuException(Yii::t('beu_brand', '数据') . Yii::t('public', '不能为空'), BeubeuException::FIELD_EMPTY);
}
}
/**
* 根据品牌ID对beu_brand表中数据的数据进行修改
* @param $id：int 品牌id 默认0
* @param $arr：Array 其内容如下
* logoimgpath：string（255） （可不填，品牌图片）
telephone：string（255） （可不填，品牌电话）
address：string（255） （可不填，品牌地址）
fax：string（255） （可不填，传真）
website：string（255） (可不填，网站地址：http://dfa.com)
companyname：string（255） （可不填，公司名）
status：int （可不填，是否显示，默认为1。参数值也只能为1或2）
createdate：string（10） （可不填，创建时间）
code_start:款号规则开始位置
code_end:款号规则结束位置
* @return 如果修改数据成功返回true
* 否则返回false
*/
public static function brandUpdateById($id = 0, $arr = array())
{
$id = trim($id);
try {
Comm::checkValue($id, Yii::t('public', '品牌号'), 1, 1);
} catch (BeubeuException $e) {
throw new BeubeuException($e->getMessage(), $e->getCode());
}
if (count($arr) > 0 && gettype($arr) == 'array') {
$updata_arr = array();
if (isset($arr['englishname'])) {
try {
$englishname = trim($arr['englishname']);
Comm::checkValue($englishname, Yii::t('beu_brand', '品牌英文名'), 0, 1, 255);
$updata_arr['englishname'] = $englishname;
} catch (BeubeuException $e) {
}
}
if (isset($arr['name'])) {
try {
$name = trim($arr['name']);
Comm::checkValue($name, Yii::t('beu_brand', '品牌名'), 0, 1, 255);
$updata_arr['name'] = $name;
} catch (BeubeuException $e) {
throw new BeubeuException($e->getMessage(), $e->getCode());
}
}
if (isset($arr['logoimgpath'])) {
try {
$logoimgpath = trim($arr['logoimgpath']);
Comm::checkValue($logoimgpath, Yii::t('beu_brand', '公司地址'), 0, 0, 255);
$updata_arr['logoimgpath'] = $logoimgpath;
} catch (BeubeuException $e) {
}
}
if (isset($arr['telephone'])) {
//公司电话字段存在，并且长度不超过255
try {
$telephone = trim($arr['telephone']);
Comm::phoneToSingle($telephone, Yii::t('beu_brand', '电话号码'));
$updata_arr['telephone'] = $telephone;
} catch (BeubeuException $e) {
}
}
if (isset($arr['address'])) {
//公司地址字段存在，并且长度不超过255
try {
$address = trim($arr['address']);
Comm::checkValue($address, Yii::t('beu_brand', '公司地址'), 0, 0, 255);
$updata_arr['address'] = $address;
} catch (BeubeuException $e) {
}
}
if (isset($arr['fax'])) {
//传真字段存在，并且长度不超过255
try {
$fax = trim($arr['fax']);
Comm::phoneToSingle($fax, Yii::t('beu_brand', '传真'));
$updata_arr['fax'] = $fax;
} catch (BeubeuException $e) {
}
}
if (isset($arr['website'])) {
//网站地址字段存在，并且长度不超过255
try {
$website = trim($arr['website']);
Comm::checkValue($website, Yii::t('beu_brand', '网站地址'), 0, 0, 255);
$updata_arr['website'] = $website;
} catch (BeubeuException $e) {
}
}
if (isset($arr['companyname']) && !empty($arr['companyname']) && strlen($arr['companyname']) <= 255) {
//公司名字段存在，并且长度不超过255
try {
$companyname = trim($arr['companyname']);
Comm::checkValue($companyname, Yii::t('beu_brand', '公司名称'), 0, 0, 255);
$updata_arr['companyname'] = $companyname;
} catch (BeubeuException $e) {
}
}
if (!isset($arr['code_start']) || intval($arr['code_start']) != $arr['code_start']) {
$updata_arr['code_start'] = 0;
} else {
$updata_arr['code_start'] = $arr['code_start'];
}
if (!isset($arr['code_end']) || intval($arr['code_end']) != $arr['code_end']) {
$updata_arr['code_end'] = 0;
} else {
$updata_arr['code_end'] = $arr['code_end'];
}
if (isset($arr['status']) && !empty($arr['status']) && trim($arr['status']) == 11) {
//显示状态字段存在，并且为2表示不显示
$updata_arr['status'] = 11;
//不显示
} else {
if (isset($arr['status']) && !empty($arr['status']) && trim($arr['status']) == 10) {
$updata_arr['status'] = 10;
//显示
}
}
if (isset($arr['angle']) && !empty($arr['angle']) && intval($arr['angle']) == $arr['angle'] && $arr['angle'] > 0) {
//衣服支持的角度
$updata_arr['angle'] = $arr['angle'];
}
if (isset($arr['model'])) {
//衣服支持的角度
$updata_arr['model_type'] = $arr['model'];
}
if (isset($arr['createdate']) && !empty($arr['createdate'])) {
//时间字段存在并格式正确
try {
$createdate = trim($arr['createdate']);
Comm::dataSingle($createdate, Yii::t('beu_brand', '添加时间'), false);
$updata_arr['createdate'] = $createdate;
} catch (BeubeuException $e) {
}
}
$img = self::brandImgUp($id);
if ($img) {
$img = json_decode($img, true);
try {
$updata_arr['logoimgpath'] = $img['brand']['img'];
} catch (Exception $e) {
}
}
try {
beu_brand::model()->updateAll($updata_arr, 'id=:textx', array(':textx' => $id));
Yii::app()->cache->delete(CacheName::getCacheName('brand_name_list_all'));
//清除品牌列表
} catch (BeubeuException $e) {
throw new BeubeuException(Yii::t('public', '修改数据失败'), BeubeuException::SQL_UPDATE_ERR);
}
} else {
throw new BeubeuException(Yii::t('beu_brand', '数据') . Yii::t('public', '不能为空'), BeubeuException::FIELD_EMPTY);
}
return true;
}
/**
* 根据条件查找beu_clothes表里的数据
* @parm $brandid 品牌id
* @parm $clothescategory 品类一级
* @parm $clothescategory2 品类二级
* @parm $modeltype 模特类型
* @parm $strd_data 开始时间
* @parm $end_data 结束时间
* @parm $key 搜索条件（衣服名、衣服id、款号）
* @parm $page 多少页
* @parm $pagecount 每页显示数量
* @return 成功后返回数据 array ('data' => $newstypelist, 'count' => $con,'pageSize'=>$pagecount,'page'=>$page ) data是查询到的数据，count是总页数，pageSize是每页显示数量，page是当前页
*/
public static function beuclothesSelectForAll($page = 1, $pagecount = 20, $brandid = 0, $modeltype = 0, $clothescategory = 0, $clothescategory2 = 0, $strd_data = 0, $end_data = 0, $key = '')
{
$page = trim($page);
$brandid = trim($brandid);
$modeltype = trim($modeltype);
$clothescategory = trim($clothescategory);
$clothescategory2 = trim($clothescategory2);
$strd_data = trim($strd_data);
$end_data = trim($end_data);
$key = trim($key);
if (!empty($page)) {
//规范页码
try {
Comm::checkValue($page, Yii::t('public', '页码'), 1, 0);
} catch (BeubeuException $e) {
$page = 1;
}
} else {
$page = 1;
}
if (!empty($pagecount)) {
try {
Comm::checkValue($pagecount, '', 1, 1);
} catch (BeubeuException $e) {
$pagecount = 20;
}
} else {
$page = 20;
}
$w_s = '';
$w_s_arr = array();
if (!empty($brandid)) {
//规范品牌id
try {
Comm::checkValue($brandid, Yii::t('public', '品牌号'), 1, 1, self::$Int_max);
$w_s = 'beu_clothes.brandid=:brandid';
$w_s_arr[':brandid'] = $brandid;
} catch (BeubeuException $e) {
}
}
if (!empty($modeltype)) {
//规范模特id
try {
Comm::checkValue($modeltype, Yii::t('public', '模特类型'), 1, 1, self::$Int_max);
if (!empty($w_s)) {
$w_s .= ' and ';
}
$w_s .= 'beu_clothes.modelgender=:modelgender';
$w_s_arr[':modelgender'] = $modeltype;
} catch (BeubeuException $e) {
}
}
if (!empty($clothescategory)) {
//规范品类一级
try {
Comm::checkValue($clothescategory, Yii::t('clothes', '一级品类'), 1, 1, self::$Int_max);
if (!empty($w_s)) {
$w_s .= ' and ';
}
$w_s .= 'beu_clothes.clothescategory=:clothescategory';
$w_s_arr[':clothescategory'] = $clothescategory;
} catch (BeubeuException $e) {
}
}
if (!empty($clothescategory2)) {
//规范品类二级
try {
Comm::checkValue($clothescategory2, Yii::t('clothes', '二级品类'), 1, 0, self::$Int_max);
if (!empty($w_s)) {
$w_s .= ' and ';
}
$w_s .= 'beu_clothes.clothescategory2=:clothescategory2';
$w_s_arr[':clothescategory2'] = $clothescategory2;
} catch (BeubeuException $e) {
}
}
if (!empty($strd_data)) {
//开始时间
try {
$strd_data = Comm::dataSingle($strd_data, Yii::t('clothes', '开始时间'));
if (!empty($w_s)) {
$w_s .= ' and ';
}
$w_s .= 'beu_clothes.date_add>=:strd_data';
$w_s_arr[':strd_data'] = $strd_data;
} catch (BeubeuException $e) {
}
}
if (!empty($end_data)) {
//结束时间
try {
$end_data = Comm::dataSingle($end_data, Yii::t('clothes', '结束时间'));
if (!empty($w_s)) {
$w_s .= ' and ';
}
$w_s .= 'beu_clothes.date_add<=:end_data';
$w_s_arr[':end_data'] = $end_data;
} catch (BeubeuException $e) {
}
}
if (!empty($key)) {
//规范关键词
if (!empty($w_s)) {
$w_s .= ' and (';
}
try {
Comm::checkValue($key, Yii::t('public', '关键词'), 1, 1, self::$Int_max);
$w_s .= 'beu_clothes.id=:clothesid or ';
$w_s_arr[':clothesid'] = $key;
} catch (BeubeuException $e) {
}
$w_s .= 'beu_clothes.name like :name or beu_clothes.brandnumber like :brandnumber )';
$w_s_arr[':name'] = "%{$key}%";
$w_s_arr[':brandnumber'] = "%{$key}%";
}
try {
$sql = Yii::app()->db->createCommand()->select('beu_clothes.id,beu_clothes.name,beu_clothes.brandid,beu_clothes.clothescategory,beu_clothes.clothescategory2,beu_clothes.brandnumber,beu_clothes.modelgender,thumbnail,beu_clothes.date_add,beu_brand.name as brandname')->from('beu_clothes')->join('beu_brand', 'beu_clothes.brandid=beu_brand.id')->where($w_s, $w_s_arr)->order('beu_clothes.id desc');
$sql2 = $sql;
$newstypelist = $sql->limit($pagecount, ($page - 1) * $pagecount)->queryAll();
//获取总个数
$con = $sql2->queryAll();
$con = count($con);
$criteria = new CDbCriteria();
$pages = new CPagination($con);
$pages->pageSize = $pagecount;
$pages->applyLimit($criteria);
if (count($newstypelist) > 0) {
return array('data' => $newstypelist, 'count' => $con, 'pageSize' => $pagecount, 'page' => $pages);
} else {
throw new BeubeuException(Yii::t('public', '查询数据失败'), BeubeuException::SQL_SELECT_ERR);
}
} catch (BeubeuException $e) {
throw new BeubeuException(Yii::t('public', '查询数据失败'), BeubeuException::SQL_SELECT_ERR);
}
}
