johnef_sh

I have 3 tables here (order_lists, order_details, products)

Table order_lists contain the following user_id

Table order_details contain the following order_lists_id product_id

Table products contain all the products details.

the three tables are related to each others in models.

I need to select the most purchases items from table order_details based this user_id.

I made very basic Eloquent query which will select 6 products for this user but stuck on how to get the most purchases product

$mostPurchases = OrderList::where( 'user_id', Auth::id() )
                 ->with( [
                   'orderDetails' => function ( $query ) {
                         $query->with( 'productId' );
                    }
                 ] )->take( 6 )->get();

but this didn't work as expected

so I used the DB

DB::table( 'products' )
              ->leftJoin( 'order_details', 'products.id', '=', 'order_details.product_id' )
              ->select( DB::raw( 'count(*) as pro_count, product_id' ) )
              ->leftJoin( 'order_lists', 'order_details.order_lists_id', '=', 'order_lists.id' )
              ->where( 'order_lists.user_id', '=', $usId )
              ->orderBy( 'pro_count', 'DESC' )
              ->groupBy( 'product_id' )
              ->take( 6 )
              ->get();

This working fine but don't get the products details

it just returns the (product_id, and the pro_count)

something like this

        {
            "pro_count": 22,
            "product_id": 733
        },

how can I return the product details with the response.

@FTIERSCH - Thanks this function filled is L5.5 I am using L5.4 so it's has thanks a lot.

I have an input looks like this.

{!! Form::text('inventory[0][amount]', null, ['class'=>'form-control']) !!}
{!! Form::text('inventory[0][expiry_date]', null, ['data-format'=>'D, dd MM yyyy', 'class'=>'form-control']) !!}

print_r( $_POST ); results

 [inventory] => Array ( [0] => Array ( [amount] => 66 [expiry_date] => 2019/05/20 ) )

I am trying to check if the amount and the expiry_date are not null

if ( $input['inventory[0][amount]'] and $input['inventory[0][expiry_date]'] != null )

but I got

Undefined index: inventory[0][amount]

@ROBOROBOK - I need this arrays it can't be changed

I am trying to validates fields like this

{!! Form::text('packages[0][price]', null, ['class'=>'form-control', 'placeholder' => trans('interface.price')]) !!}
{!! Form::text('packages[0][unit_count]', null, ['class'=>'form-control', 'placeholder' => trans('interface.unitCount')]) !!}

when I try to make the validation like this

'packages.0.price' => 'required|regex:/^[\d.,]+$/', it works fine

but with (*)

'packages.*.price' => 'required|regex:/^[\d.,]+$/',

it don't work, any ideas please.

@SERGIU17 - will review it thanks

@MVD - Yes this worked fine with me, thanks a lot dear MVD

Hi guys good day for you all, I'd like o understand how to format this code

<script>
        let counter = 1;
        let limit = 10;

        function addInput(divName) {
            if (counter === limit) {
                alert("You have reached the limit of adding " + counter + " inputs");
            } else {
                let newdiv = document.createElement('div');
                newdiv.innerHTML = '<div class="col-md-12 col-md-pull-1"><div class="col-md-6">{!! Form::text("measurements[' + (counter + 1) + '][width]", null, ["class"=>"form-control", "placeholder" => trans("interface.width")]) !!}</div>';
                document.getElementById(divName).appendChild(newdiv);
                counter++;
            }
        }
    </script>

