View Issue Detail

ID	Project	Category	Submitted / Last Updated
01859	UserSpice	Misc	2023-06-20 05:18:30 / 2024-01-28 21:53:04
Reported	Espresso Dan	Resolved By	Dan Hoover
Priority	none	Reported	5.6.1
Status	resolved fixed	Resolution Version and Commit	5.6.7
Summary	SAAS org cannot be de-activated if no users are assigned
Description	if (!empty($_POST['deact'])) { $users = $db->query("SELECT * FROM users WHERE account_owner = ?", [$org->id])->results(); $db->query("DELETE FROM us_saas_mrg WHERE org = ?", [$org->id]); foreach ($users as $u) { if ($u->id != 1 && $u->id != $org->owner) { $db->update('users', $u->id, ['permissions' => 0]); $db->update('us_saas_orgs', $org->id, ['active' => 0]); } if ($u->id != 1 && $u->id == $org->owner) { $db->update('users', $u->id, ['permissions' => 1]); $db->update('users', $u->id, ['account_owner' => 1]); } } Redirect::to('admin.php?view=plugins_config&plugin=saas&v=org'); } Change - Move deactivation of org in us_saas_orgs to outside of the foreach loop: if (!empty($_POST['deact'])) { $users = $db->query("SELECT * FROM users WHERE account_owner = ?", [$org->id])->results(); $db->query("DELETE FROM us_saas_mrg WHERE org = ?", [$org->id]); foreach ($users as $u) { if ($u->id != 1 && $u->id != $org->owner) { $db->update('users', $u->id, ['permissions' => 0]); } if ($u->id != 1 && $u->id == $org->owner) { $db->update('users', $u->id, ['permissions' => 1]); $db->update('users', $u->id, ['account_owner' => 1]); } } $db->update('us_saas_orgs', $org->id, ['active' => 0]); Redirect::to('admin.php?view=plugins_config&plugin=saas&v=org'); }