melkhior's avatar

Pagination of N level hierarchy category system in tree view

I currently have a N level hierarchy category system (Category model), and a coin system (Coin model), I have a page that shows all the categories and coins in a tree view. But since there is a lot of coins, is there a way to paginate it all based on the amount of coins?, Say, limit it to around 50 coins a page. Can't think of any proper way to do it since there can be infinite subcategories.

Basically currently it is:

-Root category
    --Sub category
    +Coin
    +Coin
    +Coin
        ---Sub sub category
            +Coin
            +Coin
            +Coin
    --Sub category
        +Coin
        +Coin
and so on with more root categories etc.
0 likes
14 replies
jlrdw's avatar

Not an answer, but a while back I showed a double paginator, where parent has paginator, child records has paginator. After going through all the current child records, click next parent on that paginator.

SO bottom line, a simple paginate(10) or whatever won't do it, need to role sleeves up and write custom pagination for each sub class.

To note, I look forward to what some of the others have to say on this.

Hint, this type stuff is well suited as a single page report type thing.

Also see http://laravel.io/forum/04-04-2015-looping-through-collection

Hint 2, have to keep track where all parents / uppers are at, tip, be surprised how an array can help with that on each call, session could be friend here to.

Oh it's not easy.

melkhior's avatar

Yeah I figured Laravel's pagination system does not support that, and I don't really can use double pagination, since that page is mainly meant to be printed, so it needs to be as simple as possible.

jlrdw's avatar

How can you expect to print it when you have unknown totals, what would be printed? How many we talking? 100, 1000, a million?

melkhior's avatar

It's a private system for 1 person, right now it's at 700, max it will go to is 2000.

jlrdw's avatar

Do it like a pedigree program, wrte to a txt file and then perfect pagination see

