function execute()
{
$return = new stdClass();
$params = Request::_REQUEST();
Config::set("HideDebugger", true);
$users = DBObject::collection("Member", DBObject::CONSISTENCY_ABSOLUTE);
$fullCount = $users->getMemberCount();
$users = DBObject::collection("Member", DBObject::CONSISTENCY_ABSOLUTE);
$users->setRange($params["iDisplayStart"], $params["iDisplayLength"]);
switch ($params["iSortCol_0"]) {
case 0:
$users->applySort("AutoID", $params["sSortDir_0"]);
break;
case 1:
$users->applySort("userFirstname", $params["sSortDir_0"]);
break;
case 2:
$users->applySort("userLastname", $params["sSortDir_0"]);
break;
case 3:
$users->applySort("useremail", $params["sSortDir_0"]);
break;
case 4:
$users->applySort("level", $params["sSortDir_0"]);
break;
case 5:
$users->applySort("is_enabled", $params["sSortDir_0"]);
break;
}
$return = array("sEcho" => $params["sEcho"], "iTotalRecords" => $fullCount, "iTotalDisplayRecords" => $fullCount, "aaData" => array());
foreach ($users->getMembers() as $_user) {
$row = array();
$row[] = $_user->getID();
$row[] = $_user->getUserFirstname();
$row[] = $_user->getUserLastname();
$row[] = $_user->getUserEmail();
$row[] = $_user->getLevel();
$row[] = $_user->getIsEnabled();
$row[] = $_user->getLastLogin();
$row[] = "<a onclick=\"editUser(this, '" . $_user->getID() . "');\"><span class=\"ui-icon ui-icon-wrench\"></span></a><a onclick=\"deleteUser(this, '" . $_user->getID() . "');\"><span class=\"ui-icon ui-icon-trash\"></span></a>";
$return["aaData"][] = $row;
}
echo json_encode($return);
return;
}
public function activate()
{
$this->setPageData('header/title', 'Users');
$this->setPageView('admin/AdminPage');
$this->setBodyView('admin/body/Users');
$this->addPageData('header/meta', array('description' => 'Passing Green :: Administration :: Users'));
$this->addPageData('header/assets/js', array('/admin-new/js/user.js'));
$business_categories = DBObject::collection('BusinessCategory', DBObject::CONSISTENCY_ABSOLUTE);
$business_categories->applySort("category");
$countries = DBObject::collection('Country', DBObject::CONSISTENCY_ABSOLUTE);
$countries->applySort("country");
$provinces = DBObject::collection('Province', DBObject::CONSISTENCY_ABSOLUTE);
$provinces->applySort("name");
$this->addPageData('body/UserEditForm/business_categories', $business_categories->getBusinessCategories());
$this->addPageData('body/UserEditForm/countries', $countries->getCountries());
$this->addPageData('body/UserEditForm/provinces', $provinces->getProvinces());
$this->loadPage();
}
function execute()
{
$return = new stdClass();
$params = Request::_REQUEST();
Config::set("HideDebugger", true);
//comment this out to debug
if (isset($params["id"])) {
$user = new Member($params["id"]);
if (isset($user) && $user->isValid()) {
// retrieve account balance based on transactions
$user_balance = 0.0;
$user_commission = 0.0;
/* $Referral_Join = DBObject::collection("Referral");
$Member_Join = DBObject::collection("Member");
$Member_Vendor_Join = DBObject::collection("Member");
$Transactions = DBObject::collection("Transaction")
->applyJoin("LEFT OUTER", $Referral_Join, array("ReferralID", "AutoID"))
->applyJoin("LEFT OUTER", $Member_Join, array("UserID", "AutoID"))
->applyJoin("LEFT OUTER", $Member_Vendor_Join, array("VendorID", "AutoID"))
->applyUserIDFilter($user->getID());
Debugger::log(Var_Dump::display($Transactions->getTransactions(), true));
*/
$q = "SELECT\n\t\t\t\tt.`amount`,\n\t\t\t\tr.*,\n\t\t\t\tCONCAT(user.`userFirstname`, CONCAT(' ',user.`userLastname`)) as _from,\n\t\t\t\tCONCAT(vendor.`userFirstname`, CONCAT(' ',vendor.`userLastname`)) as _to\n\t\t\tFROM `transactions` t\n\n\t\t\tLEFT OUTER JOIN `referrals` r\n\t\t\t\tON (t.`ReferralID` = r.`AutoID`)\n\n\t\t\tLEFT OUTER JOIN `user_signup` user\n\t\t\t\tON (r.`UserID` = user.`AutoID`)\n\n\t\t\tLEFT OUTER JOIN `user_signup` vendor\n\t\t\t\tON (r.`VendorID` = vendor.`AutoID`)\n\n\t\t\tWHERE t.`UserID` ='" . $user->getID() . "'";
$user_transactions = DatabaseFactory::passinggreen_db()->query($q);
Debugger::log(Var_Dump::display($user_transactions, true));
while ($user_transactions_row = $user_transactions->fetch_object()) {
if ($user_transactions_row->UserID == $user->getID()) {
$user_balance += $user_transactions_row->amount;
//$referrals_passed[] = $row;
} else {
if ($user_transactions_row->VendorID == $user->getID()) {
$user_commission += $user_transactions_row->amount;
//$referrals_received[] = $row;
}
}
#else
#echo "PG.com +".$row->amount."<br>";
#echo "<pre>".print_r($row, true)."</pre>";
}
// referrals
$user_referrals_passed = DBObject::collection("Referral", DBObject::CONSISTENCY_ABSOLUTE)->applyUserIDFilter($user->getID())->getReferralCount();
$user_referrals_received = DBObject::collection("Referral", DBObject::CONSISTENCY_ABSOLUTE)->applyVendorIDFilter($user->getID())->getReferralCount();
Debugger::log("refs passed: {$user_referrals_passed}");
Debugger::log("refs recvd: {$user_referrals_received}");
// decrypt cc field if it is not empty
$user_crypt_key = CryptKey::findCryptKeyByUserID($user->getID());
if (isset($user_crypt_key) && $user_crypt_key->isValid()) {
Debugger::log("User crypt private key: " . $user_crypt_key->getKey());
$decoded_cc_data = unserialize(TwoWayEncryption::decrypt($user->getCC(), $user_crypt_key->getKey()));
} else {
$decoded_cc_data = null;
}
$return->id = $user->getID();
// object id
$return->user = $user->toArray();
// set the base return, values can be overridden below.
$return->user["userCompanyType[]"] = $user->getUserCompanyType();
$return->user["siteAreas[]"] = $user->getSiteAreas();
$return->user["passwd"] = null;
$return->user["balance"] = number_format($user_balance, 2);
if (!is_null($decoded_cc_data)) {
$return->user["ccc"] = $decoded_cc_data["details"];
$return->user["ccc_status"] = $decoded_cc_data["status"];
$return->user["ccc_tcode"] = $decoded_cc_data["tcode"];
$return->user["ccc_name"] = $decoded_cc_data["name"];
$return->user["ccc_ccNum"] = $decoded_cc_data["ccNum"];
$return->user["ccc_MM"] = $decoded_cc_data["MM"];
$return->user["ccc_YY"] = $decoded_cc_data["YY"];
$return->user["ccc_ccCode"] = $decoded_cc_data["ccCODE"];
}
$return->user["referralsPassed"] = $user_referrals_passed;
$return->user["referralsReceived"] = $user_referrals_received;
$return->user["accountBalance"] = number_format($user_balance, 2);
$return->user["commissionDue"] = number_format($user_commission, 2);
echo json_encode($return);
return;
} else {
$return->error = "ID is invalid.";
echo json_encode($return);
return;
}
} else {
$return->error = "Missing ID!";
echo json_encode($return);
return;
}
}
