0){
$row = mysql_fetch_array($result);
// mysql_close();
$multypriceno = $row[multypriceno]; //다중단가순번
}
?>
0){
$limit = "limit $count";
} else {
$limit = "limit 1000"; //건수 미선택시 1000건 리밋 제한
}
if( $sename !== ""){
$qryname = " AND name like '%$sename%'";
}
if( $ssize !== ""){
$qrynorm = " AND norm like '%$ssize%'";
}
if( $sbigo !== ""){
$qrybigo = " AND m.bigo like '%$sbigo%'";
}
if( $stotal !==""){
$qrytotal=" and ( m.name like '%$stotal%' or m.code like '%$stotal%' or m.norm like '%$stotal%' or m.bigo like '%$stotal%' )";
}
if( $allcate =="on"){
} else {
if( $cate !==""){
$catenumqry = "SELECT code FROM pclass where fullpath = '$cate'";
$resultcate = mysql_query($catenumqry);
$caterow = mysql_fetch_array($resultcate);
$catenum = $caterow[code];
$qrycate = "AND classcode = '$catenum'";
}
}
if(!$code2 == "") $classcode = "AND classcode = '$code2'"; //옵션포함 조회
if($optcate == "1" AND $optpro == "1"){// 옵션(지정상품&지정카테고리 만 검색)
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype,
p.ccode, p.pcode, p.btype,
c.ccode, c.pccode, c.btype
FROM (((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
INNER JOIN custprodmatch AS p ON(m.code = p.pcode))
INNER JOIN custpclassmatch AS c ON(classcode = c.pccode)
WHERE onlinehidden = 0 AND hidden = 0 AND p.ccode = '$cuscode' AND d.ocode='$sacode' AND p.btype = '1' $classcode $qrycate $qrytotal $qryname $qrynorm $qrybigo order by code $limit";
} else if($optpro == "1"){ // 옵션(지정상품만 검색)
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype,
p.ccode, p.pcode, p.btype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
INNER JOIN custprodmatch AS p ON(m.code = p.pcode)
WHERE onlinehidden = 0 AND hidden = 0 AND p.ccode = '$cuscode' AND d.ocode='$sacode' AND btype = '1' $classcode $qrycate $qrytotal $qryname $qrynorm $qrybigo order by code $limit"; //기본 검색 이름,규격,코드,메모
} else if($optcate == "1"){ // 옵션(지정카테고리만 검색)
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype,
c.ccode, c.pccode, c.btype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
INNER JOIN custpclassmatch AS c ON(classcode = c.pccode)
WHERE onlinehidden = 0 AND hidden = 0 AND c.ccode = '$cuscode' AND d.ocode='$sacode' AND btype = '1' $classcode $qrycate $qrytotal $qryname $qrynorm $qrybigo order by code $limit" ;
} else { //옵션없는 검색
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
WHERE d.ocode='$sacode' AND onlinehidden = 0 AND hidden = 0 $classcode $qrycate $qrytotal $qryname $qrynorm $qrybigo order by code $limit"; //기본 검색 이름,규격,코드,메모
}
} else {
if(!$code2 == "") $classcode = "AND classcode = '$code2'"; //일반조회
if($optpro == "1"){ // 옵션(지정상품만 검색)
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype,
p.ccode, p.pcode, p.btype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
INNER JOIN custprodmatch AS p ON(m.code = p.pcode)
WHERE onlinehidden = 0 AND hidden = 0 AND p.ccode = '$cuscode' AND p.btype = '1' $classcode";
} else if($optcate == "1"){ // 옵션(지정카테고리만 검색) 이미 거르기 때문에없어도 될듯?
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype,
c.ccode, c.pccode, c.btype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
INNER JOIN custpclassmatch AS c ON(classcode = c.pccode)
WHERE onlinehidden = 0 AND hidden = 0 AND c.ccode = '$cuscode' AND d.ocode='$sacode' AND c.btype = '1' $classcode";
} else {
$mqry = "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.onlinestop, m.onlinestopbigo,
d.ocode, d.saleprice, d.buyprice, d.baseprice,
s.amount AS samount, s.sdate, s.edate, s.ccode,
t.pseq, t.price, t.pricetype
FROM ((product_m AS m
INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = 1 AND s.amount != 0 ))
LEFT JOIN multy_price AS t ON (m.code = t.pcode AND t.pseq = '$multypriceno' AND t.part = 1)
WHERE m.onlinehidden = 0 AND m.hidden = 0 AND d.ocode='$sacode' $classcode";
}
}
$resultm = mysql_query($mqry);
// echo $mqry;
?>