protected function genCreditCardDealReport($filename) { $self = $this; return Excel::create($filename, function ($excel) use($self) { $formatArr = ['J' => '@', 'K' => '@', 'L' => '@', 'M' => '@', 'N' => '@', 'O' => '@', 'P' => '@', 'Q' => '@', 'R' => '@', 'S' => '@', 'T' => '@', 'U' => '@', 'V' => '0', 'B' => '@', 'H' => '@', 'F' => '0', 'G' => '0']; ExcelHelper::genBasicSheet($excel, '表格', $formatArr, 'V', $self->getCreditCardDealQuery(), $self->genCreditCardDealHead()); }); }
public function process() { $self = $this; Excel::create($this->getFileName(), function ($excel) use($self) { ExcelHelper::genBasicSheet($excel, '銷貨', ['C' => '@', 'G' => '@', 'I' => '@'], 'K', $self->getSaleQuery(), $self->getExportHead()['sale']); ExcelHelper::genBasicSheet($excel, '退貨', ['C' => '@', 'G' => '@', 'I' => '@'], 'K', $self->getBackQuery(), $self->getExportHead()['back']); })->store('xls', storage_path('excel/exports')); return $msg = $this->send(); }
public function process() { set_time_limit(0); ini_set('memory_limit', '512M'); $self = $this; Excel::create($this->getFileName(), function ($excel) use($self) { ExcelHelper::genBasicSheet($excel, '表格', ['A' => '@', 'B' => '@', 'L' => '@', 'N' => '@', 'O' => '@'], 'Q', $self->getQuery(), $self->getExportHead()); })->store('xls', storage_path('excel/exports')); return $msg = $this->send(); }
public function process() { Excel::create($this->getFileName(), function ($excel) { $params = $this->getBascitSheetParams(); ExcelHelper::genBasicSheet($excel, $params[0], $params[1], $params[2], $params[3], $params[4]); })->store(ExportExcel::XLS, storage_path('excel/exports')); Mail::send('emails.creditCard', ['title' => $this->getSubject()], function ($m) { $m->subject($this->getSubject())->attach($this->getFilePath()); $m->to($this->getToList())->cc($this->getCCList()); }); return "{$this->getSubject()} send complete!"; }
public function process() { Excel::create($this->getFileName(), function ($excel) { $excel->setTitle('進銷退明細'); $excel->setCreator('*****@*****.**')->setCompany('chinghwa'); $excel->setDescription(ExportExcel::SPB_FILENAME); ExcelHelper::genBasicSheet($excel, '退貨原因', array('G' => '@'), 'K', $this->getBackReasonQuery(), $this->getExportHead()['backReason']); ExcelHelper::genBasicSheet($excel, '進貨單', array('G' => '@'), 'N', $this->getPurchaseQuery(), $this->getExportHead()['purchase']); ExcelHelper::genBasicSheet($excel, '樣品出貨單', array('G' => '@'), 'N', $this->getSampleDispatchQuery(), $this->getExportHead()['sampleDispatch']); ExcelHelper::genBasicSheet($excel, '樣品退回單', array('G' => '@'), 'N', $this->getSampleBackQuery(), $this->getExportHead()['sampleBack']); ExcelHelper::genBasicSheet($excel, '調撥單據', array('G' => '@'), 'N', $this->getAllocateQuery(), $this->getExportHead()['allocate']); ExcelHelper::genBasicSheet($excel, '銷貨退回', array('G' => '@'), 'N', $this->getSoldBackQuery(), $this->getExportHead()['soldBack']); ExcelHelper::genBasicSheet($excel, '銷貨單', array('G' => '@'), 'N', $this->getSellQuery(), $this->getExportHead()['sell']); })->store('xls', storage_path('excel/exports')); $msg = $this->send(); return $msg; }
public function process() { if (!$this->hasToSend()) { return '員購銷貨單 No Task!'; } $self = $this; Excel::create($this->getFileName(), function ($excel) use($self) { // Set the title $excel->setTitle('員購銷貨單'); // Chain the setters $excel->setCreator('*****@*****.**')->setCompany('chinghwa'); // Call them separately $excel->setDescription(ExportExcel::EMPP_FILENAME); ExcelHelper::genBasicSheet($excel, '表格', ['C' => '@', 'G' => '@', 'I' => '@'], 'K', $self->getQuery(), $self->getExportHead()); })->store('xls', storage_path('excel/exports')); $msg = $this->send(); return $msg; }