/** * @Author: ANH DUNG Jul 07, 2014 * @Todo: cập nhật status admin new or approved * @Param: $mTransactions, $statusAdmin */ public static function UpdateAdminStatus($mTransactions, $statusAdmin) { ProTransactionsSaveCommission::model()->updateAll(array('admin_approved' => $statusAdmin), "`transactions_id`={$mTransactions->id}"); }
/** * @Author: ANH DUNG Sep 15, 2014 * @Todo: calc report yearly * @Param: $model model * @Param: $aRes var return * @Param: $date_from 2014-05-25 * @Param: $date_to model 2014-09-25 */ public static function ReporYearlyTrans($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," . " year(t.received_on) as year_paid, " . "count(DISTINCT t.transactions_id) as count_record"; $criteria->group = "year(t.received_on)"; $criteria->order = "t.received_on"; $models = ProTransactionsSaveCommission::model()->findAll($criteria); foreach ($models as $item) { $aRes['TOTAL_AMOUNT_INVOICE'][$item->year_paid] = $item->profit_to_property_info + $item->profit_to_property_info_by_company; $aRes['COUNT_TRANS'][$item->year_paid] = $item->count_record; $aRes['LOOP_VAR'][$item->year_paid] = 1; } }
public function beforeDelete() { $mDel = ProTransactionsBillTo::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsInternalCoBroke::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsPropertyDetail::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsPropertyDocument::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsVendorPurchaserDetail::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsSaveCommission::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); $mDel = ProTransactionsInvoice::model()->findAll('transactions_id =' . $this->id); self::deleteArrModel($mDel); return parent::beforeDelete(); }