function preformSearch()
{
$sql = $this->buildQuery();
$SweetDB_query = new SweetDB_query();
$SweetDB_query->setupTextArea($sql);
$queryArray = $SweetDB_query->runQuery($sql, 50);
$this->sugar_smarty->assign("ACTIONS", $queryArray['actions']);
$this->sugar_smarty->assign("QUERY_TIME", $queryArray['query_time']);
$SweetDB_query->drawTableData($sql, $queryArray);
$this->sugar_smarty->assign('EDIT_COMMAND', 'edit');
$this->sugar_smarty->assign('DELETE_COMMAND', 'delete');
$this->sugar_smarty->display("custom/modules/Administration/SweetDBAdmin/tpls/SweetDBQuery.tpl");
}
function describeTable()
{
global $sugar_config;
$tableSelect = $this->getRequestVar('tableselect');
if (empty($tableSelect)) {
return null;
}
$ucaseDBUser = strtoupper($sugar_config['dbconfig']['db_user_name']);
$ucaseTableName = strtoupper($tableSelect);
$db_type = array('ibm_db2' => "SELECT * FROM SYSCAT.COLUMNS WHERE TABSCHEMA = '{$ucaseDBUser}' AND TABNAME = '{$ucaseTableName}'", 'mysql' => "DESCRIBE {$tableSelect}", 'SQL Server' => "sp_columns_90 {$tableSelect}", 'oci8' => "SELECT * FROM user_tab_columns WHERE TABLE_NAME = '" . strtoupper($tableSelect) . "'");
$sql = $db_type[$sugar_config['dbconfig']['db_type']];
$SweetDB_query = new SweetDB_query();
$SweetDB_query->setupTextArea($sql);
$queryArray = $SweetDB_query->runQuery($sql, 5000);
//$this->sugar_smarty->assign("ACTIONS", $queryArray['actions']);
$SweetDB_query->drawTableData($sql, $queryArray);
$this->sugar_smarty->assign('EDIT_COMMAND', 'edit');
$this->sugar_smarty->assign('DELETE_COMMAND', 'delete');
$this->sugar_smarty->display("custom/modules/Administration/SweetDBAdmin/tpls/SweetDBQuery.tpl");
}
function display_indexes()
{
$indexes = $this->get_indicies($this->getTable());
$i = 0;
$rows = array();
foreach ($indexes as $name => $data) {
$fields = implode(', ', $data['fields']);
$rows[$i] = array('id' => $data['name'], 'type' => $data['type'], 'fields' => $fields);
$i++;
}
$queryArray['data'] = $rows;
$queryArray['actions'] = true;
$queryArray['header'] = array('Name', 'Type', 'Fields');
$queryArray['main'] = '';
$queryArray['extra_controls'] = "Select table to query:";
$tableNameOptions = $this->getFullTableOptions();
$queryArray['extra_controls'] .= "<select name=tableselect onchange=\"chooseNewTable('indexes');\">";
$queryArray['extra_controls'] .= $tableNameOptions;
$add_index_link = "index.php?module=Administration&action=SweetDBAdmin&skip=0&sql=&command=add_index¤tTable={$this->getTable()}";
$queryArray['extra_controls'] .= "</select> <input type=button name=add value='Add Index' onclick='document.location=\"{$add_index_link}\"'>";
$this->sugar_smarty->assign("ACTIONS", $queryArray['actions']);
$sql = "HIDE";
$SweetDB_query = new SweetDB_query();
$SweetDB_query->setupTextArea($sql);
$SweetDB_query->drawTableData($sql, $queryArray);
$this->sugar_smarty->assign('EDIT_COMMAND', 'edit_index');
$this->sugar_smarty->assign('DELETE_COMMAND', 'delete_index');
$this->sugar_smarty->display("custom/modules/Administration/SweetDBAdmin/tpls/SweetDBQuery.tpl");
}
/**
*
*/
function save_record()
{
$sql = $this->buildSave();
$SweetDB_query = new SweetDB_query();
$numOfRecords = $this->getRequestVar('numrecords', 50);
$queryArray = $SweetDB_query->runQuery($sql, -1);
$table = $this->getTable();
if (isset($_REQUEST['id_input'])) {
$id = $_REQUEST['id_input'];
$id_field = 'id';
}
if (isset($_REQUEST['id_c_input'])) {
$id = $_REQUEST['id_c_input'];
$id_field = 'id_c';
}
$newQuery = $this->getRequestVar('sql', '');
if (empty($newQuery)) {
$newQuery = "SELECT * FROM {$table} WHERE {$id_field}='{$id}'";
}
$queryArray2 = $SweetDB_query->runQuery($newQuery, $numOfRecords);
$queryArray2['affectedRows'] = $queryArray['affectedRows'];
$SweetDB_query->setupTextArea($sql);
$this->sugar_smarty->assign("ACTIONS", $queryArray2['actions']);
$this->sugar_smarty->assign("QUERY_TIME", $queryArray2['query_time']);
$SweetDB_query->drawTableData($sql, $queryArray2);
$this->sugar_smarty->assign('EDIT_COMMAND', 'edit');
$this->sugar_smarty->assign('DELETE_COMMAND', 'delete');
$this->sugar_smarty->display("custom/modules/Administration/SweetDBAdmin/tpls/SweetDBQuery.tpl");
}
