/** Populates ItemPrices.price_supplement for uk_vat */
public function uk_vat()
{
App::import('model', 'ItemPrice');
$this->ItemPrice = new ItemPrice();
$sql = "SELECT * FROM item_prices WHERE item_price_type_id = 6 AND start_date <= NOW() AND (end_date IS NULL OR end_date > NOW())";
$results = $this->ItemPrice->query($sql);
foreach ($results as $result) {
//end item price
$this->ItemPrice->id = $result['item_prices']['id'];
$this->ItemPrice->saveField('end_date', DboSource::expression('NOW()'));
$original_price = $result['item_prices']['price'];
$price_supplement = round($original_price / 6, 2);
$new_price = $original_price - $price_supplement;
unset($result['item_prices']['id']);
$result['item_prices']['price'] = $new_price;
$result['item_prices']['price_supplement'] = $price_supplement;
$result['item_prices']['start_date'] = DboSource::expression('NOW()');
//add new record
$new_item = new ItemPrice();
$new_item->create();
$new_item->save($result['item_prices']);
}
}
public function saveItemPrice($item_id, $new_price, $old_price)
{
if ($new_price != $old_price) {
$item_price = new ItemPrice();
$item_price->item_id = $item_id;
$item_price->old_price = $old_price;
$item_price->new_price = $new_price;
$item_price->employee_id = Yii::app()->session['employeeid'];
$item_price->modified_date = date('Y-m-d H:i:s');
$item_price->save();
}
}
protected function updateItemPrice($item_id, $cur_unit_price, $unit_price, $employee_id, $trans_date)
{
if ($cur_unit_price != $unit_price) {
$item_price = new ItemPrice();
$item_price->item_id = $item_id;
$item_price->old_price = $cur_unit_price;
$item_price->new_price = $unit_price;
$item_price->employee_id = $employee_id;
$item_price->modified_date = $trans_date;
$item_price->save();
}
}
