= '0'){ $category = (int)$_POST[category]; $strsqlwhere .= " and sm.category = '$category'"; } else { $category = -1; } $codedataA[] = array('全て',""); //3.ブランド if($userdata[brand] <> "") { $strsqlwherebrand = " AND brand in (".$userdata["brand"].")"; $whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE 1=1 ".$strsqlwherebrand." "; $strsqlwhereshozoku = dbselectin($whereselectin," and shozokuid in "); $tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid,shozoku_string1,shozoku_string2","`".$company."shozokumaster` as main","1=1".$strsqlwhereshozoku,"shozokuid",-1); testecho($strsqldbselect); //ブランド $codedata105 = dbselect("cname,code","`".$company."code`","codekind = 105 and code in (".$userdata["brand"].")","cname",-1); $codedata105 = array_merge_recursive($codedataA, $codedata105); } else { //ブランド $codedata105 = dbselect("cname,code","`".$company."code`","codekind = 105","cname",-1); $codedata105 = array_merge_recursive($codedataA, $codedata105); $tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid,shozoku_string1","`".$company."shozokumaster` as main",-1,"shozokuid",-1); testecho($strsqldbselect); } //4.温度 $codedata1 = dbselect("cname,code","`".$company."code`","codekind = 1","cname",-1); //商品検索 if($_POST["mode"] == "shohinselect") { //1.キーワード $sw = trim(mb_convert_kana($_POST[searchword], "s", 'UTF-8')); if ($sw <> "") { $sw = mb_convert_kana($sw,'KV'); //全て全角へ変換 $strsql_shohin = " and sm.searchword like '%".$sw."%'"; } //2.サプライヤー if ($_POST["maker"] <> ""){ $strsql_shohin .= " and sm.makercode = '".$_POST["maker"]."' "; } elseif ($userdata["supplyerid2"]<> ""){ $strsql_shohin .= " and sm.makercode in (".$userdata["supplyerid2"].") "; } //3.流通型 if ($_POST["ryutu_type"] <> ""){ $strsql_shohin .= " and sm.ryutu_type = '".$_POST[ryutu_type]."'"; } //4.商品カテゴリー if ($_POST["category"] <> ""){ $strsql_shohin .= " and sm.category = '".$_POST["category"]."'"; } //商品SQL $strsql = "SELECT sm.* FROM `".$company."shohinmaster` AS sm WHERE (sm.sell_end_date is null OR sm.sell_end_date >= DATE_ADD(CURDATE(),INTERVAL 5 DAY)) AND (sm.sell_start_date is null OR sm.sell_start_date <= DATE_ADD(CURDATE(),INTERVAL 5 DAY)) ".$strsql_shohin.""; //全数 $result=@mysql_query($strsql,$my_con); $maxrow=@mysql_num_rows($result); //データ取得数 $limit = " LIMIT ".($pageset*($page - 1)).",$pageset"; $resultshohin=@mysql_query($strsql.$limit,$my_con); $row=@mysql_num_rows($resultshohin); mysql_sql_log2($strsql.$limit,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho($strsql.$limit." MAXROWS=".$maxrow." ROWS".$row); } else { } //納品先コードの設定 //ブランド if($userdata[brand] <> "") { $whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")"; $strsqlwherebrand = dbselectin($whereselectin," and shozokuid in "); $tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlwherebrand,"shozokuid",-1); } Testecho(sizeof($tenpodata)."=SHOPCOUNT LINE:".__LINE__); //納品先の絞込み if ($_POST[shop]<>"") { $shop = trim(mb_convert_kana($_POST[shop], "s", 'UTF-8')); $strsqlshop = "search like '%".mb_convert_encoding($shop, "UTF-8", "UTF-8")."%'"; //UTF-8に変換して入れる $tenpodata2 = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",$strsqlshop.$strsqlwhere,"shozokuid",-1); if(sizeof($tenpodata2)==1) { $shozokuid = $tenpodata2[0][1]; $tenpoinputnew =$tenpodata2[0][1]; } else { $shozokuid = ""; $tenpodata = $tenpodata2 ; } } elseif($_POST[shozokuid] <> "") { $shozokuid = $_POST[shozokuid]; } else { $strsqlshop = -1; } //二重更新防止 $wpostcheck = dbselect("count(orderid)","`".$company."shukka_add`","creater= '".$userdata[tid]."' and createdate > (NOW() - INTERVAL 3 SECOND)",-1,-1); Testecho($strsqldbselect); if ($wpostcheck[0][0] > 0) { $wpostflg = 1; //更新禁止 Testecho("更新禁止"); } else { $wpostflg = 0; //更新可能 } //発注処理 if (($_POST[update] <> "") and ($wpostflg == "0")){ $ii = 0; For ($i = 0;$i <= ($_POST[row2]);$i++) { if ($_POST["shohin"][$i] == "") break; //echo $_POST["shohin"][$y]; $intAdd = 0;//0:同一 1:同一無し if($InputValues[$ii - 1]["operatedate"] <> date("Y-m-d",strtotime($_POST["chday"]." day"))) $intAdd = 1; if($InputValues[$ii - 1]["deliverdate"] <> date("Y-m-d",strtotime($_POST["deliverdate"][$i]." day"))) $intAdd = 1; if($InputValues[$ii - 1]["shohincd"] <> $_POST["shohin"][$i]) $intAdd = 1; if($InputValues[$ii - 1]["shozokuid"] <> $_POST["shozoku"][$i]) $intAdd = 1; if($intAdd == 1) { //配列変数にセットする $InputValues[$ii]["shukkaid"] = $_POST["shukkaid"][$i]; $InputValues[$ii]["operatedate"] = date("Y-m-d",strtotime($_POST["chday"]." day")); $InputValues[$ii]["deliverdate"] = date("Y-m-d",strtotime($_POST["deliverdate"][$i]." day")); $InputValues[$ii]["shohincd"] = $_POST["shohin"][$i]; $InputValues[$ii]["shozokuid"] = $_POST["shozoku"][$i]; $InputValues[$ii]["inputqty"] = $_POST["amount"][$i]; if($_POST["amount"][$i] == ""){$InputValues[$ii]["inputqty"] = 0;} //出荷実績有で数量指定無い時はを0とする $InputValues[$ii]["totalgram"] = $_POST["totalgram"][$i]; $InputValues[$ii]["shukkadate"] = date("Y-m-d",strtotime($_POST["chday"]." day")); $InputValues[$ii]["price_piece"] = $_POST["price"][$i]; if(($_POST["totalgram"][$i] > 0) and ($_POST["amount"][$i] == "")) {$InputValues[$ii]["inputqty"] = 1;}//重量のみは数量を1とする // $InputValues[$i]["price_piece2"] = $_POST["price2"][$i]; // $InputValues[$i]["supplyerid"] = $_POST["supplyerid"][$i]; $ii++; } else { $InputValues[$ii - 1]["inputqty"] += $_POST["amount"][$i]; $InputValues[$ii - 1]["totalgram"] += $_POST["totalgram"][$i]; } } var_dump($InputValues); if($ii > 0) {inputShukkaAdd2($InputValues,$strmsg,$ii,"");} } //最終リストの抽出 if(($_POST["shohincd"] <> "" ) or ($_POST["shozokuid"] <> "") ) { if($_POST["chday"] <> "") {$chday = $_POST["chday"];} else {$chday = 0;} $strsql_date = " and operatedate = DATE_ADD(curdate(), INTERVAL ".$chday." DAY)"; if($_POST["shozokuid"] <> "") { $shozokuid = $_POST["shozokuid"]; $strsql_shozoku2 = " and ss.shozokuid = '".$_POST["shozokuid"]."' "; //1.キーワード $sw = trim($_POST["searchword"]); if ($sw <> "") { $sw = mb_convert_kana($sw,'KV'); //全て全角へ変換 $strsql_shohin = " and sm.searchword like '%".$sw."%'"; } //2.サプライヤー if ($_POST["maker"] <> ""){ $strsql_shohin .= " and sm.makercode = '".$_POST["maker"]."' "; } //3.流通型 if ($_POST["ryutu_type"] <> ""){ $strsql_shohin .= " and sm.ryutu_type = '".$_POST[ryutu_type]."'"; } //4.商品カテゴリー if ($_POST["category"] <> ""){ $strsql_shohin .= " and sm.category = '".$_POST["category"]."'"; } //商品SQL if($strsql_shohin <> "") { $strsql_shohin2 = dbselectin("SELECT shohincd FROM `".$company."shohinmaster` as sm WHERE 1 = 1 $strsql_shohin"," and ss.shohincd in "); } } else { $shohincd = $_POST["shohincd"]; $strsql_shohin2.= " and ss.shohincd = '".$_POST["shohincd"]."'"; //1.業態 if ($_POST["brand"] <> ""){ $strsql_shozoku2 = dbselectin("SELECT shozokuid FROM `".$company."shozokumaster` WHERE brand = '".$_POST["brand"]."'"," and ss.shozokuid in "); } } //tableA 所属商品のテーブル $strsqlA = "SELECT ss.shohincd,ss.shozokuid,ss.nohinprice FROM `".$company."shozokushohin` AS ss WHERE 1 = 1 $strsql_shozoku2 $strsql_shohin2"; //echo $strsqlA; //tableB 出荷実績 $strsqlB = "SELECT count(ss.shukkaid) as CNT, min(ss.shukkaid) as shukkaidmin, min(ss.lotnum) as lotnummin, max(ss.lotnum) as lotnumman, ss.shohincd, ss.shozokuid, ss.deliverdate, ss.price_piece, sum(ss.price_total) as price_total, sum(ss.shukkaqty) as shukkaqty, sum(ifnull(ss.totalgram,0)) as totalgram FROM `".$company."shukka` AS ss WHERE shukkaqty > 0 $strsql_date $strsql_shozoku2 $strsql_shohin2 GROUP BY shohincd,shozokuid"; //echo $strsql; $strsqlmain = "SELECT b.CNT, b.shukkaidmin, b.shozokuid, b.shohincd, b.lotnummin, b.lotnumman, b.price_piece, b.price_total, b.shukkaqty, b.totalgram, ifnull(a.nohinprice,0) as nohinprice, sho.shozokuname, sm.leadtime as smlead, sm.shohinmei, sm.shohinmei2, sm.shohincd2, sm.shohincd3, sm.code, sm.makercode, sm.ryutu_type, sm.shohin_kubun3, sm.irisuu, sm.aisuu, sm.kikaku, sm.category, sm.shohin_string2, sho.leadtime as sholead, sho.shozokuname, sho.centerid, DATEDIFF(b.deliverdate,curdate()) as deliverdate FROM ($strsqlB) as b LEFT JOIN ($strsqlA) as a USING(shohincd,shozokuid), `".$company."shozokumaster` AS sho, `".$company."shohinmaster` AS sm WHERE b.shozokuid = sho.shozokuid AND b.shohincd = sm.shohincd ORDER BY sho.brand,b.shozokuid,b.shohincd"; Testecho ($strsqlmain); //全数 $resultmain=@mysql_query($strsqlmain,$my_con); $maxrow2=@mysql_num_rows($resultmain); //データ取得数 $limit = " LIMIT ".($pageset*($page - 1)).",$pageset"; $resultmain=@mysql_query($strsqlmain.$limit,$my_con); $row2=@mysql_num_rows($resultmain); mysql_sql_log2($resultmain.$limit,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho($strsqlmain.$limit." MAXROWS=".$maxrow2." ROWS".$row2); } //出荷ステータス $codedata5 = dbselect("cname,code","`".$company."code`","codekind = 5","code",-1); //欠品ステータス $codedata7 = dbselect("cname,code","`".$company."code`","codekind = 7","code",-1); ?>

