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); }