<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — In db_pager can we freeze first few columns]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8237&amp;type=atom" />
	<updated>2019-07-17T16:22:25Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8237</id>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35467#p35467" />
			<content type="html"><![CDATA[<p>Hi @anoopmb your suggestion worked like a charm. I prefer to customize the core aand load JS in the footer. </p><p>Thanks Alot you have saved a lot of hassle for me. </p><p>I would request @joe to add such features in the upcoming 2.5</p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-07-17T16:22:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35467#p35467</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35465#p35465" />
			<content type="html"><![CDATA[<p>hi,</p><p>You can use like this</p><div class="codebox"><pre><code>$js = &quot;alert(&#039;Hi&#039;)&quot;;

if (in_ajax()) {
    $Ajax-&gt;addScript(true, $js);
} else
    add_js_source($js);</code></pre></div><p>this code will retain after ajax also</p><p>if you are using any jquery plugin and your jquery is loaded in footer part of renderer</p><p>then you have to load the plugin in renderer after jquery (it will be loaded on all pages)</p><p>or you can customize the core and define a function to load javascript files in footer</p><p>add_js_ufile() function is there but it will load in header only</p>]]></content>
			<author>
				<name><![CDATA[anoopmb]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=18207</uri>
			</author>
			<updated>2019-07-17T08:09:39Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35465#p35465</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35461#p35461" />
			<content type="html"><![CDATA[<p>My js is yuk!...but my understanding of that SO post is $(document).ready() is already called somewhere else so you need something else to initialize it????????????????????????????????????????</p><p>The &#039;top&#039; answer seems like&nbsp; the one you want, it&#039;s in the comments...read 1 - 3 for that solution they had to replace the $(document).ready() to $(document).on... or something else in the third comment.</p><p>Hope that hasn&#039;t confused you more and you get it working</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2019-07-16T15:47:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35461#p35461</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35460#p35460" />
			<content type="html"><![CDATA[<p>Thanks @poncho1234 you have suggested a non javascript solution.</p><p>But still my question is that how to get the Jquery Function workable after Ajax Call. My problem is discussed <a href="https://stackoverflow.com/questions/16062899/jquery-doesnt-work-after-content-is-loaded-via-ajax">here</a>. I have tried them but could not find workable in FA.</p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-07-16T14:30:17Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35460#p35460</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35459#p35459" />
			<content type="html"><![CDATA[<p>Now I understand what you are looking for - if you are not totally committed to using js then:-</p><p>css only answer <a href="https://stackoverflow.com/questions/15811653/table-with-fixed-header-and-fixed-column-on-pure-css">here on stackoverflow</a> and <a href="https://stackoverflow.com/questions/46275555/scrollable-table-with-fixed-columns-and-header-with-modern-css"> here</a> using position: sticky;<br /><a href="https://caniuse.com/#feat=css-sticky">Can I use</a> lists all major browsers except as usual IE.</p><p>You may have to add auto scroll or similar to the table as well</p><p>Lots of answers on SO and other sites with googling &quot;freeze table header and columns css site:stackoverflow.com&quot;</p><p>For 1st five of anything use something like :nth-child(-n+5)</p><p>No js = no js conflicts</p><p>There are also a few minimal js solutions too using the same search as above</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2019-07-16T13:58:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35459#p35459</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35458#p35458" />
			<content type="html"><![CDATA[<p>Hello friends, need support on this</p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-07-16T13:00:39Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35458#p35458</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35443#p35443" />
			<content type="html"><![CDATA[<p>I have successfully implemented <a href="https://www.jqueryscript.net/table/sticky-headers-columns-rwd-freeze-table.html">this jquery solution</a> for column and header freeze.</p><p>But I am stuck that once a page is reloaded due to Ajax Call then the following Jquery Function at the bottom of the page is not called.</p><div class="codebox"><pre><code>&lt;script&gt;
$(document).ready(function() {

  $(&quot;.table-scrollable&quot;).freezeTable({
    &#039;scrollable&#039;: true,
        &#039;columnNum&#039; : 5,

  });

});
&lt;/script&gt;</code></pre></div>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-07-15T10:04:51Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35443#p35443</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[In db_pager can we freeze first few columns]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35283#p35283" />
			<content type="html"><![CDATA[<p>Hello, is it possible in FA to get first few columns freezed in db_pager_view?</p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2019-06-22T06:19:28Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35283#p35283</id>
		</entry>
</feed>
