</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); } } }