CN106355260A - Online-booking tourist guide service providing method and data processing device - Google Patents

Online-booking tourist guide service providing method and data processing device Download PDF

Info

Publication number
CN106355260A
CN106355260A CN201610777723.1A CN201610777723A CN106355260A CN 106355260 A CN106355260 A CN 106355260A CN 201610777723 A CN201610777723 A CN 201610777723A CN 106355260 A CN106355260 A CN 106355260A
Authority
CN
China
Prior art keywords
guide
data
information
field
net
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
Application number
CN201610777723.1A
Other languages
Chinese (zh)
Inventor
邹春秋
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of CN106355260A publication Critical patent/CN106355260A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/02Reservations, e.g. for tickets, services or events
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/04Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/14Travel agencies

Abstract

The invention discloses an online-booking tourist guide service providing method and a data processing device and belongs to the fields of the tourism industry, internet and mobile internet. With the adoption of the internet, the mobile internet platform and websites, information of tourist guide personnel is searched, or online-booking tourist guide service is provided. Internet friends can query a tourism product package related to an online-booking tourist guide and a tourism grouping plan directed by the tourist guide through a website client and registers and joins the grouping plan, or a tourist uploads own tourism plan and tourist guide service demands which are confirmed by tourist guide registration internet friends. With the adoption of the method, a novel approach is provided for the tourist guide personnel to directly enter the tourism market, the tourist guide personnel are helped to improve the work enthusiasm, tourists can conveniently select satisfied tourist guides, the tourism experience of the tourists is improved, and development of the tourism industry and transformation and upgrading of the economy are promoted.

Description

