public static function apiCreatePayeePayment()
{
$inputs = Input::all();
$royaltyPaymentsIds = $inputs["ids"];
unset($inputs["ids"]);
$model = self::createEntity(__CLASS__, $inputs);
RoyaltyPayment::whereIn("id", $royaltyPaymentsIds)->update(["payee_payment_id" => $model->id]);
return $model;
}
public function testLoadFromFile()
{
$this->resetEvents();
$companyId = 1;
$rpf = RoyaltyPaymentFile::create(["name" => $this->fileName(), "path" => $this->filePath(), "company_id" => $companyId]);
RoyaltyPayment::loadFromFile($rpf);
$payments = RoyaltyPayment::all();
$this->assertTrue(count($payments) == 4);
$payment = $payments[0];
$this->assertTrue($payment->id == 1);
$this->assertTrue($payment->company_id == $companyId);
$this->assertTrue($payment->royalty_payment_file_id == $rpf->id);
$this->assertTrue($payment->payee_name == "Pop Virus (PACIFICA)");
$this->assertTrue($payment->payee_code == 1379);
$this->assertTrue($payment->client_name == "Pop Virus (PACIFICA)");
$this->assertTrue($payment->client_code == 1379);
$this->assertTrue($payment->song_title == "10 On Top - CUES");
$this->assertTrue($payment->song_code == 60106);
$this->assertTrue($payment->composers == "Coon");
$this->assertTrue($payment->source_name == "ASCAP");
$this->assertTrue($payment->source_code == "ASCA");
$this->assertTrue($payment->income_type_description == "Performance");
$this->assertTrue($payment->income_type == 2);
$this->assertTrue($payment->percent_received == 50);
$this->assertTrue($payment->amount_received == 5.41);
$this->assertTrue($payment->share == 100);
$this->assertTrue($payment->contractual_rate == 50);
$this->assertTrue($payment->contractual_code == 1379);
$this->assertTrue($payment->effective_rate == 50);
$this->assertTrue($payment->amount_earned == 2.71);
$this->assertTrue($payment->catalogue_number == "BG");
$this->assertTrue($payment->units == 0);
$this->assertTrue($payment->price == 0);
$this->assertTrue($payment->date_period_from == "2014-01-00");
$this->assertTrue($payment->date_period_to == "2014-03-00");
$this->assertTrue($payment->territory_name == "USA");
$this->assertTrue($payment->territory_code == "USA");
$this->assertTrue($payment->production_episode == '');
$this->assertTrue($payment->production_episode_code == 0);
$this->assertTrue($payment->notes == "Program Name: ONE DIRECTION ROBIN THICKE AND THE VAMPI");
$this->assertTrue($payment->currency == "USD");
$this->assertTrue($payment->statement_id == 5620);
$this->assertTrue($payment->statement_line == 68);
$this->resetEvents();
}
public function attachedPaymentsCount()
{
return RoyaltyPayment::attachedPaymentsPerPayee($this->code)->count();
}
public function testEmptyLinesInFile()
{
$this->resetEvents();
$fileName = "with_empty_lines.csv";
$path = $this->copyFileToTemp($fileName);
$s = $this->service();
$companyId = rand(1000, 1000000);
$fileDetails = ["year" => 2015, "month" => 7];
$rpf = $s->process($path, $companyId, $fileDetails);
$this->assertTrue($rpf->status == RoyaltyPaymentFile::STATUS_PAYMENTS_PROCESSED);
$rpf = $s->processRoyaltyStreams($rpf);
$this->assertTrue($rpf->status == RoyaltyPaymentFile::STATUS_PROCESSED);
$payments = RoyaltyPayment::all();
$this->assertTrue(count($payments) == 4);
$this->assertTrue($payments[0]->payee_code == 1128);
$this->assertTrue($payments[1]->payee_code == 1111);
$this->assertTrue($payments[2]->payee_code == 1545);
$this->assertTrue($payments[3]->payee_code == 1332);
$clients = Client::all();
$this->assertTrue(count($clients) == 4);
$payeePayments = PayeePayment::all();
$this->assertTrue(count($payments) == 4);
$deals = Deal::all();
$this->assertTrue(count($deals) == 4);
$streams = RoyaltyStream::all();
$this->assertTrue(count($streams) == 4);
$this->assertTrue($streams[0]->song_number == 33959);
$this->assertTrue($streams[1]->song_number == 14402);
$this->assertTrue($streams[2]->song_number == 12043);
$this->assertTrue($streams[3]->song_number == 51311);
$streamFiles = RoyaltyStreamFile::all();
$this->assertTrue(count($streamFiles) == 4);
$this->resetEvents();
}
public function savePayments($rpf)
{
RoyaltyPayment::loadFromFile($rpf);
RoyaltyPayment::cleanEmptyPayments();
}
public function testMarkAsPaidWithMultipleAdvances2CompleteUnfixedAmount()
{
$this->resetEvents();
$user = User::create(self::userArray());
$advance1 = Advance::create(self::advanceArray());
$advance2 = Advance::create(self::advanceArray());
$advance3 = Advance::create(self::advanceArray());
$paymentDate = date("Y-m-d", strtotime("+ 5 days"));
$payeePayment = PayeePayment::create(self::payeePaymentArray());
$royaltyPayment = self::royaltyPaymentsArray($payeePayment);
$royaltyPayment["amount_received"] = 800;
RoyaltyPayment::create($royaltyPayment);
RoyaltyPayment::create($royaltyPayment);
RoyaltyPayment::create($royaltyPayment);
$payeePayment->markAsPaid($paymentDate);
$this->assertTrue(count(AdvancePayment::all()) == 5);
$this->assertTrue(count(AdvancePayment::where("advance_id", "=", $advance1->id)->get()) == 2);
$this->assertTrue(count(AdvancePayment::where("advance_id", "=", $advance2->id)->get()) == 2);
$this->assertTrue(count(AdvancePayment::where("advance_id", "=", $advance3->id)->get()) == 1);
$advanceFound1 = Advance::find($advance1->id);
$this->assertTrue($advanceFound1->status == "complete");
$advanceFound2 = Advance::find($advance2->id);
$this->assertTrue($advanceFound2->status == "complete");
$advanceFound3 = Advance::find($advance3->id);
$this->assertTrue($advanceFound3->status == "incomplete");
$this->assertTrue($advanceFound3->amountLeftToPay() == 600);
$this->assertTrue(AdvancePayment::find(1)->amount == 800);
$this->assertTrue(AdvancePayment::find(2)->amount == 200);
$this->assertTrue(AdvancePayment::find(3)->amount == 600);
$this->assertTrue(AdvancePayment::find(4)->amount == 400);
$this->assertTrue(AdvancePayment::find(5)->amount == 400);
$payeePayment1 = PayeePayment::find($payeePayment->id);
$this->assertTrue($payeePayment1->status == "paid");
$this->resetEvents();
}
public static function apiPaymentsTotals()
{
return ["paid_payments_amount" => RoyaltyPayment::sumAmountReceivedPaidPerPayee(Auth::user()->code), "unpaid_payments_amount" => RoyaltyPayment::sumAmountReceivedUnpaidPerPayee(Auth::user()->code), "current_advance" => Auth::user()->currentAdvance()];
}
public static function cleanEmptyPayments()
{
RoyaltyPayment::where("payee_code", "=", 0)->where("client_code", "=", 0)->where("amount_received", "=", 0)->where("amount_earned", "=", 0)->delete();
}
