public function taxes($numDays)
{
//Get our current group characters
$members = $this->getMembersAsCharIDArray(Yii::app()->user->trackingGroupID);
$sqlarray = '(' . implode(',', $members) . ')';
$currentDate = $this->getEveTimeSql();
//Establish the search criteria
$criteria = new CDbCriteria();
$criteria->select = 'amount';
//select only the amount
$criteria->condition = 'refTypeID = 54 AND DATE(date) >= (DATE_SUB(DATE( :currentDate ), INTERVAL :numDays DAY)) AND ownerID1 IN ' . $sqlarray . '';
//where only for the selected number of days and only Blakes and Mathias selling
$criteria->params = array(':numDays' => $numDays, ':currentDate' => $currentDate);
//sets the correct number of days for the previous condition above
//Run the sales query using those criteria
$taxArray = Journal::model()->findAll($criteria);
//Add all the numbers in the sales array
if (!empty($taxArray)) {
foreach ($taxArray as $arrayRow) {
$taxValues[] = $arrayRow->amount;
}
$totalTaxes = array_sum($taxValues);
return number_format($totalTaxes, 2);
} else {
return "0.00";
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Journal::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
