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>
if ($aid) { $asn = new Assign(); $asn->id = $aid; $asn->find(); $req = new Request(); $req->id = $asn->rid; $req->find(); $requestor = $req->name; $requestor_phone = parse_phone($req->phone); $deadline = $asn->complete; $description = $req->description; } else { if ($id) { $rec = new Record(); $rec->id = $id; $rec->find(); $asn = new Assign(); $asn->id = $rec->aid; $asn->find(); $req = new Request(); $req->id = $asn->rid; $req->find(); $requestor = $req->name; $requestor_phone = parse_phone($req->phone); $deadline = $asn->complete; $description = $req->description; $hours = $rec->hours; $materials = $rec->materials; $cost = '$' . $rec->cost; } }