public static function AplicativoFaltantedelTicket($idPersona) { $resultado = \DB::table('aplicativo')->select(['aplicativo.id', 'aplicativo.nombre_aplicativo'])->whereNotIn('aplicativo.id', function ($query) use($idPersona) { $query->select(['aplicativo_ticket_persona.aplicativo_id'])->from('persona_tickets')->where('persona_tickets.persona_id', $idPersona)->join('aplicativo_ticket_persona', 'persona_tickets.id', '=', 'aplicativo_ticket_persona.ticket_persona_id')->get(); })->get(); return $resultado; }
public static function buscarAplicativoRelacionados2($idTicket_persona) { $result = \DB::table('aplicativo_ticket_persona')->select(['aplicativo.nombre_aplicativo', 'aplicativo.id', 'aplicativo_ticket_persona.created_at', 'aplicativo_ticket_persona.usucrea'])->whereIn('aplicativo_ticket_persona.ticket_persona_id', function ($query) use($idTicket_persona) { $query->select(['persona_tickets.id'])->from('persona_tickets')->where('persona_tickets.id', $idTicket_persona)->get(); })->join('aplicativo', 'aplicativo_ticket_persona.aplicativo_id', '=', 'aplicativo.id')->get(); return $result; }
public static function notify($idArr = array(), $body, $type, $to_all = 0, $is_system = 0) { $currentId = auth()->id(); if (!$currentId) { return; } $data = $notifiedUidArr = []; $now = \Carbon\Carbon::now(); if ($to_all) { $data = ['user_id' => 0, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now]; } elseif (!empty($idArr)) { $idArr = array_unique($idArr); foreach ($idArr as $id) { if ($id == $currentId) { return; } $data[] = ['user_id' => $id, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now]; $notifiedUidArr[] = $id; } } if (!empty($data)) { Notify::insert($data); if ($to_all) { \DB::table('users')->increment('notice_count'); } elseif ($notifiedUidArr) { User::whereIn('id', $notifiedUidArr)->increment('notice_count'); } } }
/** * [getMatches description] * @param [type] $tournament_id [description] * @param [type] $player_id [description] * @return [type] [description] */ public function getMatches($tournament_id, $player_id) { $m = \DB::table('matches')->join('tournaments', 'tournaments.tournament_id', '=', 'matches.tournament_id')->join('players as winner', 'winner.player_id', '=', 'matches.player1_id')->join('players as loser', 'loser.player_id', '=', 'matches.player2_id')->where('matches.tournament_id', '=', $tournament_id)->where(function ($q) use($player_id) { $q->where('player1_id', '=', $player_id)->orWhere('player2_id', '=', $player_id); })->orderBy('match_division')->orderBy('round')->select('*', 'winner.first_name as winner_first_name', 'winner.last_name as winner_last_name', 'loser.first_name as loser_first_name', 'loser.last_name as loser_last_name', 'loser.player_id as loser_id', 'tournaments.name as tournament')->distinct()->get(); return $m; }
public function closest($lat, $lng, $max_distance = 25, $max_locations = 10, $units = 'miles', $fields = false) { /* * Allow for changing of units of measurement */ switch ($units) { case 'miles': //radius of the great circle in miles $gr_circle_radius = 3959; break; case 'kilometers': //radius of the great circle in kilometers $gr_circle_radius = 6371; break; } /* * Support the selection of certain fields */ if (!$fields) { $fields = array('*'); } /* * Generate the select field for disctance */ $disctance_select = sprintf("( %d * acos( cos( radians(%s) ) " . " * cos( radians( lat ) ) " . " * cos( radians( lng ) - radians(%s) ) " . " + sin( radians(%s) ) * sin( radians( lat ) ) " . ") " . ") " . "AS distance", $gr_circle_radius, $lat, $lng, $lat); return DB::table($table)->having('distance', '<', $max_distance)->take($max_locations)->order_by('distance', 'ASC')->get(array($fields, $disctance_select)); }
public static function cuentasAplicativosExportar($ticket_id) { $resultado = \DB::table('cuenta')->select(['cuenta.id', 'cuenta.cuenta_usu', 'ticket.nroticket', 'aplicativo.nombre_aplicativo', 'cuenta.created_at', 'cuenta.clave'])->whereIn('cuenta.aplicativo_ticket_id', function ($query) use($ticket_id) { $query->select(['aplicativo_tickets.id'])->from('ticket')->where('ticket.id', $ticket_id)->join('aplicativo_tickets', 'ticket.id', '=', 'aplicativo_tickets.ticket_id')->join('aplicativo', 'aplicativo_tickets.aplicativo_id', '=', 'aplicativo.id')->get(); })->join('aplicativo_tickets', 'cuenta.aplicativo_ticket_id', '=', 'aplicativo_tickets.id')->join('aplicativo', 'aplicativo_tickets.aplicativo_id', '=', 'aplicativo.id')->join('ticket', 'aplicativo_tickets.ticket_id', '=', 'ticket.id')->get(); return $resultado; }
public static function AplicativoAreaFaltante($idarea) { $resultado = \DB::table('aplicativo')->select(['aplicativo.id', 'aplicativo.nombre_aplicativo'])->whereNotIn('aplicativo.id', function ($query) use($idarea) { $query->select(['aplicativo_area.aplicativo_id'])->from('aplicativo_area')->where('area.id', $idarea)->join('area', 'aplicativo_area.area_id', '=', 'area.id')->get(); })->get(); return $resultado; }
public function select() { $user = DB::table('login')->where('name', 'crdf')->first(); var_dump($user); die; return $user->name; }
public function user() { //return $this->hasManyThrough('App\User','App\AccountLink', // 'user_id', 'id', 'app_user_id'); $user = \DB::table('users')->join('account_links', 'users.id', '=', 'account_links.user_id')->where('account_links.app_user_id', '=', $this->id)->first(); return $user; }
public static function callStatesIndicator($ind) { //$p = \DB::statement('call PKG_CMI_INDICATOR_STATES.PROC_MAKE_FEED(?,?,?)',[$stateid, $val, $user]); //$p = \DB::exec('pkg_cmi_indicator_states.func_get_valid_fees(?, ?, ?)',[$ind, $per, $user]); //$p= \DB::table('select * from CMI_INDICATOR_STATE t where t.indicatorid = '.$ind.';'); $datasStates = \DB::table('CMI_INDICATOR_STATE')->select('*')->where('indicatorid', '=', $ind)->get(); return $datasStates; }
function getName() { DB::table('users')->whereExists(function ($query) { $query->select(DB::raw(1))->from('orders')->whereRaw('orders.user_id = users.id'); })->get(); //select * from users where exists (select 1 from orders where orders.user_id = users.id) //生成上面那句语句 exists 判断括号内语句是否为真 为真则搜索 为假则放弃 }
public function minId() { $vacancy = DB::table($this->table)->select('min(id)')->first(); if ($vacancy) { return $vacancy->min; } else { return null; } }
public function getPassedUserIds() { $arIds = \DB::table('vk_like')->select('to_id')->where(['from_id' => $this->id])->get(); $arIds = array_map(function ($item) { return $item->to_id; }, $arIds); $arIds[] = $this->id; return $arIds; }
public function generateOrder() { $max = \DB::table($this->table)->where('parent_id', $this->parent_id)->max('order'); if (!$max) { $this->order = '1'; } else { $this->order = (string) ++$max; } }
public function hasPermission($permission_id) { $result = 0; $result = \DB::table('permissions')->where('user_id', '=', $this->id)->where('permission_id', '=', $permission_id)->count(); if ($result > 0) { return true; } else { return false; } }
public function completed() { # total items count of this dataset $total = $this->StandardItems()->count() * 3; $completed = \DB::table('standard_items')->where('dataset_id', $this->id)->sum('batch_count'); if ($total == 0) { return 100; } return $completed * 100 / $total; }
public static function getCountry($ipAddress, $response = 'country_name') { if ($ipAddress == '127.0.0.1') { //localhost return 'Ukraine'; } $user_ip = ip2long($ipAddress); $query = \DB::table('laravel_ip2country')->where('start_ip_long', '<=', $user_ip)->where('end_ip_long', '>=', $user_ip); $results = $query->first(); return count($results) ? $results->{$response} : ''; }
public static function set($key, $value) { $setting = \DB::table('settings')->where('key', $key); if (!$setting->count()) { \DB::table('settings')->insert(['key' => $key, 'value' => $value, 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]); } else { $setting->where('key', $key)->update(['value' => $value, 'updated_at' => \Carbon\Carbon::now()]); } Cache::forget('settings.' . $key); self::writeSelfCache($key, $value); }
/** * The function removes all appointments against a cell * * @var array */ public function reset($cell) { $status = 1; $cell = trim($cell); try { \DB::table($this->table)->where('cell', '=', $cell)->delete(); } catch (\Exception $e) { #var_dump($e->errorInfo ); } return $status; }
/** * Получаем объект со всеми виджетами * всех позиций * * @return mixed */ public function getAllWidgets() { $data = \DB::table('widgets')->get(); // процесс компоновки объект for ($i = 0; $i < count($data); $i++) { $obj[$data[$i]->name_location]['active'] = $data[$i]->active; for ($j = 0; $j < count((array) json_decode($data[$i]->object_data)); $j++) { $obj[$data[$i]->name_location]['types'] = json_decode($data[$i]->object_data); } } return $obj; }
public function getRolesIdsArr() { $roles_rows = \DB::table(\Config::get('entrust.role_user_table'))->where('user_id', '=', $this->id)->get(['role_id']); if (empty($roles_rows)) { return []; } $roles_ids_arr = []; foreach ($roles_rows as $role_row) { $roles_ids_arr[] = $role_row->role_id; } return $roles_ids_arr; }
public function getPermissionsIdsArr() { $permissions_rows = \DB::table(\Config::get('entrust.permission_role_table'))->where('role_id', '=', $this->id)->get(['permission_id']); if (empty($permissions_rows)) { return []; } $permissions_ids_arr = []; foreach ($permissions_rows as $permission_row) { $permissions_ids_arr[] = $permission_row->permission_id; } return $permissions_ids_arr; }
public static function createSelectbox($team_id) { $excludePersons = \DB::table('persons_teams')->where('persons_teams.team_id', '=', $team_id)->lists('person_id'); $persons = array(); foreach (\DB::table('persons')->orderBy('lastname', 'asc')->get() as $person) { if (!in_array($person->id, $excludePersons)) { $persons[$person->id] = $person->lastname . ', ' . $person->firstname; } } //if (empty($teams)) return ''; return Form::select('person', $persons, '', array('class' => 'form-control')); }
public static function createSelectbox($person_id) { $excludeTeams = \DB::table('persons_teams')->where('persons_teams.person_id', '=', $person_id)->lists('team_id'); $teams = array(); foreach (\DB::table('teams')->orderBy('name', 'asc')->get() as $team) { if (!in_array($team->id, $excludeTeams)) { $teams[$team->id] = $team->name; } } //if (empty($teams)) return ''; return Form::select('team', $teams, '', array('class' => 'form-control')); }
/** * * Retrieve tweets of people being followed if they have an tweet id greater than the last * id retrieved */ public function getFeed() { $since_id = \DB::table('social_media')->where('source', '=', 'twitter')->orderBy('social_id', 'DESC')->take(1)->pluck('social_id'); $paramArr = ['count' => 200, 'include_entities' => 1]; if ($since_id) { $paramArr['since_id'] = $since_id; } $r = \Twitter::getHomeTimeline($paramArr); if (count($r) == 0) { return false; } $socialMediaArr = $this->parseFeed($r); return $socialMediaArr; }
public function head2head($player1, $player2) { //Match detail $matches = \DB::table('matches')->join('tournaments', 'tournaments.tournament_id', '=', 'matches.tournament_id')->join('players as winner', 'winner.player_id', '=', 'matches.player1_id')->join('players as loser', 'loser.player_id', '=', 'matches.player2_id')->where(function ($q) use($player1) { $q->where('player1_id', '=', $player1)->orWhere('player2_id', '=', $player1); })->where(function ($q) use($player2) { $q->where('player1_id', '=', $player2)->orWhere('player2_id', '=', $player2); })->orderBy('match_division')->orderBy('round')->select('*', 'winner.first_name as winner_first_name', 'winner.last_name as winner_last_name', 'loser.first_name as loser_first_name', 'loser.last_name as loser_last_name', 'loser.player_id as loser_id', 'tournaments.name as tournament')->distinct()->get(); //Count wins by player $player1_wins = Match::where('winner_id', '=', $player1)->where('player2_id', '=', $player2)->get()->count(); $player2_wins = Match::where('winner_id', '=', $player2)->where('player2_id', '=', $player1)->get()->count(); $versus = ['player1' => ['wins' => $player1_wins], 'player2' => ['wins' => $player2_wins], 'matches' => $matches]; return $versus; }
public function scopeAttachAlumno($query, $alumno_id) { $id = 0; if (is_object($alumno_id)) { if ($alumno_id->id) { $id = $alumno_id->id; } } elseif (is_integer($alumno_id)) { $id = $alumno_id; } if ($tarea_id = $this->attributes['id']) { if (is_integer($id)) { \DB::table('tarea_alumno')->insert(['tarea_id' => $tarea_id, 'alumno_id' => $id]); } else { return false; } } else { return false; } return true; }
public function run() { \DB::table('song_datas')->delete(); Song_data::create(['song' => 'Example', 'album' => 'Example', 'artist' => 'Example', 'difficulty' => 'Novice', 'view' => 'Specify the tuning, example: Tuning: Standard(ADGCEA) Instructions: copy and paste the segment below as much as you need to write a fingerpicking part. Example: e|--------------------------------------------------------------------------| B|-----------5-------------7-------------5----8----7----5/7--7---------| G|--------5-------------7-------------5-------9----7----5/7--7---------| D|-----5-------------7-------------5--------------------------------------| A|----------------5--------------------------------------------------------| E|--5---------------------------5------------------------------------------| "Insert some lyrics here." If you want to write some part with chords, just put it over the lyrics, like this: -G- -B- -Em- -F- -F#- bla bla.... blablablaa... bla...........yeah Put the chords between "-" and "-" without cuotes for a correct display. So you are ready now! Try it!']); }
public function users() { return \DB::table('chat')->distinct()->join('users', 'chat.sender_id', '=', 'users.id'); // ->join('chat', 'receiver_id', '=', $this->id) }
public static function getCanton($id) { return \DB::table('canton')->where('province_id', $id)->select('canton.id', 'canton.name')->get(); }