pronto/plugins/template/jqgrid.php

Go to the documentation of this file.

<?php
class tpjqGrid extends Plugin
{
        var $guid = 0;

        function tpjqGrid() {
                $this->Plugin();
                $this->depend('html','form');
        }

        function build($url, $params)
        {
                assert_type($params['columns'], 'array');
                // build our URL -- we have to set the AJAX flag and specify which fields
                // we need back from the controller
                $url = $this->depends->html->composite_url($url, array(
                        '_ajax' => 1,
                        'cols'  => urlencode(implode('&', array_keys($params['columns'])))
                ));

                $grid = array(
                        'url'         => $url,
                        'datatype'    => $this->_getparam($params, 'datatype', 'json'),
                        'height'      => $this->_getparam($params, 'height', ''),
                        'width'       => $this->_getparam($params, 'width', ''),
                        'loadText'    => __('Loading...'),
                        'altRows'     => true,
                        'loadui'      => 'block',  // default: 'enable'
                        'colNames'    => array(),
                        'colModel'    => array(),
                        'rowNum'      => $this->_getparam($params, 'perpage', 10),
                        'rowList'     => array(10,50,200,1000),
                        'viewrecords' => true,
                        'caption'     => $this->_getparam($params, 'caption', ''),
                        // override query vars used by jqGrid to match Pronto's
                        'prmNames'    => array(
                                'page'  => 'p_p',
                                'rows'  => 'p_pp',
                                'sort'  => 's_f',
                                'order' => 's_d'
                        ),
                        'toolbar' => array(true,'top'),
                );

                foreach($params['columns'] as $name=>$col) {
                        $grid['colNames'][] = $col['label'];
                        $gcol = array(
                                'name' => $name,
                                'index' => $col['expr'] ? $col['expr'] : $name,
                                //'width' => '',
                                //'align' => '',
                        );

                        $this->_optvar($col, 'width', $gcol);
                        $this->_optvar($col, 'align', $gcol);
                        $this->_optvar($col, 'date_format', $gcol, 'datefmt'); // XXX: incomplete format set
                        $this->_optvar($col, 'editable', $gcol);
                        $this->_optvar($col, 'search', $gcol, 'searchable');
                        $this->_optvar($col, 'sortable', $gcol);

                        $grid['colModel'][] = $gcol;
                }

                $tbl_id = $this->_getparam($params, 'grid_id', 'jqgrid'.++$this->guid);
                $pgr_id = $this->_getparam($params, 'pager_id', 'jqpager'.++$this->guid);
                $sch_id = $this->_getparam($params, 'search_id', 'jqsearch'.++$this->guid);

                $html  = '';
                $html .= '<div id="'.$sch_id.'" style="display:none"></div>';
                $html .= '<table id="'.$tbl_id.'" class="scroll" cellpadding="0" cellspacing="0"></table>';
                $html .= '<div id="'.$pgr_id.'" class="scroll" style="text-align:center"></div>';

                $this->depends->html->js_load('jqgrid/jquery.jqGrid');
                // needed for modals
                $this->depends->html->css_load('modal');
                $this->depends->html->js_load('jq/jquery.modal');

                $js  = 'var g = '.json_encode($grid).';';
                // add in elements that we can't put through json_encode()
                //   (eg, jQuery selectors)
                $js .= 'g.imgpath = "'.url('/img/jqgrid/basic').'";';
                $js .= 'g.pager = jQuery("#'.$pgr_id.'");';
                // wrap it all up and run it
                $js .= 'jQuery("#'.$tbl_id.'").jqGrid(g)';
                $js .= '.navGrid("#'.$pgr_id.'", {edit:false, add:false, del:false})';

                $js .= '.navButtonAdd("#'.$pgr_id.'", {caption:"Search", title:"Toggle Search", buttonimg:g.imgpath+"/find.gif", onClickButton:function(){ jQuery("#t_'.$tbl_id.'").show(); } })';

                //$js .= '.navButtonAdd("#'.$pgr_id.'", {caption:"Search", title:"Toggle Search", buttonimg:g.imgpath+"/find.gif", onClickButton:function(){ if(jQuery("#'.$sch_id.'").css("display")=="none") { /*jQuery(".HeaderButton").trigger("click");*/ jQuery("#'.$sch_id.'").show(); } } })';
                //$js .= '.navButtonAdd("#'.$pgr_id.'", {caption:"Clear", title:"Clear Search", buttonimg:g.imgpath+"/refresh.gif", onClickButton:function(){ var stat = jQuery("#'.$tbl_id.'").getGridParam("search"); if(stat) { var cs = jQuery("#'.$sch_id.'")[0]; cs.clearSearch(); } } })';
                $js .= ';';

                // toolbar
                $js .= 'jQuery("#t_'.$tbl_id.'").filterGrid("#'.$tbl_id.'", { gridModel:true, gridNames:false, gridToolbar:true, formtype:"horizontal", enableSearch:true, enableClear:false, autosearch:true, afterSearch:function() { jQuery(".HeaderButton").trigger("click"); jQuery("#'.$sch_id.'").css("display","none"); } } );';
                $js .= 'jQuery("#t_'.$tbl_id.'").hide();';

                //$js .= 'jQuery("#'.$sch_id.'").filterGrid("#'.$tbl_id.'", { gridModel:true, gridNames:true, formtype:"horizontal", enableSearch:true, enableClear:false, autosearch:false, afterSearch:function() { jQuery(".HeaderButton").trigger("click"); jQuery("#'.$sch_id.'").css("display","none"); } } );';
                //$js .= 'jQuery("#sg_invdate","#filter").datepicker({dateFormat:"yy-mm-dd"});';

                $this->depends->html->js_run('', $js);

                // CSS
                $this->depends->html->css_load('jqgrid/basic');

                // DEBUG
                $html .= '<br><br><pre style="font-size:8pt" id="jsdbg"></pre>';
                $this->depends->html->js_load('beautify');
                $this->depends->html->js_run('', '$("#jsdbg").html(js_beautify(\''.str_replace("'", "\\'", $js).'\'));');


                return $html;
        }

        function _optvar($src_arr, $src_key, &$dst_arr, $dst_key='')
        {
                if(empty($dst_key)) $dst_key = $src_key;
                if(isset($src_arr[$src_key])) $dst_arr[$dst_key] = $srt_arr[$src_key];
        }

        function _getparam($params, $name, $default)
        {
                if(isset($params[$name])) {
                        return $params[$name];
                }
                return $default;
        }

}

?>

---