function renderTraining()
{
$instructors = QMModel::getInstructors(get_the_id());
$training = QMModel::getTrainingCourses($instructors);
$designCourses = array();
$teachingCourses = array();
$designCount = 0;
$teachingCount = 0;
if (empty($instructors)) {
return;
}
$training = QMModel::getTrainingCourses($instructors);
if (empty($training)) {
return;
}
$atcCourses = $training["atc"];
$designCourse = "Designing a Quality Online Course";
if (isset($atcCourses[$designCourse])) {
$designCourses = $atcCourses[$designCourse];
// $designCount = count($designCourses);
// print_r($designCourses);
if (!empty($designCourses)) {
renderTrainingTable($designCourses, 'Faculty that completed the Designing a Quality Online Course', 'design');
}
}
$teachingCourse = "Teaching a Quality Online Course";
if (isset($atcCourses[$teachingCourse])) {
$teachingCourses = $atcCourses[$teachingCourse];
// $teachingCount = count($teachingCourses);
if (!empty($teachingCourses)) {
renderTrainingTable($teachingCourses, 'Faculty that completed the Teaching a Quality Online Course', 'teaching');
}
}
}
static function importData($data, $post_type)
{
$count = 0;
foreach ($data as $dataObject) {
$posts_array = QMModel::get_posts_by_title($dataObject, $post_type);
//print_r($posts_array);
$check = true;
if (!is_null($posts_array)) {
foreach ($posts_array as $p) {
if ($p->post_status == 'publish') {
$check = false;
}
}
}
if ($check) {
$args = array('post_title' => $dataObject, 'post_status' => 'publish', 'post_content' => $dataObject, 'post_author' => 1, 'post_type' => $post_type);
$pid = wp_insert_post($args);
$count++;
}
}
}
function testDepartmentData($id)
{
$departments = QMModel::getDepartmentsData();
foreach ($departments as $object) {
if ($object->ID != $id) {
continue;
}
//get internal count
$int = count($object->internalReviews);
//get external count
$ext = count($object->externalReviews);
//get atc courses
$atcCourses = $object->training["atc"];
print_r($atcCourses);
//designing count
if (isset($atcCourses["Designing a Quality Online Course"])) {
$design = count($atcCourses["Designing a Quality Online Course"]);
}
if (isset($atcCourses["Teaching a Quality Online Course"])) {
$teaching = count($atcCourses["Teaching a Quality Online Course"]);
}
$atcarray = QMModel::get_instructor_courses(545, 'atccourses');
$qmarray = QMModel::get_instructor_courses(545, 'qmtrainingcourse');
print_r($atcarray);
echo "";
print_r($qmarray);
echo "design" . $design;
echo "teaching" . $teaching;
}
}
<?php
get_header();
require_once "qmmodel.php";
//get courses
$email = get_field('email', get_the_ID());
$reviewedCourses = QMModel::getCourses(false, $email);
$trainingCourses = QMModel::getTrainingData($email);
// print_r($trainingCourses);
?>
<div id="main">
<div id="content">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h3 class="with-line">Quality's Profile</h3>
<!-- <div class="panel panel-default">
<div class="panel-body" -->
<div class="row">
<div class="col-md-6">
<div class="form-group row clearfix">
<label for="inputFirstName" class="col-sm-3 control-label">First Name</label>
<div class="col-sm-9"><p><?php
echo get_field('name', get_the_id());
?>
</p>
</div>
echo date("m-d-Y H:i:s.u");
/**Internal*/
$coursesCount = QMModel::getReviewedCoursesCount();
$intCount = $coursesCount["internal"];
/**External*/
$extCount = $coursesCount["external"];
$atcTrainingData = QMModel::getTrainingData(false, 'ATC');
$qmTrainingData = QMModel::getTrainingData(false, 'QM');
/**QM Training */
$qmCount = count($qmTrainingData);
/**ATC Training */
$atcCount = count($atcTrainingData);
/**All Revieved Courses*/
$courses = QMModel::getReviewedCourses();
/**All Training Courses*/
$training = QMModel::getTrainingCourses();
/**Internal*/
$int = $courses["internal"];
/**External*/
$ext = $courses["external"];
/**QM Training */
$qm = $training["qm"];
/**ATC Training */
$atc = $training["atc"];
echo "After Queries " . date("m-d-Y H:i:s.u");
?>
</div>
</div>
</div>
</div>
</div>
<?php
if (!empty($atc) || count($atc) > 0) {
foreach ($atc as $date) {
$d = DateTime::createFromFormat("Y-m-d", $date["completion_date"]);
if ($d) {
$newDate = $d->format("m/d/Y");
echo '{"date":"' . $newDate . '"},';
}
}
}
?>
];
var departments = [
<?php
$departments = QMModel::getDepartmentsData();
foreach ($departments as $object) {
echo "{";
echo '"name":"' . get_the_title($object->ID) . '",';
echo '"count":"' . count($object->reviews) . '",';
echo '"training":"' . count($object->training) . '",';
echo "},";
}
?>
];
drawBarChart(departments,"Departments");
renderGraphWithSet(internalCourses, "Internal Reviews")
renderGraphWithSet(externalCourses, "External Reviews")
<tr>
<th data-field="name" data-sortable="true">Course Name</th>
<th data-field="instructorname" data-sortable="true">Name</th>
<th data-field="instructorlastname" data-sortable="true">Last Name</th>
<th data-field="instructoremail" data-sortable="true">Instructor Email</th>
<th data-field="completion" data-sortable="true">Completion Date</th>
<th data-field="training" data-sortable="true">Training Type</th>
</tr>
</thead>
</table>
<script>
var $table = $('#table');
$(function () {
var data = [<?php
$courses = QMModel::getTrainingData();
foreach ($courses as $training) {
$instructor = $training->instructor;
$instructorName = get_field('name', $instructor->ID);
$instructorLastName = get_field('lastname', $instructor->ID);
$instructorEmail = get_field('email', $instructor->ID);
// print_r($training);
echo "{";
echo '"name":"' . $training->courseName . '",';
echo '"instructorname":"<a href = \\"' . get_permalink($instructor->ID) . '\\">' . $instructorName . '</a>",';
echo '"instructorlastname":"<a href = \\"' . get_permalink($instructor->ID) . '\\">' . $instructorLastName . '</a>",';
echo '"instructoremail":"<a href = \\"' . get_permalink($instructor->ID) . '\\">' . $instructorEmail . '</a>",';
echo '"completion":"' . $training->completed . '",';
echo '"training":"' . $training->courseType . '"';
echo "},";
}
<th data-field="instructorname" data-sortable="true">Name</th>
<th data-field="instructorlastname" data-sortable="true">Last Name</th>
<th data-field="instructoremail" data-sortable="true">Instructor Email</th>
<th data-field="department" data-sortable="true">Department</th>
<th data-field="college" data-sortable="true">College</th>
<th data-field="internal" data-sortable="true">Internal</th>
<th data-field="external" data-sortable="true">External</th>
</tr>
</thead>
</table>
<script>
var $table = $('#table');
$(function () {
var data = [<?php
$courses = QMModel::getCourses();
foreach ($courses as $course) {
//print_r($course->ID);
//<a href="url-here" id="edit-1">dddd</a>
//$course->courseName
echo "{";
echo '"name":"' . $course->courseName . '",';
echo '"instructorname":"<a href = \\"' . get_permalink($course->instructorID) . '\\">' . $course->instructorName . '</a>",';
echo '"instructorlastname":"<a href = \\"' . get_permalink($course->instructorID) . '\\">' . $course->instructorLastName . '</a>",';
echo '"instructoremail":"<a href = \\"' . get_permalink($course->instructorID) . '\\">' . $course->instructorEmail . '</a>",';
echo '"department":"<a href = \\"' . get_permalink($course->departmentID) . '\\">' . $course->department . '</a>",';
echo '"college":"' . $course->college . '",';
echo '"internal":"' . $course->internalDate . '",';
echo '"external":"' . $course->externalDate . '"';
echo "},";
}
function testGetInstructors()
{
$array = QMModel::getInstructors();
echo "" . count($array);
}
