KR20030033575A - Management method for used car through network - Google Patents

Abstract

PURPOSE: A method for managing a secondhand car through the network is provided to manage the data with a database by making a general user input the data for the car register of the secondhand car on the Internet, and to understand the car and a state of the car by enabling a user to search a secondhand car through the Internet. CONSTITUTION: The user uses a local database in a PC or the database on a web by connecting to the PC or a database server(s210). It is judged that the user is a member(s220). In case of the member, the user inputs an ID and a password and advances to the next step(s230). If the inputted ID and the password are confirmed, a main screen is displayed(s240). When the user is not a member, the user registers to the web site(s310).

Description

Management method for used car through network}

The present invention relates to a method of managing a used car through a network such as the Internet or an intranet, and more particularly, in real time inventory of the used car by storing all data related to the used car in the sale of used cars, The present invention relates to a method for calculating the current location of a vehicle, arranging customer information, closing a purchase or sale, or repairing expenses related to the vehicle such that the calculation of additional costs is performed on a network in a manner convenient for a user's use environment.

In general, in buying and selling used cars, used cars are sold through used car dealerships. At this time, the used car sales agency is the vehicle to be delivered from the owner who requested the used car sale or the personal information of the client's client about the received car, and the details of the vehicle, that is, the type of vehicle, the year of the vehicle and the accident. The facts such as history, mileage, accidents, sales and purchase expenses, and vehicle resumes will be recorded. In order to record and allow vehicle buyers to look at the vehicle in more detail, an image, that is, a picture or a video of the vehicle is taken and provided.

In order to promote the vehicle sale, a vehicle or a vehicle is advertised through the mass media to promote the fact that the vehicle is sold. Done.

In this case, since the trading agency must record and manage the tracks of a number of vehicles, it is cumbersome to inquire the relevant vehicles from the thick file folder in order to search the desired vehicle on the documents. There is an inconvenience in that you can not easily query the vehicle you want.

In addition, sales agencies can easily manage used cars using a vehicle management program operated on a personal computer, instead of recording the vehicle tracks on documents. However, if you use such a program, you should know the operation method of the program in detail, and since such a program is operated only on one PC, you cannot check it directly on the network when you are away from the remote place. There is an inconvenience.

In case of managing a vehicle using a record or program of a vehicle using documents or images of the vehicle, it is necessary to fill in all the details of the used car to be sold or to input and manage the information on the program. This is a huge disadvantage, which is physically virtually impossible.

According to the present invention, since the conventional method for maintaining and managing a vehicle commissioned for sale to sell used cars has a lot of vehicle data on the vehicle, a vehicle that is created and managed as a document as described above can be used as a vehicle buyer or a seller. The problem that the vehicle buyer cannot easily find and compare the desired vehicle in the agency, the problem that it is impossible to manage a huge amount of data physically because the amount of data is huge when managing the vehicle as a management program on a personal computer and the management program Can only be used on a single PC, so it is not possible to view it on a remote network. as It is possible to manage this as a database and to allow anyone authorized in this network environment to access this data through a PC connected to a network environment such as the Internet or an intranet. The technical problem is to provide a way to easily grasp the status of, and to allow each agency to browse the data uploaded to the data server on the Web.

1 conceptually illustrates the relationship between a user and a provider operating a database server according to the present invention;

2 is a flowchart of a used car management method of the present invention.

3 is a view showing the flow of each item of this step of FIG.

※ Explanation of code about main part of drawing ※

100-1, 100-2, 100-3, ..., 100-n: user

110: internet or intranet 120: database server

130: database s310: registration step

s320: Input and inquiry step s330: Input and output status output step

s340: cash payment output step s350: previous registration step

s360: Help step

The present invention provides a database server, a database, and a used car management program for a person who intends to provide a used car management method according to the present invention on a network as a preparation step (hereinafter referred to as a "provider") in order to realize the above technical problem. In addition, a preparatory step is performed by installing the above program at a used car sales agency (hereinafter referred to as "the agency") that intends to use the used car management method prepared by the provider, and after the preparation step is completed, A server connection step of accessing a database server through a network of the Internet or an intranet from an employee of an agency, a used car sales client, a used car purchaser, or an agent of an agency; Member judging step to hide the membership; ID and password input step; And a preliminary step as a main screen offset step in which the main screen is floated, and after this preliminary step, a registered item as this step; Input and inquiry items; Entry / exit status items; Cashier items; Previously registered items; And by selecting and implementing each item consisting of help items to enable the management of used cars according to the present invention.

