The alter sql file can now have the following extra line:
INSERT INTO `0_sys_prefs`(`name`,`category`,`type`,`length`,`value`) VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
The alter sql file can now have the following extra line:
INSERT INTO `0_sys_prefs`(`name`,`category`,`type`,`length`,`value`) VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');Yes, the function check_write() in includes/main.inc should cover the lang folder check as well.
In install/index.php mustn't there be a check to see if lang folder is writeable?
if (!file_exists($path_to_root . "/lang/installed_languages.inc")) {
$installed_languages = array (
0 => array ('code' => 'C', 'name' => 'English', 'encoding' => 'iso-8859-1'));
$dflt_lang = 'C';
write_lang();
}OK!
@Janusz
The empty.po (and other language files possibly) have your dev machine path set like
#: /home/janusz/FA/fa_stable/Repo/srcs/2.3/requisitions/_devel/../hooks.php:16 Very extensive work indeed. Congrats.
@Janusz
You're right. I'll post the actual changes in another extension in another post. The attachment was a jumble up of an extension that was in the process of testing the parameters. The extension name change to Item Sales Summary Report may have been appropriate in the light of a similarly named one in the Customer Reports.
@Janusz
Thanks for the error correction. I'll post the actual changes in another extension in another post. The attachment was a jumble up of an extension that was in the process of testing the parameters.
@flort
The effective correction is to the sql in the rep_sales_summary.php at line 41:
".TB_PREF."debtor_trans_details.quantityequivalently changed to
SUM(".TB_PREF."debtor_trans_details.quantity) AS quantityand with aliases in actual code now being
SUM(line.quantity) as quantitySince there is already a standard report by the same name under Customer Reports, it may have been better to name this report as Item Sales Summary Report.
Wikied the screenshots of both reports:
Please be specific.
What is the sequence of menu options
Which version of FA
In what browser and version
did the issue arise?
On your annotations, let us address them one at a time:
Need to address Row Alignment:
You have missed out a blank array element at the last:
Lines 144-146 in sales/includes/ui/sales_order_ui.inc
$th = array(_("Item Code"), _("Item Description"), _("Quantity"),
_("Delivered"),
_("Unit"), $order->tax_included ? _("Price after Tax") : _("Price before Tax"), _("Discount %"), _("Total"), "");For you should be:
$th = array(_("Confirmation"), _("Source"), _("Avg Rate"),
_("Stay"),
_("Gross"), $order->tax_included ? _("Our Charge") : _("Price before Tax"), _("GDS"), _("Total"),"");Check if you also need to increase the col span for the other rows at line 225 (of the original file):
$colspan = 6;to be
$colspan = 7;Could be default variables injected for Quick Entries or specific instance of certain voucher entry types for invoices.
The stated code appears only once and it is in the function sales_order_item_controls() in the file sales/includes/ui/sales_order_ui.inc.
It is used for Ajax requests for dynamic form population from previously entered values.
Some screenshots on your current invoice table can show what needs to be done - see that the arguments to the insert sql and the output of the form post variables match.
Attached a fresh Customer Sales Summary Extension for v2.3.13-1
You're right Janusz, but it is used in many places acceptably.
The said function is called in:
includes\current_user.inc
Line 613: function flush_dir($path, $wipe = false)
Line 621: flush_dir($path.'/'.$fname, $wipe);
includes\packages.inc
Line 29: // flush_dir($basedir, true);
Line 102: flush_dir($targetdir, true);
Line 428: flush_dir(PKG_CACHE_PATH.'/'.$name, true);
includes\lang\language.php Line 59: flush_dir(company_path().'/js_cache');
admin\db\company_db.inc Line 92: flush_dir(company_path().'/js_cache'); // clear cache
admin\inst_theme.php Line 55: flush_dir($dirname, true);
admin\inst_lang.php Line 256: flush_dir($dirname, true);
admin\display_prefs.php Line 51: flush_dir(company_path().'/js_cache');
admin\create_coy.php Line 226: @flush_dir($tmpname, true);
The function can be altered to reflect the hg repo files since CVS is no longer used:
function flush_dir($path, $wipe = false)
{
$dir = opendir($path);
if(!$dir)
return;
while(false !== ($fname = readdir($dir))) {
if($fname=='.' || $fname=='..' || $fname=='CVS' || (!$wipe && $fname=='index.php')) continue;
if(is_dir($path.'/'.$fname)) {
flush_dir($path.'/'.$fname, $wipe);
if ($wipe) @rmdir($path.'/'.$fname);
} else
@unlink($path.'/'.$fname);
}
}Wikiied it.
Maybe the specific IIS install uses Basic Auth by default and needs to be turned off. Thanks Janusz.
It is actually on the "not-safe side" unless we try to delete a non existant folder which is covered by the "if" check.
The said library file has been used in numerous open source projects and not even in one of them is it commented out.
Some projects it is in use are:
LifeType
OntoWiki
ZenPhoto
Automne-CMS
b2evolution
Wikiied as a prequisite for installation.
Which version are you using?
Try the latest Mercurial v2.3.13 Build 3122 attached.
In the file admin/inst_module.php, shouldn't the line 116
$is_mod = $ext['type'] == 'module';be
$is_mod = $ext['type'] == 'extension';Better still, have the line removed as the $is_mod variable is not used anywhere at all.
In the file includes/ui/ui_lists.inc, shouldn't the line 2213
if ($ext['type'] == 'module' && !$ext['active'])
$tabs[$ext['tab']] = access_string($ext['title'], true);be
if ($ext['type'] == 'extension' && !$ext['active'])
$tabs[$ext['tab']] = access_string($ext['title'], true);Also the subsequent line refers to the $ext['tab'] variable coming from $installed_extensions array that has been commented out in includes/packages.inc file in lines 128, 494, 671-672.
On a similar note, consequent to the gross changes in the extensions / plugins system in FA v2.3+, the file sql/alter2.3.php has the line 297 as part of a commented out block.
check apache error logs for issues and hints to where typos may exist.
@kusuma
Unless you are up to programming PHP it is better to go with supported programs like AntERP - @tclim has provided several plugins, contributed enough code and is knowledgeable in FA - you are likely to find his products fit in well with FA. Likewise other SOAP proponents too can provide support and LogicWorks can tailor it for FA being a fork, though does not say so online.
FA uses the PHP mail() function to send mail.
There are other mature libraries like PHPMailer that have a host of options including SMTP relaying enabling you to use hotmail / gmail / yahoo mail to send out your emails but you need to patch them in or create a module for it.
Please read the PHP mail() function and the comments there in to configure your Windows box to relay mail.
When using the PHP mail() function with IIS 6 on Windows Server 2003, check your "Relay" settings on the SMTP Virtual Server in IIS. If you grant access to 127.0.0.1 and set then set your php.ini SMTP to the same IP address (along with setting the same port 25), you should have success in sending mail.
Allocations appears on both sides of the website's first 2 column feature list summary.
Commercial applications that interface with FrontAccounting are AntErp and Logicworks CounterLogic.
Roll your own using any of the Restful APIs - check out the SipleAPI Module and others on the Wiki and / or contact Support.
Ref - MS KB and Troubleshooting IIS.
Check if the .htaccess file is being used or set it's equivalent in the IIS so that Basic Authentication error will go off.
Installed the Debian Archiver using apt-get install binutils. This makes the ar binary available.
Installed the Sales Summary Report Extension from the default Repo and made corrections to the files in modules/rep_sales_summary. Now try to re-package it after setting the correct sha1sums.
The following does not produce FA compatible pkg from the above already installed one:
cd /var/www/frontac/modules/rep_sales_summary
ar rcs ../rep_sales_summary-2.3.3-1.pkg \
../_cache/rep_sales_summary-2.3.3-1/_init/config \
../_cache/rep_sales_summary-2.3.3-1/_init/files \
index.php \
reporting/index.php \
reporting/rep_sales_summary.php \
reporting/reports_custom.phpFrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.