科恒数字网
标题: 给ecshop订单流程增加拣货状态,最新版本,支持ECSHOP3.6系统 [打印本页]
作者: admin 时间: 2020-6-12 09:15
标题: 给ecshop订单流程增加拣货状态,最新版本,支持ECSHOP3.6系统
针对ecshop订单中的物品,需要支持拣货的状态,比如未拣货、拣货中、拣货完成,以及显示拣货人姓名。5 i& F* }; B: l% S/ T
, \$ E4 l, q6 M+ ]# Q3 }1.SQL操作:
- V {' I6 D8 l( ^& J+ S
# T; s& f" _/ {* [$ V c2.在文件languages\zh_cn\admin\order.php中增加:! j) {, g! e9 \0 P7 {4 q
& M+ J7 s8 o# b0 J+ Y3 u* W8 m& Q/* 拣货 *// B- `9 Y4 d0 ~& t& d0 L; v
$_LANG['order_picking_status'] = '拣货状态';
% Z: r8 `, e3 ]& t: k2 v$ \: q2 Z$_LANG['order_picking_status_none'] = '未拣货';
% D. ~* H$ P" B* g/ Q$_LANG['order_picking_status_processing'] = '拣货中';/ A! j. c- l7 e9 R! c! ]" Q
$_LANG['order_picking_status_finish'] = '拣货完成';
$ i7 v2 y9 l! a8 W5 ], b$_LANG['invalid_order_picking_status'] = '拣货状态无效。0:未拣货;1:拣货中;2:拣货完成';
# |. ?8 T; z/ \# A6 K( Y. Y, |, O7 e5 B
9 z! x$ N. Q/ |$ l& D# _
3.文件admin\templates\order_list.htm中在一下两行之间:
6 ], q! h! `3 f% F: Q D 第一个地方
# T7 l: A# T9 I<th>{$lang.all_status}</th>0 D- d- ~" n4 E; O- [; r$ Y) ?
<th>{$lang.handler}</th>1 Y" g7 h: a" H2 a! ^
中间加上
8 k% B# z9 R) B/ @0 U4 c% z<th>{$lang.order_picking_status}</th>+ x1 g3 h7 |' v$ _0 ^
3 {% l* Y& w, J6 d* f第二个地方0 X$ U) d+ Q$ o6 k- r6 e
在<td align="center" valign="top" nowrap="nowrap">{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}</td>7 X* s2 o- a8 i% G7 o: ~
后面加上
5 ?2 T( ?3 {4 c' G# G5 R<td align="right" valign="top"nowrap="nowrap"><span>{$order.user_name}【{if $order.order_picking_status == 1}{$lang.order_picking_status_processing}{elseif $order.order_picking_status ==2} {$lang.order_picking_status_finish} {else}{$lang.order_picking_status_none}{/if}】</span></td>
7 m& d0 h% s$ e$ R- f' D! ]/ T6 ? ?# g3 B6 `$ r0 v$ ~9 Q6 u7 m
, W) R) ~% i' h
- U3 z3 b2 H( c& b4.admin\js\listtable.js中,listTable.edit的响应函数修改如下:
4 ?+ O/ M& V" k* i, k6 _/ \) M: N! ?/ f: Y- L* t F: v+ r4 b7 e
+ Z' N1 n: q& V) x0 K9 Z3 }1 l/**
* 创建一个可编辑区
*/
listTable.edit = function(obj, act, id)
{
var tag =obj.firstChild.tagName;
if (typeof(tag) !="undefined" && tag.toLowerCase() == "input")
{
return;
}
/* 保存原始的内容 */
var org = obj.innerHTML;
var val = Browser.isIE ?obj.innerText : obj.textContent;
/* 创建一个输入框 */
var txt =document.createElement("INPUT");
txt.value = (val == 'N/A') ?'' : val;
txt.style.width =(obj.offsetWidth + 12) + "px" ;
/* 隐藏对象中的内容,并将输入框加入到对象中 */
obj.innerHTML ="";
obj.appendChild(txt);
txt.focus();
txt.select();
/* 编辑区输入事件处理函数 */
txt.onkeypress = function(e)
{
var evt =Utils.fixEvent(e);
var obj =Utils.srcElement(e);
if (evt.keyCode == 13)//www.zuimoban.com
{
obj.blur();
return false;
}
if (evt.keyCode == 27)
{
obj.parentNode.innerHTML= org;
}
}
/* 编辑区失去焦点的处理函数 */
txt.onblur = function(e)
{
if(Utils.trim(txt.value).length > 0)
{
res =Ajax.call(listTable.url, "act="+act+"&val=" +encodeURIComponent(Utils.trim(txt.value)) + "&id=" +id, null,"POST", "JSON", false);
if (res.message)
{
alert(res.message);
}
if(res.id &&(res.act == 'goods_auto' || res.act == 'article_auto'))
{
document.getElementById('del'+res.id).innerHTML = "<ahref=\""+ thisfile +"?goods_id="+ res.id+"&act=del\" onclick=\"returnconfirm('"+deleteck+"');\">"+deleteid+"</a>";
}
obj.innerHTML = (res.error== 0) ? res.content : org;
}
else
{
obj.innerHTML = org;
}
if (act =='edit_is_validated')
{
var content = obj.innerHTML.trim();
if (content == '1' || content.indexOf("yes") >= 0)
{
obj.innerHTML = '<imgsrc="images/yes.gif">';
}
else
{
obj.innerHTML ='<img src="images/no.gif">';
}
}
else if (act =='edit_order_picking_status')
{
if (org == obj.innerHTML)
{
return true;
}
if (obj.innerHTML == '1')
{
obj.innerHTML ="【拣货中】";
}
else if (obj.innerHTML == '2')
{
obj.innerHTML ="【拣货完成】";
}
else
{
obj.innerHTML ="【未拣货】";
}
}
else
{
}
}
: [6 [' z! i' t: o( q/ c, k
}
+ ~3 Z/ ~9 Q) X2 H" f! k& e
5.admin\order.php文件中增加下面的函数:& a$ P5 f1 V+ n# ?; Y) w, c& _9 h. I
2 }# G" {' Q! u( L# A8 }
/*------------------------------------------------------ */% E4 [' W9 ?& c
//-- 订单拣货状态查询
' }" B" B) l0 h: n+ B- l/*------------------------------------------------------ */- K* t7 Q, ~2 ]& z
* d0 Z! H& r3 `- \5 Q; Z# a
if ($_REQUEST['act'] == 'edit_order_picking_status')
$ r7 k+ q' |0 |/ U{
- |) N' A( B6 B) ?4 r /* 检查权限 */8 N+ D0 y7 V2 s
check_authz_json('users_manage');
* M; Q7 M2 J2 [" ~4 v8 H- h4 s ' u4 \+ }% U' `
$id =empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);8 B# Q2 ^# ^7 I+ t p% `
$order_picking_status =empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));9 K" {5 H# ` c, ]* b- q
' D$ x6 [8 |" j+ h+ M2 G% E3 A* f $sql = "DELETE fromorder_picking_status WHERE order_id = '". $id ."' LIMIT 1";0 ]( x k! T' M @* B) O
$db->query($sql);9 x# q# v- K/ m1 ]+ U
3 ~; N; H" c' \1 X# f* z
$sql = "INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('". $id ."', '". $_SESSION['admin_name'] ."', '".$order_picking_status ."')";, {9 F; R( e) ? P2 B
$db->query($sql);
7 T+ l0 n+ T6 |! W1 P- ?2 e
" _" x- L2 Q/ I1 s, |% k4 F* e if ($order_picking_status> 2 || $order_picking_status < 0)' c) Y# [! n# \) n+ q+ `
{0 S- t' M& l9 L* e: s/ Z# B
make_json_error($GLOBALS['_LANG']['invalid_order_picking_status']);: _ F% |1 q5 o! u4 j& I7 Z a
}
* {% W1 E6 {0 k& s" e else
/ A- z1 f; K; A9 ~$ V1 Q0 P' f {7 U( M% g! g/ R1 y
make_json_result($order_picking_status);
( ]- S* m4 u& H9 @& Z( |' J }
7 h$ |- R$ Y# d( s/ M3 C6 W}+ V) a/ ?6 @" ^' N+ V, S5 ^' r+ O
" e+ ^( A$ @, D5 q. k4 Q
6、admin\order.php文件中增加下面的函数将以下代码9 Q G& D3 O) q" t
/* 查询 */( C' _# ~. `6 N9 z8 m/ a3 v' E6 s9 G
$sql = "SELECT o.*," .$ M. Z8 y9 |* J! \; Y" B
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .1 y$ v* P# [2 M( e/ e6 u
"(" . order_amount_field('o.') . ") AS total_fee, " .
. K; p: `0 k2 F/ D) u4 b "IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".& @/ J( u2 W0 Y7 l
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
0 y, l# V4 R& ` " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". $where . / H, m% G: V! g+ x% L
" ORDER BY $filter[sort_by] $filter[sort_order] ".% C% ?6 v; W/ @. ?( H
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
1 @6 R$ a2 O6 W- R- T/ Q修改为:
* ~; J8 c9 X2 K+ P3 S) ` //* 查询 */9 T% k* ^! B0 d- u2 }
$sql = "SELECT o.*," . Y p; y7 G. Q; M
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .
, O. z- K. X) @3 V3 K: g3 f$ | "(" . order_amount_field('o.') . ") AS total_fee, " .( j- d, |$ N4 e$ D/ a
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer , p.user_name, p.order_picking_status, r.order_reply_status ".# K, D0 e+ Q3 c! M
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
2 v, B c- I! t1 |! I " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ".
6 f. S9 b& U* i) f3 D9 L " LEFT JOIN order_reply_status AS r ON r.order_id = o.order_id ". 4 E/ j$ B! B1 |6 h% H; q
" LEFT JOIN order_picking_status AS p ON p.order_id = o.order_id ". $where .
4 n2 C+ o# x) G' f" C4 c6 x " ORDER BY $filter[sort_by] $filter[sort_order] ".
; A' W+ |" h7 k* X8 C1 ^ " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";7 Y6 D& V, S. T( o% M
. X: `# Z2 P1 Q8 D: m- r) N$ j3 ^
& ?& }8 M! u' T+ n
" W6 ~+ R9 w5 v% t* H
欢迎光临 科恒数字网 (https://www.khcic.com/) |
Powered by Discuz! X3.5 |