Subversion Repositories php_users

      public function getARecord( $whereFields, $fieldList = null ) {

         $id = isset( $whereFields['id'] ) ? $whereFields['id'] : null;

         $result = parent::getARecord( $whereFields, $fieldList );

         if ( $result && isset( $id ) ) {

            $result['permissions'] = $this->getPermissions( $id );

         }

         return $result;

      }

      public function getPermissions ( $id ) {

         $query = ( 

            $id == -1 ?

               "select name permission,default_value value from _permissions" :

               "select permission,value from _view_users_permissions where users_id = $id"

         );

         $results = $this->doSQL( $query );

         $values = $results->fetch_all(MYSQLI_ASSOC);

         return array_column( $values, 'value', 'permission' );

      }

      public function getFullPermissions( $id ) {

         $query = (

            $id == -1 ?

               "select _permission_id permission_id, _permissions.name permission, description, _permissions_categories.name category, default_value value from _permissions join _permissions_categories using (_permission_category_id)" :

               "select permission_id,permission,description,category,value from _view_users_permissions where users_id = $id order by category,description"

         );

         $results = $this->doSQL( $query );

         return $results->fetch_all(MYSQLI_ASSOC);

      }

      public function updatePermissions ( $userID,$newData ) {

         $query = '';

         foreach ( $newData as $key => $value ) {

            $query = "insert into _permissions ( _user_id,_permission_id,value) select $userID, _permission_id, $value from _permissions where name = 'key' on duplicate key update value = $value";

            $this->doSQL( $query, true );

      } // update