科恒数字网-持续研发、集成、交付、运营方案资源库
标题: 给ecshop订单流程增加拣货状态,最新版本,支持ECSHOP3.6系统 [打印本页]
作者: admin 时间: 2020-6-12 09:15
标题: 给ecshop订单流程增加拣货状态,最新版本,支持ECSHOP3.6系统
针对ecshop订单中的物品,需要支持拣货的状态,比如未拣货、拣货中、拣货完成,以及显示拣货人姓名。: U8 s2 \6 } a: c) y
" X! `5 {& o7 k- L! A. o' Z ~1.SQL操作:
4 w- N( \0 x, d1 }" D0 ^% f! ^2 i5 G& `: ]& Q2 X
2.在文件languages\zh_cn\admin\order.php中增加:
0 Z) h& b5 o/ |6 v: f3 l
% F" W' J. P8 S! ]: E1 O/* 拣货 */
6 h) ?+ T' @* E- ^) E/ g$_LANG['order_picking_status'] = '拣货状态';8 {% c# @( |6 O8 T2 i N5 s' W$ D
$_LANG['order_picking_status_none'] = '未拣货';+ j7 A/ f0 k! L3 r; j3 m% p
$_LANG['order_picking_status_processing'] = '拣货中';- l. k$ w; {. i) a5 l$ ^# x& M
$_LANG['order_picking_status_finish'] = '拣货完成';
' n( z$ c+ Z% o- i$_LANG['invalid_order_picking_status'] = '拣货状态无效。0:未拣货;1:拣货中;2:拣货完成';& [8 M4 Q/ d( c1 x$ M- B
1 g9 J0 G$ y4 _8 Q v o S& w
, Z7 H7 a) i3 A2 g$ E9 d; j
3.文件admin\templates\order_list.htm中在一下两行之间:: c. I2 h0 o/ y% F3 z9 N( d4 X
第一个地方9 E( m' Z5 y8 g' l8 K1 B
<th>{$lang.all_status}</th>+ u: q" X9 v' q: ^4 j9 \- I+ l- N
<th>{$lang.handler}</th>
- |8 E% ?( M# Z) X4 j: e) r中间加上
4 N( P* B7 v2 j0 d' t! f- X<th>{$lang.order_picking_status}</th>
( I& b1 [( V# X( j
7 T5 n: X c, y第二个地方) o7 u4 L. [% R" ~' i- V1 j
在<td align="center" valign="top" nowrap="nowrap">{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}</td>
. v: U3 b& O6 R- K1 F& c后面加上
2 g" q" f u- @: l7 S9 Z<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>9 ?9 x1 p& b V+ D6 A3 B8 r
, {1 `! d$ t2 M6 H& v9 [' X" p+ N. K) a* b( F8 ?9 h/ P* b/ a
2 {4 W% K& G) n8 Q4.admin\js\listtable.js中,listTable.edit的响应函数修改如下:1 v0 ~& U. v* W6 x6 _
2 _' `/ s& y$ r8 _' b
; g* ?7 ]% P- h& c3 z( I) V
/**
* 创建一个可编辑区
*/
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
{
}
}
/ u" |! T) X' @! R0 W5 A}
) o' n B: n2 }' v5.admin\order.php文件中增加下面的函数:
3 Q! n: Q2 N/ D7 ]
. y/ k4 W5 D( l1 C/*------------------------------------------------------ */+ f1 J, F" l+ c2 v- n \
//-- 订单拣货状态查询
5 w+ b& f. ~ h/ [$ J/*------------------------------------------------------ */- @" Z( j/ R7 t+ o/ u$ w: I
# e) C5 a9 z8 g9 x6 cif ($_REQUEST['act'] == 'edit_order_picking_status')
W8 w* j4 W0 @7 H" u8 Z{9 g: A Y' B5 I5 g
/* 检查权限 */4 R- ^" m8 H0 X" E: q
check_authz_json('users_manage');/ H9 L# D4 I6 Y( q7 F5 \
; W8 Y- ]) j: C% [4 S $id =empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);7 R( Y* C" A {
$order_picking_status =empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
; O2 x- m4 E4 z: Q' ^# ~8 j8 j' h9 h0 s 2 `# j" r$ F+ f9 S% e
$sql = "DELETE fromorder_picking_status WHERE order_id = '". $id ."' LIMIT 1";
" q! X7 y2 I) h( D+ L2 Z, ? $db->query($sql);
& T- k, U0 g. M q3 ~. T/ v
2 x# H \* c3 J0 r' l' O/ ?9 O $sql = "INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('". $id ."', '". $_SESSION['admin_name'] ."', '".$order_picking_status ."')";% |7 k/ z4 K0 u
$db->query($sql);2 U2 v# i0 ~) H" m5 R
/ h# O6 p3 V, c$ c3 c% f' t4 A
if ($order_picking_status> 2 || $order_picking_status < 0) i& d# {8 y) ~! o: j( g: b6 i$ I
{2 e7 K& J; R7 [+ W9 p1 v
make_json_error($GLOBALS['_LANG']['invalid_order_picking_status']);1 z e" H) I' [% _" U% y- {
}% X1 ~7 o. K2 T+ l. h& i( P
else
- r' u9 k1 b/ I4 @ {
, I: Z: N2 U# M* M6 j5 A; c t make_json_result($order_picking_status);
; [. c5 e9 J1 L* \3 D+ z1 i }* w" u" e. _5 \% t! T; Y
}: Z; h, x( p7 j8 l' d# ]
; K' V! n% N+ x' i$ D' ~6、admin\order.php文件中增加下面的函数将以下代码6 W; f: W8 S ^* [1 \0 Y
/* 查询 */
0 U, f, \% s5 B2 E0 {$sql = "SELECT o.*," . h: V; f& N. n' r* j
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .
; D8 Z/ z* i+ R0 t5 @9 X "(" . order_amount_field('o.') . ") AS total_fee, " .3 B6 `+ n9 y1 w. Z
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".
& c$ Q7 c9 {# S4 @( G! ~ " FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
' `( t4 `: d. ?6 X6 b3 t " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". $where .
J: R4 Y5 v: k' S" M3 J L6 N3 z2 J " ORDER BY $filter[sort_by] $filter[sort_order] ".
" _# I9 U+ Q7 m6 B4 }/ g3 I9 j- Y " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
; q h/ A! E0 B% h: f修改为:
, Y% I5 L5 J5 y2 k4 {# Y //* 查询 */0 Y8 u. ]$ V# Q( p( h; A2 X
$sql = "SELECT o.*," .- J. K2 D: F) @0 ~) [
"o.pay_status, o.consignee, o.firstname, o.lastname, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .: Y9 j5 K3 k" b, P6 z& q
"(" . order_amount_field('o.') . ") AS total_fee, " .
8 s0 R3 D: E- y; C "IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer , p.user_name, p.order_picking_status, r.order_reply_status ".
3 ^' {3 R1 ^9 N) ?* H4 I " FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
3 U3 @% W ~- L6 M " LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ".
9 U d1 `% z& r* K; p " LEFT JOIN order_reply_status AS r ON r.order_id = o.order_id ". 2 }' k2 l' h' h8 P) s
" LEFT JOIN order_picking_status AS p ON p.order_id = o.order_id ". $where .# w1 X- {$ B( V) `3 F5 B u
" ORDER BY $filter[sort_by] $filter[sort_order] ". + A# q3 j/ L- I; M6 W
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";* n2 N/ w# u! M' o1 ^& }
8 b) Q4 O$ S: i1 F
0 f6 t8 ~+ d0 P
C! m& R' N$ ]7 I( |* k0 l
| 欢迎光临 科恒数字网-持续研发、集成、交付、运营方案资源库 (https://www.khcic.com/) |
Powered by Discuz! X3.5 |