コード例 #1
0
ファイル: lib.php プロジェクト: gabrielrosset/moodle
/**
 * Get the ids of all the records that match that advanced search criteria
 * This goes and loops through each criterion one at a time until it either
 * runs out of records or returns a subset of records.
 *
 * @param array $recordids    An array of record ids.
 * @param array $searcharray  Contains information for the advanced search criteria
 * @param int $dataid         The data id of the database.
 * @return array $recordids   An array of record ids.
 */
function data_get_advance_search_ids($recordids, $searcharray, $dataid)
{
    // Check to see if we have any record IDs.
    if (empty($recordids)) {
        // Send back an empty search.
        return array();
    }
    $searchcriteria = array_keys($searcharray);
    // Loop through and reduce the IDs one search criteria at a time.
    foreach ($searchcriteria as $key) {
        $recordids = data_get_recordids($key, $searcharray, $dataid, $recordids);
        // If we don't have anymore IDs then stop.
        if (!$recordids) {
            break;
        }
    }
    return $recordids;
}
コード例 #2
0
ファイル: lib.php プロジェクト: nickbert77/moodle
/**
 * Get the ids of all the records that match that advanced search criteria
 * This goes and loops through each criterion one at a time until it either
 * runs out of records or returns a subset of records.
 *
 * @param array $recordids    An array of record ids.
 * @param array $searcharray  Contains information for the advanced search criteria
 * @param int $dataid         The data id of the database.
 * @return array $recordids   An array of record ids.
 */
function data_get_advance_search_ids($recordids, $searcharray, $dataid) {
    $searchcriteria = array_keys($searcharray);
    // Loop through and reduce the IDs one search criteria at a time.
    foreach ($searchcriteria as $key) {
        $recordids = data_get_recordids($key, $searcharray, $dataid, $recordids);
        // If we don't have anymore IDs then stop.
        if (!$recordids) {
            break;
        }
    }
    return $recordids;
}
コード例 #3
0
ファイル: search_test.php プロジェクト: Jtgadbois/Pedadida
    /**
     * Test 1: The function data_get_all_recordids.
     *
     * Test 2: This tests the data_get_advance_search_ids() function. The function takes a set
     * of all the record IDs in the database and then with the search details ($this->recordsearcharray)
     * returns a comma seperated string of record IDs that match the search criteria.
     *
     * Test 3: This function tests data_get_recordids(). This is the function that is nested in the last
     * function (@see data_get_advance_search_ids). This function takes a couple of
     * extra parameters. $alias is the field alias used in the sql query and $commaid
     * is a comma seperated string of record IDs.
     *
     * Test 4: data_get_advanced_search_sql provides an array which contains an sql string to be used for displaying records
     * to the user when they use the advanced search criteria and the parameters that go with the sql statement. This test
     * takes that information and does a search on the database, returning a record.
     *
     * Test 5: Returning to data_get_all_recordids(). Here we are ensuring that the total amount of record ids is reduced to
     * match the group conditions that are provided. There are 25 entries which relate to group 2. They are removed
     * from the total so we should only have 75 records total.
     *
     * Test 6: data_get_all_recordids() again. This time we are testing approved database records. We only want to
     * display the records that have been approved. In this record set we have 89 approved records.
     */
    function test_advanced_search_sql_section() {
        global $DB;

        // Test 1
        $recordids = data_get_all_recordids($this->recorddata->id);
        $this->assertEquals(count($recordids), $this->datarecordcount);

        // Test 2
        $key = array_keys($this->recordsearcharray);
        $alias = $key[0];
        $newrecordids = data_get_recordids($alias, $this->recordsearcharray, $this->recorddata->id, $recordids);
        $this->assertEquals($this->datarecordset, $newrecordids);

        // Test 3
        $newrecordids = data_get_advance_search_ids($recordids, $this->recordsearcharray, $this->recorddata->id);
        $this->assertEquals($this->datarecordset, $newrecordids);

        // Test 4
        $sortorder = 'ORDER BY r.timecreated ASC , r.id ASC';
        $html = data_get_advanced_search_sql('0', $this->recorddata, $newrecordids, '', $sortorder);
        $allparams = array_merge($html['params'], array('dataid' => $this->recorddata->id));
        $records = $DB->get_records_sql($html['sql'], $allparams);
        $this->assertEquals($records, $this->finalrecord);

        // Test 5
        $groupsql = " AND (r.groupid = :currentgroup OR r.groupid = 0)";
        $params = array('currentgroup' => 1);
        $recordids = data_get_all_recordids($this->recorddata->id, $groupsql, $params);
        $this->assertEquals($this->groupdatarecordcount, count($recordids));

        // Test 6
        $approvesql = ' AND r.approved=1 ';
        $recordids = data_get_all_recordids($this->recorddata->id, $approvesql, $params);
        $this->assertEquals($this->approvedatarecordcount, count($recordids));
    }
