start.php ➔ get_group_member_list() - Code Metrics - Inspection of "Member paginate" - gctools-outilsgc/gcconnex - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#1880)

unknown

created 2018-08-14 11:23 UTC

start.php ➔ get_group_member_list() A

↳ Parent: Project

Complexity

Conditions	3
Paths	4

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
nc	4
nop	4
dl	0
loc	35
rs	9.36
c	0
b	0
f	0

<?php
/* File: .../solr_api/start.php
 *
 * REFERENCE: http://learn.elgg.org/en/stable/guides/web-services.html#api-authentication
 * To get the API Key, web services must be enabled: Admin > Web Services > Create API Keys
 * Please note that the API calls will display limit of 10
 *
 * Author: Christine Yu <[email protected]>
 * Company: Government of Canada
 * Date: June 1st 2018
 *
 */


elgg_register_event_handler('init','system','solr_api_init');

function solr_api_init() {

	//$method, $function, array $parameters = NULL, $description = "",
	//	$call_method = "GET", $require_api_auth = false, $require_user_auth = false

	elgg_ws_expose_function(
		'delete.updated_index_list',
		'delete_updated_index_list',
		[
			'guids' => [
				'type' => 'array',
				'required' => false,
				'description' => 'deletes records based on collection of entity guids'
			]
		],
		'deletes record that already updated the solr index',
		'POST',
		true,
		false
	);


	elgg_ws_expose_function(
        'get.entity_list',
        'get_entity_list',
        [
            'type' => [
                'type' => 'string',
                'required' => true,
                'description' => 'the type of entity in string format',
            ],
            'subtype' => [
                'type' => 'string',
                'required' => false,
                'description' => 'the subtype of entity in string format, not required',
            ],
			'offset' => [
                'type' => 'int',
                'required' => true,
                'description' => 'the subtype of entity in string format, not required',
            ],

        ],
        'retrieves all entities filtered by type [and subtype]',
        'GET',
        true,
        false
	);


	elgg_ws_expose_function(
        'get.user_list',
        'get_user_list',
        [
        	'offset' => [
        		'type' => 'int',
        		'required' => true,
        		'description' => 'paging mechanism'
        	]
        ],
        'retrieves a user list',
        'GET',
        true,
        false
	);

	elgg_ws_expose_function(
        'get.group_list',
        'get_group_list',
        [
        	'offset' => [
        		'type' => 'int',
        		'required' => true,
        		'description' => 'api loads 20 groups at a time'
        	]
        ],
        'retrieves a group list',
        'GET',
        true,
        false
	);


	elgg_ws_expose_function(
		'get.list_of_deleted_records',
		'get_list_of_deleted_records',
		null,
		'retrieves a list of deleted content',
		'GET',
		true,
		false
	);


	elgg_ws_expose_function(
		'get.group_member_list',
		'get_group_member_list',
		[
			'group_guid' => [
				'type' => 'int',
				'required' => true,
				'description' => 'group guid'
			],
			'offset' => [
				'type' => 'int',
				'required' => true,
				'description' => 'offset for pagination'
			],
			'limit' => [
				'type' => 'int',
				'required' => true,
				'description' => 'limit number of results'
			],
			'name' => [
				'type' => 'string',
				'required' => false,
				'description' => 'search member'
			]
		],
		'retrieves a list of group members',
		'GET',
		false,
		false
	);

}

// retrieves a list of group members with defined limit and offset
function get_group_member_list($group_guid, $offset, $limit, $name) {
	$users = array();
	error_log('name: ' . $name);
	$name_param = ($name != '') ? "AND ue.name LIKE '{$name}%' " : '';
	 
	$query = "SELECT ue.guid, r.time_created AS date_joined, ue.name, ue.username, ue.email
	FROM elggentity_relationships r 
		LEFT JOIN elggusers_entity ue ON r.guid_one = ue.guid
	WHERE r.guid_two = {$group_guid} AND r.relationship = 'member' {$name_param}
	ORDER BY ue.name ASC LIMIT {$limit} OFFSET {$offset}";

	$users = get_data($query);
	
	$site_url = elgg_get_site_url();

	$query = "SELECT COUNT(*) AS member_count
	FROM elggentity_relationships r 
		LEFT JOIN elggusers_entity ue ON r.guid_one = ue.guid
WHERE r.guid_two = {$group_guid} AND r.relationship = 'member' {$name_param}";

	$member_count = get_data($query);

	$arr['count'] = $member_count[0]->member_count;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
	foreach ($users as $user) {
			$arr['members'][] = array (
				'guid' => $user->guid,
				'name' => $user->name,
				'username' => $user->username,
				'email' => $user->email,
				'date_joined' => date("Y-m-d H:m:s", $user->date_joined),
				'url' => "{$site_url}profile/{$user->username}",
			);
	}
	return $arr;
}

