$q .= " LEFT JOIN designs_elements de ON de.designs_id = d.designs_id ";
$q .= " WHERE dd.drafts_id = '$drafts_id' AND dd.approve_status != 'R'";
*/
$q = "SELECT d.status, d.sub_status FROM designs d ";
$q .= " INNER JOIN designs_drafts dd ON dd.designs_id = d.designs_id ";
$q .= " WHERE dd.drafts_id = '{$drafts_id}' AND dd.approve_status != 'R'";
$dbq = tep_db_query($q);
$res = tep_db_fetch_array($dbq);
$msg = 'Drafts is not found on tabs or invalid!';
$class = "red";
$status = '';
if ($res['status'] > 0) {
$status = is_numeric($res['sub_status']) ? "{$res['status']}-{$res['sub_status']}" : $res['status'];
$tab_name = design::getDesignStatus($status);
if (is_numeric($res['sub_status'])) {
$main_tab_name = design::getDesignStatus($res['status']);
$tab_name = "{$main_tab_name} - {$tab_name}";
}
if ($tab_name != '') {
$msg = "Drafts {$drafts_id} is on \"{$tab_name} Tab\"";
$class = "green";
$status = $res['status'];
}
}
$result = array();
$result['drafts_id'] = $drafts_id;
$result['msg'] = $msg;
$result['status'] = $status;
$result['class'] = $class;
ajaxReturn($result);
exit;
case 'drafts':
$img_title = 'Draft ' . $row['designs_id'];
$des_title[] = 'Design ' . $row['designs_id'];
$des_title[] = $img_title;
$des_title[] = "";
$image = $row['draft_image'] == '' ? $row['designs_image_2'] == '' ? $row['designs_image_1'] : $row['designs_image_2'] : $row['draft_image'];
break;
case 'products':
$img_title = 'Product ' . $row['products_id'];
$des_title[] = 'Design ' . $row['designs_id'];
$des_title[] = 'Draft ' . $row['drafts_id'];
$des_title[] = $img_title;
$image = $row['products_image'] == '' ? $row['draft_image'] == '' ? $row['designs_image_2'] == '' ? $row['designs_image_1'] : $row['designs_image_2'] : $row['draft_image'] : $row['products_image'];
break;
}
$des_title[] = '<strong>"' . design::getDesignStatus($row['status']) . '"</strong>';
$designs .= '<div class="pro-thumb" style="height:150px;">';
$designs .= '<div>' . webImage($image, IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, $img_title) . '</div>';
//$designs .= '<div class="text">'.$img_title.'</div>';
$designs .= '<div class="text">' . implode('<br />', $des_title) . '</div>';
$designs .= '</div>';
}
}
} else {
$designs_total = 0;
}
$content .= '<div id="product-style">';
$content .= '<ul>';
$content .= '<li><a href="#prostyle-tab1"><span>Attribute Detail</span></a></li>';
if ($styles_id != '0') {
$content .= '<li><a href="#prostyle-tab2"><span>List of Products (' . $products_total . ')</span></a></li>';
if(txtResult=="FLAG") {
$("#rfw").fadeIn();
} else if(txtResult=="UNFLAG") {
$("#atw").fadeIn();
}
' . $js_reload_followers . '
}
}
$("#btn-add-watchlist, #btn-rem-watchlist").click(function(){
$("#atw, #rfw").hide();
$("#low").fadeIn();
var me_action = ($(this).attr("id")=="btn-add-watchlist") ? "FLAGWATCHLIST" : "UNFLAGWATCHLIST";
$.post(url, { me_action: me_action, designs_id: ' . $design->id . ' }, watchlistUpdated, "text");
});
$("#btn-show-status-history").click(function(){
$(this).hide();
$("#area-status-history").parent().show();
});
$("#area-status-history").click(function(){
$(this).parent().hide();
$("#btn-show-status-history").show();
});
';
}
$main_status = design::getDesignStatus($design->status);
$main_status = $main_status == 'Closed' ? ' ( Done )' : " on Tab {$main_status}";
$sub_status = $design->sub_status > 0 ? design::getDesignStatus("{$design->status}-{$design->sub_status}") : '';
$title = $design->followers->drawFollowersTitleIcon() . 'Design Detail ' . $design->id . $main_status . ($sub_status != '' ? " - {$sub_status}" : '');
