登录后，购买下载资源更方便！
您需要 登录 才可以下载或查看，没有账号？立即注册
×
针对ecshop订单中的物品，需要支持拣货的状态，比如未拣货、拣货中、拣货完成，以及显示拣货人姓名。, ^$ z3 a# ~, [$ O# [) u
8 M Z' b: [0 }6 b" a1.SQL操作：
- d1 S! Z5 p3 _8 D8 _& G2 L& a4 | Y8 f* X% x4 E
2.在文件languages\zh_cn\admin\order.php中增加：
# v, }2 [: Q2 p% I: H
4 K! r% f6 R5 \( R- o% n/* 拣货 */
( p- y+ U6 {" c; ]9 p& s7 P7 \: u$_LANG['order_picking_status'] = '拣货状态';' E$ `- n' I. S
$_LANG['order_picking_status_none'] = '未拣货';
/ o C; o1 _- t- A# F$ ]$ u/ s$_LANG['order_picking_status_processing'] = '拣货中';
2 d; l: B" T# d ]1 H! n2 x2 W1 W$_LANG['order_picking_status_finish'] = '拣货完成';
, `1 G* X! Q0 V ]( H3 v ]$_LANG['invalid_order_picking_status'] = '拣货状态无效。0：未拣货；1：拣货中；2：拣货完成';8 t0 {9 C8 g: y. r6 n0 J1 r
3 k3 Q' e# m. N& F" n; K
) R& P0 H. n! g: p, X% u2 y3.文件admin\templates\order_list.htm中在一下两行之间：% e: Q( s0 [! _7 J
第一个地方
: K5 c7 y7 i Q9 s* ^8 d<th>{$lang.all_status}</th>
6 d: E$ t) Q$ z: b j! R<th>{$lang.handler}</th>: C5 f/ C8 K' m; Y
中间加上8 ]' a" k, E6 ^- L( l6 U* E
<th>{$lang.order_picking_status}</th>2 c/ P! a# _) I0 N5 ?0 t
& U: f- d9 U& b6 Z4 h
第二个地方- W+ O( U4 I; b8 {. r
在<td align="center" valign="top" nowrap="nowrap">{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}</td>
4 E4 W1 j& m. T4 B$ x6 z! D后面加上' T+ P9 V- _: V1 {( \1 i! F
<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>& ~' U3 P, _6 M
9 n6 ]* T4 T% z/ ]1 b+ D7 I# [: a
! d- Y5 W7 D9 h
) V+ p& U- n: H2 R. @4.admin\js\listtable.js中，listTable.edit的响应函数修改如下：
6 F- K# b' b" R" V9 t2 @3 x a& n7 m
5 ~5 p, E& e F, i* ~: _) F: k; i
/** * 创建一个可编辑区 */ 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' d0 |) N, H( D" P$ W# F
}
# B. @, s: R2 |/ b0 {& a, a5.admin\order.php文件中增加下面的函数：/ m; l) {- @- N' n0 u/ _
! T, S- J6 P: K0 `5 E* f- B) T
/*------------------------------------------------------ */2 P3 P# Y$ h7 j7 c' M
//-- 订单拣货状态查询
* ]8 Y) u; d) p5 J5 n# `/*------------------------------------------------------ */, ^) Y: N) x3 g+ n8 n- N
: j( k: T. q8 `
if ($_REQUEST['act'] == 'edit_order_picking_status')
& \ F" K! _% ~1 H) f/ _% g{
6 I' q2 z& G& u- }6 d( I /* 检查权限 */3 X5 s$ V( k6 k! k: D2 R f1 S8 j
check_authz_json('users_manage');
& `% W$ q/ l, a- L" I , D+ N+ R) p: y/ K( g. u
$id =empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);1 o- z/ F% i5 @) i5 v$ p& D1 `$ ~
$order_picking_status =empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
+ Y. L) B+ t7 Q
+ W2 N5 h! `1 A# E $sql = "DELETE fromorder_picking_status WHERE order_id = '". $id ."' LIMIT 1";) ^% _8 n9 V% B
$db->query($sql);
; Y+ I9 ^0 |# s' X. H$ w 2 C( a4 o0 h( v7 N# g4 N$ d
$sql = "INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('". $id ."', '". $_SESSION['admin_name'] ."', '".$order_picking_status ."')";1 M1 j+ \4 |) G7 q2 A
$db->query($sql);" } K% w, W- e& V5 \
6 {5 e- M4 w+ c; \! Y$ ]
if ($order_picking_status> 2 || $order_picking_status < 0)
5 P4 W3 r$ z; }: Q4 P5 u {/ G/ N5 m6 ]0 s$ W
make_json_error($GLOBALS['_LANG']['invalid_order_picking_status']);, @0 V! e- s! V4 @. b7 @2 \" P
}
/ P. v# T0 i" I& W6 p: G! _: R else* U- ?: P$ G# F6 \
{
+ g8 e% n. X; b9 ~* z make_json_result($order_picking_status);! m. n& S* E: N4 q
}0 j" |) A! y+ o9 a9 I+ q; R* q' g
}- v- s; L$ M& T* @# h$ X% ?9 w
A3 S: r1 u+ J. q( }( j4 W6、admin\order.php文件中增加下面的函数将以下代码
. b/ S0 T. j1 Z7 z9 s /* 查询 */ i h. e) {$ j" u) P+ T6 o
$sql = "SELECT o.*," .
: _& Q( _( U/ c "o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .! C: @% m8 X" |2 @3 C
"(" . order_amount_field('o.') . ") AS total_fee, " .
+ }) Y; {! D: a' ^2 | "IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".
4 t4 i" X0 N7 ?( n* h- O. N8 d " FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .5 ]6 w# u" O3 V
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". $where .
7 v6 x) ?6 P2 U, [- Z) I' f3 p! P " ORDER BY $filter[sort_by] $filter[sort_order] "., j+ s2 |$ i p _
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
' e7 ~* u0 S; o7 M& n4 t修改为：7 D* b# {4 g$ z5 |& ~' E
//* 查询 */
2 x+ ]+ K5 u+ l: r" E/ @* K0 f $sql = "SELECT o.*," .* Y0 G" q" {/ k6 A& V
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .
}- t3 a! I7 ? "(" . order_amount_field('o.') . ") AS total_fee, " . l+ d, ^0 H. c* e1 N& R( ~
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer , p.user_name, p.order_picking_status, r.order_reply_status ".1 A/ U. [$ `# G6 \0 d8 s2 l
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
2 {2 R0 _4 N5 t* h; [ " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". 1 a& e3 [2 A3 y4 |* ^9 z' o: d4 Z
" LEFT JOIN order_reply_status AS r ON r.order_id = o.order_id ".
8 |8 j1 o6 F, z1 f9 d0 _0 v! `" LEFT JOIN order_picking_status AS p ON p.order_id = o.order_id ". $where .
! [4 @6 X2 H% l$ L0 e " ORDER BY $filter[sort_by] $filter[sort_order] ". & a- O7 }0 x6 V3 S) z
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
2 ^ \8 x( c6 F" w* P6 y1 i# N( F
/ Y- @& n% _% z' y i
! i- d) }4 x4 z
: W6 `; v& c' J+ Q |
