queryByCondtion

select 
@pageTag(){
a.*
@} 
from xzx_sys_config_info a where 
a.config_type_code='OVERDRAW_PRICE' or 
a.config_type_code='RECHARGE_PRICE' or
a.config_type_code='AGENT_PRICE' or
a.config_type_code='INTERVAL_TIME' or
a.config_type_code='START_TIME' or
a.config_type_code='END_TIME' or
a.config_type_code='ORDERTOTAL' or
a.config_type_code='WAREHOUSING_PRICE' or
config_type_code='ORDERTIMEOUT' 

updateAgentPrice

update xzx_sys_config_info set config_value=#agentPrice# where config_type_code='AGENT_PRICE'

updateTimeInterval

update xzx_sys_config_info set config_value=#timeInterval# where config_type_code='INTERVAL_TIME'

updateStratTime

update xzx_sys_config_info set config_value=#startTime# where config_type_code='START_TIME'

updateEndTime

update xzx_sys_config_info set config_value=#endTime# where config_type_code='END_TIME'

updateOverdrawPrice

update xzx_sys_config_info set config_value=#overdrawPrice# where config_type_code='OVERDRAW_PRICE'

updateWarehousingPrice

update xzx_sys_config_info set config_value=#warehousingPrice# where config_type_code='WAREHOUSING_PRICE'

queryOverdrawPrice

select config_value from xzx_sys_config_info where config_type_code='OVERDRAW_PRICE'

queryWarehousingPrice

select config_value from xzx_sys_config_info where config_type_code='WAREHOUSING_PRICE'    

queryOrderTotal

select config_value from xzx_sys_config_info where config_type_code='ORDERTOTAL'

updateRechargePrice

update xzx_sys_config_info set config_value=#rechargePrice# where config_type_code='RECHARGE_PRICE';

updateAccountOverdrawPrice

update xzx_account_info set 
      overdraft_limit=#newOverdrawPrice#,
      fixed_limit=#newOverdrawPrice#  
