function search_certificate($item) { $list = ""; $certificates = array(); $invoice = new Invoices(); $users_array = array_unique($invoice->search_invoice_users($item)); $courses_array = array_unique($invoice->search_invoice_courses($item)); $classes_array = array_unique($this->get_certificate_classes($item)); $programs_array = array_unique(array_merge($courses_array, $classes_array)); $users_list = implode(",", $users_array); $courses_list = implode(",", $programs_array); /* * echo "<br>--------------Users array--------------<br>"; print_r($users_array); echo "<br>--------------Classes array--------------<br>"; print_r($classes_array); echo "<br>--------------Courses array--------------<br>"; print_r($courses_array); echo "<br>--------------Programs array--------------<br>"; print_r($programs_array); echo "<br>"; * */ if ($users_list != '') { $query = "select * from mdl_certificates " . "where userid in ({$users_list}) order by issue_date desc "; } // end if $users_list != '' if ($courses_list != '') { $query = "select * from mdl_certificates " . "where courseid in ({$courses_list}) order by issue_date desc "; } // end if $courses_list != '' if ($users_list != '' && $courses_list != '') { $query = "select * from mdl_certificates " . "where (courseid in ({$courses_list}) " . "or userid in ({$users_list})) order by issue_date desc "; } // end if $users_list != '' && $courses_list != '' //echo "Certificates query: " . $query . "<br>"; $num = $this->db->numrows($query); if ($num > 0) { $result = $this->db->query($query); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $certificate = new stdClass(); foreach ($row as $key => $value) { $certificate->{$key} = $value; } $certificates[] = $certificate; } // end while $list .= $this->create_certificates_list($certificates, false, true, false); } else { $list .= "<div class='container-fluid' style='text-align:center;'>"; $list .= "<span class='span6'>No Certificates found</span>"; $list .= "</div>"; } return $list; }