The database server in preparation above uses Sun Ultra 60, Apache Web Server, Internet Information Server (IIS) for Windows NT, or Netscape's Enterprise Server. And server build programs such as IBM's Lotus Domino server for AS / 400 customers.

In the above preparation database, Oracle, dBASE, DB2, Sybase, MSQL, MSQL, mSQL, OBC, Microsoft A database is built using a database building program such as MS Access, SQL Server, MDB, or Infomix.

The used car management program in the preparation step may be programmed as a client / server application development tool such as Delphi, Visual Basic, or VBA, Visual Basic for Applications (VBA).

In the above, communication through the network may be performed using a basic communication protocol such as TCP / IP.

In this step, the registration item is a member registration as a user, such as employees of the agency, second-hand car sales requester, second-hand car buyers or dealers of the agency; And registration of vehicles related to used cars such as vehicles, models, colors and models,

The above input and inquiry items are items that can be entered by the agency, the customer input and the customer's input, upload these items to the data server, or inquire these items,

The above items of entry / exit status are items that can be viewed by outputting purchase status, sales status, inventory status, sales status, store status and consignment status in relation to used car sales.

The above items for cash payment are items that can be viewed by outputting the status of income, expenditure and repair costs.

The above transfer registration item is an item that can be output by reading information such as transfer costs and necessary documents related to the transfer of used cars,

In addition, the help item is an item that can read the instruction manual and information on the program used in the used car management method according to the present invention.

In performing each of the above items, the registration item, the previous registration and the help item are made available to all users; Input and inquiry items, entry and exit status items, and cash payment items should be executed only by the employees of the agency among the users so that internal management of the agency is not leaked to the outside.

In the above-described input and correction of each item, a significant limit is placed on each member's qualification to prevent an error entry or intentional correction of data. In other words, used car sales client and used car purchaser can enter and modify only the member registration related to their personal information, and restrict only the viewing of the remaining items, and each employee of a specific agency It is possible to input and modify the data corresponding to the item, but to ensure that the security of the data, the accuracy and fidelity of the data by ensuring that only the PC installed with a program that implements the used car management method according to the present invention, Even when uploading data to a data server, only a limited person can upload in a PC installed with a program for realizing a used car management method according to the present invention to ensure the security, accuracy and fidelity of the data.

Hereinafter, with reference to the accompanying drawings will be described an embodiment of the present invention.

The following examples do not limit the scope of the present invention, and therefore, modified embodiments that do not depart from the spirit of the technical spirit of the present invention from the viewpoint of those skilled in the art do not depart from the scope of the present invention.

1 is a diagram conceptually showing a relationship between a user operating a database server and a provider according to the present invention, FIG. 2 is a flowchart illustrating a used car management method of the present invention, and FIG. It is a figure which shows the flow of an item.

First, after the above-described preparation step is made, the pre-owned car management method according to the present invention as a preliminary step (s200) is a user (100) such as an employee of an agency, a used car sales requester, a used car purchaser or an agent of an agency (100) -2, 100-3, ..., 100-n) PC 100-1 or database server 120 having installed thereon a program for realizing the method according to the present invention via a network 110 such as the Internet or an intranet. A server connection step (s210) for accessing to use the local database or the database 130 provided on the PC 100-1 itself on the hard disk;

Member judging step (s220) indicating whether the user is a member;

In the case of not a member, the user information is registered in the registration step (s310) of the registration item of the step (s300). In the case of a member, the user information is inputted so that the user can proceed to the step (s300) by entering an ID and password. Input and confirmation step (s230); And

