예제 #1
0
 /**
 * @Author: ANH DUNG Sep 15, 2014
 * @Todo: calc report daily
 * @Param: $model model 
 * @Param: $aRes var return
 * @Param: $date_from 2014-05-25
 * @Param: $date_to model 2014-09-25
 * BA-Tung Hoang: cai sales report cua financial anh 
    lay nhung cai amount cua invoice ma da paid roi tru cho cai amount cua voucher DA PAID
 */
 public static function ReportDailyTrans($model, &$aRes, $date_from, $date_to)
 {
     $criteria = new CDbCriteria();
     $criteria->addBetweenCondition("t.received_on", $date_from, $date_to);
     $criteria->compare('t.status', STATUS_GEN_RECEIPT);
     $criteria->addCondition('t.received_on IS NOT NULL');
     $criteria->select = "sum(profit_to_property_info) as profit_to_property_info,sum(profit_to_property_info_by_company) as profit_to_property_info_by_company," . " t.received_on, count(DISTINCT t.transactions_id) as count_record";
     $criteria->group = "t.received_on";
     $criteria->order = "t.received_on";
     $models = ProTransactionsSaveCommission::model()->findAll($criteria);
     foreach ($models as $item) {
         $aRes['TOTAL_AMOUNT_INVOICE'][$item->received_on] = $item->profit_to_property_info + $item->profit_to_property_info_by_company;
         $aRes['COUNT_TRANS'][$item->received_on] = $item->count_record;
     }
     $aRes['LOOP_VAR'] = MyFormat::getArrayDay($date_from, $date_to);
 }