商業(yè)網(wǎng)站客服聊天軟件的設(shè)計與實現(xiàn)-畢業(yè)論文

DESIGNANDIMPLEMENTATIONOFCOMMERCIALCHATTINGSOFTWAREFORCLIENTSERVICEATHESISINCOMPUTERSCIENCEPRESENTEDTOTHEFACULTYOFTHECOLLEGEOFINTERNATIONALZHEJIANGUNIVERSITYOFTECHNOLOGYINFULFILLMENTOFTHEREQUIREMENTSFORTHEDEGREEBACHELOROFSCIENCEINCOMPUTERSCIENCEBYZHUJIAQIJUNE,2010ONMYHONORASAUNIVERSITYSTUDENT,ONTHISASSIGNMENTIHAVENEITHERGIVENNORRECEIVEDUNAUTHORIZEDAIDASDEFINEDBYTHEHONORGUIDELINESFORPAPERSINZJUTCOURSES_ZHUJIAQIAPPROVED_TECHNICALADVISORAPPROVED_IEADVISOR摘要實時信息客服聊天軟件（IM）可以不用考慮使用者的地點，以及它們之間的距離。作為一種最常用的網(wǎng)絡(luò)軟件，IM被看做是一種時尚的聊天工具，它可以衍生出社會成員之間的新型社交關(guān)系。至今，IM是一種在人類歷史長河中最具影響的應(yīng)用之一。如今，商用企業(yè)與非盈利組織已經(jīng)發(fā)行了成千上萬種IM實時信息交流軟件。同時，一種新型的商業(yè)模式電子商務(wù)已經(jīng)被越來越多的人所關(guān)注與接受，這種模式是基于高端網(wǎng)絡(luò)技術(shù)的。然而，對于通常的商用實時信息的市場對于競爭者仍然有市場。本論文研究并實現(xiàn)了一種新型的IM客服軟件，通過網(wǎng)絡(luò)SOCKET通道，在客戶端和服務(wù)器端進(jìn)行高效實時通訊，并從軟件工程的設(shè)計規(guī)范出發(fā)，研究客戶的需求，設(shè)計模塊與功能，最終評估了IM的使用效率和可擴(kuò)展性。關(guān)鍵詞實時信息交流軟件，客服軟件，電子商務(wù)ABSTRACTINSTANTMESSAGINGIMMAKESCOMMUNICATIONIGNOREDISTANCEANDAVAILABLEBETWEENSTRANGERSDESPITEOFTHELOCATIONASTHEMOSTFREQUENTLYUSEDNETWORKSOFTWARE,IMISCONSIDEREDASTHESIGNALOFMODERNCOMMUNICATIONTHATBRINGSANEWRELATIONSHIPINSOCIETYUNTILNOW,IMISTHEMOSTIMPRESSIVECHANGEFORLIVESINHUMANHISTORYNOWADAYS,THEREISHUNDREDSOFIMSOFTWAREPUBLISHEDBYCOMMERCIALORGANIZATIONSORNONPROFITABLEGROUPSATTHESAMETIME,ANEWBUSINESSFORMCALLEDECOMMERCEHASBEENMOREANDMORENOTICEABLEANDPROMISINGTHATBASEDONADVANCEDONLINETECHNOLOGYHOWEVER,THEMARKETFORAREGULARCOMMERCIALINSTANTMESSAGINGSTILLLEFTOPPORTUNITYFORFOLLOWINGCOMPETITORSTHISTHESISINTRODUCESANEWIMANDEVALUATESTHEEFFECTIVENESSOFDESIGNEDIMFROMSOFTWAREENGINEERINGPOINTOFVIEW,THESYSTEMHASBEENDESIGNEDANDANALYZEDCAREFULLY,ANDTESTEDINTHEENDKEYWORDSINSTANTMESSAGINGCHATTINGSOFTWAREELECTRONICCOMMERCE目錄摘要I英文摘要II第一章緒論1第二章選題背景2第三章系統(tǒng)需求分析531用戶組需求分析5311系統(tǒng)管理員5312客服管理員5313客戶632系統(tǒng)服務(wù)分析6321后臺服務(wù)6322前臺服務(wù)7323數(shù)據(jù)庫7324交互界面733功能描述8331服務(wù)終端8332客戶終端8334網(wǎng)站管理后臺8335數(shù)據(jù)庫存儲功能8第四章系統(tǒng)設(shè)計941采用的技術(shù)/標(biāo)準(zhǔn)9411PHP高級編程語言9412MYSQL數(shù)據(jù)庫9413AJAX異步通訊技術(shù)9414HTML網(wǎng)頁編程標(biāo)準(zhǔn)1042系統(tǒng)設(shè)計圖例1043數(shù)據(jù)庫設(shè)計10431數(shù)據(jù)關(guān)系圖例11432數(shù)據(jù)庫選擇11433表格列表11434表格設(shè)計12435數(shù)據(jù)庫數(shù)據(jù)要求14第五章系統(tǒng)實現(xiàn)1751用例圖1752頁面關(guān)系流圖1853系統(tǒng)模塊實現(xiàn)20531高優(yōu)先級準(zhǔn)備20532裝載頁面與運行20533管理員登錄與權(quán)限控制33534管理員后臺管理實現(xiàn)35535客服登錄與實現(xiàn)50536客服交互見面的實現(xiàn)52537客戶交互界面的實現(xiàn)55538浮動窗口實現(xiàn)59總結(jié)6361未解決的問題6362今后的工作6363將來的工作展望64文獻(xiàn)67致謝69附錄70TABLECONTENTABSTRACTINCHINESEIABSTRACTIICHAPTER1INTRODUCTION1CHAPTER2BACKGROUNDINFORMATION2CHAPTER3REQUIREMENTS531USERGROUPANALYSIS5311ADMINISTRATOR5312SERVICESTAFF5313CLIENT632SYSTEMANALYSIS6321BACKSTAGE6322FRONTSERVICE7323DATABASE7324CHATINTERFACE733FUNCTIONDESCRIPTION8331SERVICETERMINAL8332CLIENTTERMINAL8334WEBSITEBACKSTAGE8335DATABASE8CHAPTER4SYSTEMDESIGN941TECHNIQUE/STANDARDUSED9411PHPADVANCEDLANGUAGE9412MYSQLDATABASE9413AJAX9414HTML1042SYSTEMDESIGNDIAGRAM1043DATABASEDESIGN10431ENTITYRELATIONSHIPDIAGRAM11432DATABASECHOOSE11433TABLELIST11434TABLEDESIGN12435DATABASEDATAREQUIREMENT14CHAPTER5IMPLEMENT1751USERCASEDIAGRAM1752RELATIONSHIPOFPAGES1853SYSTEMIMPLEMENT20531PRIORPREPARATION20532INSTALLPAGEANDPROCEEDIMPLEMENT20533ADMINLOGINANDAUTHENTICATEPROCEEDINGIMPLEMENTATION33534ADMINBACKSTAGEMANAGEMENTIMPLEMENT35535SERVICESTAFFLOGININTERFACEIMPLEMENT50536SERVICESTAFFCHATINTERFACEIMPLEMENT52537CLIENTCHATINTERFACEIMPLEMENT55538FLOATWINDOWIMPLEMENT59CONCLUSION6361UNRESOLVEDPROBLEM6362FUTUREWORK6363OUTLOOK64REFERENCE67ACKNOWLEDGE69APPENDIX70CHAPTER1INTRODUCTIONCOMMERCIALINSTANTMESSAGINGISDESIGNEDTOACHIEVEWORKTHATNORMALLY,ITISNOTCONSIDEREDASTHEREALMOFIMORLACKOFAVAILABLECONDITIONSTOREACHTHESAFETYANDLEGALREQUIREMENTSALTHOUGH,“MANYPEOPLEHAVEEXPOSURETOINTERACTIVETEXTPRIMARILYTHROUGHTEENAGEUSERSWHOPRESUMABLYEXCHANGEGOSSIPANDRUMORS,TALKABOUTTHEIRPERSONALLIVES,ANDUSEIMTODOALLTHETHINGSTEENAGERSDO”1,THAT“WORKPLACEEXPECTATIONSARELIKELYTOBEEITHERTHATINTERACTIVETEXTISAWASTEOFTIME,ORPOSSIBLYEVENSOCIALLYUNDESIRABLE”2,THEDEVELOPMENTOFIMSOFTWAREANDTHENEWERWORKPLACEENVIRONMENTBEGANTOACCEPTTHISNEWTECHNOLOGYASAUSEFULTOOLINCOMMUNICATIONINADDITION,THEREARETWOKEYFACTORSIDENTIFIEDASQUALITYFORACCEPTATIONINLARGENUMBEROFUSERSBYMARKUS“FIRST,USERSMUSTCHOOSETOABSORBCERTAINCOSTSASSOCIATEDWITHUSE”“SECOND,THEREMUSTBEINITIALVARIATIONINUSERSABILITIESTOCONTRIBUTETOANDBENEFITFROMUSEOFINTERACTIVECOMMUNICATIONSYSTEMS”3THEREFORE,THESETEENAGERSWHOARESEEMEDASFUTURERULERSOFTHEWORLD,BEINGINTERESTEDINIMORUSEIMASPARTOFLIFE,WILLBETHEPOTENTIALCLIENTOFIMINWORKPLACETHELATESTNEWSSHOWSTHATRESEARCHTEAMSISLOOKINGFORASUITABLEANDAVAILABLECOMMUNICATIONTOOLSTOOVERCOMETHEINCONVENIENCEBROUGHTBYMISTRUSTANDGAP,PARTICULARLY,WHENTHEPROJECTNEEDSQUICKRESPONDANDFREQUENTLYCOMMUNICATIONITISHARDTOSAYCOMMERCIALINSTANTMESSAGINGISTHEIRBESTCHOICEORTHEPEAKOFREVOLUTIONOFWORKHOWEVER,THISSOFTWARECANMAKEPROMOTIONFORDEVELOPMENTOFCOMMUNICATIONINWORKPLACEPOSSIBLEANDFACILITATETHISTYPEOFRESEARCHINTHISARTICLE,ITWILLFOCUSONTHEISSUEFACEDBYMODERNOFFICERS,PROJECTDESIGNEDTOSOLVETHESEPROBLEMS,REQUIREMENTFORCLIENT,SOFTWAREIMPLEMENTANDFURTHERRESEARCHONCOMMERCIALINSTANTMESSAGINGCHAPTER2BACKGROUNDINFORMATIONINSTANTMESSAGINGWASCREATEDINJULYOF1996BY4YOUNGISRAELIAVIDCOMPUTERUSERSYAIRGOLDFINGER26,CHIEFTECHNOLOGYOFFICER,ARIKVARDI27,CHIEFEXECUTIVEOFFICER,SEFIVIGISER25,PRESIDENT,ANDAMNONAMIR24,STARTEDACOMPANYCALLEDMIRABILISINORDERTOINTRODUCEANEWWAYOFCOMMUNICATIONOVERTHEINTERNETTHESEGUYSREALIZEDTHATMILLIONSOFPEOPLEWERECONNECTINGTOTHEINTERNETTOUSETHEWORLDWIDEWEB,BUTTHESEUSERSWERENOTINTERCONNECTEDTHEYCREATEDATECHNOLOGYWHICHWOULDENABLEINTERNETUSERSTOLOCATEEACHOTHERONLINEONTHEINTERNET,ANDTOCREATEPEERTOPEERCOMMUNICATIONCHANNELSEASILYTHEYCALLEDTHEIRTECHNOLOGYICQ,ISEEKYOUANDRELEASEDITINNOVEMBEROF1996SEEFIGURE21FIGURE21WITHIN6MONTHS,BY“WORDOFMOUSE“,850,000USERSHADBEENREGISTEREDBYMIRABILISBYJUNEOF1997,MIRABILISWASABLETOHANDLE100,000CONCURRENTUSERSANDHADBECOMETHELARGESTINTERNETCOMMUNICATIONSNETWORKMICROSOFTHADALSOCREATEDITSOWNINSTANTMESSAGINGCLIENTANDSERVICE,MSNMESSENGER,ANDANOTHERINTERNETHEAVYWEIGHT,YAHOOCREATEDONEASWELLBECAUSEIMSERVICESEVOLVEDFROMPROPRIETARYSYSTEMSCREATEDBYCOMPANIESTOMAKEAPROFIT,THEIRSYSTEMSREMAINUNABLETOINTEROPERATEBECAUSEOFTHEDESIRETOCONTROLTHEIMMARKETAOLANDICQ,EVENTHOUGHTHEYAREOWNEDBYTHESAMECOMPANY,ARENOTINTEROPERABLENOTLONGAFTERICQESTABLISHEDTHEPOPULARITYOFIM,AOLDECIDEDTOENTERTHEFRAYWITHINAVERYSHORTTIME,AOLINSTANTMESSENGERAIMSUPPLANTEDICQASTHELEADINGIMUTILITYSEEFIGURE22FIGURE22OTHERCOMPANIESHAVETAKENADIFFERENTAPPROACHRATHERTHANWAITFORANAGREEDUPONSTANDARDJABBERISONECOMPANYTHATHASCREATEDACLIENTPROGRAMCAPABLEOFCOMMUNICATINGWITHVARIOUSIMSYSTEMSINCHINA,THEMOSTPOPULAROFIMISQQPUBLISHEDBYTENCENTCOMPANYINFEBRUARY,1999OVER160,000,000USERSHAVEREGISTEREDANDAROUND2,000,000USERSONLINEATTHESAMETIMEWITHITSATTRACTINGMODELANDCONVENIENTMANIPULATION,THEYOUNGPEOPLESTARTEDQQFIRSTLYWHENTHENOPENTHEIRPERSONALCOMPUTERANDMOREANDMOREEMPLOYEESAREJOININGTHISGAMESEEFIGURE23FIGURE23SAMETIMESIMCOMPONENTISASUCCESSFUL“WALKUPANDUSE”APPLICATION,REQUIRINGLITTLEDOCUMENTATIONANDNOTRAININGUSERSACHIEVEACOMMERCIALLYSIGNIFICANTLEVELOFPERFORMANCEWITHINTHREEMONTHS,ASSHOWNBYSAVINGSINTHEUSEOFOTHERCOMMUNICATIONCHANNELS4HOWEVER,QQANDOTHERINSTANTMESSAGINGSOFTWARESTILLSTOPPEDBEFOREBEINGAFORMALCOMMERCIALTOOLANDTHOUGHUSERSHAVEGOODIMPRESSIONONIT,TRADITIONALINSTANTMESSAGINGDONOTHAVEROLEINMOREOFFICIALPLACEITISNOWANDERTHATANYTEXTTRANSMITTINGVIAUNSAFENETWORKBYNONENCRYPTEDAPPROACHWILLBECHALLENGEDBYMODERNTHREATSSUCHASNETWORKTAPPING,ILLEGALTAMPERINGORMALICIOUSINTERCEPTINGSOTHATTHETEXTCANNOTCONTAINVALUABLEINFORMATIONBESIDES,ARECORDFROMINSTANTMESSAGINGCANNOTBESTRONGEVIDENCEWHATEVERHOWITSEEMEDPROMISINGANDCONVINCINGONTHECOURTFOREXAMPLE,ADEFAULTCLIENTWHOBROKETHECONTRACTANDVIOLATETHESPIRITOFCOMMENCEWILLNOTBEFOUNDGUILTBYPROVIDINGTEXTFROMINSTANTMESSAGINGBETWEENCLIENTANDPRODUCERTHESEDEFECTSMAKEINSTANTMESSAGINGDWELLONTHEENTERTAINMENTGATETOOFFICIALPALACEANDMAKEUSERSBELIEVEINSTANTMESSAGINGWILLDEVELOPVARIOUSMODELSANDVISUALEFFECTSRATHERCLIMBINGINTOAHIGHERLEVELCHAPTER3REQUIREMENTS31USERGROUPANALYSIS311ADMINISTRATORANADMINISTRATORISTHEORIGINALPERSONWHOFOUNDEDTHESYSTEMANDCONSTRUCTTHEWEBSITEFORPROVIDINGCERTAINSERVICEANDHASRIGHTTOMODIFYORMAINTAINTHESYSTEMINCOMMERCIALINSTANTMESSAGING,ANADMINCANINSTALLSYSTEMONSERVER,MODIFYEXISTDATAANDADD/DELETESERVICESTAFFVIAITSOWNBACKSTAGEPAGEBYENTERINGCORRECTPASSWORDASTHEFUNDAMENTALOFFICER,ANADMINHASTHEHIGHESTPERMISSIONINSYSTEMTHEBOSSORCHAIRMANONBOARDMAYNOTBEAPROPERCANDIDATEOFADMINISTRATORBECAUSEOFREQUESTOFPROFESSIONALKNOWLEDGEOFCOMPUTERSCIENCEANDNETWORKNORMALLY,TECHNICALDIRECTORISTHEADMINCONSIDEREDHISORHERABILITYOFMANIPULATINGCOMPUTER312SERVICESTAFFTHEREISNODOUBTTHATSERVICESTAFFSARETHEDIRECTSERVICEPROVIDERSFACEDCLIENTEVERYSERVICESTAFFHASAUNIQUEIDINCOMMERCIALINSTANTMESSAGINGSYSTEMANDTHEYAREDIVIDEDINTOBELONGEDSERVICEGROUPSUCHASTECHNICALSERVICE,PRODUCTCONSULTINGORPROBLEMREPORTINGASERVICESTAFFCANLOGONBYENTERINGCORRECTIDANDPASSWORDTOOPENTHECHATINTERFACEWHENONEOFCLIENTACTIVATESSELECTEDSERVICESTAFF,ACHATINTERFACEWILLBEDISPLAYEDTOPROVIDECHATENVIRONMENTDURINGCHAT,SERVICESTAFFCANTRANSMITFILESORPICTURETOCLIENTUNLIKETHEADMINISTRATOR,SERVICESTAFFCANNOTENTERBACKSTAGEPAGETOMODIFYITSINFORMATIONWHICHCANONLYBECHANGEDBYADMINGOODSERVICESTAFFSHOULDBEFAMILIARWITHINFORMATIONOFCOMPANYANDHAVEHIGHPROFESSIONALISMDIFFERFROMUSUALSERVICESTAFF,ONLINESERVICESTAFFDONOTHAVEREQUESTOFCLOTHESMAYBEHAVE,BUTCLIENTCANNOTSEETHESPEEDOFTYPINGBECOMESANIMPORTANTVOCATIONALSKILLTOAVOIDWASTINGTIMESOTHATCLIENTWILLNOTBEIMPATIENTUNDERTIMECONSUMINGWAITING313CLIENTEACHVISITORWHOREADWEBPAGEWILLBECONSIDEREDASACLIENTANDBEACCEPTEDWHENVISITORACTIVATEDASERVICESTAFFTOSTARTBYCLICKINGONEOFSERVICESTAFFSINDIFFERENTGROUPS,CLIENTWILLBEDISPLAYEDACHATINTERFACEWHICHISSIMILARWITHSERVICESTAFFSONESOTHATCLIENTCANCOMMUNICATEWITHSELECTEDSERVICESTAFFANYOFFLINESERVICESTAFFCANNOTBEACTIVATED32SYSTEMANALYSIS321BACKSTAGETOMANAGECOMMERCIALINSTANTMESSAGING,THEREWILLBEABACKSTAGEFORADMINTOMODIFYINFORMATIONTRADITIONALLY,ABACKSTAGEPAGEORANYOTHERMANAGEMENTPAGEISCONTROLLEDBYADMINANDISINSTALLEDONSERVERTHATBEENSUREDTOAVOIDANYTYPEOFTHREATSTHELOGWINDOWNEEDSVISITORENTERCORRECTIDANDPASSWORDTOCONTINUEIFADMINENTERBACKSTAGEPAGESUCCESSFULLY,BACKSTAGEPAGEWILLSHOWSEVERALCOLUMNSTHATCONTAINSYSTEMINFORMATIONWHICHWILLINFLUENCETHEWHOLEINSTANTMESSAGINGSYSTEMFORCHANGINGBASICSETTING,SERVICESTAFFMANAGEMENTANDSERVICESTAFFGROUPMANAGEMENTINTHEBASICSETTINGCOLUMN,THEREISWEBSITEPATH,ADMINCOOKIETIME,SWITCHINSTANTMESSAGINGSTATUS,TITLE,TIMEFORMAT,TYPEOFCONNECTIONTODATABASEANDTIMEFORKEEPINGRECORDSIFADMINCHANGEANYCONTENTOFCOLUMNS,THESECHANGESWILLBEACTIVATEDAFTERADMINCLICKING“SAVECHANGE”BUTTONINTHESERVICESTAFFMANAGEMENTCOLUMN,THEREISALISTOFEXISTSERVICESTAFFSWITHTHEIRBELONGINGSERVICEGROUP,STATUS,TITLEANDNECESSARYINFORMATIONADMINCANCHANGETHESEDATAFORFURTHERMODIFICATION,ADMINCANCLICKSERVICESTAFFSNAMETOCHANGEHISORHERUSERNAME,PASSWORDANDFRONTNAMEEACHCHANGEWILLBEACTIVATEDAFTERCLICKING“SAVECHANGE”BUTTONTOADDANEWSERVICESTAFF,ADMINNEEDSCLICK“ADDUSER”BUTTONANDFOLLOWSINSTRUCTIONTOCOMPLETEPROCEEDINTHESERVICESTAFFGROUPMANAGEMENTCOLUMN,THEREISALISTOFEXISTSERVICESTAFFGROUPSWITHTHEIRNAMEANDSTATUSADMINCANCHANGETHESEDATATOADDANEWSERVICESTAFFGROUP,ADMINNEEDSTOENTERNEWSERVICESTAFFGROUPNAMEINBLANKANDCLICK“CREATEGROUP”BUTTONEACHCHANGEWILLBEACTIVATEDAFTERCLICKING“SAVECHANGE”BUTTON322FRONTSERVICEAFRONTSERVICEISAFLOATWINDOWAPPEAREDWITHVISITORSACTIONONTHEPAGETHEFRONTSERVICENEEDSTOBECONSPICUOUSANDINDEPENDENTFROMTHECONTENTOFWEBPAGEALSO,THEFRONTSERVICENEEDSTOSHOWALLSERVICESTAFFSWITHBELONGINGSERVICESTAFFGROUPSALLONLINESERVICESTAFFNAMEWILLBELIGHTEDANDBEPERMITTEDTOACTIVATE,OTHERWISETHEOFFLINESERVICESTAFFCANNOTBEACTIVATEDAFTERCLICKINGSELECTEDSERVICESTAFF,ACHATINTERFACESHOULDBESHOWN323DATABASETHEDATABASEISTHEKEYSYSTEMTHATPLAYSAMEDIUMROLEININSTANTMESSAGINGFORBACKSTAGE,ITPROVIDESMANAGEMENTDATAANDRECORDSCHANGESFORSERVICESTAFF,ITKEEPSLOGINFORMATIONANDRECORDSTEXTBETWEENSTAFFANDCLIENTFORBUDGET,ITISRECOMMENDEDTOUSEMYSQLDATABASESYSTEMFORBACKSTAGEDATABASES324CHATINTERFACECHATINTERFACEISTHECOMMUNICATIONENVIRONMENTTHATPROVIDESPLATFORMFORCLIENTANDSTAFFSITSHOULDCONTAINAZONEFORDISPLAYTEXTFROMBOTHSIDESANDABLANKZONEFORENTERINGTEXTBESIDES,CHATINTERFACESHOULDSHOWTHENUMBEROFTALKINGCLIENTSCLIENTCHATINTERFACEANDSERVICESTAFFCHATINTERFACEHAVELITTLEDIFFERENCECLIENTCHATINTERFACECANNOTSAVERECORDS,WHILESERVICESTAFFCHATINTERFACECANSAVETEXTRECORDSFORCONSIDERATION33FUNCTIONDESCRIPTION331SERVICETERMINALBEFOREASERVICESTAFFENTERSHISCHATINTERFACE,HEISREQUIREDTOCHECKHISIDANDPASSWORDUNDERTHISINTERFACE,THESERVICESTAFFISABLETOCHATWITHCLIENTWHOREQUIRESFORHISORHERSERVICEDURINGTHECHAT,SERVICESTAFFSHAVEABILITYTOSENDORRECEIVETEXT,PICTURE,SMALLAMOUNTOFANIMATIONANDFOLDERS332CLIENTTERMINALTHISINTERFACESEEMSSIMILARTOSERVICECHATINTERFACEBECAUSEOFTHEIRSIMILARFUNCTIONSPROVIDEDHOWEVER,THEREAREMORELIMITATIONSONCLIENTCHATINTERFACECONSIDEREDSERVICECHATSTAFFSMAXIMUMCAPACITYFORHANDLINGWITHDIFFERENTCLIENTSATONETIMETOENSURETHEPERFORMANCEOFSERVICETERMINAL,CLIENTCANNOTSENDLARGEFOLDERSORPICTURES,AVOIDINGHEAVYLOADONSERVICETERMINALBESIDES,THEREISNONEEDFORCLIENTTOSAVEINFORMATIONABOUTANYSERVICESTAFF,SOCLIENTCHATINTERFACEWILLNOTPROVIDESAVINGFUNCTIONANDHEORSHEHASNOTACORRESPONDINGBACKSTAGEFORFURTHERMODIFICATION334WEBSITEBACKSTAGETHISBACKSTAGEISUSEDFORMANAGINGINFORMATIONABOUTSTAFFANDOWNERATTHISPAGE,THEADMINISTRATORCANMANAGESERVICEGROUP,SERVICESTAFFANDSYSTEMSETTING335DATABASEALLINFORMATIONABOUTSERVICESTAFFS,OWNERANDCLIENTSWILLBESAVEDINDATABASETHATINSTALLEDONTHESERVERCHAPTER4SYSTEMDESIGN41TECHNIQUE/STANDARDUSED411PHPADVANCEDLANGUAGEPHPISAWIDELYUSED,GENERALPURPOSESCRIPTINGLANGUAGETHATWASORIGINALLYDESIGNEDFORWEBDEVELOPMENTTOPRODUCEDYNAMICWEBPAGESPHPLANGUAGESYNTAXCOMBINEDC,JAVA,PERLANDITSOWNRULESITHASQUICKERSPEEDWHENPRECEDEDYNAMICWEBPAGESCOMPARINGWITHCGIANDPERLBECAUSEPHPPROGRAMISEMBEDDEDINTOHTMLFILESOTHATITHASHIGHEREXECUTINGEFFICIENCYTHELATESTVERSIONIS532PUBLISHEDONMARCH4TH,2010412MYSQLDATABASEMYSQLISARELATIONALDATABASEMANAGEMENTSYSTEMRDBMSTHATRUNSASASERVERPROVIDINGMULTIUSERACCESSTOANUMBEROFDATABASESMYSQLISPROGRAMMEDBYCANDCITSUPPORTSVARIOUSOPERATIONSYSTEMSSUCHASFREEBSD,MACOSORSOLARISCOMPARINGTOOTHERLARGEDATABASESYSTEM,MYSQLISCHEAPERANDQUICKERBECAUSEOFITSOPENSOURCEFEATURE,MANYSMALLCOMPANIESANDPEOPLECHOOSEITFORKEEPINGDATATHELATESTVERSIONIS51RELEASEDONNOV27TH,2008413AJAXAJAXSHORTHANDFORASYNCHRONOUSJAVASCRIPTANDXMLISAGROUPOFINTERRELATEDWEBDEVELOPMENTTECHNIQUESUSEDONTHECLIENTSIDETOCREATEINTERACTIVEWEBAPPLICATIONSWITHAJAX,WEBAPPLICATIONSCANRETRIEVEDATAFROMTHESERVERASYNCHRONOUSLYINTHEBACKGROUNDWITHOUTINTERFERINGWITHTHEDISPLAYANDBEHAVIOROFTHEEXISTINGPAGE414HTMLHTML,WHICHSTANDSFORHYPERTEXTMARKUPLANGUAGE,ISTHEPREDOMINANTMARKUPLANGUAGEFORWEBPAGESTHEPURPOSEOFDESIGNINGHTMLISTOCONNECTFILESORIMAGESINTWOCOMPUTERSHTMLISANEASYANDGENERALLANGUAGETHATALLOWSMAKERSCONSTRUCTCONNECTIONBETWEENFILESANDIMAGESANOTHERADVANTAGEOFUSINGHTMLISHISINDEPENDENCESOTHATANYVISITORSCANREADPAGEWITHOUTCONSIDERINGTHEIROPERATINGSYSTEMS42SYSTEMDESIGNDIAGRAMTHESYSTEMDESIGNDIAGRAMISATTACHEDINTHEFOLLOWINGFIGURE41THECLIENT,SERVER,INCLUDINGSERVICESTAFFANDADMINARECONNECTEDANDCOMMUNICATEDEFFICIENTLYFIG4143DATABASEDESIGNTHEDATABASEPLAYSAVERYCENTRALROLEINTHECOMMERCIALINSTANTMESSAGINGSYSTEMALLINFORMATIONABOUTTEXT,OBJECTSANDIDENTIFICATIONDATAARESTOREDINTHEDATABASEANDWHENTHESEINFORMATIONNEEDFORCOMPUTING,THEYMUSTBEEASILYANDQUICKLYDEPLOYEDFROMTHEDATABASETHEREARETWOTHINGSWORTHCONSIDERINGTHOUGHTFULLYWHENDESIGNDATABASEFORTHISSYSTEMFIRSTOFALL,THERELATIONSHIPOFEACHCOMPONENTOROBJECTSHOULDBEMAINTAINEDCAREFULLYANDENSURETHEYNEVERBEMODIFIEDBYMALICIOUSORNONVERIFIEDPERSONTHESECONDTHINGISTHEDATASHOULDBEREADANDWRITEASQUICKLYASPOSSIBLESOTHATCLIENTWILLNOTLOSEPATIENTBEFOREREACHINGANAGREEMENT431ENTITYRELATIONSHIPDIAGRAMTHEFOLLOWINGDIAGRAMSHOWSTHEENTITYRELATIONSHIPOFEACHPARTINTHEDATABASE432DATABASECHOOSEINCOMMERCIALINSTANTMESSAGINGSYSTEM,ITISRECOMMENDEDTOCHOOSEMYSQLASTHEDATABASEBECAUSEMYSQLISOPENSOURCESOFTWARE,ITWILLSAVELOTSOFMONEYANDITSPERFORMANCECANFULFILLITSDUTYINTHESYSTEMASPEOPLEKNOWN,MYSQLISNOTASOUTSTANDINGASORACLEORMICROSOFTSQLINBOTHQUERYSPEEDANDDATACAPABILITYHOWEVER,ITISGOODENOUGHFORTHISSYSTEMTHEMOSTIMPORTANTREASONFORCHOOSINGMYSQLDATABASEISTHATITHASWELLPERFORMANCETOACCOMPLISHTASKSBUTITISEXPENSIVETOUSEORACLEORMICROSOFTSQL433TABLELIST1USERGROUPSTABLETHISTABLEISUSEDTOSTORESERVICEGROUPSINFORMATIONTHATCREATEDBYADMINITCONTAINSSEVERALCOLUMNSUSERGROUPID,DISPLAYORDER,GROUPNAMEANDACTIVATEDSTATUS2LINESTABLETHISTABLESTORESTHEMESSAGEBETWEENCLIENTANDSERVICETERMINALINTHISTABLE,ITCONTAINSLINE_ID,FROM_ID,TO_ID,FROM_NAME,TO_NAME,LINE_STAMP,LINE_TEXTANDLINE_CLR3MAINSETTINGSTABLEINTHISTABLE,ITSTORESTHESYSTEMSETTINGANDSYSTEMPARAMETERSANYMODIFICATIONONSYSTEMINADMINBACKSTAGEPAGEWILLBESAVEDINTHISTABLEITCONTAINSSETTINGID,VARNAME,GROUPNAME,INPUT,TITLE,DESCRIPTIONANDVALUECOLUMNS4SESSIONSTABLETHISTABLESTORESTHEINFORMATIONOFUSERSFORSESSIONITCONTAINSSESSIONID,USERID,IPADDRESS,USERAGENT,LASTACTIVITY,LOCATION,LOGGEDIN,ADMINCOLUMNS5USERSTABLETHISTABLESTORESTHESERVICESTAFFINFORMATIONITCONTAINSUSERID,USERGROUP,DISPLAYORDER,USERNAME,PASSWORDENCRYPTED,ACTIVATED,ISONLINE,USERFRONTNAME,ISADMINANDLASTACTIVATYCOLUMNS434TABLEDESIGN1TABLEPREFIX_LINESLINE_IDFROM_IDFROM_NAMELINE_STAMPLINE_TXTLINE_BIULINE_CLRTO_IDTO_NAMETHISISATABLETOSTORETHETEXTSENTBYCLIENTANDSERVICESTAFFEACHOFTEXTHASAUNIQUENUMBERFORDISTINGUISHINGANDBEMARKEDBYSENDERSIDANDNAMEITALSOHASASTAMPTONOTICETHETIMETHATWHENTHISMESSAGESENDTOREACHTHERECIPIENT,THEMESSAGEHASRECIPIENTSIDANDNAME2TABLEPREFIX_MAINSETTINGSSETTINGIDVARNAMEGROUPNAMEINPUTTITLEDESCRIPTIONVALUETHISTABLEISUSEDFORSTORINGTHESYSTEMSETTINGINFORMATIONFORDISPLAYORDER,EACHSETTINGITEMHASANASCENDINGNUMBERTOSHOWITSDISPLAYORDERINTHESYSTEMSETTINGMANAGEMENTPAGETHECOLUMNNAMEOFSETTINGITEMISSTOREDINVARNAMECOLUMNGROUPNAMECOLUMNISUSEDFORSEARCHINGNEEDEDITEMINPUTCOLUMNSHOWSTHETEXTTYPEOFINPUTBYADMINTHENAMEOFSETTINGITEMISSTOREDINTITLECOLUMNANDDESCRIPTIONCOLUMNSHOWSTHEBRIEFOFEACHITEMLASTCOLUMNISTHECONTENTOFSYSTEMSETTINGSAVEDINDATABASESOTHATSYSTEMUSESTHESETOPERFORMANCE3TABLEPREFIX_ONLINEUSR_IDUSR_NAMEUSR_IPRTIMEISBANEDISKICKOUTEDISSERVICEMANSERVICEMAN_IDONLINETABLEISUSEDFORSTORINGTHEONLINEUSERSINFORMATIONUSR_IDCOLUMNSTOREDTHEUSERSIDTHATEACHSERVICESTAFFHASAFIXEDNUMBERWHICHCANBESHOWNINUSERSTABLEUSR_NAMECOLUMNINDICATESTHENAMEOFEACHUSERUSR_IPSHOWSLOGICALADDRESSIPADDRES