<!DOCTYPE html>
<!--[if lt IE 7]>
<html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]>
<html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]>
<html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js"> <!--<![endif]-->
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Office of Student Financial Aid - Scholarship Supplement</title>
    <meta name="description" content="">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!--<script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>-->
    <script type="text/javascript" src="../js/jquery.min.js"></script>
    <script type="text/javascript" src="../js/jquery.validate.js"></script>
    <script type="text/javascript" src="../js/additional-methods.js"></script>

    <link rel="stylesheet" href="uw-brand/css/full.css">

    <script src="sorttable.js" type="text/javascript"></script>
    <script type='text/javascript'
            src='//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js?ver=1.9.1'></script>
    <script type='text/javascript' src='//www.washington.edu/wp-includes/js/underscore.min.js?ver=1.6.0'></script>
    <script type='text/javascript' src='//www.washington.edu/wp-includes/js/backbone.min.js?ver=1.1.2'></script>

    <script>
        var uw = {"siteUrl": "../assets/"};
    </script>

    <script>
        $(document).ready(function(){
            $("tr:odd").addClass("odd");
        });
    </script>

    <!--    <script type='text/javascript' src='//www.washington.edu/wp-content/themes/uw-2014/js/site.js?ver=1.0.3'></script>-->


    <!--[if lt IE 9]>
    <script src="js/html5shiv.js" type="text/javascript"></script>
    <script src="js/respond.js" type="text/javascript"></script>
    <link rel='stylesheet' href='css/ie.css' type='text/css' media='all'/>
    <![endif]-->

    <script src="//www.washington.edu/wp-content/themes/uw-2014/js/site.dev.js"></script>
    <link rel="stylesheet" href="//uw.edu/assets/uw.css"/>

    <!--File uw.css breaks the small header; this statement fixes it.-->
    <style media="screen" type="text/css">
        .uw-thinstrip nav {
            display: inline;
        }

        .uw-thinstrip div nav {
            display: inline-block;
        }

        dt {
            width:200px;
        }

        form {
            margin-bottom:150px;
        }
    </style>

    <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/chosen/1.1.0/chosen.css"/>
    <script type='text/javascript' src='//cdnjs.cloudflare.com/ajax/libs/chosen/1.1.0/chosen.jquery.js'></script>

    <link rel="stylesheet" href="//osfa.washington.edu/wp/osfa/wp-content/themes/uw-2014-master/style.css?ver=3.6"/>
    <link rel="stylesheet" href="//osfa.washington.edu/wp/osfa/wp-content/themes/uw-2014-osfa-standalone-child/style.css?ver=3.6"/>

</head>
<body>

<div id='uwsearcharea' aria-hidden="true" class="uw-search-bar-container"></div>

