KR102318878B1 - Agricultural product sales integrated management system capable of customizing management items, and agricultural product sales integrated management method using the system - Google Patents

Abstract

The present invention relates to an agricultural product sales integrated management system capable of customizing management items and an integrated agricultural product sales management method using the same. According to an embodiment of the present invention, an agricultural products sales integrated management system includes: a management item selection unit in which a plurality of management items each including information related to agricultural product sales for managing the agricultural product sales are listed; a management item insertion unit providing a space for selectively inserting the management items listed in the management item selection unit; and a display unit for displaying a result value of the agricultural product sales related information for the management item selectively inserted into the management item insertion unit. Accordingly, it is possible to remarkably improve convenience of managing the agricultural products and selling the agricultural products.

Description

Agricultural product sales integrated management system capable of customizing management items, and agricultural product sales integrated management method using the system

The present invention relates to an integrated agricultural product sales management system and an integrated agricultural product sales management method using the system, and more particularly, it is possible to customize the management items for the integrated agricultural product sales management, so that the result values according to the management items can be quickly and varied. It relates to an integrated agricultural product sales management system that improves the convenience of management by being able to confirm it in detail, and a method for integrated management of agricultural product sales using the system.

Local food refers to local agricultural products that have not been transported over long distances, and generally refers to agricultural products produced within a radius of 50 km.

The local food movement started with the consumption of fresh and reliable food produced in a geographically close location with the aim of maximizing the freshness of food by shortening the movement distance between producers and consumers. As a result, various local food outlets were created as a result of the revitalization of various local food stores. Thanks to these local food direct stores, it is now possible to form a local food network, revitalize the local economy, and protect the health of local residents and rural resources.

Local food direct stores receive products from various local farmers and sell them to consumers, and their annual sales have reached tens of billions of dollars. Management method and system” and Korean Patent No. 10-1725339 “Local food distribution management method and system” have been disclosed.

Meanwhile, in recent years, a food plan, a concept of food policy that has expanded beyond local food, has emerged. A food plan is a comprehensive food strategy that aims to change the food distribution system centered on external procurement into a local circulation system by integrating and managing various food issues such as production, processing, distribution, consumption, safety, nutrition, welfare, and the environment. Projects for realizing the goals of the plan include “Operating a local food store”, “Operating a food service center”, “Planned production”, “Operating a processing center”, and “Operating a farmhouse restaurant”.

In order to operate according to the food plan as described above, it is necessary to inquire and process more various types and more data. However, this method alone has limitations, and it is insufficient to process many types of data. Accordingly, there is a problem in that additional records or management work through programs such as Excel are frequently generated.

Accordingly, there is a demand for the development of a system of a new concept optimized for a food plan that can more easily process and manage a large number of data according to the increase in complexity tailored to the operation of the food plan.

The present invention relates to an agricultural product sales integrated management system and agricultural product sales integrated management method that can more effectively sell and manage agricultural products in accordance with the expansion operation to a food plan, and a management item containing a plurality of agricultural product sales related information is displayed in a pivot table. It is configured to freely set, check, and change the information to be managed while freely customizing the form, and it is configured to allow filtering of management information and to use presets. It aims to provide an integrated management system and an integrated management method for agricultural product sales.

Agricultural product sales integrated management system capable of customizing management items according to an embodiment of the present invention for solving the above problems, a management item selection in which a plurality of management items including information related to agricultural product sales for managing agricultural product sales, respectively, are listed wealth; A management item insertion unit providing a space for selectively inserting the management items listed in the management item selection unit and a display unit displaying the result value of agricultural product sales related information for the management item selectively inserted into the management item insertion unit can be configured.

Here, the management item includes: a vendor management item in which agricultural products or agricultural products-related product vendor information is stored; Goods management items in which agricultural products or agricultural products related product information are stored; Farm information management item in which agricultural products or agricultural products-related product sales farm information is stored; a transaction history management item in which agricultural products or agricultural products-related product transaction history information is stored; It may be configured to include a unit item in which product unit information of agricultural products or agricultural products-related products is stored and date management items in which transaction date information of agricultural products or agricultural products-related products is stored.

In addition, the management item includes a filter module capable of selectively extracting stored agricultural product sales related information, and the display unit is configured to display only the result value for the selective information when the selective information is extracted by the filter module. can

In addition, the agricultural product sales integrated management system further includes a filter module condition editing module capable of editing the extraction condition of the filter module, wherein the filter module condition editing module is configured to edit the extraction condition of the filter module to be edited. a filter edit field control unit for controlling addition and deletion of in-filter edit fields; a filter operator change unit capable of changing or editing a filter operator for calculating the filter edit column; a filter condition setting unit capable of setting a filter condition applied to the filter edit field; It may be configured to include a management item setting unit capable of setting a management item applied to the filter edit column and a condition value setting unit capable of setting a condition value for a filter condition of a management item applied to the filter edit column.

