G Saunders' Home Page

Summer 2020 - INFO465 - Senior Projects in IS

Zoom Classrooms:

I'll be keeping virtual office hours from the link at the top of my home page and those are most convenient for me. Please contact me by email to arrange a meeting during office hours so I'll know to expect you. If office hours don't suit you I'm sure an email or two will find a time that does.

Notes:

(7/13) Click on the 'Logged' link on your card at info465.us/SU20 to see spec violations as you're rebranding and tweaking the form. It was turned on this morning for the next deliverables. A card with no spec violations will hang straight down, spec violations tilt them. There are spec violations that don't show up in this list, so please review all the specs and set out to meet them...

(7/12) Points are posted through Team 'Shop Ready to Sell' and Individual Site Framework or Sample Code in Place, Rebranded, and Items images that get specs. Few of the Pop Quizzes earned points, so they're being used for feedback rather than dinging your grade. Please check after me, I'm having troubles with blind spots and it's very easy for me to miss stuff...

(7/8) About SiteThumbs and Logos: The sample code at SeSDoC happens to work OK with SiteThumb.png also used as a Logo in the header of index.html and the Template. Most sites' header designs don't work with a logo that's only 180px across, so please use a full-sized logo instead of the thumbnailed SiteThumb on your site...

Post images that are the same dimensions as you're using them.

(7/8) Due Thursday: Customized site, rebranded, product images in place, form works as in sample. See below for other Project #1 and #2 Due Dates.

(7/8) The problem with agressive caching may have been solved at info465.us. It was an artifact of recent updates and caching by default was moved into the base configurtion un-noticed by me. In the past only students working behind an appliance like Baracuda that caches content coming across the border and 'explicit refreshing' mostly worked.

I've written a 1 at /proc/sys/vm/drop-cache and re-rigged the .htaccess and hope it works. PLMK if you get a SiteThumb in place and it's not refreshing into your page...

This is the state of the SiteImages as at 5:45 Wednesday:

sahsan 72859 <-- Unchanged SiteThumb
gakpakli 72859 <-- Unchanged SiteThumb
cbennett 6449 <-- Changed
edong2 56545 <-- Changed
sdurfee 14038 <-- Changed
ceverett 5677 <-- Changed
sford 9788 <-- Changed
rjohnson 72859 <-- Unchanged SiteThumb
skadel 72859 <-- Unchanged SiteThumb
akaur 72859 <-- Unchanged SiteThumb
cmitolo ls: cannot access /home/cmitolo/web: No such file or directory

smohamud 72859 <-- Unchanged SiteThumb
soakes 72859 <-- Unchanged SiteThumb
epowell 72859 <-- Unchanged SiteThumb
rsagastume ls: cannot access /home/rsagastume/web: No such file or directory

bsalter 72859 <-- Unchanged SiteThumb
pshah2 72859 <-- Unchanged SiteThumb

Some students thought they had succesfully published a SiteThumb, but I believe the list above is accurate, jives with what I see...

Bonus points were posted for those that got a SiteThumb and other tweaking done in spite of the cacheing issue.

(7/7 After Class) The 40 minute Tech Support recording from this evening's class is here: Tech Support Q & A and Demos

Topics covered: How not to copy sample code; demo'd rm to remove files and directories; mkdir; cd; editing the Template; editing index.html; editing SiteSettings.php; Adding transparency to images; scaling images; configuring WinSCP to copy images to your directory; 20 minutes of confusion and random debugging of over-aggressive cacheing of contents...

(7/7) Observations: Please take a moment or longer to look at the sample code, starting with SiteSettings.php in your home directory, then in your web directory check out the index.html, .css, and Template since they'll need attention first to customize your site.

Your web/SeSDoCForm.php is a script, it is not plain html, it's a script that outputs an html form, receives the form when it's submitted, validates it, and shows the contents as the user entered tem along with error messages and red splats, and will eventually update your database. If you'll rebrand SeSDoCForm.php it will be easy to modify it for Project #2 to update your database.

The options for radio buttons, check boxes, selects, and multi-selects come from the text files that start with Options at /home/SeSDoC/. Retire them early and put the Options for your organization's referral form there instead. Please rename with meaningful names, there's nothing uglier in code than mis-named objects of any kind.

