public function actionDownload($type = 'none', $value = 'none')
{
// for($col = 'A'; $col !== 'G'; $col++) {
// $ea->getActiveSheet()
// ->getColumnDimension($col)
// ->setAutoSize(true);
// }
//
if ($type == '' && $value == '') {
$couponDetail = new Coupon();
$result = $couponDetail->couponDetail();
} else {
if ($type == 'category') {
$couponDetail = new Coupon();
$result = $couponDetail->couponDetailByCategory($value);
} else {
if ($type == 'coupontype') {
$couponDetail = new Coupon();
$result = $couponDetail->couponDetailByType($value);
} else {
if ($type == 'store') {
$couponDetail = new Coupon();
$result = $couponDetail->couponDetailBySite($value);
}
}
}
}
$data = array();
array_push($data, array('Coupon Type' => "Coupon Type", 'Store name' => 'Store name', 'Coupon Description' => 'Coupon Description', 'Coupon Expiry' => 'Coupon Expiry', 'Coupon Code' => 'Coupon Code', 'store url' => 'Store URL'));
foreach ($result as $row) {
array_push($data, array('Coupon Type' => $row['CouponType'], 'Store name' => $row['Site'], 'Coupon Description' => $row['Description'], 'Coupon Expiry' => 100, 'Coupon Code' => $row['CouponCode'], 'store url' => $row['url']));
}
//return $this->render('testing',['data'=>$data]);
// Create new PHPExcel object ea
$ea = new \PHPExcel();
// Fill worksheet from values in array
$ea->getActiveSheet()->fromArray($data, null, 'A1', true);
// ->setAutoSize(true);
// Rename worksheet
$ea->getActiveSheet()->setTitle('Members');
// to save the file
$writer = \PHPExcel_IOFactory::createWriter($ea, 'Excel2007');
$writer->setIncludeCharts(true);
$writer->save('downloadedCoupon.xlsx');
$fileLocation = '../web/downloadedCoupon.xlsx';
}
