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>