Examples with VNPlanning org.devgateway.ocvn.persistence.mongo.dao.VNPlanning used on opensource projects

Example 1 with VNPlanning

use of org.devgateway.ocvn.persistence.mongo.dao.VNPlanning in project ocvn by devgateway.

the class AwardReleaseRowImporter method newReleaseFromAwardFactory.

public Release newReleaseFromAwardFactory(String planningBidNo) {
    Release release = new Release();
    release.getTag().add(Tag.award);
    release.setOcid(MongoConstants.OCDS_PREFIX + "bidno-" + planningBidNo);
    VNPlanning planning = new VNPlanning();
    release.setPlanning(planning);
    planning.setBidNo(planningBidNo);
    return release;
}

Example 2 with VNPlanning

use of org.devgateway.ocvn.persistence.mongo.dao.VNPlanning in project ocvn by devgateway.

the class TenderRowImporter method createReleaseFromReleaseRow.

@Override
public Release createReleaseFromReleaseRow(final String[] row) throws ParseException {
    Release release = repository.findByPlanningBidNo(getRowCell(row, 0));
    if (release == null) {
        release = new Release();
        release.setOcid(MongoConstants.OCDS_PREFIX + "bidno-" + getRowCell(row, 0));
        release.getTag().add(Tag.tender);
        VNPlanning planning = new VNPlanning();
        release.setPlanning(planning);
        planning.setBidNo(getRowCell(row, 0));
    }
    VNTender tender = (VNTender) release.getTender();
    if (tender == null) {
        tender = new VNTender();
        tender.setId(release.getOcid());
        release.setTender(tender);
    }
    readStatusFromReleaseRow(row, tender);
    tender.setApproveState(getRowCell(row, 1));
    tender.setCancelYN(getRowCell(row, 2));
    tender.setModYn(getRowCell(row, 3));
    tender.setBidMethod(getInteger(getRowCell(row, 4)));
    readProcurementMethodFromReleaseRow(row, tender);
    String contrMethodDetail = getRowCell(row, 6);
    if (contrMethodDetail != null) {
        ContrMethod contrMethod = contrMethodRepository.findByDetails(contrMethodDetail);
        if (contrMethod == null) {
            contrMethod = new ContrMethod();
            contrMethod.setDetails(contrMethodDetail);
            // switch (contrMethodId) {
            // case 1:
            // contrMethod.setDetails("Trọn gói");
            // break;
            // case 2:
            // contrMethod.setDetails("Theo đơn giá");
            // break;
            // case 3:
            // contrMethod.setDetails("Theo thời gian");
            // break;
            // case 4:
            // contrMethod.setDetails("Theo tỷ lệ phần trăm");
            // break;
            // case 5:
            // contrMethod.setDetails("Hỗn hợp");
            // break;
            // default:
            // contrMethod.setDetails("Undefined");
            // break;
            // }
            contrMethod = contrMethodRepository.insert(contrMethod);
        }
        tender.setContrMethod(contrMethod);
    }
    Period period = new Period();
    period.setStartDate(getExcelDate(getRowCell(row, 7)));
    period.setEndDate(getExcelDate(getRowCell(row, 8)));
    tender.setTenderPeriod(period);
    tender.setBidOpenDt(getExcelDate(getRowCell(row, 9)));
    Organization procuringEntity = organizationRepository.findByAllIds(getRowCellUpper(row, 10));
    if (procuringEntity == null) {
        procuringEntity = OrganizationRepositoryUtil.newAndInsertOrganization(Organization.OrganizationType.procuringEntity, getRowCellUpper(row, 10), organizationRepository);
    } else {
        procuringEntity = OrganizationRepositoryUtil.ensureOrgIsOfTypeAndSave(procuringEntity, Organization.OrganizationType.procuringEntity, organizationRepository);
    }
    tender.setProcuringEntity(procuringEntity);
    Organization orderInstituCd = organizationRepository.findByAllIds(getRowCellUpper(row, 11));
    if (orderInstituCd == null) {
        orderInstituCd = OrganizationRepositoryUtil.newAndInsertOrganization(Organization.OrganizationType.buyer, getRowCellUpper(row, 11), organizationRepository);
    } else {
        orderInstituCd = OrganizationRepositoryUtil.ensureOrgIsOfTypeAndSave(orderInstituCd, Organization.OrganizationType.procuringEntity, organizationRepository);
    }
    release.setBuyer(orderInstituCd);
    if (getRowCell(row, 12) != null) {
        Amount value = new Amount();
        value.setCurrency("VND");
        value.setAmount(getDecimal(getRowCell(row, 12)));
        tender.setValue(value);
    }
    tender.setPublicationMethod(getRowCell(row, 14));
    tender.setCancellationRationale(getRowCell(row, 15));
    readLocationAndClassificationFromReleaseRow(row, tender);
    return release;
}