Here in Form::text("measurements[' + (counter + 1) + '][width]" I try to put this ' + (counter + 1) + ' in the array index but seems it's not reading the code right.

so what should be the right format here.

thanks

@MICHALURVA - Thanks worked as expected

Let's make it more simple

Here I made the HTML FORM like this

{!! Form::text('measurements[measurement][width]', null, ['class'=>'form-control', 'placeholder' => trans('interface.width')]) !!}
{!! Form::select('measurements[measurement][width_u]', $measurements, null, [ 'class'=>'form-control', 'placeholder' => trans('interface.justSelect') ]) !!}

to get the measurements in array and each array has the values and after that loop but still getting the array wrong

"measurements" => array:1 [▼
    "measurement" => array:10 [▼
      "width" => "7"
      "width_u" => "1"
      "length" => "1"
      "length_u" => "1"
      "height" => "4"
      "height_u" => "1"
      "weight" => "5"
      "weight_u" => "2"
      "volume" => "6"
      "volume_u" => "2"
    ]
  ]

if I have two measurements it should be

"measurements" => array:2 [▼
    "measurement" => array:10 [▼
      "width" => "7"
      "width_u" => "1"
      "length" => "1"
      "length_u" => "1"
      "height" => "4"
      "height_u" => "1"
      "weight" => "5"
      "weight_u" => "2"
      "volume" => "6"
      "volume_u" => "2"
    ]
"measurement" => array:10 [▼
      "width" => "5"
      "width_u" => "6"
      "length" => "1"
      "length_u" => "7"
      "height" => "4"
      "height_u" => "8"
      "weight" => "5"
      "weight_u" => "2"
      "volume" => "6"
      "volume_u" => "2"
    ]
  ]

any idea?

@AJITHLAL - Got Illegal string offset 'weight'

I have 3 tables here

products, pck_measurements, packages

I need to insert the product details into products and multiple packages for this product into packages and multiple measurement pck_measurements depending on the packages_id.

Here is what I try (HTML Form)

{!! Form::select('product_category_id', $productsCategory, null, ['class'=>'form-control', 'placeholder' => trans('interface.pleaseSelect')]) !!}
{!! Form::select('tax_id', $taxes, null, ['class'=>'form-control', 'placeholder' => trans('interface.pleaseSelect')]) !!}
{!! Form::text('name_ar', null, ['class'=>'form-control', 'placeholder' => trans('interface.productNameAr')]) !!}
....
//Now comes the package information
{!! Form::text('packages[price]', null, ['class'=>'form-control', 'placeholder' => trans('interface.price')]) !!}
{!! Form::text('packages[unit_count]', null, ['class'=>'form-control', 'placeholder' => trans('interface.unitCount')]) !!}
...
//And here is the measurement
{!! Form::text('measurements[width]', null, ['class'=>'form-control', 'placeholder' => trans('interface.width')]) !!}
{!! Form::select('measurements[width_u]', $measurements, null, ['class'=>'form-control', 'placeholder' => trans('interface.justSelect')]) !!}
{!! Form::text('measurements[length]', null, ['class'=>'form-control', 'placeholder' => trans('interface.length')]) !!}
{!! Form::select('measurements[length_u]', $measurements, null, ['class'=>'form-control', 'placeholder' => trans('interface.justSelect')]) !!}
...

and here is the controller

public function store( ProductRequest $request ) {
        $input = $request->all();

        $input += [
            'ar' => [
                'name'    => $request->name_ar,
                'details' => $request->details_ar
            ],
            'en' => [
                'name'    => $request->name_en,
                'details' => $request->details_en
            ]
        ];


        $product    = ( new Product )->create( $input );
        $product_id = $product->id;


        foreach ( $input['measurements'] as $measurement ) {
            $addMeasurement = ( new PckMeasurement() )->create( [
                'weight'   => $measurement->weight,
                'weight_u' => $measurement->weight_u,
                'length'   => $measurement->length,
                'length_u' => $measurement->length_u,
                'height'   => $measurement->height,
                'height_u' => $measurement->height_u,
                'width'    => $measurement->width,
                'width_u'  => $measurement->width_u,
                'volume'   => $measurement->volume,
                'volume_u' => $measurement->volume_u
            ] );
            $measurements   = $addMeasurement->id;
        }

        foreach ( $input['packages'] as $package ) {
            ( new Package() )->create( [
                'price'              => $input['packages']['price'],
                'unit_count'         => $input['packages']['unit_count'],
                'product_id'         => $product_id,
                'pck_measurement_id' => $measurements
            ] );
        }

        return redirect()->route( 'product.create' )
                         ->with( 'success', 'Product added Successfully' );
    }

When I try to add the measurement like this

'weight' => $measurement->weight,

Got

trying to get property of non object

any help will be appreciated