public static function apiQuery() { $query = self::query(); if (!Auth::user()->isAdmin()) { $query->where(PayeeCompany::table() . '.company_id', '=', Auth::user()["company_id"]); } $query->join(User::table() . " as user", 'user.id', '=', 'user_id'); return $query; }
public function savePayees($rpf) { // $payments = RoyaltyPayment::groupedByPayeeCode($rpf->id)->get(); // foreach ($payments as $payment) { // $user = User::where('code', '=', $payment->payee_code)->first(); // if ($user == null) { // $user = User::create(["name" => $payment->payee_name, // "deleted_at" => null, // "email" => null, // "code" => $payment->payee_code, // "company_id" => $rpf->company_id, // "password" => $payment->payee_code, // "type" => "payee"]); // PayeeCompany::create(["user_id" => $user->id, "code" => $user->code, "company_id" => $rpf->company_id]); // } else { // if (PayeeCompany::findByUserAndCompany($user->id, $rpf->company_id) == null) // PayeeCompany::create(["user_id" => $user->id, "code" => $user->code, "company_id" => $rpf->company_id]); // } // } DB::connection()->getpdo()->exec('INSERT IGNORE INTO ' . User::table() . '(`name`, `deleted_at`, `email`, `code`, `company_id`, `password`, `type`) SELECT `payee_name`, NULL, NULL, `payee_code`, ' . $rpf->company_id . ', ENCRYPT(`payee_code`), \'payee\' FROM ' . RoyaltyPayment::table() . ' WHERE `royalty_payment_file_id` = ' . $rpf->id . ' AND `payee_payment_id` IS NULL GROUP BY `payee_code` ORDER BY `payee_code`'); DB::connection()->getpdo()->exec('INSERT IGNORE INTO ' . PayeeCompany::table() . '(`user_id`, `code`, `company_id`) SELECT u.id, `payee_code`, ' . $rpf->company_id . ' FROM ' . RoyaltyPayment::table() . ' as rp LEFT JOIN ' . User::table() . ' as u on rp.payee_code = u.code WHERE `royalty_payment_file_id` = ' . $rpf->id . ' AND `payee_payment_id` IS NULL GROUP BY `payee_code` ORDER BY `payee_code`'); }