FrontAccounting forum — Payroll extension for practice

Re: Payroll extension for practice

null@example.com (Isatoyin2) — Wed, 14 Aug 2019 17:43:42 +0000

Problem solved. Thank you

Re: Payroll extension for practice

null@example.com (notrinos) — Wed, 14 Aug 2019 16:54:57 +0000

The error message pointed out how to solve your problem

SQL script execution failed in line 2: Erreur de syntaxe près de ') ENGINE=InnoDB' à la ligne 19

Please remove the last comma in the SQL script

Re: Payroll extension for practice

null@example.com (Isatoyin2) — Wed, 14 Aug 2019 15:27:49 +0000

Hello all esteem members.

Following the steps on this topic, I have been a able to write and install a module. But when I add update.sql file, I got this errors while re-installing the module again:

(SQL script execution failed in line 2: Erreur de syntaxe près de ') ENGINE=InnoDB' à la ligne 19)
(Status change for some extensions failed.)

I was able to re-install when I commented out as follow:

function activate_extension($company, $check_only=true) {
global $db_connections;

// $updates = array( 'update.sql' => array('sharehold'));

return $this->update_databases($company, $updates, $check_only);
}

-------------------------------------update.sql---------------------

DROP TABLE IF EXISTS `0_shareholder`;
CREATE TABLE IF NOT EXISTS `0_shareholder` (
`shd_id` int(11) NOT NULL AUTO_INCREMENT,
`shd_first_name` varchar(100) DEFAULT NULL,
`shd_last_name` varchar(100) DEFAULT NULL,
`gender` tinyint(1) NOT NULL DEFAULT '0',
`shd_address` tinytext,
`shd_mobile` varchar(30) DEFAULT NULL,
`shd_email` varchar(100) DEFAULT NULL,
`shd_birthdate` date NOT NULL,
`national_id` varchar(100) DEFAULT NULL,
`passport` varchar(100) DEFAULT NULL,
`bank_account` varchar(100) DEFAULT NULL,
`tax_number` varchar(100) DEFAULT NULL,
`shd_notes` tinytext NOT NULL,
`shd_hiredate` date DEFAULT NULL,
`shd_releasedate` date DEFAULT NULL,
`inactive` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`shd_id`),
) ENGINE=InnoDB;

-----------------------------------------------------------------------

Please help

Re: Payroll extension for practice

null@example.com (birender) — Thu, 27 Jul 2017 15:20:09 +0000

Good work

Re: Payroll extension for practice

null@example.com (notrinos) — Sat, 17 Jun 2017 11:12:39 +0000

Reorganized few places in the code and added printable payslip.

DOWNLOAD

Re: Payroll extension for practice

null@example.com (notrinos) — Tue, 04 Apr 2017 13:59:25 +0000

Ajmal, try to rename folder to payroll instead of Payroll

Re: Payroll extension for practice

null@example.com (Ajmal) — Tue, 04 Apr 2017 10:59:23 +0000

an error is shown as " modules/payroll/employee.php was not found on this server"
all is uploaded, and already in the server.
your guidance is appreciated...

Re: Payroll extension for practice

null@example.com (apmuthu) — Sun, 26 Mar 2017 07:55:27 +0000

Check if the attachment is okay and matches your current repo state.

Re: Payroll extension for practice

null@example.com (notrinos) — Sun, 26 Mar 2017 02:23:58 +0000

Fixed issue of attendance sheet display. Replace line 61 of inquiry/attendance_sheet.php with:

$cols["

".$day->format('d')."

"] = array('align'=>'center');

Re: Payroll extension for practice

null@example.com (boxygen) — Wed, 15 Feb 2017 06:57:38 +0000

Thats great I will test it and will respond.

Re: Payroll extension for practice

null@example.com (notrinos) — Fri, 10 Feb 2017 07:00:43 +0000

Added time attendance feature and mod payslip calculation based on timesheet DOWNLOAD

Re: Payroll extension for practice

null@example.com (apmuthu) — Sun, 05 Feb 2017 11:06:26 +0000

The file includes/packages.inc defines the function check_src_ext_version() and returns tru only if the package version >= application version. Here the latter is the FA version defined in line 9 of version.php as $src_version = "2.4.RC1"; and the former is the Payroll Module version. As your module is not packaged, there is no version number displayed in it's entry in installed_extensions.php file both in the webroot and in the company/#/ folder where you can manually make an entry for the version.

@joe: If no version is present like this for manually installed custom modules, the line 215 in admin/inst_modules.php:

            if (check_value('Active'.$i) && !check_src_ext_version($ext['version']))

can be modified to check the latter condition only if the $ext['version'] is not empty.

Re: Payroll extension for practice

null@example.com (notrinos) — Sat, 04 Feb 2017 14:08:13 +0000

boxygen wrote:

By the way while installing with 2.4RC1 I am receiving following error.
Package 'Payroll' is incompatible with current application version and cannot be activated. Check Install/Activate page for newer package version.
With 2.3.25 it installed successfully but had problem in accessing pages.

This solved on post #4

Re: Payroll extension for practice

null@example.com (boxygen) — Fri, 03 Feb 2017 16:49:46 +0000

By the way while installing with 2.4RC1 I am receiving following error.

Package 'Payroll' is incompatible with current application version and cannot be activated. Check Install/Activate page for newer package version.

With 2.3.25 it installed successfully but had problem in accessing pages.

Re: Payroll extension for practice

null@example.com (boxygen) — Fri, 03 Feb 2017 16:32:27 +0000

Oh yes I installed with 2.3.25.

I think 2.4 doesn't have stable release till now. Shouldn't you have it for 2.3.25 as well?

Regards