if (array_key_exists('currency-update-db', $_POST) == 1) {
$currency = new Currency($mCfg->getCurrencyCode());
DbHelper::updateSalesCurrency($currency);
}
Helper::pushAlert(ALERT_SUCCESS, 'Configuration saved.');
} else {
Helper::pushAlert(ALERT_ERROR, $error);
}
header('Location:index.php?p=' . PAGE_ID_CONFIG);
break;
//////// DEL USER
//////// DEL USER
case 'deluser':
$userId = @$_POST['userId'];
if (!empty($userId)) {
if (DBHelper::countRows(TBL_USERS) > 1) {
if (DBHelper::deleteUsers($userId)) {
Helper::pushAlert(ALERT_SUCCESS, 'User deleted with success !');
} else {
Helper::pushAlert(ALERT_ERROR, 'Unable to delete user with id #' . $userId);
}
} else {
Helper::pushAlert(ALERT_ERROR, 'You must keep at least one user !!!');
}
} else {
Helper::pushAlert(ALERT_ERROR, 'User id is not valid !');
}
header('Location:index.php?p=' . PAGE_ID_USERS);
break;
//////// EDIT USER
//////// EDIT USER
echo '<i style="padding-left:30px;" >|_ Update reports in (' . implode(', ', $issue['reports']) . ') with issue id ' . $issueId . ' ... </i>';
if (DBHelper::updateReportsIssue($issue['reports'], $issueId)) {
echo '<i>OK</i><br/>';
} else {
echo '<i style="color:red" >FAILED</i><br/>';
}
} else {
echo '<i style="color:red" >FAILED</i><br/>';
echo '<i style="padding-left:30px; color:red; font-weight:bold;" >' . DBHelper::getLastError() . '</i><br/>';
}
}
} catch (Exception $e) {
echo '<b style="padding-left:30px; color:red;" >' . $e->getMessage() . '</b><br/>';
exit;
}
echo '<b>Step 5.</b> ... OK<br/>';
echo '<b>Step 6.</b> Create database triggers ... ';
$res = DBHelper::exec($sql[1], true);
if ($res != null) {
echo '<br/><b style="padding-left:30px; color:red;" >' . $res . '</b>';
exit;
}
DBHelper::clearStoredResults();
// count triggers
$res = DBHelper::countRows('information_schema.triggers', null, true);
if ($res != 4) {
echo '<b style="color:red" >FAILED</b><br/><b style="padding-left:30px; color:red;" >All triggers not created properly !</b>';
} else {
echo 'OK<br/>';
}
echo '<p><b style="color:green" >UPDATE IS COMPLETE !</b></p>';
