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']; // 销售单打印字段配置