function delete_updated_index_list($guids) {
	$ids = array();
	foreach ($guids as $guid) {
		// guid must be an integer
		if (is_numeric($guid)) 
			$ids[] = $guid;
		else
			return "there is an issue deleting a record in the database, please see function delete_updated_index_list()";
	}

	if (sizeof($ids) > 0) {
		$ids = implode(",", $ids);
		$query = "DELETE FROM deleted_object_tracker WHERE id IN ({$ids})";
		$result = delete_data($query);
	}

	$arr[] = array('message' => 'deleted the following guid');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
	$arr[] = $ids;

	return $arr;
}


// this is not an api call, this is a hook that will initiate once user attempts deletion
function intercept_object_deletion($event, $type, $object) {
	$unixtime = time();

	$query = "INSERT INTO deleted_object_tracker (id, time_deleted) VALUES ({$object->guid}, {$unixtime})";

	// just in case for some reason, the user is able to delete the same thing twice
	try {
		$insert_record = insert_data($query);
	} catch (Exception $e) {
		error_log("error occurred: {$e}");
	}

	$query = "SELECT * FROM deleted_object_tracker";
	$deleted_records = get_data($query);

	return true;
}


function get_list_of_deleted_records() {
	$query = "SELECT * FROM deleted_object_tracker";
	$deleted_records = get_data($query);

	foreach ($deleted_records as $deleted_record) {
		$arr[] = array(
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			'guid' => $deleted_record->id,
			'time_deleted' => $deleted_record->time_deleted
		);
	}
	return $arr;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
}


function get_user_list($offset) {
	$site_url = elgg_get_site_url();
	$db_prefix = elgg_get_config('dbprefix');

	$query = "	SELECT e.guid, ue.name, ue.username, ue.email, e.type, e.time_created, e.enabled
				FROM {$db_prefix}users_entity ue 
					LEFT JOIN {$db_prefix}entities e ON ue.guid = e.guid 
				WHERE e.enabled = 'yes'
				LIMIT 10 OFFSET {$offset}";

	$users = get_data($query);

	foreach ($users as $user) {
		$arr[] = array (
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			'guid' => $user->guid,
			'name' => array('en' => $user->name, 'fr' => $user->name),
			'username' => $user->username,
			'email' => $user->email,
			'type' => $user->type,
			'date_created' => date("Y-m-d\TH:m:s\Z", $user->time_created),
			'date_modified' => date("Y-m-d\TH:m:s\Z", $user->time_created),
			'url' => "{$site_url}profile/{$user->username}"
		);
	}
    return $arr;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
}


function get_group_list($offset) {
	// @TODO use SQL query syntax instead of using function elgg_get_entities()
	$groups = elgg_get_entities(array(
		'type' => 'group',
		'limit' => 10,
		'offset' => $offset
	));

	foreach ($groups as $group) {

		if (is_Json($group->name)) {
			$name_array = json_decode($group->name, true);
			$name_array['en'] = str_replace('"', '\"', $name_array['en']);
			$name_array['fr'] = str_replace('"', '\"', $name_array['fr']);
		} else {
			$name_array['en'] = $group->name_array;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$name_array['fr'] = $group->name;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
		}

		if (is_Json($group->description)) {
			$description_array = json_decode($group->description, true);
			$description_array['en'] = str_replace('"', '\"', $description_array['en']);
			$description_array['fr'] = str_replace('"', '\"', $description_array['fr']);
		} else {
			$description_array['en'] = $group->description;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$description_array['fr'] = $group->description;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
		}

		$arr[] = array(
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			'guid' => $group->getGUID(),
			'name' => $name_array,
			'description' => $description_array,
			'type' => $group->getType(),
			'access_id' => $group->access_id,
			'date_created' => date("Y-m-d\TH:m:s\Z", $group->time_created),
			'date_modified' => date("Y-m-d\TH:m:s\Z", $group->time_updated),
			'url' => $group->getURL()
		);
	}
    return $arr;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
}


