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 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); } } }
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 groupmemberaccepttheadminrequest() { $userid = Input::get('userid'); $userid = explode(',', $userid); $useridcount = count($userid); $groupid = Input::get('group_id'); $curdate = date('Y-m-d h:i:s'); $inputdetails['group_id'] = $groupid; $inputdetails['createddate'] = $curdate; $accepttype = Input::get('accepttype'); for ($i = 0; $i < $useridcount; $i++) { $inputdetails['user_id'] = $userid[$i]; if ($accepttype == 'accept') { $saved = groupmemberModel::create($inputdetails); if ($saved) { $invite = invitememberforgroupModel::where('group_id', $groupid)->where('user_id', $userid)->delete(); if ($invite) { $Response = array('success' => '1', 'message' => 'You are Accepted to that Group'); $final = array("response" => $Response); return json_encode($final); } } } else { $invite = invitememberforgroupModel::where('group_id', $groupid)->where('user_id', $userid)->delete(); if ($invite) { $Response = array('success' => '0', 'message' => 'You are Rejected'); $final = array("response" => $Response); return json_encode($final); } } } }