public function actionToday()
{
$dates = date('Y-m-d');
$startProducts = array();
$inProducts = array();
$outProducts = array();
$inOutProducts = array();
$endProducts = array();
$prodModel = Products::model()->findAll();
//Приход
$fakturaProd = Faktura::model()->with('realize.products')->findAll('date(realize_date) = :realize_date', array('realize_date' => $dates));
foreach ($fakturaProd as $value) {
foreach ($value->getRelated('realize') as $key => $val) {
$inProducts[$val->getRelated('products')->product_id] = $inProducts[$val->getRelated('products')->product_id] + $val->count;
}
}
//Расход
$Depfaktura = DepFaktura::model()->with('realizedProd')->findAll('date(real_date) = :real_date', array(':real_date' => $dates));
foreach ($Depfaktura as $value) {
foreach ($value->getRelated('realizedProd') as $val) {
$outProducts[$val->prod_id] = $outProducts[$val->prod_id] + $val->count;
}
}
$expense = Expense::model()->with('order.products')->findAll('date(order_date) = :dates AND t.kind = :kind', array(':kind' => 1, ':dates' => $dates));
foreach ($expense as $value) {
foreach ($value->getRelated('order') as $val) {
$inOutProducts[$val->just_id] = $inOutProducts[$val->just_id] + $val->count;
}
}
$curProd = Balance::model()->with('products')->findAll('b_date = :dates', array(':dates' => $dates), array('order' => 'products.name'));
foreach ($curProd as $value) {
$endProducts[$value->prod_id] = $endProducts[$value->prod_id] + $value->startCount + $inProducts[$value->prod_id] - $outProducts[$value->prod_id] - $inOutProducts[$value->prod_id];
}
$this->render('today', array('prodModel' => $prodModel, 'model' => $curProd, 'inProducts' => $inProducts, 'outProducts' => $outProducts, 'inOutProducts' => $inOutProducts, 'endProducts' => $endProducts));
}
public function realize_prod($dates)
{
$sum = 0;
$model = DepFaktura::model()->with('realizedProd')->findAll('date(real_date) = :real_date', array(':real_date' => $dates));
foreach ($model as $value) {
foreach ($value->getRelated('realizedProd') as $val) {
$sum = $sum + $val->count * $this->getRealized($val->prod_id, $dates);
}
}
return $sum;
}
public function actionViewStorage()
{
$dates = date("Y-m-d");
$outProduct = array();
$depOut = array();
$depIn = array();
$outStuff = array();
$prodModel = Products::model()->findAll();
foreach ($prodModel as $value) {
$outProduct[$value->product_id] = $outProduct[$value->product_id] + 0;
$depOut[$value->product_id] = $depOut[$value->product_id] + 0;
}
$depId = $_POST['department_id'];
$departMoveOut = DepFaktura::model()->with('realizedProd')->findAll('date(t.real_date) = :dates AND t.department_id = :depId AND t.fromDepId <> :fromDepId', array(':dates' => $dates, ':depId' => $depId, ':fromDepId' => 0));
foreach ($departMoveOut as $key => $val) {
foreach ($val->getRelated('realizedProd') as $value) {
$depIn[$value->prod_id] = $depIn[$value->prod_id] + $value->count;
}
}
$departMoveIn = DepFaktura::model()->with('realizedProd')->findAll('date(t.real_date) = :dates AND t.fromDepId = :depId', array(':dates' => $dates, ':depId' => $depId));
foreach ($departMoveIn as $value) {
foreach ($value->getRelated('realizedProd') as $val) {
$depOut[$val->prod_id] = $depOut[$val->prod_id] + $val->count;
}
}
$curProd = DepBalance::model()->with('products')->findAll('date(t.b_date) = :dates AND t.department_id = :department_id AND t.type = :type', array(':dates' => $dates, ':department_id' => $depId, ':type' => 1));
$curStuff = DepBalance::model()->with('stuff')->findAll('date(t.b_date) = :dates AND t.department_id = :department_id AND t.type = :type', array(':dates' => $dates, ':department_id' => $depId, ':type' => 2));
$dish = new Expense();
$stuff = new Halfstaff();
$outProduct = $dish->getDishProd($depId, $dates);
$outDishStuff = $dish->getDishStuff($depId, $dates);
$inProducts = array();
$model = DepFaktura::model()->with('realizedProd')->findAll('date(t.real_date) = :dates AND t.department_id = :depId AND t.fromDepId = :fromDepId', array(':dates' => $dates, ':depId' => $depId, ':fromDepId' => 0));
foreach ($model as $key => $val) {
foreach ($val->getRelated('realizedProd') as $value) {
$inProducts[$value->prod_id] = $inProducts[$value->prod_id] + $value->count;
}
}
$instuff = array();
$outStuffProd = array();
$model2 = Inexpense::model()->with('inorder.stuffs.stuffStruct')->findAll('date(t.inexp_date) = :dates AND t.department_id = :depId AND stuffStruct.types = :types AND t.fromDepId = :fromDepId', array(':dates' => $dates, 'depId' => $depId, ':types' => 1, ':fromDepId' => 0));
foreach ($model2 as $val) {
foreach ($val->getRelated('inorder') as $value) {
$instuff[$value->stuff_id] = $instuff[$value->stuff_id] + $value->count;
foreach ($value->getRelated('stuffs')->getRelated('stuffStruct') as $values) {
$outStuffProd[$values->prod_id] = $outStuffProd[$values->prod_id] + $values->amount / $value->getRelated('stuffs')->count * $value->count;
}
}
}
$model3 = Inexpense::model()->with('inorder.stuffs.stuffStruct.podstuff.podstuffStruct.Struct')->findAll('date(t.inexp_date) = :dates AND t.department_id = :depId AND stuffStruct.types = :types AND t.fromDepId = :fromDepId', array(':dates' => $dates, 'depId' => $depId, ':types' => 2, ':fromDepId' => 0));
foreach ($model3 as $val) {
foreach ($val->getRelated('inorder') as $value) {
$instuff[$value->stuff_id] = $instuff[$value->stuff_id] + $value->count;
foreach ($value->getRelated('stuffs')->getRelated('stuffStruct') as $values) {
$outStuff[$values->prod_id] = $outStuff[$values->prod_id] + $values->amount / $value->getRelated('stuffs')->count * $value->count;
foreach ($values->getRelated('podstuff')->getRelated('podstuffStruct') as $vals) {
$outStuffProd[$values->prod_id] = $outStuffProd[$values->prod_id] + $vals->amount / $values->getRelated('podstuff')->count * $values->amount / $value->getRelated('stuffs')->count * $value->count;
}
}
}
}
$outStuff = $stuff->sumArray($outDishStuff, $outStuff);
$inexpense = new Inexpense();
$depStuffIn = $inexpense->getDepIn($depId, $dates);
$depStuffOut = $inexpense->getDepOut($depId, $dates);
$this->renderPartial('viewStorage', array('depOut' => $depOut, 'depIn' => $depIn, 'depStuffOut' => $depStuffOut, 'depStuffIn' => $depStuffIn, 'prodModel' => $prodModel, 'curProd' => $curProd, 'curStuff' => $curStuff, 'inProduct' => $inProducts, 'inStuff' => $instuff, 'outProduct' => $outProduct, 'outStuff' => $outStuff, 'outStuffProd' => $outStuffProd));
}
public function actionProdlist()
{
$dates = date('Y:m:d');
$halfstuff = array();
$products = array();
$inProducts = array();
$inHalfstuff = array();
$depId = $_POST['depId'];
$model = DepBalance::model()->with('products')->findAll('t.department_id = :depId AND t.type = :type', array(':depId' => $depId, 'type' => 1));
foreach ($model as $val) {
$products[$val->prod_id] = $val->getRelated('products')->name;
}
//$model = new Products();
//$products = $model->getProdName($depId);
$departMoveOut = DepFaktura::model()->with('realizedProd')->findAll('date(t.real_date) = :dates AND t.department_id = :depId AND t.fromDepId <> :fromDepId', array(':dates' => $dates, ':depId' => $_POST['depsId'], ':fromDepId' => 0));
foreach ($departMoveOut as $key => $val) {
foreach ($val->getRelated('realizedProd') as $value) {
$depIn[$value->prod_id] = $depIn[$value->prod_id] + $value->count;
}
}
$departMoveIn = DepFaktura::model()->with('realizedProd')->findAll('date(t.real_date) = :dates AND t.fromDepId = :depId', array(':dates' => $dates, ':depId' => $_POST['depsId']));
foreach ($departMoveIn as $value) {
foreach ($value->getRelated('realizedProd') as $val) {
$depOut[$val->prod_id] = $depOut[$val->prod_id] + $val->count;
}
}
$balance = DepBalance::model()->with('products')->findAll('t.b_date = :dates AND t.department_id = :depId AND t.type = :types', array(':dates' => $dates, ':depId' => $_POST['depsId'], ':types' => 1));
$model = DepFaktura::model()->with('realizedProd')->findAll('t.department_id = :depId AND date(t.real_date) = :dates', array(':depId' => $_POST['depsId'], ':dates' => $dates));
if (!empty($model)) {
foreach ($model as $value) {
foreach ($value->getRelated('realizedProd') as $val) {
$inProducts[$val->prod_id] = $inProducts[$val->prod_id] + $val->count;
}
}
}
$dishProd = Expense::model()->with('order.dish.dishStruct.Struct')->findAll('date(order_date) = :dates AND dish.department_id = :department_id', array(':dates' => $dates, ':department_id' => $_POST['depsId']));
if (!empty($dishProd)) {
foreach ($dishProd as $value) {
foreach ($value->getRelated('order') as $val) {
foreach ($val->getRelated('dish')->getRelated('dishStruct') as $vals) {
$outProduct[$vals->prod_id] = $outProduct[$vals->prod_id] + $vals->amount / $val->getRelated('dish')->count * $val->count;
}
}
}
}
$Prod = Expense::model()->with('order.products')->findAll('date(order_date) = :dates AND products.department_id = :department_id', array(':dates' => $dates, ':department_id' => $_POST['depsId']));
if (!empty($Prod)) {
foreach ($Prod as $value) {
foreach ($value->getRelated('order') as $val) {
$outProduct[$val->just_id] = $outProduct[$val->just_id] + $val->count;
}
}
}
foreach ($balance as $value) {
$endCount[$value->prod_id] = $value->startCount + $inProducts[$value->prod_id] - $outProduct[$value->prod_id] + $depIn[$value->prod_id] - $depOut[$value->prod_id];
}
$this->renderPartial('lists', array('endCount' => $endCount, 'products' => $products, 'halfstuff' => $halfstuff, 'inHalfstuff' => $inHalfstuff));
}
