<th></th>
<th>Наименование блюд</th>
<th>Себестоимость</th>
<th>Установленная цена</th>
<th>Установленная наценка</th>
<th>Текущая наценка</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
foreach ($model as $value) {
?>
<?php
$costPrice = $dish->getCostPrice($value->just_id, $dates);
$price = $prices->getPrice($value->just_id, $value->mType, $value->type, $dates);
if ($costPrice == 0) {
$costPrice = 1;
}
$percent = $price * 100 / $costPrice - 100;
?>
<?php
if ($percent < 50) {
?>
<tr class="error">
<td><?php
echo $cnt;
?>
</td>
<td><?php
echo $value->getRelated('dish')->name;
public function actionAjaxDishIncome()
{
$prices = new Prices();
$dishCnt = array();
$dCount = array();
$prodCnt = array();
$pCount = array();
$stuffCnt = array();
$sCount = array();
$dish = new Dishes();
$stuff = new Halfstaff();
$prod = new Products();
$model = Expense::model()->with('order.dish')->findAll('date(t.order_date) BETWEEN :from AND :to', array(':from' => $_POST['from'], ':to' => $_POST['to']));
if (!empty($model)) {
foreach ($model as $value) {
foreach ($value->getRelated('order') as $val) {
$dishes[$val->just_id] = $val->getRelated('dish')->name;
$dishCnt[$val->just_id] = $dishCnt[$val->just_id] + $val->count * $prices->getPrice($val->just_id, $value->mType, $val->type, $value->order_date) - $dish->getCostPrice($val->just_id, $value->order_date);
$dCount[$val->just_id] = $dCount[$val->just_id] + $val->count;
}
}
}
$model2 = Expense::model()->with('order.halfstuff')->findAll('date(t.order_date) BETWEEN :from AND :to', array(':from' => $_POST['from'], ':to' => $_POST['to']));
if (!empty($model2)) {
foreach ($model2 as $value) {
foreach ($value->getRelated('order') as $val) {
$halfstuff[$val->just_id] = $val->getRelated('halfstuff')->name;
$stuffCnt[$val->just_id] = $stuffCnt[$val->just_id] + $val->count * $prices->getPrice($val->just_id, $value->mType, $val->type, $value->order_date) - $stuff->getCostPrice($val->just_id, $value->order_date);
$sCount[$val->just_id] = $sCount[$val->just_id] + $val->count;
}
}
}
$model3 = Expense::model()->with('order.products')->findAll('date(t.order_date) BETWEEN :from AND :to', array(':from' => $_POST['from'], ':to' => $_POST['to']));
if (!empty($model3)) {
foreach ($model3 as $value) {
foreach ($value->getRelated('order') as $val) {
$products[$val->just_id] = $val->getRelated('products')->name;
$prodCnt[$val->just_id] = $prodCnt[$val->just_id] + $val->count * $prices->getPrice($val->just_id, $value->mType, $val->type, $value->order_date) - $prod->getCostPrice($val->just_id, $value->order_date);
$pCount[$val->just_id] = $pCount[$val->just_id] + $val->count;
}
}
}
$this->renderPartial('ajaxDishIncome', array('dishes' => $dishes, 'dishCnt' => $dishCnt, 'halfstuff' => $halfstuff, 'stuffCnt' => $stuffCnt, 'products' => $products, 'prodCnt' => $prodCnt, 'dCount' => $dCount, 'sCount' => $sCount, 'pCount' => $pCount));
}
<th></th>
<th>Наимен. блюда</th>
<th>Себестоимость (сум)</th>
<th>Цена реализации (сум)</th>
<th>наценка план (%)</th>
<th>наценка факт (%)</th>
<th>отклон (+,-)</th>
<th>тренд ср.стат.</th>
</tr>
</thead>
<tbody>
<?php
foreach ($model as $val) {
$beforeDates = date('Y-m-d', strtotime($dates) - 86400);
$costPrice = $dish->getCostPrice($val['just_id'], $dates);
$price = $prices->getPrice($val['just_id'], $val['mType'], $val['type'], $dates);
$beforeCostPrice = $dish->getCostPrice($val['just_id'], $beforeDates);
$beorePrice = $prices->getPrice($val['just_id'], $val['mType'], $val['type'], $beforeDates);
if ($costPrice == 0) {
$margin = $price * 100 / 1 - 100;
} elseif ($price == 0) {
$margin = 1 * 100 / $costPrice - 100;
} else {
$margin = $price * 100 / $costPrice - 100;
}
if ($beforeCostPrice == 0) {
$beforeMargin = $beorePrice * 100 / 1 - 100;
} elseif ($beorePrice == 0) {
$beforeMargin = 1 * 100 / $beforeCostPrice - 100;
} else {
$beforeMargin = $beorePrice * 100 / $beforeCostPrice - 100;
public function getExpenseSum($id, $dates)
{
$summ = 0;
$prices = new Prices();
$model = Expense::model()->with('order.dish')->findByPk($id);
$model2 = Expense::model()->with('order.halfstuff')->findByPk($id);
$model3 = Expense::model()->with('order.products')->findByPk($id);
if (!empty($model)) {
foreach ($model->getRelated('order') as $val) {
$summ = $summ + $prices->getPrice($val->just_id, 1, 1, $dates) * $val->count;
}
}
if (!empty($model2)) {
foreach ($model2->getRelated('order') as $val) {
$summ = $summ + $prices->getPrice($val->just_id, 1, 2, $dates) * $val->count;
}
}
if (!empty($model3)) {
foreach ($model3->getRelated('order') as $val) {
$summ = $summ + $prices->getPrice($val->just_id, 1, 3, $dates) * $val->count;
}
}
return $summ;
}
public function getMenuList()
{
$menuList = array();
$price = new Prices();
$dates = date('Y-m-d');
$dishModel = Menu::model()->with('dish')->findAll();
$stuffModel = Menu::model()->with('halfstuff')->findAll();
$prodModel = Menu::model()->with('products')->findAll();
foreach ($dishModel as $val) {
$menuList['dish_' . $val->just_id] = $val->getRelated('dish')->name . "_" . $price->getPrice($val->just_id, $val->mType, $val->type, $dates);
}
foreach ($stuffModel as $val) {
$menuList['stuff_' . $val->just_id] = $val->getRelated('halfstuff')->name . "_" . $price->getPrice($val->just_id, $val->mType, $val->type, $dates);
}
foreach ($prodModel as $val) {
$menuList['product_' . $val->just_id] = $val->getRelated('products')->name . "_" . $price->getPrice($val->just_id, $val->mType, $val->type, $dates);
}
return $menuList;
}
echo $value->menu_id;
?>
' />
<input type='text' style='display: none;' name='dish[type][]' value='<?php
echo $id;
?>
' />
<input type='text' style='display: none;' name='dish[id][]' value='<?php
echo $value->getRelated('dish')->dish_id;
?>
' /><?php
echo $value->getRelated('dish')->name;
?>
</td>
<td style='text-align:center;'><input type="text" class='span2' value="<?php
echo $prices->getPrice($value->getRelated('dish')->dish_id, $mType, 1, date('Y-m-d'));
?>
" name="dish[price][]"/></td>
<td style='text-align:center;'>
<select name="dish[dep][]" class="span2">
<?php
foreach ($listDep as $key => $dep) {
?>
<?php
if ($key == $value->getRelated('dish')->department_id) {
?>
<option value="<?php
echo $key;
?>
" selected="selected"><?php
echo $dep;
<thead>
<tr>
<th></th>
<th>Название</th>
<th>Количество</th>
<th>Цена</th>
<th>Сумма</th>
</tr>
</thead>
<tbody>
<?php
foreach ($dishModel as $value) {
?>
<?php
foreach ($value->getRelated('order') as $key => $val) {
$price = $prices->getPrice($val->just_id, $value->mType, $val->type, $value->order_date);
?>
<tr>
<td><?php
echo $count;
?>
</td>
<td><?php
echo $val->getRelated('dish')->name;
?>
</td>
<td><?php
echo $val->count;
?>
</td>
<td><?php
<td><?php
echo $val['name'];
?>
</td>
<td><?php
echo number_format($val['count'], 2, ',', '');
?>
<?php
echo $val['Mname'];
?>
</td>
<?php
if ($key == 'price') {
?>
<td><?php
echo number_format($price->getPrice($val['prod_id'], $val['mType'], $val['type'], $dates) * $val['count'], 0, ',', ' ');
?>
</td>
<?php
$sum = $sum + $price->getPrice($val['prod_id'], $val['mType'], $val['type'], $dates) * $val['count'];
?>
<?php
} else {
?>
<td><?php
echo number_format($prod->getCostPrice($val['prod_id'], $dates) * $val['count'], 0, ',', ' ');
?>
</td>
<?php
$sum = $sum + $prod->getCostPrice($val['prod_id'], $dates) * $val['count'];
?>
