ECSHOPv2.7.3商城系统目录结构与数据表结构说明

ECSHOP商城系统目录结构与数据表结构说明

V2.7.3

一、系统目录结构及文件说明

┣ activity.php--------------------------------------------------------------------------------------------------活动列表┣ affiche.php --------------------------------------------------------------------------------------------广告处理文件┣ affiliate.php--------------------------------------------------------------------------------------------生成广告列表

┣ api.php--------------------------------------------------------------------------------------------------API统一接口┣ article.php --------------------------------------------------------------------------------------------------文章内容┣ article_cat.php---------------------------------------------------------------------------------------------文章分类┣ auction.php--------------------------------------------------------------------------------------------拍卖前台文件┣ brand.php---------------------------------------------------------------------------------------------------品牌列表┣ captcha.php ---------------------------------------------------------------------------------------------生成验证码┣ catalog.php -----------------------------------------------------------------------------------列出所有分类及品牌┣ category.php -----------------------------------------------------------------------------------------------商品分类┣ certi.php -----------------------------------------------------------------------------------------------证书反查文件┣ comment.php ----------------------------------------------------------------------------------------提交用户评论┣ compare.php -----------------------------------------------------------------------------------------商品比较程序┣ cycle_image.php -------------------------------------------------------------------------------------轮播图片程序┣ exchange.php ----------------------------------------------------------------------------------------------积分商城┣ feed.php ---------------------------------------------------------------------------------------- RSS Feed生成程序┣ flow.php ----------------------------------------------------------------------------------------------------购物流程┣ gallery.php -------------------------------------------------------------------------------------------------商品相册┣ goods.php --------------------------------------------------------------------------------------------------商品详情┣ goods_script.php ------------------------------------------------------------------------------------生成商品列表┣ group_buy.php ----------------------------------------------------------------------------------团购商品前台文件┣ index.php ---------------------------------------------------------------------------------------------------首页文件┣ message.php -------------------------------------------------------------------------------------------------留言板┣ myship.php -----------------------------------------------------------------------------------------支付配送DEMO ┣ package.php ------------------------------------------------------------------------------------------超值礼包列表┣ pick_out.php -----------------------------------------------------------------------------------------------选购中心┣ pm.php ---------------------------------------------------------------------------------------------------短消息文件┣ quotation.php -------------------------------------------------------------------------------------------------报价单┣ receive.php -----------------------------------------------------------------------------------处理收回确认的页面┣ region.php --------------------------------------------------------------------------------------------地区切换程序┣ respond.php ------------------------------------------------------------------------------------------支付响应页面┣ search.php -------------------------------------------------------------------------------------------------搜索程序┣ sitemaps.php --------------------------------------------------------------------------------google sitemap 文件┣ snatch.php --------------------------------------------------------------------------------------夺宝奇兵前台页面┣ tag_cloud.php ------------------------------------------------------------------------------------------------标签云┣ topic.php ---------------------------------------------------------------------------------------------------专题前台

┣ user.php ----------------------------------------------------------------------------------------------------会员中心┣ vote.php ----------------------------------------------------------------------------------------------------调查程序┣ wholesale.php ----------------------------------------------------------------------------------------批发前台文件┣ admin -------------------------------------------------------------------------------------------------------后台目录┣ api 目录-------------------------------------------------------------------------------------------API统一接口目录┃┣ checkorder.php ------------------------------------------------------------------------------------检查订单API ┃┣ cron.php--------------------------------------------------------------------------------------------计划任务文件┃┣ goods.php ------------------------------------------------------------------------------------------获取商品信息┃┣ init.php API --------------------------------------------------------------------------------------公用初始化文件┃┗ uc.php ------------------------------------------------------------------------------------------------UCenter API ┣ cert目录-----------------------------------------------------------------------------------------------存放证书目录┣ data目录----------------------------------------------------------------------------------------------------数据目录┃┣ affiliate.html-----------------------------------------------------------------------------------生成广告列表文

