public function startDay($sess, $dates) { $this->Holiday($dates); $prodModel = Products::model()->findAll(); //$department = Department::model()->findAll(); $max_date = Balance::model()->find(array('select' => 'MAX(b_date) as b_date')); $curProd = Balance::model()->with('products')->findAll('date(t.b_date) = :dates', array(':dates' => $max_date->b_date)); $max_date = DepBalance::model()->find(array('select' => 'MAX(b_date) as b_date')); $curDepProd = DepBalance::model()->with('products')->findAll('date(t.b_date) = :dates', array(':dates' => $max_date->b_date)); $transaction = Yii::app()->db->beginTransaction(); $coockieModel = Coockie::model()->find('date(t.coockie_date) = :dates', array(':dates' => $dates)); if (empty($coockieModel)) { if (!empty($curProd)) { foreach ($prodModel as $key => $value) { $model = new Balance(); $model->b_date = $dates; $model->prod_id = $value->product_id; foreach ($curProd as $val) { if ($val->prod_id == $value->product_id) { $model->startCount = $val->CurEndCount; } } $model->save(); } } else { $startProducts = Storage::model()->findAll(); foreach ($prodModel as $key => $value) { $model = new Balance(); $model->b_date = $dates; $model->prod_id = $value->product_id; if (!empty($startProducts)) { foreach ($startProducts as $val) { if ($val->prod_id == $value->product_id) { $model->startCount = $val->curCount; } } } $model->save(); } } if (!empty($curDepProd)) { foreach ($curDepProd as $val) { $model = new DepBalance(); $model->startCount = $val->CurEndCount; $model->department_id = $val->department_id; $model->b_date = $dates; $model->prod_id = $val->prod_id; $model->type = $val->type; $model->save(); } } else { $startProducts = DepStorage::model()->findAll(); if (!empty($startProducts)) { foreach ($startProducts as $val) { $model = new DepBalance(); $model->b_date = $dates; $model->prod_id = $val->prod_id; $model->startCount = $val->curCount; $model->department_id = $val->department_id; $model->type = $val->type; $model->save(); } } } $coockie = new Coockie(); $coockie->coockie_date = $dates; $coockie->coockie_start = $sess; $coockie->save(); } $transaction->commit(); }
public function actionCalendarEvents() { $items = array(); $model = DepStorage::model()->findAll(); foreach ($model as $value) { $items[] = array('id' => $value->dep_storage_id, 'url' => '#'); } echo CJSON::encode($items); Yii::app()->end(); }