function SelectPlanItems() { $PlanID = $_REQUEST["PlanID"]; $ElementID = $_REQUEST["ElementID"]; $dt = PLN_PlanItems::SelectAll("PlanID=? AND ElementID=?", array($PlanID, $ElementID)); for ($i = 0; $i < count($dt); $i++) { $p = xml_parser_create(); xml_parse_into_struct($p, $dt[$i]["ElementValue"], $vals); xml_parser_free($p); foreach ($vals as $element) { if (strpos($element["tag"], "ELEMENT_") !== false) { $dt[$i][strtolower($element["tag"])] = empty($element["value"]) ? "" : $element["value"]; } } unset($dt[$i]["ElementValue"]); } echo dataReader::getJsonData($dt, count($dt), $_GET["callback"]); die; }
function SelectElements() { $PlanID = $_REQUEST["PlanID"]; $GroupID = $_REQUEST["GroupID"]; $dt = PdoDataAccess::runquery("select e.* from PLN_Elements e\r\n\t\twhere IsActive='YES' AND GroupID=? order by ElementID", array($GroupID)); $planValues = array(); for ($i = 0; $i < count($dt); $i++) { if ($dt[$i]["ElementType"] == "grid") { continue; } if ($dt[$i]["ElementType"] == "panel") { $temp = PLN_PlanItems::SelectAll("PlanID=? AND ElementID=?", array($PlanID, $dt[$i]["ElementID"])); if (count($temp) == 0) { continue; } $p = xml_parser_create(); xml_parse_into_struct($p, $temp[0]["ElementValue"], $vals); xml_parser_free($p); $planValues[$dt[$i]["ElementID"]] = $vals; } else { if (!isset($planValues[$dt[$i]["ParentID"]])) { $dt[$i]["ElementValue"] = ""; break; } $vals = $planValues[$dt[$i]["ParentID"]]; foreach ($vals as $element) { if ($element["tag"] == "ELEMENT_" . $dt[$i]["ElementID"]) { $dt[$i]["ElementValue"] = empty($element["value"]) ? "" : $element["value"]; break; } } } } echo dataReader::getJsonData($dt, count($dt), $_GET["callback"]); die; }