public function getMemberTransactionToday()
{
$member_id = Input::get("member_id");
$today = date('Y-m-d', strtotime('now'));
$transactions = Transaction::join("members", 'members.member_id', '=', 'transactions.member_id')->select("transactions.id", "transactions.member_id", "transactions.amount", "transactions.balance", "transactions.service", "transactions.created_at", "members.first_name", "members.last_name")->where('members.member_id', '=', $member_id)->whereBetween('transactions.created_at', array(Carbon::now()->yesterday()->endOfDay(), Carbon::now()->endOfDay()))->get();
$data = array();
foreach ($transactions as $transaction) {
# code...
$transaction_data = array();
$date = date("Y-m-d", strtotime($transaction->created_at));
array_push($transaction_data, $transaction->id);
array_push($transaction_data, $transaction->member_id);
array_push($transaction_data, $transaction->last_name);
array_push($transaction_data, $transaction->first_name);
array_push($transaction_data, $transaction->amount);
array_push($transaction_data, $transaction->balance);
array_push($transaction_data, $transaction->service);
array_push($transaction_data, $date);
$data[] = $transaction_data;
}
$returner = array('data' => $data);
echo json_encode($returner);
}
