function fahuostate_view($fields, $i)
{
$fieldvalue = $fields['value']['fahuostate'];
$fieldvalue = fahuostate_value($fieldvalue, $fields, $i);
$Text = "<TR><TD class=TableContent noWrap>发货:</TD><td class=TableContent noWrap>{$fieldvalue}</td></tr>";
return $Text;
}
$title = '订单明细';
}
if (!empty($_GET['supplyid'])) {
$supplyid = $_GET['supplyid'];
} else {
exit('缺少参数');
}
$sql = "SELECT a.ifpay,a.oddment,a.billid,c.supplyname,a.zhuti,d.`机会主题` AS jihui,a.totalmoney,a.huikuanjine,a.fahuojine,a.kaipiaojine,b.USER_NAME,a.user_flag,a.createtime,a.fahuostate,a.kaipiaostate FROM sellplanmain a left JOIN `user` b on a.user_id=b.USER_ID left JOIN customer c on a.supplyid=c.ROWID left JOIN crm_chance d on a.chanceid=d.`编号` where a.user_flag>0 and " . $where . " a.supplyid='" . $supplyid . "' AND a.createtime>='" . $start_time . "' AND a.createtime<='" . $end_time . "'";
//exit($sql);
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$i = 0;
foreach ($rs_a as $row) {
$rs_a[$i]['user_flag'] = sellonePriv_value($row['user_flag'], '', '');
$rs_a[$i]['ifpay'] = paystate_value($row['ifpay'], '', '');
$rs_a[$i]['fahuostate'] = fahuostate_value($row['fahuostate'], '', '');
$rs_a[$i]['kaipiaostate'] = kaipiaostate_value($row['kaipiaostate'], '', '');
$i++;
}
$head = array("supplyname" => "客户名称", "billid" => "单据ID", "zhuti" => "主题", "totalmoney" => "总金额", "oddment" => "去零金额", "huikuanjine" => "回款金额", "fahuojine" => "发货金额", "kaipiaojine" => "开票金额", "createtime" => "创建日期", "USER_NAME" => "创建人", "user_flag" => "订单状态", "ifpay" => "付款状态", "fahuostate" => "发货状态", "kaipiaostate" => "开票状态");
$headtype = array("supplyname" => "string", "billid" => "char", "zhuti" => "char", "totalmoney" => "float", "oddment" => "float", "huikuanjine" => "float", "fahuojine" => "float", "kaipiaojine" => "float", "createtime" => "char", "USER_NAME" => "char", "user_flag" => "char", "ifpay" => "char", "fahuostate" => "char", "kaipiaostate" => "char");
$title = "客户排行明细";
$sumcol = array("totalmoney" => "", "oddment" => "", "huikuanjine" => "", "fahuojine" => "", "kaipiaojine" => "");
if ($_GET['out_excel'] == 'true') {
export_XLS($head, $rs_a, $title, $sumcol);
exit;
}
?>
<html>
<head>
<?php
a.gaiyao,g.`name` as storeid,a.createtime,a.ifpay,a.kaipiaostate,a.fapiaoneirong,a.fahuotype,a.yunfeitype,a.oddment,a.integral,
a.sellplanno,b.supplyname as supplyid,a.totalmoney,c.linkmanname as linkman,a.mobile,a.address FROM sellplanmain a LEFT JOIN customer b on a.supplyid=b.ROWID LEFT JOIN linkman c on a.linkman=c.ROWID LEFT JOIN `user` d on a.user_id=d.USER_ID
LEFT JOIN crm_chance e on a.chanceid=e.`编号` LEFT JOIN `user` f on a.qianyueren=f.USER_ID LEFT JOIN stock g on a.storeid=g.ROWID WHERE a.billid=
' . $_GET['billid'];
$rs = $db->Execute($sql);
$order_info = $rs->GetArray();
$user_flag = $order_info[0]['user_flag'];
require_once './userdefine/paystate.php';
require_once './userdefine/kaipiaostate.php';
require_once './userdefine/sellonePriv.php';
require_once './userdefine/fahuostate.php';
require_once './userdefine/sellplanstate.php';
$order_info[0]['user_flag'] = sellplanstate_value($order_info[0]['user_flag'], '', '');
$order_info[0]['user_flag'] = htmlspecialchars_decode($order_info[0]['user_flag']);
$order_info[0]['user_flag'] = preg_replace("/<(.*?)>/", "", $order_info[0]['user_flag']);
$order_info[0]['fahuostate'] = fahuostate_value($order_info[0]['fahuostate'], '', '');
$order_info[0]['fahuostate'] = htmlspecialchars_decode($order_info[0]['fahuostate']);
$order_info[0]['fahuostate'] = preg_replace("/<(.*?)>/", "", $order_info[0]['fahuostate']);
$order_info[0]['ifpay'] = paystate_value($order_info[0]['ifpay'], '', '');
$order_info[0]['ifpay'] = htmlspecialchars_decode($order_info[0]['ifpay']);
$order_info[0]['ifpay'] = preg_replace("/<(.*?)>/", "", $order_info[0]['ifpay']);
$order_info[0]['kaipiaostate'] = kaipiaostate_value($order_info[0]['kaipiaostate'], '', '');
$order_info[0]['kaipiaostate'] = htmlspecialchars_decode($order_info[0]['kaipiaostate']);
$order_info[0]['kaipiaostate'] = preg_replace("/<(.*?)>/", "", $order_info[0]['kaipiaostate']);
@($ini_file = @parse_ini_file("../Framework/sellone_print_config.ini", true));
$sell_order_field_config = $ini_file['sell_order_print_field'];
$sell_order_detail_field_config = $ini_file['sell_order_detail_print_field'];
asort($sell_order_field_config);
asort($sell_order_detail_field_config);
//$order_print_paper_width = $ini_file['section']['order_print_paper_width'];
// 销售单打印字段配置
