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;
}
