197 lines
9.5 KiB
PHP
197 lines
9.5 KiB
PHP
<?
|
|
//-----------------------------------------------------后台->订单打印->明细单 for 秋水
|
|
//--条件定制
|
|
//array("xh"=>"序号","price"=>"价格","title"=>"款式名","series"=>get_cate_title_no("arr_select","series"),"season"=>get_cate_title_no("arr_select","season"),"bc"=>get_cate_title_no("arr_select","bc"),"category"=>get_cate_title_no("arr_select","category"),"category1"=>get_cate_title_no("arr_select","category1"));
|
|
$arr_zd=array("price"=>"价格","category"=>get_cate_title_no("arr_select","category"));
|
|
//是否显示颜色代码
|
|
$is_show_color="n";
|
|
//是否显示金额
|
|
$is_show_je="y";
|
|
//
|
|
//查询条件定制
|
|
$s_ka="n";
|
|
$s_key=$_key;
|
|
$con=" and ka<> 'y'";
|
|
//
|
|
if($s_dp){
|
|
$m_client=get_db_msg("select * from ".$table_pre."client where username='".$s_dp."'");
|
|
if($m_client["id"]>0){
|
|
if($m_client["face"]=="4")
|
|
$con.=" and uid='".$m_client["id"]."'";
|
|
else
|
|
$con.=" and (upath='".$m_client["path"]."-".$m_client["id"]."' or upath like '".$m_client["path"]."-".$m_client["id"]."-%')";
|
|
$_title=$m_client["title"]."订单明细(".date("Y年m月d日 H点i分").")";
|
|
if($m_client["is_checked"]!="y")
|
|
$confirm_str="<span style=\"color:#ff0000;font-weight:bold;\">该订单未确认</span>";
|
|
else
|
|
$confirm_str="";
|
|
}else{
|
|
alert_and_back("客户代码错误，请检查!");
|
|
}
|
|
}else{
|
|
$con.=" and uid=0";
|
|
}
|
|
$login_by_select=get_set("login_by_select");
|
|
if($login_by_select=="y"){
|
|
$search_content.="<select name=\"s_dp\"><option value=\"\">-请选择店铺-</option>".op_client_dp1($s_dp)."</select> ";
|
|
}else{
|
|
//取得店铺框
|
|
$js_function=get_client_autocompelete("","n")."\n";
|
|
$js_function.="$(function() {
|
|
$('#s_dp').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 400, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_dp').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="店铺: <input type=text name=\"s_dp\" id=\"s_dp\" style=\"width:80px\" onfocus=\"this.select()\" value=\"".$s_dp."\">";
|
|
}
|
|
//$search_content.="<select name=\"s_bc\" style=\"width:100px;\"><option value=\"\">-按波段过滤-</option>".op_select_cate1("bc",$s_bc)."</select> ";
|
|
//$search_content.="<select name=\"s_category\" style=\"width:100px;\"><option value=\"\">-按大类过滤-</option>".op_select_cate1("category",$s_category)."</select>";
|
|
$search_content.=" <input type=submit value=\"提交\" class=\"button_act\"> ";
|
|
$search_content.=$confirm_str;
|
|
|
|
if($m_client["id"]>0){
|
|
//$search_content.="<input type=\"button\" value=\"重新设置折扣\" onclick=\"o_window('?_m=".$_m."&_cid=".$_cid."&_a=set_zk&id=".$m_client["id"]."','set_zk',400,600)\">";
|
|
//-------------------处理尺码表头
|
|
//取得合并尺码
|
|
$arr_size_merged=get_size_merged();
|
|
$num_size_total=count($arr_size_merged);
|
|
//取得尺码合计sql
|
|
$sql_sum_num="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$sql_sum_num.="sum(num_".$arr_size_merged[$k].") 'num_".$arr_size_merged[$k]."',";
|
|
}
|
|
//取得尺码表头内容
|
|
$num_size_group=0;
|
|
$size_tr=array();
|
|
$r1=$db->query("select * from ".$table_pre."keyword where cate='size' order by ord");
|
|
while($m1=$db->fetch_array($r1)){
|
|
$size_tr[$num_size_group]="";
|
|
for($i=1;$i<=$num_size_total;$i++){
|
|
$tmp=get_db_msg("select title from ".$table_pre."size where iid='".$m1["id"]."' and no='".$i."'");
|
|
$t=$tmp["title"]?$tmp["title"]:" ";
|
|
$size_tr[$num_size_group].="<td bgcolor=\"#dddddd\" align=\"center\" width=\"30\">".$t."</td>";
|
|
}
|
|
$arr_size_merged[]=$m1["no"];
|
|
$num_size_group++;
|
|
}
|
|
//-------------------/处理尺码表头结束
|
|
//----------------------------------------------取得订单记录
|
|
//处理字段
|
|
$th_zd=$th_je=$th_color="";
|
|
foreach($arr_zd as $k1 => $v1){
|
|
$th_zd.="<td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\">".$v1."</td>";
|
|
}
|
|
if($is_show_je=="y"){
|
|
$th_je="<td rowspan=\"".$num_size_group."\" width=\"50\" bgcolor=\"#dddddd\" align=\"center\">金额（元）</td>";
|
|
if($zk_type=="y1" || $zk_type=="y2")
|
|
$th_je.="<td rowspan=\"".$num_size_group."\" width=\"30\" bgcolor=\"#dddddd\" align=\"center\">折扣</td><td rowspan=\"".$num_size_group."\" width=\"70\" bgcolor=\"#dddddd\" align=\"center\">折后金额</td>";
|
|
}
|
|
if($is_show_color=="y"){
|
|
$th_color="<td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\">颜色代码</td>";
|
|
}
|
|
//
|
|
$_tbody="<thead style=\"display:table-header-group;\"><tr><td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\">款号</td>".$th_zd."<td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\">圆牌号</td><td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\">颜色</td>".$th_color.$size_tr[0]."<td width=\"40\" rowspan=\"".$num_size_group."\" align=\"center\" bgcolor=\"#dddddd\">小计</td>".$th_je."</tr>";
|
|
for($i=1;$i<$num_size_group;$i++){
|
|
$_tbody.="<tr>".$size_tr[$i]."</tr>";
|
|
}
|
|
$_tbody.="</thead>";
|
|
$q="select * from ".$table_pre."order where _key='".$s_key."'".$con." group by no order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$total_num=$total_money=$total_money_zk=0;
|
|
$count=0;
|
|
$c=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$list=$count+1;
|
|
$bg=($c%2)?"#ffffff":"#f0f0f0";
|
|
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
|
|
//取得颜色
|
|
$tmp1=get_db_msg("select count(distinct color) 'num',sum(".get_size_sql("sum").") 'xj_num',sum((".get_size_sql("sum").")*price) 'xj_money' from ".$table_pre."order where _key='".$s_key."'".$con." and no='".$m["no"]."'");
|
|
$num1=$tmp1["num"];
|
|
$q2="select ".$sql_sum_num."color,category from ".$table_pre."order where _key='".$s_key."'".$con." and no='".$m["no"]."' group by color";
|
|
//echo $q2."<br>";
|
|
$r2=$db->query($q2);
|
|
$j=0;
|
|
while($m2=$db->fetch_array($r2)){
|
|
$m3=get_db_msg("select * from ".$table_pre."kh_xh where kh='".$m["no"]."' and color='".$m2["color"]."'");
|
|
$num=0;
|
|
$td_size1="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$num+=$m2["num_".$arr_size_merged[$k]];
|
|
$v11="hj_num_".$k;
|
|
$$v11+=$m2["num_".$arr_size_merged[$k]];
|
|
$td_size1.="<td bgcolor=\"".$bg."\" align=\"right\">".$m2["num_".$arr_size_merged[$k]]."</td>";
|
|
}
|
|
$money=$num*$m1["price"];
|
|
$total_num+=$num;
|
|
$total_money+=$money;
|
|
$tmp_zd_color=($is_show_color=="y")?"<td bgcolor=\"".$bg."\" align=\"center\">".$m2["color"]."</td>":"";
|
|
if($j==0){
|
|
$tmp_zd="";
|
|
foreach($arr_zd as $k1 => $v1){
|
|
$tmp_zd.="<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\">";
|
|
if($k1=="title" || $k1=="price")
|
|
$tmp_zd.=deel_td($m1[$k1]);
|
|
else if($k1=="color")
|
|
$tmp_zd.=deel_td($m2[$k1]);
|
|
else
|
|
$tmp_zd.=deel_td(get_cate_title_no($k1,$m1[$k1]));
|
|
$tmp_zd.="</td>";
|
|
}
|
|
if($is_show_je=="y"){
|
|
$tmp_zd_je="<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".$tmp1["xj_money"]."</td>";
|
|
if($zk_type=="y1" || $zk_type=="y2"){
|
|
$zk=($zk_type=="y1")?$m_client["zk"]:get_zk($m_client["id"],$m1["category"]);
|
|
$zk=($zk>0)?$zk:"100";
|
|
$money_zk=$tmp1["xj_money"]*$zk/100;
|
|
$total_money_zk+=$money_zk;
|
|
$tmp_zd_je.="<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".$zk."%</td><td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".keep_float($money_zk,2)."</td>";
|
|
}
|
|
}else{
|
|
$tmp_zd_je="";
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\" rowspan=\"".$num1."\">".$m1["no"]."</td>".$tmp_zd."<td bgcolor=\"".$bg."\">".$m3["xh"]."</td><td bgcolor=\"".$bg."\">".$m2["color"]."-".get_cate_title_no("color",$m2["color"])."</td>".$tmp_zd_color.$td_size1."<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".$tmp1["xj_num"]."</td>".$tmp_zd_je."</tr>";
|
|
}else{
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\">".$m3["xh"]."</td><td bgcolor=\"".$bg."\">".$m2["color"]."-".get_cate_title_no("color",$m2["color"])."</td>".$tmp_zd_color.$td_size1."</tr>";
|
|
}
|
|
$j++;
|
|
$count++;
|
|
}
|
|
$c++;
|
|
}
|
|
$colspan1=count($arr_zd)+3;
|
|
if($is_show_color=="y")
|
|
$colspan1++;
|
|
if($is_show_je=="y"){
|
|
$tmp_zd_je="<td bgcolor=\"#f0f0f0\" align=\"right\">".$total_money."</td>";
|
|
if($zk_type=="y1" || $zk_type=="y2"){
|
|
$tmp_zd_je.="<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\"> </td><td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".keep_float($total_money_zk,2)."</td>";
|
|
}
|
|
}else{
|
|
$tmp_zd_je="";
|
|
}
|
|
$td_size1="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$v1="hj_num_".$k;
|
|
$td_size1.="<td bgcolor=\"".$bg."\">".deel_td($$v1)."</td>";
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\"><td colspan=\"".($colspan1)."\" align=\"right\" bgcolor=\"#f0f0f0\">合计</td>".$td_size1."<td bgcolor=\"#f0f0f0\" align=\"right\">".$total_num."</td>".$tmp_zd_je."</tr>";
|
|
$bottom_button="<input type=\"button\" name=\"s1\" value=\"打 印\" onclick=\"start_print()\">";
|
|
}
|
|
?>
|