创建团队
语法格式:
调用参数:
参数1:tname varchar,团队名称
参数2:tkey varchar,团队邀请key
参数3:tcid varchar,团队创建人id
参数4:un varchar用户名称
参数5:ui varchar 用户头像
前端javascript调用示例:
SET @uid = UUID();
Task_Team (TeamId,TeamName,TeamInvitationKey,TeamCreatorId,CreationTime)VALUES(@uid,tname,tkey,tcid,NOW());
Task_TeamMember(Id,TeamId,UserId,UserName,UserImageHead,IsPass,TeamIdentity,CreationTime)VALUES(UUID(),
@uid,tcid,un,ui,'1','49166dba-9ec2-11e7-bf5e-005056aa632a',NOW());
SELECT @uid as TeamId;
前端javascript调用数据库存储过程示例(可在编辑区域修改参数):
U.A.Request("http://cd.1473.cn/php", (["db.1473.cn", "UseStudio_Task", "Task_CreateTeam","ed050a83-f140-11e7-bf14-005056aa632a","有思俱乐部","DMOU3-U5Y4P-HX86N-DFADN-T6CMM","fc6d04a5-467d-48a2-9d6f-d33508602b90","2018-01-04 19:18:01"]),AsynFun);
运行结果展示区域: