Фото | Код товара | Название | Кол. | Цена | Сумма |
---|---|---|---|---|---|
Итого: '.$full_totol.' |
Фото | Код товара | Название | Кол. | Цена | Сумма |
---|---|---|---|---|---|
Итого: '.$this->currency->format($this->tax->calculate($this->cart->getTotal(), 1, $this->config->get('config_tax')), $this->session->data['currency']).' |
№ '.rand(99,999).' от '.date('d.m.Y').'
'.$render_table.'Цена указана без учета доставки
'); if($_GET['formaat'] == "EXEL")$this->SmpdfEXEL( $render_table); } public function cp() { if(!empty($this->request->get['pr_id'])) { $product_id = (int) $this->request->get['pr_id']; $html = $this->print_mono($product_id); $this->Smpdf($html, rand(100,999)); } else exit('not product!'); } public function SmpdfEXEL($html, $num = null) { require_once DIR_SYSTEM . '/library/KOM-EXCEL/PHPExcel.php'; require_once DIR_SYSTEM . '/library/KOM-EXCEL/PHPExcel/Writer/Excel2007.php'; $xls = new PHPExcel(); $xls->getProperties()->setTitle("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setSubject("КП"); $xls->getProperties()->setCreator("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setManager("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setCompany("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setCategory("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setKeywords("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setDescription("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setLastModifiedBy("".$_SERVER['HTTP_HOST']); $xls->getProperties()->setCreated(date("d.m.Y")); $sheet = $xls->getActiveSheet(); $sheet->setTitle('КП'); $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setResizeProportional(false); $objDrawing->setName("".$_SERVER['HTTP_HOST']); $objDrawing->setDescription("".$_SERVER['HTTP_HOST']); $objDrawing->setPath(DIR_IMAGE.''.$this->config->get('config_logo')); $objDrawing->setCoordinates('B2'); $objDrawing->setOffsetX(10); $objDrawing->setOffsetY(10); $objDrawing->setWidth(170); $objDrawing->setHeight(70); $objDrawing->setWorksheet($sheet); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 14, 'color' => array('rgb' => '666666'), ) ); $sheet->getStyle("E2:E4")->applyFromArray($style_border); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 16, 'color' => array('rgb' => 'ff7700'), 'bold' => true, ) ); $sheet->getStyle("F2:F4")->applyFromArray($style_border); $sheet->setCellValue("F2", "".$_SERVER['HTTP_HOST']); $sheet->setCellValue("F3", "".$this->config->get('config_email')); $sheet->setCellValue("F4", "".$this->config->get('config_telephone')); $sheet->setCellValue("E2", "Сайт:"); $sheet->setCellValue("E3", "Email:"); $sheet->setCellValue("E4", "Телефон:"); $sheet->mergeCells("B6:G6"); $sheet->mergeCells("B7:G7"); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 18, 'color' => array('rgb' => '666666'), 'bold' => true, ) ); $sheet->getStyle("B6")->applyFromArray($style_border); $sheet->setCellValue("B6", "Коммерческое предложение"); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 14, 'color' => array('rgb' => '666666'), 'bold' => true, ) ); $sheet->getStyle("B7")->applyFromArray($style_border); $sheet->setCellValue("B7", "№ ".rand(99,1500)." от ".date('d.m.Y')); $sheet->getStyle("B6")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("B6")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->getStyle("B7")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("B7")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $border = array( 'borders'=>array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('rgb' => '000000') ) ) ); $listing = $this->cart->getProducts(); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 14, 'color' => array('rgb' => '666666'), 'bold' => true, ) ); $sheet->setCellValue("B9", "Фото"); $sheet->getStyle("B9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("B9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("C9", "Код товара"); $sheet->getStyle("C9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("C9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("D9", "Название "); $sheet->getStyle("D9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("D9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("E9", "Кол."); $sheet->getStyle("E9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("E9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("F9", "Цена"); $sheet->getStyle("F9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("F9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("G9", "Сумма"); $sheet->getStyle("G9")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("G9")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->getStyle("B9:G9")->applyFromArray($border); $sheet->getColumnDimension('D')->setWidth(50); $sheet->getStyle('B9')->applyFromArray($style_border); $sheet->getStyle('C9')->applyFromArray($style_border); $sheet->getStyle('D9')->applyFromArray($style_border); $sheet->getStyle('E9')->applyFromArray($style_border); $sheet->getStyle('F9')->applyFromArray($style_border); $sheet->getStyle('G9')->applyFromArray($style_border); $full_totol = 0; foreach ($listing as $key => $prd) { /* 'thumb' => $product_info['image'], 'model' => $product_info['model'], 'name' => $product_info['name'], 'url' => $url, 'quantity' => $quantity, 'total' => round($total,0), 'price' => round($price,0) */ $l = $key +10; $i = $this->mono_tableEXCEL($prd['product_id'], $prd['quantity'], $prd['price'], $prd['total']); $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setResizeProportional(false); $objDrawing->setName('Название картинки'); $objDrawing->setDescription('Описание картинки'); $objDrawing->setPath(DIR_IMAGE . $i['thumb']); $objDrawing->setCoordinates('B'.$l); $objDrawing->setOffsetX(10); $objDrawing->setOffsetY(10); $objDrawing->setWidth(163); $objDrawing->setHeight(160); $objDrawing->setWorksheet($sheet); $sheet->getColumnDimension('B')->setWidth(28); $sheet->getRowDimension( $l)->setRowHeight(140); $sheet->setCellValue("C".$l, $i['model']); $sheet->getColumnDimension('C')->setWidth(15); $sheet->getStyle("C".$l)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("C".$l)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("D".$l, $i['name']); $sheet->getStyle("D".$l)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("D".$l)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->getCell("D".$l)->getHyperlink()->setUrl($i['url']); $sheet->getCell("D".$l)->getHyperlink()->setTooltip('Открыть товар на сайте'); // У текста нужно сделать синий цвет и подчеркивание $sheet->getStyle("D".$l)->applyFromArray( array( 'font' => array( 'color' => array( 'rgb' => '0000FF' ), 'underline' => 'single' ) ) ); $sheet->getStyle("D".$l)->getAlignment()->setWrapText(true); $sheet->setCellValue("E".$l, $i['quantity']); $sheet->getStyle("E".$l)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("E".$l)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("F".$l, $i['price']); $sheet->getStyle("F".$l)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("F".$l)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $sheet->setCellValue("G".$l, $i['total']); $sheet->getStyle("G".$l)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $sheet->getStyle("G".$l)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $full_totol += $i['total']; $sheet->getStyle("B".$l.":G".$l."")->applyFromArray($border); } $sheet->setCellValue("E".($l+1), 'Итого: '.$full_totol.' грн.'); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 16, 'color' => array('rgb' => 'ff7700'), 'bold' => true, ) ); $sheet->getStyle("E".($l+1))->applyFromArray($style_border); $sheet->setCellValue("E".($l+2), "Цена без учета доставки"); $style_border = array( 'font' => array( 'name' => 'Times New Roman', 'size' => 9, 'color' => array('rgb' => '666666'), ) ); $sheet->getStyle("E".($l+2))->applyFromArray($style_border); header("Expires: Mon, 1 Apr 1974 05:00:00 GMT"); header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); header("Content-Disposition: attachment; filename=file.xlsx"); $objWriter = new PHPExcel_Writer_Excel2007($xls); $objWriter->save('php://output'); exit(); exit(); header('Content-Type: application/vnd.ms-excel; charset=utf-8'); header("Content-Disposition: attachment;filename=".date("d.m.Y").rand(2,100000)."-export.xls"); header("Content-Transfer-Encoding: binary "); echo $data = ' '; } public function Smpdf( $html, $num = null) { if ($num == null) $num = rand(100,999); require_once DIR_SYSTEM . '/library/mpdf2/vendor/autoload.php'; $this->load->model('tool/image'); $headerHTML = '
|
Сайт: Email: Телефон: |
'.$_SERVER['HTTP_HOST'].' '.$this->config->get('config_email').' '.$this->config->get('config_telephone').' |