public static function apiDetachFromPayeePayment()
{
$decrementsAmounts = RoyaltyPayment::whereIn('id', array_values(Input::all()))->groupBy("payee_payment_id")->orderBy("payee_payment_id", "asc")->select(DB::raw('sum(amount_received) AS amount'), 'payee_payment_id')->get();
foreach ($decrementsAmounts as $decrement) {
$payeePayment = PayeePayment::find($decrement->payee_payment_id);
$payeePayment->amount -= $decrement->amount;
if ($payeePayment->amount == 0) {
$payeePayment->delete();
} else {
$payeePayment->save();
}
}
RoyaltyPayment::whereIn('id', array_values(Input::all()))->update(["payee_payment_id" => null]);
}
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 updateOrCreatePayeePayment($payeePayment)
{
$payeePayment = self::formatFromExcel($payeePayment);
if (isset($payeePayment['payee_payment.id']) && is_int(intval($payeePayment['payee_payment.id']))) {
$payment = PayeePayment::find($payeePayment['payee_payment.id']);
$payment->update($payeePayment);
} else {
$payeePayment['company_id'] = Auth::user()["company_id"];
$payment = PayeePayment::create($payeePayment);
}
if (isset($payeePayment['status']) && $payeePayment['status'] == 'paid') {
$payment->distributePayeePaymentToAdvancePayments();
}
}
