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']); } }