NMA Application Report
Contents
1. Nurse Skills Owners In Patient Add Misc View Misc Schedule inPatientManage Add Bed Clinic Beds addMisc Add Allergy Add illness Add Surgery Type miscManage Allergy Illness Surgery Types schedule Add Shift Schedule Shift Admit To Admitted Add Surgery Skill Add Corporation Add Clinic Surgery Skills Corporations Clinics View Schedule Schedule Surgery Update Physician Update Nurse Add Medication Add Med Reaction Add Surgery Require Medications Med Reactions Surgery Req Skills Schedule This table breaks up the applications front end home page into the different links that allow the user to provide input for new employees new nurses new patients it also provides for the user the ability to view table data such as view Nurse and view Patients The front end divides the different functionality input output into separate pages so that the user can input data for any given entity from the same menu option or vice a versa view any information about a given entity This design feature is to simplify the page layout into obvious and specific functions that directly tie into the folder and asset hierarchy This allows a developer to easily navigate to and update a piece of code from any asset that makes up the application easily and in exactly the same way for the different entities Type 1 There are three basic front end php files The2. 5 The following is the next basic functionality provided by the website All information from a table is provided for the user by populating a table located within the html page To access any one of this table a user simply clicks a button akin to those shown in the previous image Upon doing so the user will be sent to a page similar to the own displayed below Certain tables provide the user with the ability to update the data in the table Such functionality is evident through the provided submit button that isn t absent in most read only tables
3. css file in order to be stylized according to the applications theme Furthermore the table allows a user to directly alter the data located in the table by placing the created table within a form whose submit button is placed in the column of the table This form unlike the others previously used sends data to the php files using a get method The reason is this allowed me to directly name the variable would be sending to the php file In this case send the variable code which is the Nurses User Id The id is sent to a php filed called deleteNurse and this uses the code to delete the entity that whose id matches it Another similar cases updates the information rather than the deletes it The two sql statements are listed next In order to delete Scode GET code n mysql query delete from nurse where nurseldCode Scode or die mysql error Using an sql set in order to alter data Spnum getSafeData S POST id Snurse getSafeData S_POST nurse Ss update patient set attendingNurseld Snurse where pnum Spnum mysql_query s or print mysql_error Javascript Menu PopUp This script simply works like a switch and turns table visibility off if already on or on if already off The form displayed or hidden depends on which form the user wants to see The id of which is sent to the script via a variable id to the js function Display id hidding previous form document
4. first and the simplest type only provide the user with a list of form options through which they can input data For example the php file for addPatient php contains the following code lt div id selection class height gt lt h2 gt Select Form lt h2 gt lt table id table border 1 gt lt tr gt lt th gt lt input class button type button value Add Allergy onclick Display allergyForm gt lt th gt lt tr gt lt table gt lt div gt A typical front end php file contains two parts the first part is the div which shows the users the different forms that they can pick to view Upon loading the page all forms are rendered hidden The way to make the forms visible is through the javascript file nmaButton This javascript file is in charge of displaying the form the user wants to view based on which button he pressed The file is also charge of hiding any forms that had been previously viewed Html is not a dynamic language and typically the content is static the javascript overcomes this and gives the page a bit more fluidity The second portion of a typical front end php file is the form that is displayed to the user and through which the user is able to post data the php files that are charge of directly accessing the backend using sql This form displays the data that makes up a typical allergy entity including the allergy code and description The addpatientAllergy php file is used to take da
5. gt Years lt th gt lt tr gt while Srow mysql fetch array Sresult code Srow nurseldCode name Srow name surgery Srow surgeryTypeCode Sgrade Srow grade Syears Srow years echo lt tr gt lt td gt lt a href home php gt home lt a gt a href php deleteNurse php code Scode gt Delete lt a gt lt td gt lt td gt lt td gt input class noUpdate readonlyz readonly gt lt td gt lt td gt lt input class noUpdate readonly readonly value Sname td lt td gt input class noUpdate readonly readonly n value Ssurgery gt lt td gt lt td gt input classz noUpdate readonly readonly value Sgrade lt td gt lt td gt input class noUpdate readonly readonly value Syears gt lt td gt type text name code value Scode type text name name type text name surgery type text name grade type text namez years lt tr gt End our while loop echo lt table gt gt This piece of code displays the last two types of php files that are used to display data for the user and also allow the user to update the data directly In this case this table is displayed within another html file thereby inheriting all the stylistic effects already present in the original html file This table merely need identify itself with an existing class element found in the nmaStyle
6. mysal mr Check Premieges Parformance_schema s Check Preces phemraamin E Chace Prviegea test Ch Priests 5 ums a Chaer Prasiages uma 5 Check Priles j wesqutn s Check Prtieges Totat 9 Recent tables TL D ChekAl W hseleced 1d Crop nabio Statinties Note Enabling Ine database statsbes here might cause heavy tafe between me web server and fe MASAL server Step 2 Click newly created Database Press SQL Then copy and paste the sql provided to create the tables there is sample inputs included zm bat Notepad a a jae Search vem Encoding eques semog Macro fun Proges Window Po He s amp i obis ciat ttiam s Bognlescwaiw 8 25958 je Stecture p SOL Search j Query S Export E Import Operations More Recenttaties Run SQL queryiquacies on database ume Qj 1 2 Show this query here again _ Retain query box iml Cel Sel 35124148 DesWimdews ANSLas UTES NS Vo EDM 205 04 Step 3 After transferring content into NMA in htdocs Visit localhost NMA home php to access the home page a o we s Step 4 This is screen shot of the main user interface provided by the application On the left there is a list of buttons that upon clicked will reveal the related form The user can then insert the necessary data and submit it the php files which will in turn insert it into the sql database Step
7. AMPP The user simply needs to copy the entire folder NMA folder and place it into htdocs Access to the website by using a browser to reach http localhost nma home php 4 Components and their Assets All assets are of type php unless stated otherwise Component Assets Database Input Located in PHP folder account addNurseSkill deleteEmployee addAdmit addOwner deleteNurse addAllergy addPatient deletePhysician addClinic addPatientAllergy deleteSchedule addClinicBed addPhysician deleteStaff addClinicEmp addPrescription deleteSurgeon addConsult addShift getSafeData addCorporation addShiftSchedule scheduleSurgery addDiagnosis addSurgeon updateNurse addEmployee addSurgery updatePhysician addlllness addSurgeryReq connect addMedical addSurgerySkill getSafeData php addMedication addSurgeryType Login php addMedReact deleteAdmision addNurse Front End Display and Form Javascript Menu PopUp Front End Theme and Style Located in root NMA folder viewAllergy addMisc viewClinic addPatient viewClinicBed addScheduleShift viewClinicEmp addShiftSchedule viewConsult addStaff viewCorporation footbar html viewDiagnosis home viewEmployee inPatientManage viewlllness miscManage viewMedical navBar html viewMedication schedule viewNurse staffManage viewNurseSkill updateNurse viewAdmitted updatePhysician Located In assets folder nmaButton js Lo
8. Newark Medical Associates Application Report Luis Serpas e UT epit Dispo at Table of Content Introduction to Report Intended Users Necessary Configurations To create an Instance Components and their Assets List Technical Report Building the Instance amp User Manual Screenshots 1 Introduction This report is composed of two sections The first section is called the Technical Report which describes the individual components of the Newark Medical Associates Database and Web Front End They components are a series of php and html files organized into a folder hierarchy to prompt ease of modification and navigation The second section will guide a typical end user through the menu options and navigation of the applications front end Clients The clients of this manual include the developers who will have access to the code with the intent to alter the front end end users who will the NMA application only through the forms and buttons provided and to any user who wishes to create an instance of the exact application using the assets provided Necessary Configuration Local apache server should be set up to run the application MAMP could be used for MAC OS or XAMPP in Windows The MySQL server should also be set up in order to run the database MySQL but this included with the XAMPP software The apache server is a directory located in the htdocs directory within the users program files in their c drive under X
9. cated In js folder nmasStyle css viewPatientAllergy viewPhysician viewPrescription viewReactWith viewSchedule viewScheduledSurge ry viewSurgeon viewSurgery viewSurgeryReq viewSurgerySkill viewSurgeryType viewOnwer viewPatient 5 Technical Report Section 4 listed all the assets that make up the Newark Medical Associates Application Further it breaks it into components that share some similarities in functionality This similarity is also translated to the code which would be nearly identical copies were it not for their access to different tables and different sql statements In this section attempt to provide a better understanding of the assets that make up the individual components of the NMA application Beginning with the Database input Database Input The assets under this component reside in the PHP folder of the NMA application and their purpose is to be called through a post action that occurs in the forms located in the applications front end These assets include addPrescription addMedicine addPatient The typical code within each of this files is similar to the following This is sample code found in the addEmployee php file All the php files and indeed any section of code that makes use of php includes the first three lines that import the account connect and getSafeData files that are stored in the php folder Their purpose of the account file for instance is to specify the acco
10. e n xampp Control Panel v3 2 1 Compiled May 7th 2013 em s XAMPP Control Panel v3 2 1 d Conto Modules Service Module PID s Port s Actions GM Metstat Apache HAE 80 443 Stop Admin Config Logs BM Shell MySQL 7496 3306 Stop Admin Config Logs Explorer FileZilla Start i r Config Logs j Senices Mercury Start Config J f Logs Help Tomcat Statis Admin Conig Loss graui 0 52 PM mysql This may be due to a blocked port missing dependencies PM mysql improper privileges a crash or a shutdown by another method nysql Press the Logs button to view error logs and check mysql the Windows Event Viewer for more clues mysql If you need more help copy and post this M mysql entire log window on the forums 1 PM mysql Attempting to start MySQL app 8 11 11 PM mysql Status change detected running E lt m Step 1 Start Apache and MySql Visit localhost phpmyadmin Click Home Databases then Create a new DB in this case NMA XAMPP Control Panel v3 2 1 Modes Service Module Portis Actions 80443 Stop Adma Cong Logs 385 Sop Adma Cog tom qi een Databases Eee des nformalion schema reed Crate dointese ij Sn Mims Config togs m3 Stat Adme Conka iem a out Danese Acton B kol s Chace Preces infeematen_schams T Check Prtlages
11. ess rule SriskOf Shdl Sldl 1 5 Stri Shdl Srisk if SriskOf lt 4 risk N if 4 lt SriskOf amp amp SriskOf lt 5 Srisk L if 5 lt SriskOf Srisk M Front End Display and Forms The php files located in the root of the NMA folder are tasked with providing for the user the mechanism by which they can input data into the backend database and also retrieve view delete and update certain table s date such as a patient s assigned nurse Typically files located here are following the naming convention of view Table for instance viewNurse viewEmployee viewAllergy viewlllness to name a few These files are all of the type php except for a few such as the navbar html or footbar html though renaming them wouldn t change their functionality which is to provide the links for the user access the different front end sections The front end sections are the following and they are listed in the applications Navigation Bar they accessible from anywhere on the site Section Form Available Add Patient addPatient Add Patient Add Diagnosis Add Allergy Add Consult Add Prescription Add Surgery Add Medical View Patient patientManage Patients Diagnosis Patient Allergy Consultations Prescription Surgeries Medical Data Add Staff addStaff Add Employee Add Physician Add Clinic Emp Add Nurse Add Surgeon Add Nurse Skill Add Owner View Staff staffManage Employees Physicians Clinic Emp Nurses Surgeons
12. getElementByld lastid style display none revealing selected form document getElementByld id style display block Front End Theme and Style This file called the nmaStyle css is charge of the dimensions of the website how elements overflow the color scheme basically all color and physical appearances of the website are dictated here With a blank cascading style sheet the website would simply be white with black text with pages that would extend vertically infinitely since all the elements would be placed one after the other instead of overlayed the way in which they are style now In this respect coded the website with a green theme since that is typically a clean natural and calming color 6 Creating an Application Instance and user Manual The section describe how to create an instance of the application and is followed by a simple user manual 1 First the mysql database used should have a username and password set to root and toor respectively This isn t necessary if you wish you can also alter the information already in the account php to match that of an existing mysql account 2 Create a folder within the htdocs after having installed xampp name it nma and place the contents of this folder into it You can also simply drag the entire nma folder into htdocs 3 Create the tables and populate them using the sql statements and inserts provided in the sglRelations amp Data doc fil
13. ta input through this form and inserts it into the database This file is called upon the user pressing the submit button lt form action php addPatientAllergy php method post id allergyForm style display none gt lt h2 gt New Patient Allergy lt h2 gt lt table border 1 gt lt tr gt lt th gt Patient ID lt th gt td gt input type text name id maxlength 5 gt lt td gt lt tr gt lt tr gt lt th gt Allergy Code lt th gt td gt lt input type text name allergy maxlength 5 gt lt td gt tr gt lt tr gt lt th colspan 2 gt lt input class button type submit value Submit gt lt th gt lt tr gt lt table gt lt form gt Type 2 and 3 The next type of php file that makes up the front end of my NMA application simply provides for the user a table populated with data from the backend the table is further styled using the nmaStyle css file located in the assets folder This is the typical code for displaying a table using php sql and css lt php SselectAll select from nurse employee where nurse nurseldCode employee empld Sresult mysql_query SselectAll or die echo lt table id phpTable gt echo lt tr gt lt th gt Actions lt th gt lt th style width 150px gt ID lt th gt lt th style width 150px gt Name lt th gt lt th style width 150px gt Surgery Type lt th gt lt th style width 150px gt Grade lt th gt lt th style width 150px
14. unt and password used to login to the mySgl backend php Shostname localhost Susername root Spassword toor Sproject nma gt The connect file then uses the account in order to login to the backend account connection Sdbh mysql connect Shostname Susername Spassword or die Error database selection mysql select db Sproject The getSafeData file which is used throughout all the input files makes sure that any input is sanitized to avoid sql injection include account php include connect php include getSafeData php Sid getSafeData S_POST empid Sname getSafeData POST name all these variables will get the information that is submitted into the forms Ss insert into employee empid name salary gender address type ssn phone values Sid Sname Ssalary Sgender Saddress Stype Sssn Sphone if empty Sid amp amp int Ssalary gt 25000 amp amp int Ssalary lt 300000 mysql_query s or print mysql_error m Please note that the if statement found here shows an example of a business rule that chose to implement here in the php file rather than the database Although had attempted to use triggers or an enumerated column this method proved to be simple and easily mimicked throughout the other php files where other business rules were implanted another case such as this is the Risk of Heart condition busin
Download Pdf Manuals
Related Search