件

┃┣ config.php----------------------------------------------------------------------------------------数据库配置文

件

┃┣ goods_script.html----------------------------------------------------------------------------生成商品列表文件┃┣ order_print.html-----------------------------------------------------------------------------------订单打印文件┃┣ quotation_print.html---------------------------------------------------------------------------------报价单文件┃┣ afficheimg目录-------------------------------------------------------------------------------------广告图片目录┃┣ brandlogo目录-------------------------------------------------------------------------------------品牌logo目录┃┣ captcha目录-------------------------------------------------------------------------------------验证码图片目录┃┣ cardimg目录----------------------------------------------------------------------------------------贺卡图片目录┃┣ feedbackimg目录----------------------------------------------------------------------------------反馈图片目录┃┣ flashdata目录-------------------------------------------------------------------------------------------flash目录┃┣ images目录----------------------------------------------------------------------------------------------图片目录┃┣ packimg目录---------------------------------------------------------------------------礼包图片目录（包装纸）┃┣ print目录-------------------------------------------------------------------------------------------------打印目录┃┗ sqldata目录-----------------------------------------------------------------------------------------SQL文件目录┣ images----------------------------------------------------------------------------------------------------多媒体目录┃┗ upload ----------------------------------------------------------------------------------------------上传文件目录┃┃┣ File------------------------------------------------------------------------------------------------------文件目录┃┃┣ Flash --------------------------------------------------------------------------------------------------flash目录┃┃┣ Image -------------------------------------------------------------------------------------------------图片目录┃┃┗ Media ---------------------------------------------------------------------------------------------声音视频目录┣ includes目录------------------------------------------------------------------------------------------PHP类库目录┃┣ cls_captcha.php -----------------------------------------------------------------------------------验证码图片类┃┣ cls_ecshop.php --------------------------------------------------------------------------------------------基础类┃┣ cls_error.php ---------------------------------------------------------------------------------用户级错误处理类┃┣ cls_iconv.php --------------------------------------------------------------------------------------字符集转换类┃┣ cls_image.php -----------------------后台对上传文件的处理类(实现图片上传，图片缩小，增加水印)┃┣ cls_json.php ----------------------------------------------------------------------------------------------JSON类┃┣ cls_mysql.php ----------------------------------------------------------------------------------MYSQL公用类库┃┣ cls_rss.php-------------------------------------------------------------------------------------------------RSS 类┃┣ cls_session.php---------------------------------------------------------------------------- SESSION 公用类库┃┣ cls_sms.php -------------------------------------------------------------------------短信模块之模型（类库）

