function xml($filename = 'Archivo.xml', $table = 'scaj')
{
$this->load->library("xml2sql");
$xml = new xml2sql($filename);
$db = $xml->analizador();
foreach ($db as $key => $val) {
//echo "<pre>";
//print_r($val);
//echo "</pre>";
$this->db->insert($table, $val);
echo 'insertado';
}
}
function insertar($filename = 'Archivo1.xml', $table = 'gser')
{
$this->load->library("xml2sql");
$xml = new xml2sql($filename);
$db = $xml->analizador();
//echo $filename;
foreach ($db as $key => $val) {
echo "<pre>";
print_r($val);
echo "</pre>";
$this->db->insert($table, $val);
echo $key;
}
}
function handle_event($ev)
{
global $sql;
$this->long_name = $ev->parent_name;
//$id,$current
//$sql,$db,$tbl,$atbl
if ($ev->rem_name == 'bt') {
$sql->logquerys = false;
$ld = new xml2sql();
$ld->sql =& $sql;
$ld->tbl = 'xml_editor_nodes';
$ld->atbl = 'xml_editor_attributes';
$ld->id = 0;
$sql->query('DELETE FROM xml_editor_nodes');
$sql->query('DELETE FROM xml_editor_attributes');
$ld->notrans = true;
if ($ld->notrans) {
$sql->query('ALTER TABLE ' . $ld->tbl . ' DISABLE KEYS');
}
if ($ld->notrans) {
$sql->query('ALTER TABLE ' . $ld->atbl . ' DISABLE KEYS');
}
if ($ld->notrans) {
$sql->query('START TRANSACTION');
}
ini_set('max_execution_time', 60 * 10);
$handle = fopen("../xml/LT.fods", "r");
// $handle = fopen("../xml/o.zml", "r");
// $handle = fopen("../xml/greport3.smc", "r");
// $handle = fopen("../xml/greport3.xml", "r");
// $handle = fopen("../xml/xls.xml", "r");
// $handle = fopen("../xml/ДОХОД_2НДФЛ_6025_6025026876602501001_20090226_CBED40B3-78D3-4B2A-BD21-AEC68E1837DF.xml", "r");
//print "<pre>".htmlspecialchars($v)."</pre>";
if ($handle) {
while (!feof($handle)) {
//$v=fread($handle,1);
//if(ord($v)<ord(' '))$v=' ';
//read 16K
$v = fread($handle, 16384);
//replace invalid chars with whitespace
$v = preg_replace('/[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]/', ' ', $v);
if (feof($handle)) {
$ld->feed($v, true);
} else {
$ld->feed($v, false);
}
}
}
fclose($handle);
if ($ld->notrans) {
$sql->query('COMMIT');
}
if ($ld->notrans) {
$sql->query('ALTER TABLE ' . $ld->tbl . ' ENABLE KEYS');
}
if ($ld->notrans) {
$sql->query('ALTER TABLE ' . $ld->atbl . ' ENABLE KEYS');
}
print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='read-Ok';";
if ($sql->logquerys) {
print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='";
foreach ($sql->querylog as $e) {
$a = "<div><div>" . htmlspecialchars($e->q) . "</div><div>" . htmlspecialchars($e->e) . "</div></div>\n";
print js_escape($a);
}
print "';";
}
}
if ($ev->rem_name == 'wo') {
$sql->logquerys = false;
$ld = new xml2sql();
$ld->sql =& $sql;
$ld->tbl = 'xml_editor_nodes';
$ld->atbl = 'xml_editor_attributes';
$ld->id = 0;
$this->handle = fopen("../xml/xmlsql-out.xml", "w");
ini_set('max_execution_time', 60 * 5);
// $handle = fopen("../xml/greport3.xml", "r");
// $handle = fopen("../xml/xls.xml", "r");
// $handle = fopen("../xml/ДОХОД_2НДФЛ_6025_6025026876602501001_20090226_CBED40B3-78D3-4B2A-BD21-AEC68E1837DF.xml", "r");
//print "<pre>".htmlspecialchars($v)."</pre>";
$ld->wo(0, -1, 'testw', $this);
$this->flushw();
fclose($this->handle);
print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='Write-ok';";
if ($sql->logquerys) {
print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='";
foreach ($sql->querylog as $e) {
$a = "<div><div>" . htmlspecialchars($e->q) . "</div><div>" . htmlspecialchars($e->e) . "</div></div>\n";
print js_escape($a);
}
print "';";
}
}
editor_generic::handle_event($ev);
}
