function searchCb($word, $accid, $begin = 0, $limit = 20)
{
global $db;
$acc = new Account();
$reply = new InboxReply();
$q = "\n \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}\n \n ";
$arr = $db->query($q, 2);
// pr($arr);
// echo $q;
$newMurid = array();
foreach ($arr as $databasemurid) {
$m = new Inbox();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
//return jumlah totalnya
$q = " \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n ";
$arr2 = $db->query($q, 2);
return array("arrMsg" => $newMurid, "total" => count($arr2));
//die();
}