┃┣ cls_smtp.php ---------------------------------------------------------------------------------------SMTP 邮件类┃┣ cls_sql_executor.php ---------------------------------------------------------------------------SQL语句执行类┃┣ cls_template.php ------------------------------------------------------------------------------------------模版类┃┣ cls_transport.php ----------------------------------------------------------------------服务器之间数据传输器┃┣ inc_constant.php --------------------------------------------------------------------------------------------常量┃┣ init.php ---------------------------------------------------------------------------------------------前台公用文件┃┣ lib.debug.php--------------------------------------------------------------------------------------------调错文件┃┣ lib_article.php ---------------------------------------------------------------------文章及文章分类相关函数库┃┣ lib_base.php ------------------------------------------------------------------------------------------基础函数库┃┣ lib_clips.php -------------------------------------------------------------------------------------用户相关函数库┃┣ lib_code.php ------------------------------------------------------------------------------------------加密解密类┃┣ lib_common.php -------------------------------------------------------------------------------------公用函数库┃┣ lib_compositor.php --------------------------------------------------------------------------支付插件排序文件┃┣ lib_goods.php ----------------------------------------------------------------------------------商品相关函数库┃┣ lib_insert.php -----------------------------------------------------------------------------------动态内容函数库┃┣ lib_license.php ---------------------------------------------------------------------------LICENSE 相关函数库┃┣ lib_main.php ------------------------------------------------------------------------------------前台公用函数库┃┣ lib_order.php ------------------------------------------------------------------------------------购物流程函数库┃┣ lib_passport.php --------------------------------------------------------------------------用户帐号相关函数库┃┣ lib_payment.php -------------------------------------------------------------------------------支付接口函数库┃┣ lib_time.php --------------------------------------------------------------------------------------------时间函数┃┣ lib_transaction.php ----------------------------------------------------------------------用户交易相关函数库┃┣ lib_uc.php -------------------------------------------------------------------------------------------------函数库┃┣ shopex_json.php ---------------------------------------------------------------------------------------JSON 类┃┣ codetable ----------------------------------------------------------------------------------语言对应代码表文件┃┃┣ big5_utf8.php----------------------------------------------------------------------------------------big5_utf8┃┃┣ big5-gb.table-------------------------------------------------------------------------------------------big5-gb ┃┃┣ gb_utf8.php------------------------------------------------------------------------------------------- gb_utf8┃┃┣ gb-big5.table------------------------------------------------------------------------------------------ gb-big5┃┃┗ ipdata.dat------------------------------------------------------------------------ip地址的地理位置信息文件┃┣ fckeditor目录-------------------------------------------------------------------------fckeditor编辑器插件目录┃┣ modules 目录

┃┃┣ convert-----------------------------------------------------------------------------------shopex转换文件目录┃┃┃┣ shopex46.php -------------------------------------------------------------------shopex4.6转换程序插件┃┃┃┣ shopex47.php------------------------------------------------------------------- shopex4.7转换程序插件┃┃┃┗ shopex48.php -------------------------------------------------------------------shopex4.8转换程序插件┃┃┣ cron-------------------------------------------------------------------------自动上下架、ip删除等函数目录┃┃┃┣ auto_manage.php ------------------------------------------------------------------------自动上下架管理┃┃┃┗ ipdel.php -------------------------------------------------------------------------------------------定期删除┃┃┣ integrates-----------------------------------------------------------------------------------会员数据处理目录┃┃┃┣ discuz55.php ------------------------------------------------------------------------------会员数据处理类┃┃┃┣ dvbbs.php ---------------------------------------------------------------------------------会员数据处理类┃┃┃┣ ecshop.php --------------------------------------------------------------------------------会员数据处理类┃┃┃┣ integrate.php ---------------------------------------------------------------------------整合插件类的基类┃┃┃┣ phpbb.php ---------------------------------------------------------------------------------会员数据处理类┃┃┃┣ phpwind6.php--------------------------------------------------------------------PHPwind6.3.2整合插件

