/**
* Inserts uploaded file into database
* @param array $file
*/
public function newFile($file, $path)
{
$sql = "SELECT id FROM *PREFIX*mimetypes WHERE mimetype = '" . $file['mimetype'] . "'";
$res = $this->connect->query($sql);
$mimetype = $res['id'];
$sql = "SELECT numeric_id FROM *PREFIX*storages WHERE id = 'home::" . $file['owner'] . "'";
$res = $this->connect->query($sql);
$storageid = $res['numeric_id'];
$sql = "SELECT fileid FROM *PREFIX*filecache WHERE path = '" . $file['path'] . "'";
$res = $this->connect->query($sql);
$parent = $res['fileid'];
//$path = '/var/www/owncloud.loc/data/admin/files/Photos/San Francisco.jpg';
list($storage, $internalPath) = \OC\Files\Filesystem::resolvePath($path . '/' . $file['filename']);
$etag = $storage->getETag($internalPath);
$data = array('storage' => $storageid, 'path' => $file['path'] . '/' . $file['filename'], 'path_hash' => md5($file['path'] . '/' . $file['filename']), 'parent' => $parent, 'name' => $file['filename'], 'mimetype' => $mimetype, 'mimepart' => 5, 'size' => $file['size'], 'mtime' => $file['mtime'], 'storage_mtime' => $file['storage_mtime'], 'etag' => $etag, 'permissions' => \OCP\Constants::PERMISSION_ALL);
$filecache = $this->save($data);
/* file_put_contents('/tmp/inb.log', "\nPath : /\n", FILE_APPEND);
try {
$fileInfo = \OC\Files\Filesystem::getFileInfo('/', false);
}
catch (\Exception $e) {
file_put_contents('/tmp/inb.log', "\nGet File Info error : " . $e->getMessage() . "\n", FILE_APPEND);
}
file_put_contents('/tmp/inb.log', "\nFile info : " . print_r($fileInfo, true) . "\n", FILE_APPEND);
try {
$icon = \OCA\Files\Helper::determineIcon($fileInfo);
}
catch (\Exception $e) {
file_put_contents('/tmp/inb.log', "\nDetermine Icon error : " . $e->getMessage() . "\n", FILE_APPEND);
} */
$activity = array('activity_id' => NULL, 'timestamp' => $file['mtime'], 'priority' => 30, 'type' => 'file_created', 'user' => $file['owner'], 'affecteduser' => $file['owner'], 'app' => 'files', 'subject' => 'created_self', 'subjectparams' => '["\\/' . $file['filename'] . '"]', 'message' => '', 'messageparams' => '[]', 'file' => '/' . $file['filename'], 'link' => $file['domain'] . '/index.php/apps/files?dir=%2F', 'object_type' => 'files', 'object_id' => $filecache);
$id = $this->connect->insert('*PREFIX*activity', $activity);
if ($id) {
return $filecache;
} else {
return false;
}
}
public function addtoActivity($data)
{
return $this->connect->insert('*PREFIX*activity', $data)->execute();
}
public function startInsert($uid)
{
return $this->connect->insert($this->tableName, ['name' => 'Project', 'create_uid' => $uid]);
}
public function save($data)
{
$message = $this->connect->insert($this->tableName, $data);
return $message;
}
public function save($data)
{
$user = $this->connect->insert($this->tableName, $data);
return $user;
}
