"") { Logout(); } //echo "SID: ".SID."
session_id(): ".session_id()."
COOKIE: ".$_COOKIE["PHPSESSID"]; switch ($_GET[testmode]) { case "1": setcookie("testmode","1",time()+7200); //テストモード開始 $_SESSION[testmode] = 1; //テストモード開始 break; case "2": setcookie("testmode"); //テストモード終了 $_SESSION[testmode] = 2; //テストモード break; } myopen(); //再チェック SecurityCheck(); FunctionUseCheck2(); if ((int)$settingdata["order_open"] == 0) { include "6407.php"; exit; } if($userdata[roleid] == "") { echo ""; echo ""; title(); echo ""; echo ""; Logout(); echo "ログアウトします。
同一IDを同時に使用した、または、利用できない領域を参照しました。
このままお待ちください。"; echo "not available "; echo $_SERVER['SCRIPT_NAME'].$test[2]; var_dump($userdata); echo ""; echo ""; exit; } if (($userdata["kengen"] <= 20) and ($_POST[phonbu] <> "")) { $honbu = $_POST[phonbu]; } else { $honbu = $userdata["honbuid"]; } //出荷作業日の特定 if($userdata["hacchutime"] == 0) { //00:00は必ず当日 $operatedate = 1; } elseif($userdata["hacchutime"] <= (int)date("Gi")) { //締め時間を過ぎている時は翌日 $operatedate = 1; } else { //締め時間前は当日 $operatedate = 0; } $honbudata = dbselect("hname,hlogo,nohinweek","honbumaster","honbuid=".$honbu,-1,-1);//本部データを入れる PostData(); Testecho( "本部コード:".$userdata["honbuid"]);//debug //魚カテゴリー $codedata107 = dbselect("cname,code","`".$company."code`","codekind = 107 and code > 0","code",-1); //オプション $codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104","codeid",-1); For ($y=0;$y < (int)$_POST[totalnum];$y++) { //echo "aaaa $y aaaaaa".$_POST[totalnum]; //var_dump($_POST{"id".$y});//0=shohincd,1=qty,2=option,3=詳細表示,4=cartid,5=カートに入れる if ($_POST{"id".$y}[0] == "") {} else { //数量がない場合スルー $intqty = (int)$_POST{"id".$y}[1]; if ($_POST{"id".$y}[3] <> "") { //詳細表示 $strshohicd = $_POST{"id".$y}[0]; $strdetailshohin = dbselect("shohinmei,sm.shohincd,shohinmei2,price_sell,shohin_string1,kikaku,stockoutflg,shohin_string2,shohin_string5,sum(cart.cartqty),cart.fishoption,cart.ordercartid","`".$company."shohinmaster` as sm LEFT JOIN `".$company."ordercart` as cart on (cart.operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.shozokuid= '".$userdata[shozokuid]."' and sm.shohincd = cart.shohincd )","sm.shohincd = '".$strshohicd."' GROUP BY shohincd","sm.shohincd",-1);//0:shohinmei/1:sm.shohincd/2:shohinmei2/3:price_sell/4:shohin_string1/5:kikaku/6:stockoutflg/7:shohin_string2/8:shohin_string5/9:cart.cartqty/10:cart.fishoption/11:cart.ordercartid/ Testecho ($strsqldbselect); } else { //カート更新 if ($_POST[update] <> ""){ if ($_POST{"id".$y}[1] >= 0.5) { $strsql = "INSERT INTO `".$company."ordercart` (shozokuid, shohincd,centerid,gyotaiid,inputdate,operatedate,cartqty,memo,fishoption,creater,createdate) values ('".$userdata["shozokuid"]."','".$_POST{"id".$y}[0]."','".$centerdata[0][1]."','".$userdata["gyotaiid"]."',CURDATE(),DATE_ADD(CURDATE(),INTERVAL $operatedate DAY),'".Numchecker2($_POST{"id".$y}[1])."','".$memo."','".$_POST{"id".$y}[2]."','".$userdata["tid"]."',now())"; $result=mysql_query($strsql,$my_con); $errcode =mysql_errno();if ($errcode==0) $okcount++; mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($strsql); } elseif (($_POST{"id".$y}[1] < 0.5) and ($_POST{"id".$y}[1] > 0) ) { $errcount++; $errmsg .="半身は0.5単位で入力してください。入力値：".$_POST{"id".$y}[1]; } } } } } //お勧め品 $recodata = dbselect("shohinmei,sm.shohincd,shohinmei2,nohinprice,shohin_string1,kikaku,stockoutflg,shohin_string2,shohin_string5,sum(cart.cartqty),cart.fishoption,cart.ordercartid","`".$company."shohinmaster` as sm LEFT JOIN `".$company."ordercart` as cart on (cart.operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.shozokuid= '".$userdata[shozokuid]."' and sm.shohincd = cart.shohincd ),`".$company."shozokushohin` as ss","ss.shozokuid = '".$userdata[shozokuid]."' and ss.shohincd = sm.shohincd and sm.zaiko = 1 and sm.shohin_kubun2 = 1 GROUP BY shohincd","sm.shohincd",-1);//0:shohinmei/1:sm.shohincd/2:shohinmei2/3:price_sell/4:shohin_string1/5:kikaku/6:stockoutflg/7:shohin_string2/8:shohin_string5/9:cart.cartqty/10:cart.fishoption/11:cart.ordercartid/ Testecho ($strsqldbselect); //受注カートデータ $strsqlorder="SELECT cart.ordercartid,cart.shohincd,cart.cartqty,cart.cartflg,cart.operatedate,cart.fishoption FROM `".$company."ordercart` AS cart WHERE cart.operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.shozokuid='".$userdata[shozokuid]."' "; $strsqlorder="($strsqlorder) AS oc"; //SELECT項目 $strsqlselsect = "sm.shohincd,sm.shohinmei,sm.searchword,sm.kikaku,sm.shohinmei2,ss.nohinprice,price_sell,sm.irisuu,sm.aisuu,sm.shohin_string2,sm.juryo,sum(oc.cartqty) as cartqty,sm.zaiko,oc.cartflg,sm.sell_end_date,sm.kikaku,oc.ordercartid,TO_DAYS(DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)) - TO_DAYS(sm.sell_end_date) as 'nouhincheck',oc.operatedate,sm.poplevel,sm.stockoutflg,sm.stockout_comein_date,sm.stockout_memo,sm.shohin_kubun2,sm.ryutu_type,oc.fishoption"; //商品マスタと受注のJOIN指定 $strsqljoin1 = "sm.shohincd = oc.shohincd $strsqljoin"; $strsqlall="LEFT JOIN"; //商品マスタをメインに、サプライヤーマスタ内部接続、発注カートテーブル外部接続で、発注日が指定日のリストを取り出す if ($_POST["category"] == "") { $strsqlwhere = ""; } else { $strsqlwhere = " category ='".$_POST["category"]."' and "; } if($strshohicd <> "") { $strsqlwhere .= " sm.shohincd <>'".$strshohicd."' and "; } else { } if (($_POST["category"] == "") or ($_GET["top"] == "20")) { $strsqllimit = " limit 100"; } else { } $strsql2 = "SELECT $strsqlselsect FROM `".$company."shohinmaster` AS sm $strsqlall $strsqlorder ON sm.shohincd = oc.shohincd, `".$company."shozokushohin` AS ss WHERE $strsqlwhere ss.shozokuid = '".$userdata[shozokuid]."' and ss.shohincd = sm.shohincd and sm.zaiko GROUP BY sm.shohincd ORDER BY ss.poplevel2 desc,sm.shohincd $strsqllimit"; Testecho( $strsql2); //カートの情報取得（カート内分、発注確定分） $cartdata["cart"] = dbselect("count(distinct(cart.ordercartid)),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 cartflg = 0 and ss.shohincd = cart.shohincd and cart.operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.shozokuid= '".$userdata[shozokuid]."' ",-1,1); Testecho($strsqldbselect); $cartdata["kakutei"] = dbselect("count(distinct(cart.ordercartid)),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 cartflg >= 1 and ss.shohincd = cart.shohincd and cart.operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and cart.shozokuid= '".$userdata[shozokuid]."'",-1,1); Testecho($strsqldbselect); //var_dump($cartdata); ?> 鮮魚発注システム
0) {echo "(".$cartdata["cart"][0][0]."点)"; } ?>" class="margin50" > 0) {echo "(".$cartdata["kakutei"][0][0]."点)"; } ?>"class="margin50" >
0) { if ($okcount > 0 ){ PrintMsg("","$okcount 件を追加しました。",450); } if ($errcount > 0 ){ PrintMsg(" $errcount 件追加できませんでした。
$errmsg","",700); } } ?>  
本日の市場
=curdate() and startdate<=curdate() and id.honbuid='".$userdata["honbuid"]."') order by yusen,infonum desc"; $result=@mysql_query($strsql4,$my_con); $row=@mysql_num_rows($result); mysql_sql_log2($strsql4,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=0; if($row > 0) { while ($data=@mysql_fetch_array($result)) { echo "
".nl2br(htmlspecialchars($data["memo"]))."
"; } } //0:shohinmei/1:sm.shohincd/2:shohinmei2/3:price_sell/4:shohin_string1/5:kikaku/6:stockoutflg/7:shohin_string2/8:shohin_string5/9:cart.cartqty/10:cart.fishoption/11:cart.ordercartid/ //id0:shohincd 1:cartqty 2:option 3:詳細表示指定 4:cartid //ブロックA　本日のおすすめ品 ?>
本日のおすすめ品
".$recodata[$pi][0]."
\n"; ?> \n"; } $j++; } ?>

1円
0) {echo "".$recodata[$pi][9].$recodata[$pi][5]."選択済み
";} ?>

本日取り扱い無し
0) {//詳細表示 $intimg_size = 400; //幅をintimg_sizeで固定し、高さを比率で縮尺させる。少数点はROUND $strimageurl = $imagebase.$imagehtml.$strdetailshohin[0][4]; list($intwidth,$intheight)=getimagesize($strimageurl); $intheight = round($intheight * $intimg_size / $intwidth); ?>

1円
0) {echo "".$strdetailshohin[0][9].$strdetailshohin[0][5]."選択済み
";} ?> 数量 本日取り扱い無し
  0) or ($_POST["category"] <> "") or ($_GET["top"] <> "")) { ?>
【 "") or ($_POST["category"] == "")){echo $userdata["shozokuname"]." ご注文実績順";} ?>】商品一覧
"; PrintMsg("","ただいま該当商品がありません",450); echo ""; }?>
1 円 0) {echo "".$data[cartqty].$data[kikaku]."選択済み";} // ?> 本日入荷無し
 

▲このページの先頭へ [TEST MODE OFF] [TEST MODE ON]