예제 #1
0
 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);
         }
     }
 }
예제 #2
0
 public function contestdelete()
 {
     $data = Input::get('contestid');
     $searchkey = Input::get('searchkey');
     /// Contest details /////
     $contestdetailsformail = contestModel::select('user.firstname', 'user.lastname', 'user.username', 'contest.contest_name', 'contest.contesttype', 'user.email', 'contest.themephoto')->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->where('contest.ID', $data)->first();
     $contestname = $contestdetailsformail->contest_name;
     $contesttype = $contestdetailsformail->contesttype;
     if ($contestdetailsformail->firstname != '') {
         $name = $contestdetailsformail->firstname . ' ' . $contestdetailsformail->lastname;
     } else {
         $name = $contestdetailsformail->username;
     }
     $contest_id = $data;
     $email = $contestdetailsformail->email;
     $details = "Your contest " . $contestname . " is deleted by admin.";
     $contestimage = $contestdetailsformail->themephoto;
     $contestdetails = contestparticipantModel::where('contest_id', $data)->get();
     for ($i = 0; $i < count($contestdetails); $i++) {
         $contestparticipantid = $contestdetails[$i]['ID'];
         $comment = commentModel::select('id')->where('contest_participant_id', $contestparticipantid)->get();
         for ($i = 0; $i < count($comment); $i++) {
             $replycmt = replycommentModel::where('comment_id', $comment[$i]['id'])->get()->count();
             if ($replycmt) {
                 replycommentModel::where('comment_id', $comment[$i]['id'])->delete();
             }
         }
         if (count($comment)) {
             commentModel::select('id')->where('contest_participant_id', $contestparticipantid)->delete();
         }
         $votingcnt = votingModel::where('contest_participant_id', $contestparticipantid)->get()->count();
         if ($votingcnt) {
             votingModel::where('contest_participant_id', $contestparticipantid)->delete();
         }
         $participantid = contestparticipantModel::where('ID', $contestparticipantid)->get()->count();
         if ($participantid) {
             $delete = contestparticipantModel::where('ID', $contestparticipantid)->delete();
         }
     }
     $contestcatgory = contestinterestModel::where('contest_id', $data)->count();
     if ($contestcatgory) {
         contestinterestModel::where('contest_id', $data)->delete();
     }
     $deleteinvitecontest = invitegroupforcontestModel::where('contest_id', $data)->count();
     if ($deleteinvitecontest) {
         invitegroupforcontestModel::where('contest_id', $data)->delete();
     }
     $deletefollowercontest = invitefollowerforcontestModel::where('contest_id', $data)->count();
     if ($deletefollowercontest) {
         invitefollowerforcontestModel::where('contest_id', $data)->delete();
     }
     $privatecontestdelete = privateusercontestModel::where('contest_id', $data)->count();
     if ($privatecontestdelete) {
         privateusercontestModel::where('contest_id', $data)->delete();
     }
     $deletecontest = contestModel::where('ID', $data)->delete();
     if ($deletecontest) {
         $this->contestchangesmaildelete($email, $name, $contestname, $contest_id, $contestimage, $details);
     }
     $er_data['message'] = 'Contest removed successfully';
     return Redirect::to('managecontest')->with('er_data', $er_data)->with('usercontestlist', '')->with('searchkey', $searchkey);
 }
예제 #3
0
?>
 value="{{ isset($old_data['prize'])?$old_data['prize']:$contestdetails['prize'] }}" class="radius pfix_mar" />
</p>-->

                        <p>
                                <!--<div class="inp_pfix"><img src="img/gender_icons.png" width="25" height="25"></div>-->
                            <textarea name="description" cols="" rows=""  class="radius" placeholder="Contest Information" title="Contest Information">{{ isset($old_data['description'])?$old_data['description']:$contestdetails['description'] }}</textarea>
                        </p>
                    </legend>

                    <legend class="radius"><div class="leg_head"><span id="txt_favorite">Favorite</span></div>
                        <p>
                        <div class="inp_pfix mbmtop"><img src="{{ URL::to($assets_path.'img/interest_icons.png')}}" width="25" height="25"></div>
