/**
* @Author: ANH DUNG Sep 19, 2014
* @Todo: get summary report of transaction
* @Param: $model model ProTransaction
*/
public function SummaryReport()
{
if (empty($this->date_from)) {
$this->date_from = date("d/m/Y");
}
if (empty($this->date_to)) {
$this->date_to = date("d/m/Y");
}
$date_from = MyFormat::dateConverDmyToYmd($this->date_from) . " 00:00:00";
$date_to = MyFormat::dateConverDmyToYmd($this->date_to) . " 23:59:59";
$criteria = new CDbCriteria();
$criteria->addBetweenCondition("t.created_date", $date_from, $date_to);
$criteria->compare('t.admin_approved', 1);
// $criteria->addCondition('t.status > 0');
$criteria->addInCondition('t.status', ProTransactions::$LIST_STATUS_REAL);
// add on Now 28, 2014
$criteria->order = "t.id DESC";
$mTransTemp = new ProTransactions();
$mTransTemp->date_from = $date_from;
$mTransTemp->date_to = $date_to;
// get Gross Commission to Company and pass to session
ProTransactionsSaveCommission::ReportGetAllClientComm($mTransTemp);
ProTransactionsSaveCommission::ReportGetAll1st2nd($mTransTemp);
ProTransactionsSaveCommission::ReportGetAllCommCompany($mTransTemp);
$_SESSION['DATA_SUMMARY_REPORT'] = new CActiveDataProvider('ProTransactions', array('pagination' => false, 'criteria' => $criteria));
ProTransactionsSaveCommission::SumReportGetInfoExternalCoBroke($_SESSION['DATA_SUMMARY_REPORT']->data);
return new CActiveDataProvider('ProTransactions', array('criteria' => $criteria, 'pagination' => array('pageSize' => 50)));
}
