" width="">
$tntcmnft="tntcmnftisok";
include "../main/tntcmmn.html";?>
|
" width=""> |
" width=""> |
" class="lfttlsj">Home ");
if(!$ctgS_str){
echo("$ctgL_str");
}else{
echo("$ctgL_str");
echo(" > ");
//$dt_ctgS_mn= urlencode($dt_ctgS_mn) ;
//echo "ctgL=$dt_ctgL_mn&ctgS=$dt_ctgS_mn" ;
echo("$ctgS_str");
}?>
//start of image board basic
//dbquery factors
$tblname=$tinatouch_prdt_product; //table name *****
$bdbkimg_path="$img_path/img/main"; // board background image path *****
$hor_nb=4; //horigental number-image
if($view=="all"){
$ver_line_nb=4000; //vertical line number
}else{
$ver_line_nb=15; //vertical line number
}
$hor_nb1=$hor_nb-1;
$limit=$hor_nb*$ver_line_nb;
$limit_p=$hor_nb*15;
$gallery_img_path=$img_path.'/abat/itmimg/';
//order by *****
if($mbprcshw_yn=="C_BY" || $mbprcshw_yn=="C_BN"){
if($oDr=="latest"){
$odrcri="order by id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}else if($oDr=="oldest"){
$odrcri="order by id"; //order factor *****
$odrpro="asc"; //desc or asc *****
}else if($oDr=="id"){
$odrcri="order by prdt_id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}else if($oDr=="price"){
$odrcri="order by prdt_price1"; //order factor *****
$odrpro="desc"; //desc or asc *****
}else{
$odrcri="order by prdt_sort_order desc, id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}
}else{
$odrcri="order by prdt_sort_order desc, id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}
//echo $odrcri ;
// basic query by page $ctgL_str & $ctgS_str *****
if(!$ctgL && !$ctgS){ //all item list
$findwhr='where prdt_sales_yn=\'Y\''; //add where clause db query *****
}else if($ctgL && !$ctgS){
$findwhr='where ctgr_1st=\''.$ctgL_str.'\' and prdt_sales_yn=\'Y\''; //add where clause db query *****
}else if($ctgL && $ctgS){
$findwhr='where ctgr_id='.$iRn.' and ctgr_1st=\''.$ctgL_str.'\' and prdt_sales_yn=\'Y\''; //add where clause db query *****
}
//page manager ******
$ctgL_en=$ctgL;
$ctgS_en=$ctgS;
$pgRmN='?iRn='.$iRn.'&ctgL='.$ctgL_en; //any page 1st factor
$addfactor='';
if($ctgS){
$addfactor=$addfactor.'&ctgS='.$ctgS_en;
$adOdrftr=$addfactor;
}
if($oDr){
$addfactor=$addfactor.'&oDr='.$oDr;
}
//page detect
$psver=$_GET['psver'];
$pgn=$_GET['pgn'];
if(!$psver){
$psver=0;
}else{
$psver=$psver+0;
}
if(!$pgn){
$pgn=1;
}else{
$pgn=$pgn+0;
}
$sql= "select * from $tblname $findwhr $odrcri $odrpro" ;
//select * from tinatouch_prdt_product where ctgr_id= and ctgr_1st='Cosmetic' and prdt_sales_yn='Y' order by prdt_sort_order desc, id desc
//echo $sql ; //hj
$boardqry_num=mysql_query($sql);
$board_numrows=mysql_num_rows($boardqry_num);
if(!$board_numrows){
}else{
if($psver || $pgn){
if($psver==0 || $psver%$limit==0){
if($psver >= $board_numrows || !is_int($psver)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$pgn_limitno=ceil($board_numrows/(10*$limit));
if($pgn >= 1 && $pgn <= $pgn_limitno){
if(!is_int($pgn)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{
}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$psverchk=$psver/$limit;
if($psverchk >= ($pgn*10-10) && $psverchk < $pgn*10){
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
}
}
$total_page_num=$board_numrows/$limit;
$total_page=ceil($total_page_num);
$aNo=$board_numrows-$psver;
$boardqry=mysql_query("select * from $tblname $findwhr $odrcri $odrpro limit $psver,$limit");
?>
|
|
All view | Page view ");?> |
|
| | ");
echo("Sorry, we don't have data. | ");
echo("");
}else{?>
$aNo=0;
// hj added: sales on top
if($ctgL && $ctgS){
$sql= "select * from $tblname $findwhr AND prdt_top_yn ='Y' ORDER BY prdt_sort_order limit $psver,$limit" ;
$boardqry1=mysql_query($sql);
//echo $sql ;
while($boardqry_rslt1=mysql_fetch_array($boardqry1)){
$prdt_name=$boardqry_rslt1[prdt_name];
if(strlen($prdt_name) > 16){
//$prdt_name=substr($prdt_name,0,15);
//$prdt_name=$prdt_name.'..';
}else{}
$prdt_dis_factor="";
$prdt_price=$boardqry_rslt1[prdt_price1];
$prdt_dis_price=$boardqry_rslt1[prdt_dis_price2];
if($prdt_dis_price>0 && $prdt_price > $prdt_dis_price){
$prdt_dis_factor="Y";
}
$prdt_size=$boardqry_rslt1[prdt_size];
$prdt_subchk_qry=mysql_query("select * from $tinatouch_prdt_subitem where prdt_id='$boardqry_rslt1[prdt_id]' order by id asc");
$prdt_subchk_numrows=mysql_num_rows($prdt_subchk_qry);
$prdt_sub_size_no=0;
if(!$prdt_subchk_numrows){}else{
for($i=0;$i<$prdt_subchk_numrows;$i++){
$sprdt_price=mysql_result($prdt_subchk_qry,$i,7);
$sprdt_dis_price=mysql_result($prdt_subchk_qry,$i,9);
$sprdt_size=mysql_result($prdt_subchk_qry,$i,5);
if($sprdt_price){
$prdt_sub_size_no++;
}
$prdt_size=$prdt_size.', '.$sprdt_size;
if($sprdt_dis_price > 0 && $sprdt_dis_price < $sprdt_price){
$prdt_dis_factor="Y";
$sale_icon= " " ;
}}}
$prdt_number=$boardqry_rslt1[prdt_id];
$prdt_price_unit=$boardqry_rslt1[prdt_sales_unit1];
$img_name=$boardqry_rslt1[img1_filename];
$item_number=$boardqry_rslt1[id];
$item_prdtid=$boardqry_rslt1[prdt_id];
$Vno=$aNo%$hor_nb;
if($Vno==0){
?>
}?>
No.$prdt_number $prdt_name");?>
|
0){
//echo("11 $prdt_size");
echo("$$prdt_price / $prdt_price_unit (..)");
}else{
if($prdt_dis_factor=="Y"){
echo("$$prdt_price /$prdt_price_unit $$prdt_dis_price /$prdt_price_unit");
}else{
echo("$$prdt_price /$prdt_price_unit");
}}
}else if($mbprcshw_yn=="P"){
echo("Check your status");
}else if($mbprcshw_yn=="W"){
echo("Check your status");
}else{
echo("Check your status");
}
}else{
echo("Sign in for Price");
}?>
|
|
|
|
}else{
}?>
|
}$aNo++;}?>
}
// end of 1while
//end of if($ctgL && $ctgS)
}?>
| | ");
echo("Sorry, we don't have data. | ");
echo("");
}else{?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
echo("Page ");
if($psver==0){
echo("1");
}else{
$hpage=$psver/$limit;
$hhppge=$hpage+1;
echo("$hhppge");
}
echo (" / $total_page | Total $board_numrows item(s).");?>
|
$aNo=0;
while($boardqry_rslt=mysql_fetch_array($boardqry)){
$prdt_name=$boardqry_rslt[prdt_name];
if(strlen($prdt_name) > 16){
//$prdt_name=substr($prdt_name,0,15);
//$prdt_name=$prdt_name.'..';
}else{}
$prdt_dis_factor="";
$prdt_price=$boardqry_rslt[prdt_price1];
$prdt_dis_price=$boardqry_rslt[prdt_dis_price2];
$sale_icon= '' ;
//echo "$prdt_dis_price>0 && $prdt_price > $prdt_dis_price -- " ;
//echo "$sprdt_dis_price >0 && $sprdt_dis_price < $sprdt_price " ;
if($prdt_dis_price>0 && $prdt_price > $prdt_dis_price){
$prdt_dis_factor="Y";
$sale_icon= " " ;
}
$prdt_size=$boardqry_rslt[prdt_size];
$prdt_subchk_qry=mysql_query("select * from $tinatouch_prdt_subitem where prdt_id='$boardqry_rslt[prdt_id]' order by id asc");
$prdt_subchk_numrows=mysql_num_rows($prdt_subchk_qry);
$prdt_sub_size_no=0;
if(!$prdt_subchk_numrows){}else{
for($i=0;$i<$prdt_subchk_numrows;$i++){
$sprdt_price=mysql_result($prdt_subchk_qry,$i,7);
$sprdt_dis_price=mysql_result($prdt_subchk_qry,$i,9);
$sprdt_size=mysql_result($prdt_subchk_qry,$i,5);
if($sprdt_price){
$prdt_sub_size_no++;
}
$prdt_size=$prdt_size.', '.$sprdt_size;
if($sprdt_dis_price >0 && $sprdt_dis_price < $sprdt_price){
$prdt_dis_factor="Y";
// $sale_icon= " " ;
}}}
$prdt_number=$boardqry_rslt[prdt_id];
$prdt_price_unit=$boardqry_rslt[prdt_sales_unit1];
$img_name=$boardqry_rslt[img1_filename];
$item_number=$boardqry_rslt[id];
$item_prdtid=$boardqry_rslt[prdt_id];
$prdt_input_date= $boardqry_rslt[prdt_input_date] ; //061413 prdt_update_date
$new_icon= '' ;
//$sale_icon= '' ;
$sql= "select * from `tinatouch_prdt_features` where prdt_id='$item_number'" ;
$query= mysql_query($sql);
//echo "sql1.. $sql " ;
if(!mysql_num_rows($query))
{
} else {
$rows=mysql_fetch_array($query);
$new_yn= $rows[prdt_id_new_yn];
$sale_yn= $rows[prdt_id_sale_yn];
//echo "new.. $new_yn + "-" + $sale_yn " ;
if ($new_yn == '1') { $new_icon= " " ; }
if ($sale_yn == '1') { $sale_icon= "" ; } // width=22 height=10
}
if ( (time() - $prdt_input_date) < (86400*30)) { $new_icon= " " ; }
$Vno=$aNo%$hor_nb;
if($Vno==0){?>
}?>
No.$prdt_number $prdt_name$new_icon $sale_icon");?>
|
0){
echo("$$prdt_price / $prdt_price_unit (..)");
//echo("3 $prdt_size");
}else{
if($prdt_dis_factor=="Y"){
echo("$$prdt_price /$prdt_price_unit $$prdt_dis_price /$prdt_price_unit");
}else{
echo("$$prdt_price / $prdt_price_unit");
}
}
}else if($mbprcshw_yn=="P"){
echo("Check your status");
}else if($mbprcshw_yn=="W"){
echo("Check your status");
}else{
echo("Check your status");
}
}else{
echo("Sign in for Price");
}?>
|
|
|
|
}else{
echo "We have nothing in this series.";
}?>
|
}$aNo++;}?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
}?>
//end of board?> |