If it is confirmed that the member above the main screen is displayed to open the step (s240), and if the input ID and password is different from the registered member member judging step to confirm the membership again ( The preliminary step (s200) is made by passing through s220.

After the above preliminary step (s200), this step (s300) consisting of the respective items can be performed as the present step (s300). Each of these items may be a procedure for only one item. An optional configuration may be used to carry out procedures for other items after carrying out the procedures for the items of.

Referring to each item of the present step (s300), the registration step (s310) for performing a registration item is a registration selection step (s311) for selecting a registration item as shown in Figure 3a;

User registration, such as employees of agency, used car sales client, prospective buyer of used car, or customer of agency; And a detailed item selection step (s312) of selecting detailed items such as registration of a vehicle related to a used vehicle such as a vehicle, a model, a color, and a year;

A data input determination step (s313) of selecting and determining whether to input data related to each of the selected sub-items;

A data input step (s314) of inputting data related to each selected sub-item when it is determined that the data is selected as the data input;

An upload selection step (s315) for selecting whether to upload the input data to the database 130 of the data server 120;

An end selection step (s316) of selecting whether to end the method according to the present invention when the upload is performed; And

If the end is selected above, the method according to the present invention is terminated.

In the above step, when selecting No in the data input determination step (s313), the upload selection step (s315), and the end selection step (s316), another item registration selection for selecting whether or not to register another item is selected. If the step (s317) is selected, and if yes is selected in the other item registration selection step (s317), the detailed item selection step (s312) is performed. Return to the screen offset step (s240).

As shown in FIG. 3B, an input and inquiry step for performing an input and an inquiry item among detailed items includes an input and inquiry selection step s321 for selecting an input and an inquiry item;

A detail selection step (s322) of selecting details to be input or uploaded from the vehicle, the customer and the customer;

A data input determination step (s323) of selecting and determining whether to input details in the selected detail item;

A data input step (s324) of inputting details when it is determined that the data is selected as the data input;

An upload selection step (s325) for selecting whether to upload the input data to the database 130 of the data server 120;

An end selection step (s326) of selecting whether or not to end the method according to the present invention when the upload is performed; And

When the end is selected above, the method according to the present invention is terminated.

In the above step, if No is selected in the data input determination step (s323), the inquiry step (s327) is performed through the inquiry step (s327), which enables the user to simply look up and view the details of the vehicle, the customer or the customer. Afterwards, another item input or inquiry selection step (s328) for selecting whether to input or inquire another item is performed; On the other hand, if a negative (No) is selected in the upload selection step (s325) and the end selection step (s326), the other item is entered or a search selection step (s328); If affirmative is selected in this other item input or query selection step (s328), the sub-item selection step (s322) is performed to select another sub-item, and if no (No) is selected, the main screen offset step (s240) is performed. Make sure you go back.

Among the detailed items, the input and output status output step (s330) for performing the input and output status items (s330) includes the input and output status output selection step (s331);

A detailed item selection step of selecting detailed items such as purchase status, sales status, stock status, sales status, store status and consignment status (s332);

A status output selection step of selecting whether to output the selected detail item (s333);

A status output step of outputting a current status when the current status output is selected (s334);

An end selection step (s335) of selecting whether to end after the current state is output; And

When the end is selected above, the method according to the present invention is terminated.

In the above step, in the case where no status is selected in the current status output selection step (s333) and the end selection step (s335), another item output selection step of selecting whether to output the current status by selecting another item (s336) ); In the case of selecting yes in the other item output selection step s336, the sub-item selection step s332 is performed. In case of selecting no, the main screen offset step s240 is returned.

The cashier outputting step (s340) of performing the cashier's item among the detailed items includes a cashier outputting selecting step (s341) of selecting the cashier's output as shown in FIG. 3D;

A detailed item selection step of selecting detailed status such as import status, expenditure status and repair cost status (s342);

A cashier output selecting step (s343) for selecting whether to output the selected detailed status;

A cashier output step (s344) for outputting the selected cashier when the output is selected;

An end selection step (s316) of selecting whether to end the method according to the present invention; And

When the end is selected above, the method according to the present invention is terminated.

In the above-described step, when the output unit output selection step (s343) and the end selection step (s316) is negative (No) is selected, another item selection step (s346) for selecting whether or not to output another item is passed through; If yes is selected in the other item registration selection step (s346), the detailed item selection step (s342) is performed. If no (No) is selected, the screen returns to the main screen offset step (s240). To help.

As shown in FIG. 3E, the previous registration step s350 for performing the previous registration item among the detailed items includes a previous registration output selection step s351 for selecting the previous registration item;

Transfer cost and document release step to display information such as transfer costs and necessary documents related to the transfer of used cars (s352);

A previous information output selection step (s353) for selecting whether to output the information floated above;

A previous information outputting step (s354) of outputting a previous cost and information when the yes is selected;

An end selection step (s316) of selecting whether to end the method according to the present invention; And

When the end is selected above, the method according to the present invention is terminated.

In the above step, in the case where the previous information output selection step (s353) is selected as a negative (No), the end of the selection step (s316), and if the negative selection (No) in the end selection step (s316), the main screen is off Return to step (s240).

Help step (s360) for performing a help topic of the detailed items are the help selection step (s361);

A description of the method according to the present invention displays a detailed description of a method for displaying a user's instruction and displaying other information (s362);

