if (!isset($default_cur)) { $default_cur = $row['price_default']; $default_cur_low = strtolower($default_cur); } $price = $row['price_' . $default_cur_low]; $price_total = $row['quantity'] * $price; $po_price_total += $price_total; $row_counter++; $oi = array(); $oi['no'] = $row_counter; $oi['qty'] = $row['quantity']; $oi['code'] = $row['products_model']; $oi['ean'] = $row['products_ean']; $oi['order_id'] = $row['depot_orders_id']; $oi['brand'] = $product->brand_name; $oi['desc'] = $class_pm->displayProductName($row['products_id']); $oi['price'] = $price; $oi['total'] = $price_total; $orders_items[] = $oi; } //Create new excel object $objPHPExcel = new PHPExcel(); //First let's set width of needed columns $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(40); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(15);
$col3w = 20; $ystart = 75; $def_lineheight = 6; $pdf->setFont('Arial', 'B', $fontsize_med); $pdf->SetXY($margin, $ystart); $pdf->Cell($col1w, $def_lineheight * 2, 'Artikelnummer', 1, 0); $pdf->Cell($col2w, $def_lineheight * 2, 'Artikelbezeichnung', 1, 0); $pdf->Cell($col3w, $def_lineheight * 2, 'Menge', 1, 1, 'C'); $pdf->setFont('Arial', '', $fontsize_med); $item_counter = 0; foreach ($items as $item) { $item_counter++; $pdf->SetX($margin); $pdf->Cell($col1w, $def_lineheight, $item['article_number'], 1, 0); // $pdf->Cell($col2w, $def_lineheight, $item['billing_text'], 1, 0); $pdf->Cell($col2w, $def_lineheight, $class_pm->displayProductName($item['products_id'], 65), 1, 0); $pdf->Cell($col3w, $def_lineheight, intval($item['order_quantity']), 1, 1, 'C'); } if ($item_counter < $total_items) { $item_counter++; for ($ic = $item_counter; $ic <= $total_items; $ic++) { $pdf->SetX($margin); $pdf->Cell($col1w, $def_lineheight, '', 1, 0); $pdf->Cell($col2w, $def_lineheight, '', 1, 0); $pdf->Cell($col3w, $def_lineheight, '', 1, 1, 'C'); } } //Items return Info $xpos = $margin + $col1w + $col2w + $col3w + 20; $col1w = 15; $col2w = 15;
$ypos += 2; //list $untax_price_subtotal = 0; $tax_subtotal = 0; $vat_text = VAT * 100 . '%'; $pdf->setFont('Arial', '', '8'); foreach ($items as $item) { $ypos += 4; $pdf->SetXY($margin, $ypos); $pdf->Cell($col1w, 4, $item['products_quantity'], 0, 0, 'C'); $pdf->Cell($col2w, 4, $item['products_model']); $category = $class_o->getCategories($item['orders_products_id']); use_class('products_brand'); $class_pb = new products_brand(); $product_brand = $class_pb->retrieveDetail($item['products_brand_id']); $product_name = $class_pm->displayProductName($item['products_id'], 47); // $pdf->Cell($col3w,4,$product_name); $pdf->Cell($col3w, 4, html_entity_decode($product_name)); if (!$print_delivery_note) { $untax_price_piece = $item['final_price'] / (1 + VAT); $untax_price = $item['products_quantity'] * $untax_price_piece; $taxed_price = $item['products_quantity'] * $item['final_price']; $tax = $taxed_price - $untax_price; $untax_price_subtotal += $untax_price; $tax_subtotal += $tax; $pdf->Cell($col4w, 4, displayCurrency($order['currency'], $untax_price_piece), 0, 0, 'R'); $pdf->Cell($col5w, 4, displayCurrency($order['currency'], $untax_price), 0, 0, 'R'); $pdf->Cell($col6w, 4, $vat_text, 0, 0, 'C'); $pdf->Cell($col7w, 4, displayCurrency($order['currency'], $taxed_price), 0, 0, 'R'); } }
$materials_stone = array_search($stones_bq, $stones_mats); } if (count($stones_sizes) > 0) { $stones_bq = max($stones_sizes); $materials_stone_size = array_search($stones_bq, $stones_sizes); } $cost_price = $obj_product->isPriceSellingUsingDiscount($jng_sp_id) ? $obj_product->getPriceSelling($jng_sp_id) : $obj_product->getPriceSellingOld($jng_sp_id); $row = array(); $row[] = 'X'; $row[] = $ean; $row[] = ''; //EAN rule checker $row[] = $pdata['p']['products_brand_name']; $row[] = $pdata['p']['products_model'] . ($length > 0 ? '_' . textLength($length, false) : ''); $row[] = $pdata['categories_name']; $row[] = $class_pm->displayProductName($pid); $row[] = ''; //Serie $row[] = ''; //Color Numbers $row[] = implode(', ', $colors); $row[] = implode(',', $materials); $row[] = $length > 0 ? textLength($length) : ''; $row[] = ''; //Special Size $row[] = 'DAMEN'; //Gender $row[] = displayCurrency('EUR', $cost_price, false); //Cost Price $row[] = displayCurrency('EUR', $obj_product->getPriceUVP(), false); //UVP