<?php
//仮引当取消処理
FunctionUseCheck2();

//引当日の指定
$excutedate = "DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)";
$excutedate2 = "DATE_ADD(CURDATE(),INTERVAL ".($operatedate + 1)." DAY)";
$excutedate_old = "DATE_ADD(CURDATE(),INTERVAL ".($operatedate - 4)." DAY)";

$strsqlwhere = "main.operatedate = ".$excutedate." and main.centerid='".$centerid."' and main.gyotaiid='".$_POST[gyotai]."'";
$strsqlwhere2 = "operatedate = ".$excutedate." and centerid='".$centerid."' and gyotaiid = '".$_POST[gyotai]."'";
$strsqlwhere2b = "operatedate = ".$excutedate." and a.centerid='".$centerid."' and a.gyotaiid = '".$_POST[gyotai]."' AND sho.picktimes = '".$_POST[picktimes]."' ";
$strsqlwhere3 = "operatedate = ".$excutedate." and gyotaiid = '".$_POST[gyotai]."'";

//ピック回数のデータ
$pickshozoku = dbselect("1,shozokuid,picktimes","`".$company."shozokumaster`","gyotaiid = '".$_POST[gyotai]."'",-1,-1);

//ゴミの受注情報を確定
$strsql="UPDATE `".$company."ordermain` set checkedflg = 7 ,updater ='SYS5901' WHERE checkedflg < 5 and operatedate between DATE_ADD(CURDATE(),INTERVAL -15 DAY) and ".$excutedate_old."";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

$strsql= "UPDATE `".$company."status` SET status = 7,hikiateqty = 0  WHERE operatedate < DATE_ADD(CURDATE(),INTERVAL -7 DAY)";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//出荷データを更新する
$strsql="UPDATE `".$company."shukka` as shu, `".$company."shohinmaster` as sm SET DC_TC = 2 WHERE shu.shohincd = sm.shohincd AND sm.ryutu_type = 2 AND shu.picktimes = '".$_POST[picktimes]."' and shu.operatedate = ".$excutedate." and shu.centerid='".$centerid."' and shu.gyotaiid = '".$_POST[gyotai]."'";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//欠品データを取り消し
$strsql="DELETE FROM `".$company."keppin` WHERE picktimes = '".$_POST[picktimes]."' and ".$strsqlwhere2;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//出荷データを取り消し
$strsql="DELETE FROM `".$company."shukka` WHERE DC_TC = 0 AND picktimes = '".$_POST[picktimes]."' and ".$strsqlwhere2;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//出荷実績データを取り消し
$strsql="DELETE FROM `".$company."shukkafix` WHERE DC_TC = 0 AND picktimes = '".$_POST[picktimes]."' and ".$strsqlwhere2;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//出荷配送データを取り消し
$strsql="DELETE FROM `".$company."shukka_box` WHERE DC_TC = 1 AND picktimes = '".$_POST[picktimes]."' and ".$strsqlwhere2;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//直送データを取り消し
$strsql="DELETE FROM `".$company."directsupply` WHERE ".$strsqlwhere2;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//直送データを取り消し
$strsql="DELETE FROM `".$company."orderdirect` WHERE ".$strsqlwhere3;
//$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//有効在庫をもどす  
$strsql="UPDATE `".$company."stockdata` set nonreserveqty = stockqty + arrangeqty WHERE centerid = '".$centerid."'";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//受注情報をもどす
$strsql="UPDATE `".$company."ordermain` as a,`".$company."shozokumaster` as sho set a.checkedflg = 1 WHERE a.shozokuid = sho.shozokuid and ".$strsqlwhere2b;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//受注明細情報をもどす
$strsql="UPDATE `".$company."ordersheet` as os, `".$company."ordermain` as a,`".$company."shozokumaster` as sho,`".$company."shohinmaster` as sm set os.kariflg = 0 ,os.karihikiate2 = 0,os.memo2 = null WHERE os.shohincd = sm.shohincd and a.shozokuid = sho.shozokuid and ".$strsqlwhere2b." and a.ordermainid = os.ordermainid and a.checkedflg = 1 and sm.ryutu_type = 1";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//ステータスをもどす
$strsql= "UPDATE `".$company."status` SET hikiateqty = null,keppinqty = null, keppinfixqty = null,status = 1  WHERE statusid='".$_POST[id]."'";
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho ("仮引当取消し処理がステータスデータに実施されました。".$errcode." ".$strsql."\n<br>");  #debug

//受注明細FLG更新
$strsql = "UPDATE `".$company."ordermain` as main ,`".$company."ordersheet` as sheet,`".$company."shohinmaster` AS sm SET sheet.orderid_flg = 11 WHERE main.ordermainid = sheet.ordermainid and sm.shohincd = sheet.shohincd and main.gyotaiid='".$_POST[gyotai]."' and main.centerid='".$centerid."' and main.operatedate =".$excutedate ;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$y." ".$strsql);  //debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho ("発注締めが受注明細データに実施されました。".$errcode." ".$strsql."\n<br>");  #debug

?>