In addition, the agricultural product sales integrated management system further comprises an information update module for updating the changes in the agricultural product sales related information, wherein the information update module automatically updates in real time according to the changes in the agricultural product sales related information, or data It may be configured to manually update upon loading request.

In addition, the agricultural product sales integrated management system further comprises a layout control module for adjusting the layout of the agricultural product sales integrated system, the layout control module, the management item selection unit or the management item insertion unit layout for the management items A management item layout control unit configured to selectively or comprehensively adjust, and a result value layout control unit configured to selectively or comprehensively control detailed items for a result value according to insertion of a management item into the management item insertion unit. have.

In addition, the insertion of the management item into the management item insertion unit may be configured to manually insert from the management item selection unit to the management item insertion unit directly by a drag & drop method.

In addition, the agricultural product sales integrated management system further includes an insertion item input module for automatically inserting the management item to the management item insertion unit, wherein the insertion item input module includes: an input box provided to drag & drop management items; It may be configured to include an insertion position selection unit for selecting an insertion position of the management item dragged and dropped into the input box, and an insertion determination module for determining whether to insert into the insertion position selected by the insertion position selection unit.

In addition, the management item inserting unit may include: a column inserting unit serving as an insertion space for management items for displaying the result value displayed on the display unit in a column unit; A row insert, which is an insertion space for management items for displaying the result value displayed by the display unit in row units, and the result value for agricultural product sales information to be displayed in columns and rows through the column insert and row insert unit It may be configured to include a value insertion unit that is an insertion space of .

In addition, the management items may be configured to include a sorting module capable of sorting in ascending or descending order according to criteria set for each stored agricultural product sales related information.

In addition, the agricultural product sales integrated management system, the management item is inserted into the management item insertion unit, set the displayed state in the display unit, store the modularized preset as it is, call the stored preset state, and connect the stored preset to the network It may further include a preset setting module configured to be shared over a network.

On the other hand, the agricultural product sales integrated management method according to an embodiment of the present invention is an agricultural product sales integrated management method using an agricultural product sales integrated management system that can customize the management items, and the management item selection unit selects the management items to be displayed on the display unit. to do; Inserting the selected management items into the column inserter, the row inserter, and the value inserter of the management item inserter through drag & drop or an insert item input module, respectively, and a value for each management item inserted into the column inserter and the row inserter It may be configured to include the step of checking the result value inserted into the insertion unit through the display unit.

Agricultural products sales integrated management system according to an embodiment of the present invention is configured to freely set, check, and change information to be managed while freely customizing management items containing a plurality of agricultural product sales related information in the form of a pivot table, , it has the advantage of significantly improving the convenience of managing agricultural products and selling agricultural products.

In addition, the agricultural product sales integrated management system according to an embodiment of the present invention is a system optimized for a food plan, which is a higher concept expanded from the concept of local food. It has the advantage of being easier and faster to process.

In addition, the above-mentioned effects according to the embodiments of the present invention are not limited to the described content, and may further include all effects predictable from the specification and drawings.

1 is a diagram illustrating a location and connection configuration of an integrated agricultural product sales management system according to an embodiment of the present invention.
Figure 2 is a diagram schematically showing each configuration of the agricultural product sales integrated management system according to an embodiment of the present invention.
FIG. 3 is a diagram illustrating a configuration of a management item selection unit, which is one configuration of the agricultural product sales integrated management system of FIG. 2 .
4 is a diagram illustrating a configuration of a management item insertion unit, which is one configuration of the agricultural product sales integrated management system of FIG. 2 .
5 is a view showing the entire interface of the agricultural product sales integrated management system according to an embodiment of the present invention.
6 is a diagram illustrating an insertion item input module according to an embodiment of the present invention.
7 is a diagram illustrating a filter module according to an embodiment of the present invention.
8A to 8E are diagrams illustrating in detail a filter module condition editing module according to an embodiment of the present invention.
9 is a view showing an example of an alignment module according to an embodiment of the present invention.
10A is a view showing an item layout control unit of a data loading request module and a layout control module according to an embodiment of the present invention, and FIG. 10B is a result value layout control of the data loading request module and a layout control module according to an embodiment of the present invention It is a drawing showing wealth.
11 is a view showing icons for an inquiry period setting module, a preset setting module, and a document file extraction module according to an embodiment of the present invention.
FIG. 12 is a detailed view showing the inquiry period setting module of FIG. 11 .
13A and 13B are diagrams illustrating in detail the preset setting module of FIG. 11 and the interface change for preset change through the preset setting module.
14 is a block diagram of a detailed configuration of the preset setting module shown in FIGS. 13A and 13 .
15 is a diagram schematically illustrating a preset setting module including the detailed configurations of FIG. 14 in detail.
16 is a flowchart of a method for integrated management of agricultural products sales according to an embodiment of the present invention.

