Example #1
0
 function handle(&$params)
 {
     //echo "Hello World from the controller class!!";
     //to do interesting stuff here we get info from the Dataface_Application object
     $app =& Dataface_Application::getInstance();
     // reference to Dataface_Application object
     $auth =& Dataface_AuthenticationTool::getInstance();
     // reference to Dataface_Authentication object
     //if ( !isset($_POST['--bid-amount']) ) {
     //$request =& $app->getQuery();  // Request vars:  e.g. [-table]=>'Students', [-action]=>'hello'
     $records =& df_get_records('detail', $query);
     $user =& $auth->getLoggedInUser();
     // Dataface_Record object of currently logged in user.
     $current_tablename =& $request['-table'];
     $current_record =& $app->getRecord();
     // Currently selected record (Dataface_Record object)
     $results =& $app->getResultSet();
     // Current found set (Dataface_QueryTool object).
     // Iterating through the results
     $it =& $results->iterator();
     while ($it->hasNext()) {
         $record =& $it->next();
         // $record is a Dataface_Record object
         print_r($record->strvals());
         unset($record);
         // necessary so that PHP doesn't just keep overwriting the same object.
     }
     // Perform a custom SQL Query:
     //$res = mysql_query("select * from foo inner join bar on foo.x=bar.y", $app->db());
     // .. etc ...
     // Obtain parameters from the actions.ini file for this action:
     $template_name = $params['action']['template'];
     // The value of the template parameter
     //df_display(array(), $template_name);  // this form allows you to change the template to use by modifying the actions.ini file.
     df_display(array(), 'JobWorld.html');
 }
Example #2
0
 function &df_get_records_array($table, $query = null, $start = null, $limit = null, $preview = true)
 {
     $records = array();
     $it = df_get_records($table, $query, $start, $limit, $preview);
     if (PEAR::isError($it)) {
         return $it;
     }
     while ($it->hasNext()) {
         $records[] = $it->next();
     }
     return $records;
 }
Example #3
0
 function getChildren($record)
 {
     return df_get_records('payments', array('date' == '=' . $record->val('paymentdate1')));
 }
 function processForm($values)
 {
     ini_set('max_execution_time', 900);
     import('Dataface/IO.php');
     import('Dataface/TranslationTool.php');
     $tt = new Dataface_TranslationTool();
     $app =& Dataface_Application::getInstance();
     $query =& $app->getQuery();
     if (strlen($values['-sourceLanguage']) != 2 || strlen($values['-destinationLanguage']) != 2) {
         trigger_error('Invalid input for languages.  Expected a 2 digit language code.', E_USER_ERROR);
     }
     $values['-limit'] = 500;
     //$qt = new Dataface_QueryTool($this->table->tablename, $app->db(), $values);
     //$qt->loadSet();
     //$it =& $qt->iterator();
     $q = $query;
     $q['-limit'] = 9999;
     if (@$q['--limit']) {
         $q['-limit'] = $q['--limit'];
     }
     $it =& df_get_records($this->table->tablename, $q);
     $keycols = array_keys($this->table->keys());
     $cols = $this->table->getTranslation($values['-destinationLanguage']);
     if (!is_array($cols)) {
         trigger_error('Could not find any columns to be translated in table ' . $values['-destinationLanguage'] . Dataface_Error::printStackTrace(), E_USER_ERROR);
     }
     $babelfish = $this->getTranslator();
     //new babelfish();
     if (isset($app->_conf['google_translate_url'])) {
         $babelfish->google_url_webpage = $app->_conf['google_translate_url'];
     }
     $ioSrc = new Dataface_IO($this->table->tablename);
     $ioSrc->lang = $values['-sourceLanguage'];
     $languageCodes = new I18Nv2_Language('en');
     $ioDest = new Dataface_IO($this->table->tablename);
     $ioDest->lang = $values['-destinationLanguage'];
     $count = 0;
     $to_be_translated = array();
     $destObjects = array();
     while ($it->hasNext()) {
         $curr =& $it->next();
         $translationInfo =& $tt->getTranslationRecord($curr, $values['-destinationLanguage']);
         if ($translationInfo and $translationInfo->val('translation_status') == TRANSLATION_STATUS_NEEDS_UPDATE_MACHINE) {
             $t_needsUpdate = true;
         } else {
             $t_needsUpdate = false;
         }
         $translation_text = array();
         $keyvals = $curr->vals($keycols);
         $srcObject = new Dataface_Record($this->table->tablename, array());
         $destObject = new Dataface_Record($this->table->tablename, array());
         $ioSrc->read($keyvals, $srcObject);
         $ioDest->read($keyvals, $destObject);
         $keyvalsQuery = $keyvals;
         foreach ($keyvals as $key => $val) {
             $keyvalsQuery[$key] = '=' . $keyvals[$key];
         }
         $qb = new Dataface_QueryBuilder($this->table->tablename, $keyvalsQuery);
         $sql = "select * from `" . $this->table->tablename . "_" . $values['-destinationLanguage'] . "` " . $qb->_where();
         $res = mysql_query($sql, $app->db());
         if (!$res) {
             trigger_error(mysql_error($app->db()) . 'SQL : ' . $sql . " Stacktrace:" . Dataface_Error::printStackTrace(), E_USER_ERROR);
         }
         $queryResult = mysql_fetch_array($res);
         if (!$queryResult) {
             $queryResult = array();
         }
         foreach ($cols as $col) {
             if (in_array($col, $keycols)) {
                 continue;
             }
             if (!$this->table->isText($col) and !$this->table->isChar($col)) {
                 continue;
             }
             if (!isset($queryResult[$col]) || $t_needsUpdate) {
                 //$updateRequired = true;
             } else {
                 continue;
             }
             $translation_text[$col] = $srcObject->getValue($col);
         }
         if (count($translation_text) > 0) {
             $to_be_translated[] =& $translation_text;
             $destObjects[] =& $destObject;
         }
         unset($curr);
         unset($srcObject);
         unset($destObject);
         unset($qb);
         unset($translatedRecord);
         unset($translation_text);
         unset($translationInfo);
     }
     $translated = $this->translate($to_be_translated, $values['-sourceLanguage'], $values['-destinationLanguage'], $babelfish);
     if (PEAR::isError($translated)) {
         return $translated;
     }
     foreach ($translated as $rowid => $row) {
         if ($translated[$rowid] == $to_be_translated[$rowid]) {
             continue;
         }
         $update = false;
         foreach ($row as $col => $val) {
             if (strlen(trim($val)) === 0) {
                 continue;
             }
             $destObjects[$rowid]->setValue($col, $val);
             $update = true;
         }
         if ($update) {
             $res = $ioDest->write($destObjects[$rowid]);
             if (PEAR::isError($res)) {
                 trigger_error($res->toString() . Dataface_Error::printStackTrace(), E_USER_ERROR);
             }
             $tt->setTranslationStatus($destObjects[$rowid], $ioDest->lang, TRANSLATION_STATUS_MACHINE);
         }
     }
 }
