function userHistoryAction()
{
$guid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$tblUser = new Pandamp_Modules_Identity_User_Model_User();
$req = $this->getRequest();
$sortDir = $req->getParam('dir') ? $req->getParam('dir') : 'ASC';
$sortBy = $req->getParam('sort') ? $req->getParam('sort') : 'username';
$start = $req->getParam('start') ? $req->getParam('start') : 0;
$end = $req->getParam('limit') ? $req->getParam('limit') : 10;
$fields = $req->getParam('fields') ? $req->getParam('fields') : '';
$query = $req->getParam('query') ? $req->getParam('query') : '';
$selectedRows = Zend_Json::decode($fields);
$rowval = Zend_Json::decode($query);
$rowset = $tblUser->fetchUserHistory($guid, "{$sortBy} {$sortDir}", $start, $end);
$a = array();
$a['totalCount'] = count($rowset);
$i = 0;
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
$a['history'][$i]['id'] = $row->idUser;
$a['history'][$i]['uid'] = $row->uidUser;
$a['history'][$i]['fullName'] = $row->fullName;
$a['history'][$i]['username'] = $row->username;
$a['history'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['history'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date_english($row->createdDate);
$a['history'][$i]['expirationDate'] = $row->expirationDate ? Pandamp_Lib_Formater::get_date_english($row->expirationDate) : '-';
$a['history'][$i]['paymentId'] = $row->paymentId;
$a['history'][$i]['DaysLeft'] = $row->DaysLeft;
$a['history'][$i]['value'] = $row->packageId;
$a['history'][$i]['packageId'] = $row->value;
$a['history'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['history'][$i]['isEmailSent'] = $row->isEmailSent;
$a['history'][$i]['isActive'] = $row->isActive;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['history'][0]['id'] = '';
$a['history'][0]['uid'] = '';
$a['history'][0]['fullName'] = '';
$a['history'][0]['username'] = '';
$a['history'][0]['company'] = '';
$a['history'][0]['createdDate'] = '';
$a['history'][0]['expirationDate'] = '';
$a['history'][0]['paymentId'] = '';
$a['history'][0]['DaysLeft'] = 'x';
$a['history'][0]['value'] = '';
$a['history'][0]['packageId'] = '';
$a['history'][0]['periodeId'] = '';
$a['history'][0]['isEmailSent'] = 'x';
$a['history'][0]['isActive'] = 'x';
}
echo Zend_Json::encode($a);
}