Hereinafter, the description of the present invention with reference to the drawings is not limited to specific embodiments, and various modifications may be made and various embodiments may be provided. In addition, it should be understood that the contents described below include all conversions, equivalents, and substitutes included in the spirit and scope of the present invention.

In the following description, terms such as first and second are terms used to describe various components, meanings are not limited thereto, and are used only for the purpose of distinguishing one component from other components.

Like reference numbers used throughout this specification refer to like elements.

As used herein, the singular expression includes the plural expression unless the context clearly dictates otherwise. In addition, terms such as "comprises", "comprising" or "have" described below are intended to designate the existence of features, numbers, steps, operations, components, parts, or combinations thereof described in the specification. It should be construed as not precluding the possibility of the presence or addition of one or more other features, numbers, steps, operations, components, parts, or combinations thereof.

In addition, terms such as “…unit”, “…group”, and “…module” described in the specification mean a unit that processes at least one function or operation, which may be implemented by hardware or software or a combination of hardware and software. can

Hereinafter, an integrated agricultural product sales management system capable of customizing management items according to an embodiment of the present invention and an agricultural product sales integrated management method using the system will be described in detail with reference to the accompanying drawings.

1 is a diagram illustrating a location and connection configuration of an integrated agricultural product sales management system according to an embodiment of the present invention.

First, referring to FIG. 1 , the agricultural product sales integrated management system 100 (hereinafter referred to as 'agricultural product sales integrated management system') capable of customizing management items according to an embodiment of the present invention is a local food direct store or a plurality of local As a system installed and implemented in the sales management server 10 of an integrated management center that operates and manages a food plan including management of direct food stores, a POS device 20 installed in a sales stand of a local food store, inventory management, etc. For this, it may be configured to receive and store agricultural product sales related information by interworking with the barcode reader 30 used by the direct store manager or the portable terminal 40 such as a PDA or mobile phone.

That is, the agricultural product sales integrated management system 100 according to an embodiment of the present invention is installed in the sales management server 10 provided in the form of a PC (Personal Computer) or monitoring system in the form of a program or application, etc., POS It is a place where agricultural product sales related information is gathered through the device 20, the barcode recognizer 30, the portable terminal 40, etc., and can be formed to perform integrated management related to agricultural product sales by utilizing such information.

In this case, the agricultural products sales information database 105 in which agricultural products sales related information is stored may be dualized with the agricultural products sales integrated management system 100 in the sales management server 10, but is not necessarily limited thereto. (100) may be formed to be provided in itself.

That is, the location of the agricultural product sales information database 105 in which agricultural product sales information is stored is not limited, but it is sufficient if used in conjunction with the agricultural product sales integrated management system 100 .

On the other hand, sales or inventory management using the POS device 20, the barcode reader 30, the mobile terminal 40, etc. have been conventionally performed in a number of sales stores, and detailed descriptions thereof will be omitted. .

2 is a diagram schematically illustrating each configuration of the agricultural product sales integrated management system according to an embodiment of the present invention, and FIG. 3 is a diagram illustrating the configuration of a management item selection unit which is one configuration of the agricultural product sales integrated management system of FIG. , FIG. 4 is a diagram illustrating the configuration of a management item insertion unit, which is one configuration of the integrated agricultural product sales management system of FIG. 2 , and FIG. 5 is a view showing the overall interface of the agricultural product sales integrated management system according to an embodiment of the present invention.

2 to 5 , the agricultural product sales integrated management system 100 according to an embodiment of the present invention includes a management item selection unit 110 , a management item insertion unit 120 , and a display unit 130 . can be

Specifically, the management item selection unit 110 is a place where a plurality of management items 111 for managing the sale of agricultural products are listed, for this purpose, each management item may include agricultural product sales related information.

Here, the agricultural product sales related information may be input and transmitted to the POS device 20, the barcode recognizer 30, the mobile terminal 40, etc. It may be directly input into the integrated management system 100 .

More specifically, the management item 111 includes the vendor management item (A), the goods management item (B), the farmhouse information management item (C), the transaction history management item (D), the unit item (E), the date management item ( F) may be included.