An end selection step (s363) of selecting whether or not to end the method according to the present invention; And

When the end is selected above, the method according to the present invention is terminated.

If no is selected in the end selection step (s363), it is possible to return to the main screen floating step (s240).

By performing each step according to each item as described above will be able to smoothly perform the used car management method through the network according to the present invention.

Used car management according to the present invention as described above, if you set a shared folder in one PC (PC), even if you install a program for realizing the method of the present invention in one PC so that multiple users can use the present invention It can be done by adding means.

Meanwhile, in each of the above steps, a used car sales client and a used car purchaser, in the step of performing a registration item (s310), grants the right to input and modify only the personal information of the user, thereby improving the security and fidelity of the data. It is possible to increase, and among the remaining items is limited to be carried out only for the step (s350) and the step (s360) of executing the previous registration item; Even if it is an employee of the sales office, in order to input data into the local database of the PC 100-1 where the program is installed by executing each item, only the PC 100-1 where the program is installed is allowed. In order to upload the data to 130), the PC 100-1 installed with the program can use only a limited user to upload the data, thereby limiting the security, accuracy and fidelity of the data.

As described above, a provider prepares a database server, a database, and a used car management program, and installs the program in the agency so that an employee of the agency, a used car sales client, a prospective buyer of a used car, or a trading partner of the agency uses the Internet or intranet. By inputting and managing the vehicle's vehicle through the network, it is easy to input, classify and search vast vehicle data, and even if the program is installed on one PC, In the connected PC, anyone who has been approved can use the method according to the present invention to grasp the current state of the used car, and can use the method according to the present invention in a window or Internet environment familiar to general users. Familiarize yourself with There is an effect that the present invention can be easily used without yoga, and there is an advantage that the method according to the present invention can be immediately performed in a window or the Internet environment even while the user is doing other work in his PC. It is effective to ensure the security, accuracy and fidelity of the data by restricting the use so that only a limited user can input, modify or upload data in the PC where the program that implements the method is implemented.

Claims (14)

