X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/480abba5e6b6395dd8314392274e041f4f018fa7..0e6900be0bcfc882505ec4c8b8730a798985bc80:/WEB-INF/lib/ttFileHelper.class.php diff --git a/WEB-INF/lib/ttFileHelper.class.php b/WEB-INF/lib/ttFileHelper.class.php index 611df39e..af470c71 100644 --- a/WEB-INF/lib/ttFileHelper.class.php +++ b/WEB-INF/lib/ttFileHelper.class.php @@ -28,15 +28,132 @@ // ttFileHelper class is used for attachment handling. class ttFileHelper { - var $errors = null; // Errors go here. Set in constructor by reference. + var $errors = null; // Errors go here. Set in constructor by reference. + var $storage_uri = null; // Location of file storage facility. + var $register_uri = null; // URI to register with file storage facility. + var $putfile_uri = null; // URI to put file in file storage. + var $getfile_uri = null; // URI to get file from file storage. + var $site_id = null; // Site id for file storage. + var $site_key = null; // Site key for file storage. // Constructor. function __construct(&$errors) { $this->errors = &$errors; + + if (defined('FILE_STORAGE_URI')) { + $this->storage_uri = FILE_STORAGE_URI; + $this->register_uri = $this->storage_uri.'register'; + $this->putfile_uri = $this->storage_uri.'putfile'; + $this->getfile_uri = $this->storage_uri.'getfile'; + $this->checkSiteRegistration(); + } + } + + // checkSiteRegistration - obtains site id and key from local database. + // If not found, it tries to register with file stroage facility. + function checkSiteRegistration() { + + global $i18n; + $mdb2 = getConnection(); + + // Obtain site id. + $sql = "select param_value as id from tt_site_config where param_name = 'locker_id'"; + $res = $mdb2->query($sql); + $val = $res->fetchRow(); + if (!$val) { + // No site id found, need to register. + $fields = array('name' => urlencode('time tracker'), + 'origin' => urlencode('time tracker source')); + + // Urlify the data for the POST. + foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; } + $fields_string = rtrim($fields_string, '&'); + + // Open connection. + $ch = curl_init(); + + // Set the url, number of POST vars, POST data. + curl_setopt($ch, CURLOPT_URL, $this->register_uri); + curl_setopt($ch, CURLOPT_POST, count($fields)); + curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string); + curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); + + // Execute a post request. + $result = curl_exec($ch); + + // Close connection. + curl_close($ch); + + if ($result) { + $result_array = json_decode($result, true); + if ($result_array && $result_array['id'] && $result_array['key']) { + + $this->site_id = $mdb2->quote($result_array['id']); + $this->site_key = $mdb2->quote($result_array['key']); + + // Registration successful. Store id and key locally for future use. + $sql = "insert into tt_site_config values('locker_id', $site_id, now(), null)"; + $mdb2->exec($sql); + $sql = "insert into tt_site_config values('locker_key', $key, now(), null)"; + $mdb2->exec($sql); + } else { + $this->errors->add($i18n->get('error.file_storage')); + } + } + } else { + // Site id found, need to update site attributes. + $this->site_id = $val['id']; + + // Obtain site key. + $sql = "select param_value as site_key from tt_site_config where param_name = 'locker_key'"; + $res = $mdb2->query($sql); + $val = $res->fetchRow(); + $this->site_key = $val['site_key']; + } } // putFile - puts uploaded file in remote storage. - function putFile() { + function putFile($fields) { + $mdb2 = getConnection(); + + $fields = array('site_id' => urlencode($this->site_id), + 'site_key' => urlencode($this->site_key), + //'org_id' => urlencode($this->org_id), // TODO: obtain this properly. + //'org_key' => urlencode($this->org_key), // TODO: obtain this properly. + //'group_id' => urlencode($this->group_id), // TODO: obtain this properly. + //'group_key' => urlencode($this->group_key), // TODO: obtain this properly. + //'user_id' => urlencode($this->user_id), // TODO: obtain this properly. + //'user_key' => urlencode($this->user_key), // TODO: obtain this properly. + 'file_name' => urlencode($fields['file_name']), + 'description' => urlencode($fields['description']), + // TODO: add file content here, too. Will this work for large files? + // + ); + + // url-ify the data for the POST. + foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; } + $fields_string = rtrim($fields_string, '&'); + + // Open connection. + $ch = curl_init(); + + // Set the url, number of POST vars, POST data. + curl_setopt($ch, CURLOPT_URL, $this->putfile_uri); + curl_setopt($ch, CURLOPT_POST, count($fields)); + curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string); + curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); + + // Execute a post rewuest. + $result = curl_exec($ch); + + // Close connection. + curl_close($ch); + + if ($result) { + $result_array = json_decode($result, true); + $file_id = $result_array['file_id']; + $file_key = $result_array['file_key']; + } unlink($_FILES['newfile']['tmp_name']); return false; // Not implemented.