public function usersearch($data = Null)
{
$inputs = Input::get();
$groupmemberid = groupmemberModel::where('group_id', $data)->get()->lists('user_id');
$groupmemberuserid = ProfileModel::whereNotIn('user.ID', $groupmemberid)->lists('ID');
$searcheduser = Input::get('usersearch');
$groupmemberuseridlist = ProfileModel::select('profilepicture', 'firstname', 'lastname', 'username', 'ID')->where('username', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->Orwhere('firstname', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->where('user.status', 1)->get();
return View::make('user/view/registermember')->with('group_id', $data)->with('searcheduser', $searcheduser)->with('savegroupmembers', $groupmemberuseridlist);
}
public function addgroupmembers()
{
$curdate = date('Y-m-d h:i:s');
$inputdetails = Input::get();
$inputdetails['createddate'] = $curdate;
//return $inputdetails;
$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 {
$Response = array('success' => '0', 'message' => 'Some Details Missing');
$final = array("response" => $Response);
return json_encode($final);
}
}
public function other_profile($data = Null)
{
$memberlist = groupmemberModel::where('user_id', $data)->distinct()->lists('group_id');
return View::make('user/profile/otherprofile')->with('profileid', $data)->with('memberlist', $memberlist);
}
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);
}
$user_id = Auth::user()->ID;
if (Auth::user()->ID == 1) {
if ($searchedgroup == '') {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->get();
} else {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->where('groupname', 'like', '%' . $searchedgroup . '%')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->get();
}
} else {
if ($searchedgroup == '') {
$group = groupmemberModel::select('group_members.group_id', 'group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->leftJoin('group', 'group.ID', '=', 'group_members.group_id')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->where('group_members.user_id', $user_id)->get();
} else {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->where('groupname', 'like', '%' . $searchedgroup . '%')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->get();
}
}
for ($i = 0; $i < count($group); $i++) {
$groupmembercnt = groupmemberModel::where('group_id', $group[$i]['groupid'])->get()->count();
?>
<tr>
<td>{{ $i+1; }} </td>
<td class="tr_wid_id">{{ $group[$i]['groupname'] }}</td>
<td align="center"><img src=" {{ ($group[$i]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$group[$i]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td>{{ $group[$i]['grouptype'] }}</td>
<td><?php
if ($group[$i]['firstname'] != '') {
echo $group[$i]['firstname'] . ' ' . $group[$i]['lastname'];
} else {
echo $group[$i]['username'];
}
?>
</td>
<?php
public function ajaxaccepgroup()
{
$invitetype = explode(',', $_GET['invite']);
$groupid = explode(',', $_GET['group_id']);
$user_id = explode(',', $_GET['user_id']);
count($invitetype);
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];
$verify = groupmemberModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->get()->count();
if ($verify) {
$datareturn = "You are Already Member of this group";
$delete = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->delete();
} else {
$savegroupmembers = groupmemberModel::create($inputdetails);
$delete = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->delete();
if ($savegroupmembers && $delete) {
$datareturn = "Member accepted successfully";
}
}
}
return $datareturn;
}
function uninvitegroupmemberforcontest()
{
$groupmemberlist = Input::get('groupmemberid');
$group_id = Input::get('group_id');
$contest_id = Input::get('contest_id');
$groupmemberlistid = explode(',', $groupmemberlist);
$inv_suc_message = 0;
for ($i = 0; $i < count($groupmemberlistid); $i++) {
$groupmemberid = groupmemberModel::where('id', $groupmemberlistid[$i])->get()->first();
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $groupmemberid->user_id)->count();
if ($invited != 0) {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $groupmemberid->user_id)->delete();
$invited_member = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $groupmemberid->user_id)->count();
if ($invited_member) {
$contestdetails = contestModel::where('ID', $contest_id)->get()->first();
if ($contestdetails['createdby'] != $groupmemberid->user_id) {
$invited_memberdelete = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $groupmemberid->user_id)->delete();
}
}
$inv_suc_message = 1;
} else {
$inv_suc_message = 2;
}
}
if ($inv_suc_message == 1) {
$Response = array('success' => '1', 'message' => 'Uninvited successfully', 'msgcode' => "c198");
$final = array("response" => $Response);
return json_encode($final);
} else {
if ($inv_suc_message == 2) {
$Response = array('success' => '0', 'message' => 'You are not invited.So cant able to uninvite', 'msgcode' => "c201");
$final = array("response" => $Response);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => 'No data', 'msgcode' => "c199");
$final = array("response" => $Response);
return json_encode($final);
}
}
}
<th style="background-color:#0896D6"><input name="" class="checkallgroups" type="checkbox" value="1" style="visibility:hidden;"></th>
<th><span class="txt_img">Image</span></th>
<th><span class="txt_groupname">Group Name</span></th>
<th class="tr_wid_button1" style="background-color:#0896D6" align="center"><span class="txt_invite">Invite</span>/Uninvite</th>
<th class="tr_wid_button1" style="background-color:#0896D6" align="center"><span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
$grouplist = groupModel::select('group.ID as groupid', 'groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage')->LeftJoin('group_members', 'group_members.group_id', '=', 'group.ID')->Leftjoin('user', 'user.ID', '=', 'group_members.group_id')->where('group_members.user_id', Auth::user()->ID)->where('group.status', 1)->get();
$groupcount = count($grouplist);
for ($i = 0; $i < $groupcount; $i++) {
$invited = invitegroupforcontestModel::where('group_id', $grouplist[$i]['groupid'])->where('contest_id', $contest_id)->count();
$groupmemberlist = groupmemberModel::where('group_id', $grouplist[$i]['groupid'])->get()->count();
$groupmemberlist_admin = groupmemberModel::where('group_id', $grouplist[$i]['groupid'])->where('user_id', 1)->get()->count();
?>
<tr class="clickforrowselect" <?php
/* onClick="aa(<?php echo $i; ?>)" */
?>
id="clickforrowselect_<?php
echo $i;
?>
">
<td class="tr_wid_id"><input name="group_list" id="checkgrouplist_<?php
echo $i;
?>
" class="checkgrouplist" type="checkbox" value="{{ $grouplist[$i]['groupid'] }}" <?php
if ($invited + 1 == $groupmemberlist - $groupmemberlist_admin && $groupmemberlist - $groupmemberlist_admin != 1) {
echo "checked";
}
?>
<th class="tr_wid_button1" align="center"><span class="txt_remove">Remove / Exit</span></th><?php
}
?>
<?php
if ($showjoinbtn != 'no') {
?>
<th class="tr_wid_button1" align="center"><span class="txt_exit">Exit</span></th><?php
}
?>
<th class="tr_wid_button1" align="center"><span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
$savegroupmembers = groupmemberModel::select('group_members.id as groupmemberid', 'group_members.user_id', 'user.firstname', 'user.lastname', 'user.username', 'user.profilepicture', 'group.createdby as groupadmin_userid', 'user.ID as usrid')->LeftJoin('user', 'user.ID', '=', 'group_members.user_id')->where('group_id', $group_id)->where('user.status', 1)->LeftJoin('group', 'group.ID', '=', 'group_members.group_id')->orderby('group_members.id')->get();
if ($showjoinbtn == 'no') {
$contestdetails = contestModel::where('ID', $contest_id)->get()->first();
}
for ($i = 0; $i < count($savegroupmembers); $i++) {
?>
<?php
if ($showjoinbtn == 'no') {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $savegroupmembers[$i]['user_id'])->count();
?>
<td><?php
if ($contestdetails['createdby'] != $savegroupmembers[$i]['user_id'] && $savegroupmembers[$i]['user_id'] != 1) {
?>
<input type="checkbox" name="checkseparate" class="checkseparate" <?php
if ($invited > 0) {
echo "checked";
public function exitgroup()
{
$groupid = $_GET['groupid'];
$groupmeberuserid = $_GET['groupmeberuserid'];
$removemember = groupmemberModel::where('group_id', $groupid)->where('user_id', $groupmeberuserid)->delete();
return Redirect::to('viewgroupmember/' . $groupid)->with('group_id', $groupid)->with('showjoinbtn', 'yes')->with('contest_id', 'no')->with('Message', 'You are exit from that group');
}
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);
}
}
}
<div id="p">
<table class="display" cellspacing="0" width="100%" id="dd_profile_group">
<thead>
<tr>
<th><Span class="txt_sno">S.No</span></th>
<th><Span class="txt_img">Image</span></th>
<th><Span class="txt_groupname">Group Name</span></th>
<th><Span class="txt_memberowner">Member/Owner</span></th>
<th class="tr_wid_button1" align="center"><Span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($memberlist); $i++) {
$checkverifyuser = groupmemberModel::where('user_id', Auth::user()->ID)->where('group_id', $memberlist[$i])->get()->count();
$grouplist = groupModel::select('groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage', 'group.ID as groupid', 'user.ID as userid')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->where('group.ID', $memberlist[$i])->get();
if (count($grouplist)) {
?>
<tr>
<td>{{ $i+1 }} </td>
<td align="center"><img src="{{ ($grouplist[0]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$grouplist[0]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td>{{ $grouplist[0]['groupname'] }}</td>
<td><?php
if ($grouplist[0]['createdby'] == $profileid) {
echo "Owner";
} else {
echo "Member";
}
?>
</td>
