"") { 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($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 //魚カテゴリー if($userdata["roleid"] == 8 ) { $codedata107 = dbselect("cname,code","`".$company."code`","codekind = 108 and code > 0","code",-1); } else { $codedata107 = dbselect("cname,code","`".$company."code`","codekind = 107 and code > 0","code",-1); } if($userdata["companyid"] == "katsusen"){ $codedata107 = dbselect("cname,code","`".$company."code`","codekind = 109 and code > 0","code",-1); } //オプション $codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104","codeid",-1); //二重更新防止 $wpostcheck = dbselect("count(ordercartid)","`".$company."ordercart`","shozokuid= '".$userdata[shozokuid]."' and createdate > (NOW() - INTERVAL 4 SECOND)",-1,-1); Testecho($strsqldbselect); if ($wpostcheck[0][0] > 0) { $wpostflg = 1; //更新禁止 Testecho("更新禁止"); } else { $wpostflg = 0; } 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,sm.shohin_kubun5,concat('1',shohin_midint1,shohin_midint2,shohin_midint3,shohin_midint4,shohin_midint5) as optionflg","`".$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 ("strdetailshohin=".$strsqldbselect); $strdetailshohinprice = dbselect("nohinprice","`".$company."shozokushohin`","shozokuid= '".$userdata[shozokuid]."' and shohincd = '".$strshohicd."'",-1,-1); 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())"; if($wpostflg == 0) { $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]; } } } } } if($_GET["word"] <> "") { //50音検索 $recodata = dbselect("shohinmei,sm.shohincd,shohinmei2,nohinprice,shohin_string1,kikaku,stockoutflg,shohin_string2,shohin_string5,sum(cart.cartqty),cart.fishoption,cart.ordercartid,sm.shohin_kubun5,concat('1',shohin_midint1,shohin_midint2,shohin_midint3,shohin_midint4,shohin_midint5) as optionflg","`".$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 and cart.cartflg = 0),`".$company."shozokushohin` as ss","ss.shozokuid = '".$userdata[shozokuid]."' and ss.shohincd = sm.shohincd and sm.zaiko = 1 and sm.shohinkana like '%".$_GET["word"]."%' GROUP BY shohincd","sm.shohincd",-1);//0:shohinmei/1:sm.shohincd/2:shohinmei2/3:nohinprice/4:shohin_string1/5:kikaku/6:stockoutflg/7:shohin_string2/8:shohin_string5/9:cart.cartqty/10:cart.fishoption/11:cart.ordercartid/ } else { //お勧め品 $recodata = dbselect("shohinmei,sm.shohincd,shohinmei2,nohinprice,shohin_string1,kikaku,stockoutflg,shohin_string2,shohin_string5,sum(case when cartflg=0 then cart.cartqty else 0 end),cart.fishoption,cart.ordercartid,sm.shohin_kubun5,concat('1',shohin_midint1,shohin_midint2,shohin_midint3,shohin_midint4,shohin_midint5) as optionflg","`".$company."shohinmaster` as sm LEFT JOIN `".$company."ordercart` as cart on (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.shohin_kubun1,sm.shohincd",-1);//0:shohinmei/1:sm.shohincd/2:shohinmei2/3:nohinprice/4:shohin_string1/5:kikaku/6:stockoutflg/7:shohin_string2/8:shohin_string5/9:cart.cartqty/10:cart.fishoption/11:cart.ordercartid/ if($userdata["companyid"] == "ichiko") { $recodata = dbselect("shohinmei,sm.shohincd,shohinmei2,nohinprice,shohin_string1,kikaku,stockoutflg,shohin_string2,shohin_string5,sum(case when cartflg=0 then cart.cartqty else 0 end),cart.fishoption,cart.ordercartid,sm.shohin_kubun5,concat('1',shohin_midint1,shohin_midint2,shohin_midint3,shohin_midint4,shohin_midint5) as optionflg","`".$company."shohinmaster` as sm LEFT JOIN `".$company."ordercart` as cart on (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 = 99 GROUP BY shohincd","sm.shohincd",-1); } } Testecho("RECODATA1 ".$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]."' and cart.cartflg < 2 "; $strsqlorder="($strsqlorder) AS oc"; //SELECT項目 $strsqlselsect = "sm.shohincd,sm.shohinmei,sm.shohinkana,sm.searchword,sm.kikaku,sm.shohinmei2,sm.shohin_kubun5,concat('1',shohin_midint1,shohin_midint2,shohin_midint3,shohin_midint4,shohin_midint5) as optionflg,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["catreq"] == "all") { } elseif ($_POST["catreq"] <> "") { $strcat = $_POST["catreq"]; if($userdata["roleid"] == 8 ) { $strsqlreq = " AND shohin_kubun1 ='".$strcat."' "; } else { $strsqlreq = " AND category ='".$strcat."' "; } } elseif ($_POST["category"] == "") { $strsqlwhere = ""; } else { $strcat = $_POST["category"]; if($userdata["roleid"] == 8 ) { $strsqlwhere = " shohin_kubun1 ='".$strcat."' and "; } else { $strsqlwhere = " category ='".$strcat."' and "; } } if($strshohicd <> "") { $strsqlwhere .= " sm.shohincd <>'".$strshohicd."' and "; } else { } if (($_POST["category"] == "") or ($_GET["top"] == "20")) { $strsqllimit = " limit 300"; } else { } //検索時 if(trim($_POST["searchword"].$_POST["search"]) <> "") { $strsqlwhere = " searchword like '%".trim($_POST["searchword"])."%' and "; $strcat = "all"; $strsqlreq =""; } //活鮮のみ商品カテゴリ変更　いい方法を模索すること if($userdata["companyid"] == "katsusen"){ $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]."' $strsqlreq and ss.shohincd = sm.shohincd and sm.zaiko =1 GROUP BY sm.shohincd ORDER BY sm.poplevel,sm.shohinkana,sm.shohincd $strsqllimit"; } 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]."' $strsqlreq and ss.shohincd = sm.shohincd and sm.zaiko =1 GROUP BY sm.shohincd ORDER BY ss.poplevel2 desc,sm.shohinkana,sm.shohincd $strsqllimit"; } Testecho("LIST表示　". $strsql2); $result=@mysql_query($strsql2,$my_con); $row=@mysql_num_rows($result); //カートの情報取得（カート内分、発注確定分） //$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.shozokuid= '".$userdata[shozokuid]."' ",-1,1); $cartdata["cart"] = dbselect("count(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 is null or cart.operatedate >=DATE_ADD(CURDATE(),INTERVAL $intstartday 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); $cartdata["kakutei"] = dbselect("count(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 $intstartday 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); } } ?>
" method="post" name="sw" target="_top" style="margin: 0px;" onSubmit="buttonAlldisabled();document.sw.submit();"> "") or ($_GET["50on"] <> "")) { ?>
"Y") { ?>
本日の市場
"") { //表示ブランドがある場合、表示ブランドのお知らせしか出さない $strsqlbrand = "and (brand like '%".$userdata["brand"]."%' or brand is null or brand ='')"; } $strsql4 = "select yusen,memo,memotitle,id.createdate,'',hname,honbuflg from informationdata as id LEFT JOIN honbumaster as hm on id.honbuid = hm.honbuid where (flg=1 and limitdate>=curdate() and startdate<=curdate() and id.honbuid='".$userdata["honbuid"]."') $strsqlbrand order by yusen,infonum desc"; $resultq=@mysql_query($strsql4,$my_con); $row=@mysql_num_rows($resultq); mysql_sql_log2($strsql4,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=0; if($row > 0) { while ($data=@mysql_fetch_array($resultq)) { 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/12.shohin_kubun5(端数） //id0:shohincd 1:cartqty 2:option 3:詳細表示指定 4:cartid if($_GET["word"] == "") { ?>
本日のおすすめ品
".$recodata[$pi][0]."
\n"; ?> \n"; } $j++; } ?>

