/**
* 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;
}
}
$oAdditionalTables->createPropelClasses($data['REP_TAB_NAME'], $repTabClassName, $fieldsList, $addTabUid);
$oAdditionalTables->populateReportTable($data['REP_TAB_NAME'], $data['REP_TAB_CONNECTION'], $data['REP_TAB_TYPE'], $fieldsList, $data['PRO_UID'], $data['REP_TAB_GRID']);
$result->success = true;
} catch (Exception $e) {
$result->success = false;
$result->msg = $e->getMessage();
$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);
/**
* 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;
}