┃┃┃┣ ucenter.php UCenter ---------------------------------------------------------------------会员数据处理类┃┃┃┗ vbb.php ------------------------------------------------------------------------------------会员数据处理类┃┃┣ payment------------------------------------------------------------------------------------------支付插件目录┃┃┃┣ alipay.php ---------------------------------------------------------------------------------------支付宝插件┃┃┃┣ balance.php ----------------------------------------------------------------------------------余额支付插件┃┃┃┣ bank.php --------------------------------------------------------------------------银行汇款（转帐）插件┃┃┃┣ cappay.php --------------------------------------------------------------------------------首信易支付插件┃┃┃┣ chinabank.php -------------------------------------------------------------------------------网银在线插件┃┃┃┣ cncard.php -----------------------------------------------------------------------------------云网支付插件┃┃┃┣ cod.php ---------------------------------------------------------------------------------------货到付款插件┃┃┃┣ express.php ------------------------------------------------------------------------express支付系统插件┃┃┃┣ ips.php iips------------------------------------------------------------------------------------支付系统插件┃┃┃┣ kuaiqian.php ---------------------------------------------------------------------------------------快钱插件┃┃┃┣ kuaiqian_abc.php ----------------------------------------------------------------------------快钱农行插件┃┃┃┣ kuaiqian_bcom.php--------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_bob.php-----------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_boc.php-----------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_ccb.php-----------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_cmb.php----------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_cmbc.php---------------------------------------------------------------------------快钱X行插件┃┃┃┣ kuaiqian_icbc.php ---------------------------------------------------------------------------快钱工行插件┃┃┃┣ kuaiqian_sdb.php------------------------------------------------------------------------- ---快钱X行插件┃┃┃┣ paypal.php -----------------------------------------------------------------------------------------贝宝插件┃┃┃┣ paypal_ec.php -------------------------------------------------------------------------------贝宝快速结账┃┃┃┣ post.php --------------------------------------------------------------------------------------邮局汇款插件┃┃┃┣ shenzhou.php ------------------------------------------------------------------------快钱神州行支付插件┃┃┃┣ tenpay.php---------------------------------------------------------------------------------------财付通插件┃┃┃┣ tenpayc2c.php------------------------------------------------------------------财付通中介担保支付插件┃┃┃┣ yeepay.php-------------------------------------------------------------------------------- YeePay易宝插件┃┃┃┣ yeepay_abchina.php-----------------------------------------------------------YeePay易宝银行直付插件┃┃┃┣ yeepay_ccb.php----------------------------------------------------------------YeePay易宝银行直付插件┃┃┃┣ yeepay_cmbchina.php--------------------------------------------------------YeePay易宝银行直付插件┃┃┃┣ yeepay_icbc.php --------------------------------------------------------------YeePay易宝银行直付插件┃┃┃┣ yeepay_jcard.php -------------------------------------------------------------YeePay易宝银行直付插件┃┃┃┗ yeepayszx.php-------------------------------------------------------------- YeePay易宝神州行支付插件┃┃┗ shipping------------------------------------------------------------------------------------------配送发货目录┃┃┃┣ cac.php----------------------------------------------------------------------------------------上门取货插件┃┃┃┣ city_express.php -----------------------------------------------------------------------------城际快递插件┃┃┃┣ ems.php-------------------------------------------------------------------------------------------- EMS插件┃┃┃┣ flat.php ----------------------------------------------------------------------------------------市内快递插件┃┃┃┣ fpd.php ---------------------------------------------到付运费插件FPD(freight payable at destination)┃┃┃┣ post_express.php ----------------------------------------------------------------------------邮政包裹插件┃┃┃┣ post_mail.php --------------------------------------------------------------------------------邮局平邮插件┃┃┃┣ presswork.php ----------------------------------------------------------------------------挂号印刷品插件┃┃┃┣ sf_express.php ------------------------------------------------------------------顺丰速运配送方式插件┃┃┃┣ sto_express.php -----------------------------------------------------------------申通快递配送方式插件

┃┃┃┣ yto.php ----------------------------------------------------------------------------------------圆通速递插件┃┃┃┗ zto.php ----------------------------------------------------------------------------------------中通速递插件┣ js目录

