| public get_customer_watchable_users ( integer $customer ) : array | ||
| $customer | integer | |
| return | array | |
public function get_customer_watchable_users($customer)
{
$customerID = MySQL::SQLValue($customer['customerID'], MySQL::SQLVALUE_NUMBER);
$p = $this->kga['server_prefix'];
$query = "SELECT * FROM {$p}users WHERE trash=0 AND `userID` IN (SELECT DISTINCT `userID` FROM `{$p}timeSheet` WHERE `projectID` IN (SELECT `projectID` FROM `{$p}projects` WHERE `customerID` = {$customerID})) ORDER BY name";
$result = $this->conn->Query($query);
return $this->conn->RecordsArray(MYSQLI_ASSOC);
}