/** * get an array of data to use in the response * @param Query $query the query to use to retrieve the data * @param Paginator $paginator * @param array $additionalData an associative array of data to merge with the data array */ protected function getData($query, $additionalData = array()) { //use this hook to alter the parameters $paginator = null; if (Input::get('page') || $this->paginate) { $beforePagination = Event::fire('before.pagination', array(&$query)); //check if $object is a model or a relation $model = $query->getModel(); $model = method_exists($model, 'getRelated') ? $model->getRelated() : $model; $perPage = Input::get('pp') ?: $model->getPerPage(); $paginator = $query->paginate($perPage); //preserve the url query in the paginator $paginator->appends(Input::except('page')); } $results = isset($paginator) ? $paginator->getCollection() : $query->get(); $data = array(); $data[$this->resultsKey] = $this->isAjaxRequest() ? $results->toArray() : $results; $data['total'] = isset($paginator) ? $paginator->getTotal() : $data->{$this->resultsKey}->count(); if ($paginator) { $data['paginator'] = $paginator; } if (is_array($additionalData)) { $data = array_merge($data, $additionalData); } return $data; }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('holidays')->delete(); $db = App::make('AccessDB'); $query = new Query('HOLIDAYS', $db->get_dbh()); $query->where('DURATION', '>', 0); $result = $query->get('HOLIDAYID,STARTTIME,DURATION'); $result_array = []; foreach ($result as $row) { $start_time = strtotime($row['STARTTIME']); $duration = $row['DURATION'] - 1; $end_time = strtotime("+{$duration} days", $start_time); $result_array[] = ['id' => $row['HOLIDAYID'], 'start' => $row['STARTTIME'], 'duration' => $row['DURATION'], 'end' => date('Y-m-d H:i:s', $end_time)]; } $holiday = array_chunk($result_array, 1000); foreach ($holiday as $value) { Holiday::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[2] = $result[count($result) - 1]['HOLIDAYID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
public function widget($args, $instance) { extract($args); $title = apply_filters('widget_title', empty($instance['title']) ? __('Recent Posts') : $instance['title'], $instance, $this->id_base); if (empty($instance['number']) || !($number = absint($instance['number']))) { $number = 10; } $r = new Query(apply_filters('widget_posts_args', array('posts_per_page' => $number, 'no_found_rows' => true, 'post_status' => 'publish', 'ignore_sticky_posts' => true))); return View::make('widgets.recentpost', ['posts' => $r->get(), 'title' => $title])->render(); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('departments')->delete(); $db = App::make('AccessDB'); $query = new Query('DEPARTMENTS', $db->get_dbh()); $result = $query->get('DEPTID,DEPTNAME,SUPDEPTID'); $result_array = []; foreach ($result as $row) { $result_array[] = ['id' => $row['DEPTID'], 'name' => $row['DEPTNAME'], 'super_department_id' => $row['SUPDEPTID']]; } $department = array_chunk($result_array, 1000); foreach ($department as $value) { Department::insert($value); } }
public function create_item($request) { $params = $request->get_params(); $problem_id = $params['problem_id']; $content = $params['content']; $tried = $params['tried']; $problem_data = null; if (isset($params['post_data_key'])) { $post_data_key = $params['post_data_key']; $problem_data = get_option($post_data_key); // Don't ever keep this data around. delete_option($post_data_key); } // Try fetching another question from the same problem. if (!$problem_data) { $query = new Query(array('problem_id' => $problem_id)); $questions = $query->get(); foreach ($questions as $q) { if ($q->get_problem_text()) { $problem_data = array('problem_id' => $q->get_problem_id(), 'problem_set' => $q->get_problem_set(), 'course' => $q->get_course(), 'section' => $q->get_section(), 'problem_text' => $q->get_problem_text()); break; } } } $question = new \WeBWorK\Server\Question(); $question->set_author_id(get_current_user_id()); $question->set_content($content); $question->set_tried($tried); $question->set_problem_id($problem_data['problem_id']); $question->set_problem_set($problem_data['problem_set']); $question->set_course($problem_data['course']); $question->set_section($problem_data['section']); $question->set_problem_text($problem_data['problem_text']); if ($question->save()) { $query = new Query(array('question_id' => $question->get_id())); $results = $query->get_for_endpoint(); // @todo not found? $retval = reset($results); $r = rest_ensure_response($retval); $r->set_status(201); } else { $r = rest_ensure_response(false); $r->set_status(500); } return $r; }
/** * Get responses. * * @since 1.0.0 * * @return array|int */ public function get() { $args = array('post_type' => 'webwork_response', 'update_post_term_cache' => false, 'meta_query' => array(), 'posts_per_page' => -1, 'orderby' => 'post_date', 'order' => 'ASC'); if (null !== $this->r['question_id__in']) { if (array() === $this->r['question_id__in']) { $question_id__in = array(0); } else { $question_id__in = array_map('intval', $this->r['question_id__in']); } $args['meta_query']['question_id__in'] = array('key' => 'webwork_question_id', 'value' => $question_id__in, 'compare' => 'IN'); } if (null !== $this->r['is_answer']) { if ($this->r['is_answer']) { $args['meta_query']['is_answer'] = array('key' => 'webwork_question_answer', 'value' => '1'); } else { // SOS $is_answer_args = $this->r; $is_answer_args['is_answer'] = true; $is_answer_args['orderby'] = 'post_date'; $is_answer_query = new Query($is_answer_args); $is_answers = $is_answer_query->get(); $not_in = array(); foreach ($is_answers as $is_answer) { $not_in[] = $is_answer->get_id(); } $args['post__not_in'] = $not_in; } } if ('votes' === $this->r['orderby']) { $args['meta_query']['votes_orderby'] = array('key' => 'webwork_vote_count', 'compare' => 'EXISTS', 'type' => 'SIGNED'); $args['orderby'] = array('votes_orderby' => 'DESC', 'post_date' => 'ASC'); } $response_query = new \WP_Query($args); $_responses = $response_query->posts; $responses = array(); foreach ($_responses as $_response) { $responses[$_response->ID] = new \WeBWorK\Server\Response($_response->ID); } return $responses; }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('employees')->delete(); $db = App::make('AccessDB'); $query = new Query('USERINFO', $db->get_dbh()); $query->order('USERID'); $result = $query->get('USERID,SSN,Name,Gender,BIRTHDAY,street,DEFAULTDEPTID'); $result_array = []; foreach ($result as $row) { $result_array[] = ['id' => $row['USERID'], 'ssn' => $row['SSN'], 'name' => $row['Name'], 'is_male' => $row['Gender'] == 'Male' ? 1 : 0, 'birthday' => $row['BIRTHDAY'], 'street' => $row['street'], 'department_id' => $row['DEFAULTDEPTID']]; } $employee = array_chunk($result_array, 1000); foreach ($employee as $value) { Employee::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[7] = $result[count($result) - 1]['USERID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('schedules')->delete(); $db = App::make('AccessDB'); $query = new Query('USER_OF_RUN', $db->get_dbh()); $query->order('STARTDATE'); $result = $query->get('STARTDATE,ENDDATE,USERID,NUM_OF_RUN_ID'); $result_array = []; foreach ($result as $row) { $result_array[] = ['start_date' => $row['STARTDATE'], 'end_date' => $row['ENDDATE'], 'employee_id' => $row['USERID'], 'weekly_schedule_id' => $row['NUM_OF_RUN_ID']]; } $schedule = array_chunk($result_array, 1000); foreach ($schedule as $value) { Schedule::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[5] = $result[count($result) - 1]['STARTDATE']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('daily_schedules')->delete(); $db = App::make('AccessDB'); $query = new Query('SCHCLASS', $db->get_dbh()); $query->order('SCHCLASSID'); $result = $query->get('SCHCLASSID,SCHNAME,STARTTIME,ENDTIME'); $result_array = []; foreach ($result as $row) { $result_array[] = ['id' => $row['SCHCLASSID'], 'name' => $row['SCHNAME'], 'start_time' => $row['STARTTIME'], 'end_time' => $row['ENDTIME']]; } $daily_schedule = array_chunk($result_array, 1000); foreach ($daily_schedule as $value) { DailySchedule::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[4] = $result[count($result) - 1]['SCHCLASSID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('manual_checks')->delete(); $db = App::make('AccessDB'); $query = new Query('CHECKEXACT', $db->get_dbh()); $query->where('EXACTID', '>=', 1455); $query->order('EXACTID'); $result = $query->get('EXACTID,USERID,CHECKTIME,CHECKTYPE'); $result_array = []; foreach ($result as $row) { $result_array[] = ['date_time' => $row['CHECKTIME'], 'is_in' => $row['CHECKTYPE'] == 'I' ? 1 : 0, 'employee_id' => $row['USERID']]; } $manual_check = array_chunk($result_array, 1000); foreach ($manual_check as $value) { ManualCheck::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[0] = $result[count($result) - 1]['EXACTID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('absences')->delete(); $db = App::make('AccessDB'); $query = new Query('USER_SPEDAY', $db->get_dbh()); $query->where('STARTSPECDAY', '>=', '2014-07-01'); $query->order('DATE,STARTSPECDAY'); $result = $query->get(); $result_array = []; foreach ($result as $row) { $result_array[] = ['start_date' => $row['STARTSPECDAY'], 'end_date' => $row['ENDSPECDAY'], 'reason' => isset($row['YUANYING']) ? $row['YUANYING'] : '', 'employee_id' => $row['USERID'], 'absence_category_id' => $row['DATEID']]; } $absence = array_chunk($result_array, 1000); foreach ($absence as $value) { Absence::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[6] = $result[count($result) - 1]['DATE']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('weekly_schedules')->delete(); $db = App::make('AccessDB'); $query = new Query('NUM_RUN_DEIL', $db->get_dbh()); $query->order('NUM_RUNID'); $result = $query->get('NUM_RUNID,STARTTIME,ENDTIME,SDAYS,EDAYS,SCHCLASSID'); $result_array = []; foreach ($result as $row) { $allowance_id = 0; if ($row['SDAYS'] != 6) { $end = date_parse($row['ENDTIME']); $start = date_parse($row['STARTTIME']); $duration = (mktime($end['hour'], $end['minute']) - mktime($start['hour'], $start['minute'])) / 3600; if ($duration >= 8) { $allowance_id = 1; } else { if ($duration < 7) { $allowance_id = 3; } else { $allowance_id = 2; } } } $result_array[] = ['id' => $row['NUM_RUNID'], 'start_day' => $row['SDAYS'], 'end_day' => $row['EDAYS'], 'daily_schedule_id' => $row['SCHCLASSID'], 'allowance_id' => $allowance_id]; } $weekly_schedule = array_chunk($result_array, 1000); foreach ($weekly_schedule as $value) { WeeklySchedule::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[3] = $result[count($result) - 1]['NUM_RUNID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
/** * 指定のページを表すクエリ * @param integer $current 現在のページ番号 * @return string */ public function query($current) { $vars = array_merge($this->vars, [$this->query_name() => $current]); if (isset($this->order)) { $vars['order'] = $this->order; } return Query::get($vars); }
/** * Fetch all of the objects. * * @param Query $query * @return Collection */ private function fetchObjectsFromQuery($query) { // Fech all the object IDs that match the query. $ids = $query->get()->lists('object_id')->all(); $objects = $this->objects()->load('values', 'values.attribute')->filter(function ($object) use($ids) { return in_array($object->id, $ids); }); return $objects; }
/** * Return a list of all published posts. * * @return array */ public static function all() { $query = new Query(['post_type' => 'galleries', 'posts_per_page' => -1, 'post_status' => 'publish']); return $query->get(); }
public static function mostViewed($type = 'post', $nb = 5) { $query = new Query(array('post_type' => $type, 'meta_key' => 'post_views_count', 'orderby' => 'meta_value_num', 'posts_per_page' => $nb)); return $query->get(); }
function get($objectname = false) { $query = new Query(); return $query->get($objectname); }
public function userinfo($start) { $query = new Query('USERINFO', $this->dbh); $query->where('USERID', '>', $start); $query->order('USERID'); $result = $query->get('USERID,SSN,Name,Gender,BIRTHDAY,street,DEFAULTDEPTID'); foreach ($result as $row) { Employee::create(['id' => $row['USERID'], 'ssn' => $row['SSN'], 'name' => $row['Name'], 'is_male' => $row['Gender'] == 'Male' ? 1 : 0, 'birthday' => $row['BIRTHDAY'], 'street' => $row['street'], 'department_id' => $row['DEFAULTDEPTID']]); } $size = count($result); $this->num_data += $size; return $size > 0 ? $result[$size - 1]['USERID'] : $start; }
/** * Make sure the soft-filter is added to get() calls */ public function get() { $this->add_soft_filter(); return parent::get(); }
/** * Shortcut to implementing an EXISTS test for one or more values as a new expression * @param Query $values * @param string $paramname * @param boolean $positive * @return QueryWhere Returns $this, for fluid interface */ public function exists(Query $values, $paramname = null, $positive = true) { $expression = ''; if (!$positive) { $expression .= 'NOT '; } $expression .= 'EXISTS (' . $values->get() . ')'; $this->parameters = array_merge($this->parameters, $values->params()); if (empty($paramname)) { $paramname = count($this->expressions) + 1; } $this->expressions[$paramname] = $expression; return $this; }
<?php $tags = wp_get_post_tags($id); $t = []; foreach ($tags as $tag) { $t[] = $tag->term_id; } $args = ['tag__in' => $t, 'post__not_in' => array($id), 'posts_per_page' => 2, 'post_status' => 'publish']; $query = new Query($args); $posts = $query->get(); ?> @unless(empty($posts)) <section class="single-post-related-posts section"> <h3><?php _e('RELATED POSTS', THEME_TEXT_DOMAIN); ?> </h3> <div class="divider"></div> <div class="row mt-20"> @foreach($posts as $post) <a href="{{ $post->link() }}" title="{{ $post->title()}}"> <div class="col s12 m6 l6"> <div class="card"> <div class="card-image related-post-large"> <article> <img width="640" height="427" src="{{ $post->thumbnailUrl('related')}}" class="attachment-large wp-post-image img responsive-img transparent-overlay" alt="{{ $post->title() }}"> <h2 class="card-title center-align related-post-card-title"> {{ $post->title() }} </h2> </article>
/** * Return a list of all published posts. * * @return array */ public static function all($nb = 6) { $query = new Query(['post_type' => 'post', 'posts_per_page' => $nb, 'post_status' => 'publish']); return $query->get(); }
if (!empty($record->id_parent)) { $QP = new Query('bookz_record'); $QP->where('id', '=', $record->id_parent); if (!user_authed()) { $QP->where('is_published', '=', 1); } $record->parent = $QP->fetch(); } $QCh = new Query('bookz_record'); $QCh->where('id_parent', '=', $record->id); if (!user_authed()) { $QCh->where('is_published', '=', 1); } $QCh->sort('ordkey', 'ASC'); $QCh->sort('title', 'ASC'); $record->child = $QCh->get(); $posts_page->title = $record->title; Registry::set('page', $posts_page); Registry::set('record', $record); return new Template('bookz_record'); }); /** * View pages */ Route::get('(:all)', function ($uri) { if (!($page = Page::slug($slug = basename($uri)))) { return Response::create(new Template('404'), 404); } if ($page->redirect) { return Response::redirect($page->redirect); }
public function getAdmin($conexion, $email, $password) { $query = new Query(); return $query->get($this->table, $email, $password, $conexion); }