"" ) { $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); ?> 1 ) { ?>
セラピストコード$staff_code
セラピスト名$staff_name
店舗コード$shozokuid
納品先$shop_name
HTML_PARAGRAPH; } ?> 0) { if ($okcount > 0 ){ PrintMsg("","$okcount 件のデータを更新しました。",450); if ($settingdata["order_mail_send"] == 1) { MailSendMsg($stremail,"発注受付 ",1);//メール送信 } } if ($errcount > 0 ){ PrintMsg("登録エラーが $errcount 件有りました。
$errmsg","",700); } } ?> hit_flg = " . $hit_flg . "
" ); Testecho( "
control_id = " . $control_id . "
" ); if (($userdata["kengen"] < 50) and ($shozokuid=="")) { PrintMsg("","納品先を指定下さい。",700); } else { //start OK //一覧エリアを表示する if ( $hit_flg == 2 ) { PrintMsg($staff_code_error,"",700); } ?> = 0) { ?>
カートに商品ありません。
">
カートに商品 計点 円 選択済み。
0) { ?>
">
商品 計点 円 確定済み。
0) { $strShowNavBar = "カートに入れる・数量更新"; $strButtonName = "update2"; $strAddJavascript = "buttondisabled();"; ShowNavBar3($row,$pageset,$page,"800",$order); ?> 0) {?>
No 商品コード 商品名 サイズ 金額 数量 カート受付数
検索結果はゼロ件でした。
マスター系のデータ不整合が存在します。(管理者へ連絡下さい) []
0) { echo "欠品中 "; } else { ?>