| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST2146/Labs/Lab02/ |
Upload File : |
<?
// MichaelMalz/CST2146/Labs/Lab02.phpinc
$css .= ',colorCode.css';
#d_Var('$f_task',$f_task,'df');
#d_Var('$f_subtask',$f_subtask,'df');
// Process $f_subtask == 'Save path information'
if ( $f_task == 'Submit' && $f_subtask == 'Save path information' ) {
$EvaluationSubmission_PROCESS = false;
require('getLabInfo.phpinc');
require('saveLabInfo.phpinc');
}
require('getLabInfo.phpinc');
$checkFileUpload = false;
#$showEvaluationVariables = true;
require('Gradebook/EvaluationSubmission_BEGIN.phpinc'); // Replaced.
$disabled = '';
#$disabled = ' disabled';
$uploadFilename = $classNumber.'_'.$saveFilename.'.png';
$UN = strtolower(substr($userFirstName,0,3).substr($userLastName,0,3));
$PW = $f_sId;
$ShowSpanCountBefore = false;
//$ShowSpanCountBefore = true;
// <span class="count">
#d_Var("\$_SESSION",$_SESSION,'d+');
#d_Var("\$_SESSION['CST2146']",$_SESSION['CST2146'],'d+');
?>
<fieldset><legend>Description</legend>
The purpose of this lab is to setup your Models and Migrations for the CST2146 project for class.
<br>
<span class="note normal">
There are a lot of steps and variations that can happen and I will try to cover them below.
<br>No matter what I do, you may need help to get this all working.
If you need help, don't be shy; Call me, or email me to set up a web meeting where we can talk.
</span>
<br>
<?=$gradeNote?>
<? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><? } ?>
</fieldset>
<ol class="count">
<li>Create your branch in the cst2146-2025 repository, use <?=$UN?> as your branch name.</li>
<li>Select bring changes over to new branch</li>
<li>Then click Publish Branch</li>
<li>*** Use laravel tools and conventions on this lab ***</li>
<!-- 1 -->
<li>Create the data <a href="https://laravel.com/docs/10.x/eloquent">Models</a>
<ol>
<li>Coupons</li>
<li>Customers</li>
<li>Orders</li>
<li>OrdersProducts</li>
<li>Products</li>
<li>Warehouses</li>
</ol>
</li>
<!-- 2 -->
<li>Create the <a href="https://laravel.com/docs/10.x/migrations">Migrations<a> scripts
<ol>
<li>Coupons must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>code (varchar255)</li>
<li>type (varchar255, default 'percent')</li>
<li>discount_amount (decimal 6,2)</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
<li>Customers must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>first_name (varchar255)</li>
<li>last_name (varchar255)</li>
<li>address_1 (varchar255)</li>
<li>address_2 (varchar255, nullable, default to null)</li>
<li>city (varchar255)</li>
<li>state (varchar255)</li>
<li>zip_code (varchar255)</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
<li>Orders must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>customers_id (unsigned bigint, fk to customers->id)</li>
<li>coupons_id (unsigned bigint, nullable, default to null, fk to coupons->id)</li>
<li>order_complete (tinyint, default '0')</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
<li>OrdersProducts must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>quantity (int, default '0')</li>
<li>orders_id (unsigned bigint, fk to orders->id)</li>
<li>products_id (unsigned bigint, fk to products->id)</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
<li>Products must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>name (varchar255)</li>
<li>invoice_price (decimal 6,2)</li>
<li>msrp_price (decimal 6,2)</li>
<li>back_ordered (tinyint, default '0')</li>
<li>warehouses_id (unsigned bigint, fk to warehouses->id)</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
<li>Warehouses must contain the following fields.
<ol>
<li>id (unsigned bigint, primary key, auto increment)</li>
<li>name (varchar255)</li>
<li>status (tinyint, default '0')</li>
<li>created_at (timestamp)</li>
<li>updated_at (timestamp)</li>
</ol>
</li>
</ol>
</li>
<!-- 6 -->
<li>Demonstrate that your new data models and migrations work.
<ol>
<li>Execute the command 'php artisan migrate:fresh' in the command terminal.</li>
<li>Commit your changes to your github branch.</li>
<li>Take a screenshot of the output in the command terminal.</li>
<li>Take a screenshot and save it as <b class="copyText"><?=$uploadFilename?></b>.
<br>
<? showBegin('See example screenshot','Hide example screenshot'); ?><br>
<img src="images/ScreenShot1.png" width="900" height="405" alt=""/>
<? showEnd (); ?>
</li>
</ol>
</li>
<!-- 7 -->
<li>Turn in your assignment:
<ol type="a">
<li>Browse and select your <b><?=$uploadFilename?></b> file: <input type="file" name="fileUpload" id="inpFileUpload"<?=$disabled?>><div id="divFileploadError"></div></li>
<li>Then <input type="submit" name="f_subtask" id="inpSubmit" value="Submit"<?=$disabled?> onclick="return checkFileUpload(this);"> for grading.</li>
</ol>
</li>
</ol>
<? if ( $disabled ) { ?>
<span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><br>
<? } ?>
</fieldset>
<?
require('Gradebook/EvaluationSubmission_END.phpinc'); // Replaced.
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>