public function test_database_exists()
{
$thread = \DB::table('parley_threads')->insert(array('subject' => 'test thread', 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")));
$threads = Thread::all();
$this->assertEquals($threads->count(), 1);
$this->assertEquals($threads->first()->id, 1);
}
/**
* Get a thread by its hash value
* @param string|int $id
*
* @return mixed
*/
public function getThread($id)
{
return Thread::find($id);
}
/**
* Get Threads belonging to a specific Member object
*
* @param $member
*
* @return mixed
*/
public function getThreadsForMember($member)
{
// Confirm the specified member is a valid Parleyable Object
if (!$this->confirmObjectIsParleyable($member)) {
return new Collection();
}
$query = Thread::join('parley_members', 'parley_threads.id', '=', 'parley_members.parley_thread_id')->where('parley_members.parleyable_id', $member->id)->where('parley_members.parleyable_type', get_class($member))->select('parley_threads.*', 'parley_members.is_read as is_read', 'parley_members.parleyable_id as member_id', 'parley_members.parleyable_type as member_type');
switch ($this->trashed) {
case 'yes':
$query = $query->withTrashed();
break;
case 'only':
$query = $query->onlyTrashed();
break;
default:
break;
}
if ($this->type == 'open') {
$query = $query->whereNull('parley_threads.closed_at');
}
if ($this->type == 'closed') {
$query = $query->whereNotNull('parley_threads.closed_at');
}
if ($this->status == 'read') {
$query = $query->where('parley_members.is_read', 1);
}
if ($this->status == 'unread') {
$query = $query->where('parley_members.is_read', 0);
}
return $query->orderBy('updated_at', 'desc')->get();
}