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>