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); }
public function getinviteList() { $subtab = Input::get('subtab'); $contest_id = Input::get('contest_id'); if ($subtab) { ?> <thead> <tr> <th><input name="" type="checkbox" value=""></th> <th>Image</th> <th>Group Name</th> <th class="tr_wid_button1" align="center">Invite</th> <th class="tr_wid_button1" align="center">View</th> </tr> </thead> <tbody> <?php $grouplist = groupModel::select('group.ID as groupid', 'groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->get(); $groupcount = count($grouplist); for ($i = 0; $i < $groupcount; $i++) { $invited = invitegroupforcontestModel::where('group_id', $grouplist[$i]['groupid'])->where('contest_id', $contest_id)->count(); ?> <tr> <td class="tr_wid_id"><input name="group_list[]" type="checkbox" value="{{ $grouplist[$i]['groupid'] }}"></td> <td align="center"><img src="{{ ($grouplist[$i]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$grouplist[$i]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td> <td>{{ $grouplist[$i]['groupname'] }}</td> <td class="tr_wid_button1" align="center"><a href="#" <?php if ($invited > 0) { ?> title="Invited" style="background-color:red;" <?php } else { ?> title="Invite" onClick="invite_groups('{{ $grouplist[$i]['groupid'] }}','{{ $contest_id }}');" <?php } ?> id="invite_list_{{ $grouplist[$i]['groupid'] }}" class="add-link"></a></td> <td class="tr_wid_button1" align="center"><a href="{{ URL::to('viewgroupmember/'.$grouplist[$i]['groupid']) }}" class="view-link"></a></td> </tr> <?php } ?> </tbody> <?php } }
<?php if (Session::has('searchedgroup')) { $searchedgroup = Session::get('searchedgroup'); } $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'];
public function memberequesttogroup() { $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', 'msgcode' => "c181"); $final = array("response" => $Response); return json_encode($final); } } } else { $alreadyinvited = invitememberforgroupModel::where('user_id', $userid)->where('invitetype', 'u')->where('group_id', $group_id)->count(); if ($alreadyinvited == 0) { $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']; $Response = array('success' => '1', 'message' => 'Your request sent to Group admin', 'msgcode' => "c187"); $final = array("response" => $Response); return json_encode($final); } } else { $Response = array('success' => '0', 'message' => 'Already invited', 'msgcode' => "c200"); $final = array("response" => $Response); return json_encode($final); } } }
<div id="inv_fail" style="color:red;text-align:center;font-size:14px">{{ isset($inv_fail_message)?($inv_fail_message):"" }}</div> <div class="scrolltable"> <table class="display" cellspacing="0" width="100%" id="dd_group_list"> <thead> <tr> <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;
<div class="tab-body-wrapper"> <div id="tab-body-1" class="tab-body"> @if(isset($er_data['memberdelete'])) <p class="alert" style="color:red; font-size:13px;">{{ $er_data['memberdelete'] }}</p> @endif @if(isset($er_data['message'])) <p class="alert" style="color:red; font-size:13px;">{{ $er_data['message'] }}</p> @endif @if(isset($Message)) <p class="alert" style="color:red; font-size:13px;">{{ $Message }}</p> @endif <span id="inv_success" class="alert" style="color:green; font-size:13px;"></span> <div id="p"> <?php $d = groupModel::select('groupname', 'createdby', 'ID')->where('ID', $group_id)->get(); ?> <h1><?php echo $d[0]['groupname']; ?> </h1> <div class="fleft mb_brk"> <?php $membercount = groupmemberModel::where('group_id', $group_id)->where('user_id', Auth::user()->ID)->get()->count(); ?> <nav class="slidernav"> <div id="navbtns" class="clearfix" ><b> <?php if ($showjoinbtn != 'no') { ?> <?php
public function activegroup() { $groupid = $_GET['groupid']; $checkstatus = groupModel::where('ID', $groupid)->where('status', 1)->count(); $savegroup = groupModel::select('grouptype', 'groupname', 'createdby', 'grouptype', 'status', 'groupimage')->where('ID', $groupid)->get(); $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 /////////// if ($savegroup[0]['status'] == 1) { $status = "Active"; } else { $status = "Inactive"; } $groupdetailsactive = '<div style="font-size:12px; color: #000000; float:left;padding:10px 2px;width:100%;margin:15px;">Your group <b>"' . $groupname . '"</b> is activated by admin </div><div styel"float:left;"> <table width="180" height="95" border="0" style="margin-bottom:10px;float:left;font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Name:</td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $groupname . '</td> </tr> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Type:</td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $savegroup[0]['grouptype'] . '</td> </tr> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group status </td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">Active</td> </tr> <tr style="border-radius:6px;-webkit-border-radius: 5px; -moz-border-radius: 5px;"> <td colspan="2" style="vertical-align: text-middle;" > <span><a href="' . URL::to('viewgroupmember/' . $groupowneruserid) . '" style="text-decoration:none;><img src="' . URL::to('assets/inner/images/vist_dingdatt.png') . '/assets/inner/images/vist_dingdatt.png" width="120" height="30" /></a></span> </td> </tr> </table> </div>'; $groupdetailsdeactive = '<div style="font-size:12px; color: #000000; float:left;padding:10px 2px;width:100%;margin:15px;">Your group <b>"' . $groupname . '"</b> is deactivated by admin </div><div styel"float:left;"> <table width="180" height="95" border="0" style="margin-bottom:10px;float:left;font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Name:</td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $groupname . '</td> </tr> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Type:</td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $savegroup[0]['grouptype'] . '</td> </tr> <tr> <td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group status </td> <td style="font-size:12px;color: #5d5d5d;font-weight:bold;">Inactive</td> </tr> <tr style="border-radius:6px;-webkit-border-radius: 5px; -moz-border-radius: 5px;"> <td colspan="2" style="vertical-align: text-middle;" > <span><a href="' . URL::to('viewgroupmember/' . $groupowneruserid) . '" style="text-decoration:none;><img src="' . URL::to('assets/inner/images/vist_dingdatt.png') . '/assets/inner/images/vist_dingdatt.png" width="120" height="30" /></a></span> </td> </tr> </table> </div>'; if ($checkstatus == 1) { ///Inactive process ///// $updatedetails['status'] = 0; $affectedRows = groupModel::where('ID', $groupid)->update($updatedetails); //$details = "Your contest ".$contestname." is deactivated by admin."; $this->adminmailtogroupownerdelete($email, $groupownername, $groupname, $groupownername, $groupid, $groupdetailsdeactive); if ($affectedRows) { return 0; } } else { ///Active process ///// $updatedetails['status'] = 1; $affectedRows = groupModel::where('ID', $groupid)->update($updatedetails); //$details = "Your contest ".$contestname." is activated by admin."; $this->adminmailtogroupowner($email, $groupownername, $groupname, $groupownername, $groupid, $groupdetailsactive); if ($affectedRows) { return 1; } } }
<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> <td align="center"><a href="<?php