require_once dirname(__FILE__) . '/../iomad_company_admin/lib.php'; require_once 'lib.php'; require_commerce_enabled(); $sort = optional_param('sort', 'name', PARAM_ALPHA); $dir = optional_param('dir', 'ASC', PARAM_ALPHA); $page = optional_param('page', 0, PARAM_INT); $perpage = optional_param('perpage', 30, PARAM_INT); // How many per page. global $DB; // Correct the navbar. // Set the name for the page. $linktext = get_string('orders', 'block_iomad_commerce'); // Set the url. $linkurl = new moodle_url('/blocks/iomad_commerce/orderlist.php'); // Build the nav bar. company_admin_fix_breadcrumb($PAGE, $linktext, $linkurl); $blockpage = new blockpage($PAGE, $OUTPUT, 'iomad_commerce', 'block', 'orders'); $blockpage->setup(); require_login(null, false); // Adds to $PAGE, creates $OUTPUT. $context = $PAGE->context; $baseurl = new moodle_url(basename(__FILE__), array('sort' => $sort, 'dir' => $dir, 'perpage' => $perpage)); $returnurl = $baseurl; $blockpage->display_header(); // Check we can actually do anything on this page. iomad::require_capability('block/iomad_commerce:admin_view', $context); // Get the number of orders. $objectcount = $DB->count_records_sql("SELECT COUNT(*) FROM {invoice} WHERE Status != '" . INVOICESTATUS_BASKET . "'"); echo $OUTPUT->paging_bar($objectcount, $page, $perpage, $baseurl); flush(); if ($orders = $DB->get_recordset_sql("SELECT\n i.*,\n (SELECT COUNT(*) FROM {invoiceitem} ii WHERE ii.invoiceid = i.id AND processed = 0)\n AS unprocesseditems\n FROM {invoice} i\n WHERE i.Status != '" . INVOICESTATUS_BASKET . "'\n ORDER BY i.Status DESC, i.id DESC", null, $page, $perpage)) {
require_once $CFG->dirroot . '/blocks/iomad_company_admin/lib.php'; require_once 'lib.php'; // Check permissions. require_login($SITE); $context = context_system::instance(); iomad::require_capability('local/report_companies:view', $context); // Url stuff. $url = new moodle_url('/local/report_companies/index.php'); // Page stuff:. $strcompletion = get_string('pluginname', 'local_report_companies'); $PAGE->set_url($url); $PAGE->set_pagelayout('report'); $PAGE->set_title($strcompletion); $PAGE->requires->css("/local/report_companies/styles.css"); // Set the url. company_admin_fix_breadcrumb($PAGE, get_string('pluginname', 'local_report_companies'), $url); // Navigation and header. echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('pluginname', 'local_report_companies')); // Ajax odds and sods. $PAGE->requires->js_init_call('M.local_report_companies.init'); // Get the company list. $companies = companyrep::companylist($USER); companyrep::addmanagers($companies); companyrep::addusers($companies); companyrep::addcourses($companies); // Iterate over companies. foreach ($companies as $company) { echo "<div class=\"iomad_company\" />\n"; echo "<h2>{$company->name}</h2>"; // Managers.