Package org.bgerp.plugin.inventory.sync1c.service

Class ImportService

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.sync1c.service.ImportService

public class ImportService
extends CommonDAO

Imports stock data from 1C into BGERP inventory tables. For each EngineerWarehouse: 1. Calls Api1cClient.getStocks(warehouseName, locationName) 2. Upserts inventory_item (by ext_id param = product_id) 3. Upserts inventory_store (by ext_id param = warehouse_id), links to engineer_warehouse.store_id 4. Writes to inventory_sync1c_import_pending (NOT directly to inventory_balance). The warehouse owner must confirm in user UI to apply balances.

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
ImportService(Connection con)

Method Summary

Modifier and Type	Method	Description
int	syncEngineerWarehouse(Sync1cInstance instance, EngineerWarehouse ew)	Runs import for one engineer warehouse mapping.

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ImportService

public ImportService(Connection con)

Method Details

syncEngineerWarehouse

public int syncEngineerWarehouse(Sync1cInstance instance,
 EngineerWarehouse ew)

Runs import for one engineer warehouse mapping. Logs progress to inventory_sync1c_import_log.

Returns:

number of items synced; -1 on API error