/** * Get Dropdown Label * * @author Brayan Pereyra (Cochalo) <*****@*****.**> * @copyright Colosa - Bolivia */ public function getDropdownLabel($appUid, $pro_uid, $dyn_uid, $fieldName, $fieldVal) { $oCase = new Cases(); $filename = $pro_uid . PATH_SEP . $dyn_uid . ".xml"; $G_FORM = new xmlform(); $G_FORM->home = PATH_DYNAFORM; $G_FORM->parseFile($filename, SYS_LANG, true); $aFields = $oCase->loadCase($appUid); $arrayTmp = array(); $array = array(); $sqlQuery = null; foreach ($G_FORM->fields as $key => $val) { if ($fieldName == $val->name) { if ($G_FORM->fields[$key]->sql != "") { $sqlQuery = G::replaceDataField($G_FORM->fields[$key]->sql, $aFields ["APP_DATA"]); } if ((is_array($val->options)) && (!empty($val->options))) { foreach ($val->options as $key1 => $val1) { $array[] = array("id" => $key1, "value" => $val1); } } if ($val->type == "yesno") { $array[] = array("id" => 1, "value" => strtoupper(G::LoadTranslation("ID_YES"))); $array[] = array("id" => 0, "value" => strtoupper(G::LoadTranslation("ID_NO"))); } } } if ($sqlQuery != null) { $aResult = executeQuery($sqlQuery); if ($aResult == false) { $aResult = array(); } } else { $aResult = array(); } foreach ($aResult as $field) { $i = 0; foreach ($field as $key => $value) { if ($i == 0) { $arrayTmp["id"] = $value; if (count($field) == 1) { $arrayTmp["value"] = $value; } } if ($i == 1) { $arrayTmp["value"] = $value; } $i++; } $array[] = $arrayTmp; } foreach ($array as $newKey => $newValue) { if ($newValue["id"] == $fieldVal) { return $newValue["value"]; } } return null; }
public function getDynaformFields($dynaformUid) { $content = ''; $fields = $this->Load($dynaformUid); $filename = PATH_DYNAFORM . $fields['PRO_UID'] . PATH_SEP . $fields['DYN_UID'] . '.xml'; if (file_exists($filename)) { $content = file_get_contents($filename); } $G_FORM = new xmlform($fields['DYN_FILENAME'], PATH_DYNAFORM); $G_FORM->parseFile($filename, SYS_LANG, true); return $G_FORM->fields; }
<?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ $appUid = isset($_POST["appUid"]) ? $_POST["appUid"] : ""; $dynUid = isset($_POST["dynUid"]) ? $_POST["dynUid"] : ""; $proUid = isset($_POST["proUid"]) ? $_POST["proUid"] : ""; $fieldName = isset($_POST["fieldName"]) ? $_POST["fieldName"] : ""; $filename = $proUid . PATH_SEP . $dynUid . ".xml"; $G_FORM = new xmlform(); $G_FORM->home = PATH_DYNAFORM; $G_FORM->parseFile($filename, SYS_LANG, true); G::LoadClass("case"); G::LoadClass("pmFunctions"); //Load the variables $oCase = new Cases(); $sqlQuery = null; $array = array(); $aFields = $oCase->loadCase($appUid); foreach ($G_FORM->fields as $key => $val) { if ($fieldName == $val->name) { if ($G_FORM->fields[$key]->sql != null) { $sqlQuery = G::replaceDataField($G_FORM->fields[$key]->sql, $aFields["APP_DATA"]); } //$coma = ""; //$data1 = ""; if (is_array($val->options)) { foreach ($val->options as $key1 => $val1) { $array[] = array("value" => $key1, "text" => $val1);