function main()
{
$hostname = "localhost";
$username = "******";
$password = "******";
$database = "solarPanel";
//print "function main() start\n";
$json = $_GET['json'];
$decoded = json_decode($_GET['json']);
$functionString = $decoded->fs;
//print "functionString=".$functionString."\n";
$con = mysql_connect($hostname, $username, $password) or die("Error " . mysqli_error($con));
mysql_select_db($database, $con);
if (strcmp($functionString, 'saveValues') == 0) {
//print "calling saveValues\n";
//print "calling saveValues".$bv3."\n";
saveValues($con, $database, $decoded);
}
if (strcmp($functionString, 'showTables') == 0) {
showTables($con, $database);
}
if (strcmp($functionString, 'loadValues') == 0) {
loadValues($con, $database, $decoded);
}
if (strcmp($functionString, 'SaveToExcel') == 0) {
SaveToExcel($con);
}
mysql_close($con);
}
}
switch ($action) {
case 'popula':
populaGrid();
// Exibe os dados no Grid
break;
case 'delete':
deleteValues();
// Elimina os dados
break;
case 'edit':
editValues();
// Chama para edicao os dados
break;
case 'save':
saveValues();
// Save data
break;
default:
}
function populaGrid()
{
include "functions/db-connection.php";
include "functions/cla-connection.php";
$conn = new cla_connection($hostname, $username, $password, $database);
$sql = "DELETE FROM podcast_temp;";
$rs = $conn->query($sql, false);
$sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (1) ORDER BY data DESC LIMIT 5 );";
$rs = $conn->query($sql, false);
$sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (2) ORDER BY data DESC LIMIT 5 );";
$rs = $conn->query($sql, false);
