skrip update product

//updateProduct
    public function updateProduct(Request $request){

        $language_id      =   '1';
        $products_id      =   $request->id;
        $products_last_modified = date('Y-m-d h:i:s');

        $expiryDate = str_replace('/', '-', $request->expires_date);
        $expiryDateFormate = strtotime($expiryDate);

        //get function from other controller
        $myVar = new AdminSiteSettingController();
        $languages = $myVar->getLanguages();

        $existProduct = DB::table('products')->where('products_id',$products_id)->get();

        if($request->hasFile('products_image')){

            $oldimage = $existProduct[0]->products_image;

            if (file_exists($oldimage)) {
              unlink($oldimage);
            }

            $image = $request->products_image;
            $fileName = time().'.'.$image->getClientOriginalName();
            $image->move('resources/assets/images/product_images/', $fileName);

            Image::make('resources/assets/images/product_images/'. $fileName)->resize(500, null,
                function ($constraint) {
                    $constraint->aspectRatio();
                })
            ->resizeCanvas(500, null)
            ->save('resources/assets/images/product_images/'. $fileName);

            $uploadImage = 'resources/assets/images/product_images/'.$fileName;
        }else{
            $uploadImage = $request->oldImage;
        }

        DB::table('products')->where('products_id','=',$products_id)->update([
                    'products_image'         =>   $uploadImage,
                    'manufacturers_id'       =>   $request->manufacturers_id,
                    'products_quantity'      =>   $request->products_quantity,
                    'products_model'         =>   $request->products_model,
                    'products_price'         =>   $request->products_price,
                    'products_last_modified'     =>   $products_last_modified,
                    'products_weight'        =>   $request->products_weight,
                    'products_status'        =>   $request->products_status,
                    'products_tax_class_id'  =>   $request->tax_class_id,
                    'products_weight_unit'   =>   $request->products_weight_unit,
                    'low_limit'              =>   $request->low_limit
                    ]);

        foreach($languages as $languages_data){
            $products_name = 'products_name_'.$languages_data->languages_id;
            $products_description = 'products_description_'.$languages_data->languages_id;
            $checkExist = DB::table('products_description')->where('products_id','=',$products_id)->where('language_id','=',$languages_data->languages_id)->get();
            if(count($checkExist)>0){
                DB::table('products_description')->where('products_id','=',$products_id)->where('language_id','=',$languages_data->languages_id)->update([
                    'products_name'          =>   $request->$products_name,
                    'products_url'           =>   $request->products_url,
                    'products_description'   =>   addslashes($request->$products_description)
                    ]);
            }else{
                DB::table('products_description')->insert([
                        'products_name'          =>   $request->$products_name,
                        'language_id'            =>   $languages_data->languages_id,
                        'products_id'            =>   $products_id,
                        'products_url'           =>   $request->products_url,
                        'products_description'   =>   addslashes($request->$products_description)
                        ]);
            }
        }

        DB::table('products_to_categories')->where('products_id','=',$products_id)->update([
                    'categories_id'     =>     $request->sub_category_id
                ]);

        //special product
        if($request->isSpecial == 'yes'){
            DB::table('specials')->where('products_id','=',$products_id)->update([
                    'specials_last_modified'          =>    time(),
                    'date_status_change'              =>    time(),
                    'status'                          =>    0,
                ]);

            DB::table('specials')->insert([
                    'products_id'                     =>     $products_id,
                    'specials_new_products_price'     =>     $request->specials_new_products_price,
                    'specials_date_added'             =>     time(),
                    'expires_date'                    =>     $expiryDateFormate,
                    'status'                          =>     $request->status,
                ]);

        }else if($request->isSpecial == 'no'){
            DB::table('specials')->where('products_id','=',$products_id)->update([
                    'status'                          =>    0,
                ]);
        }

        $options = DB::table('products_options')
            ->where('language_id','=', $language_id)
            ->get();

        $result['options'] = $options;

        $options_value = DB::table('products_options_values')
            ->where('language_id','=', $language_id)
            ->get();

        $result['options_value'] = $options_value;
        $result['data'] = array('products_id'=>$products_id, 'language_id'=>$language_id);

        return redirect('admin/addProductAttribute/'.$products_id);
    }