Here, the vendor management item (A) is an item in which information on a plurality of vendors, for example, a first local food direct store, a second local food direct store, and a third local food direct store, is stored as an item in which information on a plurality of agricultural product sales stores is stored. When the desired management item is inserted into the insertion unit 120 , transaction details, sales status, etc. for each agricultural product sales store can be checked through the display unit 130 , and sales management can be performed using this.

When the management items described below are also inserted into the management item insertion unit 120 like the vendor management item 111, information on the corresponding item can be checked through the display unit 130, and sales can be managed using this. For the management items (B to F) described below, only the meanings of each management item are explained.

Goods management item (B) is an item in which product information of agricultural products or agricultural products-related products (hereinafter referred to as 'products for sale') sold by vendors is stored. Product classification item (B1) where information is stored, item item (B2) where information on sales items for sale products is stored, item of origin (B3) where country of origin information of sold products is stored, and taxation item (B4) where tax information on products sold is stored , commission rate item (B5) where the commission rate of the product sold is stored, freight rate item (B6) where the freight rate of the product sold is stored, unit price item (B7), etc. It may be composed of

In addition, the farmhouse information management item (C) is an item in which agricultural products or agricultural products-related product sales farmhouse information is stored, and may be configured to include a farmhouse classification information management item (C1) and a farmhouse detailed information management item (C2).

Here, the farmhouse classification information management item (C1) is a farmhouse item (C11) in which information on farms transacting with the seller is stored, a farmhouse group item (C12) in which information classified into a specific group to which the farmer belongs, is stored, and the farmhouse The farmhouse association item (C13), which stores information on the association to which the farmhouse belongs, the farmhouse gender item (C14) where the gender information of the farmer's operating subject is stored, the farmhouse age item (C15) where the age information of the farmer's operating subject is stored, the farmhouse operation type The farmhouse type item (C16) in which information on It may be configured to include a farmhouse basic fee item (C19) in which information on the sales commission rate is stored, a farmhouse basic fee item (C20) in which information on the farmhouse fare cost is stored, and the like.

In addition, the farmhouse detailed information management item (C2) includes the farmhouse phone number item (C21), in which information about the general or mobile phone number of the farmhouse is stored, the farmhouse email item (C22) where the farmhouse email information is stored, the farmhouse's zip code and It may be configured to include a farmhouse address item (C23) in which address information is stored, and a farmhouse business name item (C24) in which information on the business name of the farm is stored.

As for the farmhouse classification information management item (C1) and the farmhouse detailed information management item (C2) of the farmhouse information management item (C) as described above, the farmhouse classification information management item 111 is first inserted into the management item insertion unit (C1) and , when the detailed farmhouse information management item C2 is inserted, the display unit 130 may be configured to check detailed information of the farmhouse according to the farmhouse classification.

In addition, the transaction history management item (D) is an item in which transaction history information for products sold by the seller is stored, and the sales item (D1) in which sales volume information for the products sold is stored, and return status information for the products sold is stored. Return item (D2), sales amount item (D3) in which information on the status of sales amount for sale products is stored, commission item (D4) in which information on the status of commission on products sold is stored, and VAT amount in which information on the status of VAT on products sold is stored Item (D5), fare item (D6) in which fare status information for sale products is stored, and a settlement amount item (D7) in which margin information on sale products is stored may be configured to be included.

In addition, the unit item (E) is an item in which product unit information of agricultural products or agricultural products-related products is stored, and product unit information capable of measuring sales products such as weight, volume, and number such as kg, L, and number may be stored. .

In addition, the date management item F is an item in which transaction date information of products for sale is stored, and transaction date information may be stored in units of hours, days, months, years, and the like.

When a plurality of management items 111 as described above are selected in the management item selection unit 110 listed and inserted into the management item insertion unit 120 , the stored information for the corresponding item is displayed on the display unit 130 . It can be confirmed through exposure.

On the other hand, the plurality of management items 111 described above have been illustrated in detail to help understanding, but are not limited to those described and the item names of the management items 111 may be changed as long as their functions do not change, Although not described, other management items 111 may be additionally included according to settings, and the described management items 111 may not be included according to settings. Therefore, it should be understood that the above-described plurality of management items 111 are exemplary only.

In addition, the plurality of management items 111 may be distinguished by applying different colors to each item so that they can be easily distinguished from each other. For example, goods management item (B) is yellow, farm information management item (C) is blue, transaction history management item (D) is red, and unit item (E) or date management item (F) is green. will be.

Meanwhile, the management item 111 may be configured to further include a filter module 111a and an alignment module 111b, respectively, and a detailed description thereof will be described later.

The management item insertion unit 120 may provide a space into which the management items 111 listed in the management item selection unit 110 are selectively inserted. At this time, the management item insertion unit 120 may not separate the insertion space of the management item 111 , but preferably, as shown in FIG. 4 , the column insertion unit 121 , the row insertion unit 122 and the value It may be formed to divide the insertion space by including the insertion part 123 .

