function getWfsConfData($wfsID) { global $con; // re-check permission $adm = new administration(); $serviceList = $adm->getWfsByOwner(Mapbender::session()->get("mb_user_id")); if (in_array($wfsID, $serviceList)) { $wfsConf = array(); $wfsConf['id'] = array(); $wfsConf['abstract'] = array(); $sql = "SELECT * FROM wfs_conf WHERE fkey_wfs_id = \$1 ORDER BY wfs_conf_abstract"; $v = array($wfsID); $t = array('i'); $res = db_prep_query($sql, $v, $t); $cnt = 0; while ($row = db_fetch_array($res)) { array_push($wfsConf['id'], $row['wfs_conf_id']); array_push($wfsConf['abstract'], $row['wfs_conf_abstract']); $cnt++; } if ($cnt == 0) { return false; } else { return $wfsConf; } } else { if ($wfsID === "gui_confs") { $wfsConf = array(); $wfsConf['id'] = array(); $wfsConf['abstract'] = array(); $wfsConf['id'] = $adm->getWfsConfByPermission(Mapbender::session()->get("mb_user_id")); $cnt = 0; foreach ($wfsConf['id'] as $wfscid) { $sql = "SELECT wfs_conf_abstract FROM wfs_conf WHERE wfs_conf_id = \$1"; $v = array($wfscid); $t = array('i'); $res = db_prep_query($sql, $v, $t); while ($row = db_fetch_array($res)) { array_push($wfsConf['abstract'], $row['wfs_conf_abstract']); } $cnt++; } if ($cnt == 0) { return false; } else { return $wfsConf; } } } }
private function getPermissionValueForWFS($wfs_id, $wfs_conf_id) { //TODO: Set Email of owner into view for ressource - so it don't have to be searched? $return_permission = ""; //get permission $admin = new administration(); $myWFSconfs = $admin->getWfsConfByPermission($this->userId); $this->myWFSConfs = $myWFSconfs; for ($index = 0; $index < sizeof($this->myWFSConfs); $index++) { $array_element = $this->myWFSConfs[$index]; } if (in_array($wfs_conf_id, $this->myWFSConfs)) { $return_permission = "true"; } else { $sql = "SELECT wfs.wfs_id, mb_user.mb_user_email as email FROM wfs, mb_user where wfs.wfs_owner=mb_user.mb_user_id " . "and wfs.wfs_id=\$1"; $v = array($wfs_id); $t = array('i'); $res = db_prep_query($sql, $v, $t); // get email $mail = ""; while ($row = db_fetch_array($res)) { $mail = $row['email']; $return_permission = $mail; } } return $return_permission; }