source: trunk/save.php@ 536

<?php

include_once('includes/global.php');


$Output = '';
$CompleteText = array('nedokončený', 'dokončený');

unset($Message);
HandleLoginForm();
if(isset($Message)) $Output .= ShowMessage($Message, $MessageType);

$GroupId = LoadGroupIdParameter();
$Group = $TranslationTree[$GroupId];
$Table = $Group['TablePrefix'];
if($User->Licence(LICENCE_USER)) 
{
  if(array_key_exists('ID', $_POST) and is_numeric($_POST['ID']))
  {
    $Entry = $_POST['entry'] * 1;
    $TextID = $_POST['ID'] * 1;
    $Language = $_POST['Language'] * 1;
    if(array_key_exists('End', $_POST)) $Complete = 1;
      else $Complete = 0;
    
    // Get source text record from database by ID
    $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE `ID`='.$TextID);
    if($DbResult->num_rows > 0)
    {
      $SourceText = $DbResult->fetch_assoc();
      
      // Get data for english original
      $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`Entry`='.$SourceText['Entry'].') AND (`Language` = '.$Config['OriginalLanguage'].') AND (`VersionStart` = '.$SourceText['VersionStart'].') AND (`VersionEnd` = '.$SourceText['VersionEnd'].')');
      if($DbResult->num_rows > 0)
      {
        $EnglishText = $DbResult->fetch_assoc();
        
        // Get all similar english texts
        $Filter = '';
        foreach($Group['Items'] as $GroupItem)
          if(($GroupItem['Visible'] == 1) and ($EnglishText[$GroupItem['Column']] != ''))
            $Filter .= ' OR (`'.$GroupItem['Column'].'` = "'.addslashes($EnglishText[$GroupItem['Column']]).'")';
        $Filter = ' AND ('.substr($Filter, 3).')';
        
        $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`Language` = '.$Config['OriginalLanguage'].')'.$Filter);
        while($EnglishFound = $DbResult->fetch_assoc())
        {         
          // Get user translation paired to found english item entry
          $DbResult2 = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`User` = '.$User->Id.') AND (`Entry` = '.$EnglishFound['Entry'].') AND (`VersionStart` = '.$EnglishFound['VersionStart'].') AND (`VersionEnd` = '.$EnglishFound['VersionEnd'].')');
          if($DbResult2->num_rows > 0)
          {
            // Update existed user translation
            $ExistedText = $DbResult2->fetch_assoc();
            $Values = '`Language` = '.$Language;
            
            $UpdateModifyTime = false;
            $Completable = true;
            $CompleteParts = $ExistedText['CompleteParts'];
            foreach($Group['Items'] as $GroupItem)
            {
              if($GroupItem['Visible'] == 1)
              {
                if($SourceText[$GroupItem['Column']] != $ExistedText[$GroupItem['Column']]) 
                  $UpdateModifyTime = true;
                
                if($EnglishFound[$GroupItem['Column']] == $EnglishText[$GroupItem['Column']])
                {
                  if(array_key_exists($GroupItem['Column'], $_POST))
                  {
                    $Values .= ', `'.$GroupItem['Column'].'` = "'.$_POST[$GroupItem['Column']].'"'; 
                    $CompleteParts |= (1 << ($GroupItem['Sequence'] - 1));
                  }
                } 
                if((($CompleteParts & (1 << ($GroupItem['Sequence'] - 1))) == 0) and ($EnglishFound[$GroupItem['Column']] != '')) $Completable = false;
              }
            }
            if($Completable) $NewComplete = 1; // All parts of text are completed. Make entire text as completed
              else $NewComplete = 0; 
            if($SourceText['ID'] == $ExistedText['ID']) 
            {
              $NewComplete = $Complete; // Our original user text, set complete according user choice
              if($Complete == 1)
              {
                foreach($Group['Items'] as $GroupItem)
                  if($GroupItem['Visible'] == 1) $CompleteParts |= (1 << ($GroupItem['Sequence'] - 1));
              }
            }
            $Values .= ', `Complete`='.$NewComplete.', `CompleteParts` = '.$CompleteParts;
            
            if($UpdateModifyTime) $Values .= ', `ModifyTime` = NOW()';
            
            // Update user translation
            $System->Database->query('UPDATE `'.$Table.'` SET '.$Values.' WHERE `ID` = '.$ExistedText['ID']);
            
            $Output .= 'Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$ExistedText['ID'].'">'.$ExistedText['ID'].'</a> ('.$ExistedText['Entry'].') uloženy jako '.$CompleteText[$NewComplete].'.<br />';
            WriteLog('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$ExistedText['ID'].'">'.$ExistedText['ID'].'</a> ('.$ExistedText['Entry'].') uloženy jako '.$CompleteText[$NewComplete].'.', LOG_TYPE_TRANSLATION);
          } else
          {
            // Insert new user translation
            $Columns = '`Entry`, `VersionStart`, `VersionEnd`, `Language`, `User`, `Take`, `ModifyTime`';
            $Values = $EnglishFound['Entry'].', '.$EnglishFound['VersionStart'].', '.$EnglishFound['VersionEnd'].', '.$Language.', '.$User->Id.', '.$SourceText['ID'].', NOW()';

            $CompleteParts = 0;
            $Completable = true;
            foreach($Group['Items'] as $GroupItem)
            {
              $Columns .= ', `'.$GroupItem['Column'].'`';
              if($GroupItem['Visible'] == 1)
              {
                if($EnglishFound[$GroupItem['Column']] == $EnglishText[$GroupItem['Column']])
                {
                  // Read form user data
                  if(array_key_exists($GroupItem['Column'], $_POST))
                  {
                    $Values .= ', "'.$_POST[$GroupItem['Column']].'"'; 
                    $CompleteParts |= (1 << ($GroupItem['Sequence'] - 1));
                  } else $Values .= ', "'.addslashes($EnglishFound[$GroupItem['Column']]).'"'; 
                } else $Values .= ', "'.addslashes($EnglishFound[$GroupItem['Column']]).'"'; 
                if((($CompleteParts & (1 << ($GroupItem['Sequence'] - 1))) == 0) and ($EnglishFound[$GroupItem['Column']] != '')) $Completable = false;
              } else 
              {
                // Read from english text
                $Values .= ', "'.$EnglishFound[$GroupItem['Column']].'"'; 
              }
            }
            if($Completable) $NewComplete = 1; // All parts of text are completed. Make entire text as completed
              else $NewComplete = 0; 
            if($SourceText['ID'] == $EnglishFound['ID'])
            {
              $NewComplete = $Complete; // Our original user text, set complete according user choice
              if($Complete == 1)
              {
                foreach($Group['Items'] as $GroupItem)
                  if($GroupItem['Visible'] == 1) $CompleteParts |= (1 << ($GroupItem['Sequence'] - 1));
              }
            }
            $Columns .= ', `Complete`, `CompleteParts`';
            $Values .= ', '.$NewComplete.', '.$CompleteParts;

            $System->Database->query('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
            $LastID = $System->Database->insert_id;
            
            $Output .= 'Text <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> ze skupiny <a href="TranslationList.php?group='.$GroupId.'&amp;user=0&amp;action=filter">'.$TranslationTree[$GroupId]['Name'].'</a> uložen jako '.$CompleteText[$NewComplete].'. Převzat z <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>.<br/>';
            WriteLog('Text <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> ze skupiny <a href="TranslationList.php?group='.$GroupId.'&amp;user=0&amp;text=&amp;entry=&amp;action=filter">'.$TranslationTree[$GroupId]['Name'].'</a> uložen jako '.$CompleteText[$NewComplete].'. Převzat z <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>.', LOG_TYPE_TRANSLATION);
          }
        }        
      } else $Output .= ShowMessage('Anglický originál k překladu nenalezen.', MESSAGE_CRITICAL);      
    } else $Output .= ShowMessage('Zadaná položka nenalezena.', MESSAGE_CRITICAL);             
             
             
  // Address and redirecting
  $Output .= '<br />Překládat: <a href="TranslationList.php?group='.$GroupId.'&amp;state=1&amp;user=0&entry=">Nepřeložené</a> '; 

  $prev = FollowingTran($TextID, $Table, $GroupId, True);
  $next = FollowingTran($TextID, $Table, $GroupId);
  $Output .= '<br /><br />';
  $DbResult = $System->Database->query('SELECT `Redirecting` FROM `User` WHERE `ID`='.$User->Id);
  $redirecting = $DbResult->fetch_assoc();
    
  switch($redirecting['Redirecting']) 
  {
    case 1:
      $Output .= '<script type="text/javascript" language="JavaScript" charset="utf-8">'.
       'setTimeout("parent.location.href=\''.htmlspecialchars_decode('TranslationList.php?group='.$GroupId.'&amp;state=1&amp;user=0').'\'", 1500)'.
       '</script>';
      break;
    case 2:
      if($next <> '')
        $Output .= '<script type="text/javascript" language="JavaScript" charset="utf-8">'.
          'setTimeout("parent.location.href=\''.htmlspecialchars_decode($next).'\'", 1500)'.
          '</script>';
      break;
    case 3:
      if($prev <> '')
        $Output .= '<script type="text/javascript" language="JavaScript" charset="utf-8">'.
          'setTimeout("parent.location.href=\''.htmlspecialchars_decode($prev).'\'", 1500)'.
          '</script>';
    break;
  }
  
  $Output .= 'Z této stránky můžete být automaticky přesměrování. Nastavit kam chcete být přesměrování si můžete v <a href="'.$System->Link('/Options.php').'" title="Nastavení uživatele">Nastavení</a>';
    
  // Update flag for experience info load
  $System->Database->query('UPDATE `User` SET `NeedUpdate` = 1 WHERE `ID` = '.$User->Id); 
  } else $Output .= ShowMessage('Položka nenalezena', MESSAGE_CRITICAL);
} else 
{
  if(array_key_exists('ID', $_POST) and array_key_exists('entry', $_POST) and array_key_exists('Language', $_POST) and array_key_exists('user', $_POST)) 
  {
    $Output .= 'Byli jste automaticky odhlášeni. Pro <strong>Uložení překladu</strong> se musíte přihlásit zde:<br /><br />'.
      '<form action="save.php?action=login&amp;group='.$GroupId.'" method="post"><div>'.
      '<input type="hidden" name="entry" value="'.$_POST['entry'].'" />'.
      '<input type="hidden" name="user" value="'.$_POST['user'].'" />'.
      '<input type="hidden" name="ID" value="'.$_POST['ID'].'" />'.
      '<input type="hidden" name="Language" value="'.$_POST['Language'].'" />';    

    foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
    {
      if(array_key_exists($TextItem['Column'], $_POST)) $Value = $_POST[$TextItem['Column']]; else $Value = '';
      $Output .= '<input id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'" type="hidden" value="'.htmlspecialchars($Value).'" />';
    }  
    $Output .= '<table>'.
    '<tr>'.
    '<td>Jméno: <input type="text" name="LoginUser" size="13" /></td>'.
    '</tr><tr>'.
    '<td>Heslo: <input type="password" name="LoginPass" size="13" /></td>'.
    '</tr><tr>'.
    '<th><input type="submit" value="Přihlásit a uložit překlad" /></th>'.
    '</tr>'.
    '</table>';  
  } else $Output = ShowMessage('Nezadány požadované údaje.', MESSAGE_CRITICAL);
}
          
ShowPage($Output);

?>