File: /var/www/vhost/disk-apps/demo.sports-crowd.com/app/Http/Controllers/FormsController.php
<?php
namespace App\Http\Controllers;
use DB;
use App\Tag;
use App\Form;
use DataTables;
use App\FormTag;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;
use App\Http\Controllers\UtilController;
class FormsController extends Controller
{
private $util;
public function __construct()
{
$this->util = new UtilController();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return view('forms.list');
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$multiselectItems = Tag::where('active', true)->get();
return view('forms.create')->with('multiselectItems', $multiselectItems);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
if (!Form::where('name', $request->input('name'))->first()) {
$tags = $request["tags"];
$request->request->remove('tags');
if ($form = Form::create($request->all())) {
if ($tags != null) {
foreach ($tags as $tagId) {
FormTag::create([
'tag_id' => $tagId,
'form_id' => $form->id
]);
}
}
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $form->id));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
}
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
return redirect()->back();
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$form = Form::findOrFail($id);
$multiselectItems = Tag::where('active', true)->get();
$multiselectValues = FormTag::select('tag_id')->where('form_id', $id)->get();
return view('forms.edit', compact('form'))
->with('multiselectItems', $multiselectItems)
->with('multiselectValues', $multiselectValues);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
if (!Form::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
$tags = $request["tags"];
$request->request->remove('tags');
if (Form::where('id', $id)->update(array_slice($request->all(), 1))) {
FormTag::where('form_id', $id)->delete();
if ($tags != null) {
foreach ($tags as $tagId) {
FormTag::create([
'tag_id' => $tagId,
'form_id' => $id
]);
}
}
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => $id));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
}
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
if (Form::where('id', $id)->delete()) {
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.deleted_successfully'), "data" => null));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_removing'), "data" => null));
}
}
public function tableFilter()
{
DB::statement("SET sql_mode = ''");
$obj = Form::select(
'forms.id',
'forms.image',
'forms.name',
'forms.description',
'forms.priority',
'forms.active',
'forms.show_in_home',
'forms.show_in_setting',
'forms.show_text',
'forms.multiple_answers',
DB::raw('GROUP_CONCAT(DISTINCT(tags.name)) AS segmentation')
)
->leftjoin('form_tags', 'forms.id', '=', 'form_tags.form_id')
->leftjoin('tags', function ($join) {
$join->on('tags.id', '=', 'form_tags.tag_id')->where('tags.active', 1);
})
->groupBy('forms.id')
->orderBy('forms.id', 'DESC');
DB::statement("SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");
return DataTables::of($obj)
->addColumn('actions', function ($obj) {
return '
<i class="fa fa-list-alt iconMini" onClick="clickFormFields(' . $obj->id . ')" data-id="' . $obj->id . '" title="Listado campos"></i>
<i class="fa fa-pencil iconMini" onClick="clickEdit(' . $obj->id . ')" data-id="' . $obj->id . '" title="Editar"></i>
<i class="fa fa-trash iconMini" onClick="clickDelete(' . $obj->id . ')" data-id="' . $obj->id . '" title="Eliminar"></i>
';
})
->editColumn('image', function ($obj) {
if (!$obj->image) {
return $this->util->generateEmptyImageColumn();
} else {
return $this->util->generateImageColumn(config('filesystems.disks.s3.url') . '/form/' . $obj->image, $obj->name, 'form' . $obj->id);
}
})
->editColumn('active', function ($obj) {
if ($obj->active == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->editColumn('show_in_home', function ($obj) {
if ($obj->show_in_home == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowInHome(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowInHome' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowInHome(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowInHome' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->editColumn('show_in_setting', function ($obj) {
if ($obj->show_in_setting == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowInSettings(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowInSettings' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowInSettings(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowInSettings' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->editColumn('show_text', function ($obj) {
if ($obj->show_text == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowText(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowText' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkShowText(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkShowText' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->editColumn('multiple_answers', function ($obj) {
if ($obj->multiple_answers == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkMultipleAnswers(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkMultipleAnswers' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chkMultipleAnswers(' . $obj->id . ')" data-id="' . $obj->id . '" id="chkMultipleAnswers' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->rawColumns(['active', 'actions', 'image', 'show_in_home', 'show_in_setting', 'show_text', 'multiple_answers'])
->make(true);
}
public function activate(Request $request)
{
$id = $request['id'];
$state = $request['state'];
$form = Form::find($id);
$form->active = $state;
$form->update();
if ($form) {
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} else {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
public function showInHome(Request $request)
{
$id = $request['id'];
$state = $request['state'];
$form = Form::find($id);
$form->show_in_home = $state;
$form->update();
if ($form) {
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} else {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
public function showInSettings(Request $request)
{
$id = $request['id'];
$state = $request['state'];
$form = Form::find($id);
$form->show_in_setting = $state;
$form->update();
if ($form) {
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} else {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
public function showText(Request $request)
{
$id = $request['id'];
$state = $request['state'];
$form = Form::find($id);
$form->show_text = $state;
$form->update();
if ($form) {
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} else {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
public function multipleAnswers(Request $request)
{
$id = $request['id'];
$state = $request['state'];
$form = Form::find($id);
$form->multiple_answers = $state;
$form->update();
if ($form) {
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} else {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
public function saveImage(Request $request)
{
try {
$extension = $request->file('image')->getClientOriginalExtension();
$filenametostore = $request->id . '.' . $extension;
Storage::disk('s3')->put(config('s3.form') . $filenametostore, fopen($request->file('image'), 'r+'), 'public');
$dorsal = Form::find($request->id);
$dorsal->image = $filenametostore;
$dorsal->update();
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => null));
} catch (\Throwable $th) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => $th->getMessage()));
}
}
}