产品名称：iWX JAVA微信管理平台源码-微友1314

JAVA版微信管理平台免费源码，QQ：3136810087
下载地址：http://pan.baidu.com/s/1bnjJOYz
http://pan.baidu.com/s/1pJ5ag9l

源码请到如下论坛注册看帖下载：http://www.weiyou1314.com/bbs/forum.php

1.我的微信
账号信息
修改密码
公共账号管理
2.权限设置
后台菜单管理
角色管理
账户管理
3.APP应用
APP信息设置
APP下载设置
4.微汽车
微汽车
微汽车官网设置
销售人员列表
微汽车模版配置
汽车预约详细
5.实用小工具
6.微相册
我的微相册
微相册设置
7.微活动
优惠券活动
刮刮卡活动
大转盘活动
一战到底管理
微投票
题库管理
团购活动管理
活动管理
8.微宣传
微宣传配置
微宣传图片
9.微插件
城市天气
智能翻译
在线听歌
人脸检测
历史上的今天
10.微酒店
我的微酒店
微酒店官网设置
酒店模版配置
酒店预约详细
11.微素材
图文
多图文
图片
语音
视频
文本
12.微调研
我的微调研
13.微用户
用户列表
14.微官网
我的微官网
模版配置
官网链接配置
15.微回复
关注回复
自动回复
关键字回复
菜单回复
LBS回复
语音回复
扫描二维码回复
16.实用小工具
实用小工具
17.微喜帖
喜帖管理
18.微餐饮
门店设置
19.微商城
商品管理
订单管理
会员中心
系统设置
PC端设置
20.微名片
微名片
微名片设置
21.微表单
表单管理
22.微留言
留言板设置
留言列表
黑名单列表
23.微菜单
自定义菜单管理
24.微客服

[1].[代码] 微信管理平台源码 跳至[1]

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

