예제 #1
0
  public Excel2Entity(
      IWorkbenchContext context,
      SequenceService sequenceService,
      AddressService addressService,
      ClientGroupService clientGroupService,
      ClientTypeService clientTypeService,
      HSSFRow row) {
    this.sequenceService = sequenceService;
    this.addressService = addressService;
    this.clientTypeService = clientTypeService;
    this.clientGroupService = clientGroupService;

    this.row = row;

    client = new Client();
    List<Organization> organizations = new ArrayList<Organization>();
    organizations.add(context.getOrganization());

    client.setOrganizations(organizations);
  }
예제 #2
0
  public Client parse() {
    if (row.getCell(CODE) == null) {
      try {
        client.setCode(sequenceService.setNextSequence(Sequence.CODE.CLIENT.name()));
      } catch (Exception e) {
        e.printStackTrace();
      }
    } else client.setCode(row.getCell(CODE).getStringCellValue());

    if (row.getCell(NAME) != null) client.setName(row.getCell(NAME).getStringCellValue());

    if (row.getCell(DESCRIPTION) != null)
      client.setDescription(row.getCell(DESCRIPTION).getStringCellValue());

    if (row.getCell(PHONE) != null) {
      row.getCell(PHONE).setCellType(Cell.CELL_TYPE_STRING);
      client.setPhone(row.getCell(PHONE).getStringCellValue());
    }

    if (row.getCell(FAX) != null) {
      row.getCell(FAX).setCellType(Cell.CELL_TYPE_STRING);
      client.setFax(row.getCell(FAX).getStringCellValue());
    }

    if (row.getCell(MOBILE) != null) {
      row.getCell(MOBILE).setCellType(Cell.CELL_TYPE_STRING);
      client.setMobile(row.getCell(MOBILE).getStringCellValue());
    }

    if (row.getCell(EMAIL) != null) client.setEmail(row.getCell(EMAIL).getStringCellValue());

    if (row.getCell(ADDRESS) != null) {
      Address address = null;
      try {
        address = addressService.getByStreet(row.getCell(ADDRESS).getStringCellValue());
      } catch (Exception e) {
        address = new Address();
        address.setStreet(row.getCell(ADDRESS).getStringCellValue());
      }

      client.setClientAddress(address);
    }

    if (row.getCell(VAT) != null) client.setVat(row.getCell(VAT).getStringCellValue());

    if (row.getCell(TYPE) != null) {
      ClientType clientType = null;
      try {
        clientType = clientTypeService.getByCode(row.getCell(TYPE).getStringCellValue());
      } catch (Exception e) {
        clientType = new ClientType();
        clientType.setCode(row.getCell(TYPE).getStringCellValue());
        clientType.setDescription(row.getCell(TYPE).getStringCellValue());
      }

      client.setClientType(clientType);
    }

    if (row.getCell(GROUP) != null) {
      ClientGroup clientGroup = null;
      try {
        clientGroup = clientGroupService.getByName(row.getCell(GROUP).getStringCellValue());
      } catch (Exception e) {
        clientGroup = new ClientGroup();
        clientGroup.setName(row.getCell(GROUP).getStringCellValue());
        clientGroup.setDescription(row.getCell(GROUP).getStringCellValue());
      }

      client.setClientGroup(clientGroup);
    }

    if (row.getCell(COMMENT) != null) client.setComment(row.getCell(COMMENT).getStringCellValue());

    if (row.getCell(ACTIVE) != null) {
      if (row.getCell(ACTIVE).getStringCellValue().equals("1")) client.setActive(true);
      else client.setActive(false);
    }

    return client;
  }