← All changes | sh4/app/query.php +1 -5 trunk → 4.9.85 View file →

		@@ -76,15 +76,11 @@
76	76	global $wpdb;
77	77	$sql = 'SELECT post_id AS employee_id, meta_value AS user_id FROM ' . $wpdb->postmeta . ' wpostmeta' . ' JOIN ' . $wpdb->posts . ' wposts ON wposts.ID = wpostmeta.post_id WHERE wpostmeta.meta_key="user_id" AND wposts.post_type="sh4_employee"';
78	78	$res = $wpdb->get_results( $sql, ARRAY_A );
79	79	foreach( $res as $e ){
80		- if (!isset($e['user_id'])) {
81		- continue;
82		- }
83	80	if( ! $e['employee_id'] ) continue;
84		- if( ! $e['user_id'] ) continue;
85	81	$this->repoEmployeeUser[ $e['employee_id'] ] = $e['user_id'];
86		- $this->repoUserEmployee[ $e['user_id'] ?? '' ] = $e['employee_id'];
	82	+ $this->repoUserEmployee[ $e['user_id'] ] = $e['employee_id'];
87	83	}
88	84
89	85	if( $this->repoUserEmployee ){
90	86	$this->repoUser = $this->usersQuery->findManyById( array_keys($this->repoUserEmployee) );