<?xml version="1.0"encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.weixin.yzh.entity.hotelwebsite.WxHotelWsiteImages">

    <!-- 获取首页logo图片和背景图片信息 -->

    

    <resultMap type="wxHotelWsiteImages"id="wxHotelWsiteImages"><!-- 通用图片logo 背景大图片信息查询 -->

        <id column="hotelwebsite_image_id"property="hotelwebsite_image_id"/>

        <result column="user_id"property="user_id"/>

        <result column="logo_image_url"property="logo_image_url"/>

        <result column="bg_image_url"property="bg_image_url"/>

        <result column="bg_image_url2"property="bg_image_url2"/>

        <result column="bg_image_url3"property="bg_image_url3"/>

        <result column="bg_image_url4"property="bg_image_url4"/>

        <result column="bg_image_url5"property="bg_image_url5"/>

        <result column="type"property="type"/>

        <result column="inserttime"property="inserttime"/>

    </resultMap>

    <select id="getLogoAndBgImage"parameterType="int"resultMap="wxHotelWsiteImages">

        select * from wx_hotel_wsite_image where user_id = #{userId} and type = #{type}

    </select>

    <!-- 轮播图信息列表 -->

    <resultMap type="wxHotelWsiteImageLunbo"id="wxHotelWsiteImageLunboList"><!-- 通用轮播图片信息查询 -->

        <id column="hotelwebsite_lunbo_id"property="hotelwebsiteLunboId"/>

        <result column="user_id"property="userId"/>

        <result column="lunbo_title"property="lunboTitle"/>

        <result column="lunbo_type"property="lunboType"/>

        <result column="lunbo_linkurl"property="lunboLinkurl"/>

        <result column="material_id"property="materialId"/>

        <result column="shopping_id"property="shoppingId"/>

        <result column="scratchcard_id"property="scratchcardId"/>

        <result column="coupon_id"property="couponId"/>

        <result column="member_id"property="memberId"/>

        <result column="hotel_id"property="hotelId"/>

        <result column="hotel_link_url"property="hotelLinkUrl"/>

        <result column="lunbo_image_url"property="lunboImageUrl"/>

        <result column="hudong_link_url"property="hudongLinkUrl"/>

        <result column="lunbo_order"property="lunboOrder"/>

        <result column="type"property="type"/>

        <result column="inserttime"property="inserttime"/>

    </resultMap>

    <select id="getWxWsiteImageLunbo"parameterType="int"resultMap="wxHotelWsiteImageLunboList">

        select * from wx_hotel_wsite_lunbo where user_id = #{userId} and type = #{type} order by lunbo_order desc

    </select>

    <!-- 获取微官网基础设置信息 -->

    <resultMap type="wxWsiteBase"id="wxWsiteBase">

        <id column="website_id"property="websiteId"/>

        <result column="user_id"property="userId"/>

        <result column="website_name"property="websiteName"/>

        <result column="website_key"property="websiteKey"/>

        <result column="website_back_title"property="websiteBackTitle"/>

        <result column="website_img"property="websiteImg"/>

        <result column="website_menu_show"property="websiteMenuShow"/>

        <result column="website_telcheck"property="websiteTelcheck"/>

        <result column="website_tel"property="websiteTel"/>

        <result column="website_lbscheck"property="websiteLbscheck"/>

        <result column="website_lbs_id"property="websiteLbsId"/>

        <result column="website_footer_title"property="websiteFooterTitle"/>

        <result column="website_index_model_num"property="websiteIndexModelNum"/>

        <result column="website_list_model_num"property="websiteListModelNum"/>

        <result column="website_content_model_num"property="websiteContentModelNum"/>

        <result column="website_style_model_num"property="websiteStyleModelNum"/>

        <result column="website_newscheck"property="websiteNewscheck"/>

        <result column="website_lunbocheck"property="websiteLunbocheck"/>

        <result column="website_footercheck"property="websiteFootercheck"/>

        <result column="inserttime"property="inserttime"/>

    </resultMap>

    <select id="getWxWsiteBase"parameterType="int"resultMap="wxWsiteBase">

        select * from wx_wsite_base where user_id = #{userId}

    </select>

    <!-- 获取首页最新消息信息 -->

    <!-- 

    <resultMap type="WxWsiteNews"id="WxWsiteNewsList">

        <id column="website_news_id"property="website_news_id"/>

        <result column="user_id"property="user_id"/>

        <result column="material_id"property="material_id"/>

        <result column="website_news_order"property="website_news_order"/>

        <result column="inserttime"property="inserttime"/>

        <collection property="wxMaterial"ofType="wxMaterial">

            <id column="material_id"property="materialId"/>

            <result column="material_writer"property="materialWriter"/>

            <result column="material_title"property="materialTitle"/>

            <result column="material_url"property="materialUrl"/>

            <result column="material_link_url"property="materialLinkUrl"/>

            <result column="material_digest"property="materialDigest"/>

            <result column="material_text"property="materialText"/>

            <result column="material_date"property="materialDate"/>

            <result column="material_type_id"property="materialTypeId"/>

            <result column="material_next_id"property="materialNextId"/>

            <result column="user_id"property="userId"/>

            <result column="material_addr"property="materialAddr"/>

        </collection>

    </resultMap>

    <select id="getWxWsiteNews"parameterType="int"resultMap="WxWsiteNewsList">

        SELECT wxw.*,wxm.* FROM wx_wsite_news AS wxw LEFT JOIN wx_material AS wxm ON wxw.material_id = wxm.material_id 

        WHERE wxw.user_id=#{userId} ORDER BY website_news_order DESC LIMIT3

    </select>

     -->

    <!-- 获取大栏目信息 -->

    <resultMap type="wxHotelWsiteClass"id="wxHotelWsiteClassList">

        <id column="hotel_website_class_id"property="hotelWebsiteClassId"/>

        <result column="user_id"property="userId"/>

        <result column="website_class_title"property="websiteClassTitle"/>

        <result column="website_class_img_url"property="websiteClassImgUrl"/>

        <result column="website_class_desc"property="websiteClassDesc"/>

        <result column="website_class_icon_url"property="websiteClassIconUrl"/>

        <result column="website_class_type"property="websiteClassType"/>

        <result column="website_class_link_url"property="websiteClassLinkUrl"/>

        <result column="website_class_material_id"property="websiteClassMaterialId"/>

        <result column="website_class_shopping_id"property="websiteClassShoppingId"/>

        <result column="scratchcard_id"property="scratchcardId"/>

        <result column="coupon_id"property="couponId"/>

        <result column="member_id"property="memberId"/>

        <result column="hotelid"property="hotelId"/>

        <result column="hotel_link_url"property="hotelLinkUrl"/>

        <result column="type"property="type"/>

        <result column="website_class_order"property="websiteClassOrder"/>

        <result column="hudong_link_url"property="hudongLinkUrl"/>

        <result column="inserttime"property="inserttime"/>

        <result column="list_model_num"property="listModelNum"/>

    </resultMap>

    <select id="getWxWsiteClassQuanBu"parameterType="int"resultMap="wxHotelWsiteClassList">

        select * from wx_hotel_website_class where user_id = #{userId} and type = #{type} order by website_class_order desc

    </select>

    <select id="getWxWsiteClassSi"parameterType="int"resultMap="wxHotelWsiteClassList">

        select * from wx_hotel_website_class where user_id = #{userId} and type = #{type} order by website_class_order desc  LIMIT0,4

    </select>

    <select id="getWxWsiteClass"parameterType="int"resultMap="wxHotelWsiteClassList">

        select * from wx_hotel_website_class where user_id = #{userId} and type = #{type} order by website_class_order desc  LIMIT4,10

    </select>

    <!-- 获取大栏目下面的二级栏目的个数 -->

    <select id="getWxWsiteClassForListNUM"parameterType="Map"resultType="int">

        SELECT count(*) as countAll  from wx_hotel_website_list where user_id = #{userId} and hotel_website_class_id =#{hotelWebsiteClassId}

    </select>

</mapper>