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

		@@ -76,11 +76,15 @@
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	+ }
80	83	if( ! $e['employee_id'] ) continue;
	84	+ if( ! $e['user_id'] ) continue;
81	85	$this->repoEmployeeUser[ $e['employee_id'] ] = $e['user_id'];
82		- $this->repoUserEmployee[ $e['user_id'] ] = $e['employee_id'];
	86	+ $this->repoUserEmployee[ $e['user_id'] ?? '' ] = $e['employee_id'];
83	87	}
84	88
85	89	if( $this->repoUserEmployee ){
86	90	$this->repoUser = $this->usersQuery->findManyById( array_keys($this->repoUserEmployee) );