public function setCouponSavingInUse(CouponSaving $couponSaving, $discount, $orderId) { $state = CouponState::IN_CART; $id = $couponSaving->getCouponSavingId(); if ($couponSaving->getState() == CouponState::COMPLETED || $couponSaving->getState() == CouponState::IN_CART) { $updateQuery = "UPDATE coupon_saving set discount_amount={$discount} , order_id={$orderId}, state='{$state}' where coupon_saving_id={$id}"; // echo $updateQuery; Mage::log(" update query to used query {$updateQuery}", null, 'custom.log'); $this->writeConnection->query($updateQuery); } return $couponSaving; }