Specs for the SiteThumb that appears in your card at info465.us are at the bottom of the progress page. SiteThumb.png or .gif in your home directory may also be used as the logo in the header of your web pages and form, edit the img tag as needed.

(7/7) The missing videos on debugging PHP, JavaScript, and SQL in PHP scripts have been recovered, moved to Kaltura, and are linked here and below in the section on Debugging: Debugging PHP and MySQL

(7/5) Sorry, I got waylaid and actually had some time away, will get the Videos done for the 'rebranding', debugging, &c up during the day Monday. Making the sample code work isn't due until after another shot at on-line tech support so please get as far as you can, check out the videos, and come to class to get answers...

I think 'rebranding' and otherwise modifying or adding to existing code that works is a good way to learn to code or a new application development environment.

I got the job with my Grand Patron by rebranding an app for FORD to work for GM. When I arrived, he had ladies with scissors and glue ready to paste little rectangles with ' GM ' on them over about 3000 pages that said 'FORD' in case my efforts at rebranding failed like the prior consultant. Luckily I was able to rebrand the app for GM, solved other problems, and the printers were reprinting the 3000 pages of confidential, internal study. I was hired on the spot and kept at a very interesting line of work with the meanest SOB in the auto industry for 21 years, perfect for a pilot/computer geek, came back full-time at VCU when said Patron retired.

(7/5) Answers in email:

The specs for your SiteThumb.png are at the foot of the progress page at info465.us. There's verbal spec to make the subject with irregular edges and have a transparent background. JPEGs can't handle transparency. The best way to add transparency is to use a capable photo editor like GIMP, PhotoShop, or Windows 10 or Mac Photo Editor that will let you add an alpha layer for the transparency. If the background's plain, smack it with your continguous color select wand and delete the selection. If it's a complex subject it can be selected using intelligent scissors or a lasso to detect the edges. Then, invert the selection to mask the selection and select everything else, then delete the selection to reveal the transparency around the subject. Use SaveAs or Export the image as a png.

Rebranding the app is a requirement. After you've made the sample code work, including the referral form, set to rebranding the app. The colors and shapes of the Template should be tweaked, there shouldn't be any reference to SeSDoC, or to SouthEastern States. You can start rebranding quickly by finding and replacing SeSDoC with your own equally UniQue acronymn. Google on 'how to find and replace text in multiple files' and pick one that uses sed-Stream EDitor. It can also be done quickly with vi, file by file. Copying filenames with modifications can be done with a little more complex commanding. I'd recommend doing a thoroough rebranding, checking it twice, and test the app to make sure you haven't botched it before putting any work to the code.

No, PHP isn't required. It's what I'm prepared to support, along with the Python samples, in a class where all but one student deny knowing how to construct a database, make a user interface for it, update, and report on the data. If you know what you're doing, you're welcome to get the specs with any language you'd like, but I can't be very helpful. Your referral form and report need to work as well, or better than the one at SeSDoC or SeSDoCPy. Points lost for independent efforts are usually because the student couldn't figure out how to make an html form where the checks, buttons, or selections come back set the way the user set them when they submitted the form for validation. The JavaScript pre-edit before the form is submitted is also a firm requirement.

(7/4)

(7/2) The videos for copying the sample code and debugging need to be redone and I'll do that tomorrow so you'll have another runthru. It's thrilling to be on-line and see six cards populated at info465.us by Akpakli, Bennett, Everett, Ford, and Johnson during the zoom session. I look forward to seeing lots of tilted cards by next Tuesday...

(7/2) Y'all are reviewing HTML5 and CSS3 with these projects, and may be using the <form and other elements to update a database for the first time. The author of Websitesetup.org/html5-periodical-table noticed we're using html5 and css3 our class, and suggested that his periodal table of html5 be referenced. I wish him all the best, and continue to preach the geek orthodoxy of CSS3, HTML5, Semantic Markup, viewports, and media queries...

(7/2) It's time to set to the individual projects so we can tick off the boxes like 'can code', 'can do database', 'can make ui'... Points and due dates:

