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