/** * delete pm table * * @param string $httpData->rows */ public function delete($httpData) { $rows = G::json_decode(stripslashes($httpData->rows)); $errors = ''; $count = 0; foreach ($rows as $row) { try { $at = new AdditionalTables(); $table = $at->load($row->id); if (!isset($table)) { require_once 'classes/model/ReportTable.php'; $rtOld = new ReportTable(); $existReportTableOld = $rtOld->load($row->id); if (count($existReportTableOld) == 0) { throw new Exception(G::LoadTranslation('ID_TABLE_NOT_EXIST_SKIPPED')); } } if ($row->type == 'CLASSIC') { G::LoadClass('reportTables'); $rp = new reportTables(); $rp->deleteReportTable($row->id); $count++; } else { $at->deleteAll($row->id); $count++; } } catch (Exception $e) { $tableName = isset($table['ADD_TAB_NAME']) ? $table['ADD_TAB_NAME'] : $row->id; $errors .= $e->getMessage() . "\n"; continue; } } if ($errors == '') { $result->success = true; $result->message = $count . G::LoadTranslation('ID_TABLES_REMOVED_SUCCESSFULLY'); } else { $result->success = false; $result->message = $count . G::LoadTranslation('ID_TABLES_REMOVED_WITH_ERRORS') . $errors; } $result->errors = $errors; return $result; }
$result->trace = $e->getTraceAsString(); } echo G::json_encode($result); break; case 'delete': require_once 'classes/model/AdditionalTables.php'; G::LoadClass('reportTables'); $rows = G::json_decode($_REQUEST['rows']); $rp = new reportTables(); $at = new AdditionalTables(); try { foreach ($rows as $row) { if ($row->type == 'CLASSIC') { $rp->deleteReportTable($row->id); } else { $at->deleteAll($row->id); } } $result->success = true; } catch (Exception $e) { $result->success = false; $result->msg = $e->getMessage(); } echo G::json_encode($result); break; case 'list': require_once 'classes/model/AdditionalTables.php'; G::LoadClass('configuration'); G::LoadClass('processMap'); $configigurations = new Configurations(); $oProcessMap = new processMap();
/** * delete pm table * * @param string $httpData->rows */ public function delete ($httpData) { $result = new stdClass(); $rows = G::json_decode( stripslashes( $httpData->rows ) ); $errors = ''; $count = 0; $result = new StdClass(); $tableCasesList = array(); $conf = new Configurations(); $confCasesListDraft = $conf->getConfiguration( 'casesList', 'draft'); $confCasesListPaused = $conf->getConfiguration( 'casesList', 'paused'); $confCasesListSent = $conf->getConfiguration( 'casesList', 'sent'); $confCasesListTodo = $conf->getConfiguration( 'casesList', 'todo'); $confCasesListUnassigned = $conf->getConfiguration( 'casesList', 'unassigned'); $tableCasesList['draft'] = ($confCasesListDraft != null) ? (isset($confCasesListDraft['PMTable']) ? $confCasesListDraft['PMTable'] : '') : ''; $tableCasesList['paused'] = ($confCasesListPaused != null) ? (isset($confCasesListPaused['PMTable']) ? $confCasesListPaused['PMTable'] : '') : ''; $tableCasesList['sent'] = ($confCasesListSent != null) ? (isset($confCasesListSent['PMTable']) ? $confCasesListSent['PMTable'] : '') : ''; $tableCasesList['todo'] = ($confCasesListTodo != null) ? (isset($confCasesListTodo['PMTable']) ? $confCasesListTodo['PMTable'] : '') : ''; $tableCasesList['unassigned'] = ($confCasesListUnassigned != null) ? (isset($confCasesListUnassigned['PMTable']) ? $confCasesListUnassigned['PMTable'] : '') : ''; foreach ($rows as $row) { try { $at = new AdditionalTables(); $table = $at->load( $row->id ); if (! isset( $table )) { require_once 'classes/model/ReportTable.php'; $rtOld = new ReportTable(); $existReportTableOld = $rtOld->load( $row->id ); if (count($existReportTableOld) == 0) { throw new Exception( G::LoadTranslation('ID_TABLE_NOT_EXIST_SKIPPED') ); } } foreach ($tableCasesList as $action => $idTable) { if ($idTable == $row->id) { $conf = new Configurations(); $resultJson = $conf->casesListDefaultFieldsAndConfig($action); $conf->saveObject($resultJson, "casesList", $action, "", "", ""); } } if ($row->type == 'CLASSIC') { G::LoadClass( 'reportTables' ); $rp = new reportTables(); $rp->deleteReportTable( $row->id ); $count ++; } else { $at->deleteAll( $row->id ); $count ++; } } catch (Exception $e) { $tableName = isset( $table['ADD_TAB_NAME'] ) ? $table['ADD_TAB_NAME'] : $row->id; $errors .= $e->getMessage() . "\n"; continue; } } if ($errors == '') { $result->success = true; $result->message = $count.G::LoadTranslation( 'ID_TABLES_REMOVED_SUCCESSFULLY' ); G::auditLog("DeletePmtable", "Table Name: ". $table['ADD_TAB_NAME']." Table ID: (".$table['ADD_TAB_UID'].") "); } else { $result->success = false; $result->message = $count. G::LoadTranslation( 'ID_TABLES_REMOVED_WITH_ERRORS' ) .$errors; } $result->errors = $errors; return $result; }
/** * delete pm table * * @param string $httpData->rows */ public function delete($httpData) { $rows = G::json_decode(stripslashes($httpData->rows)); $errors = ''; $count = 0; foreach ($rows as $row) { try { $at = new AdditionalTables(); $table = $at->load($row->id); if (!isset($table)) { throw new Exception("Table does not exist... skipped!\n"); } if ($row->type == 'CLASSIC') { G::LoadClass('reportTables'); $rp = new reportTables(); $rp->deleteReportTable($row->id); $count++; } else { $at->deleteAll($row->id); $count++; } } catch (Exception $e) { $tableName = isset($table['ADD_TAB_NAME']) ? $table['ADD_TAB_NAME'] : $row->id; $errors .= $e->getMessage() . "\n"; continue; } } if ($errors == '') { $result->success = true; $result->message = "{$count} tables removed Successfully."; } else { $result->success = false; $result->message = "{$count} tables removed but with errors.\n{$errors}"; } $result->errors = $errors; return $result; }