当前位置: 首页>>代码示例>>PHP>>正文


PHP Query::order方法代码示例

本文整理汇总了PHP中Query::order方法的典型用法代码示例。如果您正苦于以下问题:PHP Query::order方法的具体用法?PHP Query::order怎么用?PHP Query::order使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Query的用法示例。


在下文中一共展示了Query::order方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getQuery

 public function getQuery()
 {
     $query = new Query(Yii::app()->db);
     $query->from('groupon_biz');
     $query->andWhere('display=' . ARBiz::DISPLAY);
     if ($this->id) {
         $query->andWhere('id=:id', array(':id' => trim($this->id)));
     }
     if ($this->title) {
         $query->andWhere(array('like', 'title', '%' . $this->title . '%'));
     }
     if ($this->status) {
         $query->andWhere('examine_status=:status', array(':status' => $this->status));
     }
     $query->order('id desc');
     return $query;
 }
开发者ID:yinhe,项目名称:yincart,代码行数:17,代码来源:SellBizSFM.php

示例2: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:27,代码来源:ScheduleSeeder.php

示例3: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:27,代码来源:EmployeeSeeder.php

示例4: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:27,代码来源:DailyScheduleSeeder.php

示例5: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:28,代码来源:ManualCheckSeeder.php

示例6: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:28,代码来源:AbsenceSeeder.php

示例7: run

 /**
  * 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);
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:42,代码来源:WeeklyScheduleSeeder.php

示例8: _ssp_sort

 /**
  * Sorting requirements to a server-side processing query.
  *  @param Query $query Query instance to apply sorting to
  *  @param array $http HTTP variables (i.e. GET or POST)
  *  @private
  */
 private function _ssp_sort($query, $http)
 {
     for ($i = 0; $i < count($http['order']); $i++) {
         $order = $http['order'][$i];
         $query->order($this->_ssp_field($http, $order['column']) . ' ' . ($order['dir'] === 'asc' ? 'asc' : 'desc'));
     }
 }
开发者ID:paletter,项目名称:tms-website,代码行数:13,代码来源:Editor.php

示例9: userinfo

 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;
 }
开发者ID:radityapradipta,项目名称:Absensi-Binbak,代码行数:13,代码来源:AccessConverter.php


注:本文中的Query::order方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。