PHP Schema::getColumnListing方法代码示例

 public function translate(Request $request)
 {
     $data = $request->only('word', 'src_language', 'trans_language');
     $validator = Validator::make($data, array('word' => 'required', 'src_language' => 'required', 'trans_language' => 'required'));
     if ($validator->passes()) {
         $columns = Schema::getColumnListing('translation');
         // users table
         if (!in_array($data['src_language'], $columns)) {
             return response()->json(array('error' => 1, 'labels' => 'Source language is not available'));
         } else {
             if (!in_array($data['trans_language'], $columns)) {
                 return response()->json(array('error' => 1, 'labels' => 'Translation language is available'));
             } else {
                 $tra = Translation::where($data['src_language'], $data['word'])->first();
                 if (!$tra) {
                     return response()->json(array('error' => 1, 'labels' => 'This word is not available in our source language'));
                 } else {
                     $data = array('word' => $data['word'], 'source' => $data['src_language'], 'target' => $data['trans_language'], 'result' => $tra->{$data}['trans_language']);
                     return response()->json(array('error' => 0, 'data' => $data, 'errors' => array()));
                 }
             }
         }
     } else {
         return response()->json(array('error' => 1, 'labels' => $validator->messages()));
     }
 }

 public function search($input)
 {
     $query = BarcodeProcess::query();
     $query->select('barcode_processes.*');
     $query->leftJoin('shelves', 'barcode_processes.shelf_id', '=', 'shelves.id');
     $columns = Schema::getColumnListing('barcode_processes');
     $attributes = array();
     foreach ($columns as $attribute) {
         $attributes[$attribute] = null;
         if (isset($input[$attribute]) and !empty($input[$attribute])) {
             $query->where($attribute, $input[$attribute]);
             $attributes[$attribute] = $input[$attribute];
         }
     }
     /**
      * Filter
      */
     $this->filter($input, $query);
     /**
      * Get count
      */
     $total = $query->count();
     /**
      * Pagination
      */
     $this->pagination($input, $query);
     /**
      * Order
      */
     $this->order($input, $query);
     return [$query->get(), $attributes, 'total' => $total];
 }

 /**
  * get OnData spec.
  *
  * @param  array  $data
  * @return array
  */
 function getTables(array $data)
 {
     $onData = [];
     $foreignKeys = [];
     $result = [];
     $tmp = '';
     $i = 0;
     $j = 0;
     foreach ($data as $key => $value) {
         if ($key == 'tbl' . $i) {
             $tmp = $value;
             if (in_array($value, $foreignKeys)) {
                 throw new \Exception($value . " Relation Already selected");
             }
             array_push($foreignKeys, $value);
             $i++;
         } elseif ($key == 'on' . $j) {
             if (!in_array($value, Schema::getColumnListing($tmp))) {
                 throw new \Exception($value . " Does not exist in " . $tmp);
             }
             array_push($onData, $value);
             $j++;
         }
     }
     $result[] = $onData;
     $result[] = $foreignKeys;
     return $result;
 }

 public function search($input)
 {
     $query = User::query();
     $columns = Schema::getColumnListing('users');
     $attributes = array();
     foreach ($columns as $attribute) {
         $attributes[$attribute] = null;
         if (isset($input[$attribute]) and !empty($input[$attribute])) {
             $query->where($attribute, $input[$attribute]);
             $attributes[$attribute] = $input[$attribute];
         }
     }
     /*
      ** Filter
      */
     $this->filter($input, $query);
     /*
      ** Get count
      */
     $total = $query->count();
     /*
      ** Pagination
      */
     $this->pagination($input, $query);
     /*
      ** Order
      */
     $this->order($input, $query);
     return [$query->get(), $attributes, 'total' => $total];
 }

 /**
  * Exclude from find
  *
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeExcludeFromFind(Builder $query)
 {
     if (isset($this->excludedFromFind) == TRUE && is_array($this->excludedFromFind) == TRUE) {
         return $query->select(array_diff(Schema::getColumnListing($this->table), $this->excludedFromFind));
     } else {
         return $query;
     }
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $cols = Schema::getColumnListing('comments');
     unset($cols[0]);
     unset($cols[2]);
     unset($cols[3]);
     return response()->json(array_values($cols));
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $cols = Schema::getColumnListing('products');
     unset($cols[0]);
     unset($cols[8]);
     unset($cols[9]);
     return response()->json(array_values($cols));
 }

 public function getColumns($table = null, $class = null)
 {
     $class = $class ?: get_class($this);
     $table = $table ?: $this->table;
     if (!isset(self::$loaded_columns[$class])) {
         self::$loaded_columns[$class] = Schema::getColumnListing($table);
     }
     return self::$loaded_columns[$class];
 }

 /**
  * Get attributes from an existing table.
  *
  * @return array
  */
 public function getAttributes()
 {
     //get table attributes
     $this->result = Schema::getColumnListing($this->table);
     //delete the first element, (ignore the id section)
     unset($this->result[0]);
     //get result
     return $this->result;
 }

 /**
  * Search the images.
  *
  * @param string $input
  *
  * @return Collection
  */
 public function search($input)
 {
     $query = Image::orderBy('created_at', 'desc');
     $query->where('id', 'LIKE', '%' . $input['term'] . '%');
     $columns = Schema::getColumnListing('images');
     foreach ($columns as $attribute) {
         $query->orWhere($attribute, 'LIKE', '%' . $input['term'] . '%');
     }
     return [$query, $input['term'], $query->paginate(Config::get('quarx.pagination', 25))->render()];
 }

 public function search($term)
 {
     $query = $this->model->orderBy('created_at', 'desc');
     $query->where('id', 'LIKE', '%' . $input['term'] . '%');
     $columns = Schema::getColumnListing(str_plural($this->modelName));
     foreach ($columns as $attribute) {
         $query->orWhere($attribute, 'LIKE', '%' . $input['term'] . '%');
     }
     return ['term' => $input['term'], 'result' => $query->paginate(Config::get('quarx.pagination', 25))];
 }

 /**
  * Deduce relational arttributes.
  *
  * @return void
  */
 private function getAttributes()
 {
     collect($this->foreignKeys)->each(function ($key, $value) {
         $Schema = collect(Schema::getColumnListing($key));
         $Schema = $Schema->reject(function ($value, $key) {
             return str_contains($value, 'id');
         });
         $this->relationAttributes[$key] = $Schema->toArray();
     });
 }

 public function search($input)
 {
     $query = Widget::orderBy('created_at', 'desc');
     $query->where('id', 'LIKE', '%' . $input['term'] . '%');
     $columns = Schema::getColumnListing('widgets');
     foreach ($columns as $attribute) {
         $query->orWhere($attribute, 'LIKE', '%' . $input['term'] . '%');
     }
     return [$query, $input['term'], $query->paginate(25)->render()];
 }

 /**
  * @param string $className
  *
  * @return array
  */
 protected static function getClassProperties($className)
 {
     if (\class_exists($className, true)) {
         $reflection = new ReflectionClass($className);
         $value = $reflection->newInstanceWithoutConstructor();
         if (\is_subclass_of($value, Model::class, true)) {
             $attributes = Schema::getColumnListing($value->getTable());
             self::$eloquentClasses[$className] = $attributes;
         }
     }
     return !empty(self::$eloquentClasses[$className]) ? self::$eloquentClasses[$className] : parent::getClassProperties($className);
 }

 /**
  * Analyse data and attributes
  *
  * @param Array $data
  */
 private function getAttr($data)
 {
     foreach ($this->foreignKeys as $key => $value) {
         $Schema = Schema::getColumnListing($value);
         unset($Schema[0]);
         foreach ($Schema as $SchemaKey => $SchemaValue) {
             if (strpos($SchemaValue, '_id')) {
                 unset($Schema[$SchemaKey]);
             }
         }
         $this->relationAttr[$value] = $Schema;
     }
 }