<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Integration with gridphp.com]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9559&amp;type=atom" />
	<updated>2022-01-07T00:08:26Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=9559</id>
		<entry>
			<title type="html"><![CDATA[Re: Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40452#p40452" />
			<content type="html"><![CDATA[<p>This is just html decoding ,</p><p>Is there any more detail like what happens when you try it html clean</p>]]></content>
			<author>
				<name><![CDATA[kvvaradha]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19348</uri>
			</author>
			<updated>2022-01-07T00:08:26Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40452#p40452</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40449#p40449" />
			<content type="html"><![CDATA[<p>In order to get GridPHP work in FA as expected I needed to comment out following line in session.inc</p><div class="codebox"><pre><code>html_cleanup($_GET);
html_cleanup($_POST);
// html_cleanup($_REQUEST);
html_cleanup($_SERVER);</code></pre></div><p>What could be the adverse affect of this?</p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2022-01-06T06:53:36Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40449#p40449</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40293#p40293" />
			<content type="html"><![CDATA[<p>Hello all,<br />I was able to integrate this.<br />Download gridphp.com and add it to the root folder of FA.</p><p>Copy the following code in the page where you want to show the Grid and set the $path_to_root with respect to the location of file.</p><div class="codebox"><pre><code>&lt;?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran &lt;gridphp@gmail.com&gt; - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */
 $page_security = &#039;SA_OPEN&#039;;
 $path_to_root=&quot;../..&quot;;
 include($path_to_root . &quot;/includes/session.inc&quot;);

add_css_file($path_to_root.&quot;/gridphp/lib/js/themes/redmond/jquery-ui.custom.css&quot;);
add_css_file($path_to_root.&quot;/gridphp/lib/js/jqgrid/css/ui.jqgrid.css&quot;);
add_js_ufile($path_to_root.&quot;/gridphp/lib/js/jquery.min.js&quot;);
add_js_ufile($path_to_root.&quot;/gridphp/lib/js/jqgrid/js/i18n/grid.locale-en.js&quot;);
add_js_ufile($path_to_root.&quot;/gridphp/lib/js/jqgrid/js/jquery.jqGrid.min.js&quot;);
add_js_ufile($path_to_root.&quot;/gridphp/lib/js/themes/jquery-ui.custom.min.js&quot;);

// include and create object
include_once ($path_to_root.&quot;/gridphp/lib/inc/jqgrid_dist.php&quot;);

$server = $db_connections[user_company()][&#039;host&#039;];
$user = $db_connections[user_company()][&#039;dbuser&#039;];
$password = $db_connections[user_company()][&#039;dbpassword&#039;];
$database = $db_connections[user_company()][&#039;dbname&#039;];

$db_conf = array(
                    &quot;type&quot;         =&gt; &#039;mysqli&#039;,
                    &quot;server&quot;     =&gt; $server,
                    &quot;user&quot;         =&gt; $user,
                    &quot;password&quot;     =&gt; $password,
                    &quot;database&quot;     =&gt; $database
                );


$g = new jqgrid($db_conf);

$grid[&quot;rowNum&quot;] = 10; // by default 20
$grid[&quot;sortname&quot;] = &#039;id&#039;; // by default sort grid by this field
$grid[&quot;caption&quot;] = &quot;Invoice Data&quot;; // caption of grid
$grid[&quot;autowidth&quot;] = false; // expand grid to screen width
$grid[&quot;multiselect&quot;] = true; // allow you to multi-select through checkboxes
$grid[&quot;form&quot;][&quot;position&quot;] = &quot;center&quot;;
$grid[&quot;shrinkToFit&quot;] = false;

$g-&gt;set_options($grid);

$g-&gt;set_actions(array(
                        &quot;add&quot;=&gt;true, // allow/disallow add
                        &quot;edit&quot;=&gt;true, // allow/disallow edit
                        &quot;delete&quot;=&gt;true, // allow/disallow delete
                        &quot;view&quot;=&gt;true, // allow/disallow delete
                        &quot;rowactions&quot;=&gt;true, // show/hide row wise edit/del/save option
                        &quot;search&quot; =&gt; &quot;advance&quot;, // show single/multi field search condition (e.g. simple or advance)
                        &quot;showhidecolumns&quot; =&gt; false
                    )
                );

$g-&gt;select_command = &quot;SELECT * FROM dimensions where id &lt; 85&quot;;

$g-&gt;table = &quot;dimensions&quot;;

// this db table will be used for add,edit,delete
$g-&gt;table = &quot;invheader&quot;;

// pass the cooked columns to grid
$g-&gt;set_columns($cols);

// generate grid output, with unique grid name as &#039;list1&#039;
$out = $g-&gt;render(&quot;list1&quot;);
page(_($help_context = &quot;Dimensions&quot;), false);
echo &#039;&lt;div style=&quot;margin:10px&quot;&gt;&#039;;
echo $out;
div_end();
end_page();
?&gt;</code></pre></div>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2021-11-25T04:53:38Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40293#p40293</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40274#p40274" />
			<content type="html"><![CDATA[<p>Lightweight <a href="http://www.ajaxcrud.com/">AjaxCRUD</a> is superb to integrate too.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2021-11-22T18:11:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40274#p40274</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40257#p40257" />
			<content type="html"><![CDATA[<p>Basically I don&#039;t have idea about gridphp. But it looks the entire fa html content comes in the alert.. So it looks you are looking the js wrong way.</p>]]></content>
			<author>
				<name><![CDATA[kvvaradha]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19348</uri>
			</author>
			<updated>2021-11-17T11:15:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40257#p40257</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Integration with gridphp.com]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40256#p40256" />
			<content type="html"><![CDATA[<p>Hello<br />I was trying to integrate gridphp.com in FA.</p><p>Facing this error. May be some JS is conflicting. Can anyone help?</p><p><a href="https://prnt.sc/1zvrs70">https://prnt.sc/1zvrs70</a></p>]]></content>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2021-11-17T08:48:12Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40256#p40256</id>
		</entry>
</feed>
