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
@notrinos: Thanks. Fork my GitHub repo and include your extension and update it there and send in a pull request.
Replaced the said lines with:
$emp_id = $_POST['person_id'];
$from_date = DateTime::createFromFormat("m-d-Y H:i:s", $_POST['from_date']);
$to_date = DateTime::createFromFormat("m-d-Y H:i:s", $_POST['to_date']);Updated your extension and removed whitespaces and attached herein.
Migrating data from any string format especially the MySQL ANSI date format yyyy-mm-dd into MS Access Short Date format irrespective of the locale setting (m/d/Y or d/m/Y) is done using the DateValue(str DateAsString) function.
FA uses MySQL whilst many applications use MS Access. PHP on Windows allows for interfacing with both MySQL and MS Access. Attached herewith is the possible choice of PHP data connection strings for both MDB and ACCDB versions (2000 and 2007) of MS Access databases and sample usage PHP code to interface with it.
Those who run POS applications based on MS Access can use this means to interface with FA.
Further interfacing sample code is available in my GitHub repo.
Check Wiki.
Although the customer currency is set in the Customer management page (attached), when payment is made, it is generally into the company's main / default bank account and is available as a choice in the Customer Payment page. A possibly related post.
FA does not have the possibility to set the default bank account into which a customer's payment is credited. You can however check past payment bank account creditings of the said customer and use that as a default by customising the code.
From PHP 5.4 onwards, a new type of array syntax has been introduced amongst other changes.
<?php
$array = array(
"foo" => "bar",
"bar" => "foo",
);
// as of PHP 5.4
$array = [
"foo" => "bar",
"bar" => "foo",
];
?>If these libraries like PHPMailer, (as fixed in phpList) or other code snippets are going to be ported to FA for use in earlier versions of PHP than v5.4, then we will need to code them back to the earlier simple array() syntax.
The function user_company() is defined in includes/current_user.inc. Check if the said file exists. It may have been inadvertently been deleted or got corrupted (hard disk error). Take a dump of the html folder (web root) and compare with the original version you installed from and see if there are any files that are missing. Check with a filesize and date compare and beware of some false positives where some files may have been overwritten by extensions (rare) or customised.
It is also possible that on date change (next day), the session may ahve expired - cleare browser cache and try to login again or restart the webserver and try. What do the server logs show?
MySQL I expect has been restarted.
Which version of FA are you using?
Where did you take it from?
The latest versions are at:
FA 2.3.25+
FA 2.4RC1+
@notrinos: good work.Attached the same zip file without the MAC OS temp files. Updated file attached in a later post.
How? What assistance do you need? Any Irish users?
Disable the MySQL strict setting and restart MySQL. Later versions of MySQL do not like zero dates: 0000-00-00 and 0000-00-00 00:00:00.
Search your web server folder for error log files. In Windows XAMPP 1.7.3 / Apache it will generally be in WEBSERVER_FOLDER\apache\logs\error.log
You will need to build a custom extension for it in FA.
What version of Excel are you using? Does the OS have the necessary language installed? It works correctly in Excel 2007 atleast for English.
Please read @joe's post above (4th post). @randr and @seahawk have not provided their sql dumps for analysis.
Rebuilding indexes in FA is quite simple - drop the index and recreate it from the schema in the Chart of Accounts used.
Windows or Linux Server?
PHP/MySQL versions?
The discount % is stored as an integer in the database table. Attempting to put in a string with % in it will break FA. Make a module for it.
Please alter all flag fields:
`inactive` TINYINT(4) NOT NULL DEFAULT '0',to be:
`inactive` TINYINT(1) NOT NULL DEFAULT '0',The following should achieve it:
ALTER TABLE `0_departments` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_overtime` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_salaryscales` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_salary_structure` CHANGE `type` `type` TINYINT(1) NOT NULL COMMENT '0 for credit,1 for debit';Attached is the sql after above changes.
This has something to do solely with the code rendering the images - graphs. Check if there are any hard coded character sets used.
FA does not have any payment integration out of the box.
1. Roll your own extension for it or
2. Integrate FA with any POS software which has one or make/buy one for that.
Most Mobile Payment service providers would be happy to make it free for you to get traction for their business.
All or most reports in FA have the option of outputting in Excel.
All FA Reports can be customised (see the reporting/repXXX.php files) and new ones made.
Assume you are using a Windows desktop.
1. Install XAMPP for Windows.
2. Use a version that runs PHP 5.3.x, probably in the XAMPP v1.x series.
3. Install Frontaccounting after downloading the latest stable version into the XAMPP htdocs folder.
4. Refer the Wiki.
Since you are interested in the Chinese language, it would be best if you install the latest Chinese Language Extension and then take it from there. Each language used by FA must be an element in the $installed_languages array.
I have an example for the Tamil language in my repo (recently updated) you can use for reference.
Make a mockup of the final payslip printout pdf file and link it in here. We can then hammer out the tables needed. Highlight the data elements in different legend-ed colours for each of the following, data as pertinent to:
1. This pay slip instance only
2. All Pay Slips
3. This employee only
4. All such designations/pay scales
5. All such payment accounts
Only after the ERD as above is done, should we begin to make the module code and menu items.
QNAP can host multiple websites. Setup a joomla instance in the QNAP device and then ftp the FA files into it instead of the joomla file and folder structure.
Different Item Codes in FA and in the Vendor supplies are available for matching along with appropriate unit conversion factors. On the Customer side, the FA Item code holds and there is no mapping available. You will have to make a custom module/extension for it with a table that stores FA_Item_Code/Stock_ID, Customer_ID/Debtor_Master_ID, Customer_Item_ID, Customer_Unit(if different), Unit_Conversion_Factor(if different unit).
vQmod is an overhead that no production site would want unless you change themes frequently and have a need to do so.
"vQmod™" (aka Virtual Quick Mod) is an override system designed to avoid having to change core files. The concept is quite simple... Instead of making changes to the core files directly, the changes are created as xml search/replace script files. These script files are parsed during page load as each "source" core file is loaded with the "include" or "require" php functions. The source is then patched with the script file changes, and saved to a temp file. That temp file is then substituted for the original during execution. The original source file is never altered. This results in a "virtual" change to the core during execution without any actual modification to the core files.
Any such integration should be for future versions and that too in theme developer mode.
You can use either a hard coded approach (Quick and Dirty) or change the encoding of all the php files to be in the utf-8 character set.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.