PHP Record::find方法代码示例

 public function update_soa_record()
 {
     $today = date('Ymd');
     $r = Record::find('first', array('conditions' => "domain_id=" . Domain::quote($this->id) . " AND type='SOA'"));
     $soa = explode(" ", $r->content);
     if (strncmp($today, $soa[2], 8) === 0) {
         /*
          * Current serial starts with date of today, so we need to update
          * the revision only. To do so, determine current revision first,
          * then update counter.
          */
         $revision = (int) substr($soa[2], -2);
         ++$revision;
     } else {
         /*
          * Current serial did not start of today, so it's either an older
          * serial or a serial that does not adhere the recommended syntax
          * of RFC-1912. In either way, set a fresh serial
          */
         $revision = "00";
     }
     /*
      * Add additional 0 if $revision is 1 .. 9 so we get a nice number like 01, etc..
      */
     $newserial = $today . str_pad($revision, 2, "0", STR_PAD_LEFT);
     $soa[2] = $newserial;
     /*
      * Reconstruct SOA record's content string
      */
     foreach ($soa as $value) {
         $content .= $value . " ";
     }
     $r->content = $content;
     $r->save();
 }

 public static function updateRecord($input, $id)
 {
     $answer = [];
     $rules = ['municipality_id' => 'required|integer', 'number_starting' => 'required', 'folio' => 'required', 'file' => 'required', 'date' => 'required', 'interested_m' => 'required', 'interested_f' => 'required', 'starting' => 'required'];
     $validation = Validator::make($input, $rules);
     if ($validation->fails()) {
         $answer['message'] = $validation;
         $answer['error'] = true;
     } else {
         $record = Record::find($id);
         $record->municipality_id = $input['municipality_id'];
         $record->number_starting = $input['number_starting'];
         $record->folio = $input['folio'];
         $record->file = $input['file'];
         $record->date = $input['date'];
         $record->interested_m = $input['interested_m'];
         $record->interested_f = $input['interested_f'];
         $record->starting = $input['starting'];
         $record->description = $input['description'];
         if ($record->save()) {
             $answer['message'] = 'Editado con exito!';
             $answer['error'] = false;
         } else {
             $answer['message'] = 'RECORD UPDATE error, team noob!';
             $answer['error'] = false;
         }
     }
     return $answer;
 }

 public function is_unique()
 {
     $result = array('is_ok' => true, 'message' => 'Record is unique!');
     if (Record::find('first', array('conditions' => 'name = ' . Record::quote($this->name) . ' AND type = ' . Record::quote($this->type) . ' AND content = ' . Record::quote($this->content)))) {
         $result['is_ok'] = false;
         $result['message'] = "Record already exists!";
         return $result;
     }
     /*
      * Consistany check for SOA records, only allowed once at a domain
      */
     if ($this->type === SOA) {
         if (Record::find('first', array('conditions' => 'domain_id = ' . Record::quote($this->domain_id) . ' AND type = ' . Record::quote($this->type)))) {
             $result['is_ok'] = false;
             $result['message'] = "Soa record only allowed once at a domain!";
             return $result;
         }
     }
     return $result;
 }

 public function index()
 {
     if (fAuthorization::checkLoggedIn()) {
         $this->cache_control('private', 2);
     } else {
         $this->cache_control('private', 5);
     }
     $top = fRequest::get('top', 'integer');
     $this->owner = trim(fRequest::get('owner'));
     $this->problem_id = trim(fRequest::get('problem'));
     $this->language = trim(fRequest::get('language'));
     $this->verdict = trim(fRequest::get('verdict'));
     $this->page = fRequest::get('page', 'integer', 1);
     $this->records = Record::find($top, $this->owner, $this->problem_id, $this->language, $this->verdict, $this->page);
     $this->page_records = $this->records;
     $common_url = SITE_BASE . "/status?owner={$this->owner}&problem={$this->problem_id}&language={$this->language}&verdict={$this->verdict}";
     $this->top_url = "{$common_url}&top=";
     $this->page_url = "{$common_url}&page=";
     $this->nav_class = 'status';
     $this->render('record/index');
 }

    $start = $_GET["start"];
}
print $display->header();
if (!preg_match('/^\\d+$/', $_GET['id'])) {
    print $display->error("You hacker!");
    print $display->footer();
    exit(1);
}
try {
    $d = Domain::find($_GET['id']);
    $result = ActiveRecord::query("SELECT COUNT(*) AS count FROM records WHERE domain_id={$d->id}");
    $rCount = (int) $result[0]['count'];
    if ($rCount > $rowamount) {
        $findResult = Record::find('all', array('limit' => "{$rowamount}", 'offset' => "{$offset}", 'conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name'));
    } else {
        $findResult = Record::find('all', array('conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name'));
    }
} catch (Exception $e) {
    print $e->getMessage();
    print $display->footer();
    exit(0);
}
?>

