if (!$del_db->connect($db_server, $db_user, $db_pw, $db_name)) {
$error = $messageStack->add(SETUP_CO_MGR_CANNOT_CONNECT, 'error');
}
if (!$error) {
$tables = array();
$table_list = $del_db->Execute("show tables");
while (!$table_list->EOF) {
$tables[] = array_shift($table_list->fields);
$table_list->MoveNext();
}
if (is_array($tables)) {
foreach ($tables as $table) {
$del_db->Execute("drop table " . $table);
}
}
$backup->delete_dir(DIR_FS_MY_FILES . $db_name);
unset($_SESSION['companies'][$_POST['del_company']]);
gen_add_audit_log(SETUP_CO_MGR_LOG . TEXT_DELETE, $db_name);
$messageStack->add(SETUP_CO_MGR_DELETE_SUCCESS, 'success');
}
}
$default_tab_id = 'manager';
break;
case 'ordr_nums':
validate_security($security_level, 3);
// read in the requested status values
$sequence_array = array();
foreach ($status_fields as $status_field) {
if (db_prepare_input($_POST[$status_field]) != $status_values->fields[$status_field]) {
$sequence_array[$status_field] = db_prepare_input($_POST[$status_field]);
$status_values->fields[$status_field] = $sequence_array[$status_field];
}
if (!$error) {
gen_add_audit_log(GEN_DB_DATA_BACKUP, TABLE_AUDIT_LOG);
$backup->download($backup->dest_dir, $backup->dest_file);
// will not return if successful
}
$default_tab_id = 'tools';
break;
case 'clean':
$carrier = db_prepare_input($_POST['carrier']);
$fy_month = db_prepare_input($_POST['fy_month']);
$fy_year = db_prepare_input($_POST['fy_year']);
$conv_type = db_prepare_input($_POST['conv_type']);
$backup = new backup();
$backup->source_dir = DIR_FS_MY_FILES . $_SESSION['company'] . '/shipping/labels/' . $carrier . '/' . $fy_year . '/' . $fy_month . '/';
if ($backup->delete_dir($backup->source_dir, $recursive = true)) {
$error = true;
}
if (!$error) {
gen_add_audit_log(GEN_FILE_DATA_CLEAN);
}
$default_tab_id = 'tools';
break;
default:
}
/***************** prepare to display templates *************************/
// build some general pull down arrays
$sel_yes_no = array(array('id' => '0', 'text' => TEXT_NO), array('id' => '1', 'text' => TEXT_YES));
$sel_checked = array(array('id' => '0', 'text' => TEXT_UNCHECKED), array('id' => '1', 'text' => TEXT_CHECKED));
$sel_show = array(array('id' => '0', 'text' => TEXT_HIDE), array('id' => '1', 'text' => TEXT_SHOW));
$sel_fy_month = array(array('id' => '01', 'text' => TEXT_JAN), array('id' => '02', 'text' => TEXT_FEB), array('id' => '03', 'text' => TEXT_MAR), array('id' => '04', 'text' => TEXT_APR), array('id' => '05', 'text' => TEXT_MAY), array('id' => '06', 'text' => TEXT_JUN), array('id' => '07', 'text' => TEXT_JUL), array('id' => '08', 'text' => TEXT_AUG), array('id' => '09', 'text' => TEXT_SEP), array('id' => '10', 'text' => TEXT_OCT), array('id' => '11', 'text' => TEXT_NOV), array('id' => '12', 'text' => TEXT_DEC));
case 'export':
$dir = DIR_FS_MY_FILES . 'translator/';
$pieces = explode(':', $_POST['rowSeq']);
$mod = $pieces[0];
$lang = $pieces[1];
$ver = $pieces[2];
$backup->source_dir = $dir . 'export/';
$backup->dest_dir = $dir;
$backup->dest_file = $mod . '_' . $lang . '_R' . str_replace('.', '', $ver) . '.zip';
if (!($result = $translator->export_language($mod, $lang, $ver))) {
$error = true;
}
if ($backup->make_zip('dir')) {
$error = true;
}
if ($backup->delete_dir($backup->source_dir)) {
$error = true;
}
if (!$error) {
gen_add_audit_log(TEXT_EDIT_TRANSLATION . ' (' . TEXT_EXPORT . ')', $mod . ' ' . lang . ' R' . $ver);
$backup->download($backup->dest_dir, $backup->dest_file);
// will not return if successful
}
break;
case 'export_all_go':
$dir = DIR_FS_MY_FILES . 'translator/';
$lang = db_prepare_input($_POST['lang']);
$backup->source_dir = $dir . 'export/';
$backup->dest_dir = $dir;
$backup->dest_file = 'language_' . $lang . '_Rxx.zip';
$sel_modules = build_mod_list();
