ShoutBox is a like a social networking website where users can post comments, share photographs, videos and audios. The main objective of this system is to create a dynamic web application where USER can :
Login and register ,
Post shouts which includes uploading text, photos, videos and audios ,
See friends shouts and own shouts ,
Comment on his own shouts as well as his friends shouts ,
Report friends shouts ,
See pending list of requests which are not yet confirmed ,
Send friend request, accept or reject friend requests ,
Unfriend already made friend .
ADMIN functionality :
Approve new users ,
Delete or view all approved users ,
View shouts of approved users ,
Delete reported shouts
We used Spring Boot Framework, SCSS, Bootstrap 4, HTML 5, Angular 7 and MySQL to design ShoutBox.
INSERT THE FOLLOWING STORED PROCEDURES IN DATABASE :
- PROC_FRIEND_REQUEST_ACCEPT_REJECTED
CREATE PROCEDURE PROC_FRIEND_REQUEST_ACCEPT_REJECTED(IN sentFlag varchar(20),IN pendingFlag varchar(20), IN currentUserId int, IN currentFriendId int)
BEGIN
declare rowsAffected int;
select count(*) into @countVal from user_friends where (friend=currentUserId and friend_owner=currentFriendId) or (friend_owner=currentUserId or friend=currentFriendId);
if(@countVal=2) then
update user_friends set flag=sentFlag where friend_owner= currentFriendId and friend=currentUserId;
update user_friends set flag=pendingFlag where friend= currentFriendId and friend_owner=currentUserId;
else
insert into user_friends(flag,friend_owner,friend) values(pendingFlag,currentUserId,currentFriendId);
insert into user_friends(flag,friend_owner,friend) values(sentFlag,currentFriendId,currentUserId);
END IF;
END
- PROC_REJECT_APPROVED_FRIENDS
CREATE PROCEDURE PROC_REJECT_APPROVED_FRIENDS(IN flag varchar(20), IN currentUserId int, IN currentFriendId int)
BEGIN
update user_friends set flag=flag where friend_owner=currentFriendId and friend=currentUserId;
update user_friends set flag=flag where friend_owner=currentUserId and friend=currentFriendId;
END