protected function build_raw_sql_crits_to_words(Utils_RecordBrowser_CritsRawSQL $crits) { $sql = $crits->get_negation() ? $crits->get_negation_sql() : $crits->get_sql(); $value = implode(', ', $crits->get_vals()); $ret = __('Raw SQL') . ': ' . "'{$sql}'" . __('with values') . ': ' . "({$value})"; return array('str' => $ret, 'multiple' => true); }
protected function validate_sql(Utils_RecordBrowser_CritsRawSQL $crits, $record) { $sql = $crits->get_negation() ? $crits->get_negation_sql() : $crits->get_sql(); if ($sql) { $sql = "AND {$sql}"; } $ret = DB::GetOne("SELECT 1 FROM {$this->tab}_data_1 WHERE id=%d {$sql}", array($record['id'])); return $ret ? true : false; }