"") {$style = "display:block"; } else {$style = "display:none"; } ?>
納品先
No 選択 商品名 商品コード サプライヤー 入数 合数 ﾘｰﾄﾞ 温度 ｶﾃｺﾞﾘ 型 価格単位 規格
'); return true" class="box1s" value="選択" > "") {echo $data[shohinmei2]."
";} echo $data[shohinmei]; //商品名 ?>
"> "> "> "" ) or ($shozokuid <> "") ) { if($_POST["shohincd"] <> "" ) { //商品情報 $shohindata = dbselect("shohinmei,shohincd,ryutu_type",$company."shohinmaster","shohincd ='".$shohincd."'",-1,-1); //在庫型情報 if($shohindata[0][2] == 1) { $stockdata = dbselect("SUM(nonreserveqty),centerid,kikaku",$company."stockdata as sd INNER JOIN ".$company."shohinmaster USING(shohincd)","sd.shohincd ='".$shohincd."' and validflg = 1 GROUP BY centerid,shohincd",-1,-1); if(sizeof($stockdata) == 0 ) { PrintMsg("現在の有効在庫：無し　出荷実績を作成できません。","",700); $strnodata = " disabled=\"disabled\""; } else { For($p = 0;$p < sizeof($stockdata);$p++) { PrintMsg("","現在の有効在庫：".GetListData($centerdata,$stockdata[$p][1],0)." ".$stockdata[$p][0]. " ".$stockdata[$p][2],700); } } } } ?>
出荷作業日
 "" ) { ?> "> 商品
 業態
 納品先
 流通型
 カテゴリ
0) { if ($okcount > 0 ){ PrintMsg("","$okcount 件の受注データを更新しました。",700); if ($settingdata["order_mail_send"] == 1) { MailSendMsg($stremail,"注文受付 ",1);//メール送信 } } if ($errcount > 0 ){ PrintMsg("登録エラーが $errcount 件有りました。
$errmsg","",700); } } if ($shukka_update["success"] > 0) { PrintMsg("",$shukka_update["success"] ." 件の出荷データを更新しました。",700); } if ($shukka_update["fail"] > 0) { PrintMsg($shukka_update["fail"] ." 件の出荷データを更新出来ませんでした。出荷確定済みデータは変更できません","",700); } if ($direct_update["success"] > 0) { PrintMsg("",$direct_update["success"] ." 件の直送データを更新しました。",700); } if ($direct_update["fail"] > 0) { PrintMsg($direct_update["fail"] ." 件の直送データを更新出来ませんでした。出荷確定済みデータは変更できません","",700); } if ($strerr <> "") { PrintMsg($strerr,"",700); } ?>
作業日：　
"] value=""> "] value="on"> 0) { ShowNavBar3($maxrow2,$pageset,$page,"800",$order); ?> "") { ?> 0) {?>"> "") { echo " "; } if($data[price_piece] > 0) {$price = $data["price_piece"];} else {$price = $data["nohinprice"];} ?>
No 納品先 商品コード 商品 納品日 有効在庫 出荷入力 受付数 価格単位 売価 設定単価 重量 入数 合数 商品ﾘｰﾄﾞ 納品先ﾘｰﾄﾞ ｶﾃｺﾞﾘ 区分 型 出荷ID LOT
検索結果はゼロ件でした。
マスター系のデータ不整合が存在します。（管理者へ連絡下さい） []

";PrintList2($tenpodata,$data["shozokuid"],0); //納品先 ?>		 "") {echo $data[shohinmei2]."
";} echo $data[shohinmei]; //商品名 ?>
[		 "; if($data[ryutu_type] == 1) { $stockdata = dbselect("SUM(nonreserveqty)",$company."stockdata","shohincd ='".$data[shohincd]."' and centerid ='".$data[centerid]."' and validflg = 1 GROUP BY shohincd",-1,-1); if(sizeof($stockdata) == 0 ) { $strnodata = " style = \"visibility:hidden\""; echo "0"; } else { $strnodata = ""; echo "".$stockdata[0][0].""; } } else { $strnodata = ""; echo "通/直"; } echo " " class="EDIT" tabindex="" >  0) {echo $data[shukkaqty].$data[shohin_string2];} //受付数 ?> 0) { ?> " class="EDIT" tabindex="">Kg 1) {echo "(".$data[CNT].")";} //明細 ?> 1) {echo "(".$data[CNT].")";}//LOT ?>
"> "> "> "> "> ">
"> "> "> "> "> "> ">
= 0 ) { return $cknumber; //マイナス以外の数字なら数値で返す } elseif ($cknumber < 0 ) { return $cknumber; //マイナス数字なら数値で返す } else { return "NO-MATCH"; //数値でないならNO-MATCHで返す } } } /*------------------------------------------------------------ * 関数名 : inputShukkaAdd2() * 返却値 : (無し) * 引数 : (1) array:入力情報Value (2) str:エラーメッセージ (3) int:処理件数 (4) str: * 説明 : 出荷データ追加機能 $InputValues[$i]["lotnum"] = 0;//lotnum=0は自動検索 * 使用例 : inputShukkaAdd2($InputValues,$strmsg,$i,""); *------------------------------------------------------------ */ function inputShukkaAdd2( $InputValues, $strmsg, $intMax, $str1){ global $my_con,$company,$userdata,$strmsg,$strerrmsg,$interrcount ,$okcount,$strsqldbselect,$centerdata,$strerr; //TEMPデータ削除 $strsql = "DELETE FROM `".$company."shukka_add` WHERE creater in ('".$userdata["tid"]."' ,'".$userdata["tid"]."DEL')"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //新規データ作成（POST全件） For ($ii = 0; $ii < (int)$intMax; $ii++) { $array_colomn = array_keys($InputValues[$ii]);//更新項目は連想配列より取得 $strsql2 = ""; $strsql = "INSERT INTO `".$company."shukka_add`("; For ($k = 0; $k < sizeof($array_colomn); $k++) { $strsql .= "`".$array_colomn[$k]."`,"; //カラム名 if($InputValues[$ii][$array_colomn[$k]] == "0") { $strsql2 .= "'0',";//値 } elseif($InputValues[$ii][$array_colomn[$k]] == "") { $strsql2 .= "NULL,";//NULL値 } else { $strsql2 .= "'".$InputValues[$ii][$array_colomn[$k]]."',";//値 } } $strsql .= "`creater`,`createdate`) VALUES ("; $strsql .= $strsql2; $strsql .= "'".$userdata["tid"]."',now())"; //更新処理 $result=mysql_query($strsql,$my_con); // Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } //空データ削除（入力済みと新規データが無いものは処理対象外とする） $strsql = "DELETE FROM `".$company."shukka_add` WHERE (inputqty = 0 or inputqty is null) and shukkaid is null and creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //1.出荷実績より補完（出荷有り、修正分） $strsql = "UPDATE `".$company."shukka_add` as a, `".$company."shukka` as shu SET a.shukkaqty = shu.shukkaqty , a.memo = shu.memo , a.memoadd = shu.memoadd , a.memo2 = shu.memo2 , a.memo3 = shu.memo3 , a.memo4 = shu.memo4 , a.rep_id = shu.rep_id , a.rep_id_line = shu.rep_id_line , a.orderid = shu.orderid , a.ordermainid = shu.ordermainid , a.price_piece2 = shu.price_piece2 , a.price_piece3 = shu.price_piece3 , a.supplyerid = shu.supplyerid , a.comeinid = shu.comeinid, a.lotnum = shu.lotnum , a.shomi = shu.shomi , a.stockdate = shu.stockdate , a.cominprice_piece = shu.cominprice_piece WHERE shu.shukkaid = a.shukkaid and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //2.商品Mからの補完 $strsql = "UPDATE `".$company."shukka_add` as a, `".$company."shohinmaster` as sm SET a.futeikan = sm.shohin_kubun3, a.DC_TC = sm.ryutu_type WHERE a.shohincd = sm.shohincd AND a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); //Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //3.データ補完（所属） $strsql = "UPDATE `".$company."shukka_add` as a, `".$company."shozokumaster` as sho SET a.centerid = sho.centerid , a.brand = sho.brand, a.picktimes = sho.picktimes, a.deliveryid = sho.deliveryid, a.route = sho.route WHERE a.shozokuid = sho.shozokuid and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); //Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //4.データ補完（配送先変更） $strsql = "UPDATE `".$company."shukka_add` as a, `".$company."deliverchange` as dc SET a.deliveryid = dc.deliveryid WHERE a.shozokuid = dc.shozokuid AND a.operatedate = dc.operatedate AND a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 4.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //5a.データ補完（価格）定貫 $strsql = "UPDATE `".$company."shukka_add` SET price_total = floor(price_piece * inputqty), price_total2 = floor(price_piece2 * inputqty) , price_total3 = floor(price_piece3 * inputqty) WHERE futeikan = 0 and creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 5a.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //5b.データ補完（価格）不定貫 $strsql = "UPDATE `".$company."shukka_add` SET price_total = floor(price_piece * totalgram), price_total2 = floor(price_piece2 * totalgram) , price_total3 = floor(price_piece3 * totalgram) WHERE futeikan = 1 and creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 5b.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //6a.（出荷ID有り）出荷実績を通過、直送型は、新しい数量、重量、金額、納品日で全て書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."shukka` as shu SET shu.deliverdate = a.deliverdate , shu.shukkaqty = a.inputqty, shu.price_piece = a.price_piece , shu.price_piece2 = a.price_piece2 , shu.price_piece3 = a.price_piece3 , shu.price_total = a.price_total , shu.price_total2 = a.price_total2 , shu.price_total3 = a.price_total3 , shu.totalgram = a.totalgram, shu.updater = a.creater WHERE shu.shukkaid = a.shukkaid and a.DC_TC in (2,3) and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 6a.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //6b.（出荷ID有り）通過、直送型は不定貫出荷データの重量を書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."shukkafuteikan` as shu SET shu.gram = a.totalgram WHERE shu.shukkaid = a.shukkaid and a.DC_TC in (2,3) and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 5b.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //6c.（出荷ID有り）直送データを書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."directsupply` as ds SET ds.deliverdate = a.deliverdate , ds.shukkaqty = a.inputqty, ds.price_piece = a.price_piece , ds.price_buy = a.price_piece2 , ds.price_total = a.price_total , ds.price_buy_total = a.price_total2 , ds.totalgram = a.totalgram, ds.updater = a.creater WHERE ds.shukkaid = a.shukkaid and a.DC_TC in (3) and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 6c.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //7a.（出荷ID無し）通過、直送型は出荷データを作成配列変数にセットする $i = 0; $InputValues = array(array(),array()); $InputValues[$i]["shukkaid"] = "NULL"; $InputValues[$i]["operatedate"] = "operatedate"; $InputValues[$i]["deliverdate"] = "deliverdate"; $InputValues[$i]["shohincd"] = "shohincd"; $InputValues[$i]["shozokuid"] = "shozokuid"; $InputValues[$i]["totalgram"] = "totalgram"; $InputValues[$i]["shukkadate"] = "shukkadate"; $InputValues[$i]["price_piece"] = "price_piece"; $InputValues[$i]["price_total"] = "price_total"; $InputValues[$i]["shukkaqty"] = "inputqty"; $InputValues[$i]["memo"] = "memo"; $InputValues[$i]["memoadd"] = "memoadd"; $InputValues[$i]["memo2"] = "memo2"; $InputValues[$i]["memo3"] = "memo3"; $InputValues[$i]["memo4"] = "memo4"; $InputValues[$i]["rep_id"] = "rep_id"; $InputValues[$i]["rep_id_line"] = "rep_id_line"; $InputValues[$i]["orderid"] = "NULL"; $InputValues[$i]["ordermainid"] = "NULL"; $InputValues[$i]["price_piece3"] = "price_piece3"; $InputValues[$i]["price_total3"] = "price_total3"; $InputValues[$i]["supplyerid"] = "supplyerid"; $InputValues[$i]["price_piece2"] = "price_piece2"; $InputValues[$i]["comeinid"] = "NULL"; $InputValues[$i]["price_total2"] = "price_total2"; $InputValues[$i]["DC_TC"] = "DC_TC"; // $InputValues[$i]["lotnum"] = "lotnum"; // $InputValues[$i]["cominprice_piece"] = "cominprice_piece"; // $InputValues[$i]["stockdate"] = "stockdate"; // $InputValues[$i]["shomi"] = "shomi"; // $InputValues[$i]["loccode"] = "loccode"; $InputValues[$i]["centerid"] = "centerid"; $InputValues[$i]["brand"] = "brand"; $InputValues[$i]["picktimes"] = "picktimes"; $InputValues[$i]["deliveryid"] = "deliveryid"; $InputValues[$i]["route"] = "route"; $InputValues[$i]["gyotaiid"] = "gyotaiid"; $InputValues[$i]["shukka_addid"] = "shukka_addid"; $strInsertTable = "`".$company."shukka`"; $strSelectTable = "`".$company."shukka_add` WHERE shukkaid is NULL AND inputqty > 0 and DC_TC in (2,3) and creater = '".$userdata["tid"]."'"; $introw = InsertSelectSQL($InputValues,$strInsertTable,$strSelectTable,1,1,__LINE__,1); $okcount += $introw; //更新数（通過、直送分） //7b.（出荷ID無し）通過、直送型は不定貫出荷データ作成 $strsql = "INSERT INTO `".$company."shukkafuteikan` (`shukkaid`, `gram`, `creater`, `createdate`) SELECT shu.`shukkaid`, shu.`totalgram`, shu.`creater`, shu.`createdate` FROM ".$company."shukkafuteikan as f RIGHT JOIN ".$company."shukka as shu USING(shukkaid) WHERE shu.totalgram > 0 and f.shukkafuteikanid is null"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 7b.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //7c.（出荷ID無し）直送データ作成(直送） $i = 0; $InputValues = array(array(),array()); $InputValues[$i]["orderid"] = "NULL"; $InputValues[$i]["shozokuid"] = "shozokuid"; $InputValues[$i]["brand"] = "brand"; $InputValues[$i]["shohincd"] = "shohincd"; $InputValues[$i]["centerid"] = "centerid"; $InputValues[$i]["supplyerid"] = "supplyerid"; $InputValues[$i]["gyotaiid"] = "gyotaiid"; $InputValues[$i]["shukkaid"] = "0"; $InputValues[$i]["orderdirectid"] = "NULL"; $InputValues[$i]["directsupplyflg"] = "1"; $InputValues[$i]["stockdate"] = "NULL"; $InputValues[$i]["shomi"] = "NULL"; $InputValues[$i]["shukkaqty"] = "inputqty"; $InputValues[$i]["operatedate"] = "operatedate"; $InputValues[$i]["shukkadate"] = "shukkadate"; $InputValues[$i]["deliverdate"] = "deliverdate"; $InputValues[$i]["keppinid"] = "NULL"; $InputValues[$i]["price_piece"] = "price_piece"; $InputValues[$i]["price_total"] = "price_total"; $InputValues[$i]["totalgram"] = "totalgram"; $InputValues[$i]["price_buy"] = "price_piece2"; $InputValues[$i]["price_buy_total"] = "price_total2"; $InputValues[$i]["price_shipping"] = "0"; $InputValues[$i]["memo"] = "memo"; $InputValues[$i]["shukka_addid"] = "shukka_addid"; $strInsertTable = "`".$company."directsupply`"; $strSelectTable = "`".$company."shukka_add` WHERE shukkaid is NULL and inputqty > 0 and DC_TC in (3) and creater = '".$userdata["tid"]."'"; $introw = InsertSelectSQL($InputValues,$strInsertTable,$strSelectTable,1,1,__LINE__,1); //8a.在庫品＋出荷ID有り＋変動有りは在庫引当を行う（変動がある商品はshukka_addflg = 2として、在庫引当を行う。） //8b.在庫品＋出荷ID有り＋変動無しは出荷数量以外を更新する //8c.在庫品＋出荷ID無しは在庫引当を行う //8aのデータを2に更新 $whereselectin = "SELECT `shohincd` FROM `".$company."shukka_add` WHERE ((shukkaid is NULL) or (inputqty <> shukkaqty)) and DC_TC in (0,1) and creater = '".$userdata["tid"]."'"; Testecho(__LINE__." 8b.".$whereselectin); $strsql2 = dbselectin($whereselectin," and shohincd in "); $strsql = "UPDATE `".$company."shukka_add` SET shukka_addflg = 2 WHERE DC_TC in (0,1) and creater = '".$userdata["tid"]."' ". $strsql2; $result=mysql_query($strsql,$my_con); Testecho(__LINE__." 8a.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //重複分の集計データ作成 /* $strsql = "INSERT INTO `".$company."shukka_add` (`groupby`,`shukkaid`, `operatedate`, `deliverdate`, `shohincd`, `shozokuid`, `inputqty`, `totalgram`, `shukkadate`, `price_piece`, `price_total`, `shukkaqty`, `memo`, `memoadd`, `memo2`, `memo3`, `memo4`, `creater`, `createdate`) SELECT count(`shukka_addid`) as CNT, min(`shukkaid`), `operatedate`, `deliverdate`, `shohincd`, `shozokuid`, sum(`inputqty`), sum(`totalgram`), `shukkadate`, max(`price_piece`),sum( `price_total`), sum(`shukkaqty`), `memo`, `memoadd`, `memo2`, `memo3`, `memo4`,'".$userdata["tid"]."',now() FROM ".$company."shukka_add WHERE `creater` = '".$userdata["tid"]."' GROUP BY operatedate,deliverdate,shohincd,shozokuid HAVING CNT > 1"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //元データ削除 $strsql = "DELETE FROM `".$company."shukka_add` WHERE creater = '".$userdata["tid"]."DEL'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); */ //8b-1.数量以外の出荷実績を書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."shukka` as shu SET shu.deliverdate = a.deliverdate , shu.price_piece = a.price_piece , shu.price_piece2 = a.price_piece2 , shu.price_piece3 = a.price_piece3 , shu.price_total = a.price_total , shu.price_total2 = a.price_total2 , shu.price_total3 = a.price_total3 , shu.totalgram = a.totalgram, shu.updater = a.creater WHERE shu.shukkaid = a.shukkaid and a.DC_TC in (0,1) and shukka_addflg = 1 and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 8b-1.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //8b-2.不定貫出荷データの重量を書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."shukkafuteikan` as shu SET shu.gram = a.totalgram WHERE shu.shukkaid = a.shukkaid and a.DC_TC in (0,1) and shukka_addflg = 1 and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 8b-2.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //8b-3.直送データを書き換える $strsql = "UPDATE `".$company."shukka_add` as a,`".$company."directsupply` as ds SET ds.deliverdate = a.deliverdate , ds.price_piece = a.price_piece , ds.price_buy = a.price_piece2 , ds.price_total = a.price_total , ds.price_buy_total = a.price_total2 , ds.totalgram = a.totalgram, ds.updater = a.creater WHERE ds.shukkaid = a.shukkaid and a.DC_TC in (0,1) and shukka_addflg = 1 and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 8b-3.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho (__LINE__." 在庫引当開始"); //8b/8c在庫引当 $zaikoShohinList = dbselect("distinct(shohincd)",$company."shukka_add","DC_TC in (0,1) and ((shukkaid is NULL) or (shukka_addflg = 2)) and creater = '".$userdata["tid"]."'",-1,-1); Testecho (__LINE__." 8b.8c.ROW=".mysql_affected_rows()." ".$strsqldbselect); $cnt = sizeof($zaikoShohinList); $cnt2 = sizeof($centerdata); //商品単位 for($kk =0;$kk < $cnt;$kk++) { $interr = 0; //センター単位 for($k =0;$k < $cnt2;$k++) { //全在庫数との比較 Testecho (__LINE__." KK-K=".$kk."-".$k." CD=".$zaikoShohinList[$kk][0]); //$stockdatatotal = dbselect("sum(nonreserveqty),lotnum",$company."stockdata","nonreserveqty > 0 AND shohincd = '".$zaikoShohinList[$kk][0]."' and centerid ='".$centerdata[$k][1]."' GROUP BY shohincd",-1,-1); $stockdatatotal = dbselect("sum(stockqty),lotnum",$company."stockdata","stockqty > 0 AND shohincd = '".$zaikoShohinList[$kk][0]."' and centerid ='".$centerdata[$k][1]."' GROUP BY shohincd",-1,-1); Testecho (__LINE__."K=".$k.$strsqldbselect); //全出荷数との比較 $shukkadata = dbselect("sum(inputqty),centerid,sum(shukkaqty)",$company."shukka_add","DC_TC in(0, 1) AND shohincd = '".$zaikoShohinList[$kk][0]."' and centerid ='".$centerdata[$k][1]."' and creater = '".$userdata["tid"]."' GROUP BY shohincd",-1,-1); Testecho (__LINE__."K=".$strsqldbselect); Testecho (__LINE__."INPUT=".$shukkadata[0][0]." SHU=".$shukkadata[0][2]." SD=".$stockdatatotal[0][0]); $intZaikoQty = (int)$shukkadata[0][2] + (int)$stockdatatotal[0][0]; if(($shukkadata[0][0] > 0) and ($intZaikoQty <= $shukkadata[0][0])){ $strerr .= "商品CD:".$zaikoShohinList[$kk][0]."はセンター".$centerdata[$k][0]."の在庫より出荷総数が多いため追加出来ません。出荷総数:".$shukkadata[0][0]." 在庫総数:".$intZaikoQty."
"; $interr = 1; Testecho (__LINE__.$strerr); Testecho (__LINE__." CENTER=".$centerdata[$k][1]." 出荷数合計=".$shukkadata[0][0]." 在庫数= ".$intZaikoQty." 在庫オーバーNG"); } elseif(sizeof($shukkadata) ==0) { Testecho (__LINE__." CENTER=".$centerdata[$k][1]." 出荷数合計=0 "); } else { Testecho (__LINE__." CENTER=".$centerdata[$k][1]." 出荷数合計=".$shukkadata[0][0]." 在庫数= ".$intZaikoQty." 在庫数量内でOK"); } } if($interr == 0) { //全センターで在庫数OKなら在庫を戻して引き落とす　商品単位 //8a在庫を戻す $strsql = "UPDATE `".$company."stockdata` as sd, (SELECT sum(shukkaqty) as shukkaqty,lotnum,shukka_addflg FROM `".$company."shukka_add` WHERE shohincd = '".$zaikoShohinList[$kk][0]."' and shukka_addflg = 2 and creater = '".$userdata["tid"]."' GROUP BY shohincd,lotnum) as shu SET nonreserveqty = nonreserveqty + shu.shukkaqty, validflg = 1 WHERE sd.lotnum = shu.lotnum"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 8a.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //8aの出荷実績を消去 $whereselectin = "SELECT `shukkaid` FROM `".$company."shukka_add` as a WHERE shohincd = '".$zaikoShohinList[$kk][0]."' and a.shukka_addflg = 2 and a.creater = '".$userdata["tid"]."'"; $strsql2 = dbselectin($whereselectin," and shukkaid in "); $strsql = "DELETE FROM `".$company."shukka` WHERE 1 = 1 ".$strsql2; $result=mysql_query($strsql,$my_con); Testecho(__LINE__." 8a.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); ShukkaAddStock($zaikoShohinList[$kk][0]); } else { Testecho (__LINE__."処理SKIP shohincd = '".$zaikoShohinList[$kk][0]."'"); } } //8.在庫型の不定貫出荷データ作成 $strsql = "INSERT INTO `".$company."shukkafuteikan` (`shukkaid`, `gram`, `creater`, `createdate`) SELECT shu.`shukkaid`, shu.`totalgram`, shu.`creater`, shu.`createdate` FROM ".$company."shukkafuteikan as f RIGHT JOIN ".$company."shukka as shu USING(shukkaid) WHERE shu.totalgram > 0 and f.shukkafuteikanid is null"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__." 8.ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //8.直送データに出荷ID設定 $strsql = "UPDATE `".$company."directsupply` as ds, `".$company."shukka` as shu SET ds.shukkaid = shu.shukkaid WHERE ds.shukkaid = 0 AND ds.shukka_addid = shu.shukka_addid"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } /*------------------------------------------------------------ * 関数名 : ShukkaAddStock() * 返却値 : なし * 引数 : 1：商品CD * 説明 : 出荷実績追加テーブルから在庫を引き落として出荷実績を作成する * 使用例 : ShukkaAddStock(); *------------------------------------------------------------ */ Function ShukkaAddStock($shohincd){ global $okcount,$my_con,$company,$userdata,$strsqldbselect; //在庫整理 $strsql = "UPDATE `".$company."stockdata SET validflg = 1 WHERE nonreserveqty > 0 and validflg = 0"; $result=mysql_query($strsql,$my_con); //残在庫に数量入れる Testecho("ShukkaAddStock　開始 商品CD=".$shohincd); $strsql = "UPDATE `".$company."shukka_add` as a SET zanshukka = inputqty WHERE a.shohincd = '".$shohincd."' AND DC_TC in (0,1) and a.creater = '".$userdata["tid"]."'"; $result=mysql_query($strsql,$my_con); $okcount += mysql_affected_rows(); //更新数 Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //出荷予定データ 残出荷が無くなるまで（$zanshukkaflg が1）になるまで回す for ($k = 1;$zanshukkaflg = 1;$k++){ //出荷予定1件 $strsql = "SELECT zanshukka,shohincd,shozokuid,centerid,shukka_addid,futeikan FROM `".$company."shukka_add` as a WHERE zanshukka > 0 AND a.shohincd = '".$shohincd."' AND DC_TC in (0,1) and a.creater = '".$userdata["tid"]."' order by shozokuid LIMIT 1"; $resultshukka = @mysql_query($strsql,$my_con); $rowshukka = @mysql_num_rows($resultshukka); Testecho (__LINE__."K=".$k." ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); if($rowshukka == 0) { //引当必要なもの終了 $zanshukkaflg = 1; Testecho($k."回目　引当終了"); break; } else{ $datashukka=@mysql_fetch_array($resultshukka); //有効な最古ロットを取得 $stockdata = dbselect("nonreserveqty,lotnum,shomi,stockdate,comeinprice,location",$company."stockdata","nonreserveqty > 0 and shohincd = '".$shohincd."' AND centerid = '".$datashukka["centerid"]."'","shomi,lotnum",1); //出荷判定 Testecho("残出荷数:".$datashukka["zanshukka"]." 在庫:".$stockdata[0][0].$strsqldbselect); if($datashukka["zanshukka"] <= $stockdata[0][0]) { //全数同一LOT //在庫数量以下　全数出荷する $strsql = "UPDATE `".$company."shukka_add` SET shukkaqty = zanshukka,lotnum = '".$stockdata[0][1]."',shomi='".$stockdata[0][2]."',stockdate='".$stockdata[0][3]."' ,cominprice_piece ='".$stockdata[0][4]."' ,zanshukka = 0,loccode ='".$stockdata[0][5]."' WHERE shukka_addid ='".$datashukka["shukka_addid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."全数出荷 ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //在庫データ更新 $strsql = "UPDATE `".$company."stockdata` SET nonreserveqty = '".((int)$stockdata[0][0] - (int)$datashukka["zanshukka"])."' WHERE lotnum = '".$stockdata[0][1]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."全部出荷 ".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } else { //在庫数分を別LOT //在庫数量以下　一部出荷する $strsql = "UPDATE `".$company."shukka_add` SET shukkaqty = '".(int)$stockdata[0][0]."', lotnum = '".$stockdata[0][1]."',shomi='".$stockdata[0][2]."',stockdate='".$stockdata[0][3]."' ,zanshukka = ".((int)$datashukka["zanshukka"] - (int)$stockdata[0][0]).",cominprice_piece ='".$stockdata[0][4]."',loccode ='".$stockdata[0][5]."' WHERE shukka_addid ='".$datashukka["shukka_addid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."一部出荷 ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //在庫データ更新 $strsql = "UPDATE `".$company."stockdata` SET nonreserveqty = 0 ,validflg = 0 WHERE lotnum = '".$stockdata[0][1]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."一部出荷 ".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } if($datashukka["futeikan"] == 0) { //データ補完（価格定貫） $strsql = "UPDATE `".$company."shukka_add` SET price_total = floor(price_piece * shukkaqty),price_total2 = floor(price_piece2 * shukkaqty) WHERE shukka_addid ='".$datashukka["shukka_addid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } else { //データ補完（価格不定貫） $strsql = "UPDATE `".$company."shukka_add` SET price_total = floor(price_piece * totalgram),price_total2 = floor(price_piece2 * totalgram) WHERE shukka_addid ='".$datashukka["shukka_addid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } //出荷データ作成 /* $strsql = "INSERT INTO `".$company."shukka` (lotnum,shomi,stockdate,`shukkaqty`, `operatedate`, `shukkadate`, `deliverdate`, `shozokuid`, `brand`, `supplyerid`, `shohincd`, `centerid`, `picktimes`, `DC_TC`, `price_piece`, `price_total`, `price_piece2`, `price_total2`, `cominprice_piece`,`totalgram`, `creater`, `createdate`, `updater`, `updatedate`) SELECT lotnum,shomi,stockdate,`shukkaqty`, `operatedate`, `operatedate`, `deliverdate`, `shozokuid`, `brand`, `supplyerid`, `shohincd`, `centerid`, `picktimes`, `DC_TC`, `price_piece`, `price_total`, `price_piece2`, `price_total2`, `cominprice_piece`,`totalgram`, `creater`, `createdate`, '".$userdata["tid"]."', now() FROM `".$company."shukka_add` WHERE shukka_addid ='".$datashukka["shukka_addid"]."'"; $result=mysql_query($strsql,$my_con); Testecho (__LINE__."ROW=".mysql_affected_rows()." ".$strsql); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);*/ $i = 0; $InputValues = array(array(),array()); // $InputValues[$i]["shukkaid"] = "shukkaid";//出荷LOTが割れた場合追加できない $InputValues[$i]["operatedate"] = "operatedate"; $InputValues[$i]["shukkadate"] = "shukkadate"; $InputValues[$i]["deliverdate"] = "deliverdate"; $InputValues[$i]["shohincd"] = "shohincd"; $InputValues[$i]["shozokuid"] = "shozokuid"; $InputValues[$i]["shukkaqty"] = "shukkaqty"; $InputValues[$i]["totalgram"] = "totalgram"; $InputValues[$i]["price_piece"] = "price_piece"; $InputValues[$i]["price_piece2"] = "price_piece2"; $InputValues[$i]["price_piece3"] = "price_piece3"; $InputValues[$i]["price_total"] = "price_total"; $InputValues[$i]["price_total2"] = "price_total2"; $InputValues[$i]["price_total3"] = "price_total3"; $InputValues[$i]["memo"] = "memo"; $InputValues[$i]["memo2"] = "memo2"; $InputValues[$i]["memo3"] = "memo3"; $InputValues[$i]["memo4"] = "memo4"; $InputValues[$i]["memoadd"] = "memoadd"; $InputValues[$i]["rep_id"] = "rep_id"; $InputValues[$i]["rep_id_line"] = "rep_id_line"; $InputValues[$i]["orderid"] = "orderid"; $InputValues[$i]["ordermainid"] = "ordermainid"; $InputValues[$i]["supplyerid"] = "supplyerid"; $InputValues[$i]["comeinid"] = "comeinid"; $InputValues[$i]["DC_TC"] = "DC_TC"; $InputValues[$i]["lotnum"] = "lotnum"; $InputValues[$i]["cominprice_piece"] = "cominprice_piece"; $InputValues[$i]["stockdate"] = "stockdate"; $InputValues[$i]["shomi"] = "shomi"; $InputValues[$i]["loccode"] = "loccode"; $InputValues[$i]["centerid"] = "centerid"; $InputValues[$i]["brand"] = "brand"; $InputValues[$i]["picktimes"] = "picktimes"; $InputValues[$i]["deliveryid"] = "deliveryid"; $InputValues[$i]["route"] = "route"; $InputValues[$i]["gyotaiid"] = "gyotaiid"; $strInsertTable = "`".$company."shukka`"; $strSelectTable = "`".$company."shukka_add` where shukka_addid ='".$datashukka["shukka_addid"]."'"; $introw = InsertSelectSQL($InputValues,$strInsertTable,$strSelectTable,1,1,__LINE__,1); } //以下テスト if($k > 40) { break; } if($k > 40) { $zanshukkaflg = 1; } } } ?>