/**
* Add Payment-AP relationship
* @param $payment
* @param $paymentInvoice
*/
public static function addAPPaymentRelationship($payment, $paymentInvoice)
{
$document = Documents::model()->findByPk($payment->Document_ID);
$condition = new CDbCriteria();
$condition->join = "LEFT JOIN documents ON documents.Document_ID = t.Document_ID";
$condition->condition = "t.Vendor_ID=:vendorID";
$condition->addCondition("t.Invoice_Amount=:invoice_Amount");
$condition->addCondition("t.Invoice_Number=:invoice_Number");
$condition->addCondition("documents.Project_ID = '" . $document->Project_ID . "'");
$condition->params = array(
':vendorID' => $payment->Vendor_ID,
':invoice_Amount' => $paymentInvoice->Check_Invoice_Amount,
':invoice_Number' => $paymentInvoice->Check_Invoice_Number,
);
$ap = Aps::model()->find($condition);
if ($ap) {
$apPayment = ApPayments::model()->findByAttributes(array(
'AP_ID' => $ap->AP_ID,
'Payment_ID' => $payment->Payment_ID,
));
if (!$apPayment) {
$apPayment = new ApPayments();
$apPayment->AP_ID = $ap->AP_ID;
$apPayment->Payment_ID = $payment->Payment_ID;
$apPayment->save();
$ap->Payment_ID = $payment->Payment_ID;
$ap->save();
}
}
}
