function definition()
 {
     global $CFG, $currentSess, $mid, $USER, $DB;
     $mform =& $this->_form;
     // Don't forget the underscore!
     $mform->addElement('header', 'mainheader', '<span style="font-size:18px">' . get_string('requestReview_Summary', 'block_cmanager') . '</span>');
     $mform->addElement('html', '<p></p><center>' . get_string('requestReview_intro1', 'block_cmanager') . '<br>' . get_string('requestReview_intro2', 'block_cmanager') . '</center><p></p>&nbsp;<p></p>&nbsp;');
     $rec = $DB->get_recordset_select('block_cmanager_records', 'id = ' . $mid);
     $displayModHTML = block_cmanager_display_admin_list($rec, false, false, false, '');
     $mform->addElement('html', $displayModHTML);
     $buttonarray = array();
     $buttonarray[] =& $mform->createElement('submit', 'submitbutton', get_string('requestReview_SubmitRequest', 'block_cmanager'));
     $buttonarray[] =& $mform->createElement('submit', 'alter', get_string('requestReview_AlterRequest', 'block_cmanager'));
     $buttonarray[] =& $mform->createElement('cancel', 'cancel', get_string('requestReview_CancelRequest', 'block_cmanager'));
     $mform->addGroup($buttonarray, 'buttonar', '', array(' '), false);
 }
    function definition()
    {
        global $CFG;
        global $USER, $DB;
        $mform =& $this->_form;
        // Don't forget the underscore!
        $selectQuery = "status = 'PENDING' ORDER BY id ASC";
        // If search is enabled then use the
        // search parameters
        if ($_POST && isset($_POST['search'])) {
            $searchText = required_param('searchtext', PARAM_TEXT);
            $searchType = required_param('searchtype', PARAM_TEXT);
            if (!empty($searchText) && !empty($searchType)) {
                if ($searchType == 'code') {
                    $selectQuery = "`modcode` LIKE '%{$searchText}%'";
                } else {
                    if ($searchType == 'title') {
                        $selectQuery = "`modname` LIKE '%{$searchText}%'";
                    } else {
                        if ($searchType == 'requester') {
                            $selectQuery = "`createdbyid` IN (Select id from " . $CFG->prefix . "user where `firstname` LIKE '%{$searchText}%' OR `lastname` \n            LIKE '%{$searchText}%' OR `username` LIKE '%{$searchText}%')";
                        }
                    }
                }
            }
            //  if ($searchType != 'requester'){
            $selectQuery .= " AND status = 'PENDING' ORDER BY id ASC";
            //  }
        }
        // Get the list of records
        $pendingList = $DB->get_recordset_select('block_cmanager_records', $select = $selectQuery);
        $outputHTML = block_cmanager_display_admin_list($pendingList, true, true, true, 'admin_queue');
        $mform->addElement('header', 'mainheader', '<span style="font-size:18px">' . get_string('currentrequests', 'block_cmanager') . '</span>');
        $bulkActions = "<p></p>\n\t\t\t    <div style=\"width: 200px; text-align:left; padding:10px; font-size:11pt; background-color: #eee\">\n\n                <b>" . get_string('bulkactions', 'block_cmanager') . "</b>\n\t\t\t<br>\n\t\t\t<input type=\"checkbox\" onClick=\"toggle(this)\" /> Select All<br/>\n\n\t\t\t<select id=\"bulk\" onchange='bulkaction();'>\n\t\t\t  <option></option>\n\t\t\t  <option value =\"Approve\"'>" . get_string('bulkapprove', 'block_cmanager') . "</option>\n\t\t\t  <option value=\"Deny\">" . get_string('deny', 'block_cmanager') . "</option>\n\t\t\t  <option value =\"Delete\"'>" . get_string('delete', 'block_cmanager') . "</option>\n\t\t\t</select>\n\t\t\t<p></p>\n\t\t\t</div>";
        $page1_fieldname1 = $DB->get_field_select('block_cmanager_config', 'value', "varname='page1_fieldname1'");
        $page1_fieldname2 = $DB->get_field_select('block_cmanager_config', 'value', "varname='page1_fieldname2'");
        $searchHTML = '
        <div style="width: 200px; background-color:#eee; padding:10px; ">
	 	<form action="cmanager_admin.php?search=1" method="post">

	 	<b><span style="font-size:11pt">' . get_string('search_side_text', 'block_cmanager') . '</span></b>
	 	<br> <input type="text" name="searchtext" id="searchtext"></input><br>
	 	<span style="font-size:11pt">
	 	<select name="searchtype" id="searchtype">
  		<option value="code">' . $page1_fieldname1 . '</option>
		<option value="title">' . $page1_fieldname2 . '</option>
  		<option value="requester">' . get_string('searchAuthor', 'block_cmanager') . '</option>
		</select>
		</span>
		<br>
		<span style="font-size:11pt">
		<input type="submit" value="' . get_string('searchbuttontext', 'block_cmanager') . '" name="search"></input>
		</span>
		</form>

		';
        if ($_POST && isset($_POST['search'])) {
            $searchHTML .= '<br><p></p><a href="cmanager_admin.php">[Clear Search]</a>';
        }
        $searchHTML .= '</div>';
        $mainBody = '

	<div id="pagemain">
		<div id="leftpanel" style="padding-right:10px; width:200px; float:left; height:100%">' . $searchHTML . '' . $bulkActions . '</div>
			<div id="rightpanel" style=" margin-left:250px;">

					<div id="wrapper">' . $outputHTML . '</div>

		</div>
    </div>';
        $mform->addElement('html', $mainBody);
    }
    function definition()
    {
        global $CFG, $DB, $USER;
        $mform =& $this->_form;
        // Don't forget the underscore!
        $mform->addElement('header', 'mainheader', ' <span style="font-size:18px"> ' . get_string('cmanagerExstingTab', 'block_cmanager') . '</span>');
        $mform->addElement('html', '<p></p>&nbsp;&nbsp;&nbsp;' . get_string('cmanagerWelcome', 'block_cmanager') . ' &nbsp;
		                            <p></p><br>
		                            &nbsp;&nbsp;<INPUT TYPE="BUTTON" VALUE="' . get_string('cmanagerRequestBtn', 'block_cmanager') . '" ONCLICK="window.location.href=\'course_request.php?mode=1\'"><br>
		                            <p></p><p></p>&nbsp;');
        $uid = $USER->id;
        // Get the list of pending requests
        $pendinglist = $DB->get_records('block_cmanager_records', array('createdbyid' => "{$uid}", 'status' => 'PENDING'), 'id ASC');
        $outputhtml = '<div id="pendingrequestcontainer">';
        // Existing Requests
        $outputhtml = block_cmanager_display_admin_list($pendinglist, true, false, false, 'user_manager');
        $mform->addElement('html', '
	                                <p></p>
	                                &nbsp;
	                                <p></p>
	                                <div style="">	' . $outputhtml . '</div>');
    }
    function definition()
    {
        global $CFG;
        global $currentSess;
        global $mid;
        global $USER, $DB;
        $rec = $DB->get_record('block_cmanager_records', array('id' => $mid));
        $mform =& $this->_form;
        // Don't forget the underscore!
        $mform->addElement('header', 'mainheader', '<span style="font-size:18px">' . get_string('viewsummary', 'block_cmanager') . '</span>');
        // Page description text
        $mform->addElement('html', '<p></p>&nbsp;&nbsp;&nbsp;
				                <button type="button" value="" onclick="goBack();"><img src="icons/back.png"/>' . get_string('back', 'block_cmanager') . '</button> <p></p>');
        $rec = $DB->get_recordset_select('block_cmanager_records', 'id = ' . $mid);
        $displayModHTML = block_cmanager_display_admin_list($rec, false, false, false, '');
        $mform->addElement('html', '' . $displayModHTML . '');
        $mform->addElement('html', '<p></p>&nbsp;');
        $whereQuery = "instanceid = '{$mid}' ORDER BY id DESC";
        $modRecords = $DB->get_recordset_select('block_cmanager_comments', $whereQuery);
        $htmlOutput = '';
        foreach ($modRecords as $record) {
            // Get the username of the person
            $username = $DB->get_field('user', 'username', array('id' => $record->createdbyid));
            $htmlOutput .= '	<tr>';
            $htmlOutput .= ' <td width="150px">' . $record->dt . '</td>';
            $htmlOutput .= ' <td width="300px">' . $record->message . '</td>';
            $htmlOutput .= ' <td width="100px">' . $username . '</td>';
            $htmlOutput .= ' <tr>';
        }
        $mform->addElement('html', '<p></p>

	<table width="700px" style="border: 1px #000000 solid;">
			 <tr>
	             <td width="170px">' . get_string('comments_date', 'block_cmanager') . '</td>
		         <td width="430px">' . get_string('comments_message', 'block_cmanager') . '</td> 
		         <td width="100px">' . get_string('comments_from', 'block_cmanager') . '</td> 
		         </tr>
	 </table>

	
	<p></p>
	<table width="700px">
			 <tr>
		             <td width="170px"></td>
		             <td width="430px"></td> 
		             <td width="100px"></td> 
		         <tr>
			' . $htmlOutput . '
			 </table>
	

	<p></p>
	<p></p>
	');
    }
    function definition()
    {
        global $CFG, $DB, $USER;
        $mform =& $this->_form;
        // Don't forget the underscore!
        $mform->addElement('header', 'mainheader', '<span style="font-size:18px"> ' . get_string('myarchivedrequests', 'block_cmanager') . '</span>');
        $mform->addElement('html', '<p></p>&nbsp;&nbsp;&nbsp;' . get_string('cmanagerWelcome', 'block_cmanager') . ' &nbsp;
			<p></p><br>
			&nbsp;&nbsp;<INPUT TYPE="BUTTON" VALUE="' . get_string('cmanagerRequestBtn', 'block_cmanager') . '" ONCLICK="window.location.href=\'course_request.php?mode=1\'"><br>
			<p></p><p></p>&nbsp;');
        $uid = $USER->id;
        $selectQuery = "createdbyid = {$uid} AND status = 'COMPLETE' OR createdbyid = {$uid} AND status = 'REQUEST DENIED' ORDER BY id DESC";
        //$DB->sql_order_by_text('id', $numchars=32);
        $pendingList = $DB->get_recordset_select('block_cmanager_records', $select = $selectQuery);
        $page1_fieldname1 = $DB->get_field_select('block_cmanager_config', 'value', "varname = 'page1_fieldname1'");
        $page1_fieldname2 = $DB->get_field_select('block_cmanager_config', 'value', "varname = 'page1_fieldname2'");
        $page1_fieldname4 = $DB->get_field_select('block_cmanager_config', 'value', "varname = 'page1_fieldname4'");
        $outputHTML = '';
        $modsHTML = block_cmanager_display_admin_list($pendingList, true, false, false, 'user_history');
        $outputHTML .= '<center><div id="existingrequest" style="border-bottom:1px solid black; height:300px; background:transparent"></div></center> ';
        $outputHTML = $modsHTML;
        $mform->addElement('html', $outputHTML);
    }
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
//
// COURSE REQUEST MANAGER BLOCK FOR MOODLE
// by Kyle Goslin & Daniel McSweeney
// Copyright 2012-2014 - Institute of Technology Blanchardstown.
// ---------------------------------------------------------
/**
 * COURSE REQUEST MANAGER
 *
 * @package    block_cmanager
 * @copyright  2014 Kyle Goslin, Daniel McSweeney
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
require_once "../../../config.php";
global $CFG, $DB;
$formPath = "{$CFG->libdir}/formslib.php";
require_once $formPath;
require_login();
require_once '../lib/displayLists.php';
$context = context_system::instance();
if (has_capability('block/cmanager:viewrecord', $context)) {
} else {
    print_error(get_string('cannotviewrecord', 'block_cmanager'));
}
$mid = required_param('id', PARAM_INT);
$rec = $DB->get_recordset_select('block_cmanager_records', 'id = ' . $mid);
$displayModHTML = block_cmanager_display_admin_list($rec, false, false, false, '');
echo '<div style="font-family: Arial,Verdana,Helvetica,sans-serif">';
echo $displayModHTML;
echo '</div>';
 function definition()
 {
     global $CFG, $currentSess, $mid, $USER, $DB;
     $rec = $DB->get_record('block_cmanager_records', array('id' => $mid));
     $mform =& $this->_form;
     // Don't forget the underscore!
     $mform->addElement('header', 'mainheader', '<span style="font-size:18px">' . get_string('courserequestadmin', 'block_cmanager') . '</span>');
     // Page description text
     $mform->addElement('html', '<p></p>&nbsp;&nbsp;&nbsp;   <button type="button" ><img src="../icons/back.png"/>' . get_string('back', 'block_cmanager') . '</button><p></p>');
     $rec = $DB->get_recordset_select('block_cmanager_records', 'id = ' . $mid);
     $displayModHTML = block_cmanager_display_admin_list($rec, false, false, false, '');
     $outputHTML = '<div>' . $displayModHTML . '</div>';
     $mform->addElement('html', $outputHTML);
     $mform->addElement('html', '<button type="button" onclick="window.location.href=\'approve_course_new.php\'">' . get_string('requestReview_ApproveRequest', 'block_cmanager') . '</button>');
     $mform->addElement('html', '<button type="button" onclick="return popitup(\'showcoursedetails.php?id=' . $mid . '\')">' . get_string('requestReview_OpenDetails', 'block_cmanager') . '</button>');
 }