function set_lookuptable_xml($paged = false)
{
$myedbsess = new MyEDB_SESSION();
$lookuptable = new SubLookupTable($_REQUEST["table_name"]);
$table_hash = $lookuptable->get_table($paged);
//true=paged
//debug_print_backtrace();
//echo "<BR>i'M IN HERE SET LOOKUP TABLE XML!!!! paged:".$paged;
if ($paged) {
//$_SESSION['search_res_row_cnt'] = $lookuptable->get_total_results();
$myedbsess->search_res_row_cnt = $lookuptable->get_total_results();
}
$doc = new DOMDocument('1.0', 'UTF-8');
$doc->formatOutput = true;
// $docroot = $doc->createElement('myedbroot');
// $docroot = $doc->appendChild($docroot);
$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 $lkup_id => $val_ext_ar) {
$lookup_item = $doc->createElement('lookup_item');
$lookup_item = $lookup_item_group->appendChild($lookup_item);
$lookup_item->setAttribute('prim_key_col', $lkup_id);
$lookup_item->setAttribute('lookup_value_col', $val_ext_ar[0]);
$lookup_item->setAttribute('lookup_value_parent_lookup_tbl_id', $val_ext_ar[1]);
$lookup_item->setAttribute('is_disabled', $val_ext_ar["disabled"]);
}
$this->lookuptable_xml = $doc->saveXML();
}
function initialize_sub_lookup_table_jsonOld(&$xml_string)
{
$lookuptable = new SubLookupTable($_REQUEST["table_name"]);
$table_hash = $lookuptable->get_table($paged);
//true=paged
//eliminate subcategories that don't have records assigned
foreach (array_keys($table_hash) as $array_key) {
if (ClientServerDataOps_EntityManagementSystems::get_count_of_val_by_prop(50, 0, $array_key, "Int") == 0) {
unset($table_hash[$array_key]);
}
}
$xml_string = json_encode($table_hash);
}
function add_subcategory_list()
{//return;
$lookuptable = new SubLookupTable("subcategory");
$subcategory_hash = $lookuptable->get_table();
$subcategories = $this->doc->createElement('subcategories');
$this->doc_root->appendChild($subcategories);
foreach($subcategory_hash as $lkup_id => $val_ext_ar)
{
$subcategory = $this->doc->createElement('subcategory');
$subcategory = $subcategories->appendChild($subcategory);
$subcategory->setAttribute('subcat_id',$lkup_id);
$subcategory->setAttribute('subcat_name',$val_ext_ar[0]);
$subcategory->setAttribute('cat_id',$val_ext_ar['lookup_table_id']);
$subcategory->setAttribute('is_disabled',$val_ext_ar['disabled']);
}
}
