</thead>
<tbody>
<?php
if (Session::has('searchedgroup')) {
$searchedgroup = Session::get('searchedgroup');
}
$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'];
public function getgroupmemberlist()
{
$group_id = Input::get('group_id');
$contest_id = Input::get('contest_id');
$membercount = groupmemberModel::where('group_id', $group_id)->get()->count();
if ($membercount) {
$savegroupmembers = groupmemberModel::select('group_members.id as groupmemberid', 'group_members.user_id', 'user.firstname', 'user.lastname', 'user.profilepicture', 'group.createdby as groupadmin_userid', 'user.username')->LeftJoin('user', 'user.ID', '=', 'group_members.user_id')->where('group_id', $group_id)->LeftJoin('group', 'group.ID', '=', 'group_members.group_id')->get();
for ($i = 0; $i < count($savegroupmembers); $i++) {
if ($savegroupmembers[$i]['firstname'] != '') {
$savegroupmembers[$i]['name'] = $savegroupmembers[$i]['firstname'] . ' ' . $savegroupmembers[$i]['lastname'];
} else {
$savegroupmembers[$i]['name'] = $savegroupmembers[$i]['username'];
}
$savegroupmembers[$i]['profilepicture'] = url() . '/public/assets/upload/profile/' . $savegroupmembers[$i]['profilepicture'];
if ($contest_id != '') {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $savegroupmembers[$i]['user_id'])->count();
$savegroupmembers[$i]['invited'] = $invited;
}
}
}
$Response = array('success' => '1', 'message' => 'Success', 'msgcode' => "c150");
$final = array("response" => $Response, 'groupmemberlist' => $savegroupmembers);
return json_encode($final);
}
public function groupmemberdelete()
{
$groupmemberid = $_GET['groupmemberid'];
$data = $_GET['group_id'];
$groupmemberdeletedetails = groupmemberModel::select('user_id')->where('id', $groupmemberid)->first();
$invited = invitegroupforcontestModel::where('group_id', $data)->where('user_id', $groupmemberdeletedetails['user_id'])->count();
if ($invited != 0) {
invitegroupforcontestModel::where('group_id', $data)->where('user_id', $groupmemberdeletedetails['user_id'])->delete();
}
$groupmemberdelete = groupmemberModel::where('id', $groupmemberid)->delete();
if ($groupmemberdelete) {
/* * ** Admin process********** */
if (Auth::user()->ID == 1) {
$savegroup = groupModel::select('grouptype', 'groupname', 'createdby')->where('ID', $data)->get();
if ($savegroup[0]['grouptype'] == 'private') {
$groupowneruserid = $savegroup[0]['createdby'];
$getcreateduserdetails = ProfileModel::select('email', 'firstname', 'lastname', 'username')->where('ID', $groupowneruserid)->get();
$email = $getcreateduserdetails[0]['email'];
if ($getcreateduserdetails[0]['firstname'] != '') {
$groupownername = $getcreateduserdetails[0]['firstname'] . ' ' . $getcreateduserdetails[0]['lastname'];
} else {
$groupownername = $getcreateduserdetails[0]['username'];
}
$groupname = $savegroup[0]['groupname'];
///// Group member details ///////////
$groupmemberdetails = ProfileModel::select('email', 'firstname', 'lastname', 'username')->where('ID', $groupmemberdeletedetails['user_id'])->get();
if ($groupmemberdetails[0]['firstname'] != '') {
$membername = $groupmemberdetails[0]['firstname'] . ' ' . $groupmemberdetails[0]['firstname'];
} else {
$membername = $groupmemberdetails[0]['username'];
}
}
}
$lantyp = Session::get('language');
if ($lantyp == "") {
$lantyp = "value_en";
}
$languageDetails = languageModel::select($lantyp, 'ctrlCaptionId')->whereIn('value_en', ['Group Member Deleted Successfully'])->get()->toArray();
foreach ($languageDetails as $key => $val) {
if (in_array($val['ctrlCaptionId'], ['alert_group_member_delete'])) {
$er_data['memberdelete'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>";
}
}
return Redirect::to('viewgroupmember/' . $data)->with('er_data', $er_data);
}
}
?>
<th class="tr_wid_button1" align="center"><span class="txt_remove">Remove / Exit</span></th><?php
}
?>
<?php
if ($showjoinbtn != 'no') {
?>
<th class="tr_wid_button1" align="center"><span class="txt_exit">Exit</span></th><?php
}
?>
<th class="tr_wid_button1" align="center"><span class="txt_view">View</span></th>
</tr>
</thead>
<tbody>
<?php
$savegroupmembers = groupmemberModel::select('group_members.id as groupmemberid', 'group_members.user_id', 'user.firstname', 'user.lastname', 'user.username', 'user.profilepicture', 'group.createdby as groupadmin_userid', 'user.ID as usrid')->LeftJoin('user', 'user.ID', '=', 'group_members.user_id')->where('group_id', $group_id)->where('user.status', 1)->LeftJoin('group', 'group.ID', '=', 'group_members.group_id')->orderby('group_members.id')->get();
if ($showjoinbtn == 'no') {
$contestdetails = contestModel::where('ID', $contest_id)->get()->first();
}
for ($i = 0; $i < count($savegroupmembers); $i++) {
?>
<?php
if ($showjoinbtn == 'no') {
$invited = invitegroupforcontestModel::where('group_id', $group_id)->where('contest_id', $contest_id)->where('user_id', $savegroupmembers[$i]['user_id'])->count();
?>
<td><?php
if ($contestdetails['createdby'] != $savegroupmembers[$i]['user_id'] && $savegroupmembers[$i]['user_id'] != 1) {
?>
<input type="checkbox" name="checkseparate" class="checkseparate" <?php
if ($invited > 0) {
echo "checked";
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);
}
}
}
