2 Replies Latest reply: Feb 5, 2016 6:59 AM by Sai Manogna Nallamothu RSS

    Regarding Coupon

    Sai Manogna Nallamothu

      Hi,

       

      I have a scenario of online food ordering system  where in:

      Order amount is calculated in the UI,but the key coloumn in the fact tablei.e coupon code is to be assigned based on the Order amount.help me solving how to assign couponcode to an order

        • Re: Regarding Coupon
          Manish Kachhia

          Provide some more information.. May be sample data would be great

          • Re: Regarding Coupon
            Sai Manogna Nallamothu


            I have Orderfact;order_id,customer_id,region_id,restaurant_id,couon_code

            orderDetail:Order_id,restaurant_id,item_id,item_price,item_quantity,

            coupon:coupon_code,coupon_descritpion,cut_offamunt_discount_amount

            i have concatenated the two tables adn orderfact and orderdetail.

            My problem is i have to assign couponcode based on 'order_amount(sum(item_rpice*item_quantity) which is calculted in UI') and them give discount to it based on coupon code.I have to get the coupon the order is eligible in UI and still be able to link the coupon table and orderfact table.