/**
* Check Existing Data
*
* @return void
* @author
**/
public static function checkData($table = NULL)
{
$existTable = DB::query("show tables like '" . Content::$table . "'");
if (empty($existTable)) {
return false;
}
$table = $table != NULL ? $table : Content::$table;
$count = DB::table($table)->count();
return $count > 0 ? true : false;
}
/**
* Get the user from the database table.
*
* @param array $arguments
* @return mixed
*/
protected function get_user($arguments)
{
$table = Config::get('auth.table');
return DB::table($table)->where(function ($query) use($arguments) {
$username = Config::get('auth.username');
$query->where($username, '=', $arguments['username']);
foreach (array_except($arguments, array('username', 'password', 'remember')) as $column => $val) {
$query->where($column, '=', $val);
}
})->first();
}
/**
* Seed the database from the given path.
*
* @param array $arguments
* @return int
*/
public function seed($arguments = array())
{
$total = 0;
foreach ($this->globSeedFiles() as $file) {
$records = $this->loadSeedFile($file);
// We'll grab the table name here, which could either come from the array or
// from the filename itself. Then, we will simply insert the records into
// the databases.
$table = $this->fetchTableName($records, $file);
Database::table($table)->delete();
Database::table($table)->insert($records);
$total += $count = count($records);
echo sprintf("Seeded: `%s` (%d rows)\n", $table, $count);
}
return $total;
}
/**
* Get the user from the database table by username.
*
* @param mixed $value
* @return mixed
*/
protected function get_user($value)
{
$table = Config::get('auth.table');
$username = Config::get('auth.username');
return DB::table($table)->where($username, '=', $value)->first();
}
/**
* Drop the pre-migration schema for the current migration.
*
* @return void
*/
protected function delete_schema()
{
DB::table('laravel_schema')->where('name', '=', get_class($this))->delete();
}
/**
* Gets the users' ids from which the current user has unread messages from
* @return int[] Array with the users' IDs
*/
public static function getUnreadUsers()
{
$myId = \Auth::user()->id;
// Get all unread messages directed to me
$messages = DB::table('messages')->where('status', '=', 'false')->where(function ($query) use($myId) {
$query->or_where('to', '=', $myId);
})->get();
$users = array();
foreach ($messages as $message) {
$users[] = $message->from;
// $users['nick'] = $message->nick;
}
return array_unique($users);
}
public function find($id)
{
$column = 'id';
if (!is_numeric($id)) {
if (is_null($this->slug)) {
$this->code = 404;
$this->data = 'You are trying to retrieve data with a slug from a resource that is not retrievable via a slug';
return false;
}
if ($this->multilanguage) {
$language_row = DB::table($this->language_table)->where_slug($id)->first(array($this->language_table_foreign_key, 'language_id'));
if (is_null($language_row)) {
$id = null;
} else {
$id = $language_row->{$this->language_table_foreign_key};
$this->options(array('filter' => array('language_id' => $language_row->language_id)));
}
} else {
$column = 'slug';
}
} elseif ($this->parent && $this->parent->multilanguage) {
if (!$this->input['language_id']) {
$this->code = 404;
$this->data = 'Please provide the language_id';
return false;
}
$this->language_id = $this->input['language_id'];
$this->model = $this->model->where($this->table . '.language_id', '=', $this->input['language_id']);
$column = $this->parent->language_table_foreign_key;
}
$this->id = $id;
$this->model = $this->model->where($this->table . '.' . $column, '=', $id);
if (is_null($this->model->first())) {
$this->code = 404;
$this->data = 'The data you are trying to retrieve could not be found';
return false;
}
return true;
}
