登录后,购买下载资源更方便!
您需要 登录 才可以下载或查看,没有账号?立即注册
×
针对ecshop订单中的物品,需要支持拣货的状态,比如未拣货、拣货中、拣货完成,以及显示拣货人姓名。
7 Q1 o1 X# w# a4 s3 @# R# x3 Q& Q7 P% L4 O: c
1.SQL操作:3 U. ^/ D- E1 e
, X5 w+ P: g% S) H* W2.在文件languages\zh_cn\admin\order.php中增加:
- i: F; `, ~0 Z7 p" @' P
5 l" k1 T' Y. w3 ]) d9 x' M/* 拣货 *// z2 R7 d4 a3 d
$_LANG['order_picking_status'] = '拣货状态';
" y9 m' j, y' o' D! l; J$_LANG['order_picking_status_none'] = '未拣货';
( ~9 s8 C" M$ q& C. N! R% ^( x: E$_LANG['order_picking_status_processing'] = '拣货中';
3 F7 q0 p9 X5 O. s( p$_LANG['order_picking_status_finish'] = '拣货完成';
9 ]& y: j! O- T7 ~1 g" r$_LANG['invalid_order_picking_status'] = '拣货状态无效。0:未拣货;1:拣货中;2:拣货完成';
6 `, t+ ~( B g0 @+ ~+ ^; E/ t" k% u# L
0 X7 c- F# ~/ l3 v, e/ E
3.文件admin\templates\order_list.htm中在一下两行之间:# j( B, T, v3 ?* c- z) J
第一个地方, }- |6 a6 {* U ?* h5 E
<th>{$lang.all_status}</th>
- z# q% n8 F+ |) V) s<th>{$lang.handler}</th> B; D5 a% E, @, m
中间加上
8 }. a/ i, y: k7 }& `# i' m6 ]<th>{$lang.order_picking_status}</th>
9 u1 _) ^- I2 I( Q, N; \! V: Q! F, L( b# ?. C5 i
第二个地方
! V+ d* D z3 X. [; R5 V! P% k在<td align="center" valign="top" nowrap="nowrap">{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}</td>
& ~! m" [. c" N( S后面加上
9 A+ |0 L4 u, h% w* ]* \<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>
! S% K+ Y$ e3 |, F0 F
) |- {2 t) g9 g* e+ o! [/ `: y# y0 W# I M2 g
7 y% N# K7 ^$ I: D! z0 F
4.admin\js\listtable.js中,listTable.edit的响应函数修改如下:$ e5 d) q: ~. _( k; Z4 t7 B7 v
. F; X, {0 |* `" I4 ?& F3 @
5 @5 w b: K$ Q. Z2 h
/** * 创建一个可编辑区 */ 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 { } } ; h$ z2 M. Q2 d: ]- N9 G0 ~5 ?
}
# O* A1 Z9 d9 K1 w( U2 V% [5.admin\order.php文件中增加下面的函数:
* T- i6 S/ t% W( @$ Z2 d. h1 J+ s" \ U4 N
/*------------------------------------------------------ */2 U# _4 K/ q7 p
//-- 订单拣货状态查询' F: [. v. Y2 q2 o. y( O
/*------------------------------------------------------ */2 E& C' o. {2 E8 w3 e3 z$ `
' O6 y2 ~6 W6 J$ K, J0 h) Eif ($_REQUEST['act'] == 'edit_order_picking_status'); Z% ~+ p9 k/ f b" i
{
- z& g* X3 c, ]1 W /* 检查权限 */; m7 B3 k: }( k$ E" h, I
check_authz_json('users_manage');0 K/ z& t2 b; ]+ {
$ I! y( ~( y/ Z& v9 T
$id =empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);0 x) x* F% r' A* m! e
$order_picking_status =empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));4 P# g/ U# f+ \8 D/ K" }$ |
! U/ A# S- {/ K+ T) H $sql = "DELETE fromorder_picking_status WHERE order_id = '". $id ."' LIMIT 1";4 ]. o& Y1 L p# D
$db->query($sql);4 }% F& U2 I/ L2 _4 x) m
& n! {0 r7 M2 U9 o$ j3 w $sql = "INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('". $id ."', '". $_SESSION['admin_name'] ."', '".$order_picking_status ."')";
- z6 V6 X* i3 _1 n; h5 p $db->query($sql);1 ?& \7 w, i' R# s+ C
4 m( A2 X4 h- g( W if ($order_picking_status> 2 || $order_picking_status < 0)2 g- G( i8 F; F% ?
{
/ O( R5 p5 B8 n8 A5 E make_json_error($GLOBALS['_LANG']['invalid_order_picking_status']);- H3 W( Y" V! @7 o: d! p
}$ ~7 [# ^ b5 y, T) L1 ^) T
else% N `5 A) q6 N2 p- b4 l9 a( |5 g F
{% v# `! ~2 |( t( F0 s7 F, f
make_json_result($order_picking_status);
" y ~6 a) C/ ^+ p+ {/ ~" m9 M }
. w; x! B# A" d$ g3 {( j}
& a8 `$ W: W( a5 Y' `8 n: T' n8 J& j# w
- J9 q% d: A# h& F1 `5 Y) V6、admin\order.php文件中增加下面的函数将以下代码0 O2 i: H* I+ P. D; w
/* 查询 */
1 e1 d v/ w! G5 y1 T* u# x$ w$sql = "SELECT o.*," .- X" l6 [: @+ f- m
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .4 r8 q3 U# V& x* ?" e6 z
"(" . order_amount_field('o.') . ") AS total_fee, " ." w& F, j3 S. k- _; i2 b( g' E" R
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".- F- F4 O! y4 n& U+ f
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
+ Y2 K$ w* C9 m* L- S " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". $where .
]! A% U7 b3 N6 a4 T: K$ { " ORDER BY $filter[sort_by] $filter[sort_order] ".
+ o- }$ N4 ?! H9 J3 N+ `. a" ? " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]"; . u) l1 X% u+ Y
修改为:1 x" @5 j6 {8 {
//* 查询 */
* F! W% r$ t6 i& L+ S $sql = "SELECT o.*," .' Z' |7 ]0 A5 [
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .2 @3 _' e2 k3 v7 H2 @
"(" . order_amount_field('o.') . ") AS total_fee, " .4 E/ f5 E3 D# P3 ^
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer , p.user_name, p.order_picking_status, r.order_reply_status ".& G( f- I1 U% p- N7 [# C3 H
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
; n% _( }+ `% g# M4 } B" r; a- f/ ` " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". " [2 O2 d3 B, n6 ~
" LEFT JOIN order_reply_status AS r ON r.order_id = o.order_id ". 2 q( s0 r& I3 Q ^( ^
" LEFT JOIN order_picking_status AS p ON p.order_id = o.order_id ". $where .
5 A* u- J! L- C T " ORDER BY $filter[sort_by] $filter[sort_order] ".
* F3 v0 D! [3 n; ] H; R " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
& f3 m' R4 B: S5 n* f3 w$ h$ }( `6 u8 M8 D8 J4 p8 @# `7 Z) I
, n5 C5 W8 g1 n4 }' y! N! n' K* T* H
|