登录后,购买下载资源更方便!
您需要 登录 才可以下载或查看,没有账号?立即注册
×
针对ecshop订单中的物品,需要支持拣货的状态,比如未拣货、拣货中、拣货完成,以及显示拣货人姓名。5 L' H; U: b! |) U2 J, I
+ }' S( s: R5 _* o" |- Q& T
1.SQL操作:+ y. v! ]; J) E4 ]9 _3 r6 R. C! f
8 p I' F3 X: `+ b2.在文件languages\zh_cn\admin\order.php中增加:/ `7 S3 _! c8 d% N
8 r+ f0 W' Q" ~4 t. B5 P S
/* 拣货 */
- U' W" r% S8 K0 s$_LANG['order_picking_status'] = '拣货状态';
1 V8 N6 A" a# u! _4 B$_LANG['order_picking_status_none'] = '未拣货';
4 G# o7 a, S6 u% w1 ~, Z8 |+ v8 t$_LANG['order_picking_status_processing'] = '拣货中';
; I- N/ [- {1 _2 Q$_LANG['order_picking_status_finish'] = '拣货完成';
9 r1 D7 ?1 V! V$_LANG['invalid_order_picking_status'] = '拣货状态无效。0:未拣货;1:拣货中;2:拣货完成';
$ K* t% O0 c& b# i# t0 u B
" A$ d' ^/ w5 E1 z- V9 V. W
; }$ j c+ j! @- v( L+ d7 n3.文件admin\templates\order_list.htm中在一下两行之间:
; i- Q$ x% Z1 r! V7 E r9 _# j7 q 第一个地方
" p8 _# H9 v% P# a9 V8 b, b5 A5 V<th>{$lang.all_status}</th>
8 S" S9 Q7 ^0 u5 {<th>{$lang.handler}</th>) h0 S k" I( S# a4 ]: l
中间加上
/ u( f2 U0 B# p) t+ s<th>{$lang.order_picking_status}</th>: f( Z! y: w4 U- }
3 t i" B. S. U1 y
第二个地方, q! ~( b) [/ o
在<td align="center" valign="top" nowrap="nowrap">{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}</td>( K, G0 @! G# D+ @1 r. w) i& }5 B
后面加上+ z( ~: Z( t! J! w K
<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>: ]/ W/ V- [- ^, B2 P! G
$ |5 v4 u, a' q5 k2 {! X5 i+ @* l' n! J. ]4 R" Q
! n$ F8 d5 |9 T& X; Y
4.admin\js\listtable.js中,listTable.edit的响应函数修改如下:: H9 [9 C, W5 c6 ~4 I
9 w R/ A( b/ U+ G( ]
- D: m! E9 N% {9 y( E8 j7 d# g/** * 创建一个可编辑区 */ 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 { } } 7 A0 R9 u( c/ j
}
7 E- A3 v" h* t9 q2 [8 p* b" ~0 l+ ~5.admin\order.php文件中增加下面的函数:
1 l4 ]# m$ h: u, P+ f' q+ o
8 q% y1 w" q6 s9 y9 g' H7 \/*------------------------------------------------------ */1 i, Z$ R* }; p6 i5 }9 F
//-- 订单拣货状态查询
& b: |2 M6 }' s! |" R6 H/*------------------------------------------------------ */2 S5 D x1 @2 T0 Z3 V
( j/ E+ ? [1 \: T9 C; N% D/ C
if ($_REQUEST['act'] == 'edit_order_picking_status')* H% E) n5 h$ ^. L( U1 x& Y* L
{
3 J( x& x& E5 {8 k /* 检查权限 */, O% ~ r' [' j, O7 j9 b
check_authz_json('users_manage');1 D' A: ~* W3 z3 ^; V c7 c6 x
1 U- K0 n8 z/ N. s
$id =empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
4 N$ B E c1 A8 Y I l: p* j $order_picking_status =empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
6 X& y3 h+ g) D) G* Q
, O5 J* c* _ N4 y' D0 Q1 e2 k $sql = "DELETE fromorder_picking_status WHERE order_id = '". $id ."' LIMIT 1";
! \$ a J: `0 r3 P: b2 ^% ] $db->query($sql);, } y; m5 q, T
9 @; D. s7 Z; r9 M $sql = "INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('". $id ."', '". $_SESSION['admin_name'] ."', '".$order_picking_status ."')";2 v( f3 q/ g+ r7 \8 z
$db->query($sql);! n# R: W' E( f* }6 r
- w2 Z: H4 R2 M" k+ `0 u
if ($order_picking_status> 2 || $order_picking_status < 0)
! k) i* I' p' ?6 {5 w, o! k {
' U4 Q+ G) l8 v" ~ make_json_error($GLOBALS['_LANG']['invalid_order_picking_status']);
1 Z9 Q$ V% m% K7 m- a: i8 U* r }
' g: }$ v5 F5 ^" s& G else
& n+ [6 v# U5 m. y# S5 m/ c" S {; I! p) P* D$ P f5 X6 F! K: {% r
make_json_result($order_picking_status);0 S* a$ r6 O: W# E
}
. ~# q: P' }, \}7 Q. t6 G/ ]3 e/ ^. ?
' c% _) }. ]7 v
6、admin\order.php文件中增加下面的函数将以下代码5 ?4 ~" E; t8 z- V' H5 z: [1 K
/* 查询 */+ Q5 u+ H9 b2 s5 ?
$sql = "SELECT o.*," ., [" b, [6 R! f7 q2 M
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " ., ?* O+ \( `2 m5 M
"(" . order_amount_field('o.') . ") AS total_fee, " .
% v7 K. H2 r' c* W: i "IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".$ h( m5 ~. s/ C# G! f% A
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
6 I- j/ P9 {, J# v/ N; z " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". $where . 3 x5 p. u& s3 ^' o
" ORDER BY $filter[sort_by] $filter[sort_order] ".
0 [; v+ o0 S. F2 W# O " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]"; # m. K: g; I! |" X( d7 @/ X, A( h
修改为:6 X/ r9 Y* H, b1 }4 x
//* 查询 */. e& P. a# K9 H! [% r" W) k
$sql = "SELECT o.*," .
a/ o! {& k K! V "o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .: g1 d! U' o+ [8 e' G' @0 t
"(" . order_amount_field('o.') . ") AS total_fee, " .( A% N; t3 M+ L5 b: l w( ~! s
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer , p.user_name, p.order_picking_status, r.order_reply_status ".! d3 O/ V( q/ z
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .% L* P0 y# \ @; D! v
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". & Y; h$ C; s# o& e. m4 b
" LEFT JOIN order_reply_status AS r ON r.order_id = o.order_id ".
j0 W0 b" Q9 V; h" LEFT JOIN order_picking_status AS p ON p.order_id = o.order_id ". $where .
! Z! l4 O2 Y$ X3 A! l; [9 c " ORDER BY $filter[sort_by] $filter[sort_order] ". 9 b) V4 e; L! I. A' {' h9 y) y
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";1 R5 k1 {# K2 n1 K8 m
0 _( X3 {& T0 B3 E3 J4 V- i4 j8 H2 L3 g4 }; g5 d! \
) G0 n; H9 L" }' d/ _/ f* _ |