public function moveTmpFileToFile($userId, $insertToken, $articleId)
{
$valid = false;
if ($userId && $insertToken) {
$uploadTmpTbl = new VC_DbTable_Common("upload_tmp", "id");
$listTmpUploadFiles = $uploadTmpTbl->fetchAll("user_id = " . $userId . " AND insert_token = '" . $insertToken . "'");
$fileTbl = new VC_DbTable_Common("store_file", "id");
$articleFileTbl = new VC_DbTable_Common("store_article_file", "article_id");
foreach ($listTmpUploadFiles as $tmpFile) {
$fileData = array();
$fileData['name'] = $tmpFile['file_name'];
$fileData['file_name'] = $tmpFile['file_name'];
$fileData['user_id'] = $userId;
$fileData['file_path'] = $tmpFile['file_path'];
$fileData['icon_path'] = $tmpFile['icon_path'];
$fileData['upload_date'] = $tmpFile['upload_date'];
$fileId = $fileTbl->insert($fileData);
//Insert into article_file
$articleFileTbl->insert(array('article_id' => $articleId, 'file_id' => $fileId, "user_id" => $userId));
}
//Remove old file
$oldFileSql = "CURDATE() - INTERVAL 2 DAY >= upload_date";
$allOldFile = $uploadTmpTbl->fetchAll($oldFileSql);
foreach ($allOldFile as $oldFile) {
@unlink(ROOT_PATH . '/Sources/store/public' . $oldFile->file_path);
}
//Remove all file by token and post time
$delSql = "(user_id = " . $userId . " AND insert_token = '" . $insertToken . "') ";
$delSql .= " OR CURDATE() - INTERVAL 2 DAY >= upload_date";
$uploadTmpTbl->delete($delSql);
//delete file in hdd
$valid = true;
}
return $valid;
}
public function editAction()
{
$articleId = (int) $this->_getParam('id');
if ($articleId == 0) {
throw new VC_Exception("Invalid article delete information");
}
$insertTokenNamespace = new Zend_Session_Namespace("INSERT_TOKEN");
$message = "";
//Check if this article belong with this user
$articleTbl = new VC_DbTable_Store_Article();
$article = $articleTbl->findByIdAndUserId($articleId, $this->userId);
if ($article) {
if ($this->_getParam('submit')) {
if ($this->_getParam('title') && $this->_getParam('content') && $this->_getParam('tpid')) {
$updateData = array();
$updateData['title'] = $this->_getParam('title');
$updateData['content'] = $this->_getParam('content');
$updateData['root_link'] = $this->_getParam('root_link');
$updateData['topic_id'] = $this->_getParam('tpid');
$articleTbl->update($updateData, "id = " . $articleId);
$this->_redirect("article/view/?tpid=" . $article->topic_id . "&id=" . $articleId);
} else {
$message = "Bạn phải nhập đầy đủ các phần có dấu sao (*)";
}
}
$menuObj = new VC_Business_MenuFactory();
$groupAndTopic = $menuObj->getGroupsAndTopicsOfUser($this->userId);
//echo "<pre>"; var_dump($groupAndTopic); echo "</pre>"; die;
$this->view->groupAndTopic = $groupAndTopic;
$this->view->message = $message;
$this->view->article = $article;
$this->view->insertToken = $insertTokenNamespace->insertToken;
//Get all temp file uploaded of this article
$uploadTmpTbl = new VC_DbTable_Common("upload_tmp", "id");
$this->view->listUploadFiles = $uploadTmpTbl->fetchAll("user_id = " . $this->userId . " AND insert_token = '" . $insertTokenNamespace->insertToken . "'");
} else {
throw new VC_Exception("This article not belong with you");
}
}
public function indexAction()
{
if ($this->userId == 0) {
throw new VC_Exception("You have not permission");
}
$invidualDir = 'u_' . $this->userId;
$this->_helper->viewRenderer->setNoRender();
$this->_helper->getHelper('layout')->disableLayout();
$uploadRootDir = ROOT_PATH . '/Sources/store/public/uploads';
$uploadDir = $uploadRootDir . '/' . $invidualDir;
if (!is_dir($uploadDir)) {
mkdir($uploadDir, 0777);
copy($uploadRootDir . "/index.html", $uploadDir . "/index.html");
}
$error = "";
$msg = "";
$config = VC_Config::getConfig();
$maxFileSize = 0;
$valid = false;
if (isset($config['file']['upload']['size'])) {
$maxFileSize = $config['file']['upload']['size'];
} else {
$error = "System error, please contact to administrator to resolve this problem, thank you very much";
}
$fileElementName = 'fileToUpload';
$upload = new Zend_File_Transfer_Adapter_Http("http");
$allowExt = explode(",", str_replace(" ", "", $config['file']['upload']['ext']));
$upload->addValidator('Extension', true, $allowExt);
$upload->addValidator('FilesSize', true, array('min' => '10B', 'max' => $maxFileSize));
$upload->addValidator('Count', true, array('min' => 1, 'max' => 1));
$messages = array();
$files = $upload->getFileInfo();
if ($upload->isValid() && $upload->isUploaded()) {
reset($files);
$fileInputName = key($files);
//Get file extension
$fileName = $files[$fileInputName]['name'];
$ext = substr($fileName, strrpos($fileName, "."));
$fileName = preg_replace("/[^a-z.0-9]/i", "", $_FILES[$fileInputName]['name']);
$tempPath = $files[$fileInputName]['tmp_name'];
$baseName = str_replace($ext, "", $fileName);
//Name no ext
if ("" == $fileName) {
$fileName = time() . $ext;
}
if (file_exists($uploadDir . "/" . $fileName)) {
$fileName = $baseName . "_" . time() . $ext;
}
if (move_uploaded_file($tempPath, $uploadDir . "/" . $fileName)) {
$valid = true;
} else {
$error = "Could not upload file, please try again.";
}
}
if ($valid) {
//Save to upload_tmp in DB
$uploadTmpTbl = new VC_DbTable_Common("upload_tmp", "id");
$uploadTmpData = array();
$uploadTmpData['file_name'] = $this->_getParam("file_name", $fileName);
$uploadTmpData['user_id'] = $this->userId;
$uploadTmpData['upload_date'] = date("Y-m-d");
$insertTokenNamespace = new Zend_Session_Namespace("INSERT_TOKEN");
$uploadTmpData['insert_token'] = $insertTokenNamespace->insertToken;
$iconPath = VC_Business_File::getFileIcon($ext, '/uploads/' . $invidualDir . '/' . $fileName);
$filePath = '/uploads/' . $invidualDir . '/' . $fileName;
$uploadTmpData['icon_path'] = $iconPath;
$uploadTmpData['file_path'] = $filePath;
$uploadTmpTbl->insert($uploadTmpData);
$result = array('error' => '', 'icon' => $iconPath, 'file' => $filePath, 'name' => $uploadTmpData['file_name']);
echo Zend_Json_Encoder::encode($result, true);
} else {
$messages = $upload->getMessages();
$result = array('error' => implode("\n", $messages) . "\n" . $error, 'file' => '');
echo Zend_Json_Encoder::encode($result);
}
}