{"id":59413,"date":"2025-04-23T17:32:06","date_gmt":"2025-04-23T09:32:06","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59413\/"},"modified":"2025-04-23T17:32:06","modified_gmt":"2025-04-23T09:32:06","slug":"ecshop%e7%ba%a2%e5%8c%85%e6%8c%87%e5%ae%9a%e6%9f%90%e4%ba%9b%e5%95%86%e5%93%81%e4%b8%8d%e8%83%bd%e4%bd%bf%e7%94%a8-%e4%bf%ae%e6%94%b9%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59413\/","title":{"rendered":"ecshop\u7ea2\u5305\u6307\u5b9a\u67d0\u4e9b\u5546\u54c1\u4e0d\u80fd\u4f7f\u7528 \u4fee\u6539\u6b65\u9aa4"},"content":{"rendered":"

\u4ee5ecshop\u6700\u65b0\u7248\u672c273\u4e3a\u4f8b\uff1a<\/span><\/p>\n

 \u7b2c\u4e00\u6b65\uff1a\u5728goods\u8868\u683c\u589e\u52a0\u4e00\u4e2a\u5b57\u6bb5 is_bonus \u7c7b\u578b tinyint \u9ed8\u8ba4\u4e3a1 (1\u662f\u53ef\u4ee5\u4f7f\u7528\u7ea2\u5305)<\/span><\/span><\/p>\n

\u7b2c\u4e8c\u6b65\uff1a\u4fee\u6539\u540e\u53f0\u6a21\u677f\u9875 goods_info.htm<\/span><\/p>\n

<tr id=\u201dalone_sale_1\u2033><td id=\u201dalone_sale_2\u2033>{$lang.lab_is_on_sale}<\/td><td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_on_sale\u201d value=\u201d1\u2033 {if $goods.is_on_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.on_sale_desc}<\/td><\/tr><tr id=\u201dalone_sale_1\u2033><td id=\u201dalone_sale_2\u2033>\u7ea2\u5305\u4f7f\u7528<\/td><td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_bonus\u201d value=\u201d1\u2033 {if $goods.is_bonus}checked=\u201dchecked\u201d{\/if} \/> \u6253\u52fe\u8868\u793a\u5141\u8bb8\u7528\u4f7f\u7528\u7ea2\u5305\uff0c\u5426\u5219\u4e0d\u5141\u8bb8\u4f7f\u7528\u3002<\/td><\/tr><tr><td>{$lang.lab_is_alone_sale}<\/td><td><input type=\u201dcheckbox\u201d name=\u201dis_alone_sale\u201d value=\u201d1\u2033 {if $goods.is_alone_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.alone_sale}<\/td><\/tr><\/span><\/p>\n

<tr id=\u201dalone_sale_1\u2033>            <td id=\u201dalone_sale_2\u2033>{$lang.lab_is_on_sale}<\/td>            <td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_on_sale\u201d value=\u201d1\u2033 {if $goods.is_on_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.on_sale_desc}<\/td>          <\/tr><\/span><\/p>\n

<tr id=\u201dalone_sale_1\u2033>            <td id=\u201dalone_sale_2\u2033>\u7ea2\u5305\u4f7f\u7528<\/td>            <td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_bonus\u201d value=\u201d1\u2033 {if $goods.is_bonus}checked=\u201dchecked\u201d{\/if} \/> \u6253\u52fe\u8868\u793a\u5141\u8bb8\u7528\u4f7f\u7528\u7ea2\u5305\uff0c\u5426\u5219\u4e0d\u5141\u8bb8\u4f7f\u7528\u3002<\/td>          <\/tr><\/span><\/p>\n

<tr>            <td>{$lang.lab_is_alone_sale}<\/td>            <td><input type=\u201dcheckbox\u201d name=\u201dis_alone_sale\u201d value=\u201d1\u2033 {if $goods.is_alone_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.alone_sale}<\/td>          <\/tr><\/span><\/p>\n

\u8fd9\u4e2a\u5927\u6982\u5728230\u884c\u5de6\u53f3<\/span><\/p>\n

*\u6ce8\uff1a\u6211\u6ca1\u6709\u4fee\u6539\u8bed\u8a00\u5305\uff0c\u5982\u679c\u4f60\u9700\u8981\u53ef\u4ee5\u5148\u53bb\u4fee\u6539\u8bed\u8a00\u5305\uff0c\u7136\u540e\u8fd9\u91cc\u8c03\u8a00\uff08\u5475\u5475\uff09<\/span><\/p>\n

\u7b2c\u4e09\u6b65\uff1a\u4fee\u6539\u540e\u53f0goods.php\u6587\u4ef6<\/span><\/p>\n

\u5728\u6dfb\u52a0\u65b0\u5546\u54c1 \u7f16\u8f91\u5546\u54c1 \u4e0b\u9762\u4fee\u6539<\/span><\/p>\n

158\u884c\u548c230\u884c\u5de6\u53f3\u7684 $goods\u6570\u7ec4\u52a0\u4e0b\u4e0b\u9762\u7ea2\u8272\u7684\u90e8\u5206(\u6211\u8fd9\u91cc\u9ed8\u8ba4\u662f\u53ef\u4ee5\u4f7f\u7528\u7ea2\u5305\u7684)<\/span><\/p>\n

$goods = array(<\/span><\/p>\n

\u2018goods_id\u2019      => 0,<\/span><\/p>\n

\u2018goods_desc\u2019    => \u201d,<\/span><\/p>\n

\u2018cat_id\u2019        => $last_choose[0],<\/span><\/p>\n

\u2018brand_id\u2019      => $last_choose[1],<\/span><\/p>\n

\u2018is_on_sale\u2019    => \u20191\u2032,<\/span><\/p>\n

\u2018is_bonus\u2019      => \u20191\u2032,<\/span><\/p>\n

\u2018is_alone_sale\u2019 => \u20191\u2032,<\/span><\/p>\n

\u2018is_shipping\u2019 => \u20190\u2032,<\/span><\/p>\n

\u2018other_cat\u2019     => array(), \/\/ \u6269\u5c55\u5206\u7c7b<\/span><\/p>\n

\u2018goods_type\u2019    => 0,       \/\/ \u5546\u54c1\u7c7b\u578b<\/span><\/p>\n

\u2018shop_price\u2019    => 0,<\/span><\/p>\n

\u2018promote_price\u2019 => 0,<\/span><\/p>\n

\u2018market_price\u2019  => 0,<\/span><\/p>\n

\u2018integral\u2019      => 0,<\/span><\/p>\n

\u2018goods_number\u2019  => $_CFG[‘default_storage’],<\/span><\/p>\n

\u2018warn_number\u2019   => 1,<\/span><\/p>\n

\u2018promote_start_date\u2019 => local_date(\u2018Y-m-d\u2019),<\/span><\/p>\n

\u2018promote_end_date\u2019   => local_date(\u2018Y-m-d\u2019, local_strtotime(\u2018+1 month\u2019)),<\/span><\/p>\n

\u2018goods_weight\u2019  => 0,<\/span><\/p>\n

\u2018give_integral\u2019 => -1,<\/span><\/p>\n

\u2018rank_integral\u2019 => -1<\/span><\/p>\n

);<\/span><\/p>\n

\u63d2\u5165\u548c\u4fee\u6539\u90e8\u4efd\u4fee\u6539\u7684\u4ee3\u7801:<\/span><\/p>\n

805\u884c<\/span><\/p>\n

$is_on_sale = isset($_POST[‘is_on_sale’]) ? 1 : 0;<\/span><\/p>\n

$is_bonus = isset($_POST[‘is_bonus’]) ? 1 : 0;<\/span><\/p>\n

$is_alone_sale = isset($_POST[‘is_alone_sale’]) ? 1 : 0;<\/span><\/p>\n

\/* \u5165\u5e93 *\/<\/span><\/p>\n

if ($is_insert)<\/span><\/p>\n

{<\/span><\/p>\n

if ($code == \u201d)<\/span><\/p>\n

{<\/span><\/p>\n

$sql = \u201cINSERT INTO \u201d . $ecs->table(\u2018goods\u2019) . \u201d (goods_name, goods_name_style, goods_sn, \u201d .<\/span><\/p>\n

\u201ccat_id, brand_id, shop_price, market_price, is_promote, promote_price, \u201d .<\/span><\/p>\n

\u201cpromote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, \u201d .<\/span><\/p>\n

\u201cseller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, \u201d .<\/span><\/p>\n

\u201cis_on_sale, is_bonus,is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id)\u201d .<\/span><\/p>\n

\u201cVALUES (\u2018$_POST[goods_name]\u2018, \u2018$goods_name_style\u2019, \u2018$goods_sn\u2019, \u2018$catgory_id\u2019, \u201d .<\/span><\/p>\n

\u201c\u2018$brand_id\u2019, \u2018$shop_price\u2019, \u2018$market_price\u2019, \u2018$is_promote\u2019,’$promote_price\u2019, \u201c.<\/span><\/p>\n

\u201c\u2018$promote_start_date\u2019, \u2018$promote_end_date\u2019, \u2018$goods_img\u2019, \u2018$goods_thumb\u2019, \u2018$original_img\u2019, \u201c.<\/span><\/p>\n

\u201c\u2018$_POST[keywords]\u2018, \u2018$_POST[goods_brief]\u2018, \u2018$_POST[seller_note]\u2018, \u2018$goods_weight\u2019, \u2018$goods_number\u2019,\u201d.<\/span><\/p>\n

\u201d \u2018$warn_number\u2019, \u2018$_POST[integral]\u2018, \u2018$give_integral\u2019, \u2018$is_best\u2019, \u2018$is_new\u2019, \u2018$is_hot\u2019, \u2018$is_on_sale\u2019,\u2018$is_bonus\u2019,\u2019$is_alone_sale\u2019, $is_shipping, \u201c.<\/span><\/p>\n

\u201d \u2018$_POST[goods_desc]\u2018, \u2018\u201d . gmtime() . \u201c\u2018, \u2018\u201d. gmtime() .\u201d\u2018, \u2018$goods_type\u2019, \u2018$rank_integral\u2019, \u2018$suppliers_id\u2019)\u201d;<\/span><\/p>\n

}<\/span><\/p>\n

else<\/span><\/p>\n

{<\/span><\/p>\n

$sql = \u201cINSERT INTO \u201d . $ecs->table(\u2018goods\u2019) . \u201d (goods_name, goods_name_style, goods_sn, \u201d .<\/span><\/p>\n

\u201ccat_id, brand_id, shop_price, market_price, is_promote, promote_price, \u201d .<\/span><\/p>\n

\u201cpromote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, \u201d .<\/span><\/p>\n

\u201cseller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, is_real, \u201d .<\/span><\/p>\n

\u201cis_on_sale,is_bonus,is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)\u201d .<\/span><\/p>\n

\u201cVALUES (\u2018$_POST[goods_name]\u2018, \u2018$goods_name_style\u2019, \u2018$goods_sn\u2019, \u2018$catgory_id\u2019, \u201d .<\/span><\/p>\n

\u201c\u2018$brand_id\u2019, \u2018$shop_price\u2019, \u2018$market_price\u2019, \u2018$is_promote\u2019,’$promote_price\u2019, \u201c.<\/span><\/p>\n

\u201c\u2018$promote_start_date\u2019, \u2018$promote_end_date\u2019, \u2018$goods_img\u2019, \u2018$goods_thumb\u2019, \u2018$original_img\u2019, \u201c.<\/span><\/p>\n

\u201c\u2018$_POST[keywords]\u2018, \u2018$_POST[goods_brief]\u2018, \u2018$_POST[seller_note]\u2018, \u2018$goods_weight\u2019, \u2018$goods_number\u2019,\u201d.<\/span><\/p>\n

\u201d \u2018$warn_number\u2019, \u2018$_POST[integral]\u2018, \u2018$give_integral\u2019, \u2018$is_best\u2019, \u2018$is_new\u2019, \u2018$is_hot\u2019, 0, \u2018$is_on_sale\u2019,\u2018$is_bonus\u2019,$is_alone_sale\u2019, $is_shipping, \u201c.<\/span><\/p>\n

\u201d \u2018$_POST[goods_desc]\u2018, \u2018\u201d . gmtime() . \u201c\u2018, \u2018\u201d. gmtime() .\u201d\u2018, \u2018$goods_type\u2019, \u2018$code\u2019, \u2018$rank_integral\u2019)\u201d;<\/span><\/p>\n

}<\/span><\/p>\n

}<\/span><\/p>\n

901\u884c\uff1a<\/span><\/p>\n

$sql .= \u201ckeywords = \u2018$_POST[keywords]\u2018, \u201d .<\/span><\/p>\n

\u201cgoods_brief = \u2018$_POST[goods_brief]\u2018, \u201d .<\/span><\/p>\n

\u201cseller_note = \u2018$_POST[seller_note]\u2018, \u201d .<\/span><\/p>\n

\u201cgoods_weight = \u2018$goods_weight\u2019,\u201d .<\/span><\/p>\n

\u201cgoods_number = \u2018$goods_number\u2019, \u201d .<\/span><\/p>\n

\u201cwarn_number = \u2018$warn_number\u2019, \u201d .<\/span><\/p>\n

\u201cintegral = \u2018$_POST[integral]\u2018, \u201d .<\/span><\/p>\n

\u201cgive_integral = \u2018$give_integral\u2019, \u201d .<\/span><\/p>\n

\u201crank_integral = \u2018$rank_integral\u2019, \u201d .<\/span><\/p>\n

\u201cis_best = \u2018$is_best\u2019, \u201d .<\/span><\/p>\n

\u201cis_new = \u2018$is_new\u2019, \u201d .<\/span><\/p>\n

\u201cis_hot = \u2018$is_hot\u2019, \u201d .<\/span><\/p>\n

\u201cis_bonus = \u2018$is_bonus\u2019, \u201d .<\/span><\/p>\n

\u201cis_on_sale = \u2018$is_on_sale\u2019, \u201d .<\/span><\/p>\n

\u201cis_alone_sale = \u2018$is_alone_sale\u2019, \u201d .<\/span><\/p>\n

\u201cis_shipping = \u2018$is_shipping\u2019, \u201d .<\/span><\/p>\n

\u201cgoods_desc = \u2018$_POST[goods_desc]\u2018, \u201d .<\/span><\/p>\n

\u201clast_update = \u2018\u201d. gmtime() .\u201d\u2018, \u201c.<\/span><\/p>\n

\u201cgoods_type = \u2018$goods_type\u2019 \u201d .<\/span><\/p>\n

\u201cWHERE goods_id = \u2018$_REQUEST[goods_id]\u2018 LIMIT 1\u2033;<\/span><\/p>\n

\u7b2c\u56db\u6b65\uff1a\u4fee\u6539\u540e\u53f0\u6a21\u677f\u9875goods_list.htm<\/span><\/p>\n

25\u884c\uff1a<\/span><\/p>\n

<th><a href=\u201djavascript:listTable.sort(\u2018is_hot\u2019); \u201c>{$lang.is_hot}<\/a>{$sort_is_hot}<\/th><\/span><\/p>\n

<th><a href=\u201djavascript:listTable.sort(\u2018is_bonus\u2019); \u201c>\u7ea2\u5305<\/a>{$sort_is_bonus}<\/th><\/span><\/p>\n

<th><a href=\u201djavascript:listTable.sort(\u2018sort_order\u2019); \u201c>{$lang.sort_order}<\/a>{$sort_sort_order}<\/th><\/span><\/p>\n

47\u884c\uff1a<\/span><\/p>\n

<td align=\u201dcenter\u201d><img src=\u201dimages\/{if $goods.is_hot}yes{else}no{\/if}.gif\u201d onclick=\u201dlistTable.toggle(this, \u2018toggle_hot\u2019, {$goods.goods_id})\u201d \/><\/td><\/span><\/p>\n

<td align=\u201dcenter\u201d><img src=\u201dimages\/{if $goods.is_bonus}yes{else}no{\/if}.gif\u201d onclick=\u201dlistTable.toggle(this, \u2018toggle_bonus\u2019, {$goods.goods_id})\u201d \/><\/td><\/span><\/p>\n

<td align=\u201dcenter\u201d><span onclick=\u201dlistTable.edit(this, \u2018edit_sort_order\u2019, {$goods.goods_id})\u201d>{$goods.sort_order}<\/span><\/td><\/span><\/p>\n

98\u884c\uff1a<\/span><\/p>\n

<option value=\u201dnot_hot\u201d>{$lang.not_hot}<\/option><\/span><\/p>\n

<option value=\u201dbonus\u201d>\u4f7f\u7528\u7ea2\u5305<\/option><\/span><\/p>\n

<option value=\u201dnot_bonus\u201d>\u53d6\u6d88\u7ea2\u5305\u4f7f\u7528<\/option><\/span><\/p>\n

<option value=\u201dmove_to\u201d>{$lang.move_to}<\/option><\/span><\/p>\n

\u7b2c\u4e94\u6b65\uff1a\u4fee\u6539\u540e\u53f0goods.php<\/span><\/p>\n

\u57281500\u884c\u5de6\u53f3\u52a0\u4e0a<\/span><\/p>\n

\/*\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 *\/<\/span><\/p>\n

\/\/\u2013 \u4fee\u6539\u7ea2\u5305\u4f7f\u7528\u72b6\u6001<\/span><\/p>\n

\/*\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 *\/<\/span><\/p>\n

elseif ($_REQUEST[‘act’] == \u2018toggle_bonus\u2019)<\/span><\/p>\n

{<\/span><\/p>\n

check_authz_json(\u2018goods_manage\u2019);<\/span><\/p>\n

 <\/span><\/p>\n

$goods_id       = intval($_POST[‘id’]);<\/span><\/p>\n

$is_bonus         = intval($_POST[‘val’]);<\/span><\/p>\n

 <\/span><\/p>\n

if ($exc->edit(\u201cis_bonus = \u2018$is_bonus\u2019, last_update=\u201d .gmtime(), $goods_id))<\/span><\/p>\n

{<\/span><\/p>\n

clear_cache_files();<\/span><\/p>\n

make_json_result($is_bonus);<\/span><\/p>\n

}<\/span><\/p>\n

}<\/span><\/p>\n

\/*\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 *\/<\/span><\/p>\n

\/\/\u2013 \u4fee\u6539\u5546\u54c1\u6392\u5e8f<\/span><\/p>\n

\/*\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 *\/<\/span><\/p>\n

\u5230\u6b64\u540e\u53f0\u529f\u80fd\u5df2\u7ecf\u4fee\u6539\u5b8c\u6210<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u4ee5ecshop\u6700\u65b0\u7248\u672c273\u4e3a\u4f8b\uff1a  \u7b2c\u4e00\u6b65\uff1a\u5728goods\u8868\u683c\u589e\u52a0\u4e00\u4e2a\u5b57\u6bb5 is_bonus \u7c7b\u578b tinyint \u9ed8\u8ba4\u4e3a1 (1\u662f\u53ef\u4ee5\u4f7f\u7528\u7ea2\u5305) \u7b2c\u4e8c\u6b65\uff1a\u4fee\u6539\u540e\u53f0\u6a21\u677f\u9875 goods_info.htm <tr id=\u201dalone_sale_1\u2033><td id=\u201dalone_sale_2\u2033>{$lang.lab_is_on_sale}<\/td><td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_on_sale\u201d value=\u201d1\u2033 {if $goods.is_on_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.on_sale_desc}<\/td><\/tr><tr id=\u201dalone_sale_1\u2033><td id=\u201dalone_sale_2\u2033>\u7ea2\u5305\u4f7f\u7528<\/td><td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_bonus\u201d value=\u201d1\u2033 {if $goods.is_bonus}checked=\u201dchecked\u201d{\/if} \/> \u6253\u52fe\u8868\u793a\u5141\u8bb8\u7528\u4f7f\u7528\u7ea2\u5305\uff0c\u5426\u5219\u4e0d\u5141\u8bb8\u4f7f\u7528\u3002<\/td><\/tr><tr><td>{$lang.lab_is_alone_sale}<\/td><td><input type=\u201dcheckbox\u201d name=\u201dis_alone_sale\u201d value=\u201d1\u2033 {if $goods.is_alone_sale}checked=\u201dchecked\u201d{\/if} \/> {$lang.alone_sale}<\/td><\/tr> <tr id=\u201dalone_sale_1\u2033>            <td id=\u201dalone_sale_2\u2033>{$lang.lab_is_on_sale}<\/td>            <td id=\u201dalone_sale_3\u2033><input type=\u201dcheckbox\u201d name=\u201dis_on_sale\u201d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-59413","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=59413"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59413\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}