$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}" : '');