public function showTransaction()
{
$transactions = Transaction::from('transactions AS t')->join('agents AS a', DB::raw('a.id'), '=', DB::raw('t.agent_id'))->join('senders AS s', 's.id', '=', 't.sender_id')->join('sender_indentifications AS si', 'si.sender_id', '=', "t.sender_id")->join('beneficiaries AS b', 'b.id', '=', 't.beneficiary_id')->join('beneficiary_service_centers AS bsc', 'bsc.id', '=', 't.beneficiary_service_center_id')->join('service_modes AS sm', 'sm.id', '=', 'bsc.service_mode_id')->join('service_centers AS sc', 'sc.id', '=', 'bsc.service_center_id')->select('t.*', 'bsc.*', 'sm.*', 'sc.*', 's.fname AS s_fname', 's.mname AS s_mname', 's.lname AS s_lname', 's.gender AS s_gender', 's.bday AS s_bday', 's.place_of_birth AS s_place_of_birth', 's.contact_no AS s_contact_no', 's.citizenship AS s_citizenship', 's.residency AS s_contact_no', 's.country AS s_country', 's.address AS s_address', 's.address_ph AS s_address_ph', 's.suburb AS s_suburb', 's.state AS s_state', 's.post_code AS s_post_code', 's.occupation AS s_occupation', 's.source_of_inc AS s_source_of_inc', 'b.fname AS b_fname', 'b.mname AS b_mname', 'b.lname AS b_lname', 'b.gender AS b_gender', 'b.address AS b_address', 'b.contact_no AS b_contact_no', 'b.civil_status AS b_civi_status', 'b.relationship AS b_relationship', 'a.business_name AS a_business_name', 'a.agent_code AS a_agent_code', 't.created_at AS t_cdate', 'si.type AS si_type')->get()->take(5);
//->first();
/*$transaction = DB
::table('transactions AS t')
->join('agents AS a','a.id','=','t.agent_id')
->join('senders AS s','s.id','=','t.sender_id')
->join('beneficiaries AS b','b.id','=','t.beneficiary_id')
->join('service_modes AS sm','sm.id','=','t.service_mode_id')
->join('service_centers AS sc','sm.id','=','t.service_center_id')
->where('tracking_no','=','123456')
->select('t.*','s.*','b.*','sm.*','sc.*')
->get();*/
return response()->success(compact('transactions'));
}
