tablelist bby framework

    function getTableListQueuing($stud_id=null){
        // Process the query string and exclude querystring named "p"
        if (!empty($_SERVER['QUERY_STRING'])) {
            $qrystr = explode("&",$_SERVER['QUERY_STRING']);
            foreach ($qrystr as $value) {
                $qstr = explode("=",$value);
                if ($qstr[0]!="p") {
                    $arrQryStr[] = implode("=",$qstr);
                }
            }
            $aQryStr = $arrQryStr;
            $aQryStr[] = "p=@@";
            $queryStr = implode("&",$aQryStr);
        }

        $qry = array();

        if (isset($_REQUEST['search_field'])) {
            // lets check if the search field has a value
            if (strlen($_REQUEST['search_field'])>0) {
                // lets assign the request value in a variable
                $search_field = $_REQUEST['search_field'];


                // create a custom criteria in an array
                $qry[] = "user_type like '%$search_field%'";
                $qry[] = "user_fullname like '%$search_field%'";
                $qry[] = "cesqt_date like '%$search_field%'";

            }
        }


        // put all query array into one criteria string
        $criteria = (count($qry)>0)?" where ".implode(" and ",$qry):"";

        // Sort field mapping
        $arrSortBy = array(
              "cesqt_date"=>"cesqt_date"
        );

        if(isset($_GET['sortby'])){
            $strOrderBy = " order by ".$arrSortBy[$_GET['sortby']]." ".$_GET['sortof'];
        }else{
            $strOrderBy = " order by cesqt.cesqt_id DESC";
        }


        //$viewLink = "<a href=\"?statpos=applicant_information&edit=',am.stud_applicant_id,'\"><img src=\"".SYSCONFIG_THEME_URLPATH.SYSCONFIG_THEME."/images/admin/zoom.gif\" title=\"view\" hspace=\"2px\" border=0></a>";
        $editLink = "<a href=\"?statpos=enroll_subjects_queue&addreturnee=',cesqt.cesqt_id,'\"><img src=\"".SYSCONFIG_THEME_URLPATH.SYSCONFIG_THEME."/images/admin/edit.gif\" title=\"Edit\" hspace=\"2px\" border=0></a>";



        $sql = "select cesqt.*,concat('$editLink') as edit from college_enroll_subjects_queue_trans cesqt
                $criteria
                $strOrderBy";



        $sqlcount = "select count(*)
                from college_enroll_subjects_queue_trans
                    $criteria";

        // Field and Table Header Mapping
        $arrFields = array(
            "cesqt_date"=>"Transaction Date"
            ,"cesqt_subject_status"=>"Transaction"
            ,"permit_to_enroll"=>"Permitted to Enroll"
            ,"user_type"=>"User type"
            ,"user_fullname"=>"Process By"
            ,"edit"=>""
        );

        // Column (table data) User Defined Attributes
        $arrAttribs = array(
            /*"mnu_ord"=>" align='right'",*/
            "viewdata"=>"width='50' align='center'"
        );

        // Process the Table List
        $tblDisplayList = new clsTableList($this->conn);
        $tblDisplayList->arrFields = $arrFields;
        $tblDisplayList->paginator->linkPage = "?$queryStr";
        $tblDisplayList->sqlAll = $sql;
        $tblDisplayList->sqlCount = $sqlcount;

        return $tblDisplayList->getTableList($arrAttribs);
    }