public function getgrouplist()
{
$grouplist = groupModel::get()->toArray();
$Response = array('success' => '1', 'message' => 'Group Members saved successfully');
$final = array("response" => $Response, "grouplist" => $grouplist);
return json_encode($final);
}
public function resolvenestedgroupmembership(&$groups, $memberof)
{
$groupmodel = new groupModel($this->domain);
$group = $groupmodel->getfromDn($memberof);
if (count($group) == 1) {
$group = $group[0];
if (!isset($groups[$group->getId()])) {
$groups[$group->getId()] = $group->getName();
// Nested group support
$memberofs = $group->getMemberof();
if ($memberofs != '') {
if (is_array($memberofs)) {
foreach ($memberofs as $memberof) {
$this->resolvenestedgroupmembership($groups, $memberof);
}
} else {
$this->resolvenestedgroupmembership($groups, $memberofs);
}
}
}
}
}
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);
}
<?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'];
} else {
echo $group[$i]['username'];
public function getinviteList()
{
$subtab = Input::get('subtab');
$contest_id = Input::get('contest_id');
if ($subtab) {
?>
<thead>
<tr>
<th><input name="" type="checkbox" value=""></th>
<th>Image</th>
<th>Group Name</th>
<th class="tr_wid_button1" align="center">Invite</th>
<th class="tr_wid_button1" align="center">View</th>
</tr>
</thead>
<tbody>
<?php
$grouplist = groupModel::select('group.ID as groupid', 'groupname', 'grouptype', 'createdby', 'user.firstname as owner', 'groupimage')->LeftJoin('user', 'user.ID', '=', 'group.createdby')->get();
$groupcount = count($grouplist);
for ($i = 0; $i < $groupcount; $i++) {
$invited = invitegroupforcontestModel::where('group_id', $grouplist[$i]['groupid'])->where('contest_id', $contest_id)->count();
?>
<tr>
<td class="tr_wid_id"><input name="group_list[]" type="checkbox" value="{{ $grouplist[$i]['groupid'] }}"></td>
<td align="center"><img src="{{ ($grouplist[$i]['groupimage']!='')?(URL::to('public/assets/upload/group/'.$grouplist[$i]['groupimage'])):(URL::to('assets/inner/img/default_groupimage.png')) }}" width="50" height="50"></td>
<td>{{ $grouplist[$i]['groupname'] }}</td>
<td class="tr_wid_button1" align="center"><a href="#" <?php
if ($invited > 0) {
?>
title="Invited" style="background-color:red;" <?php
} else {
?>
title="Invite" onClick="invite_groups('{{ $grouplist[$i]['groupid'] }}','{{ $contest_id }}');" <?php
}
?>
id="invite_list_{{ $grouplist[$i]['groupid'] }}" class="add-link"></a></td>
<td class="tr_wid_button1" align="center"><a href="{{ URL::to('viewgroupmember/'.$grouplist[$i]['groupid']) }}" class="view-link"></a></td>
</tr>
<?php
}
?>
</tbody>
<?php
}
}
protected function mail($ticket)
{
require FRAMEWORK . DS . 'conf' . DS . 'myticket.php';
$replyto = '';
$usermodel = new userModel();
$user = $usermodel->getfromDisplayname($ticket->getContact());
if (count($user) == 1) {
$mail = $user[0]->getMail();
if ($mail != '') {
$replyto = $mail;
} else {
$replyto = $defaultfrom;
}
} else {
$replyto = $defaultfrom;
}
$dienstModel = new groupModel();
$dienstname = '';
$dienst = $dienstModel->getfromId($ticket->getDienstid());
if (count($dienst) == 1) {
$dienstname = $dienst[0]->getDescription();
}
$to = '';
$meldingdienstenModel = new meldingdienstenModel();
$dienstto = $meldingdienstenModel->getfromId($ticket->getTo());
if (count($dienstto) == 1) {
$to = $dienstto[0]->getMail();
$toname = $dienstto[0]->getName();
} else {
throw new Exception('No mail address for recipiënt');
}
$subject = 'Melding [' . $ticket->getId() . '] aan [' . $toname . ']: ' . $ticket->getTitel();
$message = '<h1>Melding ' . $toname . '</h1>';
$message .= '
<table>
<tr>
<td valign="top"><strong>Naam:</strong></td>
<td>' . $ticket->getContact() . '</td>
</tr>
<tr>
<td valign="top"><strong>Afdeling:</strong></td>
<td>' . $dienstname . '</td>
</tr>
<tr>
<td valign="top"><strong>Omschrijving:</strong></td>
<td>' . nl2br($ticket->getMessage()) . '</td>
</tr>
</table>
';
return mail($to, $subject, $message, 'Content-Type: text/html; charset=UTF-8' . "\r\n" . 'From: ' . $replyto . "\r\n" . 'Reply-To: ' . $replyto, '-f ' . $replyto);
}
<?php
// Some constants that should be configured
define('DS', '\\');
define('BASE_PATH', 'D:' . DS . 'websites' . DS . 'azl' . DS . 'framework');
define('FRAMEWORK', BASE_PATH);
// Get the dispatcher
require_once FRAMEWORK . DS . 'dispatcher.php';
// And fire it up
try {
$disp = new dispatcher();
} catch (Exception $e) {
echo $e->getMessage();
echo $e->getTrace();
}
$model = new groupModel();
echo '<pre />' . print_r($model->getfromName($_GET['group']), true) . '</pre>';
public function memberequesttogroup()
{
$userid = Input::get('userid');
$group_id = Input::get('group_id');
$groupdetails = groupModel::select('grouptype', 'groupname')->where('id', $group_id)->get();
$grouptype = $groupdetails[0]['grouptype'];
$curdate = date('Y-m-d h:i:s');
$inputdetails['user_id'] = $userid;
$inputdetails['group_id'] = $group_id;
$inputdetails['createddate'] = $curdate;
$inputdetails['invitetype'] = 'u';
if ($grouptype == 'open') {
$validation = Validator::make($inputdetails, groupmemberModel::$rules);
if ($validation->passes()) {
$savegroupmembers = groupmemberModel::create($inputdetails);
if ($savegroupmembers) {
$Response = array('success' => '1', 'message' => 'Group Members saved successfully', 'msgcode' => "c181");
$final = array("response" => $Response);
return json_encode($final);
}
}
} else {
$alreadyinvited = invitememberforgroupModel::where('user_id', $userid)->where('invitetype', 'u')->where('group_id', $group_id)->count();
if ($alreadyinvited == 0) {
$invite = invitememberforgroupModel::create($inputdetails);
if ($invite) {
$getcreateduserdetails = ProfileModel::select('email', 'firstname', 'lastname')->where('ID', $userid)->get();
$email = $getcreateduserdetails[0]['email'];
$name = $getcreateduserdetails[0]['firstname'] . ' ' . $getcreateduserdetails[0]['lastname'];
$groupname = $groupdetails[0]['groupname'];
$Response = array('success' => '1', 'message' => 'Your request sent to Group admin', 'msgcode' => "c187");
$final = array("response" => $Response);
return json_encode($final);
}
} else {
$Response = array('success' => '0', 'message' => 'Already invited', 'msgcode' => "c200");
$final = array("response" => $Response);
return json_encode($final);
}
}
}
<?php
if (Session::has('tab')) {
$tab = Session::get('tab');
} else {
$tab = "creategroup";
}
?>
@if(isset($er_data))
<p class="alert" style="color:green;padding:5px;text-align:center;font-size:13px">{{ $er_data }}</p>
@endif
<?php
if (Session::has('er_data')) {
$er_data = Session::get('er_data');
}
$groupdata = groupModel::where('ID', $groupid)->get();
?>
<div id="con_grp" class="tabs-wrapper">
<input type="radio" name="tab" id="tab1" class="tab-head" checked />
<label for="tab1"><span id="submnu_editgroup">Edit Group</span></label>
<div class="mbblk">
<select class="radius sel_lang">
<option>Edit Group</option>
</select>
</div>
<div class="tab-body-wrapper">
<div id="inv_fail" style="color:red;text-align:center;font-size:14px">{{ isset($inv_fail_message)?($inv_fail_message):"" }}</div>
<div class="scrolltable">
<table class="display" cellspacing="0" width="100%" id="dd_group_list">
<thead>
<tr>
<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;
<div class="tab-body-wrapper">
<div id="tab-body-1" class="tab-body">
@if(isset($er_data['memberdelete']))
<p class="alert" style="color:red; font-size:13px;">{{ $er_data['memberdelete'] }}</p>
@endif
@if(isset($er_data['message']))
<p class="alert" style="color:red; font-size:13px;">{{ $er_data['message'] }}</p>
@endif
@if(isset($Message))
<p class="alert" style="color:red; font-size:13px;">{{ $Message }}</p>
@endif
<span id="inv_success" class="alert" style="color:green; font-size:13px;"></span>
<div id="p">
<?php
$d = groupModel::select('groupname', 'createdby', 'ID')->where('ID', $group_id)->get();
?>
<h1><?php
echo $d[0]['groupname'];
?>
</h1>
<div class="fleft mb_brk">
<?php
$membercount = groupmemberModel::where('group_id', $group_id)->where('user_id', Auth::user()->ID)->get()->count();
?>
<nav class="slidernav">
<div id="navbtns" class="clearfix" ><b>
<?php
if ($showjoinbtn != 'no') {
?>
<?php
public function activegroup()
{
$groupid = $_GET['groupid'];
$checkstatus = groupModel::where('ID', $groupid)->where('status', 1)->count();
$savegroup = groupModel::select('grouptype', 'groupname', 'createdby', 'grouptype', 'status', 'groupimage')->where('ID', $groupid)->get();
$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 ///////////
if ($savegroup[0]['status'] == 1) {
$status = "Active";
} else {
$status = "Inactive";
}
$groupdetailsactive = '<div style="font-size:12px; color: #000000; float:left;padding:10px 2px;width:100%;margin:15px;">Your group <b>"' . $groupname . '"</b> is activated by admin </div><div styel"float:left;">
<table width="180" height="95" border="0" style="margin-bottom:10px;float:left;font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Name:</td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $groupname . '</td>
</tr>
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Type:</td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $savegroup[0]['grouptype'] . '</td>
</tr>
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group status </td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">Active</td>
</tr>
<tr style="border-radius:6px;-webkit-border-radius: 5px; -moz-border-radius: 5px;">
<td colspan="2" style="vertical-align: text-middle;" >
<span><a href="' . URL::to('viewgroupmember/' . $groupowneruserid) . '" style="text-decoration:none;><img src="' . URL::to('assets/inner/images/vist_dingdatt.png') . '/assets/inner/images/vist_dingdatt.png" width="120" height="30" /></a></span>
</td>
</tr>
</table>
</div>';
$groupdetailsdeactive = '<div style="font-size:12px; color: #000000; float:left;padding:10px 2px;width:100%;margin:15px;">Your group <b>"' . $groupname . '"</b> is deactivated by admin </div><div styel"float:left;">
<table width="180" height="95" border="0" style="margin-bottom:10px;float:left;font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Name:</td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $groupname . '</td>
</tr>
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group Type:</td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $savegroup[0]['grouptype'] . '</td>
</tr>
<tr>
<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Group status </td>
<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">Inactive</td>
</tr>
<tr style="border-radius:6px;-webkit-border-radius: 5px; -moz-border-radius: 5px;">
<td colspan="2" style="vertical-align: text-middle;" >
<span><a href="' . URL::to('viewgroupmember/' . $groupowneruserid) . '" style="text-decoration:none;><img src="' . URL::to('assets/inner/images/vist_dingdatt.png') . '/assets/inner/images/vist_dingdatt.png" width="120" height="30" /></a></span>
</td>
</tr>
</table>
</div>';
if ($checkstatus == 1) {
///Inactive process /////
$updatedetails['status'] = 0;
$affectedRows = groupModel::where('ID', $groupid)->update($updatedetails);
//$details = "Your contest ".$contestname." is deactivated by admin.";
$this->adminmailtogroupownerdelete($email, $groupownername, $groupname, $groupownername, $groupid, $groupdetailsdeactive);
if ($affectedRows) {
return 0;
}
} else {
///Active process /////
$updatedetails['status'] = 1;
$affectedRows = groupModel::where('ID', $groupid)->update($updatedetails);
//$details = "Your contest ".$contestname." is activated by admin.";
$this->adminmailtogroupowner($email, $groupownername, $groupname, $groupownername, $groupid, $groupdetailsactive);
if ($affectedRows) {
return 1;
}
}
}
<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>
<td align="center"><a href="<?php