DECENDANTS OF
LOCKERBIE BRIAN BORU,B,M    21/43
====================================
BARNABY O'BRIAN, ,M   14/186   
.    .BRAEMAR HEATHER,Y,F   187/1606  
.    .    .BRAEMAR LORD OF KUYKENDALL, ,M   14/1268  
.    .    .    .DORMANS TALLY HO TAR, ,F   2615/2616  
.    .    .    .    .DORMARK TUGBOAT ANNIE, ,F   2613/2367  
.    .    .BRAEMARS THISTLE,Y,F   14/1268  
.    .    .    .BRAEMAR OAKMEAD MAGNUM FORCE, ,M   1601/352   
.    .    .    .    .AUTUMNS THUNDER VISIONS,Y,F   1599/1600  
.    .    .    .BRAEMARS OAKMEAD DILLION,Y,M   351/352   
.    .    .    .    .BEAUTAWNS BRANDY ON THE ROCK,Y,F   350/5     
.    .    .RAINTREE BRAEMAR BAILIFF,Y,M   1610/1268  
.    .    .    .RAINTREE WILD MOUNTAIN HONEY, ,F   1607/1608  
.    .    .    .    .HYGATE GINGER,Y,F   2643/2640  
.    .    .    .SIR HENRYS KILA OF BRAEMAR,Y,F   1607/1608  
.    .    .    .    .VISIONS LADY ALEXI, ,F   155/1603  
.    .    .    .VALLEYWOOD CROW HAVEN CRASH,Y,M   1607/745   
.    .    .    .    .STONECREST BOROWICK MIZ STAR,B,F   2662/2661  
.    .GYPSY SANDYLANDS LOCKERBIE, ,F   187/2696  
.    .MONARCHS BARNABY JEWEL,B,F   187/192   
.    .    .MONARCHS DUSTY CHIEF,Y,M   189/190   
.    .    .    .MONARCHS BLACK ARROGANCE,B,M   162/163   
.    .    .    .    .BORADORS CARONDELET RISK,Y,F   128/3576  
.    .    .    .    .BORADORS RIDGEWAY REFLECTION,Y,F   128/129   
.    .    .    .    .BRETON GATE SWEET CREM, ,F   128/3744  
.    .    .    .    .BRIARY BONFIRE OF WNDSONG, ,F   128/1477  
.    .    .    .    .BRIARY LITTLE JAZZBIRD, ,F   128/1477  
.    .    .    .    .CEDARWOODS AUTUMN GUNNER,B,F   128/2307  
.    .    .    .    .CHELONS SLEEPLESS KNIGHT,B,F   128/873   
.    .    .    .    .DAVOEG SILKY BEAU,B,F   128/1477  
.    .    .    .    .DAYLIGHTS BLACKTHORN SHEENA,B,F   128/631   
.    .    .    .    .SAILIN CAJUNS CASANOVA,B,F   128/368   
.    .    .    .    .SAILINS CEDARWOOD PRIDE,B,F   128/368   
.    .    .    .    .SOMERSETT SNOW STORM,Y,F   128/559   
.    .    .    .    .STARPOINT BLACKTHORN BLONDE, ,F   128/2565  
.    .    .    .    .WINELIGHTS BIT OF ARROGANCE,Y,F   128/1477  
BORADORS INKA BEAUTY, ,F   14/2393  
.    .BARRLOCS CHUKA OF MUSKELUNGE,C,F   2389/2390  
.    .    .MUSKELUNGES BLACK CHARMER,B,M   2387/2388  
.    .    .    .BOROWICKS SOUTHERN CHARM, ,M   2383/2384  
.    .    .    .    .BOROWICKS WINNING COLOURS,B,F   2382/2376  
.    .    .    .JOLLYMUFF WEAVE ROOM BLUES, ,F   2383/2562  
.    .    .    .    .FAWNHAVEN KIVA DWELLER, ,F   2313/2561  
.    .MUSKELUNGES CHAMPAGNE LADY, ,F   2395/2390  
.    .    .MUSKELUNGES ONE OF A KIND,Y,F   155/2353  
.    .    .MUSKELUNGES TARA,B,F   235/2353  
.    .    .    .MUSKELUNGES LISAS LADY, ,F   2352/2351  
.    .    .    .    .MUSKELUNGES GUNAGO TIGRES,Y,F   2334/2350  
.    .    .    .    .MUSKELUNGES TIGER LILY,Y,F   2334/2350  
BORADORS PEACH MELBA,Y,F   14/2393  
.    .BORADORS EDGEWATER ECHO,Y,F   1981/2402  
.    .    .BORADORS EDGEWATER HARLOW,Y,F   2369/2366  
.    .    .    .BORADORS  CHLOE OF LARKANA,Y,F   132/2363  
.    .    .    .    .ZANE HILLS SUGAR CAIN,Y,F   842/3573  
.    .    .    .BORADORS DANNY BOY,B,M   235/2363  
.    .    .    .BORADORS SWEET CHARITY,Y,F   2364/2363  
.    .    .    .    .BORADORS SWEET AUTUMN MIST,Y,F   1598/2362  
BRAEMAR LORD OF KUYKENDALL, ,M   14/1268  
.    .DORMANS TALLY HO TAR, ,F   2615/2616  
.    .    .DORMARK TUGBOAT ANNIE, ,F   2613/2367  
.    .    .    .BLACKWING BALLON JUMPER,Y,M   155/1694  
BRAEMARS THISTLE,Y,F   14/1268  
.    .BRAEMAR OAKMEAD MAGNUM FORCE, ,M   1601/352   
.    .    .AUTUMNS THUNDER VISIONS,Y,M   1599/1600  
.    .    .    .BORADORS SWEET AUTUMN MIST,Y,F   1598/2362  
.    .    .    .    .DEER RUNS SWEET CARAMEL CREAM, ,F   756/2361  
.    .    .    .    .DEER RUNS WHITEHORN MIST,Y,F   2354/2361  
.    .BRAEMARS OAKMEAD DILLION,Y,M   351/352   
.    .    .BEAUTAWNS BRANDY ON THE ROCK,Y,F   350/5     
.    .    .    .BEAUTAWNS IMPORTER,Y,F   353/349   
.    .    .    .    .BELQUEST WORTH THE RISK,B,F   336/348   
.    .    .    .BEAUTAWNS INSIDE INFORMATION,Y,M   353/349   
BRIARY BLUEBELL, ,F   14/37    
.    .ELYSIUMS BRIGITTA ONEILL, ,F   2715/2716  
.    .    .WINGMASTERS BROYHILL NOELL,Y,F   2711/2633  
.    .    .    .BOLD AARON,Y,M   230/2644  
.    .    .    .    .HYGATE GINGER,Y,F   2643/2640  
.    .    .    .    .PROSPECTS FIRE AND REIGN, ,F   2643/2804  
.    .    .WINGMASTERS ELYSUIM GEM, ,F   2645/2633  
.    .    .    .SAILINS BUTTERFIELD CHATEAU,B,F   2632/2634  
.    .    .    .    .SAILIN SHATEAUX GRETCHEN, ,F   2641/2635  
BRIARY BONNIE BRIANA,B,F   14/37    
.    .BRIARY BRAE HIMSELF,B,M   44/1291  
.    .BRIARY BUSTLE,Y,F   377/1291  
.    .    .FINCHINGFIELD FAITH,Y,F   35/1413  
.    .    .    .FINCHINGFIELD CAPRICIOUS, ,F   344/1433  
.    .    .    .    .WENWOODS BANNER RUBY BEGONIA, ,F   2198/2199  
.    .    .    .FINCHINGFIELD CELTIC CAPER,B,M   344/1433  
.    .    .    .    .DANICKS BLACK MAGIC II,B,F   1432/3001  
.    .    .    .FINCHINGFIELD MIGHTY CASEY,B,M   344/1433  
.    .    .    .    .VAUGHNS KERRY BRIARGLEN, ,F   2192/1932  
.    .    .FINCHINGFIELD FANTASIA, ,F   35/1413  
.    .    .    .NORTHWOODS SANDMAN,Y,M   450/1412  
.    .    .    .    .CEDARWOOD STANDING OVATION, ,F   891/2185  
.    .    .    .    .LOBUFFS SUNDOWN AT KERRYMARK, ,F   891/1414  
.    .    .    .    .SECOND SIGHT ONYX,B,F   891/1849  
.    .    .FINCHINGFIELD INDIGO,B,F   35/1413  
.    .    .    .RAINELLS DYNASTY,B,M   344/2193  
.    .    .    .    .BREEZYS CYCLONE,Y,F   1935/2658  
.    .    .    .    .BRIARGLENS PAISLEY TAIN,Y,F   1935/1933  
.    .    .    .    .BUTTONW OOD PEPITA, ,F   1935/3738  
.    .    .    .    .STONECREST STAR OF INDIA,B,F   1935/2660  
.    .    .FINCHINGFIELD IVAN OF OAKLEA,Y,M   35/1413  
.    .    .    .COUNTRYSIDE TANTARA TILLE, ,F   3645/3635  
.    .    .    .    .LUBBERLINE COUNTRYSIDE SKIP,Y,F   3634/3644  
.    .BRIARY MARZIPAN,B,F   1481/1291  
.    .    .BRIARY BONFIRE OF WNDSONG, ,M   128/1477  
.    .    .    .HYWINDS BEST BET OF WINDSONG,B,F   1479/1483  
.    .    .BRIARY LITTLE JAZZBIRD, ,F   128/1477  
.    .    .    .BROYHILL WOODEN BIRD,Y,M   507/1740  
.    .    .    .    .SADDLEHILL DRIFTWOOD, ,F   1739/3663  
.    .    .    .    .SADDLEHILL PRETTY GIRL, ,F   1739/3667  
.    .    .    .    .SNOWBERRYS VANITY FAIR,Y,F   1739/2939  
.    .    .DAVOEG SILKY BEAU,B,M   128/1477  
.    .    .    .CEDARWOODS MASTER GUNNER,Y,M   706/2185  
.    .    .    .    .BLUMOON DUBH KEEGAN OKERRY, ,F   2184/2183  
.    .    .    .    .BLUMOON DUBH TARRANT O'KERRY,B,F   2184/2183  
.    .    .    .CEDARWOODS TOYNTON SERENADE, ,F   706/2311  
.    .    .    .    .CEDARWOODS INDEPENDENCE,Y,F   2313/2310  
.    .    .    .CHILLYBLEAK GLORIOUS SONG, ,M   706/2983  
.    .    .    .DAVOEG HILTON-HALL SAMMY BEAU, ,M   706/2303  
.    .    .    .    .CEDARWOODS AFFIDAVIT, ,F   2302/2304  
.    .    .    .DAVOEG MISS MOLLY MALONE, ,F   706/2308  
.    .    .    .    .CEDARWOOD SQUIRE O FAWNHAVEN,B,F   2412/2307  
.    .    .    .    .CEDARWOODS AUTUMN GUNNER,B,F   128/2307  
.    .    .    .DAYLIGHTS BLUE ECLIPSE, ,M   706/2565  
.    .    .    .    .BLACKTHORN TIMBERLINES TGIF, ,F   3769/2564  
.    .    .    .FINCHINGFIELD FREEDOM II, ,M   706/2327  
.    .    .    .    .BLUMOON SORCHA OBRIARGLEN, ,F   2326/1932  
.    .    .    .    .DEJA VUS CAN DO BELQUEST,Y,F   2326/400   
.    .    .    .    .DEJA VUS NAUTICAL BOUY,Y,F   2326/400   
.    .    .    .SPENROCK WIRRAWAX, ,F   706/3052  
.    .    .WINELIGHTS BIT OF ARROGANCE,Y,M   128/1477  
.    .    .    .LEGACYS GOLD DUST RAIDER,Y,M   2134/2135  
.    .    .    .    .GOLDUSTS DOVE SONG,Y,F   2133/2141  
.    .    .    .LIBERTYS TEXAS SUNSHINE, ,F   2134/2142  
.    .    .    .    .GOLDUSTS DOVE SONG,Y,F   2133/2141  
BRIARY BRACKEN,Y,M   14/37    
.    .CHILBROOK HURRICANE HEATHER,B,F   57/941   
.    .    .CHILBROOK BRANNIGAN,Y,M   14/36    
.    .    .    .BOWMANS LUCKY CHARM,B,F   1036/2461  
.    .    .    .    .CHILBROOK FAIRYSTONE, ,F   2459/2460  
.    .    .CHILBROOK PROPHECY,B,M   935/36    
.    .    .    .CHILBROOK FAIRYSTONE, ,F   2459/2460  
.    .    .    .    .CHILBROOK KIMBERLITE, ,F   357/829   
.    .    .    .    .CHILBROOK ROCKAFELLA,B,F   357/829   
.    .    .CHILBROOK SOLO SABRINA,B,F   38/36    
.    .    .    .CHILBROOK AMANDA,B,F   38/39    
.    .    .    .    .OSAGELM OAKDALE TIZZIE,B,F   1786/1075  
.    .    .    .SPIRITWOODS DEJA VU CAITLIN, ,F   235/39    
.    .    .    .    .DEJA VU'S SPIRIT OF THE QUEST,B,F   122/399   
.    .DICKENDALLS ROSE ROYCE,B,F   57/429   
.    .    .DICKENDALLS A-HA,B,F   219/426   
.    .    .    .DICKENDALL A-HOY,B,M   423/424   
.    .    .    .    .SUMOS AHOY ALL DECKED OUT, ,F   422/3539  
.    .    .    .    .TERACROFTS STRIKIN GOLD,Y,F   422/1949  
.    .    .    .DICKENDALL ARNOLD,B,M   440/424   
.    .    .    .    .BANNERS DREAMBOAT,B,F   439/2332  
.    .    .    .    .BLACKWING BRAMBLE,B,F   439/2995  
.    .    .    .    .BUCKSTONE REVEILLE, ,F   439/425   
.    .    .    .    .DICKENDALL CUTTLE UP,B,F   439/3587  
.    .    .    .    .DICKENDALL DAVARON ANSLO,B,F   439/3337  
.    .    .    .    .DICKENDALL DAVARON ARGYLE,B,F   439/3337  
.    .    .    .    .DICKENDALLS DAVARON GABLE,B,F   439/3782  
.    .    .    .    .HAWKSMOOR WEBSTER,B,F   439/3242  
.    .    .    .    .HYSPIRE SOMETHING'S AMISS,B,F   439/3808  
.    .    .    .    .KAI DENS FLASHBACK,B,F   439/1738  
.    .    .    .    .LINRAYS FARR AND ABOVE,B,F   439/2270  
.    .    .    .    .LINRAYS GO FARR IT,B,F   439/2270  
.    .    .    .    .LINRAYS OVERDRAWN,B,F   439/413   
.    .    .    .    .LOBUFFS ESPRIT DE CORPS,B,F   439/3361  
.    .    .    .    .MUSKELUNGES CHRISTMAS ANGEL,B,F   439/2349  
.    .    .    .    .MUSKELUNGES SOLO FLIGHT,B,F   439/2349  
.    .    .    .    .NIRVANAS JUST ONE LOOK,B,F   439/3025  
.    .    .    .    .NIRVANAS MADE OF HONOR,B,F   439/3025  
.    .    .    .    .NIRVANAS MASSEUSE,B,F   439/3025  
.    .    .    .    .PETTYS CLEOPATRA, ,F   439/3664  
.    .    .    .    .RICKWAY BRAEMAN BLACK ICE, ,F   439/3437  
.    .    .    .    .SECOND SIGHT BRUNHILDA, ,F   439/3434  
.    .    .    .    .SNOWDEN HILLS EBENEZER,B,F   439/2814  
.    .    .    .    .SUNSET SHENANIGANS, ,F   439/3632  
.    .    .    .    .SUNSPOTS HIS MAJESTY,B,F   439/2544  
.    .    .    .    .TABATHA GRAEMOOR DINAH,B,F   439/436   
.    .    .    .    .TABATHAS DAZZLE,B,F   439/436   
.    .    .    .    .TABATHAS DELECTABLE,B,F   439/436   
.    .    .    .    .TABATHAS DRIFTER AT DICKENDALL,B,F   439/436   
.    .    .    .    .TABATHAS EBONETTA,B,F   439/3751  
.    .    .    .    .TABATHAS RACHEL, ,F   439/1734  
.    .    .    .    .TABATHAS ROLLICK AT CAROWBY, ,F   439/2621  
.    .    .    .    .VISIONS STATE OF THE ART,B,F   439/2541  
.    .    .    .    .WINDFALLS  HIGHLANDER, ,F   439/3010  
.    .    .    .    .WINDFALLS BLACK PIPER,B,F   439/2424  
.    .    .    .    .WINDFALLS SCOTCH THISTLE,B,F   439/2424  
.    .    .ROCKY ACRES BIT OF LACE,Y,F   219/426   
.    .    .    .ROCKY ACRES SCHEHERAZADE,Y,F   1972/1921  
BRIARY BRENDAN OF RAINELL,B,M   14/37    
.    .BRIARGLENS BONNIE OF GLENCOE,B,F   35/1934  
.    .    .BRIARGLENS PAISLEY TAIN,Y,F   1935/1933  
.    .    .    .BLUMOON SORCHA OBRIARGLEN, ,F   2326/1932  
.    .    .    .    .BLUMOON MICAILA DRFTR OSORCHA, ,F   435/3551  
.    .    .    .BRIARGLENS MAGICAL MOMENT, ,F   623/1932  
.    .    .    .    .BRIARGLENS FAMOUS FINNISH,B,F   517/1931  
.    .    .    .VAUGHNS KERRY BRIARGLEN, ,F   2192/1932  
.    .    .    .    .BLUMOON DUBH KEEGAN OKERRY, ,F   2184/2183  
.    .    .    .    .BLUMOON DUBH TARRANT O'KERRY,B,F   2184/2183  
.    .FINCHINGFIELD FAITH,Y,F   35/1413  
.    .    .FINCHINGFIELD CAPRICIOUS, ,F   344/1433  
.    .    .    .WENWOODS BANNER RUBY BEGONIA, ,F   2198/2199  
.    .    .    .    .BANNERS WENWOOD OBLEO ARROW, ,F   427/2196  
.    .    .FINCHINGFIELD CELTIC CAPER,B,M   344/1433  
.    .    .    .DANICKS BLACK MAGIC II,B,M   1432/3001  
.    .    .FINCHINGFIELD MIGHTY CASEY,B,M   344/1433  
.    .    .    .VAUGHNS KERRY BRIARGLEN, ,F   2192/1932  
.    .    .    .    .BLUMOON DUBH KEEGAN OKERRY, ,F   2184/2183  
.    .    .    .    .BLUMOON DUBH TARRANT O'KERRY,B,F   2184/2183  
.    .FINCHINGFIELD FANTASIA, ,F   35/1413  
.    .    .NORTHWOODS SANDMAN,Y,M   450/1412  
.    .    .    .CEDARWOOD STANDING OVATION, ,F   891/2185  
.    .    .    .    .CEDARWOOD LAB-ARK FANFARE, ,F   560/2312  
.    .    .    .LOBUFFS SUNDOWN AT KERRYMARK, ,F   891/1414  
.    .    .    .    .KERRYMARK BALLAD AT CORHAMPTON,Y,F   1972/2033  
.    .    .    .    .LOBUFFS COCONUT CUSTARD,Y,F   1845/2033  
.    .    .    .SECOND SIGHT ONYX,B,F   891/1849  
.    .    .    .    .SECOND SIGHT BRANDIE,B,F   1847/1848  
.    .FINCHINGFIELD INDIGO,B,F   35/1413  
.    .    .RAINELLS DYNASTY,B,M   344/2193  
.    .    .    .BREEZYS CYCLONE,Y,M   1935/2658  
.    .    .    .    .VISIONS BLUSH OF HYGATE, ,F   2657/1600  
.    .    .    .BRIARGLENS PAISLEY TAIN,Y,F   1935/1933  
.    .    .    .    .BLUMOON SORCHA OBRIARGLEN, ,F   2326/1932  
.    .    .    .    .BRIARGLENS MAGICAL MOMENT, ,F   623/1932  
.    .    .    .    .VAUGHNS KERRY BRIARGLEN, ,F   2192/1932  
.    .    .    .BUTTONW OOD PEPITA, ,F   1935/3738  
.    .    .    .    .BUTTONWOOD VICTOR,B,F   435/3737  
.    .    .    .STONECREST STAR OF INDIA,B,F   1935/2660  
.    .    .    .    .STONECRESTS POLARIS,B,F   3735/2656  
.    .FINCHINGFIELD IVAN OF OAKLEA,Y,M   35/1413  
.    .    .COUNTRYSIDE TANTARA TILLE, ,F   3645/3635  
.    .    .    .LUBBERLINE COUNTRYSIDE SKIP,Y,M   3634/3644  
.    .REBEDEX DARWIN,Y,M   35/381   
.    .    .SAILINS SADIE SADIE,Y,F   375/376   
.    .    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
.    .    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
.    .WINDSONGS BRIARY BRIMSTONE,Y,M   35/1485  
.    .WINDSONGS MORNING MIST, ,F   35/1485  
.    .    .WINDSONGS JEZABELL, ,F   1063/1484  
.    .    .    .HYWINDS BEST BET OF WINDSONG,B,F   1479/1483  
BRIARY BROCADE, ,F   14/236   
.    .BRIARY MAEVE, ,F   1486/638   
.    .    .WINDSONGS BRIARY BRIMSTONE,Y,M   35/1485  
.    .    .WINDSONGS MORNING MIST, ,F   35/1485  
.    .    .    .WINDSONGS JEZABELL, ,F   1063/1484  
.    .    .    .    .HYWINDS BEST BET OF WINDSONG,B,F   1479/1483  
.    .FLAXENFIELDS SHANGHAI LIL, ,F   636/638   
.    .    .DAYLIGHTS BLACKTHORN SHEENA,B,F   128/631   
.    .    .    .DAYLIGHTS MIDNIGHT RAIDER,B,M   625/626   
.    .    .    .    .BLACKWING BLUFFDALE MEMPHIS,B,F   623/624   
.    .    .    .    .BRIARGLENS MAGICAL MOMENT, ,F   623/1932  
BRIARY FLORADORA,Y,F   14/388   
.    .BRIARY ABBEY ROAD,Y,F   377/378   
.    .    .ELYSIUMS CITIZEN KANE, ,M   14/373   
.    .    .    .BORADORS DANNY BOY,B,M   235/2363  
.    .    .    .BORADORS THE GOBLIN,Y,M   235/2365  
.    .    .    .    .BORADORS SWEET CHARITY,Y,F   2364/2363  
.    .    .    .GOLDEN SUN OF  WIGTON,Y,M   235/3045  
.    .    .    .MUSKELUNGES TARA,B,F   235/2353  
.    .    .    .    .MUSKELUNGES LISAS LADY, ,F   2352/2351  
.    .    .    .SPIRITWOODS DEJA VU CAITLIN, ,F   235/39    
.    .    .    .    .DEJA VU'S SPIRIT OF THE QUEST,B,F   122/399   
.    .    .    .VALLEYWOOD CROW HAVEN FIDDLE,Y,F   235/745   
.    .    .    .    .VALLEYWOOD NIGHTHAWK,B,F   219/743   
.    .    .ELYSIUMS SAILIN CAT BALLOU,Y,F   14/373   
.    .    .    .SAILIN CAJUNS CASANOVA,B,M   128/368   
.    .    .    .    .BLACKTHORN IVY, ,F   2313/2564  
.    .    .    .    .BLACKTHORN SIMPLY IRRESISTIBLE,Y,F   2313/2564  
.    .    .    .    .CEDARWOODS INDEPENDENCE,Y,F   2313/2310  
.    .    .    .    .FAWNHAVEN KIVA DWELLER, ,F   2313/2561  
.    .    .    .SAILIN MURF EASE LAW OF ARAGON,Y,M   367/368   
.    .    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
.    .    .    .SAILINS CEDARWOOD PRIDE,B,F   128/368   
.    .    .    .    .CEDARWOOD STANDING OVATION, ,F   891/2185  
.    .    .    .    .CEDARWOODS MASTER GUNNER,Y,F   706/2185  
.    .    .    .SAILINS COURT JESTER,Y,M   1584/368   
.    .    .    .    .SAILINS BUTTERFIELD CHATEAU,B,F   2632/2634  
.    .    .    .    .SAILINS HYGATE HY ROLLER,Y,F   2632/2639  
.    .    .    .SAILINS JOLLY ROGER,B,M   374/368   
.    .    .    .    .SAILINS GOLD DOUBLOON,Y,F   371/372   
.    .    .    .SAILINS ME BALLOU TOO,Y,F   367/368   
.    .    .    .    .SAILINS PROUD DEMENSIONS, ,F   9/2642  
.    .    .    .SAILINS SCHOONER,Y,M   374/368   
.    .    .    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
.    .    .SPRINGFIELDS CALAMITY JANE,Y,F   3648/373   
.    .    .    .INSELHEIM TANTARA FANTAIL,Y,F   3649/3647  
.    .    .    .    .LUBBERLINE JACKSTAY, ,F   696/3646  
.    .BRIARY ALLEGRA, ,F   377/378   
.    .    .BRIARY BROCADE, ,F   14/236   
.    .    .    .BRIARY MAEVE, ,F   1486/638   
.    .    .    .    .WINDSONGS BRIARY BRIMSTONE,Y,F   35/1485  
.    .    .    .    .WINDSONGS MORNING MIST, ,F   35/1485  
.    .    .    .FLAXENFIELDS SHANGHAI LIL, ,F   636/638   
.    .    .    .    .DAYLIGHTS BLACKTHORN SHEENA,B,F   128/631   
BRIARY TRACE OF BRIAN, ,M   14/37    
.    .BROYHILL AUGUSTUS, ,M   2713/2714  
.    .    .WINGMASTERS BROYHILL NOELL,Y,F   2711/2633  
.    .    .    .BOLD AARON,Y,M   230/2644  
.    .    .    .    .HYGATE GINGER,Y,F   2643/2640  
.    .    .    .    .PROSPECTS FIRE AND REIGN, ,F   2643/2804  
BRUDSTUDS BARBAREE,Y,F   14/383   
.    .REBEDEX DARWIN,Y,M   35/381   
.    .    .SAILINS SADIE SADIE,Y,F   375/376   
.    .    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
.    .    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
CAMPBELLCROFTS ANGUS,B,M   14/3556  
.    .BRETON GATE CAIRNGORM, ,F   3554/3555  
.    .    .CAMPBELLCROFTS BANKS,B,M   1458/3553  
.    .    .    .BLUMOON BANKIN ON BRETTA OKEE,B,F   3552/3559  
.    .    .    .    .BLUMOONS KEEPSAKE SMOKIN GUN,Y,F   3549/3548  
.    .BRETON GATE SCOTIA NOVA, ,F   3554/3555  
.    .    .BRETON GATE SWEET CREM, ,F   128/3744  
.    .    .    .BROOKS TEA TIME AT FOX HILL, ,F   3742/3743  
.    .    .    .    .FOX HILLS AVALANCHE,B,F   2839/3736  
CHILBROOK BRANNIGAN,Y,M   14/36    
.    .BOWMANS LUCKY CHARM,B,F   1036/2461  
.    .    .CHILBROOK FAIRYSTONE, ,F   2459/2460  
.    .    .    .CHILBROOK KIMBERLITE, ,F   357/829   
.    .    .    .    .BELQUESTS FRIENDLY PERSUASION, ,F   121/2324  
.    .    .    .CHILBROOK ROCKAFELLA,B,M   357/829   
ELYSIUMS CITIZEN KANE, ,M   14/373   
.    .BORADORS DANNY BOY,B,M   235/2363  
.    .BORADORS THE GOBLIN,Y,M   235/2365  
.    .    .BORADORS SWEET CHARITY,Y,F   2364/2363  
.    .    .    .BORADORS SWEET AUTUMN MIST,Y,F   1598/2362  
.    .    .    .    .DEER RUNS SWEET CARAMEL CREAM, ,F   756/2361  
.    .    .    .    .DEER RUNS WHITEHORN MIST,Y,F   2354/2361  
.    .GOLDEN SUN OF  WIGTON,Y,M   235/3045  
.    .MUSKELUNGES TARA,B,F   235/2353  
.    .    .MUSKELUNGES LISAS LADY, ,F   2352/2351  
.    .    .    .MUSKELUNGES GUNAGO TIGRES,Y,F   2334/2350  
.    .    .    .    .TABATHAS EBONETTA,B,F   439/3751  
.    .    .    .MUSKELUNGES TIGER LILY,Y,F   2334/2350  
.    .    .    .    .MUSKELUNGES CHRISTMAS ANGEL,B,F   439/2349  
.    .    .    .    .MUSKELUNGES SOLO FLIGHT,B,F   439/2349  
.    .    .    .    .ROZZAYS PRIMROSE PROMISE, ,F   403/2349  
.    .SPIRITWOODS DEJA VU CAITLIN, ,F   235/39    
.    .    .DEJA VU'S SPIRIT OF THE QUEST,B,M   122/399   
.    .VALLEYWOOD CROW HAVEN FIDDLE,Y,F   235/745   
.    .    .VALLEYWOOD NIGHTHAWK,B,M   219/743   
.    .    .    .BOROWICK CEDAR HILL FANFARE, ,F   741/1968  
.    .    .    .    .ACREWOODS DUE ME JUSTICE,Y,F   2/2316  
.    .    .    .BOROWICK CEDAR HILL NIGHTCAP, ,M   741/1968  
.    .    .    .    .BOROWICKS QUEST,Y,F   1966/1967  
.    .    .    .GALILEO BRIGHTONSTAR WARIOR,B,M   741/2812  
.    .    .    .PROSPECTS BROOKLAND HAWKEYE,Y,M   741/2803  
.    .    .    .SEABROOKS REGATTA,Y,M   741/744   
ELYSIUMS SAILIN CAT BALLOU,Y,F   14/373   
.    .SAILIN CAJUNS CASANOVA,B,M   128/368   
.    .    .BLACKTHORN IVY, ,F   2313/2564  
.    .    .    .GALILEO BRIGHTONSTAR WARIOR,B,M   741/2812  
.    .    .BLACKTHORN SIMPLY IRRESISTIBLE,Y,F   2313/2564  
.    .    .    .GHOSTONES LOUIE DOWNTOWN, ,M   3439/3445  
.    .    .    .    .BELLES MOONRIVER,Y,F   3417/3418  
.    .    .    .    .GRAYCROFTS DISTANT VISIONS,Y,F   3417/3447  
.    .    .    .    .GRAYCROFTS HOPEFUL JOURNEY,Y,F   3417/3440  
.    .    .CEDARWOODS INDEPENDENCE,Y,F   2313/2310  
.    .    .FAWNHAVEN KIVA DWELLER, ,M   2313/2561  
.    .    .    .FAWNHAVEN EAGLE OVER CHAR DON,C,M   2560/2563  
.    .    .    .    .TWIGS INDIANA BOOMARANG,B,F   2559/3469  
.    .    .    .FAWNHAVEN YANKEE PEDDLER,B,M   2560/3678  
.    .    .    .    .SOONER OR LATER XIII,B,F   3677/3673  
.    .SAILIN MURF EASE LAW OF ARAGON,Y,M   367/368   
.    .    .ARAGONS LADY TOVA,Y,F   365/366   
.    .SAILINS CEDARWOOD PRIDE,B,F   128/368   
.    .    .CEDARWOOD STANDING OVATION, ,F   891/2185  
.    .    .    .CEDARWOOD LAB-ARK FANFARE, ,F   560/2312  
.    .    .    .    .CEDARWOODS TOYNTON SERENADE, ,F   706/2311  
.    .    .CEDARWOODS MASTER GUNNER,Y,M   706/2185  
.    .    .    .BLUMOON DUBH KEEGAN OKERRY, ,F   2184/2183  
.    .    .    .    .BLUMOON BANKIN ON BRETTA OKEE,B,F   3552/3559  
.    .    .    .BLUMOON DUBH TARRANT O'KERRY,B,M   2184/2183  
.    .    .    .    .BLUMOON FINN BANNING OTARMIC,Y,F   2182/3550  
.    .SAILINS COURT JESTER,Y,M   1584/368   
.    .    .SAILINS BUTTERFIELD CHATEAU,B,F   2632/2634  
.    .    .    .SAILIN SHATEAUX GRETCHEN, ,F   2641/2635  
.    .    .    .    .SAILINS BRAHMA JACK,B,F   2638/2636  
.    .    .SAILINS HYGATE HY ROLLER,Y,M   2632/2639  
.    .    .    .SAILINS BRAHMA JACK,B,M   2638/2636  
.    .SAILINS JOLLY ROGER,B,M   374/368   
.    .    .SAILINS GOLD DOUBLOON,Y,M   371/372   
.    .    .    .SAILIN MURF EASE LAW OF ARAGON,Y,M   367/368   
.    .    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
.    .    .    .SAILINS ME BALLOU TOO,Y,F   367/368   
.    .    .    .    .SAILINS PROUD DEMENSIONS, ,F   9/2642  
.    .SAILINS ME BALLOU TOO,Y,F   367/368   
.    .    .SAILINS PROUD DEMENSIONS, ,M   9/2642  
.    .    .    .SAILIN SHATEAUX GRETCHEN, ,F   2641/2635  
.    .    .    .    .SAILINS BRAHMA JACK,B,F   2638/2636  
.    .SAILINS SCHOONER,Y,M   374/368   
.    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
.    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
JASERIES TASMA, ,F   14/895   
.    .JASERIES GOLD HILL THUNDER,Y,M   230/880   
.    .    .LUCKY FOUR FINNIGAN O RIAGAIN,Y,M   875/876   
.    .    .    .COBBS YELLOW FRENZY,Y,F   874/904   
.    .    .    .    .CHELONS SLEEPLESS KNIGHT,B,F   128/873   
JASERIES TASMA OBRIAN, ,F   14/895   
.    .JASERIES KING TUT,B,M   2747/2746  
RAVENWOOD BRIGADIER,B,M   14/991   
ROSES EASTERN STAR,B,M   14/389   
.    .STARS SAILERMAN OF SEASAC,B,M   379/380   
.    .    .DANCING CHANTILLY O'SAILIN,Y,F   374/384   
.    .    .    .SAILINS GOLD DOUBLOON,Y,M   371/372   
.    .    .    .    .SAILIN MURF EASE LAW OF ARAGON,Y,F   367/368   
.    .    .    .    .SAILINS ME BALLOU TOO,Y,F   367/368   
.    .    .SAILINS JOLLY ROGER,B,M   374/368   
.    .    .    .SAILINS GOLD DOUBLOON,Y,M   371/372   
.    .    .    .    .SAILIN MURF EASE LAW OF ARAGON,Y,F   367/368   
.    .    .    .    .SAILINS ME BALLOU TOO,Y,F   367/368   
.    .    .SAILINS SCHOONER,Y,M   374/368   
.    .    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
.    .    .    .    .ARAGONS LADY TOVA,Y,F   365/366   
.    .    .SAILINS WILY WIND SONG,B,F   374/382   
.    .    .    .SAILINS SADIE SADIE,Y,F   375/376   
.    .    .    .    .SAILINS FIVE STAR JENN E RAL,Y,F   369/370   
SAM DUKE OF RANDALL, ,M   14/388   
.    .BRIARY BELL BUOY OF WINDSONG, ,M   1487/963   
.    .    .WINDSONGS JEZABELL, ,F   1063/1484  
.    .    .    .HYWINDS BEST BET OF WINDSONG,B,F   1479/1483  
SPRINGFIELDS NATIVE FANCY,B,F   14/13    
.    .BEAUTAWNS BRANDY ON THE ROCK,Y,F   350/5     
.    .    .BEAUTAWNS IMPORTER,Y,F   353/349   
.    .    .    .BELQUEST WORTH THE RISK,B,F   336/348   
.    .    .BEAUTAWNS INSIDE INFORMATION,Y,M   353/349   
.    .BEAUTAWNS CAPT.DIGGORITY,B,M   4/5     
.    .    .ACREWOODS DUE ME JUSTICE,Y,M   2/2316  
.    .    .ASHWAYS DEAL ME IN BELQUEST,B,F   2/134   
.    .    .    .BELQUESTS ABBY OF KEEPSAKE,B,F   78/135   
.    .    .BELQUESTS CAVALIER,B,M   2/3     
.    .    .    .KEEPSAKES MAGGIE MAE,Y,F   1/34    
TAGALONGS CONGENIALITY, ,F   14/2058  
.    .ANDERSCROFT STALAYNA SIOUX, ,M   815/2054  
.    .    .ANDERSCROFT NUTMEGGER,C,F   446/2046  
.    .    .    .ANDERSCROFT BROWN SUGAR,C,F   2045/2044  
.    .    .    .    .CACAOS CHIEF MINI-WILLEY,C,F   2036/2037  
.    .    .MIJANS CORRIGAN, ,M   446/447   
.    .    .    .DRIFTWOODS LIMITED EDITION, ,F   445/448   
.    .    .    .    .DRIFTWOODS CELEBRATION, ,F   450/444   
.    .    .    .LOCKERBIE MIJANS BRITTANNIA,Y,F   445/753   
.    .    .    .    .ANDERSCROFT MIJANS BRAVO,B,F   344/752   
.    .    .    .    .MIJANS ALL THAT JAZZ, ,F   344/752   
.    .    .MIJANS FRISKET,B,F   446/447   
WILDWINGS MCDUFF, ,M   14/191   
.    .ELYODS MACBETH OF CANTERBURY,Y,M   2490/2491  
.    .    .ELDENS DUKE OF EBONYLANE, ,M   2129/2130  
.    .    .    .EBONYLANES COTTON CANDY, ,F   2124/2125  
.    .    .    .    .EBONYLANES BUCCANEER GOLD,Y,F   887/2122  
.    .    .    .    .TULIPWOOD GO ON GREEN,Y,F   1427/2122  
.    .TANGLEWOOD SASSY CELINA,B,F   2490/3039  
.    .    .CC'S BLACK VELVET,B,F   75/3038  
.    .    .    .CHARCARS VELVET SHASTA,B,F   75/71    
.    .    .    .    .GOLDUSTS NAUGHTY NICK,Y,F   68/69    

