FM / models

/var/www/p4ela.kz/server/delivery/models/

/var/www/p4ela.kz/server/delivery/models

Name	Size	Mode	Actions
account.js	1189	0644	edit dl rm
accountHistory.js	1267	0644	edit dl rm
address.js	1272	0644	edit dl rm
branch.js	2127	0644	edit dl rm
branchPayTypes.js	616	0644	edit dl rm
branchPrinters.js	820	0644	edit dl rm
branchPrintTemplate.js	1099	0644	edit dl rm
branchProducts.js	1704	0644	edit dl rm
branchReviews.js	767	0644	edit dl rm
branchShift.js	1296	0644	edit dl rm
branchUsers.js	581	0644	edit dl rm
category.js	945	0644	edit dl rm
categoryImage.js	1074	0644	edit dl rm
company.js	2153	0644	edit dl rm
companyClients.js	684	0644	edit dl rm
companyImage.js	1070	0644	edit dl rm
companyReviews.js	771	0644	edit dl rm
companyType.js	730	0644	edit dl rm
companyUsers.js	586	0644	edit dl rm
countryCode.js	703	0644	edit dl rm
deliveryType.js	854	0644	edit dl rm
driver.js	645	0644	edit dl rm
index.js	16230	0644	edit dl rm
language.js	621	0644	edit dl rm
message.js	813	0644	edit dl rm
order.js	2945	0644	edit dl rm
orderAddress.js	870	0644	edit dl rm
orderCancelCause.js	730	0644	edit dl rm
orderHistory.js	1006	0644	edit dl rm
orderItems.js	1329	0644	edit dl rm
orderPay.js	900	0644	edit dl rm
orderWaiters.js	495	0644	edit dl rm
payType.js	757	0644	edit dl rm
permission.js	731	0644	edit dl rm
plan.js	1240	0644	edit dl rm
planConfig.js	1038	0644	edit dl rm
product.js	1460	0644	edit dl rm
productExtra.js	696	0644	edit dl rm
productFeature.js	643	0644	edit dl rm
productGroup.js	1487	0644	edit dl rm
productGroupImage.js	1056	0644	edit dl rm
productImage.js	1035	0644	edit dl rm
productIngridient.js	716	0644	edit dl rm
productReviews.js	841	0644	edit dl rm
productType.js	664	0644	edit dl rm
productTypeFeature.js	660	0644	edit dl rm
productVariant.js	794	0644	edit dl rm
refreshToken.js	1218	0644	edit dl rm
role.js	819	0644	edit dl rm
room.js	837	0644	edit dl rm
shippingRate.js	1918	0644	edit dl rm
table.js	1149	0644	edit dl rm
tableHistory.js	1223	0644	edit dl rm
tableReserv.js	1453	0644	edit dl rm
user.js	2321	0644	edit dl rm
userCartItem.js	1267	0644	edit dl rm
userGoogleToken.js	874	0644	edit dl rm
userLoginHistory.js	1421	0644	edit dl rm
userPhone.js	836	0644	edit dl rm
userToken.js	1234	0644	edit dl rm
workTime.js	979	0644	edit dl rm

Edit: /var/www/p4ela.kz/server/delivery/models/order.js (2945B)