A kind of about guide service of net provides method and data processing equipment
Technical field
The invention belongs to tourism industry and e-commerce field.
Background technology
Tourism guide practitioner always takes service in the enterprises of service in tourism such as travel agency in the past, is dispatched officers to visitor from enterprise Guide service is provided, each travel service enterprise is lower online or line on issue travelling products set meal, visitor participates in.The feelings of reality Condition is that the interests of the personal work quality, the experience of visitor and guide itself of guide do not have direct correlation, and the main body of association is for she The tourist corporation being located, disconnects or can not because the service quality of each guide practitioner is usually existed with the demand for experience of visitor Interact in real time and accepts the supervision in market with market, visitor often in various places is taken and force to do shopping or tour-guide's service quality is swum The unsatisfied situation of visitor happens occasionally, and the vast sea that the good service that another aspect high-quality guide provides is submerged in market is big It is impossible to show one's talent among sea.This can not transfer guide practitioner well and carry the long-pending of business's professional ability improvement service quality Polarity, also increases the employment cost of guide practitioner simultaneously, but the tune of policy of guide practitioner being obtained employment with country Whole relax, be directly entered guide service market and provide more channels and selection for guide practitioner.
Content of the invention
Problem to be solved by this invention is: inventing a kind of about guide service of net provides method and data processing equipment, should Invention is to set up net on the Internet, mobile Internet, the website of Internet of Things or platform (hereafter referred to collectively as website) about to conduct a sightseeing tour mould Block or directly set up a net about guide service platform, guide's entrance that guide passes through website client end proposes service Shen to website Related data and please be uploaded and handle corresponding entries, provide net about guide service through website staff examination & verification by backward visitor. Online friend can utilize network client devices such as by the Internet, mobile Internet, Internet of Things: pc machine, notebook, flat board electricity The online such as brain, mobile phone, domestic electric appliance, mobile unit accesses the website platform providing net about guide service or related content, In website, online friend is into or by data, the visitor checking everybody guide into the related pages of networking about guide wherein that navigate To the information of its service evaluation, qualification information and service content, release vacation packages product, design organized tour circuit, The offer plan guide that forms a team of plan of forming a team etc. the travelling route adding its release that can place an order applies for being confirmed to adding, or Person online friend oneself issues tour plan, throws single online friend by guide and confirms, visitor is paid dues, and goes on a tour the time to agreement, and visitor presses About ordering place concentrates report trip to accept net about guide service, and online friend can check the management order of oneself at any time, at any time to certainly Oneself Tourist Experience gives opinion including to the complaint servicing and evaluation;Guide enters line pipe by the work space of oneself to business Reason;Portal management personnel are managed to the related service of net about guide by background work space and control.This invention can be big Facilitate greatly visitor to be that the travelling autonomous selection guide of oneself lifts the Tourist Experience of oneself, just facilitate guide practitioner simultaneously Industry simultaneously improves guide and improves its services quality, the enthusiasm of lifting professional skill, promotes tourist market service level to enter one Step improves, and is conducive to the development of Tourism Economy and economic transition and upgrade, and its beneficial social economic effect is fairly obvious.This Bright it is achieved by following technical scheme.
A kind of about guide service of net provides method and data processing equipment, including a kind of e-commerce website more particularly, to Plant Tourism E-commerce website, comprise display module, the on-line payment and the 3rd of the information such as travelling route, tourist attractions, hotel Connection of square payment platform etc.;Described e-business website comprises server, Database Systems, client;Described client End is connected with server, Database Systems;
A kind of net about guide service provide method it is characterized in that: using modern times such as the Internet, mobile Internet, Internet of Things The network platform or website (hereafter referred to collectively as website) are engaged in guide's practitioner's relevant information and are collected or provide net about guide service; Or realized by below step: guide service supplier proposes the net about service request of guide by website or uploads Opening formality handled by related data;Or online friend can utilize network client devices by the Internet, mobile Internet, Internet of Things Comprise: the online such as pc machine, notebook, panel computer, mobile phone, domestic electric appliance, mobile unit accesses provides net about guide's clothes Business or the website of related content, check into about the conduct a sightseeing tour related pages of content of networking wherein into or by navigating in website Net about conduct a sightseeing tour correlation vacation packages product or organized tour circuit, the data of every guide service person, visitor to its guide take Other information on services, the net about guide plan of forming a team or its supporting clothes that the evaluation of business, the qualification information of guide, net about guide provide One of contents such as business information or their combination in any information, or the travelling route adding this guide to direct that can also place an order Form a team offer plan;Or online friend oneself issues tour plan, single online friend is thrown by guide and confirms;Or online friend checks management oneself Order, or the Tourist Experience of oneself is given opinion or guide service is complained or evaluates;Or guide is led to Cross its work space the business of oneself is managed;Or portal management personnel pass through background work space to net about guide's working Personnel and its related service are managed;
A kind of about guide service of net provides data processing equipment and about conducts a sightseeing tour correlation it is characterized in that being provided with net in website Data processing equipment comprises: guide's practitioner's information search device, the upload device of tourism guiding service data, tourism guiding service management Device, guide's relative information displaying device, net about guide service product display device, online friend add going on a tour of guide's release to form a team Plan places an order, and device, online friend issue plan making device of going on a tour, visitor's accounts of finance managing device, website fill to the management of tourism guiding service Put, website is to one of managing device etc. of guide or their combination in any;Or be provided with apparatus above related data is carried out The data processing equipment processing;Wherein:
Guide's practitioner's information search device comprises: guide's practitioner's net about guide service application device or guide Practitioner's information search device;
The upload device of tourism guiding service data comprises: the related travelling products set meal data uploading device of guide service and The upload device of the related sight spot of travelling products or the information data such as hotel or cuisines or leisure, guide's plan of forming a team upload device Deng one of or their combination in any;
Tourism guiding service managing device comprises: managing device that guide complains to visitor, the complaint to uncivil visitor for the guide Device, guide pay dues withdraw deposit one of device, guide's accounts of finance managing device, guide and webmaster mailbox ac equipment etc. or they Combination in any;
Guide's relative information displaying device comprises: guide's practitioner's qualification or working device for displaying information, services performance Device for displaying information, visitor evaluate one of exhibiting device, the identity information of guide or contact method exhibiting device etc. or they Combination in any:
Net about guide service product display device comprises: net about conduct a sightseeing tour correlation travelling products set meal exhibiting device, correlation Sight spot exhibiting device, hotel information exhibiting device, cuisines exhibiting device, leisure are travelled the group of device for displaying information, net about guide One of group's plan exhibiting device etc. or their combination in any;
Online friend adds the plan of forming a team of the going on a tour device that places an order that guide releases to comprise: online friend joins the Youth League the device that places an order;Visitor is to entering The order management device of group's application;Visitor complain device, visitor to one of evaluating apparatus etc. of service or guide practitioner or Their combination in any;
Online friend issues plan making device of going on a tour and comprises: visitor's plan of going on a tour is collected or display device, guide service supplier are thrown Single quotation display device, visitor confirm one of device etc. or their combination in any;
Website comprises to the managing device of tourism guiding service: website to guide practitioner's title examination or managing device or Website is to processing meanss that visitor complains etc.;
Website to guide managing device comprise: guide achievement statistical summaries device, market feedback statistic device, to guide Bonus data processing equipment, to guide punishment one of data processing equipment and the performs device to this this processing data etc. Or their combination in any;
Data processing equipment comprises one of the following or their combination in any: record guide practitioner start the business Register information table, the qualification file, picture information record table of application opening, it is used for storing this picture record table and corresponds to image data Storage folder, manage withdraw deposit request for data log, operating unit's finance of member and keep accounts log, the operating unit's wealth of entering an item of expenditure in the accounts Business fixed account balance data information record table, guide's practitioner's opening annual fee pay situation log, guide practitioner Opening service guarantees gold pay information record table, net about conduct a sightseeing tour travelling products set meal data logger or store this table correspond to picture Or the travelling products plan of forming a team of about conducting a sightseeing tour of the file of multimedia data, record sight spot and service product contingency table, net remembers The record table sight spot related to net about guide service or hotel details picture or multimedia data information log or with this table Corresponding picture multimedia document data record folder, guide practitioner are directed to the throwing forms data of guide's offer that consumer initiates Log, online friend add net about guide form a team application information be net about conduct a sightseeing tour order record table, visitor and guide calling information and Disposition data logger to complain related evidence picture data message log or store relevant evidence image data File, visitor remember to the service quality evaluation of net about guide to the evaluating data information record table of study of tourism itinerary production, visitor Record table, member's mailbox mail data logger, visitor member's finance keep accounts enter an item of expenditure in the accounts log, visitor member finance fixed account more than About conduct a sightseeing tour to the examination data table of every net about guides, the punishment log of net about guide, net in volume data message table, website Bonus log etc.;
Or show or be stored with site databases one of following data message or its any group at website client end Close data message: the Professional qualification of net about guide service person, work experience, evaluation information data and net are about conducted a sightseeing tour related trip Trip product package information data, plan information data of forming a team, the service content information data that it is provided that net is about conducted a sightseeing tour, net are about conducted a sightseeing tour Order data, online friend provide tour plan data;Single information data etc. is thrown in the plan of going on a tour that guide is directed to online friend.
Guide's its feature of practitioner's information search or be of the present invention: or in consumer user end or mobile device On display screen, setting guide's practitioner's relevant information typing window or interface or information are submitted function to or are provided with guide Practitioner's authentication information or related certificate or the picture of qualification file or the upload device of multi-medium data.
Online friend of the present invention checks management its feature of the order of oneself or is its content or comprises herein below One of or their combination in any: check order, cancel the order of oneself, edit the order of oneself, to the consumption of oneself order The evaluation of experience is shared with sense of reality, and client carries out complaining and the contents such as complaint and feedback to the unhappiness occurring in consumption.
Guide of the present invention is managed its feature by its work space or is its content to the business of oneself Or comprise one of herein below or their combination in any: guide service business datum uploads, processes visitor's complaint, complains not Civilized visitor, accounts of finance management exchange mailbox, order management etc. with webmaster or visitor;Wherein:
Guide service business datum uploads and comprises one of the following or their combination in any: vacation packages product data Upload, the vacation packages product information to upload are safeguarded upper to edit-modify, the sight spot related to product or hotel information Edit-modify, the upload of plan of forming a team for set meal product passed or safeguarded or edit-modify, plan relevant information of forming a team safeguarded Show and browse;
Process visitor and complain and comprise one of the following or their combination in any: display complains related content, to complaint People replys apology, explains the situation to portal management side or appeal or transfer accounts reimbursement etc. to complainant;Or pass through guider Navigation enters the complaint handling page or interface;
Accounts of finance management comprises one of the following or their combination in any: transaction details record or query display, Account balance record or query display, pay dues, withdraw deposit and transfer accounts;
Order management comprises one of the following or their combination in any: examination & verification process visitor join the Youth League application, check group Group's plan visitor's registration situation, competition for orders etc..
Portal management personnel of the present invention are about conducted a sightseeing tour to net practitioner and its related industry by background work space Business is managed its feature or is to comprise one of the following or their combination in any: guides's opening application examination & verification, The online various administration fee of member carrying out service pay examination & verification, process member's account charging application, process member withdraws deposit Shen Please, the examination & verification of the examination & verification of travelling products data, sight spot and travelling products contingency table, plan examination & verification of forming a team, the management of member's mailbox, place Reason consumer complains, processes the complaint to uncivil visitor, website to the management conducted a sightseeing tour and checking device etc..
Product online is issued after running, and online friend passes through the Internet, mobile Internet accesses, log in related web site platform, leads to Crossing navigation and enter or be directly entered net and about navigating homepage, checking and the vacation packages product conducting a sightseeing tour related, selection guide's release The tourism plan of forming a team, throw single add it to be responsible for the tourist group conducted a sightseeing tour, or online friend uploads tour plan and the guide service of oneself Demand, guide throws single online friend and confirms, pays dues as shown in Figure 1 by the both sides that about go on a journey its schematic flow sheet of honouring an agreement.
Brief description
Fig. 1 is the schematic flow sheet of online friend's net about guide of the present invention.
Fig. 2 is that net is about conducted a sightseeing tour the homepage composition figure of module.
Fig. 3 is that net is about conducted a sightseeing tour the homepage designing view of module.
Fig. 4 shows interface composition figure for vacation packages product detail information.
Fig. 5 shows interface layout drawing for vacation packages product detail information.
Fig. 6 is that application adds the application of vacation packages product group travel plan to submit boundary's page Design view to.
Fig. 7 forms figure for the order management page
Fig. 8 shows interface order brief information Exhibition Design view for order
Specific embodiment
The following is the specific embodiment of the present invention and combine accompanying drawing technical scheme is further described, with It is easy to more clearly illustrate the spirit of the present invention, but the invention is not limited in these embodiments.
Embodiment
Initially set up the Database Systems supporting with platform, then each page of design platform or interface, in data base Set up and set up associated picture, the literary composition of multi-medium data storage including at least with following table in interior tables of data in the server Part presss from both sides.The membership information log (record common visitor with guide identity information) of first entitled u, comprise following field uid, Na, pn, cname, c, tel, qq, sl, p, pask, pans, flag, f1, oks, oksp, ma, face, mad etc., wherein uid It is this table major key for record member logging in id;Na is used for recording the name information of member;Pn is used for recording the user name letter of member Breath;Cname is used for recording its identity document name information;C is used for recording its identification card number information;Tel is used for record meeting Member's contact information such as telephone number;Qq is used for recording the social account account such as No. qq of member;Sl is used for record meeting The social platform such as WeChat accounts of member;P is used for recording the login password of member;Pask is used for record and gives password during password for change Prompting problem pans is used for recording answer of Security Question etc.;The identity category information that flag is used for recording member is divided into trip Objective consumer member and ISP guide member;F1 is used for recording the management qualification whether member opens guide service, 0 table Not open-minded, 1 table is open-minded, and 2 expressions are not passed through to audit;Oks is used for identifying outstanding guides, and 1 represents it is that 0 table is not;oksp Field is used for recording the weighted value of guide's sequence;Ma field is used for recording the title of Third-party payment platform and the account of this member Information;Face field is used for recording this member's head portrait address information, and other fields can be used for recording the other identity data of client Information or other relevant information etc. are set up a fu file simultaneously in the server and are used for storing member's head image data;
The table of second entitled dp is used for record guide practitioner and starts the business register information table, comprises data below note Record field: dpid, uid, dpname, addr, tel, uname, c, d, acc, f1, fc etc., wherein dpid field be used for record from It is this table major key that industry manages registration number;Uid field is used for record guide's member registration number and the corresponding pass of uid field in u table Connection;Dpname field is used for recording the service organization of tourist guide or the title of enterprise of service in tourism;Addr field is used for recording Shen Ask someone address;Tel field is used for writing task contact phone number;Uname field is used for writing task name of contact person;c Field is used for recording the main business range content information that applicant is managed;D field is used for recording applicant's qualification and work Biographic information;Acc field is used for recording this registration unit or guide in third-party financial account, for website platform and this warp The financial transaction that battalion member conducts a sightseeing tour, account is provided when application is started the business in the lump by client;F1 field is opened for record Industry status indicator, be divided into 0,1,2,3 four kind of state, 0 represents that new application etc. is pending, and 1 represents and allows opening, 2 tables by examination & verification Undesirable do not pass through examination & verification, 3 tables are forced closed;Fc field is used for writing task personnel's audit opinion explanation.
3rd entitled dpphote table is used for submitted to the qualification pictorial information of record application opening, comprises data below Record field: dppid, dpid, pname, addr, c, wherein this table of dppid field serial number this table major key;Dpid field is used for Record the managerial setup registered account number of this guide;Pname field is used for recording the title of this picture;Addr field is used for recording this This picture storage address in the server;C field is used for recording the explanation of this qualification file.Arrange one in the server simultaneously The file of individual entitled dpw is used for recording the corresponding image data of this table record.
The table of the 4th entitled pick, withdraws deposit request for data for recording member, comprises data below record field: Pkid, uid, dpid, c, q, k, uptime, f, wherein pkid field are used for serial number this table master of one record of minute book table Key;Uid field is used for record and submits applicant member's account number to, corresponding to the uid field of u table;Dpid field is withdrawn deposit for record The managerial setup account number of application indication, corresponding to the dpid field of dp table;C field is used for recording application documents content and explanation;q Field is used for recording application and withdraws deposit number;K field is used for whether record has paper document to be sent to by line under type, is divided into and sending Reach, be no sent to two kinds of situations;Uptime field is used for record application time submission date;F field is used for recording applicant member Classification, is divided into ordinary consumer member to be represented with 1, and provides the operator member such as guides of service to be represented with 2.
5th entitled uinto table is used for recording consumer's visitor member's finance and keeps accounts log of entering an item of expenditure in the accounts, and comprises following number According to record field: inid, uid, in, ain, atime, out, uptime, c, wherein inid field are used for one note of minute book table Serial number this table major key of record;Uid field is used for recording the account No. id of this consumer member, and correspondence is associated with the uid word of u table Section;In field is used for recording the data that formally keeps accounts of this member;When ain consumer supplements with money, number is submitted in application to;Atime submits to and fills The time of value application;Out field is used for recording the expenditure data of formally entering an item of expenditure in the accounts of this member;Uptime field is used for recording and formally goes out The time of origin of the data that keeps accounts;C field is used for the explanation to this business for the record.
6th entitled ubalance table is used for recording the regular balance data information of consumer's visitor's accounts of finance, comprise with Lower data entry fields: ubid, uid, bal, dyear, uptime, wherein ubid field are used for the sequence of one record of minute book table Number be this table major key;Uid field is used for recording the account number of this consumer member, and correspondence is associated with the uid field of u table;Bal field For recording this period account balance of this member;Dyear field is used for recording this record corresponding time period;Uptime word Section is used for recording this record time of origin;
7th entitled dpinto table is used for recording managerial setup finance and keeps accounts log of entering an item of expenditure in the accounts, and comprises data below record Field: inid, dpid, in, out, uptime, y, m, c, wherein inid field are used for the serial number of one record of minute book table originally Table major key;Dpid field is used for recording the operation id of this operation member, and correspondence is associated with the dpid field of dp table;In field is used In the data that keeps accounts recording this operation member;Out field is used for recording the expenditure data of this operation member;Uptime field is used for The time of origin of minute book data;Y field record data submits the affiliated time to;M field is used for belonging to record data submission Month;C field is used for the explanation to this business for the record.
8th entitled balance table is used for recording managerial setup finance fixed account balance data information and (monthly records Once), comprise data below record field: dpbid, dpid, bal, dyear, dmonth, uptime, wherein dpbid field is used Serial number this table major key in one record of minute book table;Dpid field is used for recording the operation id of this operation member, corresponding It is associated with the dpid field of dp table;Bal field is used for recording this month account balance of this operation member;Dyear field is used for recording This record corresponding time;Dmonth field is used for recording this record corresponding concrete time period;Uptime field Record time of origin for recording this;
9th entitled yfee table is used for recording tourist service mechanism practitioner's opening annual fee of conducting a sightseeing tour and pays situation, bag Record field containing data below: yfid, dpid, m0, m1, fyear, uptime, upuid, c etc., wherein yfid field references are originally Serial number this table major key of one record of table;Dpid field is used for the registration of the operating unit corresponding to minute book bar payment record Account number id;I.e. corresponding product is associated with the dpid field of dp table;M0 field is used for the annual fee number through appraising and deciding for the record;M1 field is used for Record is paid dues, and people is actual to pay number;Fyear field is used for record and pays dues corresponding year;Uptime field is used for recording reality Pay dues time of origin in border;Upuid field is used for recording member's account number of the actual people that pays dues;C field is used for record case explanation.
Tenth entitled qfee table is used for recording tourist service mechanism practitioner's opening service guarantees gold of conducting a sightseeing tour and pays Information, comprises data below record field: qid, dpid, m0, m1, uptime, upuid, c: wherein this table of qid field references one Serial number this table major key of bar record;Dpid field is used for account number id of the operating unit corresponding to minute book bar payment record; I.e. corresponding product is associated with the dpid field of dp table;M0 field is used for recording that this operating unit appraises and decides should pay guarantee fund's number;m1 Field is used for recording the actual guarantee fund's number paid of this operating unit;Uptime field be used for record actual paying when Between;Upuid field is used for recording the member's account number i.e. uid field corresponding to u table of actual paying people;C field is used for remembering Record relevant situation explanation.
11st entitled tourgoods table is used for recording vacation packages product data, simultaneously in the server setting with This table corresponds to picture, multimedia data storage folder tourgoodsp file, comprises following in tourgoods table Data entry fields: id, content, content1, paddr, guideid1, guideid2, guideid3, guideid4, f, Sort, uptime, upid, wherein id are used for recording serial number this table major key of travelling products;Content is used for record tourism and produces The content introduction of product;Content1 is used for recording this travelling products brief textual introduction;Paddr is used for minute book travelling products The picture address at representative sight spot, its image data by being stored in tourgoodsp file when system uploads;guideid1、 Guideid2, guideid3, guideid4 are used for member's account number id of the guide of minute book travelling products, can record altogether many Name guides, wherein guideid1 is director;F is used for recording the examination & verification whether this product has passed through portal management side, and 0 Table is not audited, and 1 table passes through examination & verification, and 2 tables do not pass through to audit;Sort is used for recording the retrieval classification of this vacation packages product, with master Page navigation classification is corresponding, is such as divided into classification herein: Southeast Asia tourism, Northern Europe tourism, island trip, Canada of the U.S., the northern part of the country The big class such as honourable, careless garden landscape, western plateau, the south of the lower reaches of the Yangtze River, modern metropolitan cities, the south of Fujian Province scene, red tourism, Peasants Joy, classification Can be arranged in typing by the member submitting data to, also can be arranged by auditor;Uptime is used for recording this product Design uplink time, upid is used for recording upload personnel No. id.
12nd entitled tourspot table is used for recording sight spot and travelling products contingency table, comprises data below record word Section: tsid, tgoodsid, spotid, upid, uptime, f, wherein tsid are serial number this table major key of one record of this table, Tgoodsid is used for No. id of vacation packages product in one record of record, associates corresponding to the id field in tourgoods table, Spotid is used for recording No. id of sight spot or hotel, and corresponding to the spotid field in view_spot table, upid field is used for remembering No. id uid field corresponding in u table of record upload personnel, uptime field is used for recording the uplink time of this product, and f is used for remembering Record the examination & verification whether this record has passed through portal management side, 0 table is not audited, and 1 table passes through examination & verification, 2 tables do not pass through to audit.
13rd entitled tourteam table is used for recording travelling products and forms a team planning chart, comprises data below record word Section: ttid, f, fd, c1, c2, goodsid, uid1, uid2, uid3, q, q1, process, t, tot, toaddr, tocity, Cost0, cost1, cost2, ins, upid, uptime, k, flag, the wherein serial number of one record of this table of ttid field references This table major key;F field record is formed a team plan classification, is divided into guide to initiate class and is represented with 1, consumer visitor initiates class and represented with 2; Fd field is used for record and is divided into for the service need status of consumer's initiation class: it is not required to competition for orders such as guide's initiation class and represented with 0, During 1 expression competition for orders is carried out, 2 expression competition for orders terminate;C1 field is formed a team explanatory note for record, and such as this plan of forming a team is by disappearing The person of expense initiates, then can illustrate that tourism route that this plan comprised and the lodging of sight spot hotel perhaps require in having dinner etc. here; C2 is used for record to comprised component content of offering: such as whether comprising guide service expense, admission fee, hotel expense, transportation expenses, use Dinner cost etc.;Goodsid field is used for recording this corresponding vacation packages product id of plan that forms a team corresponding to table tourgoods table id Field;Uid1, uid2, uid3 field be used for recording this plan of forming a team the member id wherein uid1 serving as guide be used for recording negative Duty people member id;Q field is used for recording visitor's number that this group appraises and decides;The number of the actual application of q1 field record;Process word Section is formed a team process status for record, and 0 table is formed a team in carrying out, and 1 table is formed a team end closing;T field is used for recording the one-tenth of this plan Row planned time section;Tot field is used for recording the rows of concrete set time of this plan;Toaddr field is used for recording this The initial assemble place of setting out formed a team;Tocity field is used for recording the assemble place place city setting out initial this time formed a team City;Cost0 field is used for record guide's promotion price;Cost1 field is used for recording the price data of organized tour of this time conducting a sightseeing tour; Cost2 field is used for recording the bid price data of this consumer's organized tour;Ins field is used for recording this organized tour The insurance product information being comprised;Upid field is used for recording the uid corresponding to u table for member's account number id of this plan upload of forming a team Field;Uptime field is used for recording the time that this plan of forming a team uploads;K field is used for recording price category, be divided into common fare, Promotion price;Flag field is used for recording whether the plan of this time forming a team audits mark by webmaster, and 0 represents unexamined, and 1 table passes through to examine Core, 2 tables do not pass through to audit.
14th entitled view_spot table is used for recording sight spot and hotel and its affiliated leisure, cuisines details Picture, multimedia data information log arrange picture multimedia document data record corresponding with this table simultaneously in the server Folder view_spotp file, tables of data comprises data below record field: spotid, sname, content, paddr, cy, Sen, si, addr, uptime, upid, wherein spotid are one LSN of this table is this table major key, and shame field is scape Point or the title in hotel, content field is the character introduction in this sight spot or hotel, and paddr field is this sight spot or hotel Image picture storage address, its image data is stored in view_spotp file when system uploads;Cy field is used for remembering The country origin that record sight spot is located, sen field is used for recording the province (municipality directly under the Central Government etc.) at sight spot place, and si field is used for recording sight spot place Prefecture-level city, addr field is used for recording the specific number at sight spot place, and uptime field is used for recording uplink time, Upid field is used for recording upload personnel No. id.
15th entitled ttdrop table is used for the throwing that record guide practitioner is directed to guide's offer that consumer initiates Forms data, comprises data below record field: tdid, ttid, upuid, q, c, uptime, f, and wherein tdid field is used for recording Serial number this table major key of this table this data record;Ttid field is used for minute book bar and throws the guide service corresponding to unirecord The sequence number of offer (plan of forming a team);It is No. uid that upuid field be used for record to throw single member's account number;Q field is used for recording Throw single quotation;C field is used for record and throws the service content included in single quotation;Uptime field is used for record and throws single time;f Field is used for record and throws single state, is divided into: wait pending, throw single success, throw three kinds of single failure.
16th entitled team_apply table is used for recording online friend and adds tourist group to form a team application information, and that is, net is about conducted a sightseeing tour The order record table of module, comprise data below record field: taid, ttid, goodsid, upuid, pname, ptel, Psex, page, q, mq, wq, orf, cf, uptime, accept, c, s1, s2, s3, etc. field, wherein taid field is used for recording Serial number this table major key of this data record, ttid field is used for the plan of forming a team corresponding to minute book data record Sequence number in tourteam table, the sequence number i.e. correspondence that goodsid field is used for recording corresponding vacation packages product is associated with The id field of tourgoods table, upuid field is used for record and submits to member's account number of applicant to correspond to u table uid field, Pname field is used for the name that applicant submitted in record, and ptel field is used for the telephone number such as mobile phone that applicant submitted in record Number, psex field is used for the sex that applicant submitted in record, and page field is used for the age that applicant submitted in record, q field For recording the apllied number of joining the Youth League of the application, mq field is used for recording the apllied male's number of joining the Youth League of the application, wq word Section be used for recording the apllied women number of joining the Youth League of the application, orf field be used for minute book order status be divided into normally, need supplement Data two states, cf field be used for minute book order consumption status the to be consumed, consumption such as be divided into carry out in, consumption end three Kind, uptime field is used for recording the time that order (application of joining the Youth League) is submitted to, and accept field is used for recording connecing of this order By state, be divided into pending, accept, abandoned three kinds of states, c field is used for recording the explanation that guide audit to order anticipates See, sl field is used for recording client and should pay the fees volume, and s2 field is used for record intersection number volume, when s3 field is used for registration-cancellation order Return number.
17th entitled team_applyp table is used for recording online friend and adds tourist group to form a team application composition of personnel information note Record, comprise data below record field: tapid, taid, name, sex, age, date, cname, code, tel, addr, Htel, wsort, wherein tapid field are used for serial number this table major key of minute book bar record, and taid is used for minute book bar record One LSN correspondence of be under the jurisdiction of team_apply table is associated with the taid field of this table, and name field is used for record trip Different surname name, sex field is used for recording visitor's sex, and age field is used for recording visitor's age, and date field is used for recording visitor and Life year month information, cname field is used for recording visitor's identity document title, and code field is used for recording visitor's identity card piece number Code, tel field is used for recording visitor's telephone number, and addr field is used for recording visitor address, htel field record visitor household Telephone number, wsort field record visitor's occupational information.
18th entitled complained table is used for recording guides, visitor's calling information and disposition data note Record, comprise data below record field: id, content, title, appeal, upuid, utel, uptime, tuid, tutel, toteamid、tanswer1、tanswer2、ttel、ub1、ub2、mcont、proof、sort、f1、f2、f3、qb.Wherein id word Section is for serial number this table major key of minute book bar record;Content field is used for the particular content that record is complained;Title word Section is used for recording complaint content title;Appeal field is used for recording the demand of complainant;Upuid field is used for recording complainant Member account corresponds to the uid field of u table;Utel field is used for recording complainant's telephone number;Uptime field is used for recording The complaint time;Tuid field is used for recording the uid field corresponding to u table for member's account number of defendant;Tutel field is used for remembering Record defendant's telephone number;Toteamid field is used for recording complained plan sequence number of forming a team;Tanswer1 field is used for Record defendant replys the content of complainant;Tanswer2 is used for recording defendant to portal management side's complaint content; Ttel field is used for recording complainant's telephone number;Ub1 field is used for recording complainant No satisfaction;Ub2 field is used for recording whether complainant is satisfied with to portal management side's reply handling suggestion;Mcont field is used for remembering Record portal management side handling suggestion content;Proof field is used for recording whether complaint content have submitted evidence, and 0 table is not submitted to Evidence, 1 table has been filed on evidence;Sort field is used for record and complains the classes such as classification is divided into visitor to complain, guides complains;F1 word Section is used for recording the whether processed complaint response complainant of defendant;0 represents untreated, the 1 processed reply complainant of expression; F2 field is used for recording whether webmaster is processed to this complaint, and 0 represents untreated, the 1 processed reply complainant of expression And defendant;F3 field is used for recording this complains whether process terminates, and 0 table reason is processed in carrying out, and 1 expression process terminates; Qb field is used for processing the fund number that when complaining, defendant pays or reimbursement number.
19th entitled cpproof table is used for recording the picture evidence deposit position information submitted to when visitor complains, bag Record field containing data below: id, dsid, paddr, the file simultaneously setting up an entitled proofp in the server is used for The evidence picture data that record is submitted to when complaining, wherein id field are used for serial number this table major key of minute book bar record, dsid Field is used for recording this record and belongs to which bar is complained, that is, the complaints sequence number being subordinate to corresponding to the id field of complained table, Paddr field is used for the address information of taking of evidence picture.
20th entitled assess table is used for recording the evaluating data information to study of tourism itinerary production for the visitor, comprises following Data entry fields: serial number this table master of this record of id, goodsid, c, k, uid, uptime, f, wherein id field record Key, the sequence number of goodsid field record corresponding vacation packages product corresponds to the id field of tourgoods table, represents and is done Evaluation made for this vacation packages product, c field is used for records appraisal content information, and k field is used for recording Opinion rating is divided into: fine, good, passable, poor, very poor, uid is used for the uid corresponding to u table for member's account number of records appraisal people Field, uptime field is used for the time of records appraisal content uploading, and f field is used for recording whether this valency has already been through net The examination of pipe, 0 table is unexamined, and 1 table passes through to examine, 2 tables could not be by examining.
21st entitled atourserve table is used for recording the service quality evaluation to guide for the visitor, comprises following number According to record field: this table of serial number of this record of id, taid, uname, f, c, uid, uptime, k, wherein id field record Major key;It is which time to consume the i.e. order number made based on that taid field is used for recording consumer and making an appraisal, and correspondence is associated with table The taid field of team_apply table;Uname field is used for records appraisal people's Real Name;F field is used for recording this evaluation Grade, be for example divided into, qualified, differ from three kinds;C field is used for recording this specific evaluation content;Uid field is used for minute book Member's account number correspondence of secondary appraiser is associated with the uid field of table u table;When uptime field is used for the generation recording this evaluation Between, automatically generated by system;K field is used for recording this and evaluates whether effectively, to determine, be divided into 0 table after being audited by webmaster personnel Do not audit, 1 table confirms the validity through examination & verification, and 2 tables are invalid through examination and determination.
22nd entitled cmoney table is used for recording website consumer payment tables of data, comprises data below record word Section: serial number this table major key of this record of id, taid, q, uid, uptime, c, wherein id field record;Taid field is used for The order number of record consumer, taid correspondence is associated with the taid field of table team_apply table;Q field is used for recording this time to be handed over Take the amount of money;Uid field is used for recording the corresponding uid field being associated with table u table of member's account number of this payer, uptime field For recording the time of origin that this is paid dues, automatically generated by system;C field is for recording the brief description that this is paid dues.
23rd entitled adv1 table is used for recording the advertising pictures information that net is about conducted a sightseeing tour at homepage title position, comprises Data below record field: serial number this table major key of this record of aid, paddr, uptime, c, wherein aid field record, This advertising pictures address information of paddr field record, this advertising pictures uplink time of uptime field record, c field is remembered Record comment.
24th entitled adv2 table is used for recording net and about conducts a sightseeing tour the extension of advertisement at homepage title position or in detail Information, comprises data below record field: adid, aid, paddr, uptime, c, wherein adid field record this record Serial number this table major key, aid field is used for recording the aid word that affiliated title advertising pictures sequence number correspondence is associated with table adv1 table Section, paddr field is used for recordable picture address information, this advertising pictures uplink time of uptime field record, c field record Comment.
Above adv1, adv2 tables of data shares the server folder of an entitled advp to store picture, multimedia number According to.
25th entitled tletter table is used for recording mail data in member's mailbox, comprises data below record word Section: id, touid, fromuid, content, uptime, lid, s, f, read, ans, wherein id field are used for recording this note Serial number this table major key of record;Touid field is used for recording the uid field that this letter addressee's register account number corresponds to u table; Fromuid field is used for recording the uid field that addresser's registration account number corresponds to u table, and 1 expression is transmitted by webmaster;Content word Section is used for recording communications content information;Uptime field is used for recording transmitting time;Whether lid field is used for recording this mail and is Reply part, this letter in reply of the digitized representation representated by n is the id of the former mail being directed to, 0 represents it is initial first envelope;S field is used for Record mail classification, is divided into consumer's letter, guide's letter, webmaster to write letters three classes;Whether f field record communications content passes through Webmaster is audited, and 0 table is unexamined, and 1 table passes through examination & verification, and 2 tables do not pass through to audit;Whether read field record reads, and 0 table mail is not read Read, 1 table was read;Ans field is used for recording whether this mail has responded to, and 0 table is not replied, and 1 table is replied.
26th entitled transfer table is used for recording the transfer information record of webmaster approval, comprises data below note Record field: id, udid, f, q, acc, co, wid, uptime, wherein id field are used for recording serial number this table master of this record Key;The registration account number of this consumer of udid field record member or trade company's registration number of operating service class member, f field record meeting Member classification, q field record withdraw deposit transfer amounts, acc field record proceeds to account row and title, co field record proceed to account Account, wid field record are responsible for website staff's job number, the uptime field record audit time audited.
27th entitled examine table is used for recording the examination data to every net about guides for the website, comprises Data below record field: id, uid, content, rank, tlimit, sort, uptime, mid, wherein id field are used for remembering Record serial number this table major key of this record;Uid field record is examined member's account number of guide;Content field is used for remembering Record examination comment data;Rank field is used for record examination grade;Tlimit field is used for the record examination time limit;Sort field is used In record examination classification, it is divided into monthly appraisal, quarterly review, annual screening three class;Uptime field is used for record examination and occurs Time;Mid field is used for recording the job number of examination personnel.
28th entitled punish table is used for the punishment record to net about guide for the record, comprises data below record word Section: id, uid, conetnt, rank, uptime, mid wherein id field is used for recording serial number this table major key of this record; Uid field record be punished guide member's account number correspond to u table uid field;Content field is used for record punishment in detail Content-data;Rank field is used for recording punishment level;Uptime field is used for the time that record punishment occurs;Mid field is used Job number in record management personnel.
29th entitled award table is used for the bonus record to net about guide for the record, comprises data below record word Section: id, uid, conetnt, rank, uptime, mid wherein id field is used for recording serial number this table major key of this record; Guide member's account number that uid field record is commended;Content field is used for record bonus detailed content data;Rank field For record bonus grade;Uptime field is used for the time that record bonus occurs;Mid field is used for the work of record management personnel Number.
Secondly the related pages of design website platform net about guide.
The homepage of module of first net about being conducted a sightseeing tour is designed main contents that this page is related to as shown in Fig. 2 opening first Send out and in platform, select a Page Template or designed, designed one page layout framework, then that the technical characteristic of the present invention is interior with realization Hold and and write related background program execution code by the layout framework form layout that classifies in this page.At this, we utilize Form carrys out the fast layout page, its Design view as shown in figure 3, first in the page one multirow three of insertion row table, table Width is exactly the width of display information when the page runs, and takes 1100 herein, and the first row three of form is arranged merging string in a row, This journey is that the title of full page is used for showing website logo or is about conducted a sightseeing tour related advertisement and news picture arrange phase to net The link answered, allows online friend one click on picture and can go to or check the related depth information of this picture or details display circle Face, the realization that picture shows: first in the first hurdle, a picture control is set, then will from data base's adv1 tables of data New advertising pictures data retrieval out, by picture control is bound with the image data retrieving then, and then adds one Individual hyperlink is linked to details interface, and first entitled adv1 table is used for recording the advertising pictures address letter of each upload Breath, during upload system simultaneously by advertising pictures data storage in this advp file, second Zhang Mingwei adv2 table is used for The extension of advertisement at homepage title position about conducted a sightseeing tour by record net or details comprise picture address information and Word message, its Picture or multimedia data information with different file name records in advp file, coating in order to prevent file from bearing the same name Lid, can add, when writing and uploading storage code, table code name and the business generation being under the jurisdiction of tables of data in the naming rule of filename The contents such as code number.The upload of data can be arranged in background net management work space, first uploads advertising pictures, and picture address information is remembered In first table adv1 table, in advp file, after success, system records this figure for picture, multimedia data recorder for record Sequence number in tables of data for the piece is No. aid, then uploads extension picture and Word message belonging to this advertisement again, during upload together No. aid record in the aid field of adv2 table, represent each data information that second table adv2 table recorded all with the No. aid association of one table adv1.
Arrange to show the content of five aspects in a second row: content 1, displaying log in the identity information of member, and such as " you get well certain Certain!", its implementation: registered members' name is retrieved from its log-on message log u table, is then bundled in this Position;Content 2 shows " guide practitioner and service enterprise's entrance ", and guide clicks here and may have access to website guide's work Make space, enter the operation that work space carries out correlation, have any need to illustrate is exactly to enter work after related personnel clicks on herein During space, system is provided with such a safety measure: when entering work space, the identity first according to this member for the system is believed Breath retrieves the value of identity category flag field of this member from the u table of data base and whether opens the operation money of guide service The value of the f1 of the value of lattice f1 and dp table is simultaneously checked, only when its identity category is guide and has opened online management qualification Visitor (i.e. u table f1=1, the f1=1 of dp table) this work space of being allowed for access, otherwise jumps to the about guide service of application net The application page, carries out online applicaton for business registration, fills in submission relevant information such as in this page: full name of applicant or applying unit Title, address, phone, managerial setup director's name, business scope content, the work experience of applicant, related qualification or The account upload the contents such as related qualification file, picture of opening an account of bank, passes through rear operation also can be submitted to ensure in data verification Gold, waits the examination & verification of portal management side.Content 3 arranges my account identification, and online friend clicks on the account exhibition that can jump to he or she Show the page, check oneself account balance or be the account charging of oneself, withdraw deposit apply for etc.;Content 4 arranges my order Mark, webpage passes through to click on this mark, you can jumps to the navigation page of the order showing that this online friend once submitted to, also may be used Click on " my guide to be looked for " and enter tourism offer initiation interface in this page, upload the tour plan of oneself and allow guide to throw Single;The navigation information block clicking on order can check the details of this order.Content 5 setting guidance path bar shows currently Location " so-and-so website > > net about conduct a sightseeing tour homepage ".
Tourism offer with regard to online friend initiates interface, comprises tour plan content, touring line, number of forming a team, venue Point, the typing window (can be realized with style frame control) of information and a submitting button such as plan browsing time, promoter will Submitting button is clicked on, system will data above together with the registration account number of submitter be after information above typing in typing window Under corresponding field name in the tourteam table that uid uploads in platform database, the value of f field is set to 2 expressions simultaneously Initiated by consumer visitor, the value of fd field is set to represent competition for orders ongoing 1.
With regard to consumer visitor member account displayed page, display content comprises: the remaining sum of the previous year, the transaction in the current year Detail, withdraw deposit application or charging function etc., the remaining sum of its previous year records at the end of each year and once records in platform database In ubalance table, the treasury trade information record of current year is in the uinto table of platform database.Wherein the previous year remaining sum number According to Display Realization: be first depending on the remaining sum number of account number uid the previous year from the ubalance table of platform database of this member Bind according to being retrieved and in display location, its retrieval coding is: select bal from dbo.ubalance where Uid=@id and dyear=@y
Wherein id represents this consumer member account number value, and y represents the year angle value of previous year
The transaction details in the current year show, are also the uinto table from platform database for account number uid being first depending on this member The transaction details data retrieval in this consumer's current year is out formed data set, then designs a detail in display location and show Show block, comprise: on the date, the display content such as income number, payment number, explanation, then again by the field data in data set and display Position carries out dynamic binding, then carries out multiple data to displaying block again and repeat display designing.Its data retrieval key generation Code is:
Select*from dbo.uinto where uid=@id and dyear=@yl
Wherein id represents this consumer member account number value, and yl represents the year angle value in the current year.
Withdraw deposit with regard to member the realization of application: operator can go to application interface after clicking on " application is withdrawn deposit " mark, It is provided with typing window or the interface of application content, content comprises: number of transferring accounts of withdrawing deposit, situation illustrates, submission is pressed in this boundary's page Button, applicant clicks on submitting button after input application documents content, and system is stored in platform number by applying for that related data uploads According in pick table in storehouse, website staff checks these Shens of withdrawing deposit in website background work space by management client Please, it is reserved in the account specified in log-on message by contact details in registering account after contacting with applicant to it by regulation Proceed to cash, and perform record of transferring accounts, record of transferring accounts is uploaded by the uinto table being stored in platform database by management client In.
Realization with regard to account charging function: applicant clicks on " supplementing with money " mark, you can jumps to and supplements interface with money, on this boundary Show points for attention that website receives the accounts information of fund and online friend pays dues etc. in face and supplement required information with money, arrange simultaneously Supplement with money under wired and by the option of Third-party payment platform payment top.When supplementing with money under online friend's selection line, online friend needs online Number is supplemented in submission with money, and (during its submission, according to the value of its member's account number uid, system is applied for that number upload is stored in platform data Under ain field name in the uinto table in storehouse, record its time of origin under atime field name simultaneously), pass through simultaneously under line to Transfer accounts in the account that website is specified remittance, the registration account number simultaneously indicating applicant is uid or its cash account in this website Number, website staff according to its application information and receipt on account data by its charging information record the in field name in uinto table Under, record under uptime field name simultaneously and keep accounts the time, record declaration word under c field name.When online friend selects by the During tripartite's payment platform payment top, system utilizes prior art to realize and the coupling of Third-party payment platform, and allows online friend to pass through Third-party payment platform pays the expense of supplementing with money, and the number actually receiving after expense is paid by its charging information record in website according to it Under the in field name in uinto table, record under uptime field name simultaneously and keep accounts the time, record declaration under c field name Word.
The third line: the function of setting search in Website, the way of search function that one online friend of position arrangement commonly uses herein is such as Scan for by the entitled key word in sight spot that vacation packages comprise, other ways of search can be led by Advanced Search mark Navigate and realize in another page of advanced search page.The implementation method of function of search herein: first a style frame control is set, Input search keyword for online friend, then Confirmation Controls are set, the information for verifying online friend's input in style frame is No meet the requirements, to prevent someone's input malicious code intrusion base, then setting one operation button such as " searching ", Wang Youdian Hit this button, the system i.e. sight name according to input is from data base for recording sight spot and service product contingency table Tourgoods table and be used for recording in the travelling products data registration form tourgoods table of travelling route and will comprise this tourist attractions Vacation packages be retrieved and go to another page and show, online friend clicks on the vacation packages taken a fancy to and can view the detailed of this set meal Thin information, and the tourism guide of set meal or the enterprise of service in tourism at place, if satisfaction can submit application of joining the Youth League to.Search senior In the rope page, multiple key words can be arranged to scan for, such as by price, by the number of forming a team, by guide qualification grade, on time Between scan for by specified guide etc., its implementation is similar with said method, and software programmers can be by with top The thinking of formula be can achieve by software code.
Fourth line: for arranging vacation packages navigation classification logotype, its classification can arrange according to market situation, set herein Put and comprise: Southeast Asia tourism, Northern Europe tourism, island trip, Canada of the U.S., the northern scenery, careless garden landscape, western plateau, the south of the River The region of rivers and lakes, modern metropolitan cities, the south of Fujian Province scene, red tourism, Peasants Joy etc..The link that mark has towards lower one page is this chain simultaneously Connect one Transfer Parameters of setting, online friend clicks on the vacation packages product that related classification can view the category, and online friend clicks on The details that vacation packages product therein can view this set meal and the sight spot associating, hotel information, and tourism guide Relevant information and this product forming a team plan of tourism, if satisfaction can throw single submission joined the Youth League application.
Implementation herein: when online friend clicks on mark, the page goes to the parameter that this identifies by another page simultaneously (also can be just To identify content as parameter) be passed on, in lower one page using the parameter passing over as search keyword by vacation packages Qualified vacation packages are retrieved from the vacation packages product data registration form tourgoods table of data base by product Show (its display packing is identical with the 6th row b2 display packing) as navigation information, browse selection for online friend.When online friend clicks on it In set meal product when, due to be provided with herein link now the page will jump to next page simultaneously by the sequence number of set meal product Transmitted, lower one page by according to this parameter by related data from the tourgoods table of data base by this set meal product Details are retrieved formation data set, then in the page show, show this vacation packages product details and its The information at related sight spot, hotel information and guide.First by according to the product passing in lower one page when implementing Guide member's account number of the details of this product, this product is retrieved simultaneously according to inspection from tourgoods table sequence number Guide's member's account number that rope goes out hands over the phase of this guide from u table, dp table, dpphoto table, atourserve table, complained table Close information retrieval out to show in the page, simultaneously according to the product serial number that passes over by the related sight spot of this product, hotel Sequence number be retrieved from contingency table simultaneously according to the data that herein retrieves by sight spot, hotel data from view_spot table It is retrieved, form data set, then the data retrieving above is carried out after data binding at the display location of the page Display.The tourism the formed a team plan of forming a team of this product also can be shown further, online friend also can be to arbitrary meter of forming a team therein Draw and carry out throwing single submission addition application, its related implementation is referring to relevant narration below.
Fifth line is used for showing the relevant information data of outstanding guide, a middle hurdle a2 hurdle is used for showing these outstanding guides Head portrait picture and brief character introduction, online friend clicks on the tour guide information selected and shows that block can go to business circle of this guide Face, shows the evaluation of travelling route set meal that this guide once directed and visitor and feedback information and just in this business interface In the tourism guide pin bushing released and the information of forming a team, online friend clicks on these vacation packages released and the information of forming a team, you can check The details of this travelling products and depth information introduction, and the submission that can place an order adds the application of tourist group.Implementation method be by Website set high-quality guide competition method from numerous enter select guide standard compliant personnel given concentrate show, The personnel portal management personnel being selected pass through the value of the oks field of registration information record table u table in this meeting for the backstage It is changed to 1, and provide a ranking value and be recorded in the oksp field of u table and (one backstage is set by software work personnel herein Operation interface upload with submitting to completing the typing of data above).The realization that the high-quality guides of website front end shows: from The value of the oks field of member registration log u table foundation u table of data base is 1 member's head phase and related text information retrieval Out, by u table oksp field value sequence, then high-quality guides's display location arrange an Image control and with inspection The head image data binding that rope goes out, forms display unit simultaneously after related display location carries out word binding together and adds one Lead to the hyperlink of another display details and the depth information page, and carry out multiple data to displaying block and repeat display setting Meter, such as can adopt the method for data list to carry out, you can to reach display multidigit high-quality guides, can design herein herein It is shown as 30, be configured when arranging data list.More high-quality guides can be by " more ... " at this place Mark to show to navigate to another page, in this page can satisfactory guides all or paging in batches Show, browse selection for online friend, online friend clicks on the tour guide information selected and shows that block can go to the business interface of this guide, The evaluation of travelling route set meal that this guide once directed and visitor and feedback information and is shown in this business interface The tourism guide pin bushing released and the information of forming a team, online friend clicks on these vacation packages released and the information of forming a team, you can check this The details of travelling products and depth information introduction, and the submission that can place an order adds the application of tourist group.Its implementation and basis In literary composition the basically identical related data according to the guide's member's account number passing over, this conducted a sightseeing tour of the implementation method of continuous item from Form data set after being retrieved in the relative recording table of data base, then data set field is entered Mobile state at display location Binding, you can reach the purpose of display.
The left side one hurdle a1 hurdle of fifth line be used for showing vacation packages product that outstanding guide directs by set of setting out The lookup mode of ground navigation, can list some main set out concentration cities, such as Beijing, Shanghai and Nanjing etc. in viewing area, Online friend click on the city chosen then can go to another page of display with choose city as departure place all forming a team by outstanding The vacation packages product that guide directs, clicks on the vacation packages product chosen, you can check this set meal product in another interface Be discussed in detail, and can place an order submit to add tourist group application.Click on a1 hurdle at " more ... " then go to another display by The page of more city navigations, in this page can with display system in record all vacation packages products departure place be located City or paging show in batches, and online friend clicks on the city chosen and then can go to another page of display to choose city as departure place All vacation packages products directed by outstanding guide formed a team, click on the vacation packages product chosen, you can another Check being discussed in detail of this set meal product in interface, and the submission that can place an order adds the application of tourist group, the display of data herein relates to And tourgoods table is travelling products set meal data logger and tourteam forms a team planning chart.
It is used for showing the preferential promotional items of vacation packages that outstanding guide releases, online friend on the right one hurdle a3 hurdle of fifth line Click on the promotional items chosen, you can check the information being discussed in detail with outstanding guide of this set meal product in another interface, And the addition application of the tourist group submitting this set meal product of addition to that can place an order.Click on a3 hurdle in " more ... " then go to another by The display page of more promotional items navigation, in this page can with display system in record all sales promotion that coming into force by The vacation packages product item that high-quality guide directs or paging show in batches, the promotional items that online friend's click is chosen, you can turn To being discussed in detail and outstanding tour guide information of vacation packages product of another page of display selected item, and the submission that can place an order add should The addition application of the tourist group of set meal product.
The information data of each vacation packages product released for the guide member showing this website in the 6th row, middle One hurdle b2 hurdle is used for showing that each vacation packages product item is fixed tentatively as showing 30 projects herein, more projects are by this column " more ... " marks navigate to goes in another page to show, display packing can add correlation with the sight spot representative image comprising in product The display that word composition exhibition information block carries out multi-group data shows, online friend clicks on the exhibition information block selected and can go to this set The details of meal travelling products and depth information introduction and this project tour guide information introduction and the information offer information page of forming a team, And the offer of forming a team that choose can be carried out with the tourist group applying for that addition is formed a team set by offer that places an order.Implementation method: with aforesaid phase Close the content display method equally i.e. display packing (patent application first with a kind of my data message of previous patented technology Number: in b2 hurdle, 201510537300.8) design the displaying scheme of vacation packages product item, first using the quick design one of form The displaying block (being made up of picture control and text importing area) of individual vacation packages product, then design data source or data set (with Under be referred to as data set) by the picture control in displaying block, data corresponding with data set is carried out respectively with text importing region Binding, then adds the hyperlink of the page jumping to details, and displaying block is entered to related content in displaying block Row multiple data repeat display design, herein adopt data list design (its key code is:
< asp:datalist id=" datalist1 "
Runat=" server "
Repeatcolumns=" 4 "
Repeatdirection=" horizontal "
Repeatlayout=" table "
Datasource="<%#dataset2.defaultview%>">
<itemtemplate>
<table bgcolor=" #ffffff ">
<tr>
<td width=" 210 "><div align=" center "><a href=" tour_goods2.aspx?Id=< %#
Dataset2.fieldvalue (" id ", container) % > " target=" _ blank " >
< asp:image width=" 210 " id=" face_image " imageurl=< %#
Dataset2.fieldvalue (" rface_image ", container) % > runat=" server " tooltip=" Click on picture to check in detail "/>
</a></div></td>
</tr>
<tr>
<td><div align=" center " class=" style5 "><%#dataset2.fieldvalue (" Content ", container) %></div></td>
</tr>
</table>
</itemtemplate>
<separatortemplate>&nbsp;&nbsp;</separatortemplate>
</asp:datalist>
And the design of data set be by this platform database with regard to vacation packages product related data from server and It is retrieved formation data acquisition system in data base, be related to tourgoods table and tourgoodsp file, the key generation of its retrieval Code is: select top 30*, (' tourgoodsp/ '+paddr) as rface_image from dbo.tourgoods Where f=1 is with regard to details and the depth information introduction of travelling products and this project tour guide information introduction and information of forming a team The offer information page, this page comprises: the detailed depth information of vacation packages product is shown, is directed in offer of forming a team of this set meal etc. Hold as shown in figure 4, its concrete implementation mode provides an example herein: vacation packages product detail information shows interface as schemed Shown in 5, the first row is the banner part that the first hurdle a hurdle is the page, for placing the related information content of website platform, if any Relevant advertisements news etc., its implementation is shown in above homepage part.
Fig. 5 the second behavior b area, point two subregions of b1, b2, the b1 subregion on the left side is used for placing vacation packages product and has generation The sight spot picture of table, the b2 subregion on the right is used for placing the related introduction of vacation packages product, and its implementation is with this paper's Homepage display packing is similar to, and that is, to picture to be shown, first arranges a picture control at its position, then with from data base In picture address information field in the data set that retrieves carry out dynamic binding, be also by from data base to text importing area Word message field in the data set retrieving carries out dynamic binding, and retrieve is to be used for record tourism in data base to produce herein The tourgoods table of product data, is related to the image data in tourgoodsp file simultaneously, and its search condition is according to previous The sequence number of the vacation packages product that page passes over is No. id and carries out, key code is:
Select*, (' tourgoodsp/ '+paddr) as rface_image from dbo.tourgoods whereid=@ id
The sequence number that@id represents the vacation packages product passing over according to prevpage is No. id
In mark and the link of the bottom setting " checking that visitor evaluates " in b1 area, the evaluation page that can go to of online friend's click is looked into See experience and the evaluation of the visitor having experienced this vacation packages product, evaluate page implementation method: first in online friend's point When hitting " checking that visitor evaluates ", page jump passes over to this page and by No. id of this set meal product, and this page passes through to pass over Id parameter evaluation content is retrieved formation data set from the assess table of server database by evaluation information, its inspection The key code of rope is:
Select*from dbo.assess where goodsid=@id and f=1
The sequence number that@id represents the vacation packages product passing over according to prevpage is No. id
Then in the page, one form of insertion quickly carries out the display design of evaluation information, the first behavior page of form Title, for arranging the related content of website, the second behavior title, the third line is used for the displaying of evaluation information, its implementation It is that the id field of appraiser is in the phase showing by the opinion rating in this place data set, evaluation content field and time field Answer position to carry out binding one display unit of composition, then display unit is carried out with multiple data and repeats display design, you can be real Now related visitor's evaluation information of this vacation packages product is displayed, browse for online friend.
The c area of Fig. 5 the third line is used for showing the sight spot of travelling products correlation or the leisure cuisines data of hotel and its offer Information, arrangement is the explanatory note on left side picture+the right, and its implementation is essentially identical with the above, is all i.e. right Picture to be shown, first arranges a picture control at its position, then with the data set retrieving from data base in Picture address information field is bound, and is also by the word letter in the data set retrieving from data base to text importing area Breath field is bound, what its difference was to retrieve herein be used in data base recording sight spot and hotel details picture, Multimedia data information view_spot log is provided with picture multimedia data note corresponding with this table simultaneously in the server Record file view_spotp file, its search condition is that the sequence number of the vacation packages product passing over according to prevpage is The nested subquery of of No. id retrieve sight spot hotel No. id, finally retrieves this sight spot or the picture in hotel and word is situated between Continue, key code is:
Select*, (' view_spotp/ '+paddr) as rface_image from dbo.view_spot where Spotid=(select spotid from dbo.tourspot where tgoodsid=@id)
The sequence number that@id represents the vacation packages product passing over according to prevpage is No. id
Fig. 5 fourth line is that d area is used for being shown as the group travel plan of this vacation packages product design, up-to-date for showing Go on a tour the plan of forming a team, a set meal product can have multiple plans of going on a tour, can release new after front implementing plan of going on a tour again The plan of going on a tour, local area only shows not yet rows of part of forming a team, and its displaying scheme is also similar with described above, will form a team Plan is retrieved from the tourteam table of server database, and the key code of its retrieval is:
Select*from dbo.tourteam where goodsid=@id and process=0
Process=0 represents that retrieval is formed a team this plan of partly forming a team of well afoot, to complete to form a team then not here show Show.
Then the main information formed a team in the d area display interface arrangement of Fig. 5 is shown and adds and jumps to details The link at interface, display content includes: guide director, number of forming a team, and the departure time, gathers address, price etc., realization side Method: similar with above method, first carry out the data binding of relevant field in viewing area, form displaying block, then to displaying block Carry out multiple data and repeat display designing, when program is run this vacation packages product all be among recruitment form a team Plan all can show, the plan of forming a team that online friend's click is chosen, you can the details jumping to this plan show that interface is entered Row is checked, and the application submitted to into travel party that can place an order.
Show INTERFACE DESIGN and the design applying for submitting to of joining the Youth League that places an order: its details with regard to plan details of forming a team Show that the implementation method at interface is basically identical with exhibition information method above, the page inserts a form and quickly arranges boundary Then the need information shown and the data retrieving from server database are carried out data binding in display location by face structure , the key code of its retrieval is just the same with above: select*from dbo.tourteam where ttid=@ ttid
This interface requirements shows some related more detailed information contenies of the plan of forming a team, and comprises: guide's letter of tourist group Information (as main guide's head phase, name, qualification etc.) is wanted to lead to the link at details interface, plan number of forming a team, register Number, remaining name specified number (implementation method: be planned out visitor's number one number of applicants by forming a team and draw), planned time of going on a tour, Determine afterwards goes on a tour venue and time, and the information of the insurance products included in price, price, the plan of originally forming a team are issued Time, the publisher of this plan are the information such as whose, wherein click on guide's head portrait or Word message can view the detailed of this guide Thin information, can be jumped to by setting hyperlink and go to show in another interface to realize.Can show at the details interface of guide Show the identity information of guide, working informative presentations and the contents such as qualification information, visitor's evaluation information and website examination information.
With regard to adding the design of tourist group's application: need first to design an application submission little module for visitor, its design regards Figure is as shown in fig. 6, comprise: number of applicants (wherein male how many people, women how many people), telephone number, full name of applicant, application The contents such as the item that people's sex, applicant's age etc., prompting client note, above essential information typing click submission is pressed by online friend Button, the page goes to page 2, and submission function herein is to be subordinate to the information collected and the application by above input interface It is ttid in the sequence number of the plan of forming a team, is committed to the team_apply table in platform database, charge to storage under corresponding field name Deposit.After data submits success to, the page goes to page 2, and the presentation of information in this page, upper page being committed to data base out supplies Shen Ask someone to check verification, also can submit to after this page editor Ru wrong, this page arrange simultaneously pay dues mark or button with go out visitor The personal relevant information of member submits mark or button to, enters that related interfaces are paid dues and submission is gone on a tour personnel after clicking on for online friend People's information.Wherein online friend enters, after clicking on mark of paying dues, interface of paying dues, and the third-party payment platform of many families has been listed at interface of paying dues Mark with link or other way to pay dues supplies online friend's selection, module of paying dues herein is to pay dues technology Lai in fact using existing electric business Existing, it is the common knowledge being engaged in electric business development field technical staff, be not repeated for saving space to describe herein;With regard to going out visitor The submission of member associated personal information, can be separately provided an input interface to carry out, after allowing online friend click on respective identification or button Enter in this interface and submit to after input relevant information, information is uploaded team_applyp table pair in data base for the record by system Answer field under one's name, content comprises: visitor's name, visitor's sex, age, visitor's identity document title and passport NO., visitor The data such as telephone number, visitor address, visitor household's telephone number, visitor's occupational information, simultaneously should be by corresponding to this visitor The sequence number of application record is that taid together submits to, and record is under the taid field name of team_applyp table.
With regard to order management, online friend can by click on net about conduct a sightseeing tour homepage " my order " as shown in Figure 3 identify into Enter the order management page management order of oneself, its content comprises as shown in Figure 7: check the order of oneself, cancel an order, editor Order, to the evaluation of order consumption experience and sharing of sense of reality, client the unhappiness occurring in consumption is complained ( Can be arranged in other local in platform) with the contents such as complaint and feedback, as shown in Figure 7.Its specific implementation, setting one is ordered The menu manager page, in the page, every order is shown by order display unit, comprises: order pair in each of which display unit The product set meal brief information displaying answered, order status, consumption status, wherein order status be divided into normally, need updates two Kind of situation, during consumption status such as are divided into carry out at the to be consumed, consumption, consumption terminate three kinds of situations, during the design page, we first set up Data set, according to the log-on message such as member id of this online friend, by the sequence information of this member from the team_ of platform database It is retrieved in apply table and tourgoods table, its key code is:
Select a.taid, a.upuid, a.uptime, a.orf, a.cf, t.content from dbo.team_apply A,
Dbo.tourgoods t where a.upuid=@uid and a.goodsid=t.id
Wherein@uid represents member's account number uid of online friend, and system can pass through session (uid) variable when this member logs in Recorded, in case using at any time.
Then in the page, one form of insertion quickly to arrange page display structure, as shown in figure 8, being respectively provided with order Sequence number, order set meal, the date that places an order, order status, consumption status, check detailed grade for column, then in the corresponding position on the second hurdle The place of putting carries out data binding, and " checking in detail " the mark setting under checking detailed column respectively with corresponding field in data set One link, program is issued online friend when running and is clicked on the details displayed page that can jump to this part order and by this order Sequence number be passed on, then the binding data on the second hurdle is carried out multiple data repeat display design (herein adopt duplicate block The method for designing in domain), you can reach and in this page, the vacation packages product order of this member is all shown.
The content of its displaying of order details interface comprises: adds the detailed content of tourist group's application, such as application submission People's information, is added the number of tourist group's application, wherein each how many people of men and women, personal information of respectively joining the Youth League submits situation, reserved handss to Machine number, applies for submission time, paying information, guide audits situation information;The related content of this plan of forming a team: this plan of forming a team Tour guide information, plan the travel time, the concrete set time determining and assemble place, number of forming a team, the people of registration now Number, incidental insurance products situation;The information of this vacation packages product of going on a tour is such as: the particular content of this vacation packages product or With linking and correlated identities information of this vacation packages product detail information interface of access.Wherein reserved phone number provides and repaiies Change editting function, following mark and link is set in this page: checks personnel's data of joining the Youth League, supplementary personnel's money of joining the Youth League simultaneously Material, extra purchase tourist insurance, pay dues, wherein check personnel's data mark of joining the Youth League, online friend can jump to after clicking on and join the Youth League The detailed interface of personnel's data, shows personnel's data of joining the Youth League, editor's change of its related data, its implementation can in this page Will be retrieved item by item according to order sequence number in team_applyp table from data base for personnel's data of joining the Youth League, then with exhibition Show the style frame control bundle of the corresponding display location of the page, if necessary to modification editor, then the content after modification editor is submitted to Data base stores;Supplementary personnel's data of joining the Youth League, is also not submit, for after having online friend to place an order, member's data or incomplete of joining the Youth League to Situation that portion submits to and set up, now click on supplement and join the Youth League personnel's data mark, the page jumps to aforementioned personnel's phase of going on a tour Close the submission interface of personal information, carry out typing and the submission of data.For extra purchase tourist insurance, it is for indivedual visitors The demand of the insurance products outside to set meal and design, exterior chain third party insurance product electric business platform linkage provided herein, online friend Go to third-party platform after click and voluntarily buy required insurance products.With regard to paying dues, it is to be directed to have submitted to order also not hand over The consumer of expense and design, a link is set herein, allows consumer's click mark of paying dues can jump to aforesaid friendship Expense interface carries out operation of paying dues.Cancel an order function, visitor clicks on cancel button mark, this order can be added by system in online friend The value of the accept field of tourist group's application information team_apply table is changed to " abandoning ", illustrates record in c situation simultaneously Field under one's name, now as paid dues, then return consumer or fill in its account after being examined from website staff by consumer Value.
To the evaluation of order consumption experience and sharing of sense of reality, client complains to the unhappiness occurring in consumption Implementation essentially identical, implementation method is to be respectively provided with operation interface to collect the Input of this this content and file Upload asp:fileupload control and submitting button, during running software, operator is defeated in the text inframe of corresponding items content Enter related content (such as complaint content, complainant's phone, the sequence number of plan of forming a team involved by complaint, defendant's account number I.e. uid, defendant's phone, evaluation content, evaluates targeted sequence number of vacation packages product etc.), or by file Transmission control part selects related file to be uploaded such as picture etc., then clicks on submitting button, system is then by the content of text inframe It is committed to storage in the corresponding table of server database, or the data such as picture are submitted to server folder, then by picture ground In the corresponding tables of data of platform database, the upload code of its concrete file content has been electric business software programming to location information Store The common knowledge of personnel, does not describe in detail for saving space herein one by one, as a example the evaluation content only consumption therein evaluated is submitted to Provide critical data store code as follows:
Insert into assess (goodsid, c, uid) values (' " &textboxl.text& " ', ' " & Textbox2.text& " ', ' " &session (" uid ") & " ') "
Wherein goodsid field is used for storing the sequence number of the targeted vacation packages product of this evaluation corresponding to text box control In part textboxl, the content of institute's typing, is inputted by operator herein;C field is used for storing the particular content of this evaluation, corresponding In Input textbox2, the content of institute's typing, is inputted by operator;Uid field is used for storing the author of this evaluation, To be there is provided by submitter member's account number that system session (" uid ") variable is recorded.The realization complained can refer to herein below Implementation method is complained to realize uncivil visitor.
Submitter checks to complaint and feedback information: can arrange a calling information feedback circle in order management module Face, this interface comprises: the content complained is shown, complained person's reply content shows, to the statement meaning replying handling suggestion See whether upload, portal management side process the contents such as termination to the handling suggestion complained, this complaint.The realization side that its information is shown Method: essentially identical with aforementioned said data display scheme, formation number will be retrieved from platform database by related data According to collection, then the field of related data is carried out binding the display that can achieve to information above in display location.At reply The statement suggestion of reason suggestion uploads, and can be carried out by a radio button control and a submitting button, radio button is used for User selects " satisfaction " or " being unsatisfied with ", then realizes the upload of data by submitting button, complains the sequence of record with this Number for storage condition be stored in platform database complained table ub1 (storage to defendant reply statement Information) or ub2 (the statement information that storage is replied to webmaster) under field name, this sentences as a example being stored under ub1 field name, and it is deposited The key code of storage is as follows:
Update complained set ub1=' "+ Dropdownlistxueli.selecteditem.text.tostring+ " ' where id=" & dataset1.defaultview.table.rows(0)(″id″)
Wherein id takes this to complain the value of the sequence number of record.
With regard to the work space of net about guide, comprise: guide service business datum uploads and management, process visitor complain, Complain uncivil visitor, pay dues, accounts of finance management exchanges mailbox, order management etc. with webmaster, visitor.
Wherein guide service business datum is uploaded and is comprised with management: vacation packages product data upload, the trip to upload Trip set meal product information is safeguarded and edit-modify, the sight spot related to product, hotel and its leisure cuisines information that provided Upload and safeguard edit-modify, for the upload letter related to safeguarding edit-modify, the plan of forming a team of the plan of forming a team of set meal product Breath displaying browses.This place upload data or editor safeguard amended upload include lteral data, image data or its Its multi-medium data, its implementation is all to arrange a Data Enter interface in client, in interface by style frame or picture, Document uploading control composition uploads or modification edit operation interface, clicks on " upload button " real after online friend's typing relevant information data Now upload.Lteral data uploads and is stored in corresponding data logger in platform database, picture or other multi-medium data During upload, file data is uploaded and be stored in the corresponding Photo folder of Platform Server then by the storage location of this document Address information is stored in corresponding data logger in platform database.The corresponding data base of vacation packages product data herein Middle data logger is tourgoods table, and corresponding file is tourgoodsp file;The related sight spot of product, hotel In data base corresponding to information, data logger is view_spot table, and corresponding file is view_spotp file;Pin In the data base corresponding to the plan of forming a team of set meal product, data logger is tourteam table.Plan information of forming a team is shown clear The implementation method look at is substantially similar with aforesaid information data exhibition scheme, that is, first pass through a brief information display of forming a team Interface is shown, online friend clicks on any one display information therein and shows block, and the page jumps to detailed plan exhibition of forming a team Show interface, guide not only can view specific plans of forming a team in this detailed interface, can also look at visitor and be directed to this Individual plan of forming a team participate in situation, guide can sign up with to this and be accepted or abort operation, and to applicant The situation of carrying out explanation.The content showing showing interface in the plan of forming a team comprises: program content of forming a team, tour guide information, the plan of forming a team Number, register accepted number and each how many people of men and women, the pending number such as registered, the pending order letter such as display Cease and show the sequence information audited, the displaying of the pending sequence information such as therein and the sequence information audited It is divided into brief information display display, operator clicks on display content and jumps to this order details displaying interface, and can enter Row accepts and abort operation, and server database is submitted in the explanation of typing situation to.Wherein form a team program content, tour guide information, group The realization of group's plan number: this plan sequence number group from platform database of forming a team passing over when first redirecting according to front page With member's log-on message log, information of forming a team is gone out with guide's director's name searching in group's plan log tourteam table Come, then the display correspondence position in display interface carries out data binding, the key code of its retrieval is:
Select a.na, t.*from dbo.tourteam t, dbo.u a where t.ttid=@id and a.uid= t.uid1
Wherein@id is this plan sequence number of forming a team passing over when front page redirects.
With regard to accepted number and each how many people of men and women of registering, the implementation of the pending number such as registered: first This plan sequence number registration log team_apply from platform database that forms a team passing over when redirecting according to front page In table, data summarization is retrieved, then the display correspondence position in display interface carries out data binding, its retrieval crucial generation Code is: accepted number collects
Select sum (q) as q1, sum (mq) as q2, sum (wq) as q3from dbo.team_apply where Ttid=@id and accept=' accepts '
The number retrieval having registered etc. pending collects key code: select sum (q) as q2from dbo.team_ Apply where ttid=@id and accept=' is pending '
Wherein@id is this plan sequence number of forming a team passing over when front page redirects.
Wherein order details show that the implementation at interface is similar with other data message display modes herein, first Related from the order record table team_apply table and order registration member's table team_applyp table of platform database Out, then one order brief information of design displays interface to data retrieval, clicks on display information therein and can view this The details of order and the information of participant, and corresponding behaviour can be completed with abort operation button by the acceptance in interface Make (to refer to the operating function in pending trial order interface, click on the operation button accepting or abandoning, system is according to the sequence number of this order The value of accept field in team_apply table in data base is rewritten into corresponding value, the accept button such as clicked on, then by number According to being rewritten into " accepting ";If that clicks on abandons button, data rewriting is become " abandoning "), and can be inputted by style frame The explanation suggestion of guide, then clicks on the upload that upload button realizes explanation opinion data, will illustrate that data storage is remembered in order Under the c field name of record table team_apply table.If guide selects to abandon order, system can be according to the situation of paying dues of the member that places an order It is paid dues and is recorded in the uinto table of platform database in the accounts of finance return to this member that places an order.Place an order member Other products or the service of website offer can be provided with this money again, also can withdraw deposit to platform application.
Complain with regard to processing visitor: a page can be separately provided in work space, first the homepage in work space is fitted When position setting one calling information block display complaint has several to need to process (implementation method: with No. uid of this guide as search argument From complaining log complained table, defendant's statistical data is retrieved formation data set and then in display location Place carries out binding to the data that data is concentrated, and its retrieval key code is: select count (id) as c from Dbo.complained where tuid=@uid), or be designed to, if there are having complained this chunk to show, no complain this Chunk conceals (implementation method: displaying block is controlled its display with asp:panel control, if the throwing herein in data set Tell number of packages be c value be more than 0, then the display properties of asp:panel control is that displaying block shows for true, otherwise asp:panel The display properties of control is false), staff clicks on this mark and can redirect this complaint handling page of entrance.
In complaint handling page homepage, display is listed by the displaying block being made up of each bar complaint navigation information, this displaying block There is this brief information complained such as to complain title, complain the time, complainant member uid etc., the homepage page is divided into three bulks to be come Show: defendant is still untreated, defendant has replied process but also audits passing through, careful by webmaster in wait webmaster Core has been wound up the case.The content that defendant clicks in displaying block can jump to lower one page and process operation pages.Its realization side Case is basically identical with above data display scheme, that is, should using the complained calling information log from data base The complained information retrieval of member out forms data set, then enters relevant field data with the corresponding position in displaying block Row binding, then plus one lead to next process the page link and using this complain sequence number be passed on as parameter, then Carry out multiple data to displaying block and repeat display designing.Except that herein for three big displaying blocks according to different inspections Rope key word enters line retrieval and forms three different classes of data sets respectively, and then three bulks are carried out respectively with display design.The A bulk of reply complainant for showing that defendant is not yet processed, its search condition is: the account number of defendant is tuid =@uid and f1=0, wherein f1=0 represent untreated complaint;Second bulk be used for showing defendant replied but also Webmaster examination & verification is being waited to pass through, its search condition is: the account number of defendant is tuid=@uid and f1=1and f2 =0, wherein f1=1 represent processed reply complainant, and f2=0 represents that webmaster is also untreated;The third-largest piece is used for display and is thrown Tell that the processed of people finishes the complaint wound up the case, its search condition is: the account number of defendant is tuid=uid and f3=1, Wherein f3=1 table this complain and processed finish.
The design at complaint handling interface and realization: point two parts, that is, complain related content display part, defendant to process The operation part complained;Related content display part is complained to comprise: complain title, complaint content, the demand complained, complainant's Member's account number, name, telephone number, complain theme involved by form a team program content with link and vacation packages product content and Link;Defendant processes the operation part complained and comprises: defendant replys complainant and explains why and how behaviour to complainant's apology Make interface, defendant is to webmaster complaint and explanation, the operation interface to contents such as complainant's reimbursements.Its presentation of information part and The implementation of its link is basically identical with aforesaid information display scheme, except that here relating in platform database Following three data loggers: complained table record user, visitor's calling information and disposition data;tourteam The plan of forming a team of table record travelling products;Tourgoods table is used for recording travelling products data, need to carry out multilist during its data retrieval Conjunctive query, its inquiry key code is as follows: select c.*, t.*, g.*from dbo.complained c, tourteam T, tourgoods g where c.toteamid=t.ttid and t.goodsid=g.id and c.tuid=@uid
Defendant replys the realization of complainant's operating function: arranges an Input in interface and a submission is pressed Button, during running software, defendant inputs the reply suggestion of oneself in this style frame, then clicks on submitting button, system Then the content in text box is committed to server database, is stored under the tanswer1 field name of table complained, carries The upload code handed over is the common knowledge of electric business development field technical staff, is not repeated for saving space to describe herein;With together The method of sample also can achieve defendant to the operating function of webmaster complaint and explanation, and data upload is stored in server count Under tanswer2 field name according to storehouse complained table.Complainant and webmaster personnel can be by respective client by data Retrieve and show the reply and relevant information that can view defendant from data base.
Realization to complainant's reimbursement: mailbox is passed through from defendant and proposes to transfer accounts application to webmaster, then examined by webmaster Core completes to transfer accounts after agreeing to, account and complainant's account of defendant will complete data change, herein be related to data base's Uinto visitor's accounts of finance discrepancy log and dpinto managerial setup finance discrepancy credit.Implement is in backstage net Also can first design an operation interface and comprise: the financial account producing in defendant's work or working place in pipe work space Number typing window, the financial account typing window proceeding to, transaction are through volume typing window, an executive button.The typing window of information Mouthful can be realized by Input, system is transferred accounts also need to be in the qb field of calling information log cpmplained table after success Record transfer amounts under one's name, these can be realized by the click event generation of executive button.
With regard to complaining uncivil visitor, a complaint interface need to be set in working place, comprise complaint content, defendant The typing window (being used herein as style frame control to realize) of account, defendant's telephone number etc., submitting button, second step Evidence picture uploads (being used herein as document uploading control to realize) and submitting button to realize the upload of data, by calling information Upload in the complained table being stored in platform database, when uploading evidence picture, online friend utilizes document uploading control to provide Function come to select upload picture file, then click on upload button realize upload, now picture and file are stored in flat The file of platform server proofp, its address date is stored in the cpproof table of data base, simultaneously by calling information log The value of the proof field of complained table is changed to 1.
With regard to the account management of guide, website provides guide service to carry out qualification every guide's practitioner's application and examines Look into, if by examining, website will authorize its online management qualification, produce thereafter treasury trade system by its treasury trade information Record, in the dpinto table of platform database, arranges an account management page, in this page in guide's work space simultaneously In comprise: account balance data query and display, pay dues, the functions such as application of transferring accounts of withdrawing deposit, click on " the looking into of balance data viewing area See detailed mark " can check that the account contact in given month is detailed.The Display Realization of wherein account balance data: be first depending on The income sum of No. dpid this month by this member is registered in the operation of this member and sum of entering an item of expenditure in the accounts converges from the dpinto table of data base Total out and shown the remaining sum to the end of last month is retrieved display from the balance table of data base, and aobvious simultaneously Show that the page assumes block using code and calculates to account balance sum during inquiry and shown.
The paying of expense in guide's management functions: comprise to manage paying of annual fee, service guarantees gold etc., its realization side Formula: pay imformation such as account is announced in website, the pay imformation such as toll collector's name and address can be adopted outside line using prior art Pay or paid by Third-party payment platform online, plateform system passes through to check the paying information of the people that pays dues, and will pay dues people's Paying information is separately recorded in the yfee for recording enterprise of service in tourism and guide's practitioner's opening annual fee in data base It is used for recording enterprise of service in tourism and conducts a sightseeing tour in the golden table of practitioner's opening service guarantees with qfee table in table;Or pass through platform The interior safekeeping account of its own carries out transferring accounts paying, and the situation record of paying dues of the people that pays dues directly is entered the annual fee of data base by system Yfee table and guarantee fund's qfee table simultaneously carry out, to running account table dpinto table, record of transferring accounts.
Transfer accounts with regard to withdrawing deposit the realization of application: operator can go to application interface after clicking on " withdraw deposit and transfer accounts " mark, It is provided with the application typing window of content or interface in this boundary's page, content comprises: setting has or not that papery application documents are sent to (can Realized with radio button), number of transferring accounts of withdrawing deposit, situation illustrate, be sent to website staff if there are papery application documents, need Bright paper document title and correlation circumstance (words input window can be realized by Input), submitting button, applicant Click on submitting button after input application documents content, system is stored in pick in platform database by applying for that related data uploads In table, website staff checks this this application of withdrawing deposit of transferring accounts in website background work space by management client, and core Proceed to cash by regulation to the account that it is specified to after associated documents, and perform record of transferring accounts, will be transferred accounts by management client Record uploads in the dpinto table being stored in platform database.
With regard to exchanging mailbox with webmaster, visitor: arrange " mailbox of connection " in the homepage of guide's practitioner's work space Mark and linking towards lower one page, online friend clicks on the interface that can go to mailbox of connection, and this interface comprises: transmits, checks back The contents such as multiple letter.The realization transmitting: arrange one for it and transmit interface, be respectively provided with typing letter content window in interface Mouth, receiver's id typing window and a submitting button (window can be realized by style frame control), operator during running software Member inputs letter content, receiver member's account number (transmit account number to webmaster and take 1) respectively in the window, then clicks on submitting button Realize the upload of data, upload data and be stored in platform database tletter table, the packet of upload contains: letter content, send out Letter people's member account, classification of mail etc., if the letter being destined for non-network management also needs to input receiver member's account number, the class of mail Can not given in software code in advance it is also possible to radio button selects setting by addresser according to the classification transmitting interface Realize.Check the realization of letter content: one letter content navigation interface of setting first, divide and do not read and read two classes by letter Breath block is for unit display out (as shown the front several words writing letters content, letter time, writing letters in people's registration account number etc. Hold), the content in viewer's click information block adds the detailed content displaying interface jumping to this envelope letter, checks the detailed of letter Thin content.Implementation method: the realization of mail display is similar with the implementation that foregoing information is shown, that is, pass through behaviour Making member's account number of personnel and read state is that the letter information belonging to this member is examined from the tletter table of data base by condition Rope out forms data set, then carries out data binding at the display location of display interface, adds that jump shows interface toward detailed Link and the id sequence number of this mail is transmitted, then carry out multiple data to displaying block and repeat display designing.In detail The displaying of information is also substantially similar with aforesaid same problems implementation, will data retrieval out formed data set then exist Display location processes row binding, except that the condition being used for retrieval is sequence number id of letter herein.
Realization with regard to replying to letter: the lower section that letter details show page, one reply of setting can be arranged in Interface, replys interface and is made up of one " upload " button of an Input and " reply " button, and operator clicks on and " returns Multiple " button, then reply interface and manifest, then in style frame, input reply content, click on upload button, realize reply content Upload.Upload data to be stored in the tletter table of data base, addresser can transmit at it and check in content displaying page in reply Hold.
Order management comprise examination & verification process visitor join the Youth League application, check that the plan visitor that forms a team registers situation, the content such as competition for orders, Wherein examination & verification visitor join the Youth League application, check that the plan visitor that forms a team registers situation at order details displaying interface above Describe in implementation, be not repeated herein.With regard to competition for orders of conducting a sightseeing tour, it is the guide service demand for visitor's active upload, leads Trip carries out throwing a kind of single operation, its implementation: guide clicks on " competition for orders " mark, you can jumps to and robs single-page, in this page Comprise to be in the guide service demand offer order brief information block display that the visitor of competition for orders state uploads and in face Throw single feedback result.Guide clicks on the details displaying circle that any information block therein can jump to this offer order Face, in this page, guide can view the details of this offer order, can for being in the single ongoing offer of throwing Click on and throw button, launch throwing single interface input and throw wall scroll part, then click on submitting button and carry out throwing list, oneself was once thrown Single offer, then show that feedback result state is divided into: waits pending, single successful, the single three kinds of situations that fail of throwing of throwing.With regard to robbing single page The offer information display its implementation in face consistent with aforesaid information displaying method i.e. by data retrieval, binding, again plus Carry out multiple data after one link to repeat to show design to realize, the tables of data that data retrieval is related to herein is tourteam Table.With regard to robbing the realization of single-page, comprise in have: throw the comprised service content of single quotation, quotation, throw single member The typing window of the data such as registration account number uid, operation account number dpid of throwing list person (can select style frame control during specific design To realize) and a submitting button, click on submitting button after robbing one by above-mentioned competition for orders content typing, system is then by above-mentioned letter Cease under the corresponding field name of ttdrop table of data base being uploaded to Platform Server, the value of f field is put by simultaneity factor automatically For initial value: wait pending.Then system is shown in throwing single information data in the offer administration interface of offer sponsor, About people clicks on offer information, you can view all throwing lists with regard to this offer, and it is single that offeror can select one of them to throw Acceptance mark, then this offer and throw single between contract relation set up, system by this throw single state be changed to " throw single become The registration account number uid throwing one is recorded into the uid1 word of this offer data in the tourteam table of data base by work(" simultaneously Section under one's name, automatically thrown single state and be changed to throw single failure by other throwing single systems.Then the visitor of offer can pay the bill online And go to stipulated place to accept guide service on time, throw single successfully guide and can be pressed according to the concerns that contract prepares service When provide guide service.
With regard to the job content in website background work person works space, comprise: guides's opening application examination & verification and net The upper various administration fee of member carrying out service pay examination & verification, process member's account charging application, process member withdraws deposit and transfers accounts The meeting exchanging with member is audited, with the examination & verification of travelling products contingency table, the plan of forming a team, in application, the examination & verification of travelling products data, sight spot Member's mailbox management, process consumer and complain, process with regard to the complaint of uncivil visitor, website to the management of guide and examination etc.. The realization of above content:
With regard to guides's opening application examination & verification: operator click on " guides's opening in the homepage of work space Application examination & verification " mark, page jump arrives opening examination & verification homepage, and on view etc. pending opening application navigation in this page is believed Breath block, the navigation block clicking on any of which can jump to the examination page of this application, and this working page comprises: applicant The work warp of application information such as organization names, address, phone, director's name, business scope and content, applicant that member submits to Go through, account number that related qualification, third party open an account and the picture of related qualifications file, guarantee fund are paid in situation etc. Hold and show that the situation being used for auditor's input examination reports with an Input illustrates and two operation buttons: pass through Approve " passing through " button of opening after examination, do not meet " not passing through " button that entry conditions wouldn't open management qualification.Person approving Member clicks on above operation button after input examination reports and can complete review operations.The information exhibition scheme of above content with Aforesaid data display scheme is essentially identical, herein not repeated description, and simply the tables of data in corresponding data base is name herein Table for dp is started the business the qualification pictorial information table of register information table and entitled dpphote, when auditor's clicking operation button When, examination reports can be illustrated and audit conclusion to upload storage under fc, f1 field name of data base's dp table (i.e. with this by system Record sequence number dpid be search condition change this record respective field value) and the f1 field name of u table under, wherein work as click During " by approving opening after examination " button, the value value of the f1 field of u table being changed to the f1 field of 1, dp table is changed to 1, represents logical Cross examination & verification and allow opening;When clicking on " not meeting entry conditions wouldn't open " button, the value of the f1 field of dp table is changed to 2, u The value of the f1 field of table be changed to 2 tables undesirable do not pass through examination & verification.
The online various administration fee of member carrying out service pay examination & verification, comprise service guarantees gold and annual fee pays pipe Reason, in two kinds of situation, one kind is that member passes through to pay online, and another kind is that member passes through manually to pay under line.For the first Situation, should provide the look facility of the situation of paying herein, (implementation method: data is remembered from guarantee fund's payment of platform database It is retrieved in record table qfee table or annual fee payment log yfee table, then bind in display location), and show correspondence in the lump The contact information of subscriber membership or transmit mark and connect, be easy to staff and member contacts communication.For second Kind of situation is usually member by remitting money in the account that website specifies by expenses under line, after staff should pass through herein The payment information record of this member is entered platform database by platform, should by inputting this member operation registration account number be respectively now The contents such as dpid, specified payment volume, amount paid in number, corresponding payment year (can be realized by Input), then Complete to submit to by a submitting button and upload, it is stored in qfee table the data system for guarantee fund's class, for year Expense class data is then stored in yfee table.
With regard to processing member's account charging application, provide filling of member including ordinary consumer member with the service managing class Value application, in two kinds of situation, one kind is that member passes through to supplement with money online, and another kind is that member is supplemented with money by artificial payment under line.Right In the first situation, the look facility of the situation of supplementing with money should be provided, (implementation method: by data from the consumption of platform database herein Person member's finance go out to keep accounts log uinto table or manage the safekeeping account finance of member and go out to keep accounts and examine in log dpinto table Rope out, then display location bind, and carry out multiple data repeat display design).It is usually meeting for second situation By expenses being remitted money in the account that website specifies under line, staff should pass through backstage paying this member to member herein Expense charging information record enters platform database, should be now consumer's class or the operation of operator according to the classification supplementing member with money Account class is registered account number and is by inputting consumer member registration and log in the managerial setup that account number is uid or operator member respectively Dpid, actual supplement number (can realize by Input) with money, then by a submitting button complete submit to upload, Application is supplemented with money for consumer class member and data should be uploaded in the uinto table being stored in platform database, for operation The safekeeping account of person class member is supplemented application with money and is then uploaded data in the dpinto table being stored in platform database.
Withdraw deposit application with regard to processing member, application can be submitted to online using member, manually transfer accounts after webmaster background audit Method, therefore needs to application and associative operation information (the specifying as described in registering account of withdrawing deposit in the working place on backstage Accounts information) shown (for improving safety, the function or link checking that application member's account contact is detailed can be set herein, Staff is allowed can easily to view the account contact situation of application member when feeling the need to), website works When personnel's examination & verification thinks without exception, (also manually can be turned using the fund transfer system outside platform for improving safety by manually transferring accounts Account) to applicant log-on data described in destiny account in, and transfer data is uploaded to the correlation of this platform database In member's account.The display of data of withdrawing deposit in specific implementation, can adopt aforesaid data display method, first show one Application inventory navigation interface, operator clicks on arbitrary application displaying block therein, you can the details jumping to this application show Show interface, this interface shows the detailed content data of application, is additionally provided with this page simultaneously and checks that this application is acknowledged a debt The mark of family contact with link, be easy to operator and check that whether normally the circulation of applicant's account is provided with one simultaneously and " agrees to Withdraw deposit " button.The display of request for data of herein withdrawing deposit is by this application serial number of passing over when navigation redirects Data is retrieved from the pick table of platform database after the dynamic binding of display location search condition display it is intended that account Information is the value of application membership class and uid, dpid field being recorded according to f field in pick table respectively from tables of data u table In ma field (corresponding consumer class member) or dp table acc field (the corresponding service provider member managing class) in retrieval Show after the dynamic binding of display location after out.The display of the applicant's running account information, is according to according to f in pick table The application membership class that field is recorded and the value of uid, dpid field (correspond to consumer's meeting from tables of data uinto table respectively Member), be retrieved in the dpinto table service provider member of class (corresponding manage), carry out dynamic binding in display location laggard Row multiple data repeats display design.When operator click on " agreement is withdrawn deposit " button, system will show in interface and turn Enter account information, click on " determination " button then system by Withdrawal Amount, accept account information, by by membership class and register account Number, the information such as auditor's job number, audit time uploads platform database and is stored in transfer table, and system is in its financial transaction These information are shown, website finance staff executes transfer operation according to these information in the working interface of personnel.
With regard to the examination & verification of travelling products data, operator click in the homepage of work space " travelling products data examine Core " identifies, and page jump arrives such data examination & verification homepage, the pending travelling products navigation information such as on view in this page Block (its search condition can be carried out by the value of tourgoods table f field, such as f=0), clicks on arbitrary navigation block therein Jump to the examination page of this travelling products data, this working page comprises: the display of this product detail information content and Button for review operations: " passing through ", " not passing through ", its implementation examines essentially identical, institute with aforesaid opening application Except for the difference that the table in the platform database of respective operations is the tourgoods table for recording travelling products data herein, its The sequence number of examination & verification this data record by passing over when being redirected by navigation page for the conclusion is No. id and is used as search condition general Conclusion is inserted under the f field name of this record.
With regard to the examination & verification at sight spot and travelling products contingency table, operator click in the homepage of work space " sight spot with Travelling products incidence relation is audited " mark, page jump arrives such data examination & verification homepage, on view etc. pending in this page Incidence relation navigation information block (its search condition can be carried out by the value of tourspot table f field, such as f=0), click on wherein Arbitrary navigation block can jump to this sight spot and travelling products data incidence relation the examination page, this working page Comprise: the display of this incidence relation information content and the button for review operations: " passing through ", " not passing through ", its implementation With aforesaid opening application examine essentially identical, except that the table in the platform database of respective operations is for remembering herein Record sight spot and the table tourspot table of travelling products incidence relation, its examination & verification conclusion is by passing over when being redirected by navigation page This data record sequence number be No. tsid as search condition by conclusion be inserted into this record f field name under.
With regard to plan examination & verification of forming a team, operator click on " examination & verification plan of forming a team " mark, page in the homepage of work space Face jumps to such data examination & verification homepage, on view etc. pending plan navigation information block (its retrieval of forming a team in this page Condition can be carried out by the value of tourteam table flag field, such as f=0), click on arbitrary navigation block therein and can jump to this Form a team the examination page of plan, this working page comprises: the display of details content of this plan of forming a team and be used for examining The button of core operation: " passing through ", " not passing through ", its implementation and aforesaid opening application examination are essentially identical, different It is that the table in the platform database of respective operations is to form a team planning chart tourteam table for recording travelling products herein, its examination & verification The sequence number of this data record by passing over when being redirected by navigation page for the conclusion is No. ttid and is used as search condition and will tie By be inserted into this record flag field name under.
Process consumer, the realization of ISP's complaint, operator click on " complaints department in the homepage of work space Reason " mark, page jump to complaint handling homepage, the pending complaint navigation information block such as on view in this page, it is divided into Webmaster untreated (its search condition can be carried out by the value of complained table f2 field, such as f2=0) and webmaster were processed Autre action pendante (its search condition can be carried out by the value of complained table f2, f3 field, such as f2=1and f3=0) two Part classification is shown, click on arbitrary navigation block therein can jump to this complaint content the examination page, for not locating This working page of the complaint managed comprises: this complaint content, relevant evidence picture, the demand of complainant, defendant reply and throw Tell that the content, complainant that people's information, defendant appeals to webmaster replys the attitude of suggestion, for processing operation to defendant Handling suggestion typing window (being realized with a style frame control) and handling suggestion upload button;For processed but do not tie This working page of the complaint of case comprises: this complaint content, relevant evidence picture, the demand of complainant, defendant reply and complain Content that people's information, defendant appeal to webmaster, complainant defendant is replied the attitude of suggestion, webmaster handling suggestion, Complainant to the statement of webmaster handling suggestion, for process operation handling suggestion editor (being realized with style frame control) and One handling suggestion upload button;The displaying scheme of its information is essentially identical with aforesaid presentation of information, is not repeated herein, this The suggestion upload button at place, after operator clicks on, system then will be processed with sequence number id of this complaint record for retrieval insertion condition Store under mcont field name of this record of complained table of suggestion upload platform database.
Realization with regard to the management of member's mailbox: operator click on " member's mailbox " mark in the homepage of work space, Page jump manages homepage to member's mailbox, letter navigation information block that is on view etc. to be viewed or replying of classifying in this page (its search condition can form data set, the value retrieval of such as read=0, or ans by the value retrieval of tletter table read field Form data set such as ans=0), click on arbitrary navigation block therein and can jump to this letter reading working page, this working page Bread contains: the display of the detailed content of this letter and the button for operation: " reply ", operator clicks on reply button, then return Multiple interface is showed, comprise in replying interface a reply content input interface (can be realized by an Input) and One radio button is used for selecting this mail the need of reply and a submitting button, displaying implementation method of its letter display Show with aforesaid information navigation and click through that detailed interface is essentially identical, except that the platform data of respective operations herein Table in storehouse is record member's mail data tletter table, operator's submission to reply content after writing letter in reply, and system will It uploads to be inserted in, as a new record, the value that in the tletter table of platform database, each field is recorded and be respectively as follows: and transmits Artificial webmaster, value 1 fromuid field record;Receiver is responded the letter people of mail, uses touid field record;Reply Content is the content that typing is entered in text box in replying interface, uses content field record;It is responded the id lid of letter Fields record, letter classification is write letters for webmaster, uses s field record, and f field record value is " by examination & verification ", read field Record value is that 0 expression is not also read by receiver, the value that ans field record radio button selects, and 0 expression needs to reply, 3 expressions Do not need to reply, the value simultaneously being recorded ans field in this record being responded mail is rewritten as 1 expression and has responded to (this is completed with program code to be not required to manually operate by software programmers).In addition the reading working page in letter is opened When, the value note of the read field of this data record being read letter is written as 1 by system automatically, represents this letter by addressee Open and read.
In addition work as webmaster staff and click on " transmitting to this member " mark in its working interface, the page can jump to and transmit Interface.Transmit interface by a letter content typing window, one the need of the radio button replied and a submitting button Composition.During running software, staff inputs letter content in letter typing window, selects reply requirement to click on submitting button and is Can, system now by information content in conjunction with this mail other related data (as No. id of receiver, No. id of addresser be 1, letter Part classification) it is inserted in the tletter table of platform database together as a new record, the value peopleware of each field can Spirit determination with reference to implementation above method.Wherein receiver No. id by click on previous mark " transmitting to this member " when pass Pass.The classification of mail is divided into and transmits class to consumer member and transmit with to service provider member, is clicked on by operator During different working interface, system provides different parameters to determine.
With regard to website, the management of guide is comprised with examination: guide's achievement statistical summaries, market feedback count, to guide's Commend data processing, punish data processing and the execution to this this processing data to conduct a sightseeing tour.Wherein guide's achievement collects, and is Fund in safekeeping account belonging to conducting a sightseeing tour in data base is come in and gone out detail record table dpinto table keep accounts data by given when Between section collected, then cohersive and integrated data is shown in webmaster background work interface, its retrieval collects key code and is:
Select sum (in) as q1from dbo.dpinto where dpid=@dpid and y=@y
Wherein@dpid represents that the operation account number of the guide member being aggregated corresponds to dp table dpid field, and@y table collects the time.
Market feedback counts: mainly counts the statistics that the service that this guide directed is visitor's evaluating data, including right The evaluating data statistics that visitor is recorded to the evaluation table atourserve table of tour-guide's service quality, and visitor's calling information It is related to the part of this guide, its implementation is essentially identical with above-mentioned in complained table.
Bonus data processing to guide: portal management side passes through the examination or temporal events to guide, is determined according to bonus Fixed involved guides, is recorded in the award table that upload is stored in data base for one every time by everyone.
Punishment data processing to guide: portal management side passes through the examination or temporal events to guide, is determined according to punishment Fixed involved guides, is recorded in the punish table that upload is stored in data base for one every time by everyone.
Portal management root, according to the result of appraisal of regular knot guide, will record examination knot for one by by everyone every time simultaneously Fruit data uploads in the examine table being stored in data base, and when being related to adjust guide's foreground ranking value, reply correlation is led The value of the u table oksp field in data base of trip.
The operation module of function above is set in background net management work space.
Those skilled in the art can be understood that technology in the embodiment of the present application can be by software plus necessary General hardware platform mode realizing.Based on such technical scheme understanding in the embodiment of the present application in other words to existing The part that technology contributes can embody in the form of software, and this computer software is desirably integrated into website platform system Among and be deployed to a part of function as web station system among the Internet or the server of mobile Internet to issue, with reality Existing method of the present invention.Visitor then can be by the subscriber terminal equipment of the Internet or mobile Internet such as pc machine, hand-held The online of the equipment such as equipment, mobile unit, television set accesses and includes the website of our law technology to accept net about guide service.
Above-described the application embodiment is only explanation for example to present invention spirit, does not constitute to the application The restriction of protection domain, any modification made within spirit herein and principle, equivalent, supplement and improvement etc. are all Should be included within the application protection domain.

Claims (5)

1. a kind of about guide service of net provides method and data processing equipment, more particularly, to a kind of including a kind of e-commerce website Tourism E-commerce website, comprises display module, on-line payment and the third party of the information such as travelling route, tourist attractions, hotel Connection of payment platform etc.;Described e-business website comprises server, Database Systems, client;Described client It is connected with server, Database Systems;
A kind of net about guide service provide method it is characterized in that:
It is engaged in guide using the modern network platform such as the Internet, mobile Internet, Internet of Things or website (hereafter referred to collectively as website) Practitioner's relevant information is collected or is provided net about guide service;Or realized by below step:
Guide service supplier proposes the net about service request of guide by website or opening formality handled by upload related data; Or online friend can be comprised using network client devices by the Internet, mobile Internet, Internet of Things: pc machine, notebook, flat board The online such as computer, mobile phone, domestic electric appliance, mobile unit accesses the website providing net about guide service or related content, In website into or by navigate into networking about conduct a sightseeing tour content related pages check wherein net about conduct a sightseeing tour correlation tourism set Meal product or organized tour circuit, the data of every guide service person, the qualification letter to the evaluation of its guide service, guide for the visitor Other information on services that breath, net about guide provides, net about guide form a team plan one of content such as its adequate and systematic service information or it Combination in any information, or the offer plan of forming a team of travelling route adding this guide to direct that can also place an order;Or net Friend oneself issues tour plan, throws single online friend by guide and confirms;Or online friend check management the order of oneself, or to oneself Tourist Experience gives opinion or guide service is complained or evaluates;Or guide pass through its work space to oneself Business is managed;Or portal management personnel by background work space net are about conducted a sightseeing tour with practitioner and its related service is carried out Management;
A kind of about guide service of net provides data processing equipment and about conducts a sightseeing tour related data it is characterized in that being provided with net in website Processing meanss comprise: guide's practitioner's information search device, the upload device of tourism guiding service data, tourism guiding service management dress Put, meter of forming a team of going on a tour that conduct a sightseeing tour relative information displaying device, net about guide service product display device, online friend add guide to release Draw the device that places an order, online friend issues plan making device of going on a tour, visitor's accounts of finance managing device, the management dress to tourism guiding service for the website Put, website is to one of managing device etc. of guide or their combination in any;Or be provided with apparatus above related data is carried out The data processing equipment processing;
Wherein:
Guide's practitioner's information search device comprises: guide's practitioner's net about guide service application device or guide's working Personal information collector;
The upload device of tourism guiding service data comprises: the related travelling products set meal data uploading device of guide service and tourism The upload device of the related sight spot of product or the information data such as hotel or cuisines or leisure, guide's plan of forming a team upload device etc. it One or their combination in any;
Tourism guiding service managing device comprises: managing device that guide complains to visitor, guide to the complaint device of uncivil visitor, Guide pays dues one of device, guide's accounts of finance managing device, guide and webmaster mailbox ac equipment etc. or they appoint of withdrawing deposit Meaning combination;
Guide's relative information displaying device comprises: guide's practitioner's qualification or working device for displaying information, services performance information Exhibiting device, visitor evaluate one of exhibiting device, the identity information of guide or contact method exhibiting device etc. or theirs is any Combination;
Net about guide service product display device comprises: net is about conducted a sightseeing tour the travelling products set meal exhibiting device of correlation, related sight spot Exhibiting device, hotel information exhibiting device, cuisines exhibiting device, leisure are travelled the meter of forming a team of device for displaying information, net about guide Draw one of exhibiting device etc. or their combination in any;
Online friend adds the plan of forming a team of the going on a tour device that places an order that guide releases to comprise: online friend joins the Youth League the device that places an order;Visitor is to Shen of joining the Youth League Order management device please;Visitor complain device, visitor to one of evaluating apparatus etc. of service or guide practitioner or they Combination in any;
Online friend issues plan making device of going on a tour and comprises: visitor's plan of going on a tour is collected or display device, guide service supplier throw single report Valency display device, visitor confirm one of device etc. or their combination in any;
Website comprises to the managing device of tourism guiding service: website is to guide's practitioner's title examination or managing device or website To processing meanss that visitor complains etc.;
Website comprises to the managing device of guide: guide's achievement statistical summaries device, market feedback statistic device, guide is praised Prize data processing equipment, to guide punishment one of data processing equipment and the performs device to this this processing data etc. or it Combination in any;
Data processing equipment comprises one of the following or their combination in any: record guide practitioner starts the business registration Information table, the qualification file, picture information record table of application opening, for storing depositing of the corresponding image data of this picture record table Storage file, to manage member's keep accounts enter an item of expenditure in the accounts log, operating unit's finance of request for data log, operating unit's finance of withdrawing deposit fixed Phase account balance data message log, guide's practitioner's opening annual fee pay situation log, guide's practitioner's opening Service guarantees gold pay information record table, net about conduct a sightseeing tour travelling products set meal data logger or store this table correspond to picture or many The file of media data data, record sight spot and service product contingency table, net about conduct a sightseeing tour travelling products form a team plan log, The sight spot related to net about guide service or hotel details picture or multimedia data information log or corresponding with this table Picture multimedia document data record folder, guide practitioner be directed to consumer initiate guide offer throwing forms data record It is that net is about conducted a sightseeing tour order record table, visitor and guide's calling information and process that table, online friend add net about guide application information of forming a team Situation data logger and the file complaining related evidence picture data message log or storage relevant evidence image data Folder, visitor to the evaluating data information record table of study of tourism itinerary production, visitor to the service quality evaluation log of net about guide, Member's mailbox mail data logger, visitor member's finance keep accounts enter an item of expenditure in the accounts log, visitor member finance fixed account remaining sum number According to information table, website to the examination data table of every net about guides, the punishment log of net about guide, net about guide good Prize log etc.;
Or show or be stored with site databases one of following data message or its combination in any number at website client end It is believed that breath: the tourism that the Professional qualification of net about guide service person, work experience, evaluation information data are about conducted a sightseeing tour related to net is produced Product package information data, plan information data of forming a team, the service content information data that it is provided that net is about conducted a sightseeing tour, the ordering of net about guide The tour plan data that forms data, online friend provide;Single information data etc. is thrown in the plan of going on a tour that guide is directed to online friend.
2. guide's its feature of practitioner's information search or be as claimed in claim 1: or in consumer user end or movement On device display screen, setting guide's practitioner's relevant information typing window or interface or information are submitted function to or are provided with Guide's practitioner's authentication information or related certificate or the picture of qualification file or the upload device of multi-medium data.
3. online friend as claimed in claim 1 checks management its feature of the order of oneself or is its content or comprises following interior One of appearance or their combination in any: check order, cancel the order of oneself, edit the order of oneself, the order of oneself is disappeared Take the evaluation of experience and sharing of sense of reality, client is carried out in complaint and complaint and feedback etc. to the unhappiness occurring in consumption Hold.
4. guide as claimed in claim 1 is managed its feature or in the inner by its work space to the business of oneself Hold or comprise one of herein below or their combination in any: guide service business datum uploads, processes visitor's complaint, complains Uncivil visitor, accounts of finance management exchange mailbox, order management etc. with webmaster or visitor;
Wherein:
Guide service business datum uploads and comprises one of the following or their combination in any: in vacation packages product data Biography, the vacation packages product information to upload safeguard the upload to edit-modify, the sight spot related to product or hotel information Or safeguard edit-modify, the upload of plan of forming a team for set meal product or safeguard edit-modify, plan relevant information exhibition of forming a team Show and browse;
Process visitor and complain and comprise one of the following or their combination in any: display is complained related content, returned to complainant Multiple apology, explain the situation to portal management side or appeal or transfer accounts reimbursement etc. to complainant;Or navigated by guider Enter the complaint handling page or interface;
Accounts of finance management comprises one of the following or their combination in any: transaction details record or query display, account Remaining sum record or query display, pay dues, withdraw deposit and transfer accounts;
Order management comprises one of the following or their combination in any: examination & verification process visitor join the Youth League application, check meter of forming a team Draw visitor's registration situation, competition for orders etc..
5. portal management personnel as claimed in claim 1 are about conducted a sightseeing tour to net practitioner and its correlation by background work space Business is managed its feature or is to comprise one of the following or their combination in any: guides's opening application is examined Core, the online various administration fee of member carrying out service pay examination & verification, process member's account charging application, process member withdraws deposit Application, the examination & verification of the examination & verification of travelling products data, sight spot and travelling products contingency table, the plan of forming a team are audited, member's mailbox manages, Process consumer to complain, process the complaint to uncivil visitor, website to the management conducted a sightseeing tour and checking device etc..
CN201610777723.1A 2016-07-01 2016-08-29 Online-booking tourist guide service providing method and data processing device Pending CN106355260A (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201610527500.XA CN105956679A (en) 2016-07-01 2016-07-01 Network booking tour guide service providing method
CN201610527500X 2016-07-01

Publications (1)

Publication Number Publication Date
CN106355260A true CN106355260A (en) 2017-01-25

Family

ID=56899562

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201610527500.XA Pending CN105956679A (en) 2016-07-01 2016-07-01 Network booking tour guide service providing method
CN201610777723.1A Pending CN106355260A (en) 2016-07-01 2016-08-29 Online-booking tourist guide service providing method and data processing device

Family Applications Before (1)

Application Number Title Priority Date Filing Date
CN201610527500.XA Pending CN105956679A (en) 2016-07-01 2016-07-01 Network booking tour guide service providing method

Country Status (1)

Country Link
CN (2) CN105956679A (en)

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107203610A (en) * 2017-05-13 2017-09-26 邹鑫洋 A kind of resource-sharing data processing equipment and method
CN107239989A (en) * 2017-05-08 2017-10-10 林剑华 The method formed a team with city function passenger travel
CN107330622A (en) * 2017-06-30 2017-11-07 重庆市凤筑科技有限公司 One kind trip uses platform and its application process
CN108011957A (en) * 2017-12-05 2018-05-08 深圳市赛为智能股份有限公司 System and method based on internet reservation tour guide
CN108492217A (en) * 2018-04-14 2018-09-04 曹世雄 A kind of system and method solving tour guide and tourist's supply and demand information matches
CN108985979A (en) * 2018-04-18 2018-12-11 深圳智慧岛知识产权有限公司 A method of intellectual property service is provided based on network
CN108985540A (en) * 2018-04-18 2018-12-11 深圳智慧岛知识产权有限公司 A kind of network-based intellectual property service platform
CN109033366A (en) * 2018-07-26 2018-12-18 陕西科技大学 Sharing experience formula touring system
CN109064357A (en) * 2018-08-22 2018-12-21 潘皓波 A kind of tour guide's recommender system and method in real time
CN110706088A (en) * 2019-09-26 2020-01-17 中电万维信息技术有限责任公司 Charging system and method
CN111967933A (en) * 2020-08-10 2020-11-20 高超轶 Electronic commerce transaction method, readable storage medium and computer equipment
CN114629950A (en) * 2022-03-22 2022-06-14 云游天下(北京)科技有限公司 Intelligent tourism service method, device, storage medium and server

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106447546A (en) * 2016-10-13 2017-02-22 上海懒游网络科技有限公司 O2O-based tourist guide market service system
CN107123071A (en) * 2017-05-23 2017-09-01 合肥昊思云科科技有限公司 A kind of Intelligent campus community activity management method
CN107742207A (en) * 2017-11-01 2018-02-27 江苏鸿信系统集成有限公司 A kind of multidisciplinary distribution method of uniform data
CN109948132A (en) * 2019-03-18 2019-06-28 航天云网科技发展有限责任公司 A kind of data of configuration template make a report on method and system
CN110288213A (en) * 2019-06-14 2019-09-27 武汉合创源科技有限公司 A kind of tourism quality management system and method
CN111080248A (en) * 2019-12-10 2020-04-28 湖北省定制旅游有限公司 Product of tour guide service whole-industry ecological chain transaction platform and construction method thereof

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN205028328U (en) * 2015-07-24 2016-02-10 大连大学 Tourism management system

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN205028328U (en) * 2015-07-24 2016-02-10 大连大学 Tourism management system

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
严晓璐: "开展导游自由执业试点成都打造网约导游平台", 《旅游周刊》 *
姜雪梅: "网上选订导游系统的分析与设计", 《中国优秀硕士学位论文全文数据库信息科技辑(月刊)》 *
李彦琴: "6月起来成都旅游可网购导游可在线预约并支付", 《HTTP://WWW.SOHU.COM/A/75423164_161214》 *
游游君: "当地向导火热招募—商家入驻指南", 《HTTP://YOU.CTRIP.COM/TRAVELS/CHINA110000/2054437.HTML》 *

Cited By (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107239989A (en) * 2017-05-08 2017-10-10 林剑华 The method formed a team with city function passenger travel
CN107203610A (en) * 2017-05-13 2017-09-26 邹鑫洋 A kind of resource-sharing data processing equipment and method
CN107330622A (en) * 2017-06-30 2017-11-07 重庆市凤筑科技有限公司 One kind trip uses platform and its application process
CN108011957A (en) * 2017-12-05 2018-05-08 深圳市赛为智能股份有限公司 System and method based on internet reservation tour guide
CN108492217A (en) * 2018-04-14 2018-09-04 曹世雄 A kind of system and method solving tour guide and tourist's supply and demand information matches
CN108985540A (en) * 2018-04-18 2018-12-11 深圳智慧岛知识产权有限公司 A kind of network-based intellectual property service platform
CN108985979A (en) * 2018-04-18 2018-12-11 深圳智慧岛知识产权有限公司 A method of intellectual property service is provided based on network
CN109033366A (en) * 2018-07-26 2018-12-18 陕西科技大学 Sharing experience formula touring system
CN109033366B (en) * 2018-07-26 2022-05-06 陕西科技大学 Shared experience type tourism system
CN109064357A (en) * 2018-08-22 2018-12-21 潘皓波 A kind of tour guide's recommender system and method in real time
CN109064357B (en) * 2018-08-22 2021-12-07 潘皓波 Real-time tour guide recommendation system and method
CN110706088A (en) * 2019-09-26 2020-01-17 中电万维信息技术有限责任公司 Charging system and method
CN111967933A (en) * 2020-08-10 2020-11-20 高超轶 Electronic commerce transaction method, readable storage medium and computer equipment
CN114629950A (en) * 2022-03-22 2022-06-14 云游天下(北京)科技有限公司 Intelligent tourism service method, device, storage medium and server
WO2023179314A1 (en) * 2022-03-22 2023-09-28 云游天下(北京)科技有限公司 Smart tourism service method and apparatus, and storage medium and server

Also Published As

Publication number Publication date
CN105956679A (en) 2016-09-21

Similar Documents

Publication Publication Date Title
CN106355260A (en) Online-booking tourist guide service providing method and data processing device
CN104408559B (en) A kind of engineering information management system
US8341089B2 (en) Real estate management system and method
JP7373473B2 (en) Accounting processing equipment, accounting processing methods, and accounting processing programs
JP6528070B2 (en) Bookkeeping system
CN115392999A (en) Method and device for utilizing modern network
CN110378816A (en) A kind of implementation method and its system of education complex
US20090070151A1 (en) Advanced integrated data environment
Estêvão et al. Destination management systems: key distinctive functionalities aimed at visitors and destination suppliers
CN109215258A (en) A kind of books multimode system for the distribution of commodities
US8355964B2 (en) Auditor&#39;s toolbox
KR101103334B1 (en) On-line studying abroad service automatic system
CN110796425A (en) Intellectual property transfer and conversion management method, system and storage medium
US20140195390A1 (en) Auditor&#39;s Toolbox
Chandani et al. A Study to Analyze Use of Social Media by Private and Public Sector Banks in India
Qin et al. Knowledge management in sport mega-events: a systematic literature review
KR100541794B1 (en) Method and device for providing account management service
Gstrein et al. Producing eBooks on Demand-A European Library Network
Hoskins The effect of the crisis in scholarly communication on university libraries in South Africa.
CN110326019A (en) Non-standard data management in data management system
CN103337045A (en) Data processing system for wedding planning
Patil et al. Elevating Canteen Management with a Modern Web Solution
Desai et al. Implications of an internet startup entering in a market with low level of technological adoption: case study
CN110751529A (en) Global travel data processing device and method
Giang Le Adoption of E-invoicing in Vietnam: Case: Electricity of Vietnam Group, Danang Power Company

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20170125

RJ01 Rejection of invention patent application after publication