286 lines
11 KiB
PHP
286 lines
11 KiB
PHP
<?
|
||
//-----------------------------------------------------后台->订单打印->明细单--手动分页打印(款号不合并)
|
||
//定义单页行数，包含表头
|
||
$p_size=38;
|
||
//--条件定制
|
||
//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($bx_sizegroup_title){
|
||
$tmp=get_db_msg("select id from ".$table_pre."keyword where cate='size' and title='".$bx_sizegroup_title."' limit 0,1");
|
||
$bx_sizegroup_id=$tmp["id"];
|
||
}else{
|
||
$bx_sizegroup_id=0;
|
||
}
|
||
$con_u="";
|
||
if($s_username){
|
||
$s_username=str_replace("，",",",$s_username);
|
||
//去掉最后一个逗号
|
||
if(substr($s_username,strlen($s_username)-1,1)==",")
|
||
$s_username1=substr($s_username,0,-1);
|
||
else
|
||
$s_username1=$s_username;
|
||
$arr_username=explode(",",$s_username1);
|
||
//去掉重复值
|
||
$arr_username=array_unique($arr_username);
|
||
$confirm_str=$p_title=$error="";
|
||
for($i=0;$i<count($arr_username);$i++){
|
||
//检查是否存在
|
||
$m_client=get_db_msg("select * from ".$table_pre."client where username='".$arr_username[$i]."'");
|
||
//
|
||
if($m_client["id"]){
|
||
if($m_client["face"]=="4"){
|
||
$con_u.=" (uid='".$m_client["id"]."') or ";
|
||
if($m_client["is_checked"]!="y"){
|
||
$error_confirm.=$arr_username[$i].",";
|
||
$confirm_str.="<span style=\"color:#0000ff;\">".$arr_username[$i]."(未确认)</span>,";
|
||
}else{
|
||
$confirm_str.="<span style=\"color:#ff0000;\">".$arr_username[$i]."(已确认)</span>,";
|
||
}
|
||
}else{
|
||
$con_u.=" (upath='".$m_client["path"]."-".$m_client["id"]."' or upath like '".$m_client["path"]."-".$m_client["id"]."-%') or ";
|
||
}
|
||
$p_title.=$m_client["title"]."(".$m_client["username"]."),";
|
||
}else{
|
||
$error.=$arr_username[$i].",";
|
||
}
|
||
}
|
||
}
|
||
if($con_u)
|
||
$con.=" and (".substr($con_u,0,-3).") ";
|
||
if($confirm_str)
|
||
$confirm_str=substr($confirm_str,0,-1);
|
||
//取得店铺框
|
||
$js_function=get_client_autocompelete("","n")."\n";
|
||
$js_function.="$(function() {
|
||
$('#s_username').autocomplete(clients, {
|
||
max: 100, //列表里的条目数
|
||
minChars: 0, //自动完成激活之前填入的最小字符
|
||
width: 300, //提示的宽度，溢出隐藏
|
||
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
||
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
||
autoFill: false, //自动填充
|
||
multiple:true,
|
||
multipleSeparator:',',
|
||
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_username').value=row.u;
|
||
});
|
||
});";
|
||
$js_function.="
|
||
function export1(){
|
||
var u=document.getElementById('s_username').value;
|
||
if(u){
|
||
url='".$_SERVER[PHP_SELF]."?_m=".$_m."&_cid=".$_cid."&_a=export&s_username='+u;
|
||
location.href=url;
|
||
}else{
|
||
alert('请先选择店铺!');
|
||
}
|
||
}
|
||
";
|
||
$check_md=get_db_msg("select count(*) 'num' from ".$table_pre."kh_md");
|
||
//if($check_md["num"]>0)
|
||
//$search_content.="<select name=\"s_md\"><option value=\"\">包含买断款</option>".get_main_op(array("n"=>"非买断款","y"=>"仅买断款"),$s_md)."</select> ";
|
||
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:300px\" value=\"".$s_username."\">";
|
||
$search_content.=" <input type=\"hidden\" name=\"sub\" value=\"yes\"><input type=submit value=\"提 交\" class=\"button_act\"> <input type=button value=\"导出明细\" class=\"button_act\" onclick=\"export1()\"> ";
|
||
if($confirm_str)
|
||
$search_content.="<div style=\"width:100%;padding:4px;\" align=\"center\">".$confirm_str."</div>";
|
||
if($sub=="yes"){
|
||
$_title=substr($p_title,0,-1)." 明细单 ".date("Y年m月d日 H点i分");
|
||
//$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(trim($zk_type) || $check_md["num"]>0)
|
||
$th_je.="<td rowspan=\"".$num_size_group."\" width=\"70\" bgcolor=\"#dddddd\" align=\"center\">结算金额</td>";
|
||
}
|
||
if($s_md=="y"){
|
||
//-------------------仅买断款
|
||
|
||
}else{
|
||
//包含买断款，非买断款
|
||
$_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>";
|
||
if($bx_sizegroup_id>0)
|
||
$_tbody.="<td rowspan=\"".$num_size_group."\" bgcolor=\"#dddddd\" align=\"center\" width=\"30\">杯型</td>";
|
||
$_tbody.=$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>";
|
||
if($bx_sizegroup_id>0){
|
||
$colspan1=count($arr_zd)+3;
|
||
$colspan_all=count($arr_zd)+3;
|
||
}else{
|
||
$colspan1=count($arr_zd)+2;
|
||
$colspan_all=count($arr_zd)+2;
|
||
}
|
||
$q="select iid,no from ".$table_pre."order where _key='".$s_key."'".$con." group by no order by bc,no";
|
||
//echo $q."<br>";
|
||
$r=$db->query($q);
|
||
$total_num=$total_money=$total_money_zk=0;
|
||
$count=0;
|
||
$arr_kh=$arr_kh_color=array();
|
||
while($m=$db->fetch_array($r)){
|
||
$bg=($count%2)?"#ffffff":"#f0f0f0";
|
||
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
|
||
$price_zk=get_price_zk($m1["id"],$m_client["id"]);
|
||
//取得颜色，杯型
|
||
$q2="select * from ".$table_pre."order where _key='".$s_key."'".$con." and no='".$m["no"]."' order by color,bx";
|
||
//echo $q2."<br>";
|
||
$r2=$db->query($q2);
|
||
//
|
||
$j=0;
|
||
$je1=$num1=0;
|
||
while($m2=$db->fetch_array($r2)){
|
||
$td_size1="";
|
||
$num_color_hj=0;
|
||
$xj_num=0;
|
||
for($k=0;$k<$num_size_total;$k++){
|
||
$ck_md=check_md($m1["no"],$m2["color"],$m2["bx"],$arr_size_merged[$k]);
|
||
if($s_md=="n"){
|
||
if($ck_md!="n"){
|
||
$tmp_num=0;
|
||
}else{
|
||
$tmp_num=$m2["num_".$arr_size_merged[$k]];
|
||
}
|
||
}else{
|
||
$tmp_num=$m2["num_".$arr_size_merged[$k]];
|
||
}
|
||
if($ck_md!="n"){
|
||
$price_zk1=$ck_md>0?$ck_md:$price_zk;
|
||
$sty1="#999900";
|
||
}else{
|
||
$sty1=$bg;
|
||
$price_zk1=$price_zk;
|
||
}
|
||
if($s_md=="n")
|
||
$sty1=$bg;
|
||
$je1+=$tmp_num*$price_zk1;
|
||
$num1+=$tmp_num;
|
||
$num_color_hj+=$tmp_num;
|
||
//计算尺码合计
|
||
$v11="hj_num_".$k;
|
||
$$v11+=$tmp_num;
|
||
$xj_num+=$tmp_num;
|
||
//
|
||
$td_size1.="<td bgcolor=\"".$sty1."\" align=\"right\">".deel_td(deel_0($tmp_num))."</td>";
|
||
}
|
||
if($num_color_hj>0){
|
||
$arr_kh_color[$count][$j]="<td bgcolor=\"".$bg."\">".$m2["color"]."-".get_cate_title_no("color",$m2["color"])."</td>";
|
||
if($bx_sizegroup_id>0)
|
||
$arr_kh_color[$count][$j].="<td bgcolor=\"".$bg."\" align=\"center\">".deel_td($m2["bx"])."</td>";
|
||
$arr_kh_color[$count][$j].=$td_size1;
|
||
//小计
|
||
$arr_kh_color[$count][$j].="<td bgcolor=\"".$bg."\" align=\"center\">".$xj_num."</td>";
|
||
if($is_show_je=="y"){
|
||
//吊牌金额小计
|
||
$arr_kh_color[$count][$j].="<td bgcolor=\"".$bg."\" align=\"center\">".$xj_num*$m1["price"]."</td>";
|
||
//结算金额小计
|
||
if(trim($zk_type) || $check_md["num"]>0)
|
||
$arr_kh_color[$count][$j].="<td bgcolor=\"".$bg."\" align=\"center\">".$xj_num*$price_zk1."</td>";
|
||
}
|
||
$j++;
|
||
}
|
||
}
|
||
$total_num+=$num1;
|
||
$total_money+=$num1*$m1["price"];
|
||
$total_money_zk+=$je1;
|
||
//
|
||
if($num1>0){
|
||
$arr_kh[$count]["id"]=$m1["id"];
|
||
$arr_kh[$count]["no"]=$m1["no"];
|
||
$xh=get_kh_xh($m1);
|
||
$xh=$xh>0?$xh."#":"";
|
||
$arr_kh[$count]["xh"]=$xh;
|
||
$arr_kh[$count]["title"]=$m1["title"];
|
||
$arr_kh[$count]["series"]=get_cate_title_no("series",$m1["series"]);
|
||
$arr_kh[$count]["season"]=get_cate_title_no("season",$m1["season"]);
|
||
$arr_kh[$count]["bc"]=get_cate_title_no("bc",$m1["bc"]);
|
||
$arr_kh[$count]["category"]=get_cate_title_no("category",$m1["category"]);
|
||
$arr_kh[$count]["category1"]=get_cate_title_no("category1",$m1["category1"]);
|
||
$arr_kh[$count]["num"]=$num1;
|
||
$arr_kh[$count]["price"]=$m1["price"];
|
||
$arr_kh[$count]["je"]=$je1;
|
||
$count++;
|
||
}
|
||
}
|
||
//组合输出内容
|
||
$count=0;
|
||
for($i=0;$i<count($arr_kh);$i++){
|
||
$bg=($i%2)?"#ffffff":"#f0f0f0";
|
||
$num1=count($arr_kh_color[$i]);
|
||
for($j=0;$j<$num1;$j++){
|
||
$tmp_zd="";
|
||
foreach($arr_zd as $k1 => $v1){
|
||
$tmp_zd.="<td bgcolor=\"".$bg."\">".deel_td($arr_kh[$i][$k1])."</td>";
|
||
}
|
||
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\">".$arr_kh[$i]["no"]."</td>".$tmp_zd.$arr_kh_color[$i][$j];
|
||
$_tcontent[$count].="</tr>";
|
||
$count++;
|
||
}
|
||
}
|
||
if($is_show_je=="y"){
|
||
$tmp_zd_je="<td bgcolor=\"#f0f0f0\" align=\"right\">".$total_money."</td>";
|
||
if(trim($zk_type) || $check_md["num"]>0){
|
||
$tmp_zd_je.="<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."\" align=\"right\">".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()\">";
|
||
$_tmpl="report_multi";
|
||
}
|
||
?>
|