module.exports = (sequelize, Sequelize) => {
	const Order = sequelize.define(
		'order',
		{
			id: {
				type: Sequelize.BIGINT,
				autoIncrement: true,
				allowNull: false,
				primaryKey: true
			},
			uid: {
				type: Sequelize.UUID,
				defaultValue: Sequelize.UUIDV4
			},
			companyId: {
				type: Sequelize.BIGINT
			},
			branchId: {
				type: Sequelize.BIGINT
			},
			payTypeId: {
				type: Sequelize.BIGINT
			},
			deliveryPayTypeId: {
				type: Sequelize.BIGINT
			},
			deliveryTypeId: {
				type: Sequelize.BIGINT
			},
			phone: {
				type: Sequelize.STRING(16),
				allowNull: false,
				defaultValue: ''
			},
			comment: {
				type: Sequelize.STRING,
				allowNull: false,
				defaultValue: ''
			},
			status: {
				allowNull: false,
				type: Sequelize.ENUM(
					'reserv',
					'new',
					'pending',
					'accept',
					'ready',
					'delivery',
					'arrived',
					'complete',
					'cancel'
				),
				defaultValue: 'new'
			},
			pay_status_order: {
				allowNull: false,
				type: Sequelize.ENUM('not_paid', 'free', 'paid', 'pay_error'),
				defaultValue: 'not_paid'
			},
			pay_status_delivery: {
				allowNull: false,
				type: Sequelize.ENUM('not_paid', 'free', 'paid', 'pay_error'),
				defaultValue: 'not_paid'
			},
			order_cost: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			total: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			discount: {
				type: Sequelize.INTEGER,
				allowNull: true
			},
			person_count: {
				type: Sequelize.INTEGER,
				allowNull: true
			},
			prepare_time: {
				type: Sequelize.INTEGER,
				allowNull: true
			},
			delivery_time: {
				type: Sequelize.INTEGER,
				allowNull: true
			},
			delivery_distance: {
				type: Sequelize.DECIMAL(10, 4),
				allowNull: true
			},
			delivery_cost: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			tips_cost: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			delivery_cost_calculated: {
				type: Sequelize.DECIMAL(10, 2),
				allowNull: true
			},
			printed: {
				allowNull: false,
				type: Sequelize.BOOLEAN,
				defaultValue: 0,
			},
			userId: {
				type: Sequelize.BIGINT
			},
			driverId: {
				type: Sequelize.BIGINT
			},
			tableId: {
				type: Sequelize.BIGINT
			},
			createdAt: {
				allowNull: false,
				type: Sequelize.DATE
				//defaultValue: new Date()
			},
			updatedAt: {
				allowNull: false,
				type: Sequelize.DATE
				//defaultValue: new Date()
			},
			acceptAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
			readyAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
			deliveryAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
			arrivedAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
			payAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
			completeAt: {
				allowNull: true,
				type: Sequelize.DATE
			},
		},
		{
			timestamps: true,
			paranoid: true
		}
	)
	return Order
}

module.exports = (sequelize, Sequelize) => { const Order = sequelize.define( 'order', { id: { type: Sequelize.BIGINT, autoIncrement: true, allowNull: false, primaryKey: true }, uid: { type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4 }, companyId: { type: Sequelize.BIGINT }, branchId: { type: Sequelize.BIGINT }, payTypeId: { type: Sequelize.BIGINT }, deliveryPayTypeId: { type: Sequelize.BIGINT }, deliveryTypeId: { type: Sequelize.BIGINT }, phone: { type: Sequelize.STRING(16), allowNull: false, defaultValue: '' }, comment: { type: Sequelize.STRING, allowNull: false, defaultValue: '' }, status: { allowNull: false, type: Sequelize.ENUM( 'reserv', 'new', 'pending', 'accept', 'ready', 'delivery', 'arrived', 'complete', 'cancel' ), defaultValue: 'new' }, pay_status_order: { allowNull: false, type: Sequelize.ENUM('not_paid', 'free', 'paid', 'pay_error'), defaultValue: 'not_paid' }, pay_status_delivery: { allowNull: false, type: Sequelize.ENUM('not_paid', 'free', 'paid', 'pay_error'), defaultValue: 'not_paid' }, order_cost: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, total: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, discount: { type: Sequelize.INTEGER, allowNull: true }, person_count: { type: Sequelize.INTEGER, allowNull: true }, prepare_time: { type: Sequelize.INTEGER, allowNull: true }, delivery_time: { type: Sequelize.INTEGER, allowNull: true }, delivery_distance: { type: Sequelize.DECIMAL(10, 4), allowNull: true }, delivery_cost: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, tips_cost: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, delivery_cost_calculated: { type: Sequelize.DECIMAL(10, 2), allowNull: true }, printed: { allowNull: false, type: Sequelize.BOOLEAN, defaultValue: 0, }, userId: { type: Sequelize.BIGINT }, driverId: { type: Sequelize.BIGINT }, tableId: { type: Sequelize.BIGINT }, createdAt: { allowNull: false, type: Sequelize.DATE //defaultValue: new Date() }, updatedAt: { allowNull: false, type: Sequelize.DATE //defaultValue: new Date() }, acceptAt: { allowNull: true, type: Sequelize.DATE }, readyAt: { allowNull: true, type: Sequelize.DATE }, deliveryAt: { allowNull: true, type: Sequelize.DATE }, arrivedAt: { allowNull: true, type: Sequelize.DATE }, payAt: { allowNull: true, type: Sequelize.DATE }, completeAt: { allowNull: true, type: Sequelize.DATE }, }, { timestamps: true, paranoid: true } ) return Order }