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`');
}