Students working with other languages than PHP please have the equivalent working from your link from the progress page at info465.us.

Team Project #4 Documentation Package is due July 30. Please note that none of the hand-sketched documentation is valid for the 2017Winter app or database. Please refer to the application, your use, and the database to get accurate documentataion..

(6/30) Due Date for Teams Setup Shop: By the end of class on the 2nd, I'm expecting to see startup orders posted for partners' equity, startup cash, and purchase orders to Black Barrel for items in stock. A couple of the Partner Organizations had negotiated Purchase Orders and had QOH. I ask for business to be conducted over a few days, so that when SQL asks for grouping by date, you've got good-looking Journals. If you haven't checked Notes about Setting up a PAYGO Partnership at 2017Winter, please do.

One outfit is providing consulting services by the hour, so to make that a realistic scenario, they'd let a customer with a valid eLand payment card account buy consulting on-line crediting 4010-Sales of Services and letting the PAYGO debit their 7.5% and their Web Shop Proceeds to gain interest or cash out. Purchase every hour of consulting or other services billed out from a partner or other consultant on a Work Order to offset the Credits from Customer's accounts and show how much consulting you're liable for.

(6/30) A 5-point Pop Quiz to cover the next two class meetings was announced, due before class on the 9th. It asks for 2 State Charts, aka State Transition Diagrams: 1) For Account records from the on-line Get An Account through to Active; 2) State chart for Orders from the Cart through Fulfillment. Please observe the database while simulating business in these next few days so you'll be accurate wth the State Charts.

The best State Charts run the States's clipped-corner rectangles down the page with Actors on either side to show what they do to advance the state of that record. The ACH can be considered an Actor in filling an order, but I like to see a shape that shows it's a web-service request to a remote server.

Visio's the best for UML diagrams with easily recognizable shapes, but Google's drawing tool provides easier collaboration. Anything that will export to a multi-page pdf is fine.

Prior Notes:

Notes prior to the last date above have been moved to Prior Notes.

Class Meetings:

(6/9) Most specs and advice are given in class, verbally, some are here...

Demo OE, Fulfillment, and ACH at 2017Winter

(6/11) This is a quick demo of the fake PAYGO 2017Winter that will be used in several exercises and projects this semester...

Teams Setup Shops:

Assignment: Teams of three or four confabulate a shop to operate under the umbrella of 2017 Winter. Get graphics together that meet the specs for the thumbnail uploaded logo for your organization and the Items it originates for lack of distortion or pixelation, transparency, and equal size and alignment for at least three products or services...

Videos about Memoranda, Journals, and Ledger aka Paciolan Methods with hand-drawn examples are here: Paciolan Methods: Detailed Memoranda, Journals, Ledger Trial Balance.

Here are Notes about Setting up a PAYGO partnership at 2017Winter.

Demo: A sample accounting for startup and a day of operations for a ficitious hussle similar to the case studies teams are confabulating. This is to introduce or review double-entry accounting concepts: Numbered Ledger Accounts: 1-Assets, 2-Liabilities, 3-Equity, 4-Income, 5-Expenses; Assets and Expenses are increased by Debits; Liabilities, Equity, and Income are increased by Credits; Docs: Memoranda aka Orders & Details, Journals, Ledger; Debits equal Credits on Orders, each Journal, and the Ledger Trial Balance. If we get the correct ledger codes on Details a manager approves the rest of the accounting can easily be automated...

Team First Deliverable

On-line, paper's not practical, but a pdf with scans of handwritten scenario, memoranda, journal, and trial balance. I can usually read google or excel sheets that have been exported as a pdf.

Each team please provide on paper for Rowdy Chihuahua's attention:

After a demo of the PAYGO Unbrella 2017 Winter accounts will be set up.

Accounting:

Team Assignment - Analysis of the Get an Account Process

H O L D O F F this until you've had your fake customers with payment cards issued by ELand's Ministry of Debits and Credits.

Get organized in teams of three or four and each get an account at 2017Winter. Please, do it _one at a time_ and pay careful attention to the process. And, strive to NOT CREATE DUPLICATE Accounts!