Specifically, the column inserting unit 121 is an insertion space for management items for displaying the result values indicated by the display unit 130 in units of columns, and the row inserting unit 122 is displayed by the display unit 130 . It may be an insertion space for management items to display the result value in row units.

That is, the management item 111 inserted by the column inserter 121 may represent the stored information in units of columns, and the management item 111 inserted by the row inserter 122 may represent the stored information in units of rows.

At this time, when an item to be checked is inserted by the value inserting unit 123 , the result value for the item in the value inserting unit 123 for the management item 111 in columns and rows is derived to the display unit 130 . can

For example, as shown in FIG. 5 , the date management item F is inserted by the column inserter 121 and the item item B2 and the unit item E are inserted by the row inserter 122, and then the value inserter When the sales item D1 is inserted at 123 , the display unit 130 displays the sales volume for each list of products for sale by column, while displaying the unit for each list of products for sale in units of rows.

In the same way as described above, if the management item 111 to form the table of contents is inserted in the column inserter 121 and the row inserter 122 and the result value to be checked is specified in the value inserter 123, the desired result is obtained. The value can be checked easily and quickly at a glance, making it easier to manage the products sold.

Meanwhile, the method of inserting the management item 111 into the management item insertion unit 120 may be configured such that both manual insertion and automatic insertion are possible.

Specifically, the manual method may be formed by directly dragging and dropping from the management item selection unit 110 to the management item insertion unit 120 . That is, the administrator can directly select the management item 111 from the management item selection unit 110 and arrange it at a desired location.

In addition, the automatic method may further include an insertion item input module 140 .

6 is a diagram illustrating an insertion item input module according to an embodiment of the present invention.

Referring to FIG. 6 , the insertion item input module 140 may include an input box 141 , an insertion position selection unit 142 , and an insertion determination module 143 .

The input box 141 may be provided to drag and drop management items of the management item selection unit 110 . Also, the insertion position selection unit 142 may be configured to select an insertion position of the management item 111 dragged and dropped into the input box 141 . Here, the insertion position may be set in advance within the management item insertion unit 120 and prepared to be inserted into the corresponding position by interworking.

The insertion determination module 143 is a module for determining whether to insert into the insertion position selected by the insertion position selection unit 142, and when an insertion is requested, the management item 111 dragged and dropped into the input box 141 to the selected insertion position. is inserted, and the insertion item input module 140 may be terminated when requesting to cancel the insertion.

By using the insertion item input module 140 as described above, a plurality of management items 111 can be more quickly and easily determined and automatically inserted, so that the result values for the plurality of management items 111 can be checked. could be more effective.

On the other hand, the management item 111 inserted into the management item insertion unit 120 by a manual or automatic method may be inserted and released so that the management item selection unit 110 is positioned again as well as inserted. This may be released again by drag & drop, or may be configured to automatically release by further including an inserted item release module (not shown).

The inserted item release module (not shown) is applied opposite to the inserted item input module 140, and when the inserted item release module (not shown) is opened, the currently inserted management item 111 is displayed in the input box 141, Among them, if a plurality of management items 111 to be released are selected and the release request button is pressed or directly dragged and dropped to the management item selection unit 110, the selected plurality of management items 111 may be released at once.

The display unit 130 may be configured to display the result value of agricultural products related information for the management item 111 selectively inserted into the management item insertion unit 120, and the display unit 130 only functions as a simple information marking function. , since all have been described in the description of the management item selection unit 110 and the management item insertion unit 120 , a detailed description thereof will be omitted.

Meanwhile, the management item 111 may be configured to further include a filter module 111a and an alignment module 111b as described above. This will be described with reference to FIGS. 7 and 9 .

7 is a diagram illustrating a filter module according to an embodiment of the present invention.

Referring to FIG. 7 , the filter module 111a is a module capable of selectively extracting agricultural product sales related information stored for each management item 111 by filtering, and the display unit 130 includes selective information by the filter module 111a. It may be configured to indicate only the result value for the optional information at the time of extraction.

For example, in the case of the date management item 111, if the filter module 111a is not used, all displayable units, that is, time units, daily units, monthly units, and year units, may all be expressed, but the filter module ( 111a) can be used to filter to display only specific units in units of hours, days, months, and years. If only the year unit is selected, only values corresponding to the year unit are displayed on the display unit 130 .

The filter module 111a may have a specific unit designated for each management item 111 or may be configured in a form in which a specific range is designated as a numerical value.

