'0' $strsqlwhereid ) and (shukkaqty>0 or memo<>'') and operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."'"; //表示順 商品順 ロケーションの最小 shozokuid=0は個人客 $strorder = " ORDER BY shozokuid,customerid,shohincd"; $strorder2 = " ORDER BY shozokuid,customerid,pagenumber"; //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //都道府県 $kendata = dbselect("kenname,kenid","`ken`",-1,-1,-1); //所属コード if($_POST[tenpo]<>"") { $strwhere .= " and shozokuid='".$_POST[tenpo]."' "; } //本部データ $honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='".$userdata["hcompanyid"]."'",-1,-1); //出荷データにページ番号挿入 納品先単位の出荷データ数 $strsql ="SELECT shukkaid,shozokuid FROM `".$company."shukka` AS shu ".$strwhere." ".$strorder; $result=@mysql_query($strsql,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); $line = 1;$page=1;//処理行数/ページ while ($data = mysql_fetch_array($result)) { if($data[shozokuid].$data[customerid] <> $prevshozokuid){ //所属IDが変わったら改ページ $page = 1; $line=1; } elseif($line > ($pagekaigyo - 1)) { //行数が改ページに達していたら $page++; $line=1; } else { $line++; } $prevshozokuid = $data[shozokuid].$data[customerid]; $strsql2 ="UPDATE `".$company."shukka` SET pagenumber=".$page." WHERE shukkaid='".$data[shukkaid]."'"; Testecho ("LINE ".__LINE__." ".$y." ".$strsql2); //debug $result2=@mysql_query($strsql2,$my_con); mysql_sql_log($strsql2,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } if ($userdata["kengen"] == 60) { $strwhere .= " and deliveryid='".$userdata["companyid"]."'"; }/* 納品先単位 { //出荷データ、商品情報 $data1 店舗詳細データdata2 取引明細{data3 　出荷データ商品単位 商品 } } */ //納品先、ページ単位の出荷データ $strsql ="SELECT shu.operatedate,shu.shukkadate,shu.shozokuid,shu.pagenumber,`tenpoid`, `shozokuname`, `postcode`, `address1`, `address2`, `address3`, `tel`, `fax`, shu.route, shu.deliveryid ,shu.customerid,shu.name,shu.ordermainid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ".$strwhere." GROUP BY shozokuid,customerid,pagenumber ".$strorder2; Testecho ($y." $errcode ".$strsql); ?> 納品・受領書<?php //echo $systemname; ?> <?php //echo "作業日".date("Y/m/d",strtotime ("".$_POST[chgday]." day")); ?> - <?php //echo $_POST[picktimes]."回目"; ?> #\n"; for ($i=0;$i<$rows;$i++) { echo "\n"; } ?> ".$data[$i]."\n"; } ?>
------------------------------------------

1) { //改ページの信号プリント echo "
  
\n"; echo "
  
"; $line=1; } ?>
出荷日:　
0 or memo<>"") and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' GROUP BY shohincd "; if($data["shozokuid"] <> "0") { $strsqladd = " shozokuid='".$data["shozokuid"]."' "; } else { $strsqladd = " customerid='".$data["customerid"]."' "; } $strsql2 = "SELECT shohincd,supplyerid,SUM(shukkaqty) AS shukkaqty,price_piece,SUM(price_total) AS price_total,pagenumber,orderid,memo,deliverdate,loccode FROM `".$company."shukka` WHERE (shukkaqty>0 or memo<>'') and $strsqladd and pagenumber='".$data["pagenumber"]."' and operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) GROUP BY shohincd "; $strsql2 = "SELECT shu.*,sho.shohinmei, sho.code,ryutu_type, kikaku,nisugata,price_sell FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) ORDER BY sho.code,shu.loccode, shu.shohincd"; $totalamount = 0;$totalqty = 0; $result2=@mysql_query($strsql2,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql2); //debug mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__); while ($data2 = mysql_fetch_array($result2)) { $strhtml .= "\n"; $strhtml .= " \n"; // $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $totalqty += $data2["shukkaqty"]; $strhtml .= " \n"; $strhtml .= "\n"; $line++; } $page++; $strhtml .= "\n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= "\n"; echo $strhtml; ?>
No. メーカー 商品コード 商品名 規格 数量 温度
$line ".$data["shozokuid"]." ".GetListData($makerdata,$data2["supplyerid"],0)." ".$data2["shohincd"]." ".$data2["shohinmei"]." ".$data2["memo"]." ".$data2["memo2"]." ".$data2["kikaku"]."".number_format($data2["shukkaqty"],0)." ".GetList($codedata,$data2["code"],0)."
合計".number_format($totalqty)." ".$data2["memo"]." 
  \n"; echo "
  
"; ?>
出荷日:　
No. メーカー 商品コード 商品名 規格 数量 温度
対象データがありません。 "); #debug ?>