function postPitches()
{
$selectPhrase = 'pitches.id, balls, strikes, outs, man_on_first, man_on_second, man_on_third, inning, side, visiting_team_current_runs vscore, home_team_current_runs hscore, visitor, home, batted_ball_angle, batted_ball_distance, (unix_timestamp(game_date)-(6*60*60))*1000 game_date, atbat_desc, px x, pz y, szt, szb, pa_result_id, pitch_results.ball, pitch_results.strike, pitch_results.description pitch_desc, plate_appearance_results.atbat, plate_appearance_results.hit, plate_appearance_results.onbase, plate_appearance_results.bases, plate_appearance_results.description pa_desc, pitch_types.description pitch_type, batter.name batter_name, pitches.batter_id, pitcher.name pitcher_name, pitches.pitcher_id, concat(game_string, \'-\', batter_id, \'-\', pitcher_id, \'-\', times_faced) abslug';
if (Input::has('slug') && Input::has('id')) {
$subquery = " (select * from pitches where id between (? - 30) and (? + 30)) ";
$from = " from " . $subquery . " pitches \n left join pitch_results on pitch_results.id = pitches.pitch_result_id \n left join pitch_types on pitch_types.id = pitches.pitch_type_id \n left join plate_appearance_results on plate_appearance_results.id = pitches.pa_result_id \n left join players as pitcher on pitcher.id = pitches.pitcher_id \n left join players as batter on batter.id = pitches.batter_id";
$where = " where concat(game_string, '-', batter_id, '-', pitcher_id, '-', times_faced) = ? order by `pitches`.`id` asc;";
$query = "select " . $selectPhrase . $from . $where;
$pitches = DB::select(DB::raw($query), array(Input::get('id'), Input::get('id'), Input::get('slug')));
return array('view' => 'ab', 'items' => $pitches, 'total_count' => count($pitches));
}
if (!Input::has('batter_id') && !Input::has('pitcher_id')) {
return array('error_code' => 406, 'message' => 'Please include either a batter or a pitcher (or both)');
}
if (!Input::has('pitch_types')) {
return array('error_code' => 406, 'message' => 'Please select at least one pitch type. Come on.');
}
if (!Input::has('pitch_results')) {
return array('error_code' => 406, 'message' => 'Please select at least one pitch result type. Come on.');
}
if (!Input::has('plate_appearance_results')) {
return array('error_code' => 406, 'message' => 'Please select at least one plate appearance result type. Come on.');
}
$pitch_types = array();
foreach (Input::get('pitch_types') as $pt) {
$pitch_types[] = $pt['id'];
}
$pitch_results = array();
foreach (Input::get('pitch_results') as $pt) {
$pitch_results[] = $pt['id'];
}
$plate_appearance_results = array();
foreach (Input::get('plate_appearance_results') as $pt) {
$plate_appearance_results[] = $pt['id'];
}
$all_pa_results_count = PlateAppearanceResult::count();
$pitches = Pitch::whereIn('pitch_type_id', $pitch_types)->whereIn('pitch_result_id', $pitch_results);
if (count($plate_appearance_results) < $all_pa_results_count) {
$pitches = $pitches->whereIn('pa_result_id', $plate_appearance_results);
}
if (Input::has('batter_id')) {
$pitches = $pitches->where('batter_id', Input::get('batter_id'));
}
if (Input::has('pitcher_id')) {
$pitches = $pitches->where('pitcher_id', Input::get('pitcher_id'));
}
if (Input::has('showBalls') && Input::get('showBalls') == '0') {
$pitches = $pitches->where(function ($query) {
$query->where('pitch_results.ball', 0);
$query->orWhere('plate_appearance_results.description', '<>', '');
});
}
if (Input::has('showStrikes') && Input::get('showStrikes') == '0') {
$pitches = $pitches->where(function ($query) {
$query->where('pitch_results.strike', 0);
$query->orWhere('plate_appearance_results.description', '<>', '');
});
}
if (Input::has('showInPlay') && Input::get('showInPlay') == '0') {
$pitches = $pitches->where('plate_appearance_results.description', '');
}
if (!(Input::get('show2013') == '1' && Input::get('show2014') == '1' && Input::get('show2015') == '1')) {
$show2013 = Input::get('show2013');
$show2014 = Input::get('show2014');
$show2015 = Input::get('show2015');
$pitches = $pitches->where(function ($query) use($show2013, $show2014, $show2015) {
if ($show2013 == '1') {
$query->orWhereBetween('game_date', array('2013-1-1', '2014-1-1'));
}
if ($show2014 == '1') {
$query->orWhereBetween('game_date', array('2014-1-1', '2015-1-1'));
}
if ($show2015 == '1') {
$query->orWhereBetween('game_date', array('2015-1-1', '2016-1-1'));
}
});
}
$pitches = $pitches->leftJoin('pitch_results', 'pitch_results.id', '=', 'pitches.pitch_result_id')->leftJoin('pitch_types', 'pitch_types.id', '=', 'pitches.pitch_type_id')->leftJoin('plate_appearance_results', 'plate_appearance_results.id', '=', 'pitches.pa_result_id')->leftJoin('players as pitcher', 'pitcher.id', '=', 'pitches.pitcher_id')->leftJoin('players as batter', 'batter.id', '=', 'pitches.batter_id')->selectRaw($selectPhrase)->orderBy('pitches.id')->take(1000)->get();
return array('items' => $pitches, 'total_count' => count($pitches));
}
