public static function getSumOfOtherTracks($po_id,$track_to_exclude) { $condition = new CDbCriteria(); $condition->condition = "PO_ID = ". $po_id; $condition->addCondition(" PO_Trkng_ID <>".$track_to_exclude); $tracks = PoPmtsTraking::model()->findAll($condition); $sum = 0; foreach ($tracks as $track) { $sum = $sum + $track->PO_Trkng_Pmt_Amt; } return $sum; }
/** * Add relation between AP and PO * @param $poID * @param $invAmount * @param $invDate * @param $invNumber */ public static function removeApPORelation($poID, $invAmount, $invDate, $invNumber) { if ($poID != 0) { $condition = new CDbCriteria(); $condition->condition = "PO_ID = '" . $poID . "'"; $condition->addCondition("PO_Trkng_Inv_Date = '$invDate'"); $condition->addCondition("PO_Trkng_Pmt_Amt = $invAmount"); $condition->addCondition("PO_Trkng_Inv_Number = '$invNumber'"); PoPmtsTraking::model()->deleteAll($condition); } }