In this case, the filter module 111a may be configured to edit the extraction conditions through the filter module condition editing module 150 that is further included according to an embodiment of the present invention.

8A to 8E are diagrams illustrating in detail a filter module condition editing module according to an embodiment of the present invention.

8A to 8E , the filter module condition editing module 150 includes a filter editing field control unit 151, a filter operator changing unit 152, and a filter condition setting unit ( 153), a management item setting unit 154 and a condition value setting unit 155 may be included.

Specifically, in the filter module condition editing module 150, editing may be set by the filter editing field 150a, which is an editing space of the extraction conditions of the filter module 111a. Here, the filter edit column 150a may be calculated by operators such as And, or, Not, and the filter edit column 150a includes the management items 111, equal to, not equal to, less than, greater than, between, and between. It may be composed of a combination of various filter conditions such as an external value and an edit element of the condition value.

In this case, since the position of the input field for each edit element may be predetermined by setting, editing may be easily possible if only the applied value to the edit element is changed.

The filter module condition editing module 150 as described above includes a filter edit field control unit 151 , a filter operator change unit 152 , a filter condition setting unit 153 , a management item setting unit 154 , and a condition value setting unit 155 . ) may be included.

Here, the filter edit field control unit 151 adds and deletes the aforementioned filter edit field 150a, and the filter operator change unit 152 changes or edits the filter operator for operation between the plurality of filter edit fields 150a. It is possible, and the filter condition setting unit 153 is capable of setting filter conditions applied to the filter edit field 150a, and the management item setting unit 154 sets the management item 111 applied to the filter edit field 150a. This is possible, and the condition value setting unit 155 sets a condition value applied to the filter edit field 150a.

While adding or deleting the filter editing field 150a through the filter editing field adjusting unit 151 as described above, the filter operator changing unit 152, the filter condition setting unit 153, and the management item setting for each filter editing field 150a The extraction condition of the filter module 111a can be more easily adjusted by using the unit 154 and the condition value setting unit 155 .

9 is a view showing an example of an alignment module according to an embodiment of the present invention.

Referring to FIG. 9 , the sorting module 111b included in the management item 111 enables sorting in ascending or descending order according to criteria set for each stored agricultural product sales related information.

In this case, the alignment module 111b may be activated only when the management item 111 is inserted into the management item insertion unit 120 , and may be marked with an icon or the like so that it can be easily adjusted by clicking on it.

Meanwhile, the agricultural product sales integrated management system 100 according to an embodiment of the present invention may be configured to further include an information update module (not shown) and a layout adjustment module 170 .

This will be described with reference to FIGS. 10A and 10B .

10A is a view showing an item layout control unit of a data loading request module and a layout control module according to an embodiment of the present invention, and FIG. 10B is a result value layout control of the data loading request module and a layout control module according to an embodiment of the present invention It is a drawing showing wealth.

First, referring to FIG. 10A or FIG. 10B , an information update module (not shown) may be configured to update each management item 111 with the latest information according to changes in agricultural product sales related information.

At this time, the information update module (not shown) automatically updates the information to be reflected in the management item 111 immediately upon receiving information from the POS device 20 or the barcode reader 30 for inventory management or the mobile terminal 40, or the manager It may be configured to manually update according to a data loading request performed from .

Here, the data loading request of the information update module (not shown) may be performed from the data loading request module 160, and the data loading request module 160 is always exposed on the interface or is formed in a hidden pop-up form. As shown in Fig. 8, it may be formed in a form exposed by a specific instruction such as a right-click of a mouse.

In addition, referring to FIGS. 10A and 10B , the layout adjustment module 170 controls the management item layout adjustment unit 171 as shown in FIG. 10A and the result value layout adjustment unit 172 as illustrated in FIG. 10B . may be included.

Specifically, the management item layout control unit 171 may be configured to selectively or comprehensively adjust the layout of the management item 111 of the management item selection unit 110 or the management item insertion unit 120 .

Here, the layout control for the management item 111 may be formed so that all or part of the management item 111 can be hidden or can be adjusted to be visible for the hidden management item 111, the column inserter 121, the row The insertion unit 122 and the value insertion unit 123 can be adjusted to be hidden or visible.

In addition, it may be configured to change the name of the management item 111, or to adjust the layout, such as order alignment or size alignment.

The result value layout adjustment unit 172 is formed to selectively or comprehensively adjust detailed items for the result values according to the insertion of the management items 111 into the management item insertion unit 120 , and the detailed items are the total transaction volume or daily sales. It may be a subtotal for a product, and you can hide or show these details.

