/** * Get all key and name/label of all active product attributes group * @return Array Array of style groups with group id as array key and group * name as array value */ public static function getAttributeGroups() { //Please sort array by the name $groups = array(); $groups[self::GROUP_ID_CARELABEL] = 'Care Label'; $groups[self::GROUP_ID_COLLECTION] = 'Collection'; //$groups[self::GROUP_ID_COLOR] = 'Color'; $groups[self::GROUP_ID_COMPOSITION] = 'Composition'; $groups[self::GROUP_ID_FASHION_GRADE] = 'Fashion Grade'; $groups[self::GROUP_ID_FASHION_STYLE] = 'Fashion Style'; $groups[self::GROUP_ID_MATERIAL] = 'Material Characteristic'; $groups[self::GROUP_ID_PACKAGE_CONTENT] = 'Package Content'; $groups[self::GROUP_ID_PACKAGING] = 'Packaging'; $groups[self::GROUP_ID_PATTERN] = 'Pattern'; $groups[self::GROUP_ID_PRODUCT_FINISHING] = 'Product Finishing'; $groups[self::GROUP_ID_SHAPE] = 'Product Shape'; $groups[self::GROUP_ID_ORIGIN] = 'Production Country'; $groups[self::GROUP_ID_STYLE] = 'Style'; //SUBCATEGORY: $sub_category_title = 'Sub Category'; //OLD SUBCATEGORY GROUP //$groups[self::GROUP_ID_SUB_CATEGORY] = $sub_category_title; //SUB CATEGORY IS NOW BASED ON TOP CATEGORY while ($ct = CategoryTop::getOneByOneAsObject()) { $groups[$ct->getSubCategoryGroup()] = $sub_category_title . ' ' . $ct->name; } $groups[self::GROUP_ID_SYMBOL] = 'Symbol'; $groups[self::GROUP_ID_TOPIC] = 'Topic'; $groups[self::GROUP_ID_WEEK] = 'Week'; return $groups; }
$cellsizecollweek = $cellsize + $margin; $cell_height_col = 55; $cell_height = 5; $pdf->setXY($margin, $ypos); $pdf->setFont('Arial', 'B', '14'); $pdf->cell(240, 5, 'SALES REPORT WEEKLY PRODUCT KW ' . date('W') . ' (' . date('d.m.Y', strtotime($filter_date)) . ')', 0, 0, 'C'); $pdf->setFont('Arial', '', '10'); $ypos += 10; $pdf->setXY($cellstart, $ypos); $firstorder = true; $no = 1; $catids = load_config('products-categories-sorting'); if (SERVER_IS_LOCAL) { use_class('CategoryTop'); //load all categories which not sorted while ($ct = CategoryTop::getOneByOneAsObject()) { if ($ct->getCategoriesTotalCount() > 0) { while ($cat = $ct->getCategoriesOneByOneAsObject()) { if (!in_array($cat->id, $catids)) { $catids[] = $cat->id; } } } } } foreach ($catids as $catid) { $header = true; if (is_array($products[$catid])) { foreach ($products[$catid] as $pid => $p) { if ($ypos >= 165 || $no == 1 && $firstorder == false) { $pdf->AddPage('L');
private function renderFilter() { use_class('jng_sp'); use_class('products_brand'); use_class('CategoryTop'); $class_sp = new jng_sp(); $class_pb = new products_brand(); $sp_datas = $class_sp->retrieveList(); $brands = $class_pb->retrieveList("active_status='1'"); //FILTER Order Type $order_type_selected = self::getSession(self::FILTER_ORDER_TYPE); $order_types = array(self::ORDER_TYPE_ALL => 'All Orders', self::ORDER_TYPE_JG => 'JG Orders'); $order_type_groups['SP Orders'][self::ORDER_TYPE_SP] = 'All SP Orders'; foreach ($sp_datas as $sp_id => $sp_data) { $order_type_groups['SP Orders'][$sp_id] = $sp_data['name']; } $order_type_groups['Depot Orders'] = $this->DP_ORDER_TYPES; $filter_order_type = '<select name="' . self::FILTER_ORDER_TYPE . '" class="cbo_filters">' . loadComboListFromArray($order_types, null, $order_type_selected, true, $order_type_groups) . '</select>'; /* Filter SP now merged into Filter Order Type array_unshift($sp_datas, array(self::FILTER_SP_ID => '0', 'name' => 'All Sales Partners')); $filter_sp = $class_sp->drawCombo($sp_datas, $this->filters_sp_id, '', self::FILTER_SP_ID, 'cbo_filters'); */ //FILTER Brand $brand_options = array(); $brand_options[0] = 'Show All Brands'; foreach ($brands as $b) { $brand_options[$b['products_brand_id']] = $b['brand_name']; } $filter_brand = '<select name="' . self::FILTER_BRAND_ID . '" class="cbo_filters">' . loadComboListFromArray($brand_options, null, $this->filters_brand_id, false) . '</select>'; //FILTER Category $category_selected = self::getSession(self::FILTER_CAT_ID); $categories = array('' => 'Show All Categories'); $category_groups = array(); while ($ct = CategoryTop::getOneByOneAsObject()) { if ($ct->getCategoriesTotalCount() > 0) { while ($cat = $ct->getCategoriesOneByOneAsObject()) { if ($cat->getProductCodePrefix() != "") { $category_groups[$ct->name][$cat->id] = $cat->getName(1); } } } } $filter_category = '<select name="' . self::FILTER_CAT_ID . '" class="cbo_filters">' . loadComboListFromArray($categories, null, $category_selected, true, $category_groups) . '</select>'; /* $filter_category = comboProductsCategory( self::FILTER_CAT_ID , self::FILTER_CAT_ID , $this->filters_cat_id , 'cbo_filters' , '' , 'Show All Category'); */ //FILTER Product ID/EAN $filter_prod_search = '<input type="text" name="' . self::FILTER_LIST_EAN . '" class="txt_filters input" value="' . $this->filters_list_ean . '" />'; //FILTER Order No. $filter_orders_no = '<input type="text" name="' . self::FILTER_LIST_ORDERS_NO . '" class="txt_filters" value="' . $this->filters_list_orders_no . '" />'; //FILTER Lead Time Start Date $filter_leadtime = '<input name="' . self::FILTER_LEADTIME_START_DATE . '" class="date_picker" value="' . $this->filters_leadtime_date_start . '"/>' . ' to <input name="' . self::FILTER_LEADTIME_END_DATE . '" class="date_picker" value="' . $this->filters_leadtime_date_end . '"/>' . ' <input type="button" value="Go" class="btn_filters_leadtime_go" ' . 'title="Apply lead time start date filter" />' . ' <input type="button" value="Clear" class="date_range_clear" ' . 'title="Clear lead time start date filter" />'; $enter_info = '<span class="notice smallText" style="font-weight:normal;">' . '(press <em>Enter</em> to filter)</span>'; $result .= '<div style="margin-bottom:10px;">'; $result .= '<table border="0" cellpadding="0" cellspacing="0">'; $result .= '<tr>'; $result .= '<td class="bold">Order Type</td>'; //$result .= '<td class="bold">Sales Partner</td>'; $result .= '<td class="bold">Brand</td>'; $result .= '<td class="bold">Category</td>'; $result .= '<td class="bold">Product ID/EAN ' . $enter_info . '</td>'; $result .= '<td class="bold">Order No. ' . $enter_info . '</td>'; $result .= '<td class="bold">Lead Time Start Date</td>'; $result .= '</tr>'; $result .= '<tr>' . '<td>' . $filter_order_type . '</td>' . '<td>' . $filter_brand . '</td>' . '<td>' . $filter_category . '</td>' . '<td>' . $filter_prod_search . '</td>' . '<td>' . $filter_orders_no . '</td>' . '<td>' . $filter_leadtime . '</td>' . '</tr>'; $result .= '</table></div>'; return $result; }