Example #1
0
// 邀请
func (this *MemberRep) GetMyInvitationMembers(memberId int) []*member.ValueMember {
	arr := []*member.ValueMember{}
	err := this.Connector.GetOrm().SelectByQuery(&arr,
		"SELECT * FROM mm_member WHERE id IN (SELECT member_id FROM mm_relation WHERE invi_member_id=?)", memberId)
	if err != nil {
		log.PrintErr(err)
		return nil
	}

	return arr
}
Example #2
0
// 获取下级会员数量
func (this *memberRep) GetSubInvitationNum(memberIds string) map[int]int {
	var d map[int]int = make(map[int]int)
	err := this.Connector.Query(fmt.Sprintf("SELECT r1.member_id,"+
		"(SELECT COUNT(0) FROM mm_relation r2 WHERE r2.invi_member_id=r1.member_id)"+
		"as num FROM mm_relation r1 WHERE r1.member_id IN(%s)", memberIds),
		func(rows *sql.Rows) {
			var id, num int
			for rows.Next() {
				rows.Scan(&id, &num)
				d[id] = num
			}
			rows.Close()
		})

	if err != nil {
		log.PrintErr(err)
	}
	return d
}