Methods
checkDcNumberInDB(dcNumber)
This function is responsible to fetch DC detai;s from DB based on DC number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The dc number to get details |
getDcNumberUserDetails(dcNumber, name, tokenNumber, mobile, outDc, outLocation, inDcTime, inlocation, inTokenNumber) → {getFabricDcEntryDetails}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
name |
String | The user name |
tokenNumber |
String | The token Number |
mobile |
String | The mobile |
outDc |
String | The out Dc timing |
outLocation |
String | The out location |
inDcTime |
String | The in Dc timing |
inlocation |
String | The in location |
inTokenNumber |
String | the as inTokenNumber |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~getFabricDcEntryDetails
- Type
- getFabricDcEntryDetails
getDcNumberUserDetailsBylocation(dcNumber, name, tokenNumber, mobile, outDc, outLocation, inDcTime, inlocation) → {getFabricDcEntryDetails}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
name |
String | The user name |
tokenNumber |
String | The token Number |
mobile |
String | The mobile |
outDc |
String | The out Dc timing |
outLocation |
String | The out location |
inDcTime |
String | The in Dc timing |
inlocation |
String | The in location |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~getFabricDcEntryDetails
- Type
- getFabricDcEntryDetails
getDcNumberUserDetailsByLocationAndDate(dcNumber, name, tokenNumber, mobile, outDc, outLocation, inDcTime, inlocation) → {getFabricDcEntryDetails}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
name |
String | The user name |
tokenNumber |
String | The token Number |
mobile |
String | The mobile |
outDc |
String | The out Dc timing |
outLocation |
String | The out location |
inDcTime |
String | The in Dc timing |
inlocation |
String | The in location |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~getFabricDcEntryDetails
- Type
- getFabricDcEntryDetails
getDcNumberUserDetailsByLocationAndDateInDC(dcNumber, name, tokenNumber, mobile, outDc, outLocation, inDcTime, inlocation) → {getFabricDcEntryDetails}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
name |
String | The user name |
tokenNumber |
String | The token Number |
mobile |
String | The mobile |
outDc |
String | The out Dc timing |
outLocation |
String | The out location |
inDcTime |
String | The in Dc timing |
inlocation |
String | The in location |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~getFabricDcEntryDetails
- Type
- getFabricDcEntryDetails
getDcNumberUserDetailsByLocationAndDateOutDC(dcNumber, name, tokenNumber, mobile, outDc, outLocation, inDcTime, inlocation) → {getFabricDcEntryDetails}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
name |
String | The user name |
tokenNumber |
String | The token Number |
mobile |
String | The mobile |
outDc |
String | The out Dc timing |
outLocation |
String | The out location |
inDcTime |
String | The in Dc timing |
inlocation |
String | The in location |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~getFabricDcEntryDetails
- Type
- getFabricDcEntryDetails
getItemCodeForOcFromSage(ocNumber, companyID) → {Array.<itemCodeDetailsList>}
This function is responsible to fetch itemCodes from sage based on OC number
This function consist of 2 queries:
First query fetch item code from sage product colour table
Second query fetch item code from sage product table where colour table not included in this query
Parameters:
| Name | Type | Description |
|---|---|---|
ocNumber |
String | The oc number to get product |
companyID |
String | The company id for sage DB |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~itemCodeDetailsList
- Type
- Array.<itemCodeDetailsList>
getItemCodeForPoFromSage(poNumber, companyID) → {Array.<itemCodeDetailsList>}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
poNumber |
String | The po number to fetch item codes |
companyID |
String | The company id for sage DB |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~itemCodeDetailsList
- Type
- Array.<itemCodeDetailsList>
getLocationStockFromSage(itemCodeList, companyID) → {Array.<locaionStockList>}
This function is responsible to fetch stock associated with location based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of stock associated with location from sage module:repository/sage/fabricDetails~locaionStockList
- Type
- Array.<locaionStockList>
getLocationStockFromSage(itemCodeList, companyID) → {Array.<locaionStockList>}
This function is responsible to fetch stock associated with location based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of stock associated with location from sage module:repository/sage/fabricDetails~locaionStockList
- Type
- Array.<locaionStockList>
getOrderQuantityFromSage(itemCodeList, companyID) → {Array.<orderQuantityUomList>}
This function is responsible to fetch list of order quantity based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of order quantity grouped by units from sage module:repository/sage/fabricDetails~orderQuantityUomList
- Type
- Array.<orderQuantityUomList>
getOrderQuantityFromSage(itemCodeList, companyID) → {Array.<orderQuantityUomList>}
This function is responsible to fetch list of order quantity based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of order quantity grouped by units from sage module:repository/sage/fabricDetails~orderQuantityUomList
- Type
- Array.<orderQuantityUomList>
getReceivedQuantityFromDB(itemCodeList, companyID) → {Array.<receivedQuantityList>}
This function is responsible to fetch list of received quantity based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of received quantity details from sage module:repository/sage/fabricDetails~receivedQuantityList
- Type
- Array.<receivedQuantityList>
getReceivedQuantityFromSage(itemCodeList, companyID) → {Array.<receivedQuantityList>}
This function is responsible to fetch list of received quantity based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of received quantity details from sage module:repository/sage/fabricDetails~receivedQuantityList
- Type
- Array.<receivedQuantityList>
getReceivedQuantityFromSage(itemCodeList, companyID) → {Array.<receivedQuantityList>}
This function is responsible to fetch list of received quantity based on list of item codes
Parameters:
| Name | Type | Description |
|---|---|---|
itemCodeList |
Array.<String> | The list of item code |
companyID |
String | The company id for sage DB |
Returns:
List Of received quantity details from sage module:repository/sage/fabricDetails~receivedQuantityList
- Type
- Array.<receivedQuantityList>
updateFabricDcEntryDetails(dcNumber) → {Array.<itemCodeDetailsList>}
This function is responsible to fetch itemCodes from sage based on PO number
Parameters:
| Name | Type | Description |
|---|---|---|
dcNumber |
String | The po number to fetch item codes |
Returns:
List Of item codes details from sage module:repository/sage/fabricDetails~itemCodeDetailsList
- Type
- Array.<itemCodeDetailsList>
Type Definitions
affectedRows
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
affectedRows |
String | 1 or 0 The dc data exists or not |
itemCodeDetailsList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
itemCodeDetailsList.itemDesc |
String | The item description |
itemCodeDetailsList.itemCode |
String | The item code |
itemCodeDetailsList.poNumber |
String | The po number |
itemCodeDetailsList.ocNumber |
String | The oc number |
locaionStockList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
locaionStockList.number |
String | The receipt number (MIR number) |
locaionStockList.date |
String | The receipt date |
locaionStockList.location |
String | The receipt location |
locaionStockList.quantity |
String | The receipt quantity |
locaionStockList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
locaionStockList.number |
String | The receipt number (MIR number) |
locaionStockList.date |
String | The receipt date |
locaionStockList.location |
String | The receipt location |
locaionStockList.quantity |
String | The receipt quantity |
orderQuantityUomList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
orderQuantityUomList.unitOfMeasure |
String | The unit of measure |
orderQuantityUomList.quantityOrdered |
String | The order quantity associated with unit of measure |
orderQuantityUomList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
orderQuantityUomList.unitOfMeasure |
String | The unit of measure |
orderQuantityUomList.quantityOrdered |
String | The order quantity associated with unit of measure |
receivedQuantityList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
receivedQuantityList.number |
String | The receipt number (MIR number) |
receivedQuantityList.date |
String | The receipt date |
receivedQuantityList.location |
String | The receipt location |
receivedQuantityList.quantity |
String | The receipt quantity |
receivedQuantityList
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
receivedQuantityList.number |
String | The receipt number (MIR number) |
receivedQuantityList.date |
String | The receipt date |
receivedQuantityList.location |
String | The receipt location |
receivedQuantityList.quantity |
String | The receipt quantity |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
result.affectedRows |
String | The dc update in location and date +time |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
getDcNumberUserDetailsBylocation |
String | The dc update in location and date +time |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
getDcNumberUserDetailsByLocationAndDate |
String | The dc update in location and date +time |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
getDcNumberUserDetailsByLocationAndDateInDC |
String | The dc update in location and date +time |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
getDcNumberUserDetailsByLocationAndDateOutDC |
String | The dc update in location and date +time |
result
Type:
- Object
Properties:
| Name | Type | Description |
|---|---|---|
getDcNumberUserDetails |
String | The dc update in location and date +time |