function get_entity_list($type, $subtype, $offset) {
	$entities = elgg_get_entities(array(
		'type' => $type,
		'subtype' => $subtype,
		'limit' => 10,
		'offset' => $offset
	));

	foreach ($entities as $entity) {


		if (is_Json($entity->title)) {
			$title_array = json_decode($entity->title, true);
			if (!isset($title_array['en']) || !isset($title_array['fr'])) {
				$title_array['en'] = str_replace('"', '\"', $title_array);
				$title_array['fr'] = str_replace('"', '\"', $title_array);
			} else {
				$title_array['en'] = str_replace('"', '\"', gc_explode_translation($entity->title, 'en'));
				$title_array['fr'] = str_replace('"', '\"', gc_explode_translation($entity->title, 'fr'));
			}

		} else {
			$title_array['en'] = $entity->title;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$title_array['fr'] = $entity->title;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
		}

		if (is_Json($entity->description)) {
			$description_array = json_decode($entity->description, true);
			if (!isset($description_array['en']) || !isset($description_array['fr'])) {
				$description_array['en'] = str_replace('"', '\"', $description_array);
				$description_array['fr'] = str_replace('"', '\"', $description_array);
			} else {
				$description_array['en'] = str_replace('"', '\"', gc_explode_translation($entity->description, 'en'));
				$description_array['fr'] = str_replace('"', '\"', gc_explode_translation($entity->description, 'fr'));
			}
		} else {
			$description_array['en'] = $entity->description;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$description_array['fr'] = $entity->description;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
		}

		$arr[] = array(
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			'guid' => $entity->getGUID(), 
			'title' => $title_array,
			'description' => $description_array,
			'type' => $entity->getType(),
			'subtype' => $entity->getSubtype(),
			'access_id' => $entity->access_id,
			'date_created' => date("Y-m-d\TH:m:s\Z", $entity->time_created),
			'date_modified' => date("Y-m-d\TH:m:s\Z", $entity->time_updated),
			'url' => $entity->getURL()
		);
	}

	return $arr;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
}


// @TODO check if this function already exist in other modules
function is_Json($string) {
	json_decode($string);
	return (json_last_error() == JSON_ERROR_NONE);
}



Pull Request — master (#1880)

start.php ➔ get_group_member_list() A

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1			<?php
2			/* File: .../solr_api/start.php
3			*
4			* REFERENCE: http://learn.elgg.org/en/stable/guides/web-services.html#api-authentication
5			* To get the API Key, web services must be enabled: Admin > Web Services > Create API Keys
6			* Please note that the API calls will display limit of 10
7			*
8			* Author: Christine Yu <[email protected]>
9			* Company: Government of Canada
10			* Date: June 1st 2018
11			*
12			*/
13
14
15			elgg_register_event_handler('init','system','solr_api_init');
16
17			function solr_api_init() {
18
19			//$method, $function, array $parameters = NULL, $description = "",
20			// $call_method = "GET", $require_api_auth = false, $require_user_auth = false
21
22			elgg_ws_expose_function(
23			'delete.updated_index_list',
24			'delete_updated_index_list',
25			[
26			'guids' => [
27			'type' => 'array',
28			'required' => false,
29			'description' => 'deletes records based on collection of entity guids'
30			]
31			],
32			'deletes record that already updated the solr index',
33			'POST',
34			true,
35			false
36			);
37
38
39			elgg_ws_expose_function(
40			'get.entity_list',

gctools-outilsgc / gcconnex

Pull Request — master (#1880)

start.php ➔ get_group_member_list() A

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like