[XML] pobierz, plaintext 
 0 => {#16621 ▼
      +"ifsCode": "KE.206.090.LV" <- to polaczyc z part_no
      +"description": "720x390x18(972) Base L Cnr Back B Lava (8mm grv)"
      +"minStock": "25"
      +"maxStock": "25"
      +"demand": "1"
      +"finishedStock": "45"
      +"inStock": "42"
      +"cover": "45"
      +"currentStock": "42"
      +"autoPlan": "0"
      +"totalAutoPlan": "0"
      +"qty": null <- a tu wstawic QTY ale z poprzedniej kolekcji
    }
[XML] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM db1.table1 t1 LEFT JOIN db2.table2 t2 ON t1.id = t2.id
[SQL] pobierz, plaintext 

[XML] pobierz, plaintext 
$latestPosts = DB::table('posts')
                   ->select('user_id', DB::raw('MAX(created_at) as last_post_created_at'))
                   ->where('is_published', true)
                   ->groupBy('user_id');
 
$users = DB::table('users')
        ->joinSub($latestPosts, 'latest_posts', function($join) {
            $join->on('users.id', '=', 'latest_posts.user_id');
        })->get();
[XML] pobierz, plaintext 

[PHP] pobierz, plaintext 
 
$firstCollection = $collection->keyBy('part_no')->all();
 
$secodCollection = $collection->map(function ($row) use ($firstCollection){
 
$row['qty'] = $firstCollection[$row['ifsCode']]['qty']  null;
 
// lub $row->qty = $firstCollection[$row->ifsCode]->qty  null
 
return $row;
 
});
[PHP] pobierz, plaintext 

[XML] pobierz, plaintext 
(1/1) Error
Cannot use object of type stdClass as array
[XML] pobierz, plaintext 

[XML] pobierz, plaintext 
$first = $th->keyBy('part_no')->all();
        $sec = $imaPlan->map(function ($row) use ($first){
           $row['qty'] = $first[$row['ifsCode']]['qty'];
        });
 
        return dd($row);
[XML] pobierz, plaintext 

Cytat(rad11 @ 24.09.2018, 09:40:59 )

[XML] pobierz, plaintext 
select ip.ifsCode, ip.description, ip.minStock, ip.maxStock, ip.demand, ip.finishedStock, ist.inStock ,ip.cover, 
            (CASE WHEN ist.inStock is null then 0 else ist.inStock END) as currentStock, ip.autoPlan ,ip.totalAutoPlan, 0 as qty
            from imaProdPlan ip
            -- left join imaTransactionHistory ith on ith.partNo = ip.ifsCode
            left join imaStock ist on ist.partNo = ip.ifsCode
            where left(ip.created_at,10) = '$planDate'
[XML] pobierz, plaintext