TikiWiki Mod details : features-cc

Back to list
This public repository lists the mods packages available from tikiwiki.org server. It's used by tikiwiki admins to update features that are not included in the public release of Tikiwiki. see TikiMods page on tw.o

features : cc

authorMichael Linton
Thomas Riemer
Les Squires
Mose
changelog1.3.8 fixed other_cpun things
1.3.7 fixed sorting and the all=1 thing, and more usability development
1.3.6 transaction reversion by registry owner, ledger sorting, headings, layouts
1.3.5 layout changes, prevent self credit transaction
1.3.4 added possibility to register an unlisted currency
1.3.3 added help link and transaction from currencies list
1 initial package
contributormlinton
descriptionMulti-currencies management system
devurlhttp://dev.openmoney.org/TikiCc
filescc.php
ccsp.php
cc-admin.php
modules/mod-my_ledger.php
templates/modules/mod-my_ledger.tpl
lib/cc/cclib.php
templates/cc/currencies.tpl
templates/cc/currencies_form.tpl
templates/cc/currency_admin.tpl
templates/cc/index.tpl
templates/cc/admin.tpl
templates/cc/ledgers.tpl
templates/cc/transactions.tpl
templates/cc/transactions_form.tpl
img/cc/cancel_transaction.png
img/cc/currency.png
img/cc/edit_c.png
img/cc/pending_register_c.png
img/cc/register_c.png
img/cc/transaction.png
img/cc/unregister_c.png
lastmodif2005-04-13 12:20:42
licenceGNU/LGPL
modnamefeatures-cc
namecc
revision1.3.10
sql_installcreate table if not exists cc_cc ( seq int not null auto_increment, id varchar(255) not null, cc_name varchar(255) not null, cc_description text, owner_id varchar(255), cpun varchar(255) default '' not null,requires_approval char(1) not null, listed char(1) not null default 'n', primary key seq (seq), index ( id(16),cpun(16) ), index ( cc_name(6) ));
create table if not exists cc_ledger ( seq int not null primary key auto_increment, acct_id varchar(255) null, l_cpun varchar(255) default '' not null, cc_id varchar(255) not null, balance int not null, tr_total int not null, tr_count int not null, last_tr_date int(11), approved char(1), index ( acct_id ), index ( cc_id ), index ( last_tr_date));
create table if not exists cc_transaction ( seq int not null primary key auto_increment, tr_date int(11) not null, acct_id varchar(255) not null, cpun varchar(255) not null, other_id varchar(255), other_cpun varchar(255), cc_id varchar(255) not null, amount int not null, item varchar(255), type varchar(5), balance int not null, index (tr_date), index ( acct_id ));
create table if not exists cc_providers ( cpun varchar(255) not null default '', email varchar(255), url varchar(255), lastupdate int(8), status char(1) not null default 'c', primary key cpun (cpun));
create table if not exists cc_users ( userid int(11), login varchar(255), cpun varchar(255) not null default '', email varchar(255), primary key who (login(40),cpun));
INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_cc','n');
INSERT IGNORE INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_cc_use', 'Can use community currencies', 'registered', 'cc');
INSERT IGNORE INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_cc_create', 'Can create new community currencies', 'registered', 'cc');
INSERT IGNORE INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_cc_admin', 'Administrate the currencies system', 'admin', 'cc');
delete from tiki_menu_options where url like 'cc%';
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Currencies','',1400,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Currencies Help','cc.php',1405,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Currencies Config','cc-admin.php',1407,'','tiki_p_cc_admin','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Create Currency','cc.php?page=currencies&new=1',1410,'','tiki_p_cc_create','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Add Transaction','cc.php?page=transactions&new=1',1420,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','My Currencies','cc.php?page=currencies&my=1',1430,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','My Ledgers','cc.php?page=ledgers&my=1',1440,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','My Transactions','cc.php?page=transactions&my=1',1450,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','List Currencies','cc.php?page=currencies&all=1',1460,'','tiki_p_cc_use','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','List Ledgers','cc.php?page=ledgers&all=1',1470,'','tiki_p_cc_admin','');
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','List Transactions','cc.php?page=transactions&all=1',1480,'','tiki_p_cc_admin','');
sql_removedrop table if exists cc_cc;
drop table if exists cc_ledger;
drop table if exists cc_transaction;
sql_upgradeALTER TABLE `cc_transaction` ADD `other_cpun` VARCHAR( 255 );
create table if not exists cc_users ( userid int(11), login varchar(255), cpun varchar(255) not null default '', email varchar(255), primary key who (login(40),cpun));
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Currencies','',1400,'','tiki_p_cc_use','');
typefeatures