订单打印->明细单 for 劲霸汇总到商品名称 //--条件定制 $s_group_by="category1"; //--条件定制 //查询条件定制 $con=" and ka<>'y'"; $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=$confirm_str1=$p_title=$error=""; for($i=0;$i".$arr_username[$i]."(未确认),"; $confirm_str1.=$arr_username[$i].","; }else{ $confirm_str.="".$arr_username[$i]."(已确认),"; } }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_u.="(".substr($con_u,0,-3).") and "; }else{ $con_u=$con_u_all; $p_title=$msg_login_user["title"]."(".$msg_login_user["username"]."),"; } // if($con_u) $con.=" and (".substr($con_u,0,-4).") "; //echo $con."
"; $str="var clients = [\n"; for($i=0;$i0) $str=substr($str,0,-2); $str.="];\n"; $js_function.=$str."\n$(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; }); }); "; $search_content.="打印客户:"; $search_content.=" "; if($sub=="yes"){ $sys_client_title=get_set("sys_client_title"); $dl=get_dl_title($m_client["path"]); $title_dl=$dl?$dl."-":""; $_title="
".$sys_client_title."
".$title_dl.substr($p_title,0,-1).$title_exp."汇总单 ".date("Y年m月d日 H点i分")."
"; //----------------------------------------------取得订单记录 if($s_md=="y"){ //-------------------仅买断款 }else{ //包含买断款，非买断款 //表头 $th_je=""; $_tbody="".get_cate_title_no("arr_select","sxz")."".get_cate_title_no("arr_select","category")."".get_cate_title_no("arr_select",$s_group_by)."订货生效删单"; $_tbody.="数量零售额数量零售额数量零售额"; for($i=1;$i<$num_size_group;$i++){ $_tbody.="".$size_tr[$i].""; } $_tbody.=""; //内容 $q="select sxz,category,".$s_group_by.",sum(num) 'num',sum(je) 'je' from ".$table_pre."order where id>0 ".str_replace("ka<>'y' and ","",$con)." group by ".$s_group_by." order by ".$s_group_by; //echo $q."
"; $r=$db->query($q); $total_dh_num=$total_dh_je=0; $total_sx_num=$total_sx_je=0; $total_ka_num=$total_ka_je=0; $count=0; while($m=$db->fetch_array($r)){ $bg=($count%2)?"#ffffff":"#f0f0f0"; $td_size1=""; //取得删除款数量 //echo "select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where id>0 ".str_replace("ka<>'y'","ka='y'",$con)." and ".$s_group_by."='".$m[$s_group_by]."'
"; $tmp=get_db_msg("select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where id>0 ".str_replace("ka<>'y'","ka='y'",$con)." and ".$s_group_by."='".$m[$s_group_by]."'"); $ka_num=$tmp["num"]; $ka_je=deel_num($tmp["je"]); // $dh_num=$m["num"]; $dh_je=deel_num($m["je"]); // $sx_num=$dh_num-$ka_num; $sx_je=$dh_je-$ka_je; $_tcontent[$count]="".get_cate_title_no("sxz",$m["sxz"])."".get_cate_title_no("category",$m["category"])."".get_cate_title_no($s_group_by,$m[$s_group_by])."".deel_td(deel_0($dh_num))."".deel_td(deel_0($dh_je))."".deel_td(deel_0($sx_num))."".deel_td(deel_0($sx_je))."".deel_td(deel_0($ka_num))."".deel_td(deel_0($ka_je)).""; $total_dh_num+=$dh_num; $total_dh_je+=$dh_je; $total_sx_num+=$sx_num; $total_sx_je+=$sx_je; $total_ka_num+=$ka_num; $total_ka_je+=$ka_je; $count++; // } $_tcontent[$count]="合计".$total_dh_num."".$total_dh_je."".$total_sx_num."".$total_sx_je."".$total_ka_num."".$total_ka_je.""; } $bottom_button=""; } ?>