where del_flag=0 and overdraft_limit=#oldOverdrawPrice#
and user_id in ( #join(orderIds)#)

queryRKOrderIds

    select a.user_id from xzx_user_other_info a 
                     LEFT JOIN xzx_account_info b on a.user_id=b.user_id 

                     where 
                      @if(!isEmpty(type)){
                              a.user_type=2 
                      @}
                      @if(isEmpty(type)){
                              a.user_type=4 
                      @}
                       @if(!isEmpty(limitPrice)){
                             and b.fixed_limit=#limitPrice# 
                       @}

updateAccountWarehousingPrice

update xzx_account_info set 
@if(isEmpty(oldOverdrawPrice)){
  overdraft_limit=#newOverdrawPrice#,
@}
           fixed_limit=#newOverdrawPrice#
 where del_flag=0
and user_id  in ( #join(orderIds)#)

updateOrderTotal

update xzx_sys_config_info set config_value=#orderTotal# where config_type_code='ORDERTOTAL'

updateOrderTimeout

update xzx_sys_config_info set config_value=#orderTimeout# where config_type_code='ORDERTIMEOUT'

insertItem

INSERT INTO `xzx_sys_environmental_info`
(`item_type`, `title`, `picture`, `price`, `put_storage_price`, `parent_id`, `sort`, `create_time`, `item_unit`,`second_price`) 
VALUES 
(#itemType#, #title#, #picture#, #price#, #putStoragePrice#, #parentId#,#sort#, #createTime#, #itemUnit#,#price#)

insertItemOperate

INSERT INTO `xzx_sys_environmental_info`
(`item_type`, `title`, `picture`, `price`, `put_storage_price`, `parent_id`, `sort`, `create_time`, `item_unit`,`second_price`, `partner_id`,`city_id`) 
VALUES 
(#itemType#, #title#, #picture#, #price#, #putStoragePrice#, #parentId#,#sort#, #createTime#, #itemUnit#,#secondPrice#, #partnerId#,#cityId#)

insertItemOperate1

INSERT INTO `xzx_package_goods_info`
(`item_type`, `title`, `picture`, `price`, `put_storage_price`, `parent_id`, `sort`, `create_time`, `item_unit`,`second_price`, `partner_id`,`city_id`,`package_id`) 
VALUES 
(#itemType#, #title#, #picture#, #price#, #putStoragePrice#, #parentId#,#sort#, #createTime#, #itemUnit#,#secondPrice#, #partnerId#,#cityId#,#packageId#)

updateItem

UPDATE `xzx_sys_environmental_info` SET 
`title` = #title#
, `picture` = #picture#
, `price` = #price#
, `put_storage_price` = #putStoragePrice#
, `sort` = #sort#
@if(!isEmpty(cityId)){
, `city_id` = #cityId#
@}
@if(!isEmpty(partnerId)){
, `partner_id` = #partnerId#
@} 
WHERE `id` = #id#;

updateItem1

UPDATE `xzx_package_goods_info` SET 
`title` = #title#
, `picture` = #picture#
, `price` = #price#
, `put_storage_price` = #putStoragePrice#
, `sort` = #sort#
@if(!isEmpty(cityId)){
, `city_id` = #cityId#
@}
@if(!isEmpty(packageId)){
, `package_id` = #packageId#
@} 
WHERE `id` = #id#;    

delItem

update `xzx_sys_environmental_info` set del_flag = 1 where id = #id#

delItem1

update `xzx_package_goods_info` set del_flag = 1 where id = #id#

querIteml

select * from `xzx_sys_environmental_info` where del_flag=0
@if(!isEmpty(itemType)){
    AND item_type=#itemType#
@}
@if(!isEmpty(title)){
    AND title=#title#
@}
@if(!isEmpty(delFlag)){
    AND del_flag=#delFlag#
@}
@if(!isEmpty(topFlag)){
    AND top_flag=#topFlag#
@}
@if(!isEmpty(parentId) && parentId != ''){
    AND parent_id=#parentId#
@}
@if(isEmpty(parentId)){
    AND parent_id is NULL
@}
@if(!isEmpty(id)){
    AND id=#id#
@}
order by sort limit #page#,#limit#

querIteml1

select * from `xzx_package_goods_info` where del_flag=0
@if(!isEmpty(itemType)){
    AND item_type=#itemType#
@}
@if(!isEmpty(title)){
    AND title=#title#
@}
@if(!isEmpty(delFlag)){
    AND del_flag=#delFlag#
@}
@if(!isEmpty(topFlag)){
    AND top_flag=#topFlag#
@}
@if(!isEmpty(parentId) && parentId != ''){
    AND parent_id=#parentId#
@}
@if(isEmpty(parentId)){
    AND parent_id is NULL
@}
@if(!isEmpty(id)){
    AND id=#id#
@}
order by sort limit #page#,#limit#

queryItemAll

select * from xzx_sys_environmental_info where del_flag = 0

queryItemCount

select count(*) from `xzx_sys_environmental_info` where del_flag=0
@if(!isEmpty(itemType)){
    AND item_type=#itemType#
@}
@if(!isEmpty(title)){
    AND title=#title#
@}
@if(!isEmpty(delFlag)){
    AND del_flag=#delFlag#
@}
@if(!isEmpty(topFlag)){
    AND top_flag=#topFlag#
@}
@if(!isEmpty(parentId) && parentId != ''){
    AND parent_id=#parentId#
@}
@if(isEmpty(parentId)){
    AND parent_id is NULL
@}
@if(!isEmpty(id)){
    AND id=#id#
@}

queryAllStorage

select a.id as id,a.storage_name as storageName from xzx_sys_storage a where a.del_flag = 0

queryStorageList

select * from xzx_sys_storage where del_flag = 0
limit #page#, #limit#

queryStorageListCount

select count(*) from xzx_sys_storage where del_flag = 0

addStorage

insert into xzx_sys_storage (storage_name, storage_area, province, city, area, detail_address, create_time,longitude,latitude)
 values (
    #storageName#, #storageArea#, #province#, #city#, #area#, #detailAddress#, #createTime#,#longitude#,#latitude#
 )

updateStorage

update `xzx_sys_storage` SET `storage_name` = #storageName#, `storage_area` = #storageArea#, 
`province` = #province#, `city` = #city#, `area` = #area#, `detail_address` = #detailAddress#, 
`create_time` = #createTime# WHERE `id` = #id#;

delStorage

update xzx_sys_storage set del_flag = 1 where `id` = #id#;

queryBannerList

select `id`, `pic_name`, `pic_path`, `pic_url`, `sort`, `del_flag`, `create_time` , `city_id`
from xzx_sys_banner where del_flag=0
@if(!isEmpty(id)){
    AND id=#id#
@}
@if(!isEmpty(picName)){
    AND pic_name=#picName#
@}
@if(!isEmpty(picPath)){
    AND pic_path=#picPath#
@}
@if(!isEmpty(picUrl)){
    AND pic_url=#picUrl#
@}
@if(!isEmpty(cityId)){
    AND city_id=#cityId#
@} else {
   AND city_id='-1'
@}
@if(!isEmpty(startTime)){
    AND create_time BETWEEN #startTime# AND #endTime#
@}
@if(!isEmpty(partnerId)){
    AND partner_id = #partnerId# 
@}
order by sort limit #page#, #limit#

queryBannerListCount

select count(*) 
    from xzx_sys_banner where del_flag=0
    @if(!isEmpty(id)){
        AND id=#id#
    @}
    @if(!isEmpty(picName)){
        AND pic_name=#picName#
    @}
    @if(!isEmpty(picPath)){
        AND pic_path=#picPath#
    @}
    @if(!isEmpty(picUrl)){
        AND pic_url=#picUrl#
    @}
    @if(!isEmpty(cityId)){
        AND city_id=#cityId#
    @}else{
           AND city_id='-1'
    @}
    @if(!isEmpty(startTime)){
        AND create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(partnerId)){
        AND partner_id = #partnerId# 
    @} 
    order by sort

insertBanner

INSERT INTO `xzx_sys_banner`(`pic_name`, `pic_path`, `pic_url`, `sort`, `create_time`, `city_id`, `partner_id`) 
VALUES 
(#picName#, #picPath#, #picUrl#, #sort#, #createTime#, #cityId#, #partnerId#)

updateBanner

UPDATE `xzx_sys_banner` SET 
    `pic_name` = #picName#,
    `pic_path` = #picPath#, 
    `pic_url` = #picUrl#, 
    `sort` = #sort# 
    WHERE `id` = #id#

delBanner

UPDATE xzx_sys_banner SET del_flag=1 WHERE id=#id#  

updateOverdrawPriceByUserId

update xzx_account_info set fixed_limit=fixed_limit+#money#,overdraft_limit=overdraft_limit+#money# where del_flag=0 and account_id=#accountId#

updateLimitByUserId

update xzx_account_info set overdraft_limit=fixed_limit where del_flag=0 and account_id=#accountId#