public function usersearch($data = Null)
{
$inputs = Input::get();
$groupmemberid = groupmemberModel::where('group_id', $data)->get()->lists('user_id');
$groupmemberuserid = ProfileModel::whereNotIn('user.ID', $groupmemberid)->lists('ID');
$searcheduser = Input::get('usersearch');
$groupmemberuseridlist = ProfileModel::select('profilepicture', 'firstname', 'lastname', 'username', 'ID')->where('username', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->Orwhere('firstname', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->where('user.status', 1)->get();
return View::make('user/view/registermember')->with('group_id', $data)->with('searcheduser', $searcheduser)->with('savegroupmembers', $groupmemberuseridlist);
}
public function other_profile($data = Null)
{
$memberlist = groupmemberModel::where('user_id', $data)->distinct()->lists('group_id');
return View::make('user/profile/otherprofile')->with('profileid', $data)->with('memberlist', $memberlist);
}
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);
}
$user_id = Auth::user()->ID;
if (Auth::user()->ID == 1) {
if ($searchedgroup == '') {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->get();
} else {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->where('groupname', 'like', '%' . $searchedgroup . '%')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->get();
}
} else {
if ($searchedgroup == '') {
$group = groupmemberModel::select('group_members.group_id', 'group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->leftJoin('group', 'group.ID', '=', 'group_members.group_id')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->where('group_members.user_id', $user_id)->get();
} else {
$group = groupModel::select('group.groupname', 'group.grouptype', 'group.createdby', 'user.firstname', 'user.lastname', 'user.username', 'group.groupimage', 'group.createdby as groupcreateuserid', 'group.ID as groupid', 'group.status')->where('groupname', 'like', '%' . $searchedgroup . '%')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->get();
}
}
for ($i = 0; $i < count($group); $i++) {
$groupmembercnt = groupmemberModel::where('group_id', $group[$i]['groupid'])->get()->count();
?>
<tr>
<td>{{ $i+1; }} </td>
<td class="tr_wid_id">{{ $group[$i]['groupname'] }}</td>
<td align="center"><img src=" {{ ($group[$i]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$group[$i]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td>{{ $group[$i]['grouptype'] }}</td>
<td><?php
if ($group[$i]['firstname'] != '') {
echo $group[$i]['firstname'] . ' ' . $group[$i]['lastname'];
} else {
echo $group[$i]['username'];
}
?>
</td>
<?php
public function ajaxaccepgroup()
{
$invitetype = explode(',', $_GET['invite']);
$groupid = explode(',', $_GET['group_id']);
$user_id = explode(',', $_GET['user_id']);
count($invitetype);
for ($i = 0; $i < count($invitetype); $i++) {
$curdate = date('Y-m-d h:i:s');
$inputdetails['invitetype'] = $invitetype[$i];
$inputdetails['group_id'] = $groupid[$i];
$inputdetails['createddate'] = $curdate;
$inputdetails['user_id'] = $user_id[$i];
$verify = groupmemberModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->get()->count();
if ($verify) {
$datareturn = "You are Already Member of this group";
$delete = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->delete();
} else {
$savegroupmembers = groupmemberModel::create($inputdetails);
$delete = invitememberforgroupModel::where('group_id', $groupid[$i])->where('user_id', $user_id[$i])->delete();
if ($savegroupmembers && $delete) {
$datareturn = "Member accepted successfully";
}
}
}
return $datareturn;
}
function uninvitegroupmemberforcontest()
{
$groupmemberlist = Input::get('groupmemberid');
$group_id = Input::get('group_id');
$contest_id = Input::get('contest_id');
$groupmemberlistid = explode(',', $groupmemberlist);
$inv_suc_message = 0;
for ($i = 0; $i < count($groupmemberlistid); $i++) {
$groupmemberid = groupmemberModel::where('id', $groupmemberlistid[$i])->get()->first();
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $groupmemberid->user_id)->count();
if ($invited != 0) {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $groupmemberid->user_id)->delete();
$invited_member = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $groupmemberid->user_id)->count();
if ($invited_member) {
$contestdetails = contestModel::where('ID', $contest_id)->get()->first();
if ($contestdetails['createdby'] != $groupmemberid->user_id) {
$invited_memberdelete = privateusercontestModel::where("contest_id", $contest_id)->where('user_id', $groupmemberid->user_id)->delete();
}
}
$inv_suc_message = 1;
} else {
$inv_suc_message = 2;
}
}
if ($inv_suc_message == 1) {
$Response = array('success' => '1', 'message' => 'Uninvited successfully', 'msgcode' => "c198");
$final = array("response" => $Response);
return json_encode($final);
} else {
if ($inv_suc_message == 2) {
$Response = array('success' => '0', 'message' => 'You are not invited.So cant able to uninvite', 'msgcode' => "c201");
$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);
}
}
}
<th style="background-color:#0896D6"><input name="" class="checkallgroups" type="checkbox" value="1" style="visibility:hidden;"></th>
<th><span class="txt_img">Image</span></th>
<th><span class="txt_groupname">Group 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
$grouplist = groupModel::select('group.ID as groupid', 'groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage')->LeftJoin('group_members', 'group_members.group_id', '=', 'group.ID')->Leftjoin('user', 'user.ID', '=', 'group_members.group_id')->where('group_members.user_id', Auth::user()->ID)->where('group.status', 1)->get();
$groupcount = count($grouplist);
for ($i = 0; $i < $groupcount; $i++) {
$invited = invitegroupforcontestModel::where('group_id', $grouplist[$i]['groupid'])->where('contest_id', $contest_id)->count();
$groupmemberlist = groupmemberModel::where('group_id', $grouplist[$i]['groupid'])->get()->count();
$groupmemberlist_admin = groupmemberModel::where('group_id', $grouplist[$i]['groupid'])->where('user_id', 1)->get()->count();
?>
<tr class="clickforrowselect" <?php
/* onClick="aa(<?php echo $i; ?>)" */
?>
id="clickforrowselect_<?php
echo $i;
?>
">
<td class="tr_wid_id"><input name="group_list" id="checkgrouplist_<?php
echo $i;
?>
" class="checkgrouplist" type="checkbox" value="{{ $grouplist[$i]['groupid'] }}" <?php
if ($invited + 1 == $groupmemberlist - $groupmemberlist_admin && $groupmemberlist - $groupmemberlist_admin != 1) {
echo "checked";
}
</div>
<?php
//}
}
?>
<table class="display" cellspacing="0" width="100%" id="dd_group_list">
<thead>
<tr>
<?php
if ($showjoinbtn == 'no') {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->count();
$groupmemberlist = groupmemberModel::where('group_id', $group_id)->get()->count();
?>
<th style="background-color:#0896D6"><input type="checkbox" name="checkall" class="checkall" <?php
if ($invited + 1 == $groupmemberlist && $groupmemberlist != 1) {
echo "checked";
}
?>
/></th> <?php
}
?>
<th style="background-color:#0896D6"><span class="txt_sno">S.NO</span></th>
<th><span class="txt_img">Image</span></th>
<th><span class="txt_memname">Member Name</span></th>
<?php
if ($showjoinbtn == 'no') {
?>
public function exitgroup()
{
$groupid = $_GET['groupid'];
$groupmeberuserid = $_GET['groupmeberuserid'];
$removemember = groupmemberModel::where('group_id', $groupid)->where('user_id', $groupmeberuserid)->delete();
return Redirect::to('viewgroupmember/' . $groupid)->with('group_id', $groupid)->with('showjoinbtn', 'yes')->with('contest_id', 'no')->with('Message', 'You are exit from that group');
}
public function invitegroupsforcontest()
{
//invitegroupsforcontest
$inpudetails['invitedetail'] = 1;
$inpudetails['group_id'] = Input::get('group_id');
$inpudetails['contest_id'] = Input::get('contest_id');
$curdate = date('Y-m-d h:i:s');
$inpudetails['inviteddate'] = $curdate;
$invite_type = Input::get('invite_type');
/////// Contest info /////
//Input::get('contest_id');
$contestinfo = contestModel::select('contest_name', 'contesttype', 'createdby', 'visibility')->where('ID', Input::get('contest_id'))->get();
$contestname = $contestinfo[0]['contest_name'];
$contesttype = $contestinfo[0]['contesttype'];
//return $contestinfo[0]['visibility'];
if ($contesttype == 'p') {
$contesttype = "Photo";
} else {
if ($contesttype == 'v') {
$contesttype = "Video";
} else {
if ($contesttype == 't') {
$contesttype = "Topic";
}
}
}
//return $contestinfo[0]['createdby'];
$contest_id = Input::get('contest_id');
$contestcreatedby = User::find($contestinfo[0]['createdby']);
if ($contestcreatedby['firstname'] != '') {
$contestcreatedby = $contestcreatedby['firstname'] . '' . $contestcreatedby['lastname'];
} else {
$contestcreatedby = $contestcreatedby['username'];
}
if ($invite_type == 'All') {
$invitedlis = invitegroupforcontestModel::where('contest_id', $inpudetails['contest_id'])->lists('group_id');
$invitedcnt = count($invitedlis);
if ($invitedcnt) {
//$uninvitedgroup = groupModel::whereNotIn('id', $invitedlis)->lists('id');
$uninvitedgroup = groupmemberModel::select('group.id')->leftJoin('group', 'group.ID', '=', 'group_members.group_id')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('group_members.user_id', Input::get('user_id'))->whereNotIn('group.id', $invitedlis)->get()->toArray();
} else {
//$uninvitedgroup =groupModel::lists('id');
$uninvitedgroup = groupmemberModel::select('group.id')->leftJoin('group', 'group.ID', '=', 'group_members.group_id')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('group_members.user_id', Input::get('user_id'))->get()->toArray();
}
if (count($uninvitedgroup)) {
for ($i = 0; $i < count($uninvitedgroup); $i++) {
$inpudetails['group_id'] = $uninvitedgroup[$i]['id'];
if ($uninvitedgroup[$i]['id'] != '') {
$groupowner = groupModel::select('user.firstname', 'user.lastname', 'user.username', 'group.grouptype', 'group.groupname')->where('group.ID', $uninvitedgroup[$i]['id'])->LeftJoin('user', 'user.ID', '=', 'group.createdby')->get();
if ($groupowner[0]['firstname'] != '') {
$inviter = $groupowner[0]['firstname'] . " " . $groupowner[0]['lastname'];
} else {
$inviter = $groupowner[0]['username'];
}
}
invitegroupforcontestModel::create($inpudetails);
$groupname = $groupowner[0]['groupname'];
/******** Here want to set the Notification for Group Members ***/
$groupmemberlist = groupmemberModel::where('group_id', $uninvitedgroup[$i]['id'])->lists('user_id');
for ($j = 0; $j < count($groupmemberlist); $j++) {
//////Notification////////////////////
if ($contestinfo[0]['createdby'] != $groupmemberlist[$j]) {
$user_id = User::find($groupmemberlist[$j]);
$gcmid = $user_id['gcm_id'];
$email = $user_id['email'];
if ($contestinfo[0]['visibility'] == 'p') {
$privat_user['user_id'] = $groupmemberlist[$j];
$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', $groupmemberlist[$j])->where('contest_id', $contest_id)->get()->count();
if ($privatecontestcnt == 0) {
privateusercontestModel::create($privat_user);
}
}
///////
if ($gcmid != '') {
$Message['user_id'] = $groupmemberlist[$j];
$Message['title'] = 'Ding Datt';
$Message['message'] = 'You are invited for the Contest :' . $contestname;
$Message['contest_id'] = $inpudetails['contest_id'];
$Message = array("notification" => $Message);
$DeviceId = array($gcmid);
$Message = array("notification" => $Message);
$this->PushNotification($DeviceId, $Message);
} else {
$email = $user_id['email'];
Mail::send([], array('email' => $email, 'contestcreatedby' => $contestcreatedby, 'contesttype' => $contesttype, 'contestname' => $contestname, 'contest_id' => $contest_id, '$groupname' => $groupname), function ($message) use($email, $contestcreatedby, $contesttype, $contestname, $contest_id, $groupname) {
$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:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Group Name by:</span>' . $groupname . '</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');
});
}
}
//////Notification End //////////////
}
}
$Response = array('success' => '1', 'message' => 'Invited Successfully');
$final = array("response" => $Response);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => 'Already Invited these Groups');
$final = array("response" => $Response);
return json_encode($final);
}
} else {
$validator = Validator::make($inpudetails, invitegroupforcontestModel::$rules);
if ($validator->passes()) {
$invite = invitegroupforcontestModel::create($inpudetails);
$inpudetails['group_id'] = Input::get('group_id');
if (Input::get('group_id') != '') {
$groupowner = groupModel::select('user.firstname', 'user.lastname', 'user.username', 'group.grouptype', 'group.groupname')->where('group.ID', Input::get('group_id'))->LeftJoin('user', 'user.ID', '=', 'group.createdby')->get();
if ($groupowner[0]['firstname'] != '') {
$inviter = $groupowner[0]['firstname'] . " " . $groupowner[0]['lastname'];
} else {
$inviter = $groupowner[0]['username'];
}
}
//invitegroupforcontestModel::create($inpudetails);
/******** Here want to set the Notification for Group Members ***/
$groupname = $groupowner[0]['groupname'];
$groupmemberlist = groupmemberModel::where('group_id', Input::get('group_id'))->lists('user_id');
//return $contestinfo[0]['createdby'];
//return $groupmemberlist[0];
$temp = array();
for ($j = 0; $j < count($groupmemberlist); $j++) {
//////Notification////////////////////
//return (int)$groupmemberlist[$j].'s'.$contestinfo[0]['createdby'].'ad';
$groupid1 = (int) $groupmemberlist[$j];
$contstcreated = (int) $contestinfo[0]['createdby'];
$temp[$j] = "no";
if ($groupid1 != $contstcreated) {
$temp[$j] = "yes";
//return "ABdgdfgdf";
$user_id = User::find($groupmemberlist[$j]);
$gcmid = $user_id['gcm_id'];
$email = $user_id['email'];
if ($contestinfo[0]['visibility'] == 'p') {
$privat_user['user_id'] = $groupmemberlist[$j];
$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', $groupmemberlist[$j])->where('contest_id', $contest_id)->get()->count();
if ($privatecontestcnt == 0) {
privateusercontestModel::create($privat_user);
}
}
if ($gcmid != '') {
$Message['user_id'] = $groupmemberlist[$j];
$Message['title'] = 'Ding Datt';
$Message['message'] = 'You are invited for the Contest :' . $contestname;
$Message['contest_id'] = $inpudetails['contest_id'];
$Message = array("notification" => $Message);
$DeviceId = array($gcmid);
$Message = array("notification" => $Message);
$this->PushNotification($DeviceId, $Message);
} else {
$email = $user_id['email'];
Mail::send([], array('email' => $email, 'contestcreatedby' => $contestcreatedby, 'contesttype' => $contesttype, 'contestname' => $contestname, 'contest_id' => $contest_id, 'groupname' => $groupname), function ($message) use($email, $contestcreatedby, $contesttype, $contestname, $contest_id, $groupname) {
$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:15px;"><span style="font-weight:bold; width:150px; float:left; display:inline-block;">Group Name by:</span>' . $groupname . '</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');
});
}
}
//////Notification End //////////////
}
//return $temp;
//////
$Response = array('success' => '1', 'message' => 'You are Invited That group Successfully');
$final = array("response" => $Response);
return json_encode($final);
} else {
$Response = array('success' => '0', 'message' => 'Required Details are Missing');
$final = array("response" => $Response);
return json_encode($final);
}
}
}
<div id="p">
<table class="display" cellspacing="0" width="100%" id="dd_profile_group">
<thead>
<tr>
<th><Span class="txt_sno">S.No</span></th>
<th><Span class="txt_img">Image</span></th>
<th><Span class="txt_groupname">Group Name</span></th>
<th><Span class="txt_memberowner">Member/Owner</span></th>
<th class="tr_wid_button1" align="center"><Span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($memberlist); $i++) {
$checkverifyuser = groupmemberModel::where('user_id', Auth::user()->ID)->where('group_id', $memberlist[$i])->get()->count();
$grouplist = groupModel::select('groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage', 'group.ID as groupid', 'user.ID as userid')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->where('user.status', 1)->where('group.status', 1)->where('group.ID', $memberlist[$i])->get();
if (count($grouplist)) {
?>
<tr>
<td>{{ $i+1 }} </td>
<td align="center"><img src="{{ ($grouplist[0]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$grouplist[0]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td>{{ $grouplist[0]['groupname'] }}</td>
<td><?php
if ($grouplist[0]['createdby'] == $profileid) {
echo "Owner";
} else {
echo "Member";
}
?>
</td>
