| Server IP : 66.29.137.217 / Your IP : 18.118.253.134 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/gle.gltechlimited.com/app/Http/Controllers/ |
Upload File : |
<?php
namespace App\Http\Controllers;
use App\Audio;
use App\AudioLanguage;
use App\Genre;
use App\Menu;
use App\MenuVideo;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Crypt;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Facades\Validator;
use Intervention\Image\Facades\Image;
class AudioController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function __construct()
{
$this->middleware('permission:audio.view', ['only' => ['index']]);
$this->middleware('permission:audio.create', ['only' => ['create', 'store']]);
$this->middleware('permission:audio.edit', ['only' => ['edit', 'update']]);
$this->middleware('permission:audio.delete', ['only' => ['destroy', 'bulk_delete']]);
}
public function index(Request $request)
{
if ($request->search != null) {
$audio = DB::table('audio')->where('tilte', 'like', '%' . $request->search . '%')->select('id', 'title', 'genre_id', 'thumbnail', 'poster', 'rating', 'featured')->orderBy('id', 'DESC')->paginate(12);
} else {
$audio = DB::table('audio')->select('id', 'title', 'genre_id', 'thumbnail', 'poster', 'rating','detail', 'featured')->orderBy('id', 'DESC')->paginate(12);
}
return view('admin.audio.index', compact('audio'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$menus = Menu::all();
$genre_ls = Genre::pluck('name', 'id')->all();
$a_lans = AudioLanguage::pluck('language', 'id')->all();
return view('admin.audio.create', compact('menus', 'a_lans', 'genre_ls'));
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
if (env('DEMO_LOCK') == 1) {
return back()->with('deleted', __('This action is disabled in the demo !'));
}
$menus = null;
$request->validate(['title' => 'required']);
if (isset($request->menu) && count($request->menu) > 0) {
$menus = $request->menu;
}
$input = $request->all();
$a_lans = $request->input('a_language');
if ($a_lans) {
$a_lans = implode(',', $a_lans);
$input['a_language'] = $a_lans;
} else {
$input['a_language'] = null;
}
if (!isset($input['featured'])) {
$input['featured'] = 0;
}
$thumbnail = null;
$poster = null;
if ($file = $request->file('thumbnail')) {
$validator = Validator::make(
[
'thumbnail' => $request->thumbnail,
'extension' => strtolower($request->thumbnail->getClientOriginalExtension()),
],
[
'thumbnail' => 'required',
'thumbnail' => 'required|file|image|mimes:jpeg,png,jpg,webp',
]
);
if ($validator->fails()) {
return back()->with('deleted', __('Invalid file format Please use jpg,webp,jpeg and png image format !'))->withInput();
} else {
$thumbnail = 'thumb_' . time() . $file->getClientOriginalName();
if ($request->thumbnail != null) {
$content = @file_get_contents(public_path() . '/images/audio/thumbnails/' . $request->thumbnail);
if ($content) {
unlink(public_path() . "/images/audio/thumbnails/" . $request->thumbnail);
}
}
$img = Image::make($file->path());
$img->resize(300, 450, function ($constraint) {
$constraint->aspectRatio();
});
$img->save(public_path('/images/audio/thumbnails') . '/' . $thumbnail);
$input['thumbnail'] = $thumbnail;
}
}
if ($file = $request->file('poster')) {
$validator = Validator::make(
[
'poster' => $request->poster,
'extension' => strtolower($request->poster->getClientOriginalExtension()),
],
[
'poster' => 'required',
'poster' => 'required|file|image|mimes:jpeg,png,jpg,webp',
]
);
if ($validator->fails()) {
return back()->with('deleted',__('Invalid file format Please use jpg,webp,jpeg and png image format !'))->withInput();
} else {
$poster = 'poster_' . time() . $file->getClientOriginalName();
if ($request->poster != null) {
$content = @file_get_contents(public_path() . '/images/audio/poster/' . $request->poster);
if ($content) {
unlink(public_path() . "/images/audio/poster/" . $request->poster);
}
}
$img = Image::make($file->path());
$img->resize(300, 450, function ($constraint) {
$constraint->aspectRatio();
});
$img->save(public_path('/images/events/posters') . '/' . $poster);
$input['poster'] = $poster;
}
}
if ($request->upload_audio != null) {
if (strstr($request->upload_audio, '.mp3')) {
$input['upload_audio'] = $request->upload_audio;
} else {
return back()->withInput()->with('deleted', __('Invalid file format Please use mp3 file format !'));
}
}
$keyword = $request->keyword;
$description = $request->description;
$genre_ids = $request->input('genre_id');
if ($genre_ids) {
$genre_ids = implode(',', $genre_ids);
$input['genre_id'] = $genre_ids;
} else {
$input['genre_id'] = null;
}
if (isset($request['is_protect'])) {
$request->validate([
'password' => 'required',
]);
$input['is_protect'] = 1;
$input['password'] = Crypt::encrypt($request->password);
} else {
$input['is_protect'] = 0;
}
Audio::create($input);
return back()->with('success', __('Audio has been added'));
}
/**
* Show the form for editing the specified resource.
*
* @param \App\Audio $audio
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
$menus = Menu::all();
$genre_ls = Genre::all();
$all_languages = AudioLanguage::all();
$audio = Audio::findOrFail($id);
// get old audio language values
$old_lans = collect();
$a_lans = collect();
if ($audio->a_language != null) {
$old_list = explode(',', $audio->a_language);
for ($i = 0; $i < count($old_list); $i++) {
$old = AudioLanguage::find(trim($old_list[$i]));
if (isset($old)) {
$old_lans->push($old);
}
}
}
$a_lans = $a_lans->filter(function ($value, $key) {
return $value != null;
});
$a_lans = $all_languages->diff($old_lans);
// get old subtitle language values
// get old genre list
$old_genre = collect();
if ($audio->genre_id != null) {
$old_list = explode(',', $audio->genre_id);
for ($i = 0; $i < count($old_list); $i++) {
$old5 = Genre::find(trim($old_list[$i]));
if (isset($old5)) {
$old_genre->push($old5);
}
}
}
$genre_ls = $genre_ls->filter(function ($value, $key) {
return $value != null;
});
$genre_ls = $genre_ls->diff($old_genre);
return view('admin.audio.edit', compact('audio', 'genre_ls', 'a_lans', 'old_lans',
'old_genre', 'menus'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\Audio $audio
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
if (env('DEMO_LOCK') == 1) {
return back()->with('deleted',__('This action is disabled in the demo !'));
}
$audio = Audio::findOrFail($id);
$menus = null;
if (isset($request->menu) && count($request->menu) > 0) {
$menus = $request->menu;
}
$input = $request->except('a_language', 'genre_id', 'audio_id');
$a_lans = $request->input('a_language');
if ($a_lans) {
$a_lans = implode(',', $a_lans);
$input['a_language'] = $a_lans;
} else {
$input['a_language'] = null;
}
if (!isset($input['featured'])) {
$input['featured'] = 0;
}
$thumbnail = null;
$poster = null;
$keyword = $request->keyword;
$genre_ids = $request->input('genre_id');
if ($genre_ids) {
$genre_ids = implode(',', $genre_ids);
$input['genre_id'] = $genre_ids;
} else {
$input['genre_id'] = null;
}
if ($file = $request->file('thumbnail')) {
$validator = Validator::make(
[
'thumbnail' => $request->thumbnail,
'extension' => strtolower($request->thumbnail->getClientOriginalExtension()),
],
[
'thumbnail' => 'required',
'thumbnail' => 'required|file|image|mimes:jpeg,png,jpg,webp',
]
);
if ($validator->fails()) {
return back()->with('deleted', __('Invalid file format Please use jpg.webp,jpeg and png image format !'))->withInput();
} else {
$thumbnail = 'thumb_' . time() . $file->getClientOriginalName();
if ($audio->thumbnail != null) {
$content = @file_get_contents(public_path() . '/images/audio/thumbnails/' . $audio->thumbnail);
if ($content) {
unlink(public_path() . "/images/audio/thumbnails/" . $audio->thumbnail);
}
}
$image = $request->file('thumbnail');
$file_name = 'thumb_' . time() . '.' . $image->getClientOriginalExtension();
$destinationPath = '../public/images/audio/thumbnails';
$img = Image::make($file->path());
$img->resize(300, 450, function ($constraint) {
$constraint->aspectRatio();
});
$img->save($destinationPath . '/' . $thumbnail);
$input['thumbnail'] = $thumbnail;
}
}
if ($file = $request->file('poster')) {
$validator = Validator::make(
[
'poster' => $request->poster,
'extension' => strtolower($request->poster->getClientOriginalExtension()),
],
[
'poster' => 'required',
'poster' => 'required|file|image|mimes:jpeg,png,jpg,webp',
]
);
if ($validator->fails()) {
return back()->with('deleted', __('Invalid file format Please use jpg,webp,jpeg and png image format !'))->withInput();
} else {
$poster = 'poster_' . time() . $file->getClientOriginalName();
if ($audio->poster != null) {
$content = @file_get_contents(public_path() . '/images/audio/poster/' . $audio->poster);
if ($content) {
unlink(public_path() . "/images/audio/poster/" . $audio->poster);
}
}
$img = Image::make($file->path());
$img->resize(300, 169, function ($constraint) {
$constraint->aspectRatio();
});
$img->save(public_path('/images/audio/poster') . '/' . $poster);
$input['poster'] = $poster;
}
}
if ($request->upload_audio != null) {
if (strstr($request->upload_audio, '.mp3')) {
$input['upload_audio'] = $request->upload_audio;
} else {
return back()->withInput()->with('deleted', __('Invalid file format Please use mp3 file format !'));
}
}
if (isset($request['is_protect'])) {
$request->validate([
'password' => 'required',
]);
$input['is_protect'] = 1;
$input['password'] = Crypt::encrypt($request->password);
} else {
$input['is_protect'] = 0;
}
if ($request->slug != null) {
$input['slug'] = $request->slug;
} else {
$slug = str_slug($input['title'], '-');
$input['slug'] = $slug;
}
$audio->update($input);
if ($menus != null) {
if (count($menus) > 0) {
if (isset($audio->menus) && count($audio->menus) > 0) {
foreach ($audio->menus as $key => $value) {
$value->delete();
}
}
foreach ($menus as $key => $value) {
MenuVideo::create([
'menu_id' => $value,
'audio_id' => $audio->id,
]);
}
}
} else {
if (isset($audio->menus) && count($audio->menus) > 0) {
foreach ($audio->menus as $key => $value) {
$value->delete();
}
}
}
return redirect('/admin/audio')->with('success',__('Audio has been updated'));
}
/**
* Remove the specified resource from storage.
*
* @param \App\Audio $audio
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
if (env('DEMO_LOCK') == 1) {
return back()->with('deleted', __('This action is disabled in the demo !'));
}
$audio = Audio::findOrFail($id);
if ($audio->thumbnail != null) {
$content = @file_get_contents(public_path() . '/images/audio/thumbnails/' . $audio->thumbnail);
if ($content) {
unlink(public_path() . "/images/audio/thumbnails/" . $audio->thumbnail);
}
}
if ($audio->poster != null) {
$content = @file_get_contents(public_path() . '/images/audio/poster/' . $audio->poster);
if ($content) {
unlink(public_path() . "/images/audio/poster/" . $audio->poster);
}
}
if ($audio->upload_video != null) {
$content = @file_get_contents(public_path() . '/audio/' . $audio->upload_video);
if ($content) {
unlink(public_path() . "/audio/" . $audio->upload_video);
}
}
$audio->delete();
return back()->with('deleted', __('Audio has been deleted'));
}
public function bulk_delete(Request $request)
{
if (env('DEMO_LOCK') == 1) {
return back()->with('deleted', __('This action is disabled in the demo !'));
}
$validator = Validator::make($request->all(), [
'checked' => 'required',
]);
if ($validator->fails()) {
return back()->with('deleted', __('Please check one of them to delete'));
}
foreach ($request->checked as $checked) {
$audio = Audio::findOrFail($checked);
if ($audio->thumbnail != null) {
$content = @file_get_contents(public_path() . '/images/audio/thumbnails/' . $audio->thumbnail);
if ($content) {
unlink(public_path() . "/images/audio/thumbnails/" . $audio->thumbnail);
}
}
if ($audio->poster != null) {
$content = @file_get_contents(public_path() . '/images/audio/poster/' . $audio->poster);
if ($content) {
unlink(public_path() . "/images/audio/poster/" . $audio->poster);
}
}
if ($audio->upload_video != null) {
$content = @file_get_contents(public_path() . '/audio/' . $audio->upload_video);
if ($content) {
unlink(public_path() . "/audio/" . $audio->upload_video);
}
}
$id = $checked;
Audio::destroy($checked);
}
return back()->with('deleted', __('Audio has been deleted'));
}
public function importaudio(Request $request)
{
$validator = Validator::make(
[
'file' => $request->file,
'extension' => strtolower($request->file->getClientOriginalExtension()),
],
[
'file' => 'required',
'extension' => 'required|in:xlsx,xls,csv',
]
);
if ($validator->fails()) {
return back()->with('deleted', 'Invalid file !');
}
$filename = 'tvseries_' . time() . '.' . $request->file->getClientOriginalExtension();
Storage::disk('local')->put('/excel/' . $filename, file_get_contents($request->file->getRealPath()));
$audio = fastexcel()->import(storage_path() . '/app/excel/' . $filename);
if (count($audio)) {
$audio->each(function ($item) {
DB::beginTransaction();
try {
$audios = Audio::create([
'title' => $item['title'] != null ? $item['title'] : null,
'keyword' => $item['keyword'] != null ? $item['keyword'] : null,
'slug' => str_slug($item['title'], '-'),
'thumbnail' => $item['thumbnail'] != null ? $item['thumbnail'] : null,
'poster' => $item['poster'] != null ? $item['poster'] : null,
'genre_id' => $item['genre_id'] != null ? $item['genre_id'] : null,
'detail' => $item['detail'] != null ? $item['detail'] : null,
'rating' => $item['rating'] != null ? $item['rating'] : null,
'maturity_rating' => $item['maturity_rating'] != null ? $item['maturity_rating'] : 'all age',
'featured' => $item['featured'] != null ? 1 : 0,
'audiourl' => $item['audiourl'] != null ? $item['audiourl'] : null,
'upload_audio' => $item['upload_audio'] != null ? $item['upload_audio'] : null,
'is_protect' => $item['is_protect'] != null ? 1 : 0,
'password' => $item['password'] != null ? Crypt::encrypt($item['password']) : null,
]);
if (isset($item['menu']) && $item['menu'] != null) {
$menus_ids = explode(',', $item['menu']);
foreach ($menus_ids as $value) {
MenuVideo::create(['menu_id' => $value, 'audio_id' => $audios->id]);
}
}
DB::commit();
} catch (\Exception $e) {
return back()->with('deleted', $e->getMessage());
}
});
unlink(storage_path() . '/app/excel/' . $filename);
return back()->with('success', __('Audio imported successfully'));
} else {
return back()->with('deleted', __('File is empty !'));
}
}
}