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 putfollow($data = Null)
{
//return $data;
$followerid = $_GET['followerid'];
$contest_id = $_GET['contest_id'];
$participant_id = $_GET['participant_id'];
$authusrid = Auth::user()->ID;
$curdate = date('Y-m-d h:i:s');
$inputdetails['followerid'] = $followerid;
$inputdetails['userid'] = $authusrid;
$inputdetails['createddate'] = $curdate;
$followers = followModel::create($inputdetails);
if ($followers) {
////// Send Mail /////////
$followedetails = user::find($followerid);
$email = $followedetails['email'];
if (Auth::user()->firstname != '') {
$username = Auth::user()->firstname . ' ' . Auth::user()->lastname;
} else {
$username = Auth::user()->username;
}
if ($followedetails['firstname'] != '') {
$followingusername = $followedetails['firstname'] . ' ' . $followedetails['lastname'];
} else {
$followingusername = $followedetails['username'];
}
//$email ='*****@*****.**';
Mail::send([], array('followingusername' => $followingusername, 'email' => $email, 'username' => $username), function ($message) use($followingusername, $email, $username) {
$mail_body = '<style>.thank{text-align:center; width:100%;}
.but_color{color:#ffffff;}
.cont_name{width:100px;}
.cont_value{width:500px;}
</style>
<body style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif; margin:0px auto; padding:0px;">
<div style="margin:0px auto;background:#e5e5e5;float:left; width:98%; height:30px;margin:0px 1%; border-bottom:#005377 1px solid;vertical-align: text-middle;">
<a href="' . URL() . '"><img src="' . URL::to('assets/images/logo.png') . '" style="margin-top:3px; line-height:20px;" /></a>
</div>
<div style="background:#ffffff;float:left;padding:10px 20px;margin:1px 1%;" >
<div class="thank" style="font-size:16px;color: #078AC2;font-weight:bold;float:left;width:100%;margin-top:10px;text-align:left;">Dear ' . $followingusername . '</div>
<div style="font-size:12px; color: #000000; float:left;padding:10px 2px;width:100%;margin:15px;">The Member ' . $username . ' is following you.
</div>
<div style="margin:10px;"><a href="' . URL() . '"><img src="' . URL::to('assets/inner/images/vist_dingdatt.png') . '" width="120" height="30" /></a>
</div>
</div>
<div style="font-size:12px; margin-top:10px;color: #5b5b5b;/* background:#e5e5e5;*/width:95%;vertical-align: text-middle;height:30px;margin:0% 1%;padding:0px 15px; border-top:#005377 1px solid; border-bottom:5px solid background:#e5e5e5;line-height:25px; ">
</body>';
$message->setBody($mail_body, 'text/html');
$message->to($email);
$message->subject('Follower details - DingDatt');
});
//return $participant_id;
$contestparticipantname = contestparticipantModel::select('user.firstname', 'user.lastname', 'user.username')->where('contestparticipant.ID', $participant_id)->LeftJoin('user', 'user.ID', '=', 'user_id')->get();
if ($contestparticipantname[0]['firstname'] != '') {
$follwusrname = $contestparticipantname[0]['firstname'] . ' ' . $contestparticipantname[0]['lastname'];
} else {
$follwusrname = $contestparticipantname[0]['username'];
}
return Redirect::to("contest_info/" . $contest_id)->with('tab', 'gallery')->with('gallerytype', 'comment')->with('viewcommentforparticipant', $participant_id)->with('Massage', 'You are following ' . $follwusrname);
}
}
echo "Photo";
} elseif ($contestname->contesttype == 'v') {
echo "Video";
} else {
echo "Topic";
}
?>
</th>
<th class="tr_wid_button1" align="center"><span class="txt_view">View</span></th>
<th class="tr_wid_edit"><span class="txt_delete">Delete<span></th>
</tr>
</thead>
<tbody>
<?php
if ($contest_id != '') {
$participantlist = contestparticipantModel::select('contestparticipant.ID', 'user.firstname', 'user.lastname', 'user.username', 'user.profilepicture', 'contestparticipant.dropbox_path', 'contestparticipant.uploadfile', 'contestparticipant.uploadtopic')->LeftJoin('user', 'user.ID', '=', 'contestparticipant.user_id')->where('contestparticipant.contest_id', $contest_id)->get();
for ($i = 0; $i < count($participantlist); $i++) {
if ($participantlist[$i]['firstname'] != '') {
$name = $participantlist[$i]['firstname'] . ' ' . $participantlist[$i]['lastname'];
} else {
$name = $participantlist[$i]['username'];
}
?>
<tr>
<td>{{ $i+1; }} </td>
<td class="tr_wid_id">{{ $name }}</td>
<td ><?php
if ($contestname->contesttype == 'p') {
?>
<img src="<?php
echo url() . '/public/assets/upload/contest_participant_photo/' . $participantlist[$i]['uploadfile'];
function reportflag()
{
$reporteddata = Input::get('reporteddata');
$participantid = Input::get('participantid');
$authuserid = Input::get('user_id');
$inputdetails['contest_participant_id'] = $participantid;
$inputdetails['report_description'] = $reporteddata;
$inputdetails['report_userid'] = $authuserid;
$participant_details = contestparticipantModel::select('user_id', 'contest_id')->where('ID', $participantid)->first();
$inputdetails['postedby_userid'] = $participant_details['user_id'];
$inputdetails['contest_id'] = $participant_details['contest_id'];
$inputdetails['createddate'] = date('Y-m-d h:i:s');
//reportflagModel::where()
//return $inputdetails;
$validation = Validator::make($inputdetails, reportflagModel::$rules);
if ($validation->passes()) {
$created = reportflagModel::create($inputdetails);
//if($created) return 1;
$Response = array('success' => '1', 'message' => 'You are reported successfully', 'msgcode' => "c194");
$final = array("response" => $Response);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => $validation->messages(), 'msgcode' => "c195");
$final = array("response" => $Response);
return json_encode($final);
}
}
}
}
?>
</th>
<th><span class="txt_contestantname">Contestant Name</span></th>
<th><span class="txt_noofvotes">No of Dings</span></th>
<th><span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($leaderboarddata); $i++) {
// $leaderboarddata[$i]['leaderusrid'];
$participantcnt = contestparticipantModel::where('user_id', $leaderboarddata[$i]['leaderusrid'])->get()->count();
if ($participantcnt != 0) {
$contestparticipatedimg = contestparticipantModel::select('uploadfile', 'uploadtopic', 'dropbox_path')->where('contest_id', $contest_id)->where('user_id', $leaderboarddata[$i]['leaderusrid'])->first();
?>
<tr>
<td>{{ $leaderboarddata[$i]['position'] }}</td>
<td align="center">
<?php
if ($contestdetails[0]['contesttype'] == 'p') {
?>
<img src="<?php
echo url() . '/public/assets/upload/contest_participant_photo/' . $contestparticipatedimg->uploadfile;
?>
" width="50" height="50">
<?php
} else {
if ($contestdetails[0]['contesttype'] == 'v') {
?>
function report()
{
$reporteddata = Input::get('reporteddata');
$participantid = Input::get('participantid');
$authuserid = Auth::user()->ID;
$description = Input::get('');
$participant_details = contestparticipantModel::select('user_id', 'contest_id')->where('ID', $participantid)->first();
$inputdetails['contest_participant_id'] = $participantid;
$inputdetails['report_description'] = $reporteddata;
$inputdetails['report_userid'] = $authuserid;
$inputdetails['postedby_userid'] = $participant_details['user_id'];
$inputdetails['contest_id'] = $participant_details['contest_id'];
$inputdetails['createddate'] = date('Y-m-d h:i:s');
//reportflagModel::where()
$validation = Validator::make($inputdetails, reportflagModel::$rules);
if ($validation->passes()) {
$created = reportflagModel::create($inputdetails);
if ($created) {
return 1;
}
}
}
public function getcontestlistmobile()
{
$inputdetails = Input::except(array('_token'));
$contestlisttype = Input::get('contestlisttype');
$contesttype = Input::get('contesttype');
$loggeduserid = Input::get('loggeduserid');
$currentdate = Carbon::now();
$timezone = Input::get('timezone');
if ($contestlisttype == 'current') {
$contestDetailscount = contestModel::where(function ($query) {
$query->where(function ($query) {
$currentdate = date('Y-m-d H:i:s');
$query->where('conteststartdate', '<=', $currentdate);
$query->where('contestenddate', '>=', $currentdate);
});
$query->orWhere(function ($query) {
$currentdate = date('Y-m-d H:i:s');
$query->where('votingstartdate', '<=', $currentdate);
$query->where('votingenddate', '>=', $currentdate);
});
})->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->get()->count();
$contestDetails = contestModel::where(function ($query) {
$query->where(function ($query) {
$currentdate = date('Y-m-d H:i:s');
$query->where('conteststartdate', '<=', $currentdate);
$query->where('contestenddate', '>=', $currentdate);
});
$query->orWhere(function ($query) {
$currentdate = date('Y-m-d H:i:s');
$query->where('votingstartdate', '<=', $currentdate);
$query->where('votingenddate', '>=', $currentdate);
});
})->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->get();
} else {
if ($contestlisttype == 'upcoming') {
/*$contestDetailscount = contestModel::where('conteststartdate', '>', $currentdate)->where('contesttype',$contesttype)->where('status','1')->where('visibility','u')->get()->count();
$contestDetails = contestModel::where('conteststartdate', '>', $currentdate)->where('contesttype',$contesttype)->where('status','1')->where('visibility','u')->get(); */
$contestDetailscount = contestModel::where('conteststartdate', '>', $currentdate)->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->get()->count();
$contestDetails = contestModel::where('conteststartdate', '>', $currentdate)->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->get();
} else {
if ($contestlisttype == 'archive') {
$contestDetailscount = contestModel::where('contestenddate', '<', $currentdate)->where('votingenddate', '<', $currentdate)->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')->get()->count();
$contestDetails = contestModel::where('contestenddate', '<', $currentdate)->select('contest.*', 'contestparticipant.ID as contestparticipantid')->where('votingenddate', '<', $currentdate)->where('contesttype', $contesttype)->where('status', '1')->where('visibility', 'u')->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')->get();
/*$contestDetailscount=contestModel::where('contestenddate', '<', $currentdate)
->where('votingenddate', '<', $currentdate)
->where('contesttype',$contesttype)
->where('status','1')
->where('visibility','u')
->get()->count();
$contestDetails=contestModel::where('contestenddate', '<', $currentdate)
->where('votingenddate', '<', $currentdate)
->where('contesttype',$contesttype)
->where('status','1')
->where('visibility','u')
->get();
*/
} else {
if ($contestlisttype == 'private') {
/* $contestDetailscount = contestModel::where('visibility','p')
->select('contest.ID','contest_name','description','noofparticipant','contestparticipant.ID as contestparticipantid')
->leftJoin('private_contest_users', 'private_contest_users.contest_id', '=', 'contest.ID')
->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')
->where('private_contest_users.user_id',$loggeduserid)
->get()->count();
$contestDetails = contestModel::where('visibility','p')
->select('contest.ID','contest_name','description','noofparticipant','contestparticipant.ID as contestparticipantid')
->leftJoin('private_contest_users', 'private_contest_users.contest_id', '=', 'contest.ID')
->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')
->where('private_contest_users.user_id',$loggeduserid)
->get();
*/
$contestDetailscount = contestModel::where('visibility', 'p')->where('contesttype', $contesttype)->select('contest.ID', 'contest_name', 'themephoto', 'description', 'noofparticipant', 'contest.prize', 'contest.conteststartdate', 'contest.contestenddate', 'contest.votingstartdate', 'contest.votingenddate', 'contest.createdby')->leftJoin('private_contest_users', 'private_contest_users.contest_id', '=', 'contest.ID')->where('private_contest_users.user_id', $loggeduserid)->where('private_contest_users.status', '1')->distinct()->get()->count();
$contestDetails = contestModel::where('visibility', 'p')->where('contesttype', $contesttype)->select('contest.ID', 'contest_name', 'themephoto', 'description', 'noofparticipant', 'contest.prize', 'contest.conteststartdate', 'contest.contestenddate', 'contest.votingstartdate', 'contest.votingenddate', 'contest.createdby')->leftJoin('private_contest_users', 'private_contest_users.contest_id', '=', 'contest.ID')->where('private_contest_users.user_id', $loggeduserid)->where('private_contest_users.status', '1')->distinct()->get();
/* $contestDetailscount = contestModel::where('visibility','p')
->select('contest.ID','contest_name','description','noofparticipant')
->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')
->where('contestparticipant.user_id',$loggeduserid)
->get()->count();
$contestDetails = contestModel::where('visibility','p')
->leftJoin('contestparticipant', 'contestparticipant.contest_id', '=', 'contest.ID')
->select('contest.ID','contest_name','description','noofparticipant')
->where('contestparticipant.user_id',$loggeduserid)
->get(); */
//$languageDetailscount = contestparticipantModel::where('ID',$loggeduserid)->get();
}
}
}
}
if ($contestDetailscount) {
for ($i = 0; $i < count($contestDetails); $i++) {
$participant = contestparticipantModel::select('ID')->where('contest_id', $contestDetails[$i]->ID)->where('user_id', $loggeduserid)->get()->count();
if ($participant != '') {
$contestDetails[$i]->contestparticipantid = 1;
} else {
$contestDetails[$i]->contestparticipantid = 0;
}
$contestDetails[$i]->conteststartdate = timezoneModel::convert($contestDetails[$i]->conteststartdate, 'UTC', $timezone, 'd-M-Y h:i a');
$contestDetails[$i]->contestenddate = timezoneModel::convert($contestDetails[$i]->contestenddate, 'UTC', $timezone, 'd-M-Y h:i a');
$contestDetails[$i]->votingstartdate = timezoneModel::convert($contestDetails[$i]->votingstartdate, 'UTC', $timezone, 'd-M-Y h:i a');
$contestDetails[$i]->votingenddate = timezoneModel::convert($contestDetails[$i]->votingenddate, 'UTC', $timezone, 'd-M-Y h:i a');
$contestDetails[$i]->createddate = timezoneModel::convert($contestDetails[$i]->createddate, 'UTC', $timezone, 'd-M-Y h:i a');
//themephoto
}
//return $contestDetails;
$Response = array('success' => '1', 'message' => 'Data Get Successfully');
$final = array("response" => $Response, 'contestdetails' => $contestDetails);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => 'No Data Available');
$final = array("response" => $Response);
return json_encode($final);
}
}
<div class="clrscr"></div>
<div class="loginbox">
</div>
</form>
</div>
</div>
<div id="tab-body-2" class="tab-body">
<div id="p">
<div class="clrscr"></div>
<div class="crsl-items_p" data-navigation="navbtns">
<div class="crsl-wrap">
<?php
$curdate = date('Y-m-d H:i:s');
$myhistory = contestparticipantModel::select('contest.contest_name', 'contestparticipant.contest_id', 'contestparticipant.uploadfile', 'contestparticipant.uploadtopic', 'contest.contesttype', 'contestparticipant.dropbox_path')->where('contestparticipant.user_id', $profileid)->LeftJoin('contest', 'contest.ID', '=', 'contestparticipant.contest_id')->where('contest.votingenddate', '<', $curdate)->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->get();
for ($i = 0; $i < count($myhistory); $i++) {
$leaderboard = leaderboardModel::select('position')->where('contest_id', $myhistory[$i]['contest_id'])->where('user_id', $profileid)->get();
?>
<div class="crsl-item">
<div class="thumbnail">
<?php
if ($myhistory[$i]['contesttype'] == 'p') {
?>
<img src="<?php
echo url() . '/public/assets/upload/contest_participant_photo/' . $myhistory[$i]['uploadfile'];
?>
" alt="danny antonucci"> <?php
} elseif ($myhistory[$i]['contesttype'] == 'v') {