┃┣ ato_complete.js---------------------------------------------------------------------------------自动完成js文件┃┣ caendar.php--------------------------------------------------------------------------------------调用日历js文件┃┣ common.js---------------------------------------------------------------------------------------公共函数js文件┃┣ compare.js---------------------------------------------------------------------------------------商品比较js文件┃┣ global.js------------------------------------------------------------------------------------------------全局js文件┃┣ index.js-------------------------------------------------------------------------------------------------首页js文件┃┣ lefttime.js-----------------------------------------------------------------------------------------剩余时间js文件┃┣ myship.js-- -------------------------------------------------------------------------------------支付配送js文件┃┣ region.js------------------------------------------------------------------------------------------------城市js文件┃┣ shopping_flow.js--------------------------------------------------------------------------------购物流程js文件┃┣ showdiv.js-------------------------------------------------------------------------------------创建显示层js文件┃┣ tagbox.js-------------------------------------------------------------------------------------------------------未知┃┣ transport.js----------------------------------------------------------------------------用于支持AJAX的传输类┃┣ user.js--------------------------------------------------------------------------------------------会员信息js文件┃┣ utils.js-----------------------------------------------------------------------------------------------------验证类js ┃┗ calendar目录--------------------------------------------------------------------------------------------日历目录┣ languages------------------------------------------------------------------------------------------------语言包目录┃┣ en_us--------------------------------------------------------------------------------------------------英文语言包┃┣ zh_cn---------------------------------------------------------------------------------------------简体中文语言包┃┗ zh_tw---------------------------------------------------------------------------------------------繁体中文语言包┣ mobile-----------------------------------------------------------------------------------------------------手机站目录┣ plugins-------------------------------------------------------------------------------------------------------插件目录┣ temp目录---------------------------------------------------------------------------------------------------临时目录┣ themes------------------------------------------------------------------------------------------------------模板目录┃┗ default-----------------------------------------------------------------------------------------------默认模板目录┃┃┣ images-------------------------------------------------------------------------------------------------图片目录┃┃┗ library------------------------------------------------------------------------------------------模板库文件目录┃┃┃┣ad_position.lbi ------------------------------------------------------------------- ------------------------------- 广告┃┃┃┣article_category_tree.lbi -------------------------------------------------------------------------------文章分类树┃┃┃┣bought_goods.lbi-----------------------------------------------------------购买过此商品的人购买过哪些商品┃┃┃┣brand_goods.lbi-------------------------------------------------------------------------------------------- 品牌商品┃┃┃┣cart.lbi------------------------------------------------------------------------------------------------------------购物车┃┃┃┣cat_articles.lbi------------------------------------------------------------------------------------------分类下的文章┃┃┃┣cat_goods.lbi-------------------------------------------------------------------------------------------分类下的商品┃┃┃┣category_tree.lbi------------------------------------------------------------------------------------------商品分类树┃┃┃┣categorys.lbi------------------------------------------------------------------------------------所有小类+商品数量┃┃┃┣comments.lbi-------------------------------------------------------------------------------------------------用户评论┃┃┃┣comments_list.lbi------------------------------------------------------------------------------------------ 评论列表┃┃┃┣consignee.lbi--------------------------------------------------------------------------------------------- 收货人信息┃┃┃┣email_list.lbi -------------------------------------------------------------------------------------------------邮件订阅┃┃┃┣exchange_hot.lbi --------------------------------------------------------------------------------积分商城热卖商品┃┃┃┣exchange_list.lbi --------------------------------------------------------------------------------积分商城商品列表┃┃┃┣filter_attr.lbi--------------------------------------------------------------------------------------------------扩展属性

