public function actionPaidDebt()
{
$model = Debt::model()->with('expense')->findAll();
$this->render('paidDebt', array('model' => $model));
}
public function getSum($dates)
{
$percent = new Percent();
$summa = 0;
$summaP = 0;
$curPercent = 0;
$employee = Employee::model()->findAll();
$stuff = new Halfstaff();
$debt = Debt::model()->findAll('t.d_date = :dates', array(':dates' => $dates));
$debts = array();
foreach ($employee as $vals) {
$summ = 0;
if ($vals->check_percent == 1) {
$curPercent = $percent->getPercent($dates);
} else {
$curPercent = 0;
}
$model = Yii::app()->db->CreateCommand()->select('t.expense_id')->from('expense t')->where('date(t.order_date) = :dates AND t.kind = :kind AND t.employee_id = :empId AND t.status != :status AND t.debt != :debt', array(':dates' => $dates, ':kind' => 0, ':empId' => $vals->employee_id, ':status' => 1, ':debt' => 1))->queryAll();
/*$model = Expense::model()->with()->findAll( 'date(t.order_date) = :dates AND t.kind = :kind AND t.employee_id = :empId AND t.status != :status AND t.debt != :debt', array(
':dates' => $dates,
':kind' => 0,
':empId' => $vals->employee_id,
':status'=> 1,
':debt' => 1
) );*/
if (!empty($model)) {
foreach ($model as $value) {
$summ = $summ + $this->getExpenseSum($value['expense_id'], $dates);
}
}
$tempSumm = $summ / 100 * $curPercent + $summ;
$summaP = round($tempSumm / 100) * 100 + $summaP;
$summa = round(($summ + $summa) / 100) * 100;
}
if (!empty($debt)) {
foreach ($debt as $value) {
$debts = $stuff->sumArray($debts, $this->getExpenseProcSum($value->expense_id, $dates));
}
}
return array(1 => $summaP + $debts[1], 2 => $summa + $debts[2]);
}
