コード例 #1
0
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;
            }
        }
    }
}
コード例 #2
0
 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;
 }