public function getorderinfo($querywhere, $start, $display)
{
$dbmsale = new DB_mssale();
if ($start < 0) {
$start = 0;
}
$start = $start + 0;
$display = $display + 0;
$query = "select 1 from web_order where 1=1 {$querywhere} ";
$dbmsale->query($query);
$msgallcount = $dbmsale->nf();
$wfstate = '未付款';
$wfstate = u2g($wfstate);
$yfstate = '已付款';
$yfstate = u2g($yfstate);
$qfstate = '其他';
$qfstate = u2g($qfstate);
$query = "select case \n\t when fd_order_state ='6' then '" . $wfstate . "'\n\t when fd_order_state ='7' then '" . $yfstate . "'\n\t else '" . $qfstate . "' END orderstate,fd_order_id as orderid,fd_order_no as orderno ,\n\t\t fd_order_date as ordertime ,fd_order_allmoney as ordermoney,fd_order_alldunshu as orderpronum,\n\t\t fd_order_type as orderpaytype,fd_order_shman as shman,fd_order_comnpany as shcmpyname,\n\t\t fd_order_receiveadderss as shaddress , '' as fhstorage,'' as fhwltype,\n\t\t fd_order_memo as ordermemo,'' as allpromoney,'' as fhwlmoney\n\t\t from web_order " . "where 1=1 {$querywhere} limit {$start} ,{$display}";
$dbmsale->query($query);
//echo $query;
$msgdiscount = $dbmsale->nf();
$arr_value = $dbmsale->getData('', 'msorder');
//$arr_orderinfo = $dbmsale->get_all($query);
foreach ($arr_value as $key => $value) {
foreach ($value as $k => $v) {
$orderid = $v['orderid'];
$query = "select fd_orderdetail_quantity as pronum,fd_orderdetail_productname as proname,\n\t\t\t\t\t fd_orderdetail_price as proprice \n\t\t\t\t\t ,(fd_orderdetail_price*fd_orderdetail_quantity) as promoney from web_orderdetail \n\t\t\t\t\t where fd_orderdetail_orderid ='{$orderid}'";
$dbmsale->query($query);
//echo $query;
if ($dbmsale->nf()) {
$arr_value[$key][$k]['msproinfo'] = $dbmsale->getFiledData('msgchild');
}
}
}
if (!$arr_value) {
$arr_message = array("result" => "failure", "message" => "很抱歉，没有找到相关的订单信息!");
} else {
$arr_message = array("result" => "success", "message" => "读取成功");
}
//echo var_dump($arr_value);
$arr_message = auto_charset($arr_message, 'utf-8', 'gbk');
$arr_msg['msgbody'] = $arr_value;
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$arr_msg['msgbody']['msgallcount'] = $msgallcount;
$arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $start;
return $arr_msg['msgbody'];
}
