PHP Products::getUseProdList方法代码示例

 public function actionStruct()
 {
     $id = $_POST['type_id'];
     $mType = $_POST['mType'];
     $products = new Products();
     $stuff = new Halfstaff();
     $dish = new Dishes();
     $prodList = $products->getUseProdList();
     $stuffList = $stuff->getUseStuffList();
     $dishList = $dish->getUseDishList();
     $dishModel = Menu::model()->with('dish')->findAll('t.type_id = :typeId AND mType = :mType', array(':typeId' => $id, ':mType' => $mType));
     $prodModel = Menu::model()->with('products')->findAll('t.type_id = :typeId AND mType = :mType', array(':typeId' => $id, ':mType' => $mType));
     $stuffModel = Menu::model()->with('halfstuff')->findAll('t.type_id = :typeId AND mType = :mType', array(':typeId' => $id, ':mType' => $mType));
     $listDep = CHtml::listData(Department::model()->findAll(), 'department_id', 'name');
     $this->renderPartial('struct', array('id' => $id, 'mType' => $mType, 'listDep' => $listDep, 'dishModel' => $dishModel, 'prodModel' => $prodModel, 'stuffModel' => $stuffModel, 'prodList' => $prodList, 'stuffList' => $stuffList, 'dishList' => $dishList));
 }

 /**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionCreate()
 {
     $products = new Products();
     $provider = new Provider();
     $prodList = $products->getUseProdList();
     $provList = $provider->getProvList();
     $model = new Realize();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['provider'])) {
         $fakturaId = $this->beforeSave($_POST['provider']);
         $currentDate = date('Y-m-d');
         //echo $fakturaId;
         $transaction = Yii::app()->db->beginTransaction();
         try {
             $messageType = 'warning';
             $message = "There are some errors " . count($_POST['product_id']);
             if ($_POST['product_id']) {
                 for ($i = 0; $i < count($_POST['product_id']); $i++) {
                     $models = new Realize();
                     $models->faktura_id = $fakturaId;
                     $models->prod_id = $_POST['product_id'][$i];
                     $models->price = $_POST['price'][$i];
                     $models->count = $this->changeToFloat($_POST['count'][$i]);
                     if ($models->save()) {
                         $messageType = 'success';
                         $message = "<strong>Well done!</strong> You successfully create data ";
                     }
                 }
             }
             Yii::app()->user->setFlash($messageType, $message);
             $transaction->commit();
             $this->redirect(array('dishes/checkMargin'));
         } catch (Exception $e) {
             $transaction->rollBack();
             Yii::app()->user->setFlash('error', "{$e->getMessage()}");
             //$this->refresh();
         }
     }
     $this->render('create', array('model' => $model, 'prodList' => $prodList, 'provList' => $provList));
 }

 /**
  * Updates a particular model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param integer $id the ID of the model to be updated
  */
 public function actionUpdate($id)
 {
     $chosenStuff = array();
     $prod_id = CHtml::listData(HalfstuffStructure::model()->findAll(array("condition" => "halfstuff_id = {$id} AND types = 1")), 'halfstruct_id', 'prod_id');
     $stuff_id = CHtml::listData(HalfstuffStructure::model()->findAll(array("condition" => "halfstuff_id = {$id} AND types = 2")), 'halfstruct_id', 'prod_id');
     $chosenProduct = Products::model()->with('stuffStruct')->findAllByPk($prod_id, 'stuffStruct.halfstuff_id = :halfstuff_id AND stuffStruct.types = :types', array(':halfstuff_id' => $id, ':types' => 1));
     foreach ($stuff_id as $key => $value) {
         $chosenStuff[$key] = HalfstuffStructure::model()->with('stuff')->findAllByPk($key, 't.halfstuff_id = :halfstuff_id AND types = :types', array(':halfstuff_id' => $id, ':types' => 2));
     }
     $model = $this->loadModel($id);
     $products = new Products();
     $prodList = $products->getUseProdList();
     $stuffList = $model->getUseStuffList();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['Halfstaff'])) {
         $messageType = 'warning';
         $message = "There are some errors ";
         $transaction = Yii::app()->db->beginTransaction();
         try {
             $_POST['Halfstaff']['count'] = $this->changeToFloat($_POST['Halfstaff']['count']);
             if ($_POST['Halfstaff']['count'] == '' or $_POST['Halfstaff']['count'] == 0) {
                 $_POST['Halfstaff']['count'] = 1;
             }
             $model->attributes = $_POST['Halfstaff'];
             $messageType = 'success';
             $message = "<strong>Well done!</strong> You successfully update data ";
             if ($model->save()) {
                 HalfstuffStructure::model()->deleteAll('halfstuff_id=:halfstuff_id', array(':halfstuff_id' => $id));
                 if ($_POST['product_id'] != null) {
                     $count = 0;
                     $prodMes = "prod>";
                     for ($i = 0; $i < count($_POST['product_id']); $i++) {
                         $ss = $this->changeToFloat($_POST['prod'][$i]);
                         $struct = new HalfstuffStructure();
                         $struct->halfstuff_id = $id;
                         $struct->prod_id = $_POST['product_id'][$i];
                         $struct->amount = $ss;
                         $struct->types = 1;
                         if ($struct->save()) {
                             $messageType = 'success';
                             $prodMes .= $struct->prod_id . ":" . $struct->amount . ",";
                             $message = "<strong>Well done!</strong> Your successfully create data ";
                         }
                         $count++;
                     }
                 }
                 if ($_POST['stuff_id'] != null) {
                     $count = 0;
                     $stuffMes = "stuff>";
                     for ($i = 0; $i < count($_POST['stuff_id']); $i++) {
                         $ss = $this->changeToFloat($_POST['stuff'][$i]);
                         $struct = new HalfstuffStructure();
                         $struct->halfstuff_id = $model->halfstuff_id;
                         $struct->prod_id = $_POST['stuff_id'][$i];
                         $struct->amount = $ss;
                         $struct->types = 2;
                         if ($struct->save()) {
                             $stuffMes .= $struct->prod_id . ":" . $struct->amount . ",";
                         }
                         $count++;
                     }
                 }
                 $this->logs('update', 'halfstaff', $model->halfstuff_id, $model->name . "->" . $prodMes . "=>" . $stuffMes);
                 $transaction->commit();
                 Yii::app()->user->setFlash($messageType, $message);
                 $this->redirect(array('view', 'id' => $model->halfstuff_id));
             }
         } catch (Exception $e) {
             $transaction->rollBack();
             Yii::app()->user->setFlash('error', "{$e->getMessage()}");
             // $this->refresh();
         }
         $model->attributes = $_POST['Halfstaff'];
         if ($model->save()) {
         }
         $this->redirect(array('view', 'id' => $model->halfstuff_id));
     }
     $this->render('update', array('model' => $model, 'chosenProduct' => $chosenProduct, 'chosenStuff' => $chosenStuff, 'prodList' => $prodList, 'stuffList' => $stuffList));
 }

 public function actionRefreshAdd()
 {
     $prod = new Products();
     $prodList = $prod->getUseProdList();
     $stuff = new Halfstaff();
     $stuffList = $stuff->getUseStuffList();
     $this->renderPartial('refreshAdd', array('stuffList' => $stuffList, 'prodList' => $prodList, 'form' => $_POST['form']));
 }

 public function actionRequest()
 {
     $products = new Products();
     $provider = new Provider();
     $prodList = $products->getUseProdList();
     $provList = $provider->getProvList();
     $depId = Department::model()->findAll();
     $dates = date('Y-m-d H:i:s');
     $command = Yii::app()->db->createCommand();
     $expense = new Expense();
     if (isset($_POST['request'])) {
         $command->insert('request', array('req_date' => $dates, 'provider_id' => $_POST['provider']));
         $lastId = Yii::app()->db->lastInsertID;
         foreach ($_POST['request'] as $key => $val) {
             foreach ($val as $keys => $value) {
                 $count = $expense->changeToFloat($value['count']);
                 $command->insert('request_prod', array('request_id' => $lastId, 'prod_id' => $keys, 'depId' => $key, 'count' => $count));
             }
         }
         $this->redirect(array('view', 'id' => $lastId));
     }
     $this->render('request', array('depId' => $depId, 'prodList' => $prodList, 'provList' => $provList));
 }