多比系统扩展活动模块
1. 往 yi_module 数据表新增数据 如下
INSERT INTO `yi_module` (`moduleid`, `module`, `name`, `moduledir`, `domain`, `linkurl`, `style`, `listorder`, `islink`, `ismenu`, `isblank`, `logo`, `disabled`, `installtime`) VALUES (23, 'activity', '活动', 'activity', '', 'http://localhost/yqhd/activity/', '', 20, 0, 1, 0, 0, 0, 1408350971);
2. 新建数据表
1 -- 2 -- 表的结构 `yi_activity` 3 -- 4 5 CREATE TABLE IF NOT EXISTS `yi_activity` ( 6 `itemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 7 `catid` int(10) unsigned NOT NULL DEFAULT '0', 8 `areaid` int(10) unsigned NOT NULL DEFAULT '0', 9 `level` tinyint(1) unsigned NOT NULL DEFAULT '0', 10 `title` varchar(100) NOT NULL DEFAULT '', 11 `style` varchar(50) NOT NULL DEFAULT '', 12 `fee` float NOT NULL DEFAULT '0', 13 `introduce` varchar(255) NOT NULL DEFAULT '', 14 `keyword` varchar(255) NOT NULL DEFAULT '', 15 `pptword` varchar(255) NOT NULL DEFAULT '', 16 `hits` int(10) unsigned NOT NULL DEFAULT '0', 17 `orders` int(10) unsigned NOT NULL DEFAULT '0', 18 `thumb` varchar(255) NOT NULL DEFAULT '', 19 `username` varchar(30) NOT NULL DEFAULT '', 20 `addtime` int(10) unsigned NOT NULL DEFAULT '0', 21 `fromtime` int(10) unsigned NOT NULL DEFAULT '0', 22 `totime` int(10) unsigned NOT NULL DEFAULT '0', 23 `city` varchar(50) NOT NULL DEFAULT '', 24 `address` varchar(255) NOT NULL DEFAULT '', 25 `postcode` varchar(20) NOT NULL DEFAULT '', 26 `homepage` varchar(255) NOT NULL DEFAULT '', 27 `hallname` varchar(100) NOT NULL DEFAULT '', 28 `sponsor` varchar(100) NOT NULL DEFAULT '', 29 `undertaker` varchar(100) NOT NULL DEFAULT '', 30 `truename` varchar(30) NOT NULL DEFAULT '', 31 `addr` varchar(255) NOT NULL DEFAULT '', 32 `telephone` varchar(100) NOT NULL DEFAULT '', 33 `mobile` varchar(20) NOT NULL DEFAULT '', 34 `fax` varchar(20) NOT NULL DEFAULT '', 35 `email` varchar(50) NOT NULL DEFAULT '', 36 `qq` varchar(20) NOT NULL DEFAULT '', 37 `msn` varchar(50) NOT NULL DEFAULT '', 38 `remark` mediumtext NOT NULL, 39 `sign` tinyint(1) unsigned NOT NULL DEFAULT '0', 40 `editor` varchar(30) NOT NULL DEFAULT '', 41 `edittime` int(10) unsigned NOT NULL DEFAULT '0', 42 `ip` varchar(50) NOT NULL DEFAULT '', 43 `template` varchar(30) NOT NULL DEFAULT '0', 44 `status` tinyint(1) NOT NULL DEFAULT '0', 45 `linkurl` varchar(255) NOT NULL DEFAULT '', 46 `filepath` varchar(255) NOT NULL DEFAULT '', 47 `note` varchar(255) NOT NULL DEFAULT '', 48 PRIMARY KEY (`itemid`), 49 KEY `addtime` (`addtime`), 50 KEY `catid` (`catid`), 51 KEY `username` (`username`) 52 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动' AUTO_INCREMENT=1 ;
-- -- 表的结构 `yi_activity_data` -- CREATE TABLE IF NOT EXISTS `yi_activity_data` ( `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `content` mediumtext NOT NULL, PRIMARY KEY (`itemid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动内容';
1 -- 2 -- 表的结构 `yi_activity_order` 3 -- 4 5 CREATE TABLE IF NOT EXISTS `yi_activity_order` ( 6 `itemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 7 `id` bigint(20) unsigned NOT NULL DEFAULT '0', 8 `user` varchar(30) NOT NULL, 9 `title` varchar(100) NOT NULL DEFAULT '', 10 `amount` int(10) unsigned NOT NULL DEFAULT '0', 11 `company` varchar(100) NOT NULL, 12 `truename` varchar(30) NOT NULL, 13 `mobile` varchar(50) NOT NULL, 14 `areaid` int(10) unsigned NOT NULL DEFAULT '0', 15 `address` varchar(255) NOT NULL, 16 `postcode` varchar(10) NOT NULL, 17 `email` varchar(50) NOT NULL, 18 `qq` varchar(20) NOT NULL, 19 `content` text NOT NULL, 20 `username` varchar(30) NOT NULL, 21 `addtime` int(10) unsigned NOT NULL DEFAULT '0', 22 `ip` varchar(50) NOT NULL, 23 PRIMARY KEY (`itemid`), 24 KEY `id` (`id`) 25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动报名' AUTO_INCREMENT=1 ;
3. 新建 模块前台配置文件 D:\wamp\www\yqhd\activity\config.inc.php 文件 内容如下
<?php $moduleid = 23; ?>
4. 新建 模块后台配置文件 D:\wamp\www\yqhd\module\activity\admin\config.inc.php 文件 内容如下
1 <?php 2 defined('IN_DOB2B') or exit('Access Denied'); 3 $MCFG['module'] = 'activity'; 4 $MCFG['name'] = '活动'; 5 $MCFG['author'] = 'zhengshaoxin'; 6 $MCFG['homepage'] = 'www.zhengshaoxin.com'; 7 $MCFG['copy'] = false; 8 $MCFG['uninstall'] = false; 9 $MCFG['moduleid'] = 23; 10 11 $RT = array(); 12 $RT['file']['index'] = '活动管理'; 13 $RT['file']['order'] = '报名管理'; 14 $RT['file']['html'] = '更新网页'; 15 16 $RT['action']['index']['add'] = '添加活动'; 17 $RT['action']['index']['edit'] = '修改活动'; 18 $RT['action']['index']['delete'] = '删除活动'; 19 $RT['action']['index']['check'] = '审核活动'; 20 $RT['action']['index']['expire'] = '过期活动'; 21 $RT['action']['index']['reject'] = '未通过活动'; 22 $RT['action']['index']['recycle'] = '回收站'; 23 $RT['action']['index']['move'] = '移动活动'; 24 $RT['action']['index']['level'] = '信息级别'; 25 26 $CT = true; 27 ?>
5. 新建 模块后台菜单文件 D:\wamp\www\yqhd\module\activity\admin\menu.inc.php
1 <?php 2 defined('IN_DOB2B') or exit('Access Denied'); 3 $menu = array( 4 array("添加".$name, "?moduleid=$moduleid&action=add"), 5 array($name."列表", "?moduleid=$moduleid"), 6 array("报名列表", "?moduleid=$moduleid&file=order"), 7 array("审核".$name, "?moduleid=$moduleid&action=check"), 8 array("分类管理", "?file=category&mid=$moduleid"), 9 array("更新数据", "?moduleid=$moduleid&file=html"), 10 array("模块设置", "?moduleid=$moduleid&file=setting"), 11 ); 12 ?>
6. 新建 语言文件 D:\wamp\www\yqhd\lang\zh-cn\activity.inc.php
7. 新建 类文件 D:\wamp\www\yqhd\module\activity\activity.class.php
浙公网安备 33010602011771号