<script language="JavaScript" src="http://www.mattkruse.com/javascript/datadumper/datadumper.js"></script>

<script type="text/javascript">

	function queue_record_edit_all() { 
		$$('form').each(function(form) {
				if(form.disabled == undefined) { 

 static function find($params = null, $class = __CLASS__)
 {
     return parent::find($params, $class);
 }

<?php

if (PHP_SAPI !== 'cli') {
    die("Testscript may only run in CLI-mode");
}
set_include_path(get_include_path() . PATH_SEPARATOR . '..');
require_once 'Record.php';
require_once 'Domain.php';
$test_domain = mt_rand() . '.example.com';
$test_name = 'record' . mt_rand();
$test_content = '127.0.0.1';
$d = new Domain(array('name' => $test_domain, 'master' => null, 'last_check' => null, 'type' => 'NATIVE', 'notified_serial' => null, 'account' => null));
$d->save();
$d->type = 'MASTER';
$d->save();
$r = new Record(array('name' => $test_name, 'type' => 'A', 'content' => $test_content, 'ttl' => '3600', 'prio' => '0', 'change_date' => date("U")));
$d->records_push($r);
foreach (Record::find('all', array('conditions' => 'name LIKE ' . ActiveRecord::quote($test_name . '%') . ' AND ' . 'content = ' . ActiveRecord::quote($test_content))) as $f) {
    $f->update_attributes(array('name' => $f->name . '1'));
    $f->destroy();
}
$d->destroy();

 public static function findByPageId($id, $class = __CLASS__)
 {
     $params['where'] = sprintf('page_id=%d', $id);
     return parent::find($params, $class);
 }

<input type="text" name="query" value="<?php 
echo isset($_GET['query']) ? $_GET['query'] : '';
?>
">
<input type="submit" name="submit" value="Search">
</form>

<?php 
if ($_GET["query"]) {
    $dFindResult = Domain::get_all(array('conditions' => 'd.name LIKE ' . Domain::quote($_GET['query'])));
    if (is_array($dFindResult) && count($dFindResult) > 0) {
        print '<h2>Domains (' . count($dFindResult) . ')</h2>';
        print $display->domains_header();
        foreach ($dFindResult as $domain) {
            print $display->domain($domain);
        }
        print $display->domains_footer();
        print '<br>';
    }
    flush();
    $rFindResult = Record::find('all', array('conditions' => 'name LIKE ' . Record::quote($_GET['query']) . ' OR ' . 'content LIKE ' . Record::quote($_GET['query']), 'order' => 'name'));
    if (is_array($rFindResult) && count($rFindResult) > 0) {
        print '<h2>Records (' . count($rFindResult) . ')</h2>';
        print $display->records_header();
        foreach ($rFindResult as $record) {
            print $display->record($record);
        }
        print $display->records_footer();
    }
}
print $display->footer();

    $json = [];
    $records = App\Record::where(function ($subquery) use($query) {
        $subquery->where('mrn', 'LIKE', '%' . $query . '%')->orWhere('name', 'LIKE', '%' . $query . '%')->orWhere('btn', 'LIKE', '%' . $query . '%');
    })->get();
    if (count($records) > 0) {
        foreach ($records as $record) {
            $json['items'][] = array('title' => 'Patient\'s Name: ' . $record->name, 'description' => 'MRN: ' . $record->mrn . '<br>' . 'Phone Number: ' . $record->btn, 'html_url' => route('record.show', $record->id));
        }
        return $json;
    } else {
        $json['items'][] = array('title' => "\"{$query}\" doesn't exist", 'description' => 'Record doesn\'t exist in our database.', 'html_url' => '#');
        return $json;
    }
});
get('record/show/{record_id}', ['as' => 'show_record', function ($record) {
    $record = Record::find($record);
    return view('medical_record_number.show', compact('record'));
}]);
// Ajax for updating status
get('user/update_status/{record}/{status}', function ($record, $status) {
    $user = App\User::find($record->user_id);
    $user->addStatus($status, $record->id);
    return;
});
get('user/update_status_break/{user}/{status}', function ($user, $status) {
    $user->addStatus($status);
    return;
});
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
Route::bind('records_2nd_list', function ($id) {
    return App\Record2ndList::whereId($id)->first();

 function archivesByDay($year = 'all')
 {
     $tablename = TABLE_PREFIX . 'page';
     $out = array();
     $res = Record::find(array('select' => "DISTINCT(DATE_FORMAT(created_on, '%Y/%m/%d')) AS date", 'from' => $tablename, 'where' => 'parent_id = :parent_id AND status_id != :status', 'order_by' => 'created_on DESC', 'values' => array(':parent_id' => $this->page->id, ':status' => Page::STATUS_HIDDEN)));
     foreach ($res as $r) {
         $out[] = $r->date;
     }
     return $out;
 }

 /**
  * Show the form for editing the specified record.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $record = Record::find($id);
     return View::make('records.edit', compact('record'));
 }

 static function findByPageId($id, $class = __CLASS__)
 {
     $params['sql'] = sprintf("SELECT tag.id AS id, tag.name AS name \n                                  FROM %s AS page_tag, %s AS tag\n                                  WHERE page_tag.page_id=%d AND page_tag.tag_id = tag.id", Record::tableize('PageTag'), Record::tableize('Tag'), $id);
     return parent::find($params, $class);
 }

 public function record_delete($p)
 {
     $dDeps = $this->get_DepsBeforeCommit($p);
     $domain_id = $dDeps["domain_id"];
     /*
      * Check if we received record_id else it's not possible to edit this record
      */
     if ($p->record_id != NULL) {
         $record_id = $p->record_id;
     } else {
         throw new Exception('Unable to remove this record, no valid record_id!');
     }
     $r = Record::find($p->record_id);
     $r->destroy();
     return true;
 }

        $year = '<option>' . date('Y', $time) . '</option>';
        $month = '<option>' . date('F', $time) . '</option>';
        $day = '<option>' . date('j', $time) . '</option>';
        $desc = $req->description;
        $checked = $req->approved ? 'checked="checked"' : '';
        // Get estimate information
        $asn = new Assign();
        $asn->rid = $id;
        $asn->find();
        $est_hours = $asn->hours;
        $est_cost = $asn->cost;
        // Get actual spending information
        $rec = new Record();
        // FIX THIS!!!
        $rec->uid = $asn->rid;
        $rec->find(false);
        // Sum spending information together
        while ($rec->rows()) {
            $act_hours += $rec->hours;
            $act_cost += $rec->cost;
        }
    }
    ?>
<!DOCTYPE html>
<head>
<title>Job History</title>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="jquery-1.7.min.js"></script>
<script type="text/javascript" src="validator.js"></script>
<script type="text/javascript" src="validate_history.js"></script>