/** 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(); } }