CN113780962A - Management method and system for activity-level inventory of equity mall - Google Patents
Management method and system for activity-level inventory of equity mall Download PDFInfo
- Publication number
- CN113780962A CN113780962A CN202111336178.XA CN202111336178A CN113780962A CN 113780962 A CN113780962 A CN 113780962A CN 202111336178 A CN202111336178 A CN 202111336178A CN 113780962 A CN113780962 A CN 113780962A
- Authority
- CN
- China
- Prior art keywords
- inventory
- activity
- equity
- available
- total
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a management method and a system for activity-level inventory of a rights and interests mall, comprising the steps of creating an inventory table, a sub-inventory table and a coupon code table; purchasing a batch equity and an equity coupon code, automatically generating purchase records of the batch equity in the stock table, automatically generating general stock records of the batch equity in the sub-stock table, and automatically adding the equity coupon code to the coupon code table; creating active inventory in the sub-inventory table to distribute the batch rights and interests, and synchronously updating a general inventory record; setting an activity setting total equity quantity and an activity setting available equity quantity in the activity inventory to realize batch release and use of the batch equity; according to the method, through the design of the inventory table, the sub-inventory table and the coupon code table, the effective linkage management and control of the batch total inventory and the activity-level inventory are realized, the flexible allocation of the inventory among different activity inventories under the same total inventory is realized, and the inventory of the same activity inventory is released in batches according to activity requirements.
Description
Technical Field
The invention relates to the technical field of activity-level inventory management, in particular to a method and a system for managing activity-level inventory of a rights and interests mall.
Background
Most of the existing inventory management methods and systems perform single-dimensional management and control on rights and interests or the total amount and available quantity of commodities, that is, the whole inventory can be controlled only by the available quantity of one inventory record; the problems that the whole batch of inventory can not be distributed according to the inventory quantity required by the activity, the inventory can not be dynamically increased or decreased according to the activity explosion degree, the inventory can not be released in batches according to the activity period, and the inventory early warning can not be carried out before the activity inventory is used up exist; that is, the existing inventory management method and system cannot meet the requirements of a customer on one-time batch purchase, inventory allocation according to activities, batch release of the activities, flexible adjustment of the inventory quantity among the allocated activities, and realization of a multi-dimensional inventory early warning function for the whole inventory and the activities.
Disclosure of Invention
In view of the above problems, an object of the present invention is to provide a method for managing active-level inventory of a equity mall, which implements effective linked management and control of a batch of total inventory and active-level inventory, and flexible allocation of inventory among different active inventories in the same total inventory, and releases inventory in batches according to active requirements in the same active inventory, and supports an inventory alarm function, and when an inventory alarm ratio is exceeded, notifies a manager of inventory alarm information in various ways to process the inventory alarm information.
It is a second object of the present invention to provide a management system for equity mall activity level inventory.
The first technical scheme adopted by the invention is as follows: a method for managing equity mall activity level inventory, comprising the steps of:
s100: creating an inventory table, a sub-inventory table and a coupon code table;
s200: purchasing a batch equity and an equity coupon code, automatically generating purchase records of the batch equity in the stock table, automatically generating general stock records of the batch equity in the sub-stock table, and automatically adding the equity coupon code to the coupon code table; wherein, the purchase record comprises the total equity quantity and the available equity quantity, and the general inventory record comprises the activity total equity quantity and the activity available equity quantity;
s300: creating active inventory in the sub-inventory table to distribute the batch rights and interests, and synchronously updating a general inventory record;
s400: setting an activity setting total equity quantity and an activity setting available equity quantity in the activity inventory to enable batch release and use of the bulk equity.
Preferably, the step S300 sets an activity number, an activity total equity amount and an activity available equity amount in the activity inventory when the activity inventory is created, wherein the activity total equity amount and the activity available equity amount in the activity inventory are less than or equal to the activity total equity amount and the activity available equity amount recorded in the general inventory by the lot equity.
Preferably, the step S300 of synchronously updating the general inventory records includes:
when the total rights and interests quantity of the activities and the available rights and interests quantity of the activities in the activity library are set, synchronously deducting the total rights and interests quantity of the activities and the available rights and interests quantity of the activities in the general inventory records; the amount of deduction in the general inventory record is equal to the set amount in the active library.
Preferably, the step S300 further includes performing a coordination on the created active inventory, where the coordination includes a reduction or increase of the active inventory.
Preferably, the batch equity batch release in step S400 includes:
and setting an activity setting total interest amount and an activity setting available interest amount for the activity inventory corresponding to the activity to control the release of the interest batches, wherein the activity setting total interest amount is less than or equal to the activity available interest amount, and the activity setting available interest amount is equal to the activity setting total interest amount when the activity is set for the first time.
Preferably, the use of the lot right in step S400 includes the following sub-steps:
s410: receiving a rights and interests use request, and judging whether an activity number is appointed in the rights and interests use request or not; if the activity number is designated, go to step S420; if the activity number is not specified, go to step S430;
s420: judging whether the activity setting total rights quantity is larger than 0; if the total interest amount of the activity setting is larger than 0, further judging whether the available interest amount of the activity setting meets the amount of the interest use request, if so, carrying out processing of receiving the interest ticket code, and if not, directly returning to carry out failure processing;
if the activity setting total interest amount is not more than 0, further judging whether the activity available interest amount meets the number of the interest use requests, if so, carrying out processing of receiving the interest coupon codes, and if not, directly returning to carry out failure processing;
s430: judging whether the activity setting total interest amount is set in the general inventory, and if the activity setting total interest amount is set, further judging whether the activity setting available interest amount meets the number of the interest use requests; if the right coupon code is not satisfied, directly returning to the failure processing;
if the activity setting total equity quantity is not set, further judging whether the activity available equity quantity meets the quantity of the equity use request; if the right coupon code is not satisfied, the right coupon code is received, and if the right coupon code is not satisfied, the failure processing is directly returned.
Preferably, the process of receiving the right coupon code includes:
and receiving the designated number of the rights and interests voucher codes based on the rights and interests purchaser number, the rights and interests number and the batch serial number voucher removing number table, and synchronously updating the voucher code receiving mark to be received.
Preferably, the step S400 further includes judging the inventory of the inventory table based on the inventory alarm ratio to realize the inventory automatic alarm of the inventory table, specifically:
judging the inventory of the inventory table based on the inventory alarm proportion when each equity is used, and automatically triggering the inventory alarm of the inventory table if the available equity quantity multiplied by 100%/the total equity quantity is less than or equal to the inventory alarm proportion; if the available equity quantity multiplied by 100 percent/total equity quantity is larger than the inventory alarm ratio, no alarm processing is carried out.
Preferably, the step S400 further includes judging the inventory of the sub-inventory table based on the inventory alarm ratio to realize the inventory automatic alarm of the sub-inventory table, specifically:
when the rights and interests use request is received, judging whether the activity setting total rights and interests quantity is greater than 0;
if the activity setting total interest amount is not more than 0, further judging whether the activity available interest amount multiplied by 100%/the activity total interest amount is more than the inventory alarm proportion or not based on the activity available interest amount and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table;
if the activity setting total interest quantity is larger than 0, further judging whether the activity setting interest available quantity multiplied by 100 percent/the activity setting total interest quantity is larger than the inventory alarm proportion or not based on the activity setting interest available quantity and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table.
The second technical scheme adopted by the invention is as follows: a management system of equity mall activity-level inventory comprises a creation module, an equity and equity ticket code purchase module, an equity distribution module and an equity batch release and use module;
the creating module is used for creating an inventory table, a sub-inventory table and a coupon code table;
the right and right ticket code purchasing module is used for purchasing batch right and right ticket codes, automatically generating purchasing records of the batch right in the inventory table, automatically generating general inventory records of the batch right in the sub-inventory table, and automatically adding the right ticket codes to the ticket code table; wherein, the purchase record comprises the total equity quantity and the available equity quantity, and the general inventory record comprises the activity total equity quantity and the activity available equity quantity;
the equity distribution module is used for creating active stock in the sub-stock table to distribute the batch equity and synchronously updating a general stock record;
the equity batch release and use module is for setting an activity set total equity amount and an activity set available equity amount in the active inventory to effect the batch equity batch release and use.
The beneficial effects of the above technical scheme are that:
(1) the method for managing the active-level inventory of the equity store realizes effective linkage management and control of the total inventory of the batch and the active-level inventory, realizes two-level management and control of the inventory and the active inventory, and realizes the functions of setting, dynamic adjustment, batch release and two-level inventory early warning through the reasonable design of the inventory table, the sub-inventory table and the coupon code table.
(2) The method for managing the activity-level inventory of the equity store realizes the function of setting different activity inventories under the same total inventory and realizes the dynamic adjustment of the inventory between the activity inventory and the general inventory by the incidence relation of the inventory and the sub inventory and the introduction of the general inventory concept in the sub inventory.
(3) The method for managing the activity-level inventory of the equity store realizes the function of batch release of the active inventory by adding the setting of the activity-set total equity quantity and the activity-set equity available quantity in the active inventory.
(4) The management method of the equity mall activity-level inventory realizes the function of inventory early warning through the arrangement of the inventory table warning sign, the inventory warning proportion, the warning notification mode and the contact mode of the warning person.
(5) The management method of the activity-level inventory of the equity mall realizes the function of early warning of the activity inventory through the setting of the alarm mark, the inventory alarm proportion, the alarm notification mode and the contact mode of the alarm person of the sub-inventory list.
(6) The invention discloses a management method of rights and interests mall activity level inventory, which adopts the combination of Mysql + reds to optimize the performance, wherein the inventory table, the sub-inventory table and the coupon code table are stored in the Mysql, related records are also stored in the reds in an index form, a program processes read real-time data, the recording of the reds is taken as the standard, the data of the reds is duralized at regular time, the data table in the Mysql is updated, and the safety of the data is also ensured while the new performance of the system is ensured.
Drawings
FIG. 1 is a flow chart illustrating a method for managing equity mall activity level inventory according to an embodiment of the present invention;
fig. 2 is a corresponding relationship between an inventory record in an inventory table and a general inventory record in a sub-inventory table according to an embodiment of the present invention;
FIG. 3 is a relationship between inventory records in an inventory table and general inventory records, active inventory records in a sub-inventory table according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of flexible deployment of active inventory according to one embodiment of the present invention;
FIG. 5 is a schematic diagram of a batch release of active inventory provided in accordance with one embodiment of the present invention;
fig. 6 is a schematic structural diagram of a system for managing equity mall activity-level inventory according to an embodiment of the present invention.
Detailed Description
The embodiments of the present invention will be described in further detail with reference to the drawings and examples. The following detailed description of the embodiments and the accompanying drawings are provided to illustrate the principles of the invention and are not intended to limit the scope of the invention, which is defined by the claims, i.e., the invention is not limited to the preferred embodiments described.
In the description of the present invention, it is to be noted that, unless otherwise specified, "a plurality" means two or more; the terms "first," "second," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance; the specific meaning of the above terms in the present invention can be understood as appropriate to those of ordinary skill in the art.
Example one
Fig. 1 is a method for managing equity mall activity-level inventory, according to an embodiment of the present invention, including the following steps:
s100: creating an inventory table, a sub-inventory table and a coupon code table;
the inventory table comprises an equity number, an equity buyer number, a batch serial number, a total equity quantity, an available equity quantity, an alarm mark, an inventory alarm proportion, an alarm notification mode, an alarm notifier mobile phone, an alarm notifier mailbox, an alarm notifier WeChat, an effective mark, creation time, a creator, update time and updater information (but not limited to the information), and the information recorded in the inventory table is specifically shown in table 1;
TABLE 1 inventory table
| Name of field | Type (B) |
| Equity number | varchar(32) |
| Equity buyer number | varchr(32) |
| Batch serial number | varchar(11) |
| Amount of total rights and benefits | int(8) |
| Amount of available equity | int(8) |
| Alarm sign | Char(1) |
| Inventory alarm ratio | int(3) |
| Alarm notification mode | Char(1) |
| Alarm deviceNotification person mobile phone | varchar(11) |
| Mailbox of alarm notifier | varchar(50) |
| Alarm notifier | varchar(30) |
| Valid sign | Char(1) |
| Creation time | Timestamp |
| Creators | varchar(20) |
| Update time | Timestamp |
| Renewing person | varchar(20) |
The sub-inventory table comprises an equity number, an equity buyer number, a batch serial number, an activity total equity quantity, an activity available equity quantity, an activity set total equity quantity, an activity set equity available quantity, an alarm mark, an inventory alarm proportion, an alarm notification mode, an alarm notifier mobile phone, an alarm notifier mailbox, an alarm notifier WeChat, an effective mark, a creation time, a creator, an update time and an update person information (but not limited thereto), and the information recorded in the sub-inventory table is specifically shown in table 2;
TABLE 2 sublist table
| Name of field | Type (B) |
| Equity number | varchar(32) |
| Equity buyer number | varchr(32) |
| Batch serial number | varchar(11) |
| Activity number | varchr(32) |
| Total amount of rights and interests in activities | int(8) |
| Number of rights and interests available for activities | int(8) |
| Actively setting the amount of equity | int(8) |
| Activity setting equity available quantity | int(8) |
| Alarm sign | Char(1) |
| Inventory alarm ratio | int(3) |
| Alarm notification mode | Char(1) |
| Mobile phone for alarming and informing people | varchar(11) |
| Mailbox of alarm notifier | varchar(50) |
| Alarm notifier | varchar(30) |
| Valid sign | Char(1) |
| Creation time | Timestamp |
| Creators | varchar(20) |
| Update time | Timestamp |
| Renewing person | varchar(20) |
The ticket code table includes the rights and interests number, the rights and interests purchaser number, the batch serial number, the rights and interests ticket code, the ticket code getting mark, the creation time, the creator, the update time and the information of the updater (but not limited thereto), and the information recorded in the ticket code table is specifically shown in table 3;
TABLE 3 coupon code table
| Name of field | Type (B) |
| Equity number | varchar(32) |
| Equity buyer number | varchr(32) |
| Batch serial number | varchar(11) |
| Right coupon code | varchar(32) |
| Ticket code receiving mark | Char(1) |
| Creation time | Timestamp |
| Creators | varchar(20) |
| Update time | Timestamp |
| Renewing person | varchar(20) |
One record in the inventory table represents the authority of one batch purchased by the equity buyer, and the unique equity purchasing record of one batch is determined by the number of the equity buyer, the number of the equity buyer and the serial number of the batch; the rights and interests of the batch purchased by the rights and interests buyer can be imported into the ticket code table in batch, the ticket code table is inquired by using the rights and interests buyer number, the rights and interests number and the batch serial number, all ticket code records of the rights and interests of the batch can be inquired, and the number of the rights and interests number records of the batch in the ticket code table is equal to the total rights and interests number corresponding to the batch of records in the inventory table; after the right coupon code is received, the coupon code receiving mark in the coupon code table is updated to distinguish whether the coupon code is used or not.
The key words of the sub-inventory table are the rights and interests purchaser number, the rights and interests number, the batch serial number and the activity number, one inventory record in the inventory table corresponds to one purchasing batch of the rights and interests purchaser, and the inventory record is associated with a plurality of activity inventory records and one general inventory record in the sub-inventory table, namely the sub-inventory table comprises a plurality of activity inventory records and one general inventory record; the sum of the total rights and interests of the active inventory records and the universal inventory records in the sub-inventory table is equal to the total rights and interests in the inventory table; the sum of the amount of the active available equity in the active inventory records and the universal inventory records in the sublist is equal to the amount of the available equity in the inventory table
According to the invention, through the reasonable design of the inventory table, the sub-inventory table and the coupon code table, the effective linkage management and control of the batch total inventory and the active inventory in the later period are realized, the two-stage management and control of the inventory and the active inventory are realized, and the functions of setting, dynamic adjustment, batch release and two-stage inventory early warning are realized.
S200: purchasing a batch equity and an equity coupon code, automatically generating purchase records of the batch equity in the stock table, automatically generating general stock records of the batch equity in the sub-stock table, and automatically adding the equity coupon code to the coupon code table; wherein, the purchase record includes the total equity quantity and the available equity quantity, the general inventory record includes the activity total equity quantity and the activity available equity quantity, and the total equity quantity is equal to the activity total equity quantity, and the available equity quantity is equal to the activity available equity quantity.
The system supports the rights and interests buyer to buy the designated rights and interests in batch (whole rights and interests batch buying), after successful buying, as shown in fig. 2, the corresponding rights and interests batch buying record is added in the inventory table, including the total rights and interests quantity and the available rights and interests quantity of the rights and interests purchasing; a general inventory record corresponding to the equity batch purchasing record is generated in the sub-inventory table, the activity number in the general inventory record is null, the activity total equity quantity is equal to the total equity quantity of the records corresponding to the inventory table, and the activity available equity quantity is equal to the available equity quantity of the records corresponding to the inventory table; the equity platform can purchase corresponding amount of equity coupon codes from the equity provider and add the equity coupon codes to the coupon code table, and the equity buyer number + the equity coupon number + the batch serial number recorded by the batch of coupon codes are consistent with the equity buyer number + the equity coupon number + the batch serial number recorded by the batch of coupon codes in the inventory table.
For example, the merchant M0001 purchases a lot of equity coupon 0001, the purchase quantity is 10000, records are added to the inventory table, and the record information is as follows:
| equity number | Equity buyer number | Batch serial number | Amount of total rights and benefits | Amount of available equity |
| CouponId0001 | M0001 | B0001 | 10000 | 10000 |
And synchronously adding general inventory records in the sub-inventory table, wherein the record information is as follows:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 10000 | 10000 |
S300: creating active inventory in the sub-inventory table to distribute the rights and interests of the batches, and synchronously updating the general inventory records;
(1) equity assignment by activity
As shown in fig. 3, for the lot of equity buyers, an activity inventory can be correspondingly created by adding activities to the sub-inventory table to allocate the equity inventory of the lot, wherein the equity buyer number + equity number + lot serial number of the activity inventory added in the sub-inventory is consistent with the record in the inventory table of the lot of equity, that is, the equity number + equity buyer number + lot serial number of the activity inventory in the sub-inventory inherits from the inventory record of the lot of equity in the inventory table;
when the active stock is created, an active number, an active total interest amount and an active available interest amount need to be set in the active stock, the active number of the active stock in the subload is an active number for increasing the activity, the active stock records that the active available interest amount in the active stock when the activity is newly increased is equal to the active total interest amount, and the active total interest amount is unchanged and can be reduced in the subsequent interest use process; the total number of activity equity and the number of activity availabilities for the activity (total number of activity equity and number of activity availabilities in the active inventory) should be less than or equal to the total number of activity equity and the number of activity availabilities for the corresponding general inventory record for the batch (lot) of equity in the sub-inventory tables.
For example, add activity a001, with a number of equities of 1000, then create an active inventory in the sub-inventory table to record the following table information:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 10000 | 10000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
(2) Synchronously updating the right and interest general inventory of the batch;
the activity sub-inventory records are added and set with the activity total interest amount and the activity available interest amount, and simultaneously, the activity total interest amount and the activity available interest amount of the same amount recorded in the sub-inventory table by the group of interest general inventory are synchronously deducted;
after the active inventory is successfully established, the number of the active total rights and interests of the corresponding general inventory record is reduced, and the reduced number of the active total rights and interests in the general inventory record is equal to the number of the active total rights and interests of the newly established active inventory; the amount of the activity available equity of the general inventory record is reduced, and the reduced amount of the activity available equity in the general inventory record is equal to the amount of the activity available equity of the newly created activity inventory; keeping the sum of the amount of the right and the total interest of the group of the right and the activity inventory and the amount of the total interest of the group of the general inventory records in the sub-inventory table consistent with the amount of the right and the activity of the group of the right and the activity of the total inventory and the amount of the available right and the activity of the group of the right and the activity of the general inventory records in the sub-inventory table consistent with the amount of the right and the activity of the group of the right and the activity of the total inventory records in the inventory table;
the buyer can create a plurality of active stocks as long as the total active equity quantity of the active stocks is ensured not to exceed the total equity quantity of the equity of the batch; if the activity is to be increased, the operations of steps S212-213 can be repeated until the activity increase is completed.
For example, the following table information in the general inventory records is updated simultaneously:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 9000 | 9000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
Further, in one embodiment, the buyer can flexibly allocate the established active inventory, wherein the allocation comprises the decrease and increase of the active inventory.
When the original distribution rights and interests of a certain activity are excessive, the rights and interests of the activity inventory are reduced (the number of the available rights and interests of the activity and the total rights and interests of the activity are reduced synchronously), and the number of the rights and interests reduction is less than or equal to the number of the available rights and interests of the activity; the universal inventory synchronously increases the amount of interest in the reduction of the active inventory;
as shown in FIG. 4, when it is considered that the originally assigned equity of a certain activity is excessive, the equity of the activity inventory is reduced, that is, the amount of the available equity of the activity and the amount of the total equity of the activity are synchronously reduced, and the amount of the synchronous reduction of the amount of the available equity of the activity and the amount of the total equity of the activity should be less than or equal to the amount of the available equity of the activity; after the activity available equity quantity and the activity total equity quantity in the active inventory are synchronously reduced, the corresponding general inventory record is updated, the corresponding equity quantity is synchronously increased in the general inventory, namely, the activity total equity quantity and the activity available equity quantity in the general inventory are increased by the corresponding equity quantity, the increase amount of the activity total equity quantity and the activity available equity quantity in the general inventory is equal to the reduction amount of the activity total equity quantity and the activity available equity quantity in the active inventory, and the activity total equity quantity is ensured to be in dynamic balance.
For example, the amount of activity equity before an active inventory adjustment is as follows:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 7000 | 7000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 2000 | 1500 |
The activity a002 activity total equity amount is decremented by 500, and the record updated activity total equity amount and activity available equity amount are each decremented by 500, as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 7000 | 7000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 1500 | 1000 |
The amount of total equity in the activity and the amount of available equity in the sub-inventory universal inventory record for the lot equity are increased in synchronization with the amount of active inventory decrease (500), as shown in the table below:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 7500 | 7500 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 1500 | 1000 |
When the original distributed rights and interests of a certain activity are too little, the rights and interests of the activity inventory are increased (the number of the available rights and interests of the activity and the total rights and interests of the activity are increased synchronously), and the number of the rights and interests is less than the number of the available rights and interests of the activity corresponding to the general inventory; the universal inventory synchronously reduces the increased equity quantity of the active inventory;
as shown in fig. 4, when it is considered that the originally allocated equity of a certain activity is too low, the equity of the activity inventory is increased, that is, the amount of the available equity of the activity and the amount of the total equity of the activity are synchronously increased, and the amount of the synchronous increase of the amount of the available equity of the activity and the amount of the total equity of the activity should be less than the amount of the available equity of the activity; after the activity available equity quantity and the activity total equity quantity in the active inventory are synchronously increased, the corresponding general inventory record is updated, the corresponding equity quantity is synchronously reduced in the general inventory, namely, the activity total equity quantity and the activity available equity quantity in the general inventory are both reduced by the corresponding equity quantity, the reduction amount of the activity total equity quantity and the activity available equity quantity in the general inventory is equal to the increase amount of the activity total equity quantity and the activity available equity quantity in the active inventory, and the activity total equity quantity is ensured to be in dynamic balance.
For example, the amount of activity rights before an active inventory rollup is as follows:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 7000 | 5000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 2000 | 1500 |
The campaign A002 campaign total equity amount is increased by 2000, and the campaign total equity amount and campaign available equity amount for which the record was updated are both increased by 2000, as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 7000 | 5000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 3500 |
The number of total equity in the campaign and the number of available equity in the campaign's sub-inventory universal inventory record are reduced by the number of active inventory increases in synchrony (2000), as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities |
| CouponId0001 | M0001 | B0001 | / | 5000 | 3000 |
| CouponId0001 | M0001 | B0001 | A001 | 1000 | 1000 |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 3500 |
Each equity purchasing batch in the sub-inventory table corresponds to a special active batch-universal inventory record, the equity of the batch is not distributed to the equity of the active inventory and is temporarily stored in the universal inventory record of the batch, and when the active inventory is increased, the total amount of the active equity and the amount of the available equity of the activity of the universal inventory record are deducted, so that the dynamic allocation of the equity is realized; the invention realizes the function of setting different active stocks under the same total stock through the incidence relation of the stock list and the sub-stock list and the introduction of the general stock concept in the sub-stock list, and realizes the dynamic adjustment of the stocks between the active stocks and the general stock.
S400: as shown in FIG. 5, the campaign setting total equity amount and the campaign setting available equity amount are set in the campaign inventory to enable batch release and use of the lot equity.
(1) The equity batch release is specifically as follows:
for the active inventory to which rights have been allocated, the demand for partial active rights batch release is controlled by setting the total rights amount and the available rights amount for the active in the active inventory, and it is required to ensure that the total rights amount for the active setting is less than or equal to the total rights amount for the active setting, and the total rights amount for the active setting is equal to the total rights amount for the active setting at the time of first setting.
For example, the active inventory before the aggregate equity amount is set is shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities | Actively setting the amount of equity | Activity setting of available equity amount |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 3500 | 0 | 0 |
The total equity quantity is set to 1000, which is less than 3500 of the activity available equity quantity, as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities | Actively setting the amount of equity | Activity setting of available equity amount |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 3500 | 1000 | 1000 |
The invention realizes the function of batch release of the active inventory by adding the setting of the activity setting total interest quantity and the activity setting interest available quantity in the active inventory.
(2) The use of inventory rights includes the sub-steps of:
s410: receiving a rights and interests use request, and judging whether an activity number is appointed in the rights and interests use request or not; if the activity number is designated, go to step S420; if the activity number is not specified, go to step S430;
s420: when the rights and interests use the activity number appointed in the request, judge whether the activity sets up the total rights and interests quantity to be greater than 0;
if the total interest amount of the activity setting is larger than 0, further judging whether the available interest amount of the activity setting meets the number of the interest use requests, if so, carrying out processing of receiving the interest ticket code, and if not, directly returning to carry out failure processing;
if the total interest amount of the activity setting is not more than 0, further judging whether the available interest amount of the activity meets the number of the interest use requests, if so, carrying out processing of receiving the interest ticket code, and if not, directly returning to carry out failure processing.
The use of rights and interests by rights and interests buyers needs to appoint the rights and interests number, the batch serial number and the activity number so as to conveniently manage and control rights and interests inventory of activity dimensions; after receiving the rights and interests use request from the rights and interests buyer, the system checks whether the activity available rights and interests quantity or the activity set available rights and interests quantity of the active inventory in the sublinventory table meets the quantity of the rights and interests use request;
if the activity setting total interest amount is larger than 0, judging by using the activity setting available interest amount; if the activity setting available equity quantity meets the quantity of the current equity use request (the activity setting available equity quantity is more than or equal to the quantity of the current equity use request), the subsequent processing of picking up the equity ticket code is continued, and the process returns, the activity setting available equity quantity and the activity available equity quantity of the activity inventory in the sub inventory table are synchronously deducted, and the available equity quantity of the corresponding inventory table recording the batch of equity records is deducted; if the activity setting available equity quantity does not meet the quantity of the equity use request (the activity setting available equity quantity is less than the quantity of the equity use request), directly returning to the shortage of the equity balance, and performing failure processing.
If the activity setting total interest amount is not more than 0, using the activity available interest amount to judge, if the activity available interest amount meets the amount of the interest use request (the activity available interest amount is more than or equal to the amount of the interest use request), continuing to process the subsequent right coupon code picking, returning, synchronously deducting the activity available interest amount of the activity inventory, and deducting the available interest amount of the corresponding inventory table recording the batch of interest records; if the number of the activity available equity does not meet the number of the equity use requests (the number of the activity available equity is less than the number of the equity use requests), directly returning to the state that the equity balance is insufficient, and performing failure processing.
S430: when the rights and interests use request does not specify the activity number, judging whether the number of the rights and interests use request at this time is met or not based on the activity available rights and interests number of the general inventory or the activity setting available rights and interests number;
if the rights and interests use request does not specify the rights and interests activity number, namely if the rights and interests buyer does not specify the activity number when using the rights and interests, judging whether the activity setting total rights and interests quantity is set in the general inventory, if the activity setting total rights and interests quantity of the general inventory is not empty and is more than 0, meaning that the customer sets the activity setting total rights and interests quantity, using the activity setting available rights and interests quantity to judge whether the quantity of the rights and interests use request is met; if the activity setting available equity quantity meets the quantity of the current equity use request (the activity setting available equity quantity is more than or equal to the quantity of the current equity use request), the subsequent processing of picking up the equity ticket code is continued, and the return is made, the activity available equity quantity of the activity inventory is synchronously deducted, and the available equity quantity of the corresponding inventory table record of the batch of equity records is deducted; if the activity setting available interest quantity does not meet the quantity of the current interest use requests (the activity setting available interest quantity is smaller than the quantity of the current interest use requests), prompting that the interest is insufficient, and performing error reporting and returning processing.
If the activity setting total interest amount of the general inventory is null or 0, which means that the client does not set the activity setting total interest amount, the activity available interest amount is used for judging whether the amount of the current interest use request is met; if the number of the activity available equity satisfies the number of the equity use request (the number of the activity available equity is larger than or equal to the number of the equity use request), the subsequent processing of picking up the equity coupon code is continued, and the return is made, the number of the activity available equity of the activity inventory is synchronously deducted, and the number of the available equity of the corresponding inventory record is deducted; if the number of the activity available rights and interests does not meet the number of the rights and interests using requests (the number of the activity available rights and interests is less than the number of the rights and interests using requests), the rights and interests are prompted to be insufficient, and error reporting is carried out for returning processing.
The specific processing of receiving the rights and interests code when the rights and interests are sufficient is as follows:
and (3) using the rights and interests purchaser number, the rights and interests number and the batch serial number to remove the ticket code table to receive the designated number of ticket codes, and synchronously updating the ticket code receiving mark (the received ticket code record of the ticket code table) to be received, so that the repeated receiving of the ticket codes is avoided, and the total number of the ticket codes of the batch of rights and interests in the ticket code table, which are not received, is kept consistent with the available rights and interests number of the corresponding record in the stock table.
When the equity is used, the activity setting available equity quantity and the activity available equity quantity are deducted synchronously, if the activity setting available equity quantity is deducted to be 0 (setting the equity is used up), the equity of the activity is not issued any more to ensure that the equity use does not exceed the limit; when the next batch is needed to be released, the next batch of rights can be released by adjusting the activity setting total rights quantity and the activity setting available rights quantity of the active inventory (the activity side manually adjusts the setting total rights quantity), and only the activity setting total rights quantity and the activity setting available rights quantity are required to be less than the activity available rights quantity.
For example, as shown in the following table, 600 equity picks are used, and the number of equity available for activity setting and the number of equity available for activity 600 are reduced synchronously;
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities | Actively setting the amount of equity | Activity setting of available equity amount |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 2900（3500-600） | 1000 | 400（1000-600） |
When the activity setting available equity quantity is used up, the activity setting available equity quantity is 0, and the use equity can not be received any more; for example as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities | Actively setting the amount of equity | Activity setting of available equity amount |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 2500（2900-400） | 1000 | 0 |
When the right of the next batch is released, adjusting the activity setting total right quantity, synchronously updating the activity setting available right quantity, and ensuring that the activity setting total right quantity is less than or equal to the activity available right quantity; after the right of the batch is put in, the activity sets that the number of the available rights is more than 0, and the rights can be continuously taken for use; for example, 500 equities are released again, and the campaign sets the total amount of equity to 500 (less the amount of equity available to the campaign), as shown in the following table:
| equity number | Equity buyer number | Batch serial number | Activity number | Total amount of rights and interests in activities | Number of rights and interests available for activities | Actively setting the amount of equity | Activity setting of available equity amount |
| CouponId0001 | M0001 | B0001 | A002 | 4000 | 2500 | 500 | 500 |
Further, in one embodiment, the inventory of the inventory table and the inventory of the sub-inventory table are judged based on the inventory alarm ratio so as to realize the functions of inventory automatic alarm of the inventory table and inventory automatic alarm of the sub-inventory table;
(1) judging the inventory of the inventory table based on the inventory alarm proportion when each equity is used, and automatically triggering the inventory alarm of the inventory table if the available equity quantity multiplied by 100%/the total equity quantity is less than or equal to the inventory alarm proportion; if the available equity quantity is multiplied by 100 percent/the total equity quantity is larger than the inventory alarm ratio, no alarm processing is carried out;
with the increase of the use of the equity, the number of the available equity of the purchasing lot of the purchasing party in the inventory table is gradually reduced; when each interest is used, comparing the available rights quantity multiplied by 100%/total rights quantity with the inventory alarm proportion, if the available rights quantity multiplied by 100%/total rights quantity is less than or equal to the inventory alarm proportion, triggering alarm processing (for example, setting an alarm mark as Y), and selecting channels such as mobile phone short messages/emails/WeChat to send out alarm notification to prompt an alarm notification person; for example, prompt alerts notify personnel to specify stock remaining for the equity procurement lot, exceeded stock alert ratio (value of stock alert ratio), equity code, equity procurement quotient, equity lot, alert time, please process in time; the client can know the rights and interests using condition through the alarm information, and can buy a new rights and interests batch again to supplement the rights and interests quantity if the rights and interests are required to be supplemented.
(2) Judging the inventory of the sub-inventory table based on the inventory alarm proportion to realize automatic alarm of the inventory of the sub-inventory table;
when the rights and interests are used, the number of the activity available rights and interests in the sub-stock character tables is synchronously reduced, and if the number of the activity set total rights and interests is set, the number of the activity set rights and interests is synchronously reduced; when a rights and interests use request is received, judging whether the activity set total rights and interests quantity is greater than 0, if the activity set total rights and interests quantity is not greater than 0, further judging whether the activity available rights and interests quantity multiplied by 100%/the activity total rights and interests quantity is greater than the inventory alarm proportion or not based on the activity available rights and interests quantity and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table; if the activity setting total interest quantity is larger than 0, further judging whether the activity setting interest available quantity multiplied by 100 percent/the activity setting total interest quantity is larger than the inventory alarm proportion or not based on the activity setting interest available quantity and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table.
Specifically, the method comprises the following steps:
when the interest use request is received, if the activity setting total interest quantity is 0 or null (the customer does not start the activity setting total interest quantity), carrying out inventory early warning processing according to the activity available interest quantity; comparing the activity available equity quantity multiplied by 100%/the activity total equity quantity with the inventory alarm ratio, if the activity available equity quantity multiplied by 100%/the activity total equity quantity is larger than the inventory alarm ratio, not performing alarm processing, if the activity available equity quantity multiplied by 100%/the activity total equity quantity is smaller than or equal to the inventory alarm ratio, automatically triggering alarm processing (for example, setting an alarm mark as Y), and selecting to perform alarm notification through a mobile phone short message, an electronic mail or a WeChat according to an alarm notification mode; for example, the notification content is "hello, right-of-interest code, right-of-interest purchase quotient, right-of-interest batch, activity number, activity available stock residue corresponding to activity number, total number of activity stocks, triggered stock alarm ratio (value of stock alarm ratio), alarm time, please process in time, thank you"; the customer can allocate the activity rights and interests flexibly, and allocate part of the inventory in the general inventory to the activity inventory, so that the activity inventory is sufficient.
When the equity use request is received, if the activity setting total equity quantity is more than 0 (the customer enables the activity setting total equity quantity), the inventory early warning processing is carried out according to the activity setting equity available quantity; comparing the available quantity of the activity setting rights multiplied by 100%/the total quantity of the activity setting rights with the inventory alarm ratio, and if the available quantity of the activity setting rights multiplied by 100%/the total quantity of the activity setting rights is larger than the inventory alarm ratio, not performing alarm processing; if the inventory alarm ratio is less than or equal to the inventory alarm ratio, automatically triggering alarm processing, and selecting alarm notification through a short message, an e-mail or a Wechat according to an alarm notification mode; for example, the notification content is "hello, right-interest code ×, right-interest purchase quotient ×, right-interest batch ×, activity number ×, activity available stock residue corresponding to activity number ×, total activity stock quantity ×, activity setting right-interest available quantity ×, activity setting total right-interest quantity ×, triggered stock alarm ratio (value of stock alarm ratio), alarm time ×, processing in time, thank you; the customer can increase the total rights and the available rights of the activity through the batch release function of the rights and the interests of the activity, and ensure the sufficiency of the activity stock.
The invention realizes the function of inventory early warning by setting the inventory table alarm mark, the inventory alarm proportion, the alarm notification mode and the contact mode of the alarm person; the function of active inventory early warning is realized through the setting of the alarm mark, the inventory alarm proportion, the alarm notification mode and the contact mode of the alarm person of the sub-inventory table.
The management method for the rights and interests mall activity level inventory adopts the combination of Mysql + redis to perform performance optimization, the inventory table, the sub-inventory table and the coupon code table store records in Mysql, related records in redis also stored in an index form, a program processes read real-time data, the recording of the redis taken as the standard, the data of the redis is durably timed, the data table in the Mysql is updated, and the safety of the data is also ensured while the new performance of the system is ensured.
Example two
FIG. 6 is a system for managing equity mall activity level inventory, according to an embodiment of the present invention, including a creation module, an equity and equity ticket code purchase module, an equity allocation module, and an equity batch release and use module;
the creating module is used for creating an inventory table, a sub-inventory table and a coupon code table;
the right and right ticket code purchasing module is used for purchasing batch right and right ticket codes, automatically generating purchasing records of the batch right in the stock table, automatically generating general stock records of the batch right in the sub-stock table, and automatically adding the right ticket codes to the ticket code table; wherein, the purchase record includes the total equity quantity and the available equity quantity, the general inventory record includes the activity total equity quantity and the activity available equity quantity, and the total equity quantity is equal to the activity total equity quantity, and the available equity quantity is equal to the activity available equity quantity;
the equity distribution module is used for creating active stock in the sub-stock table to distribute the batch equity and synchronously updating a general stock record;
a equity batch release and use module is used to set an activity set total equity amount and an activity set available equity amount in the active inventory to enable the batch equity batch release and use.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a removable hard disk, a ROM, a RAM, a magnetic disk, or an optical disk.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. A method for managing equity mall activity level inventory, comprising the steps of:
s100: creating an inventory table, a sub-inventory table and a coupon code table;
s200: purchasing a batch equity and an equity coupon code, automatically generating purchase records of the batch equity in the stock table, automatically generating general stock records of the batch equity in the sub-stock table, and automatically adding the equity coupon code to the coupon code table; wherein, the purchase record comprises the total equity quantity and the available equity quantity, and the general inventory record comprises the activity total equity quantity and the activity available equity quantity;
s300: creating active inventory in the sub-inventory table to distribute the batch rights and interests, and synchronously updating a general inventory record;
s400: setting an activity setting total equity quantity and an activity setting available equity quantity in the activity inventory to enable batch release and use of the bulk equity.
2. The method for managing interest-mall activity-level inventory as claimed in claim 1, wherein the step S300 is to set an activity number, an activity total interest amount and an activity available interest amount in the activity inventory when the activity inventory is created, wherein the activity total interest amount and the activity available interest amount in the activity inventory are less than or equal to the activity total interest amount and the activity available interest amount recorded in the general inventory for the lot of interest.
3. The method as claimed in claim 1, wherein the step S300 of synchronously updating the universal inventory records comprises:
when the total rights and interests quantity of the activities and the available rights and interests quantity of the activities in the activity library are set, synchronously deducting the total rights and interests quantity of the activities and the available rights and interests quantity of the activities in the general inventory records; the amount of deduction in the general inventory record is equal to the set amount in the active library.
4. The method as claimed in claim 1, wherein the step S300 further comprises deploying the created active inventory, and the deploying includes a reduction or increase of the active inventory.
5. The method for managing equity mall activity level inventory as claimed in claim 1, wherein said bulk equity batch release in step S400 includes:
and setting an activity setting total interest amount and an activity setting available interest amount for the activity inventory corresponding to the activity to control the release of the interest batches, wherein the activity setting total interest amount is less than or equal to the activity available interest amount, and the activity setting available interest amount is equal to the activity setting total interest amount when the activity is set for the first time.
6. The method of claim 1, wherein the use of lot equity in step S400 includes the sub-steps of:
s410: receiving a rights and interests use request, and judging whether an activity number is appointed in the rights and interests use request or not; if the activity number is designated, go to step S420; if the activity number is not specified, go to step S430;
s420: judging whether the activity setting total rights quantity is larger than 0; if the total interest amount of the activity setting is larger than 0, further judging whether the available interest amount of the activity setting meets the amount of the interest use request, if so, carrying out processing of receiving the interest ticket code, and if not, directly returning to carry out failure processing;
if the activity setting total interest amount is not more than 0, further judging whether the activity available interest amount meets the number of the interest use requests, if so, carrying out processing of receiving the interest coupon codes, and if not, directly returning to carry out failure processing;
s430: judging whether the activity setting total interest amount is set in the general inventory, and if the activity setting total interest amount is set, further judging whether the activity setting available interest amount meets the number of the interest use requests; if the right coupon code is not satisfied, directly returning to the failure processing;
if the activity setting total equity quantity is not set, further judging whether the activity available equity quantity meets the quantity of the equity use request; if the right coupon code is not satisfied, the right coupon code is received, and if the right coupon code is not satisfied, the failure processing is directly returned.
7. The method of claim 6, wherein the process of receiving the equity coupon code comprises:
and receiving the designated number of the rights and interests voucher codes based on the rights and interests purchaser number, the rights and interests number and the batch serial number voucher removing number table, and synchronously updating the voucher code receiving mark to be received.
8. The method as claimed in claim 1, wherein the step S400 further includes determining the inventory of the inventory table based on the inventory alarm ratio to realize the inventory automatic alarm of the inventory table, specifically:
judging the inventory of the inventory table based on the inventory alarm proportion when each equity is used, and automatically triggering the inventory alarm of the inventory table if the available equity quantity multiplied by 100%/the total equity quantity is less than or equal to the inventory alarm proportion; if the available equity quantity multiplied by 100 percent/total equity quantity is larger than the inventory alarm ratio, no alarm processing is carried out.
9. The method for managing equity mall activity level inventory as claimed in claim 1, wherein said step S400 further comprises determining sub-inventory table inventory based on inventory alarm ratio to realize sub-inventory table inventory automatic alarm, specifically:
when the rights and interests use request is received, judging whether the activity setting total rights and interests quantity is greater than 0;
if the activity setting total interest amount is not more than 0, further judging whether the activity available interest amount multiplied by 100%/the activity total interest amount is more than the inventory alarm proportion or not based on the activity available interest amount and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table;
if the activity setting total interest quantity is larger than 0, further judging whether the activity setting interest available quantity multiplied by 100 percent/the activity setting total interest quantity is larger than the inventory alarm proportion or not based on the activity setting interest available quantity and the inventory alarm proportion, if so, not performing alarm processing, and if not, automatically triggering the inventory alarm of the sub-inventory table.
10. A management system of equity mall activity level inventory is characterized by comprising a creation module, an equity and equity coupon code purchase module, an equity distribution module and an equity batch release and use module;
the creating module is used for creating an inventory table, a sub-inventory table and a coupon code table;
the right and right ticket code purchasing module is used for purchasing batch right and right ticket codes, automatically generating purchasing records of the batch right in the inventory table, automatically generating general inventory records of the batch right in the sub-inventory table, and automatically adding the right ticket codes to the ticket code table; wherein, the purchase record comprises the total equity quantity and the available equity quantity, and the general inventory record comprises the activity total equity quantity and the activity available equity quantity;
the equity distribution module is used for creating active stock in the sub-stock table to distribute the batch equity and synchronously updating a general stock record;
the equity batch release and use module is for setting an activity set total equity amount and an activity set available equity amount in the active inventory to effect the batch equity batch release and use.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111336178.XA CN113780962A (en) | 2021-11-12 | 2021-11-12 | Management method and system for activity-level inventory of equity mall |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111336178.XA CN113780962A (en) | 2021-11-12 | 2021-11-12 | Management method and system for activity-level inventory of equity mall |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113780962A true CN113780962A (en) | 2021-12-10 |
Family
ID=78956991
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111336178.XA Pending CN113780962A (en) | 2021-11-12 | 2021-11-12 | Management method and system for activity-level inventory of equity mall |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113780962A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1534447A (en) * | 2003-03-31 | 2004-10-06 | 精工爱普生株式会社 | Apparatus and method for issuing preferential tickets |
| CN102136114A (en) * | 2010-01-21 | 2011-07-27 | 维鹏信息技术(上海)有限公司 | Control method for acquiring coupon by coupon terminal and corresponding system |
| CN107944928A (en) * | 2017-12-12 | 2018-04-20 | 北京小米移动软件有限公司 | The distribution method and device of certificate code |
| CN109582682A (en) * | 2018-11-02 | 2019-04-05 | 中国平安人寿保险股份有限公司 | Data processing method, device and storage medium, computer equipment |
| JP6659898B1 (en) * | 2019-06-28 | 2020-03-04 | アビームコンサルティング株式会社 | System, method, and program |
| CN111461599A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Mode state switching method and device, storage medium and electronic device |
-
2021
- 2021-11-12 CN CN202111336178.XA patent/CN113780962A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1534447A (en) * | 2003-03-31 | 2004-10-06 | 精工爱普生株式会社 | Apparatus and method for issuing preferential tickets |
| CN102136114A (en) * | 2010-01-21 | 2011-07-27 | 维鹏信息技术(上海)有限公司 | Control method for acquiring coupon by coupon terminal and corresponding system |
| US20130041742A1 (en) * | 2010-01-21 | 2013-02-14 | Velo Information Technology (Shanghai), Inc. | Control method and corresponding system for obtaining coupons through coupon terminal |
| CN107944928A (en) * | 2017-12-12 | 2018-04-20 | 北京小米移动软件有限公司 | The distribution method and device of certificate code |
| CN109582682A (en) * | 2018-11-02 | 2019-04-05 | 中国平安人寿保险股份有限公司 | Data processing method, device and storage medium, computer equipment |
| JP6659898B1 (en) * | 2019-06-28 | 2020-03-04 | アビームコンサルティング株式会社 | System, method, and program |
| CN111461599A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Mode state switching method and device, storage medium and electronic device |
Non-Patent Citations (2)
| Title |
|---|
| ZHONG0316: "https://www.jianshu.com/p/ccffdaf81b24#comments", 《优惠劵系统库存设计浅谈》 * |
| 多么温暖的阳光啊: "https://blog.csdn.net/qingqingxiangyang/article/details/109314979", 《分库分表》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108921462B (en) | Inventory management method, inventory management device, equipment and storage medium | |
| US6470323B1 (en) | Goods sales management system | |
| US6047264A (en) | Method for supplying automatic status updates using electronic mail | |
| CN110322186A (en) | Data object inventory information processing method, apparatus and system | |
| WO2008042204A1 (en) | Improved method of networking marketing | |
| CN111028009A (en) | Method and device for processing retrievable service entity | |
| US20020198772A1 (en) | Encouraging house card use through price guarantees | |
| US7685139B2 (en) | Translating an order's stock keeping unit hierarchy to an order fulfillment structure | |
| US8417572B1 (en) | Expected exhaustion time | |
| CN113902474A (en) | Information processing method, device, equipment and computer readable storage medium | |
| US20100299229A1 (en) | Capabilities and options for distributing functionality in an enterprise resource planning system landscape | |
| WO2007047538A1 (en) | Delivery date simulation and control | |
| CN113780944A (en) | Information processing method, information processing apparatus, electronic device, and medium | |
| US8489436B1 (en) | System and method for an order handling data model with item-level granularity | |
| CN113780962A (en) | Management method and system for activity-level inventory of equity mall | |
| US20020138484A1 (en) | Business method and data structure for eliminating non-value-added data activity across a business continuum | |
| WO2002086661A2 (en) | Method and apparatus for customer storefront operations | |
| US20100211530A1 (en) | System and method for distributing earnings | |
| CN110838019A (en) | Method and device for determining trial supply distribution crowd | |
| WO2005022309A2 (en) | Manufacturing units of an item in response to demand for the item projected from page-view date | |
| CN111861502B (en) | Information processing method, system, electronic device and storage medium | |
| US20040143517A1 (en) | System and method for managing material distribution and returned materials | |
| JP2018055398A (en) | Point use compromise system and point use compromise method | |
| JPH11175616A (en) | Method for distributing customer information and system for executing the same | |
| CN107562754B (en) | Two-dimensional code management method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211210 |
|
| RJ01 | Rejection of invention patent application after publication |