public function DisplayInProjectListInProgressColumn(NarroProject $objProject, $strText = '')
{
$strExportText = '';
if ($objProject->ProjectType != NarroProjectType::Mozilla) {
return array($objProject, '');
}
$objCache = new NarroCache(__CLASS__, QApplication::GetLanguageId());
$objData = $objCache->GetData();
if (!$objData) {
$strJson = @file_get_contents($this->strUrl);
if ($strJson) {
$objData = json_decode($strJson);
if ($objData) {
$objCache->SaveData($objData);
}
}
}
if (is_array($objData->items)) {
foreach ($objData->items as $objItem) {
if ($objItem->id == sprintf('%s/%s', $objProject->GetPreferenceValueByName('Code name on mozilla l10n dashboard'), QApplication::$TargetLanguage->LanguageCode)) {
$strWarning = $objItem->warnings ? sprintf('%d warnings', $objItem->warnings) : '';
$strMissing = $objItem->missing ? sprintf('%d missing', $objItem->missing) : '';
$strExportText = sprintf('<a title="Visit the Mozilla l10n dashboard" target="_blank" href="https://l10n-stage-sj.mozilla.org/dashboard/compare?run=%d">%s</a>', $objItem->runid, join(', ', array($objItem->result, $strMissing, $strWarning)));
break;
}
}
}
return array($objProject, $strExportText);
}
public function btnSave_Click()
{
if (trim($this->txtComment->Text)) {
$objComment = new NarroTextComment();
$objComment->UserId = QApplication::GetUserId();
$objComment->LanguageId = QApplication::GetLanguageId();
$objComment->TextId = $this->intTextId;
$objComment->Created = QDateTime::Now();
$objComment->CommentText = $this->txtComment->Text;
$objComment->CommentTextMd5 = md5($objComment->CommentText);
$objComment->Save();
$this->dtgComments->Refresh();
}
}
public function __construct(NarroUser $objUser, $objParentObject, $strControlId = null)
{
// Call the Parent
try {
parent::__construct($objParentObject, $strControlId);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
$this->strTemplate = dirname(__FILE__) . '/' . __CLASS__ . '.tpl.php';
$this->objUser = $objUser;
$this->pnlTranslatedPerProjectPie = new QDatabasePieChart($this);
$this->pnlTranslatedPerProjectPie->Query = sprintf('
SELECT
narro_project.project_name AS label, COUNT(narro_suggestion.suggestion_id) AS cnt
FROM
narro_suggestion, narro_context, narro_project
WHERE
narro_context.text_id = narro_suggestion.text_id AND
narro_project.project_id = narro_context.project_id AND
narro_suggestion.language_id=%d AND
narro_suggestion.user_id=%d
GROUP BY narro_context.project_id', QApplication::GetLanguageId(), $this->objUser->UserId);
$intSuggestionCount = NarroSuggestion::CountByUserId($this->objUser->UserId);
$this->pnlTranslatedPerProjectPie->Total = $intSuggestionCount;
$this->pnlTranslatedPerProjectPie->MinimumDataValue = 0;
$this->pnlApprovedPie = new QPieChart($this);
$this->pnlApprovedPie->Total = $this->pnlTranslatedPerProjectPie->Total;
$this->pnlApprovedPie->MinimumDataValue = 0;
$objDatabase = NarroContextInfo::GetDatabase();
$strQuery = sprintf("\n SELECT\n DISTINCT narro_context_info.valid_suggestion_id\n FROM\n narro_context_info, narro_suggestion\n WHERE\n narro_context_info.valid_suggestion_id=narro_suggestion.suggestion_id AND\n narro_suggestion.user_id=%d", $this->objUser->UserId);
$objDbResult = $objDatabase->Query($strQuery);
$intValidSuggestionCount = $objDbResult->CountRows();
$this->pnlApprovedPie->Data = array(t('Approved') => $intValidSuggestionCount, t('Not approved') => $intSuggestionCount - $intValidSuggestionCount);
$this->tabActivity = new QTabs($this);
$this->dtgSuggestions_Create();
$arrHeaders[] = t('Translations');
$this->dtgReviews_Create();
$arrHeaders[] = t('Reviews');
$this->dtgComments_Create();
$arrHeaders[] = t('Comments');
$this->dtgVotes_Create();
$arrHeaders[] = t('Votes');
if (QApplication::HasPermissionForThisLang('Administrator') || QApplication::GetUserId() == $this->objUser->UserId) {
$this->dtgLog_Create();
$arrHeaders[] = t('Logged messages');
}
$this->tabActivity->Headers = $arrHeaders;
}
public function DisplayInProjectListInProgressColumn(NarroProject $objProject, $strText = '')
{
$strExportText = '';
$objCache = new NarroCache(QApplication::GetLanguageId() . '/' . $objProject->ProjectId, __CLASS__);
$arrData = $objCache->GetData();
switch ($objProject->ProjectName) {
case 'Fennec Aurora':
if ($arrData) {
return $arrData;
}
// set up basic connection
$conn_id = ftp_connect('ftp.mozilla.org');
// login with username and password
$login_result = ftp_login($conn_id, 'anonymous', '*****@*****.**');
// get contents of the current directory
$contents = ftp_nlist($conn_id, "/pub/mobile/nightly/latest-mozilla-aurora-linux-l10n");
if (is_array($contents)) {
foreach ($contents as $strFile) {
if (preg_match('/\\/fennec\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.linux\\-i686\\.tar\\.bz2$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">linux i686</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
}
$contents = ftp_nlist($conn_id, "/pub/mobile/nightly/latest-mozilla-aurora-win32-l10n");
if (is_array($contents)) {
foreach ($contents as $strFile) {
if (preg_match('/\\/fennec\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.win32\\.zip$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">win32</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
}
$contents = ftp_nlist($conn_id, "/pub/mobile/nightly/latest-mozilla-aurora-macosx-l10n");
if (is_array($contents)) {
foreach ($contents as $strFile) {
if (preg_match('/\\/fennec\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.mac\\.dmg$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">mac</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
}
$contents = ftp_nlist($conn_id, "/pub/mobile/nightly/latest-mozilla-aurora-android");
if (is_array($contents)) {
foreach ($contents as $strFile) {
if (preg_match('/\\/fennec\\-(.*)\\.multi\\.android\\-arm\\.apk$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">android</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
}
$strLinks = join(', ', $arrLink);
if ($strLinks != '') {
$arrData = array($objProject, sprintf('nightly: %s', $strLinks));
$objCache->SaveData($arrData);
return $arrData;
} else {
return array($objProject, '');
}
case 'Firefox Aurora':
if ($arrData) {
return $arrData;
}
// set up basic connection
$conn_id = ftp_connect('ftp.mozilla.org');
// login with username and password
$login_result = ftp_login($conn_id, 'anonymous', '*****@*****.**');
// get contents of the current directory
$contents = ftp_nlist($conn_id, "/pub/firefox/nightly/latest-mozilla-aurora-l10n/");
if (is_array($contents)) {
foreach ($contents as $strFile) {
if (preg_match('/\\/firefox\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.linux\\-i686\\.tar\\.bz2$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">linux i686</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/firefox\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.linux\\-x86\\_64\\.tar\\.bz2$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">linux x86_64</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/firefox\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.win32\\.zip$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">win32</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/firefox\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.mac\\.dmg$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">mac</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
}
$strLinks = join(', ', $arrLink);
if ($strLinks != '') {
$arrData = array($objProject, sprintf('nightly: %s', $strLinks));
$objCache->SaveData($arrData);
return $arrData;
} else {
return array($objProject, '');
}
case 'Thunderbird Aurora':
$strCacheId = __CLASS__ . QApplication::GetLanguageId() . 'p' . $objProject->ProjectId;
if ($arrData) {
return $arrData;
}
// set up basic connection
$conn_id = ftp_connect('ftp.mozilla.org');
// login with username and password
$login_result = ftp_login($conn_id, 'anonymous', '*****@*****.**');
// get contents of the current directory
$contents = ftp_nlist($conn_id, "/pub/thunderbird/nightly/latest-comm-aurora-l10n/");
foreach ($contents as $strFile) {
if (preg_match('/\\/thunderbird\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.linux\\-i686\\.tar\\.bz2$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">linux i686</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/thunderbird\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.linux\\-x86\\_64\\.tar\\.bz2$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">linux x86_64</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/thunderbird\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.win32\\.zip$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">win32</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
foreach ($contents as $strFile) {
if (preg_match('/\\/thunderbird\\-(.*)\\.' . preg_quote(QApplication::$TargetLanguage->LanguageCode) . '\\.mac\\.dmg$/', $strFile, $arrMatches)) {
$objDateSpan = new QDateTimeSpan(time() - ftp_mdtm($conn_id, $strFile));
$arrLink[] = sprintf('<a title="Download a localized nightly build %s built %s ago" href="ftp://ftp.mozilla.org%s">mac</a>', $arrMatches[1], $objDateSpan->SimpleDisplay(), $strFile);
}
}
$strLinks = join(', ', $arrLink);
if ($strLinks != '') {
$arrData = array($objProject, sprintf('nightly: %s', $strLinks));
$objCache->SaveData($arrData);
return $arrData;
} else {
return array($objProject, '');
}
default:
return array($objProject, '');
}
}
public function btnReplace_Click()
{
if (!QApplication::HasPermissionForThisLang('Can approve')) {
return false;
}
if ($this->txtReplace->Display == false) {
$this->txtReplace->Display = true;
} else {
if ($this->txtSearch->Text == '') {
return false;
}
if ($this->txtReplace->Text == '') {
return false;
}
$strQuery = NarroContextInfo::GetQueryForConditions($objQueryBuilder, QQ::AndCondition($this->arrConditions), $this->arrClauses);
$objDbResult = NarroContextInfo::GetDatabase()->Query($strQuery);
if ($objDbResult) {
$intReplaceCnt = 0;
$intApproved = 0;
$intTranslations = 0;
$arrProcessed = array();
while ($objDbRow = $objDbResult->GetNextRow()) {
$objContextInfo = NarroContextInfo::InstantiateDbRow($objDbRow, null, null, null, $objQueryBuilder->ColumnAliasArray);
if (in_array($objContextInfo->ContextInfoId, $arrProcessed)) {
continue;
} else {
$arrProcessed[] = $objContextInfo->ContextInfoId;
}
$objReplaceSuggestion = null;
if (preg_match("/^'.*'\$/", $this->txtSearch->Text)) {
$strToReplace = substr($this->txtSearch->Text, 1, -1);
} else {
$strToReplace = $this->txtSearch->Text;
}
if ($strToReplace == $objContextInfo->Context->Text->TextValue) {
$objReplaceSuggestion = NarroSuggestion::LoadByTextIdLanguageIdSuggestionValueMd5($objContextInfo->Context->TextId, QApplication::GetLanguageId(), md5($this->txtReplace->Text));
if (!$objReplaceSuggestion) {
$objSuggestion = new NarroSuggestion();
$objSuggestion->UserId = QApplication::GetUserId();
$objSuggestion->TextId = $objContextInfo->Context->TextId;
$objSuggestion->LanguageId = QApplication::GetLanguageId();
$objSuggestion->SuggestionValue = $this->txtReplace->Text;
$objSuggestion->HasComments = 0;
$objSuggestion->IsImported = 0;
$objSuggestion->Created = QDateTime::Now();
$objSuggestion->Modified = null;
$objSuggestion->Save();
$intTranslations++;
$objReplaceSuggestion = $objSuggestion;
}
}
if ($objReplaceSuggestion instanceof NarroSuggestion) {
$intReplaceCnt++;
if ($objContextInfo->ValidSuggestionId != $objReplaceSuggestion->SuggestionId || $this->chkApprove->Checked) {
if ($objContextInfo->ValidSuggestionId == null) {
$intApproved++;
}
$objContextInfo->ValidSuggestionId = $objReplaceSuggestion->SuggestionId;
$objContextInfo->ValidatorUserId = QApplication::GetUserId();
$objContextInfo->Modified = QDateTime::Now();
$objContextInfo->Save();
}
}
}
$this->dtrText->RemoveChildControls(true);
$this->btnReplace->Refresh();
QApplication::ExecuteJavaScript(sprintf('jQuery(\'#%s\').after(\' <small style="padding: 2px;" class="ui-state-highlight ui-corner-all"><span style="width:16px; height: 16px; display:inline-block" class="ui-icon ui-icon-info"></span> %s.</small>\')', $this->btnReplace->ControlId, sprintf(t('%d occurences of "%s" translated with "%s", out of which %d were already approved, %d translations added.'), $intReplaceCnt, $strToReplace, $this->txtReplace->Text, $intApproved, $intTranslations)));
}
}
}
public function dtgProjectList_Bind()
{
if ($this->txtSearch->Text != '') {
$arrConditions[] = QQ::Like(QQN::NarroProject()->ProjectName, sprintf('%%%s%%', $this->txtSearch->Text));
} else {
$arrConditions[] = QQ::All();
}
if (QApplication::HasPermissionForThisLang('Can manage project')) {
$arrConditions[] = QQ::All();
} else {
$arrConditions[] = QQ::AndCondition(QQ::Equal(QQN::NarroProject()->NarroProjectProgressAsProject->Active, 1), QQ::Equal(QQN::NarroProject()->Active, 1));
}
// Setup the $objClauses Array
$objClauses = array(QQ::Expand(QQN::NarroProject()->NarroProjectProgressAsProject, QQ::Equal(QQN::NarroProject()->NarroProjectProgressAsProject->LanguageId, QApplication::GetLanguageId())));
// Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
$this->dtgProjectList->TotalItemCount = NarroProject::QueryCount(QQ::AndCondition($arrConditions), $objClauses);
// If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
// the OrderByClause to the $objClauses array
if ($objClause = $this->dtgProjectList->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->dtgProjectList->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be the array of all NarroProjectProgress objects, given the clauses above
$this->dtgProjectList->DataSource = NarroProject::QueryArray(QQ::AndCondition($arrConditions), $objClauses);
}
public function __construct($strDate, $objParentObject, NarroProject $objProject = null, $strControlId = null)
{
// Call the Parent
try {
parent::__construct($objParentObject, $strControlId);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
$this->strTemplate = dirname(__FILE__) . '/' . __CLASS__ . '.tpl.php';
$this->blnAutoRenderChildren = true;
// Tabs
$this->tabTop = new QTabs($this);
$pnlTranslators = new NarroUserDataGrid($this->tabTop);
$pnlTranslators->CssClass = 'datagrid';
$colUsername = $pnlTranslators->MetaAddColumn(QQN::NarroUser()->Username);
$colUsername->HtmlEntities = false;
$colUsername->Html = '<?=NarroLink::UserProfile($_ITEM->UserId, $_ITEM->Username)?>';
$colCnt = new QDataGridColumn(t('Translations'));
$colCnt->Html = '<?=$_ITEM->GetVirtualAttribute("suggestion_cnt")?>';
$pnlTranslators->SortColumnIndex = 1;
$pnlTranslators->ShowHeader = false;
$pnlTranslators->SortDirection = 1;
$pnlTranslators->AddColumn($colCnt);
$pnlTranslators->AdditionalConditions = QQ::AndCondition(QQ::GreaterOrEqual(QQN::NarroUser()->NarroSuggestionAsUser->Created, $strDate), QQ::Equal(QQN::NarroUser()->NarroSuggestionAsUser->LanguageId, QApplication::GetLanguageId()), QQ::NotEqual(QQN::NarroUser()->UserId, NarroUser::ANONYMOUS_USER_ID), $objProject ? QQ::Equal(QQN::NarroUser()->NarroSuggestionAsUser->Text->NarroContextAsText->ProjectId, $objProject->ProjectId) : QQ::All());
$pnlTranslators->AdditionalClauses = array(QQ::Count(QQN::NarroUser()->NarroSuggestionAsUser->SuggestionId, 'suggestion_cnt'), QQ::GroupBy(QQN::NarroUser()->UserId));
$pnlReviewers = new NarroUserDataGrid($this->tabTop);
$pnlReviewers->CssClass = 'datagrid';
$colUsername = $pnlReviewers->MetaAddColumn(QQN::NarroUser()->Username);
$colUsername->HtmlEntities = false;
$colUsername->Html = '<?=NarroLink::UserProfile($_ITEM->UserId, $_ITEM->Username)?>';
$colCnt = new QDataGridColumn(t('Reviewers'));
$colCnt->Html = '<?=$_ITEM->GetVirtualAttribute("suggestion_cnt")?>';
$pnlReviewers->SortColumnIndex = 1;
$pnlReviewers->ShowHeader = false;
$pnlReviewers->SortDirection = 1;
$pnlReviewers->AddColumn($colCnt);
$pnlReviewers->AdditionalConditions = QQ::AndCondition(QQ::GreaterOrEqual(QQN::NarroUser()->NarroContextInfoAsValidatorUser->Modified, $strDate), QQ::Equal(QQN::NarroUser()->NarroContextInfoAsValidatorUser->LanguageId, QApplication::GetLanguageId()), QQ::NotEqual(QQN::NarroUser()->UserId, NarroUser::ANONYMOUS_USER_ID), $objProject ? QQ::Equal(QQN::NarroUser()->NarroContextInfoAsValidatorUser->Context->ProjectId, $objProject->ProjectId) : QQ::All());
$pnlReviewers->AdditionalClauses = array(QQ::Count(QQN::NarroUser()->NarroContextInfoAsValidatorUser->ValidSuggestionId, 'suggestion_cnt'), QQ::GroupBy(QQN::NarroUser()->UserId));
$pnlVoters = new NarroUserDataGrid($this->tabTop);
$pnlVoters->CssClass = 'datagrid';
$colUsername = $pnlVoters->MetaAddColumn(QQN::NarroUser()->Username);
$colUsername->HtmlEntities = false;
$colUsername->Html = '<?=NarroLink::UserProfile($_ITEM->UserId, $_ITEM->Username)?>';
$colCnt = new QDataGridColumn(t('Reviewers'));
$colCnt->Html = '<?=$_ITEM->GetVirtualAttribute("suggestion_cnt")?>';
$pnlVoters->SortColumnIndex = 1;
$pnlVoters->ShowHeader = false;
$pnlVoters->SortDirection = 1;
$pnlVoters->AddColumn($colCnt);
$pnlVoters->AdditionalConditions = QQ::AndCondition(QQ::GreaterOrEqual(QQN::NarroUser()->NarroSuggestionVoteAsUser->Created, $strDate), QQ::Equal(QQN::NarroUser()->NarroSuggestionVoteAsUser->Suggestion->LanguageId, QApplication::GetLanguageId()), QQ::NotEqual(QQN::NarroUser()->UserId, NarroUser::ANONYMOUS_USER_ID), $objProject ? QQ::Equal(QQN::NarroUser()->NarroSuggestionVoteAsUser->Suggestion->Text->NarroContextAsText->ProjectId, $objProject->ProjectId) : QQ::All());
$pnlVoters->AdditionalClauses = array(QQ::Count(QQN::NarroUser()->NarroSuggestionVoteAsUser->SuggestionId, 'suggestion_cnt'), QQ::GroupBy(QQN::NarroUser()->UserId));
$pnlComments = new NarroUserDataGrid($this->tabTop);
$pnlComments->CssClass = 'datagrid';
$colUsername = $pnlComments->MetaAddColumn(QQN::NarroUser()->Username);
$colUsername->HtmlEntities = false;
$colUsername->Html = '<?=NarroLink::UserProfile($_ITEM->UserId, $_ITEM->Username)?>';
$colCnt = new QDataGridColumn(t('Reviewers'));
$colCnt->Html = '<?=$_ITEM->GetVirtualAttribute("suggestion_cnt")?>';
$pnlComments->SortColumnIndex = 1;
$pnlComments->ShowHeader = false;
$pnlComments->SortDirection = 1;
$pnlComments->AddColumn($colCnt);
$pnlComments->AdditionalConditions = QQ::AndCondition(QQ::GreaterOrEqual(QQN::NarroUser()->NarroTextCommentAsUser->Created, $strDate), QQ::Equal(QQN::NarroUser()->NarroTextCommentAsUser->LanguageId, QApplication::GetLanguageId()), QQ::NotEqual(QQN::NarroUser()->UserId, NarroUser::ANONYMOUS_USER_ID));
$pnlComments->AdditionalClauses = array(QQ::Count(QQN::NarroUser()->NarroTextCommentAsUser->TextCommentId, 'suggestion_cnt'), QQ::GroupBy(QQN::NarroUser()->UserId));
$this->tabTop->Headers = array(t('Translators'), t('Reviewers'), t('Voters'), t('Comments'));
}
public function btnClearLog_Click($strFormId, $strControlId, $strParameter)
{
if (QApplication::HasPermissionForThisLang('Administrator')) {
if (QApplication::HasPermission('Administrator')) {
NarroLog::GetDatabase()->NonQuery(sprintf('DELETE FROM narro_log'));
} else {
NarroLog::GetDatabase()->NonQuery(sprintf('DELETE FROM narro_log WHERE language_id=%d', QApplication::GetLanguageId()));
}
$this->dtgLog->btnFilterReset_Click($strFormId, $strControlId, $strParameter);
$this->dtgLog->Refresh();
}
}
public static function CountByTextIdForCurrentLanguage($intTextId)
{
return self::QueryCount(QQ::AndCondition(QQ::Equal(QQN::NarroSuggestion()->LanguageId, QApplication::GetLanguageId()), QQ::Equal(QQN::NarroSuggestion()->TextId, $intTextId)));
}
public function __construct($objUser, $objParentObject, $strControlId = null)
{
// Call the Parent
try {
parent::__construct($objParentObject, $strControlId);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
$this->strTemplate = __NARRO_INCLUDES__ . '/narro/panel/NarroUserRolePanel.tpl.php';
$this->objUser = $objUser;
// Setup DataGrid Columns
$this->colLanguage = new QDataGridColumn(t('Language'), '<?= $_CONTROL->ParentControl->dtgUserRole_LanguageColumn_Render($_ITEM) ?>', array('OrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Language->LanguageName), 'ReverseOrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Language->LanguageName, false)));
$this->colLanguage->HtmlEntities = false;
$this->colProject = new QDataGridColumn(t('Project'), '<?= $_CONTROL->ParentControl->dtgUserRole_ProjectColumn_Render($_ITEM) ?>', array('OrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Project->ProjectName), 'ReverseOrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Project->ProjectName, false)));
$this->colProject->HtmlEntities = false;
$this->colRole = new QDataGridColumn(t('Roles'), '<?= $_CONTROL->ParentControl->dtgUserRole_RoleColumn_Render($_ITEM) ?>', array('OrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Role->RoleName), 'ReverseOrderByClause' => QQ::OrderBy(QQN::NarroUserRole()->Role->RoleName, false)));
$this->colRole->HtmlEntities = false;
$this->colActions = new QDataGridColumn(t('Actions'), '<?= $_CONTROL->ParentControl->dtgUserRole_ActionsColumn_Render($_ITEM) ?>');
$this->colActions->HtmlEntities = false;
// Setup DataGrid
$this->dtgUserRole = new NarroDataGrid($this);
$this->dtgUserRole->Title = sprintf(t('<b>%s</b>\'s roles'), NarroLink::UserProfile($this->objUser->UserId, $this->objUser->RealName));
$this->dtgUserRole->ShowHeader = true;
$this->dtgUserRole->Paginator = new QPaginator($this->dtgUserRole);
$this->dtgUserRole->PaginatorAlternate = new QPaginator($this->dtgUserRole);
$this->dtgUserRole->ItemsPerPage = QApplication::$User->GetPreferenceValueByName('Items per page');
// Specify Whether or Not to Refresh using Ajax
$this->dtgUserRole->UseAjax = QApplication::$UseAjax;
// Specify the local databind method this datagrid will use
$this->dtgUserRole->SetDataBinder('dtgUserRole_Bind', $this);
$this->dtgUserRole->AddColumn($this->colLanguage);
$this->dtgUserRole->AddColumn($this->colProject);
$this->dtgUserRole->AddColumn($this->colRole);
$this->lstLanguage = new QListBox($this);
$this->lstLanguage->AddItem('Any');
foreach (NarroLanguage::LoadAllActive(array(QQ::OrderBy(QQN::NarroLanguage()->LanguageName))) as $objNarroLanguage) {
if (QApplication::HasPermission('Can manage user roles', null, $objNarroLanguage->LanguageId)) {
$this->blnCanManageSomeRoles = true;
}
$this->lstLanguage->AddItem($objNarroLanguage->LanguageName, $objNarroLanguage->LanguageId);
}
$this->lstLanguage->SelectedValue = QApplication::GetLanguageId();
$this->lstProject = new QListBox($this);
$this->lstProject->AddItem('Any');
foreach (NarroProject::QueryArray(QQ::Equal(QQN::NarroProject()->Active, 1), array(QQ::OrderBy(QQN::NarroProject()->ProjectName))) as $objNarroProject) {
if (QApplication::HasPermission('Can manage user roles', $objNarroProject->ProjectId)) {
$this->blnCanManageSomeRoles = true;
}
$this->lstProject->AddItem($objNarroProject->ProjectName, $objNarroProject->ProjectId);
}
if (!$this->blnCanManageSomeRoles && QApplication::HasPermission('Can manage user roles')) {
$this->blnCanManageSomeRoles = true;
}
if ($this->blnCanManageSomeRoles) {
$this->dtgUserRole->AddColumn($this->colActions);
}
$this->lstRole = new QListBox($this);
foreach (NarroRole::LoadAll(array(QQ::OrderBy(QQN::NarroRole()->RoleName))) as $objNarroRole) {
if ($objNarroRole->RoleName == 'Administrator' && !QApplication::HasPermission('Administrator')) {
continue;
}
$this->lstRole->AddItem($objNarroRole->RoleName, $objNarroRole->RoleId);
}
$this->btnAddRole = new QButton($this);
$this->btnAddRole->Text = t('Add');
$this->btnAddRole->AddAction(new QClickEvent(), new QServerControlAction($this, 'btnAddRole_Click'));
}
public function btnSave_Click($strFormId, $strControlId, $strParameter)
{
foreach ($this->arrControls as $strName => $objControl) {
switch (NarroProject::$AvailablePreferences[$strName]['type']) {
case 'number':
$this->objProject->SetPreferenceValueByName($strName, $objControl->Text);
break;
case 'text':
$this->objProject->SetPreferenceValueByName($strName, $objControl->Text);
break;
case 'option':
$this->objProject->SetPreferenceValueByName($strName, $objControl->SelectedValue);
break;
}
}
try {
$this->objProject->Save();
$this->objProject = NarroProject::Load($this->objProject->ProjectId);
$this->objProjectProgress = NarroProjectProgress::LoadByProjectIdLanguageId($this->objProject->ProjectId, QApplication::GetLanguageId());
$this->lblMessage->Text = t('Your preferences were saved successfuly.');
$this->lblMessage->ForeColor = 'green';
} catch (Exception $objEx) {
$this->lblMessage->Text = t('An error occurred while trying to save your preferences.');
$this->lblMessage->ForeColor = 'red';
}
}
case 'textcomment':
if (isset($objProject) && $objProject instanceof NarroProject) {
$strCacheId = sprintf('rssfeed_textcomment_%d_%d', $objProject->ProjectId, QApplication::QueryString('l'));
} else {
$strCacheId = sprintf('rssfeed_textcomment_%d', QApplication::QueryString('l'));
}
if (!($objRssFeed = QApplication::$Cache->load($strCacheId))) {
if (isset($objProject) && $objProject instanceof NarroProject) {
$objRssFeed = new QRssFeed(sprintf(t('Comments on texts from %s'), $objProject->ProjectName), __HTTP_URL__ . __VIRTUAL_DIRECTORY__ . __SUBDIRECTORY__, sprintf(t('Get the latest debates on texts from the project %s'), $objProject->ProjectName));
} else {
$objRssFeed = new QRssFeed(t('Comments on texts'), __HTTP_URL__ . __VIRTUAL_DIRECTORY__ . __SUBDIRECTORY__, t('Get the latest debates on texts'));
}
if (isset($objProject) && $objProject instanceof NarroProject) {
$strSqlQuery = sprintf('SELECT DISTINCT narro_text_comment.* FROM narro_text_comment, narro_context WHERE narro_text_comment.text_id=narro_context.text_id AND narro_context.active=1 AND narro_context.project_id=%d AND narro_text_comment.language_id=%d ORDER BY created DESC LIMIT 0, 20', $objProject->ProjectId, QApplication::GetLanguageId());
} else {
$strSqlQuery = sprintf('SELECT DISTINCT narro_text_comment.* FROM narro_text_comment WHERE narro_text_comment.language_id=%d ORDER BY created DESC LIMIT 0, 20', QApplication::GetLanguageId());
}
$objDatabase = QApplication::$Database[1];
$objDbResult = $objDatabase->Query($strSqlQuery);
if ($objDbResult) {
$arrTextComment = NarroTextComment::InstantiateDbResult($objDbResult);
foreach ($arrTextComment as $objTextComment) {
if (isset($objProject) && $objProject instanceof NarroProject) {
$arrContext = NarroContext::QueryArray(QQ::AndCondition(QQ::Equal(QQN::NarroContext()->ProjectId, $objProject->ProjectId), QQ::Equal(QQN::NarroContext()->TextId, $objTextComment->TextId), QQ::Equal(QQN::NarroContext()->Active, 1)));
} else {
$arrContext = NarroContext::QueryArray(QQ::AndCondition(QQ::Equal(QQN::NarroContext()->TextId, $objTextComment->TextId), QQ::Equal(QQN::NarroContext()->Active, 1)));
}
if (count($arrContext)) {
$arrProjectLinks = array();
$arrProjects = array();
$strDescription = sprintf('
public function dtgFile_SetConditions()
{
if ($this->txtSearch->Text == '') {
$objCommonCondition = QQ::AndCondition(QQ::Equal(QQN::NarroFileProgress()->File->Active, 1), QQ::Equal(QQN::NarroFileProgress()->LanguageId, QApplication::GetLanguageId()), QQ::Equal(QQN::NarroFileProgress()->File->ProjectId, $this->objProject->ProjectId));
} else {
$objCommonCondition = QQ::AndCondition(QQ::Equal(QQN::NarroFileProgress()->File->Active, 1), QQ::Equal(QQN::NarroFileProgress()->LanguageId, QApplication::GetLanguageId()), QQ::Equal(QQN::NarroFileProgress()->File->ProjectId, $this->objProject->ProjectId), QQ::Like(QQN::NarroFileProgress()->File->FileName, sprintf('%%%s%%', $this->txtSearch->Text)));
}
// Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if (!$this->chkShowHierarchy->Checked) {
if ($this->chkShowFolders->Checked) {
$this->dtgFile->AdditionalConditions = $objCommonCondition;
} else {
$this->dtgFile->AdditionalConditions = QQ::AndCondition($objCommonCondition, QQ::NotEqual(QQN::NarroFileProgress()->File->TypeId, NarroFileType::Folder));
}
} elseif ($this->objParentFile) {
$objParentCondition = QQ::Equal(QQN::NarroFileProgress()->File->ParentId, $this->objParentFile->FileId);
if ($this->chkShowFolders->Checked) {
$this->dtgFile->AdditionalConditions = QQ::AndCondition($objCommonCondition, $objParentCondition);
} else {
$this->dtgFile->AdditionalConditions = QQ::AndCondition($objCommonCondition, $objParentCondition, QQ::NotEqual(QQN::NarroFileProgress()->File->TypeId, NarroFileType::Folder));
}
} else {
$objParentCondition = QQ::IsNull(QQN::NarroFileProgress()->File->ParentId);
if ($this->chkShowFolders->Checked) {
$this->dtgFile->AdditionalConditions = QQ::AndCondition($objCommonCondition, $objParentCondition);
} else {
$this->dtgFile->AdditionalConditions = QQ::AndCondition($objCommonCondition, $objParentCondition, QQ::NotEqual(QQN::NarroFileProgress()->File->TypeId, NarroFileType::Folder));
}
}
$this->MarkAsModified();
}
public function btnImport_Click($strFormId, $strControlId, $strParameter)
{
if (!QApplication::HasPermissionForThisLang('Can import project', $this->objProject->ProjectId)) {
return false;
}
$strProcLogFile = __TMP_PATH__ . '/' . $this->objProject->ProjectId . '-' . QApplication::$TargetLanguage->LanguageCode . '-import-process.log';
$strProcPidFile = __TMP_PATH__ . '/' . $this->objProject->ProjectId . '-' . QApplication::$TargetLanguage->LanguageCode . '-import-process.pid';
$strProgressFile = __TMP_PATH__ . '/import-' . $this->objProject->ProjectId . '-' . QApplication::$TargetLanguage->LanguageCode;
if ($strParameter == 1) {
if (NarroUtils::IsProcessRunning('import', $this->objProject->ProjectId)) {
$this->objImportProgress->Translated = NarroProgress::GetProgress($this->objProject->ProjectId, 'import');
$this->objImportProgress->MarkAsModified();
} else {
$this->lblImport->Text = t('Import finished.');
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript('if (typeof lastImportId != \'undefined\') clearInterval(lastImportId)');
}
if (file_exists($strProcLogFile) && filesize($strProcLogFile)) {
NarroLogger::LogInfo(sprintf('There are messages from the background process: %s', file_get_contents($strProcLogFile)));
}
if (file_exists($strProcLogFile)) {
unlink($strProcLogFile);
}
if (file_exists($strProcPidFile)) {
unlink($strProcPidFile);
}
if (file_exists($strProgressFile)) {
unlink($strProgressFile);
}
$this->lblImport->Visible = true;
$this->btnImport->Visible = true;
$this->btnKillProcess->Visible = false;
$this->objImportProgress->Translated = 0;
$this->objImportProgress->Visible = false;
}
$this->pnlLogViewer->MarkAsModified();
} elseif ($strParameter == 2) {
$this->pnlLogViewer->ProjectId = $this->objProject->ProjectId;
$this->pnlLogViewer->LanguageId = QApplication::GetLanguageId();
$this->pnlLogViewer->DateStart = QDateTime::Now();
NarroProgress::ClearProgressFileName($this->objProject->ProjectId, 'import');
set_time_limit(0);
if (file_exists($strProcLogFile)) {
unlink($strProcLogFile);
}
if (file_exists($strProcPidFile)) {
unlink($strProcPidFile);
}
if (file_exists($strProgressFile)) {
unlink($strProgressFile);
}
$objNarroImporter = new NarroProjectImporter();
/**
* Get boolean options
*/
$objNarroImporter->CheckEqual = true;
$objNarroImporter->Approve = $this->chkApproveImportedTranslations->Checked;
$objNarroImporter->ApproveAlreadyApproved = !$this->chkApproveOnlyNotApproved->Checked;
$objNarroImporter->OnlySuggestions = !$this->chkImportSourceTexts->Checked;
$objNarroImporter->Project = $this->objProject;
$objNarroImporter->ImportUnchangedFiles = $this->chkImportUnchangedFiles->Checked;
$objNarroImporter->User = QApplication::$User;
$objNarroImporter->TargetLanguage = QApplication::$TargetLanguage;
$objNarroImporter->SourceLanguage = NarroLanguage::LoadByLanguageCode(NarroLanguage::SOURCE_LANGUAGE_CODE);
try {
$objNarroImporter->TranslationPath = $this->pnlTranslationsSource->Directory;
$objNarroImporter->TemplatePath = $this->objProject->DefaultTemplatePath;
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during import: %s', $objEx->getMessage()));
$this->lblImport->Text = sprintf(t('Import failed: %s'), $objEx->getMessage());
return false;
}
try {
$objNarroImporter->ImportProject();
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during import: %s', $objEx->getMessage()));
$this->lblImport->Text = sprintf(t('Import failed: %s'), $objEx->getMessage());
}
$this->lblImport->Visible = true;
$this->btnImport->Visible = true;
$this->btnKillProcess->Visible = false;
$this->objImportProgress->Visible = false;
$this->pnlLogViewer->MarkAsModified();
} else {
$this->pnlLogViewer->ProjectId = $this->objProject->ProjectId;
$this->pnlLogViewer->LanguageId = QApplication::GetLanguageId();
$this->pnlLogViewer->DateStart = QDateTime::Now();
NarroProgress::ClearProgressFileName($this->objProject->ProjectId, 'import');
$this->pnlLogViewer->MarkAsModified();
$this->btnImport->Visible = false;
$this->btnKillProcess->Visible = QApplication::HasPermission('Administrator', $this->objProject, QApplication::$TargetLanguage->LanguageCode) && !$this->btnImport->Visible;
$this->objImportProgress->Visible = true;
$this->objImportProgress->Translated = 0;
$this->lblImport->Text = '';
try {
$strCommand = sprintf(__PHP_CLI_PATH__ . ' ' . escapeshellarg(sprintf('%s/includes/narro/importer/narro-cli.php', __DOCROOT__ . __SUBDIRECTORY__)) . ' --import --minloglevel 3 --project %d --user %d --check-equal ' . ($this->chkApproveImportedTranslations->Checked ? '--approve ' : '') . ($this->chkImportUnchangedFiles->Checked ? '--import-unchanged-files ' : '') . ($this->chkApproveOnlyNotApproved->Checked ? '' : '--approve-already-approved ') . (!$this->chkImportSourceTexts->Checked || !QApplication::HasPermission('Can import project', $this->objProject->ProjectId) ? '--only-suggestions ' : '') . ' --template-lang %s --translation-lang %s --template-directory %s --translation-directory %s', (int) $this->objProject->ProjectId, (int) QApplication::$User->UserId, escapeshellarg(NarroLanguage::SOURCE_LANGUAGE_CODE), escapeshellarg(QApplication::$TargetLanguage->LanguageCode), escapeshellarg($this->objProject->DefaultTemplatePath), escapeshellarg($this->pnlTranslationsSource->Directory));
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during import: %s', $objEx->getMessage()));
$this->lblImport->Text = sprintf(t('Import failed: %s'), $objEx->getMessage());
$this->lblImport->Visible = true;
$this->btnImport->Visible = true;
$this->btnKillProcess->Visible = QApplication::HasPermission('Administrator', $this->objProject, QApplication::$TargetLanguage->LanguageCode) && !$this->btnImport->Visible;
$this->objImportProgress->Translated = 0;
$this->objImportProgress->Visible = false;
$this->pnlLogViewer->MarkAsModified();
return false;
}
if (file_exists($strProcLogFile) && is_writable($strProcLogFile)) {
unlink($strProcLogFile);
}
NarroUtils::Exec($strCommand, $arrOutput, $arrError, $intRetVal, true);
if ($intRetVal == 0) {
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript(sprintf('lastImportId = setInterval("qc.pA(\'%s\', \'%s\', \'QClickEvent\', \'1\')", %d);', $strFormId, $strControlId, 2000));
} else {
$this->btnImport_Click($strFormId, $strControlId, 1);
}
} else {
$this->objImportProgress->Visible = false;
NarroLogger::LogError('Failed to launch a background process, there will be no progress displayed, and it might take a while, please wait for more messages');
$this->pnlLogViewer->MarkAsModified();
/**
* try importing without launching a background process
*/
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript(sprintf('lastImportId = setTimeout("qc.pA(\'%s\', \'%s\', \'QClickEvent\', \'2\')", %d);', $strFormId, $strControlId, 2000));
} else {
$this->btnImport_Click($strFormId, $strControlId, 2);
}
}
}
}
" href="rss.php?t=text&l=<?php
echo QApplication::GetLanguageId();
?>
" />
<link rel="alternate" type="application/rss+xml" title="<?php
echo t('Comments on texts from all projects');
?>
" href="rss.php?t=textcomment&l=<?php
echo QApplication::GetLanguageId();
?>
" />
<link rel="alternate" type="application/rss+xml" title="<?php
echo t('Translations for all projects');
?>
" href="rss.php?t=suggestion&l=<?php
echo QApplication::GetLanguageId();
?>
" />
<?php
}
?>
<?php
}
?>
<link type="image/x-icon" href="<?php
echo __HTTP_URL__ . __VIRTUAL_DIRECTORY__ . __SUBDIRECTORY__;
?>
/assets/images/narro.ico" rel="shortcut icon"/>
<link type="image/x-icon" href="<?php
echo __HTTP_URL__ . __VIRTUAL_DIRECTORY__ . __SUBDIRECTORY__;
?>
public function btnDelete_Click($strFormId, $strControlId, $strParameter)
{
if (!QApplication::HasPermission('Can delete project', $this->objProject->ProjectId)) {
QApplication::Redirect(NarroLink::ProjectList());
}
$objDatabase = QApplication::$Database[1];
try {
$strQuery = sprintf("DELETE FROM narro_context_info USING narro_context_info LEFT JOIN narro_context ON narro_context_info.context_id=narro_context.context_id WHERE narro_context_info.language_id=%d AND narro_context.project_id=%d", QApplication::GetLanguageId(), $this->objProject->ProjectId);
$objDatabase->NonQuery($strQuery);
$strQuery = sprintf("DELETE FROM `narro_context` WHERE project_id = %d", $this->objProject->ProjectId);
$objDatabase->NonQuery($strQuery);
$strQuery = sprintf("DELETE FROM `narro_file` WHERE project_id = %d", $this->objProject->ProjectId);
$objDatabase->NonQuery($strQuery);
$strQuery = sprintf("DELETE FROM `narro_user_role` WHERE project_id = %d", $this->objProject->ProjectId);
$objDatabase->NonQuery($strQuery);
$intProjectId = $this->objProject->ProjectId;
$this->objProject->Delete();
NarroUtils::RecursiveDelete(__IMPORT_PATH__ . '/' . $intProjectId);
NarroUtils::RecursiveDelete(sprintf('%s/project-%d-hg', __NARRO_DATA__ . '/mozilla-build', $intProjectId));
NarroUtils::RecursiveDelete(sprintf('%s/project-%d-obj', __NARRO_DATA__ . '/mozilla-build', $intProjectId));
} catch (Exception $objEx) {
$this->lblMessage->Text = $objEx->getMessage();
return false;
}
QApplication::Redirect(NarroLink::ProjectList());
}
/**
* Override method to perform a property "Get"
* This will get the value of $strName
*
* @param string $strName Name of the property to get
* @return mixed
*/
public function __get($strName)
{
switch ($strName) {
///////////////////
// Member Variables
///////////////////
case 'Preferences':
return $this->arrPreferences;
case 'ProjectProgressForCurrentLanguage':
if (!$this->intProjectId) {
return false;
}
if (isset($this->objProjectProgressForCurrentLanguage)) {
return $this->objProjectProgressForCurrentLanguage;
} else {
$this->objProjectProgressForCurrentLanguage = NarroProjectProgress::LoadByProjectIdLanguageId($this->intProjectId, QApplication::GetLanguageId());
if (!$this->objProjectProgressForCurrentLanguage instanceof NarroProjectProgress) {
$this->objProjectProgressForCurrentLanguage = new NarroProjectProgress();
$this->objProjectProgressForCurrentLanguage->LanguageId = QApplication::GetLanguageId();
$this->objProjectProgressForCurrentLanguage->ProjectId = $this->intProjectId;
$this->objProjectProgressForCurrentLanguage->TotalTextCount = 0;
$this->objProjectProgressForCurrentLanguage->ApprovedTextCount = 0;
$this->objProjectProgressForCurrentLanguage->FuzzyTextCount = 0;
$this->objProjectProgressForCurrentLanguage->ProgressPercent = 0;
$this->objProjectProgressForCurrentLanguage->LastModified = QDateTime::Now();
$this->objProjectProgressForCurrentLanguage->Active = $this->Active;
$this->objProjectProgressForCurrentLanguage->Save();
}
return $this->objProjectProgressForCurrentLanguage;
}
case 'DefaultTemplatePath':
return __IMPORT_PATH__ . '/' . $this->ProjectId . '/' . NarroLanguage::SOURCE_LANGUAGE_CODE;
case 'DefaultTranslationPath':
return __IMPORT_PATH__ . '/' . $this->ProjectId . '/' . QApplication::$TargetLanguage->LanguageCode;
default:
try {
return parent::__get($strName);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
}
protected function btnDelete_Create()
{
$this->btnDelete = new QButton($this);
$this->btnDelete->Text = QApplication::Translate('Delete');
$this->btnDelete->AddAction(new QClickEvent(), new QConfirmAction(QApplication::Translate('Are you SURE you want to DELETE this language?')));
$this->btnDelete->AddAction(new QClickEvent(), new QServerControlAction($this, 'btnDelete_Click'));
$this->btnDelete->CausesValidation = false;
if (!$this->blnEditMode) {
$this->btnDelete->Visible = false;
}
$this->btnDelete->Visible = $this->objNarroLanguage->LanguageId != QApplication::$SourceLanguage->LanguageId && $this->objNarroLanguage->LanguageId != QApplication::GetLanguageId();
}
public function dtgLanguage_ActiveColumn_Render(NarroLanguage $objLanguage)
{
if ($objLanguage->LanguageId == QApplication::$SourceLanguage->LanguageId || $objLanguage->LanguageId == QApplication::GetLanguageId()) {
return '';
}
$objCheckBox = $this->Form->GetControl('activelang' . $objLanguage->LanguageId);
if (!$objCheckBox instanceof QCheckBox) {
$objCheckBox = new QCheckBox($this->dtgLanguage, 'activelang' . $objLanguage->LanguageId);
$objCheckBox->ActionParameter = $objLanguage->LanguageId;
if (QApplication::$UseAjax) {
$objCheckBox->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'chkActive_Click'));
} else {
$objCheckBox->AddAction(new QClickEvent(), new QServerControlAction($this, 'chkActive_Click'));
}
}
$objCheckBox->Checked = $objLanguage->Active;
return $objCheckBox->Render(false);
}
public function btnDelete_Click($strFormId, $strControlId, $strParameter)
{
$objSuggestion = NarroSuggestion::Load($strParameter);
if ($this->btnSaveIgnore && $this->btnSaveIgnore->ControlId == $strControlId || !$this->IsSuggestionUsed($objSuggestion)) {
QApplication::$PluginHandler->DeleteSuggestion($this->objContextInfo->Context->Text->TextValue, $objSuggestion->SuggestionValue, $this->objContextInfo->Context->Context, $this->objContextInfo->Context->File, $this->objContextInfo->Context->Project);
if (!QApplication::HasPermissionForThisLang('Can delete any suggestion', $this->objContextInfo->Context->ProjectId) && ($objSuggestion->UserId != QApplication::GetUserId() || QApplication::GetUserId() == NarroUser::ANONYMOUS_USER_ID)) {
return false;
}
$objSuggestion->Delete();
if (NarroSuggestion::CountByTextIdLanguageId($this->objContextInfo->Context->TextId, QApplication::GetLanguageId()) == 0) {
$arrCtx = NarroContextInfo::QueryArray(QQ::AndCondition(QQ::Equal(QQN::NarroContextInfo()->Context->TextId, $this->objContextInfo->Context->TextId), QQ::Equal(QQN::NarroContextInfo()->LanguageId, QApplication::GetLanguageId())));
foreach ($arrCtx as $objContextInfo) {
$objContextInfo->HasSuggestions = 0;
$objContextInfo->Modified = QDateTime::Now();
$objContextInfo->Save();
}
$this->objContextInfo->HasSuggestions = 0;
$this->objContextInfo->Save();
}
foreach ($this->Form->GetAllControls() as $ctl) {
if ($ctl instanceof NarroContextInfoEditor) {
if ($ctl->TranslationList && $ctl->Text->Text == $this->lblText->Text) {
$ctl->btnHelp_Click($this->Form->FormId, $ctl->btnHelp->ControlId, '');
}
}
}
$this->lblMessage->Text = t('Suggestion succesfully deleted.');
$this->blnModified = true;
if ($this->btnSaveIgnore) {
$this->btnSave->Display = true;
}
} else {
$this->btnSaveIgnore_Create();
$this->btnSaveIgnore->Display = true;
$this->btnSaveIgnore->Text = t('Ignore and delete');
$this->btnSaveIgnore->RemoveAllActions('click');
$this->btnSaveIgnore->ActionParameter = $strParameter;
$this->btnSaveIgnore->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'btnDelete_Click'));
}
}
public function btnExport_Click($strFormId, $strControlId, $strParameter)
{
if (!QApplication::HasPermissionForThisLang('Can export project', $this->objProject->ProjectId)) {
return false;
}
$strProcLogFile = __TMP_PATH__ . '/' . $this->objProject->ProjectId . '-' . QApplication::$TargetLanguage->LanguageCode . '-export-process.log';
if ($strParameter == 1) {
if (NarroUtils::IsProcessRunning('export', $this->objProject->ProjectId)) {
$this->objExportProgress->Translated = NarroProgress::GetProgress($this->objProject->ProjectId, 'export');
$this->objExportProgress->MarkAsModified();
} else {
$this->lblExport->Text = t('Export finished.');
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript('if (typeof lastExportId != \'undefined\') clearInterval(lastExportId)');
}
if (file_exists($strProcLogFile) && filesize($strProcLogFile)) {
NarroLogger::LogInfo(sprintf('There are messages from the background process: %s', file_get_contents($strProcLogFile)));
}
$this->lblExport->Visible = true;
$this->btnExport->Visible = true;
$this->btnKillProcess->Visible = false;
$this->objExportProgress->Translated = 0;
$this->objExportProgress->Visible = false;
QApplication::$PluginHandler->DisplayExportMessage($this->objProject);
if (is_array(QApplication::$PluginHandler->PluginReturnValues)) {
foreach (QApplication::$PluginHandler->PluginReturnValues as $strPluginName => $mixReturnValue) {
if (count($mixReturnValue) == 2 && $mixReturnValue[0] instanceof NarroProject && is_string($mixReturnValue[1]) && $mixReturnValue[1] != '') {
$this->lblExport->Text .= sprintf('<br /><span class="info"><b>%s</b>: %s</span>', $strPluginName, nl2br($mixReturnValue[1]));
}
}
}
}
$this->pnlLogViewer->MarkAsModified();
} elseif ($strParameter == 2) {
$this->pnlLogViewer->DateStart = QDateTime::Now();
$this->pnlLogViewer->ProjectId = $this->objProject->ProjectId;
$this->pnlLogViewer->LanguageId = QApplication::GetLanguageId();
NarroProgress::ClearProgressFileName($this->objProject->ProjectId, 'import');
set_time_limit(0);
if ($this->chkCleanDirectory->Checked) {
NarroUtils::RecursiveDelete($this->objProject->DefaultTranslationPath . '/*');
}
$objNarroImporter = new NarroProjectImporter();
/**
* Get boolean options
*/
$objNarroImporter->ExportedSuggestion = $this->lstExportSuggestionType->SelectedValue;
$objNarroImporter->Project = $this->objProject;
$objNarroImporter->ExportAuthorList = $this->txtAuthor->Text;
$objNarroImporter->User = QApplication::$User;
$objNarroImporter->TargetLanguage = QApplication::$TargetLanguage;
$objNarroImporter->SourceLanguage = NarroLanguage::LoadByLanguageCode(NarroLanguage::SOURCE_LANGUAGE_CODE);
try {
$objNarroImporter->TranslationPath = $this->objProject->DefaultTranslationPath;
$objNarroImporter->TemplatePath = $this->objProject->DefaultTemplatePath;
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during export: %s', $objEx->getMessage()));
$this->lblExport->Text = t('Export failed.');
}
try {
$objNarroImporter->ExportProject();
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during export: %s', $objEx->getMessage()));
$this->lblExport->Text = t('Export failed.');
}
$this->lblExport->Visible = true;
$this->btnExport->Visible = true;
$this->btnKillProcess->Visible = false;
$this->objExportProgress->Visible = false;
$this->pnlLogViewer->MarkAsModified();
} else {
$this->pnlLogViewer->DateStart = QDateTime::Now();
$this->pnlLogViewer->ProjectId = $this->objProject->ProjectId;
$this->pnlLogViewer->LanguageId = QApplication::GetLanguageId();
if ($this->chkCleanDirectory->Checked) {
NarroUtils::RecursiveDelete($this->objProject->DefaultTranslationPath . '/*');
}
$this->btnExport->Visible = false;
$this->btnKillProcess->Visible = $this->btnKillProcess->Visible = QApplication::HasPermission('Administrator', $this->objProject, QApplication::$TargetLanguage->LanguageCode);
$this->objExportProgress->Visible = true;
$this->objExportProgress->Translated = 0;
$this->lblExport->Text = '';
try {
$strCommand = sprintf('%s %s --export --project %d --user %d --template-lang %s --translation-lang %s --template-directory %s --translation-directory %s --exported-suggestion %d --export-author-list %s', __PHP_CLI_PATH__, escapeshellarg(sprintf('%s/includes/narro/importer/narro-cli.php', __DOCROOT__ . __SUBDIRECTORY__)), (int) $this->objProject->ProjectId, (int) QApplication::$User->UserId, escapeshellarg(NarroLanguage::SOURCE_LANGUAGE_CODE), escapeshellarg(QApplication::$TargetLanguage->LanguageCode), escapeshellarg($this->objProject->DefaultTemplatePath), escapeshellarg($this->objProject->DefaultTranslationPath), (int) $this->lstExportSuggestionType->SelectedValue, escapeshellarg($this->txtAuthor->Text));
} catch (Exception $objEx) {
NarroLogger::LogError(sprintf('An error occurred during export: %s', $objEx->getMessage()));
$this->lblExport->Text = t('Export failed.');
$this->lblExport->Visible = true;
$this->btnExport->Visible = true;
$this->btnKillProcess->Visible = false;
$this->objExportProgress->Translated = 0;
$this->objExportProgress->Visible = false;
$this->pnlLogViewer->MarkAsModified();
return false;
}
if (file_exists($strProcLogFile) && is_writable($strProcLogFile)) {
unlink($strProcLogFile);
}
$mixProcess = proc_open("{$strCommand} &", array(2 => array("file", $strProcLogFile, 'a')), $foo);
if ($mixProcess) {
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript(sprintf('lastExportId = setInterval("qc.pA(\'%s\', \'%s\', \'QClickEvent\', \'1\')", %d);', $strFormId, $strControlId, 2000));
} else {
$this->btnExport_Click($strFormId, $strControlId, 1);
}
} else {
$this->objExportProgress->Visible = false;
NarroLogger::LogError('Failed to launch a background process, there will be no progress displayed, and it might take a while, please wait for more messages');
$this->pnlLogViewer->MarkAsModified();
/**
* try exporting without launching a background process
*/
if (QApplication::$UseAjax) {
QApplication::ExecuteJavaScript(sprintf('lastExportId = setTimeout("qc.pA(\'%s\', \'%s\', \'QClickEvent\', \'2\')", %d);', $strFormId, $strControlId, 2000));
} else {
$this->btnExport_Click($strFormId, $strControlId, 2);
}
}
}
}
