<?php
// 共通の設定を読み込む
require_once("../conf/iniset.inc");
require_once("cmnitem.inc");
require_once("cmnitem01.inc");
require_once("cmnitem02.inc");
require_once("cmnsubitem.inc");
require_once("cmnsubitem01.inc");
require_once("cmnsubitem02.inc");

// Smartyオブジェクト取得
$smarty = & getSmartyObj();

// MySQLコネクションオープン
mysql_open($cn);

//情報を更新する
$post    = GetGetHtmlData();
$search  = $post['s'];

$strWhere = " 1 = 1 ";
if ($search["etc"] <> ""){
	$quick = trim($search["etc"]);
	$strWhere .= " and ";
	$strWhere .= " ( `itemName` like '%" . $quick . "%' ";
	$strWhere .= " or `itemName` like '%" . mb_convert_kana($quick,"aKCV") . "%' ";
	$strWhere .= " or UPPER(`itemCode`) like '%" . strtoupper($quick) . "%' ";
	$strWhere .= " or `comment` like '%" . $quick . "%' ";
	$strWhere .= " or `comment` like '%" . mb_convert_kana($quick,"aKCV") . "%' "; 
	$strWhere .= " or `option` like '%" . $quick . "%' ";
	$strWhere .= " or `option` like '%" . mb_convert_kana($quick,"aKCV") . "%' "; 
	$strWhere .= " ) ";
}

if ($search["category"] <> ""){
	$strWhere .= " and category = '" . $search["category"] . "' ";
}

$strOrder = " sortNumber, itemName, itemCode ";

$_GET["lang"] = "jp";
$_COOKIE["lang"] = "jp";

if ( $_GET["lang"] == "en" ){
	$lang = "en";
	setcookie("lang", "en");
	setcookie("lang", "en", time()+60*60*24*7*30*12);  /* 有効期限は約1年です */
	setcookie("lang", "en", time()+60*60*24*7*30*12, BASE_URL);  /* 有効期限は約1年です */
}
else if ( $_GET["lang"] == "cn" ){
	$lang = "cn";
	setcookie("lang", "cn");
	setcookie("lang", "cn", time()+60*60*24*7*30*12);  /* 有効期限は約1年です */
	setcookie("lang", "cn", time()+60*60*24*7*30*12, BASE_URL);  /* 有効期限は約1年です */
}
else if ( $_COOKIE["lang"] == "en" ){
	$lang = "en";
}
else if ( $_COOKIE["lang"] == "cn" ){
	$lang = "cn";
}
else {
	$lang = "";
}

//ページングの設定
$sql = "select * from oj_item where " . $strWhere;
if (!($rs = mysql_query($sql, $cn))) {
	die("itemlistページング取得エラー$sql");
}
// MySQL レコード数
$resultNum = mysql_num_rows($rs);

if ( trim($_GET['p']) <> "" ){
	$nowPage = trim($_GET['p']);
}
else if ( trim($_POST['p']) <> "" ){
	$nowPage = trim($_POST['p']);
}
else {
	$nowPage = 0;
}
$paging = GetPaging($resultNum, $nowPage);

if ( trim($nowPage) <> "" ){
	$p = intval($nowPage) * LIST_PAGING;
	$strOrder = " sortNumber, itemName, itemCode LIMIT $p, " . LIST_PAGING;
}
else {
	$strOrder = " sortNumber, itemName, itemCode LIMIT 0, " . LIST_PAGING;
}


if ( $lang == "en" ){
	GetItem01GroupList($itemList, $strWhere, $strOrder, $cn, TRUE);
	GetNameList("enseries1", $seriesListCode, $seriesListName, $cn, TRUE, "");
	$seriesListName = $seriesListCode;

	$seriesList[""][""] = "シリーズを選択";
	for ($i=0;$i<count($seriesListCode);$i++){
		$seriesList["FootSwitch"][$seriesListCode[$i]] = $seriesListCode[$i] . "series　" . $seriesListName[$i];
	}
	unset($seriesListCode);
	unset($seriesListName);
	GetNameList("enseries2", $seriesListCode, $seriesListName, $cn, TRUE, "");
	for ($i=0; $i< count($seriesListCode);$i++){
		$seriesList["Tape&MatSwitch"][$seriesListCode[$i]] = $seriesListCode[$i]."".$seriesListName[$i];
	}
	$templateTitle = "Item List";
}
else if ( $lang == "cn" ){
	GetItem02GroupList($itemList, $strWhere, $strOrder, $cn, TRUE);
	GetNameList("cnseries1", $seriesListCode, $seriesListName, $cn, TRUE, "");
	$seriesListName = $seriesListCode;

	$seriesList[""][""] = "シリーズを選択";
	for ($i=0;$i<count($seriesListCode);$i++){
		$seriesList["脚踏开关"][$seriesListCode[$i]] = $seriesListCode[$i] . "系列　" . $seriesListName[$i];
	}
	unset($seriesListCode);
	unset($seriesListName);
	GetNameList("cnseries2", $seriesListCode, $seriesListName, $cn, TRUE, "");
	for ($i=0; $i< count($seriesListCode);$i++){
		$seriesList["脚踏开关"][$seriesListCode[$i]] = $seriesListCode[$i]."".$seriesListName[$i];
	}
	$templateTitle = "商品一覧";
}
else {
	GetItemGroupList($itemList, $strWhere, $strOrder, $cn, TRUE);
	GetNameList("series1", $seriesListCode, $seriesListName, $cn, TRUE, "");

	$seriesList[""][""] = "シリーズを選択";
	for ($i=0;$i<count($seriesListCode);$i++){
		$seriesList["フットスイッチ"][$seriesListCode[$i]] = $seriesListCode[$i] . "シリーズ　" . $seriesListName[$i];
	}
	unset($seriesListCode);
	unset($seriesListName);
	GetNameList("series2", $seriesListCode, $seriesListName, $cn, TRUE, "");
	for ($i=0; $i< count($seriesListCode);$i++){
		$seriesList["テープ＆マットスイッチ"][$seriesListCode[$i]] = $seriesListCode[$i]."".$seriesListName[$i];
	}
	$templateTitle = "商品一覧";
}

//var_dump($itemList);

//var_dump($seriesList);
mysql_close($cn);

// ページを表示する
$templateCss   = "database.css";
$bodyId        = "results";

$smarty->assign( 'p'          , $p);
$smarty->assign( 'lang'       , $lang);
$smarty->assign( 'paging'     , $paging);
$smarty->assign( 'itemList'   , $itemList);
$smarty->assign( 'search'     , $search);
$smarty->assign( 'seriesList' , $seriesList);
$smarty->assign( "scriptName" , "scriptitem.js");

// 固定設定
$smarty->assign( 'bodyId', "$bodyId");
$tmp = explode("/",$_SERVER['REQUEST_URI']);
$homepage = $tmp[count($tmp)-1];
$smarty->assign( 'homepage'   , "$homepage");
$smarty->assign( 'message'    , "$message");

$templateName  = basename(dirname($_SERVER['PHP_SELF'])) . basename(__FILE__, ".html").".tpl";
$smarty->assign( "templateCss"  , "$templateCss");
$smarty->assign( "templateTitle", "$templateTitle");
$smarty->assign( "templateName" , "$templateName");
$smarty->display( 'base.tpl' );
?>