quote($id, PDO::PARAM_INT);
$type = V::get('TYPE', 0, $_GET, 'string');
$rows = null;
if ($type == "PROBLEM") {
$rows = DB::getPDO()->fetchAll("
SELECT * FROM _SYNC_TASK_PERCENT WHERE ID_TASK = {$sqlId} AND ID_PROJECT = 0
");
}
if ($type == "PROJECT") {
$rows = DB::getPDO()->fetchAll("
SELECT * FROM _SYNC_TASK_PERCENT WHERE ID_PROJECT = {$sqlId} AND ID_TASK = 0
");
}
Response::sendJsonExit($rows);
} catch (Exception $e) {
UI::alert('danger', "Error: " . $e->getMessage());
}
}
public function handleAuth() {
if (!User::logged()) {
User::authByRequest();
}
}
public function reinstallAction() {
try {
$dropTableSql = "DROP TABLE `_SYNC_TASK_PERCENT`";
DBG::nicePrint($dropTableSql, '$dropTableSql');
DB::getPDO()->query($dropTableSql);
} catch (Exception $e) {
// SQLSTATE[42000]: Syntax error or access violation: 1305 PROCEDURE SES_USERS2.PROBLEMS__SYNC_PERCENT does not exist
}
$createTableSql = file_get_contents(__FILE__ . '.create__SYNC_TASK_PERCENT.sql');
DBG::nicePrint($createTableSql, '$createTableSql');
DB::getPDO()->query($createTableSql);
try {
$dropProcedureSql = "DROP PROCEDURE `PROBLEMS__SYNC_PERCENT`";
DBG::nicePrint($dropProcedureSql, '$dropProcedureSql');
DB::getPDO()->query($dropProcedureSql);
} catch (Exception $e) {
// SQLSTATE[42000]: Syntax error or access violation: 1305 PROCEDURE SES_USERS2.PROBLEMS__SYNC_PERCENT does not exist
}
$createProcedureSql = file_get_contents(__FILE__ . '.problems_sync_percent.sql');
DBG::nicePrint($createProcedureSql, '$createProcedureSql');
DB::getPDO()->query($createProcedureSql);
}
public function defaultAction() {
UI::gora();
UI::menu();
try {
DB::getPDO()->query("CALL `PROBLEMS__SYNC_PERCENT`();");// TODO: BUG zamula
$id = 0;
$type = "";
if (!empty(V::get('ID_PROBLEM', 0, $_REQUEST, 'int'))) {
$id = V::get('ID_PROBLEM', 0, $_REQUEST, 'int');
$type = "PROBLEM";
}
if (!empty(V::get('ID_PROJECT', 0, $_REQUEST, 'int'))) {
$id = V::get('ID_PROJECT', 0, $_REQUEST, 'int');
$type = "PROJECT";
}
if ($id <= 0) throw new Exception("Wrong ID");
$this->showManager($id, $type);
} catch (Exception $e) {
UI::alert('danger', "Error: " . $e->getMessage());
}
UI::dol();
}
public function showManager($id, $type) {
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "