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>