function getDataAll($user_id, $from_date, $to_date)
{
$cur_mod = new Application_Model_DbTable_DbCurrencies();
$usr_mod = new Application_Model_DbTable_DbUsers();
$rsCur = $cur_mod->getCurrencyList();
$rsUser = null;
$tmp_summary = null;
$return_araray = array();
if ($user_id == -1) {
$rsUser = $usr_mod->getUserListSelect();
if (!empty($rsCur)) {
$tmp_summary = array();
foreach ($rsCur as $k => $rc) {
$cur_type = $rc['symbol'];
$bought = $this->sumValue($cur_type, null, "in", $from_date, $to_date);
$sale = $this->sumValue($cur_type, null, "out", $from_date, $to_date);
$tmp_summary[$k]['saleamount'] = $sale;
$tmp_summary[$k]['boughtamount'] = $bought;
$tmp_summary[$k]['currncytype'] = $rc['name'];
$tmp_summary[$k]['currncysymbol'] = $cur_type;
}
$return_araray['summary'] = $tmp_summary;
}
} else {
$rsUser = $usr_mod->getUserInfoByfetchAll($user_id);
}
//print_r($return_araray); exit();
if (!empty($rsUser)) {
$tmp_data = array();
$row_index = 0;
foreach ($rsUser as $i => $ru) {
if (empty($rsCur)) {
break;
}
foreach ($rsCur as $k => $rc) {
$cur_type = $rc['symbol'];
$bought = $this->sumValue($cur_type, $ru['id'], "in", $from_date, $to_date);
$sale = $this->sumValue($cur_type, $ru['id'], "out", $from_date, $to_date);
if ($bought != 0 || $sale != 0) {
$tmp_data[$row_index]['username'] = $ru['name'];
$tmp_data[$row_index]['userid'] = $ru['id'];
$tmp_data[$row_index]['saleamount'] = $sale;
$tmp_data[$row_index]['boughtamount'] = $bought;
$tmp_data[$row_index]['currncytype'] = $rc['name'];
$tmp_data[$row_index]['currncysymbol'] = $cur_type;
$row_index++;
}
}
}
if (!empty($tmp_data)) {
$return_araray['data'] = $tmp_data;
}
}
return $return_araray;
}