Example 3 with VNPlanning

use of org.devgateway.ocvn.persistence.mongo.dao.VNPlanning in project ocvn by devgateway.

the class BidPlansRowImporter method createReleaseFromReleaseRow.

@Override
public Release createReleaseFromReleaseRow(final String[] row) throws ParseException {
    String projectID = getRowCell(row, 0);
    Release release = repository.findByBudgetProjectId(projectID);
    if (release == null) {
        release = new Release();
        release.getTag().add(Tag.planning);
        release.setOcid(MongoConstants.OCDS_PREFIX + "prjid-" + projectID);
        VNPlanning planning = new VNPlanning();
        release.setPlanning(planning);
    }
    Budget budget = release.getPlanning().getBudget();
    if (budget == null) {
        budget = new Budget();
        release.getPlanning().setBudget(budget);
    }
    budget.setProjectID(getRowCell(row, 0));
    Amount value = new Amount();
    value.setCurrency("VND");
    budget.setAmount(value);
    // decimal2
    value.setAmount(getDecimal(getRowCell(row, 5)));
    Tender tender = release.getTender();
    if (tender == null) {
        tender = new VNTender();
        tender.setId(release.getOcid());
        release.setTender(tender);
    }
    // create Items
    VNItem item = new VNItem();
    item.setId(Integer.toString(tender.getItems().size()));
    tender.getItems().add(item);
    // decimal2
    value.setAmount(getDecimal(getRowCell(row, 5)));
    item.setDescription(getRowCell(row, 1));
    item.setBidPlanItemRefNum(getRowCell(row, 2));
    item.setBidPlanItemStyle(getRowCell(row, 3));
    item.setBidPlanItemFund(getRowCell(row, 4));
    item.setBidPlanItemMethodSelect(getRowCell(row, 6));
    item.setBidPlanItemMethod(getRowCell(row, 7));
    item.setId(getRowCell(row, 8));
    return release;
}

Example 4 with VNPlanning

use of org.devgateway.ocvn.persistence.mongo.dao.VNPlanning in project ocvn by devgateway.

the class ProcurementPlansRowImporter method createReleaseFromReleaseRow.

@Override
public Release createReleaseFromReleaseRow(final String[] row) throws ParseException {
    String projectID = getRowCell(row, 0);
    Release oldRelease = repository.findByBudgetProjectId(projectID);
    if (oldRelease != null) {
        throw new RuntimeException("Duplicate planning.budget.projectID");
    }
    Release release = new Release();
    release.setOcid(MongoConstants.OCDS_PREFIX + "prjid-" + projectID);
    release.getTag().add(Tag.planning);
    VNPlanning planning = new VNPlanning();
    VNBudget budget = new VNBudget();
    release.setPlanning(planning);
    planning.setBudget(budget);
    // search for locations
    if (getRowCell(row, 3) != null) {
        String[] locations = getRowCell(row, 3).split(",");
        for (int i = 0; i < locations.length; i++) {
            VNLocation location = locationRepository.findByDescription(locations[i].trim());
            if (location == null) {
                location = new VNLocation();
                location.setDescription(locations[i]);
                location = locationRepository.insert(location);
            }
            budget.getProjectLocation().add(location);
        }
    }
    planning.setBidPlanProjectDateIssue(getExcelDate(getRowCell(row, 4)));
    planning.setBidPlanProjectCompanyIssue(getRowCell(row, 6));
    planning.setBidPlanProjectFund(getInteger(getRowCell(row, 8)));
    budget.getProjectClassification().setDescription(getRowCell(row, 9));
    planning.setBidPlanProjectDateApprove(getExcelDate(getRowCell(row, 10)));
    budget.getProjectClassification().setId(getRowCell(row, 12));
    planning.setBidNo(getRowCell(row, 13));
    budget.setProjectID(getRowCell(row, 0));
    budget.setBidPlanProjectStyle(getRowCell(row, 5));
    budget.setBidPlanProjectType(getRowCell(row, 7));
    budget.setProject(getRowCell(row, 1));
    budget.setDescription(getRowCell(row, 11));
    Amount value = new Amount();
    budget.setProjectAmount(value);
    value.setCurrency("VND");
    value.setAmount(getDecimal(getRowCell(row, 2)));
    return release;
}