In addition, in the agricultural product sales integrated management system according to an embodiment of the present invention, referring to FIGS. 11 to 13B , the inquiry period setting module 180 for setting the inquiry period for the result value displayed on the display unit 130, the management item The selection unit 110, the management item insertion unit 120, and the management item 111 are set in the indicated state on the management item insertion unit 120 and the display unit 130, into which the management item 111 is inserted, and modularized as it is (hereinafter referred to as 'preset'). ) Preset setting module 190 and management item selection unit 110, management item insertion unit 120, and other document files such as Excel that can be recalled in a stored state later in the state displayed on the display unit 130 It may be configured to further include a document file extraction module 200 that can be extracted as .

Here, the preset setting module 190 includes a preset storage unit 191 for storing set presets, a preset table of contents 192 showing presets stored by the preset storage unit 191, and a preset table of contents 192 displayed on the display. It may be configured to include a preset fetching unit 193 for retrieving a corresponding preset when selecting a preset to be used, and a preset sharing unit 194 for sharing the preset stored by the preset storage 191 .

14 is a block diagram of the detailed configuration of the preset setting module shown in FIGS. 13A and 13 , and FIG. 15 is a diagram illustrating the preset setting module including the detailed configuration of FIG. 14 in detail.

14 and 15 , the preset storage unit 191 returns to the corresponding state when the management items 111 are inserted into the management item insertion unit 120 and information on the corresponding table of contents and values is displayed on the display unit 130 . This is for storing the preset, and when the preset is stored, the table of contents for the preset may be sorted according to the alignment value set in the preset table of contents unit 192 .

At this time, the preset storage unit 191 is configured to set a preset name to be stored when the preset is stored, and when the preset name is not set, the preset setting module 190 is configured to modify the preset name later. It may be configured to further include.

The preset retrieval unit 193 is provided to retrieve the preset in the state of the corresponding preset when a preset arranged in the preset table of contents 192 is selected, and the preset sharing unit 194 receives the presets arranged in the preset table of contents 192 It is prepared to be shared through a connected network such as a connected agricultural product sales integrated management system, SNS, or cloud system.

At this time, the preset sharing unit 194 may be formed to selectively apply the network network to be shared, and to cancel sharing or to change the rating for each preset to be shared, only those who have an ID or code that can access the rating can be confirmed. It may be possible to set it to

Hereinafter, with reference to FIG. 16, a method for integrated management of agricultural products sales according to an embodiment of the present invention will be described. Agricultural products sales integrated management method according to an embodiment of the present invention is to use the above-described integrated agricultural product sales management system 100, a detailed description will be omitted and will only look at a time series flow.

16 is a flowchart of a method for integrated management of agricultural products sales according to an embodiment of the present invention.

Referring to FIG. 16 , the method for integrated management of agricultural product sales according to an embodiment of the present invention includes the steps of selecting management items 111 to be displayed on the display unit 130 in the management item selection unit 110 ( S10 ), the selected management Inserting the items 111 into the column inserter, the row inserter, and the value inserter of the management item inserter 120 through drag & drop or the insert item input module 140, respectively (S20) and inserting the column For each management item inserted in the unit 121 and the row inserting unit 122 , the result value inserted into the value inserting unit 123 may be checked through the display unit 130 ( S30 ).

Although the embodiments of the present invention have been described above with reference to the accompanying drawings, those of ordinary skill in the art to which the present invention pertains can practice the present invention in other specific forms without changing the technical spirit or essential features of the present invention. you will be able to understand Accordingly, the embodiments described above are illustrative in all respects and not restrictive.

10: Sales management server
20: POS device
30: barcode reader
40: mobile terminal
100: Agricultural products sales integrated management system according to an embodiment of the present invention
105: agricultural products sales information database
110: management item selection unit
111: management item
111a: filter module
111b: sorting module
120: management item insertion unit
121: column insert
122: row insert
123: value insert
130: display unit
140: insert item input module
141: input field
142: insertion position selection unit
143: insertion decision module
150: filter module condition editing module
150a : filter edit field
151: filter edit field control unit
152: filter operator change part
153: filter condition setting unit
154: management item setting unit
155: condition value setting unit
160: data loading request module
170: layout control module
171: item layout control unit
172: result value layout control unit
180: inquiry period setting module
190: preset setting module
191: preset storage
192: Preset Table of Contents
193: preset loading unit
194: preset sharing unit
195 : Preset name correction unit
200: document file extraction module
A: Vendor management items
B: Goods management items
C: Farm information management items
C1 : Farmhouse classification information management item
C2: Farm details management item
D: Transaction history management item
E: unit item
F : Date management item

Claims (12)

