xyzshop/data/model/sns_sharestore.model.php

<?php
/**
 * 分享店铺
 *
 
 */
defined('InShopNC') or exit('Access Invalid!');
class sns_sharestoreModel{
	/**
	 * 新增分享店铺
	 *
	 * @param $param 添加信息数组
	 * @return 返回结果
	 */
	public function sharestoreAdd($param){
		if (empty($param)){
			return false;
		}
		if (is_array($param)){
			$result = Db::insert('sns_sharestore',$param);
			return $result;
		}else {
			return false;
		}
	}
	/**
	 * 查询分享店铺详细
	 * 
	 * @param $condition 查询条件
	 * @param $field 查询字段
	 */
	public function getSharestoreInfo($condition,$field='*'){
		$param = array();
		$param['table'] = 'sns_sharestore';
		$param['field'] = array_keys($condition);
		$param['value'] = array_values($condition);
		return Db::getRow($param,$field);
	}
	/**
	 * 更新分享店铺信息
	 * @param $param 更新内容
	 * @param $condition 更新条件
	 */
	public function editSharestore($param,$condition) {
		if(empty($param)) {
			return false;
		}
		//得到条件语句
		$condition_str	= $this->getCondition($condition);
		$result	= Db::update('sns_sharestore',$param,$condition_str);
		return $result;
	}
	/**
	 * 分享店铺记录列表
	 *
	 * @param $condition 条件
	 * @param $page 分页
	 * @param $field 查询字段
	 * @return array 数组格式的返回结果
	 */
	public function getShareStoreList($condition,$page='',$field='*',$type = 'simple') {
		$condition_str	= $this->getCondition($condition);
		$param	= array();
		switch ($type){
            case 'detail':
				$param['table'] = 'sns_sharestore,store';
				$param['join_type'] = empty($condition['join_type'])?'LEFT JOIN':$condition['join_type'];
				$param['join_on'] = array(
					'sns_sharestore.share_storeid=store.store_id'
				);
				break;
			default:
				$param['table'] = 'sns_sharestore';
		}
		$param['where']	= $condition_str;
		$param['field'] = $field;
		$param['order'] = $condition['order'] ? $condition['order'] : 'sns_sharestore.share_addtime desc';
		$param['limit'] = $condition['limit'];
		$param['group'] = $condition['group'];
		return Db::select($param,$page);
	}
	/**
	 * 删除分享商品
	 */
	public function delSharestore($condition){
		if (empty($condition)){
			return false;
		}
		$condition_str = '';
		if ($condition['share_id'] != ''){
			$condition_str .= " and share_id='{$condition['share_id']}' ";
		}
		if ($condition['share_memberid'] != ''){
			$condition_str .= " and share_memberid='{$condition['share_memberid']}' ";
		}
		return Db::delete('sns_sharestore',$condition_str);
	}
	/**
	 * 将条件数组组合为SQL语句的条件部分
	 *
	 * @param	array $condition_array
	 * @return	string
	 */
	private function getCondition($condition_array){
		$condition_sql = '';
		//自增ID
		if ($condition_array['share_id'] != '') {
			$condition_sql	.= " and `sns_sharestore`.share_id = '{$condition_array['share_id']}'";
		}
		//会员ID
		if ($condition_array['share_memberid'] != '') {
			$condition_sql	.= " and `sns_sharestore`.share_memberid = '{$condition_array['share_memberid']}'";
		}
		//隐私权限
		if ($condition_array['share_privacyin'] !=''){
			$condition_sql	.= " and `sns_sharestore`.share_privacy in('{$condition_array['share_privacyin']}')";
		}
		return $condition_sql;
	}
}