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;
}
}
}
if (Session::has('contest_partipant_id')) {
$contest_partipant_id = Session::get('contest_partipant_id');
} else {
$contest_partipant_id = '';
}
if (Session::has('viewcommentforparticipant')) {
$viewcommentforparticipant = Session::get('viewcommentforparticipant');
}
if (isset($contest_id)) {
$contestdetails = contestModel::where('ID', $contest_id)->first();
$owner_contest = ProfileModel::where('ID', $contestdetails['createdby'])->first();
}
////// New User save the private contest for Share the Contest //////
if ($contestdetails->visibility == 'p') {
$privatecontestmodel = privateusercontestModel::where('user_id', Auth::user()->ID)->where('contest_id', $contest_id)->get()->count();
if ($privatecontestmodel == 0) {
$private_cont['contest_id'] = $contest_id;
$private_cont['user_id'] = Auth::user()->ID;
$private_cont['requesteddate'] = date('Y-m-d H:i:s');
$private_cont['status'] = 1;
privateusercontestModel::create($private_cont);
}
}
$user_id = Auth::user()->ID;
$old_cont_value = contestparticipantModel::where('contest_id', $contest_id)->where('user_id', $user_id)->first();
$old_cont_count = count($old_cont_value);
?>
<div class="tabs-wrapper"> <input type="hidden" class="contest_id" value="{{ $contest_id }}" />
<input type="radio" name="tab" id="tab1" class="tab-head" onclick="showhide_subtab('{{$contest_id}}');" <?php
if ($tab == "contest_info") {
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 invitefollowesforcontest()
{
//invitefollowerforcontestModel
$invite_type = Input::get('invite_type');
$contest_id = Input::get('contest_id');
$curdate = date('Y-m-d h:i:s');
$inpudetails['contest_id'] = $contest_id;
$inpudetails['invitedate'] = $curdate;
$contestdetails = contestModel::select('contest.createdby', 'contest.visibility', 'contest.contest_name', 'contest.contesttype', 'user.firstname', 'user.lastname', 'user.username')->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->where('contest.ID', $contest_id)->get();
$userid = $contestdetails[0]['createdby'];
if ($contestdetails[0]['firstname'] != '') {
$contestcreatedby = $contestdetails[0]['firstname'] . ' ' . $contestdetails[0]['lastname'];
} else {
$contestcreatedby = $contestdetails[0]['username'];
}
$contesttype = $contestdetails[0]['contesttype'];
if ($contesttype == 'p') {
$contesttype = "Photo";
} else {
if ($contesttype == 'v') {
$contesttype = "Video";
} else {
if ($contesttype == 't') {
$contesttype = "Topic";
}
}
}
$contestname = $contestdetails[0]['contest_name'];
//$userid = Input::get('user_id');
if ($invite_type == 'All') {
$invitedlis = invitefollowerforcontestModel::where('contest_id', $contest_id)->lists('follower_id');
$invitedcnt = count($invitedlis);
if ($invitedcnt) {
$uninvitedfollower = followModel::where('userid', Input::get('user_id'))->whereNotIn('id', $invitedlis)->lists('id');
} else {
$uninvitedfollower = followModel::where('userid', Input::get('user_id'))->lists('id');
}
if (count($uninvitedfollower)) {
for ($i = 0; $i < count($uninvitedfollower); $i++) {
$inpudetails['follower_id'] = $uninvitedfollower[$i];
invitefollowerforcontestModel::create($inpudetails);
/******** Here want to set the Notification for Group Members *********/
//return $uninvitedfollower[$i];
$folloerdetails = followModel::select('user.firstname', 'user.lastname', 'user.username', 'user.ID as follower_user_id', 'user.gcm_id', 'user.email')->LeftJoin('user', 'user.ID', '=', 'followers.followerid')->where('followers.id', $uninvitedfollower[$i])->get();
$gcmid = $folloerdetails[0]['gcm_id'];
$email = $folloerdetails[0]['email'];
if ($contestdetails[0]['visibility'] == 'p') {
$privat_user['user_id'] = $folloerdetails[0]['follower_user_id'];
$privat_user['contest_id'] = $contest_id;
$privat_user['requesteddate'] = date('Y-m-d H:i:s');
$privat_user['status'] = 1;
$privatecontestcnt = privateusercontestModel::where('user_id', $folloerdetails[0]['follower_user_id'])->where('contest_id', $contest_id)->get()->count();
if ($privatecontestcnt == 0) {
privateusercontestModel::create($privat_user);
}
}
if ($gcmid != '') {
$Message['user_id'] = $folloerdetails[0]['follower_user_id'];
$Message['title'] = 'Ding Datt';
$Message['message'] = 'You are invited for the Contest :' . $contestdetails[0]['contest_name'];
$Message['contest_id'] = $contest_id;
$Message = array("notification" => $Message);
$DeviceId = array($gcmid);
$Message = array("notification" => $Message);
$this->PushNotification($DeviceId, $Message);
} else {
//$contestcreatedby= User::find($contestdetails[0]['createdby']);
Mail::send([], array('email' => $email, 'contestcreatedby' => $contestcreatedby, 'contesttype' => $contesttype, 'contestname' => $contestname, 'contest_id' => $contest_id), function ($message) use($email, $contestcreatedby, $contesttype, $contestname, $contest_id) {
$mail_body = '<body style="padding:0px;margin:-20px 0 0 0px; font-family: Arial, Helvetica, sans-serif; color: #222222; font-size:12px;">
<div style="width:550px;height:auto; border:1px solid #d5d5d5;padding:0px;margin:0px;overflow:hidden;">
<div style="display:block; margin:25px; overflow:hidden;">
<div style="display:block; padding: 10px; border: 1px solid #e5e5e5; margin:10px 0px;">
<span style="padding:0px;margin:0px;font-weight:bold;">Invitation for join the contest.</span>
</div>
<div style="display: block; margin: 15px;">
<h4 style="padding:0px;margin:0; font-size:14px;color:#d33030;">Contest Details:</h4>
</div>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;"> Contest Name:</span>' . $contestname . '</p>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Contest Type:</span>' . $contesttype . '</p>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Created by:</span>' . $contestcreatedby . '</p>
<p style="margin-top:25px; font-size:11px; color: #999999; margin-left:15px;">This is auto generate email so please do not reply to this email.</p>
<p style="margin-top:25px; font-size:11px; color: #999999; margin-left:15px;"><a href="' . URL::to('contest_info/' . $contest_id) . '" style="dislay:block;outline: none; padding:25px;margin:25px; min-height:110px; width:100%; overflow:hidden;">' . URL::to('contest_info/' . $contest_id) . '</a> </p>
<div style="padding:0; margin:15px;">
<p style="padding:0px; font-weight: bold;">Thanks,</p>
DingDatt</div>
<a href="' . URL::to('contest_info/' . $contest_id) . '" style="dislay:block;outline: none; padding:25px;margin:25px; min-height:110px; width:100%; overflow:hidden;">
<img src="' . URL::to('assets/inner/img/DingDatt_logo_web1.png') . '" width="110" height="86" style="width:110px; padding:0px; margin:0px;" alt="DingDatt"/>
</a>
</div>
<div style="height:25px; width:100%;"> </div>
</div>
</body>';
$message->setBody($mail_body, 'text/html');
$message->to($email);
$message->subject('Dingdatt-Invitation for join the contest');
});
}
}
$Response = array('success' => '1', 'message' => 'Invited Successfully');
$final = array("response" => $Response);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => 'Already Invited All Followers');
$final = array("response" => $Response);
return json_encode($final);
}
} else {
$user_id = Input::get('user_id');
$follower_id = Input::get('follower_id');
$inpudetails['follower_id'] = $follower_id;
invitefollowerforcontestModel::create($inpudetails);
/******** Here want to set the Notification for Group Members *********/
$groupmemberlist = followModel::select('id')->where('userid', $user_id)->where('followerid', $follower_id)->get();
//return $groupmemberlist[0]['id'];
///
$folloerdetails = followModel::select('user.firstname', 'user.lastname', 'user.username', 'user.ID as follower_user_id', 'user.gcm_id', 'user.email')->LeftJoin('user', 'user.ID', '=', 'followers.followerid')->where('followers.id', $groupmemberlist[0]['id'])->get();
$gcmid = $folloerdetails[0]['gcm_id'];
$email = $folloerdetails[0]['email'];
if ($contestdetails[0]['visibility'] == 'p') {
$privat_user['user_id'] = $folloerdetails[0]['follower_user_id'];
$privat_user['contest_id'] = $contest_id;
$privat_user['requesteddate'] = date('Y-m-d H:i:s');
$privat_user['status'] = 1;
$privatecontestcnt = privateusercontestModel::where('user_id', $folloerdetails[0]['follower_user_id'])->where('contest_id', $contest_id)->get()->count();
if ($privatecontestcnt == 0) {
privateusercontestModel::create($privat_user);
}
}
if ($gcmid != '') {
$Message['user_id'] = $folloerdetails[0]['follower_user_id'];
$Message['title'] = 'Ding Datt';
$Message['message'] = 'You are invited for the Contest :' . $contestdetails[0]['contest_name'];
$Message['contest_id'] = $contest_id;
$Message = array("notification" => $Message);
$DeviceId = array($gcmid);
$Message = array("notification" => $Message);
$this->PushNotification($DeviceId, $Message);
} else {
//$contestcreatedby= User::find($contestdetails[0]['createdby']);
Mail::send([], array('email' => $email, 'contestcreatedby' => $contestcreatedby, 'contesttype' => $contesttype, 'contestname' => $contestname, 'contest_id' => $contest_id), function ($message) use($email, $contestcreatedby, $contesttype, $contestname, $contest_id) {
$mail_body = '<body style="padding:0px;margin:-20px 0 0 0px; font-family: Arial, Helvetica, sans-serif; color: #222222; font-size:12px;">
<div style="width:550px;height:auto; border:1px solid #d5d5d5;padding:0px;margin:0px;overflow:hidden;">
<div style="display:block; margin:25px; overflow:hidden;">
<div style="display:block; padding: 10px; border: 1px solid #e5e5e5; margin:10px 0px;">
<span style="padding:0px;margin:0px;font-weight:bold;">Invitation for join the contest.</span>
</div>
<div style="display: block; margin: 15px;">
<h4 style="padding:0px;margin:0; font-size:14px;color:#d33030;">Contest Details:</h4>
</div>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;"> Contest Name:</span>' . $contestname . '</p>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Contest Type:</span>' . $contesttype . '</p>
<p style="margin:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Created by:</span>' . $contestcreatedby . '</p>
<p style="margin-top:25px; font-size:11px; color: #999999; margin-left:15px;">This is auto generate email so please do not reply to this email.</p>
<p style="margin-top:25px; font-size:11px; color: #999999; margin-left:15px;"><a href="' . URL::to('contest_info/' . $contest_id) . '" style="dislay:block;outline: none; padding:25px;margin:25px; min-height:110px; width:100%; overflow:hidden;">' . URL::to('contest_info/' . $contest_id) . '</a> </p>
<div style="padding:0; margin:15px;">
<p style="padding:0px; font-weight: bold;">Thanks,</p>
DingDatt</div>
<a href="' . URL::to('contest_info/' . $contest_id) . '" style="dislay:block;outline: none; padding:25px;margin:25px; min-height:110px; width:100%; overflow:hidden;">
<img src="' . URL::to('assets/inner/img/DingDatt_logo_web1.png') . '" width="110" height="86" style="width:110px; padding:0px; margin:0px;" alt="DingDatt"/>
</a>
</div>
<div style="height:25px; width:100%;"> </div>
</div>
</body>';
$message->setBody($mail_body, 'text/html');
$message->to($email);
$message->subject('Dingdatt-Invitation for join the contest');
});
}
////
$Response = array('success' => '1', 'message' => 'Invited Successfully');
$final = array("response" => $Response);
return json_encode($final);
}
}