<?php /* This File is part of Camila PHP Framework Copyright (C) 2006-2009 Umberto Bresciani Camila PHP Framework is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. Camila PHP Framework is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Camila PHP Framework; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ require '../camila/header.php'; require CAMILA_DIR . 'datagrid/configurator.class.php'; $configurator = new configurator(); $configurator->configure_table($_REQUEST['camila_custom'], false, $_REQUEST['camila_returl']); require '../camila/footer.php';
function XLS_import2($file, $table, $db)
{
$filename = basename($file);
$sequence = intval(substr($filename, 0, strpos($filename, '_')));
$res = $db->Execute('select id from ' . CAMILA_TABLE_WORKT . ' where filename=' . $db->qstr($filename));
if ($res === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $db->ErrorMsg());
}
$id = $res->fields['id'];
$result = array();
$configurator = new configurator();
$configurator->filename = $file;
$configurator->sheetnum = 0;
$configurator->interactive = false;
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$configurator->db = $db;
$configurator->configure_table($id, false);
$record = array();
$res = $db->Execute('select * from ' . CAMILA_TABLE_WORKT . ' where id=' . $db->qstr($id));
if ($res === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $db->ErrorMsg());
}
$record['short_title'] = $res->fields['short_title'];
$record['full_title'] = $res->fields['full_title'];
$record['label_order'] = $sequence;
$scriptname = $res->fields['scriptname'];
$category = $res->fields['category'];
$updateSQL = $db->AutoExecute(CAMILA_TABLE_PLANG, $record, 'UPDATE', 'page_url=' . $db->qstr($scriptname) . ' and lang=' . $db->qstr($_REQUEST['lang']));
if (!$updateSQL) {
camila_information_text(camila_get_translation('camila.worktable.db.error'));
}
if (trim($category) != '') {
$res = $db->Execute('select page_url from ' . CAMILA_TABLE_PLANG . ' where short_title=' . $db->qstr($category) . ' AND page_url LIKE ' . $db->qstr('cf_app.php?cat%') . ' and lang=' . $db->qstr($_REQUEST['lang']));
if ($res === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $db->ErrorMsg());
}
$cat_url = '-';
if ($res->RecordCount() == 0) {
$res = $db->Execute('select page_url from ' . CAMILA_TABLE_PLANG . ' where full_title<>' . $db->qstr('-') . ' AND page_url LIKE ' . $db->qstr('cf_app.php?cat%') . ' and lang=' . $db->qstr($_REQUEST['lang']));
if ($res === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $db->ErrorMsg());
}
$cat_url = $res->fields['page_url'];
$record = array();
$record['label_order'] = $sequence;
$record['short_title'] = $category;
$record['full_title'] = '-';
$updateSQL = $db->AutoExecute(CAMILA_TABLE_PLANG, $record, 'UPDATE', 'page_url=' . $db->qstr($cat_url) . ' and lang=' . $db->qstr($_REQUEST['lang']));
if (!$updateSQL) {
camila_information_text(camila_get_translation('camila.worktable.db.error'));
}
} else {
$cat_url = $res->fields['page_url'];
}
$record = array();
$record['parent'] = $cat_url;
$updateSQL = $db->AutoExecute(CAMILA_TABLE_PAGES, $record, 'UPDATE', 'url=' . $db->qstr($scriptname));
if (!$updateSQL) {
camila_information_text(camila_get_translation('camila.worktable.db.error'));
}
$record = array();
$record['visible'] = 'yes';
$updateSQL = $db->AutoExecute(CAMILA_TABLE_PAGES, $record, 'UPDATE', 'url=' . $db->qstr($cat_url));
if (!$updateSQL) {
camila_information_text(camila_get_translation('camila.worktable.db.error'));
}
}
$result['result'] = 2;
//success
$result['processed'] = 1;
$result['failed'] = 0;
return $result;
}
