删除团队
语法格式:
调用参数:
参数1:uid 用户id
参数2:tid 团队Id
前端javascript调用数据库存储过程示例(可在编辑区域修改参数):
U.A.Request("http://cd.1473.cn/php", (["db.1473.cn", "UseStudio_Task", "Task_DelectTeam","e4a5b03b-febd-4ab4-bc6a-a74f02a8110d","6ff68add-c8e4-11e7-81ee-005056b350a4"]),AsynFun);
运行结果展示区域:
前端javascript调用示例:
SET @tid = (SELECT Task_Team.TeamId FROM Task_Team WHERE Task_Team.TeamCreatorId = uid AND Task_Team.TeamId = tid);
#SET @pid = (SELECT UserId FROM Task_Poject,Task_PojectPermiss WHERE Task_Poject.PojectId = Task_PojectPermiss.PermissId AND Task_PojectPermiss.UserId = uid AND Task_Poject.PojectTeamId = tid);
IF(@tid IS NULL) THEN
DELETE FROM Task_TeamMember where UserId = uid AND TeamId = tid;
# DELETE FROM Task_PojectPermiss WHERE UserId = @pid;
ELSE
DELETE FROM Task_Team WHERE TeamCreatorId = uid AND TeamId = tid;
DELETE FROM Task_TeamMember where TeamId = @tid;
>