function create_table($tbl, $rows_, $first_col_name, $conn)
{
global $years, $sites;
$columns = getColNames($tbl, $conn);
echo "Create table --" . $columns . "\n";
$sql = "CREATE TABLE {$tbl} ({$columns})";
$create_result = mysqli_query($conn, $sql) or die("Cannot create table --" . mysqli_error($conn));
for ($i = 0; $i < count($rows_); $i++) {
echo "Year is :" . $rows_[$i] . "\n";
$sql_insert_rows = "Insert into {$tbl} ({$first_col_name}) VALUES('{$rows_[$i]}')";
$insert_result = mysqli_query($conn, $sql_insert_rows) or die("Cannot insert -- " . mysqli_error($conn));
}
}
function backup() {
// $sql = "show tables;";
// $tables = $this->db->query_flat($sql);
$tables = array('objects', 'customers', 'users');
// ajax_echo_r ($tables);
$timestamp = date("Y-m-d-H-i-s");
$dir = "data/backups";
mkdirr(getrootdirsrv().$dir);
$filename = getrootdirsrv().$dir."/izum-rel-".$timestamp.".xls";
$filename_client = getrootdir() .$dir."/izum-rel-".$timestamp.".xls";
$output = new PHPExcel; // Create new PHPExcel object
$output->getProperties()->setCreator("Izum by Creative Force")
->setLastModifiedBy("Izum by Creative Force")
->setTitle("Izum Backup File - ".date("Y-m-d H:i:s"))
->setSubject("Office 2007 XLS Test Document")
->setDescription("Test document for Office 2007 XLS, generated using PHP classes.")
->setKeywords("Creative Force Izum backup")
->setCategory("Test result file");
$i = 0;
$n = 1;
$si = 0;
$srcrow = array();
foreach ($tables as $tableName) {
// $tableName = 'accounts';
// ajax_echo_r ($tableName);
if (!in_array($tableName, array('visits', 'events'))) {
$sql = "SELECT * FROM `".$tableName."` ORDER BY `DateAdded`;";
$ret = $this->db->query_first($sql);
$col=0;
if ($si) {
// Add new sheet
$output->createSheet($si)->setTitle($tableName); //Setting index when creating
} else {
$output->setActiveSheetIndex($si)->setTitle($tableName);
}
$colnames = getColNames();
foreach (array_keys((array)$ret) as $itm) {
// for ($col=0; $col<$colCount; $col++) {
// echo $itm;
if ($colnames[$itm]) {
$itm = $colnames[$itm];
} else {
// echo $itm."-";
}
$output->setActiveSheetIndex($si)->setCellValueByColumnAndRow($col, 1, $itm);
// $srcrow[] = $xls->getCellByColumnAndRow($col,2)->getValue();
$col++;
}
// $colnames = getColNames();
$i=2;
$sql = "SELECT * FROM `".$tableName."`;";
$ret = $this->db->query($sql);
$subtables = array('districts' , 'customersubtypes' , 'methodsofpayment' , 'sources' , 'users' , 'directions' , 'housetypes' , 'markets' , 'mediators' , 'overlappingtypes' , 'layouttypes' , 'toilettypes' , 'conditions' , 'finishings' , 'floorsurfaces' , 'stovetypes' , 'doorstypes' , 'wallssurfaces' , 'wallsmaterials' , 'bathroomequipments' , 'windowstypes' , 'rightssources' , 'rightstransmissions' );
$subcolumns = array('DistrictID', 'CustomerSubtypeID', 'MethodOfPaymentID', 'SourceID', 'UserID', 'DirectionID', 'HouseTypeID', 'MarketID', 'MediatorID', 'OverlappingTypeID', 'LayoutTypeID', 'ToiletTypeID', 'ConditionID', 'FinishingID', 'FloorSurfaceID', 'StoveTypeID', 'DoorsTypeID', 'WallsSurfaceID', 'WallsMaterialID', 'BathroomEquipmentID', 'WindowsTypeID', 'RightsSourceID', 'RightsTransmissionID');
$ret = $this->fillSubtables($ret, $subtables, $subcolumns);
// ajax_echo_r ($ret);
// return false;
foreach ($ret as $itm) {
$col=0;
$thisrecord = $this->cache[(string)$id];
foreach ($itm as $c) {
$output->setActiveSheetIndex($si)->setCellValueByColumnAndRow($col, $i, $c);
$col++;
}
$i++;
}
}
$si++;
}
$output->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($output, 'Excel5');
$objWriter->save($filename);
return ($filename_client);
/*
$tableName = 'accounts';
$sql = "SELECT * FROM `".$tableName."`;";
$ret = $this->db->query_first($sql);
ajax_echo_r ($ret);
$buf = "INSERT INTO `` ";
foreach (array_keys((array)$ret as $itm) {
}
// file_put_contents ($backupFile, implode())."\n", FILE_APPEND);
$sql = "SELECT * FROM `".$tableName."`;";
$r = $this->db->query($sql);
ajax_echo_r ($r);
*/
}
require_once "Lib/lib_autoquery.php";
if ($_POST["submit"]) {
$views = stripslashes(base64_decode($views));
if (empty($condition3)) {
$views .= " AND `{$condition1}`{$condition}{$condition2}";
} else {
if ($condition2 != 'Funcion') {
$views .= " AND `{$condition1}`{$condition} '{$condition3}'";
} else {
$views .= " AND `{$condition1}`{$condition}{$condition3}";
}
}
} else {
$views .= " WHERE 1=1 ";
}
$cols = getColNames($views);
$rows = getColNamesFull($views);
echo '<div align="center">Condiciones</div>
<form action="" method="POST" enctype="multipart/form-data" >
<div align="center">
<select name="condition1" ><br>';
foreach ($cols as $k => $v) {
echo "<option value=\"" . $rows[$k] . "\">" . $cols[$k] . "</option>";
}
echo ' </select>
<select name="condition" ><br>
<option value="=">=</option>
<option value="<"><</option>
<option value=">">></option>
<option value="<>"><></option>
<option value="LIKE">LIKE</option>
