Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

UConnJobSearch/ui.php

Go to file
 
 
Cannot retrieve contributors at this time
224 lines (191 sloc) 7.14 KB
Raw Blame
Open in GitHub Desktop
<!DOCTYPE html>
<html>
<body>
<p>
User Interface
</p>
<button type="button" onclick="query1()">Query 1</button><br><br>
Last Name: <input type="text" id="lastName"></input><br>
<button type="button" onclick="query2()">Query 2</button>
<br><br>
Company Name: <input type="text" id="companyName"></input><br>
<button type="button" onclick="query3()">Query 3</button>
<br><br>
<!-- Re-format this to be MM-DD-YYYY -->
Start Date: <input type="text" id="startDate" value="xx/xx/xxxx"></input><br>
End Date: <input type="text" id="endDate" value="xx/xx/xxxx"></input><br>
<button type="button" onclick="query4()">Query 4</button>
<br><br>
Salary: <input type="text" id="salary"></input><br>
Job Title: <input type="text" id="jobTitle"></input><br>
<button type="button" onclick="query5()">Query 5</button>
<br><br>
Job ID: <input type="text" id="jobID"></input><br>
<button type="button" onclick="query6()">Query 6</button>
<br><br>
College: <input type="text" id="college"></input><br>
<button type="button" onclick="query7()">Query 7</button>
<br><br>
<!-- Query 8 stuff here for payment report -->
Payment Start Date: <input type="text" id="paymentStartDate" value="xx/xx/xxxx"></input><br>
Payment End Date: <input type="text" id="paymentEndDate" value="xx/xx/xxxx"></input><br>
<button type="button" onclick="query8()">Query 8</button>
<br><br>
<!-- List of skills here -->
<!-- Re-do this later to make it look a lot prettier, e.g.
by making a (div?) box containing all the skills, where each is
selectable and removable (with a "Remove Skill" button?) -->
Skills: <input type="text" id="skillInput"></input><br>
<button type="button" onclick="addSkill()">Add Skill</button><br>
<select id="skillset">
</select><br>
<button type="button" onclick="query9()">Query 9</button>
<br><br>
<button type="button" onclick="query10()">Query 10</button>
<br><br>
<div id='tableContent'></div>
<br>
</body>
<head>
<!-- JQuery Reference -->
<script src="//ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script> <!-- Javascript functions here -->
var q = "";
function queryForm(){
$.ajax({
url: "query.php",
data: {
query: q
},
type: "POST",
dataType: "html",
success: function (data) {
document.getElementById("tableContent").innerHTML = data;
},
error: function (xhr, status) {
alert("There was a problem with the request!");
}
});
}
function query1(){
q = "SELECT DISTINCT UFName, ULName, UEmail, StateName FROM state, user, seeker "
+ "WHERE seeker.UName = user.UName "
+ "AND user.StateID = state.StateID "
+ "GROUP BY StateName;";
queryForm();
}
function query2(){
var lastName = document.getElementById("lastName").value;
q = "SELECT DISTINCT UFName, ULName, company.CName, Job.JobID, JListDate, jobtitle FROM seeker, user, company, job, applies "
+ "WHERE seeker.UName = user.UName "
+ "AND job.CName = company.CName "
+ "AND applies.UName = seeker.UName "
+ "AND applies.JobID = job.JobID "
+ "AND user.ULName='" + lastName + "';";
queryForm();
}
function query3(){
var companyName = document.getElementById("companyName").value;
q = "SELECT job.JobID, JListDate, jobtitle, JFillStatus FROM job, company "
+ "WHERE job.CName = company.CName "
+ "AND job.CName='" + companyName + "' "
+ "GROUP BY jobtitle;";
queryForm();
}
function query4(){
var startDate = document.getElementById("startDate").value;
var endDate = document.getElementById("endDate").value;
q = "SELECT JobID, JListDate, jobtitle, CName FROM job "
+ "WHERE '" + startDate + "' < JListDate "
+ "AND JListDate < '" + endDate + "' ";
//+ "for date > '1992-07-01';";
queryForm();
}
function query5(){
var jobTitle = document.getElementById("jobTitle").value;
var salary = document.getElementById("salary").value;
q = "SELECT JobID, JListDate, JLowRange, JHighRange, CName FROM job "
+ "WHERE jobTitle='" + jobTitle + "' AND jlowrange <= '"
+ salary + "' AND '" + salary + "' <= jhighrange;";
queryForm();
}
function query6(){
var id = document.getElementById("jobID").value;
q = "SELECT user.UFName, User.ULName, User.UStreet1, user.UStreet2, user.UCity, state.StateName, user.UEmail "
+ "FROM user, state, seeker, job, applies "
+ "WHERE user.UName=seeker.UName "
+ "AND state.stateID=user.StateID "
+ "AND applies.JobID=job.JobID "
+ "AND applies.UName=seeker.UName "
+ "AND job.jobID='" + id + "';";
queryForm();
}
function query7(){
var college = document.getElementById("college").value;
q = "SELECT UniversityName, user.ULName, UFName, User.UStreet1, user.UStreet2, user.UCity, state.StateName, user.UEmail "
+ "FROM seeker, user, university, education, state, resume "
+ "WHERE education.DegreeTypeID=3 "
+ "AND seeker.UName=user.UName "
+ "AND seeker.UName=resume.UName "
+ "AND resume.ResumeID=education.ResumeID "
+ "AND education.EUniversityID=university.UniversityID "
+ "AND university.UniversityName='" + college + "';";
queryForm();
}
function query8(){
var start = document.getElementById("paymentStartDate").value;
var end = document.getElementById("paymentEndDate").value;
q = "SELECT payment.PaymentID, PAmount, pstatus.Name, PDate, INumber, CCNumber, BVNumber "
+ "FROM payment, pstatus, bankpayment, invoice, creditcard "
+ "WHERE payment.PaymentID = bankpayment.PaymentID "
+ "AND payment.PaymentID = creditcard.PaymentID "
+ "AND payment.PaymentID = invoice.PaymentID "
+ "AND '" + start + "'<= pdate AND pdate <= '" + end + "';";
queryForm();
}
function query9(){
q = "SELECT DISTINCT job.JobID, job.JListDate, job.JobTitle "
+ "FROM job, job_skills, skill "
+ "WHERE job.JobID = job_skills.JobID "
+ "AND job_skills.SSkillID = skill.SSkillID ";
var list = document.getElementById("skillset");
for(var i = 0; i < list.length; i++){
var option = list[i].text;
if(i==0)
q += "AND (skill.SSkillName='" + option + "')";
else
q += " OR (skill.SSkillName='" + option + "')";
}
queryForm();
}
function query10(){
q = "SELECT DISTINCT user.UFName, User.ULName, User.UStreet1, user.UStreet2, user.UCity, state.StateName, user.UEmail "
+ "FROM user,state,seeker, job, applies, job_skills, skill, resume, skillset "
+ "WHERE user.UName = seeker.UName "
+ "AND state.stateID = user.StateID "
+ "AND user.UName = resume.UName "
+ "AND skillset.ResumeID = resume.ResumeID "
+ "AND skillset.SSkillID = skill.SSkillID "
+ "AND applies.JobID = job.JobID "
+ "AND applies.UName = seeker.UName "
+ "AND job.JobID = job_skills.JobID "
+ "AND job_skills.SSkillID = skill.SSkillID ";
var list = document.getElementById("skillset");
for(var i = 0; i < list.length; i++){
var option = list[i].text;
q += " AND (skill.SSkillName='" + option + "')";
}
+ "AND skill.SSkillName = input (part of list)";
queryForm();
}
function addSkill(){
var skill = document.getElementById("skillInput").value;
var option = new Option(skill);
var list = document.getElementById("skillset");
list.add(option, 0);
}
function removeSkill(){
}
</script>
</head>
</html>