Category Archives: Custom Scripts

PHPExcel

	public function excel_get(){
		$this->check_login();

		$file = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'Members.xls';
		$file_url = base_url() . 'uploads/Members.xls';
		
		// Initiate cache
		$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
		$cacheSettings = array( 'memoryCacheSize' => '32MB');
		PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
		$objPHPExcel = new PHPExcel();

		//Create $worksheet object to save data
		$worksheet = $objPHPExcel->setActiveSheetIndex(0);
		$rowN = 1;
		$columnN = 0;

		$headers = array(
			'ID', 
			'姓名', 
			'性別', 
			'生日', 
			'國碼', 
			'電話', 
			'國家', 
			'身份證明', 
			'單位', 
			'居住地', 
			'Email', 
			'建立時間', 
			'作者介紹', 
			'劇本名', 
			'投稿組別', 
			'劇本大綱', 
			'是否參與其他競賽', 
			'劇本發表', 
			'PDF', 
			'Word', 
			'上傳時間' 
		);
		foreach($headers as $value){
            $worksheet->setCellValueByColumnAndRow($columnN, $rowN, $value);
			$columnN++;
		}

		$members = $this->competition_m->get_items(false);
		$rowN++;
		foreach($members as $member){
			$data = array(
				$member->id, 
				$member->name, 
				($member->gender == 'f') ? '女' : '男', 
				$member->birthday, 
				$member->phone_country_code, 
				$member->phone, 
				$member->country, 
				$member->attachment, 
				$member->company, 
				$member->city, 
				$member->email, 
				$member->created_time, 
				$member->introduction, 
				$member->title, 
				$member->language, 
				$member->summary, 
				($member->exclusive == 1) ? '是' : '否', 
				($member->public == 1) ? '是' : '否', 
				$member->pdf, 
				$member->word, 
				$member->upload_time
			);

			$columnN = 0;
			foreach($data as $value){
	            $worksheet->setCellValueByColumnAndRow($columnN, $rowN, $value);
				$columnN++;
			}

			$rowN++;
		}

		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
		$objWriter->save($file);

		$this->success_response($file_url);
	}

public function excel_get(){

$this->check_login();

$file = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'Members.xls';

$file_url = base_url() . 'uploads/Members.xls';

// Initiate cache

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;

$cacheSettings = array( 'memoryCacheSize' => '32MB');

PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

$objPHPExcel = new PHPExcel();

//Create $worksheet object to save data

$worksheet = $objPHPExcel->setActiveSheetIndex(0);

$rowN = 1;

$columnN = 0;

$headers = array(

'ID',

'姓名',

'性別',

'生日',

'國碼',

'電話',

'國家',

'身份證明',

'單位',

'居住地',

'Email',

'建立時間',

'作者介紹',

'劇本名',

'投稿組別',

'劇本大綱',

'是否參與其他競賽',

'劇本發表',

'PDF',

'Word',

'上傳時間'

);

foreach($headers as $value){

$worksheet->setCellValueByColumnAndRow($columnN, $rowN, $value);

$columnN++;

}

$members = $this->competition_m->get_items(false);

$rowN++;

foreach($members as $member){

$data = array(

$member->id,

$member->name,

($member->gender == 'f') ? '女' : '男',

$member->birthday,

$member->phone_country_code,

$member->phone,

$member->country,

$member->attachment,

$member->company,

$member->city,

$member->email,

$member->created_time,

$member->introduction,

$member->title,

$member->language,

$member->summary,

($member->exclusive == 1) ? '是' : '否',

($member->public == 1) ? '是' : '否',

$member->pdf,

$member->word,

$member->upload_time

);

$columnN = 0;

foreach($data as $value){

$worksheet->setCellValueByColumnAndRow($columnN, $rowN, $value);

$columnN++;

}

$rowN++;

}

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save($file);

$this->success_response($file_url);

}

常用方法:

