$lastpage) { $page=$lastpage; } if ($info_pp_cnt[cocode]=="") { $location = "Location: ".DOMAIN; header($location); exit; } $sql_statement_shop = "select c.cocode, c.coname, c.coaddress from company c inner join company_c9web_region ccr on ccr.cocode=c.cocode and ccr.c9web_region_code='$session_current_c9web_region' where c.cotype='SU' and c.cocode='$su'"; if (!($result_shop = cs_query($sql_statement_shop))) { $sql_error($sql_statement_shop); } $info_shop = cs_fetch_array($result_shop); $sql_statement_pp = "select p.photo1, p.prodcode, p.rand_id, p.brand_name, p.name as product_name, pr.cdate, (select display_name from member where cocode=pr.cuser) as cuser_name, r.name as region_name, cp.coname as supplier_parent_name, c.coname as supplier_coname, cb.coname as supplier_branch_coname, pr.amount, pr.qty, pr.sellprx, pr.coaddress, pr.remark, pcr.monitor_price from product_review pr left outer join region r on r.regioncode=pr.regioncode and r.c9web_region_code='$session_current_c9web_region' left outer join company c on c.cocode=pr.supplier_cocode and c.deleted=0 left outer join company_branch cb on cb.cocode=pr.supplier_branch_cocode and cb.deleted=0 inner join company_parent cp on cp.cocode=c.company_parent_cocode inner join product p on p.prodcode=pr.prodcode inner join product_c9web_region pcr on pcr.prodcode=p.prodcode and pcr.c9web_region_code='$session_current_c9web_region' where pr.c9web_region_code='$session_current_c9web_region' and p.deleted=0 and pr.deleted=0 and pr.pr_type='QUOTE' and pr.supplier_cocode='$su' "; if ($past_quote_days!="all") { $sql_statement_pp .= "and pr.cdate>=(now()- interval'".$past_quote_days." day') "; } $sql_statement_pp .= "order by pr.cdate desc limit "; $sql_statement_pp .= ($pp_row*$pp_col); $sql_statement_pp .= " offset "; $sql_statement_pp .= (($page-1)*$pp_row*$pp_col); if(!($result_pp=cs_query($sql_statement_pp))) sql_error($sql_statement_pp); ?> "; echo ""; echo ""; echo ""; echo ""; echo "
".$info_shop[coname].""; echo ""; echo ""; echo ""; echo "
">商店資料 : 
"; echo "
商店名稱 地址
# "; echo display_pre_content($info_shop[coaddress]); ?> [編輯地址]"; } else { /* if (strlen($info_shop[coaddress])==0) { echo "[加入地址]"; } else { echo "[詳細資料]"; } */ echo "[編輯地址]"; if ($session_usergroup=="AM") { echo "[先前版本]"; } } ?> [".$arr_lang[report_remove]."]"; } else { echo "[".$arr_lang[report_remove]."]"; } ?>
分店名稱 地址
".$cnt."".$info_shop_branch[coname].""; echo display_pre_content($info_shop_branch[coaddress]); ?> "; ?> [編輯地址]"; } else { echo "[編輯地址]"; if ($session_usergroup=="AM" && $info_shop_branch[version]>1) { echo "[先前版本]"; } } ?> [".$arr_lang[report_remove]."]"; } else { echo "[".$arr_lang[report_remove]."]"; } ?>
"; // ---------------------------------------------- // begin: textlink // ---------------------------------------------- $adcode="TLINK"; include APP_PATH."spr/spr_ad_display.php"; // ---------------------------------------------- // end: textlink // ---------------------------------------------- ?>
"; } // end: spefic category top banner ?>
商品格價 : 
"; echo "
=(now()- interval'".$new_days." day') "; $sql_statement_all_quotes .= "and pr.sellprx>0 "; if(!($result_all_quotes=cs_query($sql_statement_all_quotes))) sql_error($sql_statement_all_quotes); //if ($session_usergroup=="AM") { // echo $sql_statement_all_quotes; //} $current_sellprx_title="商品報價"; $current_compare_days=$new_days; $current_compare_regioncode=""; $max_sellprx=0; $max_region_name=""; $max_supplier_coname=""; $max_supplier_branch_coname=""; $max_cdate=""; $max_cuser_name=""; $max_coaddress=""; $max_remark=""; $min_sellprx=9999999; $min_region_name=""; $min_supplier_coname=""; $min_supplier_branch_coname=""; $min_cdate=""; $min_cuser_name=""; $min_coaddress=""; $min_remark=""; while ($info_all_quotes=cs_fetch_array($result_all_quotes)) { if ($info_all_quotes[sellprx]>$max_sellprx) { $max_sellprx=$info_all_quotes[sellprx]; $max_region_name=$info_all_quotes[region_name]; $max_supplier_coname=$info_all_quotes[supplier_coname]; $max_supplier_branch_coname=$info_all_quotes[supplier_branch_coname]; $max_cdate=$info_all_quotes[cdate]; $max_cuser_name=$info_all_quotes[cuser_name]; $max_coaddress=$info_all_quotes[coaddress]; $max_remark=$info_all_quotes[remark]; } if ($info_all_quotes[sellprx]<$min_sellprx) { $min_sellprx=$info_all_quotes[sellprx]; $min_region_name=$info_all_quotes[region_name]; $min_supplier_coname=$info_all_quotes[supplier_coname]; $min_supplier_branch_coname=$info_all_quotes[supplier_branch_coname]; $min_cdate=$info_all_quotes[cdate]; $min_cuser_name=$info_all_quotes[cuser_name]; $min_coaddress=$info_all_quotes[coaddress]; $min_remark=$info_all_quotes[remark]; } } $diff_percent=number_format(((($max_sellprx-$min_sellprx)/$min_sellprx)*100),2); $brand_name=$info_pp[brand_name]; $product_name=$info_pp[product_name]; $rand_id=$info_pp[rand_id]; $photo=$info_pp[photo1]; $current_sellprx=$info_pp[sellprx]; $current_region_name=$info_pp[region_name]; $current_supplier_coname=$info_pp[supplier_coname]; $current_supplier_branch_coname=$info_pp[supplier_branch_coname]; $current_cdate=$info_pp[cdate]; $current_cuser_name=$info_pp[cuser_name]; $current_coaddress=$info_pp[coaddress]; $current_remark=$info_pp[remark]; /* end: get current, max, min, diff of one product*/ if ( ($show_cheapest_only=="1" & $current_compare_days>0 && $current_sellprx==$min_sellprx && $max_sellprx>$min_sellprx) || $show_cheapest_only=="0") { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } if ($pp_cnt==$pp_row) { echo ""; } } if ($pp_cnt<$pp_row) { echo ""; } ?>
* 最高價為最新天的會員最高報價,最低價為最新天的會員最低報價。
"; // photo $photo_str=""; if($photo!="" && file_exists(PHOTO_PATH_GLOBAL."product/w80/".$photo)) { echo $photo_str = ""; } else { echo $photo_str = ""; echo "
"; if ($session_username!="") { echo "
[ "; echo ""; echo $arr_lang[add_photo]; echo " ]
"; } else { echo "
[ "; echo ""; echo $arr_lang[add_photo]; echo " ]
"; } } echo "
"; echo ""; echo $brand_name." ".$product_name."
"; // current price include APP_PATH."product/product_current_price.php"; echo "
"; // max price include APP_PATH."product/product_max_price.php"; // min price include APP_PATH."product/product_min_price.php"; echo ""; // max-min price include APP_PATH."product/product_diff_price.php"; if ($current_compare_days>0 && $current_sellprx==$min_sellprx && $max_sellprx>$min_sellprx) { echo ""; } echo "
"; // ---------------------------------------------- // begin: price shop bottom banner 728x90 // ---------------------------------------------- //$adcode="PRICESHBB"; $adcode="PRICEAMTB"; include APP_PATH."spr/spr_ad_display.php"; // ---------------------------------------------- // end: price shop bottom banner 728x90 // ---------------------------------------------- echo "
"; // ---------------------------------------------- // begin: price shop bottom banner 728x90 // ---------------------------------------------- //$adcode="PRICESHBB"; $adcode="PRICEAMTB"; include APP_PATH."spr/spr_ad_display.php"; // ---------------------------------------------- // end: price shop bottom banner 728x90 // ---------------------------------------------- echo "