/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new ItemExpire();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['ItemExpire'])) {
$model->attributes = $_POST['ItemExpire'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
protected function saveItemExpire($item_expire_date, $receiving_id, $item_id, $employee_id, $quantity, $trans_date, $remarks)
{
if (!empty($item_expire_date)) {
$item_expire = ItemExpire::model()->find('item_id=:item_id and expire_date=:expire_date', array(':item_id' => (int) $item_id, ':expire_date' => $item_expire_date));
if (!$item_expire) {
$item_expire = new ItemExpire();
$qty_in_stock = 0;
} else {
$qty_in_stock = $item_expire->quantity;
}
$stock_quantity = $this->stockQuantiy($qty_in_stock, $quantity);
//Update Item expiry date & quantity
$item_expire->item_id = $item_id;
$item_expire->expire_date = $item_expire_date;
$item_expire->quantity = $stock_quantity[0];
$item_expire->save();
$item_expire_dt = new ItemExpireDt();
$item_expire_dt->item_expire_id = $item_expire->id;
$item_expire_dt->trans_id = $receiving_id;
$item_expire_dt->trans_qty = $stock_quantity[0];
$item_expire_dt->trans_comment = $remarks;
$item_expire_dt->modified_date = $trans_date;
$item_expire_dt->employee_id = $employee_id;
$item_expire_dt->save();
}
}
