/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('settings', function (Blueprint $table) {
$table->increments('id');
$table->string('laralum_version');
$table->string('website_title');
$table->string('logo');
$table->string('button_color');
$table->string('header_color');
$table->string('pie_chart_source');
$table->string('bar_chart_source');
$table->string('line_chart_source');
$table->string('geo_chart_source');
$table->timestamps();
});
$settings = new Settings();
$settings->laralum_version = "2.1.3";
$settings->website_title = env('APP_NAME', 'My Application');
$settings->logo = '';
//Default logo will load
$settings->button_color = "blue";
$settings->header_color = "#1678c2";
$settings->pie_chart_source = "highcharts";
$settings->bar_chart_source = "highcharts";
$settings->line_chart_source = "highcharts";
$settings->geo_chart_source = "highcharts";
$settings->save();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('settings')->delete();
$settings = new Settings();
$settings->email = '*****@*****.**';
$settings->description = 'Уникальность нашего сайта состоит в том, что покупатель выставляет свое объявление, а продавец автомобиля ищет именно то, объявление, где есть сходство с его автомобилем!';
$settings->save();
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
view()->composer('*', function ($view) {
$settings = Settings::lists('value', 'name');
$view->with('data', $settings);
});
}
/**
* Execute the job.
*
* @return void
*/
public function handle(Mailer $mail)
{
$group = $this->ticket->group_id;
$customers = Group::where('id', $group)->first()->customers()->get();
$_customers = [];
foreach ($customers as $customer) {
$_customers[] = $customer->id;
}
$sys_name = Settings::where('name', 'sys_name')->first();
$user = User::whereIn('customer_id', $_customers)->get();
foreach ($user as $_user) {
$mail->send('emails.updateticket', ['user' => $_user, 'ticket' => $this->ticket, 'response' => $this->response, 'sys_name' => $sys_name], function ($m) use($_user) {
$m->to($_user->email, $_user->first_name . ' ' . $_user->last_name)->subject('Ticket updated - ' . $this->ticket->track_id . ' [' . $this->ticket->status->name . ']');
if (count($this->response->attachments()->get()) > 0) {
foreach ($this->response->attachments as $attachment) {
$m->attach(storage_path() . '/attachments/' . $this->ticket->id . '/' . $attachment->name);
}
}
});
}
// Cleanup variables
unset($this->ticket);
unset($this->response);
unset($group);
unset($customers);
unset($user);
unset($sys_name);
unset($_customers);
}
public function feedbackSave(Request $request)
{
$rules = ['name' => 'required', 'email' => 'required_if:phone,""', 'phone' => 'required_if:email,""', 'message' => 'required'];
$messages = ['name.required' => 'Введите Ваше имя. Мы же должны как-то к Вам обращаться :)', 'email.required_if' => 'А где же ваш email для обратной связи?', 'phone.required_if' => 'Укажите пожалуйста Ваш телефончик для обратной связи', 'message.required' => 'А где собственно сообщение?'];
$validator = Validator::make($request->all(), $rules, $messages);
$validator->after(function ($validator) use($request) {
if (app()->environment() == 'production') {
$recaptcha = new ReCaptcha(env('GOOGLE_RECAPTCHA_SECRET'));
$resp = $recaptcha->verify($request->get('g-recaptcha-response'), $_SERVER['REMOTE_ADDR']);
if (!$resp->isSuccess()) {
$validator->errors()->add('google_recaptcha_error', 'Ошибка reCAPTCHA: ' . implode(', ', $resp->getErrorCodes()));
}
}
});
if ($validator->fails()) {
$this->throwValidationException($request, $validator);
}
$data = $request->all();
$settings = Settings::find(1);
Mail::queue(['text' => 'emails.feedback'], ['data' => $data], function ($message) use($data, $settings) {
$message->from(env('MAIL_ADDRESS'), env('MAIL_NAME'));
$message->to(isset($settings->email) ? $settings->email : env('MAIL_ADDRESS'));
$message->subject('Обратная связь');
});
if ($request->ajax()) {
return response()->json(['status' => 'success', 'message' => 'Сообщение отправлено']);
}
Flash::success("Сообщение отправлено");
return redirect('/');
}
/**
* Removes Cache when settings or pages(for navbar menu) are changed
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (preg_match('/page|settings\\/[update|store|destroy|action|activate|sort]/', $request->path(), $res)) {
Settings::removeCache();
}
return $next($request);
}
public function get($token)
{
$retval = array();
$retval['status'] = 1;
$options = Input::only('fields');
$vendor = new Vendor();
$cell = $vendor->getCellNumber($token);
$settings = new Settings();
if (isset($options['fields'])) {
$filters = explode(',', $options['fields'], Settings::NUM_SETTINGS + 1);
foreach ($filters as $name) {
$retval[$name] = $settings->get($cell, $name);
}
}
return $retval;
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, ['subject' => 'required|max:255', 'product' => 'required', 'group' => 'required', 'severity' => 'required', 'description' => 'required']);
$settings = Settings::where('name', 'ticket_track_id')->first();
$track_id = $settings->str_value;
$customer = Customer::where('id', $this->my_customer_id)->first();
$search_strings = ['%COMPANY_NAME', '%Y', '%m', '%d'];
$value_strings = [str_replace(' ', '_', $customer->name), date('Y', time()), date('m', time()), date('d', time())];
$track_id = str_replace($search_strings, $value_strings, $track_id);
$ticket = Ticket::create(['subject' => $request->subject, 'track_id' => $track_id, 'description' => $request->description, 'group_id' => $request->group, 'severity_id' => $request->severity, 'product_id' => $request->product, 'user_id' => $this->my_id, 'customer_id' => $this->my_customer_id, 'status_id' => 1]);
if (isset($request->attachments)) {
foreach ($request->attachments as $attachment) {
// Check that the directory exists
$uploadPath = storage_path() . '/attachments/' . $ticket->id;
$fs = new Filesystem();
if (!$fs->isDirectory($uploadPath)) {
// Create the directory
$fs->makeDirectory($uploadPath);
}
$attachment->move($uploadPath, $attachment->getClientOriginalName());
$_attachment = Attachment::create(['user_id' => $this->my_id, 'name' => $attachment->getClientOriginalName(), 'ticket_id' => $ticket->id]);
}
}
$this->dispatch(new EmailNewTicket($ticket));
return redirect('/tickets');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (!Settings::item('page_map')) {
abort(404);
}
$apartment = Apartment::active()->where('map_lat', '!=', '')->where('map_lng', '!=', '')->paginate(50);
return view('map.index', ['apartments' => $apartment]);
}
public function run()
{
DB::table('settings')->delete();
Settings::create(['logo' => '', 'title' => 'News Letter', 'subtitle' => 'Latest News Ever!', 'description' => 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s
standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it
to make a type specimen book. It has survived not only five centuries, but also the leap into
electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of
Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus
PageMaker including versions of Lorem Ipsum.', 'theme' => '']);
}
/**
* Create a new authentication controller instance.
*
* @return void
*/
public function __construct()
{
if (!Settings::get('auth.loginenabled', true)) {
$this->middleware('auth.disablelogin');
}
if (!Settings::get('auth.registerenabled', true)) {
$this->middleware('auth.disableregistering');
}
$this->middleware('guest', ['except' => 'logout']);
}
public function save(Request $request)
{
$settings = Settings::findOrNew(1);
$settings->id = 1;
$settings->fill($request->all());
//dd($settings);
$settings->save();
Flash::success("Настройки сохранены ");
return redirect(route('admin.settings'));
}
/**
* Store new account
*
*/
public function store(Request $request)
{
$user = new User();
$user->name = $request->input('name');
$user->username = $request->input('username');
$user->email = $request->input('email');
$pass = $request->input('password');
$user->role = 'Owner';
if (!empty($pass)) {
$user->password = bcrypt($pass);
}
$user->save();
// Create Company
$company = new Company();
$company->name = $request->input('company_name');
$company->email = $request->input('company_email');
$company->address1 = $request->input('address1');
$company->address2 = $request->input('address2');
$company->city = $request->input('city');
$company->postcode = $request->input('postcode');
$company->url = strtolower(str_replace(' ', '', $request->input('company_name')));
$company->save();
$user->company_id = $company->id;
$user->update();
$company->user_id = $user->id;
$company->update();
$settings = new Settings();
$settings->application_id = 1;
$settings->references_id = 0;
$settings->company_id = $company->id;
$settings->save();
$refs = new ReferenceFields();
$refs->settings_id = $settings->id;
$refs->company_id = $company->id;
$refs->save();
$options = new Settings();
$options->references_id = 1;
$options->application_id = 0;
$options->company_id = $company->id;
$options->save();
flash()->success('Success', 'Account successfully created');
return back();
}
public static function getUserSettings($user_id)
{
$default_settings = ['user_id' => $user_id, 'nickname' => Auth::user()->username, 'enable_chat' => 1, 'editor_font' => 'Consolas', 'editor_font_color' => 'Black'];
if (!Settings::where('user_id', $user_id)->exists()) {
$settings = Settings::create($default_settings);
} else {
$settings = Settings::where('user_id', $user_id)->first();
}
return $settings;
}
public function update(Request $request)
{
Laralum::permissionToAccess('laralum.settings.access');
# Check permissions
Laralum::permissionToAccess('laralum.settings.edit');
$row = Settings::first();
$data_index = 'settings';
require 'Data/Edit/Save.php';
return redirect('admin/settings')->with('success', "The settings have been updated");
}
public function emailFormSucceeded(Form $form, $values)
{
$settings = $this->EntityManager->getRepository(Settings::getClassName());
$setting = $settings->find(1);
$mail = new Message();
$mail->setFrom($values['email'])->addTo($setting->admin_email)->setSubject('Zpráva z webu PeTr - ' . $values['subject'])->setBody('Zpráva od ' . $values['name'] . '<br /><br />' . $values['message']);
$mailer = new SendmailMailer();
//$mailer->send($mail);
$this->redirect('Contact:sent');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function save(Request $request)
{
$departments = $request->get('department');
foreach ($departments as $id => $department) {
Settings::where('department_id', $id)->delete();
foreach ($department as $key => $value) {
Settings::create(['department_id' => $id, 'key' => $key, 'value' => $value]);
}
}
return redirect()->action('Admin\\SettingsController@display')->with('success', 'updated');
}
public function __construct()
{
$this->globalSiteSettings = Cache::remember('settings', 3600, function () {
$array = array();
$settings = Settings::all();
foreach ($settings as $setting) {
$array = array_add($array, $setting->name, $setting->value);
}
return $array;
});
view()->share('globalSiteSettings', $this->globalSiteSettings);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
foreach ($request->input('setting') as $key => $value) {
$setting = Settings::where('name', $key);
if ($setting->get()->count() > 0) {
$setting->first()->update(['name' => $key, 'value' => $value]);
} else {
Settings::create(['name' => $key, 'value' => $value]);
}
}
return back()->withSuccess('Settings saved successfully!');
}
/**
* Export PDF application form
*
* @param Request $request
* @return \Illuminate\Http\Response
*/
public function exportApplication(Request $request)
{
$name = 'application';
$pdfFilename = urlencode(strtolower($name . '-' . date('d-m-Y') . '.pdf'));
$ref = References::where('applications_id', '=', $request->segment(4))->first();
$refOne = References::where('id', $request->input('ref_one'))->first();
$refTwo = References::where('id', $request->input('ref_two'))->first();
$settings = Settings::where('company_id', '=', Auth::user()->company_id)->where('references_id', '=', 0)->first();
$custom = Fields::where('settings_id', $settings->id)->where('application_id', '=', $request->segment(4))->get();
$pdf = PDF::loadView('pdf.application', compact('refOne', 'refTwo', 'ref', 'custom', 'settings'));
return $pdf->download($pdfFilename);
}
public static function get($cell, $name)
{
$retval = 'undefined';
if ($name == Settings::INITIAL_EMPTY_POSITIONS || $name == Settings::PERIODIC_EMPTY_POSITION) {
$retval = 0;
}
try {
$results = Settings::where(array('cell' => $cell, 'name' => $name))->firstOrFail();
$retval = $results->value;
} catch (\Exception $e) {
}
return $retval;
}
public function store(ContactRequest $request)
{
if (!Settings::item('page_contact') or !Settings::item('contact_form')) {
abort(404);
}
$data = ['name' => $request->name, 'title' => 'Laravel5: ' . $request->title, 'text' => $request->text, 'email' => $request->email, 'admin_email' => Settings::item('admin_email')];
Mail::send('emails.contact', $data, function ($message) use($data) {
$message->from($data['email'], $data['name']);
$message->subject($data['title']);
$message->to($data['admin_email']);
});
return back()->with(['message' => trans('front/contact.send_success')]);
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @param string|null $guard
* @return mixed
*/
public function handle($request, Closure $next, $guard = null)
{
if (Auth::guard($guard)->guest()) {
if ($request->ajax()) {
return response('Unauthorized.', 401);
} else {
if (Settings::get('auth.loginenabled', true)) {
return redirect()->guest('login');
} else {
return redirect()->guest('/');
}
}
}
return $next($request);
}
/**
* Edit the Settings.
*
* @return Response
*/
public function postSettings(Request $request)
{
$settings = $request->all();
$oldSettings = Settings::where('id', '!=', '')->first();
// Rename and upload file
if ($request->file('logo')) {
$file = $request->file('logo');
$fileName = str_random(6) . '_' . $file->getClientOriginalName();
$file->move(public_path() . '/uploads', $fileName);
$settings['logo'] = $fileName;
}
$oldSettings->fill($settings);
$oldSettings->save();
return Redirect('/admin/settings')->with('message', Lang::get('admin/settings/message.edit.success'));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('settings', function (Blueprint $table) {
$table->increments('id');
$table->string('web_name');
$table->text('description');
$table->string('keywords');
$table->string('icp');
$table->text('stat_code');
$table->string('copyright');
$table->string('email');
$table->timestamps();
});
\App\Settings::create(['web_name' => '优禾尚鲜', 'description' => '提供高品质主食', 'keywords' => '优禾尚鲜', 'icp' => '', 'stat_code' => '', 'copyright' => '优禾尚鲜©版权所有', 'email' => '*****@*****.**']);
}
public function edit(Request $request)
{
$id = 0;
if (isset($request->id)) {
$id = $request->id;
}
$modelData = new \stdClass();
if ($id > 0) {
try {
$modelData = Settings::findOrFail($id);
} catch (ModelNotFoundException $e) {
session()->flash('message', trans('admin_common.Invalid Setting'));
return redirect(url('admin/settings'));
}
}
/**
* form is submitted check values and save if needed
*/
if ($request->isMethod('post')) {
/**
* validate data
*/
$rules = ['setting_value' => 'required'];
$validator = Validator::make($request->all(), $rules);
if ($validator->fails()) {
$this->throwValidationException($request, $validator);
}
/**
* get data from form
*/
$data = $request->all();
/**
* save or update
*/
if (!isset($modelData->setting_id)) {
Settings::create($data);
} else {
$modelData->update($data);
}
/**
* clear cache, set message, redirect to list
*/
Cache::flush();
session()->flash('message', trans('admin_common.Setting saved'));
return redirect(url('admin/settings'));
}
return view('admin.settings.settings_edit', ['modelData' => $modelData]);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create(Request $request)
{
$data = Tool::removeSpace($request->all());
$validator = Validator::make($data, ["hora_prueba" => "required|valid_time", "duración_prueba" => "required|valid_minute"]);
$toArray = $validator->errors()->toArray();
if ($validator->fails()) {
return redirect()->back()->withInput()->withErrors($validator->errors());
}
$chedumalTrial = Settings::where('field', '=', 'Schedumal_trial')->first();
$durationTrial = Settings::where('field', '=', 'Duration_trial')->first();
if ($chedumalTrial->value != $data['hora_prueba']) {
DB::table('rb_settings')->where('field', 'Schedumal_trial')->update(['value' => $data['hora_prueba']]);
}
if ($durationTrial->value != $data['duración_prueba']) {
DB::table('rb_settings')->where('field', 'Duration_trial')->update(['value' => $data['duración_prueba']]);
}
return $this->index();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Settings::truncate();
Settings::create(['name' => 'blogtitle', 'value' => 'CODEMAN']);
Settings::create(['name' => 'contactemail', 'value' => '']);
Settings::create(['name' => 'github', 'value' => '']);
Settings::create(['name' => 'twitter', 'value' => '']);
Settings::create(['name' => 'linkedin', 'value' => '']);
Settings::create(['name' => 'dateofbirth', 'value' => '']);
Settings::create(['name' => 'name', 'value' => '']);
Settings::create(['name' => 'location', 'value' => '']);
Settings::create(['name' => 'mobile', 'value' => '']);
Settings::create(['name' => 'email', 'value' => '']);
Settings::create(['name' => 'website', 'value' => '']);
Settings::create(['name' => 'resume', 'value' => '']);
Settings::create(['name' => 'gender', 'value' => '']);
Settings::create(['name' => 'headercode', 'value' => '']);
}
public function update(Request $request)
{
$data = $request->all();
foreach (Settings::$default as $name => $key) {
if (isset($data[$name])) {
$data[$name] = is_array($data[$name]) ? json_encode($data[$name]) : $data[$name];
Settings::where('name', $name)->update(['value' => $data[$name]]);
}
}
$user_data = ['name' => $data['name'], 'email' => $data['admin_email']];
if ($data['password']) {
if ($data['password'] != $data['password_confirm']) {
return back()->withErrors(trans('admin/settings.message.password_not_match'));
}
$user_data['password'] = bcrypt($data['password']);
}
User::find(1)->update($user_data);
return back()->with(['message' => trans('admin/settings.message.update_success')]);
}
public static function sliderPhotoArray($text = true, $slide = true, $id = false)
{
$apartments = Apartment::sliderOrId($id)->active()->get();
$currency = Settings::item('currency');
$photos['path'] = [];
$photos['slide'] = $slide;
foreach ($apartments as $apartment) {
if ($id) {
$photos['path'] = array_pluck(self::photoArray($apartment->photos, $apartment->id), 'path');
// show apartment page
} else {
$photos['path'][] = self::firstPhoto($apartment->photos, $apartment->id, false);
// home page
}
if ($text) {
$photos['text'][] = '<a href="' . Url('/apartment/' . $apartment->id) . add_slug($apartment->slug) . '">' . $apartment->street . ', ' . $apartment->house . ' <br /> ' . $apartment->price . ' ' . trans('admin/settings.main.' . $currency) . '/' . trans('front/apartment.night') . '</a>';
}
}
$photos['count'] = count($photos['path']);
return $photos;
}