As each team member gets their new Account use the database to track AcctStatus, AcctStatusDT, AcctStatusById during the enrollment of a new Account. Each team, draw a state transition diagram and notes about how the process may be improved. The customer asked to gather contact data and have the new Account holder verify email address before a manager's approval for the next steps and assignment of Roles. There have been reports of 'problems' in registration.

You'll need to use a real email address so you can get the approval code. It looks like your @vcu.edu or @mymail.vcu.edu account will work, mail may go into the spam folder, but it needs to be tested for the new semester. Email addresses will be scrubbed at the end of the semester and aren't displayed anywhere except in your Account record and to students who can use SQL. If you don't want to use one of your email addresses, you can use yourid@info465.us and use 'mail' at the command line to get the approval code.

You're welcome to use a fictitious name, an anagram of your real name is helpful, to avoid your name showing up in a google search. Use a fake address and phone number.

2017Winter Database

Projects and a quiz use the database at 2017Winter. Please gain familiarity with it. Here's a connection string with select authority that will work from the command line at info465.us:

mysql -u2017Winter -pWinter2018 2017Winter

Use W3School's SQL Tute for an introduction to SQL. The database server at info465.us is MariaDB which at this point is a direct drop-in replacement for MySQL which most Linux distros avoid because it's Oracle's property...

Here are sample quiz questions: SQL Samples. Here are sample quiz questions with answers: SQL Questions & Answers.

Here is a sketched Database ERD of a database similar to 2017Winter showing the tables that have to do with accounting. Table names and PK/FK relationships are accurate, some column names are not quite. Use SQL's DESCRIBE command to get the exact column names at 2017Winter.

ERD

Here's a sketch of the whole database and file system for a system similar to 2017Winter. Tables with dashed lines around them might show up in some other season to help with distribution functions.

ERD

Working Server Side

Click Logging in and working at info465.us for references about working at the command line at info465.us. User ids and passwords were shown in class, expecting that the first command on-line will be passwd...

Mobile First, Responsive HTML5 and CSS3 Forms

Demo'd SeSDoC forms: Mobile first, responsive, valid html5 and css.

These links were visited and examined in class. They are all dead-simple HTML and CSS, just enough to clearly demonstrate semantic markup of content and forms.

Project #1: Learn Linux, vi, and make sample code work in your web directory

This 20-point project is to put up a demo site that gets all the specs below and will launch from your link at info465.us.

Dlv #1 is 5 points: demo a valid, mobile friendly, responsive site that launches from your link at info465.us, identifies your fictitious organization and shows off three items for sale. Get your SiteThumb image or animation in place and set the name of your fictitious hussle into your settings. Use similarly-sized product images with transparent backgrounds, or use identically sized product images. Size images no larger than the largest they'll be displayed on the page, no distortion or pixelation.

It's valuable to be able to pick up code and modify it for the purpose at hand, so Copying/tweaking class samples is fine but it shouldn't look exactly like the samples when the project is delivered.

Learning a framework or using it again is better. BootStrap, W3CSS or other frameworks make good additions to a portfolio and are the easiest way to get a working, mobile-first, responsive website together. The class' coding samples are easy to stick into most any template, so when we get into server-side scripting the sample code will be easy to adapt into a framework...

Dlv #2 is 15 points: add an application form to demo JavaScript and PHP.

The project is to explore a linux web server, develop proficiency with the command line environment and the vi editor, learn or practice debugging, and demo mobile-friendly, responsive features of HTML5 and CSS3. Sample code is provided in PHP and JavaScript to present a standards-compliant, mobile-friendly html form and validate it browser-side with JavaScript and also server-side with PHP. If you're using the sample code, please plan to customize it as you go along so the end result doesn't look much like the samples. 5 bonus points will be posted for students who abandon the instructor's samples and get all the specs with other stuff.

If you've already done responsive HTML/CSS 'from scratch' this might be a good time to learn a CSS or CSS/JavaScript framework! The PHP examples deliver forms and content by replacing strings in an html template so they are easily adaptable to a template done up with Bootstrap, Foundation, or an even heavier CSS/JavaScript framework.

