nyan

<?php

namespace App\Http\Controllers;

use App\Models\Article;
use Illuminate\Http\Request;
use App\Models\Category;
use App\Models\Brand;
use App\Models\Product;
use App\Models\Tags;
use Butschster\Head\Facades\Meta;
use Butschster\Head\Packages\Entities\OpenGraphPackage;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Validator;
use Intervention\Image\Facades\Image;

class CmsController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }

public function get_data(Request $request)
    {

$id = $request->input('id');
        $table = $request->input('table');
        $column = $request->input('column');

$isi = DB::table($table . '_cms')->where($table . '_id', $id)->value($column);
        return response()->json(json_decode($isi), 200);
    }

public function set_data(Request $request)
    {

$id = $request->input('id');
        $table = $request->input('table');
        $column = $request->input('column');
        $value = $request->input('value');
        $html = $request->input('html');
        $publish = $request->input('publish');

$isi = DB::table($table . '_cms')->where($table . '_id', $id)->update([$column => $value]);
        $isi = array('status' => true);

if($publish == true){
            DB::table($table)->where('id', $id)->update([$column => $html]);
        }

return response()->json($isi, 200);
    }

private function compressImage($source, $destination, $quality) {
      $info = getimagesize($source);
      if ($info['mime'] == 'image/jpeg') 
        $image = imagecreatefromjpeg($source);
      elseif ($info['mime'] == 'image/gif') 
        $image = imagecreatefromgif($source);
      elseif ($info['mime'] == 'image/png') 
        $image = imagecreatefrompng($source);
      imagejpeg($image, $destination, $quality);
    }

public function upload_file(Request $request) {
        $png_url = "image_".time().".jpg";
        $path = public_path().'\\uploads\\cms\\' . $png_url;
        $path_low = public_path().'\\uploads\\cms\\low_' . $png_url;
        $pathcompressed = public_path().'\\uploads\\cms\\compressed_' . $png_url;

Image::make($request->input('image'))->save($path);

$this->compressImage($path,$path_low,1);
        // imagejpeg($path, $pathcompressed, 20);
        // Image::make($request->input('image'))->resize(['quality' => auto,])->save($pathcompressed);

$response = array(
            'status' => 'success',
            'path' => '/uploads/cms/'.$png_url,
            'low_path' => '/uploads/cms/low_'.$png_url,
        );
        return response()->json($response, 200);
    }
}