Esempio n. 1
0
    </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);
 }
Esempio n. 3
0
 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);
     }
 }
Esempio n. 4
0
    ?>
<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%;">&nbsp;</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%;">&nbsp;</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);
            }
        }
    }