function userAction()
{
$tblUser = new Pandamp_Modules_Identity_User_Model_User();
$req = $this->getRequest();
$sortDir = $req->getParam('dir') ? $req->getParam('dir') : 'DESC';
$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') : '';
$startdt = $req->getParam('startdt') ? $req->getParam('startdt') : '';
$enddt = $req->getParam('enddt') ? $req->getParam('enddt') : '';
$group = $req->getParam('group') ? $req->getParam('group') : '';
$selectedRows = Zend_Json::decode($fields);
$rowval = $query;
$a = array();
$i = 0;
switch ($group) {
case 'member_gratis':
$rowset = $tblUser->fetchUserGroupFree("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_gratis', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_gratis', $startdt, $enddt);
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
//$a['user'][$i]['guid'] = $row->guid;
$a['user'][$i]['kopel'] = $row->kopel;
$a['user'][$i]['fullName'] = $row->fullName;
$a['user'][$i]['username'] = $row->username;
$a['user'][$i]['email'] = !empty($row->email) ? $row->email : '-';
$a['user'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['user'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date($row->createdDate);
$a['user'][$i]['value'] = $row->packageId;
$a['user'][$i]['packageId'] = $row->value;
$a['user'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['user'][$i]['isEmailSent'] = $row->isEmailSent;
$a['user'][$i]['isEmailSentOver'] = $row->isEmailSentOver;
$a['user'][$i]['isActive'] = $row->isActive;
$a['user'][$i]['isContact'] = $row->isContact;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['user'][0]['guid'] = 'No Data';
}
break;
case 'member_corporate':
if ($startdt && $enddt) {
$rowset = $tblUser->fetchUser("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_corporate', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_corporate', $startdt, $enddt);
} else {
$rowset = $tblUser->fetchUser("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_corporate', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_corporate', $startdt, $enddt);
}
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
// sent email confirm -7 days
// $formater->_writeConfirmAkunHabis($row->guid, 'panel');
// check if days > 0
/*
if ($row->DaysLeft > 0)
{
$formater->downgrade($row->guid);
}
*/
//$a['user'][$i]['guid'] = $row->guid;
$a['user'][$i]['kopel'] = $row->kopel;
$a['user'][$i]['fullName'] = $row->fullName;
$a['user'][$i]['username'] = $row->username;
$a['user'][$i]['email'] = !empty($row->email) ? $row->email : '-';
$a['user'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['user'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date_english($row->createdDate);
$a['user'][$i]['expirationDate'] = $row->expirationDate ? Pandamp_Lib_Formater::get_date_english($row->expirationDate) : '-';
$a['user'][$i]['paymentId'] = $row->paymentId;
$a['user'][$i]['DaysLeft'] = $row->isPaid == "Y" ? "-" : $row->DaysLeft;
$a['user'][$i]['value'] = $row->packageId;
$a['user'][$i]['packageId'] = $row->value;
$a['user'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['user'][$i]['isEmailSent'] = $row->isEmailSent;
$a['user'][$i]['isEmailSentOver'] = $row->isEmailSentOver;
$a['user'][$i]['isActive'] = $row->isActive;
$a['user'][$i]['isContact'] = $row->isContact;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['user'][0]['guid'] = 'No Data';
}
break;
case 'member_individual':
$rowset = $tblUser->fetchUser("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_individual', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_individual', $startdt, $enddt);
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
// sent email confirm -7 days
// $formater->_writeConfirmAkunHabis($row->guid, 'panel');
// check if days > 0
/*
if ($row->DaysLeft > 0)
{
$formater->downgrade($row->guid);
}
*/
//$a['user'][$i]['guid'] = $row->guid;
$a['user'][$i]['kopel'] = $row->kopel;
$a['user'][$i]['fullName'] = $row->fullName;
$a['user'][$i]['username'] = $row->username;
$a['user'][$i]['email'] = !empty($row->email) ? $row->email : '-';
$a['user'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['user'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date_english($row->createdDate);
$a['user'][$i]['expirationDate'] = $row->expirationDate ? Pandamp_Lib_Formater::get_date_english($row->expirationDate) : '-';
$a['user'][$i]['paymentId'] = $row->paymentId;
$a['user'][$i]['DaysLeft'] = $row->isPaid == "Y" ? "-" : $row->DaysLeft;
$a['user'][$i]['value'] = $row->packageId;
$a['user'][$i]['packageId'] = $row->value;
$a['user'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['user'][$i]['isEmailSent'] = $row->isEmailSent;
$a['user'][$i]['isEmailSentOver'] = $row->isEmailSentOver;
$a['user'][$i]['isActive'] = $row->isActive;
$a['user'][$i]['isContact'] = $row->isContact;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['user'][0]['guid'] = 'No Data';
$a['user'][0]['DaysLeft'] = '-';
$a['user'][0]['isEmailSent'] = '';
$a['user'][0]['isEmailSentOver'] = '';
$a['user'][0]['isActive'] = '';
$a['user'][0]['isContact'] = 'N';
}
break;
case 'member_bonus':
if ($startdt && $enddt) {
$rowset = $tblUser->fetchUser("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_bonus', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_bonus', $startdt, $enddt);
} else {
$rowset = $tblUser->fetchUser("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows, 'member_bonus', $startdt, $enddt);
$a['totalCount'] = $tblUser->countUserGroup('member_bonus', $startdt, $enddt);
}
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
// sent email confirm -7 days
// $formater->_writeConfirmAkunHabis($row->guid, 'panel');
// check if days > 0
/*
if ($row->DaysLeft > 0)
{
$formater->downgrade($row->guid);
}
*/
//$a['user'][$i]['guid'] = $row->guid;
$a['user'][$i]['kopel'] = $row->kopel;
$a['user'][$i]['fullName'] = $row->fullName;
$a['user'][$i]['username'] = $row->username;
$a['user'][$i]['email'] = !empty($row->email) ? $row->email : '-';
$a['user'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['user'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date_english($row->createdDate);
$a['user'][$i]['expirationDate'] = $row->expirationDate ? Pandamp_Lib_Formater::get_date_english($row->expirationDate) : '-';
$a['user'][$i]['paymentId'] = $row->paymentId;
$a['user'][$i]['DaysLeft'] = $row->isPaid == "Y" ? "-" : $row->DaysLeft;
$a['user'][$i]['value'] = $row->packageId;
$a['user'][$i]['packageId'] = $row->value;
$a['user'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['user'][$i]['isEmailSent'] = $row->isEmailSent;
$a['user'][$i]['isEmailSentOver'] = $row->isEmailSentOver;
$a['user'][$i]['isActive'] = $row->isActive;
$a['user'][$i]['isContact'] = $row->isContact;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['user'][0]['guid'] = 'No Data';
}
break;
case 'others':
$rowset = $tblUser->fetchUserGroupOther("{$sortBy} {$sortDir}", $start, $end, $rowval, $selectedRows);
$a['totalCount'] = $tblUser->countUserGroupOther();
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
//$a['user'][$i]['guid'] = $row->guid;
$a['user'][$i]['kopel'] = $row->kopel;
$a['user'][$i]['fullName'] = $row->fullName;
$a['user'][$i]['email'] = !empty($row->email) ? $row->email : '-';
$a['user'][$i]['username'] = $row->username;
$a['user'][$i]['company'] = !empty($row->company) ? $row->company : '-';
$a['user'][$i]['createdDate'] = Pandamp_Lib_Formater::get_date($row->createdDate);
$a['user'][$i]['value'] = $row->packageId;
$a['user'][$i]['packageId'] = $row->value;
$a['user'][$i]['periodeId'] = $row->status ? $row->status : "unknown";
$a['user'][$i]['isEmailSent'] = $row->isEmailSent;
$a['user'][$i]['isEmailSentOver'] = $row->isEmailSentOver;
$a['user'][$i]['isActive'] = $row->isActive;
$a['user'][$i]['isContact'] = $row->isContact;
$i++;
}
}
if ($a['totalCount'] == 0) {
$a['user'][0]['guid'] = 'No Data';
}
break;
}
echo Zend_Json::encode($a);
}
