CN113298562A - Drawing-based home automatic quotation method and system and storage medium - Google Patents
Drawing-based home automatic quotation method and system and storage medium Download PDFInfo
- Publication number
- CN113298562A CN113298562A CN202110555049.3A CN202110555049A CN113298562A CN 113298562 A CN113298562 A CN 113298562A CN 202110555049 A CN202110555049 A CN 202110555049A CN 113298562 A CN113298562 A CN 113298562A
- Authority
- CN
- China
- Prior art keywords
- price
- home
- plate
- projection
- calculating
- 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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
Landscapes
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Strategic Management (AREA)
- Finance (AREA)
- Game Theory and Decision Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a drawing-based automatic home offer method, a drawing-based automatic home offer system and a storage medium, wherein the method comprises the steps of obtaining a home drawing corresponding to an order; extracting a home object in a home drawing; when the home object is a plate object, calculating a plate object price according to the object expansion area and the object plate unit price; when the home object is a component object, calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel; when the home object is a whole object, extracting projection materials, component materials and plate materials of the home object, and calculating the price of the whole object according to the price of the projection materials, the price of the component materials and the price of the plate materials; and carrying out home quotation according to the plate object price, the component object price and the whole object price. Compared with the existing quotation process, the method and the system have the advantages that automatic quotation is directly carried out according to the object information and the material information of the drawing, and the quotation efficiency of home quotation is improved. The method and the device can be widely applied to the technical field of home quotation.
Description
Technical Field
The application relates to the technical field of home quotation, in particular to a method, a system and a storage medium for home automatic quotation based on drawings.
Background
The existing customized home offer needs to disassemble a home drawing, the home drawing is disassembled into a plurality of finished plate pieces, and the offer is carried out according to the finished plate pieces. The dependence of quotation based on the finished plate on quotation personnel is strong, the quotation personnel need to log in the sheet splitting system to manually quotation when the quotation is operated, the quotation process has low efficiency for the quotation process, the process is lagged, and forecast price data reference cannot be provided for a front-end designer in time.
Disclosure of Invention
In view of the above, an object of the present application is to provide a method, a system and a storage medium for automatically offering home offers based on drawings, so as to improve efficiency of home offers.
The first technical scheme adopted by the application is as follows:
a home automatic quotation method based on drawings comprises the following steps:
acquiring a home drawing corresponding to the order;
extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
when the home object is a plate object, calculating the object expansion area of the home object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
when the home object is a component object, calculating the length of an object panel of the home object, acquiring the unit price of the object panel of the home object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
when the home object is a whole object, extracting projection materials, component materials and plate materials of the home object, calculating a material projection area of the projection materials, obtaining a material projection unit price of the projection materials, and calculating a projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and carrying out home quotation according to the plate object price, the component object price and the whole object price.
Further, the step of calculating the material projection area of the projection material specifically includes:
calculating the projection height and the projection width of the projection material, wherein the projection height is calculated according to the highest point of the projection material and the lowest point of the projection material, the highest point is determined according to the top line of the projection material, the top box of the projection material, the top fixing layer of the projection material or the top sealing plate of the projection material, the lowest point is determined according to the base plate of the projection material, the projection width is calculated according to the bottom width of the whole object and the additional width of the whole object, and the additional width is the width of non-projection material in the whole object;
and calculating the projection area according to the projection height and the projection width.
Further, the step of performing home offering according to the plate object price, the component object price and the whole object price specifically includes:
obtaining a product discount combination;
extracting a home discount combination in the home object according to the product discount combination;
acquiring combined discount information according to the home discount combination;
and performing home offer according to the combined discount information, the plate object price, the component object price and the whole object price.
Further, the step of performing home offering according to the plate object price, the component object price and the whole object price specifically includes:
obtaining the order placing time of the order;
obtaining the object color of the household object;
acquiring household discount information according to the ordering time, the household objects and the object colors;
and performing home offer according to the home discount information, the plate object price, the component object price and the whole object price.
Further, the step of performing home offering according to the plate object price, the component object price and the whole object price specifically includes:
acquiring order information of the order, wherein the order information comprises an order type, an order discount, an order distributor and an order detail, and the order detail comprises an object price, an object quantity and an object unit;
and when the order information is not empty, the order discount is larger than a discount threshold value, the object price is a positive integer, and the object quantity is a positive integer, carrying out home offer according to the plate object price, the component object price and the whole object price.
Further, the step of performing home offering according to the plate object price, the component object price and the whole object price specifically includes:
acquiring historical quotation data of the household object, and extracting historical unit prices in the historical quotation data;
determining that the historical unit price is consistent with the object unit price, and performing home quotation according to the plate object price, the component object price and the whole object price;
wherein the object unit price comprises an object panel unit price, an object plate unit price, a material projection unit price, a material panel unit price and a material plate unit price.
Further, the step of performing home offering according to the plate object price, the component object price and the whole object price specifically includes:
acquiring an order placing account of the order;
obtaining account discount and account shipment amount of the order placing account;
calculating account deduction amount according to the account shipment amount;
calculating account discount information according to the account discount and the account deduction amount;
and performing home offer according to the account discount information, the plate object price, the component object price and the whole object price.
The second technical scheme adopted by the application is as follows:
a drawing-based home automatic quotation system comprises:
the order acquisition module is used for acquiring a home drawing corresponding to an order;
the drawing extraction module is used for extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
the plate object module is used for calculating the object expansion area of the home object when the home object is a plate object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
the component object module is used for calculating the length of an object panel of the household object when the household object is a component object, acquiring the unit price of the object panel of the household object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
the whole object module is used for extracting projection materials, component materials and plate materials of the home object when the home object is a whole object, calculating the material projection area of the projection materials, acquiring the material projection unit price of the projection materials, and calculating the projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and the home quotation module is used for performing home quotation according to the plate object price, the component object price and the whole object price.
The third technical scheme adopted by the application is as follows:
a drawing-based home automatic quotation system comprises:
at least one processor;
at least one memory for storing at least one program;
when the at least one program is executed by the at least one processor, the at least one processor is enabled to implement the drawing-based home automatic quotation method.
The fourth technical scheme adopted by the application is as follows:
a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the drawing-based home automatic offer method.
According to the embodiment of the application, the component object, the whole object and the plate object in the home drawing are extracted, and the home price is calculated according to the object expansion area of the plate object, the panel length of the component object and the material information of the whole object. Compared with the existing quotation process, the method and the system have the advantages that automatic quotation is directly carried out according to the object information and the material information of the drawing, manual quotation is not needed, and the quotation efficiency of home quotation is improved.
Drawings
FIG. 1 is a flow chart of quotation steps of a drawing-based home automatic quotation method according to an embodiment of the application;
FIG. 2 is a quotation interaction flow chart of a drawing-based home automatic quotation method according to the embodiment of the application;
FIG. 3 is a flowchart of an order assignment of a drawing-based home automatic offer method according to an embodiment of the present application;
fig. 4 is a flow chart of a sliding door check of the drawing-based home automatic offer method according to the embodiment of the present application.
Detailed Description
The conception, specific structure and technical effects of the present application will be described clearly and completely with reference to the following embodiments and the accompanying drawings, so that the purpose, scheme and effects of the present application can be fully understood.
The present application will now be described in further detail with reference to the accompanying drawings and specific examples. The step numbers in the following embodiments are provided only for convenience of illustration, the order between the steps is not limited at all, and the execution order of each step in the embodiments can be adapted according to the understanding of those skilled in the art. Further, for several described in the following embodiments, it is denoted as at least one.
The customized home is mainly focused on two fields of a customized cabinet and a customized wardrobe, and then is gradually expanded to house spaces such as a bedroom, a study room, a living room, a dining room, a kitchen and the like, and the product fusion is divided into the field of the wardrobe, namely, the wardrobe is cut into the wardrobe, and the field of the wardrobe is cut into the wardrobe.
For customized home, the existing quotation platform is generated by ERP secondary development, the order needs to be disassembled after the order is placed, the disassembling order means that a production enterprise receives an external order, and after a design department designs a product drawing, relevant personnel disassemble the whole drawing into parts according to a production process, so that the order decomposition work required by the production of all levels of parts is determined. Taking the cabinet industry as an example, a person who tears apart carries out tearing apart on a design drawing of a cabinet of a design department according to a production process, specifies specific production parameters of each subunit such as a cabinet door plate, a box body and hardware fittings, and submits a detailed demand list of each subunit. After the bill disassembling work is finished, the purchasing department purchases the components according to the material demand list formed after bill disassembling, and the production department produces the components according to the specific standards and requirements of the components. And after the bill splitting is finished, generating quotation data according to the bill splitting data and transmitting the quotation data to the ERP to generate a quotation. And (4) manually auditing quoted prices by a quote worker on an order quote interface of the ERP system.
To sum up, the existing ERP quotation function is mainly calculated by the receipt removal data, which is finished plate pieces split from drawings, that is, the existing ERP quotation function can only quote according to finished plate pieces. The existing ERP quotation process cannot perform rule analysis according to an original drawing, and quotation cannot be performed according to conditions such as projection area, combination of home furnishing and home furnishing, and the like. In addition, due to the limitation of standard functions, the operation of a quotation interface of the ERP system is complicated, and quotation personnel are required to perform quotation manually. And when the quotation is operated, quotation personnel also need to log in the sheet splitting system at the same time, and open a design software drawing to check whether the comparison data is abnormal or not. The original ERP quotation process has low efficiency for quotation procedures, and the data quality is totally dependent on manual inspection. In addition, the quotation data is generated after the order is removed, the flow is relatively lagged, and the forecast price data reference cannot be provided for a front-end designer in time.
As shown in fig. 1, an embodiment of the present application provides a drawing-based home automatic offer method, including:
s110, acquiring a home drawing corresponding to the order;
s120, extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
s130, when the home object is a plate object, calculating the object expansion area of the home object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
s140, when the home object is a component object, calculating the length of an object panel of the home object, acquiring the unit price of the object panel of the home object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
s150, when the household object is a whole object, extracting projection materials, component materials and plate materials of the household object, calculating the material projection area of the projection materials, obtaining the material projection unit price of the projection materials, and calculating the projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and S160, carrying out home quotation according to the plate object price, the component object price and the whole object price.
Specifically, the customized home needs a front-end designer to design according to user needs, and the customized home comprises a wardrobe body, a sliding door, a baking finish door, a frame splicing door, stone, a drawer, hardware fittings and the like. After a user determines a home drawing of a customized home, a quotation needs to be generated according to the home drawing of the customized home, and the home drawing includes material information such as a material number, a name, a size, a color and a unit of a home object of the customized home. After a user determines a home drawing and a home offer, the customized home only enters a production confirmation stage, and therefore the offer needs to be generated according to the home drawing of the customized home. In the process of generating the quotation according to the home drawing, the home objects in the home drawing need to be extracted at first, and the home objects comprise plate objects, assembly objects and whole objects.
The plate object is quoted in a list quotation mode, quotation is carried out by multiplying the object expansion area of the plate object by the unit price of the plate object, for example, plates in a house such as a plywood, a side plate, a back plate and a leg line need to calculate the actual object expansion area and the plate number of each plate, and the quotation calculation formula of the plate object is as follows:
Sb＝Sbp*Sba*Sbn
wherein S isbPrice of plate object as plate object, SbpTarget plate unit price of plate target, SbaObject development area for plate object, SbnThe number of plate objects.
The module object is quoted by module, such as the products of drawer and trousers rack are quoted by module, not by the actual object expansion area of the plate. And the component object quotes according to the panel length range of the component object and the component unit price corresponding to the range where the panel length of the component object is located. For example, the panel length is 0-480mm for small drawing, and 481-650mm for medium drawing. In some embodiments, when the parser parses the drawing, it is verified that the drawing contains the ID of the panel three-sided drawer product, the width of the drawing panel is 401mm by the three-dimensional coordinate automatic scale, the system defines the drawing panel as a small drawer according to the product process specification, and the width of the component is 480mm or less, so the system automatically outputs the "panel three-sided drawer-small" quotation code. The calculation formula of the component object quotation is as follows:
Su＝Sup*Sun
wherein S isuComponent object price, S, for a component objectupUnit price of component object determined according to range of panel length of component object, SunIs the number of component objects.
The whole object adopts a mixed quotation mode, because the whole object possibly comprises projection materials, component materials and plate materials, the projection materials are materials which can be subjected to projection quotation in the whole object, the component materials and the plate materials are materials which cannot be subjected to projection quotation in the whole object, and the specific limiting rule can be determined by manually inputting screening conditions. In the whole object, the component material adopts the same quotation mode as the component object, the plate material adopts the same quotation mode as the plate object, the projection material adopts the projection quotation, namely, the home is priced according to the product of the maximum width and the maximum height, and the calculation formula of the home projection quotation is as follows:
Sp＝Spp*CC*CC
wherein S ispPrice of the whole object for home, SppUnit price for projection of home furnishing, CwWidth of home, CwCalculated by the difference between two widest non-charging plates at the outermost side of the bottom of the house, ChHeight of home, ChAnd calculating by taking a closing plate, a top line, a top box and an upper fixed layer which are transversely placed at home as a highest point. In some embodiments, the system identifies a product ID for which a per-projection offer is desired, and obtains a projected size of the projected offer product using the three-dimensional coordinate model. And acquiring a projection quotation height by taking a top line, a top box, a top fixed layer or a top sealing plate of the projection quotation product as a highest point, acquiring a total bottom width of the projection quotation product, judging whether the acquired width contains products charged additionally or not, and subtracting the width of the products charged additionally from the total bottom width of the projection quotation product to obtain a final projection quotation width. The projected area of the projected quoted product is obtained by multiplying the projected quoted height and the projected quoted width. For example, the whole object comprises an arc cabinet and a one-line sliding door cabinet, wherein the arc cabinet outputs quotation data according to the quotation mode of the expansion area list; the one-line sliding door cabinet is a projection quotation product, the system verifies that the product ID is the one-line sliding door cabinet, and if the L-shaped or U-shaped cabinet body is not available according to the three-dimensional coordinate model, the system outputs projection quotation codes and material information.
After the plate object price, the component object price and the whole object price are obtained through calculation, automatic quotation can be carried out according to the plate object price, the component object price and the whole object price, an automatic quotation result is output, and a front-end designer can provide the automatic quotation result for a client, so that the ordering process of home customization is accelerated.
Marketing strategies can be added in the automatic quotation process, and a plurality of products are packaged and sold in a combined mode according to the marketing strategies. And judging the ID, the product color and the product quantity of each product in the home drawing, combining and outputting a product material code to carry out sales promotion and quotation settlement. The marketing strategy comprises the steps of providing different discounts and benefits according to the account settled by the distributors in different areas; executing different discount activities on a certain product or a certain flower color according to the promotion time period; carrying out preferential promotion according to a combined selling mode of purchased products; checking rewards and punishments according to the delivery amount; and calculating the final settlement price of the product according to the order product type, the price list corresponding to the product, the sales strategy and the like.
According to the method, a micro-service architecture design concept is adopted, independent application services such as a quotation resolver, a quotation rule conversion platform and a new quotation platform are added, each application service is deployed on an independent server, and data interaction is carried out through a WebService interface. Because the independent server is used, the business process can be decomposed, the operation and maintenance time is shortened, and the load of the ERP server is lightened. The quotation analyzer automatically analyzes and decomposes drawings to obtain quotation material data, and the quotation rule conversion platform can process the quotation data according to user-defined rules, so that the accuracy of the quotation data is improved, and a new quotation platform can perform quotation. The quotation rule conversion platform is based on Asp.net4.5 and WebService technologies, Telerik.Web is used as a foreground development control, the new quotation platform is based on Asp.net MVC5.0, WebService and Knockout technologies, EasyUI is used as a foreground development display UI, the Knockout is mainly used for logic interaction of a front end, and a data request is submitted in combination with JQuery Ajax.
The processing flow of the drawing-based home automatic quotation can refer to fig. 2, and the quotation resolver is a server on which design software is installed. After the order is accepted, the counting system pushes the drawing paper to the service, the design software automatically opens the drawing paper for analysis, and the three-dimensional space diagram is converted into a material plate.
The quotation rule conversion platform is a quotation rule platform for quickly responding to market changes and adapting to diversified extension of the market, and can update, delete and newly add quotation data according to conditions such as order types, order accounts, order time, material codes, material colors, discount rules, material structures and the like, so that final quotation materials are combined. For example, a discount campaign, at a particular time frame, at least 7 products in the same order may enjoy the discount benefit. The orders need to be screened through the order placing time and the material codes through the rule conversion platform, the orders meeting the conditions are marked as premium discount orders, active premium discount calculation is carried out, and otherwise the orders are output according to the original product materials.
In the automatic quotation process, when a user places an order in a CRM, the system calls a quotation resolver interface to perform pre-quotation and return a result to an ordering system. After the counting system accepts the order, when an ERP synchronous queue synchronizes an order head, the counting system transmits a design drawing to a sheet disassembling analyzer for automatic analysis, and simultaneously transmits the order to a quotation analyzer for automatic analysis. And the system calls a quotation resolver interface to carry out B2B quotation, and the quotation result is stored in a temporary table of a quotation rule conversion platform. And the material counting system examines the data, completes the order line synchronously in an ERP synchronous queue, combines the material counting data and the quotation analysis data, and generates a complete quotation data according to the rules of the quotation rule conversion platform. In the ERP synchronous queue, the order synchronizes quoted data to an old quoted interface table in the ERP according to a shunting rule, or calls a WebService interface to synchronize quoted data to a new quoted platform. The new quotation platform obtains configured prices and discounts according to the number of the material counting order, the order type, the customer information, the material type and the design color, the prices and the discounts can be flexibly configured according to the order placing account, the order type, the material type, the material thickness and the design color, and the execution relation among different discounts can also be flexibly configured according to the actual service use formula. After the price discount is obtained, the order executes automatic quotation verification, the quotation data and the counting data are verified according to a fixed rule, and the price and the discount of the material are compared and verified with the inspection list. And executing automatic quotation if the data, the price and the discount are verified to pass the order, otherwise, manually checking the quotation. After the automatic quote order confirms that the data is correct, automatic examination and quote can be carried out. If the material counting data is changed, the quotation is automatically checked and the quotation data is updated again.
In some embodiments, a WebService interface is provided for the charging system to call, and complete quotation data and charging data generated by the quotation rule conversion platform are received, wherein the WebService interface is used for pulling prices and discounts maintained on a new quotation platform, and the charging data is used for verifying rules of automatic quotation.
In some embodiments, a plurality of basic discounts, such as a single promotion discount, a dealer discount, a transportation installation fee, a quarterly incentive coefficient, a first special discount, a second special discount, a logistics subsidy, a financial rebate, a discount-up, a first mechanical discount, a second mechanical discount, a third mechanical discount, and the like, are set. On the basis of original price, discount setting is mainly carried out from 3 dimensions of materials, distributors and time, and a discount formula is combined, so that flexible configuration is carried out on single or multiple materials, single or multiple distributors, single or multiple order types, single or multiple material designs and colors, validity periods and material specifications, and flexible and variable marketing strategies at the front end are met to the greatest extent. And a bsgrid control is adopted on a system page for data display and data editing, so that page operation and Excel table operation simulation are realized, and great convenience is brought to data maintenance personnel.
In some embodiments, an automatic assignment order pool algorithm is designed, and referring to fig. 3, a plurality of order attributes such as an order type, a price type, a business entity, a quotation state, an order inclusion, a delivery plan and a pick-up plan are set through a maintenance page of an automatic assignment rule to allocate orders in an order pool, and the orders are assigned to quotation names in charge of the quotation, so that the demand of the quotation group for performing division quotation for the quotation members is greatly facilitated.
In some embodiments, order verification is provided, and only the order which passes the order verification can be automatically quoted, so that the probability of error of automatic quote can be reduced through the order verification. The order verification mainly comprises conventional verification, material counting data verification and comparison order verification, the passing rate of the automatic quoted orders can be controlled through the order verification, and the orders which do not pass the verification are manually processed.
And conventional verification is performed, and the orders meeting the requirements are screened out for automatic quotation by verifying data such as order amount, order types, order materials and the like, and the main verification of conventional information verification comprises the following steps: the total amount of the quotation cannot be zero; the order type cannot be null; orders that do not participate in the special lot discount; dealer information cannot be null; there must be order details; the sum of the single items and the sum of the single due charge must be consistent; the unit price of a single material cannot be less than or equal to 0; the sales of the single material can not be less than or equal to 0; the unit of single material can not be empty; all door opening amounts must be in agreement with the sum of their detailed amounts.
The counting data verification utilizes conversion rule relations between counting data and quotation data summarized from business, and verification is carried out through the rule relations, so that orders which accord with the rules are screened out for automatic quotation, and the lap area is calculated through counting if the lap area is verified, and then verification is carried out with the lap data analyzed by the quotation analyzer.
The quoted door area is calculated according to the width and height of the household door opening, and the calculation formula is as follows:
Cs＝Dw*Dh
wherein, CsTo quote the area of the door, DwWidth of sliding door for home, DhThe height of the sliding door is the height of the household sliding door.
The sliding door calculation rule of the counting data is shown in the following table, the door leaf number of the sliding door and the vertical frame of the sliding door need to be acquired firstly, then the overlapping position of the sliding door is acquired according to the door leaf number of the sliding door and the vertical frame table lookup of the sliding door, the sliding door width can be calculated according to the overlapping position of the sliding door and the door opening width, the sliding door height can be acquired according to the door opening height, and the counting sliding door area can be calculated according to the sliding door width and the sliding door height.
The material counting data verification process is as shown in fig. 4, and if the difference between the quoted sliding door area and the counted sliding door area is determined to be smaller than the preset threshold, the sliding door area verification can be passed.
The comparison order verification is to generate a comparison order which is the same as the order needing automatic quotation in real time, pull the historical unit price and the historical discount in real time, compare the same materials under the order details, namely, compare the unit prices of the two units and the corresponding discounts one by one, compare the special material details using the quotation discount with a discount formula, and finally screen out the order meeting the requirements to carry out automatic quotation.
And the order passing the quotation examination transmits the information of the single head, the detail, the price, the discount and the like of the quotation order to the ERP for the credit examination and the invoicing of the ERP by calling a WebService interface provided by the ERP.
The application also provides a home automatic quotation system based on the drawing, which comprises:
the order acquisition module is used for acquiring a home drawing corresponding to an order;
the drawing extraction module is used for extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
the plate object module is used for calculating the object expansion area of the home object when the home object is a plate object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
the component object module is used for calculating the length of an object panel of the household object when the household object is a component object, acquiring the unit price of the object panel of the household object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
the whole object module is used for extracting projection materials, component materials and plate materials of the home object when the home object is a whole object, calculating the material projection area of the projection materials, acquiring the material projection unit price of the projection materials, and calculating the projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and the home quotation module is used for performing home quotation according to the plate object price, the component object price and the whole object price.
The contents in the above method embodiments are all applicable to the present system embodiment, the functions specifically implemented by the present system embodiment are the same as those in the above method embodiment, and the beneficial effects achieved by the present system embodiment are also the same as those achieved by the above method embodiment.
The application also provides a home automatic quotation system based on the drawing, which comprises:
at least one processor;
at least one memory for storing at least one program;
when the at least one program is executed by the at least one processor, the at least one processor is enabled to implement the drawing-based home automatic quotation method.
The contents in the above method embodiments are all applicable to the present system embodiment, the functions specifically implemented by the present system embodiment are the same as those in the above method embodiment, and the beneficial effects achieved by the present system embodiment are also the same as those achieved by the above method embodiment.
In addition, a storage medium is further provided, where processor-executable instructions are stored, and when executed by a processor, the processor-executable instructions are configured to perform the steps of the method for processing mutual information according to any one of the above-mentioned method embodiments. For the storage medium, it may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. It can be seen that the contents in the foregoing method embodiments are all applicable to this storage medium embodiment, the functions specifically implemented by this storage medium embodiment are the same as those in the foregoing method embodiments, and the advantageous effects achieved by this storage medium embodiment are also the same as those achieved by the foregoing method embodiments.
It should be appreciated that the layers, modules, units, platforms, and/or the like included in an embodiment system of the application may be implemented or embodied by computer hardware, a combination of hardware and software, or by computer instructions stored in a non-transitory computer readable memory. The methods may be implemented in a computer program using standard programming techniques, including a non-transitory computer-readable storage medium configured with the computer program, where the storage medium so configured causes a computer to operate in a specific and predefined manner, according to the methods and figures described in the detailed description. Each program may be implemented in a high level procedural or object oriented programming language to communicate with a computer system. However, the program(s) can be implemented in assembly or machine language, if desired. In any case, the language may be a compiled or interpreted language. Furthermore, the program can be run on a programmed application specific integrated circuit for this purpose.
Moreover, the data processing flows performed by the layers, modules, units, and/or platforms included in the system embodiments of the present application may be performed in any suitable order unless otherwise indicated herein or otherwise clearly contradicted by context. The data processing flows correspondingly performed by the layers, modules, units and/or platforms included in the system of embodiments of the present application may be performed under the control of one or more computer systems configured with executable instructions, and may be implemented as code (e.g., executable instructions, one or more computer programs, or one or more applications) collectively executed on one or more processors, by hardware, or a combination thereof. The computer program includes a plurality of instructions executable by one or more processors.
Further, the system may be implemented in any type of computing platform operatively connected to a suitable connection, including but not limited to a personal computer, mini computer, mainframe, workstation, networked or distributed computing environment, separate or integrated computer platform, or in communication with a charged particle tool or other imaging device, and the like. The data processing flows correspondingly executed by the layers, modules, units and/or platforms included in the system of the present application may be implemented in machine readable code stored on a non-transitory storage medium or device, whether removable or integrated into a computing platform, such as a hard disk, an optical read and/or write storage medium, a RAM, a ROM, etc., so that it may be read by a programmable computer, and when the storage medium or device is read by a computer, may be used to configure and operate the computer to perform the processes described herein. Further, the machine-readable code, or portions thereof, may be transmitted over a wired or wireless network. The invention described herein includes these and other different types of non-transitory computer-readable storage media when such media include instructions or programs that implement the steps described above in conjunction with a microprocessor or other data processor. The present application also includes the computer itself when programmed according to the methods and techniques described herein.
The above description is only a preferred embodiment of the present application, and the present application is not limited to the above embodiment, and any modifications, equivalent substitutions, improvements, etc. within the spirit and principle of the present application should be included in the protection scope of the present application as long as the technical effects of the present application are achieved by the same means. Various modifications and variations of the technical solution and/or embodiments thereof are possible within the protective scope of the present application.
Claims (10)
1. A home automatic quotation method based on drawings is characterized by comprising the following steps:
acquiring a home drawing corresponding to the order;
extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
when the home object is a plate object, calculating the object expansion area of the home object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
when the home object is a component object, calculating the length of an object panel of the home object, acquiring the unit price of the object panel of the home object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
when the home object is a whole object, extracting projection materials, component materials and plate materials of the home object, calculating a material projection area of the projection materials, obtaining a material projection unit price of the projection materials, and calculating a projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and carrying out home quotation according to the plate object price, the component object price and the whole object price.
2. The drawing-based home automatic quotation method according to claim 1, wherein the step of calculating the material projection area of the projection material specifically comprises:
calculating the projection height and the projection width of the projection material, wherein the projection height is calculated according to the highest point of the projection material and the lowest point of the projection material, the highest point is determined according to the top line of the projection material, the top box of the projection material, the top fixing layer of the projection material or the top sealing plate of the projection material, the lowest point is determined according to the base plate of the projection material, the projection width is calculated according to the bottom width of the whole object and the additional width of the whole object, and the additional width is the width of non-projection material in the whole object;
and calculating the projection area according to the projection height and the projection width.
3. The drawing-based automatic home offer method according to claim 1, wherein said step of performing a home offer according to said plate object price, said component object price and said whole object price specifically comprises:
obtaining a product discount combination;
extracting a home discount combination in the home object according to the product discount combination;
acquiring combined discount information according to the home discount combination;
and performing home offer according to the combined discount information, the plate object price, the component object price and the whole object price.
4. The drawing-based automatic home offer method according to claim 1, wherein said step of performing a home offer according to said plate object price, said component object price and said whole object price specifically comprises:
obtaining the order placing time of the order;
obtaining the object color of the household object;
acquiring household discount information according to the ordering time, the household objects and the object colors;
and performing home offer according to the home discount information, the plate object price, the component object price and the whole object price.
5. The drawing-based automatic home offer method according to claim 1, wherein said step of performing a home offer according to said plate object price, said component object price and said whole object price specifically comprises:
acquiring order information of the order, wherein the order information comprises an order type, an order discount, an order distributor and an order detail, and the order detail comprises an object price, an object quantity and an object unit;
and when the order information is not empty, the order discount is larger than a discount threshold value, the object price is a positive integer, and the object quantity is a positive integer, carrying out home offer according to the plate object price, the component object price and the whole object price.
6. The drawing-based automatic home offer method according to claim 1, wherein said step of performing a home offer according to said plate object price, said component object price and said whole object price specifically comprises:
acquiring historical quotation data of the household object, and extracting historical unit prices in the historical quotation data;
determining that the historical unit price is consistent with the object unit price, and performing home quotation according to the plate object price, the component object price and the whole object price;
wherein the object unit price comprises an object panel unit price, an object plate unit price, a material projection unit price, a material panel unit price and a material plate unit price.
7. The drawing-based automatic home offer method according to claim 1, wherein said step of performing a home offer according to said plate object price, said component object price and said whole object price specifically comprises:
acquiring an order placing account of the order;
obtaining account discount and account shipment amount of the order placing account;
calculating account deduction amount according to the account shipment amount;
calculating account discount information according to the account discount and the account deduction amount;
and performing home offer according to the account discount information, the plate object price, the component object price and the whole object price.
8. The utility model provides a house automatic quotation system based on drawing which characterized in that includes:
the order acquisition module is used for acquiring a home drawing corresponding to an order;
the drawing extraction module is used for extracting a home object in the home drawing, wherein the home object comprises a plate object, a component object and a whole object;
the plate object module is used for calculating the object expansion area of the home object when the home object is a plate object, acquiring the object plate unit price of the plate object, and calculating the plate object price according to the object expansion area and the object plate unit price;
the component object module is used for calculating the length of an object panel of the household object when the household object is a component object, acquiring the unit price of the object panel of the household object, and calculating the price of the component object according to the range of the length of the object panel and the unit price of the object panel;
the whole object module is used for extracting projection materials, component materials and plate materials of the home object when the home object is a whole object, calculating the material projection area of the projection materials, acquiring the material projection unit price of the projection materials, and calculating the projection material price according to the material projection area and the material projection unit price; calculating the length of a material panel of the component material, acquiring the unit price of the material panel of the component material, and calculating the price of the component material according to the range of the unit price of the material panel and the unit price of the material panel; calculating the material unfolding area of the plate material, acquiring the material plate unit price of the plate material, and calculating the plate material price according to the material unfolding area and the material plate unit price; calculating the price of the whole object according to the projection material price, the component material price and the plate material price;
and the home quotation module is used for performing home quotation according to the plate object price, the component object price and the whole object price.
9. The utility model provides a house automatic quotation system based on drawing which characterized in that includes:
at least one processor;
at least one memory for storing at least one program;
when executed by the at least one processor, cause the at least one processor to implement the drawing-based home automatic offer method according to any one of claims 1-7.
10. A computer-readable storage medium having stored thereon a computer program, wherein the computer program, when executed by a processor, implements the drawing-based home automatic offer method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110555049.3A CN113298562A (en) | 2021-05-21 | 2021-05-21 | Drawing-based home automatic quotation method and system and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110555049.3A CN113298562A (en) | 2021-05-21 | 2021-05-21 | Drawing-based home automatic quotation method and system and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113298562A true CN113298562A (en) | 2021-08-24 |
Family
ID=77323347
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110555049.3A Pending CN113298562A (en) | 2021-05-21 | 2021-05-21 | Drawing-based home automatic quotation method and system and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113298562A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113538116A (en) * | 2021-09-16 | 2021-10-22 | 广州诗尼曼家居股份有限公司 | Door type household on-line customized one-key quotation system and method |
| CN114677186A (en) * | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Offer calculation method and device for financial product, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130046598A1 (en) * | 2011-08-17 | 2013-02-21 | Stack N' Save Inc. | Method and system for placing and collectively discounting purchase orders via a communications network |
| CN106485578A (en) * | 2016-10-27 | 2017-03-08 | 南京用友通信息技术有限公司 | Smart home quick modularity quotation system and method |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN110909600A (en) * | 2019-10-16 | 2020-03-24 | 北京华跃博弈科技有限公司 | Method and system for automatically generating decoration quotation from design drawing |
| CN111680340A (en) * | 2020-05-28 | 2020-09-18 | 上海上咨工程造价咨询有限公司 | Building material price information pushing method, system and device and storage medium thereof |
-
2021
- 2021-05-21 CN CN202110555049.3A patent/CN113298562A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130046598A1 (en) * | 2011-08-17 | 2013-02-21 | Stack N' Save Inc. | Method and system for placing and collectively discounting purchase orders via a communications network |
| CN106485578A (en) * | 2016-10-27 | 2017-03-08 | 南京用友通信息技术有限公司 | Smart home quick modularity quotation system and method |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN110909600A (en) * | 2019-10-16 | 2020-03-24 | 北京华跃博弈科技有限公司 | Method and system for automatically generating decoration quotation from design drawing |
| CN111680340A (en) * | 2020-05-28 | 2020-09-18 | 上海上咨工程造价咨询有限公司 | Building material price information pushing method, system and device and storage medium thereof |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113538116A (en) * | 2021-09-16 | 2021-10-22 | 广州诗尼曼家居股份有限公司 | Door type household on-line customized one-key quotation system and method |
| CN113538116B (en) * | 2021-09-16 | 2022-03-22 | 广州诗尼曼家居股份有限公司 | Door type household on-line customized one-key quotation system and method |
| CN114677186A (en) * | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Offer calculation method and device for financial product, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112950162A (en) | Information system engineering supervision work distribution management information system | |
| CN111815283A (en) | Information system engineering supervision enterprise business management system | |
| CN113298562A (en) | Drawing-based home automatic quotation method and system and storage medium | |
| CN104809553A (en) | Multi-source electronic commerce data processing platform and method for heterogeneous data | |
| Gourdon et al. | Trade policy and industrial policy in China: What motivates public authorities to apply restrictions on exports? | |
| CN111142855B (en) | Software development method and software development system | |
| TW578071B (en) | System and method for allocating the supply of critical material components and manufacturing capacity | |
| CN104599019A (en) | Financial budgeting system | |
| CN114511203A (en) | Method and system for rapidly outputting project amount list based on BIM (building information modeling) | |
| CN107358472A (en) | Data processing method and device | |
| KR20170132448A (en) | Franchise membership joining system | |
| US8032454B2 (en) | Import declaration/foreign supplier invoice payment reconciliation process | |
| CN109741077A (en) | Aftermarket Claims settlement method, equipment and storage medium | |
| JPWO2017077920A1 (en) | Management support apparatus and management support method | |
| CN111028026A (en) | Invoice matching method and system | |
| KR102380556B1 (en) | System and method for business to business settlement and computer program for the same | |
| KR20190055857A (en) | System and method for adjusting material ledger | |
| Dietl et al. | Competition and welfare effects of VAT exemptions | |
| JP2014119821A (en) | Retroaction unit price correction system and method | |
| KR20210093563A (en) | Apparatus and method for managing of real estate | |
| CN114556392A (en) | Stock evaluation device | |
| CN113129066A (en) | Selling profit distribution determining method and device, electronic equipment and storage medium | |
| Li et al. | Dynamic inventory control with payment delay and credit limit | |
| JP3695152B2 (en) | Cost index calculation device | |
| CN111260409A (en) | Convenient and quick cost analysis control management method and device thereof |
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 |