コード例 #4
0
ファイル: search_test.php プロジェクト: JP-Git/moodle
    /**
     * Test 1: The function data_get_all_recordids.
     *
     * Test 2: This tests the data_get_advance_search_ids() function. The function takes a set
     * of all the record IDs in the database and then with the search details ($this->recordsearcharray)
     * returns a comma seperated string of record IDs that match the search criteria.
     *
     * Test 3: This function tests data_get_recordids(). This is the function that is nested in the last
     * function (@see data_get_advance_search_ids). This function takes a couple of
     * extra parameters. $alias is the field alias used in the sql query and $commaid
     * is a comma seperated string of record IDs.
     *
     * Test 4: data_get_advanced_search_sql provides an array which contains an sql string to be used for displaying records
     * to the user when they use the advanced search criteria and the parameters that go with the sql statement. This test
     * takes that information and does a search on the database, returning a record.
     */
    function test_advanced_search_sql_section() {
        global $DB;

        // Test 1
        $recordids = data_get_all_recordids($this->recorddata->id);
        $this->assertEquals(count($recordids), $this->datarecordcount);

        // Test 2
        $key = array_keys($this->recordsearcharray);
        $alias = $key[0];
        $newrecordids = data_get_recordids($alias, $this->recordsearcharray, $this->recorddata->id, $recordids);
        $this->assertEquals($this->datarecordset, $newrecordids);

        // Test 3
        $newrecordids = data_get_advance_search_ids($recordids, $this->recordsearcharray, $this->recorddata->id);
        $this->assertEquals($this->datarecordset, $newrecordids);

        // Test 4
        $sortorder = 'ORDER BY r.timecreated ASC , r.id ASC';
        $html = data_get_advanced_search_sql('0', $this->recorddata, $newrecordids, '', $sortorder);
        $allparams = array_merge($html['params'], array('dataid' => $this->recorddata->id));
        $records = $DB->get_records_sql($html['sql'], $allparams);
        $this->assertEquals($records, $this->finalrecord);
    }
