GV statistics

**kalastaja** · 26 Jan 2017, 05:34 PM

How do I get current status of all customers GV accounts? I need to know how much I'm in for.

**Ajeh** · 27 Jan 2017, 05:28 PM

In your Zen Cart Admin, go to Customers ... Customers ... and all GV balances are listed there for your customers ...

**kalastaja** · 27 Jan 2017, 07:48 PM

Correct answer, but not helpful, as it would require me to manually count each value to be able to know "how much I'm in for".

**DrByte** · 27 Jan 2017, 09:02 PM

Around line 98 of /admin/index.php you have:

Code:

  echo '<div class="row"><span class="left">' . BOX_ENTRY_SALEMAKER_ACTIVE . '</span><span class="rigth"> ' . $salemaker_act->fields['count']. '</span></div>';

Add the following after it:

Code:

  $gvresult = $db->Execute("SELECT sum(amount) as gvsum FROM " . TABLE_COUPON_GV_CUSTOMER);
  if ($gvresult->RecordCount()) {
  	  require(DIR_WS_CLASSES . 'currencies.php');
	  $currencies = new currencies();
      echo '<div class="row"><span class="left">' . 'GV Queue Balance' . '</span><span class="rigth"> ' . $currencies->format($gvresult->fields['gvsum']) . '</span></div>';
  }

Now the amount will show on your admin home page.