コード例 #1
0
ファイル: PoPmtsTraking.php プロジェクト: ranvijayj/htmlasa
    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;
    }
コード例 #2
0
ファイル: Pos.php プロジェクト: ranvijayj/htmlasa
 /**
  * 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);
     }
 }