silverstripe-gsoc/cms/code/MemberList.php

   1 <?php
   2
   3 class MemberList extends FormField {
   4         protected $members;
   5         protected $hidePassword;
   6         protected $pageSize;
   7
   8         function __construct($name, $group, $members = null, $hidePassword = null, $pageLimit = 10) {
   9                 if($group) {
  10                         if(is_object($group)) $this->group = $group;
  11                         else $this->group = DataObject::get_by_id('Group',$group);
  12                 }
  13
  14                 $this->pageSize = $pageLimit;
  15
  16                 if($members) $this->members = $this->memberListWithGroupID($members, $group);
  17
  18                 $this->hidePassword = $hidePassword;
  19
  20                 parent::__construct(null);
  21         }
  22
  23         function memberListWithGroupID($members, $group) {
  24                 $newMembers = new DataObjectSet();
  25                 foreach($members as $member) {
  26                         $newMembers->push($member->customise(array("GroupID" => $group->ID)));
  27                 }
  28                 return $newMembers;
  29         }
  30
  31         function FieldHolder() {
  32                 return $this->renderWith("MemberList");
  33         }
  34         function setGroup($group) {
  35                 $this->group = $group;
  36         }
  37         function setController($controller) {
  38                 $this->controller = $controller;
  39         }
  40
  41         function GroupID() {
  42                 if( $this->group )
  43                         return $this->group->ID;
  44
  45                 return '0';
  46         }
  47
  48         function GetControllerName() {
  49                 return $this->controller->class;
  50         }
  51         function Members() {
  52                 /*if($this->members)
  53                         $members = $this->members;
  54                 else if($this->group) {
  55                         $members = $this->group->Members( $this->pageSize, 0 );
  56                         $allMembers = $this->group->Members();
  57
  58                         if( $allMembers )
  59                                 $total = $allMembers->Count();
  60                 } else
  61                         return null;*/
  62
  63                 if( $this->members )
  64                         return $this->members;
  65
  66                 if( !$baseGroup )
  67                         $baseGroup = $this->group->ID;
  68
  69                 // Debug::message( $_REQUEST['MemberListOrderByField'] );
  70
  71                 // construct the filter and sort
  72
  73                 if( $_REQUEST['MemberListOrderByField'] )
  74                         $sort = "`" . $_REQUEST['MemberListOrderByField'] . "`" . addslashes( $_REQUEST['MemberListOrderByOrder'] );
  75
  76                 $whereClauses = array();
  77
  78                 $search = addslashes( $_REQUEST['MemberListSearch'] );
  79
  80                 if( is_numeric( $_REQUEST['MemberListStart'] ) )
  81                         $limitClause = ( $_REQUEST['MemberListStart'] ) . ", {$this->pageSize}";
  82                 else
  83                         $limitClause = "0, {$this->pageSize}";
  84
  85
  86                 if( !empty($_REQUEST['MemberListSearch'])  )
  87                         $whereClauses[] = "( `Email`='$search' OR `FirstName`='$search' OR `Surname`='$search' )";
  88
  89                 if( is_numeric( $_REQUEST['MemberListBaseGroup'] ) )
  90                         $baseGroup = $_REQUEST['MemberListBaseGroup'];
  91
  92                 $whereClauses[] = "`GroupID`='".$baseGroup."'";
  93                 $join = "INNER JOIN `Group_Members` ON `MemberID`=`Member`.`ID`";
  94
  95                 // $_REQUEST['showqueries'] = 1;
  96
  97                 $members = DataObject::get('Member', implode( ' AND ', $whereClauses ), $sort, $join, $limitClause );
  98
  99                 // $_REQUEST['showqueries'] = 0;
 100
 101                 if( is_numeric( $_REQUEST['MemberListGroup'] ) ) {
 102                         $baseMembers = new DataObjectSet();
 103
 104                         if( $members )
 105                                 foreach( $members as $member )
 106                                         if( $member->inGroup( $_REQUEST['MemberListGroup'] ) )
 107                                                 $baseMembers->push( $member );
 108                 } else
 109                         $baseMembers = $members;
 110
 111                 if($members){
 112                         $members->setPageLimits( $_REQUEST['MemberListStart'], $this->pageSize, $total );
 113
 114                         $this->members = $this->memberListWithGroupID($members, $this->group);
 115                 }
 116                 return $this->members;
 117         }
 118
 119         function FirstLink() {
 120                 if( !$_REQUEST['MemberListStart'] )
 121                         return null;
 122
 123                 return "admin/security/listmembers?MemberListStart=0{$this->filterString()}";
 124         }
 125
 126         function filterString() {
 127
 128                 foreach( $_REQUEST as $key => $value ) {
 129                         if( strpos( $key, 'MemberList' ) === 0 && $key != 'MemberListStart' )
 130                                 $filterString .= "&$key=$value";
 131                 }
 132
 133                 if( !$_REQUEST['MemberListBaseGroup'] )
 134                         $filterString .= '&MemberListBaseGroup=' . $this->group->ID;
 135
 136                 return $filterString;
 137         }
 138
 139         function MemberListStart() {
 140                 return $_REQUEST['MemberListStart'];
 141         }
 142
 143         function PrevLink() {
 144                 if( !$_REQUEST['MemberListStart'] )
 145                         return null;
 146
 147                 $prevStart = $_REQUEST['MemberListStart'] - $this->pageSize;
 148
 149                 if( $prevStart < 0 )
 150                         $prevStart = 0;
 151
 152                 return "admin/security/listmembers?MemberListStart=$prevStart{$this->filterString()}";
 153         }
 154
 155         function NextLink() {
 156                 $total = $this->TotalMembers();
 157
 158                 $lastStart = $total - ( $total % $this->pageSize );
 159
 160                 if( $_REQUEST['MemberListStart'] >= $lastStart )
 161                         return null;
 162
 163                 return "admin/security/listmembers?MemberListStart={$this->pageSize}{$this->filterString()}";
 164         }
 165
 166         function LastLink() {
 167
 168                 $total = $this->TotalMembers();
 169
 170                 $lastStart = $total - ( $total % $this->pageSize );
 171
 172                 if( $_REQUEST['MemberListStart'] >= $lastStart )
 173                         return null;
 174
 175                 return "admin/security/listmembers?MemberListStart=$lastStart{$this->filterString()}";
 176         }
 177
 178         function PageSize() {
 179                 return $this->pageSize;
 180         }
 181
 182         function FirstMember() {
 183                 return $_REQUEST['MemberListStart'] + 1;
 184         }
 185
 186         function LastMember() {
 187                 return $_REQUEST['MemberListStart'] + min( $_REQUEST['MemberListStart'] + $this->pageSize, $this->TotalMembers() - $_REQUEST['MemberListStart'] );
 188         }
 189
 190         function TotalMembers() {
 191                 if($this->group)  $members = $this->group->Members();
 192
 193                 if( !$members )
 194                         return null;
 195
 196                 return $members->TotalItems();
 197         }
 198
 199         function DontShowPassword(){
 200                 if( $this->hidePassword )
 201                         return true;
 202
 203                 return $this->controller->class=='CMSMain'||$this->controller->class=='NewsletterAdmin';
 204         }
 205
 206         function AddRecordForm() {
 207                 if($this->DontShowPassword())
 208                 {
 209                         return new TabularStyle(new Form($this->controller,'AddRecordForm',
 210                                 new FieldSet(
 211                                         new TextField("FirstName", "First Name"),
 212                                         new TextField("Surname", "Surname"),
 213                                         new TextField("Email", "Email"),
 214                                         new HiddenField("GroupID", null, $this->group->ID)
 215                                 ),
 216                                 new FieldSet(
 217                                         new FormAction("addmember", "Add")
 218                                 )
 219                         ));
 220
 221                 } else {
 222                         return new TabularStyle(new Form($this->controller,'AddRecordForm',
 223                                 new FieldSet(
 224                                         new TextField("FirstName", "First Name"),
 225                                         new TextField("Surname", "Surname"),
 226                                         new TextField("Email", "Email"),
 227                                         new TextField("Password", "Password"),
 228                                         new HiddenField("GroupID", null, $this->group->ID)
 229                                 ),
 230                                 new FieldSet(
 231                                         new FormAction("addmember", "Add")
 232                                 )
 233                         ));
 234                 }
 235         }
 236
 237         function SearchField() {
 238                 $field = new TextField( 'MemberListSearch', 'Search' );
 239                 return $field->FieldHolder();
 240         }
 241
 242         function OrderByField() {
 243                 $fields = new FieldGroup( new DropdownField('MemberListOrderByField','', array(
 244                         'FirstName' => 'FirstName',
 245                         'Surname' => 'Surname',
 246                         'Email' => 'Email'
 247                 )),
 248                 new DropdownField('MemberListOrderByOrder','',array(
 249                         'ASC' => 'Ascending',
 250                         'DESC' => 'Descending'
 251                 )));
 252
 253                 $field = new FieldGroup( new LabelField( 'Order by' ), $fields );
 254                 return $field->FieldHolder();
 255         }
 256
 257         function GroupFilter() {
 258
 259                 $groups = DataObject::get('Group');
 260
 261                 $groupArray = array( '' => 'Any group' );
 262
 263                 foreach( $groups as $group )
 264                         $groupArray[$group->ID] = $group->Title;
 265
 266                 $field = new DropdownField('MemberListGroup','Filter by group',$groupArray );
 267                 return $field->FieldHolder();
 268         }
 269 }
 270
 271 ?>