package data;

import javax.naming.*;
import stockmanagementpro.*;
import user.*;
import javax.rmi.*;
import java.util.*;

public class StockManagementData {
  private StockManagementDataHome stockManagementDataHome = null;
  private stockmanagementpro.StockManagementData stockManagementData = null;

  public StockManagementData() {
    try{
      initialize();
    }catch(Exception ex){
      ex.printStackTrace();
    }
  }
  //EJB的初始化方法
  public void initialize() throws Exception {
    //創建服務器對象查找類
    Context context = getInitialContext();
    //取得EJB在服務器的對象
    Object ref = context.lookup("StockManagementData");
    //取得StockManagementData EJB的創建接口
    stockManagementDataHome = (StockManagementDataHome)PortableRemoteObject.narrow(ref,
        StockManagementDataHome.class);
    //取得StockManagementData EJB的遠程接口
    create();
  }
  //服務器對象查找類的創建方法
  private Context getInitialContext() throws Exception {
    String url = "t3://bemyfriend:7001";
    String user = null;
    String password = null;
    Properties properties = null;
    //初始化聯接服務器的屬性
    try {
      properties = new Properties();
      properties.put(Context.INITIAL_CONTEXT_FACTORY,
                     "weblogic.jndi.WLInitialContextFactory");
      properties.put(Context.PROVIDER_URL, url);
      if (user != null) {
        properties.put(Context.SECURITY_PRINCIPAL, user);
        properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
      }
      return new InitialContext(properties);
    }
    catch(Exception e) {
      System.out.println("Unable to connect to WebLogic server at " + url);
      System.out.println("Please make sure that the server is running.");
      throw e;
    }
  }
  //創建StockManagementData EJB的遠程接口
  public stockmanagementpro.StockManagementData create() throws Exception {
    stockManagementData = stockManagementDataHome.create();
    return stockManagementData;
  }
  //檢查用戶的方法
  public int[] checkUser(String userName, String userPassword){
    int[] functions = new int[4];
    try{
      functions = stockManagementData.checkUser(userName, userPassword);
    }catch(Exception ex){
      functions[0] = -1;
      functions[1] = -1;
      functions[2] = -1;
      functions[3] = -1;
    }
    return functions;
  }
  //創建用戶
  public int createUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.createUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //更新用戶
  public int updateUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.updateUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //刪除用戶
  public int deleteUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.deleteUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //根據用戶名查詢用戶
  public String[][] getUserByUserName(String userName){
    //創建存取用戶數據的數組
    String[][] detail = null;
    try{
      detail = stockManagementData.getUserByUserName(userName);
    }catch(Exception ex){
      detail = new String[0][6];
      ex.printStackTrace();
    }
    //返回數組
    return detail;
  }
  //日志數據表記錄的創建方法
  public int createUserLog(String programName, String operationContent,
                            String userName) {
    int result = 0;
    try{
      result = stockManagementData.createUserLog(programName, operationContent, userName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //日志數據表記錄的刪除方法
  public int deleteUserLog(Integer id){
    int result = 0;
    try{
      result = stockManagementData.deleteUserLog(id);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //返回數據庫所有數據表名字的方法
  public String[] getTableNames() {
    String[] tableNames = new String[0];
    try{
      tableNames = stockManagementData.getTableNames();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return tableNames;
  }
  //返回數據表數據的方法
  public String[][] getDataByTableName(String tableName) {
    String[][] data = new String[0][0];
    try{
      data = stockManagementData.getDataByTableName(tableName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return data;
  }
  //將數組寫入數據表的方法
  public int setDataByTableName(String tableName, String[][] data) {
    int result = 0;
    try{
      result = stockManagementData.setDataByTableName(tableName, data);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //取得賬套名字的方法
  public String[] getLedgerNames() {
    String[] ledgerNames = new String[0];
    try{
      ledgerNames = stockManagementData.getLedgerNames();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return ledgerNames;
  }
  //創建賬套的方法
  public int createLedger(String ledgerDate) {
    int result = 0;
    try{
      result = stockManagementData.createLedger(ledgerDate);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //刪除賬套的方法
  public int deleteLedger(String ledgerDate) {
    int result = 0;
    try{
      result = stockManagementData.deleteLedger(ledgerDate);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //創建商品類別的方法
  public int createGoodsCategory(int parentId, String categoryName, String categoryDescription) {
    int result = 0;
    try {
      result = stockManagementData.createGoodsCategory(parentId,
        categoryName, categoryDescription);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //更新商品類別的方法
  public int updateGoodsCategory(int categoryId, int parentId,
                                 String categoryName,
                                 String categoryDescription) {
    int result = 0;
    try {
      result = stockManagementData.updateGoodsCategory(categoryId, parentId,
        categoryName, categoryDescription);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //刪除商品類別的方法
  public int deleteGoodsCategory(int categoryId) {
    int result = 0;
    try {
      result = stockManagementData.deleteGoodsCategory(categoryId);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //取得所有商品類別的方法
  public String[][] getAllGoodsCategory() {
    String[][] detail = new String[0][4];
    try{
      //取得商品類別的所有記錄
      detail = stockManagementData.getAllGoodsCategory();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //創建商品的方法
  public int createGoods(String goodsBarCode, int categoryId, String goodsName,
                         String goodsNickName, String goodsAssistantName,
                         String goodsPYName, String unit, String specification,
                         String producer, int upperLimit, int lowerLimit,
                         double salePrice, double discount) {
     int result = 0;
     try {
       result = stockManagementData.createGoods(goodsBarCode, categoryId, goodsName,
                     goodsNickName, goodsAssistantName, goodsPYName, unit,
                     specification, producer, upperLimit, lowerLimit, salePrice, discount);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新商品的方法
  public int updateGoods(String goodsBarCode, int categoryId, String goodsName,
                         String goodsNickName, String goodsAssistantName,
                         String goodsPYName, String unit, String specification,
                         String producer, int upperLimit, int lowerLimit,
                         double salePrice, double discount) {
    int result = 0;
    try {
      result = stockManagementData.updateGoods(goodsBarCode, categoryId, goodsName,
                    goodsNickName, goodsAssistantName, goodsPYName, unit,
                    specification, producer, upperLimit, lowerLimit, salePrice, discount);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //刪除商品的方法
  public int deleteGoods(String goodsBarCode) {
     int result = 0;
     try {
       result = stockManagementData.deleteGoods(goodsBarCode);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根據類別取得商品的方法
  public String[][] getGoodsByGoodsCategory(int goodsCategory){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsCategory(goodsCategory);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根據條形碼取得商品的方法
  public String[][] getGoodsByGoodsBarCode(String goodsBarCode){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsBarCode(goodsBarCode);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根據商品名字取得商品的方法
  public String[][] getGoodsByGoodsName(String goodsName){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsName(goodsName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根據生產廠商取得商品的方法
  public String[][] getGoodsByProducer(String producer){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByProducer(producer);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //取得折扣商品的方法
  public String[][] getDiscountGoods(){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getDiscountGoods();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //設置商品折扣的方法
  public int setGoodsDiscount(String goodsBarCode, double discount){
    int result = 0;
    try {
      result = stockManagementData.setGoodsDiscount(goodsBarCode, discount);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //創建供應商的方法
  public int createSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //創建供應商
       result = stockManagementData.createSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新供應商的方法
  public int updateSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //更新供應商
       result = stockManagementData.updateSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //刪除供應商的方法
  public int deleteSupplier(String supplierName) {
     int result = 0;
     try {
       result = stockManagementData.deleteSupplier(supplierName);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根據供應商名字取得記錄的方法
  public String[][] getSuppliersBySupplierName(String supplierName){
    String[][] detail = new String[0][16];
    try{
      //根據供應商名字取得記錄
      detail = stockManagementData.getSuppliersBySupplierName(supplierName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根據地區取得供應商記錄的方法
  public String[][] getSuppliersBySupplierZone(String supplierZone){
    String[][] detail = new String[0][16];
    try{