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#