public function __construct()
{
adminGateKeeper();
$name = pageArray(2);
if ($name != "user") {
$query = "DELETE FROM `entities` WHERE `type` = '{$name}'";
Dbase::query($query);
$query = "DROP TABLE `{$name}`";
Dbase::query($query);
Systemvariable::set("setup_complete", "false");
clearCache();
Cache::clear();
Cache::clear();
Cache::clear();
new SystemMessage("Your table has been deleted.");
}
forward();
}
public function __construct()
{
adminGateKeeper();
$admin_guids = getAdminGuidArray();
$admin_guids = implode(",", $admin_guids);
$name = pageArray(2);
$query = "DELETE FROM `entities` WHERE `type` = '{$name}' AND `guid` NOT IN ({$admin_guids})";
Dbase::query($query);
if ($name != "User") {
$query = "DELETE FROM `{$name}`";
} else {
$query = "DELETE FROM `{$name}` WHERE `guid` NOT IN ({$admin_guids})";
}
Dbase::query($query);
clearCache();
Cache::clear();
Cache::clear();
Cache::clear();
Systemvariable::set("setup_complete", "false");
new SystemMessage("Your table has been purged.");
forward();
}
static function addColumn($column, $type)
{
$type = strtolower($type);
$columns = Cache::get("table_columns", "site");
if (!$columns) {
$columns = array();
}
if (!isset($columns[$type][$column])) {
$columns[$type][] = $column;
$query = "ALTER TABLE `{$type}` ADD `{$column}` VARCHAR(50);";
Dbase::query($query);
}
return true;
}
private static function TriggerAlerts($module, $action)
{
global $currentuser, $currentorg;
if (!$currentuser || !$currentorg) {
return;
}
$user_id = $currentuser->user_id;
$org_id = $currentorg->org_id;
$db = new Dbase('stores');
$sql = "SELECT nc.*, o.name as org_name FROM notification_configs nc\n\t\t\t\tJOIN actions a ON a.id = nc.action_id\n\t\t\t\tJOIN modules m ON m.id = a.module_id\n\t\t\t\tJOIN user_management.organizations o ON o.id = {$org_id}\n\t\t\t\tWHERE m.code = '{$module}' AND a.code = '{$action}' AND nc.org_id = {$org_id}";
$result = $db->query_firstrow($sql);
if ($result) {
$report_to = json_decode($result['report_to'], true);
$send_sms = $result['send_sms'] == 'YES' ? true : false;
$send_email = $result['send_email'] == 'YES' ? true : false;
$action_id = $result['action_id'];
$apache_thread_id = $_SERVER['UNIQUE_ID'];
$org_name = $result['org_name'];
$user_name = $currentuser->username;
$time = date('Y-m-d G:i:s');
$sql = "INSERT INTO access_logs\n\t\t\t\t\t(action_id, params, user_id, org_id, time, apache_thread_id)\n\t\t\t\t\tVALUES\n\t\t\t\t\t({$action_id}, '', {$user_id}, {$org_id}, NOW(), '{$apache_thread_id}')";
$ret = $db->insert($sql);
$subject = "{$module} / {$action} accessed by {$user_name}";
$msg = "The user {$user_name} from {$org_name} has accessed {$module} / {$action} at {$time}";
$sql = "SELECT mobile, email FROM user_management.users WHERE id IN (" . Util::joinForSql($report_to) . ")";
$result = $db->query($sql);
foreach ($result as $row) {
if ($send_email) {
Util::sendEmail($row['email'], $subject, $msg, $org_id);
}
if ($send_sms) {
Util::sendSms($row['mobile'], $msg, $org_id);
}
}
}
}
function runDbaseQuery($query)
{
return Dbase::query($query);
}
public function delete()
{
Cache::delete("entity_" . $this->guid);
$guid = $this->guid;
$query = "DELETE FROM `" . strtolower($this->type) . "` WHERE `guid`='{$this->guid}'";
Dbase::query($query);
$query = "DELETE FROM `entities` WHERE `id`='{$this->guid}'";
Dbase::query($query);
$tables = Dbase::getAllTables();
foreach ($tables as $table) {
$query = "DELETE FROM {$table} WHERE `owner_guid` = '{$this->guid}'";
Dbase::query($query);
$query = "DELETE FROM {$table} WHERE `container_guid` = '{$this->guid}'";
Dbase::query($query);
}
return true;
}
