<?php  //6322出荷データBW用（セラピストデータ出力）
include "func.cgi";
myopen();

//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//センターIDのセット
if($_POST[center] <> "") {
	$centerid = $_POST[center];
} else {
	$centerid = $centerdata[0][1];
}
$strsqlcenter = " WHERE om.centerid='$centerid'";

//作業日のセット
if($_POST[chgday] == "") {
	$chgday = "CURDATE()";
} else {
	$chgday = "DATE_ADD(CURDATE(),INTERVAL $_POST[chgday] DAY)";
}
$strsqlwhere .= " and om.operatedate = ".$chgday;

//対象範囲
$errcount = 0;  //エラーカウント
$okcount = 0;  //エラーカウント
$errmsg = "";  //エラーメッセージ

//注文情報＋商品マスタ+スタッフ
//SELECT * FROM (SELECT FROM 商品マスタ、サプライヤ on makeracode=companyid) AS mas 
$strsql = "SELECT om.shozokuid,om.operatedate,sm.shohincd,sm.shohinmei,sm.kikaku, sm.makercode ,os.orderqty,os.staffid,sf.staff_name,sf.staff_name_kana,sf.sex,sm.makercode FROM  `".$company."shohinmaster` AS sm INNER JOIN `".$company."ordersheet` AS os USING(shohincd),`".$company."ordermain` AS om,`".$company."staff` AS sf ".$strsqlcenter.$strsqlwhere." and om.ordermainid = os.ordermainid and os.staffid = sf.staffid and os.shohincd = sm.shohincd ORDER BY sm.shohincd,os.staffid";

//ダウンロード
	$strdate = Sjis("出荷データ".date("Ymd-Gi").".csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	echo Sjis("No,\"出荷日\",\"サプライヤー\",\"店舗コード\",\"店舗名\",\"商品コード\",\"商品名\",\"規格\",\"発注数\",\"セラピスト\",\"氏名\",\"かな\",\"性別\"")."\n";
	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;
//echo "\"".$strsql."\"";
	while ($data = mysql_fetch_array($result)) {
		echo $i.",";
		echo Sprint($data["operatedate"]);
		echo Sprint(GetList($makerdata,$data[makercode]));
		echo Sprint($data["shozokuid"]);
		echo Sprint(GetList($tenpodata,$data[shozokuid]));
		echo Sprint("".$data["shohincd"]);
		echo Sprint($data["shohinmei"]);
		echo Sprint($data["kikaku"]);
		echo Sprint($data["orderqty"]);
		echo Sprint($data["staffid"]);
		echo Sprint($data["staff_name"]);
		echo Sprint($data["staff_name_kana"]);

		if($data["sex"] == 0) {
			echo Sprint("男性");
		} else {
			echo Sprint("女性");
		}
		echo "\n";
		$i++;
	}
	myclose();
	exit;

Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}

?>