File: /var/www/vhost/disk-apps/demo.sports-crowd.com/app/Http/Controllers/DataPolicyController.php
<?php
namespace App\Http\Controllers;
use App\DataPolicy;
use App\DataPolicyClient;
use DataTables;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Storage;
class DataPolicyController extends Controller
{
public function index()
{
return view('data_policy.list');
}
public function indexAdd()
{
return view('data_policy.create');
}
public function indexEdit($id)
{
$object = DataPolicy::findOrFail($id);
return view('data_policy.edit', compact('object'));
}
public function tableFilter()
{
$obj = DataPolicy::select('id', 'url', 'version', 'active', 'created_at')->get();
return DataTables::of($obj)
->addColumn('actions', function ($obj) {
return '
<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('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('created_at', function ($obj) {
return \Carbon\Carbon::parse($obj->created_at)->format('Y-m-d h:i:s A');
})
->rawColumns(['actions', 'active'])
->make(true);
}
public function create(Request $request)
{
try {
if (DataPolicy::where('version', $request->input('version'))->first()) {
return response(array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __('messages.already_exists', ['name' => $request->input('version')]),
"data" => null
));
}
$data = $request->all();
if ($model = DataPolicy::create($data)) {
$this->registerLog(
Auth::user()->id,
'Crear politica de datos',
json_encode($request->all()),
"Create",
$this->getModule($request)
);
Cache::forget('policies');
return response(array(
"r" => true,
"type" => "success",
"title" => "",
"m" => __('messages.created_successfully'),
"data" => $model->id
));
} else {
return response(array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __('messages.error_creating'),
"data" => null
));
}
} catch (\Exception $e) {
return response(
array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __($e->getMessage()),
"data" => null
)
);
}
}
public function update(Request $request, $id)
{
try {
$request['id'] = $id;
if (DataPolicy::where([['id', '!=', $id], ['version', $request->input('version')]])->first()) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('version')]), "data" => null));
}
$data = $request->all();
if (DataPolicy::where('id', $id)->update($data)) {
$this->registerLog(Auth::user()->id, 'Editar términos y condiciones', json_encode($request->all()), "Update", $this->getModule($request));
Cache::forget('policies');
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));
}
} catch (\Exception $e) {
return response(
array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __($e->getMessage()),
"data" => null
)
);
}
}
public function delete(Request $request, $id)
{
try {
$policy = DataPolicy::find($id);
if (DataPolicy::where('id', $id)->delete()) {
$this->registerLog(Auth::user()->id, 'Eliminar términos y condiciones', json_encode($policy), "Delete", $this->getModule($request));
Cache::forget('policies');
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));
}
} catch (\Illuminate\Database\QueryException $e) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.delete_relation_data'), "data" => null));
}
}
public function activate(Request $request)
{
try {
$id = $request['id'];
$state = $request['state'];
if ($state) {
$activePolicy = DataPolicy::where('active', true)->count();
if ($activePolicy) {
return array('r' => false, 'm' => __('messages.terms_conditions.error_active'));
}
}
$policy = DataPolicy::find($id);
$policy->active = $state;
$policy->update();
$this->registerLog(Auth::user()->id, 'Activar/Desactivar términos y condiciones', json_encode($policy), "Update", $this->getModule($request));
Cache::forget('policies');
return array('r' => true, 'm' => __('messages.updated_successfully'));
} catch (\Throwable $th) {
return array('r' => false, 'm' => __('messages.error_updating'));
}
}
public function saveDocument(Request $request)
{
try {
$extension = $this->extension($request->file('image')->getMimeType());
if ($extension != 'pdf') {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_file_pdf')));
}
$filenametostore = 'data_policy' . $request->id . '.' . $extension;
Storage::disk('s3')->put(config('s3.default') . '/public/' . $filenametostore, fopen($request->file('image'), 'r+'), 'public');
$url = config('filesystems.disks.s3.url') . '/public/' . $filenametostore;
DataPolicy::where('id', $request->id)->update(['url' => $url]);
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()));
}
}
public function validateDataPolicy()
{
$userId = Auth::user()->id;
$result = DataPolicy::select('data_policies.id', 'data_policies.version', 'data_policies.url')
->leftJoin('data_policy_clients as tc', function ($join) use ($userId) {
$join->on('tc.data_policy_id', '=', 'data_policies.id')
->where('tc.user_id', '=', $userId);
})
->whereNull('data_policies.deleted_at')
->where('data_policies.active', true)
->whereNull('tc.id')
->orderBy('data_policies.created_at', 'DESC')
->limit(1);
$result = $result->get();
return $result;
}
public function accept(Request $request)
{
$userId = Auth::user()->id;
DataPolicyClient::updateOrCreate([
'accepted' => $request['accepted'] ?? true,
'data_policy_id' => $request['id'],
'user_id' => $request['userId'] ?? $userId,
]);
return array('r' => true, 'm' => __('messages.data_policy.accepted'));
}
public function getActivePolicy()
{
if (!Cache::get('policies')) {
$policies = DataPolicy::select('id', 'version', 'url', 'active')->where("active", 1)->orderBy('created_at', 'DESC')->first();
Cache::put('policies', $policies, config('cache.time'));
} else {
$policies = Cache::get('policies');
}
return $policies;
}
}