package junittest;

import junit.framework.*;
import data.*;
import user.*;

public class TestStockManagementData extends TestCase {
  private StockManagementData stockManagementData = null;

  protected void setUp() throws Exception {
    super.setUp();
    stockManagementData = new StockManagementData();
  }
  protected void tearDown() throws Exception {
    stockManagementData = null;
    super.tearDown();
  }
  //測試檢查用戶的方法
  public void testCheckUser() {
    //測試正確的用戶名
    String userName = "jack";
    String userPassword = "jack";
    //檢查用戶的方法
    int[] functions = stockManagementData.checkUser(userName, userPassword);
    this.assertEquals("return value", 0, functions[0]);
    //測試錯誤的用戶名
    userName = "jack1";
    userPassword = "jack";
    //檢查用戶的方法
    functions = stockManagementData.checkUser(userName, userPassword);
    this.assertEquals("return value", -1, functions[0]);
  }
  //測試創建用戶的方法
  public void testCreateUser() {
    String userName = "test";
    String userPassword = "test";
    int baseInforFunction = 0;
    int stockFunction = 0;
    int stockManageFunction = 0;
    int saleFunction = 0;
    User user = new User(userName, userPassword, baseInforFunction,
                         stockFunction, stockManageFunction, saleFunction);
    int result = stockManagementData.createUser(user);
    this.assertEquals("return value", 1, result);
  }
  //測試更新用戶的方法
  public void testUpdateUser() {
    String userName = "test";
    String userPassword = "test1";
    int baseInforFunction = 1;
    int stockFunction = 1;
    int stockManageFunction = 1;
    int saleFunction = 1;
    User user = new User(userName, userPassword, baseInforFunction,
                         stockFunction, stockManageFunction, saleFunction);
    int result = stockManagementData.updateUser(user);
    this.assertEquals("return value", 1, result);
  }
  //測試刪除用戶的方法
  public void testDeleteUser() {
    String userName = "test";
    String userPassword = "test";
    int baseInforFunction = 0;
    int stockFunction = 0;
    int stockManageFunction = 0;
    int saleFunction = 0;
    User user = new User(userName, userPassword, baseInforFunction,
                         stockFunction, stockManageFunction, saleFunction);
    int result = stockManagementData.deleteUser(user);
    this.assertEquals("return value", 1, result);
  }
  //測試查詢用戶的方法
  public void testGetUserByUserName() {
    String userName = "jack";
    String[][] result = stockManagementData.getUserByUserName(userName);
    this.assertEquals("return value", "jack", result[0][1]);
  }
  //測試日志數據表記錄的創建方法
  public void testCreateUserLog() throws Exception{
    String programName = "登陸窗口";
    String operationContent = "登陸";
    String userName = "jack";
    //int result = stockManagementData.createUserLog(programName, operationContent, userName);
    //this.assertEquals("return value", 1, result);
  }
  //測試日志數據表記錄的刪除方法
  public void testDeleteUserLog() throws Exception{
    Integer id = new Integer(1);
    //int result = stockManagementData.deleteUserLog(id);
    //this.assertEquals("return value", 1, result);
  }
  //測試返回數據庫的所有數據表名字方法
  public void testGetTableNames() throws Exception{
    String[] tableNames = stockManagementData.getTableNames();
    this.assertEquals("returnValue", "accountEntryLedger", tableNames[0]);
    //this.assertEquals("returnValue", "accountName", tableNames[1]);
  }
  //測試取得數據表數據的方法
  public void testGetDataByTableName() throws Exception{
    String[][] data = stockManagementData.getDataByTableName("userTable");
    this.assertEquals("returnValue", "ame", data[0][0]);
  }
  //測試寫入數據表數據的方法
  public void testSetDataByTableName() throws Exception{
    String[][] data = new String[][] {
        {"20040427", "0", "供應商", "請購員", "訂購員", "驗收員", "現金管理員", "收貨地址",
        "倉庫", "2004-04-26", "2004-4-26 18:16:10", "1", "備注"},
        {"20040426", "0", "aa1", "aa2", "aa3", "aa4", "aa5", "aa6", "aa7",
        "2004-04-26", "2004-4-26 18:16:10", "0", "ss"}
    };
    //向數據表stockLedger寫入記錄
    int result = stockManagementData.setDataByTableName("stockLedger", data);
    this.assertEquals("returnValue", 1, result);
    data = new String[][] {
        {"1", "20040427", "55566", "15.23", "58", "2004-04-26"},
        {"2", "20040426", "55566", "15.23", "58", "2004-04-26 13:45:12"}
    };
    //向數據表stockSubLedger寫入記錄
    result = stockManagementData.setDataByTableName("stockSubLedger", data);
    this.assertEquals("returnValue", 1, result);
  }
  //測試取得帳套名字的方法
  public void testGetLedgerNames() throws Exception{
    String[] ledgerNames = stockManagementData.getLedgerNames();
    this.assertEquals("return value", 1, ledgerNames.length);
  }
  //測試創建帳套的方法
  public void testCreateLedger()  throws Exception{
    String ledgerDate = "200405";
    int result = stockManagementData.createLedger(ledgerDate);
    this.assertEquals("return value", 1, result);
    result = stockManagementData.createLedger(ledgerDate);
    this.assertEquals("return value", 0, result);
  }

