package store;
import java.sql.*;
public class ModifyOrder {
  DBConn conn=new DBConn();
  public ModifyOrder(){}
  /*orderid：訂單號
   *id：訂單表中記錄號
   *newqu：更新的商品數量
   */
  public boolean  modifyItem(int orderid,int id,int newqu) throws Exception {
    boolean flag=false;
    int oldqu=getQuantity(id,conn);

    ProInfo PI=(new OrderItems()).getProInfo(id);
      float price=newqu*PI.getPrice();  //得到該條高品重新計算的總價
      int _qu=newqu-oldqu;               //得到更新數量與原數量的差
      float nprice=_qu*PI.getPrice();

      //更新訂單表中的商品條目信息
      int u1=conn.update("UPDATE orders SET quantity="+newqu+" WHERE id="+id);
      //更新訂單表中的訂單信息
      int u2=conn.update("UPDATE orders SET quantity=quantity+"+_qu+
                         ",price=price+"+nprice+" WHERE isorder=1 AND orderid="+orderid);

      if(u1>0&&u2>0)
        flag=true;
    conn.DBclose();
    return flag;
  }
  public boolean deleteItem(int orderid,int id) throws Exception {
    boolean flag=false;
    ProInfo PI=(new OrderItems()).getProInfo(id);
    float price=PI.getPrice();
    int qu=PI.getSold();
    //更新訂單表中的訂單信息
    int u2=conn.update("UPDATE orders SET quantity=quantity-"+qu+
                   ",price=price-"+price*qu+" WHERE isorder=1 AND orderid="+orderid);
    //刪除訂單表中的商品條目信息
    int u1=conn.update("DELETE from orders WHERE id="+id);

    if(u1>0&&u2>0)
        flag=true;
    conn.DBclose();
    return flag;
  }
  public boolean deleteOrder(int orderid) throws Exception {
     boolean flag=false;
     int u=conn.update("DELETE from orders WHERE orderid="+orderid);
     if(u>0)
       flag=true;
     conn.DBclose();
     return flag;
  }
  /*用于修改送貨方式，付款方式
   *orderid是單號,參數m用于控制修改的字段是送貨方式或付款方式
   *value的值根據參數的不同，表示的意義分別是送貨方式或付款方式*/
  public boolean modifyMethod(int orderid,int value,int m) throws Exception {
    boolean flag=false;
    int u=0;
    if(m==1){
      u = conn.update("UPDATE orders SET delivery=" + value +
                      " WHERE isorder=1 AND orderid=" + orderid);
     }
    if(m==2){
     u = conn.update("UPDATE orders SET payment=" + value +
                  " WHERE isorder=1 AND orderid=" + orderid);
    }
    if(u>0)
      flag=true;
    conn.DBclose();
    conn=null;
    return flag;
 }
  /*獲取指定定單中某商品數量
   *id是orders表是的記錄號，conn是數據庫連接對象*/
  public int getQuantity(int id,DBConn conn)throws Exception{
    String sql1="SELECT * FROM orders WHERE id="+id;

    ResultSet rs1=conn.query(sql1);
    rs1.next();
    int quantity=rs1.getInt("quantity");
    rs1.close();
    return quantity;
  }
}