public function testSavePayeeUnpaidPayments()
{
$this->resetEvents();
$path = $this->filePath();
$s = $this->service();
$companyId = rand(1000, 1000000);
$rpf = $s->saveRoyaltyPaymentFile($path, $companyId, ["year" => 2015, "month" => 3]);
$s->savePayments($rpf);
$s->savePayees($rpf);
$payees = User::all();
$this->assertTrue(count($payees) == 2);
$payee1 = $payees[0];
$this->assertTrue($payee1->id == 1);
$this->assertTrue($payee1->company_id == $companyId);
$this->assertTrue($payee1->type == "payee");
$this->assertTrue($payee1->email == null);
$this->assertTrue($payee1->code == "1175");
$this->assertTrue($payee1->name == "Studio 51");
$payee2 = $payees[1];
$this->assertTrue($payee2->id == 2);
$this->assertTrue($payee2->company_id == $companyId);
$this->assertTrue($payee2->type == "payee");
$this->assertTrue($payee2->email == null);
$this->assertTrue($payee2->code == "1379");
$this->assertTrue($payee2->name == "Pop Virus (PACIFICA)");
$s->savePayeePayments($rpf, ["year" => 2015, "month" => 3]);
$payeePayments = PayeePayment::all();
$this->assertTrue(count($payeePayments) == 2);
$this->assertTrue($payeePayments[0]->payment_date == null);
$this->assertTrue($payeePayments[0]->status == "unpaid");
$this->assertTrue($payeePayments[0]->year == 2015);
$this->assertTrue($payeePayments[0]->month == 3);
$this->assertTrue($payeePayments[0]->quarter == null);
$this->assertTrue($payeePayments[1]->year == 2015);
$this->assertTrue($payeePayments[1]->month == 3);
$this->assertTrue($payeePayments[1]->quarter == null);
$paymentsSum = RoyaltyPayment::where("payee_payment_id", "=", $payeePayments[0]->id)->select(DB::raw('sum(amount_received) AS amount'))->get()[0];
$this->assertTrue($paymentsSum->amount == $payeePayments[0]->amount);
$paymentsSum = RoyaltyPayment::where("payee_payment_id", "=", $payeePayments[1]->id)->select(DB::raw('sum(amount_received) AS amount'))->get()[0];
$this->assertTrue($paymentsSum->amount == $payeePayments[1]->amount);
$this->resetEvents();
}
public static function cleanEmptyPayments()
{
RoyaltyPayment::where("payee_code", "=", 0)->where("client_code", "=", 0)->where("amount_received", "=", 0)->where("amount_earned", "=", 0)->delete();
}
