/**
* Default view all wineries
*/
public function actionCreate()
{
$wineList = Wines::model()->findByPk($id);
$this->renderOutput($wineList);
}
/**
* 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 Wines the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Wines::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* @return string the associated database table name
*/
public function refreshRating($wine_id)
{
$newRatingAvg = 0;
$currWine = Wines::model()->findByPk($wine_id);
$wineInCellars = new CellarWines();
$this->overall_rating = $newRatingAvg;
// propogate the result of saving to the calling code
return $currWine->save();
}
/**
* Add an existing wine into the cellar
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id the ID of the wine to be added
*/
public function actionAddWine($wine_id)
{
$model = new CellarWines();
$currentDateTime = new DateTime("now", new DateTimeZone('America/Chicago'));
if (isset($_POST['CellarWines'])) {
$model->attributes = $_POST['CellarWines'];
$model->cellar_id = Yii::app()->session['cellar_id'];
$model->wine_id = $wine_id;
$model->create_dt = $currentDateTime->format('Y-m-d H:i:s');
$model->update_dt = $currentDateTime->format('Y-m-d H:i:s');
if ($model->save()) {
$this->redirect(array('index', 'cellar_id' => $model->cellar_id));
}
} else {
$selectedWine = Wines::model()->findByPk($wine_id);
$model->cellar_id = Yii::app()->session['cellar_id'];
$model->wine_id = $wine_id;
$model->quantity = 0;
$model->rating = $selectedWine->overall_rating;
$model->cellar_loc_id = 1;
$model->create_dt = $currentDateTime->format('Y-m-d H:i:s');
$model->update_dt = $currentDateTime->format('Y-m-d H:i:s');
}
$this->render('update', array('model' => $model));
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
// if (!isset($_GET['ajax']))
// {
// $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('update', 'id' => $model->id));
// }
}
