HTML code for sharing admin

HTML Copy To Clipboarddone!

<div class="highlight" style="background: #f8f8f8"><pre style="line-height: 125%"><div id="lc1"><span style="color: #666666">&lt;?</span>php
</div><div id="lc2">
</div><div id="lc3">
</div><div id="lc4"><span style="color: #408080; font-style: italic">//include    &#39;../../config.inc.php&#39;;</span>
</div><div id="lc5"><span style="color: #408080; font-style: italic">//include ABS_PATH.&#39;core/init.inc.php&#39;;</span>
</div><div id="lc6"><span style="color: #408080; font-style: italic">//require_once(&#39;table_builder.php&#39;);</span>
</div><div id="lc7">
</div><div id="lc8"><span style="color: #008000; font-weight: bold">class</span> <span style="color: #0000FF; font-weight: bold">admin_table</span>{
</div><div id="lc9">	<span style="color: #008000; font-weight: bold">public</span> <span style="color: #19177C">$table</span>;
</div><div id="lc10">	<span style="color: #008000; font-weight: bold">public</span> <span style="color: #19177C">$items</span>;
</div><div id="lc11">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$img_path</span>;
</div><div id="lc12">
</div><div id="lc13">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$cols</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">array</span>();
</div><div id="lc14"><span style="color: #408080; font-style: italic">//    private $first_r=array();</span>
</div><div id="lc15">
</div><div id="lc16">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$table_name</span>;
</div><div id="lc17">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$key_col</span>;
</div><div id="lc18">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$items_per_page</span>;
</div><div id="lc19">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$form</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">false</span>;
</div><div id="lc20">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$order_default</span>;
</div><div id="lc21">
</div><div id="lc22">
</div><div id="lc23">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$order</span>;
</div><div id="lc24">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$page</span>;
</div><div id="lc25">    <span style="color: #008000; font-weight: bold">private</span> <span style="color: #19177C">$link</span>;
</div><div id="lc26">
</div><div id="lc27">
</div><div id="lc28">	<span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">__construct</span>(<span style="color: #19177C">$tags</span><span style="color: #666666">=</span><span style="color: #BA2121">&#39;&#39;</span>){
</div><div id="lc29">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">new</span> table_builder(<span style="color: #19177C">$tags</span>);
</div><div id="lc30">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">img_path</span><span style="color: #666666">=</span>ABS_PATH<span style="color: #666666">.</span><span style="color: #BA2121">&#39;images/admin/&#39;</span>;
</div><div id="lc31">	}
</div><div id="lc32">
</div><div id="lc33">
</div><div id="lc34">
</div><div id="lc35">
</div><div id="lc36"><span style="color: #408080; font-style: italic">/*prepare*/</span>
</div><div id="lc37">
</div><div id="lc38">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">set_link</span>(<span style="color: #19177C">$link</span>){
</div><div id="lc39">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">link</span><span style="color: #666666">=</span><span style="color: #19177C">$link</span>;
</div><div id="lc40">    }
</div><div id="lc41">
</div><div id="lc42">
</div><div id="lc43">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">set_table_name</span>(<span style="color: #19177C">$table</span>){
</div><div id="lc44">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table_name</span><span style="color: #666666">=</span><span style="color: #19177C">$table</span>;
</div><div id="lc45">    }
</div><div id="lc46">
</div><div id="lc47">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">set_key_col</span>(<span style="color: #19177C">$key_col</span>){
</div><div id="lc48">    	<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">key_col</span><span style="color: #666666">=</span><span style="color: #19177C">$key_col</span>;
</div><div id="lc49">    }
</div><div id="lc50">
</div><div id="lc51">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">set_items_per_page</span>(<span style="color: #19177C">$items</span>){
</div><div id="lc52">    	<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items_per_page</span><span style="color: #666666">=</span><span style="color: #19177C">$items</span>;
</div><div id="lc53">    }
</div><div id="lc54">
</div><div id="lc55">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">set_order_default</span>(<span style="color: #19177C">$field</span>){
</div><div id="lc56">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">order_default</span><span style="color: #666666">=</span><span style="color: #19177C">$field</span>;
</div><div id="lc57">    }
</div><div id="lc58">
</div><div id="lc59">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">add_col</span>(<span style="color: #19177C">$name</span>,<span style="color: #19177C">$arr</span>){
</div><div id="lc60">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$name</span>]<span style="color: #666666">=</span><span style="color: #19177C">$arr</span>;
</div><div id="lc61">    }
</div><div id="lc62">
</div><div id="lc63">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">use_form</span>(<span style="color: #19177C">$method</span><span style="color: #666666">=</span><span style="color: #BA2121">&#39;post&#39;</span>){
</div><div id="lc64">    	<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">form</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">new</span> form_builder(<span style="color: #BA2121">&#39;&#39;</span>,<span style="color: #19177C">$method</span>);
</div><div id="lc65">
</div><div id="lc66">    }
</div><div id="lc67">
</div><div id="lc68">
</div><div id="lc69">
</div><div id="lc70">
</div><div id="lc71"><span style="color: #408080; font-style: italic">/*process*/</span>
</div><div id="lc72">
</div><div id="lc73">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">process</span>(){
</div><div id="lc74">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #666666">!</span><span style="color: #19177C">$page</span><span style="color: #666666">=</span>get_var(<span style="color: #BA2121">&#39;page&#39;</span>,<span style="color: #19177C">$_GET</span>,<span style="color: #BA2121">&#39;i&#39;</span>))
</div><div id="lc75">          <span style="color: #19177C">$page</span><span style="color: #666666">=1</span>;
</div><div id="lc76">
</div><div id="lc77">
</div><div id="lc78">
</div><div id="lc79">        <span style="color: #19177C">$order</span><span style="color: #666666">=</span>get_var(<span style="color: #BA2121">&#39;order&#39;</span>,<span style="color: #19177C">$_GET</span>);
</div><div id="lc80">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #19177C">$order</span>){
</div><div id="lc81">          <span style="color: #408080; font-style: italic">//проверим что ордер это один из стобцов по которому мы можем сортировать</span>
</div><div id="lc82">
</div><div id="lc83">          <span style="color: #19177C">$tmp</span><span style="color: #666666">=</span><span style="color: #008000">isset</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$order</span>])               <span style="color: #666666">&amp;&amp;</span>
</div><div id="lc84">               <span style="color: #008000">isset</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$order</span>][<span style="color: #BA2121">&#39;in_table&#39;</span>])   <span style="color: #666666">&amp;&amp;</span>
</div><div id="lc85">                     <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$order</span>][<span style="color: #BA2121">&#39;in_table&#39;</span>]    <span style="color: #666666">&amp;&amp;</span>
</div><div id="lc86">               <span style="color: #008000">isset</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$order</span>][<span style="color: #BA2121">&#39;is_ordered&#39;</span>]) <span style="color: #666666">&amp;&amp;</span>
</div><div id="lc87">                     <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>[<span style="color: #19177C">$order</span>][<span style="color: #BA2121">&#39;is_ordered&#39;</span>];
</div><div id="lc88">
</div><div id="lc89">          <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #666666">!</span><span style="color: #19177C">$tmp</span>) <span style="color: #19177C">$order</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">false</span>;
</div><div id="lc90">        }
</div><div id="lc91">
</div><div id="lc92">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #666666">!</span><span style="color: #19177C">$order</span>)
</div><div id="lc93">            <span style="color: #19177C">$order</span><span style="color: #666666">=</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">order_default</span>;
</div><div id="lc94">
</div><div id="lc95">        <span style="color: #19177C">$desc</span><span style="color: #666666">=</span>get_var(<span style="color: #BA2121">&#39;desc&#39;</span>,<span style="color: #19177C">$_GET</span>,<span style="color: #BA2121">&#39;bi&#39;</span>);
</div><div id="lc96">
</div><div id="lc97">
</div><div id="lc98">        <span style="color: #408080; font-style: italic">//общее число элементов в таблице</span>
</div><div id="lc99">        <span style="color: #19177C">$num</span><span style="color: #666666">=</span>DB<span style="color: #666666">::</span><span style="color: #7D9029">Fast_Query</span>(<span style="color: #BA2121">&quot;SELECT COUNT(*) FROM `&quot;</span><span style="color: #666666">.</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table_name</span><span style="color: #666666">.</span><span style="color: #BA2121">&quot;`&quot;</span>);
</div><div id="lc100">
</div><div id="lc101">
</div><div id="lc102">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">max_page</span><span style="color: #666666">=</span><span style="color: #19177C">$max_page</span><span style="color: #666666">=</span><span style="color: #008000">ceil</span>(<span style="color: #19177C">$num</span><span style="color: #666666">/</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items_per_page</span>);
</div><div id="lc103">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #666666">!</span><span style="color: #19177C">$page</span>) <span style="color: #19177C">$page</span><span style="color: #666666">=1</span>;
</div><div id="lc104">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #19177C">$page</span><span style="color: #666666">&gt;</span><span style="color: #19177C">$max_page</span>) <span style="color: #19177C">$page</span><span style="color: #666666">=</span><span style="color: #19177C">$max_page</span>;
</div><div id="lc105">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #19177C">$max_page</span><span style="color: #666666">&gt;1</span>){
</div><div id="lc106">            <span style="color: #19177C">$page_line</span><span style="color: #666666">=</span><span style="color: #BA2121">&#39;&lt;div class=pages&gt;&#39;</span><span style="color: #666666">.</span>make_pages(<span style="color: #19177C">$page</span>,<span style="color: #19177C">$max_page</span>,<span style="color: #BA2121">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</span>,<span style="color: #BA2121">&quot;&amp;nbsp;&lt;a href=&#39;?module=board&amp;action=view_adverts&amp;page=%1</span><span style="color: #BB6622; font-weight: bold">\$</span><span style="color: #BA2121">s&#39;&gt;%1</span><span style="color: #BB6622; font-weight: bold">\$</span><span style="color: #BA2121">s&lt;/a&gt;&amp;nbsp;&quot;</span>,<span style="color: #666666">2</span>)<span style="color: #666666">.</span><span style="color: #BA2121">&#39;&lt;/div&gt;&#39;</span>;
</div><div id="lc107">        }
</div><div id="lc108">
</div><div id="lc109">
</div><div id="lc110">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">order</span><span style="color: #666666">=</span><span style="color: #19177C">$order</span>;
</div><div id="lc111">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">page</span><span style="color: #666666">=</span><span style="color: #19177C">$page</span>;
</div><div id="lc112">
</div><div id="lc113">
</div><div id="lc114">        <span style="color: #408080; font-style: italic">//задаем ширину столбцов</span>
</div><div id="lc115">        <span style="color: #19177C">$widths</span><span style="color: #666666">=</span>array_one_dimension(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span>,<span style="color: #BA2121">&#39;name&#39;</span>,<span style="color: #BA2121">&#39;width&#39;</span>);
</div><div id="lc116">        <span style="color: #008000">call_user_func_array</span>(<span style="color: #008000; font-weight: bold">array</span>(<span style="color: #666666">&amp;</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span>, <span style="color: #BA2121">&quot;set_widths&quot;</span>),<span style="color: #19177C">$widths</span>);
</div><div id="lc117">
</div><div id="lc118">
</div><div id="lc119">        <span style="color: #408080; font-style: italic">//установка параметров для столбцов</span>
</div><div id="lc120">        <span style="color: #008000; font-weight: bold">foreach</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span> <span style="color: #008000; font-weight: bold">as</span> <span style="color: #19177C">$coldata</span>){
</div><div id="lc121">            <span style="color: #19177C">$additions</span>[] <span style="color: #666666">=</span> get_var(<span style="color: #BA2121">&#39;addition&#39;</span>,<span style="color: #19177C">$coldata</span>);
</div><div id="lc122">            <span style="color: #19177C">$footers</span>[]   <span style="color: #666666">=</span> get_var(<span style="color: #BA2121">&#39;footer&#39;</span>,<span style="color: #19177C">$coldata</span>);
</div><div id="lc123">        }
</div><div id="lc124">        <span style="color: #008000">call_user_func_array</span>(<span style="color: #008000; font-weight: bold">array</span>(<span style="color: #666666">&amp;</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span>, <span style="color: #BA2121">&quot;set_addition&quot;</span>),<span style="color: #19177C">$additions</span>);
</div><div id="lc125">
</div><div id="lc126">
</div><div id="lc127">
</div><div id="lc128">        <span style="color: #408080; font-style: italic">//получаем и добавляем данные в таблицу</span>
</div><div id="lc129">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items</span><span style="color: #666666">=</span>DB<span style="color: #666666">::</span><span style="color: #7D9029">Fast_Arr_Query</span>(<span style="color: #BA2121">&quot;SELECT * FROM `</span><span style="color: #BB6688; font-weight: bold">{</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table_name</span><span style="color: #BB6688; font-weight: bold">}</span><span style="color: #BA2121">` &quot;</span><span style="color: #666666">.</span>
</div><div id="lc130">                                  <span style="color: #BA2121">&quot;ORDER BY `</span><span style="color: #BB6688; font-weight: bold">$order</span><span style="color: #BA2121">` &quot;</span><span style="color: #666666">.</span>(<span style="color: #19177C">$desc</span><span style="color: #666666">?</span><span style="color: #BA2121">&#39;DESC &#39;</span><span style="color: #666666">:</span><span style="color: #BA2121">&#39;&#39;</span>)<span style="color: #666666">.</span>
</div><div id="lc131">                                  <span style="color: #BA2121">&quot;LIMIT &quot;</span><span style="color: #666666">.</span>(<span style="color: #19177C">$page</span><span style="color: #666666">-1</span>)<span style="color: #666666">*</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items_per_page</span><span style="color: #666666">.</span><span style="color: #BA2121">&#39;, &#39;</span><span style="color: #666666">.</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items_per_page</span>);
</div><div id="lc132">
</div><div id="lc133">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items</span><span style="color: #666666">=</span>make_id_array(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items</span>,<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">key_col</span>,<span style="color: #666666">0</span>);
</div><div id="lc134">
</div><div id="lc135">        <span style="color: #408080; font-style: italic">//добавление строк в таблицу</span>
</div><div id="lc136">        <span style="color: #008000; font-weight: bold">foreach</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">items</span> <span style="color: #008000; font-weight: bold">as</span> <span style="color: #19177C">$id</span><span style="color: #666666">=&gt;</span><span style="color: #19177C">$item</span>){
</div><div id="lc137">            <span style="color: #19177C">$cols</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">array</span>();
</div><div id="lc138">            <span style="color: #008000; font-weight: bold">foreach</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span> <span style="color: #008000; font-weight: bold">as</span> <span style="color: #19177C">$colname</span><span style="color: #666666">=&gt;</span><span style="color: #19177C">$coldata</span>){
</div><div id="lc139">                <span style="color: #19177C">$function_name</span><span style="color: #666666">=</span><span style="color: #19177C">$coldata</span>[<span style="color: #BA2121">&#39;handler&#39;</span>];
</div><div id="lc140">                <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #008000">is_callable</span>(<span style="color: #19177C">$function_name</span>))
</div><div id="lc141">                    <span style="color: #19177C">$cols</span>[]<span style="color: #666666">=</span><span style="color: #008000">call_user_func</span>(<span style="color: #19177C">$function_name</span>, <span style="color: #19177C">$id</span>, (<span style="color: #008000">isset</span>(<span style="color: #19177C">$item</span>[<span style="color: #19177C">$colname</span>])<span style="color: #666666">?</span><span style="color: #19177C">$item</span>[<span style="color: #19177C">$colname</span>]<span style="color: #666666">:</span><span style="color: #BA2121">&#39;&#39;</span>),<span style="color: #19177C">$item</span>);
</div><div id="lc142">                <span style="color: #008000; font-weight: bold">else</span>
</div><div id="lc143">                    <span style="color: #19177C">$cols</span>[]<span style="color: #666666">=</span><span style="color: #19177C">$item</span>[<span style="color: #19177C">$colname</span>];
</div><div id="lc144">            }
</div><div id="lc145">
</div><div id="lc146">            <span style="color: #008000">call_user_func_array</span>(<span style="color: #008000; font-weight: bold">array</span>(<span style="color: #666666">&amp;</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span>, <span style="color: #BA2121">&quot;add_row&quot;</span>),<span style="color: #19177C">$cols</span>);
</div><div id="lc147">        }
</div><div id="lc148">
</div><div id="lc149">
</div><div id="lc150">        <span style="color: #408080; font-style: italic">//добавление заглавной строки в таблицу</span>
</div><div id="lc151">        <span style="color: #19177C">$cols</span><span style="color: #666666">=</span><span style="color: #008000; font-weight: bold">array</span>();
</div><div id="lc152">        <span style="color: #008000; font-weight: bold">foreach</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">cols</span> <span style="color: #008000; font-weight: bold">as</span> <span style="color: #19177C">$colname</span><span style="color: #666666">=&gt;</span><span style="color: #19177C">$coldata</span>){
</div><div id="lc153">            <span style="color: #19177C">$title</span><span style="color: #666666">=</span><span style="color: #19177C">$coldata</span>[<span style="color: #BA2121">&#39;title&#39;</span>];
</div><div id="lc154">            <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #19177C">$coldata</span>[<span style="color: #BA2121">&#39;is_ordered&#39;</span>])
</div><div id="lc155">                <span style="color: #19177C">$title</span><span style="color: #666666">=</span><span style="color: #BA2121">&quot;&lt;a href=&#39;</span><span style="color: #BB6688; font-weight: bold">{</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">link</span><span style="color: #BB6688; font-weight: bold">}</span><span style="color: #BA2121">&amp;order=</span><span style="color: #BB6688; font-weight: bold">$colname</span><span style="color: #BA2121">&amp;desc=1&#39;&gt;v&lt;/a&gt;&quot;</span><span style="color: #666666">.</span><span style="color: #19177C">$title</span><span style="color: #666666">.</span><span style="color: #BA2121">&quot;&lt;a href=&#39;</span><span style="color: #BB6688; font-weight: bold">{</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">link</span><span style="color: #BB6688; font-weight: bold">}</span><span style="color: #BA2121">&amp;order=</span><span style="color: #BB6688; font-weight: bold">$colname</span><span style="color: #BA2121">&#39;&gt;^&lt;/a&gt;</span><span style="color: #BB6622; font-weight: bold">\n</span><span style="color: #BA2121">&quot;</span>;
</div><div id="lc156">
</div><div id="lc157">            <span style="color: #19177C">$cols</span>[]<span style="color: #666666">=</span><span style="color: #19177C">$title</span>;
</div><div id="lc158">        }
</div><div id="lc159">        <span style="color: #008000">call_user_func_array</span>(<span style="color: #008000; font-weight: bold">array</span>(<span style="color: #666666">&amp;</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span>, <span style="color: #BA2121">&quot;add_head_row&quot;</span>),<span style="color: #19177C">$cols</span>);
</div><div id="lc160">
</div><div id="lc161">        <span style="color: #008000">call_user_func_array</span>(<span style="color: #008000; font-weight: bold">array</span>(<span style="color: #666666">&amp;</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span>, <span style="color: #BA2121">&quot;add_foot_row&quot;</span>),<span style="color: #19177C">$footers</span>);
</div><div id="lc162">
</div><div id="lc163">        <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">link</span><span style="color: #666666">.=</span><span style="color: #BA2121">&quot;&amp;order=</span><span style="color: #BB6688; font-weight: bold">$order</span><span style="color: #BA2121">&amp;desc=</span><span style="color: #BB6688; font-weight: bold">$desc</span><span style="color: #BA2121">&quot;</span>;
</div><div id="lc164">    }
</div><div id="lc165">
</div><div id="lc166">
</div><div id="lc167">
</div><div id="lc168">    <span style="color: #008000; font-weight: bold">function</span> <span style="color: #0000FF">print_table</span>(){
</div><div id="lc169">        <span style="color: #008000; font-weight: bold">if</span>(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">max_page</span><span style="color: #666666">&gt;1</span>){
</div><div id="lc170">          <span style="color: #19177C">$page_line</span><span style="color: #666666">=</span><span style="color: #BA2121">&#39;&lt;div class=pages&gt;&#39;</span><span style="color: #666666">.</span>make_pages(<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">page</span>,<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">max_page</span>,<span style="color: #BA2121">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</span>,<span style="color: #BA2121">&quot;&amp;nbsp;&lt;a href=&#39;</span><span style="color: #BB6688; font-weight: bold">{</span><span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">link</span><span style="color: #BB6688; font-weight: bold">}</span><span style="color: #BA2121">&amp;page=%1</span><span style="color: #BB6622; font-weight: bold">\$</span><span style="color: #BA2121">s&#39;&gt;%1</span><span style="color: #BB6622; font-weight: bold">\$</span><span style="color: #BA2121">s&lt;/a&gt;&amp;nbsp;&quot;</span>,<span style="color: #666666">2</span>)<span style="color: #666666">.</span><span style="color: #BA2121">&#39;&lt;/div&gt;&#39;</span>;
</div><div id="lc171">          <span style="color: #008000; font-weight: bold">print</span> <span style="color: #19177C">$page_line</span>;
</div><div id="lc172">        }
</div><div id="lc173">
</div><div id="lc174">        <span style="color: #008000; font-weight: bold">print</span> <span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">table</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">generate</span>();
</div><div id="lc175">        <span style="color: #008000; font-weight: bold">if</span> (<span style="color: #19177C">$this</span><span style="color: #666666">-&gt;</span><span style="color: #7D9029">max_page</span><span style="color: #666666">&gt;1</span>)
</div><div id="lc176">          <span style="color: #008000; font-weight: bold">print</span> <span style="color: #19177C">$page_line</span>;
</div><div id="lc177">    }
</div><div id="lc178">
</div><div id="lc179">
</div><div id="lc180">
</div><div id="lc181">
</div><div id="lc182">
</div><div id="lc183">}
</div><div id="lc184">
</div><div id="lc185">
</div><div id="lc186">
</div><div id="lc187">
</div><div id="lc188">
</div><div id="lc189">
</div><div id="lc190"><span style="color: #BC7A00">?&gt;</span>
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

BBCODE Copy To Clipboarddone!

[color=#666666]<?[/color]php

[color=#408080][i]//include    '../../config.inc.php';
//include ABS_PATH.'core/init.inc.php';
//require_once('table_builder.php');
[/i][/color]
[color=#008000][b]class[/b][/color] [color=#0000FF][b]admin_table[/b][/color]{
	[color=#008000][b]public[/b][/color] [color=#19177C]$table[/color];
	[color=#008000][b]public[/b][/color] [color=#19177C]$items[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$img_path[/color];

[color=#008000][b]private[/b][/color] [color=#19177C]$cols[/color][color=#666666]=[/color][color=#008000][b]array[/b][/color]();
[color=#408080][i]//    private $first_r=array();
[/i][/color]
    [color=#008000][b]private[/b][/color] [color=#19177C]$table_name[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$key_col[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$items_per_page[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$form[/color][color=#666666]=[/color][color=#008000][b]false[/b][/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$order_default[/color];

[color=#008000][b]private[/b][/color] [color=#19177C]$order[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$page[/color];
    [color=#008000][b]private[/b][/color] [color=#19177C]$link[/color];

[color=#008000][b]function[/b][/color] [color=#0000FF]__construct[/color]([color=#19177C]$tags[/color][color=#666666]=[/color][color=#BA2121]''[/color]){
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color][color=#666666]=[/color][color=#008000][b]new[/b][/color] table_builder([color=#19177C]$tags[/color]);
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]img_path[/color][color=#666666]=[/color]ABS_PATH[color=#666666].[/color][color=#BA2121]'images/admin/'[/color];
	}

[color=#408080][i]/*prepare*/[/i][/color]

[color=#008000][b]function[/b][/color] [color=#0000FF]set_link[/color]([color=#19177C]$link[/color]){
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]link[/color][color=#666666]=[/color][color=#19177C]$link[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]set_table_name[/color]([color=#19177C]$table[/color]){
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table_name[/color][color=#666666]=[/color][color=#19177C]$table[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]set_key_col[/color]([color=#19177C]$key_col[/color]){
    	[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]key_col[/color][color=#666666]=[/color][color=#19177C]$key_col[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]set_items_per_page[/color]([color=#19177C]$items[/color]){
    	[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items_per_page[/color][color=#666666]=[/color][color=#19177C]$items[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]set_order_default[/color]([color=#19177C]$field[/color]){
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]order_default[/color][color=#666666]=[/color][color=#19177C]$field[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]add_col[/color]([color=#19177C]$name[/color],[color=#19177C]$arr[/color]){
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$name[/color]][color=#666666]=[/color][color=#19177C]$arr[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]use_form[/color]([color=#19177C]$method[/color][color=#666666]=[/color][color=#BA2121]'post'[/color]){
    	[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]form[/color][color=#666666]=[/color][color=#008000][b]new[/b][/color] form_builder([color=#BA2121]''[/color],[color=#19177C]$method[/color]);

}

[color=#408080][i]/*process*/[/i][/color]

[color=#008000][b]function[/b][/color] [color=#0000FF]process[/color](){
        [color=#008000][b]if[/b][/color]([color=#666666]![/color][color=#19177C]$page[/color][color=#666666]=[/color]get_var([color=#BA2121]'page'[/color],[color=#19177C]$_GET[/color],[color=#BA2121]'i'[/color]))
          [color=#19177C]$page[/color][color=#666666]=[/color][color=#666666]1[/color];

[color=#19177C]$order[/color][color=#666666]=[/color]get_var([color=#BA2121]'order'[/color],[color=#19177C]$_GET[/color]);
        [color=#008000][b]if[/b][/color]([color=#19177C]$order[/color]){
          [color=#408080][i]//проверим что ордер это один из стобцов по которому мы можем сортировать
[/i][/color]
          [color=#19177C]$tmp[/color][color=#666666]=[/color][color=#008000]isset[/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$order[/color]])               [color=#666666]&&[/color]
               [color=#008000]isset[/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$order[/color]][[color=#BA2121]'in_table'[/color]])   [color=#666666]&&[/color]
                     [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$order[/color]][[color=#BA2121]'in_table'[/color]]    [color=#666666]&&[/color]
               [color=#008000]isset[/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$order[/color]][[color=#BA2121]'is_ordered'[/color]]) [color=#666666]&&[/color]
                     [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color][[color=#19177C]$order[/color]][[color=#BA2121]'is_ordered'[/color]];

[color=#008000][b]if[/b][/color]([color=#666666]![/color][color=#19177C]$tmp[/color]) [color=#19177C]$order[/color][color=#666666]=[/color][color=#008000][b]false[/b][/color];
        }

[color=#008000][b]if[/b][/color]([color=#666666]![/color][color=#19177C]$order[/color])
            [color=#19177C]$order[/color][color=#666666]=[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]order_default[/color];

[color=#19177C]$desc[/color][color=#666666]=[/color]get_var([color=#BA2121]'desc'[/color],[color=#19177C]$_GET[/color],[color=#BA2121]'bi'[/color]);

[color=#408080][i]//общее число элементов в таблице
[/i][/color]        [color=#19177C]$num[/color][color=#666666]=[/color]DB[color=#666666]::[/color][color=#7D9029]Fast_Query[/color]([color=#BA2121]"SELECT COUNT(*) FROM `"[/color][color=#666666].[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table_name[/color][color=#666666].[/color][color=#BA2121]"`"[/color]);

[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]max_page[/color][color=#666666]=[/color][color=#19177C]$max_page[/color][color=#666666]=[/color][color=#008000]ceil[/color]([color=#19177C]$num[/color][color=#666666]/[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items_per_page[/color]);
        [color=#008000][b]if[/b][/color]([color=#666666]![/color][color=#19177C]$page[/color]) [color=#19177C]$page[/color][color=#666666]=[/color][color=#666666]1[/color];
        [color=#008000][b]if[/b][/color]([color=#19177C]$page[/color][color=#666666]>[/color][color=#19177C]$max_page[/color]) [color=#19177C]$page[/color][color=#666666]=[/color][color=#19177C]$max_page[/color];
        [color=#008000][b]if[/b][/color]([color=#19177C]$max_page[/color][color=#666666]>[/color][color=#666666]1[/color]){
            [color=#19177C]$page_line[/color][color=#666666]=[/color][color=#BA2121]'<div class=pages>'[/color][color=#666666].[/color]make_pages([color=#19177C]$page[/color],[color=#19177C]$max_page[/color],[color=#BA2121]"&nbsp;[%s]&nbsp;"[/color],[color=#BA2121]"&nbsp;<a href='?module=board&action=view_adverts&page=%1[/color][color=#BB6622][b]\$[/b][/color][color=#BA2121]s'>%1[/color][color=#BB6622][b]\$[/b][/color][color=#BA2121]s</a>&nbsp;"[/color],[color=#666666]2[/color])[color=#666666].[/color][color=#BA2121]'</div>'[/color];
        }

[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]order[/color][color=#666666]=[/color][color=#19177C]$order[/color];
        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]page[/color][color=#666666]=[/color][color=#19177C]$page[/color];

[color=#408080][i]//задаем ширину столбцов
[/i][/color]        [color=#19177C]$widths[/color][color=#666666]=[/color]array_one_dimension([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color],[color=#BA2121]'name'[/color],[color=#BA2121]'width'[/color]);
        [color=#008000]call_user_func_array[/color]([color=#008000][b]array[/b][/color]([color=#666666]&[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color], [color=#BA2121]"set_widths"[/color]),[color=#19177C]$widths[/color]);

[color=#408080][i]//установка параметров для столбцов
[/i][/color]        [color=#008000][b]foreach[/b][/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color] [color=#008000][b]as[/b][/color] [color=#19177C]$coldata[/color]){
            [color=#19177C]$additions[/color][] [color=#666666]=[/color] get_var([color=#BA2121]'addition'[/color],[color=#19177C]$coldata[/color]);
            [color=#19177C]$footers[/color][]   [color=#666666]=[/color] get_var([color=#BA2121]'footer'[/color],[color=#19177C]$coldata[/color]);
        }
        [color=#008000]call_user_func_array[/color]([color=#008000][b]array[/b][/color]([color=#666666]&[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color], [color=#BA2121]"set_addition"[/color]),[color=#19177C]$additions[/color]);

[color=#408080][i]//получаем и добавляем данные в таблицу
[/i][/color]        [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items[/color][color=#666666]=[/color]DB[color=#666666]::[/color][color=#7D9029]Fast_Arr_Query[/color]([color=#BA2121]"SELECT * FROM `[/color][color=#BB6688][b]{[/b][/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table_name[/color][color=#BB6688][b]}[/b][/color][color=#BA2121]` "[/color][color=#666666].[/color]
                                  [color=#BA2121]"ORDER BY `[/color][color=#BB6688][b]$order[/b][/color][color=#BA2121]` "[/color][color=#666666].[/color]([color=#19177C]$desc[/color][color=#666666]?[/color][color=#BA2121]'DESC '[/color][color=#666666]:[/color][color=#BA2121]''[/color])[color=#666666].[/color]
                                  [color=#BA2121]"LIMIT "[/color][color=#666666].[/color]([color=#19177C]$page[/color][color=#666666]-[/color][color=#666666]1[/color])[color=#666666]*[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items_per_page[/color][color=#666666].[/color][color=#BA2121]', '[/color][color=#666666].[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items_per_page[/color]);

[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items[/color][color=#666666]=[/color]make_id_array([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items[/color],[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]key_col[/color],[color=#666666]0[/color]);

[color=#408080][i]//добавление строк в таблицу
[/i][/color]        [color=#008000][b]foreach[/b][/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]items[/color] [color=#008000][b]as[/b][/color] [color=#19177C]$id[/color][color=#666666]=>[/color][color=#19177C]$item[/color]){
            [color=#19177C]$cols[/color][color=#666666]=[/color][color=#008000][b]array[/b][/color]();
            [color=#008000][b]foreach[/b][/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color] [color=#008000][b]as[/b][/color] [color=#19177C]$colname[/color][color=#666666]=>[/color][color=#19177C]$coldata[/color]){
                [color=#19177C]$function_name[/color][color=#666666]=[/color][color=#19177C]$coldata[/color][[color=#BA2121]'handler'[/color]];
                [color=#008000][b]if[/b][/color]([color=#008000]is_callable[/color]([color=#19177C]$function_name[/color]))
                    [color=#19177C]$cols[/color][][color=#666666]=[/color][color=#008000]call_user_func[/color]([color=#19177C]$function_name[/color], [color=#19177C]$id[/color], ([color=#008000]isset[/color]([color=#19177C]$item[/color][[color=#19177C]$colname[/color]])[color=#666666]?[/color][color=#19177C]$item[/color][[color=#19177C]$colname[/color]][color=#666666]:[/color][color=#BA2121]''[/color]),[color=#19177C]$item[/color]);
                [color=#008000][b]else[/b][/color]
                    [color=#19177C]$cols[/color][][color=#666666]=[/color][color=#19177C]$item[/color][[color=#19177C]$colname[/color]];
            }

[color=#008000]call_user_func_array[/color]([color=#008000][b]array[/b][/color]([color=#666666]&[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color], [color=#BA2121]"add_row"[/color]),[color=#19177C]$cols[/color]);
        }

[color=#408080][i]//добавление заглавной строки в таблицу
[/i][/color]        [color=#19177C]$cols[/color][color=#666666]=[/color][color=#008000][b]array[/b][/color]();
        [color=#008000][b]foreach[/b][/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]cols[/color] [color=#008000][b]as[/b][/color] [color=#19177C]$colname[/color][color=#666666]=>[/color][color=#19177C]$coldata[/color]){
            [color=#19177C]$title[/color][color=#666666]=[/color][color=#19177C]$coldata[/color][[color=#BA2121]'title'[/color]];
            [color=#008000][b]if[/b][/color]([color=#19177C]$coldata[/color][[color=#BA2121]'is_ordered'[/color]])
                [color=#19177C]$title[/color][color=#666666]=[/color][color=#BA2121]"<a href='[/color][color=#BB6688][b]{[/b][/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]link[/color][color=#BB6688][b]}[/b][/color][color=#BA2121]&order=[/color][color=#BB6688][b]$colname[/b][/color][color=#BA2121]&desc=1'>v</a>"[/color][color=#666666].[/color][color=#19177C]$title[/color][color=#666666].[/color][color=#BA2121]"<a href='[/color][color=#BB6688][b]{[/b][/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]link[/color][color=#BB6688][b]}[/b][/color][color=#BA2121]&order=[/color][color=#BB6688][b]$colname[/b][/color][color=#BA2121]'>^</a>[/color][color=#BB6622][b]\n[/b][/color][color=#BA2121]"[/color];

[color=#19177C]$cols[/color][][color=#666666]=[/color][color=#19177C]$title[/color];
        }
        [color=#008000]call_user_func_array[/color]([color=#008000][b]array[/b][/color]([color=#666666]&[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color], [color=#BA2121]"add_head_row"[/color]),[color=#19177C]$cols[/color]);

[color=#008000]call_user_func_array[/color]([color=#008000][b]array[/b][/color]([color=#666666]&[/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color], [color=#BA2121]"add_foot_row"[/color]),[color=#19177C]$footers[/color]);

[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]link[/color][color=#666666].=[/color][color=#BA2121]"&order=[/color][color=#BB6688][b]$order[/b][/color][color=#BA2121]&desc=[/color][color=#BB6688][b]$desc[/b][/color][color=#BA2121]"[/color];
    }

[color=#008000][b]function[/b][/color] [color=#0000FF]print_table[/color](){
        [color=#008000][b]if[/b][/color]([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]max_page[/color][color=#666666]>[/color][color=#666666]1[/color]){
          [color=#19177C]$page_line[/color][color=#666666]=[/color][color=#BA2121]'<div class=pages>'[/color][color=#666666].[/color]make_pages([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]page[/color],[color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]max_page[/color],[color=#BA2121]"&nbsp;[%s]&nbsp;"[/color],[color=#BA2121]"&nbsp;<a href='[/color][color=#BB6688][b]{[/b][/color][color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]link[/color][color=#BB6688][b]}[/b][/color][color=#BA2121]&page=%1[/color][color=#BB6622][b]\$[/b][/color][color=#BA2121]s'>%1[/color][color=#BB6622][b]\$[/b][/color][color=#BA2121]s</a>&nbsp;"[/color],[color=#666666]2[/color])[color=#666666].[/color][color=#BA2121]'</div>'[/color];
          [color=#008000][b]print[/b][/color] [color=#19177C]$page_line[/color];
        }

[color=#008000][b]print[/b][/color] [color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]table[/color][color=#666666]->[/color][color=#7D9029]generate[/color]();
        [color=#008000][b]if[/b][/color] ([color=#19177C]$this[/color][color=#666666]->[/color][color=#7D9029]max_page[/color][color=#666666]>[/color][color=#666666]1[/color])
          [color=#008000][b]print[/b][/color] [color=#19177C]$page_line[/color];
    }

}

[color=#BC7A00]?>[/color]

--------------------------------------
Colored with http://dumpz.org

Light HTML Copy To Clipboarddone!

That method generates HTML with CSS classes. Hence you'll need the style sheet file

<div class="highlight"><pre><div id="lc1"><span class="o">&lt;?</span><span class="nx">php</span>
</div><div id="lc2">
</div><div id="lc3">
</div><div id="lc4"><span class="c1">//include    &#39;../../config.inc.php&#39;;</span>
</div><div id="lc5"><span class="c1">//include ABS_PATH.&#39;core/init.inc.php&#39;;</span>
</div><div id="lc6"><span class="c1">//require_once(&#39;table_builder.php&#39;);</span>
</div><div id="lc7">
</div><div id="lc8"><span class="k">class</span> <span class="nc">admin_table</span><span class="p">{</span>
</div><div id="lc9">	<span class="k">public</span> <span class="nv">$table</span><span class="p">;</span>
</div><div id="lc10">	<span class="k">public</span> <span class="nv">$items</span><span class="p">;</span>
</div><div id="lc11">    <span class="k">private</span> <span class="nv">$img_path</span><span class="p">;</span>
</div><div id="lc12">
</div><div id="lc13">    <span class="k">private</span> <span class="nv">$cols</span><span class="o">=</span><span class="k">array</span><span class="p">();</span>
</div><div id="lc14"><span class="c1">//    private $first_r=array();</span>
</div><div id="lc15">
</div><div id="lc16">    <span class="k">private</span> <span class="nv">$table_name</span><span class="p">;</span>
</div><div id="lc17">    <span class="k">private</span> <span class="nv">$key_col</span><span class="p">;</span>
</div><div id="lc18">    <span class="k">private</span> <span class="nv">$items_per_page</span><span class="p">;</span>
</div><div id="lc19">    <span class="k">private</span> <span class="nv">$form</span><span class="o">=</span><span class="k">false</span><span class="p">;</span>
</div><div id="lc20">    <span class="k">private</span> <span class="nv">$order_default</span><span class="p">;</span>
</div><div id="lc21">
</div><div id="lc22">
</div><div id="lc23">    <span class="k">private</span> <span class="nv">$order</span><span class="p">;</span>
</div><div id="lc24">    <span class="k">private</span> <span class="nv">$page</span><span class="p">;</span>
</div><div id="lc25">    <span class="k">private</span> <span class="nv">$link</span><span class="p">;</span>
</div><div id="lc26">
</div><div id="lc27">
</div><div id="lc28">	<span class="k">function</span> <span class="nf">__construct</span><span class="p">(</span><span class="nv">$tags</span><span class="o">=</span><span class="s1">&#39;&#39;</span><span class="p">){</span>
</div><div id="lc29">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="o">=</span><span class="k">new</span> <span class="nx">table_builder</span><span class="p">(</span><span class="nv">$tags</span><span class="p">);</span>
</div><div id="lc30">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">img_path</span><span class="o">=</span><span class="nx">ABS_PATH</span><span class="o">.</span><span class="s1">&#39;images/admin/&#39;</span><span class="p">;</span>
</div><div id="lc31">	<span class="p">}</span>
</div><div id="lc32">
</div><div id="lc33">
</div><div id="lc34">
</div><div id="lc35">
</div><div id="lc36"><span class="cm">/*prepare*/</span>
</div><div id="lc37">
</div><div id="lc38">    <span class="k">function</span> <span class="nf">set_link</span><span class="p">(</span><span class="nv">$link</span><span class="p">){</span>
</div><div id="lc39">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">link</span><span class="o">=</span><span class="nv">$link</span><span class="p">;</span>
</div><div id="lc40">    <span class="p">}</span>
</div><div id="lc41">
</div><div id="lc42">
</div><div id="lc43">    <span class="k">function</span> <span class="nf">set_table_name</span><span class="p">(</span><span class="nv">$table</span><span class="p">){</span>
</div><div id="lc44">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table_name</span><span class="o">=</span><span class="nv">$table</span><span class="p">;</span>
</div><div id="lc45">    <span class="p">}</span>
</div><div id="lc46">
</div><div id="lc47">    <span class="k">function</span> <span class="nf">set_key_col</span><span class="p">(</span><span class="nv">$key_col</span><span class="p">){</span>
</div><div id="lc48">    	<span class="nv">$this</span><span class="o">-&gt;</span><span class="na">key_col</span><span class="o">=</span><span class="nv">$key_col</span><span class="p">;</span>
</div><div id="lc49">    <span class="p">}</span>
</div><div id="lc50">
</div><div id="lc51">    <span class="k">function</span> <span class="nf">set_items_per_page</span><span class="p">(</span><span class="nv">$items</span><span class="p">){</span>
</div><div id="lc52">    	<span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items_per_page</span><span class="o">=</span><span class="nv">$items</span><span class="p">;</span>
</div><div id="lc53">    <span class="p">}</span>
</div><div id="lc54">
</div><div id="lc55">    <span class="k">function</span> <span class="nf">set_order_default</span><span class="p">(</span><span class="nv">$field</span><span class="p">){</span>
</div><div id="lc56">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">order_default</span><span class="o">=</span><span class="nv">$field</span><span class="p">;</span>
</div><div id="lc57">    <span class="p">}</span>
</div><div id="lc58">
</div><div id="lc59">    <span class="k">function</span> <span class="nf">add_col</span><span class="p">(</span><span class="nv">$name</span><span class="p">,</span><span class="nv">$arr</span><span class="p">){</span>
</div><div id="lc60">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$name</span><span class="p">]</span><span class="o">=</span><span class="nv">$arr</span><span class="p">;</span>
</div><div id="lc61">    <span class="p">}</span>
</div><div id="lc62">
</div><div id="lc63">    <span class="k">function</span> <span class="nf">use_form</span><span class="p">(</span><span class="nv">$method</span><span class="o">=</span><span class="s1">&#39;post&#39;</span><span class="p">){</span>
</div><div id="lc64">    	<span class="nv">$this</span><span class="o">-&gt;</span><span class="na">form</span><span class="o">=</span><span class="k">new</span> <span class="nx">form_builder</span><span class="p">(</span><span class="s1">&#39;&#39;</span><span class="p">,</span><span class="nv">$method</span><span class="p">);</span>
</div><div id="lc65">
</div><div id="lc66">    <span class="p">}</span>
</div><div id="lc67">
</div><div id="lc68">
</div><div id="lc69">
</div><div id="lc70">
</div><div id="lc71"><span class="cm">/*process*/</span>
</div><div id="lc72">
</div><div id="lc73">    <span class="k">function</span> <span class="nf">process</span><span class="p">(){</span>
</div><div id="lc74">        <span class="k">if</span><span class="p">(</span><span class="o">!</span><span class="nv">$page</span><span class="o">=</span><span class="nx">get_var</span><span class="p">(</span><span class="s1">&#39;page&#39;</span><span class="p">,</span><span class="nv">$_GET</span><span class="p">,</span><span class="s1">&#39;i&#39;</span><span class="p">))</span>
</div><div id="lc75">          <span class="nv">$page</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span>
</div><div id="lc76">
</div><div id="lc77">
</div><div id="lc78">
</div><div id="lc79">        <span class="nv">$order</span><span class="o">=</span><span class="nx">get_var</span><span class="p">(</span><span class="s1">&#39;order&#39;</span><span class="p">,</span><span class="nv">$_GET</span><span class="p">);</span>
</div><div id="lc80">        <span class="k">if</span><span class="p">(</span><span class="nv">$order</span><span class="p">){</span>
</div><div id="lc81">          <span class="c1">//проверим что ордер это один из стобцов по которому мы можем сортировать</span>
</div><div id="lc82">
</div><div id="lc83">          <span class="nv">$tmp</span><span class="o">=</span><span class="nb">isset</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$order</span><span class="p">])</span>               <span class="o">&amp;&amp;</span>
</div><div id="lc84">               <span class="nb">isset</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$order</span><span class="p">][</span><span class="s1">&#39;in_table&#39;</span><span class="p">])</span>   <span class="o">&amp;&amp;</span>
</div><div id="lc85">                     <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$order</span><span class="p">][</span><span class="s1">&#39;in_table&#39;</span><span class="p">]</span>    <span class="o">&amp;&amp;</span>
</div><div id="lc86">               <span class="nb">isset</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$order</span><span class="p">][</span><span class="s1">&#39;is_ordered&#39;</span><span class="p">])</span> <span class="o">&amp;&amp;</span>
</div><div id="lc87">                     <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">[</span><span class="nv">$order</span><span class="p">][</span><span class="s1">&#39;is_ordered&#39;</span><span class="p">];</span>
</div><div id="lc88">
</div><div id="lc89">          <span class="k">if</span><span class="p">(</span><span class="o">!</span><span class="nv">$tmp</span><span class="p">)</span> <span class="nv">$order</span><span class="o">=</span><span class="k">false</span><span class="p">;</span>
</div><div id="lc90">        <span class="p">}</span>
</div><div id="lc91">
</div><div id="lc92">        <span class="k">if</span><span class="p">(</span><span class="o">!</span><span class="nv">$order</span><span class="p">)</span>
</div><div id="lc93">            <span class="nv">$order</span><span class="o">=</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">order_default</span><span class="p">;</span>
</div><div id="lc94">
</div><div id="lc95">        <span class="nv">$desc</span><span class="o">=</span><span class="nx">get_var</span><span class="p">(</span><span class="s1">&#39;desc&#39;</span><span class="p">,</span><span class="nv">$_GET</span><span class="p">,</span><span class="s1">&#39;bi&#39;</span><span class="p">);</span>
</div><div id="lc96">
</div><div id="lc97">
</div><div id="lc98">        <span class="c1">//общее число элементов в таблице</span>
</div><div id="lc99">        <span class="nv">$num</span><span class="o">=</span><span class="nx">DB</span><span class="o">::</span><span class="na">Fast_Query</span><span class="p">(</span><span class="s2">&quot;SELECT COUNT(*) FROM `&quot;</span><span class="o">.</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table_name</span><span class="o">.</span><span class="s2">&quot;`&quot;</span><span class="p">);</span>
</div><div id="lc100">
</div><div id="lc101">
</div><div id="lc102">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">max_page</span><span class="o">=</span><span class="nv">$max_page</span><span class="o">=</span><span class="nb">ceil</span><span class="p">(</span><span class="nv">$num</span><span class="o">/</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items_per_page</span><span class="p">);</span>
</div><div id="lc103">        <span class="k">if</span><span class="p">(</span><span class="o">!</span><span class="nv">$page</span><span class="p">)</span> <span class="nv">$page</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span>
</div><div id="lc104">        <span class="k">if</span><span class="p">(</span><span class="nv">$page</span><span class="o">&gt;</span><span class="nv">$max_page</span><span class="p">)</span> <span class="nv">$page</span><span class="o">=</span><span class="nv">$max_page</span><span class="p">;</span>
</div><div id="lc105">        <span class="k">if</span><span class="p">(</span><span class="nv">$max_page</span><span class="o">&gt;</span><span class="mi">1</span><span class="p">){</span>
</div><div id="lc106">            <span class="nv">$page_line</span><span class="o">=</span><span class="s1">&#39;&lt;div class=pages&gt;&#39;</span><span class="o">.</span><span class="nx">make_pages</span><span class="p">(</span><span class="nv">$page</span><span class="p">,</span><span class="nv">$max_page</span><span class="p">,</span><span class="s2">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</span><span class="p">,</span><span class="s2">&quot;&amp;nbsp;&lt;a href=&#39;?module=board&amp;action=view_adverts&amp;page=%1</span><span class="se">\$</span><span class="s2">s&#39;&gt;%1</span><span class="se">\$</span><span class="s2">s&lt;/a&gt;&amp;nbsp;&quot;</span><span class="p">,</span><span class="mi">2</span><span class="p">)</span><span class="o">.</span><span class="s1">&#39;&lt;/div&gt;&#39;</span><span class="p">;</span>
</div><div id="lc107">        <span class="p">}</span>
</div><div id="lc108">
</div><div id="lc109">
</div><div id="lc110">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">order</span><span class="o">=</span><span class="nv">$order</span><span class="p">;</span>
</div><div id="lc111">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">page</span><span class="o">=</span><span class="nv">$page</span><span class="p">;</span>
</div><div id="lc112">
</div><div id="lc113">
</div><div id="lc114">        <span class="c1">//задаем ширину столбцов</span>
</div><div id="lc115">        <span class="nv">$widths</span><span class="o">=</span><span class="nx">array_one_dimension</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span><span class="p">,</span><span class="s1">&#39;name&#39;</span><span class="p">,</span><span class="s1">&#39;width&#39;</span><span class="p">);</span>
</div><div id="lc116">        <span class="nb">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&amp;</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="p">,</span> <span class="s2">&quot;set_widths&quot;</span><span class="p">),</span><span class="nv">$widths</span><span class="p">);</span>
</div><div id="lc117">
</div><div id="lc118">
</div><div id="lc119">        <span class="c1">//установка параметров для столбцов</span>
</div><div id="lc120">        <span class="k">foreach</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span> <span class="k">as</span> <span class="nv">$coldata</span><span class="p">){</span>
</div><div id="lc121">            <span class="nv">$additions</span><span class="p">[]</span> <span class="o">=</span> <span class="nx">get_var</span><span class="p">(</span><span class="s1">&#39;addition&#39;</span><span class="p">,</span><span class="nv">$coldata</span><span class="p">);</span>
</div><div id="lc122">            <span class="nv">$footers</span><span class="p">[]</span>   <span class="o">=</span> <span class="nx">get_var</span><span class="p">(</span><span class="s1">&#39;footer&#39;</span><span class="p">,</span><span class="nv">$coldata</span><span class="p">);</span>
</div><div id="lc123">        <span class="p">}</span>
</div><div id="lc124">        <span class="nb">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&amp;</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="p">,</span> <span class="s2">&quot;set_addition&quot;</span><span class="p">),</span><span class="nv">$additions</span><span class="p">);</span>
</div><div id="lc125">
</div><div id="lc126">
</div><div id="lc127">
</div><div id="lc128">        <span class="c1">//получаем и добавляем данные в таблицу</span>
</div><div id="lc129">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items</span><span class="o">=</span><span class="nx">DB</span><span class="o">::</span><span class="na">Fast_Arr_Query</span><span class="p">(</span><span class="s2">&quot;SELECT * FROM `</span><span class="si">{</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table_name</span><span class="si">}</span><span class="s2">` &quot;</span><span class="o">.</span>
</div><div id="lc130">                                  <span class="s2">&quot;ORDER BY `</span><span class="si">$order</span><span class="s2">` &quot;</span><span class="o">.</span><span class="p">(</span><span class="nv">$desc</span><span class="o">?</span><span class="s1">&#39;DESC &#39;</span><span class="o">:</span><span class="s1">&#39;&#39;</span><span class="p">)</span><span class="o">.</span>
</div><div id="lc131">                                  <span class="s2">&quot;LIMIT &quot;</span><span class="o">.</span><span class="p">(</span><span class="nv">$page</span><span class="o">-</span><span class="mi">1</span><span class="p">)</span><span class="o">*</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items_per_page</span><span class="o">.</span><span class="s1">&#39;, &#39;</span><span class="o">.</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items_per_page</span><span class="p">);</span>
</div><div id="lc132">
</div><div id="lc133">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items</span><span class="o">=</span><span class="nx">make_id_array</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items</span><span class="p">,</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">key_col</span><span class="p">,</span><span class="mi">0</span><span class="p">);</span>
</div><div id="lc134">
</div><div id="lc135">        <span class="c1">//добавление строк в таблицу</span>
</div><div id="lc136">        <span class="k">foreach</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">items</span> <span class="k">as</span> <span class="nv">$id</span><span class="o">=&gt;</span><span class="nv">$item</span><span class="p">){</span>
</div><div id="lc137">            <span class="nv">$cols</span><span class="o">=</span><span class="k">array</span><span class="p">();</span>
</div><div id="lc138">            <span class="k">foreach</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span> <span class="k">as</span> <span class="nv">$colname</span><span class="o">=&gt;</span><span class="nv">$coldata</span><span class="p">){</span>
</div><div id="lc139">                <span class="nv">$function_name</span><span class="o">=</span><span class="nv">$coldata</span><span class="p">[</span><span class="s1">&#39;handler&#39;</span><span class="p">];</span>
</div><div id="lc140">                <span class="k">if</span><span class="p">(</span><span class="nb">is_callable</span><span class="p">(</span><span class="nv">$function_name</span><span class="p">))</span>
</div><div id="lc141">                    <span class="nv">$cols</span><span class="p">[]</span><span class="o">=</span><span class="nb">call_user_func</span><span class="p">(</span><span class="nv">$function_name</span><span class="p">,</span> <span class="nv">$id</span><span class="p">,</span> <span class="p">(</span><span class="nb">isset</span><span class="p">(</span><span class="nv">$item</span><span class="p">[</span><span class="nv">$colname</span><span class="p">])</span><span class="o">?</span><span class="nv">$item</span><span class="p">[</span><span class="nv">$colname</span><span class="p">]</span><span class="o">:</span><span class="s1">&#39;&#39;</span><span class="p">),</span><span class="nv">$item</span><span class="p">);</span>
</div><div id="lc142">                <span class="k">else</span>
</div><div id="lc143">                    <span class="nv">$cols</span><span class="p">[]</span><span class="o">=</span><span class="nv">$item</span><span class="p">[</span><span class="nv">$colname</span><span class="p">];</span>
</div><div id="lc144">            <span class="p">}</span>
</div><div id="lc145">
</div><div id="lc146">            <span class="nb">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&amp;</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="p">,</span> <span class="s2">&quot;add_row&quot;</span><span class="p">),</span><span class="nv">$cols</span><span class="p">);</span>
</div><div id="lc147">        <span class="p">}</span>
</div><div id="lc148">
</div><div id="lc149">
</div><div id="lc150">        <span class="c1">//добавление заглавной строки в таблицу</span>
</div><div id="lc151">        <span class="nv">$cols</span><span class="o">=</span><span class="k">array</span><span class="p">();</span>
</div><div id="lc152">        <span class="k">foreach</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">cols</span> <span class="k">as</span> <span class="nv">$colname</span><span class="o">=&gt;</span><span class="nv">$coldata</span><span class="p">){</span>
</div><div id="lc153">            <span class="nv">$title</span><span class="o">=</span><span class="nv">$coldata</span><span class="p">[</span><span class="s1">&#39;title&#39;</span><span class="p">];</span>
</div><div id="lc154">            <span class="k">if</span><span class="p">(</span><span class="nv">$coldata</span><span class="p">[</span><span class="s1">&#39;is_ordered&#39;</span><span class="p">])</span>
</div><div id="lc155">                <span class="nv">$title</span><span class="o">=</span><span class="s2">&quot;&lt;a href=&#39;</span><span class="si">{</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">link</span><span class="si">}</span><span class="s2">&amp;order=</span><span class="si">$colname</span><span class="s2">&amp;desc=1&#39;&gt;v&lt;/a&gt;&quot;</span><span class="o">.</span><span class="nv">$title</span><span class="o">.</span><span class="s2">&quot;&lt;a href=&#39;</span><span class="si">{</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">link</span><span class="si">}</span><span class="s2">&amp;order=</span><span class="si">$colname</span><span class="s2">&#39;&gt;^&lt;/a&gt;</span><span class="se">\n</span><span class="s2">&quot;</span><span class="p">;</span>
</div><div id="lc156">
</div><div id="lc157">            <span class="nv">$cols</span><span class="p">[]</span><span class="o">=</span><span class="nv">$title</span><span class="p">;</span>
</div><div id="lc158">        <span class="p">}</span>
</div><div id="lc159">        <span class="nb">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&amp;</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="p">,</span> <span class="s2">&quot;add_head_row&quot;</span><span class="p">),</span><span class="nv">$cols</span><span class="p">);</span>
</div><div id="lc160">
</div><div id="lc161">        <span class="nb">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&amp;</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="p">,</span> <span class="s2">&quot;add_foot_row&quot;</span><span class="p">),</span><span class="nv">$footers</span><span class="p">);</span>
</div><div id="lc162">
</div><div id="lc163">        <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">link</span><span class="o">.=</span><span class="s2">&quot;&amp;order=</span><span class="si">$order</span><span class="s2">&amp;desc=</span><span class="si">$desc</span><span class="s2">&quot;</span><span class="p">;</span>
</div><div id="lc164">    <span class="p">}</span>
</div><div id="lc165">
</div><div id="lc166">
</div><div id="lc167">
</div><div id="lc168">    <span class="k">function</span> <span class="nf">print_table</span><span class="p">(){</span>
</div><div id="lc169">        <span class="k">if</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">max_page</span><span class="o">&gt;</span><span class="mi">1</span><span class="p">){</span>
</div><div id="lc170">          <span class="nv">$page_line</span><span class="o">=</span><span class="s1">&#39;&lt;div class=pages&gt;&#39;</span><span class="o">.</span><span class="nx">make_pages</span><span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">page</span><span class="p">,</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">max_page</span><span class="p">,</span><span class="s2">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</span><span class="p">,</span><span class="s2">&quot;&amp;nbsp;&lt;a href=&#39;</span><span class="si">{</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">link</span><span class="si">}</span><span class="s2">&amp;page=%1</span><span class="se">\$</span><span class="s2">s&#39;&gt;%1</span><span class="se">\$</span><span class="s2">s&lt;/a&gt;&amp;nbsp;&quot;</span><span class="p">,</span><span class="mi">2</span><span class="p">)</span><span class="o">.</span><span class="s1">&#39;&lt;/div&gt;&#39;</span><span class="p">;</span>
</div><div id="lc171">          <span class="k">print</span> <span class="nv">$page_line</span><span class="p">;</span>
</div><div id="lc172">        <span class="p">}</span>
</div><div id="lc173">
</div><div id="lc174">        <span class="k">print</span> <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">table</span><span class="o">-&gt;</span><span class="na">generate</span><span class="p">();</span>
</div><div id="lc175">        <span class="k">if</span> <span class="p">(</span><span class="nv">$this</span><span class="o">-&gt;</span><span class="na">max_page</span><span class="o">&gt;</span><span class="mi">1</span><span class="p">)</span>
</div><div id="lc176">          <span class="k">print</span> <span class="nv">$page_line</span><span class="p">;</span>
</div><div id="lc177">    <span class="p">}</span>
</div><div id="lc178">
</div><div id="lc179">
</div><div id="lc180">
</div><div id="lc181">
</div><div id="lc182">
</div><div id="lc183"><span class="p">}</span>
</div><div id="lc184">
</div><div id="lc185">
</div><div id="lc186">
</div><div id="lc187">
</div><div id="lc188">
</div><div id="lc189">
</div><div id="lc190"><span class="cp">?&gt;</span><span class="x"></span>
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

Habrahabr.ru HTML Copy To Clipboarddone!

Use that HTML for publications on habrahabr.ru

<blockquote><code><font color="#666666">&lt;?</font>php

<font color="#408080"><em>//include&nbsp;&nbsp;&nbsp;&nbsp;&#39;../../config.inc.php&#39;;
//include&nbsp;ABS_PATH.&#39;core/init.inc.php&#39;;
//require_once(&#39;table_builder.php&#39;);
</em></font>
<font color="#008000"><strong>class</strong></font>&nbsp;<font color="#0000FF"><strong>admin_table</strong></font>{
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>public</strong></font>&nbsp;<font color="#19177C">$table</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>public</strong></font>&nbsp;<font color="#19177C">$items</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$img_path</font>;

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$cols</font><font color="#666666">=</font><font color="#008000"><strong>array</strong></font>();
<font color="#408080"><em>//&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;$first_r=array();
</em></font>
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$table_name</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$key_col</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$items_per_page</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$form</font><font color="#666666">=</font><font color="#008000"><strong>false</strong></font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$order_default</font>;

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$order</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$page</font>;
&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>private</strong></font>&nbsp;<font color="#19177C">$link</font>;

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">__construct</font>(<font color="#19177C">$tags</font><font color="#666666">=</font><font color="#BA2121">&#39;&#39;</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font><font color="#666666">=</font><font color="#008000"><strong>new</strong></font>&nbsp;table_builder(<font color="#19177C">$tags</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">img_path</font><font color="#666666">=</font>ABS_PATH<font color="#666666">.</font><font color="#BA2121">&#39;images/admin/&#39;</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

<font color="#408080"><em>/*prepare*/</em></font>

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">set_link</font>(<font color="#19177C">$link</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">link</font><font color="#666666">=</font><font color="#19177C">$link</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">set_table_name</font>(<font color="#19177C">$table</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table_name</font><font color="#666666">=</font><font color="#19177C">$table</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">set_key_col</font>(<font color="#19177C">$key_col</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">key_col</font><font color="#666666">=</font><font color="#19177C">$key_col</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">set_items_per_page</font>(<font color="#19177C">$items</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items_per_page</font><font color="#666666">=</font><font color="#19177C">$items</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">set_order_default</font>(<font color="#19177C">$field</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">order_default</font><font color="#666666">=</font><font color="#19177C">$field</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">add_col</font>(<font color="#19177C">$name</font>,<font color="#19177C">$arr</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$name</font>]<font color="#666666">=</font><font color="#19177C">$arr</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">use_form</font>(<font color="#19177C">$method</font><font color="#666666">=</font><font color="#BA2121">&#39;post&#39;</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">form</font><font color="#666666">=</font><font color="#008000"><strong>new</strong></font>&nbsp;form_builder(<font color="#BA2121">&#39;&#39;</font>,<font color="#19177C">$method</font>);

&nbsp;&nbsp;&nbsp;&nbsp;}

<font color="#408080"><em>/*process*/</em></font>

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">process</font>(){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#666666">!</font><font color="#19177C">$page</font><font color="#666666">=</font>get_var(<font color="#BA2121">&#39;page&#39;</font>,<font color="#19177C">$_GET</font>,<font color="#BA2121">&#39;i&#39;</font>))
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$page</font><font color="#666666">=1</font>;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$order</font><font color="#666666">=</font>get_var(<font color="#BA2121">&#39;order&#39;</font>,<font color="#19177C">$_GET</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#19177C">$order</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//проверим&nbsp;что&nbsp;ордер&nbsp;это&nbsp;один&nbsp;из&nbsp;стобцов&nbsp;по&nbsp;которому&nbsp;мы&nbsp;можем&nbsp;сортировать
</em></font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$tmp</font><font color="#666666">=</font><font color="#008000">isset</font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$order</font>])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#666666">&amp;&amp;</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">isset</font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$order</font>][<font color="#BA2121">&#39;in_table&#39;</font>])&nbsp;&nbsp;&nbsp;<font color="#666666">&amp;&amp;</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$order</font>][<font color="#BA2121">&#39;in_table&#39;</font>]&nbsp;&nbsp;&nbsp;&nbsp;<font color="#666666">&amp;&amp;</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">isset</font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$order</font>][<font color="#BA2121">&#39;is_ordered&#39;</font>])&nbsp;<font color="#666666">&amp;&amp;</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>[<font color="#19177C">$order</font>][<font color="#BA2121">&#39;is_ordered&#39;</font>];

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#666666">!</font><font color="#19177C">$tmp</font>)&nbsp;<font color="#19177C">$order</font><font color="#666666">=</font><font color="#008000"><strong>false</strong></font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#666666">!</font><font color="#19177C">$order</font>)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$order</font><font color="#666666">=</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">order_default</font>;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$desc</font><font color="#666666">=</font>get_var(<font color="#BA2121">&#39;desc&#39;</font>,<font color="#19177C">$_GET</font>,<font color="#BA2121">&#39;bi&#39;</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//общее&nbsp;число&nbsp;элементов&nbsp;в&nbsp;таблице
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$num</font><font color="#666666">=</font>DB<font color="#666666">::</font><font color="#7D9029">Fast_Query</font>(<font color="#BA2121">&quot;SELECT&nbsp;COUNT(*)&nbsp;FROM&nbsp;`&quot;</font><font color="#666666">.</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table_name</font><font color="#666666">.</font><font color="#BA2121">&quot;`&quot;</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">max_page</font><font color="#666666">=</font><font color="#19177C">$max_page</font><font color="#666666">=</font><font color="#008000">ceil</font>(<font color="#19177C">$num</font><font color="#666666">/</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items_per_page</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#666666">!</font><font color="#19177C">$page</font>)&nbsp;<font color="#19177C">$page</font><font color="#666666">=1</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#19177C">$page</font><font color="#666666">&gt;</font><font color="#19177C">$max_page</font>)&nbsp;<font color="#19177C">$page</font><font color="#666666">=</font><font color="#19177C">$max_page</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#19177C">$max_page</font><font color="#666666">&gt;1</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$page_line</font><font color="#666666">=</font><font color="#BA2121">&#39;&lt;div&nbsp;class=pages&gt;&#39;</font><font color="#666666">.</font>make_pages(<font color="#19177C">$page</font>,<font color="#19177C">$max_page</font>,<font color="#BA2121">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</font>,<font color="#BA2121">&quot;&amp;nbsp;&lt;a&nbsp;href=&#39;?module=board&amp;action=view_adverts&amp;page=%1</font><font color="#BB6622"><strong>\$</strong></font><font color="#BA2121">s&#39;&gt;%1</font><font color="#BB6622"><strong>\$</strong></font><font color="#BA2121">s&lt;/a&gt;&amp;nbsp;&quot;</font>,<font color="#666666">2</font>)<font color="#666666">.</font><font color="#BA2121">&#39;&lt;/div&gt;&#39;</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">order</font><font color="#666666">=</font><font color="#19177C">$order</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">page</font><font color="#666666">=</font><font color="#19177C">$page</font>;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//задаем&nbsp;ширину&nbsp;столбцов
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$widths</font><font color="#666666">=</font>array_one_dimension(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>,<font color="#BA2121">&#39;name&#39;</font>,<font color="#BA2121">&#39;width&#39;</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">call_user_func_array</font>(<font color="#008000"><strong>array</strong></font>(<font color="#666666">&amp;</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font>,&nbsp;<font color="#BA2121">&quot;set_widths&quot;</font>),<font color="#19177C">$widths</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//установка&nbsp;параметров&nbsp;для&nbsp;столбцов
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>foreach</strong></font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>&nbsp;<font color="#008000"><strong>as</strong></font>&nbsp;<font color="#19177C">$coldata</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$additions</font>[]&nbsp;<font color="#666666">=</font>&nbsp;get_var(<font color="#BA2121">&#39;addition&#39;</font>,<font color="#19177C">$coldata</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$footers</font>[]&nbsp;&nbsp;&nbsp;<font color="#666666">=</font>&nbsp;get_var(<font color="#BA2121">&#39;footer&#39;</font>,<font color="#19177C">$coldata</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">call_user_func_array</font>(<font color="#008000"><strong>array</strong></font>(<font color="#666666">&amp;</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font>,&nbsp;<font color="#BA2121">&quot;set_addition&quot;</font>),<font color="#19177C">$additions</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//получаем&nbsp;и&nbsp;добавляем&nbsp;данные&nbsp;в&nbsp;таблицу
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items</font><font color="#666666">=</font>DB<font color="#666666">::</font><font color="#7D9029">Fast_Arr_Query</font>(<font color="#BA2121">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;`</font><font color="#BB6688"><strong>{</strong></font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table_name</font><font color="#BB6688"><strong>}</strong></font><font color="#BA2121">`&nbsp;&quot;</font><font color="#666666">.</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#BA2121">&quot;ORDER&nbsp;BY&nbsp;`</font><font color="#BB6688"><strong>$order</strong></font><font color="#BA2121">`&nbsp;&quot;</font><font color="#666666">.</font>(<font color="#19177C">$desc</font><font color="#666666">?</font><font color="#BA2121">&#39;DESC&nbsp;&#39;</font><font color="#666666">:</font><font color="#BA2121">&#39;&#39;</font>)<font color="#666666">.</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#BA2121">&quot;LIMIT&nbsp;&quot;</font><font color="#666666">.</font>(<font color="#19177C">$page</font><font color="#666666">-1</font>)<font color="#666666">*</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items_per_page</font><font color="#666666">.</font><font color="#BA2121">&#39;,&nbsp;&#39;</font><font color="#666666">.</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items_per_page</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items</font><font color="#666666">=</font>make_id_array(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items</font>,<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">key_col</font>,<font color="#666666">0</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//добавление&nbsp;строк&nbsp;в&nbsp;таблицу
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>foreach</strong></font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">items</font>&nbsp;<font color="#008000"><strong>as</strong></font>&nbsp;<font color="#19177C">$id</font><font color="#666666">=&gt;</font><font color="#19177C">$item</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$cols</font><font color="#666666">=</font><font color="#008000"><strong>array</strong></font>();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>foreach</strong></font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>&nbsp;<font color="#008000"><strong>as</strong></font>&nbsp;<font color="#19177C">$colname</font><font color="#666666">=&gt;</font><font color="#19177C">$coldata</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$function_name</font><font color="#666666">=</font><font color="#19177C">$coldata</font>[<font color="#BA2121">&#39;handler&#39;</font>];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#008000">is_callable</font>(<font color="#19177C">$function_name</font>))
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$cols</font>[]<font color="#666666">=</font><font color="#008000">call_user_func</font>(<font color="#19177C">$function_name</font>,&nbsp;<font color="#19177C">$id</font>,&nbsp;(<font color="#008000">isset</font>(<font color="#19177C">$item</font>[<font color="#19177C">$colname</font>])<font color="#666666">?</font><font color="#19177C">$item</font>[<font color="#19177C">$colname</font>]<font color="#666666">:</font><font color="#BA2121">&#39;&#39;</font>),<font color="#19177C">$item</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>else</strong></font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$cols</font>[]<font color="#666666">=</font><font color="#19177C">$item</font>[<font color="#19177C">$colname</font>];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">call_user_func_array</font>(<font color="#008000"><strong>array</strong></font>(<font color="#666666">&amp;</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font>,&nbsp;<font color="#BA2121">&quot;add_row&quot;</font>),<font color="#19177C">$cols</font>);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#408080"><em>//добавление&nbsp;заглавной&nbsp;строки&nbsp;в&nbsp;таблицу
</em></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$cols</font><font color="#666666">=</font><font color="#008000"><strong>array</strong></font>();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>foreach</strong></font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">cols</font>&nbsp;<font color="#008000"><strong>as</strong></font>&nbsp;<font color="#19177C">$colname</font><font color="#666666">=&gt;</font><font color="#19177C">$coldata</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$title</font><font color="#666666">=</font><font color="#19177C">$coldata</font>[<font color="#BA2121">&#39;title&#39;</font>];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#19177C">$coldata</font>[<font color="#BA2121">&#39;is_ordered&#39;</font>])
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$title</font><font color="#666666">=</font><font color="#BA2121">&quot;&lt;a&nbsp;href=&#39;</font><font color="#BB6688"><strong>{</strong></font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">link</font><font color="#BB6688"><strong>}</strong></font><font color="#BA2121">&amp;order=</font><font color="#BB6688"><strong>$colname</strong></font><font color="#BA2121">&amp;desc=1&#39;&gt;v&lt;/a&gt;&quot;</font><font color="#666666">.</font><font color="#19177C">$title</font><font color="#666666">.</font><font color="#BA2121">&quot;&lt;a&nbsp;href=&#39;</font><font color="#BB6688"><strong>{</strong></font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">link</font><font color="#BB6688"><strong>}</strong></font><font color="#BA2121">&amp;order=</font><font color="#BB6688"><strong>$colname</strong></font><font color="#BA2121">&#39;&gt;^&lt;/a&gt;</font><font color="#BB6622"><strong>\n</strong></font><font color="#BA2121">&quot;</font>;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$cols</font>[]<font color="#666666">=</font><font color="#19177C">$title</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">call_user_func_array</font>(<font color="#008000"><strong>array</strong></font>(<font color="#666666">&amp;</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font>,&nbsp;<font color="#BA2121">&quot;add_head_row&quot;</font>),<font color="#19177C">$cols</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">call_user_func_array</font>(<font color="#008000"><strong>array</strong></font>(<font color="#666666">&amp;</font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font>,&nbsp;<font color="#BA2121">&quot;add_foot_row&quot;</font>),<font color="#19177C">$footers</font>);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">link</font><font color="#666666">.=</font><font color="#BA2121">&quot;&amp;order=</font><font color="#BB6688"><strong>$order</strong></font><font color="#BA2121">&amp;desc=</font><font color="#BB6688"><strong>$desc</strong></font><font color="#BA2121">&quot;</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>function</strong></font>&nbsp;<font color="#0000FF">print_table</font>(){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">max_page</font><font color="#666666">&gt;1</font>){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#19177C">$page_line</font><font color="#666666">=</font><font color="#BA2121">&#39;&lt;div&nbsp;class=pages&gt;&#39;</font><font color="#666666">.</font>make_pages(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">page</font>,<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">max_page</font>,<font color="#BA2121">&quot;&amp;nbsp;[%s]&amp;nbsp;&quot;</font>,<font color="#BA2121">&quot;&amp;nbsp;&lt;a&nbsp;href=&#39;</font><font color="#BB6688"><strong>{</strong></font><font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">link</font><font color="#BB6688"><strong>}</strong></font><font color="#BA2121">&amp;page=%1</font><font color="#BB6622"><strong>\$</strong></font><font color="#BA2121">s&#39;&gt;%1</font><font color="#BB6622"><strong>\$</strong></font><font color="#BA2121">s&lt;/a&gt;&amp;nbsp;&quot;</font>,<font color="#666666">2</font>)<font color="#666666">.</font><font color="#BA2121">&#39;&lt;/div&gt;&#39;</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>print</strong></font>&nbsp;<font color="#19177C">$page_line</font>;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>print</strong></font>&nbsp;<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">table</font><font color="#666666">-&gt;</font><font color="#7D9029">generate</font>();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>if</strong></font>&nbsp;(<font color="#19177C">$this</font><font color="#666666">-&gt;</font><font color="#7D9029">max_page</font><font color="#666666">&gt;1</font>)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000"><strong>print</strong></font>&nbsp;<font color="#19177C">$page_line</font>;
&nbsp;&nbsp;&nbsp;&nbsp;}

}

<font color="#BC7A00">?&gt;</font>
</code></blockquote><p><font color="gray">Colored with <a href="http://dumpz.org">dumpz.org</a></p>