コード例 #5
0
ファイル: search_test.php プロジェクト: evltuma/moodle
 /**
  * Test 1: The function data_get_all_recordids.
  *
  * Test 2: This tests the data_get_advance_search_ids() function. The function takes a set
  * of all the record IDs in the database and then with the search details ($this->recordsearcharray)
  * returns a comma seperated string of record IDs that match the search criteria.
  *
  * Test 3: This function tests data_get_recordids(). This is the function that is nested in the last
  * function (see data_get_advance_search_ids). This function takes a couple of
  * extra parameters. $alias is the field alias used in the sql query and $commaid
  * is a comma seperated string of record IDs.
  *
  * Test 3.1: This tests that if no recordids are provided (In a situation where a search is done on an empty database)
  * That an empty array is returned.
  *
  * Test 4: data_get_advanced_search_sql provides an array which contains an sql string to be used for displaying records
  * to the user when they use the advanced search criteria and the parameters that go with the sql statement. This test
  * takes that information and does a search on the database, returning a record.
  *
  * Test 5: Returning to data_get_all_recordids(). Here we are ensuring that the total amount of record ids is reduced to
  * match the group conditions that are provided. There are 25 entries which relate to group 2. They are removed
  * from the total so we should only have 75 records total.
  *
  * Test 6: data_get_all_recordids() again. This time we are testing approved database records. We only want to
  * display the records that have been approved. In this record set we have 89 approved records.
  */
 public function test_advanced_search_sql_section()
 {
     global $DB;
     // we already have 2 users, we need 98 more - let's ignore the fact that guest can not post anywhere
     // We reset the user sequence here to ensure we get the expected numbers.
     // TODO: Invent a better way for managing data file input against database sequence id's.
     $DB->get_manager()->reset_sequence('user');
     for ($i = 3; $i <= 100; $i++) {
         $this->getDataGenerator()->create_user();
     }
     // create database module - there should be more of these I guess
     $course = $this->getDataGenerator()->create_course();
     $data = $this->getDataGenerator()->create_module('data', array('course' => $course->id));
     $this->recorddata = $data;
     // Set up data for the test database.
     $files = array('data_fields' => __DIR__ . '/fixtures/test_data_fields.csv', 'data_records' => __DIR__ . '/fixtures/test_data_records.csv', 'data_content' => __DIR__ . '/fixtures/test_data_content.csv');
     $this->loadDataSet($this->createCsvDataSet($files));
     // Set dataid to the correct value now the data has been inserted by csv file.
     $DB->execute('UPDATE {data_fields} SET dataid = ?', array($data->id));
     $DB->execute('UPDATE {data_records} SET dataid = ?', array($data->id));
     // Create the search array which contains our advanced search criteria.
     $fieldinfo = array('0' => new stdClass(), '1' => new stdClass(), '2' => new stdClass(), '3' => new stdClass(), '4' => new stdClass());
     $fieldinfo['0']->id = 1;
     $fieldinfo['0']->data = '3.721,46.6126';
     $fieldinfo['1']->id = 2;
     $fieldinfo['1']->data = 'Hahn Premium';
     $fieldinfo['2']->id = 5;
     $fieldinfo['2']->data = 'Female';
     $fieldinfo['3']->id = 7;
     $fieldinfo['3']->data = 'kel';
     $fieldinfo['4']->id = 9;
     $fieldinfo['4']->data = 'VIC';
     foreach ($fieldinfo as $field) {
         $searchfield = data_get_field_from_id($field->id, $data);
         if ($field->id == 2) {
             $searchfield->field->param1 = 'Hahn Premium';
             $val = array();
             $val['selected'] = array('0' => 'Hahn Premium');
             $val['allrequired'] = 0;
         } else {
             $val = $field->data;
         }
         $search_array[$field->id] = new stdClass();
         list($search_array[$field->id]->sql, $search_array[$field->id]->params) = $searchfield->generate_sql('c' . $field->id, $val);
     }
     $this->recordsearcharray = $search_array;
     // Setting up the comparison stdClass for the last test.
     $user = $DB->get_record('user', array('id' => 6));
     $this->finalrecord[6] = new stdClass();
     $this->finalrecord[6]->id = 6;
     $this->finalrecord[6]->approved = 1;
     $this->finalrecord[6]->timecreated = 1234567891;
     $this->finalrecord[6]->timemodified = 1234567892;
     $this->finalrecord[6]->userid = 6;
     $this->finalrecord[6]->firstname = $user->firstname;
     $this->finalrecord[6]->lastname = $user->lastname;
     $this->finalrecord[6]->firstnamephonetic = $user->firstnamephonetic;
     $this->finalrecord[6]->lastnamephonetic = $user->lastnamephonetic;
     $this->finalrecord[6]->middlename = $user->middlename;
     $this->finalrecord[6]->alternatename = $user->alternatename;
     $this->finalrecord[6]->picture = $user->picture;
     $this->finalrecord[6]->imagealt = $user->imagealt;
     $this->finalrecord[6]->email = $user->email;
     // Test 1
     $recordids = data_get_all_recordids($this->recorddata->id);
     $this->assertEquals(count($recordids), $this->datarecordcount);
     // Test 2
     $key = array_keys($this->recordsearcharray);
     $alias = $key[0];
     $newrecordids = data_get_recordids($alias, $this->recordsearcharray, $this->recorddata->id, $recordids);
     $this->assertEquals($this->datarecordset, $newrecordids);
     // Test 3
     $newrecordids = data_get_advance_search_ids($recordids, $this->recordsearcharray, $this->recorddata->id);
     $this->assertEquals($this->datarecordset, $newrecordids);
     // Test 3.1
     $resultrecordids = data_get_advance_search_ids(array(), $this->recordsearcharray, $this->recorddata->id);
     $this->assertEmpty($resultrecordids);
     // Test 4
     $sortorder = 'ORDER BY r.timecreated ASC , r.id ASC';
     $html = data_get_advanced_search_sql('0', $this->recorddata, $newrecordids, '', $sortorder);
     $allparams = array_merge($html['params'], array('dataid' => $this->recorddata->id));
     $records = $DB->get_records_sql($html['sql'], $allparams);
     $this->assertEquals($records, $this->finalrecord);
     // Test 5
     $groupsql = " AND (r.groupid = :currentgroup OR r.groupid = 0)";
     $params = array('currentgroup' => 1);
     $recordids = data_get_all_recordids($this->recorddata->id, $groupsql, $params);
     $this->assertEquals($this->groupdatarecordcount, count($recordids));
     // Test 6
     $approvesql = ' AND r.approved=1 ';
     $recordids = data_get_all_recordids($this->recorddata->id, $approvesql, $params);
     $this->assertEquals($this->approvedatarecordcount, count($recordids));
 }