{"id":255,"date":"2014-05-21T04:42:00","date_gmt":"2014-05-21T04:42:00","guid":{"rendered":"http:\/\/www.nywzjs.com\/?p=255"},"modified":"2014-05-21T04:42:00","modified_gmt":"2014-05-21T04:42:00","slug":"ecmall%e8%ae%a2%e5%8d%95%e7%ae%a1%e7%90%86%e7%94%9f%e6%88%90%e7%94%b5%e5%ad%90%e8%a1%a8%e6%a0%bc%ef%bc%88excels%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.nywzjs.com\/?p=255","title":{"rendered":"Ecmall\u8ba2\u5355\u7ba1\u7406\u751f\u6210\u7535\u5b50\u8868\u683c\uff08Excels\uff09"},"content":{"rendered":"

\u9700\u6c42\uff1aEcmall\u540e\u53f0\u7ba1\u7406\u4e2d\u7684\u8ba2\u5355\u7ba1\u7406\uff0c\u8f93\u51fa\u4e3a\u7535\u5b50\u8868\u683c\u5f62\u5f0f\u3002<\/p>\n

\u8981\u4fee\u6539\u7684\u6587\u4ef6\uff1a\\admin\\templates\\order.index.html \u3001 \\admin\\app\\order.app.php\u548c\\languages\\sc-gbk\\admin\\order.lang.php\u6587\u4ef6\u3002<\/p>\n

\u6253\u5f00\\admin\\templates\\order.index.htm\uff0c\u5728\u5927\u7ea611\u884c\uff0c<li><span>{$lang.manage}<\/span><\/li><\/span> \u7684\u4e0b\u9762\u52a0\u4e0a\uff1a<\/p>\n

<li><form method=\"get\">
\n<input type=\"hidden\" name=\"app\" value=\"order\" \/>
\n<input type=\"hidden\" name=\"act\" value=\"excels\" \/>
\n<input name=\"field\" type=\"hidden\" value=\"{$smarty.get.field}\" \/>
\n<input name=\"search_name\" type=\"hidden\" value=\"{$query.search_name|escape}\" \/>
\n<input name=\"status\" type=\"hidden\" value=\"{$query.status}\" \/>
\n<input name=\"add_time_from\" type=\"hidden\" value=\"{$query.add_time_from}\" \/>
\n<input name=\"add_time_to\" type=\"hidden\" value=\"{$query.add_time_to}\" \/>
\n<input name=\"order_amount_from\" type=\"hidden\" value=\"{$query.order_amount_from}\" \/>
\n<input name=\"order_amount_to\" type=\"hidden\" value=\"{$query.order_amount_to}\" \/>
\n<input name=\"payment_code\" type=\"hidden\" value=\"{$query.payment_code}\" \/>
\n<input type=\"submit\" class=\"formbtn1\" value=\"{$lang.scexcels}\" style=\"margin-left:10px;\" \/>
\n<\/form><\/li><\/p><\/blockquote>\n

\u6253\u5f00\\admin\\app\\order.app.php\u6587\u4ef6\uff0c\u5728\u6587\u4ef6\u7ed3\u5c3e\uff0c<\/p>\n

$this->display('order.view.html');
\n}<\/p><\/blockquote>\n

\u540e\u9762\u52a0\u4e0a\uff1a<\/p>\n

\/\/\u751f\u6210Excels
\nfunction excels()
\n{
\n$search_options = array(
\n'seller_name' => Lang::get('store_name'),
\n'buyer_name' => Lang::get('buyer_name'),
\n'payment_name' => Lang::get('payment_name'),
\n'order_sn' => Lang::get('order_sn'),
\n);
\n\/* \u9ed8\u8ba4\u641c\u7d22\u7684\u5b57\u6bb5\u662f\u5e97\u94fa\u540d *\/
\n$field = 'seller_name';
\narray_key_exists($_GET['field'], $search_options) && $field = $_GET['field'];
\n$conditions = $this->_get_query_conditions(array(array(
\n'field' => $field, \/\/\u6309\u7528\u6237\u540d,\u5e97\u94fa\u540d,\u652f\u4ed8\u65b9\u5f0f\u540d\u79f0\u8fdb\u884c\u641c\u7d22
\n'equal' => 'LIKE',
\n'name' => 'search_name',
\n),array(
\n'field' => 'status',
\n'equal' => '=',
\n'type' => 'numeric',
\n),array(
\n'field' => 'add_time',
\n'name' => 'add_time_from',
\n'equal' => '>=',
\n'handler'=> 'gmstr2time',
\n),array(
\n'field' => 'add_time',
\n'name' => 'add_time_to',
\n'equal' => '<=',
\n'handler' => 'gmstr2time_end',
\n),array(
\n'field' => 'order_amount',
\n'name' => 'order_amount_from',
\n'equal' => '>=',
\n'type' => 'numeric',
\n),array(
\n'field' => 'order_amount',
\n'name' => 'order_amount_to',
\n'equal' => '<=',
\n'type' => 'numeric',
\n),array(
\n'field' => 'payment_code',
\n),
\n));
\n$model_order =& m('order');
\n$page = $this->_get_page(100000); \/\/\u83b7\u53d6\u5206\u9875\u4fe1\u606f
\n\/\/\u66f4\u65b0\u6392\u5e8f
\nif (isset($_GET['sort']) && isset($_GET['order']))
\n{
\n$sort = strtolower(trim($_GET['sort']));
\n$order = strtolower(trim($_GET['order']));
\nif (!in_array($order,array('asc','desc')))
\n{
\n$sort = 'add_time';
\n$order = 'desc';
\n}
\n}
\nelse
\n{
\n$sort = 'add_time';
\n$order = 'desc';
\n}<\/p>\n

$orders = $model_order->find(array(
\n'conditions' => '1=1 ' . $conditions,
\n'limit' => $page['limit'], \/\/\u83b7\u53d6\u5f53\u524d\u9875\u7684\u6570\u636e
\n'order' => \"$sort $order\",
\n'count' => true \/\/\u5141\u8bb8\u7edf\u8ba1
\n)); \/\/\u627e\u51fa\u6240\u6709\u5546\u57ce\u7684\u5408\u4f5c\u4f19\u4f34<\/p>\n

$st_time=$_GET['add_time_from'].\" 00:00:00\";
\n$end_time=$_GET['add_time_to'].\" 24:00:00\";<\/p>\n

header(\"Content-type:application\/vnd.ms-excel\");
\nheader(\"Content-Disposition:filename=Order_list.xls\");
\necho \"<table width='100%' cellpadding='5' border='1'>\";
\necho \"<tr><th colspan='8'><font size='5'>\".$_GET['add_time_from'].\"\u81f3\".$_GET['add_time_to'].\"[\".$_GET['payment_code'].\"]\u4ea4\u6613\u6240\u6709\u6c47\u603b<\/font><\/th><\/tr>\";
\necho \"<tr><th width='50'>\u5e8f\u53f7<\/th><th width='190'>\u5e97\u94fa\u540d\u79f0<\/th><th width='110'>\u8ba2\u5355\u53f7<\/th><th width='130'>\u4e0b\u5355\u65f6\u95f4<\/th><th width='100'>\u4e70\u5bb6\u540d\u79f0<\/th><th width='80'>\u8ba2\u5355\u603b\u4ef7<\/th><th width='180'>\u652f\u4ed8\u65b9\u5f0f<\/th><th width='120'>\u8ba2\u5355\u72b6\u6001<\/th><\/tr>\";
\n$number=0;
\n$zyzfe=0;\/\/\u603b\u5e94\u652f\u4ed8\u989d
\n$order_isok=0;
\n\/\/var_dump($index);
\nforeach($orders as &$row)
\n{
\n$order_status=\"\";
\nswitch($row['status'])
\n{
\ncase 11:
\n$order_status=\"\u5f85\u4ed8\u6b3e\";
\nbreak;
\ncase 10:
\n$order_status=\"\u5df2\u63d0\u4ea4\";
\nbreak;
\ncase 20:
\n$order_status=\"\u5f85\u53d1\u8d27\";
\nbreak;
\ncase 30:
\n$order_status=\"\u5df2\u53d1\u8d27\";
\nbreak;
\ncase 40:
\n$order_status=\"\u5df2\u5b8c\u6210\";
\n$order_isok+=1;
\nbreak;
\ncase 0:
\n$order_status=\"\u5df2\u53d6\u6d88\";
\nbreak;
\ndefault:
\n$order_status=\"\u9000\u8d27\";
\nbreak;
\n}
\n$number+=1;
\necho \"<tr>\";
\necho \"<td align='center'>\".$number.\"<\/td>\";
\necho \"<td align='center'>\".$row['seller_name'].\"<\/td>\";
\necho \"<td align='center'>\".$row['order_sn'].\"<\/td>\";
\necho \"<td align='center'>\".date(\"Y-m-d H:i:s\",$row['add_time']).\"<\/td>\";
\necho \"<td align='center'>\".$row['buyer_name'].\"<\/td>\";
\necho \"<td align='center'>\".$row['order_amount'].\"<\/td>\";
\necho \"<td align='center'>\".$row['payment_name'].\"[\".$row['payment_code'].\"]<\/td>\";
\necho \"<td align='center'>\".$order_status.\"(\".$row['status'].\")<\/td>\";
\n$zyzfe+=$row['order_amount'];
\necho \"<\/tr>\";
\n}
\necho \"<tr><td colspan='4'>\u672c\u5217\u8868\u5171\u6709\u8ba2\u5355\u6570\uff1a\".$number.\"\u5355\uff0c\u5176\u4e2d\u5df2\u5b8c\u6210\u7684\u8ba2\u5355\u6570\u4e3a\uff1a\".$order_isok.\" \u5355\u3002<\/td><td colspan='2' align='right'>\u672c\u5217\u8868\u4ea4\u6613\u603b\u989d\uff1a<\/td><td aling='center'><strong style='color:red;'>\".sprintf(\"%.2f\",$zyzfe).\"<\/strong><\/td><td> <\/td><\/tr>\";
\necho \"<tr><td colspan='8'>\u6ce8\u610f\uff1a\u6b64\u5217\u8868\u4ec5\u505a\u4e3a\u5bf9\u5e10\u5217\u8868\u7528\uff1b\";
\necho \"<br \/>\u3000\u3000\u3000<strong>\u6b64\u8868\u4ec5\u53ef\u663e\u793a\u524d1\u4e07\u6761\u8bb0\u5f55\uff1b<\/strong>\";
\necho \"<br \/>\u3000\u3000\u3000<strong>\u6b64\u8868\u9ed8\u8ba4\u663e\u793a<font color='red'>\u6240\u6709\u72b6\u6001\u8ba2\u5355<\/font>\uff0c\u5982\u9700\u8981\u663e\u793a\u7279\u5b9a\u72b6\u6001\u8ba2\u5355\u5219\u9700\u8981\u63d0\u524d\u9009\u62e9\u201c\u8ba2\u5355\u72b6\u6001\u201d\u3002<\/strong>\";
\necho \"<\/td><\/tr>\";
\necho \"<tr><td colspan='8' align='right'>\u672c\u5217\u8868\u751f\u6210\u65f6\u95f4\uff1a\".date('Y-m-d H:i:s',time()).\"<\/td><\/tr>\";
\necho \"<\/table>\";<\/p>\n

}<\/p><\/blockquote>\n

\u6253\u5f00\\languages\\sc-gbk\\admin\\order.lang.php\u6587\u4ef6\uff0c\u5728\u7ed3\u5c3e\u5904\u52a0\u4e0a\u4e00\u53e5\uff1a<\/p>\n

'scexcels' => '\u5bfc\u51fa\u4e3aExcels',<\/p><\/blockquote>\n

\u8fd9\u91cc\u6ce8\u610f\uff0c\u4e0a\u4e00\u53e5\u7684\u7ed3\u5c3e\u8981\u52a0\u4e0a\u4e00\u4e2a\u9017\u53f7\uff08,<\/span><\/strong>\uff09\u3002<\/p>\n

\u81f3\u6b64\uff0c\u4fee\u6539\u5b8c\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u9700\u6c42\uff1aEcmall\u540e\u53f0\u7ba1\u7406\u4e2d\u7684\u8ba2\u5355\u7ba1\u7406\uff0c\u8f93\u51fa\u4e3a\u7535\u5b50\u8868\u683c\u5f62\u5f0f\u3002 \u8981\u4fee\u6539\u7684\u6587\u4ef6\uff1a\\admin\\templates\\ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[67,81],"_links":{"self":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/255"}],"collection":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=255"}],"version-history":[{"count":0,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}