$link .= "&parent_id={$parent_id}"; $link_form .= "&parent_id={$parent_id}"; if ($cate_id == $parent_id) { $cate_id = -1; } } else { $parent_id = -1; } if (isset($_GET['manu_id']) && $_GET['manu_id'] > 0) { $manu_id = (int) $_GET['manu_id']; $link .= "&manu_id={$manu_id}"; $link_form .= "&manu_id={$manu_id}"; } else { $manu_id = -1; } $arrTotal = $model->getListProduct($product_code, $product_name, $cate_type_id, $parent_id, $cate_id, $manu_id, $is_new, $is_saleoff, $is_hot, $trangthai, -1, -1); require_once 'PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("HoangNH")->setLastModifiedBy("HoangNH")->setTitle("Office 2007 XLSX vinawatch.com")->setSubject("Office 2007 XLSX vinawatch.com")->setDescription("")->setKeywords("")->setCategory(""); // Add some data $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'Mã sản phẩm')->setCellValue('B1', 'Tên sản phẩm')->setCellValue('C1', 'Menu danh mục')->setCellValue('D1', 'Danh mục')->setCellValue('E1', 'Trạng thái')->setCellValue('F1', 'Giá sản phẩm')->setCellValue('G1', 'Giá đã giảm')->setCellValue('H1', 'Số lượng deal')->setCellValue('I1', 'Ngày bắt đầu')->setCellValue('J1', 'Ngày kết thúc')->setCellValue('K1', 'Số lượng đã bán')->setCellValue('L1', 'Seo Title')->setCellValue('M1', 'Meta description')->setCellValue('N1', 'Meta Keyword'); $i = 1; if (!empty($arrTotal['data'])) { foreach ($arrTotal['data'] as $value) { $i++; $start_date = $value['start_date'] > 0 ? date('d-m-Y', $value['start_date']) : ""; $end_date = $value['end_date'] > 0 ? date('d-m-Y', $value['end_date']) : ""; // Add some data $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $value['product_code'])->setCellValue('B' . $i, $value['product_name'])->setCellValue('C' . $i, $value['cate_type_id'])->setCellValue('D' . $i, $value['cate_id'])->setCellValue('E' . $i, $value['trangthai'])->setCellValue('F' . $i, $value['price'])->setCellValue('G' . $i, $value['price_saleoff'])->setCellValue('H' . $i, $value['deal_amount'])->setCellValue('I' . $i, $start_date)->setCellValue('J' . $i, $end_date)->setCellValue('K' . $i, $value['daban'])->setCellValue('L' . $i, $value['meta_title'])->setCellValue('M' . $i, $value['meta_description'])->setCellValue('N' . $i, $value['meta_keyword']);
} if (isset($_GET['cate_type_id']) && $_GET['cate_type_id'] > 0) { $arrCustom['cate_type_id'] = $_GET['cate_type_id']; $link .= "&cate_type_id=" . $arrCustom['cate_type_id']; $link_form .= "&cate_type_id=" . $arrCustom['cate_type_id']; } else { $arrCustom['cate_type_id'] = 1; } if (isset($_GET['menu_type']) && $_GET['menu_type'] > 0) { $menu_type = $_GET['menu_type']; } else { $menu_type = -1; } $cate_type_id = $arrCustom['cate_type_id']; $detailCateType = $model->getDetail('cate_type', $cate_type_id); $listTotal = $model->getListProduct($arrCustom, $parent_id, $name, -1, -1); $total_record = $listTotal['total']; $total_page = ceil($total_record / 100); $page = isset($_GET['page']) ? (int) $_GET['page'] : 1; $offset = 100 * ($page - 1); $list = $model->getListProduct($arrCustom, $parent_id, $name, $offset, 100); if ($cate_type_id > 0) { $cateParentArr = $model->getListCateTree($cate_type_id); } else { $cateParentArr = $model->getListCateParent(); } $cateTypeArr = $model->getListCateType(); ?> <div class="row"> <div class="col-md-12"> <section class="content-header">
} if (isset($_GET['cate_type_id']) && $_GET['cate_type_id'] > 0) { $cate_type_id = (int) $_GET['cate_type_id']; $link .= "&cate_type_id={$cate_type_id}"; $link_form .= "&cate_type_id={$cate_type_id}"; } else { $cate_type_id = -1; } if (isset($_GET['cate_id']) && $_GET['cate_id'] > 0) { $cate_id = (int) $_GET['cate_id']; $link .= "&cate_id={$cate_id}"; $link_form .= "&cate_id={$cate_id}"; } else { $cate_id = -1; } $arrTotal = $model->getListProduct($product_code, $product_name, $cate_type_id, $cate_id, $is_new, $is_saleoff, $is_hot, $trangthai, -1, -1); $total_page = ceil($arrTotal['total'] / 20); $page = isset($_GET['page']) ? (int) $_GET['page'] : 1; $offset = 20 * ($page - 1); $arrList = $model->getListProduct($product_code, $product_name, $cate_type_id, $cate_id, $is_new, $is_saleoff, $is_hot, $trangthai, $offset, $limit); ?> <form id="exportForm" action="export.php"> <input type="hidden" name="product_code" value="<?php echo $product_code; ?> "> <input type="hidden" name="product_name" value="<?php echo $product_name; ?> "> <input type="hidden" name="cate_type_id" value="<?php