public static function appInfo($appID)
{
$catData = Claims_App::left_join('data_claims_cat AS c', 'claims.claimscat', '=', 'c.claimcatid')->where('claimid', '=', $appID)->left_join('flows_steps AS s', 'claims.status', '=', 's.stepid')->first(array('s.step', 'c.claims_cat_name', 'claims.*'));
$data['category'] = $catData->claims_cat_name;
$data['refno'] = $catData->claimsref;
$data['applydate'] = date('d/m/Y H:m:s', strtotime($catData->created_at));
$data['applymonth'] = $catData->applymonth;
$data['status'] = $catData->step;
return $data;
}
public function get_history()
{
$data['claimlist'] = Claims_App::listIndClaimsHistory();
return View::make('claims.request.history', $data);
}