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