Example #5
0
 /**
  * Invalidates the non-original translations.  This will set the translation
  * statuses as follows:
  *	Unknown -> Unknown
  *	Machine -> Out-of-date (Machine translation)
  *	Approved -> Out-of-date
  *	Unverified -> Out-of-date (Unverified)
  *  Original -> Original
  *  Out-of-date * -> Out-of-date *
  */
 function invalidateTranslations(&$record)
 {
     $records = df_get_records('dataface__translations', array('record_id' => '=' . $this->getRecordId($record), 'table' => $record->_table->tablename));
     if (PEAR::isError($records)) {
         throw new Exception($records->toString(), E_USER_ERROR);
     }
     while ($records->hasNext()) {
         $trecord = $records->next();
         $update = true;
         switch ($trecord->val('translation_status')) {
             case TRANSLATION_STATUS_MACHINE:
                 $trecord->setValue('translation_status', TRANSLATION_STATUS_NEEDS_UPDATE_MACHINE);
                 break;
             case TRANSLATION_STATUS_UNVERIFIED:
                 $trecord->setValue('translation_status', TRANSLATION_STATUS_NEEDS_UPDATE_UNVERIFIED);
                 break;
             case TRANSLATION_STATUS_APPROVED:
                 $trecord->setValue('translation_status', TRANSLATION_STATUS_NEEDS_UPDATE);
                 break;
             default:
                 $update = false;
                 //  no update necessary
         }
         if ($update) {
             $res = $trecord->save();
             if (PEAR::isError($res)) {
                 return $res;
             }
         }
         unset($trecord);
     }
     return true;
 }
Example #6
0
 function delete($values)
 {
     require_once 'Dataface/IO.php';
     $query = $this->_buildDeleteQuery($values);
     if (PEAR::isError($query)) {
         return $query;
     }
     $io = new Dataface_IO($this->_tablename);
     $it =& df_get_records($this->_tablename, $query);
     $warnings = array();
     while ($it->hasNext()) {
         $record =& $it->next();
         $res = $io->delete($record);
         if (PEAR::isError($res) && Dataface_Error::isError($res)) {
             // this is a serious error... kill it
             return $res;
         } else {
             if (PEAR::isError($res)) {
                 // this is a warning or a notice
                 $warnings[] = $res;
             }
         }
         unset($record);
     }
     if (count($warnings) > 0) {
         return $warnings;
     }
     return true;
 }