Create Custom ZIP File

	public function download_get(){
		$this->check_login();

		$zip = new ZipArchive();
		$dest = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'all_works.zip';
		$dest_url = base_url() . 'uploads/all_works.zip';
		//log_g($dest);

		$open = $zip->open($dest, ZIPARCHIVE::OVERWRITE);
		//log_g($open);
		if($open !== true) {
			$this->failed_response(0, '無法建立壓縮檔');
		}
		
		$root = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'members' . DIRECTORY_SEPARATOR;
		//log_g($dest);

		$members = $this->competition_m->get_items(false);
		foreach($members as $member){
			if(isset($member->pdf) == false || $member->pdf == ''){
				continue;
			}

			$member_root = $root . $member->id . DIRECTORY_SEPARATOR . 'competition_2014' . DIRECTORY_SEPARATOR;
			$pdf = $member_root . basename($member->pdf);
			$word = $member_root . basename($member->word);

			$folder = $member->country . '_' . $member->email;
			//$folder = iconv("UTF-8", "BIG-5//TRANSLIT", $member->name);
			//log_g($member_name);
			$zip->addFile($pdf, $folder . '/' . basename($member->pdf));
			$zip->addFile($word, $folder . '/' . basename($member->word));
		}

		$zip->close();

		$this->success_response($dest_url);
	}

public function download_get(){

$this->check_login();

$zip = new ZipArchive();

$dest = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'all_works.zip';

$dest_url = base_url() . 'uploads/all_works.zip';

//log_g($dest);

$open = $zip->open($dest, ZIPARCHIVE::OVERWRITE);

//log_g($open);

if($open !== true) {

$this->failed_response(0, '無法建立壓縮檔');

}

$root = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'members' . DIRECTORY_SEPARATOR;

//log_g($dest);

$members = $this->competition_m->get_items(false);

foreach($members as $member){

if(isset($member->pdf) == false || $member->pdf == ''){

continue;

}

$member_root = $root . $member->id . DIRECTORY_SEPARATOR . 'competition_2014' . DIRECTORY_SEPARATOR;

$pdf = $member_root . basename($member->pdf);

$word = $member_root . basename($member->word);

$folder = $member->country . '_' . $member->email;

//$folder = iconv("UTF-8", "BIG-5//TRANSLIT", $member->name);

//log_g($member_name);

$zip->addFile($pdf, $folder . '/' . basename($member->pdf));

$zip->addFile($word, $folder . '/' . basename($member->word));

}

$zip->close();

$this->success_response($dest_url);

}

Upload File Using Upload Handler Class

	function upload_id_attachment($member_id){
		$upload_dir = $this->upload_handler->std_path('uploads/members/' . $member_id . '/register/');
		$options = array(
			'upload_dir' => FCPATH . $upload_dir,
            'upload_url' => base_url() . 'uploads/members/' . $member_id . '/register/',
            'change_name' => true
		);

		$result = $this->upload_handler->upload($options);
		if($result == false){
			$this->failed_response(0, $this->upload_handler->err);
		}

		return $result;
	}

function upload_id_attachment($member_id){

$upload_dir = $this->upload_handler->std_path('uploads/members/' . $member_id . '/register/');

$options = array(

'upload_dir' => FCPATH . $upload_dir,

'upload_url' => base_url() . 'uploads/members/' . $member_id . '/register/',

'change_name' => true

);

$result = $this->upload_handler->upload($options);

if($result == false){

$this->failed_response(0, $this->upload_handler->err);

}

return $result;

}

Check Path and Create Directories

	function check_dir($dir){
		//Linux: "/home/wsdc/public_html/uploads/members/28/register/"
		//Windows: "D:\web_wsdc\uploads\members\34\register\"
		$dir_parts = explode(DIRECTORY_SEPARATOR, $dir);

		if(DIRECTORY_SEPARATOR == '/'){//Linux
			$path = '/';
		}else{//windows
			$path = '';
		}
		//log_g($dir);

		foreach ($dir_parts as $key => $value) {
			if($value == '') continue;

			$path .= $value . DIRECTORY_SEPARATOR;
			//log_g($path);
			if(file_exists($path) == false){
				$old = umask(0);
				mkdir($path, 0777);
				umask($old);
			}
		}

		//log_g($path);
	}

function check_dir($dir){

//Linux: "/home/wsdc/public_html/uploads/members/28/register/"

//Windows: "D:\web_wsdc\uploads\members\34\register\"

$dir_parts = explode(DIRECTORY_SEPARATOR, $dir);

if(DIRECTORY_SEPARATOR == '/'){//Linux

$path = '/';

}else{//windows

$path = '';

}

//log_g($dir);

foreach ($dir_parts as $key => $value) {

if($value == '') continue;

$path .= $value . DIRECTORY_SEPARATOR;

//log_g($path);

if(file_exists($path) == false){

$old = umask(0);

mkdir($path, 0777);

umask($old);

}