function set_lookuptable_xml()
{
$lookuptable = new LookupTable($_REQUEST["table_name"]);
$table_hash = $lookuptable->get_table();
$doc = new DOMDocument('1.0', 'UTF-8');
$doc->formatOutput = true;
$lookup_item_group = $doc->createElement('lookup_item_group');
$lookup_item_group = $doc->appendChild($lookup_item_group);
$lookup_item_group->setAttribute('lookup_table_name', $_REQUEST["table_name"]);
foreach ($table_hash as $cat_id => $catval_ar) {
$lookup_item = $doc->createElement('lookup_item');
$lookup_item = $lookup_item_group->appendChild($lookup_item);
$lookup_item->setAttribute('prim_key_col', $cat_id);
$lookup_item->setAttribute('lookup_value_col', $catval_ar[0]);
$lookup_item->setAttribute('is_disabled', $catval_ar["disabled"]);
}
$this->lookuptable_xml = $doc->saveXML();
}
function get_list()
{
$lookup_table = new LookupTable("category");
return $lookup_table->get_table();
}
function get_table_DS($table_name)
{
$lookup_table = new LookupTable($table_name);
return $lookup_table->get_table();
}
function add_category_list()
{//return;
//$category_hash = OutputSys_EntityManagementSystems::get_category_list();
$lookuptable = new LookupTable("category");
$category_hash = $lookuptable->get_table();
$category_type_matrix = OutputSys_EntityManagementSystems::get_category_type_mapping();
/*
$doc = new DOMDocument('1.0','UTF-8');
$doc->formatOutput = true;
$root = $doc->createElement('myedbroot');
$root = $doc->appendChild($root);
*/
$cats = $this->doc->createElement('categories');
$this->doc_root->appendChild($cats);
foreach ($category_hash as $cat_id => $cat_name_ar)
{
$cat_name = $cat_name_ar[0];
$cat = $this->doc->createElement('category');
$cats->appendChild($cat);
$cat->setAttribute("cat_id",$cat_id);
$cat->setAttribute("is_disabled",$cat_name_ar['disabled']);
//add elements showing which types are associated with this category
$types = $this->doc->createElement('cattypes');
$cat->appendChild($types);
if (is_array($category_type_matrix[$cat_id]))//if not set, means no records associated with category
{
foreach($category_type_matrix[$cat_id] as $type_id)
{
$type = $this->doc->createElement('cattype');
$types->appendChild($type);
$type_id_txt = $this->doc->createTextNode($type_id);
$type->appendChild($type_id_txt);
}
}
//add category text node
$catval = $this->doc->createElement('catval');
$cat->appendChild($catval);
$catnm_node = $this->doc->createTextNode($cat_name);
$catval->appendChild($catnm_node);
}
// $rec->glu->prop_ids_num_extra[6] = 1;
// $rec->glu->set_prop_ids_num_extra_by_group_id(1);
//$rec->glu->set_prop_ids_num_extra_by_group_id(1);
// $xslt_file = $_SERVER['DOCUMENT_ROOT']."/XSLTemplates/testrecs.xsl";
//$xml_string = $doc->saveXML();
}