a management item selection unit in which a plurality of management items each including information related to agricultural product sales for managing agricultural product sales are listed;
a management item insertion unit providing a space for selectively inserting management items listed in the management item selection unit; and
and a display unit for displaying the result value of agricultural product sales related information for the management item selectively inserted into the management item insertion unit,
The management items are
Vendor management items in which agricultural products or agricultural products-related product vendor information is stored;
Goods management items in which agricultural products or agricultural products related product information are stored;
Farm information management item in which agricultural products or agricultural products-related product sales farm information is stored;
a transaction history management item in which agricultural products or agricultural products-related product transaction history information is stored;
A unit item in which product unit information of agricultural products or agricultural products-related products is stored, and
Including date management items in which transaction date information of agricultural products or agricultural products-related products is stored.
It further includes a filter module that can selectively extract each stored agricultural product sales related information,
The display unit,
When the selective information is extracted by the filter module, only the result value for the selective information is displayed,
Agricultural products sales integrated management system,
a filter module condition editing module capable of editing the extraction condition of the filter module; and
Further comprising an insertion item input module for automatically inserting the insertion of the management item to the management item insertion unit,
The filter module condition editing module,
a filter editing field control unit for controlling addition and deletion of a filter editing field that is an editing space of an extraction condition of a filter module to be edited;
a filter operator change unit capable of changing or editing a filter operator for calculating the filter edit column;
a filter condition setting unit capable of setting a filter condition applied to the filter edit field;
A management item setting unit capable of setting management items applied to the filter edit column, and
and a condition value setting unit capable of setting a condition value for a filter condition of a management item applied to the filter edit field,
The insertion item input module,
an input box provided to drag and drop management items of the management item selection unit;
an insertion position selection unit for selecting an insertion position of the management item dragged and dropped into the input box; and
and an insertion determination module for determining whether to insert into the insertion position selected by the insertion position selection unit,
The insertion position selected through the insertion position selection unit is preset and interlocked within the management item insertion unit, and when insertion is requested through the insertion determination module, the management item dragged and dropped into the input box is selected in the management item insertion unit. Agricultural products sales integrated management system, characterized in that to be automatically inserted into the position for.
delete delete delete The method of claim 1,
Further comprising an information update module for updating changes in the agricultural product sales related information,
The information update module,
Agricultural product sales integrated management system, characterized in that it is configured to automatically update in real time according to changes in the agricultural product sales related information, or manually update according to a data loading request.
The method of claim 1,
Further comprising a layout control module for adjusting the layout of the agricultural product sales integration system,
The layout control module,
a management item layout control unit configured to selectively or comprehensively adjust the layout of the management item of the management item selection unit or the management item insertion unit; and
Agricultural product sales integrated management system including a result value layout adjusting unit configured to selectively or comprehensively adjust detailed items for a result value according to the management item insertion into the management item insertion unit.
The method of claim 1,
Insertion of the management item to the management item insertion unit,
Agricultural product sales integrated management system, characterized in that it is formed to be manually inserted in a direct drag & drop method from the management item selection unit to the management item insertion unit.
delete The method of claim 1,
The management item insertion unit,
a column insertion unit which is an insertion space for management items for displaying the result values displayed on the display unit in units of columns;
a row inserting unit which is an insertion space for management items for displaying the result value displayed by the display unit in a row unit; and
and a value inserter, which is a space for inserting result values for agricultural product sales information to be displayed in units of columns and rows through the column inserter and the row inserter.
The method of claim 1,
The management items are
Agricultural product sales integrated management system including a sorting module that can sort in ascending or descending order according to criteria set for each stored agricultural product sales related information.
The method of claim 1,
A preset setting module configured to insert a management item into the management item insertion unit and set it as indicated on the display unit, store the modularized preset as it is, load the stored preset state, and share the stored preset through a connected network network. Agricultural products sales integrated management system, including more.
As a method for integrated management of agricultural products sales using an integrated agricultural product sales management system that can customize management items,
selecting management items to be displayed on the display unit in the management item selection unit;
Inserting the selected management items into the column inserter, the row inserter, and the value inserter of the management item inserter through drag & drop or an insert item input module, respectively;
and checking the result value inserted into the value insertion unit for each management item inserted into the column insertion unit and the row insertion unit through a display unit,
The insertion item input module,
an input box provided to drag and drop management items of the management item selection unit;
an insertion position selection unit for selecting an insertion position of the management item dragged and dropped into the input box; and
An insertion determination module for determining whether to insert into the insertion position selected by the insertion position selection unit,
The insertion position selected through the insertion position selection unit is preset and interlocked within the management item insertion unit, and when insertion is requested through the insertion determination module, the management item dragged and dropped into the input box is selected in the management item insertion unit. Agricultural products sales integrated management method, characterized in that it is automatically inserted into the position for the.

Images