//Start Property DataTables ServerSide
        function Paging( $input ){
        $sLimit = "";
        if ( isset( $input['iDisplayStart'] ) && $input['iDisplayLength'] != '-1' ) {
            $sLimit = " LIMIT ".intval( $input['iDisplayStart'] ).", ".intval( $input['iDisplayLength'] );
        }

        return $sLimit;
        }


        function Ordering( $input, $aColumns ){
                $aOrderingRules = array();
                if ( isset( $input['iSortCol_0'] ) ) {
                    $iSortingCols = intval( $input['iSortingCols'] );
                    for ( $i=0 ; $i<$iSortingCols ; $i++ ) {
                        if ( $input[ 'bSortable_'.intval($input['iSortCol_'.$i]) ] == 'true' ) {
                            $aOrderingRules[] =
                            $aColumns[ intval( $input['iSortCol_'.$i] ) ]." "
                            .($input['sSortDir_'.$i]==='asc' ? 'asc' : 'desc');
                        }
                    }
                }

                if (!empty($aOrderingRules)) {
                    $sOrder = " ORDER BY ".implode(", ", $aOrderingRules);
                    } else {
                    $sOrder = "";
                }
                return $sOrder;
        }

        function Filtering( $aColumns, $iColumnCount, $input){
                if ( isset($input['sSearch']) && $input['sSearch'] != "" ) {
                    $aFilteringRules = array();
                    for ( $i=0 ; $i<$iColumnCount ; $i++ ) {
                        if ( isset($input['bSearchable_'.$i]) && $input['bSearchable_'.$i] == 'true' ) {
                            $aFilteringRules[] = $aColumns[$i]." LIKE '%".addslashes( $input['sSearch'] )."%'";
                        }
                    }
                    if (!empty($aFilteringRules)) {
                        $aFilteringRules = array('('.implode(" OR ", $aFilteringRules).')');
                    }
                }

                // Individual column filtering
                for ( $i=0 ; $i<$iColumnCount ; $i++ ) {
                    if ( isset($input['bSearchable_'.$i]) && $input['bSearchable_'.$i] == 'true' && $input['sSearch_'.$i] != '' ) {
                        $aFilteringRules[] = $aColumns[$i]."  LIKE '%".addslashes($input['sSearch_'.$i])."%'";
                    }
                }

                if (!empty($aFilteringRules)) {
                    $sWhere = " WHERE ".implode(" OR ", $aFilteringRules);
                    } else {
                    $sWhere = " WHERE 1=1 ";
                }
                return $sWhere;
        }
        //End Property DataTables ServerSide