  //測試刪除帳套的方法
  public void testDeleteLedger()  throws Exception{
    String ledgerDate = "200403";
    int result = stockManagementData.deleteLedger(ledgerDate);
    this.assertEquals("return value", 0, result);
  }
  //測試商品類別的創建方法
  public void testCreateGoodsCategory() throws Exception{
    /*int parentId = 0;
    String categoryName = "商品類別1";
    String categoryDescription = "商品類別1的描述";
    int result = stockManagementData.createGoodsCategory(parentId, categoryName, categoryDescription);
    this.assertEquals("return value", 1, result);
    parentId = 0;
    categoryName = "商品類別2";
    categoryDescription = "商品類別2的描述";
    result = stockManagementData.createGoodsCategory(parentId, categoryName, categoryDescription);
    this.assertEquals("return value", 1, result);*/
  }
  //測試商品類別的更新方法
  public void testUpdateGoodsCategory() throws Exception{
    int categoryId = 1;
    int parentId = 0;
    String categoryName = "商品類別1(更新)";
    String categoryDescription = "商品類別1的描述";
    int result = stockManagementData.updateGoodsCategory(categoryId, parentId,
        categoryName, categoryDescription);
    this.assertEquals("return value", 1, result);
  }
  //測試商品類別的findAll方法
  public void testFindAll() throws Exception{
    String[][] detail = stockManagementData.getAllGoodsCategory();
    this.assertEquals("", 2, detail.length);
  }
  //測試商品類別的刪除方法
  public void testDeleteGoodsCategory() throws Exception{
    /*int categoryId = 1;
    int result = stockManagementData.deleteGoodsCategory(categoryId);
    this.assertEquals("return value", 1, result);
    categoryId = 2;
    result = stockManagementData.deleteGoodsCategory(categoryId);
    this.assertEquals("return value", 1, result);*/
  }
  //測試商品創建方法
  public void testGoodsCreate() throws Exception {
    /*String goodsBarCode = "10000001";
    int categoryId = 1;
    String goodsName  = "類別1的商品1";
    String goodsNickName = "別名1";
    String goodsAssistantName = "助記碼1";
    String goodsPYName = "LBDSP1";
    String unit = "件";
    String specification = "每箱10件";
    String producer = "生產廠商1";
    int upperLimit = 0;
    int lowerLimit = 0;
    double salePrice = 15;
    double discount = 1;
    //創建商品
    int result = stockManagementData.createGoods(goodsBarCode, categoryId,
                     goodsName, goodsNickName, goodsAssistantName, goodsPYName, unit,
                     specification, producer, upperLimit, lowerLimit, salePrice, discount);
    this.assertEquals("return value", 1, result);
    goodsBarCode = "10000002";
    categoryId = 1;
    goodsName  = "類別1的商品2";
    goodsNickName = "別名2";
    goodsAssistantName = "助記碼2";
    goodsPYName = "LBDSP2";
    unit = "件";
    specification = "每箱10件";
    producer = "生產廠商2";
    upperLimit = 0;
    lowerLimit = 0;
    salePrice = 20.12;
    discount = 0.56;
    //創建商品
    result = stockManagementData.createGoods(goodsBarCode, categoryId, goodsName,
                  goodsNickName, goodsAssistantName, goodsPYName, unit,
                  specification, producer, upperLimit, lowerLimit, salePrice, discount);
    this.assertEquals("return value", 1, result);*/
  }
  //測試商品更新方法
  public void testGoodsUpdate() throws Exception {
    String goodsBarCode = "10000001";
    int categoryId = 1;
    String goodsName  = "類別1的商品1（更新）";
    String goodsNickName = "別名1";
    String goodsAssistantName = "助記碼1";
    String goodsPYName = "LBDSP1";
    String unit = "件";
    String specification = "每箱10件";
    String producer = "生產廠商1";
    int upperLimit = 0;
    int lowerLimit = 0;
    double salePrice = 15;
    double discount = 1;
    int result = stockManagementData.updateGoods(goodsBarCode, categoryId, goodsName,
                  goodsNickName, goodsAssistantName, goodsPYName, unit,
                  specification, producer, upperLimit, lowerLimit, salePrice, discount);
    this.assertEquals("return value", 1, result);
  }
  //測試根據類別取得商品的方法
  public void testFindByGoodsCategory() throws Exception {
    int goodsCategory = 1;
    String[][] detail = stockManagementData.getGoodsByGoodsCategory(goodsCategory);
    this.assertEquals("", 2, detail.length);
  }
  //測試根據條形碼取得商品的方法
  public void testFindByGoodsBarCode() throws Exception {
    String goodsBarCode = "1";
    String[][] detail = stockManagementData.getGoodsByGoodsBarCode(goodsBarCode);
    this.assertEquals("", 3, detail.length);
  }
  //測試根據商品名字取得商品的方法
  public void testFindByGoodsName() throws Exception {
    String goodsName = "商品";
    String[][] detail = stockManagementData.getGoodsByGoodsName(goodsName);
    this.assertEquals("", 3, detail.length);
  }
  //測試根據生產廠商取得商品的方法
  public void testFindByProducer() throws Exception {
    String goodsName = "生產廠商";
    String[][] detail = stockManagementData.getGoodsByProducer(goodsName);
    this.assertEquals("", 3, detail.length);
  }
  //測試設置商品折扣的方法
  public void testSetGoodsDiscount() throws Exception {
    String goodsBarCode = "10000001";
    double discount = 0.85;
    int result = stockManagementData.setGoodsDiscount(goodsBarCode, discount);
    this.assertEquals("return value", 1, result);
  }
  //測試取得折扣商品的方法
  public void testFindDiscountGoods() throws Exception {
    String[][] detail = stockManagementData.getDiscountGoods();
    this.assertEquals("", 2, detail.length);
  }
  //測試商品刪除方法
  public void testGoodsDelete() throws Exception {
    /*String goodsBarCode = "10000001";
    int result = stockManagementData.deleteGoods(goodsBarCode);
    this.assertEquals("return value", 1, result);
    goodsBarCode = "10000002";
    result = stockManagementData.deleteGoods(goodsBarCode);
    this.assertEquals("return value", 1, result);*/
  }
  //測試供應商創建方法
  public void testSupplierCreate() throws Exception{
    //創建供應商數組
    String[] supplier = new String[]{"測試供應商1", "南部", "拼音碼1", "簡稱1", "021-556892",
        "張凡", "1350058956", "021-896523", "021-963258", "地址1", "511896",
        "中行", "銀行帳號", "jack@hotmail.com", "www.jack.com", "備注1"};
    //創建供應商
    int result = stockManagementData.createSupplier(supplier);
    this.assertEquals("", 1, result);
    supplier = new String[]{"測試供應商2", "北部", "拼音碼2", "簡稱2", "021-556892",
        "張凡", "1350058956", "021-896523", "021-963258", "地址2", "511896",
        "中行", "銀行帳號", "jack@hotmail.com", "www.jack.com", "備注2"};
    //創建供應商
    result = stockManagementData.createSupplier(supplier);
    this.assertEquals("", 1, result);
    supplier = new String[]{"測試供應商3", "南部", "拼音碼3", "簡稱3", "021-556892",
        "張凡", "1350058956", "021-896523", "021-963258", "地址3", "511896",
        "中行", "銀行帳號", "jack@hotmail.com", "www.jack.com", "備注3"};
    //創建供應商