"" ) {
$shop = $_POST[shop];
$strsqlshop = "search like '%" . mb_convert_encoding($shop, "UTF-8", "UTF-8") . "%'" ;
$tenpodata2 = dbselect( "shozokuname, shozokuid", "`" . $company . "shozokumaster`", $strsqlshop, "shozokuid", -1);
if ( sizeof($tenpodata2) == 1 ) {
$shozokuid = $tenpodata2[0][1];
$tenpoinputnew = $tenpodata2[0][1];
} else {
$shozokuid = "";
$tenpodata = $tenpodata2;
}
} else {
$strsqlshop = -1;
}
// 1ページ数
if( $_POST[pageset] == "" ) {
$pageset = 1000;
} else {
$pageset = $_POST[pageset];
}
// レコードの指定
if ( $_POST[pagenum] == "") {
$page = 1;
} else {
$page = (int)$_POST[pagenum];
}
//センターコード
if ($userdata["kengen"] == 30) {
$centerid = $userdata["centerid"];
} elseif ($userdata["kengen"] == 50) {
$centerid = $userdata["centerid"];
} else {
//納品先を指定した場合
if ($_POST[tenpo] <>"") { //納品先マスターから取得する
$data = dbselect("leadtime,shimetime,centerid,gyotaiid,picktimes","`".$company."shozokumaster`","shozokuid='".$_POST[tenpo]."'",-1,-1);
$centerid = $data[0][2];
} else {
$centerid = "";
}
}
// ショップ名を取得する
$n = sizeof( $tenpodata );
for ( $i = 0; $i < $n; $i++ ) {
if ( $tenpodata[$i][1] == $shozokuid ) {
$shop_name = $tenpodata[$i][0];
}
}
// デバッグ用の出力
PostData();
//表示順番リスト
$orderlist = array(array("発注頻度","1"),array("本部標準","2"));
//検索処理
$sw = $_POST[staff_code];
Testecho($sw);
$sw = mb_convert_kana($sw,'rn'); //全て半角へ変換
Testecho("検索語:".$sw);
//発注締め時間の表記
if ((int)$userdata["hacchutime"] < 10) {
$shimestr = "00:0".$userdata["hacchutime"];
} elseif ((int)$userdata["hacchutime"]<100) {
$shimestr = "00:".substr($userdata["hacchutime"], 0, 2);
} elseif ((int)$userdata["hacchutime"]<1000) {
$shimestr = substr($userdata["hacchutime"], 0, 1).":".substr($userdata["hacchutime"], 1, 2);
} else {
$shimestr = substr($userdata["hacchutime"], 0, 2).":".substr($userdata["hacchutime"], 2, 2);
}
//緊急出荷
if ( $_POST["quick"] == 1) {
$intquick = 1;
} else {
$intquick = 0; //通常
}
//出荷作業日の特定
if($userdata["hacchutime"] == 0) {
//00:00は必ず翌日
$operatedate = 1;
} elseif($userdata["hacchutime"] <= (int)date("Gi")) {
//締め時間を過ぎている時は翌日
$operatedate = 1;
} else {
//締め時間前は当日
$operatedate = 0;
}
//メール用
$shohindata = dbselect("sm.shohinmei,sm.shohincd","`".$company."shohinmaster` AS sm inner join `".$company."shozokushohin` AS ts USING(shohincd)","ts.shozokuid='".$shozokuid."' AND sm.zaiko = 1 AND sm.shohin_kubun1 = 1 ",-1,-1);
$errcount = 0; //エラーカウント
$okcount = 0; //エラーカウント
$errmsg = ""; //エラーメッセージ
$stremail = "作業日:".date("Y/m/d",strtotime ("".$operatedate." day"))."\n"; //メールメッセージ
$stremail .= "納品先:" . GetList( $tenpodata, $shozokuid ) . "\n";
$staff_code = trim($_POST[staff_code]); //staff id
$staff_name = $_POST[staff_name]; //staff name
$staff_sex = $_POST[staff_sex];
$control_id = $_POST[control_id];
//表示順の指定
if ( $_POST[order] == "") {
$order = 1;
} else {
$order = (int)$_POST[order];
}
//サプライヤー選択
if ($_POST[maker]<>"") {
$strsqlmaker .= " and sm.makercode = '".$_POST[maker]."'";
}
$staff_code_error = "[$sw] 該当するセラピストが見つかりません。セラピストコードを入力してください。";
$hit_flg = 0; // Default
Testecho( "
shozokuid = " . $shozokuid . "
");
if ( $_POST[control_id] <> 1 ) {
} else if ( $shozokuid <> '' ){
// staffデータを取り出す
if($_POST[staffid] == "") {
if($userdata["roleid"] == 7) {
//店舗ユーザー
$staff_data = dbselect( "staff_name,staffid, sex", "`" . $company . "staff`", " ( end_date is null OR end_date >= DATE_ADD(CURDATE(), INTERVAL $operatedate DAY ) ) AND ( start_date is null OR start_date <= DATE_ADD( CURDATE(), INTERVAL $operatedate DAY ) ) AND staffid = '".$staff_code."' and yukoflg = 1", -1, -1 );
} else {
$staff_data = dbselect( "staff_name,staffid, sex", "`" . $company . "staff`", " ( end_date is null OR end_date >= DATE_ADD(CURDATE(), INTERVAL $operatedate DAY ) ) AND ( start_date is null OR start_date <= DATE_ADD( CURDATE(), INTERVAL $operatedate DAY ) ) AND ((staffid like '%".$staff_code."%') or (staff_name like '%" . mb_convert_encoding($staff_code, "UTF-8", "UTF-8")."%')) and yukoflg = 1", -1, -1 );
}
} else {
$staff_data = dbselect( "staff_name,staffid, sex", "`" . $company . "staff`", " ( end_date is null OR end_date >= DATE_ADD(CURDATE(), INTERVAL $operatedate DAY ) ) AND ( start_date is null OR start_date <= DATE_ADD( CURDATE(), INTERVAL $operatedate DAY ) ) AND staffid = '".$_POST[staffid]."' and yukoflg = 1", -1, -1 );
}
Testecho($strsqldbselect);
if ( sizeof($staff_data) == 0 ) {
//該当なし
$hit_flg = 2;
} elseif ( sizeof($staff_data) > 1 ) {
//複数
$hit_flg = 3;
} else {
//一意
$hit_flg = 1;
$staff_code = $staff_data[0][1]; //staff id
$staff_name = $staff_data[0][0]; //staff name
$staff_sex = (int)$staff_data[0][2]; //staff sex
}
}
if ( $staff_sex == 0 ) {
$condition1 = " AND sm.shohin_kubun1 in(1,3) ";
} else if ( $staff_sex == 1 ) {
$condition1 = " AND sm.shohin_kubun1 in(2,3) ";
} else {
$condition1 = " AND sm.shohin_kubun1 in(1,2,3) ";
}
//商品のリストを取り出す(shohin in 句用&総合計数用)
$strsql1 = "SELECT sm.shohincd FROM `" . $company . "shohinmaster` AS sm inner join `". $company . "shozokushohin` AS ts USING(shohincd) WHERE ( sm.sell_end_date is null OR sm.sell_end_date >= DATE_ADD(CURDATE(), INTERVAL $operatedate DAY ) ) AND (sm.sell_start_date is null OR sm.sell_start_date <= DATE_ADD( CURDATE(), INTERVAL $operatedate DAY ) ) AND ts.shozokuid = '$shozokuid' and sm.zaiko = 1 and sm.gyotaiid = '" . $userdata["gyotaiid"] . "' ".$condition1.$strsqlsearchword.$strsqlmaker;
//表示順
$strsqlorderby = " order by sm.shohin_kubun1,sm.shohincd";
$strsql1 .=" order by sm.shohin_kubun1,sm.shohincd";
//受注カートデータ
$strsqlorder="SELECT cart.ordercartid,cart.shohincd,cart.staffid,cart.cartqty,cart.cartflg FROM `".$company."ordercart` AS cart WHERE inputdate = CURDATE() and cart.staffid = '".$staff_code."' and cart.shozokuid ='".$shozokuid."' and cartflg = 0 and quickflg = '".$intquick."' ";
$strsqlorder="($strsqlorder) AS os";
//SELECT項目
$strsqlselsect = "sm.shohincd, sm.shohinmei, sm.kikaku, ss.nohinprice, sm.stockoutflg,os.cartqty, os.cartflg, sm.sell_end_date, os.ordercartid, TO_DAYS(DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)) - TO_DAYS(sm.sell_end_date) as 'nouhincheck', sm.poplevel, ss.poplevel2 ";
//既発注のみ//発注確認
$title="発注(制服関連)";
$strsqlall="LEFT JOIN";
//データ取得数
$limit = " LIMIT ".($pageset*($page - 1)).",$pageset";
//商品マスタをメインに、サプライヤーマスタ内部接続、発注カートテーブル外部接続で、発注日が指定日のリストを取り出す
$strsql2 =
"SELECT $strsqlselsect
FROM `".$company."shohinmaster` AS sm $strsqlall $strsqlorder ON sm.shohincd = os.shohincd,
`company` AS mm ,`".$company."shozokushohin` AS ss
WHERE sm.makercode = mm.companyid and ss.shozokuid = '".$shozokuid."' and sm.shohincd = ss.shohincd and ".dbselectin($strsql1.$limit," sm.shohincd in ").$strsqlorderby;
//カートの情報取得(カート内分、発注確定分)
$cartdata["cart"] = dbselect("count(distinct(sm.shohincd)),sum(cart.cartqty),sum(ss.nohinprice * cart.cartqty)","`".$company."shohinmaster` AS sm INNER JOIN `".$company."ordercart` AS cart USING(shohincd),`".$company."shozokushohin` AS ss","ss.shozokuid = cart.shozokuid and ss.shohincd = cart.shohincd and cart.operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.staffid != '' and cart.shozokuid= '".$shozokuid."' and cartflg = 0 and quickflg = '".$intquick."' ",-1,1);
Testecho($strsqldbselect);
$cartdata["kakutei"] = dbselect("count(distinct(sm.shohincd)),sum(cart.cartqty),sum(ss.nohinprice * cart.cartqty)","`".$company."shohinmaster` AS sm INNER JOIN `".$company."ordercart` AS cart USING(shohincd),`".$company."shozokushohin` AS ss","ss.shozokuid = cart.shozokuid and ss.shohincd = cart.shohincd and cart.operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.staffid != '' and cart.shozokuid= '".$shozokuid."' and cartflg = 1 and quickflg = '".$intquick."' ",-1,1);
Testecho($strsqldbselect);
//全数
$result=@mysql_query($strsql2,$my_con);
$row=@mysql_num_rows($result);
mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
//欠品ステータス
$codedata7 = dbselect("cname,code","`".$company."code`","codekind = 7","code",-1);
?>