//
//  JXLabelObject.h
//  shiku_im
//
//  Created by p on 2018/6/21.
//  Copyright © 2018年 Reese. All rights reserved.
//

#import <Foundation/Foundation.h>

@interface JXLabelObject : NSObject

@property (nonatomic, copy) NSString *tableName;

@property (nonatomic, copy) NSString *userId;// 标签拥有者
@property (nonatomic, copy) NSString *groupId; // 标签Id
@property (nonatomic, copy) NSString *groupName;//标签名字
@property (nonatomic, copy) NSString *userIdList;// 该标签下的用户Id [100,120]

// groupHelperRecord
@property (nonatomic, copy) NSString *userIds;
@property (nonatomic, copy) NSString *text1;
@property (nonatomic, copy) NSString *text2;
@property (nonatomic, copy) NSString *userNames;
@property (nonatomic, copy) NSString *userNamesWithGroup;
@property (nonatomic, assign) BOOL   isGroupMessages;
@property (nonatomic, assign) BOOL   isCYMSGgroupANDFriendy;
@property (nonatomic, copy) NSString *message;
@property (nonatomic, copy) NSString *sendTime;
@property (nonatomic, copy) NSString *userNmaesWithFriend;
// GroupAnnouncement self.userId,self.roomJid,self.content,self.creatTime,self.type,self.roomName,self.sendUserId,self.typeName
@property (nonatomic, copy) NSString *roomJid;
 @property (nonatomic, copy) NSString *content;
//字符串改成了数组
//@property (nonatomic, strong) NSArray *content;


@property (nonatomic, copy) NSString *creatTime;
@property (nonatomic, copy) NSString *roomName;
@property (nonatomic, copy) NSString *sendUserId;
@property (nonatomic, copy) NSString *typeName;
@property (nonatomic, copy) NSString *type;
@property (nonatomic, copy) NSString *selectItem;
// VIP等级
@property (nonatomic, assign) int gradeIndex;
// VIP等级数据
@property (nonatomic, copy) NSData *data;

+(JXLabelObject*)sharedInstance;

//数据库增删改查
-(BOOL)insert;
-(BOOL)delete;
-(BOOL)update;

// 获取所有标签
-(NSMutableArray *)fetchAllLabelsFromLocal;

// 获取用户的所有标签
- (NSMutableArray *)fetchLabelsWithUserId:(NSString *)userId;


-(BOOL)insertRecord;
- (BOOL)checkGroupHelperRecordTableCreatedInDb:(FMDatabase *)db;
- (NSMutableArray *)fetchAllRecordsFromLocal;
// 创建表头公告表
- (BOOL)checkGroupAnnouncementTableCreatedInDb:(FMDatabase *)db;
// 检查是否存在roomJid
- (BOOL)checkGroupAnnouncementRoomJid;
- (BOOL)insertRecordGroupAnnouncement;
- (BOOL)updateRecordGroupAnnouncement;
- (BOOL)updateRecordGroupAnnouncementSelectItem;
- (NSString *)fetchAllGroupAnnouncementFromLocal;
- (NSString *)fetchGroupAnnouncementSelectItemFromLocal;

// 创建所有VIP表
- (BOOL)checkGradeTableCreatedInDb:(FMDatabase *)db;
// 更新VIP表
- (BOOL)updateGradeTable;
// 插入VIP表
- (BOOL)insertGradeTable;

@end