X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/801da0e379cfd72ee9b3f9d6e2718989bb5a1d80..d47f034f5d1b5e70185507046dc09df7c1299d81:/WEB-INF/lib/ttFileHelper.class.php diff --git a/WEB-INF/lib/ttFileHelper.class.php b/WEB-INF/lib/ttFileHelper.class.php index 7273d808..aad91e9f 100644 --- a/WEB-INF/lib/ttFileHelper.class.php +++ b/WEB-INF/lib/ttFileHelper.class.php @@ -28,15 +28,122 @@ // 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() { + $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 { + // 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 storage. - function putFile() { + // putFile - puts uploaded file in remote storage. + function putFile($description) { + + $url = $this->storage_uri; + $fields = array('description' => urlencode($description), +// 'fname' => urlencode($_POST['first_name']), +// 'title' => urlencode($_POST['title']), +// 'company' => urlencode($_POST['institution']), +// 'age' => urlencode($_POST['age']), +// 'email' => urlencode($_POST['email']), +// 'phone' => urlencode($_POST['phone']) + ); + + // 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, $url); + 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 = $mdb2->quote($result_array['id']); + } unlink($_FILES['newfile']['tmp_name']); return false; // Not implemented.