/**
* @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();
}