Gain familiarity with the Linux command line at info465.us and use it to copy text files, scripts, css, and html from /home/SeSDoC and /home/SeSDoC/web or your framework to your home directory and web directory and tweak them into webpage that shows up from your link at info465.us.

Next, study the features of HTML5, CSS3, PHP and JavaScript in the sample code for semantic markup, responsive web design, and form handling. The SeSPoP and SeSDoC pages have links to Tutes for all these topics.

Decide whether you'll adapt the sample code at SeSDoC or Resp for your project, or start from scratch, or use a lightweight CSS framework like W3Schools RWD tute, W3CSS, Bootstrap, or something heavier with more pizzazz. Exploring AJAX and jQuery are also worthwhile while you've got a server at your fingertips if web designer is something you'd like to be.

The sample code at SeSDoC uses 'html templates' and is very easy to fit SeSDoCForm.php and other reports into an html template made from a css3 framework like W3CSS, Skeleton, BootStrap...

Make the html and css suit the fictitious organization, business, or hustle you confabulate for your case study. The index page will become a store-front that earns commissions on sales of at least three products or services. Choose a thumbnail image to represent your site at info465.us and make the site comply with the SiteThumb spec (at the bottom of the Thumbnail page at info465.us) so your site appears in the gallery at info465.us. Transparent backgrounds are attractive, animated gifs of a few dozen frames are fun to see.

Specs for Project #1 Dlv #2:

If you're working from the samples provided, consider the acronymns SeSDoC and SeSPoP as the property of these ficititious organizations and they should not appear in the file or variable names involved in your website. The info465.us enforces these and other specs.

All form elements, variables, and objects should share the same meaningful name, consistently applied so that columns in the database, names and ids of html form elements, file names, and variable names in JavaScript and php code, are all named the same.

No embedded or in-line Styles! This is what 'separate style from content' means! All CSS must be 'external', in a local file linked in the head of the document! If there is an exception, add a style for it in the external style sheet. If there is some reason you must embed or use in-line styles to achieve some effect, please discuss it with the instructor.

All pages must be consistently styled with the same or similar external css3.

If a semantic element exists, use it. Do not use plain divs with ids or classes named like header, footer, menu, aside, or any other CSS3 semantic selector. Don't use frames or iframes, named or otherwise. Make your page a very clear demo of the best markup for semantics and style!

Use CSS3's semantic elements for page layout to best advantage: As a minimum, structure your page layout using: header, main, aside, and footer.

Use CSS3's semantic elements to mark up content: p, h1-6, ul, ol, li, strong, and em, table, td, tr...

Use CSS3's form elements to mark up forms: fieldset, legend, and label.

The elements in the sample form at SeSDoC define an html form in a standards-compliant way so that is usable in a mobile device without any stretching or tapping and is also accessible for handicapped persons and search engines.

Use a grid scheme for responsive design. The samples use the '12 grid' scheme from W3School's RWD tute with Row and Col defined in CSS, amenable to folding for tablets and phones. This also appears in W3CSS and the equivalent is in BootStrap and Skeleton.

Optionally, semantic elements article and section may be used to organize featured products or items, newsletters, blogs, and other complex web documents. Styling an article is a good way to implement material web design features like cards.

Wildcard classes of CSS3 make it easy to adapt a multi-Column grid system to any kind of device by being clever with object names like 'Col-' or 'Card' to adapt seamlessly with any sized viewport. W3Schools RWD and W3CSS show how to use these wildcard features. These features are well used in most CSS3 Frameworks!

CSS styles make it easy to make accordion or drop-down interfaces for the user, or change from a hamburger to a menu when the window gets big enough. Many CSS3 transitions are now supported by current versions of all common browsers and most vendor-specific styles may be retired. There's a lot of value in learning how to do these with native jQuery or one of the frameworks that uses jQuery -- these are the slickest and doing them the way Google does it is a good thing!

