|
|
|
|
|
|
| |
|
|
| • Position> Products > Design
Change of Products |
|
|
1 and ProdItem_enTB.OpenSale=1 and ProdItem_enTB.ModifyProd=1 and ProdItem_enTB.ModifyUpDate<='".date("Y-m-d")."' and ProdItem_enTB.ModifyDownDate>='".date("Y-m-d")."' order by ProdItem_enTB.ModifyDate desc,ProdClass_enTB.ArrayNo,ProdClass_enTB.ID,ProdSeries_enTB.ArrayNo,ProdSeries_enTB.ID,ProdItem_enTB.ItemName,ProdItem_enTB.ID";
$DB->query($query);
//if(!$DB->query($query)) die($DB->error);
$numrows = $DB->numRows();
$pagesize = 8;
if(@$_GET['topage']){
$topage = $_GET['topage'];
}else if(@$_POST['topage']){
$topage = $_POST['topage'];
}else{
$topage = NULL;
}
$Page = new AllotPage($numrows,$pagesize);
$pagecount = $Page->getTatlePage();
$currentpage = $Page->getCurrentPage($topage);
$startrow = $Page->getStartRow();
$endrow = $Page->getEndRow();
if($numrows > 0){
$DB->dataSeek($startrow);
for($i=$startrow;$i<=$endrow;$i++){
$row = $DB->fetchObject();
?>
Pic_s!=''){
$firsrinfo = 'prod_'.Ck_FirstInfo($row->ID,$DB2).'.php';
echo ' | ';
}else{
echo ' | ';
}
?>
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
$query2 = "select ID from ProdSize_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
$query2 = "select ID from ProdOrderNo_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
$query2 = "select ID from ProdFitment_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
if($row->CompareSale=='1'){
echo '
$query2 = "select ID from ProdDownPdf_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '