messageCenter/service/ent_address_book.go

package service

import (
	"app.yhyue.com/moapp/jybase/go-xweb/log"
	IC "bp.jydev.jianyu360.cn/SocialPlatform/messageCenter/rpc/messagecenter/init"
	"bp.jydev.jianyu360.cn/SocialPlatform/messageCenter/rpc/messagecenter/messagecenter"
)

func (b ChatGroupService) EntPersonsList(param *messagecenter.EntPersonsListReq) {
	var sql string
	if param.Name != "" {
		sql = "SELECT a.id,a.pid,a.name,c.id as user_id,c.name as user_name,c.phone as user_phone,c.power as user_power,e.name as role from entniche_department a " +
			"INNER JOIN entniche_department_user b on (a.ent_id=? and a.id=b.dept_id) " +
			"INNER JOIN entniche_user c on (b.user_id=c.id and c.name like '%" + param.Name + "%') " +
			"LEFT JOIN entniche_user_role d on (c.id=d.user_id) " +
			"LEFT JOIN entniche_role e on (d.role_id=e.id) " +
			"order by a.id,convert(c.name using gbk) COLLATE gbk_chinese_ci asc"
	} else {
		sql = `SELECT a.id,a.pid,a.name,c.id as user_id,c.name as user_name,c.phone as user_phone,c.power as user_power,e.name as role from entniche_department a 
			INNER JOIN entniche_department_user b on (a.ent_id=? and a.id=b.dept_id) 
			INNER JOIN entniche_user c on (b.user_id=c.id) 
			LEFT JOIN entniche_user_role d on (c.id=d.user_id) 
			LEFT JOIN entniche_role e on (d.role_id=e.id) 
			order by a.id,convert(c.name using gbk) COLLATE gbk_chinese_ci asc`
	}
	data := IC.MainMysql.SelectBySql(sql, param.EntId)
	if data != nil && len(*data) > 0 {
		for _, v := range *data {
			log.Println(v)
			//id := cm.IntAll(v["id"])

			/*user := map[string]interface{}{
				"user_id":  cm.IntAll(v["user_id"]),
				"power":    user_power,
				"username": cm.ObjToString(v["user_name"]),
				"phone":    cm.ObjToString(v["user_phone"]),
				"role":     cm.ObjToString(v["role"]),
			}
			//log.Println("权限：", user_power)

			list = append(list, map[string]interface{}{
				"id":    id,
				"pid":   cm.IntAll(v["pid"]),
				"name":  cm.ObjToString(v["name"]),
				"users": []map[string]interface{}{user},
			})*/
		}
	}

	//log.Println(checkedArr)
	/*this.ServeJson(Result{Data: M{
		"entname":     this.GetSession("entName"),
		"checked":     checked,
		"quota":       VarEntInfo.GetById(entId).Quota,
		"mystaff":     Mysql.Count(Entniche_user, map[string]interface{}{"ent_id": entId}),
		"list":        list,
		"checkedList": checkedArr,
	}})*/
}