motionx-portal-package

> This lib for manage database of motionx studio.

Install with npm

$ npm i motionx-portal-package --save

Usage initialize

const { StationModel } = require("motionx-portal-package");
//If you need management with Stations table.

//Call initialize func and set sql connect to this. 1 only

/**
 * DatabaseConection Mysq.Connection in Config.js
 */
StationModel.SetConnectDatabase(DatabaseConection);

Example

Create new station

const {
  StationModel,
  STATE_CODE_STATION,
  STATE_CODE_EVENT_MANAGEMENT,
  STATE_CODE_VOID,
} = require("motionx-portal-package");
// If you need management with Stations table.

// Create new multi station
const newStation = new StationModel({
  refProductId, // Require!
  refCompanyId, // Require!
  refOrderDealId: null,
  refStoreId: null,
  serialNumber, // Require!
  stationNameCustom, // Require!
  datetimeStation, // Require!
  datetimeNotify, // Require!
  datetimeExp, // Require!
  stateCode: STATE_CODE_STATION.ACTIVED, // Require!
  refInvoiceId, // Require!
  refCommissionId, // Require!
  isArrears, // Require!
  lastSynced: null,
  refManageUserId, // Require!
  lastEventCode: STATE_CODE_EVENT_MANAGEMENT.CREATE_STATION, // Require
  isVoidStation: STATE_CODE_VOID.DON_T_VOID, // Require
  voidAuth: null,
  voidComment: null,
  typeCodeStation: typeCodeStation, // Require
});

// [INSERT INTO STATION VALUES (...), (...)]
const result = await StationModel.CREATE_MULTI_STATION([newStation]);
console.log(result); // --> Array Object of station

Query station by id

const { StationModel } = require("motionx-portal-package");
// If you need management with Stations table.

// [SELECT * FROM stations WHERE _id = `Id`]
const result = await StationModel.FIND_STATION_BY_ID(Id);
console.log(result); // --> 1 Object of station

Query station by condition

const {
  StationModel,
  MAKE_LIMIT_OFFSET,
  STATE_CODE_STATION,
  MAKE_OPERATOR,
} = require("motionx-portal-package");
// If you need management with Stations table.

//If you want OR use EQUAL_OR
var condition = {
  [MAKE_OPERATOR.EQUAL_AND("stations.isVoidStation")]: 1,
  [MAKE_OPERATOR.EQUAL_AND("stations.stateCode")]: STATE_CODE_STATION.VOIDED,
};

// limitOfPage is limit record per page
// offset is current offset
const limitOffset = MAKE_LIMIT_OFFSET(/*limitOfPage*/ 10, /*offset*/ 0);
// [ SELECT * FROM stations WHERE stations.isVoidStation = 1 AND stations.stateCode = 0 OFFSET 0 LIMIT 1]
const result = await StationModel.FIND_STATION_BY_FIELD(condition, limitOffset);
console.log(result); // --> Array Object of station

Update station by id

const {
  StationModel,
  MAKE_LIMIT_OFFSET,
  STATE_CODE_STATION,
  MAKE_OPERATOR,
} = require("motionx-portal-package");
// If you need management with Stations table.

const stationUpdate = {
  serialNumber: value,
};

//[UPDATE STATION SET serialNumber = `value` WHERE _id = `Id`]
const result = await StationModel.UPDATE_STATION_BY_ID(Id, station);
console.log(result); // --> 1 Object of station

Condition Option MAKE_OPERATOR

NOT_AND                     `-> [WHERE condition != '' AND ...]`
NOT_OR                      `-> [WHERE condition != '' OR ... ]`
EQUAL_AND                   `-> [WHERE condition = '' AND ... ]`
EQUAL_OR                    `-> [WHERE condition = '' OR ...  ]`
MORE_THAN_EQUAL_AND         `-> [WHERE condition >= '' AND ...]`
MORE_THAN_EQUAL_OR
LESS_THAN_EQUAL_AND         `-> [WHERE condition <= '' AND ...]`
LESS_THAN_EQUAL_OR
WHERE_IN_AND, WHERE_IN_OR,  `-> [WHERE condition IN() OR ...  ]`
... -> can look in ref code

Handling Errors

try{
  /** Call Model Management Function will catch if Error */
}catch(error){
  console.log(error) // Error case
}

Other tbl management

• WareHouseModel
• UserModel
• UserGmailHistoryModel
• TransactionPaymentModel
• StoreModel
• StationModel
• StationWareHouseModel
• PromotionModel
• PromotionPlayerModel
• ProductModel
• ProductTypeModel
• PriceTransactionModel
• PermissionModel
• OrderProductCardModel
• OrderPaymentModel
• OrderDealCardModel
• LogResetPasswordModel
• LogMapPlayedModel
• LogPlayedModel
• LogNotifyEventModel
• LogEventSimulatorModel
• LogEventManagementModel
• LogEndSessionModel
• LisenceModel
• InvoiceCommissionModel
• InvoicePromotionPlayedModel
• InvoiceStationModel
• ImageResouceModel
• EmailThreadModel
• EmailMessageModel
• DLCOrderModel
• DLCProductModel
• DLCProductRateModel
• CountryModel
• ContactCustCompanyModel
• CompanyModel
• CommissionModel
• EmailMessageTemplateModel