Example #1
0
 function _getFilter($tname = FALSE)
 {
     $result = "";
     if ($tname === FALSE) {
         $result .= " AND (idOwner = '" . (int) $this->idOwner . "') ";
     } else {
         $result .= " AND (" . $tname . ".idOwner = '" . (int) $this->idOwner . "') ";
     }
     return parent::_getFilter($tname) . $result;
 }
Example #2
0
 function _deleteTree($folder)
 {
     if (parent::_deleteTree($folder)) {
         $query = "SELECT idOrg, prerequisites FROM " . $this->table . " WHERE FIND_IN_SET( '" . $folder->id . "', prerequisites ) > 0";
         $rs = sql_query($query);
         if ($rs) {
             $num_rows = mysql_num_rows($rs);
         } else {
             $num_rows = 0;
         }
         if ($num_rows) {
             while (list($idOrg, $prerequisites) = sql_fetch_row($rs)) {
                 $arrPrequisites = explode(',', $prerequisites);
                 $key = array_search($folder->id, $arrPrequisites);
                 unset($arrPrequisites[$key]);
                 $prerequisites = implode(',', $arrPrequisites);
                 sql_query("UPDATE " . $this->table . "   SET prerequisites='" . $prerequisites . "' " . " WHERE idOrg='" . $idOrg . "'");
                 $this->deleteAllAccessUG($idOrg);
             }
         }
         return TRUE;
     } else {
         return FALSE;
     }
 }