private function generateReport($report, $data) { global $employeeCurrent; global $settingsManager; $fileFirst = "Report_" . str_replace(" ", "_", $report->name) . "-" . date("Y-m-d_H-i-s"); $file = $fileFirst . ".csv"; $fileName = CLIENT_BASE_PATH . 'data/' . $file; $fp = fopen($fileName, 'w'); foreach ($data as $fields) { fputcsv($fp, $fields); } fclose($fp); $uploadedToS3 = false; $uploadFilesToS3 = $settingsManager->getSetting("Files: Upload Files to S3"); $uploadFilesToS3Key = $settingsManager->getSetting("Files: Amazon S3 Key for File Upload"); $uploadFilesToS3Secret = $settingsManager->getSetting("Files: Amazone S3 Secret for File Upload"); $s3Bucket = $settingsManager->getSetting("Files: S3 Bucket"); $s3WebUrl = $settingsManager->getSetting("Files: S3 Web Url"); if ($uploadFilesToS3 . '' == '1' && !empty($uploadFilesToS3Key) && !empty($uploadFilesToS3Secret) && !empty($s3Bucket) && !empty($s3WebUrl)) { $uploadname = CLIENT_NAME . "/" . $file; $s3FileSys = new S3FileSystem($uploadFilesToS3Key, $uploadFilesToS3Secret); $res = $s3FileSys->putObject($s3Bucket, $uploadname, $fileName, 'authenticated-read'); if (empty($res)) { return array("ERROR", $file); } unlink($fileName); $file_url = $s3WebUrl . $uploadname; $file_url = $s3FileSys->generateExpiringURL($file_url); $uploadedToS3 = true; } $fileObj = new File(); $fileObj->name = $fileFirst; $fileObj->filename = $file; $fileObj->file_group = "Report"; $ok = $fileObj->Save(); if (!$ok) { error_log($fileObj->ErrorMsg()); return array("ERROR", "Error generating report"); } $headers = array_shift($data); if ($uploadedToS3) { return array("SUCCESS", array($file_url, $headers, $data)); } else { return array("SUCCESS", array($file, $headers, $data)); } }
$uploadFilesToS3 = SettingsManager::getInstance()->getSetting("Files: Upload Files to S3"); $uploadFilesToS3Key = SettingsManager::getInstance()->getSetting("Files: Amazon S3 Key for File Upload"); $uploadFilesToS3Secret = SettingsManager::getInstance()->getSetting("Files: Amazone S3 Secret for File Upload"); $s3Bucket = SettingsManager::getInstance()->getSetting("Files: S3 Bucket"); $s3WebUrl = SettingsManager::getInstance()->getSetting("Files: S3 Web Url"); $uploadedToS3 = false; LogManager::getInstance()->info($uploadFilesToS3 . "|" . $uploadFilesToS3Key . "|" . $uploadFilesToS3Secret . "|" . $s3Bucket . "|" . $s3WebUrl . "|" . CLIENT_NAME); if ($uploadFilesToS3 . '' == '1' && !empty($uploadFilesToS3Key) && !empty($uploadFilesToS3Secret) && !empty($s3Bucket) && !empty($s3WebUrl)) { $localFile = CLIENT_BASE_PATH . 'data/' . $result['filename']; $f_size = filesize($localFile); $uploadname = CLIENT_NAME . "/" . $result['filename']; LogManager::getInstance()->info("Upload file to s3:" . $uploadname); LogManager::getInstance()->info("Local file:" . $localFile); LogManager::getInstance()->info("Local file size:" . $f_size); $s3FileSys = new S3FileSystem($uploadFilesToS3Key, $uploadFilesToS3Secret); $res = $s3FileSys->putObject($s3Bucket, $uploadname, $localFile, 'authenticated-read'); $file_url = $s3WebUrl . $uploadname; $file_url = $s3FileSys->generateExpiringURL($file_url); LogManager::getInstance()->info("Response from s3 file sys:" . print_r($res, true)); unlink($localFile); $uploadedToS3 = true; } if ($result['success'] == 1) { $file->name = $saveFileName; $file->filename = $result['filename']; $signInMappingField = SIGN_IN_ELEMENT_MAPPING_FIELD_NAME; $file->{$signInMappingField} = $_POST['user'] == "_NONE_" ? null : $_POST['user']; $file->file_group = $_POST['file_group']; $file->Save(); if ($uploadedToS3) { $result['data'] = $file_url;
public function checkAddSmallProfileImage($profileImage) { $file = new File(); $file->Load('name = ?', array($profileImage->name . "_small")); if (empty($file->id)) { LogManager::getInstance()->info("Small profile image " . $profileImage->name . "_small not found"); $largeFileUrl = $this->getFileUrl($profileImage->name); $file->name = $profileImage->name . "_small"; $signInMappingField = SIGN_IN_ELEMENT_MAPPING_FIELD_NAME; $file->{$signInMappingField} = $profileImage->{$signInMappingField}; $file->filename = $file->name . str_replace($profileImage->name, "", $profileImage->filename); $file->file_group = $profileImage->file_group; file_put_contents("/tmp/" . $file->filename . "_orig", file_get_contents($largeFileUrl)); if (file_exists("/tmp/" . $file->filename . "_orig")) { //Resize image to 100 $img = new abeautifulsite\SimpleImage("/tmp/" . $file->filename . "_orig"); $img->fit_to_width(100); $img->save("/tmp/" . $file->filename); $uploadFilesToS3Key = SettingsManager::getInstance()->getSetting("Files: Amazon S3 Key for File Upload"); $uploadFilesToS3Secret = SettingsManager::getInstance()->getSetting("Files: Amazone S3 Secret for File Upload"); $s3Bucket = SettingsManager::getInstance()->getSetting("Files: S3 Bucket"); $uploadname = CLIENT_NAME . "/" . $file->filename; $localFile = "/tmp/" . $file->filename; $s3FileSys = new S3FileSystem($uploadFilesToS3Key, $uploadFilesToS3Secret); $result = $s3FileSys->putObject($s3Bucket, $uploadname, $localFile, 'authenticated-read'); unlink("/tmp/" . $file->filename); unlink("/tmp/" . $file->filename . "_orig"); LogManager::getInstance()->info("Upload Result:" . print_r($result, true)); if (!empty($result)) { $ok = $file->Save(); } return $file; } return null; } return $file; }
private function generateReport($report, $data) { $fileFirst = "Report_" . str_replace(" ", "_", $report->name) . "-" . date("Y-m-d_H-i-s"); $file = $fileFirst . ".csv"; if ($report->query == "EmployeeAttendanceReport") { //echo MODULE_PATH.'\reportClasses\xlswriter.class.php'; $file = $fileFirst . ".xlsx"; require_once APP_BASE_PATH . '\\classes\\PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("HRIS SGTSI")->setTitle("Employee Attendance"); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('Sheet1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Employee ID'); $objPHPExcel->getActiveSheet()->setCellValue('B1', $data[1][0]); $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name'); $objPHPExcel->getActiveSheet()->setCellValue('B2', $data[1][1]); $objPHPExcel->getActiveSheet()->setCellValue('A3', 'From ' . date("M d, Y", strtotime($_REQUEST['date_start']))); $objPHPExcel->getActiveSheet()->setCellValue('B3', 'To ' . date("M d, Y", strtotime($_REQUEST['date_end']))); $objPHPExcel->getActiveSheet()->setCellValue('A4', 'Date'); $objPHPExcel->getActiveSheet()->setCellValue('B4', 'Time In'); $objPHPExcel->getActiveSheet()->setCellValue('C4', 'Time Out'); $objPHPExcel->getActiveSheet()->setCellValue('D4', 'Notes'); $column = 5; foreach ($data as $key => $row) { if ($key != 0) { //echo PHPExcel_Shared_Date::PHPToExcel( strtotime($row[2]) ).",".strtotime($row[2])." <br/> "; //echo "<br/>".PHPExcel_Shared_Date::PHPToExcel( strtotime($row[2]) ); $objPHPExcel->getActiveSheet()->setCellValue('A' . $column, PHPExcel_Shared_Date::PHPToExcel(strtotime($row[2]))); $objPHPExcel->getActiveSheet()->getStyle('A' . $column)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2); $objPHPExcel->getActiveSheet()->setCellValue('B' . $column, PHPExcel_Shared_Date::PHPToExcel(strtotime($row[2]))); $objPHPExcel->getActiveSheet()->getStyle('B' . $column)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1); $objPHPExcel->getActiveSheet()->setCellValue('C' . $column, PHPExcel_Shared_Date::PHPToExcel(strtotime($row[3]))); $objPHPExcel->getActiveSheet()->getStyle('C' . $column)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1); $objPHPExcel->getActiveSheet()->setCellValue('D' . $column, $row[4]); $column++; } } $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save(CLIENT_BASE_PATH . 'data/' . $file); // require_once MODULE_PATH.'\reportClasses\xlsxwriter.class.php'; // $file=$fileFirst.".xlsx"; // $writer=new XLSXWriter(); // $writer->setAuthor('SPARK HRIS'); // $writer->writeSheetRow('Sheet1',array('Employee ID',$data[1][0])); // $writer->writeSheetRow('Sheet1',array('Name',$data[1][1])); // $writer->writeSheetRow('Sheet1',array('From '.date("M d, Y",strtotime($_REQUEST['date_start'])),'To '.date("M d, Y",strtotime($_REQUEST['date_end'])))); // $writer->writeSheetRow('Sheet1',array('Date','Tme IN','TimeOUT','Notes')); // // $sheetdata=array(); // // $sheetdata[]=array('Employee ID',$data[1][0]); // // $sheetdata[]=array('Name',$data[1][1])); // //$sheetdata[]=array('From '.date("M d, Y",strtotime($_REQUEST['date_start'])),'To '.date("M d, Y",strtotime($_REQUEST['date_end']))); // //$sheetdata[]=array('Date','Tme IN','TimeOUT','Notes'); // foreach ($data as $key=>$fields) { // if ($key<>0){ // $row=array(); // // $row[]=date("n/d/Y",strtotime($fields[2])); // // $row[]=date("g:i A",strtotime($fields[2])); // // $row[]=date("g:i A",strtotime($fields[3])); // $d1=new DateTime($fields[2]); // $d2=new DateTime($fields[2]); // $d3=new DateTime($fields[3]); // $row[]=$d1->format('n/d/Y'); // $row[]=$d2->format('g:i A'); // $row[]=$d3->format('g:i A'); // $row[]=$fields[4]; // $writer->MywriteSheetRow('Sheet1',$row); // } // } // $writer->writeToFile( CLIENT_BASE_PATH.'data/'.$file); } else { $fileName = CLIENT_BASE_PATH . 'data/' . $file; $fp = fopen($fileName, 'w'); foreach ($data as $fields) { fputcsv($fp, $fields); } fclose($fp); } $uploadedToS3 = false; $uploadFilesToS3 = SettingsManager::getInstance()->getSetting("Files: Upload Files to S3"); $uploadFilesToS3Key = SettingsManager::getInstance()->getSetting("Files: Amazon S3 Key for File Upload"); $uploadFilesToS3Secret = SettingsManager::getInstance()->getSetting("Files: Amazone S3 Secret for File Upload"); $s3Bucket = SettingsManager::getInstance()->getSetting("Files: S3 Bucket"); $s3WebUrl = SettingsManager::getInstance()->getSetting("Files: S3 Web Url"); if ($uploadFilesToS3 . '' == '1' && !empty($uploadFilesToS3Key) && !empty($uploadFilesToS3Secret) && !empty($s3Bucket) && !empty($s3WebUrl)) { $uploadname = CLIENT_NAME . "/" . $file; $s3FileSys = new S3FileSystem($uploadFilesToS3Key, $uploadFilesToS3Secret); $res = $s3FileSys->putObject($s3Bucket, $uploadname, $fileName, 'authenticated-read'); if (empty($res)) { return array("ERROR", $file); } unlink($fileName); $file_url = $s3WebUrl . $uploadname; $file_url = $s3FileSys->generateExpiringURL($file_url); $uploadedToS3 = true; } $fileObj = new File(); $fileObj->name = $fileFirst; $fileObj->filename = $file; $fileObj->file_group = "Report"; $ok = $fileObj->Save(); if (!$ok) { LogManager::getInstance()->info($fileObj->ErrorMsg()); return array("ERROR", "Error generating report"); } $headers = array_shift($data); if ($uploadedToS3) { return array("SUCCESS", array($file_url, $headers, $data)); } else { return array("SUCCESS", array($file, $headers, $data)); } }