<?php 
$interestList = InterestCategoryModel::where('status', 1)->lists('Interest_name', 'Interest_id');
$contestInterest = contestinterestModel::where('contest_id', $contest_id)->lists('category_id');
?>
                        {{ Form::select('interest[]', $interestList,$contestInterest, array('class'=>'SlectBox testsel radius','multiple'=>'multiple',(($noofparticipants>0)?'disabled':''),'placeholder'=>'Select Interest','onchange'=>'console.log($(this).children(":selected").length)')) }}

                        </p>
                    </legend>
                </div>

                <div class="loginform loginbox mar2">
                    <legend class="radius"><div class="leg_head"><span id="txt_contestschedule">Contest Schedule</span></div>
                        <p>
                        <div class="inp_pfix "><img src="{{ URL::to($assets_path.'img/date_icons.png')}}" width="25" height="25"></div>
                        <input type="text" value="{{ isset($old_data['conteststartdate'])?date('m/d/Y h:i a',strtotime($old_data['conteststartdate'])):(timezoneModel::convert($contestdetails['conteststartdate'],'UTC',Auth::user()->timezone, 'm/d/Y h:i a')) }}" <?php 
if (Auth::user()->ID != 1) {
    if ($noofparticipants > 0 || $contestdetails['conteststartdate'] <= date('Y-m-d H:i:s')) {
        echo "disabled";
 public function updatecontestmobile()
 {
     $inputdetails = Input::except(array('_token', 'themephoto', 'contestid', 'interest_id', 'userid', 'timezone'));
     $timezone = Input::get('timezone');
     $inputdetails['conteststartdate'] = timezoneModel::convert(Input::get('conteststartdate'), $timezone, 'UTC', 'Y-m-d H:i:s');
     $inputdetails['contestenddate'] = timezoneModel::convert(Input::get('contestenddate'), $timezone, 'UTC', 'Y-m-d H:i:s');
     $inputdetails['votingstartdate'] = timezoneModel::convert(Input::get('votingstartdate'), $timezone, 'UTC', 'Y-m-d H:i:s');
     $inputdetails['votingenddate'] = timezoneModel::convert(Input::get('votingenddate'), $timezone, 'UTC', 'Y-m-d H:i:s');
     if (Input::file('themephoto') != '') {
         $destinationPath = 'public/assets/upload/contest_theme_photo';
         $filename = Input::file('themephoto')->getClientOriginalName();
         $Image = str_random(8) . '_' . $filename;
         $inputdetails['themephoto'] = $Image;
     }
     $contestid = Input::get('contestid');
     $updaterules = array('contest_name' => 'required|unique:contest,contest_name,' . $contestid, 'conteststartdate' => 'required', 'contestenddate' => 'required', 'votingstartdate' => 'required', 'votingenddate' => 'required', 'noofparticipant' => 'required', 'contesttype' => 'required');
     $validation = Validator::make($inputdetails, $updaterules);
     if ($validation->passes()) {
         if (Input::file('themephoto') != '') {
             $file = Input::file('themephoto');
             $uploadSuccess = $file->move($destinationPath, $Image);
         }
         $updatedata = $inputdetails;
         $affectedRows = contestModel::where('ID', $contestid)->update($updatedata);
         $interest_id = Input::get('interest_id');
         $interestid = explode(',', $interest_id);
         $interestidcount = count($interestid);
         $interest['contest_id'] = $contestid;
         $deleteoldid = contestinterestModel::where('contest_id', $contestid)->delete();
         for ($i = 0; $i < $interestidcount; $i++) {
             $interest['category_id'] = $interestid[$i];
             //return $interest;
             $validationinterest = Validator::make($interest, contestinterestModel::$rules);
             if ($validationinterest->passes()) {
                 $userregister = contestinterestModel::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' => "c115");
         $final = array("response" => $Response);
         return json_encode($final);
     }
 }
예제 #5
0
    public function update_contest()
    {
        $inputdetails = Input::except(array('_token', 'themephoto', 'sponsor', 'sponsorphoto', 'interest', 'contest_id', 'client_login', 'enable'));
        $contest_id = Input::get('contest_id');
        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;
        }
        $lantyp = Session::get('language');
        if ($lantyp == "") {
            $lantyp = "value_en";
        }
        $rules = array('contest_name' => 'required|unique:contest,contest_name,' . $contest_id, 'conteststartdate' => 'required', 'contestenddate' => 'required', 'votingstartdate' => 'required', 'votingenddate' => 'required', 'noofparticipant' => 'required', 'contesttype' => 'required');
        if (Auth::user()->ID == 1) {
            $inputdetails['sponsorname'] = Input::get('sponsorname');
            //return Input::file('sponsorphoto');
            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;
            }
        }
        $usertimezone = contestModel::select('user.email', 'user.timezone', 'user.firstname', 'user.lastname', 'user.username', 'contest.contest_name', 'contest.themephoto')->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->where('contest.ID', $contest_id)->first();
        $validation = Validator::make($inputdetails, $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'])), $usertimezone->timezone, 'UTC', 'Y-m-d H:i:s');
                $inputdetails['contestenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['contestenddate'])), $usertimezone->timezone, 'UTC', 'Y-m-d H:i:s');
                $inputdetails['votingstartdate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingstartdate'])), $usertimezone->timezone, 'UTC', 'Y-m-d H:i:s');
                $inputdetails['votingenddate'] = timezoneModel::convert(date('Y-m-d H:i:s', strtotime($inputdetails['votingenddate'])), $usertimezone->timezone, 'UTC', 'Y-m-d H:i:s');
            }
            //$inputdetails['visibility']="p";
            if (Auth::user()->ID == 1) {
                $inputdetails['visibility'] = Input::get('visibility');
            } else {
                $inputdetails['visibility'] = "p";
            }
            $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);
                    }
                    unset($interes);
                }
            } else {
                contestinterestModel::where('contest_id', '=', $contest_id)->delete();
            }
            $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);
            }
            contestModel::where('ID', $contest_id)->update($inputdetails);
            if (Auth::user()->ID == 1) {
                if ($usertimezone->firstname != '') {
                    $name = $usertimezone->firstname . ' ' . $usertimezone->lastname;
                } else {
                    $name = $usertimezone->username;
                }
                $contestname = $usertimezone->contest_name;
                $themephoto = $usertimezone->themephoto;
                $email = $usertimezone->email;
                if ($usertimezone->createdby != 1) {
                    $contestdetailsformail = contestModel::select('user.email', 'user.timezone', 'user.firstname', 'user.lastname', 'user.username', 'contest.contest_name', 'contest.themephoto', 'contest.description', 'contest.noofparticipant', 'contest.conteststartdate', 'contest.contestenddate', 'contest.votingstartdate', 'contest.votingenddate', 'contest.contesttype', 'contest.visibility', 'contest.status', 'contest.sponsorname')->LeftJoin('user', 'user.ID', '=', 'contest.createdby')->where('contest.ID', $contest_id)->first();
                    if ($contestdetailsformail->status == 1) {
                        $status = "Active";
                    } else {
                        $status = "Inactive";
                    }
                    if ($contestdetailsformail->visibility == "p") {
                        $visibility = "Private";
                    } else {
                        $visibility = "Public";
                    }
                    $timezone = $contestdetailsformail->timezone;
                    if ($contestdetailsformail->contesttype == "p") {
                        $contesttype = "Photo";
                    } elseif ($contestdetailsformail->contesttype == "v") {
                        $contesttype = "Video";
                    } else {
                        $contesttype = "Topic";
                    }
                    $details = '<div styel"float:left;">
						<table width="500" height="95" border="1" 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;">Contest Name:</td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $contestdetailsformail->contest_name . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Contest Image:</td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;"><img src=' . URL::to('public/assets/upload/contest_theme_photo/' . $contestdetailsformail->themephoto) . ' width="150" height="150" /></td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Contest Type:</td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $contesttype . '</td>
					  </tr>
					   <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Status </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $status . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Contest Start date </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . timezoneModel::convert($contestdetailsformail->conteststartdate, 'UTC', $timezone, 'd-m-Y H:i:s') . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Contest end date </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . timezoneModel::convert($contestdetailsformail->contestenddate, 'UTC', $timezone, 'd-m-Y H:i:s') . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Voting start date </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . timezoneModel::convert($contestdetailsformail->votingstartdate, 'UTC', $timezone, 'd-m-Y H:i:s') . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Voting end date </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . timezoneModel::convert($contestdetailsformail->votingenddate, 'UTC', $timezone, 'd-m-Y H:i:s') . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Visibility </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $visibility . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">Sponsor </td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $contestdetailsformail->sponsorname . '</td>
					  </tr>
					  <tr>
						<td style="font-size:12px;color: #3BBA00;font-weight:bold;">No of participant</td>
						<td style="font-size:12px;color: #5d5d5d;font-weight:bold;">' . $contestdetailsformail->noofparticipant . '</td>
					  </tr>
					  					  				  
					</table>
					</div>';
                    $this->editcontestmail($email, $name, $contestname, $themephoto, $contest_id, $details);
                }
                $er_data['Message'] = 'Updated successfully';
                return Redirect::to('edit_contest/' . $contest_id)->with('er_data', $er_data);
            } else {
                return Redirect::to('/contest_info/' . $contest_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');
            }
            $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])->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>";
                }
            }
            return Redirect::to('edit_contest/' . $contest_id)->with('er_data', $er_data)->with('old_data', $inputdetails);
        }
    }