FM / models

/var/www/greso.tech/server/nsm/models

Name	Size	Mode	Actions
address.js	1316	0644	edit dl rm
branch.js	1680	0644	edit dl rm
branchUsers.js	689	0644	edit dl rm
company.js	2631	0644	edit dl rm
companyClients.js	779	0644	edit dl rm
companyUsers.js	694	0644	edit dl rm
condition.js	1028	0644	edit dl rm
config.js	634	0644	edit dl rm
document.js	1183	0644	edit dl rm
emailTemplates.js	962	0644	edit dl rm
extra.js	1258	0644	edit dl rm
index.js	13274	0644	edit dl rm
inventoryExtras.js	1653	0644	edit dl rm
inventoryItems.js	2132	0644	edit dl rm
inventoryItemsAttachment.js	956	0644	edit dl rm
inventoryItemsCategories.js	808	0644	edit dl rm
inventoryItemsConditions.js	814	0644	edit dl rm
inventoryItemsDestConditions.js	831	0644	edit dl rm
inventoryItemsPackages.js	1483	0644	edit dl rm
items.js	1411	0644	edit dl rm
itemsCategory.js	1087	0644	edit dl rm
leadDistribution.js	467	0644	edit dl rm
links.js	788	0644	edit dl rm
merchant.js	1257	0644	edit dl rm
order.js	4693	0644	edit dl rm
orderComment.js	746	0644	edit dl rm
orderDocument.js	1488	0644	edit dl rm
orderHistory.js	1140	0644	edit dl rm
orderInventory.js	5194	0644	edit dl rm
orderMessage.js	950	0644	edit dl rm
orderMovement.js	1529	0644	edit dl rm
orderMovementWorkers.js	714	0644	edit dl rm
orderPayment.js	2117	0644	edit dl rm
package.js	1184	0644	edit dl rm
payType.js	1046	0644	edit dl rm
provider.js	1019	0644	edit dl rm
rateArea.js	1228	0644	edit dl rm
rateItem.js	951	0644	edit dl rm
rateLocal.js	876	0644	edit dl rm
refreshToken.js	1281	0644	edit dl rm
role.js	2039	0644	edit dl rm
truck.js	1180	0644	edit dl rm
user.js	1583	0644	edit dl rm
userEmail.js	1419	0644	edit dl rm
userLoginHistory.js	1396	0644	edit dl rm
userPhone.js	744	0644	edit dl rm
userToken.js	1243	0644	edit dl rm
valuation.js	817	0644	edit dl rm
warehouse.js	1271	0644	edit dl rm
zipCodes.js	1014	0644	edit dl rm
zipRadius.js	1271	0644	edit dl rm

Edit: /var/www/greso.tech/server/nsm/models/orderInventory.js (5194B)

storage: {
				type: Sequelize.BOOLEAN,
				defaultValue: false,
				allowNull: true
			},

valuation: {
				type: Sequelize.TEXT,
			},

items_count: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			items_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			items_volume: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			items_weight: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			weight_brutto: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			weight_tare: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			bulky_count: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			bulky_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			extras_count: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			extras_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			packages_count: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			packages_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			fuel_percent: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			fuel_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},

edited_packages: {
				type: Sequelize.BOOLEAN,
				defaultValue: false,
				allowNull: true
			},
			custom_packages: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			custom_unpackage: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},

edited_weight: {
				type: Sequelize.BOOLEAN,
				defaultValue: false,
				allowNull: true
			},
			custom_weight: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},

edited_volume: {
				type: Sequelize.BOOLEAN,
				defaultValue: false,
				allowNull: true
			},
			custom_volume: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},

edited_total: {
				type: Sequelize.BOOLEAN,
				defaultValue: false,
				allowNull: true
			},
			custom_total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			discount_comment: {
				type: Sequelize.STRING,
				allowNull: false,
				defaultValue: '',
			},
			discount_cash: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},

total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			paid: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			due: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},
			due_in_30_days: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: false,
				defaultValue: 0.0
			},

createdAt: {
				allowNull: true,
				type: Sequelize.DATE,
			},
			updatedAt: {
				allowNull: true,
				type: Sequelize.DATE,
			},
		},
		{
			timestamps: true,
			tableName: 'orders_inventory',
		}
	)
	return OrderInventory
}

module.exports = (sequelize, Sequelize) => { const OrderInventory = sequelize.define( 'orderInventory', { id: { type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4, allowNull: false, primaryKey: true }, orderId: { type: Sequelize.UUID, allowNull: false, }, type: { allowNull: false, type: Sequelize.ENUM('estimate', 'new_estimate', 'revice', 'delivery'), defaultValue: 'estimate' }, status: { allowNull: false, type: Sequelize.ENUM('edit', 'sended', 'signed', 'booked', 'close'), defaultValue: 'edit' }, rate: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, rate_multiply: { allowNull: false, type: Sequelize.ENUM('weight', 'volume'), defaultValue: 'volume' }, estimate_type: { allowNull: false, type: Sequelize.ENUM('binding', 'non_binding'), defaultValue: 'binding' }, // LOCAL RATE localRateId: { allowNull: true, type: Sequelize.UUID, }, pickupFrom: { allowNull: true, type: Sequelize.TIME, }, pickupTo: { allowNull: true, type: Sequelize.TIME, }, pickupHours: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, drivingFrom: { allowNull: true, type: Sequelize.TIME, }, drivingTo: { allowNull: true, type: Sequelize.TIME, }, drivingHours: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, deliveryFrom: { allowNull: true, type: Sequelize.TIME, }, deliveryTo: { allowNull: true, type: Sequelize.TIME, }, deliveryHours: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, doubleDriving: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, storage: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, valuation: { type: Sequelize.TEXT, }, items_count: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, items_total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, items_volume: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, items_weight: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, weight_brutto: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, weight_tare: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, bulky_count: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, bulky_total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, extras_count: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, extras_total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, packages_count: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, packages_total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, fuel_percent: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, fuel_total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, edited_packages: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, custom_packages: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, custom_unpackage: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, edited_weight: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, custom_weight: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, edited_volume: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, custom_volume: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, edited_total: { type: Sequelize.BOOLEAN, defaultValue: false, allowNull: true }, custom_total: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, discount_comment: { type: Sequelize.STRING, allowNull: false, defaultValue: '', }, discount_cash: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, total: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, paid: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, due: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, due_in_30_days: { type: Sequelize.DECIMAL(10, 2), allowNull: false, defaultValue: 0.0 }, createdAt: { allowNull: true, type: Sequelize.DATE, }, updatedAt: { allowNull: true, type: Sequelize.DATE, }, }, { timestamps: true, tableName: 'orders_inventory', } ) return OrderInventory }