public static function bid($attributes = array(), $project_id = false)
{
$faker = Faker\Factory::create();
$p = $project_id ? Project::find($project_id) : Project::where_not_null('posted_to_fbo_at')->order_by(\DB::raw('RAND()'))->first();
$v = Vendor::order_by(\DB::raw('RAND()'))->first();
$prices = array();
foreach (array_keys($p->deliverables) as $d) {
$prices[$d] = rand(100, 10000);
}
$b = new Bid(array('project_id' => $p->id, 'approach' => $faker->paragraph, 'previous_work' => $faker->paragraph, 'employee_details' => "Adam Becker\n" . "Craig Collyer", 'prices' => $prices));
$b->starred = rand(0, 1);
$b->vendor_id = $v->id;
$b->save();
if (rand(0, 6) === 0) {
$b->delete_by_vendor();
} else {
if (rand(0, 1) === 0) {
$submitted_at = new \DateTime();
$b->submitted_at = rand(0, 1) === 0 ? $submitted_at : null;
$b->submit();
// Dismiss 1/3 of the bids
if (rand(0, 2) === 0) {
$b->dismiss(Bid::$dismissal_reasons[array_rand(Bid::$default_dismissal_reasons)], $faker->paragraph(2));
// Un-dismiss 1/2 of these
if (rand(0, 1) === 0) {
$b->undismiss();
}
}
}
}
}
public function action_index()
{
$view = View::make('reports.index');
$all_days = array();
$date = new \DateTime();
$date->setTimestamp(1358488800);
# 1/18/2013
// $date->setTimestamp(1354320000); # 12/17/2013
while ($date < new \DateTime()) {
array_push($all_days, $date->format("Y-m-d"));
$date = $date->modify("+1 day");
}
$signups = array();
foreach (DB::query("SELECT COUNT(*) as count, DATE(created_at) as date FROM vendors GROUP BY DATE(created_at)") as $result) {
$signups[$result->date] = $result->count;
}
$signups_per_day = array();
$signups_per_day_flat = array();
foreach ($all_days as $day) {
$signups_per_day_flat[] = $signups_per_day[$day] = intval(@$signups[$day]) ?: 0;
}
$signups = array();
foreach (DB::query("SELECT DATE(created_at) as date, duns FROM vendors") as $result) {
if (!isset($signups[$result->date])) {
$signups[$result->date] = array('new' => 0, 'old' => 0);
}
if ($result->duns) {
$signups[$result->date]['old']++;
} else {
$signups[$result->date]['new']++;
}
}
$num_signups = 0;
$num_new = 0;
$new_to_contracting = array();
foreach ($all_days as $day) {
if (isset($signups[$day])) {
$num_signups += $signups[$day]['new'];
$num_signups += $signups[$day]['old'];
$num_new += $signups[$day]['new'];
}
$new_to_contracting[$day] = $num_signups == 0 ? 0 : $num_new / $num_signups;
}
$total_projects = 0;
$total_bids = 0;
$bids_per_project = array();
foreach (DB::query("SELECT id, title, (SELECT COUNT(*) from bids where project_id = projects.id AND deleted_at IS NULL AND submitted_at IS NOT NULL) as bids from projects WHERE projects.posted_to_fbo_at IS NOT NULL") as $result) {
array_push($bids_per_project, array('project_id' => $result->id, 'project_title' => $result->title, 'num_bids' => $result->bids));
$total_projects++;
$total_bids += $result->bids;
}
$avg_bids_per_project = $total_bids / $total_projects;
$total_price_for_all = 0;
$total_bids_in_all = 0;
$total_prices = array();
foreach (Bid::where_not_null('submitted_at')->get() as $bid) {
if (!isset($total_prices[$bid->project_id])) {
$total_prices[$bid->project_id] = array('num_bids' => 0, 'total_price' => 0);
}
$total_prices[$bid->project_id]['num_bids']++;
$total_prices[$bid->project_id]['total_price'] += $bid->total_price_integer();
$total_bids_in_all++;
$total_price_for_all += $bid->total_price_integer();
}
$avg_prices = array();
foreach (Project::where_not_null('posted_to_fbo_at')->get() as $project) {
array_push($avg_prices, array('project_id' => $project->id, 'project_title' => $project->title, 'avg_price' => isset($total_prices[$project->id]) ? $total_prices[$project->id]['total_price'] / $total_prices[$project->id]['num_bids'] : 0));
}
$avg_price_total = $total_price_for_all / $total_bids_in_all;
$view->total_signups = $num_signups;
$view->total_new_to_contracting = $num_new;
$view->signups_per_day = $signups_per_day;
$view->signups_per_day_flat = $signups_per_day_flat;
$view->new_to_contracting = $new_to_contracting;
$view->bids_per_project = $bids_per_project;
$view->avg_bids_per_project = $avg_bids_per_project;
$view->avg_prices = $avg_prices;
$view->avg_price_total = $avg_price_total;
$this->layout->content = $view;
}
