BestBooks For WordPress originally was developed in Java, the original framework.
BestBooks For WordPress最初是使用Java开发的原始框架。
The goal behind Bestbooks is to provide an accounting application framework modelled
Bestbooks背后的目标是提供建模的会计应用程序框架
after common accounting terms (t-account,ledger,jornal) and the GAAP (Generally Accepted
遵循通用会计条款(t帐户,分类帐,主要货币)和GAAP(公认会计准则)
Accounting Principles) while providing open database connectivity.
会计原则),同时提供开放的数据库连接。
At the time,
当时,
accounting frameworks had a proprietary, closed database structure.
会计框架具有专有的封闭数据库结构。
The original Bestbooks
原始的Bestbooks
for Java has connectivity for multiple databases including MSSQL, DB2, Oracle and MySQL.
Java版具有与多个数据库(包括MSSQL,DB2,Oracle和MySQL)的连接性。 p>
BestBooks for WordPress started as a minimal accounting framework but with inspiration (not copy)
适用于WordPress的BestBooks最初是一个最小的会计框架,但具有启发性(不是副本)
from waveaccounting.com, BestBooks is becoming a full fledge accounting application.
来自waveaccounting.com的BestBooks正在成为功能完善的会计应用程序。 p>
BestBooks for WordPress has enough functionality that you can create
BestBooks for WordPress具有足以创建的功能
workable scripts that solve accounting problems.
解决会计问题的可行脚本。
You will be able to
您将能够
implement many of the accounting problems on the accounting
在会计中实施许多会计问题
learning website, http://www.simplestudies.com
学习网站http://www.simplestudies.com p>
Additional help from the excellent tutorials at https://www.keynotesupport.com/menu-accounting.shtml
https://www.keynotesupport.com/menu-accounting.shtml上的出色教程提供的其他帮助 p>
Arbitrary section
任意部分 h3>
Tables creation from SQL:
通过SQL创建表: p>
These tables are created automatically within the wordpress database
这些表是在wordpress数据库中自动创建的 p>
—
— p>
— Table structure for table Accounts
-表 Accounts code> p>的表结构For Network-aware configurations, aka WPMU
对于网络感知配置,又名WPMU p>
CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_accounts (
如果不存在,则创建表{$ wpdb-> base_prefix} bestbooks_accounts(
id tinyint(4) NOT NULL auto_increment,
id tinyint(4)非空auto_increment,
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
name varchar(50) NOT NULL default ”,
名称varchar(50)NOT NULL默认值”,
type varchar(20) NOT NULL default ”,
输入varchar(20)NOT NULL默认值”,
data varchar(25) NOT NULL default ”,
数据varchar(25)NOT NULL默认值”,
class varchar(255) NOT NULL default ”,
class varchar(255)NOT NULL default”,
PRIMARY KEY (id
)
主键( id code>)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1 p>
For non-Network-aware configurations,
对于非网络感知配置, p>
CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_accounts (
如果不存在,则创建表{$ wpdb-> prefix} bestbooks_accounts(
id tinyint(4) NOT NULL auto_increment,
id tinyint(4)非空auto_increment,
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
name varchar(50) NOT NULL default ”,
名称varchar(50)NOT NULL默认值”,
type varchar(20) NOT NULL default ”,
输入varchar(20)NOT NULL默认值”,
data varchar(25) NOT NULL default ”,
数据varchar(25)NOT NULL默认值”,
class varchar(255) NOT NULL default ”,
class varchar(255)NOT NULL default”,
PRIMARY KEY (id
)
主键( id code>)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1 p>
—
— p>
— Table structure for table Journal
-表 Journal code> p>的表结构For Network-aware configurations, aka WPMU
对于网络感知配置,又名WPMU p>
CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_journal (
如果不存在,则创建表{$ wpdb-> base_prefix} bestbooks_journal(
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
ref tinyint(4) NOT NULL default ‘0’,
ref tinyint(4)NOT NULL默认为'0',
account varchar(50) NOT NULL default ”,
帐户varchar(50)NOT NULL默认值”,
debit decimal(10,2) NOT NULL default ‘0.00’,
借方十进制(10,2)NOT NULL默认为'0.00',
credit decimal(10,2) NOT NULL default ‘0.00’
信用十进制(10,2)NOT NULL默认值'0.00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
)ENGINE = MyISAM DEFAULT CHARSET = latin1; p>
For non-Network-aware configurations,
对于非网络感知配置, p>
CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_journal (
如果不存在,则创建表{$ wpdb-> prefix} bestbooks_journal(
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
ref tinyint(4) NOT NULL default ‘0’,
ref tinyint(4)NOT NULL默认为'0',
account varchar(50) NOT NULL default ”,
帐户varchar(50)NOT NULL默认值”,
debit decimal(10,2) NOT NULL default ‘0.00’,
借方十进制(10,2)NOT NULL默认为'0.00',
credit decimal(10,2) NOT NULL default ‘0.00’
信用十进制(10,2)NOT NULL默认值'0.00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
)ENGINE = MyISAM DEFAULT CHARSET = latin1; p>
—
— p>
— Table structure for table Ledger
-表 Ledger code> p>的表结构For Network-aware configurations, aka WPMU
对于网络感知配置,又名WPMU p>
CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_ledger (
如果不存在,则创建表{$ wpdb-> base_prefix} bestbooks_ledger(
id tinyint(4) NOT NULL auto_increment,
id tinyint(4)非空auto_increment,
name varchar(255) NOT NULL default ”,
名称varchar(255)NOT NULL默认值”,
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
note varchar(255) NOT NULL default ”,
注意varchar(255)NOT NULL default”,
ref double NOT NULL default ‘0’,
ref double NOT NULL默认为“ 0”,
debit decimal(10,2) NOT NULL default ‘0.00’,
借方十进制(10,2)NOT NULL默认为'0.00',
credit decimal(10,2) NOT NULL default ‘0.00’,
信用小数(10,2)NOT NULL默认为'0.00',
balance decimal(10,2) NOT NULL default ‘0.00’,
余额小数(10,2)NOT NULL默认为'0.00',
type varchar(10) NOT NULL default ”,
输入varchar(10)NOT NULL默认值”,
PRIMARY KEY (id
)
主键( id code>)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1; p>
For non-Network-aware configurations,
对于非网络感知配置, p>
CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_ledger (
如果不存在,则创建表{$ wpdb-> prefix} bestbooks_ledger(
id tinyint(4) NOT NULL auto_increment,
id tinyint(4)非空auto_increment,
name varchar(255) NOT NULL default ”,
名称varchar(255)NOT NULL默认值”,
txdate date NOT NULL default ‘0000-00-00’,
txdate date NOT NULL默认为“ 0000-00-00”,
note varchar(255) NOT NULL default ”,
注意varchar(255)NOT NULL default”,
ref double NOT NULL default ‘0’,
ref double NOT NULL默认为“ 0”,
debit decimal(10,2) NOT NULL default ‘0.00’,
借方十进制(10,2)NOT NULL默认为'0.00',
credit decimal(10,2) NOT NULL default ‘0.00’,
信用小数(10,2)NOT NULL默认为'0.00',
balance decimal(10,2) NOT NULL default ‘0.00’,
余额小数(10,2)NOT NULL默认为'0.00',
type varchar(10) NOT NULL default ”,
输入varchar(10)NOT NULL默认值”,
PRIMARY KEY (id
)
主键( id code>)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;”;
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;”; p>
Testing:
测试: p>
Create a page with the following shortcode, [bestbooks-sample-1]
使用以下短代码[bestbooks-sample-1]创建一个页面
then check your database tables for the validation.
然后检查您的数据库表以进行验证。 p>
If you get an error, please report it!
如果遇到错误,请报告! p>
Credits
积分 h3>
We make honorable mention to anyone who helps make Bestbooks for WordPress a better plugin!
我们谨向任何帮助使Bestbooks for WordPress成为更好插件的人表示敬意! p>
Contact
联系 h3>
Support is provided at https://github.com/patrickingle/bestbooks/issues.
https://github.com/patrickingle/bestbooks/issues提供了支持。
You will require a free account on github.com
您将需要在github.com上有一个免费帐户 p>
Please contact presspage.entertainment@gmail.com or visit the above forum with questions, comments, or requests.
请联系presspage.entertainment@gmail.com或访问上面的论坛,以提出问题,评论或要求。 p>