public function stream(Record $record, Request $request) { if ($request->has('ts')) { $records = $record->where('date', '>=', $request->input('ts'))->orderBy('date', 'desc')->get(); } else { $records = $record->take(15)->orderBy('date', 'desc')->get(); } return response()->json($records); }
public function getRecordArray(Request $request) { $id = $request->id; $rid = RecordPreset::where('id', '=', $id)->first()->rid; $record = Record::where('rid', '=', $rid)->first(); $form = Form::where('fid', '=', $record->fid)->first(); $field_collect = $form->fields()->get(); $field_array = array(); foreach ($field_collect as $field) { $data = array(); $data['flid'] = $field->flid; $data['type'] = $field->type; if ($field->type == 'Text') { $textfield = TextField::where('rid', '=', $record->rid)->first(); $data['text'] = $textfield->text; $flid_array[] = $field->flid; } elseif ($field->type == 'Rich Text') { $rtfield = RichTextField::where('rid', '=', $record->rid)->first(); $data['rawtext'] = $rtfield->rawtext; $flid_array[] = $field->flid; } elseif ($field->type == 'Number') { $numberfield = NumberField::where('rid', '=', $record->rid)->first(); $data['number'] = $numberfield->number; $flid_array[] = $field->flid; } elseif ($field->type == 'List') { $listfield = ListField::where('rid', '=', $record->rid)->first(); $data['option'] = $listfield->option; $flid_array[] = $field->flid; } elseif ($field->type == 'Multi-Select List') { $mslfield = MultiSelectListField::where('rid', '=', $record->rid)->first(); $data['options'] = explode('[!]', $mslfield->options); $flid_array[] = $field->flid; } elseif ($field->type == 'Generated List') { $gnlfield = GeneratedListField::where('rid', '=', $record->rid)->first(); $data['options'] = explode('[!]', $gnlfield->options); $flid_array[] = $field->flid; } elseif ($field->type == 'Date') { $datefield = DateField::where('rid', '=', $record->rid)->first(); $date_array['circa'] = $datefield->circa; $date_array['era'] = $datefield->era; $date_array['day'] = $datefield->day; $date_array['month'] = $datefield->month; $date_array['year'] = $datefield->year; $data['data'] = $date_array; $flid_array[] = $field->flid; } elseif ($field->type == 'Schedule') { $schedfield = ScheduleField::where('rid', '=', $record->rid)->first(); $data['events'] = explode('[!]', $schedfield->events); $flid_array[] = $field->flid; } $field_array[$field->flid] = $data; } $response['data'] = $field_array; $response['flids'] = $flid_array; return $response; }
public function searchRecord(Request $request) { $cari = $request->get('mhs'); if ($cari == '') { return redirect()->back(); } else { $result = Record::where('nama_surat', 'LIKE', '%' . $cari . '%')->orWhere('keterangan', 'LIKE', '%' . $cari . '%')->paginate(10); return view('Records.recordadmcari')->with('result', $result); } }
/** * Show the application welcome screen to the user. * * * * @return Response */ public function index() { $languages_available = Config::get('app.locales_supported'); $user = Auth::user(); if ($user->admin) { $admin = 1; $records = Record::where('owner', '=', $user->id)->orderBy('updated_at', 'desc')->get(); return view('user/profile', compact('languages_available', 'admin', 'records')); } else { $admin = 0; $projects = UserController::buildProjectsArray($user); $forms = UserController::buildFormsArray($user); $records = Record::where('owner', '=', $user->id)->orderBy('updated_at', 'desc')->get(); return view('user/profile', compact('languages_available', 'admin', 'projects', 'forms', 'records')); } }
/** * Execute the console command. * * @param Schedule $schedule * @param Event $event * @param Record $record */ public function handle(Schedule $schedule, Event $event, Record $record) { $uptimeRobot = new UptimeRobot(env('UPTIMEROBOT_API')); $getMonitors = simplexml_load_string($uptimeRobot->getMonitors()); foreach ($getMonitors->monitor as $monitor) { // Check for the restart signal. $check = $event->where('event', 'restart'); if ($monitor['status'] == 9) { // Record the restart $event->create(['machine_name' => 'ubuntu-512mb-sgp1-01', 'event' => 'restart']); // Check for the record of recent restart $recentRestart = $record->where('event', 'restart'); // If there is a recent record but no signal found if ($recentRestart->count() > 0 && $check->count() < 6) { \Mail::send('Email.Down', [], function ($message) { $message->to('*****@*****.**', 'Hashim Ibrahim')->subject('About your server'); }); } else { // 4 hours have been passed. $hoursPassed = $check->where('created_at', '<', 'DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR)'); if ($hoursPassed->count() > 0) { if ($schedule->exec('envoy run monitorStatus')) { \Log::info('Envoy ran @ ' . \Carbon\Carbon::now()); \Mail::send('Email.Server', ['time' => \Carbon\Carbon::now()], function ($message) { $message->to('*****@*****.**', 'Hashim Ibrahim')->subject('About your server'); }); // Save this restart to db $record->create(['event' => 'restart']); } else { \Log::info('Envoy is not working @ ' . \Carbon\Carbon::now()); } } $check->delete(); } } else { $check->delete(); \Log::info('Monitor status is good @ ' . \Carbon\Carbon::now()); } } }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $count = 20; //访问一次,更新20条记录 $res = Record::select('id', 'phone')->whereNull('phone_province')->whereNotNull('phone')->limit($count)->get(); $res = $res->toArray(); $ko = 2; foreach ($res as $v) { $mobile = $v['phone']; if ($mobile) { if ($ko == 1) { $data = $this->taobao($mobile); } else { $data = $this->tenpay($mobile); } if ($data) { Record::where('id', $v['id'])->update(['phone_province' => $data['province'], 'phone_city' => $data['city'], 'phone_supplier' => $data['supplier']]); } } } exit; }
public function dispense($ic, $name) { $getID = Patient::where('pt_ic', $ic)->first(); //whole row $deID = $getID->id; //get the id from the ic $getcaseID = Record::where('pt_id', $deID)->first(); $caseID = $getcaseID->id; $disData = Dispensary::where('case_ref', $caseID)->first(); //xpe pakai first() sbb setiap case unik, case lain xpakai id ni $arrQty = explode("#", $disData->dispensed_quantity); $arrDrug = explode("#", $disData->dispensed_drug_code); //need declare $prices array x? $prices = array(); for ($x = 0; $x < count($arrDrug) - 1; $x++) { //get price of each drug into an array $hehe = Inventory::where('drug_name', $arrDrug[$x])->first(); $prices[$x] = $hehe->spu; } // $arrOne = count($arrDrug); // arr1 = druglist , arr2= respective qty of drug, arr3= respective price of drug $panel = Panel::all(); return view('staff.dispensary')->with('name', $name)->with('arr2', $arrQty)->with('arr1', $arrDrug)->with('arr3', $prices)->with('panel', $panel)->with('ptid', $deID); }
public function byInput(Request $request) { $params = $request['params']; $params = json_decode($params, 1); $major = array_key_exists('inputMajor', $params) ? $params['inputMajor'] : null; $degree = array_key_exists('inputDegree', $params) ? $params['inputDegree'] : null; $grade = array_key_exists('inputGrade', $params) ? $params['inputGrade'] : null; $gender = array_key_exists('inputGender', $params) ? $params['inputGender'] : null; $ageFrom = array_key_exists('inputAgeFrom', $params) ? $params['inputAgeFrom'] : null; $ageTo = array_key_exists('inputAgeTo', $params) ? $params['inputAgeTo'] : null; // DB::enableQueryLog(); $res = Record::where('id', '>', 0); if ($major) { $res = $res->where('major', 'like', "%{$major}%"); } if ($degree) { $res = $res->where('degree', 'like', "%{$degree}%"); } if ($grade) { $res = $res->where('grade', 'like', "%{$grade}%"); } if ($gender) { $res = $res->where('gender', '=', "{$gender}"); } if ($ageFrom or $ageTo) { $res = $res->ageBetween($ageFrom, $ageTo); } return $res->paginate($limit = 10); // $res = DB::table('records'); // if ($major) $res = $res->where('major', 'like', "%$major%"); // if ($degree) $res = $res->where('degree', 'like', "%$degree%"); // if ($grade) $res = $res->where('grade', 'like', "%$grade%"); // if ($gender) $res = $res->where('gender', '=', "$gender"); // return $res->paginate($limit=10); // var_dump(DB::getQueryLog());exit; }
public static function exists($rid) { return !is_null(Record::where('rid', '=', $rid)->first()); }
public function getRecords(Request $request) { $categoryId = $request->get('category_id'); $records = Record::where('category_id', $categoryId)->get(); return $records; }
$raw = \App\Raw::find($raw_id); $raw->records()->delete(); $raw->delete(); }); Route::put('api/table/{table}/update_fixed_record/{raw_id}', function (Request $request, App\Table $table, $raw_id) { // http://organit.app/api/table/1/fields $raw = \App\Raw::find($raw_id); // dd($request->all()); foreach ($request->all() as $label => $value) { if ($label == 'raw_id') { continue; } // echo "<h1>Table : ".$table->id." -- row".$raw->id."</h1>"; // echo $label.'<br><br>'; $field = Field::where('table_id', $table->id)->where('name', $label)->first(); $record = Record::where('raw_id', $raw->id)->where('field_id', $field->id); // echo 'field : '.$field->id. '-' .$field->name; // echo 'record : '.$record->id; // echo "<hr>"; // echo "<hr>"; $record->update(['value' => $value]); } $recordList = []; $recordList['raw_id'] = $raw->id; foreach ($raw->records as $record) { $recordList[$record->field->name] = $record->value; } return $recordList; }); /* Route::delete('api/table/{table}/fields/{field}', function(App\Table $table, Field $field){ // http://organit.app/api/table/1/fields
/** * Get all of the records for a given pet. * * @param Pet $pet * @return Collection */ public function forPet(Pet $pet) { return Record::where('pet_id', $pet->id)->orderBy('created_at', 'asc')->get(); }
/** * Rolls back a record. * * @param Request $request */ public function rollback(Request $request) { $revision = Revision::where('id', '=', $request['revision'])->first(); $form = FormController::getForm($revision->fid); if ($revision->type == 'create') { $record = Record::where('rid', '=', $revision->rid)->first(); $revision = RevisionController::storeRevision($record->rid, 'delete'); $record->delete(); flash()->overlay('Record ' . $form->pid . '-' . $form->fid . '-' . $revision->rid . ' has been deleted.', 'Success!'); } elseif ($revision->type == 'delete') { if (RecordController::exists($revision->rid)) { flash()->overlay('Cannot recreate a record that already exists.'); } else { $record = new Record(); $record->rid = $revision->rid; $record->fid = $revision->fid; $record->pid = $form->pid; $record->owner = $revision->owner; $record->save(); $record->kid = $record->pid . '-' . $record->fid . '-' . $record->rid; $record->save(); RevisionController::redo($record, $form, $revision, false); RevisionController::storeRevision($record->rid, 'create'); flash()->overlay('Record ' . $form->pid . '-' . $form->fid . '-' . $record->rid . ' has been rolled back.', 'Success!'); } } else { $record = RecordController::getRecord($revision->rid); RevisionController::redo($record, $form, $revision, true); flash()->overlay('Record ' . $form->pid . '-' . $form->fid . '-' . $record->rid . ' has been rolled back.', 'Success!'); } }