/Applications/XAMPP/xamppfiles/htdocs/roombooker/modules/depselect/actions/depselect_load.php

Go to the documentation of this file.

<?php
/*
 * Xataface Depselect Module
 * Copyright (C) 2011  Steve Hannah <steve@weblite.ca>
 * 
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Library General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 * 
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Library General Public License for more details.
 * 
 * You should have received a copy of the GNU Library General Public
 * License along with this library; if not, write to the
 * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
 * Boston, MA  02110-1301, USA.
 *
 */
 
class actions_depselect_load {


        static function errorMessage($fieldname){
        
                return "Failed to load values for field '".$fieldname."'.  See server error log for details.";
        }

        function handle($params){
        
                session_write_close();
                header('Connection: close');
                
                $app = Dataface_Application::getInstance();
                $query = $app->getQuery();
                $table = Dataface_Table::loadTable($query['-table']);
                $field = $table->getField($query['-field']);
                //$table = Dataface_Table::loadTable($field['widget']['table']);
                $this->loadFromTable($table, $field, $query);
                
        }
        
        
        private function loadFromTable(Dataface_Table $table, &$field, $query){
                
                try {
                        
                        $perms = $table->getPermissions(array('field'=>$field['name']));
                        if ( !@$perms['edit'] and !@$perms['new'] ){
                                // The user doesn't have permission to edit the column... so we 
                                // need to cut off access right now!!!
                                error_log("Insufficient permissions to access field $field[name] by current user.");
                                throw new Exception("Failed to get options for field $filed[name] because you don't have view permission for this field.", 401);
                        
                        }
                        
                        
                        
                        
                        if ( !@$field['widget']['table'] ){
                                error_log("widget:table not defined for field ".$field['name']." of table ".$table->tablename.".");
                                throw new Exception(self::errorMessage($fieldname), 500);
                        }
                        $targetTable = Dataface_Table::loadTable($field['widget']['table']);
                        
                        $filters = array();
                        if ( @$field['widget']['filters']  and is_array($field['widget']['filters'])){
                                foreach ($field['widget']['filters'] as $key=>$val){
                                        if ( isset($query[$key]) ){
                                                $filters[$key]=$query[$key];
                                        } else if ( strpos($val,'$') === 0 ){
                                                $filters[$key] = '=';
                                        } else {
                                                $filters[$key] = $val;
                                        }
                                }
                        }
                        
                        
                        
                        $limit = 250;
                        if ( @$field['widget']['limit'] ){
                                $limit = intval($field['widget']['limit']);
                        }
                        
                        $filters['-limit'] = $limit;
                        $records = df_get_records_array($field['widget']['table'], $filters);
                        //if ( count($filters) > 1 ){
                        //      echo "Num records found: ".count($records);
                        //      print_r($filters);
                        //}
                        $keyCol = null;
                        $labelCol = null;
                        
                        if ( @$field['widget']['keycol'] ){
                                $keyCol = $field['widget']['keycol'];
                        } else {
                                foreach ($targetTable->keys() as $k=>$v){
                                        $keyCol = $k;
                                        break;
                                }
                        }
                        
                        if ( @$field['widget']['labelcol'] ){
                                $labelCol = $field['widget']['labelcol'];
                        }
                        
                        $out = array();
                        foreach ($records as $r){
                                if ( @$field['widget']['ignore_permissions'] ){
                                        $r->secureDisplay = false;
                                } else {
                                        if ( !$r->checkPermission('view') ) continue;
                                        if ( !$r->checkPermission('view', array('field'=>$keyCol))) continue;
                                        if ( $labelCol and !$r->checkPermission('view', array('field'=>$labelCol))) continue;
                                }
                                
                                if ( $labelCol ){
                                        $out[$r->val($keyCol)] = $r->display($labelCol);
                                } else {
                                        $out[$r->val($keyCol)] = $r->getTitle();
                                }
                        
                        }
                        
                        $this->out(array(
                                'code'=>200,
                                'message'=>'Received default valuelist',
                                'values'=>$out
                        ));
                        exit;
                        
                
                } catch (Exception $ex){
                
                        $this->out(array(
                                'code'=>$ex->getCode(),
                                'message'=>$ex->getMessage()
                        ));
                        exit;
                }
        
        }
        
        
        private function out($params){
                header('Content-type: text/json; charset="'.Dataface_Application::getInstance()->_conf['oe'].'"');
                echo json_encode($params);
        }
        
        
        
}