円
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); if(($intwidth == 0) or ($intheight == 0)){$intwidth = 248;$intheight = 105;$strdetailshohin[$pi][4] = "noimage.jpg";} //ファイルが無い時 $intheight = round($intheight * $intimg_size / $intwidth); ?>
 

円
0) {echo "".$strdetailshohin[0][9].$strdetailshohin[0][5]."選択済み
";} ?> 数量 本日取り扱い無し
 
0) or ($_POST["category"] <> "") or ($_GET["top"] <> "")) { ?>
【 "") or ($_POST["category"] == "")){echo $userdata["shozokuname"]." ご注文実績順";} ?>】商品一覧 　 " size = "7" style="font-size:16px;color blue;background-color: #fffacd;" >
"") { $addmessage = "【".$_POST["searchword"]."】での検索では、"; } echo ""; }?>
";} ?>  円 0) {echo "".$data[cartqty].$data[kikaku]."選択済み";} // ?> 本日入荷無し
"; PrintMsg("",$addmessage."該当商品がありません。",450); echo "
50音キーワード検索　（鮮魚）検索【】
\n\n
'' and shohin_kubun1 <> 30 group by shohinkana order by shohinkana"; $result=@mysql_query($strsql50,$my_con); $row=@mysql_num_rows($result); $z = 1;$i=0; while ($data=@mysql_fetch_array($result)) { $strword = mb_substr(mb_convert_kana($data["shohinkana"],"k"),0,1);//20151001並び順修正 if($strword <> $strwordold ) { if($i > floor($row / 4)) { echo "\n"; $i = 0; } echo "
".mb_convert_kana($strword,"K")."------------------
"; } ?>・">
50音キーワード検索　（野菜）検索【】
'' and shohin_kubun1 in(30) group by shohinkana order by shohinkana"; $result=@mysql_query($strsql50,$my_con); $row=@mysql_num_rows($result); $z = 1;$i=0; while ($data=@mysql_fetch_array($result)) { $strword = mb_substr(mb_convert_kana($data["shohinkana"],"k"),0,1); if($strword <> $strwordold ) { if($i > floor($row / 4)) { echo "\n"; $i = 0; } echo "
".mb_convert_kana($strword,"K")."------------------
"; } ?>・">
 

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