<div id="uw-container">

    <div id="uw-container-inner" style="min-height:73%">

        <header class="uw-thinstrip">

            <div class='align-right'>
                <nav class="uw-thin-strip-nav">
                    <ul class="uw-thin-links">
                        <li>
                            <a href="http://uw.edu/studentlife" title=
                            "Students">Students</a>
                        </li>

                        <li>
                            <a href="http://uw.edu/parents" title=
                            "Parents">Parents</a>
                        </li>

                        <li>
                            <a href="http://uw.edu/facultystaff" title=
                            "Faculty &amp; Staff">Faculty &amp; Staff</a>
                        </li>

                        <li>
                            <a href="http://uw.edu/alumni" title=
                            "Alumni">Alumni</a>
                        </li>
                    </ul>
                </nav>
                <nav aria-label="search and quick links" id="search-quicklinks" role="navigation">


                    <button class='uw-search' aria-haspopup="true" aria-owns="uwsearcharea" aria-controls="uwsearcharea" aria-expanded="false">Open search area
                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" x="0px" y="0px" width="18.776px" height="51.062px" viewBox="0 0 18.776 51.062" enable-background="new 0 0 18.776 51.062" xml:space="preserve">
            <g><path fill="#FFFFFF" d="M3.537,7.591C3.537,3.405,6.94,0,11.128,0c4.188,0,7.595,3.406,7.595,7.591
                c0,4.187-3.406,7.593-7.595,7.593C6.94,15.185,3.537,11.778,3.537,7.591z M5.245,7.591c0,3.246,2.643,5.885,5.884,5.885
                c3.244,0,5.89-2.64,5.89-5.885c0-3.245-2.646-5.882-5.89-5.882C7.883,1.71,5.245,4.348,5.245,7.591z"></path>

                <rect x="2.418" y="11.445" transform="matrix(0.7066 0.7076 -0.7076 0.7066 11.7842 2.0922)" fill="#FFFFFF" width="1.902" height="7.622"></rect>
            </g>
                            <path fill="#FFFFFF" d="M3.501,47.864c0.19,0.194,0.443,0.29,0.694,0.29c0.251,0,0.502-0.096,0.695-0.29l5.691-5.691l5.692,5.691
              c0.192,0.194,0.443,0.29,0.695,0.29c0.25,0,0.503-0.096,0.694-0.29c0.385-0.382,0.385-1.003,0-1.388l-5.692-5.691l5.692-5.692
              c0.385-0.385,0.385-1.005,0-1.388c-0.383-0.385-1.004-0.385-1.389,0l-5.692,5.691L4.89,33.705c-0.385-0.385-1.006-0.385-1.389,0
              c-0.385,0.383-0.385,1.003,0,1.388l5.692,5.692l-5.692,5.691C3.116,46.861,3.116,47.482,3.501,47.864z"></path>
            </svg>

                    </button>

                    <button class='uw-quicklinks' aria-haspopup="true" aria-expanded="false">Quick Links<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="0px" y="0px" width="15.63px" height="69.13px" viewBox="0 0 15.63 69.13" enable-background="new 0 0 15.63 69.13" xml:space="preserve"><polygon fill="#FFFFFF" points="12.8,7.776 12.803,7.773 5.424,0 3.766,1.573 9.65,7.776 3.766,13.98 5.424,15.553 12.803,7.78"></polygon><polygon fill="#FFFFFF" points="9.037,61.351 9.036,61.351 14.918,55.15 13.26,53.577 7.459,59.689 1.658,53.577 0,55.15 5.882,61.351 5.882,61.351 5.884,61.353 0,67.557 1.658,69.13 7.459,63.019 13.26,69.13 14.918,67.557 9.034,61.353"></polygon></svg></button>
                </nav>
            </div>

            <div class="container">
                <a class="uw-patch" href="http://uw.edu" tabindex="-1" title=
                "University of Washington Home">Home</a> <a class="uw-wordmark"
                                                            href="http://uw.edu" title=
                "University of Washington Home">Home</a>
            </div>
        </header>
        <div id="notification-area" style="position:fixed;width:600px;top:30px;right:20px;z-index:100000">

        </div>

        <div id="pageContent" style="width:85%;min-width:500px;margin:auto;position:relative;top:10px;min-height:700px;">


            <nav class='uw-breadcrumbs' role='navigation' aria-label='breadcrumbs'>
                <ul>
                    <li><a href="http://uw.edu" title="University of Washington">Home</a></li>
                    <li><a href="https://www.washington.edu/financialaid/" title="Student Financial Aid">Student Financial Aid</a></li>
                    <li><a href="https://www.washington.edu/financialaid/types-of-aid/" title="Types of aid">Types of aid</a></li>
                    <li><a href="https://www.washington.edu/financialaid/types-of-aid/work-study/" title="Work Study">Work Study</a></li>
                    <li><a href="https://www.washington.edu/financialaid/types-of-aid/work-study/work-study-positions/">Work Study positions</a></li>
                    <li  class="current" ><span>UW positions</span></li>
                </ul>
            </nav>

            <div id='main_content' class="uw-body-copy" tabindex="-1">
                <div class="uwaa-btn-wrapper"><a class="uwaa-btn btn-slant-left btn-purple" href="https://www.washington.edu/financialaid/types-of-aid/work-study/work-study-positions/" >&#8678; Return to Positions</a></div>


                <h1>UW Employer Work Study Positions</h1>
                <p style="color:#FF0000"><b>*Click on headers to sort</b></p>

                <div id="table">
                    <?php
                    $db_host = 'uwfinaid.ovid.u.washington.edu:3798';
                    $db_user = root;
                    $db_pwd = '03798';
                    $database = 'workstudy';
                    $table = 'onCampus';

                    if (!($GLOBALS["___mysqli_ston"] = mysqli_connect($db_host,  $db_user,  $db_pwd)))
                        die("Can't connect to database");

                    if (!((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE " . $database)))
                        die("Can't select database");

                    $result = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT jobTitle, orgName, location, category, jobNumber, timeStamp, id FROM {$table}
		WHERE status='Open' AND jobNumber != '' ORDER BY timeStamp");

                    if (!$result) {
                        die("Query to show fields from table failed");
                    }elseif(mysqli_num_rows($result) == 0)
                    {
                        echo "<p>Sorry, there are currently no jobs listed in our database.</p>\n";
                    }else
                    {
                        $fields_num = (($___mysqli_tmp = mysqli_num_fields($result)) ? $___mysqli_tmp : false);
                        echo "<table class='sortable'>";
                        echo "<thead>";
                        echo "<tr>";
                        echo "<th>Job Title</th>";
                        echo "<th>Department</th>";
                        echo "<th>Location</th>";
                        echo "<th id='category'>Category</th>";
                        echo "<th id='number'>Job Number</th>";
                        echo "<th id='date' style='width:100px'>Date</th>";
                        echo "</tr>\n";
                        echo "</thead>";
                        echo "<tbody>";
                        while($row = mysqli_fetch_row($result)){
                            echo "<tr>";
                            foreach($row as $key=>$cell){
                                if ($key == 0) {
                                    $content = "<a href='report.php?id=$row[6]&table=$table'>$cell</a>";
                                } elseif ($key == 5) {
                                    $content = date("m-d-y", strtotime($cell));
                                } else {
                                    $content = $cell;
                                }

                                // Don't print Id.
                                if ($key < 6) {
                                    echo "<td>$content</td>";
                                }
                            }
                        }
                        echo "</tbody>";
                        echo "</table>";

                        ((mysqli_free_result($result) || (is_object($result) && (get_class($result) == "mysqli_result"))) ? true : false);
                    }
                    ?>
                </div>

                <!-- MAIN PAGE CONTENT -->

                <!-- From FOOTER.INC -->

            </div>
        </div>

        <div class="uw-footer" style="background:none;background-color:#4b2e83">

            <a href="http://www.washington.edu" class="footer-wordmark">University of Washington</a>

            <p role="contentinfo" style="margin:0">&copy; 2015 University of Washington  |  Seattle, WA</p>
        </div>
    </div>
</div>


<script type="text/javascript">
    var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl."
        : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost +
    "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
    try {
        var pageTracker = _gat._getTracker("UA-11922437-1");
        pageTracker._trackPageview();
    } catch(err) {}</script>



</body>

</html>