Serve all graphics, fonts, libraries, frameworks, and styles directly from your web directory at info465.us and be ready to report on their bulk. Quick loading speed on a slow network is of the essence. Google guidelines favor lightweight pages that load fast even on a 3G network. Limit the size of graphics for products on the home page to something less than half a megabyte. Size all images for their max dimension as used on your site. (If it's 300px wide on the page don't link to an image that is 2000px wide in the img tag, and don't use dimensions in css or html to make large images fit.) Use a photo-editor on your desktop or online to size images. Make sure all re-sizing results in sharp images and doesn't result in unsightly artifacts...

Set the permissions for your web and any of its sub-directories to 705. Set the permissions for all files in your home and web directories to 604. The intent here is that the web server can read these files but others in the info465 group can't.

Specs for The Form in Dlv #2

Project #1's 1st deliverable was a single page, mobile-friendly at google and valid at w3c, website for some fictitious shop or organization allied under 2017Winter's umbrella.

The 2nd deliverable is a two-page site that launches from the link at info465.us, showcases at least three products on the home page, and has a form on the second page that has been customized to suit membership or other relationship with your ficititious organization. All css is external, html5 and css3 validates at W3C validators, and all pages score Awesome on Google's mobile friendly test.

Project #2 will be to add user authentication and update the database using the form built in Project #1 Dlv #2.

The PHP or Python-generated form must work at least as well as the sample code provided at SeSDoC, meeting these finer specs:

Open Lab

Tech support for learning the command line and vi and Project #1, Dlv #2...

Things not looking right in the browser? Maybe getting an empty page back or missing an img? Tailing the log might help: Open a new ssh window and log in to info465.us. Use this to show the tail of the log and follow it, replacing 'yourlogin' with your login id at info465.us.

tail -f /var/log/httpd/ssl_error_log | grep yourlogin 

This will show errors produced by html or scripts from your directory when you load or refresh a page so keep it visible while you work. Use ctrl-c to stop tailing the log.

Please use the references! There's a month's time to get up to speed with mobile-first, responsive design with css3, html, form elements, JavaScript, and PHP... Validate early and validate often! W3Schools, Google, and Mozilla are all excellent references, have been revamped to cover mobile-first, responsive design. Consider W3Schools as introductory stuff, followed by Google's authoritative guidelines, and Mozilla's very detailed docs. The CSS Zen Garden is worth a stroll...

Some hints on debugging:

In short:

If you're programming without the developer and debugging tools running, you're just guessing and frustrating yourself and ticking off the intructor in lab, and will likely inject numerous errors in the code while blindly trying stuff.

Keep the debuggers visible at all times even if everything appears OK since they may be showing warnings that detract from a professional result.

Here is a screenshot suggesting a juxtaposition of putty or Mac terminals and a browser while debugging. A quick mouse-click or Alt-Tab moves among browser and code windows. The tail of the log is always visible so it's easy to see it jump if/when there is an error in a script...

Screenshot

Click Debugging PHP and MySQL for videos...

Developer's Tools vary a lot from browser to browser! Some even takes lotsa seconds to load and cause the fans to come on just to show all the charts and graphs! The instructor usually debugs with FireFox Developer Tools, W3C, and Google, then Chrome on an Android, then Safari on a tablet, then with FireFox Developer Tools, then Chrome on a notebook, then Edge. Make sure you know how to refresh components in whatever Developer's Tools you use since many ISPs cache static content and don't recognize file changes on the server! Firefox and Chrome's source views flag some HTML and CSS errors, are quicker than the W3C Validators. FireFox and Chrome both allow Ctrl-u to get to source code, others substitute their own overblown developer's tools.

Tail The Log! While You're Debugging, Tail the Error Log!

Keep the tail of the error log visible at all times as you code! If you're getting an empty page back or unexpected results from a PHP script, or missing an image /var/log/httpd/ssl_error_log will likely show the error.

Open a new ssh window and log in to info465.us. Use a command like this to show the tail of the log and follow it, replacing 'yourlogin' with your login id at info465.us.

tail -f /var/log/httpd/ssl_error_log | grep yourlogin 

This will show errors produced by html or by PHP or other web scripting languages from your directory when you load or refresh a page so keep it visible while you work.

Use ctrl-c to stop tailing the log.

If you haven't been tailing the log and wonder about recent errors, you can grep them out of the error log like this, replacing yourlogin with your login id:

grep yourlogin /var/log/httpd/ssl_error_log

If there are no errors in httpd/ssl_error_log but the script isn't producing the correct web page, place echo statements followed by exit at strategic points in the PHP code so you can _see_ what's going on before the HTML is pitched.

Something like this might be helpful:

echo $View; exit;
Or, use print_r to show superglobals or arrays:
print_r($_POST,false); exit;
at the top of a script would show the POST data submitted from an HTML form to remove any doubts what's in the POST data...

Debugging JavaScript: From FireFox or Chrome's Menu at the right of the title/search bar, choose More Tools → Developer Tools and figure out how to use it from any of several on-line resources.

To get a quick look at errors from JavaScript use the Console tab with Preserve Log set to capture errors from statements in <script, onClick, and other HTML elements. Position the console so you can see the error messages as the page loads and events are triggered. Double-click on an error to be jerked to the errant line of code.

Use the W3C HTML and CSS validators early and often and don't continue debugging until they are valid. Design for mobile first with viewport set, then tweak @media queries for larger displays. Use Google's mobile friendly test, try W3C mobile validator for more of a challenge.

Team Project: UML State Chart

Use info465.us/2017Winter's Log In or Get An Account dialog, at the upper right where 'Web 2' says it should be, for each team member. Do it one at a time while Rowdy Chihuahua or Rhue Pinscher are available to authorize accounts. Watch the process carefully so the team can get an accurate state transition diagram together for the project's deliverable.

If anything's unclear in the process or some non-fluency is discovered please document it so we can get it to the attention of the developers next time we can catch them.

Errata: info465.us is not set up to get email to you @vcu.edu, but works almost everywhere else. Using a gmail or other email account where you can click on a link to validate your email is easiest. If you don't want to use a real email address, use your userid@info465.us and the command line's mail to read the email validation code.

The 2017Winter database is available so you can closely track the value of AcctStatus to get the state chart accurate. A select-only connection string is:
mysql -u2017Winter -pWinter2018 2017Winter

PHP code is available read-only in /home/2017Winter/Web.

Project #2 Assigned - Authenticate Users, Establish a Secure Session, Menu, Update Database, Report...

Demo for this is Project #2 Demo Videos.

Demo in class showed PHP's session_name, session_start, session_destroy and also looked at a session cookie under the i-spot in the browser and session data kept in /var/lib/php/session on the server. LogIn.php authenticates via web-service at 2017Winter by opening a pipe to handle a request with userid and password and response with not-valid or user's name. LogOut.php uses session_destroy to clear all the data from the session on the server. Every 'protected' php script requires SiteSettings.php which blocks access to pages if a browser's not logged in and redirects the browser to LogIn.php or index.html. Find these features in the code and be prepared to explain them.

Modify your site at info465.us to work similar as the example at info465.us/tinstructor, making a link like 'Members' prominent on your existing page. The project is to make your site authenticate users with 2017Winter credentials and provide forms and content to logged-in users only. If somebody tries to access a 'protected' url, they should be directed to the LogIn script for authentication, then to the url they attempted to reach.

The specs for the behavior of the form are the same as Project #1, all input elements should be returned with text, checks, and selections the same as the user entered. And the user should be able to re-submit a form if they notice an error. The specs for Project #1 were intended to make a form that can easily be secured and used to update a database.

The sample scripts are available from the command line in /home/tinstructor/ and /home/tinstructor/web/.

/home/tinstructor/SiteSettingsSample.php is available to copy and modify to suit your Site. Leave the functions intact. Edit at the top and bottom to supply _your_ SessionName and database credentials. Take care not to clobber your existing SiteSettings.php when fitting the new script in your account.

Copy these scripts to your web directory: TemplateSeSDoCForm.html, SeSDoCLogIn.php, SeSDoCController.php, SeSDoCLogOut.php, and SeSDoCApplicants.php. SeSDoCCommissions.php is not available to copy. After you've made them run, edit them to suit your site and database.

SeSDoCForm.php differs from the earlier example. Don't copy it over your existing form's script. Copy the changed parts to your script:

Here's a class diagram of a project similar to your Project #2:

MVC Thumbnail

Setting up your MySQL/MariaDB Database

SQL scripting at the command line is a way to create a database at info465.us or any other LAMP stack. Any SQL database operates off a stream of characters from STDIN. STDIN is the keyboard in a command line environment, or a string in a script using the arcane mysql_query() function. In bash, the '<' less-than sign is to 'redirect' the contents of a file into the stream. Ctrl-D on the keyboard will stop Mysql...

MySQL/MariaDB Scripting and were demo'd in class.

The user id for your individual MySQL/MariaDB database is the same as your id at info465.us and passwords are the upper-case 1st letter from your first name and the last 4 lower-case letters from your last name. Rowdy Chihuahua's connect string would be: mysql -urchihuahua -pRahua rchihuahua

Please take care not to destroy your working php script as you add code to support database update! Make local backup copies so it's easy to revert to working code if you hose up the script while adding database update. HTML form handling, securing web pages, and updating a database in a structured environment are inherently complex tasks. Make sure you're keeping copies of your working scripts before each session so you've got something recent to roll back to.

Code Review

Structured Notation Page 1   Structured Notation Page 2  

Structured Notation Page 3   Structured Notation Page 4  

Project #3 - Earn and report commissions

This is 10 points for individual effort and 10 points for teams. Teams setup Items in their shop at 2017Winter to be sold under the PAYGO commission agreement by each of the associates. This is demonstrated in the 'Click to Buy' links for Pacioli's books at info465.us/tinstructor.

Each student's shop at 2017 Fall has a link added to report commissions earned on the three items offered.

Teams contrive several purchases at their shops and the shops of other teams using the fake accounts with credit acconts issued by an ELand ACH.

Shops need a good-looking trial balance put together with at least a dozen orders and journals showing startup and a couple day's operations. QOH for items in the store should be reasonable to support on-line sales.

Project #4 - Document 2017 Winter

Teams thoroughly document the 2017 Winter PAYGO Umbrella's system as built. Team members note which portions they authored, and all team members should be involved enough with the project so they can claim it as an exhibit in their professional portfolio. Individuals, or those fired from a team, may negotiate a subset of the UML Diagrams and other documents. All documents must use recognized shapes from the UML suite of diagrams. Project #4 must be submitted in printed form and also in a single pdf submitted through BlackBoard.

Bring work to class for feedback early. None will be offered between the last class and the exam. The exam time is to collect projects not help debug them or tweak them to specs after critique...

Sketch of Similar Application as at 2017Winter

MVC/Class Diagram

This a rough Class Diagram for the MVC-Model View Controller scheme similar to 2017Spring. The UML doesn't have a MVC in its set of diagrams quite yet, but the Class Diagram is easilty adapted to reflect the popular design pattern. The blocks in a UML Class Diagram typically show Name of the class, its methods, and its properties. Here, to make it fit a MVC, the block represents a model (aka script) instead of a class. 'View' is substituted for method, where the models consistently use HTML GET or POST data in $_REQUEST['View'] to control their output.

The biggest block in the diagram is Controller.php, 'the controller', which surveys the environment for a logged in user and provides a menu of the models and views appropriate for their authority and roles. Please, improve on the diagram if you choose to use it as a model for your Class diagram, and make it a tighter fit to 2017Winter.

Its important for somebody wanting work in app dev to have a ready reference to a Model View Controller and be able to talk about it, sketch it, or sit down and develop with it. The MVC is a popular and powerful design pattern implemented in many development environments in many ways. Visual Studio's MVC is highly abstract with a steep learning curve, which it's well worth climbing since it takes best advantage of the .NET Framework. Django is in many ways a MVC, as are other frameworks for application development.

State Transition Diagram aka State Chart

This is a rough UML State Chart, or state transition diagram, for Orders OStatus from check-out through fulfillment in an application similar to 2017Winter. It's reflects changes from 2017Winter that involve a shipping desk after the ACH authorizes the credit card.

2017Summer State Chart


G Saunders,
Dept of Information Systems
VCU School of Business

G Saunders Wings

Content © 1999 - Today
By G Saunders
Images are Available on the Web