public function myinbox() { $id = Account::getMyID(); $inbox = new Inbox(); $begin = isset($_GET['begin']) ? addslashes($_GET['begin']) : 0; $limit = 10; $w = isset($_GET['word']) ? addslashes($_GET['word']) : ''; //search if commbook if (isset($_GET['cb'])) { if ($w != '') { $retArr = $inbox->searchCb($w, $id, $begin, $limit); $arrMsg = $retArr['arrMsg']; $return['total'] = $retArr['total']; } else { $whereClause = "(inbox_from = '{$id}' OR inbox_to = '{$id}') AND inbox_type = 'cb' ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}"; $arrMsg = $inbox->getWhere($whereClause); $clause = " (inbox_from = '{$id}' OR inbox_to = '{$id}') AND inbox_type = 'cb' "; $return['total'] = $inbox->getJumlah($clause); } } elseif (isset($_GET['search'])) { //get search word //sementara di off in //yg bs dicari nama_depan pengirim dan judul dan msg nya saja, $retArr = $inbox->search($w, $id, $begin, $limit); $arrMsg = $retArr['arrMsg']; $return['total'] = $retArr['total']; } else { $whereClause = "inbox_from = '{$id}' OR inbox_to = '{$id}' ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}"; $arrMsg = $inbox->getWhere($whereClause); $clause = "inbox_from = '{$id}' OR inbox_to = '{$id}'"; $return['total'] = $inbox->getJumlah($clause); } //ambil last reply foreach ($arrMsg as $obja) { //ambil last conversations $reply = new InboxReply(); $reply->getLastReply($obja->inbox_id); if (isset($reply->inbox_msg) && $reply->inbox_msg != '') { $obja->inbox_msg = $reply->inbox_msg; } } $return['limit'] = $limit; $return['begin'] = $begin; $return['arrMsg'] = $arrMsg; $return['webClass'] = __CLASS__; $return['method'] = __FUNCTION__; $return['word'] = $w; $return['cb'] = isset($_GET['cb']) ? $_GET['cb'] : 0; Mold::both("inbox/myinbox", $return); //pr($arrMsg); }
function fillEnvelope($jumlah = 5) { $id = Account::getMyID(); $begin = 0; $limit = $jumlah; $whereClause = "inbox_from = '{$id}' OR inbox_to = '{$id}' ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}"; $arrMsg = $this->getWhere($whereClause); $myAcc = new Account(); $myAcc->getByID($id); foreach ($arrMsg as $obja) { $data = new Account(); if ($id != $obja->inbox_to) { //to $data->getByID($obja->inbox_to); } if ($id != $obja->inbox_from) { // $data->getByID($obja->inbox_from); } $obja->data = $data; //ambil last conversations $reply = new InboxReply(); $reply->getLastReply($obja->inbox_id); if (isset($reply->inbox_msg) && $reply->inbox_msg != '') { $obja->inbox_msg = $reply->inbox_msg; } } return array("arrMsg" => $arrMsg, "myAcc" => $myAcc, "id" => $id); }