public function contestdelete()
{
$data = Input::get('contestid');
$searchkey = Input::get('searchkey');
/// Contest details /////
$contestdetailsformail = contestModel::select('user.firstname', 'user.lastname', 'user.username', 'contest.contest_name', 'contest.contesttype', 'user.email', 'contest.themephoto')->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->where('contest.ID', $data)->first();
$contestname = $contestdetailsformail->contest_name;
$contesttype = $contestdetailsformail->contesttype;
if ($contestdetailsformail->firstname != '') {
$name = $contestdetailsformail->firstname . ' ' . $contestdetailsformail->lastname;
} else {
$name = $contestdetailsformail->username;
}
$contest_id = $data;
$email = $contestdetailsformail->email;
$details = "Your contest " . $contestname . " is deleted by admin.";
$contestimage = $contestdetailsformail->themephoto;
$contestdetails = contestparticipantModel::where('contest_id', $data)->get();
for ($i = 0; $i < count($contestdetails); $i++) {
$contestparticipantid = $contestdetails[$i]['ID'];
$comment = commentModel::select('id')->where('contest_participant_id', $contestparticipantid)->get();
for ($i = 0; $i < count($comment); $i++) {
$replycmt = replycommentModel::where('comment_id', $comment[$i]['id'])->get()->count();
if ($replycmt) {
replycommentModel::where('comment_id', $comment[$i]['id'])->delete();
}
}
if (count($comment)) {
commentModel::select('id')->where('contest_participant_id', $contestparticipantid)->delete();
}
$votingcnt = votingModel::where('contest_participant_id', $contestparticipantid)->get()->count();
if ($votingcnt) {
votingModel::where('contest_participant_id', $contestparticipantid)->delete();
}
$participantid = contestparticipantModel::where('ID', $contestparticipantid)->get()->count();
if ($participantid) {
$delete = contestparticipantModel::where('ID', $contestparticipantid)->delete();
}
}
$contestcatgory = contestinterestModel::where('contest_id', $data)->count();
if ($contestcatgory) {
contestinterestModel::where('contest_id', $data)->delete();
}
$deleteinvitecontest = invitegroupforcontestModel::where('contest_id', $data)->count();
if ($deleteinvitecontest) {
invitegroupforcontestModel::where('contest_id', $data)->delete();
}
$deletefollowercontest = invitefollowerforcontestModel::where('contest_id', $data)->count();
if ($deletefollowercontest) {
invitefollowerforcontestModel::where('contest_id', $data)->delete();
}
$privatecontestdelete = privateusercontestModel::where('contest_id', $data)->count();
if ($privatecontestdelete) {
privateusercontestModel::where('contest_id', $data)->delete();
}
$deletecontest = contestModel::where('ID', $data)->delete();
if ($deletecontest) {
$this->contestchangesmaildelete($email, $name, $contestname, $contest_id, $contestimage, $details);
}
$er_data['message'] = 'Contest removed successfully';
return Redirect::to('managecontest')->with('er_data', $er_data)->with('usercontestlist', '')->with('searchkey', $searchkey);
}
public function uninvite_allfollower()
{
$contest_id = $_GET['contest_id'];
$follower_ids = Input::get("follower_list");
$follower_ids = explode(',', $follower_ids);
$followercount = count($follower_ids);
if ($followercount > 0) {
for ($i = 0; $i < $followercount; $i++) {
$invited = invitefollowerforcontestModel::where('follower_id', $follower_ids[$i])->where('contest_id', $contest_id)->count();
if ($invited == 1) {
invitefollowerforcontestModel::where('follower_id', $follower_ids[$i])->where('contest_id', $contest_id)->delete();
$invited_member = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $follower_ids[$i])->count();
if ($invited_member) {
privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $follower_ids[$i])->delete();
}
}
}
return 1;
} else {
return 0;
}
}
<tr>
<th style="background-color:#0896D6"><input name="" class="checkallfollowers" style="visibility:hidden;" type="checkbox" value="1"></th>
<th><span class="txt_img">Image</span></th>
<th><span class="txt_followername">Follower 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
$cur_user = Auth::user()->ID;
$followerlist = followModel::where('followerid', $cur_user)->select('userid', 'followerid', 'user.profilepicture as profilepicture', 'user.firstname as firstname', 'user.lastname as lastname', 'user.username')->leftJoin('user', 'followers.userid', '=', 'user.ID')->where('user.status', 1)->get();
$followercount = count($followerlist);
for ($i = 0; $i < $followercount; $i++) {
$invited = invitefollowerforcontestModel::where('follower_id', $followerlist[$i]['userid'])->where('contest_id', $contest_id)->count();
?>
<tr>
<td class="tr_wid_id"><input name="follower_list[]" class="checkfollowerlist" type="checkbox" value="{{ $followerlist[$i]['userid'] }}" <?php
if ($invited > 0) {
echo "checked";
}
?>
></td>
<td align="center"><img src="{{ ($followerlist[$i]['profilepicture']!='')?(URL::to('public/assets/upload/profile/'.$followerlist[$i]['profilepicture'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td><?php
if ($followerlist[$i]['firstname'] != '') {
echo $followerlist[$i]['firstname'] . " " . $followerlist[$i]['lastname'];
} else {
echo $followerlist[$i]['username'];
}
public function uninvitefollowerforcontest()
{
$contest_id = Input::get('contest_id');
$followerid = Input::get('follower_id');
$invited = invitefollowerforcontestModel::where('follower_id', $followerid)->where('contest_id', $contest_id)->count();
if ($invited == 1) {
invitefollowerforcontestModel::where('follower_id', $followerid)->where('contest_id', $contest_id)->delete();
$invited_member = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $followerid)->count();
if ($invited_member) {
privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $followerid)->delete();
}
$Response = array('success' => '1', 'message' => 'Uninvited successfully', 'msgcode' => "c198");
$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);
}
}
public function getfollowerlistforinvitecontest()
{
$contest_id = Input::get('contest_id');
$userid = contestModel::select('createdby')->where('ID', $contest_id)->get();
$userid = $userid[0]['createdby'];
$followers = followModel::where('userid', $userid)->select('followers.id as followerprimaryid', 'user.profilepicture', 'user.firstname', 'user.ID as followerid')->leftJoin('user', 'user.ID', '=', 'followers.followerid')->get();
for ($k = 0; $k < count($followers); $k++) {
$invitecnt = invitefollowerforcontestModel::where('follower_id', $followers[$k]['followerprimaryid'])->where('contest_id', $contest_id)->get()->count();
$followers[$k]['invite'] = $invitecnt;
}
$Response = array('success' => '1', 'message' => 'Followers List');
$final = array("response" => $Response, "followerlist" => $followers);
return json_encode($final);
}
