Exemple #1
0
 public function attachments()
 {
     /** @var myModel $this */
     return $this->make('attachments', function () {
         return Attachments::query()->where('attachable_id = :id:', ['id' => $this->id])->andWhere('attachable_type = :type:', ['type' => get_class($this)])->orderBy('created_at DESC')->execute();
     });
 }
Exemple #2
0
 public function createZipFile(array $file_Ids, $filename)
 {
     $files = Attachments::query()->inWhere('attachable_id', $file_Ids)->andWhere('attachable_type =:type:', ['type' => 'Files'])->leftJoin('Files', 'file.id = Attachments.attachable_id', 'file')->columns(['Attachments.*', 'file.*'])->execute();
     $path = 'E:\\php\\standard\\public/';
     $zip = new ZipArchive();
     if ($zip->open($path . $filename, ZIPARCHIVE::CREATE) !== TRUE) {
         dd('无法生成ZIP文件,请检查是否具有写权限');
     }
     foreach ($files as $row) {
         $zip->addFile($path . $row->attachments->url, $row->file->title . '/' . $row->attachments->name);
         $zip->addFromString($row->file->title . '/info.txt', $this->getFileInfo($row->file));
         //@todo 将来用能够代表文档的数据形式来替代
     }
     $zip->close();
     return $filename;
 }