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>