Changeset 4362 for contrib/Dms/inc/inc.ClassFolder.php
- Timestamp:
- 05/12/11 11:52:50 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
contrib/Dms/inc/inc.ClassFolder.php
r3526 r4362 4 4 if (!is_numeric($id)) 5 5 die ("invalid folderid"); 6 7 $queryStr = "SELECT * FROM phpgw_mydms_Folders WHERE id = " . $id; 6 $queryStr = "SELECT id,name,parent,comment,owner,inheritaccess,defaultaccess,sequence FROM phpgw_mydms_folders WHERE id = " . $id; 7 8 //echo "<br>folderrrrr".$queryStr."<br>"; 8 9 $resArr = $GLOBALS['mydms']->db->getResultArray($queryStr); 9 10 … … 15 16 $resArr = $resArr[0]; 16 17 if($id == 1) { 17 $resArr[ "defaultAccess"] = M_READ;18 } 19 $newFolder = new Folder($resArr["id"], $resArr["name"], $resArr["parent"], $resArr["comment"], $resArr["owner"], $resArr["inheritAccess"], $resArr["defaultAccess"], $resArr["sequence"]);18 $resArr[6] = M_READ; 19 } 20 // echo $resArr["id"]." ".$resArr[6]." ".$resArr["parent"]." ".$id." ".$GLOBALS['phpgw_info']['user']['account_id']." dddd ".$resArr[5]." dddd ".$resArr["defaultAccess"]; 20 21 22 $newFolder = new Folder($resArr["id"], $resArr["name"], $resArr["parent"], $resArr["comment"], $resArr["owner"], $resArr["inheritaccess"], $resArr["defaultaccess"], $resArr["sequence"]); 23 //echo "llll".$GLOBALS['phpgw_info']['user']['account_id']." ".$resArr["inheritaccess"]; 21 24 #print $resArr["name"]."<br>"; 22 25 #print $newFolder->getAccessMode(getUser($GLOBALS['phpgw_info']['user']['account_id']))."<br>"; 23 if($newFolder->getAccessMode(getUser($GLOBALS['phpgw_info']['user']['account_id'])) > 1) 24 return $newFolder; 25 else 26 if($newFolder->getAccessMode(getUser($GLOBALS['phpgw_info']['user']['account_id'])) > 1){ 27 //echo "retornoooo"; 28 return $newFolder; 29 } 30 else{ 26 31 return false; 32 } 27 33 } 28 34 … … 45 51 function Folder($id, $name, $parentID, $comment, $ownerID, $inheritAccess, $defaultAccess, $sequence) 46 52 { 53 //echo "aaaaaccccseexxx".$inheritAccess; 54 if($inheritAccess=='f'){ 55 unset($inheritAccess); 56 } 47 57 $this->_id = $id; 48 58 $this->_name = $name; … … 53 63 $this->_defaultAccess = $defaultAccess; 54 64 $this->_sequence = $sequence; 55 56 65 $this->db = clone($GLOBALS['phpgw']->db); 57 66 $this->db->set_app('mydms'); 67 // echo"accc".$defaultAccess."lll{ñ{{ñ".$inheritAccess; 58 68 } 59 69 … … 67 77 $where = array('id' => $this->_id); 68 78 69 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))79 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 70 80 return false; 71 81 … … 82 92 $where = array('id' => $this->_id); 83 93 84 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))94 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 85 95 return false; 86 96 … … 105 115 $where = array('id' => $this->_id); 106 116 107 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))117 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 108 118 return false; 109 119 … … 126 136 $where = array('id' => $this->_id); 127 137 128 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))138 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 129 139 return false; 130 140 … … 151 161 $where = array('id' => $this->_id); 152 162 153 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))163 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 154 164 return false; 155 165 … … 167 177 $where = array('id' => $this->_id); 168 178 169 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))179 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 170 180 return false; 171 181 … … 181 191 $where = array('id' => $this->_id); 182 192 183 if(!$this->db->update('phpgw_mydms_ Folders', $data, $where, __LINE__, __FILE__))193 if(!$this->db->update('phpgw_mydms_folders', $data, $where, __LINE__, __FILE__)) 184 194 return false; 185 195 … … 192 202 if (!isset($this->_subFolders)) 193 203 { 194 $queryStr = "SELECT * FROM phpgw_mydms_ Folders WHERE parent = " . $this->_id . " ORDER BY sequence";204 $queryStr = "SELECT * FROM phpgw_mydms_folders WHERE parent = " . $this->_id . " ORDER BY sequence"; 195 205 196 206 … … 226 236 'sequence' => $sequence, 227 237 ); 228 $res = $this->db->insert('phpgw_mydms_ Folders', $insertData, '', __LINE__, __FILE__, 'mydms');238 $res = $this->db->insert('phpgw_mydms_folders', $insertData, '', __LINE__, __FILE__, 'mydms'); 229 239 230 240 if (!$res) … … 233 243 unset($this->_subFolders); 234 244 235 return getFolder($this->db->get_last_insert_id('phpgw_mydms_ Folders','id'));245 return getFolder($this->db->get_last_insert_id('phpgw_mydms_folders','id')); 236 246 } 237 247 … … 307 317 function getDocuments() 308 318 { 319 320 // echo "aaaaaaaquoooooo"; 309 321 if (!isset($this->_documents)) 310 322 { 311 $queryStr = "SELECT * FROM phpgw_mydms_Documents WHERE folder = " . $this->_id . " ORDER BY sequence"; 323 $queryStr = "SELECT * FROM phpgw_mydms_documents WHERE folder = " . $this->_id . " ORDER BY id desc,sequence"; 324 // echo "eeeeee".$queryStr; 312 325 $resArr = $GLOBALS['mydms']->db->getResultArray($queryStr); 313 326 if (is_bool($resArr) && !$resArr) … … 341 354 'sequence' => $sequence, 342 355 ); 343 $res = $this->db->insert('phpgw_mydms_ Documents', $insertData, '', __LINE__, __FILE__, 'mydms');356 $res = $this->db->insert('phpgw_mydms_documents', $insertData, '', __LINE__, __FILE__, 'mydms'); 344 357 345 358 if (!$res) … … 355 368 # return false; 356 369 357 $document = getDocument($this->db->get_last_insert_id('phpgw_mydms_ Documents','id'));370 $document = getDocument($this->db->get_last_insert_id('phpgw_mydms_documents','id')); 358 371 359 372 $res = $document->addContent($comment, $owner, $tmpFile, $orgFileName, $fileType, $mimeType); 360 373 if (is_bool($res) && !$res) 361 374 { 362 $queryStr = "DELETE FROM phpgw_mydms_ Documents WHERE id = " . $document->getID();375 $queryStr = "DELETE FROM phpgw_mydms_documents WHERE id = " . $document->getID(); 363 376 $GLOBALS['mydms']->db->getResult($queryStr); 364 377 return false; … … 389 402 390 403 //Entfernen der Datenbankeintrï¿œge 391 $queryStr = "DELETE FROM phpgw_mydms_ Folders WHERE id = " . $this->_id;392 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 393 return false; 394 $queryStr = "DELETE FROM phpgw_mydms_ ACLs WHERE target = ". $this->_id. " AND targetType = " . T_FOLDER;395 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 396 return false; 397 $queryStr = "DELETE FROM phpgw_mydms_ Notify WHERE target = ". $this->_id. " AND targetType = " . T_FOLDER;404 $queryStr = "DELETE FROM phpgw_mydms_folders WHERE id = " . $this->_id; 405 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 406 return false; 407 $queryStr = "DELETE FROM phpgw_mydms_acls WHERE target = ". $this->_id. " AND targettype = " . T_FOLDER; 408 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 409 return false; 410 $queryStr = "DELETE FROM phpgw_mydms_notify WHERE target = ". $this->_id. " AND targettype = " . T_FOLDER; 398 411 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 399 412 return false; … … 415 428 if (!isset($this->_accessList)) 416 429 { 417 $queryStr = "SELECT * FROM phpgw_mydms_ ACLs WHERE targetType = ".T_FOLDER." AND target = " . $this->_id . " ORDER BY targetType";418 430 $queryStr = "SELECT * FROM phpgw_mydms_acls WHERE targettype = ".T_FOLDER." AND target = " . $this->_id . " ORDER BY targettype"; 431 //echo "aqui".$queryStr ; 419 432 $resArr = $GLOBALS['mydms']->db->getResultArray($queryStr); 420 433 … … 426 439 foreach ($resArr as $row) 427 440 { 441 //echo "el grupo de acceso es".$row[4]." ".$row["groupid"]."<br>"; 442 428 443 if ($row["userid"] != -1) 429 444 array_push($this->_accessList["users"], new UserAccess($row["userid"], $row["mode"])); … … 435 450 return $this->_accessList; 436 451 } 452 453 454 455 function getAccessList2() 456 { 457 458 $grupos=read_repository2($GLOBALS['phpgw_info']['user']['account_id']); 459 // echo "".$GLOBALS['phpgw_info']['user']['account_id']; 460 461 if($grupos!=''){ 462 $queryStr = "SELECT * FROM phpgw_mydms_acls WHERE targettype = ".T_FOLDER." AND target = " . $this->_id . " and (userid=".$GLOBALS['phpgw_info']['user']['account_id']." or groupid in (".$grupos.")) ORDER BY targettype"; 463 }else{ 464 $queryStr = "SELECT * FROM phpgw_mydms_acls WHERE targettype = ".T_FOLDER." AND target = " . $this->_id . " and (userid=".$GLOBALS['phpgw_info']['user']['account_id']." ) ORDER BY targettype"; 465 466 } 467 //echo "<br>aqui".$queryStr ; 468 $resArr = $GLOBALS['mydms']->db->getResultArray($queryStr); 469 470 471 if (is_bool($resArr) && !$resArr) 472 return false; 473 474 //$this->_accessList = array("groups" => array(), "users" => array()); 475 foreach ($resArr as $row) 476 { 477 //echo "acceso".$row["mode"]; 478 //echo "el grupo de acceso es".$row[4]." ".$row["groupid"]."<br>"; 479 return $row["mode"]; 480 /*if ($row["userid"] != -1) 481 array_push($this->_accessList["users"], new UserAccess($row["userid"], $row["mode"])); 482 else //if ($row["groupID"] != -1) 483 array_push($this->_accessList["groups"], new GroupAccess($row["groupid"], $row["mode"]));*/ 484 } 485 486 return false; 487 } 437 488 438 489 function clearAccessList() 439 490 { 440 $queryStr = "DELETE FROM phpgw_mydms_ ACLs WHERE targetType = " . T_FOLDER . " AND target = " . $this->_id;491 $queryStr = "DELETE FROM phpgw_mydms_acls WHERE targettype = " . T_FOLDER . " AND target = " . $this->_id; 441 492 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 442 493 return false; … … 450 501 $userOrGroup = ($isUser) ? "userid" : "groupid"; 451 502 452 $queryStr = "INSERT INTO phpgw_mydms_ ACLs (target, targetType, ".$userOrGroup.", mode) VALUES503 $queryStr = "INSERT INTO phpgw_mydms_acls (target, targettype, ".$userOrGroup.", mode) VALUES 453 504 (".$this->_id.", ".T_FOLDER.", " . $userOrGroupID . ", " .$mode. ")"; 454 505 if (!$GLOBALS['mydms']->db->getResult($queryStr)) … … 463 514 $userOrGroup = ($isUser) ? "userID" : "groupID"; 464 515 465 $queryStr = "UPDATE phpgw_mydms_ ACLs SET mode = " . $newMode . " WHERE targetType = ".T_FOLDER." AND target = " . $this->_id . " AND " . $userOrGroup . " = " . $userOrGroupID;516 $queryStr = "UPDATE phpgw_mydms_acls SET mode = " . $newMode . " WHERE targettype = ".T_FOLDER." AND target = " . $this->_id . " AND " . $userOrGroup . " = " . $userOrGroupID; 466 517 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 467 518 return false; … … 475 526 $userOrGroup = ($isUser) ? "userID" : "groupID"; 476 527 477 $queryStr = "DELETE FROM phpgw_mydms_ ACLs WHERE targetType = ".T_FOLDER." AND target = ".$this->_id." AND ".$userOrGroup." = " . $userOrGroupID;528 $queryStr = "DELETE FROM phpgw_mydms_acls WHERE targettype = ".T_FOLDER." AND target = ".$this->_id." AND ".$userOrGroup." = " . $userOrGroupID; 478 529 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 479 530 return false; … … 492 543 function getAccessMode($user) 493 544 { 545 494 546 GLOBAL $settings; 495 547 … … 532 584 //ACLs durchforsten 533 585 $foundInACL = false; 534 $accessList = $this->getAccessList(); 586 587 return $this->getAccessList2(); 588 /*$accessList = $this->getAccessList(); 535 589 if (!$accessList) { 536 590 return false; … … 552 606 foreach ($accessList["groups"] as $groupAccess) 553 607 { 608 554 609 if ($user->isMemberOfGroup($groupAccess->getGroup())) 555 610 { 611 612 // echo "entro grupoooo<br>";//.$groupAccess->getGroup()." <br>"; 613 556 614 $foundInACL = true; 557 615 if ($groupAccess->getMode() > $highestPrivileged) … … 562 620 } 563 621 if ($foundInACL) 564 return $highestPrivileged; 622 return $highestPrivileged;*/ 565 623 566 624 //Standard-Berechtigung verwenden 567 return $this->getDefaultAccess();625 //return $this->getDefaultAccess(); 568 626 } 569 627 … … 572 630 if (!isset($this->_notifyList)) 573 631 { 574 $queryStr ="SELECT * FROM phpgw_mydms_ Notify WHERE targetType = " . T_FOLDER . " AND target = " . $this->_id;632 $queryStr ="SELECT * FROM phpgw_mydms_notify WHERE targettype = " . T_FOLDER . " AND target = " . $this->_id; 575 633 $resArr = $GLOBALS['mydms']->db->getResultArray($queryStr); 576 634 if (is_bool($resArr) && $resArr == false) … … 593 651 $userOrGroup = ($isUser) ? "userID" : "groupID"; 594 652 595 $queryStr = "INSERT INTO phpgw_mydms_ Notify (target, targetType, " . $userOrGroup . ") VALUES (" . $this->_id . ", " . T_FOLDER . ", " . $userOrGroupID . ")";653 $queryStr = "INSERT INTO phpgw_mydms_notify (target, targettype, " . $userOrGroup . ") VALUES (" . $this->_id . ", " . T_FOLDER . ", " . $userOrGroupID . ")"; 596 654 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 597 655 return false; … … 605 663 $userOrGroup = ($isUser) ? "userID" : "groupID"; 606 664 607 $queryStr = "DELETE FROM phpgw_mydms_ Notify WHERE target = " . $this->_id . " AND targetType = " . T_FOLDER . " AND " . $userOrGroup . " = " . $userOrGroupID;665 $queryStr = "DELETE FROM phpgw_mydms_notify WHERE target = " . $this->_id . " AND targettype = " . T_FOLDER . " AND " . $userOrGroup . " = " . $userOrGroupID; 608 666 if (!$GLOBALS['mydms']->db->getResult($queryStr)) 609 667 return false;
Note: See TracChangeset
for help on using the changeset viewer.