<span class="txt_memname">User Name</span><?php
} else {
?>
<span class="txt_grpowner">Group owner</span><?php
}
?>
</th>
</tr>
</thead>
<tbody>
<?php
if ($accepttype == 'admin') {
$invitedlist = invitememberforgroupModel::select('invitememberforgroup.user_id as usrid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'group.ID as group_id', 'invitememberforgroup.invitetype', 'group.groupimage')->where('group.createdby', Auth::user()->ID)->where('invitememberforgroup.invitetype', 'u')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->Join('user', 'user.ID', '=', 'invitememberforgroup.user_id')->get();
} else {
$invitedlist = invitememberforgroupModel::select('invitememberforgroup.user_id as usrid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'invitememberforgroup.invitetype', 'group.ID as group_id', 'group.groupimage', 'group.createdby')->LeftJoin('user', 'user.ID', '=', 'invitememberforgroup.user_id')->where('user_id', Auth::user()->ID)->where('invitetype', 'm')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->get();
}
for ($i = 0; $i < count($invitedlist); $i++) {
if ($accepttype == 'admin') {
if ($invitedlist[$i]['firstname'] != '') {
$membername = $invitedlist[$i]['firstname'] . ' ' . $invitedlist[$i]['lastname'];
} else {
$membername = $invitedlist[$i]['username'];
}
} else {
$memberdetails = User::find($invitedlist[$i]['createdby']);
if ($memberdetails['firstname'] != '') {
$membername = $memberdetails['firstname'] . ' ' . $memberdetails['lastname'];
} else {
$membername = $memberdetails['username'];
}
public function userdelete()
{
$userid = $_GET['userid'];
/// Comment delete //////////
$cmtcnt = commentModel::select('id')->where('userid', $userid)->get();
for ($i = 0; $i < count($cmtcnt); $i++) {
$replycnt = replycommentModel::where('comment_id', $cmtcnt[$i]['id'])->get()->count();
if ($replycnt) {
replycommentModel::where('comment_id', $cmtcnt[$i]['id'])->delete();
}
}
/// REply comt delete /////
$replycmtcnt = replycommentModel::where('user_id', $userid)->get()->count();
if ($replycmtcnt) {
replycommentModel::where('user_id', $userid)->delete();
}
/// Contest delete/////
$contestcnt = contestModel::select('ID')->where('createdby', $userid)->get();
for ($k = 0; $k < count($contestcnt); $k++) {
$conpartdet = contestparticipantModel::select('ID')->where('contest_id', $contestcnt[$k]['ID'])->get();
for ($p = 0; $p < count($conpartdet); $p++) {
$cmtcnt = commentModel::where('contest_participant_id', $conpartdet[$p]['ID'])->delete();
votingModel::where('contest_participant_id', $conpartdet[$p]['ID'])->delete();
}
$contestintrdlet = contestinterestModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
invitefollowerforcontestModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
invitegroupforcontestModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
leaderboardModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
privateusercontestModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
contestModel::where('createdby', $userid)->delete();
contestparticipantModel::where('contest_id', $contestcnt[$k]['ID'])->delete();
}
///Contestparticipant delete ///////////
$contestparticipant = contestparticipantModel::where('user_id', $userid)->get();
for ($p = 0; $p < count($contestparticipant); $p++) {
$cmtcnt = commentModel::where('contest_participant_id', $contestparticipant[$p]['ID'])->delete();
votingModel::where('contest_participant_id', $contestparticipant[$p]['ID'])->delete();
}
///////////////Group //////////////////
$group = groupModel::select('ID')->where('createdby', $userid)->get();
if (count($group) > 0) {
groupmemberModel::where('group_id', $group[0]['ID'])->delete();
invitegroupforcontestModel::where('group_id', $group[0]['ID'])->delete();
invitememberforgroupModel::where('group_id', $group[0]['ID'])->delete();
}
contestparticipantModel::where('user_id', $userid)->delete();
followModel::where('userid', $userid)->delete();
followModel::where('followerid', $userid)->delete();
userinterestModel::where('user_id', $userid)->delete();
votingModel::where('user_id', $userid)->delete();
invitememberforgroupModel::where('user_id', $userid)->delete();
groupmemberModel::where('user_id', $userid)->delete();
ProfileModel::where('ID', $userid)->delete();
$er_data['message'] = 'User details deleted successfully';
return Redirect::to('user')->with('er_data', $er_data);
}
<!----- Multi Select End --------->
</head>
<body >
<!--Header-->
<input type="hidden" id="sessionlanguage" value="<?php
echo Session::get('language');
?>
">
<div class="head_con">
<div class="logo_con">
<img src="{{ URL::to('assets/inner/img/DingDatt_logo_web1.png') }}" width="150" height="51">
</div>
<?php
$admin = invitememberforgroupModel::where('group.createdby', Auth::user()->ID)->where('invitememberforgroup.invitetype', 'u')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->get()->count();
$user = invitememberforgroupModel::where('user_id', Auth::user()->ID)->where('invitetype', 'm')->get()->count();
$redflag = reportflagModel::where('action_taken', 0)->get()->count();
?>
<div class="fright">
<?php
if (Auth::user()->ID == 1) {
?>
<div style="height:25px;"></div><?php
}
?>
<div class="noty fleft">
<?php
if (Auth::user()->ID == 1) {
?>
<a href="<?php
public function ajaxrejectgroup()
{
$invitetype = explode(',', $_GET['invite']);
$groupid = explode(',', $_GET['group_id']);
$user_id = explode(',', $_GET['user_id']);
for ($i = 0; $i < count($invitetype); $i++) {
$curdate = date('Y-m-d h:i:s');
$inputdetails['invitetype'] = $invitetype[$i];
$inputdetails['group_id'] = $groupid[$i];
$inputdetails['createddate'] = $curdate;
$inputdetails['user_id'] = $user_id[$i];
$cntinvittype = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->get()->count();
if ($cntinvittype) {
$reject = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->delete();
}
if (count($invitetype) > 0) {
$datareturn = "You rejected that request";
} else {
$datareturn = "You are not invited";
}
}
return $datareturn;
}
public function requestcount()
{
$user_id = Input::get('user_id');
$admincount = invitememberforgroupModel::select('invitememberforgroup.user_id as userid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'group.ID as group_id', 'invitememberforgroup.invitetype', 'group.groupimage')->where('group.createdby', $user_id)->where('invitememberforgroup.invitetype', 'u')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->Join('user', 'user.ID', '=', 'invitememberforgroup.user_id')->get()->count();
$membercount = invitememberforgroupModel::select('invitememberforgroup.user_id as userid', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'invitememberforgroup.invitetype', 'group.ID as group_id', 'group.groupimage', 'group.createdby')->LeftJoin('user', 'user.ID', '=', 'invitememberforgroup.user_id')->where('user_id', $user_id)->where('invitetype', 'm')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->get()->count();
$final = array("admincount" => $admincount, "membercount" => $membercount);
return json_encode($final);
}
public function addthismembertogroup($data = null)
{
$group_id = $_GET['group_id'];
$userid = $_GET['userid'];
$savegroup = groupModel::select('grouptype', 'groupname', 'createdby')->where('ID', $group_id)->get();
$curdate = date('Y-m-d h:i:s');
$inputdetails['user_id'] = $userid;
$inputdetails['group_id'] = $group_id;
$inputdetails['createddate'] = $curdate;
$inputdetails['invitetype'] = 'm';
if ($savegroup[0]['grouptype'] == 'private') {
$already = invitememberforgroupModel::where('user_id', $userid)->where('group_id', $group_id)->count();
if ($already == 0) {
$invite = invitememberforgroupModel::create($inputdetails);
if ($invite) {
$groupowneruserid = $savegroup[0]['createdby'];
$getcreateduserdetails = ProfileModel::select('email', 'firstname', 'lastname', 'username')->where('ID', $groupowneruserid)->get();
$email = $getcreateduserdetails[0]['email'];
if ($getcreateduserdetails[0]['firstname'] != '') {
$groupownername = $getcreateduserdetails[0]['firstname'] . ' ' . $getcreateduserdetails[0]['lastname'];
} else {
$groupownername = $getcreateduserdetails[0]['username'];
}
$groupname = $savegroup[0]['groupname'];
///// Group member details ///////////
$groupmemberdetails = ProfileModel::select('email', 'firstname', 'lastname', 'username')->where('ID', $userid)->get();
if ($groupmemberdetails[0]['firstname'] != '') {
$membername = $groupmemberdetails[0]['firstname'] . ' ' . $groupmemberdetails[0]['firstname'];
} else {
$membername = $groupmemberdetails[0]['username'];
}
if (Auth::user()->ID == 1) {
///Admin sent the notification mail to group Owner ////
//$this->adminmailtogroupowner($email,$groupownername,$groupname,$membername,$group_id);
}
/* Here Set the Notification for send to Group member */
$er_data['message'] = 'Your request sent to the group member';
return Redirect::to('viewgroupmember/' . $group_id)->with('er_data', $er_data);
}
} else {
$er_data['message'] = 'Request already sent to member';
return Redirect::to('viewgroupmember/' . $group_id)->with('er_data', $er_data);
}
} else {
$savegroupmembers = groupmemberModel::create($inputdetails);
$er_data['message'] = 'You have added this member to group';
return Redirect::to('viewgroupmember/' . $group_id)->with('er_data', $er_data);
}
}
public function memberequeattogroup()
{
$userid = Input::get('userid');
$group_id = Input::get('group_id');
$groupdetails = groupModel::select('grouptype', 'groupname')->where('id', $group_id)->get();
$grouptype = $groupdetails[0]['grouptype'];
$curdate = date('Y-m-d h:i:s');
$inputdetails['user_id'] = $userid;
$inputdetails['group_id'] = $group_id;
$inputdetails['createddate'] = $curdate;
$inputdetails['invitetype'] = 'u';
if ($grouptype == 'open') {
$validation = Validator::make($inputdetails, groupmemberModel::$rules);
if ($validation->passes()) {
$savegroupmembers = groupmemberModel::create($inputdetails);
if ($savegroupmembers) {
$Response = array('success' => '1', 'message' => 'Group Members saved successfully');
$final = array("response" => $Response);
return json_encode($final);
}
}
} else {
$invite = invitememberforgroupModel::create($inputdetails);
if ($invite) {
$getcreateduserdetails = ProfileModel::select('email', 'firstname', 'lastname')->where('ID', $userid)->get();
$email = $getcreateduserdetails[0]['email'];
$name = $getcreateduserdetails[0]['firstname'] . ' ' . $getcreateduserdetails[0]['lastname'];
$groupname = $groupdetails[0]['groupname'];
/* Here Set the Notification for send to Group admin */
$Response = array('success' => '1', 'message' => 'Your request sent to Group admin');
$final = array("response" => $Response);
return json_encode($final);
}
}
}