┃┃┃┣goods_article.lbi--- -----------------------------------------------------------------------------商品相关文章列表┃┃┃┣goods_attrlinked.lbi-----------------------------------------------------------------------------------属性关联商品┃┃┃┣goods_fittings.lbi--------------------------------------------------------------------------------------相关配件列表┃┃┃┣goods_gallery.lbi------------------------------------------------------------------------------------------- 商品相册┃┃┃┣goods_list.lbi ------------------------------------------------------------------------------------------------商品列表┃┃┃┣goods_related.lbi --------------------------------------------------------------------------------------相关商品列表┃┃┃┣goods_tags.lbi -----------------------------------------------------------------------------------------------商品标签┃┃┃┣group_buy.lbi ------------------------------------------------------------------------------------------------团购商品┃┃┃┣help.lbi--------------------------------------------------------------------------------------------------------帮助内容┃┃┃┣history.lbi-----------------------------------------------------------------------------------------------------历史记录┃┃┃┣invoice_query.lbi-----------------------------------------------------------------------------------------发货单查询┃┃┃┣member.lbi------------------------------------------------------------------------------------------------会员登录区┃┃┃┣member_info.lbi---------------------------------------------------------------------------------------------会员信息┃┃┃┣myship.lbi----------------------------------------------------------------------------------------------------收货信息┃┃┃┣new_articles.lbi----------------------------------------------------------------------------------------------最新文章┃┃┃┣online.lbi------------------------------------------------------------------------------------------------------在线用户┃┃┃┣order_query.lbi-----------------------------------------------------------------------------------------------订单查询┃┃┃┣order_total.lbi------------------------------------------------------------------------------------------订单费用总数┃┃┃┣page_footer.lbi-----------------------------------------------------------------------------------------------页面底部┃┃┃┣page_header.lbi ----------------------------------------------------------------------------------------------页面顶部┃┃┃┣pages.lbi-------- ----------------------------------------------------------------------------------------------列表分页┃┃┃┣price_grade.lbi-------- --------------------------------------------------------------------------------价格筛选区间┃┃┃┣promotion_info.lbi-------------------------------------------------------------------------------------------促销信息┃┃┃┣recommend_best.lbi--------------------------------------------------------------------------------------- 精品推荐┃┃┃┣recommend_hot.lbi------------------------------------------------------------------------------------------热卖商品┃┃┃┣recommend_new.lbi-----------------------------------------------------------------------------------------最新商品┃┃┃┣recommend_promotion.lbi---------------------------------------------------------------------------促销特价商品┃┃┃┣relatetag.lbi -----------------------------------------------------------------------------------------------------云标签┃┃┃┣snatch.lbi------------------------------------------------------------------------------------------------------夺宝奇兵┃┃┃┣snatch_price.lbi----------------------------------------------------------------------------------夺宝奇兵价格列表┃┃┃┣top10.lbi-------------------------------------------------------------------------------------------------------销售排行┃┃┃┣ur_here.lbi--------------------------------------------------------------------------------------------------- 当前位置┃┃┃┣user_menu.lbi----------------------------------------------------------------------------------------------- 用户菜单┃┃┃┣vote.lbi -------------------------------------------------------------------------------------------------------用户投票┃┃┃┗vote_list.lbi---------------------------------------------------------------------------------------------------在线调查┃┃┃

┣ wap目录--------------------------------------------------------------------------------------------------手机站目录┗ widget目录-------------------------------------------------------------------------------------------------微件目录

二、数据库数据表结构说明(数据字典)

ecs_account_log

表注释: 用户账目日志表

ecs_ad

表注释: 广告表

ecs_ad_custom

表注释: 广告客户表

ecs_ad_position 表注释: 广告位置表

ecs_admin_action 表注释: 管理员权限分配表

ecs_admin_log

表注释: 管理员操作日志表

ecs_admin_message 表注释: 管理员留言表

ecs_admin_user

表注释: 系统管理员表

ecs_adsense

表注释: 广告相关统计（站外JS投放）

ecs_affiliate_log 表注释: 分成记录表

ecs_agency

表注释: 办事处列表

ecs_area_region

表注释: 区域范围表（如配送区域等）

ecs_article

表注释: 文章表

ecs_article_cat

表注释: 文章分类表

ecs_attribute

表注释: 各类商品扩展属性管理表

ecs_auction_log 表注释: 拍卖活动出价记录表

ecs_auto_manage 表注释: 自动上下架管理表

ecs_back_goods 表注释: 退货商品表

ecs_back_order 表注释: 退货单列表

ecs_bonus_type 表注释: 红包类型表

ecs_booking_goods 表注释: 缺货登记表

ecs_brand 表注释: 商品品牌表

ecs_card 表注释: 祝福贺卡表

ecs_cart 表注释: 购物车表

ecs_cat_recommend 表注释: 首页推荐商品分类表

ecs_category

表注释: 商品分类表

ecs_collect_goods 表注释: 用户商品收藏表

ecs_comment

表注释: 用户评论表

ecs_crons

表注释: 计划任务表

ecs_delivery_goods 表注释: 发货清单中的商品表

ecs_delivery_order 表注释: 发货订单列表