��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/modules/lhform/downloaditem.php

��ѧ٧ѧ�
<?php try { $item = erLhAbstractModelFormCollected::fetch((int)$Params['user_parameters']['collected_id']); $form = $item->form; include 'lib/core/lhform/PHPExcel.php'; $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp; $cacheSettings = array( 'memoryCacheSize ' => '64MB'); PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->getStyle('A1:AW1')->getFont()->setBold(true); // Set width foreach ($form->xls_columns_data as $key => $data) { if (isset($data['width'])) { $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($key)->setWidth($data['width']); } } // Set header $i = 0; foreach ($form->xls_columns_data as $data) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, 1, $data['name']); $i++; } $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, 1, erTranslationClassLhTranslation::getInstance()->getTranslation('form/index','Date')); $i++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, 1, 'IP'); $i++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, 1, erTranslationClassLhTranslation::getInstance()->getTranslation('form/index','Custom fields')); $i++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, 1, erTranslationClassLhTranslation::getInstance()->getTranslation('form/index','Identifier')); // Set data $i = 2; $y = 0; foreach ($form->xls_columns_data as $data) { if (isset($item->content_array[$data['attr_name']]['definition']['type']) && $item->content_array[$data['attr_name']]['definition']['type'] == 'file') { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, erLhcoreClassSystem::getHost() . erLhcoreClassDesign::baseurldirect('user/login').'/(r)/'.rawurlencode(base64_encode('form/download/'.$item->id.'/'.$data['attr_name']))); } else { if (strpos($data['attr_name'], ',') === false){ $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, $item->content_array[$data['attr_name']]['value']); } else { $nameParts = explode(',', $data['attr_name']); $valuesPart = array(); foreach ($nameParts as $part) { $valuesPart[] = isset($item->content_array[$part]['value']) ? $item->content_array[$part]['value'] : $part; } $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, implode('', $valuesPart)); } } $y++; } $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, $item->ctime_full_front); $y++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, $item->ip); $y++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, $item->custom_fields); $y++; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($y, $i, $item->identifier); $y++; $objPHPExcel->getActiveSheet()->setTitle('Report'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('var/storageform/'.$item->id.'-report.xlsx'); $zip = new ZipArchive(); $zip->open('var/storageform/'.$item->id.'-temp.zip',ZIPARCHIVE::CREATE \| ZIPARCHIVE::OVERWRITE); $zip->addFile('var/storageform/'.$item->id.'-report.xlsx','report.xlsx'); foreach ($item->content_array as $key => $content) { if ($content['definition']['type'] == 'file') { $array = explode('.',$content['value']['name']); $ext = end($array); $response = erLhcoreClassChatEventDispatcher::getInstance()->dispatch('form.file.download', array('filename' => $content['filename'])); // There was no callbacks or file not found etc, we try to download from standard location if ($response === false) { $zip->addFile( $content['filepath'] . $content['filename'],$key.'.'.$ext); } else { $zip->addFromString($key.'.'.$ext, $response['filedata']); } } } $zip->close(); header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=\"export-{$item->id}.zip\""); echo file_get_contents('var/storageform/'.$item->id.'-temp.zip'); unlink('var/storageform/'.$item->id.'-temp.zip'); unlink('var/storageform/'.$item->id.'-report.xlsx'); exit; } catch (Exception $e) { header('Location: /'); exit; } exit; ?>

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