include $DOCUMENT_ROOT."/form_begin.php";
if($state >= 0) {
if(!$orname && !$orsun) $order = " order by updatetime desc";
else $order = " order by $orname $orsun";
if($menu=="index") {
$result = $dalib->selectSQLAll("select * from $Table[Product] where $kind = '1' $order");
$rnumPN = $result[rnum];
}elseif($menu=="search") {
$result = $dalib->selectSQLAll("select * from $Table[Product] where pname like '%$search%' or pcompany like '%$search%' $order");
$rnumPN = $result[rnum];
}else {
$result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and smcate = '$smcate' $order");
$rnumPN = $result[rnum];
}
if($mode=="prev") {
@mysql_data_seek($result[result],$state);
$r_prev = mysql_fetch_array($result[result]);
$pcode = $r_prev[pcode];
}elseif($mode=="next") {
@mysql_data_seek($result[result],$state);
$r_next = @mysql_fetch_array($result[result]);
$pcode = $r_next[pcode];
}
$prev_state = $state - 1;
$next_state = $state + 1;
}
$r = $dalib->selectSQLField("select bigcatename from $Table[Bigcategory] where bigcate ='$bigcate'");
$r2 = $dalib->selectSQLField("select smcatename from $Table[Smcategory] where smcate ='$smcate'");
$bigcatename = $r[bigcatename];
$smcatename = $r2[smcatename];
if($smcatename=="") $smcatenameTitle = $r2[smcatename];
else $smcatenameTitle = $smcatename;
$r = $dalib->selectSQLField("select * from $Table[Product] where pcode = '$pcode'");
$pname = stripslashes($r[pname]);
$pcompany = stripslashes($r[pcompany]);
$pbuylimit = stripslashes($r[pbuylimit]);
if(trim($r[pro_option]) != "") {
$pro_option = stripslashes($r[pro_option]);
$pro_option = split("#",$pro_option);
}
# »óǰÄڵ尡 À߸øµÇ¾ú°Å³ª »óǰÀÌ µðºñ³»¿ë¿¡ ¾øÀ»°æ¿ì
if($r[srlno]=="") $fulib->alertBack("À߸øµÈ »óǰÄÚµåÀ̰ųª ÇöÀç ¼ºñ½ºÇÏÁö ¾Ê´Â »óǰÀÔ´Ï´Ù.");
if($r[stock_amount] < 1) $STOCK_IMG = "";
if($r[html] == "0") {
$pcontents = str_replace(" "," ",$r[pcontents]) ;
$pcontents = nl2br(stripslashes($pcontents)) ;
}elseif($r[html] =="1") {
$pcontents = stripslashes($r[pcontents]);
}
$rstock = $dalib->selectSQLField("select * from $Table[ProductStockItemDetail] where pcode = '$pcode' and kind = '1'");
$rstock2 = $dalib->selectSQLField("select * from $Table[ProductStockItemDetail] where pcode = '$pcode' and kind = '2'");
$rstock3 = $dalib->selectSQLField("select * from $Table[ProductStockSetting] where pcode = '$pcode'");
# ¹è¼ÛÁ¤º¸
$r_send = $dalib->selectSQLField("select sendkind, sendcontent from $Table[ManageInfo]");
if($r_send[sendkind] == "0") {
$sendcontent = str_replace(" "," ",$r_send[sendcontent]) ;
$sendcontent = nl2br(stripslashes($sendcontent)) ;
}elseif($r_send[sendkind] =="1") {
$sendcontent = stripslashes($r_send[sendcontent]);
}
# »óǰº° Åë°è
if($r[srlno] != "" and $now != "ad") {
$basedate = date("Ym");
$r_stat_total = $dalib->selectSQLField("select srlno from $Table[ProductStat] where pcode = '$pcode' and basedate = 'total'");
if($r_stat_total[0]=="") {
$insertsql = "insert into $Table[ProductStat] set pcode = '$pcode',
pname = '$pname',
basedate = 'total',
view = '1'";
$dalib->directQuery($insertsql);
}else {
$dalib->directQuery("update $Table[ProductStat] set view = view + 1 where pcode = '$pcode' and basedate = 'total'");
}
$r_stat_view = $dalib->selectSQLField("select srlno from $Table[ProductStat] where pcode = '$pcode' and basedate = '$basedate'");
if($r_stat_view[0]=="") {
$insertsql = "insert into $Table[ProductStat] set pcode = '$pcode',
pname = '$pname',
basedate = '$basedate',
view = '1'";
$dalib->directQuery($insertsql);
}else {
$dalib->directQuery("update $Table[ProductStat] set view = view + 1 where pcode = '$pcode' and basedate = '$basedate'");
}
}
if($mode=="recom") {
if($find=="precom") $PreTitle .= "Ãßõ»óǰ > ";
if($find=="pnew") $PreTitle .= "½Å»óǰ > ";
if($find=="pbest") $PreTitle .= "º£½ºÆ® »óǰ > ";
if($find=="ppopu") $PreTitle .= "Àαâ»óǰ > ";
}elseif($menu=="search") {
$PreTitle .= "'$search' °Ë»ö > ";
}elseif($menu=="symp") {
$PreTitle = "$SYMP_TITLE > ";
}else {
if($bigcatename != "") $PreTitle .= "$bigcatename > ";
if($smcatenameTitle !="") $PreTitle .= "$smcatenameTitle > ";
}
?>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
|