public function saveClients($rpf) { // $payments = RoyaltyPayment::groupedByClientCode($rpf->id)->get(); // foreach ($payments as $payment) // $client = Client::create(["name" => $payment->client_name, "code" => $payment->client_code]); DB::connection()->getpdo()->exec('INSERT IGNORE INTO ' . Client::table() . '(`name`, `code`) SELECT `client_name`, `client_code` FROM ' . RoyaltyPayment::table() . ' WHERE `royalty_payment_file_id` = ' . $rpf->id . ' AND `payee_payment_id` IS NULL GROUP BY `client_code` ORDER BY `client_code`'); }