public static List<List<Job>> getAllJobsByDate(LocalDate theDate) throws SQLException {
		
		log.entry("getAllJobsByDate (JobManager)");
		
		String sql = "SELECT ship_date, job_id, customer_name, proof_spec_date, "
				+ "job_completed, product_id, product_detail, num_colors, quantity, item_completed "
				+ "FROM Job AS j "
				+ "JOIN OrderDetail AS o "
				+ "ON j.job_id = o.order_id "
				+ "WHERE ship_date = ? "
				+ "ORDER BY proof_spec_date";
		
		java.sql.Date sqlDate = java.sql.Date.valueOf(DateManager.getSqlFormattedDate(theDate));
		List<Job> jobList = new ArrayList<Job>();
		List<Job> incompletedJobsList = new ArrayList<Job>();
		List<List<Job>> jobArray = new ArrayList<List<Job>>(2);
		String lastJob = "";
		
		try (
				PreparedStatement stmt = conn.prepareStatement(sql);
				/*				CallableStatement stmt = conn.prepareCall(
						SQL_JOBS_BY_DATE,
						ResultSet.TYPE_FORWARD_ONLY,
						ResultSet.CONCUR_READ_ONLY);*/){
			stmt.setDate(1, sqlDate);
//			stmt.registerOutParameter("total", Types.INTEGER);
			rs = stmt.executeQuery();
			
			while (rs.next()) {
				String jobId = rs.getString("job_id");
				if (!jobId.equals(lastJob))
				{
					lastJob = jobId;
					List<OrderDetail> detailList = OrderDetailManager.getRows(jobId);
					Job bean = new Job();
					
					bean.setShipDate(rs.getDate("ship_date"));
					bean.setJobId(jobId);
					bean.setCustomerName(rs.getString("customer_name"));
					bean.setProofSpecDate(rs.getTimestamp("proof_spec_date"));
					bean.setJobCompleted(rs.getTimestamp("job_completed"));
					bean.setOrderDetailList(detailList);
					jobList.add(bean);
					
					if (bean.getJobCompleted() == null)
						incompletedJobsList.add(bean);
				}
			}
			
			jobArray.add(jobList);
			jobArray.add(incompletedJobsList);
			
//			log.debug("Length of all jobs (0): " + jobArray.get(0));
//			log.debug("Length of incomplete jobs (1): " + jobArray.get(1));
			
			return log.exit(jobArray);
			
		} catch (SQLException err) {
			log.error("SQL Exception occurred when retreiving data from database.", err);
			return log.exit(null);
		} finally {
			if (rs != null) {
				rs.close();
			}
		}
	}