\eapie\source\table\shopshop_goods_region

Summary

Methods
Properties
Constants
get_unique_id()
find_exists_id()
insert()
remove()
update()
find()
find_goods_scope_pcd()
select_scope_province_city_district()
select()
select_page()
sql_goods_ids()
$check
CACHE_KEY
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Constants

CACHE_KEY

CACHE_KEY = array(__CLASS__, "shop_goods") : string

缓存的键列表

Properties

$check

$check : array

数据检测

Type

array

Methods

get_unique_id()

get_unique_id() : string

获取一个id号

Returns

string

find_exists_id()

find_exists_id(string  $shop_goods_region_id) 

根据ID,判断是否存在

Parameters

string $shop_goods_region_id

insert()

insert(array  $data = array(), array  $call_data = array()) : boolean

插入新数据

Parameters

array $data

数据

array $call_data

数据

Returns

boolean

remove()

remove(array  $shop_goods_region_id = '') : array

根据唯一标识,删除数据

Parameters

array $shop_goods_region_id

Returns

array

update()

update(array  $where = array(), array  $data = array(), array  $call_data = array()) : boolean

更新数据

Parameters

array $where
array $data
array $call_data

Returns

boolean

find()

find(array  $shop_goods_region_id = '') : array

获取一条数据

Parameters

array $shop_goods_region_id

Returns

array

find_goods_scope_pcd()

find_goods_scope_pcd(string  $shop_goods_id, string  $shop_goods_region_province, string  $shop_goods_region_city, string  $shop_goods_region_district) : array

根据 商品ID、省市区 查询数据

Parameters

string $shop_goods_id
string $shop_goods_region_province
string $shop_goods_region_city
string $shop_goods_region_district

Returns

array

select_scope_province_city_district()

select_scope_province_city_district(string  $shop_goods_region_province, string  $shop_goods_region_city, string  $shop_goods_region_district) 

根据 省市区 查询数据

Parameters

string $shop_goods_region_province
string $shop_goods_region_city
string $shop_goods_region_district

select()

select(array  $config = array()) : array

获取多个数据 $config = array( 'where' => array(), //条件 'orderby' => array(), //排序 'limit' => array(0, page_size), //取出条数,默认不限制 );

Parameters

array $config

Returns

array

select_page()

select_page(array  $config = array()) : array

获取所有的分页数据

$config = array( 'where' => array(), //条件 'orderby' => array(), //排序 'limit' => array(0, page_size), //取出条数,默认获取10条 );

limit的分页算法是:当前页数-1 * page_size 序号的算法:key键+1,+每页显示的条数。等于分页后的序号。{key + 1 + page_size}

返回的数据: $data = array( 'row_count' => //数据总条数 'limit_count' => //已取出条数 'page_size' => //每页的条数 'page_count' => //总页数 'page_now' => //当前页数 'data' => //数据 );

Parameters

array $config

配置信息

Returns

array

sql_goods_ids()

sql_goods_ids(  $shop_goods_region_province,   $shop_goods_region_city,   $shop_goods_region_district) : string

返回一个省市区的商品id SQL语句

Parameters

$shop_goods_region_province
$shop_goods_region_city
$shop_goods_region_district

Returns

string —

[sql语句]