TYPO3 Formidable - PasteBin

Ajax Pager

Permalink to this snippet:

http://formidable.typo3.ug/pastebin/snippet/107.html

The authors comment:

The default LISTER pager is not AJAX friendly. Here's a simply way of overriding it with an AJAX pager. My code creates the paging element as a LISTBOX of pages. If someone can figure out how to create a set of page links, I'd like to see it!

Also, this code requires an extra SQL call to count rows. If someone has any improvements, please submit to the mailing list.

Gary Wong, 2009-08-21@17:22:41, pasted:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<formidable version="1.0.0">

<datasources>
			<datasource:DB name="pages">
				<sql>
					<userobj>
						<php><![CDATA[
							// Set rows per page in a sandbox var:
							$this->oSandBox->sb_perpage = 10;
							
							// Our original query:
							$sql="SELECT uid, title, tstamp, crdate from pages WHERE pid > 0 AND doktype=1 AND deleted=0 and hidden=0 ORDER BY uid";
							
							// Our count query - we have to count the
							$sqlcnt="SELECT COUNT(*) from pages WHERE pid > 0 AND doktype=1 AND deleted=0 and hidden=0";
							// We have to get the # of rows to calculate the # of pages and store it in the sandbox.
							// Since we are overriding the pager, we have to find numrows ourselves.
							$res = $GLOBALS['TYPO3_DB']->sql_query($sqlcnt);
							$row = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
							$this->oSandBox->sb_numrows = $row[0];
							if ($row[0]>0)
								$this->oSandBox->sb_numpages = ceil($row[0] / $this->oSandBox->sb_perpage);
							else
								$this->oSandBox->sb_numpages = 0;
								
							return $sql;
							]]>
						</php>
					</userobj>
				</sql>
				<beforeSqlExec>
					<userobj>
						<php><![CDATA[
							$info = func_get_arg(1);
							$page = $this->oSandBox->sb_page ? $this->oSandBox->sb_page : 0;
							$page = $page * $this->oSandBox->sb_perpage;
							// This is the generated SQL:
							$sql = $info['sql'];
							// Pager set at unlimited, Formidable adds a default LIMIT which we
							// have to override. There ars smarter ways of doing the following, of course...
							$sql = str_replace('LIMIT 0, 1000000',"LIMIT $page, ".$this->oSandBox->sb_perpage,$sql);
							return ($sql);
							]]>
						</php>
               		</userobj>
				</beforeSqlExec>				
			</datasource:DB>
		</datasources>
		<sandbox>
			<userobj>
				<php><![CDATA[/*<?*/
					var $sb_page;
					var $sb_numrows;
					var $sb_numpages;
				/*?>*/]]></php>
			</userobj>
		</sandbox>

</control>

<renderlet:BOX name="list-box" mode="div">
			<childs>
				<renderlet:BOX name="lister-container">
					<childs>
						<renderlet:LISTER name="mylist" cachehash="true">

<datasource use="pages" />
							<columns>
								<column name="uid" type="TEXT" listHeader="UID" />
								<column name="title" type="TEXT" listHeader="Page title" />
							</columns>
							<pager>
								<rows>
									<perpage>-1</perpage>
								</rows>
							</pager>
						</renderlet:LISTER>
					</childs>
				</renderlet:BOX>	
				<renderlet:LISTBOX label="" name="pagebox">
					<wrap>Page: |</wrap>
					<data defaultvalue="">
						<userobj>
							<php><![CDATA[
								$data = array();
								for ($i=1;$i<=$this->oSandBox->sb_numpages;$i++) {
									$data[]=array("value"=>$i-1,"caption"=>$i);
								}
								return $data;
							]]></php>
						</userobj>
					</data>
					<onchange runat="ajax" cache="false" params="list-box.pagebox">
						<userobj>
							<php><![CDATA[
							   $this->oSandBox->sb_page=$this->oMajixEvent->getParam("list-box.pagebox");
							   return $this->aORenderlets["list-box"]->aChilds["lister-container"]->majixRepaint();
							]]></php>
						</userobj>
					</onchange>

</renderlet:LISTBOX>
			</childs>
		</renderlet:BOX>	
	</elements>

</formidable>

Ajax Pager

Download

Features

Documentation

Many thanks to

Latest snippets