<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Report Generator]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=836&amp;type=atom" />
	<updated>2009-11-10T21:17:40Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=836</id>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3845#p3845" />
			<content type="html"><![CDATA[<p>Hack so far - still insert, edit and delete do not work.</p><p>The last part of the repgen_strings.php now stands as:</p><p>$k = 0;&nbsp; &nbsp;// line-number (for row color)<br />$kk = 0; // For input field name serial<br />while (list ($key,$val) = each($rec_ar))<br />{<br />&nbsp; &nbsp; $h = explode(&quot;|&quot;,$val);<br />&nbsp; &nbsp; for ($i = 0; $i &lt; 16; $i++)<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; if (!isset($h[$i]))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $h[$i] = &quot;&quot;;<br />&nbsp; &nbsp; }<br />&nbsp; &nbsp; $it_typ=$h[0];<br />&nbsp; &nbsp; $it_art = $h[1];<br />&nbsp; &nbsp; $it_font = $h[2];<br />&nbsp; &nbsp; $it_fontsize = $h[3];<br />&nbsp; &nbsp; $it_number = $h[4];<br />&nbsp; &nbsp; $it_x1 = $h[5];<br />&nbsp; &nbsp; $it_y1 = $h[6];<br />&nbsp; &nbsp; if (in_array($it_typ, array(&quot;String&quot;,&quot;DB&quot;,&quot;Term&quot;,&quot;Block&quot;,&quot;Textarea&quot;)))<br />&nbsp; &nbsp; &nbsp; &nbsp; $it_str = $h[7];<br />&nbsp; &nbsp; $it_ord = $h[8];<br />&nbsp; &nbsp; $it_from = $h[10];<br />&nbsp; &nbsp; $it_to = $h[11];<br />&nbsp; &nbsp; $it_total = $h[12];<br />&nbsp; &nbsp; $it_o_score = $h[13];<br />&nbsp; &nbsp; $it_u_score = $h[14];<br />&nbsp; &nbsp; $it_bold = $h[15];</p><p> &nbsp; &nbsp; // &lt;!-- existing items --&gt;<br />&nbsp; &nbsp; <br />&nbsp; &nbsp; $hiddenattrs&nbsp; = hidden(&quot;id1&quot;, $id_new, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;attrib&quot;, $val, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;id_new&quot;, $id_new, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;sql&quot;, $sql, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;long&quot;, $long, false);</p><p>&nbsp; &nbsp; alt_table_row_color($k);<br />&nbsp; &nbsp; label_cell($it_typ);<br /> &nbsp; &nbsp; label_cell($it_art);<br /> &nbsp; &nbsp; label_cell($it_font);<br /> &nbsp; &nbsp; label_cell($it_fontsize);<br /> &nbsp; &nbsp; label_cell($it_ord);<br /> &nbsp; &nbsp; label_cell($it_number);<br /> &nbsp; &nbsp; label_cell($it_x1);<br /> &nbsp; &nbsp; label_cell(($it_y1 != &quot;&quot; ? $it_y1 : &quot;.&quot;));<br />&nbsp; &nbsp; label_cell(($it_total != &quot;&quot; ? $it_total : &quot;.&quot;));<br />&nbsp; &nbsp; if (in_array($it_typ, array(&quot;Line&quot;,&quot;Rectangle&quot;)))<br />&nbsp; &nbsp; &nbsp; &nbsp; label_cell(&quot;.&quot;);<br />&nbsp; &nbsp; else<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; if (!(empty($it_from) || empty($it_to)))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; label_cell($it_str.&quot;(&quot;.$it_from.&quot;-&quot;.$it_to.&quot;)&quot;);<br />&nbsp; &nbsp; &nbsp; &nbsp; else<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; label_cell($it_str);<br />&nbsp; &nbsp; }<br />&nbsp; &nbsp; if (in_array($it_typ,array(&quot;String&quot;,&quot;DB&quot;,&quot;Term&quot;,&quot;Block&quot;,&quot;Textarea&quot;)))<br />&nbsp; &nbsp; &nbsp; &nbsp; $editbutton = submit(&quot;alter&quot;, CHANGE, false);<br />&nbsp; &nbsp; else<br />&nbsp; &nbsp; &nbsp; &nbsp; $editbutton = &quot; &quot;;<br />&nbsp; &nbsp; echo &quot;&lt;td&gt;\n&quot;;<br />&nbsp; &nbsp; start_form(false, false, &quot;repgen_strings.php?report_type=&quot;.$report_type, &quot;edit&quot;);<br />&nbsp; &nbsp; echo $hiddenattrs . $editbutton . submit(&quot;delete&quot;, DELETE, false);<br />&nbsp; &nbsp; end_form();<br />&nbsp; &nbsp; echo &quot;&lt;/td&gt;\n&quot;;<br />&nbsp; &nbsp; end_row();<br />&nbsp; &nbsp; $kk++;<br />}&nbsp; // end of while</p><p>end_table(1);</p><p>end_page();<br />?&gt;</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T21:17:40Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3845#p3845</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3844#p3844" />
			<content type="html"><![CDATA[<p>As there is no Primary Key field in the xx_reports table, even DELETION will not work reliably if it does work at all.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T21:13:26Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3844#p3844</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3843#p3843" />
			<content type="html"><![CDATA[<p>Both files: /modules/repgen/repgen_strings.php and repgen_graphics.php do not have any UPDATE / REPLACE SQL query for case=&quot;alter&quot; and hence no updations occur. Hence we will have to manually enter the item values into the table for now.</p><p>The repgen_graphics.php uses the $k row variable for the &quot;edit&quot; form names and this alternates between 0 and 1 as it is used for alternate row colors. Another variable should be used to serially number the form name like edit1, edit2, etc. This is totally absent in repgen_strings.php.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T21:11:16Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3843#p3843</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3842#p3842" />
			<content type="html"><![CDATA[<p>It would be nice if this board enables file attachments.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T20:05:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3842#p3842</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3841#p3841" />
			<content type="html"><![CDATA[<p>For a start, I have done some code cleanup for /modules/repgen/repgen_strings.php by bringing all form elements into one cell for each record. They just have the same name for each record&#039;s form.</p><p>The last empty column after &quot;Action&quot; is removed in Line 602 by replacing:<br />$th = array(IT_TYP, IT_ART, IT_FONT, IT_FONT_SIZE, IT_ORD, IT_LEN, IT_X1, IT_Y1, &quot;Total&quot;, IT_STRING, &quot;Action&quot;, &quot;&quot;);<br />with<br />$th = array(IT_TYP, IT_ART, IT_FONT, IT_FONT_SIZE, IT_ORD, IT_LEN, IT_X1, IT_Y1, &quot;Total&quot;, IT_STRING, &quot;Action&quot;);</p><br /><p>Then replace the snippet from &quot;existing items&quot; till &quot;end of while&quot; with:</p><p>// &lt;!-- existing items --&gt;</p><p>&nbsp; &nbsp; $hiddenattrs&nbsp; = hidden(&quot;id1&quot;, $id_new, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;attrib&quot;, $val, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;id_new&quot;, $id_new, false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;sql&quot;, $sql,false);<br />&nbsp; &nbsp; $hiddenattrs .= hidden(&quot;long&quot;, $long, false);<br />&nbsp; &nbsp; <br />&nbsp; &nbsp; alt_table_row_color($k);<br /> &nbsp; &nbsp; label_cell($it_typ);<br /> &nbsp; &nbsp; label_cell($it_art);<br /> &nbsp; &nbsp; label_cell($it_font);<br /> &nbsp; &nbsp; label_cell($it_fontsize);<br /> &nbsp; &nbsp; label_cell($it_ord);<br /> &nbsp; &nbsp; label_cell($it_number);<br /> &nbsp; &nbsp; label_cell($it_x1);<br /> &nbsp; &nbsp; label_cell(($it_y1 != &quot;&quot; ? $it_y1 : &quot;.&quot;));<br />&nbsp; &nbsp; label_cell(($it_total != &quot;&quot; ? $it_total : &quot;.&quot;));<br />&nbsp; &nbsp; if (in_array($it_typ, array(&quot;Line&quot;,&quot;Rectangle&quot;)))<br />&nbsp; &nbsp; &nbsp; &nbsp; label_cell(&quot;.&quot;);<br />&nbsp; &nbsp; else<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; if (!(empty($it_from) || empty($it_to)))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; label_cell($it_str.&quot;(&quot;.$it_from.&quot;-&quot;.$it_to.&quot;)&quot;);<br />&nbsp; &nbsp; &nbsp; &nbsp; else<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; label_cell($it_str);<br />&nbsp; &nbsp; }<br />&nbsp; &nbsp; if (in_array($it_typ,array(&quot;String&quot;,&quot;DB&quot;,&quot;Term&quot;,&quot;Block&quot;,&quot;Textarea&quot;)))<br />&nbsp; &nbsp; &nbsp; &nbsp; $editbutton = submit(&quot;alter&quot;, CHANGE, false);<br />&nbsp; &nbsp; else<br />&nbsp; &nbsp; &nbsp; &nbsp; $editbutton = &quot; &quot;;<br />&nbsp; &nbsp; echo &quot;&lt;td&gt;\n&quot;;<br />&nbsp; &nbsp; start_form(false, false, &quot;repgen_strings.php?report_type=&quot;.$report_type, &quot;edit&quot;);<br />&nbsp; &nbsp; echo $hiddenattrs . $editbutton . submit(&quot;delete&quot;, DELETE, false);<br />&nbsp; &nbsp; end_form();<br />&nbsp; &nbsp; echo &quot;&lt;/td&gt;\n&quot;;</p><p>&nbsp; &nbsp; end_row();<br />&nbsp; &nbsp; <br />}&nbsp; // end of while</p><br /><p>The form URL is still suspect - the $report_type variable in the submit url may cause problems with the other POST variables.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T20:02:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3841#p3841</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3840#p3840" />
			<content type="html"><![CDATA[<p>A new report can be created but items cannot be added. The EDIT and INSERT are broken.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T19:54:52Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3840#p3840</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3838#p3838" />
			<content type="html"><![CDATA[<p>The above colon typo applies to Lines 259 and 300&nbsp; in /modules/repgen/repgen_graphics.php as well.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T17:29:34Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3838#p3838</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3837#p3837" />
			<content type="html"><![CDATA[<p>Lines 653 and 680 have typos:<br />&nbsp; &nbsp; echo &quot;&lt;td style=&#039;width;0px;display:none;&#039;&gt;\n&quot;;<br />should be<br />&nbsp; &nbsp; echo &quot;&lt;td style=&#039;width:0px;display:none;&#039;&gt;\n&quot;;</p><p>The semicolon (;) after &quot;width&quot; should be a colon (:).</p><p>This still does not as yet solve the problem.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T17:25:39Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3837#p3837</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3836#p3836" />
			<content type="html"><![CDATA[<p>Refer file /modules/repgen/repgen_strings.php :-</p><p>Line 654 is the &quot;start_form&quot; statement and it is inside a cell of a table and PHP decides to auto close the form within the cell itself. Hence the Line 681 which is the actual &quot;end_form()&quot; does not get used where intended.</p><p>The start_form() and end_form() statements must be outside of the row cells showing the current Page String Records to be effectve. If each record is in a table of it&#039;s own, it will be effective.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T17:17:01Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3836#p3836</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3835#p3835" />
			<content type="html"><![CDATA[<p>Tested repgen on FA v2.1.6 and v2.1.7 and it installed flawlessly with no changes at all.</p><p>Logged in as Admin in the Company 0 (default) and was able to see the default reports. </p><p>When we try to EDIT any of the 3 default reports <br />and then we go to the &quot;Page definition for Strings&quot;, <br />we are unable to edit any record in the &quot;Table of Stored Items&quot; there.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2009-11-10T16:34:58Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3835#p3835</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3663#p3663" />
			<content type="html"><![CDATA[<p>I am beginning to get repgen to work ( v2.1.5 of FA ). I needed to fix :</p><p>A) Security Level in module install<br />- security level on inst_module.php. As installed it is set to $page_security = 20;;however the&nbsp; whilst security level in config.php as installed are <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; array(1,2),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,20),<br />and despite logging in as administrator ( and the screen showing administrator it refused me access<br />correcting this to $page_security = 16; allowed the installation routine to work.</p><p>Have I discovered a bug or a feature? as I understood these arrays related to inquiries,accountant,administrator respectively and therefore the admin should have security level 20.</p><p>B) Test of sql statement in repgen_create.php. On line 204 I added ?sql=$sql to the url to get rid of a SQL Statement is empty error. I note that the OpenWindow php function didn&#039;t set the method to GET or POST prior to the submit - </p><p>Enough for now...</p><p>Cheers</p><p>Vernon</p>]]></content>
			<author>
				<name><![CDATA[vernonr]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=322</uri>
			</author>
			<updated>2009-10-15T15:37:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3663#p3663</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3456#p3456" />
			<content type="html"><![CDATA[<p>Set the variable, $go_debug, to 1 in the file config.php. That will tell you about the errors.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2009-09-15T12:42:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3456#p3456</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Report Generator]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3455#p3455" />
			<content type="html"><![CDATA[<p>Running the report generator after installation only gives a blank screen. All the files are in the repgen subdirectory in modules <br />Please advice</p>]]></content>
			<author>
				<name><![CDATA[restinc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=425</uri>
			</author>
			<updated>2009-09-15T11:49:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3455#p3455</id>
		</entry>
</feed>
