PHP Utils_RecordBrowser_CritsRawSQL Examples

Example #1

File: CritsToWords.php Project: cretzu89/EPESI

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

Example #2

File: CritsValidator.php Project: cretzu89/EPESI

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