In the management of used cars in connection with the sale of used cars, as a preparatory step, the provider prepares a database server, a database and a used car management program on the network, and the agency wants to use the used car management method provided by the provider. Prepare a preparatory step by installing a program, and after this preparatory step is completed, execute the database server through the Internet or intranet network at the agent of the agency, the client of used car sales, the buyer of used car or the client of the agency. A server connection step of accessing the server; Member judging step to hide the membership; ID and password input step; And a preliminary step as a main screen offset step in which the main screen is floated, and after this preliminary step, a registered item as this step; Input and inquiry items; Entry / exit status items; Cashier items; Previously registered items; And used car management method through the network, characterized in that by performing each item consisting of a help item. The system of claim 1, wherein the database server is a Sun Ultra 60, Apache Web Server, Internet Information Server (IIS) for Windows NT or Netscape's Enterprise Server or IBM's Lotus Domino Server. Used car management method through the network, characterized in that. The method of claim 1, wherein the database comprises Oracle, dBASE, DB2, Sybase, MSQL, mySQL, mSQL, OBC, Used car management method through a network, characterized in that Microsoft Access (MS Access), SQL Server (SQL Server) or Infomix (Infomix). The method of claim 1, wherein the used car management program is programmed by a client / server application development tool such as Delphi, Visual Basic, or Visual Basic for Applications (VBA). How to care for used cars through a network. The method according to claim 1, wherein the registration item, the previous registration, and the help item are made available to the user in executing each item in the above-described step; Input and inquiry items, incoming and outgoing status items and cash payment items can be carried out only by the employees of the agency, so that the internal management of the agency is not leaked to the outside. How to care for your car. The method according to claim 1, wherein the execution of said registration item selects a registration item (s311); Registration of a user of an agency, a used car sales client, a used car purchaser, or an agent of an agency; And a detailed item selection step (s312) of selecting detailed items such as registration of a vehicle related to a used vehicle such as a vehicle, a model, a color, and a year; A data input determination step (s313) of selecting and determining whether to input data related to each of the selected sub-items; A data input step (s314) of inputting data related to each selected sub-item when it is determined that the data is selected as the data input; An upload selection step (s315) for selecting whether to upload the input data to the database 130 of the data server 120; An end selection step (s316) of selecting whether to end the method according to the present invention when the upload is performed; And When the end is selected above, the method according to the invention ends. In the above step, when selecting No in the data input determination step (s313), the upload selection step (s315), and the end selection step (s316), another item registration selection for selecting whether or not to register another item is selected. If yes is selected in the other item registration selection step (s317), the detailed item selection step (s312) is performed. If negative is selected, the main item is selected. Used car management method through the network, characterized in that to return to the screen off step (s240). The method of claim 1, further comprising: an input and inquiry selection step (s321) in which execution of the input and inquiry items selects an input and inquiry item; A detail selection step (s322) of selecting details to be input or uploaded from a vehicle, a customer, and a customer; A data input determination step (s323) of selecting and determining whether to input details in the selected detail item; A data input step (s324) of inputting details when it is determined that the data is selected as the data input; An upload selection step (s325) for selecting whether to upload the input data to the database 130 of the data server 120; An end selection step (s326) of selecting whether or not to end the method according to the present invention when the upload is performed; And If the end is selected in the above it consists in terminating the method according to the invention, In the above step, if No is selected in the data input determination step (s323), the inquiry step (s327) is performed through the inquiry step (s327), which enables the user to simply look up and view the details of the vehicle, the customer or the customer. Afterwards, another item input or inquiry selection step (s328) for selecting whether to input or inquire another item is performed; On the other hand, if a negative (No) is selected in the upload selection step (s325) and the end selection step (s326), the other item is entered or a search selection step (s328); If affirmative is selected in this other item input or query selection step (s328), the sub-item selection step (s322) is performed to select another sub-item, and if no (No) is selected, the main screen offset step (s240) is performed. Used car management method through the network, characterized in that the return. 2. The method according to claim 1, wherein the execution of the entry / exit status items is performed by the input / output status output selection step (s331); A detailed item selection step of selecting detailed items such as purchase status, sales status, stock status, sales status, store status and consignment status (s332); A status output selection step of selecting whether to output the selected detail item (s333); A status output step of outputting a current status when the current status output is selected (s334); An end selection step (s335) of selecting whether to end after the current state is output; And If the end is selected in the above it consists in terminating the method according to the invention, In the above step, in the case where no status is selected in the current status output selection step (s333) and the end selection step (s335), another item output selection step of selecting whether to output the current status by selecting another item (s336) To go through; In the case of selecting yes in the other item output selection step (s336), the sub-item selection step (s332) is performed, and in case of selecting no (No), it is possible to return to the main screen offset step (s240). How to care for used cars through the network. 2. The method according to claim 1, wherein the execution of the cash entry item selects a cash payment output (s341); A detailed item selection step of selecting detailed status such as import status, expenditure status and repair cost status (s342); A cashier output selecting step (s343) for selecting whether to output the selected detailed status; A cashier output step (s344) for outputting the selected cashier when the output is selected; An end selection step (s316) of selecting whether to end the method according to the present invention; And If the end is selected in the above it consists in terminating the method according to the invention, In the above step, when the output unit output selection step (s343) and the end selection step (s316) is selected as a negative (No), another item selection step (s346) for selecting whether or not to output another item is passed through; If yes is selected in the other item registration selection step (s346), the detailed item selection step (s342) is performed. If no (No) is selected, the screen returns to the main screen offset step (s240). Used car management method through the network, characterized in that to enable. The method according to claim 1, wherein the execution of the previous registration item comprises: a previous registration output selection step (s351) of selecting a previous registration item; Transfer cost and document release step to display information such as transfer costs and necessary documents related to the transfer of used cars (s352); A previous information output selection step (s353) for selecting whether to output the information floated above; A previous information outputting step (s354) of outputting a previous cost and information when the yes is selected; An end selection step (s316) of selecting whether to end the method according to the present invention; And If the end is selected in the above it consists in terminating the method according to the invention, In the case where the previous information output selection step (s353) is selected as the above step, if the selection is made to No (S316), the selection goes through the end selection step (s316). Used car management method through the network, characterized in that to return to step (s240). The method according to any one of claims 5 to 7, wherein in the inputting and uploading step, the used car sales client and the used car purchaser can input and upload only the member registration related to their personal information and How to manage used cars through the network, characterized in that the restriction to only view. The method according to any one of claims 5 to 7, wherein uploading to the data server 120 in the uploading step is limited to uploading by a limited person in PC installed with a program for realizing a used car management method according to the present invention. Used car management method through the network, characterized in that to limit the possible. The method of claim 1, wherein the network is the Internet or an intranet. The method of claim 13, wherein the communication through the network uses a basic communication protocol such as TCP / IP.