classes/file/file.class.php

<?php
/*******************************************************************************
 * Copyright (c) 2007 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Eclipse Foundation - initial API and implementation
*******************************************************************************/
require(BABEL_BASE_DIR . "classes/string/string.class.php");

class File {
  public $errStrs;
  
  public $file_id		= 0;
  public $project_id	= '';
  public $version		= '';
  public $name			= '';
  public $is_active 	= 0;

	
	function save() {
		$rValue = false;
		if($this->name != "" && $this->project_id != "" && $this->version != "") {
			global $App, $dbh;

			if($this->file_id == 0) {
				$this->file_id = $this->getFileID($this->name, $this->project_id, $this->version);
			}
			
			$sql 	= "INSERT INTO";
			$where = "";
			if($this->file_id > 0) {
				$sql = "UPDATE";
				$where = " WHERE file_id = " . $App->sqlSanitize($this->file_id, $dbh);
			}
			
			$Event = new EventLog("files", "file_id", $this->file_id, $sql);
			
			$sql .= " files 
						SET file_id 	= " . $App->sqlSanitize($this->file_id, $dbh) . ",
							project_id	= " . $App->returnQuotedString($App->sqlSanitize($this->project_id, $dbh)) . ", 
							version		= " . $App->returnQuotedString($App->sqlSanitize($this->version, $dbh)) . ", 
							name		= " . $App->returnQuotedString($App->sqlSanitize($this->name, $dbh)) . ",
							is_active	= 1" . $where;
			if(mysql_query($sql, $dbh)) {
				if($this->file_id == 0) {
					$this->file_id = mysql_insert_id($dbh);
					$Event->key_value = $this->file_id;
				}
				$rValue = true;
				$Event->add();
			}
			else {
				echo $sql;
				$GLOBALS['g_ERRSTRS'][1] = mysql_error();
			}
		}
		else {
			echo "ERROR: One missing:Name: " . $this->name . "Project: " . $this->project_id  . "Version: " . $this->version;
		}
		return $rValue;
	}
	
	function getFileID($_name, $_project_id, $_version) {
		$rValue = 0;
		if($this->name != "" && $this->project_id != "" && $_version != "") {
			global $App, $dbh;

			$sql = "SELECT file_id
				FROM 
					files 
				WHERE name = " . $App->returnQuotedString($App->sqlSanitize($_name, $dbh)) . "
					AND project_id = " . $App->returnQuotedString($App->sqlSanitize($_project_id, $dbh)) . "	
					AND version = '" . $App->sqlSanitize($_version, $dbh) . "'";

			$result = mysql_query($sql, $dbh);
			if($result && mysql_num_rows($result) > 0) {
				$myrow = mysql_fetch_assoc($result);
				$rValue = $myrow['file_id'];
			}
		}
		return $rValue;
	}
	
	function parseProperties($_content) {
		$rValue = "";
		if($_content != "") {
			
			global $User, $App;
			
			# step 1 - import existing strings.  $String->save() will deal with merges
			$previous_line 	= "";
			$lines 			= explode("\n", $_content);
			foreach($lines as $line) {
				if(strlen($line) > 0 && $line[0] != "#" && $line[0] != ";") {
					$line = trim($line);
					
					# Does line end with a \ ?
					if(preg_match("/\\\\$/", $line)) {
						# Line ends with \
						
						# strip the backslash
						$previous_line .= $line . "\n";
					}
					else {
						if($previous_line != "") {
							$line 			= $previous_line . $line;
							$previous_line 	= "";
						}

						$tags = explode("=", trim($line), 2);
						if(count($tags) > 1) {
							if($rValue != "") {
								$rValue .= ",";
							}
							$tags[0] = trim($tags[0]);
							$tags[1] = trim($tags[1]);
							
							$rValue .= $tags[0];
							
							$String = new String();
							$String->file_id 	= $this->file_id;
							$String->name 		= $tags[0];
							$String->value 		= $tags[1];
							$String->userid 	= $User->userid;
							$String->created_on = $App->getCURDATE();
							$String->is_active 	= 1;
							$String->save();
						}
					}
				}
			}
			
			# step 2 - remove strings that are no longer in the properties file
			$String = new String();
			$aStrings = $String->getActiveStrings($this->file_id);
			foreach ($aStrings as $String) {
				$found = false;
				
				$aStringList = explode(",",$rValue);
				foreach($aStringList as $strName) {
					if($strName == $String->name) {
						$found = true;
						break;
					}
				}
				
				if(!$found) {
					$String->deactivate($String->string_id);
				}
			}
		}
		return $rValue;
	}
}
?>