ECSHOP二次开发教程开发手册（一）

ECSHOP教程 > ECSHOP二次开发：ECSHOP模板修改，ecshop二次开发介绍ECSHOP二次开发必备手册【ECSHOP数据库表结构完整版】ECSHOP数据表结构完整仔细说明教程ECSHOP模板结构说明,一套完整ECSHOP模板文件说明手册ECSHOP模板制作教程,ECSHOP标签大全,ECSHOP模板标签ECSHOP二次开发,ECSHOP模板修改,ECSHOP模板制作工具ECSHOP二次开发手册,ECSHOP文件结构,ECSHOP目录详解ecshop文件结构名称手册ecshop开发手册,ecshop使用手册,ECSHOP数据库结构参数表1:如何统计ecshop商品在订单中出现的次数     回答:$count = $db -> getOne("select sum(goods_number) from ".$ecs->table('order_goods')." where goods_id = '$goods[goods_id]'");   2:ecshop详细页面如何通过onclick点击事件来控制购买，特别用在批发，批发存在一个最小购买量控制．   回答:            3:如何用js去验证手机号码．    回答：var reg =/^[1]([3][0-9]{1}|50|53|59|58|56|86|80|89|87|88|85|86|55|51|52|57)[0-9]{8}$/;    4:ecshop中如何取得每个月的1号时间?   回答:local_mktime(0,0,0,date("m"),0,date("Y"));使用ecshop的local_mktime函 数.      5:ecshop如何直接关闭窗口而不弹出提示   回答:    6:如何统计ecshop某商品下被审核过的评论数量。回答：$ccount = $db -> getOne("select count(*) cc from ".$ecs->table('comment')." where id_value = '$goods_id' and comment_type = '0' and status = '1' and parent_id = '0'");       7:ecshop中js如何将时间格式互转    回答：date1 = new Date();var b = Date.UTC(date1.getYear(),date1.getMonth()+1,date1.getDate(),0,0,0)time1 = frm.elements['best_time'].value;y = time1.substring(0,4);m = time1.substring(5,7);d = time1.substring(8,10);var b2 = Date.UTC(y,m,d,0,0,0)   8:如何解析ecshop flash的xml回答：    $str = @file_get_contents("data/flash_data.xml");if($str){   preg_match_all("/item_url=\"(.*?)\"/",$str,$url);   preg_match_all("/text=\"(.*?)\"/",$str,$text);   preg_match_all("/link=\"(.*?)\"/",$str,$link);   $ar_flash = array();   if(sizeof($url[1])){    for($i=0;$i     $ar_flash[$i]['url'] = $url[1][$i];     $ar_flash[$i]['text'] = $text[1][$i];     $ar_flash[$i]['link'] = $link[1][$i];    }    $smarty->assign('ar_flash',$ar_flash);   }  }9:ecshop中如何正则提取中文回答:preg_match("/[".chr(0xa1)."-".chr(0xff)."]+/",ecs_iconv("UTF-8","GBK",$v['brand_name']),$cn);10:ecshop如何取得订单中所属区域$p = $GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id = '".$re1['province']."'");     $c = $GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id = '".$re1['city']."'");     $d = $GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id = '".$re1['district']."'");11:ecshop中如何分别提取中文和英文回答:utf下面$pregstr = "/[\x{4e00}-\x{9fa5}]+/u";preg_match($pregstr,$v['brand_name'],$ch);      gbk下面$strtest = “yyg中文字符yyg”;$pregstr = "/([".chr(0xb0)."-".chr(0xf7)."][".chr(0xa1)."-".chr(0xfe)."])+/i";if(preg_match($pregstr,$strtest,$matchArray)){echo $matchArray[0]; } 12:如何控制ecshop商品总价格只有ecshop会员特殊等级才能查看回答：ecshop的goods.php$is_spe = $GLOBALS['db'] -> getOne("select special_rank from ".$GLOBALS['ecs']->table('user_rank')." where rank_id = '".$_SESSION['user_rank']."'");   if($is_spe){    $res['result'] = price_format($shop_price * $number);   }else{    $string = "请联系客服";    $res['result'] = $string;   } 13:调试ecshop程序出现以下错误Fatal error: Cannot redeclare是什么意思？ 回答：Fatal error: Cannot redeclare,意思是你运行的程序中，某函数重新申明了两次，要删除其中一个同名函数． 14:ecshop如何判断是否当天登陆，并赠送积分.回答:/* 赠送积分 */   $day = local_mktime(0,0,0,date("m"),date("d"),date("Y"));   $last_time = $db -> getOne("select last_login from ".$ecs->table('users')." where user_name = '".$username."'");   if($last_time < $day){    log_account_change($_SESSION['user_id'], 0, 0, 0, 10, '每天登陆送积分', ACT_OTHER);   } 15:如何在ecshop订单列表中列表出订单中所包含的商品编号.回答:    function get_user_orders($user_id, $num = 10, $start = 0){    /* 取得订单列表 */    $arr    = array();    global $ecs;global $db;    $sql = "SELECT order_id, order_sn, order_status,consignee, shipping_status, pay_status, add_time, " .           "(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee ".           " FROM " .$GLOBALS['ecs']->table('order_info') .           " WHERE user_id = '$user_id' ORDER BY add_time DESC";    $res = $GLOBALS['db']->SelectLimit($sql, $num, $start);    while ($row = $GLOBALS['db']->fetchRow($res))    {        if ($row['order_status'] == OS_UNCONFIRMED)        {            $row['handler'] = "".$GLOBALS['_LANG']['cancel']."";        }        else if ($row['order_status'] == OS_SPLITED)        {            /* 对配送状态的处理 */            if ($row['shipping_status'] == SS_SHIPPED)            {                @$row['handler'] = "".$GLOBALS['_LANG']['received']."";            }            elseif ($row['shipping_status'] == SS_RECEIVED)            {                @$row['handler'] = ''.$GLOBALS['_LANG']['ss_received'] .'';            }            else            {                if ($row['pay_status'] == PS_UNPAYED)                {                    @$row['handler'] = "' .$GLOBALS['_LANG']['pay_money']. '';                }                else                {                    @$row['handler'] = "' .$GLOBALS['_LANG']['view_order']. '';                }            }        }        else        {            $row['handler'] = ''.$GLOBALS['_LANG']['os'][$row['order_status']] .'';        }        $row2 = $db -> getAll("select goods_id ,goods_sn from ".$ecs->table('order_goods')." where order_id = '".$row['order_id']."'");        $row['shipping_status'] = ($row['shipping_status'] == SS_SHIPPED_ING) ? SS_PREPARING : $row['shipping_status'];        $row['order_status'] = $GLOBALS['_LANG']['os'][$row['order_status']] . ',' . $GLOBALS['_LANG']['ps'][$row['pay_status']] . ',' . $GLOBALS['_LANG']['ss'][$row['shipping_status']];        $arr[] = array('order_id'       => $row['order_id'],                       'order_sn'       => $row['order_sn'],                       'order_time'     => local_date($GLOBALS['_CFG']['time_format'], $row['add_time']),                       'order_status'   => $row['order_status'],       'consignee'   => $row['consignee'],                       'total_fee'      => price_format($row['total_fee'], false),        'goodslist'   => $row2,                       'handler'        => $row['handler']);    }    return $arr;} 16:如何取得ecshop会员一天内的评论条数回答:function get_day_count_comment($user_id = ''){global $db;global $ecs;$pre = local_mktime(0,0,0,date("m"),date("d"),date("y"));$next = local_mktime(0,0,0,date("m"),date("d")+2,date("y"));   $count = $db -> getOne("select count(*) from ".$ecs->table('comment')." where user_id = '$user_id' and add_time > '$pre' and add_time < '$next' ");if($count > 5){   return false;}else{   return true;}} 17:ecshop中js是如何验证radio选择．回答：类似以下代码/*var businesstype = false;var job_title = false;var number_of_employees = false;   for (i = 0; i < frm.elements.length; i ++ ){    if (frm.elements[i].name == 'businesstype' && frm.elements[i].checked)    {      businesstype = true;    }    if (frm.elements[i].name == 'job_title' && frm.elements[i].checked)    {      job_title = true;    }if (frm.elements[i].name == 'number_of_employees' && frm.elements[i].checked)    {      number_of_employees = true;    }if (frm.elements[i].name == 'number_of_employees' && frm.elements[i].checked)    {      number_of_employees = true;    }}*/