public function insert_posts($post_detail)
{
$Evebidpost = new Evebid();
$date1 = $post_detail['post_time'];
$date = str_replace('.', '-', $date1);
$post_id = $Evebidpost->where('post_id', $post_detail['post_id'])->pluck('id');
if (empty($post_detail)) {
return false;
}
if (!empty($post_id)) {
echo "<br>";
$row = $Evebidpost->find($post_id);
if ($row->lastpost_time == date('Y-m-d H:i:s', strtotime($date))) {
echo "Already Updated";
return true;
}
return;
}
$Evebidpost->threadid = $post_detail['threadid'];
$Evebidpost->post_id = trim(strip_tags($post_detail['post_id']));
$Evebidpost->bid_id = trim(strip_tags($post_detail['bid_id']));
$Evebidpost->char_id = trim(strip_tags($post_detail['char_id']));
$Evebidpost->post_rank = trim(strip_tags($post_detail['post_rank']));
$Evebidpost->post_time = trim(strip_tags($post_detail['post_time']));
$Evebidpost->profile_link = trim(strip_tags($post_detail['profile_link']));
$Evebidpost->username = trim(strip_tags($post_detail['username']));
$Evebidpost->wall_post = trim($post_detail['wall_post']);
$Evebidpost->update_time = date('Y-m-d H:i:s');
echo "<br>";
echo "Inserted";
$save_Eveapi = $Evebidpost->save();
return $save_Eveapi;
}
function bidNow(Request $request)
{
if (!Auth::check()) {
return Redirect::to('/login');
}
if ($request->isMethod('post')) {
$rules = array('bid_am' => 'required|numeric', 'post_message' => 'required');
$id = Auth::user()->id;
$characters = Character::join('character_profile', function ($j) {
$j->on('characters.char_id', '=', 'character_profile.char_id');
//->where('bid_posts.post_rank',"=",1);
})->where('characters.uid', "=", $id)->where('characters.status', '=', 1)->orderBy('characters.id', 'asc')->get()->take(1);
foreach ($characters as $char) {
$charname = $char['username'];
$charid = $char['char_id'];
}
$post_message = trim($request->get('post_message'));
$bid_am = trim($request->get('bid_am'));
$bid_id = trim($request->get('bid_id'));
$bid_post_detail = Evebid::where('bid_id', $bid_id)->orderBy('post_rank', 'desc')->take(1)->get();
foreach ($bid_post_detail as $dt) {
$post_rank = $dt['post_rank'];
}
$bid_detail = Eveapi::where('id', $bid_id)->first();
if (!empty($bid_detail)) {
$bid_detail->topicreplies = $bid_detail['topicreplies'] + 1;
$bid_detail->save();
}
$post_thread = new Evebid();
$post_thread->bid_id = $bid_id;
$post_thread->char_id = $charid;
$post_thread->post_rank = $post_rank + 1;
$post_thread->post_time = Carbon::now();
$post_thread->update_time = Carbon::now();
$post_thread->wall_post = $post_message;
$post_thread->profile_link = $charid . "_128.jpg";
$post_thread->username = $charname;
$post_thread->bid_amount = $bid_am;
$post_thread->save();
return Redirect::to('bazaar/' . $bid_id);
}
}
