/** * Suggest stocking location based on provided attributes */ public function actionSuggestLocation($id) { $bins = array(); $model = $this->loadModel($id); $location = StockLocation::findLocationByName($model->PNUser9); if ($location != null) { $bins = StockLocation::suggestLocation($location->id); } $this->render('suggestLocation', array('location' => $location, 'bins' => $bins, 'model' => $model)); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return StockLocation the loaded model * @throws CHttpException */ public function loadModel($id) { $model = StockLocation::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public static function findLocationByName($name) { $model = StockLocation::model()->find(array('condition' => 'name=:name', 'params' => array(':name' => $name))); return $model; }