public function regenerateleaderboard()
{
$contestid = Input::get('contestid');
if ($contestid) {
$iputdetails['leaderboard'] = 0;
$leaderboard = contestModel::where('ID', $contestid)->update($iputdetails);
$leaderboardcnt = leaderboardModel::where('contest_id', $contestid)->get()->count();
if ($leaderboardcnt > 0) {
leaderboardModel::where('contest_id', $contestid)->delete();
}
return 1;
}
}
public function viewprofile()
{
$userid = Input::get('userid');
$myuserid = Input::get('myuserid');
$followingcount = followModel::where('userid', $userid)->get()->count();
$followerscount = followModel::where('followerid', $userid)->get()->count();
$participatedcount = contestparticipantModel::where('user_id', $userid)->get()->count();
$woncount = leaderboardModel::where('user_id', $userid)->get()->count();
$userdetails = User::select('firstname', 'lastname', 'username', 'profilepicture')->where('ID', $userid)->first();
$return['following'] = $followingcount;
$return['followers'] = $followerscount;
$return['participated'] = $participatedcount;
$return['won'] = $woncount;
if ($userdetails->firstname != '') {
$return['name'] = $userdetails->firstname . ' ' . $userdetails->lastname;
} else {
$return['name'] = $userdetails->username;
}
$return['profilepicture'] = url() . '/public/assets/upload/profile/' . $userdetails->profilepicture;
$Response = array('success' => '1', 'message' => 'My Profile Details', 'msgcode' => "c138");
if ($myuserid != '') {
$follow = followModel::where('userid', $myuserid)->where('followerid', $userid)->get()->count();
if ($follow) {
$follow1 = 1;
} else {
$follow1 = 0;
}
//return $follow1;
$final = array("response" => $Response, 'viewmyprofile' => $return, 'follow' => $follow1);
} else {
$final = array("response" => $Response, 'viewmyprofile' => $return);
}
return json_encode($final);
}
public function viewprofile()
{
$userid = Input::get('userid');
$followingcount = followModel::where('userid', $userid)->get()->count();
$followerscount = followModel::where('followerid', $userid)->get()->count();
$participatedcount = contestparticipantModel::where('user_id', $userid)->get()->count();
$woncount = leaderboardModel::where('user_id', $userid)->get()->count();
$return['following'] = $followingcount;
$return['followers'] = $followerscount;
$return['participated'] = $participatedcount;
$return['won'] = $woncount;
$Response = array('success' => '1', 'message' => 'My Profile Details');
$final = array("response" => $Response, 'viewmyprofile' => $return);
return json_encode($final);
}
<div class="vstart"><strong><span class="votingstart"> Voting start Date:</span> </strong><div class="mb_brk"></div><span class="mleft">{{ (timezoneModel::convert($contestdetails[0]['votingstartdate'],'UTC',Auth::user()->timezone, 'd-M-Y h:i a')) }} </span></div>
<div class="vend"><strong><span class="votingend"> Voting End Date:</span> </strong><div class="mb_brk"></div><span class="mleft">{{ (timezoneModel::convert($contestdetails[0]['votingenddate'],'UTC',Auth::user()->timezone, 'd-M-Y h:i a')) }} </span></div>
<!--<div class="prize"><strong><span class="txt_prize"> Prize: </span></strong><div class="mb_brk"></div><span class="mleft">{{ $contestdetails[0]['prize']}}</span></div>-->
<div class="noparty"><strong><span class="txt_noofparticipant">No. of Participants: </span> </strong><div class="mb_brk"></div><span class="mleft">{{ ($contestdetails[0]['noofparticipant']==0)?"Unlimited":$contestdetails[0]['noofparticipant']; }} </span></div>
</div>
</div>
<h1>{{ $contestdetails[0]['contest_name']}} - Leader Board</h1>
<div class="cont_det_con">
<div class="cont_des_con">
</div>
<div class="clearfix"></div>
<?php
$leaderboarddata = leaderboardModel::select('user.ID as userid', 'user.username', 'user.firstname', 'user.lastname', 'user.profilepicture', 'leaderboard.votes', 'leaderboard.user_id as leaderusrid', 'leaderboard.position')->LeftJoin('user', 'user.ID', '=', 'leaderboard.user_id')->where('contest_id', $contest_id)->orderby('position')->take(20)->get();
if (count($leaderboarddata) == 0) {
echo "<div class='centertext'>Leader Board will be generated Soon.....</div>";
} else {
?>
<table class="display" cellspacing="0" width="100%" id="dd_leader_board">
<thead>
<tr>
<th><span class="txt_rank">Rank</span></th>
<th><?php
if ($contestdetails[0]['contesttype'] == 'p') {
?>
<span class="txt_img">Image</span><?php
} else {
<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') {
?>
<video width="125" height="125" controls>
