public function actionTest()
{
if (isset($_POST['dates'])) {
$from = $_POST['dates'];
$to = $_POST['dates'];
} else {
$from = $_POST['from'];
$to = $_POST['to'];
}
$PERSENT = new Percent();
$expense = new Expense();
$model = Employee::model()->findAll();
$summ = 0;
$perSumm = 0;
foreach ($model as $val) {
$empsum = 0;
$empPersum = 0;
$percent = 0;
$newModel = Expense::model()->findAll('t.employee_id = :id AND date(t.order_date) BETWEEN :from AND :to AND t.status != :status AND t.debt != :debt', array(':id' => $val->employee_id, ':from' => $from, ':to' => $to, ':status' => 1, ':debt' => 1));
//echo $val->employee_id."<br>";
foreach ($newModel as $vale) {
if ($val->check_percent == 1) {
$percent = $PERSENT->getPercent(date('Y-m-d', strtotime($vale->order_date)));
}
$temp = $expense->getExpenseSum($vale->expense_id, date('Y-m-d', strtotime($vale->order_date)));
$empsum = $empsum + $temp;
$empPersum = $empPersum + ($temp + $temp * $percent / 100);
}
$sum[$val->name] = $empsum;
$sumPer[$val->name] = $empPersum;
$summ = $summ + $empsum;
$perSumm = $perSumm + $empPersum;
}
$this->renderPartial('test', array('sum' => $summ, 'empSum' => $sum, 'sumPer' => $perSumm, 'empPerSum' => $sumPer));
}
<th></th>
</tr>
</thead>
<tbody>
<?php
foreach ($model as $value) {
$procent = new Percent();
$percent = $procent->getPercent(date('Y-m-d', strtotime($value->getRelated('expense')->order_date)));
?>
<?php
if ($value->getRelated('expense')->getRelated('employee')->check_percent == 1) {
$curPercent = $percent;
} else {
$curPercent = 0;
}
$temp = $expense->getExpenseSum($value->getRelated('expense')->expense_id, $value->getRelated('expense')->expense_id->order_date);
?>
<tr>
<td><?php
echo $count;
?>
</td>
<td><?php
echo $value->getRelated('expense')->order_date;
?>
</td>
<td><?php
echo $value->d_date;
?>
</td>
<th>Процент обслуживания</th>
<th>Сумма счета</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
foreach ($newModel as $value) {
?>
<?php
if ($value->getRelated('employee')->check_percent == 1) {
$curPercent = $percent;
} else {
$curPercent = 0;
}
$temp = $expense->getExpenseSum($value->expense_id, $value->order_date);
?>
<tr>
<td><?php
echo $count;
?>
</td>
<td><?php
echo $value->order_date;
?>
</td>
<td><?php
echo $value->getRelated('employee')->name;
?>
</td>
?>
</span><?php
echo $count;
?>
</td>
<td><?php
echo $value->order_date;
?>
</td>
<td><?php
echo $value->getRelated('employee')->name;
?>
</td>
<td><?php
echo number_format($expense->getExpenseSum($value->expense_id) / 100 * $curPercent + $expense->getExpenseSum($value->expense_id), 0, '.', ',');
$summaP = $summaP + $expense->getExpenseSum($value->expense_id) / 100 * $curPercent + $expense->getExpenseSum($value->expense_id);
?>
</td>
<td>
<?php
echo CHtml::link('<i class="fa fa-pencil fa-fw"></i>', array('expense/update?id=' . $value->expense_id), array('id' => 'update', 'target' => 'blank'));
?>
</td>
</tr>
<?php
$count++;
}
?>
</tbody>
<tfoot>
?>
<tr>
<td><?php
echo $counting;
?>
</td>
<td><?php
echo $value->order_date;
?>
</td>
<td><?php
echo $value->table;
?>
</td>
<td><?php
echo $expense->getExpenseSum($value->expense_id, $value->order_date);
?>
</td>
<td><?php
//=CHtml::link('<i class="fa fa-eye fa-fw"></i> Просмотр',array('expense/view&id='.$value->employee_id.'&order_date='.$value->order_date))
?>
</td>
</tr>
<?php
$count = $count + $expense->getExpenseSum($value->expense_id, $value->order_date);
?>
<?php
$counting++;
}
?>
<tr>