melkhior's avatar

I don't only show the coin's name, I also show some more stats, and more importantly, 2 images of that coin, so doing it in text is kind of impossible.

But I might do a render of it and make an hourly or so PDF with the page.

Also that snippet is a little long :p

jlrdw's avatar

Then where is the N level hierarchy coming from, can't you just paginate one coin at a time? Or paginated table with a more info button

melkhior's avatar

categories table:

  • id
  • name
  • category_id (if null = root category, otherwise subcategory)

And coins has a category_id column.

Right now I run loop of all root categories, in which I run a loop to show it's coins and show all it's subcategories, which then also shows it's coins and subcategories, and so on.

jlrdw's avatar

Put down some actual example, made up coins ok, I am trying to picture what would be in sub cat.. You said N level hierarchy is it N or just cats and sub cats, a lot of difference here. I meant sub sub

melkhior's avatar

Here's a part of the page: https://i.clouds.tf/9f0z/o59k.png

There's currently only categories and subcategories added but there can be infinite subcategories to categories etc, so it is N level hierarchy.

Ignore the pagination at the top, at the moment it just separates root categories.

jlrdw's avatar

Ok, can't you just paginate cats, user can click to view more in that cat. just paginate only what's being viewed. Example if POST. Paginate post, user sees post to view, bring that up, now that's paginated, like this very forum.

melkhior's avatar

I do have another page like that, but as I said, this page needs to be printed, so the least clicks possible, only reason I'm paginating this is to save load time from the insane amount of images loaded.

jlrdw's avatar

That where you can export to pdf if that's what would work. Hard to print the paginated, get jumboled, pdf nice / clean. Sorry I meant print to pdf.

melkhior's avatar

Yeah I might go the PDF route if the person using it agrees it to it, otherwise I guess I'll just have to live with the load times.

Please or to participate in this conversation.