public function deletecategory() { $categoryid = Input::get('categoryid'); $usercategory = userinterestModel::where('interest_id', $categoryid)->get()->count(); $contestcategory = contestinterestModel::where('category_id', $categoryid)->get()->count(); if ($usercategory > 0 || $contestcategory > 0) { $er_data = 'This category is used. So not able to delete '; return Redirect::to('category')->with('er_data', $er_data); } else { $deletecategory = InterestCategoryModel::where('Interest_id', $categoryid)->delete(); if ($deletecategory) { $er_data = 'Category deleted successfully'; return Redirect::to('category')->with('er_data', $er_data); } } }
public function profileupdate($data = Null) { //$data = Auth::user()->ID; $editid = $data; $GeneralData = Input::except(array('_token', 'status', 'pagename', 'profilepicture', 'profileimgedithidden', 'interest', 'update_profile')); $newimg = Input::file('profilepicture'); if ($newimg != '') { $destinationPath = 'public/assets/upload/profile'; $filename = Input::file('profilepicture')->getClientOriginalName(); $Image = str_random(8) . '_' . $filename; $GeneralData['profilepicture'] = $Image; $uploadSuccess = Input::file('profilepicture')->move($destinationPath, $Image); } $interest = Input::get('interest'); $interest_length = sizeof(Input::get('interest')); if ($interest_length > 0) { userinterestModel::whereNotIn('interest_id', $interest)->where('user_id', '=', $data)->delete(); for ($i = 0; $i < $interest_length; $i++) { $interes['user_id'] = $data; $interes['interest_id'] = $interest[$i]; $userInterest = userinterestModel::where('user_id', $data)->where('interest_id', $interest[$i])->lists('interest_id'); if (count($userInterest) < 1) { userinterestModel::create($interes); } unset($interes); } } else { userinterestModel::where('user_id', '=', $data)->delete(); } $cur_date = date('Y-m-d'); $updaterules = array('username' => 'required|unique:user,username,' . $data, 'password' => 'confirmed|min:5', 'email' => 'required|email|unique:user,email,' . $data, 'dateofbirth' => 'required', 'timezone' => 'required|min:2'); $validation = Validator::make($GeneralData, $updaterules); $newpassword = Input::get('password'); if ($newpassword != "") { $GeneralData['password'] = Hash::make(Input::get('password')); } else { unset($GeneralData["password"]); } unset($GeneralData["password_confirmation"]); $updatedata = $GeneralData; $lantyp = Session::get('language'); if ($lantyp == "") { $lantyp = "value_en"; } if (!isset($updatedata['maritalstatus'])) { $updatedata['maritalstatus'] = 0; } if ($validation->passes()) { $affectedRows = ProfileModel::where('ID', $data)->update($updatedata); $lantyp = Session::get('language'); $labelname = ['txt_user_update_msg']; $languageDetails = languageModel::select($lantyp)->whereIn('ctrlCaptionId', $labelname)->get()->toArray(); $user_id = $data; $profileData = ProfileModel::where('ID', $user_id)->first(); $interestList = InterestCategoryModel::lists('Interest_name', 'Interest_id'); $userInterest = userinterestModel::where('user_id', $user_id)->lists('interest_id'); $er_data['Message'] = "<span id='txt_user_update_msg'>" . $languageDetails[0][$lantyp] . "</span>"; return Redirect::to('/edit_profile/' . $data)->with('er_data', $er_data)->with('user_id', $user_id); } else { $languageDetails = languageModel::select($lantyp, 'ctrlCaptionId')->whereIn('value_en', [$validation->messages()->first('username'), $validation->messages()->first('password'), $validation->messages()->first('email'), $validation->messages()->first('dateofbirth'), $validation->messages()->first('timezone')])->get()->toArray(); foreach ($languageDetails as $key => $val) { if (in_array($val['ctrlCaptionId'], ['alert_enterusername', 'alert_alreadyuser'])) { $er_data['username'] = "******" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_enterpassword', 'alert_minpass5', 'alert_passconfnotmatch'])) { $er_data['password'] = "******" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_enteremail', 'alert_validemail', 'alertr_emailalready'])) { $er_data['email'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_enterdob'])) { $er_data['dateofbirth'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['txt_timezone_required'])) { $er_data['timezone'] = "<span id='" . $val['ctrlCaptionId'] . "'>Timezone is required</span>"; } } return Redirect::to('/edit_profile/' . $data)->with('er_data', $er_data)->with('old_data', $updatedata); } }
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); }
?> <div class="main_head" style="width:180px;"><span id="txt_editmyprofile" class="txt_editmyprofile">Edit Profile</span></div> <div class="main_wrap" style="background-colour:"> <form id="editprofile" name="edit_profile_update" enctype="multipart/form-data" action="<?php echo url() . "/edit_profile_update/" . $user_id; ?> " method="post" class="form_mid"> @if(isset($er_data['Message'])) <p class="alert" style="color:green;padding:5px;text-align:center;font-size:13px">{{ $er_data['Message'] }}</p> @endif <?php //$user_id = Auth::user()->ID; $user_id = $user_id; $profileData = ProfileModel::where('ID', $user_id)->first(); $interestList = InterestCategoryModel::where('status', 1)->lists('Interest_name', 'Interest_id'); $userInterest = userinterestModel::where('user_id', $user_id)->lists('interest_id'); $timezoneList = timezoneDBModel::lists('timezonename', 'timezonevalue'); ?> <div class="loginform loginbox mar1"> <legend class="radius"><div class="leg_head"><span id="txt_logininfo">Login Info</span></div> <p> <div class="inp_pfix"><img src="{{ URL::to($assets_path.'img/user_icons.png') }}" width="25" height="25"></div> <input type="text" id="pch_username" name="username" placeholder="User Name" title="User Name" value="{{ isset($old_data['username'])?$old_data['username']:$profileData['username'] }}" <?php if (Auth::user()->ID != $user_id) { echo "readonly"; } ?> class="radius pfix_mar" /> </p> @if(isset($er_data['username'])) <p class="alert" style="text-align:left;margin-left:55px;color:red;">{{ $er_data['username'] }}</p>
public function editmyprofile() { $GeneralData = array_filter(Input::except(array('_token', 'passwordhidden', 'profilepicture', 'interest_id', 'userid', 'timezone', 'dateofbirth'))); $timezone = Input::get('timezone'); $GeneralData['dateofbirth'] = timezoneModel::convert(Input::get('dateofbirth'), $timezone, 'UTC', 'Y-m-d'); $newimg = Input::file('profilepicture'); if ($newimg != '') { $destinationPath = 'public/assets/upload/profile'; $filename = Input::file('profilepicture')->getClientOriginalName(); $Image = str_random(8) . '_' . $filename; $GeneralData['profilepicture'] = $Image; $uploadSuccess = Input::file('profilepicture')->move($destinationPath, $Image); } else { //$GeneralData['profilepicture']=Input::get('profileimgedithidden'); } $GeneralData['status'] = 1; $data = Input::get('userid'); $newpassword = Input::get('password'); $updaterules = array('username' => 'required|unique:user,username,' . $data, 'password' => 'confirmed:min:5', 'email' => 'required|email|unique:user,email,' . $data); $validation = Validator::make($GeneralData, $updaterules); if ($validation->passes()) { if ($newpassword != "") { $GeneralData['password'] = Hash::make(Input::get('password')); } unset($GeneralData["password_confirmation"]); $affectedRows = ProfileModel::where('ID', $data)->update($GeneralData); $interest_id = Input::get('interest_id'); $interestid = explode(',', $interest_id); $interestidcount = count($interestid); $interest['user_id'] = Input::get('userid'); $affectedRows = userinterestModel::where('user_id', $data)->delete(); for ($i = 0; $i < $interestidcount; $i++) { $interest['interest_id'] = $interestid[$i]; $validationinterest = Validator::make($interest, userinterestModel::$rules); if ($validationinterest->passes()) { $userregister = userinterestModel::create($interest); } } $Response = array('success' => '1', 'message' => 'Record Updated successfully', 'msgcode' => "c109"); $final = array("response" => $Response); return json_encode($final); } else { $Response = array('success' => '0', 'message' => $validation->messages()->first(), 'msgcode' => "c110"); $final = array("response" => $Response); return json_encode($final); } }
public function savecontest() { $conteststart = Input::get('conteststartdate'); $contestenddate = Input::get('contestenddate'); $votingstartdate = Input::get('votingstartdate'); $votingenddate = Input::get('votingenddate'); $a = 0; //if($conteststart<$contestenddate && $contestenddate<=$votingstartdate && $votingstartdate<$votingenddate){}else{ return "S"; } if ($conteststart > $contestenddate) { $a = 1; $er_data['contestenddate'] = 'Contest end date should be greater than contest start date'; } elseif (strtotime($contestenddate) > strtotime($votingstartdate)) { $a = 1; $er_data['votingstartdate'] = 'Voting start date should be greater than or equal to contest end date'; } elseif ($votingstartdate > $votingenddate) { $a = 1; $er_data['votingenddate'] = 'Voting end date should be greater than voting start date'; } if ($a == 1) { return Redirect::to('/contest')->withInput()->with('er_data', $er_data); } $inputdetails = Input::except(array('_token', 'themephoto', 'sponsor', 'sponsorphoto', 'sponsorname')); if (Input::file('themephoto') != '') { $destinationPath_them = 'public/assets/upload/contest_theme_photo'; $filename_them = Input::file('themephoto')->getClientOriginalName(); $Image_them = str_random(8) . '_' . $filename_them; $inputdetails['themephoto'] = $Image_them; } if (Auth::user()->ID == 1) { $inputdetails['sponsorname'] = Input::get('sponsorname'); if (Input::file('sponsorphoto') != '') { $destinationPath_spons = 'public/assets/upload/sponsor_photo'; $filename_spons = Input::file('sponsorphoto')->getClientOriginalName(); $Image_spons = str_random(8) . '_' . $filename_spons; $inputdetails['sponsorphoto'] = $Image_spons; } } $lantyp = Session::get('language'); if ($lantyp == "") { $lantyp = "value_en"; } $validation = Validator::make($inputdetails, contestModel::$rules); if ($validation->passes()) { if (Auth::user()->ID == 1) { $admintimezone = User::where('ID', 1)->get()->first(); $inputdetails['conteststartdate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['conteststartdate'])), $admintimezone->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['contestenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['contestenddate'])), $admintimezone->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['votingstartdate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingstartdate'])), $admintimezone->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['votingenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingenddate'])), $admintimezone->timezone, 'UTC', 'Y-m-d H:i:s'); } else { $inputdetails['conteststartdate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['conteststartdate'])), Auth::user()->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['contestenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['contestenddate'])), Auth::user()->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['votingstartdate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingstartdate'])), Auth::user()->timezone, 'UTC', 'Y-m-d H:i:s'); $inputdetails['votingenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingenddate'])), Auth::user()->timezone, 'UTC', 'Y-m-d H:i:s'); } $inputdetails['createdby'] = Auth::user()->ID; if (Auth::user()->ID == 1) { $inputdetails['visibility'] = Input::get('visibility'); } else { $inputdetails['visibility'] = "p"; } $inputdetails['status'] = 1; $inputdetails['createddate'] = $inputdetails['updateddate'] = date('Y-m-d H:i:s'); $file_them = Input::file('themephoto'); $file_spons = Input::file('sponsorphoto'); if (isset($inputdetails['sponsorphoto'])) { $uploadSuccess_spons = $file_spons->move($destinationPath_spons, $Image_spons); } if (isset($inputdetails['themephoto'])) { $uploadSuccess_them = $file_them->move($destinationPath_them, $Image_them); } $product = contestModel::create($inputdetails); $contest_id = $product->ID; $interest = Input::get('interest'); $interest_length = sizeof(Input::get('interest')); if ($interest_length > 0) { contestinterestModel::whereNotIn('category_id', $interest)->where('contest_id', '=', $contest_id)->delete(); for ($i = 0; $i < $interest_length; $i++) { $interes['contest_id'] = $contest_id; $interes['category_id'] = $interest[$i]; $userInterest = contestinterestModel::where('contest_id', $contest_id)->where('category_id', $interest[$i])->lists('category_id'); if (count($userInterest) < 1) { contestinterestModel::create($interes); /// Vew enhanchment for interest send push notification to appropriate user //// $pushnotificationdetail = userinterestModel::select('user.firstname', 'user.lastname', 'user.username', 'user.ID', 'user.email', 'user.gcm_id', 'user.device_type', 'user.timezone')->LeftJoin('user', 'user.ID', '=', 'user_interest.user_id')->where('interest_id', $interest[$i])->get(); for ($j = 0; $j < count($pushnotificationdetail); $j++) { if (Auth::user()->ID == 1) { if ($pushnotificationdetail[$j]['firstname'] != '') { $name = $pushnotificationdetail[$j]['firstname'] . ' ' . $pushnotificationdetail[$j]['lastname']; } else { $name = $pushnotificationdetail[$j]['username']; } $email = $pushnotificationdetail[$j]['email']; $gcm_id = $pushnotificationdetail[$j]['gcm_id']; $device_type = $pushnotificationdetail[$j]['device_type']; $uid = $pushnotificationdetail[$j]['ID']; $contestname = Input::get('contest_name'); $contesttype = Input::get('contesttype'); $contestimage = $Image_them; $conteststartdate = timezoneModel::convert($inputdetails['conteststartdate'], 'UTC', $pushnotificationdetail[$j]['timezone'], 'd-m-Y h:i:s'); $contestenddate = timezoneModel::convert($inputdetails['contestenddate'], 'UTC', $pushnotificationdetail[$j]['timezone'], 'd-m-Y h:i:s'); $this->Inviteforcontestintest($name, $email, $gcm_id, $device_type, $uid, $interest[$i], $contestname, $contest_id, $contesttype, $contestimage, $conteststartdate, $contestenddate); } } // //$interest[$i] } unset($interes); } } $private_cont['contest_id'] = $contest_id; $private_cont['user_id'] = Auth::user()->ID; $private_cont['requesteddate'] = date('Y-m-d H:i:s'); $private_cont['status'] = 1; if (Auth::user()->ID == 1) { if (Input::get('visibility') == 'p') { privateusercontestModel::create($private_cont); } } else { privateusercontestModel::create($private_cont); } return Redirect::to('contest_info/' . $product->ID); } else { if ($validation->messages()->first('contest_name') == "The contest name field is required.") { $er_msg_con_name = "The Contest Name field is required."; } else { $er_msg_con_name = $validation->messages()->first('contest_name'); } if ($validation->messages()->first('conteststartdate') == "The conteststartdate field is required.") { $er_msg_con_start = "The Contest Start Date field is required."; } else { $er_msg_con_start = $validation->messages()->first('conteststartdate'); } if ($validation->messages()->first('contestenddate') == "The contestenddate field is required.") { $er_msg_con_end = "The Contest End Date field is required."; } else { $er_msg_con_end = $validation->messages()->first('contestenddate'); } if ($validation->messages()->first('votingstartdate') == "The votingstartdate field is required.") { $er_msg_vote_start = "The Voting Start Date field is required."; } else { $er_msg_vote_start = $validation->messages()->first('votingstartdate'); } if ($validation->messages()->first('votingenddate') == "The votingenddate field is required.") { $er_msg_vote_end = "The Voting End Date field is required."; } else { $er_msg_vote_end = $validation->messages()->first('votingenddate'); } if ($validation->messages()->first('noofparticipant') == "The noofparticipant field is required.") { $er_msg_noof_part = "The No of Participant field is required."; } else { $er_msg_noof_part = $validation->messages()->first('noofparticipant'); } if ($validation->messages()->first('contesttype') == "The contesttype field is required.") { $er_msg_con_type = "The Contest Type field is required."; } else { $er_msg_con_type = $validation->messages()->first('contesttype'); } if ($validation->messages()->first('themephoto') == "The themephoto field is required.") { $er_msg_them = "The Contest Image field is required."; } else { $er_msg_them = $validation->messages()->first('themephoto'); } $languageDetails = languageModel::select($lantyp, 'ctrlCaptionId')->whereIn('value_en', [$er_msg_con_name, $er_msg_con_start, $er_msg_con_end, $er_msg_vote_start, $er_msg_vote_end, $er_msg_noof_part, $er_msg_con_type, $er_msg_them])->get()->toArray(); //return $validation->messages(); foreach ($languageDetails as $key => $val) { if (in_array($val['ctrlCaptionId'], ['alert_entercontestname', 'alert_alreadycontestname'])) { $er_data['contest_name'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_enterconteststartdate'])) { $er_data['conteststartdate'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_contestenddate'])) { $er_data['contestenddate'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_votingstartdate'])) { $er_data['votingstartdate'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_votingenddate'])) { $er_data['votingenddate'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_enternoofpartis'])) { $er_data['noofparticipant'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_entercontesttype'])) { $er_data['contesttype'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } elseif (in_array($val['ctrlCaptionId'], ['alert_themephoto'])) { $er_data['themephoto'] = "<span id='" . $val['ctrlCaptionId'] . "'>" . $val[$lantyp] . "</span>"; } } return Redirect::to('/contest')->withInput()->with('er_data', $er_data); } }