<span class="txt_memname">User Name</span><?php
} else {
?>
<span class="txt_grpowner">Group owner</span><?php
}
?>
</th>
</tr>
</thead>
<tbody>
<?php
if ($accepttype == 'admin') {
$invitedlist = invitememberforgroupModel::select('invitememberforgroup.user_id as usrid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'group.ID as group_id', 'invitememberforgroup.invitetype', 'group.groupimage')->where('group.createdby', Auth::user()->ID)->where('invitememberforgroup.invitetype', 'u')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->Join('user', 'user.ID', '=', 'invitememberforgroup.user_id')->get();
} else {
$invitedlist = invitememberforgroupModel::select('invitememberforgroup.user_id as usrid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'invitememberforgroup.invitetype', 'group.ID as group_id', 'group.groupimage', 'group.createdby')->LeftJoin('user', 'user.ID', '=', 'invitememberforgroup.user_id')->where('user_id', Auth::user()->ID)->where('invitetype', 'm')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->get();
}
for ($i = 0; $i < count($invitedlist); $i++) {
if ($accepttype == 'admin') {
if ($invitedlist[$i]['firstname'] != '') {
$membername = $invitedlist[$i]['firstname'] . ' ' . $invitedlist[$i]['lastname'];
} else {
$membername = $invitedlist[$i]['username'];
}
} else {
$memberdetails = User::find($invitedlist[$i]['createdby']);
if ($memberdetails['firstname'] != '') {
$membername = $memberdetails['firstname'] . ' ' . $memberdetails['lastname'];
} else {
$membername = $memberdetails['username'];
}
public function requestcount()
{
$user_id = Input::get('user_id');
$admincount = invitememberforgroupModel::select('invitememberforgroup.user_id as userid', 'user.profilepicture', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'group.ID as group_id', 'invitememberforgroup.invitetype', 'group.groupimage')->where('group.createdby', $user_id)->where('invitememberforgroup.invitetype', 'u')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->Join('user', 'user.ID', '=', 'invitememberforgroup.user_id')->get()->count();
$membercount = invitememberforgroupModel::select('invitememberforgroup.user_id as userid', 'user.firstname', 'user.lastname', 'user.username', 'group.groupname', 'invitememberforgroup.invitetype', 'group.ID as group_id', 'group.groupimage', 'group.createdby')->LeftJoin('user', 'user.ID', '=', 'invitememberforgroup.user_id')->where('user_id', $user_id)->where('invitetype', 'm')->LeftJoin('group', 'group.ID', '=', 'invitememberforgroup.group_id')->get()->count();
$final = array("admincount" => $admincount, "membercount" => $membercount);
return json_encode($final);
}
