0 or memo<>'') and operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."'"; //表示順 商品順 ロケーションの最小 $strorder = " ORDER BY sho.deliveryid,sho.route,sho.address1,shu.shozokuid,sm.code,shu.loccode,shu.shohincd,shu.shomi"; //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //所属コード if($_POST[tenpo]<>"") { $strwhere .= " and shozokuid='".$_POST[tenpo]."' "; } //本部データ $honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='bodywork'",-1,-1); $honbudata2 = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='rebirth'",-1,-1); //配送会社変更データ $datadelivery = dbselect("memo1,shozokuid,deliveryid,deliverchangeid,memo2,memo3","`".$company."deliverchange`","operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY )",-1,-1); $intchange = sizeof($datadelivery); //出荷データにページ番号挿入 納品先単位の出荷データ数 $strsql ="UPDATE `".$company."shukka` as shu SET pagenumber = 1 and operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY )"; //リセット $result=@mysql_query($strsql,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); $strsql ="SELECT shukkaid,shu.shozokuid,shu.shohincd FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid),`".$company."shohinmaster` AS sm".$strwhere." AND sm.shohincd = shu.shohincd GROUP BY sho.deliveryid,sho.route,sho.address1,shu.shozokuid,sm.code,shu.loccode,shu.shohincd,shu.shomi".$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]<>$prevshozokuid){ //所属IDが変わったら改ページ $page = 1; $line=1; } elseif($line > ($pagekaigyo - 1)) { //行数が改ページに達していたら $page++; $line=1; } else { $line++; } $prevshozokuid = $data[shozokuid]; if ($page > 1) { $strsql2 ="UPDATE `".$company."shukka` as shu SET pagenumber=".$page." WHERE shozokuid = '".$data[shozokuid]."' and shohincd = '".$data[shohincd]."' and operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY )";//lot割れで複数あるはず 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,sho.brand in(50) as brandflg,shu.centerid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ".$strwhere." GROUP BY sho.deliveryid,sho.route,sho.address1,shozokuid,pagenumber"; 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; } if($data["brandflg"] == 1 ) { $honbudatadisplay = $honbudata2; } else { $honbudatadisplay = $honbudata; } $strDeliverMsg = ""; for ($j = 0; $j < $intchange; $j++) { if($datadelivery[$j][1] == $data["shozokuid"]) { $strDeliverMsg = $datadelivery[$j][0].$datadelivery[$j][4]; break; } } ?>
0 or memo<>'') and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' AND centerid ='".$data["centerid"]."' and operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) GROUP BY shohincd,orderid "; $strsql2 = "SELECT shu.*,sm.shohinmei,sm.shohinmei2, sm.code,ryutu_type, kikaku,nisugata,price_sell,category FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sm USING (shohincd) ORDER BY sm.code,shu.loccode,shu.shohincd"; $totalamount = 0;$totalqty = 0;$strhtml = ""; $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"; $totalqty += $data2["shukkaqty"]; //制服=category=8は発注者氏名を出す if($data2["category"] == 8) { $strsql3 = "SELECT sf.staffid,sf.staff_name FROM `".$company."staff` AS sf INNER JOIN `".$company."ordersheet` AS os USING(staffid) WHERE os.orderid ='".$data2["orderid"]."'"; $result3=@mysql_query($strsql3,$my_con); //Testecho ("LINE ".__LINE__." ".$y." ".$strsql3); //debug $data3 = mysql_fetch_array($result3); mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__); $strhtml .= " \n"; } else { $strhtml .= " \n"; } $strhtml .= "\n"; $line++; } $page++; $strhtml .= "\n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= " \n"; $strhtml .= "\n"; echo $strhtml; ?>
No. 商品コード 商品名 規格 数量 備考
$line ".substr($data2["shohincd"],0,6)." ".substr($data2["shohincd"],6,10)." .$data2["shohinmei"]." ".$data2["shohinmei2"]." ".$data2["shohinmei"]."  ".$data2["kikaku"]."".number_format($data2["shukkaqty"],0).$data2["nisugata"]."  ".$data3["staffid"]." ".$data3["staff_name"].$data2["memo"]." ".$data2["memo"]."
合計".number_format($totalqty)." "." 

 

対象データがありません。 "); #debug ?>