Skrip add product

//addNewProduct
    public function addNewProduct(Request $request){
        $title = array('pageTitle' => Lang::get("labels.AddAttributes"));
        $language_id      =   '1';
        $date_added = date('Y-m-d h:i:s');

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

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

        if($request->hasFile('products_image')){
            $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 = '';
        }

        $products_id = DB::table('products')->insertGetId([
                    'products_image'         =>   $uploadImage,
                    'manufacturers_id'       =>   $request->manufacturers_id,
                    'products_quantity'      =>   $request->products_quantity,
                    'products_model'         =>   $request->products_model,
                    'products_price'         =>   $request->products_price,
                    'products_date_added'    =>   $date_added,
                    '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;

            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)
                    ]);
        }

        //special product
        if($request->isSpecial == 'yes'){
            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,
                ]);
        }

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

        $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);

        //notify users
        $myVar = new AdminAlertController();
        $alertSetting = $myVar->newProductNotification($products_id);

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